PDA

View Full Version : Resetting Arcade but save list of high scores


theodonnells
13 Apr 2006, 11:13
I am resetting my arcade but would like to post a list of all the high scores before hand.Is there an easy way to get them from the database?

MrZeropage
13 Apr 2006, 20:30
SELECT champ_gid, champ_name, champ_score FROM ".TABLE_PREFIX."games_champs

champ_gid => GameID
champ_name => Name of Champ
champ_score => Highscore

After that you may want to lookup the Gamename corresponting to that GameID:

SELECT gname FROM ".TABLE_PREFIX."games_list WHERE gid=$champ_gid