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

+ if ($this->cachedToken)

+ {

+ if ($this->cachedToken instanceof TokenInterface)

+ {

+ * @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);

+ $root_path = (defined('PHPBB_USE_BOARD_URL_PATH') && PHPBB_USE_BOARD_URL_PATH) ? generate_board_url() . '/' : $this->path_helper->get_web_root_path();

+

+ 'src' => $root_path . $this->config['avatar_gallery_path'] . '/' . $row['avatar'],

+ * @var \phpbb\event\dispatcher_interface

+ */

+ protected $dispatcher;

+

+ /**

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

+ public function __construct(\phpbb\config\config $config, $phpbb_root_path, $php_ext, \phpbb\path_helper $path_helper, \phpbb\mimetype\guesser $mimetype_guesser, \phpbb\event\dispatcher_interface $dispatcher, \phpbb\cache\driver\driver_interface $cache = null)

+ $this->dispatcher = $dispatcher;

+ $root_path = (defined('PHPBB_USE_BOARD_URL_PATH') && PHPBB_USE_BOARD_URL_PATH) ? generate_board_url() . '/' : $this->path_helper->get_web_root_path();

+

+ 'src' => $root_path . 'download/file.' . $this->php_ext . '?avatar=' . $row['avatar'],

+ // If there was an error during upload, then abort operation

+ if (sizeof($file->error))

+ {

+ $file->remove();

+ $error = $file->error;

+ return false;

+ }

+

+ // Calculate new destination

+ /**

+ * Before moving new file in place (and eventually overwriting the existing avatar with the newly uploaded avatar)

+ *

+ * @event core.avatar_driver_upload_move_file_before

+ * @var string destination Destination directory where the file is going to be moved

+ * @var string prefix Prefix for the avatar filename

+ * @var array row Array with avatar row data

+ * @var array error Array of errors, if filled in by this event file will not be moved

+ * @since 3.1.6-RC1

+ */

+ $vars = array(

+ 'destination',

+ 'prefix',

+ 'row',

+ 'error',

+ );

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

+ if (!sizeof($error))

+ {

+ // Move file and overwrite any existing image

+ $file->move_file($destination, true);

+ }

+

+ // If there was an error during move, then clean up leftovers

+ $error = array_merge($error, $file->error);

+ if (sizeof($error))

+ // Delete current avatar if not overwritten

+ $ext = substr(strrchr($row['avatar'], '.'), 1);

+ if ($ext && $ext !== $file->get('extension'))

+ {

+ $this->delete($row);

+ }

+

+

+ $error = array();

+ $destination = $this->config['avatar_path'];

+ $prefix = $this->config['avatar_salt'] . '_';

+ $filename = $this->phpbb_root_path . $destination . '/' . $prefix . $row['id'] . '.' . $ext;

+

+ /**

+ * Before deleting an existing avatar

+ *

+ * @event core.avatar_driver_upload_delete_before

+ * @var string destination Destination directory where the file is going to be deleted

+ * @var string prefix Prefix for the avatar filename

+ * @var array row Array with avatar row data

+ * @var array error Array of errors, if filled in by this event file will not be deleted

+ * @since 3.1.6-RC1

+ */

+ $vars = array(

+ 'destination',

+ 'prefix',

+ 'row',

+ 'error',

+ );

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

+ if (!sizeof($error) && file_exists($filename))

+ $var_name = $this->clean_varname($var_name);

+ $filename = $this->clean_varname($filename);

+ $filename = $this->clean_varname($filename);

+

+ /**

+ * Replace slashes in the file name

+ *

+ * @param string $varname name of a cache variable

+ * @return string $varname name that is safe to use as a filename

+ */

+ protected function clean_varname($varname)

+ {

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

+ }

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

+ global $config, $db, $user;

+ global $db;

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

+ global $user;

+ return;

+ return;

+ global $user, $template;

+ global $config;

+ $question_input = $this->acp_get_question_input();

+ 'QUESTION_TEXT' => ($question_input['question_text']) ? $question_input['question_text'] : $question['question_text'],

+ 'LANG_ISO' => ($question_input['lang_iso']) ? $question_input['lang_iso'] : $question['lang_iso'],

+ 'STRICT' => (isset($_REQUEST['strict'])) ? $question_input['strict'] : $question['strict'],

+ 'ANSWERS' => implode("\n", $question['answers']),

+ 'QUESTION_TEXT' => $question_input['question_text'],

+ 'LANG_ISO' => $question_input['lang_iso'],

+ 'STRICT' => $question_input['strict'],

+ 'ANSWERS' => (is_array($question_input['answers'])) ? implode("\n", $question_input['answers']) : '',

+ if (!$this->validate_input($question_input))

+ $this->acp_update_question($question_input, $question_id);

+ $this->acp_add_question($question_input);

+

+ return false;

+

+ // Convert answers into array and filter if answers are set

+ if (strlen($answers))

+ {

+ $answers = array_filter(array_map('trim', explode("\n", $answers)), function ($value) {

+ return $value !== '';

+ });

+ }

+

+ 'answers' => $answers,

+ $where_sql = '';

+

+ $get_visibility_sql_overwrite = false;

+

+ /**

+ * Allow changing the result of calling get_visibility_sql

+ *

+ * @event core.phpbb_content_visibility_get_visibility_sql_before

+ * @var string where_sql Extra visibility conditions. It must end with either an SQL "AND" or an "OR"

+ * @var string mode Either "topic" or "post" depending on the query this is being used in

+ * @var array forum_id The forum id in which the search is made.

+ * @var string table_alias Table alias to prefix in SQL queries

+ * @var mixed get_visibility_sql_overwrite If a string, forces the function to return get_forums_visibility_sql_overwrite after executing the event

+ * If false, get_visibility_sql continues normally

+ * It must be either boolean or string

+ * @since 3.1.4-RC1

+ */

+ $vars = array(

+ 'where_sql',

+ 'mode',

+ 'forum_id',

+ 'table_alias',

+ 'get_visibility_sql_overwrite',

+ );

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

+

+ if ($get_visibility_sql_overwrite !== false)

+ {

+ return $get_visibility_sql_overwrite;

+ }

+

+ return $where_sql . '1 = 1';

+ return $where_sql . $table_alias . $mode . '_visibility = ' . ITEM_APPROVED;

+ return $where_sql . $this->db->sql_in_set($table_alias . 'forum_id', $approve_forums) . ')';

+ return $where_sql . $table_alias . $mode . '_visibility = ' . ITEM_APPROVED . '

+ AND ' . $this->db->sql_in_set($table_alias . 'forum_id', $forum_ids, false, true) . ')';

+use Symfony\Component\HttpFoundation\JsonResponse;

+ // Append page name if base URL does not contain it

+ if (!empty($page_name) && strpos($base_url, '/' . $page_name) === false)

+ {

+ $base_url .= '/' . $page_name;

+ }

+

+ $message_text = call_user_func_array(array($this->user, 'lang'), $parameters);

+ $message_title = $this->user->lang($title);

+

+ if ($this->request->is_ajax())

+ {

+ global $refresh_data;

+

+ return new JsonResponse(

+ array(

+ 'MESSAGE_TITLE' => $message_title,

+ 'MESSAGE_TEXT' => $message_text,

+ 'S_USER_WARNING' => false,

+ 'S_USER_NOTICE' => false,

+ 'REFRESH_DATA' => (!empty($refresh_data)) ? $refresh_data : null

+ ),

+ $code

+ );

+ }

+

+ 'MESSAGE_TEXT' => $message_text,

+ 'MESSAGE_TITLE' => $message_title,

+ return $this->render('message_body.html', $message_title, $code);

+ /**

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

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

+

+class release_3_0_14 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.14', '>=') && phpbb_version_compare($this->config['version'], '3.1.0-dev', '<');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_14_rc1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('if', array(

+ phpbb_version_compare($this->config['version'], '3.0.14', '<'),

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

+ )),

+ );

+ }

+}

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

+

+class release_3_0_14_rc1 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.14-RC1', '>=') && phpbb_version_compare($this->config['version'], '3.1.0-dev', '<');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_13');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('if', array(

+ phpbb_version_compare($this->config['version'], '3.0.14-RC1', '<'),

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

+ )),

+ );

+ }

+}

+ // Get current avatar type of guest user

+ $sql = 'SELECT user_avatar_type

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

+ WHERE user_id = ' . ANONYMOUS;

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

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

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

+

+ // Try to set avatar type to string

+ $sql = 'UPDATE ' . $this->table_prefix . "users

+ SET user_avatar_type = 'avatar.driver.upload'

+ WHERE user_id = " . ANONYMOUS;

+ $this->db->sql_return_on_error(true);

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

+ $this->db->sql_return_on_error();

+

+ // Restore avatar type of guest user to previous state

+ $sql = 'UPDATE ' . $this->table_prefix . "users

+ SET user_avatar_type = '{$backup_type}'

+ WHERE user_id = " . ANONYMOUS;

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

+

+ return $effectively_installed !== false;

+ $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 v314 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v30x\release_3_0_14',

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

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

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

+ );

+ }

+}

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

+{

+ static public function depends_on()

+ {

+ return array(

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

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

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

+ );

+ }

+}

+<?php

+/**

+*

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

+*

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

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

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

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

+

+class v314rc2 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v30x\release_3_0_14_rc1',

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

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.1.4-RC2')),

+ );

+ }

+}

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

+ );

+ }

+}

+ $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->phpbb_root_path . 'cache/container_' . md5($this->phpbb_root_path) . '.' . $this->php_ext;

+ /** @var string The minimum version for the events to return */

+ protected $min_version;

+

+ /** @var string The maximum version for the events to return */

+ protected $max_version;

+

+ * @param string $min_version

+ * @param string $max_version

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

+ $this->min_version = $min_version;

+ $this->max_version = $max_version;

+

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

+

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

+ {

+ $is_filtered = false;

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

+ {

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

+ {

+ $is_filtered = true;

+ break;

+ }

+ }

+

+ if (!$is_filtered)

+ {

+ continue;

+ }

+ }

+ 'changed' => $changes,

+ * The version to check

+ *

+ * @param string $version

+ * @return bool

+ */

+ protected function version_is_filtered($version)

+ {

+ return (!$this->min_version || phpbb_version_compare($this->min_version, $version, '<='))

+ && (!$this->max_version || phpbb_version_compare($this->max_version, $version, '>='));

+ }

+

+ /**

+ *

+ * @param string $action

+ public function export_events_for_wiki($action = '')

+ if ($action === 'diff')

+ {

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

+ }

+ else

+ {

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

+ }

+ if ($action === 'diff')

+ {

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

+ }

+ else

+ {

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

+ }

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

+ }

+

+ /**

+ /** @var string The minimum version for the events to return */

+ protected $min_version;

+

+ /** @var string The maximum version for the events to return */

+ protected $max_version;

+

+ * @param string $min_version

+ * @param string $max_version

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

+ $this->min_version = $min_version;

+ $this->max_version = $max_version;

+ *

+ * @param string $action

+ public function export_events_for_wiki($action = '')

+ if ($action === 'diff')

+ {

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

+ }

+ else

+ {

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

+ }

+ $changed_line_nums = $this->find_changed('changed');

+ if (empty($changed_line_nums))

+ {

+ $changed_line_nums = $this->find_changed('change');

+ }

+ $changed_versions = array();

+ if (!empty($changed_line_nums))

+ {

+ foreach ($changed_line_nums as $changed_line_num)

+ {

+ $changed_versions[] = $this->validate_changed($this->file_lines[$changed_line_num]);

+ }

+ }

+

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

+ {

+ $valid_version = false;

+ foreach ($changed_versions as $changed)

+ {

+ $valid_version = $valid_version || $this->version_is_filtered($changed);

+ }

+

+ if (!$valid_version)

+ {

+ continue;

+ }

+ }

+

+ * The version to check

+ *

+ * @param string $version

+ * @return bool

+ */

+ protected function version_is_filtered($version)

+ {

+ return (!$this->min_version || phpbb_version_compare($this->min_version, $version, '<='))

+ && (!$this->max_version || phpbb_version_compare($this->max_version, $version, '>='));

+ }

+

+ /**

+ * Find the "@changed" Information lines

+ *

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

+ * @return array Absolute line numbers

+ * @throws \LogicException

+ */

+ public function find_changed($tag_name)

+ {

+ $lines = array();

+ $last_line = 0;

+ try

+ {

+ while ($line = $this->find_tag($tag_name, array('since'), $last_line))

+ {

+ $lines[] = $line;

+ $last_line = $line;

+ }

+ }

+ catch (\LogicException $e)

+ {

+ // Not changed? No problem!

+ }

+

+ return $lines;

+ }

+

+ /**

+ * @param int $skip_to_line Skip lines until this one

+ public function find_tag($find_tag, $disallowed_tags, $skip_to_line = 0)

+ $find_tag_line = $skip_to_line ? $this->current_event_line - $skip_to_line + 1 : 0;

+ $found_comment_end = ($skip_to_line) ? true : false;

+ * Validate "@changed" Information

+ *

+ * @param string $line

+ * @return string

+ * @throws \LogicException

+ */

+ public function validate_changed($line)

+ {

+ $match = array();

+ $line = str_replace("\t", ' ', ltrim($line, "\t "));

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

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

+ {

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

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

+ }

+

+ return $match[2];

+ }

+

+ /**

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

+ *

+ *

+ if ($user['user_type'] == USER_IGNORE || ($user['user_type'] == USER_INACTIVE && $user['user_inactive_reason'] == INACTIVE_MANUAL) || in_array($notification->user_id, $banned_users))

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

+ * @param array $defaults List of default driver types

+ 'm_info' => array('lang' => 'ACL_M_INFO', 'cat' => 'post_actions'),

+ 'm_softdelete' => array('lang' => 'ACL_M_SOFTDELETE', 'cat' => 'post_actions'),

+ (int) $this->config['img_max_width'],

+ (int) $this->config['img_max_height']

+ if (!phpbb_is_writable($this->temporary_directory) || !move_uploaded_file($upload['tmp_name'], $tmp_file))

+ * 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 string type Either "posts" or "topics" specifying the type of search being made

+ * @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 string sql_firstpost The SQL with the conditions to join the tables when using firstpost_only

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

+ 'type',

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

+ 'sql_firstpost',

+ '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 total_results The previous result count for the format of the query

+ * Set to 0 to force a re-count

+ * @var array sql_array The data on how to search in the DB at this point

+ * @var bool left_join_topics Whether 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 bool 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',

+ 'total_results',

+ 'sql_array',

+ 'left_join_topics',

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

+

+ // if using mysql and the total result count is not calculated yet, get it from the db

+ if (!$total_results && $is_mysql)

+ {

+ // Also count rows for the query as if there was not LIMIT. Add SQL_CALC_FOUND_ROWS to SQL

+ $sql_array['SELECT'] = 'SQL_CALC_FOUND_ROWS ' . $sql_array['SELECT'];

+ }

+

+ // Get the number of results as calculated by MySQL

+ /**

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

+ $forum_id = $request->variable('f', 0);

+ // maximum forum id value is maximum value of mediumint unsigned column

+ $forum_id = ($forum_id > 0 && $forum_id < 16777215) ? $forum_id : 0;

+

+ 'forum' => $forum_id,

+ global $SID, $_SID, $db, $config, $cache, $phpbb_root_path, $phpEx, $phpbb_container, $phpbb_dispatcher;

+ $session_data = $sql_ary;

+ /**

+ * Event to send new session data to extension

+ * Read-only event

+ *

+ * @event core.session_create_after

+ * @var array session_data Associative array of session keys to be updated

+ * @since 3.1.6-RC1

+ */

+ $vars = array('session_data');

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

+ unset($session_data);

+

+ global $SID, $_SID, $db, $config, $phpbb_root_path, $phpEx, $phpbb_container, $phpbb_dispatcher;

+ $user_id = (int) $this->data['user_id'];

+ $session_id = $this->session_id;

+ /**

+ * Event to send session kill information to extension

+ * Read-only event

+ *

+ * @event core.session_kill_after

+ * @var int user_id user_id of the session user.

+ * @var string session_id current user's session_id

+ * @var bool new_session should we create new session for user

+ * @since 3.1.6-RC1

+ */

+ $vars = array('user_id', 'session_id', 'new_session');

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

+ unset($user_id);

+ unset($session_id);

+

+ global $db, $config, $phpbb_root_path, $phpEx, $phpbb_container, $phpbb_dispatcher;

+ /**

+ * Event to trigger extension on session_gc

+ *

+ * @event core.session_gc_after

+ * @since 3.1.6-RC1

+ */

+ $phpbb_dispatcher->dispatch('core.session_gc_after');

+

+ global $db, $phpbb_dispatcher;

+

+ /**

+ * Event to send update session information to extension

+ * Read-only event

+ *

+ * @event core.update_session_after

+ * @var array session_data Associative array of session keys to be updated

+ * @var string session_id current user's session_id

+ * @since 3.1.6-RC1

+ */

+ $vars = array('session_data', 'session_id');

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

+ if (isset($this->cache[$name]))

+ {

+ if ($this->getAttribute('capture'))

+ {

+ ->raw(' rel="stylesheet" type="text/css" media="screen" />')

+ if ($this->getAttribute('ignore_missing'))

+ {

+ if ($this->getAttribute('ignore_missing'))

+ {

+ if ($stream->test(\Twig_Token::OPERATOR_TYPE, '='))

+ {

+ }

+ else

+ {

+ if ($stream->test(\Twig_Token::NAME_TYPE, 'ignore'))

+ {

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

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

+

+ foreach ($rows as $row)

+ if (strpos($phpbb_root_path . $filename, $lang_path) === 0)

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

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

+ return get_user_avatar($user['user_avatar'], $user['user_avatar_type'], $user['user_avatar_width'], $user['user_avatar_height'], 'USER_AVATAR', false, $lazy);