|
Latest Tournament
function getNth ($n)
{
$qn = (int) (($n%100) / 10);
$rn = $n % 10;
$suffix = "th";
if ($qn != 1)
{
switch ($rn)
{
case 1: $suffix = "st"; break;
case 2: $suffix = "nd"; break;
case 3: $suffix = "rd"; break;
}
}
return $n . $suffix;
}
$tquery = "SELECT `id`, `name`, `date`, `type` FROM tournaments ORDER by id DESC LIMIT 1";
$tresult = mysql_query($tquery, $server);
while ($trow = mysql_fetch_assoc($tresult))
{
$tid = $trow['id'];
$tid2++;
$tname = $trow['name'];
$ttype = $trow['type'];
if (!$ttype) { $ttype = "FFA"; }
$tdate = $trow['date'];
$year = substr($tdate, -2);
print "
$query = "SELECT `player`, `r1`, `r2`, `r3`, `r4`, `r5`, SUM(r1+r2+r3+r4+r5), `w`, `pos` FROM tournament WHERE tournament = $tid GROUP BY player ORDER BY `pos` ASC";
$result = mysql_query($query, $server);
?>
$color = "0";
while ($row = mysql_fetch_assoc($result))
{
$points = "0";
$player = $row['player'];
$pos = $row['pos'];
$r1 = $row['r1'];
$r2 = $row['r2'];
$r3 = $row['r3'];
$r4 = $row['r4'];
$r5 = $row['r5'];
if ($r5 == "0") { $r5 = "-"; }
$points = $row['SUM(r1+r2+r3+r4+r5)'];
$w = $row['w'];
$pquery = "SELECT `name` FROM players WHERE `id` = $player";
$presult = mysql_query($pquery, $server);
$plid = $player;
while ($prow = mysql_fetch_assoc($presult))
{
$player = $prow['name'];
$color++;
}
$pos2 = getNth($pos);
?>
| if ($pos == "1") { print ""; } print "$pos2"; print " "; print "$player";?> |
if ($pos == "1") { print ""; } print $r1;?> |
if ($pos == "1") { print ""; } print $r2;?> |
if ($pos == "1") { print ""; } print $r3;?> |
if ($pos == "1") { print ""; } print $r4;?> |
if ($pos == "1") { print ""; } print $r5;?> |
if ($pos == "1") { print ""; } print $points;?> |
}
print "
";
}
?>
|
|