All | Royals | Elves | Mages | Knights | Dark Elves | Dragon Knights | Illusionists | Reapers
query("Select ranks.*, characters.char_name, characters.level, characters.`Class` From `arenapvpranks` as ranks Left Join characters On ranks.charid = characters.objid Where characters.AccessLevel = '0' $queryname Order By ranks.score DESC, ranks.wins DESC, ranks.kills Desc Limit 50"); $number = 1; while($rank = $DB->fetch_array($rankings)){ switch($rank['Class']){ case "0": case "1": $rank['classname'] = "Royal"; break; case "138": case "37": $rank['classname'] = "Elf"; break; case "734": case "1186": $rank['classname'] = "Mage"; break; case "61": case "48": $rank['classname'] = "Knight"; break; case "2786": case "2796": $rank['classname'] = "Dark Elf"; break; case "3046": case "4001": $rank['classname'] = "Reaper"; break; case "6658": case "6661": $rank['classname'] = "DragonKnight"; break; case "6671": case "6650": $rank['classname'] = "Illusionist"; } echo ' '; $number++; } echo '
# Name Class Level Wins Loss Ties Kills Deaths Score
'.$number.' '.$rank['char_name'].' '.$rank['classname'].' '.$rank['level'].' '.$rank['wins'].' '.$rank['loss'].' '.$rank['ties'].' '.$rank['kills'].' '.$rank['deaths'].' '.$rank['score'].'
'; require("./templates/footer.php"); ?>