{

$sql = 'DELETE FROM ' . ACL_USERS_TABLE . '

WHERE forum_id = ' . (int) $forum_data['forum_id'];

$sql = 'DELETE FROM ' . ACL_GROUPS_TABLE . '

WHERE forum_id = ' . (int) $forum_data['forum_id'];

}

// From the mysql documentation:

$sql = 'SELECT user_id, auth_option_id, auth_role_id, auth_setting

FROM ' . ACL_USERS_TABLE . '

WHERE forum_id = ' . $forum_perm_from;

$users_sql_ary = array();

{

$users_sql_ary[] = array(

'user_id' => (int) $row['user_id'],

'auth_setting' => (int) $row['auth_setting']

);

}

// Copy permisisons from/to the acl groups table (only forum_id gets changed)

$sql = 'SELECT group_id, auth_option_id, auth_role_id, auth_setting

FROM ' . ACL_GROUPS_TABLE . '

WHERE forum_id = ' . $forum_perm_from;

$groups_sql_ary = array();

{

$groups_sql_ary[] = array(

'group_id' => (int) $row['group_id'],

'auth_setting' => (int) $row['auth_setting']

);

}

// Now insert the data

cache_moderators();

}

$sql = 'SELECT *

FROM ' . FORUMS_TABLE . "

WHERE forum_id = $forum_id";

if (!$row)

{

$sql = 'SELECT forum_name, forum_topics_real

FROM ' . FORUMS_TABLE . "

WHERE forum_id = $forum_id";

if (!$row)

{

$sql = 'SELECT MIN(topic_id) as min_topic_id, MAX(topic_id) as max_topic_id

FROM ' . TOPICS_TABLE . '

WHERE forum_id = ' . $forum_id;

// Typecast to int if there is no data available

$row2['min_topic_id'] = (int) $row2['min_topic_id'];

FROM ' . TOPICS_TABLE . '

WHERE forum_id = ' . $forum_id . '

AND topic_id BETWEEN ' . $start . ' AND ' . $end;

$start += $batch_size;

$sql = 'SELECT forum_name, forum_type

FROM ' . FORUMS_TABLE . "

WHERE forum_id = $forum_id";

if (!$row)

{

FROM ' . FORUMS_TABLE . '

WHERE forum_type = ' . FORUM_POST . "

AND forum_id <> $forum_id";

{

$template->assign_vars(array(

'S_MOVE_FORUM_OPTIONS' => make_forum_select($forum_data['parent_id'], $forum_id, false, true, false))

);

}

// Subforum move options

if ($action == 'edit' && $forum_data['forum_type'] == FORUM_CAT)

FROM ' . FORUMS_TABLE . '

WHERE forum_type = ' . FORUM_POST . "

AND forum_id <> $forum_id";

{

$template->assign_vars(array(

'S_MOVE_FORUM_OPTIONS' => make_forum_select($forum_data['parent_id'], $subforums_id)) // , false, true, false???

);

}

$template->assign_vars(array(

'S_HAS_SUBFORUMS' => ($forum_data['right_id'] - $forum_data['left_id'] > 1) ? true : false,

FROM ' . FORUMS_TABLE . '

WHERE forum_type = ' . FORUM_POST . "

AND forum_id <> $forum_id";

{

$template->assign_vars(array(

'S_MOVE_FORUM_OPTIONS' => make_forum_select($forum_data['parent_id'], $subforums_id, false, true)) // , false, true, false???

);

}

$parent_id = ($this->parent_id == $forum_id) ? 0 : $this->parent_id;

FROM ' . FORUMS_TABLE . "

WHERE parent_id = $this->parent_id

ORDER BY left_id";

{

do

{

'U_SYNC' => $url . '&amp;action=sync')

);

}

}

else if ($this->parent_id)

{

'U_SYNC' => $url . '&amp;action=sync')

);

}

$template->assign_vars(array(

'ERROR_MSG' => (sizeof($errors)) ? implode('<br />', $errors) : '',

$sql = 'SELECT *

FROM ' . FORUMS_TABLE . "

WHERE forum_id = $forum_id";

if (!$row)

{

$sql = 'SELECT left_id, right_id, forum_type

FROM ' . FORUMS_TABLE . '

WHERE forum_id = ' . $forum_data_sql['parent_id'];

if (!$row)

{

$sql = 'UPDATE ' . FORUMS_TABLE . '

SET left_id = left_id + 2, right_id = right_id + 2

WHERE left_id > ' . $row['right_id'];

$sql = 'UPDATE ' . FORUMS_TABLE . '

SET right_id = right_id + 2

WHERE ' . $row['left_id'] . ' BETWEEN left_id AND right_id';

$forum_data_sql['left_id'] = $row['right_id'];

$forum_data_sql['right_id'] = $row['right_id'] + 1;

{

$sql = 'SELECT MAX(right_id) AS right_id

FROM ' . FORUMS_TABLE;

$forum_data_sql['left_id'] = $row['right_id'] + 1;

$forum_data_sql['right_id'] = $row['right_id'] + 2;

}

add_log('admin', 'LOG_FORUM_ADD', $forum_data['forum_name']);

}

if (sizeof($forum_ids))

{

$sql = 'DELETE FROM ' . FORUMS_TABLE . '

$sql = 'DELETE FROM ' . ACL_GROUPS_TABLE . '

$sql = 'DELETE FROM ' . ACL_USERS_TABLE . '

// Delete forum ids from extension groups table

$sql = 'SELECT group_id, allowed_forums

FROM ' . EXTENSION_GROUPS_TABLE;

{

if (!$_row['allowed_forums'])

{

$sql = 'UPDATE ' . EXTENSION_GROUPS_TABLE . "

SET allowed_forums = '" . ((sizeof($allowed_forums)) ? serialize($allowed_forums) : '') . "'

WHERE group_id = {$_row['group_id']}";

}

phpbb::$acm->destroy('extensions');

}

$sql = 'SELECT forum_name

FROM ' . FORUMS_TABLE . '

WHERE forum_id = ' . $subforums_to_id;

if (!$_row)

{

$sql = 'SELECT forum_id

FROM ' . FORUMS_TABLE . "

WHERE parent_id = {$row['forum_id']}";

{

$this->move_forum($_row['forum_id'], $subforums_to_id);

}

$sql = 'UPDATE ' . FORUMS_TABLE . "

SET parent_id = $subforums_to_id

WHERE parent_id = {$row['forum_id']}";

}

// Adjust the left/right id

$sql = 'UPDATE ' . FORUMS_TABLE . '

SET right_id = left_id + 1

WHERE forum_id = ' . $row['forum_id'];

}

}

else if ($row['forum_type'] == FORUM_CAT && $forum_data_sql['forum_type'] == FORUM_POST)

// the forum name has changed, clear the parents list of all forums (for safety)

$sql = 'UPDATE ' . FORUMS_TABLE . "

SET forum_parents = ''";

}

// Setting the forum id to the forum id is not really received well by some dbs. ;)

unset($forum_data_sql['forum_id']);

$sql = 'UPDATE ' . FORUMS_TABLE . '

WHERE forum_id = ' . $forum_id;

// Add it back

$forum_data['forum_id'] = $forum_id;

SET right_id = right_id - $diff, forum_parents = ''

WHERE left_id < " . $from_data['right_id'] . "

AND right_id > " . $from_data['right_id'];

// Resync righthand side of tree

$sql = 'UPDATE ' . FORUMS_TABLE . "

SET left_id = left_id - $diff, right_id = right_id - $diff, forum_parents = ''

WHERE left_id > " . $from_data['right_id'];

if ($to_id > 0)

{

$sql = 'UPDATE ' . FORUMS_TABLE . "

SET right_id = right_id + $diff, forum_parents = ''

WHERE " . $to_data['right_id'] . ' BETWEEN left_id AND right_id

// Resync the righthand side of the tree

$sql = 'UPDATE ' . FORUMS_TABLE . "

SET left_id = left_id + $diff, right_id = right_id + $diff, forum_parents = ''

WHERE left_id > " . $to_data['right_id'] . '

// Resync moved branch

$to_data['right_id'] += $diff;

{

$sql = 'SELECT MAX(right_id) AS right_id

FROM ' . FORUMS_TABLE . '

$diff = '+ ' . ($row['right_id'] - $from_data['left_id'] + 1);

}

$sql = 'UPDATE ' . FORUMS_TABLE . "

SET left_id = left_id $diff, right_id = right_id $diff, forum_parents = ''

return $errors;

}

$sql = "UPDATE $table

SET forum_id = $to_id

WHERE forum_id = $from_id";

}

unset($table_ary);

{

$sql = "DELETE FROM $table

WHERE forum_id = $from_id";

}

if ($sync)

$sql = 'SELECT forum_name

FROM ' . FORUMS_TABLE . '

WHERE forum_id = ' . $posts_to_id;

if (!$row)

{

$diff = sizeof($forum_ids) * 2;

$sql = 'DELETE FROM ' . FORUMS_TABLE . '

$sql = 'DELETE FROM ' . ACL_GROUPS_TABLE . '

$sql = 'DELETE FROM ' . ACL_USERS_TABLE . '

}

else if ($action_subforums == 'move')

{

$sql = 'SELECT forum_name

FROM ' . FORUMS_TABLE . '

WHERE forum_id = ' . $subforums_to_id;

if (!$row)

{

$sql = 'SELECT forum_id

FROM ' . FORUMS_TABLE . "

WHERE parent_id = $forum_id";

{

$this->move_forum($row['forum_id'], $subforums_to_id);

}

// Grab new forum data for correct tree updating later

$forum_data = $this->get_forum_info($forum_id);

$sql = 'UPDATE ' . FORUMS_TABLE . "

SET parent_id = $subforums_to_id

WHERE parent_id = $forum_id";

$diff = 2;

$sql = 'DELETE FROM ' . FORUMS_TABLE . "

WHERE forum_id = $forum_id";

$sql = 'DELETE FROM ' . ACL_GROUPS_TABLE . "

WHERE forum_id = $forum_id";

$sql = 'DELETE FROM ' . ACL_USERS_TABLE . "

WHERE forum_id = $forum_id";

}

}

$diff = 2;

$sql = 'DELETE FROM ' . FORUMS_TABLE . "

WHERE forum_id = $forum_id";

$sql = 'DELETE FROM ' . ACL_GROUPS_TABLE . "

WHERE forum_id = $forum_id";

$sql = 'DELETE FROM ' . ACL_USERS_TABLE . "

WHERE forum_id = $forum_id";

}

// Resync tree

$sql = 'UPDATE ' . FORUMS_TABLE . "

SET right_id = right_id - $diff

WHERE left_id < {$forum_data['right_id']} AND right_id > {$forum_data['right_id']}";

$sql = 'UPDATE ' . FORUMS_TABLE . "

SET left_id = left_id - $diff, right_id = right_id - $diff

WHERE left_id > {$forum_data['right_id']}";

// Delete forum ids from extension groups table

$sql = 'SELECT group_id, allowed_forums

FROM ' . EXTENSION_GROUPS_TABLE;

{

if (!$row['allowed_forums'])

{

$sql = 'UPDATE ' . EXTENSION_GROUPS_TABLE . "

SET allowed_forums = '" . ((sizeof($allowed_forums)) ? serialize($allowed_forums) : '') . "'

WHERE group_id = {$row['group_id']}";

}

phpbb::$acm->destroy('extensions');

{

include_once(PHPBB_ROOT_PATH . 'includes/functions_posting.' . PHP_EXT);

// Select then delete all attachments

$sql = 'SELECT a.topic_id

WHERE p.forum_id = $forum_id

AND a.in_message = 0

AND a.topic_id = p.topic_id";

$topic_ids = array();

{

$topic_ids[] = $row['topic_id'];

}

delete_attachments('topic', $topic_ids, false);

WHERE forum_id = ' . $forum_id . '

AND post_postcount = 1

AND post_approved = 1';

$post_counts = array();

{

$post_counts[$row['poster_id']] = (!empty($post_counts[$row['poster_id']])) ? $post_counts[$row['poster_id']] + 1 : 1;

}

{

case 'mysql':

$sql_where .= "\nAND $table.$field = " . POSTS_TABLE . ".$field";

}

break;

$sql = "SELECT $field

FROM " . POSTS_TABLE . '

WHERE forum_id = ' . $forum_id;

$ids = array();

{

$ids[] = $row[$field];

}

if (sizeof($ids))

{

foreach ($tables as $table)

{

}

}

}

foreach ($table_ary as $table)

{

}

// Set forum ids to 0

foreach ($table_ary as $table)

{

}

// Adjust users post counts

SET user_posts = 0

WHERE user_id = ' . $poster_id . '

AND user_posts < ' . $substract;

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_posts = user_posts - ' . $substract . '

WHERE user_id = ' . $poster_id . '

AND user_posts >= ' . $substract;

}

}

// Make sure the overall post/topic count is correct...

$sql = 'SELECT COUNT(post_id) AS stat

FROM ' . POSTS_TABLE . '

WHERE post_approved = 1';

set_config('num_posts', (int) $row['stat'], true);

$sql = 'SELECT COUNT(topic_id) AS stat

FROM ' . TOPICS_TABLE . '

WHERE topic_approved = 1';

set_config('num_topics', (int) $row['stat'], true);

$sql = 'SELECT COUNT(attach_id) as stat

FROM ' . ATTACHMENTS_TABLE;

set_config('num_files', (int) $row['stat'], true);

$sql = 'SELECT SUM(filesize) as stat

FROM ' . ATTACHMENTS_TABLE;

set_config('upload_dir_size', (float) $row['stat'], true);

FROM ' . FORUMS_TABLE . "

WHERE parent_id = {$forum_row['parent_id']}

AND " . (($action == 'move_up') ? "right_id < {$forum_row['right_id']} ORDER BY right_id DESC" : "left_id > {$forum_row['left_id']} ORDER BY left_id ASC");

$target = array();

{

$target = $row;

}

if (!sizeof($target))

{

WHERE

left_id BETWEEN {$left_id} AND {$right_id}

AND right_id BETWEEN {$left_id} AND {$right_id}";

return $target['forum_name'];

}