|
include "class/scoresutil.php";
$bd=new bd();
echo "";
if (!(isset($lvl)||isset($racer)))
{
$nb=$bd->execute("select * from MQScoreTableUsers order by totalscores desc");
$max=$nb;if ($max>50) $max=50;
echo "MicroQuad best players ";
echo "";
echo "Rank | Nickname | Score | ";
for($i=0;$i<$max;$i++)
{
$tmp=$bd->get_next_row();
echo "";
$nick=$tmp["pseudo"];
echo "".($i+1)." | ";
echo "$nick | ";
echo "".$tmp["totalscores"]." | ";
echo " ";
}
echo " ";
if ($user)
{
if ($idxuser=UserGetIDX($user))
{
echo "$user's score: $totalscore (Rank: ".UserRank($totalscore).")";
}
}
}
if (isset($lvl))
{
echo "".$racename[$lvl]." best times";
echo "";
if (isset($racer))
echo " with ".$racername[$racer];
if (!isset($racer))
{
echo " ";
}
$rec="select pseudo,lvl,racer,time from MQScoreTable,MQScoreTableUsers where idx=idxuser and lvl=$lvl ";
if (isset($racer))
{
$rec.=" and racer=$racer";
}
$rec.=" and time<65535 order by time";
$nb=$bd->execute($rec);
$max=$nb;if ($max>20) $max=20;
echo "";
echo "Rank | Nickname | ";
if (!isset($racer)) echo "Pilote | ";
echo "Time | ";
for($i=0;$i<$max;$i++)
{
$tmp=$bd->get_next_row();
echo "";
$nick=$tmp["pseudo"];
echo "".($i+1)." | ";
echo "$nick | ";
if (!isset($racer)) echo " | ";
echo "".TimeToString($tmp["time"])." | ";
echo " ";
}
echo " ";
/*
if ($user)
{
if ($idxuser=UserGetIDX($user))
{
echo "$user's score: $totalscore ";
}
}
*/
}
echo "";
?>
|