function delete_forum($forum_id, $action_posts = 'delete', $action_subforums = 'delete', $posts_to_id = 0, $subforums_to_id = 0)
{
global $_CLASS;
$row = get_forum_info($forum_id);
extract($row);
$errors = array();
$log_action_posts = $log_action_forums = '';
if ($action_posts == 'delete') {
$_CLASS['core_db']->query('UPDATE ' . FORUMS_FORUMS_TABLE . ' SET forum_status = ' . ITEM_DELETING . ' WHERE forum_id = ' . $forum_id);
$log_action_posts = 'POSTS';
if ($delete_error = delete_forum_content($forum_id)) {
$errors[] = $delete_error;
}
} elseif ($action_posts == 'move') {
if (!$posts_to_id) {
$errors[] = $_CLASS['core_user']->lang['NO_DESTINATION_FORUM'];
} else {
$log_action_posts = 'MOVE_POSTS';
$sql = 'SELECT forum_name
FROM ' . FORUMS_FORUMS_TABLE . '
WHERE forum_id = ' . $posts_to_id;
$result = $_CLASS['core_db']->query($sql);
if (!($row = $_CLASS['core_db']->fetch_row_assoc($result))) {
$errors[] = $_CLASS['core_user']->lang['NO_FORUM'];
} else {
$posts_to_name = $row['forum_name'];
unset($row);
$errors[] = move_forum_content($forum_id, $subforums_to_id);
}
}
}
if (count($errors)) {
return $errors;
}
if ($action_subforums == 'delete') {
$log_action_forums = 'FORUMS';
$forum_ids = array($forum_id);
$rows = get_forum_branch($forum_id, 'children', 'descending', FALSE);
// Maybe add feild to the get_forum_branch
foreach ($rows as $row) {
$forum_ids[] = $row['forum_id'];
}
unset($rows);
$_CLASS['core_db']->query('UPDATE ' . FORUMS_FORUMS_TABLE . ' SET forum_status = ' . ITEM_DELETING . ' WHERE forum_id IN (' . implode(', ', $forum_ids) . ')');
foreach ($forum_ids as $forum_id) {
if ($delete_error = delete_forum_content($forum_id)) {
$errors[] = $delete_error;
}
}
if (count($errors)) {
return $errors;
}
$diff = count($forum_ids) * 2;
$sql = 'DELETE FROM ' . FORUMS_FORUMS_TABLE . '
WHERE forum_id IN (' . implode(', ', $forum_ids) . ')';
$_CLASS['core_db']->query($sql);
} elseif ($action_subforums == 'move') {
if (!$subforums_to_id) {
$errors[] = $_CLASS['core_user']->lang['NO_DESTINATION_FORUM'];
} else {
$log_action_forums = 'MOVE_FORUMS';
$sql = 'SELECT forum_name
FROM ' . FORUMS_FORUMS_TABLE . '
WHERE forum_id = ' . $subforums_to_id;
$result = $_CLASS['core_db']->query($sql);
if (!($row = $_CLASS['core_db']->fetch_row_assoc($result))) {
$errors[] = $_CLASS['core_user']->lang['NO_FORUM'];
} else {
$subforums_to_name = $row['forum_name'];
unset($row);
$sql = 'SELECT forum_id
FROM ' . FORUMS_FORUMS_TABLE . "\n\t\t\t\t\tWHERE parent_id = {$forum_id}";
$result = $_CLASS['core_db']->query($sql);
while ($row = $_CLASS['core_db']->fetch_row_assoc($result)) {
move_forum($row['forum_id'], intval($_POST['subforums_to_id']));
}
$_CLASS['core_db']->free_result($result);
$sql = 'UPDATE ' . FORUMS_FORUMS_TABLE . "\n\t\t\t\t\tSET parent_id = {$subforums_to_id}\n\t\t\t\t\tWHERE parent_id = {$forum_id}";
$_CLASS['core_db']->query($sql);
$diff = 2;
$sql = 'DELETE FROM ' . FORUMS_FORUMS_TABLE . "\n\t\t\t\t\tWHERE forum_id = {$forum_id}";
$_CLASS['core_db']->query($sql);
}
}
if (count($errors)) {
return $errors;
}
} else {
$diff = 2;
$sql = 'DELETE FROM ' . FORUMS_FORUMS_TABLE . "\n\t\t\tWHERE forum_id = {$forum_id}";
$_CLASS['core_db']->query($sql);
}
// Resync tree
$sql = 'UPDATE ' . FORUMS_FORUMS_TABLE . "\n\t\tSET right_id = right_id - {$diff}\n\t\tWHERE left_id < {$right_id} AND right_id > {$right_id}";
$_CLASS['core_db']->query($sql);
$sql = 'UPDATE ' . FORUMS_FORUMS_TABLE . "\n\t\tSET left_id = left_id - {$diff}, right_id = right_id - {$diff}\n\t\tWHERE left_id > {$right_id}";
$_CLASS['core_db']->query($sql);
if (!is_array($forum_ids)) {
$forum_ids = array($forum_id);
}
// Delete forum ids from extension groups table
$sql = 'SELECT group_id, allowed_forums
FROM ' . EXTENSION_GROUPS_TABLE . "\n\t\tWHERE allowed_forums <> ''";
$result = $_CLASS['core_db']->query($sql);
while ($row = $_CLASS['core_db']->fetch_row_assoc($result)) {
$allowed_forums = unserialize(trim($row['allowed_forums']));
$allowed_forums = array_diff($allowed_forums, $forum_ids);
$sql = 'UPDATE ' . EXTENSION_GROUPS_TABLE . " \n\t\t\tSET allowed_forums = '" . (sizeof($allowed_forums) ? serialize($allowed_forums) : '') . "'\n\t\t\tWHERE group_id = {$row['group_id']}";
$_CLASS['core_db']->query($sql);
}
$_CLASS['core_cache']->destroy('extensions');
$log_action = implode('_', array($log_action_posts, $log_action_forums));
switch ($log_action) {
case 'MOVE_POSTS_MOVE_FORUMS':
add_log('admin', 'LOG_FORUM_DEL_MOVE_POSTS_MOVE_FORUMS', $posts_to_name, $subforums_to_name, $forum_name);
break;
case 'MOVE_POSTS_FORUMS':
add_log('admin', 'LOG_FORUM_DEL_MOVE_POSTS_FORUMS', $posts_to_name, $forum_name);
break;
case 'POSTS_MOVE_FORUMS':
add_log('admin', 'LOG_FORUM_DEL_POSTS_MOVE_FORUMS', $subforums_to_name, $forum_name);
break;
case '_MOVE_FORUMS':
add_log('admin', 'LOG_FORUM_DEL_MOVE_FORUMS', $subforums_to_name, $forum_name);
break;
case 'MOVE_POSTS_':
add_log('admin', 'LOG_FORUM_DEL_MOVE_POSTS', $posts_to_name, $forum_name);
break;
case 'POSTS_FORUMS':
add_log('admin', 'LOG_FORUM_DEL_POSTS_FORUMS', $forum_name);
break;
case '_FORUMS':
add_log('admin', 'LOG_FORUM_DEL_FORUMS', $forum_name);
break;
case 'POSTS_':
add_log('admin', 'LOG_FORUM_DEL_POSTS', $forum_name);
break;
}
return $errors;
}
/**
* Remove complete forum
*/
function delete_forum($forum_id, $action_posts = 'delete', $action_subforums = 'delete', $posts_to_id = 0, $subforums_to_id = 0)
{
global $_CLASS;
$forum_data = get_forum_info($forum_id);
$errors = array();
$log_action_posts = $log_action_forums = $posts_to_name = $subforums_to_name = '';
$forum_ids = array($forum_id);
if ($action_posts == 'delete') {
$log_action_posts = 'POSTS';
$errors = array_merge($errors, delete_forum_content($forum_id));
} else {
if ($action_posts == 'move') {
if (!$posts_to_id) {
$errors[] = $_CLASS['core_user']->lang['NO_DESTINATION_FORUM'];
} else {
$log_action_posts = 'MOVE_POSTS';
$sql = 'SELECT forum_name
FROM ' . FORUMS_FORUMS_TABLE . '
WHERE forum_id = ' . $posts_to_id;
$result = $_CLASS['core_db']->query($sql);
$row = $_CLASS['core_db']->fetch_row_assoc($result);
$_CLASS['core_db']->free_result($result);
if (!$row) {
$errors[] = $_CLASS['core_user']->lang['NO_FORUM'];
} else {
$posts_to_name = $row['forum_name'];
$errors = array_merge($errors, move_forum_content($forum_id, $posts_to_id));
}
}
}
}
if (sizeof($errors)) {
return $errors;
}
if ($action_subforums === 'delete') {
$log_action_forums = 'FORUMS';
$rows = get_forum_branch($forum_id, 'children', 'descending', false);
foreach ($rows as $row) {
$forum_ids[] = $row['forum_id'];
$errors = array_merge($errors, delete_forum_content($row['forum_id']));
}
if (sizeof($errors)) {
return $errors;
}
$diff = sizeof($forum_ids) * 2;
$sql = 'DELETE FROM ' . FORUMS_FORUMS_TABLE . '
WHERE forum_id IN (' . implode(', ', $forum_ids) . ')';
$_CLASS['core_db']->query($sql);
$sql = 'DELETE FROM ' . FORUMS_ACL_TABLE . '
WHERE forum_id IN (' . implode(', ', $forum_ids) . ')';
$_CLASS['core_db']->query($sql);
} else {
if ($action_subforums === 'move') {
if (!$subforums_to_id) {
$errors[] = $_CLASS['core_user']->lang['NO_DESTINATION_FORUM'];
} else {
$log_action_forums = 'MOVE_FORUMS';
$sql = 'SELECT forum_name
FROM ' . FORUMS_FORUMS_TABLE . '
WHERE forum_id = ' . $subforums_to_id;
$result = $_CLASS['core_db']->query($sql);
$row = $_CLASS['core_db']->fetch_row_assoc($result);
$_CLASS['core_db']->free_result($result);
if (!$row) {
$errors[] = $_CLASS['core_user']->lang['NO_FORUM'];
} else {
$subforums_to_name = $row['forum_name'];
$sql = 'SELECT forum_id
FROM ' . FORUMS_FORUMS_TABLE . "\r\n\t\t\t\t\tWHERE parent_id = {$forum_id}";
$result = $_CLASS['core_db']->query($sql);
while ($row = $_CLASS['core_db']->fetch_row_assoc($result)) {
move_forum($row['forum_id'], $subforums_to_id);
}
$_CLASS['core_db']->free_result($result);
$sql = 'UPDATE ' . FORUMS_FORUMS_TABLE . "\r\n\t\t\t\t\tSET parent_id = {$subforums_to_id}\r\n\t\t\t\t\tWHERE parent_id = {$forum_id}";
$_CLASS['core_db']->query($sql);
$diff = 2;
$sql = 'DELETE FROM ' . FORUMS_FORUMS_TABLE . "\r\n\t\t\t\t\tWHERE forum_id = {$forum_id}";
$_CLASS['core_db']->query($sql);
$sql = 'DELETE FROM ' . FORUMS_ACL_TABLE . '
WHERE forum_id = ' . $forum_id;
$_CLASS['core_db']->query($sql);
}
}
if (sizeof($errors)) {
return $errors;
}
} else {
$diff = 2;
$sql = 'DELETE FROM ' . FORUMS_FORUMS_TABLE . "\r\n\t\t\tWHERE forum_id = {$forum_id}";
$_CLASS['core_db']->query($sql);
$sql = 'DELETE FROM ' . FORUMS_ACL_TABLE . '
WHERE forum_id = ' . $forum_id;
$_CLASS['core_db']->query($sql);
}
}
// Resync tree
$sql = 'UPDATE ' . FORUMS_FORUMS_TABLE . "\r\n\t\tSET right_id = right_id - {$diff}\r\n\t\tWHERE left_id < {$forum_data['right_id']} AND right_id > {$forum_data['right_id']}";
$_CLASS['core_db']->query($sql);
$sql = 'UPDATE ' . FORUMS_FORUMS_TABLE . "\r\n\t\tSET left_id = left_id - {$diff}, right_id = right_id - {$diff}\r\n\t\tWHERE left_id > {$forum_data['right_id']}";
$_CLASS['core_db']->query($sql);
// Delete forum ids from extension groups table
$sql = 'SELECT group_id, allowed_forums
FROM ' . FORUMS_EXTENSION_GROUPS_TABLE;
$result = $_CLASS['core_db']->query($sql);
while ($row = $_CLASS['core_db']->fetch_row_assoc($result)) {
if (!$row['allowed_forums']) {
continue;
}
$allowed_forums = unserialize(trim($row['allowed_forums']));
$allowed_forums = array_diff($allowed_forums, $forum_ids);
$sql = 'UPDATE ' . FORUMS_EXTENSION_GROUPS_TABLE . " \r\n\t\t\tSET allowed_forums = '" . (sizeof($allowed_forums) ? serialize($allowed_forums) : '') . "'\r\n\t\t\tWHERE group_id = {$row['group_id']}";
$_CLASS['core_db']->query($sql);
}
$_CLASS['core_db']->free_result($result);
$_CLASS['core_cache']->destroy('_extensions');
$log_action = implode('_', array($log_action_posts, $log_action_forums));
switch ($log_action) {
case 'MOVE_POSTS_MOVE_FORUMS':
add_log('admin', 'LOG_FORUM_DEL_MOVE_POSTS_MOVE_FORUMS', $posts_to_name, $subforums_to_name, $forum_data['forum_name']);
break;
case 'MOVE_POSTS_FORUMS':
add_log('admin', 'LOG_FORUM_DEL_MOVE_POSTS_FORUMS', $posts_to_name, $forum_data['forum_name']);
break;
case 'POSTS_MOVE_FORUMS':
add_log('admin', 'LOG_FORUM_DEL_POSTS_MOVE_FORUMS', $subforums_to_name, $forum_data['forum_name']);
break;
case '_MOVE_FORUMS':
add_log('admin', 'LOG_FORUM_DEL_MOVE_FORUMS', $subforums_to_name, $forum_data['forum_name']);
break;
case 'MOVE_POSTS_':
add_log('admin', 'LOG_FORUM_DEL_MOVE_POSTS', $posts_to_name, $forum_data['forum_name']);
break;
case 'POSTS_FORUMS':
add_log('admin', 'LOG_FORUM_DEL_POSTS_FORUMS', $forum_data['forum_name']);
break;
case '_FORUMS':
add_log('admin', 'LOG_FORUM_DEL_FORUMS', $forum_data['forum_name']);
break;
case 'POSTS_':
add_log('admin', 'LOG_FORUM_DEL_POSTS', $forum_data['forum_name']);
break;
default:
add_log('admin', 'LOG_FORUM_DEL_FORUM', $forum_data['forum_name']);
break;
}
return $errors;
}
$forumdata[$i]['LASTPOST_USERID'] = $res['lastposter_userid'];
$forumdata[$i]['LASTPOST_TIME'] = $res['lastposttime'];
$forumdata[$i]['LASTPOST_LINK'] = HTTPDIR . $set['forum']['directory'] . '/' . 'thread.php?id=' . $thread['threadid'] . '&goto=lastpost';
//Optionen
$forumdata[$i]['LINK_DEL'] = mklink('user.php?action=subscribe&option=delete&id=' . $subsrcinfo_forums[$forumid]['id'], 'user,subscribe.html?option=delete&id=' . $subsrcinfo_forums[$forumid]['id']);
$forumdata[$i]['LINK_EDIT'] = mklink('user.php?action=subscribe&option=edit&id=' . $subsrcinfo_forums[$forumid]['id'], 'user,subscribe.html?option=edit&id=' . $subsrcinfo_forums[$forumid]['id']);
}
}
}
//Auflistung THEMEN
if (count($subscr_threads)) {
$data = $db->fetch("SELECT * FROM " . PRE . "_forum_threads WHERE threadid IN (" . implode(',', $subscr_threads) . ") ORDER BY lastposttime DESC");
if (count($data)) {
//Fehlerhafte Abonnements löschen
foreach ($data as $key => $res) {
$foruminfo = get_forum_info($res['forumid']);
if (!$foruminfo || !forum_access_read($foruminfo)) {
unset($data[$key]);
$db->query("DELETE FROM " . PRE . "_forum_subscriptions WHERE ( type='thread' AND source='" . $res['threadid'] . "' AND userid='" . $user->info['userid'] . "' )");
}
}
foreach ($data as $res) {
++$i;
//Link
$link = HTTPDIR . $set['forum']['directory'] . '/' . mkrellink('thread.php?id=' . $res['threadid'], 'thread,' . $res['threadid'] . ',1' . urlformat($res['title']) . '.html');
//Icon
if ($res['icon'] != -1 && isset($set['forum']['icons'][(int) $res['icon']])) {
$icon = $set['forum']['icons'][(int) $res['icon']]['file'];
} else {
$icon = '';
}
<?
/*
New post page
This is the page that's loaded if someone wants to make a new topic.
Information to be expected in $_GET:
forumid: The ID of the forum that it's being posted in
*/
$ForumID = $_GET['forumid'];
if(!is_number($ForumID)) {
error(404);
}
$Forum = get_forum_info($ForumID);
if($Forum === false) {
error(404);
}
if($LoggedUser['Class'] < $Forum['MinClassCreate']) { error(403); }
show_header('Forums > '.$Forum['Name'].' > New Topic');
?>
<div class="thin">
<h2><a href="forums.php">Forums</a> > <a href="forums.php?action=viewforum&forumid=<?php
echo $ForumID;
?>
"><?php
echo $Forum['Name'];
?>