-* [](http://travis-ci.org/phpbb/phpbb)[](https://ci.appveyor.com/project/phpBB/phpbb/branch/master) **master** - Latest development version

-* [](http://travis-ci.org/phpbb/phpbb)[](https://ci.appveyor.com/project/phpBB/phpbb/branch/3.3.x) **3.3.x** - Development of version 3.3.x

-* [](http://travis-ci.org/phpbb/phpbb)[](https://ci.appveyor.com/project/phpBB/phpbb/branch/3.2.x) **3.2.x** - Development of version 3.2.x

- <property name="newversion" value="3.3.0-b2-dev" />

- <property name="prevversion" value="3.3.0-b1" />

- <property name="olderversions" value="3.1.0, 3.1.1, 3.1.2, 3.1.3, 3.1.4, 3.1.5, 3.1.6, 3.1.7, 3.1.7-pl1, 3.1.8, 3.1.9, 3.1.10, 3.1.11, 3.1.12, 3.2.0-a1, 3.2.0-a2, 3.2.0-b1, 3.2.0-b2, 3.2.0-RC1, 3.2.0-RC2, 3.2.0, 3.2.1, 3.2.2, 3.2.3, 3.2.4, 3.2.5, 3.2.6, 3.2.7, 3.2.8" />

- var orientation = el.attr('data-color-palette'),

- $('[data-color-palette]').each(function() {

- - '@dbal.conn'

- - '@service_container'

- - '@dbal.conn'

- - '@passwords.manager'

- - '@dbal.conn'

- - '@passwords.manager'

- - '@dbal.conn'

- - '@passwords.manager'

- - '@auth.provider.oauth.service_collection'

- - '@service_container'

- - '@dispatcher'

- console.command.fixup.recalculate_email_hash:

- class: phpbb\console\command\fixup\recalculate_email_hash

- arguments:

- - '@user'

- - '@dbal.conn'

- tags:

- - { name: console.command }

-

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

-*

-*/

-

-//

-// Security message:

-//

-// This script is potentially dangerous.

-// Remove or comment the next line (die(".... ) to enable this script.

-// Do NOT FORGET to either remove this script or disable it after you have used it.

-//

-die("Please read the first lines of this script for instructions on how to enable it");

-@set_time_limit(300);

-

-$db = $dbhost = $dbuser = $dbpasswd = $dbport = $dbname = '';

-

-define('IN_PHPBB', 1);

-define('ANONYMOUS', 1);

-$phpEx = substr(strrchr(__FILE__, '.'), 1);

-$phpbb_root_path='./../';

-include($phpbb_root_path . 'config.'.$phpEx);

-require($phpbb_root_path . 'includes/acm/acm_' . $acm_type . '.'.$phpEx);

-require($phpbb_root_path . 'includes/db/' . $dbms . '.'.$phpEx);

-include($phpbb_root_path . 'includes/functions.'.$phpEx);

-

-$cache = new acm();

-$db = new sql_db();

-

-// Connect to DB

-$db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport, false);

-

-$start = 0;

-do

-{

- // Batch query for group members, call group_user_del

- $sql = "SELECT user_id, user_email

- FROM {$table_prefix}users

- LIMIT $start, 100";

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

-

- if ($row = $db->sql_fetchrow($result))

- {

- do

- {

- $sql = "UPDATE {$table_prefix}users

- SET user_email_hash = " . (crc32(strtolower($row['user_email'])) . strlen($row['user_email'])) . '

- WHERE user_id = ' . $row['user_id'];

- $db->sql_query($sql);

-

- $start++;

- }

- while ($row = $db->sql_fetchrow($result));

-

- echo "<br />Batch -> $start\n";

- flush();

- }

- else

- {

- $start = 0;

- }

- $db->sql_freeresult($result);

-}

-while ($start);

-

-echo "<p><b>Done</b></p>\n";

-<?php

-/**

-* Corrects user_email_hash values if DB moved from 32-bit system to 64-bit system or vice versa.

-* The CRC32 function in PHP generates different results for both systems.

-* @PHP dev team: no, a hexdec() applied to it does not solve the issue. And please document it.

-*

-*/

-die("Please read the first lines of this script for instructions on how to enable it");

-

-set_time_limit(0);

-

-define('IN_PHPBB', true);

-$phpbb_root_path = './../';

-$phpEx = substr(strrchr(__FILE__, '.'), 1);

-include($phpbb_root_path . 'common.' . $phpEx);

-

-// Start session management

-$user->session_begin();

-$auth->acl($user->data);

-$user->setup();

-

-$start = $request->variable('start', 0);

-$num_items = 1000;

-

-echo '<br />Updating user email hashes' . "\n";

-

-$sql = 'SELECT user_id, user_email

- FROM ' . USERS_TABLE . '

- ORDER BY user_id ASC';

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

-

-$echos = 0;

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

-{

- $echos++;

-

- $sql = 'UPDATE ' . USERS_TABLE . "

- SET user_email_hash = '" . $db->sql_escape(phpbb_email_hash($row['user_email'])) . "'

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

- $db->sql_query($sql);

-

- if ($echos == 200)

- {

- echo '<br />';

- $echos = 0;

- }

-

- echo '.';

- flush();

-}

-$db->sql_freeresult($result);

-

-echo 'FINISHED';

-

-// Done

-$db->sql_close();

- <li><strong>PHP 7.1.0+</strong> but less than <strong>PHP 7.4</strong> with support for the database you intend to use.</li>

-PHPBB_ACM_MEMCACHE_PORT (overwrite memcached port, default is 11211)

-PHPBB_ACM_MEMCACHE_COMPRESS (overwrite memcached compress setting, default is disabled)

-PHPBB_ACM_MEMCACHE_HOST (overwrite memcached host name, default is localhost)

- try_files $uri $uri/ @rewrite_installapp;

- try_files $uri $uri/ /install/app.php$is_args$args;

- $sql_ary += array(

- 'user_email' => $update_email,

- 'user_email_hash' => phpbb_email_hash($update_email),

- );

-@define('PHPBB_VERSION', '3.3.0-b2-dev');

-* Hashes an email address to a big integer

-*

-* @param string $email Email address

-*

-* @return string Unsigned Big Integer

-*/

-function phpbb_email_hash($email)

-{

- return sprintf('%u', crc32(strtolower($email))) . strlen($email);

-}

-

-/**

-* Generate the email hash stored in the users table

-*

-* Note: Deprecated, calls should directly go to phpbb_email_hash()

-*/

-function gen_email_hash($email)

-{

- return phpbb_email_hash($email);

-}

-

-/**

-* Wrapper for sending out emails with the PHP's mail function

-*/

- // We use the EOL character for the OS here because the PHP mail function does not correctly transform line endings. On Windows SMTP is used (SMTP is \r\n), on UNIX a command is used...

- // Reference: http://bugs.php.net/bug.php?id=15841

- // On some PHP Versions mail() *may* fail if there are newlines within the subject.

- // Newlines are used as a delimiter for lines in mail_encode() according to RFC 2045 section 6.8.

- // Because PHP can't decide what is wanted we revert back to the non-RFC-compliant way of separating by one space (Use '' as parameter to mail_encode() results in SPACE used)

- 'user_email_hash' => phpbb_email_hash($user_row['user_email']),

- $sql = 'SELECT user_email_hash

- WHERE user_email_hash = " . $db->sql_escape(phpbb_email_hash($email));

-

- 'user_email_hash' => ($auth->acl_get('u_chgemail')) ? phpbb_email_hash($data['email']) : $user->data['user_email_hash'],

- $coppa = $request->is_set('coppa') ? (int) $request->variable('coppa', false) : false;

- if ($agreed)

- {

- add_form_key('ucp_register');

- }

- else

- {

- add_form_key('ucp_register_terms');

- }

- 'L_COPPA_NO' => sprintf($user->lang['UCP_COPPA_BEFORE'], $coppa_birthday),

- 'L_COPPA_YES' => sprintf($user->lang['UCP_COPPA_ON_AFTER'], $coppa_birthday),

-

- 'U_COPPA_NO' => append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=register&amp;coppa=0'),

- 'U_COPPA_YES' => append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=register&amp;coppa=1'),

- WHERE user_email_hash = '" . $db->sql_escape(phpbb_email_hash($email)) . "'

- 'phpbb_version' => '3.3.0',

- array('user_email_hash', 'users.user_email', 'gen_email_hash'),

-define('PHPBB_VERSION', '3.3.0-b2-dev');

-INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '3.3.0-b2-dev');

- 'CLI_DESCRIPTION_RECALCULATE_EMAIL_HASH' => 'Recalculates the user_email_hash column of the users table.',

-

- 'CLI_FIXUP_RECALCULATE_EMAIL_HASH_SUCCESS' => 'Successfully recalculated all email hashes.',

-class apache extends \phpbb\auth\provider\base

- /**

- * phpBB passwords manager

- *

- * @var \phpbb\passwords\manager

- */

- protected $passwords_manager;

- * @param \phpbb\db\driver\driver_interface $db Database object

- * @param \phpbb\config\config $config Config object

- * @param \phpbb\passwords\manager $passwords_manager Passwords Manager object

- * @param \phpbb\request\request $request Request object

- * @param \phpbb\user $user User object

- public function __construct(\phpbb\db\driver\driver_interface $db, \phpbb\config\config $config, \phpbb\passwords\manager $passwords_manager, \phpbb\request\request $request, \phpbb\user $user, $phpbb_root_path, $php_ext)

- $this->db = $db;

- $this->passwords_manager = $passwords_manager;

- if (!$this->request->is_set('PHP_AUTH_USER', \phpbb\request\request_interface::SERVER) || $this->user->data['username'] !== htmlspecialchars_decode($this->request->server('PHP_AUTH_USER')))

- return $this->user->lang['APACHE_SETUP_BEFORE_USE'];

- if (!$this->request->is_set('PHP_AUTH_USER', \phpbb\request\request_interface::SERVER))

- 'user_row' => $this->user_row($php_auth_user, $php_auth_pw),

- if (!$this->request->is_set('PHP_AUTH_USER', \phpbb\request\request_interface::SERVER))

- set_var($php_auth_user, $php_auth_user, 'string', true);

- set_var($php_auth_pw, $php_auth_pw, 'string', true);

- user_add($this->user_row($php_auth_user, $php_auth_pw));

- * @param string $password The password of the new user.

- private function user_row($username, $password)

- 'user_password' => $this->passwords_manager->hash($password),

- if ($this->request->is_set('PHP_AUTH_USER', \phpbb\request\request_interface::SERVER))

-abstract class base implements \phpbb\auth\provider\provider_interface

-class db extends \phpbb\auth\provider\base

- * @var \phpbb\passwords\manager

- * DI container

- *

- * @var \Symfony\Component\DependencyInjection\ContainerInterface

- */

- protected $phpbb_container;

-

- /**

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

- * @param \phpbb\config\config $config

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

- * @param \phpbb\request\request $request

- * @param \phpbb\user $user

- * @param \Symfony\Component\DependencyInjection\ContainerInterface $phpbb_container DI container

- public function __construct(\phpbb\db\driver\driver_interface $db, \phpbb\config\config $config, \phpbb\passwords\manager $passwords_manager, \phpbb\request\request $request, \phpbb\user $user, \Symfony\Component\DependencyInjection\ContainerInterface $phpbb_container, $phpbb_root_path, $php_ext)

- $this->db = $db;

- $this->phpbb_container = $phpbb_container;

- /* @var $captcha_factory \phpbb\captcha\factory */

- $captcha_factory = $this->phpbb_container->get('captcha.factory');

- $captcha = $captcha_factory->get_instance($this->config['captcha_plugin']);

-class ldap extends \phpbb\auth\provider\base

- /**

- * phpBB passwords manager

- *

- * @var \phpbb\passwords\manager

- */

- protected $passwords_manager;

- * @param \phpbb\db\driver\driver_interface $db Database object

- * @param \phpbb\config\config $config Config object

- * @param \phpbb\passwords\manager $passwords_manager Passwords manager object

- * @param \phpbb\user $user User object

- public function __construct(\phpbb\db\driver\driver_interface $db, \phpbb\config\config $config, \phpbb\passwords\manager $passwords_manager, \phpbb\user $user)

- $this->db = $db;

- $this->passwords_manager = $passwords_manager;

- return $this->user->lang['LDAP_NO_LDAP_EXTENSION'];

- return $this->user->lang['LDAP_NO_SERVER_CONNECTION'];

- return $this->user->lang['LDAP_INCORRECT_USER_PASSWORD'];

- return $this->user->lang['LDAP_SEARCH_FAILED'];

- return sprintf($this->user->lang['LDAP_NO_IDENTITY'], $this->user->data['username']);

- return $this->user->lang['LDAP_NO_EMAIL'];

- 'user_password' => $this->passwords_manager->hash($password),

-*

-* 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.

-*

-*/

-* OAuth authentication provider for phpBB3

-*/

-class oauth extends \phpbb\auth\provider\base

- /**

- * Database driver

- *

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

- */

- protected $db;

-

- /**

- * phpBB config

- *

- * @var \phpbb\config\config

- */

- /**

- * phpBB passwords manager

- *

- * @var \phpbb\passwords\manager

- */

- protected $passwords_manager;

-

- /**

- * phpBB request object

- *

- * @var \phpbb\request\request_interface

- */

- protected $request;

- /**

- * phpBB user

- *

- * @var \phpbb\user

- */

- protected $user;

- /**

- * OAuth token table

- *

- * @var string

- */

- protected $auth_provider_oauth_token_storage_table;

- /**

- * OAuth state table

- *

- * @var string

- */

- protected $auth_provider_oauth_state_table;

- /**

- * OAuth account association table

- *

- * @var string

- */

- protected $auth_provider_oauth_token_account_assoc;

- /**

- * All OAuth service providers

- *

- * @var \phpbb\di\service_collection Contains \phpbb\auth\provider\oauth\service_interface

- */

- /**

- * Users table

- *

- * @var string

- */

- protected $users_table;

- /**

- * Cached current uri object

- *

- * @var \OAuth\Common\Http\Uri\UriInterface|null

- */

- protected $current_uri;

- /**

- * DI container

- *

- * @var \Symfony\Component\DependencyInjection\ContainerInterface

- */

- protected $phpbb_container;

- /**

- * phpBB event dispatcher

- *

- * @var \phpbb\event\dispatcher_interface

- */

- protected $dispatcher;

- /**

- * phpBB root path

- *

- * @var string

- */

- protected $phpbb_root_path;

- /**

- * PHP file extension

- *

- * @var string

- */

- * OAuth Authentication Constructor

- *

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

- * @param \phpbb\config\config $config

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

- * @param \phpbb\request\request_interface $request

- * @param \phpbb\user $user

- * @param string $auth_provider_oauth_token_storage_table

- * @param string $auth_provider_oauth_state_table

- * @param string $auth_provider_oauth_token_account_assoc

- * @param \phpbb\di\service_collection $service_providers Contains \phpbb\auth\provider\oauth\service_interface

- * @param string $users_table

- * @param \Symfony\Component\DependencyInjection\ContainerInterface $phpbb_container DI container

- * @param \phpbb\event\dispatcher_interface $dispatcher phpBB event dispatcher

- * @param string $phpbb_root_path

- * @param string $php_ext

- */

- public function __construct(\phpbb\db\driver\driver_interface $db, \phpbb\config\config $config, \phpbb\passwords\manager $passwords_manager, \phpbb\request\request_interface $request, \phpbb\user $user, $auth_provider_oauth_token_storage_table, $auth_provider_oauth_state_table, $auth_provider_oauth_token_account_assoc, \phpbb\di\service_collection $service_providers, $users_table, \Symfony\Component\DependencyInjection\ContainerInterface $phpbb_container, \phpbb\event\dispatcher_interface $dispatcher, $phpbb_root_path, $php_ext)

- $this->db = $db;

- $this->config = $config;

- $this->passwords_manager = $passwords_manager;

- $this->request = $request;

- $this->user = $user;

- $this->auth_provider_oauth_token_storage_table = $auth_provider_oauth_token_storage_table;

- $this->auth_provider_oauth_state_table = $auth_provider_oauth_state_table;

- $this->auth_provider_oauth_token_account_assoc = $auth_provider_oauth_token_account_assoc;

- $this->service_providers = $service_providers;

- $this->users_table = $users_table;

- $this->phpbb_container = $phpbb_container;

- $this->dispatcher = $dispatcher;

- $this->phpbb_root_path = $phpbb_root_path;

- $this->php_ext = $php_ext;

- * {@inheritdoc}

- */

- return $this->user->lang['AUTH_PROVIDER_OAUTH_ERROR_ELEMENT_MISSING'];

- * {@inheritdoc}

- */

- $provider = new \phpbb\auth\provider\db($this->db, $this->config, $this->passwords_manager, $this->request, $this->user, $this->phpbb_container, $this->phpbb_root_path, $this->php_ext);

- return $provider->login($username, $password);

- $service_name_original = $this->request->variable('oauth_service', '', false);

- $service_name = 'auth.provider.oauth.service.' . strtolower($service_name_original);

- if ($service_name_original === '' || !array_key_exists($service_name, $this->service_providers))

- return array(

- 'user_row' => array('user_id' => ANONYMOUS),

- );

- $service_credentials = $this->service_providers[$service_name]->get_service_credentials();

- $storage = new \phpbb\auth\provider\oauth\token_storage($this->db, $this->user, $this->auth_provider_oauth_token_storage_table, $this->auth_provider_oauth_state_table);

- $query = 'mode=login&login=external&oauth_service=' . $service_name_original;

- $service = $this->get_service($service_name_original, $storage, $service_credentials, $query, $this->service_providers[$service_name]->get_auth_scope());

- if (($service::OAUTH_VERSION === 2 && $this->request->is_set('code', \phpbb\request\request_interface::GET))

- || ($service::OAUTH_VERSION === 1 && $this->request->is_set('oauth_token', \phpbb\request\request_interface::GET)))

- $unique_id = $this->service_providers[$service_name]->perform_auth_login();

- * Enforcing a data type to make data contains strings and not integers,

- $data = array(

- 'provider' => (string) $service_name_original,

- );

- $sql = 'SELECT user_id FROM ' . $this->auth_provider_oauth_token_account_assoc . '

- 'login_link_oauth_service' => $service_name_original,

- * Event is triggered before check if provider is already associated with an account

- *

- * @event core.oauth_login_after_check_if_provider_id_has_match

- * @var array row User row

- * @var array data Provider data

- * @var array redirect_data Data to be appended to the redirect url

- * @var \OAuth\Common\Service\ServiceInterface service OAuth service

- * @since 3.2.3-RC1

- * @changed 3.2.6-RC1 Added redirect_data

- */

- $vars = array(

- );

- return array(

- 'user_row' => array(),

- );

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

- throw new \Exception('AUTH_PROVIDER_OAUTH_ERROR_INVALID_ENTRY');

- * The fourth parameter, return, has to be true,

- * otherwise the OAuth login is still called and

- * an uncaught exception is thrown as there is no

- * token stored in the database.

- $contact_link = phpbb_get_board_contact_link($this->config, $this->phpbb_root_path, $this->php_ext);

- $message = $this->user->lang($message, $till_date, '<a href="' . $contact_link . '">', '</a>');

- $message .= !empty($ban['ban_give_reason']) ? '<br /><br />' . $this->user->lang('BOARD_BAN_REASON', $ban['ban_give_reason']) : '';

- $message .= !empty($ban['ban_triggered_by']) ? '<br /><br /><em>' . $this->user->lang('BAN_TRIGGERED_BY_' . strtoupper($ban['ban_triggered_by'])) . '</em>' : '';

- return array(

- );

- * Event is triggered after user is successfully logged in via OAuth.

- *

- * @event core.auth_oauth_login_after

- * @var array row User row

- * @since 3.1.11-RC1

- */

- $vars = array(

- );

- return array(

- );

- if ($service::OAUTH_VERSION === 1)

- {

- $token = $service->requestRequestToken();

- $url = $service->getAuthorizationUri(array('oauth_token' => $token->getRequestToken()));

- }

- else

- {

- $url = $service->getAuthorizationUri();

- }

- header('Location: ' . $url);

- }

- }

-

- /**

- * Returns the cached current_uri object or creates and caches it if it is

- * not already created. In each case the query string is updated based on

- * the $query parameter.

- *

- * @param string $service_name The name of the service

- * @param string $query The query string of the current_uri

- * used in redirects

- * @return \OAuth\Common\Http\Uri\UriInterface

- */

- protected function get_current_uri($service_name, $query)

- {

- if ($this->current_uri)

- {

- $this->current_uri->setQuery($query);

- return $this->current_uri;

- }

-

- $uri_factory = new \OAuth\Common\Http\Uri\UriFactory();

- $super_globals = $this->request->get_super_global(\phpbb\request\request_interface::SERVER);

- if (!empty($super_globals['HTTP_X_FORWARDED_PROTO']) && $super_globals['HTTP_X_FORWARDED_PROTO'] === 'https')

- {

- $super_globals['HTTPS'] = 'on';

- $super_globals['SERVER_PORT'] = 443;

- }

- $current_uri = $uri_factory->createFromSuperGlobalArray($super_globals);

- $current_uri->setQuery($query);

-

- $this->current_uri = $current_uri;

- return $current_uri;

- }

-

- /**

- * Returns a new service object

- *

- * @param string $service_name The name of the service

- * @param \phpbb\auth\provider\oauth\token_storage $storage

- * @param array $service_credentials {@see \phpbb\auth\provider\oauth\oauth::get_service_credentials}

- * @param string $query The query string of the

- * current_uri used in redirection

- * @param array $scopes The scope of the request against

- * the api.

- * @return \OAuth\Common\Service\ServiceInterface

- * @throws \Exception

- */

- protected function get_service($service_name, \phpbb\auth\provider\oauth\token_storage $storage, array $service_credentials, $query, array $scopes = array())

- {

- $current_uri = $this->get_current_uri($service_name, $query);

-

- // Setup the credentials for the requests

- $credentials = new Credentials(

- $service_credentials['key'],

- $service_credentials['secret'],

- $current_uri->getAbsoluteUri()

- );

-

- $service_factory = new \OAuth\ServiceFactory();

- $service = $service_factory->createService($service_name, $credentials, $storage, $scopes);

-

- if (!$service)

- {

- throw new \Exception('AUTH_PROVIDER_OAUTH_ERROR_SERVICE_NOT_CREATED');

-

- return $service;

- * {@inheritdoc}

- */

- $login_data = array(

- 'BLOCK_VARS' => array(),

- );

- $actual_name = str_replace('auth.provider.oauth.service.', '', $service_name);

- $redirect_url = generate_board_url() . '/ucp.' . $this->php_ext . '?mode=login&login=external&oauth_service=' . $actual_name;

- $login_data['BLOCK_VARS'][$service_name] = array(

- 'SERVICE_NAME' => $this->user->lang['AUTH_PROVIDER_OAUTH_SERVICE_' . strtoupper($actual_name)],

- );

- * {@inheritdoc}

- */

- $ret = array();

- $actual_name = str_replace('auth.provider.oauth.service.', '', $service_name);

- $ret[] = 'auth_oauth_' . $actual_name . '_key';

- $ret[] = 'auth_oauth_' . $actual_name . '_secret';

- * {@inheritdoc}

- */

- $ret = array(

- 'BLOCK_VARS' => array(),

- 'TEMPLATE_VARS' => array(),

- );

- $actual_name = str_replace('auth.provider.oauth.service.', '', $service_name);

- $ret['BLOCK_VARS'][$actual_name] = array(

- 'ACTUAL_NAME' => $this->user->lang['AUTH_PROVIDER_OAUTH_SERVICE_' . strtoupper($actual_name)],

- 'KEY' => $new_config['auth_oauth_' . $actual_name . '_key'],

- 'NAME' => $actual_name,

- 'SECRET' => $new_config['auth_oauth_' . $actual_name . '_secret'],

- );

- * {@inheritdoc}

- */

- * {@inheritdoc}

- */

- !in_array($link_data['link_method'], array(

- 'auth_link',

- 'login_link',

- )))

- $service_name = 'auth.provider.oauth.service.' . strtolower($link_data['oauth_service']);

- * Performs the account linking for login_link

- *

- * @param array $link_data The same variable given to {@see \phpbb\auth\provider\provider_interface::link_account}

- * @param string $service_name The name of the service being used in

- * linking.

- * @return string|null Returns a language constant (string) if an error is

- * encountered, or null on success.

- */

- $storage = new \phpbb\auth\provider\oauth\token_storage($this->db, $this->user, $this->auth_provider_oauth_token_storage_table, $this->auth_provider_oauth_state_table);

- // Prepare the query string

- $query = 'mode=login_link&login_link_oauth_service=' . strtolower($link_data['oauth_service']);

-

- $service_credentials = $this->service_providers[$service_name]->get_service_credentials();

- $scopes = $this->service_providers[$service_name]->get_auth_scope();

- $service = $this->get_service(strtolower($link_data['oauth_service']), $storage, $service_credentials, $query, $scopes);

- // The user has already authenticated successfully, request to authenticate again

- $unique_id = $this->service_providers[$service_name]->perform_token_auth();

- $data = array(

- 'provider' => strtolower($link_data['oauth_service']),

- );

- * Performs the account linking for auth_link

- *

- * @param array $link_data The same variable given to {@see \phpbb\auth\provider\provider_interface::link_account}

- * @param string $service_name The name of the service being used in

- * linking.

- * @return string|null Returns a language constant (string) if an error is

- * encountered, or null on success.

- */

- $storage = new \phpbb\auth\provider\oauth\token_storage($this->db, $this->user, $this->auth_provider_oauth_token_storage_table, $this->auth_provider_oauth_state_table);

- $query = 'i=ucp_auth_link&mode=auth_link&link=1&oauth_service=' . strtolower($link_data['oauth_service']);

- $service_credentials = $this->service_providers[$service_name]->get_service_credentials();

- $scopes = $this->service_providers[$service_name]->get_auth_scope();

- $service = $this->get_service(strtolower($link_data['oauth_service']), $storage, $service_credentials, $query, $scopes);

- if (($service::OAUTH_VERSION === 2 && $this->request->is_set('code', \phpbb\request\request_interface::GET))

- || ($service::OAUTH_VERSION === 1 && $this->request->is_set('oauth_token', \phpbb\request\request_interface::GET)))

- $unique_id = $this->service_providers[$service_name]->perform_auth_login();

- $data = array(

- 'provider' => strtolower($link_data['oauth_service']),

- );

- if ($service::OAUTH_VERSION === 1)

- {

- $token = $service->requestRequestToken();

- $url = $service->getAuthorizationUri(array('oauth_token' => $token->getRequestToken()));

- }

- else

- {

- $url = $service->getAuthorizationUri();

- }

- header('Location: ' . $url);

- * Performs the query that inserts an account link

- *

- * @param array $data This array is passed to db->sql_build_array

- */

- FROM ' . $this->auth_provider_oauth_token_account_assoc . "

- $sql = 'INSERT INTO ' . $this->auth_provider_oauth_token_account_assoc . '

- ' . $this->db->sql_build_array('INSERT', $data);

- * @var array data User row

- $vars = array(

- );

- * {@inheritdoc}

- */

- public function logout($data, $new_session)

- // Clear all tokens belonging to the user

- $storage = new \phpbb\auth\provider\oauth\token_storage($this->db, $this->user, $this->auth_provider_oauth_token_storage_table, $this->auth_provider_oauth_state_table);

- $storage->clearAllTokens();

- return;

- }

- /**

- * {@inheritdoc}

- */

- public function get_auth_link_data($user_id = 0)

- {

- $block_vars = array();

- // Get all external accounts tied to the current user

- $data = array(

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

- $sql = 'SELECT oauth_provider_id, provider FROM ' . $this->auth_provider_oauth_token_account_assoc . '

- WHERE ' . $this->db->sql_build_array('SELECT', $data);

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

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

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

- $oauth_user_ids = array();

- if ($rows !== false && count($rows))

- foreach ($rows as $row)

- $oauth_user_ids[$row['provider']] = $row['oauth_provider_id'];

- unset($rows);

- foreach ($this->service_providers as $service_name => $service_provider)

- // Only include data if the credentials are set

- $credentials = $service_provider->get_service_credentials();

- if ($credentials['key'] && $credentials['secret'])

- {

- $actual_name = str_replace('auth.provider.oauth.service.', '', $service_name);

-

- $block_vars[$service_name] = array(

- 'HIDDEN_FIELDS' => array(

- 'link' => (!isset($oauth_user_ids[$actual_name])),

- 'oauth_service' => $actual_name,

- ),

-

- 'SERVICE_ID' => $actual_name,

- 'SERVICE_NAME' => $this->user->lang['AUTH_PROVIDER_OAUTH_SERVICE_' . strtoupper($actual_name)],

- 'UNIQUE_ID' => (isset($oauth_user_ids[$actual_name])) ? $oauth_user_ids[$actual_name] : null,

- );

- }

- return array(

- 'BLOCK_VAR_NAME' => 'oauth',

- 'BLOCK_VARS' => $block_vars,

- 'TEMPLATE_FILE' => 'ucp_auth_link_oauth.html',

- );

- * {@inheritdoc}

- */

- public function unlink_account(array $link_data)

- if (!array_key_exists('oauth_service', $link_data) || !$link_data['oauth_service'])

- return 'LOGIN_LINK_MISSING_DATA';

- // Remove user specified in $link_data if possible

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

- // Remove the link

- $sql = 'DELETE FROM ' . $this->auth_provider_oauth_token_account_assoc . "

- WHERE provider = '" . $this->db->sql_escape($link_data['oauth_service']) . "'

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

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

- // Clear all tokens belonging to the user on this service

- $service_name = 'auth.provider.oauth.service.' . strtolower($link_data['oauth_service']);

- $storage = new \phpbb\auth\provider\oauth\token_storage($this->db, $this->user, $this->auth_provider_oauth_token_storage_table, $this->auth_provider_oauth_state_table);

- $storage->clearToken($service_name);

-*

-* 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.

-*

-*/

-* Base OAuth abstract class that all OAuth services should implement

-*/

-abstract class base implements \phpbb\auth\provider\oauth\service\service_interface

- * External OAuth service provider

- *

- * @var \OAuth\Common\Service\ServiceInterface

- */

- * {@inheritdoc}

- */

- public function get_external_service_provider()

- return $this->service_provider;

- * {@inheritdoc}

- */

- public function get_auth_scope()

- return array();

- * {@inheritdoc}

- */

-*

-* 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.

-*

-*/

-* Bitly OAuth service

-*/

-class bitly extends \phpbb\auth\provider\oauth\service\base

- /**

- * phpBB config

- *

- * @var \phpbb\config\config

- */

- /**

- * phpBB request

- *

- * @var \phpbb\request\request_interface

- */

- * Constructor

- *

- * @param \phpbb\config\config $config

- * @param \phpbb\request\request_interface $request

- */

- $this->config = $config;

- $this->request = $request;

- * {@inheritdoc}

- */

- return array(

- );

- * {@inheritdoc}

- */

- throw new \phpbb\auth\provider\oauth\service\exception('AUTH_PROVIDER_OAUTH_ERROR_INVALID_SERVICE_TYPE');

- // This was a callback request from bitly, get the token

- $this->service_provider->requestAccessToken($this->request->variable('code', ''));

- // Send a request with it

- $result = json_decode($this->service_provider->request('user/info'), true);

- * {@inheritdoc}

- */

- throw new \phpbb\auth\provider\oauth\service\exception('AUTH_PROVIDER_OAUTH_ERROR_INVALID_SERVICE_TYPE');

- // Send a request with it

- $result = json_decode($this->service_provider->request('user/info'), true);

- // Return the unique identifier returned from bitly

-*

-* 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.

-*

-*/

-* Facebook OAuth service

-*/

- /**

- * phpBB config

- *

- * @var \phpbb\config\config

- */

- /**

- * phpBB request

- *

- * @var \phpbb\request\request_interface

- */

- * Constructor

- *

- * @param \phpbb\config\config $config

- * @param \phpbb\request\request_interface $request

- */

- $this->config = $config;

- $this->request = $request;

- * {@inheritdoc}

- */

- return array(

- );

- * {@inheritdoc}

- */

- // This was a callback request, get the token

- $this->service_provider->requestAccessToken($this->request->variable('code', ''));

- // Send a request with it

- $result = json_decode($this->service_provider->request('/me'), true);

- * {@inheritdoc}

- */

- // Send a request with it

- $result = json_decode($this->service_provider->request('/me'), true);

-*

-* 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.

-*

-*/

-* Google OAuth service

-*/

- /**

- * phpBB config

- *

- * @var \phpbb\config\config

- */

- /**

- * phpBB request

- *

- * @var \phpbb\request\request_interface

- */

- * Constructor

- *

- * @param \phpbb\config\config $config

- * @param \phpbb\request\request_interface $request

- */

- $this->config = $config;

- $this->request = $request;

- * {@inheritdoc}

- */

- return array(

- );

- * {@inheritdoc}

- */

- return array(

- );

- * {@inheritdoc}

- */

- // This was a callback request, get the token

- $this->service_provider->requestAccessToken($this->request->variable('code', ''));

- // Send a request with it

- $result = json_decode($this->service_provider->request('https://www.googleapis.com/oauth2/v1/userinfo'), true);

- * {@inheritdoc}

- */

- // Send a request with it

- $result = json_decode($this->service_provider->request('https://www.googleapis.com/oauth2/v1/userinfo'), true);

-*

-* 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.

-*

-*/

-* OAuth service interface

-*/

- * Returns an array of the scopes necessary for auth

- *

- * @return array An array of the required scopes

- */

- * Returns the external library service provider once it has been set

- *

- * @param \OAuth\Common\Service\ServiceInterface|null

- */

- public function get_external_service_provider();

-

- /**

- * Returns an array containing the service credentials belonging to requested

- * service.

- *

- * @return array An array containing the 'key' and the 'secret' of the

- * service in the form:

- * array(

- * 'key' => string

- * 'secret' => string

- * )

- */

- * Returns the results of the authentication in json format

- *

- * @throws \phpbb\auth\provider\oauth\service\exception

- * @return string The unique identifier returned by the service provider

- * that is used to authenticate the user with phpBB.

- */

- * Returns the results of the authentication in json format

- * Use this function when the user already has an access token

- *

- * @throws \phpbb\auth\provider\oauth\service\exception

- * @return string The unique identifier returned by the service provider

- * that is used to authenticate the user with phpBB.

- */

- * Sets the external library service provider

- *

- * @param \OAuth\Common\Service\ServiceInterface $service_provider

- */

-*

-* 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.

-*

-*/

-* Twitter OAuth service

-*/

-class twitter extends \phpbb\auth\provider\oauth\service\base

- /**

- * phpBB config

- *

- * @var \phpbb\config\config

- */

- /**

- * phpBB request

- *

- * @var \phpbb\request\request_interface

- */

- * Constructor

- *

- * @param \phpbb\config\config $config

- * @param \phpbb\request\request_interface $request

- */

- $this->config = $config;

- $this->request = $request;

- * {@inheritdoc}

- */

- return array(

- );

- * {@inheritdoc}

- */

- throw new \phpbb\auth\provider\oauth\service\exception('AUTH_PROVIDER_OAUTH_ERROR_INVALID_SERVICE_TYPE');

- $token = $storage->retrieveAccessToken('Twitter');

- $tokensecret = $token->getRequestTokenSecret();

- // This was a callback request from twitter, get the token

- $this->service_provider->requestAccessToken(

- $this->request->variable('oauth_token', ''),

- $this->request->variable('oauth_verifier', ''),

- $tokensecret

- );

- $result = json_decode($this->service_provider->request('account/verify_credentials.json'), true);

- // Return the unique identifier returned from twitter

- * {@inheritdoc}

- */

- throw new \phpbb\auth\provider\oauth\service\exception('AUTH_PROVIDER_OAUTH_ERROR_INVALID_SERVICE_TYPE');

- $result = json_decode($this->service_provider->request('account/verify_credentials.json'), true);

- // Return the unique identifier returned from twitter

-*

-* 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.

-*

-*/

-* OAuth storage wrapper for phpbb's cache

-*/

- /**

- * Cache driver.

- *

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

- */

- /**

- * phpBB user

- *

- * @var \phpbb\user

- */

- /**

- * OAuth token table

- *

- * @var string

- */

- /**

- * OAuth state table

- *

- * @var string

- */

- /**

- * @var object|TokenInterface

- */

- /**

- * @var string

- */

- * Creates token storage for phpBB.

- *

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

- * @param \phpbb\user $user

- * @param string $oauth_token_table

- * @param string $oauth_state_table

- */

- $this->db = $db;

- $this->user = $user;

- * {@inheritdoc}

- */

- $data = array(

- );

- * {@inheritdoc}

- */

- $data = array(

- );

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

- WHERE user_id = ' . (int) $this->user->data['user_id'] . '

- ' . ((int) $this->user->data['user_id'] === ANONYMOUS ? "AND session_id = '" . $this->db->sql_escape($this->user->data['session_id']) . "'" : '') . "

- AND provider = '" . $this->db->sql_escape($service) . "'";

- $data = array(

- );

- * {@inheritdoc}

- */

- $data = array(

- );

- return $this->_has_acess_token($data);

- * {@inheritdoc}

- */

- * {@inheritdoc}

- */

- $sql = 'DELETE FROM ' . $this->oauth_token_table . '

- * {@inheritdoc}

- */

- $data = array(

- );

- $sql = 'INSERT INTO ' . $this->oauth_state_table . '

- ' . $this->db->sql_build_array('INSERT', $data);

- * {@inheritdoc}

- */

- $data = array(

- );

- * {@inheritdoc}

- */

- $data = array(

- );

- * {@inheritdoc}

- */

- * {@inheritdoc}

- */

- * Updates the user_id field in the database assosciated with the token

- *

- * @param int $user_id

- */

- SET ' . $this->db->sql_build_array('UPDATE', array(

- 'user_id' => (int) $user_id

- )) . '

- WHERE user_id = ' . (int) $this->user->data['user_id'] . "

- AND session_id = '" . $this->db->sql_escape($this->user->data['session_id']) . "'";

- * Checks to see if an access token exists solely by the session_id of the user

- *

- * @param string $service The name of the OAuth service

- * @return bool true if they have token, false if they don't

- */

- $data = array(

- );

- return $this->_has_acess_token($data);

- * Checks to see if a state exists solely by the session_id of the user

- *

- * @param string $service The name of the OAuth service

- * @return bool true if they have state, false if they don't

- */

- $data = array(

- );

- * A helper function that performs the query for has access token functions

- *

- * @param array $data

- * @return bool

- */

- protected function _has_acess_token($data)

- $data = array(

- 'provider' => $service,

- );

- $data = array(

- 'provider' => $service,

- );

- * A helper function that performs the query for retrieve access token functions

- * Also checks if the token is a valid token

- *

- * @param array $data

- * @return mixed

- * @throws \OAuth\Common\Storage\Exception\TokenNotFoundException

- */

- * A helper function that performs the query for retrieve state functions

- * @param array $data

- * @return mixed

- * @throws \OAuth\Common\Storage\Exception\AuthorizationStateNotFoundException

- * A helper function that performs the query for retrieving an access token

- *

- * @param array $data

- * @return mixed

- */

- $sql = 'SELECT oauth_token FROM ' . $this->oauth_token_table . '

- * A helper function that performs the query for retrieving a state

- * @param array $data

- * @return mixed

- $sql = 'SELECT oauth_state FROM ' . $this->oauth_state_table . '

- $members = array(

- );

- // Create the token

- * Returns the name of the service as it must be stored in the database.

- *

- * @param string $service The name of the OAuth service

- * @return string The name of the OAuth service as it needs to be stored

- * in the database.

- */

- protected function get_service_name_for_db($service)

- if (strpos($service, 'auth.provider.oauth.service.') !== 0)

- $service = 'auth.provider.oauth.service.' . strtolower($service);

- return $service;

- * should take place, or null if not impletmented.

- * options with whatever configuraton values are passed to it as an array.

-<?php

-/**

-*

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

-*

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

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

-*

-* For full copyright and license information, please see

-* the docs/CREDITS.txt file.

-*

-*/

-

-namespace phpbb\cache\driver;

-

-if (!defined('PHPBB_ACM_MEMCACHE_PORT'))

-{

- define('PHPBB_ACM_MEMCACHE_PORT', 11211);

-}

-

-if (!defined('PHPBB_ACM_MEMCACHE_COMPRESS'))

-{

- define('PHPBB_ACM_MEMCACHE_COMPRESS', false);

-}

-

-if (!defined('PHPBB_ACM_MEMCACHE_HOST'))

-{

- define('PHPBB_ACM_MEMCACHE_HOST', 'localhost');

-}

-

-if (!defined('PHPBB_ACM_MEMCACHE'))

-{

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

- define('PHPBB_ACM_MEMCACHE', PHPBB_ACM_MEMCACHE_HOST . '/' . PHPBB_ACM_MEMCACHE_PORT);

-}

-

-/**

-* ACM for Memcached

-*/

-class memcache extends \phpbb\cache\driver\memory

-{

- var $extension = 'memcache';

-

- var $memcache;

- var $flags = 0;

-

- function __construct()

- {

- // Call the parent constructor

- parent::__construct();

-

- $this->memcache = new \Memcache;

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

- {

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

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

- }

- $this->flags = (PHPBB_ACM_MEMCACHE_COMPRESS) ? MEMCACHE_COMPRESSED : 0;

- }

-

- /**

- * {@inheritDoc}

- */

- function unload()

- {

- parent::unload();

-

- $this->memcache->close();

- }

-

- /**

- * {@inheritDoc}

- */

- function purge()

- {

- $this->memcache->flush();

-

- parent::purge();

- }

-

- /**

- * Fetch an item from the cache

- *

- * @access protected

- * @param string $var Cache key

- * @return mixed Cached data

- */

- function _read($var)

- {

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

- }

-

- /**

- * Store data in the cache

- *

- * @access protected

- * @param string $var Cache key

- * @param mixed $data Data to store

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

- * @return bool True if the operation succeeded

- */

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

- {

- if (!$this->memcache->replace($this->key_prefix . $var, $data, $this->flags, $ttl))

- {

- return $this->memcache->set($this->key_prefix . $var, $data, $this->flags, $ttl);

- }

- return true;

- }

-

- /**

- * Remove an item from the cache

- *

- * @access protected

- * @param string $var Cache key

- * @return bool True if the operation succeeded

- */

- function _delete($var)

- {

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

- }

-}

- public function __construct()

- foreach (explode(',', PHPBB_ACM_MEMCACHED) as $u)

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

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

-<?php

-/**

-*

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

-*

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

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

-*

-* For full copyright and license information, please see

-* the docs/CREDITS.txt file.

-*

-*/

-namespace phpbb\console\command\fixup;

-

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

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

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

-

-class recalculate_email_hash extends \phpbb\console\command\command

-{

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

- protected $db;

-

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

- {

- $this->db = $db;

-

- parent::__construct($user);

- }

-

- protected function configure()

- {

- $this

- ->setName('fixup:recalculate-email-hash')

- ->setDescription($this->user->lang('CLI_DESCRIPTION_RECALCULATE_EMAIL_HASH'))

- ;

- }

-

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

- {

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

-

- $sql = 'SELECT user_id, user_email, user_email_hash

- FROM ' . USERS_TABLE . '

- WHERE user_type <> ' . USER_IGNORE . "

- AND user_email <> ''";

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

-

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

- {

- $user_email_hash = phpbb_email_hash($row['user_email']);

- if ($user_email_hash !== $row['user_email_hash'])

- {

- $sql_ary = array(

- 'user_email_hash' => $user_email_hash,

- );

-

- $sql = 'UPDATE ' . USERS_TABLE . '

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

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

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

-

- if ($output->getVerbosity() >= OutputInterface::VERBOSITY_DEBUG)

- {

- $io->table(

- array('user_id', 'user_email', 'user_email_hash'),

- array(array($row['user_id'], $row['user_email'], $user_email_hash))

- );

- }

- }

- }

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

-

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

- }

-}

- $is_visible = $this->auth->acl_get('m_approve', $forum_id) || $data[$mode . '_visibility'] == ITEM_APPROVED;

- $where_sql .= $table_alias . $mode . '_visibility = ' . ITEM_APPROVED;

- }

- // Because of a PHP issue we have to redefine offsetExists

- // (even with a call to the parent):

- // https://bugs.php.net/bug.php?id=66834

- // https://bugs.php.net/bug.php?id=67067

- // But it triggers a sniffer issue that we have to skip

- // @codingStandardsIgnoreStart

- /**

- * {@inheritdoc}

- */

- public function offsetExists($index)

- {

- return parent::offsetExists($index);

- }

- // @codingStandardsIgnoreEnd

-

- * @return null

- $this->offsetSet($name, null);

- user_email_hash = " . $this->db->sql_escape(phpbb_email_hash($this->install_config->get('board_email'))) . ",

- if ($this->is_content_bbcode($without, $with))

- * Such BBCodes include the [URL] BBCode, which uses its text content as

- * @return array Merged definition

- // Convert [X={X}] into [X={X;useContent}]

- * Such BBCodes include the [QUOTE] BBCode, which takes an optional argument

- $link_text_tag = $parser->addSelfClosingTag('LINK_TEXT', $start, $length);

- else if ($msg === 'Tag is disabled')

- $post_url = $this->post_url;

- $profile_url = $this->profile_url;

- $user = $this->user;

-

- function ($attributes) use ($post_url, $profile_url, $user)

- $attributes['post_url'] = str_replace('{POST_ID}', $attributes['post_id'], $post_url);

- $attributes['date'] = $user->format_date($attributes['time']);

- $attributes['profile_url'] = str_replace('{USER_ID}', $attributes['user_id'], $profile_url);

- 'WHERE' => "user_email_hash = '" . $this->db->sql_escape(phpbb_email_hash($email)) . "'" .

- $zebra = array();

-style_version = 3.3.0-b1

-phpbb_version = 3.3.0-b1

- <strong><a href="{U_COPPA_NO}" class="button1">{L_COPPA_NO}</a></strong>&nbsp; <a href="{U_COPPA_YES}" class="button2">{L_COPPA_YES}</a>

-<?xml version="1.0" encoding="UTF-8" ?>

-<dataset>

- <table name="phpbb_users">

- <column>user_id</column>

- <column>username</column>

- <column>username_clean</column>

- <column>user_password</column>

- <column>user_passchg</column>

- <column>user_email</column>

- <column>user_type</column>

- <column>user_login_attempts</column>

- <column>user_permissions</column>

- <column>user_sig</column>

- <row>

- <value>1</value>

- <value>foobar</value>

- <value>foobar</value>

- <value>$2a$10$e01Syh9PbJjUkio66eFuUu4FhCE2nRgG7QPc1JACalsPXcIuG2bbi</value>

- <value>0</value>

- <value>example@example.com</value>

- <value>0</value>

- <value>0</value>

- <value></value>

- <value></value>

- </row>

- <row>

- <value>2</value>

- <value>foobar2</value>

- <value>foobar2</value>

- <value>$H$9E45lK6J8nLTSm9oJE5aNCSTFK9wqa/</value>

- <value>0</value>

- <value>example@example.com</value>

- <value>0</value>

- <value>0</value>

- <value></value>

- <value></value>

- </row>

- </table>

-</dataset>

- $this->user = new \phpbb\user($lang, '\phpbb\datetime');

- $driver_helper = new \phpbb\passwords\driver\helper($config);

- $passwords_drivers = array(

- 'passwords.driver.bcrypt_2y' => new \phpbb\passwords\driver\bcrypt_2y($config, $driver_helper),

- 'passwords.driver.bcrypt' => new \phpbb\passwords\driver\bcrypt($config, $driver_helper),

- 'passwords.driver.salted_md5' => new \phpbb\passwords\driver\salted_md5($config, $driver_helper),

- 'passwords.driver.phpass' => new \phpbb\passwords\driver\phpass($config, $driver_helper),

- );

-

- $passwords_helper = new \phpbb\passwords\helper;

- // Set up passwords manager

- $passwords_manager = new \phpbb\passwords\manager($config, $passwords_drivers, $passwords_helper, array_keys($passwords_drivers));

-

- if (version_compare(PHP_VERSION, '5.3.7', '<'))

- {

- $this->password_hash = '$2a$10$e01Syh9PbJjUkio66eFuUu4FhCE2nRgG7QPc1JACalsPXcIuG2bbi';

- }

- else

- {

- $this->password_hash = '$2y$10$4RmpyVu2y8Yf/lP3.yQBquKvE54TCUuEDEBJYY6FDDFN3LcbCGz9i';

- }

- $this->provider = new \phpbb\auth\provider\apache($db, $config, $passwords_manager, $this->request, $this->user, $phpbb_root_path, $phpEx);

- if ((version_compare(PHP_VERSION, '5.3.7', '<')))

- {

- return $this->createXMLDataSet(dirname(__FILE__).'/fixtures/user_533.xml');

- }

- else

- {

- return $this->createXMLDataSet(dirname(__FILE__).'/fixtures/user.xml');

- }

- 'user_password' => $this->password_hash,

- 'user_password' => $this->password_hash,

- 'user_email_hash' => '0',

- if ((version_compare(PHP_VERSION, '5.3.7', '<')))

- {

- return $this->createXMLDataSet(dirname(__FILE__).'/fixtures/user_533.xml');

- }

- else

- {

- return $this->createXMLDataSet(dirname(__FILE__).'/fixtures/user.xml');

- }

- $provider = new \phpbb\auth\provider\db($db, $config, $passwords_manager, $request, $user, $phpbb_container, $phpbb_root_path, $phpEx);

- if (version_compare(PHP_VERSION, '5.3.7', '<'))

- {

- $password_hash = '$2a$10$e01Syh9PbJjUkio66eFuUu4FhCE2nRgG7QPc1JACalsPXcIuG2bbi';

- }

- else

- {

- $password_hash = '$2y$10$4RmpyVu2y8Yf/lP3.yQBquKvE54TCUuEDEBJYY6FDDFN3LcbCGz9i';

- }

- $password_start = (version_compare(PHP_VERSION, '5.3.7', '<')) ? '$2a$10$' : '$2y$10$';

- $this->assertStringStartsWith($password_start, $login_return['user_row']['user_password']);

- public function test_get_visibility_sql($table, $mode, $forum_id, $table_alias, $permissions, $expected)

- $config = new phpbb\config\config(array());

- $result = $db->sql_query('SELECT ' . $mode . '_id

- ORDER BY ' . $mode . '_id ASC');

- $expected = "(\\[quote=admin time=\\d+ user_id=2\\]\n" . $text . "\n\\[/quote\\])";

- <column>user_email_hash</column>

- <value>143317126117</value>

- $oauth_provider = new \phpbb\auth\provider\oauth\oauth(

- $db,

- $oauth_provider_collection,

- $phpbb_container,

- $phpbb_dispatcher,

- $this->phpbb_root_path,

- $this->php_ext

- if (version_compare(PHP_VERSION, '5.3.7', '<'))

- {

- return array(

- array('', '2a', 60),

- array('passwords.driver.bcrypt_2y', '2a', 60),

- array('passwords.driver.bcrypt', '2a', 60),

- array('passwords.driver.salted_md5', 'H', 34),

- array('passwords.driver.foobar', '', false),

- );

- }

- else

- {

- return array(

- array('', '2y', 60),

- array('passwords.driver.bcrypt_2y', '2y', 60),

- array('passwords.driver.bcrypt', '2a', 60),

- array('passwords.driver.salted_md5', 'H', 34),

- array('passwords.driver.foobar', '', false),

- );

- }

- if (version_compare(PHP_VERSION, '5.3.7', '<'))

- {

- return array(

- array('passwords.driver.bcrypt'),

- array('passwords.driver.salted_md5'),

- array('passwords.driver.phpass'),

- );

- }

- else

- {

- return array(

- array('passwords.driver.bcrypt_2y'),

- array('passwords.driver.bcrypt'),

- array('passwords.driver.salted_md5'),

- array('passwords.driver.phpass'),

- );

- }

- $default_type = (version_compare(PHP_VERSION, '5.3.7', '<')) ? 'passwords.driver.bcrypt' : 'passwords.driver.bcrypt_2y';

- if (version_compare(PHP_VERSION, '5.3.7', '<'))

- {

- $this->assertEquals(false, $this->manager->hash('foobar𝄞', 'passwords.driver.bcrypt_2y'));

- }

- else

- {

- $this->assertNotEquals(false, $this->manager->hash('foobar𝄞', 'passwords.driver.bcrypt_2y'));

- }

- if (version_compare(PHP_VERSION, '5.3.7', '<'))

- {

- return array(

- array(

- 'passwords.driver.salted_md5',

- array('passwords.driver.bcrypt'),

- ),

- array(

- 'passwords.driver.phpass',

- array('passwords.driver.salted_md5'),

- ),

- array(

- 'passwords.driver.salted_md5',

- array('passwords.driver.phpass', 'passwords.driver.bcrypt'),

- ),

- array(

- 'passwords.driver.salted_md5',

- array('passwords.driver.salted_md5'),

- false,

- ),

- array(

- '$H$',

- array('$2a$'),

- ),

- );

- }

- else

- {

- return array(

- array(

- 'passwords.driver.salted_md5',

- array('passwords.driver.bcrypt_2y'),

- ),

- array(

- 'passwords.driver.salted_md5',

- array('passwords.driver.bcrypt'),

- ),

- array(

- 'passwords.driver.phpass',

- array('passwords.driver.salted_md5'),

- ),

- array(

- 'passwords.driver.salted_md5',

- array('passwords.driver.bcrypt_2y', 'passwords.driver.bcrypt'),

- ),

- array(

- 'passwords.driver.salted_md5',

- array('passwords.driver.salted_md5'),

- false,

- ),

- array(

- 'passwords.driver.bcrypt_2y',

- array('passwords.driver.salted_md4'),

- false,

- ),

- array(

- '$H$',

- array('$2y$'),

- ),

- );

- }

- $db_tools = new \phpbb\db\tools($db);

-namespace phpbb\db;

-

-/**

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

- */

-class tools extends \phpbb\db\tools\tools

-# Disable opcache for testing

-echo 'Disabling Opcache'

-echo 'opcache.enable=0' >> "$php_ini_file"

-