+phpBB/cache/queue.php.lock

+phpBB/images/avatars/gallery/*

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

+ command="git archive ${revision} | tar -xf - -C ../${dir}"

+ <exec dir="${dir}" command="find . -type f|xargs chmod 644" escape="false" />

+ <exec dir="${dir}" command="find . -type d|xargs chmod 755" escape="false" />

+ if (preg_match('/^Binary files ' . $package_name . '\/(.*) and [a-z0-9._-]+\/\1 differ/i', $line, $match))

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

+

+msg=$(grep -v '^#' "$1" |grep -nE '.{81,}')

+ echo "The following lines are greater than 80 characters long:" >&2;

+ echo >&2

+ echo "$msg" >&2;

+ 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 merges a github pull request.\n";

+ echo "\n";

+

+ echo "Usage: [php] $filename -p pull_request_id [OPTIONS]\n";

+ echo "\n";

+

+ echo "Options:\n";

+ echo " -p pull_request_id The pull request id to be merged (mandatory)\n";

+ echo " -r remote Remote of upstream, defaults to 'upstream' (optional)\n";

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

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

+

+ exit(2);

+}

+

+// Handle arguments

+$opts = getopt('p:r:dh');

+

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

+{

+ show_usage();

+}

+

+$pull_id = get_arg($opts, 'p', '');

+$remote = get_arg($opts, 'r', 'upstream');

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

+

+try

+{

+ exit(work($pull_id, $remote));

+}

+catch (RuntimeException $e)

+{

+ echo $e->getMessage();

+ exit($e->getCode());

+}

+

+function work($pull_id, $remote)

+{

+ // Get some basic data

+ $pull = get_pull('phpbb', 'phpbb3', $pull_id);

+

+ if (!$pull_id)

+ {

+ show_usage();

+ }

+

+ if ($pull['state'] != 'open')

+ {

+ throw new RuntimeException(sprintf("Error: pull request is closed\n",

+ $target_branch), 5);

+ }

+

+ $pull_user = $pull['head'][0];

+ $pull_branch = $pull['head'][1];

+ $target_branch = $pull['base'][1];

+

+ switch ($target_branch)

+ {

+ case 'develop-olympus':

+ run("git checkout develop-olympus");

+ run("git pull $remote develop-olympus");

+

+ add_remote($pull_user, 'phpbb3');

+ run("git fetch $pull_user");

+ run("git merge --no-ff $pull_user/$pull_branch");

+ run("phpunit");

+

+ run("git checkout develop");

+ run("git pull $remote develop");

+ run("git merge --no-ff develop-olympus");

+ run("phpunit");

+ break;

+

+ case 'develop':

+ run("git checkout develop");

+ run("git pull $remote develop");

+

+ add_remote($pull_user, 'phpbb3');

+ run("git fetch $pull_user");

+ run("git merge --no-ff $pull_user/$pull_branch");

+ run("phpunit");

+ break;

+

+ default:

+ throw new RuntimeException(sprintf("Error: pull request target branch '%s' is not a main branch\n",

+ $target_branch), 5);

+ break;

+ }

+}

+

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

+{

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

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

+

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

+ {

+ throw new RuntimeException("Error: failed to retrieve pull request data\n", 4);

+ }

+

+ return json_decode($contents);

+}

+

+function get_pull($username, $repository, $pull_id)

+{

+ $request = api_request("pulls/$username/$repository/$pull_id");

+

+ $pull = $request->pull;

+

+ $pull_data = array(

+ 'base' => array($pull->base->user->login, $pull->base->ref),

+ 'head' => array($pull->head->user->login, $pull->head->ref),

+ 'state' => $pull->state,

+ );

+

+ return $pull_data;

+}

+

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

+{

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

+}

+

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

+{

+ global $dry_run;

+

+ if (!empty($dry_run))

+ {

+ echo "$cmd\n";

+ }

+ else

+ {

+ passthru(escapeshellcmd($cmd), $status);

+

+ if ($status != 0 && !$ignore_fail)

+ {

+ throw new RuntimeException(sprintf("Error: command '%s' failed with status %s'\n",

+ $cmd, $status), 6);

+ }

+ }

+}

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

+ }

+}

+function h_radio($name, $input_ary, $input_default = false, $id = false, $key = false, $separator = '')

+ $html .= '<label><input type="radio" name="' . $name . '"' . (($id && !$id_assigned) ? ' id="' . $id . '"' : '') . ' value="' . $value . '"' . $selected . (($key) ? ' accesskey="' . $key . '"' : '') . ' class="radio" /> ' . $user->lang[$title] . '</label>' . $separator;

+ $tpl = '<input id="' . $key . '" type="' . $tpl_type[0] . '"' . (($size) ? ' size="' . $size . '"' : '') . ' maxlength="' . (($maxlength) ? $maxlength : 255) . '" name="' . $name . '" value="' . $new[$config_key] . '"' . (($tpl_type[0] === 'password') ? ' autocomplete="off"' : '') . ' />';

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

+ <dt><label for="banned">{L_MAIL_BANNED}:</label><br /><span>{L_MAIL_BANNED_EXPLAIN}</span></dt>

+ <dd><input id="banned" name="mail_banned_flag" type="checkbox" class="radio" /></dd>

+</dl>

+<dl>

+ <!-- IF S_CAN_COPY_PERMISSIONS -->

+ <dl>

+ <dt><label for="forum_perm_from">{L_COPY_PERMISSIONS}:</label><br /><span>{L_COPY_PERMISSIONS_EXPLAIN}</span></dt>

+ <dd><select id="forum_perm_from" name="forum_perm_from"><option value="0">{L_NO_PERMISSIONS}</option>{S_FORUM_OPTIONS}</select></dd>

+ </dl>

+ <!-- ENDIF -->

+ <dd><input type="password" id="forum_password" name="forum_password" value="<!-- IF S_FORUM_PASSWORD_SET -->&#x20;&#x20;&#x20;&#x20;&#x20;&#x20;<!-- ENDIF -->" autocomplete="off" /></dd>

+ <dd><input type="password" id="forum_password_confirm" name="forum_password_confirm" value="<!-- IF S_FORUM_PASSWORD_SET -->&#x20;&#x20;&#x20;&#x20;&#x20;&#x20;<!-- ENDIF -->" autocomplete="off" /></dd>

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

+ <dd><input class="text medium" type="text" id="user_email" name="user_email" value="{USER_EMAIL}" autocomplete="off" /></dd>

+ <dd><input class="text medium" type="text" id="email_confirm" name="email_confirm" value="" autocomplete="off" /></dd>

+ <dd><input type="password" id="new_password" name="new_password" value="" autocomplete="off" /></dd>

+ <dd><input type="password" id="password_confirm" name="password_confirm" value="" autocomplete="off" /></dd>

+error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);

+ // Hacking attempt. No point in continuing unless it's a COOKIE (so a cookie called GLOBALS doesn't lock users out completely)

+ if (!is_array($cookie['GLOBALS']))

+ {

+ break;

+ }

+

+// Flush here to prevent browser from showing the page as loading while running cron.

+flush();

+ $queue->process();

+ $cache->tidy();

+ $search->tidy();

+ tidy_warnings();

+ tidy_database();

+ $user->session_gc();

+ auto_prune($row['forum_id'], 'posted', $row['forum_flags'], $row['prune_days'], $row['prune_freq']);

+ auto_prune($row['forum_id'], 'viewed', $row['forum_flags'], $row['prune_viewed'], $row['prune_freq']);

+unlock_cron();

+garbage_collection();

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

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

+ echo "ALTER TABLE $table_name ADD FULLTEXT (post_subject), ADD FULLTEXT (post_text), ADD FULLTEXT post_content (post_subject, post_text);{$newline}";

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

+ <li><a href="#webserver_configuration">Webserver configuration</a></li>

+<a name="webserver_configuration"></a><h3>6.ii. Webserver configuration</h3>

+

+ <p>Depending on your web server you may have to configure your server to deny web access to the <code>cache/</code>, <code>files/</code>, <code>store/</code> and other directories. This is to prevent users from accessing sensitive files.</p>

+

+ <p>For <strong>apache</strong> there are <code>.htaccess</code> files already in place to do this for you. For other webservers you will have to adjust the configuration yourself. Sample files for <strong>nginx</strong> and <strong>lighttpd</strong> to help you get started may be found in docs directory.</p>

+

+PHPBB_ACM_REDIS_HOST (overwrite redis host name, default is localhost)

+PHPBB_ACM_REDIS_PORT (overwrite redis port, default is 6379)

+PHPBB_ACM_REDIS_PASSWORD (overwrite redis password, default is empty)

+PHPBB_ACM_REDIS_DB (overwrite redis default database)

+

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

+ error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);

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

+<?php

+/**

+*

+* @package acm

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+// Include the abstract base

+if (!class_exists('acm_memory'))

+{

+ require("{$phpbb_root_path}includes/acm/acm_memory.$phpEx");

+}

+

+if (!defined('PHPBB_ACM_REDIS_PORT'))

+{

+ define('PHPBB_ACM_REDIS_PORT', 6379);

+}

+

+if (!defined('PHPBB_ACM_REDIS_HOST'))

+{

+ define('PHPBB_ACM_REDIS_HOST', 'localhost');

+}

+

+if (!defined('PHPBB_ACM_REDIS'))

+{

+ //can define multiple servers with host1/port1,host2/port2 format

+ define('PHPBB_ACM_REDIS', PHPBB_ACM_REDIS_HOST . '/' . PHPBB_ACM_REDIS_PORT);

+}

+

+/**

+* ACM for Redis

+*

+* Compatible with the php extension phpredis available

+* at https://github.com/nicolasff/phpredis

+*

+* @package acm

+*/

+class acm extends acm_memory

+{

+ var $extension = 'redis';

+

+ var $redis;

+

+ function acm()

+ {

+ // Call the parent constructor

+ parent::acm_memory();

+

+ $this->redis = new Redis();

+ foreach (explode(',', PHPBB_ACM_REDIS) as $server)

+ {

+ $parts = explode('/', $server);

+ $this->redis->connect(trim($parts[0]), trim($parts[1]));

+ }

+

+ if (defined('PHPBB_ACM_REDIS_PASSWORD'))

+ {

+ if (!$this->redis->auth(PHPBB_ACM_REDIS_PASSWORD))

+ {

+ global $acm_type;

+

+ trigger_error("Incorrect password for the ACM module $acm_type.", E_USER_ERROR);

+ }

+ }

+

+ $this->redis->setOption(Redis::OPT_SERIALIZER, Redis::SERIALIZER_PHP);

+ $this->redis->setOption(Redis::OPT_PREFIX, $this->key_prefix);

+

+ if (defined('PHPBB_ACM_REDIS_DB'))

+ {

+ if (!$this->redis->select(PHPBB_ACM_REDIS_DB))

+ {

+ global $acm_type;

+

+ trigger_error("Incorrect database for the ACM module $acm_type.", E_USER_ERROR);

+ }

+ }

+ }

+

+ /**

+ * Unload the cache resources

+ *

+ * @return void

+ */

+ function unload()

+ {

+ parent::unload();

+

+ $this->redis->close();

+ }

+

+ /**

+ * Purge cache data

+ *

+ * @return void

+ */

+ function purge()

+ {

+ $this->redis->flushDB();

+

+ parent::purge();

+ }

+

+ /**

+ * Fetch an item from the cache

+ *

+ * @access protected

+ * @param string $var Cache key

+ * @return mixed Cached data

+ */

+ function _read($var)

+ {

+ return $this->redis->get($var);

+ }

+

+ /**

+ * Store data in the cache

+ *

+ * @access protected

+ * @param string $var Cache key

+ * @param mixed $data Data to store

+ * @param int $ttl Time-to-live of cached data

+ * @return bool True if the operation succeeded

+ */

+ function _write($var, $data, $ttl = 2592000)

+ {

+ return $this->redis->setex($var, $ttl, $data);

+ }

+

+ /**

+ * Remove an item from the cache

+ *

+ * @access protected

+ * @param string $var Cache key

+ * @return bool True if the operation succeeded

+ */

+ function _delete($var)

+ {

+ if ($this->redis->delete($var) > 0)

+ {

+ return true;

+ }

+ return false;

+ }

+}

+ if ($bbcode_id > BBCODE_LIMIT)

+ $radio_ary = array(

+ USER_ACTIVATION_DISABLE => 'ACC_DISABLE',

+ USER_ACTIVATION_NONE => 'ACC_NONE',

+ );

+

+ $radio_ary[USER_ACTIVATION_SELF] = 'ACC_USER';

+ $radio_ary[USER_ACTIVATION_ADMIN] = 'ACC_ADMIN';

+ $radio_text = h_radio('config[require_activation]', $radio_ary, $value, 'require_activation', $key, '<br />');

+

+ return $radio_text;

+ $sql = 'SELECT disallow_id

+ FROM ' . DISALLOW_TABLE . "

+ WHERE disallow_username = '" . $db->sql_escape($disallowed_user) . "'";

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

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

+ $db->sql_freeresult($result);

+

+ if ($row)

+ {

+ trigger_error($user->lang['DISALLOWED_ALREADY'] . adm_back_link($this->u_action), E_USER_WARNING);

+ }

+

+ $sql_ary = array(

+ 'SELECT' => 'u.user_email, u.username, u.username_clean, u.user_lang, u.user_jabber, u.user_notify_type',

+ 'FROM' => array(

+ USERS_TABLE => 'u',

+ USER_GROUP_TABLE => 'ug',

+ ),

+ 'WHERE' => 'ug.group_id = ' . $group_id . '

+ AND u.user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')',

+ 'ORDER_BY' => 'u.user_lang, u.user_notify_type',

+ );

+ $sql_ary = array(

+ 'SELECT' => 'u.username, u.username_clean, u.user_email, u.user_jabber, u.user_lang, u.user_notify_type',

+ 'FROM' => array(

+ USERS_TABLE => 'u',

+ ),

+ 'WHERE' => 'u.user_allow_massemail = 1

+ AND u.user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')',

+ 'ORDER_BY' => 'u.user_lang, u.user_notify_type',

+ );

+

+ // Mail banned or not

+ if (!isset($_REQUEST['mail_banned_flag']))

+ {

+ $sql_ary['WHERE'] .= ' AND (b.ban_id IS NULL

+ OR b.ban_exclude = 1)';

+ $sql_ary['LEFT_JOIN'] = array(

+ array(

+ 'FROM' => array(

+ BANLIST_TABLE => 'b',

+ ),

+ 'ON' => 'u.user_id = b.ban_userid',

+ ),

+ );

+ }

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

+ else if (!file_exists($phpbb_root_path . $img_path . '/' . $image))

+ {

+ $errors[$image] = 'SMILIE_NO_FILE';

+ }

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

+ $buffer = $db->sql_buffer_nested_transactions();

+

+ if ($buffer)

+ {

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

+ $rows[] = false; // indicate end of array for while loop below

+

+ $db->sql_freeresult($result);

+ }

+

+ $i = 0;

+ while ($row = ($buffer ? $rows[$i++] : $db->sql_fetchrow($result)))

+ if (!$buffer)

+ {

+ $db->sql_freeresult($result);

+ }

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

+ $seq_cache = array();

+ if (isset($seq_cache[$subseq]))

+ {

+ $converted = $seq_cache[$subseq];

+ }

+ else

+ {

+ $converted = $seq_cache[$subseq] = str_pad(base_convert($subseq, 36, 2), 31, 0, STR_PAD_LEFT);

+ }

+

+ $this->acl[$f] .= $converted;

+ <dd><input type="password" id="ldap_password" size="40" name="config[ldap_password]" value="' . $new['ldap_password'] . '" autocomplete="off" /></dd>

+ $offset[$i] = phpbb_mt_rand(0, (int) round((1.5 * $width_avail) / $denom));

+ $noise[$i] = new char_cube3d($noise_bitmaps, mt_rand(1, sizeof($noise_bitmaps['data'])));

+ 'A' => $chars['A'][mt_rand(0, min(sizeof($chars['A']), $config['captcha_gd_fonts']) -1)],

+ 'B' => $chars['B'][mt_rand(0, min(sizeof($chars['B']), $config['captcha_gd_fonts']) -1)],

+ 'C' => $chars['C'][mt_rand(0, min(sizeof($chars['C']), $config['captcha_gd_fonts']) -1)],

+ 'D' => $chars['D'][mt_rand(0, min(sizeof($chars['D']), $config['captcha_gd_fonts']) -1)],

+ 'E' => $chars['E'][mt_rand(0, min(sizeof($chars['E']), $config['captcha_gd_fonts']) -1)],

+ 'F' => $chars['F'][mt_rand(0, min(sizeof($chars['F']), $config['captcha_gd_fonts']) -1)],

+ 'G' => $chars['G'][mt_rand(0, min(sizeof($chars['G']), $config['captcha_gd_fonts']) -1)],

+ 'H' => $chars['H'][mt_rand(0, min(sizeof($chars['H']), $config['captcha_gd_fonts']) -1)],

+ 'I' => $chars['I'][mt_rand(0, min(sizeof($chars['I']), $config['captcha_gd_fonts']) -1)],

+ 'J' => $chars['J'][mt_rand(0, min(sizeof($chars['J']), $config['captcha_gd_fonts']) -1)],

+ 'K' => $chars['K'][mt_rand(0, min(sizeof($chars['K']), $config['captcha_gd_fonts']) -1)],

+ 'L' => $chars['L'][mt_rand(0, min(sizeof($chars['L']), $config['captcha_gd_fonts']) -1)],

+ 'M' => $chars['M'][mt_rand(0, min(sizeof($chars['M']), $config['captcha_gd_fonts']) -1)],

+ 'N' => $chars['N'][mt_rand(0, min(sizeof($chars['N']), $config['captcha_gd_fonts']) -1)],

+ 'O' => $chars['O'][mt_rand(0, min(sizeof($chars['O']), $config['captcha_gd_fonts']) -1)],

+ 'P' => $chars['P'][mt_rand(0, min(sizeof($chars['P']), $config['captcha_gd_fonts']) -1)],

+ 'Q' => $chars['Q'][mt_rand(0, min(sizeof($chars['Q']), $config['captcha_gd_fonts']) -1)],

+ 'R' => $chars['R'][mt_rand(0, min(sizeof($chars['R']), $config['captcha_gd_fonts']) -1)],

+ 'S' => $chars['S'][mt_rand(0, min(sizeof($chars['S']), $config['captcha_gd_fonts']) -1)],

+ 'T' => $chars['T'][mt_rand(0, min(sizeof($chars['T']), $config['captcha_gd_fonts']) -1)],

+ 'U' => $chars['U'][mt_rand(0, min(sizeof($chars['U']), $config['captcha_gd_fonts']) -1)],

+ 'V' => $chars['V'][mt_rand(0, min(sizeof($chars['V']), $config['captcha_gd_fonts']) -1)],

+ 'W' => $chars['W'][mt_rand(0, min(sizeof($chars['W']), $config['captcha_gd_fonts']) -1)],

+ 'X' => $chars['X'][mt_rand(0, min(sizeof($chars['X']), $config['captcha_gd_fonts']) -1)],

+ 'Y' => $chars['Y'][mt_rand(0, min(sizeof($chars['Y']), $config['captcha_gd_fonts']) -1)],

+ 'Z' => $chars['Z'][mt_rand(0, min(sizeof($chars['Z']), $config['captcha_gd_fonts']) -1)],

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

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

+ var $recaptcha_server = 'http://www.google.com/recaptcha/api';

+ var $recaptcha_server_secure = 'https://www.google.com/recaptcha/api'; // class constants :(

+

+ // We are opening a socket to port 80 of this host and send

+ // the POST request asking for verification to the path specified here.

+ var $recaptcha_verify_server = 'www.google.com';

+ var $recaptcha_verify_path = '/recaptcha/api/verify';

+

+ $response = $this->_recaptcha_http_post($this->recaptcha_verify_server, $this->recaptcha_verify_path,

+// BBCode hard limit

+define('BBCODE_LIMIT', 1511);

+

+ // Only add the column if it does not exist yet

+ continue;

+ // This is commented out here because it can take tremendous time on updates

+// $result = $this->sql_column_change($table, $column_name, $column_data, true);

+ continue;

+// $sqlite_data[$table]['change_columns'][] = $result;

+ if (!$this->sql_index_exists($table, $index_name))

+ {

+ continue;

+ }

+

+ if ($this->sql_unique_index_exists($table, $index_name))

+ {

+ continue;

+ }

+

+ if ($this->sql_index_exists($table, $index_name))

+ {

+ continue;

+ }

+

+ * Check if a specified index exists in table. Does not return PRIMARY KEY and UNIQUE indexes.

+ *

+ * @param string $table_name Table to check the index at

+ * @param string $index_name The index name to check

+ *

+ * @return bool True if index exists, else false

+ */

+ function sql_index_exists($table_name, $index_name)

+ {

+ if ($this->sql_layer == 'mssql' || $this->sql_layer == 'mssqlnative')

+ {

+ $sql = "EXEC sp_statistics '$table_name'";

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

+

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

+ {

+ if ($row['TYPE'] == 3)

+ {

+ if (strtolower($row['INDEX_NAME']) == strtolower($index_name))

+ {

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

+ return true;

+ }

+ }

+ }

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

+

+ return false;

+ }

+

+ switch ($this->sql_layer)

+ {

+ case 'firebird':

+ $sql = "SELECT LOWER(RDB\$INDEX_NAME) as index_name

+ FROM RDB\$INDICES

+ WHERE RDB\$RELATION_NAME = '" . strtoupper($table_name) . "'

+ AND RDB\$UNIQUE_FLAG IS NULL

+ AND RDB\$FOREIGN_KEY IS NULL";

+ $col = 'index_name';

+ break;

+

+ case 'postgres':

+ $sql = "SELECT ic.relname as index_name

+ FROM pg_class bc, pg_class ic, pg_index i

+ WHERE (bc.oid = i.indrelid)

+ AND (ic.oid = i.indexrelid)

+ AND (bc.relname = '" . $table_name . "')

+ AND (i.indisunique != 't')

+ AND (i.indisprimary != 't')";

+ $col = 'index_name';

+ break;

+

+ case 'mysql_40':

+ case 'mysql_41':

+ $sql = 'SHOW KEYS

+ FROM ' . $table_name;

+ $col = 'Key_name';

+ break;

+

+ case 'oracle':

+ $sql = "SELECT index_name

+ FROM user_indexes

+ WHERE table_name = '" . strtoupper($table_name) . "'

+ AND generated = 'N'

+ AND uniqueness = 'NONUNIQUE'";

+ $col = 'index_name';

+ break;

+

+ case 'sqlite':

+ $sql = "PRAGMA index_list('" . $table_name . "');";

+ $col = 'name';

+ break;

+ }

+

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

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

+ {

+ if (($this->sql_layer == 'mysql_40' || $this->sql_layer == 'mysql_41') && !$row['Non_unique'])

+ {

+ continue;

+ }

+

+ // These DBMS prefix index name with the table name

+ switch ($this->sql_layer)

+ {

+ case 'firebird':

+ case 'oracle':

+ case 'postgres':

+ case 'sqlite':

+ $row[$col] = substr($row[$col], strlen($table_name) + 1);

+ break;

+ }

+

+ if (strtolower($row[$col]) == strtolower($index_name))

+ {

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

+ return true;

+ }

+ }

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

+

+ return false;

+ }

+

+ /**

+ * Check if a specified index exists in table. Does not return PRIMARY KEY and UNIQUE indexes.

+ *

+ * @param string $table_name Table to check the index at

+ * @param string $index_name The index name to check

+ *

+ * @return bool True if index exists, else false

+ */

+ function sql_unique_index_exists($table_name, $index_name)

+ {

+ if ($this->sql_layer == 'mssql' || $this->sql_layer == 'mssqlnative')

+ {

+ $sql = "EXEC sp_statistics '$table_name'";

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

+

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

+ {

+ // Usually NON_UNIQUE is the column we want to check, but we allow for both

+ if ($row['TYPE'] == 3)

+ {

+ if (strtolower($row['INDEX_NAME']) == strtolower($index_name))

+ {

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

+ return true;

+ }

+ }

+ }

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

+ return false;

+ }

+

+ switch ($this->sql_layer)

+ {

+ case 'firebird':

+ $sql = "SELECT LOWER(RDB\$INDEX_NAME) as index_name

+ FROM RDB\$INDICES

+ WHERE RDB\$RELATION_NAME = '" . strtoupper($table_name) . "'

+ AND RDB\$UNIQUE_FLAG IS NOT NULL

+ AND RDB\$FOREIGN_KEY IS NULL";

+ $col = 'index_name';

+ break;

+

+ case 'postgres':

+ $sql = "SELECT ic.relname as index_name, i.indisunique

+ FROM pg_class bc, pg_class ic, pg_index i

+ WHERE (bc.oid = i.indrelid)

+ AND (ic.oid = i.indexrelid)

+ AND (bc.relname = '" . $table_name . "')

+ AND (i.indisprimary != 't')";

+ $col = 'index_name';

+ break;

+

+ case 'mysql_40':

+ case 'mysql_41':

+ $sql = 'SHOW KEYS

+ FROM ' . $table_name;

+ $col = 'Key_name';

+ break;

+

+ case 'oracle':

+ $sql = "SELECT index_name, table_owner

+ FROM user_indexes

+ WHERE table_name = '" . strtoupper($table_name) . "'

+ AND generated = 'N'

+ AND uniqueness = 'UNIQUE'";

+ $col = 'index_name';

+ break;

+

+ case 'sqlite':

+ $sql = "PRAGMA index_list('" . $table_name . "');";

+ $col = 'name';

+ break;

+ }

+

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

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

+ {

+ if (($this->sql_layer == 'mysql_40' || $this->sql_layer == 'mysql_41') && ($row['Non_unique'] || $row[$col] == 'PRIMARY'))

+ {

+ continue;

+ }

+

+ if ($this->sql_layer == 'sqlite' && !$row['unique'])

+ {

+ continue;

+ }

+

+ if ($this->sql_layer == 'postgres' && $row['indisunique'] != 't')

+ {

+ continue;

+ }

+

+ // These DBMS prefix index name with the table name

+ switch ($this->sql_layer)

+ {

+ case 'oracle':

+ // Two cases here... prefixed with U_[table_owner] and not prefixed with table_name

+ if (strpos($row[$col], 'U_') === 0)

+ {

+ $row[$col] = substr($row[$col], strlen('U_' . $row['table_owner']) + 1);

+ }

+ else if (strpos($row[$col], strtoupper($table_name)) === 0)

+ {

+ $row[$col] = substr($row[$col], strlen($table_name) + 1);

+ }

+ break;

+

+ case 'firebird':

+ case 'postgres':

+ case 'sqlite':

+ $row[$col] = substr($row[$col], strlen($table_name) + 1);

+ break;

+ }

+

+ if (strtolower($row[$col]) == strtolower($index_name))

+ {

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

+ return true;

+ }

+ }

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

+

+ return false;

+ }

+

+ /**

+ // Does not support AFTER statement, only POSITION (and there you need the column position)

+ // Does not support AFTER, only through temporary table

+ $after = (!empty($column_data['after'])) ? ' AFTER ' . $column_data['after'] : '';

+ $statements[] = 'ALTER TABLE `' . $table_name . '` ADD COLUMN `' . $column_name . '` ' . $column_data['column_type_sql'] . $after;

+ // Does not support AFTER, only through temporary table

+ // Does not support AFTER, only through temporary table

+ // TODO: try to change pkey without removing trigger, generator or constraints. ATM this query may fail.

+ * Returns whether results of a query need to be buffered to run a transaction while iterating over them.

+ *

+ * @return bool Whether buffering is required.

+ */

+ function sql_buffer_nested_transactions()

+ {

+ return false;

+ }

+

+ /**

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

+ $this->m_row_count = sizeof($this->m_rows);

+ * {@inheritDoc}

+ */

+ function sql_buffer_nested_transactions()

+ {

+ return true;

+ }

+

+ /**

+

+ preg_match_all('/\'(?:[^\']++|\'\')*+\'|[\d-.]+/', $regs[3], $vals, PREG_PATTERN_ORDER);

+

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

+ }

+}

+ // Precision must be from 1 to 18

+ $sql_update = 'CAST(CAST(config_value as DECIMAL(18, 0)) + ' . (int) $increment . ' as VARCHAR(255))';

+ break;

+

+ // Need to cast to text first for PostgreSQL 7.x

+ $sql_update = 'CAST(CAST(config_value::text as DECIMAL(255, 0)) + ' . (int) $increment . ' as VARCHAR(255))';

+ set_config('rand_seed', $config['rand_seed'], true);

+* Wrapper for mt_rand() which allows swapping $min and $max parameters.

+*

+* PHP does not allow us to swap the order of the arguments for mt_rand() anymore.

+* (since PHP 5.3.4, see http://bugs.php.net/46587)

+*

+* @param int $min Lowest value to be returned

+* @param int $max Highest value to be returned

+*

+* @return int Random integer between $min and $max (or $max and $min)

+*/

+function phpbb_mt_rand($min, $max)

+{

+ return ($min > $max) ? mt_rand($max, $min) : mt_rand($min, $max);

+}

+

+/**

+ if (substr($setting, 0, 3) != '$H$' && substr($setting, 0, 3) != '$P$')

+*

+*

+* @return string the generated board url

+ 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 (ob_get_level() > 0)

+ }

+ 'T_IMAGESET_LANG_PATH' => "{$web_path}styles/" . $user->theme['imageset_path'] . '/imageset/' . $user->lang_name,

+ 'T_STYLESHEET_LINK' => (!$user->theme['theme_storedb']) ? "{$web_path}styles/" . $user->theme['theme_path'] . '/theme/stylesheet.css' : append_sid("{$phpbb_root_path}style.$phpEx", 'id=' . $user->theme['style_id'] . '&amp;lang=' . $user->lang_name),

+ if (!defined('IN_CRON') && $run_cron && !$config['board_disable'] && !$user->data['is_bot'])

+ (ob_get_level() > 0) ? @ob_flush() : @flush();

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

+

+ // retrieve option lang data if necessary

+ if (!isset($this->options_lang[$field_data['field_id']]) || !isset($this->options_lang[$field_data['field_id']][$field_data['lang_id']]) || !sizeof($this->options_lang[$file_data['field_id']][$field_data['lang_id']]))

+ {

+ $this->get_option_lang($field_data['field_id'], $field_data['lang_id'], FIELD_DROPDOWN, false);

+ }

+

+ if (!isset($this->options_lang[$field_data['field_id']][$field_data['lang_id']][$field_value]))

+ {

+ return 'FIELD_INVALID_VALUE';

+ }

+

+ case 'FIELD_INVALID_VALUE':

+ // Count the number of ! occurrences (not allowed in vars)

+ trigger_error('LENGTH_BAN_INVALID', E_USER_WARNING);

+ trigger_error('NO_USER_SPECIFIED', E_USER_WARNING);

+ trigger_error('NO_USERS', E_USER_WARNING);

+ trigger_error('NO_IPS_DEFINED', E_USER_WARNING);

+ trigger_error('NO_EMAILS_DEFINED', E_USER_WARNING);

+ trigger_error('NO_MODE', E_USER_WARNING);

+* Validate Language Pack ISO Name

+*

+* Tests whether a language name is valid and installed

+*

+* @param string $lang_iso The language string to test

+*

+* @return bool|string Either false if validation succeeded or

+* a string which will be used as the error message

+* (with the variable name appended)

+*/

+function validate_language_iso_name($lang_iso)

+{

+ global $db;

+

+ $sql = 'SELECT lang_id

+ FROM ' . LANG_TABLE . "

+ WHERE lang_iso = '" . $db->sql_escape($lang_iso) . "'";

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

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

+ $db->sql_freeresult($result);

+

+ return ($lang_id) ? false : 'WRONG_DATA';

+}

+

+/**

+ if ($password === '' || $config['pass_complex'] === 'PASS_TYPE_ANY')

+ // Password empty or no password complexity required.

+ // No break statements below ...

+ // We require strong passwords in case pass_complex is not set or is invalid

+ default:

+

+ // Require mixed case letters, numbers and symbols

+ case 'PASS_TYPE_SYMBOL':

+ $chars[] = $sym;

+ // Require mixed case letters and numbers

+ // Require mixed case letters

+ case 'PASS_TYPE_CASE':

+ $log_count = false;

+ foreach ($topic_data as $topic_id => $topic_row)

+ {

+ if (!isset($search_type) && $topic_row['enable_indexing'])

+ // Select the search method and do some additional checks to ensure it can actually be utilised

+ $search_type = basename($config['search_type']);

+ if (!file_exists($phpbb_root_path . 'includes/search/' . $search_type . '.' . $phpEx))

+ {

+ trigger_error('NO_SUCH_SEARCH_MODULE');

+ }

+

+ if (!class_exists($search_type))

+ {

+ include("{$phpbb_root_path}includes/search/$search_type.$phpEx");

+ }

+ $error = false;

+ $search = new $search_type($error);

+ $search_mode = 'post';

+ if ($error)

+ {

+ trigger_error($error);

+ }

+ }

+ else if (!isset($search_type) && !$topic_row['enable_indexing'])

+ $search_type = false;

+ if (!empty($search_type))

+ $search->index($search_mode, $new_post_id, $sql_ary['post_text'], $sql_ary['post_subject'], $sql_ary['poster_id'], ($topic_row['topic_type'] == POST_GLOBAL) ? 0 : $to_forum_id);

+ $log_count = false;

+ if (!empty($log_data))

+ 'code' => array('bbcode_id' => 8, 'regexp' => array('#\[code(?:=([a-z]+))?\](.+\[/code\])#uise' => "\$this->bbcode_code('\$1', '\$2')")),

+ 'quote' => array('bbcode_id' => 0, 'regexp' => array('#\[quote(?:=&quot;(.*?)&quot;)?\](.+)\[/quote\]#uise' => "\$this->bbcode_quote('\$0')")),

+ 'attachment' => array('bbcode_id' => 12, 'regexp' => array('#\[attachment=([0-9]+)\](.*?)\[/attachment\]#uise' => "\$this->bbcode_attachment('\$1', '\$2')")),

+ 'b' => array('bbcode_id' => 1, 'regexp' => array('#\[b\](.*?)\[/b\]#uise' => "\$this->bbcode_strong('\$1')")),

+ 'i' => array('bbcode_id' => 2, 'regexp' => array('#\[i\](.*?)\[/i\]#uise' => "\$this->bbcode_italic('\$1')")),

+ 'url' => array('bbcode_id' => 3, 'regexp' => array('#\[url(=(.*))?\](.*)\[/url\]#uiUe' => "\$this->validate_url('\$2', '\$3')")),

+ 'img' => array('bbcode_id' => 4, 'regexp' => array('#\[img\](.*)\[/img\]#uiUe' => "\$this->bbcode_img('\$1')")),

+ 'size' => array('bbcode_id' => 5, 'regexp' => array('#\[size=([\-\+]?\d+)\](.*?)\[/size\]#uise' => "\$this->bbcode_size('\$1', '\$2')")),

+ 'color' => array('bbcode_id' => 6, 'regexp' => array('!\[color=(#[0-9a-f]{3}|#[0-9a-f]{6}|[a-z\-]+)\](.*?)\[/color\]!uise' => "\$this->bbcode_color('\$1', '\$2')")),

+ 'u' => array('bbcode_id' => 7, 'regexp' => array('#\[u\](.*?)\[/u\]#uise' => "\$this->bbcode_underline('\$1')")),

+ 'list' => array('bbcode_id' => 9, 'regexp' => array('#\[list(?:=(?:[a-z0-9]|disc|circle|square))?].*\[/list]#uise' => "\$this->bbcode_parse_list('\$0')")),

+ 'email' => array('bbcode_id' => 10, 'regexp' => array('#\[email=?(.*?)?\](.*?)\[/email\]#uise' => "\$this->validate_email('\$1', '\$2')")),

+ 'flash' => array('bbcode_id' => 11, 'regexp' => array('#\[flash=([0-9]+),([0-9]+)\](.*?)\[/flash\]#uie' => "\$this->bbcode_flash('\$1', '\$2', '\$3')"))

+ // 'u' modifier has been added to correctly parse smilies within unicode strings

+ // For details: http://tracker.phpbb.com/browse/PHPBB3-10117

+ $num_matches = preg_match_all('#(?<=^|[\n .])(?:' . implode('|', $match) . ')(?![^<>]*>)#u', $this->message, $matches);

+ // 'u' modifier has been added to correctly parse smilies within unicode strings

+ // For details: http://tracker.phpbb.com/browse/PHPBB3-10117

+

+ $this->message = trim(preg_replace(explode(chr(0), '#(?<=^|[\n .])' . implode('(?![^<>]*>)#u' . chr(0) . '#(?<=^|[\n .])', $match) . '(?![^<>]*>)#u'), $replace, $this->message));

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

+ }

+

+ // Neither Spamhaus nor Spamcop supports IPv6 addresses.

+ if (strpos($ip, ':') !== false)

+ {

+ return false;

+ }

+

+ break;

+ if (!file_exists($filename) || @filesize($filename) === 0 || defined('DEBUG_EXTRA'))

+

+ // Create the correct logs

+ add_log('user', $user_row['user_id'], 'LOG_USER_ACTIVE_USER');

+ if ($auth->acl_get('a_user'))

+ {

+ add_log('admin', 'LOG_USER_ACTIVE', $user_row['username']);

+ }

+ $user_folders = get_folder($user->data['user_id']);

+ compose_pm($id, $mode, $action, $user_folders);

+function compose_pm($id, $mode, $action, $user_folders = array())

+ $folder_id = 0;

+ $s_action .= (($folder_id) ? "&amp;f=$folder_id" : '') . (($msg_id) ? "&amp;p=$msg_id" : '');

+ $inbox_folder_url = append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&amp;folder=inbox');

+ $outbox_folder_url = append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&amp;folder=outbox');

+

+ $folder_url = '';

+ if (($folder_id > 0) && isset($user_folders[$folder_id]))

+ {

+ $folder_url = append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&amp;folder=' . $folder_id);

+ }

+

+ $return_box_url = ($action === 'post' || $action === 'edit') ? $outbox_folder_url : $inbox_folder_url;

+ $return_box_lang = ($action === 'post' || $action === 'edit') ? 'PM_OUTBOX' : 'PM_INBOX';

+

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

+

+ $last_click_type = 'CLICK_RETURN_FOLDER';

+ if ($folder_url)

+ {

+ $message .= '<br /><br />' . sprintf($user->lang['CLICK_RETURN_FOLDER'], '<a href="' . $folder_url . '">', '</a>', $user_folders[$folder_id]['folder_name']);

+ $last_click_type = 'CLICK_GOTO_FOLDER';

+ }

+ $message .= '<br /><br />' . sprintf($user->lang[$last_click_type], '<a href="' . $return_box_url . '">', '</a>', $user->lang[$return_box_lang]);

+

+ meta_refresh(3, $return_message_url);

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

+ 'U_ICQ' => ($user_info['user_icq']) ? 'http://www.icq.com/people' . urlencode($user_info['user_icq']) . '/' : '',

+ 'lang' => array('language_iso_name'),

+ if (!validate_language_iso_name($use_lang))

+ 'lang' => array('language_iso_name'),

+ case 'mssqlnative':

+ case 'mssqlnative':

+ case 'mssqlnative':

+//error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);

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

+error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);

+ // 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_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 9, auth_option_id, 0 FROM phpbb_acl_options WHERE auth_option LIKE 'u_%' AND auth_option IN ('u_chgavatar');

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

+ 'ACC_ACTIVATION_EXPLAIN' => 'This determines whether users have immediate access to the board or if confirmation is required. You can also completely disable new registrations. “Board-wide e-mail” must be enabled in order to use user or admin activation.',

+ 'ACC_ADMIN' => 'By admin',

+ 'ACC_DISABLE' => 'Disable registration',

+ 'ACC_NONE' => 'No activation (immediate access)',

+ 'ACC_USER' => 'By user (e-mail verification)',

+

+ 'MAIL_BANNED' => 'Mail banned users',

+ 'MAIL_BANNED_EXPLAIN' => 'When sending a mass e-mail to a group you can select here whether banned users will also receive the e-mail.',

+

+ 'SMILIE_NO_CODE' => 'The smiley “%s” was ignored, as there was no code entered.',

+ 'SMILIE_NO_EMOTION' => 'The smiley “%s” was ignored, as there was no emotion entered.',

+ 'SMILIE_NO_FILE' => 'The smiley “%s” was ignored, as the file is missing.',

+ 'ACP_DISALLOW_EXPLAIN' => 'Here you can control usernames which will not be allowed to be used. Disallowed usernames are allowed to contain a wildcard character of *.',

+ 'DISALLOWED_ALREADY' => 'The name you entered is already disallowed.',

+ '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"',

+ 'RECAPTCHA_NOT_AVAILABLE' => 'In order to use reCaptcha, you must create an account on <a href="http://www.google.com/recaptcha">www.google.com/recaptcha</a>.',

+ 'RECAPTCHA_PUBLIC_EXPLAIN' => 'Your public reCaptcha key. Keys can be obtained on <a href="http://www.google.com/recaptcha">www.google.com/recaptcha</a>.',

+ 'RECAPTCHA_PRIVATE_EXPLAIN' => 'Your private reCaptcha key. Keys can be obtained on <a href="http://www.google.com/recaptcha">www.google.com/recaptcha</a>.',

+ 'FORUMS_MARKED' => 'The selected forums have been marked read.',

+ 'MARK_SUBFORUMS_READ' => 'Mark subforums read',

+ 'MERGE_POSTS' => 'Move posts',

+ 'SEARCH_USER_POSTS' => 'Search user’s posts',

+ 'PHP_URL_FOPEN_SUPPORT_EXPLAIN' => '<strong>Optional</strong> - This setting is optional, however certain phpBB functions like off-site avatars will not work properly without it.',

+ 'MERGE_POSTS_CONFIRM' => 'Are you sure you want to move the selected posts?',

+ 'MERGE_TOPIC_EXPLAIN' => 'Using the form below you can move selected posts into another topic. The posts will be split from this topic and merged into the other topic. These posts will not be reordered and will appear as if the users posted them to the new topic.<br />Please enter the destination topic id or click on “Select topic” to search for one.',

+ 'CLICK_GOTO_FOLDER' => '%1$sGo to your “%3$s” folder%2$s',

+ 'FIELD_INVALID_VALUE' => 'The field “%s” has an invalid value.',

+

+ if (isset($find_key_match[$joined_select]) && sizeof($joined) == 3)

+ {

+ // Before PHP 5.1 an error value -1 can be returned instead of false.

+ // Theoretically gmmktime() can also legitimately return -1 as an actual timestamp.

+ // But since we do not pass the $second parameter to gmmktime(),

+ // an actual unix timestamp -1 cannot be returned in this case.

+ // Thus we can check whether it is -1 and treat -1 as an error.

+ $joined_time = gmmktime(0, 0, 0, (int) $joined[1], (int) $joined[2], (int) $joined[0]);

+

+ if ($joined_time !== false && $joined_time !== -1)

+ {

+ $sql_where .= " AND u.user_regdate " . $find_key_match[$joined_select] . ' ' . $joined_time;

+ }

+ }

+

+ if (isset($find_key_match[$active_select]) && sizeof($active) == 3 && $auth->acl_get('u_viewonline'))

+ {

+ $active_time = gmmktime(0, 0, 0, (int) $active[1], (int) $active[2], (int) $active[0]);

+

+ if ($active_time !== false && $active_time !== -1)

+ {

+ $sql_where .= " AND u.user_lastvisit " . $find_key_match[$active_select] . ' ' . $active_time;

+ }

+ }

+

+ 'U_ICQ' => ($data['user_icq']) ? 'http://www.icq.com/people/' . urlencode($data['user_icq']) . '/' : '',

+// Page title & action URL

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

+error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);

+ <object id="qtstream_{_file.ATTACH_ID}" classid="clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B" codebase="http://www.apple.com/qtactivex/qtplugin.cab#version=6,0,2,0" width="320" height="285">

+ <embed name="qtstream_{_file.ATTACH_ID}" src="{_file.U_DOWNLOAD_LINK}" pluginspage="http://www.apple.com/quicktime/download/" enablejavascript="true" controller="true" width="320" height="285" type="video/quicktime" autoplay="false"></embed>

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

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

+ <a href="#minitabs" onclick="subPanels('merge-panel'); return false;"><span>{L_MERGE_POSTS}</span></a>

+ <dd><a href="http://www.aim.com">{L_IM_DOWNLOAD_APP}</a> | <a href="http://www.aim.com/products/express">{L_IM_AIM_EXPRESS}</a></dd>

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

+ <!-- IF S_PENDING_SET -->

+ <li class="rightside"><a href="{U_MARK_FORUMS}">{L_MARK_SUBFORUMS_READ}</a></li>

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

+ <object id="qtstream_{_file.ATTACH_ID}" classid="clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B" codebase="http://www.apple.com/qtactivex/qtplugin.cab#version=6,0,2,0" width="320" height="285">

+ <embed name="qtstream_{_file.ATTACH_ID}" src="{_file.U_DOWNLOAD_LINK}" pluginspage="http://www.apple.com/quicktime/download/" enablejavascript="true" controller="true" width="320" height="285" type="video/quicktime" autoplay="false">

+ <th colspan="3" nowrap="nowrap">{L_MERGE_POSTS}</th>

+ <td class="row1" colspan="2" align="center"><br /><a class="gen" href="{U_AIM_CONTACT}">{L_IM_ADD_CONTACT}</a><br /><a class="gen" href="{U_AIM_MESSAGE}">{L_IM_SEND_MESSAGE}</a><br /><br /><a class="gensmall" href="http://www.aim.com">{L_IM_DOWNLOAD_APP}</a> | <a class="gensmall" href="http://www.aim.com/products/express">{L_IM_AIM_EXPRESS}</a> </td>

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

+ <td class="gensmall" width="100%"><div style="float: {S_CONTENT_FLOW_BEGIN};">&nbsp;<b>{L_POST_SUBJECT}:</b> <a href="#p{postrow.POST_ID}">{postrow.POST_SUBJECT}</a></div><div style="float: {S_CONTENT_FLOW_END};"><!-- IF S_IS_BOT -->{postrow.MINI_POST_IMG}<!-- ELSE --><a href="{postrow.U_MINI_POST}">{postrow.MINI_POST_IMG}</a><!-- ENDIF --><b>{L_POSTED}:</b> {postrow.POST_DATE}&nbsp;</div></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;

+}

+

+}

+// Do not display signature panel if not authed to do so

+if (!$auth->acl_get('u_sig'))

+{

+ $module->set_display('profile', 'signature', false);

+}

+

+ $user_cache[$poster_id]['icq'] = 'http://www.icq.com/people/' . urlencode($row['user_icq']) . '/';

+ '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/utf/utf_tools.php';

+

+ function test_nested_transactions()

+ {

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

+

+ // nested transactions should work on systems that do not require

+ // buffering of nested transactions, so ignore the ones that need

+ // buffering

+ if ($db->sql_buffer_nested_transactions())

+ {

+ return;

+ }

+

+ $sql = 'SELECT user_id FROM phpbb_users ORDER BY user_id ASC';

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

+

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

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

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

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

+

+ $this->assertEquals('1', $row['user_id']);

+ }

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

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

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

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

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

+ unset($cache_data['sqlite_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';

+<?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/functions_profile_fields.php';

+

+class phpbb_profile_custom_test extends phpbb_database_test_case

+{

+ public function getDataSet()

+ {

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

+ }

+

+ static public function dropdownFields()

+ {

+ return array(

+ // note, there is an offset of 1 between option_id (0-indexed)

+ // in the database and values (1-indexed) to avoid problems with

+ // transmitting 0 in an HTML form

+ // required, value, expected

+ array(1, '0', 'FIELD_INVALID_VALUE', 'Required field should throw error for out-of-range value'),

+ array(1, '1', 'FIELD_REQUIRED', 'Required field should throw error for default value'),

+ array(1, '2', false, 'Required field should accept non-default value'),

+ array(0, '0', 'FIELD_INVALID_VALUE', 'Optional field should throw error for out-of-range value'),

+ array(0, '1', false, 'Optional field should accept default value'),

+ array(0, '2', false, 'Optional field should accept non-default value'),

+ );

+ }

+

+ /**

+ * @dataProvider dropdownFields

+ */

+ public function test_dropdown_validate($field_required, $field_value, $expected, $description)

+ {

+ global $db;

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

+

+ $field_data = array(

+ 'field_id' => 1,

+ 'lang_id' => 1,

+ 'field_novalue' => 1,

+ 'field_required' => $field_required,

+ );

+

+ $cp = new custom_profile;

+ $result = $cp->validate_profile_field(FIELD_DROPDOWN, &$field_value, $field_data);

+

+ $this->assertEquals($expected, $result, $description);

+ }

+}

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

+<dataset>

+ <table name="phpbb_profile_fields_lang">

+ <column>field_id</column>

+ <column>lang_id</column>

+ <column>option_id</column>

+ <column>field_type</column>

+ <column>lang_value</column>

+ <row>

+ <value>1</value>

+ <value>1</value>

+ <value>0</value>

+ <value>5</value>

+ <value>Default Option</value>

+ </row>

+ <row>

+ <value>1</value>

+ <value>1</value>

+ <value>1</value>

+ <value>5</value>

+ <value>First Alternative</value>

+ </row>

+ <row>

+ <value>1</value>

+ <value>1</value>

+ <value>2</value>

+ <value>5</value>

+ <value>Third Alternative</value>

+ </row>

+ </table>

+</dataset>

+require_once dirname(__FILE__) . '/../../phpBB/includes/functions.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/functions.php';

+

+class phpbb_random_mt_rand_test extends phpbb_test_case

+{

+ public function test_max_equals_min()

+ {

+ $result = phpbb_mt_rand(42, 42);

+ $this->assertEquals(42, $result);

+ }

+

+ public function test_max_equals_min_negative()

+ {

+ $result = phpbb_mt_rand(-42, -42);

+ $this->assertEquals(-42, $result);

+ }

+

+ public function test_max_greater_min()

+ {

+ $result = phpbb_mt_rand(3, 4);

+ $this->assertGreaterThanOrEqual(3, $result);

+ $this->assertLessThanOrEqual(4, $result);

+ }

+

+ public function test_min_greater_max()

+ {

+ $result = phpbb_mt_rand(4, 3);

+ $this->assertGreaterThanOrEqual(3, $result);

+ $this->assertLessThanOrEqual(4, $result);

+ }

+

+ public function test_min_greater_max_negative()

+ {

+ $result = phpbb_mt_rand(-3, -4);

+ $this->assertGreaterThanOrEqual(-4, $result);

+ $this->assertLessThanOrEqual(-3, $result);

+ }

+}

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

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2010 phpBB Group

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

+*

+*/

+

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

+

+class phpbb_password_complexity_test extends phpbb_test_case

+{

+ public function password_complexity_test_data_positive()

+ {

+ return array(

+ array('12345', 'PASS_TYPE_ANY'),

+ array('qwerty', 'PASS_TYPE_ANY'),

+ array('QWERTY', 'PASS_TYPE_ANY'),

+ array('QwerTY', 'PASS_TYPE_ANY'),

+ array('q$erty', 'PASS_TYPE_ANY'),

+ array('qW$rty', 'PASS_TYPE_ANY'),

+

+ array('QwerTY', 'PASS_TYPE_CASE'),

+ array('QwerTY123', 'PASS_TYPE_ALPHA'),

+ array('QwerTY123$&', 'PASS_TYPE_SYMBOL'),

+

+ array('', 'PASS_TYPE_ANY'),

+ );

+ }

+

+ public function password_complexity_test_data_negative()

+ {

+ return array(

+ array('qwerty', 'PASS_TYPE_CASE'),

+ array('QWERTY', 'PASS_TYPE_CASE'),

+ array('123456', 'PASS_TYPE_CASE'),

+ array('#$&', 'PASS_TYPE_CASE'),

+ array('QTY123$', 'PASS_TYPE_CASE'),

+

+ array('qwerty', 'PASS_TYPE_ALPHA'),

+ array('QWERTY', 'PASS_TYPE_ALPHA'),

+ array('123456', 'PASS_TYPE_ALPHA'),

+ array('QwertY', 'PASS_TYPE_ALPHA'),

+ array('qwerty123', 'PASS_TYPE_ALPHA'),

+ array('QWERTY123', 'PASS_TYPE_ALPHA'),

+ array('#$&', 'PASS_TYPE_ALPHA'),

+ array('QTY123$', 'PASS_TYPE_ALPHA'),

+

+ array('qwerty', 'PASS_TYPE_SYMBOL'),

+ array('QWERTY', 'PASS_TYPE_SYMBOL'),

+ array('123456', 'PASS_TYPE_SYMBOL'),

+ array('QwertY', 'PASS_TYPE_SYMBOL'),

+ array('qwerty123', 'PASS_TYPE_SYMBOL'),

+ array('QWERTY123', 'PASS_TYPE_SYMBOL'),

+ array('#$&', 'PASS_TYPE_SYMBOL'),

+ array('qwerty123$', 'PASS_TYPE_SYMBOL'),

+ array('QWERTY123$', 'PASS_TYPE_SYMBOL'),

+ );

+ }

+

+ /**

+ * @dataProvider password_complexity_test_data_positive

+ */

+ public function test_password_complexity_positive($password, $mode)

+ {

+ global $config;

+ $config['pass_complex'] = $mode;

+ $this->assertFalse(validate_password($password));

+ }

+

+ /**

+ * @dataProvider password_complexity_test_data_negative

+ */

+ public function test_password_complexity_negative($password, $mode)

+ {

+ global $config;

+ $config['pass_complex'] = $mode;

+ $this->assertEquals('INVALID_CHARS', validate_password($password));

+ }

+}

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

+<?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/functions.php';

+

+class phpbb_security_hash_test extends phpbb_test_case

+{

+ public function test_check_hash_with_phpass()

+ {

+ $this->assertTrue(phpbb_check_hash('test', '$H$9isfrtKXWqrz8PvztXlL3.daw4U0zI1'));

+ $this->assertTrue(phpbb_check_hash('test', '$P$9isfrtKXWqrz8PvztXlL3.daw4U0zI1'));

+ $this->assertFalse(phpbb_check_hash('foo', '$H$9isfrtKXWqrz8PvztXlL3.daw4U0zI1'));

+ }

+}

+

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

+ {

+ // The session_id field is defined as CHAR(32) in the database schema.

+ // Thus the data we put in session_id fields has to have a length of 32 characters on stricter DBMSes.

+ // Thus we fill those strings up with zeroes until they have a string length of 32.

+

+ return array(

+ array(

+ 'bar_session000000000000000000000', '4', 'user agent', '127.0.0.1',

+ array(

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

+ array('session_id' => 'bar_session000000000000000000000', '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_session00000000000000000000', '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_session000000000000000000000', '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>

+ <value>anon_session00000000000000000000</value>

+ <value>bar_session000000000000000000000</value>

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

+ }

+}

+