- if (($rowset = $this->_read('sql_' . md5($query))) === false)

- $query_id = sizeof($this->sql_rowset);

- $this->sql_rowset[$query_id] = $rowset;

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

- global $phpbb_root_path;

- $this->cache_dir = !is_null($cache_dir) ? $cache_dir : $phpbb_root_path . 'cache/';

- global $phpEx;

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

- $query_id = sizeof($this->sql_rowset);

- if ($this->_write('sql_' . md5($query), $this->sql_rowset[$query_id], $ttl + time(), $query))

- // cache has auto GC, no need to have any code here :)

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

- $hash = md5($query);

- $temp[$hash] = true;

- $query_id = sizeof($this->sql_rowset);

- $this->_write('sql_' . $hash, $this->sql_rowset[$query_id], $ttl);

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

- global $config, $db, $user;

- $this->confirm_id = request_var('confirm_id', '');

- $this->confirm_code = request_var('confirm_code', '');

- $refresh = request_var('refresh_vc', false) && $config['confirm_refresh'];

- global $config, $user, $template, $phpbb_admin_path, $phpEx;

- $variables .= '&' . rawurlencode($captcha_var) . '=' . request_var($captcha_var, (int) $config[$captcha_var]);

- if (request_var('confirm_code', false) && $this->solved === 0)

- global $db, $user, $auth, $template;

- $submit = request_var('submit', '');

- $value = request_var($captcha_var, 0);

- set_config($captcha_var, $value);

- add_log('admin', 'LOG_CONFIG_VISUAL');

- $var = (isset($_REQUEST[$captcha_var])) ? request_var($captcha_var, 0) : $config[$captcha_var];

- global $config;

- $config->set($captcha_var, request_var($captcha_var, (int) $config[$captcha_var]));

- global $config, $db, $user;

- $this->confirm_id = request_var('qa_confirm_id', '');

- $this->answer = utf8_normalize_nfc(request_var('qa_answer', '', true));

- global $db;

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

- global $db;

-

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

- $tables = array($this->table_captcha_questions, $this->table_captcha_answers, $this->table_qa_confirm);

- foreach($schemas as $table => $schema)

- global $db;

- $answer = ($this->question_strict) ? utf8_normalize_nfc(request_var('qa_answer', '', true)) : utf8_clean_string(utf8_normalize_nfc(request_var('qa_answer', '', true)));

- if (request_var('qa_answer', false) && $this->solved === 0)

- global $db, $user, $auth, $template;

- $submit = request_var('submit', false);

- $question_id = request_var('question_id', 0);

- $action = request_var('action', '');

- $input_question = request_var('question_text', '', true);

- $input_answers = request_var('answers', '', true);

- $input_lang = request_var('lang_iso', '', true);

- $input_strict = request_var('strict', false);

- add_log('admin', 'LOG_CONFIG_VISUAL');

- $answers = utf8_normalize_nfc(request_var('answers', '', true));

- 'question_text' => request_var('question_text', '', true),

- 'strict' => request_var('strict', false),

- 'lang_iso' => request_var('lang_iso', ''),

- global $config, $db, $user;

- $this->challenge = request_var('recaptcha_challenge_field', '');

- $this->response = request_var('recaptcha_response_field', '');

- global $config, $db, $template, $user;

- $submit = request_var('submit', '');

- $value = request_var($captcha_var, '');

- set_config($captcha_var, $value);

- add_log('admin', 'LOG_CONFIG_VISUAL');

- $var = (isset($_REQUEST[$captcha_var])) ? request_var($captcha_var, '') : ((isset($config[$captcha_var])) ? $config[$captcha_var] : '');

- "php": ">=5.3.3"

-use Symfony\Component\Routing\Generator\UrlGenerator;

- * @param \phpbb\controller\provider $provider Path provider

- * @param \phpbb\extension\manager $manager Extension manager 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)

- $provider->find_routing_files($manager->get_finder());

- $this->route_collection = $provider->find($phpbb_root_path)->get_routes();

- $url_generator = new UrlGenerator($this->route_collection, $context);

- $route_url = $url_generator->generate($route, $params, $reference_type);

-<?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\controller;

-

-use Symfony\Component\Routing\RouteCollection;

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

-use Symfony\Component\Config\FileLocator;

-

-/**

-* Controller interface

-*/

-class provider

-{

- /**

- * YAML file(s) containing route information

- * @var array

- */

- protected $routing_files;

-

- /**

- * Collection of the routes in phpBB and all found extensions

- * @var RouteCollection

- */

- protected $routes;

-

- /**

- * Construct method

- *

- * @param array $routing_files Array of strings containing paths

- * to YAML files holding route information

- */

- public function __construct($routing_files = array())

- {

- $this->routing_files = $routing_files;

- }

-

- /**

- * Find the list of routing files

- *

- * @param \phpbb\finder $finder

- * @return null

- */

- public function find_routing_files(\phpbb\finder $finder)

- {

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

- // because the finder cannot find it

- $this->routing_files = array_merge($this->routing_files, array('config/routing.yml'), array_keys($finder

- ->directory('/config')

- ->suffix('routing.yml')

- ->find()

- ));

- }

-

- /**

- * Find a list of controllers

- *

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

- * @return provider

- */

- public function find($base_path = '')

- {

- $this->routes = new RouteCollection;

- foreach ($this->routing_files as $file_path)

- {

- $loader = new YamlFileLoader(new FileLocator(phpbb_realpath($base_path)));

- $this->routes->addCollection($loader->load($file_path));

- }

-

- return $this;

- }

-

- /**

- * Get the list of routes

- *

- * @return RouteCollection Get the route collection

- */

- public function get_routes()

- {

- return $this->routes;

- }

-}

- * If $forum_data is not given, forum id will be retrieved via request_var

- * If $forum_data is not given, forum id will be retrieved via request_var

- add_log(

- 'critical',

- 'LOG_PLUPLOAD_TIDY_FAILED',

- );

- if ($query_id !== false)

- if ($query_id === false)

- if ($query_id === false)

- if ($query_id !== false)

- $expression = utf8_str_replace(array('_', '%'), array("\_", "\%"), $expression);

- $expression = utf8_str_replace(array(chr(0) . "\_", chr(0) . "\%"), array('_', '%'), $expression);

- $expression = utf8_str_replace(array('_', '%'), array("\_", "\%"), $expression);

- $expression = utf8_str_replace(array(chr(0) . "\_", chr(0) . "\%"), array('_', '%'), $expression);

- $row = @mssql_fetch_assoc($result_id);

- @mssql_free_result($result_id);

- else if (strpos($query, 'SELECT') === 0 && $this->query_result)

- if ($query_id === false)

- $row = @mssql_fetch_assoc($query_id);

- return ($query_id !== false) ? @mssql_data_seek($query_id, $rownum) : false;

- if ($row = @mssql_fetch_assoc($result_id))

- @mssql_free_result($result_id);

- @mssql_free_result($result_id);

- return @mssql_free_result($query_id);

- $row = @mssql_fetch_assoc($result_id);

- @mssql_free_result($result_id);

- $row = @mssql_fetch_assoc($result_id);

- @mssql_free_result($result_id);

- while ($row = @mssql_fetch_row($result))

- @mssql_free_result($result);

- while ($void = @mssql_fetch_assoc($result))

- // Take the time spent on parsing rows into account

- @mssql_free_result($result);

- $row = @odbc_fetch_array($result_id);

- @odbc_free_result($result_id);

- else if (strpos($query, 'SELECT') === 0 && $this->query_result)

- return ($query_id !== false) ? @odbc_fetch_array($query_id) : false;

- if (@odbc_fetch_array($result_id))

- $id = @odbc_result($result_id, 1);

- @odbc_free_result($result_id);

- @odbc_free_result($result_id);

- return @odbc_free_result($query_id);

- while ($void = @odbc_fetch_array($result))

- // Take the time spent on parsing rows into account

- @odbc_free_result($result);

- else if (strpos($query, 'SELECT') === 0 && $this->query_result)

- if ($query_id === false)

- $row = @sqlsrv_fetch_array($query_id, SQLSRV_FETCH_ASSOC);

- if ($result_id !== false)

- $row = @sqlsrv_fetch_array($result_id);

- @sqlsrv_free_stmt($result_id);

- return @sqlsrv_free_stmt($query_id);

- @sqlsrv_next_result($result);

- while ($row = @sqlsrv_fetch_array($result))

- @sqlsrv_free_stmt($result);

- while ($void = @sqlsrv_fetch_array($result))

- // Take the time spent on parsing rows into account

- @sqlsrv_free_stmt($result);

- $row = @mysql_fetch_assoc($result);

- @mysql_free_result($result);

- $modes = array_map('trim', explode(',', $row['sql_mode']));

- $row = @mysql_fetch_assoc($result);

- @mysql_free_result($result);

- $this->sql_server_version = $row['version'];

- if (!empty($cache) && $use_cache)

- {

- $cache->put('mysql_version', $this->sql_server_version);

- else if (strpos($query, 'SELECT') === 0 && $this->query_result)

- return ($query_id !== false) ? @mysql_fetch_assoc($query_id) : false;

- return @mysql_free_result($query_id);

- while ($row = @mysql_fetch_assoc($result))

- @mysql_free_result($result);

- while ($row = @mysql_fetch_assoc($result))

- @mysql_free_result($result);

- while ($void = @mysql_fetch_assoc($result))

- // Take the time spent on parsing rows into account

- @mysql_free_result($result);

- if ($result !== null)

- $row = @mysqli_fetch_assoc($result);

- @mysqli_free_result($result);

- if ($result !== null)

- $row = @mysqli_fetch_assoc($result);

- @mysqli_free_result($result);

- if ($query_id !== false && $query_id !== null)

- $result = @mysqli_fetch_assoc($query_id);

- return ($query_id !== false) ? @mysqli_data_seek($query_id, $rownum) : false;

- return @mysqli_free_result($query_id);

- while ($row = @mysqli_fetch_assoc($result))

- @mysqli_free_result($result);

- while ($row = @mysqli_fetch_assoc($result))

- @mysqli_free_result($result);

- if ($result !== null)

- while ($void = @mysqli_fetch_assoc($result))

- @mysqli_free_result($result);

- else if (strpos($query, 'SELECT') === 0 && $this->query_result)

- if ($query_id !== false)

- $result = @ocifetchinto($query_id, $row, OCI_ASSOC + OCI_RETURN_NULLS);

- if ($query_id === false)

- @ociexecute($stmt, OCI_DEFAULT);

- $temp_result = @ocifetchinto($stmt, $temp_array, OCI_ASSOC + OCI_RETURN_NULLS);

- @ocifreestatement($stmt);

- if ($temp_result)

- {

- return $temp_array['CURRVAL'];

- }

- else

- {

- return false;

- return @ocifreestatement($query_id);

- $success = @ociexecute($result, OCI_DEFAULT);

- $row = array();

-

- while (@ocifetchinto($result, $row, OCI_ASSOC + OCI_RETURN_NULLS))

- // Take the time spent on parsing rows into account

- @ocifreestatement($result);

- $row = @pg_fetch_assoc($query_id, null);

- @pg_free_result($query_id);

- $this->sql_server_version = (!empty($row['version'])) ? trim(substr($row['version'], 10)) : 0;

- if (!empty($cache) && $use_cache)

- {

- $cache->put('pgsql_version', $this->sql_server_version);

- else if (strpos($query, 'SELECT') === 0 && $this->query_result)

- return ($query_id !== false) ? @pg_fetch_assoc($query_id, null) : false;

- return ($query_id !== false) ? @pg_result_seek($query_id, $rownum) : false;

- $temp_result = @pg_fetch_assoc($temp_q_id, null);

- @pg_free_result($query_id);

- return @pg_free_result($query_id);

- while ($row = @pg_fetch_assoc($result, null))

- @pg_free_result($result);

- while ($void = @pg_fetch_assoc($result, null))

- // Take the time spent on parsing rows into account

- @pg_free_result($result);

- $row = @sqlite_fetch_array($result, SQLITE_ASSOC);

- $this->sql_server_version = (!empty($row['version'])) ? $row['version'] : 0;

- if (!empty($cache) && $use_cache)

- {

- $cache->put('sqlite_version', $this->sql_server_version);

- if ($cache && $cache_ttl)

- $this->open_queries[(int) $this->query_result] = $this->query_result;

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

- else if (strpos($query, 'SELECT') === 0 && $this->query_result)

- $this->open_queries[(int) $this->query_result] = $this->query_result;

- return ($query_id !== false) ? @sqlite_fetch_array($query_id, SQLITE_ASSOC) : false;

- return ($query_id !== false) ? @sqlite_seek($query_id, $rownum) : false;

- while ($void = @sqlite_fetch_array($result, SQLITE_ASSOC))

- // Take the time spent on parsing rows into account

- while ($void = $result->fetchArray(SQLITE3_ASSOC))

- // Take the time spent on parsing rows into account

- // soon as the db_tools class is capable of properly

- set_config('default_style', $default_style);

- /** @var \phpbb\db\tools */

- * @param \phpbb\db\tools $db_tools

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

- /** @var \phpbb\db\tools */

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

- add_log('admin', 'LOG_MODULE_ADD', $module_log_name);

- /** @var \phpbb\db\tools */

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

-namespace phpbb\db;

-class tools

- * Is the used MS SQL Server a SQL Server 2000?

- * @var bool

- */

- protected $is_sql_server_2000;

-

- /**

- 'mssql' => array(

- 'INT:' => '[int]',

- 'BINT' => '[float]',

- 'UINT' => '[int]',

- 'UINT:' => '[int]',

- 'TINT:' => '[int]',

- 'USINT' => '[int]',

- 'BOOL' => '[int]',

- 'VCHAR' => '[varchar] (255)',

- 'VCHAR:' => '[varchar] (%d)',

- 'CHAR:' => '[char] (%d)',

- 'XSTEXT' => '[varchar] (1000)',

- 'STEXT' => '[varchar] (3000)',

- 'TEXT' => '[varchar] (8000)',

- 'MTEXT' => '[text]',

- 'XSTEXT_UNI'=> '[varchar] (100)',

- 'STEXT_UNI' => '[varchar] (255)',

- 'TEXT_UNI' => '[varchar] (4000)',

- 'MTEXT_UNI' => '[text]',

- 'TIMESTAMP' => '[int]',

- 'DECIMAL' => '[float]',

- 'DECIMAL:' => '[float]',

- 'PDECIMAL' => '[float]',

- 'PDECIMAL:' => '[float]',

- 'VCHAR_UNI' => '[varchar] (255)',

- 'VCHAR_UNI:'=> '[varchar] (%d)',

- 'VCHAR_CI' => '[varchar] (255)',

- 'VARBINARY' => '[varchar] (255)',

- ),

-

- 'mssqlnative' => array(

- 'INT:' => '[int]',

- 'BINT' => '[float]',

- 'UINT' => '[int]',

- 'UINT:' => '[int]',

- 'TINT:' => '[int]',

- 'USINT' => '[int]',

- 'BOOL' => '[int]',

- 'VCHAR' => '[varchar] (255)',

- 'VCHAR:' => '[varchar] (%d)',

- 'CHAR:' => '[char] (%d)',

- 'XSTEXT' => '[varchar] (1000)',

- 'STEXT' => '[varchar] (3000)',

- 'TEXT' => '[varchar] (8000)',

- 'MTEXT' => '[text]',

- 'XSTEXT_UNI'=> '[varchar] (100)',

- 'STEXT_UNI' => '[varchar] (255)',

- 'TEXT_UNI' => '[varchar] (4000)',

- 'MTEXT_UNI' => '[text]',

- 'TIMESTAMP' => '[int]',

- 'DECIMAL' => '[float]',

- 'DECIMAL:' => '[float]',

- 'PDECIMAL' => '[float]',

- 'PDECIMAL:' => '[float]',

- 'VCHAR_UNI' => '[varchar] (255)',

- 'VCHAR_UNI:'=> '[varchar] (%d)',

- 'VCHAR_CI' => '[varchar] (255)',

- 'VARBINARY' => '[varchar] (255)',

- ),

-

-

- 'postgres' => array(

- 'INT:' => 'INT4',

- 'BINT' => 'INT8',

- 'UINT' => 'INT4', // unsigned

- 'UINT:' => 'INT4', // unsigned

- 'USINT' => 'INT2', // unsigned

- 'BOOL' => 'INT2', // unsigned

- 'TINT:' => 'INT2',

- 'VCHAR' => 'varchar(255)',

- 'VCHAR:' => 'varchar(%d)',

- 'CHAR:' => 'char(%d)',

- 'XSTEXT' => 'varchar(1000)',

- 'STEXT' => 'varchar(3000)',

- 'TEXT' => 'varchar(8000)',

- 'MTEXT' => 'TEXT',

- 'XSTEXT_UNI'=> 'varchar(100)',

- 'STEXT_UNI' => 'varchar(255)',

- 'TEXT_UNI' => 'varchar(4000)',

- 'MTEXT_UNI' => 'TEXT',

- 'TIMESTAMP' => 'INT4', // unsigned

- 'DECIMAL' => 'decimal(5,2)',

- 'DECIMAL:' => 'decimal(%d,2)',

- 'PDECIMAL' => 'decimal(6,3)',

- 'PDECIMAL:' => 'decimal(%d,3)',

- 'VCHAR_UNI' => 'varchar(255)',

- 'VCHAR_UNI:'=> 'varchar(%d)',

- 'VCHAR_CI' => 'varchar_ci',

- 'VARBINARY' => 'bytea',

- ),

- * A list of supported DBMS. We change this class to support more DBMS, the DBMS itself only need to follow some rules.

- * @var array

- */

- var $supported_dbms = array('mssql', 'mssqlnative', 'mysql_40', 'mysql_41', 'oracle', 'postgres', 'sqlite', 'sqlite3');

-

- /**

- case 'mssql':

- case 'mssql_odbc':

- $this->sql_layer = 'mssql';

- break;

-

- case 'mssqlnative':

- $this->sql_layer = 'mssqlnative';

- break;

-

- * Gets a list of tables in the database.

- *

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

- */

- case 'mssql':

- case 'mssql_odbc':

- case 'mssqlnative':

- $sql = "SELECT name

- FROM sysobjects

- WHERE type='U'";

- break;

-

- case 'postgres':

- $sql = 'SELECT relname

- FROM pg_stat_user_tables';

- break;

-

- * Check if table exists

- *

- *

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

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

- */

- * Create SQL Table

- *

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

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

- * @return array Statements if $return_statements is true.

- */

- switch ($this->sql_layer)

- {

- case 'mssql':

- case 'mssqlnative':

- $table_sql = 'CREATE TABLE [' . $table_name . '] (' . "\n";

- break;

-

- default:

- $table_sql = 'CREATE TABLE ' . $table_name . ' (' . "\n";

- break;

- }

-

- if ($this->sql_layer == 'mssql' || $this->sql_layer == 'mssqlnative')

- {

- if (!isset($table_data['PRIMARY_KEY']))

- {

- $table_data['COLUMNS']['mssqlindex'] = array('UINT', null, 'auto_increment');

- $table_data['PRIMARY_KEY'] = 'mssqlindex';

- }

- }

- switch ($this->sql_layer)

- {

- case 'mssql':

- case 'mssqlnative':

- $columns[] = "\t [{$column_name}] " . $prepared_column['column_type_sql_default'];

- break;

-

- default:

- $columns[] = "\t {$column_name} " . $prepared_column['column_type_sql'];

- break;

- }

- // Close the table for two DBMS and add to the statements

- switch ($this->sql_layer)

- {

- case 'mssql':

- case 'mssqlnative':

- $table_sql .= "\n);";

- $statements[] = $table_sql;

- break;

- }

-

- case 'postgres':

- case 'mssql':

- case 'mssqlnative':

- // We need the data here

- $old_return_statements = $this->return_statements;

- $this->return_statements = true;

-

- $primary_key_stmts = $this->sql_create_primary_key($table_name, $table_data['PRIMARY_KEY']);

- foreach ($primary_key_stmts as $pk_stmt)

- {

- $statements[] = $pk_stmt;

- }

-

- $this->return_statements = $old_return_statements;

- break;

-

- case 'postgres':

- // do we need to add a sequence for auto incrementing columns?

- if ($create_sequence)

- {

- $statements[] = "CREATE SEQUENCE {$table_name}_seq;";

- }

-

- $table_sql .= "\n);";

- $statements[] = $table_sql;

- break;

-

- * 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}),

- * )

- *

- * For more information have a look at /develop/create_schema_files.php (only available through SVN)

- */

- * Gets a list of columns of a table.

- *

- * @param string $table Table name

- *

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

- */

- function sql_list_columns($table)

- $sql = "SHOW COLUMNS FROM $table";

- break;

-

- // PostgreSQL has a way of doing this in a much simpler way but would

- // not allow us to support all versions of PostgreSQL

- case 'postgres':

- $sql = "SELECT a.attname

- FROM pg_class c, pg_attribute a

- WHERE c.relname = '{$table}'

- AND a.attnum > 0

- AND a.attrelid = c.oid";

- break;

-

- // same deal with PostgreSQL, we must perform more complex operations than

- // we technically could

- case 'mssql':

- case 'mssqlnative':

- $sql = "SELECT c.name

- FROM syscolumns c

- LEFT JOIN sysobjects o ON c.id = o.id

- WHERE o.name = '{$table}'";

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

- AND name = '{$table}'";

- * Check whether a specified column exist in a table

- *

- * @param string $table Table to check

- * @param string $column_name Column to check

- *

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

- */

- function sql_column_exists($table, $column_name)

- $columns = $this->sql_list_columns($table);

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

- */

- if ($this->sql_layer == 'mssql' || $this->sql_layer == 'mssqlnative')

- {

- $sql = "EXEC sp_statistics '$table_name'";

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

-

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

- {

- if ($row['TYPE'] == 3)

- {

- if (strtolower($row['INDEX_NAME']) == strtolower($index_name))

- {

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

- return true;

- }

- }

- }

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

-

- return false;

- }

-

- case 'postgres':

- $sql = "SELECT ic.relname as index_name

- FROM pg_class bc, pg_class ic, pg_index i

- WHERE (bc.oid = i.indrelid)

- AND (ic.oid = i.indexrelid)

- AND (bc.relname = '" . $table_name . "')

- AND (i.indisunique != 't')

- AND (i.indisprimary != 't')";

- $col = 'index_name';

- break;

-

- case 'postgres':

- * Check if a specified index exists in table. Does not return 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

- */

- if ($this->sql_layer == 'mssql' || $this->sql_layer == 'mssqlnative')

- {

- $sql = "EXEC sp_statistics '$table_name'";

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

-

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

- {

- // Usually NON_UNIQUE is the column we want to check, but we allow for both

- if ($row['TYPE'] == 3)

- {

- if (strtolower($row['INDEX_NAME']) == strtolower($index_name))

- {

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

- return true;

- }

- }

- }

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

- return false;

- }

-

- case 'postgres':

- $sql = "SELECT ic.relname as index_name, i.indisunique

- FROM pg_class bc, pg_class ic, pg_index i

- WHERE (bc.oid = i.indrelid)

- AND (ic.oid = i.indexrelid)

- AND (bc.relname = '" . $table_name . "')

- AND (i.indisprimary != 't')";

- $col = 'index_name';

- break;

-

- if ($this->sql_layer == 'postgres' && $row['indisunique'] != 't')

- {

- continue;

- }

-

- case 'postgres':

- case 'mssql':

- case 'mssqlnative':

- $sql .= " {$column_type} ";

- $sql_default = " {$column_type} ";

-

- // For adding columns we need the default definition

- if (!is_null($column_data[1]))

- {

- // For hexadecimal values do not use single quotes

- if (strpos($column_data[1], '0x') === 0)

- {

- $return_array['default'] = 'DEFAULT (' . $column_data[1] . ') ';

- $sql_default .= $return_array['default'];

- }

- else

- {

- $return_array['default'] = 'DEFAULT (' . ((is_numeric($column_data[1])) ? $column_data[1] : "'{$column_data[1]}'") . ') ';

- $sql_default .= $return_array['default'];

- }

- }

-

- if (isset($column_data[2]) && $column_data[2] == 'auto_increment')

- {

-// $sql .= 'IDENTITY (1, 1) ';

- $sql_default .= 'IDENTITY (1, 1) ';

- }

-

- $return_array['textimage'] = $column_type === '[text]';

-

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

- {

- $sql .= 'NOT NULL';

- $sql_default .= 'NOT NULL';

- }

- else

- {

- $sql .= 'NULL';

- $sql_default .= 'NULL';

- }

-

- $return_array['column_type_sql_default'] = $sql_default;

-

- break;

-

- case 'postgres':

- $return_array['column_type'] = $column_type;

-

- $sql .= " {$column_type} ";

-

- $return_array['auto_increment'] = false;

- if (isset($column_data[2]) && $column_data[2] == 'auto_increment')

- {

- $default_val = "nextval('{$table_name}_seq')";

- $return_array['auto_increment'] = true;

- }

- else if (!is_null($column_data[1]))

- {

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

- $return_array['null'] = 'NOT NULL';

- $sql .= 'NOT NULL ';

- }

- else

- {

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

- }

- $return_array['null'] = 'NULL';

- $sql .= 'NULL ';

- }

-

- $return_array['default'] = $default_val;

-

- $sql .= "DEFAULT {$default_val}";

-

- // Unsigned? Then add a CHECK contraint

- if (in_array($orig_column_type, $this->unsigned_types))

- {

- $return_array['constraint'] = "CHECK ({$column_name} >= 0)";

- $sql .= " CHECK ({$column_name} >= 0)";

- }

-

- break;

-

- * Add new column

- */

- case 'mssql':

- case 'mssqlnative':

- // Does not support AFTER, only through temporary table

- $statements[] = 'ALTER TABLE [' . $table_name . '] ADD [' . $column_name . '] ' . $column_data['column_type_sql_default'];

- break;

-

- case 'postgres':

- // Does not support AFTER, only through temporary table

- if (version_compare($this->db->sql_server_info(true), '8.0', '>='))

- {

- $statements[] = 'ALTER TABLE ' . $table_name . ' ADD COLUMN "' . $column_name . '" ' . $column_data['column_type_sql'];

- }

- else

- {

- // old versions cannot add columns with default and null information

- $statements[] = 'ALTER TABLE ' . $table_name . ' ADD COLUMN "' . $column_name . '" ' . $column_data['column_type'] . ' ' . $column_data['constraint'];

-

- if (isset($column_data['null']))

- {

- if ($column_data['null'] == 'NOT NULL')

- {

- $statements[] = 'ALTER TABLE ' . $table_name . ' ALTER COLUMN ' . $column_name . ' SET NOT NULL';

- }

- }

-

- if (isset($column_data['default']))

- {

- $statements[] = 'ALTER TABLE ' . $table_name . ' ALTER COLUMN ' . $column_name . ' SET DEFAULT ' . $column_data['default'];

- }

- }

-

- break;

-

- * Drop column

- */

- case 'mssql':

- case 'mssqlnative':

- // We need the data here

- $old_return_statements = $this->return_statements;

- $this->return_statements = true;

-

- $indexes = $this->get_existing_indexes($table_name, $column_name);

- $indexes = array_merge($indexes, $this->get_existing_indexes($table_name, $column_name, true));

-

- // Drop any indexes

- $recreate_indexes = array();

- if (!empty($indexes))

- {

- foreach ($indexes as $index_name => $index_data)

- {

- $result = $this->sql_index_drop($table_name, $index_name);

- $statements = array_merge($statements, $result);

- if (sizeof($index_data) > 1)

- {

- // Remove this column from the index and recreate it

- $recreate_indexes[$index_name] = array_diff($index_data, array($column_name));

- }

- }

- }

-

- // Drop default value constraint

- $result = $this->mssql_get_drop_default_constraints_queries($table_name, $column_name);

- $statements = array_merge($statements, $result);

-

- // Remove the column

- $statements[] = 'ALTER TABLE [' . $table_name . '] DROP COLUMN [' . $column_name . ']';

-

- if (!empty($recreate_indexes))

- {

- // Recreate indexes after we removed the column

- foreach ($recreate_indexes as $index_name => $index_data)

- {

- $result = $this->sql_create_index($table_name, $index_name, $index_data);

- $statements = array_merge($statements, $result);

- }

- }

-

- $this->return_statements = $old_return_statements;

- break;

-

- case 'postgres':

- $statements[] = 'ALTER TABLE ' . $table_name . ' DROP COLUMN "' . $column_name . '"';

- break;

-

- * Drop Index

- */

- case 'mssql':

- case 'mssqlnative':

- $statements[] = 'DROP INDEX ' . $table_name . '.' . $index_name;

- break;

-

- case 'postgres':

- * Drop Table

- */

-

- case 'postgres':

- // PGSQL does not "tightly" bind sequences and tables, we must guess...

- $sql = "SELECT relname

- FROM pg_class

- WHERE relkind = 'S'

- AND relname = '{$table_name}_seq'";

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

-

- // We don't even care about storing the results. We already know the answer if we get rows back.

- if ($this->db->sql_fetchrow($result))

- {

- $statements[] = "DROP SEQUENCE {$table_name}_seq;\n";

- }

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

- break;

- * Add primary key

- */

- case 'postgres':

- case 'mssql':

- case 'mssqlnative':

- $sql = "ALTER TABLE [{$table_name}] WITH NOCHECK ADD ";

- $sql .= "CONSTRAINT [PK_{$table_name}] PRIMARY KEY CLUSTERED (";

- $sql .= '[' . implode("],\n\t\t[", $column) . ']';

- $sql .= ')';

-

- $statements[] = $sql;

- break;

-

- * Add unique index

- */

- $table_prefix = substr(CONFIG_TABLE, 0, -6); // strlen(config)

- if (strlen($table_name . '_' . $index_name) - strlen($table_prefix) > 24)

- {

- $max_length = strlen($table_prefix) + 24;

- trigger_error("Index name '{$table_name}_$index_name' on table '$table_name' is too long. The maximum is $max_length characters.", E_USER_ERROR);

- }

- case 'postgres':

-

- case 'mssql':

- case 'mssqlnative':

- $statements[] = 'CREATE UNIQUE INDEX [' . $index_name . '] ON [' . $table_name . ']([' . implode('], [', $column) . '])';

- break;

- * Add index

- */

- $table_prefix = substr(CONFIG_TABLE, 0, -6); // strlen(config)

- if (strlen($table_name . $index_name) - strlen($table_prefix) > 24)

- {

- $max_length = strlen($table_prefix) + 24;

- trigger_error("Index name '{$table_name}_$index_name' on table '$table_name' is too long. The maximum is $max_length characters.", E_USER_ERROR);

- }

- case 'postgres':

-

- case 'mssql':

- case 'mssqlnative':

- $statements[] = 'CREATE INDEX [' . $index_name . '] ON [' . $table_name . ']([' . implode('], [', $column) . '])';

- break;

- * List all of the indices that belong to a table,

- * does not count:

- * * UNIQUE indices

- * * PRIMARY keys

- */

- if ($this->sql_layer == 'mssql' || $this->sql_layer == 'mssqlnative')

- {

- $sql = "EXEC sp_statistics '$table_name'";

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

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

- {

- if ($row['TYPE'] == 3)

- {

- $index_array[] = $row['INDEX_NAME'];

- }

- }

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

- }

- else

- switch ($this->sql_layer)

- {

- case 'postgres':

- $sql = "SELECT ic.relname as index_name

- FROM pg_class bc, pg_class ic, pg_index i

- WHERE (bc.oid = i.indrelid)

- AND (ic.oid = i.indexrelid)

- AND (bc.relname = '" . $table_name . "')

- AND (i.indisunique != 't')

- AND (i.indisprimary != 't')";

- $col = 'index_name';

- case 'mysql_40':

- case 'mysql_41':

- $sql = 'SHOW KEYS

- FROM ' . $table_name;

- $col = 'Key_name';

- case 'oracle':

- $sql = "SELECT index_name

- FROM user_indexes

- WHERE table_name = '" . strtoupper($table_name) . "'

- AND generated = 'N'

- AND uniqueness = 'NONUNIQUE'";

- $col = 'index_name';

- case 'sqlite':

- case 'sqlite3':

- $sql = "PRAGMA index_info('" . $table_name . "');";

- $col = 'name';

- break;

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

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

- if (($this->sql_layer == 'mysql_40' || $this->sql_layer == 'mysql_41') && !$row['Non_unique'])

- {

- continue;

- }

-

- switch ($this->sql_layer)

- {

- case 'oracle':

- case 'postgres':

- case 'sqlite':

- case 'sqlite3':

- $row[$col] = substr($row[$col], strlen($table_name) + 1);

- }

-

- $index_array[] = $row[$col];

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

- * Change column type (not name!)

- */

- case 'mssql':

- case 'mssqlnative':

- // We need the data here

- $old_return_statements = $this->return_statements;

- $this->return_statements = true;

-

- $indexes = $this->get_existing_indexes($table_name, $column_name);

- $unique_indexes = $this->get_existing_indexes($table_name, $column_name, true);

-

- // Drop any indexes

- if (!empty($indexes) || !empty($unique_indexes))

- {

- $drop_indexes = array_merge(array_keys($indexes), array_keys($unique_indexes));

- foreach ($drop_indexes as $index_name)

- {

- $result = $this->sql_index_drop($table_name, $index_name);

- $statements = array_merge($statements, $result);

- }

- }

-

- // Drop default value constraint

- $result = $this->mssql_get_drop_default_constraints_queries($table_name, $column_name);

- $statements = array_merge($statements, $result);

-

- // Change the column

- $statements[] = 'ALTER TABLE [' . $table_name . '] ALTER COLUMN [' . $column_name . '] ' . $column_data['column_type_sql'];

-

- if (!empty($column_data['default']))

- {

- // Add new default value constraint

- $statements[] = 'ALTER TABLE [' . $table_name . '] ADD CONSTRAINT [DF_' . $table_name . '_' . $column_name . '_1] ' . $this->db->sql_escape($column_data['default']) . ' FOR [' . $column_name . ']';

- }

-

- if (!empty($indexes))

- {

- // Recreate indexes after we changed the column

- foreach ($indexes as $index_name => $index_data)

- {

- $result = $this->sql_create_index($table_name, $index_name, $index_data);

- $statements = array_merge($statements, $result);

- }

- }

-

- if (!empty($unique_indexes))

- {

- // Recreate unique indexes after we changed the column

- foreach ($unique_indexes as $index_name => $index_data)

- {

- $result = $this->sql_create_unique_index($table_name, $index_name, $index_data);

- $statements = array_merge($statements, $result);

- }

- }

-

- $this->return_statements = $old_return_statements;

- break;

-

- case 'postgres':

- $sql = 'ALTER TABLE ' . $table_name . ' ';

-

- $sql_array = array();

- $sql_array[] = 'ALTER COLUMN ' . $column_name . ' TYPE ' . $column_data['column_type'];

-

- if (isset($column_data['null']))

- {

- if ($column_data['null'] == 'NOT NULL')

- {

- $sql_array[] = 'ALTER COLUMN ' . $column_name . ' SET NOT NULL';

- }

- else if ($column_data['null'] == 'NULL')

- {

- $sql_array[] = 'ALTER COLUMN ' . $column_name . ' DROP NOT NULL';

- }

- }

-

- if (isset($column_data['default']))

- {

- $sql_array[] = 'ALTER COLUMN ' . $column_name . ' SET DEFAULT ' . $column_data['default'];

- }

-

- // we don't want to double up on constraints if we change different number data types

- if (isset($column_data['constraint']))

- {

- $constraint_sql = "SELECT consrc as constraint_data

- FROM pg_constraint, pg_class bc

- WHERE conrelid = bc.oid

- AND bc.relname = '{$table_name}'

- AND NOT EXISTS (

- SELECT *

- FROM pg_constraint as c, pg_inherits as i

- WHERE i.inhrelid = pg_constraint.conrelid

- AND c.conname = pg_constraint.conname

- AND c.consrc = pg_constraint.consrc

- AND c.conrelid = i.inhparent

- )";

-

- $constraint_exists = false;

-

- $result = $this->db->sql_query($constraint_sql);

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

- {

- if (trim($row['constraint_data']) == trim($column_data['constraint']))

- {

- $constraint_exists = true;

- break;

- }

- }

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

-

- if (!$constraint_exists)

- {

- $sql_array[] = 'ADD ' . $column_data['constraint'];

- }

- }

-

- $sql .= implode(', ', $sql_array);

-

- $statements[] = $sql;

- break;

-

- * Get queries to drop the default constraints of a column

- *

- * We need to drop the default constraints of a column,

- * before being able to change their type or deleting them.

- *

- * @param string $table_name

- * @param string $column_name

- * @return array Array with SQL statements

- */

- protected function mssql_get_drop_default_constraints_queries($table_name, $column_name)

- {

- $statements = array();

- if ($this->mssql_is_sql_server_2000())

- {

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

- // Deprecated in SQL Server 2005

- $sql = "SELECT so.name AS def_name

- FROM sysobjects so

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

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

- AND so.xtype = 'D'

- AND sc.colid = (SELECT colid FROM syscolumns

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

- AND name = '{$column_name}')";

- }

- else

- {

- $sql = "SELECT dobj.name AS def_name

- FROM sys.columns col

- LEFT OUTER JOIN sys.objects dobj ON (dobj.object_id = col.default_object_id AND dobj.type = 'D')

- WHERE col.object_id = object_id('{$table_name}')

- AND col.name = '{$column_name}'

- AND dobj.name IS NOT NULL";

- }

-

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

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

- {

- $statements[] = 'ALTER TABLE [' . $table_name . '] DROP CONSTRAINT [' . $row['def_name'] . ']';

- }

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

-

- return $statements;

- }

-

- /**

- case 'postgres':

- case 'mssql':

- case 'mssqlnative':

- if ($this->mssql_is_sql_server_2000())

- {

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

- // Deprecated in SQL Server 2005

- $sql = "SELECT DISTINCT ix.name AS phpbb_index_name

- FROM sysindexes ix

- INNER JOIN sysindexkeys ixc

- ON ixc.id = ix.id

- AND ixc.indid = ix.indid

- INNER JOIN syscolumns cols

- ON cols.colid = ixc.colid

- AND cols.id = ix.id

- WHERE ix.id = object_id('{$table_name}')

- AND cols.name = '{$column_name}'

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

- }

- else

- {

- $sql = "SELECT DISTINCT ix.name AS phpbb_index_name

- FROM sys.indexes ix

- INNER JOIN sys.index_columns ixc

- ON ixc.object_id = ix.object_id

- AND ixc.index_id = ix.index_id

- INNER JOIN sys.columns cols

- ON cols.column_id = ixc.column_id

- AND cols.object_id = ix.object_id

- WHERE ix.object_id = object_id('{$table_name}')

- AND cols.name = '{$column_name}'

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

- }

- break;

-

- case 'mssql':

- case 'mssqlnative':

- if ($this->mssql_is_sql_server_2000())

- {

- $sql = "SELECT DISTINCT ix.name AS phpbb_index_name, cols.name AS phpbb_column_name

- FROM sysindexes ix

- INNER JOIN sysindexkeys ixc

- ON ixc.id = ix.id

- AND ixc.indid = ix.indid

- INNER JOIN syscolumns cols

- ON cols.colid = ixc.colid

- AND cols.id = ix.id

- WHERE ix.id = object_id('{$table_name}')

- AND " . $this->db->sql_in_set('ix.name', array_keys($existing_indexes));

- }

- else

- {

- $sql = "SELECT DISTINCT ix.name AS phpbb_index_name, cols.name AS phpbb_column_name

- FROM sys.indexes ix

- INNER JOIN sys.index_columns ixc

- ON ixc.object_id = ix.object_id

- AND ixc.index_id = ix.index_id

- INNER JOIN sys.columns cols

- ON cols.column_id = ixc.column_id

- AND cols.object_id = ix.object_id

- WHERE ix.object_id = object_id('{$table_name}')

- AND " . $this->db->sql_in_set('ix.name', array_keys($existing_indexes));

- }

- break;

-

- * Is the used MS SQL Server a SQL Server 2000?

- *

- * @return bool

- */

- protected function mssql_is_sql_server_2000()

- {

- if ($this->is_sql_server_2000 === null)

- {

- $sql = "SELECT CAST(SERVERPROPERTY('productversion') AS VARCHAR(25)) AS mssql_version";

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

- $properties = $this->db->sql_fetchrow($result);

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

- $this->is_sql_server_2000 = $properties['mssql_version'][0] == '8';

- }

-

- return $this->is_sql_server_2000;

- }

-

- /**

-use Symfony\Component\HttpKernel\DependencyInjection\RegisterListenersPass;

- /** @var string phpBB Root Path */

- /** @var string php file extension */

- if (!defined('DEBUG_CONTAINER') && $this->dump_container && file_exists($container_filename))

- if ($this->config_path === null)

- {

- $this->config_path = $this->phpbb_root_path . 'config';

- }

- $container_extensions = array(new \phpbb\di\extension\core($this->config_path));

- $container_extensions[] = new \phpbb\di\extension\ext($installed_exts);

- if ($this->dump_container && !defined('DEBUG_CONTAINER'))

- $this->dump_container($container_filename);

- * @param string $container_filename The name of the file.

- protected function dump_container($container_filename)

- file_put_contents($container_filename, $cached_container_dump);

- $container = new ContainerBuilder();

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

- * Inject the customs parameters into the container

- */

- if ($this->custom_parameters === null)

- $this->custom_parameters = array(

- 'core.root_path' => $this->phpbb_root_path,

- 'core.php_ext' => $this->php_ext,

- );

- foreach ($this->custom_parameters as $key => $value)

- $this->container->setParameter($key, $value);

- return $this->phpbb_root_path . 'cache/container_' . $filename . '.' . $this->php_ext;

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

-use Symfony\Component\Config\FileLocator;

- * Config path

- * @var string

- */

- * Constructor

- *

- * @param string $config_path Config path

- */

- * Loads a specific configuration.

- *

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

- * @param ContainerBuilder $container A ContainerBuilder instance

- *

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

- */

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

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

- * Returns the recommended alias to use in XML.

- *

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

- *

- * @return string The alias

- */

-<?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\di\extension;

-

-use Symfony\Component\DependencyInjection\ContainerBuilder;

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

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

-use Symfony\Component\Config\FileLocator;

-

-/**

-* Container ext extension

-*/

-class ext extends Extension

-{

- protected $paths = array();

-

- public function __construct($enabled_extensions)

- {

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

- {

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

- }

- }

-

- /**

- * Loads a specific configuration.

- *

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

- * @param ContainerBuilder $container A ContainerBuilder instance

- *

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

- */

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

- {

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

- {

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

- {

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

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

- }

- }

- }

-

- /**

- * Returns the recommended alias to use in XML.

- *

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

- *

- * @return string The alias

- */

- public function getAlias()

- {

- return 'ext';

- }

-}

-<?php

-/**

-*

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

-

-use Symfony\Component\EventDispatcher\EventSubscriberInterface;

-use Symfony\Component\HttpKernel\KernelEvents;

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

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

-use Symfony\Component\Routing\RequestContext;

-

-class kernel_request_subscriber implements EventSubscriberInterface

-{

- /**

- * Extension manager object

- * @var \phpbb\extension\manager

- */

- protected $manager;

-

- /**

- * PHP file extension

- * @var string

- */

- protected $php_ext;

-

- /**

- * Root path

- * @var string

- */

- protected $root_path;

-

- /**

- * Construct method

- *

- * @param \phpbb\extension\manager $manager Extension manager object

- * @param string $root_path Root path

- * @param string $php_ext PHP file extension

- */

- public function __construct(\phpbb\extension\manager $manager, $root_path, $php_ext)

- {

- $this->root_path = $root_path;

- $this->php_ext = $php_ext;

- $this->manager = $manager;

- }

-

- /**

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

- *

- * This is responsible for setting up the routing information

- *

- * @param GetResponseEvent $event

- * @throws \BadMethodCallException

- * @return null

- */

- public function on_kernel_request(GetResponseEvent $event)

- {

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

- $context = new RequestContext();

- $context->fromRequest($request);

-

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

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

- $router_listener->onKernelRequest($event);

- }

-

- public static function getSubscribedEvents()

- {

- return array(

- KernelEvents::REQUEST => 'on_kernel_request',

- );

- }

-}

- $styles = array('prosilver', 'subsilver2');

- $wiki_page .= '! Identifier !! Prosilver Placement (If applicable) !! Subsilver Placement (If applicable) !! Added in Release !! Explanation' . "\n";

- $wiki_page .= implode(', ', $event['files']['prosilver']) . ' || ' . implode(', ', $event['files']['subsilver2']);

- 'subsilver2' => array(),

- else if (($this->filter !== 'adm') && strpos($file, 'styles/subsilver2/template/') === 0)

- {

- $files_list['subsilver2'][] = substr($file, strlen('styles/subsilver2/template/'));

- }

- public function all_configured()

- $data['ext_path'] = $this->phpbb_root_path . $data['ext_path'];

- public function all_enabled()

- $enabled[$name] = $this->phpbb_root_path . $data['ext_path'];

- public function all_disabled()

- $disabled[$name] = $this->phpbb_root_path . $data['ext_path'];

- * added when add_log() is called.

- if ($log_time == false)

- 'user_id' => $user_id,

- 'log_ip' => $log_ip,

- * page call. When add_log is called and the type is disabled,

- * the log will not be added to the database.

- * @param string $mode The mode defines which log_type is used and from which log the entry is retrieved

- * @param int $user_id User ID of the user

- * @param string $log_ip IP address of the user

- * @param string $log_operation Name of the operation

- * @param int $log_time Timestamp when the log entry was added, if empty time() will be used

- * @param array $additional_data More arguments can be added, depending on the log_type

- $always_now = request_var('always_now', -1);

- $message = 'Illegal use of $' . $this->name . '. You must use the request class or request_var() to access input data. Found in %s on line %d. This error message was generated by deactivated_super_global.';

- set_config('fulltext_mysql_max_word_len', $mysql_info['ft_max_word_len']);

- set_config('fulltext_mysql_min_word_len', $mysql_info['ft_min_word_len']);

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

- * Initialises the fulltext_native search backend with min/max word length and makes sure the UTF-8 normalizer is loaded

- if (!class_exists('utf_normalizer'))

- {

- include($this->phpbb_root_path . 'includes/utf/utf_normalizer.' . $this->php_ext);

- }

- if ((strncmp($word, UTF8_HANGUL_FIRST, 3) < 0 || strncmp($word, UTF8_HANGUL_LAST, 3) > 0)

- && (strncmp($word, UTF8_CJK_FIRST, 3) < 0 || strncmp($word, UTF8_CJK_LAST, 3) > 0)

- && (strncmp($word, UTF8_CJK_B_FIRST, 4) < 0 || strncmp($word, UTF8_CJK_B_LAST, 4) > 0))

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

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

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

- *

- * @todo \normalizer::cleanup being able to be used?

- * Load the UTF-8 normalizer

- *

- * If we use it more widely, an instance of that class should be held in a

- * a global variable instead

- \utf_normalizer::nfc($text);

- if (($utf_char >= UTF8_HANGUL_FIRST && $utf_char <= UTF8_HANGUL_LAST)

- || ($utf_char >= UTF8_CJK_FIRST && $utf_char <= UTF8_CJK_LAST)

- || ($utf_char >= UTF8_CJK_B_FIRST && $utf_char <= UTF8_CJK_B_LAST))

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

- * @var \phpbb\db\tools

- // Initialize \phpbb\db\tools object

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

- set_config('fulltext_sphinx_id', unique_id());

- set_config('search_gc', 3600);

- add_log('critical', 'LOG_SPHINX_ERROR', $this->sphinx->GetLastError());

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

- global $request, $phpbb_container;

- $this->cookie_data['u'] = request_var($config['cookie_name'] . '_u', 0, false, true);

- $this->cookie_data['k'] = request_var($config['cookie_name'] . '_k', '', false, true);

- $this->session_id = request_var($config['cookie_name'] . '_sid', '', false, true);

- $this->session_id = $_SID = request_var('sid', '');

- $this->session_id = $_SID = request_var('sid', '');

- set_config('limit_load', '0');

- set_config('limit_search_load', '0');

- add_log('critical', 'LOG_IP_BROWSER_FORWARDED_CHECK', $u_ip, $s_ip, $u_browser, $s_browser, htmlspecialchars($u_forwarded_for), htmlspecialchars($s_forwarded_for));

- add_log('critical', 'LOG_REFERER_INVALID', $this->referer);

- set_config('session_last_gc', $this->time_now, true);

- public function __construct($phpbb_config, \phpbb\path_helper $path_helper, \phpbb\extension\manager $extension_manager = null, \Twig_LoaderInterface $loader = null, $options = array())

- // LA_ is transformed into lang(\'$1\')|addslashes, so we should not

- // Replace all of our escaped language variables, {LA_VARNAME}, with Twig style, {{ lang('NAME')|addslashes }}

- // Appends any filters after lang(), but before addslashes

- $code = preg_replace('#{LA_([a-zA-Z0-9_\.]+)(\|[^}]+?)?}#', '{{ lang(\'$1\')$2|addslashes }}', $code);

- public function __construct(\phpbb\path_helper $path_helper, $config, $user, \phpbb\template\context $context, \phpbb\extension\manager $extension_manager = null)