[PHP]<?
if ($command=="init"){
$link = @mysql_connect("localhost", "username", "password");
if (!$link){
print "&message=Error connecting to database";
exit;
}
if (!@mysql_select_db("kevinsmi_game")){
print "&message=Couldn't select database";
exit;
}
$players = "";
$scores = "";
$distances = "";
$victims = "";
$innerquery = "SELECT * FROM game ORDER BY scores DESC";
$innerresult = @mysql_query($innerquery);
$numPlayers=mysql_num_rows($innerresult);
for($loop=0;$loop<$numPlayers; $loop++) {
$newPlayer = mysql_result($innerresult,$loop,"players");
$newScore = mysql_result($innerresult,$loop,"scores");
$newDistance = mysql_result($innerresult,$loop,"distances");
$newVictim = mysql_result($innerresult,$loop,"victims");
$players = "$players<br>$newPlayer";
$scores = "$scores<br>$newScore";
$distances = "$distances<br>$newDistance";
$victims = "$victims<br>$newVictim";
}
printf("&players=%s", $players);
printf("&scores=%s", $scores);
printf("&distances=%s", $distances);
printf("&victims=%s", $victims);
mysql_close($link);
}
if ($command=="update"){
$link = @mysql_connect("localhost", "username", "password");
if (!$link){
print "&message=Error connecting to database";
exit;
}
if (!@mysql_select_db("game")){
print "&message=Couldn't select database";
exit;
}
$players = "";
$scores = "";
$query = "SELECT scores FROM game where players = '$name'";
$result = @mysql_query($query);
if(@mysql_num_rows($result)>0){
$oldScore = mysql_result($result,"scores");
if($score>$oldScore){
$query = "UPDATE game SET scores = '$score' where players = '$name'";
$result = @mysql_query($query);
}
}
else {
$query ="INSERT INTO game (players, scores, distances, victims) VALUES ('$name', '$score', '$distance', '$victim')";
$result = @mysql_query($query);
}
$innerquery = "SELECT * FROM game ORDER BY scores DESC";
$innerresult = @mysql_query($innerquery);
$numPlayers=mysql_num_rows($innerresult);
for($loop=0;$loop<$numPlayers; $loop++) {
$newPlayer = mysql_result($innerresult,$loop,"players");
$newScore = mysql_result($innerresult,$loop,"scores");
$newDistance = mysql_result($innerresult,$loop,"distances");
$newVictim = mysql_result($innerresult,$loop,"victims");
$players = "$players<br>$newPlayer";
$scores = "$scores<br>$newScore";
$distances = "$distances<br>$newDistance";
$victims = "$victims<br>$newVictim";
}
printf("&players=%s", $players);
printf("&scores=%s", $scores);
printf("&distances=%s", $distances);
printf("&victims=%s", $victims);
mysql_close($link);
}
?>[/PHP]