+ <!-- INCLUDE {auth_tpl.TEMPLATE_FILE} -->

+ <p><strong>{NAVIGATION}<!-- IF S_NO_FORUMS --> [<a href="{U_EDIT}">{L_EDIT}</a> | <a href="{U_DELETE}">{L_DELETE}</a><!-- IF not S_LINK --> | <a href="{U_SYNC}">{L_RESYNC}</a><!-- ENDIF -->]<!-- ENDIF --></strong></p>

+<dl>

+ <dt><label for="ldap_server">{L_LDAP_SERVER}{L_COLON}</label><br /><span>{L_LDAP_SERVER_EXPLAIN}</span></dt>

+ <dd><input type="text" id="ldap_server" size="40" name="config[ldap_server]" value="{AUTH_LDAP_SERVER}" /></dd>

+</dl>

+<dl>

+ <dt><label for="ldap_port">{L_LDAP_PORT}{L_COLON}</label><br /><span>{L_LDAP_PORT_EXPLAIN}</span></dt>

+ <dd><input type="text" id="ldap_port" size="40" name="config[ldap_port]" value="{AUTH_LDAP_PORT}" /></dd>

+</dl>

+<dl>

+ <dt><label for="ldap_dn">{L_LDAP_DN}{L_COLON}</label><br /><span>{L_LDAP_DN_EXPLAIN}</span></dt>

+ <dd><input type="text" id="ldap_dn" size="40" name="config[ldap_base_dn]" value="{AUTH_LDAP_BASE_DN}" /></dd>

+</dl>

+<dl>

+ <dt><label for="ldap_uid">{L_LDAP_UID}{L_COLON}</label><br /><span>{L_LDAP_UID_EXPLAIN}</span></dt>

+ <dd><input type="text" id="ldap_uid" size="40" name="config[ldap_uid]" value="{AUTH_LDAP_UID}" /></dd>

+</dl>

+<dl>

+ <dt><label for="ldap_user_filter">{L_LDAP_USER_FILTER}{L_COLON}</label><br /><span>{L_LDAP_USER_FILTER_EXPLAIN}</span></dt>

+ <dd><input type="text" id="ldap_user_filter" size="40" name="config[ldap_user_filter]" value="{AUTH_LDAP_USER_FILTER}" /></dd>

+</dl>

+<dl>

+ <dt><label for="ldap_email">{L_LDAP_EMAIL}{L_COLON}</label><br /><span>{L_LDAP_EMAIL_EXPLAIN}</span></dt>

+ <dd><input type="email" id="ldap_email" size="40" name="config[ldap_email]" value="{AUTH_LDAP_EMAIL}" /></dd>

+</dl>

+<dl>

+ <dt><label for="ldap_user">{L_LDAP_USER}{L_COLON}</label><br /><span>{L_LDAP_USER_EXPLAIN}</span></dt>

+ <dd><input type="text" id="ldap_user" size="40" name="config[ldap_user]" value="{AUTH_LDAP_USER}" /></dd>

+</dl>

+<dl>

+ <dt><label for="ldap_password">{L_LDAP_PASSWORD}{L_COLON}</label><br /><span>{L_LDAP_PASSWORD_EXPLAIN}</span></dt>

+ <dd><input type="password" id="ldap_password" size="40" name="config[ldap_password]" value="{AUTH_LDAP_PASSWORD}" autocomplete="off" /></dd>

+</dl>

+{$SCRIPTS}

+ "symfony/yaml": "2.1.*",

+ "twig/twig": "1.13.*"

+ "phpunit/phpunit": "3.7.*",

+ "phing/phing": "2.4.*"

+ "hash": "6e6125b88160e28568edcb9fd007abed",

+ "version": "v2.1.11",

+ "reference": "v2.1.11"

+ "url": "https://api.github.com/repos/symfony/Config/zipball/v2.1.11",

+ "reference": "v2.1.11",

+ "time": "2013-05-09 15:22:40"

+ "version": "v2.1.11",

+ "reference": "v2.1.11"

+ "url": "https://api.github.com/repos/symfony/DependencyInjection/zipball/v2.1.11",

+ "reference": "v2.1.11",

+ "version": "v2.1.11",

+ "reference": "v2.1.11"

+ "url": "https://api.github.com/repos/symfony/EventDispatcher/zipball/v2.1.11",

+ "reference": "v2.1.11",

+ "version": "v2.1.11",

+ "reference": "v2.1.11"

+ "url": "https://api.github.com/repos/symfony/HttpFoundation/zipball/v2.1.11",

+ "reference": "v2.1.11",

+ "time": "2013-05-26 18:42:07"

+ "version": "v2.1.11",

+ "reference": "v2.1.11"

+ "url": "https://api.github.com/repos/symfony/HttpKernel/zipball/v2.1.11",

+ "reference": "v2.1.11",

+ "time": "2013-06-02 12:29:05"

+ "version": "v2.1.11",

+ "reference": "v2.1.11"

+ "url": "https://api.github.com/repos/symfony/Routing/zipball/v2.1.11",

+ "reference": "v2.1.11",

+ "time": "2013-05-06 10:48:41"

+ "version": "v2.1.11",

+ "reference": "v2.1.11"

+ "url": "https://api.github.com/repos/symfony/Yaml/zipball/v2.1.11",

+ "reference": "v2.1.11",

+ "time": "2013-05-10 00:09:46"

+ },

+ {

+ "name": "twig/twig",

+ "version": "v1.13.1",

+ "source": {

+ "type": "git",

+ "url": "https://github.com/fabpot/Twig.git",

+ "reference": "v1.13.1"

+ },

+ "dist": {

+ "type": "zip",

+ "url": "https://api.github.com/repos/fabpot/Twig/zipball/v1.13.1",

+ "reference": "v1.13.1",

+ "shasum": ""

+ },

+ "require": {

+ "php": ">=5.2.4"

+ },

+ "type": "library",

+ "extra": {

+ "branch-alias": {

+ "dev-master": "1.13-dev"

+ }

+ },

+ "autoload": {

+ "psr-0": {

+ "Twig_": "lib/"

+ }

+ },

+ "notification-url": "https://packagist.org/downloads/",

+ "license": [

+ "BSD-3"

+ ],

+ "authors": [

+ {

+ "name": "Fabien Potencier",

+ "email": "fabien@symfony.com"

+ },

+ {

+ "name": "Armin Ronacher",

+ "email": "armin.ronacher@active-4.com"

+ }

+ ],

+ "description": "Twig, the flexible, fast, and secure template language for PHP",

+ "homepage": "http://twig.sensiolabs.org",

+ "keywords": [

+ "templating"

+ ],

+ "time": "2013-06-06 06:06:01"

+ "name": "phing/phing",

+ "version": "2.4.14",

+ "source": {

+ "type": "git",

+ "url": "https://github.com/phingofficial/phing",

+ "reference": "2.4.14"

+ },

+ "dist": {

+ "type": "zip",

+ "url": "https://github.com/phingofficial/phing/archive/2.4.14.zip",

+ "reference": "2.4.14",

+ "shasum": ""

+ },

+ "require": {

+ "php": ">=5.2.0"

+ },

+ "bin": [

+ "bin/phing"

+ ],

+ "type": "library",

+ "autoload": {

+ "classmap": [

+ "classes/phing/"

+ ]

+ },

+ "notification-url": "https://packagist.org/downloads/",

+ "include-path": [

+ "classes"

+ ],

+ "license": [

+ "LGPL3"

+ ],

+ "authors": [

+ {

+ "name": "Michiel Rook",

+ "email": "mrook@php.net"

+ },

+ {

+ "name": "Phing Community",

+ "homepage": "http://www.phing.info/trac/wiki/Development/Contributors"

+ }

+ ],

+ "description": "PHing Is Not GNU make; it's a PHP project build system or build tool based on Apache Ant.",

+ "homepage": "http://www.phing.info/",

+ "keywords": [

+ "build",

+ "task",

+ "tool"

+ ],

+ "time": "2012-11-29 21:23:47"

+ },

+ {

+ "version": "1.2.12",

+ "reference": "1.2.12"

+ "url": "https://api.github.com/repos/sebastianbergmann/php-code-coverage/zipball/1.2.12",

+ "reference": "1.2.12",

+ "require-dev": {

+ "phpunit/phpunit": "3.7.*@dev"

+ },

+ "extra": {

+ "branch-alias": {

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

+ }

+ },

+ "time": "2013-07-06 06:26:16"

+ "version": "3.7.22",

+ "reference": "3.7.22"

+ "url": "https://api.github.com/repos/sebastianbergmann/phpunit/zipball/3.7.22",

+ "reference": "3.7.22",

+ "phpunit/php-code-coverage": "~1.2.1",

+ "phpunit/php-timer": "~1.0.2",

+ "phpunit/phpunit-mock-objects": "~1.2.0",

+ "symfony/yaml": "~2.0"

+ "time": "2013-07-06 06:29:15"

+ "version": "v2.1.11",

+ "reference": "v2.1.11"

+ "url": "https://api.github.com/repos/symfony/BrowserKit/zipball/v2.1.11",

+ "reference": "v2.1.11",

+ "version": "v2.1.11",

+ "reference": "v2.1.11"

+ "url": "https://api.github.com/repos/symfony/CssSelector/zipball/v2.1.11",

+ "reference": "v2.1.11",

+ "time": "2013-05-17 00:31:34"

+ "version": "v2.1.11",

+ "reference": "v2.1.11"

+ "url": "https://api.github.com/repos/symfony/DomCrawler/zipball/v2.1.11",

+ "reference": "v2.1.11",

+ "time": "2013-05-16 00:06:15"

+ "version": "v2.1.11",

+ "reference": "v2.1.11"

+ "url": "https://api.github.com/repos/symfony/Finder/zipball/v2.1.11",

+ "reference": "v2.1.11",

+ "time": "2013-05-25 15:47:15"

+ "version": "v2.1.11",

+ "reference": "v2.1.11"

+ "url": "https://api.github.com/repos/symfony/Process/zipball/v2.1.11",

+ "reference": "v2.1.11",

+ "time": "2013-05-06 10:21:56"

+ - @content.visibility

+ - @content.visibility

+ - @content.visibility

+ - @content.visibility

+ - @content.visibility

+ - @content.visibility

+ - @content.visibility

+ content.visibility:

+ class: phpbb_content_visibility

+ arguments:

+ - @auth

+ - @dbal.conn

+ - @user

+ - %core.root_path%

+ - %core.php_ext%

+ - %tables.forums%

+ - %tables.posts%

+ - %tables.topics%

+ - %tables.users%

+

+ - @style

+ class: phpbb_template_twig

+ - %core.adm_relative_path%

+ tables.forums: %core.table_prefix%forums

+ tables.posts: %core.table_prefix%posts

+ tables.topics: %core.table_prefix%topics

+ $sql = "SELECT forum_topics_approved

+ $topic_count = $row['forum_topics_approved'];

+ $sql = "INSERT INTO " . POSTS_TABLE . " (topic_id, forum_id, poster_id, attach_id, icon_id, post_username, post_time, poster_ip, post_visibility, bbcode_uid, enable_bbcode, enable_html, enable_smilies, enable_sig, post_subject, post_text)

+ SET forum_last_post_id = $new_post_id, forum_posts_approved = forum_posts_approved + 1";

+ $sql .= ", forum_topics_approved = forum_topics_approved + 1";

+ 'forum_posts_approved' => array('UINT', 0),

+ 'forum_posts_unapproved' => array('UINT', 0),

+ 'forum_posts_softdeleted' => array('UINT', 0),

+ 'forum_topics_approved' => array('UINT', 0),

+ 'forum_topics_unapproved' => array('UINT', 0),

+ 'forum_topics_softdeleted' => array('UINT', 0),

+ 'post_visibility' => array('TINT:3', 0),

+ 'post_delete_time' => array('TIMESTAMP', 0),

+ 'post_delete_reason' => array('STEXT_UNI', ''),

+ 'post_delete_user' => array('UINT', 0),

+ 'post_visibility' => array('INDEX', 'post_visibility'),

+ 'topic_visibility' => array('TINT:3', 0),

+ 'topic_posts_approved' => array('UINT', 0),

+ 'topic_posts_unapproved' => array('UINT', 0),

+ 'topic_posts_softdeleted' => array('UINT', 0),

+ 'topic_delete_time' => array('TIMESTAMP', 0),

+ 'topic_delete_reason' => array('STEXT_UNI', ''),

+ 'topic_delete_user' => array('UINT', 0),

+ 'topic_visibility' => array('INDEX', 'topic_visibility'),

+ 'forum_appr_last' => array('INDEX', array('forum_id', 'topic_visibility', 'topic_last_post_id')),

+ $sql = 'INSERT IGNORE INTO ' . POSTS_TABLE . ' (topic_id, forum_id, poster_id, post_subject, post_text, post_username, post_visibility, post_time, post_reported)

+ ADD INDEX post_visibility (post_visibility),

+ SET forum_last_poster_id = " . ((!empty($row['user_id']) && $row['user_id'] != ANONYMOUS) ? $row['user_id'] : ANONYMOUS) . ", forum_last_poster_name = '" . ((!empty($row['user_id']) && $row['user_id'] != ANONYMOUS) ? addslashes($row['username']) : addslashes($row['post_username'])) . "', forum_last_post_time = " . $row['post_time'] . ", forum_posts_approved = " . (($post_count[$forum_id]) ? $post_count[$forum_id] : 0) . ", forum_topics_approved = " . (($topic_count[$forum_id]) ? $topic_count[$forum_id] : 0) . "

+ 'forum_posts_approved' => array('UINT', 0),

+ 'forum_posts_unapproved' => array('UINT', 0),

+ 'forum_posts_softdeleted' => array('UINT', 0),

+ 'forum_topics_approved' => array('UINT', 0),

+ 'forum_topics_unapproved' => array('UINT', 0),

+ 'forum_topics_softdeleted' => array('UINT', 0),

+ 'post_visibility' => array('TINT:3', 0),

+ 'post_visibility' => array('INDEX', 'post_visibility'),

+ 'topic_visibility' => array('TINT:3', 0),

+ 'topic_posts_approved' => array('UINT', 0),

+ 'topic_posts_unapproved' => array('UINT', 0),

+ 'topic_posts_softdeleted' => array('UINT', 0),

+ 'topic_visibility' => array('INDEX', 'topic_visibility'),

+ 'forum_appr_last' => array('INDEX', array('forum_id', 'topic_visibility', 'topic_last_post_id')),

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

+ <a name="v3011"></a><h3>1.i. Changes since 3.0.11</h3>

+

+<h4>Bug</h4>

+<ul>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-6723">PHPBB3-6723</a>] - Empty message in deleted messages in PM history</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-7262">PHPBB3-7262</a>] - Clarify docs about is_dynamic not being updated by set_config()</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-8319">PHPBB3-8319</a>] - LOCAL_URL not enforced in bbcodes</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-9551">PHPBB3-9551</a>] - Mysql fulltext index creation fails due to partial collation change</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-9975">PHPBB3-9975</a>] - Hard coded language in sessions.php</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10184">PHPBB3-10184</a>] - Bots can be sent private messages</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10491">PHPBB3-10491</a>] - Fatal error in functional tests when server returns 404</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10568">PHPBB3-10568</a>] - Modify the trigger language when you edit a PM</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10602">PHPBB3-10602</a>] - A bug in mail queue processing</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10661">PHPBB3-10661</a>] - UCP &gt; PM &gt; Compose &gt; enumerated recipients &gt; BCC group misses a &amp;nbsp; (prosilver)</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10678">PHPBB3-10678</a>] - Provide Firebird, Oracle, and increased MSSQL support in unit tests</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10772">PHPBB3-10772</a>] - trigger_error is using the default style</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10789">PHPBB3-10789</a>] - PM print template (prosilver) with unnecessary variables</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10820">PHPBB3-10820</a>] - Display images directly in IE9 and 10 instead of download</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10828">PHPBB3-10828</a>] - PostgreSQL dbal tests try to connect to the database named as user specified in configuration</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10838">PHPBB3-10838</a>] - Functional tests are not mentioned in RUNNING_TESTS.txt</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10840">PHPBB3-10840</a>] - If you add a member to a group, the form_token can be set to 0 if the creation_time is 0 too. Maybe even if creation_time is unchanged.</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10848">PHPBB3-10848</a>] - Wrong redirect to installer from acp</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10850">PHPBB3-10850</a>] - create_schema_files.php is not creating the oracle or postgres' schema file properly</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10879">PHPBB3-10879</a>] - prosilver: attachment-link will be displayed wrong, when filename is too long </li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10880">PHPBB3-10880</a>] - m_approve should not imply f_noapprove</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10896">PHPBB3-10896</a>] - board_email &amp; board_contact are not validated as email addresses in ACP</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10897">PHPBB3-10897</a>] - Bot Definitions are outdated</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10918">PHPBB3-10918</a>] - docs/INSTALL.html claims there are tar.gz packages</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10943">PHPBB3-10943</a>] - Search Box should display keywords entered by the user</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10967">PHPBB3-10967</a>] - PHPBB_USE_BOARD_URL_PATH not implemented in posting_gen_topic_icons</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10986">PHPBB3-10986</a>] - Invalid email message ids because config variable server_name is used even when force server URL settings is disabled</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10995">PHPBB3-10995</a>] - Return value of $db-&gt;sql_fetchrow() on empty tables is not consistent on mssqlnative</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10996">PHPBB3-10996</a>] - Travis tests fail on Postgres because database does not exist</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11034">PHPBB3-11034</a>] - The functional test case framework does not install a full board each time</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11066">PHPBB3-11066</a>] - MSSQLnative driver contains debug code error_reporting(E_ALL)</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11069">PHPBB3-11069</a>] - missing closing span in subsilver2 simple_footer.html</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11081">PHPBB3-11081</a>] - Duplicated /TD in styles/subsilver2/template/catpcha_qa.html</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11093">PHPBB3-11093</a>] - acp_users_overview.html has a wrongly placed &lt;/dd&gt;</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11094">PHPBB3-11094</a>] - prosilver: searching for users: no textbox for Jabber</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11105">PHPBB3-11105</a>] - Missing mandatory space in meta http-equiv=refresh</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11112">PHPBB3-11112</a>] - phpBB Footer Link should be SSL</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11122">PHPBB3-11122</a>] - Update docs/AUTHORS for 3.0.12-RC1</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11144">PHPBB3-11144</a>] - {FORUM_NAME} is not filled in login mask when logging into a password protected forum</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11145">PHPBB3-11145</a>] - ATTACHED_IMAGE_NOT_IMAGE thrown because of file limit in php.ini</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11158">PHPBB3-11158</a>] - modules table lacks acl_u_sig for signature module</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11159">PHPBB3-11159</a>] - Coding guidelines: static public</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11164">PHPBB3-11164</a>] - Composer not finding symfony/config in PHP 5.3.3</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11178">PHPBB3-11178</a>] - database_update.php should not set error_reporting to E_ALL</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11186">PHPBB3-11186</a>] - Database unit tests fail on windows using sqlite2</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11190">PHPBB3-11190</a>] - Functional tests do not clear the cache between each test</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11196">PHPBB3-11196</a>] - /includes/session.php sends 401 HTTP status with &quot;Not authorized&quot; instead of &quot;Unauthorized&quot;</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11219">PHPBB3-11219</a>] - Database sequences are not updated for tests using fixtures with auto_incremented columns</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11227">PHPBB3-11227</a>] - @return void -&gt; @return null</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11233">PHPBB3-11233</a>] - Anonymous can be selected as a PM recipient</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11248">PHPBB3-11248</a>] - CRLF line endings</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11262">PHPBB3-11262</a>] - .lock files are not in .gitignore</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11265">PHPBB3-11265</a>] - Functional tests do not assert that board installation succeeded</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11269">PHPBB3-11269</a>] - Travis functional test case errors</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11278">PHPBB3-11278</a>] - Firebird tables are not removed correctly on 3.0.9-rc1 update</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11288">PHPBB3-11288</a>] - Search fooled by hyphens</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11291">PHPBB3-11291</a>] - &quot;Could not open input file: ../composer.phar&quot; error during phing's create-package</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11292">PHPBB3-11292</a>] - Newlines removed in display of PM reports, no clickable links in PM reports</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11301">PHPBB3-11301</a>] - &quot;String offset cast occured&quot; error on PHP 5.4</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11304">PHPBB3-11304</a>] - check_form_key breaks in tests when form is submitted in the same second it is retrieved</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11343">PHPBB3-11343</a>] - Loose string comparison during new password activation</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11355">PHPBB3-11355</a>] - Incorrect error message when no user selected for action on group membership management page</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11358">PHPBB3-11358</a>] - Success message even withot selecting a user and performing a group operation</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11361">PHPBB3-11361</a>] - &quot;Array to string conversion&quot; error in $user-&gt;format_date()</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11493">PHPBB3-11493</a>] - Functional tests should fail if any debug output is made</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11517">PHPBB3-11517</a>] - Numbering is wrong in coding guidelines</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11536">PHPBB3-11536</a>] - Installer incorrectly removes /install from script_path</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11537">PHPBB3-11537</a>] - UCP group manage page's error box differs heavily from the rest of the UCP</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11538">PHPBB3-11538</a>] - SQL error on UCP groups manage page caused by setting color to 7 characters long string</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11544">PHPBB3-11544</a>] - Add admin_login() to 3.0 functional test case</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11545">PHPBB3-11545</a>] - is_absolute() should not depend on DIRECTORY_SEPARATOR</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11546">PHPBB3-11546</a>] - is_absolute() throws E_NOTICE for empty string</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11547">PHPBB3-11547</a>] - Test fixtures do not support utf8 characters</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11548">PHPBB3-11548</a>] - Untranslated TOO_SHORT in UCP &quot;Manage Groups&quot;</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11566">PHPBB3-11566</a>] - Reporting a post should require a captcha to be solved by guests</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11568">PHPBB3-11568</a>] - Functional tests fail with retrieving install pages using file_get_contents</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11575">PHPBB3-11575</a>] - phpbb_dbal_order_lower_test::test_cross_join should be called test_order_lower</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11578">PHPBB3-11578</a>] - Missing underscore after function prefix in validate_data()</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11579">PHPBB3-11579</a>] - Add unit tests for validate_data()</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11580">PHPBB3-11580</a>] - Avoid API Limit from composer downloads on github</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11588">PHPBB3-11588</a>] - install/install_update.php should use version.phpbb.com instead of www</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11590">PHPBB3-11590</a>] - Close database connections from tests whenever possible</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11601">PHPBB3-11601</a>] - Allow manual resync of database columns in unit tests not only on fixture load</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11603">PHPBB3-11603</a>] - git-tools use invalid api urls</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11604">PHPBB3-11604</a>] - Functional tests fail when phpBB can not create the config file</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11617">PHPBB3-11617</a>] - Missing U_ACTION in acp_captcha.php</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11618">PHPBB3-11618</a>] - Template tests fail on some systems due to a PHP error in glob()</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11619">PHPBB3-11619</a>] - get_remote_file() should use HTTP 1.0</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11630">PHPBB3-11630</a>] - Improvements to the PHP lint pre-commit hook</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11644">PHPBB3-11644</a>] - Skip phpbb_dbal_order_lower_test on MySQL 5.6</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11662">PHPBB3-11662</a>] - &quot;occured&quot; should be &quot;occurred&quot;</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11670">PHPBB3-11670</a>] - Replace trademark ™ with ® on &quot;Welcome to phpBB&quot; install page</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11674">PHPBB3-11674</a>] - Do not include vendor folder if there are no dependencies.</li>

+</ul>

+<h4>Improvement</h4>

+<ul>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-8743">PHPBB3-8743</a>] - New topic / reply notifications do not contain author's name.</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10050">PHPBB3-10050</a>] - subsilver2: Do not show &quot;Mark topics as read&quot; when there are no topics</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10205">PHPBB3-10205</a>] - More informative reporting of errors when database connection fails (MySQL and others)</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10716">PHPBB3-10716</a>] - PHP-parse all php files as part of the test suite</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10841">PHPBB3-10841</a>] - Disable style and language selectors if there's only one installed.</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10854">PHPBB3-10854</a>] - sql server drop default constraint when dropping column </li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10865">PHPBB3-10865</a>] - Updated and Added to docs/INSTALL.html</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10873">PHPBB3-10873</a>] - Change language entry for deleted PMs</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10981">PHPBB3-10981</a>] - Upgrade Goutte and use Composer for Installation</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11131">PHPBB3-11131</a>] - Phrasing &amp; semantics of Board settings</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11162">PHPBB3-11162</a>] - Get rid of $db-&gt;sql_return_on_error(true) trickery when splitting/merging topics</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11192">PHPBB3-11192</a>] - Add Tebibyte to get_formatted_filesize()</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11202">PHPBB3-11202</a>] - Add response status checks to functional tests</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11220">PHPBB3-11220</a>] - Improve tooltip explaining the [list=] - BBcode</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11238">PHPBB3-11238</a>] - Specify goutte version</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11285">PHPBB3-11285</a>] - Use more granularity in dependency checks in compress test</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11293">PHPBB3-11293</a>] - Prefer mysqli over mysql due to php 5.5 alpha 2 deprecating mysql</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11294">PHPBB3-11294</a>] - Update extension list in running tests doc</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11368">PHPBB3-11368</a>] - Latest pm reports row count</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11583">PHPBB3-11583</a>] - InnoDB supports FULLTEXT index since MySQL 5.6.4.</li>

+</ul>

+<h4>Sub-task</h4>

+<ul>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10974">PHPBB3-10974</a>] - Move tests/mock_user.php to tests/mock/user.php</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11009">PHPBB3-11009</a>] - Backport phing build.xml from develop to develop-olympus so it uses composer.</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11540">PHPBB3-11540</a>] - Add unit tests for (phpbb_)is_absolute()</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11541">PHPBB3-11541</a>] - Add unit tests for style_select() in functions.php</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11542">PHPBB3-11542</a>] - Add unit tests for language_select() in functions.php</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11543">PHPBB3-11543</a>] - Add unit tests for obtain online functions in functions.php</li>

+</ul>

+<h4>Task</h4>

+<ul>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10877">PHPBB3-10877</a>] - Have bamboo generate and publish a phpBB package for every build.</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11045">PHPBB3-11045</a>] - Add unit tests for the compress class</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11059">PHPBB3-11059</a>] - Fix README logo</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11060">PHPBB3-11060</a>] - Fix travis.yml pyrus config</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11240">PHPBB3-11240</a>] - Turn on PHPUnit's verbose mode on Travis</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11324">PHPBB3-11324</a>] - Add PHP 5.5 environment on Travis-CI</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11337">PHPBB3-11337</a>] - Run functional tests on Travis CI</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11513">PHPBB3-11513</a>] - Install PHPUnit via Composer's require-dev to simplify test running (no need for pear)</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11526">PHPBB3-11526</a>] - Increase composer minimum-stability from beta to stable</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11527">PHPBB3-11527</a>] - Upgrade composer.phar to 1.0.0-alpha7</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11529">PHPBB3-11529</a>] - Rename RUNNING_TESTS file to .md file to render it on GitHub</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11576">PHPBB3-11576</a>] - Make phpBB Test Suite MySQL behave at least as strict as phpBB MySQL driver</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11671">PHPBB3-11671</a>] - Add phing/phing to composer.json</li>

+</ul>

+

+ <a name="v3010"></a><h3>1.ii. Changes since 3.0.10</h3>

+ <a name="v309"></a><h3>1.iii. Changes since 3.0.9</h3>

+ <a name="v308"></a><h3>1.iv. Changes since 3.0.8</h3>

+ <a name="v307-PL1"></a><h3>1.v. Changes since 3.0.7-PL1</h3>

+ <a name="v307"></a><h3>1.vi. Changes since 3.0.7</h3>

+ <a name="v306"></a><h3>1.vii. Changes since 3.0.6</h3>

+ <a name="v305"></a><h3>1.viii. Changes since 3.0.5</h3>

+ <a name="v304"></a><h3>1.ix. Changes since 3.0.4</h3>

+ <a name="v303"></a><h3>1.x. Changes since 3.0.3</h3>

+ <a name="v302"></a><h3>1.xi. Changes since 3.0.2</h3>

+ <a name="v301"></a><h3>1.xii. Changes since 3.0.1</h3>

+ <a name="v300"></a><h3>1.xiii Changes since 3.0.0</h3>

+ <a name="v30rc8"></a><h3>1.xiv. Changes since 3.0.RC8</h3>

+ <a name="v30rc7"></a><h3>1.xv. Changes since 3.0.RC7</h3>

+ <a name="v30rc6"></a><h3>1.xvi. Changes since 3.0.RC6</h3>

+ <a name="v30rc5"></a><h3>1.xvii. Changes since 3.0.RC5</h3>

+ <a name="v30rc4"></a><h3>1.xviii. Changes since 3.0.RC4</h3>

+ <a name="v30rc3"></a><h3>1.xix. Changes since 3.0.RC3</h3>

+ <a name="v30rc2"></a><h3>1.xx. Changes since 3.0.RC2</h3>

+ <a name="v30rc1"></a><h3>1.xxi. Changes since 3.0.RC1</h3>

+ <p>This application is opensource software released under the <a href="http://opensource.org/licenses/gpl-2.0.php">GNU General Public License v2</a>. Please see source code and the docs directory for more details. This package and its contents are Copyright (c) <a href="https://www.phpbb.com/">phpBB Group</a>, All Rights Reserved.</p>

+<p>We think a better solution is for you to carefully read the enclosed documentation, read through our knowledge base at <a href="https://www.phpbb.com/">www.phpbb.com</a> and if necessary ask for help on any thing you get stuck on. However, the decision is yours but please note we may not offer support if we believe you have had the board installed by a third party. In such cases you should direct your questions to that company or person/s.</p>

+<p>This error will occur if phpBB cannot send mail. phpBB can send email two ways; using the PHP <code>mail()</code> function or directly via SMTP. Some hosting providers limit the <code>mail()</code> function to prevent its use in spamming, others may rename it or limit its functionality. If the <code>mail()</code> function got renamed, you are able to enter the correct name within the administration control panel. In either case you may need to make use of SMTP. This requires that you have access to such a facility, e.g. your hosting provider may provide one (perhaps requiring specific written authorisation), etc. Please see <a href="https://www.phpbb.com/">www.phpbb.com</a> for additional help on this matter.</p>

+<p>Please read the paragraph about permissions in our extensive <a href="https://www.phpbb.com/support/documentation/3.0/">online documentation</a>.</p>

+<p>Please read our <a href="https://www.phpbb.com/support/documentation/3.0/">extensive user documentation</a> first, it may just explain what you want to know.</p>

+<p><a href="https://www.phpbb.com">www.phpbb.com</a></p>

+ <p>This application is opensource software released under the <a href="http://opensource.org/licenses/gpl-2.0.php">GNU General Public License v2</a>. Please see source code and the docs directory for more details. This package and its contents are Copyright (c) <a href="https://www.phpbb.com/">phpBB Group</a>, All Rights Reserved.</p>

+<p>A basic overview of running phpBB3 can be found in the accompanying <a href="README.html">README</a> file. Please ensure you read that document in addition to this! For more detailed information on using, installing, updating and converting phpBB3 you should read <a href="https://www.phpbb.com/support/documentation/3.0/">the documentation</a> available online.</p>

+ <p>Now you have to create your administration user. This user will have full administration access and he/she will be the first user on your forum. All fields on this page are required. You can also set the default language of your forum on this page. In a vanilla phpBB3 installation, we only include British English. You can download further languages from <a href="https://www.phpbb.com/">www.phpbb.com</a>, and add them before installing or later.</p>

+ <li>Go to the <a href="https://www.phpbb.com/downloads/">downloads page</a> and download the latest update package listed there, matching your current version.</li>

+ <p>Please note that this conversion process may take quite some time and depending on your hosting provider this may result in it failing (due to web server resource limits or other timeout issues). If this is the case, you should ask your provider if they are willing to allow the convert script to temporarily exceed their limits (be nice and they will probably be quite helpful). If your host is unwilling to increase the limits to run the convertor, please see this article for performing the conversion on your local machine: <a href="https://www.phpbb.com/kb/article/offline-conversions/">Knowledge Base - Offline Conversions</a></p>

+ <p>Like any online site that allows user input, your board could be subject to unwanted posts; often referred to as <a href="http://en.wikipedia.org/wiki/Forum_spam">forum spam</a>. The vast majority of these attacks will be from automated computer programs known as <a href="http://en.wikipedia.org/wiki/Spambot">spambots</a>. The attacks, generally, are not personal as the spammers are just trying to find accessible targets. phpBB has a number of anti-spam measures built in, including a range of CAPTCHAs. However, administrators are strongly urged to read and follow the advice for <a href="https://www.phpbb.com/support/spam/">Preventing Spam in phpBB</a> as soon as possible after completing the installation of your board.</p>

+ <p>This application is opensource software released under the <a href="http://opensource.org/licenses/gpl-2.0.php">GNU General Public License v2</a>. Please see the source code and <code>docs/</code> directory for more details. This package and its contents are Copyright &copy; <a href="https://www.phpbb.com/">phpBB Group</a>, All Rights Reserved.</p>

+ <p>A number of language packs with included style localisations are available. You can find them listed in the <a href="https://www.phpbb.com/languages/">Language Packs</a> pages of our downloads section or from the <a href="https://www.phpbb.com/customise/db/language_packs-25/">Language Packs</a> section of the <a href="https://www.phpbb.com/customise/db/">Customisation Database</a>.</p>

+ <p>For more information about language packs, please see: <a href="https://www.phpbb.com/languages/">https://www.phpbb.com/languages/</a></p>

+ <p>Installation of these packages is straightforward: simply download the required language pack, uncompress (unzip) it and via FTP transfer the included <code>language</code> and <code>styles</code> folders to the root of your board installation. The language can then be installed via the Administration Control Panel of your board: <code>System tab -&gt; General Tasks -&gt; Language packs</code>. A more detailed description of the process is in the Knowledge Base article, <a href="https://www.phpbb.com/kb/article/how-to-install-a-language-pack/">How to Install a Language Pack</a>.</p>

+ <p>If your language is not available, please visit our <a href="https://www.phpbb.com/community/viewforum.php?f=66">[3.0.x] Translations</a> forum where you will find topics on translations in progress. Should you wish to volunteer to translate a language not currently available or assist in maintaining an existing language pack, you can <a href="https://www.phpbb.com/languages/apply.php">Apply to become a translator</a>.</p>

+ <p>Although the phpBB Group is rather proud of the included styles, we realise that they may not be to everyone's taste. Therefore, phpBB3 allows styles to be switched with relative ease. First, you need to locate and download a style you like. You can find them listed in the <a href="https://www.phpbb.com/customise/db/styles-2/">Styles</a> section of our <a href="https://www.phpbb.com/customise/db/">Customisation Database</a>.</p>

+ <p>For more information about styles, please see: <a href="https://www.phpbb.com/styles/">https://www.phpbb.com/styles/</a></p>

+ <p>Although not officially supported by the phpBB Group, phpBB has a thriving modification scene. These third party modifications to the standard phpBB software, known as <strong>MODs</strong>, extend its capabilities still further. You can browse through many of the MODs in the <a href="https://www.phpbb.com/customise/db/modifications-1/">Modifications</a> section of our <a href="https://www.phpbb.com/customise/db/">Customisation Database</a>.</p>

+ <p>For more information about MODs, please see: <a href="https://www.phpbb.com/mods/">https://www.phpbb.com/mods/</a></p>

+ <p><a href="https://www.phpbb.com/support/documentation/3.0/">https://www.phpbb.com/support/documentation/3.0/</a></p>

+ <p><a href="https://www.phpbb.com/kb/">https://www.phpbb.com/kb/</a></p>

+ <p><a href="https://www.phpbb.com/community/">https://www.phpbb.com/community/</a></p>

+ <p>There are other IRC channels available, please see <a href="https://www.phpbb.com/support/irc/">https://www.phpbb.com/support/irc/</a> for the complete list.</p>

+ <p><a href="https://www.phpbb.com/security/">https://www.phpbb.com/security/</a></p>

+ <p>This application is opensource software released under the <a href="http://opensource.org/licenses/gpl-2.0.php">GNU General Public License v2</a>. Please see source code and the docs directory for more details. This package and its contents are Copyright &copy; <a href="https://www.phpbb.com/">phpBB Group</a>, All Rights Reserved.</p>

+ <p>This application is opensource software released under the <a href="http://opensource.org/licenses/gpl-2.0.php">GNU General Public License v2</a>. Please see source code and the docs directory for more details. This package and its contents are Copyright (c) <a href="https://www.phpbb.com/">phpBB Group</a>, All Rights Reserved.</p>

+<p>it will be included and executed inline.<br /><br />A note, it is very much encouraged that template designers do not include PHP. The ability to include raw PHP was introduced primarily to allow end users to include banner code, etc. without modifying multiple files (as with 2.0.x). It was not intended for general use ... hence <!-- w --><a href="https://www.phpbb.com">www.phpbb.com</a><!-- w --> will <strong>not</strong> make available template sets which include PHP. And by default templates will have PHP disabled (the admin will need to specifically activate PHP for a template).</p>

+ <p>This application is opensource software released under the <a href="http://opensource.org/licenses/gpl-2.0.php">GNU General Public License v2</a>. Please see source code and the docs directory for more details. This package and its contents are Copyright (c) <a href="https://www.phpbb.com/">phpBB Group</a>, All Rights Reserved.</p>

+ <p>This application is opensource software released under the <a href="http://opensource.org/licenses/gpl-2.0.php">GNU General Public License v2</a>. Please see source code and the docs directory for more details. This package and its contents are Copyright (c) <a href="https://www.phpbb.com/">phpBB Group</a>, All Rights Reserved.</p>

+ p.post_visibility, \

+ sql_attr_uint = post_visibility

+ p.post_visibility, \

+ 'EXPLAIN' => ($token === 'LOCAL_URL') ? sprintf($token_explain, generate_board_url() . '/') : $token_explain,

+ ));

+ 'RELATIVE_URL' => array(

+ '!(' . str_replace(array('!', '\#'), array('\!', '#'), get_preg_expression('relative_url')) . ')!e' => "\$this->bbcode_specialchars('$1')"

+ ),

+ 'RELATIVE_URL' => '(?i)(' . str_replace(array('!', '\#'), array('\!', '#'), get_preg_expression('relative_url')) . ')(?-i)',

+

+ // Prepend the board url to local relative links

+ $replace_prepend = ($token_type === 'LOCAL_URL') ? generate_board_url() . '/' : '';

+

+ $sp_replace = str_replace($token, $replace_prepend . '${' . ($n + 1) . '}', $sp_replace);

+ if ($fields = $provider->acp())

+ foreach ($fields as $field)

+ $auth_tpl = $provider->get_acp_template($this->new_config);

+ if ($auth_tpl)

+ $template->assign_vars($auth_tpl['TEMPLATE_VARS']);

+ 'TEMPLATE_FILE' => $auth_tpl['TEMPLATE_FILE'],

+ foreach ($auth_providers as $key => $value)

+ if (!($value instanceof phpbb_auth_provider_interface))

+ {

+ continue;

+ }

+ $sql = 'SELECT forum_name, (forum_topics_approved + forum_topics_unapproved + forum_topics_softdeleted) AS total_topics

+ if ($row['total_topics'])

+ $url = $this->u_action . "&amp;parent_id={$this->parent_id}&amp;f=$forum_id&amp;action=sync&amp;start=$start&amp;topics_done=$topics_done&amp;total={$row['total_topics']}";

+ 'U_PROGRESS_BAR' => $this->u_action . "&amp;action=progress_bar&amp;start=$topics_done&amp;total={$row['total_topics']}",

+ 'UA_PROGRESS_BAR' => addslashes($this->u_action . "&amp;action=progress_bar&amp;start=$topics_done&amp;total={$row['total_topics']}"),

+ 'L_PROGRESS_EXPLAIN' => sprintf($user->lang['SYNC_IN_PROGRESS_EXPLAIN'], $topics_done, $row['total_topics']))

+ 'L_PROGRESS_EXPLAIN' => sprintf($user->lang['SYNC_IN_PROGRESS_EXPLAIN'], 0, $row['total_topics']))

+ 'FORUM_TOPICS' => $row['forum_topics_approved'],

+ 'FORUM_POSTS' => $row['forum_posts_approved'],

+ $forum_data_sql['forum_posts_approved'] = $forum_data_sql['forum_posts_unapproved'] = $forum_data_sql['forum_posts_softdeleted'] = $forum_data_sql['forum_topics_approved'] = $forum_data_sql['forum_topics_unapproved'] = $forum_data_sql['forum_topics_softdeleted'] = 0;

+ $forum_data_sql['forum_last_post_id'] = $forum_data_sql['forum_last_poster_id'] = $forum_data_sql['forum_last_post_time'] = 0;

+ $forum_data_sql['forum_posts_approved'] = 0;

+ $forum_data_sql['forum_posts_unapproved'] = 0;

+ $forum_data_sql['forum_posts_softdeleted'] = 0;

+ $forum_data_sql['forum_topics_approved'] = 0;

+ $forum_data_sql['forum_topics_unapproved'] = 0;

+ $forum_data_sql['forum_topics_softdeleted'] = 0;

+ AND post_visibility = ' . ITEM_APPROVED;

+ WHERE post_visibility = ' . ITEM_APPROVED;

+ WHERE topic_visibility = ' . ITEM_APPROVED;

+ $error = array_merge($error, $validation_error);

+ $error = array_map(array(&$user, 'lang'), $error);

+ redirect(append_sid("{$phpbb_root_path}index.$phpEx"));

+ WHERE post_visibility = ' . ITEM_APPROVED;

+ WHERE topic_visibility = ' . ITEM_APPROVED;

+ AND post_postcount = 1 AND post_visibility = ' . ITEM_APPROVED . '

+ 'L_PHP_VERSION_OLD' => sprintf($user->lang['PHP_VERSION_OLD'], '<a href="https://www.phpbb.com/community/viewtopic.php?f=14&amp;t=2152375">', '</a>'),

+ $old_info_class_file = str_replace("phpbb_{$module_class}_info_", '', $cur_module);

+ $old_info_class = $old_info_class_file . '_info';

+

+ if (class_exists($old_info_class))

+ {

+ $info_class = $old_info_class;

+ }

+ else if (!class_exists($info_class))

+ $info_class = $old_info_class;

+ // need to check class exists again because previous checks triggered autoloading

+ if (!class_exists($info_class) && file_exists($directory . $old_info_class_file . '.' . $phpEx))

+ include($directory . $old_info_class_file . '.' . $phpEx);

+ $collect_url = "https://www.phpbb.com/stats/receive_stats.php";

+ $sql = 'SELECT topic_id, post_visibility, COUNT(post_id) AS total_posts

+ GROUP BY topic_id, post_visibility";

+ $topic_id_ary[$row['topic_id']][$row['post_visibility']] = $row['total_posts'];

+ $sql = 'SELECT topic_id, forum_id, topic_title, topic_posts_approved, topic_posts_unapproved, topic_posts_softdeleted, topic_attachment

+ if ($topic_id_ary[$row['topic_id']][ITEM_APPROVED] == $row['topic_posts_approved']

+ && $topic_id_ary[$row['topic_id']][ITEM_UNAPPROVED] == $row['topic_posts_unapproved']

+ && $topic_id_ary[$row['topic_id']][ITEM_DELETED] == $row['topic_posts_softdeleted'])

+ 'topic_visibility' => ITEM_APPROVED,

+ AND post_visibility = ' . ITEM_UNAPPROVED;

+class phpbb_auth_provider_apache extends phpbb_auth_provider_base

+<?php

+/**

+*

+* @package auth

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Base authentication provider class that all other providers should implement

+*

+* @package auth

+*/

+abstract class phpbb_auth_provider_base implements phpbb_auth_provider_interface

+{

+ /**

+ * {@inheritdoc}

+ */

+ public function init()

+ {

+ return;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function autologin()

+ {

+ return;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function acp()

+ {

+ return;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_acp_template($new_config)

+ {

+ return;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function logout($data, $new_session)

+ {

+ return;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function validate_session($user)

+ {

+ return;

+ }

+}

+class phpbb_auth_provider_db extends phpbb_auth_provider_base

+ * configuration fields of the provider.

+ */

+ public function acp();

+

+ /**

+ * This function updates the template with variables related to the acp

+ * options with whatever configuraton values are passed to it as an array.

+ * It then returns the name of the acp file related to this authentication

+ * provider.

+ * @param array $new_config Contains the new configuration values that

+ * have been set in acp_board.

+ * @return array|null Returns null if not implemented or an array with

+ * the template file name and an array of the vars

+ * that the template needs that must conform to the

+ * following example:

+ * 'TEMPLATE_FILE' => string,

+ * 'TEMPLATE_VARS' => array(...),

+ public function get_acp_template($new_config);

+class phpbb_auth_provider_ldap extends phpbb_auth_provider_base

+

+ public function acp()

+ // These are fields required in the config table

+ return array(

+ 'ldap_server', 'ldap_port', 'ldap_base_dn', 'ldap_uid', 'ldap_user_filter', 'ldap_email', 'ldap_user', 'ldap_password',

+ );

+ public function get_acp_template($new_config)

+ 'TEMPLATE_FILE' => 'auth_provider_ldap.html',

+ 'TEMPLATE_VARS' => array(

+ 'AUTH_LDAP_DN' => $new_config['ldap_base_dn'],

+ 'AUTH_LDAP_EMAIL' => $new_config['ldap_email'],

+ 'AUTH_LDAP_PASSORD' => $new_config['ldap_password'],

+ 'AUTH_LDAP_PORT' => $new_config['ldap_port'],

+ 'AUTH_LDAP_SERVER' => $new_config['ldap_server'],

+ 'AUTH_LDAP_UID' => $new_config['ldap_uid'],

+ 'AUTH_LDAP_USER' => $new_config['ldap_user'],

+ 'AUTH_LDAP_USER_FILTER' => $new_config['ldap_user_filter'],

+ ),

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

+ {

+ $url = 'http://' . $url;

+ }

+

+ if (!function_exists('validate_data'))

+ {

+ require($this->phpbb_root_path . 'includes/functions_user.' . $this->php_ext);

+ }

+

+ $validate_array = validate_data(

+ array(

+ 'url' => $url,

+ ),

+ array(

+ 'url' => array('string', true, 5, 255),

+ )

+ );

+

+ $error = array_merge($error, $validate_array);

+

+ if (!empty($error))

+ {

+ return false;

+ }

+

+ $template = new phpbb_template_twig($phpbb_root_path, $phpEx, $config, $user, new phpbb_template_context(), $phpbb_extension_manager);

+ $this->template_filename = $template->get_source_file_for_handle('bbcode.html');

+define('ITEM_UNAPPROVED', 0); // => has not yet been approved

+define('ITEM_APPROVED', 1); // => has been approved, and has not been soft deleted

+define('ITEM_DELETED', 2); // => has been soft deleted

+

+<?php

+/**

+*

+* @package phpbb

+* @copyright (c) 2012 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* phpbb_visibility

+* Handle fetching and setting the visibility for topics and posts

+* @package phpbb

+*/

+class phpbb_content_visibility

+{

+ /**

+ * Database object

+ * @var phpbb_db_driver

+ */

+ protected $db;

+

+ /**

+ * User object

+ * @var phpbb_user

+ */

+ protected $user;

+

+ /**

+ * Auth object

+ * @var phpbb_auth

+ */

+ protected $auth;

+

+ /**

+ * phpBB root path

+ * @var string

+ */

+ protected $phpbb_root_path;

+

+ /**

+ * PHP Extension

+ * @var string

+ */

+ protected $php_ext;

+

+ /**

+ * Constructor

+ *

+ * @param phpbb_auth $auth Auth object

+ * @param phpbb_db_driver $db Database object

+ * @param phpbb_user $user User object

+ * @param string $phpbb_root_path Root path

+ * @param string $php_ext PHP Extension

+ * @return null

+ */

+ public function __construct(phpbb_auth $auth, phpbb_db_driver $db, phpbb_user $user, $phpbb_root_path, $php_ext, $forums_table, $posts_table, $topics_table, $users_table)

+ {

+ $this->auth = $auth;

+ $this->db = $db;

+ $this->user = $user;

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->php_ext = $php_ext;

+ $this->forums_table = $forums_table;

+ $this->posts_table = $posts_table;

+ $this->topics_table = $topics_table;

+ $this->users_table = $users_table;

+ }

+

+ /**

+ * Can the current logged-in user soft-delete posts?

+ *

+ * @param $forum_id int Forum ID whose permissions to check

+ * @param $poster_id int Poster ID of the post in question

+ * @param $post_locked bool Is the post locked?

+ * @return bool

+ */

+ public function can_soft_delete($forum_id, $poster_id, $post_locked)

+ {

+ if ($this->auth->acl_get('m_softdelete', $forum_id))

+ {

+ return true;

+ }

+ else if ($this->auth->acl_get('f_softdelete', $forum_id) && $poster_id == $this->user->data['user_id'] && !$post_locked)

+ {

+ return true;

+ }

+

+ return false;

+ }

+

+ /**

+ * Get the topics post count or the forums post/topic count based on permissions

+ *

+ * @param $mode string One of topic_posts, forum_posts or forum_topics

+ * @param $data array Array with the topic/forum data to calculate from

+ * @param $forum_id int The forum id is used for permission checks

+ * @return int Number of posts/topics the user can see in the topic/forum

+ */

+ public function get_count($mode, $data, $forum_id)

+ {

+ if (!$this->auth->acl_get('m_approve', $forum_id))

+ {

+ return (int) $data[$mode . '_approved'];

+ }

+

+ return (int) $data[$mode . '_approved'] + (int) $data[$mode . '_unapproved'] + (int) $data[$mode . '_softdeleted'];

+ }

+

+ /**

+ * Create topic/post visibility SQL for a given forum ID

+ *

+ * Note: Read permissions are not checked.

+ *

+ * @param $mode string Either "topic" or "post"

+ * @param $forum_id int The forum id is used for permission checks

+ * @param $table_alias string Table alias to prefix in SQL queries

+ * @return string The appropriate combination SQL logic for topic/post_visibility

+ */

+ public function get_visibility_sql($mode, $forum_id, $table_alias = '')

+ {

+ if ($this->auth->acl_get('m_approve', $forum_id))

+ {

+ return '1 = 1';

+ }

+

+ return $table_alias . $mode . '_visibility = ' . ITEM_APPROVED;

+ }

+

+ /**

+ * Create topic/post visibility SQL for a set of forums

+ *

+ * Note: Read permissions are not checked. Forums without read permissions

+ * should not be in $forum_ids

+ *

+ * @param $mode string Either "topic" or "post"

+ * @param $forum_ids array Array of forum ids which the posts/topics are limited to

+ * @param $table_alias string Table alias to prefix in SQL queries

+ * @return string The appropriate combination SQL logic for topic/post_visibility

+ */

+ public function get_forums_visibility_sql($mode, $forum_ids = array(), $table_alias = '')

+ {

+ $where_sql = '(';

+

+ $approve_forums = array_intersect($forum_ids, array_keys($this->auth->acl_getf('m_approve', true)));

+

+ if (sizeof($approve_forums))

+ {

+ // Remove moderator forums from the rest

+ $forum_ids = array_diff($forum_ids, $approve_forums);

+

+ if (!sizeof($forum_ids))

+ {

+ // The user can see all posts/topics in all specified forums

+ return $this->db->sql_in_set($table_alias . 'forum_id', $approve_forums);

+ }

+ else

+ {

+ // Moderator can view all posts/topics in some forums

+ $where_sql .= $this->db->sql_in_set($table_alias . 'forum_id', $approve_forums) . ' OR ';

+ }

+ }

+ else

+ {

+ // The user is just a normal user

+ return $table_alias . $mode . '_visibility = ' . ITEM_APPROVED . '

+ AND ' . $this->db->sql_in_set($table_alias . 'forum_id', $forum_ids, false, true);

+ }

+

+ $where_sql .= '(' . $table_alias . $mode . '_visibility = ' . ITEM_APPROVED . '

+ AND ' . $this->db->sql_in_set($table_alias . 'forum_id', $forum_ids) . '))';

+

+ return $where_sql;

+ }

+

+ /**

+ * Create topic/post visibility SQL for all forums on the board

+ *

+ * Note: Read permissions are not checked. Forums without read permissions

+ * should be in $exclude_forum_ids

+ *

+ * @param $mode string Either "topic" or "post"

+ * @param $exclude_forum_ids array Array of forum ids which are excluded

+ * @param $table_alias string Table alias to prefix in SQL queries

+ * @return string The appropriate combination SQL logic for topic/post_visibility

+ */

+ public function get_global_visibility_sql($mode, $exclude_forum_ids = array(), $table_alias = '')

+ {

+ $where_sqls = array();

+

+ $approve_forums = array_diff(array_keys($this->auth->acl_getf('m_approve', true)), $exclude_forum_ids);

+

+ if (sizeof($exclude_forum_ids))

+ {

+ $where_sqls[] = '(' . $this->db->sql_in_set($table_alias . 'forum_id', $exclude_forum_ids, true) . '

+ AND ' . $table_alias . $mode . '_visibility = ' . ITEM_APPROVED . ')';

+ }

+ else

+ {

+ $where_sqls[] = $table_alias . $mode . '_visibility = ' . ITEM_APPROVED;

+ }

+

+ if (sizeof($approve_forums))

+ {

+ $where_sqls[] = $this->db->sql_in_set($table_alias . 'forum_id', $approve_forums);

+ return '(' . implode(' OR ', $where_sqls) . ')';

+ }

+

+ // There is only one element, so we just return that one

+ return $where_sqls[0];

+ }

+

+ /**

+ * Change visibility status of one post or all posts of a topic

+ *

+ * @param $visibility int Element of {ITEM_APPROVED, ITEM_DELETED}

+ * @param $post_id mixed Post ID or array of post IDs to act on,

+ * if it is empty, all posts of topic_id will be modified

+ * @param $topic_id int Topic where $post_id is found

+ * @param $forum_id int Forum where $topic_id is found

+ * @param $user_id int User performing the action

+ * @param $time int Timestamp when the action is performed

+ * @param $reason string Reason why the visibilty was changed.

+ * @param $is_starter bool Is this the first post of the topic changed?

+ * @param $is_latest bool Is this the last post of the topic changed?

+ * @param $limit_visibility mixed Limit updating per topic_id to a certain visibility

+ * @param $limit_delete_time mixed Limit updating per topic_id to a certain deletion time

+ * @return array Changed post data, empty array if an error occured.

+ */

+ public function set_post_visibility($visibility, $post_id, $topic_id, $forum_id, $user_id, $time, $reason, $is_starter, $is_latest, $limit_visibility = false, $limit_delete_time = false)

+ {

+ if (!in_array($visibility, array(ITEM_APPROVED, ITEM_DELETED)))

+ {

+ return array();

+ }

+

+ if ($post_id)

+ {

+ if (is_array($post_id))

+ {

+ $where_sql = $this->db->sql_in_set('post_id', array_map('intval', $post_id));

+ }

+ else

+ {

+ $where_sql = 'post_id = ' . (int) $post_id;

+ }

+ $where_sql .= ' AND topic_id = ' . (int) $topic_id;

+ }

+ else

+ {

+ $where_sql = 'topic_id = ' . (int) $topic_id;

+

+ // Limit the posts to a certain visibility and deletion time

+ // This allows us to only restore posts, that were approved

+ // when the topic got soft deleted. So previous soft deleted

+ // and unapproved posts are still soft deleted/unapproved

+ if ($limit_visibility !== false)

+ {

+ $where_sql .= ' AND post_visibility = ' . (int) $limit_visibility;

+ }

+

+ if ($limit_delete_time !== false)

+ {

+ $where_sql .= ' AND post_delete_time = ' . (int) $limit_delete_time;

+ }

+ }

+

+ $sql = 'SELECT poster_id, post_id, post_postcount, post_visibility

+ FROM ' . $this->posts_table . '

+ WHERE ' . $where_sql;

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

+

+ $post_ids = $poster_postcounts = $postcounts = $postcount_visibility = array();

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

+ {

+ $post_ids[] = (int) $row['post_id'];

+

+ if ($row['post_visibility'] != $visibility)

+ {

+ if ($row['post_postcount'] && !isset($poster_postcounts[(int) $row['poster_id']]))

+ {

+ $poster_postcounts[(int) $row['poster_id']] = 1;

+ }

+ else if ($row['post_postcount'])

+ {

+ $poster_postcounts[(int) $row['poster_id']]++;

+ }

+

+ if (!isset($postcount_visibility[$row['post_visibility']]))

+ {

+ $postcount_visibility[$row['post_visibility']] = 1;

+ }

+ else

+ {

+ $postcount_visibility[$row['post_visibility']]++;

+ }

+ }

+ }

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

+

+ if (empty($post_ids))

+ {

+ return array();

+ }

+

+ $data = array(

+ 'post_visibility' => (int) $visibility,

+ 'post_delete_user' => (int) $user_id,

+ 'post_delete_time' => ((int) $time) ?: time(),

+ 'post_delete_reason' => truncate_string($reason, 255, 255, false),

+ );

+

+ $sql = 'UPDATE ' . $this->posts_table . '

+ SET ' . $this->db->sql_build_array('UPDATE', $data) . '

+ WHERE ' . $this->db->sql_in_set('post_id', $post_ids);

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

+

+ // Group the authors by post count, to reduce the number of queries

+ foreach ($poster_postcounts as $poster_id => $num_posts)

+ {

+ $postcounts[$num_posts][] = $poster_id;

+ }

+

+ // Update users postcounts

+ foreach ($postcounts as $num_posts => $poster_ids)

+ {

+ if ($visibility == ITEM_DELETED)

+ {

+ $sql = 'UPDATE ' . $this->users_table . '

+ SET user_posts = 0

+ WHERE ' . $this->db->sql_in_set('user_id', $poster_ids) . '

+ AND user_posts < ' . $num_posts;

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

+

+ $sql = 'UPDATE ' . $this->users_table . '

+ SET user_posts = user_posts - ' . $num_posts . '

+ WHERE ' . $this->db->sql_in_set('user_id', $poster_ids) . '

+ AND user_posts >= ' . $num_posts;

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

+ }

+ else

+ {

+ $sql = 'UPDATE ' . $this->users_table . '

+ SET user_posts = user_posts + ' . $num_posts . '

+ WHERE ' . $this->db->sql_in_set('user_id', $poster_ids);

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

+ }

+ }

+

+ $update_topic_postcount = true;

+

+ // Sync the first/last topic information if needed

+ if (!$is_starter && $is_latest)

+ {

+ // update_post_information can only update the last post info ...

+ if ($topic_id)

+ {

+ update_post_information('topic', $topic_id, false);

+ }

+ if ($forum_id)

+ {

+ update_post_information('forum', $forum_id, false);

+ }

+ }

+ else if ($is_starter && $topic_id)

+ {

+ if (!function_exists('sync'))

+ {

+ include($this->phpbb_root_path . 'includes/functions_admin.' . $this->php_ext);

+ }

+

+ // ... so we need to use sync, if the first post is changed.

+ // The forum is resynced recursive by sync() itself.

+ sync('topic', 'topic_id', $topic_id, true);

+

+ // sync recalculates the topic replies and forum posts by itself, so we don't do that.

+ $update_topic_postcount = false;

+ }

+

+ // Update the topic's reply count and the forum's post count

+ if ($update_topic_postcount)

+ {

+ $cur_posts = $cur_unapproved_posts = $cur_softdeleted_posts = 0;

+ foreach ($postcount_visibility as $post_visibility => $visibility_posts)

+ {

+ // We need to substract the posts from the counters ...

+ if ($post_visibility == ITEM_APPROVED)

+ {

+ $cur_posts += $visibility_posts;

+ }

+ else if ($post_visibility == ITEM_UNAPPROVED)

+ {

+ $cur_unapproved_posts += $visibility_posts;

+ }

+ else if ($post_visibility == ITEM_DELETED)

+ {

+ $cur_softdeleted_posts += $visibility_posts;

+ }

+ }

+

+ $sql_ary = array();

+ if ($visibility == ITEM_DELETED)

+ {

+ if ($cur_posts)

+ {

+ $sql_ary['posts_approved'] = ' - ' . $cur_posts;

+ }

+ if ($cur_unapproved_posts)

+ {

+ $sql_ary['posts_unapproved'] = ' - ' . $cur_unapproved_posts;

+ }

+ if ($cur_posts + $cur_unapproved_posts)

+ {

+ $sql_ary['posts_softdeleted'] = ' + ' . ($cur_posts + $cur_unapproved_posts);

+ }

+ }

+ else

+ {

+ if ($cur_unapproved_posts)

+ {

+ $sql_ary['posts_unapproved'] = ' - ' . $cur_unapproved_posts;

+ }

+ if ($cur_softdeleted_posts)

+ {

+ $sql_ary['posts_softdeleted'] = ' - ' . $cur_softdeleted_posts;

+ }

+ if ($cur_softdeleted_posts + $cur_unapproved_posts)

+ {

+ $sql_ary['posts_approved'] = ' + ' . ($cur_softdeleted_posts + $cur_unapproved_posts);

+ }

+ }

+

+ if (sizeof($sql_ary))

+ {

+ $topic_sql = $forum_sql = array();

+

+ foreach ($sql_ary as $field => $value_change)

+ {

+ $topic_sql[] = 'topic_' . $field . ' = topic_' . $field . $value_change;

+ $forum_sql[] = 'forum_' . $field . ' = forum_' . $field . $value_change;

+ }

+

+ // Update the number for replies and posts

+ $sql = 'UPDATE ' . $this->topics_table . '

+ SET ' . implode(', ', $topic_sql) . '

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

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

+

+ $sql = 'UPDATE ' . $this->forums_table . '

+ SET ' . implode(', ', $forum_sql) . '

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

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

+ }

+ }

+

+ return $data;

+ }

+

+ /**

+ * Set topic visibility

+ *

+ * Allows approving (which is akin to undeleting/restore) or soft deleting an entire topic.

+ * Calls set_post_visibility as needed.

+ *

+ * Note: By default, when a soft deleted topic is restored. Only posts that

+ * were approved at the time of soft deleting, are being restored.

+ * Same applies to soft deleting. Only approved posts will be marked

+ * as soft deleted.

+ * If you want to update all posts, use the force option.

+ *

+ * @param $visibility int Element of {ITEM_APPROVED, ITEM_DELETED}

+ * @param $topic_id mixed Topic ID to act on

+ * @param $forum_id int Forum where $topic_id is found

+ * @param $user_id int User performing the action

+ * @param $time int Timestamp when the action is performed

+ * @param $reason string Reason why the visibilty was changed.

+ * @param $force_update_all bool Force to update all posts within the topic

+ * @return array Changed topic data, empty array if an error occured.

+ */

+ public function set_topic_visibility($visibility, $topic_id, $forum_id, $user_id, $time, $reason, $force_update_all = false)

+ {

+ if (!in_array($visibility, array(ITEM_APPROVED, ITEM_DELETED)))

+ {

+ return array();

+ }

+

+ if (!$force_update_all)

+ {

+ $sql = 'SELECT topic_visibility, topic_delete_time

+ FROM ' . $this->topics_table . '

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

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

+ $original_topic_data = $this->db->sql_fetchrow($result);

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

+

+ if (!$original_topic_data)

+ {

+ // The topic does not exist...

+ return array();

+ }

+ }

+

+ // Note, we do not set a reason for the posts, just for the topic

+ $data = array(

+ 'topic_visibility' => (int) $visibility,

+ 'topic_delete_user' => (int) $user_id,

+ 'topic_delete_time' => ((int) $time) ?: time(),

+ 'topic_delete_reason' => truncate_string($reason, 255, 255, false),

+ );

+

+ $sql = 'UPDATE ' . $this->topics_table . '

+ SET ' . $this->db->sql_build_array('UPDATE', $data) . '

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

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

+

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

+ {

+ return array();

+ }

+

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

+ {

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

+ self::set_post_visibility($visibility, false, $topic_id, $forum_id, $user_id, $time, '', true, true, $original_topic_data['topic_visibility'], $original_topic_data['topic_delete_time']);

+ }

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

+ {

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

+ self::set_post_visibility($visibility, false, $topic_id, $forum_id, $user_id, $time, '', true, true, $original_topic_data['topic_visibility']);

+ }

+ else

+ {

+ self::set_post_visibility($visibility, false, $topic_id, $forum_id, $user_id, $time, '', true, true);

+ }

+

+ return $data;

+ }

+

+ /**

+ * Add post to topic and forum statistics

+ *

+ * @param $data array Contains information from the topics table about given topic

+ * @param $sql_data array Populated with the SQL changes, may be empty at call time

+ * @return void

+ */

+ public function add_post_to_statistic($data, &$sql_data)

+ {

+ $sql_data[$this->topics_table] = (($sql_data[$this->topics_table]) ? $sql_data[$this->topics_table] . ', ' : '') . 'topic_posts_approved = topic_posts_approved + 1';

+

+ $sql_data[$this->forums_table] = (($sql_data[$this->forums_table]) ? $sql_data[$this->forums_table] . ', ' : '') . 'forum_posts_approved = forum_posts_approved + 1';

+

+ if ($data['post_postcount'])

+ {

+ $sql_data[$this->users_table] = (($sql_data[$this->users_table]) ? $sql_data[$this->users_table] . ', ' : '') . 'user_posts = user_posts + 1';

+ }

+

+ set_config_count('num_posts', 1, true);

+ }

+

+ /**

+ * Remove post from topic and forum statistics

+ *

+ * @param $data array Contains information from the topics table about given topic

+ * @param $sql_data array Populated with the SQL changes, may be empty at call time

+ * @return void

+ */

+ public function remove_post_from_statistic($data, &$sql_data)

+ {

+ $sql_data[$this->topics_table] = ((!empty($sql_data[$this->topics_table])) ? $sql_data[$this->topics_table] . ', ' : '') . 'topic_posts_approved = topic_posts_approved - 1';

+ $sql_data[$this->forums_table] = ((!empty($sql_data[$this->forums_table])) ? $sql_data[$this->forums_table] . ', ' : '') . 'forum_posts_approved = forum_posts_approved - 1';

+

+ if ($data['post_postcount'])

+ {

+ $sql_data[$this->users_table] = ((!empty($sql_data[$this->users_table])) ? $sql_data[$this->users_table] . ', ' : '') . 'user_posts = user_posts - 1';

+ }

+

+ set_config_count('num_posts', -1, true);

+ }

+

+ /**

+ * Remove topic from forum statistics

+ *

+ * @param $topic_id int The topic to act on

+ * @param $forum_id int Forum where the topic is found

+ * @param $topic_row array Contains information from the topic, may be empty at call time

+ * @param $sql_data array Populated with the SQL changes, may be empty at call time

+ * @return void

+ */

+ public function remove_topic_from_statistic($topic_id, $forum_id, &$topic_row, &$sql_data)

+ {

+ // Do we need to grab some topic informations?

+ if (!sizeof($topic_row))

+ {

+ $sql = 'SELECT topic_type, topic_posts_approved, topic_posts_unapproved, topic_posts_softdeleted, topic_visibility

+ FROM ' . $this->topics_table . '

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

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

+ $topic_row = $this->db->sql_fetchrow($result);

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

+ }

+

+ // If this is an edited topic or the first post the topic gets completely disapproved later on...

+ $sql_data[$this->forums_table] = (($sql_data[$this->forums_table]) ? $sql_data[$this->forums_table] . ', ' : '') . 'forum_topics_approved = forum_topics_approved - 1';

+ $sql_data[$this->forums_table] .= ', forum_posts_approved = forum_posts_approved - ' . $topic_row['topic_posts_approved'];

+ $sql_data[$this->forums_table] .= ', forum_posts_unapproved = forum_posts_unapproved - ' . $topic_row['topic_posts_unapproved'];

+ $sql_data[$this->forums_table] .= ', forum_posts_softdeleted = forum_posts_softdeleted - ' . $topic_row['topic_posts_softdeleted'];

+

+ set_config_count('num_topics', -1, true);

+ set_config_count('num_posts', $topic_row['topic_posts_approved'] * (-1), true);

+

+ // Get user post count information

+ $sql = 'SELECT poster_id, COUNT(post_id) AS num_posts

+ FROM ' . $this->posts_table . '

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

+ AND post_postcount = 1

+ AND post_visibility = ' . ITEM_APPROVED . '

+ GROUP BY poster_id';

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

+

+ $postcounts = array();

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

+ {

+ $postcounts[(int) $row['num_posts']][] = (int) $row['poster_id'];

+ }

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

+

+ // Decrement users post count

+ foreach ($postcounts as $num_posts => $poster_ids)

+ {

+ $sql = 'UPDATE ' . $this->users_table . '

+ SET user_posts = 0

+ WHERE user_posts < ' . $num_posts . '

+ AND ' . $this->db->sql_in_set('user_id', $poster_ids);

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

+

+ $sql = 'UPDATE ' . $this->users_table . '

+ SET user_posts = user_posts - ' . $num_posts . '

+ WHERE user_posts >= ' . $num_posts . '

+ AND ' . $this->db->sql_in_set('user_id', $poster_ids);

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

+ }

+ }

+}

+ * phpbb_style object

+ * @var phpbb_style

+ */

+ protected $style;

+

+ /**

+ * @param phpbb_style $style

+ public function __construct(phpbb_user $user, ContainerInterface $container, phpbb_style $style = null)

+ $this->style = $style;

+ /*

+ * If this is an extension controller, we'll try to automatically set

+ * the style paths for the extension (the ext author can change them

+ * if necessary).

+ */

+ $controller_dir = explode('_', get_class($controller_object));

+

+ // 0 phpbb, 1 ext, 2 vendor, 3 extension name, ...

+ if (!is_null($this->style) && isset($controller_dir[3]) && $controller_dir[1] === 'ext')

+ {

+ $controller_style_dir = 'ext/' . $controller_dir[2] . '/' . $controller_dir[3] . '/styles';

+

+ if (is_dir($controller_style_dir))

+ {

+ $this->style->set_style(array($controller_style_dir, 'styles'));

+ }

+ }

+

+ Powered by <a href="https://www.phpbb.com/">phpBB</a>&reg; Forum Software &copy; phpBB Group

+ // in 3.0.9-RCX installations and has to be dropped as

+ // soon as the db_tools class is capable of properly

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+class phpbb_db_migration_data_30x_local_url_bbcode extends phpbb_db_migration

+{

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_12_rc1');

+ }

+

+ public function update_data()

+ {

+ return array(

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

+ );

+ }

+

+ /**

+ * Update BBCodes that currently use the LOCAL_URL tag

+ *

+ * To fix http://tracker.phpbb.com/browse/PHPBB3-8319 we changed

+ * the second_pass_replace value, so that needs updating for existing ones

+ */

+ public function update_local_url_bbcode()

+ {

+ $sql = 'SELECT *

+ FROM ' . BBCODES_TABLE . '

+ WHERE bbcode_match ' . $this->db->sql_like_expression($this->db->any_char . 'LOCAL_URL' . $this->db->any_char);

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

+

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

+ {

+ if (!class_exists('acp_bbcodes'))

+ {

+ global $phpEx;

+ phpbb_require_updated('includes/acp/acp_bbcodes.' . $phpEx);

+ }

+ $bbcode_match = $row['bbcode_match'];

+ $bbcode_tpl = $row['bbcode_tpl'];

+

+ $acp_bbcodes = new acp_bbcodes();

+ $sql_ary = $acp_bbcodes->build_regexp($bbcode_match, $bbcode_tpl);

+

+ $sql = 'UPDATE ' . BBCODES_TABLE . '

+ SET ' . $this->db->sql_build_array('UPDATE', $sql_ary) . '

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

+ $this->sql_query($sql);

+ }

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

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+class phpbb_db_migration_data_310_notification_options_reconvert extends phpbb_db_migration

+{

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_310_notifications_schema_fix');

+ }

+

+ public function update_data()

+ {

+ return array(

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

+ );

+ }

+

+ public function convert_notifications()

+ {

+ $insert_table = $this->table_prefix . 'user_notifications';

+ $insert_buffer = new phpbb_db_sql_insert_buffer($this->db, $insert_table);

+

+ $this->perform_conversion($insert_buffer, $insert_table);

+ }

+

+ /**

+ * Perform the conversion (separate for testability)

+ *

+ * @param phpbb_db_sql_insert_buffer $insert_buffer

+ * @param string $insert_table

+ */

+ public function perform_conversion(phpbb_db_sql_insert_buffer $insert_buffer, $insert_table)

+ {

+ $sql = 'DELETE FROM ' . $insert_table;

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

+

+ $sql = 'SELECT user_id, user_notify_type, user_notify_pm

+ FROM ' . USERS_TABLE;

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

+

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

+ {

+ $notification_methods = array();

+

+ // In-board notification

+ $notification_methods[] = '';

+

+ if ($row['user_notify_type'] == NOTIFY_EMAIL || $row['user_notify_type'] == NOTIFY_BOTH)

+ {

+ $notification_methods[] = 'email';

+ }

+

+ if ($row['user_notify_type'] == NOTIFY_IM || $row['user_notify_type'] == NOTIFY_BOTH)

+ {

+ $notification_methods[] = 'jabber';

+ }

+

+ // Notifications for posts

+ foreach (array('post', 'topic') as $item_type)

+ {

+ $this->add_method_rows(

+ $insert_buffer,

+ $item_type,

+ 0,

+ $row['user_id'],

+ $notification_methods

+ );

+ }

+

+ if ($row['user_notify_pm'])

+ {

+ // Notifications for private messages

+ // User either gets all methods or no method

+ $this->add_method_rows(

+ $insert_buffer,

+ 'pm',

+ 0,

+ $row['user_id'],

+ $notification_methods

+ );

+ }

+ }

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

+

+ $insert_buffer->flush();

+ }

+

+ /**

+ * Insert method rows to DB

+ *

+ * @param phpbb_db_sql_insert_buffer $insert_buffer

+ * @param string $item_type

+ * @param int $item_id

+ * @param int $user_id

+ * @param string $methods

+ */

+ protected function add_method_rows(phpbb_db_sql_insert_buffer $insert_buffer, $item_type, $item_id, $user_id, array $methods)

+ {

+ $row_base = array(

+ 'item_type' => $item_type,

+ 'item_id' => (int) $item_id,

+ 'user_id' => (int) $user_id,

+ 'notify' => 1

+ );

+

+ foreach ($methods as $method)

+ {

+ $row_base['method'] = $method;

+ $insert_buffer->insert($row_base);

+ }

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License v2

+*

+*/

+

+class phpbb_db_migration_data_310_softdelete_p1 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return $this->db_tools->sql_column_exists($this->table_prefix . 'posts', 'post_visibility');

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_310_dev');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

+ 'forum_posts_approved' => array('UINT', 0),

+ 'forum_posts_unapproved' => array('UINT', 0),

+ 'forum_posts_softdeleted' => array('UINT', 0),

+ 'forum_topics_approved' => array('UINT', 0),

+ 'forum_topics_unapproved' => array('UINT', 0),

+ 'forum_topics_softdeleted' => array('UINT', 0),

+ ),

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

+ 'post_visibility' => array('TINT:3', 0),

+ 'post_delete_time' => array('TIMESTAMP', 0),

+ 'post_delete_reason' => array('STEXT_UNI', ''),

+ 'post_delete_user' => array('UINT', 0),

+ ),

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

+ 'topic_visibility' => array('TINT:3', 0),

+ 'topic_delete_time' => array('TIMESTAMP', 0),

+ 'topic_delete_reason' => array('STEXT_UNI', ''),

+ 'topic_delete_user' => array('UINT', 0),

+ 'topic_posts_approved' => array('UINT', 0),

+ 'topic_posts_unapproved' => array('UINT', 0),

+ 'topic_posts_softdeleted' => array('UINT', 0),

+ ),

+ ),

+ 'add_index' => array(

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

+ 'post_visibility' => array('post_visibility'),

+ ),

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

+ 'topic_visibility' => array('topic_visibility'),

+ 'forum_vis_last' => array('forum_id', 'topic_visibility', 'topic_last_post_id'),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'forum_posts_approved',

+ 'forum_posts_unapproved',

+ 'forum_posts_softdeleted',

+ 'forum_topics_approved',

+ 'forum_topics_unapproved',

+ 'forum_topics_softdeleted',

+ ),

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

+ 'post_visibility',

+ 'post_delete_time',

+ 'post_delete_reason',

+ 'post_delete_user',

+ ),

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

+ 'topic_visibility',

+ 'topic_delete_time',

+ 'topic_delete_reason',

+ 'topic_delete_user',

+ 'topic_posts_approved',

+ 'topic_posts_unapproved',

+ 'topic_posts_softdeleted',

+ ),

+ ),

+ 'drop_keys' => array(

+ $this->table_prefix . 'posts' => array('post_visibility'),

+ $this->table_prefix . 'topics' => array('topic_visibility', 'forum_vis_last'),

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

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

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

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

+

+ array('permission.add', array('f_softdelete', false)),

+ array('permission.add', array('m_softdelete', false)),

+ );

+ }

+

+ public function update_post_visibility()

+ {

+ $sql = 'UPDATE ' . $this->table_prefix . 'posts

+ SET post_visibility = post_approved';

+ $this->sql_query($sql);

+ }

+

+ public function update_topic_visibility()

+ {

+ $sql = 'UPDATE ' . $this->table_prefix . 'topics

+ SET topic_visibility = topic_approved';

+ $this->sql_query($sql);

+ }

+

+ public function update_topic_forum_counts()

+ {

+ $sql = 'UPDATE ' . $this->table_prefix . 'topics

+ SET topic_posts_approved = topic_replies + 1,

+ topic_posts_unapproved = topic_replies_real - topic_replies

+ WHERE topic_visibility = ' . ITEM_APPROVED;

+ $this->sql_query($sql);

+

+ $sql = 'UPDATE ' . $this->table_prefix . 'topics

+ SET topic_posts_approved = 0,

+ topic_posts_unapproved = (topic_replies_real - topic_replies) + 1

+ WHERE topic_visibility = ' . ITEM_UNAPPROVED;

+ $this->sql_query($sql);

+

+ $sql = 'SELECT forum_id, topic_visibility, COUNT(topic_id) AS sum_topics, SUM(topic_posts_approved) AS sum_posts_approved, SUM(topic_posts_unapproved) AS sum_posts_unapproved

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

+ GROUP BY forum_id, topic_visibility';

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

+

+ $update_forums = array();

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

+ {

+ $forum_id = (int) $row['forum_id'];

+ if (!isset($update_forums[$forum_id]))

+ {

+ $update_forums[$forum_id] = array(

+ 'forum_posts_approved' => 0,

+ 'forum_posts_unapproved' => 0,

+ 'forum_topics_approved' => 0,

+ 'forum_topics_unapproved' => 0,

+ );

+ }

+

+ $update_forums[$forum_id]['forum_posts_approved'] += (int) $row['sum_posts_approved'];

+ $update_forums[$forum_id]['forum_posts_unapproved'] += (int) $row['sum_posts_unapproved'];

+

+ $update_forums[$forum_id][(($row['topic_visibility'] == ITEM_APPROVED) ? 'forum_topics_approved' : 'forum_topics_unapproved')] += (int) $row['sum_topics'];

+ }

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

+

+ foreach ($update_forums as $forum_id => $forum_data)

+ {

+ $sql = 'UPDATE ' . FORUMS_TABLE . '

+ SET ' . $this->db->sql_build_array('UPDATE', $forum_data) . '

+ WHERE forum_id = ' . $forum_id;

+ $this->sql_query($sql);

+ }

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License v2

+*

+*/

+

+class phpbb_db_migration_data_310_softdelete_p2 extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return !$this->db_tools->sql_column_exists($this->table_prefix . 'posts', 'post_approved');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ 'phpbb_db_migration_data_310_dev',

+ 'phpbb_db_migration_data_310_softdelete_p1',

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'drop_columns' => array(

+ $this->table_prefix . 'forums' => array('forum_posts', 'forum_topics', 'forum_topics_real'),

+ $this->table_prefix . 'posts' => array('post_approved'),

+ $this->table_prefix . 'topics' => array('topic_approved', 'topic_replies', 'topic_replies_real'),

+ ),

+ 'drop_keys' => array(

+ $this->table_prefix . 'posts' => array('post_approved'),

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

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

+ 'forum_posts' => array('UINT', 0),

+ 'forum_topics' => array('UINT', 0),

+ 'forum_topics_real' => array('UINT', 0),

+ ),

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

+ 'post_approved' => array('BOOL', 1),

+ ),

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

+ 'topic_approved' => array('BOOL', 1),

+ 'topic_replies' => array('UINT', 0),

+ 'topic_replies_real' => array('UINT', 0),

+ ),

+ ),

+ 'add_index' => array(

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

+ 'post_approved' => array('post_approved'),

+ ),

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

+ 'forum_appr_last' => array('forum_id', 'topic_approved', 'topic_last_post_id'),

+ ),

+ ),

+ );

+ }

+}

+ /** @var array Errors, if any occurred */

+ * @param phpbb_content_visibility $content_visibility Auth object

+ function __construct(phpbb_feed_helper $helper, phpbb_config $config, phpbb_db_driver $db, phpbb_cache_driver_interface $cache, phpbb_user $user, phpbb_auth $auth, phpbb_content_visibility $content_visibility, $phpEx)

+ $this->content_visibility = $content_visibility;

+ AND ' . $this->content_visibility->get_visibility_sql('topic', $this->forum_id) . '

+ 'SELECT' => 'p.post_id, p.topic_id, p.post_time, p.post_edit_time, p.post_visibility, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, ' .

+ AND ' . $this->content_visibility->get_visibility_sql('post', $this->forum_id, 'p.') . '

+ f.forum_topics_approved, f.forum_posts_approved',

+ $item_row['statistics'] = $this->user->lang('TOTAL_TOPICS', (int) $row['forum_topics_approved'])

+ . ' ' . $this->separator_stats . ' ' . $this->user->lang('TOTAL_POSTS_COUNT', (int) $row['forum_posts_approved']);

+ AND topic_visibility = ' . ITEM_APPROVED . '

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

+ WHERE topic_moved_id = 0

+ AND ' . $this->content_visibility->get_forums_visibility_sql('topic', $forum_ids) . '

+ 'p.post_id, p.topic_id, p.post_time, p.post_edit_time, p.post_visibility, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, ' .

+ AND ' . $this->content_visibility->get_visibility_sql('post', array(), 'p.') . '

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

+ $sql = 'SELECT f.forum_options, f.forum_password, t.topic_id, t.forum_id, t.topic_visibility, t.topic_title, t.topic_time, t.topic_views, t.topic_replies, t.topic_type

+ 'SELECT' => 'p.post_id, p.post_time, p.post_edit_time, p.post_visibility, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, ' .

+ AND ' . $this->content_visibility->get_visibility_sql('post', $this->forum_id, 'p.') . '

+ . ' ' . $this->separator_stats . ' ' . $this->user->lang['REPLIES'] . ' ' . $this->content_visibility->get_count('topic_posts', $row, $row['forum_id']) - 1

+ . (($this->is_moderator_approve_forum($row['forum_id']) && $row['topic_posts_unapproved']) ? ' ' . $this->separator_stats . ' ' . $this->user->lang['POSTS_UNAPPROVED'] : '');

+ AND topic_visibility = ' . ITEM_APPROVED . '

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

+ AND topic_visibility = ' . ITEM_APPROVED . '

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

+ global $db, $tracking_topics, $user, $config, $auth, $request, $phpbb_container;

+ $phpbb_content_visibility = $phpbb_container->get('content.visibility');

+ AND t.topic_moved_id = 0

+ AND ' . $phpbb_content_visibility->get_visibility_sql('topic', $forum_id, 't.') . '

+ AND t.topic_moved_id = 0

+ AND ' . $phpbb_content_visibility->get_visibility_sql('topic', $forum_id, 't.');

+ redirect($redirect);

+ 'T_ASSETS_VERSION' => $config['assets_version'],

+

+ $sql = 'SELECT topic_id, forum_id, topic_visibility, topic_moved_id

+ if ($row['topic_visibility'] == ITEM_APPROVED && !$row['topic_moved_id'])

+ $sql = 'SELECT post_id, poster_id, post_visibility, post_postcount, topic_id, forum_id

+ if ($row['post_postcount'] && $post_count_sync && $row['post_visibility'] == ITEM_APPROVED)

+ if ($row['post_visibility'] == ITEM_APPROVED)

+ if ($approved_posts && $post_count_sync)

+* - topic_visibility Resyncs the topic_visibility flag according to the status of the first post

+ if ($mode == 'forum' || $mode == 'topic' || $mode == 'topic_visibility' || $mode == 'topic_reported' || $mode == 'post_reported')

+ case 'topic_visibility':

+

+ $sql = 'SELECT t.topic_id, p.post_visibility

+ FROM ' . TOPICS_TABLE . ' t, ' . POSTS_TABLE . " p

+ $where_sql_and p.topic_id = t.topic_id

+ AND p.post_visibility = " . ITEM_APPROVED;

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

+

+ $topics_approved = array();

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

+ $topics_approved[] = (int) $row['topic_id'];

+ }

+ $db->sql_freeresult($result);

+ $sql = 'SELECT t.topic_id, p.post_visibility

+ FROM ' . TOPICS_TABLE . ' t, ' . POSTS_TABLE . " p

+ $where_sql_and " . $db->sql_in_set('t.topic_id', $topics_approved, true, true) . '

+ AND p.topic_id = t.topic_id

+ AND p.post_visibility = ' . ITEM_DELETED;

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

+ $topics_softdeleted = array();

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

+ {

+ $topics_softdeleted[] = (int) $row['topic_id'];

+ }

+ $db->sql_freeresult($result);

+ $topics_softdeleted = array_diff($topics_softdeleted, $topics_approved);

+ $topics_not_unapproved = array_merge($topics_softdeleted, $topics_approved);

+

+ $update_ary = array(

+ ITEM_UNAPPROVED => (!empty($topics_not_unapproved)) ? $where_sql_and . ' ' . $db->sql_in_set('topic_id', $topics_not_unapproved, true) : '',

+ ITEM_APPROVED => (!empty($topics_approved)) ? ' WHERE ' . $db->sql_in_set('topic_id', $topics_approved) : '',

+ ITEM_DELETED => (!empty($topics_softdeleted)) ? ' WHERE ' . $db->sql_in_set('topic_id', $topics_softdeleted) : '',

+ );

+ foreach ($topic_visiblities as $visibility => $sql_where)

+ {

+ if ($sql_where)

+ {

+ SET topic_visibility = ' . $visibility . '

+ ' . $sql_where;

+ }

+ $forum_data[$forum_id]['posts_approved'] = 0;

+ $forum_data[$forum_id]['posts_unapproved'] = 0;

+ $forum_data[$forum_id]['posts_softdeleted'] = 0;

+ $forum_data[$forum_id]['topics_approved'] = 0;

+ $forum_data[$forum_id]['topics_unapproved'] = 0;

+ $forum_data[$forum_id]['topics_softdeleted'] = 0;

+ $sql = 'SELECT forum_id, topic_visibility, COUNT(topic_id) AS total_topics

+ GROUP BY forum_id, topic_visibility';

+ if ($row['topic_visibility'] == ITEM_APPROVED)

+ $forum_data[$forum_id]['topics_approved'] = $row['total_topics'];

+ }

+ else if ($row['topic_visibility'] == ITEM_UNAPPROVED)

+ {

+ $forum_data[$forum_id]['topics_unapproved'] = $row['total_topics'];

+ }

+ else if ($row['topic_visibility'] == ITEM_DELETED)

+ {

+ $forum_data[$forum_id]['topics_softdeleted'] = $row['total_topics'];

+ $sql = 'SELECT SUM(t.topic_posts_approved) AS forum_posts_approved, SUM(t.topic_posts_unapproved) AS forum_posts_unapproved, SUM(t.topic_posts_softdeleted) AS forum_posts_softdeleted

+ $sql = 'SELECT t.forum_id, SUM(t.topic_posts_approved) AS forum_posts_approved, SUM(t.topic_posts_unapproved) AS forum_posts_unapproved, SUM(t.topic_posts_softdeleted) AS forum_posts_softdeleted

+ $forum_data[$forum_id]['posts_approved'] = (int) $row['forum_posts_approved'];

+ $forum_data[$forum_id]['posts_unapproved'] = (int) $row['forum_posts_unapproved'];

+ $forum_data[$forum_id]['posts_softdeleted'] = (int) $row['forum_posts_softdeleted'];

+ AND t.topic_visibility = ' . ITEM_APPROVED;

+ AND t.topic_visibility = ' . ITEM_APPROVED . '

+ array_push($fieldnames, 'posts_approved', 'posts_unapproved', 'posts_softdeleted', 'topics_approved', 'topics_unapproved', 'topics_softdeleted');

+ $topic_data = $post_ids = $resync_forums = $delete_topics = $delete_posts = $moved_topics = array();

+ $sql = 'SELECT t.topic_id, t.forum_id, t.topic_moved_id, t.topic_visibility, ' . (($sync_extra) ? 't.topic_attachment, t.topic_reported, ' : '') . 't.topic_poster, t.topic_time, t.topic_posts_approved, t.topic_posts_unapproved, t.topic_posts_softdeleted, t.topic_first_post_id, t.topic_first_poster_name, t.topic_first_poster_colour, t.topic_last_post_id, t.topic_last_post_subject, t.topic_last_poster_id, t.topic_last_poster_name, t.topic_last_poster_colour, t.topic_last_post_time

+ $topic_data[$topic_id]['visibility'] = ITEM_UNAPPROVED;

+ $topic_data[$topic_id]['posts_approved'] = 0;

+ $topic_data[$topic_id]['posts_unapproved'] = 0;

+ $topic_data[$topic_id]['posts_softdeleted'] = 0;

+ // NOTE: 't.post_visibility' in the GROUP BY is causing a major slowdown.

+ $sql = 'SELECT t.topic_id, t.post_visibility, COUNT(t.post_id) AS total_posts, MIN(t.post_id) AS first_post_id, MAX(t.post_id) AS last_post_id

+ GROUP BY t.topic_id, t.post_visibility";

+ if ($row['post_visibility'] == ITEM_APPROVED)

+ {

+ $topic_data[$topic_id]['posts_approved'] = $row['total_posts'];

+ }

+ else if ($row['post_visibility'] == ITEM_UNAPPROVED)

+ {

+ $topic_data[$topic_id]['posts_unapproved'] = $row['total_posts'];

+ }

+ else if ($row['post_visibility'] == ITEM_DELETED)

+ {

+ $topic_data[$topic_id]['posts_softdeleted'] = $row['total_posts'];

+ }

+ if ($row['post_visibility'] == ITEM_APPROVED)

+ $topic_data[$topic_id]['visibility'] = ITEM_APPROVED;

+ $topic_data[$topic_id]['first_post_id'] = $row['first_post_id'];

+ else if ($topic_data[$topic_id]['visibility'] != ITEM_APPROVED)

+ {

+ // If there is no approved post, we take the min/max of the other visibilities

+ // for the last and first post info, because it is only visible to moderators anyway

+ $topic_data[$topic_id]['first_post_id'] = (!empty($topic_data[$topic_id]['first_post_id'])) ? min($topic_data[$topic_id]['first_post_id'], $row['first_post_id']) : $row['first_post_id'];

+ $topic_data[$topic_id]['last_post_id'] = max($topic_data[$topic_id]['last_post_id'], $row['last_post_id']);

+

+ if ($topic_data[$topic_id]['visibility'] == ITEM_UNAPPROVED)

+ {

+ // Soft delete status is stronger than unapproved.

+ $topic_data[$topic_id]['visibility'] = $row['post_visibility'];

+ }

+ }

+ $sql = 'SELECT p.post_id, p.topic_id, p.post_visibility, p.poster_id, p.post_subject, p.post_username, p.post_time, u.username, u.user_colour

+ $sql = 'SELECT p.post_id, p.topic_id, p.post_visibility, p.poster_id, p.post_subject, p.post_username, p.post_time, u.username, u.user_colour

+ $fieldnames = array('time', 'visibility', 'posts_approved', 'posts_unapproved', 'posts_softdeleted', 'poster', 'first_post_id', 'first_poster_name', 'first_poster_colour', 'last_post_id', 'last_post_subject', 'last_post_time', 'last_poster_id', 'last_poster_name', 'last_poster_colour');

+* Get DB connection from config.php.

+*

+* Used to bootstrap the container.

+*

+* @param string $config_file

+* @return phpbb_db_driver

+*/

+function phpbb_bootstrap_db_connection($config_file)

+{

+ require($config_file);

+ $dbal_driver_class = phpbb_convert_30_dbms_to_31($dbms);

+

+ $db = new $dbal_driver_class();

+ $db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport, defined('PHPBB_DB_NEW_LINK'));

+

+ return $db;

+}

+

+/**

+* Get table prefix from config.php.

+*

+* Used to bootstrap the container.

+*

+* @param string $config_file

+* @return string table prefix

+*/

+function phpbb_bootstrap_table_prefix($config_file)

+{

+ require($config_file);

+ return $table_prefix;

+}

+

+/**

+* Get enabled extensions.

+*

+* Used to bootstrap the container.

+*

+* @param string $config_file

+* @param string $phpbb_root_path

+* @return array enabled extensions

+*/

+function phpbb_bootstrap_enabled_exts($config_file, $phpbb_root_path)

+{

+ $db = phpbb_bootstrap_db_connection($config_file);

+ $table_prefix = phpbb_bootstrap_table_prefix($config_file);

+ $extension_table = $table_prefix.'ext';

+

+ $sql = 'SELECT *

+ FROM ' . $extension_table . '

+ WHERE ext_active = 1';

+

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

+ $rows = $db->sql_fetchrowset($result);

+ $db->sql_freeresult($result);

+

+ $exts = array();

+ foreach ($rows as $row)

+ {

+ $exts[$row['ext_name']] = $phpbb_root_path . 'ext/' . $row['ext_name'] . '/';

+ }

+

+ return $exts;

+}

+

+/**

+function phpbb_create_compiled_container($config_file, array $extensions, array $passes, $phpbb_root_path, $php_ext)

+ $installed_exts = phpbb_bootstrap_enabled_exts($config_file, $phpbb_root_path);

+function phpbb_create_dumped_container($config_file, array $extensions, array $passes, $phpbb_root_path, $php_ext)

+ $container = phpbb_create_compiled_container($config_file, $extensions, $passes, $phpbb_root_path, $php_ext);

+function phpbb_create_dumped_container_unless_debug($config_file, array $extensions, array $passes, $phpbb_root_path, $php_ext)

+ return $container_factory($config_file, $extensions, $passes, $phpbb_root_path, $php_ext);

+ $config_file = $phpbb_root_path . 'config.' . $php_ext;

+ $config_file,

+ new phpbb_di_extension_config($config_file),

+ AND post_visibility = ' . ITEM_APPROVED . '

+ WHERE post_visibility = ' . ITEM_APPROVED;

+ WHERE topic_visibility = ' . ITEM_APPROVED;

+ global $request, $phpbb_dispatcher, $phpbb_container;

+ $phpbb_content_visibility = $phpbb_container->get('content.visibility');

+

+ // Lets check whether there are unapproved topics/posts, so we can display an information to moderators

+ $row['forum_id_unapproved_topics'] = ($auth->acl_get('m_approve', $forum_id) && $row['forum_topics_unapproved']) ? $forum_id : 0;

+ $row['forum_id_unapproved_posts'] = ($auth->acl_get('m_approve', $forum_id) && $row['forum_posts_unapproved']) ? $forum_id : 0;

+ $row['forum_posts'] = $phpbb_content_visibility->get_count('forum_posts', $row, $forum_id);

+ $row['forum_topics'] = $phpbb_content_visibility->get_count('forum_topics', $row, $forum_id);

+ if (!$forum_rows[$parent_id]['forum_id_unapproved_posts'] && $row['forum_id_unapproved_posts'])

+ {

+ $forum_rows[$parent_id]['forum_id_unapproved_posts'] = $forum_id;

+ }

+

+ 'U_UNAPPROVED_POSTS' => ($row['forum_id_unapproved_posts']) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&amp;mode=unapproved_posts&amp;f=' . $row['forum_id_unapproved_posts']) : '',

+ 'UNAPPROVED_POST_IMG' => $user->img('icon_topic_unapproved', 'POSTS_UNAPPROVED'),

+ ($user->data['is_registered'] && ($auth->acl_gets('f_delete', 'm_delete', $forum_id) || $auth->acl_gets('f_softdelete', 'm_softdelete', $forum_id)) && !$locked) ? $user->lang['RULES_DELETE_CAN'] : $user->lang['RULES_DELETE_CANNOT'],

+ global $phpbb_root_path, $phpEx, $phpbb_container;

+ $forum_read_ary = $auth->acl_getf('f_read');

+ foreach ($forum_read_ary as $forum_id => $allowed)

+ if ($allowed['f_read'])

+ $forum_ary = array_diff($forum_ary, $user->get_passworded_forums());

+ $active_f_row = $active_t_row = array();

+ if (!empty($forum_ary))

+ $phpbb_content_visibility = $phpbb_container->get('content.visibility');

+

+ // Obtain active forum

+ $sql = 'SELECT forum_id, COUNT(post_id) AS num_posts

+ FROM ' . POSTS_TABLE . '

+ WHERE poster_id = ' . $userdata['user_id'] . '

+ AND post_postcount = 1

+ AND ' . $phpbb_content_visibility->get_forums_visibility_sql('post', $forum_ary) . '

+ GROUP BY forum_id

+ ORDER BY num_posts DESC';

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

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

+ if (!empty($active_f_row))

+ {

+ $sql = 'SELECT forum_name

+ FROM ' . FORUMS_TABLE . '

+ WHERE forum_id = ' . $active_f_row['forum_id'];

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

+ $active_f_row['forum_name'] = (string) $db->sql_fetchfield('forum_name');

+ $db->sql_freeresult($result);

+ }

+ // Obtain active topic

+ $sql = 'SELECT topic_id, COUNT(post_id) AS num_posts

+ FROM ' . POSTS_TABLE . '

+ WHERE poster_id = ' . $userdata['user_id'] . '

+ AND post_postcount = 1

+ AND ' . $phpbb_content_visibility->get_forums_visibility_sql('post', $forum_ary) . '

+ GROUP BY topic_id

+ ORDER BY num_posts DESC';

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

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

+

+ if (!empty($active_t_row))

+ {

+ $sql = 'SELECT topic_title

+ FROM ' . TOPICS_TABLE . '

+ WHERE topic_id = ' . $active_t_row['topic_id'];

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

+ $active_t_row['topic_title'] = (string) $db->sql_fetchfield('topic_title');

+ $db->sql_freeresult($result);

+ }

+ // Apparently an error occurred...

+ /** @var phpbb_template */

+ protected $template;

+

+

+ *

+ $this->setup_template();

+

+ // $this->template->set_filenames will do a trigger_error

+ if ($template_path)

+ $template_paths = array(

+ $template_path,

+ );

+ }

+ else

+ {

+ $template_path = (!empty($user->lang_path)) ? $user->lang_path : $phpbb_root_path . 'language/';

+ $template_path .= $template_lang . '/email';

+ $template_paths = array(

+ $template_path,

+ );

+ // we can only specify default language fallback when the path is not a custom one for which we

+ // do not know the default language alternative

+ if ($template_lang !== basename($config['default_lang']))

+ $fallback_template_path = (!empty($user->lang_path)) ? $user->lang_path : $phpbb_root_path . 'language/';

+ $fallback_template_path .= basename($config['default_lang']) . '/email';

+ $template_paths[] = $fallback_template_path;

+ }

+ $this->set_template_paths($template_lang . '_email', $template_paths);

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

+ 'body' => $template_file . '.txt',

+ ));

+ $this->vars = $this->template->get_template_vars();

+ $this->setup_template();

+ $this->template->assign_vars($vars);

+ $this->setup_template();

+ $this->template->assign_block_vars($blockname, $vars);

+ $this->msg = trim($this->template->assign_display('body'));

+

+ /**

+ * Setup template engine

+ */

+ protected function setup_template()

+ {

+ global $config, $phpbb_root_path, $phpEx, $user, $phpbb_extension_manager;

+

+ if ($this->template instanceof phpbb_template)

+ {

+ return;

+ }

+

+ $this->template = new phpbb_template_twig($phpbb_root_path, $phpEx, $config, $user, new phpbb_template_context(), $phpbb_extension_manager);

+ }

+

+ /**

+ * Set template paths to load

+ */

+ protected function set_template_paths($path_name, $paths)

+ {

+ $this->setup_template();

+

+ $this->template->set_style_names(array($path_name), $paths);

+ }

+ global $phpbb_root_path, $phpbb_admin_path, $phpEx, $user, $phpbb_style;

+ /*

+ * If this is an extension module, we'll try to automatically set

+ * the style paths for the extension (the ext author can change them

+ * if necessary).

+ */

+ $module_dir = explode('_', get_class($this->module));

+

+ // 0 phpbb, 1 ext, 2 vendor, 3 extension name, ...

+ if (isset($module_dir[3]) && $module_dir[1] === 'ext')

+ {

+ $module_style_dir = $phpbb_root_path . 'ext/' . $module_dir[2] . '/' . $module_dir[3] . '/adm/style';

+

+ if (is_dir($module_style_dir))

+ {

+ $phpbb_style->set_custom_style('admin', array($module_style_dir, $phpbb_admin_path . 'style'), array(), '');

+ }

+ }

+

+ /*

+ * If this is an extension module, we'll try to automatically set

+ * the style paths for the extension (the ext author can change them

+ * if necessary).

+ */

+ $module_dir = explode('_', get_class($this->module));

+

+ // 0 phpbb, 1 ext, 2 vendor, 3 extension name, ...

+ if (isset($module_dir[3]) && $module_dir[1] === 'ext')

+ {

+ $module_style_dir = 'ext/' . $module_dir[2] . '/' . $module_dir[3] . '/styles';

+

+ if (is_dir($phpbb_root_path . $module_style_dir))

+ {

+ $phpbb_style->set_style(array($module_style_dir, 'styles'));

+ }

+ }

+

+ $topic_condition = 'AND t.topic_id = p.topic_id AND t.topic_visibility = ' . ITEM_APPROVED;

+ AND p.post_visibility = " . ITEM_APPROVED;

+ AND p.post_visibility = " . ITEM_APPROVED . "

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

+

+ $phpbb_content_visibility = $phpbb_container->get('content.visibility');

+ AND " . $phpbb_content_visibility->get_visibility_sql('post', $forum_id, 'p.') . '

+function delete_post($forum_id, $topic_id, $post_id, &$data, $is_soft = false, $softdelete_reason = '')

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

+ if (($data['topic_first_post_id'] === $data['topic_last_post_id']) && ($data['topic_posts_approved'] + $data['topic_posts_unapproved'] + $data['topic_posts_softdeleted'] == 1))

+ $phpbb_content_visibility = $phpbb_container->get('content.visibility');

+

+ // (Soft) delete the post

+ if ($is_soft && ($post_mode != 'delete_topic'))

+ {

+ $phpbb_content_visibility->set_post_visibility(ITEM_DELETED, $post_id, $topic_id, $forum_id, $user->data['user_id'], time(), $softdelete_reason, ($data['topic_first_post_id'] == $post_id), ($data['topic_last_post_id'] == $post_id));

+ }

+ else if (!$is_soft)

+ if (!delete_posts('post_id', array($post_id), false, false, false))

+ // Try to delete topic, we may had an previous error causing inconsistency

+ if ($post_mode == 'delete_topic')

+ {

+ delete_topics('topic_id', array($topic_id), false);

+ }

+ trigger_error('ALREADY_DELETED');

+ $sql_data[FORUMS_TABLE] = $sql_data[TOPICS_TABLE] = '';

+ $sql = 'UPDATE ' . FORUMS_TABLE . '

+ SET forum_topics_approved = forum_topics_approved - ' . $topic_count . '

+ WHERE forum_id = ' . $updated_forum;

+ $db->sql_query($sql);

+ if ($is_soft)

+ {

+ $topic_row = array();

+ $phpbb_content_visibility->set_topic_visibility(ITEM_DELETED, $topic_id, $forum_id, $user->data['user_id'], time(), $softdelete_reason);

+ }

+ else

+ {

+ delete_topics('topic_id', array($topic_id), false);

+ if ($data['topic_visibility'] == ITEM_APPROVED)

+ {

+ $sql_data[FORUMS_TABLE] .= 'forum_posts_approved = forum_posts_approved - 1, forum_topics_approved = forum_topics_approved - 1';

+ }

+ else if ($data['topic_visibility'] == ITEM_UNAPPROVED)

+ {

+ $sql_data[FORUMS_TABLE] .= 'forum_posts_unapproved = forum_posts_unapproved - 1, forum_topics_unapproved = forum_topics_unapproved - 1';

+ }

+ else if ($data['topic_visibility'] == ITEM_DELETED)

+ {

+ $sql_data[FORUMS_TABLE] .= 'forum_posts_softdeleted = forum_posts_softdeleted - 1, forum_topics_softdeleted = forum_topics_softdeleted - 1';

+ }

+ $update_sql = update_post_information('forum', $forum_id, true);

+ if (sizeof($update_sql))

+ {

+ $sql_data[FORUMS_TABLE] .= ($sql_data[FORUMS_TABLE]) ? ', ' : '';

+ $sql_data[FORUMS_TABLE] .= implode(', ', $update_sql[$forum_id]);

+ }

+

+ AND p.post_visibility = " . ITEM_APPROVED . '

+ ORDER BY p.post_time ASC';

+ if (!$row)

+ {

+ // No approved post, so the first is a not-approved post (unapproved or soft deleted)

+ $sql = 'SELECT p.post_id, p.poster_id, p.post_time, p.post_username, u.username, u.user_colour

+ FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . " u

+ WHERE p.topic_id = $topic_id

+ AND p.poster_id = u.user_id

+ ORDER BY p.post_time ASC";

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

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

+ $db->sql_freeresult($result);

+ }

+

+ $sql_data[TOPICS_TABLE] = $db->sql_build_array('UPDATE', array(

+ 'topic_poster' => (int) $row['poster_id'],

+ 'topic_first_post_id' => (int) $row['post_id'],

+ 'topic_first_poster_colour' => $row['user_colour'],

+ 'topic_first_poster_name' => ($row['poster_id'] == ANONYMOUS) ? $row['post_username'] : $row['username'],

+ 'topic_time' => (int) $row['post_time'],

+ ));

+ if (!$is_soft)

+ // Update last post information when hard deleting. Soft delete already did that by itself.

+ $update_sql = update_post_information('forum', $forum_id, true);

+ if (sizeof($update_sql))

+ {

+ $sql_data[FORUMS_TABLE] = (($sql_data[FORUMS_TABLE]) ? $sql_data[FORUMS_TABLE] . ', ' : '') . implode(', ', $update_sql[$forum_id]);

+ }

+ $sql_data[TOPICS_TABLE] = (($sql_data[TOPICS_TABLE]) ? $sql_data[TOPICS_TABLE] . ', ' : '') . 'topic_bumped = 0, topic_bumper = 0';

+ $update_sql = update_post_information('topic', $topic_id, true);

+ if (!empty($update_sql))

+ {

+ $sql_data[TOPICS_TABLE] .= ', ' . implode(', ', $update_sql[$topic_id]);

+ $next_post_id = (int) str_replace('topic_last_post_id = ', '', $update_sql[$topic_id][0]);

+ }

+

+ if (!$next_post_id)

+ WHERE topic_id = $topic_id

+ AND " . $phpbb_content_visibility->get_visibility_sql('post', $forum_id);

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

+ WHERE topic_id = $topic_id

+ AND " . $phpbb_content_visibility->get_visibility_sql('post', $forum_id) . '

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

+ if (!$is_soft)

+ {

+ if ($data['post_visibility'] == ITEM_APPROVED)

+ {

+ $phpbb_content_visibility->remove_post_from_statistic($data, $sql_data);

+ }

+ else if ($data['post_visibility'] == ITEM_UNAPPROVED)

+ {

+ $sql_data[FORUMS_TABLE] = (($sql_data[FORUMS_TABLE]) ? $sql_data[FORUMS_TABLE] . ', ' : '') . 'forum_posts_unapproved = forum_posts_unapproved - 1';

+ $sql_data[TOPICS_TABLE] = (($sql_data[TOPICS_TABLE]) ? $sql_data[TOPICS_TABLE] . ', ' : '') . 'topic_posts_unapproved = topic_posts_unapproved - 1';

+ }

+ else if ($data['post_visibility'] == ITEM_DELETED)

+ {

+ $sql_data[FORUMS_TABLE] = (($sql_data[FORUMS_TABLE]) ? $sql_data[FORUMS_TABLE] . ', ' : '') . 'forum_posts_softdeleted = forum_posts_softdeleted - 1';

+ $sql_data[TOPICS_TABLE] = (($sql_data[TOPICS_TABLE]) ? $sql_data[TOPICS_TABLE] . ', ' : '') . 'topic_posts_softdeleted = topic_posts_softdeleted - 1';

+ }

+ }

+

+ $sql_data[TOPICS_TABLE] = (($sql_data[TOPICS_TABLE]) ? $sql_data[TOPICS_TABLE] . ', ' : '') . 'topic_attachment = 0';

+ USERS_TABLE => 'user_id = ' . $data['poster_id'],

+ $post_mode = ($data['topic_posts_approved'] + $data['topic_posts_unapproved'] + $data['topic_posts_softdeleted'] == 1) ? 'edit_topic' : (($data['topic_first_post_id'] == $data['post_id']) ? 'edit_first_post' : (($data['topic_last_post_id'] == $data['post_id']) ? 'edit_last_post' : 'edit'));

+ if ($mode == 'edit' && (!isset($data['post_visibility']) || !isset($data['topic_visibility']) || $data['post_visibility'] === false || $data['topic_visibility'] === false))

+ $sql = 'SELECT p.post_visibility, t.topic_type, t.topic_posts_approved, t.topic_posts_unapproved, t.topic_posts_softdeleted, t.topic_visibility

+ $data['topic_visibility'] = $topic_row['topic_visibility'];

+ $data['post_visibility'] = $topic_row['post_visibility'];

+ // This variable indicates if the user is able to post or put into the queue

+ $post_visibility = ITEM_APPROVED;

+ $post_visibility = ITEM_UNAPPROVED;

+ // MODs/Extensions are able to force any visibility on posts

+ $post_visibility = (in_array((int) $data['force_approved_state'], array(ITEM_APPROVED, ITEM_UNAPPROVED, ITEM_DELETED))) ? (int) $data['force_approved_state'] : $post_visibility;

+ }

+ if (isset($data['force_visibility']))

+ {

+ $post_visibility = (in_array((int) $data['force_visibility'], array(ITEM_APPROVED, ITEM_UNAPPROVED, ITEM_DELETED))) ? (int) $data['force_visibility'] : $post_visibility;

+ 'post_visibility' => $post_visibility,

+ // We will change the visibility later

+ //'post_visibility' => $post_visibility,

+ 'topic_posts_approved' => ($post_visibility == ITEM_APPROVED) ? 1 : 0,

+ 'topic_posts_softdeleted' => ($post_visibility == ITEM_DELETED) ? 1 : 0,

+ 'topic_posts_unapproved' => ($post_visibility == ITEM_UNAPPROVED) ? 1 : 0,

+ 'topic_visibility' => $post_visibility,

+ 'topic_delete_user' => ($post_visibility != ITEM_APPROVED) ? (int) $user->data['user_id'] : 0,

+ $sql_data[USERS_TABLE]['stat'][] = "user_lastpost_time = $current_time" . (($auth->acl_get('f_postcount', $data['forum_id']) && $post_visibility == ITEM_APPROVED) ? ', user_posts = user_posts + 1' : '');

+ if ($post_visibility == ITEM_APPROVED)

+ $sql_data[FORUMS_TABLE]['stat'][] = 'forum_topics_approved = forum_topics_approved + 1';

+ $sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts_approved = forum_posts_approved + 1';

+ }

+ else if ($post_visibility == ITEM_UNAPPROVED)

+ {

+ $sql_data[FORUMS_TABLE]['stat'][] = 'forum_topics_unapproved = forum_topics_unapproved + 1';

+ $sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts_unapproved = forum_posts_unapproved + 1';

+ }

+ else if ($post_visibility == ITEM_DELETED)

+ {

+ $sql_data[FORUMS_TABLE]['stat'][] = 'forum_topics_softdeleted = forum_topics_softdeleted + 1';

+ $sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts_softdeleted = forum_posts_softdeleted + 1';

+ (($post_visibility == ITEM_APPROVED) ? ', topic_posts_approved = topic_posts_approved + 1' : '') .

+ (($post_visibility == ITEM_UNAPPROVED) ? ', topic_posts_unapproved = topic_posts_unapproved + 1' : '') .

+ (($post_visibility == ITEM_DELETED) ? ', topic_posts_softdeleted = topic_posts_softdeleted + 1' : '') .

+ $sql_data[USERS_TABLE]['stat'][] = "user_lastpost_time = $current_time" . (($auth->acl_get('f_postcount', $data['forum_id']) && $post_visibility == ITEM_APPROVED) ? ', user_posts = user_posts + 1' : '');

+ if ($post_visibility == ITEM_APPROVED)

+ {

+ $sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts_approved = forum_posts_approved + 1';

+ }

+ else if ($post_visibility == ITEM_UNAPPROVED)

+ $sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts_unapproved = forum_posts_unapproved + 1';

+ }

+ else if ($post_visibility == ITEM_DELETED)

+ {

+ $sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts_softdeleted = forum_posts_softdeleted + 1';