+services:

+ profilefields.manager:

+ class: phpbb\profilefields\manager

+ arguments:

+ - @auth

+ - @dbal.conn

+ - @request

+ - @template

+ - @profilefields.type_collection

+ - @user

+ - %tables.profile_fields%

+ - %tables.profile_fields_language%

+ - %tables.profile_fields_data%

+

+ profilefields.lang_helper:

+ class: phpbb\profilefields\lang_helper

+ arguments:

+ - @dbal.conn

+ - %tables.profile_fields_options_language%

+

+ profilefields.type_collection:

+ class: phpbb\di\service_collection

+ arguments:

+ - @service_container

+ tags:

+ - { name: service_collection, tag: profilefield.type }

+

+ profilefields.type.bool:

+ class: phpbb\profilefields\type\type_bool

+ arguments:

+ - @profilefields.lang_helper

+ - @request

+ - @template

+ - @user

+ tags:

+ - { name: profilefield.type }

+

+ profilefields.type.date:

+ class: phpbb\profilefields\type\type_date

+ arguments:

+ - @request

+ - @template

+ - @user

+ tags:

+ - { name: profilefield.type }

+

+ profilefields.type.dropdown:

+ class: phpbb\profilefields\type\type_dropdown

+ arguments:

+ - @profilefields.lang_helper

+ - @request

+ - @template

+ - @user

+ tags:

+ - { name: profilefield.type }

+

+ profilefields.type.int:

+ class: phpbb\profilefields\type\type_int

+ arguments:

+ - @request

+ - @template

+ - @user

+ tags:

+ - { name: profilefield.type }

+

+ profilefields.type.string:

+ class: phpbb\profilefields\type\type_string

+ arguments:

+ - @request

+ - @template

+ - @user

+ tags:

+ - { name: profilefield.type }

+

+ profilefields.type.text:

+ class: phpbb\profilefields\type\type_text

+ arguments:

+ - @request

+ - @template

+ - @user

+ tags:

+ - { name: profilefield.type }

+ - { resource: profilefields.yml }

+ tables.profile_fields: %core.table_prefix%profile_fields

+ tables.profile_fields_data: %core.table_prefix%profile_fields_data

+ tables.profile_fields_options_language: %core.table_prefix%profile_fields_lang

+ tables.profile_fields_language: %core.table_prefix%profile_lang

+ protected $type_collection;

+ global $request, $phpbb_container;

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

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

+ foreach ($this->lang_defs['entry'] as $field_ident => $field_ary)

+ $this->lang_defs['diff'][$field_ident] = array_diff(array_values($this->lang_defs['iso']), $field_ary);

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

+ $field_type = request_var('field_type', '');

+ if (!isset($this->type_collection[$field_type]))

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

+ $field_row = array_merge($profile_field->get_default_option_values(), array(

+ $options = $profile_field->prepare_options_form($exclude, $visibility_ary);

+

+ $cp->vars['field_ident'] = ($action == 'create' && $step == 1) ? utf8_clean_string(request_var('field_ident', $field_row['field_ident'], true)) : request_var('field_ident', $field_row['field_ident']);

+ $cp->vars['lang_name'] = utf8_normalize_nfc(request_var('lang_name', $field_row['lang_name'], true));

+ $cp->vars['lang_explain'] = utf8_normalize_nfc(request_var('lang_explain', $field_row['lang_explain'], true));

+ $cp->vars['lang_default_value'] = utf8_normalize_nfc(request_var('lang_default_value', $field_row['lang_default_value'], true));

+

+ $field_data = $cp->vars;

+ $var = $profile_field->get_excluded_options($key, $action, $var, $field_data, 2);

+ $cp->vars = $field_data;

+ $field_data = $cp->vars;

+ $var = $profile_field->get_excluded_options($key, $action, $var, $field_data, 3);

+ $cp->vars = $field_data;

+ $error = $profile_field->validate_options_on_submit($error, $cp->vars);

+ $field_data = $cp->vars;

+ $var = $profile_field->prepare_hidden_fields($step, $key, $action, $field_data);

+ if ($var !== null)

+ $_new_key_ary[$key] = $profile_field->prepare_hidden_fields($step, $key, $action, $field_data);

+ $cp->vars = $field_data;

+ $template_vars = array(

+ 'FIELD_TYPE' => $profile_field->get_name(),

+ 'LANG_EXPLAIN' => $cp->vars['lang_explain'],

+ $field_data = $cp->vars;

+ $profile_field->display_options($template_vars, $field_data);

+ $cp->vars = $field_data;

+ // Build common create options

+ $template->assign_vars($template_vars);

+ $options = $profile_field->get_options($this->lang_defs['iso'][$config['default_lang']], $cp->vars);

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

+ 'FIELD_TYPE' => $profile_field->get_name(),

+ foreach ($this->type_collection as $key => $profile_field)

+ $s_select_type .= '<option value="' . $key . '">' . $profile_field->get_name() . '</option>';

+ 'S_TYPE_OPTIONS' => $s_select_type,

+ ));

+ global $user, $config, $db, $phpbb_container;

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

+ $options = $profile_field->get_language_options($cp->vars);

+ global $db, $config, $user, $phpbb_container;

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

+

+

+ $db_tools = $phpbb_container->get('dbal.tools');

+

+ list($sql_type, $null) = $db_tools->get_column_type($profile_field->get_database_column_type());

+ $profile_sql[] = $this->add_field_ident($field_ident, $sql_type);

+ $cp->vars = $profile_field->get_language_options_input($cp->vars);

+ 'field_type' => $field_type,

+ 'field_type' => $field_type,

+ function add_field_ident($field_ident, $sql_type)

+ $sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD `$field_ident` " . $sql_type;

+ $new_table_cols = $field_ident . ' ' . $sql_type . ',' . $new_table_cols;

+ $sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD $field_ident [$sql_type]";

+ $sql = 'ALTER TABLE [' . PROFILE_FIELDS_DATA_TABLE . "] ADD [$field_ident] " . $sql_type;

+ $sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD COLUMN \"$field_ident\" " . $sql_type;

+ $sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . ' ADD "' . strtoupper($field_ident) . '" ' . $sql_type;

+ $sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD $field_ident " . $sql_type;

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

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

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

+ global $phpbb_dispatcher, $phpbb_container;

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

+ global $user, $template, $auth, $db, $cache, $phpbb_container;

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

+ global $request, $phpbb_container;

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

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

+ field_type VARCHAR(100) CHARACTER SET NONE DEFAULT '' NOT NULL,

+ field_type VARCHAR(100) CHARACTER SET NONE DEFAULT '' NOT NULL,

+ [field_type] [varchar] (100) DEFAULT ('') NOT NULL ,

+ [field_type] [varchar] (100) DEFAULT ('') NOT NULL ,

+ field_type varbinary(100) DEFAULT '' NOT NULL,

+ field_type varbinary(100) DEFAULT '' NOT NULL,

+ field_type varchar(100) DEFAULT '' NOT NULL,

+ field_type varchar(100) DEFAULT '' NOT NULL,

+ field_type varchar2(100) DEFAULT '' ,

+ field_type varchar2(100) DEFAULT '' ,

+ field_type varchar(100) DEFAULT '' NOT NULL,

+ field_type varchar(100) DEFAULT '' NOT NULL,

+ field_type varchar(100) NOT NULL DEFAULT '',

+ field_type varchar(100) NOT NULL DEFAULT '',

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

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

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

+ }

+ }

+}

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

+ }

+

+ /**

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

+ }

+ }

+

+ /**

+ * Assign fields to template, used for viewprofile, viewtopic and memberlist (if load setting is enabled)

+ * This is directly connected to the user -> mode == grab is to grab the user specific fields, mode == show is for assigning the row to the template

+ */

+ public function generate_profile_fields_template($mode, $user_id = 0, $profile_row = false)

+ {

+ if ($mode == 'grab')

+ {

+ if (!is_array($user_id))

+ {

+ $user_id = array($user_id);

+ }

+

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

+ {

+ $this->build_cache();

+ }

+

+ if (!sizeof($user_id))

+ {

+ return array();

+ }

+

+ $sql = 'SELECT *

+ FROM ' . $this->fields_data_table . '

+ WHERE ' . $this->db->sql_in_set('user_id', array_map('intval', $user_id));

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

+

+ $user_ids = $user_id;

+

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

+ }

+ else if ($mode == 'show')

+ {

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

+ }

+

+ $tpl_fields['row'] += array(

+ 'PROFILE_' . strtoupper($ident) . '_VALUE' => $value,

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

+ );

+

+ $tpl_fields['blockrow'][] = array(

+ 'PROFILE_FIELD_VALUE' => $value,

+ '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_' . strtoupper($ident) => true,

+ );

+ }

+

+ return $tpl_fields;

+ }

+ else

+ {

+ trigger_error('Wrong mode for custom profile', E_USER_ERROR);

+ }

+ }

+

+ /**

+ * 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_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', $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'],

+ );

+

+ $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', $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', $field_data['lang_name']);

+ }

+

+ if (checkdate($month, $day, $year) === false)

+ {

+ return $this->user->lang('FIELD_INVALID_DATE', $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', $field_data['lang_name']);

+ }

+

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

+ {

+ return $this->user->lang('FIELD_REQUIRED', $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="post" 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) $row['field_minlen'], $row['lang_name']);

+ }

+ else if ($field_value > $field_data['field_maxlen'])

+ {

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

+ }

+

+ return false;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_profile_value($field_value, $field_data)

+ {

+ if ($field_value === '' && !$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 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);

+

+ /**

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

+}

+<?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" 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('string', 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

+{

+ /**

+ * Return possible validation options

+ */

+ function validate_options($field_data)

+ {

+ $validate_ary = array('CHARS_ANY' => '.*', 'NUMBERS_ONLY' => '[0-9]+', 'ALPHA_ONLY' => '[\w]+', 'ALPHA_SPACERS' => '[\w_\+\. \-\[\]]+');

+

+ $validate_options = '';

+ foreach ($validate_ary 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', $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) $row['field_minlen'], $row['lang_name']);

+ }

+ else if ($field_data['field_maxlen'] && utf8_strlen($field_value) > $field_data['field_maxlen'])

+ {

+ return $this->user->lang('FIELD_TOO_LONG', (int) $row['field_maxlen'], $row['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))

+ {

+ switch ($row['field_validation'])

+ {

+ case '[0-9]+':

+ return $this->user->lang('FIELD_INVALID_CHARS_NUMBERS_ONLY', $row['lang_name']);

+

+ case '[\w]+':

+ return $this->user->lang('FIELD_INVALID_CHARS_ALPHA_ONLY', $row['lang_name']);

+

+ case '[\w_\+\. \-\[\]]+':

+ return $this->user->lang('FIELD_INVALID_CHARS_SPACERS_ONLY', $row['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 prepare_options_form(&$exclude_options, &$visibility_options)

+ {

+ $exclude_options[1][] = 'lang_default_value';

+

+ return $this->request->variable('lang_options', '', true);

+ }

+}

+<?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_text 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 'text';

+ }

+

+ /**

+ * {@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="rows" size="5" value="' . $field_data['rows'] . '" /> ' . $this->user->lang['ROWS'] . '</dd><dd><input type="number" min="0" max="99999" name="columns" size="5" value="' . $field_data['columns'] . '" /> ' . $this->user->lang['COLUMNS'] . ' <input type="hidden" name="field_length" value="' . $field_data['field_length'] . '" />'),

+ 1 => array('TITLE' => $this->user->lang['MIN_FIELD_CHARS'], 'FIELD' => '<input type="number" min="0" max="9999999999" name="field_minlen" size="10" value="' . $field_data['field_minlen'] . '" />'),

+ 2 => array('TITLE' => $this->user->lang['MAX_FIELD_CHARS'], 'FIELD' => '<input type="number" min="0" max="9999999999" name="field_maxlen" size="10" 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' => '5|80',

+ 'field_minlen' => 0,

+ 'field_maxlen' => 1000,

+ '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('text', $field_value, $field_data);

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function generate_field($profile_row, $preview_options = false)

+ {

+ $field_length = explode('|', $profile_row['field_length']);

+ $profile_row['field_rows'] = $field_length[0];

+ $profile_row['field_cols'] = $field_length[1];

+ $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('text', array_change_key_case($profile_row, CASE_UPPER));

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_database_column_type()

+ {

+ return 'MTEXT';

+ }

+

+ /**

+ * {@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'] = 'text';

+ }

+

+ return $options;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_excluded_options($key, $action, $current_value, &$field_data, $step)

+ {

+ if ($step == 2 && $key == 'field_length')

+ {

+ if ($this->request->is_set('rows'))

+ {

+ $field_data['rows'] = $this->request->variable('rows', 0);

+ $field_data['columns'] = $this->request->variable('columns', 0);

+ $current_value = $field_data['rows'] . '|' . $field_data['columns'];

+ }

+ else

+ {

+ $row_col = explode('|', $current_value);

+ $field_data['rows'] = $row_col[0];

+ $field_data['columns'] = $row_col[1];

+ }

+

+ 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_length' && $this->request->is_set('rows'))

+ {

+ $field_data['rows'] = $this->request->variable('rows', 0);

+ $field_data['columns'] = $this->request->variable('columns', 0);

+ return $field_data['rows'] . '|' . $field_data['columns'];

+ }

+

+ return parent::prepare_hidden_fields($step, $key, $action, $field_data);

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function display_options(&$template_vars, &$field_data)

+ {

+ $template_vars = array_merge($template_vars, array(

+ 'S_TEXT' => true,

+ 'L_DEFAULT_VALUE_EXPLAIN' => $this->user->lang['TEXT_DEFAULT_VALUE_EXPLAIN'],

+ 'LANG_DEFAULT_VALUE' => $field_data['lang_default_value'],

+ ));

+ }

+}

+<!-- BEGIN bool -->

+<!-- IF bool.FIELD_LENGTH eq 1 -->

+ <!-- BEGIN options --><label for="{bool.FIELD_IDENT}_{bool.options.OPTION_ID}"><input type="radio" class="radio" name="{bool.FIELD_IDENT}" id="{bool.FIELD_IDENT}_{bool.options.OPTION_ID}" value="{bool.options.OPTION_ID}"{bool.options.CHECKED} /> {bool.options.VALUE}</label> <!-- END options -->

+<!-- ELSE -->

+ <input type="checkbox" class="radio" name="{bool.FIELD_IDENT}" id="{bool.FIELD_IDENT}"<!-- IF bool.FIELD_VALUE --> checked="checked"<!-- ENDIF --> />

+<!-- ENDIF -->

+<!-- END bool -->

+<!-- BEGIN date -->

+<label for="{date.FIELD_IDENT}_day">{L_DAY}{L_COLON} <select name="{date.FIELD_IDENT}_day" id="{date.FIELD_IDENT}_day">{date.S_DAY_OPTIONS}</select></label>

+<label for="{date.FIELD_IDENT}_month">{L_MONTH}{L_COLON} <select name="{date.FIELD_IDENT}_month" id="{date.FIELD_IDENT}_month">{date.S_MONTH_OPTIONS}</select></label>

+<label for="{date.FIELD_IDENT}_year">{L_YEAR}{L_COLON} <select name="{date.FIELD_IDENT}_year" id="{date.FIELD_IDENT}_year">{date.S_YEAR_OPTIONS}</select></label>

+<!-- END date -->

+<!-- BEGIN dropdown -->

+<select name="{dropdown.FIELD_IDENT}" id="{dropdown.FIELD_IDENT}">

+ <!-- BEGIN options --><option value="{dropdown.options.OPTION_ID}"{dropdown.options.SELECTED}>{dropdown.options.VALUE}</option><!-- END options -->

+</select>

+<!-- END dropdown -->

+<!-- BEGIN int -->

+<input type="number" min="{int.FIELD_MINLEN}" max="{int.FIELD_MAXLEN}" class="inputbox autowidth" name="{int.FIELD_IDENT}" id="{int.FIELD_IDENT}" size="{int.FIELD_LENGTH}" value="{int.FIELD_VALUE}" />

+<!-- END int -->

+<!-- BEGIN string -->

+<input type="text" class="inputbox autowidth" name="{string.FIELD_IDENT}" id="{string.FIELD_IDENT}" size="{string.FIELD_LENGTH}" maxlength="{string.FIELD_MAXLEN}" value="{string.FIELD_VALUE}" />

+<!-- END string -->

+<!-- BEGIN text -->

+<textarea name="{text.FIELD_IDENT}" id="{text.FIELD_IDENT}" rows="{text.FIELD_ROWS}" cols="{text.FIELD_COLS}" class="inputbox">{text.FIELD_VALUE}</textarea>

+<!-- END text -->

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