<!-- IF .pagination -->

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

<!-- ELSE -->

<!-- ENDIF -->

</div>

<!-- ENDIF -->

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

</div>

<!-- EVENT acp_users_signature_editor_buttons_after -->

<dt style="width: 90px;" id="color_palette_placeholder" data-orientation="v" data-height="12" data-width="15" data-bbcode="true">

</dt>

<dd style="margin-{S_CONTENT_FLOW_BEGIN}: 90px;"><textarea name="signature" rows="10" cols="60" style="width: 95%;" onselect="storeCaret(this);" onclick="storeCaret(this);" onkeyup="storeCaret(this);" onfocus="initInsertions();" data-bbcode="true">{SIGNATURE}</textarea></dd>

margin: 10px 15px;

}

img {

border: 0;

}

padding: 3px 8px 3px 3px;

}

#menu li a:hover, #menu li a:hover span {

text-decoration: none;

background-color: #FFFFFF;

table.responsive.styles td:first-child > dfn, table.responsive td.actions > dfn {

display: none !important;

}

}

/* General form styles

border-left: 1px solid #CCCCCC;

}

fieldset dd {

margin: 0 0 0 45%;

padding: 0 0 0 5px;

width: auto;

}

.ltr fieldset dd {

padding-left: 20px;

}

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;

}

}

<ul>

<!-- BEGIN pagination -->

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

numberList[3] = 'BF';

numberList[4] = 'FF';

for (r = 0; r < 5; r++) {

if (dir == 'h') {

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

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

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

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

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

- @config

- @user

- %core.root_path%

feed.factory:

class: phpbb\feed\factory

- @user

tags:

- { name: profilefield.type }

- @template

- @user

- @config

- %core.root_path%

- %core.php_ext%

- @service_container

- @template

cron.task_collection:

class: phpbb\di\service_collection

arguments:

arguments:

- @template

- @user

path_helper:

class: phpbb\path_helper

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

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

a post

viewtopic_topic_title_prepend

===

* 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

{

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

$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';

$phpEx = substr(strrchr(__FILE__, '.'), 1);

include($phpbb_root_path . 'common.' . $phpEx);

if (!$config['feed_enable'])

{

trigger_error('NO_FEED');

}

// Open Feed

$feed->open();

'title' => censor_text($title),

'category' => ($config['feed_item_statistics'] && !empty($row['forum_id'])) ? $board_url . '/viewforum.' . $phpEx . '?f=' . $row['forum_id'] : '',

'category_name' => ($config['feed_item_statistics'] && isset($row['forum_name'])) ? $row['forum_name'] : '',

'statistics' => '',

);

*/

class acp_attachments

{

function main($id, $mode)

{

global $db, $user, $auth, $template, $cache, $phpbb_container;

global $config, $phpbb_admin_path, $phpbb_root_path, $phpEx;

$user->add_lang(array('posting', 'viewtopic', 'acp/attachments'));

$error = $notify = array();

}

}

$template->assign_vars(array(

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

$attachments_per_page = (int) $config['topics_per_page'];

// Make sure $start is set to the last page if it exceeds the amount

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

$start = $pagination->validate_start($start, $attachments_per_page, $num_files);

}

/**

* Build Select for category items

*/

function category_select($select_name, $group_id = false, $key = '')

{

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

global $config, $phpbb_root_path, $phpbb_admin_path, $phpEx;

$user->add_lang('acp/board');

break;

}

if (isset($display_vars['lang']))

{

$user->add_lang($display_vars['lang']);

'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 . ' ' : '';

if ($submit)

{

{

if (!$auth->acl_get('a_userdel'))

{

trigger_error($user->lang['CANNOT_REMOVE_ANONYMOUS'] . adm_back_link($this->u_action . '&amp;u=' . $user_id), E_USER_WARNING);

}

if ($user_id == $user->data['user_id'])

{

trigger_error($user->lang['CANNOT_REMOVE_YOURSELF'] . adm_back_link($this->u_action . '&amp;u=' . $user_id), E_USER_WARNING);

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

return $this->random_colour($colour, $mode);

}

$resource = imagecolorallocate($this->img, $rgb[0], $rgb[1], $rgb[2]);

$this->colours[$resource] = $store;

$resource = $pre;

}

$results = ($include_original) ? array($resource) : array();

$colour2 = $colour3 = $colour4 = $colour;

$colour2[0] += 150;

$resource = $pre;

}

$results = array();

if ($include_original)

switch ($from_model)

{

case 'ahsv':

break;

case 'rgb':

break;

}

break;

switch ($from_model)

{

case 'hsv':

break;

case 'rgb':

break;

}

break;

switch ($from_model)

{

case 'hsv':

break;

case 'ahsv':

break;

}

break;

*/

function hsv2rgb($hsv)

{

$h = $hsv[0];

$s = min(1, max(0, $hsv[1] / 100));

break;

}

}

return array($h, $s * 100, $v * 100);

}

{

if (is_array($ahue))

{

return $ahue;

}

// blue through red is already ok

if ($ahue >= 240)

{

if (is_array($hue))

{

return $hue;

}

// blue through red is already ok

if ($hue >= 240)

'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_password' => array('VCHAR_UNI', ''),

'user_passchg' => array('TIMESTAMP', 0),

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

'user_email' => array('VCHAR_UNI:100', ''),

'user_email_hash' => array('BINT', 0),

'user_birthday' => array('VCHAR:10', ''),

'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

/**

*/

function build_url($strip_vars = false)

{

$page = $user->page['page'];

// URL

if ($url_parts === false || empty($url_parts['scheme']) || empty($url_parts['host']))

{

$page = $phpbb_root_path . $page;

}

}

// Determine first occurrence, since in values the equal sign is allowed

$value = trim(substr($line, $delim_pos + 1));

if (in_array($value, array('off', 'false', '0')))

}

else if (($value[0] == "'" && $value[sizeof($value) - 1] == "'") || ($value[0] == '"' && $value[sizeof($value) - 1] == '"'))

{

}

$parsed_items[$key] = $value;

'S_TOPIC_ID' => $topic_id,

'S_LOGIN_ACTION' => ((!defined('ADMIN_START')) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=login') : append_sid("{$phpbb_admin_path}index.$phpEx", false, true, $user->session_id)),

'S_ENABLE_FEEDS' => ($config['feed_enable']) ? true : false,

'S_ENABLE_FEEDS_OVERALL' => ($config['feed_overall']) ? true : false,

*/

function delete_posts($where_type, $where_ids, $auto_sync = true, $posted_sync = true, $post_count_sync = true, $call_delete_topics = true)

{

if ($where_type === 'range')

{

delete_attachments('post', $post_ids, false);

$db->sql_transaction('commit');

// Resync topics_posted table

if ($posted_sync)

{

$phpbb_notifications = $phpbb_container->get('notification_manager');

return sizeof($post_ids);

}

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

);

*/

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

if (!$this->jabber->connect())

{

continue 2;

}

if (!$this->jabber->login())

{

continue 2;

}

if (!$result)

{

continue 2;

}

break;

{

if ($this->jabber->send_message($address, $msg, $subject) === false)

{

continue 3;

}

}

// Clean up module cache array to only let survive modules the user can access

$right_id = false;

foreach ($this->module_cache['modules'] as $key => $row)

{

// Not allowed to view module?

if (!$this->module_auth_self($row['module_auth']))

{

$right_id = $row['right_id'];

continue;

}

}

// Re-index (this is needed, else we are not able to array_slice later)

if ($this->active_module === false)

{

}

// new modules use the full class names, old ones are always called <type>_<name>, e.g. acp_board

{

if (!file_exists("$module_path/{$this->p_name}.$phpEx"))

{

}

include("$module_path/{$this->p_name}.$phpEx");

if (!class_exists($this->p_name))

{

}

}

{

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

// We do not handle erasing posts here

if ($mode == 'delete')

{

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

);

return $return;

}

}

// Init some needed values

return;

}

}

// Init some needed values

return;

}

*/

function phpbb_create_dumped_url_matcher(\phpbb\extension\finder $finder, $root_path, $php_ext)

{

$dumper = new PhpMatcherDumper($routes);

$cached_url_matcher_dump = $dumper->dump(array(

'class' => 'phpbb_url_matcher',

*/

function phpbb_create_url_matcher(\phpbb\extension\finder $finder, RequestContext $context, $root_path)

{

return new UrlMatcher($routes, $context);

}

{

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)

else if ($action == 'view_message')

{

$template->assign_vars(array(

if (!$msg_id)

{

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

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

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

user_passchg INTEGER DEFAULT 0 NOT NULL,

user_pass_convert INTEGER DEFAULT 0 NOT NULL,

user_email VARCHAR(100) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

user_email_hash DOUBLE PRECISION DEFAULT 0 NOT NULL,

user_birthday VARCHAR(10) CHARACTER SET NONE 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_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_password] [varchar] (255) DEFAULT ('') NOT NULL ,

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

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

[user_email] [varchar] (100) DEFAULT ('') NOT NULL ,

[user_email_hash] [float] DEFAULT (0) NOT NULL ,

[user_birthday] [varchar] (10) DEFAULT ('') NOT NULL ,

[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_password blob NOT NULL,

user_passchg int(11) UNSIGNED DEFAULT '0' NOT NULL,

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

user_email blob NOT NULL,

user_email_hash bigint(20) DEFAULT '0' NOT NULL,

user_birthday varbinary(10) DEFAULT '' NOT NULL,

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

user_passchg int(11) UNSIGNED DEFAULT '0' NOT NULL,

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

user_email varchar(100) DEFAULT '' NOT NULL,

user_email_hash bigint(20) DEFAULT '0' NOT NULL,

user_birthday varchar(10) DEFAULT '' NOT NULL,

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

user_passchg number(11) DEFAULT '0' NOT NULL,

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

user_email varchar2(300) DEFAULT '' ,

user_email_hash number(20) DEFAULT '0' NOT NULL,

user_birthday varchar2(10) DEFAULT '' ,

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

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

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

user_email varchar(100) DEFAULT '' NOT NULL,

user_email_hash INT8 DEFAULT '0' NOT NULL,

user_birthday varchar(10) DEFAULT '' NOT NULL,

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

user_passchg INTEGER UNSIGNED NOT NULL DEFAULT '0',

user_pass_convert INTEGER UNSIGNED NOT NULL DEFAULT '0',

user_email varchar(100) NOT NULL DEFAULT '',

user_email_hash bigint(20) NOT NULL DEFAULT '0',

user_birthday varchar(10) NOT NULL DEFAULT '',

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

'DEFAULT_LANGUAGE' => 'Default language',

'DEFAULT_STYLE' => 'Default style',

'DISABLE_BOARD' => 'Disable board',

'DISPLAY_LAST_SUBJECT' => 'Display subject of last added post on forum list',

'DISPLAY_LAST_SUBJECT_EXPLAIN' => 'The subject of the last added post will be displayed in the forum list with a hyperlink to the post. Subjects from password protected forums and forums in which user doesn’t have read access are not shown.',

'OVERRIDE_STYLE' => 'Override user style',

'ACP_CAT_CUSTOMISE' => 'Customise',

'ACP_CAT_DATABASE' => 'Database',

'ACP_CAT_FORUMS' => 'Forums',

'ACP_CAT_GENERAL' => 'General',

'ACP_CAT_MAINTENANCE' => 'Maintenance',

'ACP_EMAIL_SETTINGS' => 'Email settings',

'ACP_EXTENSION_GROUPS' => 'Manage attachment extension groups',

'ACP_EXTENSION_MANAGEMENT' => 'Extension management',

'ACP_FORUM_BASED_PERMISSIONS' => 'Forum based permissions',

'RESYNC' => 'Resynchronise',

'RESYNC_FILES_STATS' => 'Resynchronise files statistics',

'RESYNC_FILES_STATS_EXPLAIN' => 'Recalculates the total number and size of files attached to posts and private messages.',

'SELECT_ANONYMOUS' => 'Select anonymous user',

'SELECT_OPTION' => 'Select option',

'ACL_NEVER' => 'Never',

'ACL_SET' => 'Setting permissions',

'ACL_SETTING' => 'Setting',

'ACL_TYPE_A_' => 'Administrative permissions',

'ADD_USERS' => 'Add users',

'ADVANCED_PERMISSIONS' => 'Advanced Permissions',

'ALL_GROUPS' => 'Select all groups',

'ALL_USERS' => 'Select all users',

'APPLY_ALL_PERMISSIONS' => 'Apply all permissions',

'APPLY_PERMISSIONS' => 'Apply permissions',

'APPLY_PERMISSIONS_EXPLAIN' => 'The permissions and role defined for this item will only be applied to this item and all checked items.',

'NO_AUTH_SETTING_FOUND' => 'Permission settings not defined.',

'NO_ROLE_ASSIGNED' => 'No role assigned…',

'NO_ROLE_AVAILABLE' => 'No role available',

'NO_ROLE_NAME_SPECIFIED' => 'Please give the role a name.',

'NO_ROLE_SELECTED' => 'Role could not be found.',

'ROLE_DESCRIPTION_FORUM_POLLS' => 'Like Standard Access but can also create polls.',

'ROLE_DESCRIPTION_FORUM_READONLY' => 'Can read the forum, but cannot create new topics or reply to posts.',

'ROLE_DESCRIPTION_FORUM_STANDARD' => 'Can use most forum features including attachments and deleting own topics, but cannot lock own topics, and cannot create polls.',

'ROLE_DESCRIPTION_MOD_FULL' => 'Can use all moderating features, including banning.',

'ROLE_DESCRIPTION_MOD_QUEUE' => 'Can use the Moderation Queue to validate and edit posts, but nothing else.',

'ROLE_DESCRIPTION_MOD_SIMPLE' => 'Can only use basic topic actions. Cannot send warnings or use moderation queue.',

'ROLE_DESCRIPTION_USER_NOAVATAR' => 'Has a limited feature set and is not allowed to use the Avatar feature.',

'ROLE_DESCRIPTION_USER_NOPM' => 'Has a limited feature set, and is not allowed to use Private Messages.',

'ROLE_DESCRIPTION_USER_STANDARD' => 'Can access most but not all user features. Cannot change user name or ignore the flood limit, for instance.',

'ROLE_DESCRIPTION_EXPLAIN' => 'You are able to enter a short explanation of what the role is doing or for what it is meant for. The text you enter here will be displayed within the permissions screens too.',

'ROLE_DESCRIPTION_LONG' => 'The role description is too long, please limit it to 4000 characters.',

'SET_USERS_PERMISSIONS' => 'Set user permissions',

'SET_USERS_FORUM_PERMISSIONS' => 'Set user forum permissions',

'TRACE_FOR' => 'Trace for',

'TRACE_GLOBAL_SETTING' => '%s (global)',

'TRACE_PERMISSION' => 'Trace permission - %s',

'TRACE_RESULT' => 'Trace result',

'TRACE_SETTING' => 'Trace setting',

'TRACE_WHO' => 'Who',

'TRACE_TOTAL' => 'Total',

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

'CANNOT_FORCE_REACT_FOUNDER' => 'You are not allowed to force reactivation on founder accounts.',

'CANNOT_FORCE_REACT_YOURSELF' => 'You are not allowed to force reactivation of your own account.',

'CANNOT_REMOVE_ANONYMOUS' => 'You are not able to remove the guest user account.',

'CANNOT_REMOVE_YOURSELF' => 'You are not allowed to remove your own user account.',

'CANNOT_SET_FOUNDER_IGNORED' => 'You are not able to promote ignored users to be founders.',

'CANNOT_SET_FOUNDER_INACTIVE' => 'You need to activate users before you promote them to founders, only activated users are able to be promoted.',

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

'MODERATOR' => 'Moderator',

'MODERATORS' => 'Moderators',

'MONTH' => 'Month',

'MOVE' => 'Move',

'NA' => 'N/A',

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

'RETURN_FORUM' => '%sReturn to the forum last visited%s',

'RETURN_PAGE' => '%sReturn to the previous page%s',

'RETURN_TOPIC' => '%sReturn to the topic last visited%s',

'FEED' => 'Feed',

'FEED_NEWS' => 'News',

'FEED_TOPICS_ACTIVE' => 'Active Topics',

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

'TIMEZONE' => 'Timezone',

'TIMEZONE_DATE_SUGGESTION' => 'Suggestion: %s',

'TIMEZONE_INVALID' => 'The timezone you selected is invalid.',

'TOO_MANY_RECIPIENTS' => 'You tried to send a private message to too many recipients.',

'TOO_MANY_REGISTERS' => 'You have exceeded the maximum number of registration attempts for this session. Please try again later.',

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

break;

default:

break;

}

}

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

if (!$force_update_all && $original_topic_data['topic_delete_time'] && $original_topic_data['topic_visibility'] == ITEM_DELETED && $visibility == ITEM_APPROVED)

{

// If we're restoring a topic we only restore posts, that were soft deleted through the topic soft deletion.

}

else if (!$force_update_all && $original_topic_data['topic_visibility'] == ITEM_APPROVED && $visibility == ITEM_DELETED)

{

// If we're soft deleting a topic we only approved posts are soft deleted.

}

else

{

}

return $data;

namespace phpbb\controller;

use Symfony\Component\HttpFoundation\Response;

/**

* Controller helper class, contains methods that do things for controllers

* Constructor

*

* @param \phpbb\template\template $template Template object

* @param string $phpbb_root_path phpBB root path

* @param string $php_ext PHP extension

*/

{

$this->template = $template;

$this->user = $user;

$this->config = $config;

$this->phpbb_root_path = $phpbb_root_path;

$this->php_ext = $php_ext;

}

/**

}

/**

*

* @param bool $is_amp Is url using &amp; (true) or & (false)

* @param string $session_id Possibility to use a custom session id instead of the global one

* @return string The URL already passed through append_sid()

*/

{

{

}

// If enable_mod_rewrite is false, we need to include app.php

$route_prefix .= 'app.' . $this->php_ext . '/';

}

}

/**

protected $routing_files;

/**

* Construct method

*

* @param array() $routing_files Array of strings containing paths

* to YAML files holding route information

*/

{

$this->routing_files = $routing_files;

}

/**

*

* @param string $base_path Base path to prepend to file paths

*/

public function find($base_path = '')

{

foreach ($this->routing_files as $file_path)

{

$loader = new YamlFileLoader(new FileLocator($base_path));

}

}

}

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

);

}

/** @var \phpbb\cache\service */

protected $cache;

protected $db;

/** @var \phpbb\user */

* Constructor

*

* @param \phpbb\db\driver\driver $db

* @param \phpbb\user $user

* @param string $phpbb_root_path

* @param string $php_ext

* )

* Optionally you may not send 'modes' and it will insert all of the

* modules in that info file.

* path, specify that here

* @return null

*/

{

// Allows '' to be sent as 0

$parent = $parent ?: 0;

* @param int|string|bool $parent The parent module_id|module_langname(0 for no parent).

* Use false to ignore the parent check and check class wide.

* @param int|string $module The module id|module_langname

* specify that here

* @return null

*/

{

// Imitation of module_add's "automatic" and "manual" method so the uninstaller works from the same set of instructions for umil_auto

if (is_array($module))

if (isset($module['module_langname']))

{

// Manual Method

}

// Failed.

$module_ids[] = (int) $module_id;

}

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

}

else

{

}

if (!class_exists('acp_modules'))

/** @var \phpbb\cache\service */

protected $cache;

protected $db;

/** @var string */

* Constructor

*

* @param \phpbb\db\driver\driver $db

* @param \phpbb\auth\auth $auth

* @param string $phpbb_root_path

* @param string $php_ext

}

$this->sql = array(

'u.username, u.user_id',

'FROM' => array(

POSTS_TABLE => 'p',

/** @var string */

protected $phpbb_root_path;

/**

* Constructor

*

* @param string $phpbb_root_path Root path

* @return null

*/

{

$this->config = $config;

$this->user = $user;

$this->phpbb_root_path = $phpbb_root_path;

}

/**

/**

* Generate text content

*/

{

if (empty($content))

{

// Remove some specials html tag, because somewhere there are a mod to allow html tags ;)

$content = preg_replace( '#<(script|iframe)([^[]+)\1>#siU', ' <strong>$1</strong> ', $content);

// Remove Comments from inline attachments [ia]

// Replace some entities with their unicode counterpart

$entities = array(

$this->sql = array(

'SELECT' => 'f.forum_id, f.forum_name,

t.topic_id, t.topic_title, t.topic_poster, t.topic_first_poster_name, t.topic_posts_approved, t.topic_posts_unapproved, t.topic_posts_softdeleted, t.topic_views, t.topic_time, t.topic_last_post_time,

'FROM' => array(

TOPICS_TABLE => 't',

POSTS_TABLE => 'p',

// Get the actual data

$this->sql = array(

'SELECT' => 'f.forum_id, f.forum_name, ' .

'u.username, u.user_id',

'FROM' => array(

USERS_TABLE => 'u',

abstract class post_base extends \phpbb\feed\base

{

var $num_items = 'feed_limit_post';

function set_keys()

{

. (($this->is_moderator_approve_forum($row['forum_id']) && $row['post_visibility'] !== ITEM_APPROVED) ? ' ' . $this->separator_stats . ' ' . $this->user->lang['POST_UNAPPROVED'] : '');

}

}

}

function get_sql()

{

$this->sql = array(

'u.username, u.user_id',

'FROM' => array(

POSTS_TABLE => 'p',

$this->sql = array(

'SELECT' => 'f.forum_id, f.forum_name,

t.topic_id, t.topic_title, t.topic_poster, t.topic_first_poster_name, t.topic_posts_approved, t.topic_posts_unapproved, t.topic_posts_softdeleted, t.topic_views, t.topic_time, t.topic_last_post_time,

'FROM' => array(

TOPICS_TABLE => 't',

POSTS_TABLE => 'p',

'SELECT' => 'f.forum_id, f.forum_name,

t.topic_id, t.topic_title, t.topic_posts_approved, t.topic_posts_unapproved, t.topic_posts_softdeleted, t.topic_views,

t.topic_last_poster_id, t.topic_last_poster_name, t.topic_last_post_time,

'FROM' => array(

TOPICS_TABLE => 't',

POSTS_TABLE => 'p',

WHERE user_type = ' . USER_FOUNDER;

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

{

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

}

*

* @param \phpbb\template\template $template

* @param \phpbb\user $user

*/

{

$this->template = $template;

$this->user = $user;

}

/**

*/

protected function generate_page_link($base_url, $on_page, $start_name, $per_page)

{

{

}

else

{

$tpl_prefix = ($tpl_prefix == 'PAGINATION') ? '' : $tpl_prefix . '_';

$template_array = array(

$tpl_prefix . 'PER_PAGE' => $per_page,

'U_' . $tpl_prefix . 'PREVIOUS_PAGE' => ($on_page != 1) ? $u_previous_page : '',

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

}

/**

*/

{

{

{

{

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

$sql_where_options .= $sql_match_where;

$tmp_sql_match = array();

$this->db->sql_transaction('begin');