What is wrong with doing a store with the tetris one?

I was waiting for that one. I had my hopes up for that great hack. I would do anything to see that hack.

Why did u change ur mind and deside not to do it?

F it. It's not that important.

I just thought people would prefer a store add on for the arcade hack, with more games - rather than just the tetris hack.

If there's enough demand, I'll do both.

k :D

If you enable "Record highest scores only" from the start, you essentially get the same thing.

I can look @ it if you want, pm me the problem.

I'll post the main issue here, so everyone can have a go.

Basically, I need a SQL query that will select the highest score each userid has, and output the records.

So:
1. There's only one record per userid value
2. And the score value that corresponds to the userid is the highest one.

I suppose you could do it the server intensive way by having it go through each member, check if they have a score, and if so get the the highest one. But that might cause problems with bigger boards.

Already thought of that, it would be VERY server intensive

Then you could just go through the inputted scores, set the score it gets to a variable and just compare it every time it finds another score by that user. If the score it found is bigger than the one in the variable, it replaces it.

I can get you the code for this if you want, but I'll need your table structure.

No news on why my screen is stuck on loading...? :(

http://nba2k3.net/forum/tetris.php