takže udělej si config.php a vypln to ukazka
<?php
error_reporting(0);
$tbc_allowed = '1'; // pokud na serveru máte vyplé tbc, nastavte 0 (po mé uprávě už toto nefunguje)
$dbhost = 'localhost'; // standardně localhost (127.0.0.1)
$dbuser = 'root'; // uživatelské jméno pro přístup do db, defaultně 'root'
$dbpass = 'vase_heslo'; // heslo pro přístup do db
$dbname = 'realmd'; // databáze
$mangname = 'mangos'; // databáze
$charname = 'characters'; // databáze
$servername = 'jmeno'; // Jméno serveru
$ip = "ip_serveru"; // IP Serveru
$db = mysql_connect($dbhost, $dbuser, $dbpass) or print("Nepodařilo se přihlásit do databáze. Server je zřejmě offline.") AND $chyba = 1;
mysql_select_db($dbname);
################################################################################
?>
online list i když ty obrazky měl někde sehnat nebo to tam bude ukazuje i misto
<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`, ' ', 54), ' ', -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 6:
$class = 'Death Knight';
break;
Case 7:
$class = 'Shaman';
break;
Case 8:
$class = 'Mage';
break;
Case 9:
$class = 'Warlock';
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 = 'Dragonblight'; break;
Case 66: $zone = 'Zul Drak'; break;
Case 67: $zone = 'Storm Peaks'; 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 = 'Icecrown'; 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 = 'Howling Fjord'; 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 = 'Crystalsong Forest'; 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 = 'Borean Tundra'; 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 = 'Sholazar Basin'; 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 4298: $zone = 'Death Knight Start'; 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>