+ global $db, $user, $phpbb_root_path, $phpEx, $phpbb_container;

+ $provider_collection = $phpbb_container->get('auth.provider_collection');

+ $provider = $provider_collection->get_provider();

+ 'user_row' => $this->user_row($php_auth_user, $php_auth_pw),

+ user_add($this->user_row($php_auth_user, $php_auth_pw));

+ $sql = 'SELECT *

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

+ if ($this->passwords_manager->check($password, $row['user_password'], $row))

+ 'error_msg' => 'LOGIN_ERROR_PASSWORD',

+ 'AUTH_LDAP_BASE_DN' => $new_config['ldap_base_dn'],

+ * @param string $provider_name The name of the auth provider

+ public function get_provider($provider_name = '')

+ $provider_name = ($provider_name !== '') ? $provider_name : basename(trim($this->config['auth_method']));

+ if ($this->offsetExists('auth.provider.' . $provider_name))

+ return $this->offsetGet('auth.provider.' . $provider_name);

+ $avatar_list = ($this->cache == null) ? false : $this->cache->get('_avatar_local_list');

+ $this->cache->put('_avatar_local_list', $avatar_list, 86400);

+ // read some data to ensure headers are present

+ fread($file_stream, 1024);

+

+ if (isset($meta['wrapper_data']['headers']) && is_array($meta['wrapper_data']['headers']))

+ {

+ $headers = $meta['wrapper_data']['headers'];

+ }

+ else if (isset($meta['wrapper_data']) && is_array($meta['wrapper_data']))

+ {

+ $headers = $meta['wrapper_data'];

+ }

+ else

+ {

+ $headers = array();

+ }

+

+ foreach ($headers as $header)

+ $result = $this->prefix_avatar_columns($prefix, self::$default_row);

+ $sql = 'UPDATE ' . $table . '

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

+ WHERE ' . $prefix . 'id = ' . (int) $avatar_data['id'];

+ $db->sql_query($sql);

+

+ // Make sure we also delete this avatar from the users

+ if ($prefix === 'group_')

+ $result = $this->prefix_avatar_columns('user_', self::$default_row);

+

+ $sql = 'UPDATE ' . USERS_TABLE . '

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

+ WHERE user_avatar = '" . $db->sql_escape($avatar_data['avatar']) . "'";

+ $db->sql_query($sql);

+ }

+ /**

+ * Prefix avatar columns

+ *

+ * @param string $prefix Column prefix

+ * @param array $data Column data

+ *

+ * @return array Column data with prefixed column names

+ */

+ public function prefix_avatar_columns($prefix, $data)

+ {

+ foreach ($data as $key => $value)

+ {

+ $data[$prefix . $key] = $value;

+ unset($data[$key]);

+ }

+

+ return $data;

+ $var_name = $this->clean_varname($var_name);

+ $filename = $this->clean_varname($filename);

+ $filename = $this->clean_varname($filename);

+

+ /**

+ * Replace slashes in the file name

+ *

+ * @param string $varname name of a cache variable

+ * @return string $varname name that is safe to use as a filename

+ */

+ protected function clean_varname($varname)

+ {

+ return str_replace('/', '-', $varname);

+ }

+ if (!preg_match_all('/(?:FROM \\(?(`?\\w+`?(?: \\w+)?(?:, ?`?\\w+`?(?: \\w+)?)*)\\)?)|(?:JOIN (`?\\w+`?(?: \\w+)?))/', $query, $regs, PREG_SET_ORDER))

+

+ $tables = array();

+ foreach ($regs as $match)

+ {

+ if ($match[0][0] == 'F')

+ {

+ $tables = array_merge($tables, array_map('trim', explode(',', $match[1])));

+ }

+ else

+ {

+ $tables[] = $match[2];

+ }

+ }

+ /**

+ * Constructor

+ */

+ public function __construct()

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

+ if (!$this->db->sql_affectedrows() && isset($this->config[$key]))

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

+ /** @var \phpbb\log\log_interface */

+ public function __construct(\phpbb\user $user, \phpbb\cache\driver\driver_interface $cache, \phpbb\db\driver\driver_interface $db, \phpbb\auth\auth $auth, \phpbb\log\log_interface $log, \phpbb\config\config $config)

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\console\command\db;

+

+use phpbb\user;

+use phpbb\db\migrator_output_handler_interface;

+use Symfony\Component\Console\Output\OutputInterface;

+

+class console_migrator_output_handler implements migrator_output_handler_interface

+{

+ /**

+ * User object.

+ *

+ * @var user

+ */

+ private $user;

+

+ /**

+ * Console output object.

+ *

+ * @var OutputInterface

+ */

+ private $output;

+

+ /**

+ * Constructor

+ *

+ * @param user $user User object

+ * @param OutputInterface $output Console output object

+ */

+ public function __construct(user $user, OutputInterface $output)

+ {

+ $this->user = $user;

+ $this->output = $output;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function write($message, $verbosity)

+ {

+ if ($verbosity <= $this->output->getVerbosity())

+ {

+ $translated_message = call_user_func_array(array($this->user, 'lang'), $message);

+

+ if ($verbosity === migrator_output_handler_interface::VERBOSITY_NORMAL)

+ {

+ $translated_message = '<info>' . $translated_message . '</info>';

+ }

+ else if ($verbosity === migrator_output_handler_interface::VERBOSITY_VERBOSE)

+ {

+ $translated_message = '<comment>' . $translated_message . '</comment>';

+ }

+

+ $this->output->writeln($translated_message);

+ }

+ }

+}

+ /** @var string phpBB root path */

+ protected $phpbb_root_path;

+

+ function __construct(\phpbb\user $user, \phpbb\db\migrator $migrator, \phpbb\extension\manager $extension_manager, \phpbb\config\config $config, \phpbb\cache\service $cache, \phpbb\log\log $log, $phpbb_root_path)

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->migrator->set_output_handler(new \phpbb\db\log_wrapper_migrator_output_handler($this->user, new console_migrator_output_handler($this->user, $output), $this->phpbb_root_path . 'store/migrations_' . time() . '.log'));

+

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

+

+ * Event dispatcher object

+ * @var \phpbb\event\dispatcher_interface

+ */

+ protected $phpbb_dispatcher;

+

+ /**

+ * @param \phpbb\event\dispatcher_interface $phpbb_dispatcher Event dispatcher object

+ public function __construct(\phpbb\auth\auth $auth, \phpbb\config\config $config, \phpbb\event\dispatcher_interface $phpbb_dispatcher, \phpbb\db\driver\driver_interface $db, \phpbb\user $user, $phpbb_root_path, $php_ext, $forums_table, $posts_table, $topics_table, $users_table)

+ $this->phpbb_dispatcher = $phpbb_dispatcher;

+ $where_sql = '';

+

+ $get_visibility_sql_overwrite = false;

+

+ /**

+ * Allow changing the result of calling get_visibility_sql

+ *

+ * @event core.phpbb_content_visibility_get_visibility_sql_before

+ * @var string where_sql Extra visibility conditions. It must end with either an SQL "AND" or an "OR"

+ * @var string mode Either "topic" or "post" depending on the query this is being used in

+ * @var array forum_id The forum id in which the search is made.

+ * @var string table_alias Table alias to prefix in SQL queries

+ * @var mixed get_visibility_sql_overwrite If a string, forces the function to return get_forums_visibility_sql_overwrite after executing the event

+ * If false, get_visibility_sql continues normally

+ * It must be either boolean or string

+ * @since 3.1.4-RC1

+ */

+ $vars = array(

+ 'where_sql',

+ 'mode',

+ 'forum_id',

+ 'table_alias',

+ 'get_visibility_sql_overwrite',

+ );

+ extract($this->phpbb_dispatcher->trigger_event('core.phpbb_content_visibility_get_visibility_sql_before', compact($vars)));

+

+ if ($get_visibility_sql_overwrite !== false)

+ {

+ return $get_visibility_sql_overwrite;

+ }

+

+ return $where_sql . '1 = 1';

+ return $where_sql . $table_alias . $mode . '_visibility = ' . ITEM_APPROVED;

+ $get_forums_visibility_sql_overwrite = false;

+ /**

+ * Allow changing the result of calling get_forums_visibility_sql

+ *

+ * @event core.phpbb_content_visibility_get_forums_visibility_before

+ * @var string where_sql The action the user tried to execute

+ * @var string mode Either "topic" or "post" depending on the query this is being used in

+ * @var array forum_ids Array of forum ids which the posts/topics are limited to

+ * @var string table_alias Table alias to prefix in SQL queries

+ * @var array approve_forums Array of forums where the user has m_approve permissions

+ * @var mixed get_forums_visibility_sql_overwrite If a string, forces the function to return get_forums_visibility_sql_overwrite after executing the event

+ * If false, get_forums_visibility_sql continues normally

+ * It must be either boolean or string

+ * @since 3.1.3-RC1

+ */

+ $vars = array(

+ 'where_sql',

+ 'mode',

+ 'forum_ids',

+ 'table_alias',

+ 'approve_forums',

+ 'get_forums_visibility_sql_overwrite',

+ );

+ extract($this->phpbb_dispatcher->trigger_event('core.phpbb_content_visibility_get_forums_visibility_before', compact($vars)));

+

+ if ($get_forums_visibility_sql_overwrite !== false)

+ {

+ return $get_forums_visibility_sql_overwrite;

+ }

+

+ $visibility_sql_overwrite = null;

+

+ /**

+ * Allow changing the result of calling get_global_visibility_sql

+ *

+ * @event core.phpbb_content_visibility_get_global_visibility_before

+ * @var array where_sqls The action the user tried to execute

+ * @var string mode Either "topic" or "post" depending on the query this is being used in

+ * @var array exclude_forum_ids Array of forum ids the current user doesn't have access to

+ * @var string table_alias Table alias to prefix in SQL queries

+ * @var array approve_forums Array of forums where the user has m_approve permissions

+ * @var string visibility_sql_overwrite Forces the function to return an implosion of where_sqls (joined by "OR")

+ * @since 3.1.3-RC1

+ */

+ $vars = array(

+ 'where_sqls',

+ 'mode',

+ 'exclude_forum_ids',

+ 'table_alias',

+ 'approve_forums',

+ 'visibility_sql_overwrite',

+ );

+ extract($this->phpbb_dispatcher->trigger_event('core.phpbb_content_visibility_get_global_visibility_before', compact($vars)));

+

+ if ($visibility_sql_overwrite)

+ {

+ return $visibility_sql_overwrite;

+ }

+

+ /* @var \phpbb\request\request_interface */

+ protected $request;

+

+ * @param \phpbb\request\request_interface $request phpBB request object

+ public function __construct(\phpbb\template\template $template, \phpbb\user $user, \phpbb\config\config $config, \phpbb\controller\provider $provider, \phpbb\extension\manager $manager, \phpbb\symfony_request $symfony_request, \phpbb\request\request_interface $request, \phpbb\filesystem $filesystem, $phpbb_root_path, $php_ext)

+ $this->request = $request;

+ // We need to update the base url to move to the directory of the app.php file if the current script is not app.php

+ if ($page_name !== 'app.php')

+ if (empty($this->config['enable_mod_rewrite']))

+ {

+ $base_url = str_replace('/app.' . $this->php_ext, '/' . $this->phpbb_root_path . 'app.' . $this->php_ext, $base_url);

+ }

+ else

+ {

+ $base_url .= preg_replace(get_preg_expression('path_remove_dot_trailing_slash'), '$2', $this->phpbb_root_path);

+ }

+ $base_url = $this->request->escape($this->filesystem->clean_path($base_url), true);

+ *

+ * @deprecated 3.1.3 (To be removed: 3.3.0) Use exceptions instead.

+ return $this->message($message, array(), 'INFORMATION', $code);

+ }

+

+ /**

+ * Output a message

+ *

+ * In case of an error, please throw an exception instead

+ *

+ * @param string $message The message to display (must be a language variable)

+ * @param array $parameters The parameters to use with the language var

+ * @param string $title Title for the message (must be a language variable)

+ * @param int $code The HTTP status code (e.g. 404, 500, 503, etc.)

+ * @return Response A Response instance

+ */

+ public function message($message, array $parameters = array(), $title = 'INFORMATION', $code = 200)

+ {

+ array_unshift($parameters, $message);

+ 'MESSAGE_TEXT' => call_user_func_array(array($this->user, 'lang'), $parameters),

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

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

+ return generate_board_url(true) . $this->request->escape($this->symfony_request->getRequestUri(), true);

+ shuffle($this->tasks);

+ return $this->config['last_queue_run'] < time() - $this->config['queue_interval'];

+ $this->persistency = $persistency;

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db;

+

+use phpbb\user;

+

+class html_migrator_output_handler implements migrator_output_handler_interface

+{

+ /**

+ * User object.

+ *

+ * @var user

+ */

+ private $user;

+

+ /**

+ * Constructor

+ *

+ * @param user $user User object

+ */

+ public function __construct(user $user)

+ {

+ $this->user = $user;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function write($message, $verbosity)

+ {

+ if ($verbosity <= migrator_output_handler_interface::VERBOSITY_VERBOSE)

+ {

+ $final_message = call_user_func_array(array($this->user, 'lang'), $message);

+ echo $final_message . "<br />\n";

+ }

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db;

+

+use phpbb\user;

+

+class log_wrapper_migrator_output_handler implements migrator_output_handler_interface

+{

+ /**

+ * User object.

+ *

+ * @var user

+ */

+ protected $user;

+

+ /**

+ * A migrator output handler

+ *

+ * @var migrator_output_handler_interface

+ */

+ protected $migrator;

+

+ /**

+ * Log file handle

+ * @var resource

+ */

+ protected $file_handle = false;

+

+ /**

+ * Constructor

+ *

+ * @param user $user User object

+ * @param migrator_output_handler_interface $migrator Migrator output handler

+ * @param string $log_file File to log to

+ */

+ public function __construct(user $user, migrator_output_handler_interface $migrator, $log_file)

+ {

+ $this->user = $user;

+ $this->migrator = $migrator;

+ $this->file_open($log_file);

+ }

+

+ /**

+ * Open file for logging

+ *

+ * @param string $file File to open

+ */

+ protected function file_open($file)

+ {

+ if (phpbb_is_writable(dirname($file)))

+ {

+ $this->file_handle = fopen($file, 'w');

+ }

+ else

+ {

+ throw new \RuntimeException('Unable to write to migrator log file');

+ }

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function write($message, $verbosity)

+ {

+ $this->migrator->write($message, $verbosity);

+

+ if ($this->file_handle !== false)

+ {

+ $translated_message = call_user_func_array(array($this->user, 'lang'), $message) . "\n";

+

+ if ($verbosity <= migrator_output_handler_interface::VERBOSITY_NORMAL)

+ {

+ $translated_message = '[INFO] ' . $translated_message;

+ }

+ else

+ {

+ $translated_message = '[DEBUG] ' . $translated_message;

+ }

+

+ fwrite($this->file_handle, $translated_message);

+ fflush($this->file_handle);

+ }

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration;

+

+use Symfony\Component\DependencyInjection\ContainerAwareInterface;

+use Symfony\Component\DependencyInjection\ContainerInterface;

+

+/**

+* Abstract base class for container aware database migrations.

+*/

+abstract class container_aware_migration extends migration implements ContainerAwareInterface

+{

+ /**

+ * @var ContainerInterface

+ */

+ protected $container;

+

+ /**

+ * {@inheritdoc}

+ */

+ public function setContainer(ContainerInterface $container = null)

+ {

+ $this->container = $container;

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_13 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.13', '>=') && phpbb_version_compare($this->config['version'], '3.1.0-dev', '<');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_13_rc1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('if', array(

+ phpbb_version_compare($this->config['version'], '3.0.13', '<'),

+ array('config.update', array('version', '3.0.13')),

+ )),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_13_pl1 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.13-PL1', '>=') && phpbb_version_compare($this->config['version'], '3.1.0-dev', '<');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_13');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('if', array(

+ phpbb_version_compare($this->config['version'], '3.0.13-PL1', '<'),

+ array('config.update', array('version', '3.0.13-PL1')),

+ )),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_13_rc1 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.13-RC1', '>=') && phpbb_version_compare($this->config['version'], '3.1.0-dev', '<');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_12');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('if', array(

+ phpbb_version_compare($this->config['version'], '3.0.13-RC1', '<'),

+ array('config.update', array('version', '3.0.13-RC1')),

+ )),

+ );

+ }

+}

+use phpbb\db\migration\container_aware_migration;

+

+class release_3_0_5_rc1 extends container_aware_migration

+ $passwords_manager = $this->container->get('passwords.manager');

+ 'user_password' => '$CP$' . $passwords_manager->hash($row['user_password'], 'passwords.driver.salted_md5'),

+ WHERE auth_option = '" . $this->db->sql_escape($option) . "'

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class bot_update extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v310\rc6');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array(&$this, 'update_bing_bot'))),

+ array('custom', array(array(&$this, 'update_bots'))),

+ );

+ }

+

+ public function update_bing_bot()

+ {

+ $bot_name = 'Bing [Bot]';

+ $bot_name_clean = utf8_clean_string($bot_name);

+

+ $sql = 'SELECT user_id

+ FROM ' . USERS_TABLE . "

+ WHERE username_clean = '" . $this->db->sql_escape($bot_name_clean) . "'";

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

+ $bing_already_added = (bool) $this->db->sql_fetchfield('user_id');

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

+

+ if (!$bing_already_added)

+ {

+ $bot_agent = 'bingbot/';

+ $bot_ip = '';

+ $sql = 'SELECT group_id, group_colour

+ FROM ' . GROUPS_TABLE . "

+ WHERE group_name = 'BOTS'";

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

+ $group_row = $this->db->sql_fetchrow($result);

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

+

+ if (!$group_row)

+ {

+ // default fallback, should never get here

+ $group_row['group_id'] = 6;

+ $group_row['group_colour'] = '9E8DA7';

+ }

+

+ if (!function_exists('user_add'))

+ {

+ include($this->phpbb_root_path . 'includes/functions_user.' . $this->php_ext);

+ }

+

+ $user_row = array(

+ 'user_type' => USER_IGNORE,

+ 'group_id' => $group_row['group_id'],

+ 'username' => $bot_name,

+ 'user_regdate' => time(),

+ 'user_password' => '',

+ 'user_colour' => $group_row['group_colour'],

+ 'user_email' => '',

+ 'user_lang' => $this->config['default_lang'],

+ 'user_style' => $this->config['default_style'],

+ 'user_timezone' => 0,

+ 'user_dateformat' => $this->config['default_dateformat'],

+ 'user_allow_massemail' => 0,

+ );

+

+ $user_id = user_add($user_row);

+

+ $sql = 'INSERT INTO ' . BOTS_TABLE . ' ' . $this->db->sql_build_array('INSERT', array(

+ 'bot_active' => 1,

+ 'bot_name' => (string) $bot_name,

+ 'user_id' => (int) $user_id,

+ 'bot_agent' => (string) $bot_agent,

+ 'bot_ip' => (string) $bot_ip,

+ ));

+

+ $this->sql_query($sql);

+ }

+ }

+

+ public function update_bots()

+ {

+ // Update bots

+ if (!function_exists('user_delete'))

+ {

+ include($this->phpbb_root_path . 'includes/functions_user.' . $this->php_ext);

+ }

+

+ $bots_updates = array(

+ // Bot Deletions

+ 'NG-Search [Bot]' => false,

+ 'Nutch/CVS [Bot]' => false,

+ 'OmniExplorer [Bot]' => false,

+ 'Seekport [Bot]' => false,

+ 'Synoo [Bot]' => false,

+ 'WiseNut [Bot]' => false,

+

+ // Bot Updates

+ // Bot name to bot user agent map

+ 'Baidu [Spider]' => 'Baiduspider',

+ 'Exabot [Bot]' => 'Exabot',

+ 'Voyager [Bot]' => 'voyager/',

+ 'W3C [Validator]' => 'W3C_Validator',

+ );

+

+ foreach ($bots_updates as $bot_name => $bot_agent)

+ {

+ $sql = 'SELECT user_id

+ FROM ' . USERS_TABLE . '

+ WHERE user_type = ' . USER_IGNORE . "

+ AND username_clean = '" . $this->db->sql_escape(utf8_clean_string($bot_name)) . "'";

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

+ $bot_user_id = (int) $this->db->sql_fetchfield('user_id');

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

+

+ if ($bot_user_id)

+ {

+ if ($bot_agent === false)

+ {

+ $sql = 'DELETE FROM ' . BOTS_TABLE . "

+ WHERE user_id = $bot_user_id";

+ $this->sql_query($sql);

+

+ user_delete('retain', $bot_user_id);

+ }

+ else

+ {

+ $sql = 'UPDATE ' . BOTS_TABLE . "

+ SET bot_agent = '" . $this->db->sql_escape($bot_agent) . "'

+ WHERE user_id = $bot_user_id";

+ $this->sql_query($sql);

+ }

+ }

+ }

+ }

+}

+ if (strpos($captcha_plugin, 'phpbb_captcha_') === 0)

+ $captcha_plugin = substr($captcha_plugin, strlen('phpbb_captcha_'));

+ }

+ else if (strpos($captcha_plugin, 'phpbb_') === 0)

+ {

+ $captcha_plugin = substr($captcha_plugin, strlen('phpbb_'));

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v310\config_db_text');

+ }

+

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class gold extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\rc6',

+ '\phpbb\db\migration\data\v310\bot_update',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.1.0')),

+ );

+ }

+}

+ protected $indexes;

+

+ if (strpos($this->db->get_sql_layer(), 'mysql') === false)

+ {

+ return true;

+ }

+

+ $this->find_indexes_to_drop();

+ return empty($this->indexes);

+ if (empty($this->indexes))

+ {

+ return array();

+ }

+

+ $this->table_prefix . 'posts' => $this->indexes,

+

+ public function find_indexes_to_drop()

+ {

+ if ($this->indexes !== null)

+ {

+ return $this->indexes;

+ }

+

+ $this->indexes = array();

+ $potential_keys = array('post_subject', 'post_text', 'post_content');

+ foreach ($potential_keys as $key)

+ {

+ if ($this->db_tools->sql_index_exists($this->table_prefix . 'posts', $key))

+ {

+ $this->indexes[] = $key;

+ }

+ }

+

+ return $this->indexes;

+ }

+ $sql = 'SELECT notification_type_id

+ FROM ' . NOTIFICATION_TYPES_TABLE . "

+ WHERE notification_type_name = 'notification.type.{$notification_type}'";

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

+ $new_type_id = (int) $this->db->sql_fetchfield('notification_type_id');

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

+

+ if ($new_type_id)

+ {

+ // New type name already exists,

+ // so we delete the old type and update the type id of existing entries.

+ $sql = 'SELECT notification_type_id

+ FROM ' . NOTIFICATION_TYPES_TABLE . "

+ WHERE notification_type_name = '{$notification_type}'";

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

+ $old_type_id = (int) $this->db->sql_fetchfield('notification_type_id');

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

+

+ $sql = 'UPDATE ' . NOTIFICATIONS_TABLE . '

+ SET notification_type_id = ' . (int) $new_type_id . '

+ WHERE notification_type_id = ' . (int) $old_type_id;

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

+

+ $sql = 'DELETE FROM ' . NOTIFICATION_TYPES_TABLE . "

+ WHERE notification_type_name = '{$notification_type}'";

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

+ }

+ else

+ {

+ // Otherwise we just update the name

+ $sql = 'UPDATE ' . NOTIFICATION_TYPES_TABLE . "

+ SET notification_type_name = 'notification.type.{$notification_type}'

+ WHERE notification_type_name = '{$notification_type}'";

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

+ }

+ $sql = 'SELECT notification_type_id

+ FROM ' . NOTIFICATION_TYPES_TABLE . "

+ WHERE notification_type_name = '{$notification_type}'";

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

+ $new_type_id = (int) $this->db->sql_fetchfield('notification_type_id');

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

+

+ if ($new_type_id)

+ {

+ // New type name already exists,

+ // so we delete the old type and update the type id of existing entries.

+ $sql = 'SELECT notification_type_id

+ FROM ' . NOTIFICATION_TYPES_TABLE . "

+ WHERE notification_type_name = 'notification.type.{$notification_type}'";

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

+ $old_type_id = (int) $this->db->sql_fetchfield('notification_type_id');

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

+

+ $sql = 'UPDATE ' . NOTIFICATIONS_TABLE . '

+ SET notification_type_id = ' . (int) $new_type_id . '

+ WHERE notification_type_id = ' . (int) $old_type_id;

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

+

+ $sql = 'DELETE FROM ' . NOTIFICATION_TYPES_TABLE . "

+ WHERE notification_type_name = 'notification.type.{$notification_type}'";

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

+ }

+ else

+ {

+ // Otherwise we just update the name

+ $sql = 'UPDATE ' . NOTIFICATION_TYPES_TABLE . "

+ SET notification_type_name = '{$notification_type}'

+ WHERE notification_type_name = 'notification.type.{$notification_type}'";

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

+ }

+ protected $indexes;

+

+ if (strpos($this->db->get_sql_layer(), 'postgres') === false)

+ {

+ return true;

+ }

+

+ $this->find_indexes_to_drop();

+ return empty($this->indexes);

+ if (empty($this->indexes))

+ {

+ return array();

+ }

+

+ $this->table_prefix . 'posts' => $this->indexes,

+

+ public function find_indexes_to_drop()

+ {

+ if ($this->indexes !== null)

+ {

+ return $this->indexes;

+ }

+

+ $this->indexes = array();

+ $potential_keys = array('post_subject', 'post_text', 'post_content');

+ foreach ($potential_keys as $key)

+ {

+ if ($this->db_tools->sql_index_exists($this->table_prefix . 'posts', $key))

+ {

+ $this->indexes[] = $key;

+ }

+ }

+

+ return $this->indexes;

+ }

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class rc5 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\rc4',

+ '\phpbb\db\migration\data\v310\profilefield_field_validation_length',

+ '\phpbb\db\migration\data\v310\remove_acp_styles_cache',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.1.0-RC5')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class rc6 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\rc5',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.1.0-RC6')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class remove_acp_styles_cache extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ $sql = 'SELECT module_id

+ FROM ' . MODULES_TABLE . "

+ WHERE module_class = 'acp'

+ AND module_langname = 'ACP_STYLES_CACHE'";

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

+ $module_id = $this->db->sql_fetchfield('module_id');

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

+

+ return !$module_id;

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v310\rc4');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('module.remove', array(

+ 'acp',

+ 'ACP_STYLE_MANAGEMENT',

+ array(

+ 'module_basename' => 'acp_styles',

+ 'module_langname' => 'ACP_STYLES_CACHE',

+ 'module_mode' => 'cache',

+ 'module_auth' => 'acl_a_styles',

+ ),

+ )),

+ );

+ }

+}

+ (is_dir($this->phpbb_root_path . 'includes/captcha/plugins/') &&

+ !is_file($this->phpbb_root_path . "includes/captcha/plugins/{$this->config['captcha_plugin']}_plugin." . $this->php_ext)),

+use phpbb\db\migration\container_aware_migration;

+

+class soft_delete_mod_convert extends container_aware_migration

+ /**

+ * @return \phpbb\content_visibility

+ */

+ return $this->container->get('content.visibility');

+ FROM ' . STYLES_TABLE . ' s, ' . $this->table_prefix . 'styles_template t, ' . $this->table_prefix . "styles_theme c

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v31x;

+

+class m_softdelete_global extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v31x\v311');

+ }

+

+ public function update_data()

+ {

+ return array(

+ // Make m_softdelete global. The add method will take care of updating

+ // it if it already exists.

+ array('permission.add', array('m_softdelete', true)),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v31x;

+

+class plupload_last_gc_dynamic extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v31x\v312');

+ }

+

+ public function update_data()

+ {

+ return array(

+ // Make plupload_last_gc dynamic.

+ array('config.remove', array('plupload_last_gc')),

+ array('config.add', array('plupload_last_gc', 0, 1)),

+ );

+ }

+}

+<?php

+

+/**

+ *

+ * This file is part of the phpBB Forum Software package.

+ *

+ * @copyright (c) phpBB Limited <https://www.phpbb.com>

+ * @license GNU General Public License, version 2 (GPL-2.0)

+ *

+ * For full copyright and license information, please see

+ * the docs/CREDITS.txt file.

+ *

+ */

+

+namespace phpbb\db\migration\data\v31x;

+

+class profilefield_remove_underscore_from_alpha extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v31x\v311');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array($this, 'remove_underscore_from_alpha_validations'))),

+ );

+ }

+

+ public function remove_underscore_from_alpha_validations()

+ {

+ $this->update_validation_rule('[\w]+', '[a-zA-Z0-9]+');

+ $this->update_validation_rule('[\w_]+', '[\w]+');

+ $this->update_validation_rule('[\w.]+', '[a-zA-Z0-9.]+');

+ $this->update_validation_rule('[\w\x20_+\-\[\]]+', '[\w\x20+\-\[\]]+');

+ $this->update_validation_rule('[a-zA-Z][\w\.,\-_]+', '[a-zA-Z][\w\.,\-]+');

+ }

+

+ public function update_validation_rule($old_validation, $new_validation)

+ {

+ $sql = 'UPDATE ' . PROFILE_FIELDS_TABLE . "

+ SET field_validation = '" . $this->db->sql_escape($new_validation) . "'

+ WHERE field_validation = '" . $this->db->sql_escape($old_validation) . "'";

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

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v31x;

+

+class profilefield_yahoo_update_url extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v31x\v312');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array($this, 'update_contact_url'))),

+ );

+ }

+

+ public function update_contact_url()

+ {

+ $sql = 'UPDATE ' . $this->table_prefix . "profile_fields

+ SET field_contact_url = 'ymsgr:sendim?%s'

+ WHERE field_name = 'phpbb_yahoo'

+ AND field_contact_url = 'http://edit.yahoo.com/config/send_webmesg?.target=%s&amp;.src=pg'";

+ $this->sql_query($sql);

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v31x;

+

+class style_update extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v310\gold');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array($this, 'update_installed_styles'))),

+ );

+ }

+

+ public function update_installed_styles()

+ {

+ // Get all currently available styles

+ $styles = $this->find_style_dirs();

+ $style_paths = $style_ids = array();

+

+ $sql = 'SELECT style_path, style_id

+ FROM ' . $this->table_prefix . 'styles';

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

+ while ($styles_row = $this->db->sql_fetchrow())

+ {

+ if (in_array($styles_row['style_path'], $styles))

+ {

+ $style_paths[] = $styles_row['style_path'];

+ $style_ids[] = $styles_row['style_id'];

+ }

+ }

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

+

+ // Install prosilver if no style is available and prosilver can be installed

+ if (empty($style_paths) && in_array('prosilver', $styles))

+ {

+ // Try to parse config file

+ $cfg = parse_cfg_file($this->phpbb_root_path . 'styles/prosilver/style.cfg');

+

+ // Stop running this if prosilver cfg file can't be read

+ if (empty($cfg))

+ {

+ throw new \RuntimeException('No styles available and could not fall back to prosilver.');

+ }

+

+ $style = array(

+ 'style_name' => 'prosilver',

+ 'style_copyright' => '&copy; phpBB Limited',

+ 'style_active' => 1,

+ 'style_path' => 'prosilver',

+ 'bbcode_bitfield' => 'kNg=',

+ 'style_parent_id' => 0,

+ 'style_parent_tree' => '',

+ );

+

+ // Add to database

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

+

+ $sql = 'INSERT INTO ' . $this->table_prefix . 'styles

+ ' . $this->db->sql_build_array('INSERT', $style);

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

+

+ $style_id = $this->db->sql_nextid();

+ $style_ids[] = $style_id;

+

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

+

+ // Set prosilver to default style

+ $this->config->set('default_style', $style_id);

+ }

+ else if (empty($styles) && empty($available_styles))

+ {

+ throw new \RuntimeException('No valid styles available');

+ }

+

+ // Make sure default style is available

+ if (!in_array($this->config['default_style'], $style_ids))

+ {

+ $this->config->set('default_style', array_pop($style_ids));

+ }

+

+ // Reset users to default style if their user_style is nonexistent

+ $sql = 'UPDATE ' . $this->table_prefix . "users

+ SET user_style = {$this->config['default_style']}

+ WHERE " . $this->db->sql_in_set('user_style', $style_ids, true, true);

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

+ }

+

+ /**

+ * Find all directories that have styles

+ * Copied from acp_styles

+ *

+ * @return array Directory names

+ */

+ protected function find_style_dirs()

+ {

+ $styles = array();

+ $styles_path = $this->phpbb_root_path . 'styles/';

+

+ $dp = @opendir($styles_path);

+ if ($dp)

+ {

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

+ {

+ $dir = $styles_path . $file;

+ if ($file[0] == '.' || !is_dir($dir))

+ {

+ continue;

+ }

+

+ if (file_exists("{$dir}/style.cfg"))

+ {

+ $styles[] = $file;

+ }

+ }

+ closedir($dp);

+ }

+

+ return $styles;

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v31x;

+

+class update_custom_bbcodes_with_idn extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v31x\v312',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array($this, 'update_bbcodes_table'))),

+ );

+ }

+

+ public function update_bbcodes_table()

+ {

+ if (!class_exists('acp_bbcodes'))

+ {

+ include($this->phpbb_root_path . 'includes/acp/acp_bbcodes.' . $this->php_ext);

+ }

+

+ $bbcodes = new \acp_bbcodes();

+

+ $sql = 'SELECT bbcode_id, bbcode_match, bbcode_tpl

+ FROM ' . BBCODES_TABLE;

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

+

+ $sql_ary = array();

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

+ {

+ $data = array();

+ if (preg_match('/(URL|LOCAL_URL|RELATIVE_URL)/', $row['bbcode_match']))

+ {

+ $data = $bbcodes->build_regexp($row['bbcode_match'], $row['bbcode_tpl']);

+ $sql_ary[$row['bbcode_id']] = array(

+ 'first_pass_match' => $data['first_pass_match'],

+ 'first_pass_replace' => $data['first_pass_replace'],

+ 'second_pass_match' => $data['second_pass_match'],

+ 'second_pass_replace' => $data['second_pass_replace']

+ );

+ }

+ }

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

+

+ foreach ($sql_ary as $bbcode_id => $bbcode_data)

+ {

+ $sql = 'UPDATE ' . BBCODES_TABLE . '

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

+ WHERE bbcode_id = ' . (int) $bbcode_id;

+ $this->sql_query($sql);

+ }

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v31x;

+

+class v311 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\gold',

+ '\phpbb\db\migration\data\v31x\style_update',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.1.1')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v31x;

+

+class v312 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v31x\v312rc1',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.1.2')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v31x;

+

+class v312rc1 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v31x\v311',

+ '\phpbb\db\migration\data\v31x\m_softdelete_global',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.1.2-RC1')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v31x;

+

+class v313 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v31x\v313rc2',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.1.3')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v31x;

+

+class v313rc1 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v30x\release_3_0_13_rc1',

+ '\phpbb\db\migration\data\v31x\plupload_last_gc_dynamic',

+ '\phpbb\db\migration\data\v31x\profilefield_remove_underscore_from_alpha',

+ '\phpbb\db\migration\data\v31x\profilefield_yahoo_update_url',

+ '\phpbb\db\migration\data\v31x\update_custom_bbcodes_with_idn',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.1.3-RC1')),

+ );

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v31x;

+

+class v313rc2 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v30x\release_3_0_13_pl1',

+ '\phpbb\db\migration\data\v31x\v313rc1',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.1.3-RC2')),

+ );

+ }

+}

+abstract class profilefield_base_migration extends container_aware_migration

+ $manager = $this->container->get('profilefields.manager');

+ $this->user->add_lang('acp/modules');

+ WHERE ' . $this->db->sql_in_set('auth_option_id', $to_remove) . '

+ AND role_id = ' . (int) $role_id;

+use Symfony\Component\DependencyInjection\ContainerAwareInterface;

+use Symfony\Component\DependencyInjection\ContainerInterface;

+

+ /**

+ * @var ContainerInterface

+ */

+ protected $container;

+

+ * Array of migrations that have been determined to be fulfillable

+ *

+ * @var array

+ */

+ protected $fulfillable_migrations = array();

+

+ /**

+ * The output handler. A null handler is configured by default.

+ *

+ * @var migrator_output_handler_interface

+ */

+ public $output_handler;

+

+ /**

+ public function __construct(ContainerInterface $container, \phpbb\config\config $config, \phpbb\db\driver\driver_interface $db, \phpbb\db\tools $db_tools, $migrations_table, $phpbb_root_path, $php_ext, $table_prefix, $tools, \phpbb\db\migration\helper $helper)

+ $this->container = $container;

+ $this->output_handler = new null_migrator_output_handler();

+

+ * Set the output handler.

+ *

+ * @param migrator_output_handler $handler The output handler

+ */

+ public function set_output_handler(migrator_output_handler_interface $handler)

+ {

+ $this->output_handler = $handler;

+ }

+

+ /**

+ $this->container->get('dispatcher')->disable();

+ $this->update_do();

+ $this->container->get('dispatcher')->enable();

+ }

+

+ /**

+ * Effectively runs a single update step from the next migration to be applied.

+ *

+ * @return null

+ */

+ protected function update_do()

+ {

+ else

+ {

+ $this->output_handler->write(array('MIGRATION_EFFECTIVELY_INSTALLED', $name), migrator_output_handler_interface::VERBOSITY_DEBUG);

+ }

+ $this->output_handler->write(array('MIGRATION_NOT_VALID', $name), migrator_output_handler_interface::VERBOSITY_DEBUG);

+ if (!empty($state['migration_depends_on']))

+ {

+ $this->output_handler->write(array('MIGRATION_APPLY_DEPENDENCIES', $name), migrator_output_handler_interface::VERBOSITY_DEBUG);

+ }

+

+

+ $this->output_handler->write(array('MIGRATION_EFFECTIVELY_INSTALLED', $name), migrator_output_handler_interface::VERBOSITY_VERBOSE);

+ $this->output_handler->write(array('MIGRATION_SCHEMA_RUNNING', $name), migrator_output_handler_interface::VERBOSITY_VERBOSE);

+

+ $elapsed_time = microtime(true);

+ $elapsed_time = microtime(true) - $elapsed_time;

+

+ $this->output_handler->write(array('MIGRATION_SCHEMA_DONE', $name, $elapsed_time), migrator_output_handler_interface::VERBOSITY_NORMAL);

+ $this->output_handler->write(array('MIGRATION_DATA_RUNNING', $name), migrator_output_handler_interface::VERBOSITY_VERBOSE);

+

+

+ $elapsed_time = microtime(true);

+ $elapsed_time = microtime(true) - $elapsed_time;

+

+ if ($state['migration_schema_done'])

+ {

+ $this->output_handler->write(array('MIGRATION_DATA_DONE', $name, $elapsed_time), migrator_output_handler_interface::VERBOSITY_NORMAL);

+ }

+ else

+ {

+ $this->output_handler->write(array('MIGRATION_DATA_IN_PROGRESS', $name, $elapsed_time), migrator_output_handler_interface::VERBOSITY_VERY_VERBOSE);

+ }

+ $this->revert_do($name);

+ $this->container->get('dispatcher')->disable();

+ $this->revert_do($migration);

+ $this->container->get('dispatcher')->enable();

+ }

+

+ /**

+ * Effectively runs a single revert step from the last migration installed

+ *

+ * @param string $migration String migration name to revert (including any that depend on this migration)

+ * @return null

+ */

+ protected function revert_do($migration)

+ {

+ $this->revert_do($name);

+ if (isset($this->migration_state[$name]) || isset($this->fulfillable_migrations[$name]))

+ $this->fulfillable_migrations[$name] = true;

+ $migration = new $name($this->config, $this->db, $this->db_tools, $this->phpbb_root_path, $this->php_ext, $this->table_prefix);

+

+ if ($migration instanceof ContainerAwareInterface)

+ {

+ $migration->setContainer($this->container);

+ }

+

+ return $migration;

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db;

+

+interface migrator_output_handler_interface

+{

+ const VERBOSITY_QUIET = 0;

+ const VERBOSITY_NORMAL = 1;

+ const VERBOSITY_VERBOSE = 2;

+ const VERBOSITY_VERY_VERBOSE = 3;

+ const VERBOSITY_DEBUG = 4;

+

+ /**

+ * Write output using the configured closure.

+ *

+ * @param string|array $message The message to write or an array containing the language key and all of its parameters.

+ * @param int $verbosity The verbosity of the message.

+ */

+ public function write($message, $verbosity);

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db;

+

+class null_migrator_output_handler implements migrator_output_handler_interface

+{

+ /**

+ * {@inheritdoc}

+ */

+ public function write($message, $verbosity)

+ {

+ }

+}

+ if (!is_null($column_data[1]) || (isset($column_data[2]) && $column_data[2] == 'auto_increment'))

+ // Integers need to have 0 instead of empty string as default

+ if (strpos($column_type, 'INT') === 0)

+ {

+ $default_val = '0';

+ }

+ else

+ {

+ $default_val = "'" . $column_data[1] . "'";

+ }

+ $statements[] = 'ALTER TABLE ' . $table_name . ' ADD INDEX ' . $index_name . ' (' . implode(', ', $column) . ')';

+ AND INDEXPROPERTY(ix.id, ix.name, 'IsUnique') = " . ($unique ? '1' : '0');

+ AND ix.is_unique = " . ($unique ? '1' : '0');

+ $parameters = array(

+ 'core.adm_relative_path' => $this->config_php->get('phpbb_adm_relative_path') ? $this->config_php->get('phpbb_adm_relative_path') : 'adm/',

+ 'core.table_prefix' => $this->config_php->get('table_prefix'),

+ 'cache.driver.class' => $this->convert_30_acm_type($this->config_php->get('acm_type')),

+ 'dbal.driver.class' => $this->config_php->convert_30_dbms_to_31($this->config_php->get('dbms')),

+ 'dbal.dbhost' => $this->config_php->get('dbhost'),

+ 'dbal.dbuser' => $this->config_php->get('dbuser'),

+ 'dbal.dbpasswd' => $this->config_php->get('dbpasswd'),

+ 'dbal.dbname' => $this->config_php->get('dbname'),

+ 'dbal.dbport' => $this->config_php->get('dbport'),

+ 'dbal.new_link' => defined('PHPBB_DB_NEW_LINK') && PHPBB_DB_NEW_LINK,

+ );

+ $parameter_bag = $container->getParameterBag();

+

+ foreach ($parameters as $parameter => $value)

+ {

+ $container->setParameter($parameter, $parameter_bag->escapeValue($value));

+ }

+ var $error_types;

+ /**

+ * Constructor.

+ *

+ * The variable $error_types may be set to a mask of PHP error types that

+ * the collector should keep, e.g. `E_ALL`. If unset, the current value of

+ * the error_reporting() function will be used to determine which errors

+ * the collector will keep.

+ *

+ * @see PHPBB3-13306

+ * @param int|null $error_types

+ */

+ function __construct($error_types = null)

+ $this->error_types = $error_types;

+ set_error_handler(array(&$this, 'error_handler'), ($this->error_types !== null) ? $this->error_types : error_reporting());

+use Symfony\Component\EventDispatcher\Event;

+ * @var bool

+ */

+ protected $disabled = false;

+

+ /**

+

+ /**

+ * {@inheritdoc}

+ */

+ public function dispatch($eventName, Event $event = null)

+ {

+ if ($this->disabled)

+ {

+ return $event;

+ }

+

+ return parent::dispatch($eventName, $event);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function disable()

+ {

+ $this->disabled = true;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function enable()

+ {

+ $this->disabled = false;

+ }

+

+ /**

+ * Disable the event dispatcher.

+ */

+ public function disable();

+

+ /**

+ * Enable the event dispatcher.

+ */

+ public function enable();

+use Symfony\Component\HttpFoundation\JsonResponse;

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

+ $message = $exception->getMessage();

+

+ if ($exception instanceof \phpbb\exception\exception_interface)

+ {

+ $message = call_user_func_array(array($this->user, 'lang'), array_merge(array($message), $exception->get_parameters()));

+ }

+

+ if (!$event->getRequest()->isXmlHttpRequest())

+ {

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

+

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

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

+ 'MESSAGE_TEXT' => $message,

+ ));

+

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

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

+ ));

+

+ page_footer(true, false, false);

+

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

+ }

+ else

+ {

+ $data = array();

+

+ if (!empty($message))

+ {

+ $data['message'] = $message;

+ }

+

+ if (defined('DEBUG'))

+ {

+ $data['trace'] = $exception->getTrace();

+ }

+ $response = new JsonResponse($data, 500);

+ }

+ if ($exception instanceof HttpExceptionInterface)

+ {

+ $response->setStatusCode($exception->getStatusCode());

+ $response->headers->add($exception->getHeaders());

+ }

+ KernelEvents::TERMINATE => array('on_kernel_terminate', ~PHP_INT_MAX),

+ $event_text_line = ltrim($event_text_line, "\t ");

+ if (ltrim($this->file_lines[$this->current_event_line - $current_doc_line], "\t ") === '*/')

+ while (strpos(ltrim($this->file_lines[$this->current_event_line - $find_tag_line], "\t "), '* @' . $find_tag . ' ') !== 0)

+ if ($found_comment_end && strpos(ltrim($this->file_lines[$this->current_event_line - $find_tag_line], "\t "), '* @' . $disallowed_tag) === 0)

+ if (ltrim($this->file_lines[$this->current_event_line - $find_tag_line], "\t ") === '*/')

+ preg_match('#^\* @since (\d+\.\d+\.\d+(?:-(?:a|b|RC|pl)\d+)?)$#', ltrim($line, "\t "), $match);

+ $event = substr(ltrim($line, "\t "), strlen('* @event '));

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\exception;

+

+/**

+ * Interface exception_interface

+ *

+ * Define an exception which support a language var as message.

+ */

+interface exception_interface

+{

+ /**

+ * Return the arguments associated with the message if it's a language var.

+ *

+ * @return array

+ */

+ public function get_parameters();

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\exception;

+

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

+

+/**

+ * Class http_exception

+ */

+class http_exception extends runtime_exception implements HttpExceptionInterface

+{

+ /**

+ * Http status code.

+ *

+ * @var integer

+ */

+ private $status_code;

+

+ /**

+ * Additional headers to set in the response.

+ *

+ * @var array

+ */

+ private $headers;

+

+ /**

+ * Constructor

+ *

+ * @param integer $status_code The http status code.

+ * @param string $message The Exception message to throw (must be a language variable).

+ * @param array $parameters The parameters to use with the language var.

+ * @param \Exception $previous The previous exception used for the exception chaining.

+ * @param array $headers Additional headers to set in the response.

+ * @param integer $code The Exception code.

+ */

+ public function __construct($status_code, $message = "", array $parameters = array(), \Exception $previous = null, array $headers = array(), $code = 0)

+ {

+ $this->status_code = $status_code;

+ $this->headers = $headers;

+

+ parent::__construct($message, $parameters, $previous, $code);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function getStatusCode()

+ {

+ return $this->status_code;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function getHeaders()

+ {

+ return $this->headers;

+ }

+}

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\exception;

+

+/**

+ * Class runtime_exception

+ *

+ * Define an exception which support a language var as message.

+ */

+class runtime_exception extends \RuntimeException implements exception_interface

+{

+ /**

+ * Parameters to use with the language var.

+ *

+ * @var array

+ */

+ private $parameters;

+

+ /**

+ * Constructor

+ *

+ * @param string $message The Exception message to throw (must be a language variable).

+ * @param array $parameters The parameters to use with the language var.

+ * @param \Exception $previous The previous runtime_exception used for the runtime_exception chaining.

+ * @param integer $code The Exception code.

+ */

+ public function __construct($message = "", array $parameters = array(), \Exception $previous = null, $code = 0)

+ {

+ $this->parameters = $parameters;

+

+ parent::__construct($message, $code, $previous);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_parameters()

+ {

+ return $this->parameters;

+ }

+}

+ array_walk_recursive($metadata, array($this, 'sanitize_json'));

+ * Sanitize input from JSON array using htmlspecialchars()

+ *

+ * @param mixed $value Value of array row

+ * @param string $key Key of array row

+ */

+ public function sanitize_json(&$value, $key)

+ {

+ $value = htmlspecialchars($value);

+ }

+

+ /**

+ 'META_NAME' => $this->metadata['name'],

+ 'META_TYPE' => $this->metadata['type'],

+ 'META_DESCRIPTION' => (isset($this->metadata['description'])) ? $this->metadata['description'] : '',

+ 'META_VERSION' => (isset($this->metadata['version'])) ? $this->metadata['version'] : '',

+ 'META_TIME' => (isset($this->metadata['time'])) ? $this->metadata['time'] : '',

+ 'META_LICENSE' => $this->metadata['license'],

+ 'META_REQUIRE_PHP' => (isset($this->metadata['require']['php'])) ? $this->metadata['require']['php'] : '',

+ 'META_REQUIRE_PHPBB' => (isset($this->metadata['extra']['soft-require']['phpbb/phpbb'])) ? $this->metadata['extra']['soft-require']['phpbb/phpbb'] : '',

+ 'META_DISPLAY_NAME' => (isset($this->metadata['extra']['display-name'])) ? $this->metadata['extra']['display-name'] : '',

+ 'AUTHOR_NAME' => $author['name'],

+ 'AUTHOR_ROLE' => (isset($author['role'])) ? $author['role'] : '',

+ /** @var mixed Query result handle */

+ protected $result;

+

+ if (!isset($this->result))

+ $this->result = $this->db->sql_query_limit($sql, $this->num_items);

+ return $this->db->sql_fetchrow($this->result);

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb;

+

+class file_downloader

+{

+ /** @var string Error string */

+ protected $error_string = '';

+

+ /** @var int Error number */

+ protected $error_number = 0;

+

+ /**

+ * Retrieve contents from remotely stored file

+ *

+ * @param string $host File host

+ * @param string $directory Directory file is in

+ * @param string $filename Filename of file to retrieve

+ * @param int $port Port to connect to; default: 80

+ * @param int $timeout Connection timeout in seconds; default: 6

+ *

+ * @return mixed File data as string if file can be read and there is no

+ * timeout, false if there were errors or the connection timed out

+ *

+ * @throws \phpbb\exception\runtime_exception If data can't be retrieved and no error

+ * message is returned

+ */

+ public function get($host, $directory, $filename, $port = 80, $timeout = 6)

+ {

+ // Set default values for error variables

+ $this->error_number = 0;

+ $this->error_string = '';

+

+ if ($socket = @fsockopen($host, $port, $this->error_number, $this->error_string, $timeout))

+ {

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

+ @fputs($socket, "HOST: $host\r\n");

+ @fputs($socket, "Connection: close\r\n\r\n");

+

+ $timer_stop = time() + $timeout;

+ stream_set_timeout($socket, $timeout);

+

+ $file_info = '';

+ $get_info = false;

+

+ while (!@feof($socket))

+ {

+ if ($get_info)

+ {

+ $file_info .= @fread($socket, 1024);

+ }

+ else

+ {

+ $line = @fgets($socket, 1024);

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

+ {

+ $get_info = true;

+ }

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

+ {

+ throw new \phpbb\exception\runtime_exception('FILE_NOT_FOUND', array($filename));

+ }

+ }

+

+ $stream_meta_data = stream_get_meta_data($socket);

+

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

+ {

+ throw new \phpbb\exception\runtime_exception('FSOCK_TIMEOUT');

+ }

+ }

+ @fclose($socket);

+ }

+ else

+ {

+ if ($this->error_string)

+ {

+ $this->error_string = utf8_convert_message($this->error_string);

+ return false;

+ }

+ else

+ {

+ throw new \phpbb\exception\runtime_exception('FSOCK_DISABLED');

+ }

+ }

+

+ return $file_info;

+ }

+

+ /**

+ * Get error string

+ *

+ * @return string Error string

+ */

+ public function get_error_string()

+ {

+ return $this->error_string;

+ }

+

+ /**

+ * Get error number

+ *

+ * @return int Error number

+ */

+ public function get_error_number()

+ {

+ return $this->error_number;

+ }

+}

+ /**

+ * Allow modifying or execute extra final filter on log entries

+ *

+ * @event core.get_logs_after

+ * @var array log Array with all our log entries

+ * @var array topic_id_list Array of topic ids, for which we

+ * get the permission data

+ * @var array reportee_id_list Array of additional user IDs we

+ * get the username strings for

+ * @var string mode Mode of the entries we display

+ * @var bool count_logs Do we count all matching entries?

+ * @var int limit Limit the number of entries

+ * @var int offset Offset when fetching the entries

+ * @var mixed forum_id Limit entries to the forum_id,

+ * can also be an array of forum_ids

+ * @var int topic_id Limit entries to the topic_id

+ * @var int user_id Limit entries to the user_id

+ * @var int log_time Limit maximum age of log entries

+ * @var string sort_by SQL order option

+ * @var string keywords Will only return entries that have the

+ * keywords in log_operation or log_data

+ * @var string profile_url URL to the users profile

+ * @var int log_type The type of logs it was filtered

+ * @since 3.1.3-RC1

+ */

+ $vars = array(

+ 'log',

+ 'topic_id_list',

+ 'reportee_id_list',

+ 'mode',

+ 'count_logs',

+ 'limit',

+ 'offset',

+ 'forum_id',

+ 'topic_id',

+ 'user_id',

+ 'log_time',

+ 'sort_by',

+ 'keywords',

+ 'profile_url',

+ 'log_type',

+ );

+ extract($this->dispatcher->trigger_event('core.get_logs_after', compact($vars)));

+

+ 'S_POST_ACTION' => append_sid($this->phpbb_root_path . 'memberlist.' . $this->phpEx, 'mode=contactadmin'),

+ if ($this->cc_sender && $this->user->data['is_registered'])

+ $this->message->set_body($this->body);

+ protected $subscription_types;

+

+ /** @var array */

+ /** @var \phpbb\event\dispatcher_interface */

+ protected $phpbb_dispatcher;

+

+ * @param \phpbb\event\dispatcher_interface $phpbb_dispatcher

+ public function __construct($notification_types, $notification_methods, ContainerInterface $phpbb_container, \phpbb\user_loader $user_loader, \phpbb\config\config $config, \phpbb\event\dispatcher_interface $phpbb_dispatcher, \phpbb\db\driver\driver_interface $db, \phpbb\cache\service $cache, $user, $phpbb_root_path, $php_ext, $notification_types_table, $notifications_table, $user_notifications_table)

+ $this->phpbb_dispatcher = $phpbb_dispatcher;

+ (($item_parent_id !== false) ? ' AND ' . (is_array($item_parent_id) ? $this->db->sql_in_set('item_parent_id', $item_parent_id, false, true) : 'item_parent_id = ' . (int) $item_parent_id) : '') .

+ /**

+ * Allow filtering the notify_users array for a notification that is about to be sent.

+ * Here, $notify_users is already filtered by f_read and the ignored list included in the options variable

+ *

+ * @event core.notification_manager_add_notifications

+ * @var string notification_type_name The forum id from where the topic belongs

+ * @var array data Data specific for the notification_type_name used will be inserted

+ * @var array notify_users The array of userid that are going to be notified for this notification. Set to array() to cancel.

+ * @var array options The options that were used when this method was called (read only)

+ *

+ * @since 3.1.3-RC1

+ */

+ $vars = array(

+ 'notification_type_name',

+ 'data',

+ 'notify_users',

+ 'options',

+ );

+ extract($this->phpbb_dispatcher->trigger_event('core.notification_manager_add_notifications', compact($vars)));

+

+ if ($this->subscription_types === null)

+ $this->subscription_types = array();

+ foreach ($this->notification_types as $type_name => $data)

+ $type = $this->get_item_type_class($type_name);

+ if ($type instanceof \phpbb\notification\type\type_interface && $type->is_available())

+ {

+ $options = array_merge(array(

+ 'id' => $type->get_type(),

+ 'lang' => 'NOTIFICATION_TYPE_' . strtoupper($type->get_type()),

+ 'group' => 'NOTIFICATION_GROUP_MISCELLANEOUS',

+ ), (($type::$notification_option !== false) ? $type::$notification_option : array()));

+

+ $this->subscription_types[$options['group']][$options['id']] = $options;

+ }

+ // Move Miscellaneous to the very last section

+ if (isset($this->subscription_types['NOTIFICATION_GROUP_MISCELLANEOUS']))

+ {

+ $miscellaneous = $this->subscription_types['NOTIFICATION_GROUP_MISCELLANEOUS'];

+ unset($this->subscription_types['NOTIFICATION_GROUP_MISCELLANEOUS']);

+ $this->subscription_types['NOTIFICATION_GROUP_MISCELLANEOUS'] = $miscellaneous;

+ }

+ return $this->subscription_types;

+ $username = $this->user_loader->get_username($this->item_id, 'username');

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

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

+ /** @var \phpbb\controller\helper */

+ protected $helper;

+

+ /** @var \phpbb\event\dispatcher_interface */

+ protected $phpbb_dispatcher;

+

+ * @param \phpbb\template\template $template

+ * @param \phpbb\user $user

+ * @param \phpbb\controller\helper $helper

+ * @param \phpbb\event\dispatcher_interface $phpbb_dispatcher

+ public function __construct(\phpbb\template\template $template, \phpbb\user $user, \phpbb\controller\helper $helper, \phpbb\event\dispatcher_interface $phpbb_dispatcher)

+ $this->phpbb_dispatcher = $phpbb_dispatcher;

+ // A listener can set this variable to the new pagination URL

+ // to override the generate_page_link() function generated value

+ $generate_page_link_override = false;

+

+ /**

+ * Execute code and/or override generate_page_link()

+ *

+ * To override the generate_page_link() function generated value

+ * set $generate_page_link_override to the new URL value

+ *

+ * @event core.pagination_generate_page_link

+ * @var string base_url is url prepended to all links generated within the function

+ * If you use page numbers inside your controller route, base_url should contains a placeholder (%d)

+ * for the page. Also be sure to specify the pagination path information into the start_name argument

+ * @var string on_page is the page for which we want to generate the link

+ * @var string start_name is the name of the parameter containing the first item of the given page (example: start=20)

+ * If you use page numbers inside your controller route, start name should be the string

+ * that should be removed for the first page (example: /page/%d)

+ * @var int per_page the number of items, posts, etc. to display per page, used to determine the number of pages to produce

+ * @var bool|string generate_page_link_override Shall we return custom pagination link (string URL) or not (false)

+ * @since 3.1.0-RC5

+ */

+ $vars = array('base_url', 'on_page', 'start_name', 'per_page', 'generate_page_link_override');

+ extract($this->phpbb_dispatcher->trigger_event('core.pagination_generate_page_link', compact($vars)));

+

+ if ($generate_page_link_override)

+ {

+ return $generate_page_link_override;

+ }

+

+ if ($this->helper->string_compare($hash, $this->hash($password, $salt)))

+ return $this->helper->string_compare($hash, $this->bcrypt->hash($this->bcrypt->hash($password, $salt), $salt));

+

+ /**

+ * Compare two strings byte by byte

+ *

+ * @param string $string_a The first string

+ * @param string $string_b The second string

+ *

+ * @return bool True if strings are the same, false if not

+ */

+ public function string_compare($string_a, $string_b)

+ {

+ $difference = strlen($string_a) != strlen($string_b);

+

+ for ($i = 0; $i < strlen($string_a) && $i < strlen($string_b); $i++)

+ {

+ $difference |= $string_a[$i] != $string_b[$i];

+ }

+

+ return $difference === 0;

+ }

+ return $this->helper->string_compare($hash, md5(md5($user_row['user_passwd_salt']) . md5($password)));

+ /** @var \phpbb\passwords\driver\helper */

+ protected $helper;

+

+ * @param \phpbb\passwords\driver\helper $helper Driver helper

+ public function __construct($request, salted_md5 $salted_md5, helper $helper, $phpbb_root_path, $php_ext)

+ $this->helper = $helper;

+ if ($this->helper->string_compare(md5($password_old_format), $hash) || $this->helper->string_compare(md5(\utf8_to_cp1252($password_old_format)), $hash)

+ return $this->helper->string_compare($hash, md5(md5($password) . $user_row['user_passwd_salt']));

+ return $this->helper->string_compare($hash, $this->hash($password, $hash));

+ return (strlen($hash) == 40) ? $this->helper->string_compare($hash, sha1($password)) : false;

+ return (strlen($hash) == 40) ? $this->helper->string_compare($hash, $this->hash($password, $user_row)) : false;

+ return $this->helper->string_compare($hash, sha1($user_row['user_passwd_salt'] . sha1($user_row['user_passwd_salt'] . sha1($password))));

+ if ($this->helper->string_compare($hash, sha1(sha1($password) . $user_row['user_passwd_salt']))

+ || $this->helper->string_compare($hash, hash('sha256', hash('sha256', $password) . $user_row['user_passwd_salt'])))

+ // We do not need to escape $path_info, $request_uri and $script_name because we can not find their content in the result.

+ // We need to escape $absolute_board_url because it can be partially concatenated to the result.

+ $absolute_board_url = $this->request->escape($this->symfony_request->getSchemeAndHttpHost() . $this->symfony_request->getBasePath(), true);

+

+ $absolute_board_url

+ while (($dir_position = strpos($absolute_board_url, $referer_dir)) !== 0)

+

+ // Just return phpbb_root_path if we reach the top directory

+ if ($referer_dir === '.')

+ {

+ return $this->phpbb_root_path;

+ }

+

+ /**

+ * Get a valid page

+ *

+ * @param string $page The page to verify

+ * @param bool $mod_rewrite Whether mod_rewrite is enabled, default: false

+ *

+ * @return string A valid page based on given page and mod_rewrite

+ */

+ public function get_valid_page($page, $mod_rewrite = false)

+ {

+ // We need to be cautious here.

+ // On some situations, the redirect path is an absolute URL, sometimes a relative path

+ // For a relative path, let's prefix it with $phpbb_root_path to point to the correct location,

+ // else we use the URL directly.

+ $url_parts = parse_url($page);

+

+ // URL

+ if ($url_parts === false || empty($url_parts['scheme']) || empty($url_parts['host']))

+ {

+ // Remove 'app.php/' from the page, when rewrite is enabled.

+ // Treat app.php as a reserved file name and remove on mod rewrite

+ // even if it might not be in the phpBB root.

+ if ($mod_rewrite && ($app_position = strpos($page, 'app.' . $this->php_ext . '/')) !== false)

+ {

+ $page = substr($page, 0, $app_position) . substr($page, $app_position + strlen('app.' . $this->php_ext . '/'));

+ }

+

+ // Remove preceding slashes from page name and prepend root path

+ $page = $this->get_phpbb_root_path() . ltrim($page, '/\\');

+ }

+

+ return $page;

+ }

+ if (!phpbb_is_writable($this->temporary_directory) || !move_uploaded_file($upload['tmp_name'], $tmp_file))

+ $field_data[$key][$lang_id] = is_array($options) ? $options : explode("\n", $options);

+ $default_value = '';

+ $lang_fields = array(

+ 'l_lang_name',

+ 'l_lang_explain',

+ 'l_lang_default_value',

+ 'l_lang_options',

+ );

+

+ if (in_array($key, $lang_fields))

+ {

+ $default_value = array(0 => '');

+ }

+ return $this->request->variable($key, $default_value, true);

+ return $this->lang_helper->is_set($field_id, $lang_id, $field_value + 1) ? $this->lang_helper->get($field_id, $lang_id, $field_value + 1) : null;

+ if ($key == 'l_lang_options' && $this->request->is_set($key))

+ if ($key == 'field_default_value')

+ $field_length = $this->request->variable('field_length', 0);

+

+ // Do a simple is set check if using checkbox.

+ if ($field_length == 2)

+ return $this->request->is_set($key);

+ return $this->request->variable($key, $field_data[$key], true);

+ }

+

+ $default_lang_options = array(

+ 'l_lang_options' => array(0 => array('')),

+ 'lang_options' => array(0 => ''),

+ );

+

+ if (isset($default_lang_options[$key]) && $this->request->is_set($key))

+ {

+ return $this->request->variable($key, $default_lang_options[$key], true);

+

+ return parent::prepare_hidden_fields($step, $key, $action, $field_data);

+ 'ALPHA_ONLY' => '[a-zA-Z0-9]+',

+ 'ALPHA_UNDERSCORE' => '[\w]+',

+ 'ALPHA_DOTS' => '[a-zA-Z0-9.]+',

+ 'ALPHA_SPACERS' => '[\w\x20+\-\[\]]+',

+ 'ALPHA_PUNCTUATION' => '[a-zA-Z][\w\.,\-]+',

+ if (!preg_match('#^' . get_preg_expression('url') . '$#iu', $field_value))

+ return $this->variable($form_name, array('name' => 'none'), true, \phpbb\request\request_interface::FILES);

+

+ /**

+ * {@inheritdoc}

+ */

+ public function escape($var, $multibyte)

+ {

+ if (is_array($var))

+ {

+ $result = array();

+ foreach ($var as $key => $value)

+ {

+ $this->type_cast_helper->set_var($key, $key, gettype($key), $multibyte);

+ $result[$key] = $this->escape($value, $multibyte);

+ }

+ $var = $result;

+ }

+ else

+ {

+ $this->type_cast_helper->set_var($var, $var, 'string', $multibyte);

+ }

+

+ return $var;

+ }

+

+ /**

+ * Escape a string variable.

+ *

+ * @param mixed $value The contents to fill with

+ * @param bool $multibyte Indicates whether string values may contain UTF-8 characters.

+ * Default is false, causing all bytes outside the ASCII range (0-127) to be replaced with question marks.

+ * @return string|array

+ */

+ public function escape($value, $multibyte);

+ preg_match_all('#([^\\s+\\-|()]+)(?:$|[\\s+\\-|()])#u', $keywords, $exact_words);

+ trigger_error(sprintf($this->user->lang['WORDS_IN_NO_POST'], implode($this->user->lang['COMMA_SEPARATOR'], $non_common_words)));

+ // if using mysql and the total result count is not calculated yet, get it from the db

+ if (!$total_results && $is_mysql)

+ {

+ // Also count rows for the query as if there was not LIMIT. Add SQL_CALC_FOUND_ROWS to SQL

+ $sql_array['SELECT'] = 'SQL_CALC_FOUND_ROWS ' . $sql_array['SELECT'];

+ }

+

+ // Get the number of results as calculated by MySQL

+ array('sql_user', '[dbuser]'),

+ array('sql_pass', '[dbpassword]'),

+ 'WHERE' => 'p2.post_id = ' . ((int) $post_id),

+ * Extract current session page

+ *

+ * @param string $root_path current root path (phpbb_root_path)

+ * @return array

+ */

+ $script_name = $request->escape($symfony_request->getScriptName(), true);

+ $args = $request->escape(explode('&', $symfony_request->getQueryString()), true);

+ $find = array('"', "'", '<', '>', '&quot;', '&lt;', '&gt;');

+ $replace = array('%22', '%27', '%3C', '%3E', '%22', '%3C', '%3E');

+ $page_name .= str_replace('%2F', '/', urlencode($symfony_request_path));

+ $forum_id = $request->variable('f', 0);

+ // maximum forum id value is maximum value of mediumint unsigned column

+ $forum_id = ($forum_id > 0 && $forum_id < 16777215) ? $forum_id : 0;

+

+ 'forum' => $forum_id,

+ if ($user_id !== false && sizeof($this->data) && $this->data['user_id'] != $user_id)

+ {

+ $this->data = array();

+ }

+

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

+

+ if ($user_id === false || (isset($user_data['user_id']) && $user_id == $user_data['user_id']))

+ {

+ $this->data = $user_data;

+ $bot = false;

+ }

+

+

+ if ($user_id !== false && !sizeof($this->data))

+ $domain = (!$config['cookie_domain'] || $config['cookie_domain'] == '127.0.0.1' || strpos($config['cookie_domain'], '.') === false) ? '' : '; domain=' . $config['cookie_domain'];

+ global $config, $db, $phpbb_dispatcher;

+ /**

+ * Event to set custom ban type

+ *

+ * @event core.session_set_custom_ban

+ * @var bool return If $return is false this routine does not return on finding a banned user, it outputs a relevant message and stops execution

+ * @var bool banned Check if user already banned

+ * @var array|false ban_row Ban data

+ * @var string ban_triggered_by Method that caused ban, can be your custom method

+ * @since 3.1.3-RC1

+ */

+ $ban_row = isset($ban_row) ? $ban_row : false;

+ $vars = array('return', 'banned', 'ban_row', 'ban_triggered_by');

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

+

+/**

+ * WARNING: The Symfony request does not escape the input and should be used very carefully

+ * prefer the phpbb request as possible

+ */

+ if (defined('DEBUG'))

+ {

+ $this->twig->addExtension(new \Twig_Extension_Debug());

+ }

+

+ $theme_path = $path . 'theme/';

+ $is_valid_dir = false;

+ $is_valid_dir = true;

+ $paths[] = $template_path;

+ }

+ if (is_dir($theme_path))

+ {

+ $is_valid_dir = true;

+ $paths[] = $theme_path;

+ }

+

+ if ($is_valid_dir)

+ {

+ $ext_style_theme_path = $ext_style_path . 'theme/';

+ $ext_style_theme_path = $ext_style_path . 'theme/';

+ $ext_style_theme_path = $ext_style_path . 'theme/';

+ $is_valid_dir = false;

+ $is_valid_dir = true;

+ $paths[] = $ext_style_template_path;

+ }

+ if (is_dir($ext_style_theme_path))

+ {

+ $is_valid_dir = true;

+ $paths[] = $ext_style_theme_path;

+ }

+

+ if ($is_valid_dir)

+ {

+ $time = new $this->datetime($this, "@$gmepoch", $utc);

+ if (!function_exists('phpbb_get_user_rank'))

+ $user_rank_data = phpbb_get_user_rank($user, (($user['user_id'] == ANONYMOUS) ? false : $user['user_posts']));

+ $rank['rank_title'] = $user_rank_data['title'];

+ $rank['rank_img'] = $user_rank_data['img'];

+ $rank['rank_img_src'] = $user_rank_data['img_src'];

+ /** @var \phpbb\file_downloader */

+ protected $file_downloader;

+

+ * @param \phpbb\file_downloader $file_downloader

+ public function __construct(\phpbb\cache\service $cache, \phpbb\config\config $config, \phpbb\file_downloader $file_downloader, \phpbb\user $user)

+ $this->file_downloader = $file_downloader;

+ $cache_file = '_versioncheck_' . $this->host . $this->path . $this->file;

+ try {

+ $info = $this->file_downloader->get($this->host, $this->path, $this->file);

+ }

+ catch (\phpbb\exception\runtime_exception $exception)

+ {

+ $prepare_parameters = array_merge(array($exception->getMessage()), $exception->get_parameters());

+ throw new \RuntimeException(call_user_func_array(array($this->user, 'lang'), $prepare_parameters));

+ }

+ $error_string = $this->file_downloader->get_error_string();

+ if (!empty($error_string))

+ throw new \RuntimeException($error_string);

+ // Sanitize any data we retrieve from a server

+ if (!empty($info))

+ {

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

+ $type_cast_helper = new \phpbb\request\type_cast_helper();

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

+ };

+ array_walk_recursive($info, $json_sanitizer);

+ }

+