define('POST_NORMAL', 0);

define('POST_STICKY', 1);

define('POST_ANNOUNCE', 2);

// Lastread types

define('TRACK_NORMAL', 0); // not used at the moment

*

***************************************************************************/

function generate_smilies($mode)

{

global $SID, $auth, $db, $user, $config, $template;

}

}

// Format text to be displayed - from viewtopic.php - centralizing this would be nice ;)

function format_display($message, $html, $bbcode, $uid, $url, $smilies, $sig)

{

global $auth, $forum_id, $config, $censors, $user, $bbcode, $phpbb_root_path;

{

$message = preg_replace('#(<)([\/]?.*?)(>)#is', "&lt;\\2&gt;", $message);

}

// Second parse bbcode here

$message = $bbcode->bbcode_second_pass($message, $uid);

$message = (empty($smilies) || empty($config['allow_smilies'])) ? preg_replace('#<!\-\- s(.*?) \-\-><img src="\{SMILE_PATH\}\/.*? \/><!\-\- s\1 \-\->#', '\1', $message) : str_replace('<img src="{SMILE_PATH}', '<img src="' . $phpbb_root_path . $config['smilies_path'], $message);

// Replace naughty words such as farty pants

if ($user_sig != '' && $auth->acl_get('f_sigs', $forum_id))

{

{

$user_sig = preg_replace('#(<)([\/]?.*?)(>)#is', "&lt;\\2&gt;", $user_sig);

}

if (sizeof($censors))

{

$user_sig = str_replace('\"', '"', substr(preg_replace('#(\>(((?>([^><]+|(?R)))*)\<))#se', "preg_replace(\$censors['match'], \$censors['replace'], '\\0')", '>' . $user_sig . '<'), 1, -1));

}

}

else

{

$user_sig = '';

}

$message .= $user_sig;

return $message;

return;

}

WHERE p.post_approved = 1

AND t.topic_approved = 1

AND p.poster_id = u.user_id

if (!is_array($attach_id_array))

{

}

// Get the post_ids to fill the array

GROUP BY id';

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

{

}

{

}

}

if (!is_array($post_id_array))

return;

}

}

if (!count($post_id_array))

GROUP BY attach_id';

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

{

}

{

}

}

if (!is_array($attach_id_array))

{

}

if (!count($attach_id_array))

return;

}

if ($page == 'privmsgs')

{

$sql_id = 'privmsgs_id';

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

{

{

case PRIVMSGS_READ_MAIL:

case PRIVMSGS_NEW_MAIL:

$sql_id = 'post_id';

}

$db->sql_query($sql);

foreach ($attach_id_array as $attach_id)

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

{

phpbb_unlink($row['physical_filename'], 'file', $config['use_ftp_upload']);

{

phpbb_unlink($row['physical_filename'], 'thumbnail', $config['use_ftp_upload']);

}

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

{

$sql = 'SELECT post_id

FROM ' . POSTS_TABLE . "

while ($post_row = $db->sql_fetchrow($result2))

{

}

$db->sql_freeresult($result2);

// Upload Attachment - filedata is generated here

function upload_attachment($filename)

{

$filedata = array();

$filedata['error'] = array();

$cat_id = $extensions[$filedata['extension']]['display_cat'];

// check Filename

{

$filedata['error'][] = sprintf($user->lang['INVALID_FILENAME'], $filename);

$filedata['post_attach'] = FALSE;

{

list($width, $height) = getimagesize($file);

{

{

$filedata['post_attach'] = false;

return $filedata;

}

return $deleted;

}

// Read DWord (4 Bytes) from File

function read_dword($fp)

{

}

// Try to get the Dimension manually, depending on the mimetype

{

return $size;

}

$used_imagick = FALSE;

{

if (is_array($size) && count($size) > 0)

{

if (file_exists($new_file))

{

$used_imagick = TRUE;

}

?> \ No newline at end of file

{

case 'front':

{

}

else

{

}

$i = 0;

$topic_type = $user->lang['VIEW_TOPIC_ANNOUNCEMENT'];

$folder = 'folder_announce';

$folder_new = $folder . '_new';

$sql = "SELECT t.* $sql_select

WHERE t.forum_id = 0

ORDER BY t.topic_last_post_time DESC';

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

{

$folder_new = 'folder_locked_new';

}

{

}

}

$newest_post_img = ($unread_topic) ? "<a href=\"viewtopic.$phpEx$SID&amp;f=$forum_id&amp;t=$topic_id&amp;view=unread\">" . $user->img('icon_post_newest', 'VIEW_NEWEST_POST') . '</a> ' : '';

$view_topic_url = "viewtopic.$phpEx$SID&amp;f=$forum_id&amp;t=$topic_id";

$last_post_author = ($row['topic_last_poster_id'] == ANONYMOUS) ? (($row['topic_last_poster_name'] != '') ? $row['topic_last_poster_name'] . ' ' : $user->lang['GUEST'] . ' ') : "<a href=\"memberlist.$phpEx$SID&amp;mode=viewprofile&amp;u=" . $row['topic_last_poster_id'] . '">' . $row['topic_last_poster_name'] . '</a>';

break;

default:

break;

}

$lastread_select = ', ft.mark_time ';

}

else

{

}

$sql = "SELECT f.*$lastread_select

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

AND f.forum_id = fw.forum_id

ORDER BY left_id';

$forum_id = $row['forum_id'];

$unread_forum = false;

if ($forum_check < $row['forum_last_post_time'])

{

$unread_topic = ($user->data['user_id'] != ANONYMOUS) ? true : false;

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

{

if ($topic_check > $row['topic_last_post_time'] || $forum_check > $row['topic_last_post_time'])

{

$folder_img .= '_posted';

}

{

$goto_page = ' [ ' . $user->img('icon_post', 'GOTO_PAGE') . $user->lang['GOTO_PAGE'] . ': ';

$times = 1;

{

$goto_page .= "<a href=\"viewtopic.$phpEx$SID&amp;f=$forum_id&amp;t=$topic_id&amp;start=$j\">$times</a>";

if ($times == 1 && $total_pages > 4)

{

$goto_page .= ' ... ';

$times = $total_pages - 3;

}

else if ($times < $total_pages)

{

poll_last_vote int(11),

PRIMARY KEY (topic_id),

KEY forum_id (forum_id),

KEY topic_last_post_time (topic_last_post_time),

);

# Table: 'phpbb_topic_marking'

INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_poll', 1);

INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_vote', 1);

INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_votechg', 1);

INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_announce', 1);

INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_sticky', 1);

INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_attach', 1);

'POST_STICKY' => 'Sticky',

'POST_FORUM_LOCKED' => 'Forum is locked',

'POST_TOPIC_LOCKED' => 'Topic is locked',

'VIEW_TOPIC_POSTS' => '%d Posts',

'MESSAGE_BODY' => 'Message body',

'MESSAGE_BODY_EXPLAIN' => 'Enter your message here, it may contain no more than <b>%d</b> characters.',

'LOCK_POST' => 'Lock Post',

'LOCK_POST_EXPLAIN' => 'Prevent editing',

'No_such_post' => 'There is no such post, please return and try again',

'ADD_POLL' => 'Add a Poll',

'POLL_QUESTION' => 'Poll question',

'POLL_OPTIONS' => 'Poll options',

'POLL_OPTIONS_EXPLAIN' => 'Place each option on a new line. You may enter up to <b>%d</b> options',

'POLL_MAX_OPTIONS' => 'Options per user',

'POLL_MAX_OPTIONS_EXPLAIN' => 'This is the number of options each user may select when voting.',

'POLL_FOR' => 'Run poll for',

'DISABLE_MAGIC_URL' => 'Do not automatically parse URLs',

'POST_STORED_MOD' => 'Your message has been saved but requires approval',

'Topic_reply_notification' => 'Topic Reply Notification',

'TOO_FEW_POLL_OPTIONS' => 'You must enter at least two poll options',

'UCP' => 'User Control Panel',

'UCP_OPTIONS' => 'Options',

'UCP_MAIN' => 'Overview',

'UCP_FRONT' => 'Front page',

switch ($mode)

{

case 'make_global':

case 'make_announce':

$set_sql = 'topic_type = ' . POST_ANNOUNCE;

case 'make_sticky':

$set_sql = 'topic_type = ' . POST_STICKY;

case 'make_normal':

$set_sql = 'topic_type = ' . POST_NORMAL;

}

if ($topic_info['forum_id'] == 0 && $mode != 'make_global')

{

*

***************************************************************************/

define('IN_PHPBB', true);

$phpbb_root_path = './';

include($phpbb_root_path . 'extension.inc');

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

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

// Start session management

$user->start();

$auth->acl($user->data);

$user->setup();

// Grab only parameters needed here

$mode = (!empty($_REQUEST['mode'])) ? strval($_REQUEST['mode']) : '';

$post_id = (!empty($_REQUEST['p'])) ? intval($_REQUEST['p']) : false;

$forum_validate = $topic_validate = $post_validate = false;

// Easier validation

$sql = '';

switch ($mode)

$sql = 'SELECT t.*, f.*

FROM ' . TOPICS_TABLE . ' t, ' . FORUMS_TABLE . " f

WHERE t.topic_id = $topic_id

$forum_validate = $topic_validate = true;

break;

WHERE p.post_id = $post_id

AND t.topic_id = p.topic_id

AND u.user_id = p.poster_id

$forum_validate = $topic_validate = $post_validate = true;

break;

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

}

break;

case 'smilies':

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

}

if ($sql != '')

{

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

$postrow = $row;

$quote_username = (!empty($row['username'])) ? $row['username'] : $row['post_username'];

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

{

login_forum_box($row);

}

{

{

}

}

$post_subject = ($post_validate) ? $post_subject : $topic_title;

$poll_length = ($poll_length) ? $poll_length/3600 : $poll_length;

$poll_options = array();

$db->sql_freeresult($result);

}

$message_parser->filename_data['filecomment'] = (isset($_POST['filecomment'])) ? trim(strip_tags($_POST['filecomment'])) : '';

$message_parser->filename_data['filename'] = ($_FILES['fileupload']['name'] != 'none') ? trim($_FILES['fileupload']['name']) : '';

$db->sql_freeresult($result);

}

if ($poster_id == ANONYMOUS || !$poster_id)

{

$username = ($post_validate) ? trim($post_username) : '';

$enable_urls = $enable_magic_url;

if (!$post_validate)

{

$enable_urls = true;

}

$enable_magic_url = false;

}

// Notify user checkbox

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

{

$notify_set = -1;

}

if (!$auth->acl_get('f_' . $mode, $forum_id) && $forum_type == FORUM_POST)

{

trigger_error($user->lang['USER_CANNOT_' . strtoupper($mode)]);

}

// Forum/Topic locked?

if (($forum_status == ITEM_LOCKED || $topic_status == ITEM_LOCKED) && !$auth->acl_get('m_edit', $forum_id))

{

trigger_error($user->lang[$message]);

}

// Can we edit this post?

if (($mode == 'edit' || $mode == 'delete') && !$auth->acl_get('m_edit', $forum_id) && $config['edit_time'] && $post_time < time() - $config['edit_time'])

{

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

}

// Do we want to edit our post ?

if ($mode == 'edit' && !$auth->acl_get('m_edit', $forum_id) && $user->data['user_id'] != $poster_id)

{

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

}

// Is edit posting locked ?

if ($mode == 'edit' && $post_edit_locked && !$auth->acl_get('m_', $forum_id))

{

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

}

if ($mode == 'edit')

{

$message_parser->bbcode_uid = $row['bbcode_uid'];

}

// Delete triggered ?

if ($mode == 'delete' && (($poster_id == $user->data['user_id'] && $user->data['user_id'] != ANONYMOUS && $auth->acl_get('f_delete', $forum_id) && $post_id == $topic_last_post_id) || $auth->acl_get('m_delete', $forum_id)))

{

if ($post_data['topic_first_post_id'] != $post_data['topic_last_post_id'] && $post_id == $post_data['topic_first_post_id'])

{

$topic_sql = array(

'topic_first_poster_name' => ($row['poster_id'] == ANONYMOUS) ? trim($row['post_username']) : trim($row['username'])

);

}

$db->sql_transaction('commit');

if ($post_data['topic_first_post_id'] == $post_data['topic_last_post_id'])

{

$meta_info = "viewforum.$phpEx$SID&amp;f=$forum_id";

'MESSAGE_TITLE' => $user->lang['DELETE_MESSAGE'],

'MESSAGE_TEXT' => $user->lang['CONFIRM_DELETE'],

'S_HIDDEN_FIELDS' => $s_hidden_fields)

);

}

}

if ($mode == 'delete' && $poster_id != $user->data['user_id'] && !$auth->acl_get('f_delete', $forum_id))

{

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

}

if ($mode == 'delete' && $poster_id == $user->data['user_id'] && $auth->acl_get('f_delete', $forum_id) && $post_id != $topic_last_post_id)

{

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

}

if ($mode == 'delete')

{

trigger_error('USER_CANNOT_DELETE');

}

// HTML, BBCode, Smilies, Images and Flash status

if ($submit || $preview || $refresh)

{

$message_parser->message = (!empty($_POST['message'])) ? trim(stripslashes($_POST['message'])) : '';

$username = (!empty($_POST['username'])) ? trim($_POST['username']) : '';

$icon_id = (!empty($_POST['icon'])) ? intval($_POST['icon']) : 0;

$enable_html = (!$html_status || !empty($_POST['disable_html'])) ? FALSE : TRUE;

$poll_delete = (isset($_POST['poll_delete'])) ? true : false;

// Faster than crc32

$check_value = (($enable_html+1) << 16) + (($enable_bbcode+1) << 8) + (($enable_smilies+1) << 4) + (($enable_urls+1) << 2) + (($enable_sig+1) << 1);

$status_switch = (isset($_POST['status_switch']) && intval($_POST['status_switch']) != $check_value) ? true : false;

if ($poll_delete && (($mode == 'edit' && !empty($poll_options) && empty($poll_last_vote) && $poster_id == $user->data['user_id'] && $auth->acl_get('f_delete', $forum_id)) || $auth->acl_get('m_delete', $forum_id)))

{

// Delete Poll

$poll_max_options = (!empty($_POST['poll_max_options'])) ? intval($_POST['poll_max_options']) : 1;

}

$current_time = time();

// If replying/quoting and last post id has changed

// Parse message

if ($result = $message_parser->parse($enable_html, $enable_bbcode, $enable_urls, $enable_smilies, $img_status, $flash_status))

{

}

}

if (count($result))

{

}

if ($mode != 'edit' && !$preview && !$refresh && !$auth->acl_get('f_ignoreflood', $forum_id))

{

if (intval($row['last_post_time']) && ($current_time - intval($row['last_post_time'])) < intval($config['flood_interval']))

{

}

}

}

// Validate username

if (($username != '' && $user->data['user_id'] == ANONYMOUS) || ($mode == 'edit' && $post_username != ''))

{

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

if (($result = $ucp->validate_username($username)) != false)

{

}

}

// Parse subject

if ($subject == '' && ($mode == 'post' || ($mode == 'edit' && $topic_first_post_id == $post_id)))

{

}

$poll_data = array(

$poll = array();

if (($result = $message_parser->parse_poll($poll, $poll_data)) != '')

{

}

$poll_options = $poll['poll_options'];

// Check topic type

if ($topic_type != POST_NORMAL)

{

switch ($topic_type)

{

case POST_GLOBAL:

case POST_ANNOUNCE:

break;

case POST_STICKY:

break;

}

{

}

}

// Store message, sync counters

{

// Lock/Unlock Topic

$change_topic_status = $topic_status;

'post_edit_locked' => $post_edit_locked,

'bbcode_bitfield' => $message_parser->bbcode_bitfield

);

submit_post($mode, $message_parser->message, $subject, $username, $topic_type, $message_parser->bbcode_uid, $poll, $message_parser->attachment_data, $message_parser->filename_data, $post_data);

}

}

// Preview

{

if (empty($censors))

{

$post_time = $current_time;

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

$bbcode = new bbcode($message_parser->bbcode_bitfield);

$preview_message = format_display($message_parser->message, $enable_html, $enable_bbcode, $message_parser->bbcode_uid, $enable_urls, $enable_smilies, $enable_sig);

$preview_subject = (sizeof($censors)) ? preg_replace($censors['match'], $censors['replace'], $subject) : $subject;

// Poll Preview

{

decode_text($poll_title, $message_parser->bbcode_uid);

$preview_poll_title = format_display(stripslashes($poll_title), $enable_html, $enable_bbcode, $message_parser->bbcode_uid, $enable_urls, $enable_smilies, false, false);

}

}

// Attachment Preview

if (sizeof($message_parser->attachment_data))

{

}

}

// Decode text for message display

$bbcode_uid = ($mode == 'quote' && !$preview) ? $row['bbcode_uid'] : $message_parser->bbcode_uid;

decode_text($post_text, $bbcode_uid);

if ($subject)

{

decode_text($subject, $bbcode_uid);

}

// Save us some processing time. ;)

if (count($poll_options))

{

$poll_options = explode("\n", $poll_options_tmp);

}

if ($mode == 'quote' && !$preview && !$refresh)

{

$post_text = '[quote="' . $quote_username . '"]' . trim($post_text) . "[/quote]\n";

}

if (($mode == 'reply' || $mode == 'quote') && !$preview && !$refresh)

{

$post_subject = ((!preg_match('/^Re:/', $post_subject)) ? 'Re: ' : '') . $post_subject;

}

// MAIN POSTING PAGE BEGINS HERE

// Forum moderators?

get_moderators($moderators, $forum_id);

// Generate smilies and topic icon listings

generate_smilies('inline');

// Generate Topic icons

$s_topic_icons = false;

if ($enable_icons)

{

$topic_types = array(

'sticky' => array('const' => POST_STICKY, 'lang' => 'POST_STICKY'),

);

foreach ($topic_types as $auth_key => $topic_value)

if ($auth->acl_get('f_' . $auth_key, $forum_id))

{

$topic_type_toggle .= '<input type="radio" name="topic_type" value="' . $topic_value['const'] . '"';

{

$topic_type_toggle .= ' checked="checked"';

}

'MODERATORS' => (sizeof($moderators)) ? implode(', ', $moderators[$forum_id]) : '',

'USERNAME' => (((!$preview) && ($mode != 'quote')) || ($preview)) ? stripslashes($username) : '',

'SUBJECT' => $post_subject,

'MESSAGE' => trim($post_text),

'HTML_STATUS' => ($html_status) ? $user->lang['HTML_IS_ON'] : $user->lang['HTML_IS_OFF'],

'BBCODE_STATUS' => ($bbcode_status) ? sprintf($user->lang['BBCODE_IS_ON'], '<a href="' . "faq.$phpEx$SID&amp;mode=bbcode" . '" target="_phpbbcode">', '</a>') : sprintf($user->lang['BBCODE_IS_OFF'], '<a href="' . "faq.$phpEx$SID&amp;mode=bbcode" . '" target="_phpbbcode">', '</a>'),

'IMG_STATUS' => ($img_status) ? $user->lang['IMAGES_ARE_ON'] : $user->lang['IMAGES_ARE_OFF'],

'SMILIES_STATUS' => ($smilies_status) ? $user->lang['SMILIES_ARE_ON'] : $user->lang['SMILIES_ARE_OFF'],

'MINI_POST_IMG' => $user->img('icon_post', $user->lang['POST']),

'POST_DATE' => ($post_time) ? $user->format_date($post_time) : '',

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

'U_VIEWTOPIC' => ($mode != 'post') ? "viewtopic.$phpEx$SID&amp;$forum_id&amp;t=$topic_id" : '',

'U_REVIEW_TOPIC' => ($mode != 'post') ? "posting.$phpEx$SID&amp;mode=topicreview&amp;f=$forum_id&amp;t=$topic_id" : '',

'S_DISPLAY_REVIEW' => ($mode == 'reply' || $mode == 'quote') ? true : false,

'S_DISPLAY_USERNAME' => ($user->data['user_id'] == ANONYMOUS || ($mode == 'edit' && $post_username)) ? true : false,

'S_SHOW_TOPIC_ICONS' => $s_topic_icons,

// Topic review

if ($mode == 'reply' || $mode == 'quote')

{

}

page_footer();

// FUNCTIONS

// Topic Review

{

global $template;

$sql = 'SELECT t.topic_title, f.forum_id

FROM ' . TOPICS_TABLE . ' t, ' . FORUMS_TABLE . " f

WHERE t.topic_id = $topic_id

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

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

return $new_string;

}

?> \ No newline at end of file

$sql = 'SELECT COUNT(topic_id) AS num_topics

FROM ' . TOPICS_TABLE . "

WHERE forum_id = $forum_id

" . (($auth->acl_get('m_approve', $forum_id)) ? '' : 'AND t.topic_approved = 1');

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

$total_topics = 0;

$row_ary = array();

switch (SQL_LAYER)

{

case 'oracle':

$sql = "SELECT t.* $sql_select

FROM $sql_from

WHERE t.forum_id IN ($forum_id, 0)

ORDER BY $sql_sort_order";

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

{

{

$topic_id = $row['topic_id'];

if ($config['load_db_lastread'])

{

$mark_time_topic = $row['mark_time'];

else

{

$topic_id36 = base_convert($topic_id, 10, 36);

}

// Goto message generation

{

$goto_page = ' [ ' . $user->img('icon_post', 'GOTO_PAGE') . $user->lang['GOTO_PAGE'] . ': ';

$times = 1;

{

$goto_page .= "<a href=\"viewtopic.$phpEx$SID&amp;f=$forum_id&amp;t=$topic_id&amp;start=$j\">$times</a>";

if ($times == 1 && $total_pages > 4)

{

$goto_page .= ' ... ';

$times = $total_pages - 3;

}

else if ($times < $total_pages)

{

$last_post_author = ($row['topic_last_poster_id'] == ANONYMOUS) ? (($row['topic_last_poster_name'] != '') ? $row['topic_last_poster_name'] . ' ' : $user->lang['GUEST'] . ' ') : "<a href=\"memberlist.$phpEx$SID&amp;mode=viewprofile&amp;u=" . $row['topic_last_poster_id'] . '">' . $row['topic_last_poster_name'] . '</a>';

// This will allow the style designer to output a different header

// or even seperate the list of announcements from sticky and normal

// topics

// Send vars to template

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

'FORUM_ID' => $forum_id,

'TOPIC_ID' => $topic_id,

'TOPIC_AUTHOR' => $topic_author,

'LAST_POST_AUTHOR' => $last_post_author,

'GOTO_PAGE' => $goto_page,

'REPLIES' => ($auth->acl_get('m_approve')) ? $row['topic_replies_real'] : $row['topic_replies'],

'VIEWS' => $row['topic_views'],

'S_TOPIC_TYPE' => $row['topic_type'],

'S_USER_POSTED' => (!empty($row['mark_type'])) ? true : false,

'S_TOPIC_UNAPPROVED' => (!$row['topic_approved'] && $auth->acl_gets('m_approve', $forum_id)) ? TRUE : FALSE,

'U_VIEW_TOPIC' => $view_topic_url)

);

$i++;

}

// This rather complex gaggle of code handles querying for topics but

// also allows for direct linking to a post (and the calculation of which

// page the post is on and the correct display of viewtopic)

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

$sql = 'SELECT t.topic_id, t.forum_id AS real_forum_id, t.topic_title, t.topic_attachment, t.topic_status, ' . (($auth->acl_get('m_approve')) ? 't.topic_replies_real AS topic_replies' : 't.topic_replies') . ', t.topic_last_post_id, t.topic_time, t.topic_type, t.poll_max_options, t.poll_start, t.poll_length, t.poll_title, f.forum_name, f.forum_desc, f.forum_parents, f.parent_id, f.left_id, f.right_id, f.forum_status, f.forum_id, f.forum_style, f.forum_password' . $extra_fields . '

FROM ' . TOPICS_TABLE . ' t, ' . FORUMS_TABLE . ' f' . $join_sql_table . "

WHERE $join_sql

$order_sql";

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

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

{

trigger_error('NO_TOPIC');

// Extract the data

extract($topic_data);

// Start auth check

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

{

login_box(preg_replace('#.*?([a-z]+?\.' . $phpEx . '.*?)$#i', '\1', htmlspecialchars($_SERVER['REQUEST_URI'])), '', $user->lang['LOGIN_VIEWFORUM']);

}

// What is start equal to?

if (!empty($post_id))

// Quick mod tools

$topic_mod = '';

$topic_mod .= ($auth->acl_get('m_delete', $forum_id)) ? '<option value="delete_topic">' . $user->lang['DELETE_TOPIC'] . '</option>' : '';

$topic_mod .= ($auth->acl_get('m_move', $forum_id)) ? '<option value="move">' . $user->lang['MOVE_TOPIC'] . '</option>' : '';

$topic_mod .= ($auth->acl_get('m_split', $forum_id)) ? '<option value="split">' . $user->lang['SPLIT_TOPIC'] . '</option>' : '';

'FORUM_DESC' => strip_tags($forum_desc),

'TOPIC_ID' => $topic_id,

'TOPIC_TITLE' => $topic_title,

'TOTAL_POSTS' => ($total_posts == 1) ? $user->lang['VIEW_TOPIC_POST'] : sprintf($user->lang['VIEW_TOPIC_POSTS'], $total_posts),

'MCP' => ($auth->acl_get('m_', $forum_id)) ? sprintf($user->lang['MCP'], "<a href=\"mcp.$phpEx?sid=" . $user->session_id . "&amp;f=$forum_id&amp;t=$topic_id&amp;start=$start&amp;$u_sort_param&amp;posts_per_page=" . $config['posts_per_page'] . '">', '</a>') : '',

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

$limit_posts_time

AND u.user_id = p.poster_id

ORDER BY $sort_order";

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

{

}

$rowset[] = array(

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

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

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

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

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

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

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

);

if ($poster_id == ANONYMOUS)

{

$user_cache[$poster_id] = array(

'posts' => '',

'from' => '',

'rank_image' => '',

'posts' => '',

'email' => '',

'www' => '',

'icq_status_img'=> '',

'msn' => '',

);

}

else

}

}

if ($bbcode_bitfield)

{

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

$bbcode = new bbcode($bbcode_bitfield);

}

foreach ($rowset as $i => $row)

{

$poster_id = $row['user_id'];

'SIGNATURE' => ($row['enable_sig']) ? $user_cache[$poster_id]['sig'] : '',

'EDITED_MESSAGE'=> $l_edited_by,

'MINI_POST_IMG' => ($row['post_time'] > $user->data['user_lastvisit'] && $row['post_time'] > $topic_last_read && $user->data['user_id'] != ANONYMOUS) ? $user->img('icon_post_new', $user->lang['NEW_POST']) : $user->img('icon_post', $user->lang['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'],

'KARMA_IMG' => $user_cache[$poster_id]['karma_img'],

'U_QUOTE' => ($auth->acl_get('f_quote', $forum_id)) ? "posting.$phpEx$SID&amp;mode=quote&amp;f=$forum_id&amp;p=" . $row['post_id'] : '',

'U_IP' => ($auth->acl_get('m_ip', $forum_id)) ? "mcp.$phpEx?sid=" . $user->session_id . "&amp;mode=post_details&amp;p=" . $row['post_id'] . "&amp;t=$topic_id#ip" : '',

'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;p=" . $row['post_id'] : '',

unset($user_cache);

// Update topic view and if necessary attachment view counters ... but only

// if this is the first 'page view'

if (!preg_match("#&t=$topic_id#", $user->data['session_page']))

{

WHERE topic_id = $topic_id";

$db->sql_query($sql);

// Update the attachment download counts

{

$sql = 'UPDATE ' . ATTACHMENTS_DESC_TABLE . '

SET download_count = download_count + 1

// Mark topics read

// Change encoding if appropriate