- sh -c "if [ '$TRAVIS_PHP_VERSION' = '5.5' -a '$DB' = 'mysql' ]; then ../phpBB/vendor/bin/phing sniff; fi"

- cd ..

- phpBB/vendor/bin/phpunit --configuration travis/phpunit-$DB-travis.xml

matrix:

allow_failures:

// $package->run_command('rm -v database_update.php');

$package->run_command('rm -v install_update.php');

chdir($package->locations['package_dir']);

foreach ($compress_programs as $extension => $compress_command)

{

$package->begin_status('Packaging phpBB for ' . $extension);

$package->run_command('rm -v ./release_files/' . $package->get('release_filename') . ".{$extension}");

// Build Package

$package->run_command("$compress_command ./release_files/" . $package->get('release_filename') . '.' . $extension . ' ' . $package->get('package_name'));

}

// Microsoft Web PI packaging

#

# Calls the git commit-msg hook on all non-merge commits in a given commit range.

#

if [ "$#" -ne 1 ];

then

exit

fi

DIR=$(dirname "$0")

COMMIT_RANGE="$1"

for COMMIT_HASH in $(git rev-list --no-merges "$COMMIT_RANGE")

do

# The git commit-msg hook takes a path to a file containing a commit

# message. So we have to extract the commit message into a file first,

# which then also needs to be deleted after our work is done.

COMMIT_MESSAGE_PATH="$DIR/commit_msg.$COMMIT_HASH"

git log -n 1 --pretty=format:%B "$COMMIT_HASH" > "$COMMIT_MESSAGE_PATH"

"$COMMIT_MSG_HOOK_PATH" "$COMMIT_MESSAGE_PATH"

rm "$COMMIT_MESSAGE_PATH"

done

<!-- INCLUDE overall_header.html -->

<h1>{L_EXTENSIONS_ADMIN}</h1>

<!-- INCLUDE overall_header.html -->

<a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

<legend>{L_EXT_DETAILS}</legend>

<!-- IF META_DISPLAY_NAME -->

<dl>

<dd><strong id="meta_display_name">{META_DISPLAY_NAME}</strong></dd>

</dl>

<!-- ENDIF -->

<dl>

<dd><strong id="meta_name">{META_NAME}</strong></dd>

</dl>

<!-- IF META_DESCRIPTION -->

<dl>

<dd><p id="meta_description">{META_DESCRIPTION}</p></dd>

</dl>

<!-- ENDIF -->

<dl>

<dd><p id="meta_version">{META_VERSION}</p></dd>

</dl>

<!-- IF META_HOMEPAGE -->

<dl>

</dl>

<!-- ENDIF -->

<!-- IF META_TIME -->

<dl>

<dd><p id="meta_time">{META_TIME}</p></dd>

</dl>

<!-- ENDIF -->

<dl>

<dd><p id="meta_license">{META_LICENCE}</p></dd>

</dl>

</fieldset>

<legend>{L_REQUIREMENTS}</legend>

<!-- IF META_REQUIRE_PHPBB -->

<dl<!-- IF META_REQUIRE_PHPBB_FAIL --> class="requirements_not_met"<!-- ENDIF -->>

<dd><p id="require_phpbb">{META_REQUIRE_PHPBB}</p></dd>

</dl>

<!-- ENDIF -->

<!-- IF META_REQUIRE_PHP -->

<dl<!-- IF META_REQUIRE_PHP_FAIL --> class="requirements_not_met"<!-- ENDIF -->>

<dd><p id="require_php">{META_REQUIRE_PHP}</p></dd>

</dl>

<!-- ENDIF -->

<!-- BEGIN meta_authors -->

<fieldset>

<dl>

</dl>

<!-- IF meta_authors.AUTHOR_EMAIL -->

<dl>

</dl>

<!-- ENDIF -->

<!-- IF meta_authors.AUTHOR_HOMEPAGE -->

<dl>

</dl>

<!-- ENDIF -->

<!-- IF meta_authors.AUTHOR_ROLE -->

<dl>

</dl>

<!-- ENDIF -->

</fieldset>

<!-- INCLUDE overall_header.html -->

<h1>{L_EXTENSIONS_ADMIN}</h1>

<!-- INCLUDE overall_header.html -->

<h1>{L_EXTENSIONS_ADMIN}</h1>

<!-- INCLUDE overall_header.html -->

<h1>{L_EXTENSIONS_ADMIN}</h1>

<dt><label for="field_hide">{L_HIDE_PROFILE_FIELD}{L_COLON}</label><br /><span>{L_HIDE_PROFILE_FIELD_EXPLAIN}</span></dt>

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

</dl>

</fieldset>

<!-- IF S_EDIT_MODE -->

<dd><input type="text" id="email" name="email" /></dd>

</dl>

<dl>

<dd>

<strong>{L_AFTER}</strong> <input type="text" id="joined_after" name="joined_after" />

<br /> <br /> <strong>{L_BEFORE}</strong> <input type="text" id="joined_before" name="joined_before" />

<!-- IF S_GROUP_LIST -->

<dl>

<dt><label for="group_id">{L_GROUP}{L_COLON}</label><br /><span>{L_PRUNE_USERS_GROUP_EXPLAIN}</span></dt>

</dl>

<!-- ENDIF -->

</fieldset>

<fieldset>

<legend>{L_USER_PROFILE}</legend>

<dl>

<dt><label for="jabber">{L_UCP_JABBER}{L_COLON}</label></dt>

<dd><input type="email" id="jabber" name="jabber" value="{JABBER}" /></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>

top: 150px;

left: 0;

right: 0;

margin: 0 auto;

z-index: 50;

padding: 25px;

@media only screen and (max-width: 700px), only screen and (max-device-width: 700px)

{

.phpbb_alert {

margin: 0 25px;

}

}

- @user

tags:

- { name: profilefield.type }

$password = md5("benchpass");

$email = "nobody@localhost";

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

$signature_bbcode_uid = "";

$avatar_filename = "";

$viewemail = 0;

$attachsig = 1;

$allowsmilies = 1;

$allowhtml = 1;

}

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

* Since: 3.1.0-a3

* Purpose: Add content before BBCode posting buttons in the ACP user signature

forumlist_body_last_post_title_prepend

====

* Locations:

* Since: 3.1.0-a1

* Purpose: Add content before the post title of the latest post in a forum on the forum list.

index_body_linklist_after

===

* Locations:

sql_attr_bool = deleted

sql_attr_timestamp = post_time

sql_attr_timestamp = topic_last_post_time

}

source source_phpbb_{SPHINX_ID}_delta : source_phpbb_{SPHINX_ID}_main

{

'field_show_on_pm' => 0,

'field_show_on_vt' => 0,

'field_show_on_ml' => 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_ml',

'field_show_profile',

'field_hide',

);

$options = $profile_field->prepare_options_form($exclude, $visibility_ary);

$cp->vars['field_ident'] = ($action == 'create' && $step == 1) ? utf8_clean_string(request_var('field_ident', $field_row['field_ident'], true)) : request_var('field_ident', $field_row['field_ident']);

foreach ($visibility_ary as $val)

{

}

// If the user has submitted a form with options (i.e. dropdown field)

if ($options)

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

'L_LANG_SPECIFIC' => sprintf($user->lang['LANG_SPECIFIC_OPTIONS'], $config['default_lang']),

'FIELD_TYPE' => $profile_field->get_name(),

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

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

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

);

if ($action == 'create')

{

$username = request_var('username', '', true);

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

$active_select = request_var('active_select', 'lt');

$count_select = request_var('count_select', 'eq');

$where_sql = '';

$where_sql .= ($username) ? ' AND username_clean ' . $db->sql_like_expression(str_replace('*', $db->any_char, utf8_clean_string($username))) : '';

$where_sql .= ($email) ? ' AND user_email ' . $db->sql_like_expression(str_replace('*', $db->any_char, $email)) . ' ' : '';

$where_sql .= $joined_sql;

$where_sql .= ($count) ? " AND user_posts " . $key_match[$count_select] . ' ' . (int) $count . ' ' : '';

$user_row['iso_lang_id'] = $row['lang_id'];

$data = array(

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

'bday_day' => 0,

'bday_month' => 0,

'bday_year' => 0,

if ($submit)

{

$error = validate_data($data, array(

'jabber' => array(

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

array('jabber')),

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

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

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

if (!sizeof($error))

{

$sql_ary = array(

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

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

);

unset($now);

$template->assign_vars(array(

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

'S_BIRTHDAY_DAY_OPTIONS' => $s_birthday_day_options,

'S_BIRTHDAY_MONTH_OPTIONS' => $s_birthday_month_options,

'S_BIRTHDAY_YEAR_OPTIONS' => $s_birthday_year_options,

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

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

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

),

'PRIMARY_KEY' => 'field_id',

'KEYS' => array(

'pf_phpbb_location' => array('VCHAR', ''),

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

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

),

'PRIMARY_KEY' => 'user_id',

);

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

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

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

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

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

'user_new' => array('BOOL', 1),

'user_reminded' => array('TINT:4', 0),

}

/**

* Hashes an email address to a big integer

*

* @param string $email Email address

}

}

// functions used for building option fields

/**

return phpbb_get_avatar($row, $alt, $ignore_config);

}

'BBCODE_NAME' => "'[{$row['bbcode_tag']}]', '[/" . str_replace('=', '', $row['bbcode_tag']) . "]'",

'BBCODE_ID' => $num_predefined_bbcodes + ($i * 2),

'BBCODE_TAG' => $row['bbcode_tag'],

'BBCODE_HELPLINE' => $row['bbcode_helpline'],

'A_BBCODE_HELPLINE' => str_replace(array('&amp;', '&quot;', "'", '&lt;', '&gt;'), array('&', '"', "\'", '<', '>'), $row['bbcode_helpline']),

);

'percent' => ($user->data['message_limit']) ? (($user->data['message_limit'] > 0) ? round(($folder['num_messages'] / $user->data['message_limit']) * 100) : 100) : 0,

);

return $return;

}

// Something went wrong, only partially moved?

if ($num_moved != $folder_row['pm_count'])

{

}

break;

$folder[PRIVMSGS_INBOX] = array(

'folder_name' => $user->lang['PM_INBOX'],

);

$sql = 'SELECT folder_id, folder_name, pm_count

$num_user_folder++;

$folder[$row['folder_id']] = array(

'folder_name' => $row['folder_name'],

);

}

$db->sql_freeresult($result);

{

$cp = $phpbb_container->get('profilefields.manager');

}

// Assign TO/BCC Addresses to template

if (isset($profile_fields[$author_id]))

{

}

}

'MESSAGE_ID' => $message_row['msg_id'],

'U_PM' => ($config['allow_privmsg'] && $auth->acl_get('u_sendpm') && ($user_info['user_allow_pm'] || $auth->acl_gets('a_', 'm_') || $auth->acl_getf_global('m_'))) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&amp;mode=compose&amp;u=' . $author_id) : '',

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

'U_DELETE' => ($auth->acl_get('u_pm_delete')) ? "$url&amp;mode=compose&amp;action=delete&amp;f=$folder_id&amp;p=" . $message_row['msg_id'] : '',

$cp_data = $cp_error = array();

$data = array(

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

);

if ($config['allow_birthdays'])

if ($submit)

{

$validate_array = array(

'jabber' => array(

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

array('jabber')),

);

if ($config['allow_birthdays'])

}

$sql_ary = array(

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

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

);

$template->assign_vars(array(

'ERROR' => (sizeof($error)) ? implode('<br />', $error) : '',

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

));

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

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

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

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

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

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

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

array('pf_phpbb_interests', 'users.user_interests', array('function1' => 'phpbb_set_encoding')),

array('pf_phpbb_location', 'users.user_from', array('function1' => 'phpbb_set_encoding')),

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

),

field_hide INTEGER DEFAULT 0 NOT NULL,

field_no_view INTEGER DEFAULT 0 NOT NULL,

field_active INTEGER DEFAULT 0 NOT NULL,

);;

ALTER TABLE phpbb_profile_fields ADD PRIMARY KEY (field_id);;

user_id INTEGER DEFAULT 0 NOT NULL,

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

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

);;

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_jabber VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

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

user_new INTEGER DEFAULT 1 NOT NULL,

user_reminded INTEGER DEFAULT 0 NOT NULL,

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

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

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

) ON [PRIMARY]

GO

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

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

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

) 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_jabber] [varchar] (255) DEFAULT ('') NOT NULL ,

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

[user_new] [int] DEFAULT (1) NOT NULL ,

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

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

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

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

PRIMARY KEY (field_id),

KEY fld_type (field_type),

KEY fld_ordr (field_order)

pf_phpbb_location varbinary(255) DEFAULT '' 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_jabber blob NOT NULL,

user_form_salt varbinary(96) DEFAULT '' NOT NULL,

user_new tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

user_reminded tinyint(4) DEFAULT '0' NOT NULL,

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

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

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

PRIMARY KEY (field_id),

KEY fld_type (field_type),

KEY fld_ordr (field_order)

pf_phpbb_location varchar(255) DEFAULT '' NOT NULL,

pf_phpbb_interests text NOT NULL,

pf_phpbb_occupation text 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_jabber varchar(255) DEFAULT '' NOT NULL,

user_form_salt varchar(32) DEFAULT '' NOT NULL,

user_new tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

user_reminded tinyint(4) DEFAULT '0' NOT NULL,

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

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

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

CONSTRAINT pk_phpbb_profile_fields PRIMARY KEY (field_id)

)

/

pf_phpbb_location varchar2(255) DEFAULT '' ,

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_jabber varchar2(765) DEFAULT '' ,

user_form_salt varchar2(96) DEFAULT '' ,

user_new number(1) DEFAULT '1' NOT NULL,

user_reminded number(4) DEFAULT '0' NOT NULL,

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

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

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

PRIMARY KEY (field_id)

);

pf_phpbb_location varchar(255) DEFAULT '' NOT NULL,

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_jabber varchar(255) DEFAULT '' NOT NULL,

user_form_salt varchar(32) DEFAULT '' NOT NULL,

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

user_reminded INT2 DEFAULT '0' NOT NULL,

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

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

INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_birthdays', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_cpf_viewprofile', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_db_lastread', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_db_track', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_jquery_url', '//ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js');

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_hide INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_no_view INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_active INTEGER UNSIGNED NOT NULL DEFAULT '0',

);

CREATE INDEX phpbb_profile_fields_fld_type ON phpbb_profile_fields (field_type);

pf_phpbb_location varchar(255) NOT NULL DEFAULT '',

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_jabber varchar(255) NOT NULL DEFAULT '',

user_form_salt varchar(32) NOT NULL DEFAULT '',

user_new INTEGER UNSIGNED NOT NULL DEFAULT '1',

user_reminded tinyint(4) NOT NULL DEFAULT '0',

'ACP_CAT_CUSTOMISE' => 'Customise',

'ACP_CAT_DATABASE' => 'Database',

'ACP_CAT_FORUMS' => 'Forums',

'ACP_CAT_GENERAL' => 'General',

'ACP_CAT_MAINTENANCE' => 'Maintenance',

'ADDED_PROFILE_FIELD' => 'Successfully added custom profile field.',

'ALPHA_ONLY' => 'Alphanumeric only',

'ALPHA_SPACERS' => 'Alphanumeric and spacers',

'ALWAYS_TODAY' => 'Always the current date',

'BOOL_ENTRIES_EXPLAIN' => 'Enter your options now',

'EVERYTHING_OK' => 'Everything OK',

'FIELD_BOOL' => 'Boolean (Yes/No)',

'FIELD_DATE' => 'Date',

'FIELD_DESCRIPTION' => 'Field description',

'FIELD_DESCRIPTION_EXPLAIN' => 'The explanation for this field presented to the user.',

'FIELD_IDENT_ALREADY_EXIST' => 'The chosen field identification already exist. Please choose another name.',

'FIELD_IDENT_EXPLAIN' => 'The field identification is a name to identify the profile field within the database and the templates.',

'FIELD_INT' => 'Numbers',

'FIELD_LENGTH' => 'Length of input box',

'FIELD_NOT_FOUND' => 'Profile field not found.',

'FIELD_STRING' => 'Single text field',

'FIELD_TEXT' => 'Textarea',

'FIELD_TYPE' => 'Field type',

'FIELD_TYPE_EXPLAIN' => 'You are not able to change the field type later.',

'FIELD_VALIDATION' => 'Field validation',

'FIRST_OPTION' => 'First option',

'IMG_ICON_BACK_TOP' => 'Top',

'IMG_ICON_CONTACT_EMAIL' => 'Send email',

'IMG_ICON_CONTACT_JABBER' => 'Jabber',

'IMG_ICON_CONTACT_PM' => 'Send message',

'IMG_ICON_POST_DELETE' => 'Delete post',

'IMG_ICON_POST_EDIT' => 'Edit post',

'HOME' => 'Home',

'ICQ' => 'ICQ',

'IF' => 'If',

'IMAGE' => 'Image',

'IMAGE_FILETYPE_INVALID' => 'Image file type %d for mimetype %s not supported.',

'MERGE_TOPIC' => 'Merge topic',

'MESSAGE' => 'Message',

'MESSAGES' => 'Messages',

'MESSAGE_BODY' => 'Message body',

'MINUTES' => 'Minutes',

'MODERATE' => 'Moderate',

'MODERATORS' => 'Moderators',

'MONTH' => 'Month',

'MOVE' => 'Move',

'NA' => 'N/A',

'NEWEST_USER' => 'Our newest member <strong>%s</strong>',

'TOO_LONG' => 'The value you entered is too long.',

'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_JABBER' => 'The Jabber account 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_LONG_EMAIL' => 'The email address you entered is too long.',

'TOO_MANY_VOTE_OPTIONS' => 'You have tried to vote for too many options.',

'TOO_SHORT' => 'The value you entered is too short.',

'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_JABBER' => 'The Jabber account 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.',

'TOO_SHORT_EMAIL' => 'The email address you entered is too short.',

'TOO_SMALL' => 'The value you entered is too small.',

'TOO_SMALL_MAX_RECIPIENTS' => 'The value of <strong>Maximum number of allowed recipients per private message</strong> setting you entered is too small.',

'WEBSITE' => 'Website',

'WHOIS' => 'Whois',

'WHO_IS_ONLINE' => 'Who is online',

'WRONG_PASSWORD' => 'You entered an incorrect password.',

'WRONG_DATA_COLOUR' => 'The colour value you entered is invalid.',

'WRONG_DATA_JABBER' => 'The name you entered is not a valid Jabber account name.',

'WRONG_DATA_LANG' => 'The language you specified is not valid.',

'WROTE' => 'wrote',

'YEAR' => 'Year',

'YEAR_MONTH_DAY' => '(YYYY-MM-DD)',

'YES' => 'Yes',

'YOU_LAST_VISIT' => 'Last visit was: %s',

'datetime' => array(

'HIDE_MEMBER_SEARCH' => 'Hide member search',

'IM_ADD_CONTACT' => 'Add Contact',

'IM_DOWNLOAD_APP' => 'Download application',

'IM_JABBER' => 'Please note that users may have selected to not receive unsolicited instant messages.',

'IM_JABBER_SUBJECT' => 'This is an automated message please do not reply! Message from user %1$s at %2$s.',

'IM_MESSAGE' => 'Your message',

'IM_NAME' => 'Your Name',

'IM_NO_DATA' => 'There is no suitable contact information for this user.',

'IM_NO_JABBER' => 'Sorry, direct messaging of Jabber users is not supported on this board. You will need a Jabber client installed on your system to contact the recipient above.',

'SELECT_MARKED' => 'Select marked',

'SELECT_SORT_METHOD' => 'Select sort method',

'SEND_ICQ_MESSAGE' => 'Send ICQ message',

'SEND_IM' => 'Instant messaging',

'SEND_JABBER_MESSAGE' => 'Send Jabber message',

'SEND_MESSAGE' => 'Message',

'SEND_YIM_MESSAGE' => 'Send YIM message',

'SORT_EMAIL' => 'Email',

'SORT_LAST_ACTIVE' => 'Last active',

'VIEWING_PROFILE' => 'Viewing profile - %s',

'VISITED' => 'Last visited',

));

),

'FIELD_TOO_SMALL' => 'The value of “%2$s” is too small, a minimum value of %1$d is required.',

'FIELD_TOO_LARGE' => 'The value of “%2$s” is too large, a maximum value of %1$d is allowed.',

'FIELD_INVALID_CHARS_NUMBERS_ONLY' => 'The field “%s” has invalid characters, only numbers are allowed.',

'FIELD_INVALID_CHARS_ALPHA_ONLY' => 'The field “%s” has invalid characters, only alphanumeric characters are allowed.',

'FIELD_INVALID_DATE' => 'The field “%s” has an invalid date.',

'FIELD_INVALID_VALUE' => 'The field “%s” has an invalid value.',

'FOE_MESSAGE' => 'Message from foe',

'FOES_UPDATED' => 'Your foes list has been updated successfully.',

'FOLDER_ADDED' => 'Folder successfully added.',

'FOLDER_MESSAGE_STATUS' => array(

),

'FOLDER_NAME_EMPTY' => 'You must enter a name for this folder.',

'FOLDER_NAME_EXIST' => 'Folder <strong>%s</strong> already exists.',

'FOLDER_RENAMED' => 'Folder successfully renamed.',

'FOLDER_REMOVED' => 'Folder successfully removed.',

'FOLDER_STATUS_MSG' => array(

),

'FORWARD_PM' => 'Forward PM',

'FORCE_PASSWORD_EXPLAIN' => 'Before you may continue browsing the board you are required to change your password.',

'MOVE_DOWN' => 'Move down',

'MOVE_MARKED_TO_FOLDER' => 'Move marked to %s',

'MOVE_PM_ERROR' => array(

),

'MOVE_TO_FOLDER' => 'Move to folder',

'MOVE_UP' => 'Move up',

'UCP' => 'User Control Panel',

'UCP_ACTIVATE' => 'Activate account',

'UCP_ADMIN_ACTIVATE' => 'Please note that you will need to enter a valid email address before your account is activated. The administrator will review your account and if approved you will receive an email at the address you specified.',

'UCP_ATTACHMENTS' => 'Attachments',

'UCP_AUTH_LINK' => 'External accounts',

'UCP_AUTH_LINK_ASK' => 'You currently have no account associated with this external service. Click the button below to link your board account to an account with this external service.',

'UCP_COPPA_BEFORE' => 'Before %s',

'UCP_COPPA_ON_AFTER' => 'On or after %s',

'UCP_EMAIL_ACTIVATE' => 'Please note that you will need to enter a valid email address before your account is activated. You will receive an email at the address you provide that contains an account activation link.',

'UCP_JABBER' => 'Jabber address',

'UCP_LOGIN_LINK' => 'Set up an external account association',

'UCP_MAIN_FRONT' => 'Front page',

'UCP_MAIN_SUBSCRIBED' => 'Manage subscriptions',

'UCP_NO_ATTACHMENTS' => 'You have posted no files.',

'UCP_NOTIFICATION_LIST' => 'Manage notifications',

'UCP_REMIND' => 'Send password',

'UCP_RESEND' => 'Send activation email',

'UCP_WELCOME' => 'Welcome to the User Control Panel. From here you can monitor, view and update your profile, preferences, subscribed forums and topics. You can also send messages to other users (if permitted). Please ensure you read any announcements before continuing.',

'UCP_ZEBRA' => 'Friends &amp; Foes',

'UCP_ZEBRA_FOES' => 'Manage foes',

'UCP_ZEBRA_FRIENDS' => 'Manage friends',

2 => '%d posts',

),

'VIEW_UNREAD_POST' => 'First unread post',

'VOTE_SUBMITTED' => 'Your vote has been cast.',

'VOTE_CONVERTED' => 'Changing votes is not supported for converted polls.',

// If needed, the flag can be set to true within event listener

// to indicate that the action was handled properly

// and to pass by the trigger_error() call below

/**

* This event allows you to add custom quickmod options

* @event core.modify_quickmod_options

* @var object module Instance of module system class

* @var string action Quickmod option

* @since 3.1.0-a4

*/

{

trigger_error($user->lang('QUICKMOD_ACTION_NOT_ALLOWED', $action), E_USER_ERROR);

}

$presence_img = '';

switch ($action)

{

case 'jabber':

$lang = 'JABBER';

$sql_field = 'user_jabber';

'IM_CONTACT' => $row[$sql_field],

'A_IM_CONTACT' => addslashes($row[$sql_field]),

'USERNAME' => $row['username'],

'CONTACT_NAME' => $row[$sql_field],

'SITENAME' => $config['sitename'],

if ($config['load_cpf_viewprofile'])

{

$cp = $phpbb_container->get('profilefields.manager');

}

// If the user has m_approve permission or a_user permission, then list then display unapproved posts

'AVATAR_IMG' => $poster_avatar,

'PM_IMG' => $user->img('icon_contact_pm', $user->lang['SEND_PRIVATE_MESSAGE']),

'EMAIL_IMG' => $user->img('icon_contact_email', $user->lang['EMAIL']),

'JABBER_IMG' => $user->img('icon_contact_jabber', $user->lang['JABBER']),

'SEARCH_IMG' => $user->img('icon_user_search', $user->lang['SEARCH']),

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

// Sorting

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

{

$select_single = request_var('select_single', false);

// Search URL parameters, if any of these are in the URL we do a search

// We validate form and field here, only id/class allowed

$form = (!preg_match('/^[a-z0-9_-]+$/i', $form)) ? '' : $form;

{

$username = request_var('username', '', true);

$email = strtolower(request_var('email', ''));

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

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

$sql_where .= ($username) ? ' AND u.username_clean ' . $db->sql_like_expression(str_replace('*', $db->any_char, utf8_clean_string($username))) : '';

$sql_where .= ($auth->acl_get('a_user') && $email) ? ' AND u.user_email ' . $db->sql_like_expression(str_replace('*', $db->any_char, $email)) . ' ' : '';

$sql_where .= ($jabber) ? ' AND u.user_jabber ' . $db->sql_like_expression(str_replace('*', $db->any_char, $jabber)) . ' ' : '';

$sql_where .= (is_numeric($count) && isset($find_key_match[$count_select])) ? ' AND u.user_posts ' . $find_key_match[$count_select] . ' ' . (int) $count . ' ' : '';

'select_single' => array('select_single', $select_single),

'username' => array('username', '', true),

'email' => array('email', ''),

'jabber' => array('jabber', ''),

'search_group_id' => array('search_group_id', 0),

'joined_select' => array('joined_select', 'lt'),

$template->assign_vars(array(

'USERNAME' => $username,

'EMAIL' => $email,

'JABBER' => $jabber,

'JOINED' => implode('-', $joined),

'ACTIVE' => implode('-', $active),

if ($config['load_cpf_memberlist'])

{

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

// Filter the fields we don't want to show

foreach ($profile_fields_cache as $user_id => $user_profile_fields)

$cp_row = array();

if ($config['load_cpf_memberlist'])

{

}

$memberrow = array_merge(show_profile($row), array(

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

'PM_IMG' => $user->img('icon_contact_pm', $user->lang['SEND_PRIVATE_MESSAGE']),

'EMAIL_IMG' => $user->img('icon_contact_email', $user->lang['EMAIL']),

'JABBER_IMG' => $user->img('icon_contact_jabber', $user->lang['JABBER']),

'SEARCH_IMG' => $user->img('icon_user_search', $user->lang['SEARCH']),

'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_ACTIVE' => ($auth->acl_get('u_viewonline')) ? $sort_url . '&amp;sk=l&amp;sd=' . (($sort_key == 'l' && $sort_dir == 'a') ? 'd' : 'a') : '',

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

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

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

'RANK_IMG' => $rank_img,

'RANK_IMG_SRC' => $rank_img_src,

'S_JABBER_ENABLED' => ($config['jab_enable']) ? true : false,

'S_WARNINGS' => ($auth->acl_getf_global('m_') || $auth->acl_get('m_warn')) ? true : false,

'U_WARN' => ($warn_user_enabled && $auth->acl_get('m_warn')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=warn&amp;mode=warn_user&amp;u=' . $user_id, true, $user->session_id) : '',

'U_PM' => ($config['allow_privmsg'] && $auth->acl_get('u_sendpm') && ($data['user_allow_pm'] || $auth->acl_gets('a_', 'm_') || $auth->acl_getf_global('m_'))) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&amp;mode=compose&amp;u=' . $user_id) : '',

'U_EMAIL' => $email,

'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_JABBER' => $data['user_jabber'],

'USER_JABBER_IMG' => ($data['user_jabber']) ? $user->img('icon_contact_jabber', $data['user_jabber']) : '',

* Build sql statement from array for insert/update/select statements

*

* Idea for this from Ikonboard

*

*/

function sql_build_array($query, $assoc_ary = false)

{

trigger_error('The MULTI_INSERT query value is no longer supported. Please use sql_multi_insert() instead.', E_USER_ERROR);

}

{

$values = array();

foreach ($assoc_ary as $key => $var)

{

return array(

'\phpbb\db\migration\data\v310\profilefield_types',

);

}

WHERE user_type = ' . USER_FOUNDER;

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

{

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

}

}

/**

*/

{

{

{

{

$user_fields[$user_id][$used_ident]['data'] = $this->profile_cache[$used_ident];

}

}

}

{

{

{

}

}

}

}

/**

/**

* {@inheritDoc}

*/

public function get_language_options_input($field_data)

{

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

'field_ident' => 'field_default_value',

'field_type' => $this->get_service_name(),

'field_length' => $field_data['field_length'],

);

$always_now = request_var('always_now', -1);

0 => array('TITLE' => $this->user->lang['FIELD_LENGTH'], 'FIELD' => '<input type="number" min="0" max="99999" name="field_length" size="5" value="' . $field_data['field_length'] . '" />'),

1 => array('TITLE' => $this->user->lang['MIN_FIELD_NUMBER'], 'FIELD' => '<input type="number" min="0" max="99999" name="field_minlen" size="5" value="' . $field_data['field_minlen'] . '" />'),

2 => array('TITLE' => $this->user->lang['MAX_FIELD_NUMBER'], 'FIELD' => '<input type="number" min="0" max="99999" name="field_maxlen" size="5" value="' . $field_data['field_maxlen'] . '" />'),

);

return $options;

*/

public function get_profile_value($field_value, $field_data)

{

{

return null;

}

public function get_profile_value($field_value, $field_data);

/**

* Generate the input field for display

*

* @param array $profile_row Array with data for this field

$default_value = $profile_row['lang_default_value'];

$profile_row['field_value'] = ($this->request->is_set($field_ident)) ? $this->request->variable($field_ident, $default_value, true) : ((!isset($this->user->profile_fields[$field_ident]) || $preview_options !== false) ? $default_value : $this->user->profile_fields[$field_ident]);

}

/**

abstract class type_string_common extends type_base

{

/**

* Return possible validation options

*/

{

$validate_options = '';

{

$selected = ($field_data['field_validation'] == $value) ? ' selected="selected"' : '';

$validate_options .= '<option value="' . $value . '"' . $selected . '>' . $this->user->lang[$lang] . '</option>';

$field_validate = ($field_type != 'text') ? $field_value : bbcode_nl2br($field_value);

if (!preg_match('#^' . str_replace('\\\\', '\\', $field_data['field_validation']) . '$#i', $field_validate))

{

{

}

}

}

/**

* {@inheritDoc}

*/

public function prepare_options_form(&$exclude_options, &$visibility_options)

{

$exclude_options[1][] = 'lang_default_value';

}

$this->db->sql_freeresult($result);

}

// now analyse the search query, first split it using the spaces

$query = explode(' ', $keywords);

$this->{$mode . '_ids'}[] = $words[$word];

}

}

{

if (!isset($common_ids[$word]))

{

$len = utf8_strlen($word);

{

$this->common_words[] = $word;

}

}

}

}

{

return true;

}

return false;

}

$must_contain_ids = $this->must_contain_ids;

$must_not_contain_ids = $this->must_not_contain_ids;

$must_exclude_one_ids = $this->must_exclude_one_ids;

array('sql_attr_uint', 'post_visibility'),

array('sql_attr_bool', 'topic_first_post'),

array('sql_attr_bool', 'deleted'),

),

'source source_phpbb_' . $this->id . '_delta : source_phpbb_' . $this->id . '_main' => array(

array('sql_query_pre', ''),

// We're adding a new iteration to this block with the given

// variable assignments.

$str[$blocks[$blockcount]][] = $vararray;

// Set S_NUM_ROWS

foreach ($str[$blocks[$blockcount]] as &$mod_block)

{

}

}

else

// Add a new iteration to this block with the variable assignments we were given.

$this->tpldata[$blockname][] = $vararray;

// Set S_NUM_ROWS

foreach ($this->tpldata[$blockname] as &$mod_block)

{

}

}

$total_match_count = $search->author_search($show_results, $firstpost_only, $sort_by_sql, $sort_key, $sort_dir, $sort_days, $ex_fid_ary, $m_approve_posts_fid_sql, $topic_id, $author_id_ary, $sql_author_match, $id_ary, $start, $per_page);

}

$sql_where = '';

if (sizeof($id_ary))

jQuery(document).ready(apply_onkeypress_event);

/**

* Functions for user search popup

*/

function insert_user(formId, value)

</div>

<!-- ENDIF -->

<!-- IF forumrow.S_IS_CAT or forumrow.S_FIRST_ROW or forumrow.S_NO_CAT -->

<div class="forabg">

<div class="inner">

</ul>

<ul class="topiclist forums">

<!-- ENDIF -->

<!-- IF not forumrow.S_IS_CAT -->

<li class="row">

<br /><strong>{forumrow.L_MODERATOR_STR}{L_COLON}</strong> {forumrow.MODERATORS}

<!-- ENDIF -->

<!-- IF .forumrow.subforum and forumrow.S_LIST_SUBFORUMS -->

<br /><strong>{forumrow.L_SUBFORUM_STR}</strong>

<!-- BEGIN subforum -->

<!-- END subforum -->

<!-- ENDIF -->

<!-- IF not S_IS_BOT -->

<p><!-- BEGIN return_links -->{return_links.MESSAGE_LINK}<br /><br /><!-- END return_links --></p>

</div>

<!-- ENDIF -->

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

<!-- INCLUDE simple_header.html -->

<h2 class="solo">{L_SEND_IM}</h2>

<div class="panel bg2">

<div class="inner">

<fieldset>

<dl class="fields2">

<dt><label>{L_IM_RECIPIENT}{L_COLON}</label></dt>

</dl>

<!-- IF S_SEND_JABBER -->

<dl class="fields2">

<dt><label for="message">{L_IM_MESSAGE}{L_COLON}</label></dt>

<dt>&nbsp;</dt>

<dd><input class="button1" name="submit" type="submit" value="{L_IM_SEND}" /></dd>

</dl>

<dl class="fields2">

<dt>&nbsp;</dt>

</dl>

<dl class="fields2">

<dt>&nbsp;</dt>

</dl>

<!-- ENDIF -->

{S_FORM_TOKEN}

</dl>

<!-- ENDIF -->

<dl>

<dt><label for="jabber">{L_JABBER}:</label></dt>

<dd><input type="text" name="jabber" id="jabber" value="{JABBER}" class="inputbox" /></dd>

</dl>

</fieldset>

<fieldset class="fields1 column2">

<dd><input class="inputbox medium" type="text" name="ip" id="ip" value="{IP}" /></dd>

</dl>

<!-- ENDIF -->

</fieldset>

<div class="clear"></div>

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

<!-- IF S_USER_LOGGED_IN and S_ZEBRA -->

<!-- IF U_REMOVE_FRIEND -->

<dt>&nbsp;</dt> <dd class="zebra"><a href="{U_REMOVE_FRIEND}" data-ajax="zebra"><strong>{L_REMOVE_FRIEND}</strong></a></dd>

<dl class="details">

<!-- IF U_EMAIL --><dt>{L_EMAIL_ADDRESS}{L_COLON}</dt> <dd><a href="{U_EMAIL}">{L_SEND_EMAIL_USER} {USERNAME}</a></dd><!-- ENDIF -->

<!-- IF U_PM --><dt>{L_PM}{L_COLON}</dt> <dd><a href="{U_PM}">{L_SEND_PRIVATE_MESSAGE}</a></dd><!-- ENDIF -->

<!-- IF U_JABBER and S_JABBER_ENABLED --><dt>{L_JABBER}{L_COLON}</dt> <dd><a href="{U_JABBER}" onclick="popup(this.href, 550, 320); return false;">{L_SEND_JABBER_MESSAGE}</a></dd><!-- ELSEIF USER_JABBER --><dt>{L_JABBER}{L_COLON}</dt> <dd>{USER_JABBER}</dd><!-- ENDIF -->

<!-- IF S_PROFILE_FIELD1 -->

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

<dt>{PROFILE_FIELD1_NAME}{L_COLON}</dt> <dd>{PROFILE_FIELD1_VALUE}</dd>

<!-- EVENT posting_editor_buttons_before -->

<div id="format-buttons">

<!-- IF S_BBCODE_QUOTE -->

<!-- ENDIF -->

<!-- IF S_BBCODE_IMG -->

<!-- ENDIF -->

<!-- IF S_LINKS_ALLOWED -->

<!-- ENDIF -->

<!-- IF S_BBCODE_FLASH -->

<!-- ENDIF -->

<option value="50">{L_FONT_TINY}</option>

<option value="85">{L_FONT_SMALL}</option>

<option value="100" selected="selected">{L_FONT_NORMAL}</option>

<!-- ENDIF -->

<!-- ENDIF -->

</select>

<!-- BEGIN custom_tags -->

<!-- END custom_tags -->

</div>

<!-- EVENT posting_editor_buttons_after -->

<!-- EVENT ucp_pm_viewmessage_custom_fields_before -->

<!-- BEGIN custom_fields -->

<!-- END custom_fields -->

<!-- EVENT ucp_pm_viewmessage_custom_fields_after -->

<dd>

<ul class="profile-icons">

<!-- IF U_PM --><li class="pm-icon"><a href="{U_PM}" title="{L_PRIVATE_MESSAGE}"><span>{L_PRIVATE_MESSAGE}</span></a></li><!-- ENDIF -->

<!-- IF U_EMAIL --><li class="email-icon"><a href="{U_EMAIL}" title="{L_SEND_EMAIL_USER} {MESSAGE_AUTHOR}"><span>{L_SEND_EMAIL_USER} {MESSAGE_AUTHOR}</span></a></li><!-- ENDIF -->

<!-- IF U_JABBER --><li class="jabber-icon"><a href="{U_JABBER}" onclick="popup(this.href, 550, 320); return false;" title="{L_JABBER}"><span>{L_JABBER}</span></a></li><!-- ENDIF -->

</ul>

</dd>

<!-- ENDIF -->

<fieldset>

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

<!-- IF S_BIRTHDAYS_ENABLED -->

<dl>

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

</dd>

</dl>

<!-- ENDIF -->

<!-- BEGIN profile_fields -->

<dl>

<dt><label<!-- IF profile_fields.FIELD_ID --> for="{profile_fields.FIELD_ID}"<!-- ENDIF -->>{profile_fields.LANG_NAME}{L_COLON}<!-- IF profile_fields.S_REQUIRED --> *<!-- ENDIF --></label>

<!-- EVENT viewtopic_body_postrow_custom_fields_before -->

<!-- BEGIN custom_fields -->

<!-- END custom_fields -->

<!-- EVENT viewtopic_body_postrow_custom_fields_after -->

<!-- IF not S_IS_BOT -->

<dd>

<ul class="profile-icons">

<!-- IF postrow.U_PM --><li class="pm-icon"><a href="{postrow.U_PM}" title="{L_PRIVATE_MESSAGE}"><span>{L_PRIVATE_MESSAGE}</span></a></li><!-- ENDIF -->

<!-- IF postrow.U_EMAIL --><li class="email-icon"><a href="{postrow.U_EMAIL}" title="{L_SEND_EMAIL_USER} {postrow.POST_AUTHOR}"><span>{L_SEND_EMAIL_USER} {postrow.POST_AUTHOR}</span></a></li><!-- ENDIF -->

<!-- IF postrow.U_JABBER --><li class="jabber-icon"><a href="{postrow.U_JABBER}" onclick="popup(this.href, 550, 320); return false;" title="{L_JABBER}"><span>{L_JABBER}</span></a></li><!-- ENDIF -->

</ul>

</dd>

<!-- ENDIF -->

padding-right: 11px;

padding-left: 0;

}

padding-right: 20px;

padding-left: 0;

}

/* Profile & navigation icons */

.email-icon, .email-icon a { background: none top left no-repeat; }

.aim-icon, .aim-icon a { background: none top left no-repeat; }

.yahoo-icon, .yahoo-icon a { background: none top left no-repeat; }

.web-icon, .web-icon a { background: none top left no-repeat; }

.msnm-icon, .msnm-icon a { background: none top left no-repeat; }

.icq-icon, .icq-icon a { background: none top left no-repeat; }

.jabber-icon, .jabber-icon a { background: none top left no-repeat; }

.pm-icon, .pm-icon a { background: none top left no-repeat; }

.quote-icon, .quote-icon a { background: none top left no-repeat; }

/* Set profile icon dimensions */

ul.profile-icons li.email-icon { width: 20px; height: 20px; }

ul.profile-icons li.aim-icon { width: 20px; height: 20px; }

ul.profile-icons li.yahoo-icon { width: 20px; height: 20px; }

ul.profile-icons li.web-icon { width: 20px; height: 20px; }

ul.profile-icons li.msnm-icon { width: 20px; height: 20px; }

ul.profile-icons li.icq-icon { width: 20px; height: 20px; }

ul.profile-icons li.jabber-icon { width: 20px; height: 20px; }

ul.profile-icons li.pm-icon { width: 28px; height: 20px; }

ul.profile-icons li.quote-icon { width: 54px; height: 20px; }

/* Profile & navigation icons */

.email-icon, .email-icon a { background-image: url("./images/icon_contact_email.gif"); }

.aim-icon, .aim-icon a { background-image: url("./images/icon_contact_aim.gif"); }

.yahoo-icon, .yahoo-icon a { background-image: url("./images/icon_contact_yahoo.gif"); }

.web-icon, .web-icon a { background-image: url("./images/icon_contact_www.gif"); }

.msnm-icon, .msnm-icon a { background-image: url("./images/icon_contact_msnm.gif"); }

.icq-icon, .icq-icon a { background-image: url("./images/icon_contact_icq.gif"); }

.jabber-icon, .jabber-icon a { background-image: url("./images/icon_contact_jabber.gif"); }

.pm-icon, .pm-icon a { background-image: url("./en/icon_contact_pm.gif"); }

.quote-icon, .quote-icon a { background-image: url("./en/icon_post_quote.gif"); }

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

.phpbb_alert {

border: 1px solid transparent;

display: none;

top: 150px;

z-index: 50;

}

@media only screen and (max-height: 500px), only screen and (max-device-width: 500px)

/* Friends list */

.cp-mini {

margin: 10px 15px 10px 5px;

padding: 5px 10px;

border-radius: 7px;

}

padding-left: 11px;

padding-top: 11px;

}

background-image: url("./images/icon_contact_aim.gif");

padding-left: 20px;

padding-top: 20px;

padding-left: 20px;

padding-top: 20px;

}

background-image: url("./images/icon_contact_icq.gif");

padding-left: 20px;

padding-top: 20px;

padding-left: 20px;

padding-top: 20px;

}

background-image: url("./images/icon_contact_msnm.gif");

padding-left: 20px;

padding-top: 20px;

}

background-image: url("./images/icon_contact_www.gif");

padding-left: 20px;

padding-top: 20px;

}

background-image: url("./images/icon_contact_yahoo.gif");

padding-left: 20px;

padding-top: 20px;

}

.phpbb_alert {

}

.attach-comment dfn {

<th>&nbsp;{L_LAST_POST}&nbsp;</th>

</tr>

<!-- BEGIN forumrow -->

<!-- IF forumrow.S_IS_CAT -->

<tr>

<td class="cat" colspan="2"><h4><a href="{forumrow.U_VIEWFORUM}">{forumrow.FORUM_NAME}</a></h4></td>

<td class="catdiv" colspan="3">&nbsp;</td>

</tr>

<!-- ELSEIF forumrow.S_IS_LINK -->

<tr>

<td class="row1" width="50" align="center">{forumrow.FORUM_FOLDER_IMG}</td>

<p class="forumdesc"><strong>{forumrow.L_MODERATOR_STR}{L_COLON}</strong> {forumrow.MODERATORS}</p>

<!-- ENDIF -->

<!-- IF .forumrow.subforum and forumrow.S_LIST_SUBFORUMS -->

<p class="forumdesc"><strong>{forumrow.L_SUBFORUM_STR}</strong>

<!-- BEGIN subforum -->

<!-- END subforum -->

</p>

<!-- ENDIF -->

</td>

<td class="row2" align="center"><p class="topicdetails">{forumrow.TOPICS}</p></td>

<br />

<!-- ENDIF -->

<th nowrap="nowrap" width="15%"><a href="{U_SORT_RANK}">{L_RANK}</a></th>

<th nowrap="nowrap" width="11%">{L_SEND_MESSAGE}</th>

<th nowrap="nowrap" width="11%"><a href="{U_SORT_EMAIL}">{L_EMAIL}</a></th>

<!-- IF S_IN_SEARCH_POPUP and not S_SELECT_SINGLE --><th width="2%" nowrap="nowrap">{L_MARK}</th><!-- ENDIF -->

</tr>

<!-- BEGIN memberrow -->

<td class="gen" align="center"><!-- IF memberrow.RANK_IMG -->{memberrow.RANK_IMG}<!-- ELSE -->{memberrow.RANK_TITLE}<!-- ENDIF --></td>

<td class="gen" align="center">&nbsp;<!-- IF memberrow.U_PM --><a href="{memberrow.U_PM}" class="imageset">{PM_IMG}</a><!-- ENDIF -->&nbsp;</td>

<td class="gen" align="center">&nbsp;<!-- IF memberrow.U_EMAIL --><a href="{memberrow.U_EMAIL}" class="imageset">{EMAIL_IMG}</a><!-- ENDIF -->&nbsp;</td>

<!-- IF memberrow.S_PROFILE_FIELD1 -->

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

<td class="gen" align="center">&nbsp;{memberrow.PROFILE_FIELD1_VALUE}</td>

<br clear="all" />

<form method="post" action="{S_IM_ACTION}">

<table class="tablebg" width="95%" cellspacing="1" cellpadding="4" border="0" align="center">

<tr>

</tr>

<tr>

<td class="row1"><b class="genmed">{L_IM_RECIPIENT}{L_COLON} </b></td>

</tr>

<!-- IF S_SEND_JABBER -->

<tr>

<td class="row1"><b class="genmed">{L_IM_MESSAGE}{L_COLON} </b></td>

<tr>

<td class="cat" colspan="2" align="center"><input class="btnmain" name="submit" type="submit" value="{L_IM_SEND}" /></td>

</tr>

<tr>

<td class="row1" colspan="2" align="center"><span class="gen">{L_IM_SENT_JABBER}</span></td>

</tr>

<tr>

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

</tr>

<!-- ENDIF -->

</table>

<tr>

<td class="row1"><b class="genmed">{L_USERNAME}{L_COLON}</b></td>

<td class="row2"><input class="post" type="text" name="username" value="{USERNAME}" /></td>

</tr>

<tr>

<td class="row1"><b class="genmed">{L_JOINED}{L_COLON}</b></td>

<td class="row2"><select name="joined_select">{S_JOINED_TIME_OPTIONS}</select> <input class="post" type="text" name="joined" value="{JOINED}" /></td>

</tr>

<!-- IF S_VIEWONLINE -->

<td class="row1"><b class="genmed">{L_LAST_ACTIVE}{L_COLON}</b></td>

<td class="row2"><select name="active_select">{S_ACTIVE_TIME_OPTIONS}</select> <input class="post" type="text" name="active" value="{ACTIVE}" /></td>

</tr>

<tr>

<td class="row1"><b class="genmed">{L_JABBER}{L_COLON}</b></td>

<td class="row2"><input class="post" type="text" name="jabber" value="{JABBER}" /></td>

</tr>

<tr>

<td class="row1"><b class="genmed">{L_SORT_BY}{L_COLON}</b></td>

<td class="row2" nowrap="nowrap"><select name="sk">{S_SORT_OPTIONS}</select> <select name="sd">{S_ORDER_SELECT}</select>&nbsp;</td>

</tr>

<tr>

<td class="cat" colspan="4" align="center"><input class="btnmain" type="submit" name="submit" value="{L_SEARCH}" />&nbsp;&nbsp;<input class="btnlite" type="reset" value="{L_RESET}" /></td>

</tr>

</tr>

<!-- ENDIF -->

<tr>

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

<td><!-- IF U_JABBER --><a href="{U_JABBER}" onclick="popup(this.href, 550, 320); return false" class="imageset">{JABBER_IMG}</a><!-- ELSEIF USER_JABBER -->{USER_JABBER_IMG}<!-- ENDIF --></td>

</tr>

</table>

</td>

<td class="row1">

<td><b class="genmed">{AGE}</b></td>

</tr>

<!-- ENDIF -->

<!-- IF S_PROFILE_FIELD1 -->

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

<tr>

</tr>

<!-- ENDIF -->

<!-- BEGIN custom_fields -->

<tr>

<td class="gen" align="{S_CONTENT_FLOW_END}" nowrap="nowrap">{custom_fields.PROFILE_FIELD_NAME}{L_COLON} </td>

<td><b class="genmed">{custom_fields.PROFILE_FIELD_VALUE}</b></td>

</tr>

<!-- END custom_fields -->

</table>

</td>

<!-- IF S_BBCODE_ALLOWED -->

<!-- EVENT posting_editor_buttons_before -->

<div id="core-bbcode-buttons">

<!-- IF S_BBCODE_QUOTE -->

<!-- ENDIF -->

<!-- IF S_BBCODE_IMG -->

<!-- ENDIF -->

<!-- IF S_LINKS_ALLOWED -->

<!-- ENDIF -->

<!-- IF S_BBCODE_FLASH -->

<!-- ENDIF -->

<option value="50">{L_FONT_TINY}</option>

<option value="85">{L_FONT_SMALL}</option>

<option value="100" selected="selected">{L_FONT_NORMAL}</option>

<td colspan="2">

<div id="custom-bbcode-buttons">

<!-- BEGIN custom_tags -->

<!-- END custom_tags -->

</div>

</td>

<td class="row1" colspan="2"><span class="gensmall">{L_PROFILE_INFO_NOTICE}</span></td>

</tr>

<tr>

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

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

<!-- EVENT viewtopic_body_postrow_custom_fields_before -->

<!-- BEGIN custom_fields -->

<br /><b>{postrow.custom_fields.PROFILE_FIELD_NAME}{L_COLON}</b> {postrow.custom_fields.PROFILE_FIELD_VALUE}

<!-- END custom_fields -->

<!-- EVENT viewtopic_body_postrow_custom_fields_after -->

</span>

/* EN Language Pack */

background-image: url("./icon_contact_aim.gif");

padding-left: 72px;

padding-top: 20px;

padding-left: 72px;

padding-top: 20px;

}

background-image: url("./icon_contact_icq.gif");

padding-left: 72px;

padding-top: 20px;

padding-left: 72px;

padding-top: 20px;

}

background-image: url("./icon_contact_msnm.gif");

padding-left: 72px;

padding-top: 20px;

padding-left: 72px;

padding-top: 20px;

}

background-image: url("./icon_contact_yahoo.gif");

padding-left: 72px;

padding-top: 20px;

}

background-image: url("./icon_contact_www.gif");

padding-left: 72px;

padding-top: 20px;

/* English images for fallback */

background-image: url("./en/icon_contact_aim.gif");

padding-left: 72px;

padding-top: 20px;

padding-left: 72px;

padding-top: 20px;

}

background-image: url("./en/icon_contact_icq.gif");

padding-left: 72px;

padding-top: 20px;

padding-left: 72px;

padding-top: 20px;

}

background-image: url("./en/icon_contact_msnm.gif");

padding-left: 72px;

padding-top: 20px;

padding-left: 72px;

padding-top: 20px;

}

background-image: url("./en/icon_contact_yahoo.gif");

padding-left: 72px;

padding-top: 20px;

}

background-image: url("./en/icon_contact_www.gif");

padding-left: 72px;

padding-top: 20px;

'SEARCH_IMG' => $user->img('icon_user_search', 'SEARCH_USER_POSTS'),

'PM_IMG' => $user->img('icon_contact_pm', 'SEND_PRIVATE_MESSAGE'),

'EMAIL_IMG' => $user->img('icon_contact_email', 'SEND_EMAIL'),

'JABBER_IMG' => $user->img('icon_contact_jabber', 'JABBER') ,

'REPORT_IMG' => $user->img('icon_post_report', 'REPORT_POST'),

'REPORTED_IMG' => $user->img('icon_topic_reported', 'POST_REPORTED'),

'profile' => '',

'pm' => '',

'email' => '',

'jabber' => '',

'search' => '',

'age' => '',

'online' => false,

'profile' => append_sid("{$phpbb_root_path}memberlist.$phpEx", "mode=viewprofile&amp;u=$poster_id"),

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

'search' => ($auth->acl_get('u_search')) ? append_sid("{$phpbb_root_path}search.$phpEx", "author_id=$poster_id&amp;sr=posts") : '',

$user_cache[$poster_id]['email'] = '';

}

if ($config['allow_birthdays'] && !empty($row['user_birthday']))

{

list($bday_day, $bday_month, $bday_year) = array_map('intval', explode('-', $row['user_birthday']));

$cp = $phpbb_container->get('profilefields.manager');

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

// filter out fields not to be displayed on viewtopic. Yes, it's a hack, but this shouldn't break any MODs.

$profile_fields_cache = array();

//

if ($config['load_cpf_viewtopic'])

{

}

$post_unread = (isset($topic_tracking_info[$topic_id]) && $row['post_time'] > $topic_tracking_info[$topic_id]) ? true : false;

'POST_ICON_IMG' => ($topic_data['enable_icons'] && !empty($row['icon_id'])) ? $icons[$row['icon_id']]['img'] : '',

'POST_ICON_IMG_WIDTH' => ($topic_data['enable_icons'] && !empty($row['icon_id'])) ? $icons[$row['icon_id']]['width'] : '',

'POST_ICON_IMG_HEIGHT' => ($topic_data['enable_icons'] && !empty($row['icon_id'])) ? $icons[$row['icon_id']]['height'] : '',

'ONLINE_IMG' => ($poster_id == ANONYMOUS || !$config['load_onlinetrack']) ? '' : (($user_cache[$poster_id]['online']) ? $user->img('icon_user_online', 'ONLINE') : $user->img('icon_user_offline', 'OFFLINE')),

'S_ONLINE' => ($poster_id == ANONYMOUS || !$config['load_onlinetrack']) ? false : (($user_cache[$poster_id]['online']) ? true : false),

'U_SEARCH' => $user_cache[$poster_id]['search'],

'U_PM' => ($poster_id != ANONYMOUS && $config['allow_privmsg'] && $auth->acl_get('u_sendpm') && ($user_cache[$poster_id]['allow_pm'] || $auth->acl_gets('a_', 'm_') || $auth->acl_getf_global('m_'))) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&amp;mode=compose&amp;action=quotepost&amp;p=' . $row['post_id']) : '',

'U_EMAIL' => $user_cache[$poster_id]['email'],

'U_JABBER' => $user_cache[$poster_id]['jabber'],

'U_APPROVE_ACTION' => append_sid("{$phpbb_root_path}mcp.$phpEx", "i=queue&amp;p={$row['post_id']}&amp;f=$forum_id&amp;redirect=" . urlencode(str_replace('&amp;', '&', $viewtopic_url . '&amp;p=' . $row['post_id'] . '#p' . $row['post_id']))),

'user_sig' => '',

'user_sig_bbcode_uid' => '',

'user_sig_bbcode_bitfield' => '',

'user_jabber' => '',

'user_actkey' => '',

'user_newpasswd' => '',

'user_form_salt' => '',

{

protected $search_backend = '\phpbb\search\fulltext_mysql';

}

class phpbb_functional_search_native_test extends phpbb_functional_search_base

{

protected $search_backend = '\phpbb\search\fulltext_native';

}

{

protected $search_backend = '\phpbb\search\fulltext_postgres';

}

array(

'-foo',

'all',

array(),

),

array(

'-foo -bar',

'all',

array(),

),

// all common

*

*/

class phpbb_security_hash_test extends phpbb_test_case

{