rendered paste body<h1>Online Hráči</h1> <center> <?php include "config.php"; mysql_select_db($charname); $a = 0; $aliance = 0; $horda = 0; $icon = 3; echo "<table cellspacing=0 cellpadding=0><tr><td class='online0'>Úroveň</td><td class='online0'>Jméno</td><td class='online0'>Rasa</td><td class='online0'>Povolání</td><td class='online0'>Lokace</td></tr>"; $getCharacters = mysql_query("SELECT * FROM characters WHERE online = 1 ORDER BY CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 35), ' ', -1) AS UNSIGNED) DESC"); while($characters = mysql_fetch_array($getCharacters)) { $getLevel = mysql_query("SELECT CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 35), ' ', -1) AS UNSIGNED) AS `level` FROM `characters` WHERE `guid` = $characters[guid]"); $level = mysql_fetch_array($getLevel); Switch ($characters['race']) { Case 1: $race = 'Human'; $icon = 1; $aliance++; break; Case 2: $race = 'Orc'; $icon = 0; $horda++; break; Case 3: $race = 'Dwarf'; $icon = 1; $aliance++; break; Case 4: $race = 'Night Elf'; $icon = 1; $aliance++; break; Case 5: $race = 'Undead'; $icon = 0; $horda++; break; Case 6: $race = 'Tauren'; $icon = 0; $horda++; break; Case 7: $race = 'Gnome'; $icon = 1; $aliance++; break; Case 8: $race = 'Troll'; $icon = 0; $horda++; break; Case 10: $race = 'Blood Elf'; $icon = 0; $horda++; break; Case 11: $race = 'Draenei'; $icon = 1; $aliance++; break; } Switch ($characters['class']) { Case 1: $class = 'Warrior'; break; Case 2: $class = 'Paladin'; break; Case 3: $class = 'Hunter'; break; Case 4: $class = 'Rogue'; break; Case 5: $class = 'Priest'; break; Case 7: $class = 'Shaman'; break; Case 8: $class = 'Mage'; break; Case 9: $class = 'Warlock'; break; Case 10: $class = 'Death Knight'; break; Case 11: $class = 'Druid'; break; } Switch ($characters['zone']) { Case 1: $zone = 'Dun Morogh'; break; Case 3: $zone = 'Badlands'; break; Case 4: $zone = 'Blasted Lands'; break; Case 8: $zone = 'Swamp of Sorrows'; break; Case 10: $zone = 'Duskwood'; break; Case 11: $zone = 'Wetlands'; break; Case 12: $zone = 'Elwynn Forest'; break; Case 14: $zone = 'Durotar'; break; Case 15: $zone = 'Dustwallow Marsh'; break; Case 16: $zone = 'Azshara'; break; Case 17: $zone = 'The Barrens'; break; Case 21: $zone = 'Kul Tiras'; break; Case 22: $zone = 'Programmer Isle'; break; Case 25: $zone = 'Blackrock Mountain'; break; Case 28: $zone = 'Western Plaguelands'; break; Case 30: $zone = 'Nine'; break; Case 33: $zone = 'Stranglethorn Vale'; break; Case 36: $zone = 'Alterac Mountains'; break; Case 38: $zone = 'Loch Modan'; break; Case 40: $zone = 'Westfall'; break; Case 41: $zone = 'Deadwind Pass'; break; Case 44: $zone = 'Redridge Mountains'; break; Case 45: $zone = 'Arathi Highlands'; break; Case 46: $zone = 'Burning Steppes'; break; Case 47: $zone = 'The Hinterlands'; break; Case 51: $zone = 'Searing Gorge'; break; Case 65: $zone = 'Reuse Me 3'; break; Case 66: $zone = 'Reuse Me 6'; break; Case 67: $zone = 'Reuse Me 5'; break; Case 85: $zone = 'Tirisfal Glades'; break; Case 130: $zone = 'Silverpine Forest'; break; Case 139: $zone = 'Eastern Plaguelands'; break; Case 141: $zone = 'Teldrassil'; break; Case 148: $zone = 'Darkshore'; break; Case 151: $zone = 'Designer Island'; break; Case 170: $zone = 'Lordamere Lake'; break; Case 206: $zone = 'UNUSED Westfall'; break; Case 207: $zone = 'The Great Sea'; break; Case 208: $zone = 'Unused Ironcladcove'; break; Case 209: $zone = 'Shadowfang Keep'; break; Case 210: $zone = 'Reuse Me 2'; break; Case 214: $zone = 'The Great Sea'; break; Case 215: $zone = 'Mulgore'; break; Case 267: $zone = 'Hillsbrad Foothills'; break; Case 268: $zone = 'Azshara Crater'; break; Case 269: $zone = 'Dun Algaz'; break; Case 276: $zone = 'UNUSED Stonewrought Pass'; break; Case 293: $zone = 'Thoradin`s Wall'; break; Case 296: $zone = 'South Seas UNUSED'; break; Case 308: $zone = 'The Forbidding Sea'; break; Case 330: $zone = 'Thandol Span'; break; Case 331: $zone = 'Ashenvale'; break; Case 332: $zone = 'The Great Sea'; break; Case 357: $zone = 'Feralas'; break; Case 361: $zone = 'Felwood'; break; Case 377: $zone = 'Southfury River'; break; Case 394: $zone = 'Darrowmere Lake UNUSED'; break; Case 400: $zone = 'Thousand Needles'; break; Case 405: $zone = 'Desolace'; break; Case 406: $zone = 'Stonetalon Mountains'; break; Case 408: $zone = 'Gillijim`s Isle'; break; Case 409: $zone = 'Island of Doctor Lapidis'; break; Case 440: $zone = 'Tanaris'; break; Case 457: $zone = 'The Veiled Sea'; break; Case 490: $zone = 'Un`Goro Crater'; break; Case 491: $zone = 'Razorfen Kraul'; break; Case 493: $zone = 'Moonglade'; break; Case 495: $zone = 'DELETE ME'; break; Case 616: $zone = 'Hyjal'; break; Case 618: $zone = 'Winterspring'; break; Case 676: $zone = 'Outland'; break; Case 717: $zone = 'The Stockade'; break; Case 718: $zone = 'Wailing Caverns'; break; Case 719: $zone = 'Blackfathom Deeps'; break; Case 721: $zone = 'Gnomeregan'; break; Case 722: $zone = 'Razorfen Downs'; break; Case 796: $zone = 'Scarlet Monastery'; break; Case 876: $zone = 'GM Island'; break; Case 956: $zone = 'The Verdant Fields'; break; Case 1176: $zone = 'Zul`Farrak'; break; Case 1196: $zone = 'UNUSEDAlcaz Island'; break; Case 1337: $zone = 'Uldaman'; break; Case 1377: $zone = 'Silithus'; break; Case 1397: $zone = 'Emerald Forest'; break; Case 1417: $zone = 'Sunken Temple'; break; Case 1477: $zone = 'The Temple of Atal`Hakkar'; break; Case 1497: $zone = 'Undercity'; break; Case 1519: $zone = 'Stormwind City'; break; Case 1537: $zone = 'Ironforge'; break; Case 1579: $zone = 'Unused The Deadmines 002'; break; Case 1581: $zone = 'The Deadmines'; break; Case 1583: $zone = 'Blackrock Spire'; break; Case 1584: $zone = 'Blackrock Depths'; break; Case 1637: $zone = 'Orgrimmar'; break; Case 1638: $zone = 'Thunder Bluff'; break; Case 1657: $zone = 'Darnassus'; break; Case 1941: $zone = 'Caverns of Time'; break; Case 1977: $zone = 'Zul`Gurub'; break; Case 2017: $zone = 'Stratholme'; break; Case 2037: $zone = 'Quel`thalas'; break; Case 2057: $zone = 'Scholomance'; break; Case 2100: $zone = 'Maraudon'; break; Case 2159: $zone = 'Onyxia`s Lair'; break; Case 2257: $zone = 'Deeprun Tram'; break; Case 2280: $zone = 'UNUSED Stratholme'; break; Case 2366: $zone = 'The Black Morass'; break; Case 2367: $zone = 'Old Hillsbrad Foothills'; break; Case 2437: $zone = 'Ragefire Chasm'; break; Case 2557: $zone = 'Dire Maul'; break; Case 2597: $zone = 'Alterac Valley'; break; Case 2677: $zone = 'Blackwing Lair'; break; Case 2717: $zone = 'Molten Core'; break; Case 2817: $zone = 'Reuse Me 4'; break; Case 2917: $zone = 'Hall of Legends'; break; Case 2918: $zone = 'Champions` Hall'; break; Case 3277: $zone = 'Warsong Gulch'; break; Case 3358: $zone = 'Arathi Basin'; break; Case 3428: $zone = 'Ahn`Qiraj'; break; Case 3429: $zone = 'Ruins of Ahn`Qiraj'; break; Case 3430: $zone = 'Eversong Woods'; break; Case 3433: $zone = 'Ghostlands'; break; Case 3455: $zone = 'The North Sea'; break; Case 3456: $zone = 'Naxxramas'; break; Case 3457: $zone = 'Karazhan'; break; Case 3459: $zone = 'City'; break; Case 3477: $zone = 'Karazhan *UNUSED*'; break; Case 3478: $zone = 'Gates of Ahn`Qiraj'; break; Case 3479: $zone = 'The Veiled Sea'; break; Case 3483: $zone = 'Hellfire Peninsula'; break; Case 3487: $zone = 'Silvermoon City'; break; Case 3518: $zone = 'Nagrand'; break; Case 3519: $zone = 'Terokkar Forest'; break; Case 3520: $zone = 'Shadowmoon Valley'; break; Case 3521: $zone = 'Zangarmarsh'; break; Case 3522: $zone = 'Blade`s Edge Mountains'; break; Case 3523: $zone = 'Netherstorm'; break; Case 3524: $zone = 'Azuremyst Isle'; break; Case 3525: $zone = 'Bloodmyst Isle'; break; Case 3535: $zone = 'Hellfire Citadel'; break; Case 3537: $zone = 'REUSE'; break; Case 3540: $zone = 'Twisting Nether'; break; Case 3557: $zone = 'The Exodar'; break; Case 3562: $zone = 'Hellfire Ramparts'; break; Case 3605: $zone = 'Hyjal Past'; break; Case 3606: $zone = 'Hyjal Summit'; break; Case 3607: $zone = 'Serpentshrine Cavern'; break; Case 3698: $zone = 'Nagrand Arena'; break; Case 3702: $zone = 'Blade`s Edge Arena'; break; Case 3703: $zone = 'Shattrath City'; break; Case 3711: $zone = 'Reuse Me'; break; Case 3713: $zone = 'The Blood Furnace'; break; Case 3714: $zone = 'The Shattered Halls'; break; Case 3715: $zone = 'The Steamvault'; break; Case 3716: $zone = 'The Underbog'; break; Case 3717: $zone = 'The Slave Pens'; break; Case 3789: $zone = 'Shadow Labyrinth'; break; Case 3790: $zone = 'Auchenai Crypts'; break; Case 3791: $zone = 'Sethekk Halls'; break; Case 3792: $zone = 'Mana-Tombs'; break; Case 3805: $zone = 'Zul`Aman'; break; Case 3817: $zone = 'Testing'; break; Case 3820: $zone = 'Eye of the Storm'; break; Case 3836: $zone = 'Magtheridon`s Lair'; break; Case 3845: $zone = 'Tempest Keep'; break; Case 3847: $zone = 'The Botanica'; break; Case 3848: $zone = 'The Arcatraz'; break; Case 3849: $zone = 'The Mechanar'; break; Case 3917: $zone = 'Auchindoun'; break; Case 3923: $zone = 'Gruul`s Lair'; break; Case 3948: $zone = 'Brian and Pat Test'; break; Case 3959: $zone = 'Black Temple'; break; Case 3968: $zone = 'Ruins of Lordaeron'; break; Case 3537: $zone = 'Borean Tundra'; break; Case 2817: $zone = 'Crystalsong Forest'; break; Case 4395: $zone = 'Dalaran'; break; Case 65: $zone = 'Dragonblight'; break; Case 394: $zone = 'Grizzly Hills'; break; Case 210: $zone = 'Icecrown'; break; Case 3711: $zone = 'Sholazar Basin'; break; Case 4197: $zone = 'Wintergrasp'; break; Case 66: $zone = 'Zul\'Drak'; break; Case 3537: $zone = 'Borean Tundra'; break; Case 67: $zone = 'Storm Peaks'; break; Case 495: $zone = 'Howling Fjord'; break; } if ($a == 0) { echo '<tr><td class="online">'.$level['level'].'</font><td class="online">'.$characters['name'].'</font></td><td class="online">'.$race.'</td><td class="online">'.$class.'</td><td class="online">'.$zone.'</td></tr>'; $a++; } else { echo '<tr><td class="online2">'.$level['level'].'</font><td class="online2">'.$characters['name'].'</font></td><td class="online2">'.$race.'</td><td class="online2">'.$class.'</td><td class="online2">'.$zone.'</td></tr>'; $a--; } } echo "<table cellspacing=0 cellpadding=0><tr><td class='online0' colspan=5 style='width: 550px;'>Celkem je online ".($aliance + $horda)." hráčů, z toho ".$aliance." Aliance a ".$horda." Horda.</td></tr></table><br><br>"; ?> </center>