}
if($_GET['expand'] == 0){
switch($_GET['sub']){
case "individual";
ShowIndividualRanking();
break;
case "clan";
ShowClanRanking();
break;
}
}
if(!function_exists("ShowIndividualRanking")){
function ShowIndividualRanking(){
$res = mssql_query("SELECT TOP 50 * FROM Character ORDER BY XP DESC");
$count = 0;
?>
while($r = mssql_fetch_assoc($res)){
$count++;
?>
=$count?>
=$r['Name']?>
=$r['Level']?>
=number_format($r['XP'],0,'','.');?>
=$r['KillCount']?>/=$r['DeathCount']?>
(80%)
}?>
} }
if(!function_exists("ShowClanRanking")){
function ShowClanRanking(){
$res = mssql_query("SELECT TOP 50 * FROM Clan ORDER BY Ranking DESC");
?>
while($r = mssql_fetch_assoc($res)){ ?>
=$r['Ranking']?>
=$r['Name']?>
$res2 = mssql_query("SELECT * FROM Character WHERE CID = '".$r['MasterCID']."'");
$c = mssql_fetch_assoc($res2);
echo $c['Name'];
?>