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

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

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

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

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

+ if ($log_time)

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

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

+ }

+

+ /**

+ * 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'])

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

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