+ <property name="newversion" value="3.1.11-RC1" />

+ <property name="prevversion" value="3.1.10" />

+ <property name="olderversions" value="3.0.14, 3.1.0, 3.1.1, 3.1.2, 3.1.3, 3.1.4, 3.1.5, 3.1.6, 3.1.7, 3.1.7-pl1, 3.1.8, 3.1.9" />

+<!-- EVENT acp_ext_details_notice -->

+ <!-- EVENT acp_ext_details_end -->

+ <td><strong title="{enabled.NAME}">{enabled.META_DISPLAY_NAME}</strong><!-- EVENT acp_ext_list_enabled_name_after --></td>

+ <td><strong title="{disabled.NAME}">{disabled.META_DISPLAY_NAME}</strong><!-- EVENT acp_ext_list_disabled_name_after --></td>

+<dl>

+ <dt><label for="jab_verify_peer">{L_JAB_VERIFY_PEER}{L_COLON}</label><br /><span>{L_JAB_VERIFY_PEER_EXPLAIN}</span></dt>

+ <dd><label><input type="radio" class="radio" id="jab_verify_peer" name="jab_verify_peer" value="1"<!-- IF JAB_VERIFY_PEER --> checked="checked"<!-- ENDIF --> /> {L_YES}</label>

+ <label><input type="radio" class="radio" name="jab_verify_peer" value="0"<!-- IF not JAB_VERIFY_PEER --> checked="checked"<!-- ENDIF --> /> {L_NO}</label></dd>

+</dl>

+<dl>

+ <dt><label for="jab_verify_peer_name">{L_JAB_VERIFY_PEER_NAME}{L_COLON}</label><br /><span>{L_JAB_VERIFY_PEER_NAME_EXPLAIN}</span></dt>

+ <dd><label><input type="radio" class="radio" id="jab_verify_peer_name" name="jab_verify_peer_name" value="1"<!-- IF JAB_VERIFY_PEER_NAME --> checked="checked"<!-- ENDIF --> /> {L_YES}</label>

+ <label><input type="radio" class="radio" name="jab_verify_peer_name" value="0"<!-- IF not JAB_VERIFY_PEER_NAME --> checked="checked"<!-- ENDIF --> /> {L_NO}</label></dd>

+</dl>

+<dl>

+ <dt><label for="jab_allow_self_signed">{L_JAB_ALLOW_SELF_SIGNED}{L_COLON}</label><br /><span>{L_JAB_ALLOW_SELF_SIGNED_EXPLAIN}</span></dt>

+ <dd><label><input type="radio" class="radio" id="jab_allow_self_signed" name="jab_allow_self_signed" value="1"<!-- IF JAB_ALLOW_SELF_SIGNED --> checked="checked"<!-- ENDIF --> /> {L_YES}</label>

+ <label><input type="radio" class="radio" name="jab_allow_self_signed" value="0"<!-- IF not JAB_ALLOW_SELF_SIGNED --> checked="checked"<!-- ENDIF --> /> {L_NO}</label></dd>

+</dl>

+ <!-- IF S_VERSION_UPGRADEABLE -->

+ <div class="errorbox notice">

+ <p>{UPGRADE_INSTRUCTIONS}</p>

+ </div>

+ <!-- ENDIF -->

+ <!-- EVENT acp_profile_contact_last -->

+ <!-- EVENT acp_profile_step_one_lang_after -->

+ <dt><label>{L_STYLE_VERSION}{L_COLON}</label></dt>

+ <dd><strong>{STYLE_VERSION}</strong></dd>

+ </dl>

+ <dl>

+<!-- IF S_VERSION_UPGRADEABLE -->

+ <div class="errorbox notice">

+ <p>{UPGRADE_INSTRUCTIONS}</p>

+ </div>

+<!-- ENDIF -->

+/**

+ * Handler for submitting permissions form in chunks

+ * This call will submit permissions forms in chunks of 5 fieldsets.

+ */

+function submitPermissions() {

+ var $form = $('form#set-permissions'),

+ fieldsetList = $form.find('fieldset[id^=perm]'),

+ formDataSets = [],

+ $submitAllButton = $form.find('input[type=submit][name^=action]')[0],

+ $submitButton = $form.find('input[type=submit][data-clicked=true]')[0];

+

+ // Set proper start values for handling refresh of page

+ var permissionSubmitSize = 0,

+ permissionRequestCount = 0,

+ forumIds = [],

+ permissionSubmitFailed = false;

+

+ if ($submitAllButton !== $submitButton) {

+ fieldsetList = $form.find('fieldset#' + $submitButton.closest('fieldset.permissions').id);

+ }

+

+ $.each(fieldsetList, function (key, value) {

+ if (key % 5 === 0) {

+ formDataSets[Math.floor(key / 5)] = $form.find('fieldset#' + value.id).serialize();

+ } else {

+ formDataSets[Math.floor(key / 5)] += '&' + $form.find('fieldset#' + value.id).serialize();

+ }

+ });

+

+ permissionSubmitSize = formDataSets.length;

+

+ // Add each forum ID to forum ID list to preserve selected forums

+ $.each($form.find('input[type=hidden][name^=forum_id]'), function (key, value) {

+ if (value.name.match(/^forum_id\[([0-9]+)\]$/)) {

+ forumIds.push(value.value);

+ }

+ });

+

+ /**

+ * Handler for submitted permissions form chunk

+ *

+ * @param {object} res Object returned by AJAX call

+ */

+ function handlePermissionReturn(res) {

+ permissionRequestCount++;

+ var $dark = $('#darkenwrapper');

+

+ if (res.S_USER_WARNING) {

+ phpbb.alert(res.MESSAGE_TITLE, res.MESSAGE_TEXT);

+ permissionSubmitFailed = true;

+ } else if (!permissionSubmitFailed && res.S_USER_NOTICE) {

+ // Display success message at the end of submitting the form

+ if (permissionRequestCount >= permissionSubmitSize) {

+ var $alert = phpbb.alert(res.MESSAGE_TITLE, res.MESSAGE_TEXT);

+ var $alertBoxLink = $alert.find('p.alert_text > a');

+

+ // Create form to submit instead of normal "Back to previous page" link

+ if ($alertBoxLink) {

+ // Remove forum_id[] from URL

+ $alertBoxLink.attr('href', $alertBoxLink.attr('href').replace(/(&forum_id\[\]=[0-9]+)/g, ''));

+ var previousPageForm = '<form action="' + $alertBoxLink.attr('href') + '" method="post">';

+ $.each(forumIds, function (key, value) {

+ previousPageForm += '<input type="text" name="forum_id[]" value="' + value + '" />';

+ });

+ previousPageForm += '</form>';

+

+ $alertBoxLink.on('click', function (e) {

+ var $previousPageForm = $(previousPageForm);

+ $('body').append($previousPageForm);

+ e.preventDefault();

+ $previousPageForm.submit();

+ });

+ }

+

+ // Do not allow closing alert

+ $dark.off('click');

+ $alert.find('.alert_close').hide();

+

+ if (typeof res.REFRESH_DATA !== 'undefined') {

+ setTimeout(function () {

+ // Create forum to submit using POST. This will prevent

+ // exceeding the maximum length of URLs

+ var form = '<form action="' + res.REFRESH_DATA.url.replace(/(&forum_id\[\]=[0-9]+)/g, '') + '" method="post">';

+ $.each(forumIds, function (key, value) {

+ form += '<input type="text" name="forum_id[]" value="' + value + '" />';

+ });

+ form += '</form>';

+ $form = $(form);

+ $('body').append($form);

+

+ // Hide the alert even if we refresh the page, in case the user

+ // presses the back button.

+ $dark.fadeOut(phpbb.alertTime, function () {

+ if (typeof $alert !== 'undefined') {

+ $alert.hide();

+ }

+ });

+

+ // Submit form

+ $form.submit();

+ }, res.REFRESH_DATA.time * 1000); // Server specifies time in seconds

+ }

+ }

+ }

+ }

+ // Create AJAX request for each form data set

+ $.each(formDataSets, function (key, formData) {

+ $.ajax({

+ url: $form.action,

+ type: 'POST',

+ data: formData + '&' + $submitButton.name + '=' + encodeURIComponent($submitButton.value) +

+ '&creation_time=' + $form.find('input[type=hidden][name=creation_time]')[0].value +

+ '&form_token=' + $form.find('input[type=hidden][name=form_token]')[0].value +

+ '&' + $form.children('input[type=hidden]').serialize() +

+ '&' + $form.find('input[type=checkbox][name^=inherit]').serialize(),

+ success: handlePermissionReturn,

+ error: handlePermissionReturn

+ });

+ });

+}

+

+ var $setPermissionsForm = $('form#set-permissions');

+ if ($setPermissionsForm.length) {

+ $setPermissionsForm.on('submit', function (e) {

+ submitPermissions();

+ e.preventDefault();

+ });

+ $setPermissionsForm.find('input[type=submit]').click(function() {

+ $('input[type=submit]', $(this).parents($('form#set-permissions'))).removeAttr('data-clicked');

+ $(this).attr('data-clicked', true);

+ });

+ }

+ if (rb[r].name.substr(0, name.length) == name && rb[r].disabled !== true)

+ if (rb[r].name.substr(0, name.length) == name && rb[r].disabled !== true)

+ // Wait 60 seconds and display an error if nothing has been returned by then.

+ phpbb.showTimeoutMessage();

+ }, 60000);

+ * Show timeout message

+ */

+phpbb.showTimeoutMessage = function () {

+ var $alert = $('#phpbb_alert');

+

+ if ($loadingIndicator.is(':visible')) {

+ phpbb.alert($alert.attr('data-l-err'), $alert.attr('data-l-timeout-processing-req'));

+ }

+};

+

+/**

+ "twig/twig": "^1.0,<1.25"

+ "hash": "ab3d7f33388bce90e6032110a537e61f",

+ "content-hash": "9c138398f4bc789098b020ed37f6ae20",

+ "version": "1.0.2",

+ "reference": "4ebe3a8bf773a19edfe0a84b6585ba3d401b724d"

+ "url": "https://api.github.com/repos/php-fig/log/zipball/4ebe3a8bf773a19edfe0a84b6585ba3d401b724d",

+ "reference": "4ebe3a8bf773a19edfe0a84b6585ba3d401b724d",

+ "require": {

+ "php": ">=5.3.0"

+ },

+ "extra": {

+ "branch-alias": {

+ "dev-master": "1.0.x-dev"

+ }

+ },

+ "psr-4": {

+ "Psr\\Log\\": "Psr/Log/"

+ "homepage": "https://github.com/php-fig/log",

+ "time": "2016-10-10 12:19:37"

+ "version": "v1.3.0",

+ "reference": "e79d363049d1c2128f133a2667e4f4190904f7f4"

+ "url": "https://api.github.com/repos/symfony/polyfill-mbstring/zipball/e79d363049d1c2128f133a2667e4f4190904f7f4",

+ "reference": "e79d363049d1c2128f133a2667e4f4190904f7f4",

+ "dev-master": "1.3-dev"

+ "time": "2016-11-14 01:06:16"

+ "version": "v1.24.2",

+ "reference": "33093f6e310e6976baeac7b14f3a6ec02f2d79b7"

+ "url": "https://api.github.com/repos/twigphp/Twig/zipball/33093f6e310e6976baeac7b14f3a6ec02f2d79b7",

+ "reference": "33093f6e310e6976baeac7b14f3a6ec02f2d79b7",

+ "time": "2016-09-01 17:50:53"

+ "version": "1.7.0",

+ "reference": "1f51cc520948f66cd2af8cbc45a5ee175e774220"

+ "url": "https://api.github.com/repos/michelf/php-markdown/zipball/1f51cc520948f66cd2af8cbc45a5ee175e774220",

+ "reference": "1f51cc520948f66cd2af8cbc45a5ee175e774220",

+ "time": "2016-10-29 18:58:20"

+ "version": "1.0.9",

+ "reference": "3dcf38ca72b158baf0bc245e9184d3fdffa9c46f"

+ "url": "https://api.github.com/repos/sebastianbergmann/php-timer/zipball/3dcf38ca72b158baf0bc245e9184d3fdffa9c46f",

+ "reference": "3dcf38ca72b158baf0bc245e9184d3fdffa9c46f",

+ "php": "^5.3.3 || ^7.0"

+ "phpunit/phpunit": "^4.8.35 || ^5.7 || ^6.0"

+ "extra": {

+ "branch-alias": {

+ "dev-master": "1.0-dev"

+ }

+ },

+ "time": "2017-02-26 11:10:40"

+ "version": "1.4.11",

+ "reference": "e03f8f67534427a787e21a385a67ec3ca6978ea7"

+ "url": "https://api.github.com/repos/sebastianbergmann/php-token-stream/zipball/e03f8f67534427a787e21a385a67ec3ca6978ea7",

+ "reference": "e03f8f67534427a787e21a385a67ec3ca6978ea7",

+ "time": "2017-02-27 10:12:30"

+ "version": "1.2.4",

+ "reference": "2b7424b55f5047b47ac6e5ccb20b2aea4011d9be"

+ "url": "https://api.github.com/repos/sebastianbergmann/comparator/zipball/2b7424b55f5047b47ac6e5ccb20b2aea4011d9be",

+ "reference": "2b7424b55f5047b47ac6e5ccb20b2aea4011d9be",

+ "sebastian/exporter": "~1.2 || ~2.0"

+ "time": "2017-01-29 09:50:25"

+ "version": "1.4.3",

+ "reference": "7f066a26a962dbe58ddea9f72a4e82874a3975a4"

+ "url": "https://api.github.com/repos/sebastianbergmann/diff/zipball/7f066a26a962dbe58ddea9f72a4e82874a3975a4",

+ "reference": "7f066a26a962dbe58ddea9f72a4e82874a3975a4",

+ "php": "^5.3.3 || ^7.0"

+ "phpunit/phpunit": "^4.8.35 || ^5.7 || ^6.0"

+ "time": "2017-05-22 07:24:03"

+ "version": "1.3.8",

+ "reference": "be2c607e43ce4c89ecd60e75c6a85c126e754aea"

+ "url": "https://api.github.com/repos/sebastianbergmann/environment/zipball/be2c607e43ce4c89ecd60e75c6a85c126e754aea",

+ "reference": "be2c607e43ce4c89ecd60e75c6a85c126e754aea",

+ "php": "^5.3.3 || ^7.0"

+ "phpunit/phpunit": "^4.8 || ^5.0"

+ "time": "2016-08-18 05:49:44"

+ "version": "1.0.5",

+ "reference": "b19cc3298482a335a95f3016d2f8a6950f0fbcd7"

+ "url": "https://api.github.com/repos/sebastianbergmann/recursion-context/zipball/b19cc3298482a335a95f3016d2f8a6950f0fbcd7",

+ "reference": "b19cc3298482a335a95f3016d2f8a6950f0fbcd7",

+ "time": "2016-10-03 07:41:43"

+ "version": "2.9.1",

+ "reference": "dcbed1074f8244661eecddfc2a675430d8d33f62"

+ "url": "https://api.github.com/repos/squizlabs/PHP_CodeSniffer/zipball/dcbed1074f8244661eecddfc2a675430d8d33f62",

+ "reference": "dcbed1074f8244661eecddfc2a675430d8d33f62",

+ "time": "2017-05-22 02:43:20"

+ - @dispatcher

+

+ console.command.fixup.update_hashes:

+ class: phpbb\console\command\fixup\update_hashes

+ arguments:

+ - @config

+ - @user

+ - @dbal.conn

+ - @passwords.manager

+ - @passwords.driver_collection

+ - %passwords.algorithms%

+ tags:

+ - { name: console.command }

+

+ console.command.fixup.fix_left_right_ids:

+ class: phpbb\console\command\fixup\fix_left_right_ids

+ arguments:

+ - @user

+ - @dbal.conn

+ - @cache.driver

+ tags:

+ - { name: console.command }

+

+ cron.task.core.update_hashes:

+ class: phpbb\cron\task\core\update_hashes

+ arguments:

+ - @config

+ - @dbal.conn

+ - @passwords.update.lock

+ - @passwords.manager

+ - @passwords.driver_collection

+ - %passwords.algorithms%

+ calls:

+ - [set_name, [cron.task.core.update_hashes]]

+ tags:

+ - { name: cron.task }

+ synthetic: true

+

+ passwords.update.lock:

+ class: phpbb\lock\db

+ arguments:

+ - update_hashes_lock

+ - '@config'

+ - '@dbal.conn'

+ <li><a href="#v3110">Changes since 3.1.10</a></li>

+ <a name="v3110"></a><h3>Changes since 3.1.10</h3>

+

+ <h4>Bug</h4>

+ <ul>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-7336">PHPBB3-7336</a>] - Words in new topic title aren't found by search after topic is split</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-8116">PHPBB3-8116</a>] - Server timeout or browsercrash after viewing postdetails</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-8301">PHPBB3-8301</a>] - admin log generate slow queries</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-9590">PHPBB3-9590</a>] - Unable to update permissions for more than 6 forums at a time</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11076">PHPBB3-11076</a>] - Update notification in ACP for minimum PHP version missing essential information</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11483">PHPBB3-11483</a>] - Forced Activation needs looking at.</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11611">PHPBB3-11611</a>] - setup_github_network.php no longer creates a repository</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13247">PHPBB3-13247</a>] - Online indicator in post profile hides behind certain avatars</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13250">PHPBB3-13250</a>] - File cache does not write entries starting with _ and containing a slash</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13429">PHPBB3-13429</a>] - Changes tag in docblock of events should be unified</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13558">PHPBB3-13558</a>] - Error - stream_socket_enable_crypto()</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13757">PHPBB3-13757</a>] - Negative PM count</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14468">PHPBB3-14468</a>] - [php] - 'core.viewforum_modify_topics_data' add parameter forum_id</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14549">PHPBB3-14549</a>] - Correctly redirect back after topic merge in MCP</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14770">PHPBB3-14770</a>] - Plupload: WRONG_FILESIZE is used wrong</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14795">PHPBB3-14795</a>] - Topic merge bug</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14801">PHPBB3-14801</a>] - Search highlight option doesn't always highlight unicode strings</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14802">PHPBB3-14802</a>] - Empty/blank lines should not be additional poll options</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14806">PHPBB3-14806</a>] - Authentication for e-mail is not working</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14819">PHPBB3-14819</a>] - Soft deleted posts visible in topic review</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14821">PHPBB3-14821</a>] - Do not expect parsed HTML in kernel subscriber output</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14830">PHPBB3-14830</a>] - FORM_INVALID error on ACP search and CPF settings</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14831">PHPBB3-14831</a>] - Extension migration file fails</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14838">PHPBB3-14838</a>] - feeds.attachments_base - server 500 error for large attachment tables</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14844">PHPBB3-14844</a>] - BBcodes B and I return &lt;strong&gt; and &lt;em&gt; tags instead of CSS under inherited styles</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14859">PHPBB3-14859</a>] - PM report notifications only sent out to full Global Moderators</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14860">PHPBB3-14860</a>] - Broken link on subscriptions page on mobile devices</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14863">PHPBB3-14863</a>] - &quot;Array&quot; in message title when permanently deleting posts</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14864">PHPBB3-14864</a>] - ACP datefromat text input still has 30 max length while dateformat field had been expanded to 64</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14876">PHPBB3-14876</a>] - Multibyte message is not displayed properly on exception</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14877">PHPBB3-14877</a>] - CSS error in &quot;.codebox code&quot; definition</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14881">PHPBB3-14881</a>] - Problems using EVENT (overall_footer_content_after)</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14888">PHPBB3-14888</a>] - Missing check for disabled profile field types</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14889">PHPBB3-14889</a>] - Missing method declaration in profile fields type interface</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14890">PHPBB3-14890</a>] - Wrong validation of input field in profile field type string</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14906">PHPBB3-14906</a>] - Duplicated sig key in user_cache_data array</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14923">PHPBB3-14923</a>] - SQL PostgreSQL blocking errors during DB update installation</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14938">PHPBB3-14938</a>] - Inconsistent data results from ext_mgr-&gt;all_available() vs ext_mgr-&gt;is_available()</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14941">PHPBB3-14941</a>] - MySQL Fulltext search index creating still fails on InnoDB</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14943">PHPBB3-14943</a>] - Template loop access gives PHP error</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14953">PHPBB3-14953</a>] - Incorrect &quot;order by&quot; definition in ucp_pm_viewfolder</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14968">PHPBB3-14968</a>] - Version check marks 3.1.10 boards as outdated </li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14997">PHPBB3-14997</a>] - Bad Position for topiclist_row_topic_title_after</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14998">PHPBB3-14998</a>] - ACP Update link is incorrect!</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15003">PHPBB3-15003</a>] - When using mark all, disabled check boxes should not become checked</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15006">PHPBB3-15006</a>] - Permission inheritance with checkbox not working</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15011">PHPBB3-15011</a>] - Error not checked on metadata load failure</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15108">PHPBB3-15108</a>] - Duplicate code in request-&gt;overwrite</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15143">PHPBB3-15143</a>] - version check on branch is broken</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15146">PHPBB3-15146</a>] - Date profile field validation incorrect</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15150">PHPBB3-15150</a>] - Yabber SSL/TLS certification</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15186">PHPBB3-15186</a>] - The force_delete_allowed flag does not affect actual posts deletion ability</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15187">PHPBB3-15187</a>] - ACP Template files not purged during Extension Enable</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15246">PHPBB3-15246</a>] - Memcache driver incorrectly handles Unix sockets</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15248">PHPBB3-15248</a>] - Event core.modify_posting_auth does not honor its parameters</li>

+ </ul>

+ <h4>Improvement</h4>

+ <ul>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-9211">PHPBB3-9211</a>] - List subforums-links separately in parent-forums' legend</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-12749">PHPBB3-12749</a>] - core.submit_post_end add subject to the event data</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13457">PHPBB3-13457</a>] - New Hooks for ucp_main</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13459">PHPBB3-13459</a>] - New Template-Event in overall_header.html</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13479">PHPBB3-13479</a>] - Add hook for modifying highlighting on viewtopic</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13601">PHPBB3-13601</a>] - New event upon acl_clear_prefetch</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13603">PHPBB3-13603</a>] - New event upon index_body_online_block_after</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13605">PHPBB3-13605</a>] - New event upon ucp_pm_compose_predefined_message</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13608">PHPBB3-13608</a>] - New event upon ucp_restore_permissions</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13609">PHPBB3-13609</a>] - New event upon ucp_switch_permissions</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13845">PHPBB3-13845</a>] - Add event when user changes or delete avatar</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14119">PHPBB3-14119</a>] - [PHP] - (User) unban event request</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14239">PHPBB3-14239</a>] - [PHP] - Add event ucp_remind_modify_select_sql</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14331">PHPBB3-14331</a>] - Add rank calculation or result event access</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14520">PHPBB3-14520</a>] - [Template] - ucp_pm_viewmessage_message_body_after</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14522">PHPBB3-14522</a>] - [Template] - ucp_register_buttons_before</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14524">PHPBB3-14524</a>] - [PHP] - core.ucp_register_requests_after</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14733">PHPBB3-14733</a>] - Support increasing hashing cost factor</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14750">PHPBB3-14750</a>] - Fileupload form should not set invalid attributes for file input</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14758">PHPBB3-14758</a>] - ACP-Parameter &quot;Maximum thumbnail width in pixel&quot; should be &quot;Maximum thumbnail width/heigth in pixel:&quot;</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14759">PHPBB3-14759</a>] - Event core.mcp_main_modify_shadow_sql</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14760">PHPBB3-14760</a>] - Event core.mcp_main_modify_fork_sql</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14786">PHPBB3-14786</a>] - Add mcp_forum_actions_before/after events</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14804">PHPBB3-14804</a>] - Add core event to MCP after merging topics</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14805">PHPBB3-14805</a>] - Allow building package for previous versions on PHP 7</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14808">PHPBB3-14808</a>] - Add template event overall_header_searchbox_after</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14817">PHPBB3-14817</a>] - Add core event on includes/functions_download.php</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14825">PHPBB3-14825</a>] - Add OAuth events</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14827">PHPBB3-14827</a>] - Possibility to add multiple form keys</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14842">PHPBB3-14842</a>] - Avatar size 0 - unlimited</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14847">PHPBB3-14847</a>] - Add php event to add options in ACP Attachments</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14848">PHPBB3-14848</a>] - Add ACP template events after extensions list titles</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14849">PHPBB3-14849</a>] - Add ACP extension event</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14850">PHPBB3-14850</a>] - Add core events for smilies</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14852">PHPBB3-14852</a>] - Add core event to the function build_header()</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14853">PHPBB3-14853</a>] - Add core event to allow modifying PM attachments download auth</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14855">PHPBB3-14855</a>] - Update notifications and PM alert bubbles</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14870">PHPBB3-14870</a>] - Add php events to modify list of PMs</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14872">PHPBB3-14872</a>] - Remove count versus sizeof restriction in coding guidelines</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14874">PHPBB3-14874</a>] - Error on sending a .pak smiley</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14882">PHPBB3-14882</a>] - Add core event to MCP after move posts sync</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14887">PHPBB3-14887</a>] - ACP profile step 1 lang specific event</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14918">PHPBB3-14918</a>] - Provide quick access to extension version metadata</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14940">PHPBB3-14940</a>] - Add ACP template event acp_ext_details_end</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14957">PHPBB3-14957</a>] - Do not cache database config</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14958">PHPBB3-14958</a>] - Twig extension function lang() performs redundant template data copying</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15020">PHPBB3-15020</a>] - Add Events for mcp_topic_postrow_post_subject</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15059">PHPBB3-15059</a>] - Do not wrap content in code box</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15081">PHPBB3-15081</a>] - Add ACP template event acp_ext_details_notice</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15107">PHPBB3-15107</a>] - Add additional vars to event</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15131">PHPBB3-15131</a>] - Add variable to the 'core.mcp_main_modify_fork_sql' event</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15142">PHPBB3-15142</a>] - Extension Version Check Should Support Branches</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15151">PHPBB3-15151</a>] - ACP Cookie settings should contain explanatory text for all fields</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15199">PHPBB3-15199</a>] - Add core event to the function send() in the messenger</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15200">PHPBB3-15200</a>] - Allow extensions using custom templates for help/faq controllers </li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15205">PHPBB3-15205</a>] - Add template events to forumlist_body.html</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15219">PHPBB3-15219</a>] - Add cron to update passwords hashes to bcrypt</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15226">PHPBB3-15226</a>] - Add index for latest topics query in feeds</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15237">PHPBB3-15237</a>] - Unguarded includes functions_user</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15238">PHPBB3-15238</a>] - Add console command to fix left/right IDs for the forums and modules</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15241">PHPBB3-15241</a>] - Add ACP template event acp_profile_contact_last</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15250">PHPBB3-15250</a>] - Add core event to MCP at the end of merge_posts</li>

+ </ul>

+ <h4>New Feature</h4>

+ <ul>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-12545">PHPBB3-12545</a>] - new pre-posting event</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13730">PHPBB3-13730</a>] - [PHP] - core.delete_post_end</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14390">PHPBB3-14390</a>] - [prosilver] - ucp_main_front_user_details_after</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14498">PHPBB3-14498</a>] - Not possible to deactivate display of &quot;who is online&quot; and birthdays for guests</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14662">PHPBB3-14662</a>] - [Template] - memberlist_team_username_prepend &amp; append</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14868">PHPBB3-14868</a>] - [Template] - mcp_forum_modify_select_after</li>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-14996">PHPBB3-14996</a>] - [event] - Add Event search_results_topictitle_after</li>

+ </ul>

+ <h4>Sub-task</h4>

+ <ul>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-13149">PHPBB3-13149</a>] - [Event] - core.phpbb_log_get_topic_auth_sql_before</li>

+ </ul>

+ <h4>Task</h4>

+ <ul>

+ <li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-15178">PHPBB3-15178</a>] - Update 3.1.x dependencies</li>

+ </ul>

+

+acp_ext_details_end

+===

+* Location: adm/style/acp_ext_details.html

+* Since: 3.1.11-RC1

+* Purpose: Add more detailed information on extension after the available information.

+

+acp_ext_details_notice

+===

+* Location: adm/style/acp_ext_details.html

+* Since: 3.1.11-RC1

+* Purpose: Add extension detail notices after version check information.

+

+acp_ext_list_disabled_name_after

+===

+* Location: adm/style/acp_ext_list.html

+* Since: 3.1.11-RC1

+* Purpose: Add content after the name of disabled extensions in the list

+

+acp_ext_list_enabled_name_after

+===

+* Location: adm/style/acp_ext_list.html

+* Since: 3.1.11-RC1

+* Purpose: Add content after the name of enabled extensions in the list

+

+acp_profile_contact_last

+===

+* Locations:

+ + adm/style/acp_profile.html

+* Since: 3.1.11-RC1

+* Purpose: Add contact specific options to custom profile fields in the ACP

+

+acp_profile_step_one_lang_after

+===

+* Locations:

+ + adm/style/acp_profile.html

+* Since: 3.1.11-RC1

+* Purpose: Add extra lang specific options to custom profile field step one configuration in the ACP

+

+forumlist_body_subforum_link_append

+===

+* Locations:

+ + styles/prosilver/template/forumlist_body.html

+ + styles/subsilver2/template/forumlist_body.html

+* Since: 3.1.11-RC1

+* Purpose: Add content at the end of subforum link item.

+

+forumlist_body_subforum_link_prepend

+===

+* Locations:

+ + styles/prosilver/template/forumlist_body.html

+ + styles/subsilver2/template/forumlist_body.html

+* Since: 3.1.11-RC1

+* Purpose: Add content at the start of subforum link item.

+

+index_body_birthday_block_before

+===

+* Locations:

+ + styles/prosilver/template/index_body.html

+ + styles/subsilver2/template/index_body.html

+* Since: 3.1.11-RC1

+* Purpose: Add new statistic blocks before the Birthday block

+

+mcp_forum_actions_append

+===

+* Locations:

+ + styles/prosilver/template/mcp_forum.html

+ + styles/subsilver2/template/mcp_forum.html

+* Since: 3.1.11-RC1

+* Purpose: Add additional options to actions select

+

+mcp_topic_postrow_post_subject_after

+===

+* Locations:

+ + styles/prosilver/template/mcp_topic.html

+* Since: 3.1.11-RC1

+* Purpose: Add content after post subject in topic moderation

+

+mcp_topic_postrow_post_subject_before

+===

+* Locations:

+ + styles/prosilver/template/mcp_topic.html

+* Since: 3.1.11-RC1

+* Purpose: Add content before post subject in topic moderation

+

+memberlist_team_username_append

+===

+* Locations:

+ + styles/prosilver/template/memberlist_team.html

+ + styles/subsilver2/template/memberlist_team.html

+* Since: 3.1.11-RC1

+* Purpose: Append information to username of team member

+

+memberlist_team_username_prepend

+===

+* Locations:

+ + styles/prosilver/template/memberlist_team.html

+ + styles/subsilver2/template/memberlist_team.html

+* Since: 3.1.11-RC1

+* Purpose: Add information before team user username

+

+search_results_topic_title_after

+===

+* Locations:

+ + styles/prosilver/template/search_results.html

+* Since: 3.1.11-RC1

+* Purpose: Add data after search results topic title

+

+ucp_main_front_user_activity_append

+===

+* Locations:

+ + styles/prosilver/template/ucp_main_front.html

+ + styles/subsilver2/template/ucp_main_front.html

+* Since: 3.1.11-RC1

+* Purpose: Add content after last user activity info viewing UCP front page

+

+ucp_main_front_user_activity_prepend

+===

+* Locations:

+ + styles/prosilver/template/ucp_main_front.html

+ + styles/subsilver2/template/ucp_main_front.html

+* Since: 3.1.11-RC1

+* Purpose: Add content before first user activity info viewing UCP front page

+

+ucp_pm_viewmessage_options_before

+===

+* Locations:

+ + styles/prosilver/template/ucp_pm_viewmessage.html

+* Since: 3.1.11-RC1

+* Purpose: Add content right before display options

+

+ucp_register_buttons_before

+===

+* Locations:

+ + styles/prosilver/template/ucp_register.html

+ + styles/subsilver2/template/ucp_register.html

+* Since: 3.1.11-RC1

+* Purpose: Add content before buttons in registration form.

+

+ * @changed 3.1.7-RC1 Fixing wrong name of a variable (replacing "extension" by "extensions")

+$template_file = 'faq_body.html';

+ * @var string template_file Template file name

+ * @changed 3.1.11-RC1 Added template_file var

+ 'template_file',

+ 'body' => $template_file)

+ var $new_config;

+ 'cookie_domain' => array('lang' => 'COOKIE_DOMAIN', 'validate' => 'string', 'type' => 'text::255', 'explain' => true),

+ 'cookie_name' => array('lang' => 'COOKIE_NAME', 'validate' => 'string', 'type' => 'text::16', 'explain' => true),

+ 'cookie_path' => array('lang' => 'COOKIE_PATH', 'validate' => 'string', 'type' => 'text::255', 'explain' => true),

+ 'smtp_verify_peer' => array('lang' => 'SMTP_VERIFY_PEER', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

+ 'smtp_verify_peer_name' => array('lang' => 'SMTP_VERIFY_PEER_NAME', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

+ 'smtp_allow_self_signed'=> array('lang' => 'SMTP_ALLOW_SELF_SIGNED','validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

+ $this->new_config = clone $config;

+ <input type=\"text\" name=\"config[$key]\" id=\"$key\" value=\"$value\" maxlength=\"64\" />";

+ var $tpl_name;

+ var $page_title;

+ private $phpbb_dispatcher;

+ private $ext_manager;

+ global $config, $user, $template, $request, $phpbb_extension_manager, $phpbb_root_path, $phpEx, $phpbb_log, $cache, $phpbb_dispatcher;

+ $this->phpbb_dispatcher = $phpbb_dispatcher;

+ $this->ext_manager = $phpbb_extension_manager;

+ $this->user->add_lang(array('install', 'acp/extensions', 'migrator'));

+ $action = $this->request->variable('action', 'list');

+ $ext_name = $this->request->variable('ext_name', '');

+ if ($this->request->is_set_post('cancel'))

+ if (in_array($action, array('enable', 'disable', 'delete_data')) && !check_link_hash($this->request->variable('hash', ''), $action . '.' . $ext_name))

+ /**

+ * Event to run a specific action on extension

+ *

+ * @event core.acp_extensions_run_action_before

+ * @var string action Action to run; if the event completes execution of the action, should be set to 'none'

+ * @var string u_action Url we are at

+ * @var string ext_name Extension name from request

+ * @var int safe_time_limit Safe limit of execution time

+ * @var int start_time Start time

+ * @var string tpl_name Template file to load

+ * @since 3.1.11-RC1

+ * @changed 3.2.1-RC1 Renamed to core.acp_extensions_run_action_before, added tpl_name, added action 'none'

+ */

+ $u_action = $this->u_action;

+ $tpl_name = '';

+ $vars = array('action', 'u_action', 'ext_name', 'safe_time_limit', 'start_time', 'tpl_name');

+ extract($this->phpbb_dispatcher->trigger_event('core.acp_extensions_run_action_before', compact($vars)));

+

+ // In case they have been updated by the event

+ $this->u_action = $u_action;

+ $this->tpl_name = $tpl_name;

+

+ $md_manager = $this->ext_manager->create_extension_metadata_manager($ext_name, $this->template);

+ case 'none':

+ // Intentionally empty, used by extensions that execute additional actions in the prior event

+ break;

+

+ confirm_box(false, $this->user->lang('EXTENSION_FORCE_UNSTABLE_CONFIRM'), $s_hidden_fields);

+ $this->config->set('extension_force_unstable', false);

+ trigger_error($this->user->lang['CONFIG_UPDATED'] . adm_back_link($this->u_action));

+ $this->config->set('extension_force_unstable', true);

+ trigger_error($this->user->lang['CONFIG_UPDATED'] . adm_back_link($this->u_action));

+ $this->list_enabled_exts();

+ $this->list_disabled_exts();

+ $this->list_available_exts();

+ 'FORCE_UNSTABLE' => $this->config['extension_force_unstable'],

+ try

+ $md_manager->validate_enable();

+ catch (\phpbb\extension\exception $e)

+ trigger_error($e . adm_back_link($this->u_action), E_USER_WARNING);

+ $extension = $this->ext_manager->get_extension($ext_name);

+ trigger_error($this->user->lang['EXTENSION_NOT_ENABLEABLE'] . adm_back_link($this->u_action), E_USER_WARNING);

+ if ($this->ext_manager->is_enabled($ext_name))

+ $this->template->assign_vars(array(

+ try

+ $md_manager->validate_enable();

+ catch (\phpbb\extension\exception $e)

+ trigger_error($e . adm_back_link($this->u_action), E_USER_WARNING);

+ $extension = $this->ext_manager->get_extension($ext_name);

+ trigger_error($this->user->lang['EXTENSION_NOT_ENABLEABLE'] . adm_back_link($this->u_action), E_USER_WARNING);

+ while ($this->ext_manager->enable_step($ext_name))

+ $this->template->assign_var('S_NEXT_STEP', true);

+

+ // Update custom style for admin area

+ $this->template->set_custom_style(array(

+ array(

+ 'name' => 'adm',

+ 'ext_path' => 'adm/style/',

+ ),

+ ), array($phpbb_root_path . 'adm/style'));

+

+ $this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_EXT_ENABLE', time(), array($ext_name));

+ $this->template->assign_var('MIGRATOR_ERROR', $e->getLocalisedMessage($this->user));

+ $this->template->assign_vars(array(

+ if (!$this->ext_manager->is_enabled($ext_name))

+ $this->template->assign_vars(array(

+ if (!$this->ext_manager->is_enabled($ext_name))

+ while ($this->ext_manager->disable_step($ext_name))

+ $this->template->assign_var('S_NEXT_STEP', true);

+ $this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_EXT_DISABLE', time(), array($ext_name));

+ $this->template->assign_vars(array(

+ if ($this->ext_manager->is_enabled($ext_name))

+ $this->template->assign_vars(array(

+ if ($this->ext_manager->is_enabled($ext_name))

+ while ($this->ext_manager->purge_step($ext_name))

+ $this->template->assign_var('S_NEXT_STEP', true);

+ $this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_EXT_PURGE', time(), array($ext_name));

+ $this->template->assign_var('MIGRATOR_ERROR', $e->getLocalisedMessage($this->user));

+ $this->template->assign_vars(array(

+ $updates_available = $this->version_check($md_manager, $this->request->variable('versioncheck_force', false));

+ $this->template->assign_vars(array(

+ $this->template->assign_block_vars('updates_available', $updates_available);

+ $this->template->assign_vars(array(

+ 'VERSIONCHECK_FAIL_REASON' => ($e->getMessage() !== $this->user->lang('VERSIONCHECK_FAIL')) ? $e->getMessage() : '',

+ $this->template->assign_vars(array(

+

+ /**

+ * Event to run after a specific action on extension has completed

+ *

+ * @event core.acp_extensions_run_action_after

+ * @var string action Action that has run

+ * @var string u_action Url we are at

+ * @var string ext_name Extension name from request

+ * @var int safe_time_limit Safe limit of execution time

+ * @var int start_time Start time

+ * @var string tpl_name Template file to load

+ * @since 3.1.11-RC1

+ */

+ $u_action = $this->u_action;

+ $tpl_name = $this->tpl_name;

+ $vars = array('action', 'u_action', 'ext_name', 'safe_time_limit', 'start_time', 'tpl_name');

+ extract($this->phpbb_dispatcher->trigger_event('core.acp_extensions_run_action_after', compact($vars)));

+

+ // In case they have been updated by the event

+ $this->u_action = $u_action;

+ $this->tpl_name = $tpl_name;

+ public function list_enabled_exts()

+ foreach ($this->ext_manager->all_enabled() as $name => $location)

+ $md_manager = $this->ext_manager->create_extension_metadata_manager($name, $this->template);

+ public function list_disabled_exts()

+ foreach ($this->ext_manager->all_disabled() as $name => $location)

+ $md_manager = $this->ext_manager->create_extension_metadata_manager($name, $this->template);

+ public function list_available_exts()

+ $uninstalled = array_diff_key($this->ext_manager->all_available(), $this->ext_manager->all_configured());

+ $md_manager = $this->ext_manager->create_extension_metadata_manager($name, $this->template);

+ * @return array

+ return $version_helper->get_ext_update_on_branch($force_update, $force_cache);

+ $jab_enable = request_var('jab_enable', (bool) $config['jab_enable']);

+ $jab_host = request_var('jab_host', (string) $config['jab_host']);

+ $jab_port = request_var('jab_port', (int) $config['jab_port']);

+ $jab_username = request_var('jab_username', (string) $config['jab_username']);

+ $jab_password = request_var('jab_password', (string) $config['jab_password']);

+ $jab_package_size = request_var('jab_package_size', (int) $config['jab_package_size']);

+ $jab_use_ssl = request_var('jab_use_ssl', (bool) $config['jab_use_ssl']);

+ $jab_verify_peer = request_var('jab_verify_peer', (bool) $config['jab_verify_peer']);

+ $jab_verify_peer_name = request_var('jab_verify_peer_name', (bool) $config['jab_verify_peer_name']);

+ $jab_allow_self_signed = request_var('jab_allow_self_signed', (bool) $config['jab_allow_self_signed']);

+ $jabber = new jabber($jab_host, $jab_port, $jab_username, $jab_password, $jab_use_ssl, $jab_verify_peer, $jab_verify_peer_name, $jab_allow_self_signed);

+ set_config('jab_verify_peer', $jab_verify_peer);

+ set_config('jab_verify_peer_name', $jab_verify_peer_name);

+ set_config('jab_allow_self_signed', $jab_allow_self_signed);

+ 'JAB_VERIFY_PEER' => $jab_verify_peer,

+ 'JAB_VERIFY_PEER_NAME' => $jab_verify_peer_name,

+ 'JAB_ALLOW_SELF_SIGNED' => $jab_allow_self_signed,

+ if ($auth->acl_get('a_server') && version_compare(PHP_VERSION, '5.4.0', '<'))

+ 'L_PHP_VERSION_OLD' => sprintf($user->lang['PHP_VERSION_OLD'], PHP_VERSION, '5.4.0', '<a href="https://www.phpbb.com/support/docs/en/3.2/ug/quickstart/requirements">', '</a>'),

+ /** @var \phpbb\version_helper $version_helper */

+ $updates_available = $version_helper->get_update_on_branch($recheck);

+ $upgrades_available = $version_helper->get_suggested_updates();

+ if (!empty($upgrades_available))

+ {

+ $upgrades_available = array_pop($upgrades_available);

+ }

+ $template->assign_vars(array(

+ 'S_VERSION_UP_TO_DATE' => empty($updates_available),

+ 'S_VERSION_UPGRADEABLE' => !empty($upgrades_available),

+ 'UPGRADE_INSTRUCTIONS' => !empty($upgrades_available) ? $user->lang('UPGRADE_INSTRUCTIONS', $upgrades_available['current'], $upgrades_available['announcement']) : false,

+ ));

+ meta_refresh(5, $this->u_action);

+ meta_refresh(5, $this->u_action . '&amp;forum_id[]=' . implode('&amp;forum_id[]=', $forum_ids));

+ meta_refresh(5, $this->u_action);

+ meta_refresh(5, $this->u_action . '&amp;forum_id[]=' . implode('&amp;forum_id[]=', $forum_id));

+ meta_refresh(5, $this->u_action);

+ if (!isset($this->type_collection[$row['field_type']]))

+ {

+ continue;

+ }

+ // Read style configuration file

+ $style_cfg = $this->read_style_cfg($style['style_path']);

+

+ 'STYLE_VERSION' => htmlspecialchars($style_cfg['style_version']),

+ $updates_available = $version_helper->get_update_on_branch($recheck);

+ $upgrades_available = $version_helper->get_suggested_updates();

+ if (!empty($upgrades_available))

+ {

+ $upgrades_available = array_pop($upgrades_available);

+ }

+ $template->assign_block_vars('updates_available', $updates_available);

+ $update_link = append_sid($phpbb_root_path . 'install/');

+ 'S_VERSION_UPGRADEABLE' => !empty($upgrades_available),

+ 'UPGRADE_INSTRUCTIONS' => !empty($upgrades_available) ? $user->lang('UPGRADE_INSTRUCTIONS', $upgrades_available['current'], $upgrades_available['announcement']) : false,

+ 'L_AVATAR_EXPLAIN' => $user->lang(($config['avatar_filesize'] == 0) ? 'AVATAR_EXPLAIN_NO_FILESIZE' : 'AVATAR_EXPLAIN', $config['avatar_max_width'], $config['avatar_max_height'], $config['avatar_filesize'] / 1024),

+ global $phpbb_dispatcher;

+

+ $modes = array(

+ 'admin' => array('title' => 'ACP_ADMIN_LOGS', 'auth' => 'acl_a_viewlogs', 'cat' => array('ACP_FORUM_LOGS')),

+ 'mod' => array('title' => 'ACP_MOD_LOGS', 'auth' => 'acl_a_viewlogs', 'cat' => array('ACP_FORUM_LOGS')),

+ 'users' => array('title' => 'ACP_USERS_LOGS', 'auth' => 'acl_a_viewlogs', 'cat' => array('ACP_FORUM_LOGS')),

+ 'critical' => array('title' => 'ACP_CRITICAL_LOGS', 'auth' => 'acl_a_viewlogs', 'cat' => array('ACP_FORUM_LOGS')),

+ );

+

+ /**

+ * Event to add or modify ACP log modulemodes

+ *

+ * @event core.acp_logs_info_modify_modes

+ * @var array modes Array with modes info

+ * @since 3.1.11-RC1

+ * @since 3.2.1-RC1

+ */

+ $vars = array('modes');

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

+

+ 'modes' => $modes,

+define('PHPBB_VERSION', '3.1.11-RC1');

+ 'MESSAGE_TITLE' => (!isset($user->lang[$title])) ? $user->lang['CONFIRM'] : $user->lang($title, 1),

+ * @var int topic_id The topic id the posts are moved to

+ * @var bool auto_sync Whether or not to perform auto sync

+ * @var int topic_id The topic id the posts are moved to

+ * @var bool auto_sync Whether or not to perform auto sync

+

+ /**

+ * Perform additional actions after move post sync

+ *

+ * @event core.move_posts_sync_after

+ * @var array post_ids Array of the moved post ids

+ * @var int topic_id The topic id the posts are moved to

+ * @var bool auto_sync Whether or not to perform auto sync

+ * @var array forum_ids Array of the forum ids the posts are moved from

+ * @var array topic_ids Array of the topic ids the posts are moved from

+ * @var array forum_row Array with the forum id of the topic the posts are moved to

+ * @since 3.1.11-RC1

+ */

+ $vars = array(

+ 'post_ids',

+ 'topic_id',

+ 'auto_sync',

+ 'forum_ids',

+ 'topic_ids',

+ 'forum_row',

+ );

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

+ * @var string message_parser The message_parser object

+ * @changed 3.1.11-RC1 Added message_parser to vars

+ $vars = array('text', 'uid', 'bitfield', 'flags', 'message_parser');

+ global $config, $user, $phpbb_path_helper, $phpbb_dispatcher;

+

+ /**

+ * Event to override the root_path for smilies

+ *

+ * @event core.smiley_text_root_path

+ * @var string root_path root_path for smilies

+ * @since 3.1.11-RC1

+ */

+ $vars = array('root_path');

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

+ * @changed 3.1.0-b5 Added var subforums_row

+ /**

+ * Modify a user's rank before displaying

+ *

+ * @event core.get_user_rank_after

+ * @var array user_data Array with user's data

+ * @var int user_posts User_posts to change

+ * @var array user_rank_data User rank data

+ * @since 3.1.11-RC1

+ */

+

+ $vars = array(

+ 'user_data',

+ 'user_posts',

+ 'user_rank_data',

+ );

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

+

+ global $user, $db, $config, $phpbb_dispatcher, $phpbb_root_path;

+ /**

+ * Event to alter attachment before it is sent to browser.

+ *

+ * @event core.send_file_to_browser_before

+ * @var array attachment Attachment data

+ * @var string upload_dir Relative path of upload directory

+ * @var int category Attachment category

+ * @var string filename Path to file, including filename

+ * @var int size File size

+ * @since 3.1.11-RC1

+ */

+ $vars = array(

+ 'attachment',

+ 'upload_dir',

+ 'category',

+ 'filename',

+ 'size',

+ );

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

+

+ global $phpbb_dispatcher;

+

+ /**

+ * Event to modify PM attachments download auth

+ *

+ * @event core.modify_pm_attach_download_auth

+ * @var bool allowed Whether the user is allowed to download from that PM or not

+ * @var int msg_id The id of the PM to download from

+ * @var int user_id The user id for auth check

+ * @since 3.1.11-RC1

+ */

+ $vars = array('allowed', 'msg_id', 'user_id');

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

+

+ var $verify_peer;

+ var $verify_peer_name;

+ var $allow_self_signed;

+ * Constructor

+ *

+ * @param string $server Jabber server

+ * @param int $port Jabber server port

+ * @param string $username Jabber username or JID

+ * @param string $password Jabber password

+ * @param boold $use_ssl Use ssl

+ * @param bool $verify_peer Verify SSL certificate

+ * @param bool $verify_peer_name Verify Jabber peer name

+ * @param bool $allow_self_signed Allow self signed certificates

+ function __construct($server, $port, $username, $password, $use_ssl = false, $verify_peer = true, $verify_peer_name = true, $allow_self_signed = false)

+ $this->verify_peer = $verify_peer;

+ $this->verify_peer_name = $verify_peer_name;

+ $this->allow_self_signed = $allow_self_signed;

+ if (!@extension_loaded('openssl') || !function_exists('stream_socket_enable_crypto') || !function_exists('stream_get_meta_data') || !function_exists('stream_set_blocking') || !function_exists('stream_get_wrappers'))

+ if ($this->open_socket($this->connect_server, $this->port, $this->use_ssl, $this->verify_peer, $this->verify_peer_name, $this->allow_self_signed))

+ * @param bool $verify_peer verify ssl certificate

+ * @param bool $verify_peer_name verify peer name

+ * @param bool $allow_self_signed allow self-signed ssl certificates

+ function open_socket($server, $port, $use_ssl, $verify_peer, $verify_peer_name, $allow_self_signed)

+ $options = array();

+ if ($use_ssl)

+ $remote_socket = 'ssl://' . $server . ':' . $port;

+

+ // Set ssl context options, see http://php.net/manual/en/context.ssl.php

+ $options['ssl'] = array('verify_peer' => $verify_peer, 'verify_peer_name' => $verify_peer_name, 'allow_self_signed' => $allow_self_signed);

+ }

+ else

+ {

+ $remote_socket = $server . ':' . $port;

+ }

+

+ $socket_context = stream_context_create($options);

+

+ if ($this->connection = @stream_socket_client($remote_socket, $errorno, $errorstr, $this->timeout, STREAM_CLIENT_CONNECT, $socket_context))

+ {

+ stream_set_blocking($this->connection, 0);

+ stream_set_timeout($this->connection, 60);

+ stream_set_blocking($this->connection, 1);

+ stream_set_blocking($this->connection, $meta['blocked']);

+ *

+ * @param int $method User notification method NOTIFY_EMAIL|NOTIFY_IM|NOTIFY_BOTH

+ * @param bool $break Flag indicating if the function only formats the subject

+ * and the message without sending it

+ *

+ * @return bool

+ global $config, $user, $phpbb_dispatcher;

+ $subject = $this->subject;

+ $message = $this->msg;

+ /**

+ * Event to modify notification message text before parsing

+ *

+ * @event core.modify_notification_message

+ * @var int method User notification method NOTIFY_EMAIL|NOTIFY_IM|NOTIFY_BOTH

+ * @var bool break Flag indicating if the function only formats the subject

+ * and the message without sending it

+ * @var string subject The message subject

+ * @var string message The message text

+ * @since 3.1.11-RC1

+ */

+ $vars = array(

+ 'method',

+ 'break',

+ 'subject',

+ 'message',

+ );

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

+ $this->subject = $subject;

+ $this->msg = $message;

+ unset($subject, $message);

+

+ global $config, $phpbb_dispatcher;

+ /**

+ * Event to modify email header entries

+ *

+ * @event core.modify_email_headers

+ * @var array headers Array containing email header entries

+ * @since 3.1.11-RC1

+ */

+ $vars = array('headers');

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

+

+ $this->jabber = new jabber($config['jab_host'], $config['jab_port'], $config['jab_username'], htmlspecialchars_decode($config['jab_password']), $config['jab_use_ssl'], $config['jab_verify_peer'], $config['jab_verify_peer_name'], $config['jab_allow_self_signed']);

+ $this->jabber = new jabber($config['jab_host'], $config['jab_port'], $config['jab_username'], htmlspecialchars_decode($config['jab_password']), $config['jab_use_ssl'], $config['jab_verify_peer'], $config['jab_verify_peer_name'], $config['jab_allow_self_signed']);

+

+ $options = array();

+ $verify_peer = (bool) $config['smtp_verify_peer'];

+ $verify_peer_name = (bool) $config['smtp_verify_peer_name'];

+ $allow_self_signed = (bool) $config['smtp_allow_self_signed'];

+ $remote_socket = $config['smtp_host'] . ':' . $config['smtp_port'];

+

+ // Set ssl context options, see http://php.net/manual/en/context.ssl.php

+ $options['ssl'] = array('verify_peer' => $verify_peer, 'verify_peer_name' => $verify_peer_name, 'allow_self_signed' => $allow_self_signed);

+ $socket_context = stream_context_create($options);

+

+ $smtp->socket = @stream_socket_client($remote_socket, $errno, $errstr, 20, STREAM_CLIENT_CONNECT, $socket_context);

+ /**

+ * Modify smiley root path before populating smiley list

+ *

+ * @event core.generate_smilies_before

+ * @var string root_path root_path for smilies

+ * @since 3.1.11-RC1

+ */

+ $vars = array('root_path');

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

+ global $db, $user, $auth, $phpbb_container, $phpbb_dispatcher;

+ /**

+ * This event is used for performing actions directly after a post or topic

+ * has been deleted.

+ *

+ * @event core.delete_post_after

+ * @var int forum_id Post forum ID

+ * @var int topic_id Post topic ID

+ * @var int post_id Post ID

+ * @var array data Post data

+ * @var bool is_soft Soft delete flag

+ * @var string softdelete_reason Soft delete reason

+ * @var string post_mode delete_topic, delete_first_post, delete_last_post or delete

+ * @var mixed next_post_id Next post ID in the topic (post ID or false)

+ *

+ * @since 3.1.11-RC1

+ */

+ $vars = array(

+ 'forum_id',

+ 'topic_id',

+ 'post_id',

+ 'data',

+ 'is_soft',

+ 'softdelete_reason',

+ 'post_mode',

+ 'next_post_id',

+ );

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

+

+ * @changed 3.1.0-RC3 Added vars mode, subject, username, topic_type,

+*

+* @param int $forum_id The id of the forum

+* @param int $topic_id The id of the topic

+* @param int $post_id The id of the post

+* @param array $post_data Array with the post data

+* @param bool $is_soft The flag indicating whether it is the soft delete mode

+* @param string $delete_reason Description for the post deletion reason

+*

+* @return null

+ global $phpbb_root_path, $phpEx, $phpbb_dispatcher;

+ $force_delete_allowed = $force_softdelete_allowed = false;

+ /**

+ * This event allows to modify the conditions for the post deletion

+ *

+ * @event core.handle_post_delete_conditions

+ * @var int forum_id The id of the forum

+ * @var int topic_id The id of the topic

+ * @var int post_id The id of the post

+ * @var array post_data Array with the post data

+ * @var bool is_soft The flag indicating whether it is the soft delete mode

+ * @var string delete_reason Description for the post deletion reason

+ * @var bool force_delete_allowed Allow the user to delete the post (all permissions and conditions are ignored)

+ * @var bool force_softdelete_allowed Allow the user to softdelete the post (all permissions and conditions are ignored)

+ * @var string perm_check The deletion mode softdelete|delete

+ * @since 3.1.11-RC1

+ */

+ $vars = array(

+ 'forum_id',

+ 'topic_id',

+ 'post_id',

+ 'post_data',

+ 'is_soft',

+ 'delete_reason',

+ 'force_delete_allowed',

+ 'force_softdelete_allowed',

+ 'perm_check',

+ );

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

+

+ if ($force_delete_allowed || ($is_soft && $force_softdelete_allowed) || $auth->acl_get("m_$perm_check", $forum_id) || ($post_data['poster_id'] == $user->data['user_id'] && $user->data['is_registered'] && $auth->acl_get("f_$perm_check", $forum_id) && $post_id == $post_data['topic_last_post_id'] && !$post_data['post_edit_locked'] && ($post_data['post_time'] > time() - ($config['delete_time'] * 60) || !$config['delete_time'])))

+ global $template;

+ $can_delete = $force_delete_allowed || ($auth->acl_get('m_delete', $forum_id) || ($post_data['poster_id'] == $user->data['user_id'] && $user->data['is_registered'] && $auth->acl_get('f_delete', $forum_id)));

+ $can_softdelete = $force_softdelete_allowed || ($auth->acl_get('m_softdelete', $forum_id) || ($post_data['poster_id'] == $user->data['user_id'] && $user->data['is_registered'] && $auth->acl_get('f_softdelete', $forum_id)));

+ AND folder_id = $folder_id

+ AND pm_unread = 1";

+ // If the message is already marked as read, we just skip the rest to avoid negative PM count

+ if (!$db->sql_affectedrows())

+ {

+ return;

+ }

+

+ * @var array user_row Array of user details submited to user_add

+ * @var array cp_data Array of Custom profile fields submited to user_add

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

+ * @var array notifications_data Array of notification data to be inserted when a user is added

+ * @changed 3.1.0-b5 Added user_row and cp_data

+ * @changed 3.1.11-RC1 Added notifications_data

+ $vars = array('user_row', 'cp_data', 'sql_ary', 'notifications_data');

+ global $db, $user, $auth, $cache, $phpbb_dispatcher;

+

+ /**

+ * Use this event to perform actions after the unban has been performed

+ *

+ * @event core.user_unban

+ * @var string mode One of the following: user, ip, email

+ * @var array user_ids_ary Array with user_ids

+ * @since 3.1.11-RC1

+ */

+ $vars = array(

+ 'mode',

+ 'user_ids_ary',

+ );

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

+ return $user->lang(($config['avatar_filesize'] == 0) ? 'AVATAR_EXPLAIN_NO_FILESIZE' : 'AVATAR_EXPLAIN',

+ if (!function_exists('user_ban'))

+ {

+ include($phpbb_root_path . 'includes/functions_user.' . $phpEx);

+ }

+ $redirect = request_var('redirect', "{$phpbb_root_path}mcp.$phpEx?f=$forum_id&amp;i=main&amp;mode=forum_view");

+ * @changed 3.1.0-RC4 Added variables: action, quickmod

+ global $auth, $user, $db, $template, $phpbb_log, $request, $phpbb_dispatcher;

+ /**

+ * Perform actions before shadow topic is created.

+ *

+ * @event core.mcp_main_modify_shadow_sql

+ * @var array shadow SQL array to be used by $db->sql_build_array

+ * @var array row Topic data

+ * @since 3.1.11-RC1

+ * @changed 3.1.11-RC1 Added variable: row

+ */

+ $vars = array(

+ 'shadow',

+ 'row',

+ );

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

+

+ /**

+ * Perform actions before forked topic is created.

+ *

+ * @event core.mcp_main_modify_fork_sql

+ * @var array sql_ary SQL array to be used by $db->sql_build_array

+ * @var array topic_row Topic data

+ * @since 3.1.11-RC1

+ * @changed 3.1.11-RC1 Added variable: topic_row

+ */

+ $vars = array(

+ 'sql_ary',

+ 'topic_row',

+ );

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

+

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

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

+ if (!function_exists('user_ipwhois'))

+ {

+ include($phpbb_root_path . 'includes/functions_user.' . $phpEx);

+ }

+ /** @var \phpbb\pagination $pagination */

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

+

+ $rdns_ip_num = $request->variable('rdns', '');

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

+ $num_users = false;

+ if ($start_users)

+ {

+ $num_users = phpbb_get_num_posters_for_ip($db, $post_info['poster_ip']);

+ $start_users = $pagination->validate_start($start_users, $config['posts_per_page'], $num_users);

+ }

+

+ AND poster_id <> " . (int) $post_info['poster_id'] . "

+ ORDER BY postings DESC, poster_id ASC";

+ $result = $db->sql_query_limit($sql, $config['posts_per_page'], $start_users);

+ $page_users = 0;

+ $page_users++;

+ $users_ary[$row['poster_id']] = $row;

+ }

+ $db->sql_freeresult($result);

+

+ if ($page_users == $config['posts_per_page'] || $start_users)

+ {

+ if ($num_users === false)

+ $num_users = phpbb_get_num_posters_for_ip($db, $post_info['poster_ip']);

+

+ $pagination->generate_template_pagination(

+ $url . '&amp;i=main&amp;mode=post_details',

+ 'pagination',

+ 'start_users',

+ $num_users,

+ $config['posts_per_page'],

+ $start_users

+ );

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

+

+ $num_ips = false;

+ if ($start_ips)

+ {

+ $num_ips = phpbb_get_num_ips_for_poster($db, $post_info['poster_id']);

+ $start_ips = $pagination->validate_start($start_ips, $config['posts_per_page'], $num_ips);

+ }

+ ORDER BY postings DESC, poster_ip ASC";

+ $result = $db->sql_query_limit($sql, $config['posts_per_page'], $start_ips);

+ $page_ips = 0;

+ $page_ips++;

+ if ($page_ips == $config['posts_per_page'] || $start_ips)

+ {

+ if ($num_ips === false)

+ {

+ $num_ips = phpbb_get_num_ips_for_poster($db, $post_info['poster_id']);

+ }

+

+ $pagination->generate_template_pagination(

+ $url . '&amp;i=main&amp;mode=post_details',

+ 'pagination_ips',

+ 'start_ips',

+ $num_ips,

+ $config['posts_per_page'],

+ $start_ips

+ );

+ }

+

+ * Get the number of posters for a given ip

+ *

+ * @param \phpbb\db\driver\driver_interface $db DBAL interface

+ * @param string $poster_ip IP

+ * @return int Number of posters

+ */

+function phpbb_get_num_posters_for_ip(\phpbb\db\driver\driver_interface $db, $poster_ip)

+{

+ $sql = 'SELECT COUNT(DISTINCT poster_id) as num_users

+ FROM ' . POSTS_TABLE . "

+ WHERE poster_ip = '" . $db->sql_escape($poster_ip) . "'";

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

+ $num_users = (int) $db->sql_fetchfield('num_users');

+ $db->sql_freeresult($result);

+

+ return $num_users;

+}

+

+/**

+ * Get the number of ips for a given poster

+ *

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

+ * @param int $poster_id Poster user ID

+ * @return int Number of IPs for given poster

+ */

+function phpbb_get_num_ips_for_poster(\phpbb\db\driver\driver_interface $db, $poster_id)

+{

+ $sql = 'SELECT COUNT(DISTINCT poster_ip) as num_ips

+ FROM ' . POSTS_TABLE . '

+ WHERE poster_id = ' . (int) $poster_id;

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

+ $num_ips = (int) $db->sql_fetchfield('num_ips');

+ $db->sql_freeresult($result);

+

+ return $num_ips;

+}

+

+/**

+ global $phpbb_dispatcher;

+ // Grab data for first post in split topic

+ $sql_array = array(

+ 'SELECT' => 'p.post_id, p.forum_id, p.poster_id, p.post_text, f.enable_indexing',

+ 'FROM' => array(

+ POSTS_TABLE => 'p',

+ ),

+ 'LEFT_JOIN' => array(

+ array(

+ 'FROM' => array(FORUMS_TABLE => 'f'),

+ 'ON' => 'p.forum_id = f.forum_id',

+ )

+ ),

+ 'WHERE' => "post_id = {$post_id_list[0]}",

+ );

+ $sql = $db->sql_build_query('SELECT', $sql_array);

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

+ $first_post_data = $db->sql_fetchrow($result);

+ $db->sql_freeresult($result);

+

+ // Index first post as if it were edited

+ if ($first_post_data['enable_indexing'])

+ {

+ // Select the search method and do some additional checks to ensure it can actually be utilised

+ $search_type = $config['search_type'];

+

+ if (!class_exists($search_type))

+ {

+ trigger_error('NO_SUCH_SEARCH_MODULE');

+ }

+

+ $error = false;

+ $search = new $search_type($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user, $phpbb_dispatcher);

+

+ if ($error)

+ {

+ trigger_error($error);

+ }

+

+ $search->index('edit', $first_post_data['post_id'], $first_post_data['post_text'], $subject, $first_post_data['poster_id'], $first_post_data['forum_id']);

+ }

+

+ global $db, $template, $user, $phpEx, $phpbb_root_path, $auth, $phpbb_dispatcher;

+ /**

+ * Perform additional actions after merging posts.

+ *

+ * @event core.mcp_topics_merge_posts_after

+ * @var int topic_id The topic ID from which posts are being moved

+ * @var int to_topic_id The topic ID to which posts are being moved

+ * @since 3.1.11-RC1

+ */

+ $vars = array(

+ 'topic_id',

+ 'to_topic_id',

+ );

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

+

+ * @changed 3.1.3-RC1 Added vars $bbcode_bitfield and $bbcode_uid

+ /**

+ * Predefine message text and subject

+ *

+ * @event core.ucp_pm_compose_predefined_message

+ * @var string message_text Message text

+ * @var string message_subject Messate subject

+ * @since 3.1.11-RC1

+ */

+ $vars = array('message_text', 'message_subject');

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

+

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

+ $template_vars = array(

+ );

+

+ /**

+ * Modify template variables before they are assigned

+ *

+ * @event core.ucp_pm_view_folder_get_pm_from_template

+ * @var int folder_id Folder ID

+ * @var array folder Folder data

+ * @var int user_id User ID

+ * @var string base_url Pagination base URL

+ * @var int start Pagination start

+ * @var int pm_count Count of PMs

+ * @var array template_vars Template variables to be assigned

+ * @since 3.1.11-RC1

+ */

+ $vars = array(

+ 'folder_id',

+ 'folder',

+ 'user_id',

+ 'base_url',

+ 'start',

+ 'pm_count',

+ 'template_vars',

+ );

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

+

+ $template->assign_vars($template_vars);

+ $sql_ary = array(

+ 'SELECT' => 't.*, p.root_level, p.message_time, p.message_subject, p.icon_id, p.to_address, p.message_attachment, p.bcc_address, u.username, u.username_clean, u.user_colour, p.message_reported',

+ 'FROM' => array(

+ PRIVMSGS_TO_TABLE => 't',

+ PRIVMSGS_TABLE => 'p',

+ USERS_TABLE => 'u',

+ ),

+ 'WHERE' => "t.user_id = $user_id

+ $sql_limit_time",

+ 'ORDER_BY' => $sql_sort_order,

+ );

+

+ /**

+ * Modify SQL before it is executed

+ *

+ * @event core.ucp_pm_view_folder_get_pm_from_sql

+ * @var array sql_ary SQL array

+ * @var int sql_limit SQL limit

+ * @var int sql_start SQL start

+ * @since 3.1.11-RC1

+ */

+ $vars = array(

+ 'sql_ary',

+ 'sql_limit',

+ 'sql_start',

+ );

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

+

+ $result = $db->sql_query_limit($db->sql_build_query('SELECT', $sql_ary), $sql_limit, $sql_start);

+ /**

+ * Trigger events on successfull avatar change

+ *

+ * @event core.ucp_profile_avatar_sql

+ * @var array result Array with data to be stored in DB

+ * @since 3.1.11-RC1

+ */

+ $vars = array('result');

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

+

+ /**

+ * Add UCP register data before they are assigned to the template or submitted

+ *

+ * To assign data to the template, use $template->assign_vars()

+ *

+ * @event core.ucp_register_requests_after

+ * @var bool coppa Is set coppa

+ * @var bool agreed Did user agree to coppa?

+ * @var bool submit Is set post submit?

+ * @var string change_lang Change language request

+ * @var string user_lang User language request

+ * @since 3.1.11-RC1

+ */

+ $vars = array(

+ 'coppa',

+ 'agreed',

+ 'submit',

+ 'change_lang',

+ 'user_lang',

+ );

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

+

+ global $db, $user, $auth, $template, $phpbb_container, $phpbb_dispatcher;

+ add_form_key('ucp_remind');

+

+ if (!check_form_key('ucp_remind'))

+ {

+ trigger_error('FORM_INVALID');

+ }

+

+ $sql_array = array(

+ 'SELECT' => 'user_id, username, user_permissions, user_email, user_jabber, user_notify_type, user_type, user_lang, user_inactive_reason',

+ 'FROM' => array(USERS_TABLE => 'u'),

+ 'WHERE' => "user_email_hash = '" . $db->sql_escape(phpbb_email_hash($email)) . "'

+ AND username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'"

+ );

+

+ /**

+ * Change SQL query for fetching user data

+ *

+ * @event core.ucp_remind_modify_select_sql

+ * @var string email User's email from the form

+ * @var string username User's username from the form

+ * @var array sql_array Fully assembled SQL query with keys SELECT, FROM, WHERE

+ * @since 3.1.11-RC1

+ */

+ $vars = array(

+ 'email',

+ 'username',

+ 'sql_array',

+ );

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

+

+ $sql = $db->sql_build_query('SELECT', $sql_array);

+ 'phpbb_version' => '3.1.11',

+INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '3.1.11-RC1');

+ 'MAX_THUMB_WIDTH' => 'Maximum thumbnail width/height in pixel',

+ 'ACP_COOKIE_SETTINGS_EXPLAIN' => 'These details define the data used to send cookies to your users browsers. In most cases the default values for the cookie settings should be sufficient. If you do need to change any do so with care, incorrect settings can prevent users logging in. If you have problems with users staying logging in to your board, visit the <b><a href="https://www.phpbb.com/support/go/cookie-settings/">phpBB.com Knowledge Base - Fixing incorrect cookie settings</a></b>.',

+ 'COOKIE_DOMAIN_EXPLAIN' => 'In most cases the cookie domain is optional. Leave it blank if you are unsure.<br /><br /> In the case where you have a board integrated with other software or have multiple domains, then to determine the cookie domain you need to do the following. If you have something like <i>example.com</i> and <i>forums.example.com</i>, or perhaps <i>forums.example.com</i> and <i>blog.example.com</i>. Remove the subdomains until you find the common domain, <i>example.com</i>. Now add a dot in front of the common domain and you would enter .example.com (note the dot at the beginning).',

+ 'COOKIE_NAME_EXPLAIN' => 'This can be anything what you want, make it original. Whenever the cookie settings are changed the name of the cookie should be changed.',

+ 'COOKIE_PATH_EXPLAIN' => 'Note that this is always a slash, it does not matter what your board URL is.',

+ 'SMTP_ALLOW_SELF_SIGNED' => 'Allow self-signed SSL certificates',

+ 'SMTP_ALLOW_SELF_SIGNED_EXPLAIN'=> 'Allow connections to SMTP server with self-signed SSL certificate.<em><strong>Warning:</strong> Allowing self-signed SSL certificates may cause security implications.</em>',

+ 'SMTP_VERIFY_PEER' => 'Verify SSL certificate',

+ 'SMTP_VERIFY_PEER_EXPLAIN' => 'Require verification of SSL certificate used by SMTP server.<em><strong>Warning:</strong> Connecting peers with unverified SSL certificates may cause security implications.</em>',

+ 'SMTP_VERIFY_PEER_NAME' => 'Verify SMTP peer name',

+ 'SMTP_VERIFY_PEER_NAME_EXPLAIN' => 'Require verification of peer name for SMTP servers using SSL / TLS connections.<em><strong>Warning:</strong> Connecting to unverified peers may cause security implications.</em>',

+

+ 'JAB_ALLOW_SELF_SIGNED' => 'Allow self-signed SSL certificates',

+ 'JAB_ALLOW_SELF_SIGNED_EXPLAIN' => 'Allow connections to Jabber server with self-signed SSL certificate.<em><strong>Warning:</strong> Allowing self-signed SSL certificates may cause security implications.</em>',

+ 'JAB_ENABLE' => 'Enable Jabber',

+ 'JAB_ENABLE_EXPLAIN' => 'Enables use of Jabber messaging and notifications.',

+ 'JAB_GTALK_NOTE' => 'Please note that GTalk will not work because the <samp>dns_get_record</samp> function could not be found. This function is not available in PHP4, and is not implemented on Windows platforms. It currently does not work on BSD-based systems, including Mac OS.',

+ 'JAB_PACKAGE_SIZE' => 'Jabber package size',

+ 'JAB_PACKAGE_SIZE_EXPLAIN' => 'This is the number of messages sent in one package. If set to 0 the message is sent immediately and will not be queued for later sending.',

+ 'JAB_PASSWORD' => 'Jabber password',

+ 'JAB_PASSWORD_EXPLAIN' => '<em><strong>Warning:</strong> This password will be stored as plain text in the database, visible to everybody who can access your database or who can view this configuration page.</em>',

+ 'JAB_PORT' => 'Jabber port',

+ 'JAB_PORT_EXPLAIN' => 'Leave blank unless you know it is not port 5222.',

+ 'JAB_SERVER' => 'Jabber server',

+ 'JAB_SERVER_EXPLAIN' => 'See %sjabber.org%s for a list of servers.',

+ 'JAB_SETTINGS_CHANGED' => 'Jabber settings changed successfully.',

+ 'JAB_USE_SSL' => 'Use SSL to connect',

+ 'JAB_USE_SSL_EXPLAIN' => 'If enabled a secure connection is tried to be established. The Jabber port will be modified to 5223 if port 5222 is specified.',

+ 'JAB_USERNAME' => 'Jabber username or JID',

+ 'JAB_USERNAME_EXPLAIN' => 'Specify a registered username or a valid JID. The username will not be checked for validity. If you only specify a username, then your JID will be the username and the server you specified above. Else, specify a valid JID, for example user@jabber.org.',

+ 'JAB_VERIFY_PEER' => 'Verify SSL certificate',

+ 'JAB_VERIFY_PEER_EXPLAIN' => 'Require verification of SSL certificate used by Jabber server.<em><strong>Warning:</strong> Connecting peers with unverified SSL certificates may cause security implications.</em>',

+ 'JAB_VERIFY_PEER_NAME' => 'Verify Jabber peer name',

+ 'JAB_VERIFY_PEER_NAME_EXPLAIN' => 'Require verification of peer name for Jabber servers using SSL / TLS connections.<em><strong>Warning:</strong> Connecting to unverified peers may cause security implications.</em>',

+ 'PHP_VERSION_OLD' => 'The version of PHP on this server (%1$s) will no longer be supported by future versions of phpBB. The minimum required version will be PHP %2$s. %3$sDetails%4$s',

+ 'STYLE_VERSION' => 'Style version',

+ 'CLI_DESCRIPTION_FIX_LEFT_RIGHT_IDS' => 'Repairs the tree structure of the forums and modules.',

+ 'CLI_DESCRIPTION_UPDATE_HASH_BCRYPT' => 'Updates outdated password hashes to be hashed with bcrypt.',

+ 'CLI_FIXUP_FIX_LEFT_RIGHT_IDS_SUCCESS' => 'Successfully repaired the tree structure of the forums and modules.',

+ 'CLI_FIXUP_UPDATE_HASH_BCRYPT_SUCCESS' => 'Successfully updated outdated password hashes to bcrypt.'

+ 'INVALID_FEED_ATTACHMENTS' => 'The selected feed tried fetching attachments with invalid constraints.',

+ 'UPGRADE_INSTRUCTIONS' => 'A new feature release <strong>%1$s</strong> is available. Please read <a href="%2$s" title="%2$s"><strong>the release announcement</strong></a> to learn about what it has to offer, and how to upgrade.',

+ 'AVATAR_EXPLAIN_NO_FILESIZE' => 'Maximum dimensions; width: %1$s, height: %2$s.',

+ if (!function_exists('user_get_id_name'))

+ {

+ include($phpbb_root_path . 'includes/functions_user.' . $phpEx);

+ }

+ global $db, $cache, $phpbb_dispatcher;

+ /**

+ * Event is triggered after user(s) permission settings cache has been cleared

+ *

+ * @event core.acl_clear_prefetch_after

+ * @var mixed user_id User ID(s)

+ * @since 3.1.11-RC1

+ */

+ $vars = array('user_id');

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

+

+ * phpBB event dispatcher

+ *

+ * @var \phpbb\event\dispatcher_interface

+ */

+ protected $dispatcher;

+

+ /**

+ * @param \phpbb\event\dispatcher_interface $dispatcher phpBB event dispatcher

+ public function __construct(\phpbb\db\driver\driver_interface $db, \phpbb\config\config $config, \phpbb\passwords\manager $passwords_manager, \phpbb\request\request_interface $request, \phpbb\user $user, $auth_provider_oauth_token_storage_table, $auth_provider_oauth_token_account_assoc, \phpbb\di\service_collection $service_providers, $users_table, \Symfony\Component\DependencyInjection\ContainerInterface $phpbb_container, \phpbb\event\dispatcher_interface $dispatcher, $phpbb_root_path, $php_ext)

+ $this->dispatcher = $dispatcher;

+ /**

+ * Event is triggered after user is successfuly logged in via OAuth.

+ *

+ * @event core.auth_oauth_login_after

+ * @var array row User row

+ * @since 3.1.11-RC1

+ */

+ $vars = array(

+ 'row',

+ );

+ extract($this->dispatcher->trigger_event('core.auth_oauth_login_after', compact($vars)));

+

+

+ /**

+ * Event is triggered after user links account.

+ *

+ * @event core.auth_oauth_link_after

+ * @var array data User row

+ * @since 3.1.11-RC1

+ */

+ $vars = array(

+ 'data',

+ );

+ extract($this->dispatcher->trigger_event('core.auth_oauth_link_after', compact($vars)));

+ return str_replace(array('/', '\\'), '-', $varname);

+ preg_match('#(.*)/(\d+)#', $u, $parts);

+ $this->memcache->addServer(trim($parts[1]), (int) trim($parts[2]));

+<?php

+/**

+*

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

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\cache\driver;

+

+if (!defined('PHPBB_ACM_MEMCACHED_PORT'))

+{

+ define('PHPBB_ACM_MEMCACHED_PORT', 11211);

+}

+

+if (!defined('PHPBB_ACM_MEMCACHED_COMPRESS'))

+{

+ define('PHPBB_ACM_MEMCACHED_COMPRESS', true);

+}

+

+if (!defined('PHPBB_ACM_MEMCACHED_HOST'))

+{

+ define('PHPBB_ACM_MEMCACHED_HOST', 'localhost');

+}

+

+if (!defined('PHPBB_ACM_MEMCACHED'))

+{

+ //can define multiple servers with host1/port1,host2/port2 format

+ define('PHPBB_ACM_MEMCACHED', PHPBB_ACM_MEMCACHED_HOST . '/' . PHPBB_ACM_MEMCACHED_PORT);

+}

+

+/**

+* ACM for Memcached

+*/

+class memcached extends \phpbb\cache\driver\memory

+{

+ /** @var string Extension to use */

+ protected $extension = 'memcached';

+

+ /** @var \Memcached Memcached class */

+ protected $memcached;

+

+ /** @var int Flags */

+ protected $flags = 0;

+

+ /**

+ * Memcached constructor

+ */

+ public function __construct()

+ {

+ // Call the parent constructor

+ parent::__construct();

+

+ $this->memcached = new \Memcached();

+ $this->memcached->setOption(\Memcached::OPT_BINARY_PROTOCOL, true);

+ // Memcached defaults to using compression, disable if we don't want

+ // to use it

+ if (!PHPBB_ACM_MEMCACHED_COMPRESS)

+ {

+ $this->memcached->setOption(\Memcached::OPT_COMPRESSION, false);

+ }

+

+ foreach (explode(',', PHPBB_ACM_MEMCACHE) as $u)

+ {

+ preg_match('#(.*)/(\d+)#', $u, $parts);

+ $this->memcache->addServer(trim($parts[1]), (int) trim($parts[2]));

+ }

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function unload()

+ {

+ parent::unload();

+

+ unset($this->memcached);

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function purge()

+ {

+ $this->memcached->flush();

+

+ parent::purge();

+ }

+

+ /**

+ * Fetch an item from the cache

+ *

+ * @param string $var Cache key

+ *

+ * @return mixed Cached data

+ */

+ protected function _read($var)

+ {

+ return $this->memcached->get($this->key_prefix . $var);

+ }

+

+ /**

+ * Store data in the cache

+ *

+ * @param string $var Cache key

+ * @param mixed $data Data to store

+ * @param int $ttl Time-to-live of cached data

+ * @return bool True if the operation succeeded

+ */

+ protected function _write($var, $data, $ttl = 2592000)

+ {

+ if (!$this->memcached->replace($this->key_prefix . $var, $data, $ttl))

+ {

+ return $this->memcached->set($this->key_prefix . $var, $data, $ttl);

+ }

+ return true;

+ }

+

+ /**

+ * Remove an item from the cache

+ *

+ * @param string $var Cache key

+ * @return bool True if the operation succeeded

+ */

+ protected function _delete($var)

+ {

+ return $this->memcached->delete($this->key_prefix . $var);

+ }

+}

+<?php

+/**

+*

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

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\console\command\fixup;

+

+use Symfony\Component\Console\Input\InputInterface;

+use Symfony\Component\Console\Output\OutputInterface;

+

+class fix_left_right_ids extends \phpbb\console\command\command

+{

+ /** @var \phpbb\user */

+ protected $user;

+

+ /** @var \phpbb\db\driver\driver_interface */

+ protected $db;

+

+ /** @var \phpbb\cache\driver\driver_interface */

+ protected $cache;

+

+ /**

+ * Constructor

+ *

+ * @param \phpbb\user $user User instance

+ * @param \phpbb\db\driver\driver_interface $db Database connection

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

+ */

+ public function __construct(\phpbb\user $user, \phpbb\db\driver\driver_interface $db, \phpbb\cache\driver\driver_interface $cache)

+ {

+ $this->user = $user;

+ $this->db = $db;

+ $this->cache = $cache;

+

+ parent::__construct($user);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ protected function configure()

+ {

+ $this

+ ->setName('fixup:fix-left-right-ids')

+ ->setDescription($this->user->lang('CLI_DESCRIPTION_FIX_LEFT_RIGHT_IDS'))

+ ;

+ }

+

+ /**

+ * Executes the command fixup:fix-left-right-ids.

+ *

+ * Repairs the tree structure of the forums and modules.

+ * The code is mainly borrowed from Support toolkit for phpBB Olympus

+ *

+ * @param InputInterface $input An InputInterface instance

+ * @param OutputInterface $output An OutputInterface instance

+ *

+ * @return void

+ */

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

+ {

+ // Fix Left/Right IDs for the modules table

+ $result = $this->db->sql_query('SELECT DISTINCT(module_class) FROM ' . MODULES_TABLE);

+ while ($row = $this->db->sql_fetchrow($result))

+ {

+ $i = 1;

+ $where = array("module_class = '" . $this->db->sql_escape($row['module_class']) . "'");

+ $this->fix_ids_tree($i, 'module_id', MODULES_TABLE, 0, $where);

+ }

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

+

+ // Fix the Left/Right IDs for the forums table

+ $i = 1;

+ $this->fix_ids_tree($i, 'forum_id', FORUMS_TABLE);

+

+ $this->cache->purge();

+

+ $output->writeln('<info>' . $this->user->lang('CLI_FIXUP_FIX_LEFT_RIGHT_IDS_SUCCESS') . '</info>');

+ }

+

+ /**

+ * Item's tree structure rebuild helper

+ * The item is either forum or ACP/MCP/UCP module

+ *

+ * @param int $i Item id offset index

+ * @param string $field The key field to fix, forum_id|module_id

+ * @param string $table The table name to perform, FORUMS_TABLE|MODULES_TABLE

+ * @param int $parent_id Parent item id

+ * @param array $where Additional WHERE clause condition

+ *

+ * @return bool True on rebuild success, false otherwise

+ */

+ protected function fix_ids_tree(&$i, $field, $table, $parent_id = 0, $where = array())

+ {

+ $changes_made = false;

+ $sql = 'SELECT * FROM ' . $table . '

+ WHERE parent_id = ' . (int) $parent_id .

+ ((!empty($where)) ? ' AND ' . implode(' AND ', $where) : '') . '

+ ORDER BY left_id ASC';

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

+ while ($row = $this->db->sql_fetchrow($result))

+ {

+ // Update the left_id for the item

+ if ($row['left_id'] != $i)

+ {

+ $this->db->sql_query('UPDATE ' . $table . ' SET ' . $this->db->sql_build_array('UPDATE', array('left_id' => $i)) . " WHERE $field = " . (int) $row[$field]);

+ $changes_made = true;

+ }

+ $i++;

+

+ // Go through children and update their left/right IDs

+ $changes_made = (($this->fix_ids_tree($i, $field, $table, $row[$field], $where)) || $changes_made) ? true : false;

+

+ // Update the right_id for the item

+ if ($row['right_id'] != $i)

+ {

+ $this->db->sql_query('UPDATE ' . $table . ' SET ' . $this->db->sql_build_array('UPDATE', array('right_id' => $i)) . " WHERE $field = " . (int) $row[$field]);

+ $changes_made = true;

+ }

+ $i++;

+ }

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

+

+ return $changes_made;

+ }

+}

+<?php

+/**

+*

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

+* the docs/CREDITS.txt file.

+*

+*/

+namespace phpbb\console\command\fixup;

+

+use Symfony\Component\Console\Input\InputInterface;

+use Symfony\Component\Console\Output\OutputInterface;

+use Symfony\Component\Console\Helper\ProgressBar;

+

+class update_hashes extends \phpbb\console\command\command

+{

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

+ protected $config;

+

+ /** @var \phpbb\db\driver\driver_interface */

+ protected $db;

+

+ /** @var \phpbb\passwords\manager */

+ protected $passwords_manager;

+

+ /** @var string Default hashing type */

+ protected $default_type;

+

+ /**

+ * Update_hashes constructor

+ *

+ * @param \phpbb\config\config $config

+ * @param \phpbb\user $user

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

+ * @param \phpbb\passwords\manager $passwords_manager

+ * @param array $hashing_algorithms Hashing driver

+ * service collection

+ * @param array $defaults Default password types

+ */

+ public function __construct(\phpbb\config\config $config, \phpbb\user $user,

+ \phpbb\db\driver\driver_interface $db, \phpbb\passwords\manager $passwords_manager,

+ $hashing_algorithms, $defaults)

+ {

+ $this->config = $config;

+ $this->db = $db;

+

+ $this->passwords_manager = $passwords_manager;

+

+ foreach ($defaults as $type)

+ {

+ if ($hashing_algorithms[$type]->is_supported())

+ {

+ $this->default_type = $type;

+ break;

+ }

+ }

+

+ parent::__construct($user);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ protected function configure()

+ {

+ $this

+ ->setName('fixup:update-hashes')

+ ->setDescription($this->user->lang('CLI_DESCRIPTION_UPDATE_HASH_BCRYPT'))

+ ;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

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

+ {

+ // Get count to be able to display progress

+ $sql = 'SELECT COUNT(user_id) AS count

+ FROM ' . USERS_TABLE . '

+ WHERE user_password ' . $this->db->sql_like_expression('$H$' . $this->db->get_any_char()) . '

+ OR user_password ' . $this->db->sql_like_expression('$CP$' . $this->db->get_any_char());

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

+ $total_update_passwords = $this->db->sql_fetchfield('count');

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

+

+ // Create progress bar

+ $progress_bar = new ProgressBar($output, $total_update_passwords);

+ $progress_bar->start();

+

+ $sql = 'SELECT user_id, user_password

+ FROM ' . USERS_TABLE . '

+ WHERE user_password ' . $this->db->sql_like_expression('$H$' . $this->db->get_any_char()) . '

+ OR user_password ' . $this->db->sql_like_expression('$CP$' . $this->db->get_any_char());

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

+

+ while ($row = $this->db->sql_fetchrow($result))

+ {

+ $new_hash = $this->passwords_manager->hash($row['user_password'], array($this->default_type));

+

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_password = "' . $this->db->sql_escape($new_hash) . '"

+ WHERE user_id = ' . (int) $row['user_id'];

+ $this->db->sql_query($sql);

+ $progress_bar->advance();

+ }

+

+ $this->config->set('update_hashes_last_cron', time());

+

+ $progress_bar->finish();

+

+ $output->writeln('<info>' . $this->user->lang('CLI_FIXUP_UPDATE_HASH_BCRYPT_SUCCESS') . '</info>');

+ }

+}

+<?php

+/**

+ *

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

+ * the docs/CREDITS.txt file.

+ *

+ */

+

+namespace phpbb\cron\task\core;

+

+/**

+ * Update old hashes to the current default hashing algorithm

+ *

+ * It is intended to gradually update all "old" style hashes to the

+ * current default hashing algorithm.

+ */

+class update_hashes extends \phpbb\cron\task\base

+{

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

+ protected $config;

+

+ /** @var \phpbb\db\driver\driver_interface */

+ protected $db;

+

+ /** @var \phpbb\lock\db */

+ protected $update_lock;

+

+ /** @var \phpbb\passwords\manager */

+ protected $passwords_manager;

+

+ /** @var string Default hashing type */

+ protected $default_type;

+

+ /**

+ * Constructor.

+ *

+ * @param \phpbb\config\config $config

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

+ * @param \phpbb\lock\db $update_lock

+ * @param \phpbb\passwords\manager $passwords_manager

+ * @param array $hashing_algorithms Hashing driver

+ * service collection

+ * @param array $defaults Default password types

+ */

+ public function __construct(\phpbb\config\config $config, \phpbb\db\driver\driver_interface $db, \phpbb\lock\db $update_lock, \phpbb\passwords\manager $passwords_manager, $hashing_algorithms, $defaults)

+ {

+ $this->config = $config;

+ $this->db = $db;

+ $this->passwords_manager = $passwords_manager;

+ $this->update_lock = $update_lock;

+

+ foreach ($defaults as $type)

+ {

+ if ($hashing_algorithms[$type]->is_supported())

+ {

+ $this->default_type = $type;

+ break;

+ }

+ }

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function is_runnable()

+ {

+ return !$this->config['use_system_cron'];

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function should_run()

+ {

+ if (!empty($this->config['update_hashes_lock']))

+ {

+ $last_run = explode(' ', $this->config['update_hashes_lock']);

+ if ($last_run[0] + 60 >= time())

+ {

+ return false;

+ }

+ }

+

+ return $this->config['enable_update_hashes'] && $this->config['update_hashes_last_cron'] < (time() - 60);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function run()

+ {

+ if ($this->update_lock->acquire())

+ {

+ $sql = 'SELECT user_id, user_password

+ FROM ' . USERS_TABLE . '

+ WHERE user_password ' . $this->db->sql_like_expression('$H$' . $this->db->get_any_char()) . '

+ OR user_password ' . $this->db->sql_like_expression('$CP$' . $this->db->get_any_char());

+ $result = $this->db->sql_query_limit($sql, 20);

+

+ $affected_rows = 0;

+

+ while ($row = $this->db->sql_fetchrow($result))

+ {

+ $new_hash = $this->passwords_manager->hash($row['user_password'], array($this->default_type));

+

+ // Increase number so we know that users were selected from the database

+ $affected_rows++;

+

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_password = "' . $this->db->sql_escape($new_hash) . '"

+ WHERE user_id = ' . (int) $row['user_id'];

+ $this->db->sql_query($sql);

+ }

+

+ $this->config->set('update_hashes_last_cron', time());

+ $this->update_lock->release();

+

+ // Stop cron for good once all hashes are converted

+ if ($affected_rows === 0)

+ {

+ $this->config->set('enable_update_hashes', '0');

+ }

+ }

+ }

+}

+ $start = $start ?: 0;

+<?php

+/**

+*

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

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v31x;

+

+class add_jabber_ssl_context_config_options extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v31x\v3110');

+ }

+

+ public function update_data()

+ {

+ return array(

+ // See http://php.net/manual/en/context.ssl.php

+ array('config.add', array('jab_verify_peer', 1)),

+ array('config.add', array('jab_verify_peer_name', 1)),

+ array('config.add', array('jab_allow_self_signed', 0)),

+ );

+ }

+}

+<?php

+/**

+ *

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

+ * the docs/CREDITS.txt file.

+ *

+ */

+

+namespace phpbb\db\migration\data\v31x;

+

+class add_latest_topics_index extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v31x\v3110',

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_index' => array(

+ $this->table_prefix . 'topics' => array(

+ 'latest_topics' => array(

+ 'forum_id',

+ 'topic_last_post_time',

+ 'topic_last_post_id',

+ 'topic_moved_id',

+ ),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_keys' => array(

+ $this->table_prefix . 'topics' => array(

+ 'latest_topics',

+ ),

+ ),

+ );

+ }

+}

+<?php

+/**

+*

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

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v31x;

+

+class add_smtp_ssl_context_config_options extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v31x\v3110');

+ }

+

+ public function update_data()

+ {

+ return array(

+ // See http://php.net/manual/en/context.ssl.php

+ array('config.add', array('smtp_verify_peer', 1)),

+ array('config.add', array('smtp_verify_peer_name', 1)),

+ array('config.add', array('smtp_allow_self_signed', 0)),

+ );

+ }

+}

+<?php

+/**

+*

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

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v31x;

+

+class increase_size_of_emotion extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v31x\v3110',

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'change_columns' => array(

+ $this->table_prefix . 'smilies' => array(

+ 'emotion' => array('VCHAR_UNI', ''),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'change_columns' => array(

+ $this->table_prefix . 'smilies' => array(

+ 'emotion' => array('VCHAR_UNI:50', ''),

+ ),

+ ),

+ );

+ }

+}

+<?php

+

+/**

+ *

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

+ * the docs/CREDITS.txt file.

+ *

+ */

+

+namespace phpbb\db\migration\data\v31x;

+

+class remove_duplicate_migrations extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v31x\v3110');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array($this, 'deduplicate_entries'))),

+ );

+ }

+

+ public function deduplicate_entries()

+ {

+ $migration_state = array();

+ $duplicate_migrations = array();

+

+ $sql = "SELECT *

+ FROM " . $this->table_prefix . 'migrations';

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

+

+ if (!$this->db->get_sql_error_triggered())

+ {

+ while ($migration = $this->db->sql_fetchrow($result))

+ {

+ $migration_state[$migration['migration_name']] = $migration;

+

+ $migration_state[$migration['migration_name']]['migration_depends_on'] = unserialize($migration['migration_depends_on']);

+ }

+ }

+

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

+

+ foreach ($migration_state as $name => $migration)

+ {

+ $prepended_name = ($name[0] == '\\' ? '' : '\\') . $name;

+ $prefixless_name = $name[0] == '\\' ? substr($name, 1) : $name;

+

+ if ($prepended_name != $name && isset($migration_state[$prepended_name]) && $migration_state[$prepended_name]['migration_depends_on'] == $migration_state[$name]['migration_depends_on'])

+ {

+ $duplicate_migrations[] = $name;

+ unset($migration_state[$prepended_name]);

+ }

+ else if ($prefixless_name != $name && isset($migration_state[$prefixless_name]) && $migration_state[$prefixless_name]['migration_depends_on'] == $migration_state[$name]['migration_depends_on'])

+ {

+ $duplicate_migrations[] = $prefixless_name;

+ unset($migration_state[$prefixless_name]);

+ }

+ }

+

+ if (count($duplicate_migrations))

+ {

+ $sql = 'DELETE

+ FROM ' . $this->table_prefix . 'migrations

+ WHERE ' . $this->db->sql_in_set('migration_name', $duplicate_migrations);

+ $this->db->sql_query($sql);

+ }

+ }

+}

+<?php

+/**

+ *

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

+ * the docs/CREDITS.txt file.

+ *

+ */

+

+namespace phpbb\db\migration\data\v31x;

+

+class update_hashes extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v31x\v3110',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('enable_update_hashes', '1')),

+ array('config.add', array('update_hashes_lock', '')),

+ array('config.add', array('update_hashes_last_cron', '0'))

+ );

+ }

+}

+<?php

+/**

+*

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

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\migration\data\v31x;

+

+class v3111rc1 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.1.11-RC1', '>=');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v31x\v3110',

+ '\phpbb\db\migration\data\v31x\add_log_time_index',

+ '\phpbb\db\migration\data\v31x\increase_size_of_emotion',

+ '\phpbb\db\migration\data\v31x\add_jabber_ssl_context_config_options',

+ '\phpbb\db\migration\data\v31x\add_smtp_ssl_context_config_options',

+ '\phpbb\db\migration\data\v31x\update_hashes',

+ '\phpbb\db\migration\data\v31x\remove_duplicate_migrations',

+ '\phpbb\db\migration\data\v31x\add_latest_topics_index',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.1.11-RC1')),

+ );

+ }

+}

+ $start = $start ?: 0;

+ * Get a valid migration name from the migration state array in case the

+ * supplied name is not in the migration state list.

+ *

+ * @param string $name Migration name

+ * @return string Migration name

+ */

+ protected function get_valid_name($name)

+ {

+ // Try falling back to a valid migration name with or without leading backslash

+ if (!isset($this->migration_state[$name]))

+ {

+ $prepended_name = ($name[0] == '\\' ? '' : '\\') . $name;

+ $prefixless_name = $name[0] == '\\' ? substr($name, 1) : $name;

+

+ if (isset($this->migration_state[$prepended_name]))

+ {

+ $name = $prepended_name;

+ }

+ else if (isset($this->migration_state[$prefixless_name]))

+ {

+ $name = $prefixless_name;

+ }

+ }

+

+ return $name;

+ }

+

+ /**

+ $name = $this->get_valid_name($name);

+

+ $depend = $this->get_valid_name($depend);

+

+ // Test all possible namings before throwing exception

+ $name = $this->get_valid_name($name);

+

+ $depend = $this->get_valid_name($depend);

+ $this->inject_dbal_driver();

+ * Inject the dbal connection driver into container

+ */

+ protected function inject_dbal_driver()

+ {

+ $config_data = $this->config_php_file->get_all();

+ if (!empty($config_data))

+ {

+ $this->container->set('dbal.conn.driver', $this->get_dbal_connection());

+ }

+ }

+

+ /**

+ false,

+ $this->type_caster->set_var($message, $message, 'string', true, false);

+ * @param string $tag_name Should be 'change', not 'changed'

+ preg_match('#^\* @changed (\d+\.\d+\.\d+(?:-(?:a|b|RC|pl)\d+)?)( (?:.*))?$#', $line, $match);

+ * @param \phpbb\template\template $template The template manager or null

+ public function create_extension_metadata_manager($name, \phpbb\template\template $template = null)

+ if ($this->is_available($ext_name))

+ $available[$ext_name] = $this->phpbb_root_path . 'ext/' . $ext_name . '/';

+ $md_manager = $this->create_extension_metadata_manager($name);

+ try

+ {

+ return $md_manager->get_metadata('all') && $md_manager->validate_enable();

+ }

+ catch (\phpbb\extension\exception $e)

+ {

+ return false;

+ }

+ // @codingStandardsIgnoreStart

+ * @param \phpbb\template\template $template phpBB Template instance or null

+ public function __construct($ext_name, \phpbb\config\config $config, \phpbb\extension\manager $extension_manager, \phpbb\template\template $template = null, \phpbb\user $user, $phpbb_root_path)

+ // @codingStandardsIgnoreEnd

+ // Fetch and clean the metadata if not done yet

+ if ($this->metadata_file === '')

+ {

+ $this->fetch_metadata_from_file();

+ }

+ $this->validate();

+ case 'version':

+ $this->validate($element);

+ return $this->metadata[$element];

+ return (isset($this->metadata['extra']['display-name'])) ? $this->metadata['extra']['display-name'] : $this->get_metadata('name');

+ * Sets the path of the metadata file, gets its contents and cleans loaded file

+ private function fetch_metadata_from_file()

+ if (!($file_contents = file_get_contents($this->metadata_file)))

+ throw new \phpbb\extension\exception($this->user->lang('FILE_CONTENT_ERR', $this->metadata_file));

+ if (($metadata = json_decode($file_contents, true)) === null)

+ {

+ throw new \phpbb\extension\exception($this->user->lang('FILE_JSON_DECODE_ERR', $this->metadata_file));

+

+ array_walk_recursive($metadata, array($this, 'sanitize_json'));

+ $this->metadata = $metadata;

+ // no break

+ * @return bool True if validation succeeded, throws an exception if invalid

+ * @throws \phpbb\extension\exception

+ return $this->validate_dir() && $this->validate_require_phpbb() && $this->validate_require_php();

+ * @return boolean True when passes validation, throws an exception if invalid

+ * @throws \phpbb\extension\exception

+ if (substr_count($this->ext_name, '/') !== 1 || $this->ext_name != $this->get_metadata('name'))

+ {

+ throw new \phpbb\extension\exception($this->user->lang('EXTENSION_DIR_INVALID'));

+ }

+

+ return true;

+ * @return boolean True when passes validation, throws an exception if invalid

+ * @throws \phpbb\extension\exception

+ throw new \phpbb\extension\exception($this->user->lang('META_FIELD_NOT_SET', 'soft-require'));

+ * @return boolean True when passes validation, throws an exception if invalid

+ * @throws \phpbb\extension\exception

+ throw new \phpbb\extension\exception($this->user->lang('META_FIELD_NOT_SET', 'require php'));

+ 'META_REQUIRE_PHP_FAIL' => (isset($this->metadata['require']['php'])) ? false : true,

+ 'META_REQUIRE_PHPBB_FAIL' => (isset($this->metadata['extra']['soft-require']['phpbb/phpbb'])) ? false : true,

+ *

+ * @param array $post_ids Specify for which post IDs to fetch the attachments (optional)

+ * @param array $topic_ids Specify for which topic IDs to fetch the attachments (optional)

+ protected function fetch_attachments($post_ids = array(), $topic_ids = array())

+ if (!empty($post_ids))

+ {

+ $sql_array['WHERE'] .= 'AND ' . $this->db->sql_in_set('a.post_msg_id', $post_ids);

+ }

+ else if (!empty($topic_ids))

+ {

+ if (isset($this->topic_id))

+ {

+ $topic_ids[] = $this->topic_id;

+ }

+

+ $sql_array['WHERE'] .= 'AND ' . $this->db->sql_in_set('a.topic_id', $topic_ids);

+ }

+ else if (isset($this->topic_id))

+ else

+ {

+ // Do not allow querying the full attachments table

+ throw new \RuntimeException($this->user->lang('INVALID_FEED_ATTACHMENTS'));

+ }

+ parent::fetch_attachments(array(), $topic_ids);

+

+ parent::fetch_attachments($post_ids);

+

+ parent::fetch_attachments(array(), $topic_ids);

+

+ parent::fetch_attachments();

+

+ parent::fetch_attachments($post_ids);

+

+ parent::fetch_attachments($post_ids);

+

+ $sql_ary = array(

+ 'SELECT' => 'topic_id, forum_id',

+ 'FROM' => array(

+ TOPICS_TABLE => 't',

+ ),

+ 'WHERE' => $this->db->sql_in_set('topic_id', array_map('intval', $topic_ids)),

+ );

+

+ /**

+ * Allow modifying SQL query before topic data is retrieved.

+ *

+ * @event core.phpbb_log_get_topic_auth_sql_before

+ * @var array topic_ids Array with unique topic IDs

+ * @var array sql_ary SQL array

+ * @since 3.1.11-RC1

+ */

+ $vars = array(

+ 'topic_ids',

+ 'sql_ary',

+ );

+ extract($this->dispatcher->trigger_event('core.phpbb_log_get_topic_auth_sql_before', compact($vars)));

+

+ $sql = $this->db->sql_build_query('SELECT', $sql_ary);

+ $user_data = $this->user_loader->get_user($this->get_data('reporter_id'));

+