}

$db->sql_freeresult($result);

{

$root_path = (defined('PHPBB_USE_BOARD_URL_PATH') && PHPBB_USE_BOARD_URL_PATH) ? generate_board_url() . '/' : $phpbb_path_helper->get_web_root_path();

$topic_condition = '';

}

{

$sql = 'SELECT MAX(p.post_id) as last_post_id

FROM ' . POSTS_TABLE . " p $topic_join

$last_post_ids = array();

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

{

{

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

}

}

}

{

$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

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

}

unset($empty_forums, $ids, $last_post_ids);

{

return $update_sql;

}

$template->assign_var('S_NO_ICON_CHECKED', ' checked="checked"');

}

{

$root_path = (defined('PHPBB_USE_BOARD_URL_PATH') && PHPBB_USE_BOARD_URL_PATH) ? generate_board_url() . '/' : $phpbb_root_path;

{

global $template;

{

$s_inline_attachment_options = '';

// Some default template variables

$template->assign_vars(array(

'S_SHOW_ATTACH_BOX' => $show_attach_box,

'FILESIZE' => $config['max_filesize'],

'FILE_COMMENT' => (isset($filename_data['filecomment'])) ? $filename_data['filecomment'] : '',

));

{

// We display the posted attachments within the desired order.

($config['display_order']) ? krsort($attachment_data) : ksort($attachment_data);

$template->assign_block_vars_array('attach_row', $attachrow_template_vars);

}

}

//

}

$db->sql_freeresult($result);

{

return;

}

$topic_rows = array();

{

$sql = 'SELECT topic_id, forum_id, topic_title, topic_poster

FROM ' . TOPICS_TABLE . '

$db->sql_freeresult($result);

{

return false;

}

);

extract($phpbb_dispatcher->trigger_event('core.topic_review_modify_post_list', compact($vars)));

{

// A non-existing rowset only happens if there was no user present for the entered poster_id

// This could be a broken posts table.

foreach ($shadow_forum_ids as $updated_forum => $topic_count)

{

// even if the topic is moved back to where its shadow lives (we count how many times it is in a forum)

$sql = 'UPDATE ' . FORUMS_TABLE . '

SET forum_topics_approved = forum_topics_approved - ' . $topic_count . '

$phpbb_content_visibility->remove_topic_from_statistic($data, $sql_data);

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

{

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

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

{

// Update last post information when hard deleting. Soft delete already did that by itself.

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

{

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

}

$sql_insert_ary = array();

{

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

{

{

// If we add options we need to put them to the end to be able to preserve votes...

$sql_insert_ary[] = array(

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

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

);

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

{

$sql = 'DELETE FROM ' . POLL_OPTIONS_TABLE . '

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

$db->sql_query($sql);

}

// If edited, we would need to reset votes (since options can be re-ordered above, you can't be sure if the change is for changing the text or adding an option

{

$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']);

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

}

{

$sql = 'SELECT attach_id, filesize, physical_filename

FROM ' . ATTACHMENTS_TABLE . '