How to delete best score ever?

[johon]

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]

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]

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]

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.