function IndexForumDeletePost()
{
global $forum_lang;
if (!System::user()->isAdmin() || !CheckGet('topic', 'post', 'ok')) {
HackOff();
return;
}
if (isset($_GET['page']) && $_GET['page'] > 1) {
$page = '&page=' . SafeDB($_GET['page'], 11, int);
$page_ufu = '-{page}';
} else {
$page = '';
$page_ufu = '';
}
// Подтверждение на удаление
if (!isset($_GET['ok']) || !isset($_POST['text']) && System::config('forum/basket') || $_GET['ok'] == '0') {
$text = '<br>' . $forum_lang['delete_post'] . '?';
System::site()->AddTextBox($forum_lang['forum'], '<p align="center">' . $text . '</p>');
System::site()->AddTemplatedBox('', 'module/forum_delete_post.html');
System::site()->AddBlock('delete_form', true, false, 'form');
$vars = array();
$vars['basket'] = System::config('forum/basket');
$vars['url'] = 'index.php?name=forum&op=deletepost&topic=' . SafeDB($_GET['topic'], 11, int) . '&post=' . SafeDB($_GET['post'], 11, int) . $page . '&ok=1';
// Без UFU
System::site()->Blocks['delete_form']['vars'] = $vars;
return;
}
// Сообщение
$post_id = SafeEnv($_GET['post'], 11, int);
System::database()->Select('forum_posts', "`id`='{$post_id}'");
if (System::database()->NumRows() == 0) {
System::site()->AddTextBox($forum_lang['error'], $forum_lang['error_no_post']);
return;
}
$post = System::database()->FetchRow();
if ($post['delete'] == '1') {
// На удалении
System::site()->AddTextBox($forum_lang['error'], $forum_lang['post_basket']);
return;
}
// Тема
$topic_id = SafeEnv($_GET['topic'], 11, int);
System::database()->Select('forum_topics', "`id`='{$topic_id}'");
if (System::database()->NumRows() == 0) {
System::site()->AddTextBox($forum_lang['error'], $forum_lang['error_no_topic']);
return;
}
$topic = System::database()->FetchRow();
if ($topic['delete'] == '1') {
// Тема на удалении
System::site()->AddTextBox($forum_lang['error'], $forum_lang['topic_basket']);
return;
}
// Форум
$forum_id = SafeEnv($topic['forum_id'], 11, int);
System::database()->Select('forums', "`id`='{$forum_id}'");
if (System::database()->NumRows() == 0) {
System::site()->AddTextBox($forum_lang['error'], $forum_lang['error_no_forum']);
return;
}
$forum = System::database()->FetchRow();
// Удаление поста
if (System::config('forum/basket')) {
// Удаляем сообщение в корзину
$reason = '';
if (isset($_POST['text'])) {
$reason = SafeEnv($_POST['text'], 255, str);
}
Moderation_Do_Basket_Post($post_id, $reason);
} else {
ForumAdminDeletePost($post_id);
}
// Обновляем тему
$topic_posts = (int) $topic['posts'] - 1;
if ($topic_posts < 0) {
$topic_posts = 0;
}
$topic_set = "`posts`='{$topic_posts}'";
$topic_extra_set = false;
// Удаляется последний пост в теме (нужно ли обновлять последний пост в форуме)
if ($topic['last_post'] == $post['public'] && $topic['last_poster_id'] == $post['user_id']) {
$topic_extra_set = true;
$topic_set = ForumSetLastPost($topic_id, $topic_set, true);
}
System::database()->Update('forum_topics', $topic_set, "`id`='{$topic_id}'");
// Обновляем форум
$forum_posts = (int) $forum['posts'] - 1;
if ($forum_posts < 0) {
$forum_posts = 0;
}
$forum_set = "`posts`='{$forum_posts}'";
if ($topic_extra_set) {
// Только если удален последний пост в теме
$forum_set = ForumSetLastTopic($forum_id, $forum_set, true);
}
System::database()->Update('forums', $forum_set, "`id`= '{$forum_id}'");
// Очищаем кэш форума
ForumCacheClear();
GO(Ufu('index.php?name=forum&op=showtopic&topic=' . $topic_id . $page, 'forum/topic{topic}' . $page_ufu . '.html'));
}
function ForumModerationMergePosts($posts, $begin)
{
global $forum_lang;
if (!$begin) {
return $forum_lang['merge_posts'];
}
$posts = System::database()->Select('forum_posts', '(`id`=\'' . implode('\' or `id`=\'', $posts) . '\') and `delete`=\'0\'');
$merged_posts = count($posts);
if ($merged_posts < 2) {
return false;
}
SortArray($posts, 'public', false);
$post = $posts[0];
// Тема
$topic_id = SafeEnv($post['object'], 11, int);
System::database()->Select('forum_topics', "`id`='{$topic_id}'");
if (System::database()->NumRows() == 0) {
System::site()->AddTextBox($forum_lang['error'], $forum_lang['error_no_topic']);
return false;
}
$topic = System::database()->FetchRow();
if ($topic['delete'] == '1') {
// Тема на удалении
System::site()->AddTextBox($forum_lang['error'], $forum_lang['topic_basket']);
return false;
}
// Форум
$forum_id = SafeEnv($topic['forum_id'], 11, int);
System::database()->Select('forums', "`id`='{$forum_id}'");
if (System::database()->NumRows() == 0) {
System::site()->AddTextBox($forum_lang['error'], $forum_lang['error_no_forum']);
return false;
}
$forum = System::database()->FetchRow();
// Объединяем сообщения и удаляем старые
$new_post_message = '';
$where = '';
foreach ($posts as $p) {
if ($new_post_message != '') {
$where .= "`id`='" . SafeEnv($p['id'], 11, int) . "' or ";
}
$new_post_message .= $p['message'] . "\r\n\r\n";
}
$new_post_message = SafeEnv($new_post_message, 0, str);
$post_id = SafeEnv($post['id'], 11, int);
System::database()->Update('forum_posts', "`message`='{$new_post_message}'", "`id`='{$post_id}'");
$where = substr($where, 0, strlen($where) - 4);
if ($where != '') {
System::database()->Delete('forum_posts', $where);
}
if ($merged_posts >= 2) {
// Обновляем тему
$topic_posts = (int) $topic['posts'] - ($merged_posts - 1);
if ($topic_posts < 0) {
$topic_posts = 0;
}
$topic_set = "`posts`='{$topic_posts}'";
ForumSetLastPost($topic_id, $topic_set);
// Обновляем форум
$forum_posts = (int) $forum['posts'] - ($merged_posts - 1);
if ($forum_posts < 0) {
$forum_posts = 0;
}
$forum_set = "`posts`='{$forum_posts}'";
ForumSetLastTopic($forum_id, $forum_set);
}
ForumCacheClear();
return true;
}
function IndexForumRestoreBasketTopic($topic_id = 0, $go_back = true)
{
global $forum_lang;
if (!System::user()->isAdmin()) {
HackOff();
return;
}
$topic = System::database()->Select('forum_topics', "`id`='{$topic_id}' and `delete`='1'");
if (count($topic) > 0) {
$topic = $topic[0];
$forum_id = SafeEnv($topic['forum_id'], 11, int);
// Восстанавливаем количество сообщений и тем для форума
System::database()->Select('forums', "`id`='{$forum_id}'");
if (System::database()->NumRows() == 0) {
// Форум не найден
System::site()->AddTextBox($forum_lang['error'], $forum_lang['error_no_forum']);
return;
}
$forum = System::database()->FetchRow();
$forum_topics = SafeEnv($forum['topics'], 11, int) + 1;
if ($forum_topics < 0) {
$forum_topics = 0;
}
$forum_posts = SafeEnv($forum['posts'], 11, int) + SafeEnv($topic['posts'], 11, int);
if ($forum_posts < 0) {
$forum_posts = 0;
}
$forum_set = "`topics`='{$forum_topics}',`posts`='{$forum_posts}'";
System::database()->Update('forums', $forum_set, "`id`='{$forum_id}'");
// Восстанавливаем тему
System::database()->Update('forum_topics', "`delete`='0'", "`id`='{$topic_id}'");
// Удаляем метку в корзине
System::database()->Delete('forum_basket_topics', "`obj_id`='{$topic_id}'");
// Устанавливаем инф-ю о последнем сообщении для темы и форума
ForumSetLastPost($topic_id);
ForumSetLastTopic($forum_id);
// Очищаем кэш форума
ForumCacheClear();
if ($go_back) {
if (isset($_GET['back'])) {
GoRefererUrl($_GET['back']);
} else {
GoBack();
}
}
} else {
System::site()->AddTextBox($forum_lang['error'], $forum_lang['error_no_topic']);
return;
}
}
function IndexForumDeleteTopic()
{
global $forum_lang;
if (!System::user()->isAdmin() || !CheckGet('topic', 'ok')) {
HackOff();
return;
}
$topic_id = SafeEnv($_GET['topic'], 11, int);
// Подтверждение на удаление
if (!isset($_GET['ok']) || !isset($_POST['text']) && System::config('forum/basket') || $_GET['ok'] == '0') {
System::database()->Select('forum_topics', "`id`='" . SafeEnv($_GET['topic'], 11, int) . "'");
$topic = System::database()->FetchRow();
$text = $forum_lang['delete_topic'] . ' "' . SafeDB($topic['title'], 255, str) . '"?';
System::site()->AddTextBox($forum_lang['forum'], '<p align="center">' . $text . '</p>');
System::site()->AddTemplatedBox('', 'module/forum_delete_post.html');
System::site()->AddBlock('delete_form', true, false, 'form');
$vars = array();
$vars['basket'] = System::config('forum/basket') == true;
$vars['url'] = 'index.php?name=forum&op=deletetopic&topic=' . SafeEnv($_GET['topic'], 11, int) . '&ok=1';
// Без UFU
System::site()->Blocks['delete_form']['vars'] = $vars;
return;
}
// Вытаскиваем тему
System::database()->Select('forum_topics', "`id`='{$topic_id}'");
if (System::database()->NumRows() == 0) {
System::site()->AddTextBox($forum_lang['error'], $forum_lang['error_no_topic']);
return;
}
$topic = System::database()->FetchRow();
if ($topic['delete'] == '1') {
// Удалена в корзину
System::site()->AddTextBox($forum_lang['error'], $forum_lang['topic_basket']);
return;
}
// Удаление
if (System::config('forum/basket')) {
// Удаляем тему в корзину
$reason = '';
if (isset($_POST['text'])) {
$reason = SafeEnv($_POST['text'], 255, str);
}
Moderation_Do_Basket_Topic($topic_id, $reason);
} else {
ForumAdminDeleteTopic($topic_id);
}
// Форум (Изменяем счетчики количества тем и сообщений, устанавливаем информацию о последнем посте)
$forum_id = SafeEnv($topic['forum_id'], 11, int);
System::database()->Select('forums', "`id`='{$forum_id}'");
if (System::database()->NumRows() == 0) {
System::site()->AddTextBox($forum_lang['error'], $forum_lang['error_no_forum']);
return;
}
$forum = System::database()->FetchRow();
// Значения счётчиков форума
$forum_topics = (int) $forum['topics'] - 1;
if ($forum_topics < 0) {
$forum_topics = 0;
}
$forum_posts = (int) $forum['posts'] - (int) $topic['posts'];
if ($forum_posts < 0) {
$forum_posts = 0;
}
$forum_set = "`topics`='{$forum_topics}',`posts`='{$forum_posts}'";
// Устанавливаем информацию о последнем посте в форуме
if ($forum['last_id'] == $topic_id) {
// Только если удалена тема с последним постом
$forum_set = ForumSetLastTopic($forum_id, $forum_set, true);
}
System::database()->Update('forums', $forum_set, "`id`= '{$forum_id}'");
// Очищаем кэш форума
ForumCacheClear();
GO(Ufu('index.php?name=forum&op=showforum&forum=' . $forum_id, 'forum/{forum}/'));
}
function ForumModerationMergeTopics($topics, $begin)
{
global $forum_lang;
if (count($topics) < 2) {
System::site()->AddTextBox($forum_lang['error'], $forum_lang['merge_topics_error']);
return false;
}
if (!$begin) {
$topics = System::database()->Select('forum_topics', '`id`=\'' . implode('\' or `id`=\'', $topics) . '\'');
$text = $forum_lang['confirm'] . ': ' . $forum_lang['merge_topics'];
$select_data = array();
$text .= '<ul style="margin: 10px 0;">';
foreach ($topics as $topic) {
$text .= '<li>' . SafeDB($topic['title'], 255, str) . '</li>';
System::site()->DataAdd($select_data, SafeDB($topic['id'], 11, int), SafeDB($topic['title'], 255, str), false);
}
$text .= '</ul>';
$text .= $forum_lang['merge_dest_topic'] . ':<br>' . System::site()->Select('dest_topic', $select_data) . '<br><br>';
return $text;
}
$destination_topic_id = SafeEnv($_POST['dest_topic'], 11, int);
$topics = System::database()->Select('forum_topics', '`id`=\'' . implode('\' or `id`=\'', $topics) . '\'');
// Счётчики
$deleted_topics = 0;
$moved_posts = 0;
$dst_topic = null;
foreach ($topics as $topic) {
$topic_id = SafeEnv($topic['id'], 11, int);
if ($topic_id != $destination_topic_id) {
$moved_posts += $topic['posts'] + 1;
System::database()->Update('forum_posts', "`object`='{$destination_topic_id}'", "`object`='{$topic_id}'");
System::database()->Delete('forum_topics', "`id`='{$topic_id}'");
System::database()->Delete('forum_topics_read', "`tid`='{$topic_id}'");
$deleted_topics++;
} else {
$forum_id = SafeEnv($topic['forum_id'], 11, int);
$dst_topic = $topic;
}
}
$topic_posts = (int) $dst_topic['posts'] + $moved_posts;
System::database()->Update('forum_topics', "`posts`='{$topic_posts}'", "`id`='{$destination_topic_id}'");
// Обновляем форум
System::database()->Select('forums', "`id`='{$forum_id}'");
$forum = System::database()->FetchRow();
$forum_topics = (int) $forum['topics'] - $deleted_topics;
$forum_posts = (int) $forum['posts'] + $deleted_topics;
// В темах стартовые сообщения не считаются постами и не учитываются
if ($forum_topics < 0) {
$forum_topics = 0;
}
if ($forum_posts < 0) {
$forum_posts = 0;
}
ForumSetLastTopic($forum_id, "`topics`='{$forum_topics}',`posts`='{$forum_posts}'");
ForumCacheClear();
}
