stats

<style>
body {
    margin: 0;
    background:#ddd;
}
h2 {
    margin:15px;
}
h3 {
    margin:5px;
}
table {
    border-collapse:collapse;
    background:#333;
    color:#BBB;
}
th {
    border-left:1px solid #000;
    border-right:1px solid #000;
    border-bottom:1px solid #000;
    color:#fe5;
}
#border {
    border-left:1px solid #000;
    border-right:1px solid #000;
    border-bottom:1px solid #000;
}
#border td {
    border-left:1px solid #000;
    border-right:1px solid #000;
}
#stats td {
    border-bottom:1px solid #000;
    padding:0 0 0 15px;
}
</style>
<?php
$host = 'localhost';
$user = 'root';
$pass = '';
$rdb = 'auth';
$cdb = 'characters';

$connect = mysql_connect($host,$user,$pass) or die('Нет подключения к базе данных');
mysql_select_db ($rdb, $connect) or die(mysql_error());
print "<h2 align=\"center\">Статистика</h2>";
$sql_account_count = mysql_query("SELECT COUNT(*) FROM `account`", $connect) or die(mysql_error());
$account_count = mysql_result($sql_account_count, 0);
mysql_select_db ($cdb, $connect) or die(mysql_error());
$sql_character_count = mysql_query("SELECT COUNT(*) FROM `characters`", $connect) or die(mysql_error());
$character_count = mysql_result($sql_character_count, 0);
$sql_horder_count = mysql_query("SELECT COUNT(*) FROM `characters` WHERE `race` IN (2, 5, 6, 8, 10)", $connect) or die(mysql_error());
$horde_count = mysql_result($sql_horder_count, 0);
$sql_alliance_count = mysql_query("SELECT COUNT(*) FROM `characters` WHERE `race` IN (1, 3, 4, 7, 11)", $connect) or die(mysql_error());
$alliance_count = mysql_result($sql_alliance_count, 0);
$sql_guild_count = mysql_query("SELECT COUNT(*) FROM `guild`", $connect) or die(mysql_error());
$guild_count = mysql_result($sql_guild_count, 0);
mysql_select_db ($rdb, $connect) or die(mysql_error());
$sql_moder_count = mysql_query("SELECT COUNT(*) FROM `account_access` WHERE `gmlevel` = 1 AND `RealmID` = 1", $connect) or die(mysql_error());
$moder_count = mysql_result($sql_moder_count, 0);
$sql_gm_count = mysql_query("SELECT COUNT(*) FROM `account_access` WHERE `gmlevel` = 2 AND `RealmID` = 1", $connect) or die(mysql_error());
$gm_count = mysql_result($sql_gm_count, 0);
$sql_admin_count = mysql_query("SELECT COUNT(*) FROM `account_access` WHERE `gmlevel` >= 3 AND `RealmID` = 1", $connect) or die(mysql_error());
$admin_count = mysql_result($sql_admin_count, 0);
print "<h3 align=\"center\">Общая</h3>
<table cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"300\" id=\"stats\">
<tr>
<td>Всего аккаунтов</td><th align=\"center\" width=\"100\">$account_count</th>
</tr>
<tr>
<td>Всего персонажей</td><th align=\"center\" width=\"100\">$character_count</th>
</tr>
<tr>
<td>Орды</td><th align=\"center\" width=\"100\">$horde_count</th>
</tr>
<tr>
<td>Альянса</td><th align=\"center\" width=\"100\">$alliance_count</th>
</tr>
<tr>
<td>Гильдий</td><th align=\"center\" width=\"100\">$guild_count</th>
</tr>
<tr>
<td>Модераторов</td><th align=\"center\" width=\"100\">$moder_count</th>
</tr>
<tr>
<td>Гейм мастеров</td><th align=\"center\" width=\"100\">$gm_count</th>
</tr>
<tr>
<td>Администраторов</td><th align=\"center\" width=\"100\">$admin_count</th>
</tr>
</table>";
mysql_select_db ($cdb, $connect) or die(mysql_error());
$sql_character_online_count = mysql_query("SELECT COUNT(*) FROM `characters` WHERE `online` = 1", $connect) or die(mysql_error());
$character_online_count = mysql_result($sql_character_online_count, 0);
$sql_horde_online_count = mysql_query("SELECT COUNT(*) FROM `characters` WHERE `online` = 1 AND `race` IN (2, 5, 6, 8, 10)", $connect) or die(mysql_error());
$horde_online_count = mysql_result($sql_horde_online_count, 0);
$sql_alliance_online_count = mysql_query("SELECT COUNT(*) FROM `characters` WHERE `online` = 1 AND `race` IN (1, 3, 4, 7, 11)", $connect) or die(mysql_error());
$alliance_online_count = mysql_result($sql_alliance_online_count, 0);
mysql_select_db ($rdb, $connect) or die(mysql_error());
$sql_max_online_count = mysql_query("SELECT max(`maxplayers`) FROM `uptime`", $connect) or die(mysql_error());
$result_max_online_count = mysql_result($sql_max_online_count, 0);
mysql_select_db ($cdb, $connect) or die(mysql_error());
$sql_online_admin = mysql_query("SELECT COUNT(*) FROM `$cdb`.`characters` c INNER JOIN `auth`.`account_access` a ON a.id = c.account WHERE a.gmlevel >= 3 AND a.RealmID = 1 AND c.online = 1", $connect) or die(mysql_error());
$admin_online_count = mysql_result($sql_online_admin, 0);
$sql_online_gm = mysql_query("SELECT COUNT(*) FROM `$cdb`.`characters` c INNER JOIN `auth`.`account_access` a ON a.id = c.account WHERE a.gmlevel = 2 AND a.RealmID = 1 AND c.online = 1", $connect) or die(mysql_error());
$gm_online_count = mysql_result($sql_online_gm, 0);
$sql_online_moder = mysql_query("SELECT COUNT(*) FROM `$cdb`.`characters` c INNER JOIN `auth`.`account_access` a ON a.id = c.account WHERE a.gmlevel = 1 AND a.RealmID = 1 AND c.online = 1", $connect) or die(mysql_error());
$moder_online_count = mysql_result($sql_online_moder, 0);
print "<h3 align=\"center\">Онлайн</h3>
<table cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"300\" id=\"stats\">
<tr>
<td>Всего</td><th align=\"center\" width=\"100\">$character_online_count</th>
</tr>
<tr>
<td>Орды</td><th align=\"center\" width=\"100\">$horde_online_count</th>
</tr>
<tr>
<td>Альянса</td><th align=\"center\" width=\"100\">$alliance_online_count</th>
</tr>
<tr>
<td>Модераторов</td><th align=\"center\" width=\"100\">$moder_online_count</th>
</tr>
<tr>
<td>Гейм мастеров</td><th align=\"center\" width=\"100\">$gm_online_count</th>
</tr>
<tr>
<td>Администраторов</td><th align=\"center\" width=\"100\">$admin_online_count</th>
</tr>
<tr>
<td>Максимальный</td><th align=\"center\" width=\"100\">$result_max_online_count</th>
</tr>
</table>";
$sql_human_count = mysql_query("SELECT COUNT(*) FROM `characters` WHERE `race` = 1", $connect) or die(mysql_error());
$human_count = mysql_result($sql_human_count, 0);
$sql_orc_count = mysql_query("SELECT COUNT(*) FROM `characters` WHERE `race` = 2", $connect) or die(mysql_error());
$orc_count = mysql_result($sql_orc_count, 0);
$sql_dworf_count = mysql_query("SELECT COUNT(*) FROM `characters` WHERE `race` = 3", $connect) or die(mysql_error());
$dworf_count = mysql_result($sql_dworf_count, 0);
$sql_nightelf_count = mysql_query("SELECT COUNT(*) FROM `characters` WHERE `race` = 4", $connect) or die(mysql_error());
$nightelf_count = mysql_result($sql_nightelf_count, 0);
$sql_undead_count = mysql_query("SELECT COUNT(*) FROM `characters` WHERE `race` = 5", $connect) or die(mysql_error());
$undead_count = mysql_result($sql_undead_count, 0);
$sql_tauren_count = mysql_query("SELECT COUNT(*) FROM `characters` WHERE `race` = 6", $connect) or die(mysql_error());
$tauren_count = mysql_result($sql_tauren_count, 0);
$sql_gnome_count = mysql_query("SELECT COUNT(*) FROM `characters` WHERE `race` = 7", $connect) or die(mysql_error());
$gnome_count = mysql_result($sql_gnome_count, 0);
$sql_troll_count = mysql_query("SELECT COUNT(*) FROM `characters` WHERE `race` = 8", $connect) or die(mysql_error());
$troll_count = mysql_result($sql_troll_count, 0);
$sql_bloodeld_count = mysql_query("SELECT COUNT(*) FROM `characters` WHERE `race` = 10", $connect) or die(mysql_error());
$bloodelf_count = mysql_result($sql_bloodeld_count, 0);
$sql_draney_count = mysql_query("SELECT COUNT(*) FROM `characters` WHERE `race` = 11", $connect) or die(mysql_error());
$draney_count = mysql_result($sql_draney_count, 0);
print "<h3 align=\"center\">По расам</h3>
<table cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"300\" id=\"stats\">
<tr>
<td>Людей</td><th align=\"center\" width=\"100\">$human_count</th>
</tr>
<tr>
<td>Орков</td><th align=\"center\" width=\"100\">$orc_count</th>
</tr>
<tr>
<td>Дворфов</td><th align=\"center\" width=\"100\">$dworf_count</th>
</tr>
<tr>
<td>Ночных эльфов</td><th align=\"center\" width=\"100\">$nightelf_count</th>
</tr>
<tr>
<td>Отрекшихся</td><th align=\"center\" width=\"100\">$undead_count</th>
</tr>
<tr>
<td>Тауренов</td><th align=\"center\" width=\"100\">$tauren_count</th>
</tr>
<tr>
<td>Гномов</td><th align=\"center\" width=\"100\">$gnome_count</th>
</tr>
<tr>
<td>Троллей</td><th align=\"center\" width=\"100\">$troll_count</th>
</tr>
<tr>
<td>Эльфов крови</td><th align=\"center\" width=\"100\">$bloodelf_count</th>
</tr>
<tr>
<td>Дренеев</td><th align=\"center\" width=\"100\">$draney_count</th>
</tr>
</table>";
$sql_warrior_count = mysql_query("SELECT COUNT(*) FROM `characters` WHERE `class` = 1", $connect) or die(mysql_error());
$warrior_count = mysql_result($sql_warrior_count, 0);
$sql_paladin_count = mysql_query("SELECT COUNT(*) FROM `characters` WHERE `class` = 2", $connect) or die(mysql_error());
$paladin_count = mysql_result($sql_paladin_count, 0);
$sql_hunter_count = mysql_query("SELECT COUNT(*) FROM `characters` WHERE `class` = 3", $connect) or die(mysql_error());
$hunter_count = mysql_result($sql_hunter_count, 0);
$sql_rogue_count = mysql_query("SELECT COUNT(*) FROM `characters` WHERE `class` = 4", $connect) or die(mysql_error());
$rogue_count = mysql_result($sql_rogue_count, 0);
$sql_priest_count = mysql_query("SELECT COUNT(*) FROM `characters` WHERE `class` = 5", $connect) or die(mysql_error());
$priest_count = mysql_result($sql_priest_count, 0);
$sql_deathknight_count = mysql_query("SELECT COUNT(*) FROM `characters` WHERE `class` = 6", $connect) or die(mysql_error());
$deathknight_count = mysql_result($sql_deathknight_count, 0);
$sql_shaman_count = mysql_query("SELECT COUNT(*) FROM `characters` WHERE `class` = 7", $connect) or die(mysql_error());
$shaman_count = mysql_result($sql_shaman_count, 0);
$sql_mage_count = mysql_query("SELECT COUNT(*) FROM `characters` WHERE `class` = 8", $connect) or die(mysql_error());
$mage_count = mysql_result($sql_mage_count, 0);
$sql_warlock_count = mysql_query("SELECT COUNT(*) FROM `characters` WHERE `class` = 9", $connect) or die(mysql_error());
$warlock_count = mysql_result($sql_warlock_count, 0);
$sql_druid_count = mysql_query("SELECT COUNT(*) FROM `characters` WHERE `class` = 11", $connect) or die(mysql_error());
$druid_count = mysql_result($sql_druid_count, 0);
print "<h3 align=\"center\">По классам</h3>
<table cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"300\" id=\"stats\">
<tr>
<td><font color=\"#C79C6E\">Воинов</font></td><th align=\"center\" width=\"100\">$warrior_count</th>
</tr>
<tr>
<td><font color=\"#F58CBA\">Паладинов</font></td><th align=\"center\" width=\"100\">$paladin_count</th>
</tr>
<tr>
<td><font color=\"#ABD473\">Охотников</font></td><th align=\"center\" width=\"100\">$hunter_count</th>
</tr>
<tr>
<td><font color=\"#FFF569\">Разбойников</font></td><th align=\"center\" width=\"100\">$rogue_count</th>
</tr>
<tr>
<td><font color=\"#FFFFFF\">Жрецов</font></td><th align=\"center\" width=\"100\">$priest_count</th>
</tr>
<tr>
<td><font color=\"#C41F3B\">Рыцарей смерти</font></td><th align=\"center\" width=\"100\">$deathknight_count</th>
</tr>
<tr>
<td><font color=\"#0070DE\">Шаманов</font></td><th align=\"center\" width=\"100\">$shaman_count</th>
</tr>
<tr>
<td><font color=\"#69CCF0\">Магов</font></td><th align=\"center\" width=\"100\">$mage_count</th>
</tr>
<tr>
<td><font color=\"#9482C9\">Чернокнижников</font></td><th align=\"center\" width=\"100\">$warlock_count</th>
</tr>
<tr>
<td><font color=\"#FF7D0A\">Друидов</font></td><th align=\"center\" width=\"100\">$druid_count</th>
</tr>
</table>";
mysql_select_db ($rdb, $connect) or die(mysql_error());
$sql_uptime = mysql_query ("SELECT max(`starttime`), `uptime` FROM `uptime` WHERE `realmid` = 1");
$uptime = time() - mysql_result($sql_uptime, 0);
$sec = $uptime%60;
$uptime = intval ($uptime/60);
$min = $uptime%60;
$uptime = intval ($uptime/60);
$hour = $uptime%24;
$uptime = intval($uptime/24);
$day = $uptime;
if ($day != 0)
    $day = $day." д";
else
    $day = "";
if ($hour != 0)
    $hour = $hour." ч";
else
    $hour = "";
if ($min != 0)
    $min = $min." м";
else
    $min = "";
$sql_all_time = mysql_query ("SELECT min(`starttime`) FROM `uptime` WHERE `realmid` = 1");
$result_all_time = time() - mysql_result($sql_all_time, 0);
$secs = $result_all_time%60;
$all_time = intval ($result_all_time/60);
$mins = $all_time%60;
$all_time = intval ($all_time/60);
$hours = $all_time%24;
$all_time = intval($all_time/24);
$days = $all_time;
if ($days != 0)
    $days = $days." д";
else
    $days = "";
if ($hours != 0)
    $hours = $hours." ч";
else
    $hours = "";
if ($mins != 0)
    $mins = $mins." м";
else
    $mins = "";
mysql_select_db ($cdb, $connect) or die(mysql_error());
$sql_ap = mysql_query("SELECT `value` FROM `worldstates` WHERE `entry` = 20001", $connect) or die(mysql_error());
$result_ap = mysql_fetch_array($sql_ap);
$accrual_ap = date("H:i:s d.m.Y", $result_ap['value']);
$sql_day = mysql_query("SELECT `value` FROM `worldstates` WHERE `entry` = 20006", $connect) or die(mysql_error());
$result_day = mysql_fetch_array($sql_day);
$reset_day = date("H:i:s d.m.Y", $result_day['value']);
$sql_week = mysql_query("SELECT `value` FROM `worldstates` WHERE `entry` = 20002", $connect) or die(mysql_error());
$result_week = mysql_fetch_array($sql_week);
$reset_week = date("H:i:s d.m.Y", $result_week['value']);
$sql_month = mysql_query("SELECT `value` FROM `worldstates` WHERE `entry` = 20007", $connect) or die(mysql_error());
$result_month = mysql_fetch_array($sql_month);
$reset_month = date("H:i:s d.m.Y", $result_month['value']);
print "<h3 align=\"center\">Таймеры</h3>
<table cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"450\" id=\"stats\">
<tr>
<td>Время работы сервера</td><th align=\"center\" width=\"150\">$day $hour $min $sec с</th>
</tr>
<tr>
<td>Серверу уже</td><th align=\"center\" width=\"100\">$days $hours $mins $secs с</th>
</tr>
<tr>
<td>Дата начисления очков арены</td><th align=\"center\" width=\"100\">$accrual_ap</th>
</tr>
<tr>
<td>Дата сброса ежедневных заданий</td><th align=\"center\" width=\"100\">$reset_day</th>
</tr>
<tr>
<td>Дата сброса еженедельных заданий</td><th align=\"center\" width=\"100\">$reset_week</th>
</tr>
<tr>
<td>Дата сброса ежемесячных заданий</td><th align=\"center\" width=\"100\">$reset_month</th>
</tr>
</table>";
mysql_close($connect);
?>