<dd><input type="text" id="location" name="location" value="{LOCATION}" /></dd>

</dl>

<dl>

<dt><label for="birthday">{L_BIRTHDAY}{L_COLON}</label><br /><span>{L_BIRTHDAY_EXPLAIN}</span></dt>

<dd>{L_DAY}{L_COLON} <select id="birthday" name="bday_day">{S_BIRTHDAY_DAY_OPTIONS}</select> {L_MONTH}{L_COLON} <select name="bday_month">{S_BIRTHDAY_MONTH_OPTIONS}</select> {L_YEAR}{L_COLON} <select name="bday_year">{S_BIRTHDAY_YEAR_OPTIONS}</select></dd>

</dl>

$email = "nobody@localhost";

$icq = "12345678";

$website = "http://www.phpbb.com";

$location = "phpBB world hq";

$signature = "$username: phpBB tester.";

$signature_bbcode_uid = "";

$avatar_filename = "";

}

$sql .= "1, '')";

'jabber' => utf8_normalize_nfc(request_var('jabber', $user_row['user_jabber'], true)),

'website' => request_var('website', $user_row['user_website']),

'location' => utf8_normalize_nfc(request_var('location', $user_row['user_from'], true)),

'bday_day' => 0,

'bday_month' => 0,

'bday_year' => 0,

array('string', true, 12, 255),

array('match', true, '#^http[s]?://(.*?\.)*?[a-z0-9\-]+\.[a-z]{2,4}#i')),

'location' => array('string', true, 2, 100),

'bday_day' => array('num', true, 1, 31),

'bday_month' => array('num', true, 1, 12),

'bday_year' => array('num', true, 1901, gmdate('Y', time())),

'user_jabber' => $data['jabber'],

'user_website' => $data['website'],

'user_from' => $data['location'],

'user_birthday' => $data['user_birthday'],

);

'JABBER' => $data['jabber'],

'WEBSITE' => $data['website'],

'LOCATION' => $data['location'],

'S_BIRTHDAY_DAY_OPTIONS' => $s_birthday_day_options,

'S_BIRTHDAY_MONTH_OPTIONS' => $s_birthday_month_options,

$schema_data['phpbb_profile_fields_data'] = array(

'COLUMNS' => array(

'user_id' => array('UINT', 0),

),

'PRIMARY_KEY' => 'user_id',

);

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

'user_jabber' => array('VCHAR_UNI', ''),

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

'user_actkey' => array('VCHAR:32', ''),

'user_newpasswd' => array('VCHAR_UNI:40', ''),

'user_form_salt' => array('VCHAR_UNI:32', ''),

'user_lastpage' => '',

'user_posts' => 0,

'user_colour' => '',

'user_avatar' => '',

'user_avatar_type' => '',

'user_avatar_width' => 0,

'POSTS_DAY' => $user->lang('POST_DAY', $posts_per_day),

'POSTS_PCT' => $user->lang('POST_PCT', $percentage),

// 'S_GROUP_OPTIONS' => $group_options,

'U_SEARCH_USER' => ($auth->acl_get('u_search')) ? append_sid("{$phpbb_root_path}search.$phpEx", 'author_id=' . $user->data['user_id'] . '&amp;sr=posts') : '',

'jabber' => utf8_normalize_nfc(request_var('jabber', $user->data['user_jabber'], true)),

'website' => request_var('website', $user->data['user_website']),

'location' => utf8_normalize_nfc(request_var('location', $user->data['user_from'], true)),

);

if ($config['allow_birthdays'])

array('string', true, 12, 255),

array('match', true, '#^http[s]?://(.*?\.)*?[a-z0-9\-]+\.[a-z]{2,4}#i')),

'location' => array('string', true, 2, 100),

);

if ($config['allow_birthdays'])

'user_jabber' => $data['jabber'],

'user_website' => $data['website'],

'user_from' => $data['location'],

'user_notify_type' => $data['notify'],

);

'JABBER' => $data['jabber'],

'WEBSITE' => $data['website'],

'LOCATION' => $data['location'],

));

// Get additional profile fields and assign them to the template block var 'profile_fields'

array('user_inactive_reason', '', 'phpbb_inactive_reason'),

array('user_inactive_time', '', 'phpbb_inactive_time'),

array('user_website', 'users.user_website', 'validate_website'),

array('user_jabber', '', ''),

array('user_msnm', 'users.user_msnm', array('function1' => 'phpbb_set_encoding')),

'where' => 'users.user_id <> -1',

),

),

);

}

$this->error('Unable to access the language directory', __LINE__, __FILE__);

}

while (($file = readdir($dir)) !== false)

{

$path = $phpbb_root_path . 'language/' . $file;

$db->sql_query('INSERT INTO ' . LANG_TABLE . ' ' . $db->sql_build_array('INSERT', $lang_pack));

if ($db->sql_error_triggered)

{

$error = $db->sql_error($db->sql_error_sql);

}

}

closedir($dir);

}

/**

# Table: 'phpbb_profile_fields_data'

CREATE TABLE phpbb_profile_fields_data (

);;

ALTER TABLE phpbb_profile_fields_data ADD PRIMARY KEY (user_id);;

user_msnm VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

user_jabber VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

user_website VARCHAR(200) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

user_actkey VARCHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL,

user_newpasswd VARCHAR(40) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

user_form_salt VARCHAR(32) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

Table: 'phpbb_profile_fields_data'

*/

CREATE TABLE [phpbb_profile_fields_data] (

) ON [PRIMARY]

GO

[user_msnm] [varchar] (255) DEFAULT ('') NOT NULL ,

[user_jabber] [varchar] (255) DEFAULT ('') NOT NULL ,

[user_website] [varchar] (200) DEFAULT ('') NOT NULL ,

[user_actkey] [varchar] (32) DEFAULT ('') NOT NULL ,

[user_newpasswd] [varchar] (40) DEFAULT ('') NOT NULL ,

[user_form_salt] [varchar] (32) DEFAULT ('') NOT NULL ,

# Table: 'phpbb_profile_fields_data'

CREATE TABLE phpbb_profile_fields_data (

user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

PRIMARY KEY (user_id)

);

user_msnm blob NOT NULL,

user_jabber blob NOT NULL,

user_website blob NOT NULL,

user_actkey varbinary(32) DEFAULT '' NOT NULL,

user_newpasswd varbinary(120) DEFAULT '' NOT NULL,

user_form_salt varbinary(96) DEFAULT '' NOT NULL,

# Table: 'phpbb_profile_fields_data'

CREATE TABLE phpbb_profile_fields_data (

user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

PRIMARY KEY (user_id)

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

user_msnm varchar(255) DEFAULT '' NOT NULL,

user_jabber varchar(255) DEFAULT '' NOT NULL,

user_website varchar(200) DEFAULT '' NOT NULL,

user_actkey varchar(32) DEFAULT '' NOT NULL,

user_newpasswd varchar(40) DEFAULT '' NOT NULL,

user_form_salt varchar(32) DEFAULT '' NOT NULL,

*/

CREATE TABLE phpbb_profile_fields_data (

user_id number(8) DEFAULT '0' NOT NULL,

CONSTRAINT pk_phpbb_profile_fields_data PRIMARY KEY (user_id)

)

/

user_msnm varchar2(765) DEFAULT '' ,

user_jabber varchar2(765) DEFAULT '' ,

user_website varchar2(600) DEFAULT '' ,

user_actkey varchar2(32) DEFAULT '' ,

user_newpasswd varchar2(120) DEFAULT '' ,

user_form_salt varchar2(96) DEFAULT '' ,

*/

CREATE TABLE phpbb_profile_fields_data (

user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),

PRIMARY KEY (user_id)

);

user_msnm varchar(255) DEFAULT '' NOT NULL,

user_jabber varchar(255) DEFAULT '' NOT NULL,

user_website varchar(200) DEFAULT '' NOT NULL,

user_actkey varchar(32) DEFAULT '' NOT NULL,

user_newpasswd varchar(40) DEFAULT '' NOT NULL,

user_form_salt varchar(32) DEFAULT '' NOT NULL,

INSERT INTO phpbb_forums (forum_name, forum_desc, left_id, right_id, parent_id, forum_type, forum_posts_approved, forum_posts_unapproved, forum_posts_softdeleted, forum_topics_approved, forum_topics_unapproved, forum_topics_softdeleted, forum_last_post_id, forum_last_poster_id, forum_last_poster_name, forum_last_poster_colour, forum_last_post_subject, forum_last_post_time, forum_link, forum_password, forum_image, forum_rules, forum_rules_link, forum_rules_uid, forum_desc_uid, prune_days, prune_viewed, forum_parents, forum_flags) VALUES ('{L_FORUMS_TEST_FORUM_TITLE}', '{L_FORUMS_TEST_FORUM_DESC}', 2, 3, 1, 1, 1, 0, 0, 1, 0, 0, 1, 2, 'Admin', 'AA0000', '{L_TOPICS_TOPIC_TITLE}', 972086460, '', '', '', '', '', '', '', 0, 0, '', 48);

# -- Users / Anonymous user

# -- username: Admin password: admin (change this or remove it once everything is working!)

# -- Groups

INSERT INTO phpbb_groups (group_name, group_type, group_founder_manage, group_colour, group_legend, group_avatar, group_desc, group_desc_uid, group_max_recipients) VALUES ('GUESTS', 3, 0, '', 0, '', '', '', 5);

INSERT INTO phpbb_extensions (group_id, extension) VALUES (9, 'ogg');

INSERT INTO phpbb_extensions (group_id, extension) VALUES (9, 'ogm');

# User Notification Options (for first user)

INSERT INTO phpbb_user_notifications (item_type, item_id, user_id, method) VALUES('post', 0, 2, '');

INSERT INTO phpbb_user_notifications (item_type, item_id, user_id, method) VALUES('post', 0, 2, 'email');

# Table: 'phpbb_profile_fields_data'

CREATE TABLE phpbb_profile_fields_data (

user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

PRIMARY KEY (user_id)

);

user_msnm varchar(255) NOT NULL DEFAULT '',

user_jabber varchar(255) NOT NULL DEFAULT '',

user_website varchar(200) NOT NULL DEFAULT '',

user_actkey varchar(32) NOT NULL DEFAULT '',

user_newpasswd varchar(40) NOT NULL DEFAULT '',

user_form_salt varchar(32) NOT NULL DEFAULT '',

'TOO_LONG_CONFIRM_CODE' => 'The confirm code you entered is too long.',

'TOO_LONG_DATEFORMAT' => 'The date format you entered is too long.',

'TOO_LONG_ICQ' => 'The ICQ number you entered is too long.',

'TOO_LONG_JABBER' => 'The Jabber account name you entered is too long.',

'TOO_LONG_LOCATION' => 'The location you entered is too long.',

'TOO_LONG_MSN' => 'The WLM name you entered is too long.',

'TOO_LONG_NEW_PASSWORD' => 'The password you entered is too long.',

'TOO_LONG_PASSWORD_CONFIRM' => 'The password confirmation you entered is too long.',

'TOO_LONG_USER_PASSWORD' => 'The password you entered is too long.',

'TOO_LONG_USERNAME' => 'The username you entered is too long.',

'TOO_SHORT_CONFIRM_CODE' => 'The confirm code you entered is too short.',

'TOO_SHORT_DATEFORMAT' => 'The date format you entered is too short.',

'TOO_SHORT_ICQ' => 'The ICQ number you entered is too short.',

'TOO_SHORT_JABBER' => 'The Jabber account name you entered is too short.',

'TOO_SHORT_LOCATION' => 'The location you entered is too short.',

'TOO_SHORT_MSN' => 'The WLM name you entered is too short.',

'TOO_SHORT_NEW_PASSWORD' => 'The password you entered is too short.',

'TOO_SHORT_PASSWORD_CONFIRM' => 'The password confirmation you entered is too short.',

'TOO_SHORT_USER_PASSWORD' => 'The password you entered is too short.',

'TOO_SHORT_USERNAME' => 'The username you entered is too short.',

'POSTS_DAY' => $user->lang('POST_DAY', $posts_per_day),

'POSTS_PCT' => $user->lang('POST_PCT', $percentage),

'SIGNATURE' => $member['user_sig'],

'POSTS_IN_QUEUE'=> $member['posts_in_queue'],

/**

* {@inheritDoc}

*/

public function get_language_options_input($field_data)

{

$field_data['l_lang_name'] = $this->request->variable('l_lang_name', array(0 => ''), true);

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

{

}

return false;

if ((!$day || !$month || !$year) && $field_data['field_required'])

{

}

if ($day < 0 || $day > 31 || $month < 0 || $month > 12 || ($year < 1901 && $year > 0) || $year > gmdate('Y', time()) + 50)

{

}

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

{

}

return false;

if (!$this->lang_helper->is_set($field_data['field_id'], $field_data['lang_id'], $field_value))

{

}

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

{

}

return false;

if ($field_value < $field_data['field_minlen'])

{

}

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

{

}

return false;

public function get_service_name();

/**

* Get dropdown options for second step in ACP

*

* @param string $default_lang_id ID of the default language

* @return null

*/

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

}

}

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

{

}

if ($field_data['field_minlen'] && utf8_strlen($field_value) < $field_data['field_minlen'])

{

}

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

{

}

if (!empty($field_data['field_validation']) && $field_data['field_validation'] != '.*')

switch ($row['field_validation'])

{

case '[0-9]+':

case '[\w]+':

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

}

}

}

<!-- IF S_USER_INACTIVE --><dt>{L_USER_IS_INACTIVE}{L_COLON}</dt> <dd>{USER_INACTIVE_REASON}</dd><!-- ENDIF -->

<!-- IF LOCATION --><dt>{L_LOCATION}{L_COLON}</dt> <dd>{LOCATION}</dd><!-- ENDIF -->

<!-- IF AGE !== '' --><dt>{L_AGE}{L_COLON}</dt> <dd>{AGE}</dd><!-- ENDIF -->

<!-- IF S_GROUP_OPTIONS --><dt>{L_USERGROUPS}{L_COLON}</dt> <dd><select name="g">{S_GROUP_OPTIONS}</select> <input type="submit" name="submit" value="{L_GO}" class="button2" /></dd><!-- ENDIF -->

<!-- BEGIN custom_fields --><dt>{custom_fields.PROFILE_FIELD_NAME}{L_COLON}</dt> <dd>{custom_fields.PROFILE_FIELD_VALUE}</dd><!-- END custom_fields -->

<!-- IF S_USER_LOGGED_IN and S_ZEBRA -->

<dt><label for="location">{L_LOCATION}{L_COLON}</label></dt>

<dd><input type="text" name="location" id="location" maxlength="255" value="{LOCATION}" class="inputbox" /></dd>

</dl>

<!-- IF S_BIRTHDAYS_ENABLED -->

<dl>

<dt><label for="bday_day">{L_BIRTHDAY}{L_COLON}</label><br /><span>{L_BIRTHDAY_EXPLAIN}</span></dt>

</tr>

<!-- ENDIF -->

<tr>

<td class="gen" align="{S_CONTENT_FLOW_END}" nowrap="nowrap">{L_WEBSITE}{L_COLON} </td>

<td><!-- IF U_WWW --><b><a class="genmed" href="{U_WWW}">{U_WWW}</a></b><!-- ENDIF --></td>

</tr>

<td class="row1" width="35%"><b class="genmed">{L_LOCATION}{L_COLON} </b></td>

<td class="row2"><input class="post" type="text" name="location" size="30" maxlength="100" value="{LOCATION}" /></td>

</tr>

<!-- IF S_BIRTHDAYS_ENABLED -->

<tr>

<td class="row1" width="35%"><b class="genmed">{L_BIRTHDAY}{L_COLON} </b><br /><span class="gensmall">{L_BIRTHDAY_EXPLAIN}</span></td>