-$submit = (isset($_POST['post']));

-$preview = (isset($_POST['preview']));

-$save = (isset($_POST['save']));

-$load = (isset($_POST['load']));

-$cancel = (isset($_POST['cancel']));

-$confirm = (isset($_POST['confirm']));

-$delete = (isset($_POST['delete']));

-

-$refresh = isset($_POST['add_file']) || isset($_POST['delete_file']) || isset($_POST['edit_comment']) || isset($_POST['cancel_unglobalise']) || $save || $load;

-

-$error = array();

-if ($sql)

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

-

- extract($db->sql_fetchrow($result));

- $db->sql_freeresult($result);

-

- if ($mode == 'popup')

- {

- upload_popup($forum_style);

- exit;

- }

-

- $quote_username = (isset($username)) ? $username : ((isset($post_username)) ? $post_username : '');

-

- $forum_id = (int) $forum_id;

- $topic_id = (int) $topic_id;

- $post_id = (int) $post_id;

-

- // Global Topic? - Adjust forum id

- if (!$forum_id && $topic_type == POST_GLOBAL)

- {

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

- }

-

- $post_edit_locked = (isset($post_edit_locked)) ? (int) $post_edit_locked : 0;

-

- $user->setup(array('posting', 'mcp', 'viewtopic'), $forum_style);

-

- if ($forum_password)

- {

- $forum_info = array(

- 'forum_id' => $forum_id,

- 'forum_password'=> $forum_password

- );

-

- login_forum_box($forum_info);

- unset($forum_info);

- }

-

- $post_subject = (in_array($mode, array('quote', 'edit', 'delete'))) ? $post_subject : ((isset($topic_title)) ? $topic_title : '');

-

- $topic_time_limit = (isset($topic_time_limit)) ? (($topic_time_limit) ? (int) $topic_time_limit / 86400 : (int) $topic_time_limit) : 0;

-

- $poll_length = (isset($poll_length)) ? (($poll_length) ? (int) $poll_length / 86400 : (int) $poll_length) : 0;

- $poll_start = (isset($poll_start)) ? (int) $poll_start : 0;

- $poll_options = array();

-

- if (!isset($icon_id) || in_array($mode, array('quote', 'reply')))

- {

- $icon_id = 0;

- }

-

- // Get Poll Data

- if ($poll_start)

- {

- $sql = 'SELECT poll_option_text

- FROM ' . POLL_OPTIONS_TABLE . "

- WHERE topic_id = $topic_id

- ORDER BY poll_option_id";

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

-

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

- {

- $poll_options[] = trim($row['poll_option_text']);

- }

- $db->sql_freeresult($result);

- }

-

- $orig_poll_options_size = sizeof($poll_options);

- $message_parser = new parse_message();

-

- if (isset($post_text))

- {

- $message_parser->message = $post_text;

- unset($post_text);

- }

-

- $message_parser->get_submitted_attachment_data();

-

- // Set uninitialized variables

- $uninit = array('post_attachment' => 0, 'poster_id' => 0, 'enable_magic_url' => 0, 'topic_status' => 0, 'topic_type' => POST_NORMAL, 'subject' => '', 'topic_title' => '', 'post_time' => 0, 'post_edit_reason' => '');

- foreach ($uninit as $var_name => $default_value)

- {

- if (!isset($$var_name))

- {

- $$var_name = $default_value;

- }

- }

- unset($uninit, $var_name, $default_value);

-

- if ($post_attachment && !$submit && !$refresh && !$preview && $mode == 'edit')

- {

- $sql = 'SELECT attach_id, physical_filename, comment, real_filename, extension, mimetype, filesize, filetime, thumbnail

- FROM ' . ATTACHMENTS_TABLE . "

- WHERE post_msg_id = $post_id

- AND in_message = 0

- ORDER BY filetime " . ((!$config['display_order']) ? 'DESC' : 'ASC');

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

-

- $message_parser->attachment_data = array_merge($message_parser->attachment_data, $db->sql_fetchrowset($result));

-

- $db->sql_freeresult($result);

- }

-

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

- {

- $username = (in_array($mode, array('quote', 'edit', 'delete'))) ? trim($post_username) : '';

- }

- else

- {

- $username = (in_array($mode, array('quote', 'edit', 'delete'))) ? trim($username) : '';

- }

-

- $enable_urls = $enable_magic_url;

-

- if (!in_array($mode, array('quote', 'edit', 'delete')))

- {

- $enable_sig = ($config['allow_sig'] && $user->optionget('attachsig'));

- $enable_smilies = ($config['allow_smilies'] && $user->optionget('smilies'));

- $enable_bbcode = ($config['allow_bbcode'] && $user->optionget('bbcode'));

- $enable_urls = true;

- }

- $enable_magic_url = $drafts = false;

- // User own some drafts?

- if ($user->data['is_registered'] && $auth->acl_get('u_savedrafts') && $mode != 'delete')

- {

- $sql = 'SELECT draft_id

- FROM ' . DRAFTS_TABLE . '

- WHERE (forum_id IN (' . $forum_id . ', 0)' . (($topic_id) ? " OR topic_id = $topic_id" : '') . ')

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

- (($draft_id) ? " AND draft_id <> $draft_id" : '');

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

-

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

- {

- $drafts = true;

- }

- $db->sql_freeresult($result);

- }

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

-}

-

-// Notify user checkbox

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

- $sql = 'SELECT topic_id

- FROM ' . TOPICS_WATCH_TABLE . '

- WHERE topic_id = ' . $topic_id . '

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

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

- $notify_set = ($db->sql_fetchrow($result)) ? 1 : 0;

- $db->sql_freeresult($result);

-else

- $notify_set = 0;

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

-

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

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

- $message = ($forum_status == ITEM_LOCKED) ? 'FORUM_LOCKED' : 'TOPIC_LOCKED';

- trigger_error($message);

-// !$preview && !$refresh && !$submit &&

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

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

- if (!($post_time > time() - $config['edit_time'] || !$config['edit_time']))

- if ($post_edit_locked)

-// Do we want to edit our post ?

-

-if ($mode == 'edit')

- $message_parser->bbcode_uid = $bbcode_uid;

-

-// Delete triggered ?

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

- $s_hidden_fields = build_hidden_fields(array(

- 'p' => $post_id,

- 'f' => $forum_id,

- 'mode' => 'delete')

- );

-

- if (confirm_box(true))

- $data = array(

- 'topic_first_post_id' => $topic_first_post_id,

- 'topic_last_post_id' => $topic_last_post_id,

- 'topic_approved' => $topic_approved,

- 'topic_type' => $topic_type,

- 'post_approved' => $post_approved,

- 'post_time' => $post_time,

- 'poster_id' => $poster_id

- );

- $next_post_id = delete_post($mode, $post_id, $topic_id, $forum_id, $data);

- if ($topic_first_post_id == $topic_last_post_id)

- {

- add_log('mod', $forum_id, $topic_id, 'LOG_DELETE_TOPIC', $topic_title);

- $meta_info = "{$phpbb_root_path}viewforum.$phpEx$SID&amp;f=$forum_id";

- $message = $user->lang['POST_DELETED'];

- }

- else

- {

- add_log('mod', $forum_id, $topic_id, 'LOG_DELETE_POST', $post_subject);

- $meta_info = "{$phpbb_root_path}viewtopic.$phpEx$SID&amp;f=$forum_id&amp;t=$topic_id&amp;p=$next_post_id#p$next_post_id";

- $message = $user->lang['POST_DELETED'] . '<br /><br />' . sprintf($user->lang['RETURN_TOPIC'], "<a href=\"{$phpbb_root_path}viewtopic.$phpEx$SID&amp;f=$forum_id&amp;t=$topic_id&amp;p=$next_post_id#p$next_post_id\">", '</a>');

- }

- meta_refresh(3, $meta_info);

- $message .= '<br /><br />' . sprintf($user->lang['RETURN_FORUM'], "<a href=\"{$phpbb_root_path}viewforum.$phpEx$SID&amp;f=$forum_id\">", '</a>');

- else

- confirm_box(false, 'DELETE_MESSAGE', $s_hidden_fields);

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

- trigger_error('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('CANNOT_DELETE_REPLIED');

-if ($mode == 'delete')

- trigger_error('USER_CANNOT_DELETE');

-

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

-$bbcode_status = ($config['allow_bbcode'] && $auth->acl_get('f_bbcode', $forum_id));

-$smilies_status = ($config['allow_smilies'] && $auth->acl_get('f_smilies', $forum_id));

-$img_status = ($auth->acl_get('f_img', $forum_id));

-$flash_status = ($auth->acl_get('f_flash', $forum_id));

-$quote_status = ($auth->acl_get('f_reply', $forum_id));

-

-// Bump Topic

-if ($mode == 'bump' && ($bump_time = bump_topic_allowed($forum_id, $topic_bumped, $topic_last_post_time, $topic_poster, $topic_last_poster_id)))

- $db->sql_transaction();

-

- $db->sql_query('UPDATE ' . POSTS_TABLE . "

- SET post_time = $current_time

- WHERE post_id = $topic_last_post_id

- AND topic_id = $topic_id");

-

- $db->sql_query('UPDATE ' . TOPICS_TABLE . "

- SET topic_last_post_time = $current_time,

- topic_bumped = 1,

- topic_bumper = " . $user->data['user_id'] . "

- WHERE topic_id = $topic_id");

-

- update_post_information('forum', $forum_id);

- $db->sql_query('UPDATE ' . USERS_TABLE . "

- SET user_lastpost_time = $current_time

- WHERE user_id = " . $user->data['user_id']);

- $db->sql_transaction('commit');

- markread('post', $forum_id, $topic_id, $current_time);

- add_log('mod', $forum_id, $topic_id, sprintf($user->lang['LOGM_BUMP'], $topic_title));

- meta_refresh(3, "viewtopic.$phpEx$SID&amp;f=$forum_id&amp;t=$topic_id&amp;p=$topic_last_post_id#p$topic_last_post_id");

- $message = $user->lang['TOPIC_BUMPED'] . '<br /><br />' . sprintf($user->lang['VIEW_MESSAGE'], '<a href="viewtopic.' . $phpEx . $SID . "&amp;f=$forum_id&amp;t=$topic_id&amp;p=$topic_last_post_id#p$topic_last_post_id\">", '</a>') . '<br /><br />' . sprintf($user->lang['RETURN_FORUM'], '<a href="viewforum.' . $phpEx . $SID .'&amp;f=' . $forum_id . '">', '</a>');

- trigger_error($message);

-else if ($mode == 'bump')

- trigger_error('BUMP_ERROR');

- $subject = (!$subject && $mode != 'post') ? $topic_title : $subject;

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

- 'topic_id' => $topic_id,

- 'forum_id' => $forum_id,

- 'save_time' => $current_time,

- 'draft_subject' => $subject,

- 'draft_message' => $message));

- $meta_info = ($mode == 'post') ? "viewforum.$phpEx$SID&amp;f=$forum_id" : "viewtopic.$phpEx$SID&amp;f=$forum_id&amp;t=$topic_id";

- $message .= sprintf($user->lang['RETURN_FORUM'], '<a href="viewforum.' . $phpEx . $SID . '&amp;f=' . $forum_id . '">', '</a>');

- unset($subject);

- unset($message);

-// Load Draft

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

-// Load Drafts

-if ($load && $drafts)

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

- $subject = request_var('subject', '', true);

- if (strcmp($subject, strtoupper($subject)) == 0 && $subject)

- $subject = strtolower($subject);

- $username = (isset($_POST['username'])) ? request_var('username', '', true) : $username;

- $post_edit_reason = (!empty($_POST['edit_reason']) && $mode == 'edit' && $auth->acl_get('m_edit', $forum_id)) ? request_var('edit_reason', '', true) : '';

-

- $topic_type = (isset($_POST['topic_type'])) ? (int) $_POST['topic_type'] : (($mode != 'post') ? $topic_type : POST_NORMAL);

- $topic_time_limit = (isset($_POST['topic_time_limit'])) ? (int) $_POST['topic_time_limit'] : (($mode != 'post') ? $topic_time_limit : 0);

- $icon_id = request_var('icon', 0);

- $enable_bbcode = (!$bbcode_status || isset($_POST['disable_bbcode'])) ? false : true;

- $enable_smilies = (!$smilies_status || isset($_POST['disable_smilies'])) ? false : true;

- $enable_urls = (isset($_POST['disable_magic_url'])) ? 0 : 1;

- $enable_sig = (!$config['allow_sig']) ? false : ((isset($_POST['attach_sig']) && $user->data['is_registered']) ? true : false);

- $notify = (isset($_POST['notify']));

- $topic_lock = (isset($_POST['lock_topic']));

- $post_lock = (isset($_POST['lock_post']));

- $poll_delete = (isset($_POST['poll_delete']));

- $status_switch = (($enable_bbcode+1) << 8) + (($enable_smilies+1) << 4) + (($enable_urls+1) << 2) + (($enable_sig+1) << 1);

- if ($poll_delete && $mode == 'edit' && $poll_options &&

- ((!$poll_last_vote && $poster_id == $user->data['user_id'] && $auth->acl_get('f_delete', $forum_id)) || $auth->acl_get('m_delete', $forum_id)))

- $poll_title = $poll_option_text = '';

- $poll_vote_change = $poll_max_options = $poll_length = 0;

- $poll_title = request_var('poll_title', '', true);

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

- $poll_option_text = request_var('poll_option_text', '', true);

- $poll_max_options = request_var('poll_max_options', 1);

- $poll_vote_change = ($auth->acl_get('f_votechg', $forum_id) && isset($_POST['poll_vote_change'])) ? 1 : 0;

- if (($mode == 'reply' || $mode == 'quote') && $topic_cur_post_id && $topic_cur_post_id != $topic_last_post_id)

- if (topic_review($topic_id, $forum_id, 'post_review', $topic_cur_post_id))

- $update_message = ($mode != 'edit' || $message_md5 != $post_checksum || $status_switch) ? true : false;

- $message_parser->parse($enable_bbcode, $enable_urls, $enable_smilies, $img_status, $flash_status, $quote_status);

- $message_parser->bbcode_bitfield = $bbcode_bitfield;

- if ($last_post_time)

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

- {

- $error[] = $user->lang['FLOOD_ERROR'];

- }

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

- if (($result = validate_username(($mode == 'edit' && $post_username) ? $post_username : $username)) != false)

- if ($config['enable_post_confirm'] && !$user->data['is_registered'] && ($mode == 'post' || $mode == 'reply'))

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

- $poll_last_vote = (isset($poll_last_vote)) ? $poll_last_vote : 0;

- if ($poll_option_text &&

- ($mode == 'post' || ($mode == 'edit' && $post_id == $topic_first_post_id && (!$poll_last_vote || $auth->acl_get('m_edit', $forum_id))))

- 'poll_title' => $poll_title,

- 'poll_length' => $poll_length,

- 'poll_max_options' => $poll_max_options,

- 'poll_option_text' => $poll_option_text,

- 'poll_start' => $poll_start,

- 'poll_last_vote' => $poll_last_vote,

- 'poll_vote_change' => $poll_vote_change,

- 'enable_bbcode' => $enable_bbcode,

- 'enable_urls' => $enable_urls,

- 'enable_smilies' => $enable_smilies,

- $poll_options = isset($poll['poll_options']) ? $poll['poll_options'] : '';

- $poll_title = isset($poll['poll_title']) ? $poll['poll_title'] : '';

- if ($poll_last_vote && ($poll['poll_options_size'] < $orig_poll_options_size))

- if ($topic_type != POST_NORMAL && ($mode == 'post' || ($mode == 'edit' && $topic_first_post_id == $post_id)))

- switch ($topic_type)

- if ($topic_type != POST_GLOBAL)

-

- $change_topic_status = $topic_status;

- $perm_lock_unlock = ($auth->acl_get('m_lock', $forum_id) || ($auth->acl_get('f_user_lock', $forum_id) && $user->data['is_registered'] && $user->data['user_id'] == $topic_poster));

- if ($topic_status == ITEM_LOCKED && !$topic_lock && $perm_lock_unlock)

- else if ($topic_status == ITEM_UNLOCKED && $topic_lock && $perm_lock_unlock)

- if ($change_topic_status != $topic_status)

- $user_lock = ($auth->acl_get('f_user_lock', $forum_id) && $user->data['is_registered'] && $user->data['user_id'] == $topic_poster) ? 'USER_' : '';

- add_log('mod', $forum_id, $topic_id, 'LOG_' . $user_lock . (($change_topic_status == ITEM_LOCKED) ? 'LOCK' : 'UNLOCK'), $topic_title);

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

- $post_edit_locked = ITEM_UNLOCKED;

- else if ($mode == 'edit' && $post_edit_locked == ITEM_UNLOCKED && $post_lock && $auth->acl_get('m_edit', $forum_id))

- $post_edit_locked = ITEM_LOCKED;

- $post_data = array(

- 'topic_title' => (!$topic_title) ? $subject : $topic_title,

- 'topic_first_post_id' => (isset($topic_first_post_id)) ? (int) $topic_first_post_id : 0,

- 'topic_last_post_id' => (isset($topic_last_post_id)) ? (int) $topic_last_post_id : 0,

- 'topic_time_limit' => (int) $topic_time_limit,

- 'icon_id' => (int) $icon_id,

- 'poster_id' => (int) $poster_id,

- 'enable_sig' => (bool) $enable_sig,

- 'enable_bbcode' => (bool) $enable_bbcode,

- 'enable_smilies' => (bool) $enable_smilies,

- 'enable_urls' => (bool) $enable_urls,

- 'enable_indexing' => (bool) $enable_indexing,

- 'post_time' => (isset($post_time)) ? (int) $post_time : $current_time,

- 'post_checksum' => (isset($post_checksum)) ? (string) $post_checksum : '',

- 'post_edit_reason' => $post_edit_reason,

- 'post_edit_user' => ($mode == 'edit') ? $user->data['user_id'] : ((isset($post_edit_user)) ? (int) $post_edit_user : 0),

- 'forum_parents' => $forum_parents,

- 'forum_name' => $forum_name,

- 'notify_set' => $notify_set,

- 'poster_ip' => (isset($poster_ip)) ? (int) $poster_ip : $user->ip,

- 'post_edit_locked' => (int) $post_edit_locked,

- submit_post($mode, $subject, $username, $topic_type, $poll, $post_data, $update_message);

- $post_subject = stripslashes($subject);

- $post_time = ($mode == 'edit') ? $post_time : $current_time;

- $preview_message = $message_parser->format_display($enable_bbcode, $enable_urls, $enable_smilies, false);

- $preview_signature = ($mode == 'edit') ? $user_sig : $user->data['user_sig'];

- $preview_signature_uid = ($mode == 'edit') ? $user_sig_bbcode_uid : $user->data['user_sig_bbcode_uid'];

- $preview_signature_bitfield = ($mode == 'edit') ? $user_sig_bbcode_bitfield : $user->data['user_sig_bbcode_bitfield'];

- if ($enable_sig && $config['allow_sig'] && $preview_signature && $auth->acl_get('f_sigs', $forum_id))

- $parse_sig->format_display($config['allow_bbcode'], true, $config['allow_smilies']);

- $preview_subject = censor_text($subject);

- if (($mode == 'post' || ($mode == 'edit' && $post_id == $topic_first_post_id && (!$poll_last_vote || $auth->acl_get('m_edit', $forum_id))))

- $parse_poll = new parse_message($poll_title);

- $parse_poll->format_display($enable_bbcode, $enable_urls, $enable_smilies);

- 'S_HAS_POLL_OPTIONS'=> (sizeof($poll_options)),

- 'S_IS_MULTI_CHOICE' => ($poll_max_options > 1) ? true : false,

- 'L_POLL_LENGTH' => ($poll_length) ? sprintf($user->lang['POLL_RUN_TILL'], $user->format_date($poll_length + $poll_start)) : '',

- 'L_MAX_VOTES' => ($poll_max_options == 1) ? $user->lang['MAX_OPTION_SELECT'] : sprintf($user->lang['MAX_OPTIONS_SELECT'], $poll_max_options))

- $parse_poll->message = implode("\n", $poll_options);

- $parse_poll->format_display($enable_bbcode, $enable_urls, $enable_smilies);

-

- unset($post_text);

-$bbcode_uid = ($mode == 'quote' && !$preview && !$refresh && !sizeof($error)) ? $bbcode_uid : $message_parser->bbcode_uid;

-$message_parser->decode_message($bbcode_uid);

- $message_parser->message = '[quote="' . $quote_username . '"]' . censor_text(trim($message_parser->message)) . "[/quote]\n";

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

-$post_text = $message_parser->message;

-if (sizeof($poll_options) && $poll_title)

- $message_parser->message = $poll_title;

- $message_parser->bbcode_uid = $bbcode_uid;

- $poll_title = $message_parser->message;

- $message_parser->message = implode("\n", $poll_options);

- $poll_options = explode("\n", $message_parser->message);

-

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

- $topic_type_toggle = posting_gen_topic_types($forum_id, $topic_type);

-if ($enable_icons)

- $s_topic_icons = posting_gen_topic_icons($mode, $icon_id);

-$bbcode_checked = (isset($enable_bbcode)) ? !$enable_bbcode : (($config['allow_bbcode']) ? !$user->optionget('bbcode') : 1);

-$smilies_checked = (isset($enable_smilies)) ? !$enable_smilies : (($config['allow_smilies']) ? !$user->optionget('smilies') : 1);

-$urls_checked = (isset($enable_urls)) ? !$enable_urls : 0;

-$sig_checked = $enable_sig;

-$notify_checked = (isset($notify)) ? $notify : ((!$notify_set) ? (($user->data['is_registered']) ? $user->data['user_notify'] : 0) : 1);

-$lock_topic_checked = (isset($topic_lock)) ? $topic_lock : (($topic_status == ITEM_LOCKED) ? 1 : 0);

-$lock_post_checked = (isset($post_lock)) ? $post_lock : $post_edit_locked;

-$forum_data = array(

- 'parent_id' => $parent_id,

- 'left_id' => $left_id,

- 'right_id' => $right_id,

- 'forum_parents' => $forum_parents,

- 'forum_name' => $forum_name,

- 'forum_id' => $forum_id,

- 'forum_type' => $forum_type,

- 'forum_desc' => $forum_desc,

- 'forum_desc_uid' => $forum_desc_uid,

- 'forum_desc_bitfield' => $forum_desc_bitfield,

- 'forum_rules' => $forum_rules,

- 'forum_rules_uid' => $forum_rules_uid,

- 'forum_rules_bitfield' => $forum_rules_bitfield,

- 'forum_rules_link' => $forum_rules_link

-);

-

-generate_forum_nav($forum_data);

-generate_forum_rules($forum_data);

-if ($config['enable_post_confirm'] && !$user->data['is_registered'] && ($mode == 'post' || $mode == 'reply'))

- 'L_POST_CONFIRM_EXPLAIN' => sprintf($user->lang['POST_CONFIRM_EXPLAIN'], '<a href="mailto:' . htmlentities($config['board_contact']) . '">', '</a>'),

-$s_hidden_fields = ($mode == 'reply' || $mode == 'quote') ? '<input type="hidden" name="topic_cur_post_id" value="' . $topic_last_post_id . '" />' : '';

-$s_hidden_fields .= ($draft_id || isset($_REQUEST['draft_loaded'])) ? '<input type="hidden" name="draft_loaded" value="' . ((isset($_REQUEST['draft_loaded'])) ? intval($_REQUEST['draft_loaded']) : $draft_id) . '" />' : '';

- 'L_ICON' => ($mode == 'reply' || $mode == 'quote' || ($mode == 'edit' && $post_id != $topic_first_post_id)) ? $user->lang['POST_ICON'] : $user->lang['TOPIC_ICON'],

- 'FORUM_NAME' => $forum_name,

- 'FORUM_DESC' => ($forum_desc) ? generate_text_for_display($forum_desc, $forum_desc_uid, $forum_desc_bitfield) : '',

- 'TOPIC_TITLE' => $topic_title,

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

- 'SUBJECT' => $post_subject,

- 'MESSAGE' => $post_text,

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

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

- 'TOPIC_TIME_LIMIT' => (int) $topic_time_limit,

- 'EDIT_REASON' => $post_edit_reason,

-

- '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_PROGRESS_BAR' => "posting.$phpEx$SID&amp;f=$forum_id&amp;mode=popup",

- 'UA_PROGRESS_BAR' => "posting.$phpEx$SID&f=$forum_id&mode=popup",

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

- 'S_SHOW_TOPIC_ICONS' => $s_topic_icons,

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

- 'S_BBCODE_ALLOWED' => $bbcode_status,

- 'S_BBCODE_CHECKED' => ($bbcode_checked) ? ' checked="checked"' : '',

- 'S_SMILIES_ALLOWED' => $smilies_status,

- 'S_SMILIES_CHECKED' => ($smilies_checked) ? ' checked="checked"' : '',

- 'S_SIG_ALLOWED' => ($auth->acl_get('f_sigs', $forum_id) && $config['allow_sig'] && $user->data['is_registered']),

- 'S_SIGNATURE_CHECKED' => ($sig_checked) ? ' checked="checked"' : '',

- 'S_NOTIFY_ALLOWED' => ($user->data['is_registered']),

- 'S_NOTIFY_CHECKED' => ($notify_checked) ? ' checked="checked"' : '',

- 'S_LOCK_TOPIC_ALLOWED' => (($mode == 'edit' || $mode == 'reply' || $mode == 'quote') && ($auth->acl_get('m_lock', $forum_id) || ($auth->acl_get('f_user_lock', $forum_id) && $user->data['is_registered'] && $user->data['user_id'] == $topic_poster))),

- 'S_LOCK_TOPIC_CHECKED' => ($lock_topic_checked) ? ' checked="checked"' : '',

- 'S_LOCK_POST_ALLOWED' => ($mode == 'edit' && $auth->acl_get('m_edit', $forum_id)),

- 'S_LOCK_POST_CHECKED' => ($lock_post_checked) ? ' checked="checked"' : '',

- 'S_MAGIC_URL_CHECKED' => ($urls_checked) ? ' checked="checked"' : '',

- 'S_TYPE_TOGGLE' => $topic_type_toggle,

- 'S_SAVE_ALLOWED' => ($auth->acl_get('u_savedrafts') && $user->data['is_registered']),

- 'S_HAS_DRAFTS' => ($auth->acl_get('u_savedrafts') && $user->data['is_registered'] && $drafts),

- 'S_FORM_ENCTYPE' => $form_enctype,

-if (($mode == 'post' || ($mode == 'edit' && $post_id == $topic_first_post_id && (!$poll_last_vote || $auth->acl_get('m_edit', $forum_id))))

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

- 'VOTE_CHANGE_CHECKED' => (isset($poll_vote_change) && $poll_vote_change) ? ' checked="checked"' : '',

- 'POLL_TITLE' => (isset($poll_title)) ? $poll_title : '',

- 'POLL_OPTIONS' => (isset($poll_options) && $poll_options) ? implode("\n", $poll_options) : '',

- 'POLL_MAX_OPTIONS' => (isset($poll_max_options)) ? (int) $poll_max_options : 1,

- 'POLL_LENGTH' => $poll_length)

-make_jumpbox('viewforum.'.$phpEx);

-

-* Delete Post

-function delete_post($mode, $post_id, $topic_id, $forum_id, &$data)

- global $db, $user, $config, $auth, $phpEx, $SID, $phpbb_root_path;

-

- // Specify our post mode

- $post_mode = ($data['topic_first_post_id'] == $data['topic_last_post_id']) ? 'delete_topic' : (($data['topic_first_post_id'] == $post_id) ? 'delete_first_post' : (($data['topic_last_post_id'] == $post_id) ? 'delete_last_post' : 'delete'));

- $sql_data = array();

- $next_post_id = 0;

-

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

-

- $db->sql_transaction();

-

- if (!delete_posts('post_id', array($post_id), false))

- {

- // Try to delete topic, we may had an previous error causing inconsistency

- if ($post_mode = 'delete_topic')

- {

- delete_topics('topic_id', array($topic_id), false);

- }

- trigger_error('ALREADY_DELETED');

- }

-

- $db->sql_transaction('commit');

-

- // Collect the necessary informations for updating the tables

- $sql_data[FORUMS_TABLE] = '';

- switch ($post_mode)

- {

- case 'delete_topic':

- delete_topics('topic_id', array($topic_id), false);

- set_config('num_topics', $config['num_topics'] - 1, true);

-

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

- {

- $sql_data[FORUMS_TABLE] .= 'forum_posts = forum_posts - 1, forum_topics_real = forum_topics_real - 1';

- $sql_data[FORUMS_TABLE] .= ($data['topic_approved']) ? ', forum_topics = forum_topics - 1' : '';

- }

-

- $update_sql = update_post_information('forum', $forum_id, true);

- if (sizeof($update_sql))

- {

- $sql_data[FORUMS_TABLE] .= ($sql_data[FORUMS_TABLE]) ? ', ' : '';

- $sql_data[FORUMS_TABLE] .= implode(', ', $update_sql[$forum_id]);

- }

-

- $sql_data[TOPICS_TABLE] = 'topic_replies_real = topic_replies_real - 1' . (($data['post_approved']) ? ', topic_replies = topic_replies - 1' : '');

- break;

-

- case 'delete_first_post':

- $sql = 'SELECT p.post_id, p.poster_id, p.post_username, u.username

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

- WHERE p.topic_id = $topic_id

- AND p.poster_id = u.user_id

- ORDER BY p.post_time ASC";

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

-

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

- $db->sql_freeresult($result);

-

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

- {

- $sql_data[FORUMS_TABLE] = 'forum_posts = forum_posts - 1';

- }

-

- $sql_data[TOPICS_TABLE] = 'topic_first_post_id = ' . intval($row['post_id']) . ", topic_first_poster_name = '" . (($row['poster_id'] == ANONYMOUS) ? $db->sql_escape($row['post_username']) : $db->sql_escape($row['username'])) . "'";

- $sql_data[TOPICS_TABLE] .= ', topic_replies_real = topic_replies_real - 1' . (($data['post_approved']) ? ', topic_replies = topic_replies - 1' : '');

-

- $next_post_id = (int) $row['post_id'];

- break;

-

- case 'delete_last_post':

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

- {

- $sql_data[FORUMS_TABLE] = 'forum_posts = forum_posts - 1';

- }

-

- $update_sql = update_post_information('forum', $forum_id, true);

- if (sizeof($update_sql))

- {

- $sql_data[FORUMS_TABLE] .= ($sql_data[FORUMS_TABLE]) ? ', ' : '';

- $sql_data[FORUMS_TABLE] .= implode(', ', $update_sql[$forum_id]);

- }

-

- $sql_data[TOPICS_TABLE] = 'topic_bumped = 0, topic_bumper = 0, topic_replies_real = topic_replies_real - 1' . (($data['post_approved']) ? ', topic_replies = topic_replies - 1' : '');

-

- $update_sql = update_post_information('topic', $topic_id, true);

- if (sizeof($update_sql))

- {

- $sql_data[TOPICS_TABLE] .= ', ' . implode(', ', $update_sql[$topic_id]);

- $next_post_id = (int) str_replace('topic_last_post_id = ', '', $update_sql[$topic_id][0]);

- }

- else

- {

- $sql = 'SELECT MAX(post_id) as last_post_id

- FROM ' . POSTS_TABLE . "

- WHERE topic_id = $topic_id " .

- ((!$auth->acl_get('m_approve', $forum_id)) ? 'AND post_approved = 1' : '');

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

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

- $db->sql_freeresult($result);

-

- $next_post_id = (int) $row['last_post_id'];

- }

- break;

-

- case 'delete':

- $sql = 'SELECT post_id

- FROM ' . POSTS_TABLE . "

- WHERE topic_id = $topic_id " .

- ((!$auth->acl_get('m_approve', $forum_id)) ? 'AND post_approved = 1' : '') . '

- AND post_time > ' . $data['post_time'] . '

- ORDER BY post_time ASC';

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

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

- $db->sql_freeresult($result);

-

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

- {

- $sql_data[FORUMS_TABLE] = 'forum_posts = forum_posts - 1';

- }

-

- $sql_data[TOPICS_TABLE] = 'topic_replies_real = topic_replies_real - 1' . (($data['post_approved']) ? ', topic_replies = topic_replies - 1' : '');

- $next_post_id = (int) $row['post_id'];

- break;

- }

-

- $sql_data[USERS_TABLE] = ($auth->acl_get('f_postcount', $forum_id)) ? 'user_posts = user_posts - 1' : '';

- set_config('num_posts', $config['num_posts'] - 1, true);

- $db->sql_transaction();

- $where_sql = array(FORUMS_TABLE => "forum_id = $forum_id", TOPICS_TABLE => "topic_id = $topic_id", USERS_TABLE => 'user_id = ' . $data['poster_id']);

- foreach ($sql_data as $table => $update_sql)

- {

- if ($update_sql)

- {

- $db->sql_query("UPDATE $table SET $update_sql WHERE " . $where_sql[$table]);

- }

- }

- $db->sql_transaction('commit');

- return $next_post_id;

-

-* Submit Post

-function submit_post($mode, $subject, $username, $topic_type, &$poll, &$data, $update_message = true)

- global $db, $auth, $user, $config, $phpEx, $SID, $template, $phpbb_root_path;

-

- // We do not handle erasing posts here

- if ($mode == 'delete')

- {

- return;

- }

-

- $current_time = time();

-

- if ($mode == 'post')

- {

- $post_mode = 'post';

- $update_message = true;

- }

- else if ($mode != 'edit')

- {

- $post_mode = 'reply';

- $update_message = true;

- }

- else if ($mode == 'edit')

- {

- $post_mode = ($data['topic_first_post_id'] == $data['topic_last_post_id']) ? 'edit_topic' : (($data['topic_first_post_id'] == $data['post_id']) ? 'edit_first_post' : (($data['topic_last_post_id'] == $data['post_id']) ? 'edit_last_post' : 'edit'));

- }

-

-

- // Collect some basic informations about which tables and which rows to update/insert

- $sql_data = array();

- $poster_id = ($mode == 'edit') ? $data['poster_id'] : (int) $user->data['user_id'];

-

- // Collect Informations

- switch ($post_mode)

- {

- case 'post':

- case 'reply':

- $sql_data[POSTS_TABLE]['sql'] = array(

- 'forum_id' => ($topic_type == POST_GLOBAL) ? 0 : $data['forum_id'],

- 'poster_id' => (int) $user->data['user_id'],

- 'icon_id' => $data['icon_id'],

- 'poster_ip' => $user->ip,

- 'post_time' => $current_time,

- 'post_approved' => ($auth->acl_get('f_moderate', $data['forum_id']) && !$auth->acl_get('m_approve', $data['forum_id'])) ? 0 : 1,

- 'enable_bbcode' => $data['enable_bbcode'],

- 'enable_smilies' => $data['enable_smilies'],

- 'enable_magic_url' => $data['enable_urls'],

- 'enable_sig' => $data['enable_sig'],

- 'post_username' => (!$user->data['is_registered']) ? stripslashes($username) : '',

- 'post_subject' => $subject,

- 'post_text' => $data['message'],

- 'post_checksum' => $data['message_md5'],

- 'post_encoding' => $user->lang['ENCODING'],

- 'post_attachment' => (isset($data['filename_data']['physical_filename']) && sizeof($data['filename_data'])) ? 1 : 0,

- 'bbcode_bitfield' => $data['bbcode_bitfield'],

- 'bbcode_uid' => $data['bbcode_uid'],

- 'post_edit_locked' => $data['post_edit_locked']

- );

- break;

-

- case 'edit_first_post':

- case 'edit':

-

- if (!$auth->acl_gets('m_', 'a_') || $data['post_edit_reason'])

- {

- $sql_data[POSTS_TABLE]['sql'] = array(

- 'post_edit_time' => $current_time

- );

-

- $sql_data[POSTS_TABLE]['stat'][] = 'post_edit_count = post_edit_count + 1';

- }

-

- case 'edit_last_post':

- case 'edit_topic':

-

- if (($post_mode == 'edit_last_post' || $post_mode == 'edit_topic') && $data['post_edit_reason'])

- {

- $sql_data[POSTS_TABLE]['sql'] = array(

- 'post_edit_time' => $current_time

- );

-

- $sql_data[POSTS_TABLE]['stat'][] = 'post_edit_count = post_edit_count + 1';

- }

-

- if (!isset($sql_data[POSTS_TABLE]['sql']))

- {

- $sql_data[POSTS_TABLE]['sql'] = array();

- }

-

- $sql_data[POSTS_TABLE]['sql'] = array_merge($sql_data[POSTS_TABLE]['sql'], array(

- 'forum_id' => ($topic_type == POST_GLOBAL) ? 0 : $data['forum_id'],

- 'poster_id' => $data['poster_id'],

- 'icon_id' => $data['icon_id'],

- 'post_approved' => ($auth->acl_get('f_moderate', $data['forum_id']) && !$auth->acl_get('m_approve', $data['forum_id'])) ? 0 : 1,

- 'enable_bbcode' => $data['enable_bbcode'],

- 'enable_smilies' => $data['enable_smilies'],

- 'enable_magic_url' => $data['enable_urls'],

- 'enable_sig' => $data['enable_sig'],

- 'post_username' => ($username && $data['poster_id'] == ANONYMOUS) ? stripslashes($username) : '',

- 'post_subject' => $subject,

- 'post_edit_reason' => $data['post_edit_reason'],

- 'post_edit_user' => (int) $data['post_edit_user'],

- 'post_checksum' => $data['message_md5'],

- 'post_encoding' => $user->lang['ENCODING'],

- 'post_attachment' => (isset($data['filename_data']['physical_filename']) && sizeof($data['filename_data'])) ? 1 : 0,

- 'bbcode_bitfield' => $data['bbcode_bitfield'],

- 'bbcode_uid' => $data['bbcode_uid'],

- 'post_edit_locked' => $data['post_edit_locked'])

- );

-

- if ($update_message)

- {

- $sql_data[POSTS_TABLE]['sql']['post_text'] = $data['message'];

- }

-

- break;

- }

-

- // And the topic ladies and gentlemen

- switch ($post_mode)

- {

- case 'post':

- $sql_data[TOPICS_TABLE]['sql'] = array(

- 'topic_poster' => (int) $user->data['user_id'],

- 'topic_time' => $current_time,

- 'forum_id' => ($topic_type == POST_GLOBAL) ? 0 : $data['forum_id'],

- 'icon_id' => $data['icon_id'],

- 'topic_approved' => ($auth->acl_get('f_moderate', $data['forum_id']) && !$auth->acl_get('m_approve', $data['forum_id'])) ? 0 : 1,

- 'topic_title' => $subject,

- 'topic_first_poster_name' => (!$user->data['is_registered'] && $username) ? stripslashes($username) : (($user->data['user_id'] != ANONYMOUS) ? $user->data['username'] : ''),

- 'topic_type' => $topic_type,

- 'topic_time_limit' => ($topic_type == POST_STICKY || $topic_type == POST_ANNOUNCE) ? ($data['topic_time_limit'] * 86400) : 0,

- 'topic_attachment' => (isset($data['filename_data']['physical_filename']) && sizeof($data['filename_data'])) ? 1 : 0

- );

-

- if (isset($poll['poll_options']) && !empty($poll['poll_options']))

- {

- $sql_data[TOPICS_TABLE]['sql'] = array_merge($sql_data[TOPICS_TABLE]['sql'], array(

- 'poll_title' => $poll['poll_title'],

- 'poll_start' => ($poll['poll_start']) ? $poll['poll_start'] : $current_time,

- 'poll_max_options' => $poll['poll_max_options'],

- 'poll_length' => ($poll['poll_length'] * 86400),

- 'poll_vote_change' => $poll['poll_vote_change'])

- );

- }

-

- $sql_data[USERS_TABLE]['stat'][] = "user_lastpost_time = $current_time" . (($auth->acl_get('f_postcount', $data['forum_id'])) ? ', user_posts = user_posts + 1' : '');

- if ($topic_type != POST_GLOBAL)

- {

- if (!$auth->acl_get('f_moderate', $data['forum_id']) || $auth->acl_get('m_approve', $data['forum_id']))

- {

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts = forum_posts + 1';

- }

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_topics_real = forum_topics_real + 1' . ((!$auth->acl_get('f_moderate', $data['forum_id']) || $auth->acl_get('m_approve', $data['forum_id'])) ? ', forum_topics = forum_topics + 1' : '');

- }

- break;

-

- case 'reply':

- $sql_data[TOPICS_TABLE]['stat'][] = 'topic_replies_real = topic_replies_real + 1, topic_bumped = 0, topic_bumper = 0' . ((!$auth->acl_get('f_moderate', $data['forum_id']) || $auth->acl_get('m_approve', $data['forum_id'])) ? ', topic_replies = topic_replies + 1' : '');

- $sql_data[USERS_TABLE]['stat'][] = "user_lastpost_time = $current_time" . (($auth->acl_get('f_postcount', $data['forum_id'])) ? ', user_posts = user_posts + 1' : '');

-

- if ((!$auth->acl_get('f_moderate', $data['forum_id']) || $auth->acl_get('m_approve', $data['forum_id'])) && $topic_type != POST_GLOBAL)

- {

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts = forum_posts + 1';

- }

- break;

-

- case 'edit_topic':

- case 'edit_first_post':

-

- $sql_data[TOPICS_TABLE]['sql'] = array(

- 'forum_id' => ($topic_type == POST_GLOBAL) ? 0 : $data['forum_id'],

- 'icon_id' => $data['icon_id'],

- 'topic_approved' => ($auth->acl_get('f_moderate', $data['forum_id']) && !$auth->acl_get('m_approve', $data['forum_id'])) ? 0 : 1,

- 'topic_title' => $subject,

- 'topic_first_poster_name' => stripslashes($username),

- 'topic_type' => $topic_type,

- 'topic_time_limit' => ($topic_type == POST_STICKY || $topic_type == POST_ANNOUNCE) ? ($data['topic_time_limit'] * 86400) : 0,

- 'poll_title' => (isset($poll['poll_options'])) ? $poll['poll_title'] : '',

- 'poll_start' => (isset($poll['poll_options'])) ? (($poll['poll_start']) ? $poll['poll_start'] : $current_time) : 0,

- 'poll_max_options' => (isset($poll['poll_options'])) ? $poll['poll_max_options'] : 1,

- 'poll_length' => (isset($poll['poll_options'])) ? ($poll['poll_length'] * 86400) : 0,

- 'poll_vote_change' => (isset($poll['poll_vote_change'])) ? $poll['poll_vote_change'] : 0,

-

- 'topic_attachment' => ($post_mode == 'edit_topic') ? ((isset($data['filename_data']['physical_filename']) && sizeof($data['filename_data'])) ? 1 : 0) : (isset($data['topic_attachment']) ? $data['topic_attachment'] : 0)

- );

- break;

- }

-

- $db->sql_transaction();

-

- // Submit new topic

- if ($post_mode == 'post')

- $sql = 'INSERT INTO ' . TOPICS_TABLE . ' ' .

- $db->sql_build_array('INSERT', $sql_data[TOPICS_TABLE]['sql']);

- $db->sql_query($sql);

-

- $data['topic_id'] = $db->sql_nextid();

-

- $sql_data[POSTS_TABLE]['sql'] = array_merge($sql_data[POSTS_TABLE]['sql'], array(

- 'topic_id' => $data['topic_id'])

- unset($sql_data[TOPICS_TABLE]['sql']);

- }

-

- // Submit new post

- if ($post_mode == 'post' || $post_mode == 'reply')

- {

- if ($post_mode == 'reply')

- {

- $sql_data[POSTS_TABLE]['sql'] = array_merge($sql_data[POSTS_TABLE]['sql'], array(

- 'topic_id' => $data['topic_id'])

- );

- }

- $sql = 'INSERT INTO ' . POSTS_TABLE . ' ' .

- $db->sql_build_array('INSERT', $sql_data[POSTS_TABLE]['sql']);

- $db->sql_query($sql);

- $data['post_id'] = $db->sql_nextid();

-

- if ($post_mode == 'post')

- $sql_data[TOPICS_TABLE]['sql'] = array(

- 'topic_first_post_id' => $data['post_id'],

- 'topic_last_post_id' => $data['post_id'],

- 'topic_last_post_time' => $current_time,

- 'topic_last_poster_id' => (int) $user->data['user_id'],

- 'topic_last_poster_name'=> (!$user->data['is_registered'] && $username) ? stripslashes($username) : (($user->data['user_id'] != ANONYMOUS) ? $user->data['username'] : '')

- }

- unset($sql_data[POSTS_TABLE]['sql']);

- }

- $make_global = false;

-

- // Are we globalising or unglobalising?

- if ($post_mode == 'edit_first_post' || $post_mode == 'edit_topic')

- {

- $sql = 'SELECT topic_type, topic_replies_real, topic_approved

- FROM ' . TOPICS_TABLE . '

- WHERE topic_id = ' . $data['topic_id'];

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

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

- $db->sql_freeresult($result);

-

- // globalise

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

- {

- // Decrement topic/post count

- $make_global = true;

- $sql_data[FORUMS_TABLE]['stat'] = array();

-

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts = forum_posts - ' . ($row['topic_replies_real'] + 1);

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_topics_real = forum_topics_real - 1' . (($row['topic_approved']) ? ', forum_topics = forum_topics - 1' : '');

-

- // Update forum_ids for all posts

- $sql = 'UPDATE ' . POSTS_TABLE . '

- SET forum_id = 0

- WHERE topic_id = ' . $data['topic_id'];

- $db->sql_query($sql);

- }

- // unglobalise

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

- {

- // Increment topic/post count

- $make_global = true;

- $sql_data[FORUMS_TABLE]['stat'] = array();

-

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts = forum_posts + ' . ($row['topic_replies_real'] + 1);

- $sql_data[FORUMS_TABLE]['stat'][] = 'forum_topics_real = forum_topics_real + 1' . (($row['topic_approved']) ? ', forum_topics = forum_topics + 1' : '');

-

- // Update forum_ids for all posts

- $sql = 'UPDATE ' . POSTS_TABLE . '

- SET forum_id = ' . $data['forum_id'] . '

- WHERE topic_id = ' . $data['topic_id'];

- $db->sql_query($sql);

- }

- }

-

- // Update the topics table

- if (isset($sql_data[TOPICS_TABLE]['sql']))

- {

- $db->sql_query('UPDATE ' . TOPICS_TABLE . '

- SET ' . $db->sql_build_array('UPDATE', $sql_data[TOPICS_TABLE]['sql']) . '

- WHERE topic_id = ' . $data['topic_id']);

- }

-

- // Update the posts table

- if (isset($sql_data[POSTS_TABLE]['sql']))

- {

- $db->sql_query('UPDATE ' . POSTS_TABLE . '

- SET ' . $db->sql_build_array('UPDATE', $sql_data[POSTS_TABLE]['sql']) . '

- WHERE post_id = ' . $data['post_id']);

- }

-

- // Update Poll Tables

- if (isset($poll['poll_options']) && !empty($poll['poll_options']))

- {

- $cur_poll_options = array();

-

- if ($poll['poll_start'] && $mode == 'edit')

- {

- $sql = 'SELECT * FROM ' . POLL_OPTIONS_TABLE . '

- WHERE topic_id = ' . $data['topic_id'] . '

- ORDER BY poll_option_id';

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

-

- while ($cur_poll_options[] = $db->sql_fetchrow($result));

- $db->sql_freeresult($result);

- }

-

- $sql_insert_ary = array();

- for ($i = 0, $size = sizeof($poll['poll_options']); $i < $size; $i++)

- {

- if (trim($poll['poll_options'][$i]))

- if (!$cur_poll_options[$i])

- {

- $sql_insert_ary[] = array(

- 'poll_option_id' => (int) $i,

- 'topic_id' => (int) $data['topic_id'],

- 'poll_option_text' => (string) $poll['poll_options'][$i]

- );

- }

- else if ($poll['poll_options'][$i] != $cur_poll_options[$i])

- {

- $sql = "UPDATE " . POLL_OPTIONS_TABLE . "

- SET poll_option_text = '" . $db->sql_escape($poll['poll_options'][$i]) . "'

- WHERE poll_option_id = " . $cur_poll_options[$i]['poll_option_id'] . "

- AND topic_id = " . $data['topic_id'];

- $db->sql_query($sql);

- }

- }

- }

- if (sizeof($sql_insert_ary))

- {

- switch (SQL_LAYER)

- {

- case 'mysql':

- case 'mysql4':

- case 'mysqli':

- $db->sql_query('INSERT INTO ' . POLL_OPTIONS_TABLE . ' ' . $db->sql_build_array('MULTI_INSERT', $sql_insert_ary));

- break;

-

- default:

- foreach ($sql_insert_ary as $ary)

- {

- $db->sql_query('INSERT INTO ' . POLL_OPTIONS_TABLE . ' ' . $db->sql_build_array('INSERT', $ary));

- }

- break;

- }

- }

-

- if (sizeof($poll['poll_options']) < sizeof($cur_poll_options))

- {

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

- WHERE poll_option_id >= ' . sizeof($poll['poll_options']) . '

- AND topic_id = ' . $data['topic_id'];

- $db->sql_query($sql);

- }

- }

-

- // Submit Attachments

- if (sizeof($data['attachment_data']) && $data['post_id'] && in_array($mode, array('post', 'reply', 'quote', 'edit')))

- {

- $space_taken = $files_added = 0;

-

- foreach ($data['attachment_data'] as $pos => $attach_row)

- {

- if ($attach_row['attach_id'])

- {

- // update entry in db if attachment already stored in db and filespace

- $sql = 'UPDATE ' . ATTACHMENTS_TABLE . "

- SET comment = '" . $db->sql_escape($attach_row['comment']) . "'

- WHERE attach_id = " . (int) $attach_row['attach_id'];

- $db->sql_query($sql);

- // insert attachment into db

- if (!@file_exists($phpbb_root_path . $config['upload_path'] . '/' . basename($attach_row['physical_filename'])))

- {

- continue;

- }

-

- $attach_sql = array(

- 'post_msg_id' => $data['post_id'],

- 'topic_id' => $data['topic_id'],

- 'in_message' => 0,

- 'poster_id' => $poster_id,

- 'physical_filename' => basename($attach_row['physical_filename']),

- 'real_filename' => basename($attach_row['real_filename']),

- 'comment' => $attach_row['comment'],

- 'extension' => $attach_row['extension'],

- 'mimetype' => $attach_row['mimetype'],

- 'filesize' => $attach_row['filesize'],

- 'filetime' => $attach_row['filetime'],

- 'thumbnail' => $attach_row['thumbnail']

- );

-

- $sql = 'INSERT INTO ' . ATTACHMENTS_TABLE . ' ' .

- $db->sql_build_array('INSERT', $attach_sql);

- $db->sql_query($sql);

- $space_taken += $attach_row['filesize'];

- $files_added++;

- }

- if (sizeof($data['attachment_data']))

- {

- $sql = 'UPDATE ' . POSTS_TABLE . '

- SET post_attachment = 1

- WHERE post_id = ' . $data['post_id'];

- $db->sql_query($sql);

-

- $sql = 'UPDATE ' . TOPICS_TABLE . '

- SET topic_attachment = 1

- WHERE topic_id = ' . $data['topic_id'];

- $db->sql_query($sql);

-

- set_config('upload_dir_size', $config['upload_dir_size'] + $space_taken, true);

- set_config('num_files', $config['num_files'] + $files_added, true);

- }

-

- $db->sql_transaction('commit');

-

- if ($post_mode == 'post' || $post_mode == 'reply' || $post_mode == 'edit_last_post')

- {

- if ($topic_type != POST_GLOBAL)

- {

- $update_sql = update_post_information('forum', $data['forum_id'], true);

- if (sizeof($update_sql))

- {

- $sql_data[FORUMS_TABLE]['stat'][] = implode(', ', $update_sql[$data['forum_id']]);

- }

- }

-

- $update_sql = update_post_information('topic', $data['topic_id'], true);

- if (sizeof($update_sql))

- {

- $sql_data[TOPICS_TABLE]['stat'][] = implode(', ', $update_sql[$data['topic_id']]);

- }

- }

-

- if ($make_global)

- {

- $update_sql = update_post_information('forum', $data['forum_id'], true);

- if (sizeof($update_sql))

- {

- $sql_data[FORUMS_TABLE]['stat'][] = implode(', ', $update_sql[$data['forum_id']]);

- }

- }

-

- if ($post_mode == 'edit_topic')

- {

- $update_sql = update_post_information('topic', $data['topic_id'], true);

- if (sizeof($update_sql))

- {

- $sql_data[TOPICS_TABLE]['stat'][] = implode(', ', $update_sql[$data['topic_id']]);

- }

- }

-

- // Update total post count, do not consider moderated posts/topics

- if (!$auth->acl_get('f_moderate', $data['forum_id']) || $auth->acl_get('m_approve', $data['forum_id']))

- {

- if ($post_mode == 'post')

- {

- set_config('num_topics', $config['num_topics'] + 1, true);

- set_config('num_posts', $config['num_posts'] + 1, true);

- }

-

- if ($post_mode == 'reply')

- {

- set_config('num_posts', $config['num_posts'] + 1, true);

- }

- }

-

- // Update forum stats

- $db->sql_transaction();

-

- $where_sql = array(POSTS_TABLE => 'post_id = ' . $data['post_id'], TOPICS_TABLE => 'topic_id = ' . $data['topic_id'], FORUMS_TABLE => 'forum_id = ' . $data['forum_id'], USERS_TABLE => 'user_id = ' . $user->data['user_id']);

-

- foreach ($sql_data as $table => $update_ary)

- {

- if (isset($update_ary['stat']) && implode('', $update_ary['stat']))

- {

- $db->sql_query("UPDATE $table SET " . implode(', ', $update_ary['stat']) . ' WHERE ' . $where_sql[$table]);

- }

- }

-

- // Delete topic shadows (if any exist). We do not need a shadow topic for an global announcement

- if ($make_global)

- {

- $db->sql_query('DELETE FROM ' . TOPICS_TABLE . '

- WHERE topic_moved_id = ' . $data['topic_id']);

- }

-

- // Index message contents

- if ($update_message && $data['enable_indexing'])

- {

- // Select the search method and do some additional checks to ensure it can actually be utilised

- $search_type = $config['search_type'];

-

- if (!file_exists($phpbb_root_path . 'includes/search/' . $search_type . '.' . $phpEx))

- {

- trigger_error('NO_SUCH_SEARCH_MODULE');

- }

-

- require("{$phpbb_root_path}includes/search/$search_type.$phpEx");

-

- $error = false;

- $search = new $search_type($error);

-

- if ($error)

- trigger_error($error);

-

- $search->index($mode, $data['post_id'], $data['message'], $subject, $poster_id);

- }

-

- $db->sql_transaction('commit');

-

- // Delete draft if post was loaded...

- $draft_id = request_var('draft_loaded', 0);

- if ($draft_id)

- {

- $db->sql_query('DELETE FROM ' . DRAFTS_TABLE . " WHERE draft_id = $draft_id AND user_id = " . $user->data['user_id']);

- }

-

- // Topic Notification

- if (!$data['notify_set'] && $data['notify'])

- {

- $sql = 'INSERT INTO ' . TOPICS_WATCH_TABLE . ' (user_id, topic_id)

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

- $db->sql_query($sql);

- }

- else if ($data['notify_set'] && !$data['notify'])

- {

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

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

- AND topic_id = ' . $data['topic_id'];

- $db->sql_query($sql);

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

- // Mark this topic as posted to

- markread('post', $data['forum_id'], $data['topic_id'], $data['post_time']);

- // Mark this topic as read

- // We do not use post_time here, this is intended (post_time can have a date in the past if editing a message)

- markread('topic', $data['forum_id'], $data['topic_id'], time());

-

- // Send Notifications

- if ($mode != 'edit' && $mode != 'delete' && (!$auth->acl_get('f_moderate', $data['forum_id']) || $auth->acl_get('m_approve', $data['forum_id'])))

- {

- user_notification($mode, stripslashes($subject), stripslashes($data['topic_title']), stripslashes($data['forum_name']), $data['forum_id'], $data['topic_id'], $data['post_id']);

- }

-

- if ($mode == 'post')

- {

- $url = (!$auth->acl_get('f_moderate', $data['forum_id']) || $auth->acl_get('m_approve', $data['forum_id'])) ? "{$phpbb_root_path}viewtopic.$phpEx$SID&amp;f=" . $data['forum_id'] . '&amp;t=' . $data['topic_id'] : "{$phpbb_root_path}viewforum.$phpEx$SID&amp;f=" . $data['forum_id'];

- }

- else

- $url = (!$auth->acl_get('f_moderate', $data['forum_id']) || $auth->acl_get('m_approve', $data['forum_id'])) ? "{$phpbb_root_path}viewtopic.$phpEx$SID&amp;f={$data['forum_id']}&amp;t={$data['topic_id']}&amp;p={$data['post_id']}#p{$data['post_id']}" : "{$phpbb_root_path}viewtopic.$phpEx$SID&amp;f={$data['forum_id']}&amp;t={$data['topic_id']}";

- meta_refresh(3, $url);

-

- $message = ($auth->acl_get('f_moderate', $data['forum_id']) && !$auth->acl_get('m_approve', $data['forum_id'])) ? (($mode == 'edit') ? 'POST_EDITED_MOD' : 'POST_STORED_MOD') : (($mode == 'edit') ? 'POST_EDITED' : 'POST_STORED');

- $message = $user->lang[$message] . ((!$auth->acl_get('f_moderate', $data['forum_id']) || $auth->acl_get('m_approve', $data['forum_id'])) ? '<br /><br />' . sprintf($user->lang['VIEW_MESSAGE'], '<a href="' . $url . '">', '</a>') : '') . '<br /><br />' . sprintf($user->lang['RETURN_FORUM'], '<a href="viewforum.' . $phpEx . $SID .'&amp;f=' . $data['forum_id'] . '">', '</a>');

- trigger_error($message);

-}

-

-function upload_popup($forum_style = 0)

-{

- global $template, $user;

-

- ($forum_style) ? $user->setup('posting', $forum_style) : $user->setup('posting');

-

- page_header('PROGRESS_BAR');

-

- $template->set_filenames(array(

- 'popup' => 'posting_progress_bar.html')

- );

-

- $template->assign_vars(array(

- 'PROGRESS_BAR' => $user->img('attach_progress_bar', $user->lang['UPLOAD_IN_PROGRESS']))

- );

-

- $template->display('popup');