vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=324476

[SOLVED]How to remove all scores of "0" from database
by blind-eddie
18 Feb 2017 13:23

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

Quote:

Originally Posted by stangger5
Delete 0 score queries.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Stratis 03 Dec 2017 17:50

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 04 Dec 2017 12:24

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 04 Dec 2017 16:06

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


All times are GMT. The time now is 00:51.

Powered by vBulletin® Version 3.8.14
Copyright © 2021, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.