- // Add global forum id

- $forum_ids[] = 0;

-

- $forum_ids = array(0, $this->forum_id);

- WHERE ' . $db->sql_in_set('forum_id', $forum_ids) . '

- if ($this->topic_data['topic_type'] == POST_GLOBAL)

- {

- // We need to find at least one postable forum where feeds are enabled,

- // that the user can read and maybe also has approve permissions.

- $in_fid_ary = $this->get_readable_forums();

-

- if (empty($in_fid_ary))

- {

- // User cannot read any forums

- trigger_error('SORRY_AUTH_READ');

- }

-

- if (!$this->topic_data['topic_approved'])

- {

- // Also require m_approve

- $in_fid_ary = array_intersect($in_fid_ary, $this->get_moderator_approve_forums());

-

- if (empty($in_fid_ary))

- {

- trigger_error('SORRY_AUTH_READ');

- }

- }

-

- // Diff excluded forums

- $in_fid_ary = array_diff($in_fid_ary, $this->get_excluded_forums());

-

- if (empty($in_fid_ary))

- {

- trigger_error('SORRY_AUTH_READ');

- }

-

- // Also exclude passworded forums

- $in_fid_ary = array_diff($in_fid_ary, $this->get_passworded_forums());

-

- if (empty($in_fid_ary))

- {

- trigger_error('SORRY_AUTH_READ');

- }

-

- $sql = 'SELECT forum_id, left_id

- FROM ' . FORUMS_TABLE . '

- WHERE forum_type = ' . FORUM_POST . '

- AND ' . $db->sql_in_set('forum_id', $in_fid_ary) . '

- ORDER BY left_id ASC';

- $result = $db->sql_query_limit($sql, 1);

- $this->forum_data = $db->sql_fetchrow($result);

- $db->sql_freeresult($result);

-

- if (empty($this->forum_data))

- {

- // No forum found.

- trigger_error('SORRY_AUTH_READ');

- }

- unset($in_fid_ary);

- else

- $this->forum_id = (int) $this->topic_data['forum_id'];

- // Make sure topic is either approved or user authed

- if (!$this->topic_data['topic_approved'] && !$auth->acl_get('m_approve', $this->forum_id))

- {

- trigger_error('SORRY_AUTH_READ');

- }

- // Make sure forum is not excluded from feed

- if (phpbb_optionget(FORUM_OPTION_FEED_EXCLUDE, $this->topic_data['forum_options']))

- {

- trigger_error('NO_FEED');

- }

- // Make sure we can read this forum

- if (!$auth->acl_get('f_read', $this->forum_id))

- // Make sure forum is not passworded or user is authed

- if ($this->topic_data['forum_password'])

- {

- $forum_ids_passworded = $this->get_passworded_forums();

-

- if (isset($forum_ids_passworded[$this->forum_id]))

- {

- trigger_error('SORRY_AUTH_READ');

- }

-

- unset($forum_ids_passworded);

- }

- // Add global forum

- $in_fid_ary[] = 0;

-

- // Add global forum

- $in_fid_ary[] = 0;

-

- // Add global forum

- $in_fid_ary[] = 0;

-

- if ($new_topic_type != POST_GLOBAL)

- WHERE " . $db->sql_in_set('topic_id', $topic_ids) . '

- AND forum_id <> 0';

-

- // Reset forum id if a global topic is within the array

- $to_forum_id = request_var('to_forum_id', 0);

-

- if ($to_forum_id)

- {

- $sql = 'UPDATE ' . TOPICS_TABLE . "

- SET topic_type = $new_topic_type, forum_id = $to_forum_id

- WHERE " . $db->sql_in_set('topic_id', $topic_ids) . '

- AND forum_id = 0';

- $db->sql_query($sql);

-

- // Update forum_ids for all posts

- $sql = 'UPDATE ' . POSTS_TABLE . "

- SET forum_id = $to_forum_id

- WHERE " . $db->sql_in_set('topic_id', $topic_ids) . '

- AND forum_id = 0';

- $db->sql_query($sql);

-

- // Do a little forum sync stuff

- $sql = 'SELECT SUM(t.topic_replies + t.topic_approved) as topic_posts, COUNT(t.topic_approved) as topics_authed

- FROM ' . TOPICS_TABLE . ' t

- WHERE ' . $db->sql_in_set('t.topic_id', $topic_ids);

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

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

- $db->sql_freeresult($result);

-

- $sync_sql = array();

-

- if ($row_data['topic_posts'])

- {

- $sync_sql[$to_forum_id][] = 'forum_posts = forum_posts + ' . (int) $row_data['topic_posts'];

- }

-

- if ($row_data['topics_authed'])

- {

- $sync_sql[$to_forum_id][] = 'forum_topics = forum_topics + ' . (int) $row_data['topics_authed'];

- }

-

- $sync_sql[$to_forum_id][] = 'forum_topics_real = forum_topics_real + ' . (int) sizeof($topic_ids);

-

- foreach ($sync_sql as $forum_id_key => $array)

- {

- $sql = 'UPDATE ' . FORUMS_TABLE . '

- SET ' . implode(', ', $array) . '

- WHERE forum_id = ' . $forum_id_key;

- $db->sql_query($sql);

- }

-

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

- }

- }

- else

- {

- // Get away with those topics already being a global announcement by re-calculating $topic_ids

- $sql = 'SELECT topic_id

- FROM ' . TOPICS_TABLE . '

- WHERE ' . $db->sql_in_set('topic_id', $topic_ids) . '

- AND forum_id <> 0';

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

-

- $topic_ids = array();

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

- {

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

- }

- $db->sql_freeresult($result);

-

- if (sizeof($topic_ids))

- {

- // Delete topic shadows for global announcements

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

- WHERE ' . $db->sql_in_set('topic_moved_id', $topic_ids);

- $db->sql_query($sql);

-

- $sql = 'UPDATE ' . TOPICS_TABLE . "

- SET topic_type = $new_topic_type, forum_id = 0

- WHERE " . $db->sql_in_set('topic_id', $topic_ids);

- $db->sql_query($sql);

-

- // Update forum_ids for all posts

- $sql = 'UPDATE ' . POSTS_TABLE . '

- SET forum_id = 0

- WHERE ' . $db->sql_in_set('topic_id', $topic_ids);

- $db->sql_query($sql);

-

- // Do a little forum sync stuff

- $sql = 'SELECT SUM(t.topic_replies + t.topic_approved) as topic_posts, COUNT(t.topic_approved) as topics_authed

- FROM ' . TOPICS_TABLE . ' t

- WHERE ' . $db->sql_in_set('t.topic_id', $topic_ids);

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

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

- $db->sql_freeresult($result);

-

- $sync_sql = array();

-

- if ($row_data['topic_posts'])

- {

- $sync_sql[$forum_id][] = 'forum_posts = forum_posts - ' . (int) $row_data['topic_posts'];

- }

-

- if ($row_data['topics_authed'])

- {

- $sync_sql[$forum_id][] = 'forum_topics = forum_topics - ' . (int) $row_data['topics_authed'];

- }

-

- $sync_sql[$forum_id][] = 'forum_topics_real = forum_topics_real - ' . (int) sizeof($topic_ids);

-

- foreach ($sync_sql as $forum_id_key => $array)

- {

- $sql = 'UPDATE ' . FORUMS_TABLE . '

- SET ' . implode(', ', $array) . '

- WHERE forum_id = ' . $forum_id_key;

- $db->sql_query($sql);

- }

-

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

- }

- // Global topic involved?

- $global_involved = false;

-

- if ($new_topic_type != POST_GLOBAL)

- {

- $sql = 'SELECT forum_id

- FROM ' . TOPICS_TABLE . '

- WHERE ' . $db->sql_in_set('topic_id', $topic_ids) . '

- AND forum_id = 0';

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

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

- $db->sql_freeresult($result);

-

- if ($row)

- {

- $global_involved = true;

- }

- }

-

- if ($global_involved)

- {

- global $template;

-

- $template->assign_vars(array(

- 'S_FORUM_SELECT' => make_forum_select(request_var('f', $forum_id), false, false, true, true),

- 'S_CAN_LEAVE_SHADOW' => false,

- 'ADDITIONAL_MSG' => (sizeof($topic_ids) == 1) ? $user->lang['SELECT_FORUM_GLOBAL_ANNOUNCEMENT'] : $user->lang['SELECT_FORUM_GLOBAL_ANNOUNCEMENTS'])

- );

-

- confirm_box(false, $l_new_type, build_hidden_fields($s_hidden_fields), 'mcp_move.html');

- }

- else

- {

- confirm_box(false, $l_new_type, build_hidden_fields($s_hidden_fields));

- }

- $forum_id = (int) ($row['forum_id']) ? $row['forum_id'] : $forum_id;

- if (!$row['forum_id'])

- {

- // Global Announcement?

- $row['forum_id'] = request_var('f', 0);

- }

-

- if (!$row['forum_id'])

- {

- // Global Announcement?

- $row['forum_id'] = request_var('f', 0);

- }

-

- AND forum_id IN (0, " . implode(', ', $ip_forums) . ')';

- AND (f.forum_id = t.forum_id

- OR f.forum_id = $forum_id)" .

- AND (f.forum_id = t.forum_id

- OR f.forum_id = $forum_id)" .

- // Check if we want to de-globalize the topic... and ask for new forum

- if ($post_data['topic_type'] != POST_GLOBAL)

- {

- $sql = 'SELECT topic_type, forum_id

- FROM ' . TOPICS_TABLE . "

- WHERE topic_id = $topic_id";

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

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

- $db->sql_freeresult($result);

-

- if ($row && !$row['forum_id'] && $row['topic_type'] == POST_GLOBAL)

- {

- $to_forum_id = request_var('to_forum_id', 0);

-

- if ($to_forum_id)

- {

- $sql = 'SELECT forum_type

- FROM ' . FORUMS_TABLE . '

- WHERE forum_id = ' . $to_forum_id;

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

- $forum_type = (int) $db->sql_fetchfield('forum_type');

- $db->sql_freeresult($result);

-

- if ($forum_type != FORUM_POST || !$auth->acl_get('f_post', $to_forum_id) || (!$auth->acl_get('m_approve', $to_forum_id) && !$auth->acl_get('f_noapprove', $to_forum_id)))

- {

- $to_forum_id = 0;

- }

- }

-

- if (!$to_forum_id)

- {

- include_once($phpbb_root_path . 'includes/functions_admin.' . $phpEx);

-

- $template->assign_vars(array(

- 'S_FORUM_SELECT' => make_forum_select(false, false, false, true, true, true),

- 'S_UNGLOBALISE' => true)

- );

-

- $submit = false;

- $refresh = true;

- }

- else

- {

- if (!$auth->acl_get('f_post', $to_forum_id))

- {

- // This will only be triggered if the user tried to trick the forum.

- trigger_error('NOT_AUTHORISED');

- }

-

- $forum_id = $to_forum_id;

- }

- }

- }

-

- $forum_id = (int) ($report_data['forum_id']) ? $report_data['forum_id'] : $forum_id;

- // we need to select a forum id for this global topic

- if (!$forum_id)

- {

- if (!isset($g_forum_id))

- {

- // Get a list of forums the user cannot read

- $forum_ary = array_unique(array_keys($auth->acl_getf('!f_read', true)));

-

- // Determine first forum the user is able to read (must not be a category)

- $sql = 'SELECT forum_id

- FROM ' . FORUMS_TABLE . '

- WHERE forum_type = ' . FORUM_POST;

-

- if (sizeof($forum_ary))

- {

- $sql .= ' AND ' . $db->sql_in_set('forum_id', $forum_ary, true);

- }

-

- $result = $db->sql_query_limit($sql, 1);

- $g_forum_id = (int) $db->sql_fetchfield('forum_id');

- }

- $u_forum_id = $g_forum_id;

- }

- else

- {

- $u_forum_id = $forum_id;

- }

-

- $view_topic_url_params = "f=$u_forum_id&amp;t=$result_topic_id" . (($u_hilit) ? "&amp;hilit=$u_hilit" : '');

- 'S_TOPIC_GLOBAL' => (!$forum_id) ? true : false,

- {L_POST_BY_AUTHOR} {searchresults.TOPIC_AUTHOR_FULL} &raquo; {searchresults.FIRST_POST_TIME}

- <!-- IF not searchresults.S_TOPIC_GLOBAL -->{L_IN} <a href="{searchresults.U_VIEW_FORUM}">{searchresults.FORUM_TITLE}</a><!-- ELSE --> ({L_GLOBAL})<!-- ENDIF -->

- <!-- IF searchresults.FORUM_TITLE -->

- <dd>{L_FORUM}: <a href="{searchresults.U_VIEW_FORUM}">{searchresults.FORUM_TITLE}</a></dd>

- <dd>{L_TOPIC}: <a href="{searchresults.U_VIEW_TOPIC}">{searchresults.TOPIC_TITLE}</a></dd>

- <!-- ELSE -->

- <dd>{L_GLOBAL}: <a href="{searchresults.U_VIEW_TOPIC}">{searchresults.TOPIC_TITLE}</a></dd>

- <!-- ENDIF -->

- 'WHERE' => 't.forum_id IN (' . $forum_id . ', 0)

- AND t.topic_type IN (' . POST_ANNOUNCE . ', ' . POST_GLOBAL . ')',

-

- // Check for global announcement correctness?

- if (!$row['forum_id'] && !$forum_id)

- {

- trigger_error('NO_TOPIC');

- }

- else if ($row['forum_id'])

- {

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

- }

- // Check for global announcement correctness?

- if ((!isset($row) || !$row['forum_id']) && !$forum_id)

- {

- trigger_error('NO_TOPIC');

- }

- else if (isset($row) && $row['forum_id'])

-// Firebird handles two columns of the same name a little differently, this

-// addresses that by forcing the forum_id to come from the forums table.

-if ($db->sql_layer === 'firebird')

-{

- $sql_array['SELECT'] = 'f.forum_id AS forum_id, ' . $sql_array['SELECT'];

-}

-

-$sql_array['WHERE'] .= ' AND (f.forum_id = t.forum_id';

-if (!$forum_id)

-{

- // If it is a global announcement make sure to set the forum id to a postable forum

- $sql_array['WHERE'] .= ' OR (t.topic_type = ' . POST_GLOBAL . '

- AND f.forum_type = ' . FORUM_POST . ')';

-}

-else

-{

- $sql_array['WHERE'] .= ' OR (t.topic_type = ' . POST_GLOBAL . "

- AND f.forum_id = $forum_id)";

-}

-

-$sql_array['WHERE'] .= ')';

-

-// Join to forum table on topic forum_id unless topic forum_id is zero

-// whereupon we join on the forum_id passed as a parameter ... this

-// is done so navigation, forum name, etc. remain consistent with where

-// user clicked to view a global topic

- 'U_MINI_POST' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'p=' . $row['post_id']) . (($topic_data['topic_type'] == POST_GLOBAL) ? '&amp;f=' . $forum_id : '') . '#p' . $row['post_id'],

-// Get last post time for all global announcements

-// to keep proper forums tracking

-if ($topic_data['topic_type'] == POST_GLOBAL)

-{

- $sql = 'SELECT topic_last_post_time as forum_last_post_time

- FROM ' . TOPICS_TABLE . '

- WHERE forum_id = 0

- ORDER BY topic_last_post_time DESC';

- $result = $db->sql_query_limit($sql, 1);

- $topic_data['forum_last_post_time'] = (int) $db->sql_fetchfield('forum_last_post_time');

- $db->sql_freeresult($result);

-

- $sql = 'SELECT mark_time as forum_mark_time

- FROM ' . FORUMS_TRACK_TABLE . '

- WHERE forum_id = 0

- AND user_id = ' . $user->data['user_id'];

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

- $topic_data['forum_mark_time'] = (int) $db->sql_fetchfield('forum_mark_time');

- $db->sql_freeresult($result);

-}

-

- markread('topic', (($topic_data['topic_type'] == POST_GLOBAL) ? 0 : $forum_id), $topic_id, $max_post_time);

- $all_marked_read = update_forum_tracking_info((($topic_data['topic_type'] == POST_GLOBAL) ? 0 : $forum_id), $topic_data['forum_last_post_time'], (isset($topic_data['forum_mark_time'])) ? $topic_data['forum_mark_time'] : false, false);