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

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

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

+ }

+

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

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

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

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

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

+ function sql_buffer_nested_transactions()

+ function sql_buffer_nested_transactions()

+ // Precision must be from 1 to 18

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

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

+}

+

+/**

+*

+*

+* @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),

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

+/**

+* Handle topic bumping

+* @param int $forum_id The ID of the forum the topic is being bumped belongs to

+* @param int $topic_id The ID of the topic is being bumping

+* @param array $post_data Passes some topic parameters:

+* - 'topic_title'

+* - 'topic_last_post_id'

+* - 'topic_last_poster_id'

+* - 'topic_last_post_subject'

+* - 'topic_last_poster_name'

+* - 'topic_last_poster_colour'

+* @param int $bump_time The time at which topic was bumped, usually it is a current time as obtained via time().

+* @return string An URL to the bumped topic, example: ./viewtopic.php?forum_id=1&amptopic_id=2&ampp=3#p3

+*/

+function phpbb_bump_topic($forum_id, $topic_id, $post_data, $bump_time = false)

+{

+ global $config, $db, $user, $phpEx, $phpbb_root_path;

+

+ if ($bump_time === false)

+ {

+ $bump_time = time();

+ }

+

+ // Begin bumping

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

+

+ // Update the topic's last post post_time

+ $sql = 'UPDATE ' . POSTS_TABLE . "

+ SET post_time = $bump_time

+ WHERE post_id = {$post_data['topic_last_post_id']}

+ AND topic_id = $topic_id";

+ $db->sql_query($sql);

+

+ // Sync the topic's last post time, the rest of the topic's last post data isn't changed

+ $sql = 'UPDATE ' . TOPICS_TABLE . "

+ SET topic_last_post_time = $bump_time,

+ topic_bumped = 1,

+ topic_bumper = " . $user->data['user_id'] . "

+ WHERE topic_id = $topic_id";

+ $db->sql_query($sql);

+

+ // Update the forum's last post info

+ $sql = 'UPDATE ' . FORUMS_TABLE . "

+ SET forum_last_post_id = " . $post_data['topic_last_post_id'] . ",

+ forum_last_poster_id = " . $post_data['topic_last_poster_id'] . ",

+ forum_last_post_subject = '" . $db->sql_escape($post_data['topic_last_post_subject']) . "',

+ forum_last_post_time = $bump_time,

+ forum_last_poster_name = '" . $db->sql_escape($post_data['topic_last_poster_name']) . "',

+ forum_last_poster_colour = '" . $db->sql_escape($post_data['topic_last_poster_colour']) . "'

+ WHERE forum_id = $forum_id";

+ $db->sql_query($sql);

+

+ // Update bumper's time of the last posting to prevent flood

+ $sql = 'UPDATE ' . USERS_TABLE . "

+ SET user_lastpost_time = $bump_time

+ WHERE user_id = " . $user->data['user_id'];

+ $db->sql_query($sql);

+

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

+

+ // Mark this topic as posted to

+ markread('post', $forum_id, $topic_id, $bump_time);

+

+ // Mark this topic as read

+ markread('topic', $forum_id, $topic_id, $bump_time);

+

+ // Update forum tracking info

+ if ($config['load_db_lastread'] && $user->data['is_registered'])

+ {

+ $sql = 'SELECT mark_time

+ FROM ' . FORUMS_TRACK_TABLE . '

+ WHERE user_id = ' . $user->data['user_id'] . '

+ AND forum_id = ' . $forum_id;

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

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

+ $db->sql_freeresult($result);

+ }

+ else if ($config['load_anon_lastread'] || $user->data['is_registered'])

+ {

+ $f_mark_time = false;

+ }

+

+ if (($config['load_db_lastread'] && $user->data['is_registered']) || $config['load_anon_lastread'] || $user->data['is_registered'])

+ {

+ // Update forum info

+ $sql = 'SELECT forum_last_post_time

+ FROM ' . FORUMS_TABLE . '

+ WHERE forum_id = ' . $forum_id;

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

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

+ $db->sql_freeresult($result);

+

+ update_forum_tracking_info($forum_id, $forum_last_post_time, $f_mark_time, false);

+ }

+

+ add_log('mod', $forum_id, $topic_id, 'LOG_BUMP_TOPIC', $post_data['topic_title']);

+

+ $url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$forum_id&amp;t=$topic_id&amp;p={$post_data['topic_last_post_id']}") . "#p{$post_data['topic_last_post_id']}";

+

+ return $url;

+}

+

+

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

+ function bbcode_init($allow_custom_bbcode = true)

+ // To parse multiline URL we enable dotall option setting only for URL text

+ // but not for link itself, thus [url][/url] is not affected.

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

+ if (!$allow_custom_bbcode)

+ {

+ return;

+ }

+

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

+ case 'mssqlnative':

+ case 'mssqlnative':

+ case 'mssqlnative':

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

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

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

+ 'BUMP_INTERVAL_EXPLAIN' => 'Number of minutes, hours or days between the last post to a topic and the ability to bump that topic. Setting the value to 0 disables bumping entirely.',

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

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

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

+ $meta_url = phpbb_bump_topic($forum_id, $topic_id, $post_data, $current_time);

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

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

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

+ border-bottom-color: #5D8FBD;

+ padding: 0 3px;

+ padding: 0 3px;

+ padding: 0;

+ padding: 0;

+ border-width: 0 3px;

+ padding: 0;

+ padding: 0;

+ width: 700px;

+ height: 270px;

+ min-width: 100%;

+ max-width: 100%;

+/* .postlink:visited { color: #bdbdbd; } */

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

+ <td valign="top" style="width: 100%;"><textarea name="message" rows="15" cols="76" tabindex="3" onselect="storeCaret(this);" onclick="storeCaret(this);" onkeyup="storeCaret(this);" onfocus="initInsertions();" style="width: 700px; height: 270px; min-width: 98%; max-width: 98%;">{MESSAGE}</textarea></td>

+ <td class="row2" valign="top" align="left" width="78%"><textarea name="message" rows="7" cols="76" tabindex="3" style="width: 700px; height: 130px; min-width: 98%; max-width: 98%;"></textarea> </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),

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

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

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

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

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

+

+class phpbb_url_bbcode_test extends phpbb_test_case

+{

+ public function url_bbcode_test_data()

+ {

+ return array(

+ array(

+ 'url only',

+ '[url]http://www.phpbb.com/community/[/url]',

+ '[url:]http&#58;//www&#46;phpbb&#46;com/community/[/url:]'

+ ),

+ array(

+ 'url with title',

+ '[url=http://www.phpbb.com/community/]One line URL text[/url]',

+ '[url=http&#58;//www&#46;phpbb&#46;com/community/:]One line URL text[/url:]'

+ ),

+ array(

+ 'url with multiline title',

+ "[url=http://www.phpbb.com/community/]Multiline\x0AURL\x0Atext[/url]",

+ "[url=http&#58;//www&#46;phpbb&#46;com/community/:]Multiline\x0AURL\x0Atext[/url:]"

+ ),

+ array(

+ 'unclosed url with multiline',

+ "test [url] test \x0A test [url=http://www.phpbb.com/]test[/url] test",

+ "test [url] test \x0A test [url=http&#58;//www&#46;phpbb&#46;com/:]test[/url:] test"

+ ),

+ array(

+ 'unclosed url with multiline and title',

+ "test [url=http://www.phpbb.com/]test \x0A [url]http://phpbb.com[/url] test",

+ "test [url=http&#58;//www&#46;phpbb&#46;com/:]test \x0A [url]http://phpbb.com[/url:] test"

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider url_bbcode_test_data

+ */

+ public function test_url($description, $message, $expected)

+ {

+ global $user;

+ $user = new phpbb_mock_user;

+

+ $bbcode = new bbcode_firstpass();

+ $bbcode->message = $message;

+ $bbcode->bbcode_init(false);

+ $bbcode->parse_bbcode();

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

+ }

+}

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

+ }

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

+/**

+* Mock user class.

+* This class is used when tests invoke phpBB code expecting to have a global

+* user object, to avoid instantiating the actual user object.

+* It has a minimum amount of functionality, just to make tests work.

+*/

+class phpbb_mock_user

+{

+ public $host = "testhost";

+ public $page = array('root_script_path' => '/');

+}

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

+ }

+}