+phpBB/images/avatars/gallery/*

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

+# Check for empty commit message

+if ! grep -qv '^#' "$1"

+then

+ # Commit message is empty (or contains only comments).

+ # Let git handle this.

+ # It will abort with a message like so:

+ #

+ # Aborting commit due to empty commit message.

+ exit 0

+fi

+

+ echo "$line" | grep -Eq "^\[(ticket/[0-9]+|feature/$branch_regex|task/$branch_regex)\] .+$"

+ result=$?

+ if ! echo "$line" | grep -Eq "^\[(ticket/[0-9]+|feature/$branch_regex|task/$branch_regex)\] [A-Z].+$"

+ then

+ # Don't be too strict.

+ # Commits may be temporary, intended to be squashed later.

+ # Just issue a warning here.

+ echo "Warning: heading should be a sentence beginning with a capital letter." 1>&2

+ echo "You entered:" 1>&2

+ echo "$line" 1>&2

+ fi

+ # restore exit code

+ (exit $result)

+ "possibly-eof")

+ # Allow empty and/or comment lines at the end

+ ! tail -n +"$i" "$1" |grep -qvE '^($|#)'

+ ;;

+ expecting="footer possibly-eof";

+ "possibly-eof")

+ expecting="eof";

+ ;;

+ tail="$(printf "\n\nPHPBB3-${branch##ticket/}")";

+ echo "[$branch] $tail$(cat "$1")" > "$1"

+#!/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),

+ document.getElementById('acp_unban').unbanlength.value = ban_length[option];

+ <dd><label><input onclick="dE('posts', -1)" type="radio" class="radio" name="special_rank" value="1" id="special_rank"<!-- IF S_SPECIAL_RANK --> checked="checked"<!-- ENDIF --> />{L_YES}</label>

+ <label><input onclick="dE('posts', 1)" type="radio" class="radio" name="special_rank" value="0"<!-- IF not S_SPECIAL_RANK --> checked="checked"<!-- ENDIF --> /> {L_NO}</label></dd>

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

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

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

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

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

+ ckwalsh (Cullen Walsh)

+ nn- (Oleg Pudeyev)

+Contributions by: leviatan21 (Gabriel Vazquez)

+phpBB Developers: A_Jelly_Doughnut (Josh Woody) [01/2010 - 11/2010]

+ Ashe (Ludovic Arnaud) [10/2002 - 11/2003, 06/2006 - 10/2006]

+ BartVB (Bart van Bragt) [11/2000 - 03/2006]

+ DavidMJ (David M.) [12/2005 - 08/2009]

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

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

+ TerraFrost (Jim Wigginton) [04/2009 - 01/2011]

+ Vic D'Elfant (Vic D'Elfant) [04/2007 - 04/2009]

+ <p>Some of these functions are only chosen over others because of personal preference and having no other benefit than to be consistent over the code.</p>

+

+ # Compression levels over 6 do not give an appreciable improvement

+ # in compression ratio, but take more resources.

+

+ # IE 6 and lower do not support gzip with Vary correctly.

+ gzip_disable "msie6";

+ # Before nginx 0.7.63:

+ #gzip_disable "MSIE [1-6]\.";

+ # default specifies that this block is to be used when

+ # no other block matches.

+ listen 80 default;

+

+ # Default port is 80.

+ #listen 80;

+

+

+ # A trick from http://wiki.nginx.org/Pitfalls#Taxing_Rewrites:

+ rewrite ^ http://www.myforums.com$request_uri permanent;

+ # Equivalent to:

+ #rewrite ^(.*)$ http://www.myforums.com$1 permanent;

+ #listen 80;

+ # deny was ignored before 0.8.40 for connections over IPv6.

+ # Use internal directive to prohibit access on older versions.

+ 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', '') === '')

+ $template_file = preg_replace('#\.{2,}#', '.', $template_file);

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

+

+ var $connect_error = '';

+ if ($this->persistency)

+ {

+ if (!function_exists('ibase_pconnect'))

+ {

+ $this->connect_error = 'ibase_pconnect function does not exist, is interbase extension installed?';

+ return $this->sql_error('');

+ }

+ $this->db_connect_id = @ibase_pconnect($use_database, $this->user, $sqlpassword, false, false, 3);

+ }

+ else

+ {

+ if (!function_exists('ibase_connect'))

+ {

+ $this->connect_error = 'ibase_connect function does not exist, is interbase extension installed?';

+ return $this->sql_error('');

+ }

+ $this->db_connect_id = @ibase_connect($use_database, $this->user, $sqlpassword, false, false, 3);

+ }

+ // Do not call ibase_service_attach if connection failed,

+ // otherwise error message from ibase_(p)connect call will be clobbered.

+ if ($this->db_connect_id && function_exists('ibase_service_attach') && $this->server)

+ {

+ $this->service_handle = @ibase_service_attach($this->server, $this->user, $sqlpassword);

+ }

+ else

+ {

+ $this->service_handle = false;

+ }

+ // Need special handling here because ibase_errmsg returns

+ // connection errors, however if the interbase extension

+ // is not installed then ibase_errmsg does not exist and

+ // we cannot call it.

+ if (function_exists('ibase_errmsg'))

+ {

+ $msg = @ibase_errmsg();

+ if (!$msg)

+ {

+ $msg = $this->connect_error;

+ }

+ }

+ else

+ {

+ $msg = $this->connect_error;

+ }

+ 'message' => $msg,

+if (!class_exists('phpbb_error_collector'))

+{

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

+}

+

+ var $connect_error = '';

+ if (!function_exists('pg_pconnect'))

+ {

+ $this->connect_error = 'pg_pconnect function does not exist, is pgsql extension installed?';

+ return $this->sql_error('');

+ }

+ $collector = new phpbb_error_collector;

+ $collector->install();

+ if (!function_exists('pg_connect'))

+ {

+ $this->connect_error = 'pg_connect function does not exist, is pgsql extension installed?';

+ return $this->sql_error('');

+ }

+ $collector = new phpbb_error_collector;

+ $collector->install();

+ $collector->uninstall();

+

+ $this->connect_error = $collector->format_errors();

+ // pg_last_error only works when there is an established connection.

+ // Connection errors have to be tracked by us manually.

+ if ($this->db_connect_id)

+ {

+ $message = @pg_last_error($this->db_connect_id);

+ }

+ else

+ {

+ $message = $this->connect_error;

+ }

+

+ 'message' => $message,

+<?php

+/**

+*

+* @package phpBB

+* @version $Id$

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+class phpbb_error_collector

+{

+ var $errors;

+

+ function phpbb_error_collector()

+ {

+ $this->errors = array();

+ }

+

+ function install()

+ {

+ set_error_handler(array(&$this, 'error_handler'));

+ }

+

+ function uninstall()

+ {

+ restore_error_handler();

+ }

+

+ function error_handler($errno, $msg_text, $errfile, $errline)

+ {

+ $this->errors[] = array($errno, $msg_text, $errfile, $errline);

+ }

+

+ function format_errors()

+ {

+ $text = '';

+ foreach ($this->errors as $error)

+ {

+ if (!empty($text))

+ {

+ $text .= "<br />\n";

+ }

+ list($errno, $msg_text, $errfile, $errline) = $error;

+ $text .= "Errno $errno: $msg_text";

+ if (defined('DEBUG_EXTRA') || defined('IN_INSTALL'))

+ {

+ $text .= " at $errfile line $errline";

+ }

+ }

+ return $text;

+ }

+}

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

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

+ }

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

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

+ 'S_PM_UNREAD' => ($row['pm_unread']) ? true : false,

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

+

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

+ // If we can't insert this user then continue to the next one to avoid inconsistent data

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

+<script type="text/javascript" src="{T_SUPER_TEMPLATE_PATH}/forum_fn.js"></script>

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

+<script type="text/javascript" src="{T_SUPER_TEMPLATE_PATH}/styleswitcher.js"></script>

+<script type="text/javascript" src="{T_SUPER_TEMPLATE_PATH}/forum_fn.js"></script>

+<script type="text/javascript" src="{T_SUPER_TEMPLATE_PATH}/editor.js"></script>

+<script type="text/javascript" src="{T_SUPER_TEMPLATE_PATH}/editor.js"></script>

+<script type="text/javascript" src="{T_SUPER_TEMPLATE_PATH}/styleswitcher.js"></script>

+<script type="text/javascript" src="{T_SUPER_TEMPLATE_PATH}/forum_fn.js"></script>

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

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

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

+ <script type="text/javascript" src="{T_SUPER_TEMPLATE_PATH}/editor.js"></script>

+<script type="text/javascript" src="{T_SUPER_TEMPLATE_PATH}/editor.js"></script>

+ 'POST_NUMBER' => $i + $start + 1,

+if (!defined('E_DEPRECATED'))

+{

+ define('E_DEPRECATED', 8192);

+}

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

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

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

+*/

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

+ }

+}

+ <table name="phpbb_sessions">

+ <column>session_id</column>

+ <column>session_user_id</column>

+ <column>session_ip</column>

+ <column>session_browser</column>

+ </table>

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

+ $cache_file = $this->template->cachepath . str_replace('/', '.', $file) . '.php';

+ $cache_file = $this->template->cachepath . 'php.html.php';

+ $cache_file = $this->template->cachepath . 'includephp.html.php';

+ $this->assertEquals('testing included php', $this->display('test'), "Testing INCLUDEPHP");

+outer - 0 - before

+outer - 1

+middle - 0

+middle - 1

+outer - 2

+middle - 0

+middle - 1

+outer - 3

+middle - 0

+middle - 1

+outer - 0

+middle - 0

+middle - 1

+outer - 1

+middle - 0

+middle - 1

+outer - 2

+middle - 0

+middle - 1

+outer - 3 - after

+outer - 0

+middle - 0

+middle - 1

+outer - 1 - pos #1

+outer - 2

+middle - 0

+middle - 1

+outer - 3

+middle - 0

+middle - 1

+outer - 0 - pos #1

+middle - 0

+middle - 1

+outer - 1

+middle - 0

+middle - 1

+outer - 2

+middle - 0

+middle - 1

+ $this->assertEquals("outer - 0\nmiddle - 0\nmiddle - 1\nouter - 1\nmiddle - 0\nmiddle - 1\nouter - 2\nmiddle - 0\nmiddle - 1", $this->display('test'), 'Ensuring template is built correctly before modification');

+<!-- INCLUDEPHP ../tests/template/templates/_dummy_include.php.inc -->

+ outer - {outer.S_ROW_COUNT}<!-- IF outer.VARIABLE --> - {outer.VARIABLE}<!-- ENDIF -->

+ middle - {middle.S_ROW_COUNT}<!-- IF middle.VARIABLE --> - {middle.VARIABLE}<!-- ENDIF -->

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

+

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

+ }

+}

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

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

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

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

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

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