<!-- IF .pagination -->

&bull; <!-- INCLUDE pagination.html -->

<!-- ELSE -->

<!-- ENDIF -->

<!-- ENDIF -->

</div>

<!-- ENDIF -->

</tbody>

</table>

<!-- INCLUDE overall_footer.html -->

<dd><input type="checkbox" class="radio" id="field_show_on_vt" name="field_show_on_vt" value="1"<!-- IF S_SHOW_ON_VT --> checked="checked"<!-- ENDIF --> /></dd>

</dl>

<dl>

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

<dd><input type="checkbox" class="radio" id="field_required" name="field_required" value="1"<!-- IF S_FIELD_REQUIRED --> checked="checked"<!-- ENDIF --> /></dd>

</dl>

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

}*/

.clearfix, .row, #content, fieldset dl, #page-body {

overflow: hidden;

}

<script type="text/javascript">

// <![CDATA[

var jump_page = '{LA_JUMP_PAGE}{L_COLON}';

var per_page = '{PER_PAGE}';

var base_url = '{BASE_URL|e('js')}';

<script type="text/javascript">

// <![CDATA[

var jump_page = '{LA_JUMP_PAGE}{L_COLON}';

var per_page = '{PER_PAGE}';

var base_url = '{BASE_URL|e('js')}';

phpbb.plupload.deleteFile = function(row, attachId) {

// If there's no attach id, then the file hasn't been uploaded. Simply delete the row.

if (typeof attachId === 'undefined') {

row.slideUp(100, function() {

row.remove();

phpbb.plupload.hideEmptyList();

- %core.php_ext%

- %core.table_prefix%

- @migrator.tool_collection

migrator.tool_collection:

class: phpbb\di\service_collection

$email = "nobody@localhost";

$icq = "12345678";

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

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

$signature_bbcode_uid = "";

$avatar_filename = "";

}

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

<ol>

<li><a href="#changelog">Changelog</a>

<ol style="list-style-type: lower-roman;">

<li><a href="#v310a1">Changes since 3.1.0-a1</a></li>

<li><a href="#v30x">Changes since 3.0.x</a></li>

<li><a href="#v3011">Changes since 3.0.11</a></li>

<div class="content">

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11998">PHPBB3-11998</a>] - Add console / command line client environment </li>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11913">PHPBB3-11913</a>] - Apply reorganisation of download.phpbb.com to build_announcement.php</li>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11753">PHPBB3-11753</a>] - Upgrade mysql_upgrader.php schema data.</li>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10909">PHPBB3-10909</a>] - Update Travis Test Configuration: Travis no longer supports PHP 5.3.2</li>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10480">PHPBB3-10480</a>] - Automate changelog building</li>

</ul>

<h4> Bug

</h4>

</ul>

<h4> Security

</h4>

<ul>

</ul>

<ul>

<li>[Sec] Do not expose forum content of forums with ACL entries but no actual permission in ATOM Feeds. (Bug #58595)</li>

</ul>

<ul>

<li>[Fix] Allow ban reason and length to be selected and copied in ACP and subsilver2 MCP. (Bug #51095)</li>

</ul>

<ul>

<li>[Fix] Allow whitespaces in avatar gallery names. (Bug #44955)</li>

<li>[Feature] Send anonymous statistical information to phpBB on installation and update (optional).</li>

</ul>

<ul>

<li>[Fix] Delete user entry from ban list table upon user deletion (Bug #40015 - Patch by TerraFrost)</li>

<li>[Sec] Only use forum id supplied for posting if global announcement detected. (Reported by nickvergessen)</li>

</ul>

<ul>

<li>[Fix] Allow mixed-case template directories to be inherited (Bug #36725)</li>

<li>[Sec] Ask for forum password if post within passworded forum quoted in private message. (Reported by nickvergessen)</li>

</ul>

<ul>

<li>[Fix] Correctly set topic starter if first post in topic removed (Bug #30575 - Patch by blueray2048)</li>

<li>[Sec Precaution] Stricter validation of the HTTP_HOST header (Thanks to Techie-Micheal et al for pointing out possible issues in derived code)</li>

</ul>

<ul>

<li>[Fix] Ability to set permissions on non-mysql dbms (Bug #24955)</li>

<li>[Sec] Only allow urls gone through redirect() being used within login_box(). (thanks nookieman)</li>

</ul>

<ul>

<li>[Change] Validate birthdays (Bug #15004)</li>

<li>[Fix] Find and display colliding usernames correctly when converting from one database to another (Bug #23925)</li>

</ul>

<ul>

<li>[Fix] Cleaned usernames contain only single spaces, so &quot;a_name&quot; and &quot;a__name&quot; are treated as the same name (Bug #15634)</li>

<li>[Fix] Call garbage_collection() within database updater to correctly close connections (affects Oracle for example)</li>

</ul>

<ul>

<li>[Fix] Fixed MSSQL related bug in the update system</li>

<li>[Fix] No duplication of active topics (Bug #15474)</li>

</ul>

<ul>

<li>[Fix] Submitting language changes using acp_language (Bug #14736)</li>

<li>[Fix] Able to request new password (Bug #14743)</li>

</ul>

<ul>

<li>[Feature] Removing constant PHPBB_EMBEDDED in favor of using an exit_handler(); the constant was meant to achive this more or less.</li>

<li>[Sec] New password hashing mechanism for storing passwords (#i42)</li>

</ul>

<ul>

<li>[Fix] MySQL, PostgreSQL and SQLite related database fixes (Bug #13862)</li>

<li>[Fix] odbc_autocommit causing existing result sets to be dropped (Bug #14182)</li>

</ul>

<ul>

<li>[Fix] Fixing some subsilver2 and prosilver style issues</li>

</ul>

<ul>

<li>[Fix] Re-allow searching within the memberlist</li>

</ul>

<ul>

<li>[Fix] (X)HTML issues within the templates (Bug #11255, #11255)</li>

* Since: 3.1.0-a2

* Purpose: Add field (e.g. textbox) to the posting screen before the subject

simple_footer_after

===

* Locations:

===

* Locations:

+ styles/prosilver/template/ucp_pm_viewmessage_print.html

* Since: 3.1.0-a1

* Purpose: Add asset calls directly before the `</head>` tag of the Print PM screen

* Purpose: Add options to the bottom of the drop-down lists block of the Edit

Display Options screen

viewtopic_print_head_append

===

* Locations:

+ styles/prosilver/template/viewtopic_print.html

* Since: 3.1.0-a1

* Purpose: Add asset calls directly before the `</head>` tag of the Print Topic screen

'TOTAL_FILES' => $num_files,

'TOTAL_SIZE' => get_formatted_filesize($total_size),

'S_LIMIT_DAYS' => $s_limit_days,

'S_SORT_KEY' => $s_sort_key,

'S_SORT_DIR' => $s_sort_dir)

'S_GROUP_SPECIAL' => ($group_row['group_type'] == GROUP_SPECIAL) ? true : false,

'S_ACTION_OPTIONS' => $s_action_options,

'GROUP_NAME' => ($group_row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $group_row['group_name']] : $group_row['group_name'],

'U_ACTION' => $this->u_action . "&amp;g=$group_id",

'S_LIMIT_DAYS' => $s_limit_days,

'S_SORT_KEY' => $s_sort_key,

'S_SORT_DIR' => $s_sort_dir,

'USERS_PER_PAGE' => $per_page,

'U_ACTION' => $this->u_action . "&amp;$u_sort_param&amp;users_per_page=$per_page&amp;start=$start",

'L_EXPLAIN' => $l_title_explain,

'U_ACTION' => $this->u_action . "&amp;$u_sort_param$keywords_param&amp;start=$start",

'S_LIMIT_DAYS' => $s_limit_days,

'S_SORT_KEY' => $s_sort_key,

'S_SORT_DIR' => $s_sort_dir,

'field_show_on_reg' => 0,

'field_show_on_pm' => 0,

'field_show_on_vt' => 0,

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

'lang_explain' => '',

'lang_default_value'=> '')

// $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')

);

'field_show_on_reg',

'field_show_on_pm',

'field_show_on_vt',

'field_show_profile',

'field_hide',

);

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

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

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

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

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

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

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

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

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

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

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

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

$template->assign_vars(array(

'S_FEEDBACK' => true,

'S_LIMIT_DAYS' => $s_limit_days,

'S_SORT_KEY' => $s_sort_key,

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

$template->assign_vars(array(

'S_ATTACHMENTS' => true,

'S_SORT_KEY' => $s_sort_key,

'S_SORT_DIR' => $s_sort_dir,

));

*/

// phpBB Version

// QA-related

// define('PHPBB_QA', 1);

define('ZEBRA_TABLE', $table_prefix . 'zebra');

// Additional tables

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

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

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

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

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

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

$schema_data['phpbb_profile_fields_data'] = array(

'COLUMNS' => array(

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

),

'PRIMARY_KEY' => 'user_id',

);

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

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

function generate_smilies($mode, $forum_id)

{

global $db, $user, $config, $template, $phpbb_dispatcher;

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

if ($mode == 'window')

'body' => 'posting_smilies.html')

);

}

$display_link = false;

{

$template->assign_vars(array(

'S_SHOW_SMILEY_LINK' => true,

}

if ($mode == 'window')

'user_lastpage' => '',

'user_posts' => 0,

'user_colour' => '',

'user_avatar' => '',

'user_avatar_type' => '',

'user_avatar_width' => 0,

'S_MCP_ACTION' => $url . "&amp;i=$id&amp;forum_action=$action&amp;mode=$mode&amp;start=$start" . (($merge_select) ? $selected_ids : ''),

'TOTAL_TOPICS' => $user->lang('VIEW_FORUM_TOPICS', (int) $forum_topics),

));

$pagination->generate_template_pagination($base_url, 'pagination', 'start', $log_count, $config['topics_per_page'], $start);

$template->assign_vars(array(

'TOTAL' => $user->lang('TOTAL_LOGS', (int) $log_count),

'L_TITLE' => $user->lang['MCP_LOGS'],

'L_TITLE' => $user->lang['MCP_NOTES_USER'],

'TOTAL_REPORTS' => $user->lang('LIST_REPORTS', (int) $log_count),

'RANK_TITLE' => $rank_title,

'S_MCP_ACTION' => $this->u_action,

'S_CLOSED' => ($mode == 'pm_reports_closed') ? true : false,

'TOTAL' => $total,

'TOTAL_REPORTS' => $user->lang('LIST_REPORTS', (int) $total),

)

'S_TOPICS' => $is_topics,

'S_RESTORE' => $is_restore,

'TOPIC_ID' => $topic_id,

'TOTAL' => $user->lang(((!$is_topics) ? 'VIEW_TOPIC_POSTS' : 'VIEW_FORUM_TOPICS'), (int) $total),

));

'S_FORUM_OPTIONS' => $forum_options,

'S_CLOSED' => ($mode == 'reports_closed') ? true : false,

'TOPIC_ID' => $topic_id,

'TOTAL' => $total,

'TOTAL_REPORTS' => $user->lang('LIST_REPORTS', (int) $total),

'RETURN_TOPIC' => sprintf($user->lang['RETURN_TOPIC'], '<a href="' . append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f={$topic_info['forum_id']}&amp;t={$topic_info['topic_id']}&amp;start=$start") . '">', '</a>'),

'RETURN_FORUM' => sprintf($user->lang['RETURN_FORUM'], '<a href="' . append_sid("{$phpbb_root_path}viewforum.$phpEx", "f={$topic_info['forum_id']}&amp;start=$start") . '">', '</a>'),

'TOTAL_POSTS' => $user->lang('VIEW_TOPIC_POSTS', (int) $total),

));

}

'S_SELECT_SORT_KEY' => $s_sort_key,

'S_SELECT_SORT_DAYS' => $s_limit_days,

'TOTAL_USERS' => $user->lang('LIST_USERS', (int) $user_count),

));

}

$pagination->generate_template_pagination($base_url, 'pagination', 'start', $num_attachments, $config['topics_per_page'], $start);

$template->assign_vars(array(

'TOTAL_ATTACHMENTS' => $num_attachments,

'L_TITLE' => $user->lang['UCP_ATTACHMENTS'],

$template->assign_vars(array(

'S_LIST' => true,

'S_ACTION_OPTIONS' => $s_action_options,

'U_ACTION' => $this->u_action . "&amp;g=$group_id",

'S_UCP_ACTION' => $this->u_action . "&amp;g=$group_id",

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

$pagination->generate_template_pagination($this->u_action, 'pagination', 'start', $topics_count, $config['topics_per_page'], $start);

$template->assign_vars(array(

'TOTAL_TOPICS' => $user->lang('VIEW_FORUM_TOPICS', (int) $topics_count),

));

}

$pagination->generate_template_pagination($base_url, 'pagination', 'start', $notifications['total_count'], $config['topics_per_page'], $start);

$template->assign_vars(array(

'TOTAL_COUNT' => $notifications['total_count'],

'U_MARK_ALL' => $base_url . '&amp;mark=all&amp;token=' . generate_link_hash('mark_all_notifications_read'),

));

$pagination->generate_template_pagination($base_url, 'pagination', 'start', $pm_count, $config['topics_per_page'], $start);

$template->assign_vars(array(

'TOTAL_MESSAGES' => $user->lang('VIEW_PM_MESSAGES', (int) $pm_count),

'POST_IMG' => (!$auth->acl_get('u_sendpm')) ? $user->img('button_topic_locked', 'POST_PM_LOCKED') : $user->img('button_pm_new', 'POST_NEW_PM'),

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

function main($id, $mode)

{

global $config, $phpbb_root_path, $phpEx;

if (!$config['allow_password_reset'])

{

$convertor_data = array(

'forum_name' => 'phpBB 2.0.x',

'version' => '1.0.3',

'author' => '<a href="https://www.phpbb.com/">phpBB Group</a>',

'dbms' => $dbms,

'dbhost' => $dbhost,

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

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

}

/**

field_show_on_reg INTEGER DEFAULT 0 NOT NULL,

field_show_on_pm INTEGER DEFAULT 0 NOT NULL,

field_show_on_vt INTEGER DEFAULT 0 NOT NULL,

field_show_profile INTEGER DEFAULT 0 NOT NULL,

field_hide INTEGER DEFAULT 0 NOT NULL,

field_no_view INTEGER DEFAULT 0 NOT NULL,

# Table: 'phpbb_profile_fields_data'

CREATE TABLE phpbb_profile_fields_data (

);;

ALTER TABLE phpbb_profile_fields_data ADD PRIMARY KEY (user_id);;

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,

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,

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

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

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

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

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

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

Table: 'phpbb_profile_fields_data'

*/

CREATE TABLE [phpbb_profile_fields_data] (

) ON [PRIMARY]

GO

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

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

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

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

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

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

# 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_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,

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,

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

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

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

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

# 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_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,

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,

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

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

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

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

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

field_no_view number(1) DEFAULT '0' 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_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 '' ,

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

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

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

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

field_show_profile INT2 DEFAULT '0' NOT NULL CHECK (field_show_profile >= 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),

*/

CREATE TABLE phpbb_profile_fields_data (

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

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,

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_config (config_name, config_value) VALUES ('upload_icons_path', 'images/upload_icons');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('upload_path', 'files');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('use_system_cron', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_expire_days', '90');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_gc', '14400');

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

field_show_on_reg INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_show_on_pm INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_show_on_vt INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_show_profile INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_hide INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_no_view INTEGER UNSIGNED NOT NULL DEFAULT '0',

# Table: 'phpbb_profile_fields_data'

CREATE TABLE phpbb_profile_fields_data (

user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

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

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

'EXTENSION_DISABLE_SUCCESS' => 'The extension was disabled successfully',

'EXTENSION_ENABLE_SUCCESS' => 'The extension was enabled successfully',

'EXTENSION_DELETE_DATA_CONFIRM' => 'Are you sure that you wish to delete the data associated with “%s”?<br /><br />This removes all of its data and settings and cannot be undone!',

'EXTENSION_DISABLE_CONFIRM' => 'Are you sure that you wish to disable the “%s” extension?',

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

'DISPLAY_AT_REGISTER' => 'Display on registration screen',

'DISPLAY_AT_REGISTER_EXPLAIN' => 'If this option is enabled, the field will be displayed on registration.',

'DISPLAY_ON_PM' => 'Display on view pm screen',

'DISPLAY_ON_PM_EXPLAIN' => 'If this option is enabled, the field will be displayed in the mini-profile on the pm screen.',

'DISPLAY_ON_VT' => 'Display on viewtopic screen',

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

'PLUPLOAD_ERR_INPUT' => 'Failed to open input stream.',

'PLUPLOAD_ERR_MOVE_UPLOADED' => 'Failed to move uploaded file.',

'PLUPLOAD_ERR_OUTPUT' => 'Failed to open output stream.',

'PLUPLOAD_ERR_FILE_COUNT' => 'File count error.',

'PLUPLOAD_ERR_RUNTIME_MEMORY' => 'Runtime ran out of available memory.',

'PLUPLOAD_ERR_UPLOAD_URL' => 'Upload URL might be wrong or does not exist.',

'PLUPLOAD_EXTENSION_ERROR' => 'File extension error.',

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

$pagination = $phpbb_container->get('pagination');

// Sorting

if ($auth->acl_get('a_user'))

{

$user_list[] = (int) $row['user_id'];

}

$db->sql_freeresult($result);

$leaders_set = false;

// So, did we get any users?

if (sizeof($user_list))

// Load custom profile fields

if ($config['load_cpf_memberlist'])

{

// Grab all profile fields from users in id cache for later use - similar to the poster cache

$profile_fields_cache = $cp->generate_profile_fields_template('grab', $user_list);

}

// If we sort by last active date we need to adjust the id cache due to user_lastvisit not being the last active date...

// Generate page

$template->assign_vars(array(

'TOTAL_USERS' => $user->lang('LIST_USERS', (int) $total_users),

'PROFILE_IMG' => $user->img('icon_user_profile', $user->lang['PROFILE']),

'U_FIND_MEMBER' => ($config['load_search'] || $auth->acl_get('a_')) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=searchuser' . (($start) ? "&amp;start=$start" : '') . (!empty($params) ? '&amp;' . implode('&amp;', $params) : '')) : '',

'U_HIDE_FIND_MEMBER' => ($mode == 'searchuser' || ($mode == '' && $submit)) ? $u_hide_find_member : '',

'U_SORT_USERNAME' => $sort_url . '&amp;sk=a&amp;sd=' . (($sort_key == 'a' && $sort_dir == 'a') ? 'd' : 'a'),

'U_SORT_JOINED' => $sort_url . '&amp;sk=c&amp;sd=' . (($sort_key == 'c' && $sort_dir == 'a') ? 'd' : 'a'),

'U_SORT_POSTS' => $sort_url . '&amp;sk=d&amp;sd=' . (($sort_key == 'd' && $sort_dir == 'a') ? 'd' : 'a'),

'U_SORT_EMAIL' => $sort_url . '&amp;sk=e&amp;sd=' . (($sort_key == 'e' && $sort_dir == 'a') ? 'd' : 'a'),

'U_SORT_WEBSITE' => $sort_url . '&amp;sk=f&amp;sd=' . (($sort_key == 'f' && $sort_dir == 'a') ? 'd' : 'a'),

'U_SORT_ICQ' => $sort_url . '&amp;sk=g&amp;sd=' . (($sort_key == 'g' && $sort_dir == 'a') ? 'd' : 'a'),

'U_SORT_AIM' => $sort_url . '&amp;sk=h&amp;sd=' . (($sort_key == 'h' && $sort_dir == 'a') ? 'd' : 'a'),

'U_SORT_MSN' => $sort_url . '&amp;sk=i&amp;sd=' . (($sort_key == 'i' && $sort_dir == 'a') ? 'd' : 'a'),

'U_YIM' => ($data['user_yim']) ? 'http://edit.yahoo.com/config/send_webmesg?.target=' . urlencode($data['user_yim']) . '&amp;.src=pg' : '',

'U_MSN' => ($data['user_msnm'] && $auth->acl_get('u_sendim')) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=contact&amp;action=msnm&amp;u=' . $user_id) : '',

'U_JABBER' => ($data['user_jabber'] && $auth->acl_get('u_sendim')) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=contact&amp;action=jabber&amp;u=' . $user_id) : '',

'USER_ICQ' => $data['user_icq'],

'USER_AIM' => $data['user_aim'],

return false;

}

}

/** @var \phpbb\db\tools */

protected $db_tools;

/** @var string */

protected $table_prefix;

/**

* Constructor of the database migrator

*/

{

$this->config = $config;

$this->db = $db;

$this->db_tools = $db_tools;

$this->migrations_table = $migrations_table;

$this->tools[$tool->get_name()] = $tool;

}

$this->load_migration_state();

}

if (!$state['migration_schema_done'])

{

}

else if (!$state['migration_data_done'])

{

$this->set_migration_state($name, $state);

}

{

}

return true;

}

/**

* Process the data step of the migration

*

* @param array $steps The steps to run

return $this->get_callable_from_step($step);

break;

case 'custom':

if (!is_callable($parameters[0]))

{

// here lies an array, filled with information compiled on the column's data

$prepared_column = $this->sql_prepare_column_data($table_name, $column_name, $column_data);

{

trigger_error("Index name '${column_name}_gen' on table '$table_name' is too long. The maximum auto increment column length is 26 characters.", E_USER_ERROR);

}

{

return $this->getMessage();

}

*/

public function get_avatar()

{

}

/**

public function generate_template_pagination($base_url, $block_var_name, $start_name, $num_items, $per_page, $start = 1, $reverse_count = false, $ignore_on_page = false)

{

$total_pages = ceil($num_items / $per_page);

$on_page = $this->get_on_page($per_page, $start);

$u_previous_page = $u_next_page = '';

{

{

}

{

}

{

}

}

// If the block_var_name is a nested block, we will use the last (most

'U_' . $tpl_prefix . 'NEXT_PAGE' => ($on_page != $total_pages) ? $u_next_page : '',

$tpl_prefix . 'TOTAL_PAGES' => $total_pages,

$tpl_prefix . 'CURRENT_PAGE' => $on_page,

);

if ($tpl_block_name)

/**

* Return current page

*

* @param int $num_items the total number of items, posts, topics, etc.

* @param int $per_page the number of items, posts, etc. per page

* @param int $start the item which should be considered currently active, used to determine the page we're on

* @return string Descriptive pagination string (e.g. "page 1 of 10")

*/

{

$on_page = $this->get_on_page($per_page, $start);

return $this->user->lang('PAGE_OF', $on_page, max(ceil($num_items / $per_page), 1));

}

}

/**

* 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

*/

$profile_field = $this->type_collection[$ident_ary['data']['field_type']];

$value = $profile_field->get_profile_value($ident_ary['value'], $ident_ary['data']);

{

continue;

}

/**

* {@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;

return $current_value;

}

return parent::get_excluded_options($key, $action, $current_value, $field_data, $step);

}

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;

return sizeof(explode("\n", $this->request->variable('lang_options', '', true)));

}

return parent::get_excluded_options($key, $action, $current_value, $field_data, $step);

}

*/

public function get_default_field_value($field_data)

{

{

// We cannot insert an empty string into an integer column.

return null;

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

}

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

);

}

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_\+\. \-\[\]]+':

}

}

}

$this->error();

}

}

unset($lang_set_ext);

$style_request = request_var('style', 0);

{

global $SID, $_EXTRA_URL;

# General Information about this style

name = prosilver

copyright = &copy; phpBB Group, 2007

# Defining a different template bitfield

# template_bitfield = lNg=

<tr>

<th class="name" data-dfn="{L_RANK}{L_COMMA_SEPARATOR}<!-- IF S_SHOW_GROUP and .memberrow -->{L_GROUP_LEADER}<!-- ELSE -->{L_USERNAME}<!-- ENDIF -->"><span class="rank-img"><a href="{U_SORT_RANK}">{L_RANK}</a></span><a href="{U_SORT_USERNAME}"><!-- IF S_SHOW_GROUP and .memberrow -->{L_GROUP_LEADER}<!-- ELSE -->{L_USERNAME}<!-- ENDIF --></a></th>

<th class="posts"><a href="{U_SORT_POSTS}#memberlist">{L_POSTS}</a></th>

<th class="joined"><a href="{U_SORT_JOINED}#memberlist">{L_JOINED}</a></th>

<!-- IF U_SORT_ACTIVE --><th class="active"><a href="{U_SORT_ACTIVE}#memberlist">{L_LAST_ACTIVE}</a></th><!-- ENDIF -->

</tr>

<!-- IF not S_LEADERS_SET -->

<th class="name" data-dfn="{L_RANK}{L_COMMA_SEPARATOR}{L_USERNAME}"><span class="rank-img"><a href="{U_SORT_RANK}">{L_RANK}</a></span><a href="{U_SORT_USERNAME}"><!-- IF S_SHOW_GROUP -->{L_GROUP_MEMBERS}<!-- ELSE -->{L_USERNAME}<!-- ENDIF --></a></th>

<th class="posts"><a href="{U_SORT_POSTS}#memberlist">{L_POSTS}</a></th>

<th class="joined"><a href="{U_SORT_JOINED}#memberlist">{L_JOINED}</a></th>

<!-- IF U_SORT_ACTIVE --><th class="active"><a href="{U_SORT_ACTIVE}#memberlist">{L_LAST_ACTIVE}</a></th><!-- ENDIF -->

<!-- ELSEIF S_SHOW_GROUP -->

<tr class="<!-- IF memberrow.S_ROW_COUNT is even -->bg1<!-- ELSE -->bg2<!-- ENDIF -->">

<td><!-- IF memberrow.RANK_IMG --><span class="rank-img">{memberrow.RANK_IMG}</span><!-- ELSE --><span class="rank-img">{memberrow.RANK_TITLE}</span><!-- ENDIF --><!-- IF S_IN_SEARCH_POPUP and not S_SELECT_SINGLE --><input type="checkbox" name="user" value="{memberrow.USERNAME}" /> <!-- ENDIF --><!-- EVENT memberlist_body_username_prepend -->{memberrow.USERNAME_FULL}<!-- EVENT memberlist_body_username_append --><!-- IF S_IN_SEARCH_POPUP --><br />[&nbsp;<a href="#" onclick="insert_single_user('#results', '{memberrow.A_USERNAME}'); return false;">{L_SELECT}</a>&nbsp;]<!-- ENDIF --></td>

<td class="posts"><!-- IF memberrow.POSTS and S_DISPLAY_SEARCH --><a href="{memberrow.U_SEARCH_USER}" title="{L_SEARCH_USER_POSTS}">{memberrow.POSTS}</a><!-- ELSE -->{memberrow.POSTS}<!-- ENDIF --></td>

<td>{memberrow.JOINED}</td>

<!-- IF S_VIEWONLINE --><td>{memberrow.VISITED}&nbsp;</td><!-- ENDIF -->

</tr>

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

<!-- IF S_USER_LOGGED_IN and S_ZEBRA -->

<ul>

<!-- BEGIN pagination -->

<!-- IF pagination.S_IS_PREV -->

'Close': '{LA_PLUPLOAD_CLOSE}',

'Drag files here.': '{LA_PLUPLOAD_DRAG}',

'Duplicate file error.': '{LA_PLUPLOAD_DUPLICATE_ERROR}',

'File: %s': '{LA_PLUPLOAD_FILE}',

'File: %s, size: %d, max file size: %d': '{LA_PLUPLOAD_FILE_DETAILS}',

'File count error.': '{LA_PLUPLOAD_ERR_FILE_COUNT}',

'File extension error.': '{LA_PLUPLOAD_EXTENSION_ERROR}',

'File size error.': '{LA_PLUPLOAD_SIZE_ERROR}',

'Filename': '{LA_PLUPLOAD_FILENAME}',

'Generic error.': '{LA_PLUPLOAD_GENERIC_ERROR}',

'HTTP Error.': '{LA_PLUPLOAD_HTTP_ERROR}',

'Image format either wrong or not supported.': '{LA_PLUPLOAD_IMAGE_FORMAT}',

'Init error.': '{LA_PLUPLOAD_INIT_ERROR}',

'IO error.': '{LA_PLUPLOAD_IO_ERROR}',

'N/A': '{LA_PLUPLOAD_NOT_APPLICABLE}',

'Runtime ran out of available memory.': '{LA_PLUPLOAD_ERR_RUNTIME_MEMORY}',

'Security error.': '{LA_PLUPLOAD_SECURITY_ERROR}',

<dt><label for="subject">{L_SUBJECT}{L_COLON}</label></dt>

<dd><input type="text" name="subject" id="subject" size="45" maxlength="124" tabindex="2" value="{SUBJECT}" class="inputbox autowidth" /></dd>

</dl>

<div id="message-box">

<textarea style="height: 9em;" name="message" rows="7" cols="76" tabindex="3" class="inputbox"></textarea>

</div>

</fieldset>

<fieldset class="submit-buttons">

{S_FORM_TOKEN}

<!-- IF .pagination -->

<!-- INCLUDE pagination.html -->

<!-- ELSE -->

<!-- ENDIF -->

</li>

</ul>

<dd><strong>{L_POSTS}{L_COLON}</strong> {AUTHOR_POSTS}</dd>

<!-- IF AUTHOR_JOINED --><dd><strong>{L_JOINED}{L_COLON}</strong> {AUTHOR_JOINED}</dd><!-- ENDIF -->

<!-- EVENT ucp_pm_viewmessage_custom_fields_before -->

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

<fieldset class="fields2">

<!-- IF ERROR --><p class="error">{ERROR}</p><!-- ENDIF -->

<dl>

<dt><label <!-- IF S_USERNAME_OPTIONS -->for="usernames"<!-- ENDIF -->>{L_YOUR_FRIENDS}{L_COLON}</label><br /><span>{L_YOUR_FRIENDS_EXPLAIN}</span></dt>

<dd>

<!-- ENDIF -->

</dd>

</dl>

<dl>

<dt><label for="add">{L_ADD_FRIENDS}{L_COLON}</label><br /><span>{L_ADD_FRIENDS_EXPLAIN}</span></dt>

<dd><textarea name="add" id="add" rows="3" cols="30" class="inputbox">{USERNAMES}</textarea></dd>

<!-- IF postrow.POSTER_POSTS != '' --><dd><strong>{L_POSTS}{L_COLON}</strong> {postrow.POSTER_POSTS}</dd><!-- ENDIF -->

<!-- IF postrow.POSTER_JOINED --><dd><strong>{L_JOINED}{L_COLON}</strong> {postrow.POSTER_JOINED}</dd><!-- ENDIF -->

<!-- IF postrow.S_PROFILE_FIELD1 -->

<!-- Use a construct like this to include admin defined profile fields. Replace FIELD1 with the name of your field. -->

}

.clearfix, fieldset dl, ul.topiclist dl, dl.polls {

overflow: hidden;

}

/* Pagination

---------------------------------------- */

.pagination {

width: auto;

text-align: right;

margin-top: 5px;

# General Information about this style

name = subsilver2

copyright = &copy; 2005 phpBB Group

# Defining a different template bitfield

# template_bitfield = lNg=

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

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

function jumpto()

{

var per_page = '{PER_PAGE}';

var base_url = '{BASE_URL|e('js')}';

<td class="row1" width="22%"><b class="genmed">{L_SUBJECT}{L_COLON}</b></td>

<td class="row2" width="78%"><input class="post" style="width:450px" type="text" name="subject" size="45" maxlength="124" tabindex="2" value="{SUBJECT}" /></td>

</tr>

<tr>

<td class="row1" width="22%"><b class="genmed">{L_MESSAGE}{L_COLON}</b></td>

<td class="row2" valign="top" align="left" width="78%"><textarea name="message" rows="7" cols="76" tabindex="3" style="width: 700px; height: 130px; min-width: 98%; max-width: 98%;"></textarea> </td>

</tr>

<tr>

<td class="cat" colspan="2" align="center">

<input class="btnlite" type="submit" accesskey="f" tabindex="6" name="preview" value="{L_FULL_EDITOR}" />&nbsp;

<!-- IF .pagination -->

<!-- INCLUDE pagination.html -->

<!-- ELSE -->

<!-- ENDIF -->

</div>

}

//-->

</style>

</head>

<body>

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

<tr>

<th colspan="2" valign="middle">{L_TITLE}</th>

</tr>

<tr>

<td class="row3" colspan="2"><span class="gensmall">{L_FRIENDS_EXPLAIN}</span></td>

</tr>

<td class="row1" width="40%"><b class="genmed">{L_YOUR_FRIENDS}{L_COLON}</b><br /><span class="gensmall">{L_YOUR_FRIENDS_EXPLAIN}</span></td>

<td class="row2" align="center"><!-- IF S_USERNAME_OPTIONS --><select name="usernames[]" multiple="multiple" size="5">{S_USERNAME_OPTIONS}</select><!-- ELSE --><b class="genmed">{L_NO_FRIENDS}</b><!-- ENDIF --></td>

</tr>

<tr>

<td class="row1"><b class="genmed">{L_ADD_FRIENDS}{L_COLON}</b><br /><span class="gensmall">{L_ADD_FRIENDS_EXPLAIN} [ <a href="{U_FIND_USERNAME}" onclick="find_username(this.href); return false;">{L_FIND_USERNAME}</a> ]</span></td>

<td class="row2" align="center"><textarea name="add" rows="5" cols="30">{USERNAMES}</textarea><br /></td>

<span class="postdetails">

<!-- IF postrow.POSTER_JOINED --><br /><b>{L_JOINED}{L_COLON}</b> {postrow.POSTER_JOINED}<!-- ENDIF -->

<!-- IF postrow.POSTER_POSTS != '' --><br /><b>{L_POSTS}{L_COLON}</b> {postrow.POSTER_POSTS}<!-- ENDIF -->

<!-- IF postrow.S_PROFILE_FIELD1 -->

<!-- Use a construct like this to include admin defined profile fields. Replace FIELD1 with the name of your field. -->

}

//-->

</style>

</head>

<body>

$pagination->generate_template_pagination($base_url, 'pagination', 'start', $topics_count, $config['topics_per_page'], $start);

$template->assign_vars(array(

'TOTAL_TOPICS' => ($s_display_active) ? false : $user->lang('VIEW_FORUM_TOPICS', (int) $total_topic_count),

));

'TOTAL_REGISTERED_USERS_ONLINE' => $user->lang('REG_USERS_ONLINE', (int) $logged_visible_online, $user->lang('HIDDEN_USERS_ONLINE', (int) $logged_hidden_online)),

'TOTAL_GUEST_USERS_ONLINE' => $user->lang('GUEST_USERS_ONLINE', (int) $guest_counter),

'LEGEND' => $legend,

'U_SORT_USERNAME' => append_sid("{$phpbb_root_path}viewonline.$phpEx", 'sk=a&amp;sd=' . (($sort_key == 'a' && $sort_dir == 'a') ? 'd' : 'a') . '&amp;sg=' . ((int) $show_guests)),

'U_SORT_UPDATED' => append_sid("{$phpbb_root_path}viewonline.$phpEx", 'sk=b&amp;sd=' . (($sort_key == 'b' && $sort_dir == 'a') ? 'd' : 'a') . '&amp;sg=' . ((int) $show_guests)),

'TOPIC_AUTHOR_COLOUR' => get_username_string('colour', $topic_data['topic_poster'], $topic_data['topic_first_poster_name'], $topic_data['topic_first_poster_colour']),

'TOPIC_AUTHOR' => get_username_string('username', $topic_data['topic_poster'], $topic_data['topic_first_poster_name'], $topic_data['topic_first_poster_colour']),

'TOTAL_POSTS' => $user->lang('VIEW_TOPIC_POSTS', (int) $total_posts),

'U_MCP' => ($auth->acl_get('m_', $forum_id)) ? append_sid("{$phpbb_root_path}mcp.$phpEx", "i=main&amp;mode=topic_view&amp;f=$forum_id&amp;t=$topic_id" . (($start == 0) ? '' : "&amp;start=$start") . ((strlen($u_sort_param)) ? "&amp;$u_sort_param" : ''), true, $user->session_id) : '',

'MODERATORS' => (isset($forum_moderators[$forum_id]) && sizeof($forum_moderators[$forum_id])) ? implode($user->lang['COMMA_SEPARATOR'], $forum_moderators[$forum_id]) : '',

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

$request->overwrite('t', $topic_id);

}

/**

* You can use this event to modify the page title of the viewtopic page