- global $db, $user, $auth;

- global $db, $user, $config;

- $s_group_options .= '<option' . (($row['group_type'] == GROUP_SPECIAL) ? ' class="sep"' : '') . ' value="' . $row['group_id'] . '"' . $selected . '>' . (($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name']) . '</option>';

- global $db;

- add_log('admin', 'LOG_FORUM_COPIED_PERMISSIONS', $src_forum_name, implode(', ', $dest_forum_names));

- set_config_count('num_topics', $approved_topics * (-1), true);

- delete_attachments('post', $post_ids, false);

- set_config_count('num_posts', $approved_posts * (-1), true);

- global $db, $config, $phpbb_dispatcher;

-

- // 0 is as bad as an empty array

- if (empty($ids))

- {

- return false;

- }

-

- if (is_array($ids))

- {

- $ids = array_unique($ids);

- $ids = array_map('intval', $ids);

- }

- else

- {

- $ids = array((int) $ids);

- }

-

- $sql_where = '';

-

- switch ($mode)

- {

- case 'post':

- case 'message':

- $sql_id = 'post_msg_id';

- $sql_where = ' AND in_message = ' . ($mode == 'message' ? 1 : 0);

- 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();

-

- /**

- * Perform additional actions before collecting data for attachment(s) deletion

- *

- * @event core.delete_attachments_collect_data_before

- * @var string mode Variable containing attachments deletion mode, can be: post|message|topic|attach|user

- * @var mixed ids Array or comma separated list of ids corresponding to the mode

- * @var bool resync Flag indicating if posts/messages/topics should be synchronized

- * @var string sql_id The field name to collect/delete data for depending on the mode

- * @since 3.1.7-RC1

- */

- $vars = array(

- 'mode',

- 'ids',

- 'resync',

- 'sql_id',

- );

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

-

- // 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

- FROM ' . ATTACHMENTS_TABLE . '

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

-

- $sql .= $sql_where;

-

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

-

- /**

- * Perform additional actions before attachment(s) deletion

- *

- * @event core.delete_attachments_before

- * @var string mode Variable containing attachments deletion mode, can be: post|message|topic|attach|user

- * @var mixed ids Array or comma separated list of ids corresponding to the mode

- * @var bool resync Flag indicating if posts/messages/topics should be synchronized

- * @var string sql_id The field name to collect/delete data for depending on the mode

- * @var array post_ids Array with post ids for deleted attachment(s)

- * @var array topic_ids Array with topic ids for deleted attachment(s)

- * @var array message_ids Array with private message ids for deleted attachment(s)

- * @var array physical Array with deleted attachment(s) physical file(s) data

- * @since 3.1.7-RC1

- */

- $vars = array(

- 'mode',

- 'ids',

- 'resync',

- 'sql_id',

- 'post_ids',

- 'topic_ids',

- 'message_ids',

- 'physical',

- );

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

-

- // Delete attachments

- $sql = 'DELETE FROM ' . ATTACHMENTS_TABLE . '

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

-

- $sql .= $sql_where;

-

- $db->sql_query($sql);

- $num_deleted = $db->sql_affectedrows();

-

- /**

- * Perform additional actions after attachment(s) deletion from the database

- *

- * @event core.delete_attachments_from_database_after

- * @var string mode Variable containing attachments deletion mode, can be: post|message|topic|attach|user

- * @var mixed ids Array or comma separated list of ids corresponding to the mode

- * @var bool resync Flag indicating if posts/messages/topics should be synchronized

- * @var string sql_id The field name to collect/delete data for depending on the mode

- * @var array post_ids Array with post ids for deleted attachment(s)

- * @var array topic_ids Array with topic ids for deleted attachment(s)

- * @var array message_ids Array with private message ids for deleted attachment(s)

- * @var array physical Array with deleted attachment(s) physical file(s) data

- * @var int num_deleted The number of deleted attachment(s) from the database

- * @since 3.1.7-RC1

- */

- $vars = array(

- 'mode',

- 'ids',

- 'resync',

- 'sql_id',

- 'post_ids',

- 'topic_ids',

- 'message_ids',

- 'physical',

- 'num_deleted',

- );

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

-

- if (!$num_deleted)

- {

- return 0;

- }

-

- // Delete attachments from filesystem

- $space_removed = $files_removed = 0;

- foreach ($physical as $file_ary)

- {

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

- {

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

- $space_removed += $file_ary['filesize'];

- $files_removed++;

- }

-

- if ($file_ary['thumbnail'])

- {

- phpbb_unlink($file_ary['filename'], 'thumbnail', true);

- }

- }

-

- /**

- * Perform additional actions after attachment(s) deletion from the filesystem

- *

- * @event core.delete_attachments_from_filesystem_after

- * @var string mode Variable containing attachments deletion mode, can be: post|message|topic|attach|user

- * @var mixed ids Array or comma separated list of ids corresponding to the mode

- * @var bool resync Flag indicating if posts/messages/topics should be synchronized

- * @var string sql_id The field name to collect/delete data for depending on the mode

- * @var array post_ids Array with post ids for deleted attachment(s)

- * @var array topic_ids Array with topic ids for deleted attachment(s)

- * @var array message_ids Array with private message ids for deleted attachment(s)

- * @var array physical Array with deleted attachment(s) physical file(s) data

- * @var int num_deleted The number of deleted attachment(s) from the database

- * @var int space_removed The size of deleted files(s) from the filesystem

- * @var int files_removed The number of deleted file(s) from the filesystem

- * @since 3.1.7-RC1

- */

- $vars = array(

- 'mode',

- 'ids',

- 'resync',

- 'sql_id',

- 'post_ids',

- 'topic_ids',

- 'message_ids',

- 'physical',

- 'num_deleted',

- 'space_removed',

- 'files_removed',

- );

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

-

- if ($space_removed || $files_removed)

- {

- set_config_count('upload_dir_size', $space_removed * (-1), true);

- set_config_count('num_files', $files_removed * (-1), 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

- unset($ids);

-

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

- $post_ids = array_unique($post_ids);

- $message_ids = array_unique($message_ids);

- $topic_ids = array_unique($topic_ids);

-

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

- if (sizeof($post_ids))

- {

- // Just check which posts are still having an assigned attachment not orphaned by querying the attachments table

- $sql = 'SELECT post_msg_id

- FROM ' . ATTACHMENTS_TABLE . '

- WHERE ' . $db->sql_in_set('post_msg_id', $post_ids) . '

- AND in_message = 0

- AND is_orphan = 0';

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

-

- $remaining_ids = array();

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

- {

- $remaining_ids[] = $row['post_msg_id'];

- }

- $db->sql_freeresult($result);

-

- // Now only unset those ids remaining

- $post_ids = array_diff($post_ids, $remaining_ids);

-

- if (sizeof($post_ids))

- {

- $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))

- {

- // Just check which messages are still having an assigned attachment not orphaned by querying the attachments table

- $sql = 'SELECT post_msg_id

- FROM ' . ATTACHMENTS_TABLE . '

- WHERE ' . $db->sql_in_set('post_msg_id', $message_ids) . '

- AND in_message = 1

- AND is_orphan = 0';

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

-

- $remaining_ids = array();

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

- {

- $remaining_ids[] = $row['post_msg_id'];

- }

- $db->sql_freeresult($result);

-

- // Now only unset those ids remaining

- $message_ids = array_diff($message_ids, $remaining_ids);

-

- 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

- if (sizeof($topic_ids))

- {

- // 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

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

- $db->sql_query($sql);

- }

- }

- global $db, $phpbb_root_path, $config;

- // Because of copying topics or modifications a physical filename could be assigned more than once. If so, do not remove the file itself.

- $sql = 'SELECT COUNT(attach_id) AS num_entries

- FROM ' . ATTACHMENTS_TABLE . "

- WHERE physical_filename = '" . $db->sql_escape(utf8_basename($filename)) . "'";

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

- $num_entries = (int) $db->sql_fetchfield('num_entries');

- $db->sql_freeresult($result);

- // Do not remove file if at least one additional entry with the same name exist.

- if (($entry_removed && $num_entries > 0) || (!$entry_removed && $num_entries > 1))

- {

- return false;

- }

-

- $filename = ($mode == 'thumbnail') ? 'thumb_' . utf8_basename($filename) : utf8_basename($filename);

- return @unlink($phpbb_root_path . $config['upload_path'] . '/' . $filename);

- $post_ids = array();

- $post_ids = array();

- global $db;

- add_log('admin', 'LOG_AUTO_PRUNE', $row['forum_name']);

- $hold_ary = $ug_id_ary = $sql_ary = array();

-/**

-* Retrieve contents from remotely stored file

-*

-* @deprecated 3.1.2 Use file_downloader instead

-*/

-function get_remote_file($host, $directory, $filename, &$errstr, &$errno, $port = 80, $timeout = 6)

-{

- global $phpbb_container;

-

- // Get file downloader and assign $errstr and $errno

- $file_downloader = $phpbb_container->get('file_downloader');

-

- $file_data = $file_downloader->get($host, $directory, $filename, $port, $timeout);

- $errstr = $file_downloader->get_error_string();

- $errno = $file_downloader->get_error_number();

-

- return $file_data;

-}

-

- set_config('warnings_last_gc', time(), true);

- global $db;

- set_config('database_last_gc', time(), true);