<fieldset>

<legend>{L_VISIBILITY_OPTION}</legend>

<dl>

</dl>

<dl>

<dt><label for="field_show_on_reg">{L_DISPLAY_AT_REGISTER}:</label><br /><span>{L_DISPLAY_AT_REGISTER_EXPLAIN}</span></dt>

</dl>

<dl>

<dt><label for="field_required">{L_REQUIRED_FIELD}:</label><br /><span>{L_REQUIRED_FIELD_EXPLAIN}</span></dt>

</dl>

<dl>

<dt><label for="field_hide">{L_HIDE_PROFILE_FIELD}:</label><br /><span>{L_HIDE_PROFILE_FIELD_EXPLAIN}</span></dt>

</dl>

</fieldset>

'field_validation' => array('VCHAR_UNI:20', ''),

'field_required' => array('BOOL', 0),

'field_show_on_reg' => array('BOOL', 0),

'field_hide' => array('BOOL', 0),

'field_no_view' => array('BOOL', 0),

'field_active' => array('BOOL', 0),

<?php

*

* @package phpBB3

* @version $Id$

*

* This file creates SQL statements to upgrade phpBB on MySQL 3.x/4.0.x to 4.1.x/5.x

*

$line = "ALTER TABLE {$table_name} $newline";

// Table specific so we don't get overlap

// Write columns one by one...

foreach ($table_data['COLUMNS'] as $column_name => $column_data)

'field_validation' => array('VCHAR_UNI:20', ''),

'field_required' => array('BOOL', 0),

'field_show_on_reg' => array('BOOL', 0),

'field_hide' => array('BOOL', 0),

'field_no_view' => array('BOOL', 0),

'field_active' => array('BOOL', 0),

<li>[Fix] Only display special ranks to guests; no longer display normal ranks for guests (Bug #36735)</li>

<li>[Fix] Properly treat punctuation marks after local urls (Bug #37055)</li>

<li>[Fix] Make searching for members by YIM address work in prosilver</li>

<li>[Change] Alllow applications to set custom module inclusion path (idea by HoL)</li>

<li>[Change] Handle checking for duplicate usernames in chunks (Bug #17285 - Patch by A_Jelly_Doughnut)</li>

</ul>

<a name="v302"></a><h3>1.ii. Changes since 3.0.2</h3>

FROM ' . PROFILE_LANG_TABLE . '

ORDER BY lang_id';

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

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

{

// Which languages are available for each item

'field_id' => $field_id,

)));

}

break;

case 'activate':

{

trigger_error($user->lang['NO_FIELD_ID'] . adm_back_link($this->u_action), E_USER_WARNING);

}

$sql = 'SELECT lang_id

FROM ' . LANG_TABLE . "

WHERE lang_iso = '" . $db->sql_escape($config['default_lang']) . "'";

{

trigger_error($user->lang['NO_FIELD_ID'] . adm_back_link($this->u_action), E_USER_WARNING);

}

$sql = 'UPDATE ' . PROFILE_FIELDS_TABLE . "

SET field_active = 0

WHERE field_id = $field_id";

case 'create':

case 'edit':

$field_id = request_var('field_id', 0);

$step = request_var('step', 1);

{

// We are adding a new field, define basic params

$lang_options = $field_row = array();

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

if (!$field_type)

{

trigger_error($user->lang['NO_FIELD_TYPE'] . adm_back_link($this->u_action), E_USER_WARNING);

}

$field_row = array_merge($default_values[$field_type], array(

'field_required' => 0,

'field_hide' => 0,

'field_no_view' => 0,

'field_show_on_reg' => 0,

'lang_name' => utf8_normalize_nfc(request_var('field_ident', '', true)),

// $exclude contains the data we gather in each step

$exclude = array(

2 => array('field_length', 'field_maxlen', 'field_minlen', 'field_validation', 'field_novalue', 'field_default_value'),

3 => array('l_lang_name', 'l_lang_explain', 'l_lang_default_value', 'l_lang_options')

);

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

{

}

// A boolean field expects an array as the lang options

if ($field_type == FIELD_BOOL)

else if ($field_type == FIELD_DATE && $key == 'field_default_value')

{

$always_now = request_var('always_now', -1);

if ($always_now == 1 || ($always_now === -1 && $var == 'now'))

{

$now = getdate();

{

list($cp->vars['field_default_value_day'], $cp->vars['field_default_value_month'], $cp->vars['field_default_value_year']) = explode('-', $var);

}

}

/* else if ($field_type == FIELD_BOOL && $key == 'field_default_value')

{

}

$db->sql_freeresult($result);

$sql = 'SELECT lang_id, lang_name, lang_explain, lang_default_value

FROM ' . PROFILE_LANG_TABLE . '

WHERE lang_id <> ' . $this->edit_lang_id . "

}

$db->sql_freeresult($result);

}

foreach ($exclude[3] as $key)

{

$cp->vars[$key] = utf8_normalize_nfc(request_var($key, array(0 => ''), true));

{

$cp->vars[$key][$lang_id] = explode("\n", $options);

}

}

}

'L_TITLE' => $user->lang['STEP_' . $step . '_TITLE_' . strtoupper($action)],

'L_EXPLAIN' => $user->lang['STEP_' . $step . '_EXPLAIN_' . strtoupper($action)],

'U_ACTION' => $this->u_action . "&amp;action=$action&amp;step=$step",

'U_BACK' => $this->u_action)

);

{

// Create basic options - only small differences between field types

case 1:

// Build common create options

$template->assign_vars(array(

'S_STEP_ONE' => true,

'S_FIELD_REQUIRED' => ($cp->vars['field_required']) ? true : false,

'S_SHOW_ON_REG' => ($cp->vars['field_show_on_reg']) ? true : false,

'S_FIELD_HIDE' => ($cp->vars['field_hide']) ? true : false,

'S_FIELD_NO_VIEW' => ($cp->vars['field_no_view']) ? true : false,

'L_LANG_SPECIFIC' => sprintf($user->lang['LANG_SPECIFIC_OPTIONS'], $config['default_lang']),

'LANG_DEFAULT_VALUE' => $cp->vars['lang_default_value'])

);

}

if ($field_type == FIELD_BOOL || $field_type == FIELD_DROPDOWN)

{

// Initialize these array elements if we are creating a new field

'SECOND_LANG_OPTION' => ($field_type == FIELD_BOOL) ? $cp->vars['lang_options'][1] : '')

);

}

break;

case 2:

$template->assign_vars(array(

'S_STEP_TWO' => true,

'L_NEXT_STEP' => (sizeof($this->lang_defs['iso']) == 1) ? $user->lang['SAVE'] : $user->lang['PROFILE_LANG_OPTIONS'])

);

}

}

break;

}

break;

}

$sql = 'SELECT *

FROM ' . PROFILE_FIELDS_TABLE . '

ORDER BY field_order';

$languages[$row['lang_id']] = $row['lang_iso'];

}

$db->sql_freeresult($result);

$options = array();

$options['lang_name'] = 'string';

if ($cp->vars['lang_explain'])

{

$options['lang_explain'] = 'text';

}

switch ($field_type)

{

case FIELD_BOOL:

case FIELD_DROPDOWN:

$options['lang_options'] = 'optionfield';

break;

case FIELD_TEXT:

case FIELD_STRING:

if ($cp->vars['lang_default_value'])

}

break;

}

$lang_options = array();

foreach ($options as $field => $field_type)

if ($field == 'lang_options')

{

$var = (!isset($cp->vars['l_lang_options'][$lang_id]) || !is_array($cp->vars['l_lang_options'][$lang_id])) ? $cp->vars['lang_options'] : $cp->vars['l_lang_options'][$lang_id];

switch ($field_type)

{

case 'two_options':

);

break;

}

if (isset($user->lang['CP_' . strtoupper($field) . '_EXPLAIN']))

{

$lang_options[$lang_id]['fields'][$field]['EXPLAIN'] = $user->lang['CP_' . strtoupper($field) . '_EXPLAIN'];

'TITLE' => $user->lang['CP_' . strtoupper($field)],

'FIELD' => ($field_type == 'string') ? '<dd><input class="medium" type="text" name="l_' . $field . '[' . $lang_id . ']" value="' . ((isset($value[$lang_id])) ? $value[$lang_id] : $var) . '" /></dd>' : '<dd><textarea name="l_' . $field . '[' . $lang_id . ']" rows="3" cols="80">' . ((isset($value[$lang_id])) ? $value[$lang_id] : $var) . '</textarea></dd>'

);

if (isset($user->lang['CP_' . strtoupper($field) . '_EXPLAIN']))

{

$lang_options[$lang_id]['fields'][$field]['EXPLAIN'] = $user->lang['CP_' . strtoupper($field) . '_EXPLAIN'];

'field_required' => $cp->vars['field_required'],

'field_show_on_reg' => $cp->vars['field_show_on_reg'],

'field_hide' => $cp->vars['field_hide'],

'field_no_view' => $cp->vars['field_no_view']

);

WHERE field_id = $field_id";

$db->sql_query($sql);

}

if ($action == 'create')

{

$field_ident = 'pf_' . $field_ident;

{

$sql_ary['field_id'] = $field_id;

$sql_ary['lang_id'] = $default_lang_id;

$profile_sql[] = 'INSERT INTO ' . PROFILE_LANG_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);

}

else

AND lang_id = " . (int) $default_lang_id;

$db->sql_query($sql);

}

foreach ($cp->vars['lang_options'] as $option_id => $value)

{

$sql_ary = array(

$lang_id = $sql['lang_id'];

$option_id = $sql['option_id'];

unset($sql['lang_id'], $sql['field_id'], $sql['option_id']);

$this->update_insert(PROFILE_FIELDS_LANG_TABLE, $sql, array(

'lang_id' => $lang_id,

'field_id' => $field_id,

$db->sql_query($sql);

}

}

$db->sql_transaction('commit');

if ($action == 'edit')

if (!$row)

{

$sql_ary = array_merge($where_fields, $sql_ary);

if (sizeof($sql_ary))

{

$db->sql_query("INSERT INTO $table " . $db->sql_build_array('INSERT', $sql_ary));

case FIELD_BOOL:

$sql .= 'TINYINT(2) ';

break;

case FIELD_DROPDOWN:

$sql .= 'MEDIUMINT(8) ';

break;

}

}

{

case 'register':

// If the field is required we show it on the registration page and do not show hidden fields

break;

case 'profile':

// Show hidden fields to moderators/admins

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

{

}

break;

{

case FIELD_DATE:

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

return 'FIELD_TOO_LARGE';

}

break;

case FIELD_DROPDOWN:

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

{

return 'FIELD_REQUIRED';

}

break;

case FIELD_STRING:

case FIELD_TEXT:

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

global $db, $user, $auth;

$this->profile_cache = array();

// Display hidden/no_view fields for admin/moderator

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

FROM ' . PROFILE_LANG_TABLE . ' l, ' . PROFILE_FIELDS_TABLE . ' f

if ($preview)

{

$lang_options = (!is_array($this->vars['lang_options'])) ? explode("\n", $this->vars['lang_options']) : $this->vars['lang_options'];

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

{

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

{

case 'register':

// If the field is required we show it on the registration page and do not show hidden fields

break;

case 'profile':

// Show hidden fields to moderators/admins

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

{

}

break;

case 'FIELD_TOO_SMALL':

$error = sprintf($user->lang[$cp_result], $row['lang_name'], $row['field_minlen']);

break;

case 'FIELD_TOO_LONG':

case 'FIELD_TOO_LARGE':

$error = sprintf($user->lang[$cp_result], $row['lang_name'], $row['field_maxlen']);

break;

case 'FIELD_INVALID_CHARS':

switch ($row['field_validation'])

{

}

break;

}

if ($error != '')

{

$cp_error[] = $error;

'S_PROFILE_' . strtoupper($ident) => true

);

}

return $tpl_fields;

}

else

else

{

$value = (isset($_REQUEST[$profile_row['field_ident']])) ? request_var($profile_row['field_ident'], $default_value, true) : ((!isset($user->profile_fields[$user_ident]) || $preview) ? $default_value : $user->profile_fields[$user_ident]);

if (gettype($value) == 'string')

{

$value = utf8_normalize_nfc($value);

$profile_row['s_year_options'] .= '<option value="' . $i . '"' . (($i == $year) ? ' selected="selected"' : '') . ">$i</option>";

}

unset($now);

$profile_row['field_value'] = 0;

$template->assign_block_vars($this->profile_types[$profile_row['field_type']], array_change_key_case($profile_row, CASE_UPPER));

}

$cp_data['pf_' . $row['field_ident']] = (in_array($row['field_type'], array(FIELD_TEXT, FIELD_STRING))) ? $row['lang_default_value'] : $row['field_default_value'];

}

$db->sql_freeresult($result);

return $cp_data;

}

{

global $phpbb_root_path, $phpEx;

global $config;

$var_name = 'pf_' . $profile_row['field_ident'];

switch ($profile_row['field_type'])

{

case FIELD_DATE:

$month = request_var($var_name . '_month', 0);

$year = request_var($var_name . '_year', 0);

}

$var = sprintf('%2d-%2d-%4d', $day, $month, $year);

break;

return $validate_options;

}

/**

* Get string options for second step in ACP

*/

}

}

// No changes from 3.0.3-RC1 to 3.0.3

'3.0.3-RC1' => array(),

);

// Determine mapping database type

$no_updates = false;

break;

}

}

return trim($text);

}

field_validation VARCHAR(20) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

field_required INTEGER DEFAULT 0 NOT NULL,

field_show_on_reg INTEGER DEFAULT 0 NOT NULL,

field_hide INTEGER DEFAULT 0 NOT NULL,

field_no_view INTEGER DEFAULT 0 NOT NULL,

field_active INTEGER DEFAULT 0 NOT NULL,

[field_validation] [varchar] (20) DEFAULT ('') NOT NULL ,

[field_required] [int] DEFAULT (0) NOT NULL ,

[field_show_on_reg] [int] DEFAULT (0) NOT NULL ,

[field_hide] [int] DEFAULT (0) NOT NULL ,

[field_no_view] [int] DEFAULT (0) NOT NULL ,

[field_active] [int] DEFAULT (0) NOT NULL ,

field_validation varbinary(60) DEFAULT '' NOT NULL,

field_required tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_show_on_reg tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_hide tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_no_view tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_validation varchar(20) DEFAULT '' NOT NULL,

field_required tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_show_on_reg tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_hide tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_no_view tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_validation varchar2(60) DEFAULT '' ,

field_required number(1) DEFAULT '0' NOT NULL,

field_show_on_reg number(1) DEFAULT '0' NOT NULL,

field_hide number(1) DEFAULT '0' NOT NULL,

field_no_view number(1) DEFAULT '0' NOT NULL,

field_active number(1) DEFAULT '0' NOT NULL,

field_validation varchar(20) DEFAULT '' NOT NULL,

field_required INT2 DEFAULT '0' NOT NULL CHECK (field_required >= 0),

field_show_on_reg INT2 DEFAULT '0' NOT NULL CHECK (field_show_on_reg >= 0),

field_hide INT2 DEFAULT '0' NOT NULL CHECK (field_hide >= 0),

field_no_view INT2 DEFAULT '0' NOT NULL CHECK (field_no_view >= 0),

field_active INT2 DEFAULT '0' NOT NULL CHECK (field_active >= 0),

field_validation varchar(20) NOT NULL DEFAULT '',

field_required INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_show_on_reg INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_hide INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_no_view INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_active INTEGER UNSIGNED NOT NULL DEFAULT '0',

'DELETE_PROFILE_FIELD_CONFIRM' => 'Are you sure you want to delete this profile field?',

'DISPLAY_AT_PROFILE' => 'Display in user control panel',

'DISPLAY_AT_PROFILE_EXPLAIN' => 'The user is able to change this profile field within the user control panel.',

'DISPLAY_PROFILE_FIELD' => 'Display profile field',

'DROPDOWN_ENTRIES_EXPLAIN' => 'Enter your options now, every option in one line.',

'EDIT_DROPDOWN_LANG_EXPLAIN' => 'Please note that you are able to change your options text and also able to add new options to the end. It is not advised to add new options between existing options - this could result in wrong options assigned to your users. This can also happen if you remove options in-between. Removing options from the end result in users having assigned this item now reverting back to the default one.',

'FIRST_OPTION' => 'First option',

'HIDE_PROFILE_FIELD' => 'Hide profile field',

'INVALID_CHARS_FIELD_IDENT' => 'Field identification can only contain lowercase a-z and _',

'INVALID_FIELD_IDENT_LEN' => 'Field identification can only be 17 characters long',

'RADIO_BUTTONS' => 'Radio buttons',

'REMOVED_PROFILE_FIELD' => 'Successfully removed profile field.',

'REQUIRED_FIELD' => 'Required field',

'ROWS' => 'Rows',

'SAVE' => 'Save',

'USER_FIELD_NAME' => 'Field name/title presented to the user',

));