-/***************************************************************************

- * admin_forums.php

- * -------------------

- * begin : Thursday, Jul 12, 2001

- * copyright : (C) 2001 The phpBB Group

- * email : support@phpbb.com

- *

- * $Id$

- *

- ***************************************************************************/

-

-/***************************************************************************

- *

- * This program is free software; you can redistribute it and/or modify

- * it under the terms of the GNU General Public License as published by

- * the Free Software Foundation; either version 2 of the License, or

- * (at your option) any later version.

- *

- ***************************************************************************/

-// Include files

-require($phpbb_root_path . 'extension.inc');

-// Get mode

-switch ($mode)

- case 'add':

- case 'edit':

- $action = (isset($_POST['action'])) ? htmlspecialchars($_POST['action']) : '';

- $forum_id = (isset($_REQUEST['this_f'])) ? intval($_REQUEST['this_f']) : ((isset($_REQUEST['f'])) ? intval($_REQUEST['f']) : 0);

- $parent_id = (isset($_REQUEST['parent_id'])) ? intval($_REQUEST['parent_id']) : 0;

-

- $forum_type = (isset($_POST['forum_type'])) ? intval($_POST['forum_type']) : FORUM_POST;

- $forum_status = (isset($_POST['forum_status'])) ? intval($_POST['forum_status']) : ITEM_UNLOCKED;

- $forum_name = (isset($_POST['forum_name'])) ? htmlspecialchars(stripslashes($_POST['forum_name'])) : '';

- $forum_link = (isset($_POST['forum_link'])) ? htmlspecialchars(stripslashes($_POST['forum_link'])) : '';

- $forum_link_track = (!empty($_POST['forum_link_track'])) ? 1 : 0;

- $forum_desc = (isset($_POST['forum_desc'])) ? str_replace("\n", '<br />', stripslashes($_POST['forum_desc'])) : '';

- $forum_image = (isset($_POST['forum_image'])) ? htmlspecialchars(stripslashes($_POST['forum_image'])) : '';

- $forum_style = (isset($_POST['forum_style'])) ? intval($_POST['forum_style']) : 0;

- $display_on_index = (!empty($_POST['display_on_index'])) ? 1 : 0;

- $forum_topics_per_page = (isset($_POST['topics_per_page'])) ? intval($_POST['topics_per_page']) : 0;

- $enable_icons = (!empty($_POST['enable_icons'])) ? 1 : 0;

- $enable_prune = (!empty($_POST['enable_prune'])) ? 1 : 0;

- $prune_days = (isset($_POST['prune_days'])) ? intval($_POST['prune_days']) : 7;

- $prune_freq = (isset($_POST['prune_freq'])) ? intval($_POST['prune_freq']) : 1;

- $prune_old_polls = (!empty($_POST['prune_old_polls'])) ? 1 : 0;

- $prune_announce = (!empty($_POST['prune_announce'])) ? 1 : 0;

- $prune_sticky = (!empty($_POST['prune_sticky'])) ? 1 : 0;

- $forum_password = (isset($_POST['forum_password'])) ? htmlspecialchars(stripslashes($_POST['forum_password'])) : '';

- $forum_password_confirm = (isset($_POST['forum_password_confirm'])) ? htmlspecialchars(stripslashes($_POST['forum_password_confirm'])) : '';

- if (isset($_POST['update']))

- {

- $error = array();

- if (!trim($_POST['forum_name']))

- {

- $error[] = $user->lang['FORUM_NAME_EMPTY'];

- }

- if (!empty($password) || !empty($password_confirm))

- if ($password != $password_confirm)

- {

- $error[] = $user->lang['FORUM_PASSWORD_MISMATCH'];

- }

- if ($prune_days < 0 || $prune_freq < 0)

- {

- $error[] = $user->lang['FORUM_DATA_NEGATIVE'];

- }

- // Set forum flags

- // 1 = link tracking

- // 2 = prune old polls

- // 4 = prune announcements

- // 8 = prune stickies

- $forum_flags = 0;

- $forum_flags += ($forum_link_track) ? 1 : 0;

- $forum_flags += ($prune_old_polls) ? 2 : 0;

- $forum_flags += ($prune_announce) ? 4 : 0;

- $forum_flags += ($prune_sticky) ? 8 : 0;

-

- // What are we going to do tonight Brain? The same thing we do everynight,

- // try to take over the world ... or decide whether to continue update

- // and if so, whether it's a new forum/cat/link or an existing one

- if (sizeof($error))

- {

- $error = implode('<br />', $error);

- }

- else if ($mode == 'add')

- {

- if ($parent_id)

- {

- $sql = 'SELECT left_id, right_id

- FROM ' . FORUMS_TABLE . "

- WHERE forum_id = $parent_id";

- $result = $db->sql_query($sql);

-

- if (!($row = $db->sql_fetchrow($result)))

- {

- trigger_error('Parent does not exist', E_USER_ERROR);

- }

- $db->sql_freeresult($result);

-

- extract($row);

- unset($row);

-

- $sql = 'UPDATE ' . FORUMS_TABLE . "

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

- WHERE left_id > $right_id";

- $db->sql_query($sql);

-

- $sql = 'UPDATE ' . FORUMS_TABLE . "

- SET right_id = right_id + 2

- WHERE $left_id BETWEEN left_id AND right_id";

- $db->sql_query($sql);

-

- $left_id = $right_id;

- ++$right_id;

- }

- else

- {

- $sql = 'SELECT MAX(right_id) AS right_id

- FROM ' . FORUMS_TABLE;

- $result = $db->sql_query($sql);

-

- $row = $db->sql_fetchrow($result);

- $db->sql_freeresult($result);

-

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

- $right_id = $left_id + 1;

- }

-

- $sql = array(

- 'parent_id' => (int) $parent_id,

- 'left_id' => (int) $left_id,

- 'right_id' => (int) $right_id,

- 'forum_name' => (string) $forum_name,

- 'forum_desc' => (string) $forum_desc,

- 'forum_type' => (int) $forum_type,

- 'forum_status' => (int) $forum_status,

- 'forum_link' => (string) $forum_link,

- 'forum_password' => (string) $forum_password,

- 'forum_topics_per_page' => (int) $forum_topics_per_page,

- 'forum_style' => (int) $forum_style,

- 'forum_image' => (string) $forum_image,

- 'display_on_index' => (int) $display_on_index,

- 'forum_flags' => (int) $forum_flags,

- 'enable_icons' => (int) $enable_icons,

- 'enable_prune' => (int) $enable_prune,

- 'prune_days' => (int) $prune_days,

- 'prune_freq' => (int) $prune_freq,

- );

-

- $sql = 'INSERT INTO ' . FORUMS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql);

- $db->sql_query($sql);

-

- $forum_id = $db->sql_nextid();

-

- add_log('admin', 'LOG_FORUM_ADD', $forum_name);

-

- // Redirect to permissions

- $message = $user->lang['FORUM_UPDATED'] . '<br /><br />' . sprintf($user->lang['REDIRECT_ACL'], "<a href=\"admin_permissions.$phpEx$SID&amp;mode=forum&amp;submit_usergroups=true&amp;ug_type=forum&amp;action=usergroups&amp;f[forum][]=$forum_id\">", '</a>');

- trigger_error($message);

-

- }

- else if ($mode == 'edit')

- {

- $row = get_forum_info($forum_id);

-

- if ($row['forum_type'] != $forum_type && $action)

- {

- if ($action == 'move' && $_POST['to_forum_id'])

- {

- move_forum_content($forum_id, $_POST['to_forum_id']);

- }

- elseif ($action == 'delete')

- {

- delete_forum_content($forum_id);

- }

-

- $sql['forum_posts'] = 0;

- $sql['forum_topics'] = 0;

- $sql['forum_topics_real'] = 0;

- }

-

- if ($row['parent_id'] != $parent_id)

- {

- move_forum($forum_id, $parent_id);

- }

- elseif ($row['forum_name'] != $forum_name)

- {

- $sql = 'UPDATE ' . FORUMS_TABLE . "

- SET forum_parents = ''

- WHERE left_id > " . $row['left_id'] . '

- AND right_id < ' . $row['right_id'];

- $db->sql_query($sql);

- }

-

- $sql = array(

- 'parent_id' => (int) $parent_id,

- 'forum_name' => (string) $forum_name,

- 'forum_desc' => (string) $forum_desc,

- 'forum_type' => (int) $forum_type,

- 'forum_status' => (int) $forum_status,

- 'forum_link' => (string) $forum_link,

- 'forum_topics_per_page' => (int) $forum_topics_per_page,

- 'forum_password' => (string) $forum_password,

- 'forum_style' => (int) $forum_style,

- 'forum_image' => (string) $forum_image,

- 'display_on_index' => (int) $display_on_index,

- 'forum_flags' => (int) $forum_flags,

- 'enable_icons' => (int) $enable_icons,

- 'enable_prune' => (int) $enable_prune,

- 'prune_days' => (int) $prune_days,

- 'prune_freq' => (int) $prune_freq,

- );

-

- $sql = 'UPDATE ' . FORUMS_TABLE . '

- SET ' . $db->sql_build_array('UPDATE', $sql) . "

- WHERE forum_id = $forum_id";

- $db->sql_query($sql);

-

- add_log('admin', 'LOG_FORUM_EDIT', $forum_name);

- trigger_error($user->lang['FORUM_UPDATED']);

- }

-

- if ($parent_id && !isset($_POST['update']))

- if (!empty($error))

- <td class="row3" colspan="2" align="center"><span style="color:red"><?php echo $error; ?></span></td>

- if ($old_forum_type == FORUM_POST && $forum_type == FORUM_CAT)

-?><br /><input type="radio" name="action" value="delete" checked="checked" /> <?php echo $user->lang['DELETE_ALL_POSTS'] ?> &nbsp;<input type="radio" name="action" value="move" /> <?php echo $user->lang['MOVE_POSTS_TO'] ?> <select name="to_forum_id"><?php echo $forums_list ?></select><?php

- <td class="row2"><input class="post" type="text" size="25" name="forum_image" value="<?php echo $forum_image ?>" /><br /><?php

-

-

- $forum_id = (isset($_REQUEST['this_f'])) ? intval($_REQUEST['this_f']) : ((isset($_REQUEST['f'])) ? intval($_REQUEST['f']) : 0);

-

- if (isset($_POST['update']))

- {

-

- $action_subforums = (!empty($_POST['action_subforums'])) ? $_POST['action_subforums'] : '';

- $action_posts = (!empty($_POST['action_posts'])) ? $_POST['action_posts'] : '';

-

- $row = get_forum_info($forum_id);

- extract($row);

-

- $log_action_posts = $log_action_forums = '';

- if ($action_posts == 'delete')

- {

- $log_action_posts = 'POSTS';

- delete_forum_content($forum_id);

- }

- elseif ($action_posts == 'move')

- {

- if (empty($_POST['posts_to_id']))

- {

- trigger_error($user->lang['NO_DESTINATION_FORUM']);

- }

-

- $log_action_posts = 'MOVE_POSTS';

-

- $sql = 'SELECT forum_name

- FROM ' . FORUMS_TABLE . "

- WHERE forum_id = " . intval($_POST['posts_to_id']);

- $result = $db->sql_query($sql);

-

- if (!($row = $db->sql_fetchrow($result)))

- {

- trigger_error($user->lang['NO_FORUM']);

- }

- $db->sql_freeresult($result);

-

- $posts_to_name = $row['forum_name'];

- unset($row);

-

- move_forum_content($forum_id, intval($_POST['posts_to_id']));

- }

-

- if ($action_subforums == 'delete')

- {

- $log_action_forums = 'FORUMS';

-

- $forum_ids = array($forum_id);

- $rows = get_forum_branch($forum_id, 'children', 'descending', FALSE);

-

- foreach ($rows as $row)

- {

- $forum_ids[] = $row['forum_id'];

- delete_forum_content($row['forum_id']);

- }

-

- $diff = count($forum_ids) * 2;

-

- $sql = 'DELETE FROM ' . FORUMS_TABLE . '

- WHERE forum_id IN (' . implode(', ', $forum_ids) . ')';

- $db->sql_query($sql);

- }

- elseif ($action_subforums == 'move')

- {

- if (empty($_POST['subforums_to_id']))

- {

- trigger_error($user->lang['NO_DESTINATION_FORUM']);

- }

-

- $log_action_forums = 'MOVE_FORUMS';

-

- $sql = 'SELECT forum_name

- FROM ' . FORUMS_TABLE . "

- WHERE forum_id = " . intval($_POST['subforums_to_id']);

- $result = $db->sql_query($sql);

-

- if (!($row = $db->sql_fetchrow($result)))

- {

- trigger_error($user->lang['NO_FORUM']);

- }

- $db->sql_freeresult($result);

-

- $subforums_to_name = $row['forum_name'];

- unset($row);

-

- $sql = 'SELECT forum_id

- FROM ' . FORUMS_TABLE . "

- WHERE parent_id = $forum_id";

- $result = $db->sql_query($sql);

-

- while ($row = $db->sql_fetchrow($result))

- {

- move_forum($row['forum_id'], intval($_POST['subforums_to_id']));

- }

- $db->sql_freeresult($result);

-

- $sql = 'UPDATE ' . FORUMS_TABLE . '

- SET parent_id = ' . $_POST['subforums_to_id'] . "

- WHERE parent_id = $forum_id";

- $db->sql_query($sql);

-

- $diff = 2;

-

- $sql = 'DELETE FROM ' . FORUMS_TABLE . "

- WHERE forum_id = $forum_id";

- $db->sql_query($sql);

- }

- else

- {

- $diff = 2;

- $sql = 'DELETE FROM ' . FORUMS_TABLE . "

- WHERE forum_id = $forum_id";

- $db->sql_query($sql);

- }

-

- // Resync tree

- $sql = 'UPDATE ' . FORUMS_TABLE . "

- SET right_id = right_id - $diff

- WHERE left_id < $right_id AND right_id > $right_id";

- $db->sql_query($sql);

-

- $sql = 'UPDATE ' . FORUMS_TABLE . "

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

- WHERE left_id > $right_id";

- $db->sql_query($sql);

-

- $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;

- }

-

- trigger_error($user->lang['FORUM_DELETED']);

- }

-

- </tr>

- <tr>

- <td><input type="radio" name="action_posts" value="move" /> <?php echo $user->lang['MOVE_POSTS_TO'] ?> <select name="posts_to_id" ?><?php echo $move_posts_list ?></select></td>

- </tr>

- $forum_id = intval($_GET['this_f']);

- $sql = 'SELECT parent_id, left_id, right_id

- FROM ' . FORUMS_TABLE . "

- $sql = 'SELECT forum_id, forum_name, left_id, right_id

- FROM ' . FORUMS_TABLE . "

- WHERE parent_id = $parent_id

- WHERE left_id > ' . $forum_info[$up_id]['left_id'] . '

- WHERE left_id > ' . $forum_info[$down_id]['left_id'] . '

- $sql = "SELECT forum_name

- FROM " . FORUMS_TABLE . "

-$sql = 'SELECT *

- FROM ' . FORUMS_TABLE . "

- WHERE parent_id = $forum_id

- $folder_image = '<img src="images/icon_folder_lock.gif" width="46" height="25" alt="' . $user->lang['LOCKED'] . '" alt="' . $user->lang['LOCKED'] . '" />';

- $folder_image = '<img src="images/icon_folder_link.gif" width="46" height="25" alt="' . $user->lang['LINK'] . '" alt="' . $user->lang['LINK'] . '" />';

- $folder_image = ($row['left_id'] + 1 != $row['right_id']) ? '<img src="images/icon_subfolder.gif" width="46" height="25" alt="' . $user->lang['SUBFORUM'] . '" alt="' . $user->lang['SUBFORUM'] . '" />' : '<img src="images/icon_folder.gif" width="46" height="25" alt="' . $user->lang['FOLDER'] . '" alt="' . $user->lang['FOLDER'] . '" />';

- $url = "$phpEx$SID&amp;f=$forum_id&amp;this_f=" . $row['forum_id'];

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

- $sql = 'SELECT MAX(right_id) AS right_id

- FROM ' . FORUMS_TABLE . '

-function move_forum_content($from_id, $to_id)

- $table_ary = array(LOG_MOD_TABLE, POSTS_TABLE, TOPICS_TABLE);

- $sql = "UPDATE $table

- $sql = 'SELECT t1.topic_id

- FROM ' .TOPICS_TABLE . ' t1, ' . TOPICS_TABLE . " t2

- WHERE t2.forum_id = $to_id

- AND t1.topic_moved_id = t2.topic_id

- AND t1.forum_id = t2.forum_id";

- $result = $db->sql_query($result);

-

- if ($row = $db->sql_fetchrow($result))

- $topic_id_ary = array();

- do

- {

- $topic_id_ary[] = $row['topic_id'];

- }

- while ($row = $db->sql_fetchrow($result));

- $sql = 'DELETE FROM ' . TOPICS_TABLE . '

- WHERE topic_id IN (' . implode(', ', $topic_id_ary) . ')';

- $db->sql_query($sql);

- unset($topic_id_ary);

- $db->sql_freeresult($result);

-

- sync('forum', 'forum_id', $to_id);

-function delete_forum_content($forum_id)

- global $db;

- $db->sql_transaction();

- $sql = 'SELECT post_id

- FROM ' . POSTS_TABLE . "

- WHERE forum_id = $forum_id";

- $result = $db->sql_query();

- if ($row = $db->sql_fetchrow($result))

- $id_ary = array();

-

- do

- $id_ary[] = $row['post_id'];

- while ($row = $db->sql_fetchrow($result));

- // TODO

- // Could be problematical with large forums ... should split array

- // if large

- $sql = 'DELETE FROM ' . SEARCH_MATCH_TABLE . '

- WHERE post_id IN (' . implode(', ', $id_ary) . ')';

- $db->sql_query($sql);

- // Remove attachments

- delete_attachment($id_ary);

- unset($id_ary);

- $db->sql_freeresult();

- $sql = 'SELECT topic_id

- FROM ' . TOPICS_TABLE . "

- WHERE forum_id = $forum_id";

- $result = $db->sql_query();

- if ($row = $db->sql_fetchrow($result))

- $id_ary = array();

- do

- $id_ary[] = $row['topic_id'];

- while ($row = $db->sql_fetchrow($result));

- $sql_in = implode(', ', $id_ary);

- unset($id_ary);

-

- $table_ary = array(TOPICS_WATCH_TABLE, POLL_OPTIONS_TABLE, POLL_VOTES_TABLE);

- foreach ($sql_ary as $table)

- $sql = "DELETE FROM $table

- WHERE topic_id IN ($sql_in)";

- $db->sql_query($sql);

- unset($table_ary);

- $sql = 'DELETE FROM ' . TOPICS_TABLE . "

- WHERE topic_moved_id IN ($sql_in)";

- $db->sql_query($sql);

- unset($sql_in);

- $db->sql_freeresult();

- $table_ary = array(TOPICS_TABLE, POSTS_TABLE, ACL_GROUPS_TABLE, ACL_USERS_TABLE, MODERATOR_TABLE, LOG_MOD_TABLE, FORUMS_WATCH_TABLE);

- foreach ($sql_ary as $table)

- $sql = "DELETE FROM $table

- unset($table_ary);

- case 'mysql':

-/* $sql = 'SHOW TABLES';

- $result = $db->sql_query($sql);

- $field_name = 'Tables_in_' . $db->dbname;

- $table_ary = array();

- if (preg_match('#^' . preg_quote($phpEx, '#') . '#', $row[$field_name]))

- $table_ary[] = $row[$field_name];

- if (sizeof($table_ary))

- {*/

- $table_ary = array(TOPICS_TABLE, POSTS_TABLE, ACL_GROUPS_TABLE, ACL_USERS_TABLE, MODERATOR_TABLE, LOG_MOD_TABLE, FORUMS_WATCH_TABLE, TOPICS_WATCH_TABLE, POLL_OPTIONS_TABLE, POLL_VOTES_TABLE, SEARCH_MATCH_TABLE);

- $sql = 'OPTIMIZE TABLE ' . implode(', ', $table_ary);

- $db->sql_query($sql);

-// }

- unset($table_ary);

- break;

- case 'postgresql':

- $db->sql_query('VACUUM');

- break;