'; echo 'Character Rankings | Guild Rankings | PVP Rankings'; echo '

'; $odbc_link = odbc_connect ( "Driver={SQL Server};Server=".$odbc_host.";Database=w00_Character;" , $odbc_user , $odbc_pass ); $sql = 'SELECT sName, nWarWinCount, nWarLoseCount, nWarDrawCount, nType FROM tGuild WHERE nMaxMembers = 100 ORDER BY nWarWinCount DESC'; $rs = odbc_exec ( $odbc_link , $sql ); if ( !$rs ) { exit ( 'Error in SQL' ); } $i = 1; echo ''; echo ' '; echo ' '; echo ' '; echo ' '; echo ' '; echo ' '; echo ' '; echo ' '; echo ' '; while ( odbc_fetch_row ( $rs ) ) { $sName = odbc_result ( $rs , 'sName' ); $nWarWinCount = odbc_result ( $rs , 'nWarWinCount' ); $nWarLoseCount = odbc_result ( $rs , 'nWarLoseCount' ); $nWarDrawCount = odbc_result ( $rs , 'nWarDrawCount' ); $nType = odbc_result ( $rs, 'nType' ); switch($nType) { case 1: $nType = 'Warable'; break; case 0: $nType = 'Not Warable'; break; } $sID = str_replace ( 'ä' , 'ä' , str_replace ( 'Ä' , 'Ä' , str_replace ( 'ö' , 'ö' , str_replace ( 'Ö' , 'Ö' , str_replace ( 'ü' , 'ü' , str_replace ( 'Ü' , 'Ü' , str_replace ( 'ß' , 'ß' , $sID ) ) ) ) ) ) ); $sql4 = 'SELECT nNo FROM tGuild'; $rs4 = odbc_exec ( $odbc_link , $sql4 ); if ( !$rs4 ) { exit ( 'Error in SQL 4' ); } while (odbc_fetch_row($rs4)) { $nNo = odbc_result ($rs4, 'nNo' ); } $sql2 = 'SELECT * FROM tGuildMember WHERE nNo = '.$nNo; $rs2 = odbc_exec ( $odbc_link , $sql2 ); if ( !$rs2 ) { exit ( 'Error in SQL 2' ); } while ( odbc_fetch_row ( $rs2 )) { $nMembers = odbc_result ($rs2, 'nCharNo' ); } echo ' '; echo ' '; echo ' '; echo ' '; echo ' '; echo ' '; echo ' '; echo ' '; echo ' '; $i++; } odbc_close ( $odbc_link ); echo '

'; echo ' #'; echo '	'; echo ' Name'; echo '	'; echo ' Wins'; echo '	'; echo ' Loses'; echo '	'; echo ' Draws'; echo '	'; echo ' Type'; echo '	'; echo ' Members'; echo '
'; echo ' '.$i; echo '	'; echo ' '.$sName; echo '	'; echo ' '.$nWarWinCount; echo '	'; echo ' '.$nWarLoseCount; echo '	'; echo ' '.$nWarDrawCount; echo '	'; echo ' '.$nType; echo '	'; echo ' '.$nMembers; echo '