World Wide Highscores

Last submitted scores

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; $result_p = mysql_query("SELECT idx,title,level,score FROM pinballs WHERE idx>=100 and idx<200 ORDER BY idx"); while ($res_p = mysql_fetch_array($result_p)) { if ($res_p["score"]=="Grand Champion") { $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 DESC,score_units 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 " \n"; echo "\n"; $i=1; $max=0; $aPlayer=array(); while ($resarray = mysql_fetch_array($result)) { if (in_array($resarray["p_idx"],$aPlayer)==0) { $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"]==103) { echo "Combos"; } elseif ($res_p["idx"]==104) { echo "Loops"; } else echo "Points"; echo "     "; 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 "";*/ echo insert_points($resarray["score_billions"],$resarray["score_units"]); /* if (strlen(trim($resarray["zusatz"]))>0) echo "";*/ echo "     "; // echo $resarray["datum"]; // echo "   \n"; mysql_free_result($result); } mysql_free_result($result_p); echo "

\n"; ?>
=100 and scr.typ<200 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"]."	"; 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 (©) 2003-2005 by Andreas 'Ante' Grabher