[Help] Deleting a member's scores

[doggy1]

Hi. I was wondering if it is possible if the administrator can delete all the scores of one member. Our arcade champion wants to give other members a chance to be at the top and has requested his scores to be removed and nobody elses. If this is possible how is this done?

Thanks!

[MrZeropage]

Sure, this is implemented in AdminCP:

Score Tools -> enter Username and SEARCH -> CHECK ALL -> REMOVE SELECTED

[doggy1]

Sure, this is implemented in AdminCP:

Score Tools -> enter Username and SEARCH -> CHECK ALL -> REMOVE SELECTED
Thank you very much. The scores of the member have been deleted, but how do I remove that member from being the King of the Arcade? He is still showing up as the King. Is there a way to delete him from being the King?

Thanks again.

[MrZeropage]

Score Tools -> Rebuild Best Resuls Ever

[doggy1]

Score Tools -> Rebuild Best Resuls Ever
I went and click on the START for "Update the Best Results" and the person still is the king of the arcade. I do have less than 100 games so it appears I can do this all at once. But, it does not appear to be working? Is there something else that I need to be doing????? It is still showing him as having the best score of all time despite me deleting his scores.

Thanks.

[MrZeropage]

ah ok, I see

then manually delete all best results from this user :)

execute the following query:
UPDATE games_list SET bestscore=0,bestmid=0 WHERE bestmid=UserID

replace UserID with the UserID of that deleted user
if you have some table_prefix set, remind to put it infront of "games_list" ...

After the query is executed, run the Score Tools -> Update Best Results again to fill up the empty slots with other users ;)

[doggy1]

That worked and I thank you so much for your help.

Thumbs up!

[Mysticales]

execute the following query:
UPDATE games_list SET bestscore=0,bestmid=0 WHERE bestmid=UserID



Thanks, was looking for this answer.. since that someone wanted to cheat to win and I didnt want the top table to be messed up. Do you plan on making a AdminCP version of this to easily reset data or clear a user fully if they cheat?

[MrZeropage]

in AdminCP -> Games List there is an option "reset best result ever" for single/multiple games, just pick the games this user has the best result and run it. Before it you should remove all scores of that user (AdminCP -> Score Tools)

So this already is included :)