Top 50 worldwide:
";
echo"
| Name | Time | Date | "; $i=1;
$sql = "SELECT name, score, time FROM highscores WHERE game='$game' ORDER by score ASC LIMIT 50";
$resultaat = mysql_query($sql);
while ($record = mysql_fetch_object($resultaat))
{
if($BG!="#7B8491"){$BG="#7B8491"; }else{ $BG="#999999"; }
echo"| $i | $record->name | $record->score | ".time_format($record->time)." | ";
$i++;
}
echo" ";
?>
| |
Best times per playername:
";
echo"
| Name | Best time | Last online | "; $i=1;
$sql = "SELECT name, MIN(score) as score, MAX(time) as time FROM highscores WHERE game='$game' GROUP BY name ORDER by score ASC LIMIT 50";
$resultaat = mysql_query($sql);
while ($record = mysql_fetch_object($resultaat))
{
if($BG!="#7B8491"){$BG="#7B8491"; }else{ $BG="#999999"; }
echo"| $i | $record->name | $record->score | ".time_format($record->time)." | ";
$i++;
}
echo" ";
?>
| |
Last 50 laps
";
echo"
| Name | Best time | Last online | "; $i=1;
$sql = "SELECT name, score, time FROM highscores WHERE game='$game' ORDER by ID DESC LIMIT 50";
$resultaat = mysql_query($sql);
while ($record = mysql_fetch_object($resultaat))
{
if($BG!="#7B8491"){$BG="#7B8491"; }else{ $BG="#999999"; }
echo"| $i | $record->name | $record->score | ".time_format($record->time)." | ";
$i++;
}
echo" ";
?>
|
