The Arcive of vBulletin Modifications Site.

How to delete best score ever? · **Released**: 10-23-2006

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

MrZeropage · #2 10-23-2006, 09:02 PM

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

johon · #3 10-24-2006, 03:50 AM

Quote:

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!

G_Man · #4 11-24-2006, 01:42 AM

Quote:

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

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.