0)&($gameid<100000))
{
$totalscore = preg_replace("/[^0-9]/","",$totalscore);
$name = preg_replace("/[^0-9a-z\.\&\! ]/i","",$name);
$name = urlencode($name);
$sql = "INSERT into fwm_game_scores (gameid,name,score) values (\"$gameid\",\"$name\",\"$totalscore\")";
echo $sql;
$result=mysql_query($sql,$db);
}
}
elseif (($gameid>0)&($gameid<100000))
{
$sql = "SELECT * FROM fwm_game_scores where gameid = $gameid order by score desc limit 0,5";
$result = mysql_query($sql,$db);
if($myrow = mysql_fetch_array($result))
{
$i = 1;
echo "gameid=";
echo $gameid;
echo "&";
do
{
printf("name%s=%s&score%s=%s&",$i,$myrow["name"],$i,$myrow["score"]);
$i++;
}
while($myrow = mysql_fetch_array($result));
$sql = "SELECT * FROM fwm_games where gameid = $gameid";
$result = mysql_query($sql,$db);
if ($myrow = mysql_fetch_array($result))
{
echo "game_name=";
echo urlencode($myrow["game_name"]);
echo "&";
}
else
{
//no records retrieved
}
}
else
{
//no records retrieved
}
}
//cleanup
$sql = "DELETE from fwm_game_scores where score=0";
$result = mysql_query($sql,$db);
$sql = "DELETE from fwm_game_scores where gameid=0";
$result = mysql_query($sql,$db);
$sql = "DELETE from fwm_game_scores where name = \" \"";
$result = mysql_query($sql,$db);
?>