Line 202 | Line 202 |
---|
if (count($ids) == 1) {
|
if (count($ids) == 1) {
|
$sql = 'SELECT MAX(p.post_id) as last_post_id
| $sql = 'SELECT p.post_id as last_post_id
|
FROM ' . POSTS_TABLE . " p $topic_join WHERE " . $db->sql_in_set('p.' . $type . '_id', $ids) . " $topic_condition
|
FROM ' . POSTS_TABLE . " p $topic_join WHERE " . $db->sql_in_set('p.' . $type . '_id', $ids) . " $topic_condition
|
AND p.post_visibility = " . ITEM_APPROVED;
| AND p.post_visibility = " . ITEM_APPROVED . " ORDER BY p.post_id DESC"; $result = $db->sql_query_limit($sql, 1);
|
} else {
| } else {
|
Line 216 | Line 218 |
---|
$topic_condition AND p.post_visibility = " . ITEM_APPROVED . " GROUP BY p.{$type}_id";
|
$topic_condition AND p.post_visibility = " . ITEM_APPROVED . " GROUP BY p.{$type}_id";
|
}
| |
$result = $db->sql_query($sql);
|
$result = $db->sql_query($sql);
|
| }
|
$last_post_ids = array(); while ($row = $db->sql_fetchrow($result))
| $last_post_ids = array(); while ($row = $db->sql_fetchrow($result))
|
Line 975 | Line 977 |
---|
'WHERE' => $db->sql_in_set('p.post_id', $post_list) . ' AND u.user_id = p.poster_id', );
|
'WHERE' => $db->sql_in_set('p.post_id', $post_list) . ' AND u.user_id = p.poster_id', );
|
| /** * Event to modify the SQL query for topic reviews * * @event core.topic_review_modify_sql_ary * @var int topic_id The topic ID that is being reviewed * @var int forum_id The topic's forum ID * @var string mode The topic review mode * @var int cur_post_id Post offset ID * @var bool show_quote_button Flag indicating if the quote button should be displayed * @var array post_list Array with the post IDs * @var array sql_ary Array with the SQL query * @since 3.2.8-RC1 */ $vars = array( 'topic_id', 'forum_id', 'mode', 'cur_post_id', 'show_quote_button', 'post_list', 'sql_ary', ); extract($phpbb_dispatcher->trigger_event('core.topic_review_modify_sql_ary', compact($vars)));
|
$sql = $db->sql_build_query('SELECT', $sql_ary); $result = $db->sql_query($sql);
| $sql = $db->sql_build_query('SELECT', $sql_ary); $result = $db->sql_query($sql);
|
Line 1282 | Line 1308 |
---|
delete_topics('topic_id', array($topic_id), false);
$phpbb_content_visibility->remove_topic_from_statistic($data, $sql_data);
|
delete_topics('topic_id', array($topic_id), false);
$phpbb_content_visibility->remove_topic_from_statistic($data, $sql_data);
|
| $config->increment('num_posts', -1, false);
|
$update_sql = update_post_information('forum', $forum_id, true); if (count($update_sql))
| $update_sql = update_post_information('forum', $forum_id, true); if (count($update_sql))
|
Line 2050 | Line 2077 |
---|
if ($attach_row['is_orphan'] && !isset($orphan_rows[$attach_row['attach_id']])) { continue;
|
if ($attach_row['is_orphan'] && !isset($orphan_rows[$attach_row['attach_id']])) { continue;
|
| }
if (preg_match('/[\x{10000}-\x{10FFFF}]/u', $attach_row['attach_comment'])) { trigger_error('ATTACH_COMMENT_NO_EMOJIS');
|
}
if (!$attach_row['is_orphan'])
| }
if (!$attach_row['is_orphan'])
|