Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 18 Feb 2017, 13:23
blind-eddie's Avatar
blind-eddie blind-eddie is offline
 
Join Date: Apr 2006
Real name: Tim
[SOLVED]How to remove all scores of "0" from database

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

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.
__________________
LONG LIVE 3.8 SERIES
National Arcade Competition Club- NACC All arcade edits will work on vb4.
Check out my heavily modified ibproarcade with over 45,000 games for you, free of charge!
Exclusive arcade addons, edits and skins were made by stangger5 owner of Next Level Arcade

Last edited by blind-eddie; 27 Feb 2017 at 11:22. Reason: Changed Help to Solved in title.
Reply With Quote
Comments
  #2  
Old 03 Dec 2017, 17:50
Stratis's Avatar
Stratis Stratis is offline
 
Join Date: Jan 2010
Real name: 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.
Reply With Quote
  #3  
Old 04 Dec 2017, 12:24
stangger5's Avatar
stangger5 stangger5 is offline
 
Join Date: Jan 2005
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

__________________
vb ibProArcade: Download Game, Game Challenge, Report Game, Daily Game Systems.
40,000+ Flash and HTML5 Games,, and more can be found at: next-level-arcade.com
Reply With Quote
  #4  
Old 04 Dec 2017, 16:06
Stratis's Avatar
Stratis Stratis is offline
 
Join Date: Jan 2010
Real name: 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.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 13:08.

Layout Options | Width: Wide Color: