'; 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 TOP 100 sID, nPKCount FROM tCharacter WHERE nAdminLevel = 0 AND bDeleted = 0 ORDER BY nPKCount DESC'; $rs = odbc_exec ( $odbc_link , $sql ); if ( !$rs ) { exit ( 'Error in SQL' ); } $i = 1; echo ''; echo ' '; echo ' '; echo ' '; echo ' '; echo ' '; while ( odbc_fetch_row ( $rs ) ) { $sID = odbc_result ( $rs , 'sID' ); $nPKCount = odbc_result ( $rs , 'nPKCount' ); $sID = str_replace ( 'ä' , 'ä' , str_replace ( 'Ä' , 'Ä' , str_replace ( 'ö' , 'ö' , str_replace ( 'Ö' , 'Ö' , str_replace ( 'ü' , 'ü' , str_replace ( 'Ü' , 'Ü' , str_replace ( 'ß' , 'ß' , $sID ) ) ) ) ) ) ); echo ' '; echo ' '; echo ' '; echo ' '; echo ' '; $i++; } odbc_close ( $odbc_link ); echo '

'; echo ' #'; echo '	'; echo ' Name'; echo '	'; echo ' Kills'; echo '
'; echo ' '.$i; echo '	'; echo ' '.$sID; echo '	'; echo ' '.$nPKCount; echo '

PvP Rankings