Ranking

$msconnect = mssql_connect("IP","user","pass"); $msdb = mssql_select_db("character", $msconnect); $plist = "SELECT TOP 100 character_name, dwPVPpoint FROM [user_character] WHERE dwPVPpoint > '0'order by dwPVPpoint desc"; $pplist = mssql_query($plist); Ranking Top PvP $msconnect = mssql_connect("IP","user","pass"); $msdb = mssql_select_db("character", $msconnect); $plist = "SELECT TOP 100 character_name, dwPVPpoint FROM [user_character] WHERE dwPVPpoint > '0'order by dwPVPpoint desc"; $pplist = mssql_query($plist); echo "

Position	Character	Win	Lose	Class

"; echo ""; while($list = mssql_fetch_array($pplist)){ if($list[''] == "0"){ $char = "t"; } elseif($list[''] == "1"){ $char = ""; } else $char = "Archer"; echo ""; echo ""; echo ""; } echo "

	Name	Points
"; echo "	"; echo $list['character_name']; echo "	"; echo $list['dwPVPpoint']; echo "

"; $msconnect = mssql_connect("IP","user","password"); $msdb = mssql_select_db("character", $msconnect); $plist = "SELECT TOP 100 character_name, wPKCount FROM [user_character] WHERE wPKCount > '0'order by wPKCount desc"; $pplist = mssql_query($plist); Ranking Top PK echo "

Position	Character	PK	Class

"; echo ""; while($list = mssql_fetch_array($pplist)){ if($list[''] == "0"){ $char = "t"; } elseif($list[''] == "1"){ $char = ""; } else $char = "Archer"; echo ""; echo ""; echo ""; } echo "

	Name	Points
"; echo "	"; echo $list['character_name']; echo "	"; echo $list['wPKCount']; echo "

";