<?php  

    // CONFIG 
    include '../inc/config.php';
    // CONFIG END 
     
    echo '<div class="box"><div class="header"><h2><center>Online Players</div><div class="pad"></center></h2>'; 
    $odbc_link = odbc_connect ( "Driver={SQL Server};Server=".$odbc_host.";Database=w00_Character;" , $odbc_user , $odbc_pass ); 
     
    $sql[1] = 'SELECT  nCharNo, sID, nExp , nLevel, nAdminLevel FROM LoggedInChars ORDER  BY nExp DESC'; 
    $rs[1] = odbc_exec ( $odbc_link , $sql[1] ); 
    if ( !$rs[1] ) 
        { 
        exit ( 'Error in SQL' ); 
        } 
     
	
    $i = 1; 
         
    echo '<table width="105%">'; 
    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 '            Admin Level'; 
    echo '        </td>'; 
    echo '        <td>'; 
    echo '            Guild'; 
    echo '        </td>';
    echo '        <td>'; 
    echo '            Location'; 
    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' ); 
		$nAdminLevel = odbc_result ( $rs[1], 'nAdminLevel' );
        $nName = 'No Guild'; 
        $sID = str_replace ( 'ä' , '&auml;' , str_replace ( 'Ä' , '&Auml;' , str_replace ( 'ö' , '&ouml;' , str_replace ( 'Ö' , '&Ouml;' , str_replace ( 'ü' , '&uuml;' , str_replace ( 'Ü' , '&Uuml;' , str_replace ( 'ß' , '&szlig;' , $sID ) ) ) ) ) ) ); 
         
        $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' ); 
            }
			
		$sql[5] = 'SELECT sLoginZone FROM tCharacter WHERE nAdminLevel = 0 AND nCharNo = '.$nCharNo;
		$rs[5] = odbc_exec ( $odbc_link, $sql[5] );
		if ( !$rs[5] ) 
			{ 
			exit ( 'Error in SQL 5' ); 
			} 	
		while ( odbc_fetch_row ( $rs[5] ))
			{
			$sLoginZone = odbc_result ( $rs[5], 'sLoginZone' );
			}
	
	
		 
        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; 
            } 
			
			switch($sLoginZone)
			{
			case 'RouN':
				$sLoginZone = 'Roumen';
				break;
			case 'Rou':
				$sLoginZone = 'Roumen';
				break;
			case 'RouCos01':
				$sLoginZone = 'Sand Beach';
				break;
			case 'RouCos02':
				$sLoginZone = 'Forest of Tides';
				break;
			case 'RouCos03':
				$sLoginZone = 'Sea of Greed';
				break;
			case 'RouVal01':
				$sLoginZone = 'Forest of Mist';
				break;
			case 'RouVal02':
				$sLoginZone = 'Burning Hill';
				break;
			case 'RouTemDn01':
				$sLoginZone = 'Luminous Stone 1';
				break;
			case 'RouTemDn02':
				$sLoginZone = 'Luminous Stone 2';
				break;
			case 'Eld':
				$sLoginZone = 'Elderine';
				break;
			case 'EldCem01':
				$sLoginZone = 'Moonlight Tomb';
				break;
			case 'EldCem02':
				$sLoginZone = 'Vine Tomb';
				break;
			case 'EldGbl01':
				$sLoginZone = 'Goblin Camp';
				break;
			case 'EldPri01':
				$sLoginZone = 'Collapsed Prison';
				break;
			case 'EldPriDn01':
				$sLoginZone = 'Concealed Prison 1st Floor';
				break;
			case 'EldFor01':
				$sLoginZone = 'Anicent Eleven Woods';
				break;
			case 'EldSleep01':
				$sLoginZone = 'Forest of Slumber';
				break;
			case 'Urg':
				$sLoginZone = 'Uruga';
				break;
			case 'KDPrtShip':
				$sLoginZone = "Captain Mara's Pirate Ship";
				break;
			case 'KDEddyHill':
				$sLoginZone = 'Cyclone Hill';
				break;
			case 'EchoCave':
				$sLoginZone = 'Echo Cave';
				break;
			case 'KDTrDn':
				$sLoginZone = 'Adventurer Dungeon';
				break;
			case 'KDUnHall':
				$sLoginZone = 'Underground Square';
				break;
			case 'KDEnMaze':
				$sLoginZone = 'Endless Maze';
				break;
			case 'KDGoldHill':
				$sLoginZone = 'Golden Hill';
				break;
			case 'EldPri':
				$sLoginZone = 'Restricted Area';
				break;
			case 'Job1_Dn01':
				$sLoginZone = 'Shadow Dungeon';
				break;
			case 'WindyCave':
				$sLoginZone = 'Cave of Wind';
				break;
			case 'KDMDragon':
				$sLoginZone = 'Rock Valley';
				break;
			case 'EldPriDn02':
				$sLoginZone = 'Concealed Prison 2nd Floor';
				break;
			case 'Job2_Dn01':
				$sLoginZone = 'Forgotton Relics';
				break;
			case 'Job2_Dn02':
				$sLoginZone = 'Ancient Elven Woods';
				break;
			case 'Job2_TimeG':
				$sLoginZone = 'Time Gap';
				break;
			case 'ValDn01':
				$sLoginZone = "Marlone Clan's Hideout";
				break;
			case 'CemDn01':
				$sLoginZone = 'Graveyard of the Dead';
				break;
			case 'GblDn01':
				$sLoginZone = 'Concealed Peak';
				break;
			case 'ElfDn01':
				$sLoginZone = 'Land of Trails';
				break;
			case 'GoldCave':
				$sLoginZone = 'Golden Cave';
				break;
			case 'PriDn01':
				$sLoginZone = 'Bonds of Darkness';
				break;
			case 'ForDn01':
				$sLoginZone = 'Trumpy Remains';
				break;
			case 'KDHero':
				$sLoginZone = "Warrior's Hall of Trials";
				break;
			case 'KDKingkong':
				$sLoginZone = 'Elven Woods';
				break;
			case 'KDHoneying':
				$sLoginZone = 'Spiral Hill';
				break;
			case 'KDSpider':
				$sLoginZone = 'Underground Square of Horror';
				break;			
			case 'GblDn02':
				$sLoginZone = 'Abysmal Summit';
				break;			
			case 'ElfDn02':
				$sLoginZone = 'Dungeon of the Abyss';
				break;
			case 'PriDn02':
				$sLoginZone = 'Passage of the Abyss';
				break;
			case 'UrgFire01':
				$sLoginZone = 'Burning Rock';
				break;
			case 'GuildT01':
				$sLoginZone = 'Guild Tournament 1';
				break;
			case 'GuildT02':
				$sLoginZone = 'Guild Tournament 2';
				break;
			case 'GuildT03':
				$sLoginZone = 'Guild Tournament 3';
				break;
			case 'FireDn01':
				$sLoginZone = "Guardian's Holy Shrine";
				break;
			case 'SwaDn01':
				$sLoginZone = "Tear's Marsh";
				break;
			case 'UrgFireDn01':
				$sLoginZone = 'Flaming Mine';
				break;
			case 'UrgSwaDn01':
				$sLoginZone = 'Temple of Spirit';
				break;
			case 'Fbattle01':
				$sLoginZone = 'Free Battle Zone 1';
				break;
			case 'Fbattle02':
				$sLoginZone = 'Free Battle Zone 2';
				break;
			case 'Fbattle03':
				$sLoginZone = 'Free Battle Zone 3';
				break;
			case 'MHBasic':
				$sLoginZone = 'Estate';
				break;
			case 'R_Helga01':
				$sLoginZone = "Helga's Tomb";
				break;
			case 'UrgSwa01':
				$sLoginZone = 'Swamp of Dawn';
				break;
			case 'CemDn02':
				$sLoginZone = 'Grave of the Abyss';
				break;
			case 'EldGbl02':
				$sLoginZone = 'Sand Hill';
				break;
			case 'EldPri02':
				$sLoginZone = 'Execution Ground';
				break;			
			case 'Wedding':
				$sLoginZone = 'Blessed Garden';
				break;			
			case 'OX_field':
				$sLoginZone = 'OX Quiz Field';
				break;
			case 'Linkfield01':
				$sLoginZone = 'Dark Passage II';
				break;
			case 'Linkfield02':
				$sLoginZone = 'Dark Passage I';
				break;
			case 'BFGate01':
				$sLoginZone = 'Forest Perimeter';
				break;			
			case 'BFGate02':
				$sLoginZone = 'Forest Perimeter';
				break;
			case 'ValDn02':
				$sLoginZone = 'Abysmal Cave';
				break;				
			case 'ForDn02':
				$sLoginZone = 'Relic of the Abyss';
				break;
			case 'FireDn02':
				$sLoginZone = 'Holy Place of the Abyss';
				break;
			case 'KDHDragon':
				$sLoginZone = 'Rock Valley';
				break;
			case 'KDHBat1':
				$sLoginZone = 'Warrior Arena';
				break;
			case 'UrgDragon':
				$sLoginZone = "Dragon's Tomb";
				break;
			case 'KDVictor':
				$sLoginZone = 'Fortress of Shadows';
				break;
			case 'KDAntiHenis':
				$sLoginZone = 'Anti-Henneath Hideout';
				break;
			case 'AlDn01':
				$sLoginZone = 'Origin of Life Tree';
				break;
			case 'Urg_Alruin':
				$sLoginZone = 'Alberstol Ruins';
				break;
			case 'SwaDn02':
				$sLoginZone = 'Abyss Marsh';
				break;
			case 'Tower01':
				$sLoginZone = 'Tower of Iyzel';
				break;
			case 'GuildT04':
				$sLoginZone = 'Guild Tournament';
				break;
			case 'Tower02':
				$sLoginZone = 'Crystal Castle';
				break;
			case 'AdlThorn01':
				$sLoginZone = 'Thorn Cave';
				break;
			case 'Leviathan':
				$sLoginZone = 'Leviathan Nest';
				break;
			case 'IDGate01':
				$sLoginZone = 'Secret Basement';
				break;
			case 'QField01':
				$sLoginZone = 'Cave of Memories';
				break;
			case 'QField02':
				$sLoginZone = 'Dangerous Cave';
				break;
			case 'Tower3':
				$sLoginZone = 'Secret Laboratory';
				break;
			case 'UrgDark01':
				$sLoginZone = 'Dark Land';
				break;
			case 'B_Cracker':
				$sLoginZone = "Malephar's Lair";
				break;
			case 'QField03':
				$sLoginZone = 'Cave of Fever';
				break;
			case 'QField04':
				$sLoginZone = 'Burning Cave';
				break;
			case 'AlDn02':
				$sLoginZone = 'Tree of Abyss';
				break;
			case 'BFGate03':
				$sLoginZone = 'Forest Perimeter';
				break;
			case 'GBHouse':
				$sLoginZone = 'Lucky House';
				break;
			case 'Bera':
				$sLoginZone = 'Bera';
				break;
			case 'BerKal01':
				$sLoginZone = 'Kahal Plains';
				break;
			case 'Croad01':
				$sLoginZone = 'Cross Road 2';
				break;
			case 'Croad01D':
				$sLoginZone = 'Cross Road 2';
				break;
			case 'UrgD':
				$sLoginZone = 'Stone Field';
				break;
			case 'DarkTown':
				$sLoginZone = 'Dark Town';
				break;
			case 'DarkCave':
				$sLoginZone = 'Dark Cave';
				break;
			case 'RouO':
				$sLoginZone = 'Ancient Roumen';
				break;
			case 'BH_Helga':
				$sLoginZone = "Helga's Tomb (Hard)";
				break;
			case 'BH_Cracker':
				$sLoginZone = "Malephar's Lair (Hard)";
				break;
			case 'LField02D':
				$sLoginZone = "Enticing Vines";
				break;
			case 'EldPri02D':
				$sLoginZone = "Enticing Prison";
				break;
			case 'EldGbl01D':
				$sLoginZone = "Golbin Relic";
				break;
			case 'Adl':
				$sLoginZone = "Adealia";
				break;
			case 'PsyIn':
				$sLoginZone = "Psiken Mansion";
				break;
			case 'PsyOut':
				$sLoginZone = "Psiken Garden";
				break;
			case 'ID_Cracker':
				$sLoginZone = "Malephar's Lair (Instace)";
				break;
			case 'KDSiege':
				$sLoginZone = "Mountain of Insanity";
				break;
			case 'ExpLoss':
				$sLoginZone = "Exp Loss Area";
				break;
			case 'Noitome':
				$sLoginZone = "Noitome's Lair";
				break;
			case 'GreenHouse':
				$sLoginZone = "Green House";
				break;
			case 'AngelsDen':
				$sLoginZone = "Angel's Den";
				break;

			default:
				$sLoginZone = "Everywhere";
				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 '            '.$nAdminLevel; 
        echo '        </td>'; 
        echo '        <td>'; 
        echo '            '.$nName; 
        echo '        </td>'; 
        echo '        <td>'; 
        echo '            '.$sLoginZone; 
        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 ' Admin Level'; echo '	'; echo ' Guild'; echo '	'; echo ' Location'; echo '
'; echo ' '.$i; echo '	'; echo ' '.$sID; echo '	'; echo ' '.$nExp; echo '	'; echo ' '.$nLevel; echo '	'; echo ' '.$nClass; echo '	'; echo ' '.$nAdminLevel; echo '	'; echo ' '.$nName; echo '	'; echo ' '.$sLoginZone; echo '