Файл: panel/includes/ban_panel.php
Строк: 186
<?php
/**
* @package JohnCMS
* @link http://johncms.com
* @copyright Copyright (C) 2008-2011 JohnCMS Community
* @license LICENSE.txt (see attached file)
* @version VERSION.txt (see attached file)
* @author http://johncms.com/about
*/
defined('_IN_JOHNADM') or die('Error: restricted access');
$lng_ban = core::load_lng('ban');
switch ($mod) {
case 'amnesty':
if ($rights < 9) {
echo functions::display_error($lng_ban['amnesty_access_error']);
} else {
echo '<div class="phdr"><a href="index.php?act=ban_panel"><b>' . $lng['ban_panel'] . '</b></a> | ' . $lng_ban['amnesty'] . '</div>';
if (isset($_POST['submit'])) {
$term = isset($_POST['term']) && $_POST['term'] == 1 ? 1 : 0;
if ($term) {
// Очищаем таблицу Банов
mysql_query("TRUNCATE TABLE `cms_ban_users`");
echo '<div class="gmenu"><p>' . $lng_ban['amnesty_clean_confirm'] . '</p></div>';
} else {
// Разбаниваем активные Баны
$req = mysql_query("SELECT * FROM `cms_ban_users` WHERE `ban_time` > '" . time() . "'");
while ($res = mysql_fetch_array($req)) {
$ban_left = $res['ban_time'] - time();
if ($ban_left < 2592000) {
$amnesty_msg = isset($lng_ban['amnesty']) ? mysql_real_escape_string($lng_ban['amnesty']) : 'Amnesty';
mysql_query("UPDATE `cms_ban_users` SET `ban_time`='" . time() . "', `ban_raz`='--$amnesty_msg--' WHERE `id` = '" . $res['id'] . "'");
}
}
echo '<div class="gmenu"><p>' . $lng_ban['amnesty_delban_confirm'] . '</p></div>';
}
} else {
echo '<form action="index.php?act=ban_panel&mod=amnesty" method="post"><div class="menu"><p>' .
'<input type="radio" name="term" value="0" checked="checked" /> ' . $lng_ban['amnesty_delban'] . '<br />' .
'<input type="radio" name="term" value="1" /> ' . $lng_ban['amnesty_clean'] .
'</p><p><input type="submit" name="submit" value="' . $lng_ban['amnesty'] . '" />' .
'</p></div></form>' .
'<div class="phdr"><small>' . $lng_ban['amnesty_help'] . '</small></div>';
}
echo '<p><a href="index.php?act=ban_panel">' . $lng['ban_panel'] . '</a><br /><a href="index.php">' . $lng['admin_panel'] . '</a></p>';
}
break;
default:
/*
-----------------------------------------------------------------
БАН-панель, список нарушителей
-----------------------------------------------------------------
*/
echo '<div class="phdr"><a href="index.php"><b>' . $lng['admin_panel'] . '</b></a> | ' . $lng['ban_panel'] . '</div>';
echo '<div class="topmenu"><span class="gray">' . $lng['sorting'] . ':</span> ';
if (isset($_GET['count']))
echo '<a href="index.php?act=ban_panel">' . $lng['term'] . '</a> | ' . $lng['infringements'] . '</div>';
else
echo $lng['term'] . ' | <a href="index.php?act=ban_panel&count">' . $lng['infringements'] . '</a></div>';
$sort = isset($_GET['count']) ? 'bancount' : 'bantime';
$req = mysql_query("SELECT `user_id` FROM `cms_ban_users` GROUP BY `user_id`");
$total = mysql_num_rows($req);
$req = mysql_query("SELECT COUNT(`cms_ban_users`.`user_id`) AS `bancount`, MAX(`cms_ban_users`.`ban_time`) AS `bantime`, `cms_ban_users`.`id` AS `ban_id`, `users`.*
FROM `cms_ban_users` LEFT JOIN `users` ON `cms_ban_users`.`user_id` = `users`.`id`
GROUP BY `user_id`
ORDER BY `$sort` DESC
LIMIT $start, $kmess");
if (mysql_num_rows($req)) {
while ($res = mysql_fetch_array($req)) {
echo '<div class="' . ($res['bantime'] > time() ? 'r' : '') . 'menu">';
$arg = array (
'header' => '<br /><img src="../images/block.gif" width="16" height="16" align="middle" /> <small><a href="../users/profile.php?act=ban&user=' . $res['id'] . '">' . $lng_ban['infringements_history'] . '</a> [' . $res['bancount'] . ']</small>'
);
echo functions::display_user($res, $arg);
echo '</div>';
}
} else {
echo '<div class="menu"><p>' . $lng['list_empty'] . '</p></div>';
}
echo '<div class="phdr">' . $lng['total'] . ': ' . $total . '</div>';
if ($total > $kmess) {
echo '<div class="topmenu">' . functions::display_pagination('index.php?act=ban_panel&', $start, $total, $kmess) . '</div>';
echo '<p><form action="index.php?act=ban_panel" method="post"><input type="text" name="page" size="2"/><input type="submit" value="' . $lng['to_page'] . ' >>"/></form></p>';
}
echo '<p>' . ($rights == 9 && $total ? '<a href="index.php?act=ban_panel&mod=amnesty">' . $lng_ban['amnesty'] . '</a><br />' : '') . '<a href="index.php">' . $lng['admin_panel'] . '</a></p>';
}
?>