+/phpBB/cache/*.lock

+ - 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 pear install --force phpunit/DbUnit; phpenv rehash; fi"

+ - cd phpBB

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

+ - cd ..

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

+ - sh -c "if [ '$TRAVIS_PHP_VERSION' = '5.2' ]; then phpunit --configuration travis/phpunit-$DB-travis.xml; else phpBB/vendor/bin/phpunit --configuration travis/phpunit-$DB-travis.xml; fi"

+

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

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

+ <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, 3.0.12-RC1, 3.0.12-RC2, 3.0.12-RC3" />

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

+ command="phpBB/vendor/bin/phpunit

+ --log-junit build/logs/phpunit.xml

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

+ command="phpBB/vendor/bin/phpunit

+ --log-junit build/logs/phpunit.xml

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

+

+ <!-- Install composer dependencies, if there are any. -->

+ <exec dir="."

+ command='php -r "\$j = json_decode(file_get_contents("composer.json")); echo isset(\$j->require);"'

+ checkreturn="true"

+ outputProperty='composer-has-dependencies' />

+ <if>

+ <equals arg1="${composer-has-dependencies}" arg2="1" trim="true" />

+ <then>

+ <!-- We have non-dev composer dependencies -->

+ <exec dir="."

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

+ checkreturn="true"

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

+ <if>

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

+ <then>

+ <fail message="There are composer dependencies, but composer.phar is missing." />

+ </then>

+ <else>

+ <!-- Export the phar, install dependencies, delete phar. -->

+ <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" />

+ </else>

+ </if>

+ </then>

+ <else>

+ <!-- We do not have composer dependencies, do not ship composer files -->

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

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

+ </else>

+ </if>

+

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

+ result=$(git cat-file -p $sha | "$PHP_BIN" -n -l -ddisplay_errors\=1 -derror_reporting\=E_ALL -dlog_errrors\=0 2>&1)

+ errors=$(echo "$errors"; echo "$result" | grep ':' | sed -e "s@in - on@in $filename on@g")

+if [ -n "$errors" ]

+ echo "PHP Syntax check failed: "

+ $echo_e "$errors"

+ run("phpBB/vendor/bin/phpunit");

+ run("phpBB/vendor/bin/phpunit");

+ run("phpBB/vendor/bin/phpunit");

+ return api_url_request("https://api.github.com/$query?per_page=100");

+}

+

+function api_url_request($url)

+{

+ $contents = file_get_contents($url, false, stream_context_create(array(

+ 'http' => array(

+ 'header' => "User-Agent: phpBB/1.0\r\n",

+ ),

+ )));

+ $contents = json_decode($contents);

+

+ if (isset($contents->message) && strpos($contents->message, 'API Rate Limit') === 0)

+ {

+ throw new RuntimeException('Reached github API Rate Limit. Please try again later' . "\n", 4);

+ }

+ return $contents;

+ $request = api_request("repos/$username/$repository/pulls/$pull_id");

+ echo "Usage: [php] $filename -s collaborators|organisation|contributors|forks [OPTIONS]\n";

+ echo " forks All repositories of the whole github network\n";

+ $forks = get_forks($username, $repository);

+ if ($forks === false || $collaborators === false)

+ echo "Error: failed to retrieve forks or collaborators\n";

+ $remotes = array_intersect_key($forks, $collaborators);

+ $remotes = array_intersect_key($forks, get_organisation_members($username));

+ $remotes = array_intersect_key($forks, get_contributors($username, $repository));

+ case 'forks':

+ $remotes = $forks;

+ return api_url_request("https://api.github.com/$query?per_page=100");

+}

+

+function api_url_request($url)

+{

+ $contents = file_get_contents($url, false, stream_context_create(array(

+ 'http' => array(

+ 'header' => "User-Agent: phpBB/1.0\r\n",

+ ),

+ )));

+

+ $sub_request_result = array();

+ // Check headers for pagination links

+ if (!empty($http_response_header))

+ {

+ foreach ($http_response_header as $header_element)

+ {

+ // Find Link Header which gives us a link to the next page

+ if (strpos($header_element, 'Link: ') === 0)

+ {

+ list($head, $header_content) = explode(': ', $header_element);

+ foreach (explode(', ', $header_content) as $links)

+ {

+ list($url, $rel) = explode('; ', $links);

+ if ($rel == 'rel="next"')

+ {

+ // Found a next link, follow it and merge the results

+ $sub_request_result = api_url_request(substr($url, 1, -1));

+ }

+ }

+ }

+ }

+ }

+

+ $contents = json_decode($contents);

+

+ if (isset($contents->message) && strpos($contents->message, 'API Rate Limit') === 0)

+ {

+ throw new RuntimeException('Reached github API Rate Limit. Please try again later' . "\n", 4);

+ }

+

+ return ($sub_request_result) ? array_merge($sub_request_result, $contents) : $contents;

+ $request = api_request("repos/$username/$repository/stats/contributors");

+ foreach ($request as $contribution)

+ $usernames[$contribution->author->login] = $contribution->author->login;

+ $request = api_request("orgs/$username/public_members");

+ foreach ($request as $member)

+ $request = api_request("repos/$username/$repository/collaborators");

+ foreach ($request as $collaborator)

+ $usernames[$collaborator->login] = $collaborator->login;

+function get_forks($username, $repository)

+ $request = api_request("repos/$username/$repository/forks");

+ foreach ($request as $fork)

+ $usernames[$fork->owner->login] = array(

+ 'username' => $fork->owner->login,

+ 'repository' => $fork->name,

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

+ case 'email':

+ if (!preg_match('/^' . get_preg_expression('email') . '$/i', $cfg_array[$config_name]))

+ {

+ $error[] = $user->lang['EMAIL_INVALID_EMAIL'];

+ }

+ break;

+

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

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

+ </dd>

+ 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

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

+{

+ "require-dev": {

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

+ "phpunit/dbunit": "1.2.*",

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

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

+ }

+}

+{

+ "_readme": [

+ "This file locks the dependencies of your project to a known state",

+ "Read more about it at http://getcomposer.org/doc/01-basic-usage.md#composer-lock-the-lock-file"

+ ],

+ "hash": "ef6d05965cca4e390fff7ce63e9d2d49",

+ "packages": [

+

+ ],

+ "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": {

+ "ext-curl": "*",

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

+ "php": ">=5.3.0",

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

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

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

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

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

+ },

+ "type": "application",

+ "extra": {

+ "branch-alias": {

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

+ }

+ },

+ "autoload": {

+ "psr-0": {

+ "Goutte": "."

+ }

+ },

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

+ "license": [

+ "MIT"

+ ],

+ "authors": [

+ {

+ "name": "Fabien Potencier",

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

+ }

+ ],

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

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

+ "keywords": [

+ "scraper"

+ ],

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

+ },

+ {

+ "name": "guzzle/guzzle",

+ "version": "v3.0.7",

+ "source": {

+ "type": "git",

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

+ "reference": "v3.0.7"

+ },

+ "dist": {

+ "type": "zip",

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

+ "reference": "v3.0.7",

+ "shasum": ""

+ },

+ "require": {

+ "ext-curl": "*",

+ "php": ">=5.3.2",

+ "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": "*",

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

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

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

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

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

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

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

+ },

+ "type": "library",

+ "extra": {

+ "branch-alias": {

+ "dev-master": "3.0-dev"

+ }

+ },

+ "autoload": {

+ "psr-0": {

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

+ "Guzzle": "src/"

+ }

+ },

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

+ "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": [

+ "client",

+ "curl",

+ "framework",

+ "http",

+ "http client",

+ "rest",

+ "web service"

+ ],

+ "time": "2012-12-19 23:06:35"

+ },

+ {

+ "name": "phing/phing",

+ "version": "2.4.14",

+ "source": {

+ "type": "git",

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

+ "reference": "2.4.14"

+ },

+ "dist": {

+ "type": "zip",

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

+ "reference": "2.4.14",

+ "shasum": ""

+ },

+ "require": {

+ "php": ">=5.2.0"

+ },

+ "bin": [

+ "bin/phing"

+ ],

+ "type": "library",

+ "autoload": {

+ "classmap": [

+ "classes/phing/"

+ ]

+ },

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

+ "include-path": [

+ "classes"

+ ],

+ "license": [

+ "LGPL3"

+ ],

+ "authors": [

+ {

+ "name": "Michiel Rook",

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

+ },

+ {

+ "name": "Phing Community",

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

+ }

+ ],

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

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

+ "keywords": [

+ "build",

+ "task",

+ "tool"

+ ],

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

+ },

+ {

+ "name": "phpunit/dbunit",

+ "version": "1.2.3",

+ "source": {

+ "type": "git",

+ "url": "https://github.com/sebastianbergmann/dbunit.git",

+ "reference": "1.2.3"

+ },

+ "dist": {

+ "type": "zip",

+ "url": "https://api.github.com/repos/sebastianbergmann/dbunit/zipball/1.2.3",

+ "reference": "1.2.3",

+ "shasum": ""

+ },

+ "require": {

+ "ext-pdo": "*",

+ "ext-simplexml": "*",

+ "php": ">=5.3.3",

+ "phpunit/phpunit": ">=3.7.0@stable"

+ },

+ "bin": [

+ "dbunit.php"

+ ],

+ "type": "library",

+ "extra": {

+ "branch-alias": {

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

+ }

+ },

+ "autoload": {

+ "classmap": [

+ "PHPUnit/"

+ ]

+ },

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

+ "include-path": [

+ "",

+ "../../symfony/yaml/"

+ ],

+ "license": [

+ "BSD-3-Clause"

+ ],

+ "authors": [

+ {

+ "name": "Sebastian Bergmann",

+ "email": "sb@sebastian-bergmann.de",

+ "role": "lead"

+ }

+ ],

+ "description": "DbUnit port for PHP/PHPUnit to support database interaction testing.",

+ "homepage": "https://github.com/sebastianbergmann/dbunit/",

+ "keywords": [

+ "database",

+ "testing",

+ "xunit"

+ ],

+ "time": "2013-03-01 11:50:46"

+ },

+ {

+ "name": "phpunit/php-code-coverage",

+ "version": "1.2.12",

+ "source": {

+ "type": "git",

+ "url": "https://github.com/sebastianbergmann/php-code-coverage.git",

+ "reference": "1.2.12"

+ },

+ "dist": {

+ "type": "zip",

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

+ "reference": "1.2.12",

+ "shasum": ""

+ },

+ "require": {

+ "php": ">=5.3.3",

+ "phpunit/php-file-iterator": ">=1.3.0@stable",

+ "phpunit/php-text-template": ">=1.1.1@stable",

+ "phpunit/php-token-stream": ">=1.1.3@stable"

+ },

+ "require-dev": {

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

+ },

+ "suggest": {

+ "ext-dom": "*",

+ "ext-xdebug": ">=2.0.5"

+ },

+ "type": "library",

+ "extra": {

+ "branch-alias": {

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

+ }

+ },

+ "autoload": {

+ "classmap": [

+ "PHP/"

+ ]

+ },

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

+ "include-path": [

+ ""

+ ],

+ "license": [

+ "BSD-3-Clause"

+ ],

+ "authors": [

+ {

+ "name": "Sebastian Bergmann",

+ "email": "sb@sebastian-bergmann.de",

+ "role": "lead"

+ }

+ ],

+ "description": "Library that provides collection, processing, and rendering functionality for PHP code coverage information.",

+ "homepage": "https://github.com/sebastianbergmann/php-code-coverage",

+ "keywords": [

+ "coverage",

+ "testing",

+ "xunit"

+ ],

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

+ },

+ {

+ "name": "phpunit/php-file-iterator",

+ "version": "1.3.3",

+ "source": {

+ "type": "git",

+ "url": "git://github.com/sebastianbergmann/php-file-iterator.git",

+ "reference": "1.3.3"

+ },

+ "dist": {

+ "type": "zip",

+ "url": "https://github.com/sebastianbergmann/php-file-iterator/zipball/1.3.3",

+ "reference": "1.3.3",

+ "shasum": ""

+ },

+ "require": {

+ "php": ">=5.3.3"

+ },

+ "type": "library",

+ "autoload": {

+ "classmap": [

+ "File/"

+ ]

+ },

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

+ "include-path": [

+ ""

+ ],

+ "license": [

+ "BSD-3-Clause"

+ ],

+ "authors": [

+ {

+ "name": "Sebastian Bergmann",

+ "email": "sb@sebastian-bergmann.de",

+ "role": "lead"

+ }

+ ],

+ "description": "FilterIterator implementation that filters files based on a list of suffixes.",

+ "homepage": "http://www.phpunit.de/",

+ "keywords": [

+ "filesystem",

+ "iterator"

+ ],

+ "time": "2012-10-11 04:44:38"

+ },

+ {

+ "name": "phpunit/php-text-template",

+ "version": "1.1.4",

+ "source": {

+ "type": "git",

+ "url": "git://github.com/sebastianbergmann/php-text-template.git",

+ "reference": "1.1.4"

+ },

+ "dist": {

+ "type": "zip",

+ "url": "https://github.com/sebastianbergmann/php-text-template/zipball/1.1.4",

+ "reference": "1.1.4",

+ "shasum": ""

+ },

+ "require": {

+ "php": ">=5.3.3"

+ },

+ "type": "library",

+ "autoload": {

+ "classmap": [

+ "Text/"

+ ]

+ },

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

+ "include-path": [

+ ""

+ ],

+ "license": [

+ "BSD-3-Clause"

+ ],

+ "authors": [

+ {

+ "name": "Sebastian Bergmann",

+ "email": "sb@sebastian-bergmann.de",

+ "role": "lead"

+ }

+ ],

+ "description": "Simple template engine.",

+ "homepage": "https://github.com/sebastianbergmann/php-text-template/",

+ "keywords": [

+ "template"

+ ],

+ "time": "2012-10-31 11:15:28"

+ },

+ {

+ "name": "phpunit/php-timer",

+ "version": "1.0.4",

+ "source": {

+ "type": "git",

+ "url": "git://github.com/sebastianbergmann/php-timer.git",

+ "reference": "1.0.4"

+ },

+ "dist": {

+ "type": "zip",

+ "url": "https://github.com/sebastianbergmann/php-timer/zipball/1.0.4",

+ "reference": "1.0.4",

+ "shasum": ""

+ },

+ "require": {

+ "php": ">=5.3.3"

+ },

+ "type": "library",

+ "autoload": {

+ "classmap": [

+ "PHP/"

+ ]

+ },

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

+ "include-path": [

+ ""

+ ],

+ "license": [

+ "BSD-3-Clause"

+ ],

+ "authors": [

+ {

+ "name": "Sebastian Bergmann",

+ "email": "sb@sebastian-bergmann.de",

+ "role": "lead"

+ }

+ ],

+ "description": "Utility class for timing",

+ "homepage": "http://www.phpunit.de/",

+ "keywords": [

+ "timer"

+ ],

+ "time": "2012-10-11 04:45:58"

+ },

+ {

+ "name": "phpunit/php-token-stream",

+ "version": "1.1.5",

+ "source": {

+ "type": "git",

+ "url": "git://github.com/sebastianbergmann/php-token-stream.git",

+ "reference": "1.1.5"

+ },

+ "dist": {

+ "type": "zip",

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

+ "reference": "1.1.5",

+ "shasum": ""

+ },

+ "require": {

+ "ext-tokenizer": "*",

+ "php": ">=5.3.3"

+ },

+ "type": "library",

+ "autoload": {

+ "classmap": [

+ "PHP/"

+ ]

+ },

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

+ "include-path": [

+ ""

+ ],

+ "license": [

+ "BSD-3-Clause"

+ ],

+ "authors": [

+ {

+ "name": "Sebastian Bergmann",

+ "email": "sb@sebastian-bergmann.de",

+ "role": "lead"

+ }

+ ],

+ "description": "Wrapper around PHP's tokenizer extension.",

+ "homepage": "http://www.phpunit.de/",

+ "keywords": [

+ "tokenizer"

+ ],

+ "time": "2012-10-11 04:47:14"

+ },

+ {

+ "name": "phpunit/phpunit",

+ "version": "3.7.22",

+ "source": {

+ "type": "git",

+ "url": "https://github.com/sebastianbergmann/phpunit.git",

+ "reference": "3.7.22"

+ },

+ "dist": {

+ "type": "zip",

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

+ "reference": "3.7.22",

+ "shasum": ""

+ },

+ "require": {

+ "ext-dom": "*",

+ "ext-pcre": "*",

+ "ext-reflection": "*",

+ "ext-spl": "*",

+ "php": ">=5.3.3",

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

+ "phpunit/php-file-iterator": ">=1.3.1",

+ "phpunit/php-text-template": ">=1.1.1",

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

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

+ "symfony/yaml": "~2.0"

+ },

+ "require-dev": {

+ "pear-pear/pear": "1.9.4"

+ },

+ "suggest": {

+ "ext-json": "*",

+ "ext-simplexml": "*",

+ "ext-tokenizer": "*",

+ "phpunit/php-invoker": ">=1.1.0,<1.2.0"

+ },

+ "bin": [

+ "composer/bin/phpunit"

+ ],

+ "type": "library",

+ "extra": {

+ "branch-alias": {

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

+ }

+ },

+ "autoload": {

+ "classmap": [

+ "PHPUnit/"

+ ]

+ },

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

+ "include-path": [

+ "",

+ "../../symfony/yaml/"

+ ],

+ "license": [

+ "BSD-3-Clause"

+ ],

+ "authors": [

+ {

+ "name": "Sebastian Bergmann",

+ "email": "sebastian@phpunit.de",

+ "role": "lead"

+ }

+ ],

+ "description": "The PHP Unit Testing framework.",

+ "homepage": "http://www.phpunit.de/",

+ "keywords": [

+ "phpunit",

+ "testing",

+ "xunit"

+ ],

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

+ },

+ {

+ "name": "phpunit/phpunit-mock-objects",

+ "version": "1.2.3",

+ "source": {

+ "type": "git",

+ "url": "git://github.com/sebastianbergmann/phpunit-mock-objects.git",

+ "reference": "1.2.3"

+ },

+ "dist": {

+ "type": "zip",

+ "url": "https://github.com/sebastianbergmann/phpunit-mock-objects/archive/1.2.3.zip",

+ "reference": "1.2.3",

+ "shasum": ""

+ },

+ "require": {

+ "php": ">=5.3.3",

+ "phpunit/php-text-template": ">=1.1.1@stable"

+ },

+ "suggest": {

+ "ext-soap": "*"

+ },

+ "type": "library",

+ "autoload": {

+ "classmap": [

+ "PHPUnit/"

+ ]

+ },

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

+ "include-path": [

+ ""

+ ],

+ "license": [

+ "BSD-3-Clause"

+ ],

+ "authors": [

+ {

+ "name": "Sebastian Bergmann",

+ "email": "sb@sebastian-bergmann.de",

+ "role": "lead"

+ }

+ ],

+ "description": "Mock Object library for PHPUnit",

+ "homepage": "https://github.com/sebastianbergmann/phpunit-mock-objects/",

+ "keywords": [

+ "mock",

+ "xunit"

+ ],

+ "time": "2013-01-13 10:24:48"

+ },

+ {

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

+ "version": "v2.1.11",

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

+ "source": {

+ "type": "git",

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

+ "reference": "v2.1.11"

+ },

+ "dist": {

+ "type": "zip",

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

+ "reference": "v2.1.11",

+ "shasum": ""

+ },

+ "require": {

+ "php": ">=5.3.3",

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

+ },

+ "require-dev": {

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

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

+ },

+ "suggest": {

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

+ },

+ "type": "library",

+ "autoload": {

+ "psr-0": {

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

+ }

+ },

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

+ "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",

+ "time": "2013-04-29 20:22:06"

+ },

+ {

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

+ "version": "v2.1.11",

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

+ "source": {

+ "type": "git",

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

+ "reference": "v2.1.11"

+ },

+ "dist": {

+ "type": "zip",

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

+ "reference": "v2.1.11",

+ "shasum": ""

+ },

+ "require": {

+ "php": ">=5.3.3"

+ },

+ "type": "library",

+ "autoload": {

+ "psr-0": {

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

+ }

+ },

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

+ "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",

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

+ },

+ {

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

+ "version": "v2.1.11",

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

+ "source": {

+ "type": "git",

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

+ "reference": "v2.1.11"

+ },

+ "dist": {

+ "type": "zip",

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

+ "reference": "v2.1.11",

+ "shasum": ""

+ },

+ "require": {

+ "php": ">=5.3.3"

+ },

+ "require-dev": {

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

+ },

+ "suggest": {

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

+ },

+ "type": "library",

+ "autoload": {

+ "psr-0": {

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

+ }

+ },

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

+ "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",

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

+ },

+ {

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

+ "version": "v2.3.1",

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

+ "source": {

+ "type": "git",

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

+ "reference": "v2.3.1"

+ },

+ "dist": {

+ "type": "zip",

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

+ "reference": "v2.3.1",

+ "shasum": ""

+ },

+ "require": {

+ "php": ">=5.3.3"

+ },

+ "require-dev": {

+ "symfony/dependency-injection": ">=2.0,<3.0"

+ },

+ "suggest": {

+ "symfony/dependency-injection": "",

+ "symfony/http-kernel": ""

+ },

+ "type": "library",

+ "extra": {

+ "branch-alias": {

+ "dev-master": "2.3-dev"

+ }

+ },

+ "autoload": {

+ "psr-0": {

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

+ }

+ },

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

+ "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",

+ "time": "2013-05-13 14:36:40"

+ },

+ {

+ "name": "symfony/finder",

+ "version": "v2.1.11",

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

+ "source": {

+ "type": "git",

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

+ "reference": "v2.1.11"

+ },

+ "dist": {

+ "type": "zip",

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

+ "reference": "v2.1.11",

+ "shasum": ""

+ },

+ "require": {

+ "php": ">=5.3.3"

+ },

+ "type": "library",

+ "autoload": {

+ "psr-0": {

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

+ }

+ },

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

+ "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",

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

+ },

+ {

+ "name": "symfony/process",

+ "version": "v2.1.11",

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

+ "source": {

+ "type": "git",

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

+ "reference": "v2.1.11"

+ },

+ "dist": {

+ "type": "zip",

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

+ "reference": "v2.1.11",

+ "shasum": ""

+ },

+ "require": {

+ "php": ">=5.3.3"

+ },

+ "type": "library",

+ "autoload": {

+ "psr-0": {

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

+ }

+ },

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

+ "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",

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

+ },

+ {

+ "name": "symfony/yaml",

+ "version": "v2.3.1",

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

+ "source": {

+ "type": "git",

+ "url": "https://github.com/symfony/Yaml.git",

+ "reference": "v2.3.1"

+ },

+ "dist": {

+ "type": "zip",

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

+ "reference": "v2.3.1",

+ "shasum": ""

+ },

+ "require": {

+ "php": ">=5.3.3"

+ },

+ "type": "library",

+ "extra": {

+ "branch-alias": {

+ "dev-master": "2.3-dev"

+ }

+ },

+ "autoload": {

+ "psr-0": {

+ "Symfony\\Component\\Yaml\\": ""

+ }

+ },

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

+ "license": [

+ "MIT"

+ ],

+ "authors": [

+ {

+ "name": "Fabien Potencier",

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

+ },

+ {

+ "name": "Symfony Community",

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

+ }

+ ],

+ "description": "Symfony Yaml Component",

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

+ "time": "2013-05-10 18:12:13"

+ }

+ ],

+ "aliases": [

+

+ ],

+ "minimum-stability": "stable",

+ "stability-flags": [

+

+ ],

+ "platform": [

+

+ ],

+ "platform-dev": [

+

+ ]

+}

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

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

+* @return null

+* @return null

+* @return null

+ if (isset($dbms_type_map['mysql_40'][$orig_column_type . ':']['limit']) &&

+ isset($dbms_type_map['mysql_40'][$orig_column_type . ':']['limit'][0]))

+ $schema_data['phpbb_login_attempts'] = array(

+ 'COLUMNS' => array(

+ 'attempt_ip' => array('VCHAR:40', ''),

+ 'attempt_browser' => array('VCHAR:150', ''),

+ 'attempt_forwarded_for' => array('VCHAR:255', ''),

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

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

+ 'username' => array('VCHAR_UNI:255', 0),

+ 'username_clean' => array('VCHAR_CI', 0),

+ ),

+ 'KEYS' => array(

+ 'att_ip' => array('INDEX', array('attempt_ip', 'attempt_time')),

+ 'att_for' => array('INDEX', array('attempt_forwarded_for', 'attempt_time')),

+ 'att_time' => array('INDEX', array('attempt_time')),

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

+ ),

+ );

+

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

+* @return null

+phpBB Developers: bantu (Andreas Fischer)

+ EXreaction (Nathan Guse)

+ dhruv.goel92 (Dhruv Goel)

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

+ igorw (Igor Wiedler) [08/2010 - 02/2013]

+ Oleg (Oleg Pudeyev) [01/2011 - 05/2013]

+ rxu (Ruslan Uzdenov) [04/2010 - 12/2012]

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

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

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

+

+<h4>Bug</h4>

+<ul>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11524">PHPBB3-11524</a>] - MySQL Upgrader throws warnings on PHP 5.4</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11720">PHPBB3-11720</a>] - Reporting posts leads to white page error</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11769">PHPBB3-11769</a>] - Wrong poster in subscription email when poster is using the Quote button</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11775">PHPBB3-11775</a>] - Error while moving posts to a new topic</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11802">PHPBB3-11802</a>] - Undefined variable $browser in /download/file.php</li>

+</ul>

+<h4>Improvement</h4>

+<ul>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11740">PHPBB3-11740</a>] - Update link in FAQ to Ideas Centre</li>

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11873">PHPBB3-11873</a>] - Prevent expensive hash computation in phpbb_check_hash() by rejecting very long passwords</li>

+</ul>

+<h4>Sub-task</h4>

+<ul>

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

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

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

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

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

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

+</ul>

+<h4>Task</h4>

+<ul>

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

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

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

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

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

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

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

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

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

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

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

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

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

+<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11752">PHPBB3-11752</a>] - Update phpBB.com URLs to https in email templates</li>

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

+</ul>

+

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

+ <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="https://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.11</strong> you should select the appropriate <code>phpBB-3.0.12-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.11</strong>, you need the <code>phpBB-3.0.12-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.11</strong>, you need the <code>phpBB-3.0.11_to_3.0.12.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>Go to the <a href="https://www.phpbb.com/downloads/">downloads page</a> and download the latest update package listed there, matching your current version.</li>

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

+ <p>Thank you for downloading phpBB3. This README will guide you through the basics of installation and operation of phpBB3. Please ensure you read this and the accompanying documentation fully <strong>before</strong> proceeding with the installation.</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><a href="#bugs">Reporting bugs</a>

+ <p>Installation, update and conversion instructions can be found in the <a href="INSTALL.html">INSTALL</a> document in this directory. If you are intending on converting from a phpBB 2.0.x installation we highly recommend that you backup any existing data before proceeding!</p>

+ <p>Please note that we don't support the following installation types:</p>

+ <li>New installations of phpBB3 - only the latest released 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="https://www.phpbb.com/languages/">Language Packs</a> pages of our downloads section or from the <a href="https://www.phpbb.com/customise/db/language_packs-25/">Language Packs</a> section of the <a href="https://www.phpbb.com/customise/db/">Customisation Database</a>.</p>

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

+ <p>This is the <em>official</em> location for all supported language sets. If you download a package from a 3rd party site you do so with the understanding that we cannot offer support. Please do not ask for support if you download a language pack from a 3rd party site.</p>

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

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

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

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

+ <p><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="https://www.phpbb.com/customise/db/modifications-1/">Modifications</a> section of our <a href="https://www.phpbb.com/customise/db/">Customisation Database</a>.</p>

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

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

+ <p>phpBB3 can sometimes seem a little daunting to new users, particularly with regards to the permission system. The first thing you should do is check the <a href="FAQ.html">FAQ</a>, which covers a few basic getting started questions. If you need additional help there are several places you can find it.</p>

+ <p>Comprehensive documentation is now available on the phpBB website:</p>

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

+ <p>This covers everything from installation to setting permissions and managing users.</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="https://www.phpbb.com/kb/">https://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="https://www.phpbb.com/community/">https://www.phpbb.com/community/</a></p>

+ <p>If you do seek help via our forums please be sure to do a search before posting; if someone has experienced the issue before, then you may find that your question has already been answered. Please remember that phpBB is entirely staffed by volunteers, no one receives any compensation for the time they give, including moderators as well as developers; please be respectful and mindful when awaiting responses and receiving support.</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="https://www.phpbb.com/support/irc/">https://www.phpbb.com/support/irc/</a> for the complete list.</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>

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

+ <li>If no existing bug exists then please feel free to add it</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>Please be as detailed as you can in your report, and if possible, list the steps required to duplicate the problem. If you have a patch that fixes the issue, please attach it to the ticket or submit a pull request to our repository <a href="https://github.com/phpbb/phpbb3">on GitHub</a>.</p>

+ <p><a href="https://www.phpbb.com/security/">https://www.phpbb.com/security/</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>

+ <li>Conversions may fail to complete on large boards under some hosts.</li>

+ <li>Updates may fail to complete on large update sets under some hosts.</li>

+ <p>phpBB is no longer supported on PHP3 due to several compatibility issues and we recommend that you upgrade to the latest stable release of PHP5 to run phpBB. The minimum version required is PHP 4.3.3. The minimum version that will be required for phpBB 3.1 is PHP 5.3.3.</p>

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

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

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

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

+ <p><code>$forum_data</code> should contain at least the <code>forum_id</code> and <code>forum_password</code> fields. If the field <code>forum_name</code> is available, then it is displayed on the forum login page.</p>

+

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

+<a name="disclaimer"></a><h2>7. 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 source code and the docs directory for more details. This package and its contents are Copyright (c) <a href="https://www.phpbb.com/">phpBB Group</a>, All Rights Reserved.</p>

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

+ $sql = 'SELECT p.forum_id, f.forum_name, f.forum_password, f.parent_id

+if ($display_cat == ATTACHMENT_CATEGORY_IMAGE && $mode === 'view' && (strpos($attachment['mimetype'], 'image') === 0) && (strpos(strtolower($user->browser), 'msie') !== false) && !phpbb_is_greater_ie_version($user->browser, 7))

+

+ if ((strpos(strtolower($browser), 'msie') !== false) && !phpbb_is_greater_ie_version($browser, 7))

+

+ if (phpbb_is_greater_ie_version($user->browser, 7))

+ if (empty($user->browser) || ((strpos(strtolower($user->browser), 'msie') !== false) && !phpbb_is_greater_ie_version($user->browser, 7)))

+ if (phpbb_is_greater_ie_version($user->browser, 7) && (strpos($attachment['mimetype'], 'image') !== 0))

+

+ if (strpos(strtolower($browser), 'msie 6.0') === false && !phpbb_is_greater_ie_version($browser, 7))

+/**

+* Check if the browser is internet explorer version 7+

+*

+* @param string $user_agent User agent HTTP header

+* @param int $version IE version to check against

+*

+* @return bool true if internet explorer version is greater than $version

+*/

+function phpbb_is_greater_ie_version($user_agent, $version)

+{

+ if (preg_match('/msie (\d+)/', strtolower($user_agent), $matches))

+ {

+ $ie_version = (int) $matches[1];

+ return ($ie_version > $version);

+ }

+ else

+ {

+ return false;

+ }

+}

+

+ * @return null

+ * @return null

+ * @return null

+ * @return null

+ * @return null

+ * @return null

+ * @return null

+ * @return null

+ * @return null

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

+ ));

+ 'RELATIVE_URL' => array(

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

+ ),

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

+

+ // Prepend the board url to local relative links

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

+

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

+ 'board_contact' => array('lang' => 'CONTACT_EMAIL', 'validate' => 'email', 'type' => 'text:25:100', 'explain' => true),

+ 'board_email' => array('lang' => 'ADMIN_EMAIL', 'validate' => 'email', 'type' => 'text:25:100', 'explain' => true),

+

+ 'U_ACTION' => $this->u_action,

+ if (!check_form_key($form_key))

+ {

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

+ }

+

+ else if (empty($mark_ary))

+ {

+ trigger_error($user->lang['NO_USERS'] . adm_back_link($this->u_action . '&amp;action=list&amp;g=' . $group_id), E_USER_WARNING);

+ }

+ group_user_attributes('default', $group_id, $mark_ary, false, $group_name, $group_row);

+ trigger_error($user->lang['GROUP_DEFS_UPDATED'] . adm_back_link($this->u_action . '&amp;action=list&amp;g=' . $group_id));

+ }

+ else

+ {

+ confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields(array(

+ 'mark' => $mark_ary,

+ 'g' => $group_id,

+ 'i' => $id,

+ 'mode' => $mode,

+ 'action' => $action))

+ );

+ }

+ break;

+ case 'set_default_on_all':

+ if (confirm_box(true))

+ {

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

+

+ $start = 0;

+ do

+ {

+ $sql = 'SELECT user_id

+ FROM ' . USER_GROUP_TABLE . "

+ WHERE group_id = $group_id

+ ORDER BY user_id";

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

+

+ $mark_ary = array();

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

+ do

+ $mark_ary[] = $row['user_id'];

+ }

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

+ group_user_attributes('default', $group_id, $mark_ary, false, $group_name, $group_row);

+ $start = (sizeof($mark_ary) < 200) ? 0 : $start + 200;

+ else

+ {

+ $start = 0;

+ }

+ $db->sql_freeresult($result);

+ while ($start);

+ if (empty($mark_ary))

+ {

+ trigger_error($user->lang['NO_USERS'] . adm_back_link($this->u_action . '&amp;action=list&amp;g=' . $group_id), E_USER_WARNING);

+ }

+ if (!check_form_key($form_key))

+ {

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

+ }

+

+ /*

+ * Validate the length of "Maximum number of allowed recipients per

+ * private message" setting. We use 16777215 as a maximum because it matches

+ * MySQL unsigned mediumint maximum value which is the lowest amongst DBMSes

+ * supported by phpBB3. Also validate the submitted colour value.

+ */

+ $validation_checks = array(

+ 'max_recipients' => array('num', false, 0, 16777215),

+ 'colour' => array('hex_colour', true),

+ );

+

+ if ($validation_error = validate_data($submit_ary, $validation_checks))

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

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

+ 'U_DEFAULT_ALL' => "{$this->u_action}&amp;action=set_default_on_all&amp;g=$group_id",

+?>

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

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

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

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

+ if (empty($info))

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

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

+define('CONFIRM_REPORT', 4);

+ // remove default cosntraints first

+ // http://msdn.microsoft.com/en-us/library/aa175912%28v=sql.80%29.aspx

+ $statements[] = "DECLARE @drop_default_name VARCHAR(100), @cmd VARCHAR(1000)

+ SET @drop_default_name =

+ (SELECT so.name FROM sysobjects so

+ JOIN sysconstraints sc ON so.id = sc.constid

+ WHERE object_name(so.parent_obj) = '{$table_name}'

+ AND so.xtype = 'D'

+ AND sc.colid = (SELECT colid FROM syscolumns

+ WHERE id = object_id('{$table_name}')

+ AND name = '{$column_name}'))

+ IF @drop_default_name <> ''

+ BEGIN

+ SET @cmd = 'ALTER TABLE [{$table_name}] DROP CONSTRAINT [' + @drop_default_name + ']'

+ EXEC(@cmd)

+ END";

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

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

+ }

+

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

+ }

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

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

+* Sets a configuration option's value.

+*

+* Please note that this function does not update the is_dynamic value for

+* an already existing config option.

+*

+* @param string $config_name The configuration option's name

+* @param string $config_value New configuration value

+* @param bool $is_dynamic Whether this variable should be cached (false) or

+* if it changes too frequently (true) to be

+* efficiently cached.

+*

+* @return null

+* Increments an integer config value directly in the database.

+*

+* @param string $config_name The configuration option's name

+* @param int $increment Amount to increment by

+* @param bool $is_dynamic Whether this variable should be cached (false) or

+* if it changes too frequently (true) to be

+* efficiently cached.

+*

+* @return null

+* @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',

+ ),

+ if (strlen($password) > 4096)

+ {

+ // If the password is too huge, we will simply reject it

+ // and not let the server try to hash it.

+ return false;

+ }

+

+ return (isset($path[0]) && $path[0] == '/' || preg_match('#^[a-z]:[/\\\]#i', $path)) ? true : false;

+/**

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

+}

+

+ 'META' => '<meta http-equiv="refresh" content="' . $time . '; url=' . $url . '" />')

+* @return null

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

+ 'FORUM_NAME' => isset($forum_data['forum_name']) ? $forum_data['forum_name'] : '',

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

+}

+

+/**

+ @fputs($fsock, "GET $directory/$filename HTTP/1.0\r\n");

+ if (empty($info))

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

+ }

+

+ // Apparently an error occurred...

+ * Generates a valid message id to be used in emails

+ *

+ * @return string message id

+ */

+ function generate_message_id()

+ {

+ global $config;

+

+ $domain = 'phpbb.generated';

+ if ($config['server_name'])

+ {

+ $domain = $config['server_name'];

+ }

+ else if (!empty($_SERVER['SERVER_NAME']))

+ {

+ $domain = $_SERVER['SERVER_NAME'];

+ }

+

+ return md5(unique_id(time())) . '@' . $domain;

+ }

+

+ /**

+ $headers[] = 'Message-ID: <' . $this->generate_message_id() . '>';

+ // 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'],

+ // Make sure the image category only holds valid images...

+ if ($cat_id == ATTACHMENT_CATEGORY_IMAGE && !$file->is_image())

+ {

+ $file->remove();

+

+ // If this error occurs a user tried to exploit an IE Bug by renaming extensions

+ // Since the image category is displaying content inline we need to catch this.

+ trigger_error($user->lang['ATTACHED_IMAGE_NOT_IMAGE']);

+ }

+

+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']))

+ // If a username was supplied or the poster is a guest, we will use the supplied username.

+ // Doing it this way we can use "...post by guest-username..." in notifications when

+ // "guest-username" is supplied or ommit the username if it is not.

+ $username = ($username !== '' || !$user->data['is_registered']) ? $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().

+ $undelivered_msg = $delete_ids = array();

+

+ $sql = 'SELECT msg_id