Register Members List Search Today's Posts Mark Forums Read

 
 
Mod Options
  #1  
Old 18 Feb 2017, 14: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 50,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 12:22. Reason: Changed Help to Solved in title.
Comments
  #2  
Old 03 Dec 2017, 18: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.
  #3  
Old 04 Dec 2017, 13:24
stangger5's Avatar
stangger5 stangger5 is online now
 
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
  #4  
Old 04 Dec 2017, 17: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.
 



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

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


New To Site? Need Help?

All times are GMT. The time now is 21:53.

Layout Options | Width: Wide Color: