//

// $Id$

//

// STARTED : Sat Feb 13, 2001

// COPYRIGHT : © 2001, 2003 phpBB Group

// WWW : http://www.phpbb.com/

// -------------------------------------------------------------

define('IN_PHPBB', true);

break;

default:

AND tt.topic_id = p.topic_id)';

$sql_unread_time = ' tt.mark_time OR tt.mark_time IS NULL';

}

}

$sql = 'SELECT p.post_id

$sql_lastread, " . TOPICS_TABLE . " t)

WHERE t.topic_id = $topic_id

AND (p.post_time > $sql_unread_time

OR p.post_id = t.topic_last_post_id)

ORDER BY p.post_time ASC";

FROM ' . TOPICS_TABLE . ' t, ' . TOPICS_TABLE . " t2

WHERE t2.topic_id = $topic_id

AND t.forum_id = t2.forum_id

AND t.topic_last_post_time $sql_condition t2.topic_last_post_time

ORDER BY t.topic_last_post_time $sql_ordering";

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

default:

$extra_fields .= ', tw.notify_status' . (($config['allow_bookmarks']) ? ', bm.order_id as bookmarked' : '');

AND t.topic_id = tw.topic_id)';

$join_sql_table .= ($config['allow_bookmarks']) ? ' LEFT JOIN ' . BOOKMARKS_TABLE . ' bm ON (bm.user_id = ' . $user->data['user_id'] . '

AND t.topic_id = bm.topic_id)' : '';

// Check sticky/announcement time limit

if (($topic_type == POST_STICKY || $topic_type == POST_ANNOUNCE) && $topic_time_limit && $topic_time + $topic_time_limit < time())

{

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

WHERE topic_id = ' . $topic_id;

$db->sql_query($sql);

}

else

{

WHERE user_id = {$user->data['user_id']}

AND topic_id = $topic_id";

$db->sql_query($sql);

// Works because of current order_id selected as bookmark value (please do not change because of simplicity)

$where_sql = " AND order_id > $bookmarked";

$sign = '-';

'TOPIC_TITLE' => $topic_title,

'PAGINATION' => $pagination,

'PAGE_NUMBER' => on_page($total_posts, $config['posts_per_page'], $start),

'U_MCP' => ($auth->acl_get('m_', $forum_id)) ? "mcp.$phpEx?sid=" . $user->session_id . "&amp;mode=topic_view&amp;f=$forum_id&amp;t=$topic_id&amp;start=$start&amp;$u_sort_param" : '',

'MODERATORS' => (isset($forum_moderators[$forum_id]) && sizeof($forum_moderators[$forum_id])) ? implode(', ', $forum_moderators[$forum_id]) : '',

'REPLY_IMG' => ($forum_status == ITEM_LOCKED || $topic_status == ITEM_LOCKED) ? $user->img('btn_locked', 'TOPIC_LOCKED') : $user->img('btn_reply', 'REPLY_TO_TOPIC'),

'EDIT_IMG' => $user->img('btn_edit', 'EDIT_POST'),

'DELETE_IMG' => $user->img('btn_delete', 'DELETE_POST'),

'SEARCH_IMG' => $user->img('btn_search', 'SEARCH_USER_POSTS'),

'PM_IMG' => $user->img('btn_pm', 'SEND_PRIVATE_MESSAGE'),

'EMAIL_IMG' => $user->img('btn_email', 'SEND_EMAIL'),

'S_SELECT_SORT_DAYS' => $s_limit_days,

'S_TOPIC_ACTION' => "viewtopic.$phpEx$SID&amp;f=$forum_id&amp;t=$topic_id&amp;start=$start",

'S_TOPIC_MOD' => ($topic_mod != '') ? '<select name="mode">' . $topic_mod . '</select>' : '',

'U_TOPIC' => "{$server_path}viewtopic.$phpEx?f=$forum_id&amp;t=$topic_id",

'U_FORUM' => $server_path,

'U_VIEW_OLDER_TOPIC' => "viewtopic.$phpEx$SID&amp;f=$forum_id&amp;t=$topic_id&amp;view=previous",

'U_VIEW_NEWER_TOPIC' => "viewtopic.$phpEx$SID&amp;f=$forum_id&amp;t=$topic_id&amp;view=next",

'U_PRINT_TOPIC' => ($auth->acl_get('f_print', $forum_id)) ? $viewtopic_url . '&amp;view=print' : '',

'U_BOOKMARK_TOPIC' => ($user->data['user_id'] != ANONYMOUS && $config['allow_bookmarks']) ? $viewtopic_url . '&amp;bookmark=1' : '',

'L_BOOKMARK_TOPIC' => ($user->data['user_id'] != ANONYMOUS && $config['allow_bookmarks'] && $bookmarked) ? $user->lang['BOOKMARK_TOPIC_REMOVE'] : $user->lang['BOOKMARK_TOPIC'],

'U_POST_NEW_TOPIC' => "posting.$phpEx$SID&amp;mode=post&amp;f=$forum_id",

'U_POST_REPLY_TOPIC' => "posting.$phpEx$SID&amp;mode=reply&amp;f=$forum_id&amp;t=$topic_id",

'U_BUMP_TOPIC' => (bump_topic_allowed($forum_id, $topic_bumped, $topic_last_post_time, $topic_poster, $topic_last_poster_id)) ? "posting.$phpEx$SID&amp;mode=bump&amp;f=$forum_id&amp;t=$topic_id" : '')

}

}

(($poll_length != 0 && $poll_start + $poll_length > time()) || $poll_length == 0) &&

$forum_status != ITEM_LOCKED) ? true : false;

$s_display_results = (!$s_can_vote || ($s_can_vote && $voted_id) || $view == 'viewpoll') ? true : false;

continue;

}

AND topic_id = $topic_id";

$db->sql_query($sql);

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

{

VALUES ($topic_id, $option, " . $user->data['user_id'] . ", '$user->ip')";

$db->sql_query($sql);

}

{

if (!in_array($option, $voted_id))

{

AND topic_id = $topic_id";

$db->sql_query($sql);

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

{

WHERE topic_id = $topic_id

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

$db->sql_query($sql);

}

$user->set_cookie('poll_' . $topic_id, implode(',', $voted_id), time() + 31536000);

}

WHERE topic_id = $topic_id";

$db->sql_query($sql);

'POLL_OPTION_CAPTION' => $poll_option['poll_option_text'],

'POLL_OPTION_RESULT' => $poll_option['poll_option_total'],

'POLL_OPTION_PERCENT' => $option_pct_txt,

'POLL_OPTION_VOTED' => (in_array($poll_option['poll_option_id'], $cur_voted_id)) ? true : false)

);

}

'POLL_LEFT_CAP_IMG' => $user->img('poll_left'),

'POLL_RIGHT_CAP_IMG'=> $user->img('poll_right'),

'S_DISPLAY_RESULTS' => $s_display_results,

'S_POLL_ACTION' => $viewtopic_url,

'U_VIEW_RESULTS' => $viewtopic_url . '&amp;view=viewpoll')

}

$sql = 'SELECT u.username, u.user_id, u.user_colour, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_jabber, u.user_regdate, u.user_msnm, u.user_allow_viewemail, u.user_allow_viewonline, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_sig_bbcode_bitfield, u.user_avatar, u.user_avatar_type, u.user_avatar_width, u.user_avatar_height, z.friend, z.foe, p.*

WHERE p.post_id IN (' . implode(', ', $post_list) . ')

AND u.user_id = p.poster_id';

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

{

$rowset[$row['post_id']] = array(

'foe' => true,

'poster' => $poster,

);

if ($row['post_attachment'] && $config['allow_attachments'])

{

$attach_list[] = $row['post_id'];

if ($row['post_approved'])

{

$has_attachments = TRUE;

'bbcode_bitfield' => $row['bbcode_bitfield'],

'enable_html' => $row['enable_html'],

'enable_smilies' => $row['enable_smilies'],

);

// Define the global bbcode bitfield, will be used to load bbcodes

'sig_bbcode_uid' => (!empty($row['user_sig_bbcode_uid'])) ? $row['user_sig_bbcode_uid'] : '',

'sig_bbcode_bitfield' => (!empty($row['user_sig_bbcode_bitfield'])) ? $row['user_sig_bbcode_bitfield'] : '',

'avatar' => '',

// Generate online information for user

if ($config['load_onlinetrack'] && sizeof($id_cache))

{

WHERE session_user_id IN (' . implode(', ', $id_cache) . ')

GROUP BY session_user_id';

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

{

include($phpbb_root_path . 'includes/functions_display.' . $phpEx);

FROM ' . ATTACHMENTS_TABLE . '

WHERE post_msg_id IN (' . implode(', ', $attach_list) . ')

AND in_message = 0

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

if (!sizeof($attachments))

{

WHERE post_id IN (' . implode(', ', $attach_list) . ')';

$db->sql_query($sql);

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

{

WHERE topic_id = $topic_id";

$db->sql_query($sql);

}

}

else

{

WHERE topic_id = $topic_id";

$db->sql_query($sql);

}

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

{

// Topic has approved attachments but its flag is wrong

WHERE topic_id = $topic_id";

$db->sql_query($sql);

if (isset($row['foe']) && $row['foe'])

{

$template->assign_block_vars('postrow', array(

'L_IGNORE_POST' => sprintf($user->lang['POST_BY_FOE'], $row['poster'], "<a href=\"viewtopic.$phpEx$SID&amp;f=$forum_id&amp;p=" . $row['post_id'] . '&amp;view=show#' . $row['post_id'] . '">', '</a>'))

);

else

{

$template->assign_block_vars('postrow', array(

'L_IGNORE_POST' => sprintf($user->lang['POST_ENCODING'], $row['poster'], '<a href="viewtopic.' . $phpEx . $SID . '&amp;p=' . $row['post_id'] . '&amp;view=encoding#' . $row['post_id'] . '">', '</a>'))

);

// Remove all post_ids already parsed (we do not have to check them)

$post_storage_list = array_slice($post_list, $i);

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

WHERE p.post_id IN (' . implode(', ', $post_storage_list) . ")

AND p.post_edit_count <> 0

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

}

$db->sql_freeresult($result2);

unset($post_storage_list);

}

$l_edit_time_total = ($row['post_edit_count'] == 1) ? $user->lang['EDITED_TIME_TOTAL'] : $user->lang['EDITED_TIMES_TOTAL'];

// Bump information

if ($topic_bumped && $row['post_id'] == $topic_last_post_id)

{

// post and only the topic poster and last poster are allowed to bump

$l_bumped_by = '<br /><br />' . sprintf($user->lang['BUMPED_BY'], $user_cache[$topic_bumper]['username'], $user->format_date($topic_last_post_time));

}

{

// Flip index if we are displaying the reverse way

$index = ($config['display_order']) ? ($tpl_size-($matches[1][$num] + 1)) : $matches[1][$num];

$replace['from'][] = $matches[0][$index];

$replace['to'][] = (isset($tpl[$index])) ? $tpl[$index] : sprintf($user->lang['MISSING_INLINE_ATTACHMENT'], $matches[2][$num]);

if (isset($replace['from']))

{

$message = str_replace($replace['from'], $replace['to'], $message);

foreach (array_unique($unset_tpl) as $index)

{

unset($attachments[$row['post_id']][$index]);

'MINI_POST_IMG' => ($user->data['user_id'] != ANONYMOUS && $row['post_time'] > $user->data['user_lastvisit'] && $row['post_time'] > $topic_last_read) ? $user->img('icon_post_new', 'NEW_POST') : $user->img('icon_post', 'POST'),

'POST_ICON_IMG' => (!empty($row['icon_id'])) ? '<img src="' . $config['icons_path'] . '/' . $icons[$row['icon_id']]['img'] . '" width="' . $icons[$row['icon_id']]['width'] . '" height="' . $icons[$row['icon_id']]['height'] . '" alt="" title="" />' : '',

'ICQ_STATUS_IMG' => $user_cache[$poster_id]['icq_status_img'],

'U_EDIT' => (($user->data['user_id'] == $poster_id && $auth->acl_get('f_edit', $forum_id) && ($row['post_time'] > time() - $config['edit_time'] || !$config['edit_time'])) || $auth->acl_get('m_edit', $forum_id)) ? "posting.$phpEx$SID&amp;mode=edit&amp;f=$forum_id&amp;p=" . $row['post_id'] : '',

'U_DELETE' => (($user->data['user_id'] == $poster_id && $auth->acl_get('f_delete', $forum_id) && $topic_data['topic_last_post_id'] == $row['post_id'] && ($row['post_time'] > time() - $config['edit_time'] || !$config['edit_time'])) || $auth->acl_get('m_delete', $forum_id)) ? "posting.$phpEx$SID&amp;mode=delete&amp;f=$forum_id&amp;p=" . $row['post_id'] : '',

'U_PROFILE' => $user_cache[$poster_id]['profile'],

'U_AIM' => $user_cache[$poster_id]['aim'],

'U_MSN' => $user_cache[$poster_id]['msn'],

'U_YIM' => $user_cache[$poster_id]['yim'],

'U_REPORT' => "report.$phpEx$SID&amp;p=" . $row['post_id'],

'U_MCP_REPORT' => ($auth->acl_gets('m_', 'a_', 'f_report', $forum_id)) ? "mcp.$phpEx$SID&amp;mode=post_details&amp;p=" . $row['post_id'] : '',

'U_MCP_APPROVE' => ($auth->acl_get('m_approve', $forum_id)) ? "mcp.$phpEx$SID&amp;i=queue&amp;mode=approve&amp;post_id_list[]=" . $row['post_id'] : '',

'U_MINI_POST' => "viewtopic.$phpEx$SID&amp;p=" . $row['post_id'] . '#' . $row['post_id'],

'U_POST_ID' => ($unread_post_id == $row['post_id']) ? 'unread' : $row['post_id'],

'POST_ID' => $row['post_id'],

'S_HAS_ATTACHMENTS' => (!empty($attachments[$row['post_id']])) ? TRUE : FALSE,

'S_POST_UNAPPROVED' => ($row['post_approved']) ? FALSE : TRUE,

'S_POST_REPORTED' => ($row['post_reported'] && $auth->acl_get('m_', $forum_id)) ? TRUE : FALSE,

'S_FRIEND' => ($row['friend']) ? true : false

);

}*/

$template->assign_block_vars('postrow', $postrow);

// Display not already displayed Attachments for this post, we already parsed them. ;)

if (isset($attachments[$row['post_id']]) && sizeof($attachments[$row['post_id']]))

{

// Update the attachment download counts

if (sizeof($update_count))

{

WHERE attach_id IN (' . implode(', ', array_unique($update_count)) . ')';

$db->sql_query($sql);

}