<!-- IF .pagination -->

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

<!-- ELSE -->

<!-- ENDIF -->

<!-- ENDIF -->

</div>

<!-- IF .pagination -->

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

<!-- ELSE -->

<!-- ENDIF -->

</div>

<!-- ENDIF -->

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

<ul>

<!-- BEGIN pagination -->

<!-- IF pagination.S_IS_PREV --><li><a href="{pagination.PAGE_URL}">{L_PREVIOUS}</a></li>

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

* http://www.faqts.com/knowledge_base/view.phtml/aid/1052/fid/130

*/

function storeCaret(textEl) {

textEl.caretPos = document.selection.createRange().duplicate();

}

}

var row = $(phpbb.plupload.rowTpl);

row.attr('id', file.id);

row.find('.file-size').html(plupload.formatSize(file.size));

if (phpbb.plupload.order == 'desc') {

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

* Fires when an error occurs.

*/

uploader.bind('Error', function(up, error) {

// The error message that Plupload provides for these is vague, so we'll be more specific.

if (error.code === plupload.FILE_EXTENSION_ERROR) {

error.message = plupload.translate('Invalid file extension:') + ' ' + error.file.name;

$email = "nobody@localhost";

$icq = "12345678";

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

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

$signature_bbcode_uid = "";

$avatar_filename = "";

}

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

* 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

* Purpose: Add data before the custom fields on the user profile when viewing

a post

viewtopic_topic_title_prepend

===

* Locations:

$download_id = request_var('id', 0);

$topic_id = $request->variable('topic_id', 0);

$archive = $request->variable('archive', '.tar');

$mode = request_var('mode', '');

$thumbnail = request_var('t', false);

if ($download_id)

{

// Attachment id (only 1 attachment)

}

{

}

else if ($topic_id)

{

// Topic id (multiple attachments)

}

else

{

if (!$attachment['in_message'])

{

phpbb_download_handle_forum_auth($db, $auth, $attachment['topic_id']);

}

else

{

$extensions = array();

if (!extension_allowed($row['forum_id'], $attachment['extension'], $extensions))

{

trigger_error(sprintf($user->lang['EXTENSION_DISABLED_AFTER_POSTING'], $attachment['extension']));

}

}

$archive = '.tar';

}

{

}

else

{

$sql = 'SELECT topic_title AS attach_subject, forum_id

FROM ' . TOPICS_TABLE . "

WHERE topic_id = $topic_id";

}

$clean_name = phpbb_download_clean_filename($row['attach_subject']);

$archive_name = 'attachments' . $suffix;

$store_name = 'att_' . time() . '_' . unique_id();

$extensions = array();

$files_added = 0;

$forum_id = ($attachment['in_message']) ? false : (int) $row['forum_id'];

foreach ($attachments as $attach)

{

if (!extension_allowed($forum_id, $attach['extension'], $extensions))

{

continue;

}

unlink($archive_path);

{

// None of the attachments had a valid extension

}

file_gc();

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

));

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

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

*/

function phpbb_download_handle_forum_auth($db, $auth, $topic_id)

{

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

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

$db->sql_freeresult($result);

{

{

// Do something else ... ?

login_forum_box($row);

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

{

global $db, $auth, $user, $config, $phpEx, $template, $phpbb_root_path, $phpbb_container, $phpbb_dispatcher;

// We do not handle erasing posts here

if ($mode == 'delete')

{

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

{

global $auth, $db, $user, $template, $action;

global $config, $phpbb_root_path, $phpEx, $request;

$quickmod = ($mode == 'quickmod') ? true : false;

mcp_restore_topic($topic_ids);

break;

}

switch ($mode)

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

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

// Display not already displayed Attachments for this post, we already parsed them. ;)

if (isset($attachments) && sizeof($attachments))

{

foreach ($methods as $method)

{

$template->assign_block_vars('dl_method', $method);

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

),

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 (

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,

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

*/

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 ,

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,

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,

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,

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,

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,

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

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

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

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

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

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

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

break;

default:

break;

}

}

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

}

}

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

}

{

if ($start < 0 || $start >= $num_items)

{

}

return $start;

}

/**

* 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

*/

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

);

$this->error();

}

}

unset($lang_set_ext);

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

{

global $SID, $_EXTRA_URL;

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

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

{S_HIDDEN_FIELDS}

</div>

</form>

<hr />

<!-- ENDIF -->

<!-- BEGIN postrow -->

<!-- IF postrow.S_FIRST_UNREAD --><a id="unread"></a><!-- ENDIF -->

<div id="p{postrow.POST_ID}" class="post <!-- IF postrow.S_ROW_COUNT is odd -->bg1<!-- ELSE -->bg2<!-- ENDIF --><!-- IF postrow.S_UNREAD_POST --> unreadpost<!-- ENDIF --><!-- IF postrow.S_POST_REPORTED --> reported<!-- ENDIF --><!-- IF postrow.S_POST_DELETED --> deleted<!-- ENDIF --><!-- IF postrow.S_ONLINE and not postrow.S_POST_HIDDEN --> online<!-- ENDIF -->">

<div class="inner">

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

</div>

<hr class="divider" />

<!-- END postrow -->

<!-- IF S_QUICK_REPLY -->

<!-- INCLUDE quickreply_editor.html -->

<hr />

<!-- ENDIF -->

<div class="topic-actions">

<div class="buttons">

<!-- IF not S_IS_BOT and S_DISPLAY_REPLY_INFO -->

}

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

overflow: hidden;

}

/* Pagination

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

.pagination {

width: auto;

text-align: right;

margin-top: 5px;

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

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>

</table>

<!-- BEGIN postrow -->

<table class="tablebg" width="100%" cellspacing="1">

<!-- IF postrow.S_FIRST_ROW -->

<tr>

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

<td class="spacer" colspan="2" height="1"><img src="images/spacer.gif" alt="" width="1" height="1" /></td>

</tr>

</table>

<!-- END postrow -->

<!-- IF not S_IS_BOT -->

</table>

<!-- ENDIF -->

<table width="100%" cellspacing="1">

<tr>

<td align="{S_CONTENT_FLOW_BEGIN}" valign="middle" nowrap="nowrap">

}

//-->

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

));

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

$sort_key = request_var('sk', 'b');

$sort_dir = request_var('sd', 'd');

// Can this user view profiles/memberlist?

if (!$auth->acl_gets('u_viewprofile', 'a_user', 'a_useradd', 'a_userdel'))

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

);

}

foreach ($methods as $method)

{

$template->assign_block_vars('postrow.dl_method', $method);