\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";
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 " |