- global $db, $user, $auth;

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

- $db->sql_freeresult($result);

- unset($padding_store);

- for ($i = 0, $size = sizeof($size_types_text); $i < $size; $i++)

- global $db, $user, $config;

- $exclude_sql = ($exclude_ids !== false && sizeof($exclude_ids)) ? 'WHERE ' . $db->sql_in_set('group_id', array_map('intval', $exclude_ids), true) : '';

- $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, $auth;

- global $db;

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

- global $db;

- global $db;

- global $db, $config, $phpbb_container;

- if (!sizeof($where_ids))

- $return['topics'] = sizeof($topic_ids);

- if (!sizeof($topic_ids))

- if (sizeof($moved_topic_ids))

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

- if (!sizeof($where_ids))

- if (sizeof($where_ids) >= 1001)

- if (!sizeof($post_ids))

- if (sizeof($post_counts) && $post_count_sync)

- if (sizeof($topic_ids))

- $search = new $search_type($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user);

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

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

- if (sizeof($remove_topics) && $call_delete_topics)

- return sizeof($post_ids);

- global $db, $config;

-

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

-

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

-

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

-

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

- }

- }

-

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

- }

- }

- while (sizeof($topic_ids) == $batch_size);

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

- if (!sizeof($where_ids))

- if (!sizeof($where_ids))

- if (!sizeof($topic_id_ary))

- if (sizeof($post_ids))

- if (sizeof($topic_ids))

- if (sizeof($post_ids))

- if (sizeof($topic_ids))

- if (!sizeof($forum_ids))

- if (sizeof($forum_ids) == 1)

- $forum_id = (sizeof($forum_ids) == 1) ? (int) $forum_ids[0] : (int) $row['forum_id'];

- if (sizeof($forum_ids) == 1)

- $forum_id = (sizeof($forum_ids) == 1) ? (int) $forum_ids[0] : (int) $row['forum_id'];

- if (sizeof($post_ids))

- if (sizeof($sql_ary))

- if (sizeof($delete_posts))

- if (!sizeof($topic_data))

- if (sizeof($delete_topics))

- $post_ids = array();

- if (sizeof($moved_topics))

- if (sizeof($delete_topics))

- if (sizeof($post_ids))

- $post_ids = array();

- if (sizeof($sync_shadow_topics))

- if (sizeof($sql_ary))

- if ($resync_parents && sizeof($resync_forums) && $where_type != 'range')

-function prune($forum_id, $prune_mode, $prune_date, $prune_flags = 0, $auto_sync = true)

- if (!sizeof($forum_id))

- $vars = array('forum_id', 'prune_mode', 'prune_date', 'prune_flags', 'auto_sync', 'sql_and');

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

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

- global $db;

- prune($forum_id, $prune_mode, $prune_date, $prune_flags, true);

- $sql = 'UPDATE ' . FORUMS_TABLE . "

- SET prune_next = $next_prune

- WHERE forum_id = $forum_id";

- $db->sql_query($sql);

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

- case 'sqlite':

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

- if (sizeof($hold_ary))

- if (sizeof($hold_ary))

- if (sizeof($hold_ary))

- if (is_array($user_id) && sizeof($user_id))

- if (is_array($group_id) && sizeof($group_id))

- if (!sizeof($groups))

- if (sizeof($users))

- if (sizeof($perms))

- if (preg_match('#(3\.23|[45]\.)#', $version))

- $db_name = (preg_match('#^(?:3\.23\.(?:[6-9]|[1-9]{2}))|[45]\.#', $version)) ? "`{$db->get_db_name()}`" : $db->get_db_name();

- if ((isset($row['Type']) && $row['Type'] != 'MRG_MyISAM') || (isset($row['Engine']) && ($row['Engine'] == 'MyISAM' || $row['Engine'] == 'InnoDB')))

- case 'sqlite':

- case 'mssql':

-/**

-* 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;

-}

-

- if (sizeof($warning_list))

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

- global $db;

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

- ->core_path('language/' . $user->lang_name . '/')

- ->extension_directory('/language/' . $user->lang_name)