<?php  

    // CONFIG 
	include '../inc/config.php';
    // CONFIG END 
     
    echo '<div class="box"><div class="header"><h2><center>Character Rankings</div><div class="pad"><br /></center></h2>'; 
	echo '<center><a href="?page=rankings">Character Rankings</a>&nbsp;|&nbsp; <a href="?page=guilds">Guild Rankings</a>&nbsp;|&nbsp; <a href="?page=pvp">PVP Rankings</a>';
	echo '<br><br>';
    $odbc_link = odbc_connect ( "Driver={SQL Server};Server=".$odbc_host.";Database=w00_Character;" , $odbc_user , $odbc_pass ); 
     
    $sql[1] = 'SELECT TOP 100 nCharNo, sID, nExp , nLevel FROM tCharacter WHERE nAdminLevel = 0 AND bDeleted = 0 ORDER  BY nExp DESC'; 
    $rs[1] = odbc_exec ( $odbc_link , $sql[1] ); 
    if ( !$rs[1] ) 
        { 
        exit ( 'Error in SQL' ); 
        } 
     
    $i = 1; 
         
    echo '<table width="100%">'; 
    echo '    <tr>'; 
    echo '        <td>'; 
    echo '            #'; 
    echo '        </td>'; 
    echo '        <td>'; 
    echo '            Name'; 
    echo '        </td>'; 
    echo '        <td>'; 
    echo '            Exp'; 
    echo '        </td>'; 
    echo '        <td>'; 
    echo '            Level'; 
    echo '        </td>'; 
    echo '        <td>'; 
    echo '            Class'; 
    echo '        </td>'; 
    echo '        <td>'; 
    echo '            Guild'; 
    echo '        </td>'; 
    echo '    </tr>'; 
    while ( odbc_fetch_row ( $rs[1] ) ) 
        { 
        $sID = odbc_result ( $rs[1] , 'sID' ); 
        $nExp = odbc_result ( $rs[1] , 'nExp' ); 
        $nLevel = odbc_result ( $rs[1] , 'nLevel' ); 
        $nName = 'No Guild'; 
        
        $nCharNo = odbc_result ( $rs[1] , 'nCharNo' ); 
         
        $sql[2] = 'SELECT TOP 1 nNo FROM tGuildMember WHERE nCharNo = '.$nCharNo; 
        $rs[2] = odbc_exec ( $odbc_link , $sql[2] ); 
        if ( !$rs[2] ) 
            { 
            exit ( 'Error in SQL' ); 
            } 
			
			  while ( odbc_fetch_row ( $rs[2] ) ) 
            { 
            $nNo = odbc_result ( $rs[2] , 'nNo' ); 
            $sql[3] = 'SELECT TOP 1 sName FROM tGuild WHERE nNo = '.$nNo; 
            $rs[3] = odbc_exec ( $odbc_link , $sql[3] ); 
            while ( odbc_fetch_row ( $rs[3] ) ) 
                { 
                $nName = odbc_result ( $rs[3] , 'sName' ); 
                } 
            } 
             
        $sql[4] = 'SELECT TOP 1 nClass FROM tCharacterShape WHERE nCharNo = '.$nCharNo; 
        $rs[4] = odbc_exec ( $odbc_link , $sql[4] ); 
        if ( !$rs[4] ) 
            { 
            exit ( 'Error in SQL' ); 
            } 
        while ( odbc_fetch_row ( $rs[4] ) ) 
            { 
            $nClass = odbc_result ( $rs[4] , 'nClass' ); 
            } 
         
		 
        switch ($nClass) 
            { 
            //Fighter 
            case 1: 
                $nClass = 'Fighter'; 
                break; 
            case 2: 
                $nClass = 'Clever Fighter'; 
                break; 
            case 3: 
                $nClass = 'Warrior'; 
                break; 
            case 4: 
                $nClass = 'Gladiator'; 
                break; 
            case 5: 
                $nClass = 'Knight'; 
                break; 
             
            //Cleric    
            case 6: 
                $nClass = 'Cleric'; 
                break; 
            case 7: 
                $nClass = 'High Cleric'; 
                break; 
            case 8: 
                $nClass = 'Paladin'; 
                break; 
            case 9: 
                $nClass = 'Holyknight'; 
                break; 
            case 10: 
                $nClass = 'Guardian'; 
                break; 
             
            //Archer 
            case 11: 
                $nClass = 'Archer'; 
                break; 
            case 12: 
                $nClass = 'Hawk Archer'; 
                break; 
            case 13: 
                $nClass = 'Scout'; 
                break; 
            case 14: 
                $nClass = 'SharpShooter'; 
                break; 
            case 15: 
                $nClass = 'Ranger'; 
                break; 
             
            //Mage     
            case 16: 
                $nClass = 'Mage'; 
                break; 
            case 17: 
                $nClass = 'Wiz Mage'; 
                break; 
            case 18: 
                $nClass = 'Enhancter'; 
                break; 
            case 19: 
                $nClass = 'Warlock'; 
                break; 
            case 20: 
                $nClass = 'Wizard'; 
                break; 
				
			//Trickster
			case 21:
				$nClass = 'Trickster';
				break;
			case 22:
				$nClass = 'Gambit';
				break;
			case 23:
				$nClass = 'Renegade';
				break;	
			case 24:
				$nClass = 'Spectre';
				break;	
			case 25:
				$nClass = 'Reaper';
				break;	
             
            //Standard     
            default: 
                $nClass = 'Unknown Class'; 
                break; 
            } 
         
        echo '    <tr>'; 
        echo '        <td>'; 
        echo '            '.$i; 
        echo '        </td>'; 
        echo '        <td>'; 
        echo '            '.$sID; 
        echo '        </td>';  
        echo '        <td>'; 
        echo '            '.$nExp;   
        echo '        </td>'; 
        echo '        <td>'; 
        echo '            '.$nLevel; 
        echo '        </td>'; 
        echo '        <td>'; 
        echo '            '.$nClass; 
        echo '        </td>'; 
        echo '        <td>'; 
        echo '            '.$nName; 
        echo '        </td>'; 
        echo '    </tr>'; 
         
        $i++; 
        } 
         
    odbc_close ( $odbc_link ); 
     
    echo '</table></div></div>'; 

?>
'; echo ' #'; echo '	'; echo ' Name'; echo '	'; echo ' Exp'; echo '	'; echo ' Level'; echo '	'; echo ' Class'; echo '	'; echo ' Guild'; echo '
'; echo ' '.$i; echo '	'; echo ' '.$sID; echo '	'; echo ' '.$nExp; echo '	'; echo ' '.$nLevel; echo '	'; echo ' '.$nClass; echo '	'; echo ' '.$nName; echo '