$sql = 'SELECT forum_id

FROM ' . TOPICS_TABLE . "

WHERE topic_id = $topic_id";

if (!$forum_id)

{

" . ((phpbb::$acl->acl_get('m_approve', $forum_id)) ? '' : 'AND post_approved = 1') . "

AND post_time > $topic_last_read

ORDER BY post_time ASC";

if (!$row)

{

$sql = 'SELECT topic_last_post_id as post_id, topic_id, forum_id

FROM ' . TOPICS_TABLE . '

WHERE topic_id = ' . $topic_id;

}

if (!$row)

$sql = 'SELECT forum_id, topic_last_post_time

FROM ' . TOPICS_TABLE . '

WHERE topic_id = ' . $topic_id;

if (!$row)

{

AND topic_last_post_time $sql_condition {$row['topic_last_post_time']}

" . ((phpbb::$acl->acl_get('m_approve', $row['forum_id'])) ? '' : 'AND topic_approved = 1') . "

ORDER BY topic_last_post_time $sql_ordering";

if (!$row)

{

// 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

phpbb::$db->sql_freeresult($result);

if (!$topic_data)

" . ((!phpbb::$acl->acl_get('m_approve', $forum_id)) ? 'AND p1.post_approved = 1' : '') . '

AND ' . (($sort_dir == 'd') ? 'p1.post_time >= p2.post_time' : 'p1.post_time <= p2.post_time');

$topic_data['prev_posts'] = $row['prev_posts'] - 1;

}

$sql = 'UPDATE ' . TOPICS_TABLE . '

SET topic_type = ' . POST_NORMAL . ', topic_time_limit = 0

WHERE topic_id = ' . $topic_id;

$topic_data['topic_type'] = POST_NORMAL;

$topic_data['topic_time_limit'] = 0;

WHERE topic_id = $topic_id

AND post_time >= $min_post_time

" . ((phpbb::$acl->acl_get('m_approve', $forum_id)) ? '' : 'AND post_approved = 1');

$limit_posts_time = "AND p.post_time >= $min_post_time ";

{

if (!$topic_data['bookmarked'])

{

'user_id' => phpbb::$user->data['user_id'],

'topic_id' => $topic_id,

));

}

else

{

$sql = 'DELETE FROM ' . BOOKMARKS_TABLE . '

WHERE user_id = ' . phpbb::$user->data['user_id'] . '

AND topic_id = ' . $topic_id;

}

$message = (($topic_data['bookmarked']) ? phpbb::$user->lang['BOOKMARK_REMOVED'] : phpbb::$user->lang['BOOKMARK_ADDED']) . '<br /><br />' . sprintf(phpbb::$user->lang['RETURN_TOPIC'], '<a href="' . $viewtopic_url . '">', '</a>');

}

AND p.post_id = {$topic_data['topic_first_post_id']}

AND p.topic_id = o.topic_id

ORDER BY o.poll_option_id";

$poll_info = array();

{

$poll_info[] = $row;

}

$cur_voted_id = array();

if (phpbb::$user->is_registered)

FROM ' . POLL_VOTES_TABLE . '

WHERE topic_id = ' . $topic_id . '

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

{

$cur_voted_id[] = $row['poll_option_id'];

}

}

else

{

SET poll_option_total = poll_option_total + 1

WHERE poll_option_id = ' . (int) $option . '

AND topic_id = ' . (int) $topic_id;

if (phpbb::$user->is_registered)

{

'vote_user_ip' => (string) phpbb::$user->ip,

);

}

}

SET poll_option_total = poll_option_total - 1

WHERE poll_option_id = ' . (int) $option . '

AND topic_id = ' . (int) $topic_id;

if (phpbb::$user->is_registered)

{

WHERE topic_id = ' . (int) $topic_id . '

AND poll_option_id = ' . (int) $option . '

AND vote_user_id = ' . (int) phpbb::$user->data['user_id'];

}

}

}

SET poll_last_vote = ' . time() . "

WHERE topic_id = $topic_id";

//, topic_last_post_time = ' . time() . " -- for bumping topics with new votes, ignore for now

$redirect_url = append_sid('viewtopic', "f=$forum_id&amp;t=$topic_id&amp;start=$start");

" . (($sort_by_sql[$sort_key][0] == 'u') ? 'AND u.user_id = p.poster_id': '') . "

$limit_posts_time

ORDER BY $sql_sort_order";

$i = ($store_reverse) ? $sql_limit - 1 : 0;

{

$post_list[$i] = $row['post_id'];

($store_reverse) ? $i-- : $i++;

// We need to grab it because we do reverse ordering sometimes

$max_post_time = 0;

'SELECT' => 'u.*, z.friend, z.foe, p.*',

'FROM' => array(

)

),

AND u.user_id = p.poster_id'

));

$now = getdate(time() + phpbb::$user->timezone + phpbb::$user->dst - date('Z'));

// Posts are stored in the $rowset array while $attach_list, $user_cache

// and the global bbcode_bitfield are built

{

// Set max_post_time

if ($row['post_time'] > $max_post_time)

{

$sql = 'SELECT session_user_id, MAX(session_time) as online_time, MIN(session_viewonline) AS viewonline

FROM ' . SESSIONS_TABLE . '

GROUP BY session_user_id';

$update_time = phpbb::$config['load_online_time'] * 60;

{

$user_cache[$row['session_user_id']]['online'] = (time() - $update_time < $row['online_time'] && (($row['viewonline']) || phpbb::$acl->acl_get('u_viewonline'))) ? true : false;

}

}

unset($id_cache);

{

$sql = 'SELECT *

FROM ' . ATTACHMENTS_TABLE . '

AND in_message = 0

ORDER BY filetime DESC, post_msg_id ASC';

{

$attachments[$row['post_msg_id']][] = $row;

}

// No attachments exist, but post table thinks they do so go ahead and reset post_attach flags

if (!sizeof($attachments))

{

$sql = 'UPDATE ' . POSTS_TABLE . '

SET post_attachment = 0

// We need to update the topic indicator too if the complete topic is now without an attachment

if (sizeof($rowset) != $total_posts)

WHERE p.topic_id = $topic_id

AND p.post_approved = 1

AND p.topic_id = a.topic_id";

if (!$row)

{

$sql = 'UPDATE ' . TOPICS_TABLE . "

SET topic_attachment = 0

WHERE topic_id = $topic_id";

}

}

else

$sql = 'UPDATE ' . TOPICS_TABLE . "

SET topic_attachment = 0

WHERE topic_id = $topic_id";

}

}

else if ($has_attachments && !$topic_data['topic_attachment'])

$sql = 'UPDATE ' . TOPICS_TABLE . "

SET topic_attachment = 1

WHERE topic_id = $topic_id";

$topic_data['topic_attachment'] = 1;

}

$sql = 'SELECT DISTINCT u.user_id, u.username, u.user_colour

FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u

AND p.post_edit_count <> 0

AND p.post_edit_user <> 0

AND p.post_edit_user = u.user_id';

{

$post_edit_list[$user_edit_row['user_id']] = $user_edit_row;

}

unset($post_storage_list);

}

$sql = 'UPDATE ' . TOPICS_TABLE . '

SET topic_views = topic_views + 1, topic_last_view_time = ' . time() . "

WHERE topic_id = $topic_id";

// Update the attachment download counts

if (sizeof($update_count))

{

$sql = 'UPDATE ' . ATTACHMENTS_TABLE . '

SET download_count = download_count + 1

}

}