Best Score will not remove from main page

[syrus.xl]

Hi again,

I recently banned a user from my site, and wanted to remove all of his scores, well it removed them from all games he had played.

But I'm left with an arcade that contradicts itselfs regarding Best Scores on any game that he achieved a best score.

If the game scores are viewed from the actual game, his nick is not there - which is correct. However, if the scores are viewed from the main arcade index page, his name is still there.

I've tried all the scoring tools to no avail... So, I was wondering is there an SQL query I could run to remove this guys scores (eventhough under his userid he has none, according to the Score Tools and Member Management). It's annoying because it's not showing the 'true' High Score person, unless you click on View HighScores.

Regards,

[MrZeropage]

Try this:

UPDATE games_list SET bestscore=0 WHERE bestmid=USERID
(replace USERID with the UserID of that banned user)

This will set all his "best results" to a score of zero.

After that run the Score Tools -> Update Best Result Ever and everything should look fine :)

[syrus.xl]

Cool that worked!

Thanks...:)