";
}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 = "
Rank | Name | Score | Date |
";
$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 .= "".$row['rank']." | ".$row['name']." | ".$row['score']." | ".explode(' ', $row['date'])[0]." |
";
}
}else{
}
$r = $r + 1;
}
/*
for( $r=($difficulty*9)+($track*3); $r<($difficulty*9)+($track*3)+3; $r++ )
{
$output .= "".$arrayOfHighScores[$r][3]." | ".$arrayOfHighScores[$r][4]." | | ".$arrayOfHighScores[$r][5]."".$arrayOfHighScores[$r][6]." |
";
}
*/
$output .= "
";
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
|
|
|
|