<exec command="phpBB/vendor/bin/phpcs

-s

--extensions=php

--ignore=${project.basedir}/phpBB/phpbb/db/migration/data/v30x/*

phpBB/phpbb"

dir="." returnProperty="retval-php-strict" passthru="true" />

<exec command="phpBB/vendor/bin/phpcs

-s

--extensions=php

--ignore=${project.basedir}/phpBB/cache/*

--ignore=${project.basedir}/phpBB/develop/*

--ignore=${project.basedir}/phpBB/includes/diff/*.php

--ignore=${project.basedir}/phpBB/includes/sphinxapi.php

--ignore=${project.basedir}/phpBB/includes/utf/data/*

--ignore=${project.basedir}/phpBB/vendor/*

phpBB"

dir="." returnProperty="retval-php-legacy" passthru="true" />

<if>

<or>

<not><equals arg1="${retval-php-strict}" arg2="0" /></not>

<not><equals arg1="${retval-php-legacy}" arg2="0" /></not>

</or>

<then>

<fail message="PHP Code Sniffer failed." />

*/

/**

*

* @package code_sniffer

* @author Manuel Pichler <mapi@phpundercontrol.org>

{

if ($phpcsFile->findPrevious(T_OPEN_TAG, $stackPtr - 1) !== false)

{

}

}

// Fetch next non whitespace token

$tokens = $phpcsFile->getTokens();

$start = $phpcsFile->findNext(T_WHITESPACE, $stackPtr + 1, null, true);

$phpcsFile->addError('Missing required file doc comment.', $stackPtr);

return;

}

// Find comment end token

$end = $phpcsFile->findNext(T_DOC_COMMENT, $start + 1, null, true) - 1;

// If there is no end, skip processing here

if ($end === false)

{

return;

}

// List of found comment tags

$tags = array();

// check comment lines without the first(/**) an last(*/) line

{

$line = $tokens[$i]['content'];

// Check that each line starts with a '*'

if (substr($line, 0, 1) !== '*')

{

$phpcsFile->addWarning($message, $i);

}

else if (preg_match('/^\*\s+@([\w]+)\s+(.*)$/', $line, $match) !== 0)

{

}

}

// Check that the first and last line is empty

if (trim($tokens[$start + 1]['content']) !== '*')

{

$message = 'The first file comment line should be empty.';

}

/**

protected function processPackage(PHP_CodeSniffer_File $phpcsFile, $ptr, $tags)

{

if (!isset($tags['package']))

}

else if (preg_match('/^([\w]+)$/', $tags['package'][0]) === 0)

{

}

}

/**

protected function processVersion(PHP_CodeSniffer_File $phpcsFile, $ptr, $tags)

}

<!-- Call-time pass-by-reference MUST not be used. -->

<rule ref="Generic.Functions.CallTimePassByReference.NotAllowed" />

<!-- Class constants MUST be declared in all upper case with underscore separators. -->

<rule ref="Generic.NamingConventions.UpperCaseConstantName" />

<!-- Each file MUST end with exactly one newline character -->

<rule ref="PSR2.Files.EndFileNewline" />

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

</rule>

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

<!-- There MUST NOT be trailing whitespace at the end of lines. -->

<rule ref="Squiz.WhiteSpace.SuperfluousWhitespace" />

<!-- PHP keywords MUST be in lower case. -->

<rule ref="Generic.PHP.LowerCaseKeyword" />

<!-- Classes etc. MUST be namespaced -->

<rule ref="PSR1.Classes.ClassDeclaration.MissingNamespace" />

err=$ERR_HEADER;

echo "$line" | grep -Eq "^\[(ticket/[0-9]+|feature/$branch_regex|task/$branch_regex)\] .+$"

result=$?

then

# Don't be too strict.

# Commits may be temporary, intended to be squashed later.

# Just issue a warning here.

complain "You entered:" 1>&2

complain "$line" 1>&2

fi

</dl>

<dl>

<dt><label for="allowed_forums">{L_ALLOWED_FORUMS}{L_COLON}</label><br /><span>{L_ALLOWED_FORUMS_EXPLAIN}</span></dt>

<dd><select name="allowed_forums[]" multiple="multiple" size="8">{S_FORUM_ID_OPTIONS}</select></dd>

</dl>

#page-footer {

clear: both;

font-size: 0.75em;

text-align: center;

}

margin-bottom: 1px;

}

table.responsive td.empty {

display: none !important;

}

box-sizing: border-box;

}

table.responsive.two-columns td:nth-child(2n+1) {

clear: left;

}

z-index: 50;

padding: 25px;

padding: 0 25px 20px 25px;

}

.phpbb_alert .alert_close {

</div>

<div id="page-footer">

<div id="darkenwrapper" data-ajax-error-title="{L_AJAX_ERROR_TITLE}" data-ajax-error-text="{L_AJAX_ERROR_TEXT}" data-ajax-error-text-abort="{L_AJAX_ERROR_TEXT_ABORT}" data-ajax-error-text-timeout="{L_AJAX_ERROR_TEXT_TIMEOUT}" data-ajax-error-text-parsererror="{L_AJAX_ERROR_TEXT_PARSERERROR}">

<div id="darken">&nbsp;</div>

// define a couple constants for keydown functions.

var keymap = {

ENTER: 13,

ESC: 27

};

}

};

phpbb.ajaxCallbacks = {};

/**

var key = event.keyCode || event.which;

// intercept tabs

!event.metaKey) {

if (inTag()) {

appendText("\t");

}

// intercept new line characters

if (inTag()) {

var lastLine = getLastLine(true),

code = '' + /^\s*/g.exec(lastLine);

};

/**

*/

});

// Hide active dropdowns when click event happens outside

$(phpbb.dropdownHandles).each(phpbb.toggleDropdown);

}

});

$('#color_palette_placeholder').each(function() {

phpbb.registerPalette($(this));

tags:

- { name: profilefield.type }

profilefields.type.int:

class: phpbb\profilefields\type\type_int

arguments:

$schema_path = dirname(__FILE__) . '/../install/schemas/';

$supported_dbms = array(

'mssql',

'mysql_40',

'mysql_41',

{

case 'mysql_40':

case 'mysql_41':

case 'sqlite':

case 'sqlite3':

fwrite($fp, "# DO NOT EDIT THIS FILE, IT IS GENERATED\n");

<li>PostgreSQL 8.3+</li>

<li>SQLite 2.8.2+</li>

<li>SQLite 3.6.15+</li>

<li>MS SQL Server 2000 or above (directly or via ODBC or the native adapter)</li>

<li>Oracle</li>

</ul>

<p>Please remember that running any application on a development (unstable, e.g. a beta release) version of PHP can lead to strange/unexpected results which may appear to be bugs in the application. Therefore, we recommend you upgrade to the newest stable version of PHP before running phpBB3. If you are running a development version of PHP please check any bugs you find on a system running a stable release before submitting.</p>

<a name="phpsec"></a><h3>7.i. Notice on PHP security issues</h3>

<a name="sql"></a><h3>2.iii. SQL/SQL Layout</h3>

<h4>Common SQL Guidelines: </h4>

<p>All SQL commands should utilise the DataBase Abstraction Layer (DBAL)</p>

<h4>SQL code layout:</h4>

<?php

/**

*

*/

/**

case 'mssqlnative':

$extractor = new mssql_extractor($format, $filename, $time, $download, $store);

break;

}

$extractor->write_start($table_prefix);

{

case 'sqlite':

case 'sqlite3':

$extractor->flush('DELETE FROM ' . $table_name . ";\n");

break;

}

break;

case 'postgres':

$delim = ";\n";

while (($sql = $fgetd($fp, $delim, $read, $seek, $eof)) !== false)

}

}

// get how much space we allow for a chunk of data, very similar to phpMyAdmin's way of doing things ;-) (hey, we only do this for MySQL anyway :P)

function get_usable_memory()

{

$version_helper = new \phpbb\version_helper($this->cache, $this->config, $this->user);

$version_helper->set_current_version($meta['version']);

$version_helper->force_stability($this->config['extension_force_unstable'] ? 'unstable' : null);

return $updates = $version_helper->get_suggested_updates($force_update, $force_cache);

{

case 'sqlite':

case 'sqlite3':

$db->sql_query('DELETE FROM ' . $table);

break;

$this->tpl_name = 'acp_jabber';

$this->page_title = 'ACP_JABBER_SETTINGS';

$form_name = 'acp_jabber';

add_form_key($form_name);

{

case 'sqlite':

case 'sqlite3':

$db->sql_query('DELETE FROM ' . TOPICS_POSTED_TABLE);

break;

{

case 'sqlite':

case 'sqlite3':

$db->sql_query("DELETE FROM $table");

break;

break;

case 'oracle':

$sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD $field_ident " . $sql_type;

// Teh standard

case 'postgres':

case 'oracle':

case 'sqlite':

case 'sqlite3':

// Change the reports using this reason to 'other'

}

// Remove current auth options...

foreach ($auth as $auth_option => $auth_setting)

{

$auth_option_ids[] = (int) $this->acl_options['id'][$auth_option];

<?php

/**

*

*

*/

if (isset($GLOBALS['starttime']))

{

$totaltime = microtime(true) - $GLOBALS['starttime'];

}

$memory_usage = memory_get_peak_usage();

if ($memory_usage)

{

case 'sqlite':

case 'sqlite3':

$db->sql_query('DELETE FROM ' . MODERATOR_CACHE_TABLE);

break;

}

break;

case 'sqlite':

case 'sqlite3':

global $dbhost;

static $static_class;

static $magic_url_match_args;

{

$static_class = $class;

$class = ($static_class) ? ' class="' . $static_class . '"' : '';

$local_class = ($static_class) ? ' class="' . $static_class . '-local"' : '';

// relative urls for this board

'#(^|[\n\t (>.])(' . preg_quote($server_url, '#') . ')/(' . get_preg_expression('relative_url_inline') . ')#i',

MAGIC_URL_LOCAL,

$local_class,

);

// matches a xxxx://aaaaa.bbb.cccc. ...

'#(^|[\n\t (>.])(' . get_preg_expression('url_inline') . ')#i',

MAGIC_URL_FULL,

$class,

);

// matches a "www.xxxx.yyyy[/zzzz]" kinda lazy URL thing

'#(^|[\n\t (>])(' . get_preg_expression('www_url_inline') . ')#i',

MAGIC_URL_WWW,

$class,

);

// matches an email@domain type address at the start of a line, or after a space or after what might be a BBCode.

'/(^|[\n\t (>])(' . get_preg_expression('email') . ')/i',

MAGIC_URL_EMAIL,

'',

);

}

{

if (preg_match($magic_args[0], $text, $matches))

{

{

$bigger = ($remote_avatar_cache[$src][0] > $remote_avatar_cache[$src][1]) ? 0 : 1;

$ratio = $default[$bigger] / $remote_avatar_cache[$src][$bigger];

}

}

{

$var = (empty($m[2]) || empty($convert_config[$m[2]])) ? "''" : "'" . addslashes($convert_config[$m[2]]) . "'";

$exec = '$config_value = ' . $m[1] . '(' . $var . ');';

eval($exec);

}

else

{

{

case 'sqlite':

case 'sqlite3':

$db->sql_query('DELETE FROM ' . TOPICS_POSTED_TABLE);

break;

$message = preg_replace('#\[size=([0-9]+)\](.*?)\[/size\]#i', '[size=\1]\2[/size]', $message);

$message = preg_replace('#\[size=[0-9]{2,}\](.*?)\[/size\]#i', '[size=29]\1[/size]', $message);

{

$i--;

$message = str_replace('[size=' . $i . ']', '[size=' . $size[$i] . ']', $message);

// Get forum parents

$forum_parents = get_forum_parents($forum_data);

// Build navigation links

if (!empty($forum_parents))

{

'S_IS_POST' => ($parent_type == FORUM_POST) ? true : false,

'FORUM_NAME' => $parent_name,

'FORUM_ID' => $parent_forum_id,

'U_VIEW_FORUM' => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $parent_forum_id))

);

}

'S_IS_POST' => ($forum_data['forum_type'] == FORUM_POST) ? true : false,

'FORUM_NAME' => $forum_data['forum_name'],

'FORUM_ID' => $forum_data['forum_id'],

'U_VIEW_FORUM' => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_data['forum_id']))

);

{

global $lang;

$available_dbms = array(

// Note: php 5.5 alpha 2 deprecated mysql.

// Keep mysqli before mysql in this list.

'mysqli' => array(

$prefix_length = 200;

break;

case 'phpbb\db\driver\oracle':

$prefix_length = 6;

break;

}

break;

case 'phpbb\db\driver\oracle':

if ($unicode_check)

{

);

$is_auth = false;

eval('$is_auth = (int) (' . $module_auth . ');');

return $is_auth;

}

*/

function delete_pm($user_id, $msg_ids, $folder_id)

{

$user_id = (int) $user_id;

$folder_id = (int) $folder_id;

return false;

}

// Get PM Information for later deleting

$sql = 'SELECT msg_id, pm_unread, pm_new

FROM ' . PRIVMSGS_TO_TABLE . '

* Use this event to modify the values to be inserted when a user is added

*

* @event core.user_add_modify_data

* @var array sql_ary Array of data to be inserted when a user is added

* @since 3.1.0-a1

*/

extract($phpbb_dispatcher->trigger_event('core.user_add_modify_data', compact($vars)));

$sql = 'INSERT INTO ' . USERS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);

set_config('newest_user_colour', $row['group_colour'], true);

}

return $user_id;

}

else

{

$ban_other = explode('-', $ban_len_other);

(strlen($ban_other[0]) == 4) && (strlen($ban_other[1]) == 2) && (strlen($ban_other[2]) == 2))

{

$ban_end = max($current_time, $user->create_datetime()

// Check if the users avatar is actually *not* a group avatar

if ($mode == 'user')

{

{

return false;

}

{

global $config, $db, $phpbb_root_path;

$ext = substr(strrchr($old_entry, '.'), 1);

$old_filename = get_avatar_filename($old_entry);

$new_filename = $config['avatar_salt'] . "_g$group_id.$ext";

$sql = 'SELECT *

FROM ' . GROUPS_TABLE . '

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

if (!$row = $db->sql_fetchrow($result))

{

$sql = 'SELECT *

FROM ' . GROUPS_TABLE . '

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

if (!$row = $db->sql_fetchrow($result))

{

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_rank = 0

AND user_rank <> 0

AND ' . $db->sql_in_set('user_id', $user_ids);

$db->sql_query($sql);

}

{

$topics_moved++;

}

{

$topics_moved_unapproved++;

}

{

$topics_moved_softdeleted++;

}

'topic_last_poster_id' => (int) $row['topic_last_poster_id'],

'topic_last_poster_colour'=>(string) $row['topic_last_poster_colour'],

'topic_last_poster_name'=> (string) $row['topic_last_poster_name'],

'topic_last_post_time' => (int) $row['topic_last_post_time'],

'topic_last_view_time' => (int) $row['topic_last_view_time'],

'topic_moved_id' => (int) $row['topic_id'],

{

$redirect = request_var('redirect', build_url(array('mode', 'r', 'quickmod')) . '&amp;mode=reports');

}

{

$redirect = request_var('redirect', build_url(array('mode', 'r', 'quickmod')) . '&amp;mode=pm_reports');

}

}

}

// Check for "empty" message. We do not check here for maximum length, because bbcode, smilies, etc. can add to the length.

// The maximum length check happened before any parsings.

if ($mode === 'post' && utf8_clean_string($this->message) === '')

ORDER BY LEN(code) DESC';

break;

// LENGTH supported by MySQL, IBM DB2, Oracle and Access for sure...

default:

$sql = 'SELECT *

return '';

}

$ly = (-$length) % 65535;

// negative length requires ... capture everything

'forum_desc' => htmlspecialchars(phpbb_set_default_encoding($row['forum_desc']), ENT_COMPAT, 'UTF-8'),

'forum_type' => FORUM_POST,

'forum_status' => is_item_locked($row['forum_status']),

'prune_next' => (int) null_to_zero($row['prune_next']),

'prune_days' => (int) null_to_zero($row['prune_days']),

'prune_viewed' => 0,

$drop_sql = 'DROP TABLE ' . USERCONV_TABLE;

switch ($map_dbms)

{

case 'mssql':

$create_sql = 'CREATE TABLE [' . USERCONV_TABLE . '] (

[user_id] [int] NOT NULL ,

define('IN_DB_UPDATE', true);

/**

*/

// End startup code

break;

case 'select':

eval('$s_options = ' . str_replace('{VALUE}', $value, $options) . ';');

$tpl = '<select id="' . $name . '" name="' . $name . '">' . $s_options . '</select>';

break;

case 'custom':

eval('$tpl = ' . str_replace('{VALUE}', $value, $options) . ';');

break;

default:

{

case 'sqlite':

case 'sqlite3':

$db->sql_query('DELETE FROM ' . SESSIONS_KEYS_TABLE);

$db->sql_query('DELETE FROM ' . SESSIONS_TABLE);

break;

{

case 'sqlite':

case 'sqlite3':

$convert->src_truncate_statement = 'DELETE FROM ';

break;

{

case 'sqlite':

case 'sqlite3':

$convert->truncate_statement = 'DELETE FROM ';

break;

// Now process queries and execute functions that have to be executed prior to the conversion

if (!empty($convert->convertor['execute_first']))

{

eval($convert->convertor['execute_first']);

}

if (!empty($convert->convertor['query_first']))

// process execute_first and query_first for this table...

if (!empty($schema['execute_first']))

{

eval($schema['execute_first']);

}

if (!empty($schema['query_first']))

// it gets split because of time restrictions

if (!empty($schema['execute_always']))

{

eval($schema['execute_always']);

}

//

{

if (!is_array($convert->convertor['execute_last']))

{

eval($convert->convertor['execute_last']);

}

else

{

while ($last_statement < sizeof($convert->convertor['execute_last']))

{

eval($convert->convertor['execute_last'][$last_statement]);

$template->assign_block_vars('checks', array(

'TITLE' => $convert->convertor['execute_last'][$last_statement],

$execution = str_replace('{RESULT}', '$value', $execution);

$execution = str_replace('{VALUE}', '$value', $execution);

eval($execution);

}

}

}

$execution = str_replace('{RESULT}', '$value', $execution);

$execution = str_replace('{VALUE}', '$value', $execution);

eval($execution);

}

}

}

<?php

phpinfo();

"UINT",

0

],

"pf_phpbb_interests": [

"MTEXT",

""

INSERT INTO phpbb_profile_fields (field_name, field_type, field_ident, field_length, field_minlen, field_maxlen, field_novalue, field_default_value, field_validation, field_required, field_show_novalue, field_show_on_reg, field_show_on_pm, field_show_on_vt, field_show_on_ml, field_show_profile, field_hide, field_no_view, field_active, field_order, field_is_contact, field_contact_desc, field_contact_url) VALUES ('phpbb_icq', 'profilefields.type.string', 'phpbb_icq', '20', '3', '15', '', '', '[0-9]+', 0, 0, 0, 1, 1, 1, 1, 0, 0, 0, 6, 1, 'SEND_ICQ_MESSAGE', 'https://www.icq.com/people/%s/');

INSERT INTO phpbb_profile_fields (field_name, field_type, field_ident, field_length, field_minlen, field_maxlen, field_novalue, field_default_value, field_validation, field_required, field_show_novalue, field_show_on_reg, field_show_on_pm, field_show_on_vt, field_show_on_ml, field_show_profile, field_hide, field_no_view, field_active, field_order, field_is_contact, field_contact_desc, field_contact_url) VALUES ('phpbb_wlm', 'profilefields.type.string', 'phpbb_wlm', '40', '5', '255', '', '', '.*', 0, 0, 0, 1, 1, 1, 1, 0, 0, 0, 7, 1, '', '');

INSERT INTO phpbb_profile_fields (field_name, field_type, field_ident, field_length, field_minlen, field_maxlen, field_novalue, field_default_value, field_validation, field_required, field_show_novalue, field_show_on_reg, field_show_on_pm, field_show_on_vt, field_show_on_ml, field_show_profile, field_hide, field_no_view, field_active, field_order, field_is_contact, field_contact_desc, field_contact_url) VALUES ('phpbb_yahoo', 'profilefields.type.string', 'phpbb_yahoo', '40', '5', '255', '', '', '.*', 0, 0, 0, 1, 1, 1, 1, 0, 0, 0, 8, 1, 'SEND_YIM_MESSAGE', 'http://edit.yahoo.com/config/send_webmesg?.target=%s&amp;.src=pg');

# User Notification Options (for first user)

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

// Custom profile fields

$lang = array_merge($lang, array(

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

'ALPHA_ONLY' => 'Alphanumeric only',

'ALPHA_SPACERS' => 'Alphanumeric and spacers',

'ALPHA_UNDERSCORE' => 'Alphanumeric and underscores',

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

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

'FIELD_DESCRIPTION' => 'Field description',

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

'FIELD_DROPDOWN' => 'Dropdown box',

'FIELD_IDENT' => 'Field identification',

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

'EXTENSION_DISABLED_AFTER_POSTING' => 'The extension <strong>%s</strong> has been deactivated and can no longer be displayed.',

'EXTENSION_DOES_NOT_EXIST' => 'The extension <strong>%s</strong> does not exist.',

'FAQ' => 'FAQ',

'FAQ_EXPLAIN' => 'Frequently Asked Questions',

'FILENAME' => 'Filename',

'GB' => 'GB',

'GIB' => 'GiB',

'GO' => 'Go',

'GOTO_FIRST_POST' => 'Go to first post',

'GOTO_LAST_POST' => 'Go to last post',

'GOTO_PAGE' => 'Go to page',

'SETTINGS' => 'Settings',

'SIGNATURE' => 'Signature',

'SKIP' => 'Skip to content',

'SMTP_NO_AUTH_SUPPORT' => 'SMTP server does not support authentication.',

'SORRY_AUTH_READ' => 'You are not authorised to read this forum.',

'SORRY_AUTH_VIEW_ATTACH' => 'You are not authorised to download this attachment.',

2 => 'Total members <strong>%d</strong>',

),

'TRACKED_PHP_ERROR' => 'Tracked PHP errors: %s',

'UNABLE_GET_IMAGE_SIZE' => 'It was not possible to determine the dimensions of the image. Please verify that the URL you entered is correct.',

'UNABLE_TO_DELIVER_FILE'=> 'Unable to deliver file.',

'WROTE' => 'wrote',

'YAHOO' => 'Yahoo Messenger',

'YEAR' => 'Year',

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

'YES' => 'Yes',

'DEV_NO_TEST_FILE' => 'No value has been specified for the test_file variable in the convertor. If you are a user of this convertor, you should not be seeing this error, please report this message to the convertor author. If you are a convertor author, you must specify the name of a file which exists in the source board to allow the path to it to be verified.',

'DIRECTORIES_AND_FILES' => 'Directory and file setup',

'DISABLE_KEYS' => 'Disabling keys',

'DLL_FTP' => 'Remote FTP support [ Installation ]',

'DLL_GD' => 'GD graphics support [ Visual Confirmation ]',

'DLL_MBSTRING' => 'Multi-byte character support',

'FILLING_TABLE' => 'Filling table <strong>%s</strong>',

'FILLING_TABLES' => 'Filling tables',

'FINAL_STEP' => 'Process final step',

'FORUM_ADDRESS' => 'Board address',

'FORUM_ADDRESS_EXPLAIN' => 'This is the URL of your former board, for example <samp>http://www.example.com/phpBB2/</samp>. If an address is entered here and not left empty every instance of this address will be replaced by your new board address within messages, private messages and signatures.',

<li>PostgreSQL 8.3+</li>

<li>SQLite 2.8.2+</li>

<li>SQLite 3.6.15+</li>

<li>MS SQL Server 2000 or above (directly or via ODBC)</li>

<li>MS SQL Server 2005 or above (native)</li>

<li>Oracle</li>

'INST_ERR_DB_NO_SQLITE' => 'The version of the SQLite extension you have installed is too old, it must be upgraded to at least 2.8.2.',

'INST_ERR_DB_NO_SQLITE3' => 'The version of the SQLite extension you have installed is too old, it must be upgraded to at least 3.6.15.',

'INST_ERR_DB_NO_ORACLE' => 'The version of Oracle installed on this machine requires you to set the <var>NLS_CHARACTERSET</var> parameter to <var>UTF8</var>. Either upgrade your installation to 9.2+ or change the parameter.',

'INST_ERR_DB_NO_POSTGRES' => 'The database you have selected was not created in <var>UNICODE</var> or <var>UTF8</var> encoding. Try installing with a database in <var>UNICODE</var> or <var>UTF8</var> encoding.',

'INST_ERR_DB_NO_NAME' => 'No database name specified.',

'INST_ERR_EMAIL_INVALID' => 'The email address you entered is invalid.',

'USERS_PER_PAGE' => 'Users per page',

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

));

*

* This file is part of the phpBB Forum Software package.

*

* @copyright (c) phpBB Limited <https://www.phpbb.com>

* @license GNU General Public License, version 2 (GPL-2.0)

*

* For full copyright and license information, please see

'UNAUTHORISED_BBCODE' => 'You cannot use certain BBCodes: %s.',

'UNGLOBALISE_EXPLAIN' => 'To switch this topic back from being global to a normal topic, you need to select the forum you wish this topic to be displayed.',

'UPDATE_COMMENT' => 'Update comment',

'URL_INVALID' => 'The URL you specified is invalid.',

'URL_NOT_FOUND' => 'The file specified could not be found.',

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

'FIELD_INVALID_CHARS_INVALID' => 'The field “%s” has invalid characters.',

'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_CHARS_ALPHA_SPACERS' => 'The field “%s” has invalid characters, only alphanumeric, space or -+_[] characters are allowed.',

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

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

namespace phpbb\auth\provider\oauth;

use OAuth\Common\Consumer\Credentials;

/**

* OAuth authentication provider for phpBB3

if (!$row)

{

}

// Update token storage to store the user_id

* @param array $service_credentials {@see \phpbb\auth\provider\oauth\oauth::get_service_credentials}

* @param string $query The query string of the

* current_uri used in redirection

* the api.

* @return \OAuth\Common\Service\ServiceInterface

*/

protected function get_service($service_name, \phpbb\auth\provider\oauth\token_storage $storage, array $service_credentials, $query, array $scopes = array())

{

if (!$service)

{

}

return $service;

$service_name = 'auth.provider.oauth.service.' . strtolower($link_data['oauth_service']);

$storage = new \phpbb\auth\provider\oauth\token_storage($this->db, $this->user, $this->auth_provider_oauth_token_storage_table);

$storage->clearToken($service_name);

}

}

/**

* phpBB config

*

*/

protected $config;

/**

* phpBB request

*

*/

protected $request;

/**

* Constructor

*

*/

public function __construct(\phpbb\config\config $config, \phpbb\request\request_interface $request)

{

/**

* phpBB config

*

*/

protected $config;

/**

* phpBB request

*

*/

protected $request;

/**

* Constructor

*

*/

public function __construct(\phpbb\config\config $config, \phpbb\request\request_interface $request)

{

/**

* Sets the external library service provider

*

*/

public function set_external_service_provider(\OAuth\Common\Service\ServiceInterface $service_provider);

}

use OAuth\OAuth1\Token\StdOAuth1Token;

use OAuth\Common\Token\TokenInterface;

use OAuth\Common\Storage\TokenStorageInterface;

use OAuth\Common\Storage\Exception\TokenNotFoundException;

/**

/**

* Checks to see if an access token exists solely by the session_id of the user

*

* @return bool true if they have token, false if they don't

*/

public function has_access_token_by_session($service)

*

* @param array $data

* @return mixed

*/

protected function _retrieve_access_token($data)

{

* user_id of an account needed to successfully link an external account to

* a forum account.

*

* an external account.

* @return string|null Returns a string with a language constant if there

* is data missing or null if there is no error.

return $this->offsetGet('auth.provider.' . basename(trim($this->config['auth_method'])));

}

// Revert to db auth provider if selected method does not exist

{

return $this->offsetGet('auth.provider.db');

}

* Construct a driver object

*

* @param \phpbb\config\config $config phpBB configuration

* @param string $phpbb_root_path Path to the phpBB root

* @param string $php_ext PHP file extension

* @param \phpbb\cache\driver\driver_interface $cache Cache driver

*/

public function __construct(\phpbb\config\config $config, $phpbb_root_path, $php_ext, \phpbb\path_helper $path_helper, \phpbb\cache\driver\driver_interface $cache = null)

}

/**

*/

public function get_custom_html($user, $row, $alt = '')

{

}

/**

*/

public function prepare_form_acp($user)

{

}

/**

*/

public function delete($row)

{

}

/**

*/

public function get_name()

{

const GRAVATAR_URL = '//secure.gravatar.com/avatar/';

/**

*/

public function get_data($row)

{

}

/**

*/

public function get_custom_html($user, $row, $alt = '')

{

}

/**

*/

public function prepare_form($request, $template, $user, $row, &$error)

{

}

/**

*/

public function process_form($request, $template, $user, $row, &$error)

{

}

/**

*/

public function get_template_name()

{

/**

* Build gravatar URL for output on page

*

* @return string Gravatar URL

*/

protected function get_gravatar_url($row)

class local extends \phpbb\avatar\driver\driver

{

/**

*/

public function get_data($row)

{

}

/**

*/

public function prepare_form($request, $template, $user, $row, &$error)

{

}

/**

*/

public function prepare_form_acp($user)

{

}

/**

*/

public function process_form($request, $template, $user, $row, &$error)

{

}

/**

*/

public function get_template_name()

{

class remote extends \phpbb\avatar\driver\driver

{

/**

*/

public function get_data($row)

{

}

/**

*/

public function prepare_form($request, $template, $user, $row, &$error)

{

}

/**

*/

public function process_form($request, $template, $user, $row, &$error)

{

}

/**

*/

public function get_template_name()

{

class upload extends \phpbb\avatar\driver\driver

{

/**

*/

public function get_data($row, $ignore_config = false)

{

}

/**

*/

public function prepare_form($request, $template, $user, $row, &$error)

{

}

/**

*/

public function process_form($request, $template, $user, $row, &$error)

{

{

$file = $upload->form_upload('avatar_upload_file');

}

{

if (!preg_match('#^(http|https|ftp)://#i', $url))

{

}

/**

*/

public function prepare_form_acp($user)

{

}

/**

*/

public function delete($row)

{

}

/**

*/

public function get_template_name()

{

* Fetch a field from the current row of a cached database result (database)

*

* @param int $query_id

* @return string|bool The field of the query result if found in the cache,

* otherwise false.

*/

/**

* Set cache path

*/

function __construct($cache_dir = null)

{

{

$this->remove_dir($fileInfo->getPathname());

}

strpos($filename, 'url_matcher') === 0 ||

strpos($filename, 'sql_') === 0 ||

strpos($filename, 'data_') === 0)

ORDER BY LEN(bot_agent) DESC';

break;

// LENGTH supported by MySQL, IBM DB2 and Oracle for sure...

default:

$sql = 'SELECT user_id, bot_agent, bot_ip

/** @var \phpbb\config\config */

protected $config;

public function __construct(\phpbb\cache\driver\driver_interface $cache, \phpbb\db\driver\driver_interface $db, \phpbb\auth\auth $auth, \phpbb\log\log $log, \phpbb\user $user, \phpbb\config\config $config)

{

$this->cache = $cache;

parent::__construct();

}

protected function configure()

{

$this

;

}

protected function execute(InputInterface $input, OutputInterface $output)

{

$this->config->increment('assets_version', 1);

use Symfony\Component\Console\Input\InputArgument;

use Symfony\Component\Console\Input\InputInterface;

use Symfony\Component\Console\Output\OutputInterface;

class delete extends command

{

protected function configure()

{

$this

;

}

protected function execute(InputInterface $input, OutputInterface $output)

{

$key = $input->getArgument('key');

class get extends command

{

protected function configure()

{

$this

;

}

protected function execute(InputInterface $input, OutputInterface $output)

{

$key = $input->getArgument('key');

{

$output->write($this->config[$key]);

}

{

$output->writeln($this->config[$key]);

}

class increment extends command

{

protected function configure()

{

$this

;

}

protected function execute(InputInterface $input, OutputInterface $output)

{

$key = $input->getArgument('key');

class set extends command

{

protected function configure()

{

$this

;

}

protected function execute(InputInterface $input, OutputInterface $output)

{

$key = $input->getArgument('key');

class set_atomic extends command

{

protected function configure()

{

$this

;

}

protected function execute(InputInterface $input, OutputInterface $output)

{

$key = $input->getArgument('key');

/** @var \phpbb\user */

protected $user;

public function __construct(\phpbb\cron\manager $cron_manager, \phpbb\user $user)

{

$this->cron_manager = $cron_manager;

parent::__construct();

}

protected function configure()

{

$this

;

}

protected function execute(InputInterface $input, OutputInterface $output)

{

$tasks = $this->cron_manager->get_tasks();

}

}

protected function print_tasks_names(array $tasks, OutputInterface $output)

{

foreach ($tasks as $task)

*

* This file is part of the phpBB Forum Software package.

*

* @license GNU General Public License, version 2 (GPL-2.0)

*

* For full copyright and license information, please see

use Symfony\Component\Console\Input\InputInterface;

use Symfony\Component\Console\Input\InputArgument;

use Symfony\Component\Console\Output\OutputInterface;

class run extends \phpbb\console\command\command

* @param \phpbb\cron\manager $cron_manager The cron manager containing

* the cron tasks to be executed.

* @param \phpbb\lock\db $lock_db The lock for accessing database.

*/

public function __construct(\phpbb\cron\manager $cron_manager, \phpbb\lock\db $lock_db, \phpbb\user $user)

{

}

}

* Executes all ready cron tasks.

*

* If verbose mode is set, an info message will be printed if there is no task to

return 0;

}

* Executes a given cron task, if it is ready.

*

* If there is a task whose name matches $task_name, it is run and 0 is returned.

*

* @param \phpbb\auth\auth $auth Auth object

* @param \phpbb\db\driver\driver_interface $db Database object

* @param string $phpbb_root_path Root path

* @param string $php_ext PHP Extension

*/

public function __construct(\phpbb\auth\auth $auth, \phpbb\db\driver\driver_interface $db, \phpbb\user $user, $phpbb_root_path, $php_ext, $forums_table, $posts_table, $topics_table, $users_table)

{

* @param string $route Name of the route to travel

* @param array $params String or array of additional url parameters

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

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

*/

public function route($route, array $params = array(), $is_amp = true, $session_id = false)

* Output an error, effectively the same thing as trigger_error

*

* @param string $message The error message

*/

public function error($message, $code = 500)

{

/**

* Construct method

*

* to YAML files holding route information

*/

public function __construct($routing_files = array())

}

/**

* @param \phpbb\finder $finder

* @return null

*/

}

/**

*

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

*/

public function find($base_path = '')

{

*

* @param \Symfony\Component\HttpFoundation\Request $request Symfony Request object

* @param mixed $controller A callable (controller class, method)

* @throws \phpbb\controller\exception

*/

public function getArguments(Request $request, $controller)

/**

* Constructor. Loads all available tasks.

*

*/

public function __construct($tasks, $phpbb_root_path, $php_ext)

{

* Loads tasks given by name, wraps them

* and puts them into $this->tasks.

*

*

* @return null

*/

* @param int $forum_id Forum ID of forum that should be pruned

* @param string $prune_mode Prune mode

* @param int $prune_flags Prune flags

* @param int $prune_freq Prune frequency

* @return null

*/

* the user context and modify the timezone to the users selected timezone if one is not set.

*

* @param string $time String in a format accepted by strtotime().

*/

public function __construct($user, $time = 'now', \DateTimeZone $timezone = null)

{

/**

* Magic method to convert DateTime object to string

*

*/

public function __toString()

{

{

$this->sql_report('start', $query);

}

$this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

$this->sql_add_num_queries($this->query_result);

{

$this->sql_report('stop', $query);

}

if ($cache && $cache_ttl)

{

{

$this->sql_report('start', $query);

}

$this->last_query_text = $query;

$this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

{

$this->sql_report('stop', $query);

}

if ($cache && $cache_ttl)

{

{

$this->sql_report('start', $query);

}

$this->last_query_text = $query;

$this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

{

$this->sql_report('stop', $query);

}

if ($cache && $cache_ttl)

{

{

foreach ($errors as $error)

{

$code = $error['code'];

}

$this->last_error_result = $error_message;

$error = $this->last_error_result;

{

$this->sql_report('start', $query);

}

$this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

$this->sql_add_num_queries($this->query_result);

{

$this->sql_report('stop', $query);

}

if ($cache && $cache_ttl)

{

if (version_compare($this->sql_server_info(true), '5.0.2', '>='))

{

$result = @mysqli_query($this->db_connect_id, 'SELECT @@session.sql_mode AS sql_mode');

// TRADITIONAL includes STRICT_ALL_TABLES and STRICT_TRANS_TABLES

if (!in_array('TRADITIONAL', $modes))

if (!$use_cache || empty($cache) || ($this->sql_server_version = $cache->get('mysqli_version')) === false)

{

$result = @mysqli_query($this->db_connect_id, 'SELECT VERSION() AS version');

}

}

return ($raw) ? $this->sql_server_version : 'MySQL(i) ' . $this->sql_server_version;

{

$this->sql_report('start', $query);

}

$this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

$this->sql_add_num_queries($this->query_result);

{

$this->sql_report('stop', $query);

}

if ($cache && $cache_ttl)

{

return $cache->sql_fetchrow($query_id);

}

{

$result = @mysqli_fetch_assoc($query_id);

return $result !== null ? $result : false;

$endtime = $endtime[0] + $endtime[1];

$result = @mysqli_query($this->db_connect_id, $query);

{

}

@mysqli_free_result($result);

{

$this->sql_report('start', $query);

}

$this->last_query_text = $query;

$this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

{

$this->sql_report('stop', $query);

}

if ($cache && $cache_ttl)

{

{

$this->sql_report('start', $query);

}

$this->last_query_text = $query;

$this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

{

$this->sql_report('stop', $query);

}

if ($cache && $cache_ttl)

{

{

$this->sql_report('start', $query);

}

$this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

$this->sql_add_num_queries($this->query_result);

{

$this->sql_report('stop', $query);

}

if ($cache && $cache_ttl)

{

{

$this->sql_report('start', $query);

}

$this->last_query_text = $query;

$this->query_result = ($cache && $cache_ttl) ? $cache->sql_load($query) : false;

{

$this->sql_report('stop', $query);

}

if ($cache && $cache_ttl)

{

{

if (!class_exists('acp_bbcodes'))

{

}

$bbcode_match = $row['bbcode_match'];

$bbcode_tpl = $row['bbcode_tpl'];

<?php

/**

*

*

*/

<?php

/**

*

*

*/

$sql = 'SELECT user_password, user_id

FROM ' . $this->table_prefix . 'users

WHERE user_pass_convert = 1

ORDER BY user_id';

$result = $this->db->sql_query_limit($sql, $limit, $start);

* Check if one of the migrations files' dependencies can't be resolved

* by the supplied list of migrations

*

*/

protected function check_dependencies()

{

* like to update

* @param mixed $config_value The value of the config setting

* @return null

*/

public function update($config_name, $config_value)

{

* like to update

* @param mixed $config_value The value of the config setting

* @return null

*/

public function update_if_equals($compare, $config_name, $config_value)

{

* modules in that info file.

* path, specify that here

* @return null

*/

public function add($class, $parent = 0, $data = array())

{

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

* specify that here

* @return null

*/

public function remove($class, $parent = 0, $module = '')

{

* @param string $class Module Class

* @param string $basename Module Basename

* @return array Module Information

*/

protected function get_module_info($class, $basename)

{

* @param string $old_role_name The old role name

* @param string $new_role_name The new role name

* @return null

*/

public function role_update($old_role_name, $new_role_name)

{

* @param bool $has_permission True if you want to give them permission,

* false if you want to deny them permission

* @return null

*/

public function permission_set($name, $auth_option, $type = 'role', $has_permission = true)

{

* auth_options you would like to set

* @param string $type The type (role|group)

* @return null

*/

public function permission_unset($name, $auth_option, $type = 'role')

{

/**

* Attempts to apply a step of the given migration or one of its dependencies

*

* @return bool Whether any update step was successfully run

*/

protected function try_apply($name)

{

/**

* Attempts to revert a step of the given migration or one of its dependencies

*

* @return bool Whether any update step was successfully run

*/

protected function try_revert($name)

* @param bool|string $state Current state of the migration

* @param bool $revert true to revert a data step

* @return bool|string migration state. True if completed, serialized array if not finished

*/

protected function process_data_step($steps, $state, $revert = false)

{

* @param mixed $last_result Result to pass to the callable (only for 'custom' method)

* @param bool $reverse False to install, True to attempt uninstallation by reversing the call

* @return array Array with parameters for call_user_func_array(), 0 is the callable, 1 is parameters

*/

protected function get_callable_from_step(array $step, $last_result = 0, $reverse = false)

{

* to prevent errors (if including multiple directories, check

* with the last call to prevent throwing errors unnecessarily).

* @return array Array of migration names

*/

public function load_migrations(\phpbb\finder $finder, $path, $check_fulfillable = true)

{

'VARBINARY' => 'varbinary(255)',

),

'mssql' => array(

'INT:' => '[int]',

'BINT' => '[float]',

* A list of supported DBMS. We change this class to support more DBMS, the DBMS itself only need to follow some rules.

* @var array

*/

/**

* This is set to true if user only wants to return the 'to-be-executed' SQL statement(s) (as an array).

FROM pg_stat_user_tables';

break;

case 'oracle':

$sql = 'SELECT table_name

FROM USER_TABLES';

// Close the table for two DBMS and add to the statements

switch ($this->sql_layer)

{

case 'mssql':

case 'mssqlnative':

$table_sql .= "\n);";

$table_sql .= ",\n\t PRIMARY KEY (" . implode(', ', $table_data['PRIMARY_KEY']) . ')';

break;

case 'mssql':

case 'mssqlnative':

// We need the data here

$statements[] = $trigger;

}

break;

}

// Write Keys

WHERE LOWER(table_name) = '" . strtolower($table) . "'";

break;

case 'sqlite':

case 'sqlite3':

$sql = "SELECT sql

switch ($this->sql_layer)

{

case 'postgres':

$sql = "SELECT ic.relname as index_name

FROM pg_class bc, pg_class ic, pg_index i

// These DBMS prefix index name with the table name

switch ($this->sql_layer)

{

case 'oracle':

case 'postgres':

case 'sqlite':

switch ($this->sql_layer)

{

case 'postgres':

$sql = "SELECT ic.relname as index_name, i.indisunique

FROM pg_class bc, pg_class ic, pg_index i

}

break;

case 'postgres':

case 'sqlite':

case 'sqlite3':

switch ($this->sql_layer)

{

case 'mssql':

case 'mssqlnative':

$sql .= " {$column_type} ";

switch ($this->sql_layer)

{

case 'mssql':

case 'mssqlnative':

// Does not support AFTER, only through temporary table

switch ($this->sql_layer)

{

case 'mssql':

case 'mssqlnative':

// We need the data here

$columns = implode(',', $column_list);

if (substr($new_table_cols, -1) === ',')

{

// Remove the comma from the last entry again

$statements[] = 'DROP INDEX ' . $index_name . ' ON ' . $table_name;

break;

case 'oracle':

case 'postgres':

case 'sqlite':

switch ($this->sql_layer)

{

case 'oracle':

$sql = 'SELECT A.REFERENCED_NAME

FROM USER_DEPENDENCIES A, USER_TRIGGERS B