Код:
<? if(!defined('Light_Engine')) {die("Hacking attempt!");}
# ========================================================================== #
# #
# Light_Engine | Модуль: Статистика сервера #
# #
# ========================================================================== #
$i = 1;
$r = 255;
$all = "<div align='center'>[ <a href=\"?page=stats\">Общая</a> | <a href=\"?page=stats&type=adena\">Богачи</a> | <a href=\"?page=stats&type=online\">Онлайн</a> | <a href=\"?page=stats&type=vote\">Голоса</a> | <a href=\"?page=stats&type=top\">Топ</a> | <a href=\"?page=stats&type=rb\">РБ</a> | <a href=\"?page=stats&type=castle\">Замки</a> | <a href=\"?page=stats&type=clan\">Топ Кланов</a> ]</div><br/>";
$sexes = array('М', 'Ж');
$online = array('0' => "<font color=red>Offline</font>", '1' => "<font color=green>Online</font>");
$castle = array('0' => "No Castle", ' ' => "No Castle", '1' => "Gludio Castle", '2' => "Dion Castle", '3' => "Giran Castle", '4' => "Oren Castle", '5' => "Aden Castle", '6' => "Innadril Castle", '7' => "Goddard Castle", '8' => "Rune Castle", '9' => "Schuttgart Castle");
if ($_GET ['type'] == ''){
$page_name = "Общая статистика";
$stats_all['online'] = mysql_result (sql($queryList["online"]),0) or die (mysql_error($queryList["online"]));
$stats_all['characters'] = mysql_result (sql($queryList["charactersCount"], array ("a" => "charid")),0) or die (mysql_error($queryList["charactersCount"]));
$stats_all['account'] = mysql_result (sql($queryList["accountsCount"], array ("a" => "login")),0) or die (mysql_error($queryList["accountsCount"]));
$stats_all['clan'] = mysql_result (sql($queryList["clanDataCount"], array ("a" => "clan_name")),0) or die (mysql_error($queryList["clanDataCount"]));
$stats_all['human'] = mysql_result (sql($queryList["raceCount"], array ("a" => "0")),0) or die (mysql_error($queryList["raceCount"]));
$stats_all['elf'] = mysql_result (sql($queryList["raceCount"], array ("a" => "1")),0) or die (mysql_error($queryList["raceCount"]));
$stats_all['dark_elf'] = mysql_result (sql($queryList["raceCount"], array ("a" => "2")),0) or die (mysql_error($queryList["raceCount"]));
$stats_all['ork'] = mysql_result (sql($queryList["raceCount"], array ("a" => "3")),0) or die (mysql_error($queryList["raceCount"]));
$stats_all['gnom'] = mysql_result (sql($queryList["raceCount"], array ("a" => "4")),0) or die (mysql_error($queryList["raceCount"]));
$stats_all['kamael'] = mysql_result (sql($queryList["raceCount"], array ("a" => "5")),0) or die (mysql_error($queryList["raceCount"]));
$stats_all['dawn'] = mysql_result (sql($queryList["sevenSigns"], array ("a" => "dawn")),0) or die (mysql_error($queryList["sevenSigns"]));
$stats_all['dusk'] = mysql_result (sql($queryList["sevenSigns"], array ("a" => "dusk")),0) or die (mysql_error($queryList["sevenSigns"]));
$stats_all['hellbound']['lvl'] = mysql_result (sql($queryList["hellbound"], array ("a" => "zonesLevel")),0) or die (mysql_error($queryList["hellbound"]));
$stats_all['hellbound']['trust'] = mysql_result (sql($queryList["hellbound"], array ("a" => "trustLevel")),0) or die (mysql_error($queryList["hellbound"]));
$stats_all['percent_characters'] = $stats_all['characters']/100;
$page_result = "<table width=\"360\" border=\"0\" cellpadding=\"1\" cellspacing=\"1\" align=\"center\">
<tr align=\"left\"><td><br/><strong>Общая информация</strong><br/><br/></td></tr>
<tr align=\"left\"><td><strong>Логин сервер:</strong></td><td align=\"right\">".$stats_all['login']."</td></tr>
<tr align=\"left\"><td><strong>Игровой сервер:</strong></td><td align=\"right\">".$stats_all['game']."</td></tr>
<tr align=\"left\"><td><strong>Игроки онлайн:</strong></td><td align=\"right\">".$stats_all['online']."</td></tr>
<tr align=\"left\"><td><strong>Персонажей:</strong></td><td align=\"right\">".$stats_all['characters']."</td></tr>
<tr align=\"left\"><td><strong>Аккаунтов:</strong></td><td align=\"right\">".$stats_all['account']."</td></tr>
<tr align=\"left\"><td><strong>Кланов:</strong></td><td align=\"right\">".$stats_all['clan']."</td></tr>
<tr align=\"left\"><td><br/><strong>Расы на сервере</strong><br/><br/></td></tr>
<tr align=\"left\"><td><strong>Люди:</strong></td><td align=\"right\">".$stats_all['human']." (".round($stats_all['human']/$stats_all['percent_characters'])."%)</td></tr>
<tr align=\"left\"><td><strong>Эльфы:</strong></td><td align=\"right\">".$stats_all['elf']." (".round($stats_all['elf']/$stats_all['percent_characters'])."%)</td></tr>
<tr align=\"left\"><td><strong>Темные эльфы:</strong></td><td align=\"right\">".$stats_all['dark_elf']." (".round($stats_all['dark_elf']/$stats_all['percent_characters'])."%)</td></tr>
<tr align=\"left\"><td><strong>Орки:</strong></td><td align=\"right\">".$stats_all['ork']." (".round($stats_all['ork']/$stats_all['percent_characters'])."%)</td></tr>
<tr align=\"left\"><td><strong>Гномы:</strong></td><td align=\"right\">".$stats_all['gnom']." (".round($stats_all['gnom']/$stats_all['percent_characters'])."%)</td></tr>
<tr align=\"left\"><td><strong>Камаэли:</strong></td><td align=\"right\">".$stats_all['kamael']." (".round($stats_all['kamael']/$stats_all['percent_characters'])."%)</td></tr>
<tr align=\"left\"><td><br/><strong>7 Печатей</strong><br/><br/></td></tr>
<tr align=\"left\"><td><strong>Dawn (рассвет):</strong></td><td align=\"right\">".$stats_all['dawn']." (".round($stats_all['dawn']/$stats_all['percent_characters'])."%)</td></tr>
<tr align=\"left\"><td><strong>Dusk (сумрак):</strong></td><td align=\"right\">".$stats_all['dusk']." (".round($stats_all['dusk']/$stats_all['percent_characters'])."%)</td></tr>
<tr align=\"left\"><td><br/><strong>Hellbound</strong><br/><br/></td></tr>
<tr align=\"left\"><td><strong>Уровень ХБ:</strong></td><td align=\"right\">".$stats_all['hellbound']['lvl']."</td></tr>
<tr align=\"left\"><td><strong>Уровень доверия:</strong></td><td align=\"right\">".$stats_all['hellbound']['trust']."</td></tr>
</table>";
}
else
{
$page_result = "<p class=\"block\">Непредвиденная ошибка в обработке команды.<br/>Обратитесь к модератору/администратору сайта.</p>";
}
if ($_GET ['type'] == 'adena'){
$page_name = "Топ ".$stats['adena']." богачей сервера";
$page_result = "<tr>
<th align=center>#</th>
<th align=center>Имя</th>
<th align=center>Уровень</th>
<th align=center>Пол</th>
<th align=center>Количество Аден</th>
<th align=center>Статус</th>
</tr>";
$link = sql($queryList["statsAdena"], array ("a" => $stats['adena']),0);
while ($row = mysql_fetch_row($link))
{
$name = mysql_fetch_row(sql($queryList["charIdToName"], array ("a" => $row[2]),0));
$page_result .= "<tr>
<td align=center>$i</span></td>
<td align=center>".$name[0]."</span></td>
<td align=center>$row[3]</span></td>
<td align=center>".$sexes[$row[4]]."</span></td>
<td align=center>$row[0] Аден</span></td>
<td align=center>".$online[$row[5]]."</span></td>
</tr>";
$i++;
$r -= 0;
}
}
if ($_GET ['type'] == 'online'){
$page_name = "Количество онлайн";
$page_result = "<tr>
<th align=center>#</th>
<th align=center>Ник</th>
<th align=center>Уровень</th>
<th align=center>Пол</th>
<th align=center>ПвП/ПК</th>
<th align=center>Клан</th>
</tr>";
$link = sql($queryList["statsOnline"],0);
while ($row = mysql_fetch_row($link))
{
$clan = mysql_fetch_row(sql($queryList["clanIdToClanName"], array ("a" => $row[5]),0));
$page_result .= "<tr>
<td align=center>$i</span></td>
<td align=center>$row[0]</td>
<td align=center>$row[1]</td>
<td align=center>".$sexes[$row[2]]."</td>
<td align=center>$row[3]/$row[4]</td>
<td align=center>".$clan[0]."</td>
</tr>";
$i++;
$r -= 0;
}
}
if ($_GET ['type'] == 'vote'){
$page_name = "Топ ".$stats['vote']." голосующих";
$page_result = "<tr>
<th align=center>Место</th>
<th align=center>Ник</th>
<th align=center>Количество голосов</th>
</tr>";
$link = sql($queryList["statsVote"], array ("a" => $stats['vote']),0);
while ($row = mysql_fetch_row($link))
{
$page_result .= "<tr>
<td align=center>$i</span></td>
<td align=center>$row[0]</td>
<td align=center>$row[1]</td>
</tr>";
$i++;
$r -= 0;
}
}
if ($_GET ['type'] == 'top'){
$page_name = "Топ ".$stats['top']." Игроков";
$page_result = "<tr>
<th align=center>#</th>
<th align=center>Ник</th>
<th align=center>Уровень</th>
<th align=center>ПвП/ПК</th>
<th align=center>Клан</th>
<th align=center>Статус</th>
</tr>";
$link = sql($queryList["statsTop"], array ("a" => $stats['top']),0);
while ($row = mysql_fetch_row($link))
{
$clan = mysql_fetch_row(sql($queryList["clanIdToClanName"], array ("a" => $row[4]),0));
$page_result .= "<tr>
<td align=center>$i</span></td>
<td align=center>$row[0]</td>
<td align=center>$row[1]</td>
<td align=center>$row[2]/$row[3]</td>
<td align=center>".$clan[0]."</td>
<td align=center>".$online[$row[5]]."</td>
</tr>";
$i++;
$r -= 0;
}
}
if ($_GET ['type'] == 'rb'){
$page_name = "Статистика РБ";
$page_result = "<tr>
<th align=center>#</th>
<th align=center>Имя</th>
<th align=center>Уровень</th>
<th align=center>Время респауна</th>
</tr>";
$link = sql($queryList["statsRb"], array ("a" => $stats['rb']),0);
while ($row = mysql_fetch_row($link))
{
if ($row[1]>1) $respawn=date('j M Y H\:i',$row[4]/1000); else $respawn='пока-что жив';
$page_result .= "<tr>
<td align=center>$i</span></td>
<td align=center>$row[0]</td>
<td align=center>$row[2]</td>
<td align=center>$respawn</td>
</tr>";
$i++;
$r -= 0;
}
}
if ($_GET ['type'] == 'castle'){
$page_name = "Статус замков";
$page_result = "<tr>
<th align=center>#</th>
<th align=center>Название</th>
<th align=center>Дата осады</th>
<th align=center>Владеет</th>
</tr>";
$link = sql($queryList["statsCastle"],0);
while ($row = mysql_fetch_row($link))
{
$castle_owner = mysql_fetch_row(sql($queryList["castleOwner"], array ("a" => $row[0]),0));
$siege_date = date('D\, j M Y H\:i',$row[2]/1000);
$page_result .= "<tr>
<td align=center>$i</span></td>
<td align=center>$row[1] Castle</td>
<td align=center>$siege_date</td>
<td align=center>".$castle_owner[0]."</td>
</tr>";
$i++;
$r -= 0;
}
}
if ($_GET ['type'] == 'clan'){
$page_name = "Топ Кланов";
$page_result = "<tr>
<th align=center>#</th>
<th align=center>Клан</th>
<th align=center>Уровень</th>
<th align=center>Игроков</th>
<th align=center>Лидер</th>
</tr>";
$link = sql($queryList["statsClan"],0);
while ($row = mysql_fetch_row($link))
{
$clan_leader = mysql_fetch_row(sql($queryList["clanLeader"], array ("a" => $row[3]),0));
$clan_member = mysql_fetch_row(sql($queryList["clanMember"], array ("a" => $row[0]),0));
$page_result .= "<tr>
<td align=center>$i</span></td>
<td align=center>$row[1]</td>
<td align=center>$row[2]</td>
<td align=center>".$clan_member[0]."</td>
<td align=center>".$clan_leader[0]."</td>
</tr>";
$i++;
$r -= 0;
}
}
?>
<div id="navitabs">
<h2 class="hide">Меню сайта:</h2>
<a class="navitab" href=".">Привет!</a><span class="hide"> | </span>
<a class="navitab" href="?page=news">Новости</a><span class="hide"> | </span>
<a class="navitab" href="?page=registration">Регистрация</a><span class="hide"> | </span>
<a class="navitab" href="?page=account">ЛК</a><span class="hide"> | </span>
<a class="activenavitab" href="?page=stats">Статистика сервера</a><span class="hide"> | </span>
<a class="navitab" href="?page=bonus">Бонус</a><span class="hide"> | </span>
<a class="navitab" href="?page=rules">Правила</a><span class="hide"> | </span>
<a class="navitab" href="?page=download">Файлы</a><span class="hide"> | </span>
<a class="navitab" href="forum/">Форум</a>
</div>
<div id="desc">
<h2>Статистика сервера</h2>
<p>Эта страница предназначена для отображения экономической стороны сервера, так и для отображения статистики среди игроков.<br/><br/>
Тем не менее, данный модуль можно разрабатывать до бесконечности или пока фантазия не кончится. %)</p>
</div>
<div id="main">
<h2><? echo "$page_name"?></h2>
<p><table width='100%' border='0' cellspacing='0' cellpadding='0'>
<? echo "$all", "$page_result"; if (!empty($error)) error($error); ?>
</table></p>
так