+ elseif ($row['forum_name'] != $_POST['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);

+ }

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

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

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

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

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

+ $values[] = "'" . sql_quote($var) . "'";

+ $values[] = "$key = '" . sql_quote($var) . "'";

+ $last_post .= ($forum_last_poster_id == ANONYMOUS) ? (($forum_last_poster_name != '') ? $forum_last_poster_name . ' ' : $user->lang['Guest'] . ' ') : '<a href="profile.' . $phpEx . $SID . '&amp;mode=viewprofile&amp;u=' . $forum_last_poster_id . '">' . $forum_last_poster_name . '</a> ';

+function sql_addslashes($msg)

+{

+ return str_replace("'", "''", str_replace('\\', '\\\\', $msg));

+}

+

+function watch_topic_forum($mode, &$s_watching, &$s_watching_img, $user_id, $match_id, $notify_status = 'unset')

+ if ($notify_status == 'unset')

+ {

+ $sql = "SELECT notify_status

+ FROM $table_sql

+ WHERE $where_sql = $match_id

+ AND user_id = $user_id";

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

+

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

+ {

+ $notify_status = $row['notify_status'];

+ }

+ else

+ {

+ $notify_status = NULL;

+ }

+ }

+ if (!is_null($notify_status))

+ if ($notify_status)

+ if ($mode != 'register')

+ {

+ $sql = 'UPDATE ' . FORUMS_TABLE . "

+ SET forum_last_poster_name = '" . sql_quote($username) . "'

+ WHERE forum_last_poster_id = " . $user_id;

+ $db->sql_query($sql);

+ }

+ $db->sql_query('UPDATE ' . USERS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_ary) . ' WHERE user_id = ' . $user_id);

+

+ if ($config['newest_user_id'] == $user_id)

+ {

+ $sql = 'UPDATE ' . CONFIG_TABLE . "

+ SET config_value = '" . sql_quote($username) . "'

+ WHERE config_name = 'newest_username'";

+ $db->sql_query($sql);

+ }

+

+ $sql = 'SELECT * FROM ' . FORUMS_TABLE . ' ORDER BY left_id';

+INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('newest_user_id', '2', 1);

+ forum_parents text,

+// Grab all data

+extract($_GET);

+extract($_POST);

+

+ 'forum_last_poster_name'=> ($user->data['user_id'] == ANONYMOUS) ? $username : $user->data['username'],

+ redirect("login.$phpEx?redirect=search.$phpEx&search_id=newposts");

+ redirect("login.$phpEx?redirect=search.$phpEx&search_id=egosearch");

+$mark_read = (!empty($_REQUEST['mark'])) ? $_REQUEST['mark'] : '';

+$forum_id = (!empty($_REQUEST['f'])) ? intval($_REQUEST['f']) : 0;

+if (!$forum_id)

+if ($user->data['user_id'] == ANONYMOUS)

+{

+ $sql = 'SELECT * FROM ' . FORUMS_TABLE . ' WHERE forum_id = ' . $forum_id;

+}

+else

+{

+ switch (SQL_LAYER)

+ {

+ //TODO

+ case 'oracle':

+ break;

+

+ default:

+ $sql = 'SELECT f.*, fw.notify_status

+ FROM ' . FORUMS_TABLE . ' f

+ LEFT JOIN ' . FORUMS_WATCH_TABLE . ' fw ON fw.user_id = ' . $user->data['user_id'] . ' AND f.forum_id = fw.forum_id

+ WHERE f.forum_id = ' . $forum_id;

+ }

+}

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

+if (!$forum_data = $db->sql_fetchrow($result))

+$user->setup(false, $forum_data['forum_style']);

+ if ($user->data['user_id'] == ANONYMOUS)

+ trigger_error('Sorry_auth_read');

+// Get forum parents

+$forum_parents = array();

+if ($forum_data['parent_id'] > 0)

+ if (empty($forum_data['forum_parents']))

+ $sql = 'SELECT forum_id, forum_name

+ FROM ' . FORUMS_TABLE . '

+ WHERE left_id < ' . $forum_data['left_id'] . '

+ AND right_id > ' . $forum_data['right_id'] . '

+ ORDER BY left_id ASC';

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

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

+ $forum_parents[$row['forum_id']] = $row['forum_name'];

+

+ $sql = 'UPDATE ' . FORUMS_TABLE . "

+ SET forum_parents = '" . sql_addslashes(serialize($forum_parents)) . "'

+ WHERE parent_id = " . $forum_data['parent_id'];

+ $db->sql_query($sql);

+ $forum_parents = unserialize($forum_data['forum_parents']);

+ }

+}

+

+// Build navigation links

+foreach ($forum_parents as $parent_forum_id => $parent_name)

+{

+ $template->assign_block_vars('navlinks', array(

+ 'FORUM_NAME' => $parent_name,

+ 'U_VIEW_FORUM' => 'viewforum.' . $phpEx . $SID . '&amp;f=' . $parent_forum_id

+ ));

+}

+$template->assign_block_vars('navlinks', array(

+ 'FORUM_NAME' => $forum_data['forum_name'],

+ 'U_VIEW_FORUM' => 'viewforum.' . $phpEx . $SID . '&amp;f=' . $forum_id

+));

+

+

+// Get forum children

+if ($forum_data['left_id'] != $forum_data['right_id'] - 1)

+{

+ $sql = 'SELECT *

+ FROM ' . FORUMS_TABLE . '

+ WHERE left_id > ' . $forum_data['left_id'] . ' AND left_id < ' . $forum_data['right_id'] . '

+ ORDER BY left_id ASC';

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

+

+ $type = 'parent';

+ $forum_rows = array();

+

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

+ {

+/*

+ if ($type == 'parent')

+ $link = 'index.' . $phpEx . $SID . '&amp;c=' . $row['forum_id'];

+ $link = 'viewforum.' . $phpEx . $SID . '&amp;f=' . $row['forum_id'];

+ $template->assign_block_vars('navlinks', array(

+ 'FORUM_NAME' => $row['forum_name'],

+ 'U_VIEW_FORUM' => $link

+ ));

+

+ if ($row['forum_id'] == $forum_id)

+ $branch_root_id = 0;

+ $forum_data = $row;

+ $type = 'child';

+ else

+*/

+ if ($row['parent_id'] == $forum_data['forum_id'])

+ // Root-level forum

+ $forum_rows[] = $row;

+ $parent_id = $row['forum_id'];

+

+ if ($row['forum_status'] == ITEM_CATEGORY)

+ {

+ $branch_root_id = $row['forum_id'];

+ }

+ else

+ {

+ $s_has_subforums = TRUE;

+ }

+ elseif ($row['parent_id'] == $branch_root_id)

+ {

+ // Forum directly under a category

+ $forum_rows[] = $row;

+ $parent_id = $row['forum_id'];

+

+ if ($row['forum_status'] != ITEM_CATEGORY)

+ {

+ $s_has_subforums = TRUE;

+ }

+ }

+ elseif ($row['forum_status'] != ITEM_CATEGORY)

+ {

+ // Subforum

+ if ($auth->acl_get('f_list', $row['forum_id']))

+ {

+ $subforums[$parent_id][] = $row;

+ }

+ }

+/*

+*/

+ $db->sql_freeresult();

+$notify_status = (isset($forum_data['notify_status'])) ? $forum_data['notify_status'] : NULL;

+watch_topic_forum('forum', $s_watching_forum, $s_watching_forum_img, $user->data['user_id'], $forum_id, $notify_status);

+// Do we have subforums? if so, let's include this harmless file

+if ($forum_data['left_id'] != $forum_data['right_id'] - 1)

+{

+ $template->assign_vars(array(

+ 'S_HAS_SUBFORUM' => TRUE,

+ 'L_SUBFORUM' => (count($forum_rows) == 1) ? $user->lang['Subforum'] : $user->lang['Subforums']

+ ));

+

+ $root_id = $forum_id;

+ include($phpbb_root_path . 'includes/forums_display.' . $phpEx);

+}

+

+$extra_fields = (!$post_id) ? '' : ", COUNT(p2.post_id) AS prev_posts";

+if ($user->data['user_id'] != ANONYMOUS)

+{

+ switch (SQL_LAYER)

+ {

+ //TODO

+ case 'oracle':

+ break;

+

+ default:

+ $extra_fields .= ', tw.notify_status';

+ $join_sql_table .= ' LEFT JOIN ' . TOPICS_WATCH_TABLE . ' tw ON tw.user_id = ' . $user->data['user_id'] . ' AND t.topic_id = tw.topic_id';

+ }

+}

+

+$sql = "SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.poll_start, t.poll_length, t.poll_title, f.forum_name, f.forum_status, f.forum_id, f.forum_style" . $extra_fields . "

+if (!extract($db->sql_fetchrow($result)))

+watch_topic_forum('topic', $s_watching_topic, $s_watching_topic_img, $user->data['user_id'], $topic_id, $notify_status);