100) { $page = 0; } } $playerid = $_GET['playerid']; showplayerswebscores($page,$playerid); } else { If (isset($_GET['diff'])) { $diff = $_GET['diff']; If ($diff < 0 || $diff > 2) { $diff = 0; } } If (isset($_GET['page'])) { $page = $_GET['page']; If ($page < 0 || $page > 100) { $page = 0; } } OutputHeader($diff,$page); showwebhighscores("HIGHER",$diff,$page); OutputFooter($diff,$page); } break; Case Null: echo "Missing Action."; break; Default: echo "Action not understood"; break; } mysql_close(); Function CalcChecksum($blob) { $sum = 0; For ($i=0; $i"; echo ""; echo "AtomHex High Scores"; echo ""; echo ""; echo ""; echo "
AtomHex High Scores - "; switch($diff) { case 0: echo "Easy "; echo " / (Normal)"; echo " / (Hard)"; break; case 1: echo "Normal "; echo " / (Easy)"; echo " / (Hard)"; break; case 2: echo "Hard "; echo " / (Easy)"; echo " / (Normal)"; break; } echo "

"; echo ""; echo ""; echo ""; echo "
"; echo "View "; $i = 0; while ($i < 10) { if ($page == $i) { echo ($i*25+1)."-".(($i+1)*25)." "; } else { echo "".($i*25+1)."-".(($i+1)*25)." "; } $i = $i + 1; } echo "
"; echo "
"; } Function OutputFooter($diff,$page) { echo "
"; echo "View "; $i = 0; while ($i < 10) { if ($page == $i) { echo ($i*25+1)."-".(($i+1)*25)." "; } else { echo "".($i*25+1)."-".(($i+1)*25)." "; } $i = $i + 1; } echo "
"; echo "
"; echo ""; } Function AddHighScore($pid, $sc, $scd, $df, $pt, $pti, $ct, $ha,$hr,$hy,$hg,$hc,$hb,$hv) { $sql = "INSERT INTO atomhexhighscores " ."(webpid,score,score_disp,difficulty," ."play_time,play_time_int,clocktime," ."hex_all,hex_r,hex_y,hex_g,hex_c,hex_b,hex_v) " ."VALUES ('" . $pid . "'," . $sc . ",'" . $scd . "'," . $df .",'" . $pt . "'," . $pti .",'" . $ct ."'," . $ha . "," . $hr . "," . $hy . "," . $hg . "," . $hc . "," . $hb . "," . $hv . ")"; mysql_query($sql); return mysql_insert_id(); } Function showhighscores($higherscore="HIGHER") { If ($higherscore=="HIGHER") { $sortdir="DESC"; } If ($higherscore=="LOWER") { $sortdir="ASC"; } $sql = "SELECT * FROM players INNER JOIN atomhexhighscores ON 'players.webpid' = 'atomhexhighscores.webpid' ORDER BY score " . $sortdir; $response = mysql_query($sql); $i=0; $Max=mysql_numrows($response); While ($i < $Max) { echo mysql_result($response, $i, "players.unique_name") . " - " . mysql_result($response, $i, "score_disp") . webend(0); $i = $i + 1; } } Function showwebhighscores($higherscore="HIGHER",$diff,$page) { If ($higherscore=="HIGHER") { $sortdir="DESC"; } If ($higherscore=="LOWER") { $sortdir="ASC"; } $sql = "SELECT * FROM players INNER JOIN atomhexhighscores ON players.webpid = atomhexhighscores.webpid " . "WHERE difficulty = $diff ORDER BY atomhexhighscores.score " . $sortdir ." LIMIT " .$page*25 .",25"; $response = mysql_query($sql); If ($response <> "") { $i=0; $Max=mysql_numrows($response); /* Output data into a HTMl table */ echo ""; echo "
"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; While ($i < $Max) { echo "\n"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $i = $i + 1; } echo "
RankPlayer NameScoreTimeHexes / Runs
Total RedYellowGreenCyanBlueViolet
" . ($i+1+$page*25) . "";; if (mysql_result($response, $i, "players.unique_name") <> "") { echo "".mysql_result($response, $i, "players.unique_name").""; } else { echo "".mysql_result($response, $i, "players.name").""; } echo "" . mysql_result($response, $i, "score_disp") . "" . mysql_result($response, $i, "play_time") . "" . mysql_result($response, $i, "hex_all") . "" . mysql_result($response, $i, "hex_r") . "" . mysql_result($response, $i, "hex_y") . "" . mysql_result($response, $i, "hex_g") . "" . mysql_result($response, $i, "hex_c") . "" . mysql_result($response, $i, "hex_b") . "" . mysql_result($response, $i, "hex_v") . "
"; } } Function showplayerswebscores($page,$player_ID) { //output all scores for this player, with difficulty column, sort by difficulty & score $player_name = ""; $sql = "SELECT * FROM players WHERE players.webpid=$player_ID"; $response = mysql_query($sql); if ($response <> "") { if (mysql_result($response, 0, "players.unique_name") <> "") { $player_name = mysql_result($response, 0, "players.unique_name"); } else { $player_name = mysql_result($response, 0, "players.name"); } } echo ""; echo ""; echo "AtomHex High Scores"; echo ""; echo ""; echo ""; echo "
AtomHex High Scores For "; echo "".$player_name."
"; echo "
Show all Scores: (Easy)"; echo " / (Normal)"; echo " / (Hard)"; echo "

"; echo ""; echo ""; echo ""; echo "
"; echo "View "; $i = 0; while ($i < 10) { if ($page == $i) { echo ($i*25+1)."-".(($i+1)*25)." "; } else { echo "".($i*25+1)."-".(($i+1)*25)." "; } $i = $i + 1; } echo "
"; echo "
"; $sql = "SELECT * FROM atomhexhighscores " . "WHERE webpid = $player_ID ORDER BY difficulty ASC, score DESC" ." LIMIT " .$page*25 .",25"; $response = mysql_query($sql); If ($response <> "") { $i=0; $Max=mysql_numrows($response); /* Output data into a HTMl table */ echo ""; echo "
"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; While ($i < $Max) { echo "\n"; echo ""; switch (mysql_result($response, $i, "difficulty")) { Case "0": echo ""; break; Case "1": echo ""; break; Case "2": echo ""; break; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $i = $i + 1; } echo "
GameDifficultyScoreTimeHexes / Runs
Total RedYellowGreenCyanBlueViolet
" . ($i+1+$page*25) . "EasyNormalHard" . mysql_result($response, $i, "score_disp") . "" . mysql_result($response, $i, "play_time") . "" . mysql_result($response, $i, "hex_all") . "" . mysql_result($response, $i, "hex_r") . "" . mysql_result($response, $i, "hex_y") . "" . mysql_result($response, $i, "hex_g") . "" . mysql_result($response, $i, "hex_c") . "" . mysql_result($response, $i, "hex_b") . "" . mysql_result($response, $i, "hex_v") . "
"; } echo "
"; echo "View "; $i = 0; while ($i < 10) { if ($page == $i) { echo ($i*25+1)."-".(($i+1)*25)." "; } else { echo "".($i*25+1)."-".(($i+1)*25)." "; } $i = $i + 1; } echo "
"; echo "
"; echo ""; } ?>