-* @package acp

-* @copyright (c) 2005 phpBB Group

-* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

-*

-* @author EXreaction

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

-*

-* @author bantu

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

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

- 'topic',

- 'approve_topic',

- 'topic_in_queue',

- global $db, $config, $phpbb_root_path, $phpEx, $auth, $user, $phpbb_container;

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

- $phpbb_notifications->delete_notifications(array(

- 'quote',

- 'bookmark',

- 'post',

- 'approve_post',

- 'post_in_queue',

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

- }

- }

-*

-* @author bantu

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

- switch ($db->sql_layer)

- foreach ($topic_visiblities as $visibility => $sql_where)

- else if ($row['topic_visibility'] == ITEM_UNAPPROVED)

- else if ($row['post_visibility'] == ITEM_UNAPPROVED)

- if ($topic_data[$topic_id]['visibility'] == ITEM_UNAPPROVED)

- $post_ids = array();

- $post_ids = array();

- global $db;

- global $db;

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

-* @param \phpbb\db\driver\driver $db Database connection

- switch ($db->sql_layer)

- case 'firebird':

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

- AND o.auth_option " . $db->sql_like_expression('m_' . $db->any_char),

-* Cache moderators. Called whenever permissions are changed

-* via admin_permissions. Changes of usernames and group names

-* must be carried through for the moderators table.

-*

-* @deprecated 3.1

-* @return null

-*/

-function cache_moderators()

-{

- global $db, $cache, $auth;

- return phpbb_cache_moderators($db, $cache, $auth);

-}

-

-/**

-* @param \phpbb\db\driver\driver $db Database connection

- switch ($db->sql_layer)

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

-* Removes moderators and administrators from foe lists.

-*

-* @deprecated 3.1

-* @param array|bool $group_id If an array, remove all members of this group from foe lists, or false to ignore

-* @param array|bool $user_id If an array, remove this user from foe lists, or false to ignore

-* @return null

-*/

-function update_foes($group_id = false, $user_id = false)

-{

- global $db, $auth;

- return phpbb_update_foes($db, $auth, $group_id, $user_id);

-}

-

-/**

- switch ($db->sql_layer)

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

- case 'firebird':

- global $dbname;

-

- // if it on the local machine, we can get lucky

- if (file_exists($dbname))

- {

- $database_size = filesize($dbname);

- }

-

- break;

-

- $database = $db->dbname;

-/**

-* Retrieve contents from remotely stored file

-*/

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

-{

- global $user;

-

- if ($fsock = @fsockopen($host, $port, $errno, $errstr, $timeout))

- {

- @fputs($fsock, "GET $directory/$filename HTTP/1.0\r\n");

- @fputs($fsock, "HOST: $host\r\n");

- @fputs($fsock, "Connection: close\r\n\r\n");

-

- $timer_stop = time() + $timeout;

- stream_set_timeout($fsock, $timeout);

-

- $file_info = '';

- $get_info = false;

-

- while (!@feof($fsock))

- {

- if ($get_info)

- {

- $file_info .= @fread($fsock, 1024);

- }

- else

- {

- $line = @fgets($fsock, 1024);

- if ($line == "\r\n")

- {

- $get_info = true;

- }

- else if (stripos($line, '404 not found') !== false)

- {

- $errstr = $user->lang['FILE_NOT_FOUND'] . ': ' . $filename;

- return false;

- }

- }

-

- $stream_meta_data = stream_get_meta_data($fsock);

-

- if (!empty($stream_meta_data['timed_out']) || time() >= $timer_stop)

- {

- $errstr = $user->lang['FSOCK_TIMEOUT'];

- return false;

- }

- }

- @fclose($fsock);

- }

- else

- {

- if ($errstr)

- {

- $errstr = utf8_convert_message($errstr);

- return false;

- }

- else

- {

- $errstr = $user->lang['FSOCK_DISABLED'];

- return false;

- }

- }

-

- return $file_info;

-}

-

-/**

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

- global $db;

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

- * Obtains the latest version information

- *

- * @param bool $force_update Ignores cached data. Defaults to false.

- * @param bool $warn_fail Trigger a warning if obtaining the latest version information fails. Defaults to false.

- * @param int $ttl Cache version information for $ttl seconds. Defaults to 86400 (24 hours).

- *

- * @return string | false Version info on success, false on failure.

- */

-function obtain_latest_version_info($force_update = false, $warn_fail = false, $ttl = 86400)

-{

- global $cache;

-

- $info = $cache->get('versioncheck');

-

- if ($info === false || $force_update)

- {

- $errstr = '';

- $errno = 0;

-

- $info = get_remote_file('version.phpbb.com', '/phpbb',

- ((defined('PHPBB_QA')) ? '30x_qa.txt' : '30x.txt'), $errstr, $errno);

-

- if (empty($info))

- {

- $cache->destroy('versioncheck');

- if ($warn_fail)

- {

- trigger_error($errstr, E_USER_WARNING);

- }

- return false;

- }

-

- $cache->put('versioncheck', $info, $ttl);

- }

-

- return $info;

-}

-

-/**