<? include "trunk/lagranj/header.php"?>
<? include "trunk/lagranj/top.php"?>
<div class="lContent">

<div id="newsBlock">
<h1> Онлайн игроков сервера ваш сервер</h1>
<div id="newsContainer">

<div id="n1" class="news disabled" rel="news-1">
<h2>ваш сервер</h2>
<div class="newscontent" >
<? include "trunk/lagranj/config.php"?>
<?php
$link = mysql_connect("$dbip", "$dblogin", "$dbpass") or die ("Нет соединения с хостом");
mysql_select_db ("$cdb") or die ("Нет соединения с базой");
mysql_query('SET NAMES CP1251');
$query = "SELECT name, race, class, gender, level, zone FROM characters WHERE online=1";
$result = mysql_query ($query) or die ("Нет такой таблицы");
$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);
mysql_selectdb ("$rdb");
?>

<table border=1 width=100%><tr>
<td width=492 height="21" align=center bgcolor="#184357"><b>Ник</b></td>
<td width=257 align=center bgcolor="#184357"><b>Расса</b></td>
<td width=276 align=center bgcolor="#184357"><b>Класс</b></td>
<td width=414 align=center bgcolor="#184357"><b>Фракция</b></td>
<td width=393 align=center bgcolor="#184357"><b>Уровень</b></td>

<?
$num_online = mysql_num_rows($result);
$faction = array(1=>"alliance", 3=>"alliance",4=>"alliance",7=>"alliance",11=>"alliance",2=>"horde",5=>"horde",6=>"horde",8=>"horde",10=>"horde"

);

for($i=0;$i<$num_online;$i++) {
$row = mysql_fetch_array($result);
$ch_name = $row['name'];
$ch_race = $row['race'];
$ch_class = $row['class'];
$ch_faction = $row['faction'];
$ch_gender = $row['gender'];
$ch_lvl = $row['level'];
$ch_loc = $row['zone'];

echo "<tr bgcolor='' align=center><td height='27'>$ch_name</td>";
echo "<td bgcolor='' align=center><img src=/images/race/$ch_race-$ch_gender.gif></td>";
echo "<td bgcolor='' align=center><img src=/images/race/$ch_class.gif></td>";
echo "<td bgcolor='' align=center><img src=/images/race/$faction[$ch_race].gif></td>";
echo "<td bgcolor='' align=center>$ch_lvl</td></tr>";
}
?>
</table>

<?php
if($num_online < 1) {
echo "<div align='center'>В игре никого нет</div>";
}
?>
</div>
</div>





</div>
</div>

<div class="spacer"></div>
<? include "trunk/lagranj/rek.php"?>
<? include "trunk/lagranj/menu.php"?>
<? include "trunk/lagranj/footer.php"?>
</body>

</html>