+ function update_forum_data(&$forum_data_ary)

+ $forum_data = $forum_data_ary;

+ * @var array forum_data Array with new forum data

+ $vars = array('forum_data', 'errors');

+ $forum_data_ary = $forum_data;

+ unset($forum_data);

+ if ($forum_data_ary['forum_name'] == '')

+ if (utf8_strlen($forum_data_ary['forum_desc']) > 4000)

+ if (utf8_strlen($forum_data_ary['forum_rules']) > 4000)

+ if ($forum_data_ary['forum_password'] || $forum_data_ary['forum_password_confirm'])

+ if ($forum_data_ary['forum_password'] != $forum_data_ary['forum_password_confirm'])

+ $forum_data_ary['forum_password'] = $forum_data_ary['forum_password_confirm'] = '';

+ if ($forum_data_ary['prune_days'] < 0 || $forum_data_ary['prune_viewed'] < 0 || $forum_data_ary['prune_freq'] < 0)

+ $forum_data_ary['prune_days'] = $forum_data_ary['prune_viewed'] = $forum_data_ary['prune_freq'] = 0;

+ array('lang' => 'FORUM_TOPICS_PAGE', 'value' => $forum_data_ary['forum_topics_per_page'], 'column_type' => 'TINT:0'),

+ if (!empty($forum_data_ary['forum_image']) && !file_exists($phpbb_root_path . $forum_data_ary['forum_image']))

+ $forum_data_ary['forum_flags'] = 0;

+ $forum_data_ary['forum_flags'] += ($forum_data_ary['forum_link_track']) ? FORUM_FLAG_LINK_TRACK : 0;

+ $forum_data_ary['forum_flags'] += ($forum_data_ary['prune_old_polls']) ? FORUM_FLAG_PRUNE_POLL : 0;

+ $forum_data_ary['forum_flags'] += ($forum_data_ary['prune_announce']) ? FORUM_FLAG_PRUNE_ANNOUNCE : 0;

+ $forum_data_ary['forum_flags'] += ($forum_data_ary['prune_sticky']) ? FORUM_FLAG_PRUNE_STICKY : 0;

+ $forum_data_ary['forum_flags'] += ($forum_data_ary['show_active']) ? FORUM_FLAG_ACTIVE_TOPICS : 0;

+ $forum_data_ary['forum_flags'] += ($forum_data_ary['enable_post_review']) ? FORUM_FLAG_POST_REVIEW : 0;

+ $forum_data_ary['forum_flags'] += ($forum_data_ary['enable_quick_reply']) ? FORUM_FLAG_QUICK_REPLY : 0;

+ $forum_data_sql = $forum_data_ary;

+ $forum_data = $forum_data_ary;

+ * @var array forum_data Array with forum data

+ $vars = array('forum_data', 'forum_data_sql');

+ $forum_data_ary = $forum_data;

+ unset($forum_data);

+ $forum_data_ary['forum_id'] = $db->sql_nextid();

+ $phpbb_log->add('admin', $user->data['user_id'], $user->ip, 'LOG_FORUM_ADD', false, array($forum_data_ary['forum_name']));

+ $forum_data_ary['forum_id'] = $forum_id;

+ $phpbb_log->add('admin', $user->data['user_id'], $user->ip, 'LOG_FORUM_EDIT', false, array($forum_data_ary['forum_name']));

+ $forum_data = $forum_data_ary;

+ * @var array forum_data Array with forum data

+ $vars = array('forum_data', 'forum_data_sql', 'is_new_forum', 'errors');

+ $forum_data_ary = $forum_data;

+ unset($forum_data);

+function build_cfg_template($tpl_type, $key, &$new_ary, $config_key, $vars)

+ if (!isset($new_ary[$config_key]))

+ $new_ary[$config_key] = '';

+ if ($new_ary[$config_key] !== '')

+ $new_ary[$config_key] = '********';

+ $tpl = '<input id="' . $key . '" type="' . $tpl_type[0] . '"' . (($size) ? ' size="' . $size . '"' : '') . ' maxlength="' . (($maxlength) ? $maxlength : 255) . '" name="' . $name . '" value="' . $new_ary[$config_key] . '"' . (($tpl_type[0] === 'password') ? ' autocomplete="off"' : '') . ' />';

+ $tpl = '<input id="' . $key . '" type="number" maxlength="' . (( $maxlength != '' ) ? $maxlength : 255) . '"' . (( $min != '' ) ? ' min="' . $min . '"' : '') . (( $max != '' ) ? ' max="' . $max . '"' : '') . ' name="' . $name . '" value="' . $new_ary[$config_key] . '" />';

+ $tpl = '<input id="' . $key . '" type="number"' . (( $size != '' ) ? ' size="' . $size . '"' : '') . ' maxlength="' . (($maxlength != '') ? $maxlength : 255) . '"' . (( $min !== '' ) ? ' min="' . $min . '"' : '') . (( $max != '' ) ? ' max="' . $max . '"' : '') . ' name="config[' . $config_key . '_width]" value="' . $new_ary[$config_key . '_width'] . '" /> x <input type="number"' . (( $size != '' ) ? ' size="' . $size . '"' : '') . ' maxlength="' . (($maxlength != '') ? $maxlength : 255) . '"' . (( $min !== '' ) ? ' min="' . $min . '"' : '') . (( $max != '' ) ? ' max="' . $max . '"' : '') . ' name="config[' . $config_key . '_height]" value="' . $new_ary[$config_key . '_height'] . '" />';

+ $tpl = '<textarea id="' . $key . '" name="' . $name . '" rows="' . $rows . '" cols="' . $cols . '">' . $new_ary[$config_key] . '</textarea>';

+ $key_yes = ($new_ary[$config_key]) ? ' checked="checked"' : '';

+ $key_no = (!$new_ary[$config_key]) ? ' checked="checked"' : '';

+ $value = $new_ary[$config_key];

+ $args = array($new_ary[$config_key], $key);

+ $new = $new_ary;

+ * @var array new Array with the config values we display

+ $vars = array('tpl_type', 'key', 'new', 'name', 'vars', 'tpl');

+ $new_ary = $new;

+ unset($new);

+* @param array &$update_count_ary The attachment counts to be updated - will be filled

+function parse_attachments($forum_id, &$message, &$attachments, &$update_count_ary, $preview = false)

+ $update_count_ary[] = $attachment['attach_id'];

+ $update_count_ary[] = $attachment['attach_id'];

+ $update_count_ary[] = $attachment['attach_id'];

+ $update_count = $update_count_ary;

+ * @var array update_count Array with attachment ids to update download count

+ 'update_count',

+ $update_count_ary = $update_count;

+ unset($update_count);

+function generate_forum_nav(&$forum_data_ary)

+ if (!$auth->acl_get('f_list', $forum_data_ary['forum_id']))

+ $forum_parents = get_forum_parents($forum_data_ary);

+ 'S_IS_CAT' => ($forum_data_ary['forum_type'] == FORUM_CAT) ? true : false,

+ 'S_IS_LINK' => ($forum_data_ary['forum_type'] == FORUM_LINK) ? true : false,

+ 'S_IS_POST' => ($forum_data_ary['forum_type'] == FORUM_POST) ? true : false,

+ 'FORUM_NAME' => $forum_data_ary['forum_name'],

+ 'FORUM_ID' => $forum_data_ary['forum_id'],

+ 'MICRODATA' => $microdata_attr . '="' . $forum_data_ary['forum_id'] . '"',

+ 'U_VIEW_FORUM' => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_data_ary['forum_id']),

+ 'FORUM_ID' => $forum_data_ary['forum_id'],

+ 'FORUM_NAME' => $forum_data_ary['forum_name'],

+ 'FORUM_DESC' => generate_text_for_display($forum_data_ary['forum_desc'], $forum_data_ary['forum_desc_uid'], $forum_data_ary['forum_desc_bitfield'], $forum_data_ary['forum_desc_options']),

+ 'S_ENABLE_FEEDS_FORUM' => ($config['feed_forum'] && $forum_data_ary['forum_type'] == FORUM_POST && !phpbb_optionget(FORUM_OPTION_FEED_EXCLUDE, $forum_data_ary['forum_options'])) ? true : false,

+ $forum_data = $forum_data_ary;

+ * @var array forum_data Array with the forum data

+ 'forum_data',

+ $forum_data_ary = $forum_data;

+ unset($forum_data);

+function display_user_activity(&$userdata_ary)

+ if ($userdata_ary['user_posts'] > 5000)

+ WHERE poster_id = ' . $userdata_ary['user_id'] . '

+ WHERE poster_id = ' . $userdata_ary['user_id'] . '

+ $userdata = $userdata_ary;

+ * @var array userdata User's data

+ $vars = array('userdata', 'active_f_row', 'active_t_row');

+ $userdata_ary = $userdata;

+ unset($userdata);

+ $userdata_ary['active_t_row'] = $active_t_row;

+ $userdata_ary['active_f_row'] = $active_f_row;

+ $active_f_pct = ($userdata_ary['user_posts']) ? ($active_f_count / $userdata_ary['user_posts']) * 100 : 0;

+ $active_t_pct = ($userdata_ary['user_posts']) ? ($active_t_count / $userdata_ary['user_posts']) * 100 : 0;

+ $l_active_pct = ($userdata_ary['user_id'] != ANONYMOUS && $userdata_ary['user_id'] == $user->data['user_id']) ? $user->lang['POST_PCT_ACTIVE_OWN'] : $user->lang['POST_PCT_ACTIVE'];

+function phpbb_mcp_sorting($mode, &$sort_days_val, &$sort_key_val, &$sort_dir_val, &$sort_by_sql_ary, &$sort_order_sql, &$total_val, $forum_id = 0, $topic_id = 0, $where_sql = 'WHERE')

+ $sort_days_val = $request->variable('st', 0);

+ $min_time = ($sort_days_val) ? time() - ($sort_days_val * 86400) : 0;

+ $sort_key_val = $request->variable('sk', $default_key);

+ $sort_dir_val = $request->variable('sd', $default_dir);

+ $sort_by_sql_ary = array('a' => 't.topic_first_poster_name', 't' => array('t.topic_last_post_time', 't.topic_last_post_id'), 'tt' => 't.topic_time', 'r' => (($auth->acl_get('m_approve', $forum_id)) ? 't.topic_posts_approved + t.topic_posts_unapproved + t.topic_posts_softdeleted' : 't.topic_posts_approved'), 's' => 't.topic_title', 'v' => 't.topic_views');

+ $sort_by_sql_ary = array('a' => 'u.username_clean', 't' => array('p.post_time', 'p.post_id'), 's' => 'p.post_subject');

+ $sort_by_sql_ary = array('a' => 'u.username_clean', 'r' => 'ru.username', 'p' => array('p.post_time', 'p.post_id'), 't' => 'r.report_time', 's' => 'p.post_subject');

+ $sort_by_sql_ary = array('a' => 'u.username_clean', 'r' => 'ru.username', 'p' => 'p.message_time', 't' => 'r.report_time', 's' => 'p.message_subject');

+ $sort_by_sql_ary = array('u' => 'u.username_clean', 't' => 'l.log_time', 'i' => 'l.log_ip', 'o' => 'l.log_operation');

+ $total_val = -1;

+ $sort_by_sql = $sort_by_sql_ary;

+ $sort_days = $sort_days_val;

+ $sort_dir = $sort_dir_val;

+ $sort_key = $sort_key_val;

+ $total = $total_val;

+ * @var int sort_days The max age of the oldest report to be shown, in days

+ * @var string sort_key The way the user has decided to sort the data.

+ * @var string sort_dir Either 'd' for "DESC" or 'a' for 'ASC' in the SQL query

+ * @var array sort_by_sql SQL text (values) for the possible names of the ways of sorting data (keys).

+ * @var int total The total number of reports that exist. Only set if you want to override the result

+ 'sort_days',

+ 'sort_key',

+ 'sort_dir',

+ 'sort_by_sql',

+ 'total',

+ $sort_by_sql_ary = $sort_by_sql;

+ $sort_days_val = $sort_days;

+ $sort_key_val = $sort_key;

+ $sort_dir_val = $sort_dir;

+ $total_val = $total;

+ unset($sort_by_sql);

+ unset($sort_days);

+ unset($sort_key);

+ unset($sort_dir);

+ unset($total);

+ if (!isset($sort_by_sql_ary[$sort_key_val]))

+ $sort_key_val = $default_key;

+ $direction = ($sort_dir_val == 'd') ? 'DESC' : 'ASC';

+ if (is_array($sort_by_sql_ary[$sort_key_val]))

+ $sort_order_sql = implode(' ' . $direction . ', ', $sort_by_sql_ary[$sort_key_val]) . ' ' . $direction;

+ $sort_order_sql = $sort_by_sql_ary[$sort_key_val] . ' ' . $direction;

+ gen_sort_selects($limit_days, $sort_by_text, $sort_days_val, $sort_key_val, $sort_dir_val, $s_limit_days, $s_sort_key, $s_sort_dir, $sort_url);

+ if (($sort_days_val && $mode != 'viewlogs') || in_array($mode, array('reports', 'unapproved_topics', 'unapproved_posts', 'deleted_topics', 'deleted_posts')) || $where_sql != 'WHERE')

+ $total_val = (int) $db->sql_fetchfield('total');

+ else if ($total_val < -1)

+ $total_val = -1;

+function submit_post($mode, $subject, $username, $topic_type, &$poll_ary, &$data_ary, $update_message = true, $update_search_index = true)

+ $poll = $poll_ary;

+ $data = $data_ary;

+ * @var array poll Array with the poll data for the post

+ * @var array data Array with the data for the post

+ 'poll',

+ 'data',

+ $poll_ary = $poll;

+ $data_ary = $data;

+ unset($poll);

+ unset($data);

+ if (!empty($data_ary['post_time']))

+ $current_time = $data_ary['post_time'];

+ $post_mode = ($data_ary['topic_posts_approved'] + $data_ary['topic_posts_unapproved'] + $data_ary['topic_posts_softdeleted'] == 1) ? 'edit_topic' : (($data_ary['topic_first_post_id'] == $data_ary['post_id']) ? 'edit_first_post' : (($data_ary['topic_last_post_id'] == $data_ary['post_id']) ? 'edit_last_post' : 'edit'));

+ $data_ary['topic_title'] = truncate_string($data_ary['topic_title'], 120);

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

+ if ($mode == 'edit' && (!isset($data_ary['post_visibility']) || !isset($data_ary['topic_visibility']) || $data_ary['post_visibility'] === false || $data_ary['topic_visibility'] === false))

+ AND p.post_id = ' . $data_ary['post_id'];

+ $data_ary['topic_visibility'] = $topic_row['topic_visibility'];

+ $data_ary['post_visibility'] = $topic_row['post_visibility'];

+ if (!$auth->acl_get('f_noapprove', $data_ary['forum_id']))

+ if (isset($data_ary['force_approved_state']))

+ $post_visibility = (in_array((int) $data_ary['force_approved_state'], array(ITEM_APPROVED, ITEM_UNAPPROVED, ITEM_DELETED, ITEM_REAPPROVE))) ? (int) $data_ary['force_approved_state'] : $post_visibility;

+ if (isset($data_ary['force_visibility']))

+ $post_visibility = (in_array((int) $data_ary['force_visibility'], array(ITEM_APPROVED, ITEM_UNAPPROVED, ITEM_DELETED, ITEM_REAPPROVE))) ? (int) $data_ary['force_visibility'] : $post_visibility;

+ 'forum_id' => $data_ary['forum_id'],

+ 'icon_id' => $data_ary['icon_id'],

+ 'enable_bbcode' => $data_ary['enable_bbcode'],

+ 'enable_smilies' => $data_ary['enable_smilies'],

+ 'enable_magic_url' => $data_ary['enable_urls'],

+ 'enable_sig' => $data_ary['enable_sig'],

+ 'post_text' => $data_ary['message'],

+ 'post_checksum' => $data_ary['message_md5'],

+ 'post_attachment' => (!empty($data_ary['attachment_data'])) ? 1 : 0,

+ 'bbcode_bitfield' => $data_ary['bbcode_bitfield'],

+ 'bbcode_uid' => $data_ary['bbcode_uid'],

+ 'post_postcount' => ($auth->acl_get('f_postcount', $data_ary['forum_id'])) ? 1 : 0,

+ 'post_edit_locked' => $data_ary['post_edit_locked']

+ if ($data_ary['post_edit_reason'] || (!$auth->acl_get('m_edit', $data_ary['forum_id']) && ($post_mode == 'edit' || $post_mode == 'edit_first_post')))

+ $data_ary['post_edit_reason'] = truncate_string($data_ary['post_edit_reason'], 255, 255, false);

+ 'post_edit_reason' => $data_ary['post_edit_reason'],

+ 'post_edit_user' => (int) $data_ary['post_edit_user'],

+ else if (!$data_ary['post_edit_reason'] && $mode == 'edit' && $auth->acl_get('m_edit', $data_ary['forum_id']))

+ $log_subject = ($subject) ? $subject : $data_ary['topic_title'];

+ 'forum_id' => $data_ary['forum_id'],

+ 'topic_id' => $data_ary['topic_id'],

+ 'post_id' => $data_ary['post_id'],

+ $data_ary['post_edit_reason']

+ 'forum_id' => $data_ary['forum_id'],

+ 'poster_id' => $data_ary['poster_id'],

+ 'icon_id' => $data_ary['icon_id'],

+ 'enable_bbcode' => $data_ary['enable_bbcode'],

+ 'enable_smilies' => $data_ary['enable_smilies'],

+ 'enable_magic_url' => $data_ary['enable_urls'],

+ 'enable_sig' => $data_ary['enable_sig'],

+ 'post_username' => ($username && $data_ary['poster_id'] == ANONYMOUS) ? $username : '',

+ 'post_checksum' => $data_ary['message_md5'],

+ 'post_attachment' => (!empty($data_ary['attachment_data'])) ? 1 : 0,

+ 'bbcode_bitfield' => $data_ary['bbcode_bitfield'],

+ 'bbcode_uid' => $data_ary['bbcode_uid'],

+ 'post_edit_locked' => $data_ary['post_edit_locked'])

+ $sql_data[POSTS_TABLE]['sql']['post_text'] = $data_ary['message'];

+ 'forum_id' => $data_ary['forum_id'],

+ 'icon_id' => $data_ary['icon_id'],

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

+ 'topic_attachment' => (!empty($data_ary['attachment_data'])) ? 1 : 0,

+ 'topic_status' => (isset($data_ary['topic_status'])) ? $data_ary['topic_status'] : ITEM_UNLOCKED,

+ if (isset($poll_ary['poll_options']) && !empty($poll_ary['poll_options']))

+ $poll_start = ($poll_ary['poll_start']) ? $poll_ary['poll_start'] : $current_time;

+ $poll_length = $poll_ary['poll_length'] * 86400;

+ 'poll_title' => $poll_ary['poll_title'],

+ 'poll_max_options' => $poll_ary['poll_max_options'],

+ 'poll_vote_change' => $poll_ary['poll_vote_change'])

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

+ ((!empty($data_ary['attachment_data']) || (isset($data_ary['topic_attachment']) && $data_ary['topic_attachment'])) ? ', topic_attachment = 1' : '');

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

+ if (isset($poll_ary['poll_options']))

+ $poll_start = ($poll_ary['poll_start'] || empty($poll_ary['poll_options'])) ? $poll_ary['poll_start'] : $current_time;

+ $poll_length = $poll_ary['poll_length'] * 86400;

+ 'forum_id' => $data_ary['forum_id'],

+ 'icon_id' => $data_ary['icon_id'],

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

+ 'poll_title' => (isset($poll_ary['poll_options'])) ? $poll_ary['poll_title'] : '',

+ 'poll_start' => (isset($poll_ary['poll_options'])) ? $poll_start : 0,

+ 'poll_max_options' => (isset($poll_ary['poll_options'])) ? $poll_ary['poll_max_options'] : 1,

+ 'poll_length' => (isset($poll_ary['poll_options'])) ? $poll_length : 0,

+ 'poll_vote_change' => (isset($poll_ary['poll_vote_change'])) ? $poll_ary['poll_vote_change'] : 0,

+ 'topic_attachment' => (!empty($data_ary['attachment_data'])) ? 1 : (isset($data_ary['topic_attachment']) ? $data_ary['topic_attachment'] : 0),

+ $poll = $poll_ary;

+ $data = $data_ary;

+ 'data',

+ 'poll',

+ $poll_ary = $poll;

+ $data_ary = $data;

+ unset($poll);

+ unset($data);

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

+ 'topic_id' => $data_ary['topic_id'])

+ 'topic_id' => $data_ary['topic_id'],

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

+ 'topic_last_post_id' => $data_ary['post_id'],

+ $sql_data[TOPICS_TABLE]['sql']['topic_first_post_id'] = $data_ary['post_id'];

+ $sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_id = ' . $data_ary['post_id'];

+ WHERE topic_id = ' . $data_ary['topic_id'];

+ WHERE post_id = ' . $data_ary['post_id'];

+ if (isset($poll_ary['poll_options']))

+ WHERE topic_id = ' . $data_ary['topic_id'] . '

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

+ if (strlen(trim($poll_ary['poll_options'][$i])))

+ 'topic_id' => (int) $data_ary['topic_id'],

+ 'poll_option_text' => (string) $poll_ary['poll_options'][$i]

+ else if ($poll_ary['poll_options'][$i] != $cur_poll_options[$i])

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

+ AND topic_id = ' . $data_ary['topic_id'];

+ if (sizeof($poll_ary['poll_options']) < sizeof($cur_poll_options))

+ WHERE poll_option_id > ' . sizeof($poll_ary['poll_options']) . '

+ AND topic_id = ' . $data_ary['topic_id'];

+ if ($mode == 'edit' && sizeof($poll_ary['poll_options']) != sizeof($cur_poll_options))

+ $db->sql_query('DELETE FROM ' . POLL_VOTES_TABLE . ' WHERE topic_id = ' . $data_ary['topic_id']);

+ $db->sql_query('UPDATE ' . POLL_OPTIONS_TABLE . ' SET poll_option_total = 0 WHERE topic_id = ' . $data_ary['topic_id']);

+ if (!empty($data_ary['attachment_data']) && $data_ary['post_id'] && in_array($mode, array('post', 'reply', 'quote', 'edit')))

+ foreach ($data_ary['attachment_data'] as $pos => $attach_row)

+ foreach ($data_ary['attachment_data'] as $pos => $attach_row)

+ 'post_msg_id' => $data_ary['post_id'],

+ 'topic_id' => $data_ary['topic_id'],

+ (($post_visibility == ITEM_DELETED && $data_ary['topic_posts_softdeleted'] == 1) ||

+ ($post_visibility == ITEM_UNAPPROVED && $data_ary['topic_posts_unapproved'] == 1) ||

+ ($post_visibility == ITEM_REAPPROVE && $data_ary['topic_posts_unapproved'] == 1) ||

+ ($post_visibility == ITEM_APPROVED && $data_ary['topic_posts_approved'] == 1)));

+ if (($post_mode != 'post' && $post_mode != 'reply') && $data_ary['post_visibility'] != $post_visibility)

+ $is_starter = ($post_mode == 'edit_first_post' || $post_mode == 'edit_topic' || $data_ary['post_visibility'] != ITEM_APPROVED);

+ $is_latest = ($post_mode == 'edit_last_post' || $post_mode == 'edit_topic' || $data_ary['post_visibility'] != ITEM_APPROVED);

+ $phpbb_content_visibility->set_post_visibility($post_visibility, $data_ary['post_id'], $data_ary['topic_id'], $data_ary['forum_id'], $user->data['user_id'], time(), '', $is_starter, $is_latest);

+ if ($post_visibility == ITEM_APPROVED || $data_ary['topic_visibility'] == $post_visibility)

+ if ($data_ary['poster_id'] == ANONYMOUS)

+ WHERE forum_id = ' . (int) $data_ary['forum_id'];

+ if ($row['forum_last_post_id'] == $data_ary['post_id'] && ($row['forum_last_post_subject'] !== $subject || $data_ary['poster_id'] == ANONYMOUS))

+ if ($data_ary['poster_id'] == ANONYMOUS)

+ POSTS_TABLE => 'post_id = ' . $data_ary['post_id'],

+ TOPICS_TABLE => 'topic_id = ' . $data_ary['topic_id'],

+ FORUMS_TABLE => 'forum_id = ' . $data_ary['forum_id'],

+ WHERE topic_moved_id = ' . $data_ary['topic_id'];

+ if ($update_search_index && $data_ary['enable_indexing'])

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

+ if (!$data_ary['notify_set'] && $data_ary['notify'])

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

+ else if (($config['email_enable'] || $config['jab_enable']) && $data_ary['notify_set'] && !$data_ary['notify'])

+ AND topic_id = ' . $data_ary['topic_id'];

+ markread('post', $data_ary['forum_id'], $data_ary['topic_id']);

+ markread('topic', $data_ary['forum_id'], $data_ary['topic_id'], time());

+ AND forum_id = ' . $data_ary['forum_id'];

+ WHERE forum_id = ' . $data_ary['forum_id'];

+ update_forum_tracking_info($data_ary['forum_id'], $forum_last_post_time, $f_mark_time, false);

+ $notification_data = array_merge($data_ary, array(

+ 'topic_title' => (isset($data_ary['topic_title'])) ? $data_ary['topic_title'] : $subject,

+ 'post_text' => $data_ary['message'],

+ $params .= '&amp;t=' . $data_ary['topic_id'];

+ $params .= '&amp;p=' . $data_ary['post_id'];

+ $add_anchor = '#p' . $data_ary['post_id'];

+ $params .= '&amp;t=' . $data_ary['topic_id'];

+ $url = append_sid($url, 'f=' . $data_ary['forum_id'] . $params) . $add_anchor;

+ $poll = $poll_ary;

+ $data = $data_ary;

+ * @var array poll Array with the poll data for the post

+ * @var array data Array with the data for the post

+ 'poll',

+ 'data',

+ $data_ary = $data;

+ $poll_ary = $poll;

+ unset($data);

+ unset($poll);

+function submit_pm($mode, $subject, &$data_ary, $put_in_outbox = true)

+ $data = $data_ary;

+ * @var array data The whole row data of the PM.

+ $vars = array('mode', 'subject', 'data');

+ $data_ary = $data;

+ unset($data);

+ if (isset($data_ary['address_list'][$ug_type]) && sizeof($data_ary['address_list'][$ug_type]))

+ foreach ($data_ary['address_list'][$ug_type] as $id => $field)

+ if (isset($data_ary['address_list']['g']) && sizeof($data_ary['address_list']['g']))

+ WHERE ' . $db->sql_in_set('ug.group_id', array_keys($data_ary['address_list']['g'])) . '

+ $field = ($data_ary['address_list']['g'][$row['group_id']] == 'to') ? 'to' : 'bcc';

+ $root_level = ($data_ary['reply_from_root_level']) ? $data_ary['reply_from_root_level'] : $data_ary['reply_from_msg_id'];

+ WHERE user_id = ' . $data_ary['from_user_id'] . '

+ AND msg_id = ' . $data_ary['reply_from_msg_id'];

+ 'author_id' => $data_ary['from_user_id'],

+ 'icon_id' => $data_ary['icon_id'],

+ 'author_ip' => $data_ary['from_user_ip'],

+ 'enable_bbcode' => $data_ary['enable_bbcode'],

+ 'enable_smilies' => $data_ary['enable_smilies'],

+ 'enable_magic_url' => $data_ary['enable_urls'],

+ 'enable_sig' => $data_ary['enable_sig'],

+ 'message_text' => $data_ary['message'],

+ 'message_attachment'=> (!empty($data_ary['attachment_data'])) ? 1 : 0,

+ 'bbcode_bitfield' => $data_ary['bbcode_bitfield'],

+ 'bbcode_uid' => $data_ary['bbcode_uid'],

+ 'icon_id' => $data_ary['icon_id'],

+ 'enable_bbcode' => $data_ary['enable_bbcode'],

+ 'enable_smilies' => $data_ary['enable_smilies'],

+ 'enable_magic_url' => $data_ary['enable_urls'],

+ 'enable_sig' => $data_ary['enable_sig'],

+ 'message_text' => $data_ary['message'],

+ 'message_attachment'=> (!empty($data_ary['attachment_data'])) ? 1 : 0,

+ 'bbcode_bitfield' => $data_ary['bbcode_bitfield'],

+ 'bbcode_uid' => $data_ary['bbcode_uid']

+ $data_ary['msg_id'] = $db->sql_nextid();

+ WHERE msg_id = ' . $data_ary['msg_id'];

+ 'msg_id' => (int) $data_ary['msg_id'],

+ 'author_id' => (int) $data_ary['from_user_id'],

+ 'msg_id' => (int) $data_ary['msg_id'],

+ 'user_id' => (int) $data_ary['from_user_id'],

+ 'author_id' => (int) $data_ary['from_user_id'],

+ WHERE user_id = " . $data_ary['from_user_id'];

+ if (!empty($data_ary['attachment_data']) && $data_ary['msg_id'] && in_array($mode, array('post', 'reply', 'quote', 'quotepost', 'edit', 'forward')))

+ foreach ($data_ary['attachment_data'] as $pos => $attach_row)

+ foreach ($data_ary['attachment_data'] as $pos => $attach_row)

+ 'post_msg_id' => $data_ary['msg_id'],

+ 'poster_id' => $data_ary['from_user_id'],

+ AND user_id = " . $data_ary['from_user_id'];

+ $pm_data = array_merge($data_ary, array(

+ $data = $data_ary;

+ $vars = array('mode', 'subject', 'data', 'pm_data');

+ $data_ary = $data;

+ unset($data);

+ return $data_ary['msg_id'];

+ while ($row_ary = $db->sql_fetchrow($result))

+ $topic_list[] = $row_ary['topic_id'];

+ while ($row_ary = $db->sql_fetchrow($result))

+ $topic_rows[$row_ary['topic_id']] = $row_ary;

+ $row_ary = &$topic_rows[$topic_id];

+ $replies = $phpbb_content_visibility->get_count('topic_posts', $row_ary, $forum_id) - 1;

+ if ($row_ary['topic_status'] == ITEM_MOVED)

+ $unread_topic = (isset($topic_tracking_info[$topic_id]) && $row_ary['topic_last_post_time'] > $topic_tracking_info[$topic_id]) ? true : false;

+ topic_status($row_ary, $replies, $unread_topic, $folder_img, $folder_alt, $topic_type);

+ $topic_title = censor_text($row_ary['topic_title']);

+ $topic_unapproved = (($row_ary['topic_visibility'] == ITEM_UNAPPROVED || $row_ary['topic_visibility'] == ITEM_REAPPROVE) && $auth->acl_get('m_approve', $row_ary['forum_id'])) ? true : false;

+ $posts_unapproved = ($row_ary['topic_visibility'] == ITEM_APPROVED && $row_ary['topic_posts_unapproved'] && $auth->acl_get('m_approve', $row_ary['forum_id'])) ? true : false;

+ $topic_deleted = $row_ary['topic_visibility'] == ITEM_DELETED;

+ $u_mcp_queue = ($topic_unapproved || $posts_unapproved) ? $url . '&amp;i=queue&amp;mode=' . (($topic_unapproved) ? 'approve_details' : 'unapproved_posts') . '&amp;t=' . $row_ary['topic_id'] : '';

+ 'ATTACH_ICON_IMG' => ($auth->acl_get('u_download') && $auth->acl_get('f_download', $row_ary['forum_id']) && $row_ary['topic_attachment']) ? $user->img('icon_topic_attach', $user->lang['TOTAL_ATTACHMENTS']) : '',

+ 'TOPIC_ICON_IMG' => (!empty($icons[$row_ary['icon_id']])) ? $icons[$row_ary['icon_id']]['img'] : '',

+ 'TOPIC_ICON_IMG_WIDTH' => (!empty($icons[$row_ary['icon_id']])) ? $icons[$row_ary['icon_id']]['width'] : '',

+ 'TOPIC_ICON_IMG_HEIGHT' => (!empty($icons[$row_ary['icon_id']])) ? $icons[$row_ary['icon_id']]['height'] : '',

+ 'TOPIC_AUTHOR' => get_username_string('username', $row_ary['topic_poster'], $row_ary['topic_first_poster_name'], $row_ary['topic_first_poster_colour']),

+ 'TOPIC_AUTHOR_COLOUR' => get_username_string('colour', $row_ary['topic_poster'], $row_ary['topic_first_poster_name'], $row_ary['topic_first_poster_colour']),

+ 'TOPIC_AUTHOR_FULL' => get_username_string('full', $row_ary['topic_poster'], $row_ary['topic_first_poster_name'], $row_ary['topic_first_poster_colour']),

+ 'U_TOPIC_AUTHOR' => get_username_string('profile', $row_ary['topic_poster'], $row_ary['topic_first_poster_name'], $row_ary['topic_first_poster_colour']),

+ 'LAST_POST_AUTHOR' => get_username_string('username', $row_ary['topic_last_poster_id'], $row_ary['topic_last_poster_name'], $row_ary['topic_last_poster_colour']),

+ 'LAST_POST_AUTHOR_COLOUR' => get_username_string('colour', $row_ary['topic_last_poster_id'], $row_ary['topic_last_poster_name'], $row_ary['topic_last_poster_colour']),

+ 'LAST_POST_AUTHOR_FULL' => get_username_string('full', $row_ary['topic_last_poster_id'], $row_ary['topic_last_poster_name'], $row_ary['topic_last_poster_colour']),

+ 'U_LAST_POST_AUTHOR' => get_username_string('profile', $row_ary['topic_last_poster_id'], $row_ary['topic_last_poster_name'], $row_ary['topic_last_poster_colour']),

+ 'REPLIES' => $phpbb_content_visibility->get_count('topic_posts', $row_ary, $row_ary['forum_id']) - 1,

+ 'LAST_POST_TIME' => $user->format_date($row_ary['topic_last_post_time']),

+ 'FIRST_POST_TIME' => $user->format_date($row_ary['topic_time']),

+ 'LAST_POST_SUBJECT' => $row_ary['topic_last_post_subject'],

+ 'LAST_VIEW_TIME' => $user->format_date($row_ary['topic_last_view_time']),

+ 'S_TOPIC_REPORTED' => (!empty($row_ary['topic_reported']) && empty($row_ary['topic_moved_id']) && $auth->acl_get('m_report', $row_ary['forum_id'])) ? true : false,

+ if ($row_ary['topic_status'] == ITEM_MOVED)

+ 'U_VIEW_TOPIC' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", "t={$row_ary['topic_moved_id']}"),

+ 'U_DELETE_TOPIC' => ($auth->acl_get('m_delete', $forum_id)) ? append_sid("{$phpbb_root_path}mcp.$phpEx", "i=$id&amp;f=$forum_id&amp;topic_id_list[]={$row_ary['topic_id']}&amp;mode=forum_view&amp;action=delete_topic") : '',

+ 'TOPIC_ID' => $row_ary['topic_moved_id'],

+ $u_select_topic = $url . "&amp;i=$id&amp;mode=forum_view&amp;action=$action&amp;to_topic_id=" . $row_ary['topic_id'] . $selected_ids;

+ $u_select_topic = $url . "&amp;i=$id&amp;mode=topic_view&amp;action=merge&amp;to_topic_id=" . $row_ary['topic_id'] . $selected_ids;

+ 'U_VIEW_TOPIC' => append_sid("{$phpbb_root_path}mcp.$phpEx", "i=$id&amp;f=$forum_id&amp;t={$row_ary['topic_id']}&amp;mode=topic_view"),

+ 'S_SELECT_TOPIC' => ($merge_select && !in_array($row_ary['topic_id'], $source_topic_ids)) ? true : false,

+ 'U_MCP_REPORT' => ($auth->acl_get('m_report', $forum_id)) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&amp;mode=topic_view&amp;t=' . $row_ary['topic_id'] . '&amp;action=reports') : '',

+ 'TOPIC_ID' => $row_ary['topic_id'],

+ 'S_TOPIC_CHECKED' => ($topic_id_list && in_array($row_ary['topic_id'], $topic_id_list)) ? true : false,

+ $row = $row_ary;

+ * @var array row Array with topic data

+ $vars = array('row', 'topic_row');

+ $row_ary = $row;

+ unset($row);