<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 11:
$class = 'Druid';
break;
}
Switch ($characters['zone'])
{
---ZONY--(smazano)
}
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>