+tests/utf/data/*.txt

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

+#!/usr/bin/env php

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

+function show_usage()

+{

+ $filename = basename(__FILE__);

+

+ echo "$filename adds repositories of a github network as remotes to a local git repository.\n";

+ echo "\n";

+

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

+ echo "\n";

+

+ echo "Scopes:\n";

+ echo " collaborators Repositories of people who have push access to the specified repository\n";

+ echo " contributors Repositories of people who have contributed to the specified repository\n";

+ echo " organisation Repositories of members of the organisation at github\n";

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

+ echo "\n";

+

+ echo "Options:\n";

+ echo " -s scope See description above (mandatory)\n";

+ echo " -u github_username Overwrites the github username (optional)\n";

+ echo " -r repository_name Overwrites the repository name (optional)\n";

+ echo " -m your_github_username Sets up ssh:// instead of git:// for pushable repositories (optional)\n";

+ echo " -d Outputs the commands instead of running them (optional)\n";

+ echo " -h This help text\n";

+

+ exit(1);

+}

+

+// Handle arguments

+$opts = getopt('s:u:r:m:dh');

+

+if (empty($opts) || isset($opts['h']))

+{

+ show_usage();

+}

+

+$scope = get_arg($opts, 's', '');

+$username = get_arg($opts, 'u', 'phpbb');

+$repository = get_arg($opts, 'r', 'phpbb3');

+$developer = get_arg($opts, 'm', '');

+$dry_run = !get_arg($opts, 'd', true);

+run(null, $dry_run);

+exit(work($scope, $username, $repository, $developer));

+

+function work($scope, $username, $repository, $developer)

+{

+ // Get some basic data

+ $network = get_network($username, $repository);

+ $collaborators = get_collaborators($username, $repository);

+

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

+ {

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

+ return 1;

+ }

+

+ switch ($scope)

+ {

+ case 'collaborators':

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

+ break;

+

+ case 'organisation':

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

+ break;

+

+ case 'contributors':

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

+ break;

+

+ case 'network':

+ $remotes = $network;

+ break;

+

+ default:

+ show_usage();

+ }

+

+ if (file_exists('.git'))

+ {

+ add_remote($username, $repository, isset($collaborators[$developer]));

+ }

+ else

+ {

+ clone_repository($username, $repository, isset($collaborators[$developer]));

+ }

+

+ // Add private security repository for developers

+ if ($username == 'phpbb' && $repository == 'phpbb3' && isset($collaborators[$developer]))

+ {

+ run("git remote add $username-security " . get_repository_url($username, "$repository-security", true));

+ }

+

+ // Skip blessed repository.

+ unset($remotes[$username]);

+

+ foreach ($remotes as $remote)

+ {

+ add_remote($remote['username'], $remote['repository'], $remote['username'] == $developer);

+ }

+

+ run('git remote update');

+}

+

+function clone_repository($username, $repository, $pushable = false)

+{

+ $url = get_repository_url($username, $repository, false);

+ run("git clone $url ./ --origin $username");

+

+ if ($pushable)

+ {

+ $ssh_url = get_repository_url($username, $repository, true);

+ run("git remote set-url --push $username $ssh_url");

+ }

+}

+

+function add_remote($username, $repository, $pushable = false)

+{

+ $url = get_repository_url($username, $repository, false);

+ run("git remote add $username $url");

+

+ if ($pushable)

+ {

+ $ssh_url = get_repository_url($username, $repository, true);

+ run("git remote set-url --push $username $ssh_url");

+ }

+}

+

+function get_repository_url($username, $repository, $ssh = false)

+{

+ $url_base = ($ssh) ? 'git@github.com:' : 'git://github.com/';

+

+ return $url_base . $username . '/' . $repository . '.git';

+}

+

+function api_request($query)

+{

+ $contents = file_get_contents("http://github.com/api/v2/json/$query");

+ if ($contents === false)

+ {

+ return false;

+ }

+ return json_decode($contents);

+}

+

+function get_contributors($username, $repository)

+{

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

+ if ($request === false)

+ {

+ return false;

+ }

+

+ $usernames = array();

+ foreach ($request->contributors as $contributor)

+ {

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

+ }

+

+ return $usernames;

+}

+

+function get_organisation_members($username)

+{

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

+ if ($request === false)

+ {

+ return false;

+ }

+

+ $usernames = array();

+ foreach ($request->users as $member)

+ {

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

+ }

+

+ return $usernames;

+}

+

+function get_collaborators($username, $repository)

+{

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

+ if ($request === false)

+ {

+ return false;

+ }

+

+ $usernames = array();

+ foreach ($request->collaborators as $collaborator)

+ {

+ $usernames[$collaborator] = $collaborator;

+ }

+

+ return $usernames;

+}

+

+function get_network($username, $repository)

+{

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

+ if ($request === false)

+ {

+ return false;

+ }

+

+ $usernames = array();

+ foreach ($request->network as $network)

+ {

+ $usernames[$network->owner] = array(

+ 'username' => $network->owner,

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

+ );

+ }

+

+ return $usernames;

+}

+

+function get_arg($array, $index, $default)

+{

+ return isset($array[$index]) ? $array[$index] : $default;

+}

+

+function run($cmd, $dry = false)

+{

+ static $dry_run;

+

+ if (is_null($cmd))

+ {

+ $dry_run = $dry;

+ }

+ else if (!empty($dry_run))

+ {

+ echo "$cmd\n";

+ }

+ else

+ {

+ passthru(escapeshellcmd($cmd));

+ }

+}

+ // Do not use (int) 0x80000000 - it evaluates to different

+ // values on 32-bit and 64-bit systems.

+ // Apparently -2147483648 is a float on 32-bit systems,

+ // despite fitting in an int, thus explicit cast is needed.

+ 'INT' => array('php_type' => 'int', 'min' => (int) -2147483648, 'max' => (int) 0x7fffffff),

+ <!-- IF S_DELETE_STYLE -->

+ <hr />

+ <dl>

+ <dt><label for="new_template_id">{L_DELETE_TEMPLATE}:</label><br /><span>{L_REPLACE_TEMPLATE_EXPLAIN}</span></dt>

+ <dd><select id="new_template_id" name="new_template_id">{S_REPLACE_TEMPLATE_OPTIONS}</select></dd>

+ </dl>

+ <dl>

+ <dt><label for="new_theme_id">{L_DELETE_THEME}:</label><br /><span>{L_REPLACE_THEME_EXPLAIN}</span></dt>

+ <dd><select id="new_theme_id" name="new_theme_id">{S_REPLACE_THEME_OPTIONS}</select></dd>

+ </dl>

+ <dl>

+ <dt><label for="new_imageset_id">{L_DELETE_IMAGESET}:</label><br /><span>{L_REPLACE_IMAGESET_EXPLAIN}</span></dt>

+ <dd><select id="new_imageset_id" name="new_imageset_id">{S_REPLACE_IMAGESET_OPTIONS}</select></dd>

+ </dl>

+ <!-- ENDIF -->

+

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

+

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

+ <br />Powered by <a href="http://www.phpbb.com/">phpBB</a> &copy; phpBB Group

+ 'bbcode_id' => array('USINT', 0),

+<div class="copyright" align="center">Powered by <a href="http://www.phpbb.com/">phpBB</a> &copy; phpBB Group</div>

+$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';

+ 'bbcode_id' => array('USINT', 0),

+* phpBB3 © Copyright phpBB Group

+<meta name="copyright" content="phpBB Group" />

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

+<meta name="copyright" content="phpBB Group" />

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

+<meta name="copyright" content="phpBB Group" />

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

+<meta name="copyright" content="phpBB Group" />

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

+<meta name="copyright" content="phpBB Group" />

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

+<meta name="copyright" content="phpBB Group" />

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

+<meta name="copyright" content="phpBB Group" />

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

+ internal;

+ internal;

+ $filename = request_var('avatar', '');

+ send_status_line(404, 'Not Found');

+ send_status_line(404, 'Not Found');

+ send_status_line(404, 'Not Found');

+ send_status_line(404, 'Not Found');

+ send_status_line(404, 'Not Found');

+ send_status_line(403, 'Forbidden');

+ send_status_line(404, 'Forbidden');

+ send_status_line(404, 'Not Found');

+ send_status_line(500, 'Internal Server Error');

+ send_status_line(404, 'Not Found');

+ send_status_line(500, 'Internal Server Error');

+ send_status_line(500, 'Internal Server Error');

+ $published = ($feed->get('published') !== NULL) ? (int) $row[$feed->get('published')] : 0;

+ $updated = ($feed->get('updated') !== NULL) ? (int) $row[$feed->get('updated')] : 0;

+ 'published' => ($published > 0) ? feed_format_date($published) : '',

+ 'updated' => ($updated > 0) ? feed_format_date($updated) : '',

+ $feed_updated_time = max($feed_updated_time, $published, $updated);

+ echo '<updated>' . ((!empty($row['updated'])) ? $row['updated'] : $row['published']) . '</updated>' . "\n";

+

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

+ {

+ echo '<published>' . $row['published'] . '</published>' . "\n";

+ }

+

+ $this->set('published', 'post_time');

+ $this->set('updated', 'post_edit_time');

+ . ' ' . $this->separator_stats . ' ' . $user->format_date($row[$this->get('published')])

+ $this->set('published', 'post_time');

+ $this->set('updated', 'post_edit_time');

+ . ' ' . $this->separator_stats . ' ' . $user->format_date($row[$this->get('published')])

+ 'p.post_id, p.topic_id, p.post_time, p.post_edit_time, p.post_approved, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, ' .

+ 'SELECT' => 'p.post_id, p.topic_id, p.post_time, p.post_edit_time, p.post_approved, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, ' .

+ 'SELECT' => 'p.post_id, p.post_time, p.post_edit_time, p.post_approved, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, ' .

+ $this->set('updated', 'forum_last_post_time');

+ t.topic_id, t.topic_title, t.topic_poster, t.topic_first_poster_name, t.topic_replies, t.topic_replies_real, t.topic_views, t.topic_time, t.topic_last_post_time,

+ p.post_id, p.post_time, p.post_edit_time, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url',

+ t.topic_id, t.topic_title, t.topic_poster, t.topic_first_poster_name, t.topic_replies, t.topic_replies_real, t.topic_views, t.topic_time, t.topic_last_post_time,

+ p.post_id, p.post_time, p.post_edit_time, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url',

+ p.post_id, p.post_time, p.post_edit_time, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url',

+ die('Fatal: ' . $this->cache_dir . ' is NOT writable.');

+ die('Fatal: Not able to open ' . $this->cache_dir . 'data_global.' . $phpEx);

+ if ($bbcode_id > BBCODE_LIMIT)

+ // index.htm files

+ $compress->add_data('', 'language/' . $row['lang_iso'] . '/index.htm');

+ $compress->add_data('', 'language/' . $row['lang_iso'] . '/email/index.htm');

+ $compress->add_data('', 'language/' . $row['lang_iso'] . '/acp/index.htm');

+ $compress->add_data('', 'language/' . $row['lang_iso'] . '/mods/index.htm');

+ $this->main_files = array("captcha_qa.$phpEx", "captcha_recaptcha.$phpEx", "common.$phpEx", "groups.$phpEx", "install.$phpEx", "mcp.$phpEx", "memberlist.$phpEx", "posting.$phpEx", "search.$phpEx", "ucp.$phpEx", "viewforum.$phpEx", "viewtopic.$phpEx", "help_bbcode.$phpEx", "help_faq.$phpEx");

+ $log_count = false;

+ if ($action == 'create' && request_var('field_default_value', '') === '')

+ $sql_select = 'style_id, style_name, template_id, theme_id, imageset_id';

+ $sql_select = 'template_id, template_name, template_path, template_storedb';

+ $sql_select = 'theme_id, theme_name, theme_path, theme_storedb';

+ $sql_select = 'imageset_id, imageset_name, imageset_path';

+ $sql = "DELETE FROM $sql_from

+ WHERE {$mode}_id = $style_id";

+ $db->sql_query($sql);

+

+

+ // Remove the components

+ $components = array('template', 'theme', 'imageset');

+ foreach ($components as $component)

+ {

+ $new_id = request_var('new_' . $component . '_id', 0);

+ $component_id = $style_row[$component . '_id'];

+ $this->remove_component($component, $component_id, $new_id, $style_id);

+ }

+ $this->remove_component($mode, $style_id, $new_id);

+ $this->display_component_options($mode, $style_row[$mode . '_id'], $style_row);

+

+

+ if ($mode == 'style')

+ {

+ $template->assign_vars(array(

+ 'S_DELETE_STYLE' => true,

+ ));

+ }

+ }

+

+ /**

+ * Remove template/theme/imageset entry from the database

+ */

+ function remove_component($component, $component_id, $new_id, $style_id = false)

+ {

+ global $db;

+

+ if (($new_id == 0) || ($component === 'template' && ($conflicts = $this->check_inheritance($component, $component_id))))

+ {

+ // We can not delete the template, as the user wants to keep the component or an other template is inheriting from this one.

+ return;

+ }

+

+ $component_in_use = array();

+ if ($component != 'style')

+ {

+ $component_in_use = $this->component_in_use($component, $component_id, $style_id);

+ }

+

+ if (($new_id == -1) && !empty($component_in_use))

+ {

+ // We can not delete the component, as it is still in use

+ return;

+ }

+

+ if ($component == 'imageset')

+ {

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

+ WHERE imageset_id = $component_id";

+ $db->sql_query($sql);

+ }

+

+ switch ($component)

+ {

+ case 'template':

+ $sql_from = STYLES_TEMPLATE_TABLE;

+ break;

+

+ case 'theme':

+ $sql_from = STYLES_THEME_TABLE;

+ break;

+

+ case 'imageset':

+ $sql_from = STYLES_IMAGESET_TABLE;;

+ break;

+ }

+

+ $sql = "DELETE FROM $sql_from

+ WHERE {$component}_id = $component_id";

+ $db->sql_query($sql);

+

+ $sql = 'UPDATE ' . STYLES_TABLE . "

+ SET {$component}_id = $new_id

+ WHERE {$component}_id = $component_id";

+ $db->sql_query($sql);

+ }

+

+ /**

+ * Display the options which can be used to replace a style/template/theme/imageset

+ */

+ function display_component_options($component, $component_id, $style_row = false, $style_id = false)

+ {

+ global $db, $template, $user;

+

+ $component_in_use = array();

+ if ($component != 'style')

+ {

+ $component_in_use = $this->component_in_use($component, $component_id, $style_id);

+ }

+

+ $sql_where = '';

+ switch ($component)

+ {

+ case 'style':

+ $sql_from = STYLES_TABLE;

+ $sql_where = 'WHERE style_active = 1';

+ break;

+

+ case 'template':

+ $sql_from = STYLES_TEMPLATE_TABLE;

+ $sql_where = 'WHERE template_inherits_id <> ' . $component_id;

+ break;

+

+ case 'theme':

+ $sql_from = STYLES_THEME_TABLE;

+ break;

+

+ case 'imageset':

+ $sql_from = STYLES_IMAGESET_TABLE;

+ break;

+ }

+

+ $s_options = '';

+ if (($component != 'style') && empty($component_in_use))

+ {

+ $sql = "SELECT {$component}_id, {$component}_name

+ FROM $sql_from

+ WHERE {$component}_id = {$component_id}";

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

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

+ $db->sql_freeresult($result);

+

+ $s_options .= '<option value="-1" selected="selected">' . $user->lang['DELETE_' . strtoupper($component)] . '</option>';

+ $s_options .= '<option value="0">' . sprintf($user->lang['KEEP_' . strtoupper($component)], $row[$component . '_name']) . '</option>';

+ }

+ else

+ {

+ $sql = "SELECT {$component}_id, {$component}_name

+ FROM $sql_from

+ $sql_where

+ ORDER BY {$component}_name ASC";

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

+

+ $s_keep_option = $s_options = '';

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

+ {

+ if ($row[$component . '_id'] != $component_id)

+ {

+ $s_options .= '<option value="' . $row[$component . '_id'] . '">' . sprintf($user->lang['REPLACE_WITH_OPTION'], $row[$component . '_name']) . '</option>';

+ }

+ else if ($component != 'style')

+ {

+ $s_keep_option = '<option value="0" selected="selected">' . sprintf($user->lang['KEEP_' . strtoupper($component)], $row[$component . '_name']) . '</option>';

+ }

+ }

+ $db->sql_freeresult($result);

+ $s_options = $s_keep_option . $s_options;

+ }

+

+ if (!$style_row)

+ {

+ $template->assign_var('S_REPLACE_' . strtoupper($component) . '_OPTIONS', $s_options);

+ }

+ else

+ {

+ $template->assign_var('S_REPLACE_OPTIONS', $s_options);

+ if ($component == 'style')

+ {

+ $components = array('template', 'theme', 'imageset');

+ foreach ($components as $component)

+ {

+ $this->display_component_options($component, $style_row[$component . '_id'], false, $component_id, true);

+ }

+ }

+ }

+ }

+

+ /**

+ * Check whether the component is still used by another style or component

+ */

+ function component_in_use($component, $component_id, $style_id = false)

+ {

+ global $db;

+

+ $component_in_use = array();

+

+ if ($style_id)

+ {

+ $sql = 'SELECT style_id, style_name

+ FROM ' . STYLES_TABLE . "

+ WHERE {$component}_id = {$component_id}

+ AND style_id <> {$style_id}

+ ORDER BY style_name ASC";

+ }

+ else

+ {

+ $sql = 'SELECT style_id, style_name

+ FROM ' . STYLES_TABLE . "

+ WHERE {$component}_id = {$component_id}

+ ORDER BY style_name ASC";

+ }

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

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

+ {

+ $component_in_use[] = $row['style_name'];

+ }

+ $db->sql_freeresult($result);

+

+ if ($component === 'template' && ($conflicts = $this->check_inheritance($component, $component_id)))

+ {

+ foreach ($conflicts as $temp_id => $conflict_data)

+ {

+ $component_in_use[] = $conflict_data['template_name'];

+ }

+ }

+

+ return $component_in_use;

+ 'x' => mt_rand($img_x - 45, $img_x - 5),

+ 'y' => mt_rand($img_y - 15, $img_y - 0),

+// BBCode hard limit

+define('BBCODE_LIMIT', 1511);

+

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

+ $last_mark = (int) $user->data['user_lastmark'];

+ t.topic_last_post_time > $last_mark AND

+ (tt.mark_time IS NULL AND ft.mark_time IS NULL)

+ if (!empty($_SERVER['SERVER_PROTOCOL']))

+ $version = $_SERVER['SERVER_PROTOCOL'];

+ }

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

+ {

+ // I cannot remember where I got this from.

+ // This code path may never be reachable in reality.

+* @param string $word word template to be replaced

+* @param bool $use_unicode whether or not to take advantage of PCRE supporting unicode

+function get_censor_preg_expression($word, $use_unicode = true)

+ static $unicode_support = null;

+ if (is_null($unicode_support))

+ $unicode_support = ((version_compare(PHP_VERSION, '5.1.0', '>=') || (version_compare(PHP_VERSION, '5.0.0-dev', '<=') && version_compare(PHP_VERSION, '4.4.0', '>='))) && @preg_match('/\p{L}/u', 'a') !== false) ? true : false;

+ // Unescape the asterisk to simplify further conversions

+ $word = str_replace('\*', '*', preg_quote($word, '#'));

+ if ($use_unicode && $unicode_support)

+ {

+ // Replace the asterisk inside the pattern, at the start and at the end of it with regexes

+ $word = preg_replace(array('#(?<=\S)\*+(?=\S)#iu', '#^\*+#', '#\*+$#'), array('(\x20*?\S*?)', '\S*?', '\S*?'), $word);

+

+ // Generate the final substitution

+ $preg_expr = '#(?<!\S)(' . $word . ')(?!\S)#iu';

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

+* If $log_count is set to false, we will skip counting all entries in the database.

+ if ($log_count !== false)

+ {

+ $sql = 'SELECT COUNT(l.log_id) AS total_entries

+ FROM ' . LOG_TABLE . ' l, ' . USERS_TABLE . " u

+ WHERE l.log_type = $log_type

+ AND l.user_id = u.user_id

+ AND l.log_time >= $limit_days

+ $sql_keywords

+ $sql_forum";

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

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

+ $db->sql_freeresult($result);

+ }

+ if ($config['check_attachment_content'] && isset($config['mime_triggers']))

+ $sql = 'SELECT p.post_id, p.poster_id, p.post_time, p.post_username, u.username, u.user_colour

+ $sql_data[TOPICS_TABLE] = 'topic_poster = ' . intval($row['poster_id']) . ', topic_first_post_id = ' . intval($row['post_id']) . ", topic_first_poster_colour = '" . $db->sql_escape($row['user_colour']) . "', topic_first_poster_name = '" . (($row['poster_id'] == ANONYMOUS) ? $db->sql_escape($row['post_username']) : $db->sql_escape($row['username'])) . "', topic_time = " . (int) $row['post_time'];

+ var $disallowed_content = array('body', 'head', 'html', 'img', 'plaintext', 'a href', 'pre', 'script', 'table', 'title');

+ $this->disallowed_content = array_diff($disallowed_content, array(''));

+ $upload = new fileupload('AVATAR_', array('jpg', 'jpeg', 'gif', 'png'), $config['avatar_filesize'], $config['avatar_min_width'], $config['avatar_min_height'], $config['avatar_max_width'], $config['avatar_max_height'], (isset($config['mime_triggers']) ? explode('|', $config['mime_triggers']) : false));

+ $log_count = false;

+ $log_count = false;

+ if (!empty($log_data))

+ // Bot user, if they have a SID in the Request URI we need to get rid of it

+ // otherwise they'll index this page with the SID, duplicate content oh my!

+ if ($bot && isset($_GET['sid']))

+ {

+ redirect(build_url(array('sid')));

+ }

+

+ break;

+// Firebird update from Firebird 2.0 to 2.1+ required?

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

+

+ // Changes from 3.0.8 to 3.0.9-RC1

+ '3.0.8' => array(

+ 'change_columns' => array(

+ BBCODES_TABLE => array(

+ 'bbcode_id' => array('USINT', 0),

+ ),

+ ),

+ ),

+

+ // Changes from 3.0.8 to 3.0.9-RC1

+ case '3.0.8':

+ // Update file extension group names to use language strings, again.

+ $sql = 'SELECT group_id, group_name

+ FROM ' . EXTENSION_GROUPS_TABLE . '

+ WHERE group_name ' . $db->sql_like_expression('EXT_GROUP_' . $db->any_char);

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

+

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

+ {

+ $sql_ary = array(

+ 'group_name' => substr($row['group_name'], 10), // Strip off 'EXT_GROUP_'

+ );

+

+ $sql = 'UPDATE ' . EXTENSION_GROUPS_TABLE . '

+ SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '

+ WHERE group_id = ' . $row['group_id'];

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

+ }

+ $db->sql_freeresult($result);

+

+ $no_updates = false;

+ break;

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

+ bbcode_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

+ bbcode_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

+ bbcode_id number(4) DEFAULT '0' NOT NULL,

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

+INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('IMAGES', 1, 1, 1, '', 0, '');

+INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('ARCHIVES', 0, 1, 1, '', 0, '');

+INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('PLAIN_TEXT', 0, 0, 1, '', 0, '');

+INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('DOCUMENTS', 0, 0, 1, '', 0, '');

+INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('REAL_MEDIA', 3, 0, 1, '', 0, '');

+INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('WINDOWS_MEDIA', 2, 0, 1, '', 0, '');

+INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('FLASH_FILES', 5, 0, 1, '', 0, '');

+INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('QUICKTIME_MEDIA', 6, 0, 1, '', 0, '');

+INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('DOWNLOADABLE_FILES', 0, 0, 1, '', 0, '');

+ bbcode_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

+ 'DELETE_STYLE_EXPLAIN' => 'Here you can remove the selected style. Take care in deleting styles, there is no undo capability.',

+ 'KEEP_IMAGESET' => 'Keep "%s" imageset',

+ 'KEEP_TEMPLATE' => 'Keep "%s" template',

+ 'KEEP_THEME' => 'Keep "%s" theme',

+

+ 'REPLACE_WITH_OPTION' => 'Replace with "%s"',

+// Page title & action URL

+$s_action = append_sid("{$phpbb_root_path}posting.$phpEx", "mode=$mode&amp;f=$forum_id");

+ <input class="button2" type="submit" value="{L_DISAPPROVE}" name="action[disapprove]" /> &nbsp;

+ <input class="button1" type="submit" value="{L_APPROVE}" name="action[approve]" />

+ <!-- IF S_USER_PM_POPUP and S_NEW_PM -->

+ var url = '{UA_POPUP_PM}';

+ window.open(url.replace(/&amp;/g, '&'), '_phpbbprivmsg', 'height=225,resizable=yes,scrollbars=yes, width=400');

+ <div class="copyright">Powered by <a href="http://www.phpbb.com/">phpBB</a> &copy; phpBB Group

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

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

+.pagination span a, .pagination span a:link, .pagination span a:visited {

+.pagination span a:active {

+ color: #5C758C;

+ background-color: #ECEDEE;

+ border-color: #B4BAC0;

+}

+

+.signature a, .signature a:visited, .signature a:hover, .signature a:active {

+.postprofile a:link, .postprofile a:visited, .postprofile dt.author a {

+.postprofile a:active {

+ color: #105289;

+}

+

+ background-image: url("{IMG_ICON_USER_ONLINE_SRC}");

+.signature a, .signature a:visited, .signature a:hover, .signature a:active {

+.postprofile a:link, .postprofile a:visited, .postprofile dt.author a {

+/* CSS spec requires a:link, a:visited, a:hover and a:active rules to be specified in this order. */

+/* See http://www.phpbb.com/bugs/phpbb3/59685 */

+.postprofile a:active {

+ font-weight: bold;

+ color: #898989;

+ text-decoration: none;

+}

+

+.postbody a:link, .postbody a:visited, .postbody a:hover, .postbody a:active {

+dl.codebox dt { display: none; }

+<!-- IF S_USER_PM_POPUP and S_NEW_PM -->

+ popup('{UA_POPUP_PM}', 400, 225, '_phpbbprivmsg');

+ <span class="copyright">Powered by <a href="http://www.phpbb.com/">phpBB</a> &copy; phpBB Group</span>

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

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

+.postreported, .postreported a:link, .postreported a:visited, .postreported a:hover, .postreported a:active {

+.postapprove, .postapprove a:link, .postapprove a:visited, .postapprove a:hover, .postapprove a:active {

+/* CSS spec requires a:link, a:visited, a:hover and a:active rules to be specified in this order. */

+/* See http://www.phpbb.com/bugs/phpbb3/59685 */

+a:active {

+ color: #005784;

+ text-decoration: none;

+}

+

+}

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

+ </testsuite>

+ </testsuites>

+

+ <filter>

+ <blacklist>

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

+ </blacklist>

+ </filter>

+</phpunit>

+ colors="true"

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

+

+ <groups>

+ <exclude>

+ <group>slow</group>

+ </exclude>

+ </groups>

+

+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

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

+want the slow tests, run:

+

+ $ phpunit --group slow

+

+$table_prefix = 'phpbb_';

+require_once 'test_framework/phpbb_database_test_connection_manager.php';

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

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

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2008 phpBB Group

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

+*

+*/

+

+class phpbb_mock_cache

+{

+ public function __construct($data = array())

+ {

+ $this->data = $data;

+

+ if (!isset($this->data['_bots']))

+ {

+ $this->data['_bots'] = array();

+ }

+ }

+

+ public function get($var_name)

+ {

+ if (isset($this->data[$var_name]))

+ {

+ return $this->data[$var_name];

+ }

+

+ return false;

+ }

+

+ public function put($var_name, $var, $ttl = 0)

+ {

+ $this->data[$var_name] = $var;

+ }

+

+ /**

+ * Obtain active bots

+ */

+ public function obtain_bots()

+ {

+ return $this->data['_bots'];

+ }

+

+ public function set_bots($bots)

+ {

+ $this->data['_bots'] = $bots;

+ }

+

+ public function checkVar(PHPUnit_Framework_Assert $test, $var_name, $data)

+ {

+ $test->assertTrue(isset($this->data[$var_name]));

+ $test->assertEquals($data, $this->data[$var_name]);

+ }

+

+ public function check(PHPUnit_Framework_Assert $test, $data, $ignore_db_info = true)

+ {

+ $cache_data = $this->data;

+

+ if ($ignore_db_info)

+ {

+ unset($cache_data['mysqli_version']);

+ }

+

+ $test->assertEquals($data, $cache_data);

+ }

+}

+

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2008 phpBB Group

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

+*

+*/

+

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

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

+

+/**

+* Extends the session class to overwrite the setting of cookies.

+*

+* The session class directly writes cookie headers making it impossible to

+* test it without warnings about sent headers. This class only stores cookie

+* data for later verification.

+*/

+class phpbb_mock_session_testable extends session

+{

+ private $_cookies = array();

+

+ public function set_cookie($name, $data, $time)

+ {

+ $this->_cookies[$name] = array($data, $time);

+ }

+

+ /**

+ * Checks if the cookies were set correctly.

+ *

+ * @param PHPUnit_Framework_Assert test The test from which this is called

+ * @param array(string => mixed) cookies The cookie data to check against.

+ * The keys are cookie names, the values can either be null to

+ * check only the existance of the cookie, or an array(d, t),

+ * where d is the cookie data to check, or null to skip the

+ * check and t is the cookie time to check, or null to skip.

+ */

+ public function check_cookies(PHPUnit_Framework_Assert $test, $cookies)

+ {

+ $test->assertEquals(array_keys($cookies), array_keys($this->_cookies), 'Incorrect cookies were set');

+

+ foreach ($cookies as $name => $cookie)

+ {

+ if (!is_null($cookie))

+ {

+ $data = $cookie[0];

+ $time = $cookie[1];

+

+ if (!is_null($data))

+ {

+ $test->assertEquals($data, $this->_cookies[$name][0], "Cookie $name contains incorrect data");

+ }

+

+ if (!is_null($time))

+ {

+ $test->assertEquals($time, $this->_cookies[$name][1], "Cookie $name expires at the wrong time");

+ }

+ }

+ }

+ }

+}

+

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

+/**

+* @group slow

+*/

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

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

+ public function test_censor_unicode($pattern, $subject)

+ $regex = get_censor_preg_expression($pattern, true);

+

+ $this->assertRegExp($regex, $subject);

+ }

+

+ /**

+ * @dataProvider censor_test_data

+ */

+ public function test_censor_no_unicode($pattern, $subject)

+ {

+ $regex = get_censor_preg_expression($pattern, false);

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

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

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

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

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

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

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

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

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

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

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

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

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

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

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

+

+class phpbb_session_continue_test extends phpbb_database_test_case

+{

+ public function getDataSet()

+ {

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

+ }

+

+ static public function session_begin_attempts()

+ {

+ return array(

+ array(

+ 'bar_session', '4', 'user agent', '127.0.0.1',

+ array(

+ array('session_id' => 'anon_session', 'session_user_id' => 1),

+ array('session_id' => 'bar_session', 'session_user_id' => 4),

+ ),

+ array(),

+ 'If a request comes with a valid session id with matching user agent and IP, no new session should be created.',

+ ),

+ array(

+ 'anon_session', '4', 'user agent', '127.0.0.1',

+ array(

+ array('session_id' => '__new_session_id__', 'session_user_id' => 1), // use generated SID

+ array('session_id' => 'bar_session', 'session_user_id' => 4),

+ ),

+ array(

+ 'u' => array('1', null),

+ 'k' => array(null, null),

+ 'sid' => array('__new_session_id__', null),

+ ),

+ 'If a request comes with a valid session id and IP but different user id and user agent, a new anonymous session is created and the session matching the supplied session id is deleted.',

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider session_begin_attempts

+ */

+ public function test_session_begin_valid_session($session_id, $user_id, $user_agent, $ip, $expected_sessions, $expected_cookies, $message)

+ {

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

+ $session_factory = new phpbb_session_testable_factory;

+ $session_factory->set_cookies(array(

+ '_sid' => $session_id,

+ '_u' => $user_id,

+ ));

+ $session_factory->merge_config_data(array(

+ 'session_length' => time(), // need to do this to allow sessions started at time 0

+ ));

+ $session_factory->merge_server_data(array(

+ 'HTTP_USER_AGENT' => $user_agent,

+ 'REMOTE_ADDR' => $ip,

+ ));

+

+ $session = $session_factory->get_session($db);

+ $session->page = array('page' => 'page', 'forum' => 0);

+

+ $session->session_begin();

+

+ $sql = 'SELECT session_id, session_user_id

+ FROM phpbb_sessions

+ ORDER BY session_user_id';

+

+ $expected_sessions = $this->replace_session($expected_sessions, $session->session_id);

+ $expected_cookies = $this->replace_session($expected_cookies, $session->session_id);

+

+ $this->assertSqlResultEquals(

+ $expected_sessions,

+ $sql,

+ $message

+ );

+

+ $session->check_cookies($this, $expected_cookies);

+

+ $session_factory->check($this);

+ }

+

+ /**

+ * Replaces recursively the value __new_session_id__ with the given session

+ * id.

+ *

+ * @param array $array An array of data

+ * @param string $session_id The new session id to use instead of the

+ * placeholder.

+ * @return array The input array with all occurances of __new_session_id__

+ * replaced.

+ */

+ public function replace_session($array, $session_id)

+ {

+ foreach ($array as $key => &$value)

+ {

+ if ($value === '__new_session_id__')

+ {

+ $value = $session_id;

+ }

+

+ if (is_array($value))

+ {

+ $value = $this->replace_session($value, $session_id);

+ }

+ }

+

+ return $array;

+ }

+}

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

+<dataset>

+ <table name="phpbb_users">

+ <column>user_id</column>

+ <column>username_clean</column>

+ <row>

+ <value>1</value>

+ <value>anonymous</value>

+ </row>

+ <row>

+ <value>3</value>

+ <value>foo</value>

+ </row>

+ <row>

+ <value>4</value>

+ <value>bar</value>

+ </row>

+ </table>

+ <table name="phpbb_sessions">

+ <column>session_id</column>

+ <column>session_user_id</column>

+ <column>session_ip</column>

+ <column>session_browser</column>

+ </table>

+</dataset>

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

+<dataset>

+ <table name="phpbb_users">

+ <column>user_id</column>

+ <column>username_clean</column>

+ <row>

+ <value>1</value>

+ <value>anonymous</value>

+ </row>

+ <row>

+ <value>3</value>

+ <value>foo</value>

+ </row>

+ <row>

+ <value>4</value>

+ <value>bar</value>

+ </row>

+ </table>

+ <table name="phpbb_sessions">

+ <column>session_id</column>

+ <column>session_user_id</column>

+ <column>session_ip</column>

+ <column>session_browser</column>

+ <row>

+ <value>anon_session</value>

+ <value>1</value>

+ <value>127.0.0.1</value>

+ <value>anonymous user agent</value>

+ </row>

+ <row>

+ <value>bar_session</value>

+ <value>4</value>

+ <value>127.0.0.1</value>

+ <value>user agent</value>

+ </row>

+ </table>

+</dataset>

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

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

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

+

+class phpbb_session_init_test extends phpbb_database_test_case

+{

+ public function getDataSet()

+ {

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

+ }

+

+ // also see security/extract_current_page.php

+

+ public function test_login_session_create()

+ {

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

+ $session_factory = new phpbb_session_testable_factory;

+

+ $session = $session_factory->get_session($db);

+ $session->page = array('page' => 'page', 'forum' => 0);

+

+ $session->session_create(3);

+

+ $sql = 'SELECT session_user_id

+ FROM phpbb_sessions';

+

+ $this->assertSqlResultEquals(

+ array(array('session_user_id' => 3)),

+ $sql,

+ 'Check if exacly one session for user id 3 was created'

+ );

+

+ $cookie_expire = $session->time_now + 31536000; // default is one year

+

+ $session->check_cookies($this, array(

+ 'u' => array(null, $cookie_expire),

+ 'k' => array(null, $cookie_expire),

+ 'sid' => array($session->session_id, $cookie_expire),

+ ));

+

+ global $SID, $_SID;

+ $this->assertEquals($session->session_id, $_SID);

+ $this->assertEquals('?sid=' . $session->session_id, $SID);

+

+ $session_factory->check($this);

+ }

+}

+

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

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

+

+/**

+* This class exists to setup an instance of phpbb's session class for testing.

+*

+* The session class has rather complex dependencies, so in order to make its

+* tests more * understandable and to make its dependencies more visible this

+* factory class sets up all the necessary global state & variable contents.

+*/

+class phpbb_session_testable_factory

+{

+ protected $config_data;

+ protected $cache_data;

+ protected $cookies;

+

+ protected $config;

+ protected $cache;

+

+ /**

+ * Initialises the factory with a set of default config and cache values.

+ */

+ public function __construct()

+ {

+ // default configuration values

+ $this->config_data = array(

+ 'allow_autologin' => false,

+ 'auth_method' => 'db',

+ 'forwarded_for_check' => true,

+ 'active_sessions' => 0, // disable

+ 'rand_seed' => 'foo',

+ 'rand_seed_last_update' => 0,

+ 'max_autologin_time' => 0,

+ 'session_length' => 100,

+ 'form_token_lifetime' => 100,

+ 'cookie_name' => '',

+ 'limit_load' => 0,

+ 'limit_search_load' => 0,

+ 'ip_check' => 3,

+ 'browser_check' => 1,

+ );

+

+ $this->cache_data = array(

+ '_bots' => array(),

+ );

+

+ $this->cookies = array();

+

+ $this->server_data = $_SERVER;

+ }

+

+ /**

+ * Retrieve the configured session class instance

+ *

+ * @param dbal $dbal The database connection to use for session data

+ * @return phpbb_mock_session_testable A session instance

+ */

+ public function get_session(dbal $dbal)

+ {

+ // set up all the global variables used by session

+ global $SID, $_SID, $db, $config, $cache;

+

+ $config = $this->config = $this->get_config_data();

+ $db = $dbal;

+

+ $cache = $this->cache = new phpbb_mock_cache($this->get_cache_data());

+ $SID = $_SID = null;

+

+ $_COOKIE = $this->cookies;

+ $_SERVER = $this->server_data;

+

+ $session = new phpbb_mock_session_testable;

+ return $session;

+ }

+

+ /**

+ * Set the cookies which should be present in the request data.

+ *

+ * @param array $cookies The cookie data, structured like $_COOKIE contents.

+ */

+ public function set_cookies(array $cookies)

+ {

+ $this->cookies = $cookies;

+ }

+

+ /**

+ * Check if the cache used for the generated session contains correct data.

+ *

+ * @param PHPUnit_Framework_Assert $test The test case to call assert methods

+ * on

+ */

+ public function check(PHPUnit_Framework_Assert $test)

+ {

+ $this->cache->check($test, $this->get_cache_data());

+ }

+

+ /**

+ * Merge config data with the current config data to be supplied to session.

+ *

+ * New values overwrite new ones.

+ *

+ * @param array $config_data The config data to merge with previous data

+ */

+ public function merge_config_data(array $config_data)

+ {

+ $this->config_data = array_merge($this->config_data, $config_data);

+ }

+

+ /**

+ * Retrieve the entire config data to be passed to the session.

+ *

+ * @return array Configuration

+ */

+ public function get_config_data()

+ {

+ return $this->config_data;

+ }

+

+ /**

+ * Merge the cache contents with more data.

+ *

+ * New values overwrite old ones.

+ *

+ * @param array $cache_data The additional cache data

+ */

+ public function merge_cache_data(array $cache_data)

+ {

+ $this->cache_data = array_merge($this->cache_data, $cache_data);

+ }

+

+ /**

+ * Retrieve the entire cache data to be passed to the session.

+ *

+ * @return array Cache contents

+ */

+ public function get_cache_data()

+ {

+ return $this->cache_data;

+ }

+

+ /**

+ * Merge the current server info ($_SERVER) with more data.

+ *

+ * New values overwrite old ones.

+ *

+ * @param array $server_data The additional server variables

+ */

+ public function merge_server_data($server_data)

+ {

+ return $this->server_data = array_merge($this->server_data, $server_data);

+ }

+

+ /**

+ * Retrieve all server variables to be passed to the session.

+ *

+ * @return array Server variables

+ */

+ public function get_server_data()

+ {

+ return $this->server_data;

+ }

+}

+

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

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

+ static private $already_connected;

+ else if (file_exists(dirname(__FILE__) . '/../test_config.php'))

+ include(dirname(__FILE__) . '/../test_config.php');

+ 'dbhost' => dirname(__FILE__) . '/../phpbb_unit_tests.sqlite2', // filename

+

+ $manager = $this->create_connection_manager($config);

+ $manager->recreate_db();

+ $manager->connect();

+ $manager->load_schema();

+ return $this->createDefaultDBConnection($manager->get_pdo(), 'testdb');

+ require_once dirname(__FILE__) . '/../../phpBB/includes/db/' . $config['dbms'] . '.php';

+ public function assertSqlResultEquals($expected, $sql, $message = '')

+ {

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

+

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

+ $rows = $db->sql_fetchrowset($result);

+ $db->sql_freeresult($result);

+

+ $this->assertEquals($expected, $rows, $message);

+ }

+

+

+ protected function create_connection_manager($config)

+ {

+ return new phpbb_database_test_connection_manager($config);

+ }

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

+class phpbb_database_test_connection_manager

+{

+ private $config;

+ private $dbms;

+ private $pdo;

+

+ /**

+ * Constructor

+ *

+ * @param array $config Tests database configuration as returned by

+ * phpbb_database_test_case::get_database_config()

+ */

+ public function __construct($config)

+ {

+ $this->config = $config;

+ $this->dbms = $this->get_dbms_data($this->config['dbms']);

+ }

+

+ /**

+ * Return the current PDO instance

+ */

+ public function get_pdo()

+ {

+ return $this->pdo;

+ }

+

+ /**

+ * Creates a PDO connection for the configured database.

+ *

+ * @param bool $use_db Whether the DSN should be tied to a

+ * particular database making it impossible

+ * to delete that database.

+ */

+ public function connect($use_db = true)

+ {

+ $dsn = $this->dbms['PDO'] . ':';

+

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

+ {

+ case 'sqlite2':

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

+ break;

+

+ case 'sqlsrv':

+ // prefix the hostname (or DSN) with Server= so using just (local)\SQLExpress

+ // works for example, further parameters can still be appended using ;x=y

+ $dsn .= 'Server=';

+ // no break -> rest like ODBC

+ case 'odbc':

+ // for ODBC assume dbhost is a suitable DSN

+ // e.g. Driver={SQL Server Native Client 10.0};Server=(local)\SQLExpress;

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

+

+ if ($use_db)

+ {

+ $dsn .= ';Database=' . $this->config['dbname'];

+ }

+ break;

+

+ default:

+ $dsn .= 'host=' . $this->config['dbhost'];

+

+ if ($use_db)

+ {

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

+ }

+ break;

+ }

+

+ try

+ {

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

+ }

+ catch (PDOException $e)

+ {

+ $cleaned_dsn = str_replace($this->config['dbpasswd'], '*password*', $dsn);

+ throw new Exception("Unable do connect to $cleaned_dsn using PDO with error: {$e->getMessage()}");

+ }

+

+ // good for debug

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

+ }

+

+ /**

+ * Load the phpBB database schema into the database

+ */

+ public function load_schema()

+ {

+ $this->ensure_connected(__METHOD__);

+

+ $directory = dirname(__FILE__) . '/../../phpBB/install/schemas/';

+ $this->load_schema_from_file($directory);

+ }

+

+ /**

+ * Drop the database if it exists and re-create it

+ *

+ * Note: This does not load the schema, and it is suggested

+ * to re-connect after calling to get use_db isolation.

+ */

+ public function recreate_db()

+ {

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

+ {

+ case 'sqlite':

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

+ {

+ unlink($this->config['dbhost']);

+ }

+ break;

+

+ default:

+ $this->connect(false);

+

+ try

+ {

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

+ }

+ catch (PDOException $e)

+ {

+ // try to delete all tables if dropping the database was not possible.

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

+ {

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

+ }

+ }

+

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

+ break;

+ }

+ }

+

+ /**

+ * Retrieves a list of all tables from the database.

+ *

+ * @return array(string)

+ */

+ public function get_tables()

+ {

+ $this->ensure_connected(__METHOD__);

+

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

+ {

+ case 'mysql':

+ case 'mysql4':

+ case 'mysqli':

+ $sql = 'SHOW TABLES';

+ break;

+

+ case 'sqlite':

+ $sql = 'SELECT name

+ FROM sqlite_master

+ WHERE type = "table"';

+ break;

+

+ case 'mssql':

+ case 'mssql_odbc':

+ case 'mssqlnative':

+ $sql = "SELECT name

+ FROM sysobjects

+ WHERE type='U'";

+ break;

+

+ case 'postgres':

+ $sql = 'SELECT relname

+ FROM pg_stat_user_tables';

+ break;

+

+ case 'firebird':

+ $sql = 'SELECT rdb$relation_name

+ FROM rdb$relations

+ WHERE rdb$view_source is null

+ AND rdb$system_flag = 0';

+ break;

+

+ case 'oracle':

+ $sql = 'SELECT table_name

+ FROM USER_TABLES';

+ break;

+ }

+

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

+

+ $tables = array();

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

+ {

+ $tables[] = current($row);

+ }

+

+ return $tables;

+ }

+

+ /**

+ * Throw an exception if not connected

+ */

+ protected function ensure_connected($method_name)

+ {

+ if (null === $this->pdo)

+ {

+ throw new Exception(sprintf('You must connect before calling %s', $method_name));

+ }

+ }

+

+ /**

+ * Compile the correct schema filename (as per create_schema_files) and

+ * load it into the database.

+ */

+ protected function load_schema_from_file($directory)

+ {

+ $schema = $this->dbms['SCHEMA'];

+

+ if ($this->config['dbms'] == 'mysql')

+ {

+ $sth = $this->pdo->query('SELECT VERSION() AS version');

+ $row = $sth->fetch(PDO::FETCH_ASSOC);

+

+ if (version_compare($row['version'], '4.1.3', '>='))

+ {

+ $schema .= '_41';

+ }

+ else

+ {

+ $schema .= '_40';

+ }

+ }

+

+ $filename = $directory . $schema . '_schema.sql';

+ $sql = $this->split_sql(file_get_contents($filename));

+

+ foreach ($sql as $query)

+ {

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

+ }

+ }

+

+ /**

+ * Split contents of an SQL file into an array of SQL statements

+ *

+ * Note: This method is not the same as split_sql_file from functions_install.

+ *

+ * @param string $sql Raw contents of an SQL file

+ *

+ * @return Array of runnable SQL statements

+ */

+ protected function split_sql($sql)

+ {

+ $sql = str_replace("\r" , '', $sql);

+ $data = preg_split('/' . preg_quote($this->dbms['DELIM'], '/') . '$/m', $sql);

+

+ $data = array_map('trim', $data);

+

+ // The empty case

+ $end_data = end($data);

+

+ if (empty($end_data))

+ {

+ unset($data[key($data)]);

+ }

+

+ if ($this->config['dbms'] == 'sqlite')

+ {

+ // remove comment lines starting with # - they are not proper sqlite

+ // syntax and break sqlite2

+ foreach ($data as $i => $query)

+ {

+ $data[$i] = preg_replace('/^#.*$/m', "\n", $query);

+ }

+ }

+

+ return $data;

+ }

+

+ /**

+ * Map a phpBB dbms driver name to dbms data array

+ */

+ protected function get_dbms_data($dbms)

+ {

+ $available_dbms = array(

+ 'firebird' => array(

+ 'SCHEMA' => 'firebird',

+ 'DELIM' => ';;',

+ 'PDO' => 'firebird',

+ ),

+ 'mysqli' => array(

+ 'SCHEMA' => 'mysql_41',

+ 'DELIM' => ';',

+ 'PDO' => 'mysql',

+ ),

+ 'mysql' => array(

+ 'SCHEMA' => 'mysql',

+ 'DELIM' => ';',

+ 'PDO' => 'mysql',

+ ),

+ 'mssql' => array(

+ 'SCHEMA' => 'mssql',

+ 'DELIM' => 'GO',

+ 'PDO' => 'odbc',

+ ),

+ 'mssql_odbc'=> array(

+ 'SCHEMA' => 'mssql',

+ 'DELIM' => 'GO',

+ 'PDO' => 'odbc',

+ ),

+ 'mssqlnative' => array(

+ 'SCHEMA' => 'mssql',

+ 'DELIM' => 'GO',

+ 'PDO' => 'sqlsrv',

+ ),

+ 'oracle' => array(

+ 'SCHEMA' => 'oracle',

+ 'DELIM' => '/',

+ 'PDO' => 'oci',

+ ),

+ 'postgres' => array(

+ 'SCHEMA' => 'postgres',

+ 'DELIM' => ';',

+ 'PDO' => 'pgsql',

+ ),

+ 'sqlite' => array(

+ 'SCHEMA' => 'sqlite',

+ 'DELIM' => ';',

+ 'PDO' => 'sqlite2',

+ ),

+ );

+

+ if (isset($available_dbms[$dbms]))

+ {

+ return $available_dbms[$dbms];

+ }

+ else

+ {

+ $message = "Supplied dbms \"$dbms\" is not a valid phpBB dbms, must be one of: ";

+ $message .= implode(', ', array_keys($available_dbms));

+ throw new Exception($message);

+ }

+ }

+}

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

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

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

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

+

+class phpbb_user_lang_test extends phpbb_test_case

+{

+ public function test_user_lang_sprintf()

+ {

+ $user = new user;

+ $user->lang = array(

+ 'FOO' => 'BAR',

+ 'BARZ' => 'PENG',

+ 'EMPTY' => '',

+ 'ZERO' => '0',

+ 'STR' => '%d %s, %d topics',

+ 'STR2' => '%d foos',

+ 'ARRY' => array(

+ 0 => 'No posts', // 0

+ 1 => '1 post', // 1

+ 2 => '%d posts', // 2+

+ ),

+ );

+

+ // No param

+ $this->assertEquals($user->lang('FOO'), 'BAR');

+ $this->assertEquals($user->lang('EMPTY'), '');

+ $this->assertEquals($user->lang('ZERO'), '0');

+

+ // Invalid index

+ $this->assertEquals($user->lang('VOID'), 'VOID');

+

+ // Unnecessary param

+ $this->assertEquals($user->lang('FOO', 2), 'BAR');

+ $this->assertEquals($user->lang('FOO', 2, 3), 'BAR');

+ $this->assertEquals($user->lang('FOO', 2, 3, 'BARZ'), 'BAR');

+

+ // String

+ $this->assertEquals($user->lang('STR', 24, 'x', 42), '24 x, 42 topics');

+ $this->assertEquals($user->lang('STR2', 64), '64 foos');

+

+ // Array

+ $this->assertEquals($user->lang('ARRY', 0), 'No posts');

+ $this->assertEquals($user->lang('ARRY', 1), '1 post');

+ $this->assertEquals($user->lang('ARRY', 2), '2 posts');

+ $this->assertEquals($user->lang('ARRY', 123), '123 posts');

+

+ // Bug PHPBB3-9949

+ $this->assertEquals($user->lang('ARRY', 1, 2), '1 post');

+ $this->assertEquals($user->lang('ARRY', 1, 's', 2), '1 post');

+ }

+}

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

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

+

+/**

+* @group slow

+*/

+class phpbb_utf_normalizer_test extends phpbb_test_case

+{

+ static public function setUpBeforeClass()

+ {

+ self::download('http://www.unicode.org/Public/UNIDATA/NormalizationTest.txt', dirname(__FILE__).'/data');

+ self::download('http://www.unicode.org/Public/UNIDATA/UnicodeData.txt', dirname(__FILE__).'/data');

+ }

+

+ public function test_normalizer()

+ {

+ $test_suite = array(

+ /**

+ * NFC

+ * c2 == NFC(c1) == NFC(c2) == NFC(c3)

+ * c4 == NFC(c4) == NFC(c5)

+ */

+ 'NFC' => array(

+ 'c2' => array('c1', 'c2', 'c3'),

+ 'c4' => array('c4', 'c5')

+ ),

+

+ /**

+ * NFD

+ * c3 == NFD(c1) == NFD(c2) == NFD(c3)

+ * c5 == NFD(c4) == NFD(c5)

+ */

+ 'NFD' => array(

+ 'c3' => array('c1', 'c2', 'c3'),

+ 'c5' => array('c4', 'c5')

+ ),

+

+ /**

+ * NFKC

+ * c4 == NFKC(c1) == NFKC(c2) == NFKC(c3) == NFKC(c4) == NFKC(c5)

+ */

+ 'NFKC' => array(

+ 'c4' => array('c1', 'c2', 'c3', 'c4', 'c5')

+ ),

+

+ /**

+ * NFKD

+ * c5 == NFKD(c1) == NFKD(c2) == NFKD(c3) == NFKD(c4) == NFKD(c5)

+ */

+ 'NFKD' => array(

+ 'c5' => array('c1', 'c2', 'c3', 'c4', 'c5')

+ )

+ );

+

+ $tested_chars = array();

+

+ $fp = fopen(dirname(__FILE__).'/data/NormalizationTest.txt', 'rb');

+ while (!feof($fp))

+ {

+ $line = fgets($fp);

+

+ if ($line[0] == '@')

+ {

+ continue;

+ }

+

+ if (!strpos(' 0123456789ABCDEF', $line[0]))

+ {

+ continue;

+ }

+

+ list($c1, $c2, $c3, $c4, $c5) = explode(';', $line);

+

+ if (!strpos($c1, ' '))

+ {

+ /**

+ * We are currently testing a single character, we add it to the list of

+ * characters we have processed so that we can exclude it when testing

+ * for invariants

+ */

+ $tested_chars[$c1] = 1;

+ }

+

+ foreach ($test_suite as $form => $serie)

+ {

+ foreach ($serie as $expected => $tests)

+ {

+ $hex_expected = ${$expected};

+ $utf_expected = $this->hexseq_to_utf($hex_expected);

+

+ foreach ($tests as $test)

+ {

+ $utf_result = $utf_expected;

+ call_user_func(array('utf_normalizer', $form), &$utf_result);

+

+ $hex_result = $this->utf_to_hexseq($utf_result);

+ $this->assertEquals($utf_expected, $utf_result, "$expected == $form($test) ($hex_expected != $hex_result)");

+ }

+ }

+ }

+ }

+ fclose($fp);

+

+ return $tested_chars;

+ }

+

+ /**

+ * @depends test_normalizer

+ */

+ public function test_invariants(array $tested_chars)

+ {

+ $fp = fopen(dirname(__FILE__).'/data/UnicodeData.txt', 'rb');

+

+ while (!feof($fp))

+ {

+ $line = fgets($fp, 1024);

+

+ if (!$pos = strpos($line, ';'))

+ {

+ continue;

+ }

+

+ $hex_tested = $hex_expected = substr($line, 0, $pos);

+

+ if (isset($tested_chars[$hex_tested]))

+ {

+ continue;

+ }

+

+ $utf_expected = $this->hex_to_utf($hex_expected);

+

+ if ($utf_expected >= UTF8_SURROGATE_FIRST

+ && $utf_expected <= UTF8_SURROGATE_LAST)

+ {

+ /**

+ * Surrogates are illegal on their own, we expect the normalizer

+ * to return a replacement char

+ */

+ $utf_expected = UTF8_REPLACEMENT;

+ $hex_expected = $this->utf_to_hexseq($utf_expected);

+ }

+

+ foreach (array('nfc', 'nfkc', 'nfd', 'nfkd') as $form)

+ {

+ $utf_result = $utf_expected;

+ call_user_func(array('utf_normalizer', $form), &$utf_result);

+ $hex_result = $this->utf_to_hexseq($utf_result);

+

+ $this->assertEquals($utf_expected, $utf_result, "$hex_expected == $form($hex_tested) ($hex_expected != $hex_result)");

+ }

+ }

+ fclose($fp);

+ }

+

+ /**

+ * Convert a UTF string to a sequence of codepoints in hexadecimal

+ *

+ * @param string $utf UTF string

+ * @return integer Unicode codepoints in hex

+ */

+ protected function utf_to_hexseq($str)

+ {

+ $pos = 0;

+ $len = strlen($str);

+ $ret = array();

+

+ while ($pos < $len)

+ {

+ $c = $str[$pos];

+ switch ($c & "\xF0")

+ {

+ case "\xC0":

+ case "\xD0":

+ $utf_char = substr($str, $pos, 2);

+ $pos += 2;

+ break;

+

+ case "\xE0":

+ $utf_char = substr($str, $pos, 3);

+ $pos += 3;

+ break;

+

+ case "\xF0":

+ $utf_char = substr($str, $pos, 4);

+ $pos += 4;

+ break;

+

+ default:

+ $utf_char = $c;

+ ++$pos;

+ }

+

+ $hex = dechex($this->utf_to_cp($utf_char));

+

+ if (!isset($hex[3]))

+ {

+ $hex = substr('000' . $hex, -4);

+ }

+

+ $ret[] = $hex;

+ }

+

+ return strtr(implode(' ', $ret), 'abcdef', 'ABCDEF');

+ }

+

+ /**

+ * Convert a UTF-8 char to its codepoint

+ *

+ * @param string $utf_char UTF-8 char

+ * @return integer Unicode codepoint

+ */

+ protected function utf_to_cp($utf_char)

+ {

+ switch (strlen($utf_char))

+ {

+ case 1:

+ return ord($utf_char);

+

+ case 2:

+ return ((ord($utf_char[0]) & 0x1F) << 6) | (ord($utf_char[1]) & 0x3F);

+

+ case 3:

+ return ((ord($utf_char[0]) & 0x0F) << 12) | ((ord($utf_char[1]) & 0x3F) << 6) | (ord($utf_char[2]) & 0x3F);

+

+ case 4:

+ return ((ord($utf_char[0]) & 0x07) << 18) | ((ord($utf_char[1]) & 0x3F) << 12) | ((ord($utf_char[2]) & 0x3F) << 6) | (ord($utf_char[3]) & 0x3F);

+

+ default:

+ throw new RuntimeException('UTF-8 chars can only be 1-4 bytes long');

+ }

+ }

+

+ /**

+ * Return a UTF string formed from a sequence of codepoints in hexadecimal

+ *

+ * @param string $seq Sequence of codepoints, separated with a space

+ * @return string UTF-8 string

+ */

+ protected function hexseq_to_utf($seq)

+ {

+ return implode('', array_map(array($this, 'hex_to_utf'), explode(' ', $seq)));

+ }

+

+ /**

+ * Convert a codepoint in hexadecimal to a UTF-8 char

+ *

+ * @param string $hex Codepoint, in hexadecimal

+ * @return string UTF-8 char

+ */

+ protected function hex_to_utf($hex)

+ {

+ return $this->cp_to_utf(hexdec($hex));

+ }

+

+ /**

+ * Convert a codepoint to a UTF-8 char

+ *

+ * @param integer $cp Unicode codepoint

+ * @return string UTF-8 string

+ */

+ protected function cp_to_utf($cp)

+ {

+ if ($cp > 0xFFFF)

+ {

+ return chr(0xF0 | ($cp >> 18)) . chr(0x80 | (($cp >> 12) & 0x3F)) . chr(0x80 | (($cp >> 6) & 0x3F)) . chr(0x80 | ($cp & 0x3F));

+ }

+ else if ($cp > 0x7FF)

+ {

+ return chr(0xE0 | ($cp >> 12)) . chr(0x80 | (($cp >> 6) & 0x3F)) . chr(0x80 | ($cp & 0x3F));

+ }

+ else if ($cp > 0x7F)

+ {

+ return chr(0xC0 | ($cp >> 6)) . chr(0x80 | ($cp & 0x3F));

+ }

+ else

+ {

+ return chr($cp);

+ }

+ }

+

+ // chunked download helper

+ static protected function download($url, $to)

+ {

+ $target = $to . '/' . basename($url);

+

+ if (file_exists($target))

+ {

+ return;

+ }

+

+ if (!$fpr = fopen($url, 'rb'))

+ {

+ throw new RuntimeException("Failed to download $url");

+ }

+

+ if (!$fpw = fopen($target, 'wb'))

+ {

+ throw new RuntimeException("Failed to open $target for writing");

+ }

+

+ $chunk = 32768;

+

+ while (!feof($fpr))

+ {

+ fwrite($fpw, fread($fpr, $chunk));

+ }

+ fclose($fpr);

+ fclose($fpw);

+ }

+}

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

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