+/phpBB/cache/*.lock

+ - 5.3.3

+ - 5.5

+matrix:

+ allow_failures:

+ - php: 5.5

+

+ - sh -c "if [ '$DB' = 'postgres' ]; then psql -c 'DROP DATABASE IF EXISTS phpbb_tests;' -U postgres; fi"

+ - sh -c "if [ '$DB' = 'postgres' ]; then psql -c 'create database phpbb_tests;' -U postgres; fi"

+ - sh -c "if [ '$TRAVIS_PHP_VERSION' != '5.2' ]; then pyrus set auto_discover 1; fi"

+ - cd phpBB

+ - sh -c "if [ '$TRAVIS_PHP_VERSION' != '5.2' ]; then php ../composer.phar install --dev; fi"

+ - cd ..

+[](http://www.phpbb.com)

+ <property name="newversion" value="3.0.12-dev" />

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

+ <property name="olderversions" value="3.0.2, 3.0.3, 3.0.4, 3.0.5, 3.0.6, 3.0.7, 3.0.7-PL1, 3.0.8, 3.0.9, 3.0.10" />

+ <target name="all" depends="clean,prepare,composer,test,docs,package" />

+ <target name="build" depends="clean,prepare,composer,test,docs" />

+ <!--

+ This target basically just runs composer in the phpBB tree to ensure

+ all dependencies are loaded. Additional development dependencies are

+ loaded because testing framework may depend on them.

+ -->

+ <target name="composer">

+ <exec dir="phpBB"

+ command="php ../composer.phar install --dev"

+ checkreturn="true"

+ passthru="true" />

+ </target>

+

+ <target name="test" depends="clean,prepare,composer">

+ <target name="test-slow" depends="clean,prepare,composer">

+ <target name="package" depends="clean,prepare,prepare-new-version,old-version-diffs">

+

+ <!--

+ If composer.phar exists in this version of the tree, also export

+ it into ${dir}, install dependencies, then delete it again.

+ -->

+ <exec dir="."

+ command="git ls-tree ${revision} composer.phar"

+ checkreturn="true"

+ outputProperty='composer-ls-tree-output' />

+ <if>

+ <not><equals arg1="${composer-ls-tree-output}" arg2="" trim="true" /></not>

+ <then>

+ <exec dir="."

+ command="git archive ${revision} composer.phar | tar -xf - -C ${dir}"

+ checkreturn="true" />

+ <exec dir="${dir}"

+ command="php composer.phar install"

+ checkreturn="true"

+ passthru="true" />

+ <delete file="${dir}/composer.phar" />

+ </then>

+ </if>

+

+ <delete dir="${dir}/vendor" />

+ 'CREDIT_LINE' => $user->lang('POWERED_BY', '<a href="https://www.phpbb.com/">phpBB</a>&reg; Forum Software &copy; phpBB Group'),

+ <dt><label for="field_show_novalue">{L_SHOW_NOVALUE_FIELD}:</label><br /><span>{L_SHOW_NOVALUE_FIELD_EXPLAIN}</span></dt>

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

+ </dl>

+ <dl>

+ <form id="user_delete" method="post" action="{U_ACTION}">

+ <fieldset>

+ <legend>{L_DELETE_USER}</legend>

+ <dl>

+ <dt><label for="delete_type">{L_DELETE_USER}:</label><br /><span>{L_DELETE_USER_EXPLAIN}</span></dt>

+ <dd>

+ <!-- IF USER_HAS_POSTS -->

+ <select id="delete_type" name="delete_type"><option class="sep" value="">{L_SELECT_OPTION}</option><option value="retain">{L_RETAIN_POSTS}</option><option value="remove">{L_DELETE_POSTS}</option></select>

+ <!-- ELSE -->

+ {L_USER_NO_POSTS_TO_DELETE}<input type="hidden" id="delete_type" name="delete_type" value="retain" />

+ <!-- ENDIF -->

+ </dd>

+ </dl>

+ <p class="quick">

+ <input class="button1" type="submit" name="update" value="{L_SUBMIT}" />

+ <input type="hidden" name="delete" value="1" />

+ {S_FORM_TOKEN}

+ </p>

+ </fieldset>

+ </form>

+ background: url("../images/phpbb_logo.png") top left no-repeat;

+ height: 54px;

+ background: url("../images/phpbb_logo.png") top right no-repeat;

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

+ var block = document.getElementById('diff_content');

+ height = window.innerHeight - 200;

+ background: transparent;

+ border-right: 1px solid #999;

+ background: #D9D9D9;

+table.hrdiff tbody td {

+ font-family: "Consolas", monospace;

+ font-size: 1.1em;

+ white-space: pre-wrap; /* css-3 */

+ word-wrap: break-word; /* Internet Explorer 5.5+ */

+ background: transparent;

+ require($phpbb_root_path . 'includes/functions.' . $phpEx);

+

+ // $phpbb_root_path accounts for redirects from e.g. /adm

+ $script_path = trim(dirname($script_name)) . '/' . $phpbb_root_path . 'install/index.' . $phpEx;

+ // Eliminate . and .. from the path

+ $script_path = phpbb_clean_path($script_path);

+{

+ "minimum-stability": "beta",

+ "require-dev": {

+ "fabpot/goutte": "v0.1.0"

+ }

+}

+{

+ "hash": "23352b29002e6d22658e314a8e737f71",

+ "packages": [

+ {

+ "name": "symfony/event-dispatcher",

+ "version": "v2.1.4",

+ "target-dir": "Symfony/Component/EventDispatcher",

+ "source": {

+ "type": "git",

+ "url": "https://github.com/symfony/EventDispatcher",

+ "reference": "v2.1.4"

+ },

+ "dist": {

+ "type": "zip",

+ "url": "https://github.com/symfony/EventDispatcher/archive/v2.1.4.zip",

+ "reference": "v2.1.4",

+ "shasum": ""

+ },

+ "require": {

+ "php": ">=5.3.3"

+ },

+ "require-dev": {

+ "symfony/dependency-injection": "2.1.*"

+ },

+ "suggest": {

+ "symfony/dependency-injection": "2.1.*",

+ "symfony/http-kernel": "2.1.*"

+ },

+ "time": "2012-11-08 09:51:48",

+ "type": "library",

+ "extra": {

+ "branch-alias": {

+ "dev-master": "2.1-dev"

+ }

+ },

+ "installation-source": "dist",

+ "autoload": {

+ "psr-0": {

+ "Symfony\\Component\\EventDispatcher": ""

+ }

+ },

+ "license": [

+ "MIT"

+ ],

+ "authors": [

+ {

+ "name": "Fabien Potencier",

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

+ },

+ {

+ "name": "Symfony Community",

+ "homepage": "http://symfony.com/contributors"

+ }

+ ],

+ "description": "Symfony EventDispatcher Component",

+ "homepage": "http://symfony.com"

+ }

+ ],

+ "packages-dev": [

+ {

+ "name": "fabpot/goutte",

+ "version": "v0.1.0",

+ "source": {

+ "type": "git",

+ "url": "https://github.com/fabpot/Goutte",

+ "reference": "v0.1.0"

+ },

+ "dist": {

+ "type": "zip",

+ "url": "https://github.com/fabpot/Goutte/archive/v0.1.0.zip",

+ "reference": "v0.1.0",

+ "shasum": ""

+ },

+ "require": {

+ "php": ">=5.3.0",

+ "ext-curl": "*",

+ "symfony/browser-kit": "2.1.*",

+ "symfony/css-selector": "2.1.*",

+ "symfony/dom-crawler": "2.1.*",

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

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

+ "guzzle/guzzle": "3.0.*"

+ },

+ "time": "2012-12-02 13:44:35",

+ "type": "application",

+ "extra": {

+ "branch-alias": {

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

+ }

+ },

+ "installation-source": "source",

+ "autoload": {

+ "psr-0": {

+ "Goutte": "."

+ }

+ },

+ "license": [

+ "MIT"

+ ],

+ "authors": [

+ {

+ "name": "Fabien Potencier",

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

+ }

+ ],

+ "description": "A simple PHP Web Scraper",

+ "homepage": "https://github.com/fabpot/Goutte",

+ "keywords": [

+ "scraper"

+ ]

+ },

+ {

+ "name": "guzzle/guzzle",

+ "version": "v3.0.5",

+ "source": {

+ "type": "git",

+ "url": "https://github.com/guzzle/guzzle",

+ "reference": "v3.0.5"

+ },

+ "dist": {

+ "type": "zip",

+ "url": "https://github.com/guzzle/guzzle/archive/v3.0.5.zip",

+ "reference": "v3.0.5",

+ "shasum": ""

+ },

+ "require": {

+ "php": ">=5.3.2",

+ "ext-curl": "*",

+ "symfony/event-dispatcher": "2.1.*"

+ },

+ "replace": {

+ "guzzle/batch": "self.version",

+ "guzzle/cache": "self.version",

+ "guzzle/common": "self.version",

+ "guzzle/http": "self.version",

+ "guzzle/inflection": "self.version",

+ "guzzle/iterator": "self.version",

+ "guzzle/log": "self.version",

+ "guzzle/parser": "self.version",

+ "guzzle/plugin": "self.version",

+ "guzzle/plugin-async": "self.version",

+ "guzzle/plugin-backoff": "self.version",

+ "guzzle/plugin-cache": "self.version",

+ "guzzle/plugin-cookie": "self.version",

+ "guzzle/plugin-curlauth": "self.version",

+ "guzzle/plugin-history": "self.version",

+ "guzzle/plugin-log": "self.version",

+ "guzzle/plugin-md5": "self.version",

+ "guzzle/plugin-mock": "self.version",

+ "guzzle/plugin-oauth": "self.version",

+ "guzzle/service": "self.version",

+ "guzzle/stream": "self.version"

+ },

+ "require-dev": {

+ "doctrine/common": "*",

+ "symfony/class-loader": "*",

+ "monolog/monolog": "1.*",

+ "zendframework/zend-cache": "2.0.*",

+ "zendframework/zend-log": "2.0.*",

+ "zend/zend-log1": "1.12",

+ "zend/zend-cache1": "1.12",

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

+ },

+ "time": "2012-11-19 00:15:33",

+ "type": "library",

+ "installation-source": "dist",

+ "autoload": {

+ "psr-0": {

+ "Guzzle\\Tests": "tests/",

+ "Guzzle": "src/"

+ }

+ },

+ "license": [

+ "MIT"

+ ],

+ "authors": [

+ {

+ "name": "Michael Dowling",

+ "email": "mtdowling@gmail.com",

+ "homepage": "https://github.com/mtdowling"

+ },

+ {

+ "name": "Guzzle Community",

+ "homepage": "https://github.com/guzzle/guzzle/contributors"

+ }

+ ],

+ "description": "Guzzle is a PHP HTTP client library and framework for building RESTful web service clients",

+ "homepage": "http://guzzlephp.org/",

+ "keywords": [

+ "framework",

+ "curl",

+ "http",

+ "rest",

+ "http client",

+ "client",

+ "web service"

+ ]

+ },

+ {

+ "name": "symfony/browser-kit",

+ "version": "v2.1.4",

+ "target-dir": "Symfony/Component/BrowserKit",

+ "source": {

+ "type": "git",

+ "url": "https://github.com/symfony/BrowserKit",

+ "reference": "v2.1.4"

+ },

+ "dist": {

+ "type": "zip",

+ "url": "https://github.com/symfony/BrowserKit/archive/v2.1.4.zip",

+ "reference": "v2.1.4",

+ "shasum": ""

+ },

+ "require": {

+ "php": ">=5.3.3",

+ "symfony/dom-crawler": "2.1.*"

+ },

+ "require-dev": {

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

+ "symfony/css-selector": "2.1.*"

+ },

+ "suggest": {

+ "symfony/process": "2.1.*"

+ },

+ "time": "2012-11-08 09:51:48",

+ "type": "library",

+ "extra": {

+ "branch-alias": {

+ "dev-master": "2.1-dev"

+ }

+ },

+ "installation-source": "dist",

+ "autoload": {

+ "psr-0": {

+ "Symfony\\Component\\BrowserKit": ""

+ }

+ },

+ "license": [

+ "MIT"

+ ],

+ "authors": [

+ {

+ "name": "Fabien Potencier",

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

+ },

+ {

+ "name": "Symfony Community",

+ "homepage": "http://symfony.com/contributors"

+ }

+ ],

+ "description": "Symfony BrowserKit Component",

+ "homepage": "http://symfony.com"

+ },

+ {

+ "name": "symfony/css-selector",

+ "version": "v2.1.4",

+ "target-dir": "Symfony/Component/CssSelector",

+ "source": {

+ "type": "git",

+ "url": "https://github.com/symfony/CssSelector",

+ "reference": "v2.1.4"

+ },

+ "dist": {

+ "type": "zip",

+ "url": "https://github.com/symfony/CssSelector/archive/v2.1.4.zip",

+ "reference": "v2.1.4",

+ "shasum": ""

+ },

+ "require": {

+ "php": ">=5.3.3"

+ },

+ "time": "2012-11-08 09:51:48",

+ "type": "library",

+ "extra": {

+ "branch-alias": {

+ "dev-master": "2.1-dev"

+ }

+ },

+ "installation-source": "dist",

+ "autoload": {

+ "psr-0": {

+ "Symfony\\Component\\CssSelector": ""

+ }

+ },

+ "license": [

+ "MIT"

+ ],

+ "authors": [

+ {

+ "name": "Fabien Potencier",

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

+ },

+ {

+ "name": "Symfony Community",

+ "homepage": "http://symfony.com/contributors"

+ }

+ ],

+ "description": "Symfony CssSelector Component",

+ "homepage": "http://symfony.com"

+ },

+ {

+ "name": "symfony/dom-crawler",

+ "version": "v2.1.4",

+ "target-dir": "Symfony/Component/DomCrawler",

+ "source": {

+ "type": "git",

+ "url": "https://github.com/symfony/DomCrawler",

+ "reference": "v2.1.4"

+ },

+ "dist": {

+ "type": "zip",

+ "url": "https://github.com/symfony/DomCrawler/archive/v2.1.4.zip",

+ "reference": "v2.1.4",

+ "shasum": ""

+ },

+ "require": {

+ "php": ">=5.3.3"

+ },

+ "require-dev": {

+ "symfony/css-selector": "2.1.*"

+ },

+ "suggest": {

+ "symfony/css-selector": "2.1.*"

+ },

+ "time": "2012-11-29 10:32:18",

+ "type": "library",

+ "extra": {

+ "branch-alias": {

+ "dev-master": "2.1-dev"

+ }

+ },

+ "installation-source": "dist",

+ "autoload": {

+ "psr-0": {

+ "Symfony\\Component\\DomCrawler": ""

+ }

+ },

+ "license": [

+ "MIT"

+ ],

+ "authors": [

+ {

+ "name": "Fabien Potencier",

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

+ },

+ {

+ "name": "Symfony Community",

+ "homepage": "http://symfony.com/contributors"

+ }

+ ],

+ "description": "Symfony DomCrawler Component",

+ "homepage": "http://symfony.com"

+ },

+ {

+ "name": "symfony/finder",

+ "version": "v2.1.4",

+ "target-dir": "Symfony/Component/Finder",

+ "source": {

+ "type": "git",

+ "url": "https://github.com/symfony/Finder",

+ "reference": "v2.1.4"

+ },

+ "dist": {

+ "type": "zip",

+ "url": "https://github.com/symfony/Finder/archive/v2.1.4.zip",

+ "reference": "v2.1.4",

+ "shasum": ""

+ },

+ "require": {

+ "php": ">=5.3.3"

+ },

+ "time": "2012-11-08 09:51:48",

+ "type": "library",

+ "extra": {

+ "branch-alias": {

+ "dev-master": "2.1-dev"

+ }

+ },

+ "installation-source": "dist",

+ "autoload": {

+ "psr-0": {

+ "Symfony\\Component\\Finder": ""

+ }

+ },

+ "license": [

+ "MIT"

+ ],

+ "authors": [

+ {

+ "name": "Fabien Potencier",

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

+ },

+ {

+ "name": "Symfony Community",

+ "homepage": "http://symfony.com/contributors"

+ }

+ ],

+ "description": "Symfony Finder Component",

+ "homepage": "http://symfony.com"

+ },

+ {

+ "name": "symfony/process",

+ "version": "v2.1.4",

+ "target-dir": "Symfony/Component/Process",

+ "source": {

+ "type": "git",

+ "url": "https://github.com/symfony/Process",

+ "reference": "v2.1.4"

+ },

+ "dist": {

+ "type": "zip",

+ "url": "https://github.com/symfony/Process/archive/v2.1.4.zip",

+ "reference": "v2.1.4",

+ "shasum": ""

+ },

+ "require": {

+ "php": ">=5.3.3"

+ },

+ "time": "2012-11-19 20:53:52",

+ "type": "library",

+ "extra": {

+ "branch-alias": {

+ "dev-master": "2.1-dev"

+ }

+ },

+ "installation-source": "dist",

+ "autoload": {

+ "psr-0": {

+ "Symfony\\Component\\Process": ""

+ }

+ },

+ "license": [

+ "MIT"

+ ],

+ "authors": [

+ {

+ "name": "Fabien Potencier",

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

+ },

+ {

+ "name": "Symfony Community",

+ "homepage": "http://symfony.com/contributors"

+ }

+ ],

+ "description": "Symfony Process Component",

+ "homepage": "http://symfony.com"

+ }

+ ],

+ "aliases": [

+

+ ],

+ "minimum-stability": "beta",

+ "stability-flags": [

+

+ ]

+}

+/**

+*

+* @package phpBB3

+* @copyright (c) 2004 phpBB Group

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

+*

+*/

+/**

+*

+* @package phpBB3

+* @copyright (c) 2004 phpBB Group

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

+*

+*/

+/**

+*

+* @package phpBB3

+* @copyright (c) 2003 phpBB Group

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

+*

+*/

+*

+ $fp = fopen($schema_path . $dbms . '_schema.sql', 'wb');

+ 'field_show_novalue' => array('BOOL', 0),

+/**

+*

+* @package phpBB3

+* @copyright (c) 2003 phpBB Group

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

+*

+* This script generates an index of some template vars and their use within the templates.

+* It writes down all language variables used by various templates.

+*

+/**

+*

+* @package phpBB3

+* @copyright (c) 2001, 2003 phpBB Group

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

+*

+*/

+

+* @return null

+* @return null

+* @return null

+/**

+*

+* @package phpBB3

+* @copyright (c) 2001, 2003 phpBB Group

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

+*

+*/

+/**

+*

+* @package phpBB3

+* @copyright (c) 2003 phpBB Group

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

+*

+*/

+* @return null

+phpBB Developers: bantu (Andreas Fischer)

+ imkingdavid (David King)

+phpBB Project Manager: theFinn (James Atkinson) [Founder - 04/2007]

+phpBB Lead Developer: Acyd Burn (Meik Sievertsen) [09/2005 - 01/2010]

+ psoTFX (Paul S. Owen) [2001 - 09/2005]

+ Acyd Burn (Meik Sievertsen) [02/2003 - 09/2005]

+ Arty (Vjacheslav Trushkin) [02/2012 - 07/2012]

+ ToonArmy (Chris Smith) [06/2008 - 11/2011]

+ <li><a href="#v3010">Changes since 3.0.10</a></li>

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

+

+<h4>Bug</h4>

+<ul>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-7432">PHPBB3-7432</a>] - Unclear language for Inactive Users on ACP main page</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-8652">PHPBB3-8652</a>] - Duplicate Emails Sent When Subscribed to Forum and Topic</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-9079">PHPBB3-9079</a>] - Display backtrace on all E_USER_ERROR errors, not only SQL errors (when DEBUG_EXTRA is enabled)</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-9084">PHPBB3-9084</a>] - Unable to display 'option equal to non entered value' if dropdown CPF is not required</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-9089">PHPBB3-9089</a>] - PM message title box not accessible via Tab key</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-9220">PHPBB3-9220</a>] - Blue border width when table in a div</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-9681">PHPBB3-9681</a>] - Password length not in security settings</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-9813">PHPBB3-9813</a>] - fulltext_native.php on innodb loading deadly slow for big indexes</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-9831">PHPBB3-9831</a>] - Cannot change default of Boolean checkbox custom profile field</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10094">PHPBB3-10094</a>] - Clear cache before phpBB installation</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10129">PHPBB3-10129</a>] - Missing apostrophes in ACP user management -&gt; permissions</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10349">PHPBB3-10349</a>] - Unit tests do not remove comments from schemas</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10399">PHPBB3-10399</a>] - Special characters aren't parsed in style component variables</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10401">PHPBB3-10401</a>] - auth_ldap has an incorrect return value in login_ldap()</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10407">PHPBB3-10407</a>] - Incorrect check for empty image file paths during conversion</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10428">PHPBB3-10428</a>] - optionget/optionset functions in session.php and acp_users.php incorrectly check whether $data is at its default value</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10456">PHPBB3-10456</a>] - Subsilver2 does not define $CAPTCHA_TAB_INDEX</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10508">PHPBB3-10508</a>] - Marking forums as read displays misleading language</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10511">PHPBB3-10511</a>] - Grammar defect in permissions language</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10512">PHPBB3-10512</a>] - Test failure when no default timezone is set in php</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10532">PHPBB3-10532</a>] - Out of range $start causes a page with no search results but with pagination</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10538">PHPBB3-10538</a>] - Special character are not correctly parsed for SMTP protocol</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10542">PHPBB3-10542</a>] - Incorrect class=&quot;postlink&quot; in styles/subsilver2/template/faq_body.html</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10546">PHPBB3-10546</a>] - Argument missing for adm_back_link() in acp_captcha.php</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10561">PHPBB3-10561</a>] - All users can choose deactivated styles.</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10569">PHPBB3-10569</a>] - template/ucp_main_front.html does not correctly handle active topic with the name &quot;0&quot;</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10580">PHPBB3-10580</a>] - Default tz in registration dropdown not the same as the board default tz</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10589">PHPBB3-10589</a>] - user_birthday does not use table alias in $leap_year_birthdays variable definition</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10605">PHPBB3-10605</a>] - Orpahned privmsgs are left in the prvmsgs table, with no ties in privmsgs_to table</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10606">PHPBB3-10606</a>] - $s_hidden_fields -&gt; incorrect array name (3 files affected)</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10611">PHPBB3-10611</a>] - Add a check for selected tables existence for ACP database backup tool</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10615">PHPBB3-10615</a>] - Static calls in utf normalizer yield E_STRICT spam on php 5.4</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10630">PHPBB3-10630</a>] - Prune Users produced unnecessarily long query; Got a packet bigger than 'max_allowed_packet' bytes</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10633">PHPBB3-10633</a>] - Users are able to get the real filename of attachment</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10639">PHPBB3-10639</a>] - negative value of ranks message</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10658">PHPBB3-10658</a>] - Rank-item is not shown on team-list</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10675">PHPBB3-10675</a>] - Use more descriptive message when disk is out of space</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10684">PHPBB3-10684</a>] - Function user_notification() prevents notifications for users with stale bans</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10689">PHPBB3-10689</a>] - Bug in the popup &quot; Find a member&quot; when select by letter.</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10691">PHPBB3-10691</a>] - Search index creation CLI script incorrectly calculates indexing speed</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10699">PHPBB3-10699</a>] - Long h2 title breaks div.minitabs in MCP</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10708">PHPBB3-10708</a>] - After a conversion, passwords with UTF8 characters do not work when user_pass_convert is set.</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10717">PHPBB3-10717</a>] - memberlist_view.html: including admin defined profile fields doesnt work</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10723">PHPBB3-10723</a>] - Do not use SQLite on PHP 5.4 in Tests on Travis</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10731">PHPBB3-10731</a>] - JS function addquote() works incorrectly in Opera</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10751">PHPBB3-10751</a>] - MS SQL Error when searching Admin Log</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10760">PHPBB3-10760</a>] - In pre-commit git hook, syntax error is thrown, but is not specifically described</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10767">PHPBB3-10767</a>] - Git hooks do not work properly with git GUIs</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10774">PHPBB3-10774</a>] - db_tools::create_unique_index does not use specified index names on MySQL</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10790">PHPBB3-10790</a>] - Strict comparison on user_id for sending pms</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10797">PHPBB3-10797</a>] - Template var for user rank not filled</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10835">PHPBB3-10835</a>] - Misleading message in UCP when no permission to change password</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10846">PHPBB3-10846</a>] - Missing alias for MAX(post_id) in SQL query in acp_main.php</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10849">PHPBB3-10849</a>] - Missing BBCode Help Text in subsilver2</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10858">PHPBB3-10858</a>] - $db-&gt;sql_fetchfield returns false with mssqlnative</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10860">PHPBB3-10860</a>] - Side-by-side diff styling javascript bug</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10881">PHPBB3-10881</a>] - Some files use 0xA9 as the copyright symbol which is neither ASCII nor the UTF8 copyright symbol.</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10887">PHPBB3-10887</a>] - Auto increment tests depend on varbinary handling</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10889">PHPBB3-10889</a>] - Default value for c_char_size in database unit tests is an empty string instead of a char(4)</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10890">PHPBB3-10890</a>] - test_sql_fetchrow_returns_false_when_empty() fails on MSSQL and Oracle</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10908">PHPBB3-10908</a>] - No remote avatar size limit results in files limited only by PHP memory limit</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10913">PHPBB3-10913</a>] - Admin is logged out when accessing any url under adm/ without session id</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10441">PHPBB3-10441</a>] - Update to docs/README.html</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10773">PHPBB3-10773</a>] - ACP phpBB logo needs registered trademark symbol</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10935">PHPBB3-10935</a>] - Limit number of PM rules per user</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10937">PHPBB3-10937</a>] - Comment removal functions: Backward compatibility broken</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10950">PHPBB3-10950</a>] - Deleting user with undelivered PMs causes SQL error</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10952">PHPBB3-10952</a>] - includes/constants.php version number incorrect</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10965">PHPBB3-10965</a>] - Dropdown CPF now shows in profile when no value is selected</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10978">PHPBB3-10978</a>] - Typo in prosilvers ucp_groups_membership.html</li>

+</ul>

+<h4>Improvement</h4>

+<ul>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-8599">PHPBB3-8599</a>] - Add &quot;Select All&quot; to &quot;Add multiple smilies&quot; screen</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-8636">PHPBB3-8636</a>] - Add resync option to topic_view moderation page</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-9876">PHPBB3-9876</a>] - Names and descriptions for roles &quot;Newly registered User&quot; in &quot;User roles&quot; and &quot;Forum roles&quot; must be different</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-9914">PHPBB3-9914</a>] - Add backup warning to Automatic DB Updater</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-9916">PHPBB3-9916</a>] - License in header not linking to version 2 of GNU GPL</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10093">PHPBB3-10093</a>] - Make commit-msg hook always not fatal</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10162">PHPBB3-10162</a>] - Allow TLDs over 6 characters in email addresses</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10280">PHPBB3-10280</a>] - Change the ACP user activation display</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10308">PHPBB3-10308</a>] - Disable Retain/Delete Posts selection if the user has no posts.</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10453">PHPBB3-10453</a>] - PM viewmessage page is misplacing the online icon</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10492">PHPBB3-10492</a>] - Port functional tests to develop-olympus</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10507">PHPBB3-10507</a>] - Sort installed styles list in admin control panel - styles</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10550">PHPBB3-10550</a>] - Sort not installed styles list in admin control panel - styles</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10563">PHPBB3-10563</a>] - ACP usability improvement: show deactivated styles below active styles in styles list</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10565">PHPBB3-10565</a>] - Performance: Unneeded GROUP BY in update_forum_tracking_info</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10607">PHPBB3-10607</a>] - phpBB Credit Line Hardcoded</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10653">PHPBB3-10653</a>] - Add ability to count table rows to database abstraction layer</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10730">PHPBB3-10730</a>] - Add label tags around &quot;select&quot; text in post splitting UI in MCP</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10764">PHPBB3-10764</a>] - FAQ mentions SourceForge</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10812">PHPBB3-10812</a>] - Installer should not display register globals UI for php 5.4+</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10815">PHPBB3-10815</a>] - Enable Feeds by default</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10819">PHPBB3-10819</a>] - Improve side-by-side diff styling</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10834">PHPBB3-10834</a>] - Backport general development language changes in readme files</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10836">PHPBB3-10836</a>] - Enable Avatars by default</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10891">PHPBB3-10891</a>] - Allow specifying test config file name via environment variable</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10892">PHPBB3-10892</a>] - Cosmetic improvements to RUNNING_TESTS.txt</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10898">PHPBB3-10898</a>] - Do not write ?&gt; into config.php to avoid whitespace output</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10925">PHPBB3-10925</a>] - Clarify that SQLite3 is not supported for phpBB 3.0.x</li>

+</ul>

+<h4>New Feature</h4>

+<ul>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10616">PHPBB3-10616</a>] - Add template inheritance by default</li>

+</ul>

+<h4>Sub-task</h4>

+<ul>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10907">PHPBB3-10907</a>] - Mark (var)binary tests as incomplete on non-MySQL DBMSes</li>

+</ul>

+<h4>Task</h4>

+<ul>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-9896">PHPBB3-9896</a>] - Update links in docs/readme.html</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10434">PHPBB3-10434</a>] - Add a script that allows creating a search index from CLI</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10455">PHPBB3-10455</a>] - Remove NOTE from header files</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10694">PHPBB3-10694</a>] - Update notification in ACP (Olympus) for increase of minimum PHP version to 5.3.2</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10718">PHPBB3-10718</a>] - Add Travis CI</li>

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

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

+</ul>

+

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

+ <li><a href="#update_files">Changed files</a></li>

+ <li><a href="#anti_spam">Anti-Spam Measures</a></li>

+ <li>Point your web browser to the location where you uploaded the phpBB3 files with the addition of <code>install/index.php</code> or simply <code>install/</code>, e.g. <code>http://www.example.com/phpBB3/install/index.php</code>, <code>http://www.example.com/forum/install/</code>.</li>

+ <li>Click the <strong><em>INSTALL</em></strong> tab, follow the steps and fill out all the requested information.</li>

+ <li>phpBB3 should now be available, please <strong>MAKE SURE</strong> you read at least <a href="#postinstall">Section 6</a> below for important, security related post-installation instructions, and also take note of <a href="#anti_spam">Section 7</a> regarding anti-spam measures.</li>

+ <p>phpBB 3.0.x has a few requirements which must be met before you are able to install and use it.</p>

+ <li>SQLite 2.8.2+ (SQLite 3 is not supported)</li>

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

+ <li><strong>PHP (>=4.3.3, >=4.4.0, >=5.0.0)</strong> with support for the database you intend to use.</li>

+ <li>getimagesize() function must be enabled.</li>

+ <li>Presence of the following modules within PHP will provide access to additional features, but they are not required:

+ <p>If your server or hosting account does not meet the requirements above then you will be unable to install phpBB 3.0.x.</p>

+ <p>If you do not have shell access or do not wish to use it, you will need to decompress the phpBB3 archive to a local directory on your system using your favourite compression program, e.g. winzip, rar, zip, etc. From there you must FTP <strong>ALL</strong> the files it contains (being sure to retain the directory structure and filenames) to your host. Please ensure that the cases of filenames are retained, do <strong>NOT</strong> force filenames to all lower or upper case as doing so will cause errors later.</p>

+ <p>All .php, .sql, .cfg, .css, .js, .html, .htaccess and .txt files should be uploaded in <strong>ASCII</strong> mode, while all graphics should be uploaded in <strong>BINARY</strong> mode. If you are unfamiliar with what this means please refer to your FTP client documentation. In most cases this is all handled transparantly by your ftp client, but if you encounter problems later you should be sure the files were uploaded correctly as described here.</p>

+ <p>phpBB3 comes supplied with British English as its standard language. However, a number of separate packs for different languages are available. If you are not a native English speaker you may wish to install one or more of these packages before continuing. The installation process below will allow you to select a default language from those available (you can, of course, change this default at a later stage). For more details on language packs, where to obtain them and how to install them please see the <a href="README.html#i18n">README</a>.</p>

+ <p>Once all the files have been uploaded to your site, you should point your browser at this location with the addition of <code>/install/</code>. For example, if your domain name is <code>www.example.com</code> and you placed the phpBB3 files in the directory <code>/phpBB3</code> off your web root you would enter <code>http://www.example.com/phpBB3/install/</code> or (alternatively) <code>http://www.example.com/phpBB3/install/index.php</code> into your browser. When you have done this, you should see the <strong><em>phpBB3 Introduction</em></strong> screen appear.</p>

+ <p>The initial screen gives you a short introduction into phpBB. It allows you to read the license phpBB3 is released under (General Public License v2) and provides information about how you can receive support. To start the installation, use the <strong><em>INSTALL</em></strong> tab.</p>

+ <p>The first page you will see after starting the installation is the Requirements list. phpBB3 automatically checks whether everything that it needs to run properly is installed on your server. You need to have at least the minimum PHP version installed, and at least one database available to continue the installation. Also important, is that all shown folders are available and have the correct permissions. Please see the description of each section to find out whether they are optional or required for phpBB3 to run. If everything is in order, you can continue the installation with <em>Start Install</em>.</p>

+ <p>You don't need to change the Prefix for tables in database setting, unless you plan on using multipe phpBB installations on one database. In this case, you can use a different prefix for each installation to make it work.</p>

+ <p>After you entered your details, you can continue with the <em>Proceed to next step</em> button. Now phpBB3 will check whether the data you entered will lead to a successful database connection and whether tables with the same prefix already exist.</p>

+ <p>If you see the <em>Successful Connection</em> message, you can continue to the next step.</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="http://www.phpbb.com/">www.phpbb.com</a>, and add them before installing or later.</p>

+ <p>In this step, phpBB will try to write the configuration file automatically. The forum needs the configuration file in order to operate. It contains all the database settings, so without it, phpBB will not be able to access the database.</p>

+ <p>Usually, writing the configuration file automatically works fine. If the file permissions are not set correctly, this process can fail. In this case, you need to upload the file manually. phpBB asks you to download the <code>config.php</code> file and tells you what to do with it. Please read the instructions carefully. After you have uploaded the file, use <em>Done</em> to get to the last step. If <em>Done</em> returns you to the same page as before, and does not return a success message, you did not upload the file correctly.</p>

+ <p>The Advanced settings allow you to set additional parameters of the board configuration. They are optional and you can always change them later. So, even if you are not sure what these settings mean, you can still proceed to the final step and finish the installation.</p>

+ <p>If the installation was successful, you can now use the <em>Login</em> button to visit the Administration Control Panel. Congratulations, you have installed phpBB successfully. But there is still work ahead!</p>

+ <p>If you are unable to get phpBB3 installed even after reading this guide, please look at the support section of the installer's introduction page to find out where you can ask for further assistance.</p>

+<p>If you are currently using a stable release of phpBB3, updating to this version is straightforward. You would have downloaded one of four packages and your choice determines what you need to do. <strong>Note</strong>: Before updating, we heavily recommend you do a <em>full backup of your database and existing phpBB3 files</em>! If you are unsure how to achieve this please ask your hosting provider for advice.</p>

+ <p>The full package is normally meant for new installations only, but if you want to replace all source files, this package comes in handy.</p>

+ <p>First, you should make a copy of your existing <code>config.php</code> file; keep it in a safe place! Next, delete all the existing phpBB3 files, you may want to leave your <code>files/</code> and <code>images/</code> directorie in place. You can leave alternative styles in place too. With this complete, you can upload the new phpBB files (see <a href="#install">New installation</a> for details if necessary). Once complete, copy back your saved <code>config.php</code>, replacing the new one. Another method is to just <strong>replace</strong> the existing files with the files from the full package - though make sure you do <strong>not</strong> overwrite your config.php file.</p>

+ <p>You should now run <code>install/database_update.php</code> which, depending on your previous version, will make a number of database changes. You may receive <em>FAILURES</em> during this procedure. They should not be a cause for concern unless you see an actual <em>ERROR</em>, in which case the script will stop (in this case you should seek help via our forums or bug tracker).</p>

+ <p>Once <code>install/database_update.php</code> has completed, you may proceed to the Administration Control Panel and then remove the install directory as advised.</p>

+<a name="update_files"></a><h3>4.ii. Changed files</h3>

+ <p>This package is meant for those wanting to only replace the files that were changed between a previous version and the latest version.</p>

+ <p>This package contains a number of archives, each contains the files changed from a given release to the latest version. You should select the appropriate archive for your current version, e.g. if you currently have <strong>3.0.10</strong> you should select the appropriate <code>phpBB-3.0.11-files.zip/tar.bz2</code> file.</p>

+ <p>The directory structure has been preserved, enabling you (if you wish) to simply upload the uncompressed contents of the archive to the appropriate location on your server, i.e. simply overwrite the existing files with the new versions. Do not forget that if you have installed any modifications (MODs) these files will overwrite the originals, possibly destroying them in the process. You will need to re-add MODs to any affected file before uploading.</p>

+ <p>As for the other update procedures, you should run <code>install/database_update.php</code> after you have finished updating the files. This will update your database schema and increment the version number.</p>

+ <p>The patch file package is for those wanting to update through the patch application, and should only be used by those who are comfortable with it.</p>

+ <p>The patch file is one solution for those with many Modifications (MODs) or other changes and do not want to re-add them back to all the changed files. To use this you will need command line access to a standard UNIX type <strong>patch</strong> application. If you do not have access to such an application, but still want to use this update approach, we strongly recommend the <a href="#update_auto">Automatic update package</a> explained below. It is also the recommended update method.</p>

+ <p>A number of patch files are provided to allow you to update from previous stable releases. Select the correct patch, e.g. if your current version is <strong>3.0.10</strong>, you need the <code>phpBB-3.0.11-patch.zip/tar.bz2</code> file. Place the correct patch in the parent directory containing the phpBB core files (i.e. index.php, viewforum.php, etc.). With this done you should run the following command: <code>patch -cl -d [PHPBB DIRECTORY] -p1 &lt; [PATCH NAME]</code> (where PHPBB DIRECTORY is the directory name your phpBB Installation resides in, for example phpBB, and where PATCH NAME is the relevant filename of the selected patch file). This should complete quickly, hopefully without any HUNK FAILED comments.</p>

+ <p>If you do get failures, you should look at using the <a href="#update_files">Changed Files</a> package to replace the files which failed to patch. Please note that you will need to manually re-add any MODs to these particular files. Alternatively, if you know how, you can examine the .rej files to determine what failed where and make manual adjustments to the relevant source.</p>

+ <p>You should, of course, delete the patch file (or files) after use. As for the other update procedures, you should run <code>install/database_update.php</code> after you have finished updating the files. This will update your database schema and data (if appropriate) and increment the version number.</p>

+ <p>This update method is the recommended method for updating. This package detects changed files automatically and merges in changes if needed.</p>

+ <p>The automatic update package will update the board from a given version to the latest version. A number of automatic update files are available, and you should choose the one that corresponds to the version of the board that you are currently running. For example, if your current version is <strong>3.0.10</strong>, you need the <code>phpBB-3.0.10_to_3.0.11.zip/tar.bz2</code> file.</p>

+ <p>To perform the update, either follow the instructions from the <strong>Administration Control Panel-&gt;System</strong> Tab - this should point out that you are running an outdated version and will guide you through the update - or follow the instructions listed below.</p>

+ <li>Upload the uncompressed archive contents to your phpBB installation - only the install folder is required. Upload the whole install folder, retaining the file structure.</li>

+ <li>Point your browser to the install directory, for example <code>http://www.example.com/phpBB3/install/</code></li>

+ <p>If you have non-English language packs installed, you may want to see if a new version has been made available. A number of missing strings may have been added which, though not essential, may be beneficial to users. Please note that at this time not all language packs have been updated so you should be prepared to periodically check for updates.</p>

+

+ <p>These update methods will only update the standard styles, <code>prosilver</code> and <code>subsilver2</code>, any other styles you have installed for your board will usually also need to be updated.</p>

+ <p>Before converting, we heavily recommend you do a <em>full backup of your database and files</em>! If you are unsure how to achieve this, please ask your hosting provider for advice. You basically need to follow the instructions given for <a href="#install">New installations</a>. Please <strong>do not</strong> overwrite any old files - install phpBB3 at a different location.</p>

+ <p>Note that the conversion requires <code>CREATE</code> and <code>DROP</code> privileges for the phpBB3 database user account.</p>

+ <p>To begin the conversion, visit the <code>install/</code> folder of your phpBB3 installation (the same as you have done for installing). Now you will see a new tab <em>Convert</em>. Click this tab.</p>

+ <p>As with install, the conversion is automated. Your previous 2.0.x database tables will not be changed and the original 2.0.x files will remain unaltered. The conversion is actually only filling your phpBB3 database tables and copying additional data over to your phpBB3 installation. This has the benefit that if something goes wrong, you are able to either re-run the conversion or continue a conversion, while your old board is still accessible. We really recommend that you disable your old installation while converting, else you may have inconsistent data after the conversion.</p>

+ <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="http://www.phpbb.com/kb/article/offline-conversions/">Knowledge Base - Offline Conversions</a></p>

+ <p>Once completed, your board should be immediately available. If you encountered errors, you should report the problems to our bug tracker or seek help via our forums (see <a href="README.html">README</a> for details).</p>

+ <p>After a successful conversion, there may be a few items you need to do - apart from checking if the installation is accessible and everything displayed correctly.</p>

+ <p>The first thing you may want to do is to go to the administration control panel and check every configuration item within the general tab. Thereafter, you may want to adjust the forum descriptions/names if you entered HTML there. You also may want to access the other administrative sections, e.g. adjusting permissions, smilies, icons, ranks, etc.</p>

+ <p>During the conversion, the search index is not created or transferred. This means after conversion you are not able to find any matches if you want to search for something. We recommend you rebuild your search index within <strong>Administration Control Panel -&gt; Maintenance -&gt; Database -&gt; Search Index</strong>.</p>

+ <p>Once you are pleased with your new installation, you may want to give it the name of your old installation, changing the directory name. With phpBB3 this is possible without any problems, but you may still want to check your cookie settings within the administration panel; in case your cookie path needs to be adjusted prior to renaming.</p>

+ <p><strong>http 500 / white pages</strong> The conversion is a load-heavy procedure. Restrictions imposed by some server hosting providers can cause problems. The most common causes are: values too low for the PHP settings <code>memory_limit</code> and <code>max_execution_time</code>. Limits on the allowed CPU time are also a frequent cause for such errors, as are limits on the number of database queries allowed. If you cannot change such settings, then contact your hosting provider or run the conversion procedure on a different computer. The phpBB.com forums are also an excellent location to ask for support.</p>

+ <p><strong>Password conversion</strong> Due to the utf-8 based handling of passwords in phpBB3, it is not always possible to transfer all passwords. For passwords "lost in translation" the easiest workaround is to use the <em>I forgot my password</em> link on the login page.</p>

+ <p><strong>Path to your former board</strong> The convertor expects the relative path to your old board's files. So, for instance, if the old board is located at <code>http://www.yourdomain.com/forum</code> and the phpBB3 installation is located at <code>http://www.yourdomain.com/phpBB3</code>, then the correct value would be <code>../forum</code>. Note that the webserver user must be able to access the source installation's files.</p>

+ <p><strong>Smilies</strong> During the conversion you might see warnings about image files where the copying failed. This can happen if the old board's smilies have the same file names as those on the new board. Copy those files manually after the conversion, if you want to continue using the old smilies.</p>

+ <p>Once you have successfully installed phpBB3 you <strong>MUST</strong> ensure you remove the entire <code>install/</code> directory. Leaving the install directory in place is a <em>very serious potential security issue</em> which may lead to deletion or alteration of files, etc. Please note that until this directory is removed, phpBB will not operate and a warning message will be displayed. Beyond this <strong>essential</strong> deletion, you may also wish to delete the docs/ directory if you wish.</p>

+ <p>With these directories deleted, you should proceed to the administration panel. Depending on how the installation completed, you may have been directed there automatically. If not, login as the administrator you specified during install/conversion and click the <strong>Administration Control Panel</strong> link at the bottom of any page. Ensure that details specified on the <strong>General</strong> tab are correct!</p>

+ <p>Two of these options allow users to upload an avatar from their machine or a remote location (via a URL). If you wish to enable this function you should first ensure the correct path for uploadable avatars is set in <strong>Administration Control Panel -&gt; General -&gt; Board Configuration -&gt; Avatar settings</strong>. By default this is <code>images/avatars/uploads</code>, but you can set it to whatever you like, just ensure the configuration setting is updated. You must also ensure this directory can be written to by the webserver. Usually this means you have to alter its permissions to allow anyone to read and write to it. Exactly how you should do this depends on your FTP client or server operating system.</p>

+ <p>On UNIX systems, for example, you set the directory to a+rwx (or ugo+rwx or even 777). This can be done from a command line on your server using chmod or via your FTP client (using the Change Permissions, chmod or other Permissions dialog box, see your FTP client's documentation for help). Most FTP clients list permissions in the form of User (Read, Write, Execute), Group (Read, Write, Execute) and Other (Read, Write, Execute). You need to tick all of these boxes to set correct permissions.</p>

+ <p>On Windows systems, you need to ensure the directory is not write-protected and that it has global write permissions (see your server's documentation or contact your hosting provider if you are unsure on how to achieve this).</p>

+ <p>Please be aware that setting a directory's permissions to global write access is a potential security issue. While it is unlikely that anything nasty will occur (such as all the avatars being deleted) there are always people out there to cause trouble. Therefore you should monitor this directory and if possible make regular backups.</p>

+ <p>Depending on your web server, you may have to configure your server to deny web access to the <code>cache/</code>, <code>files/</code>, <code>store/</code> and other directories. This is to prevent users from accessing sensitive files.</p>

+

+ <p>For <strong>Apache</strong> there are <code>.htaccess</code> files already in place to do this for you. Similarly, for <strong>Windows</strong> based servers using <strong>IIS</strong> there are <code>web.config</code> files already in place to do this for you. For other webservers, you will have to adjust the configuration yourself. Sample files for <strong>nginx</strong> and <strong>lighttpd</strong> to help you get started may be found in <code>docs/</code> directory.</p>

+ </div>

+ <div class="back2top"><a href="#wrap" class="top">Back to Top</a></div>

+

+ <span class="corners-bottom"><span></span></span></div>

+ </div>

+

+ <hr />

+

+<a name="anti_spam"></a><h2>7. Anti-Spam Measures</h2>

+

+ <div class="paragraph">

+ <div class="inner"><span class="corners-top"><span></span></span>

+

+ <div class="content">

+ <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="http://www.phpbb.com/support/spam/">Preventing Spam in phpBB</a> as soon as possible after completing the installation of your board.</p>

+<a name="disclaimer"></a><h2>8. Copyright and disclaimer</h2>

+ <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="http://www.phpbb.com/">phpBB Group</a>, All Rights Reserved.</p>

+ <li><a href="#i18n">Languages (Internationalisation - i18n)</a></li>

+ <li><a href="#kb">Knowledge Base</a></li>

+ <li><a href="#irc">Internet Relay Chat (IRC)</a></li>

+ <li>Note: if using the <em>Automatic Update Package</em>, updates are supported from phpBB 3.0.2 onward. To update a pre-3.0.2 installation, first update to 3.0.2 and then update to the current version.</li>

+ <p>Once installed, phpBB is easily managed via the Administration and Moderator Control Panels. If you need help or advice with phpBB, please see <a href="#help">Section 3</a> below.</p>

+ <a name="i18n"></a><h3>2.i. Languages (Internationalisation - i18n)</h3>

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

+ <p>For more information about language packs, please see: <a href="http://www.phpbb.com/languages/">http://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="http://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="http://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="http://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="http://www.phpbb.com/customise/db/styles-2/">Styles</a> section of our <a href="http://www.phpbb.com/customise/db/">Customisation Database</a>.</p>

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

+ <p><strong>Please note</strong> that 3rd party styles downloaded for versions of phpBB2 will <strong>not</strong> work in phpBB3. It is also important to ensure that the style is updated to match the current version of the phpBB software you are using.</p>

+ <p>Once you have downloaded a style, the usual next step is to unarchive (or upload the unarchived contents of) the package into your <code>styles/</code> directory. You then need to visit <code>Administration Control Panel -&gt; Styles tab</code> where you should see the new style available. Click &quot;Install&quot; to install the style.</p>

+ <p><strong>Please note</strong> that to improve efficiency, the software caches certain data. For this reason, if you create your own style or modify existing ones, please remember to &quot;Refresh&quot; the appropriate style components <code>Administration Control Panel -&gt; Styles tab -&gt; Style Components</code> screen. You may also need to reload the page you have changed in your web browser to overcome browser caching. If the changed components are not refreshed you will not see your changes taking effect.</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="http://www.phpbb.com/customise/db/modifications-1/">Modifications</a> section of our <a href="http://www.phpbb.com/customise/db/">Customisation Database</a>.</p>

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

+ <p><strong>Please remember</strong> that any bugs or other issues that occur after you have added any modification should <strong>NOT</strong> be reported to the bug tracker (see below). First remove the MOD and see if the problem is resolved. Any support for a MOD should only be sought in the &quot;Discussion/Support&quot; forum for that MOD.</p>

+ <p>Also remember that any modifications, particularly those which modify the database in any way, may render upgrading your forum to future versions more difficult. With all this said, many users have and continue to utilise many of the MODs already available with great success.</p>

+ <a name="kb"></a><h3>3.ii. Knowledge Base</h3>

+ <p>The Knowledge Base consists of a number of detailed articles on some common issues phpBB users may encounter while using the product. The Knowledge Base can be found at:</p>

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

+

+ <a name="website"></a><h3>3.iii. Community Forums</h3>

+

+ <p>The phpBB Group maintains a thriving community where a number of people have generously decided to donate their time to help support users. This site can be found at:</p>

+

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

+ <a name="irc"></a><h3>3.iv Internet Relay Chat</h3>

+ <p>Another place you may find help is our IRC channel. This operates on the Freenode IRC network, <a href="irc://irc.freenode.net">irc.freenode.net</a> and the channel is <em>#phpbb</em> and can be accessed by any decent IRC client such as mIRC, XChat, etc. Again, please do not abuse this service and be respectful of other users.</p>

+

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

+ <p>This is the third stable release of phpBB. The 3.0.x line is essentially feature frozen, with only point releases seeing fixes for bugs and security issues, though feature alterations and minor feature additions may be done if deemed absolutely required. Our next major release will be phpBB 3.1. Please do not post questions asking when 3.1 will be available, no release date has been set.</p>

+ <p>Those interested in the development of phpBB should keep an eye on the development forums to see how things are progressing:</p>

+ <p>Please note that the development forums should <strong>NOT</strong> be used to seek support for or ask questions about phpBB 2.0.x or phpBB 3.0.x, the main community forums are the place for this. Any such posts will be locked and go unanswered.</p>

+ <p>The phpBB Group uses a bug tracking system to store, list and manage all reported bugs, it can be found at the location listed below. Please <strong>DO NOT</strong> post bug reports to our forums. In addition please <strong>DO NOT</strong> use the bug tracker for support requests. Posting such a request will only see you directed to the support forums (while taking time away from working on real bugs).</p>

+ <p><a href="http://tracker.phpbb.com/browse/PHPBB3">http://tracker.phpbb.com/browse/PHPBB3</a></p>

+ <li>First, determine if your bug is reproduceable; how to determine this depends on the bug in question. Only if the bug is reproduceable is it likely to be a problem with phpBB3 (or in some way connected). If something cannot be reproduced it may turn out to have been your hosting provider working on something, a user doing something silly, etc. Bug reports for non-reproduceable events can slow down our attempts to fix real, reproduceable issues<br /><br /></li>

+ <li>Next, please read or search through the existing bug reports to see if <em>your</em> bug (or one very similar to it) is already listed. If it is please add to that existing bug rather than creating a new duplicate entry (all this does is slow us down).<br /><br /></li>

+ <li>Check the forums (use search!) to see if people have discussed anything that sounds similar to what you are seeing. However, as noted above please <strong>DO NOT</strong> post your particular bug to the forum unless it's non-reproduceable or you are sure it&rsquo;s related to something you have done rather than phpBB3<br /><br /></li>

+ <p>If you do post a new bug (i.e. one that isn't already listed in the bug tracker) first make sure that you have logged in (your username and password are the same as for the community forums) then please include the following details:</p>

+ <p>The relevant database type/version is listed within the administration control panel.</p>

+ <p>If you create a patch, it is very much appreciated (but not required) if you follow the phpBB coding guidelines. Please note that the coding guidelines are somewhat different between different versions of phpBB. For phpBB 3.0.x the coding guidelines may be found here: <a href="http://area51.phpbb.com/docs/30x/coding-guidelines.html">http://area51.phpbb.com/docs/30x/coding-guidelines.html</a></p>

+

+ <p>This list is not complete but does represent those bugs which may affect users on a wider scale. Other bugs listed in the tracker have typically been shown to be limited to certain setups or methods of installation, updating and/or conversions.</p>

+ <p>This board has been developed and tested under Linux and Windows (amongst others) running Apache using MySQL 3.23, 4.x, 5.x, MSSQL Server 2000, PostgreSQL 7.x, Oracle 8, SQLite 2 and Firebird. Versions of PHP used range from 4.3.3 to 5.4.x without problem. </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="http://www.phpbb.com/">phpBB Group</a>, All Rights Reserved.</p>

+ <p>This method returns null.</p>

+ * @return null

+ * @return null

+ * @return null

+ * @return null

+ * @return null

+ * @return null

+ * @return null

+ * @return null

+ * @return null

+ var $db_tools;

+ if (!class_exists('phpbb_db_tools'))

+ {

+ require($phpbb_root_path . 'includes/db/db_tools.' . $phpEx);

+ }

+ $this->db_tools = new phpbb_db_tools($db);

+

+ $table = array_intersect($this->db_tools->sql_list_tables(), request_var('table', array('')));

+ $tables = $this->db_tools->sql_list_tables();

+ $sql = 'SELECT MAX(post_id) as max_post_id

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

+ 'field_show_novalue'=> 0,

+ 1 => array('field_ident', 'lang_name', 'lang_explain', 'field_option_none', 'field_show_on_reg', 'field_show_on_vt', 'field_required', 'field_show_novalue', 'field_hide', 'field_show_profile', 'field_no_view'),

+ 'field_show_novalue',

+ 'S_FIELD_SHOW_NOVALUE'=> ($cp->vars['field_show_novalue']) ? true : false,

+ 'field_show_novalue' => $cp->vars['field_show_novalue'],

+ // The array key is used for sorting later on.

+ // $file is appended because $name doesn't have to be unique.

+ $new_ary[$name . $file] = array(

+ ksort($new_ary);

+

+ $sql = 'SELECT post_id

+ FROM ' . POSTS_TABLE . '

+ WHERE poster_id = '. $user_id;

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

+ $user_row['user_has_posts'] = (bool) $db->sql_fetchfield('post_id');

+ $db->sql_freeresult($result);

+

+ 'USER_HAS_POSTS' => $user_row['user_has_posts'],

+ return array(

+ 'status' => LOGIN_ERROR_EXTERNAL_AUTH,

+ 'error_msg' => 'LDAP_NO_SERVER_CONNECTION',

+ 'user_row' => array('user_id' => ANONYMOUS),

+ );

+ for ($i = (int) floor($width / 2); $i < $end; $i++)

+define('PHPBB_VERSION', '3.0.12-dev');

+ * Seek to given row number

+ * rownum is zero-based

+ */

+ function sql_rowseek($rownum, &$query_id)

+ {

+ global $cache;

+

+ if ($query_id === false)

+ {

+ $query_id = $this->query_result;

+ }

+

+ if (isset($cache->sql_rowset[$query_id]))

+ {

+ return $cache->sql_rowseek($rownum, $query_id);

+ }

+

+ if ($query_id === false)

+ {

+ return false;

+ }

+

+ $this->sql_freeresult($query_id);

+ $query_id = $this->sql_query($this->last_query_text);

+

+ if ($query_id === false)

+ {

+ return false;

+ }

+

+ // We do not fetch the row for rownum == 0 because then the next resultset would be the second row

+ for ($i = 0; $i < $rownum; $i++)

+ {

+ if (!$this->sql_fetchrow($query_id))

+ {

+ return false;

+ }

+ }

+

+ return true;

+ }

+

+ /**

+ * Run LOWER() on DB column of type text (i.e. neither varchar nor char).

+ *

+ * @param string $column_name The column name to use

+ *

+ * @return string A SQL statement like "LOWER($column_name)"

+ */

+ function sql_lower_text($column_name)

+ {

+ return "LOWER($column_name)";

+ }

+

+ /**

+ var $connect_error = '';

+

+ if (!function_exists('mssql_connect'))

+ {

+ $this->connect_error = 'mssql_connect function does not exist, is mssql extension installed?';

+ return $this->sql_error('');

+ }

+

+ * {@inheritDoc}

+ */

+ function sql_lower_text($column_name)

+ {

+ return "LOWER(SUBSTRING($column_name, 1, DATALENGTH($column_name)))";

+ }

+

+ /**

+ if (function_exists('mssql_get_last_message'))

+ $error = array(

+ 'message' => @mssql_get_last_message(),

+ 'code' => '',

+ );

+ // Get error code number

+ $result_id = @mssql_query('SELECT @@ERROR as code', $this->db_connect_id);

+ if ($result_id)

+ $row = @mssql_fetch_assoc($result_id);

+ $error['code'] = $row['code'];

+ @mssql_free_result($result_id);

+

+ // Get full error message if possible

+ $sql = 'SELECT CAST(description as varchar(255)) as message

+ FROM master.dbo.sysmessages

+ WHERE error = ' . $error['code'];

+ $result_id = @mssql_query($sql);

+

+ if ($result_id)

+ {

+ $row = @mssql_fetch_assoc($result_id);

+ if (!empty($row['message']))

+ {

+ $error['message'] .= '<br />' . $row['message'];

+ }

+ @mssql_free_result($result_id);

+ }

+ }

+ else

+ {

+ $error = array(

+ 'message' => $this->connect_error,

+ 'code' => '',

+ );

+ var $connect_error = '';

+ if ($this->persistency)

+ {

+ if (!function_exists('odbc_pconnect'))

+ {

+ $this->connect_error = 'odbc_pconnect function does not exist, is odbc extension installed?';

+ return $this->sql_error('');

+ }

+ $this->db_connect_id = @odbc_pconnect($this->server, $this->user, $sqlpassword);

+ }

+ else

+ {

+ if (!function_exists('odbc_connect'))

+ {

+ $this->connect_error = 'odbc_connect function does not exist, is odbc extension installed?';

+ return $this->sql_error('');

+ }

+ $this->db_connect_id = @odbc_connect($this->server, $this->user, $sqlpassword);

+ }

+ * {@inheritDoc}

+ */

+ function sql_lower_text($column_name)

+ {

+ return "LOWER(SUBSTRING($column_name, 1, DATALENGTH($column_name)))";

+ }

+

+ /**

+ if (function_exists('odbc_errormsg'))

+ {

+ $error = array(

+ 'message' => @odbc_errormsg(),

+ 'code' => @odbc_error(),

+ );

+ }

+ else

+ {

+ $error = array(

+ 'message' => $this->connect_error,

+ 'code' => '',

+ );

+ }

+

+ return $error;

+ var $connect_error = '';

+ // Test for driver support, to avoid suppressed fatal error

+ $this->connect_error = 'Native MS SQL Server driver for PHP is missing or needs to be updated. Version 1.1 or later is required to install phpBB3. You can download the driver from: http://www.microsoft.com/sqlserver/2005/en/us/PHP-Driver.aspx';

+ return $this->sql_error('');

+ return (sizeof($row)) ? $row : false;

+ * {@inheritDoc}

+ */

+ function sql_lower_text($column_name)

+ {

+ return "LOWER(SUBSTRING($column_name, 1, DATALENGTH($column_name)))";

+ }

+

+ /**

+ if (function_exists('sqlsrv_errors'))

+ $errors = @sqlsrv_errors(SQLSRV_ERR_ERRORS);

+ $error_message = '';

+ $code = 0;

+

+ if ($errors != null)

+ foreach ($errors as $error)

+ {

+ $error_message .= "SQLSTATE: " . $error[ 'SQLSTATE'] . "\n";

+ $error_message .= "code: " . $error[ 'code'] . "\n";

+ $code = $error['code'];

+ $error_message .= "message: " . $error[ 'message'] . "\n";

+ }

+ $this->last_error_result = $error_message;

+ $error = $this->last_error_result;

+ }

+ else

+ {

+ $error = (isset($this->last_error_result) && $this->last_error_result) ? $this->last_error_result : array();

+

+ $error = array(

+ 'message' => $error,

+ 'code' => $code,

+ );

+ $error = array(

+ 'message' => $this->connect_error,

+ 'code' => '',

+ );

+ return $error;

+ var $connect_error = '';

+ if ($this->persistency)

+ {

+ if (!function_exists('mysql_pconnect'))

+ {

+ $this->connect_error = 'mysql_pconnect function does not exist, is mysql extension installed?';

+ return $this->sql_error('');

+ }

+ $this->db_connect_id = @mysql_pconnect($this->server, $this->user, $sqlpassword);

+ }

+ else

+ {

+ if (!function_exists('mysql_connect'))

+ {

+ $this->connect_error = 'mysql_connect function does not exist, is mysql extension installed?';

+ return $this->sql_error('');

+ }

+ $this->db_connect_id = @mysql_connect($this->server, $this->user, $sqlpassword, $new_link);

+ }

+ if ($this->db_connect_id)

+ {

+ $error = array(

+ 'message' => @mysql_error($this->db_connect_id),

+ 'code' => @mysql_errno($this->db_connect_id),

+ );

+ }

+ else if (function_exists('mysql_error'))

+ $error = array(

+ 'code' => @mysql_errno(),

+ );

+ }

+ else

+ {

+ $error = array(

+ 'message' => $this->connect_error,

+ 'code' => '',

+ return $error;

+ var $connect_error = '';

+ if (!function_exists('mysqli_connect'))

+ {

+ $this->connect_error = 'mysqli_connect function does not exist, is mysqli extension installed?';

+ return $this->sql_error('');

+ }

+

+ if ($this->db_connect_id)

+ {

+ $error = array(

+ 'message' => @mysqli_error($this->db_connect_id),

+ 'code' => @mysqli_errno($this->db_connect_id)

+ );

+ }

+ else if (function_exists('mysqli_connect_error'))

+ $error = array(

+ 'code' => @mysqli_connect_errno(),

+ );

+ }

+ else

+ {

+ $error = array(

+ 'message' => $this->connect_error,

+ 'code' => '',

+ return $error;

+ var $connect_error = '';

+ if ($new_link)

+ {

+ if (!function_exists('ocinlogon'))

+ {

+ $this->connect_error = 'ocinlogon function does not exist, is oci extension installed?';

+ return $this->sql_error('');

+ }

+ $this->db_connect_id = @ocinlogon($this->user, $sqlpassword, $connect, 'UTF8');

+ }

+ else if ($this->persistency)

+ {

+ if (!function_exists('ociplogon'))

+ {

+ $this->connect_error = 'ociplogon function does not exist, is oci extension installed?';

+ return $this->sql_error('');

+ }

+ $this->db_connect_id = @ociplogon($this->user, $sqlpassword, $connect, 'UTF8');

+ }

+ else

+ {

+ if (!function_exists('ocilogon'))

+ {

+ $this->connect_error = 'ocilogon function does not exist, is oci extension installed?';

+ return $this->sql_error('');

+ }

+ $this->db_connect_id = @ocilogon($this->user, $sqlpassword, $connect, 'UTF8');

+ }

+ if (function_exists('ocierror'))

+ $error = @ocierror();

+ $error = (!$error) ? @ocierror($this->query_result) : $error;

+ $error = (!$error) ? @ocierror($this->db_connect_id) : $error;

+

+ if ($error)

+ {

+ $this->last_error_result = $error;

+ }

+ else

+ {

+ $error = (isset($this->last_error_result) && $this->last_error_result) ? $this->last_error_result : array();

+ }

+ $error = array(

+ 'message' => $this->connect_error,

+ 'code' => '',

+ );

+ var $connect_error = '';

+

+ if ($this->persistency)

+ {

+ if (!function_exists('sqlite_popen'))

+ {

+ $this->connect_error = 'sqlite_popen function does not exist, is sqlite extension installed?';

+ return $this->sql_error('');

+ }

+ $this->db_connect_id = @sqlite_popen($this->server, 0666, $error);

+ }

+ else

+ {

+ if (!function_exists('sqlite_open'))

+ {

+ $this->connect_error = 'sqlite_open function does not exist, is sqlite extension installed?';

+ return $this->sql_error('');

+ }

+ $this->db_connect_id = @sqlite_open($this->server, 0666, $error);

+ }

+ if (function_exists('sqlite_error_string'))

+ {

+ $error = array(

+ 'message' => @sqlite_error_string(@sqlite_last_error($this->db_connect_id)),

+ 'code' => @sqlite_last_error($this->db_connect_id),

+ );

+ }

+ else

+ {

+ $error = array(

+ 'message' => $this->connect_error,

+ 'code' => '',

+ );

+ }

+

+ return $error;

+* @param mixed $value filesize in bytes

+* (non-negative number; int, float or string)

+ 'tb' => array(

+ 'min' => 1099511627776, // pow(2, 40)

+ 'index' => 4,

+ 'si_unit' => 'TB',

+ 'iec_unit' => 'TIB',

+ ),

+/**

+* Eliminates useless . and .. components from specified path.

+*

+* @param string $path Path to clean

+* @return string Cleaned path

+*/

+function phpbb_clean_path($path)

+{

+ $exploded = explode('/', $path);

+ $filtered = array();

+ foreach ($exploded as $part)

+ {

+ if ($part === '.' && !empty($filtered))

+ {

+ continue;

+ }

+

+ if ($part === '..' && !empty($filtered) && $filtered[sizeof($filtered) - 1] !== '..')

+ {

+ array_pop($filtered);

+ }

+ else

+ {

+ $filtered[] = $part;

+ }

+ }

+ $path = implode('/', $filtered);

+ return $path;

+}

+

+ $sql = 'SELECT t.forum_id

+ FROM ' . TOPICS_TABLE . ' t

+ LEFT JOIN ' . TOPICS_TRACK_TABLE . ' tt

+ ON (tt.topic_id = t.topic_id

+ AND tt.user_id = ' . $user->data['user_id'] . ')

+ AND (tt.topic_id IS NULL

+ OR tt.mark_time < t.topic_last_post_time)';

+* @return null

+ if (defined('DEBUG_TEST') || $diff && ($diff <= $timespan || $timespan === -1))

+ return '([\w\!\#$\%\&\'\*\+\-\/\=\?\^\`{\|\}\~]+\.)*(?:[\w\!\#$\%\'\*\+\-\/\=\?\^\`{\|\}\~]|&amp;)+@((((([a-z0-9]{1}[a-z0-9\-]{0,62}[a-z0-9]{1})|[a-z])\.)+[a-z]{2,63})|(\d{1,3}\.){3}\d{1,3}(\:\d{1,5})?)';

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

+* @return null

+ 'CREDIT_LINE' => $user->lang('POWERED_BY', '<a href="https://www.phpbb.com/">phpBB</a>&reg; Forum Software &copy; phpBB Group'),

+* remove_comments will strip the sql comment lines out of an uploaded sql file

+* specifically for mssql and postgres type files in the install....

+*

+* @deprecated Use phpbb_remove_comments() instead.

+*/

+function remove_comments(&$output)

+{

+ // Remove /* */ comments (http://ostermiller.org/findcomment.html)

+ $output = preg_replace('#/\*(.|[\r\n])*?\*/#', "\n", $output);

+

+ // Return by reference and value.

+ return $output;

+}

+

+/**

+ $sql_lower = $db->sql_lower_text('l.log_data');

+ $sql_keywords .= "$sql_lower " . implode(" OR $sql_lower ", $keywords) . ')';

+ * @return null

+<?php

+/**

+*

+* @package phpBB3

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

+}

+

+/**

+* Updates rows in given table from a set of values to a new value.

+* If this results in rows violating uniqueness constraints, the duplicate

+* rows are eliminated.

+*

+* The only supported table is bookmarks.

+*

+* @param dbal $db Database object

+* @param string $table Table on which to perform the update

+* @param string $column Column whose values to change

+* @param array $from_values An array of values that should be changed

+* @param int $to_value The new value

+* @return null

+*/

+function phpbb_update_rows_avoiding_duplicates($db, $table, $column, $from_values, $to_value)

+{

+ $sql = "SELECT $column, user_id

+ FROM $table

+ WHERE " . $db->sql_in_set($column, $from_values);

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

+

+ $old_user_ids = array();

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

+ {

+ $old_user_ids[$row[$column]][] = (int) $row['user_id'];

+ }

+ $db->sql_freeresult($result);

+

+ $sql = "SELECT $column, user_id

+ FROM $table

+ WHERE $column = " . (int) $to_value;

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

+

+ $new_user_ids = array();

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

+ {

+ $new_user_ids[$row[$column]][] = (int) $row['user_id'];

+ }

+ $db->sql_freeresult($result);

+

+ $queries = array();

+ foreach ($from_values as $from_value)

+ {

+ if (!isset($old_user_ids[$from_value]))

+ {

+ continue;

+ }

+ if (empty($new_user_ids))

+ {

+ $sql = "UPDATE $table

+ SET $column = " . (int) $to_value . "

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

+ $queries[] = $sql;

+ }

+ else

+ {

+ $different_user_ids = array_diff($old_user_ids[$from_value], $new_user_ids[$to_value]);

+ if (!empty($different_user_ids))

+ {

+ $sql = "UPDATE $table

+ SET $column = " . (int) $to_value . "

+ WHERE $column = '" . $db->sql_escape($from_value) . "'

+ AND " . $db->sql_in_set('user_id', $different_user_ids);

+ $queries[] = $sql;

+ }

+ }

+ }

+

+ if (!empty($queries))

+ {

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

+

+ foreach ($queries as $sql)

+ {

+ $db->sql_query($sql);

+ }

+

+ $sql = "DELETE FROM $table

+ WHERE " . $db->sql_in_set($column, $from_values);

+ $db->sql_query($sql);

+

+ $db->sql_transaction('commit');

+ }

+}

+

+/**

+* Updates rows in given table from a set of values to a new value.

+* If this results in rows violating uniqueness constraints, the duplicate

+* rows are merged respecting notify_status (0 takes precedence over 1).

+*

+* The only supported table is topics_watch.

+*

+* @param dbal $db Database object

+* @param string $table Table on which to perform the update

+* @param string $column Column whose values to change

+* @param array $from_values An array of values that should be changed

+* @param int $to_value The new value

+* @return null

+*/

+function phpbb_update_rows_avoiding_duplicates_notify_status($db, $table, $column, $from_values, $to_value)

+{

+ $sql = "SELECT $column, user_id, notify_status

+ FROM $table

+ WHERE " . $db->sql_in_set($column, $from_values);

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

+

+ $old_user_ids = array();

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

+ {

+ $old_user_ids[(int) $row['notify_status']][$row[$column]][] = (int) $row['user_id'];

+ }

+ $db->sql_freeresult($result);

+

+ $sql = "SELECT $column, user_id

+ FROM $table

+ WHERE $column = " . (int) $to_value;

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

+

+ $new_user_ids = array();

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

+ {

+ $new_user_ids[$row[$column]][] = (int) $row['user_id'];

+ }

+ $db->sql_freeresult($result);

+

+ $queries = array();

+ $extra_updates = array(

+ 0 => 'notify_status = 0',

+ 1 => '',

+ );

+ foreach ($from_values as $from_value)

+ {

+ foreach ($extra_updates as $notify_status => $extra_update)

+ {

+ if (!isset($old_user_ids[$notify_status][$from_value]))

+ {

+ continue;

+ }

+ if (empty($new_user_ids))

+ {

+ $sql = "UPDATE $table

+ SET $column = " . (int) $to_value . "

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

+ $queries[] = $sql;

+ }

+ else

+ {

+ $different_user_ids = array_diff($old_user_ids[$notify_status][$from_value], $new_user_ids[$to_value]);

+ if (!empty($different_user_ids))

+ {

+ $sql = "UPDATE $table

+ SET $column = " . (int) $to_value . "

+ WHERE $column = '" . $db->sql_escape($from_value) . "'

+ AND " . $db->sql_in_set('user_id', $different_user_ids);

+ $queries[] = $sql;

+ }

+

+ if ($extra_update)

+ {

+ $same_user_ids = array_diff($old_user_ids[$notify_status][$from_value], $different_user_ids);

+ if (!empty($same_user_ids))

+ {

+ $sql = "UPDATE $table

+ SET $extra_update

+ WHERE $column = '" . (int) $to_value . "'

+ AND " . $db->sql_in_set('user_id', $same_user_ids);

+ $queries[] = $sql;

+ }

+ }

+ }

+ }

+ }

+

+ if (!empty($queries))

+ {

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

+

+ foreach ($queries as $sql)

+ {

+ $db->sql_query($sql);

+ }

+

+ $sql = "DELETE FROM $table

+ WHERE " . $db->sql_in_set($column, $from_values);

+ $db->sql_query($sql);

+

+ $db->sql_transaction('commit');

+ }

+}

+ 'COMMENTS' => 'remove_remarks',

+ // Note: php 5.5 alpha 2 deprecated mysql.

+ // Keep mysqli before mysql in this list.

+ 'COMMENTS' => 'remove_remarks',

+ 'COMMENTS' => 'remove_remarks',

+ 'COMMENTS' => 'remove_comments',

+ 'COMMENTS' => 'remove_comments',

+ 'COMMENTS' => 'remove_comments',

+ 'COMMENTS' => 'remove_comments',

+ 'COMMENTS' => 'remove_comments',

+ 'COMMENTS' => 'remove_remarks',

+*

+* @deprecated Use phpbb_remove_comments() instead.

+function remove_remarks(&$sql)

+ // Return by reference

+}

+

+/**

+* Removes "/* style" as well as "# style" comments from $input.

+*

+* @param string $input Input string

+*

+* @return string Input string with comments removed

+*/

+function phpbb_remove_comments($input)

+{

+ if (!function_exists('remove_comments'))

+ {

+ global $phpbb_root_path, $phpEx;

+ require($phpbb_root_path . 'includes/functions_admin.' . $phpEx);

+ }

+

+ // Remove /* */ comments

+ remove_comments($input);

+

+ // Remove # style comments

+ remove_remarks($input);

+

+ return $input;

+* @param bool $debug_test If the DEBUG_TEST constant should be added

+* NOTE: Only for use within the testing framework

+function phpbb_create_config_file_data($data, $dbms, $load_extensions, $debug = false, $debug_test = false)

+ if ($debug_test)

+ {

+ $config_data .= "@define('DEBUG_TEST', true);\n";

+ }

+ // avoid races, check file existence once

+ $have_cache_file = file_exists($this->cache_file);

+ if (!$have_cache_file || $config['last_queue_run'] > time() - $config['queue_interval'])

+ if (!$have_cache_file)

+ {

+ set_config('last_queue_run', time(), true);

+ }

+

+ set_config('last_queue_run', time(), true);

+

+ $root_path = (defined('PHPBB_USE_BOARD_URL_PATH') && PHPBB_USE_BOARD_URL_PATH) ? generate_board_url() . '/' : $phpbb_root_path;

+

+ 'ICON_IMG' => $root_path . $config['icons_path'] . '/' . $data['img'],

+function user_notification($mode, $subject, $topic_title, $forum_name, $forum_id, $topic_id, $post_id, $author_name = '')

+ 'AUTHOR_NAME' => htmlspecialchars_decode($author_name),

+ // Check the permissions for post approval.

+ // Moderators must go through post approval like ordinary users.

+ if (!$auth->acl_get('f_noapprove', $data['forum_id']))

+ $username = ($username) ? $username : $user->data['username'];

+ user_notification($mode, $subject, $data['topic_title'], $data['forum_name'], $data['forum_id'], $data['topic_id'], $data['post_id'], $username);

+* @param int $bump_time The time at which topic was bumped, usually it is a current time as obtained via time().

+* Delete all PM(s) for a given user and delete the ones without references

+*

+* @param int $user_id ID of the user whose private messages we want to delete

+*

+* @return boolean False if there were no pms found, true otherwise.

+*/

+function phpbb_delete_user_pms($user_id)

+{

+ global $db, $user, $phpbb_root_path, $phpEx;

+

+ $user_id = (int) $user_id;

+

+ if (!$user_id)

+ {

+ return false;

+ }

+

+ // Get PM Information for later deleting

+ // The two queries where split, so we can use our indexes

+ $undelivered_msg = $delete_ids = array();

+

+ // Part 1: get PMs the user received

+ $sql = 'SELECT msg_id

+ FROM ' . PRIVMSGS_TO_TABLE . '

+ WHERE user_id = ' . $user_id;

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

+

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

+ {

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

+ $delete_ids[$msg_id] = $msg_id;

+ }

+ $db->sql_freeresult($result);

+

+ // Part 2: get PMs the user sent, but have yet to be received

+ // We cannot simply delete them. First we have to check,

+ // whether another user already received and read the message.

+ $sql = 'SELECT msg_id

+ FROM ' . PRIVMSGS_TO_TABLE . '

+ WHERE author_id = ' . $user_id . '

+ AND folder_id = ' . PRIVMSGS_NO_BOX;

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

+

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

+ {

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

+ $undelivered_msg[$msg_id] = $msg_id;

+ }

+ $db->sql_freeresult($result);

+

+ if (empty($delete_ids) && empty($undelivered_msg))

+ {

+ return false;

+ }

+

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

+

+ if (!empty($undelivered_msg))

+ {

+ // A pm is delivered, if for any recipient the message was moved

+ // from their NO_BOX to another folder. We do not delete such

+ // messages, but only delete them for users, who have not yet

+ // received them.

+ $sql = 'SELECT msg_id

+ FROM ' . PRIVMSGS_TO_TABLE . '

+ WHERE author_id = ' . $user_id . '

+ AND folder_id <> ' . PRIVMSGS_NO_BOX . '

+ AND folder_id <> ' . PRIVMSGS_OUTBOX . '

+ AND folder_id <> ' . PRIVMSGS_SENTBOX;

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

+

+ $delivered_msg = array();

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

+ {

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

+ $delivered_msg[$msg_id] = $msg_id;

+ unset($undelivered_msg[$msg_id]);

+ }

+ $db->sql_freeresult($result);

+

+ $undelivered_user = array();

+

+ // Count the messages we delete, so we can correct the user pm data

+ $sql = 'SELECT user_id, COUNT(msg_id) as num_undelivered_privmsgs

+ FROM ' . PRIVMSGS_TO_TABLE . '

+ WHERE author_id = ' . $user_id . '

+ AND folder_id = ' . PRIVMSGS_NO_BOX . '

+ AND ' . $db->sql_in_set('msg_id', array_merge($undelivered_msg, $delivered_msg)) . '

+ GROUP BY user_id';

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

+

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

+ {

+ $num_pms = (int) $row['num_undelivered_privmsgs'];

+ $undelivered_user[$num_pms][] = (int) $row['user_id'];

+

+ if (sizeof($undelivered_user[$num_pms]) > 50)

+ {

+ // If there are too many users affected the query might get

+ // too long, so we update the value for the first bunch here.

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_new_privmsg = user_new_privmsg - ' . $num_pms . ',

+ user_unread_privmsg = user_unread_privmsg - ' . $num_pms . '

+ WHERE ' . $db->sql_in_set('user_id', $undelivered_user[$num_pms]);

+ $db->sql_query($sql);

+ unset($undelivered_user[$num_pms]);

+ }

+ }

+ $db->sql_freeresult($result);

+

+ foreach ($undelivered_user as $num_pms => $undelivered_user_set)

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_new_privmsg = user_new_privmsg - ' . $num_pms . ',

+ user_unread_privmsg = user_unread_privmsg - ' . $num_pms . '

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

+ $db->sql_query($sql);

+ }

+

+ if (!empty($delivered_msg))

+ {

+ $sql = 'DELETE FROM ' . PRIVMSGS_TO_TABLE . '

+ WHERE folder_id = ' . PRIVMSGS_NO_BOX . '

+ AND ' . $db->sql_in_set('msg_id', $delivered_msg);

+ $db->sql_query($sql);

+ }

+

+ if (!empty($undelivered_msg))

+ {

+ $sql = 'DELETE FROM ' . PRIVMSGS_TO_TABLE . '

+ WHERE ' . $db->sql_in_set('msg_id', $undelivered_msg);

+ $db->sql_query($sql);

+

+ $sql = 'DELETE FROM ' . PRIVMSGS_TABLE . '

+ WHERE ' . $db->sql_in_set('msg_id', $undelivered_msg);

+ $db->sql_query($sql);

+ }

+ }

+

+ // Reset the user's pm count to 0

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_new_privmsg = 0,

+ user_unread_privmsg = 0

+ WHERE user_id = ' . $user_id;

+ $db->sql_query($sql);

+

+ // Delete private message data of the user

+ $sql = 'DELETE FROM ' . PRIVMSGS_TO_TABLE . '

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

+ $db->sql_query($sql);

+

+ if (!empty($delete_ids))

+ {

+ // Now we have to check which messages we can delete completely

+ $sql = 'SELECT msg_id

+ FROM ' . PRIVMSGS_TO_TABLE . '

+ WHERE ' . $db->sql_in_set('msg_id', $delete_ids);

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

+

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

+ {

+ unset($delete_ids[$row['msg_id']]);

+ }

+ $db->sql_freeresult($result);

+

+ if (!empty($delete_ids))

+ {

+ // Check if there are any attachments we need to remove

+ if (!function_exists('delete_attachments'))

+ {

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

+ }

+

+ delete_attachments('message', $delete_ids, false);

+

+ $sql = 'DELETE FROM ' . PRIVMSGS_TABLE . '

+ WHERE ' . $db->sql_in_set('msg_id', $delete_ids);

+ $db->sql_query($sql);

+ }

+ }

+

+ // Set the remaining author id to anonymous

+ // This way users are still able to read messages from users being removed

+ $sql = 'UPDATE ' . PRIVMSGS_TO_TABLE . '

+ SET author_id = ' . ANONYMOUS . '

+ WHERE author_id = ' . $user_id;

+ $db->sql_query($sql);

+

+ $sql = 'UPDATE ' . PRIVMSGS_TABLE . '

+ SET author_id = ' . ANONYMOUS . '

+ WHERE author_id = ' . $user_id;

+ $db->sql_query($sql);

+

+ $db->sql_transaction('commit');

+

+ return true;

+}

+

+/**

+

+

+ $user_ids = $user_id;

+

+

+ foreach ($user_ids as $user_id)

+ {

+ if (!isset($user_fields[$user_id][$used_ident]) && $this->profile_cache[$used_ident]['field_show_novalue'])

+ {

+ $user_fields[$user_id][$used_ident]['value'] = '';

+ $user_fields[$user_id][$used_ident]['data'] = $this->profile_cache[$used_ident];

+ }

+ }

+ if ($value === '' && !$ident_ary['data']['field_show_novalue'])

+ if (!$value && !$ident_ary['data']['field_show_novalue'])

+ if (!$day && !$month && !$year && !$ident_ary['data']['field_show_novalue'])

+ if ($value == $ident_ary['data']['field_novalue'] && !$ident_ary['data']['field_show_novalue'])

+ if ($ident_ary['data']['field_show_novalue'])

+ {

+ $value = $ident_ary['data']['field_novalue'];

+ }

+ else

+ {

+ return NULL;

+ }

+ if (!$value && $ident_ary['data']['field_show_novalue'])

+ {

+ $value = $ident_ary['data']['field_default_value'];

+ }

+

+ $remote_max_filesize = $this->max_filesize;

+ if (!$remote_max_filesize)

+ {

+ $max_filesize = @ini_get('upload_max_filesize');

+

+ if (!empty($max_filesize))

+ {

+ $unit = strtolower(substr($max_filesize, -1, 1));

+ $remote_max_filesize = (int) $max_filesize;

+

+ switch ($unit)

+ {

+ case 'g':

+ $remote_max_filesize *= 1024;

+ // no break

+ case 'm':

+ $remote_max_filesize *= 1024;

+ // no break

+ case 'k':

+ $remote_max_filesize *= 1024;

+ // no break

+ }

+ }

+ }

+

+ if ($remote_max_filesize && $filesize > $remote_max_filesize)

+ $max_filesize = get_formatted_filesize($remote_max_filesize, false);

+ if ($remote_max_filesize && $length && $length > $remote_max_filesize)

+ $max_filesize = get_formatted_filesize($remote_max_filesize, false);

+ // Clean the private messages tables from the user

+ if (!function_exists('phpbb_delete_user_pms'))

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

+ phpbb_delete_user_pms($user_id);

+ if (!function_exists('phpbb_update_rows_avoiding_duplicates_notify_status'))

+ {

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

+ }

+

+ // Update the topic watch table.

+ phpbb_update_rows_avoiding_duplicates_notify_status($db, TOPICS_WATCH_TABLE, 'topic_id', $topic_ids, $to_topic_id);

+ // Update the bookmarks table.

+ phpbb_update_rows_avoiding_duplicates($db, BOOKMARKS_TABLE, 'topic_id', $topic_ids, $to_topic_id);

+ // Copy topic subscriptions to new topic

+

+ // Copy bookmarks to new topic

+ $sql = 'SELECT user_id

+ FROM ' . BOOKMARKS_TABLE . '

+ WHERE topic_id = ' . $topic_id;

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

+

+ $sql_ary = array();

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

+ {

+ $sql_ary[] = array(

+ 'topic_id' => (int) $new_topic_id,

+ 'user_id' => (int) $row['user_id'],

+ );

+ }

+ $db->sql_freeresult($result);

+

+ if (sizeof($sql_ary))

+ {

+ $db->sql_multi_insert(BOOKMARKS_TABLE, $sql_ary);

+ }

+ $report['report_text'] = make_clickable(bbcode_nl2br($report['report_text']));

+ // Copy topic subscriptions to new topic

+ $sql = 'SELECT user_id, notify_status

+ FROM ' . TOPICS_WATCH_TABLE . '

+ WHERE topic_id = ' . $topic_id;

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

+

+ $sql_ary = array();

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

+ {

+ $sql_ary[] = array(

+ 'topic_id' => (int) $to_topic_id,

+ 'user_id' => (int) $row['user_id'],

+ 'notify_status' => (int) $row['notify_status'],

+ );

+ }

+ $db->sql_freeresult($result);

+

+ if (sizeof($sql_ary))

+ {

+ $db->sql_multi_insert(TOPICS_WATCH_TABLE, $sql_ary);

+ }

+

+ // Copy bookmarks to new topic

+ $sql = 'SELECT user_id

+ FROM ' . BOOKMARKS_TABLE . '

+ WHERE topic_id = ' . $topic_id;

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

+

+ $sql_ary = array();

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

+ {

+ $sql_ary[] = array(

+ 'topic_id' => (int) $to_topic_id,

+ 'user_id' => (int) $row['user_id'],

+ );

+ }

+ $db->sql_freeresult($result);

+

+ if (sizeof($sql_ary))

+ {

+ $db->sql_multi_insert(BOOKMARKS_TABLE, $sql_ary);

+ }

+

+ if (!function_exists('phpbb_update_rows_avoiding_duplicates_notify_status'))

+ {

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

+ }

+

+ phpbb_update_rows_avoiding_duplicates_notify_status($db, TOPICS_WATCH_TABLE, 'topic_id', $topic_ids, $to_topic_id);

+ // If the topic no longer exist, we will update the bookmarks table.

+ phpbb_update_rows_avoiding_duplicates($db, BOOKMARKS_TABLE, 'topic_id', $topic_id, $to_topic_id);

+ * @return null

+ $alter[] = 'MODIFY post_subject varchar(255) COLLATE utf8_unicode_ci DEFAULT \'\' NOT NULL';

+ // if no session id is set, redirect to index.php

+ if (defined('NEED_SID') && (!isset($_GET['sid']) || $this->session_id !== $_GET['sid']))

+ {

+ send_status_line(401, 'Not authorized');

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

+ }

+

+ // if session id is set

+ if (!empty($this->session_id))

+ 'signature' => array('title' => 'UCP_PROFILE_SIGNATURE', 'auth' => 'acl_u_sig', 'cat' => array('UCP_PROFILE')),

+ $save_message = ($action === 'edit') ? $user->lang['MESSAGE_EDITED'] : $user->lang['MESSAGE_STORED'];

+ $message = $save_message . '<br /><br />' . $user->lang('VIEW_PRIVATE_MESSAGE', '<a href="' . $return_message_url . '">', '</a>');

+ // Prevent users from flooding the rules table

+ $sql = 'SELECT COUNT(rule_id) AS num_rules

+ FROM ' . PRIVMSGS_RULES_TABLE . '

+ WHERE user_id = ' . (int) $user->data['user_id'];

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

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

+ $db->sql_freeresult($result);

+

+ if ($num_rules >= 5000)

+ {

+ trigger_error('RULE_LIMIT_REACHED');

+ }

+

+ // Set the user_message_rules bit

+ // Unset the user_message_rules bit

+ // check if there are any user-selectable languages

+ $sql = 'SELECT COUNT(lang_id) as languages_count

+ FROM ' . LANG_TABLE;

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

+ if ($db->sql_fetchfield('languages_count') > 1)

+ {

+ $s_more_languages = true;

+ }

+ else

+ {

+ $s_more_languages = false;

+ }

+ $db->sql_freeresult($result);

+

+ // check if there are any user-selectable styles

+ $sql = 'SELECT COUNT(style_id) as styles_count

+ FROM ' . STYLES_TABLE . '

+ WHERE style_active = 1';

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

+ if ($db->sql_fetchfield('styles_count') > 1)

+ {

+ $s_more_styles = true;

+ }

+ else

+ {

+ $s_more_styles = false;

+ }

+ $db->sql_freeresult($result);

+

+ 'S_MORE_LANGUAGES' => $s_more_languages,

+ 'S_MORE_STYLES' => $s_more_styles,

+

+ 'phpbb_version' => '3.0.11',

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

+define('UPDATES_TO_VERSION', '3.0.12-dev');

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

+ // 3.0.12 after the db_tools class is capable of properly

+ // Changes from 3.0.11-RC1 to 3.0.11-RC2

+ '3.0.11-RC1' => array(

+ 'add_columns' => array(

+ PROFILE_FIELDS_TABLE => array(

+ 'field_show_novalue' => array('BOOL', 0),

+ ),

+ ),

+ ),

+ // No changes from 3.0.11-RC2 to 3.0.11

+ '3.0.11-RC2' => array(),

+ // No changes from 3.0.11 to 3.0.12-RC1

+ '3.0.11' => array(),

+ /** @todo DROP LOGIN_ATTEMPT_TABLE.attempt_id in 3.0.12-RC1 */

+ global $db, $db_tools, $errored, $error_ary, $config, $table_prefix, $phpbb_root_path, $phpEx;

+ /*

+ * Due to a bug, vanilla phpbb could not create captcha tables

+ * in 3.0.8 on firebird. It was possible for board administrators

+ * to adjust the code to work. If code was manually adjusted by

+ * board administrators, index names would not be the same as

+ * what 3.0.9 and newer expect. This code fragment drops captcha

+ * tables, destroying all entered Q&A captcha configuration, such

+ * that when Q&A is configured next the respective tables will be

+ * created with correct index names.

+ *

+ * If you wish to preserve your Q&A captcha configuration, you can

+ * manually rename indexes to the currently expected name:

+ * phpbb_captcha_questions_lang_iso => phpbb_captcha_questions_lang

+ * phpbb_captcha_answers_question_id => phpbb_captcha_answers_qid

+ *

+ * Again, this needs to be done only if a board was manually modified

+ * to fix broken captcha code.

+ *

+ $changes = array(

+ 'drop_tables' => array(

+ $table_prefix . 'captcha_questions',

+ $table_prefix . 'captcha_answers',

+ $table_prefix . 'qa_confirm',

+ ),

+ $statements = $db_tools->perform_schema_changes($changes);

+

+ foreach ($statements as $sql)

+ _sql($sql, $errored, $error_ary);

+ */

+

+ // Delete orphan private messages

+ $batch_size = 500;

+

+ $sql_array = array(

+ 'SELECT' => 'p.msg_id',

+ 'FROM' => array(

+ PRIVMSGS_TABLE => 'p',

+ ),

+ 'LEFT_JOIN' => array(

+ array(

+ 'FROM' => array(PRIVMSGS_TO_TABLE => 't'),

+ 'ON' => 'p.msg_id = t.msg_id',

+ ),

+ ),

+ 'WHERE' => 't.user_id IS NULL',

+ );

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

+

+ do

+ {

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

+

+ $delete_pms = array();

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

+ {

+ $delete_pms[] = (int) $row['msg_id'];

+ }

+ $db->sql_freeresult($result);

+

+ if (!empty($delete_pms))

+ {

+ $sql = 'DELETE FROM ' . PRIVMSGS_TABLE . '

+ WHERE ' . $db->sql_in_set('msg_id', $delete_pms);

+ _sql($sql, $errored, $error_ary);

+ }

+ }

+ while (sizeof($delete_pms) == $batch_size);

+

+ $no_updates = false;

+ break;

+

+ // No changes from 3.0.11-RC1 to 3.0.11-RC2

+ case '3.0.11-RC1':

+ break;

+

+ // No changes from 3.0.11-RC2 to 3.0.11

+ case '3.0.11-RC2':

+ break;

+

+ // Changes from 3.0.11 to 3.0.12-RC1

+ case '3.0.11':

+ $sql = 'UPDATE ' . MODULES_TABLE . '

+ SET module_auth = \'acl_u_sig\'

+ WHERE module_class = \'ucp\'

+ AND module_basename = \'profile\'

+ AND module_mode = \'signature\'';

+ _sql($sql, $errored, $error_ary);

+

+ // Update bots

+ if (!function_exists('user_delete'))

+ {

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

+ }

+

+ $bots_updates = array(

+ // Bot Deletions

+ 'NG-Search [Bot]' => false,

+ 'Nutch/CVS [Bot]' => false,

+ 'OmniExplorer [Bot]' => false,

+ 'Seekport [Bot]' => false,

+ 'Synoo [Bot]' => false,

+ 'WiseNut [Bot]' => false,

+

+ // Bot Updates

+ // Bot name to bot user agent map

+ 'Baidu [Spider]' => 'Baiduspider',

+ 'Exabot [Bot]' => 'Exabot',

+ 'Voyager [Bot]' => 'voyager/',

+ 'W3C [Validator]' => 'W3C_Validator',

+ );

+

+ foreach ($bots_updates as $bot_name => $bot_agent)

+ {

+ $sql = 'SELECT user_id

+ FROM ' . USERS_TABLE . '

+ WHERE user_type = ' . USER_IGNORE . "

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

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

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

+ $db->sql_freeresult($result);

+

+ if ($bot_user_id)

+ {

+ if ($bot_agent === false)

+ {

+ $sql = 'DELETE FROM ' . BOTS_TABLE . "

+ WHERE user_id = $bot_user_id";

+ _sql($sql, $errored, $error_ary);

+

+ user_delete('remove', $bot_user_id);

+ }

+ else

+ {

+ $sql = 'UPDATE ' . BOTS_TABLE . "

+ SET bot_agent = '" . $db->sql_escape($bot_agent) . "'

+ WHERE user_id = $bot_user_id";

+ _sql($sql, $errored, $error_ary);

+ }

+ }

+ }

+

+ // Disable receiving pms for bots

+ $sql = 'SELECT user_id

+ FROM ' . BOTS_TABLE;

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

+

+ $bot_user_ids = array();

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

+ {

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

+ }

+ $db->sql_freeresult($result);

+

+ if (!empty($bot_user_ids))

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_allow_pm = 0

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

+ _sql($sql, $errored, $error_ary);

+ }

+

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

+ global $lang, $template, $language, $phpbb_root_path, $cache;

+ $cache->purge();

+

+ $sql_query = phpbb_remove_comments($sql_query);

+ $sql_query = phpbb_remove_comments($sql_query);

+ 'user_allow_pm' => 0,

+ 'Baidu [Spider]' => array('Baiduspider', ''),

+ 'Bing [Bot]' => array('bingbot/', ''),

+ 'Exabot [Bot]' => array('Exabot', ''),

+ 'Voyager [Bot]' => array('voyager/', ''),

+ 'W3C [Validator]' => array('W3C_Validator', ''),

+ field_show_novalue INTEGER DEFAULT 0 NOT NULL,

+ [field_show_novalue] [int] DEFAULT (0) NOT NULL ,

+ field_show_novalue tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ field_show_novalue tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

+ field_show_novalue number(1) DEFAULT '0' NOT NULL,

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

+INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '3.0.12-dev');

+ field_show_novalue INTEGER UNSIGNED NOT NULL DEFAULT '0',

+ 'ATTACH_MAX_FILESIZE_EXPLAIN' => 'Maximum size of each file. If this value is 0, the uploadable filesize is only limited by your PHP configuration.',

+ 'WARNINGS_EXPIRE_EXPLAIN' => 'Number of days that will elapse before a warning will automatically expire from a user’s record. Set this value to 0 to make warnings permanent.',

+ 'MAX_FILESIZE_EXPLAIN' => 'For uploaded avatar files. If this value is 0, the uploaded filesize is only limited by your PHP configuration.',

+ 'SHOW_NOVALUE_FIELD' => 'Show field if no value was selected',

+ 'SHOW_NOVALUE_FIELD_EXPLAIN' => 'Determines if the profile field should be displayed if no value was selected for optional fields or if no value has been selected yet for required fields.',

+ 'DELETE_USER_EXPLAIN' => 'Please note that deleting a user is final, they cannot be recovered. Unread private messages sent by this user will be deleted and will not be available to their recipients.',

+ 'USER_NO_POSTS_TO_DELETE' => 'The user has no posts to retain or delete.',

+ 'TB' => 'TB',

+ 'TIB' => 'TiB',

+You are receiving this notification because you are watching the forum, "{FORUM_NAME}" at "{SITENAME}". This forum has received a new reply to the topic "{TOPIC_TITLE}"<!-- IF AUTHOR_NAME --> by {AUTHOR_NAME}<!-- ENDIF --> since your last visit. You can use the following link to view the last unread reply, no more notifications will be sent until you visit the topic.

+You are receiving this notification because you are watching the forum, "{FORUM_NAME}" at "{SITENAME}". This forum has received a new topic<!-- IF AUTHOR_NAME --> by {AUTHOR_NAME}<!-- ENDIF --> since your last visit, "{TOPIC_TITLE}". You can use the following link to view the forum, no more notifications will be sent until you visit the forum.

+You are receiving this notification because you are watching the topic, "{TOPIC_TITLE}" at "{SITENAME}". This topic has received a reply<!-- IF AUTHOR_NAME --> by {AUTHOR_NAME}<!-- ENDIF --> since your last visit. You can use the following link to view the replies made, no more notifications will be sent until you visit the topic.

+ 'SEARCHED_QUERY' => 'Searched query',

+ 'CURRENT_PASSWORD_EXPLAIN' => 'You must enter your current password if you wish to alter your email address or username.',

+ 'CURRENT_CHANGE_PASSWORD_EXPLAIN' => 'To change your password, your email address, or your username, you must enter your current password.',

+ 'MESSAGE_EDITED' => 'Message successfully edited.',

+ 'MESSAGE_REMOVED_FROM_OUTBOX' => 'This message was deleted by its author.',

+ 'RULE_LIMIT_REACHED' => 'You cannot add more PM rules. You have reached the maximum number of rules.',

+ if ($forum_type != FORUM_POST || !$auth->acl_get('f_post', $to_forum_id) || !$auth->acl_get('f_noapprove', $to_forum_id))

+ // Check the permissions for post approval.

+ // Moderators must go through post approval like ordinary users.

+ if ((!$auth->acl_get('f_noapprove', $data['forum_id']) && empty($data['force_approved_state'])) || (isset($data['force_approved_state']) && !$data['force_approved_state']))

+ 'SEARCH_WORDS' => $keywords,

+ 'SEARCHED_QUERY' => $search->search_query,

+version = 3.0.11

+version = 3.0.11 \ No newline at end of file

+ <!-- IF to_recipient.IS_GROUP --><a href="{to_recipient.U_VIEW}"><strong>{to_recipient.NAME}</strong></a><!-- ELSE -->{to_recipient.NAME_FULL}<!-- ENDIF -->&nbsp;

+ <!-- IF bcc_recipient.IS_GROUP --><a href="{bcc_recipient.U_VIEW}"><strong>{bcc_recipient.NAME}</strong></a><!-- ELSE -->{bcc_recipient.NAME_FULL}<!-- ENDIF -->&nbsp;

+ <!-- IF to_recipient.IS_GROUP --><a href="{to_recipient.U_VIEW}"><strong>{to_recipient.NAME}</strong></a><!-- ELSE -->{to_recipient.NAME_FULL}<!-- ENDIF -->&nbsp;

+ <dd><a href="{attach_row.U_VIEW_ATTACHMENT}">{attach_row.FILENAME}</a></dd>

+<!-- IF SEARCHED_QUERY --> <p>{L_SEARCHED_QUERY}: <strong>{SEARCHED_QUERY}</strong></p><!-- ENDIF -->

+version = 3.0.11

+ <dd class="mark"><input type="radio" name="selected" value="{pending.GROUP_ID}" <!-- IF pending.GROUP_SPECIAL -->disabled="disabled"<!-- ENDIF --> /></dd>

+ <p>{SITE_DESCRIPTION}</p>

+ <h2>{L_PRIVATE_MESSAGING}</h2>

+ <div class="copyright">Powered by phpBB&reg; Forum Software &copy; phpBB Group<br />https://www.phpbb.com/</div>

+ <!-- IF S_MORE_LANGUAGES -->

+ <dl>

+ <dt><label for="lang">{L_BOARD_LANGUAGE}:</label></dt>

+ <dd><select name="lang" id="lang">{S_LANG_OPTIONS}</select></dd>

+ </dl>

+ <!-- ENDIF -->

+ <!-- IF S_STYLE_OPTIONS and S_MORE_STYLES -->

+ <dt><label for="cur_password">{L_CURRENT_PASSWORD}:</label><br /><span><!-- IF S_CHANGE_PASSWORD -->{L_CURRENT_CHANGE_PASSWORD_EXPLAIN}<!-- ELSE -->{L_CURRENT_PASSWORD_EXPLAIN}<!-- ENDIF --></span></dt>

+ {S_HIDDEN_FIELDS}<input type="reset" value="{L_RESET}" name="reset" class="button2" />&nbsp;

+ <div class="copyright">Powered by phpBB&reg; Forum Software &copy; phpBB Group<br />https://www.phpbb.com/</div>