World Wide Highscores

=201) and ($_REQUEST["pinballid"]<=206)) { echo "Last submitted scores\n"; } else { echo "Last submitted scores\n"; } ?>

0) { while (strlen($units)<9) { $units="0".$units; } $units=$billions.$units; } if (strlen($units)>3) $units=substr($units,0,strlen($units)-3).".".substr($units,strlen($units)-3,3); if (strlen($units)>7) $units=substr($units,0,strlen($units)-7).".".substr($units,strlen($units)-7,7); if (strlen($units)>11) $units=substr($units,0,strlen($units)-11).".".substr($units,strlen($units)-11,11); if (strlen($units)>15) $units=substr($units,0,strlen($units)-15).".".substr($units,strlen($units)-15,15); if (strlen($units)>19) $units=substr($units,0,strlen($units)-19).".".substr($units,strlen($units)-19,19); return $units; } echo "\n"; echo "

\n"; $score_nr=0; if (($_REQUEST["pinballid"]>=201) and ($_REQUEST["pinballid"]<=206)) { $query="SELECT idx,title,level,score FROM pinballs WHERE idx=".$_REQUEST["pinballid"]; } else { $query="SELECT idx,title,level,score FROM pinballs WHERE idx>=200 and idx<300 ORDER BY idx"; $_REQUEST["pinballid"]=0; } $result_p = mysql_query("$query"); while ($res_p = mysql_fetch_array($result_p)) { if (($res_p["score"]=="Grand Champion") and ($_REQUEST["pinballid"]==0)) { $query="SELECT typ,p_idx,score_billions,score_units,datum,showinfo,player,email,www,zusatz from scores LEFT JOIN players ON scores.p_idx=players.idx WHERE typ=".$res_p["idx"]." ORDER BY score_billions DESC,score_units DESC"; $result = mysql_query("$query"); $resarray = mysql_fetch_array($result); echo " \n"; echo "\n"; if ($resarray) { echo "\n"; } echo " "; echo $res_p["score"]; echo "   Name     Points     "; /* if (($resarray["showinfo"]>0) and (strlen($resarray["email"])>0)) { echo ""; }*/ echo $resarray["player"]; /* if (($resarray["showinfo"]>0) and (strlen($resarray["email"])>0)) echo "";*/ echo "     "; echo insert_points($resarray["score_billions"],$resarray["score_units"]); echo "   \n"; echo "
\n"; mysql_free_result($result); } $query="SELECT typ,p_idx,score_billions,score_units,datum,showinfo,player,email,www,zusatz from scores LEFT JOIN players ON scores.p_idx=players.idx WHERE typ=".$res_p["idx"]." ORDER BY score_billions"; if ($res_p["idx"]<>203) $query=$query." DESC"; $query=$query.",score_units"; if ($res_p["idx"]<>203) $query=$query." DESC"; $result = mysql_query("$query"); if ($score_nr>0) { if (($score_nr/2)==floor($score_nr/2)) { echo "
\n"; } else echo "		\n"; } $score_nr=$score_nr+1; echo ""; if (($_REQUEST["pinballid"]==0) and ($bubbling)) { echo ""; } echo " \n"; echo ""; // echo ""; echo "\n"; $i=1; $bubbling=FALSE; $max=0; $aPlayer=array(); while ($resarray = mysql_fetch_array($result)) { if (in_array($resarray["p_idx"],$aPlayer)==0) { // Abbruch nach den TOP 10 if (($_REQUEST["pinballid"]==0) and ($i==11)) { $bubbling=TRUE; break; } $aPlayer=array_pad($aPlayer,count($aPlayer)+1,0); $aPlayer[count($aPlayer)-1]=$resarray["p_idx"]; echo ""; // echo ""; echo "\n"; $i=$i+1; } } echo " "; if ($res_p["score"]=="Grand Champion") { echo "Highscore"; } else echo $res_p["score"]; echo "   Rank     Name     "; if ($res_p["idx"]==203) { echo "Seconds"; } elseif ($res_p["idx"]==204) { echo "Ramps"; } else echo "Points"; echo "   Date     "; echo $i; echo "     "; /* if (($resarray["showinfo"]>0) and (strlen($resarray["email"])>0)) { echo ""; }*/ echo $resarray["player"]; /* if (($resarray["showinfo"]>0) and (strlen($resarray["email"])>0)) echo "";*/ echo "     "; /* if (strlen(trim($resarray["zusatz"]))>0) echo "";*/ if ($res_p["idx"]==203) { $komma=$resarray["score_units"]; while (strlen($komma)<2) { $komma="0".$komma; } echo $resarray["score_billions"].",".$komma; } else echo insert_points($resarray["score_billions"],$resarray["score_units"]); /* if (strlen(trim($resarray["zusatz"]))>0) echo "";*/ echo "     "; // echo $resarray["datum"]; // echo "   Show all scores \n"; mysql_free_result($result); } mysql_free_result($result_p); echo "

\n"; ?>
=201) and ($_REQUEST["pinballid"]<=206)) { $query = "select pin.score,scr.*,ply.player from scores scr left join players ply on scr.p_idx=ply.idx left join pinballs pin on pin.idx=scr.typ where scr.typ=".$_REQUEST["pinballid"]." order by scr.idx desc"; } else { $query = "select pin.score,scr.*,ply.player from scores scr left join players ply on scr.p_idx=ply.idx left join pinballs pin on pin.idx=scr.typ where scr.typ>=200 and scr.typ<300 order by scr.idx desc"; } $result = mysql_query("$query"); $i=0; while ($resarray = mysql_fetch_array($result)) { $i=$i+1; echo "\n"; echo "\n"; echo "\n"; // Abbruch nach den aktuellsten 10 if ($i==10) { break; } } mysql_free_result($result); ?>

Last submitted scores
Name	Score type	Score	Date	Comment
".$resarray["player"]."	".$resarray["score"]."	"; if ($resarray["typ"]==203) { echo $resarray["score_billions"].",".$resarray["score_units"]." sec"; } else { echo insert_points($resarray["score_billions"],$resarray["score_units"]); } echo "	".$resarray["datum"]."	"; if ((strlen($resarray["info"]))==0) { echo "---"; } else { echo $resarray["info"]; } echo "

Pro Pinball, The Web, Timeshock!, Big Race USA and Fantastic Journey are trademarks of Empire Interactive.

All other trademarks and logos are the property of their respective owners.

Copyright (©) 2004-2005 by Andreas 'Ante' Grabher