<?
$BEST_PLAYER = mssql_fetch_row(mssql_query("SELECT TOP 1 name,clevel,class,resets,money FROM Character WHERE ctlcode != 32 AND ctlcode != 8 order by clevel desc, resets desc"));
$BEST_DK = mssql_fetch_row(mssql_query("SELECT TOP 1 name,clevel,class,resets,money FROM Character WHERE Class like '16' OR Class like '17' OR Class like '19' AND ctlcode != '32' AND ctlcode != '8' order by clevel desc, resets desc"));
$BEST_DW = mssql_fetch_row(mssql_query("SELECT TOP 1 name,clevel,class,resets,money FROM Character WHERE Class like '0' OR Class like '1' OR Class like '2' AND ctlcode != '32' AND ctlcode != '8' order by clevel desc, resets desc"));
$BEST_ELF = mssql_fetch_row(mssql_query("SELECT TOP 1 name,clevel,class,resets,money FROM Character WHERE Class like '32' OR Class like '33' OR Class like '35' AND ctlcode != '32' AND ctlcode != '8' order by clevel desc, resets desc"));
$BEST_MG = mssql_fetch_row(mssql_query("SELECT TOP 1 name,clevel,class,resets,money FROM Character WHERE Class like '48' OR Class like '50' AND ctlcode != '32' AND ctlcode != '8' order by clevel desc, resets desc"));
$BEST_DL = mssql_fetch_row(mssql_query("SELECT TOP 1 name,clevel,class,resets,money FROM Character WHERE Class like '64' OR Class like '66' AND ctlcode != '32' AND ctlcode != '8' order by clevel desc, resets desc"));
$BEST_SUM = mssql_fetch_row(mssql_query("SELECT TOP 1 name,clevel,class,resets,money FROM Character WHERE Class like '80' OR Class like '81' OR Class like '83' AND ctlcode != '32' AND ctlcode != '8' order by clevel desc, resets desc"));
$BEST_ZEN = mssql_fetch_row(mssql_query("SELECT TOP 1 name,clevel,class,resets,money FROM Character WHERE ctlcode != 32 AND ctlcode != 8 order by money desc"));
$BEST_GUILD = mssql_fetch_row(mssql_query("SELECT TOP 1 G_Name,G_Score,G_Master FROM Guild order by G_SCORE desc"));
print "
<div align=\"left\">
Strongest: <a title=\"Level: ".$BEST_PLAYER[1]." Resets: ".$BEST_PLAYER[3]."\">".$BEST_PLAYER[0]."</a>
<div style=\"padding-left:10px;\">
» Knight: <a title=\"Level: ".$BEST_DK[1]." Resets: ".$BEST_DK[3]."\">".$BEST_DK[0]."</a>
</div>
<div style=\"padding-left:10px;\">
» Wizard: <a title=\"Level: ".$BEST_DW[1]." Resets: ".$BEST_DW[3]."\">".$BEST_DW[0]."</a>
</div>
<div style=\"padding-left:10px;\">
» Elf: <a title=\"Level: ".$BEST_ELF[1]." Resets: ".$BEST_ELF[3]."\">".$BEST_ELF[0]."</a>
</div>
<div style=\"padding-left:10px;\">
» Gladiator: <a title=\"Level: ".$BEST_MG[1]." Resets: ".$BEST_MG[3]."\">".$BEST_MG[0]."</a>
</div>
Richest: <a title=\"Level: ".$BEST_ZEN[1]." Resets: ".$BEST_ZEN[3]." Money: ".$BEST_ZEN[4]." Zen\">".$BEST_ZEN[0]."</a><br>
Best Guild: <a title=\"Guild Master: ".$BEST_GUILD[2]." Points: ".$BEST_GUILD[1]."\">".$BEST_GUILD[0]."</a><br>
</div>
";
?>