Teenage Mutant Ninja Turtles
released on March 06, 2026!

Order now on CardKingdom Order now on TcgPlayer

Teenage Mutant Ninja Turtles
released on March 06, 2026!

Order now on CardKingdom Order now on TcgPlayer
2 total results       Page 1 of 1
You must login or register to post a new reply
Posts [ 1 to 2 ]
Trade score 0 (100%)
Members
Registered: 02-Feb-2014 15:14
When viewing all users for a certain geographic area it'd be cool if you could sort by parameters like "total value of inventory" or "total cards in inventory".

Doing something like this wouldn't be very efficient:

SELECT username, totalValue
FROM (
    SELECT username, SUM(value) AS totalValue
    FROM users
    JOIN cards ON cards.user_id = users.user_id
    WHERE location = 'Texas, USA'
    GROUP BY username
)
ORDER BY totalValue

But maybe there could be a total value column and a total cards column in the users table. The total cards column would be updated every time a card was added or removed and the total value column could be updated every time someone clicked the "Show Value" button on a particular inventory.
Trade score 146 (100%)
Members
Registered: 28-Oct-2013 02:12
That would be terribad. People are already begging for a privacy option, this just screams like a mechanism for thieves to identify targets.
Posts [ 1 to 2 ]
2 total results       Page 1 of 1
You must login or register to post a new reply