<?  
$ip ="127.0.0.1"; // IP сервера  
$dbip ="127.0.0.1"; // IP mysql  
$dbport ="3306"; // порт mysql  
$gameport ="8085"; // игровой порт  
$dblogin ="login"; // логин mysql  
$dbpass ="password"; // пароль mysql  
$wdb ="world"; // название базы world  
$ldb ="logon"; // название базы logon  
$cdb ="character"; // название базы character  
?>  

<?  
require_once ('config.php');  
mysql_connect ("$dbip:$dbport","$dblogin","$dbpass");  
?>  

<?  
$fp = @fsockopen ("$ip","$gameport",$errno,$errstr,1);  
if ($fp)  
echo "Статус Сервера: online<br>";  
else  
echo "Статус Сервера: offline<br>";  
?>  

<?  
mysql_selectdb ($ldb);  
$acc = mysql_query ("select count(*) from accounts");  
$acc = mysql_result ($acc,0);  
mysql_selectdb ("$cdb");  
$char = mysql_query ("select count(*) from characters");  
$char = mysql_result ($char,0);  
$alliance = mysql_query ("select count(*) from characters where race in (1,3,4,7,11)");  
$alliance = mysql_result ($alliance,0);  
$horde = mysql_query ("select count(*) from characters where race in (2,5,6,8,10)");  
$horde = mysql_result ($horde,0);  
$guild = mysql_query ("select count(*) from guild");  
$guild = mysql_result ($guild,0);  

echo "Аккаунтов: $acc<br>";  
echo "Персонажей: $char<br>";  
echo "Альянса: $alliance<br>";  
echo "Орды: $horde<br>";  
echo "Гильдий: $guild<br>";  
?>  

<?  
mysql_selectdb ("$cdb");  
$online = mysql_query ("select count(*) from characters where online = 1");  
$online = mysql_result ($online,0);  
$allianceonline = mysql_query ("select count(*) from characters where online = 1 and race in (1,3,4,7,11)");  
$allianceonline = mysql_result ($allianceonline,0);  
$hordeonline = mysql_query ("select count(*) from characters where online = 1 and race in (2,5,6,8,10)");  
$hordeonline = mysql_result ($hordeonline,0);  
echo "Игроков Онлайн: $online<br>";  
echo "Альянса Онлайн: $allianceonline<br>";  
echo "Орды Онлайн: $hordeonline<br>";  
?>  

<?  
mysql_selectdb ("$cdb");  
$human = mysql_query ("select count(*) from characters where race = 1");  
$human = mysql_result ($human,0);  
$dwarv = mysql_query ("select count(*) from characters where race = 3");  
$dwarv = mysql_result ($dwarv,0);  
$night = mysql_query ("select count(*) from characters where race = 4");  
$night = mysql_result ($night,0);  
$gnome = mysql_query ("select count(*) from characters where race = 7");  
$gnome = mysql_result ($gnome,0);  
$draenei = mysql_query ("select count(*) from characters where race = 11");  
$draenei = mysql_result ($draenei,0);  
$orc = mysql_query ("select count(*) from characters where race = 2");  
$orc = mysql_result ($orc,0);  
$undead = mysql_query ("select count(*) from characters where race = 5");  
$undead = mysql_result ($undead,0);  
$tauren = mysql_query ("select count(*) from characters where race = 6");  
$tauren = mysql_result ($tauren,0);  
$troll = mysql_query ("select count(*) from characters where race = 8");  
$troll = mysql_result ($troll,0);  
$blood = mysql_query ("select count(*) from characters where race = 10");  
$blood = mysql_result ($blood,0);  
$druid = mysql_query ("select count(*) from characters where class = 11");  
$druid = mysql_result ($druid,0);  
$hunter = mysql_query ("select count(*) from characters where class = 3");  
$hunter = mysql_result ($hunter,0);  
$mage = mysql_query ("select count(*) from characters where class = 8");  
$mage = mysql_result ($mage,0);  
$paladin = mysql_query ("select count(*) from characters where class = 2");  
$paladin = mysql_result ($paladin,0);  
$priest = mysql_query ("select count(*) from characters where class = 5");  
$priest = mysql_result ($priest,0);  
$rogue = mysql_query ("select count(*) from characters where class = 4");  
$rogue = mysql_result ($rogue,0);  
$shaman = mysql_query ("select count(*) from characters where class = 7");  
$shaman = mysql_result ($shaman,0);  
$warlock = mysql_query ("select count(*) from characters where class = 9");  
$warlock = mysql_result ($warlock,0);  
$warrior = mysql_query ("select count(*) from characters where class = 1");  
$warrior = mysql_result ($warrior,0);  
$death = mysql_query ("select count(*) from characters where class = 6");  
$death = mysql_result ($death,0);  
echo "Людей: $human<br>";  
echo "Дворфов: $dwarv<br>";  
echo "Ночных Эльфов: $night<br>";  
echo "Гномов: $gnome<br>";  
echo "Дренейев: $draenei<br>";  
echo "Орков: $orc<br>";  
echo "Нежити: $undead<br>";  
echo "Тауренов: $tauren<br>";  
echo "Троллей: $troll<br>";  
echo "Эльфов Крови: $blood<br><br>";  
echo "Друидов: $druid<br>";  
echo "Охотников: $hunter<br>";  
echo "Магов: $mage<br>";  
echo "Паладинов: $paladin<br>";  
echo "Жрецов: $priest<br>";  
echo "Разбойников: $rogue<br>";  
echo "Шаманов: $shaman<br>";  
echo "Чернокнижников: $warlock<br>";  
echo "Воинов: $warrior<br>";  
echo "Рыцарей Смерти: $death<br>";  
?>  

<?  
mysql_selectdb ("$cdb");  
$race=mysql_query("SELECT `race`,`class` FROM characters");  
$human=0; $dwarv=0; $night=0; $gnome=0; $draenei=0; $orc=0; $undead=0; $tauren=0; $troll=0; $blood=0; //Приравниваем все рассы к 0.  
$druid=0; $hunter=0; $mage=0; $paladin=0; $priest=0; $rogue=0; $shaman=0; $warlock=0; $warrior=0; $death=0; //к нулю все классы  
while ($rc=mysql_fetch_array($race)){  
//Начинаем проверять на рассы  
if ($rc['race']=="1"){$human=$human + 1;}  
if ($rc['race']=="2"){$orc=$orc + 1;}  
if ($rc['race']=="3"){$dwarv=$dwarv + 1;}  
if ($rc['race']=="4"){$night=$night + 1;}  
if ($rc['race']=="5"){$undead=$undead + 1;}  
if ($rc['race']=="6"){$tauren=$tauren + 1;}  
if ($rc['race']=="7"){$gnome=$gnome + 1;}  
if ($rc['race']=="8"){$troll=$troll + 1;}  
if ($rc['race']=="10"){$blood=$blood + 1;}  
if ($rc['race']=="11"){$draenei=$draenei + 1;}  
//Проверяем на классы  
if ($rc['class']=="1"){$warrior=$warrior + 1;}  
if ($rc['class']=="2"){$paladin=$paladin + 1;}  
if ($rc['class']=="3"){$hunter=$hunter + 1;}  
if ($rc['class']=="4"){$rogue=$rogue + 1;}  
if ($rc['class']=="5"){$priest=priest + 1;}  
if ($rc['class']=="6"){$death=$death + 1;}  
if ($rc['class']=="7"){$shaman=$shaman + 1;}  
if ($rc['class']=="8"){$mage=$mage + 1;}  
if ($rc['class']=="9"){$warlock=$warlock + 1;}  
if ($rc['class']=="11"){$druid=$druid + 1;}  
}  
echo "Людей: $human<br>";  
echo "Дворфов: $dwarv<br>";  
echo "Ночных Эльфов: $night<br>";  
echo "Гномов: $gnome<br>";  
echo "Дренейев: $draenei<br>";  
echo "Орков: $orc<br>";  
echo "Нежити: $undead<br>";  
echo "Тауренов: $tauren<br>";  
echo "Троллей: $troll<br>";  
echo "Эльфов Крови: $blood<br><br>";  
echo "Друидов: $druid<br>";  
echo "Охотников: $hunter<br>";  
echo "Магов: $mage<br>";  
echo "Паладинов: $paladin<br>";  
echo "Жрецов: $priest<br>";  
echo "Разбойников: $rogue<br>";  
echo "Шаманов: $shaman<br>";  
echo "Чернокнижников: $warlock<br>";  
echo "Воинов: $warrior<br>";  
echo "Рыцарей Смерти: $death<br>";  
?>  

<table border="0">  
<tr>  
<td><strong>Имя:</strong></td>  
<td><strong>Раса:</strong></td>  
<td><strong>Класс:</strong></td>  
<td><strong>Уровень:</strong></td>  
</tr>  
<?  
mysql_selectdb ("$cdb");  
mysql_query ('set names cp1251');  
$result = mysql_query ("select name, race, class from characters where online = 1");  
$class = array  
(1=>"Воин",2=>"Паладин",3=>"Охотник",4=>"Разбойник",5=>"Жрец",6=>"Рыцарь Смерти",7=>"Шаман",8=>"Маг",9=>"Чернокнижник",11=>"Друид");  
$race = array  
(1=>"Человек",2=>"Орк",3=>"Дворф",4=>"Ночной Эльф",5=>"Нежить",6=>"Таурен",7=>"Гном",8=>"Тролль",10=>"Эльф Крови",11=>"Дреней");  
while ($row = mysql_fetch_array ($result))  
{  
$ch_name = $row['name'];  
$ch_race = $row['race'];  
$ch_class = $row['class'];  
$ch_lvl = $row[level];  
echo "<tr><td><strong>$ch_name</strong></td>";  
echo "<td><strong>$race[$ch_race]</strong></td>";  
echo "<td><strong>$class[$ch_class]</strong></td>";  
echo "<td><strong>$ch_lvl</strong></td></tr>";  
}  
?>  
</table>