Chaim wrote:So how would you do it?
I think offering cards that are looked at is fine, but you should compare them to cards in the trade list first. In other words assuming that the data (cardName or cardIDNumber) is stored in a table something like this?
SELECT cardName
FROM lookedAtRecently
WHERE cardName NOT IN
(SELECT cardName
FROM tradeList)
And of course put a limit (maybe 30 or so) so you're not pulling way more data than you need. Then you can pick a random one from this array so that you're not showing the last card looked at. In the event that you get a null set on that maybe something random from top cards?
It's also now showing me my own cards for sale as I just went through a bunch of blue commons and added them. That's cool I guess, maybe it means other people will see my listings too.
Last edited by gumgodMTG (2014-10-11 13:35:57)