+ $update_sql = $empty_forums = $not_empty_forums = array();

+ if (sizeof($ids) == 1)

+ {

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

+ FROM ' . POSTS_TABLE . '

+ WHERE ' . $db->sql_in_set($type . '_id', $ids) . '

+ AND post_approved = 1';

+ }

+ else

+ {

+ $sql = 'SELECT ' . $type . '_id, MAX(post_id) as last_post_id

+ FROM ' . POSTS_TABLE . '

+ WHERE ' . $db->sql_in_set($type . '_id', $ids) . "

+ AND post_approved = 1

+ GROUP BY {$type}_id";

+ }

+ if (sizeof($ids) == 1)

+ {

+ $row[$type . '_id'] = $ids[0];

+ }

+

+ $not_empty_forums[] = $row['forum_id'];

+

+ if (empty($row['last_post_id']))

+ {

+ $empty_forums[] = $row['forum_id'];

+ }

+ $empty_forums = array_merge($empty_forums, array_diff($ids, $not_empty_forums));

+ $update_sql[$forum_id][] = "forum_last_post_subject = ''";

+ $update_sql[$forum_id][] = 'forum_last_post_time = 0';

+ $update_sql[$forum_id][] = "forum_last_poster_colour = ''";

+ $sql = 'SELECT p.' . $type . '_id, p.post_id, p.post_subject, p.post_time, p.poster_id, p.post_username, u.user_id, u.username, u.user_colour

+ $update_sql[$row["{$type}_id"]][] = "{$type}_last_post_subject = '" . $db->sql_escape($row['post_subject']) . "'";

+ $update_sql[$row["{$type}_id"]][] = "{$type}_last_poster_colour = '" . $db->sql_escape($row['user_colour']) . "'";

+ $icons = $cache->obtain_icons();

+ $filedata['error'][] = $user->lang['NO_UPLOAD_FORM_FOUND'];

+ $extensions = $cache->obtain_attach_extensions($forum_id);

+ // Make sure the image category only holds valid images...

+ if ($cat_id == ATTACHMENT_CATEGORY_IMAGE && !$file->is_image())

+ {

+ $file->remove();

+

+ // If this error occurs a user tried to exploit an IE Bug by renaming extensions

+ // Since the image category is displaying content inline we need to catch this.

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

+ }

+

+ global $config;

+

+ $max_width = ($config['img_max_thumb_width']) ? $config['img_max_thumb_width'] : 400;

+ @passthru(escapeshellcmd($config['img_imagick']) . 'convert' . ((defined('PHP_OS') && preg_match('#^win#i', PHP_OS)) ? '.exe' : '') . ' -quality 85 -antialias -sample ' . $new_width . 'x' . $new_height . ' "' . str_replace('\\', '/', $source) . '" +profile "*" "' . str_replace('\\', '/', $destination) . '"');

+

+ $s_inline_attachment_options .= '<option value="' . $i . '">' . basename($attachment['real_filename']) . '</option>';

+ global $template, $config, $phpbb_root_path, $phpEx, $user;

+ $download_link = append_sid("{$phpbb_root_path}download.$phpEx", 'id=' . (int) $attach_row['attach_id'], false, ($attach_row['is_orphan']) ? $user->session_id : false);

+ 'S_IS_ORPHAN' => $attach_row['is_orphan'],

+ if (!isset($bbcode) && $bbcode_bitfield !== '')

+ $bbcode = new bbcode(base64_encode($bbcode_bitfield));

+ $message = censor_text($message);

+ $message = str_replace("\n", '<br />', $message);

+ 'MESSAGE' => $message,

+ 'POSTER_QUOTE' => ($show_quote_button && $auth->acl_get('f_reply', $forum_id)) ? addslashes($poster) : '')

+ $topic_notification = ($mode == 'reply' || $mode == 'quote') ? true : false;

+ $forum_notification = ($mode == 'post') ? true : false;

+ 'USERNAME' => htmlspecialchars_decode($addr['name']),

+ 'TOPIC_TITLE' => htmlspecialchars_decode($topic_title),

+ 'FORUM_NAME' => htmlspecialchars_decode($forum_name),

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

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

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

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

+ 'topic_first_poster_colour' => (($user->data['user_id'] != ANONYMOUS) ? $user->data['user_colour'] : ''),

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

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

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

+ 'topic_last_poster_colour' => (($user->data['user_id'] != ANONYMOUS) ? $user->data['user_colour'] : ''),

+ $db->sql_multi_insert(POLL_OPTIONS_TABLE, $sql_insert_ary);

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

+ $orphan_rows = array();

+ $orphan_rows[(int) $attach_row['attach_id']] = array();

+ }

+

+ if (sizeof($orphan_rows))

+ {

+ $sql = 'SELECT attach_id, filesize, physical_filename

+ FROM ' . ATTACHMENTS_TABLE . '

+ WHERE ' . $db->sql_in_set('attach_id', array_keys($orphan_rows)) . '

+ AND is_orphan = 1

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

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

+

+ $orphan_rows = array();

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

+ {

+ $orphan_rows[$row['attach_id']] = $row;

+ }

+ $db->sql_freeresult($result);

+ }

+

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

+ {

+ if ($attach_row['is_orphan'] && !in_array($attach_row['attach_id'], array_keys($orphan_rows)))

+ {

+ continue;

+ }

+

+ if (!$attach_row['is_orphan'])

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

+ AND is_orphan = 0';

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

+ $space_taken += $orphan_rows[$attach_row['attach_id']]['filesize'];

+ $files_added++;

+

+ 'is_orphan' => 0,

+ $sql = 'UPDATE ' . ATTACHMENTS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $attach_sql) . '

+ WHERE attach_id = ' . $attach_row['attach_id'] . '

+ AND is_orphan = 1

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

+ if ($space_taken && $files_added)

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

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

+ require_once("{$phpbb_root_path}includes/search/$search_type.$phpEx");

+ $search->index($mode, $data['post_id'], $data['message'], $subject, $poster_id, ($topic_type == POST_GLOBAL) ? 0 : $data['forum_id']);

+ if (($config['load_db_lastread'] && $user->data['is_registered']) || $config['load_anon_lastread'] || $user->data['is_registered'])