[SOLVED]How to remove all scores of "0" from database

[blind-eddie]

I reset my arcade high scores and in doing so left all scores on "View High Scores" page set at zero.

What query is needed to remove all scores that are "0"?

Thank you

Update: Thank you stangger5

Delete 0 score queries.

DELETE FROM games_scores WHERE score = 0;
DELETE FROM games_champs WHERE champ_score = 0;

[Stratis]

I reset my arcade high scores using Score Pruning and all updates that has pruning page.
But I still can see "Best Score" and "Winner Arcade"

Thanks foe any help.

[stangger5]

You can delete the Best Score in the Categories.

Admincp >> Arcade >> Categories.
Choose a category.
Put a check in the box to the right of the game or games you want to delete the Best Score and then look at the options at the bottom..
Reset BEST RESULT EVER


After deleting any score or scores, run the Score Tools.
Update Highscores, Update the Best Results and Update League

:)

[Stratis]

Actually I did not notice those options.
I went Admincp >> Arcade >> Games List. (and than pressed to each categories)

Thank you so much for helping me to this. Really appreciate it. :)