+

+ $sql = 'SELECT topic_id, forum_id, topic_approved, topic_moved_id

+ if ($row['topic_approved'] && !$row['topic_moved_id'])

+ if ($row['post_postcount'] && $post_count_sync && $row['post_approved'])

+

+* @param string $mode can be: post|message|topic|attach|user

+* @param mixed $ids can be: post_ids, message_ids, topic_ids, attach_ids, user_ids

+ switch ($mode)

+ {

+ case 'post':

+ case 'message':

+ $sql_id = 'post_msg_id';

+ break;

+ case 'topic':

+ $sql_id = 'topic_id';

+ break;

+ case 'user':

+ $sql_id = 'poster_id';

+ break;

+ case 'attach':

+ default:

+ $sql_id = 'attach_id';

+ $mode = 'attach';

+ break;

+ $post_ids = $message_ids = $topic_ids = $physical = array();

+

+ // Collect post and topic ids for later use if we need to touch remaining entries (if resync is enabled)

+ $sql = 'SELECT post_msg_id, topic_id, in_message, physical_filename, thumbnail, filesize, is_orphan

+ WHERE ' . $db->sql_in_set($sql_id, $ids);

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

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

+ {

+ // We only need to store post/message/topic ids if resync is enabled and the file is not orphaned

+ if ($resync && !$row['is_orphan'])

+ if (!$row['in_message'])

+ {

+ $post_ids[] = $row['post_msg_id'];

+ $topic_ids[] = $row['topic_id'];

+ }

+ else

+ {

+ $message_ids[] = $row['post_msg_id'];

+ }

+

+ $physical[] = array('filename' => $row['physical_filename'], 'thumbnail' => $row['thumbnail'], 'filesize' => $row['filesize'], 'is_orphan' => $row['is_orphan']);

+ $db->sql_freeresult($result);

+ if (phpbb_unlink($file_ary['filename'], 'file', true) && !$file_ary['is_orphan'])

+ // Only non-orphaned files count to the file size

+ if ($space_removed || $files_removed)

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

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

+ // If we do not resync, we do not need to adjust any message, post, topic or user entries

+ if (!$resync)

+ return $num_deleted;

+

+ // No more use for the original ids

+ // Now, we need to resync posts, messages, topics. We go through every one of them

+ $message_ids = array_unique($message_ids);

+ // Update post indicators for posts now no longer having attachments

+ $sql = 'UPDATE ' . POSTS_TABLE . '

+ SET post_attachment = 0

+ WHERE ' . $db->sql_in_set('post_id', $post_ids);

+ $db->sql_query($sql);

+ }

+ // Update message table if messages are affected

+ if (sizeof($message_ids))

+ {

+ $sql = 'UPDATE ' . PRIVMSGS_TABLE . '

+ SET message_attachment = 0

+ WHERE ' . $db->sql_in_set('msg_id', $message_ids);

+ $db->sql_query($sql);

+ // Now update the topics. This is a bit trickier, because there could be posts still having attachments within the topic

+ // Just check which topics are still having an assigned attachment not orphaned by querying the attachments table (much less entries expected)

+ $sql = 'SELECT topic_id

+ FROM ' . ATTACHMENTS_TABLE . '

+ WHERE ' . $db->sql_in_set('topic_id', $topic_ids) . '

+ AND is_orphan = 0';

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

+

+ $remaining_ids = array();

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

+ $remaining_ids[] = $row['topic_id'];

+ $db->sql_freeresult($result);

+ // Now only unset those ids remaining

+ $topic_ids = array_diff($topic_ids, $remaining_ids);

+ if (sizeof($topic_ids))

+ {

+ $sql = 'UPDATE ' . TOPICS_TABLE . '

+ SET topic_attachment = 0

+ $db->sql_query($sql);

+

+

+

+

+ // Check if there are more occurrences of % than arguments, if there are we fill out the arguments array

+ // It doesn't matter if we add more arguments than placeholders

+ if (substr_count($log[$i]['action'], '%') - sizeof($log_data_ary))

+ {

+ $log_data_ary = array_merge($log_data_ary, array_fill(0, substr_count($log[$i]['action'], '%') - sizeof($log_data_ary), ''));

+ }

+

+ $log[$i]['action'] = vsprintf($log[$i]['action'], $log_data_ary);

+ $sql = 'DELETE ' . (($db->sql_layer === 'mysqli' || version_compare($db->sql_server_info(true), '4.1', '>=')) ? 'z.*' : ZEBRA_TABLE) . '

+ {

+

+

+

+

+ $dh = @opendir($user->lang_path . $user->lang_name . '/' . $path);