+ - 5.3.3

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

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

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

+ - cd phpBB

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

+ - cd ..

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

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

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

+ <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.11-RC1, 3.0.11-RC2" />

+ <target name="package" depends="clean,prepare,composer,create-package" />

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

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

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

+ <exec dir="./phpBB/"

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

+ passthru="true" />

+ </target>

+

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

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

+

+ <exec dir="${dir}"

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

+ passthru="true" />

+

+# You can configure whether invalid commit messages abort commits:

+#

+# git config phpbb.hooks.commit-msg.fatal true (abort)

+# git config phpbb.hooks.commit-msg.fatal false (warn only, do not abort)

+#

+# The default is to warn only.

+#

+if [ "$(git config --bool $config_ns.fatal)" = "true" ]

+then

+ fatal=1;

+ severity=Error;

+else

+ fatal=0;

+ severity=Warning;

+fi

+

+ if [ $1 -eq 0 ] || [ $1 -eq $ERR_UNKNOWN ]

+ then

+ # success

+ exit 0;

+ elif [ $fatal -eq 0 ]

+ then

+ # problems found but fatal is false

+ complain 'Please run `git commit --amend` and fix the problems mentioned.' 1>&2

+ exit 0;

+ else

+ complain "Aborting commit." 1>&2

+ exit $1;

+ fi

+ complain "$severity: heading should be a sentence beginning with a capital letter." 1>&2

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

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

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

+ </dl>

+ <dl>

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

+ <fieldset>

+ <legend>{L_DELETE_USER}</legend>

+ <dl>

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

+ <dd>

+ <!-- IF USER_HAS_POSTS -->

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

+ <!-- ELSE -->

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

+ <!-- ENDIF -->

+ </dd>

+ </dl>

+ <p class="quick">

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

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

+ {S_FORM_TOKEN}

+ </p>

+ </fieldset>

+ </form>

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

+ height: 54px;

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

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

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

+ height = window.innerHeight - 200;

+ background: transparent;

+ border-right: 1px solid #999;

+ background: #D9D9D9;

+table.hrdiff tbody td {

+ font-family: "Consolas", monospace;

+ font-size: 1.1em;

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

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

+ background: transparent;

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

+

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

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

+ // Eliminate . and .. from the path

+ $script_path = phpbb_clean_path($script_path);

+{

+ "minimum-stability": "beta",

+ "require-dev": {

+ "fabpot/goutte": "1.0.x-dev"

+ }

+}

+{

+ "hash": "a5d02c59e3a91c84c1a96aca0f1ae81a",

+ "packages": [

+

+ ],

+ "packages-dev": [

+ {

+ "package": "fabpot/goutte",

+ "version": "dev-master",

+ "alias-pretty-version": "1.0.x-dev",

+ "alias-version": "1.0.9999999.9999999-dev"

+ },

+ {

+ "package": "fabpot/goutte",

+ "version": "dev-master",

+ "source-reference": "c2ea8d9a6682d14482e57ede2371001b8a5238d2",

+ "commit-date": "1340264258"

+ },

+ {

+ "package": "guzzle/guzzle",

+ "version": "v2.6.6"

+ },

+ {

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

+ "version": "v2.1.0-BETA3"

+ },

+ {

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

+ "version": "v2.1.0-BETA3"

+ },

+ {

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

+ "version": "v2.1.0-BETA3"

+ },

+ {

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

+ "version": "v2.1.0-BETA3"

+ },

+ {

+ "package": "symfony/finder",

+ "version": "v2.1.0-BETA3"

+ },

+ {

+ "package": "symfony/process",

+ "version": "v2.1.0-BETA3"

+ }

+ ],

+ "aliases": [

+

+ ],

+ "minimum-stability": "beta",

+ "stability-flags": {

+ "fabpot/goutte": 20

+ }

+}

+/**

+*

+* @package phpBB3

+* @copyright (c) 2004 phpBB Group

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

+*

+*/

+/**

+*

+* @package phpBB3

+* @copyright (c) 2004 phpBB Group

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

+*

+*/

+/**

+*

+* @package phpBB3

+* @copyright (c) 2003 phpBB Group

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

+*

+*/

+*

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

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

+/**

+*

+* @package phpBB3

+* @copyright (c) 2003 phpBB Group

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

+*

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

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

+*

+/**

+*

+* @package phpBB3

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

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

+*

+*/

+

+/**

+*

+* @package phpBB3

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

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

+*

+*/

+/**

+*

+* @package phpBB3

+* @copyright (c) 2003 phpBB Group

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

+*

+*/

+phpBB Developers: bantu (Andreas Fischer)

+ imkingdavid (David King)

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

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

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

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

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

+ ckwalsh (Cullen Walsh) [01/2010 - 07/2011]

+ kellanved (Henry Sudhof) [04/2007 - 03/2011]

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

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

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

+

+<h4>Bug</h4>

+<ul>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

+</ul>

+<h4>Improvement</h4>

+<ul>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

+</ul>

+<h4>New Feature</h4>

+<ul>

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

+</ul>

+<h4>Sub-task</h4>

+<ul>

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

+</ul>

+<h4>Task</h4>

+<ul>

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

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

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

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

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

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

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

+</ul>

+

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

+ <li><strong>PHP 4.3.3+ (>=4.3.3, >=4.4.x, >=5.x.x, >=5.4.x)</strong> with support for the database you intend to use.</li>

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

+ <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 of language packs, where to obtain them and how to install them please see the <a href="README.html#i18n">README</a>.</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 <samp>3.0.10</samp> you should select the phpBB-3.0.10_to_3.0.11.zip/tar.gz file.</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 <samp>3.0.10</samp> you need the phpBB-3.0.10_to_3.0.11.patch file. Place the correct patch in the parent directory containing the phpBB3 core files (i.e. index.php, viewforum.php, etc.). With this done you should run the following command: <strong>patch -cl -d [PHPBB DIRECTORY] -p1 &lt; [PATCH NAME]</strong> (where PHPBB DIRECTORY is the directory name your phpBB Installation resides in, for example phpBB3, and where PATCH NAME is the relevant filename of the selected patch file). This should complete quickly, hopefully without any HUNK FAILED comments.</p>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

+ <p><strong>Please note</strong> that to improve efficiency, the software caches certain data. For this reason, if you create your own style or modify existing ones, please remember to &quot;Refresh&quot; the appropriate style components <code>Administration Control Panel -&gt; Styles tab -&gt; Style Components</code> screen. You may also need to reload the page you have changed in your web browser to overcome browser caching. If the changed components are not refreshed you will not see your changes taking effect.</p>

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

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

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

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

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

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

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

+

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

+

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

+

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

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

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

+

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

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

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

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

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

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

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

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

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

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

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

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

+

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

+ <p>This board has been developed and tested under Linux and Windows (amongst others) running Apache using MySQL 3.23, 4.x, 5.x, MSSQL Server 2000, PostgreSQL 7.x, Oracle 8, SQLite 2 and Firebird. Versions of PHP used range from 4.3.3 to 5.4.x without problem. </p>

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

+ var $db_tools;

+ if (!class_exists('phpbb_db_tools'))

+ {

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

+ }

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

+

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

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

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

+ 'field_show_novalue'=> 0,

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

+ 'field_show_novalue',

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

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

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

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

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

+ ksort($new_ary);

+

+ $sql = 'SELECT post_id

+ FROM ' . POSTS_TABLE . '

+ WHERE poster_id = '. $user_id;

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

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

+ $db->sql_freeresult($result);

+

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

+ return array(

+ 'status' => LOGIN_ERROR_EXTERNAL_AUTH,

+ 'error_msg' => 'LDAP_NO_SERVER_CONNECTION',

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

+ );

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

+ $statements[] = 'ALTER TABLE ' . $table_name . ' ADD UNIQUE INDEX ' . $index_name . '(' . implode(', ', $column) . ')';

+ * Seek to given row number

+ * rownum is zero-based

+ */

+ function sql_rowseek($rownum, &$query_id)

+ {

+ global $cache;

+

+ if ($query_id === false)

+ {

+ $query_id = $this->query_result;

+ }

+

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

+ {

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

+ }

+

+ if ($query_id === false)

+ {

+ return false;

+ }

+

+ $this->sql_freeresult($query_id);

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

+

+ if ($query_id === false)

+ {

+ return false;

+ }

+

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

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

+ {

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

+ {

+ return false;

+ }

+ }

+

+ return true;

+ }

+

+ /**

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

+ *

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

+ *

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

+ */

+ function sql_lower_text($column_name)

+ {

+ return "LOWER($column_name)";

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ function sql_lower_text($column_name)

+ {

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

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ function sql_lower_text($column_name)

+ {

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

+ }

+

+ /**

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

+ * {@inheritDoc}

+ */

+ function sql_lower_text($column_name)

+ {

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

+ }

+

+ /**

+/**

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

+*

+* @param string $path Path to clean

+* @return string Cleaned path

+*/

+function phpbb_clean_path($path)

+{

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

+ $filtered = array();

+ foreach ($exploded as $part)

+ {

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

+ {

+ continue;

+ }

+

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

+ {

+ array_pop($filtered);

+ }

+ else

+ {

+ $filtered[] = $part;

+ }

+ }

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

+ return $path;

+}

+

+ $sql = 'SELECT t.forum_id

+ FROM ' . TOPICS_TABLE . ' t

+ LEFT JOIN ' . TOPICS_TRACK_TABLE . ' tt

+ ON (tt.topic_id = t.topic_id

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

+ AND (tt.topic_id IS NULL

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

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

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

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

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

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

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

+*

+* @deprecated Use phpbb_remove_comments() instead.

+*/

+function remove_comments(&$output)

+{

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

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

+

+ // Return by reference and value.

+ return $output;

+}

+

+/**

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

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

+ 'COMMENTS' => 'remove_remarks',

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

+/**

+* Creates the output to be stored in a phpBB config.php file

+*

+* @param array $data Array containing the database connection information

+* @param string $dbms The name of the DBAL class to use

+* @param array $load_extensions Array of additional extensions that should be loaded

+* @param bool $debug If the debug constants should be enabled by default or not

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

+* NOTE: Only for use within the testing framework

+*

+* @return string The output to write to the file

+*/

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

+{

+ $load_extensions = implode(',', $load_extensions);

+

+ $config_data = "<?php\n";

+ $config_data .= "// phpBB 3.0.x auto-generated configuration file\n// Do not change anything in this file!\n";

+

+ $config_data_array = array(

+ 'dbms' => $dbms,

+ 'dbhost' => $data['dbhost'],

+ 'dbport' => $data['dbport'],

+ 'dbname' => $data['dbname'],

+ 'dbuser' => $data['dbuser'],

+ 'dbpasswd' => htmlspecialchars_decode($data['dbpasswd']),

+ 'table_prefix' => $data['table_prefix'],

+ 'acm_type' => 'file',

+ 'load_extensions' => $load_extensions,

+ );

+

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

+ {

+ $config_data .= "\${$key} = '" . str_replace("'", "\\'", str_replace('\\', '\\\\', $value)) . "';\n";

+ }

+

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

+

+ if ($debug)

+ {

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

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

+ }

+ else

+ {

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

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

+ }

+

+ if ($debug_test)

+ {

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

+ }

+

+ return $config_data;

+}

+

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

+

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

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

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

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

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

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

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

+*

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

+*

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

+*/

+function phpbb_delete_user_pms($user_id)

+{

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

+

+ $user_id = (int) $user_id;

+

+ if (!$user_id)

+ {

+ return false;

+ }

+

+ // Get PM Information for later deleting

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

+ $undelivered_msg = $delete_ids = array();

+

+ // Part 1: get PMs the user received

+ $sql = 'SELECT msg_id

+ FROM ' . PRIVMSGS_TO_TABLE . '

+ WHERE user_id = ' . $user_id;

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

+

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

+ {

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

+ $delete_ids[$msg_id] = $msg_id;

+ }

+ $db->sql_freeresult($result);

+

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

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

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

+ $sql = 'SELECT msg_id

+ FROM ' . PRIVMSGS_TO_TABLE . '

+ WHERE author_id = ' . $user_id . '

+ AND folder_id = ' . PRIVMSGS_NO_BOX;

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

+

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

+ {

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

+ $undelivered_msg[$msg_id] = $msg_id;

+ }

+ $db->sql_freeresult($result);

+

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

+ {

+ return false;

+ }

+

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

+

+ if (!empty($undelivered_msg))

+ {

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

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

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

+ // received them.

+ $sql = 'SELECT msg_id

+ FROM ' . PRIVMSGS_TO_TABLE . '

+ WHERE author_id = ' . $user_id . '

+ AND folder_id <> ' . PRIVMSGS_NO_BOX . '

+ AND folder_id <> ' . PRIVMSGS_OUTBOX . '

+ AND folder_id <> ' . PRIVMSGS_SENTBOX;

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

+

+ $delivered_msg = array();

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

+ {

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

+ $delivered_msg[$msg_id] = $msg_id;

+ unset($undelivered_msg[$msg_id]);

+ }

+ $db->sql_freeresult($result);

+

+ $undelivered_user = array();

+

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

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

+ FROM ' . PRIVMSGS_TO_TABLE . '

+ WHERE author_id = ' . $user_id . '

+ AND folder_id = ' . PRIVMSGS_NO_BOX . '

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

+ GROUP BY user_id';

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

+

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

+ {

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

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

+

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

+ {

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

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

+ $sql = 'UPDATE ' . USERS_TABLE . '

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

+ user_unread_privmsg = user_unread_privmsg - ' . $num_pms . '

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

+ $db->sql_query($sql);

+ unset($undelivered_user[$num_pms]);

+ }

+ }

+ $db->sql_freeresult($result);

+

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

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . '

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

+ user_unread_privmsg = user_unread_privmsg - ' . $num_pms . '

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

+ $db->sql_query($sql);

+ }

+

+ if (!empty($delivered_msg))

+ {

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

+ WHERE folder_id = ' . PRIVMSGS_NO_BOX . '

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

+ $db->sql_query($sql);

+ }

+

+ if (!empty($undelivered_msg))

+ {

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

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

+ $db->sql_query($sql);

+

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

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

+ $db->sql_query($sql);

+ }

+ }

+

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

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_new_privmsg = 0,

+ user_unread_privmsg = 0

+ WHERE user_id = ' . $user_id;

+ $db->sql_query($sql);

+

+ // Delete private message data of the user

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

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

+ $db->sql_query($sql);

+

+ if (!empty($delete_ids))

+ {

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

+ $sql = 'SELECT msg_id

+ FROM ' . PRIVMSGS_TO_TABLE . '

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

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

+

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

+ {

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

+ }

+ $db->sql_freeresult($result);

+

+ if (!empty($delete_ids))

+ {

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

+ if (!function_exists('delete_attachments'))

+ {

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

+ }

+

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

+

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

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

+ $db->sql_query($sql);

+ }

+ }

+

+ // Set the remaining author id to anonymous

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

+ $sql = 'UPDATE ' . PRIVMSGS_TO_TABLE . '

+ SET author_id = ' . ANONYMOUS . '

+ WHERE author_id = ' . $user_id;

+ $db->sql_query($sql);

+

+ $sql = 'UPDATE ' . PRIVMSGS_TABLE . '

+ SET author_id = ' . ANONYMOUS . '

+ WHERE author_id = ' . $user_id;

+ $db->sql_query($sql);

+

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

+

+ return true;

+}

+

+/**

+

+

+ $user_ids = $user_id;

+

+

+ foreach ($user_ids as $user_id)

+ {

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

+ {

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

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

+ }

+ }

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

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

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

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

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

+ {

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

+ }

+ else

+ {

+ return NULL;

+ }

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

+ {

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

+ }

+

+ $remote_max_filesize = $this->max_filesize;

+ if (!$remote_max_filesize)

+ {

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

+

+ if (!empty($max_filesize))

+ {

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

+ $remote_max_filesize = (int) $max_filesize;

+

+ switch ($unit)

+ {

+ case 'g':

+ $remote_max_filesize *= 1024;

+ // no break

+ case 'm':

+ $remote_max_filesize *= 1024;

+ // no break

+ case 'k':

+ $remote_max_filesize *= 1024;

+ // no break

+ }

+ }

+ }

+

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

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

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

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

+ // Clean the private messages tables from the user

+ if (!function_exists('phpbb_delete_user_pms'))

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

+ phpbb_delete_user_pms($user_id);

+* Verifies whether a style ID corresponds to an active style.

+*

+* @param int $style_id The style_id of a style which should be checked if activated or not.

+* @return boolean

+*/

+function phpbb_style_is_active($style_id)

+{

+ global $db;

+

+ $sql = 'SELECT style_active

+ FROM ' . STYLES_TABLE . '

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

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

+

+ $style_is_active = (bool) $db->sql_fetchfield('style_active');

+ $db->sql_freeresult($result);

+

+ return $style_is_active;

+}

+

+/**

+ get_user_rank($user_row['user_rank'], $user_row['user_posts'], $rank_title, $rank_img, $rank_img_src);

+ get_user_rank($user_row['user_rank'], $user_row['user_posts'], $rank_title, $rank_img, $rank_img_src);

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

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

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

+ {

+ send_status_line(401, 'Not authorized');

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

+ }

+

+ // if session id is set

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

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

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

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

+ // Prevent users from flooding the rules table

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

+ FROM ' . PRIVMSGS_RULES_TABLE . '

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

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

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

+ $db->sql_freeresult($result);

+

+ if ($num_rules >= 5000)

+ {

+ trigger_error('RULE_LIMIT_REACHED');

+ }

+

+ // Set the user_message_rules bit

+ // Unset the user_message_rules bit

+ if ($config['override_user_style'])

+ {

+ $data['style'] = (int) $config['default_style'];

+ }

+ else if (!phpbb_style_is_active($data['style']))

+ {

+ $data['style'] = (int) $user->data['user_style'];

+ }

+ 'phpbb_version' => '3.0.11',

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

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

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

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

+ // No changes from 3.0.10 to 3.0.11-RC1

+ '3.0.10' => array(),

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

+ '3.0.11-RC1' => array(

+ 'add_columns' => array(

+ PROFILE_FIELDS_TABLE => array(

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

+ ),

+ ),

+ ),

+ // No changes from 3.0.11-RC2 to 3.0.11

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

+ // No changes from 3.0.11 to 3.0.12-RC1

+ '3.0.11' => array(),

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

+

+ // Changes from 3.0.10 to 3.0.11-RC1

+ case '3.0.10':

+ // Updates users having current style a deactivated one

+ $sql = 'SELECT style_id

+ FROM ' . STYLES_TABLE . '

+ WHERE style_active = 0';

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

+

+ $deactivated_style_ids = array();

+ while ($style_id = $db->sql_fetchfield('style_id', false, $result))

+ {

+ $deactivated_style_ids[] = (int) $style_id;

+ }

+ $db->sql_freeresult($result);

+

+ if (!empty($deactivated_style_ids))

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_style = ' . (int) $config['default_style'] .'

+ WHERE ' . $db->sql_in_set('user_style', $deactivated_style_ids);

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

+ }

+

+ // Delete orphan private messages

+ $batch_size = 500;

+

+ $sql_array = array(

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

+ 'FROM' => array(

+ PRIVMSGS_TABLE => 'p',

+ ),

+ 'LEFT_JOIN' => array(

+ array(

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

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

+ ),

+ ),

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

+ );

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

+

+ do

+ {

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

+

+ $delete_pms = array();

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

+ {

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

+ }

+ $db->sql_freeresult($result);

+

+ if (!empty($delete_pms))

+ {

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

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

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

+ }

+ }

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

+

+ $no_updates = false;

+ break;

+

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

+ case '3.0.11-RC1':

+ break;

+

+ // No changes from 3.0.11-RC2 to 3.0.11

+ case '3.0.11-RC2':

+ break;

+

+ // Changes from 3.0.11 to 3.0.12-RC1

+ case '3.0.11':

+ $sql = 'UPDATE ' . MODULES_TABLE . '

+ SET module_auth = \'acl_u_sig\'

+ WHERE module_class = \'ucp\'

+ AND module_basename = \'profile\'

+ AND module_mode = \'signature\'';

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

+ break;

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

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

+ $cache->purge();

+

+ $this->disable_avatars_if_unwritable();

+ // Don't check for register_globals on 5.4+

+ if (version_compare($php_version, '5.4.0-dev') < 0)

+ // Check for register_globals being enabled

+ if (@ini_get('register_globals') == '1' || strtolower(@ini_get('register_globals')) == 'on')

+ {

+ $result = '<strong style="color:red">' . $lang['NO'] . '</strong>';

+ }

+ else

+ {

+ $result = '<strong style="color:green">' . $lang['YES'] . '</strong>';

+ }

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

+ 'TITLE' => $lang['PHP_REGISTER_GLOBALS'],

+ 'TITLE_EXPLAIN' => $lang['PHP_REGISTER_GLOBALS_EXPLAIN'],

+ 'RESULT' => $result,

+ 'S_EXPLAIN' => true,

+ 'S_LEGEND' => false,

+ ));

+ }

+ $config_data = phpbb_create_config_file_data($data, $available_dbms[$data['dbms']]['DRIVER'], $load_extensions);

+ $sql_query = phpbb_remove_comments($sql_query);

+ $sql_query = phpbb_remove_comments($sql_query);

+ * Check if the avatar directory is writable and disable avatars

+ * if it isn't writable.

+ */

+ function disable_avatars_if_unwritable()

+ {

+ global $phpbb_root_path;

+

+ if (!phpbb_is_writable($phpbb_root_path . 'images/avatars/upload/'))

+ {

+ set_config('allow_avatar', 0);

+ set_config('allow_avatar_upload', 0);

+ }

+ }

+

+ /**

+ field_show_novalue INTEGER DEFAULT 0 NOT NULL,

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

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

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

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

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

+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar', '1');

+INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_upload', '1');

+INSERT INTO phpbb_config (config_name, config_value) VALUES ('feed_enable', '1');

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

+ field_show_novalue INTEGER UNSIGNED NOT NULL DEFAULT '0',

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

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

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

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

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

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

+ 'USER_NO_POSTS_TO_DELETE' => 'The user has no posts to retain or delete.',

+ 'RANK' => 'Rank',

+You are receiving this notification because you are watching the forum, "{FORUM_NAME}" at "{SITENAME}". This forum has received a new reply to the topic "{TOPIC_TITLE}"<!-- IF AUTHOR_NAME --> by {AUTHOR_NAME}<!-- ENDIF --> since your last visit. You can use the following link to view the last unread reply, no more notifications will be sent until you visit the topic.

+You are receiving this notification because you are watching the forum, "{FORUM_NAME}" at "{SITENAME}". This forum has received a new topic<!-- IF AUTHOR_NAME --> by {AUTHOR_NAME}<!-- ENDIF --> since your last visit, "{TOPIC_TITLE}". You can use the following link to view the forum, no more notifications will be sent until you visit the forum.

+You are receiving this notification because you are watching the topic, "{TOPIC_TITLE}" at "{SITENAME}". This topic has received a reply<!-- IF AUTHOR_NAME --> by {AUTHOR_NAME}<!-- ENDIF --> since your last visit. You can use the following link to view the replies made, no more notifications will be sent until you visit the topic.

+ 1 => 'This software was written by and licensed through phpBB Group. If you believe a feature needs to be added, or you want to report a bug, please visit the phpBB <a href="http://area51.phpbb.com/">Area51</a> website, where you will find resources to do so.'

+ 'SEARCHED_QUERY' => 'Searched query',

+ 'CURRENT_PASSWORD_EXPLAIN' => 'You must enter your current password if you wish to alter your email address or username.',

+ 'CURRENT_CHANGE_PASSWORD_EXPLAIN' => 'To change your password, your email address, or your username, you must enter your current password.',

+ 'MESSAGE_EDITED' => 'Message successfully edited.',

+ 'MESSAGE_REMOVED_FROM_OUTBOX' => 'This message was deleted by its author.',

+ 'RULE_LIMIT_REACHED' => 'You cannot add more PM rules. You have reached the maximum number of rules.',

+ 'SEARCH_WORDS' => $keywords,

+ 'SEARCHED_QUERY' => $search->search_query,

+version = 3.0.11

+version = 3.0.11 \ No newline at end of file

+ <dt><textarea id="username_list" name="username_list" class="inputbox" cols="50" rows="2" tabindex="1"></textarea></dt>

+ <dd><input type="submit" name="add_to" value="{L_ADD}" class="button2" tabindex="1" /></dd>

+ <dd><input type="submit" name="add_bcc" value="{L_ADD_BCC}" class="button2" tabindex="1" /></dd>

+ <label for="icon"><input type="radio" name="icon" id="icon" value="0" checked="checked" tabindex="1" /> <!-- IF S_SHOW_TOPIC_ICONS -->{L_NO_TOPIC_ICON}<!-- ELSE -->{L_NO_PM_ICON}<!-- ENDIF --></label>

+ <!-- BEGIN topic_icon --><label for="icon-{topic_icon.ICON_ID}"><input type="radio" name="icon" id="icon-{topic_icon.ICON_ID}" value="{topic_icon.ICON_ID}" {topic_icon.S_ICON_CHECKED} tabindex="1" /><img src="{topic_icon.ICON_IMG}" width="{topic_icon.ICON_WIDTH}" height="{topic_icon.ICON_HEIGHT}" alt="" title="" /></label> <!-- END topic_icon -->

+<!-- IF SEARCHED_QUERY --> <p>{L_SEARCHED_QUERY}: <strong>{SEARCHED_QUERY}</strong></p><!-- ENDIF -->

+version = 3.0.11

+ <dd class="mark"><input type="radio" name="selected" value="{pending.GROUP_ID}" <!-- IF pending.GROUP_SPECIAL -->disabled="disabled"<!-- ENDIF --> /></dd>

+ <p>{SITE_DESCRIPTION}</p>

+ <h2>{L_PRIVATE_MESSAGING}</h2>

+ <div class="copyright">Powered by phpBB&reg; Forum Software &copy; phpBB Group<br />https://www.phpbb.com/</div>

+ <dt><label for="cur_password">{L_CURRENT_PASSWORD}:</label><br /><span><!-- IF S_CHANGE_PASSWORD -->{L_CURRENT_CHANGE_PASSWORD_EXPLAIN}<!-- ELSE -->{L_CURRENT_PASSWORD_EXPLAIN}<!-- ENDIF --></span></dt>

+ {S_HIDDEN_FIELDS}<input type="reset" value="{L_RESET}" name="reset" class="button2" />&nbsp;

+ <div class="copyright">Powered by phpBB&reg; Forum Software &copy; phpBB Group<br />https://www.phpbb.com/</div>

+ Modified by: phpBB Group ( https://www.phpbb.com/ )

+version = 3.0.11

+version = 3.0.11

+version = 3.0.11

+ <td><input type="radio" class="radio" name="icon" value="0"{S_NO_ICON_CHECKED} tabindex="1" /><span class="genmed"><!-- IF S_SHOW_TOPIC_ICONS -->{L_NO_TOPIC_ICON}<!-- ELSE -->{L_NO_PM_ICON}<!-- ENDIF --></span> <!-- BEGIN topic_icon --><span style="white-space: nowrap;"><input type="radio" class="radio" name="icon" value="{topic_icon.ICON_ID}"{topic_icon.S_ICON_CHECKED} tabindex="1" /><img src="{topic_icon.ICON_IMG}" width="{topic_icon.ICON_WIDTH}" height="{topic_icon.ICON_HEIGHT}" alt="" title="" hspace="2" vspace="2" /></span> <!-- END topic_icon --></td>

+ e: '{LA_BBCODE_LISTITEM_HELP}',

+ <span class="copyright">{CREDIT_LINE}</span>

+version = 3.0.11

+ <td class="row2"><textarea name="username_list" rows="5" cols="22" tabindex="1"></textarea><br />

+ <td class="row1"><div style="float: {S_CONTENT_FLOW_BEGIN};">&nbsp;<input class="post" type="submit" name="add_bcc" value="{L_ADD_BCC}" tabindex="1" />&nbsp;</div><div style="float: {S_CONTENT_FLOW_END};">&nbsp;<input class="post" type="submit" name="add_to" value="{L_ADD_TO}" tabindex="1" />&nbsp;</div></td>

+ <td colspan="2" align="center"><span class="gensmall">Powered by phpBB&reg; Forum Software &copy; phpBB Group<br />https://www.phpbb.com/</span></td>

+ <td class="row1" width="35%"><b class="genmed">{L_CURRENT_PASSWORD}: </b><br /><span class="gensmall"><!-- IF S_CHANGE_PASSWORD -->{L_CURRENT_CHANGE_PASSWORD_EXPLAIN}<!-- ELSE -->{L_CURRENT_PASSWORD_EXPLAIN}<!-- ENDIF --></span></td>

+ <td colspan="2" align="center"><span class="gensmall">Powered by phpBB&reg; Forum Software &copy; phpBB Group<br />https://www.phpbb.com/</span></td>

+ Modified by: phpBB Group ( https://www.phpbb.com/ )

+version = 3.0.11

+ <exclude>./tests/functional</exclude>

+ </testsuite>

+ <testsuite name="phpBB Functional Tests">

+ <directory suffix="_test.php" phpVersion="5.3.0" phpVersionOperator=">=">./tests/functional</directory>

+ <exclude>./tests/functional</exclude>

+ </testsuite>

+ <testsuite name="phpBB Functional Tests">

+ <directory suffix="_test.php" phpVersion="5.3.0" phpVersionOperator=">=">./tests/functional</directory>

+ <group>functional</group>

+<?xml version="1.0" encoding="UTF-8"?>

+

+<phpunit backupGlobals="true"

+ backupStaticAttributes="true"

+ colors="true"

+ convertErrorsToExceptions="true"

+ convertNoticesToExceptions="true"

+ convertWarningsToExceptions="true"

+ processIsolation="false"

+ stopOnFailure="false"

+ syntaxCheck="false"

+ bootstrap="tests/bootstrap.php"

+>

+ <testsuites>

+ <testsuite name="phpBB Test Suite">

+ <directory suffix="_test.php">./tests/</directory>

+ <exclude>./tests/functional</exclude>

+ </testsuite>

+ <testsuite name="phpBB Functional Tests">

+ <directory suffix="_test.php" phpVersion="5.3.0" phpVersionOperator=">=">./tests/functional</directory>

+ </testsuite>

+ </testsuites>

+

+ <groups>

+ <include>

+ <group>functional</group>

+ </include>

+ </groups>

+

+ <filter>

+ <blacklist>

+ <directory>./tests/</directory>

+ </blacklist>

+ </filter>

+</phpunit>

+

+your tests directory following the same format as phpBB's config.php. An

+example for mysqli can be found below. More information on configuration

+options can be found on the wiki (see below).

+It is possible to have multiple test_config.php files, for example if you

+are testing on multiple databases. You can specify which test_config.php file

+to use in the environment as follows:

+

+ $ PHPBB_TEST_CONFIG=tests/test_config.php phpunit

+

+Alternatively you can specify parameters in the environment, so e.g. the

+following will run phpunit with the same parameters as in the shown

+test_config.php file:

+Special Database Cases

+----------------------

+In order to run tests on some of the databases that we support, it will be

+necessary to provide a custom DSN string in test_config.php. This is only

+needed for MSSQL 2000+ (PHP module), MSSQL via ODBC, and Firebird when

+PDO_Firebird does not work on your system

+(https://bugs.php.net/bug.php?id=61183). The variable must be named $custom_dsn.

+

+Examples:

+Firebird using http://www.firebirdsql.org/en/odbc-driver/

+$custom_dsn = "Driver={Firebird/InterBase(r) driver};dbname=$dbhost:$dbname";

+

+MSSQL

+$custom_dsn = "Driver={SQL Server Native Client 10.0};Server=$dbhost;Database=$dbname";

+

+The other fields in test_config.php should be filled out as you would normally

+to connect to that database in phpBB.

+

+Additionally, you will need to be running the DbUnit fork from

+https://github.com/phpbb/dbunit/tree/phpbb.

+

+Once the prerequisites are installed, run the tests from the project root

+directory (above phpBB):

+

+enable slow tests by copying the phpunit.xml.all file to phpunit.xml. If you

+only want the slow tests, run:

+http://wiki.phpbb.com/Unit_Tests

+require_once dirname(__FILE__) . '/../mock/user.php';

+

+if (version_compare(PHP_VERSION, '5.3.0-dev', '>='))

+{

+ if (getenv('PHPBB_NO_COMPOSER_AUTOLOAD'))

+ {

+ if (getenv('PHPBB_AUTOLOAD'))

+ {

+ require(getenv('PHPBB_AUTOLOAD'));

+ }

+ }

+ else

+ {

+ if (!file_exists($phpbb_root_path . 'vendor/autoload.php'))

+ {

+ trigger_error('You have not set up composer dependencies. See http://getcomposer.org/.', E_USER_ERROR);

+ }

+ require($phpbb_root_path . 'vendor/autoload.php');

+ }

+ require_once 'test_framework/phpbb_functional_test_case.php';

+}

+<?php

+/**

+ *

+ * @package testing

+ * @copyright (c) 2012 phpBB Group

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

+ *

+ */

+

+require_once dirname(__FILE__) . '/../../phpBB/includes/functions.php';

+require_once dirname(__FILE__) . '/../../phpBB/includes/functions_admin.php';

+require_once dirname(__FILE__) . '/../../phpBB/includes/functions_compress.php';

+

+class phpbb_compress_test extends phpbb_test_case

+{

+ const EXTRACT_DIR = '/extract/';

+ const ARCHIVE_DIR = '/archive/';

+

+ private $path;

+

+ protected $filelist = array(

+ '1.txt',

+ 'dir/2.txt',

+ 'dir/3.txt',

+ 'dir/subdir/4.txt',

+ );

+

+ protected function setUp()

+ {

+ // Required for compress::add_file

+ global $phpbb_root_path;

+ $phpbb_root_path = '';

+

+ $this->path = dirname(__FILE__) . '/fixtures/';

+

+ if (!@extension_loaded('zlib') || !@extension_loaded('bz2'))

+ {

+ $this->markTestSkipped('PHP needs to be compiled with --with-zlib and --with-bz2 in order to run these tests');

+ }

+ }

+

+ protected function tearDown()

+ {

+ foreach (array(dirname(__FILE__) . self::EXTRACT_DIR, dirname(__FILE__) . self::ARCHIVE_DIR) as $dir)

+ {

+ $this->clear_dir($dir);

+ }

+ }

+

+ protected function clear_dir($dir)

+ {

+ $iterator = new DirectoryIterator($dir);

+ foreach ($iterator as $fileinfo)

+ {

+ $name = $fileinfo->getFilename();

+ $path = $fileinfo->getPathname();

+

+ if ($name[0] !== '.')

+ {

+ if ($fileinfo->isDir())

+ {

+ $this->clear_dir($path);

+ rmdir($path);

+ }

+ else

+ {

+ unlink($path);

+ }

+ }

+ }

+ }

+

+ protected function archive_files($compress)

+ {

+ $compress->add_file($this->path . '1.txt', $this->path);

+ $compress->add_file(

+ 'tests/compress/fixtures/dir/',

+ 'tests/compress/fixtures/',

+ '',

+ // The comma here is not an error, this is a comma-separated list

+ 'subdir/4.txt,3.txt'

+ );

+ $compress->add_custom_file($this->path . 'dir/3.txt', 'dir/3.txt');

+ $compress->add_data(file_get_contents($this->path . 'dir/subdir/4.txt'), 'dir/subdir/4.txt');

+ }

+

+ protected function valid_extraction($extra = array())

+ {

+ $filelist = array_merge($this->filelist, $extra);

+

+ foreach ($filelist as $filename)

+ {

+ $path = dirname(__FILE__) . self::EXTRACT_DIR . $filename;

+ $this->assertTrue(file_exists($path));

+

+ // Check the file's contents is correct

+ $contents = explode('_', basename($filename, '.txt'));

+ $contents = $contents[0];

+ $this->assertEquals($contents . "\n", file_get_contents($path));

+ }

+ }

+

+ public function tar_archive_list()

+ {

+ return array(

+ array('archive.tar', '.tar'),

+ array('archive.tar.gz', '.tar.gz'),

+ array('archive.tar.bz2', '.tar.bz2'),

+ );

+ }

+

+ /**

+ * @dataProvider tar_archive_list

+ */

+ public function test_extract_tar($filename, $type)

+ {

+ $compress = new compress_tar('r', $this->path . $filename);

+ $compress->extract('tests/compress/' . self::EXTRACT_DIR);

+ $this->valid_extraction();

+ }

+

+ public function test_extract_zip()

+ {

+ $compress = new compress_zip('r', $this->path . 'archive.zip');

+ $compress->extract('tests/compress/' . self::EXTRACT_DIR);

+ $this->valid_extraction();

+ }

+

+ /**

+ * @depends test_extract_tar

+ * @dataProvider tar_archive_list

+ */

+ public function test_compress_tar($filename, $type)

+ {

+ $tar = dirname(__FILE__) . self::ARCHIVE_DIR . $filename;

+ $compress = new compress_tar('w', $tar);

+ $this->archive_files($compress);

+ $compress->close();

+ $this->assertTrue(file_exists($tar));

+

+ $compress->mode = 'r';

+ $compress->open();

+ $compress->extract('tests/compress/' . self::EXTRACT_DIR);

+ $this->valid_extraction();

+ }

+

+ /**

+ * @depends test_extract_zip

+ */

+ public function test_compress_zip()

+ {

+ $zip = dirname(__FILE__) . self::ARCHIVE_DIR . 'archive.zip';

+ $compress = new compress_zip('w', $zip);

+ $this->archive_files($compress);

+ $compress->close();

+ $this->assertTrue(file_exists($zip));

+

+ $compress = new compress_zip('r', $zip);

+ $compress->extract('tests/compress/' . self::EXTRACT_DIR);

+ $this->valid_extraction();

+ }

+}

+1

+2

+3

+4

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+require_once dirname(__FILE__) . '/../../phpBB/includes/functions.php';

+require_once dirname(__FILE__) . '/../../phpBB/includes/db/db_tools.php';

+

+class phpbb_dbal_auto_increment_test extends phpbb_database_test_case

+{

+ protected $db;

+ protected $tools;

+ protected $table_exists;

+ protected $table_data;

+

+ public function getDataSet()

+ {

+ return $this->createXMLDataSet(dirname(__FILE__) . '/fixtures/config.xml');

+ }

+

+ protected function setUp()

+ {

+ parent::setUp();

+

+ $this->db = $this->new_dbal();

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

+

+ $this->table_data = array(

+ 'COLUMNS' => array(

+ 'c_id' => array('UINT', NULL, 'auto_increment'),

+ 'c_uint' => array('UINT', 4),

+ ),

+ 'PRIMARY_KEY' => 'c_id',

+ );

+ $this->tools->sql_create_table('prefix_table_name', $this->table_data);

+ $this->table_exists = true;

+ }

+

+ protected function tearDown()

+ {

+ if ($this->table_exists)

+ {

+ $this->tools->sql_table_drop('prefix_table_name');

+ }

+

+ parent::tearDown();

+ }

+

+ static protected function get_default_values()

+ {

+ return array(

+ 'c_uint' => 0,

+ );

+ }

+

+ public function test_auto_increment()

+ {

+ $sql = 'DELETE FROM prefix_table_name';

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

+

+ $row1 = array_merge(self::get_default_values(), array(

+ 'c_uint' => 1,

+ ));

+ $row2 = array_merge(self::get_default_values(), array(

+ 'c_uint' => 2,

+ ));

+

+ $sql = 'INSERT INTO prefix_table_name ' . $this->db->sql_build_array('INSERT', $row1);

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

+ $id1 = $this->db->sql_nextid();

+

+ $sql = 'INSERT INTO prefix_table_name ' . $this->db->sql_build_array('INSERT', $row2);

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

+ $id2 = $this->db->sql_nextid();

+

+ $this->assertGreaterThan($id1, $id2, 'Auto increment should increase the id value');

+

+ $sql = "SELECT *

+ FROM prefix_table_name WHERE c_id = $id1";

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

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

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

+

+ $row1['c_id'] = $id1;

+ $this->assertEquals($row1, $row_actual);

+

+ $sql = "SELECT *

+ FROM prefix_table_name WHERE c_id = $id2";

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

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

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

+

+ $row2['c_id'] = $id2;

+ $this->assertEquals($row2, $row_actual);

+ }

+}

+ 'c_char_size' => 'abcd',

+ if ($column_name === 'c_varbinary' && stripos(get_class($this->db), 'mysql') === false)

+ {

+ $this->markTestIncomplete('Binary handling is not implemented properly on non-MySQL DBMSes.');

+ }

+

+ public function test_unique_index_exists()

+ {

+ $this->assertTrue($this->tools->sql_unique_index_exists('prefix_table_name', 'i_uniq'));

+ }

+

+

+ public function test_create_unique_index_against_unique_index_exists()

+ {

+ $this->tools->sql_create_unique_index('prefix_table_name', 'i_uniq_ts_id', array('c_timestamp', 'c_id'));

+ $this->assertTrue($this->tools->sql_unique_index_exists('prefix_table_name', 'i_uniq_ts_id'));

+ }

+ static public function return_on_error_select_data()

+ static public function fetchrow_data()

+ static public function fetchfield_data()

+ static public function fetchfield_seek_data()

+ {

+ return array(

+ array(1, 'foobar'),

+ array(0, 'barfoo'),

+ array(2, 'bertie'),

+ );

+ }

+

+ /**

+ * @dataProvider fetchfield_seek_data

+ */

+ public function test_fetchfield_seek($rownum, $expected)

+ {

+ $db = $this->new_dbal();

+

+ $result = $db->sql_query('SELECT username_clean

+ FROM phpbb_users

+ ORDER BY user_id ASC');

+

+ $field = $db->sql_fetchfield('username_clean', $rownum, $result);

+ $db->sql_freeresult($result);

+

+ $this->assertEquals($expected, $field);

+ }

+

+ static public function query_limit_data()

+ static public function like_expression_data()

+ static public function in_set_data()

+ static public function build_array_data()

+ $sql = 'SELECT user_id

+ FROM phpbb_users

+ WHERE 1 = 0';

+ static public function build_array_insert_data()

+ static public function update_data()

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @group functional

+*/

+class phpbb_functional_auth_test extends phpbb_functional_test_case

+{

+ public function test_login()

+ {

+ $this->login();

+

+ // check for logout link

+ $crawler = $this->request('GET', 'index.php');

+ $this->assertContains($this->lang('LOGOUT_USER', 'admin'), $crawler->filter('.navbar')->text());

+ }

+

+ /**

+ * @depends test_login

+ */

+ public function test_logout()

+ {

+ $this->login();

+ $this->add_lang('ucp');

+

+ // logout

+ $crawler = $this->request('GET', 'ucp.php?sid=' . $this->sid . '&mode=logout');

+ $this->assertContains($this->lang('LOGOUT_REDIRECT'), $crawler->filter('#message')->text());

+

+ // look for a register link, which should be visible only when logged out

+ $crawler = $this->request('GET', 'index.php');

+ $this->assertContains($this->lang('REGISTER'), $crawler->filter('.navbar')->text());

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

+/**

+* @group functional

+*/

+class phpbb_functional_browse_test extends phpbb_functional_test_case

+{

+ public function test_index()

+ {

+ $crawler = $this->request('GET', 'index.php');

+ $this->assertGreaterThan(0, $crawler->filter('.topiclist')->count());

+ }

+

+ public function test_viewforum()

+ {

+ $crawler = $this->request('GET', 'viewforum.php?f=2');

+ $this->assertGreaterThan(0, $crawler->filter('.topiclist')->count());

+ }

+

+ public function test_viewtopic()

+ {

+ $crawler = $this->request('GET', 'viewtopic.php?t=1');

+ $this->assertGreaterThan(0, $crawler->filter('.postbody')->count());

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @group functional

+*/

+class phpbb_functional_lang_test extends phpbb_functional_test_case

+{

+ public function test_lang()

+ {

+ // Test a language string present in the common language file

+ $this->assertEquals('Board index', $this->lang('FORUM_INDEX'));

+ }

+

+ /**

+ * @expectedException RuntimeException

+ */

+ public function test_lang_missing()

+ {

+ $this->assertEquals('Your account has now been activated. Thank you for registering.', $this->lang('ACCOUNT_ACTIVE'));

+ }

+

+ public function test_add_lang()

+ {

+ $this->add_lang('ucp');

+

+ // Test a language string present only in the UCP language file

+ $this->assertEquals('Your account has now been activated. Thank you for registering.', $this->lang('ACCOUNT_ACTIVE'));

+ }

+

+ public function test_add_langs()

+ {

+ $this->add_lang(array('groups', 'memberlist'));

+

+ // Test a language string from each UCP and memberlist

+ $this->assertEquals('The selected group is already your default group.', $this->lang('ALREADY_DEFAULT_GROUP'));

+ $this->assertEquals('Profile', $this->lang('ABOUT_USER'));

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @group functional

+*/

+class phpbb_functional_posting_test extends phpbb_functional_test_case

+{

+ public function test_post_new_topic()

+ {

+ $this->login();

+ $this->add_lang('posting');

+

+ $crawler = $this->request('GET', 'posting.php?mode=post&f=2&sid=' . $this->sid);

+ $this->assertContains($this->lang('POST_TOPIC'), $crawler->filter('html')->text());

+

+ $hidden_fields = array();

+ $hidden_fields[] = $crawler->filter('[type="hidden"]')->each(function ($node, $i) {

+ return array('name' => $node->getAttribute('name'), 'value' => $node->getAttribute('value'));

+ });

+

+ $test_message = 'This is a test topic posted by the testing framework.';

+ $form_data = array(

+ 'subject' => 'Test Topic 1',

+ 'message' => $test_message,

+ 'post' => true,

+ 'f' => 2,

+ 'mode' => 'post',

+ 'sid' => $this->sid,

+ );

+

+ foreach ($hidden_fields as $fields)

+ {

+ foreach($fields as $field)

+ {

+ $form_data[$field['name']] = $field['value'];

+ }

+ }

+

+ // Bypass time restriction that said that if the lastclick time (i.e. time when the form was opened)

+ // is not at least 2 seconds before submission, cancel the form

+ $form_data['lastclick'] = 0;

+

+ // I use a request because the form submission method does not allow you to send data that is not

+ // contained in one of the actual form fields that the browser sees (i.e. it ignores "hidden" inputs)

+ // Instead, I send it as a request with the submit button "post" set to true.

+ $crawler = $this->client->request('POST', 'posting.php', $form_data);

+ $this->assertContains($this->lang('POST_STORED'), $crawler->filter('html')->text());

+

+ $crawler = $this->request('GET', 'viewtopic.php?t=2&sid=' . $this->sid);

+ $this->assertContains($test_message, $crawler->filter('html')->text());

+ }

+

+ public function test_post_reply()

+ {

+ $this->login();

+ $this->add_lang('posting');

+

+ $crawler = $this->request('GET', 'posting.php?mode=reply&t=2&f=2&sid=' . $this->sid);

+ $this->assertContains($this->lang('POST_REPLY'), $crawler->filter('html')->text());

+

+ $hidden_fields = array();

+ $hidden_fields[] = $crawler->filter('[type="hidden"]')->each(function ($node, $i) {

+ return array('name' => $node->getAttribute('name'), 'value' => $node->getAttribute('value'));

+ });

+

+ $test_message = 'This is a test post posted by the testing framework.';

+ $form_data = array(

+ 'subject' => 'Re: Test Topic 1',

+ 'message' => $test_message,

+ 'post' => true,

+ 't' => 2,

+ 'f' => 2,

+ 'mode' => 'reply',

+ 'sid' => $this->sid,

+ );

+

+ foreach ($hidden_fields as $fields)

+ {

+ foreach($fields as $field)

+ {

+ $form_data[$field['name']] = $field['value'];

+ }

+ }

+

+ // For reasoning behind the following command, see the test_post_new_topic() test

+ $form_data['lastclick'] = 0;

+

+ // Submit the post

+ $crawler = $this->client->request('POST', 'posting.php', $form_data);

+ $this->assertContains($this->lang('POST_STORED'), $crawler->filter('html')->text());

+

+ $crawler = $this->request('GET', 'viewtopic.php?t=2&sid=' . $this->sid);

+ $this->assertContains($test_message, $crawler->filter('html')->text());

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+require_once dirname(__FILE__) . '/../../phpBB/includes/functions.php';

+

+class phpbb_clean_path_test extends phpbb_test_case

+{

+ public function clean_path_test_data()

+ {

+ return array(

+ array('foo', 'foo'),

+ array('foo/bar', 'foo/bar'),

+ array('foo/bar/', 'foo/bar/'),

+ array('foo/./bar', 'foo/bar'),

+ array('foo/./././bar', 'foo/bar'),

+ array('foo/bar/.', 'foo/bar'),

+ array('./foo/bar', './foo/bar'),

+ array('../foo/bar', '../foo/bar'),

+ array('one/two/three', 'one/two/three'),

+ array('one/two/../three', 'one/three'),

+ array('one/../two/three', 'two/three'),

+ array('one/two/..', 'one'),

+ array('one/two/../', 'one/'),

+ array('one/two/../three/../four', 'one/four'),

+ array('one/two/three/../../four', 'one/four'),

+ );

+ }

+

+ /**

+ * @dataProvider clean_path_test_data

+ */

+ public function test_clean_path($input, $expected)

+ {

+ $output = phpbb_clean_path($input);

+

+ $this->assertEquals($expected, $output);

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

+require_once dirname(__FILE__) . '/../../phpBB/includes/functions_privmsgs.php';

+

+class phpbb_privmsgs_delete_user_pms_test extends phpbb_database_test_case

+{

+ public function getDataSet()

+ {

+ return $this->createXMLDataSet(dirname(__FILE__).'/fixtures/delete_user_pms.xml');

+ }

+

+ static public function delete_user_pms_data()

+ {

+ return array(

+ // array(

+ // (user we delete),

+ // array(remaining privmsgs ids),

+ // array(remaining privmsgs_to),

+ // ),

+ array(

+ 2,

+ array(

+ array('msg_id' => 1),

+ ),

+ array(

+ array('msg_id' => 1, 'user_id' => 3),

+ ),

+ ),

+ array(

+ 3,

+ array(

+ array('msg_id' => 1),

+ array('msg_id' => 2),

+ array('msg_id' => 3),

+ array('msg_id' => 5),

+ ),

+ array(

+ array('msg_id' => 1, 'user_id' => 2),

+ array('msg_id' => 1, 'user_id' => 4),

+ array('msg_id' => 2, 'user_id' => 2),

+ array('msg_id' => 2, 'user_id' => 4),

+ array('msg_id' => 3, 'user_id' => 2),

+ array('msg_id' => 5, 'user_id' => 2),

+ array('msg_id' => 5, 'user_id' => 4),

+ ),

+ ),

+ array(

+ 5,

+ array(

+ array('msg_id' => 1),

+ array('msg_id' => 2),

+ array('msg_id' => 3),

+ array('msg_id' => 4),

+ array('msg_id' => 5),

+ ),

+ array(

+ array('msg_id' => 1, 'user_id' => 2),

+ array('msg_id' => 1, 'user_id' => 3),

+ array('msg_id' => 1, 'user_id' => 4),

+ array('msg_id' => 2, 'user_id' => 2),

+ array('msg_id' => 2, 'user_id' => 4),

+ array('msg_id' => 3, 'user_id' => 2),

+ array('msg_id' => 4, 'user_id' => 3),

+ array('msg_id' => 5, 'user_id' => 2),

+ array('msg_id' => 5, 'user_id' => 3),

+ array('msg_id' => 5, 'user_id' => 4),

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider delete_user_pms_data

+ */

+ public function test_delete_user_pms($delete_user, $remaining_privmsgs, $remaining_privmsgs_to)

+ {

+ global $db;

+

+ $db = $this->new_dbal();

+

+ phpbb_delete_user_pms($delete_user);

+

+ $sql = 'SELECT msg_id

+ FROM ' . PRIVMSGS_TABLE;

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

+

+ $this->assertEquals($remaining_privmsgs, $db->sql_fetchrowset($result));

+

+ $sql = 'SELECT msg_id, user_id

+ FROM ' . PRIVMSGS_TO_TABLE;

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

+

+ $this->assertEquals($remaining_privmsgs_to, $db->sql_fetchrowset($result));

+ }

+}

+<?xml version="1.0" encoding="UTF-8" ?>

+<dataset>

+ <table name="phpbb_users">

+ <column>user_id</column>

+ <column>username</column>

+ <column>username_clean</column>

+ <column>user_new_privmsg</column>

+ <column>user_unread_privmsg</column>

+ <column>user_permissions</column>

+ <column>user_sig</column>

+ <column>user_occ</column>

+ <column>user_interests</column>

+ <row>

+ <value>2</value>

+ <value>sender</value>

+ <value>sender</value>

+ <value>0</value>

+ <value>0</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>3</value>

+ <value>pm in inbox</value>

+ <value>pm in inbox</value>

+ <value>0</value>

+ <value>0</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>4</value>

+ <value>pm in no box</value>

+ <value>pm in no box</value>

+ <value>2</value>

+ <value>2</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>5</value>

+ <value>no pms</value>

+ <value>no pms</value>

+ <value>0</value>

+ <value>0</value>

+ <value></value>

+ <value></value>

+ <value></value>

+ <value></value>

+ </row>

+ </table>

+ <table name="phpbb_privmsgs">

+ <column>msg_id</column>

+ <column>root_level</column>

+ <column>author_id</column>

+ <column>message_subject</column>

+ <column>message_text</column>

+ <column>to_address</column>

+ <column>bcc_address</column>

+ <row>

+ <value>1</value>

+ <value>0</value>

+ <value>2</value>

+ <value>#1</value>

+ <value>

+ 2 - outbox

+ 3 - inbox

+ 4 - nobox

+ </value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>0</value>

+ <value>2</value>

+ <value>#2</value>

+ <value>

+ 2 - outbox

+ 4 - nobox

+ </value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>3</value>

+ <value>0</value>

+ <value>2</value>

+ <value>#3</value>

+ <value>

+ 2 - outbox

+ </value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>4</value>

+ <value>0</value>

+ <value>2</value>

+ <value>#4</value>

+ <value>

+ 3 - nobox

+ </value>

+ <value></value>

+ <value></value>

+ </row>

+ <row>

+ <value>5</value>

+ <value>0</value>

+ <value>2</value>

+ <value>#5</value>

+ <value>

+ 2 - outbox

+ 3 - nobox

+ 4 - nobox

+ </value>

+ <value></value>

+ <value></value>

+ </row>

+ </table>

+ <table name="phpbb_privmsgs_to">

+ <column>msg_id</column>

+ <column>user_id</column>

+ <column>author_id</column>

+ <column>pm_new</column>

+ <column>pm_unread</column>

+ <column>folder_id</column>

+ <row>

+ <value>1</value>

+ <value>2</value>

+ <value>2</value>

+ <value>0</value>

+ <value>0</value>

+ <value>-2</value>

+ </row>

+ <row>

+ <value>1</value>

+ <value>3</value>

+ <value>2</value>

+ <value>0</value>

+ <value>0</value>

+ <value>0</value>

+ </row>

+ <row>

+ <value>1</value>

+ <value>4</value>

+ <value>2</value>

+ <value>0</value>

+ <value>0</value>

+ <value>-3</value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>2</value>

+ <value>2</value>

+ <value>0</value>

+ <value>0</value>

+ <value>-2</value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>4</value>

+ <value>2</value>

+ <value>0</value>

+ <value>0</value>

+ <value>-3</value>

+ </row>

+ <row>

+ <value>3</value>

+ <value>2</value>

+ <value>2</value>

+ <value>0</value>

+ <value>0</value>

+ <value>-2</value>

+ </row>

+ <row>

+ <value>4</value>

+ <value>3</value>

+ <value>2</value>

+ <value>0</value>

+ <value>0</value>

+ <value>-3</value>

+ </row>

+ <row>

+ <value>5</value>

+ <value>2</value>

+ <value>2</value>

+ <value>0</value>

+ <value>0</value>

+ <value>-2</value>

+ </row>

+ <row>

+ <value>5</value>

+ <value>3</value>

+ <value>2</value>

+ <value>0</value>

+ <value>0</value>

+ <value>-3</value>

+ </row>

+ <row>

+ <value>5</value>

+ <value>4</value>

+ <value>2</value>

+ <value>0</value>

+ <value>0</value>

+ <value>-3</value>

+ </row>

+ </table>

+</dataset>

+ array('alice@phpbb.australia'),

+ array('alice@phpbb.topZlevelZdomainZnamesZcanZbeZupZtoZsixtyZthreeZcharactersZlong'),

+ array('alice@phpbb.topZlevelZdomainZnamesZcanZbeZupZtoZsixtyZthreeZcharactersZlongZ'),

+ static public function request_variables()

+ static public function security_variables()

+ static public function provider()

+ static public function template_data()

+ static public function alter_block_array_data()

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

+if (!class_exists('PDO'))

+{

+ return;

+}

+

+/**

+* Used for passing in information about the PDO driver

+* since the PDO class reveals nothing about the DSN that

+* the user provided.

+*

+* This is used in the custom PHPUnit ODBC driver

+*/

+class phpbb_database_connection_odbc_pdo_wrapper extends PDO

+{

+ // Name of the driver being used (i.e. mssql, firebird)

+ public $driver = '';

+

+ // Version number of driver since PDO::getAttribute(PDO::ATTR_CLIENT_VERSION) is pretty useless for this

+ public $version = 0;

+

+ function __construct($dbms, $version, $dsn, $user, $pass)

+ {

+ $this->driver = $dbms;

+ $this->version = (double) $version;

+

+ parent::__construct($dsn, $user, $pass);

+ }

+}

+ public function createXMLDataSet($path)

+ {

+ $db_config = $this->get_database_config();

+

+ // Firebird requires table and column names to be uppercase

+ if ($db_config['dbms'] == 'firebird')

+ {

+ $xml_data = file_get_contents($path);

+ $xml_data = preg_replace_callback('/(?:(<table name="))([a-z_]+)(?:(">))/', 'phpbb_database_test_case::to_upper', $xml_data);

+ $xml_data = preg_replace_callback('/(?:(<column>))([a-z_]+)(?:(<\/column>))/', 'phpbb_database_test_case::to_upper', $xml_data);

+

+ $new_fixture = tmpfile();

+ fwrite($new_fixture, $xml_data);

+ fseek($new_fixture, 0);

+

+ $meta_data = stream_get_meta_data($new_fixture);

+ $path = $meta_data['uri'];

+ }

+

+ return parent::createXMLDataSet($path);

+ }

+

+ $config = phpbb_test_case_helpers::get_test_config();

+

+ if (!isset($config['dbms']))

+

+ return $config;

+

+ /**

+ * Converts a match in the middle of a string to uppercase.

+ * This is necessary for transforming the fixture information for Firebird tests

+ *

+ * @param $matches The array of matches from a regular expression

+ *

+ * @return string The string with the specified match converted to uppercase

+ */

+ static public function to_upper($matches)

+ {

+ return $matches[1] . strtoupper($matches[2]) . $matches[3];

+ }

+require_once dirname(__FILE__) . '/phpbb_database_connection_odbc_pdo_wrapper.php';

+ // Primarily for MSSQL Native/Azure as ODBC needs it in $dbhost, attached to the Server param

+ if ($this->config['dbport'])

+ {

+ $port_delimiter = (defined('PHP_OS') && substr(PHP_OS, 0, 3) === 'WIN') ? ',' : ':';

+ $dsn .= $port_delimiter . $this->config['dbport'];

+ }

+

+ else if ($this->dbms['PDO'] == 'pgsql')

+ {

+ // Postgres always connects to a

+ // database. If the database is not

+ // specified here, but the username

+ // is specified, then connection

+ // will be to the database named

+ // as the username.

+ //

+ // For greater compatibility, connect

+ // instead to postgres database which

+ // should always exist:

+ // http://www.postgresql.org/docs/9.0/static/manage-ag-templatedbs.html

+ $dsn .= ';dbname=postgres';

+ }

+ // These require different connection strings on the phpBB side than they do in PDO

+ // so you must provide a DSN string for ODBC separately

+ if (!empty($this->config['custom_dsn']) && ($this->config['dbms'] == 'mssql' || $this->config['dbms'] == 'firebird'))

+ {

+ $dsn = 'odbc:' . $this->config['custom_dsn'];

+ }

+

+ switch ($this->config['dbms'])

+ {

+ case 'mssql':

+ case 'mssql_odbc':

+ $this->pdo = new phpbb_database_connection_odbc_pdo_wrapper('mssql', 0, $dsn, $this->config['dbuser'], $this->config['dbpasswd']);

+ break;

+

+ case 'firebird':

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

+ {

+ $this->pdo = new phpbb_database_connection_odbc_pdo_wrapper('firebird', 0, $dsn, $this->config['dbuser'], $this->config['dbpasswd']);

+ break;

+ }

+ // Fall through if they're using the firebird PDO driver and not the generic ODBC driver

+

+ default:

+ $this->pdo = new PDO($dsn, $this->config['dbuser'], $this->config['dbpasswd']);

+ break;

+ }

+ $this->pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

+ case 'firebird':

+ $this->connect();

+ // Drop all of the tables

+ foreach ($this->get_tables() as $table)

+ {

+ $this->pdo->exec('DROP TABLE ' . $table);

+ }

+ $this->purge_extras();

+ break;

+

+ case 'oracle':

+ $this->connect();

+ // Drop all of the tables

+ foreach ($this->get_tables() as $table)

+ {

+ $this->pdo->exec('DROP TABLE ' . $table . ' CASCADE CONSTRAINTS');

+ }

+ $this->purge_extras();

+ break;

+

+

+ try

+ {

+ $this->pdo->exec('CREATE DATABASE ' . $this->config['dbname']);

+ }

+ catch (PDOException $e)

+ {

+ throw new Exception("Unable to re-create database: {$e->getMessage()}");

+ }

+ $this->purge_extras();

+ $sql = phpbb_remove_comments($queries);

+

+ /**

+ * Removes extra objects from a database. This is for cases where dropping the database fails.

+ */

+ public function purge_extras()

+ {

+ $this->ensure_connected(__METHOD__);

+ $queries = array();

+

+ switch ($this->config['dbms'])

+ {

+ case 'firebird':

+ $sql = 'SELECT RDB$GENERATOR_NAME

+ FROM RDB$GENERATORS

+ WHERE RDB$SYSTEM_FLAG = 0';

+ $result = $this->pdo->query($sql);

+

+ while ($row = $result->fetch(PDO::FETCH_NUM))

+ {

+ $queries[] = 'DROP GENERATOR ' . current($row);

+ }

+ break;

+

+ case 'oracle':

+ $sql = 'SELECT sequence_name

+ FROM USER_SEQUENCES';

+ $result = $this->pdo->query($sql);

+

+ while ($row = $result->fetch(PDO::FETCH_NUM))

+ {

+ $queries[] = 'DROP SEQUENCE ' . current($row);

+ }

+ break;

+ }

+

+ foreach ($queries as $query)

+ {

+ $this->pdo->exec($query);

+ }

+ }

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+use Symfony\Component\BrowserKit\CookieJar;

+

+require_once __DIR__ . '/../../phpBB/includes/functions_install.php';

+

+class phpbb_functional_test_case extends phpbb_test_case

+{

+ protected $client;

+ protected $root_url;

+

+ /**

+ * Session ID for current test's session (each test makes its own)

+ * @var string

+ */

+ protected $sid;

+

+ /**

+ * Language array used by phpBB

+ * @var array

+ */

+ protected $lang = array();

+

+ static protected $config = array();

+ static protected $already_installed = false;

+

+ public function setUp()

+ {

+ if (!isset(self::$config['phpbb_functional_url']))

+ {

+ $this->markTestSkipped('phpbb_functional_url was not set in test_config and wasn\'t set as PHPBB_FUNCTIONAL_URL environment variable either.');

+ }

+

+ $this->cookieJar = new CookieJar;

+ $this->client = new Goutte\Client(array(), null, $this->cookieJar);

+ // Reset the curl handle because it is 0 at this point and not a valid

+ // resource

+ $this->client->getClient()->getCurlMulti()->reset(true);

+ $this->root_url = self::$config['phpbb_functional_url'];

+ // Clear the language array so that things

+ // that were added in other tests are gone

+ $this->lang = array();

+ $this->add_lang('common');

+ }

+

+ public function request($method, $path)

+ {

+ return $this->client->request($method, $this->root_url . $path);

+ }

+

+ // bootstrap, called after board is set up

+ // once per test case class

+ // test cases can override this

+ protected function bootstrap()

+ {

+ }

+

+ public function __construct($name = NULL, array $data = array(), $dataName = '')

+ {

+ parent::__construct($name, $data, $dataName);

+

+ $this->backupStaticAttributesBlacklist += array(

+ 'phpbb_functional_test_case' => array('config', 'already_installed'),

+ );

+

+ if (!static::$already_installed)

+ {

+ $this->install_board();

+ $this->bootstrap();

+ static::$already_installed = true;

+ }

+ }

+

+ protected function install_board()

+ {

+ global $phpbb_root_path, $phpEx;

+

+ self::$config = phpbb_test_case_helpers::get_test_config();

+

+ if (!isset(self::$config['phpbb_functional_url']))

+ {

+ return;

+ }

+

+ self::$config['table_prefix'] = 'phpbb_';

+ $this->recreate_database(self::$config);

+

+ if (file_exists($phpbb_root_path . "config.$phpEx"))

+ {

+ if (!file_exists($phpbb_root_path . "config_dev.$phpEx"))

+ {

+ rename($phpbb_root_path . "config.$phpEx", $phpbb_root_path . "config_dev.$phpEx");

+ }

+ else

+ {

+ unlink($phpbb_root_path . "config.$phpEx");

+ }

+ }

+

+ // begin data

+ $data = array();

+

+ $data = array_merge($data, self::$config);

+

+ $data = array_merge($data, array(

+ 'default_lang' => 'en',

+ 'admin_name' => 'admin',

+ 'admin_pass1' => 'admin',

+ 'admin_pass2' => 'admin',

+ 'board_email' => 'nobody@example.com',

+ ));

+

+ $parseURL = parse_url(self::$config['phpbb_functional_url']);

+

+ $data = array_merge($data, array(

+ 'email_enable' => false,

+ 'smtp_delivery' => false,

+ 'smtp_host' => '',

+ 'smtp_auth' => '',

+ 'smtp_user' => '',

+ 'smtp_pass' => '',

+ 'cookie_secure' => false,

+ 'force_server_vars' => false,

+ 'server_protocol' => $parseURL['scheme'] . '://',

+ 'server_name' => 'localhost',

+ 'server_port' => isset($parseURL['port']) ? (int) $parseURL['port'] : 80,

+ 'script_path' => $parseURL['path'],

+ ));

+ // end data

+

+ $content = $this->do_request('install');

+ $this->assertContains('Welcome to Installation', $content);

+

+ $this->do_request('create_table', $data);

+

+ $this->do_request('config_file', $data);

+ file_put_contents($phpbb_root_path . "config.$phpEx", phpbb_create_config_file_data($data, self::$config['dbms'], array(), true, true));

+

+ $this->do_request('final', $data);

+ copy($phpbb_root_path . "config.$phpEx", $phpbb_root_path . "config_test.$phpEx");

+ }

+

+ private function do_request($sub, $post_data = null)

+ {

+ $context = null;

+

+ if ($post_data)

+ {

+ $context = stream_context_create(array(

+ 'http' => array(

+ 'method' => 'POST',

+ 'header' => 'Content-Type: application/x-www-form-urlencoded',

+ 'content' => http_build_query($post_data),

+ 'ignore_errors' => true,

+ ),

+ ));

+ }

+

+ return file_get_contents(self::$config['phpbb_functional_url'] . 'install/index.php?mode=install&sub=' . $sub, false, $context);

+ }

+

+ private function recreate_database($config)

+ {

+ $db_conn_mgr = new phpbb_database_test_connection_manager($config);

+ $db_conn_mgr->recreate_db();

+ }

+

+ protected function login()

+ {

+ $this->add_lang('ucp');

+

+ $crawler = $this->request('GET', 'ucp.php');

+ $this->assertContains($this->lang('LOGIN_EXPLAIN_UCP'), $crawler->filter('html')->text());

+

+ $form = $crawler->selectButton($this->lang('LOGIN'))->form();

+ $login = $this->client->submit($form, array('username' => 'admin', 'password' => 'admin'));

+

+ $cookies = $this->cookieJar->all();

+

+ // The session id is stored in a cookie that ends with _sid - we assume there is only one such cookie

+ foreach ($cookies as $cookie);

+ {

+ if (substr($cookie->getName(), -4) == '_sid')

+ {

+ $this->sid = $cookie->getValue();

+ }

+ }

+ }

+

+ protected function add_lang($lang_file)

+ {

+ if (is_array($lang_file))

+ {

+ foreach ($lang_file as $file)

+ {

+ $this->add_lang($file);

+ }

+ }

+

+ $lang_path = __DIR__ . "/../../phpBB/language/en/$lang_file.php";

+

+ $lang = array();