';
++$i;
}
}
echo '' .
'
';
break;
case 'htopics':
/*
-----------------------------------------------------------------
Управление скрытыми темами форума
-----------------------------------------------------------------
*/
echo '
';
$sort = '';
$link = '';
if (isset($_GET['usort'])) {
$sort = " AND `forum`.`user_id` = '" . abs(intval($_GET['usort'])) . "'";
$link = '&usort=' . abs(intval($_GET['usort']));
echo '';
}
if (isset($_GET['rsort'])) {
$sort = " AND `forum`.`refid` = '" . abs(intval($_GET['rsort'])) . "'";
$link = '&rsort=' . abs(intval($_GET['rsort']));
echo '';
}
if (isset($_POST['deltopic'])) {
if ($rights != 9) {
echo functions::display_error($lng['access_forbidden']);
require('../incfiles/end.php');
exit;
}
$req = mysql_query("SELECT `id` FROM `forum` WHERE `type` = 't' AND `close` = '1' $sort");
while ($res = mysql_fetch_assoc($req)) {
$req_f = mysql_query("SELECT * FROM `cms_forum_files` WHERE `topic` = '" . $res['id'] . "'");
if (mysql_num_rows($req_f)) {
// Удаляем файлы
while ($res_f = mysql_fetch_assoc($req_f)) {
unlink('../files/forum/attach/' . $res_f['filename']);
}
mysql_query("DELETE FROM `cms_forum_files` WHERE `topic` = '" . $res['id'] . "'");
}
// Удаляем посты
mysql_query("DELETE FROM `forum` WHERE `type` = 'm' AND `refid` = '" . $res['id'] . "'");
}
// Удаляем темы
$req = mysql_query("DELETE FROM `forum` WHERE `type` = 't' AND `close` = '1' $sort");
header('Location: index.php?act=forum&mod=htopics');
} else {
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `type` = 't' AND `close` = '1' $sort"), 0);
if ($total > $kmess) echo '';
$req = mysql_query("SELECT `forum`.*, `forum`.`id` AS `fid`, `forum`.`user_id` AS `id`, `forum`.`from` AS `name`, `forum`.`soft` AS `browser`, `users`.`rights`, `users`.`lastdate`, `users`.`sex`, `users`.`status`, `users`.`datereg`
FROM `forum` LEFT JOIN `users` ON `forum`.`user_id` = `users`.`id`
WHERE `forum`.`type` = 't' AND `forum`.`close` = '1' $sort ORDER BY `forum`.`id` DESC LIMIT $start, $kmess");
if (mysql_num_rows($req)) {
$i = 0;
while ($res = mysql_fetch_assoc($req)) {
$subcat = mysql_fetch_assoc(mysql_query("SELECT * FROM `forum` WHERE `id` = '" . $res['refid'] . "'"));
$cat = mysql_fetch_assoc(mysql_query("SELECT * FROM `forum` WHERE `id` = '" . $subcat['refid'] . "'"));
$ttime = '
' : '
';
echo functions::display_user($res, array(
'header' => $ttime,
'body' => $text,
'sub' => $subtext
));
echo '
';
++$i;
}
if ($rights == 9)
echo '
';
} else {
echo '';
}
echo '
' . $lng['total'] . ': ' . $total . '
';
if ($total > $kmess) {
echo '' .
'
';
}
}
break;
case 'hposts':
/*
-----------------------------------------------------------------
Управление скрытыми постави форума
-----------------------------------------------------------------
*/
echo '
';
$sort = '';
$link = '';
if (isset($_GET['tsort'])) {
$sort = " AND `forum`.`refid` = '" . abs(intval($_GET['tsort'])) . "'";
$link = '&tsort=' . abs(intval($_GET['tsort']));
echo '';
} elseif (isset($_GET['usort'])) {
$sort = " AND `forum`.`user_id` = '" . abs(intval($_GET['usort'])) . "'";
$link = '&usort=' . abs(intval($_GET['usort']));
echo '';
}
if (isset($_POST['delpost'])) {
if ($rights != 9) {
echo functions::display_error($lng['access_forbidden']);
require('../incfiles/end.php');
exit;
}
$req = mysql_query("SELECT `id` FROM `forum` WHERE `type` = 'm' AND `close` = '1' $sort");
while ($res = mysql_fetch_assoc($req)) {
$req_f = mysql_query("SELECT * FROM `cms_forum_files` WHERE `post` = '" . $res['id'] . "' LIMIT 1");
if (mysql_num_rows($req_f)) {
$res_f = mysql_fetch_assoc($req_f);
// Удаляем файлы
unlink('../files/forum/attach/' . $res_f['filename']);
mysql_query("DELETE FROM `cms_forum_files` WHERE `post` = '" . $res['id'] . "' LIMIT 1");
}
}
// Удаляем посты
mysql_query("DELETE FROM `forum` WHERE `type` = 'm' AND `close` = '1' $sort");
header('Location: index.php?act=forum&mod=hposts');
} else {
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `type` = 'm' AND `close` = '1' $sort"), 0);
if ($total > $kmess) echo '';
$req = mysql_query("SELECT `forum`.*, `forum`.`id` AS `fid`, `forum`.`user_id` AS `id`, `forum`.`from` AS `name`, `forum`.`soft` AS `browser`, `users`.`rights`, `users`.`lastdate`, `users`.`sex`, `users`.`status`, `users`.`datereg`
FROM `forum` LEFT JOIN `users` ON `forum`.`user_id` = `users`.`id`
WHERE `forum`.`type` = 'm' AND `forum`.`close` = '1' $sort ORDER BY `forum`.`id` DESC LIMIT $start, $kmess");
if (mysql_num_rows($req)) {
$i = 0;
while ($res = mysql_fetch_assoc($req)) {
$res['ip'] = ip2long($res['ip']);
$posttime = '
(' . functions::display_date($res['time']) . ')';
$page = ceil(mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `refid` = '" . $res['refid'] . "' AND `id` " . ($set_forum['upfp'] ? ">=" : "<=") . " '" . $res['fid'] . "'"), 0) / $kmess);
$text = mb_substr($res['text'], 0, 500);
$text = functions::checkout($text, 1, 0);
$text = preg_replace('#\[c\](.*?)\[/c\]#si', '
\1
', $text);
$theme = mysql_fetch_assoc(mysql_query("SELECT `id`, `text` FROM `forum` WHERE `id` = '" . $res['refid'] . "'"));
$text = '
' . $theme['text'] . ' >>' . $text;
$subtext = '
' . $lng_forum['filter_to'] . ': ';
$subtext .= '
' . $lng_forum['by_theme'] . ' | ';
$subtext .= '
' . $lng_forum['by_author'] . '';
echo $i % 2 ? '
' : '
';
echo functions::display_user($res, array(
'header' => $posttime,
'body' => $text,
'sub' => $subtext
));
echo '
';
++$i;
}
if ($rights == 9)
echo '
';
} else {
echo '';
}
echo '
' . $lng['total'] . ': ' . $total . '
';
if ($total > $kmess) {
echo '' .
'
';
}
}
break;
case 'moders':
/*
-----------------------------------------------------------------
Управление модераторами разделов
-----------------------------------------------------------------
*/
if (isset($_POST['submit'])) {
if (!$id) {
echo functions::display_error($lng['error_wrong_data'], '
' . $lng_forum['forum_management'] . '');
require('../incfiles/end.php');
exit;
}
if (isset($_POST['moder'])) {
$q = mysql_query("SELECT * FROM `forum` WHERE `type` = 'a' AND `refid` = '$id'");
while ($q1 = mysql_fetch_array($q)) {
if (!in_array($q1['from'], $_POST['moder'])) {
mysql_query("delete from `forum` where `id`='" . $q1['id'] . "'");
}
}
foreach ($_POST['moder'] as $v) {
$v = functions::check($v);
$q2 = mysql_query("SELECT * FROM `forum` WHERE `type` = 'a' AND `from` = '$v' AND `refid` = '$id'");
$q3 = mysql_num_rows($q2);
if ($q3 == 0) {
mysql_query("INSERT INTO `forum` SET
`refid` = '$id',
`type` = 'a',
`from` = '$v'");
}
}
} else {
mysql_query("DELETE * FROM `forum` WHERE `type` = 'a' AND `refid` = '$id'");
}
header("Location: index.php?act=forum&mod=moders&id=$id");
} else {
echo '
';
if (!empty($_GET['id'])) {
$typ = mysql_query("SELECT * FROM `forum` WHERE `id` = '$id'");
$ms = mysql_fetch_array($typ);
if ($ms['type'] != "f") {
echo functions::display_error($lng['error_wrong_data'], '
' . $lng_forum['forum_management'] . '');
require('../incfiles/end.php');
exit;
}
echo '';
echo '