From 8d6c391d4810d7e56d917da79803983998fe442e Mon Sep 17 00:00:00 2001 From: Ludovic Arnaud Date: Sun, 15 Sep 2002 16:14:35 +0000 Subject: First commit of updated forums management panel - crossing fingers git-svn-id: file:///svn/phpbb/trunk@2888 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/admin/admin_forums.php | 1488 +++++++++++++++++++++--------------------- 1 file changed, 760 insertions(+), 728 deletions(-) (limited to 'phpBB/admin/admin_forums.php') diff --git a/phpBB/admin/admin_forums.php b/phpBB/admin/admin_forums.php index ce5ad24541..19b9b6fc00 100644 --- a/phpBB/admin/admin_forums.php +++ b/phpBB/admin/admin_forums.php @@ -19,9 +19,9 @@ * ***************************************************************************/ -if ( !empty($setmodules) ) +if (!empty($setmodules)) { - if ( !$acl->get_acl_admin('forum') ) + if (!$acl->get_acl_admin('forum')) { return; } @@ -40,10 +40,32 @@ require($phpbb_root_path . 'extension.inc'); require('pagestart.' . $phpEx); include($phpbb_root_path . 'includes/functions_admin.'.$phpEx); +// +// Additional lang strings and constants +// +$lang['Category_name'] = 'Category name'; +$lang['Type'] = 'Type'; + +$lang['Parent'] = 'Parent'; +$lang['Locked'] = 'Locked'; +$lang['Unlocked'] = 'Unlocked'; + +$lang['General_settings'] = 'General settings'; +$lang['Forum_settings'] = 'Forum settings'; +$lang['Disable_post_count'] = 'Disable post count'; + +$lang['Default_style'] = 'Default style'; + +$lang['Move_posts'] = 'Move posts to'; +$lang['Delete_subforums'] = 'Delete subforums and associated posts'; +$lang['Move_subforums'] = 'Move subforums to'; + +define('ITEM_CATEGORY', 3); + // // Do we have forum admin permissions? // -if ( !$acl->get_acl_admin('forum') ) +if (!$acl->get_acl_admin('forum')) { message_die(MESSAGE, $lang['No_admin']); } @@ -51,748 +73,627 @@ if ( !$acl->get_acl_admin('forum') ) // // Mode setting // -if ( isset($HTTP_POST_VARS['mode']) || isset($HTTP_GET_VARS['mode']) ) +if (isset($HTTP_POST_VARS['mode']) || isset($HTTP_GET_VARS['mode'])) { - $mode = ( isset($HTTP_POST_VARS['mode']) ) ? $HTTP_POST_VARS['mode'] : $HTTP_GET_VARS['mode']; + $mode = (!empty($HTTP_POST_VARS['mode'])) ? $HTTP_POST_VARS['mode'] : $HTTP_GET_VARS['mode']; } else { $mode = ''; } -// -// Begin program proper -// -if ( isset($HTTP_POST_VARS['addforum']) || isset($HTTP_POST_VARS['addcategory']) ) +switch ($mode) { - $mode = ( isset($HTTP_POST_VARS['addforum']) ) ? "addforum" : "addcat"; + case 'move_up': + case 'move_down': + $show_index = TRUE; + $forum_id = intval($HTTP_GET_VARS['f']); + + $result = $db->sql_query('SELECT parent_id, left_id, right_id FROM ' . FORUMS_TABLE . " WHERE forum_id = $forum_id"); + if (!$row = $db->sql_fetchrow($result)) + { + message_die(ERROR, 'Forum does not exist'); + } + extract($row); + $forum_info = array($forum_id => $row); - if( $mode == "addforum" ) - { - list($cat_id) = each($HTTP_POST_VARS['addforum']); - // - // stripslashes needs to be run on this because slashes are added when the forum name is posted // - $forumname = stripslashes($HTTP_POST_VARS['forumname'][$cat_id]); - } -} + // Get the adjacent forum + // + if ($mode == 'move_up') + { + $sql = 'SELECT forum_id, left_id, right_id + FROM ' . FORUMS_TABLE . " + WHERE parent_id = $parent_id AND right_id < $right_id + ORDER BY right_id DESC"; + } + else + { + $sql = 'SELECT forum_id, left_id, right_id + FROM ' . FORUMS_TABLE . " + WHERE parent_id = $parent_id AND left_id > $left_id + ORDER BY left_id ASC"; + } + $result = $db->sql_query_limit($sql, 1, 0); -if ( !empty($mode) ) -{ - switch($mode) - { - case 'addforum': - case 'editforum': + if (!$row = $db->sql_fetchrow($result)) + { // - // Show form to create/modify a forum + // already on top or at bottom // - if ($mode == 'editforum') - { - // $newmode determines if we are going to INSERT or UPDATE after posting? - - $l_title = $lang['Edit_forum']; - $newmode = 'modforum'; - $buttonvalue = $lang['Update']; - - $forum_id = intval($HTTP_GET_VARS[POST_FORUM_URL]); - - $row = get_info('forum', $forum_id); - - $cat_id = $row['cat_id']; - $forumname = $row['forum_name']; - $forumdesc = $row['forum_desc']; - $forumstatus = $row['forum_status']; - - // - // start forum prune stuff. - // - if( $row['prune_enable'] ) - { - $prune_enabled = "checked=\"checked\""; - $sql = "SELECT * - FROM " . PRUNE_TABLE . " - WHERE forum_id = $forum_id"; - if(!$pr_result = $db->sql_query($sql)) - { - message_die(GENERAL_ERROR, "Auto-Prune: Couldn't read auto_prune table.", __LINE__, __FILE__); - } - - $pr_row = $db->sql_fetchrow($pr_result); - } - else - { - $prune_enabled = ''; - } - } - else - { - $l_title = $lang['Create_forum']; - $newmode = 'createforum'; - $buttonvalue = $lang['Create_forum']; - - $forumdesc = ''; - $forumstatus = FORUM_UNLOCKED; - $forum_id = ''; - $prune_enabled = ''; - } - - $catlist = get_list('category', $cat_id, TRUE); - - $forumstatus == ( FORUM_LOCKED ) ? $forumlocked = "selected=\"selected\"" : $forumunlocked = "selected=\"selected\""; - $statuslist = "\n"; - $statuslist .= "\n"; - - $template->set_filenames(array( - "body" => "admin/forum_edit_body.tpl") - ); - - $s_hidden_fields = ''; - - $template->assign_vars(array( - 'S_FORUM_ACTION' => append_sid("admin_forums.$phpEx"), - 'S_HIDDEN_FIELDS' => $s_hidden_fields, - 'S_SUBMIT_VALUE' => $buttonvalue, - 'S_CAT_LIST' => $catlist, - 'S_STATUS_LIST' => $statuslist, - 'S_PRUNE_ENABLED' => $prune_enabled, - - 'L_FORUM_TITLE' => $l_title, - 'L_FORUM_EXPLAIN' => $lang['Forum_edit_delete_explain'], - 'L_FORUM_SETTINGS' => $lang['Forum_settings'], - 'L_FORUM_NAME' => $lang['Forum_name'], - 'L_CATEGORY' => $lang['Category'], - 'L_FORUM_DESCRIPTION' => $lang['Forum_desc'], - 'L_FORUM_STATUS' => $lang['Forum_status'], - 'L_AUTO_PRUNE' => $lang['Forum_pruning'], - 'L_ENABLED' => $lang['Enabled'], - 'L_PRUNE_DAYS' => $lang['prune_days'], - 'L_PRUNE_FREQ' => $lang['prune_freq'], - 'L_DAYS' => $lang['Days'], - - 'PRUNE_DAYS' => ( isset($pr_row['prune_days']) ) ? $pr_row['prune_days'] : 7, - 'PRUNE_FREQ' => ( isset($pr_row['prune_freq']) ) ? $pr_row['prune_freq'] : 1, - 'FORUM_NAME' => $forumname, - 'DESCRIPTION' => $forumdesc) - ); - $template->pparse("body"); break; + } - case 'createforum': - // - // Create a forum in the DB - // - if( trim($HTTP_POST_VARS['forumname']) == "" ) - { - message_die(GENERAL_ERROR, "Can't create a forum without a name"); - } - - $sql = "SELECT MAX(forum_order) AS max_order - FROM " . FORUMS_TABLE . " - WHERE cat_id = " . intval($HTTP_POST_VARS[POST_CAT_URL]); - if( !$result = $db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Couldn't get order number from forums table", "", __LINE__, __FILE__, $sql); - } - $row = $db->sql_fetchrow($result); - - $max_order = $row['max_order']; - $next_order = $max_order + 10; - - $sql = "SELECT MAX(forum_id) AS max_id - FROM " . FORUMS_TABLE; - if( !$result = $db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Couldn't get order number from forums table", "", __LINE__, __FILE__, $sql); - } - $row = $db->sql_fetchrow($result); - - $max_id = $row['max_id']; - $next_id = $max_id + 1; - - // - // Default permissions of public :: - // - $field_sql = ""; - $value_sql = ""; - while( list($field, $value) = each($forum_auth_ary) ) - { - $field_sql .= ", $field"; - $value_sql .= ", $value"; - - } + if ($mode == 'move_up') + { + $up_id = $forum_id; + $down_id = $row['forum_id']; + } + else + { + $up_id = $row['forum_id']; + $down_id = $forum_id; + } - // There is no problem having duplicate forum names so we won't check for it. - $sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, cat_id, forum_desc, forum_order, forum_status, prune_enable" . $field_sql . ") - VALUES ('" . $next_id . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", " . intval($HTTP_POST_VARS['prune_enable']) . $value_sql . ")"; - if( !$result = $db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Couldn't insert row in forums table", "", __LINE__, __FILE__, $sql); - } + $forum_info[$row['forum_id']] = $row; + $diff_up = $forum_info[$up_id]['right_id'] - $forum_info[$up_id]['left_id']; + $diff_down = $forum_info[$down_id]['right_id'] - $forum_info[$down_id]['left_id']; - if( $HTTP_POST_VARS['prune_enable'] ) - { + // + // I should consider using transactions here + // + $forum_ids = array(); + $sql = 'SELECT forum_id + FROM ' . FORUMS_TABLE . ' + WHERE left_id > ' . $forum_info[$up_id]['left_id'] . ' AND right_id < ' . $forum_info[$up_id]['right_id']; - if( $HTTP_POST_VARS['prune_days'] == "" || $HTTP_POST_VARS['prune_freq'] == "") - { - message_die(GENERAL_MESSAGE, $lang['Set_prune_data']); - } - - $sql = "INSERT INTO " . PRUNE_TABLE . " (forum_id, prune_days, prune_freq) - VALUES('" . $next_id . "', " . intval($HTTP_POST_VARS['prune_days']) . ", " . intval($HTTP_POST_VARS['prune_freq']) . ")"; - if( !$result = $db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Couldn't insert row in prune table", "", __LINE__, __FILE__, $sql); - } - } + $result = $db->sql_query($sql); + while ($row = $db->sql_fetchrow($result)) + { + $forum_ids[] = $row['forum_id']; + } - $message = $lang['Forums_updated'] . "

" . sprintf($lang['Click_return_forumadmin'], "", "") . "

" . sprintf($lang['Click_return_admin_index'], "", ""); + $sql = 'UPDATE ' . FORUMS_TABLE . ' + SET left_id = left_id + ' . ($diff_up + 1) . ', right_id = right_id + ' . ($diff_up + 1) . ' + WHERE left_id > ' . $forum_info[$down_id]['left_id'] . ' AND right_id < ' . $forum_info[$down_id]['right_id']; + $db->sql_query($sql); - message_die(GENERAL_MESSAGE, $message); + if (count($forum_ids)) + { + $sql = 'UPDATE ' . FORUMS_TABLE . ' + SET left_id = left_id - ' . ($diff_down + 1) . ', right_id = right_id - ' . ($diff_down + 1) . ' + WHERE forum_id IN (' . implode(', ', $forum_ids) . ')'; + $db->sql_query($sql); + } - break; + $sql = 'UPDATE ' . FORUMS_TABLE . ' + SET left_id = ' . $forum_info[$down_id]['left_id'] . ', right_id = ' . ($forum_info[$down_id]['left_id'] + $diff_up) . ' + WHERE forum_id = ' . $up_id; + $db->sql_query($sql); - case 'modforum': - // Modify a forum in the DB - if( isset($HTTP_POST_VARS['prune_enable'])) - { - if( $HTTP_POST_VARS['prune_enable'] != 1 ) - { - $HTTP_POST_VARS['prune_enable'] = 0; - } - } + $sql = 'UPDATE ' . FORUMS_TABLE . ' + SET left_id = ' . ($forum_info[$up_id]['right_id'] - $diff_down) . ', right_id = ' . $forum_info[$up_id]['right_id'] . ' + WHERE forum_id = ' . $down_id; + $db->sql_query($sql); + break; - $sql = "UPDATE " . FORUMS_TABLE . " - SET forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', cat_id = " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . " - WHERE forum_id = " . intval($HTTP_POST_VARS[POST_FORUM_URL]); - if( !$result = $db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Couldn't update forum information", "", __LINE__, __FILE__, $sql); - } - - if( $HTTP_POST_VARS['prune_enable'] == 1 ) - { - if( $HTTP_POST_VARS['prune_days'] == "" || $HTTP_POST_VARS['prune_freq'] == "" ) - { - message_die(GENERAL_MESSAGE, $lang['Set_prune_data']); - } - - $sql = "SELECT * - FROM " . PRUNE_TABLE . " - WHERE forum_id = " . intval($HTTP_POST_VARS[POST_FORUM_URL]); - if( !$result = $db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Couldn't get forum Prune Information","",__LINE__, __FILE__, $sql); - } - - if( $db->sql_numrows($result) > 0 ) - { - $sql = "UPDATE " . PRUNE_TABLE . " - SET prune_days = " . intval($HTTP_POST_VARS['prune_days']) . ", prune_freq = " . intval($HTTP_POST_VARS['prune_freq']) . " - WHERE forum_id = " . intval($HTTP_POST_VARS[POST_FORUM_URL]); - } - else - { - $sql = "INSERT INTO " . PRUNE_TABLE . " (forum_id, prune_days, prune_freq) - VALUES(" . intval($HTTP_POST_VARS[POST_FORUM_URL]) . ", " . intval($HTTP_POST_VARS['prune_days']) . ", " . intval($HTTP_POST_VARS['prune_freq']) . ")"; - } - - if( !$result = $db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Couldn't Update Forum Prune Information","",__LINE__, __FILE__, $sql); - } - } + case 'create': + if (!trim($HTTP_POST_VARS['forum_name'])) + { + message_die(ERROR, 'Cannot create a forum without a name'); + } - $message = $lang['Forums_updated'] . "

" . sprintf($lang['Click_return_forumadmin'], "", "") . "

" . sprintf($lang['Click_return_admin_index'], "", ""); + $parent_id = (!empty($HTTP_POST_VARS['parent_id'])) ? $HTTP_POST_VARS['parent_id'] : 0; + $forum_status = (!empty($HTTP_POST_VARS['is_category'])) ? ITEM_CATEGORY : $HTTP_POST_VARS['forum_status']; + $forum_name = str_replace("\'", "''", $HTTP_POST_VARS['forum_name']); + $forum_desc = str_replace("\'", "''", $HTTP_POST_VARS['forum_desc']); - message_die(GENERAL_MESSAGE, $message); + $forum_style = (!empty($HTTP_POST_VARS['forum_style'])) ? intval($HTTP_POST_VARS['forum_style']) : 'NULL'; + $post_count_inc = (!empty($HTTP_POST_VARS['disable_post_count'])) ? 0 : 1; - break; - - case 'addcat': - // Create a category in the DB - if( trim($HTTP_POST_VARS['categoryname']) == '') - { - message_die(GENERAL_ERROR, "Can't create a category without a name"); - } - - $sql = "SELECT MAX(cat_order) AS max_order - FROM " . CATEGORIES_TABLE; - if( !$result = $db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Couldn't get order number from categories table", "", __LINE__, __FILE__, $sql); - } - $row = $db->sql_fetchrow($result); + $prune_enable = (!empty($HTTP_POST_VARS['prune_enable'])) ? 1 : 0; + $prune_days = intval($HTTP_POST_VARS['prune_days']); + $prune_freq = intval($HTTP_POST_VARS['prune_freq']); - $max_order = $row['max_order']; - $next_order = $max_order + 10; + $result = $db->sql_query('SELECT MAX(forum_id) AS max_id FROM ' . FORUMS_TABLE); + $forum_id = $db->sql_fetchfield('max_id', 0, $result) + 1; - // - // There is no problem having duplicate forum names so we won't check for it. - // - $sql = "INSERT INTO " . CATEGORIES_TABLE . " (cat_title, cat_order) - VALUES ('" . $HTTP_POST_VARS['categoryname'] . "', $next_order)"; - if( !$result = $db->sql_query($sql) ) + if ($parent_id) + { + $result = $db->sql_query('SELECT left_id, right_id FROM ' . FORUMS_TABLE . " WHERE forum_id = $parent_id"); + if (!$row = $db->sql_fetchrow($result)) { - message_die(GENERAL_ERROR, "Couldn't insert row in categories table", "", __LINE__, __FILE__, $sql); + message_die(ERROR, 'Parent does not exist'); } + extract($row); - $message = $lang['Forums_updated'] . "

" . sprintf($lang['Click_return_forumadmin'], "", "") . "

" . sprintf($lang['Click_return_admin_index'], "", ""); - - message_die(GENERAL_MESSAGE, $message); - - break; - - case 'editcat': - // - // Show form to edit a category - // - $newmode = 'modcat'; - $buttonvalue = $lang['Update']; + $db->sql_query('UPDATE ' . FORUMS_TABLE . " SET left_id = left_id + 2, right_id = right_id + 2 WHERE left_id > $right_id"); + $db->sql_query('UPDATE ' . FORUMS_TABLE . " SET right_id = right_id + 2 WHERE $left_id BETWEEN left_id AND right_id"); - $cat_id = intval($HTTP_GET_VARS[POST_CAT_URL]); + $left_id = $right_id; + ++$right_id; + } + else + { + $result = $db->sql_query('SELECT MAX(right_id) AS right_id FROM ' . FORUMS_TABLE); + $left_id = $db->sql_fetchfield('right_id', 0, $result) + 1; + $right_id = $left_id + 1; + } - $row = get_info('category', $cat_id); - $cat_title = $row['cat_title']; + $sql = 'INSERT INTO ' . FORUMS_TABLE . " (forum_id, forum_name, forum_desc, parent_id, left_id, right_id, forum_status, forum_style, post_count_inc, prune_enable, prune_days, prune_freq) + VALUES ($forum_id, '$forum_name', '$forum_desc', $parent_id, $left_id, $right_id, $forum_status, $forum_style, $post_count_inc, $prune_enable, $prune_days, $prune_freq)"; + $db->sql_query($sql); - $template->set_filenames(array( - "body" => "admin/category_edit_body.tpl") - ); + $message = $lang['Forums_updated'] . "

" . sprintf($lang['Click_return_forumadmin'], '', '') . '

' . sprintf($lang['Click_return_admin_index'], '', ''); + message_die(MESSAGE, $message); - $s_hidden_fields = ''; + break; - $template->assign_vars(array( - 'CAT_TITLE' => $cat_title, + case 'modify': + if (!$forum_id = intval($HTTP_POST_VARS['forum_id'])) + { + message_die(ERROR, 'No forum specified'); + } - 'L_EDIT_CATEGORY' => $lang['Edit_Category'], - 'L_EDIT_CATEGORY_EXPLAIN' => $lang['Edit_Category_explain'], - 'L_CATEGORY' => $lang['Category'], + $row = get_forum_info($forum_id); + $parent_id = intval($HTTP_POST_VARS['parent_id']); + $action = (!empty($HTTP_POST_VARS['action'])) ? $HTTP_POST_VARS['action'] : ''; - 'S_HIDDEN_FIELDS' => $s_hidden_fields, - 'S_SUBMIT_VALUE' => $buttonvalue, - 'S_FORUM_ACTION' => append_sid("admin_forums.$phpEx")) - ); + if (($row['parent_id'] != $parent_id) && ($parent_id != -1)) + { + move_forum($forum_id, $parent_id); + } - $template->pparse("body"); - break; + $sql = array( + 'forum_name' => (!empty($HTTP_POST_VARS['forum_name'])) ? stripslashes($HTTP_POST_VARS['forum_name']) : $row['forum_name'], + 'forum_desc' => (!empty($HTTP_POST_VARS['forum_desc'])) ? stripslashes($HTTP_POST_VARS['forum_desc']) : $row['forum_desc'], + 'forum_status' => (!empty($HTTP_POST_VARS['set_category']) && $action) ? ITEM_CATEGORY : intval($HTTP_POST_VARS['forum_status']), + 'forum_style' => (!empty($HTTP_POST_VARS['forum_style'])) ? $HTTP_POST_VARS['forum_style'] : NULL, + 'parent_id' => $parent_id, + 'prune_enable' => (!empty($HTTP_POST_VARS['prune_enable'])) ? 1 : 0, + 'prune_days' => intval($HTTP_POST_VARS['prune_days']), + 'prune_freq' => intval($HTTP_POST_VARS['prune_freq']), + 'post_count_inc' => (!empty($HTTP_POST_VARS['disable_post_count'])) ? 0 : 1 + ); - case 'modcat': - // Modify a category in the DB - $sql = "UPDATE " . CATEGORIES_TABLE . " - SET cat_title = '" . str_replace("\'", "''", $HTTP_POST_VARS['cat_title']) . "' - WHERE cat_id = " . intval($HTTP_POST_VARS[POST_CAT_URL]); - if( !$result = $db->sql_query($sql) ) + if (!empty($HTTP_POST_VARS['set_category']) && $action) + { + if ($action == 'move' && $HTTP_POST_VARS['to_forum_id']) { - message_die(GENERAL_ERROR, "Couldn't update forum information", "", __LINE__, __FILE__, $sql); + move_forum_content($forum_id, $HTTP_POST_VARS['to_forum_id']); + } + elseif ($action == 'delete') + { + delete_forum_content($forum_id); } - $message = $lang['Forums_updated'] . "

" . sprintf($lang['Click_return_forumadmin'], "", "") . "

" . sprintf($lang['Click_return_admin_index'], "", ""); - - message_die(GENERAL_MESSAGE, $message); - - break; - - case 'deleteforum': - // Show form to delete a forum - $forum_id = intval($HTTP_GET_VARS[POST_FORUM_URL]); + $sql['forum_posts'] = 0; + $sql['forum_topics'] = 0; + } - $select_to = ''; + $db->sql_query_array('UPDATE ' . FORUMS_TABLE . " SET WHERE forum_id = $forum_id", $sql); - $buttonvalue = $lang['Move_and_Delete']; + $message = $lang['Forums_updated'] . "

" . sprintf($lang['Click_return_forumadmin'], '', '') . '

' . sprintf($lang['Click_return_admin_index'], '', ''); + message_die(MESSAGE, $message); - $newmode = 'movedelforum'; + break; - $foruminfo = get_info('forum', $forum_id); - $name = $foruminfo['forum_name']; + case 'remove': + break; - $template->set_filenames(array( - "body" => "admin/forum_delete_body.tpl") - ); + case 'forum_sync': + sync('forum', intval($HTTP_GET_VARS[POST_FORUM_URL])); + $show_index = TRUE; + break; - $s_hidden_fields = ''; + case 'add': + case 'edit': + // + // Show form to create/modify a forum + // + if ($mode == 'edit') + { + $forum_id = intval($HTTP_GET_VARS['f']); - $template->assign_vars(array( - 'NAME' => $name, + $row = get_forum_info($forum_id); + extract($row); - 'L_FORUM_DELETE' => $lang['Forum_delete'], - 'L_FORUM_DELETE_EXPLAIN' => $lang['Forum_delete_explain'], - 'L_MOVE_CONTENTS' => $lang['Move_contents'], - 'L_FORUM_NAME' => $lang['Forum_name'], + $subforums_id = array(); + $subforums = get_forum_branch($forum_id, 'children'); + foreach ($subforums as $row) + { + $subforums_id[] = $row['forum_id']; + } - "S_HIDDEN_FIELDS" => $s_hidden_fields, - 'S_FORUM_ACTION' => append_sid("admin_forums.$phpEx"), - 'S_SELECT_TO' => $select_to, - 'S_SUBMIT_VALUE' => $buttonvalue) - ); + $parents_list = make_forums_list('all', $parent_id, $subforums_id); - $template->pparse("body"); - break; - - case 'movedelforum': // - // Move or delete a forum in the DB + // TODO: Make 'Edit_forum' and 'Edit_Category' use the same case // - $from_id = intval($HTTP_POST_VARS['from_id']); - $to_id = intval($HTTP_POST_VARS['to_id']); - $delete_old = intval($HTTP_POST_VARS['delete_old']); - - // Either delete or move all posts in a forum - if($to_id == -1) - { - include($phpbb_root_path . "includes/prune.$phpEx"); - prune($from_id, 0); // Delete everything from forum - } - else - { - $sql = "SELECT * - FROM " . FORUMS_TABLE . " - WHERE forum_id IN ($from_id, $to_id)"; - if( !$result = $db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Couldn't verify existence of forums", "", __LINE__, __FILE__, $sql); - } - if($db->sql_numrows($result) != 2) - { - message_die(GENERAL_ERROR, "Ambiguous forum ID's", "", __LINE__, __FILE__); - } - $sql = "UPDATE " . TOPICS_TABLE . " - SET forum_id = $to_id - WHERE forum_id = $from_id"; - if( !$result = $db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Couldn't move topics to other forum", "", __LINE__, __FILE__, $sql); - } - $sql = "UPDATE " . POSTS_TABLE . " - SET forum_id = $to_id - WHERE forum_id = $from_id"; - if( !$result = $db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Couldn't move posts to other forum", "", __LINE__, __FILE__, $sql); - } - sync('forum', $to_id); - } + $l_title = ($forum_status != ITEM_CATEGORY) ? $lang['Edit_forum'] : $lang['Edit_Category']; + $newmode = 'modify'; + $buttonvalue = $lang['Update']; + $prune_enabled = ($prune_enable) ? 'checked="checked" ' : ''; - $sql = "DELETE FROM " . FORUMS_TABLE . " - WHERE forum_id = $from_id"; - if( !$result = $db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Couldn't delete forum", "", __LINE__, __FILE__, $sql); - } - - $sql = "DELETE FROM " . AUTH_ACCESS_TABLE . " - WHERE forum_id = $from_id"; - if( !$result = $db->sql_query($sql) ) + if ($forum_status != ITEM_CATEGORY) { - message_die(GENERAL_ERROR, "Couldn't delete forum", "", __LINE__, __FILE__, $sql); + $forums_list = make_forums_list('forums', 0, $forum_id); } - - $sql = "DELETE FROM " . PRUNE_TABLE . " - WHERE forum_id = $from_id"; - if( !$result = $db->sql_query($sql) ) + } + else + { + $parent_id = 0; + if (!empty($HTTP_POST_VARS['parent_id'])) { - message_die(GENERAL_ERROR, "Couldn't delete forum prune information!", "", __LINE__, __FILE__, $sql); + list($parent_id) = each($HTTP_POST_VARS['parent_id']); } + $parents_list = make_forums_list('all', $parent_id); - $message = $lang['Forums_updated'] . "

" . sprintf($lang['Click_return_forumadmin'], "", "") . "

" . sprintf($lang['Click_return_admin_index'], "", ""); + $l_title = $lang['Create_forum']; + $newmode = 'create'; + $buttonvalue = $lang['Create_forum']; - message_die(GENERAL_MESSAGE, $message); + $forum_desc = ''; + $forum_style = ''; + $forum_status = ITEM_UNLOCKED; + $forum_name = (!empty($HTTP_POST_VARS['forum_name'][$parent_id])) ? htmlspecialchars($HTTP_POST_VARS['forum_name'][$parent_id]) : ''; - break; - - case 'deletecat': - // - // Show form to delete a category - // - $cat_id = intval($HTTP_GET_VARS[POST_CAT_URL]); - - $buttonvalue = $lang['Move_and_Delete']; - $newmode = 'movedelcat'; - $catinfo = get_info('category', $cat_id); - $name = $catinfo['cat_title']; - - if ($catinfo['number'] == 1) - { - $sql = "SELECT count(*) as total - FROM ". FORUMS_TABLE; - if( !$result = $db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Couldn't get Forum count", "", __LINE__, __FILE__, $sql); - } - $count = $db->sql_fetchrow($result); - $count = $count['total']; - - if ($count > 0) - { - message_die(GENERAL_ERROR, $lang['Must_delete_forums']); - } - else - { - $select_to = $lang['Nowhere_to_move']; - } - } - else - { - $select_to = ''; - } + $post_count_inc = TRUE; - $template->set_filenames(array( - "body" => "admin/forum_delete_body.tpl") - ); + $prune_enabled = ''; + $prune_days = 7; + $prune_freq = 1; + } - $s_hidden_fields = ''; + $styles_list = make_styles_list($forum_style); - $template->assign_vars(array( - 'NAME' => $name, + $forumlocked = ($forum_status == ITEM_LOCKED) ? ' selected="selected"' : ''; + $forumunlocked = ($forum_status == ITEM_UNLOCKED || $forum_status == ITEM_CATEGORY) ? ' selected="selected"' : ''; - 'L_FORUM_DELETE' => $lang['Forum_delete'], - 'L_FORUM_DELETE_EXPLAIN' => $lang['Forum_delete_explain'], - 'L_MOVE_CONTENTS' => $lang['Move_contents'], - 'L_FORUM_NAME' => $lang['Forum_name'], - - 'S_HIDDEN_FIELDS' => $s_hidden_fields, - 'S_FORUM_ACTION' => append_sid("admin_forums.$phpEx"), - 'S_SELECT_TO' => $select_to, - 'S_SUBMIT_VALUE' => $buttonvalue) - ); + $forum_checked = ($forum_status != ITEM_CATEGORY) ? 'checked="checked" ' : ''; + $category_checked = ($forum_status == ITEM_CATEGORY) ? 'checked="checked" ' : ''; - $template->pparse("body"); - break; + $statuslist = '\n"; + $statuslist .= '\n"; - case 'movedelcat': - // - // Move or delete a category in the DB - // - $from_id = intval($HTTP_POST_VARS['from_id']); - $to_id = intval($HTTP_POST_VARS['to_id']); + page_header($l_title); - if (!empty($to_id)) - { - $sql = "SELECT * - FROM " . CATEGORIES_TABLE . " - WHERE cat_id IN ($from_id, $to_id)"; - if( !$result = $db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Couldn't verify existence of categories", "", __LINE__, __FILE__, $sql); - } - if($db->sql_numrows($result) != 2) - { - message_die(GENERAL_ERROR, "Ambiguous category ID's", "", __LINE__, __FILE__); - } - - $sql = "UPDATE " . FORUMS_TABLE . " - SET cat_id = $to_id - WHERE cat_id = $from_id"; - if( !$result = $db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Couldn't move forums to other category", "", __LINE__, __FILE__, $sql); - } - } +?> +

+ +

+ +
" method="post"> + + + + + + + + + + + + +sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Couldn't delete category", "", __LINE__, __FILE__, $sql); - } + if ($mode == 'add' || $forum_status == ITEM_CATEGORY) + { +?> + + + + +
" . sprintf($lang['Click_return_forumadmin'], "", "") . "

" . sprintf($lang['Click_return_admin_index'], "", ""); + } +?> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
/>   />
/>
Change this forum into a category and
+      
+      Move all posts to +
+ + + + + + + + + + + + +
/>
  
  
+
+ +
+sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Couldn't change category order", "", __LINE__, __FILE__, $sql); - } + $forums_list = make_forums_list('all', $parent_id, $subforums_id); + $move_posts_list = make_forums_list('forums', $parent_id, $subforums_id); - renumber_order('forum', $forum_info['cat_id']); - $show_index = TRUE; +?> +

+ +

+ +
+ + + + + + + + + + + + + + + + + + 1) + { +?> + + + + + + + + + + + + +
+
+sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Couldn't change category order", "", __LINE__, __FILE__, $sql); - } + default: + $show_index = TRUE; +} - renumber_order('category'); - $show_index = TRUE; +if (empty($show_index)) +{ + page_footer(); +} - break; +page_header($lang['Manage']); - case 'forum_sync': - sync('forum', intval($HTTP_GET_VARS[POST_FORUM_URL])); - $show_index = TRUE; +$parent_id = (!empty($HTTP_GET_VARS['parent_id'])) ? $HTTP_GET_VARS['parent_id'] : 0; - break; +if (!$parent_id) +{ + $navigation = 'Forum Index'; +} +else +{ + $navigation = 'Forum Index'; - default: - message_die(GENERAL_MESSAGE, $lang['No_mode']); - break; - } + $sql = 'SELECT f2.forum_id, f2.forum_name + FROM ' . FORUMS_TABLE . ' f1 + LEFT JOIN ' . FORUMS_TABLE . " f2 ON f1.left_id BETWEEN f2.left_id AND f2.right_id + WHERE f1.forum_id = $parent_id + ORDER BY f2.left_id"; - if ($show_index != TRUE) + $result = $db->sql_query($sql); + while ($row = $db->sql_fetchrow($result)) { - include('page_footer_admin.'.$phpEx); - exit; + if ($row['forum_id'] == $parent_id) + { + $navigation .= ' -> ' . htmlspecialchars($row['forum_name']); + } + else + { + $navigation .= ' -> ' . htmlspecialchars($row['forum_name']) . ''; + } } } - -page_header($lang['Manage']); - - ?> -

Manage

Here you can add, edit, delete, lock, unlock individual forums as well as set certain additional controls. If your posts and topics have got out of sync you can also resynchronise a forum. In phpBB 2.2 there are no categories, everything is forum based. Each forum can have an unlimited number of sub-forums and you can determine whether each may be posted to or not (i.e. whether it acts like an old category).

-
+
+">
- - - - + - - - - - - - - - - - - - - -
Forum Name   
   
  
- set_filenames(array( - "body" => "admin/forum_admin_body.tpl") -); - -$template->assign_vars(array( - 'S_FORUM_ACTION' => "admin_forums.$phpEx$SID", - 'L_FORUM_TITLE' => $lang['Forum_admin'], - 'L_FORUM_EXPLAIN' => $lang['Forum_admin_explain'], - 'L_CREATE_FORUM' => $lang['Create_forum'], - 'L_CREATE_CATEGORY' => $lang['Create_category'], - 'L_EDIT' => $lang['Edit'], - 'L_DELETE' => $lang['Delete'], - 'L_MOVE_UP' => $lang['Move_up'], - 'L_MOVE_DOWN' => $lang['Move_down'], - 'L_RESYNC' => $lang['Resync']) -); - -$sql = "SELECT cat_id, cat_title, cat_order - FROM " . CATEGORIES_TABLE . " - ORDER BY cat_order"; -$q_categories = $db->sql_query($sql); - -if ( $category_rows = $db->sql_fetchrowset($q_categories) ) +$result = $db->sql_query('SELECT * FROM ' . FORUMS_TABLE . " WHERE parent_id = $parent_id ORDER BY left_id"); +while ($row = $db->sql_fetchrow($result)) { - - $sql = "SELECT * - FROM " . FORUMS_TABLE . " - ORDER BY cat_id, forum_order"; - $q_forums = $db->sql_query($sql); - - if( $total_forums = $db->sql_numrows($q_forums) ) - { - $forum_rows = $db->sql_fetchrowset($q_forums); - } - // - // Okay, let's build the index + // DEBUG // - $gen_cat = array(); + $forum_title = htmlspecialchars($row['forum_name']); + $forum_desc = htmlspecialchars($row['forum_desc']); + $url = $phpEx . $SID . '&f=' . $row['forum_id']; + $subforums = ($row['right_id'] - $row['left_id'] - 1) / 2; - for($i = 0; $i < $total_categories; $i++) + if ($row['forum_status'] != ITEM_CATEGORY) + { + $colspan = ' colspan="2"'; + $forum_stats = ' + ' . $row['forum_topics'] . ' + ' . $row['forum_posts'] . ' + ' . $subforums . ' + '; + } + else { - $cat_id = $category_rows[$i]['cat_id']; + $colspan = ' colspan="4"'; + $forum_stats = ' + ' . $subforums . ' + '; + } - $template->assign_block_vars("catrow", array( - 'S_ADD_FORUM_SUBMIT' => "addforum[$cat_id]", - 'S_ADD_FORUM_NAME' => "forumname[$cat_id]", + if ($row['left_id'] + 1 != $row['right_id']) + { + $forum_title = '' . $forum_title . ''; + } - 'CAT_ID' => $cat_id, - 'CAT_DESC' => $category_rows[$i]['cat_title'], + if ($row['forum_status'] == ITEM_CATEGORY) + { +?> + + + + + +   + - 'U_CAT_EDIT' => "admin_forums.$phpEx$SID&mode=editcat&c=$cat_id", - 'U_CAT_DELETE' => "admin_forums.$phpEx$SID&mode=deletecat&c=$cat_id", - 'U_CAT_MOVE_UP' => "admin_forums.$phpEx$SID&mode=cat_order&move=-15&c=$cat_id", - 'U_CAT_MOVE_DOWN' => "admin_forums.$phpEx$SID&mode=cat_order&move=15&c=$cat_id", - 'U_VIEWCAT' => $phpbb_root_path."index.$phpEx$SID&c=$cat_id") - ); +sql_query('SELECT * FROM ' . FORUMS_TABLE . ' WHERE parent_id = ' . $row['forum_id'] . ' ORDER BY left_id'); + while ($sub_row = $db->sql_fetchrow($sub_result)) { - $forum_id = $forum_rows[$j]['forum_id']; + $url = $phpEx . $SID . '&f=' . $sub_row['forum_id']; + $forum_title = htmlspecialchars($sub_row['forum_name']); + $forum_desc = htmlspecialchars($sub_row['forum_desc']); + $subforums = ($sub_row['right_id'] - $sub_row['left_id'] - 1) / 2; - if ( $forum_rows[$j]['cat_id'] == $cat_id ) + if ($sub_row['forum_status'] != ITEM_CATEGORY) { + $colspan = ''; + $forum_stats = ' + ' . $sub_row['forum_topics'] . ' + ' . $sub_row['forum_posts'] . ' + ' . $subforums . ' + '; + } + else + { + $colspan = ' colspan="3"'; + $forum_stats = ' + ' . $subforums . ' + '; + } - $template->assign_block_vars("catrow.forumrow", array( - 'FORUM_NAME' => $forum_rows[$j]['forum_name'], - 'FORUM_DESC' => $forum_rows[$j]['forum_desc'], - 'ROW_COLOR' => $row_color, - 'NUM_TOPICS' => $forum_rows[$j]['forum_topics'], - 'NUM_POSTS' => $forum_rows[$j]['forum_posts'], - - 'U_VIEWFORUM' => $phpbb_root_path."viewforum.$phpEx$SID&f=$forum_id", - 'U_FORUM_EDIT' => "admin_forums.$$SID&mode=editforum&f=$forum_id", - 'U_FORUM_DELETE' => "admin_forums.$phpEx$SID&mode=deleteforum&f=$forum_id", - 'U_FORUM_MOVE_UP' => "admin_forums.$phpEx$SID&mode=forum_order&move=-15&f=$forum_id", - 'U_FORUM_MOVE_DOWN' => "admin_forums.$phpEx$SID&mode=forum_order&move=15&f=$forum_id", - 'U_FORUM_RESYNC' => "admin_forums.$phpEx$SID&mode=forum_sync&f=$forum_id") - ); - - }// if ... forumid == catid - - } // for ... forums + if ($sub_row['left_id'] + 1 != $sub_row['right_id']) + { + $forum_title = '' . $forum_title . ''; + } +?> + + + >
+ + + +
+ + + + + + + + + + >
+ + + +
+ + + + + + + + +sql_query($sql) ) + $sql = 'SELECT f2.* + FROM ' . FORUMS_TABLE . ' f1 + LEFT JOIN ' . FORUMS_TABLE . " f2 ON $condition + WHERE f1.forum_id = $forum_id + ORDER BY f2.left_id " . (($order == 'descending') ? 'ASC' : 'DESC'); + + $rows = array(); + $result = $db->sql_query($sql); + while ($row = $db->sql_fetchrow($result)) { - message_die(GENERAL_ERROR, "Couldn't get Forum/Category information", "", __LINE__, __FILE__, $sql); + if (!$include_forum && $row['forum_id'] == $forum_id) + { + continue; + } + $rows[] = $row; } - $count = $db->sql_fetchrow($result); - $count = $count['total']; + return $rows; +} - $sql = "SELECT * - FROM $table - WHERE $idfield = $id"; +function get_forum_info($forum_id) +{ + global $db; + $sql = 'SELECT f.*, s.* + FROM ' . FORUMS_TABLE . ' f + LEFT JOIN ' . STYLES_TABLE . " s ON f.forum_style = s.style_id + WHERE f.forum_id = $forum_id"; + $result = $db->sql_query($sql); + if (!$row = $db->sql_fetchrow($result)) + { + message_die(ERROR, "Forum #$forum_id does not exist"); + } - if( !$result = $db->sql_query($sql) ) + return $row; +} + +function make_forums_list($mode='all', $selected_id=0, $exclude_id=array()) +{ + global $db; + if (!is_array($exclude_id)) { - message_die(GENERAL_ERROR, "Couldn't get Forum/Category information", "", __LINE__, __FILE__, $sql); + $exclude_id = array($exclude_id); } - if( $db->sql_numrows($result) != 1 ) + $sql = 'SELECT f2.* + FROM ' . FORUMS_TABLE . ' f1, ' . FORUMS_TABLE . ' f2 + WHERE f1.parent_id = 0 + AND f2.left_id BETWEEN f1.left_id AND f1.right_id + ORDER BY f2.left_id'; + $result = $db->sql_query($sql); + + $list = ''; + $indent = array(); + $current_indent = 0; + + while ($row = $db->sql_fetchrow($result)) { - message_die(GENERAL_ERROR, "Forum/Category doesn't exist or multiple forums/categories with ID $id", "", __LINE__, __FILE__); + if ($row['parent_id'] == 0) + { + $current_indent = 0; + } + elseif (!isset($indent[$row['parent_id']])) + { + ++$current_indent; + $indent[$row['parent_id']] = $current_indent; + } + else + { + $current_indent = $indent[$row['parent_id']]; + } + + if (($mode == 'forums' && $row['forum_status'] == ITEM_CATEGORY) + || ($mode == 'categories' && $row['forum_status'] != ITEM_CATEGORY) + || (in_array($row['forum_id'], $exclude_id))) + { + continue; + } + + if ($mode == 'all' && !$row['parent_id']) + { + $list .= "\n"; + } + + $list .= '\n"; } - $return = $db->sql_fetchrow($result); - $return['number'] = $count; - return $return; + return $list; } -function get_list($mode, $id, $select) +function make_styles_list($selected_id=0) { global $db; - switch($mode) + $list = ''; + $result = $db->sql_query('SELECT style_id, style_name FROM ' . STYLES_TABLE . ' ORDER BY style_name'); + + while ($row = $db->sql_fetchrow($result)) { - case 'category': - $table = CATEGORIES_TABLE; - $idfield = 'cat_id'; - $namefield = 'cat_title'; - break; + $list .= '\n"; + } + return $list; +} - case 'forum': - $table = FORUMS_TABLE; - $idfield = 'forum_id'; - $namefield = 'forum_name'; - break; +function move_forum($from_id, $to_id) +{ + global $db; - default: - message_die(GENERAL_ERROR, "Wrong mode for generating select list", "", __LINE__, __FILE__); - break; - } + $moved_forums = get_forum_branch($from_id, 'children', 'descending'); + $from_data = $moved_forums[0]; + $diff = count($moved_forums) * 2; - $sql = "SELECT * - FROM $table"; - if( $select == 0 ) + $moved_ids = array(); + for ($i = 0; $i < count($moved_forums); ++$i) { - $sql .= " WHERE $idfield <> $id"; + $moved_ids[] = $moved_forums[$i]['forum_id']; } - if( !$result = $db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Couldn't get list of Categories/Forums", "", __LINE__, __FILE__, $sql); - } + // + // Resync parents + // + $sql = 'UPDATE ' . FORUMS_TABLE . " + SET right_id = right_id - $diff + WHERE left_id < " . $from_data['right_id'] . " AND right_id > " . $from_data['right_id']; + $db->sql_query($sql); - $cat_list = ""; + // + // Resync righthand side of tree + // + $sql = 'UPDATE ' . FORUMS_TABLE . " + SET left_id = left_id - $diff, right_id = right_id - $diff + WHERE left_id > " . $from_data['right_id']; + $db->sql_query($sql); - while( $row = $db->sql_fetchrow($result) ) + if ($to_id > 0) { - $s = ""; - if ($row[$idfield] == $id) + $to_data = get_forum_info($to_id); + + // + // Resync new parents + // + $sql = 'UPDATE ' . FORUMS_TABLE . " + SET right_id = right_id + $diff + WHERE " . $to_data['right_id'] . ' BETWEEN left_id AND right_id + AND forum_id NOT IN (' . implode(', ', $moved_ids) . ')'; + $db->sql_query($sql); + + // + // Resync the righthand side of the tree + // + $sql = 'UPDATE ' . FORUMS_TABLE . " + SET left_id = left_id + $diff, right_id = right_id + $diff + WHERE left_id > " . $to_data['right_id'] . ' + AND forum_id NOT IN (' . implode(', ', $moved_ids) . ')'; + $db->sql_query($sql); + + // + // Resync moved branch + // + $to_data['right_id'] += $diff; + if ($to_data['right_id'] > $from_data['right_id']) { - $s = " selected=\"selected\""; + $diff = '+ ' . ($to_data['right_id'] - $from_data['right_id'] - 1); + } + else + { + $diff = '- ' . abs($to_data['right_id'] - $from_data['right_id'] - 1); } - $catlist .= "\n"; } + else + { + $result = $db->sql_query('SELECT MAX(right_id) AS right_id FROM ' . FORUMS_TABLE . ' WHERE forum_id NOT IN (' . implode(', ', $moved_ids) . ')'); + $right_id = $db->sql_fetchfield('right_id', 0, $result); - return($catlist); + $diff = '+ ' . ($right_id - $from_data['left_id'] + 1); + } + + $sql = 'UPDATE ' . FORUMS_TABLE . " + SET left_id = left_id $diff, right_id = right_id $diff + WHERE forum_id IN (" . implode(', ', $moved_ids) . ')'; + $db->sql_query($sql); } -function renumber_order($mode, $cat = 0) +function move_forum_content($from_id, $to_id) { global $db; - switch($mode) + $db->sql_query('UPDATE ' . ACL_GROUPS_TABLE . " SET forum_id = $to_id WHERE forum_id = $from_id"); + $db->sql_query('UPDATE ' . ACL_PREFETCH_TABLE . " SET forum_id = $to_id WHERE forum_id = $from_id"); + $db->sql_query('UPDATE ' . LOG_MOD_TABLE . " SET forum_id = $to_id WHERE forum_id = $from_id"); + $db->sql_query('UPDATE ' . POSTS_TABLE . " SET forum_id = $to_id WHERE forum_id = $from_id"); + $db->sql_query('UPDATE ' . TOPICS_TABLE . " SET forum_id = $to_id WHERE forum_id = $from_id"); + + // + // TODO: untested yet + // + $sql = 'SELECT t1.topic_id + FROM ' .TOPICS_TABLE . ' t1 + LEFT JOIN ' . TOPICS_TABLE . " t2 ON t1.topic_moved_id = t2.topic_id AND t1.forum_id = t2.forum_id + WHERE t1.forum_id = $to_id"; + $result = $db->sql_query($result); + + $topic_ids = array(); + while ($row = $db->sql_fetchrow($result)) { - case 'category': - $table = CATEGORIES_TABLE; - $idfield = 'cat_id'; - $orderfield = 'cat_order'; - $cat = 0; - break; + $topic_ids[] = $row['topic_id']; + } + if (count($topic_ids)) + { + $db->sql_query('DELETE FROM ' . TOPICS_TABLE . ' WHERE topic_id IN (' . implode(', ', $topic_ids) . ')'); + } + sync('forum', $to_id); - case 'forum': - $table = FORUMS_TABLE; - $idfield = 'forum_id'; - $orderfield = 'forum_order'; - $catfield = 'cat_id'; - break; + // + // TODO: there might be conflicts in ACL tables =\ + // make sure that the query that retrieves shadow topics uses the correct index (topic_type or topic_moved_id) + // +} - default: - message_die(GENERAL_ERROR, "Wrong mode for generating select list", "", __LINE__, __FILE__); - break; - } +function delete_forum_content($forum_id) +{ + global $db; + + $db->sql_query('DELETE FROM ' . ACL_GROUPS_TABLE . " WHERE forum_id = $forum_id"); + $db->sql_query('DELETE FROM ' . ACL_PREFETCH_TABLE . " WHERE forum_id = $forum_id"); + $db->sql_query('DELETE FROM ' . LOG_MOD_TABLE . " WHERE forum_id = $forum_id"); - $sql = "SELECT * FROM $table"; - if( $cat != 0) + $ids = array(); + $result = $db->sql_query('SELECT post_id FROM ' . POSTS_TABLE . " WHERE forum_id = $forum_id"); + while ($row = $db->sql_fetchrow($result)) { - $sql .= " WHERE $catfield = $cat"; + $ids[] = $row['post_id']; } - $sql .= " ORDER BY $orderfield ASC"; + $ids = implode(',', $ids); + $db->sql_freeresult(); - - if( !$result = $db->sql_query($sql) ) + if ($ids) { - message_die(GENERAL_ERROR, "Couldn't get list of Categories", "", __LINE__, __FILE__, $sql); + $db->sql_query('DELETE FROM ' . SEARCH_MATCH_TABLE . " WHERE post_id IN ($ids)"); + $db->sql_query('DELETE FROM ' . POSTS_TABLE . " WHERE forum_id = $forum_id"); + $db->sql_query('DELETE FROM ' . POSTS_TEXT_TABLE . " WHERE post_id IN ($ids)"); } - $i = 10; - $inc = 10; + $ids = array(); + $result = $db->sql_query('SELECT topic_id FROM ' . TOPICS_TABLE . " WHERE forum_id = $forum_id"); + while ($row = $db->sql_fetchrow($result)) + { + $ids[] = $row['topic_id']; + } + $ids = implode(',', $ids); + $db->sql_freeresult(); - while( $row = $db->sql_fetchrow($result) ) + if ($ids) { - $sql = "UPDATE $table - SET $orderfield = $i - WHERE $idfield = " . $row[$idfield]; - if( !$db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Couldn't update order fields", "", __LINE__, __FILE__, $sql); - } - $i += 10; + $db->sql_query('DELETE FROM ' . TOPICS_RATING_TABLE . " WHERE topic_id IN ($ids)"); + $db->sql_query('DELETE FROM ' . TOPICS_WATCH_TABLE . " WHERE topic_id IN ($ids)"); + $db->sql_query('DELETE FROM ' . TOPICS_TABLE . " WHERE forum_id = $forum_id"); + $db->sql_query('DELETE FROM ' . TOPICS_TABLE . " WHERE topic_moved_id IN ($ids)"); } + // + // TODO: delete attachments + // delete polls + // OPTIMIZE / VACUUM table ? + // } + // // End function block // ------------------ -- cgit v1.2.1