rendered paste body<?
require_once("./navigation.php");
?>
<center><div class="center"><!-- Body Panel -->
<div class="header"><img src="./images/page_favourites.png" class="lefticon"><center>Rankings</center></div>
<div class="sec"> </div>
<?
$rank = mysql_query("SELECT * FROM users ORDER by points/10000 DESC");
$sort = $_GET['sortby'];
if($sort == "username")
{
$rank = mysql_query("SELECT * FROM users ORDER by username ASC");
?>
<center><table width="100%"><tr>
<tr>
<td class="rankhead">#</td>
<td class="rankhead"><a href="./rankings.php?sortby=usernamedesc">Username</a></td>
<td class="rankhead"><a href="./rankings.php?sortby=pointsasc">Points</a></td>
</tr>
<?
}
elseif($sort == "pointsdesc")
{
$rank = mysql_query("SELECT * FROM users ORDER by points DESC");
?>
<center><table width="100%"><tr>
<tr>
<td class="rankhead">#</td>
<td class="rankhead"><a href="./rankings.php?sortby=usernameasc">Username</a></td>
<td class="rankhead"><a href="./rankings.php?sortby=pointsasc">Points</a></td>
</tr>
<?
}
elseif($sort == "pointsdesc")
{
$rank = mysql_query("SELECT * FROM users ORDER by username DESC");
?>
<center><table width="100%"><tr>
<tr>
<td class="rankhead">#</td>
<td class="rankhead"><a href="./rankings.php?sortby=usernameasc">Username</a></td>
<td class="rankhead"><a href="./rankings.php?sortby=pointsdesc">Points</a></td>
</tr>
<?
}
elseif($sort == "pointsasc")
{
$rank = mysql_query("SELECT * FROM users ORDER by points ASC");
?>
<center><table width="100%"><tr>
<tr>
<td class="rankhead">#</td>
<td class="rankhead"><a href="./rankings.php?sortby=usernameasc">Username</a></td>
<td class="rankhead"><a href="./rankings.php?sortby=pointsdesc">Points</a></td>
</tr>
<?
}
else
{
?>
<center><table width="100%"><tr>
<tr>
<td class="rankhead">#</td>
<td class="rankhead"><a href="./rankings.php?sortby=usernameasc">Username</a></td>
<td class="rankhead"><a href="./rankings.php?sortby=pointsasc">Points</a></td>
</tr>
<?
}
while($row = mysql_fetch_assoc($rank))
{
$i ++;
$ranked =$i;
}
?>
<tr><td class="ranktd"><b>
<?
echo $ranked;
?>
</b></td><td class="ranktd">
<?
echo $row['username'];
?>
</td><td class="ranktd">
<?
echo $row['points'];
?>
</td></tr>
<?
}
?>
</table>
<div class="small"> </div>
<center>
<?
require_once("./footer.php");
?>