Difference between revisions of "How to unvalidate a highscore"
From X-Moto
Line 1: | Line 1: | ||
*You need access to the website database | *You need access to the website database | ||
− | *find the level, set | + | *find the level, set nb_times_updated to nb_times_updated-1 |
SELECT * FROM levels WHERE name LIKE '%level%name%'; | SELECT * FROM levels WHERE name LIKE '%level%name%'; | ||
*find the highscore, set enabled to 0, validated to 0 | *find the highscore, set enabled to 0, validated to 0 |
Revision as of 18:14, 7 April 2008
- 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