How to unvalidate a highscore
From X-Moto
- You need access to the website database
- find the level, set nb_times_updated to nb_times_updated-1
SELECT id,name,nb_times_updated FROM levels WHERE name LIKE '%level%name%'; update levels set nb_times_updated=nb_times_updated-1 where id=<id_level from the previous query>
- 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> update highscores set validated=0, enabled=0 where id=xxx;
- find the previous highscore, set enabled to 1
SELECT * FROM highscores WHERE id_room=1 AND id_level=<id_level from the previous query> update highscores set validated=1, enabled=1 where id=xxx;
- delete the line in wr_history
SELECT * FROM wr_history WHERE id_room=1 AND id_level=<id_level from the previous query> delete from wr_history where id=xxx;
- regenerate the rss and the highscore's xml