+phpBB/cache/queue.php.lock

+phpBB/images/avatars/gallery/*

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

+ }

+ }

+}

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

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

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

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

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

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

+ }

+}

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

+ }

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

+ $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)],

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

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

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

+ // Call checkdnsrr() if

+ // Call dns_get_record() if

+ isset($result['host']) && $result['host'] == $host &&

+ if (ob_get_level() > 0)

+ }

+ $s_search_hidden_fields = array();

+ if ($_SID)

+ {

+ $s_search_hidden_fields['sid'] = $_SID;

+ }

+

+ 'S_SEARCH_HIDDEN_FIELDS' => build_hidden_fields($s_search_hidden_fields),

+

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

+

+ // 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':

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

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

+ // Neither Spamhaus nor Spamcop supports IPv6 addresses.

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

+ {

+ return false;

+ }

+

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

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

+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

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

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

+ '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']) . '/' : '',

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

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

+ <form action="{U_SEARCH}" method="get" id="search">

+ <!-- IF S_PENDING_SET -->

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

+ <form method="get" id="forum-search" action="{S_SEARCHBOX_ACTION}">

+ {S_SEARCH_HIDDEN_FIELDS}

+ <form method="get" id="topic-search" action="{S_SEARCHBOX_ACTION}">

+ {S_SEARCH_HIDDEN_FIELDS}

+ padding: 0 3px;

+ padding: 0 3px;

+ padding: 0;

+ padding: 0;

+ border-width: 0 3px;

+ padding: 0;

+ padding: 0;

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

+<form method="get" name="search" action="{S_SEARCHBOX_ACTION}"><span class="gensmall">{L_SEARCH_FOR}:</span> <input class="post" type="text" name="keywords" size="20" /> <input class="btnlite" type="submit" value="{L_GO}" />{S_SEARCH_HIDDEN_FIELDS}</form>

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

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

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

+{

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

+}

+

+$s_search_hidden_fields = array('fid' => $forum_id);

+if ($_SID)

+{

+ $s_search_hidden_fields['sid'] = $_SID;

+}

+

+ 'S_SEARCHBOX_ACTION' => append_sid("{$phpbb_root_path}search.$phpEx"),

+ 'S_SEARCH_HIDDEN_FIELDS' => build_hidden_fields($s_search_hidden_fields),

+$s_search_hidden_fields = array(

+ 't' => $topic_id,

+ 'sf' => 'msgonly',

+);

+if ($_SID)

+{

+ $s_search_hidden_fields['sid'] = $_SID;

+}

+

+ 'S_SEARCHBOX_ACTION' => append_sid("{$phpbb_root_path}search.$phpEx"),

+ 'S_SEARCH_HIDDEN_FIELDS' => build_hidden_fields($s_search_hidden_fields),

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

+ }

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

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

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

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

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

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

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

+ }

+}

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

+ }

+}

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

+ }

+}

+

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

+

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

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

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

+ 'anon_session00000000000000000000', '4', 'user agent', '127.0.0.1',

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

+ <value>anon_session00000000000000000000</value>

+ <value>bar_session000000000000000000000</value>

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