+ * phpBB passwords manager

+ *

+ * @var \phpbb\passwords\manager

+ */

+ protected $passwords_manager;

+

+ /**

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

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

+ $this->passwords_manager = $passwords_manager;

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

+ /**

+ * phpBB passwords manager

+ *

+ * @var \phpbb\passwords\manager

+ */

+ protected $passwords_manager;

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

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

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

+ * @param \phpbb\request\request $request

+ * @param \phpbb\user $user

+ * @param string $phpbb_root_path

+ * @param string $php_ext

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

+ $this->passwords_manager = $passwords_manager;

+ if ((strlen($row['user_password']) == 34 && ($this->passwords_manager->check(md5($password_old_format), $row['user_password']) || $this->passwords_manager->check(md5(utf8_to_cp1252($password_old_format)), $row['user_password'])))

+ $hash = $this->passwords_manager->hash($password_new_format);

+ if (!$row['user_pass_convert'] && $this->passwords_manager->check($password, $row['user_password']))

+ if ($this->passwords_manager->convert_flag || strlen($row['user_password']) == 32)

+ $hash = $this->passwords_manager->hash($password);

+ * phpBB passwords manager

+ *

+ * @var \phpbb\passwords\manager

+ */

+ protected $passwords_manager;

+

+ /**

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

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

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

+ * @param \phpbb\user $user

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

+ $this->passwords_manager = $passwords_manager;

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

+ * phpBB passwords manager

+ *

+ * @var \phpbb\passwords\manager

+ */

+ protected $passwords_manager;

+

+ /**

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

+ public function __construct(\phpbb\db\driver\driver $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_token_account_assoc, \phpbb\di\service_collection $service_providers, $users_table, $phpbb_root_path, $php_ext)

+ $this->passwords_manager = $passwords_manager;

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

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+namespace phpbb\console\command\config;

+

+abstract class command extends \phpbb\console\command\command

+{

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

+ protected $config;

+

+ function __construct(\phpbb\config\config $config)

+ {

+ $this->config = $config;

+

+ parent::__construct();

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+namespace phpbb\console\command\config;

+

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

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

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

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

+

+class delete extends command

+{

+ protected function configure()

+ {

+ $this

+ ->setName('config:delete')

+ ->setDescription('Deletes a configuration option')

+ ->addArgument(

+ 'key',

+ InputArgument::REQUIRED,

+ "The configuration option's name"

+ )

+ ;

+ }

+

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

+ {

+ $key = $input->getArgument('key');

+

+ if (isset($this->config[$key]))

+ {

+ $this->config->delete($key);

+

+ $output->writeln("<info>Successfully deleted config $key</info>");

+ }

+ else

+ {

+ $output->writeln("<error>Config $key does not exist</error>");

+ }

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+namespace phpbb\console\command\config;

+

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

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

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

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

+

+class get extends command

+{

+ protected function configure()

+ {

+ $this

+ ->setName('config:get')

+ ->setDescription("Gets a configuration option's value")

+ ->addArgument(

+ 'key',

+ InputArgument::REQUIRED,

+ "The configuration option's name"

+ )

+ ->addOption(

+ 'no-newline',

+ null,

+ InputOption::VALUE_NONE,

+ 'Set this option if the value should be printed without a new line at the end.'

+ )

+ ;

+ }

+

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

+ {

+ $key = $input->getArgument('key');

+

+ if (isset($this->config[$key]) && $input->getOption('no-newline'))

+ {

+ $output->write($this->config[$key]);

+ }

+ elseif (isset($this->config[$key]))

+ {

+ $output->writeln($this->config[$key]);

+ }

+ else

+ {

+ $output->writeln("<error>Could not get config $key</error>");

+ }

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+namespace phpbb\console\command\config;

+

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

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

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

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

+

+class increment extends command

+{

+ protected function configure()

+ {

+ $this

+ ->setName('config:increment')

+ ->setDescription("Increments a configuration option's value")

+ ->addArgument(

+ 'key',

+ InputArgument::REQUIRED,

+ "The configuration option's name"

+ )

+ ->addArgument(

+ 'increment',

+ InputArgument::REQUIRED,

+ 'Amount to increment by'

+ )

+ ->addOption(

+ 'dynamic',

+ 'd',

+ InputOption::VALUE_NONE,

+ 'Set this option if the configuration option changes too frequently to be efficiently cached.'

+ )

+ ;

+ }

+

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

+ {

+ $key = $input->getArgument('key');

+ $increment = $input->getArgument('increment');

+ $use_cache = !$input->getOption('dynamic');

+

+ $this->config->increment($key, $increment, $use_cache);

+

+ $output->writeln("<info>Successfully incremented config $key</info>");

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+namespace phpbb\console\command\config;

+

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

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

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

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

+

+class set extends command

+{

+ protected function configure()

+ {

+ $this

+ ->setName('config:set')

+ ->setDescription("Sets a configuration option's value")

+ ->addArgument(

+ 'key',

+ InputArgument::REQUIRED,

+ "The configuration option's name"

+ )

+ ->addArgument(

+ 'value',

+ InputArgument::REQUIRED,

+ 'New configuration value, use 0 and 1 to specify boolean values'

+ )

+ ->addOption(

+ 'dynamic',

+ 'd',

+ InputOption::VALUE_NONE,

+ 'Set this option if the configuration option changes too frequently to be efficiently cached.'

+ )

+ ;

+ }

+

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

+ {

+ $key = $input->getArgument('key');

+ $value = $input->getArgument('value');

+ $use_cache = !$input->getOption('dynamic');

+

+ $this->config->set($key, $value, $use_cache);

+

+ $output->writeln("<info>Successfully set config $key</info>");

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+namespace phpbb\console\command\config;

+

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

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

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

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

+

+class set_atomic extends command

+{

+ protected function configure()

+ {

+ $this

+ ->setName('config:set-atomic')

+ ->setDescription("Sets a configuration option's value only if the old matches the current value.")

+ ->addArgument(

+ 'key',

+ InputArgument::REQUIRED,

+ "The configuration option's name"

+ )

+ ->addArgument(

+ 'old',

+ InputArgument::REQUIRED,

+ 'Current configuration value, use 0 and 1 to specify boolean values'

+ )

+ ->addArgument(

+ 'new',

+ InputArgument::REQUIRED,

+ 'New configuration value, use 0 and 1 to specify boolean values'

+ )

+ ->addOption(

+ 'dynamic',

+ 'd',

+ InputOption::VALUE_NONE,

+ 'Set this option if the configuration option changes too frequently to be efficiently cached.'

+ )

+ ;

+ }

+

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

+ {

+ $key = $input->getArgument('key');

+ $old_value = $input->getArgument('old');

+ $new_value = $input->getArgument('new');

+ $use_cache = !$input->getOption('dynamic');

+

+ if ($this->config->set_atomic($key, $old_value, $new_value, $use_cache))

+ {

+ $output->writeln("<info>Successfully set config $key</info>");

+ return 0;

+ }

+ else

+ {

+ $output->writeln("<error>Could not set config $key</error>");

+ return 1;

+ }

+ }

+}

+ $this->set_post_visibility($visibility, false, $topic_id, $forum_id, $user_id, $time, '', true, true, $original_topic_data['topic_visibility'], $original_topic_data['topic_delete_time']);

+ $this->set_post_visibility($visibility, false, $topic_id, $forum_id, $user_id, $time, '', true, true, $original_topic_data['topic_visibility']);

+ $this->set_post_visibility($visibility, false, $topic_id, $forum_id, $user_id, $time, '', true, true);

+use Symfony\Component\Routing\Generator\UrlGenerator;

+use Symfony\Component\Routing\RequestContext;

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

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

+ * @param \phpbb\controller\provider $provider Path provider

+ public function __construct(\phpbb\template\template $template, \phpbb\user $user, \phpbb\config\config $config, \phpbb\controller\provider $provider, $phpbb_root_path, $php_ext)

+ $this->route_collection = $provider->get_routes();

+ * Generate a URL to a route

+ * @param string $route Name of the route to travel

+ * @param array $params String or array of additional url parameters

+ public function route($route, array $params = array(), $is_amp = true, $session_id = false)

+ $anchor = '';

+ if (isset($params['#']))

+ $anchor = '#' . $params['#'];

+ unset($params['#']);

+ }

+ $url_generator = new UrlGenerator($this->route_collection, new RequestContext());

+ $route_url = $url_generator->generate($route, $params);

+

+ if (strpos($route_url, '/') === 0)

+ {

+ $route_url = substr($route_url, 1);

+ }

+

+ if ($is_amp)

+ {

+ $route_url = str_replace(array('&amp;', '&'), array('&', '&amp;'), $route_url);

+ return append_sid($route_prefix . $route_url . $anchor, false, $is_amp, $session_id);

+ * Collection of the routes in phpBB and all found extensions

+ * @var RouteCollection

+ */

+ protected $routes;

+

+ /**

+ public function __construct(\phpbb\extension\finder $finder = null, $routing_files = array())

+ if ($finder)

+ {

+ // We hardcode the path to the core config directory

+ // because the finder cannot find it

+ $this->routing_files = array_merge($this->routing_files, array('config/routing.yml'), array_keys($finder

+ ->directory('config')

+ ->suffix('routing.yml')

+ ->find()

+ ));

+ }

+ * Find a list of controllers and return it

+ * @return null

+ $this->routes = new RouteCollection;

+ $this->routes->addCollection($loader->load($file_path));

+ return $this;

+ }

+

+ /**

+ * Get the list of routes

+ *

+ * @return RouteCollection Get the route collection

+ */

+ public function get_routes()

+ {

+ return $this->routes;

+ * Possible query values: INSERT, INSERT_SELECT, UPDATE, SELECT, DELETE

+ else if ($query == 'UPDATE' || $query == 'SELECT' || $query == 'DELETE')

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU Public License v2

+*

+*/

+

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

+

+class alpha3 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\alpha2',

+ '\phpbb\db\migration\data\v310\avatar_types',

+ '\phpbb\db\migration\data\v310\passwords',

+ '\phpbb\db\migration\data\v310\profilefield_types',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.1.0-a3')),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License v2

+*

+*/

+

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

+

+class passwords extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

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

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'change_columns' => array(

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

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

+ ),

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

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

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'change_columns' => array(

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

+ 'user_password' => array('VCHAR:40', ''),

+ ),

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

+ 'forum_password' => array('VCHAR:40', ''),

+ ),

+ ),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License v2

+*

+*/

+

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

+

+class passwords_p2 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v310\passwords');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'change_columns' => array(

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

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

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'change_columns' => array(

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

+ 'user_newpasswd' => array('VCHAR:40', ''),

+ ),

+ ),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

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

+

+class profilefield_aol extends \phpbb\db\migration\profilefield_base_migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_yahoo_cleanup',

+ );

+ }

+

+ protected $profilefield_name = 'phpbb_aol';

+

+ protected $profilefield_database_type = array('VCHAR', '');

+

+ protected $profilefield_data = array(

+ 'field_name' => 'phpbb_aol',

+ 'field_type' => 'profilefields.type.string',

+ 'field_ident' => 'phpbb_aol',

+ 'field_length' => '40',

+ 'field_minlen' => '5',

+ 'field_maxlen' => '255',

+ 'field_novalue' => '',

+ 'field_default_value' => '',

+ 'field_validation' => '.*',

+ 'field_required' => 0,

+ 'field_show_novalue' => 0,

+ 'field_show_on_reg' => 0,

+ 'field_show_on_pm' => 1,

+ 'field_show_on_vt' => 1,

+ 'field_show_on_ml' => 0,

+ 'field_show_profile' => 1,

+ 'field_hide' => 0,

+ 'field_no_view' => 0,

+ 'field_active' => 1,

+ 'field_is_contact' => 1,

+ 'field_contact_desc' => '',

+ 'field_contact_url' => '',

+ );

+

+ protected $user_column_name = 'user_aim';

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+ * @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

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

+

+class profilefield_aol_cleanup extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return !$this->db_tools->sql_column_exists($this->table_prefix . 'users', 'user_aim');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_aol',

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'user_aim',

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

+ 'user_aim' => array('VCHAR_UNI', ''),

+ ),

+ ),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

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

+

+class profilefield_change_load_settings extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_aol_cleanup',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('load_cpf_memberlist', '1')),

+ array('config.update', array('load_cpf_pm', '1')),

+ array('config.update', array('load_cpf_viewprofile', '1')),

+ array('config.update', array('load_cpf_viewtopic', '1')),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License v2

+*

+*/

+

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

+

+class profilefield_cleanup extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return !$this->db_tools->sql_column_exists($this->table_prefix . 'users', 'user_occ') &&

+ !$this->db_tools->sql_column_exists($this->table_prefix . 'users', 'user_interests');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_interests',

+ '\phpbb\db\migration\data\v310\profilefield_occupation',

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'user_occ',

+ 'user_interests',

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

+ 'user_occ' => array('MTEXT', ''),

+ 'user_interests' => array('MTEXT', ''),

+ ),

+ ),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

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

+

+class profilefield_contact_field extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return $this->db_tools->sql_column_exists($this->table_prefix . 'profile_fields', 'field_is_contact');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_on_memberlist',

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

+ 'field_is_contact' => array('BOOL', 0),

+ 'field_contact_desc' => array('VCHAR', ''),

+ 'field_contact_url' => array('VCHAR', ''),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'field_is_contact',

+ 'field_contact_desc',

+ 'field_contact_url',

+ ),

+ ),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

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

+

+class profilefield_icq extends \phpbb\db\migration\profilefield_base_migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_contact_field',

+ );

+ }

+

+ protected $profilefield_name = 'phpbb_icq';

+

+ protected $profilefield_database_type = array('VCHAR', '');

+

+ protected $profilefield_data = array(

+ 'field_name' => 'phpbb_icq',

+ 'field_type' => 'profilefields.type.string',

+ 'field_ident' => 'phpbb_icq',

+ 'field_length' => '20',

+ 'field_minlen' => '3',

+ 'field_maxlen' => '15',

+ 'field_novalue' => '',

+ 'field_default_value' => '',

+ 'field_validation' => '[0-9]+',

+ 'field_required' => 0,

+ 'field_show_novalue' => 0,

+ 'field_show_on_reg' => 0,

+ 'field_show_on_pm' => 1,

+ 'field_show_on_vt' => 1,

+ 'field_show_profile' => 1,

+ 'field_hide' => 0,

+ 'field_no_view' => 0,

+ 'field_active' => 1,

+ 'field_is_contact' => 1,

+ 'field_contact_desc' => 'SEND_ICQ_MESSAGE',

+ 'field_contact_url' => 'https://www.icq.com/people/%s/',

+ );

+

+ protected $user_column_name = 'user_icq';

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

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

+

+class profilefield_icq_cleanup extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return !$this->db_tools->sql_column_exists($this->table_prefix . 'users', 'user_icq');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_icq',

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'user_icq',

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

+ 'user_icq' => array('VCHAR:20', ''),

+ ),

+ ),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License v2

+*

+*/

+

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

+

+class profilefield_interests extends \phpbb\db\migration\profilefield_base_migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_types',

+ '\phpbb\db\migration\data\v310\profilefield_show_novalue',

+ );

+ }

+

+ protected $profilefield_name = 'phpbb_interests';

+

+ protected $profilefield_database_type = array('MTEXT', '');

+

+ protected $profilefield_data = array(

+ 'field_name' => 'phpbb_interests',

+ 'field_type' => 'profilefields.type.text',

+ 'field_ident' => 'phpbb_interests',

+ 'field_length' => '3|30',

+ 'field_minlen' => '2',

+ 'field_maxlen' => '500',

+ 'field_novalue' => '',

+ 'field_default_value' => '',

+ 'field_validation' => '.*',

+ 'field_required' => 0,

+ 'field_show_novalue' => 0,

+ 'field_show_on_reg' => 0,

+ 'field_show_on_pm' => 0,

+ 'field_show_on_vt' => 0,

+ 'field_show_profile' => 1,

+ 'field_hide' => 0,

+ 'field_no_view' => 0,

+ 'field_active' => 1,

+ );

+

+ protected $user_column_name = 'user_interests';

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License v2

+*

+*/

+

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

+

+class profilefield_location extends \phpbb\db\migration\profilefield_base_migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_types',

+ '\phpbb\db\migration\data\v310\profilefield_on_memberlist',

+ );

+ }

+

+ protected $profilefield_name = 'phpbb_location';

+

+ protected $profilefield_database_type = array('VCHAR', '');

+

+ protected $profilefield_data = array(

+ 'field_name' => 'phpbb_location',

+ 'field_type' => 'profilefields.type.string',

+ 'field_ident' => 'phpbb_location',

+ 'field_length' => '20',

+ 'field_minlen' => '2',

+ 'field_maxlen' => '100',

+ 'field_novalue' => '',

+ 'field_default_value' => '',

+ 'field_validation' => '.*',

+ 'field_required' => 0,

+ 'field_show_novalue' => 0,

+ 'field_show_on_reg' => 0,

+ 'field_show_on_pm' => 1,

+ 'field_show_on_vt' => 1,

+ 'field_show_profile' => 1,

+ 'field_hide' => 0,

+ 'field_no_view' => 0,

+ 'field_active' => 1,

+ );

+

+ protected $user_column_name = 'user_from';

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License v2

+*

+*/

+

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

+

+class profilefield_occupation extends \phpbb\db\migration\profilefield_base_migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_interests',

+ );

+ }

+

+ protected $profilefield_name = 'phpbb_occupation';

+

+ protected $profilefield_database_type = array('MTEXT', '');

+

+ protected $profilefield_data = array(

+ 'field_name' => 'phpbb_occupation',

+ 'field_type' => 'profilefields.type.text',

+ 'field_ident' => 'phpbb_occupation',

+ 'field_length' => '3|30',

+ 'field_minlen' => '2',

+ 'field_maxlen' => '500',

+ 'field_novalue' => '',

+ 'field_default_value' => '',

+ 'field_validation' => '.*',

+ 'field_required' => 0,

+ 'field_show_novalue' => 0,

+ 'field_show_on_reg' => 0,

+ 'field_show_on_pm' => 0,

+ 'field_show_on_vt' => 0,

+ 'field_show_profile' => 1,

+ 'field_hide' => 0,

+ 'field_no_view' => 0,

+ 'field_active' => 1,

+ );

+

+ protected $user_column_name = 'user_occ';

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License v2

+*

+*/

+

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

+

+class profilefield_on_memberlist extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return $this->db_tools->sql_column_exists($this->table_prefix . 'profile_fields', 'field_show_on_ml');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_cleanup',

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

+ 'field_show_on_ml' => array('BOOL', 0),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'field_show_on_ml',

+ ),

+ ),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

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

+

+class profilefield_show_novalue extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return $this->db_tools->sql_column_exists($this->table_prefix . 'profile_fields', 'field_show_novalue');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v310\profilefield_types');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

+ 'field_show_novalue' => array('BOOL', 0),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'field_show_novalue',

+ ),

+ ),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License v2

+*

+*/

+

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

+

+class profilefield_types extends \phpbb\db\migration\migration

+{

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\alpha2',

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'change_columns' => array(

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

+ 'field_type' => array('VCHAR:100', ''),

+ ),

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

+ 'field_type' => array('VCHAR:100', ''),

+ ),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

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

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

+ );

+ }

+

+ public function update_profile_fields_type()

+ {

+ // Update profile field types

+ $sql = 'SELECT field_type

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

+ GROUP BY field_type';

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

+

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

+ {

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

+ SET field_type = '" . $this->db->sql_escape($this->convert_phpbb30_field_type($row['field_type'])) . "'

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

+ $this->sql_query($sql);

+ }

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

+ }

+

+ public function update_profile_fields_lang_type()

+ {

+ // Update profile field language types

+ $sql = 'SELECT field_type

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

+ GROUP BY field_type';

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

+

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

+ {

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

+ SET field_type = '" . $this->db->sql_escape($this->convert_phpbb30_field_type($row['field_type'])) . "'

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

+ $this->sql_query($sql);

+ }

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

+ }

+

+ /**

+ * Determine the new field type for a given phpBB 3.0 field type

+ *

+ * @param $field_type string Field type in 3.0

+ * @return string Field new type which is used since 3.1

+ */

+ public function convert_phpbb30_field_type($field_type)

+ {

+ switch ($field_type)

+ {

+ case FIELD_INT:

+ return 'profilefields.type.int';

+ case FIELD_STRING:

+ return 'profilefields.type.string';

+ case FIELD_TEXT:

+ return 'profilefields.type.text';

+ case FIELD_BOOL:

+ return 'profilefields.type.bool';

+ case FIELD_DROPDOWN:

+ return 'profilefields.type.dropdown';

+ case FIELD_DATE:

+ return 'profilefields.type.date';

+ default:

+ return $field_type;

+ }

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

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

+

+class profilefield_website extends \phpbb\db\migration\profilefield_base_migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_on_memberlist',

+ '\phpbb\db\migration\data\v310\profilefield_icq_cleanup',

+ );

+ }

+

+ protected $profilefield_name = 'phpbb_website';

+

+ protected $profilefield_database_type = array('VCHAR', '');

+

+ protected $profilefield_data = array(

+ 'field_name' => 'phpbb_website',

+ 'field_type' => 'profilefields.type.url',

+ 'field_ident' => 'phpbb_website',

+ 'field_length' => '40',

+ 'field_minlen' => '12',

+ 'field_maxlen' => '255',

+ 'field_novalue' => '',

+ 'field_default_value' => '',

+ 'field_validation' => '',

+ 'field_required' => 0,

+ 'field_show_novalue' => 0,

+ 'field_show_on_reg' => 0,

+ 'field_show_on_pm' => 1,

+ 'field_show_on_vt' => 1,

+ 'field_show_on_ml' => 1,

+ 'field_show_profile' => 1,

+ 'field_hide' => 0,

+ 'field_no_view' => 0,

+ 'field_active' => 1,

+ 'field_is_contact' => 1,

+ 'field_contact_desc' => 'VISIT_WEBSITE',

+ 'field_contact_url' => '%s',

+ );

+

+ protected $user_column_name = 'user_website';

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

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

+

+class profilefield_website_cleanup extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return !$this->db_tools->sql_column_exists($this->table_prefix . 'users', 'user_website');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_website',

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'user_website',

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

+ 'user_website' => array('VCHAR_UNI:200', ''),

+ ),

+ ),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

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

+

+class profilefield_wlm extends \phpbb\db\migration\profilefield_base_migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_website_cleanup',

+ );

+ }

+

+ protected $profilefield_name = 'phpbb_wlm';

+

+ protected $profilefield_database_type = array('VCHAR', '');

+

+ protected $profilefield_data = array(

+ 'field_name' => 'phpbb_wlm',

+ 'field_type' => 'profilefields.type.string',

+ 'field_ident' => 'phpbb_wlm',

+ 'field_length' => '40',

+ 'field_minlen' => '5',

+ 'field_maxlen' => '255',

+ 'field_novalue' => '',

+ 'field_default_value' => '',

+ 'field_validation' => '.*',

+ 'field_required' => 0,

+ 'field_show_novalue' => 0,

+ 'field_show_on_reg' => 0,

+ 'field_show_on_pm' => 1,

+ 'field_show_on_vt' => 1,

+ 'field_show_on_ml' => 0,

+ 'field_show_profile' => 1,

+ 'field_hide' => 0,

+ 'field_no_view' => 0,

+ 'field_active' => 1,

+ 'field_is_contact' => 1,

+ 'field_contact_desc' => '',

+ 'field_contact_url' => '',

+ );

+

+ protected $user_column_name = 'user_msnm';

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

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

+

+class profilefield_wlm_cleanup extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return !$this->db_tools->sql_column_exists($this->table_prefix . 'users', 'user_msnm');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_wlm',

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'user_msnm',

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

+ 'user_msnm' => array('VCHAR_UNI', ''),

+ ),

+ ),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

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

+

+class profilefield_yahoo extends \phpbb\db\migration\profilefield_base_migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_wlm_cleanup',

+ );

+ }

+

+ protected $profilefield_name = 'phpbb_yahoo';

+

+ protected $profilefield_database_type = array('VCHAR', '');

+

+ protected $profilefield_data = array(

+ 'field_name' => 'phpbb_yahoo',

+ 'field_type' => 'profilefields.type.string',

+ 'field_ident' => 'phpbb_yahoo',

+ 'field_length' => '40',

+ 'field_minlen' => '5',

+ 'field_maxlen' => '255',

+ 'field_novalue' => '',

+ 'field_default_value' => '',

+ 'field_validation' => '.*',

+ 'field_required' => 0,

+ 'field_show_novalue' => 0,

+ 'field_show_on_reg' => 0,

+ 'field_show_on_pm' => 1,

+ 'field_show_on_vt' => 1,

+ 'field_show_on_ml' => 0,

+ 'field_show_profile' => 1,

+ 'field_hide' => 0,

+ 'field_no_view' => 0,

+ 'field_active' => 1,

+ 'field_is_contact' => 1,

+ 'field_contact_desc' => 'SEND_YIM_MESSAGE',

+ 'field_contact_url' => 'http://edit.yahoo.com/config/send_webmesg?.target=%s&amp;.src=pg',

+ );

+

+ protected $user_column_name = 'user_yim';

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

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

+

+class profilefield_yahoo_cleanup extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return !$this->db_tools->sql_column_exists($this->table_prefix . 'users', 'user_yim');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_yahoo',

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'user_yim',

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

+ 'user_yim' => array('VCHAR_UNI', ''),

+ ),

+ ),

+ );

+ }

+}

+<?php

+/**

+*

+* @package db

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+namespace phpbb\db\migration;

+

+/**

+* The migrator is responsible for applying new migrations in the correct order.

+*

+* @package db

+*/

+class helper

+{

+ /**

+ * Get the schema steps from an array of schema changes

+ *

+ * This splits up $schema_changes into individual changes so that the

+ * changes can be chunked

+ *

+ * @param array $schema_changes from migration

+ * @return array

+ */

+ public function get_schema_steps($schema_changes)

+ {

+ $steps = array();

+

+ // Nested level of data (only supports 1/2 currently)

+ $nested_level = array(

+ 'drop_tables' => 1,

+ 'add_tables' => 1,

+ 'change_columns' => 2,

+ 'add_columns' => 2,

+ 'drop_keys' => 2,

+ 'drop_columns' => 2,

+ 'add_primary_keys' => 2, // perform_schema_changes only uses one level, but second is in the function

+ 'add_unique_index' => 2,

+ 'add_index' => 2,

+ );

+

+ foreach ($nested_level as $change_type => $data_depth)

+ {

+ if (!empty($schema_changes[$change_type]))

+ {

+ foreach ($schema_changes[$change_type] as $key => $value)

+ {

+ if ($data_depth === 1)

+ {

+ $steps[] = array(

+ 'dbtools.perform_schema_changes', array(array(

+ $change_type => array(

+ (!is_int($key)) ? $key : 0 => $value,

+ ),

+ )),

+ );

+ }

+ else if ($data_depth === 2)

+ {

+ foreach ($value as $key2 => $value2)

+ {

+ $steps[] = array(

+ 'dbtools.perform_schema_changes', array(array(

+ $change_type => array(

+ $key => array(

+ $key2 => $value2,

+ ),

+ ),

+ )),

+ );

+ }

+ }

+ }

+ }

+ }

+

+ return $steps;

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License v2

+*

+*/

+

+namespace phpbb\db\migration;

+

+abstract class profilefield_base_migration extends \phpbb\db\migration\migration

+{

+ protected $profilefield_name;

+

+ protected $profilefield_database_type;

+

+ protected $profilefield_data;

+

+ protected $user_column_name;

+

+ public function effectively_installed()

+ {

+ return $this->db_tools->sql_column_exists($this->table_prefix . 'profile_fields_data', 'pf_' . $this->profilefield_name);

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

+ 'pf_' . $this->profilefield_name => $this->profilefield_database_type,

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'pf_' . $this->profilefield_name,

+ ),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

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

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

+ );

+ }

+

+ public function create_custom_field()

+ {

+ $sql = 'SELECT MAX(field_order) as max_field_order

+ FROM ' . PROFILE_FIELDS_TABLE;

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

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

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

+

+ $sql_ary = array_merge($this->profilefield_data, array(

+ 'field_order' => $max_field_order + 1,

+ ));

+

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

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

+ $field_id = (int) $this->db->sql_nextid();

+

+ $insert_buffer = new \phpbb\db\sql_insert_buffer($this->db, PROFILE_LANG_TABLE);

+

+ $sql = 'SELECT lang_id

+ FROM ' . LANG_TABLE;

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

+ while ($lang_id = (int) $this->db->sql_fetchfield('lang_id'))

+ {

+ $insert_buffer->insert(array(

+ 'field_id' => $field_id,

+ 'lang_id' => $lang_id,

+ 'lang_name' => strtoupper(substr($this->profilefield_name, 6)),// Remove phpbb_ from field name

+ 'lang_explain' => '',

+ 'lang_default_value' => '',

+ ));

+ }

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

+

+ $insert_buffer->flush();

+ }

+

+ /**

+ * @param int $start Start of staggering step

+ * @return mixed int start of the next step, null if the end was reached

+ */

+ public function convert_user_field_to_custom_field($start)

+ {

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

+ $limit = 250;

+ $converted_users = 0;

+

+ $sql = 'SELECT user_id, ' . $this->user_column_name . '

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

+ WHERE ' . $this->user_column_name . " <> ''

+ ORDER BY user_id";

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

+

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

+ {

+ $converted_users++;

+

+ $cp_data = array(

+ 'pf_' . $this->profilefield_name => $row[$this->user_column_name],

+ );

+

+ $sql = 'UPDATE ' . $this->table_prefix . 'profile_fields_data

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

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

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

+

+ if (!$this->db->sql_affectedrows())

+ {

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

+ $cp_data = array_merge($this->get_insert_sql_array(), $cp_data);

+ $insert_buffer->insert($cp_data);

+ }

+ }

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

+

+ $insert_buffer->flush();

+

+ if ($converted_users < $limit)

+ {

+ // No more users left, we are done...

+ return;

+ }

+

+ return $start + $limit;

+ }

+

+ protected function get_insert_sql_array()

+ {

+ static $profile_row;

+

+ if ($profile_row === null)

+ {

+ global $phpbb_container;

+ $manager = $phpbb_container->get('profilefields.manager');

+ $profile_row = $manager->build_insert_sql_array(array());

+ }

+

+ return $profile_row;

+ }

+}

+ /** @var \phpbb\db\migration\helper */

+ protected $helper;

+

+ public function __construct(\phpbb\config\config $config, \phpbb\db\driver\driver $db, \phpbb\db\tools $db_tools, $migrations_table, $phpbb_root_path, $php_ext, $table_prefix, $tools, \phpbb\db\migration\helper $helper)

+ $this->helper = $helper;

+ $this->tools['dbtools'] = $this->db_tools;

+

+ $this->last_run_migration['task'] = 'process_schema_step';

+ $steps = $this->helper->get_schema_steps($migration->update_schema());

+ $result = $this->process_data_step($steps, $state['migration_data_state']);

+

+ $state['migration_data_state'] = ($result === true) ? '' : $result;

+ $state['migration_schema_done'] = ($result === true);

+ else if ($state['migration_schema_done'])

+ $steps = $this->helper->get_schema_steps($migration->revert_schema());

+ $result = $this->process_data_step($steps, $state['migration_data_state']);

+ $state['migration_data_state'] = ($result === true) ? '' : $result;

+ $state['migration_schema_done'] = ($result === true) ? false : true;

+

+ if (!$state['migration_schema_done'])

+ {

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

+ WHERE migration_name = '" . $this->db->sql_escape($name) . "'";

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

+ unset($this->migration_state[$name]);

+ }

+

+ if (isset($prepared_column['auto_increment']) && $prepared_column['auto_increment'] && strlen($column_name) > 26) // "${column_name}_gen"

+ list($column_type, $orig_column_type) = $this->get_column_type($column_data[0]);

+ * Get the column's database type from the type map

+ *

+ * @param string $column_map_type

+ * @return array column type for this database

+ * and map type without length

+ */

+ function get_column_type($column_map_type)

+ {

+ if (strpos($column_map_type, ':') !== false)

+ {

+ list($orig_column_type, $column_length) = explode(':', $column_map_type);

+ if (!is_array($this->dbms_type_map[$this->sql_layer][$orig_column_type . ':']))

+ {

+ $column_type = sprintf($this->dbms_type_map[$this->sql_layer][$orig_column_type . ':'], $column_length);

+ }

+ else

+ {

+ if (isset($this->dbms_type_map[$this->sql_layer][$orig_column_type . ':']['rule']))

+ {

+ switch ($this->dbms_type_map[$this->sql_layer][$orig_column_type . ':']['rule'][0])

+ {

+ case 'div':

+ $column_length /= $this->dbms_type_map[$this->sql_layer][$orig_column_type . ':']['rule'][1];

+ $column_length = ceil($column_length);

+ $column_type = sprintf($this->dbms_type_map[$this->sql_layer][$orig_column_type . ':'][0], $column_length);

+ break;

+ }

+ }

+

+ if (isset($this->dbms_type_map[$this->sql_layer][$orig_column_type . ':']['limit']))

+ {

+ switch ($this->dbms_type_map[$this->sql_layer][$orig_column_type . ':']['limit'][0])

+ {

+ case 'mult':

+ $column_length *= $this->dbms_type_map[$this->sql_layer][$orig_column_type . ':']['limit'][1];

+ if ($column_length > $this->dbms_type_map[$this->sql_layer][$orig_column_type . ':']['limit'][2])

+ {

+ $column_type = $this->dbms_type_map[$this->sql_layer][$orig_column_type . ':']['limit'][3];

+ }

+ else

+ {

+ $column_type = sprintf($this->dbms_type_map[$this->sql_layer][$orig_column_type . ':'][0], $column_length);

+ }

+ break;

+ }

+ }

+ }

+ $orig_column_type .= ':';

+ }

+ else

+ {

+ $orig_column_type = $column_map_type;

+ $column_type = $this->dbms_type_map[$this->sql_layer][$column_map_type];

+ }

+

+ return array($column_type, $orig_column_type);

+ }

+

+ /**

+}

+ FROM ' . $this->log_table . ' l, ' . USERS_TABLE . ' u

+ FROM ' . $this->log_table . ' l, ' . USERS_TABLE . ' u

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

+ * Inherit notification read status from post.

+ *

+ * @var bool

+ */

+ protected $inherit_read_status = false;

+

+ /**

+ * Inherit notification read status from topic.

+ *

+ * @var bool

+ */

+ protected $inherit_read_status = false;

+

+ /**

+ $mark_hash = generate_link_hash('mark_notification_read');

+

+ $u_mark_read = append_sid($this->phpbb_root_path . 'index.' . $this->php_ext, 'mark_notification=' . $this->notification_id . '&amp;hash=' . $mark_hash);

+ $u_mark_read = append_sid($this->phpbb_root_path . 'index.' . $this->php_ext, 'mark_notification=' . $this->notification_id . '&amp;hash=' . $mark_hash . '&amp;redirect=' . urlencode($redirect));

+ * Inherit notification read status from post.

+ *

+ * @var bool

+ */

+ protected $inherit_read_status = false;

+

+ /**

+ * Inherit notification read status from topic.

+ *

+ * @var bool

+ */

+ protected $inherit_read_status = false;

+

+ /**

+ * Inherit notification read status from post.

+ *

+ * @var bool

+ */

+ protected $inherit_read_status = true;

+

+ /**

+ if (!sizeof($notify_users) || !$this->inherit_read_status)

+ if ($this->inherit_read_status && isset($pre_create_data[$this->user_id]) && $pre_create_data[$this->user_id] >= $this->notification_time)

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

+ * Inherit notification read status from post.

+ *

+ * @var bool

+ */

+ protected $inherit_read_status = false;

+

+ /**

+ /**

+ * Inherit notification read status from post.

+ *

+ * @var bool

+ */

+ protected $inherit_read_status = false;

+

+ * Inherit notification read status from topic.

+ *

+ * @var bool

+ */

+ protected $inherit_read_status = true;

+

+ /**

+ if (!sizeof($notify_users) || !$this->inherit_read_status)

+ if ($this->inherit_read_status && isset($pre_create_data[$this->user_id]) && $pre_create_data[$this->user_id] >= $this->notification_time)

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

+ public function __construct(\phpbb\template\template $template, \phpbb\user $user, \phpbb\controller\helper $helper)

+ $this->helper = $helper;

+ if (!is_string($base_url))

+ if (is_array($base_url['routes']))

+ {

+ $route = ($on_page > 1) ? $base_url['routes'][1] : $base_url['routes'][0];

+ }

+ else

+ {

+ $route = $base_url['routes'];

+ }

+ $params = (isset($base_url['params'])) ? $base_url['params'] : array();

+ $is_amp = (isset($base_url['is_amp'])) ? $base_url['is_amp'] : true;

+ $session_id = (isset($base_url['session_id'])) ? $base_url['session_id'] : false;

+

+ if ($on_page > 1 || !is_array($base_url['routes']))

+ {

+ $params[$start_name] = (int) $on_page;

+ }

+

+ return $this->helper->route($route, $params, $is_amp, $session_id);

+ if ($total_pages > 1)

+ if ($reverse_count)

+ $start_page = ($total_pages > 5) ? $total_pages - 4 : 1;

+ $end_page = $total_pages;

+ else

+ // What we're doing here is calculating what the "start" and "end" pages should be. We

+ // do this by assuming pagination is "centered" around the currently active page with

+ // the three previous and three next page links displayed. Anything more than that and

+ // we display the ellipsis, likewise anything less.

+ //

+ // $start_page is the page at which we start creating the list. When we have five or less

+ // pages we start at page 1 since there will be no ellipsis displayed. Anymore than that

+ // and we calculate the start based on the active page. This is the min/max calculation.

+ // First (max) would we end up starting on a page less than 1? Next (min) would we end

+ // up starting so close to the end that we'd not display our minimum number of pages.

+ //

+ // $end_page is the last page in the list to display. Like $start_page we use a min/max to

+ // determine this number. Again at most five pages? Then just display them all. More than

+ // five and we first (min) determine whether we'd end up listing more pages than exist.

+ // We then (max) ensure we're displaying the minimum number of pages.

+ $start_page = ($total_pages > 5) ? min(max(1, $on_page - 3), $total_pages - 4) : 1;

+ $end_page = ($total_pages > 5) ? max(min($total_pages, $on_page + 3), 5) : $total_pages;

+

+ if ($on_page != 1)

+ $u_previous_page = $this->generate_page_link($base_url, $on_page - 1, $start_name, $per_page);

+

+ $this->template->assign_block_vars($block_var_name, array(

+ 'PAGE_NUMBER' => '',

+ 'PAGE_URL' => $u_previous_page,

+ 'S_IS_CURRENT' => false,

+ 'S_IS_PREV' => true,

+ 'S_IS_NEXT' => false,

+ 'S_IS_ELLIPSIS' => false,

+ ));

+ // This do...while exists purely to negate the need for start and end assign_block_vars, i.e.

+ // to display the first and last page in the list plus any ellipsis. We use this loop to jump

+ // around a little within the list depending on where we're starting (and ending).

+ $at_page = 1;

+ do

+ {

+ // We decide whether to display the ellipsis during the loop. The ellipsis is always

+ // displayed as either the second or penultimate item in the list. So are we at either

+ // of those points and of course do we even need to display it, i.e. is the list starting

+ // on at least page 3 and ending three pages before the final item.

+ $this->template->assign_block_vars($block_var_name, array(

+ 'PAGE_NUMBER' => $at_page,

+ 'PAGE_URL' => $this->generate_page_link($base_url, $at_page, $start_name, $per_page),

+ 'S_IS_CURRENT' => (!$ignore_on_page && $at_page == $on_page),

+ 'S_IS_NEXT' => false,

+ 'S_IS_PREV' => false,

+ 'S_IS_ELLIPSIS' => ($at_page == 2 && $start_page > 2) || ($at_page == $total_pages - 1 && $end_page < $total_pages - 1),

+ ));

+ // We may need to jump around in the list depending on whether we have or need to display

+ // the ellipsis. Are we on page 2 and are we more than one page away from the start

+ // of the list? Yes? Then we jump to the start of the list. Likewise are we at the end of

+ // the list and are there more than two pages left in total? Yes? Then jump to the penultimate

+ // page (so we can display the ellipsis next pass). Else, increment the counter and keep

+ // going

+ if ($at_page == 2 && $at_page < $start_page - 1)

+ {

+ $at_page = $start_page;

+ }

+ else if ($at_page == $end_page && $end_page < $total_pages - 1)

+ {

+ $at_page = $total_pages - 1;

+ }

+ else

+ {

+ $at_page++;

+ }

+ }

+ while ($at_page <= $total_pages);

+

+ if ($on_page != $total_pages)

+ {

+ $u_next_page = $this->generate_page_link($base_url, $on_page + 1, $start_name, $per_page);

+

+ $this->template->assign_block_vars($block_var_name, array(

+ 'PAGE_NUMBER' => '',

+ 'PAGE_URL' => $u_next_page,

+ 'S_IS_CURRENT' => false,

+ 'S_IS_PREV' => false,

+ 'S_IS_NEXT' => true,

+ 'S_IS_ELLIPSIS' => false,

+ ));

+ }

+ $tpl_prefix . 'BASE_URL' => is_string($base_url) ? $base_url : '',//@todo: Fix this for routes

+ $tpl_prefix . 'START_NAME' => $start_name,

+ $tpl_prefix . 'PAGE_NUMBER' => $this->on_page($num_items, $per_page, $start),

+ public function on_page($num_items, $per_page, $start)

+ return ($start < 0 || $num_items <= 0) ? 0 : floor(($num_items - 1) / $per_page) * $per_page;

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\passwords\driver;

+

+/**

+* @package passwords

+*/

+abstract class base implements driver_interface

+{

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

+ protected $config;

+

+ /** @var phpbb\passwords\driver\helper */

+ protected $helper;

+

+ /** @var driver name */

+ protected $name;

+

+ /**

+ * Constructor of passwords driver object

+ *

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

+ * @param \phpbb\passwords\driver\helper $helper Password driver helper

+ */

+ public function __construct(\phpbb\config\config $config, helper $helper)

+ {

+ $this->config = $config;

+ $this->helper = $helper;

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function is_supported()

+ {

+ return true;

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\passwords\driver;

+

+/**

+* @package passwords

+*/

+class bcrypt extends base

+{

+ const PREFIX = '$2a$';

+

+ /**

+ * @inheritdoc

+ */

+ public function get_prefix()

+ {

+ return self::PREFIX;

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function hash($password, $salt = '')

+ {

+ // The 2x and 2y prefixes of bcrypt might not be supported

+ // Revert to 2a if this is the case

+ $prefix = (!$this->is_supported()) ? '$2a$' : $this->get_prefix();

+

+ // Do not support 8-bit characters with $2a$ bcrypt

+ // Also see http://www.php.net/security/crypt_blowfish.php

+ if ($prefix === self::PREFIX)

+ {

+ if (ord($password[strlen($password)-1]) & 128)

+ {

+ return false;

+ }

+ }

+

+ if ($salt == '')

+ {

+ $salt = $prefix . '10$' . $this->get_random_salt();

+ }

+

+ $hash = crypt($password, $salt);

+ if (strlen($hash) < 60)

+ {

+ return false;

+ }

+ return $hash;

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function check($password, $hash)

+ {

+ $salt = substr($hash, 0, 29);

+ if (strlen($salt) != 29)

+ {

+ return false;

+ }

+

+ if ($hash == $this->hash($password, $salt))

+ {

+ return true;

+ }

+ return false;

+ }

+

+ /**

+ * Get a random salt value with a length of 22 characters

+ *

+ * @return string Salt for password hashing

+ */

+ protected function get_random_salt()

+ {

+ return $this->helper->hash_encode64($this->helper->get_random_salt(22), 22);

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function get_settings_only($hash, $full = false)

+ {

+ if ($full)

+ {

+ $pos = stripos($hash, '$', 1) + 1;

+ $length = 22 + (strripos($hash, '$') + 1 - $pos);

+ }

+ else

+ {

+ $pos = strripos($hash, '$') + 1;

+ $length = 22;

+ }

+ return substr($hash, $pos, $length);

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\passwords\driver;

+

+/**

+* @package passwords

+*/

+class bcrypt_2y extends bcrypt

+{

+ const PREFIX = '$2y$';

+

+ /**

+ * @inheritdoc

+ */

+ public function get_prefix()

+ {

+ return self::PREFIX;

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function is_supported()

+ {

+ return (version_compare(PHP_VERSION, '5.3.7', '<')) ? false : true;

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\passwords\driver;

+

+/**

+* @package passwords

+*/

+interface driver_interface

+{

+ /**

+ * Check if hash type is supported

+ *

+ * @return bool True if supported, false if not

+ */

+ public function is_supported();

+

+ /**

+ * Returns the hash prefix

+ *

+ * @return string Hash prefix

+ */

+ public function get_prefix();

+

+ /**

+ * Hash the password

+ *

+ * @param string $password The password that should be hashed

+ *

+ * @return bool|string Password hash or false if something went wrong

+ * during hashing

+ */

+ public function hash($password);

+

+ /**

+ * Check the password against the supplied hash

+ *

+ * @param string $password The password to check

+ * @param string $hash The password hash to check against

+ *

+ * @return bool True if password is correct, else false

+ */

+ public function check($password, $hash);

+

+ /**

+ * Get only the settings of the specified hash

+ *

+ * @param string $hash Password hash

+ * @param bool $full Return full settings or only settings

+ * related to the salt

+ * @return string String containing the hash settings

+ */

+ public function get_settings_only($hash, $full = false);

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\passwords\driver;

+

+/**

+* @package passwords

+*/

+class helper

+{

+ /**

+ * @var phpbb\config\config

+ */

+ protected $config;

+

+ /**

+ * base64 alphabet

+ * @var string

+ */

+ public $itoa64 = './0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz';

+

+ /**

+ * Construct a driver helper object

+ *

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

+ */

+ public function __construct(\phpbb\config\config $config)

+ {

+ $this->config = $config;

+ }

+

+ /**

+ * Base64 encode hash

+ *

+ * @param string $input Input string

+ * @param int $count Input string length

+ *

+ * @return string base64 encoded string

+ */

+ public function hash_encode64($input, $count)

+ {

+ $output = '';

+ $i = 0;

+

+ do

+ {

+ $value = ord($input[$i++]);

+ $output .= $this->itoa64[$value & 0x3f];

+

+ if ($i < $count)

+ {

+ $value |= ord($input[$i]) << 8;

+ }

+

+ $output .= $this->itoa64[($value >> 6) & 0x3f];

+

+ if ($i++ >= $count)

+ {

+ break;

+ }

+

+ if ($i < $count)

+ {

+ $value |= ord($input[$i]) << 16;

+ }

+

+ $output .= $this->itoa64[($value >> 12) & 0x3f];

+

+ if ($i++ >= $count)

+ {

+ break;

+ }

+

+ $output .= $this->itoa64[($value >> 18) & 0x3f];

+ }

+ while ($i < $count);

+

+ return $output;

+ }

+

+ /**

+ * Return unique id

+ *

+ * @param string $extra Additional entropy

+ *

+ * @return string Unique id

+ */

+ public function unique_id($extra = 'c')

+ {

+ static $dss_seeded = false;

+

+ $val = $this->config['rand_seed'] . microtime();

+ $val = md5($val);

+ $this->config['rand_seed'] = md5($this->config['rand_seed'] . $val . $extra);

+

+ if ($dss_seeded !== true && ($this->config['rand_seed_last_update'] < time() - rand(1,10)))

+ {

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

+ $this->config->set('rand_seed', $this->config['rand_seed'], true);

+ $dss_seeded = true;

+ }

+

+ return substr($val, 4, 16);

+ }

+

+ /**

+ * Get random salt with specified length

+ *

+ * @param int $length Salt length

+ * @param string $rand_seed Seed for random data (optional). For tests.

+ *

+ * @return string Random salt with specified length

+ */

+ public function get_random_salt($length, $rand_seed = '/dev/urandom')

+ {

+ $random = '';

+

+ if (($fh = @fopen($rand_seed, 'rb')))

+ {

+ $random = fread($fh, $length);

+ fclose($fh);

+ }

+

+ if (strlen($random) < $length)

+ {

+ $random = '';

+ $random_state = $this->unique_id();

+

+ for ($i = 0; $i < $length; $i += 16)

+ {

+ $random_state = md5($this->unique_id() . $random_state);

+ $random .= pack('H*', md5($random_state));

+ }

+ $random = substr($random, 0, $length);

+ }

+ return $random;

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\passwords\driver;

+

+/**

+* @package passwords

+*/

+class phpass extends salted_md5

+{

+ const PREFIX = '$P$';

+

+ /**

+ * @inheritdoc

+ */

+ public function get_prefix()

+ {

+ return self::PREFIX;

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\passwords\driver;

+

+/**

+*

+* @version Version 0.1 / slightly modified for phpBB 3.1.x (using $H$ as hash type identifier)

+*

+* Portable PHP password hashing framework.

+*

+* Written by Solar Designer <solar at openwall.com> in 2004-2006 and placed in

+* the public domain.

+*

+* There's absolutely no warranty.

+*

+* The homepage URL for this framework is:

+*

+* http://www.openwall.com/phpass/

+*

+* Please be sure to update the Version line if you edit this file in any way.

+* It is suggested that you leave the main version number intact, but indicate

+* your project name (after the slash) and add your own revision information.

+*

+* Please do not change the "private" password hashing method implemented in

+* here, thereby making your hashes incompatible. However, if you must, please

+* change the hash type identifier (the "$P$") to something different.

+*

+* Obviously, since this code is in the public domain, the above are not

+* requirements (there can be none), but merely suggestions.

+*

+*/

+

+/**

+* @package passwords

+*/

+class salted_md5 extends base

+{

+ const PREFIX = '$H$';

+

+ /**

+ * @inheritdoc

+ */

+ public function get_prefix()

+ {

+ return self::PREFIX;

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function hash($password, $setting = '')

+ {

+ if ($setting)

+ {

+ if (($settings = $this->get_hash_settings($setting)) === false)

+ {

+ // Return md5 of password if settings do not

+ // comply with our standards. This will only

+ // happen if pre-determined settings are

+ // directly passed to the driver. The manager

+ // will not do this. Same as the old hashing

+ // implementatio in phpBB 3.0

+ return md5($password);

+ }

+ }

+ else

+ {

+ $settings = $this->get_hash_settings($this->generate_salt());

+ }

+

+ $hash = md5($settings['salt'] . $password, true);

+ do

+ {

+ $hash = md5($hash . $password, true);

+ }

+ while (--$settings['count']);

+

+ $output = $settings['full'];

+ $output .= $this->helper->hash_encode64($hash, 16);

+

+ return $output;

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function check($password, $hash)

+ {

+ if (strlen($hash) !== 34)

+ {

+ return md5($password) === $hash;

+ }

+

+ return $hash === $this->hash($password, $hash);

+ }

+

+ /**

+ * Generate salt for hashing method

+ *

+ * @return string Salt for hashing method

+ */

+ protected function generate_salt()

+ {

+ $count = 6;

+

+ $random = $this->helper->get_random_salt($count);

+

+ $salt = $this->get_prefix();

+ $salt .= $this->helper->itoa64[min($count + 5, 30)];

+ $salt .= $this->helper->hash_encode64($random, $count);

+

+ return $salt;

+ }

+

+ /**

+ * Get hash settings

+ *

+ * @param string $hash The hash that contains the settings

+ *

+ * @return bool|array Array containing the count_log2, salt, and full

+ * hash settings string or false if supplied hash is empty

+ * or contains incorrect settings

+ */

+ public function get_hash_settings($hash)

+ {

+ if (empty($hash))

+ {

+ return false;

+ }

+

+ $count_log2 = strpos($this->helper->itoa64, $hash[3]);

+ $salt = substr($hash, 4, 8);

+

+ if ($count_log2 < 7 || $count_log2 > 30 || strlen($salt) != 8)

+ {

+ return false;

+ }

+

+ return array(

+ 'count' => 1 << $count_log2,

+ 'salt' => $salt,

+ 'full' => substr($hash, 0, 12),

+ );

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function get_settings_only($hash, $full = false)

+ {

+ return substr($hash, 3, 9);

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\passwords;

+

+/**

+* @package passwords

+*/

+class helper

+{

+ /**

+ * Get hash settings from combined hash

+ *

+ * @param string $hash Password hash of combined hash

+ *

+ * @return array An array containing the hash settings for the hash

+ * types in successive order as described by the combined

+ * password hash or an empty array if hash does not

+ * properly fit the combined hash format

+ */

+ public function get_combined_hash_settings($hash)

+ {

+ $output = array();

+

+ preg_match('#^\$([a-zA-Z0-9\\\]*?)\$#', $hash, $match);

+ $hash_settings = substr($hash, strpos($hash, $match[1]) + strlen($match[1]) + 1);

+ $matches = explode('\\', $match[1]);

+ foreach ($matches as $cur_type)

+ {

+ $dollar_position = strpos($hash_settings, '$');

+ $output[] = substr($hash_settings, 0, ($dollar_position != false) ? $dollar_position : strlen($hash_settings));

+ $hash_settings = substr($hash_settings, $dollar_position + 1);

+ }

+

+ return $output;

+ }

+

+ /**

+ * Combine hash prefixes, settings, and actual hash

+ *

+ * @param array $data Array containing the keys 'prefix' and 'settings'.

+ * It will hold the prefixes and settings

+ * @param string $type Data type of the supplied value

+ * @param string $value Value that should be put into the data array

+ *

+ * @return string|null Return complete combined hash if type is neither

+ * 'prefix' nor 'settings', nothing if it is

+ */

+ public function combine_hash_output(&$data, $type, $value)

+ {

+ if ($type == 'prefix')

+ {

+ $data[$type] .= ($data[$type] !== '$') ? '\\' : '';

+ $data[$type] .= str_replace('$', '', $value);

+ }

+ elseif ($type == 'settings')

+ {

+ $data[$type] .= ($data[$type] !== '$') ? '$' : '';

+ $data[$type] .= $value;

+ }

+ else

+ {

+ // Return full hash

+ return $data['prefix'] . $data['settings'] . '$' . $value;

+ }

+ }

+

+ /**

+ * Rebuild hash for hashing functions

+ *

+ * @param string $prefix Hash prefix

+ * @param string $settings Hash settings

+ *

+ * @return string Rebuilt hash for hashing functions

+ */

+ public function rebuild_hash($prefix, $settings)

+ {

+ $rebuilt_hash = $prefix;

+ if (strpos($settings, '\\') !== false)

+ {

+ $settings = str_replace('\\', '$', $settings);

+ }

+ $rebuilt_hash .= $settings;

+ return $rebuilt_hash;

+ }

+

+ /**

+ * Obtain only the actual hash after the prefixes

+ *

+ * @param string $hash The full password hash

+ * @return string Actual hash (incl. settings)

+ */

+ public function obtain_hash_only($hash)

+ {

+ return substr($hash, strripos($hash, '$') + 1);

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\passwords;

+

+/**

+* @package passwords

+*/

+class manager

+{

+ /**

+ * Default hashing method

+ */

+ protected $type = false;

+

+ /**

+ * Hashing algorithm type map

+ * Will be used to map hash prefix to type

+ */

+ protected $type_map = false;

+

+ /**

+ * Service collection of hashing algorithms

+ * Needs to be public for passwords helper

+ */

+ public $algorithms = false;

+

+ /**

+ * Password convert flag. Signals that password should be converted

+ */

+ public $convert_flag = false;

+

+ /**

+ * Passwords helper

+ * @var phpbb\passwords\helper

+ */

+ protected $helper;

+

+ /**

+ * phpBB configuration

+ * @var phpbb\config\config

+ */

+ protected $config;

+

+ /**

+ * Construct a passwords object

+ *

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

+ * @param array $hashing_algorithms Hashing driver

+ * service collection

+ * @param phpbb\passwords\helper $helper Passwords helper object

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

+ */

+ public function __construct(\phpbb\config\config $config, $hashing_algorithms, helper $helper, $defaults)

+ {

+ $this->config = $config;

+ $this->helper = $helper;

+

+ $this->fill_type_map($hashing_algorithms);

+ $this->register_default_type($defaults);

+ }

+

+ /**

+ * Register default type

+ * Will register the first supported type from the list of default types

+ *

+ * @param array $defaults List of default types in order from first to

+ * use to last to use

+ */

+ protected function register_default_type($defaults)

+ {

+ foreach ($defaults as $type)

+ {

+ if ($this->algorithms[$type]->is_supported())

+ {

+ $this->type = $this->algorithms[$type]->get_prefix();

+ break;

+ }

+ }

+ }

+

+ /**

+ * Fill algorithm type map

+ *

+ * @param phpbb\di\service_collection $hashing_algorithms

+ */

+ protected function fill_type_map($hashing_algorithms)

+ {

+ foreach ($hashing_algorithms as $algorithm)

+ {

+ if (!isset($this->type_map[$algorithm->get_prefix()]))

+ {

+ $this->type_map[$algorithm->get_prefix()] = $algorithm;

+ }

+ }

+ $this->algorithms = $hashing_algorithms;

+ }

+

+ /**

+ * Get the algorithm specified by a specific prefix

+ *

+ * @param string $prefix Password hash prefix

+ *

+ * @return object|bool The hash type object or false if prefix is not

+ * supported

+ */

+ protected function get_algorithm($prefix)

+ {

+ if (isset($this->type_map[$prefix]))

+ {

+ return $this->type_map[$prefix];

+ }

+ else

+ {

+ return false;

+ }

+ }

+

+ /**

+ * Detect the hash type of the supplied hash

+ *

+ * @param string $hash Password hash that should be checked

+ *

+ * @return object|bool The hash type object or false if the specified

+ * type is not supported

+ */

+ public function detect_algorithm($hash)

+ {

+ /*

+ * preg_match() will also show hashing algos like $2a\H$, which

+ * is a combination of bcrypt and phpass. Legacy algorithms

+ * like md5 will not be matched by this and need to be treated

+ * differently.

+ */

+ if (!preg_match('#^\$([a-zA-Z0-9\\\]*?)\$#', $hash, $match))

+ {

+ return $this->get_algorithm('$H$');

+ }

+

+ // Be on the lookout for multiple hashing algorithms

+ // 2 is correct: H\2a > 2, H\P > 2

+ if (strlen($match[1]) > 2)

+ {

+ $hash_types = explode('\\', $match[1]);

+ $return_ary = array();

+ foreach ($hash_types as $type)

+ {

+ // we do not support the same hashing

+ // algorithm more than once

+ if (isset($return_ary[$type]))

+ {

+ return false;

+ }

+

+ $return_ary[$type] = $this->get_algorithm('$' . $type . '$');

+

+ if (empty($return_ary[$type]))

+ {

+ return false;

+ }

+ }

+ return $return_ary;

+ }

+

+ // get_algorithm() will automatically return false if prefix

+ // is not supported

+ return $this->get_algorithm($match[0]);

+ }

+

+ /**

+ * Hash supplied password

+ *

+ * @param string $password Password that should be hashed

+ * @param string $type Hash type. Will default to standard hash type if

+ * none is supplied

+ * @return string|bool Password hash of supplied password or false if

+ * if something went wrong during hashing

+ */

+ public function hash($password, $type = '')

+ {

+ if (strlen($password) > 4096)

+ {

+ // If the password is too huge, we will simply reject it

+ // and not let the server try to hash it.

+ return false;

+ }

+

+ // Try to retrieve algorithm by service name if type doesn't

+ // start with dollar sign

+ if (!is_array($type) && strpos($type, '$') !== 0 && isset($this->algorithms[$type]))

+ {

+ $type = $this->algorithms[$type]->get_prefix();

+ }

+

+ $type = ($type === '') ? $this->type : $type;

+

+ if (is_array($type))

+ {

+ return $this->combined_hash_password($password, $type);

+ }

+

+ if (isset($this->type_map[$type]))

+ {

+ $hashing_algorithm = $this->type_map[$type];

+ }

+ else

+ {

+ return false;

+ }

+

+ return $hashing_algorithm->hash($password);

+ }

+

+ /**

+ * Check supplied password against hash and set convert_flag if password

+ * needs to be converted to different format (preferrably newer one)

+ *

+ * @param string $password Password that should be checked

+ * @param string $hash Stored hash

+ * @return string|bool True if password is correct, false if not

+ */

+ public function check($password, $hash)

+ {

+ if (strlen($password) > 4096)

+ {

+ // If the password is too huge, we will simply reject it

+ // and not let the server try to hash it.

+ return false;

+ }

+

+ // First find out what kind of hash we're dealing with

+ $stored_hash_type = $this->detect_algorithm($hash);

+ if ($stored_hash_type == false)

+ {

+ return false;

+ }

+

+ // Multiple hash passes needed

+ if (is_array($stored_hash_type))

+ {

+ $correct = $this->check_combined_hash($password, $stored_hash_type, $hash);

+ $this->convert_flag = ($correct === true) ? true : false;

+ return $correct;

+ }

+

+ if ($stored_hash_type->get_prefix() !== $this->type)

+ {

+ $this->convert_flag = true;

+ }

+ else

+ {

+ $this->convert_flag = false;

+ }

+

+ return $stored_hash_type->check($password, $hash);

+ }

+

+ /**

+ * Create combined hash from already hashed password

+ *

+ * @param string $password_hash Complete current password hash

+ * @param string $type Type of the hashing algorithm the password hash

+ * should be combined with

+ * @return string|bool Combined password hash if combined hashing was

+ * successful, else false

+ */

+ public function combined_hash_password($password_hash, $type)

+ {

+ $data = array(

+ 'prefix' => '$',

+ 'settings' => '$',

+ );

+ $hash_settings = $this->helper->get_combined_hash_settings($password_hash);

+ $hash = $hash_settings[0];

+

+ // Put settings of current hash into data array

+ $stored_hash_type = $this->detect_algorithm($password_hash);

+ $this->helper->combine_hash_output($data, 'prefix', $stored_hash_type->get_prefix());

+ $this->helper->combine_hash_output($data, 'settings', $stored_hash_type->get_settings_only($password_hash));

+

+ // Hash current hash with the defined types

+ foreach ($type as $cur_type)

+ {

+ if (isset($this->algorithms[$cur_type]))

+ {

+ $new_hash_type = $this->algorithms[$cur_type];

+ }

+ else

+ {

+ $new_hash_type = $this->get_algorithm($cur_type);

+ }

+

+ if (!$new_hash_type)

+ {

+ return false;

+ }

+

+ $new_hash = $new_hash_type->hash(str_replace($stored_hash_type->get_settings_only($password_hash), '', $hash));

+ $this->helper->combine_hash_output($data, 'prefix', $new_hash_type->get_prefix());

+ $this->helper->combine_hash_output($data, 'settings', substr(str_replace('$', '\\', $new_hash_type->get_settings_only($new_hash, true)), 0));

+ $hash = str_replace($new_hash_type->get_settings_only($new_hash), '', $this->helper->obtain_hash_only($new_hash));

+ }

+ return $this->helper->combine_hash_output($data, 'hash', $hash);

+ }

+

+ /**

+ * Check combined password hash against the supplied password

+ *

+ * @param string $password Password entered by user

+ * @param array $stored_hash_type An array containing the hash types

+ * as described by stored password hash

+ * @param string $hash Stored password hash

+ *

+ * @return bool True if password is correct, false if not

+ */

+ public function check_combined_hash($password, $stored_hash_type, $hash)

+ {

+ $i = 0;

+ $data = array(

+ 'prefix' => '$',

+ 'settings' => '$',

+ );

+ $hash_settings = $this->helper->get_combined_hash_settings($hash);

+ foreach ($stored_hash_type as $key => $hash_type)

+ {

+ $rebuilt_hash = $this->helper->rebuild_hash($hash_type->get_prefix(), $hash_settings[$i]);

+ $this->helper->combine_hash_output($data, 'prefix', $key);

+ $this->helper->combine_hash_output($data, 'settings', $hash_settings[$i]);

+ $cur_hash = $hash_type->hash($password, $rebuilt_hash);

+ $password = str_replace($rebuilt_hash, '', $cur_hash);

+ $i++;

+ }

+ return ($hash === $this->helper->combine_hash_output($data, 'hash', $password));

+ }

+}

+ * Strips away the web root path and prepends the normal root path

+ *

+ * This replaces get_web_root_path() . some_url with

+ * $phpbb_root_path . some_url

+ *

+ * @param string $path The path to be updated

+ * @return string

+ */

+ public function remove_web_root_path($path)

+ {

+ if (strpos($path, $this->get_web_root_path()) === 0)

+ {

+ $path = substr($path, strlen($this->get_web_root_path()));

+

+ return $this->phpbb_root_path . $path;

+ }

+

+ return $path;

+ }

+

+ /**

+

+ /**

+ * Eliminates useless . and .. components from specified URL

+ *

+ * @param string $url URL to clean

+ *

+ * @return string Cleaned URL

+ */

+ public function clean_url($url)

+ {

+ $delimiter_position = strpos($url, '://');

+ // URL should contain :// but it shouldn't start with it.

+ // Do not clean URLs that do not fit these constraints.

+ if (empty($delimiter_position))

+ {

+ return $url;

+ }

+ $scheme = substr($url, 0, $delimiter_position) . '://';

+ // Add length of URL delimiter to position

+ $path = substr($url, $delimiter_position + 3);

+

+ return $scheme . $this->filesystem->clean_path($path);

+ }

+ 'f_softdelete' => array('lang' => 'ACL_F_SOFTDELETE', 'cat' => 'post'),

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\profilefields;

+

+/**

+* Custom Profile Fields

+* @package phpBB3

+*/

+class lang_helper

+{

+ /**

+ * Array with the language option, grouped by field and language

+ * @var array

+ */

+ protected $options_lang = array();

+

+ /**

+ * Database object

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

+ */

+ protected $db;

+

+ /**

+ * Table where the language strings are stored

+ * @var string

+ */

+ protected $language_table;

+

+ /**

+ * Construct

+ *

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

+ * @param string $language_table Table where the language strings are stored

+ */

+ public function __construct($db, $language_table)

+ {

+ $this->db = $db;

+ $this->language_table = $language_table;

+ }

+

+ /**

+ * Get language entries for options and store them here for later use

+ */

+ public function get_option_lang($field_id, $lang_id, $field_type, $preview_options)

+ {

+ if ($preview_options !== false)

+ {

+ $lang_options = (!is_array($preview_options)) ? explode("\n", $preview_options) : $preview_options;

+

+ foreach ($lang_options as $num => $var)

+ {

+ if (!isset($this->options_lang[$field_id]))

+ {

+ $this->options_lang[$field_id] = array();

+ }

+ if (!isset($this->options_lang[$field_id][$lang_id]))

+ {

+ $this->options_lang[$field_id][$lang_id] = array();

+ }

+ $this->options_lang[$field_id][$lang_id][($num + 1)] = $var;

+ }

+ }

+ else

+ {

+ $sql = 'SELECT option_id, lang_value

+ FROM ' . $this->language_table . '

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

+ AND lang_id = ' . (int) $lang_id . "

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

+ ORDER BY option_id";

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

+

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

+ {

+ $this->options_lang[$field_id][$lang_id][($row['option_id'] + 1)] = $row['lang_value'];

+ }

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

+ }

+ }

+

+ /**

+ * Are language options set for this field?

+ *

+ * @param int $field_id Database ID of the field

+ * @param int $lang_id ID of the language

+ * @param int $field_value Selected value of the field

+ * @return boolean

+ */

+ public function is_set($field_id, $lang_id = null, $field_value = null)

+ {

+ $is_set = isset($this->options_lang[$field_id]);

+

+ if ($is_set && (!is_null($lang_id) || !is_null($field_value)))

+ {

+ $is_set = isset($this->options_lang[$field_id][$lang_id]);

+ }

+

+ if ($is_set && !is_null($field_value))

+ {

+ $is_set = isset($this->options_lang[$field_id][$lang_id][$field_value]);

+ }

+

+ return $is_set;

+ }

+

+ /**

+ * Get the selected language string

+ *

+ * @param int $field_id Database ID of the field

+ * @param int $lang_id ID of the language

+ * @param int $field_value Selected value of the field

+ * @return string

+ */

+ public function get($field_id, $lang_id, $field_value = null)

+ {

+ if (is_null($field_value))

+ {

+ return $this->options_lang[$field_id][$lang_id];

+ }

+

+ return $this->options_lang[$field_id][$lang_id][$field_value];

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\profilefields;

+

+/**

+* Custom Profile Fields

+* @package phpBB3

+*/

+class manager

+{

+ /**

+ * Auth object

+ * @var \phpbb\auth\auth

+ */

+ protected $auth;

+

+ /**

+ * Database object

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

+ */

+ protected $db;

+

+ /**

+ * Request object

+ * @var \phpbb\request\request

+ */

+ protected $request;

+

+ /**

+ * Template object

+ * @var \phpbb\template\template

+ */

+ protected $template;

+

+ /**

+ * Service Collection object

+ * @var \phpbb\di\service_collection

+ */

+ protected $type_collection;

+

+ /**

+ * User object

+ * @var \phpbb\user

+ */

+ protected $user;

+

+ protected $fields_table;

+

+ protected $fields_language_table;

+

+ protected $fields_data_table;

+

+ protected $profile_cache = array();

+

+ /**

+ * Construct

+ *

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

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

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

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

+ * @param \phpbb\di\service_collection $type_collection

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

+ * @param string $fields_table

+ * @param string $fields_language_table

+ * @param string $fields_data_table

+ */

+ public function __construct(\phpbb\auth\auth $auth, \phpbb\db\driver\driver $db, \phpbb\request\request $request, \phpbb\template\template $template, \phpbb\di\service_collection $type_collection, \phpbb\user $user, $fields_table, $fields_language_table, $fields_data_table)

+ {

+ $this->auth = $auth;

+ $this->db = $db;

+ $this->request = $request;

+ $this->template = $template;

+ $this->type_collection = $type_collection;

+ $this->user = $user;

+

+ $this->fields_table = $fields_table;

+ $this->fields_language_table = $fields_language_table;

+ $this->fields_data_table = $fields_data_table;

+ }

+

+ /**

+ * Assign editable fields to template, mode can be profile (for profile change) or register (for registration)

+ * Called by ucp_profile and ucp_register

+ */

+ public function generate_profile_fields($mode, $lang_id)

+ {

+ $sql_where = '';

+ switch ($mode)

+ {

+ case 'register':

+ // If the field is required we show it on the registration page

+ $sql_where .= ' AND f.field_show_on_reg = 1';

+ break;

+

+ case 'profile':

+ // Show hidden fields to moderators/admins

+ if (!$this->auth->acl_gets('a_', 'm_') && !$this->auth->acl_getf_global('m_'))

+ {

+ $sql_where .= ' AND f.field_show_profile = 1';

+ }

+ break;

+

+ default:

+ trigger_error('Wrong profile mode specified', E_USER_ERROR);

+ break;

+ }

+

+ $sql = 'SELECT l.*, f.*

+ FROM ' . $this->fields_language_table . ' l, ' . $this->fields_table . " f

+ WHERE f.field_active = 1

+ $sql_where

+ AND l.lang_id = " . (int) $lang_id . '

+ AND l.field_id = f.field_id

+ ORDER BY f.field_order';

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

+

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

+ {

+ // Return templated field

+ $profile_field = $this->type_collection[$row['field_type']];

+ $tpl_snippet = $profile_field->process_field_row('change', $row);

+

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

+ 'LANG_NAME' => $this->user->lang($row['lang_name']),

+ 'LANG_EXPLAIN' => $this->user->lang($row['lang_explain']),

+ 'FIELD' => $tpl_snippet,

+ 'FIELD_ID' => $profile_field->get_field_ident($row),

+ 'S_REQUIRED' => ($row['field_required']) ? true : false,

+ ));

+ }

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

+ }

+

+ /**

+ * Build profile cache, used for display

+ */

+ protected function build_cache()

+ {

+ $this->profile_cache = array();

+

+ // Display hidden/no_view fields for admin/moderator

+ $sql = 'SELECT l.*, f.*

+ FROM ' . $this->fields_language_table . ' l, ' . $this->fields_table . ' f

+ WHERE l.lang_id = ' . $this->user->get_iso_lang_id() . '

+ AND f.field_active = 1 ' .

+ ((!$this->auth->acl_gets('a_', 'm_') && !$this->auth->acl_getf_global('m_')) ? ' AND f.field_hide = 0 ' : '') . '

+ AND f.field_no_view = 0

+ AND l.field_id = f.field_id

+ ORDER BY f.field_order';

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

+

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

+ {

+ $this->profile_cache[$row['field_ident']] = $row;

+ }

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

+ }

+

+ /**

+ * Submit profile field for validation

+ */

+ public function submit_cp_field($mode, $lang_id, &$cp_data, &$cp_error)

+ {

+ $sql_where = '';

+ switch ($mode)

+ {

+ case 'register':

+ // If the field is required we show it on the registration page

+ $sql_where .= ' AND f.field_show_on_reg = 1';

+ break;

+

+ case 'profile':

+ // Show hidden fields to moderators/admins

+ if (!$this->auth->acl_gets('a_', 'm_') && !$this->auth->acl_getf_global('m_'))

+ {

+ $sql_where .= ' AND f.field_show_profile = 1';

+ }

+ break;

+

+ default:

+ trigger_error('Wrong profile mode specified', E_USER_ERROR);

+ break;

+ }

+

+ $sql = 'SELECT l.*, f.*

+ FROM ' . $this->fields_language_table . ' l, ' . $this->fields_table . ' f

+ WHERE l.lang_id = ' . (int) $lang_id . "

+ AND f.field_active = 1

+ $sql_where

+ AND l.field_id = f.field_id

+ ORDER BY f.field_order";

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

+

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

+ {

+ $profile_field = $this->type_collection[$row['field_type']];

+ $cp_data['pf_' . $row['field_ident']] = $profile_field->get_profile_field($row);

+ $check_value = $cp_data['pf_' . $row['field_ident']];

+

+ if (($cp_result = $profile_field->validate_profile_field($check_value, $row)) !== false)

+ {

+ // If the result is not false, it's an error message

+ $cp_error[] = $cp_result;

+ }

+ }

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

+ }

+

+ /**

+ * Update profile field data directly

+ */

+ public function update_profile_field_data($user_id, $cp_data)

+ {

+ if (!sizeof($cp_data))

+ {

+ return;

+ }

+

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

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

+ WHERE user_id = ' . (int) $user_id;

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

+

+ if (!$this->db->sql_affectedrows())

+ {

+ $cp_data['user_id'] = (int) $user_id;

+

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

+

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

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

+

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

+ }

+ }

+

+ /**

+ * Generate the template arrays in order to display the column names

+ *

+ * @param string $restrict_option Restrict the published fields to a certain profile field option

+ * @return array Returns an array with the template variables type, name and explain for the fields to display

+ */

+ public function generate_profile_fields_template_headlines($restrict_option = '')

+ {

+ if (!sizeof($this->profile_cache))

+ {

+ $this->build_cache();

+ }

+

+ $tpl_fields = array();

+

+ // Go through the fields in correct order

+ foreach ($this->profile_cache as $field_ident => $field_data)

+ {

+ if ($restrict_option && !$field_data[$restrict_option])

+ {

+ continue;

+ }

+

+ $profile_field = $this->type_collection[$field_data['field_type']];

+

+ $tpl_fields[] = array(

+ 'PROFILE_FIELD_TYPE' => $field_data['field_type'],

+ 'PROFILE_FIELD_NAME' => $profile_field->get_field_name($field_data['lang_name']),

+ 'PROFILE_FIELD_EXPLAIN' => $this->user->lang($field_data['lang_explain']),

+ );

+ }

+

+ return $tpl_fields;

+ }

+

+ /**

+ * Grab the user specific profile fields data

+ *

+ * @param int|array $user_ids Single user id or an array of ids

+ * @return array Users profile fields data

+ */

+ public function grab_profile_fields_data($user_ids = 0)

+ {

+ if (!is_array($user_ids))

+ {

+ $user_ids = array($user_ids);

+ }

+

+ if (!sizeof($this->profile_cache))

+ {

+ $this->build_cache();

+ }

+

+ if (!sizeof($user_ids))

+ {

+ return array();

+ }

+

+ $sql = 'SELECT *

+ FROM ' . $this->fields_data_table . '

+ WHERE ' . $this->db->sql_in_set('user_id', array_map('intval', $user_ids));

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

+

+ $field_data = array();

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

+ {

+ $field_data[$row['user_id']] = $row;

+ }

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

+

+ $user_fields = array();

+

+ // Go through the fields in correct order

+ foreach (array_keys($this->profile_cache) as $used_ident)

+ {

+ foreach ($field_data as $user_id => $row)

+ {

+ $user_fields[$user_id][$used_ident]['value'] = $row['pf_' . $used_ident];

+ $user_fields[$user_id][$used_ident]['data'] = $this->profile_cache[$used_ident];

+ }

+

+ foreach ($user_ids as $user_id)

+ {

+ if (!isset($user_fields[$user_id][$used_ident]) && $this->profile_cache[$used_ident]['field_show_novalue'])

+ {

+ $user_fields[$user_id][$used_ident]['value'] = '';

+ $user_fields[$user_id][$used_ident]['data'] = $this->profile_cache[$used_ident];

+ }

+ }

+ }

+

+ return $user_fields;

+ }

+

+ /**

+ * Assign the user's profile fields data to the template

+ *

+ * @param array $profile_row Array with users profile field data

+ * @param bool $use_contact_fields Should we display contact fields as such?

+ * This requires special treatments (links should not be parsed in the values, and more)

+ * @return array

+ */

+ public function generate_profile_fields_template_data($profile_row, $use_contact_fields = true)

+ {

+ // $profile_row == $user_fields[$row['user_id']];

+ $tpl_fields = array();

+ $tpl_fields['row'] = $tpl_fields['blockrow'] = array();

+

+ foreach ($profile_row as $ident => $ident_ary)

+ {

+ $profile_field = $this->type_collection[$ident_ary['data']['field_type']];

+ $value = $profile_field->get_profile_value($ident_ary['value'], $ident_ary['data']);

+

+ if ($value === null)

+ {

+ continue;

+ }

+

+ $field_desc = $contact_url = '';

+ if ($use_contact_fields)

+ {

+ $value = $profile_field->get_profile_contact_value($ident_ary['value'], $ident_ary['data']);

+ $field_desc = $this->user->lang($ident_ary['data']['field_contact_desc']);

+ if (strpos($field_desc, '%s') !== false)

+ {

+ $field_desc = sprintf($field_desc, $value);

+ }

+ $contact_url = '';

+ if (strpos($ident_ary['data']['field_contact_url'], '%s') !== false)

+ {

+ $contact_url = sprintf($ident_ary['data']['field_contact_url'], $value);

+ }

+ }

+

+ $tpl_fields['row'] += array(

+ 'PROFILE_' . strtoupper($ident) . '_IDENT' => $ident,

+ 'PROFILE_' . strtoupper($ident) . '_VALUE' => $value,

+ 'PROFILE_' . strtoupper($ident) . '_CONTACT'=> $contact_url,

+ 'PROFILE_' . strtoupper($ident) . '_DESC' => $field_desc,

+ 'PROFILE_' . strtoupper($ident) . '_TYPE' => $ident_ary['data']['field_type'],

+ 'PROFILE_' . strtoupper($ident) . '_NAME' => $this->user->lang($ident_ary['data']['lang_name']),

+ 'PROFILE_' . strtoupper($ident) . '_EXPLAIN'=> $this->user->lang($ident_ary['data']['lang_explain']),

+

+ 'S_PROFILE_' . strtoupper($ident) . '_CONTACT' => $ident_ary['data']['field_is_contact'],

+ 'S_PROFILE_' . strtoupper($ident) => true,

+ );

+

+ $tpl_fields['blockrow'][] = array(

+ 'PROFILE_FIELD_IDENT' => $ident,

+ 'PROFILE_FIELD_VALUE' => $value,

+ 'PROFILE_FIELD_CONTACT' => $contact_url,

+ 'PROFILE_FIELD_DESC' => $field_desc,

+ 'PROFILE_FIELD_TYPE' => $ident_ary['data']['field_type'],

+ 'PROFILE_FIELD_NAME' => $this->user->lang($ident_ary['data']['lang_name']),

+ 'PROFILE_FIELD_EXPLAIN' => $this->user->lang($ident_ary['data']['lang_explain']),

+

+ 'S_PROFILE_CONTACT' => $ident_ary['data']['field_is_contact'],

+ 'S_PROFILE_' . strtoupper($ident) => true,

+ );

+ }

+

+ return $tpl_fields;

+ }

+

+ /**

+ * Build Array for user insertion into custom profile fields table

+ */

+ public function build_insert_sql_array($cp_data)

+ {

+ $sql_not_in = array();

+ foreach ($cp_data as $key => $null)

+ {

+ $sql_not_in[] = (strncmp($key, 'pf_', 3) === 0) ? substr($key, 3) : $key;

+ }

+

+ $sql = 'SELECT f.field_type, f.field_ident, f.field_default_value, l.lang_default_value

+ FROM ' . $this->fields_language_table . ' l, ' . $this->fields_table . ' f

+ WHERE l.lang_id = ' . $this->user->get_iso_lang_id() . '

+ ' . ((sizeof($sql_not_in)) ? ' AND ' . $this->db->sql_in_set('f.field_ident', $sql_not_in, true) : '') . '

+ AND l.field_id = f.field_id';

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

+

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

+ {

+ $profile_field = $this->type_collection[$row['field_type']];

+ $cp_data['pf_' . $row['field_ident']] = $profile_field->get_default_field_value($row);

+ }

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

+

+ return $cp_data;

+ }

+}

+<?php

+/**

+*

+* @package phpBB

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\profilefields\type;

+

+abstract class type_base implements type_interface

+{

+ /**

+ * Request object

+ * @var \phpbb\request\request

+ */

+ protected $request;

+

+ /**

+ * Template object

+ * @var \phpbb\template\template

+ */

+ protected $template;

+

+ /**

+ * User object

+ * @var \phpbb\user

+ */

+ protected $user;

+

+ /**

+ * Construct

+ *

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

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

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

+ * @param string $language_table Table where the language strings are stored

+ */

+ public function __construct(\phpbb\request\request $request, \phpbb\template\template $template, \phpbb\user $user)

+ {

+ $this->request = $request;

+ $this->template = $template;

+ $this->user = $user;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_name()

+ {

+ return $this->user->lang('FIELD_' . strtoupper($this->get_name_short()));

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_service_name()

+ {

+ return 'profilefields.type.' . $this->get_name_short();

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_template_filename()

+ {

+ return 'profilefields/' . $this->get_name_short() . '.html';

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_field_ident($field_data)

+ {

+ return 'pf_' . $field_data['field_ident'];

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_field_name($field_name)

+ {

+ return isset($this->user->lang[$field_name]) ? $this->user->lang[$field_name] : $field_name;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_profile_contact_value($field_value, $field_data)

+ {

+ return $this->get_profile_value($field_value, $field_data);

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_language_options_input($field_data)

+ {

+ $field_data['l_lang_name'] = $this->request->variable('l_lang_name', array(0 => ''), true);

+ $field_data['l_lang_explain'] = $this->request->variable('l_lang_explain', array(0 => ''), true);

+ $field_data['l_lang_default_value'] = $this->request->variable('l_lang_default_value', array(0 => ''), true);

+ $field_data['l_lang_options'] = $this->request->variable('l_lang_options', array(0 => ''), true);

+

+ return $field_data;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function prepare_options_form(&$exclude_options, &$visibility_options)

+ {

+ return $this->request->variable('lang_options', '', true);

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function validate_options_on_submit($error, $field_data)

+ {

+ return $error;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_excluded_options($key, $action, $current_value, &$field_data, $step)

+ {

+ if ($step == 3 && ($field_data[$key] || $action != 'edit') && $key == 'l_lang_options' && is_array($field_data[$key]))

+ {

+ foreach ($field_data[$key] as $lang_id => $options)

+ {

+ $field_data[$key][$lang_id] = explode("\n", $options);

+ }

+

+ return $current_value;

+ }

+

+ return $current_value;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function prepare_hidden_fields($step, $key, $action, &$field_data)

+ {

+ if (!$this->request->is_set($key))

+ {

+ // Do not set this variable, we will use the default value

+ return null;

+ }

+ else if ($key == 'field_ident' && isset($field_data[$key]))

+ {

+ return $field_data[$key];

+ }

+ else

+ {

+ return $this->request->variable($key, '', true);

+ }

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function display_options(&$template_vars, &$field_data)

+ {

+ return;

+ }

+

+ /**

+ * Return templated value/field. Possible values for $mode are:

+ * change == user is able to set/enter profile values; preview == just show the value

+ */

+ public function process_field_row($mode, $profile_row)

+ {

+ $preview_options = ($mode == 'preview') ? $profile_row['lang_options'] : false;

+

+ // set template filename

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

+ 'cp_body' => $this->get_template_filename(),

+ ));

+

+ // empty previously filled blockvars

+ $this->template->destroy_block_vars($this->get_name_short());

+

+ // Assign template variables

+ $this->generate_field($profile_row, $preview_options);

+

+ return $this->template->assign_display('cp_body');

+ }

+}

+<?php

+/**

+*

+* @package phpBB

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\profilefields\type;

+

+class type_bool extends type_base

+{

+ /**

+ * Profile fields language helper

+ * @var \phpbb\profilefields\lang_helper

+ */

+ protected $lang_helper;

+

+ /**

+ * Request object

+ * @var \phpbb\request\request

+ */

+ protected $request;

+

+ /**

+ * Template object

+ * @var \phpbb\template\template

+ */

+ protected $template;

+

+ /**

+ * User object

+ * @var \phpbb\user

+ */

+ protected $user;

+

+ /**

+ * Construct

+ *

+ * @param \phpbb\profilefields\lang_helper $lang_helper Profile fields language helper

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

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

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

+ * @param string $language_table Table where the language strings are stored

+ */

+ public function __construct(\phpbb\profilefields\lang_helper $lang_helper, \phpbb\request\request $request, \phpbb\template\template $template, \phpbb\user $user)

+ {

+ $this->lang_helper = $lang_helper;

+ $this->request = $request;

+ $this->template = $template;

+ $this->user = $user;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_name_short()

+ {

+ return 'bool';

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_options($default_lang_id, $field_data)

+ {

+ $profile_row = array(

+ 'var_name' => 'field_default_value',

+ 'field_id' => 1,

+ 'lang_name' => $field_data['lang_name'],

+ 'lang_explain' => $field_data['lang_explain'],

+ 'lang_id' => $default_lang_id,

+ 'field_default_value' => $field_data['field_default_value'],

+ 'field_ident' => 'field_default_value',

+ 'field_type' => $this->get_service_name(),

+ 'field_length' => $field_data['field_length'],

+ 'lang_options' => $field_data['lang_options'],

+ );

+

+ $options = array(

+ 0 => array('TITLE' => $this->user->lang['FIELD_TYPE'], 'EXPLAIN' => $this->user->lang['BOOL_TYPE_EXPLAIN'], 'FIELD' => '<label><input type="radio" class="radio" name="field_length" value="1"' . (($field_data['field_length'] == 1) ? ' checked="checked"' : '') . ' onchange="document.getElementById(\'add_profile_field\').submit();" /> ' . $this->user->lang['RADIO_BUTTONS'] . '</label><label><input type="radio" class="radio" name="field_length" value="2"' . (($field_data['field_length'] == 2) ? ' checked="checked"' : '') . ' onchange="document.getElementById(\'add_profile_field\').submit();" /> ' . $this->user->lang['CHECKBOX'] . '</label>'),

+ 1 => array('TITLE' => $this->user->lang['DEFAULT_VALUE'], 'FIELD' => $this->process_field_row('preview', $profile_row)),

+ );

+

+ return $options;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_default_option_values()

+ {

+ return array(

+ 'field_length' => 1,

+ 'field_minlen' => 0,

+ 'field_maxlen' => 0,

+ 'field_validation' => '',

+ 'field_novalue' => 0,

+ 'field_default_value' => 0,

+ );

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_default_field_value($field_data)

+ {

+ return $field_data['field_default_value'];

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_profile_field($profile_row)

+ {

+ $var_name = 'pf_' . $profile_row['field_ident'];

+

+ // Checkbox

+ if ($profile_row['field_length'] == 2)

+ {

+ return ($this->request->is_set($var_name)) ? 1 : 0;

+ }

+ else

+ {

+ return $this->request->variable($var_name, (int) $profile_row['field_default_value']);

+ }

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function validate_profile_field(&$field_value, $field_data)

+ {

+ $field_value = (bool) $field_value;

+

+ if (!$field_value && $field_data['field_required'])

+ {

+ return $this->user->lang('FIELD_REQUIRED', $this->get_field_name($field_data['lang_name']));

+ }

+

+ return false;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_profile_value($field_value, $field_data)

+ {

+ $field_id = $field_data['field_id'];

+ $lang_id = $field_data['lang_id'];

+

+ if (!$this->lang_helper->is_set($field_id, $lang_id))

+ {

+ $this->lang_helper->get_option_lang($field_id, $lang_id, FIELD_BOOL, false);

+ }

+

+ if (!$field_value && $field_data['field_show_novalue'])

+ {

+ $field_value = $field_data['field_default_value'];

+ }

+

+ if ($field_data['field_length'] == 1)

+ {

+ return ($this->lang_helper->is_set($field_id, $lang_id, (int) $field_value)) ? $this->lang_helper->get($field_id, $lang_id, (int) $field_value) : null;

+ }

+ else if (!$field_value)

+ {

+ return null;

+ }

+ else

+ {

+ return $this->lang_helper->is_set($field_id, $lang_id, $field_value + 1);

+ }

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function generate_field($profile_row, $preview_options = false)

+ {

+ $profile_row['field_ident'] = (isset($profile_row['var_name'])) ? $profile_row['var_name'] : 'pf_' . $profile_row['field_ident'];

+ $field_ident = $profile_row['field_ident'];

+ $default_value = $profile_row['field_default_value'];

+

+ // checkbox - set the value to "true" if it has been set to 1

+ if ($profile_row['field_length'] == 2)

+ {

+ $value = ($this->request->is_set($field_ident) && $this->request->variable($field_ident, $default_value) == 1) ? true : ((!isset($this->user->profile_fields[$field_ident]) || $preview_options !== false) ? $default_value : $this->user->profile_fields[$field_ident]);

+ }

+ else

+ {

+ $value = ($this->request->is_set($field_ident)) ? $this->request->variable($field_ident, $default_value) : ((!isset($this->user->profile_fields[$field_ident]) || $preview_options !== false) ? $default_value : $this->user->profile_fields[$field_ident]);

+ }

+

+ $profile_row['field_value'] = (int) $value;

+ $this->template->assign_block_vars('bool', array_change_key_case($profile_row, CASE_UPPER));

+

+ if ($profile_row['field_length'] == 1)

+ {

+ if (!$this->lang_helper->is_set($profile_row['field_id'], $profile_row['lang_id'], 1))

+ {

+ $this->lang_helper->get_option_lang($profile_row['field_id'], $profile_row['lang_id'], $this->get_service_name(), $preview_options);

+ }

+

+ $options = $this->lang_helper->get($profile_row['field_id'], $profile_row['lang_id']);

+ foreach ($options as $option_id => $option_value)

+ {

+ $this->template->assign_block_vars('bool.options', array(

+ 'OPTION_ID' => $option_id,

+ 'CHECKED' => ($value == $option_id) ? ' checked="checked"' : '',

+ 'VALUE' => $option_value,

+ ));

+ }

+ }

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_field_ident($field_data)

+ {

+ return ($field_data['field_length'] == '1') ? '' : 'pf_' . $field_data['field_ident'];

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_database_column_type()

+ {

+ return 'TINT:2';

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_language_options($field_data)

+ {

+ $options = array(

+ 'lang_name' => 'string',

+ 'lang_options' => 'two_options',

+ );

+

+ if ($field_data['lang_explain'])

+ {

+ $options['lang_explain'] = 'text';

+ }

+

+ return $options;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_language_options_input($field_data)

+ {

+ $field_data['l_lang_name'] = $this->request->variable('l_lang_name', array(0 => ''), true);

+ $field_data['l_lang_explain'] = $this->request->variable('l_lang_explain', array(0 => ''), true);

+ $field_data['l_lang_default_value'] = $this->request->variable('l_lang_default_value', array(0 => ''), true);

+

+ /**

+ * @todo check if this line is correct...

+ $field_data['l_lang_default_value'] = $this->request->variable('l_lang_default_value', array(0 => array('')), true);

+ */

+ $field_data['l_lang_options'] = $this->request->variable('l_lang_options', array(0 => array('')), true);

+

+ return $field_data;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function prepare_options_form(&$exclude_options, &$visibility_options)

+ {

+ $exclude_options[1][] = 'lang_options';

+

+ return $this->request->variable('lang_options', array(''), true);

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function validate_options_on_submit($error, $field_data)

+ {

+ if (empty($field_data['lang_options'][0]) || empty($field_data['lang_options'][1]))

+ {

+ $error[] = $this->user->lang['NO_FIELD_ENTRIES'];

+ }

+

+ return $error;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_excluded_options($key, $action, $current_value, &$field_data, $step)

+ {

+ if ($step == 2 && $key == 'field_default_value')

+ {

+ // 'field_length' == 1 defines radio buttons. Possible values are 1 or 2 only.

+ // 'field_length' == 2 defines checkbox. Possible values are 0 or 1 only.

+ // If we switch the type on step 2, we have to adjust field value.

+ // 1 is a common value for the checkbox and radio buttons.

+

+ // Adjust unchecked checkbox value.

+ // If we return or save settings from 2nd/3rd page

+ // and the checkbox is unchecked, set the value to 0.

+ if ($this->request->is_set('step') && !$this->request->is_set($key))

+ {

+ return 0;

+ }

+

+ // If we switch to the checkbox type but former radio buttons value was 2,

+ // which is not the case for the checkbox, set it to 0 (unchecked).

+ if ($field_data['field_length'] == 2 && $current_value == 2)

+ {

+ return 0;

+ }

+ // If we switch to the radio buttons but the former checkbox value was 0,

+ // which is not the case for the radio buttons, set it to 0.

+ else if ($field_data['field_length'] == 1 && $current_value == 0)

+ {

+ return 2;

+ }

+ }

+

+ if ($step == 3 && ($field_data[$key] || $action != 'edit') && $key == 'l_lang_options')

+ {

+ $field_data[$key] = $this->request->variable($key, array(0 => array('')), true);

+

+ return $current_value;

+ }

+

+ return parent::get_excluded_options($key, $action, $current_value, $field_data, $step);

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function prepare_hidden_fields($step, $key, $action, &$field_data)

+ {

+ if ($key == 'l_lang_options' && $this->request->is_set('l_lang_options'))

+ {

+ return $this->request->variable($key, array(array('')), true);

+ }

+ else if ($key == 'field_default_value')

+ {

+ return $this->request->variable($key, $field_data[$key]);

+ }

+ else

+ {

+ if (!$this->request->is_set($key))

+ {

+ return false;

+ }

+ else if ($key == 'field_ident' && isset($field_data[$key]))

+ {

+ return $field_data[$key];

+ }

+ else

+ {

+ return ($key == 'lang_options') ? $this->request->variable($key, array(''), true) : $this->request->variable($key, '', true);

+ }

+ }

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function display_options(&$template_vars, &$field_data)

+ {

+ // Initialize these array elements if we are creating a new field

+ if (!sizeof($field_data['lang_options']))

+ {

+ // No options have been defined for a boolean field.

+ $field_data['lang_options'][0] = '';

+ $field_data['lang_options'][1] = '';

+ }

+

+ $template_vars = array_merge($template_vars, array(

+ 'S_BOOL' => true,

+ 'L_LANG_OPTIONS_EXPLAIN' => $this->user->lang['BOOL_ENTRIES_EXPLAIN'],

+ 'FIRST_LANG_OPTION' => $field_data['lang_options'][0],

+ 'SECOND_LANG_OPTION' => $field_data['lang_options'][1],

+ ));

+ }

+}

+<?php

+/**

+*

+* @package phpBB

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\profilefields\type;

+

+class type_date extends type_base

+{

+ /**

+ * Request object

+ * @var \phpbb\request\request

+ */

+ protected $request;

+

+ /**

+ * Template object

+ * @var \phpbb\template\template

+ */

+ protected $template;

+

+ /**

+ * User object

+ * @var \phpbb\user

+ */

+ protected $user;

+

+ /**

+ * Construct

+ *

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

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

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

+ * @param string $language_table Table where the language strings are stored

+ */

+ public function __construct(\phpbb\request\request $request, \phpbb\template\template $template, \phpbb\user $user)

+ {

+ $this->request = $request;

+ $this->template = $template;

+ $this->user = $user;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_name_short()

+ {

+ return 'date';

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_options($default_lang_id, $field_data)

+ {

+ $profile_row = array(

+ 'var_name' => 'field_default_value',

+ 'lang_name' => $field_data['lang_name'],

+ 'lang_explain' => $field_data['lang_explain'],

+ 'lang_id' => $default_lang_id,

+ 'field_default_value' => $field_data['field_default_value'],

+ 'field_ident' => 'field_default_value',

+ 'field_type' => $this->get_service_name(),

+ 'field_length' => $field_data['field_length'],

+ 'lang_options' => $field_data['lang_options'],

+ );

+

+ $always_now = request_var('always_now', -1);

+ if ($always_now == -1)

+ {

+ $s_checked = ($field_data['field_default_value'] == 'now') ? true : false;

+ }

+ else

+ {

+ $s_checked = ($always_now) ? true : false;

+ }

+

+ $options = array(

+ 0 => array('TITLE' => $this->user->lang['DEFAULT_VALUE'], 'FIELD' => $this->process_field_row('preview', $profile_row)),

+ 1 => array('TITLE' => $this->user->lang['ALWAYS_TODAY'], 'FIELD' => '<label><input type="radio" class="radio" name="always_now" value="1"' . (($s_checked) ? ' checked="checked"' : '') . ' onchange="document.getElementById(\'add_profile_field\').submit();" /> ' . $this->user->lang['YES'] . '</label><label><input type="radio" class="radio" name="always_now" value="0"' . ((!$s_checked) ? ' checked="checked"' : '') . ' onchange="document.getElementById(\'add_profile_field\').submit();" /> ' . $this->user->lang['NO'] . '</label>'),

+ );

+

+ return $options;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_default_option_values()

+ {

+ return array(

+ 'field_length' => 10,

+ 'field_minlen' => 10,

+ 'field_maxlen' => 10,

+ 'field_validation' => '',

+ 'field_novalue' => ' 0- 0- 0',

+ 'field_default_value' => ' 0- 0- 0',

+ );

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_default_field_value($field_data)

+ {

+ if ($field_data['field_default_value'] == 'now')

+ {

+ $now = getdate();

+ $field_data['field_default_value'] = sprintf('%2d-%2d-%4d', $now['mday'], $now['mon'], $now['year']);

+ }

+

+ return $field_data['field_default_value'];

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_profile_field($profile_row)

+ {

+ $var_name = 'pf_' . $profile_row['field_ident'];

+

+ if (!$this->request->is_set($var_name . '_day'))

+ {

+ if ($profile_row['field_default_value'] == 'now')

+ {

+ $now = getdate();

+ $profile_row['field_default_value'] = sprintf('%2d-%2d-%4d', $now['mday'], $now['mon'], $now['year']);

+ }

+ list($day, $month, $year) = explode('-', $profile_row['field_default_value']);

+ }

+ else

+ {

+ $day = $this->request->variable($var_name . '_day', 0);

+ $month = $this->request->variable($var_name . '_month', 0);

+ $year = $this->request->variable($var_name . '_year', 0);

+ }

+

+ return sprintf('%2d-%2d-%4d', $day, $month, $year);

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function validate_profile_field(&$field_value, $field_data)

+ {

+ $field_validate = explode('-', $field_value);

+

+ $day = (isset($field_validate[0])) ? (int) $field_validate[0] : 0;

+ $month = (isset($field_validate[1])) ? (int) $field_validate[1] : 0;

+ $year = (isset($field_validate[2])) ? (int) $field_validate[2] : 0;

+

+ if ((!$day || !$month || !$year) && !$field_data['field_required'])

+ {

+ return false;

+ }

+

+ if ((!$day || !$month || !$year) && $field_data['field_required'])

+ {

+ return $this->user->lang('FIELD_REQUIRED', $this->get_field_name($field_data['lang_name']));

+ }

+

+ if ($day < 0 || $day > 31 || $month < 0 || $month > 12 || ($year < 1901 && $year > 0) || $year > gmdate('Y', time()) + 50)

+ {

+ return $this->user->lang('FIELD_INVALID_DATE', $this->get_field_name($field_data['lang_name']));

+ }

+

+ if (checkdate($month, $day, $year) === false)

+ {

+ return $this->user->lang('FIELD_INVALID_DATE', $this->get_field_name($field_data['lang_name']));

+ }

+

+ return false;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_profile_value($field_value, $field_data)

+ {

+ $date = explode('-', $field_value);

+ $day = (isset($date[0])) ? (int) $date[0] : 0;

+ $month = (isset($date[1])) ? (int) $date[1] : 0;

+ $year = (isset($date[2])) ? (int) $date[2] : 0;

+

+ if (!$day && !$month && !$year && !$field_data['field_show_novalue'])

+ {

+ return null;

+ }

+ else if ($day && $month && $year)

+ {

+ // Date should display as the same date for every user regardless of timezone

+ return $this->user->create_datetime()

+ ->setDate($year, $month, $day)

+ ->setTime(0, 0, 0)

+ ->format($this->user->lang['DATE_FORMAT'], true);

+ }

+

+ return $field_value;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function generate_field($profile_row, $preview_options = false)

+ {

+ $profile_row['field_ident'] = (isset($profile_row['var_name'])) ? $profile_row['var_name'] : 'pf_' . $profile_row['field_ident'];

+ $field_ident = $profile_row['field_ident'];

+

+ $now = getdate();

+

+ if (!$this->request->is_set($profile_row['field_ident'] . '_day'))

+ {

+ if ($profile_row['field_default_value'] == 'now')

+ {

+ $profile_row['field_default_value'] = sprintf('%2d-%2d-%4d', $now['mday'], $now['mon'], $now['year']);

+ }

+ list($day, $month, $year) = explode('-', ((!isset($this->user->profile_fields[$field_ident]) || $preview_options !== false) ? $profile_row['field_default_value'] : $this->user->profile_fields[$field_ident]));

+ }

+ else

+ {

+ if ($preview_options !== false && $profile_row['field_default_value'] == 'now')

+ {

+ $profile_row['field_default_value'] = sprintf('%2d-%2d-%4d', $now['mday'], $now['mon'], $now['year']);

+ list($day, $month, $year) = explode('-', ((!isset($this->user->profile_fields[$field_ident]) || $preview_options !== false) ? $profile_row['field_default_value'] : $this->user->profile_fields[$field_ident]));

+ }

+ else

+ {

+ $day = $this->request->variable($profile_row['field_ident'] . '_day', 0);

+ $month = $this->request->variable($profile_row['field_ident'] . '_month', 0);

+ $year = $this->request->variable($profile_row['field_ident'] . '_year', 0);

+ }

+ }

+

+ $profile_row['s_day_options'] = '<option value="0"' . ((!$day) ? ' selected="selected"' : '') . '>--</option>';

+ for ($i = 1; $i < 32; $i++)

+ {

+ $profile_row['s_day_options'] .= '<option value="' . $i . '"' . (($i == $day) ? ' selected="selected"' : '') . ">$i</option>";

+ }

+

+ $profile_row['s_month_options'] = '<option value="0"' . ((!$month) ? ' selected="selected"' : '') . '>--</option>';

+ for ($i = 1; $i < 13; $i++)

+ {

+ $profile_row['s_month_options'] .= '<option value="' . $i . '"' . (($i == $month) ? ' selected="selected"' : '') . ">$i</option>";

+ }

+

+ $profile_row['s_year_options'] = '<option value="0"' . ((!$year) ? ' selected="selected"' : '') . '>--</option>';

+ for ($i = $now['year'] - 100; $i <= $now['year'] + 100; $i++)

+ {

+ $profile_row['s_year_options'] .= '<option value="' . $i . '"' . (($i == $year) ? ' selected="selected"' : '') . ">$i</option>";

+ }

+

+ $profile_row['field_value'] = 0;

+ $this->template->assign_block_vars('date', array_change_key_case($profile_row, CASE_UPPER));

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_field_ident($field_data)

+ {

+ return '';

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_database_column_type()

+ {

+ return 'VCHAR:10';

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_language_options($field_data)

+ {

+ $options = array(

+ 'lang_name' => 'string',

+ );

+

+ if ($field_data['lang_explain'])

+ {

+ $options['lang_explain'] = 'text';

+ }

+

+ return $options;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_excluded_options($key, $action, $current_value, &$field_data, $step)

+ {

+ if ($step == 2 && $key == 'field_default_value')

+ {

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

+

+ if ($always_now == 1 || ($always_now === -1 && $current_value == 'now'))

+ {

+ $now = getdate();

+

+ $field_data['field_default_value_day'] = $now['mday'];

+ $field_data['field_default_value_month'] = $now['mon'];

+ $field_data['field_default_value_year'] = $now['year'];

+ $current_value = 'now';

+ $this->request->overwrite('field_default_value', $current_value, \phpbb\request\request_interface::POST);

+ }

+ else

+ {

+ if ($this->request->is_set('field_default_value_day'))

+ {

+ $field_data['field_default_value_day'] = $this->request->variable('field_default_value_day', 0);

+ $field_data['field_default_value_month'] = $this->request->variable('field_default_value_month', 0);

+ $field_data['field_default_value_year'] = $this->request->variable('field_default_value_year', 0);

+ $current_value = sprintf('%2d-%2d-%4d', $field_data['field_default_value_day'], $field_data['field_default_value_month'], $field_data['field_default_value_year']);

+ $this->request->overwrite('field_default_value', $current_value, \phpbb\request\request_interface::POST);

+ }

+ else

+ {

+ list($field_data['field_default_value_day'], $field_data['field_default_value_month'], $field_data['field_default_value_year']) = explode('-', $current_value);

+ }

+ }

+

+ return $current_value;

+ }

+

+ return parent::get_excluded_options($key, $action, $current_value, $field_data, $step);

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function prepare_hidden_fields($step, $key, $action, &$field_data)

+ {

+ if ($key == 'field_default_value')

+ {

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

+

+ if ($always_now)

+ {

+ return 'now';

+ }

+ else if ($this->request->is_set('field_default_value_day'))

+ {

+ $field_data['field_default_value_day'] = $this->request->variable('field_default_value_day', 0);

+ $field_data['field_default_value_month'] = $this->request->variable('field_default_value_month', 0);

+ $field_data['field_default_value_year'] = $this->request->variable('field_default_value_year', 0);

+ return sprintf('%2d-%2d-%4d', $field_data['field_default_value_day'], $field_data['field_default_value_month'], $field_data['field_default_value_year']);

+ }

+ }

+

+ return parent::prepare_hidden_fields($step, $key, $action, $field_data);

+ }

+}

+<?php

+/**

+*

+* @package phpBB

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\profilefields\type;

+

+class type_dropdown extends type_base

+{

+ /**

+ * Profile fields language helper

+ * @var \phpbb\profilefields\lang_helper

+ */

+ protected $lang_helper;

+

+ /**

+ * Request object

+ * @var \phpbb\request\request

+ */

+ protected $request;

+

+ /**

+ * Template object

+ * @var \phpbb\template\template

+ */

+ protected $template;

+

+ /**

+ * User object

+ * @var \phpbb\user

+ */

+ protected $user;

+

+ /**

+ * Construct

+ *

+ * @param \phpbb\profilefields\lang_helper $lang_helper Profile fields language helper

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

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

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

+ * @param string $language_table Table where the language strings are stored

+ */

+ public function __construct(\phpbb\profilefields\lang_helper $lang_helper, \phpbb\request\request $request, \phpbb\template\template $template, \phpbb\user $user)

+ {

+ $this->lang_helper = $lang_helper;

+ $this->request = $request;

+ $this->template = $template;

+ $this->user = $user;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_name_short()

+ {

+ return 'dropdown';

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_options($default_lang_id, $field_data)

+ {

+ $profile_row[0] = array(

+ 'var_name' => 'field_default_value',

+ 'field_id' => 1,

+ 'lang_name' => $field_data['lang_name'],

+ 'lang_explain' => $field_data['lang_explain'],

+ 'lang_id' => $default_lang_id,

+ 'field_default_value' => $field_data['field_default_value'],

+ 'field_ident' => 'field_default_value',

+ 'field_type' => $this->get_service_name(),

+ 'lang_options' => $field_data['lang_options'],

+ );

+

+ $profile_row[1] = $profile_row[0];

+ $profile_row[1]['var_name'] = 'field_novalue';

+ $profile_row[1]['field_ident'] = 'field_novalue';

+ $profile_row[1]['field_default_value'] = $field_data['field_novalue'];

+

+ $options = array(

+ 0 => array('TITLE' => $this->user->lang['DEFAULT_VALUE'], 'FIELD' => $this->process_field_row('preview', $profile_row[0])),

+ 1 => array('TITLE' => $this->user->lang['NO_VALUE_OPTION'], 'EXPLAIN' => $this->user->lang['NO_VALUE_OPTION_EXPLAIN'], 'FIELD' => $this->process_field_row('preview', $profile_row[1])),

+ );

+

+ return $options;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_default_option_values()

+ {

+ return array(

+ 'field_length' => 0,

+ 'field_minlen' => 0,

+ 'field_maxlen' => 5,

+ 'field_validation' => '',

+ 'field_novalue' => 0,

+ 'field_default_value' => 0,

+ );

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_default_field_value($field_data)

+ {

+ return $field_data['field_default_value'];

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_profile_field($profile_row)

+ {

+ $var_name = 'pf_' . $profile_row['field_ident'];

+ return $this->request->variable($var_name, (int) $profile_row['field_default_value']);

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function validate_profile_field(&$field_value, $field_data)

+ {

+ $field_value = (int) $field_value;

+

+ // retrieve option lang data if necessary

+ if (!$this->lang_helper->is_set($field_data['field_id'], $field_data['lang_id'], 1))

+ {

+ $this->lang_helper->get_option_lang($field_data['field_id'], $field_data['lang_id'], $this->get_service_name(), false);

+ }

+

+ if (!$this->lang_helper->is_set($field_data['field_id'], $field_data['lang_id'], $field_value))

+ {

+ return $this->user->lang('FIELD_INVALID_VALUE', $this->get_field_name($field_data['lang_name']));

+ }

+

+ if ($field_value == $field_data['field_novalue'] && $field_data['field_required'])

+ {

+ return $this->user->lang('FIELD_REQUIRED', $this->get_field_name($field_data['lang_name']));

+ }

+

+ return false;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_profile_value($field_value, $field_data)

+ {

+ $field_id = $field_data['field_id'];

+ $lang_id = $field_data['lang_id'];

+ if (!$this->lang_helper->is_set($field_id, $lang_id))

+ {

+ $this->lang_helper->get_option_lang($field_id, $lang_id, $this->get_service_name(), false);

+ }

+

+ if ($field_value == $field_data['field_novalue'] && !$field_data['field_show_novalue'])

+ {

+ return null;

+ }

+

+ $field_value = (int) $field_value;

+

+ // User not having a value assigned

+ if (!$this->lang_helper->is_set($field_id, $lang_id, $field_value))

+ {

+ if ($field_data['field_show_novalue'])

+ {

+ $field_value = $field_data['field_novalue'];

+ }

+ else

+ {

+ return null;

+ }

+ }

+

+ return $this->lang_helper->get($field_id, $lang_id, $field_value);

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function generate_field($profile_row, $preview_options = false)

+ {

+ $profile_row['field_ident'] = (isset($profile_row['var_name'])) ? $profile_row['var_name'] : 'pf_' . $profile_row['field_ident'];

+ $field_ident = $profile_row['field_ident'];

+ $default_value = $profile_row['field_default_value'];

+

+ $value = ($this->request->is_set($field_ident)) ? $this->request->variable($field_ident, $default_value) : ((!isset($this->user->profile_fields[$field_ident]) || $preview_options !== false) ? $default_value : $this->user->profile_fields[$field_ident]);

+

+ if (!$this->lang_helper->is_set($profile_row['field_id'], $profile_row['lang_id'], 1))

+ {

+ $this->lang_helper->get_option_lang($profile_row['field_id'], $profile_row['lang_id'], $this->get_service_name(), $preview_options);

+ }

+

+ $profile_row['field_value'] = (int) $value;

+ $this->template->assign_block_vars('dropdown', array_change_key_case($profile_row, CASE_UPPER));

+

+ $options = $this->lang_helper->get($profile_row['field_id'], $profile_row['lang_id']);

+ foreach ($options as $option_id => $option_value)

+ {

+ $this->template->assign_block_vars('dropdown.options', array(

+ 'OPTION_ID' => $option_id,

+ 'SELECTED' => ($value == $option_id) ? ' selected="selected"' : '',

+ 'VALUE' => $option_value,

+ ));

+ }

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_database_column_type()

+ {

+ return 'UINT';

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_language_options($field_data)

+ {

+ $options = array(

+ 'lang_name' => 'string',

+ 'lang_options' => 'optionfield',

+ );

+

+ if ($field_data['lang_explain'])

+ {

+ $options['lang_explain'] = 'text';

+ }

+

+ return $options;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function prepare_options_form(&$exclude_options, &$visibility_options)

+ {

+ $exclude_options[1][] = 'lang_options';

+

+ return $this->request->variable('lang_options', '', true);

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function validate_options_on_submit($error, $field_data)

+ {

+ if (!sizeof($field_data['lang_options']))

+ {

+ $error[] = $this->user->lang['NO_FIELD_ENTRIES'];

+ }

+

+ return $error;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_excluded_options($key, $action, $current_value, &$field_data, $step)

+ {

+ if ($step == 2 && $key == 'field_maxlen')

+ {

+ // Get the number of options if this key is 'field_maxlen'

+ return sizeof(explode("\n", $this->request->variable('lang_options', '', true)));

+ }

+

+ return parent::get_excluded_options($key, $action, $current_value, $field_data, $step);

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function display_options(&$template_vars, &$field_data)

+ {

+ // Initialize these array elements if we are creating a new field

+ if (!sizeof($field_data['lang_options']))

+ {

+ // No options have been defined for the dropdown menu

+ $field_data['lang_options'] = array();

+ }

+

+ $template_vars = array_merge($template_vars, array(

+ 'S_DROPDOWN' => true,

+ 'L_LANG_OPTIONS_EXPLAIN' => $this->user->lang['DROPDOWN_ENTRIES_EXPLAIN'],

+ 'LANG_OPTIONS' => implode("\n", $field_data['lang_options']),

+ ));

+ }

+}

+<?php

+/**

+*

+* @package phpBB

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\profilefields\type;

+

+class type_int extends type_base

+{

+ /**

+ * Request object

+ * @var \phpbb\request\request

+ */

+ protected $request;

+

+ /**

+ * Template object

+ * @var \phpbb\template\template

+ */

+ protected $template;

+

+ /**

+ * User object

+ * @var \phpbb\user

+ */

+ protected $user;

+

+ /**

+ * Construct

+ *

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

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

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

+ * @param string $language_table Table where the language strings are stored

+ */

+ public function __construct(\phpbb\request\request $request, \phpbb\template\template $template, \phpbb\user $user)

+ {

+ $this->request = $request;

+ $this->template = $template;

+ $this->user = $user;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_name_short()

+ {

+ return 'int';

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_options($default_lang_id, $field_data)

+ {

+ $options = array(

+ 0 => array('TITLE' => $this->user->lang['FIELD_LENGTH'], 'FIELD' => '<input type="number" min="0" max="99999" name="field_length" size="5" value="' . $field_data['field_length'] . '" />'),

+ 1 => array('TITLE' => $this->user->lang['MIN_FIELD_NUMBER'], 'FIELD' => '<input type="number" min="0" max="99999" name="field_minlen" size="5" value="' . $field_data['field_minlen'] . '" />'),

+ 2 => array('TITLE' => $this->user->lang['MAX_FIELD_NUMBER'], 'FIELD' => '<input type="number" min="0" max="99999" name="field_maxlen" size="5" value="' . $field_data['field_maxlen'] . '" />'),

+ 3 => array('TITLE' => $this->user->lang['DEFAULT_VALUE'], 'FIELD' => '<input type="number" name="field_default_value" value="' . $field_data['field_default_value'] . '" />'),

+ );

+

+ return $options;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_default_option_values()

+ {

+ return array(

+ 'field_length' => 5,

+ 'field_minlen' => 0,

+ 'field_maxlen' => 100,

+ 'field_validation' => '',

+ 'field_novalue' => 0,

+ 'field_default_value' => 0,

+ );

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_default_field_value($field_data)

+ {

+ if ($field_data['field_default_value'] === '')

+ {

+ // We cannot insert an empty string into an integer column.

+ return null;

+ }

+

+ return $field_data['field_default_value'];

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_profile_field($profile_row)

+ {

+ $var_name = 'pf_' . $profile_row['field_ident'];

+ if ($this->request->is_set($var_name) && $this->request->variable($var_name, '') === '')

+ {

+ return null;

+ }

+ else

+ {

+ return $this->request->variable($var_name, (int) $profile_row['field_default_value']);

+ }

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function validate_profile_field(&$field_value, $field_data)

+ {

+ if (trim($field_value) === '' && !$field_data['field_required'])

+ {

+ return false;

+ }

+

+ $field_value = (int) $field_value;

+

+ if ($field_value < $field_data['field_minlen'])

+ {

+ return $this->user->lang('FIELD_TOO_SMALL', (int) $field_data['field_minlen'], $this->get_field_name($field_data['lang_name']));

+ }

+ else if ($field_value > $field_data['field_maxlen'])

+ {

+ return $this->user->lang('FIELD_TOO_LARGE', (int) $field_data['field_maxlen'], $this->get_field_name($field_data['lang_name']));

+ }

+

+ return false;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_profile_value($field_value, $field_data)

+ {

+ if (($field_value === '' || $field_value === null) && !$field_data['field_show_novalue'])

+ {

+ return null;

+ }

+ return (int) $field_value;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function generate_field($profile_row, $preview_options = false)

+ {

+ $profile_row['field_ident'] = (isset($profile_row['var_name'])) ? $profile_row['var_name'] : 'pf_' . $profile_row['field_ident'];

+ $field_ident = $profile_row['field_ident'];

+ $default_value = $profile_row['field_default_value'];

+

+ if ($this->request->is_set($field_ident))

+ {

+ $value = ($this->request->variable($field_ident, '') === '') ? null : $this->request->variable($field_ident, $default_value);

+ }

+ else

+ {

+ if ($preview_options === false && array_key_exists($field_ident, $this->user->profile_fields) && is_null($this->user->profile_fields[$field_ident]))

+ {

+ $value = null;

+ }

+ else if (!isset($this->user->profile_fields[$field_ident]) || $preview_options !== false)

+ {

+ $value = $default_value;

+ }

+ else

+ {

+ $value = $this->user->profile_fields[$field_ident];

+ }

+ }

+

+ $profile_row['field_value'] = (is_null($value) || $value === '') ? '' : (int) $value;

+

+ $this->template->assign_block_vars('int', array_change_key_case($profile_row, CASE_UPPER));

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_field_ident($field_data)

+ {

+ return 'pf_' . $field_data['field_ident'];

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_database_column_type()

+ {

+ return 'BINT';

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_language_options($field_data)

+ {

+ $options = array(

+ 'lang_name' => 'string',

+ );

+

+ if ($field_data['lang_explain'])

+ {

+ $options['lang_explain'] = 'text';

+ }

+

+ return $options;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_excluded_options($key, $action, $current_value, &$field_data, $step)

+ {

+ if ($step == 2 && $key == 'field_default_value')

+ {

+ // Permit an empty string

+ if ($action == 'create' && $this->request->variable('field_default_value', '') === '')

+ {

+ return '';

+ }

+ }

+

+ return parent::get_excluded_options($key, $action, $current_value, $field_data, $step);

+ }

+}

+<?php

+/**

+*

+* @package phpBB

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\profilefields\type;

+

+interface type_interface

+{

+ /**

+ * Get the translated name of the type

+ *

+ * @return string Translated name of the field type

+ */

+ public function get_name();

+

+ /**

+ * Get the short name of the type, used for error messages and template loops

+ *

+ * @return string lowercase version of the fields type

+ */

+ public function get_name_short();

+

+ /**

+ * Get the name of service representing the type

+ *

+ * @return string lowercase version of the fields type

+ */

+ public function get_service_name();

+

+ /**

+ * Get the name of template file for this type

+ *

+ * @return string Returns the name of the template file

+ */

+ public function get_template_filename();

+

+ /**

+ * Get dropdown options for second step in ACP

+ *

+ * @param string $default_lang_id ID of the default language

+ * @param array $field_data Array with data for this field

+ * @return array with the acp options

+ */

+ public function get_options($default_lang_id, $field_data);

+

+ /**

+ * Get default values for the options of this type

+ *

+ * @return array with values like default field size and more

+ */

+ public function get_default_option_values();

+

+ /**

+ * Get default value for this type

+ *

+ * @param array $field_data Array with data for this field

+ * @return mixed default value for new users when no value is given

+ */

+ public function get_default_field_value($field_data);

+

+ /**

+ * Get profile field value on submit

+ *

+ * @param array $profile_row Array with data for this field

+ * @return mixed Submitted value of the profile field

+ */

+ public function get_profile_field($profile_row);

+

+ /**

+ * Validate entered profile field data

+ *

+ * @param mixed $field_value Field value to validate

+ * @param array $field_data Array with requirements of the field

+ * @return mixed String with the error message

+ */

+ public function validate_profile_field(&$field_value, $field_data);

+

+ /**

+ * Get Profile Value for display

+ *

+ * @param mixed $field_value Field value as stored in the database

+ * @param array $field_data Array with requirements of the field

+ * @return mixed Field value to display

+ */

+ public function get_profile_value($field_value, $field_data);

+

+ /**

+ * Get Profile Value for display

+ *

+ * When displaying a contact field, we don't want to have links already parsed and more

+ *

+ * @param mixed $field_value Field value as stored in the database

+ * @param array $field_data Array with requirements of the field

+ * @return mixed Field value to display

+ */

+ public function get_profile_contact_value($field_value, $field_data);

+

+ /**

+ * Generate the input field for display

+ *

+ * @param array $profile_row Array with data for this field

+ * @param mixed $preview_options When previewing we use different data

+ * @return null

+ */

+ public function generate_field($profile_row, $preview_options = false);

+

+ /**

+ * Get the ident of the field

+ *

+ * Some types are multivalue, we can't give them a field_id

+ * as we would not know which to pick.

+ *

+ * @param array $field_data Array with data for this field

+ * @return string ident of the field

+ */

+ public function get_field_ident($field_data);

+

+ /**

+ * Get the column type for the database

+ *

+ * @return string Returns the database column type

+ */

+ public function get_database_column_type();

+

+ /**

+ * Get the options we need to display for the language input fields in the ACP

+ *

+ * @param array $field_data Array with data for this field

+ * @return array Returns the language options we need to generate

+ */

+ public function get_language_options($field_data);

+

+ /**

+ * Get the input for the supplied language options

+ *

+ * @param array $field_data Array with data for this field

+ * @return array Returns the language options we need to generate

+ */

+ public function get_language_options_input($field_data);

+

+ /**

+ * Allows exclusion of options in single steps of the creation process

+ *

+ * @param array $exclude_options Array with options that should be excluded in the steps

+ * @param array $visibility_options Array with options responsible for the fields visibility

+ * @return mixed Returns the provided language options

+ */

+ public function prepare_options_form(&$exclude_options, &$visibility_options);

+

+ /**

+ * Allows exclusion of options in single steps of the creation process

+ *

+ * @param array $error Array with error messages

+ * @param array $field_data Array with data for this field

+ * @return array Array with error messages

+ */

+ public function validate_options_on_submit($error, $field_data);

+

+ /**

+ * Allows manipulating the intended variables if needed

+ *

+ * @param string $key Name of the option

+ * @param string $action Currently performed action (create|edit)

+ * @param mixed $current_value Currently value of the option

+ * @param array $field_data Array with data for this field

+ * @param int $step Step on which the option is excluded

+ * @return mixed Final value of the option

+ */

+ public function get_excluded_options($key, $action, $current_value, &$field_data, $step);

+

+ /**

+ * Allows manipulating the intended variables if needed

+ *

+ * @param string $key Name of the option

+ * @param int $step Step on which the option is hidden

+ * @param string $action Currently performed action (create|edit)

+ * @param array $field_data Array with data for this field

+ * @return mixed Final value of the option

+ */

+ public function prepare_hidden_fields($step, $key, $action, &$field_data);

+

+ /**

+ * Allows assigning of additional template variables

+ *

+ * @param array $template_vars Template variables we are going to assign

+ * @param array $field_data Array with data for this field

+ * @return null

+ */

+ public function display_options(&$template_vars, &$field_data);

+

+ /**

+ * Return templated value/field. Possible values for $mode are:

+ * change == user is able to set/enter profile values; preview == just show the value

+ *

+ * @param string $mode Mode for displaying the field (preview|change)

+ * @param array $profile_row Array with data for this field

+ * @return null

+ */

+ public function process_field_row($mode, $profile_row);

+}

+<?php

+/**

+*

+* @package phpBB

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\profilefields\type;

+

+class type_string extends type_string_common

+{

+ /**

+ * Request object

+ * @var \phpbb\request\request

+ */

+ protected $request;

+

+ /**

+ * Template object

+ * @var \phpbb\template\template

+ */

+ protected $template;

+

+ /**

+ * User object

+ * @var \phpbb\user

+ */

+ protected $user;

+

+ /**

+ * Construct

+ *

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

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

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

+ * @param string $language_table Table where the language strings are stored

+ */

+ public function __construct(\phpbb\request\request $request, \phpbb\template\template $template, \phpbb\user $user)

+ {

+ $this->request = $request;

+ $this->template = $template;

+ $this->user = $user;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_name_short()

+ {

+ return 'string';

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_options($default_lang_id, $field_data)

+ {

+ $options = array(

+ 0 => array('TITLE' => $this->user->lang['FIELD_LENGTH'], 'FIELD' => '<input type="number" min="0" name="field_length" size="5" value="' . $field_data['field_length'] . '" />'),

+ 1 => array('TITLE' => $this->user->lang['MIN_FIELD_CHARS'], 'FIELD' => '<input type="number" min="0" name="field_minlen" size="5" value="' . $field_data['field_minlen'] . '" />'),

+ 2 => array('TITLE' => $this->user->lang['MAX_FIELD_CHARS'], 'FIELD' => '<input type="number" min="0" name="field_maxlen" size="5" value="' . $field_data['field_maxlen'] . '" />'),

+ 3 => array('TITLE' => $this->user->lang['FIELD_VALIDATION'], 'FIELD' => '<select name="field_validation">' . $this->validate_options($field_data) . '</select>'),

+ );

+

+ return $options;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_default_option_values()

+ {

+ return array(

+ 'field_length' => 10,

+ 'field_minlen' => 0,

+ 'field_maxlen' => 20,

+ 'field_validation' => '.*',

+ 'field_novalue' => '',

+ 'field_default_value' => '',

+ );

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_profile_field($profile_row)

+ {

+ $var_name = 'pf_' . $profile_row['field_ident'];

+ return $this->request->variable($var_name, (string) $profile_row['field_default_value'], true);

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function validate_profile_field(&$field_value, $field_data)

+ {

+ return $this->validate_string_profile_field('string', $field_value, $field_data);

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function generate_field($profile_row, $preview_options = false)

+ {

+ $profile_row['field_ident'] = (isset($profile_row['var_name'])) ? $profile_row['var_name'] : 'pf_' . $profile_row['field_ident'];

+ $field_ident = $profile_row['field_ident'];

+ $default_value = $profile_row['lang_default_value'];

+ $profile_row['field_value'] = ($this->request->is_set($field_ident)) ? $this->request->variable($field_ident, $default_value, true) : ((!isset($this->user->profile_fields[$field_ident]) || $preview_options !== false) ? $default_value : $this->user->profile_fields[$field_ident]);

+

+ $this->template->assign_block_vars($this->get_name_short(), array_change_key_case($profile_row, CASE_UPPER));

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_database_column_type()

+ {

+ return 'VCHAR';

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_language_options($field_data)

+ {

+ $options = array(

+ 'lang_name' => 'string',

+ );

+

+ if ($field_data['lang_explain'])

+ {

+ $options['lang_explain'] = 'text';

+ }

+

+ if (strlen($field_data['lang_default_value']))

+ {

+ $options['lang_default_value'] = 'string';

+ }

+

+ return $options;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function display_options(&$template_vars, &$field_data)

+ {

+ $template_vars = array_merge($template_vars, array(

+ 'S_STRING' => true,

+ 'L_DEFAULT_VALUE_EXPLAIN' => $this->user->lang['STRING_DEFAULT_VALUE_EXPLAIN'],

+ 'LANG_DEFAULT_VALUE' => $field_data['lang_default_value'],

+ ));

+ }

+}

+<?php

+/**

+*

+* @package phpBB

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\profilefields\type;

+

+abstract class type_string_common extends type_base

+{

+ protected $validation_options = array(

+ 'CHARS_ANY' => '.*',

+ 'NUMBERS_ONLY' => '[0-9]+',

+ 'ALPHA_ONLY' => '[\w]+',

+ 'ALPHA_UNDERSCORE' => '[\w_]+',

+ 'ALPHA_SPACERS' => '[\w_\+\. \-\[\]]+',

+ );

+

+ /**

+ * Return possible validation options

+ */

+ public function validate_options($field_data)

+ {

+ $validate_options = '';

+ foreach ($this->validation_options as $lang => $value)

+ {

+ $selected = ($field_data['field_validation'] == $value) ? ' selected="selected"' : '';

+ $validate_options .= '<option value="' . $value . '"' . $selected . '>' . $this->user->lang[$lang] . '</option>';

+ }

+

+ return $validate_options;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_default_field_value($field_data)

+ {

+ return $field_data['lang_default_value'];

+ }

+

+ /**

+ * Validate entered profile field data

+ *

+ * @param string $field_type Field type (string or text)

+ * @param mixed $field_value Field value to validate

+ * @param array $field_data Array with requirements of the field

+ * @return mixed String with key of the error language string, false otherwise

+ */

+ public function validate_string_profile_field($field_type, &$field_value, $field_data)

+ {

+ if (trim($field_value) === '' && !$field_data['field_required'])

+ {

+ return false;

+ }

+ else if (trim($field_value) === '' && $field_data['field_required'])

+ {

+ return $this->user->lang('FIELD_REQUIRED', $this->get_field_name($field_data['lang_name']));

+ }

+

+ if ($field_data['field_minlen'] && utf8_strlen($field_value) < $field_data['field_minlen'])

+ {

+ return $this->user->lang('FIELD_TOO_SHORT', (int) $field_data['field_minlen'], $this->get_field_name($field_data['lang_name']));

+ }

+ else if ($field_data['field_maxlen'] && utf8_strlen($field_value) > $field_data['field_maxlen'])

+ {

+ return $this->user->lang('FIELD_TOO_LONG', (int) $field_data['field_maxlen'], $this->get_field_name($field_data['lang_name']));

+ }

+

+ if (!empty($field_data['field_validation']) && $field_data['field_validation'] != '.*')

+ {

+ $field_validate = ($field_type != 'text') ? $field_value : bbcode_nl2br($field_value);

+ if (!preg_match('#^' . str_replace('\\\\', '\\', $field_data['field_validation']) . '$#i', $field_validate))

+ {

+ $validation = array_search($field_data['field_validation'], $this->validation_options);

+ if ($validation)

+ {

+ return $this->user->lang('FIELD_INVALID_CHARS_' . $validation, $this->get_field_name($field_data['lang_name']));

+ }

+ return $this->user->lang('FIELD_INVALID_CHARS_INVALID', $this->get_field_name($field_data['lang_name']));

+ }

+ }

+

+ return false;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_profile_value($field_value, $field_data)

+ {

+ if (!$field_value && !$field_data['field_show_novalue'])

+ {

+ return null;

+ }

+

+ $field_value = make_clickable($field_value);

+ $field_value = censor_text($field_value);

+ $field_value = bbcode_nl2br($field_value);

+ return $field_value;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_profile_contact_value($field_value, $field_data)

+ {

+ if (!$field_value && !$field_data['field_show_novalue'])

+ {