How to unvalidate a highscore
From X-Moto
Revision as of 18:14, 7 April 2008 by The only dude (talk | contribs)
- You need access to the website database
- find the level, set nb_times_updated to nb_times_updated-1
SELECT * FROM levels WHERE name LIKE '%level%name%';
- find the highscore, set enabled to 0, validated to 0
SELECT * FROM highscores WHERE id_room=1 AND id_level=<id_level from the previous query>
- find the previous highscore, set enabled to 1
SELECT * FROM highscores WHERE id_room=1 AND id_level=<id_level from the previous query>
- delete the line in wr_history
SELECT * FROM wr_history WHERE id_room=1 AND id_level=<id_level from the previous query>
- regenerate the rss and the highscore's xml