<ol>

<li><a href="#changelog">Changelog</a>

<ol style="list-style-type: lower-roman;">

<li><a href="#v310b3">Changes since 3.1.0-b3</a></li>

<li><a href="#v310b2">Changes since 3.1.0-b2</a></li>

<li><a href="#v310b1">Changes since 3.1.0-b1</a></li>

<div class="content">

<h4>Bug</h4>

<ul>

</ul>

<h4>Bug</h4>

<ul>

</ul>

<h4>Bug</h4>

<ul>

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

</ul>

<h4>Bug</h4>

<ul>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-12147">PHPBB3-12147</a>] - Remove Travis CI notification configuration</li>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11998">PHPBB3-11998</a>] - Add console / command line client environment </li>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11913">PHPBB3-11913</a>] - Apply reorganisation of download.phpbb.com to build_announcement.php</li>

</ul>

<h4>Bug</h4>

<ul>

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

</ul>

<h4>Bug</h4>

<ul>

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

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10480">PHPBB3-10480</a>] - Automate changelog building</li>

</ul>

<h4> Bug

</h4>

</ul>

<h4> Security

</h4>

<ul>

</ul>

<ul>

<li>[Sec] Do not expose forum content of forums with ACL entries but no actual permission in ATOM Feeds. (Bug #58595)</li>

</ul>

<ul>

<li>[Fix] Allow ban reason and length to be selected and copied in ACP and subsilver2 MCP. (Bug #51095)</li>

</ul>

<ul>

<li>[Fix] Allow whitespaces in avatar gallery names. (Bug #44955)</li>

<li>[Feature] Send anonymous statistical information to phpBB on installation and update (optional).</li>

</ul>

<ul>

<li>[Fix] Delete user entry from ban list table upon user deletion (Bug #40015 - Patch by TerraFrost)</li>

<li>[Sec] Only use forum id supplied for posting if global announcement detected. (Reported by nickvergessen)</li>

</ul>

<ul>

<li>[Fix] Allow mixed-case template directories to be inherited (Bug #36725)</li>

<li>[Sec] Ask for forum password if post within passworded forum quoted in private message. (Reported by nickvergessen)</li>

</ul>

<ul>

<li>[Fix] Correctly set topic starter if first post in topic removed (Bug #30575 - Patch by blueray2048)</li>

<li>[Sec Precaution] Stricter validation of the HTTP_HOST header (Thanks to Techie-Micheal et al for pointing out possible issues in derived code)</li>

</ul>

<ul>

<li>[Fix] Ability to set permissions on non-mysql dbms (Bug #24955)</li>

<li>[Sec] Only allow urls gone through redirect() being used within login_box(). (thanks nookieman)</li>

</ul>

<ul>

<li>[Change] Validate birthdays (Bug #15004)</li>

<li>[Fix] Find and display colliding usernames correctly when converting from one database to another (Bug #23925)</li>

</ul>

<ul>

<li>[Fix] Cleaned usernames contain only single spaces, so &quot;a_name&quot; and &quot;a__name&quot; are treated as the same name (Bug #15634)</li>

<li>[Fix] Call garbage_collection() within database updater to correctly close connections (affects Oracle for example)</li>

</ul>

<ul>

<li>[Fix] Fixed MSSQL related bug in the update system</li>

<li>[Fix] No duplication of active topics (Bug #15474)</li>

</ul>

<ul>

<li>[Fix] Submitting language changes using acp_language (Bug #14736)</li>

<li>[Fix] Able to request new password (Bug #14743)</li>

</ul>

<ul>

<li>[Feature] Removing constant PHPBB_EMBEDDED in favor of using an exit_handler(); the constant was meant to achive this more or less.</li>

<li>[Sec] New password hashing mechanism for storing passwords (#i42)</li>

</ul>

<ul>

<li>[Fix] MySQL, PostgreSQL and SQLite related database fixes (Bug #13862)</li>

<li>[Fix] odbc_autocommit causing existing result sets to be dropped (Bug #14182)</li>

</ul>

<ul>

<li>[Fix] Fixing some subsilver2 and prosilver style issues</li>

</ul>

<ul>

<li>[Fix] Re-allow searching within the memberlist</li>

</ul>

<ul>

<li>[Fix] (X)HTML issues within the templates (Bug #11255, #11255)</li>

phpBB Developers: bantu (Andreas Fischer)

dhruv.goel92 (Dhruv Goel)

EXreaction (Nathan Guse)

marc1706 (Marc Alexander)

nickvergessen (Joas Schilling)

prototech (Cesar Gallegos)

For a list of phpBB Team members, please see:

dhn (Dominik Dröscher) [05/2007 - 01/2011]

GrahamJE (Graham Eames) [09/2005 - 11/2006]

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

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

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

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

<li><a href="#update_all">All package types</a></li>

</ol>

</li>

<li><a href="#convert">Conversion from phpBB 2.0.x to phpBB 3.1.x</a>

<ol style="list-style-type: lower-roman;">

<li><a href="#prereq">Requirements before converting</a></li>

<li>PostgreSQL 8.3+</li>

<li>SQLite 2.8.2+</li>

<li>SQLite 3.6.15+</li>

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

<li>Oracle</li>

</ul>

<hr />

<div class="paragraph">

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

<hr />

<div class="paragraph">

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

<hr />

<div class="paragraph">

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

<hr />

<div class="paragraph">

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

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

<a name="phpsec"></a><h3>7.i. Notice on PHP security issues</h3>

<a name="sql"></a><h3>2.iii. SQL/SQL Layout</h3>

<h4>Common SQL Guidelines: </h4>

<p>All SQL commands should utilise the DataBase Abstraction Layer (DBAL)</p>

<h4>SQL code layout:</h4>

* Since: 3.1.0-a1

* Purpose: Add assets within the `<head>` tags in the ACP

acp_posting_buttons_after

===

* Locations:

* Since: 3.1.0-b4

* Purpose: Add content before BBCode posting buttons in the ACP

acp_simple_footer_after

===

* Location: adm/style/simple_footer.html

* Since: 3.1.0-a1

* Purpose: Add assets within the `<head>` tags in the simple header of the ACP

acp_users_overview_options_append

===

* Location: adm/style/acp_users_overview.html

* Since: 3.1.0-b3

* Purpose: Prepend content to the statistics list on the Board index

===

* Locations:

+ styles/prosilver/template/index_body.html

+ styles/subsilver2/template/index_body.html

===

* Locations:

+ styles/prosilver/template/index_body.html

+ styles/subsilver2/template/index_body.html

index_body_stat_blocks_after

===

* Since: 3.1.0-a1

* Purpose: Add new statistic blocks above the Who Is Online and Board Statistics blocks

memberlist_body_username_append

===

* Locations:

* Since: 3.1.0-a1

* Purpose: Add entries before the user statistics part of any user profile

overall_footer_after

===

* Locations:

===

* Locations:

+ styles/prosilver/template/navbar_footer.html

* Since: 3.1.0-a1

* Purpose: Add links to the list of breadcrumbs in the footer

overall_footer_content_after

===

* Locations:

* Since: 3.1.0-a1

* Purpose: Add links to the list of breadcrumbs in the header

overall_header_content_before

===

* Locations:

* Since: 3.1.0-b3

* Purpose: Add content after the page-header, but before the page-body

posting_editor_buttons_after

===

* Locations:

* Since: 3.1.0-b4

* Purpose: Add asset calls directly before the `</head>` tag

topiclist_row_prepend

===

* Locations:

* Purpose: Add data before the custom fields on the user profile when viewing

a private message

ucp_pm_viewmessage_print_head_append

===

* Locations:

+ styles/prosilver/template/ucp_prefs_view.html

+ styles/subsilver2/template/ucp_prefs_view.html

* Since: 3.1.0-a1

Display Options screen

ucp_prefs_view_radio_buttons_append

+ styles/prosilver/template/ucp_prefs_view.html

+ styles/subsilver2/template/ucp_prefs_view.html

* Since: 3.1.0-a1

Display Options screen

ucp_prefs_view_select_menu_prepend

+ styles/prosilver/template/ucp_prefs_view.html

+ styles/subsilver2/template/ucp_prefs_view.html

* Since: 3.1.0-a1

Display Options screen

ucp_prefs_view_select_menu_append

+ styles/prosilver/template/ucp_prefs_view.html

+ styles/subsilver2/template/ucp_prefs_view.html

* Since: 3.1.0-a1

Display Options screen

ucp_friend_list_before

===

* Locations: