+ public function get_auth_link_data($user_id = 0)

+ 'AUTH_LDAP_PASSORD' => $new_config['ldap_password'] !== '' ? '********' : '',

+ public function get_auth_link_data($user_id = 0)

+ 'user_id' => ($user_id <= 0) ? (int) $this->user->data['user_id'] : (int) $user_id,

+ // Remove user specified in $link_data if possible

+ $user_id = isset($link_data['user_id']) ? $link_data['user_id'] : $this->user->data['user_id'];

+

+ AND user_id = " . (int) $user_id;

+ * @param int $user_id User ID for whom the data should be retrieved.

+ * defaults to 0, which is not a valid ID. The method

+ * should fall back to the current user's ID in this

+ * case.

+ public function get_auth_link_data($user_id = 0);

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

+ /**

+ * phpBB root path

+ * @var string

+ */

+

+ /**

+ * PHP file extension

+ * @var string

+ */

+

+ /**

+ * Auth object

+ * @var \phpbb\auth\auth

+ */

+

+ /**

+ * Config object

+ * @var \phpbb\config\config

+ */

+

+ /**

+ * Database object

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

+ */

+

+ /**

+ * User object

+ * @var \phpbb\user

+ */

+ * Event dispatcher object

+ * @var \phpbb\event\dispatcher_interface

+ */

+ protected $phpbb_dispatcher;

+

+ /**

+ * @param string $phpbb_root_path The phpBB root path

+ * @param \phpbb\auth\auth $auth The auth object

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

+ * @param \phpbb\db\driver\driver_interface $db The database object

+ * @param \phpbb\user $user The user object

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

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

+ $this->phpbb_dispatcher = $phpbb_dispatcher;

+ $search = new $search_type($error, $this->phpbb_root_path, $this->php_ext, $this->auth, $this->config, $this->db, $this->user, $this->phpbb_dispatcher);

+ else if ($this->db->get_sql_layer() === 'mssqlnative')

+class acp_prune_users_module extends \phpbb\db\migration\container_aware_migration

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

+ $module_manager->move_module($acp_prune_users_id, $acp_cat_users_id, 'acp');

+class dev extends \phpbb\db\migration\container_aware_migration

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

+ $module_manager->move_module($language_module_id, $language_management_module_id, 'acp');

+ $this->sql_query('DELETE FROM ' . STYLES_TABLE);

+ FROM ' . STYLES_TABLE . "

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

+<?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 v315 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

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

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

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

+ );

+ }

+}

+<?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 v315rc1 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

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

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

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

+ );

+ }

+}

+use phpbb\module\exception\module_exception;

+

+ /** @var \phpbb\module\module_manager */

+ protected $module_manager;

+

+ * @param \phpbb\module\module_manager $module_manager

+ public function __construct(\phpbb\db\driver\driver_interface $db, \phpbb\cache\service $cache, \phpbb\user $user, \phpbb\module\module_manager $module_manager, $phpbb_root_path, $php_ext, $modules_table)

+ $this->module_manager = $module_manager;

+ try

+ $this->module_manager->update_module_data($module_data);

+

+ catch (module_exception $e)

+ {

+ // Error

+ throw new \phpbb\db\migration\exception('MODULE_ERROR', $e->getMessage());

+ }

+ $this->module_manager->delete_module($module_id, $class);

+ $module = $this->module_manager->get_module_infos($class, $basename, true);

+ $sql = 'SELECT role_name, role_type

+ $role_data = $this->db->sql_fetchrow();

+ $role_name = $role_data['role_name'];

+ $role_type = $role_data['role_type'];

+

+ // Filter new auth options to match the role type: a_ | f_ | m_ | u_

+ // Set new auth options to the role only if options matching the role type were found

+ $auth_option = array_filter($auth_option,

+ function ($option) use ($role_type)

+ {

+ return strpos($option, $role_type) === 0;

+ }

+ );

+

+ if (sizeof($auth_option))

+ {

+ return $this->permission_set($role_name, $auth_option, 'role', $has_permission);

+ }

+ * @param array $rows

+use phpbb\filesystem\filesystem;

+use Symfony\Component\Filesystem\Exception\IOException;

+ * @var string The environment to use.

+ */

+ protected $environment;

+

+ /**

+ * The container under construction

+ *

+ * @var ContainerBuilder

+ */

+ * Indicates whether extensions should be used (default to true).

+ *

+ * @var bool

+ */

+ * Defines a custom path to find the configuration of the container (default to $this->phpbb_root_path . 'config')

+ *

+ * @var string

+ */

+ * Indicates whether the container should be dumped to the filesystem (default to true).

+ *

+ * If DEBUG_CONTAINER is set this option is ignored and a new container is build.

+ *

+ * @var bool

+ */

+ protected $use_cache = true;

+ * Indicates if the container should be compiled automatically (default to true).

+ *

+ * @var bool

+ */

+ * Custom parameters to inject into the container.

+ *

+ * Default to:

+ * array(

+ * 'core.root_path', $this->phpbb_root_path,

+ * 'core.php_ext', $this->php_ext,

+ * );

+ *

+ * @var array

+ */

+ * @var \phpbb\config_php_file

+ */

+ * @var array

+ */

+ private $container_extensions;

+

+ /**

+ * Constructor

+ *

+ * @param string $phpbb_root_path Path to the phpbb includes directory.

+ * @param string $php_ext php file extension

+ */

+ function __construct($phpbb_root_path, $php_ext)

+ * Build and return a new Container respecting the current configuration

+ *

+ * @return \phpbb_cache_container|ContainerBuilder

+ */

+ if ($this->use_cache && $config_cache->isFresh())

+ $this->container_extensions = array(new extension\core($this->get_config_path()));

+ $this->load_extensions();

+ // Inject the config

+ if ($this->config_php_file)

+ $this->container_extensions[] = new extension\config($this->config_php_file);

+ $this->container = $this->create_container($this->container_extensions);

+ // Easy collections through tags

+ $this->container->addCompilerPass(new pass\collection_pass());

+ // Event listeners "phpBB style"

+ $this->container->addCompilerPass(new RegisterListenersPass('dispatcher', 'event.listener_listener', 'event.listener'));

+ // Event listeners "Symfony style"

+ $this->container->addCompilerPass(new RegisterListenersPass('dispatcher'));

+

+ $filesystem = new filesystem();

+ $loader = new YamlFileLoader($this->container, new FileLocator($filesystem->realpath($this->get_config_path())));

+ if ($this->use_cache)

+ {

+ $this->dump_container($config_cache);

+ }

+ if ($this->compile_container && $this->config_php_file)

+ $this->container->set('config.php', $this->config_php_file);

+ * Enable the extensions.

+ *

+ * @param string $environment The environment to use

+ * @return $this

+ */

+ public function with_environment($environment)

+ {

+ $this->environment = $environment;

+

+ return $this;

+ }

+

+ /**

+ * Enable the extensions.

+ *

+ * @return $this

+ */

+ public function with_extensions()

+ $this->use_extensions = true;

+

+ return $this;

+ }

+

+ /**

+ * Disable the extensions.

+ *

+ * @return $this

+ */

+ public function without_extensions()

+ {

+ $this->use_extensions = false;

+

+ return $this;

+ * Enable the caching of the container.

+ *

+ * If DEBUG_CONTAINER is set this option is ignored and a new container is build.

+ *

+ * @return $this

+ */

+ public function with_cache()

+ $this->use_cache = true;

+

+ return $this;

+ * Disable the caching of the container.

+ *

+ * @return $this

+ */

+ public function without_cache()

+ $this->use_cache = false;

+

+ return $this;

+ * Set the cache directory.

+ *

+ * @param string $cache_dir The cache directory.

+ * @return $this

+ */

+ public function with_cache_dir($cache_dir)

+ $this->cache_dir = $cache_dir;

+

+ return $this;

+ * Enable the compilation of the container.

+ *

+ * @return $this

+ */

+ public function with_compiled_container()

+ $this->compile_container = true;

+

+ return $this;

+ * Disable the compilation of the container.

+ *

+ * @return $this

+ */

+ public function without_compiled_container()

+ $this->compile_container = false;

+

+ return $this;

+ * Set a custom path to find the configuration of the container.

+ *

+ * @param string $config_path

+ * @return $this

+ */

+ public function with_config_path($config_path)

+

+ return $this;

+ * Set custom parameters to inject into the container.

+ * @param array $custom_parameters

+ * @return $this

+ public function with_custom_parameters($custom_parameters)

+ $this->custom_parameters = $custom_parameters;

+

+ return $this;

+ * Set custom parameters to inject into the container.

+ *

+ * @param \phpbb\config_php_file $config_php_file

+ * @return $this

+ */

+ public function with_config(\phpbb\config_php_file $config_php_file)

+ $this->config_php_file = $config_php_file;

+

+ return $this;

+ * Returns the path to the container configuration (default: root_path/config)

+ * @return string

+ protected function get_config_path()

+ return $this->config_path ?: $this->phpbb_root_path . 'config';

+ * Load the enabled extensions.

+ */

+ protected function load_extensions()

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

+ {

+ // Build an intermediate container to load the ext list from the database

+ $container_builder = new container_builder($this->phpbb_root_path, $this->php_ext);

+ $ext_container = $container_builder

+ ->without_cache()

+ ->without_extensions()

+ ->with_config($this->config_php_file)

+ ->with_environment('production')

+ ->without_compiled_container()

+ ->get_container()

+ ;

+

+ $ext_container->register('cache.driver', '\\phpbb\\cache\\driver\\dummy');

+ $ext_container->compile();

+

+ $extensions = $ext_container->get('ext.manager')->all_enabled();

+

+ // Load each extension found

+ foreach ($extensions as $ext_name => $path)

+ {

+ $extension_class = '\\' . str_replace('/', '\\', $ext_name) . '\\di\\extension';

+ if (!class_exists($extension_class))

+ {

+ $extension_class = '\\phpbb\\extension\\di\\extension_base';

+ }

+ $this->container_extensions[] = new $extension_class($ext_name, $path);

+ // Load extension autoloader

+ $filename = $path . 'vendor/autoload.php';

+ if (file_exists($filename))

+ {

+ require $filename;

+ }

+ }

+ }

+ else

+ // To load the extensions we need the database credentials.

+ // Automatically disable the extensions if we don't have them.

+ $this->use_extensions = false;

+ * Dump the container to the disk.

+ *

+ * @param ConfigCache $cache The config cache

+ */

+ protected function dump_container($cache)

+ try

+ {

+ $dumper = new PhpDumper($this->container);

+ $cached_container_dump = $dumper->dump(array(

+ 'class' => 'phpbb_cache_container',

+ 'base_class' => 'Symfony\\Component\\DependencyInjection\\ContainerBuilder',

+ ));

+ $cache->write($cached_container_dump, $this->container->getResources());

+ }

+ catch (IOException $e)

+ // Don't fail if the cache isn't writeable

+ * Create the ContainerBuilder object

+ *

+ * @param array $extensions Array of Container extension objects

+ * @return ContainerBuilder object

+ */

+ * Get the filename under which the dumped container will be stored.

+ *

+ * @return string Path for dumped container

+ */

+ return $this->get_cache_dir() . 'container_' . md5($this->phpbb_root_path) . '.' . $this->php_ext;

+ return $this->environment ?: PHPBB_ENVIRONMENT;

+ $twig_environment_options = $definition->getArgument(7);

+ // Replace the 8th argument, the options passed to the environment

+ $definition->replaceArgument(7, $twig_environment_options);

+

+ $changed_versions = array();

+ if (strpos($details, "\n* Changed: ") !== false)

+ {

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

+ while (strpos($details, "\n* Changed: ") !== false)

+ {

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

+ $changed_versions[] = $changed;

+ }

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

+ $changed_versions[] = $changed;

+ }

+ else

+ {

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

+ $changed_versions = array();

+ }

+ $changes = array();

+ foreach ($changed_versions as $changed)

+ {

+ list($changed_version, $changed_description) = $this->validate_changed($changed);

+

+ if (isset($changes[$changed_version]))

+ {

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

+ }

+

+ $changes[$changed_version] = $changed_description;

+ }

+ $description = trim($description, "\n") . "\n";

+ $is_filtered = false;

+ foreach ($changes as $version => $null)

+ {

+ if ($this->version_is_filtered($version))

+ {

+ $is_filtered = true;

+ break;

+ }

+ }

+

+ if (!$is_filtered)

+ {

+ continue;

+ }

+ 'changed' => $changes,

+ * @return bool

+ if (!$this->validate_version($since))

+ * Validate "Changed" Information

+ *

+ * @param string $changed

+ * @return string

+ * @throws \LogicException

+ */

+ public function validate_changed($changed)

+ {

+ if (strpos($changed, ' ') !== false)

+ {

+ list($version, $description) = explode(' ', $changed, 2);

+ }

+ else

+ {

+ $version = $changed;

+ $description = '';

+ }

+

+ if (!$this->validate_version($version))

+ {

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

+ }

+

+ return array($version, $description);

+ }

+

+ /**

+ * Validate "version" Information

+ *

+ * @param string $version

+ * @return bool True if valid, false otherwise

+ */

+ public function validate_version($version)

+ {

+ return preg_match('#^\d+\.\d+\.\d+(?:-(?:a|b|RC|pl)\d+)?$#', $version);

+ }

+

+ /**

+ * @return bool

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

+

+/**

+ * BBCode help page

+ */

+class bbcode extends controller

+{

+ /**

+ * @return string The title of the page

+ */

+ public function display()

+ {

+ $this->language->add_lang('help/bbcode');

+

+ $this->manager->add_block(

+ 'HELP_BBCODE_BLOCK_INTRO',

+ false,

+ array(

+ 'HELP_BBCODE_INTRO_BBCODE_QUESTION' => 'HELP_BBCODE_INTRO_BBCODE_ANSWER',

+ )

+ );

+ $this->manager->add_block(

+ 'HELP_BBCODE_BLOCK_TEXT',

+ false,

+ array(

+ 'HELP_BBCODE_TEXT_BASIC_QUESTION' => 'HELP_BBCODE_TEXT_BASIC_ANSWER',

+ 'HELP_BBCODE_TEXT_COLOR_QUESTION' => 'HELP_BBCODE_TEXT_COLOR_ANSWER',

+ 'HELP_BBCODE_TEXT_COMBINE_QUESTION' => 'HELP_BBCODE_TEXT_COMBINE_ANSWER',

+ )

+ );

+ $this->manager->add_block(

+ 'HELP_BBCODE_BLOCK_QUOTES',

+ false,

+ array(

+ 'HELP_BBCODE_QUOTES_TEXT_QUESTION' => 'HELP_BBCODE_QUOTES_TEXT_ANSWER',

+ 'HELP_BBCODE_QUOTES_CODE_QUESTION' => 'HELP_BBCODE_QUOTES_CODE_ANSWER',

+ )

+ );

+ $this->manager->add_block(

+ 'HELP_BBCODE_BLOCK_LISTS',

+ false,

+ array(

+ 'HELP_BBCODE_LISTS_UNORDERER_QUESTION' => 'HELP_BBCODE_LISTS_UNORDERER_ANSWER',

+ 'HELP_BBCODE_LISTS_ORDERER_QUESTION' => 'HELP_BBCODE_LISTS_ORDERER_ANSWER',

+ )

+ );

+ $this->manager->add_block(

+ 'HELP_BBCODE_BLOCK_LINKS',

+ true,

+ array(

+ 'HELP_BBCODE_LINKS_BASIC_QUESTION' => 'HELP_BBCODE_LINKS_BASIC_ANSWER',

+ )

+ );

+ $this->manager->add_block(

+ 'HELP_BBCODE_BLOCK_IMAGES',

+ false,

+ array(

+ 'HELP_BBCODE_IMAGES_BASIC_QUESTION' => 'HELP_BBCODE_IMAGES_BASIC_ANSWER',

+ 'HELP_BBCODE_IMAGES_ATTACHMENT_QUESTION' => 'HELP_BBCODE_IMAGES_ATTACHMENT_ANSWER',

+ )

+ );

+ $this->manager->add_block(

+ 'HELP_BBCODE_BLOCK_OTHERS',

+ false,

+ array(

+ 'HELP_BBCODE_OTHERS_CUSTOM_QUESTION' => 'HELP_BBCODE_OTHERS_CUSTOM_ANSWER',

+ )

+ );

+

+ return $this->language->lang('BBCODE_GUIDE');

+ }

+}

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

+

+/**

+ * BBCode help page

+ */

+abstract class controller

+{

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

+ protected $helper;

+

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

+ protected $manager;

+

+ /** @var \phpbb\template\template */

+ protected $template;

+

+ /** @var \phpbb\language\language */

+ protected $language;

+

+ /** @var string */

+ protected $root_path;

+

+ /** @var string */

+ protected $php_ext;

+

+ /**

+ * Constructor

+ *

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

+ * @param \phpbb\help\manager $manager

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

+ * @param \phpbb\language\language $language

+ * @param string $root_path

+ * @param string $php_ext

+ */

+ public function __construct(\phpbb\controller\helper $helper, \phpbb\help\manager $manager, \phpbb\template\template $template, \phpbb\language\language $language, $root_path, $php_ext)

+ {

+ $this->helper = $helper;

+ $this->manager = $manager;

+ $this->template = $template;

+ $this->language = $language;

+ $this->root_path = $root_path;

+ $this->php_ext = $php_ext;

+ }

+

+ /**

+ * @return string

+ */

+ abstract protected function display();

+

+ public function handle()

+ {

+ $title = $this->display();

+

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

+ 'L_FAQ_TITLE' => $title,

+ 'S_IN_FAQ' => true,

+ ));

+

+ make_jumpbox(append_sid("{$this->root_path}viewforum.{$this->php_ext}"));

+ return $this->helper->render('faq_body.html', $title);

+ }

+}

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

+

+/**

+ * FAQ help page

+ */

+class faq extends controller

+{

+ /**

+ * @return string The title of the page

+ */

+ public function display()

+ {

+ $this->language->add_lang('help/faq');

+

+ $this->manager->add_block(

+ 'HELP_FAQ_BLOCK_LOGIN',

+ false,

+ array(

+ 'HELP_FAQ_LOGIN_REGISTER_QUESTION' => 'HELP_FAQ_LOGIN_REGISTER_ANSWER',

+ 'HELP_FAQ_LOGIN_COPPA_QUESTION' => 'HELP_FAQ_LOGIN_COPPA_ANSWER',

+ 'HELP_FAQ_LOGIN_CANNOT_REGISTER_QUESTION' => 'HELP_FAQ_LOGIN_CANNOT_REGISTER_ANSWER',

+ 'HELP_FAQ_LOGIN_REGISTER_CONFIRM_QUESTION' => 'HELP_FAQ_LOGIN_REGISTER_CONFIRM_ANSWER',

+ 'HELP_FAQ_LOGIN_CANNOT_LOGIN_QUESTION' => 'HELP_FAQ_LOGIN_CANNOT_LOGIN_ANSWER',

+ 'HELP_FAQ_LOGIN_CANNOT_LOGIN_ANYMORE_QUESTION' => 'HELP_FAQ_LOGIN_CANNOT_LOGIN_ANYMORE_ANSWER',

+ 'HELP_FAQ_LOGIN_LOST_PASSWORD_QUESTION' => 'HELP_FAQ_LOGIN_LOST_PASSWORD_ANSWER',

+ 'HELP_FAQ_LOGIN_AUTO_LOGOUT_QUESTION' => 'HELP_FAQ_LOGIN_AUTO_LOGOUT_ANSWER',

+ 'HELP_FAQ_LOGIN_DELETE_COOKIES_QUESTION' => 'HELP_FAQ_LOGIN_DELETE_COOKIES_ANSWER',

+ )

+ );

+ $this->manager->add_block(

+ 'HELP_FAQ_BLOCK_USERSETTINGS',

+ false,

+ array(

+ 'HELP_FAQ_USERSETTINGS_CHANGE_SETTINGS_QUESTION' => 'HELP_FAQ_USERSETTINGS_CHANGE_SETTINGS_ANSWER',

+ 'HELP_FAQ_USERSETTINGS_HIDE_ONLINE_QUESTION' => 'HELP_FAQ_USERSETTINGS_HIDE_ONLINE_ANSWER',

+ 'HELP_FAQ_USERSETTINGS_TIMEZONE_QUESTION' => 'HELP_FAQ_USERSETTINGS_TIMEZONE_ANSWER',

+ 'HELP_FAQ_USERSETTINGS_SERVERTIME_QUESTION' => 'HELP_FAQ_USERSETTINGS_SERVERTIME_ANSWER',

+ 'HELP_FAQ_USERSETTINGS_LANGUAGE_QUESTION' => 'HELP_FAQ_USERSETTINGS_LANGUAGE_ANSWER',

+ 'HELP_FAQ_USERSETTINGS_AVATAR_QUESTION' => 'HELP_FAQ_USERSETTINGS_AVATAR_ANSWER',

+ 'HELP_FAQ_USERSETTINGS_AVATAR_DISPLAY_QUESTION' => 'HELP_FAQ_USERSETTINGS_AVATAR_DISPLAY_ANSWER',

+ 'HELP_FAQ_USERSETTINGS_RANK_QUESTION' => 'HELP_FAQ_USERSETTINGS_RANK_ANSWER',

+ 'HELP_FAQ_USERSETTINGS_EMAIL_LOGIN_QUESTION' => 'HELP_FAQ_USERSETTINGS_EMAIL_LOGIN_ANSWER',

+ )

+ );

+ $this->manager->add_block(

+ 'HELP_FAQ_BLOCK_POSTING',

+ false,

+ array(

+ 'HELP_FAQ_POSTING_CREATE_QUESTION' => 'HELP_FAQ_POSTING_CREATE_ANSWER',

+ 'HELP_FAQ_POSTING_EDIT_DELETE_QUESTION' => 'HELP_FAQ_POSTING_EDIT_DELETE_ANSWER',

+ 'HELP_FAQ_POSTING_SIGNATURE_QUESTION' => 'HELP_FAQ_POSTING_SIGNATURE_ANSWER',

+ 'HELP_FAQ_POSTING_POLL_CREATE_QUESTION' => 'HELP_FAQ_POSTING_POLL_CREATE_ANSWER',

+ 'HELP_FAQ_POSTING_POLL_ADD_QUESTION' => 'HELP_FAQ_POSTING_POLL_ADD_ANSWER',

+ 'HELP_FAQ_POSTING_POLL_EDIT_QUESTION' => 'HELP_FAQ_POSTING_POLL_EDIT_ANSWER',

+ 'HELP_FAQ_POSTING_FORUM_RESTRICTED_QUESTION' => 'HELP_FAQ_POSTING_FORUM_RESTRICTED_ANSWER',

+ 'HELP_FAQ_POSTING_NO_ATTACHMENTS_QUESTION' => 'HELP_FAQ_POSTING_NO_ATTACHMENTS_ANSWER',

+ 'HELP_FAQ_POSTING_WARNING_QUESTION' => 'HELP_FAQ_POSTING_WARNING_ANSWER',

+ 'HELP_FAQ_POSTING_REPORT_QUESTION' => 'HELP_FAQ_POSTING_REPORT_ANSWER',

+ 'HELP_FAQ_POSTING_DRAFT_QUESTION' => 'HELP_FAQ_POSTING_DRAFT_ANSWER',

+ 'HELP_FAQ_POSTING_QUEUE_QUESTION' => 'HELP_FAQ_POSTING_QUEUE_ANSWER',

+ 'HELP_FAQ_POSTING_BUMP_QUESTION' => 'HELP_FAQ_POSTING_BUMP_ANSWER',

+ )

+ );

+ $this->manager->add_block(

+ 'HELP_FAQ_BLOCK_FORMATTING',

+ false,

+ array(

+ 'HELP_FAQ_FORMATTING_BBOCDE_QUESTION' => 'HELP_FAQ_FORMATTING_BBOCDE_ANSWER',

+ 'HELP_FAQ_FORMATTING_HTML_QUESTION' => 'HELP_FAQ_FORMATTING_HTML_ANSWER',

+ 'HELP_FAQ_FORMATTING_SMILIES_QUESTION' => 'HELP_FAQ_FORMATTING_SMILIES_ANSWER',

+ 'HELP_FAQ_FORMATTING_IMAGES_QUESTION' => 'HELP_FAQ_FORMATTING_IMAGES_ANSWER',

+ 'HELP_FAQ_FORMATTING_GLOBAL_ANNOUNCE_QUESTION' => 'HELP_FAQ_FORMATTING_GLOBAL_ANNOUNCE_ANSWER',

+ 'HELP_FAQ_FORMATTING_ANNOUNCEMENT_QUESTION' => 'HELP_FAQ_FORMATTING_ANNOUNCEMENT_ANSWER',

+ 'HELP_FAQ_FORMATTING_STICKIES_QUESTION' => 'HELP_FAQ_FORMATTING_STICKIES_ANSWER',

+ 'HELP_FAQ_FORMATTING_LOCKED_QUESTION' => 'HELP_FAQ_FORMATTING_LOCKED_ANSWER',

+ 'HELP_FAQ_FORMATTING_ICONS_QUESTION' => 'HELP_FAQ_FORMATTING_ICONS_ANSWER',

+ )

+ );

+ $this->manager->add_block(

+ 'HELP_FAQ_BLOCK_GROUPS',

+ true,

+ array(

+ 'HELP_FAQ_GROUPS_ADMINISTRATORS_QUESTION' => 'HELP_FAQ_GROUPS_ADMINISTRATORS_ANSWER',

+ 'HELP_FAQ_GROUPS_MODERATORS_QUESTION' => 'HELP_FAQ_GROUPS_MODERATORS_ANSWER',

+ 'HELP_FAQ_GROUPS_USERGROUPS_QUESTION' => 'HELP_FAQ_GROUPS_USERGROUPS_ANSWER',

+ 'HELP_FAQ_GROUPS_USERGROUPS_JOIN_QUESTION' => 'HELP_FAQ_GROUPS_USERGROUPS_JOIN_ANSWER',

+ 'HELP_FAQ_GROUPS_USERGROUPS_LEAD_QUESTION' => 'HELP_FAQ_GROUPS_USERGROUPS_LEAD_ANSWER',

+ 'HELP_FAQ_GROUPS_COLORS_QUESTION' => 'HELP_FAQ_GROUPS_COLORS_ANSWER',

+ 'HELP_FAQ_GROUPS_DEFAULT_QUESTION' => 'HELP_FAQ_GROUPS_DEFAULT_ANSWER',

+ 'HELP_FAQ_GROUPS_TEAM_QUESTION' => 'HELP_FAQ_GROUPS_TEAM_ANSWER',

+ )

+ );

+ $this->manager->add_block(

+ 'HELP_FAQ_BLOCK_PMS',

+ false,

+ array(

+ 'HELP_FAQ_PMS_CANNOT_SEND_QUESTION' => 'HELP_FAQ_PMS_CANNOT_SEND_ANSWER',

+ 'HELP_FAQ_PMS_UNWANTED_QUESTION' => 'HELP_FAQ_PMS_UNWANTED_ANSWER',

+ 'HELP_FAQ_PMS_SPAM_QUESTION' => 'HELP_FAQ_PMS_SPAM_ANSWER',

+ )

+ );

+ $this->manager->add_block(

+ 'HELP_FAQ_BLOCK_FRIENDS',

+ false,

+ array(

+ 'HELP_FAQ_FRIENDS_BASIC_QUESTION' => 'HELP_FAQ_FRIENDS_BASIC_ANSWER',

+ 'HELP_FAQ_FRIENDS_MANAGE_QUESTION' => 'HELP_FAQ_FRIENDS_MANAGE_ANSWER',

+ )

+ );

+ $this->manager->add_block(

+ 'HELP_FAQ_BLOCK_SEARCH',

+ false,

+ array(

+ 'HELP_FAQ_SEARCH_FORUM_QUESTION' => 'HELP_FAQ_SEARCH_FORUM_ANSWER',

+ 'HELP_FAQ_SEARCH_NO_RESULT_QUESTION' => 'HELP_FAQ_SEARCH_NO_RESULT_ANSWER',

+ 'HELP_FAQ_SEARCH_BLANK_QUESTION' => 'HELP_FAQ_SEARCH_BLANK_ANSWER',

+ 'HELP_FAQ_SEARCH_MEMBERS_QUESTION' => 'HELP_FAQ_SEARCH_MEMBERS_ANSWER',

+ 'HELP_FAQ_SEARCH_OWN_QUESTION' => 'HELP_FAQ_SEARCH_OWN_ANSWER',

+ )

+ );

+ $this->manager->add_block(

+ 'HELP_FAQ_BLOCK_BOOKMARKS',

+ false,

+ array(

+ 'HELP_FAQ_BOOKMARKS_DIFFERENCE_QUESTION' => 'HELP_FAQ_BOOKMARKS_DIFFERENCE_ANSWER',

+ 'HELP_FAQ_BOOKMARKS_TOPIC_QUESTION' => 'HELP_FAQ_BOOKMARKS_TOPIC_ANSWER',

+ 'HELP_FAQ_BOOKMARKS_FORUM_QUESTION' => 'HELP_FAQ_BOOKMARKS_FORUM_ANSWER',

+ 'HELP_FAQ_BOOKMARKS_REMOVE_QUESTION' => 'HELP_FAQ_BOOKMARKS_REMOVE_ANSWER',

+ )

+ );

+ $this->manager->add_block(

+ 'HELP_FAQ_BLOCK_ATTACHMENTS',

+ false,

+ array(

+ 'HELP_FAQ_ATTACHMENTS_ALLOWED_QUESTION' => 'HELP_FAQ_ATTACHMENTS_ALLOWED_ANSWER',

+ 'HELP_FAQ_ATTACHMENTS_OWN_QUESTION' => 'HELP_FAQ_ATTACHMENTS_OWN_ANSWER',

+ )

+ );

+ $this->manager->add_block(

+ 'HELP_FAQ_BLOCK_ISSUES',

+ false,

+ array(

+ 'HELP_FAQ_ISSUES_WHOIS_PHPBB_QUESTION' => 'HELP_FAQ_ISSUES_WHOIS_PHPBB_ANSWER',

+ 'HELP_FAQ_ISSUES_FEATURE_QUESTION' => 'HELP_FAQ_ISSUES_FEATURE_ANSWER',

+ 'HELP_FAQ_ISSUES_LEGAL_QUESTION' => 'HELP_FAQ_ISSUES_LEGAL_ANSWER',

+ 'HELP_FAQ_ISSUES_ADMIN_QUESTION' => 'HELP_FAQ_ISSUES_ADMIN_ANSWER',

+ )

+ );

+

+ return $this->language->lang('FAQ_EXPLAIN');

+ }

+}

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

+

+/**

+ * Class help page manager

+ */

+class manager

+{

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

+ protected $dispatcher;

+

+ /** @var \phpbb\language\language */

+ protected $language;

+

+ /** @var \phpbb\template\template */

+ protected $template;

+

+ /** @var bool */

+ protected $switched_column;

+

+ /**

+ * Constructor

+ *

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

+ * @param \phpbb\language\language $language

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

+ */

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

+ {

+ $this->dispatcher = $dispatcher;

+ $this->language = $language;

+ $this->template = $template;

+ }

+

+ /**

+ * Add a new faq block

+ *

+ * @param string $block_name Name or language key with the name of the block

+ * @param bool $switch_column Switch the column of the menu

+ */

+ public function add_block($block_name, $switch_column = false, $questions = array())

+ {

+ /**

+ * You can use this event to add a block before the current one.

+ *

+ * @event core.help_manager_add_block_before

+ * @var string block_name Language key of the block headline

+ * @var bool switch_column Should we switch the menu column before this headline

+ * @var array questions Array with questions

+ * @since 3.2.0-a1

+ */

+ $vars = array('block_name', 'switch_column', 'questions');

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

+

+ $this->template->assign_block_vars('faq_block', array(

+ 'BLOCK_TITLE' => $this->language->lang($block_name),

+ 'SWITCH_COLUMN' => !$this->switched_column && $switch_column,

+ ));

+

+ foreach ($questions as $question => $answer)

+ {

+ $this->add_question($question, $answer);

+ }

+

+ $this->switched_column = $this->switched_column || $switch_column;

+

+ /**

+ * You can use this event to add a block after the current one.

+ *

+ * @event core.help_manager_add_block_after

+ * @var string block_name Language key of the block headline

+ * @var bool switch_column Should we switch the menu column before this headline

+ * @var array questions Array with questions

+ * @since 3.2.0-a1

+ */

+ $vars = array('block_name', 'switch_column', 'questions');

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

+ }

+

+ /**

+ * Add a new faq question

+ *

+ * @param string $question Question or language key with the question of the block

+ * @param string $answer Answer or language key with the answer of the block

+ */

+ public function add_question($question, $answer)

+ {

+ /**

+ * You can use this event to add a question before the current one.

+ *

+ * @event core.help_manager_add_question_before

+ * @var string question Language key of the question

+ * @var string answer Language key of the answer

+ * @since 3.2.0-a1

+ */

+ $vars = array('question', 'answer');

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

+

+ $this->template->assign_block_vars('faq_block.faq_row', array(

+ 'FAQ_QUESTION' => $this->language->lang($question),

+ 'FAQ_ANSWER' => $this->language->lang($answer),

+ ));

+

+ /**

+ * You can use this event to add a question after the current one.

+ *

+ * @event core.help_manager_add_question_after

+ * @var string question Language key of the question

+ * @var string answer Language key of the answer

+ * @since 3.2.0-a1

+ */

+ $vars = array('question', 'answer');

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

+ }

+

+ /**

+ * Returns whether the block titles switched side

+ * @return bool

+ */

+ public function switched_column()

+ {

+ return $this->switched_column;

+ }

+}

+ $this->lang = array();

+ * @throws language_file_not_found When the path to the file cannot be resolved

+ $language_file_path = $filename;

+

+ $get_logs_sql_ary = array(

+ 'SELECT' => 'l.*, u.username, u.username_clean, u.user_colour',

+ 'FROM' => array(

+ $this->log_table => 'l',

+ USERS_TABLE => 'u',

+ ),

+ 'WHERE' => 'l.log_type = ' . (int) $log_type . "

+ $sql_additional",

+

+ 'ORDER_BY' => $sort_by,

+ );

+

+ if ($log_time)

+ {

+ $get_logs_sql_ary['WHERE'] = 'l.log_time >= ' . (int) $log_time . '

+ AND ' . $get_logs_sql_ary['WHERE'];

+ }

+

+ /**

+ * Modify the query to obtain the logs data

+ *

+ * @event core.get_logs_main_query_before

+ * @var array get_logs_sql_ary The array in the format of the query builder with the query

+ * to get the log count and the log list

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

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

+ * @var int limit Limit the number of entries

+ * @var int offset Offset when fetching the entries

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

+ * can also be an array of forum_ids

+ * @var int topic_id Limit entries to the topic_id

+ * @var int user_id Limit entries to the user_id

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

+ * @var string sort_by SQL order option

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

+ * keywords in log_operation or log_data

+ * @var string profile_url URL to the users profile

+ * @var int log_type Limit logs to a certain type. If log_type

+ * is false, no entries will be returned.

+ * @var string sql_additional Additional conditions for the entries,

+ * e.g.: 'AND l.forum_id = 1'

+ * @since 3.1.5-RC1

+ */

+ $vars = array(

+ 'get_logs_sql_ary',

+ 'mode',

+ 'count_logs',

+ 'limit',

+ 'offset',

+ 'forum_id',

+ 'topic_id',

+ 'user_id',

+ 'log_time',

+ 'sort_by',

+ 'keywords',

+ 'profile_url',

+ 'log_type',

+ 'sql_additional',

+ );

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

+

+ if ($count_logs)

+ {

+ $count_logs_sql_ary = $get_logs_sql_ary;

+

+ $count_logs_sql_ary['SELECT'] = 'COUNT(l.log_id) AS total_entries';

+ unset($count_logs_sql_ary['ORDER_BY']);

+

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

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

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

+

+class module_exception extends \phpbb\exception\runtime_exception

+{

+

+}

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

+

+class module_not_found_exception extends module_exception

+{

+

+}

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

+

+use phpbb\module\exception\module_exception;

+use phpbb\module\exception\module_not_found_exception;

+

+class module_manager

+{

+ /**

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

+ */

+ protected $cache;

+

+ /**

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

+ */

+ protected $db;

+

+ /**

+ * @var \phpbb\extension\manager

+ */

+ protected $extension_manager;

+

+ /**

+ * @var string

+ */

+ protected $modules_table;

+

+ /**

+ * @var string

+ */

+ protected $phpbb_root_path;

+

+ /**

+ * @var string

+ */

+ protected $php_ext;

+

+ /**

+ * Constructor

+ *

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

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

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

+ * @param string $modules_table Module database table's name

+ * @param string $phpbb_root_path Path to phpBB's root

+ * @param string $php_ext Extension of PHP files

+ */

+ public function __construct(\phpbb\cache\driver\driver_interface $cache, \phpbb\db\driver\driver_interface $db, \phpbb\extension\manager $ext_manager, $modules_table, $phpbb_root_path, $php_ext)

+ {

+ $this->cache = $cache;

+ $this->db = $db;

+ $this->extension_manager = $ext_manager;

+ $this->modules_table = $modules_table;

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->php_ext = $php_ext;

+ }

+

+ /**

+ * Get row for specified module

+ *

+ * @param int $module_id ID of the module

+ * @param string $module_class Class of the module (acp, ucp, mcp etc...)

+ *

+ * @return array Array of data fetched from the database

+ *

+ * @throws \phpbb\module\exception\module_not_found_exception When there is no module with $module_id

+ */

+ public function get_module_row($module_id, $module_class)

+ {

+ $module_id = (int) $module_id;

+

+ $sql = 'SELECT *

+ FROM ' . $this->modules_table . "

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

+ AND module_id = $module_id";

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

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

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

+

+ if (!$row)

+ {

+ throw new module_not_found_exception('NO_MODULE');

+ }

+

+ return $row;

+ }

+

+ /**

+ * Get available module information from module files

+ *

+ * @param string $module_class Class of the module (acp, ucp, mcp etc...)

+ * @param string $module ID of module

+ * @param bool $use_all_available Use all available instead of just all

+ * enabled extensions

+ *

+ * @return array Array with module information gathered from module info files.

+ */

+ public function get_module_infos($module_class, $module = '', $use_all_available = false)

+ {

+ $directory = $this->phpbb_root_path . 'includes/' . $module_class . '/info/';

+ $fileinfo = array();

+

+ $finder = $this->extension_manager->get_finder($use_all_available);

+

+ $modules = $finder

+ ->extension_suffix('_module')

+ ->extension_directory("/$module_class")

+ ->core_path("includes/$module_class/info/")

+ ->core_prefix($module_class . '_')

+ ->get_classes(true);

+

+ foreach ($modules as $cur_module)

+ {

+ // Skip entries we do not need if we know the module we are

+ // looking for

+ if ($module && strpos(str_replace('\\', '_', $cur_module), $module) === false && $module !== $cur_module)

+ {

+ continue;

+ }

+

+ $info_class = preg_replace('/_module$/', '_info', $cur_module);

+

+ // If the class does not exist it might be following the old

+ // format. phpbb_acp_info_acp_foo needs to be turned into

+ // acp_foo_info and the respective file has to be included

+ // manually because it does not support auto loading

+ $old_info_class_file = str_replace("phpbb_{$module_class}_info_", '', $cur_module);

+ $old_info_class = $old_info_class_file . '_info';

+

+ if (class_exists($old_info_class))

+ {

+ $info_class = $old_info_class;

+ }

+ else if (!class_exists($info_class))

+ {

+ $info_class = $old_info_class;

+

+ // need to check class exists again because previous checks triggered autoloading

+ if (!class_exists($info_class) && file_exists($directory . $old_info_class_file . '.' . $this->php_ext))

+ {

+ include($directory . $old_info_class_file . '.' . $this->php_ext);

+ }

+ }

+

+ if (class_exists($info_class))

+ {

+ $info = new $info_class();

+ $module_info = $info->module();

+

+ $main_class = (isset($module_info['filename'])) ? $module_info['filename'] : $cur_module;

+

+ $fileinfo[$main_class] = $module_info;

+ }

+ }

+

+ ksort($fileinfo);

+

+ return $fileinfo;

+ }

+

+ /**

+ * Get module branch

+ *

+ * @param int $module_id ID of the module

+ * @param string $module_class Class of the module (acp, ucp, mcp etc...)

+ * @param string $type Type of branch (Expected values: all, parents or children)

+ * @param bool $include_module Whether or not to include the specified module with $module_id

+ *

+ * @return array Returns an array containing the modules in the specified branch type.

+ */

+ public function get_module_branch($module_id, $module_class, $type = 'all', $include_module = true)

+ {

+ $module_id = (int) $module_id;

+

+ switch ($type)

+ {

+ case 'parents':

+ $condition = 'm1.left_id BETWEEN m2.left_id AND m2.right_id';

+ break;

+

+ case 'children':

+ $condition = 'm2.left_id BETWEEN m1.left_id AND m1.right_id';

+ break;

+

+ default:

+ $condition = 'm2.left_id BETWEEN m1.left_id AND m1.right_id OR m1.left_id BETWEEN m2.left_id AND m2.right_id';

+ break;

+ }

+

+ $rows = array();

+

+ $sql = 'SELECT m2.*

+ FROM ' . $this->modules_table . ' m1

+ LEFT JOIN ' . $this->modules_table . " m2 ON ($condition)

+ WHERE m1.module_class = '" . $this->db->sql_escape($module_class) . "'

+ AND m2.module_class = '" . $this->db->sql_escape($module_class) . "'

+ AND m1.module_id = $module_id

+ ORDER BY m2.left_id DESC";

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

+

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

+ {

+ if (!$include_module && $row['module_id'] == $module_id)

+ {

+ continue;

+ }

+

+ $rows[] = $row;

+ }

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

+

+ return $rows;

+ }

+

+ /**

+ * Remove modules cache file

+ *

+ * @param string $module_class Class of the module (acp, ucp, mcp etc...)

+ */

+ public function remove_cache_file($module_class)

+ {

+ // Sanitise for future path use, it's escaped as appropriate for queries

+ $cache_class = str_replace(array('.', '/', '\\'), '', basename($module_class));

+ $this->cache->destroy('_modules_' . $cache_class);

+ $this->cache->destroy('sql', $this->modules_table);

+ }

+

+ /**

+ * Update/Add module

+ *

+ * @param array &$module_data The module data

+ *

+ * @throws \phpbb\module\exception\module_not_found_exception When parent module or the category is not exist

+ */

+ public function update_module_data(&$module_data)

+ {

+ if (!isset($module_data['module_id']))

+ {

+ // no module_id means we're creating a new category/module

+ if ($module_data['parent_id'])

+ {

+ $sql = 'SELECT left_id, right_id

+ FROM ' . $this->modules_table . "

+ WHERE module_class = '" . $this->db->sql_escape($module_data['module_class']) . "'

+ AND module_id = " . (int) $module_data['parent_id'];

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

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

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

+

+ if (!$row)

+ {

+ throw new module_not_found_exception('PARENT_NOT_EXIST');

+ }

+

+ // Workaround

+ $row['left_id'] = (int) $row['left_id'];

+ $row['right_id'] = (int) $row['right_id'];

+

+ $sql = 'UPDATE ' . $this->modules_table . "

+ SET left_id = left_id + 2, right_id = right_id + 2

+ WHERE module_class = '" . $this->db->sql_escape($module_data['module_class']) . "'

+ AND left_id > {$row['right_id']}";

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

+

+ $sql = 'UPDATE ' . $this->modules_table . "

+ SET right_id = right_id + 2

+ WHERE module_class = '" . $this->db->sql_escape($module_data['module_class']) . "'

+ AND {$row['left_id']} BETWEEN left_id AND right_id";

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

+

+ $module_data['left_id'] = (int) $row['right_id'];

+ $module_data['right_id'] = (int) $row['right_id'] + 1;

+ }

+ else

+ {

+ $sql = 'SELECT MAX(right_id) AS right_id

+ FROM ' . $this->modules_table . "

+ WHERE module_class = '" . $this->db->sql_escape($module_data['module_class']) . "'";

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

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

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

+

+ $module_data['left_id'] = (int) $row['right_id'] + 1;

+ $module_data['right_id'] = (int) $row['right_id'] + 2;

+ }

+

+ $sql = 'INSERT INTO ' . $this->modules_table . ' ' . $this->db->sql_build_array('INSERT', $module_data);

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

+

+ $module_data['module_id'] = $this->db->sql_nextid();

+ }

+ else

+ {

+ $row = $this->get_module_row($module_data['module_id'], $module_data['module_class']);

+

+ if ($module_data['module_basename'] && !$row['module_basename'])

+ {

+ // we're turning a category into a module

+ $branch = $this->get_module_branch($module_data['module_id'], $module_data['module_class'], 'children', false);

+

+ if (sizeof($branch))

+ {

+ throw new module_not_found_exception('NO_CATEGORY_TO_MODULE');

+ }

+ }

+

+ if ($row['parent_id'] != $module_data['parent_id'])

+ {

+ $this->move_module($module_data['module_id'], $module_data['parent_id'], $module_data['module_class']);

+ }

+

+ $update_ary = $module_data;

+ unset($update_ary['module_id']);

+

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

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

+ WHERE module_class = '" . $this->db->sql_escape($module_data['module_class']) . "'

+ AND module_id = " . (int) $module_data['module_id'];

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

+ }

+ }

+

+ /**

+ * Move module around the tree

+ *

+ * @param int $from_module_id ID of the current parent module

+ * @param int $to_parent_id ID of the target parent module

+ * @param string $module_class Class of the module (acp, ucp, mcp etc...)

+ *

+ * @throws \phpbb\module\exception\module_not_found_exception If the module specified to move modules from does not

+ * have any children.

+ */

+ public function move_module($from_module_id, $to_parent_id, $module_class)

+ {

+ $moved_modules = $this->get_module_branch($from_module_id, $module_class, 'children');

+

+ if (empty($moved_modules))

+ {

+ throw new module_not_found_exception();

+ }

+

+ $from_data = $moved_modules[0];

+ $diff = sizeof($moved_modules) * 2;

+

+ $moved_ids = array();

+ for ($i = 0; $i < sizeof($moved_modules); ++$i)

+ {

+ $moved_ids[] = $moved_modules[$i]['module_id'];

+ }

+

+ // Resync parents

+ $sql = 'UPDATE ' . $this->modules_table . "

+ SET right_id = right_id - $diff

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

+ AND left_id < " . (int) $from_data['right_id'] . '

+ AND right_id > ' . (int) $from_data['right_id'];

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

+

+ // Resync righthand side of tree

+ $sql = 'UPDATE ' . $this->modules_table . "

+ SET left_id = left_id - $diff, right_id = right_id - $diff

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

+ AND left_id > " . (int) $from_data['right_id'];

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

+

+ if ($to_parent_id > 0)

+ {

+ $to_data = $this->get_module_row($to_parent_id, $module_class);

+

+ // Resync new parents

+ $sql = 'UPDATE ' . $this->modules_table . "

+ SET right_id = right_id + $diff

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

+ AND " . (int) $to_data['right_id'] . ' BETWEEN left_id AND right_id

+ AND ' . $this->db->sql_in_set('module_id', $moved_ids, true);

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

+

+ // Resync the righthand side of the tree

+ $sql = 'UPDATE ' . $this->modules_table . "

+ SET left_id = left_id + $diff, right_id = right_id + $diff

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

+ AND left_id > " . (int) $to_data['right_id'] . '

+ AND ' . $this->db->sql_in_set('module_id', $moved_ids, true);

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

+

+ // Resync moved branch

+ $to_data['right_id'] += $diff;

+ if ($to_data['right_id'] > $from_data['right_id'])

+ {

+ $diff = '+ ' . ($to_data['right_id'] - $from_data['right_id'] - 1);

+ }

+ else

+ {

+ $diff = '- ' . abs($to_data['right_id'] - $from_data['right_id'] - 1);

+ }

+ }

+ else

+ {

+ $sql = 'SELECT MAX(right_id) AS right_id

+ FROM ' . $this->modules_table . "

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

+ AND " . $this->db->sql_in_set('module_id', $moved_ids, true);

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

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

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

+

+ $diff = '+ ' . (int) ($row['right_id'] - $from_data['left_id'] + 1);

+ }

+

+ $sql = 'UPDATE ' . $this->modules_table . "

+ SET left_id = left_id $diff, right_id = right_id $diff

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

+ AND " . $this->db->sql_in_set('module_id', $moved_ids);

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

+ }

+

+ /**

+ * Remove module from tree

+ *

+ * @param int $module_id ID of the module to delete

+ * @param string $module_class Class of the module (acp, ucp, mcp etc...)

+ *

+ * @throws \phpbb\module\exception\module_exception When the specified module cannot be removed

+ */

+ public function delete_module($module_id, $module_class)

+ {

+ $module_id = (int) $module_id;

+

+ $row = $this->get_module_row($module_id, $module_class);

+

+ $branch = $this->get_module_branch($module_id, $module_class, 'children', false);

+

+ if (sizeof($branch))

+ {

+ throw new module_exception('CANNOT_REMOVE_MODULE');

+ }

+

+ // If not move

+ $diff = 2;

+ $sql = 'DELETE FROM ' . $this->modules_table . "

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

+ AND module_id = $module_id";

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

+

+ $row['right_id'] = (int) $row['right_id'];

+ $row['left_id'] = (int) $row['left_id'];

+

+ // Resync tree

+ $sql = 'UPDATE ' . $this->modules_table . "

+ SET right_id = right_id - $diff

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

+ AND left_id < {$row['right_id']} AND right_id > {$row['right_id']}";

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

+

+ $sql = 'UPDATE ' . $this->modules_table . "

+ SET left_id = left_id - $diff, right_id = right_id - $diff

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

+ AND left_id > {$row['right_id']}";

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

+ }

+

+ /**

+ * Move module position by $steps up/down

+ *

+ * @param array $module_row Array of module data

+ * @param string $module_class Class of the module (acp, ucp, mcp etc...)

+ * @param string $action Direction of moving (valid values: move_up or move_down)

+ * @param int $steps Number of steps to move module

+ *

+ * @return string Returns the language name of the module

+ *

+ * @throws \phpbb\module\exception\module_not_found_exception When the specified module does not exists

+ */

+ public function move_module_by($module_row, $module_class, $action = 'move_up', $steps = 1)

+ {

+ /**

+ * Fetch all the siblings between the module's current spot

+ * and where we want to move it to. If there are less than $steps

+ * siblings between the current spot and the target then the

+ * module will move as far as possible

+ */

+ $sql = 'SELECT module_id, left_id, right_id, module_langname

+ FROM ' . $this->modules_table . "

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

+ AND parent_id = " . (int) $module_row['parent_id'] . '

+ AND ' . (($action == 'move_up') ? 'right_id < ' . (int) $module_row['right_id'] . ' ORDER BY right_id DESC' : 'left_id > ' . (int) $module_row['left_id'] . ' ORDER BY left_id ASC');

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

+

+ $target = array();

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

+ {

+ $target = $row;

+ }

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

+

+ if (!sizeof($target))

+ {

+ // The module is already on top or bottom

+ throw new module_not_found_exception();

+ }

+

+ /**

+ * $left_id and $right_id define the scope of the nodes that are affected by the move.

+ * $diff_up and $diff_down are the values to substract or add to each node's left_id

+ * and right_id in order to move them up or down.

+ * $move_up_left and $move_up_right define the scope of the nodes that are moving

+ * up. Other nodes in the scope of ($left_id, $right_id) are considered to move down.

+ */

+ if ($action == 'move_up')

+ {

+ $left_id = (int) $target['left_id'];

+ $right_id = (int) $module_row['right_id'];

+

+ $diff_up = (int) ($module_row['left_id'] - $target['left_id']);

+ $diff_down = (int) ($module_row['right_id'] + 1 - $module_row['left_id']);

+

+ $move_up_left = (int) $module_row['left_id'];

+ $move_up_right = (int) $module_row['right_id'];

+ }

+ else

+ {

+ $left_id = (int) $module_row['left_id'];

+ $right_id = (int) $target['right_id'];

+

+ $diff_up = (int) ($module_row['right_id'] + 1 - $module_row['left_id']);

+ $diff_down = (int) ($target['right_id'] - $module_row['right_id']);

+

+ $move_up_left = (int) ($module_row['right_id'] + 1);

+ $move_up_right = (int) $target['right_id'];

+ }

+

+ // Now do the dirty job

+ $sql = 'UPDATE ' . $this->modules_table . "

+ SET left_id = left_id + CASE

+ WHEN left_id BETWEEN {$move_up_left} AND {$move_up_right} THEN -{$diff_up}

+ ELSE {$diff_down}

+ END,

+ right_id = right_id + CASE

+ WHEN right_id BETWEEN {$move_up_left} AND {$move_up_right} THEN -{$diff_up}

+ ELSE {$diff_down}

+ END

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

+ AND left_id BETWEEN {$left_id} AND {$right_id}

+ AND right_id BETWEEN {$left_id} AND {$right_id}";

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

+

+ $this->remove_cache_file($module_class);

+

+ return $target['module_langname'];

+ }

+}

+ *

+ *

+ return $this->user_loader->get_avatar($this->item_id, false, true);

+ return $this->user_loader->get_avatar($this->item_id, false, true);

+ return $this->user_loader->get_avatar($this->get_data('from_user_id'), false, true);

+ return $this->user_loader->get_avatar($this->get_data('poster_id'), false, true);

+ * @var \phpbb\textformatter\utils_interface

+ */

+ protected $utils;

+

+ /**

+ $usernames = $this->utils->get_outermost_quote_authors($post['post_text']);

+ if (empty($usernames))

+ $usernames = array_unique($usernames);

+ $usernames = array_map('utf8_clean_string', $usernames);

+

+ /**

+ * Set the utils service used to retrieve quote authors

+ *

+ * @param \phpbb\textformatter\utils_interface $utils

+ */

+ public function set_utils(\phpbb\textformatter\utils_interface $utils)

+ {

+ $this->utils = $utils;

+ }

+ return $this->user_loader->get_avatar($this->get_data('reporter_id'), false, true);

+ return $this->user_loader->get_avatar($this->get_data('closer_id'), false, true);

+ return $this->user_loader->get_avatar($this->get_data('reporter_id'), false, true);

+ return $this->user_loader->get_avatar($this->get_data('closer_id'), false, true);

+ return $this->user_loader->get_avatar($this->get_data('poster_id'), false, true);

+ // Return if input variables are not strings or if length does not match

+ if (!is_string($string_a) || !is_string($string_b) || strlen($string_a) != strlen($string_b))

+ {

+ return false;

+ }

+

+ // Use hash_equals() if it's available

+ if (function_exists('hash_equals'))

+ {

+ return hash_equals($string_a, $string_b);

+ }

+

+ $difference = 0;

+ $difference |= ord($string_a[$i]) ^ ord($string_b[$i]);

+use Symfony\Component\Filesystem\Exception\IOException;

+use Symfony\Component\DependencyInjection\ContainerInterface;

+use Symfony\Component\DependencyInjection\Exception\ParameterNotFoundException;

+use Symfony\Component\DependencyInjection\Exception\RuntimeException;

+ * @var ContainerInterface

+ */

+ protected $container;

+

+ /**

+ * @param ContainerInterface $container DI container

+ * @param string $phpbb_root_path phpBB root path

+ * @param string $php_ext PHP file extension

+ * @param string $environment Name of the current environment

+ * @param manager $extension_manager Extension manager

+ * @param array $routing_files Array of strings containing paths to YAML files holding route information

+ public function __construct(ContainerInterface $container, \phpbb\filesystem\filesystem_interface $filesystem, $phpbb_root_path, $php_ext, $environment, manager $extension_manager = null, $routing_files = array())

+ $this->container = $container;

+ $this->resolveParameters($this->route_collection);

+

+ * Replaces placeholders with service container parameter values in:

+ * - the route defaults,

+ * - the route requirements,

+ * - the route path,

+ * - the route host,

+ * - the route schemes,

+ * - the route methods.

+ *

+ * @param RouteCollection $collection

+ */

+ private function resolveParameters(RouteCollection $collection)

+ {

+ foreach ($collection as $route)

+ {

+ foreach ($route->getDefaults() as $name => $value)

+ {

+ $route->setDefault($name, $this->resolve($value));

+ }

+

+ $requirements = $route->getRequirements();

+ unset($requirements['_scheme']);

+ unset($requirements['_method']);

+

+ foreach ($requirements as $name => $value)

+ {

+ $route->setRequirement($name, $this->resolve($value));

+ }

+

+ $route->setPath($this->resolve($route->getPath()));

+ $route->setHost($this->resolve($route->getHost()));

+

+ $schemes = array();

+ foreach ($route->getSchemes() as $scheme)

+ {

+ $schemes = array_merge($schemes, explode('|', $this->resolve($scheme)));

+ }

+

+ $route->setSchemes($schemes);

+ $methods = array();

+ foreach ($route->getMethods() as $method)

+ {

+ $methods = array_merge($methods, explode('|', $this->resolve($method)));

+ }

+

+ $route->setMethods($methods);

+ $route->setCondition($this->resolve($route->getCondition()));

+ }

+ }

+

+ /**

+ * Recursively replaces placeholders with the service container parameters.

+ *

+ * @param mixed $value The source which might contain "%placeholders%"

+ *

+ * @return mixed The source with the placeholders replaced by the container

+ * parameters. Arrays are resolved recursively.

+ *

+ * @throws ParameterNotFoundException When a placeholder does not exist as a container parameter

+ * @throws RuntimeException When a container value is not a string or a numeric value

+ */

+ private function resolve($value)

+ {

+ if (is_array($value))

+ {

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

+ {

+ $value[$key] = $this->resolve($val);

+ }

+

+ return $value;

+ }

+

+ if (!is_string($value))

+ {

+ return $value;

+ }

+

+ $container = $this->container;

+ $escapedValue = preg_replace_callback('/%%|%([^%\s]++)%/', function ($match) use ($container, $value)

+ {

+ // skip %%

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

+ {

+ return '%%';

+ }

+

+ $resolved = $container->getParameter($match[1]);

+ if (is_string($resolved) || is_numeric($resolved))

+ {

+ return (string) $resolved;

+ }

+

+ throw new RuntimeException(sprintf(

+ 'The container parameter "%s", used in the route configuration value "%s", '.

+ 'must be a string or numeric, but it is of type %s.',

+ $match[1],

+ $value,

+ gettype($resolved)

+ )

+ );

+ }, $value);

+

+ return str_replace('%%', '%', $escapedValue);

+ }

+

+ /**

+ try

+ $cache = new ConfigCache("{$this->phpbb_root_path}cache/{$this->environment}/url_matcher.{$this->php_ext}", defined('DEBUG'));

+ if (!$cache->isFresh())

+ {

+ $dumper = new PhpMatcherDumper($this->get_routes());

+ $options = array(

+ 'class' => 'phpbb_url_matcher',

+ 'base_class' => 'Symfony\\Component\\Routing\\Matcher\\UrlMatcher',

+ );

+ $cache->write($dumper->dump($options), $this->get_routes()->getResources());

+ }

+ require_once($cache->getPath());

+ $this->matcher = new \phpbb_url_matcher($this->context);

+ }

+ catch (IOException $e)

+ {

+ $this->create_new_url_matcher();

+ }

+ try

+ $cache = new ConfigCache("{$this->phpbb_root_path}cache/{$this->environment}/url_generator.{$this->php_ext}", defined('DEBUG'));

+ if (!$cache->isFresh())

+ {

+ $dumper = new PhpGeneratorDumper($this->get_routes());

+ $options = array(

+ 'class' => 'phpbb_url_generator',

+ 'base_class' => 'Symfony\\Component\\Routing\\Generator\\UrlGenerator',

+ );

+ $cache->write($dumper->dump($options), $this->get_routes()->getResources());

+ }

+ require_once($cache->getPath());

+ $this->generator = new \phpbb_url_generator($this->context);

+ }

+ catch (IOException $e)

+ {

+ $this->create_new_url_generator();

+ }

+ * phpBB event dispatcher object

+ * @var \phpbb\event\dispatcher_interface

+ */

+ protected $phpbb_dispatcher;

+

+ /**

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

+ public function __construct(&$error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user, $phpbb_dispatcher)

+ $this->phpbb_dispatcher = $phpbb_dispatcher;

+ $search_query = $this->search_query;

+

+ /**

+ * Allow changing the query used to search for posts using fulltext_mysql

+ *

+ * @event core.search_mysql_keywords_main_query_before

+ * @var string search_query The parsed keywords used for this search

+ * @var int result_count The previous result count for the format of the query.

+ * Set to 0 to force a re-count

+ * @var bool join_topic Weather or not TOPICS_TABLE should be CROSS JOIN'ED

+ * @var array author_ary Array of user_id containing the users to filter the results to

+ * @var string author_name An extra username to search on (!empty(author_ary) must be true, to be relevant)

+ * @var array ex_fid_ary Which forums not to search on

+ * @var int topic_id Limit the search to this topic_id only

+ * @var string sql_sort_table Extra tables to include in the SQL query.

+ * Used in conjunction with sql_sort_join

+ * @var string sql_sort_join SQL conditions to join all the tables used together.

+ * Used in conjunction with sql_sort_table

+ * @var int sort_days Time, in days, of the oldest possible post to list

+ * @var string sql_match Which columns to do the search on.

+ * @var string sql_match_where Extra conditions to use to properly filter the matching process

+ * @var string sort_by_sql The possible predefined sort types

+ * @var string sort_key The sort type used from the possible sort types

+ * @var string sort_dir "a" for ASC or "d" dor DESC for the sort order used

+ * @var string sql_sort The result SQL when processing sort_by_sql + sort_key + sort_dir

+ * @var int start How many posts to skip in the search results (used for pagination)

+ * @since 3.1.5-RC1

+ */

+ $vars = array(

+ 'search_query',

+ 'result_count',

+ 'join_topic',

+ 'author_ary',

+ 'author_name',

+ 'ex_fid_ary',

+ 'topic_id',

+ 'sql_sort_table',

+ 'sql_sort_join',

+ 'sort_days',

+ 'sql_match',

+ 'sql_match_where',

+ 'sort_by_sql',

+ 'sort_key',

+ 'sort_dir',

+ 'sql_sort',

+ 'start',

+ );

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

+

+ /**

+ * Allow changing the query used to search for posts by author in fulltext_mysql

+ *

+ * @event core.search_mysql_author_query_before

+ * @var int result_count The previous result count for the format of the query.

+ * Set to 0 to force a re-count

+ * @var string sql_sort_table CROSS JOIN'ed table to allow doing the sort chosen

+ * @var string sql_sort_join Condition to define how to join the CROSS JOIN'ed table specifyed in sql_sort_table

+ * @var array author_ary Array of user_id containing the users to filter the results to

+ * @var string author_name An extra username to search on

+ * @var string sql_author SQL WHERE condition for the post author ids

+ * @var int topic_id Limit the search to this topic_id only

+ * @var string sql_topic_id SQL of topic_id

+ * @var string sort_by_sql The possible predefined sort types

+ * @var string sort_key The sort type used from the possible sort types

+ * @var string sort_dir "a" for ASC or "d" dor DESC for the sort order used

+ * @var string sql_sort The result SQL when processing sort_by_sql + sort_key + sort_dir

+ * @var string sort_days Time, in days, that the oldest post showing can have

+ * @var string sql_time The SQL to search on the time specifyed by sort_days

+ * @var bool firstpost_only Wether or not to search only on the first post of the topics

+ * @var array ex_fid_ary Forum ids that must not be searched on

+ * @var array sql_fora SQL query for ex_fid_ary

+ * @var string m_approve_fid_sql WHERE clause condition on post_visibility restrictions

+ * @var int start How many posts to skip in the search results (used for pagination)

+ * @since 3.1.5-RC1

+ */

+ $vars = array(

+ 'result_count',

+ 'sql_sort_table',

+ 'sql_sort_join',

+ 'author_ary',

+ 'author_name',

+ 'sql_author',

+ 'topic_id',

+ 'sql_topic_id',

+ 'sort_by_sql',

+ 'sort_key',

+ 'sort_dir',

+ 'sql_sort',

+ 'sort_days',

+ 'sql_time',

+ 'firstpost_only',

+ 'ex_fid_ary',

+ 'sql_fora',

+ 'm_approve_fid_sql',

+ 'start',

+ );

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

+

+ * phpBB event dispatcher object

+ * @var \phpbb\event\dispatcher_interface

+ */

+ protected $phpbb_dispatcher;

+

+ /**

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

+ public function __construct(&$error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user, $phpbb_dispatcher)

+ $this->phpbb_dispatcher = $phpbb_dispatcher;

+ $search_query = $this->search_query;

+ $must_exclude_one_ids = $this->must_exclude_one_ids;

+ $must_not_contain_ids = $this->must_not_contain_ids;

+ $must_contain_ids = $this->must_contain_ids;

+

+ /**

+ * Allow changing the query used for counting for posts using fulltext_native

+ *

+ * @event core.search_native_keywords_count_query_before

+ * @var string search_query The parsed keywords used for this search

+ * @var array must_not_contain_ids Ids that cannot be taken into account for the results

+ * @var array must_exclude_one_ids Ids that cannot be on the results

+ * @var array must_contain_ids Ids that must be on the results

+ * @var int result_count The previous result count for the format of the query

+ * Set to 0 to force a re-count

+ * @var bool join_topic Weather or not TOPICS_TABLE should be CROSS JOIN'ED

+ * @var array author_ary Array of user_id containing the users to filter the results to

+ * @var string author_name An extra username to search on (!empty(author_ary) must be true, to be relevant)

+ * @var array ex_fid_ary Which forums not to search on

+ * @var int topic_id Limit the search to this topic_id only

+ * @var string sql_sort_table Extra tables to include in the SQL query.

+ * Used in conjunction with sql_sort_join

+ * @var string sql_sort_join SQL conditions to join all the tables used together.

+ * Used in conjunction with sql_sort_table

+ * @var int sort_days Time, in days, of the oldest possible post to list

+ * @var string sql_where An array of the current WHERE clause conditions

+ * @var string sql_match Which columns to do the search on

+ * @var string sql_match_where Extra conditions to use to properly filter the matching process

+ * @var string group_by Whether or not the SQL query requires a GROUP BY for the elements in the SELECT clause

+ * @var string sort_by_sql The possible predefined sort types

+ * @var string sort_key The sort type used from the possible sort types

+ * @var string sort_dir "a" for ASC or "d" dor DESC for the sort order used

+ * @var string sql_sort The result SQL when processing sort_by_sql + sort_key + sort_dir

+ * @var int start How many posts to skip in the search results (used for pagination)

+ * @since 3.1.5-RC1

+ */

+ $vars = array(

+ 'search_query',

+ 'must_not_contain_ids',

+ 'must_exclude_one_ids',

+ 'must_contain_ids',

+ 'result_count',

+ 'join_topic',

+ 'author_ary',

+ 'author_name',

+ 'ex_fid_ary',

+ 'topic_id',

+ 'sql_sort_table',

+ 'sql_sort_join',

+ 'sort_days',

+ 'sql_where',

+ 'sql_match',

+ 'sql_match_where',

+ 'group_by',

+ 'sort_by_sql',

+ 'sort_key',

+ 'sort_dir',

+ 'sql_sort',

+ 'start',

+ );

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

+

+ /**

+ * Allow changing the query used to search for posts by author in fulltext_native

+ *

+ * @event core.search_native_author_count_query_before

+ * @var int total_results The previous result count for the format of the query.

+ * Set to 0 to force a re-count

+ * @var string select SQL SELECT clause for what to get

+ * @var string sql_sort_table CROSS JOIN'ed table to allow doing the sort chosen

+ * @var string sql_sort_join Condition to define how to join the CROSS JOIN'ed table specifyed in sql_sort_table

+ * @var array sql_author SQL WHERE condition for the post author ids

+ * @var int topic_id Limit the search to this topic_id only

+ * @var string sort_by_sql The possible predefined sort types

+ * @var string sort_key The sort type used from the possible sort types

+ * @var string sort_dir "a" for ASC or "d" dor DESC for the sort order used

+ * @var string sql_sort The result SQL when processing sort_by_sql + sort_key + sort_dir

+ * @var string sort_days Time, in days, that the oldest post showing can have

+ * @var string sql_time The SQL to search on the time specifyed by sort_days

+ * @var bool firstpost_only Wether or not to search only on the first post of the topics

+ * @var array ex_fid_ary Forum ids that must not be searched on

+ * @var array sql_fora SQL query for ex_fid_ary

+ * @var int start How many posts to skip in the search results (used for pagination)

+ * @since 3.1.5-RC1

+ */

+ $vars = array(

+ 'total_results',

+ 'select',

+ 'sql_sort_table',

+ 'sql_sort_join',

+ 'sql_author',

+ 'topic_id',

+ 'sort_by_sql',

+ 'sort_key',

+ 'sort_dir',

+ 'sql_sort',

+ 'sort_days',

+ 'sql_time',

+ 'firstpost_only',

+ 'ex_fid_ary',

+ 'sql_fora',

+ 'start',

+ );

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

+

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

+ * phpBB event dispatcher object

+ * @var \phpbb\event\dispatcher_interface

+ */

+ protected $phpbb_dispatcher;

+

+ /**

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

+ public function __construct(&$error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user, $phpbb_dispatcher)

+ $this->phpbb_dispatcher = $phpbb_dispatcher;

+ $tsearch_query = $this->tsearch_query;

+

+ /**

+ * Allow changing the query used to search for posts using fulltext_postgres

+ *

+ * @event core.search_postgres_keywords_main_query_before

+ * @var string tsearch_query The parsed keywords used for this search

+ * @var int result_count The previous result count for the format of the query.

+ * Set to 0 to force a re-count

+ * @var bool join_topic Weather or not TOPICS_TABLE should be CROSS JOIN'ED

+ * @var array author_ary Array of user_id containing the users to filter the results to

+ * @var string author_name An extra username to search on (!empty(author_ary) must be true, to be relevant)

+ * @var array ex_fid_ary Which forums not to search on

+ * @var int topic_id Limit the search to this topic_id only

+ * @var string sql_sort_table Extra tables to include in the SQL query.

+ * Used in conjunction with sql_sort_join

+ * @var string sql_sort_join SQL conditions to join all the tables used together.

+ * Used in conjunction with sql_sort_table

+ * @var int sort_days Time, in days, of the oldest possible post to list

+ * @var string sql_match Which columns to do the search on.

+ * @var string sql_match_where Extra conditions to use to properly filter the matching process

+ * @var string sort_by_sql The possible predefined sort types

+ * @var string sort_key The sort type used from the possible sort types

+ * @var string sort_dir "a" for ASC or "d" dor DESC for the sort order used

+ * @var string sql_sort The result SQL when processing sort_by_sql + sort_key + sort_dir

+ * @var int start How many posts to skip in the search results (used for pagination)

+ * @since 3.1.5-RC1

+ */

+ $vars = array(

+ 'tsearch_query',

+ 'result_count',

+ 'join_topic',

+ 'author_ary',

+ 'author_name',

+ 'ex_fid_ary',

+ 'topic_id',

+ 'sql_sort_table',

+ 'sql_sort_join',

+ 'sort_days',

+ 'sql_match',

+ 'sql_match_where',

+ 'sort_by_sql',

+ 'sort_key',

+ 'sort_dir',

+ 'sql_sort',

+ 'start',

+ );

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

+

+ /**

+ * Allow changing the query used to search for posts by author in fulltext_postgres

+ *

+ * @event core.search_postgres_author_count_query_before

+ * @var int result_count The previous result count for the format of the query.

+ * Set to 0 to force a re-count

+ * @var string sql_sort_table CROSS JOIN'ed table to allow doing the sort chosen

+ * @var string sql_sort_join Condition to define how to join the CROSS JOIN'ed table specifyed in sql_sort_table

+ * @var array author_ary Array of user_id containing the users to filter the results to

+ * @var string author_name An extra username to search on

+ * @var string sql_author SQL WHERE condition for the post author ids

+ * @var int topic_id Limit the search to this topic_id only

+ * @var string sql_topic_id SQL of topic_id

+ * @var string sort_by_sql The possible predefined sort types

+ * @var string sort_key The sort type used from the possible sort types

+ * @var string sort_dir "a" for ASC or "d" dor DESC for the sort order used

+ * @var string sql_sort The result SQL when processing sort_by_sql + sort_key + sort_dir

+ * @var string sort_days Time, in days, that the oldest post showing can have

+ * @var string sql_time The SQL to search on the time specifyed by sort_days

+ * @var bool firstpost_only Wether or not to search only on the first post of the topics

+ * @var array ex_fid_ary Forum ids that must not be searched on

+ * @var array sql_fora SQL query for ex_fid_ary

+ * @var string m_approve_fid_sql WHERE clause condition on post_visibility restrictions

+ * @var int start How many posts to skip in the search results (used for pagination)

+ * @since 3.1.5-RC1

+ */

+ $vars = array(

+ 'result_count',

+ 'sql_sort_table',

+ 'sql_sort_join',

+ 'author_ary',

+ 'author_name',

+ 'sql_author',

+ 'topic_id',

+ 'sql_topic_id',

+ 'sort_by_sql',

+ 'sort_key',

+ 'sort_dir',

+ 'sql_sort',

+ 'sort_days',

+ 'sql_time',

+ 'firstpost_only',

+ 'ex_fid_ary',

+ 'sql_fora',

+ 'm_approve_fid_sql',

+ 'start',

+ );

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

+

+ * phpBB event dispatcher object

+ * @var \phpbb\event\dispatcher_interface

+ */

+ protected $phpbb_dispatcher;

+

+ /**

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

+ public function __construct(&$error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user, $phpbb_dispatcher)

+ $this->phpbb_dispatcher = $phpbb_dispatcher;

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

+ * @return array[] Array of arrays. Each array contains a lang string at index 0 plus any number

+ * of optional parameters

+ 'email' => '[EMAIL={EMAIL;useContent} subject={TEXT;optional;postFilter=rawurlencode} body={TEXT;optional;postFilter=rawurlencode}]{TEXT}[/EMAIL]',

+ 'email' => '<a>

+ <xsl:attribute name="href">

+ <xsl:text>mailto:</xsl:text>

+ <xsl:value-of select="@email"/>

+ <xsl:if test="@subject or @body">

+ <xsl:text>?</xsl:text>

+ <xsl:if test="@subject">subject=<xsl:value-of select="@subject"/></xsl:if>

+ <xsl:if test="@body"><xsl:if test="@subject">&amp;</xsl:if>body=<xsl:value-of select="@body"/></xsl:if>

+ </xsl:if>

+ </xsl:attribute>

+ <xsl:apply-templates/>

+ </a>',

+ public function __construct(\phpbb\cache\driver\driver_interface $cache, $key, factory $factory, \phpbb\event\dispatcher_interface $dispatcher)

+ * - toggle features or BBCodes

+ * - register variables or custom parsers in the s9e\TextFormatter parser

+ * - configure the s9e\TextFormatter parser's runtime settings

+ $vars = array('parser');

+ * This will convert the log entries found in s9e\TextFormatter's logger into phpBB error

+ $errors[] = array('TOO_MANY_SMILIES', $context['tagLimit']);

+ $errors[] = array('TOO_MANY_URLS', $context['tagLimit']);

+ $errors[] = array($msg, $context['max_size']);

+ $errors[] = array($msg, $context['max_' . strtolower($m[1])]);

+ $errors[] = array('UNAUTHORISED_BBCODE', '[' . $name . ']');

+ $errors[] = array($msg);

+ // Deduplicate error messages. array_unique() only works on strings so we have to serialize

+ if (!empty($errors))

+ {

+ $errors = array_map('unserialize', array_unique(array_map('serialize', $errors)));

+ }

+

+ return $errors;

+ * Return given string between quotes

+ *

+ * Will use either single- or double- quotes depending on whichever requires less escaping.

+ * Quotes and backslashes are escaped with backslashes where necessary

+ *

+ * @param string $str Original string

+ * @return string Escaped string within quotes

+ */

+ protected function enquote($str)

+ {

+ $singleQuoted = "'" . addcslashes($str, "\\'") . "'";

+ $doubleQuoted = '"' . addcslashes($str, '\\"') . '"';

+

+ return (strlen($singleQuoted) < strlen($doubleQuoted)) ? $singleQuoted : $doubleQuoted;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function generate_quote($text, array $attributes = array())

+ {

+ $text = trim($text);

+ $quote = '[quote';

+ if (isset($attributes['author']))

+ {

+ // Add the author as the BBCode's default attribute

+ $quote .= '=' . $this->enquote($attributes['author']);

+ unset($attributes['author']);

+ }

+ foreach ($attributes as $name => $value)

+ {

+ $quote .= ' ' . $name . '=' . $this->enquote($value);

+ }

+ $quote .= ']';

+ $newline = (strlen($quote . $text . '[/quote]') > 80 || strpos($text, "\n") !== false) ? "\n" : '';

+ $quote .= $newline . $text . $newline . '[/quote]';

+

+ return $quote;

+ }

+

+ /**

+ * Get a list of quote authors, limited to the outermost quotes

+ *

+ * @param string $xml Parsed text

+ * @return string[] List of authors

+ */

+ public function get_outermost_quote_authors($xml)

+ {

+ $authors = array();

+ if (strpos($xml, '<QUOTE ') === false)

+ {

+ return $authors;

+ }

+

+ $dom = new \DOMDocument;

+ $dom->loadXML($xml);

+ $xpath = new \DOMXPath($dom);

+ foreach ($xpath->query('//QUOTE[not(ancestor::QUOTE)]/@author') as $author)

+ {

+ $authors[] = $author->textContent;

+ }

+

+ return $authors;

+ }

+

+ /**

+ * Create a quote block for given text

+ *

+ * Possible attributes:

+ * - author

+ *

+ * @param string $text Quote's text

+ * @param array $attributes Quote's attributes

+ * @return string Quote block to be used in a new post/text

+ */

+ public function generate_quote($text, array $attributes = array());

+

+ /**

+ * Get a list of quote authors, limited to the outermost quotes

+ *

+ * @param string $text Parsed text

+ * @return string[] List of authors

+ */

+ public function get_outermost_quote_authors($text);

+

+ /**

+ $rows = $this->db->sql_fetchrowset($result);

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

+

+ foreach ($rows as $row)

+ * @param bool @lazy If true, will be lazy loaded (requires JS)

+ public function get_avatar($user_id, $query = false, $lazy = false)

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