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

+ $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('&', '&'), array('&', '&'), $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) 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-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"

+}

+ 'SELECT' => 'p.post_id, p.topic_id, p.post_time, p.post_edit_time, p.post_visibility, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, ' .

+ /** @var string */

+ protected $phpEx;

+

+ public function __construct(\phpbb\config\config $config, \phpbb\user $user, $phpbb_root_path, $phpEx)

+ $this->phpEx = $phpEx;

+ *

+ * @param string $content is feed text content

+ * @param string $uid is bbcode_uid

+ * @param string $bitfield is bbcode bitfield

+ * @param int $options bbcode flag options

+ * @param int $forum_id is the forum id

+ * @param array $post_attachments is an array containing the attachments and their respective info

+ * @return string the html content to be printed for the feed

+ public function generate_content($content, $uid, $bitfield, $options, $forum_id, $post_attachments)

+ // Parse inline images to display with the feed

+ if (!empty($post_attachments))

+ {

+ $update_count = array();

+ parse_attachments($forum_id, $content, $post_attachments, $update_count);

+ $post_attachments = implode('<br />', $post_attachments);

+

+ // Convert attachments' relative path to absolute path

+ $post_attachments = str_replace($this->phpbb_root_path . 'download/file.' . $this->phpEx, $this->get_board_url() . '/download/file.' . $this->phpEx, $post_attachments);

+

+ $content .= $post_attachments;

+ }

+

+ $content = preg_replace('#<dd>(.*?)</dd>#','',$content);

+ p.post_id, p.post_time, p.post_edit_time, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment',

+ 'p.post_id, p.topic_id, p.post_time, p.post_edit_time, p.post_visibility, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, ' .

+ var $attachments = array();

+

+ function fetch_attachments()

+ {

+ $sql_array = array(

+ 'SELECT' => 'a.*',

+ 'FROM' => array(

+ ATTACHMENTS_TABLE => 'a'

+ ),

+ 'WHERE' => 'a.in_message = 0 ',

+ 'ORDER_BY' => 'a.filetime DESC, a.post_msg_id ASC',

+ );

+

+ if (isset($this->topic_id))

+ {

+ $sql_array['WHERE'] .= 'AND a.topic_id = ' . (int) $this->topic_id;

+ }

+ else if (isset($this->forum_id))

+ {

+ $sql_array['LEFT_JOIN'] = array(

+ array(

+ 'FROM' => array(TOPICS_TABLE => 't'),

+ 'ON' => 'a.topic_id = t.topic_id',

+ )

+ );

+ $sql_array['WHERE'] .= 'AND t.forum_id = ' . (int) $this->forum_id;

+ }

+

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

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

+

+ // Set attachments in feed items

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

+ {

+ $this->attachments[$row['post_msg_id']][] = $row;

+ }

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

+ }

+ 'SELECT' => 'p.post_id, p.post_time, p.post_edit_time, p.post_visibility, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment, ' .

+ p.post_id, p.post_time, p.post_edit_time, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment',

+ p.post_id, p.post_time, p.post_edit_time, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, p.post_attachment',

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

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

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

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

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

+ */

+ return $this->user->lang('FIELD_REQUIRED', $this->get_field_name($field_data['lang_name']));

+ 'lang_options' => $field_data['lang_options'],

+ return $this->user->lang('FIELD_REQUIRED', $this->get_field_name($field_data['lang_name']));

+ return $this->user->lang('FIELD_INVALID_DATE', $this->get_field_name($field_data['lang_name']));

+ return $this->user->lang('FIELD_INVALID_DATE', $this->get_field_name($field_data['lang_name']));

+ return $this->user->lang('FIELD_INVALID_VALUE', $this->get_field_name($field_data['lang_name']));

+ return $this->user->lang('FIELD_REQUIRED', $this->get_field_name($field_data['lang_name']));

+ 3 => array('TITLE' => $this->user->lang['DEFAULT_VALUE'], 'FIELD' => '<input type="number" name="field_default_value" value="' . $field_data['field_default_value'] . '" />'),

+ if ($field_data['field_default_value'] === '')

+ return $this->user->lang('FIELD_TOO_SMALL', (int) $field_data['field_minlen'], $this->get_field_name($field_data['lang_name']));

+ return $this->user->lang('FIELD_TOO_LARGE', (int) $field_data['field_maxlen'], $this->get_field_name($field_data['lang_name']));

+ if (($field_value === '' || $field_value === null) && !$field_data['field_show_novalue'])

+ * Get the name of template file for this type

+ *

+ * @return string Returns the name of the template file

+ */

+ public function get_template_filename();

+

+ /**

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

+

+ /**

+

+ /**

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

+ 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'] . '" />'),

+ $this->template->assign_block_vars($this->get_name_short(), array_change_key_case($profile_row, CASE_UPPER));

+ protected $validation_options = array(

+ 'CHARS_ANY' => '.*',

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

+ 'ALPHA_ONLY' => '[\w]+',

+ 'ALPHA_UNDERSCORE' => '[\w_]+',

+ 'ALPHA_SPACERS' => '[\w_\+\. \-\[\]]+',

+ );

+

+ public function validate_options($field_data)

+ foreach ($this->validation_options as $lang => $value)

+ return $this->user->lang('FIELD_REQUIRED', $this->get_field_name($field_data['lang_name']));

+ return $this->user->lang('FIELD_TOO_SHORT', (int) $field_data['field_minlen'], $this->get_field_name($field_data['lang_name']));

+ return $this->user->lang('FIELD_TOO_LONG', (int) $field_data['field_maxlen'], $this->get_field_name($field_data['lang_name']));

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

+ public function get_profile_contact_value($field_value, $field_data)

+ {

+ if (!$field_value && !$field_data['field_show_novalue'])

+ {

+ return null;

+ }

+

+ return $field_value;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+<?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_url extends type_string

+{

+ /**

+ * {@inheritDoc}

+ */

+ public function get_name_short()

+ {

+ return 'url';

+ }

+

+ /**

+ * {@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'] . '" />'),

+ );

+

+ return $options;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_default_option_values()

+ {

+ return array(

+ 'field_length' => 40,

+ 'field_minlen' => 0,

+ 'field_maxlen' => 200,

+ 'field_validation' => '',

+ 'field_novalue' => '',

+ 'field_default_value' => '',

+ );

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function validate_profile_field(&$field_value, $field_data)

+ {

+ $field_value = trim($field_value);

+

+ if ($field_value === '' && !$field_data['field_required'])

+ {

+ return false;

+ }

+

+ if (!preg_match('#^' . get_preg_expression('url') . '$#i', $field_value))

+ {

+ return $this->user->lang('FIELD_INVALID_URL', $this->get_field_name($field_data['lang_name']));

+ }

+

+ return false;

+ }

+}

+

+ // Handle +, - without preceeding whitespace character

+ $match = array('#(\S)\+#', '#(\S)-#');

+ $replace = array('$1 +', '$1 +');

+

+ $keywords = preg_replace($match, $replace, $keywords);

+ else

+ if ($len < $this->word_length['min'] || $len > $this->word_length['max'])

+ // Return true if all words are not common words

+ if (sizeof($exact_words) - sizeof($this->common_words) > 0)

+ // we can't search for negatives only

+ if (empty($this->must_contain_ids))

+ {

+ return false;

+ }

+

+ array('sql_attr_timestamp', 'post_time'),

+ array('sql_attr_timestamp', 'topic_last_post_time'),

+ array('sql_attr_string', 'post_subject'),

+ public function assign_block_vars_array($blockname, array $block_vars_array)

+ {

+ $this->context->assign_block_vars_array($blockname, $block_vars_array);

+

+ return $this;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ $s_num_rows = sizeof($str[$blocks[$blockcount]]);

+ $mod_block['S_NUM_ROWS'] = $s_num_rows;

+ $s_num_rows = sizeof($this->tpldata[$blockname]);

+ $mod_block['S_NUM_ROWS'] = $s_num_rows;

+ * Assign key variable pairs from an array to a whole specified block loop

+ *

+ * @param string $blockname Name of block to assign $block_vars_array to

+ * @param array $block_vars_array An array of hashes of variable name => value pairs

+ */

+ public function assign_block_vars_array($blockname, array $block_vars_array)

+ {

+ foreach ($block_vars_array as $vararray)

+ {

+ $this->assign_block_vars($blockname, $vararray);

+ }

+

+ return true;

+ }

+

+ /**

+ * Assign key variable pairs from an array to a whole specified block loop

+ * @param string $blockname Name of block to assign $block_vars_array to

+ * @param array $block_vars_array An array of hashes of variable name => value pairs

+ * @return \phpbb\template\template $this

+ */

+ public function assign_block_vars_array($blockname, array $block_vars_array);

+

+ /**

+ * Get all items from the tree

+ *

+ * @param bool $order_asc Order the items ascending by their left_id

+ * @return array Array of items (containing all columns from the item table)

+ * ID => Item data

+ */

+ public function get_all_tree_data($order_asc = true)

+ {

+ $rows = array();

+

+ $sql = 'SELECT *

+ FROM ' . $this->table_name . ' ' .

+ $this->get_sql_where('WHERE') . '

+ ORDER BY ' . $this->column_left_id . ' ' . ($order_asc ? 'ASC' : 'DESC');

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

+

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

+ {

+ $rows[(int) $row[$this->column_item_id]] = $row;

+ }

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

+

+ return $rows;

+ }

+

+ /**

+ if ($style_request && (!$config['override_user_style'] || $auth->acl_get('a_styles')) && !defined('ADMIN_START'))