Register Members List Search Today's Posts Mark Forums Read

 
 
Mod Options
  #1  
Old 23 Oct 2006, 14:13
johon johon is offline
 
Join Date: Oct 2004
How to delete best score ever?

Hi @ll,

can somebody help me with an SQL-Synax or something like that to delete the best score ever for all games in one statement?

Thanks

JHon
Comments
  #2  
Old 24 Oct 2006, 00:02
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Real name: Marcel
upcoming v2.5.7+ will have an option for this in the gamelist in AdminCP

but you can try:

UPDATE games_list SET bestmid=0, bestscore=0
__________________
Get the most installed modification for your vBulletin (more than 8400 installations and 148.000 downloads!):
ibProArcade 2.7.6+ download here | Click here to enter the ibProArcade-Support-Section
Don't miss the new Google Analytics Integration (GDPR/DSGVO) for vB4.x
  #3  
Old 24 Oct 2006, 06:50
johon johon is offline
 
Join Date: Oct 2004
Originally Posted by MrZeropage
upcoming v2.5.7+ will have an option for this in the gamelist in AdminCP

but you can try:

UPDATE games_list SET bestmid=0, bestscore=0
Thank you, works great!
  #4  
Old 24 Nov 2006, 03:42
G_Man's Avatar
G_Man G_Man is offline
 
Join Date: Feb 2006
Real name: Wade
Originally Posted by MrZeropage View Post
upcoming v2.5.7+ will have an option for this in the gamelist in AdminCP

but you can try:

UPDATE games_list SET bestmid=0, bestscore=0
Mr. Zeropage...

That feature isn't working for me in the ACP with 2.5.7+

Just a head ups.

The query still worked great though. Cheers.
__________________
www.afterseppuku.com
Feel free to check it out and tell me what I can do better.
Make Money.
 



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 18:22.

Layout Options | Width: Wide Color: