<dd><input type="url" id="website" name="website" value="{WEBSITE}" /></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";

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

$signature_bbcode_uid = "";

$avatar_filename = "";

}

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

'yim' => request_var('yim', $user_row['user_yim']),

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

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

'bday_day' => 0,

'bday_month' => 0,

'bday_year' => 0,

'website' => array(

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

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

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

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

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

'user_yim' => $data['yim'],

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

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

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

);

'MSN' => $data['msn'],

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

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

'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_interests' => array('TEXT_UNI', ''),

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

),

'user_sig' => array('MTEXT_UNI', ''),

'user_sig_bbcode_uid' => array('VCHAR:8', ''),

'user_sig_bbcode_bitfield' => array('VCHAR:255', ''),

'user_icq' => array('VCHAR:15', ''),

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

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

'AUTHOR_AVATAR' => (isset($user_info['avatar'])) ? $user_info['avatar'] : '',

'AUTHOR_JOINED' => $user->format_date($user_info['user_regdate']),

'AUTHOR_POSTS' => (int) $user_info['user_posts'],

'ONLINE_IMG' => (!$config['load_onlinetrack']) ? '' : ((isset($user_info['online']) && $user_info['online']) ? $user->img('icon_user_online', $user->lang['ONLINE']) : $user->img('icon_user_offline', $user->lang['OFFLINE'])),

'S_ONLINE' => (!$config['load_onlinetrack']) ? false : ((isset($user_info['online']) && $user_info['online']) ? true : false),

'yim' => request_var('yim', $user->data['user_yim']),

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

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

);

if ($config['allow_birthdays'])

'website' => array(

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

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

);

if ($config['allow_birthdays'])

'user_yim' => $data['yim'],

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

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

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

);

'MSN' => $data['msn'],

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

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

));

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

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

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

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

array('user_rank', 'users.user_rank', 'intval'),

array('user_permissions', '', ''),

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

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

array('pf_phpbb_interests', 'users.user_interests', 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_interests BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,

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

);;

user_sig BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,

user_sig_bbcode_uid VARCHAR(8) CHARACTER SET NONE DEFAULT '' NOT NULL,

user_sig_bbcode_bitfield VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,

user_icq VARCHAR(15) CHARACTER SET NONE DEFAULT '' NOT NULL,

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

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

*/

CREATE TABLE [phpbb_profile_fields_data] (

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

[pf_phpbb_interests] [varchar] (4000) DEFAULT ('') NOT NULL ,

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

) ON [PRIMARY]

[user_sig] [text] DEFAULT ('') NOT NULL ,

[user_sig_bbcode_uid] [varchar] (8) DEFAULT ('') NOT NULL ,

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

[user_icq] [varchar] (15) DEFAULT ('') NOT NULL ,

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

[user_yim] [varchar] (255) 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_interests blob NOT NULL,

pf_phpbb_occupation blob NOT NULL,

PRIMARY KEY (user_id)

user_sig mediumblob NOT NULL,

user_sig_bbcode_uid varbinary(8) DEFAULT '' NOT NULL,

user_sig_bbcode_bitfield varbinary(255) DEFAULT '' NOT NULL,

user_icq varbinary(15) DEFAULT '' NOT NULL,

user_aim blob NOT NULL,

user_yim blob NOT NULL,

# Table: 'phpbb_profile_fields_data'

CREATE TABLE phpbb_profile_fields_data (

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

pf_phpbb_interests text NOT NULL,

pf_phpbb_occupation text NOT NULL,

PRIMARY KEY (user_id)

user_sig mediumtext NOT NULL,

user_sig_bbcode_uid varchar(8) DEFAULT '' NOT NULL,

user_sig_bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,

user_icq varchar(15) DEFAULT '' NOT NULL,

user_aim varchar(255) DEFAULT '' NOT NULL,

user_yim varchar(255) DEFAULT '' NOT NULL,

*/

CREATE TABLE phpbb_profile_fields_data (

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

pf_phpbb_interests clob DEFAULT '' ,

pf_phpbb_occupation clob DEFAULT '' ,

CONSTRAINT pk_phpbb_profile_fields_data PRIMARY KEY (user_id)

user_sig clob DEFAULT '' ,

user_sig_bbcode_uid varchar2(8) DEFAULT '' ,

user_sig_bbcode_bitfield varchar2(255) DEFAULT '' ,

user_icq varchar2(15) DEFAULT '' ,

user_aim varchar2(765) DEFAULT '' ,

user_yim varchar2(765) DEFAULT '' ,

*/

CREATE TABLE phpbb_profile_fields_data (

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

pf_phpbb_interests varchar(4000) DEFAULT '' NOT NULL,

pf_phpbb_occupation varchar(4000) DEFAULT '' NOT NULL,

PRIMARY KEY (user_id)

user_sig TEXT DEFAULT '' NOT NULL,

user_sig_bbcode_uid varchar(8) DEFAULT '' NOT NULL,

user_sig_bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,

user_icq varchar(15) DEFAULT '' NOT NULL,

user_aim varchar(255) DEFAULT '' NOT NULL,

user_yim varchar(255) 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_interests text(65535) NOT NULL DEFAULT '',

pf_phpbb_occupation text(65535) NOT NULL DEFAULT '',

PRIMARY KEY (user_id)

user_sig mediumtext(16777215) NOT NULL DEFAULT '',

user_sig_bbcode_uid varchar(8) NOT NULL DEFAULT '',

user_sig_bbcode_bitfield varchar(255) NOT NULL DEFAULT '',

user_icq varchar(15) NOT NULL DEFAULT '',

user_aim varchar(255) NOT NULL DEFAULT '',

user_yim varchar(255) NOT NULL DEFAULT '',

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

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

3 => array('TITLE' => $this->user->lang['FIELD_VALIDATION'], 'FIELD' => '<select name="field_validation">' . $this->validate_options($field_data) . '</select>'),

);

<!-- IF RANK_IMG --><dt><!-- IF RANK_TITLE -->&nbsp;<!-- ELSE -->{L_RANK}{L_COLON}<!-- ENDIF --></dt> <dd>{RANK_IMG}</dd><!-- ENDIF -->

<!-- ENDIF -->

<!-- IF S_USER_INACTIVE --><dt>{L_USER_IS_INACTIVE}{L_COLON}</dt> <dd>{USER_INACTIVE_REASON}</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 -->

<dt><label for="website">{L_WEBSITE}{L_COLON}</label></dt>

<dd><input type="url" name="website" id="website" maxlength="255" value="{WEBSITE}" 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>

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

<td><select name="g">{S_GROUP_OPTIONS}</select> <input class="btnlite" type="submit" name="submit" value="{L_GO}" /></td>

</tr>

<!-- IF AGE !== '' -->

<tr>

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

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

<td class="row2"><input class="post" type="url" name="website" size="30" maxlength="255" value="{WEBSITE}" /></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>

$user_cache_data = array(

'joined' => '',

'posts' => '',

'sig' => '',

'sig_bbcode_uid' => '',

'joined' => $user->format_date($row['user_regdate']),

'posts' => $row['user_posts'],

'warnings' => (isset($row['user_warnings'])) ? $row['user_warnings'] : 0,

'sig' => $user_sig,

'sig_bbcode_uid' => (!empty($row['user_sig_bbcode_uid'])) ? $row['user_sig_bbcode_uid'] : '',

'RANK_IMG_SRC' => $user_cache[$poster_id]['rank_image_src'],

'POSTER_JOINED' => $user_cache[$poster_id]['joined'],

'POSTER_POSTS' => $user_cache[$poster_id]['posts'],

'POSTER_AVATAR' => $user_cache[$poster_id]['avatar'],

'POSTER_WARNINGS' => $user_cache[$poster_id]['warnings'],

'POSTER_AGE' => $user_cache[$poster_id]['age'],

'user_sig' => '',

'user_sig_bbcode_uid' => '',

'user_sig_bbcode_bitfield' => '',

'user_icq' => '',

'user_aim' => '',

'user_yim' => '',