Файл: inc/stat.php
Строк: 95
<?
echo "<div class='content'>";
echo "<div class='blockings event'>Cтатистика проекта ''Моя грядка'' ";
echo "</div>";
echo "<div class='blockings'>";
echo "<li>Монет у игроков:
<span class='title'>".mysql_result(mysql_query("SELECT SUM(money) FROM kolhoz_user;
"), 0)."</span></li>";
echo "<li>Рубинов у игроков:
<span class='title'>".mysql_result(mysql_query("SELECT SUM(rubies) FROM kolhoz_user;
"), 0)."</span></li>";
echo "<li>Золота у игроков:
<span class='title'>".mysql_result(mysql_query("SELECT SUM(turnir) FROM kolhoz_user;
"), 0)."</span></li>";
echo "<li>Уровней в игре:
<span class='title'>150</span></li>";
echo "<li>Игроков 50 уровня:
<span class='title'>".mysql_num_rows(mysql_query("SELECT * FROM `kolhoz_user` WHERE level='50'"))."</span></li></ul>";
echo "<li>Игроков до 50 уровня:
<span class='title'>".mysql_num_rows(mysql_query("SELECT * FROM `kolhoz_user` WHERE level<'50'"))."</span></li></ul>";
echo "<li>Игроков 80 уровня:
<span class='title'>".mysql_num_rows(mysql_query("SELECT * FROM `kolhoz_user` WHERE level='80'"))."</span></li></ul>";
echo "<li>Игроков выше 80 уровня:
<span class='title'>".mysql_num_rows(mysql_query("SELECT * FROM `kolhoz_user` WHERE level>'80'"))."</span></li></ul>";
echo "<li>Игроков 40 уровня:
<span class='title'>".mysql_num_rows(mysql_query("SELECT * FROM `kolhoz_user` WHERE level='40'"))."</span></li></ul>";
echo "<li>Администрации:
<span class='title'>".mysql_num_rows(mysql_query("SELECT * FROM `kolhoz_user` WHERE status>'0'"))."</span></li></ul>";
echo "<li>Модераторов:
<span class='title'>".mysql_num_rows(mysql_query("SELECT * FROM `kolhoz_user` WHERE status='2'"))."</span></li></ul>";
echo "<li>Администраторов:
<span class='title'>".mysql_num_rows(mysql_query("SELECT * FROM `kolhoz_user` WHERE status='3'"))."</span></li></ul>";
echo "<li>Сотрудников ТП:
<span class='title'>".mysql_num_rows(mysql_query("SELECT * FROM `kolhoz_user` WHERE status='1'"))."</span></li></ul>";
echo "Сообщений в личной почте:
<span class='title'>".mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_mail`"), 0)."</span></center>";
echo "<li>Загонов у игроков:
<span class='title'>".mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_petground`"), 0)."</span></li></ul>";
echo "<li>Грядок у игроков:
<span class='title'>".mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_ground`"), 0)."</span></li></ul>";
echo "<li>Комментарий на форуме:
<span class='title'>".mysql_result(mysql_query("SELECT COUNT(*) FROM kolhoz_forum WHERE type='komm'"), 0)."</span></li></ul>";
echo "<li>Тем на форуме:
<span class='title'>".mysql_result(mysql_query("SELECT COUNT(*) FROM kolhoz_forum WHERE type='tema'"), 0)."</span></li></ul>";
echo "<li>Сообщений в чате:
<span class='title'>".mysql_result(mysql_query("SELECT COUNT(*) FROM kolhoz_chat WHERE type='komm'"), 0)."</span></li></ul>";
echo "<li>Колхозов:
<span class='title'>".mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_collective` "), 0)."</span></li></ul>";
echo "<li>Вертолетов:
<span class='title'>".mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_collective_ahlist` "), 0)."</span></li></ul>";
echo "<li>Вызвано вертолетов:
<span class='title'>".mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_collective_heli` "), 0)."</span></li></ul>";
echo "<li>Выдано Изгнаний:
<span class='title'>".mysql_result(mysql_query("SELECT COUNT(*) FROM kolhoz_ban WHERE izg='1'"), 0)."</span></li></ul>";
echo "<li>Выдано банов:
<span class='title'>".mysql_result(mysql_query("SELECT COUNT(*) FROM kolhoz_ban WHERE izg='0'"), 0)."</span></li></ul>";
echo "<li>Видов полян:
<span class='title'>".mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_forest`"), 0)."</span></li></ul>";
echo "<li>Видов растений:
<span class='title'>".mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_plant` "), 0)."</span></li></ul>";
echo "<li>Видов животных:
<span class='title'>".mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_pet` "), 0)."</span></li></ul>";
echo "<li>Видов Подарков:
<span class='title'>".mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_gift` "), 0)."</span></li></ul>";
echo "<li>Подарено подарков:
<span class='title'>".mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_gifts` "), 0)."</span></li></ul>";
echo "<li>Видов Смайлов:
<span class='title'>".mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_smiles` "), 0)."</span></li></ul>";
echo "<li>Бракосочетаний:
<span class='title'>10</span></li></ul>";
echo "<li>Обращений в тех.поддержку:
<span class='title'>".mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_tikets` "), 0)."</span></li></ul>";
echo "<br/><div><img alt='' width='16' height='16' src='images/icons/back.png'> <a href='http://gryadka.aux.su'>Вернуться</a></div></div></div>";
?>
<?
echo "<div class='framed'>";
echo "<div class='blockings event'>";
echo "Онлайн <span class='title'>".mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_user` WHERE `date_last` > '".(time()-10000)."'"), 0)."</span>, регистраций
<span class='title'>".mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_user`"), 0)."</span></div>";
echo "</div>";
exit;
?>