+ 'avatar_path' => array('lang' => 'AVATAR_STORAGE_PATH', 'validate' => 'rpath', 'type' => 'text:20:255', 'explain' => true),

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2014 phpBB Group

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

+*

+*/

+namespace phpbb\console\command\cache;

+

+use Symfony\Component\Console\Input\InputInterface;

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

+

+class purge extends \phpbb\console\command\command

+{

+ /** @var \phpbb\cache\driver\driver_interface */

+ protected $cache;

+

+ /** @var \phpbb\db\driver\driver_interface */

+ protected $db;

+

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

+ protected $auth;

+

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

+ protected $log;

+

+ /** @var \phpbb\user */

+ protected $user;

+

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

+ {

+ $this->cache = $cache;

+ $this->db = $db;

+ $this->auth = $auth;

+ $this->log = $log;

+ $this->user = $user;

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

+ parent::__construct();

+ }

+

+ protected function configure()

+ {

+ $this

+ ->setName('cache:purge')

+ ->setDescription('Purge the cache.')

+ ;

+ }

+

+ protected function execute(InputInterface $input, OutputInterface $output)

+ {

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

+

+ // Clear permissions

+ $this->auth->acl_clear_prefetch();

+ phpbb_cache_moderators($this->db, $this->cache, $this->auth);

+

+ $this->log->add('admin', ANONYMOUS, '', 'LOG_PURGE_CACHE', time(), array());

+

+ $output->writeln($this->user->lang('PURGE_CACHE_SUCCESS'));

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2014 phpBB Group

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

+*

+*/

+namespace phpbb\console\command\db;

+

+use Symfony\Component\Console\Input\InputInterface;

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

+

+class migrate extends \phpbb\console\command\command

+{

+ /** @var \phpbb\db\migrator */

+ protected $migrator;

+

+ /** @var \phpbb\extension\manager */

+ protected $extension_manager;

+

+ /** @var \phpbb\config\config */

+ protected $config;

+

+ /** @var \phpbb\cache\service */

+ protected $cache;

+

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

+ protected $log;

+

+ /** @var \phpbb\user */

+ protected $user;

+

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

+ {

+ $this->migrator = $migrator;

+ $this->extension_manager = $extension_manager;

+ $this->config = $config;

+ $this->cache = $cache;

+ $this->log = $log;

+ $this->user = $user;

+ $this->user->add_lang(array('common', 'acp/common', 'install', 'migrator'));

+ parent::__construct();

+ }

+

+ protected function configure()

+ {

+ $this

+ ->setName('db:migrate')

+ ->setDescription('Updates the database by applying migrations.')

+ ;

+ }

+

+ protected function execute(InputInterface $input, OutputInterface $output)

+ {

+ $this->load_migrations();

+ $orig_version = $this->config['version'];

+ while (!$this->migrator->finished())

+ {

+ $migration_start_time = microtime(true);

+

+ try

+ {

+ $this->migrator->update();

+ }

+ catch (\phpbb\db\migration\exception $e)

+ {

+ $output->writeln('<error>' . $e->getLocalisedMessage($this->user) . '</error>');

+ $this->finalise_update();

+ return 1;

+ }

+

+ $migration_stop_time = microtime(true) - $migration_start_time;

+

+ $state = array_merge(

+ array(

+ 'migration_schema_done' => false,

+ 'migration_data_done' => false,

+ ),

+ $this->migrator->last_run_migration['state']

+ );

+

+ if (!empty($this->migrator->last_run_migration['effectively_installed']))

+ {

+ $msg = $this->user->lang('MIGRATION_EFFECTIVELY_INSTALLED', $this->migrator->last_run_migration['name']);

+ $output->writeln("<comment>$msg</comment>");

+ }

+ else if ($this->migrator->last_run_migration['task'] == 'process_data_step' && $state['migration_data_done'])

+ {

+ $msg = $this->user->lang('MIGRATION_DATA_DONE', $this->migrator->last_run_migration['name'], $migration_stop_time);

+ $output->writeln("<info>$msg</info>");

+ }

+ else if ($this->migrator->last_run_migration['task'] == 'process_data_step')

+ {

+ $output->writeln($this->user->lang('MIGRATION_DATA_IN_PROGRESS', $this->migrator->last_run_migration['name'], $migration_stop_time));

+ }

+ else if ($state['migration_schema_done'])

+ {

+ $msg = $this->user->lang('MIGRATION_SCHEMA_DONE', $this->migrator->last_run_migration['name'], $migration_stop_time);

+ $output->writeln("<info>$msg</info>");

+ }

+ }

+

+ if ($orig_version != $this->config['version'])

+ {

+ $this->log->add('admin', ANONYMOUS, '', 'LOG_UPDATE_DATABASE', time(), array($orig_version, $this->config['version']));

+ }

+

+ $this->finalise_update();

+ $output->writeln($this->user->lang['DATABASE_UPDATE_COMPLETE']);

+ }

+

+ protected function load_migrations()

+ {

+ $migrations = $this->extension_manager

+ ->get_finder()

+ ->core_path('phpbb/db/migration/data/')

+ ->extension_directory('/migrations')

+ ->get_classes();

+ $this->migrator->set_migrations($migrations);

+ }

+

+ protected function finalise_update()

+ {

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

+ $this->config->increment('assets_version', 1);

+ }

+}

+ * @param $visibility int Element of {ITEM_APPROVED, ITEM_DELETED, ITEM_REAPPROVE}

+ * @param $reason string Reason why the visibility was changed.

+ * @return array Changed post data, empty array if an error occurred.

+ if (!in_array($visibility, array(ITEM_APPROVED, ITEM_DELETED, ITEM_REAPPROVE)))

+ if (in_array($visibility, array(ITEM_REAPPROVE, ITEM_DELETED)))

+ $field_alias = array(

+ ITEM_APPROVED => 'posts_approved',

+ ITEM_UNAPPROVED => 'posts_unapproved',

+ ITEM_DELETED => 'posts_softdeleted',

+ ITEM_REAPPROVE => 'posts_unapproved',

+ );

+ $cur_posts = array_fill_keys($field_alias, 0);

+

+ $cur_posts[$field_alias[(int) $post_visibility]] += $visibility_posts;

+ $recipient_field = $field_alias[$visibility];

+

+ foreach ($cur_posts as $field => $count)

+ // Decrease the count for the old statuses.

+ if ($count && $field != $recipient_field)

+ $sql_ary[$field] = " - $count";

+ // Add up the count from all statuses excluding the recipient status.

+ $count_increase = array_sum(array_diff($cur_posts, array($recipient_field)));

+

+ if ($count_increase)

+ $sql_ary[$recipient_field] = " + $count_increase";

+ * @param $visibility int Element of {ITEM_APPROVED, ITEM_DELETED, ITEM_REAPPROVE}

+ if (!in_array($visibility, array(ITEM_APPROVED, ITEM_DELETED, ITEM_REAPPROVE)))

+ // If we're soft deleting a topic we only mark approved posts as soft deleted.

+ * @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_root_path, $php_ext)

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

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

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

+ }

+ /**

+ * @param \phpbb\extension\finder $finder

+ * @return null

+ */

+ public function find_routing_files(\phpbb\extension\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()

+ ));

+<?php

+/**

+*

+* @package dbal

+* @copyright (c) 2014 phpBB Group

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

+*

+*/

+

+namespace phpbb\db\driver;

+

+/**

+* SQLite3 Database Abstraction Layer

+* Minimum Requirement: 3.6.15+

+* @package dbal

+*/

+class sqlite3 extends \phpbb\db\driver\driver

+{

+ /**

+ * @var string Stores errors during connection setup in case the driver is not available

+ */

+ protected $connect_error = '';

+

+ /**

+ * @var \SQLite3 The SQLite3 database object to operate against

+ */

+ protected $dbo = null;

+

+ /**

+ * {@inheritDoc}

+ */

+ public function sql_connect($sqlserver, $sqluser, $sqlpassword, $database, $port = false, $persistency = false, $new_link = false)

+ {

+ $this->persistency = false;

+ $this->user = $sqluser;

+ $this->server = $sqlserver . (($port) ? ':' . $port : '');

+ $this->dbname = $database;

+

+ if (!class_exists('SQLite3', false))

+ {

+ $this->connect_error = 'SQLite3 not found, is the extension installed?';

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

+ }

+

+ try

+ {

+ $this->dbo = new \SQLite3($this->server, SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE);

+ $this->db_connect_id = true;

+ }

+ catch (Exception $e)

+ {

+ return array('message' => $e->getMessage());

+ }

+

+ return true;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function sql_server_info($raw = false, $use_cache = true)

+ {

+ global $cache;

+

+ if (!$use_cache || empty($cache) || ($this->sql_server_version = $cache->get('sqlite_version')) === false)

+ {

+ $version = \SQLite3::version();

+

+ $this->sql_server_version = $version['versionString'];

+

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

+ {

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

+ }

+ }

+

+ return ($raw) ? $this->sql_server_version : 'SQLite ' . $this->sql_server_version;

+ }

+

+ /**

+ * SQL Transaction

+ *

+ * @param string $status Should be one of the following strings:

+ * begin, commit, rollback

+ * @return bool Success/failure of the transaction query

+ */

+ protected function _sql_transaction($status = 'begin')

+ {

+ switch ($status)

+ {

+ case 'begin':

+ return $this->dbo->exec('BEGIN IMMEDIATE');

+ break;

+

+ case 'commit':

+ return $this->dbo->exec('COMMIT');

+ break;

+

+ case 'rollback':

+ return $this->dbo->exec('ROLLBACK');

+ break;

+ }

+

+ return true;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function sql_query($query = '', $cache_ttl = 0)

+ {

+ if ($query != '')

+ {

+ global $cache;

+

+ // EXPLAIN only in extra debug mode

+ if (defined('DEBUG'))

+ {

+ $this->sql_report('start', $query);

+ }

+

+ $this->last_query_text = $query;

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

+ $this->sql_add_num_queries($this->query_result);

+

+ if ($this->query_result === false)

+ {

+ if (($this->query_result = @$this->dbo->query($query)) === false)

+ {

+ $this->sql_error($query);

+ }

+

+ if (defined('DEBUG'))

+ {

+ $this->sql_report('stop', $query);

+ }

+

+ if ($cache && $cache_ttl)

+ {

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

+ }

+ }

+ else if (defined('DEBUG'))

+ {

+ $this->sql_report('fromcache', $query);

+ }

+ }

+ else

+ {

+ return false;

+ }

+

+ return $this->query_result;

+ }

+

+ /**

+ * Build LIMIT query

+ *

+ * @param string $query The SQL query to execute

+ * @param int $total The number of rows to select

+ * @param int $offset

+ * @param int $cache_ttl Either 0 to avoid caching or

+ * the time in seconds which the result shall be kept in cache

+ * @return mixed Buffered, seekable result handle, false on error

+ */

+ protected function _sql_query_limit($query, $total, $offset = 0, $cache_ttl = 0)

+ {

+ $this->query_result = false;

+

+ // if $total is set to 0 we do not want to limit the number of rows

+ if ($total == 0)

+ {

+ $total = -1;

+ }

+

+ $query .= "\n LIMIT " . ((!empty($offset)) ? $offset . ', ' . $total : $total);

+

+ return $this->sql_query($query, $cache_ttl);

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function sql_affectedrows()

+ {

+ return ($this->db_connect_id) ? $this->dbo->changes() : false;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function sql_fetchrow($query_id = false)

+ {

+ global $cache;

+

+ if ($query_id === false)

+ {

+ $query_id = $this->query_result;

+ }

+

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

+ {

+ return $cache->sql_fetchrow($query_id);

+ }

+

+ return is_object($query_id) ? $query_id->fetchArray(SQLITE3_ASSOC) : false;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function sql_nextid()

+ {

+ return ($this->db_connect_id) ? $this->dbo->lastInsertRowID() : false;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function sql_freeresult($query_id = false)

+ {

+ global $cache;

+

+ if ($query_id === false)

+ {

+ $query_id = $this->query_result;

+ }

+

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

+ {

+ return $cache->sql_freeresult($query_id);

+ }

+

+ if ($query_id)

+ {

+ return @$query_id->finalize();

+ }

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function sql_escape($msg)

+ {

+ return \SQLite3::escapeString($msg);

+ }

+

+ /**

+ * {@inheritDoc}

+ *

+ * For SQLite an underscore is a not-known character...

+ */

+ public function sql_like_expression($expression)

+ {

+ // Unlike LIKE, GLOB is case sensitive (unfortunatly). SQLite users need to live with it!

+ // We only catch * and ? here, not the character map possible on file globbing.

+ $expression = str_replace(array(chr(0) . '_', chr(0) . '%'), array(chr(0) . '?', chr(0) . '*'), $expression);

+

+ $expression = str_replace(array('?', '*'), array("\?", "\*"), $expression);

+ $expression = str_replace(array(chr(0) . "\?", chr(0) . "\*"), array('?', '*'), $expression);

+

+ return 'GLOB \'' . $this->sql_escape($expression) . '\'';

+ }

+

+ /**

+ * return sql error array

+ *

+ * @return array

+ */

+ protected function _sql_error()

+ {

+ if (class_exists('SQLite3', false))

+ {

+ $error = array(

+ 'message' => $this->dbo->lastErrorMsg(),

+ 'code' => $this->dbo->lastErrorCode(),

+ );

+ }

+ else

+ {

+ $error = array(

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

+ 'code' => '',

+ );

+ }

+

+ return $error;

+ }

+

+ /**

+ * Build db-specific query data

+ *

+ * @param string $stage Available stages: FROM, WHERE

+ * @param mixed $data A string containing the CROSS JOIN query or an array of WHERE clauses

+ *

+ * @return string The db-specific query fragment

+ */

+ protected function _sql_custom_build($stage, $data)

+ {

+ return $data;

+ }

+

+ /**

+ * Close sql connection

+ *

+ * @return bool False if failure

+ */

+ protected function _sql_close()

+ {

+ return $this->dbo->close();

+ }

+

+ /**

+ * Build db-specific report

+ *

+ * @param string $mode Available modes: display, start, stop,

+ * add_select_row, fromcache, record_fromcache

+ * @param string $query The Query that should be explained

+ * @return mixed Either a full HTML page, boolean or null

+ */

+ protected function _sql_report($mode, $query = '')

+ {

+ switch ($mode)

+ {

+ case 'start':

+

+ $explain_query = $query;

+ if (preg_match('/UPDATE ([a-z0-9_]+).*?WHERE(.*)/s', $query, $m))

+ {

+ $explain_query = 'SELECT * FROM ' . $m[1] . ' WHERE ' . $m[2];

+ }

+ else if (preg_match('/DELETE FROM ([a-z0-9_]+).*?WHERE(.*)/s', $query, $m))

+ {

+ $explain_query = 'SELECT * FROM ' . $m[1] . ' WHERE ' . $m[2];

+ }

+

+ if (preg_match('/^SELECT/', $explain_query))

+ {

+ $html_table = false;

+

+ if ($result = $this->dbo->query("EXPLAIN QUERY PLAN $explain_query"))

+ {

+ while ($row = $result->fetchArray(SQLITE3_ASSOC))

+ {

+ $html_table = $this->sql_report('add_select_row', $query, $html_table, $row);

+ }

+ }

+

+ if ($html_table)

+ {

+ $this->html_hold .= '</table>';

+ }

+ }

+

+ break;

+

+ case 'fromcache':

+ $endtime = explode(' ', microtime());

+ $endtime = $endtime[0] + $endtime[1];

+

+ $result = $this->dbo->query($query);

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

+ {

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

+ }

+

+ $splittime = explode(' ', microtime());

+ $splittime = $splittime[0] + $splittime[1];

+

+ $this->sql_report('record_fromcache', $query, $endtime, $splittime);

+

+ break;

+ }

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

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

+*

+*/

+

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

+

+class beta3 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

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

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

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

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

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

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

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

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

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

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

+*

+*/

+

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

+

+class board_contact_name extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return isset($this->config['board_contact_name']);

+ }

+

+ static public function depends_on()

+ {

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

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('board_contact_name', '')),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

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

+*

+*/

+

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

+

+class live_searches_config extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return isset($this->config['allow_live_searches']);

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('allow_live_searches', '1')),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

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

+*

+*/

+

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

+

+/**

+* Class captcha_plugin

+*

+* Reset the captcha setting to the default plugin if the defined 'captcha_plugin' is missing.

+*/

+class reset_missing_captcha_plugin extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

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

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('if', array(

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

+ array('config.update', array('captcha_plugin', 'phpbb_captcha_nogd')),

+ )),

+ );

+ }

+}

+ public function update_timezones($start)

+ $start = (int) $start;

+ $limit = 500;

+ $converted = 0;

+

+ $update_blocks = array();

+ $sql = 'SELECT user_id, user_timezone, user_dst

+ FROM ' . $this->table_prefix . 'users

+ ORDER BY user_id ASC';

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

+ $converted++;

+

+ // In case this is somehow run twice on a row.

+ // Otherwise it would just end up as UTC on the second run

+ if (is_numeric($row['user_timezone']))

+ {

+ $update_blocks[$row['user_timezone'] . ':' . $row['user_dst']][] = (int) $row['user_id'];

+ }

+ }

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

+

+ // Update blocks of users who share the same timezone/dst

+ foreach ($update_blocks as $timezone => $user_ids)

+ {

+ $timezone = explode(':', $timezone);

+ $converted_timezone = $this->convert_phpbb30_timezone($timezone[0], $timezone[1]);

+

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

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

+

+ if ($converted == $limit)

+ {

+ // There are still more to convert

+ return $start + $limit;

+ }

+ if ($reverse)

+ {

+ return false;

+ }

+ else

+ {

+ return array(

+ $parameters[0],

+ array($last_result),

+ );

+ }

+ 'sqlite3' => array(

+ 'INT:' => 'INT(%d)',

+ 'BINT' => 'BIGINT(20)',

+ 'UINT' => 'INTEGER UNSIGNED',

+ 'UINT:' => 'INTEGER UNSIGNED',

+ 'TINT:' => 'TINYINT(%d)',

+ 'USINT' => 'INTEGER UNSIGNED',

+ 'BOOL' => 'INTEGER UNSIGNED',

+ 'VCHAR' => 'VARCHAR(255)',

+ 'VCHAR:' => 'VARCHAR(%d)',

+ 'CHAR:' => 'CHAR(%d)',

+ 'XSTEXT' => 'TEXT(65535)',

+ 'STEXT' => 'TEXT(65535)',

+ 'TEXT' => 'TEXT(65535)',

+ 'MTEXT' => 'MEDIUMTEXT(16777215)',

+ 'XSTEXT_UNI'=> 'TEXT(65535)',

+ 'STEXT_UNI' => 'TEXT(65535)',

+ 'TEXT_UNI' => 'TEXT(65535)',

+ 'MTEXT_UNI' => 'MEDIUMTEXT(16777215)',

+ 'TIMESTAMP' => 'INTEGER UNSIGNED', //'int(11) 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(255)',

+ 'VARBINARY' => 'BLOB',

+ ),

+

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

+ case 'sqlite3':

+ $sql = 'SELECT name

+ FROM sqlite_master

+ WHERE type = "table"

+ AND name <> "sqlite_sequence"';

+ break;

+

+ case 'sqlite3':

+ case 'sqlite3':

+ if (($this->db->sql_layer == 'sqlite' || $this->db->sql_layer == 'sqlite3') && $this->return_statements)

+ case 'sqlite3':

+ case 'sqlite3':

+ case 'sqlite3':

+ case 'sqlite3':

+ if (($this->sql_layer == 'sqlite' || $this->sql_layer == 'sqlite3') && !$row['unique'])

+ case 'sqlite3':

+ case 'sqlite3':

+

+ if ($this->sql_layer === 'sqlite3')

+ {

+ $sql .= ' AUTOINCREMENT';

+ }

+ $recreate_queries = $this->sqlite_get_recreate_table_queries($table_name);

+ if (empty($recreate_queries))

+ break;

+ }

+ $statements[] = 'begin';

+ $sql_create_table = array_shift($recreate_queries);

+ // Create a backup table and populate it, destroy the existing one

+ $statements[] = preg_replace('#CREATE\s+TABLE\s+"?' . $table_name . '"?#i', 'CREATE TEMPORARY TABLE ' . $table_name . '_temp', $sql_create_table);

+ $statements[] = 'INSERT INTO ' . $table_name . '_temp SELECT * FROM ' . $table_name;

+ $statements[] = 'DROP TABLE ' . $table_name;

+ preg_match('#\((.*)\)#s', $sql_create_table, $matches);

+ $new_table_cols = trim($matches[1]);

+ $old_table_cols = preg_split('/,(?![\s\w]+\))/m', $new_table_cols);

+ $column_list = array();

+ foreach ($old_table_cols as $declaration)

+ {

+ $entities = preg_split('#\s+#', trim($declaration));

+ if ($entities[0] == 'PRIMARY')

+ continue;

+ $column_list[] = $entities[0];

+ }

+ $columns = implode(',', $column_list);

+ $new_table_cols = $column_name . ' ' . $column_data['column_type_sql'] . ',' . $new_table_cols;

+ // create a new table and fill it up. destroy the temp one

+ $statements[] = 'CREATE TABLE ' . $table_name . ' (' . $new_table_cols . ');';

+ $statements = array_merge($statements, $recreate_queries);

+ $statements[] = 'INSERT INTO ' . $table_name . ' (' . $columns . ') SELECT ' . $columns . ' FROM ' . $table_name . '_temp;';

+ $statements[] = 'DROP TABLE ' . $table_name . '_temp';

+

+ $statements[] = 'commit';

+ break;

+

+ case 'sqlite3':

+ if ($inline && $this->return_statements)

+ return $column_name . ' ' . $column_data['column_type_sql'];

+

+ $statements[] = 'ALTER TABLE ' . $table_name . ' ADD ' . $column_name . ' ' . $column_data['column_type_sql'];

+ case 'sqlite3':

+ $recreate_queries = $this->sqlite_get_recreate_table_queries($table_name, $column_name);

+ if (empty($recreate_queries))

+ break;

+ }

+ $statements[] = 'begin';

+ $sql_create_table = array_shift($recreate_queries);

+ // Create a backup table and populate it, destroy the existing one

+ $statements[] = preg_replace('#CREATE\s+TABLE\s+"?' . $table_name . '"?#i', 'CREATE TEMPORARY TABLE ' . $table_name . '_temp', $sql_create_table);

+ $statements[] = 'INSERT INTO ' . $table_name . '_temp SELECT * FROM ' . $table_name;

+ $statements[] = 'DROP TABLE ' . $table_name;

+ preg_match('#\((.*)\)#s', $sql_create_table, $matches);

+ $new_table_cols = trim($matches[1]);

+ $old_table_cols = preg_split('/,(?![\s\w]+\))/m', $new_table_cols);

+ $column_list = array();

+ foreach ($old_table_cols as $declaration)

+ {

+ $entities = preg_split('#\s+#', trim($declaration));

+ if ($entities[0] == 'PRIMARY' || $entities[0] === $column_name)

+ continue;

+ $column_list[] = $entities[0];

+ }

+ $columns = implode(',', $column_list);

+ $new_table_cols = trim(preg_replace('/' . $column_name . '[^,]+(?:,|$)/m', '', $new_table_cols));

+ if (substr($new_table_cols, -1) === ',')

+ // Remove the comma from the last entry again

+ $new_table_cols = substr($new_table_cols, 0, -1);

+

+ // create a new table and fill it up. destroy the temp one

+ $statements[] = 'CREATE TABLE ' . $table_name . ' (' . $new_table_cols . ');';

+ $statements = array_merge($statements, $recreate_queries);

+

+ $statements[] = 'INSERT INTO ' . $table_name . ' (' . $columns . ') SELECT ' . $columns . ' FROM ' . $table_name . '_temp;';

+ $statements[] = 'DROP TABLE ' . $table_name . '_temp';

+

+ $statements[] = 'commit';

+ case 'sqlite3':

+ case 'sqlite3':

+ $recreate_queries = $this->sqlite_get_recreate_table_queries($table_name);

+ if (empty($recreate_queries))

+ $sql_create_table = array_shift($recreate_queries);

+

+ $statements[] = preg_replace('#CREATE\s+TABLE\s+"?' . $table_name . '"?#i', 'CREATE TEMPORARY TABLE ' . $table_name . '_temp', $sql_create_table);

+ preg_match('#\((.*)\)#s', $sql_create_table, $matches);

+ $statements = array_merge($statements, $recreate_queries);

+

+ case 'sqlite3':

+ case 'sqlite3':

+ case 'sqlite3':

+ case 'sqlite3':

+ case 'sqlite3':

+ $recreate_queries = $this->sqlite_get_recreate_table_queries($table_name);

+ if (empty($recreate_queries))

+ $sql_create_table = array_shift($recreate_queries);

+

+ $statements[] = preg_replace('#CREATE\s+TABLE\s+"?' . $table_name . '"?#i', 'CREATE TEMPORARY TABLE ' . $table_name . '_temp', $sql_create_table);

+ preg_match('#\((.*)\)#s', $sql_create_table, $matches);

+ // Create a new table and fill it up. destroy the temp one

+ $statements = array_merge($statements, $recreate_queries);

+

+

+ /**

+ * Returns the Queries which are required to recreate a table including indexes

+ *

+ * @param string $table_name

+ * @param string $remove_column When we drop a column, we remove the column

+ * from all indexes. If the index has no other

+ * column, we drop it completly.

+ * @return array

+ */

+ protected function sqlite_get_recreate_table_queries($table_name, $remove_column = '')

+ {

+ $queries = array();

+

+ $sql = "SELECT sql

+ FROM sqlite_master

+ WHERE type = 'table'

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

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

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

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

+

+ if (!$sql_create_table)

+ {

+ return array();

+ }

+ $queries[] = $sql_create_table;

+

+ $sql = "SELECT sql

+ FROM sqlite_master

+ WHERE type = 'index'

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

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

+ while ($sql_create_index = $this->db->sql_fetchfield('sql'))

+ {

+ if ($remove_column)

+ {

+ $match = array();

+ preg_match('#(?:[\w ]+)\((.*)\)#', $sql_create_index, $match);

+ if (!isset($match[1]))

+ {

+ continue;

+ }

+

+ // Find and remove $remove_column from the index

+ $columns = explode(', ', $match[1]);

+ $found_column = array_search($remove_column, $columns);

+ if ($found_column !== false)

+ {

+ unset($columns[$found_column]);

+

+ // If the column list is not empty add the index to the list

+ if (!empty($columns))

+ {

+ $queries[] = str_replace($match[1], implode(', ', $columns), $sql_create_index);

+ }

+ }

+ else

+ {

+ $queries[] = $sql_create_index;

+ }

+ }

+ else

+ {

+ $queries[] = $sql_create_index;

+ }

+ }

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

+

+ return $queries;

+ }

+ * Extension manager object

+ * @var \phpbb\extension\manager

+ protected $manager;

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

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

+ $this->manager = $manager;

+ * @throws \BadMethodCallException

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

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2014 phpBB Group

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

+*

+*/

+

+namespace phpbb\event;

+

+/**

+* Class md_exporter

+* Crawls through a markdown file and grabs all events

+*

+* @package phpbb\event

+*/

+class md_exporter

+{

+ /** @var string Path where we look for files*/

+ protected $path;

+

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

+ protected $root_path;

+

+ /** @var string */

+ protected $filter;

+

+ /** @var string */

+ protected $current_event;

+

+ /** @var array */

+ protected $events;

+

+ /**

+ * @param string $phpbb_root_path

+ * @param mixed $extension String 'vendor/ext' to filter, null for phpBB core

+ */

+ public function __construct($phpbb_root_path, $extension = null)

+ {

+ $this->root_path = $phpbb_root_path;

+ $this->path = $this->root_path;

+ if ($extension)

+ {

+ $this->path .= 'ext/' . $extension . '/';

+ }

+

+ $this->events = array();

+ $this->events_by_file = array();

+ $this->filter = $this->current_event = '';

+ }

+

+ /**

+ * Get the list of all events

+ *

+ * @return array Array with events: name => details

+ */

+ public function get_events()

+ {

+ return $this->events;

+ }

+

+ /**

+ * @param string $md_file Relative from phpBB root

+ * @return int Number of events found

+ * @throws \LogicException

+ */

+ public function crawl_phpbb_directory_adm($md_file)

+ {

+ $this->crawl_eventsmd($md_file, 'adm');

+

+ $file_list = $this->get_recursive_file_list($this->path . 'adm/style/');

+ foreach ($file_list as $file)

+ {

+ $file_name = 'adm/style/' . $file;

+ $this->validate_events_from_file($file_name, $this->crawl_file_for_events($file_name));

+ }

+

+ return sizeof($this->events);

+ }

+

+ /**

+ * @param string $md_file Relative from phpBB root

+ * @return int Number of events found

+ * @throws \LogicException

+ */

+ public function crawl_phpbb_directory_styles($md_file)

+ {

+ $this->crawl_eventsmd($md_file, 'styles');

+

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

+ foreach ($styles as $style)

+ {

+ $file_list = $this->get_recursive_file_list(

+ $this->path . 'styles/' . $style . '/template/'

+ );

+

+ foreach ($file_list as $file)

+ {

+ $file_name = 'styles/' . $style . '/template/' . $file;

+ $this->validate_events_from_file($file_name, $this->crawl_file_for_events($file_name));

+ }

+ }

+

+ return sizeof($this->events);

+ }

+

+ /**

+ * @param string $md_file Relative from phpBB root

+ * @param string $filter Should be 'styles' or 'adm'

+ * @return int Number of events found

+ * @throws \LogicException

+ */

+ public function crawl_eventsmd($md_file, $filter)

+ {

+ if (!file_exists($this->path . $md_file))

+ {

+ throw new \LogicException("The event docs file '{$md_file}' could not be found");

+ }

+

+ $file_content = file_get_contents($this->path . $md_file);

+ $this->filter = $filter;

+

+ $events = explode("\n\n", $file_content);

+ foreach ($events as $event)

+ {

+ // Last row of the file

+ if (strpos($event, "\n===\n") === false)

+ {

+ continue;

+ }

+

+ list($event_name, $details) = explode("\n===\n", $event, 2);

+ $this->validate_event_name($event_name);

+ $this->current_event = $event_name;

+

+ if (isset($this->events[$this->current_event]))

+ {

+ throw new \LogicException("The event '{$this->current_event}' is defined multiple times");

+ }

+

+ if (($this->filter == 'adm' && strpos($this->current_event, 'acp_') !== 0)

+ || ($this->filter == 'styles' && strpos($this->current_event, 'acp_') === 0))

+ {

+ continue;

+ }

+

+ list($file_details, $details) = explode("\n* Since: ", $details, 2);

+ list($since, $description) = explode("\n* Purpose: ", $details, 2);

+

+ $files = $this->validate_file_list($file_details);

+ $since = $this->validate_since($since);

+

+ $this->events[$event_name] = array(

+ 'event' => $this->current_event,

+ 'files' => $files,

+ 'since' => $since,

+ 'description' => $description,

+ );

+ }

+

+ return sizeof($this->events);

+ }

+

+ /**

+ * Format the php events as a wiki table

+ * @return string Number of events found

+ */

+ public function export_events_for_wiki()

+ {

+ if ($this->filter === 'adm')

+ {

+ $wiki_page = '= ACP Template Events =' . "\n";

+ $wiki_page .= '{| class="zebra sortable" cellspacing="0" cellpadding="5"' . "\n";

+ $wiki_page .= '! Identifier !! Placement !! Added in Release !! Explanation' . "\n";

+ }

+ else

+ {

+ $wiki_page = '= Template Events =' . "\n";

+ $wiki_page .= '{| class="zebra sortable" cellspacing="0" cellpadding="5"' . "\n";

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

+ }

+

+ foreach ($this->events as $event_name => $event)

+ {

+ $wiki_page .= "|- id=\"{$event_name}\"\n";

+ $wiki_page .= "| [[#{$event_name}|{$event_name}]] || ";

+

+ if ($this->filter === 'adm')

+ {

+ $wiki_page .= implode(', ', $event['files']['adm']);

+ }

+ else

+ {

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

+ }

+

+ $wiki_page .= " || {$event['since']} || " . str_replace("\n", ' ', $event['description']) . "\n";

+ }

+ $wiki_page .= '|}' . "\n";

+

+ return $wiki_page;

+ }

+

+ /**

+ * Validates a template event name

+ *

+ * @param $event_name

+ * @return null

+ * @throws \LogicException

+ */

+ public function validate_event_name($event_name)

+ {

+ if (!preg_match('#^([a-z][a-z0-9]*(?:_[a-z][a-z0-9]*)+)$#', $event_name))

+ {

+ throw new \LogicException("Invalid event name '{$event_name}'");

+ }

+ }

+

+ /**

+ * Validate "Since" Information

+ *

+ * @param string $since

+ * @return string

+ * @throws \LogicException

+ */

+ public function validate_since($since)

+ {

+ if (!preg_match('#^\d+\.\d+\.\d+(?:-(?:a|b|rc|pl)\d+)?$#', $since))

+ {

+ throw new \LogicException("Invalid since information found for event '{$this->current_event}'");

+ }

+

+ return $since;

+ }

+

+ /**

+ * Validate the files list

+ *

+ * @param string $file_details

+ * @return array

+ * @throws \LogicException

+ */

+ public function validate_file_list($file_details)

+ {

+ $files_list = array(

+ 'prosilver' => array(),

+ 'subsilver2' => array(),

+ 'adm' => array(),

+ );

+

+ // Multi file list

+ if (strpos($file_details, "* Locations:\n + ") === 0)

+ {

+ $file_details = substr($file_details, strlen("* Locations:\n + "));

+ $files = explode("\n + ", $file_details);

+ foreach ($files as $file)

+ {

+ if (!file_exists($this->path . $file) || substr($file, -5) !== '.html')

+ {

+ throw new \LogicException("Invalid file '{$file}' not found for event '{$this->current_event}'", 1);

+ }

+

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

+ {

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

+ }

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

+ {

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

+ }

+ else if (($this->filter === 'adm') && strpos($file, 'adm/style/') === 0)

+ {

+ $files_list['adm'][] = substr($file, strlen('adm/style/'));

+ }

+ else

+ {

+ throw new \LogicException("Invalid file '{$file}' not found for event '{$this->current_event}'", 2);

+ }

+

+ $this->events_by_file[$file][] = $this->current_event;

+ }

+ }

+ else if ($this->filter == 'adm')

+ {

+ $file = substr($file_details, strlen('* Location: '));

+ if (!file_exists($this->path . $file) || substr($file, -5) !== '.html')

+ {

+ throw new \LogicException("Invalid file '{$file}' not found for event '{$this->current_event}'", 1);

+ }

+

+ $files_list['adm'][] = substr($file, strlen('adm/style/'));

+

+ $this->events_by_file[$file][] = $this->current_event;

+ }

+ else

+ {

+ throw new \LogicException("Invalid file list found for event '{$this->current_event}'", 2);

+ }

+

+ return $files_list;

+ }

+

+ /**

+ * Get all template events in a template file

+ *

+ * @param string $file

+ * @return array

+ * @throws \LogicException

+ */

+ public function crawl_file_for_events($file)

+ {

+ if (!file_exists($this->path . $file))

+ {

+ throw new \LogicException("File '{$file}' does not exist", 1);

+ }

+

+ $event_list = array();

+ $file_content = file_get_contents($this->path . $file);

+

+ $events = explode('<!-- EVENT ', $file_content);

+ // Remove the code before the first event

+ array_shift($events);

+ foreach ($events as $event)

+ {

+ $event = explode(' -->', $event, 2);

+ $event_list[] = array_shift($event);

+ }

+

+ return $event_list;

+ }

+

+ /**

+ * Validates whether all events from $file are in the md file and vice-versa

+ *

+ * @param string $file

+ * @param array $events

+ * @return true

+ * @throws \LogicException

+ */

+ public function validate_events_from_file($file, array $events)

+ {

+ if (empty($this->events_by_file[$file]) && empty($events))

+ {

+ return true;

+ }

+ else if (empty($this->events_by_file[$file]))

+ {

+ $event_list = implode("', '", $events);

+ throw new \LogicException("File '{$file}' should not contain events, but contains: "

+ . "'{$event_list}'", 1);

+ }

+ else if (empty($events))

+ {

+ $event_list = implode("', '", $this->events_by_file[$file]);

+ throw new \LogicException("File '{$file}' contains no events, but should contain: "

+ . "'{$event_list}'", 1);

+ }

+

+ $missing_events_from_file = array();

+ foreach ($this->events_by_file[$file] as $event)

+ {

+ if (!in_array($event, $events))

+ {

+ $missing_events_from_file[] = $event;

+ }

+ }

+

+ if (!empty($missing_events_from_file))

+ {

+ $event_list = implode("', '", $missing_events_from_file);

+ throw new \LogicException("File '{$file}' does not contain events: '{$event_list}'", 2);

+ }

+

+ $missing_events_from_md = array();

+ foreach ($events as $event)

+ {

+ if (!in_array($event, $this->events_by_file[$file]))

+ {

+ $missing_events_from_md[] = $event;

+ }

+ }

+

+ if (!empty($missing_events_from_md))

+ {

+ $event_list = implode("', '", $missing_events_from_md);

+ throw new \LogicException("File '{$file}' contains additional events: '{$event_list}'", 3);

+ }

+

+ return true;

+ }

+

+ /**

+ * Returns a list of files in $dir

+ *

+ * Works recursive with any depth

+ *

+ * @param string $dir Directory to go through

+ * @return array List of files (including directories)

+ */

+ public function get_recursive_file_list($dir)

+ {

+ try

+ {

+ $iterator = new \RecursiveIteratorIterator(

+ new \phpbb\recursive_dot_prefix_filter_iterator(

+ new \RecursiveDirectoryIterator(

+ $dir,

+ \FilesystemIterator::SKIP_DOTS

+ )

+ ),

+ \RecursiveIteratorIterator::SELF_FIRST

+ );

+ }

+ catch (\Exception $e)

+ {

+ return array();

+ }

+

+ $files = array();

+ foreach ($iterator as $file_info)

+ {

+ /** @var \RecursiveDirectoryIterator $file_info */

+ if ($file_info->isDir())

+ {

+ continue;

+ }

+

+ $relative_path = $iterator->getInnerIterator()->getSubPathname();

+

+ if (substr($relative_path, -5) == '.html')

+ {

+ $files[] = str_replace(DIRECTORY_SEPARATOR, '/', $relative_path);

+ }

+ }

+

+ return $files;

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2014 phpBB Group

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

+*

+*/

+

+namespace phpbb\event;

+

+/**

+* Class php_exporter

+* Crawls through a list of files and grabs all php-events

+*

+* @package phpbb\event

+*/

+class php_exporter

+{

+ /** @var string Path where we look for files*/

+ protected $path;

+

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

+ protected $root_path;

+

+ /** @var string */

+ protected $current_file;

+

+ /** @var string */

+ protected $current_event;

+

+ /** @var int */

+ protected $current_event_line;

+

+ /** @var array */

+ protected $events;

+

+ /** @var array */

+ protected $file_lines;

+

+ /**

+ * @param string $phpbb_root_path

+ * @param mixed $extension String 'vendor/ext' to filter, null for phpBB core

+ */

+ public function __construct($phpbb_root_path, $extension = null)

+ {

+ $this->root_path = $phpbb_root_path;

+ $this->path = $phpbb_root_path;

+ $this->events = $this->file_lines = array();

+ $this->current_file = $this->current_event = '';

+ $this->current_event_line = 0;

+

+ $this->path = $this->root_path;

+ if ($extension)

+ {

+ $this->path .= 'ext/' . $extension . '/';

+ }

+ }

+

+ /**

+ * Get the list of all events

+ *

+ * @return array Array with events: name => details

+ */

+ public function get_events()

+ {

+ return $this->events;

+ }

+

+ /**

+ * Set current event data

+ *

+ * @param string $name Name of the current event (used for error messages)

+ * @param int $line Line where the current event is placed in

+ * @return null

+ */

+ public function set_current_event($name, $line)

+ {

+ $this->current_event = $name;

+ $this->current_event_line = $line;

+ }

+

+ /**

+ * Set the content of this file

+ *

+ * @param array $content Array with the lines of the file

+ * @return null

+ */

+ public function set_content($content)

+ {

+ $this->file_lines = $content;

+ }

+

+ /**

+ * Crawl the phpBB/ directory for php events

+ * @return int The number of events found

+ */

+ public function crawl_phpbb_directory_php()

+ {

+ $files = $this->get_recursive_file_list();

+ $this->events = array();

+ foreach ($files as $file)

+ {

+ $this->crawl_php_file($file);

+ }

+ ksort($this->events);

+

+ return sizeof($this->events);

+ }

+

+ /**

+ * Returns a list of files in $dir

+ *

+ * @return array List of files (including the path)

+ */

+ public function get_recursive_file_list()

+ {

+ try

+ {

+ $iterator = new \RecursiveIteratorIterator(

+ new \phpbb\event\recursive_event_filter_iterator(

+ new \RecursiveDirectoryIterator(

+ $this->path,

+ \FilesystemIterator::SKIP_DOTS

+ ),

+ $this->path

+ ),

+ \RecursiveIteratorIterator::LEAVES_ONLY

+ );

+ }

+ catch (\Exception $e)

+ {

+ return array();

+ }

+

+ $files = array();

+ foreach ($iterator as $file_info)

+ {

+ /** @var \RecursiveDirectoryIterator $file_info */

+ $relative_path = $iterator->getInnerIterator()->getSubPathname();

+ $files[] = str_replace(DIRECTORY_SEPARATOR, '/', $relative_path);

+ }

+

+ return $files;

+ }

+

+ /**

+ * Format the php events as a wiki table

+ * @return string

+ */

+ public function export_events_for_wiki()

+ {

+ $wiki_page = '= PHP Events (Hook Locations) =' . "\n";

+ $wiki_page .= '{| class="sortable zebra" cellspacing="0" cellpadding="5"' . "\n";

+ $wiki_page .= '! Identifier !! Placement !! Arguments !! Added in Release !! Explanation' . "\n";

+ foreach ($this->events as $event)

+ {

+ $wiki_page .= '|- id="' . $event['event'] . '"' . "\n";

+ $wiki_page .= '| [[#' . $event['event'] . '|' . $event['event'] . ']] || ' . $event['file'] . ' || ' . implode(', ', $event['arguments']) . ' || ' . $event['since'] . ' || ' . $event['description'] . "\n";

+ }

+ $wiki_page .= '|}' . "\n";

+

+ return $wiki_page;

+ }

+

+ /**

+ * @param string $file

+ * @return int Number of events found in this file

+ * @throws \LogicException

+ */

+ public function crawl_php_file($file)

+ {

+ $this->current_file = $file;

+ $this->file_lines = array();

+ $content = file_get_contents($this->path . $this->current_file);

+ $num_events_found = 0;

+

+ if (strpos($content, "dispatcher->trigger_event('") || strpos($content, "dispatcher->dispatch('"))

+ {

+ $this->set_content(explode("\n", $content));

+ for ($i = 0, $num_lines = sizeof($this->file_lines); $i < $num_lines; $i++)

+ {

+ $event_line = false;

+ $found_trigger_event = strpos($this->file_lines[$i], "dispatcher->trigger_event('");

+ $arguments = array();

+ if ($found_trigger_event !== false)

+ {

+ $event_line = $i;

+ $this->set_current_event($this->get_event_name($event_line, false), $event_line);

+

+ // Find variables of the event

+ $arguments = $this->get_vars_from_array();

+ $doc_vars = $this->get_vars_from_docblock();

+ $this->validate_vars_docblock_array($arguments, $doc_vars);

+ }

+ else

+ {

+ $found_dispatch = strpos($this->file_lines[$i], "dispatcher->dispatch('");

+ if ($found_dispatch !== false)

+ {

+ $event_line = $i;

+ $this->set_current_event($this->get_event_name($event_line, true), $event_line);

+ }

+ }

+

+ if ($event_line)

+ {

+ // Validate @event

+ $event_line_num = $this->find_event();

+ $this->validate_event($this->current_event, $this->file_lines[$event_line_num]);

+

+ // Validate @since

+ $since_line_num = $this->find_since();

+ $since = $this->validate_since($this->file_lines[$since_line_num]);

+

+ // Find event description line

+ $description_line_num = $this->find_description();

+ $description = substr(trim($this->file_lines[$description_line_num]), strlen('* '));

+

+ if (isset($this->events[$this->current_event]))

+ {

+ throw new \LogicException("The event '{$this->current_event}' from file "

+ . "'{$this->current_file}:{$event_line_num}' already exists in file "

+ . "'{$this->events[$this->current_event]['file']}'", 10);

+ }

+

+ sort($arguments);

+ $this->events[$this->current_event] = array(

+ 'event' => $this->current_event,

+ 'file' => $this->current_file,

+ 'arguments' => $arguments,

+ 'since' => $since,

+ 'description' => $description,

+ );

+ $num_events_found++;

+ }

+ }

+ }

+

+ return $num_events_found;

+ }

+

+ /**

+ * Find the name of the event inside the dispatch() line

+ *

+ * @param int $event_line

+ * @param bool $is_dispatch Do we look for dispatch() or trigger_event() ?

+ * @return string Name of the event

+ * @throws \LogicException

+ */

+ public function get_event_name($event_line, $is_dispatch)

+ {

+ $event_text_line = $this->file_lines[$event_line];

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

+

+ if ($is_dispatch)

+ {

+ $regex = '#\$([a-z](?:[a-z0-9_]|->)*)';

+ $regex .= '->dispatch\(';

+ $regex .= '\'' . $this->preg_match_event_name() . '\'';

+ $regex .= '\);#';

+ }

+ else

+ {

+ $regex = '#extract\(\$([a-z](?:[a-z0-9_]|->)*)';

+ $regex .= '->trigger_event\(';

+ $regex .= '\'' . $this->preg_match_event_name() . '\'';

+ $regex .= ', compact\(\$vars\)\)\);#';

+ }

+

+ $match = array();

+ preg_match($regex, $event_text_line, $match);

+ if (!isset($match[2]))

+ {

+ throw new \LogicException("Can not find event name in line '{$event_text_line}' "

+ . "in file '{$this->current_file}:{$event_line}'", 1);

+ }

+

+ return $match[2];

+ }

+

+ /**

+ * Returns a regex match for the event name

+ *

+ * @return string

+ */

+ protected function preg_match_event_name()

+ {

+ return '([a-z][a-z0-9_]*(?:\.[a-z][a-z0-9_]*)+)';

+ }

+

+ /**

+ * Find the $vars array

+ *

+ * @return array List of variables

+ * @throws \LogicException

+ */

+ public function get_vars_from_array()

+ {

+ $line = ltrim($this->file_lines[$this->current_event_line - 1], "\t");

+ if ($line === ');')

+ {

+ $vars_array = $this->get_vars_from_multi_line_array();

+ }

+ else

+ {

+ $vars_array = $this->get_vars_from_single_line_array($line);

+ }

+

+ foreach ($vars_array as $var)

+ {

+ if (!preg_match('#^([a-zA-Z_][a-zA-Z0-9_]*)$#', $var))

+ {

+ throw new \LogicException("Found invalid var '{$var}' in array for event '{$this->current_event}' in file '{$this->current_file}:{$this->current_event_line}'", 3);

+ }

+ }

+

+ sort($vars_array);

+ return $vars_array;

+ }

+

+ /**

+ * Find the variables in single line array

+ *

+ * @param string $line

+ * @param bool $throw_multiline Throw an exception when there are too

+ * many arguments in one line.

+ * @return array List of variables

+ * @throws \LogicException

+ */

+ public function get_vars_from_single_line_array($line, $throw_multiline = true)

+ {

+ $match = array();

+ preg_match('#^\$vars = array\(\'([a-zA-Z0-9_\' ,]+)\'\);$#', $line, $match);

+

+ if (isset($match[1]))

+ {

+ $vars_array = explode("', '", $match[1]);

+ if ($throw_multiline && sizeof($vars_array) > 6)

+ {

+ throw new \LogicException('Should use multiple lines for $vars definition '

+ . "for event '{$this->current_event}' in file '{$this->current_file}:{$this->current_event_line}'", 2);

+ }

+ return $vars_array;

+ }

+ else

+ {

+ throw new \LogicException("Can not find '\$vars = array();'-line for event '{$this->current_event}' in file '{$this->current_file}:{$this->current_event_line}'", 1);

+ }

+ }

+

+ /**

+ * Find the variables in single line array

+ *

+ * @return array List of variables

+ * @throws \LogicException

+ */

+ public function get_vars_from_multi_line_array()

+ {

+ $current_vars_line = 2;

+ $var_lines = array();

+ while (ltrim($this->file_lines[$this->current_event_line - $current_vars_line], "\t") !== '$vars = array(')

+ {

+ $var_lines[] = substr(trim($this->file_lines[$this->current_event_line - $current_vars_line]), 0, -1);

+

+ $current_vars_line++;

+ if ($current_vars_line > $this->current_event_line)

+ {

+ // Reached the start of the file

+ throw new \LogicException("Can not find end of \$vars array for event '{$this->current_event}' in file '{$this->current_file}:{$this->current_event_line}'", 2);

+ }

+ }

+

+ return $this->get_vars_from_single_line_array('$vars = array(' . implode(", ", $var_lines) . ');', false);

+ }

+

+ /**

+ * Find the $vars array

+ *

+ * @return array List of variables

+ * @throws \LogicException

+ */

+ public function get_vars_from_docblock()

+ {

+ $doc_vars = array();

+ $current_doc_line = 1;

+ $found_comment_end = false;

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

+ {

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

+ {

+ $found_comment_end = true;

+ }

+

+ if ($found_comment_end)

+ {

+ $var_line = trim($this->file_lines[$this->current_event_line - $current_doc_line]);

+ $var_line = preg_replace('!\s+!', ' ', $var_line);

+ if (strpos($var_line, '* @var ') === 0)

+ {

+ $doc_line = explode(' ', $var_line, 5);

+ if (sizeof($doc_line) !== 5)

+ {

+ throw new \LogicException("Found invalid line '{$this->file_lines[$this->current_event_line - $current_doc_line]}' "

+ . "for event '{$this->current_event}' in file '{$this->current_file}:{$this->current_event_line}'", 1);

+ }

+ $doc_vars[] = $doc_line[3];

+ }

+ }

+

+ $current_doc_line++;

+ if ($current_doc_line > $this->current_event_line)

+ {

+ // Reached the start of the file

+ throw new \LogicException("Can not find end of docblock for event '{$this->current_event}' in file '{$this->current_file}:{$this->current_event_line}'", 2);

+ }

+ }

+

+ if (empty($doc_vars))

+ {

+ // Reached the start of the file

+ throw new \LogicException("Can not find @var lines for event '{$this->current_event}' in file '{$this->current_file}:{$this->current_event_line}'", 3);

+ }

+

+ foreach ($doc_vars as $var)

+ {

+ if (!preg_match('#^([a-zA-Z_][a-zA-Z0-9_]*)$#', $var))

+ {

+ throw new \LogicException("Found invalid @var '{$var}' in docblock for event "

+ . "'{$this->current_event}' in file '{$this->current_file}:{$this->current_event_line}'", 4);

+ }

+ }

+

+ sort($doc_vars);

+ return $doc_vars;

+ }

+

+ /**

+ * Find the "@since" Information line

+ *

+ * @return int Absolute line number

+ * @throws \LogicException

+ */

+ public function find_since()

+ {

+ return $this->find_tag('since', array('event', 'var'));

+ }

+

+ /**

+ * Find the "@event" Information line

+ *

+ * @return int Absolute line number

+ */

+ public function find_event()

+ {

+ return $this->find_tag('event', array());

+ }

+

+ /**

+ * Find a "@*" Information line

+ *

+ * @param string $find_tag Name of the tag we are trying to find

+ * @param array $disallowed_tags List of tags that must not appear between

+ * the tag and the actual event

+ * @return int Absolute line number

+ * @throws \LogicException

+ */

+ public function find_tag($find_tag, $disallowed_tags)

+ {

+ $find_tag_line = 0;

+ $found_comment_end = false;

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

+ {

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

+ {

+ // Reached the start of this doc block

+ throw new \LogicException("Can not find '@{$find_tag}' information for event "

+ . "'{$this->current_event}' in file '{$this->current_file}:{$this->current_event_line}'", 1);

+ }

+

+ foreach ($disallowed_tags as $disallowed_tag)

+ {

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

+ {

+ // Found @var after the @since

+ throw new \LogicException("Found '@{$disallowed_tag}' information after '@{$find_tag}' for event "

+ . "'{$this->current_event}' in file '{$this->current_file}:{$this->current_event_line}'", 3);

+ }

+ }

+

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

+ {

+ $found_comment_end = true;

+ }

+

+ $find_tag_line++;

+ if ($find_tag_line >= $this->current_event_line)

+ {

+ // Reached the start of the file

+ throw new \LogicException("Can not find '@{$find_tag}' information for event "

+ . "'{$this->current_event}' in file '{$this->current_file}:{$this->current_event_line}'", 2);

+ }

+ }

+

+ return $this->current_event_line - $find_tag_line;

+ }

+

+ /**

+ * Find a "@*" Information line

+ *

+ * @return int Absolute line number

+ * @throws \LogicException

+ */

+ public function find_description()

+ {

+ $find_desc_line = 0;

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

+ {

+ $find_desc_line++;

+ if ($find_desc_line > $this->current_event_line)

+ {

+ // Reached the start of the file

+ throw new \LogicException("Can not find a description for event "

+ . "'{$this->current_event}' in file '{$this->current_file}:{$this->current_event_line}'", 1);

+ }

+ }

+

+ $find_desc_line = $this->current_event_line - $find_desc_line + 1;

+

+ $desc = trim($this->file_lines[$find_desc_line]);

+ if (strpos($desc, '* @') === 0 || $desc[0] !== '*' || substr($desc, 1) == '')

+ {

+ // First line of the doc block is a @-line, empty or only contains "*"

+ throw new \LogicException("Can not find a description for event "

+ . "'{$this->current_event}' in file '{$this->current_file}:{$this->current_event_line}'", 2);

+ }

+

+ return $find_desc_line;

+ }

+

+ /**

+ * Validate "@since" Information

+ *

+ * @param string $line

+ * @return string

+ * @throws \LogicException

+ */

+ public function validate_since($line)

+ {

+ $match = array();

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

+ if (!isset($match[1]))

+ {

+ throw new \LogicException("Invalid '@since' information for event "

+ . "'{$this->current_event}' in file '{$this->current_file}:{$this->current_event_line}'");

+ }

+

+ return $match[1];

+ }

+

+ /**

+ * Validate "@event" Information

+ *

+ * @param string $event_name

+ * @param string $line

+ * @return string

+ * @throws \LogicException

+ */

+ public function validate_event($event_name, $line)

+ {

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

+

+ if ($event !== trim($event))

+ {

+ throw new \LogicException("Invalid '@event' information for event "

+ . "'{$this->current_event}' in file '{$this->current_file}:{$this->current_event_line}'", 1);

+ }

+

+ if ($event !== $event_name)

+ {

+ throw new \LogicException("Event name does not match '@event' tag for event "

+ . "'{$this->current_event}' in file '{$this->current_file}:{$this->current_event_line}'", 2);

+ }

+

+ return $event;

+ }

+

+ /**

+ * Validates that two arrays contain the same strings

+ *

+ * @param array $vars_array Variables found in the array line

+ * @param array $vars_docblock Variables found in the doc block

+ * @return null

+ * @throws \LogicException

+ */

+ public function validate_vars_docblock_array($vars_array, $vars_docblock)

+ {

+ $vars_array = array_unique($vars_array);

+ $vars_docblock = array_unique($vars_docblock);

+ $sizeof_vars_array = sizeof($vars_array);

+

+ if ($sizeof_vars_array !== sizeof($vars_docblock) || $sizeof_vars_array !== sizeof(array_intersect($vars_array, $vars_docblock)))

+ {

+ throw new \LogicException("\$vars array does not match the list of '@var' tags for event "

+ . "'{$this->current_event}' in file '{$this->current_file}:{$this->current_event_line}'");

+ }

+ }

+}

+<?php

+/**

+*

+* @package event

+* @copyright (c) 2014 phpBB Group

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

+*

+*/

+

+namespace phpbb\event;

+

+/**

+* Class recursive_event_filter_iterator

+*

+* This filter ignores directories and files starting with a dot.

+* It also skips some directories that do not contain events anyway,

+* such as e.g. files/, store/ and vendor/

+*

+* @package phpbb\event

+*/

+class recursive_event_filter_iterator extends \RecursiveFilterIterator

+{

+ protected $root_path;

+

+ /**

+ * Construct

+ *

+ * @param \RecursiveIterator $iterator

+ * @param string $root_path

+ */

+ public function __construct(\RecursiveIterator $iterator, $root_path)

+ {

+ $this->root_path = str_replace(DIRECTORY_SEPARATOR, '/', $root_path);

+ parent::__construct($iterator);

+ }

+

+ /**

+ * Return the inner iterator's children contained in a recursive_event_filter_iterator

+ *

+ * @return recursive_event_filter_iterator

+ */

+ public function getChildren() {

+ return new self($this->getInnerIterator()->getChildren(), $this->root_path);

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function accept()

+ {

+ $relative_path = str_replace(DIRECTORY_SEPARATOR, '/', $this->current());

+ $filename = $this->current()->getFilename();

+

+ return (substr($relative_path, -4) === '.php' || $this->current()->isDir())

+ && $filename[0] !== '.'

+ && strpos($relative_path, $this->root_path . 'cache/') !== 0

+ && strpos($relative_path, $this->root_path . 'develop/') !== 0

+ && strpos($relative_path, $this->root_path . 'docs/') !== 0

+ && strpos($relative_path, $this->root_path . 'ext/') !== 0

+ && strpos($relative_path, $this->root_path . 'files/') !== 0

+ && strpos($relative_path, $this->root_path . 'includes/utf/') !== 0

+ && strpos($relative_path, $this->root_path . 'language/') !== 0

+ && strpos($relative_path, $this->root_path . 'phpbb/db/migration/data/') !== 0

+ && strpos($relative_path, $this->root_path . 'phpbb/event/') !== 0

+ && strpos($relative_path, $this->root_path . 'store/') !== 0

+ && strpos($relative_path, $this->root_path . 'tests/') !== 0

+ && strpos($relative_path, $this->root_path . 'vendor/') !== 0

+ ;

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2014 phpBB Group

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

+*

+*/

+

+namespace phpbb\feed;

+

+/**

+* Abstract class for feeds displaying attachments

+*

+* @package phpBB3

+*/

+abstract class attachments_base extends \phpbb\feed\base

+{

+ /**

+ * Attachments that may be displayed

+ */

+ protected $attachments = array();

+

+ /**

+ * Retrieve the list of attachments that may be displayed

+ */

+ protected function fetch_attachments()

+ {

+ $sql_array = array(

+ 'SELECT' => 'a.*',

+ 'FROM' => array(

+ ATTACHMENTS_TABLE => 'a'

+ ),

+ 'WHERE' => 'a.in_message = 0 ',

+ 'ORDER_BY' => 'a.filetime DESC, a.post_msg_id ASC',

+ );

+

+ if (isset($this->topic_id))

+ {

+ $sql_array['WHERE'] .= 'AND a.topic_id = ' . (int) $this->topic_id;

+ }

+ else if (isset($this->forum_id))

+ {

+ $sql_array['LEFT_JOIN'] = array(

+ array(

+ 'FROM' => array(TOPICS_TABLE => 't'),

+ 'ON' => 'a.topic_id = t.topic_id',

+ )

+ );

+ $sql_array['WHERE'] .= 'AND t.forum_id = ' . (int) $this->forum_id;

+ }

+

+ $sql = $this->db->sql_build_query('SELECT', $sql_array);

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

+

+ // Set attachments in feed items

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

+ {

+ $this->attachments[$row['post_msg_id']][] = $row;

+ }

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

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function open()

+ {

+ parent::open();

+ $this->fetch_attachments();

+ }

+

+ /**

+ * Get attachments related to a given post

+ *

+ * @param $post_id int Post id

+ * @return mixed Attachments related to $post_id

+ */

+ public function get_attachments($post_id)

+ {

+ return $this->attachments[$post_id];

+ }

+}

+

+ parent::open();

+ $item_row['forum_id'] = $this->forum_id;

+ WHERE topic_moved_id = 0

+ AND ' . $this->content_visibility->get_forums_visibility_sql('topic', $in_fid_ary) . '

+ p.post_id, p.post_time, p.post_edit_time, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, t.topic_visibility',

+abstract class post_base extends \phpbb\feed\attachments_base

+ . (($this->is_moderator_approve_forum($row['forum_id']) && (int)$row['post_visibility'] === ITEM_UNAPPROVED) ? ' ' . $this->separator_stats . ' ' . $this->user->lang['POST_UNAPPROVED'] : '')

+ . (($this->is_moderator_approve_forum($row['forum_id']) && (int)$row['post_visibility'] === ITEM_DELETED) ? ' ' . $this->separator_stats . ' ' . $this->user->lang['POST_DELETED'] : '');

+

+ parent::open();

+ function adjust_item(&$item_row, &$row)

+ {

+ parent::adjust_item($item_row, $row);

+

+ $item_row['forum_id'] = $this->forum_id;

+ }

+

+abstract class topic_base extends \phpbb\feed\attachments_base

+ . ' ' . $this->separator_stats . ' ' . $this->user->lang['REPLIES'] . ' ' . ($this->content_visibility->get_count('topic_posts', $row, $row['forum_id']) - 1)

+ . ' ' . $this->separator_stats . ' ' . $this->user->lang['VIEWS'] . ' ' . $row['topic_views'];

+

+ if ($this->is_moderator_approve_forum($row['forum_id']))

+ {

+ if ( (int)$row['topic_visibility'] === ITEM_DELETED)

+ {

+ $item_row['statistics'] .= ' ' . $this->separator_stats . ' ' . $this->user->lang['TOPIC_DELETED'];

+ }

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

+ {

+ $item_row['statistics'] .= ' ' . $this->separator_stats . ' ' . $this->user->lang['TOPIC_UNAPPROVED'];

+ }

+ else if ($row['topic_posts_unapproved'])

+ {

+ $item_row['statistics'] .= ' ' . $this->separator_stats . ' ' . $this->user->lang['POSTS_UNAPPROVED'];

+ }

+ }

+ WHERE topic_moved_id = 0

+ AND ' . $this->content_visibility->get_forums_visibility_sql('topic', $in_fid_ary) . '

+ p.post_id, p.post_time, p.post_edit_time, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, t.topic_visibility',

+ WHERE topic_moved_id = 0

+ AND ' . $this->content_visibility->get_forums_visibility_sql('topic', $in_fid_ary) . '

+ p.post_id, p.post_time, p.post_edit_time, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, t.topic_visibility',

+ * @since 3.1.0-a1

+ $vars = array(

+ 'mode',

+ 'user_id',

+ 'log_ip',

+ 'log_operation',

+ 'log_time',

+ 'additional_data',

+ 'sql_ary',

+ );

+ * @since 3.1.0-a1

+ $vars = array(

+ 'mode',

+ 'count_logs',

+ 'limit',

+ 'offset',

+ 'forum_id',

+ 'topic_id',

+ 'user_id',

+ 'log_time',

+ 'sort_by',

+ 'keywords',

+ 'profile_url',

+ 'log_type',

+ 'sql_additional',

+ );

+ * @since 3.1.0-a1

+ $num_args = substr_count($this->user->lang[$row['log_operation']], '%');

+ * @since 3.1.0-a1

+

+ /**

+ * {inheritDoc}

+ */

+ public function get_redirect_url()

+ {

+ return $this->get_url();

+ }

+ * {inheritDoc}

+ */

+ public function get_redirect_url()

+ {

+ return $this->get_url();

+ }

+

+ /**

+ $update_responders = $notification->add_responders($post);

+ if (!empty($update_responders))

+ {

+ $sql = 'UPDATE ' . $this->notifications_table . '

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

+ WHERE notification_id = ' . $row['notification_id'];

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

+ }

+ $update_responders = $notification->add_responders($post);

+ if (!empty($update_responders))

+ {

+ $sql = 'UPDATE ' . $this->notifications_table . '

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

+ WHERE notification_id = ' . $row['notification_id'];

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

+ }

+ if ($trimmed_responders_cnt > 20)

+ {

+ $usernames[] = $this->user->lang('NOTIFICATION_MANY_OTHERS');

+ }

+ else if ($trimmed_responders_cnt)

+ * {inheritDoc}

+ */

+ public function get_redirect_url()

+ {

+ return append_sid($this->phpbb_root_path . 'viewtopic.' . $this->php_ext, "t={$this->item_parent_id}&amp;view=unread#unread");

+ }

+

+ /**

+ return array();

+ // Do not add more than 25 responders,

+ // we trim the username list to "a, b, c and x others" anyway

+ // so there is no use to add all of them anyway.

+ if (sizeof($responders) > 25)

+ {

+ return array();

+ }

+

+ return array();

+ $serialized_data = serialize($this->get_data(false));

+

+ // If the data is longer then 4000 characters, it would cause a SQL error.

+ // We don't add the username to the list if this is the case.

+ if (utf8_strlen($serialized_data) >= 4000)

+ {

+ return array();

+ }

+

+ return array('notification_data' => $serialized_data);

+ * {inheritDoc}

+ */

+ public function get_redirect_url()

+ {

+ return parent::get_url();

+ }

+

+ /**

+ * {inheritDoc}

+ */

+ public function get_redirect_url()

+ {

+ return $this->get_url();

+ }

+

+ /**

+ * Get the url to redirect after the item has been marked as read

+ *

+ * @return string URL

+ */

+ public function get_redirect_url();

+

+ /**

+

+ /**

+ * Glue URL parameters together

+ *

+ * @param array $params URL parameters in the form of array(name => value)

+ * @return string Returns the glued string, e.g. name1=value1&amp;name2=value2

+ */

+ public function glue_url_params($params)

+ {

+ $_params = array();

+

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

+ {

+ $_params[] = $key . '=' . $value;

+ }

+ return implode('&amp;', $_params);

+ }

+

+ /**

+ * Get the base and parameters of a URL

+ *

+ * @param string $url URL to break apart

+ * @param bool $is_amp Is the parameter separator &amp;. Defaults to true.

+ * @return array Returns the base and parameters in the form of array('base' => string, 'params' => array(name => value))

+ */

+ public function get_url_parts($url, $is_amp = true)

+ {

+ $separator = ($is_amp) ? '&amp;' : '&';

+ $params = array();

+

+ if (strpos($url, '?') !== false)

+ {

+ $base = substr($url, 0, strpos($url, '?'));

+ $args = substr($url, strlen($base) + 1);

+ $args = ($args) ? explode($separator, $args) : array();

+

+ foreach ($args as $argument)

+ {

+ if (empty($argument))

+ {

+ continue;

+ }

+ list($key, $value) = explode('=', $argument, 2);

+

+ if ($key === '')

+ {

+ continue;

+ }

+

+ $params[$key] = $value;

+ }

+ }

+ else

+ {

+ $base = $url;

+ }

+

+ return array(

+ 'base' => $base,

+ 'params' => $params,

+ );

+ }

+

+ /**

+ * Strip parameters from an already built URL.

+ *

+ * @param string $url URL to strip parameters from

+ * @param array|string $strip Parameters to strip.

+ * @param bool $is_amp Is the parameter separator &amp;. Defaults to true.

+ * @return string Returns the new URL.

+ */

+ public function strip_url_params($url, $strip, $is_amp = true)

+ {

+ $url_parts = $this->get_url_parts($url, $is_amp);

+ $params = $url_parts['params'];

+

+ if (!is_array($strip))

+ {

+ $strip = array($strip);

+ }

+

+ if (!empty($params))

+ {

+ // Strip the parameters off

+ foreach ($strip as $param)

+ {

+ unset($params[$param]);

+ }

+ }

+

+ return $url_parts['base'] . (($params) ? '?' . $this->glue_url_params($params) : '');

+ }

+

+ /**

+ * Append parameters to an already built URL.

+ *

+ * @param string $url URL to append parameters to

+ * @param array $new_params Parameters to add in the form of array(name => value)

+ * @param string $is_amp Is the parameter separator &amp;. Defaults to true.

+ * @return string Returns the new URL.

+ */

+ public function append_url_params($url, $new_params, $is_amp = true)

+ {

+ $url_parts = $this->get_url_parts($url, $is_amp);

+ $params = array_merge($url_parts['params'], $new_params);

+

+ // Move the sid to the end if it's set

+ if (isset($params['sid']))

+ {

+ $sid = $params['sid'];

+ unset($params['sid']);

+ $params['sid'] = $sid;

+ }

+

+ return $url_parts['base'] . (($params) ? '?' . $this->glue_url_params($params) : '');

+ }

+ * @since 3.1.0-a1

+ * Event dispatcher object

+ * @var \phpbb\event\dispatcher

+ */

+ protected $dispatcher;

+

+ /**

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

+ public function __construct(\phpbb\auth\auth $auth, \phpbb\db\driver\driver_interface $db, \phpbb\event\dispatcher $dispatcher, \phpbb\request\request $request, \phpbb\template\template $template, \phpbb\di\service_collection $type_collection, \phpbb\user $user, $fields_table, $fields_language_table, $fields_data_table)

+ $this->dispatcher = $dispatcher;

+ /**

+ * Event to modify profile fields data retrieved from the database

+ *

+ * @event core.grab_profile_fields_data

+ * @var array user_ids Single user id or an array of ids

+ * @var array field_data Array with profile fields data

+ * @since 3.1.0-b3

+ */

+ $vars = array('user_ids', 'field_data');

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

+

+ /**

+ * Event to modify data of the generated profile fields, before the template assignment loop

+ *

+ * @event core.generate_profile_fields_template_data_before

+ * @var array profile_row Array with users profile field data

+ * @var array tpl_fields Array with template data fields

+ * @var bool use_contact_fields Should we display contact fields as such?

+ * @since 3.1.0-b3

+ */

+ $vars = array('profile_row', 'tpl_fields', 'use_contact_fields');

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

+

+ /**

+ * Event to modify template data of the generated profile fields

+ *

+ * @event core.generate_profile_fields_template_data

+ * @var array profile_row Array with users profile field data

+ * @var array tpl_fields Array with template data fields

+ * @var bool use_contact_fields Should we display contact fields as such?

+ * @since 3.1.0-b3

+ */

+ $vars = array('profile_row', 'tpl_fields', 'use_contact_fields');

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

+

+ case 'sqlite3':

+ if ($this->db->sql_layer == 'sqlite' || $this->db->sql_layer == 'sqlite3')

+ $sql_time" . (($this->db->sql_layer == 'sqlite' || $this->db->sql_layer == 'sqlite3') ? ')' : '');

+ case 'sqlite3':

+ * @param bool $httponly Use HttpOnly. Defaults to true. Use false to make cookie accessible by client-side scripts.

+ function set_cookie($name, $cookiedata, $cookietime, $httponly = true)

+ header('Set-Cookie: ' . $name_data . (($cookietime) ? '; expires=' . $expire : '') . '; path=' . $config['cookie_path'] . $domain . ((!$config['cookie_secure']) ? '' : '; secure') . ';' . (($httponly) ? ' HttpOnly' : ''), false);

+ $hard_parents = explode('.', $matches[1]);

+ array_pop($hard_parents); // ends with .

+ if ($hard_parents)

+ {

+ $parent_nodes = array_merge($hard_parents, $parent_nodes);

+ }

+

+ $name = $matches[2];

+ $subset = trim(substr($matches[3], 1, -1)); // Remove parenthesis

+ $body = $matches[4];

+ return preg_replace_callback('#<!-- BEGIN ((?:[a-zA-Z0-9_]+\.)*)([!a-zA-Z0-9_]+)(\([0-9,\-]+\))? -->(.+?)<!-- END \1\2 -->#s', $callback, $code);

+ global $db, $request, $template, $config, $auth, $phpEx, $phpbb_root_path, $cache;

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

+ if ($lang_override)

+ {

+ $this->set_cookie('lang', $lang_override, 0, false);

+ }

+ else

+ {

+ $lang_override = $request->variable($config['cookie_name'] . '_lang', '', true, \phpbb\request\request_interface::COOKIE);

+ }

+ if ($lang_override)

+ {

+ $use_lang = basename($lang_override);

+ $user_lang_name = (file_exists($this->lang_path . $use_lang . "/common.$phpEx")) ? $use_lang : basename($config['default_lang']);

+ $this->data['user_lang'] = $user_lang_name;

+ }

+ else

+ {

+ $user_lang_name = basename($config['default_lang']);

+ }

+ * @since 3.1.0-a1

+ $vars = array(

+ 'user_data',

+ 'user_lang_name',

+ 'user_date_format',

+ 'user_timezone',

+ 'lang_set',

+ 'lang_set_ext',

+ 'style_id',

+ );

+ $style_request = $request->variable('style', 0);

+ $title = '';

+

+ if ($alt)

+ {

+ $alt = $this->lang($alt);

+ $title = ' title="' . $alt . '"';

+ }

+ return '<span class="imageset ' . $img . '"' . $title . '>' . $alt . '</span>';