<?php
defined('_IN_JOHNCMS') or die('Restricted access');
class counters
{
/*
-----------------------------------------------------------------
Счетчик Фотоальбомов для простых пользователей
-----------------------------------------------------------------
*/
static function album()
{
$file = ROOTPATH . 'files/cache/count_album.dat';
if (file_exists($file) && filemtime($file) > (time() - 600)) {
$res = unserialize(file_get_contents($file));
$album = $res['album'];
$photo = $res['photo'];
$new = $res['new'];
$new_adm = $res['new_adm'];
} else {
$album = mysql_result(mysql_query("SELECT COUNT(DISTINCT `user_id`) FROM `cms_album_files`"), 0);
$photo = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files`"), 0);
$new = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` WHERE `time` > '" . (time() - 259200) . "' AND `access` = '4'"), 0);
$new_adm = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` WHERE `time` > '" . (time() - 259200) . "' AND `access` > '1'"), 0);
file_put_contents($file, serialize(array('album' => $album, 'photo' => $photo, 'new' => $new, 'new_adm' => $new_adm)));
}
$newcount = 0;
if (core::$user_rights >= 6 && $new_adm) {
$newcount = $new_adm;
} elseif ($new) {
$newcount = $new;
}
return $album . ' / ' . $photo .
($newcount ? ' / <span class="red"><a href="' . core::$system_set['homeurl'] . '/users/album.php?act=top">+' . $newcount . '</a></span>' : '');
}
/*
-----------------------------------------------------------------
Доска объявлений
-----------------------------------------------------------------
*/
static function board() {
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `board_ads` WHERE `status` != 0"), 0);
$new = mysql_result(mysql_query("SELECT COUNT(*) FROM `board_ads` WHERE `status` != 0 AND `time` > (" . time() . " - 3600 * 24)"), 0);
if ($new)
$total .= ' / <span class="red">+' . $new . '</span>';
$mod = mysql_result(mysql_query("SELECT COUNT(*) FROM `board_ads` WHERE `status` = 0"), 0);
if ($mod)
$total .= ' / <span class="green">M:' . $mod . '</span>';
return $total;
}
/*
-----------------------------------------------------------------
Статистика загрузок
-----------------------------------------------------------------
*/
static function downloads()
{
global $down_setting, $lng_dl;
require_once ROOTPATH.'download/functions.php';
return dcount_simba();
}
/*
-----------------------------------------------------------------
Статистика Форума
-----------------------------------------------------------------
*/
static function forum()
{
$file = ROOTPATH . 'files/cache/count_forum.dat';
$new = '';
if (file_exists($file) && filemtime($file) > (time() - 600)) {
$res = unserialize(file_get_contents($file));
$top = $res['top'];
$msg = $res['msg'];
} else {
$top = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `type` = 't' AND `close` != '1'"), 0);
$msg = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `type` = 'm' AND `close` != '1'"), 0);
file_put_contents($file, serialize(array('top' => $top, 'msg' => $msg)));
}
if (core::$user_id && ($new_msg = self::forum_new()) > 0) {
$new = ' / <span class="red"><a href="' . core::$system_set['homeurl'] . '/forum/index.php?act=new">+' . $new_msg . '</a></span>';
}
return $top . ' / ' . $msg . $new;
}
/*
-----------------------------------------------------------------
Счетчик непрочитанных тем на форуме
-----------------------------------------------------------------
$mod = 0 Возвращает число непрочитанных тем
$mod = 1 Выводит ссылки на непрочитанное
-----------------------------------------------------------------
*/
static function forum_new($mod = 0)
{
if (core::$user_id) {
$req = mysql_query("SELECT COUNT(*) FROM `forum`
LEFT JOIN `cms_forum_rdm` ON `forum`.`id` = `cms_forum_rdm`.`topic_id` AND `cms_forum_rdm`.`user_id` = '" . core::$user_id . "'
WHERE `forum`.`type`='t'" . (core::$user_rights >= 7 ? "" : " AND `forum`.`close` != '1'") . "
AND (`cms_forum_rdm`.`topic_id` Is Null
OR `forum`.`time` > `cms_forum_rdm`.`time`)");
$total = mysql_result($req, 0);
if ($mod) {
return '<a href="index.php?act=new&do=period">' . core::$lng['show_for_period'] . '</a>' .
($total ? '<br/><a href="index.php?act=new">' . core::$lng['unread'] . '</a> <span class="red">(<b>' . $total . '</b>)</span>' : '');
} else {
return $total;
}
} else {
if ($mod) {
return '<a href="index.php?act=new">' . core::$lng['last_activity'] . '</a>';
} else {
return false;
}
}
}
/*
-----------------------------------------------------------------
Статистика галлереи
-----------------------------------------------------------------
$mod = 1 будет выдавать только колличество новых картинок
-----------------------------------------------------------------
*/
static function gallery($mod = 0)
{
$new = mysql_result(mysql_query("SELECT COUNT(*) FROM `gallery` WHERE `time` > '" . (time() - 259200) . "' AND `type` = 'ft'"), 0);
if ($mod == 0) {
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `gallery` WHERE `type` = 'ft'"), 0);
$out = $total;
if ($new > 0)
$out .= ' / <span class="red"><a href="/gallery/index.php?act=new">+' . $new . '</a></span>';
} else {
$out = $new;
}
return $out;
}
/*
-----------------------------------------------------------------
Статистика гостевой
-----------------------------------------------------------------
$mod = 1 колличество новых в гостевой
$mod = 2 колличество новых в Админ-Клубе
-----------------------------------------------------------------
*/
static function guestbook($mod = 0)
{
$count = 0;
switch ($mod) {
case 1:
$count = mysql_result(mysql_query("SELECT COUNT(*) FROM `guest` WHERE `adm`='0' AND `time` > '" . (time() - 86400) . "'"), 0);
break;
case 2:
if (core::$user_rights >= 1)
$count = mysql_result(mysql_query("SELECT COUNT(*) FROM `guest` WHERE `adm`='1' AND `time` > '" . (time() - 86400) . "'"), 0);
break;
default:
$count = mysql_result(mysql_query("SELECT COUNT(*) FROM `guest` WHERE `adm`='0' AND `time` > '" . (time() - 86400) . "'"), 0);
if (core::$user_rights >= 1) {
$req = mysql_query("SELECT COUNT(*) FROM `guest` WHERE `adm`='1' AND `time`>'" . (time() - 86400) . "'");
$count = $count . ' / <span class="red"><a href="guestbook/index.php?act=ga&do=set">' . mysql_result($req, 0) . '</a></span>';
}
}
return $count;
}
/*
-----------------------------------------------------------------
Статистика библиотеки
-----------------------------------------------------------------
*/
static function library()
{
$file = ROOTPATH . 'files/cache/count_library.dat';
if (file_exists($file) && filemtime($file) > (time() - 3200)) {
$res = unserialize(file_get_contents($file));
$total = $res['total'];
$new = $res['new'];
$mod = $res['mod'];
} else {
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `library_texts` WHERE `premod` = '1'"), 0);
$new = mysql_result(mysql_query("SELECT COUNT(*) FROM `library_texts` WHERE `time` > '" . (time() - 259200) . "' AND `premod` = '1'"), 0);
$mod = mysql_result(mysql_query("SELECT COUNT(*) FROM `library_texts` WHERE `premod` = '0'"), 0);
file_put_contents($file, serialize(array('total' => $total, 'new' => $new, 'mod' => $mod)));
}
if ($new) $total .= ' / <span class="red"><a href="' . core::$system_set['homeurl'] . '/library/index.php?act=new">+' . $new . '</a></span>';
if ((core::$user_rights == 5 || core::$user_rights >= 6) && $mod) {
$total .= ' / <span class="red"><a href="' . core::$system_set['homeurl'] . '/library/index.php?act=premod">M:' . $mod . '</a></span>';
}
return $total;
}
/*
-----------------------------------------------------------------
Счетчик посетителей онлайн
-----------------------------------------------------------------
*/
static function online()
{
$users = mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `lastdate` > '" . (time() - 300) . "'"), 0);
$guests = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_sessions` WHERE `lastdate` > '" . (time() - 300) . "'"), 0);
return (core::$user_id || core::$system_set['active'] ? '<a href="' . core::$system_set['homeurl'] . '/users/index.php?act=online">' . functions::image('menu_online.png') . $users . ' / ' . $guests . '</a>' : core::$lng['online'] . ': ' . $users . ' / ' . $guests);
}
/*
-----------------------------------------------------------------
Колличество зарегистрированных пользователей
-----------------------------------------------------------------
*/
static function users()
{
$file = ROOTPATH . 'files/cache/count_users.dat';
if (file_exists($file) && filemtime($file) > (time() - 600)) {
$res = unserialize(file_get_contents($file));
$total = $res['total'];
$new = $res['new'];
} else {
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `users`"), 0);
$new = mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `datereg` > '" . (time() - 86400) . "'"), 0);
file_put_contents($file, serialize(array('total' => $total, 'new' => $new)));
}
if ($new) $total .= ' / <span class="red">+' . $new . '</span>';
return $total;
}
}