Monthly High Scores:
| Level: | Player: | Score: | Set: |
mysql_pconnect("localhost","lisa01_us24701b","deejay02");
mysql_select_db("lisa01_db24701b");
for($a=1;$a<6;$a++) {
$x=mysql_query("SELECT LoginID,Score,DATE_FORMAT(Timestamp,'%a,%b %D %Y') FROM GemGame WHERE Level=$a AND YEAR(Timestamp)=YEAR(NOW()) AND MONTH(Timestamp)=MONTH(NOW()) ORDER BY Score DESC LIMIT 1;");
echo mysql_error();
$y=mysql_fetch_row($x);
if ($y[0]==0) {
if ($y[1]>0) {
$z='Unknown Guest';
}
else {
$z="(Not set)";
}
}
else {
$w=mysql_query("SELECT Username FROM Users WHERE ID=$y[0];");
$b=mysql_fetch_row($w);
$z=$b[0];
}
echo "| $a | $z | $y[1] | $y[2] | \n\n";
}
?>
|
All-Time High Scores:
| Level: | Player: | Score: | Set: |
mysql_select_db("4WebGames");
for($a=1;$a<6;$a++) {
$x=mysql_query("SELECT LoginID,Score,DATE_FORMAT(Timestamp,'%a,%b %D %Y') FROM GemGame WHERE Level=$a ORDER BY Score DESC LIMIT 1;");
echo mysql_error();
$y=mysql_fetch_row($x);
if ($y[0]==0) {
if ($y[1]>0) {
$z='Unknown Guest';
}
else {
$z="(Not set)";
}
}
else {
$w=mysql_query("SELECT Username FROM Users WHERE ID=$y[0];");
$b=mysql_fetch_row($w);
$z=$b[0];
}
echo "| $a | $z | $y[1] | $y[2] | \n\n";
}
?>
|