<div class="panel "" title="Server #*">   
<div class="wrapper">   
<h3>Онлайн сервера MaNGOS*</h3>   

<table width=40% border=0 cellpadding=4>   
<tr><td width="40%" align=right>Логин сервер:</td><td align="left"><span class="on"><? echo "$gamen"; ?></span></td></tr>   
<tr><td align=right style="padding-bottom: 15px;">Игровой сервер:</td><td valign="top" align="left"><span class="on"><? echo "$gamen"; ?></span></td></tr>   
<tr><td align=right>Онлайн игроков:</td><td align="left" valign="top" class="online"><font color=#000000><b><? echo "$online"; ?></font></b></td></tr>   
</table>   
<br/>   


<a href="http://localhost/lk/">Вход в личный кабинет MaNGOS</a></p>   


<a href="http://localhost/reg/">Регистрация нового аккаунта</a></p>   

</div>   
</div>

<?php   

include('config.php');   

$characters = mysql_connect("$host:$port", "$login", "$pass") or die('Нет конекта к MySQL серверу');   

mysql_selectdb("$dbc2", $characters) or die('Нет конекта к базе Characters');   
;   

$clases = array(   
1 => "Воин",   
2 => "Паладин",   
3 => "Охотник",   
4 => "Разбойник",   
5 => "Жрец",   
6 => "Рыцарь Смерти",   
7 => "Шаман",   
8 => "Маг",   
9 => "Колдун",   
11 => "Друид"   
);   

$result = @mysql_query("SELECT name,race,class,zone,data FROM `characters` WHERE online=1 ORDER BY zone");   

?>   
<table align=center cellpadding="0" cellspacing="0" border="1" width=100%>   
<thead>   
<td>Ник</td>   
<td width="6%">Раса</td>   
<td width="16%">Класс</td>   
<td width="6%">Уровень</td>   
</thead>   
<tbody>   

<?php   
while ($row = mysql_fetch_array($result))   
{   

$ch_name = $row['name'];   
$ch_race = $row['race'];   
$ch_class = $row['class'];   
$ch_zone = $zones[$row['zone']];   
$char_data = explode(' ',$row['data']);   
$char_gender = dechex($char_data[36]);   
$char_gender = str_pad($char_gender,8, 0, STR_PAD_LEFT);   
$char_gender = $char_gender{3};   
$ch_lvl = $char_data[53];   

if ($char_gender==1) $drace = "$ch_race-1.gif"; else $drace = "$ch_race-0.gif";   

$pic = "<img src='images/races/$drace' alt=$race[$ch_race]>";   

if(in_array(race, array(1, 3, 4, 7, 11)))   
$faction = "Альянс";   
else   
$faction = "Орда";   

echo "   
<tr>   
<td>$ch_name</td>   
<td>$pic</td>   
<td>$clases[$ch_class]</td>   
<td>$ch_lvl</td>   
</tr>";   
}   

?>   
<br><center><h3>Сервер ***</h3></center>

<?php   
include('config.php');   

$realmd = mysql_connect("$host:$port", "$login", "$pass", True);   
mysql_selectdb("$dbr", $realmd);   

$world = mysql_connect("$host:$port", "$login", "$pass", True);   
mysql_selectdb("$dbm", $world);   

$characters = mysql_connect("$host:$port", "$login", "$pass", True);   
mysql_selectdb("$dbc", $characters);   

$sql = mysql_query("SELECT count(*) FROM `account`;", $realmd);   
$accountsnum = "<font color=#C71585><b>".mysql_result($sql, 0, 0)."</b></font>";   

$sql = mysql_query("SELECT count(`guid`) FROM `characters`;", $characters);   
$charnum = "<font color=#FFFF00><b>".mysql_result($sql, 0, 0)."</b></font>";   

$sql = mysql_query("SELECT count(`guid`) FROM `characters` WHERE `online` = 1;", $characters);   
$online = "".mysql_result($sql, 0, 0)."";   

$fp = @fsockopen("127.0.0.1", 3724, $errno, $errstr, 1);   
if($fp >= 1){   
$login = '<font color=#00CC00 size=1 face=verdana>On</font>';   
} else {   
$login = '<font color=#CC0000 size=1 face=verdana>Off</font>';   
}   

$fp = @fsockopen("127.0.0.1", 8085, $errno, $errstr, 1);   
if($fp >= 1){   
$gamen = '<font color=#00CC00 size=1 face=verdana><img src="/images/on.gif"></font>';   
} else {   
$gamen = '<font color=#CC0000 size=1 face=verdana><img src="/images/off.gif"></font>';   
}   
?>