"") { $num=mysql_numrows($response); //echo "\n".$num; if ($num > 0) { //found the regcode in the db - they are registerd! $pnameunique = ""; //find any players with the same name $sql = "SELECT * FROM players WHERE players.name='".$pname."'"; $response = mysql_query($sql); If ($response <> "") { // we found some... // how many? $num=mysql_numrows($response); if ($num > 0) { $pnameunique = $pname . "(" . $num . ")"; } } $sql = "INSERT INTO players (name,unique_name,reg_ID,achievements,achievementblob) VALUES ('" . $pname . "','" . $pnameunique . "','" . $regkey . "','" . $ach . "','" . $achblob . "')"; mysql_query($sql); return mysql_insert_id(); } } return "-5"; } Function showplayers() { echo ""; echo ""; echo "Achievements"; echo ""; echo ""; echo ""; echo "
Achievements
"; $sql = "SELECT * FROM players"; $response = mysql_query($sql); If ($response <> "") { echo "Show All Scores

"; $i=0; $Max=mysql_numrows($response); echo ""; While ($i < $Max) { echo ""; echo ""; echo ""; $i = $i + 1; } echo "
"; if (mysql_result($response, $i, "players.unique_name") <> "") { echo "".mysql_result($response, $i, "players.unique_name").""; } else { echo "".mysql_result($response, $i, "players.name").""; } $achv = mysql_result($response, $i, "players.achievements"); echo " has completed " . $achv . "%"; echo "


"; } else { echo "No players found.

"; echo "Show Scores

"; } echo ""; } Function showachievements($pid) { $achvdesc[0] = "Collect 100 HEXES"; $achvdesc[1] = "Collect 200 HEXES"; $achvdesc[2] = "Collect 300 HEXES"; $achvdesc[3] = "Collect 400 HEXES"; $achvdesc[4] = "Collect 500 HEXES"; $achvdesc[5] = "Collect a single run of 10 HEXES"; $achvdesc[6] = "Collect a single run of 15 HEXES"; $achvdesc[7] = "Collect a single run of 25 HEXES"; $achvdesc[8] = "Collect a single run of 35 HEXES"; $achvdesc[9] = "Collect a single run of 50 HEXES"; $achvdesc[10] = "Collect a single run of 75 HEXES"; $achvdesc[11] = "Collect a 3 HEX run for each colour"; $achvdesc[12] = "Collect a 6 HEX run for each colour"; $achvdesc[13] = "Collect a 9 HEX run for each colour"; $achvdesc[14] = "Collect a 12 HEX run for each colour"; $achvdesc[15] = "Collect a 15 HEX run for each colour"; $achvdesc[16] = "Collect 10 HEXES with no colour runs"; $achvdesc[17] = "Collect 15 HEXES with no colour runs"; $achvdesc[18] = "Collect 25 HEXES with no colour runs"; $achvdesc[19] = "Collect 35 HEXES with no colour runs"; $achvdesc[20] = "Collect 50 HEXES with no colour runs"; $achvdesc[21] = "Collect 75 HEXES with no colour runs"; $achvdesc[22] = "10 Unshielded HEXES on screen"; $achvdesc[23] = "15 Unshielded HEXES on screen"; $achvdesc[24] = "25 Unshielded HEXES on screen"; $achvdesc[25] = "35 Unshielded HEXES on screen"; $achvdesc[26] = "50 Unshielded HEXES on screen"; $achvdesc[27] = "75 Unshielded HEXES on screen"; $achvdesc[28] = "Get Multiplier over 10X"; $achvdesc[29] = "Get Multiplier over 100X"; $achvdesc[30] = "Get Multiplier over 500X"; $achvdesc[31] = "Get Multiplier over 1000X"; $achvdesc[32] = "Get Multiplier over 5000X"; $achvdesc[33] = "Get Multiplier to 10000X"; $achvdesc[34] = "Score 100,000 on EASY"; $achvdesc[35] = "Score 1,000,000 on EASY"; $achvdesc[36] = "Score 5,000,000 on EASY"; $achvdesc[37] = "Score 10,000,000 on EASY"; $achvdesc[38] = "Score 50,000,000 on EASY"; $achvdesc[39] = "Score 100,000,000 on EASY"; $achvdesc[40] = "Score 100,000 on NORMAL"; $achvdesc[41] = "Score 1,000,000 on NORMAL"; $achvdesc[42] = "Score 5,000,000 on NORMAL"; $achvdesc[43] = "Score 10,000,000 on NORMAL"; $achvdesc[44] = "Score 50,000,000 on NORMAL"; $achvdesc[45] = "Score 100,000,000 on NORMAL"; $achvdesc[46] = "Score 100,000 on HARD"; $achvdesc[47] = "Score 1,000,000 on HARD"; $achvdesc[48] = "Score 5,000,000 on HARD"; $achvdesc[49] = "Score 10,000,000 on HARD"; $achvdesc[50] = "Score 50,000,000 on HARD"; $achvdesc[51] = "Score 100,000,000 on HARD"; $achvdesc[52] = "Survive for 5 minutes EASY"; $achvdesc[53] = "Survive for 10 minutes EASY"; $achvdesc[54] = "Survive for 15 minutes EASY"; $achvdesc[55] = "Survive for 20 minutes EASY"; $achvdesc[56] = "Survive for 25 minutes EASY"; $achvdesc[57] = "Survive for 30 minutes EASY"; $achvdesc[58] = "Survive for 5 minutes NORMAL"; $achvdesc[59] = "Survive for 10 minutes NORMAL"; $achvdesc[60] = "Survive for 15 minutes NORMAL"; $achvdesc[61] = "Survive for 20 minutes NORMAL"; $achvdesc[62] = "Survive for 25 minutes NORMAL"; $achvdesc[63] = "Survive for 30 minutes NORMAL"; $achvdesc[64] = "Survive for 5 minutes HARD"; $achvdesc[65] = "Survive for 10 minutes HARD"; $achvdesc[66] = "Survive for 15 minutes HARD"; $achvdesc[67] = "Survive for 20 minutes HARD"; $achvdesc[68] = "Survive for 25 minutes HARD"; $achvdesc[69] = "Survive for 30 minutes HARD"; $achvdesc[70] = "Score 100,000 on first life"; $achvdesc[71] = "Score 1,000,000 on first life"; $achvdesc[72] = "Score 5,000,000 on first life"; $achvdesc[73] = "Score 10,000,000 on first life"; $achvdesc[74] = "Score 50,000,000 on first life"; $achvdesc[75] = "Score 100,000,000 on first life"; $achvdesc[76] = "Score 100,000 in less than 5 minutes"; $achvdesc[77] = "Score 1,000,000 in less than 5 minutes"; $achvdesc[78] = "Score 5,000,000 in less than 5 minutes"; $achvdesc[79] = "Score 10,000,000 in less than 5 minutes"; $achvdesc[80] = "Score 25,000,000 in less than 5 minutes"; $achvdesc[81] = "Score 50,000,000 in less than 5 minutes"; $achvdesc[82] = "Don't shoot for 15 seconds"; $achvdesc[83] = "Don't shoot for 30 seconds"; $achvdesc[84] = "Don't shoot for 45 seconds"; $achvdesc[85] = "Don't shoot for 60 seconds"; $achvdesc[86] = "Cold Tranquility for 5 seconds"; $achvdesc[87] = "Cold Tranquility for 8 seconds"; $achvdesc[88] = "Bank 5 Extra NAUS"; $achvdesc[89] = "Bank 10 Extra NAUS"; $achvdesc[90] = "Enter Subatomic in less than 5 minutes"; $achvdesc[91] = "Enter Subatomic in less than 3 minutes"; $achvdesc[92] = "Enter Subatomic in less than 1 minute"; $achvdesc[93] = "Escape Subatomic in less than 1 minute"; $achvdesc[94] = "Escape Subatomic in less than 40 Seconds"; $achvdesc[95] = "Escape Subatomic in less than 20 Seconds"; $achvdesc[96] = "Collect a KARKATA PLASMA Bonus"; $achvdesc[97] = "Enter Subatomic without losing a HEX"; $achvdesc[98] = "Enter Subatomic without collecting a HEX"; $achvdesc[99] = "Collect the 3 Shot Powerup Bonuses"; echo ""; echo ""; echo "Achievements"; echo ""; echo ""; echo ""; echo "
Achievements
"; $sql = "SELECT * FROM players WHERE players.webpid = ".$pid; $response = mysql_query($sql); If ($response <> "") { echo "Show all Players - "; echo "Show all Scores - "; echo "Show ". mysql_result($response, 0, "players.name")."'s Scores

"; echo ""; echo ""; echo ""; echo "
"; echo "". mysql_result($response, 0, "players.name"); $achv = mysql_result($response, 0, "players.achievements"); echo " has completed " . $achv . " of the achievements. "; If ($achv < 25) { echo "Level: Shouldn't even be uploaded!"; } If (($achv> 24) && ($achv< 50)) //25-49 { echo "Level: Bronze"; } If (($achv> 49) && ($achv< 65)) //50-64 { echo "Level: Silver"; } If (($achv> 64) && ($achv< 80)) //65-79 { echo "Level: Gold"; } If (($achv> 79) && ($achv< 90)) //80-89 { echo "Level: Platinum"; } If (($achv> 89) && ($achv< 100)) //90-99 { echo "Level: Diamond"; } If ($achv == 100) { echo "Level: Quintessence"; } echo "
"; echo "
"; echo ""; echo ""; $achvblob = mysql_result($response, 0, "achievementblob"); $i = 0; While ($i < 100) { if ($achvblob[$i] == "0") { //not complete echo ""; echo ""; echo ""; } else { echo ""; echo ""; echo ""; } echo ""; echo ""; $i = $i + 1; } echo "
#StatusAchievement
" .($i+1). " ------
" .($i+1). " Completed " .$achvdesc[$i]. "
"; echo "
"; } echo ""; } ?>