"; }else{ echo "Error with high scores database: " . mysqli_error( $conn ) . "
"; } mysqli_close($conn); $database = "TDHighScores"; $conn = mysqli_connect( $servername, $username, $password, $database ); if( mysqli_query($conn, "CREATE TABLE IF NOT EXISTS T( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, difficulty INT(6) UNSIGNED, track INT(6) UNSIGNED, rank INT(6) UNSIGNED, name VARCHAR(20), score INT(6), date TIMESTAMP )") ){ //echo "T CHECK
"; }else{ echo "Error with high scores tables: " . mysqli_error($conn) . "
"; } $sql = "SELECT id FROM T"; $result = mysqli_query($conn, $sql); if( mysqli_num_rows( $result ) > 0 ) { }else{ $sql = ""; for( $k=0; $k<3; $k++ ) { for( $l=0; $l<3; $l++ ) { for( $rank=1; $rank<=3; $rank++ ) { $sql .= "INSERT INTO T (difficulty, track, rank, name, score) VALUES (" . $k . ", " . $l . ", " . $rank . ", 'Empty', " . 0 . ");"; } } } } if( mysqli_multi_query( $conn, $sql ) ) { }else{ echo "Error: " . mysqli_error( $conn ); } mysqli_close( $conn ); $conn = mysqli_connect( $servername, $username, $password, $database ); $arrayOfHighScores = array(); $sql = "SELECT id, difficulty, track, rank, name, score, date FROM T"; $result = mysqli_query($conn, $sql); if(!$result){ echo "Error: " . $sql . "
" . mysqli_error( $conn ); } if( mysqli_num_rows( $result ) > 0 ) { while( $row = mysqli_fetch_assoc( $result ) ) { array_push( $arrayOfHighScores, array( $row['id'], $row['difficulty'], $row['track'], $row['rank'], $row['name'], $row['score'], $row['date'] ) ); } }else{ } //echo $arrayOfHighScores[15][6]; // should echo the date, for now mysqli_close($conn); function echoScoresTable( $difficulty, $track ) { global $servername, $username, $password, $database; $output = ""; $conn = mysqli_connect( $servername, $username, $password, $database ); if( !$conn ) { die("Connection failed: " . mysqli_connect_error()); }else{ } $r=1; while( $r <= 3 ) { $sql = "SELECT rank, name, score, date FROM T WHERE difficulty=" . $difficulty . " AND track=" . $track . " AND rank=" . $r; $result = mysqli_query($conn, $sql); if(!$result){ echo "Error: " . $sql . "
" . mysqli_error( $conn ); } if( mysqli_num_rows( $result ) > 0 ) { while( $row = mysqli_fetch_assoc( $result ) ) { $output .= ""; } }else{ } $r = $r + 1; } /* for( $r=($difficulty*9)+($track*3); $r<($difficulty*9)+($track*3)+3; $r++ ) { $output .= "".$arrayOfHighScores[$r][5].""; } */ $output .= "
RankNameScoreDate
".$row['rank']."".$row['name']."".$row['score']."".explode(' ', $row['date'])[0]."
".$arrayOfHighScores[$r][3]."".$arrayOfHighScores[$r][4]."".$arrayOfHighScores[$r][6]."
"; echo $output; } // end function echoScoresTable ?>
Bubbos TD

High Scores

Score = ( [number of lives left] X 1000) + [Money at the end] Winding Path Big Loop S Curve
Easy
Hard
Impoppable