\n";
echo "\n";
$score_nr=0;
if (($_REQUEST["pinballid"]>=401) and ($_REQUEST["pinballid"]<=442)) {
$query="SELECT idx,title,level,score FROM pinballs WHERE idx=".$_REQUEST["pinballid"];
} else {
$query="SELECT idx,title,level,score FROM pinballs WHERE idx>=400 and idx<500 ORDER BY idx";
$_REQUEST["pinballid"]=0;
}
$result_p = mysql_query("$query");
while ($res_p = mysql_fetch_array($result_p)) {
if (($score_nr==0) or ($score_nr==2) or ($score_nr==4) or ($score_nr==6) or ($score_nr==8)) {
if ($score_nr<>0) {
echo " \n";
}
echo " ";
echo $res_p["level"];
echo "
| \n";
echo "\n";
} else
echo " | | \n";
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";
echo "\n";
mysql_free_result($result);
}
echo "";
if ($res_p["score"]=="Grand Champion") {
echo "Highscore";
} else
echo $res_p["score"];
echo " |
| \n";
echo " Rank | Name | ";
echo "Points";
echo " | ";
// echo "Date | ";
echo " \n";
$i=1;
$bubbling=FALSE;
$max=0;
$aPlayer=array();
$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");
while ($resarray = mysql_fetch_array($result)) {
if (in_array($resarray["p_idx"],$aPlayer)==0) {
// Abbruch nach den TOP 5
if (($_REQUEST["pinballid"]==0) and ($i==6)) {
$bubbling=TRUE;
break;
}
$aPlayer=array_pad($aPlayer,count($aPlayer)+1,0);
$aPlayer[count($aPlayer)-1]=$resarray["p_idx"];
echo " ";
echo $i;
echo " | ";
/* if (($resarray["showinfo"]>0) and (strlen($resarray["email"])>0)) {
echo "";
}*/
echo htmlentities($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";
$i=$i+1;
}
}
echo "
| ";
if (($_REQUEST["pinballid"]==0) and ($bubbling)) {
echo "Show all scores | ";
}
echo " \n";
mysql_free_result($result);
$score_nr=$score_nr+1;
}
mysql_free_result($result_p);
echo " | \n";
?>
Last submitted scores |
Name | Difficulty | Score type | Score | Date | Comment |
if (($_REQUEST["pinballid"]>=401) and ($_REQUEST["pinballid"]<=442)) {
$query = "select pin.level,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.level,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>=400 and scr.typ<500 order by scr.idx desc";
}
$result = mysql_query("$query");
$i=0;
while ($resarray = mysql_fetch_array($result)) {
$i=$i+1;
echo "\n";
echo "".htmlentities($resarray["player"])." | ".$resarray["level"]." | ".$resarray["score"]." | ";
echo insert_points($resarray["score_billions"],$resarray["score_units"]);
echo " | ".$resarray["datum"]." | ";
if ((strlen($resarray["info"]))==0) {
echo "---";
} else {
echo htmlentities($resarray["info"]);
}
echo " | \n";
echo " \n";
// Abbruch nach den aktuellsten 10
if ($i==10) {
break;
}
}
mysql_free_result($result);
?>
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. |
echo htmlentities("Copyright (©) 2004-2012 by Andreas 'Ante' Grabher");
?>
|
|