[trilOByte]

...showing *only* thier high score.

I think I've worked it out myself. This should list users in order ofg their high dcore on the leaderboard, but list them only once, allowing lower scoring users a foot on the leaderboard....

find *both* instances of...

PHP Code:

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


and replace them *both* with.....

PHP Code:

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


Oh yeah, this also increases the displayed users from 10 to 30.

Thanks.