How to unvalidate a highscore

From X-Moto
Revision as of 18:13, 7 April 2008 by The only dude (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
  • You need access to the website database
  • find the level, set numberUpdates to numberUpdates-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