language: php

php:

- 5.4

env:

<project name="phpBB" description="The phpBB forum software" default="all" basedir="../">

<!-- a few settings for the build -->

<!-- no configuration should be needed beyond this point -->

<property name="oldversions" value="${olderversions}, ${prevversion}" />

</form>

<!-- IF not S_OWN_ACCOUNT -->

<!-- ENDIF -->

<!-- ENDIF -->

<?php

//

// Security message:

<?php

//

// Security message:

<?php

//

// Security message:

* @copyright (c) 2009, 2010 phpBB Group

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

*

* This script will check your database for potentially dangerous flash BBCode tags

*/

//

<?php

*/

//

<?php

//

// Security message:

//

<?php

//

// Security message:

<?php

//

// Security message:

*

*/

//

// Security message:

//

phpBB Lead Developer: naderman (Nils Adermann)

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

bantu (Andreas Fischer)

imkingdavid (David King)

igorw (Igor Wiedler)

<ol>

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

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

<li><a href="#v309">Changes since 3.0.9</a></li>

<li><a href="#v308">Changes since 3.0.8</a></li>

<li><a href="#v307-PL1">Changes since 3.0.7-PL1</a></li>

<div class="content">

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

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

<p>This is the <em>official</em> location for all supported language sets. If you download a package from a 3rd party site you do so with the understanding that we cannot offer support. So please, do not ask for help in these cases!</p>

<p>Although phpBB Group are rather proud of the included styles we realise that they may not be to everyone's tastes. Therefore phpBB3 allows styles to be switched with relative ease. Firstly you need to locate and download a style you like. We maintain such a site at</p>

<p><strong>Please note</strong> that 3rd party styles downloaded for versions of phpBB2 will <strong>not</strong> work in phpBB3.</p>

<p>Although not officially supported by phpBB Group, phpBB has a thriving modification scene. These third party modifications to the standard phpBB extend its capabilities still further and can be found at:</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 modification and see if the problem is resolved.</p>

'allow_nocensors' => array('lang' => 'ALLOW_NO_CENSORS', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

'allow_bookmarks' => array('lang' => 'ALLOW_BOOKMARKS', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

'allow_birthdays' => array('lang' => 'ALLOW_BIRTHDAYS', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

'allow_quick_reply' => array('lang' => 'ALLOW_QUICK_REPLY', 'validate' => 'bool', 'type' => 'custom', 'method' => 'quick_reply', 'explain' => true),

'legend2' => 'ACP_LOAD_SETTINGS',

*/

class acp_database

{

var $u_action;

function main($id, $mode)

global $cache, $db, $user, $auth, $template, $table_prefix;

global $config, $phpbb_root_path, $phpbb_admin_path, $phpEx;

$user->add_lang('acp/database');

$this->tpl_name = 'acp_database';

{

case 'download':

$type = request_var('type', '');

$format = request_var('method', '');

$where = request_var('where', '');

break;

default:

asort($tables);

foreach ($tables as $table_name)

{

class acp_styles

{

public $u_action;

protected $u_base_action;

protected $s_hidden_fields;

protected $mode;

$user_row['posts_in_queue'] = (int) $db->sql_fetchfield('posts_in_queue');

$db->sql_freeresult($result);

$template->assign_vars(array(

'L_NAME_CHARS_EXPLAIN' => $user->lang($config['allow_name_chars'] . '_EXPLAIN', $user->lang('CHARACTERS', (int) $config['min_name_chars']), $user->lang('CHARACTERS', (int) $config['max_name_chars'])),

'L_CHANGE_PASSWORD_EXPLAIN' => $user->lang($config['pass_complex'] . '_EXPLAIN', $user->lang('CHARACTERS', (int) $config['min_pass_chars']), $user->lang('CHARACTERS', (int) $config['max_pass_chars'])),

'USER_EMAIL' => $user_row['user_email'],

'USER_WARNINGS' => $user_row['user_warnings'],

'USER_POSTS' => $user_row['user_posts'],

'USER_INACTIVE_REASON' => $inactive_reason,

));

{

if (!@ldap_bind($ldap, htmlspecialchars_decode($config['ldap_user']), htmlspecialchars_decode($config['ldap_password'])))

{

}

}

}

/**

* Run more than one insert statement.

*

* @param string $table table name to run the statements on

}

/**

* Build LIKE expression

* @access private

*/

}

/**

* Build LIKE expression

* @access private

*/

}

/**

* Build LIKE expression

* @access private

*/

}

else

{

WHERE t.forum_id = ' . $forum_id . '

AND t.topic_last_post_time > ' . $mark_time_forum . '

AND t.topic_moved_id = 0 ' .

$sql_update_unapproved . '

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

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

$db->sql_freeresult($result);

case 'email':

// Regex written by James Watts and Francisco Jose Martin Moreno

// http://fightingforalostcause.net/misc/2006/compare-email-regex.php

break;

case 'bbcode_htm':

}

return $utf8_pcre_properties;

}

{

$sql_keywords .= $db->sql_in_set('l.log_operation', $operations) . ' OR ';

}

}

if ($log_count !== false)

if ($row['forum_last_post_id'])

{

$last_post_subject = $row['forum_last_post_subject'];

$last_post_time = $user->format_date($row['forum_last_post_time']);

$last_post_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id_last_post'] . '&amp;p=' . $row['forum_last_post_id']) . '#p' . $row['forum_last_post_id'];

}

else

{

}

// Output moderator listing ... if applicable

'S_LOCKED_FORUM' => ($row['forum_status'] == ITEM_LOCKED) ? true : false,

'S_LIST_SUBFORUMS' => ($row['display_subforum_list']) ? true : false,

'S_SUBFORUMS' => (sizeof($subforums_list)) ? true : false,

'S_FEED_ENABLED' => ($config['feed_forum'] && !phpbb_optionget(FORUM_OPTION_FEED_EXCLUDE, $row['forum_options']) && $row['forum_type'] == FORUM_POST) ? true : false,

'FORUM_ID' => $row['forum_id'],

'FORUM_FOLDER_IMG_ALT' => isset($user->lang[$folder_alt]) ? $user->lang[$folder_alt] : '',

'FORUM_IMAGE' => ($row['forum_image']) ? '<img src="' . $phpbb_root_path . $row['forum_image'] . '" alt="' . $user->lang[$folder_alt] . '" />' : '',

'FORUM_IMAGE_SRC' => ($row['forum_image']) ? $phpbb_root_path . $row['forum_image'] : '',

'LAST_POST_TIME' => $last_post_time,

'LAST_POSTER' => get_username_string('username', $row['forum_last_poster_id'], $row['forum_last_poster_name'], $row['forum_last_poster_colour']),

'LAST_POSTER_COLOUR' => get_username_string('colour', $row['forum_last_poster_id'], $row['forum_last_poster_name'], $row['forum_last_poster_colour']),

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

}

return $config_data;

}

}

/**

* Rebuild message header

*/

function rebuild_header($check_ary)

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

{

$field = ($data['address_list']['g'][$row['group_id']] == 'to') ? 'to' : 'bcc';

$recipients[$row['user_id']] = $field;

}

$filename = $url['path'];

$filesize = 0;

$errno = 0;

$errstr = '';

$block = @fread($fsock, 1024);

$filesize += strlen($block);

{

$file = new fileerror(sprintf($user->lang[$this->error_prefix . 'WRONG_FILESIZE'], $max_filesize['value'], $max_filesize['unit']));

return $file;

{

$length = (int) str_replace('content-length: ', '', strtolower($line));

{

$file = new fileerror(sprintf($user->lang[$this->error_prefix . 'WRONG_FILESIZE'], $max_filesize['value'], $max_filesize['unit']));

return $file;

WHERE session_user_id = ' . $user_id;

$db->sql_query($sql);

{

}

$db->sql_transaction('commit');

}

}

{

$sql = 'SELECT u.*, s.*

FROM ' . SESSIONS_TABLE . ' s, ' . USERS_TABLE . " u

// Autoloading of dependencies.

// Three options are supported:

// 1. If dependencies are installed with Composer, Composer will create a

// automatically used by phpBB. This is the default mode that phpBB

// will use when shipped.

// 2. To disable composer autoloading, PHPBB_NO_COMPOSER_AUTOLOAD can be specified.

}

else

{

{

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

}

}

$starttime = explode(' ', microtime());

// this column was removed from the database updater

// after 3.0.9-RC3 was released. It might still exist

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

// removing a primary key.

// 'attempt_id' => array('UINT', NULL, 'auto_increment'),

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

// No changes from 3.0.10 to 3.0.11-RC1

'3.0.10' => array(),

// Changes from 3.1.0-dev to 3.1.0-A1

'3.1.0-dev' => array(

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

}

$no_updates = false;

break;

}

}

$no_updates = false;

if (!isset($config['assets_version']))

function main($mode, $sub)

{

switch ($sub)

{

case 'intro':

$this->page_title = $lang['SUB_INTRO'];

$template->assign_vars(array(

INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_dateformat', 'D M d, Y g:i a');

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

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

INSERT INTO phpbb_config (config_name, config_value) VALUES ('display_order', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('edit_time', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('delete_time', '0');

'ATTACH_EXT_GROUPS_URL' => 'Extension groups',

'ATTACH_ID' => 'ID',

'ATTACH_MAX_FILESIZE' => 'Maximum file size',

'ATTACH_MAX_PM_FILESIZE' => 'Maximum file size messaging',

'ATTACH_MAX_PM_FILESIZE_EXPLAIN' => 'Maximum size of each file, with 0 being unlimited, attached to a private message.',

'ATTACH_ORPHAN_URL' => 'Orphan attachments',

'DEFAULT_STYLE' => 'Default style',

'DISABLE_BOARD' => 'Disable board',

'DISABLE_BOARD_EXPLAIN' => 'This will make the board unavailable to users. You can also enter a short (255 character) message to display if you wish.',

'OVERRIDE_STYLE' => 'Override user style',

'OVERRIDE_STYLE_EXPLAIN' => 'Replaces user’s style with the default.',

'SITE_DESC' => 'Site description',

'MAX_AVATAR_SIZE' => 'Maximum avatar dimensions',

'MAX_AVATAR_SIZE_EXPLAIN' => 'Width x Height in pixels.',

'MAX_FILESIZE' => 'Maximum avatar file size',

'MIN_AVATAR_SIZE' => 'Minimum avatar dimensions',

'MIN_AVATAR_SIZE_EXPLAIN' => 'Width x Height in pixels.',

));

'USER_GROUP_SPECIAL' => 'Pre-defined groups user is a member of',

'USER_LIFTED_NR' => 'Successfully removed the user’s newly registered status.',

'USER_NO_ATTACHMENTS' => 'There are no attached files to display.',

'USER_OUTBOX_EMPTIED' => 'Successfully emptied user’s private message outbox.',

'USER_OUTBOX_EMPTY' => 'The user’s private message outbox was already empty.',

'USER_OVERVIEW_UPDATED' => 'User details updated.',

),

'EDIT_POST' => 'Edit post',

'EMAIL' => 'Email', // Short form for EMAIL_ADDRESS

'EMAIL_ADDRESS' => 'Email address',

'EMAIL_SMTP_ERROR_RESPONSE' => 'Ran into problems sending email at <strong>Line %1$s</strong>. Response: %2$s.',

'CREATE_FOLDER' => 'Add folder…',

'CURRENT_IMAGE' => 'Current image',

'CURRENT_PASSWORD' => 'Current password',

'CUR_PASSWORD_EMPTY' => 'You did not enter your current password.',

'CUR_PASSWORD_ERROR' => 'The current password you entered is incorrect.',

'CUSTOM_DATEFORMAT' => 'Custom…',

<dd class="posts">{forumrow.POSTS} <dfn>{L_POSTS}</dfn></dd>

<dd class="lastpost"><span>

<!-- IF forumrow.U_UNAPPROVED_TOPICS --><a href="{forumrow.U_UNAPPROVED_TOPICS}">{UNAPPROVED_IMG}</a><!-- ENDIF -->

<!-- IF not S_IS_BOT --><a href="{forumrow.U_LAST_POST}">{LAST_POST_IMG}</a> <!-- ENDIF --><br />{forumrow.LAST_POST_TIME}<!-- ELSE -->{L_NO_POSTS}<br />&nbsp;<!-- ENDIF --></span>

</dd>

<!-- ENDIF -->

<fieldset>

<dl>

<dd><input type="password" name="cur_password" id="cur_password" maxlength="255" value="{CUR_PASSWORD}" class="inputbox" title="{L_CURRENT_PASSWORD}" /></dd>

</dl>

</fieldset>

</div>

<fieldset class="submit-buttons">

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

{S_FORM_TOKEN}

</fieldset>

<td class="row2" align="center"><p class="topicdetails">{forumrow.POSTS}</p></td>

<td class="row2" align="center" nowrap="nowrap">

<!-- IF forumrow.LAST_POST_TIME -->

<p class="topicdetails"><!-- IF forumrow.U_UNAPPROVED_TOPICS --><a href="{forumrow.U_UNAPPROVED_TOPICS}" class="imageset">{UNAPPROVED_IMG}</a>&nbsp;<!-- ENDIF -->{forumrow.LAST_POST_TIME}</p>

<p class="topicdetails">{forumrow.LAST_POSTER_FULL}

<!-- IF not S_IS_BOT --><a href="{forumrow.U_LAST_POST}" class="imageset">{LAST_POST_IMG}</a><!-- ENDIF -->

<th colspan="2">{L_CONFIRM_CHANGES}</th>

</tr>

<tr>

<td class="row2"><input type="password" class="post" name="cur_password" size="30" maxlength="255" value="{CUR_PASSWORD}" /></td>

</tr>

<tr>

Database Tests

--------------

By default all tests requiring a database connection will use sqlite. If you

do not have sqlite installed the tests will be skipped. If you wish to run the

tests on a different database you have to create a test_config.php file within

<?php

$dbms = 'mysqli';

$dbuser = 'user';

$dbpasswd = 'password';

$ PHPBB_TEST_DBMS='mysqli' PHPBB_TEST_DBHOST='localhost' \

PHPBB_TEST_DBNAME='database' PHPBB_TEST_DBUSER='user' \

Running

=======

$ phpunit

Slow tests

--------------

Certain tests, such as the UTF-8 normalizer or the DNS tests tend to be slow.

Thus these tests are in the `slow` group, which is excluded by default. You can

$ phpunit --group slow

================

Further information is available on phpbb wiki:

'c_bool' => 0,

'c_vchar' => '',

'c_vchar_size' => '',

'c_xstext' => '',

'c_stext' => '',

'c_text' => '',

*/

public function test_created_column($column_name, $column_value)

{

$row_insert = self::get_default_values();

$row_insert[$column_name] = $column_value;

$this->assertEquals($row_expect[$column_name], $row_actual[$column_name], "Column $column_name of type $type should have equal return and input value.");

}

public function test_list_columns()

{

$this->assertEquals(

{

$db = $this->new_dbal();

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

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

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

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

}

}

}

}

public function setUp()

{

parent::setUp();

array('alice_foo@bar.phpbb.com'),

array('alice+tag@foo.phpbb.com'),

array('alice&amp;tag@foo.phpbb.com'),

//array('"John Doe"@example.com'),

//array('Alice@[192.168.2.1]'), // IPv4

array('! "#$%(),/;<>[]`|@invalidCharsInLocal.org'),

array('invalidCharsInDomain@! "#$%(),/;<>_[]`|.org'),

array('local@SecondLevelDomainNamesAreInvalidIfTheyAreLongerThan64Charactersss.org'),

);

}

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

*

*/

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

protected $db = null;

protected $extension_manager = null;

static protected $config = array();

static protected $already_installed = false;

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

}

$this->root_url = self::$config['phpbb_functional_url'];

}

public function request($method, $path)

$db_conn_mgr = new phpbb_database_test_connection_manager($config);

$db_conn_mgr->recreate_db();

}

}

));

}

{

$config = array_merge($config, array(

'dbms' => $dbms,

<testsuites>

<testsuite name="phpBB Test Suite">

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

</testsuite>

</testsuites>

<testsuites>

<testsuite name="phpBB Test Suite">

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

</testsuite>

</testsuites>