[Help] Deleting a member's scores
 

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!

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.

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.

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 ;)

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

Thumbs up!

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?

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 :)