+ /* @var $provider_collection \phpbb\auth\provider_collection */

+ /* @var $captcha_factory \phpbb\captcha\factory */

+ $db_tool = new \phpbb\db\tools\tools($db);

+ $db_tool = new \phpbb\db\tools\tools($db);

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

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

+ * Event dispatcher object

+ * @var \phpbb\event\dispatcher

+ */

+ protected $phpbb_dispatcher;

+

+ /**

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

+ public function __construct(\phpbb\auth\auth $auth, \phpbb\config\config $config, \phpbb\event\dispatcher $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;

+ $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 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 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',

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

+ }

+

+ *

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

+<?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_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

+ /* @var $passwords_manager \phpbb\passwords\manager */

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

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

+ // soon as the \phpbb\db\tools\tools class is capable of properly

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

+ }

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

+ }

+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 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 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 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')),

+ );

+ }

+}

+ /** @var \phpbb\db\tools\tools_interface */

+ * @param \phpbb\db\tools\tools_interface $db_tools

+ public function __construct(\phpbb\config\config $config, \phpbb\db\driver\driver_interface $db, \phpbb\db\tools\tools_interface $db_tools, $phpbb_root_path, $php_ext, $table_prefix)

+abstract class profilefield_base_migration extends container_aware_migration

+ /* @var $manager \phpbb\profilefields\manager */

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

+ /** @var \phpbb\db\tools\tools_interface */

+ public function __construct(array $class_names, \phpbb\config\config $config, \phpbb\db\driver\driver_interface $db, \phpbb\db\tools\tools_interface $db_tools, $phpbb_root_path, $php_ext, $table_prefix)

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

+use Symfony\Component\DependencyInjection\ContainerAwareInterface;

+use Symfony\Component\DependencyInjection\ContainerInterface;

+

+ /**

+ * @var ContainerInterface

+ */

+ protected $container;

+

+ /** @var \phpbb\db\tools\tools_interface */

+ * @var migrator_output_handler_interface

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

+ $this->container = $container;

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

+ {

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

+ $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\tools;

+

+/**

+ * A factory which serves the suitable tools instance for the given dbal

+ */

+class factory

+{

+ /**

+ * @param mixed $db_driver

+ * @param bool $return_statements

+ * @return \phpbb\db\tools\tools_interface

+ */

+ public function get($db_driver, $return_statements = false)

+ {

+ if ($db_driver instanceof \phpbb\db\driver\driver_interface)

+ {

+ return new \phpbb\db\tools\tools($db_driver, $return_statements);

+ }

+

+ throw new \InvalidArgumentException('Invalid database driver given');

+ }

+}

+namespace phpbb\db\tools;

+class tools implements tools_interface

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ */

+ function sql_list_columns($table_name)

+ $sql = "SHOW COLUMNS FROM $table_name";

+ WHERE c.relname = '{$table_name}'

+ WHERE o.name = '{$table_name}'";

+ WHERE LOWER(table_name) = '" . strtolower($table_name) . "'";

+ AND name = '{$table_name}'";

+ * {@inheritDoc}

+ */

+ function sql_column_exists($table_name, $column_name)

+ $columns = $this->sql_list_columns($table_name);

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ */

+ // 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] . "'";

+ }

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ */

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

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ */

+<?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\tools;

+

+/**

+ * Interface for a Database Tools for handling cross-db actions such as altering columns, etc.

+ */

+interface tools_interface

+{

+ /**

+ * Handle passed database update array.

+ * Expected structure...

+ * Key being one of the following

+ * drop_tables: Drop tables

+ * add_tables: Add tables

+ * change_columns: Column changes (only type, not name)

+ * add_columns: Add columns to a table

+ * drop_keys: Dropping keys

+ * drop_columns: Removing/Dropping columns

+ * add_primary_keys: adding primary keys

+ * add_unique_index: adding an unique index

+ * add_index: adding an index (can be column:index_size if you need to provide size)

+ *

+ * The values are in this format:

+ * {TABLE NAME} => array(

+ * {COLUMN NAME} => array({COLUMN TYPE}, {DEFAULT VALUE}, {OPTIONAL VARIABLES}),

+ * {KEY/INDEX NAME} => array({COLUMN NAMES}),

+ * )

+ *

+ *

+ * @param array $schema_changes

+ * @return null

+ */

+ public function perform_schema_changes($schema_changes);

+

+ /**

+ * Gets a list of tables in the database.

+ *

+ * @return array Array of table names (all lower case)

+ */

+ public function sql_list_tables();

+

+ /**

+ * Check if table exists

+ *

+ * @param string $table_name The table name to check for

+ * @return bool true if table exists, else false

+ */

+ public function sql_table_exists($table_name);

+

+ /**

+ * Create SQL Table

+ *

+ * @param string $table_name The table name to create

+ * @param array $table_data Array containing table data.

+ * @return array|true Statements to run, or true if the statements have been executed

+ */

+ public function sql_create_table($table_name, $table_data);

+

+ /**

+ * Drop Table

+ *

+ * @param string $table_name The table name to drop

+ * @return array|true Statements to run, or true if the statements have been executed

+ */

+ public function sql_table_drop($table_name);

+

+ /**

+ * Gets a list of columns of a table.

+ *

+ * @param string $table_name Table name

+ * @return array Array of column names (all lower case)

+ */

+ public function sql_list_columns($table_name);

+

+ /**

+ * Check whether a specified column exist in a table

+ *

+ * @param string $table_name Table to check

+ * @param string $column_name Column to check

+ * @return bool True if column exists, false otherwise

+ */

+ public function sql_column_exists($table_name, $column_name);

+

+ /**

+ * Add new column

+ *

+ * @param string $table_name Table to modify

+ * @param string $column_name Name of the column to add

+ * @param array $column_data Column data

+ * @param bool $inline Whether the query should actually be run,

+ * or return a string for adding the column

+ * @return array|true Statements to run, or true if the statements have been executed

+ */

+ public function sql_column_add($table_name, $column_name, $column_data, $inline = false);

+

+ /**

+ * Change column type (not name!)

+ *

+ * @param string $table_name Table to modify

+ * @param string $column_name Name of the column to modify

+ * @param array $column_data Column data

+ * @param bool $inline Whether the query should actually be run,

+ * or return a string for modifying the column

+ * @return array|true Statements to run, or true if the statements have been executed

+ */

+ public function sql_column_change($table_name, $column_name, $column_data, $inline = false);

+

+ /**

+ * Drop column

+ *

+ * @param string $table_name Table to modify

+ * @param string $column_name Name of the column to drop

+ * @param bool $inline Whether the query should actually be run,

+ * or return a string for deleting the column

+ * @return array|true Statements to run, or true if the statements have been executed

+ */

+ public function sql_column_remove($table_name, $column_name, $inline = false);

+

+ /**

+ * List all of the indices that belong to a table

+ *

+ * NOTE: does not list

+ * - UNIQUE indices

+ * - PRIMARY keys

+ *

+ * @param string $table_name Table to check

+ * @return array Array with index names

+ */

+ public function sql_list_index($table_name);

+

+ /**

+ * Check if a specified index exists in table. Does not return PRIMARY KEY and UNIQUE indexes.

+ *

+ * @param string $table_name Table to check the index at

+ * @param string $index_name The index name to check

+ * @return bool True if index exists, else false

+ */

+ public function sql_index_exists($table_name, $index_name);

+

+ /**

+ * Add index

+ *

+ * @param string $table_name Table to modify

+ * @param string $index_name Name of the index to create

+ * @param string|array $column Either a string with a column name, or an array with columns

+ * @return array|true Statements to run, or true if the statements have been executed

+ */

+ public function sql_create_index($table_name, $index_name, $column);

+

+ /**

+ * Drop Index

+ *

+ * @param string $table_name Table to modify

+ * @param string $index_name Name of the index to delete

+ * @return array|true Statements to run, or true if the statements have been executed

+ */

+ public function sql_index_drop($table_name, $index_name);

+

+ /**

+ * Check if a specified index exists in table.

+ *

+ * NOTE: Does not return normal and PRIMARY KEY indexes

+ *

+ * @param string $table_name Table to check the index at

+ * @param string $index_name The index name to check

+ * @return bool True if index exists, else false

+ */

+ public function sql_unique_index_exists($table_name, $index_name);

+

+ /**

+ * Add unique index

+ *

+ * @param string $table_name Table to modify

+ * @param string $index_name Name of the unique index to create

+ * @param string|array $column Either a string with a column name, or an array with columns

+ * @return array|true Statements to run, or true if the statements have been executed

+ */

+ public function sql_create_unique_index($table_name, $index_name, $column);

+

+ /**

+ * Add primary key

+ *

+ * @param string $table_name Table to modify

+ * @param string|array $column Either a string with a column name, or an array with columns

+ * @param bool $inline Whether the query should actually be run,

+ * or return a string for creating the key

+ * @return array|true Statements to run, or true if the statements have been executed

+ */

+ public function sql_create_primary_key($table_name, $column, $inline = false);

+}

+ ->booleanNode('require_dev_dependencies')->defaultValue(false)->end()

+ ->arrayNode('twig')

+ ->addDefaultsIfNotSet()

+ ->children()

+ ->booleanNode('enable_debug_extension')->defaultValue(false)->end()

+ ->end()

+ ->end()

+

+ if ($config['twig']['enable_debug_extension'])

+ {

+ $definition = $container->getDefinition('template.twig.extensions.debug');

+ $definition->addTag('twig.extension');

+ }

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

+ }

+<?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'] : '',

+ /**

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

+

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

+ protected $phpbb_dispatcher;

+

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

+ public function __construct($notification_types, $notification_methods, ContainerInterface $phpbb_container, \phpbb\user_loader $user_loader, \phpbb\config\config $config, \phpbb\event\dispatcher $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;

+ /**

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

+

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

+ }

+ 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 == '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);

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

+ * @var \phpbb\db\tools\tools_interface

+ // Initialize \phpbb\db\tools\tools object

+ $this->db_tools = new \phpbb\db\tools\tools($this->db);

+ /* @var $provider_collection \phpbb\auth\provider_collection */

+ /* @var $provider_collection \phpbb\auth\provider_collection */

+ /* @var $provider_collection \phpbb\auth\provider_collection */

+ /* @var $captcha_factory \phpbb\captcha\factory */

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

+

+ $is_valid_dir = false;

+ $is_valid_dir = true;

+ $is_valid_dir = true;

+ if ($is_valid_dir)

+ * @param int $user_id User ID of the user you want to retrieve the avatar for

+ $row = array(

+ 'avatar' => $user['user_avatar'],

+ 'avatar_type' => $user['user_avatar_type'],

+ 'avatar_width' => $user['user_avatar_width'],

+ 'avatar_height' => $user['user_avatar_height'],

+ );

+ return phpbb_get_avatar($row, 'USER_AVATAR');

+ throw new \RuntimeException($this->user->lang($exception->getMessage()));

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

+ }

+