[trilOByte]

With regard to making *only* each users best score show up on the leaderboard......

Originally posted by futureal


This can be done. Here's an example:

http://www.shadowsofnamek.com/forum/...game=tetris&s=

Or another, from a different game:

http://www.shadowsofnamek.com/forum/...me=breakout&s=

Only each user's best score is shown. To accomplish this, you need to alter the query used in tetris.php for the "leaderboard" action.

From the original tetris.php file, you will want to replace this:

PHP Code:

$leaderboard_q = $DB_site->query("SELECT * FROM arcade WHERE game='tetris' ORDER BY score DESC LIMIT 10"); 


with this:

PHP Code:

  $leaderboard_q = $DB_site->query("SELECT game,userid,comment,max(score) as maxscore
                                    FROM arcade
                                    WHERE game='tetris'
                                    GROUP BY userid
                                    ORDER BY maxscore DESC
                                    LIMIT 10"); 


That should achieve the result you're looking for.

Well I tried this, but no luck I'm afraid. There are two instances of the code you said to look for. When I replaced both instances with your replacement code, it did list the users only once, but i lost the comments and the actual score.

I think this is very close, but i dont know enough about drawing info from SQL DB's to work it out myself - any ideas anyone?

Thanks.