How to unvalidate a highscore

From X-Moto
Jump to: navigation, search
  • 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