Difference between revisions of "How to unvalidate a highscore"

From X-Moto
Jump to: navigation, search
 
Line 1: Line 1:
 
*You need access to the website database
 
*You need access to the website database
*find the level, set numberUpdates to numberUpdates-1
+
*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