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