<?
if ($_GET[typ]=="1" || $_GET[typ]=="2" || $_GET[typ]=="4" || $_GET[typ]=="8" || $_GET[typ]=="16" || $_GET[typ]=="32" || $_GET[typ]=="64" || $_GET[typ]=="128" || $_GET[typ]=="256" || $_GET[typ]=="512")
{
$r = "SELECT TOP 100 * FROM $dfsql[db2].dbo.ChaInfo P, $dfsql[db4].dbo.UserInfo U WHERE P.UserNum = U.UserNum AND U.UserType != 30 AND P.ChaDeleted != 1 AND P.ChaClass = $_GET[typ] ORDER BY P.ChaReborn DESC, P.ChaLevel DESC";
}
else
{
$r = "SELECT TOP 100 * FROM $dfsql[db2].dbo.ChaInfo P, $dfsql[db4].dbo.UserInfo U WHERE P.UserNum = U.UserNum AND U.UserType != 30 AND P.ChaDeleted != 1 ORDER BY P.ChaReborn DESC, P.ChaLevel DESC";
}
if ($_GET[typ]=="gold")
{
$r = "SELECT TOP 100 * FROM $dfsql[db2].dbo.ChaInfo P, $dfsql[db4].dbo.UserInfo U WHERE P.UserNum = U.UserNum AND U.UserType != 30 AND P.ChaDeleted != 1 ORDER BY P.ChaMoney DESC";
}
else if ($_GET[typ]=="pk")
{
$r = "SELECT TOP 100 * FROM $dfsql[db2].dbo.ChaInfo P, $dfsql[db4].dbo.UserInfo U WHERE P.UserNum = U.UserNum AND U.UserType != 30 AND P.ChaDeleted != 1 ORDER BY P.ChaKill DESC";
}
$get_crank = mssql_query("$r");
while ($crank = mssql_fetch_array($get_crank))
{
$gccount++;
$get_g = mssql_query("SELECT * FROM $dfsql[db2].dbo.GuildInfo where GuNum = '$crank[3]' ");
while ($guild = mssql_fetch_array($get_g)) {
$g = $guild[3];
}
?>