+ phpbb_cache_moderators($db, $cache, $auth);

+

+ phpbb_cache_moderators($db, $cache, $auth);

+ if (isset($submit_ary[$test]) && ($action == 'add' || $group_row['group_' . $test] != $submit_ary[$test] || isset($group_attributes['group_avatar']) && strpos($test, 'avatar') === 0 || in_array($test, $set_attributes)))

+ global $config, $db, $cache, $user, $auth, $template, $request;

+

+

+

+

+

+ phpbb_cache_moderators($db, $cache, $auth);

+

+

+ global $phpbb_container;

+ $phpbb_container->get('cache.driver')->destroy('_modules_' . $p_class);

+ $phpbb_container->get('cache.driver')->destroy('sql', MODULES_TABLE);

+ global $db, $cache, $user, $auth;

+ phpbb_cache_moderators($db, $cache, $auth);

+ phpbb_update_foes($db, $auth, $group_id, $user_id);

+ global $db, $cache, $user, $auth;

+ phpbb_cache_moderators($db, $cache, $auth);

+ phpbb_update_foes($db, $auth, $group_id, $user_id);

+ global $user, $db, $cache, $auth;

+ phpbb_cache_moderators($db, $cache, $auth);

+ $userdata = $auth->obtain_user_data($user_id);

+ global $db, $auth, $cache, $template, $user;

+ phpbb_cache_moderators($db, $cache, $auth);

+

+

+

+ 'RANK_IMAGE' => ($edit_img) ? $phpbb_root_path . $config['ranks_path'] . '/' . $edit_img : htmlspecialchars($phpbb_admin_path) . 'images/spacer.gif',

+

+

+ );

+ global $db, $cache, $auth;

+

+ phpbb_cache_moderators($db, $cache, $auth);

+ 'title' => 'ACP_EXTENSIONS_MANAGEMENT',

+ 'main' => array('title' => 'ACP_EXTENSIONS', 'auth' => 'acl_a_extensions', 'cat' => array('ACP_EXTENSIONS_MANAGEMENT')),

+ 'lang_packs' => array('title' => 'ACP_LANGUAGE_PACKS', 'auth' => 'acl_a_language', 'cat' => array('ACP_LANGUAGE')),

+ * Retrieves data wanted by acl function from the database for the

+ * specified user.

+ *

+ * @param int $user_id User ID

+ * @return array User attributes

+ */

+ public function obtain_user_data($user_id)

+ {

+ global $db;

+

+ $sql = 'SELECT user_id, username, user_permissions, user_type

+ FROM ' . USERS_TABLE . '

+ WHERE user_id = ' . $user_id;

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

+ $user_data = $db->sql_fetchrow($result);

+ $db->sql_freeresult($result);

+ return $user_data;

+ }

+

+ /**

+ * if the option is prefixed with !, then the result becomes negated

+ $template = new phpbb_template($phpbb_root_path, $phpEx, $config, $user, $style_resource_locator, new phpbb_template_context(), $phpbb_extension_manager);

+ * @return null

+ * @return null

+ * @return null

+ if (strpos($entry, 'container_') !== 0 &&

+ strpos($entry, 'url_matcher') !== 0 &&

+ strpos($entry, 'sql_') !== 0 &&

+ strpos($entry, 'data_') !== 0 &&

+ strpos($entry, 'ctpl_') !== 0 &&

+ strpos($entry, 'tpl_') !== 0)

+ * {@inheritDoc}

+ function sql_save(phpbb_db_driver $db, $query, $query_result, $ttl)

+ return $query_id;

+ return $query_result;

+ $lock = new phpbb_lock_flock($file);

+ $lock->acquire();

+

+ $return_value = true;

+ }

+ else

+ {

+ $return_value = false;

+ $lock->release();

+

+ return $return_value;

+ * Check if a given cache entry exists

+ * Load result of an SQL query from cache.

+ *

+ * @param string $query SQL query

+ *

+ * @return int|bool Query ID (integer) if cache contains a rowset

+ * for the specified query.

+ * False otherwise.

+ * Save result of an SQL query in cache.

+ *

+ * In persistent cache stores, this function stores the query

+ * result to persistent storage. In other words, there is no need

+ * to call save() afterwards.

+ *

+ * @param phpbb_db_driver $db Database connection

+ * @param string $query SQL query, should be used for generating storage key

+ * @param mixed $query_result The result from dbal::sql_query, to be passed to

+ * dbal::sql_fetchrow to get all rows and store them

+ * in cache.

+ * @param int $ttl Time to live, after this timeout the query should

+ * expire from the cache.

+ * @return int|mixed If storing in cache succeeded, an integer $query_id

+ * representing the query should be returned. Otherwise

+ * the original $query_result should be returned.

+ public function sql_save(phpbb_db_driver $db, $query, $query_result, $ttl);

+ * Check if result for a given SQL query exists in cache.

+ *

+ * @param int $query_id

+ * @return bool

+ *

+ * @param int $query_id

+ * @return array|bool The query result if found in the cache, otherwise

+ * false.

+ *

+ * @param int $query_id

+ * @param $field The name of the column.

+ * @return string|bool The field of the query result if found in the cache,

+ * otherwise false.

+ *

+ * @param int $rownum Row to seek to.

+ * @param int $query_id

+ * @return bool

+ *

+ * @param int $query_id

+ * @return bool

+ * @return null

+ * @return null

+ if (strpos($entry, 'container_') !== 0 &&

+ strpos($entry, 'url_matcher') !== 0 &&

+ strpos($entry, 'sql_') !== 0 &&

+ strpos($entry, 'data_') !== 0 &&

+ strpos($entry, 'ctpl_') !== 0 &&

+ strpos($entry, 'tpl_') !== 0)

+ * {@inheritDoc}

+ function sql_save(phpbb_db_driver $db, $query, $query_result, $ttl)

+ return $query_result;

+ * {@inheritDoc}

+ function sql_save(phpbb_db_driver $db, $query, $query_result, $ttl)

+ return $query_result;

+ /**

+ * Creates a redis cache driver.

+ *

+ * The following global constants affect operation:

+ *

+ * PHPBB_ACM_REDIS_HOST

+ * PHPBB_ACM_REDIS_PORT

+ * PHPBB_ACM_REDIS_PASSWORD

+ * PHPBB_ACM_REDIS_DB

+ *

+ * There are no publicly documented constructor parameters.

+ */

+

+ $args = func_get_args();

+ if (!empty($args))

+ {

+ $ok = call_user_func_array(array($this->redis, 'connect'), $args);

+ }

+ else

+ {

+ $ok = $this->redis->connect(PHPBB_ACM_REDIS_HOST, PHPBB_ACM_REDIS_PORT);

+ }

+

+ if (!$ok)

+ {

+ trigger_error('Could not connect to redis server');

+ }

+ * @return null

+ * @return null

+ * @return null

+ * @return null

+ /**

+ * Cache driver.

+ *

+ * @var phpbb_cache_driver_interface

+ */

+ protected $driver;

+

+ /**

+ * The config.

+ *

+ * @var phpbb_config

+ */

+ protected $config;

+

+ /**

+ * Database connection.

+ *

+ * @var phpbb_db_driver

+ */

+ protected $db;

+

+ /**

+ * Root path.

+ *

+ * @var string

+ */

+ protected $phpbb_root_path;

+

+ /**

+ * PHP extension.

+ *

+ * @var string

+ */

+ protected $php_ext;

+ * @param phpbb_config $config The config

+ * @param phpbb_db_driver $db Database connection

+ * @param string $phpbb_root_path Root path

+ * @param string $php_ext PHP extension

+ public function __construct(phpbb_cache_driver_interface $driver, phpbb_config $config, phpbb_db_driver $db, $phpbb_root_path, $php_ext)

+ $this->config = $config;

+ $this->db = $db;

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->php_ext = $php_ext;

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

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

+ $this->db->sql_freeresult($result);

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

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

+ $this->db->sql_freeresult($result);

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

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

+ $this->db->sql_freeresult($result);

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

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

+ $this->db->sql_freeresult($result);

+ switch ($this->db->sql_layer)

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

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

+ $this->db->sql_freeresult($result);

+ $filename = $this->phpbb_root_path . 'styles/' . $style['style_path'] . '/style.cfg';

+ if (!isset($parsed_array['filetime']) || (($this->config['load_tplcompile'] && @filemtime($filename) > $parsed_array['filetime'])))

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

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

+ $this->db->sql_freeresult($result);

+ for ($i = (int) floor($width / 2); $i < $end; $i++)

+ * @return null

+ * @var phpbb_db_driver

+ * @param phpbb_db_driver $db Database connection

+ public function __construct(phpbb_db_driver $db, phpbb_cache_driver_interface $cache, $table)

+ * @return null

+<?php

+/**

+*

+* @package controller

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Controller exception class

+* @package phpBB3

+*/

+class phpbb_controller_exception extends RuntimeException

+{

+}

+<?php

+/**

+*

+* @package controller

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+use Symfony\Component\HttpFoundation\Response;

+

+/**

+* Controller helper class, contains methods that do things for controllers

+* @package phpBB3

+*/

+class phpbb_controller_helper

+{

+ /**

+ * Template object

+ * @var phpbb_template

+ */

+ protected $template;

+

+ /**

+ * User object

+ * @var phpbb_user

+ */

+ protected $user;

+

+ /**

+ * phpBB root path

+ * @var string

+ */

+ protected $phpbb_root_path;

+

+ /**

+ * PHP extension

+ * @var string

+ */

+ protected $php_ext;

+

+ /**

+ * Constructor

+ *

+ * @param phpbb_template $template Template object

+ * @param phpbb_user $user User object

+ * @param string $phpbb_root_path phpBB root path

+ * @param string $php_ext PHP extension

+ */

+ public function __construct(phpbb_template $template, phpbb_user $user, $phpbb_root_path, $php_ext)

+ {

+ $this->template = $template;

+ $this->user = $user;

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->php_ext = $php_ext;

+ }

+

+ /**

+ * Automate setting up the page and creating the response object.

+ *

+ * @param string $handle The template handle to render

+ * @param string $page_title The title of the page to output

+ * @param int $status_code The status code to be sent to the page header

+ * @return Response object containing rendered page

+ */

+ public function render($template_file, $page_title = '', $status_code = 200)

+ {

+ page_header($page_title);

+

+ $this->template->set_filenames(array(

+ 'body' => $template_file,

+ ));

+

+ page_footer(true, false, false);

+

+ return new Response($this->template->assign_display('body'), $status_code);

+ }

+

+ /**

+ * Easily generate a URL

+ *

+ * @param array $url_parts Each array element is a 'folder'

+ * i.e. array('my', 'ext') maps to ./app.php/my/ext

+ * @param mixed $query The Query string, passed directly into the second

+ * argument of append_sid()

+ * @return string A URL that has already been run through append_sid()

+ */

+ public function url(array $url_parts, $query = '')

+ {

+ return append_sid($this->phpbb_root_path . implode('/', $url_parts), $query);

+ }

+

+ /**

+ * Output an error, effectively the same thing as trigger_error

+ *

+ * @param string $message The error message

+ * @param string $code The error code (e.g. 404, 500, 503, etc.)

+ * @return Response A Reponse instance

+ */

+ public function error($message, $code = 500)

+ {

+ $this->template->assign_vars(array(

+ 'MESSAGE_TEXT' => $message,

+ 'MESSAGE_TITLE' => $this->user->lang('INFORMATION'),

+ ));

+

+ return $this->render('message_body.html', $this->user->lang('INFORMATION'), $code);

+ }

+}

+<?php

+/**

+*

+* @package controller

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+use Symfony\Component\Routing\RouteCollection;

+use Symfony\Component\Routing\Loader\YamlFileLoader;

+use Symfony\Component\Config\FileLocator;

+

+/**

+* Controller interface

+* @package phpBB3

+*/

+class phpbb_controller_provider

+{

+ /**

+ * YAML file(s) containing route information

+ * @var array

+ */

+ protected $routing_paths;

+

+ /**

+ * Construct method

+ *

+ * @param array() $routing_paths Array of strings containing paths

+ * to YAML files holding route information

+ */

+ public function __construct($routing_paths = array())

+ {

+ $this->routing_paths = $routing_paths;

+ }

+

+ /**

+ * Locate paths containing routing files

+ * This sets an internal property but does not return the paths.

+ *

+ * @return The current instance of this object for method chaining

+ */

+ public function import_paths_from_finder(phpbb_extension_finder $finder)

+ {

+ // We hardcode the path to the core config directory

+ // because the finder cannot find it

+ $this->routing_paths = array_merge(array('config'), array_map('dirname', array_keys($finder

+ ->directory('config')

+ ->prefix('routing')

+ ->suffix('yml')

+ ->find()

+ )));

+

+ return $this;

+ }

+

+ /**

+ * Get a list of controllers and return it

+ *

+ * @param string $base_path Base path to prepend to file paths

+ * @return array Array of controllers and their route information

+ */

+ public function find($base_path = '')

+ {

+ $routes = new RouteCollection;

+ foreach ($this->routing_paths as $path)

+ {

+ $loader = new YamlFileLoader(new FileLocator($base_path . $path));

+ $routes->addCollection($loader->load('routing.yml'));

+ }

+

+ return $routes;

+ }

+}

+<?php

+/**

+*

+* @package controller

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+use Symfony\Component\HttpKernel\Controller\ControllerResolverInterface;

+use Symfony\Component\DependencyInjection\ContainerInterface;

+use Symfony\Component\HttpFoundation\Request;

+

+/**

+* Controller manager class

+* @package phpBB3

+*/

+class phpbb_controller_resolver implements ControllerResolverInterface

+{

+ /**

+ * User object

+ * @var phpbb_user

+ */

+ protected $user;

+

+ /**

+ * ContainerInterface object

+ * @var ContainerInterface

+ */

+ protected $container;

+

+ /**

+ * Construct method

+ *

+ * @param phpbb_user $user User Object

+ * @param ContainerInterface $container ContainerInterface object

+ */

+ public function __construct(phpbb_user $user, ContainerInterface $container)

+ {

+ $this->user = $user;

+ $this->container = $container;

+ }

+

+ /**

+ * Load a controller callable

+ *

+ * @param Symfony\Component\HttpFoundation\Request $request Symfony Request object

+ * @return bool|Callable Callable or false

+ * @throws phpbb_controller_exception

+ */

+ public function getController(Request $request)

+ {

+ $controller = $request->attributes->get('_controller');

+

+ if (!$controller)

+ {

+ throw new phpbb_controller_exception($this->user->lang['CONTROLLER_NOT_SPECIFIED']);

+ }

+

+ // Require a method name along with the service name

+ if (stripos($controller, ':') === false)

+ {

+ throw new phpbb_controller_exception($this->user->lang['CONTROLLER_METHOD_NOT_SPECIFIED']);

+ }

+

+ list($service, $method) = explode(':', $controller);

+

+ if (!$this->container->has($service))

+ {

+ throw new phpbb_controller_exception($this->user->lang('CONTROLLER_SERVICE_UNDEFINED', $service));

+ }

+

+ $controller_object = $this->container->get($service);

+

+ return array($controller_object, $method);

+ }

+

+ /**

+ * Dependencies should be specified in the service definition and can be

+ * then accessed in __construct(). Arguments are sent through the URL path

+ * and should match the parameters of the method you are using as your

+ * controller.

+ *

+ * @param Symfony\Component\HttpFoundation\Request $request Symfony Request object

+ * @param mixed $controller A callable (controller class, method)

+ * @return bool False

+ * @throws phpbb_controller_exception

+ */

+ public function getArguments(Request $request, $controller)

+ {

+ // At this point, $controller contains the object and method name

+ list($object, $method) = $controller;

+ $mirror = new ReflectionMethod($object, $method);

+

+ $arguments = array();

+ $parameters = $mirror->getParameters();

+ $attributes = $request->attributes->all();

+ foreach ($parameters as $param)

+ {

+ if (array_key_exists($param->name, $attributes))

+ {

+ $arguments[] = $attributes[$param->name];

+ }

+ else if ($param->getClass() && $param->getClass()->isInstance($request))

+ {

+ $arguments[] = $request;

+ }

+ else if ($param->isDefaultValueAvailable())

+ {

+ $arguments[] = $param->getDefaultValue();

+ }

+ else

+ {

+ throw new phpbb_controller_exception($this->user->lang('CONTROLLER_ARGUMENT_VALUE_MISSING', $param->getPosition() + 1, get_class($object) . ':' . $method, $param->name));

+ }

+ }

+

+ return $arguments;

+ }

+}

+ * @return null

+ * @param phpbb_db_driver $db The db connection

+ public function __construct($phpbb_root_path, $php_ext, phpbb_config $config, phpbb_db_driver $db)

+ * @return null

+ * @param phpbb_db_driver $db The db connection

+ public function __construct($phpbb_root_path, $php_ext, phpbb_config $config, phpbb_db_driver $db)

+ * @return null

+ * @return null

+ * @return null

+ * @return null

+ * @return null

+ * @param phpbb_db_driver $db The db connection

+ public function __construct($phpbb_root_path, $php_ext, phpbb_auth $auth, phpbb_config $config, phpbb_db_driver $db, phpbb_user $user)

+ * @return null

+ * @return null

+ * @return null

+ * @return null

+ * @return null

+ * @param phpbb_db_driver $db Database connection

+ // remove default cosntraints first

+ // http://msdn.microsoft.com/en-us/library/aa175912%28v=sql.80%29.aspx

+ $statements[] = "DECLARE @drop_default_name VARCHAR(100), @cmd VARCHAR(1000)

+ SET @drop_default_name =

+ (SELECT so.name FROM sysobjects so

+ JOIN sysconstraints sc ON so.id = sc.constid

+ WHERE object_name(so.parent_obj) = '{$table_name}'

+ AND so.xtype = 'D'

+ AND sc.colid = (SELECT colid FROM syscolumns

+ WHERE id = object_id('{$table_name}')

+ AND name = '{$column_name}'))

+ IF @drop_default_name <> ''

+ BEGIN

+ SET @cmd = 'ALTER TABLE [{$table_name}] DROP CONSTRAINT [' + @drop_default_name + ']'

+ EXEC(@cmd)

+ END";

+class phpbb_db_driver

+ function __construct()

+ 'cached' => 0,

+ 'normal' => 0,

+ 'total' => 0,

+ $this->sql_layer = substr(get_class($this), strlen('phpbb_db_driver_'));

+ if ($cache && $cache->sql_exists($query_id))

+ if ($cache && !is_object($query_id) && $cache->sql_exists($query_id))

+ global $cache, $starttime, $phpbb_root_path, $phpbb_admin_path, $user;

+ <link href="' . htmlspecialchars($phpbb_admin_path) . 'style/admin.css" rel="stylesheet" type="text/css" media="screen" />

+class phpbb_db_driver_firebird extends phpbb_db_driver

+ $this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

+ if ($cache && $cache_ttl)

+ $this->query_result = $cache->sql_save($this, $query, $this->query_result, $cache_ttl);

+ if ($cache && $cache->sql_exists($query_id))

+ if ($cache && $cache->sql_exists($query_id))

+class phpbb_db_driver_mssql extends phpbb_db_driver

+ var $connect_error = '';

+

+ if (!function_exists('mssql_connect'))

+ {

+ $this->connect_error = 'mssql_connect function does not exist, is mssql extension installed?';

+ return $this->sql_error('');

+ }

+

+ $this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

+ if ($cache && $cache_ttl)

+ $this->query_result = $cache->sql_save($this, $query, $this->query_result, $cache_ttl);

+ if ($cache && $cache->sql_exists($query_id))

+ if ($cache && $cache->sql_exists($query_id))

+ if ($cache && $cache->sql_exists($query_id))

+ if (function_exists('mssql_get_last_message'))

+ $error = array(

+ 'message' => @mssql_get_last_message(),

+ 'code' => '',

+ );

+ // Get error code number

+ $result_id = @mssql_query('SELECT @@ERROR as code', $this->db_connect_id);

+ if ($result_id)

+ $row = @mssql_fetch_assoc($result_id);

+ $error['code'] = $row['code'];

+ @mssql_free_result($result_id);

+

+ // Get full error message if possible

+ $sql = 'SELECT CAST(description as varchar(255)) as message

+ FROM master.dbo.sysmessages

+ WHERE error = ' . $error['code'];

+ $result_id = @mssql_query($sql);

+

+ if ($result_id)

+ {

+ $row = @mssql_fetch_assoc($result_id);

+ if (!empty($row['message']))

+ {

+ $error['message'] .= '<br />' . $row['message'];

+ }

+ @mssql_free_result($result_id);

+ }

+ }

+ else

+ {

+ $error = array(

+ 'message' => $this->connect_error,

+ 'code' => '',

+ );

+class phpbb_db_driver_mssql_odbc extends phpbb_db_driver

+ var $connect_error = '';

+ if ($this->persistency)

+ {

+ if (!function_exists('odbc_pconnect'))

+ {

+ $this->connect_error = 'odbc_pconnect function does not exist, is odbc extension installed?';

+ return $this->sql_error('');

+ }

+ $this->db_connect_id = @odbc_pconnect($this->server, $this->user, $sqlpassword);

+ }

+ else

+ {

+ if (!function_exists('odbc_connect'))

+ {

+ $this->connect_error = 'odbc_connect function does not exist, is odbc extension installed?';

+ return $this->sql_error('');

+ }

+ $this->db_connect_id = @odbc_connect($this->server, $this->user, $sqlpassword);

+ }

+ $this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

+ if ($cache && $cache_ttl)

+ $this->query_result = $cache->sql_save($this, $query, $this->query_result, $cache_ttl);

+ if ($cache && $cache->sql_exists($query_id))

+ if ($cache && $cache->sql_exists($query_id))

+ if (function_exists('odbc_errormsg'))

+ {

+ $error = array(

+ 'message' => @odbc_errormsg(),

+ 'code' => @odbc_error(),

+ );

+ }

+ else

+ {

+ $error = array(

+ 'message' => $this->connect_error,

+ 'code' => '',

+ );

+ }

+

+ return $error;

+class phpbb_db_driver_mssqlnative extends phpbb_db_driver

+ var $connect_error = '';

+ // Test for driver support, to avoid suppressed fatal error

+ $this->connect_error = 'Native MS SQL Server driver for PHP is missing or needs to be updated. Version 1.1 or later is required to install phpBB3. You can download the driver from: http://www.microsoft.com/sqlserver/2005/en/us/PHP-Driver.aspx';

+ return $this->sql_error('');

+ $this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

+ $this->query_result = $cache->sql_save($this, $query, $this->query_result, $cache_ttl);

+ if (function_exists('sqlsrv_errors'))

+ $errors = @sqlsrv_errors(SQLSRV_ERR_ERRORS);

+ $error_message = '';

+ $code = 0;

+

+ if ($errors != null)

+ foreach ($errors as $error)

+ {

+ $error_message .= "SQLSTATE: " . $error[ 'SQLSTATE'] . "\n";

+ $error_message .= "code: " . $error[ 'code'] . "\n";

+ $code = $error['code'];

+ $error_message .= "message: " . $error[ 'message'] . "\n";

+ }

+ $this->last_error_result = $error_message;

+ $error = $this->last_error_result;

+ else

+ {

+ $error = (isset($this->last_error_result) && $this->last_error_result) ? $this->last_error_result : array();

+ }

+

+ $error = array(

+ 'message' => $error,

+ 'code' => $code,

+ );

+ $error = array(

+ 'message' => $this->connect_error,

+ 'code' => '',

+ );

+ return $error;

+class phpbb_db_driver_mysql extends phpbb_db_driver

+ var $connect_error = '';

+ if ($this->persistency)

+ {

+ if (!function_exists('mysql_pconnect'))

+ {

+ $this->connect_error = 'mysql_pconnect function does not exist, is mysql extension installed?';

+ return $this->sql_error('');

+ }

+ $this->db_connect_id = @mysql_pconnect($this->server, $this->user, $sqlpassword);

+ }

+ else

+ {

+ if (!function_exists('mysql_connect'))

+ {

+ $this->connect_error = 'mysql_connect function does not exist, is mysql extension installed?';

+ return $this->sql_error('');

+ }

+ $this->db_connect_id = @mysql_connect($this->server, $this->user, $sqlpassword, $new_link);

+ }

+ $this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

+ if ($cache && $cache_ttl)

+ $this->query_result = $cache->sql_save($this, $query, $this->query_result, $cache_ttl);

+ if ($cache && $cache->sql_exists($query_id))

+ if ($cache && $cache->sql_exists($query_id))

+ if ($cache && $cache->sql_exists($query_id))

+ if ($this->db_connect_id)

+ {

+ $error = array(

+ 'message' => @mysql_error($this->db_connect_id),

+ 'code' => @mysql_errno($this->db_connect_id),

+ );

+ }

+ else if (function_exists('mysql_error'))

+ $error = array(

+ 'code' => @mysql_errno(),

+ );

+ }

+ else

+ {

+ $error = array(

+ 'message' => $this->connect_error,

+ 'code' => '',

+ return $error;

+class phpbb_db_driver_mysqli extends phpbb_db_driver

+ var $connect_error = '';

+ if (!function_exists('mysqli_connect'))

+ {

+ $this->connect_error = 'mysqli_connect function does not exist, is mysqli extension installed?';

+ return $this->sql_error('');

+ }

+

+ $this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

+ if ($cache && $cache_ttl)

+ $this->query_result = $cache->sql_save($this, $query, $this->query_result, $cache_ttl);

+ if ($cache && !is_object($query_id) && $cache->sql_exists($query_id))

+ if ($cache && !is_object($query_id) && $cache->sql_exists($query_id))

+ if ($cache && !is_object($query_id) && $cache->sql_exists($query_id))

+ if ($this->db_connect_id)

+ $error = array(

+ 'message' => @mysqli_error($this->db_connect_id),

+ 'code' => @mysqli_errno($this->db_connect_id)

+ );

+ }

+ else if (function_exists('mysqli_connect_error'))

+ {

+ $error = array(

+ 'code' => @mysqli_connect_errno(),

+ );

+ }

+ else

+ {

+ $error = array(

+ 'message' => $this->connect_error,

+ 'code' => '',

+ return $error;

+class phpbb_db_driver_oracle extends phpbb_db_driver

+ var $connect_error = '';

+ if ($new_link)

+ {

+ if (!function_exists('ocinlogon'))

+ {

+ $this->connect_error = 'ocinlogon function does not exist, is oci extension installed?';

+ return $this->sql_error('');

+ }

+ $this->db_connect_id = @ocinlogon($this->user, $sqlpassword, $connect, 'UTF8');

+ }

+ else if ($this->persistency)

+ {

+ if (!function_exists('ociplogon'))

+ {

+ $this->connect_error = 'ociplogon function does not exist, is oci extension installed?';

+ return $this->sql_error('');

+ }

+ $this->db_connect_id = @ociplogon($this->user, $sqlpassword, $connect, 'UTF8');

+ }

+ else

+ {

+ if (!function_exists('ocilogon'))

+ {

+ $this->connect_error = 'ocilogon function does not exist, is oci extension installed?';

+ return $this->sql_error('');

+ }

+ $this->db_connect_id = @ocilogon($this->user, $sqlpassword, $connect, 'UTF8');

+ }

+ $this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

+ if ($cache && $cache_ttl)

+ $this->query_result = $cache->sql_save($this, $query, $this->query_result, $cache_ttl);

+ if ($cache && $cache->sql_exists($query_id))

+ if ($cache && $cache->sql_exists($query_id))

+ if ($cache && $cache->sql_exists($query_id))

+ if (function_exists('ocierror'))

+ $error = @ocierror();

+ $error = (!$error) ? @ocierror($this->query_result) : $error;

+ $error = (!$error) ? @ocierror($this->db_connect_id) : $error;

+

+ if ($error)

+ {

+ $this->last_error_result = $error;

+ }

+ else

+ {

+ $error = (isset($this->last_error_result) && $this->last_error_result) ? $this->last_error_result : array();

+ }

+ $error = array(

+ 'message' => $this->connect_error,

+ 'code' => '',

+ );

+class phpbb_db_driver_postgres extends phpbb_db_driver

+ $this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

+ if ($cache && $cache_ttl)

+ $this->query_result = $cache->sql_save($this, $query, $this->query_result, $cache_ttl);

+ if ($cache && $cache->sql_exists($query_id))

+ if ($cache && $cache->sql_exists($query_id))

+ if ($cache && $cache->sql_exists($query_id))

+class phpbb_db_driver_sqlite extends phpbb_db_driver

+ var $connect_error = '';

+

+ if ($this->persistency)

+ {

+ if (!function_exists('sqlite_popen'))

+ {

+ $this->connect_error = 'sqlite_popen function does not exist, is sqlite extension installed?';

+ return $this->sql_error('');

+ }

+ $this->db_connect_id = @sqlite_popen($this->server, 0666, $error);

+ }

+ else

+ {

+ if (!function_exists('sqlite_open'))

+ {

+ $this->connect_error = 'sqlite_open function does not exist, is sqlite extension installed?';

+ return $this->sql_error('');

+ }

+ $this->db_connect_id = @sqlite_open($this->server, 0666, $error);

+ }

+ $this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

+ if ($cache && $cache_ttl)

+ $this->query_result = $cache->sql_save($this, $query, $this->query_result, $cache_ttl);

+ if ($cache && $cache->sql_exists($query_id))

+ if ($cache && $cache->sql_exists($query_id))

+ if ($cache && $cache->sql_exists($query_id))

+ if (function_exists('sqlite_error_string'))

+ {

+ $error = array(

+ 'message' => @sqlite_error_string(@sqlite_last_error($this->db_connect_id)),

+ 'code' => @sqlite_last_error($this->db_connect_id),

+ );

+ }

+ else

+ {

+ $error = array(

+ 'message' => $this->connect_error,

+ 'code' => '',

+ );

+ }

+

+ return $error;

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+use Symfony\Component\DependencyInjection\ContainerBuilder;

+use Symfony\Component\HttpKernel\DependencyInjection\Extension;

+use Symfony\Component\DependencyInjection\Loader\XmlFileLoader;

+use Symfony\Component\Config\FileLocator;

+

+/**

+* Container config extension

+*/

+class phpbb_di_extension_config extends Extension

+{

+ public function __construct($config_file)

+ {

+ $this->config_file = $config_file;

+ }

+

+ /**

+ * Loads a specific configuration.

+ *

+ * @param array $config An array of configuration values

+ * @param ContainerBuilder $container A ContainerBuilder instance

+ *

+ * @throws InvalidArgumentException When provided tag is not defined in this extension

+ */

+ public function load(array $config, ContainerBuilder $container)

+ {

+ require($this->config_file);

+

+ $container->setParameter('core.adm_relative_path', (isset($phpbb_adm_relative_path) ? $phpbb_adm_relative_path : 'adm/'));

+ $container->setParameter('core.table_prefix', $table_prefix);

+ $container->setParameter('cache.driver.class', $this->convert_30_acm_type($acm_type));

+ $container->setParameter('dbal.driver.class', phpbb_convert_30_dbms_to_31($dbms));

+ $container->setParameter('dbal.dbhost', $dbhost);

+ $container->setParameter('dbal.dbuser', $dbuser);

+ $container->setParameter('dbal.dbpasswd', $dbpasswd);

+ $container->setParameter('dbal.dbname', $dbname);

+ $container->setParameter('dbal.dbport', $dbport);

+ $container->setParameter('dbal.new_link', defined('PHPBB_DB_NEW_LINK') && PHPBB_DB_NEW_LINK);

+ }

+

+ /**

+ * Returns the recommended alias to use in XML.

+ *

+ * This alias is also the mandatory prefix to use when using YAML.

+ *

+ * @return string The alias

+ */

+ public function getAlias()

+ {

+ return 'config';

+ }

+

+ /**

+ * Convert 3.0 ACM type to 3.1 cache driver class name

+ *

+ * @param string $acm_type ACM type

+ * @return cache driver class

+ */

+ protected function convert_30_acm_type($acm_type)

+ {

+ if (preg_match('#^[a-z]+$#', $acm_type))

+ {

+ return 'phpbb_cache_driver_'.$acm_type;

+ }

+

+ return $acm_type;

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+use Symfony\Component\DependencyInjection\ContainerBuilder;

+use Symfony\Component\HttpKernel\DependencyInjection\Extension;

+use Symfony\Component\DependencyInjection\Loader\YamlFileLoader;

+use Symfony\Component\Config\FileLocator;

+

+/**

+* Container core extension

+*/

+class phpbb_di_extension_core extends Extension

+{

+ /**

+ * phpBB Root path

+ * @var string

+ */

+ protected $root_path;

+

+ /**

+ * Constructor

+ *

+ * @param string $root_path Root path

+ */

+ public function __construct($root_path)

+ {

+ $this->root_path = $root_path;

+ }

+

+ /**

+ * Loads a specific configuration.

+ *

+ * @param array $config An array of configuration values

+ * @param ContainerBuilder $container A ContainerBuilder instance

+ *

+ * @throws InvalidArgumentException When provided tag is not defined in this extension

+ */

+ public function load(array $config, ContainerBuilder $container)

+ {

+ $loader = new YamlFileLoader($container, new FileLocator(phpbb_realpath($this->root_path . 'config')));

+ $loader->load('services.yml');

+ }

+

+ /**

+ * Returns the recommended alias to use in XML.

+ *

+ * This alias is also the mandatory prefix to use when using YAML.

+ *

+ * @return string The alias

+ */

+ public function getAlias()

+ {

+ return 'core';

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+use Symfony\Component\DependencyInjection\ContainerBuilder;

+use Symfony\Component\HttpKernel\DependencyInjection\Extension;

+use Symfony\Component\DependencyInjection\Loader\YamlFileLoader;

+use Symfony\Component\Config\FileLocator;

+

+/**

+* Container ext extension

+*/

+class phpbb_di_extension_ext extends Extension

+{

+ protected $paths = array();

+

+ public function __construct($enabled_extensions)

+ {

+ foreach ($enabled_extensions as $ext => $path)

+ {

+ $this->paths[] = $path;

+ }

+ }

+

+ /**

+ * Loads a specific configuration.

+ *

+ * @param array $config An array of configuration values

+ * @param ContainerBuilder $container A ContainerBuilder instance

+ *

+ * @throws InvalidArgumentException When provided tag is not defined in this extension

+ */

+ public function load(array $config, ContainerBuilder $container)

+ {

+ foreach ($this->paths as $path)

+ {

+ if (file_exists($path . '/config/services.yml'))

+ {

+ $loader = new YamlFileLoader($container, new FileLocator(phpbb_realpath($path . '/config')));

+ $loader->load('services.yml');

+ }

+ }

+ }

+

+ /**

+ * Returns the recommended alias to use in XML.

+ *

+ * This alias is also the mandatory prefix to use when using YAML.

+ *

+ * @return string The alias

+ */

+ public function getAlias()

+ {

+ return 'ext';

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+use Symfony\Component\DependencyInjection\ContainerBuilder;

+use Symfony\Component\DependencyInjection\Compiler\CompilerPassInterface;

+

+/**

+* Appends an add method call to the definition of each collection service for

+* the services tagged with the appropriate name defined in the collection's

+* service_collection tag.

+*/

+class phpbb_di_pass_collection_pass implements CompilerPassInterface

+{

+ /**

+ * Modify the container before it is passed to the rest of the code

+ *

+ * @param ContainerBuilder $container ContainerBuilder object

+ * @return null

+ */

+ public function process(ContainerBuilder $container)

+ {

+ foreach ($container->findTaggedServiceIds('service_collection') as $id => $data)

+ {

+ $definition = $container->getDefinition($id);

+

+ foreach ($container->findTaggedServiceIds($data[0]['tag']) as $service_id => $service_data)

+ {

+ $definition->addMethodCall('add', array($service_id));

+ }

+ }

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+use Symfony\Component\DependencyInjection\ContainerBuilder;

+use Symfony\Component\DependencyInjection\Compiler\CompilerPassInterface;

+

+class phpbb_di_pass_kernel_pass implements CompilerPassInterface

+{

+ /**

+ * Modify the container before it is passed to the rest of the code

+ *

+ * @param ContainerBuilder $container ContainerBuilder object

+ * @return null

+ */

+ public function process(ContainerBuilder $container)

+ {

+ $definition = $container->getDefinition('dispatcher');

+

+ foreach ($container->findTaggedServiceIds('kernel.event_listener') as $id => $events)

+ {

+ foreach ($events as $event)

+ {

+ $priority = isset($event['priority']) ? $event['priority'] : 0;

+

+ if (!isset($event['event']))

+ {

+ throw new InvalidArgumentException(sprintf('Service "%1$s" must define the "event" attribute on "kernel.event_listener" tags.', $id));

+ }

+

+ if (!isset($event['method']))

+ {

+ throw new InvalidArgumentException(sprintf('Service "%1$s" must define the "method" attribute on "kernel.event_listener" tags.', $id));

+ }

+

+ $definition->addMethodCall('addListenerService', array($event['event'], array($id, $event['method']), $priority));

+ }

+ }

+

+ foreach ($container->findTaggedServiceIds('kernel.event_subscriber') as $id => $attributes)

+ {

+ // We must assume that the class value has been correctly filled, even if the service is created by a factory

+ $class = $container->getDefinition($id)->getClass();

+

+ $refClass = new ReflectionClass($class);

+ $interface = 'Symfony\Component\EventDispatcher\EventSubscriberInterface';

+ if (!$refClass->implementsInterface($interface))

+ {

+ throw new InvalidArgumentException(sprintf('Service "%1$s" must implement interface "%2$s".', $id, $interface));

+ }

+

+ $definition->addMethodCall('addSubscriberService', array($id, $class));

+ }

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+use Symfony\Component\DependencyInjection\ContainerInterface;

+

+/**

+* Collection of services to be configured at container compile time.

+*

+* @package phpBB3

+*/

+class phpbb_di_service_collection extends ArrayObject

+{

+ /**

+ * Constructor

+ *

+ * @param ContainerInterface $container Container object

+ */

+ public function __construct(ContainerInterface $container)

+ {

+ $this->container = $container;

+ }

+

+ /**

+ * Add a service to the collection

+ *

+ * @param string $name The service name

+ * @return null

+ */

+ public function add($name)

+ {

+ $task = $this->container->get($name);

+

+ $this->offsetSet($name, $task);

+ }

+}

+use Symfony\Component\EventDispatcher\ContainerAwareEventDispatcher;

+class phpbb_event_dispatcher extends ContainerAwareEventDispatcher

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+use Symfony\Component\EventDispatcher\EventSubscriberInterface;

+use Symfony\Component\HttpKernel\KernelEvents;

+use Symfony\Component\HttpKernel\Event\GetResponseForExceptionEvent;

+use Symfony\Component\HttpKernel\Exception\HttpException;

+use Symfony\Component\HttpFoundation\Response;

+

+class phpbb_event_kernel_exception_subscriber implements EventSubscriberInterface

+{

+ /**

+ * Template object

+ * @var phpbb_template

+ */

+ protected $template;

+

+ /**

+ * User object

+ * @var phpbb_user

+ */

+ protected $user;

+

+ /**

+ * Construct method

+ *

+ * @param phpbb_template $template Template object

+ * @param phpbb_user $user User object

+ */

+ public function __construct(phpbb_template $template, phpbb_user $user)

+ {

+ $this->template = $template;

+ $this->user = $user;

+ }

+

+ /**

+ * This listener is run when the KernelEvents::EXCEPTION event is triggered

+ *

+ * @param GetResponseForExceptionEvent $event

+ * @return null

+ */

+ public function on_kernel_exception(GetResponseForExceptionEvent $event)

+ {

+ page_header($this->user->lang('INFORMATION'));

+

+ $exception = $event->getException();

+

+ $this->template->assign_vars(array(

+ 'MESSAGE_TITLE' => $this->user->lang('INFORMATION'),

+ 'MESSAGE_TEXT' => $exception->getMessage(),

+ ));

+

+ $this->template->set_filenames(array(

+ 'body' => 'message_body.html',

+ ));

+

+ page_footer(true, false, false);

+

+

+ $status_code = $exception instanceof HttpException ? $exception->getStatusCode() : 500;

+ $response = new Response($this->template->assign_display('body'), $status_code);

+ $event->setResponse($response);

+ }

+

+ public static function getSubscribedEvents()

+ {

+ return array(

+ KernelEvents::EXCEPTION => 'on_kernel_exception',

+ );

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+use Symfony\Component\EventDispatcher\EventSubscriberInterface;

+use Symfony\Component\HttpKernel\KernelEvents;

+use Symfony\Component\HttpKernel\Event\GetResponseEvent;

+use Symfony\Component\HttpKernel\EventListener\RouterListener;

+use Symfony\Component\Routing\RequestContext;

+

+class phpbb_event_kernel_request_subscriber implements EventSubscriberInterface

+{

+ /**

+ * Extension finder object

+ * @var phpbb_extension_finder

+ */

+ protected $finder;

+

+ /**

+ * PHP extension

+ * @var string

+ */

+ protected $php_ext;

+

+ /**

+ * Root path

+ * @var string

+ */

+ protected $root_path;

+

+ /**

+ * Construct method

+ *

+ * @param phpbb_extension_finder $finder Extension finder object

+ * @param string $root_path Root path

+ * @param string $php_ext PHP extension

+ */

+ public function __construct(phpbb_extension_finder $finder, $root_path, $php_ext)

+ {

+ $this->finder = $finder;

+ $this->root_path = $root_path;

+ $this->php_ext = $php_ext;

+ }

+

+ /**

+ * This listener is run when the KernelEvents::REQUEST event is triggered

+ *

+ * This is responsible for setting up the routing information

+ *

+ * @param GetResponseEvent $event

+ * @return null

+ */

+ public function on_kernel_request(GetResponseEvent $event)

+ {

+ $request = $event->getRequest();

+ $context = new RequestContext();

+ $context->fromRequest($request);

+

+ $matcher = phpbb_get_url_matcher($this->finder, $context, $this->root_path, $this->php_ext);

+ $router_listener = new RouterListener($matcher, $context);

+ $router_listener->onKernelRequest($event);

+ }

+

+ public static function getSubscribedEvents()

+ {

+ return array(

+ KernelEvents::REQUEST => 'on_kernel_request',

+ );

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+use Symfony\Component\EventDispatcher\EventSubscriberInterface;

+use Symfony\Component\HttpKernel\KernelEvents;

+use Symfony\Component\HttpKernel\Event\PostResponseEvent;

+

+class phpbb_event_kernel_terminate_subscriber implements EventSubscriberInterface

+{

+ /**

+ * This listener is run when the KernelEvents::TERMINATE event is triggered

+ * This comes after a Response has been sent to the server; this is

+ * primarily cleanup stuff.

+ *

+ * @param PostResponseEvent $event

+ * @return null

+ */

+ public function on_kernel_terminate(PostResponseEvent $event)

+ {

+ exit_handler();

+ }

+

+ public static function getSubscribedEvents()

+ {

+ return array(

+ KernelEvents::TERMINATE => 'on_kernel_terminate',

+ );

+ }

+}

+ * @return mixed Returns false after last step, otherwise

+ * temporary state which is passed as an

+ * argument to the next step

+ * @param phpbb_db_driver $db A database connection

+ public function __construct(phpbb_db_driver $db, phpbb_config $config, $extension_table, $phpbb_root_path, $php_ext = '.php', phpbb_cache_driver_interface $cache = null, $cache_name = '_ext')

+ $this->cache->purge();

+ $this->cache->purge();

+ $this->cache->purge();

+ $this->cache->purge();

+ $this->cache->purge();

+ new RecursiveDirectoryIterator($this->phpbb_root_path . 'ext/', FilesystemIterator::NEW_CURRENT_AND_KEY | FilesystemIterator::FOLLOW_SYMLINKS),

+ * @param phpbb_db_driver $db A database connection

+ public function __construct($ext_name, phpbb_db_driver $db, phpbb_extension_manager $extension_manager, $phpbb_root_path, $phpEx = '.php', phpbb_template $template, phpbb_config $config)

+use Symfony\Component\HttpFoundation\Request;

+

+* @param mixed $value filesize in bytes

+* (non-negative number; int, float or string)

+ 'tb' => array(

+ 'min' => 1099511627776, // pow(2, 40)

+ 'index' => 4,

+ 'si_unit' => 'TB',

+ 'iec_unit' => 'TIB',

+ ),

+* @return null

+ $version = phpbb_request_http_version();

+/**

+* Returns the HTTP version used in the current request.

+*

+* Handles the case of being called before $request is present,

+* in which case it falls back to the $_SERVER superglobal.

+*

+* @return string HTTP version

+*/

+function phpbb_request_http_version()

+{

+ global $request;

+

+ if ($request && $request->server('SERVER_PROTOCOL'))

+ {

+ return $request->server('SERVER_PROTOCOL');

+ }

+ else if (isset($_SERVER['SERVER_PROTOCOL']))

+ {

+ return $_SERVER['SERVER_PROTOCOL'];

+ }

+

+ return 'HTTP/1.0';

+}

+

+* @return null

+* Escapes and quotes a string for use as an HTML/XML attribute value.

+*

+* This is a port of Python xml.sax.saxutils quoteattr.

+*

+* The function will attempt to choose a quote character in such a way as to

+* avoid escaping quotes in the string. If this is not possible the string will

+* be wrapped in double quotes and double quotes will be escaped.

+*

+* @param string $data The string to be escaped

+* @param array $entities Associative array of additional entities to be escaped

+* @return string Escaped and quoted string

+*/

+function phpbb_quoteattr($data, $entities = null)

+{

+ $data = str_replace('&', '&amp;', $data);

+ $data = str_replace('>', '&gt;', $data);

+ $data = str_replace('<', '&lt;', $data);

+

+ $data = str_replace("\n", '&#10;', $data);

+ $data = str_replace("\r", '&#13;', $data);

+ $data = str_replace("\t", '&#9;', $data);

+

+ if (!empty($entities))

+ {

+ $data = str_replace(array_keys($entities), array_values($entities), $data);

+ }

+

+ if (strpos($data, '"') !== false)

+ {

+ if (strpos($data, "'") !== false)

+ {

+ $data = '"' . str_replace('"', '&quot;', $data) . '"';

+ }

+ else

+ {

+ $data = "'" . $data . "'";

+ }

+ }

+ else

+ {

+ $data = '"' . $data . '"';

+ }

+

+ return $data;

+}

+

+/**

+* Converts query string (GET) parameters in request into hidden fields.

+*

+* Useful for forwarding GET parameters when submitting forms with GET method.

+*

+* It is possible to omit some of the GET parameters, which is useful if

+* they are specified in the form being submitted.

+*

+* sid is always omitted.

+*

+* @param phpbb_request $request Request object

+* @param array $exclude A list of variable names that should not be forwarded

+* @return string HTML with hidden fields

+*/

+function phpbb_build_hidden_fields_for_query_params($request, $exclude = null)

+{

+ $names = $request->variable_names(phpbb_request_interface::GET);

+ $hidden = '';

+ foreach ($names as $name)

+ {

+ // Sessions are dealt with elsewhere, omit sid always

+ if ($name == 'sid')

+ {

+ continue;

+ }

+

+ // Omit any additional parameters requested

+ if (!empty($exclude) && in_array($name, $exclude))

+ {

+ continue;

+ }

+

+ $escaped_name = phpbb_quoteattr($name);

+

+ // Note: we might retrieve the variable from POST or cookies

+ // here. To avoid exposing cookies, skip variables that are

+ // overwritten somewhere other than GET entirely.

+ $value = $request->variable($name, '', true);

+ $get_value = $request->variable($name, '', true, phpbb_request_interface::GET);

+ if ($value === $get_value)

+ {

+ $escaped_value = phpbb_quoteattr($value);

+ $hidden .= "<input type='hidden' name=$escaped_name value=$escaped_value />";

+ }

+ }

+ return $hidden;

+}

+

+/**

+ global $phpbb_dispatcher, $request;

+ $hidden_fields_for_jumpbox = phpbb_build_hidden_fields_for_query_params($request, array('f'));

+

+ 'HIDDEN_FIELDS_FOR_JUMPBOX' => $hidden_fields_for_jumpbox,

+*

+* @param bool $run_cron Whether or not to run the cron

+* @param bool $display_template Whether or not to display the template

+* @param bool $exit_handler Whether or not to run the exit_handler()

+function page_footer($run_cron = true, $display_template = true, $exit_handler = true)

+ global $request, $phpbb_dispatcher, $phpbb_admin_path;

+ 'U_ACP' => ($auth->acl_get('a_') && !empty($user->data['is_registered'])) ? append_sid("{$phpbb_admin_path}index.$phpEx", false, true, $user->session_id) : '')

+ if ($display_template)

+ {

+ $template->display('body');

+ }

+

+ if ($exit_handler)

+ {

+ exit_handler();

+ }

+ if (!empty($phpbb_dispatcher))

+ {

+ $phpbb_dispatcher->dispatch('core.garbage_collection');

+ }

+

+/**

+* Convert either 3.0 dbms or 3.1 db driver class name to 3.1 db driver class name.

+*

+* If $dbms is a valid 3.1 db driver class name, returns it unchanged.

+* Otherwise prepends phpbb_db_driver_ to the dbms to convert a 3.0 dbms

+* to 3.1 db driver class name.

+*

+* @param string $dbms dbms parameter

+* @return db driver class

+*/

+function phpbb_convert_30_dbms_to_31($dbms)

+{

+ // Note: this check is done first because mysqli extension

+ // supplies a mysqli class, and class_exists($dbms) would return

+ // true for mysqli class.

+ // However, per the docblock any valid 3.1 driver name should be

+ // recognized by this function, and have priority over 3.0 dbms.

+ if (class_exists('phpbb_db_driver_' . $dbms))

+ {

+ return 'phpbb_db_driver_' . $dbms;

+ }

+

+ if (class_exists($dbms))

+ {

+ // Additionally we could check that $dbms extends phpbb_db_driver.

+ // http://php.net/manual/en/class.reflectionclass.php

+ // Beware of possible performance issues:

+ // http://stackoverflow.com/questions/294582/php-5-reflection-api-performance

+ // We could check for interface implementation in all paths or

+ // only when we do not prepend phpbb_db_driver_.

+

+ /*

+ $reflection = new \ReflectionClass($dbms);

+

+ if ($reflection->isSubclassOf('phpbb_db_driver'))

+ {

+ return $dbms;

+ }

+ */

+

+ return $dbms;

+ }

+

+ throw new \RuntimeException("You have specified an invalid dbms driver: $dbms");

+}

+

+/**

+* Create a Symfony Request object from phpbb_request object

+*

+* @param phpbb_request $request Request object

+* @return Request A Symfony Request object

+*/

+function phpbb_create_symfony_request(phpbb_request $request)

+{

+ // This function is meant to sanitize the global input arrays

+ $sanitizer = function(&$value, $key) {

+ $type_cast_helper = new phpbb_request_type_cast_helper();

+ $type_cast_helper->set_var($value, $value, gettype($value), true);

+ };

+

+ // We need to re-enable the super globals so we can access them here

+ $request->enable_super_globals();

+ $get_parameters = $_GET;

+ $post_parameters = $_POST;

+ $server_parameters = $_SERVER;

+ $files_parameters = $_FILES;

+ $cookie_parameters = $_COOKIE;

+ // And now disable them again for security

+ $request->disable_super_globals();

+

+ array_walk_recursive($get_parameters, $sanitizer);

+ array_walk_recursive($post_parameters, $sanitizer);

+

+ // Until we fix the issue with relative paths, we have to fake path info

+ // to allow urls like app.php?controller=foo/bar

+ $controller = $request->variable('controller', '');

+ $path_info = '/' . $controller;

+ $request_uri = $server_parameters['REQUEST_URI'];

+

+ // Remove the query string from REQUEST_URI

+ if ($pos = strpos($request_uri, '?'))

+ {

+ $request_uri = substr($request_uri, 0, $pos);

+ }

+

+ // Add the path info (i.e. controller route) to the REQUEST_URI

+ $server_parameters['REQUEST_URI'] = $request_uri . $path_info;

+ $server_parameters['SCRIPT_NAME'] = '';

+

+ return new Request($get_parameters, $post_parameters, array(), $cookie_parameters, $files_parameters, $server_parameters);

+}

+ 'ICON_MOVE_UP' => '<img src="' . htmlspecialchars($phpbb_admin_path) . 'images/icon_up.gif" alt="' . $user->lang['MOVE_UP'] . '" title="' . $user->lang['MOVE_UP'] . '" />',

+ 'ICON_MOVE_UP_DISABLED' => '<img src="' . htmlspecialchars($phpbb_admin_path) . 'images/icon_up_disabled.gif" alt="' . $user->lang['MOVE_UP'] . '" title="' . $user->lang['MOVE_UP'] . '" />',

+ 'ICON_MOVE_DOWN' => '<img src="' . htmlspecialchars($phpbb_admin_path) . 'images/icon_down.gif" alt="' . $user->lang['MOVE_DOWN'] . '" title="' . $user->lang['MOVE_DOWN'] . '" />',

+ 'ICON_MOVE_DOWN_DISABLED' => '<img src="' . htmlspecialchars($phpbb_admin_path) . 'images/icon_down_disabled.gif" alt="' . $user->lang['MOVE_DOWN'] . '" title="' . $user->lang['MOVE_DOWN'] . '" />',

+ 'ICON_EDIT' => '<img src="' . htmlspecialchars($phpbb_admin_path) . 'images/icon_edit.gif" alt="' . $user->lang['EDIT'] . '" title="' . $user->lang['EDIT'] . '" />',

+ 'ICON_EDIT_DISABLED' => '<img src="' . htmlspecialchars($phpbb_admin_path) . 'images/icon_edit_disabled.gif" alt="' . $user->lang['EDIT'] . '" title="' . $user->lang['EDIT'] . '" />',

+ 'ICON_DELETE' => '<img src="' . htmlspecialchars($phpbb_admin_path) . 'images/icon_delete.gif" alt="' . $user->lang['DELETE'] . '" title="' . $user->lang['DELETE'] . '" />',

+ 'ICON_DELETE_DISABLED' => '<img src="' . htmlspecialchars($phpbb_admin_path) . 'images/icon_delete_disabled.gif" alt="' . $user->lang['DELETE'] . '" title="' . $user->lang['DELETE'] . '" />',

+ 'ICON_SYNC' => '<img src="' . htmlspecialchars($phpbb_admin_path) . 'images/icon_sync.gif" alt="' . $user->lang['RESYNC'] . '" title="' . $user->lang['RESYNC'] . '" />',

+ 'ICON_SYNC_DISABLED' => '<img src="' . htmlspecialchars($phpbb_admin_path) . 'images/icon_sync_disabled.gif" alt="' . $user->lang['RESYNC'] . '" title="' . $user->lang['RESYNC'] . '" />',

+* Cache moderators. Called whenever permissions are changed

+* via admin_permissions. Changes of usernames and group names

+* must be carried through for the moderators table.

+*

+* @param phpbb_db_driver $db Database connection

+* @param phpbb_cache_driver_interface Cache driver

+* @param phpbb_auth $auth Authentication object

+* @return null

+function phpbb_cache_moderators($db, $cache, $auth)

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

+}

+

+/**

+* Removes moderators and administrators from foe lists.

+*

+* @param phpbb_db_driver $db Database connection

+* @param phpbb_auth $auth Authentication object

+* @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 phpbb_update_foes($db, $auth, $group_id = false, $user_id = false)

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

+}

+

+/**

+ * @return null

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2005 phpBB Group

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

+*

+*/

+

+use Symfony\Component\Config\FileLocator;

+use Symfony\Component\DependencyInjection\ContainerBuilder;

+use Symfony\Component\DependencyInjection\Dumper\PhpDumper;

+use Symfony\Component\DependencyInjection\Loader\YamlFileLoader;

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Create the ContainerBuilder object

+*

+* @param array $extensions Array of Container extension objects

+* @param string $phpbb_root_path Root path

+* @param string $php_ext PHP Extension

+* @return ContainerBuilder object

+*/

+function phpbb_create_container(array $extensions, $phpbb_root_path, $php_ext)

+{

+ $container = new ContainerBuilder();

+

+ foreach ($extensions as $extension)

+ {

+ $container->registerExtension($extension);

+ $container->loadFromExtension($extension->getAlias());

+ }

+

+ $container->setParameter('core.root_path', $phpbb_root_path);

+ $container->setParameter('core.php_ext', $php_ext);

+

+ return $container;

+}

+

+/**

+* Create installer container

+*

+* @param string $phpbb_root_path Root path

+* @param string $php_ext PHP Extension

+* @return ContainerBuilder object

+*/

+function phpbb_create_install_container($phpbb_root_path, $php_ext)

+{

+ $core = new phpbb_di_extension_core($phpbb_root_path);

+ $container = phpbb_create_container(array($core), $phpbb_root_path, $php_ext);

+

+ $container->setParameter('core.root_path', $phpbb_root_path);

+ $container->setParameter('core.php_ext', $php_ext);

+ $container->setParameter('core.table_prefix', '');

+

+ $container->register('dbal.conn')->setSynthetic(true);

+

+ $container->setAlias('cache.driver', 'cache.driver.install');

+

+ $container->compile();

+

+ return $container;

+}

+

+/**

+* Create a compiled ContainerBuilder object

+*

+* @param array $extensions Array of Container extension objects

+* @param array $passes Array of Compiler Pass objects

+* @param string $phpbb_root_path Root path

+* @param string $php_ext PHP Extension

+* @return ContainerBuilder object (compiled)

+*/

+function phpbb_create_compiled_container(array $extensions, array $passes, $phpbb_root_path, $php_ext)

+{

+ // Create a temporary container for access to the ext.manager service

+ $tmp_container = phpbb_create_container($extensions, $phpbb_root_path, $php_ext);

+ $tmp_container->compile();

+

+ // XXX stop writing to global $cache when

+ // http://tracker.phpbb.com/browse/PHPBB3-11203 is fixed

+ $GLOBALS['cache'] = $tmp_container->get('cache');

+ $installed_exts = $tmp_container->get('ext.manager')->all_enabled();

+

+ // Now pass the enabled extension paths into the ext compiler extension

+ $extensions[] = new phpbb_di_extension_ext($installed_exts);

+

+ // Create the final container to be compiled and cached

+ $container = phpbb_create_container($extensions, $phpbb_root_path, $php_ext);

+

+ // Compile the container

+ foreach ($passes as $pass)

+ {

+ $container->addCompilerPass($pass);

+ }

+ $container->compile();

+

+ return $container;

+}

+

+/**

+* Create a compiled and dumped ContainerBuilder object

+*

+* @param array $extensions Array of Container extension objects

+* @param array $passes Array of Compiler Pass objects

+* @param string $phpbb_root_path Root path

+* @param string $php_ext PHP Extension

+* @return ContainerBuilder object (compiled)

+*/

+function phpbb_create_dumped_container(array $extensions, array $passes, $phpbb_root_path, $php_ext)

+{

+ // Check for our cached container; if it exists, use it

+ $container_filename = phpbb_container_filename($phpbb_root_path, $php_ext);

+ if (file_exists($container_filename))

+ {

+ require($container_filename);

+ return new phpbb_cache_container();

+ }

+

+ $container = phpbb_create_compiled_container($extensions, $passes, $phpbb_root_path, $php_ext);

+

+ // Lastly, we create our cached container class

+ $dumper = new PhpDumper($container);

+ $cached_container_dump = $dumper->dump(array(

+ 'class' => 'phpbb_cache_container',

+ 'base_class' => 'Symfony\\Component\\DependencyInjection\\ContainerBuilder',

+ ));

+

+ file_put_contents($container_filename, $cached_container_dump);

+

+ return $container;

+}

+

+/**

+* Create an environment-specific ContainerBuilder object

+*

+* If debug is enabled, the container is re-compiled every time.

+* This ensures that the latest changes will always be reflected

+* during development.

+*

+* Otherwise it will get the existing dumped container and use

+* that one instead.

+*

+* @param array $extensions Array of Container extension objects

+* @param array $passes Array of Compiler Pass objects

+* @param string $phpbb_root_path Root path

+* @param string $php_ext PHP Extension

+* @return ContainerBuilder object (compiled)

+*/

+function phpbb_create_dumped_container_unless_debug(array $extensions, array $passes, $phpbb_root_path, $php_ext)

+{

+ $container_factory = defined('DEBUG') ? 'phpbb_create_compiled_container' : 'phpbb_create_dumped_container';

+ return $container_factory($extensions, $passes, $phpbb_root_path, $php_ext);

+}

+

+/**

+* Create a default ContainerBuilder object

+*

+* Contains the default configuration of the phpBB container.

+*

+* @param array $extensions Array of Container extension objects

+* @param array $passes Array of Compiler Pass objects

+* @return ContainerBuilder object (compiled)

+*/

+function phpbb_create_default_container($phpbb_root_path, $php_ext)

+{

+ return phpbb_create_dumped_container_unless_debug(

+ array(

+ new phpbb_di_extension_config($phpbb_root_path . 'config.' . $php_ext),

+ new phpbb_di_extension_core($phpbb_root_path),

+ ),

+ array(

+ new phpbb_di_pass_collection_pass(),

+ new phpbb_di_pass_kernel_pass(),

+ ),

+ $phpbb_root_path,

+ $php_ext

+ );

+}

+

+/**

+* Get the filename under which the dumped container will be stored.

+*

+* @param string $phpbb_root_path Root path

+* @param string $php_ext PHP Extension

+* @return Path for dumped container

+*/

+function phpbb_container_filename($phpbb_root_path, $php_ext)

+{

+ $filename = str_replace(array('/', '.'), array('slash', 'dot'), $phpbb_root_path);

+ return $phpbb_root_path . 'cache/container_' . $filename . '.' . $php_ext;

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Updates rows in given table from a set of values to a new value.

+* If this results in rows violating uniqueness constraints, the duplicate

+* rows are eliminated.

+*

+* The only supported table is bookmarks.

+*

+* @param phpbb_db_driver $db Database object

+* @param string $table Table on which to perform the update

+* @param string $column Column whose values to change

+* @param array $from_values An array of values that should be changed

+* @param int $to_value The new value

+* @return null

+*/

+function phpbb_update_rows_avoiding_duplicates(phpbb_db_driver $db, $table, $column, $from_values, $to_value)

+{

+ $sql = "SELECT $column, user_id

+ FROM $table

+ WHERE " . $db->sql_in_set($column, $from_values);

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

+

+ $old_user_ids = array();

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

+ {

+ $old_user_ids[$row[$column]][] = (int) $row['user_id'];

+ }

+ $db->sql_freeresult($result);

+

+ $sql = "SELECT $column, user_id

+ FROM $table

+ WHERE $column = " . (int) $to_value;

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

+

+ $new_user_ids = array();

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

+ {

+ $new_user_ids[$row[$column]][] = (int) $row['user_id'];

+ }

+ $db->sql_freeresult($result);

+

+ $queries = array();

+ foreach ($from_values as $from_value)

+ {

+ if (!isset($old_user_ids[$from_value]))

+ {

+ continue;

+ }

+ if (empty($new_user_ids))

+ {

+ $sql = "UPDATE $table

+ SET $column = " . (int) $to_value . "

+ WHERE $column = '" . $db->sql_escape($from_value) . "'";

+ $queries[] = $sql;

+ }

+ else

+ {

+ $different_user_ids = array_diff($old_user_ids[$from_value], $new_user_ids[$to_value]);

+ if (!empty($different_user_ids))

+ {

+ $sql = "UPDATE $table

+ SET $column = " . (int) $to_value . "

+ WHERE $column = '" . $db->sql_escape($from_value) . "'

+ AND " . $db->sql_in_set('user_id', $different_user_ids);

+ $queries[] = $sql;

+ }

+ }

+ }

+

+ if (!empty($queries))

+ {

+ $db->sql_transaction('begin');

+

+ foreach ($queries as $sql)

+ {

+ $db->sql_query($sql);

+ }

+

+ $sql = "DELETE FROM $table

+ WHERE " . $db->sql_in_set($column, $from_values);

+ $db->sql_query($sql);

+

+ $db->sql_transaction('commit');

+ }

+}

+

+/**

+* Updates rows in given table from a set of values to a new value.

+* If this results in rows violating uniqueness constraints, the duplicate

+* rows are merged respecting notify_status (0 takes precedence over 1).

+*

+* The only supported table is topics_watch.

+*

+* @param phpbb_db_driver $db Database object

+* @param string $table Table on which to perform the update

+* @param string $column Column whose values to change

+* @param array $from_values An array of values that should be changed

+* @param int $to_value The new value

+* @return null

+*/

+function phpbb_update_rows_avoiding_duplicates_notify_status(phpbb_db_driver $db, $table, $column, $from_values, $to_value)

+{

+ $sql = "SELECT $column, user_id, notify_status

+ FROM $table

+ WHERE " . $db->sql_in_set($column, $from_values);

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

+

+ $old_user_ids = array();

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

+ {

+ $old_user_ids[(int) $row['notify_status']][$row[$column]][] = (int) $row['user_id'];

+ }

+ $db->sql_freeresult($result);

+

+ $sql = "SELECT $column, user_id

+ FROM $table

+ WHERE $column = " . (int) $to_value;

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

+

+ $new_user_ids = array();

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

+ {

+ $new_user_ids[$row[$column]][] = (int) $row['user_id'];

+ }

+ $db->sql_freeresult($result);

+

+ $queries = array();

+ $extra_updates = array(

+ 0 => 'notify_status = 0',

+ 1 => '',

+ );

+ foreach ($from_values as $from_value)

+ {

+ foreach ($extra_updates as $notify_status => $extra_update)

+ {

+ if (!isset($old_user_ids[$notify_status][$from_value]))

+ {

+ continue;

+ }

+ if (empty($new_user_ids))

+ {

+ $sql = "UPDATE $table

+ SET $column = " . (int) $to_value . "

+ WHERE $column = '" . $db->sql_escape($from_value) . "'";

+ $queries[] = $sql;

+ }

+ else

+ {

+ $different_user_ids = array_diff($old_user_ids[$notify_status][$from_value], $new_user_ids[$to_value]);

+ if (!empty($different_user_ids))

+ {

+ $sql = "UPDATE $table

+ SET $column = " . (int) $to_value . "

+ WHERE $column = '" . $db->sql_escape($from_value) . "'

+ AND " . $db->sql_in_set('user_id', $different_user_ids);

+ $queries[] = $sql;

+ }

+

+ if ($extra_update)

+ {

+ $same_user_ids = array_diff($old_user_ids[$notify_status][$from_value], $different_user_ids);

+ if (!empty($same_user_ids))

+ {

+ $sql = "UPDATE $table

+ SET $extra_update

+ WHERE $column = '" . (int) $to_value . "'

+ AND " . $db->sql_in_set('user_id', $same_user_ids);

+ $queries[] = $sql;

+ }

+ }

+ }

+ }

+ }

+

+ if (!empty($queries))

+ {

+ $db->sql_transaction('begin');

+

+ foreach ($queries as $sql)

+ {

+ $db->sql_query($sql);

+ }

+

+ $sql = "DELETE FROM $table

+ WHERE " . $db->sql_in_set($column, $from_values);

+ $db->sql_query($sql);

+

+ $db->sql_transaction('commit');

+ }

+}

+ if ($request->is_ajax())

+ {

+ // Tell the ajax script what language vars and URL need to be replaced

+ $data = array(

+ 'NO_UNREAD_POSTS' => $user->lang['NO_UNREAD_POSTS'],

+ 'UNREAD_POSTS' => $user->lang['UNREAD_POSTS'],

+ 'U_MARK_FORUMS' => ($user->data['is_registered'] || $config['load_anon_lastread']) ? append_sid("{$phpbb_root_path}index.$phpEx", 'hash=' . generate_link_hash('global') . '&mark=forums&mark_time=' . time()) : '',

+ 'MESSAGE_TITLE' => $user->lang['INFORMATION'],

+ 'MESSAGE_TEXT' => $user->lang['FORUMS_MARKED']

+ );

+ $json_response = new phpbb_json_response();

+ $json_response->send($data);

+ }

+

+ if ($request->is_ajax())

+ {

+ // Tell the ajax script what language vars and URL need to be replaced

+ $data = array(

+ 'NO_UNREAD_POSTS' => $user->lang['NO_UNREAD_POSTS'],

+ 'UNREAD_POSTS' => $user->lang['UNREAD_POSTS'],

+ 'U_MARK_FORUMS' => ($user->data['is_registered'] || $config['load_anon_lastread']) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'hash=' . generate_link_hash('global') . '&f=' . $root_data['forum_id'] . '&mark=forums&mark_time=' . time()) : '',

+ 'MESSAGE_TITLE' => $user->lang['INFORMATION'],

+ 'MESSAGE_TEXT' => $user->lang['FORUMS_MARKED']

+ );

+ $json_response = new phpbb_json_response();

+ $json_response->send($data);

+ }

+

+* @return null

+* @param phpbb_db_driver $db The database object

+* @param phpbb_db_driver $db The database object

+* @param phpbb_db_driver $db The database object

+* @param phpbb_db_driver $db The database object

+ 'DRIVER' => 'phpbb_db_driver_firebird',

+ // Note: php 5.5 alpha 2 deprecated mysql.

+ // Keep mysqli before mysql in this list.

+ 'DRIVER' => 'phpbb_db_driver_mysqli',

+ 'DRIVER' => 'phpbb_db_driver_mysql',

+ 'DRIVER' => 'phpbb_db_driver_mssql',

+ 'DRIVER' => 'phpbb_db_driver_mssql_odbc',

+ 'DRIVER' => 'phpbb_db_driver_mssqlnative',

+ 'DRIVER' => 'phpbb_db_driver_oracle',

+ 'LABEL' => 'PostgreSQL 8.3+',

+ 'DRIVER' => 'phpbb_db_driver_postgres',

+ 'DRIVER' => 'phpbb_db_driver_sqlite',

+ $db = new $dbms();

+ if ($dbms_details['DRIVER'] != 'phpbb_db_driver_sqlite' && $dbms_details['DRIVER'] != 'phpbb_db_driver_oracle' && $dbname === '')

+ if ($dbms_details['DRIVER'] == 'phpbb_db_driver_sqlite' && stripos(phpbb_realpath($dbhost), phpbb_realpath('../')) === 0)

+ case 'phpbb_db_driver_mysql':

+ case 'phpbb_db_driver_mysqli':

+ case 'phpbb_db_driver_postgres':

+ case 'phpbb_db_driver_mssql':

+ case 'phpbb_db_driver_mssql_odbc':

+ case 'phpbb_db_driver_mssqlnative':

+ case 'phpbb_db_driver_sqlite':

+ case 'phpbb_db_driver_firebird':

+ case 'phpbb_db_driver_oracle':

+ case 'phpbb_db_driver_mysqli':

+ case 'phpbb_db_driver_sqlite':

+ case 'phpbb_db_driver_firebird':

+ case 'phpbb_db_driver_oracle':

+ case 'phpbb_db_driver_postgres':

+

+ 'adm_relative_path' => 'adm/',

+

+ $tpl = new phpbb_template($phpbb_root_path, $phpEx, $config, $user, $style_resource_locator, new phpbb_template_context(), $phpbb_extension_manager);

+ $style->set_custom_style($template_lang . '_email', array($template_path, $fallback_template_path), array(), '');

+ $lock = new phpbb_lock_flock($this->cache_file);

+ $lock->acquire();

+ // avoid races, check file existence once

+ $have_cache_file = file_exists($this->cache_file);

+ if (!$have_cache_file || $config['last_queue_run'] > time() - $config['queue_interval'])

+ if (!$have_cache_file)

+ {

+ set_config('last_queue_run', time(), true);

+ }

+

+ $lock->release();

+ set_config('last_queue_run', time(), true);

+

+ $lock->release();

+ $lock->release();

+ $lock = new phpbb_lock_flock($this->cache_file);

+ $lock->acquire();

+ $lock->release();

+ $u_title = $module_url . $delim . 'i=';

+ // if the item has a name use it, else use its id

+ if (empty($item_ary['name']))

+ {

+ $u_title .= $item_ary['id'];

+ }

+ else

+ {

+ // if the category has a name, then use it.

+ $u_title .= $item_ary['name'];

+ }

+ // If the item is not a category append the mode

+ if (!$item_ary['cat'])

+ {

+ if ($item_ary['is_duplicate'])

+ {

+ $u_title .= '&amp;icat=' . $current_id;

+ }

+ $u_title .= '&amp;mode=' . $item_ary['mode'];

+ }

+ // Check the permissions for post approval.

+ // Moderators must go through post approval like ordinary users.

+ if (!$auth->acl_get('f_noapprove', $data['forum_id']))

+ $this->extension = strtolower(self::get_extension($this->realname));

+ *

+ * @param string Filename that needs to be checked

+ * @return string Extension of the supplied filename

+ static public function get_extension($filename)

+ $types = fileupload::image_types();

+ * Get image type/extension mapping

+ *

+ * @return array Array containing the image types and their extensions

+ static public function image_types()

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2005 phpBB Group

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

+*

+*/

+

+use Symfony\Component\Routing\Matcher\Dumper\PhpMatcherDumper;

+use Symfony\Component\Routing\Matcher\UrlMatcher;

+use Symfony\Component\Routing\RequestContext;

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Create a new UrlMatcher class and dump it into the cache file

+*

+* @param phpbb_extension_finder $finder Extension finder

+* @param RequestContext $context Symfony RequestContext object

+* @param string $root_path Root path

+* @param string $php_ext PHP extension

+* @return null

+*/

+function phpbb_get_url_matcher(phpbb_extension_finder $finder, RequestContext $context, $root_path, $php_ext)

+{

+ if (defined('DEBUG'))

+ {

+ return phpbb_create_url_matcher($finder, $context);

+ }

+

+ if (!phpbb_url_matcher_dumped($root_path, $php_ext))

+ {

+ phpbb_create_dumped_url_matcher($finder, $root_path, $php_ext);

+ }

+

+ return phpbb_load_url_matcher($context, $root_path, $php_ext);

+}

+

+/**

+* Create a new UrlMatcher class and dump it into the cache file

+*

+* @param phpbb_extension_finder $finder Extension finder

+* @param string $root_path Root path

+* @param string $php_ext PHP extension

+* @return null

+*/

+function phpbb_create_dumped_url_matcher(phpbb_extension_finder $finder, $root_path, $php_ext)

+{

+ $provider = new phpbb_controller_provider();

+ $routes = $provider->import_paths_from_finder($finder)->find();

+ $dumper = new PhpMatcherDumper($routes);

+ $cached_url_matcher_dump = $dumper->dump(array(

+ 'class' => 'phpbb_url_matcher',

+ ));

+

+ file_put_contents($root_path . 'cache/url_matcher' . $php_ext, $cached_url_matcher_dump);

+}

+

+/**

+* Create a non-cached UrlMatcher

+*

+* @param phpbb_extension_finder $finder Extension finder

+* @param RequestContext $context Symfony RequestContext object

+* @return UrlMatcher

+*/

+function phpbb_create_url_matcher(phpbb_extension_finder $finder, RequestContext $context)

+{

+ $provider = new phpbb_controller_provider();

+ $routes = $provider->import_paths_from_finder($finder)->find();

+ return new UrlMatcher($routes, $context);

+}

+

+/**

+* Load the cached phpbb_url_matcher class

+*

+* @param RequestContext $context Symfony RequestContext object

+* @param string $root_path Root path

+* @param string $php_ext PHP extension

+* @return phpbb_url_matcher

+*/

+function phpbb_load_url_matcher(RequestContext $context, $root_path, $php_ext)

+{

+ require($root_path . 'cache/url_matcher' . $php_ext);

+ return new phpbb_url_matcher($context);

+}

+

+/**

+* Determine whether we have our dumped URL matcher

+*

+* The class is automatically dumped to the cache directory

+*

+* @param string $root_path Root path

+* @param string $php_ext PHP extension

+* @return bool True if it exists, false if not

+*/

+function phpbb_url_matcher_dumped($root_path, $php_ext)

+{

+ return file_exists($root_path . 'cache/url_matcher' . $php_ext);

+}

+ if (isset($sql_ary['group_avatar']))

+ if (isset($sql_ary['group_rank']))

+ global $db, $cache, $auth, $phpbb_root_path, $phpEx, $phpbb_dispatcher;

+ if (!function_exists('phpbb_cache_moderators'))

+ phpbb_cache_moderators($db, $cache, $auth);

+ AND user_avatar = '" . $db->sql_escape($row['group_avatar']) . "'

+ AND " . $db->sql_in_set('user_id', $user_ids);

+ AND user_rank <> 0

+ AND user_rank = ' . (int)$row['group_rank'] . '

+ AND ' . $db->sql_in_set('user_id', $user_ids);

+ $sql = 'SELECT user_id

+ FROM ' . USER_GROUP_TABLE . "

+ $sql = 'SELECT user_id, group_id

+ FROM ' . USERS_TABLE . '

+ global $phpbb_container, $db, $phpbb_dispatcher;

+ $updated_sql_ary = $sql_ary;

+

+ // Before we update the user attributes, we will update the rank for users that don't have a custom rank

+ if (isset($sql_ary['user_rank']))

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET ' . $db->sql_build_array('UPDATE', array('user_rank' => $sql_ary['user_rank'])) . '

+ WHERE user_rank = 0

+ AND ' . $db->sql_in_set('user_id', $user_id_ary);

+ $db->sql_query($sql);

+ unset($sql_ary['user_rank']);

+ }

+ // Before we update the user attributes, we will update the avatar for users that don't have a custom avatar

+ $avatar_options = array('user_avatar', 'user_avatar_type', 'user_avatar_height', 'user_avatar_width');

+

+ if (isset($sql_ary['user_avatar']))

+ {

+ $avatar_sql_ary = array();

+ foreach ($avatar_options as $avatar_option)

+ if (isset($sql_ary[$avatar_option]))

+ {

+ $avatar_sql_ary[$avatar_option] = $sql_ary[$avatar_option];

+ }

+ }

+

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET ' . $db->sql_build_array('UPDATE', $avatar_sql_ary) . "

+ WHERE user_avatar = ''

+ AND " . $db->sql_in_set('user_id', $user_id_ary);

+ $db->sql_query($sql);

+

+ // Remove the avatar options, as we already updated them

+ foreach ($avatar_options as $avatar_option)

+ unset($sql_ary[$avatar_option]);

+ if (!empty($sql_ary))

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '

+ WHERE ' . $db->sql_in_set('user_id', $user_id_ary);

+ $db->sql_query($sql);

+ }

+ $sql = 'UPDATE ' . FORUMS_TABLE . "

+ SET forum_last_poster_colour = '" . $db->sql_escape($sql_ary['user_colour']) . "'

+ $sql = 'UPDATE ' . TOPICS_TABLE . "

+ SET topic_first_poster_colour = '" . $db->sql_escape($sql_ary['user_colour']) . "'

+ $sql = 'UPDATE ' . TOPICS_TABLE . "

+ SET topic_last_poster_colour = '" . $db->sql_escape($sql_ary['user_colour']) . "'

+ // Make all values available for the event

+ $sql_ary = $updated_sql_ary;

+

+ $phpbb_container->get('cache.driver')->destroy('sql', MODERATOR_CACHE_TABLE);

+ global $db, $cache, $auth;

+ if (!function_exists('phpbb_cache_moderators'))

+ phpbb_cache_moderators($db, $cache, $auth);

+ if (!function_exists('phpbb_update_foes'))

+ phpbb_update_foes($db, $auth, array($group_id));

+ * @return null

+ * @return null

+ * @return null

+ * @return null

+ * @return null

+<?php

+/**

+*

+* @package extension

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* The hook finder locates installed hooks.

+*

+* @package phpBB3

+*/

+class phpbb_hook_finder

+{

+ protected $phpbb_root_path;

+ protected $cache;

+ protected $php_ext;

+

+ /**

+ * Creates a new finder instance.

+ *

+ * @param string $phpbb_root_path Path to the phpbb root directory

+ * @param string $php_ext php file extension

+ * @param phpbb_cache_driver_interface $cache A cache instance or null

+ */

+ public function __construct($phpbb_root_path, $php_ext, phpbb_cache_driver_interface $cache = null)

+ {

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->cache = $cache;

+ $this->php_ext = $php_ext;

+ }

+

+ /**

+ * Finds all hook files.

+ *

+ * @param bool $cache Whether the result should be cached

+ * @return array An array of paths to found hook files

+ */

+ public function find($cache = true)

+ {

+ if (!defined('DEBUG') && $cache && $this->cache)

+ {

+ $hook_files = $this->cache->get('_hooks');

+ if ($hook_files !== false)

+ {

+ return $hook_files;

+ }

+ }

+

+ $hook_files = array();

+

+ // Now search for hooks...

+ $dh = @opendir($this->phpbb_root_path . 'includes/hooks/');

+

+ if ($dh)

+ {

+ while (($file = readdir($dh)) !== false)

+ {

+ if (strpos($file, 'hook_') === 0 && substr($file, -(strlen($this->php_ext) + 1)) === '.' . $this->php_ext)

+ {

+ $hook_files[] = substr($file, 0, -(strlen($this->php_ext) + 1));

+ }

+ }

+ closedir($dh);

+ }

+

+ if ($cache && $this->cache)

+ {

+ $this->cache->put('_hooks', $hook_files);

+ }

+

+ return $hook_files;

+ }

+}

+ * @var phpbb_db_driver

+ * @param phpbb_db_driver $db A database connection

+ public function __construct($config_name, phpbb_config $config, phpbb_db_driver $db)

+ * @return null

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* File locking class

+* @package phpBB3

+*/

+class phpbb_lock_flock

+{

+ /**

+ * Path to the file to which access is controlled

+ *

+ * @var string

+ */

+ private $path;

+

+ /**

+ * File pointer for the lock file

+ * @var string

+ */

+ private $lock_fp;

+

+ /**

+ * Constructor.

+ *

+ * You have to call acquire() to actually acquire the lock.

+ *

+ * @param string $path Path to the file to which access is controlled

+ */

+ public function __construct($path)

+ {

+ $this->path = $path;

+ $this->lock_fp = null;

+ }

+

+ /**

+ * Tries to acquire the lock.

+ *

+ * If the lock is already held by another process, this call will block

+ * until the other process releases the lock. If a lock is acquired and

+ * is not released before script finishes but the process continues to

+ * live (apache/fastcgi) then subsequent processes trying to acquire

+ * the same lock will be blocked forever.

+ *

+ * If the lock is already held by the same process via another instance

+ * of this class, this call will block forever.

+ *

+ * If flock function is disabled in php or fails to work, lock

+ * acquisition will fail and false will be returned.

+ *

+ * @return bool true if lock was acquired

+ * false otherwise

+ */

+ public function acquire()

+ {

+ if ($this->lock_fp)

+ {

+ return false;

+ }

+

+ // For systems that can't have two processes opening

+ // one file for writing simultaneously

+ if (file_exists($this->path . '.lock'))

+ {

+ $mode = 'rb';

+ }

+ else

+ {

+ $mode = 'wb';

+ }

+

+ $this->lock_fp = @fopen($this->path . '.lock', $mode);

+

+ if ($mode == 'wb')

+ {

+ if (!$this->lock_fp)

+ {

+ // Two processes may attempt to create lock file at the same time.

+ // Have the losing process try opening the lock file again for reading

+ // on the assumption that the winning process created it

+ $mode = 'rb';

+ $this->lock_fp = @fopen($this->path . '.lock', $mode);

+ }

+ else

+ {

+ // Only need to set mode when the lock file is written

+ @chmod($this->path . '.lock', 0666);

+ }

+ }

+

+ if ($this->lock_fp)

+ {

+ @flock($this->lock_fp, LOCK_EX);

+ }

+

+ return (bool) $this->lock_fp;

+ }

+

+ /**

+ * Releases the lock.

+ *

+ * The lock must have been previously obtained, that is, acquire() call

+ * was issued and returned true.

+ *

+ * Note: Attempting to release a lock that is already released,

+ * that is, calling release() multiple times, is harmless.

+ *

+ * @return null

+ */

+ public function release()

+ {

+ if ($this->lock_fp)

+ {

+ @flock($this->lock_fp, LOCK_UN);

+ fclose($this->lock_fp);

+ $this->lock_fp = null;

+ }

+ }

+}

+ if (!function_exists('phpbb_update_rows_avoiding_duplicates_notify_status'))

+ {

+ include($phpbb_root_path . 'includes/functions_database_helper.' . $phpEx);

+ }

+

+ // Update the topic watch table.

+ phpbb_update_rows_avoiding_duplicates_notify_status($db, TOPICS_WATCH_TABLE, 'topic_id', $topic_ids, $to_topic_id);

+ // Update the bookmarks table.

+ phpbb_update_rows_avoiding_duplicates($db, BOOKMARKS_TABLE, 'topic_id', $topic_ids, $to_topic_id);

+ // Copy topic subscriptions to new topic

+

+ // Copy bookmarks to new topic

+ $sql = 'SELECT user_id

+ FROM ' . BOOKMARKS_TABLE . '

+ WHERE topic_id = ' . $topic_id;

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

+

+ $sql_ary = array();

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

+ {

+ $sql_ary[] = array(

+ 'topic_id' => (int) $new_topic_id,

+ 'user_id' => (int) $row['user_id'],

+ );

+ }

+ $db->sql_freeresult($result);

+

+ if (sizeof($sql_ary))

+ {

+ $db->sql_multi_insert(BOOKMARKS_TABLE, $sql_ary);

+ }

+ $report['report_text'] = make_clickable(bbcode_nl2br($report['report_text']));

+ $sql = 'SELECT r.post_id, r.user_id, r.report_id, r.report_closed, report_time, r.report_text, r.reported_post_text, r.reported_post_uid, r.reported_post_bitfield, r.reported_post_enable_magic_url, r.reported_post_enable_smilies, r.reported_post_enable_bbcode, rr.reason_title, rr.reason_description, u.username, u.username_clean, u.user_colour

+

+ $parse_post_flags = $report['reported_post_enable_bbcode'] ? OPTION_FLAG_BBCODE : 0;

+ $parse_post_flags += $report['reported_post_enable_smilies'] ? OPTION_FLAG_SMILIES : 0;

+ $parse_post_flags += $report['reported_post_enable_magic_url'] ? OPTION_FLAG_LINKS : 0;

+ parse_attachments($post_info['forum_id'], $report['reported_post_text'], $attachments, $update_count);

+ 'POST_PREVIEW' => generate_text_for_display($report['reported_post_text'], $report['reported_post_uid'], $report['reported_post_bitfield'], $parse_post_flags, false),

+ // Copy topic subscriptions to new topic

+ $sql = 'SELECT user_id, notify_status

+ FROM ' . TOPICS_WATCH_TABLE . '

+ WHERE topic_id = ' . $topic_id;

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

+

+ $sql_ary = array();

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

+ {

+ $sql_ary[] = array(

+ 'topic_id' => (int) $to_topic_id,

+ 'user_id' => (int) $row['user_id'],

+ 'notify_status' => (int) $row['notify_status'],