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

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

'pf_phpbb_occupation' => array('TEXT_UNI', ''),

),

'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')),

array('user_id', 'users.user_id', 'phpbb_user_id'),

array('pf_phpbb_occupation', 'users.user_occ', array('function1' => 'phpbb_set_encoding')),

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

),

# Table: 'phpbb_profile_fields_data'

CREATE TABLE phpbb_profile_fields_data (

user_id INTEGER DEFAULT 0 NOT NULL,

pf_phpbb_occupation BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL

);;

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,

*/

CREATE TABLE [phpbb_profile_fields_data] (

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

[pf_phpbb_occupation] [varchar] (4000) DEFAULT ('') NOT NULL

) 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,

pf_phpbb_occupation blob 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,

pf_phpbb_occupation text 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,

pf_phpbb_occupation clob DEFAULT '' ,

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),

pf_phpbb_occupation varchar(4000) DEFAULT '' NOT NULL,

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, 'ogm');

# Add default profile fields

# User Notification Options (for first user)

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

# Table: 'phpbb_profile_fields_data'

CREATE TABLE phpbb_profile_fields_data (

user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

pf_phpbb_occupation text(65535) NOT NULL DEFAULT '',

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_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.',

'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'],

static public function depends_on()

{

return array(

);

}

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

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

{

'field_id' => $field_id,

'lang_id' => $lang_id,

'lang_name' => 'OCCUPATION',

'pf_phpbb_occupation' => $row['user_occ'],

);

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

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

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

<!-- 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>