- 5.3

- 5.4

- 5.5

- hhvm

env:

- DB=mysql

services:

- redis-server

install:

- sh -c "if [ '$DB' = 'mariadb' ]; then travis/setup-mariadb.sh; fi"

- sh -c "if [ `php -r "echo (int) version_compare(PHP_VERSION, '5.3.19', '>=');"` = "1" ]; then travis/setup-webserver.sh; fi"

- cd phpBB

- php ../composer.phar install --dev --no-interaction --prefer-source

- cd ..

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

- php: hhvm

<project name="phpBB" description="The phpBB forum software" default="all" basedir="../">

<!-- a few settings for the build -->

<!-- no configuration should be needed beyond this point -->

<property name="oldversions" value="${olderversions}, ${prevversion}" />

<property name="dir" value="build/old_versions/release-${version}" />

</phingcall>

../new_version/patches/phpBB-${version}_to_${newversion}.patch" escape="false" />

</target>

<exec dir="build" command="php -f package.php '${versions}' > logs/package.log" escape="false" />

<exec dir="build" escape="false"

command="diff -crNEBwd old_versions/release-${prevversion}/language new_version/phpBB3/language >

<exec dir="build" escape="false"

command="diff -crNEBwd old_versions/release-${prevversion}/styles/prosilver new_version/phpBB3/styles/prosilver >

<exec dir="build" escape="false"

command="diff -crNEBwd old_versions/release-${prevversion}/styles/subsilver2 new_version/phpBB3/styles/subsilver2 >

<exec dir="build" escape="false"

command="git shortlog --summary --numbered release-${prevversion}...HEAD >

<exec dir="build" escape="false"

command="git diff --stat release-${prevversion}...HEAD >

<phingcall target="checksum-dir">

<property name="dir" value="build/new_version/release_files" />

<!-- Method arguments with default values MUST go at the end of the argument list. -->

<rule ref="PEAR.Functions.ValidDefaultValue" />

<!-- In the argument list, there MUST NOT be a space before each comma,

and there MUST be one space after each comma. -->

<rule ref="Squiz.Functions.FunctionDeclarationArgumentSpacing">

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

<!-- IF .pagination -->

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

<!-- ELSE -->

<!-- ENDIF -->

<!-- ENDIF -->

</div>

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

<!-- ENDIF -->

</tbody>

</table>

<!-- INCLUDE overall_footer.html -->

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

</dl>

<dl>

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

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

</dl>

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

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;

}

}

}*/

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

overflow: hidden;

}

<script type="text/javascript">

// <![CDATA[

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

var per_page = '{PER_PAGE}';

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

<ul>

<!-- BEGIN pagination -->

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

<script type="text/javascript">

// <![CDATA[

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

var per_page = '{PER_PAGE}';

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

numberList[3] = 'BF';

numberList[4] = 'FF';

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

if (dir == 'h') {

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

*/

function storeCaret(textEl) {

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

}

}

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

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

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

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

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

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

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

row.slideUp(100, function() {

row.remove();

phpbb.plupload.hideEmptyList();

* Fires when an error occurs.

*/

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

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

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

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

arguments:

- @dbal.conn

- @config

- @request

- @user

- %tables.auth_provider_oauth_token_storage%

- @config

- @user

- %core.root_path%

feed.factory:

class: phpbb\feed\factory

- %core.php_ext%

- %core.table_prefix%

- @migrator.tool_collection

migrator.tool_collection:

class: phpbb\di\service_collection

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

<ol>

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

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

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

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

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

<div class="content">

<h4>Bug</h4>

<ul>

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

</ul>

<h4>Bug</h4>

<ul>

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

</ul>

<h4>Bug</h4>

<ul>

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

</ul>

<h4>Bug</h4>

<ul>

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

</ul>

<h4>Bug</h4>

<ul>

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

</ul>

<h4> Bug

</h4>

</ul>

<h4> Security

</h4>

<ul>

</ul>

<ul>

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

</ul>

<ul>

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

</ul>

<ul>

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

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

</ul>

<ul>

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

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

</ul>

<ul>

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

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

</ul>

<ul>

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

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

</ul>

<ul>

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

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

</ul>

<ul>

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

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

</ul>

<ul>

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

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

</ul>

<ul>

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

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

</ul>

<ul>

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

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

</ul>

<ul>

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

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

</ul>

<ul>

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

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

</ul>

<ul>

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

</ul>

<ul>

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

</ul>

<ul>

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

* Since: 3.1.0-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:

* Since: 3.1.0-a2

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

simple_footer_after

===

* Locations:

===

* Locations:

+ styles/prosilver/template/ucp_pm_viewmessage_print.html

* Since: 3.1.0-a1

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

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

Display Options screen

viewtopic_print_head_append

===

* Locations:

+ styles/prosilver/template/viewtopic_print.html

* Since: 3.1.0-a1

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

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

a post

viewtopic_topic_title_prepend

===

* Locations:

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

'TOTAL_FILES' => $num_files,

'TOTAL_SIZE' => get_formatted_filesize($total_size),

'S_LIMIT_DAYS' => $s_limit_days,

'S_SORT_KEY' => $s_sort_key,

'S_SORT_DIR' => $s_sort_dir)

}

/**

* Build Select for category items

*/

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

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

'S_ACTION_OPTIONS' => $s_action_options,

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

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

'S_LIMIT_DAYS' => $s_limit_days,

'S_SORT_KEY' => $s_sort_key,

'S_SORT_DIR' => $s_sort_dir,

'USERS_PER_PAGE' => $per_page,

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

'L_EXPLAIN' => $l_title_explain,

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

'S_LIMIT_DAYS' => $s_limit_days,

'S_SORT_KEY' => $s_sort_key,

'S_SORT_DIR' => $s_sort_dir,

'field_show_on_reg' => 0,

'field_show_on_pm' => 0,

'field_show_on_vt' => 0,

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

'lang_explain' => '',

'lang_default_value'=> '')

// $exclude contains the data we gather in each step

$exclude = array(

2 => array('field_length', 'field_maxlen', 'field_minlen', 'field_validation', 'field_novalue', 'field_default_value'),

3 => array('l_lang_name', 'l_lang_explain', 'l_lang_default_value', 'l_lang_options')

);

'field_show_on_reg',

'field_show_on_pm',

'field_show_on_vt',

'field_show_profile',

'field_hide',

);

$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_SHOW_ON_REG' => ($cp->vars['field_show_on_reg']) ? true : false,

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

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

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

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

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

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

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

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

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

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

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

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

);

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

$template->assign_vars(array(

'S_FEEDBACK' => true,

'S_LIMIT_DAYS' => $s_limit_days,

'S_SORT_KEY' => $s_sort_key,

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

$template->assign_vars(array(

'S_ATTACHMENTS' => true,

'S_SORT_KEY' => $s_sort_key,

'S_SORT_DIR' => $s_sort_dir,

));

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)

*/

// phpBB Version

// QA-related

// define('PHPBB_QA', 1);

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

// Additional tables

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

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

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

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

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

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

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

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

),

'PRIMARY_KEY' => 'field_id',

'KEYS' => array(

$schema_data['phpbb_profile_fields_data'] = array(

'COLUMNS' => array(

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

),

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

}

}

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

{

}

}

function generate_smilies($mode, $forum_id)

{

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

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

if ($mode == 'window')

'body' => 'posting_smilies.html')

);

}

$display_link = false;

{

$template->assign_vars(array(

'S_SHOW_SMILEY_LINK' => true,

}

if ($mode == 'window')

{

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

// We do not handle erasing posts here

if ($mode == 'delete')

{

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

}

'user_lastpage' => '',

'user_posts' => 0,

'user_colour' => '',

'user_avatar' => '',

'user_avatar_type' => '',

'user_avatar_width' => 0,

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

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

));

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

$template->assign_vars(array(

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

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

{

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

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

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

mcp_restore_topic($topic_ids);

break;

}

switch ($mode)

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

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

'RANK_TITLE' => $rank_title,

'S_MCP_ACTION' => $this->u_action,

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

'TOTAL' => $total,

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

)

'S_TOPICS' => $is_topics,

'S_RESTORE' => $is_restore,

'TOPIC_ID' => $topic_id,

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

));

'S_FORUM_OPTIONS' => $forum_options,

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

'TOPIC_ID' => $topic_id,

'TOTAL' => $total,

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

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

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

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

));

}

'S_SELECT_SORT_KEY' => $s_sort_key,

'S_SELECT_SORT_DAYS' => $s_limit_days,

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

));

}

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

$template->assign_vars(array(

'TOTAL_ATTACHMENTS' => $num_attachments,

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

$template->assign_vars(array(

'S_LIST' => true,

'S_ACTION_OPTIONS' => $s_action_options,

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

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

'POSTS_DAY' => $user->lang('POST_DAY', $posts_per_day),

'POSTS_PCT' => $user->lang('POST_PCT', $percentage),

// 'S_GROUP_OPTIONS' => $group_options,

'U_SEARCH_USER' => ($auth->acl_get('u_search')) ? append_sid("{$phpbb_root_path}search.$phpEx", 'author_id=' . $user->data['user_id'] . '&amp;sr=posts') : '',

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

$template->assign_vars(array(

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

));

}

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

$template->assign_vars(array(

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

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

));

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

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

$template->assign_vars(array(

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

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

{

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

}

// Assign TO/BCC Addresses to template

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

{

}

}

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

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

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

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

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

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

function main($id, $mode)

{

global $config, $phpbb_root_path, $phpEx;

if (!$config['allow_password_reset'])

{

$convertor_data = array(

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

'version' => '1.0.3',

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

'dbms' => $dbms,

'dbhost' => $dbhost,

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

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

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

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

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

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

),

),

);

}

$this->error('Unable to access the language directory', __LINE__, __FILE__);

}

while (($file = readdir($dir)) !== false)

{

$path = $phpbb_root_path . 'language/' . $file;

$db->sql_query('INSERT INTO ' . LANG_TABLE . ' ' . $db->sql_build_array('INSERT', $lang_pack));

if ($db->sql_error_triggered)

{

$error = $db->sql_error($db->sql_error_sql);

}

}

closedir($dir);

}

/**

field_show_on_reg INTEGER DEFAULT 0 NOT NULL,

field_show_on_pm INTEGER DEFAULT 0 NOT NULL,

field_show_on_vt INTEGER DEFAULT 0 NOT NULL,

field_show_profile INTEGER DEFAULT 0 NOT NULL,

field_hide INTEGER DEFAULT 0 NOT NULL,

field_no_view INTEGER DEFAULT 0 NOT NULL,

field_active INTEGER DEFAULT 0 NOT NULL,

);;

ALTER TABLE phpbb_profile_fields ADD PRIMARY KEY (field_id);;

# Table: 'phpbb_profile_fields_data'

CREATE TABLE phpbb_profile_fields_data (

);;

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_show_on_reg] [int] DEFAULT (0) NOT NULL ,

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

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

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

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

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

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

) ON [PRIMARY]

GO

Table: 'phpbb_profile_fields_data'

*/

CREATE TABLE [phpbb_profile_fields_data] (

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

forum_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL,

forum_desc_uid varbinary(8) DEFAULT '' NOT NULL,

forum_link blob NOT NULL,

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

forum_image varbinary(255) DEFAULT '' NOT NULL,

forum_rules blob NOT NULL,

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

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

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

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

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

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

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)

# Table: 'phpbb_profile_fields_data'

CREATE TABLE phpbb_profile_fields_data (

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

PRIMARY KEY (user_id)

);

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

username blob NOT NULL,

username_clean 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_show_on_reg tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

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

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

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

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

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

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)

# Table: 'phpbb_profile_fields_data'

CREATE TABLE phpbb_profile_fields_data (

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

PRIMARY KEY (user_id)

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

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

forum_desc_options number(11) DEFAULT '7' NOT NULL,

forum_desc_uid varchar2(8) DEFAULT '' ,

forum_link varchar2(765) DEFAULT '' ,

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

forum_image varchar2(255) DEFAULT '' ,

forum_rules clob DEFAULT '' ,

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

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

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

)

/

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

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

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

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

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

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

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)

)

/

*/

CREATE TABLE phpbb_profile_fields_data (

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

CONSTRAINT pk_phpbb_profile_fields_data PRIMARY KEY (user_id)

)

/

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

username varchar2(255) DEFAULT '' ,

username_clean varchar2(255) 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_show_on_reg INT2 DEFAULT '0' NOT NULL CHECK (field_show_on_reg >= 0),

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

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

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

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

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

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)

);

*/

CREATE TABLE phpbb_profile_fields_data (

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

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

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

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

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

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

INSERT INTO phpbb_forums (forum_name, forum_desc, left_id, right_id, parent_id, forum_type, forum_posts_approved, forum_posts_unapproved, forum_posts_softdeleted, forum_topics_approved, forum_topics_unapproved, forum_topics_softdeleted, forum_last_post_id, forum_last_poster_id, forum_last_poster_name, forum_last_poster_colour, forum_last_post_subject, forum_last_post_time, forum_link, forum_password, forum_image, forum_rules, forum_rules_link, forum_rules_uid, forum_desc_uid, prune_days, prune_viewed, forum_parents, forum_flags) VALUES ('{L_FORUMS_TEST_FORUM_TITLE}', '{L_FORUMS_TEST_FORUM_DESC}', 2, 3, 1, 1, 1, 0, 0, 1, 0, 0, 1, 2, 'Admin', 'AA0000', '{L_TOPICS_TOPIC_TITLE}', 972086460, '', '', '', '', '', '', '', 0, 0, '', 48);

# -- Users / Anonymous user

# -- username: Admin password: admin (change this or remove it once everything is working!)

# -- Groups

INSERT INTO phpbb_groups (group_name, group_type, group_founder_manage, group_colour, group_legend, group_avatar, group_desc, group_desc_uid, group_max_recipients) VALUES ('GUESTS', 3, 0, '', 0, '', '', '', 5);

INSERT INTO phpbb_extensions (group_id, extension) VALUES (9, 'ogg');

INSERT INTO phpbb_extensions (group_id, extension) VALUES (9, 'ogm');

# User Notification Options (for first user)

INSERT INTO phpbb_user_notifications (item_type, item_id, user_id, method) VALUES('post', 0, 2, '');

INSERT INTO phpbb_user_notifications (item_type, item_id, user_id, method) VALUES('post', 0, 2, 'email');

field_show_on_reg INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_show_on_pm INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_show_on_vt INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_show_profile INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_hide INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_no_view INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_active INTEGER UNSIGNED NOT NULL DEFAULT '0',

);

CREATE INDEX phpbb_profile_fields_fld_type ON phpbb_profile_fields (field_type);

# Table: 'phpbb_profile_fields_data'

CREATE TABLE phpbb_profile_fields_data (

user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

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

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

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

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

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

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

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

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

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

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

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

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

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

'MODERATOR' => 'Moderator',

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

));

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

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

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

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

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

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

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

),

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

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

'POSTS_DAY' => $user->lang('POST_DAY', $posts_per_day),

'POSTS_PCT' => $user->lang('POST_PCT', $percentage),

'SIGNATURE' => $member['user_sig'],

'POSTS_IN_QUEUE'=> $member['posts_in_queue'],

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