View Full Version : Resetting Arcade but save list of high scores
13 Apr 2006, 10: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?
13 Apr 2006, 19: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
vBulletin® v3.6.12, Copyright ©2000-2014, Jelsoft Enterprises Ltd.