\n";
echo "\n";
$score_nr=0;
if (($_REQUEST["pinballid"]>=301) and ($_REQUEST["pinballid"]<=347)) {
$query="SELECT idx,title,level,score FROM pinballs WHERE idx=".$_REQUEST["pinballid"];
} else {
$query="SELECT idx,title,level,score FROM pinballs WHERE idx>=300 and idx<400 ORDER BY idx";
$_REQUEST["pinballid"]=0;
}
$result_p = mysql_query("$query");
while ($res_p = mysql_fetch_array($result_p)) {
$lGerade=(($score_nr/2)==floor($score_nr/2));
if (($score_nr==0) or ($score_nr==6) or ($score_nr==13) or ($score_nr==20) or ($score_nr==27)) {
if ($score_nr<>0) {
echo "|
\n";
}
echo "
";
echo $res_p["level"];
echo "
| \n";
echo "| \n";
} elseif (($score_nr==12) or ($score_nr==19) or ($score_nr==26) or ($score_nr==33)) {
echo " | |
| \n";
} elseif ($lGerade and (($score_nr<=10) or ($score_nr==22) or ($score_nr==24))) {
echo " | |
| \n";
} elseif ($lGerade and ((($score_nr>=14) and ($score_nr<=18)) or ($score_nr>=28))) {
echo " | | \n";
} elseif ((! $lGerade) and (($score_nr<=11) or (($score_nr>=21) and ($score_nr<=25)))) {
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 | ";
if (($res_p["idx"]==305) or ($res_p["idx"]==315) or ($res_p["idx"]==325) or ($res_p["idx"]==335) or ($res_p["idx"]==345)) {
echo "Combos";
} elseif (($res_p["idx"]==306) or ($res_p["idx"]==316) or ($res_p["idx"]==326) or ($res_p["idx"]==336) or ($res_p["idx"]==346)) {
echo "Loops";
} elseif (($res_p["idx"]==317) or ($res_p["idx"]==327) or ($res_p["idx"]==337) or ($res_p["idx"]==347)) {
echo "Kills";
} else
echo "Points";
echo " | ";
// Datum Spalte
// 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 $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 " | ";
// Datum Wert
// 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 |
=301) and ($_REQUEST["pinballid"]<=347)) {
$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>=300 and scr.typ<400 order by scr.idx desc";
}
$result = mysql_query("$query");
$i=0;
while ($resarray = mysql_fetch_array($result)) {
$i=$i+1;
echo "\n";
echo "| ".$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 $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. |
| Copyright (©) 2004-2005 by Andreas 'Ante' Grabher |
|
