Файл: adm_panel/adm_log.php
Строк: 164
<?php
require_once '../sys/inc/start.php';
require_once '../sys/inc/compress.php';
require_once '../sys/inc/sess.php';
require_once '../sys/inc/settings.php';
require_once '../sys/inc/db_connect.php';
require_once '../sys/inc/ipua.php';
require_once '../sys/inc/fnc.php';
require_once '../sys/inc/adm_check.php';
require_once '../sys/inc/user.php';
user_access('adm_log_read', null, 'index.php?' . SID);
adm_check();
$set['title'] = 'Действия администрации';
require_once '../sys/inc/thead.php';
err();
aut();
if (isset($_GET['id'])) {
$ank = get_user($_GET['id']);
} else {
$ank = false;
}
if ($ank && user_access('adm_log_read') && ($ank['id'] == $user['id'] || $ank['level'] < $user['level'])) {
echo "<div class = 'foot'>";
echo "<a href='/info.php?id=$ank[id]'>$ank[nick]</a> ($ank[group_name])<br />n";
$adm_log_c_all = mysql_result(mysql_query("SELECT COUNT(*) FROM `admin_log` WHERE `id_user` = '$ank[id]'"), 0);
$mes = mktime(0, 0, 0, date('m') - 1);
$adm_log_c_mes = mysql_result(mysql_query("SELECT COUNT(*) FROM `admin_log` WHERE `id_user` = '$ank[id]' AND `time` > '$mes'"), 0);
echo "Вся активность: $adm_log_c_all<br />n";
echo "Активность за месяц: $adm_log_c_mes";
echo "</div>";
} else {
echo "<div class = 'foot'>";
$adm_log_c_all = mysql_result(mysql_query("SELECT COUNT(*) FROM `admin_log`"), 0);
$mes = mktime(0, 0, 0, date('m') - 1); // время месяц назад
$adm_log_c_mes = mysql_result(mysql_query("SELECT COUNT(*) FROM `admin_log` WHERE `time` > '$mes'"), 0);
echo "Вся активность: $adm_log_c_all<br />n";
echo "Активность за месяц: $adm_log_c_mes";
echo "</div>";
}
if (isset($_GET['id_mod']) && isset($_GET['id_act']) && mysql_result(mysql_query("SELECT COUNT(*) FROM `admin_log` WHERE `mod` = '" . intval($_GET['id_mod']) . "' AND `act` = '" . intval($_GET['id_act']) . "'" . ($ank ? " AND `id_user` = '$ank[id]'" : null)), 0) != 0) {
$mod = mysql_fetch_assoc(mysql_query("SELECT * FROM `admin_log_mod` WHERE `id` = '" . intval($_GET['id_mod']) . "' LIMIT 1"));
$act = mysql_fetch_assoc(mysql_query("SELECT * FROM `admin_log_act` WHERE `id` = '" . intval($_GET['id_act']) . "' LIMIT 1"));
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `admin_log` WHERE `mod` = '$mod[id]' AND `act` = '$act[id]'" . ($ank ? " AND `admin_log`.`id_user` = '$ank[id]'" : null)), 0);
$k_page = k_page($k_post, $set['p_str']);
$page = page($k_page);
$start = $set['p_str'] * $page - $set['p_str'];
if ($k_post == 0) {
echo "<table class = 'foot'><tr><td class = 'null'>";
echo "<img src = '/style/icons/bullet_error.png' /> Нет результатов";
echo "</td></tr></table>";
}
$q = mysql_query("SELECT * FROM `admin_log` WHERE `mod` = '$mod[id]' AND `act` = '$act[id]'" . ($ank ? " AND `admin_log`.`id_user` = '$ank[id]'" : null) . " ORDER BY id DESC LIMIT $start, $set[p_str]");
while ($post = mysql_fetch_assoc($q)) {
$ank2 = get_user($post['id_user']);
echo "<table class = 'foot'><tr><td class = 'icon14'>";
avatar($ank2['id'], '48');
echo " </td><td class='null'>n";
user($ank2['id']);
echo "<br /><img src = '/style/icons/time.png' /> " . vremja($post['time']) . "<br />";
echo text::toOutput($post['opis']);
echo "</td></tr></table>n";
}
if ($k_page > 1) {
str('?', $k_page, $page);
}
echo "<div class = 'foot'>";
echo "«<a href='?id_mod=$mod[id]" . ($ank ? "&id=$ank[id]" : null) . "'>Список действий</a><br />n";
echo "«<a href='?$passgen" . ($ank ? "&id=$ank[id]" : null) . "'>Список модулей</a><br />n";
echo "</div>";
} elseif (isset($_GET['id_mod']) && mysql_result(mysql_query("SELECT COUNT(*) FROM `admin_log` WHERE `mod` = '" . intval($_GET['id_mod']) . "'" . ($ank ? " AND `id_user` = '$ank[id]'" : null)), 0) != 0) {
// действия в модуле
$mod = mysql_fetch_assoc(mysql_query("SELECT * FROM `admin_log_mod` WHERE `id` = '" . intval($_GET['id_mod']) . "' LIMIT 1"));
$q = mysql_query("SELECT `admin_log_act`.`name`, `admin_log_act`.`id`, COUNT(`admin_log`.`id`) AS `count` FROM `admin_log` LEFT JOIN `admin_log_act` ON `admin_log`.`act` = `admin_log_act`.`id` WHERE `admin_log`.`mod` = '$mod[id]'" . ($ank ? " AND `admin_log`.`id_user` = '$ank[id]'" : null) . " GROUP BY `admin_log`.`act`");
echo "<div class='menu'>n";
if (mysql_num_rows($q) == 0) {
echo "Нет действий в модуле '$mod[name]'";
}
while ($act = mysql_fetch_assoc($q)) {
echo "<a href='?id_mod=$mod[id]&id_act=$act[id]" . ($ank ? "&id=$ank[id]" : null) . "'>$act[name]</a> ($act[count])<br />n";
}
echo "</div>n";
echo "«<a href='?$passgen" . ($ank ? "&id=$ank[id]" : null) . "'>Список модулей</a><br />n";
} else {
// действия по модулям
$q = mysql_query("SELECT `admin_log_mod`.`name`, `admin_log_mod`.`id`, COUNT(`admin_log`.`id`) AS `count` FROM `admin_log` LEFT JOIN `admin_log_mod` ON `admin_log`.`mod` = `admin_log_mod`.`id`" . ($ank ? " WHERE `admin_log`.`id_user` = '$ank[id]'" : null) . " GROUP BY `admin_log`.`mod`");
echo "<div class='menu'>n";
if (mysql_num_rows($q) == 0) {
echo "Нет действий в модулях";
}
while ($mod = mysql_fetch_assoc($q)) {
echo "<a href='?id_mod=$mod[id]" . ($ank ? "&id=$ank[id]" : null) . "'>$mod[name]</a> ($mod[count])<br />n";
}
echo "</div>n";
}
if (user_access('adm_panel_show')) {
echo "<div class='foot'>n";
if (user_access('adm_show_adm')) {
echo "<img src = '/style/icons/left.png' /> <a href='administration.php'>Администрация</a><br />n";
}
echo "<img src = '/style/icons/left.png' /> <a href='/adm_panel/'>Панель управления</a><br />n";
echo "</div>n";
}
require_once '../sys/inc/tfoot.php';