+ global $db, $cache, $phpbb_dispatcher;

+ /**

+ * Event is triggered after user(s) permission settings cache has been cleared

+ *

+ * @event core.acl_clear_prefetch_after

+ * @var mixed user_id User ID(s)

+ * @since 3.1.11-RC1

+ */

+ $vars = array('user_id');

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

+

+ // Do not allow specifying the port (see RFC 3986) or IP addresses

+ if (!preg_match('#^(http|https|ftp)://(?:(.*?\.)*?[a-z0-9\-]+?\.[a-z]{2,4}|(?:\d{1,3}\.){3,5}\d{1,3}):?([0-9]*?).*?\.('. implode('|', $this->allowed_extensions) . ')$#i', $url) ||

+ preg_match('@^(http|https|ftp)://[^/:?#]+:[0-9]+[/:?#]@i', $url) ||

+ preg_match('#^(http|https|ftp)://(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])#i', $url) ||

+ preg_match('#^(http|https|ftp)://(?:(?:(?:[\dA-F]{1,4}:){6}(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:::(?:[\dA-F]{1,4}:){0,5}(?:[\dA-F]{1,4}(?::[\dA-F]{1,4})?|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:):(?:[\dA-F]{1,4}:){4}(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:){1,2}:(?:[\dA-F]{1,4}:){3}(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:){1,3}:(?:[\dA-F]{1,4}:){2}(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:){1,4}:(?:[\dA-F]{1,4}:)(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:){1,5}:(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:){1,6}:[\dA-F]{1,4})|(?:(?:[\dA-F]{1,4}:){1,7}:)|(?:::))#i', $url))

+ // Do not allow specifying the port (see RFC 3986) or IP addresses

+ // remote_upload() will do its own check for allowed filetypes

+ if (preg_match('@^(http|https|ftp)://[^/:?#]+:[0-9]+[/:?#]@i', $url) ||

+ preg_match('#^(http|https|ftp)://(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])#i', $url) ||

+ preg_match('#^(http|https|ftp)://(?:(?:(?:[\dA-F]{1,4}:){6}(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:::(?:[\dA-F]{1,4}:){0,5}(?:[\dA-F]{1,4}(?::[\dA-F]{1,4})?|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:):(?:[\dA-F]{1,4}:){4}(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:){1,2}:(?:[\dA-F]{1,4}:){3}(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:){1,3}:(?:[\dA-F]{1,4}:){2}(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:){1,4}:(?:[\dA-F]{1,4}:)(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:){1,5}:(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:){1,6}:[\dA-F]{1,4})|(?:(?:[\dA-F]{1,4}:){1,7}:)|(?:::))#i', $url))

+ {

+ $error[] = 'AVATAR_URL_INVALID';

+ return false;

+ }

+

+ if (!sizeof($error) && $this->filesystem->exists($filename))

+ try

+ {

+ $this->filesystem->remove($filename);

+ return true;

+ }

+ catch (\phpbb\filesystem\exception\filesystem_exception $e)

+ {

+ // Fail is covered by return statement below

+ }

+ return false;

+ return ($this->filesystem->exists($this->phpbb_root_path . $this->config['avatar_path']) && $this->filesystem->is_writable($this->phpbb_root_path . $this->config['avatar_path']) && (@ini_get('file_uploads') || strtolower(@ini_get('file_uploads')) == 'on'));

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

+

+/**

+* ACM for APCU

+*/

+class apcu extends \phpbb\cache\driver\memory

+{

+ var $extension = 'apcu';

+

+ /**

+ * {@inheritDoc}

+ */

+ function purge()

+ {

+ apcu_clear_cache();

+

+ parent::purge();

+ }

+

+ /**

+ * Fetch an item from the cache

+ *

+ * @access protected

+ * @param string $var Cache key

+ * @return mixed Cached data

+ */

+ function _read($var)

+ {

+ return apcu_fetch($this->key_prefix . $var);

+ }

+

+ /**

+ * Store data in the cache

+ *

+ * @access protected

+ * @param string $var Cache key

+ * @param mixed $data Data to store

+ * @param int $ttl Time-to-live of cached data

+ * @return bool True if the operation succeeded

+ */

+ function _write($var, $data, $ttl = 2592000)

+ {

+ return apcu_store($this->key_prefix . $var, $data, $ttl);

+ }

+

+ /**

+ * Remove an item from the cache

+ *

+ * @access protected

+ * @param string $var Cache key

+ * @return bool True if the operation succeeded

+ */

+ function _delete($var)

+ {

+ return apcu_delete($this->key_prefix . $var);

+ }

+}

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

+ preg_match('#(.*)/(\d+)#', $u, $parts);

+ $this->memcache->addServer(trim($parts[1]), (int) trim($parts[2]));

+<?php

+/**

+*

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

+*

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

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

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\cache\driver;

+

+if (!defined('PHPBB_ACM_MEMCACHED_PORT'))

+{

+ define('PHPBB_ACM_MEMCACHED_PORT', 11211);

+}

+

+if (!defined('PHPBB_ACM_MEMCACHED_COMPRESS'))

+{

+ define('PHPBB_ACM_MEMCACHED_COMPRESS', true);

+}

+

+if (!defined('PHPBB_ACM_MEMCACHED_HOST'))

+{

+ define('PHPBB_ACM_MEMCACHED_HOST', 'localhost');

+}

+

+if (!defined('PHPBB_ACM_MEMCACHED'))

+{

+ //can define multiple servers with host1/port1,host2/port2 format

+ define('PHPBB_ACM_MEMCACHED', PHPBB_ACM_MEMCACHED_HOST . '/' . PHPBB_ACM_MEMCACHED_PORT);

+}

+

+/**

+* ACM for Memcached

+*/

+class memcached extends \phpbb\cache\driver\memory

+{

+ /** @var string Extension to use */

+ protected $extension = 'memcached';

+

+ /** @var \Memcached Memcached class */

+ protected $memcached;

+

+ /** @var int Flags */

+ protected $flags = 0;

+

+ /**

+ * Memcached constructor

+ */

+ public function __construct()

+ {

+ // Call the parent constructor

+ parent::__construct();

+

+ $this->memcached = new \Memcached();

+ $this->memcached->setOption(\Memcached::OPT_BINARY_PROTOCOL, true);

+ // Memcached defaults to using compression, disable if we don't want

+ // to use it

+ if (!PHPBB_ACM_MEMCACHED_COMPRESS)

+ {

+ $this->memcached->setOption(\Memcached::OPT_COMPRESSION, false);

+ }

+

+ foreach (explode(',', PHPBB_ACM_MEMCACHE) as $u)

+ {

+ preg_match('#(.*)/(\d+)#', $u, $parts);

+ $this->memcached->addServer(trim($parts[1]), (int) trim($parts[2]));

+ }

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function unload()

+ {

+ parent::unload();

+

+ unset($this->memcached);

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function purge()

+ {

+ $this->memcached->flush();

+

+ parent::purge();

+ }

+

+ /**

+ * Fetch an item from the cache

+ *

+ * @param string $var Cache key

+ *

+ * @return mixed Cached data

+ */

+ protected function _read($var)

+ {

+ return $this->memcached->get($this->key_prefix . $var);

+ }

+

+ /**

+ * Store data in the cache

+ *

+ * @param string $var Cache key

+ * @param mixed $data Data to store

+ * @param int $ttl Time-to-live of cached data

+ * @return bool True if the operation succeeded

+ */

+ protected function _write($var, $data, $ttl = 2592000)

+ {

+ if (!$this->memcached->replace($this->key_prefix . $var, $data, $ttl))

+ {

+ return $this->memcached->set($this->key_prefix . $var, $data, $ttl);

+ }

+ return true;

+ }

+

+ /**

+ * Remove an item from the cache

+ *

+ * @param string $var Cache key

+ * @return bool True if the operation succeeded

+ */

+ protected function _delete($var)

+ {

+ return $this->memcached->delete($this->key_prefix . $var);

+ }

+}

+

+ if (!$this->manager->is_enabled($name))

+ {

+ $io->error($this->user->lang('CLI_EXTENSION_DISABLED', $name));

+ return 2;

+ }

+

+ $extension = $this->manager->get_extension($name);

+

+ if (!$extension->is_enableable())

+ {

+ $io->error($this->user->lang('CLI_EXTENSION_NOT_ENABLEABLE', $name));

+ return 1;

+ }

+

+ if ($this->manager->is_enabled($name))

+ {

+ $io->error($this->user->lang('CLI_EXTENSION_ENABLED', $name));

+ return 1;

+ }

+

+<?php

+/**

+*

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

+*

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

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

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\console\command\fixup;

+

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

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

+use Symfony\Component\Console\Style\SymfonyStyle;

+

+class fix_left_right_ids extends \phpbb\console\command\command

+{

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

+ protected $user;

+

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

+ protected $db;

+

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

+ protected $cache;

+

+ /**

+ * Constructor

+ *

+ * @param \phpbb\user $user User instance

+ * @param \phpbb\db\driver\driver_interface $db Database connection

+ * @param \phpbb\cache\driver\driver_interface $cache Cache instance

+ */

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

+ {

+ $this->user = $user;

+ $this->db = $db;

+ $this->cache = $cache;

+

+ parent::__construct($user);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ protected function configure()

+ {

+ $this

+ ->setName('fixup:fix-left-right-ids')

+ ->setDescription($this->user->lang('CLI_DESCRIPTION_FIX_LEFT_RIGHT_IDS'))

+ ;

+ }

+

+ /**

+ * Executes the command fixup:fix-left-right-ids.

+ *

+ * Repairs the tree structure of the forums and modules.

+ * The code is mainly borrowed from Support toolkit for phpBB Olympus

+ *

+ * @param InputInterface $input An InputInterface instance

+ * @param OutputInterface $output An OutputInterface instance

+ *

+ * @return void

+ */

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

+ {

+ $io = new SymfonyStyle($input, $output);

+

+ // Fix Left/Right IDs for the modules table

+ $result = $this->db->sql_query('SELECT DISTINCT(module_class) FROM ' . MODULES_TABLE);

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

+ {

+ $i = 1;

+ $where = array("module_class = '" . $this->db->sql_escape($row['module_class']) . "'");

+ $this->fix_ids_tree($i, 'module_id', MODULES_TABLE, 0, $where);

+ }

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

+

+ // Fix the Left/Right IDs for the forums table

+ $i = 1;

+ $this->fix_ids_tree($i, 'forum_id', FORUMS_TABLE);

+

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

+

+ $io->success($this->user->lang('CLI_FIXUP_FIX_LEFT_RIGHT_IDS_SUCCESS'));

+ }

+

+ /**

+ * Item's tree structure rebuild helper

+ * The item is either forum or ACP/MCP/UCP module

+ *

+ * @param int $i Item id offset index

+ * @param string $field The key field to fix, forum_id|module_id

+ * @param string $table The table name to perform, FORUMS_TABLE|MODULES_TABLE

+ * @param int $parent_id Parent item id

+ * @param array $where Additional WHERE clause condition

+ *

+ * @return bool True on rebuild success, false otherwise

+ */

+ protected function fix_ids_tree(&$i, $field, $table, $parent_id = 0, $where = array())

+ {

+ $changes_made = false;

+ $sql = 'SELECT * FROM ' . $table . '

+ WHERE parent_id = ' . (int) $parent_id .

+ ((!empty($where)) ? ' AND ' . implode(' AND ', $where) : '') . '

+ ORDER BY left_id ASC';

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

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

+ {

+ // Update the left_id for the item

+ if ($row['left_id'] != $i)

+ {

+ $this->db->sql_query('UPDATE ' . $table . ' SET ' . $this->db->sql_build_array('UPDATE', array('left_id' => $i)) . " WHERE $field = " . (int) $row[$field]);

+ $changes_made = true;

+ }

+ $i++;

+

+ // Go through children and update their left/right IDs

+ $changes_made = (($this->fix_ids_tree($i, $field, $table, $row[$field], $where)) || $changes_made) ? true : false;

+

+ // Update the right_id for the item

+ if ($row['right_id'] != $i)

+ {

+ $this->db->sql_query('UPDATE ' . $table . ' SET ' . $this->db->sql_build_array('UPDATE', array('right_id' => $i)) . " WHERE $field = " . (int) $row[$field]);

+ $changes_made = true;

+ }

+ $i++;

+ }

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

+

+ return $changes_made;

+ }

+}

+<?php

+/**

+*

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

+*

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

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

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+namespace phpbb\console\command\fixup;

+

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

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

+use Symfony\Component\Console\Helper\ProgressBar;

+

+class update_hashes extends \phpbb\console\command\command

+{

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

+ protected $config;

+

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

+ protected $db;

+

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

+ protected $passwords_manager;

+

+ /** @var string Default hashing type */

+ protected $default_type;

+

+ /**

+ * Update_hashes constructor

+ *

+ * @param \phpbb\config\config $config

+ * @param \phpbb\user $user

+ * @param \phpbb\db\driver\driver_interface $db

+ * @param \phpbb\passwords\manager $passwords_manager

+ * @param array $hashing_algorithms Hashing driver

+ * service collection

+ * @param array $defaults Default password types

+ */

+ public function __construct(\phpbb\config\config $config, \phpbb\user $user,

+ \phpbb\db\driver\driver_interface $db, \phpbb\passwords\manager $passwords_manager,

+ $hashing_algorithms, $defaults)

+ {

+ $this->config = $config;

+ $this->db = $db;

+

+ $this->passwords_manager = $passwords_manager;

+

+ foreach ($defaults as $type)

+ {

+ if ($hashing_algorithms[$type]->is_supported())

+ {

+ $this->default_type = $type;

+ break;

+ }

+ }

+

+ parent::__construct($user);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ protected function configure()

+ {

+ $this

+ ->setName('fixup:update-hashes')

+ ->setDescription($this->user->lang('CLI_DESCRIPTION_UPDATE_HASH_BCRYPT'))

+ ;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

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

+ {

+ // Get count to be able to display progress

+ $sql = 'SELECT COUNT(user_id) AS count

+ FROM ' . USERS_TABLE . '

+ WHERE user_password ' . $this->db->sql_like_expression('$H$' . $this->db->get_any_char()) . '

+ OR user_password ' . $this->db->sql_like_expression('$CP$' . $this->db->get_any_char());

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

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

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

+

+ // Create progress bar

+ $progress_bar = new ProgressBar($output, $total_update_passwords);

+ $progress_bar->start();

+

+ $sql = 'SELECT user_id, user_password

+ FROM ' . USERS_TABLE . '

+ WHERE user_password ' . $this->db->sql_like_expression('$H$' . $this->db->get_any_char()) . '

+ OR user_password ' . $this->db->sql_like_expression('$CP$' . $this->db->get_any_char());

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

+

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

+ {

+ $new_hash = $this->passwords_manager->hash($row['user_password'], array($this->default_type));

+

+ $sql = 'UPDATE ' . USERS_TABLE . '

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

+ WHERE user_id = ' . (int) $row['user_id'];

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

+ $progress_bar->advance();

+ }

+

+ $this->config->set('update_hashes_last_cron', time());

+

+ $progress_bar->finish();

+

+ $output->writeln('<info>' . $this->user->lang('CLI_FIXUP_UPDATE_HASH_BCRYPT_SUCCESS') . '</info>');

+ }

+}

+ $md_manager = $ext_manager->create_extension_metadata_manager($ext_name);

+ $this->language->lang('DOWNLOAD_LATEST'),

+<?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\cron\task\core;

+

+/**

+ * Update old hashes to the current default hashing algorithm

+ *

+ * It is intended to gradually update all "old" style hashes to the

+ * current default hashing algorithm.

+ */

+class update_hashes extends \phpbb\cron\task\base

+{

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

+ protected $config;

+

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

+ protected $db;

+

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

+ protected $update_lock;

+

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

+ protected $passwords_manager;

+

+ /** @var string Default hashing type */

+ protected $default_type;

+

+ /**

+ * Constructor.

+ *

+ * @param \phpbb\config\config $config

+ * @param \phpbb\db\driver\driver_interface $db

+ * @param \phpbb\lock\db $update_lock

+ * @param \phpbb\passwords\manager $passwords_manager

+ * @param array $hashing_algorithms Hashing driver

+ * service collection

+ * @param array $defaults Default password types

+ */

+ public function __construct(\phpbb\config\config $config, \phpbb\db\driver\driver_interface $db, \phpbb\lock\db $update_lock, \phpbb\passwords\manager $passwords_manager, $hashing_algorithms, $defaults)

+ {

+ $this->config = $config;

+ $this->db = $db;

+ $this->passwords_manager = $passwords_manager;

+ $this->update_lock = $update_lock;

+

+ foreach ($defaults as $type)

+ {

+ if ($hashing_algorithms[$type]->is_supported())

+ {

+ $this->default_type = $type;

+ break;

+ }

+ }

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function is_runnable()

+ {

+ return !$this->config['use_system_cron'];

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function should_run()

+ {

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

+ {

+ $last_run = explode(' ', $this->config['update_hashes_lock']);

+ if ($last_run[0] + 60 >= time())

+ {

+ return false;

+ }

+ }

+

+ return $this->config['enable_update_hashes'] && $this->config['update_hashes_last_cron'] < (time() - 60);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function run()

+ {

+ if ($this->update_lock->acquire())

+ {

+ $sql = 'SELECT user_id, user_password

+ FROM ' . USERS_TABLE . '

+ WHERE user_password ' . $this->db->sql_like_expression('$H$' . $this->db->get_any_char()) . '

+ OR user_password ' . $this->db->sql_like_expression('$CP$' . $this->db->get_any_char());

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

+

+ $affected_rows = 0;

+

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

+ {

+ $new_hash = $this->passwords_manager->hash($row['user_password'], array($this->default_type));

+

+ // Increase number so we know that users were selected from the database

+ $affected_rows++;

+

+ $sql = 'UPDATE ' . USERS_TABLE . '

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

+ WHERE user_id = ' . (int) $row['user_id'];

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

+ }

+

+ $this->config->set('update_hashes_last_cron', time());

+ $this->update_lock->release();

+

+ // Stop cron for good once all hashes are converted

+ if ($affected_rows === 0)

+ {

+ $this->config->set('enable_update_hashes', '0');

+ }

+ }

+ }

+}

+ $sql_data .= "DROP SEQUENCE IF EXISTS {$table_name}_seq;\n";

+# With Apache 2.4 the "Order, Deny" syntax has been deprecated and moved from

+# module mod_authz_host to a new module called mod_access_compat (which may be

+# disabled) and a new "Require" syntax has been introduced to mod_authz_host.

+# We could just conditionally provide both versions, but unfortunately Apache

+# does not explicitly tell us its version if the module mod_version is not

+# available. In this case, we check for the availability of module

+# mod_authz_core (which should be on 2.4 or higher only) as a best guess.

+<IfModule mod_version.c>

+ <IfVersion < 2.4>

+ <Files "*">

+ Order Allow,Deny

+ Deny from All

+ </Files>

+ </IfVersion>

+ <IfVersion >= 2.4>

+ <Files "*">

+ Require all denied

+ </Files>

+ </IfVersion>

+</IfModule>

+<IfModule !mod_version.c>

+ <IfModule !mod_authz_core.c>

+ <Files "*">

+ Order Allow,Deny

+ Deny from All

+ </Files>

+ </IfModule>

+ <IfModule mod_authz_core.c>

+ <Files "*">

+ Require all denied

+ </Files>

+ </IfModule>

+</IfModule>

+# With Apache 2.4 the "Order, Deny" syntax has been deprecated and moved from

+# module mod_authz_host to a new module called mod_access_compat (which may be

+# disabled) and a new "Require" syntax has been introduced to mod_authz_host.

+# We could just conditionally provide both versions, but unfortunately Apache

+# does not explicitly tell us its version if the module mod_version is not

+# available. In this case, we check for the availability of module

+# mod_authz_core (which should be on 2.4 or higher only) as a best guess.

+<IfModule mod_version.c>

+ <IfVersion < 2.4>

+ <Files "*">

+ Order Allow,Deny

+ Deny from All

+ </Files>

+ </IfVersion>

+ <IfVersion >= 2.4>

+ <Files "*">

+ Require all denied

+ </Files>

+ </IfVersion>

+</IfModule>

+<IfModule !mod_version.c>

+ <IfModule !mod_authz_core.c>

+ <Files "*">

+ Order Allow,Deny

+ Deny from All

+ </Files>

+ </IfModule>

+ <IfModule mod_authz_core.c>

+ <Files "*">

+ Require all denied

+ </Files>

+ </IfModule>

+</IfModule>

+# With Apache 2.4 the "Order, Deny" syntax has been deprecated and moved from

+# module mod_authz_host to a new module called mod_access_compat (which may be

+# disabled) and a new "Require" syntax has been introduced to mod_authz_host.

+# We could just conditionally provide both versions, but unfortunately Apache

+# does not explicitly tell us its version if the module mod_version is not

+# available. In this case, we check for the availability of module

+# mod_authz_core (which should be on 2.4 or higher only) as a best guess.

+<IfModule mod_version.c>

+ <IfVersion < 2.4>

+ <Files "*">

+ Order Allow,Deny

+ Deny from All

+ </Files>

+ </IfVersion>

+ <IfVersion >= 2.4>

+ <Files "*">

+ Require all denied

+ </Files>

+ </IfVersion>

+</IfModule>

+<IfModule !mod_version.c>

+ <IfModule !mod_authz_core.c>

+ <Files "*">

+ Order Allow,Deny

+ Deny from All

+ </Files>

+ </IfModule>

+ <IfModule mod_authz_core.c>

+ <Files "*">

+ Require all denied

+ </Files>

+ </IfModule>

+</IfModule>

+<?php

+/**

+*

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

+*

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

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

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

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

+

+class add_jabber_ssl_context_config_options extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

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

+ }

+

+ public function update_data()

+ {

+ return array(

+ // See http://php.net/manual/en/context.ssl.php

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

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

+ array('config.add', array('jab_allow_self_signed', 0)),

+ );

+ }

+}

+<?php

+/**

+ *

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

+ *

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

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

+ *

+ * For full copyright and license information, please see

+ * the docs/CREDITS.txt file.

+ *

+ */

+

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

+

+class add_latest_topics_index extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

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

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_index' => array(

+ $this->table_prefix . 'topics' => array(

+ 'latest_topics' => array(

+ 'forum_id',

+ 'topic_last_post_time',

+ 'topic_last_post_id',

+ 'topic_moved_id',

+ ),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_keys' => array(

+ $this->table_prefix . 'topics' => array(

+ 'latest_topics',

+ ),

+ ),

+ );

+ }

+}

+<?php

+/**

+*

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

+*

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

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

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

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

+

+class add_smtp_ssl_context_config_options extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

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

+ }

+

+ public function update_data()

+ {

+ return array(

+ // See http://php.net/manual/en/context.ssl.php

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

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

+ array('config.add', array('smtp_allow_self_signed', 0)),

+ );

+ }

+}

+<?php

+/**

+ *

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

+ *

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

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

+ *

+ * For full copyright and license information, please see

+ * the docs/CREDITS.txt file.

+ *

+ */

+

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

+

+class update_hashes extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

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

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

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

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

+ array('config.add', array('update_hashes_last_cron', '0'))

+ );

+ }

+}

+<?php

+/**

+*

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

+*

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

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

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

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

+

+class v3111 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.1.11', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array(

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

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

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

+ );

+ }

+}

+<?php

+/**

+*

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

+*

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

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

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

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

+

+class v3111rc1 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.1.11-RC1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array(

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

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

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

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

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

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

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

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

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

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

+ );

+ }

+}

+# With Apache 2.4 the "Order, Deny" syntax has been deprecated and moved from

+# module mod_authz_host to a new module called mod_access_compat (which may be

+# disabled) and a new "Require" syntax has been introduced to mod_authz_host.

+# We could just conditionally provide both versions, but unfortunately Apache

+# does not explicitly tell us its version if the module mod_version is not

+# available. In this case, we check for the availability of module

+# mod_authz_core (which should be on 2.4 or higher only) as a best guess.

+<IfModule mod_version.c>

+ <IfVersion < 2.4>

+ <Files "*">

+ Order Allow,Deny

+ Deny from All

+ </Files>

+ </IfVersion>

+ <IfVersion >= 2.4>

+ <Files "*">

+ Require all denied

+ </Files>

+ </IfVersion>

+</IfModule>

+<IfModule !mod_version.c>

+ <IfModule !mod_authz_core.c>

+ <Files "*">

+ Order Allow,Deny

+ Deny from All

+ </Files>

+ </IfModule>

+ <IfModule mod_authz_core.c>

+ <Files "*">

+ Require all denied

+ </Files>

+ </IfModule>

+</IfModule>

+ array('if', array(

+ array('module.exists', array('acp', false, 'ACP_SEND_STATISTICS')),

+ array('module.remove', array('acp', false, 'ACP_SEND_STATISTICS')),

+<?php

+/**

+*

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

+*

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

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

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

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

+

+class cookie_notice extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v320\v320rc2',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('cookie_notice', false)),

+ );

+ }

+}

+<?php

+/**

+*

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

+*

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

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

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

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

+

+use phpbb\db\migration\migration;

+

+class v320 extends migration

+{

+ public function effectively_installed()

+ {

+ return version_compare($this->config['version'], '3.2.0', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array(

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

+ '\phpbb\db\migration\data\v320\cookie_notice',

+ );

+

+ }

+

+ public function update_data()

+ {

+ return array(

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

+ );

+ }

+}

+# With Apache 2.4 the "Order, Deny" syntax has been deprecated and moved from

+# module mod_authz_host to a new module called mod_access_compat (which may be

+# disabled) and a new "Require" syntax has been introduced to mod_authz_host.

+# We could just conditionally provide both versions, but unfortunately Apache

+# does not explicitly tell us its version if the module mod_version is not

+# available. In this case, we check for the availability of module

+# mod_authz_core (which should be on 2.4 or higher only) as a best guess.

+<IfModule mod_version.c>

+ <IfVersion < 2.4>

+ <Files "*">

+ Order Allow,Deny

+ Deny from All

+ </Files>

+ </IfVersion>

+ <IfVersion >= 2.4>

+ <Files "*">

+ Require all denied

+ </Files>

+ </IfVersion>

+</IfModule>

+<IfModule !mod_version.c>

+ <IfModule !mod_authz_core.c>

+ <Files "*">

+ Order Allow,Deny

+ Deny from All

+ </Files>

+ </IfModule>

+ <IfModule mod_authz_core.c>

+ <Files "*">

+ Require all denied

+ </Files>

+ </IfModule>

+</IfModule>

+<?php

+/**

+*

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

+*

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

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

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

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

+

+class cookie_notice_p2 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v320\v320',

+ );

+ }

+

+ public function effectively_installed()

+ {

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

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('cookie_notice', '0')),

+ );

+ }

+}

+<?php

+/**

+*

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

+*

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

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

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

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

+

+class load_user_activity_limit extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v320\v320',

+ );

+ }

+

+ public function effectively_installed()

+ {

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

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('load_user_activity_limit', '5000')),

+ );

+ }

+}

+<?php

+/**

+ *

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

+ *

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

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

+ *

+ * For full copyright and license information, please see

+ * the docs/CREDITS.txt file.

+ *

+ */

+

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

+

+class user_notifications_table_index_p1 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v32x\cookie_notice_p2',

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_index' => array(

+ $this->table_prefix . 'user_notifications' => array(

+ 'user_id' => array('user_id'),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_keys' => array(

+ $this->table_prefix . 'user_notifications' => array(

+ 'user_id',

+ ),

+ ),

+ );

+ }

+}

+<?php

+/**

+ *

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

+ *

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

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

+ *

+ * For full copyright and license information, please see

+ * the docs/CREDITS.txt file.

+ *

+ */

+

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

+

+class user_notifications_table_index_p2 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v32x\user_notifications_table_index_p1',

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_index' => array(

+ $this->table_prefix . 'user_notifications' => array(

+ 'uid_itm_id' => array('user_id', 'item_id'),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_keys' => array(

+ $this->table_prefix . 'user_notifications' => array(

+ 'uid_itm_id',

+ ),

+ ),

+ );

+ }

+}

+<?php

+/**

+ *

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

+ *

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

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

+ *

+ * For full copyright and license information, please see

+ * the docs/CREDITS.txt file.

+ *

+ */

+

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

+

+class user_notifications_table_index_p3 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v32x\user_notifications_table_index_p2',

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_index' => array(

+ $this->table_prefix . 'user_notifications' => array(

+ 'usr_itm_tpe' => array('user_id', 'item_type', 'item_id'),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_keys' => array(

+ $this->table_prefix . 'user_notifications' => array(

+ 'usr_itm_tpe',

+ ),

+ ),

+ );

+ }

+}

+<?php

+/**

+ *

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

+ *

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

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

+ *

+ * For full copyright and license information, please see

+ * the docs/CREDITS.txt file.

+ *

+ */

+

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

+

+class user_notifications_table_reduce_column_sizes extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v32x\user_notifications_table_index_p3',

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'change_columns' => array(

+ $this->table_prefix . 'user_notifications' => array(

+ 'item_type' => array('VCHAR:165', ''),

+ 'method' => array('VCHAR:165', ''),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'change_columns' => array(

+ $this->table_prefix . 'user_notifications' => array(

+ 'item_type' => array('VCHAR:255', ''),

+ 'method' => array('VCHAR:255', ''),

+ ),

+ ),

+ );

+ }

+}

+<?php

+/**

+ *

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

+ *

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

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

+ *

+ * For full copyright and license information, please see

+ * the docs/CREDITS.txt file.

+ *

+ */

+

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

+

+class user_notifications_table_remove_duplicates extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v32x\user_notifications_table_temp_index',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

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

+ );

+ }

+

+ public function remove_duplicates()

+ {

+ $insert_buffer = new \phpbb\db\sql_insert_buffer($this->db, $this->table_prefix . 'user_notifications');

+

+ $sql = "SELECT item_type, item_id, user_id, method, MAX(notify) AS notify

+ FROM {$this->table_prefix}user_notifications

+ GROUP BY item_type, item_id, user_id, method

+ HAVING COUNT(item_type) > 1";

+

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

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

+ {

+ // Delete the duplicate entries

+ $this->sql_query("DELETE FROM {$this->table_prefix}user_notifications

+ WHERE user_id = {$row['user_id']}

+ AND item_type = '{$row['item_type']}'

+ AND method = '{$row['method']}'");

+

+ // And re-insert as a single one

+ $insert_buffer->insert($row);

+ }

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

+ }

+}

+<?php

+/**

+ *

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

+ *

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

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

+ *

+ * For full copyright and license information, please see

+ * the docs/CREDITS.txt file.

+ *

+ */

+

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

+

+class user_notifications_table_temp_index extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v32x\user_notifications_table_reduce_column_sizes',

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_index' => array(

+ $this->table_prefix . 'user_notifications' => array(

+ 'itm_usr_mthd' => array('item_type', 'item_id', 'user_id', 'method'),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_keys' => array(

+ $this->table_prefix . 'user_notifications' => array(

+ 'itm_usr_mthd',

+ ),

+ ),

+ );

+ }

+}

+<?php

+/**

+ *

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

+ *

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

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

+ *

+ * For full copyright and license information, please see

+ * the docs/CREDITS.txt file.

+ *

+ */

+

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

+

+class user_notifications_table_unique_index extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v32x\user_notifications_table_remove_duplicates',

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'drop_keys' => array(

+ $this->table_prefix . 'user_notifications' => array(

+ 'itm_usr_mthd',

+ ),

+ ),

+ 'add_unique_index' => array(

+ $this->table_prefix . 'user_notifications' => array(

+ 'itm_usr_mthd' => array('item_type', 'item_id', 'user_id', 'method'),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_keys' => array(

+ $this->table_prefix . 'user_notifications' => array(

+ 'itm_usr_mthd',

+ ),

+ ),

+ );

+ }

+}

+<?php

+/**

+*

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

+*

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

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

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

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

+

+class v321 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.2.1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v32x\v321rc1',

+ );

+

+ }

+

+ public function update_data()

+ {

+ return array(

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

+ );

+ }

+}

+<?php

+/**

+*

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

+*

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

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

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

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

+

+class v321rc1 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.2.1-RC1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v320\v320',

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

+ '\phpbb\db\migration\data\v32x\load_user_activity_limit',

+ '\phpbb\db\migration\data\v32x\user_notifications_table_unique_index',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

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

+ );

+ }

+}

+<?php

+/**

+*

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

+*

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

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

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db;

+

+/**

+ * @deprecated 3.2.0-dev (To be removed 3.3.0) use \phpbb\db\tools\tools instead

+ */

+class tools extends \phpbb\db\tools\tools

+{

+}

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

+ if ($this->is_sql_server_2000())

+ {

+ $this->check_index_name_length($table_name, $index_name);

+ }

+ if ($this->is_sql_server_2000())

+ {

+ $this->check_index_name_length($table_name, $index_name);

+ }

+ if (!empty($column_data['default']) && !$this->mssql_is_column_identity($table_name, $column_name))

+ * Checks to see if column is an identity column

+ *

+ * Identity columns cannot have defaults set for them.

+ *

+ * @param string $table_name

+ * @param string $column_name

+ * @return bool true if identity, false if not

+ */

+ protected function mssql_is_column_identity($table_name, $column_name)

+ {

+ 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 COLUMNPROPERTY(object_id('{$table_name}'), '{$column_name}', 'IsIdentity') AS is_identity";

+ }

+ else

+ {

+ $sql = "SELECT is_identity FROM sys.columns

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

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

+ }

+

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

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

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

+

+ return (bool) $is_identity;

+ }

+

+ /**

+ AND ix.is_primary_key = 0

+ $statements[] = "DROP SEQUENCE IF EXISTS {$table_name}_seq;\n";

+ // These DBMS prefix index name with the table name

+ $new_index_name = $this->check_index_name_length($table_name, $table_name . '_' . $index_name, false);

+ break;

+ default:

+ $new_index_name = $this->check_index_name_length($table_name, $index_name, false);

+ if (strtolower($row[$col]) == strtolower($new_index_name))

+ $index_name = $this->check_index_name_length($table_name, $index_name, false);

+ $index_name = $this->check_index_name_length($table_name, $table_name . '_' . $index_name, false);

+ $statements[] = 'DROP INDEX ' . $index_name;

+ $index_name = $this->check_index_name_length($table_name, $table_name . '_' . $index_name);

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

+ $index_name = $this->check_index_name_length($table_name, $index_name);

+ $index_name = $this->check_index_name_length($table_name, $table_name . '_' . $index_name);

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

+ $index_name = $this->check_index_name_length($table_name, $index_name);

+ * @param bool $throw_error

+ * @return string The index name, shortened if too long

+ protected function check_index_name_length($table_name, $index_name, $throw_error = true)

+ if (strlen($index_name) > 30)

+ // Try removing the table prefix if it's at the beginning

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

+ if (strpos($index_name, $table_prefix) === 0)

+ {

+ $index_name = substr($index_name, strlen($table_prefix));

+ return $this->check_index_name_length($table_name, $index_name, $throw_error);

+ }

+

+ // Try removing the remaining suffix part of table name then

+ $table_suffix = substr($table_name, strlen($table_prefix));

+ if (strpos($index_name, $table_suffix) === 0)

+ {

+ // Remove the suffix and underscore separator between table_name and index_name

+ $index_name = substr($index_name, strlen($table_suffix) + 1);

+ return $this->check_index_name_length($table_name, $index_name, $throw_error);

+ }

+

+ if ($throw_error)

+ {

+ trigger_error("Index name '$index_name' on table '$table_name' is too long. The maximum is 30 characters.", E_USER_ERROR);

+ }

+

+ return $index_name;

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

+ */

+ protected $dbal_connection = null;

+

+ /**

+ $this->inject_dbal_driver();

+

+ }

+ /**

+ * Inject the dbal connection driver into container

+ */

+ protected function inject_dbal_driver()

+ {

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

+ {

+ return;

+ }

+

+ $config_data = $this->config_php_file->get_all();

+ if (!empty($config_data))

+ {

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

+ {

+ $dbal_driver_class = $this->config_php_file->convert_30_dbms_to_31($this->config_php_file->get('dbms'));

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

+ $this->dbal_connection = new $dbal_driver_class();

+ $this->dbal_connection->sql_connect(

+ $this->config_php_file->get('dbhost'),

+ $this->config_php_file->get('dbuser'),

+ $this->config_php_file->get('dbpasswd'),

+ $this->config_php_file->get('dbname'),

+ $this->config_php_file->get('dbport'),

+ false,

+ defined('PHPBB_DB_NEW_LINK') && PHPBB_DB_NEW_LINK

+ );

+ }

+ $this->container->set('dbal.conn.driver', $this->dbal_connection);

+ }

+ const TWIG_OPTIONS_POSITION = 7;

+ if (empty($tmp_dir) || !@file_exists($tmp_dir) || !@is_writable($tmp_dir))

+

+ /**

+ * Returns data with updated key in specified offset.

+ *

+ * @param string $subarray Data array subarray

+ * @param string $key Subarray key

+ * @param mixed $value Value to update

+ */

+ public function update_subarray($subarray, $key, $value)

+ {

+ $this->data[$subarray][$key] = $value;

+ }

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

+ * @param string $tag_name Should be 'change', not 'changed'

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

+ if (!isset($this->extensions[$name]['metadata']))

+ {

+ $metadata = new \phpbb\extension\metadata_manager($name, $this->get_extension_path($name, true));

+ $this->extensions[$name]['metadata'] = $metadata;

+ }

+ return $this->extensions[$name]['metadata'];

+ if ($this->is_enabled($name))

+ // ignore extensions that are not enabled

+ if (!$this->is_enabled($name))

+ // ignore extensions that are not configured

+ if (!$this->is_configured($name))

+ if ($this->is_available($ext_name))

+ $available[$ext_name] = $this->get_extension_path($ext_name, true);

+ if ($this->is_configured($name))

+ {

+ unset($data['metadata']);

+ $data['ext_path'] = ($phpbb_relative ? $this->phpbb_root_path : '') . $data['ext_path'];

+ $configured[$name] = $data;

+ }

+ if ($this->is_enabled($name))

+ if ($this->is_disabled($name))

+ $md_manager = $this->create_extension_metadata_manager($name);

+ try

+ {

+ return $md_manager->get_metadata('all') && $md_manager->validate_enable();

+ }

+ catch (\phpbb\extension\exception $e)

+ {

+ return false;

+ }

+ return isset($this->extensions[$name]['ext_active']) && $this->extensions[$name]['ext_active'];

+ return isset($this->extensions[$name]['ext_active']) && !$this->extensions[$name]['ext_active'];

+ return isset($this->extensions[$name]['ext_active']);

+ * @return array

+ $version_helper->set_file_location($version_check['host'], $version_check['directory'], $version_check['filename'], isset($version_check['ssl']) ? $version_check['ssl'] : false);

+ return $version_helper->get_ext_update_on_branch($force_update, $force_cache);

+ * @param string $ext_path Path to the extension directory including root path

+ public function __construct($ext_name, $ext_path)

+ $this->metadata_file = $ext_path . 'composer.json';

+ // Fetch and clean the metadata if not done yet

+ if ($this->metadata === array())

+ {

+ $this->fetch_metadata_from_file();

+ }

+ $this->validate();

+ $this->validate($element);

+ return $this->metadata[$element];

+ return (isset($this->metadata['extra']['display-name'])) ? $this->metadata['extra']['display-name'] : $this->get_metadata('name');

+ * Gets the metadata file contents and cleans loaded file

+ private function fetch_metadata_from_file()

+ if (!($file_contents = file_get_contents($this->metadata_file)))

+ throw new \phpbb\extension\exception('FILE_CONTENT_ERR', array($this->metadata_file));

+ if (($metadata = json_decode($file_contents, true)) === null)

+ {

+ throw new \phpbb\extension\exception('FILE_JSON_DECODE_ERR', array($this->metadata_file));

+

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

+ $this->metadata = $metadata;

+ // no break

+ * @return bool True if validation succeeded, throws an exception if invalid

+ * @throws \phpbb\extension\exception

+ return $this->validate_dir() && $this->validate_require_phpbb() && $this->validate_require_php();

+ * @return boolean True when passes validation, throws an exception if invalid

+ * @throws \phpbb\extension\exception

+ if (substr_count($this->ext_name, '/') !== 1 || $this->ext_name != $this->get_metadata('name'))

+ {

+ throw new \phpbb\extension\exception('EXTENSION_DIR_INVALID');

+ }

+

+ return true;

+ * @return boolean True when passes validation, throws an exception if invalid

+ * @throws \phpbb\extension\exception

+ throw new \phpbb\extension\exception('META_FIELD_NOT_SET', array('soft-require'));

+ * @return boolean True when passes validation, throws an exception if invalid

+ * @throws \phpbb\extension\exception

+ throw new \phpbb\extension\exception('META_FIELD_NOT_SET', array('require php'));

+ *

+ * @param array $post_ids Specify for which post IDs to fetch the attachments (optional)

+ * @param array $topic_ids Specify for which topic IDs to fetch the attachments (optional)

+ protected function fetch_attachments($post_ids = array(), $topic_ids = array())

+ if (!empty($post_ids))

+ {

+ $sql_array['WHERE'] .= 'AND ' . $this->db->sql_in_set('a.post_msg_id', $post_ids);

+ }

+ else if (!empty($topic_ids))

+ {

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

+ {

+ $topic_ids[] = $this->topic_id;

+ }

+

+ $sql_array['WHERE'] .= 'AND ' . $this->db->sql_in_set('a.topic_id', $topic_ids);

+ }

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

+ else

+ {

+ // Do not allow querying the full attachments table

+ throw new \RuntimeException($this->user->lang('INVALID_FEED_ATTACHMENTS'));

+ }

+ parent::fetch_attachments(array(), $topic_ids);

+

+ parent::fetch_attachments($post_ids);

+

+ parent::fetch_attachments(array(), $topic_ids);

+

+ parent::fetch_attachments();

+

+ parent::fetch_attachments($post_ids);

+

+ parent::fetch_attachments($post_ids);

+

+ $name = $upload_ary['name'];

+ $template_file = 'faq_body.html';

+ * @var string template_file Template file name

+ * @changed 3.1.11-RC1 Added template_file var

+ 'template_file',

+ return $this->helper->render($template_file, $page_title);

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

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

+ public function __construct(\phpbb\event\dispatcher_interface $dispatcher, \phpbb\language\language $language, \phpbb\template\template $template)

+ // Check if SQLite database is writable

+ if ($dbms_info['SCHEMA'] === 'sqlite'

+ && (!$this->filesystem->is_writable($dbhost) || !$this->filesystem->is_writable(pathinfo($dbhost, PATHINFO_DIRNAME))))

+ {

+ $errors[] = array(

+ 'title' =>'INST_ERR_DB_NO_WRITABLE',

+ );

+ }

+

+ public function __construct(update_helper $update_helper, $phpbb_root_path, $php_ext)

+ $tpl_ary['DISABLED'] = isset($input_options['disabled']) ? $input_options['disabled'] : false;

+ if (!$not_button_form)

+ {

+ $this->template->destroy_block_vars('options');

+ }

+

+<?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\install\module\install_data\task;

+

+use phpbb\auth\auth;

+use phpbb\db\driver\driver_interface;

+use phpbb\event\dispatcher;

+use phpbb\config\config;

+use phpbb\install\helper\container_factory;

+use phpbb\language\language;

+use phpbb\search\fulltext_native;

+use phpbb\user;

+

+class create_search_index extends \phpbb\install\task_base

+{

+ /**

+ * @var auth

+ */

+ protected $auth;

+

+ /**

+ * @var config

+ */

+ protected $config;

+

+ /**

+ * @var driver_interface

+ */

+ protected $db;

+

+ /**

+ * @var dispatcher

+ */

+ protected $phpbb_dispatcher;

+

+ /**

+ * @var language

+ */

+ protected $language;

+

+ /**

+ * @var user

+ */

+ protected $user;

+

+ /**

+ * @var string phpBB root path

+ */

+ protected $phpbb_root_path;

+

+ /**

+ * @var string PHP file extension

+ */

+ protected $php_ext;

+

+ /**

+ * Constructor

+ *

+ * @param config $config phpBB config

+ * @param container_factory $container Installer's DI container

+ * @param string $phpbb_root_path phpBB root path

+ * @param string $php_ext PHP file extension

+ */

+ public function __construct(config $config, container_factory $container,

+ $phpbb_root_path, $php_ext)

+ {

+ $this->auth = $container->get('auth');

+ $this->config = $config;

+ $this->db = $container->get('dbal.conn');

+ $this->language = $container->get('language');

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

+ $this->user = $container->get('user');

+

+ parent::__construct(true);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function run()

+ {

+ // Make sure fulltext native load update is set

+ $this->config->set('fulltext_native_load_upd', 1);

+

+ $error = false;

+ $search = new fulltext_native(

+ $error,

+ $this->phpbb_root_path,

+ $this->php_ext,

+ $this->auth,

+ $this->config,

+ $this->db,

+ $this->user,

+ $this->phpbb_dispatcher

+ );

+

+ $sql = 'SELECT post_id, post_subject, post_text, poster_id, forum_id

+ FROM ' . POSTS_TABLE;

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

+

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

+ {

+ $search->index('post', $row['post_id'], $row['post_text'], $row['post_subject'], $row['poster_id'], $row['forum_id']);

+ }

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

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ static public function get_step_count()

+ {

+ return 1;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_task_lang_name()

+ {

+ return 'TASK_CREATE_SEARCH_INDEX';

+ }

+}

+ $extension = $this->extension_manager->get_extension($ext_name);

+

+ if (!$extension->is_enableable())

+ {

+ $this->iohandler->add_log_message(array('CLI_EXTENSION_NOT_ENABLEABLE', $ext_name));

+ continue;

+ }

+

+ 'description' => 'ENABLE_EMAIL_EXPLAIN',

+ if ($this->update_helper->phpbb_version_compare($version_from, $version, '<'))

+ if (file_exists($old_path . $filename))

+ {

+ $file_contents[0] = file_get_contents($old_path . $filename);

+ $filenames = array(

+ $this->phpbb_root_path . $filename,

+ $new_path . $filename

+ );

+ foreach ($filenames as $file_to_diff)

+ {

+ $file_contents[] = file_get_contents($file_to_diff);

+

+ if ($file_contents[sizeof($file_contents) - 1] === false)

+ {

+ $this->iohandler->add_error_message(array('FILE_DIFFER_ERROR_FILE_CANNOT_BE_READ', $files_to_diff));

+ unset($file_contents);

+ throw new user_interaction_required_exception();

+ }

+ }

+ $diff = new \diff3($file_contents[0], $file_contents[1], $file_contents[2]);

+ unset($file_contents);

+

+ // Handle conflicts

+ if ($diff->get_num_conflicts() !== 0)

+ $merge_conflicts[] = $filename;

+ // Save merged output

+ $this->cache->put(

+ '_file_' . md5($filename),

+ base64_encode(implode("\n", $diff->merged_output()))

+ );

+ unset($diff);

+ else

+ {

+ $new_file_content = file_get_contents($new_path . $filename);

+ if ($new_file_content === false)

+ {

+ $this->iohandler->add_error_message(array('FILE_DIFFER_ERROR_FILE_CANNOT_BE_READ', $files_to_diff));

+ unset($new_file_content );

+ throw new user_interaction_required_exception();

+ }

+ // Save new file content to cache

+ $this->cache->put(

+ '_file_' . md5($filename),

+ base64_encode($new_file_content)

+ );

+ unset($new_file_content);

+ }

+ $this->installer_config->set('file_updater_elem_progress', '');

+ $this->installer_config->set('update_files', array());

+ $file_update_info = $this->installer_config->get('update_files', array());

+

+ if (count($file_update_info) > 0)

+ {

+ // Render download box

+ $this->iohandler->add_download_link(

+ 'phpbb_installer_update_file_download',

+ 'DOWNLOAD_UPDATE_METHOD',

+ 'DOWNLOAD_UPDATE_METHOD_EXPLAIN'

+ );

+ }

+ 'label' => 'UPDATE_CONTINUE_UPDATE_PROCESS',

+ 'type' => 'submit',

+ 'disabled' => count($file_update_info) > 0,

+ foreach ($file_update_info['update_without_diff'] as $key => $binary_file)

+ {

+ $new_file = $new_path . $binary_file;

+ $file = $this->phpbb_root_path . $binary_file;

+

+ if (!$this->filesystem->exists($file))

+ {

+ continue;

+ }

+

+ if (md5_file($file) === md5_file($new_file))

+ {

+ // File already up to date

+ unset($file_update_info['update_without_diff'][$key]);

+ }

+ }

+

+ // Remove update without diff info if empty

+ if (count($file_update_info['update_without_diff']) < 1)

+ {

+ unset($file_update_info['update_without_diff']);

+ }

+

+

+ // Remove files to delete list if empty

+ if (count($file_update_info['delete']) < 1)

+ {

+ unset($file_update_info['delete']);

+ }

+ if ($this->update_helper->phpbb_version_compare($update_info['version']['from'], $version, '>='))

+ 'submit_continue_file_update' => array(

+ 'label' => 'UPDATE_CONTINUE_FILE_UPDATE',

+ 'type' => 'submit',

+ ORDER BY m2.left_id";

+ 'type' => $type,

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

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

+ 'group' => 'NOTIFICATION_GROUP_MISCELLANEOUS',

+ 'method' => $method,

+use phpbb\notification\type\type_interface;

+

+ *

+ * @param type_interface $notification_type An optional instance of a notification type. If provided, this

+ * method additionally checks if the type provides an email template.

+ * @return bool

+ public function is_available(type_interface $notification_type = null)

+ return parent::is_available($notification_type) && $this->config['email_enable'] && $this->user->data['user_email'];

+use phpbb\notification\type\type_interface;

+

+ *

+ * @param type_interface $notification_type An optional instance of a notification type. If provided, this

+ * method additionally checks if the type provides an email template.

+ * @return bool

+ public function is_available(type_interface $notification_type = null)

+ return parent::is_available($notification_type) && $this->global_available() && $this->user->data['user_jabber'];

+use phpbb\notification\type\type_interface;

+

+ * Is this method available for the user?

+ * This is checked on the notifications options

+ *

+ * @param type_interface $notification_type An optional instance of a notification type. This method returns false

+ * only if the type is provided and if it doesn't provide an email template.

+ * @return bool

+ */

+ public function is_available(type_interface $notification_type = null)

+ {

+ return $notification_type === null || $notification_type->get_email_template() !== false;

+ }

+

+ /**

+ $data_array = array_merge(array(

+ 'post_time' => $post['post_time'],

+ 'post_id' => $post['post_id'],

+ 'topic_id' => $post['topic_id']

+ ), $this->get_data(false));

+

+ return $data_array;

+ return floor((int) $start / (int) $per_page) + 1;

+ $password_old_format = addslashes($password_old_format);

+ $always_now = $this->request->variable('always_now', -1);

+ for ($i = 1901; $i <= $now['year'] + 50; $i++)

+ // Check for not allowed search queries for InnoDB.

+ // We assume similar restrictions for MyISAM, which is usually even

+ // slower but not as restrictive as InnoDB.

+ // InnoDB full-text search does not support the use of a leading

+ // plus sign with wildcard ('+*'), a plus and minus sign

+ // combination ('+-'), or leading a plus and minus sign combination.

+ // InnoDB full-text search only supports leading plus or minus signs.

+ // For example, InnoDB supports '+apple' but does not support 'apple+'.

+ // Specifying a trailing plus or minus sign causes InnoDB to report

+ // a syntax error. InnoDB full-text search does not support the use

+ // of multiple operators on a single search word, as in this example:

+ // '++apple'. Use of multiple operators on a single search word

+ // returns a syntax error to standard out.

+ // Also, ensure that the wildcard character is only used at the

+ // end of the line as it's intended by MySQL.

+ if (preg_match('#^(\+[+-]|\+\*|.+[+-]$|.+\*(?!$))#', $word))

+ {

+ unset($this->split_words[$i]);

+ continue;

+ }

+

+ $alter_list = array();

+ $alter_entry = array();

+ $alter_entry[] = 'MODIFY post_subject varchar(255) COLLATE utf8_unicode_ci DEFAULT \'\' NOT NULL';

+ $alter_entry[] = 'MODIFY post_subject text NOT NULL';

+ $alter_entry[] = 'ADD FULLTEXT (post_subject)';

+ $alter_list[] = $alter_entry;

+ $alter_entry = array();

+ $alter_entry[] = 'MODIFY post_text mediumtext COLLATE utf8_unicode_ci NOT NULL';

+ $alter_entry[] = 'MODIFY post_text mediumtext NOT NULL';

+ $alter_entry[] = 'ADD FULLTEXT post_content (post_text, post_subject)';

+ $alter_list[] = $alter_entry;

+ if (sizeof($alter_list))

+ foreach ($alter_list as $alter)

+ {

+ $this->db->sql_query('ALTER TABLE ' . POSTS_TABLE . ' ' . implode(', ', $alter));

+ }

+ $this->word_length = array('min' => (int) $this->config['fulltext_native_min_chars'], 'max' => (int) $this->config['fulltext_native_max_chars']);

+ // Is user banned? Are they excluded? Won't return on ban, exists within method

+ $this->check_ban_for_current_session($config);

+

+ $this->check_ban_for_current_session($config);

+ AND session_time >= ' . (int) ($this->time_now - (max((int) $config['session_length'], (int) $config['form_token_lifetime'])));

+ // To circumvent session_begin returning a valid value and the check_ban() not called on second page view, we kill the session again

+ $this->session_kill(false);

+

+ * Check the current session for bans

+ *

+ * @return true if session user is banned.

+ */

+ protected function check_ban_for_current_session($config)

+ {

+ if (!defined('SKIP_CHECK_BAN') && $this->data['user_type'] != USER_FOUNDER)

+ {

+ if (!$config['forwarded_for_check'])

+ {

+ $this->check_ban($this->data['user_id'], $this->ip);

+ }

+ else

+ {

+ $ips = explode(' ', $this->forwarded_for);

+ $ips[] = $this->ip;

+ $this->check_ban($this->data['user_id'], $ips);

+ }

+ }

+ }

+

+ /**

+ if ($this->time_now - ((isset($this->data['session_time'])) ? $this->data['session_time'] : 0) > 60 || ($this->update_session_page && $this->data['session_page'] != $this->page['page']))

+ public function retrieve_vars(array $vararray)

+ {

+ $result = array();

+ foreach ($vararray as $varname)

+ {

+ $result[$varname] = $this->retrieve_var($varname);

+ }

+ return $result;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function retrieve_var($varname)

+ {

+ return $this->context->retrieve_var($varname);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function retrieve_block_vars($blockname, array $vararray)

+ {

+ return $this->context->retrieve_block_vars($blockname, $vararray);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ * {@inheritdoc}

+ */

+ public function find_key_index($blockname, $key)

+ {

+ return $this->context->find_key_index($blockname, $key);

+ }

+

+ /**

+ * Retreive a single scalar value from a single key.

+ *

+ * @param string $varname Variable name

+ * @return mixed Variable value, or null if not set

+ */

+ public function retrieve_var($varname)

+ {

+ return isset($this->rootref[$varname]) ? $this->rootref[$varname] : null;

+ }

+

+ /**

+ * Retrieve key variable pairs from the specified block

+ *

+ * @param string $blockname Name of block to retrieve $vararray from

+ * @param array $vararray An array of variable names, empty array retrieves all vars

+ * @return array of hashes with variable name as key and retrieved value or null as value

+ */

+ public function retrieve_block_vars($blockname, array $vararray)

+ {

+ // For nested block, $blockcount > 0, for top-level block, $blockcount == 0

+ $blocks = explode('.', $blockname);

+ $blockcount = sizeof($blocks) - 1;

+

+ $block = $this->tpldata;

+ for ($i = 0; $i <= $blockcount; $i++)

+ {

+ if (($pos = strpos($blocks[$i], '[')) !== false)

+ {

+ $name = substr($blocks[$i], 0, $pos);

+

+ if (strpos($blocks[$i], '[]') === $pos)

+ {

+ $index = sizeof($block[$name]) - 1;

+ }

+ else

+ {

+ $index = min((int) substr($blocks[$i], $pos + 1, -1), sizeof($block[$name]) - 1);

+ }

+ }

+ else

+ {

+ $name = $blocks[$i];

+ $index = sizeof($block[$name]) - 1;

+ }

+ $block = $block[$name];

+ $block = $block[$index];

+ }

+

+ $result = array();

+ if ($vararray === array())

+ {

+ // The calculated vars that depend on the block position are excluded from the complete block returned results

+ $excluded_vars = array('S_FIRST_ROW', 'S_LAST_ROW', 'S_BLOCK_NAME', 'S_NUM_ROWS', 'S_ROW_COUNT', 'S_ROW_NUM');

+

+ foreach ($block as $varname => $varvalue)

+ {

+ if ($varname === strtoupper($varname) && !is_array($varvalue) && !in_array($varname, $excluded_vars))

+ {

+ $result[$varname] = $varvalue;

+ }

+ }

+ }

+ else

+ {

+ foreach ($vararray as $varname)

+ {

+ $result[$varname] = isset($block[$varname]) ? $block[$varname] : null;

+ }

+ }

+ return $result;

+ }

+

+ /**

+ * Find the index for a specified key in the innermost specified block

+ *

+ * @param string $blockname the blockname, for example 'loop'

+ * @param mixed $key Key to search for

+ *

+ * array: KEY => VALUE [the key/value pair to search for within the loop to determine the correct position]

+ *

+ * int: Position [the position to search for]

+ *

+ * If key is false the position is set to 0

+ * If key is true the position is set to the last entry

+ *

+ * @return mixed false if not found, index position otherwise; be sure to test with ===

+ */

+ public function find_key_index($blockname, $key)

+ {

+ // For nested block, $blockcount > 0, for top-level block, $blockcount == 0

+ $blocks = explode('.', $blockname);

+ $blockcount = sizeof($blocks) - 1;

+

+ $block = $this->tpldata;

+ for ($i = 0; $i < $blockcount; $i++)

+ {

+ if (($pos = strpos($blocks[$i], '[')) !== false)

+ {

+ $name = substr($blocks[$i], 0, $pos);

+

+ if (strpos($blocks[$i], '[]') === $pos)

+ {

+ $index = sizeof($block[$name]) - 1;

+ }

+ else

+ {

+ $index = min((int) substr($blocks[$i], $pos + 1, -1), sizeof($block[$name]) - 1);

+ }

+ }

+ else

+ {

+ $name = $blocks[$i];

+ $index = sizeof($block[$name]) - 1;

+ }

+ if (!isset($block[$name]))

+ {

+ return false;

+ }

+ $block = $block[$name];

+ if (!isset($block[$index]))

+ {

+ return false;

+ }

+ $block = $block[$index];

+ }

+

+ if (!isset($block[$blocks[$i]]))

+ {

+ return false;

+ }

+ $block = $block[$blocks[$i]]; // Traverse the last block

+

+ // Change key to zero (change first position) if false and to last position if true

+ if ($key === false || $key === true)

+ {

+ return ($key === false) ? 0 : sizeof($block) - 1;

+ }

+

+ // Get correct position if array given

+ if (is_array($key))

+ {

+ // Search array to get correct position

+ list($search_key, $search_value) = @each($key);

+ foreach ($block as $i => $val_ary)

+ {

+ if ($val_ary[$search_key] === $search_value)

+ {

+ return $i;

+ }

+ }

+ }

+

+ return (is_int($key) && ((0 <= $key) && ($key < sizeof($block)))) ? $key : false;

+ }

+

+ /**

+ * @param string $mode Mode to execute (valid modes are 'insert', 'change' and 'delete')

+ * If delete, the vararray is ignored, and the block at the given position (counting from zero) is removed.

+ // For nested block, $blockcount > 0, for top-level block, $blockcount == 0

+ $blocks = explode('.', $blockname);

+ $blockcount = sizeof($blocks) - 1;

+

+ $block = &$this->tpldata;

+ for ($i = 0; $i < $blockcount; $i++)

+ {

+ if (($pos = strpos($blocks[$i], '[')) !== false)

+ $name = substr($blocks[$i], 0, $pos);

+

+ if (strpos($blocks[$i], '[]') === $pos)

+ $index = sizeof($block[$name]) - 1;

+ $index = min((int) substr($blocks[$i], $pos + 1, -1), sizeof($block[$name]) - 1);

+ else

+ {

+ $name = $blocks[$i];

+ $index = sizeof($block[$name]) - 1;

+ }

+ $block = &$block[$name];

+ $block = &$block[$index];

+ $name = $blocks[$i];

+

+ // If last block does not exist and we are inserting, and not searching for key, we create it empty; otherwise, nothing to do

+ if (!isset($block[$name]))

+ if ($mode != 'insert' || is_array($key))

+ {

+ return false;

+ }

+ $block[$name] = array();

+ $block = &$block[$name]; // Now we can traverse the last block

+

+ if ($key >= sizeof($block))

+ $key = sizeof($block);

+ unset($block[($key - 1)]['S_LAST_ROW']);

+ if ($key <= 0)

+ $key = 0;

+ unset($block[0]['S_FIRST_ROW']);

+ $vararray['S_BLOCK_NAME'] = $name;

+ // If key is out of bounds, do not change anything

+ if ($key > sizeof($block) || $key < 0)

+ {

+ return false;

+ }

+

+ // Delete Block

+ if ($mode == 'delete')

+ {

+ // If we are exceeding last iteration, do not delete anything

+ if ($key > sizeof($block) || $key < 0)

+ {

+ return false;

+ }

+

+ // If we are positioned at the end, we remove the last element

+ if ($key == sizeof($block))

+ {

+ $key--;

+ }

+

+ // We are deleting the last element in the block, so remove the block

+ if (sizeof($block) === 1)

+ {

+ $block = null; // unset($block); does not work on references

+ return true;

+ }

+

+ // Re-position template blocks

+ for ($i = $key; $i < sizeof($block)-1; $i++)

+ {

+ $block[$i] = $block[$i+1];

+ $block[$i]['S_ROW_COUNT'] = $block[$i]['S_ROW_NUM'] = $i;

+ }

+

+ // Remove the last element

+ unset($block[$i]);

+

+ // Set first and last elements again, in case they were removed

+ $block[0]['S_FIRST_ROW'] = true;

+ $block[sizeof($block)-1]['S_LAST_ROW'] = true;

+

+ return true;

+ }

+

+ * Retrieve multiple template values

+ *

+ * @param array $vararray An array with variable names

+ * @return array A hash of variable name => value pairs (value is null if not set)

+ */

+ public function retrieve_vars(array $vararray);

+

+ /**

+ * Retreive a single scalar value from a single key.

+ *

+ * @param string $varname Variable name

+ * @return mixed Variable value, or null if not set

+ */

+ public function retrieve_var($varname);

+

+ /**

+ * Retrieve variable values from an specified block

+ * @param string $blockname Name of block to retrieve $vararray from

+ * @param array $vararray An array with variable names, empty array gets all vars

+ * @return array A hash of variable name => value pairs (value is null if not set)

+ */

+ public function retrieve_block_vars($blockname, array $vararray);

+

+ /**

+ * @param string $mode Mode to execute (valid modes are 'insert', 'change' and 'delete')

+ * If delete, the vararray is ignored, and the block at the given position (counting from zero) is removed.

+ * Find the index for a specified key in the innermost specified block

+ *

+ * @param string $blockname the blockname, for example 'loop'

+ * @param mixed $key Key to search for

+ *

+ * array: KEY => VALUE [the key/value pair to search for within the loop to determine the correct position]

+ *

+ * int: Position [the position to search for]

+ *

+ * If key is false the position is set to 0

+ * If key is true the position is set to the last entry

+ *

+ * @return mixed false if not found, index position otherwise; be sure to test with ===

+ */

+ public function find_key_index($blockname, $key);

+

+ /**

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

+ protected $phpbb_dispatcher;

+

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

+ public function __construct(\phpbb\config\config $phpbb_config, \phpbb\filesystem\filesystem $filesystem, \phpbb\path_helper $path_helper, $cache_path, \phpbb\extension\manager $extension_manager = null, \Twig_LoaderInterface $loader = null, \phpbb\event\dispatcher_interface $phpbb_dispatcher = null, $options = array())

+ $this->phpbb_dispatcher = $phpbb_dispatcher;

+ /**

+ * Allow changing the template output stream before rendering

+ *

+ * @event core.twig_environment_render_template_before

+ * @var array context Array with template variables

+ * @var string name The template name

+ * @since 3.2.1-RC1

+ */

+ if ($this->phpbb_dispatcher)

+ {

+ $vars = array('context', 'name');

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

+ }

+

+ /**

+ * Allow changing the template output stream after rendering

+ *

+ * @event core.twig_environment_render_template_after

+ * @var array context Array with template variables

+ * @var string name The template name

+ * @var string output Rendered template output stream

+ * @since 3.2.1-RC1

+ */

+ if ($this->phpbb_dispatcher)

+ {

+ $vars = array('context', 'name', 'output');

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

+ }

+

+ $context_vars = $this->context->get_root_ref();

+ // Handle \Twig_Source format input

+ if ($code instanceof \Twig_Source)

+ {

+ $source = $code;

+ $code = $source->getCode();

+ $filename = $source->getName();

+ }

+

+ // Tokenize \Twig_Source instance

+ return parent::tokenize(new \Twig_Source($code, $filename));

+ parent::__construct($paths, $this->filesystem->realpath(dirname(__FILE__)));

+ return $this->fetch_decoded_rowset($sql, ['bbcode_match']);

+ return $this->fetch_decoded_rowset($sql, ['code', 'emotion', 'smiley_url']);

+ return $this->fetch_decoded_rowset($sql);

+

+ return $this->fetch_decoded_rowset($sql, ['word', 'replacement']);

+ }

+

+ /**

+ * Decode HTML special chars in given rowset

+ *

+ * @param array $rows Original rowset

+ * @param array $columns List of columns to decode

+ * @return array Decoded rowset

+ */

+ protected function decode_rowset(array $rows, array $columns)

+ {

+ foreach ($rows as &$row)

+ {

+ foreach ($columns as $column)

+ {

+ $row[$column] = htmlspecialchars_decode($row[$column]);

+ }

+ }

+

+ return $rows;

+ }

+

+ /**

+ * Fetch all rows for given query and decode plain text columns

+ *

+ * @param string $sql SELECT query

+ * @param array $columns List of columns to decode

+ * @return array

+ */

+ protected function fetch_decoded_rowset($sql, array $columns = [])

+ {

+ return $this->decode_rowset($rows, $columns);

+ '<img class="smilies" src="{$T_SMILIES_PATH}/' . $this->escape_html_attribute($row['smiley_url']) . '" width="' . $row['smiley_width'] . '" height="' . $row['smiley_height'] . '" alt="{.}" title="' . $this->escape_html_attribute($row['emotion']) . '"/>'

+

+ // Ignore emoticons that are immediately followed by a "word" character

+ $configurator->Emoticons->notBefore = '\\w';

+ $configurator->Censor->add($row['word'], $row['replacement']);

+ $configurator->Emoji->omitImageSize();

+ $tag->template = '<xsl:choose><xsl:when test="$S_VIEWSMILIES">' . str_replace('class="emoji"', 'class="emoji smilies"', $tag->template) . '</xsl:when><xsl:otherwise><xsl:value-of select="."/></xsl:otherwise></xsl:choose>';

+ * Escape a literal to be used in an HTML attribute in an XSL template

+ *

+ * Escapes "HTML special chars" for obvious reasons and curly braces to avoid them

+ * being interpreted as an attribute value template

+ *

+ * @param string $value Original string

+ * @return string Escaped string

+ */

+ protected function escape_html_attribute($value)

+ {

+ return htmlspecialchars(strtr($value, ['{' => '{{', '}' => '}}']), ENT_COMPAT | ENT_XML1, 'UTF-8');

+ }

+

+ /**

+ $this->parser->disablePlugin('Emoji');

+ $this->parser->enablePlugin('Emoji');

+ $this->post_url = append_sid($root_path . 'viewtopic.' . $php_ext, 'p={POST_ID}#p{POST_ID}', false);

+ $this->profile_url = append_sid($root_path . 'memberlist.' . $php_ext, 'mode=viewprofile&u={USER_ID}', false);

+ $html = $this->renderer->render($xml);

+ $html = $this->censor->censorHtml($html, true);

+

+ /**

+ * {@inheritdoc}

+ */

+ public function is_empty($text)

+ {

+ if ($text === null || $text === '')

+ {

+ return true;

+ }

+

+ return trim($this->unparse($text)) === '';

+ }

+ * Return a parsed text to its original form

+ *

+ * @param string $text Parsed text

+ * @return string Original plain text

+ */

+

+ /**

+ * Return whether or not a parsed text represent an empty text.

+ *

+ * @param string $text Parsed text

+ * @return bool Tue if the original text is empty

+ */

+ public function is_empty($text);

+ global $phpbb_dispatcher;

+ $format_date_override = false;

+ $function_arguments = func_get_args();

+ /**

+ * Execute code and/or override format_date()

+ *

+ * To override the format_date() function generated value

+ * set $format_date_override to new return value

+ *

+ * @event core.user_format_date_override

+ * @var DateTimeZone utc Is DateTimeZone in UTC

+ * @var array function_arguments is array comprising a function's argument list

+ * @var string format_date_override Shall we return custom format (string) or not (false)

+ * @since 3.2.1-RC1

+ */

+ $vars = array('utc', 'function_arguments', 'format_date_override');

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

+ if (!$format_date_override)

+ {

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

+ $time->setTimezone($this->timezone);

+

+ return $time->format($format, $forcedate);

+ }

+ else

+ {

+ return $format_date_override;

+ }

+ protected $version_schema = array(

+ 'stable' => array(

+ 'current' => 'version',

+ 'download' => 'url',

+ 'announcement' => 'url',

+ 'eol' => 'url',

+ 'security' => 'bool',

+ ),

+ 'unstable' => array(

+ 'current' => 'version',

+ 'download' => 'url',

+ 'announcement' => 'url',

+ 'eol' => 'url',

+ 'security' => 'bool',

+ ),

+ );

+

+ // Filter out any versions less than the current version

+ * Gets the latest update for the current branch the user is on

+ * Will suggest versions from newer branches when EoL has been reached

+ * and/or version from newer branch is needed for having all known security

+ * issues fixed.

+ *

+ * @param bool $force_update Ignores cached data. Defaults to false.

+ * @param bool $force_cache Force the use of the cache. Override $force_update.

+ * @return array Version info or empty array if there are no updates

+ * @throws \RuntimeException

+ */

+ public function get_update_on_branch($force_update = false, $force_cache = false)

+ {

+ $versions = $this->get_versions_matching_stability($force_update, $force_cache);

+

+ $self = $this;

+ $current_version = $this->current_version;

+

+ // Filter out any versions less than the current version

+ $versions = array_filter($versions, function($data) use ($self, $current_version) {

+ return $self->compare($data['current'], $current_version, '>=');

+ });

+

+ // Get the lowest version from the previous list.

+ $update_info = array_reduce($versions, function($value, $data) use ($self, $current_version) {

+ if ($value === null && $self->compare($data['current'], $current_version, '>='))

+ {

+ if (!$data['eol'] && (!$data['security'] || $self->compare($data['security'], $data['current'], '<=')))

+ {

+ return ($self->compare($data['current'], $current_version, '>')) ? $data : array();

+ }

+ else

+ {

+ return null;

+ }

+ }

+

+ return $value;

+ });

+

+ return $update_info === null ? array() : $update_info;

+ }

+

+ /**

+ * Gets the latest extension update for the current phpBB branch the user is on

+ * Will suggest versions from newer branches when EoL has been reached

+ * and/or version from newer branch is needed for having all known security

+ * issues fixed.

+ *

+ * @param bool $force_update Ignores cached data. Defaults to false.

+ * @param bool $force_cache Force the use of the cache. Override $force_update.

+ * @return array Version info or empty array if there are no updates

+ * @throws \RuntimeException

+ */

+ public function get_ext_update_on_branch($force_update = false, $force_cache = false)

+ {

+ $versions = $this->get_versions_matching_stability($force_update, $force_cache);

+

+ $self = $this;

+ $current_version = $this->current_version;

+

+ // Get current phpBB branch from version, e.g.: 3.2

+ preg_match('/^(\d+\.\d+).*$/', $this->config['version'], $matches);

+ $current_branch = $matches[1];

+

+ // Filter out any versions less than the current version

+ $versions = array_filter($versions, function($data) use ($self, $current_version) {

+ return $self->compare($data['current'], $current_version, '>=');

+ });

+

+ // Filter out any phpbb branches less than the current version

+ $branches = array_filter(array_keys($versions), function($branch) use ($self, $current_branch) {

+ return $self->compare($branch, $current_branch, '>=');

+ });

+ if (!empty($branches))

+ {

+ $versions = array_intersect_key($versions, array_flip($branches));

+ }

+ else

+ {

+ // If branches are empty, it means the current phpBB branch is newer than any branch the

+ // extension was validated against. Reverse sort the versions array so we get the newest

+ // validated release available.

+ krsort($versions);

+ }

+

+ // Get the first available version from the previous list.

+ $update_info = array_reduce($versions, function($value, $data) use ($self, $current_version) {

+ if ($value === null && $self->compare($data['current'], $current_version, '>='))

+ {

+ if (!$data['eol'] && (!$data['security'] || $self->compare($data['security'], $data['current'], '<=')))

+ {

+ return $self->compare($data['current'], $current_version, '>') ? $data : array();

+ }

+ else

+ {

+ return null;

+ }

+ }

+

+ return $value;

+ });

+

+ return $update_info === null ? array() : $update_info;

+ }

+

+ /**

+ * @return array

+ * @return array Version info

+ * @return array Version info, includes stable and unstable data

+ $info = $this->validate_versions($info);

+

+

+ /**

+ * Validate versions info input

+ *

+ * @param array $versions_info Decoded json data array. Will be modified

+ * and cleaned by this method

+ *

+ * @return array Versions info array

+ * @throws version_check_exception

+ */

+ public function validate_versions($versions_info)

+ {

+ $array_diff = array_diff_key($versions_info, array($this->version_schema));

+

+ // Remove excessive data

+ if (count($array_diff) > 0)

+ {

+ $old_versions_info = $versions_info;

+ $versions_info = array(

+ 'stable' => !empty($old_versions_info['stable']) ? $old_versions_info['stable'] : array(),

+ 'unstable' => !empty($old_versions_info['unstable']) ? $old_versions_info['unstable'] : array(),

+ );

+ unset($old_versions_info);

+ }

+

+ foreach ($versions_info as $stability_type => &$versions_data)

+ {

+ foreach ($versions_data as $branch => &$version_data)

+ {

+ if (!preg_match('/^[0-9a-z\-\.]+$/i', $branch))

+ {

+ unset($versions_data[$branch]);

+ continue;

+ }

+

+ $stability_diff = array_diff_key($version_data, $this->version_schema[$stability_type]);

+

+ if (count($stability_diff) > 0)

+ {

+ $old_version_data = $version_data;

+ $version_data = array();

+ foreach ($this->version_schema[$stability_type] as $key => $value)

+ {

+ if (isset($old_version_data[$key]))

+ {

+ $version_data[$key] = $old_version_data[$key];

+ }

+ }

+ unset($old_version_data);

+ }

+

+ foreach ($version_data as $key => &$value)

+ {

+ if (!isset($this->version_schema[$stability_type][$key]))

+ {

+ unset($version_data[$key]);

+ throw new version_check_exception('VERSIONCHECK_INVALID_ENTRY');

+ }

+

+ switch ($this->version_schema[$stability_type][$key])

+ {

+ case 'bool':

+ $value = (bool) $value;

+ break;

+

+ case 'url':

+ if (!empty($value) && !preg_match('#^' . get_preg_expression('url') . '$#iu', $value) &&

+ !preg_match('#^' . get_preg_expression('www_url') . '$#iu', $value))

+ {

+ throw new version_check_exception('VERSIONCHECK_INVALID_URL');

+ }

+ break;

+

+ case 'version':

+ if (!empty($value) && !preg_match(get_preg_expression('semantic_version'), $value))

+ {

+ throw new version_check_exception('VERSIONCHECK_INVALID_VERSION');

+ }

+ break;

+

+ default:

+ // Shouldn't be possible to trigger this

+ throw new version_check_exception('VERSIONCHECK_INVALID_ENTRY');

+ }

+ }

+ }

+ }

+

+ return $versions_info;

+ }