+ </fieldset>

+ </fieldset>

+

+ </fieldset>

+ </fieldset>

+ </fieldset>

+ </fieldset>

+</fieldset>

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ </fieldset>

+ {S_FORM_TOKEN}

+</fieldset>

+ {S_FORM_TOKEN}

+ </fieldset>

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ </fieldset>

+ {S_FORM_TOKEN}

+ </fieldset>

+ </fieldset>

+ </fieldset>

+ <p class="small"><a href="#" onclick="marklist('inactive', 'mark', true); return false;">{L_MARK_ALL}</a> &bull; <a href="#" onclick="marklist('inactive', 'mark', false); return false;">{L_UNMARK_ALL}</a></p>

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ </fieldset>

+ <div>{S_FORM_TOKEN}</div>

+ <td class="row3" colspan="3" style="text-align: right;">{S_FORM_TOKEN}<input type="submit" name="download_file" class="button2" value="{L_SUBMIT_AND_DOWNLOAD}" />&nbsp;&nbsp;<input type="submit" name="submit_file" class="button2" value="{L_SUBMIT}" /></td>

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ </fieldset>

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ </fieldset>

+

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ ,cb_{custom_tags.BBCODE_ID}: '{custom_tags.A_BBCODE_HELPLINE}'

+ <input type="button" class="button2" name="addbbcode{custom_tags.BBCODE_ID}" value="{custom_tags.BBCODE_TAG}" onclick="bbstyle({custom_tags.BBCODE_ID})"<!-- IF custom_tags.BBCODE_HELPLINE !== '' --> onmouseover="helpline('cb_{custom_tags.BBCODE_ID}')" onmouseout="helpline('tip')"<!-- ENDIF --> />

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ </fieldset>

+.install-body p a {

+ font-weight: bold;

+}

+

+ <div id="main" class="install-body">

+ <!-- IF files.STATUS eq 'not_modified' --><div style="float: {S_CONTENT_FLOW_END};">&raquo; <a href="#" onclick="dE('not_modified', 0); return false;">{L_TOGGLE_DISPLAY}</a></div><!-- ENDIF -->

+$db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport, false, defined('PHPBB_DB_NEW_LINK') ? PHPBB_DB_NEW_LINK : false);

+<?php

+/**

+* Repair bbcodes converted with RC6

+*

+* You should make a backup from your users, posts and privmsgs table in case something goes wrong

+* Forum descriptions and rules need to be re-submitted manually

+*

+*/

+die("Please read the first lines of this script for instructions on how to enable it");

+

+set_time_limit(0);

+@ini_set('memory_limit', '512M');

+

+define('IN_PHPBB', true);

+$phpbb_root_path = './../';

+$phpEx = substr(strrchr(__FILE__, '.'), 1);

+include($phpbb_root_path . 'common.'.$phpEx);

+

+// Start session management

+$user->session_begin();

+$auth->acl($user->data);

+$user->setup();

+

+$echos = 0;

+

+

+// Adjust user signatures

+$sql = 'SELECT user_id, user_sig, user_sig_bbcode_uid

+ FROM ' . USERS_TABLE . '

+ ORDER BY user_id ASC';

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

+

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

+{

+ $bbcode_uid = $row['user_sig_bbcode_uid'];

+

+ // Only if a bbcode uid is present, the signature present and a size tag used...

+ if (!empty($bbcode_uid) && strpos($row['user_sig'], $bbcode_uid) === false)

+ {

+ $row['user_sig'] = preg_replace('/\:[0-9a-z]{8}\]/', ":$bbcode_uid]", $row['user_sig']);

+

+ $sql = 'UPDATE ' . USERS_TABLE . " SET user_sig = '" . $db->sql_escape($row['user_sig']) . "'

+ WHERE user_id = " . $row['user_id'];

+ $db->sql_query($sql);

+

+ if ($echos > 200)

+ {

+ echo '<br />User: ' . "{$row['user_id']}\n";

+ $echos = 0;

+ }

+

+ echo '.';

+ $echos++;

+

+ flush();

+ }

+}

+$db->sql_freeresult($result);

+

+

+// Now adjust posts

+$sql = 'SELECT post_id, post_text, bbcode_uid, enable_bbcode

+ FROM ' . POSTS_TABLE . '

+ ORDER BY post_id ASC';

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

+

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

+{

+ $bbcode_uid = $row['bbcode_uid'];

+

+ // Only if a bbcode uid is present, bbcode enabled and a size tag used...

+ if ($row['enable_bbcode'] && !empty($bbcode_uid) && strpos($row['post_text'], $bbcode_uid) === false)

+ {

+ $row['post_text'] = preg_replace('/\:[0-9a-z]{8}\]/', ":$bbcode_uid]", $row['post_text']);

+

+ $sql = 'UPDATE ' . POSTS_TABLE . " SET post_text = '" . $db->sql_escape($row['post_text']) . "'

+ WHERE post_id = " . $row['post_id'];

+ $db->sql_query($sql);

+

+ if ($echos > 200)

+ {

+ echo '<br />Post: ' . "{$row['post_id']} \n";

+ $echos = 0;

+ }

+

+ echo '.';

+ $echos++;

+

+ flush();

+ }

+}

+$db->sql_freeresult($result);

+

+// Now to the private messages

+$sql = 'SELECT msg_id, message_text, bbcode_uid, enable_bbcode

+ FROM ' . PRIVMSGS_TABLE;

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

+

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

+{

+ $bbcode_uid = $row['bbcode_uid'];

+

+ // Only if a bbcode uid is present, bbcode enabled and a size tag used...

+ if ($row['enable_bbcode'] && !empty($bbcode_uid) && strpos($row['message_text'], $bbcode_uid) === false)

+ {

+ $row['message_text'] = preg_replace('/\:[0-9a-z]{8}\]/', ":$bbcode_uid]", $row['message_text']);

+

+ $sql = 'UPDATE ' . PRIVMSGS_TABLE . " SET message_text = '" . $db->sql_escape($row['message_text']) . "'

+ WHERE msg_id = " . $row['msg_id'];

+ $db->sql_query($sql);

+

+ if ($echos > 200)

+ {

+ echo '<br />' . "\n";

+ $echos = 0;

+ }

+

+ echo '.';

+ $echos++;

+

+ flush();

+ }

+}

+$db->sql_freeresult($result);

+

+// Done

+$db->sql_close();

+echo 'done';

+?> \ No newline at end of file

+<?php

+/**

+*

+* @package phpBB3

+* @version $Id$

+* @copyright (c) 2006 phpBB Group

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

+*

+* This file creates SQL statements to upgrade phpBB on MySQL 3.x/4.0.x to 4.1.x/5.x

+*

+*/

+

+

+//

+// Security message:

+//

+// This script is potentially dangerous.

+// Remove or comment the next line (die(".... ) to enable this script.

+// Do NOT FORGET to either remove this script or disable it after you have used it.

+//

+die("Please read the first lines of this script for instructions on how to enable it");

+

+define('IN_PHPBB', true);

+$phpEx = substr(strrchr(__FILE__, '.'), 1);

+include($phpbb_root_path . 'common.' . $phpEx);

+

+$prefix = $table_prefix;

+

+$newline = "\n";

+

+if (PHP_SAPI !== 'cli')

+{

+ $newline = '<br>';

+}

+

+$sql = 'DESCRIBE ' . POSTS_TABLE . ' post_text';

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

+

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

+

+$db->sql_freeresult($result);

+

+$mysql_indexer = false;

+

+if (strtolower($row['Type']) === 'mediumtext')

+{

+ $mysql_indexer = true;

+}

+

+echo "USE $dbname;$newline$newline";

+

+

+@set_time_limit(0);

+

+$schema_data = get_schema_struct();

+$dbms_type_map = array(

+ 'mysql_41' => array(

+ 'INT:' => 'int(%d)',

+ 'BINT' => 'bigint(20)',

+ 'UINT' => 'mediumint(8) UNSIGNED',

+ 'UINT:' => 'int(%d) UNSIGNED',

+ 'TINT:' => 'tinyint(%d)',

+ 'USINT' => 'smallint(4) UNSIGNED',

+ 'BOOL' => 'tinyint(1) UNSIGNED',

+ 'VCHAR' => 'varchar(255)',

+ 'VCHAR:' => 'varchar(%d)',

+ 'CHAR:' => 'char(%d)',

+ 'XSTEXT' => 'text',

+ 'XSTEXT_UNI'=> 'varchar(100)',

+ 'STEXT' => 'text',

+ 'STEXT_UNI' => 'varchar(255)',

+ 'TEXT' => 'text',

+ 'TEXT_UNI' => 'text',

+ 'MTEXT' => 'mediumtext',

+ 'MTEXT_UNI' => 'mediumtext',

+ 'TIMESTAMP' => 'int(11) UNSIGNED',

+ 'DECIMAL' => 'decimal(5,2)',

+ 'DECIMAL:' => 'decimal(%d,2)',

+ 'PDECIMAL' => 'decimal(6,3)',

+ 'PDECIMAL:' => 'decimal(%d,3)',

+ 'VCHAR_UNI' => 'varchar(255)',

+ 'VCHAR_UNI:'=> 'varchar(%d)',

+ 'VCHAR_CI' => 'varchar(255)',

+ 'VARBINARY' => 'varbinary(255)',

+ ),

+

+ 'mysql_40' => array(

+ 'INT:' => 'int(%d)',

+ 'BINT' => 'bigint(20)',

+ 'UINT' => 'mediumint(8) UNSIGNED',

+ 'UINT:' => 'int(%d) UNSIGNED',

+ 'TINT:' => 'tinyint(%d)',

+ 'USINT' => 'smallint(4) UNSIGNED',

+ 'BOOL' => 'tinyint(1) UNSIGNED',

+ 'VCHAR' => 'varbinary(255)',

+ 'VCHAR:' => 'varbinary(%d)',

+ 'CHAR:' => 'binary(%d)',

+ 'XSTEXT' => 'blob',

+ 'XSTEXT_UNI'=> 'blob',

+ 'STEXT' => 'blob',

+ 'STEXT_UNI' => 'blob',

+ 'TEXT' => 'blob',

+ 'TEXT_UNI' => 'blob',

+ 'MTEXT' => 'mediumblob',

+ 'MTEXT_UNI' => 'mediumblob',

+ 'TIMESTAMP' => 'int(11) UNSIGNED',

+ 'DECIMAL' => 'decimal(5,2)',

+ 'DECIMAL:' => 'decimal(%d,2)',

+ 'PDECIMAL' => 'decimal(6,3)',

+ 'PDECIMAL:' => 'decimal(%d,3)',

+ 'VCHAR_UNI' => 'blob',

+ 'VCHAR_UNI:'=> array('varbinary(%d)', 'limit' => array('mult', 3, 255, 'blob')),

+ 'VCHAR_CI' => 'blob',

+ 'VARBINARY' => 'varbinary(255)',

+ ),

+);

+

+foreach ($schema_data as $table_name => $table_data)

+{

+ $table_name = str_replace('phpbb_', $prefix, $table_name);

+ // Write comment about table

+ echo "# Table: '{$table_name}'$newline";

+

+ // Create Table statement

+ $generator = $textimage = false;

+

+ $line = "ALTER TABLE {$table_name} $newline";

+

+ // Table specific so we don't get overlap

+ $modded_array = array();

+

+ // Write columns one by one...

+ foreach ($table_data['COLUMNS'] as $column_name => $column_data)

+ {

+ // Get type

+ if (strpos($column_data[0], ':') !== false)

+ {

+ list($orig_column_type, $column_length) = explode(':', $column_data[0]);

+ $column_type = sprintf($dbms_type_map['mysql_41'][$orig_column_type . ':'], $column_length);

+

+ if (isset($dbms_type_map['mysql_40'][$orig_column_type . ':']['limit'][0]))

+ {

+ switch ($dbms_type_map['mysql_40'][$orig_column_type . ':']['limit'][0])

+ {

+ case 'mult':

+ if (($column_length * $dbms_type_map['mysql_40'][$orig_column_type . ':']['limit'][1]) > $dbms_type_map['mysql_40'][$orig_column_type . ':']['limit'][2])

+ {

+ $modded_array[$column_name] = $column_type;

+ }

+ break;

+ }

+ }

+

+ $orig_column_type .= ':';

+ }

+ else

+ {

+ $orig_column_type = $column_data[0];

+ $other_column_type = $dbms_type_map['mysql_40'][$column_data[0]];

+ if ($other_column_type == 'text' || $other_column_type == 'blob')

+ {

+ $modded_array[$column_name] = $column_type;

+ }

+ $column_type = $dbms_type_map['mysql_41'][$column_data[0]];

+ }

+

+ // Adjust default value if db-dependant specified

+ if (is_array($column_data[1]))

+ {

+ $column_data[1] = (isset($column_data[1][$dbms])) ? $column_data[1][$dbms] : $column_data[1]['default'];

+ }

+

+ $line .= "\tMODIFY {$column_name} {$column_type} ";

+

+ // For hexadecimal values do not use single quotes

+ if (!is_null($column_data[1]) && substr($column_type, -4) !== 'text' && substr($column_type, -4) !== 'blob')

+ {

+ $line .= (strpos($column_data[1], '0x') === 0) ? "DEFAULT {$column_data[1]} " : "DEFAULT '{$column_data[1]}' ";

+ }

+ $line .= 'NOT NULL';

+

+ if (isset($column_data[2]))

+ {

+ if ($column_data[2] == 'auto_increment')

+ {

+ $line .= ' auto_increment';

+ }

+ else if ($column_data[2] == 'true_sort')

+ {

+ $line .= ' COLLATE utf8_unicode_ci';

+ }

+ else if ($column_data[2] == 'no_sort')

+ {

+ $line .= ' COLLATE utf8_bin';

+ }

+ }

+ else if (preg_match('/(?:var)?char|(?:medium)?text/i', $column_type))

+ {

+ $line .= ' COLLATE utf8_bin';

+ }

+

+ $line .= ",$newline";

+ }

+

+ // Write Keys

+ if (isset($table_data['KEYS']))

+ {

+ foreach ($table_data['KEYS'] as $key_name => $key_data)

+ {

+ $temp = '';

+ if (!is_array($key_data[1]))

+ {

+ $key_data[1] = array($key_data[1]);

+ }

+

+ $temp .= ($key_data[0] == 'INDEX') ? "\tADD KEY" : '';

+ $temp .= ($key_data[0] == 'UNIQUE') ? "\tADD UNIQUE" : '';

+ $repair = false;

+ foreach ($key_data[1] as $key => $col_name)

+ {

+ if (isset($modded_array[$col_name]))

+ {

+ $repair = true;

+ }

+ }

+ if ($repair)

+ {

+ $line .= "\tDROP INDEX " . $key_name . ",$newline";

+ $line .= $temp;

+ $line .= ' ' . $key_name . ' (' . implode(', ', $key_data[1]) . "),$newline";

+ }

+ }

+ }

+

+ //$line .= "\tCONVERT TO CHARACTER SET `utf8`$newline";

+ $line .= "\tDEFAULT CHARSET=utf8 COLLATE=utf8_bin;$newline$newline";

+

+ echo $line . "$newline";

+}

+

+/**

+* Define the basic structure

+* The format:

+* array('{TABLE_NAME}' => {TABLE_DATA})

+* {TABLE_DATA}:

+* COLUMNS = array({column_name} = array({column_type}, {default}, {auto_increment}))

+* PRIMARY_KEY = {column_name(s)}

+* KEYS = array({key_name} = array({key_type}, {column_name(s)})),

+*

+* Column Types:

+* INT:x => SIGNED int(x)

+* BINT => BIGINT

+* UINT => mediumint(8) UNSIGNED

+* UINT:x => int(x) UNSIGNED

+* TINT:x => tinyint(x)

+* USINT => smallint(4) UNSIGNED (for _order columns)

+* BOOL => tinyint(1) UNSIGNED

+* VCHAR => varchar(255)

+* CHAR:x => char(x)

+* XSTEXT_UNI => text for storing 100 characters (topic_title for example)

+* STEXT_UNI => text for storing 255 characters (normal input field with a max of 255 single-byte chars) - same as VCHAR_UNI

+* TEXT_UNI => text for storing 3000 characters (short text, descriptions, comments, etc.)

+* MTEXT_UNI => mediumtext (post text, large text)

+* VCHAR:x => varchar(x)

+* TIMESTAMP => int(11) UNSIGNED

+* DECIMAL => decimal number (5,2)

+* DECIMAL: => decimal number (x,2)

+* PDECIMAL => precision decimal number (6,3)

+* PDECIMAL: => precision decimal number (x,3)

+* VCHAR_UNI => varchar(255) BINARY

+* VCHAR_CI => varchar_ci for postgresql, others VCHAR

+*/

+function get_schema_struct()

+{

+ $schema_data = array();

+

+ $schema_data['phpbb_attachments'] = array(

+ 'COLUMNS' => array(

+ 'attach_id' => array('UINT', NULL, 'auto_increment'),

+ 'post_msg_id' => array('UINT', 0),

+ 'topic_id' => array('UINT', 0),

+ 'in_message' => array('BOOL', 0),

+ 'poster_id' => array('UINT', 0),

+ 'is_orphan' => array('BOOL', 1),

+ 'physical_filename' => array('VCHAR', ''),

+ 'real_filename' => array('VCHAR', ''),

+ 'download_count' => array('UINT', 0),

+ 'attach_comment' => array('TEXT_UNI', ''),

+ 'extension' => array('VCHAR:100', ''),

+ 'mimetype' => array('VCHAR:100', ''),

+ 'filesize' => array('UINT:20', 0),

+ 'filetime' => array('TIMESTAMP', 0),

+ 'thumbnail' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => 'attach_id',

+ 'KEYS' => array(

+ 'filetime' => array('INDEX', 'filetime'),

+ 'post_msg_id' => array('INDEX', 'post_msg_id'),

+ 'topic_id' => array('INDEX', 'topic_id'),

+ 'poster_id' => array('INDEX', 'poster_id'),

+ 'is_orphan' => array('INDEX', 'is_orphan'),

+ ),

+ );

+

+ $schema_data['phpbb_acl_groups'] = array(

+ 'COLUMNS' => array(

+ 'group_id' => array('UINT', 0),

+ 'forum_id' => array('UINT', 0),

+ 'auth_option_id' => array('UINT', 0),

+ 'auth_role_id' => array('UINT', 0),

+ 'auth_setting' => array('TINT:2', 0),

+ ),

+ 'KEYS' => array(

+ 'group_id' => array('INDEX', 'group_id'),

+ 'auth_opt_id' => array('INDEX', 'auth_option_id'),

+ 'auth_role_id' => array('INDEX', 'auth_role_id'),

+ ),

+ );

+

+ $schema_data['phpbb_acl_options'] = array(

+ 'COLUMNS' => array(

+ 'auth_option_id' => array('UINT', NULL, 'auto_increment'),

+ 'auth_option' => array('VCHAR:50', ''),

+ 'is_global' => array('BOOL', 0),

+ 'is_local' => array('BOOL', 0),

+ 'founder_only' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => 'auth_option_id',

+ 'KEYS' => array(

+ 'auth_option' => array('INDEX', 'auth_option'),

+ ),

+ );

+

+ $schema_data['phpbb_acl_roles'] = array(

+ 'COLUMNS' => array(

+ 'role_id' => array('UINT', NULL, 'auto_increment'),

+ 'role_name' => array('VCHAR_UNI', ''),

+ 'role_description' => array('TEXT_UNI', ''),

+ 'role_type' => array('VCHAR:10', ''),

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

+ ),

+ 'PRIMARY_KEY' => 'role_id',

+ 'KEYS' => array(

+ 'role_type' => array('INDEX', 'role_type'),

+ 'role_order' => array('INDEX', 'role_order'),

+ ),

+ );

+

+ $schema_data['phpbb_acl_roles_data'] = array(

+ 'COLUMNS' => array(

+ 'role_id' => array('UINT', 0),

+ 'auth_option_id' => array('UINT', 0),

+ 'auth_setting' => array('TINT:2', 0),

+ ),

+ 'PRIMARY_KEY' => array('role_id', 'auth_option_id'),

+ 'KEYS' => array(

+ 'ath_op_id' => array('INDEX', 'auth_option_id'),

+ ),

+ );

+

+ $schema_data['phpbb_acl_users'] = array(

+ 'COLUMNS' => array(

+ 'user_id' => array('UINT', 0),

+ 'forum_id' => array('UINT', 0),

+ 'auth_option_id' => array('UINT', 0),

+ 'auth_role_id' => array('UINT', 0),

+ 'auth_setting' => array('TINT:2', 0),

+ ),

+ 'KEYS' => array(

+ 'user_id' => array('INDEX', 'user_id'),

+ 'auth_option_id' => array('INDEX', 'auth_option_id'),

+ 'auth_role_id' => array('INDEX', 'auth_role_id'),

+ ),

+ );

+

+ $schema_data['phpbb_banlist'] = array(

+ 'COLUMNS' => array(

+ 'ban_id' => array('UINT', NULL, 'auto_increment'),

+ 'ban_userid' => array('UINT', 0),

+ 'ban_ip' => array('VCHAR:40', ''),

+ 'ban_email' => array('VCHAR_UNI:100', ''),

+ 'ban_start' => array('TIMESTAMP', 0),

+ 'ban_end' => array('TIMESTAMP', 0),

+ 'ban_exclude' => array('BOOL', 0),

+ 'ban_reason' => array('VCHAR_UNI', ''),

+ 'ban_give_reason' => array('VCHAR_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'ban_id',

+ 'KEYS' => array(

+ 'ban_end' => array('INDEX', 'ban_end'),

+ 'ban_user' => array('INDEX', array('ban_userid', 'ban_exclude')),

+ 'ban_email' => array('INDEX', array('ban_email', 'ban_exclude')),

+ 'ban_ip' => array('INDEX', array('ban_ip', 'ban_exclude')),

+ ),

+ );

+

+ $schema_data['phpbb_bbcodes'] = array(

+ 'COLUMNS' => array(

+ 'bbcode_id' => array('TINT:3', 0),

+ 'bbcode_tag' => array('VCHAR:16', ''),

+ 'bbcode_helpline' => array('VCHAR_UNI', ''),

+ 'display_on_posting' => array('BOOL', 0),

+ 'bbcode_match' => array('TEXT_UNI', ''),

+ 'bbcode_tpl' => array('MTEXT_UNI', ''),

+ 'first_pass_match' => array('MTEXT_UNI', ''),

+ 'first_pass_replace' => array('MTEXT_UNI', ''),

+ 'second_pass_match' => array('MTEXT_UNI', ''),

+ 'second_pass_replace' => array('MTEXT_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'bbcode_id',

+ 'KEYS' => array(

+ 'display_on_post' => array('INDEX', 'display_on_posting'),

+ ),

+ );

+

+ $schema_data['phpbb_bookmarks'] = array(

+ 'COLUMNS' => array(

+ 'topic_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ ),

+ 'PRIMARY_KEY' => array('topic_id', 'user_id'),

+ );

+

+ $schema_data['phpbb_bots'] = array(

+ 'COLUMNS' => array(

+ 'bot_id' => array('UINT', NULL, 'auto_increment'),

+ 'bot_active' => array('BOOL', 1),

+ 'bot_name' => array('STEXT_UNI', ''),

+ 'user_id' => array('UINT', 0),

+ 'bot_agent' => array('VCHAR', ''),

+ 'bot_ip' => array('VCHAR', ''),

+ ),

+ 'PRIMARY_KEY' => 'bot_id',

+ 'KEYS' => array(

+ 'bot_active' => array('INDEX', 'bot_active'),

+ ),

+ );

+

+ $schema_data['phpbb_config'] = array(

+ 'COLUMNS' => array(

+ 'config_name' => array('VCHAR', ''),

+ 'config_value' => array('VCHAR_UNI', ''),

+ 'is_dynamic' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => 'config_name',

+ 'KEYS' => array(

+ 'is_dynamic' => array('INDEX', 'is_dynamic'),

+ ),

+ );

+

+ $schema_data['phpbb_confirm'] = array(

+ 'COLUMNS' => array(

+ 'confirm_id' => array('CHAR:32', ''),

+ 'session_id' => array('CHAR:32', ''),

+ 'confirm_type' => array('TINT:3', 0),

+ 'code' => array('VCHAR:8', ''),

+ 'seed' => array('UINT:10', 0),

+ ),

+ 'PRIMARY_KEY' => array('session_id', 'confirm_id'),

+ 'KEYS' => array(

+ 'confirm_type' => array('INDEX', 'confirm_type'),

+ ),

+ );

+

+ $schema_data['phpbb_disallow'] = array(

+ 'COLUMNS' => array(

+ 'disallow_id' => array('UINT', NULL, 'auto_increment'),

+ 'disallow_username' => array('VCHAR_UNI:255', ''),

+ ),

+ 'PRIMARY_KEY' => 'disallow_id',

+ );

+

+ $schema_data['phpbb_drafts'] = array(

+ 'COLUMNS' => array(

+ 'draft_id' => array('UINT', NULL, 'auto_increment'),

+ 'user_id' => array('UINT', 0),

+ 'topic_id' => array('UINT', 0),

+ 'forum_id' => array('UINT', 0),

+ 'save_time' => array('TIMESTAMP', 0),

+ 'draft_subject' => array('XSTEXT_UNI', ''),

+ 'draft_message' => array('MTEXT_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'draft_id',

+ 'KEYS' => array(

+ 'save_time' => array('INDEX', 'save_time'),

+ ),

+ );

+

+ $schema_data['phpbb_extensions'] = array(

+ 'COLUMNS' => array(

+ 'extension_id' => array('UINT', NULL, 'auto_increment'),

+ 'group_id' => array('UINT', 0),

+ 'extension' => array('VCHAR:100', ''),

+ ),

+ 'PRIMARY_KEY' => 'extension_id',

+ );

+

+ $schema_data['phpbb_extension_groups'] = array(

+ 'COLUMNS' => array(

+ 'group_id' => array('UINT', NULL, 'auto_increment'),

+ 'group_name' => array('VCHAR_UNI', ''),

+ 'cat_id' => array('TINT:2', 0),

+ 'allow_group' => array('BOOL', 0),

+ 'download_mode' => array('BOOL', 1),

+ 'upload_icon' => array('VCHAR', ''),

+ 'max_filesize' => array('UINT:20', 0),

+ 'allowed_forums' => array('TEXT', ''),

+ 'allow_in_pm' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => 'group_id',

+ );

+

+ $schema_data['phpbb_forums'] = array(

+ 'COLUMNS' => array(

+ 'forum_id' => array('UINT', NULL, 'auto_increment'),

+ 'parent_id' => array('UINT', 0),

+ 'left_id' => array('UINT', 0),

+ 'right_id' => array('UINT', 0),

+ 'forum_parents' => array('MTEXT', ''),

+ 'forum_name' => array('STEXT_UNI', ''),

+ 'forum_desc' => array('TEXT_UNI', ''),

+ 'forum_desc_bitfield' => array('VCHAR:255', ''),

+ 'forum_desc_options' => array('UINT:11', 7),

+ 'forum_desc_uid' => array('VCHAR:8', ''),

+ 'forum_link' => array('VCHAR_UNI', ''),

+ 'forum_password' => array('VCHAR_UNI:40', ''),

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

+ 'forum_image' => array('VCHAR', ''),

+ 'forum_rules' => array('TEXT_UNI', ''),

+ 'forum_rules_link' => array('VCHAR_UNI', ''),

+ 'forum_rules_bitfield' => array('VCHAR:255', ''),

+ 'forum_rules_options' => array('UINT:11', 7),

+ 'forum_rules_uid' => array('VCHAR:8', ''),

+ 'forum_topics_per_page' => array('TINT:4', 0),

+ 'forum_type' => array('TINT:4', 0),

+ 'forum_status' => array('TINT:4', 0),

+ 'forum_posts' => array('UINT', 0),

+ 'forum_topics' => array('UINT', 0),

+ 'forum_topics_real' => array('UINT', 0),

+ 'forum_last_post_id' => array('UINT', 0),

+ 'forum_last_poster_id' => array('UINT', 0),

+ 'forum_last_post_subject' => array('XSTEXT_UNI', ''),

+ 'forum_last_post_time' => array('TIMESTAMP', 0),

+ 'forum_last_poster_name'=> array('VCHAR_UNI', ''),

+ 'forum_last_poster_colour'=> array('VCHAR:6', ''),

+ 'forum_flags' => array('TINT:4', 32),

+ 'display_on_index' => array('BOOL', 1),

+ 'enable_indexing' => array('BOOL', 1),

+ 'enable_icons' => array('BOOL', 1),

+ 'enable_prune' => array('BOOL', 0),

+ 'prune_next' => array('TIMESTAMP', 0),

+ 'prune_days' => array('UINT', 0),

+ 'prune_viewed' => array('UINT', 0),

+ 'prune_freq' => array('UINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'forum_id',

+ 'KEYS' => array(

+ 'left_right_id' => array('INDEX', array('left_id', 'right_id')),

+ 'forum_lastpost_id' => array('INDEX', 'forum_last_post_id'),

+ ),

+ );

+

+ $schema_data['phpbb_forums_access'] = array(

+ 'COLUMNS' => array(

+ 'forum_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ 'session_id' => array('CHAR:32', ''),

+ ),

+ 'PRIMARY_KEY' => array('forum_id', 'user_id', 'session_id'),

+ );

+

+ $schema_data['phpbb_forums_track'] = array(

+ 'COLUMNS' => array(

+ 'user_id' => array('UINT', 0),

+ 'forum_id' => array('UINT', 0),

+ 'mark_time' => array('TIMESTAMP', 0),

+ ),

+ 'PRIMARY_KEY' => array('user_id', 'forum_id'),

+ );

+

+ $schema_data['phpbb_forums_watch'] = array(

+ 'COLUMNS' => array(

+ 'forum_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ 'notify_status' => array('BOOL', 0),

+ ),

+ 'KEYS' => array(

+ 'forum_id' => array('INDEX', 'forum_id'),

+ 'user_id' => array('INDEX', 'user_id'),

+ 'notify_stat' => array('INDEX', 'notify_status'),

+ ),

+ );

+

+ $schema_data['phpbb_groups'] = array(

+ 'COLUMNS' => array(

+ 'group_id' => array('UINT', NULL, 'auto_increment'),

+ 'group_type' => array('TINT:4', 1),

+ 'group_founder_manage' => array('BOOL', 0),

+ 'group_name' => array('VCHAR_CI', ''),

+ 'group_desc' => array('TEXT_UNI', ''),

+ 'group_desc_bitfield' => array('VCHAR:255', ''),

+ 'group_desc_options' => array('UINT:11', 7),

+ 'group_desc_uid' => array('VCHAR:8', ''),

+ 'group_display' => array('BOOL', 0),

+ 'group_avatar' => array('VCHAR', ''),

+ 'group_avatar_type' => array('TINT:2', 0),

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

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

+ 'group_rank' => array('UINT', 0),

+ 'group_colour' => array('VCHAR:6', ''),

+ 'group_sig_chars' => array('UINT', 0),

+ 'group_receive_pm' => array('BOOL', 0),

+ 'group_message_limit' => array('UINT', 0),

+ 'group_legend' => array('BOOL', 1),

+ ),

+ 'PRIMARY_KEY' => 'group_id',

+ 'KEYS' => array(

+ 'group_legend' => array('INDEX', 'group_legend'),

+ ),

+ );

+

+ $schema_data['phpbb_icons'] = array(

+ 'COLUMNS' => array(

+ 'icons_id' => array('UINT', NULL, 'auto_increment'),

+ 'icons_url' => array('VCHAR', ''),

+ 'icons_width' => array('TINT:4', 0),

+ 'icons_height' => array('TINT:4', 0),

+ 'icons_order' => array('UINT', 0),

+ 'display_on_posting' => array('BOOL', 1),

+ ),

+ 'PRIMARY_KEY' => 'icons_id',

+ 'KEYS' => array(

+ 'display_on_posting' => array('INDEX', 'display_on_posting'),

+ ),

+ );

+

+ $schema_data['phpbb_lang'] = array(

+ 'COLUMNS' => array(

+ 'lang_id' => array('TINT:4', NULL, 'auto_increment'),

+ 'lang_iso' => array('VCHAR:30', ''),

+ 'lang_dir' => array('VCHAR:30', ''),

+ 'lang_english_name' => array('VCHAR_UNI:100', ''),

+ 'lang_local_name' => array('VCHAR_UNI:255', ''),

+ 'lang_author' => array('VCHAR_UNI:255', ''),

+ ),

+ 'PRIMARY_KEY' => 'lang_id',

+ 'KEYS' => array(

+ 'lang_iso' => array('INDEX', 'lang_iso'),

+ ),

+ );

+

+ $schema_data['phpbb_log'] = array(

+ 'COLUMNS' => array(

+ 'log_id' => array('UINT', NULL, 'auto_increment'),

+ 'log_type' => array('TINT:4', 0),

+ 'user_id' => array('UINT', 0),

+ 'forum_id' => array('UINT', 0),

+ 'topic_id' => array('UINT', 0),

+ 'reportee_id' => array('UINT', 0),

+ 'log_ip' => array('VCHAR:40', ''),

+ 'log_time' => array('TIMESTAMP', 0),

+ 'log_operation' => array('TEXT_UNI', ''),

+ 'log_data' => array('MTEXT_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'log_id',

+ 'KEYS' => array(

+ 'log_type' => array('INDEX', 'log_type'),

+ 'forum_id' => array('INDEX', 'forum_id'),

+ 'topic_id' => array('INDEX', 'topic_id'),

+ 'reportee_id' => array('INDEX', 'reportee_id'),

+ 'user_id' => array('INDEX', 'user_id'),

+ ),

+ );

+

+ $schema_data['phpbb_moderator_cache'] = array(

+ 'COLUMNS' => array(

+ 'forum_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ 'username' => array('VCHAR_UNI:255', ''),

+ 'group_id' => array('UINT', 0),

+ 'group_name' => array('VCHAR_UNI', ''),

+ 'display_on_index' => array('BOOL', 1),

+ ),

+ 'KEYS' => array(

+ 'disp_idx' => array('INDEX', 'display_on_index'),

+ 'forum_id' => array('INDEX', 'forum_id'),

+ ),

+ );

+

+ $schema_data['phpbb_modules'] = array(

+ 'COLUMNS' => array(

+ 'module_id' => array('UINT', NULL, 'auto_increment'),

+ 'module_enabled' => array('BOOL', 1),

+ 'module_display' => array('BOOL', 1),

+ 'module_basename' => array('VCHAR', ''),

+ 'module_class' => array('VCHAR:10', ''),

+ 'parent_id' => array('UINT', 0),

+ 'left_id' => array('UINT', 0),

+ 'right_id' => array('UINT', 0),

+ 'module_langname' => array('VCHAR', ''),

+ 'module_mode' => array('VCHAR', ''),

+ 'module_auth' => array('VCHAR', ''),

+ ),

+ 'PRIMARY_KEY' => 'module_id',

+ 'KEYS' => array(

+ 'left_right_id' => array('INDEX', array('left_id', 'right_id')),

+ 'module_enabled' => array('INDEX', 'module_enabled'),

+ 'class_left_id' => array('INDEX', array('module_class', 'left_id')),

+ ),

+ );

+

+ $schema_data['phpbb_poll_options'] = array(

+ 'COLUMNS' => array(

+ 'poll_option_id' => array('TINT:4', 0),

+ 'topic_id' => array('UINT', 0),

+ 'poll_option_text' => array('TEXT_UNI', ''),

+ 'poll_option_total' => array('UINT', 0),

+ ),

+ 'KEYS' => array(

+ 'poll_opt_id' => array('INDEX', 'poll_option_id'),

+ 'topic_id' => array('INDEX', 'topic_id'),

+ ),

+ );

+

+ $schema_data['phpbb_poll_votes'] = array(

+ 'COLUMNS' => array(

+ 'topic_id' => array('UINT', 0),

+ 'poll_option_id' => array('TINT:4', 0),

+ 'vote_user_id' => array('UINT', 0),

+ 'vote_user_ip' => array('VCHAR:40', ''),

+ ),

+ 'KEYS' => array(

+ 'topic_id' => array('INDEX', 'topic_id'),

+ 'vote_user_id' => array('INDEX', 'vote_user_id'),

+ 'vote_user_ip' => array('INDEX', 'vote_user_ip'),

+ ),

+ );

+

+ $schema_data['phpbb_posts'] = array(

+ 'COLUMNS' => array(

+ 'post_id' => array('UINT', NULL, 'auto_increment'),

+ 'topic_id' => array('UINT', 0),

+ 'forum_id' => array('UINT', 0),

+ 'poster_id' => array('UINT', 0),

+ 'icon_id' => array('UINT', 0),

+ 'poster_ip' => array('VCHAR:40', ''),

+ 'post_time' => array('TIMESTAMP', 0),

+ 'post_approved' => array('BOOL', 1),

+ 'post_reported' => array('BOOL', 0),

+ 'enable_bbcode' => array('BOOL', 1),

+ 'enable_smilies' => array('BOOL', 1),

+ 'enable_magic_url' => array('BOOL', 1),

+ 'enable_sig' => array('BOOL', 1),

+ 'post_username' => array('VCHAR_UNI:255', ''),

+ 'post_subject' => array('XSTEXT_UNI', '', 'true_sort'),

+ 'post_text' => array('MTEXT_UNI', '', ($GLOBALS['mysql_indexer']) ? 'true_sort' : 'no_sort'),

+ 'post_checksum' => array('VCHAR:32', ''),

+ 'post_attachment' => array('BOOL', 0),

+ 'bbcode_bitfield' => array('VCHAR:255', ''),

+ 'bbcode_uid' => array('VCHAR:8', ''),

+ 'post_postcount' => array('BOOL', 1),

+ 'post_edit_time' => array('TIMESTAMP', 0),

+ 'post_edit_reason' => array('STEXT_UNI', ''),

+ 'post_edit_user' => array('UINT', 0),

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

+ 'post_edit_locked' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => 'post_id',

+ 'KEYS' => array(

+ 'forum_id' => array('INDEX', 'forum_id'),

+ 'topic_id' => array('INDEX', 'topic_id'),

+ 'poster_ip' => array('INDEX', 'poster_ip'),

+ 'poster_id' => array('INDEX', 'poster_id'),

+ 'post_approved' => array('INDEX', 'post_approved'),

+ 'tid_post_time' => array('INDEX', array('topic_id', 'post_time')),

+ ),

+ );

+

+ $schema_data['phpbb_privmsgs'] = array(

+ 'COLUMNS' => array(

+ 'msg_id' => array('UINT', NULL, 'auto_increment'),

+ 'root_level' => array('UINT', 0),

+ 'author_id' => array('UINT', 0),

+ 'icon_id' => array('UINT', 0),

+ 'author_ip' => array('VCHAR:40', ''),

+ 'message_time' => array('TIMESTAMP', 0),

+ 'enable_bbcode' => array('BOOL', 1),

+ 'enable_smilies' => array('BOOL', 1),

+ 'enable_magic_url' => array('BOOL', 1),

+ 'enable_sig' => array('BOOL', 1),

+ 'message_subject' => array('XSTEXT_UNI', ''),

+ 'message_text' => array('MTEXT_UNI', ''),

+ 'message_edit_reason' => array('STEXT_UNI', ''),

+ 'message_edit_user' => array('UINT', 0),

+ 'message_attachment' => array('BOOL', 0),

+ 'bbcode_bitfield' => array('VCHAR:255', ''),

+ 'bbcode_uid' => array('VCHAR:8', ''),

+ 'message_edit_time' => array('TIMESTAMP', 0),

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

+ 'to_address' => array('TEXT_UNI', ''),

+ 'bcc_address' => array('TEXT_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'msg_id',

+ 'KEYS' => array(

+ 'author_ip' => array('INDEX', 'author_ip'),

+ 'message_time' => array('INDEX', 'message_time'),

+ 'author_id' => array('INDEX', 'author_id'),

+ 'root_level' => array('INDEX', 'root_level'),

+ ),

+ );

+

+ $schema_data['phpbb_privmsgs_folder'] = array(

+ 'COLUMNS' => array(

+ 'folder_id' => array('UINT', NULL, 'auto_increment'),

+ 'user_id' => array('UINT', 0),

+ 'folder_name' => array('VCHAR_UNI', ''),

+ 'pm_count' => array('UINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'folder_id',

+ 'KEYS' => array(

+ 'user_id' => array('INDEX', 'user_id'),

+ ),

+ );

+

+ $schema_data['phpbb_privmsgs_rules'] = array(

+ 'COLUMNS' => array(

+ 'rule_id' => array('UINT', NULL, 'auto_increment'),

+ 'user_id' => array('UINT', 0),

+ 'rule_check' => array('UINT', 0),

+ 'rule_connection' => array('UINT', 0),

+ 'rule_string' => array('VCHAR_UNI', ''),

+ 'rule_user_id' => array('UINT', 0),

+ 'rule_group_id' => array('UINT', 0),

+ 'rule_action' => array('UINT', 0),

+ 'rule_folder_id' => array('INT:11', 0),

+ ),

+ 'PRIMARY_KEY' => 'rule_id',

+ 'KEYS' => array(

+ 'user_id' => array('INDEX', 'user_id'),

+ ),

+ );

+

+ $schema_data['phpbb_privmsgs_to'] = array(

+ 'COLUMNS' => array(

+ 'msg_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ 'author_id' => array('UINT', 0),

+ 'pm_deleted' => array('BOOL', 0),

+ 'pm_new' => array('BOOL', 1),

+ 'pm_unread' => array('BOOL', 1),

+ 'pm_replied' => array('BOOL', 0),

+ 'pm_marked' => array('BOOL', 0),

+ 'pm_forwarded' => array('BOOL', 0),

+ 'folder_id' => array('INT:11', 0),

+ ),

+ 'KEYS' => array(

+ 'msg_id' => array('INDEX', 'msg_id'),

+ 'author_id' => array('INDEX', 'author_id'),

+ 'usr_flder_id' => array('INDEX', array('user_id', 'folder_id')),

+ ),

+ );

+

+ $schema_data['phpbb_profile_fields'] = array(

+ 'COLUMNS' => array(

+ 'field_id' => array('UINT', NULL, 'auto_increment'),

+ 'field_name' => array('VCHAR_UNI', ''),

+ 'field_type' => array('TINT:4', 0),

+ 'field_ident' => array('VCHAR:20', ''),

+ 'field_length' => array('VCHAR:20', ''),

+ 'field_minlen' => array('VCHAR', ''),

+ 'field_maxlen' => array('VCHAR', ''),

+ 'field_novalue' => array('VCHAR_UNI', ''),

+ 'field_default_value' => array('VCHAR_UNI', ''),

+ 'field_validation' => array('VCHAR_UNI:20', ''),

+ 'field_required' => array('BOOL', 0),

+ 'field_show_on_reg' => array('BOOL', 0),

+ 'field_hide' => array('BOOL', 0),

+ 'field_no_view' => array('BOOL', 0),

+ 'field_active' => array('BOOL', 0),

+ 'field_order' => array('UINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'field_id',

+ 'KEYS' => array(

+ 'fld_type' => array('INDEX', 'field_type'),

+ 'fld_ordr' => array('INDEX', 'field_order'),

+ ),

+ );

+

+ $schema_data['phpbb_profile_fields_data'] = array(

+ 'COLUMNS' => array(

+ 'user_id' => array('UINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'user_id',

+ );

+

+ $schema_data['phpbb_profile_fields_lang'] = array(

+ 'COLUMNS' => array(

+ 'field_id' => array('UINT', 0),

+ 'lang_id' => array('UINT', 0),

+ 'option_id' => array('UINT', 0),

+ 'field_type' => array('TINT:4', 0),

+ 'lang_value' => array('VCHAR_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => array('field_id', 'lang_id', 'option_id'),

+ );

+

+ $schema_data['phpbb_profile_lang'] = array(

+ 'COLUMNS' => array(

+ 'field_id' => array('UINT', 0),

+ 'lang_id' => array('UINT', 0),

+ 'lang_name' => array('VCHAR_UNI', ''),

+ 'lang_explain' => array('TEXT_UNI', ''),

+ 'lang_default_value' => array('VCHAR_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => array('field_id', 'lang_id'),

+ );

+

+ $schema_data['phpbb_ranks'] = array(

+ 'COLUMNS' => array(

+ 'rank_id' => array('UINT', NULL, 'auto_increment'),

+ 'rank_title' => array('VCHAR_UNI', ''),

+ 'rank_min' => array('UINT', 0),

+ 'rank_special' => array('BOOL', 0),

+ 'rank_image' => array('VCHAR', ''),

+ ),

+ 'PRIMARY_KEY' => 'rank_id',

+ );

+

+ $schema_data['phpbb_reports'] = array(

+ 'COLUMNS' => array(

+ 'report_id' => array('UINT', NULL, 'auto_increment'),

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

+ 'post_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ 'user_notify' => array('BOOL', 0),

+ 'report_closed' => array('BOOL', 0),

+ 'report_time' => array('TIMESTAMP', 0),

+ 'report_text' => array('MTEXT_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'report_id',

+ );

+

+ $schema_data['phpbb_reports_reasons'] = array(

+ 'COLUMNS' => array(

+ 'reason_id' => array('USINT', NULL, 'auto_increment'),

+ 'reason_title' => array('VCHAR_UNI', ''),

+ 'reason_description' => array('MTEXT_UNI', ''),

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

+ ),

+ 'PRIMARY_KEY' => 'reason_id',

+ );

+

+ $schema_data['phpbb_search_results'] = array(

+ 'COLUMNS' => array(

+ 'search_key' => array('VCHAR:32', ''),

+ 'search_time' => array('TIMESTAMP', 0),

+ 'search_keywords' => array('MTEXT_UNI', ''),

+ 'search_authors' => array('MTEXT', ''),

+ ),

+ 'PRIMARY_KEY' => 'search_key',

+ );

+

+ $schema_data['phpbb_search_wordlist'] = array(

+ 'COLUMNS' => array(

+ 'word_id' => array('UINT', NULL, 'auto_increment'),

+ 'word_text' => array('VCHAR_UNI', ''),

+ 'word_common' => array('BOOL', 0),

+ 'word_count' => array('UINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'word_id',

+ 'KEYS' => array(

+ 'wrd_txt' => array('UNIQUE', 'word_text'),

+ 'wrd_cnt' => array('INDEX', 'word_count'),

+ ),

+ );

+

+ $schema_data['phpbb_search_wordmatch'] = array(

+ 'COLUMNS' => array(

+ 'post_id' => array('UINT', 0),

+ 'word_id' => array('UINT', 0),

+ 'title_match' => array('BOOL', 0),

+ ),

+ 'KEYS' => array(

+ 'unq_mtch' => array('UNIQUE', array('word_id', 'post_id', 'title_match')),

+ 'word_id' => array('INDEX', 'word_id'),

+ 'post_id' => array('INDEX', 'post_id'),

+ ),

+ );

+

+ $schema_data['phpbb_sessions'] = array(

+ 'COLUMNS' => array(

+ 'session_id' => array('CHAR:32', ''),

+ 'session_user_id' => array('UINT', 0),

+ 'session_last_visit' => array('TIMESTAMP', 0),

+ 'session_start' => array('TIMESTAMP', 0),

+ 'session_time' => array('TIMESTAMP', 0),

+ 'session_ip' => array('VCHAR:40', ''),

+ 'session_browser' => array('VCHAR:150', ''),

+ 'session_forwarded_for' => array('VCHAR:255', ''),

+ 'session_page' => array('VCHAR_UNI', ''),

+ 'session_viewonline' => array('BOOL', 1),

+ 'session_autologin' => array('BOOL', 0),

+ 'session_admin' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => 'session_id',

+ 'KEYS' => array(

+ 'session_time' => array('INDEX', 'session_time'),

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

+ ),

+ );

+

+ $schema_data['phpbb_sessions_keys'] = array(

+ 'COLUMNS' => array(

+ 'key_id' => array('CHAR:32', ''),

+ 'user_id' => array('UINT', 0),

+ 'last_ip' => array('VCHAR:40', ''),

+ 'last_login' => array('TIMESTAMP', 0),

+ ),

+ 'PRIMARY_KEY' => array('key_id', 'user_id'),

+ 'KEYS' => array(

+ 'last_login' => array('INDEX', 'last_login'),

+ ),

+ );

+

+ $schema_data['phpbb_sitelist'] = array(

+ 'COLUMNS' => array(

+ 'site_id' => array('UINT', NULL, 'auto_increment'),

+ 'site_ip' => array('VCHAR:40', ''),

+ 'site_hostname' => array('VCHAR', ''),

+ 'ip_exclude' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => 'site_id',

+ );

+

+ $schema_data['phpbb_smilies'] = array(

+ 'COLUMNS' => array(

+ 'smiley_id' => array('UINT', NULL, 'auto_increment'),

+ // We may want to set 'code' to VCHAR:50 or check if unicode support is possible... at the moment only ASCII characters are allowed.

+ 'code' => array('VCHAR_UNI:50', ''),

+ 'emotion' => array('VCHAR_UNI:50', ''),

+ 'smiley_url' => array('VCHAR:50', ''),

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

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

+ 'smiley_order' => array('UINT', 0),

+ 'display_on_posting'=> array('BOOL', 1),

+ ),

+ 'PRIMARY_KEY' => 'smiley_id',

+ 'KEYS' => array(

+ 'display_on_post' => array('INDEX', 'display_on_posting'),

+ ),

+ );

+

+ $schema_data['phpbb_styles'] = array(

+ 'COLUMNS' => array(

+ 'style_id' => array('USINT', NULL, 'auto_increment'),

+ 'style_name' => array('VCHAR_UNI:255', ''),

+ 'style_copyright' => array('VCHAR_UNI', ''),

+ 'style_active' => array('BOOL', 1),

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

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

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

+ ),

+ 'PRIMARY_KEY' => 'style_id',

+ 'KEYS' => array(

+ 'style_name' => array('UNIQUE', 'style_name'),

+ 'template_id' => array('INDEX', 'template_id'),

+ 'theme_id' => array('INDEX', 'theme_id'),

+ 'imageset_id' => array('INDEX', 'imageset_id'),

+ ),

+ );

+

+ $schema_data['phpbb_styles_template'] = array(

+ 'COLUMNS' => array(

+ 'template_id' => array('USINT', NULL, 'auto_increment'),

+ 'template_name' => array('VCHAR_UNI:255', ''),

+ 'template_copyright' => array('VCHAR_UNI', ''),

+ 'template_path' => array('VCHAR:100', ''),

+ 'bbcode_bitfield' => array('VCHAR:255', 'kNg='),

+ 'template_storedb' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => 'template_id',

+ 'KEYS' => array(

+ 'tmplte_nm' => array('UNIQUE', 'template_name'),

+ ),

+ );

+

+ $schema_data['phpbb_styles_template_data'] = array(

+ 'COLUMNS' => array(

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

+ 'template_filename' => array('VCHAR:100', ''),

+ 'template_included' => array('TEXT', ''),

+ 'template_mtime' => array('TIMESTAMP', 0),

+ 'template_data' => array('MTEXT_UNI', ''),

+ ),

+ 'KEYS' => array(

+ 'tid' => array('INDEX', 'template_id'),

+ 'tfn' => array('INDEX', 'template_filename'),

+ ),

+ );

+

+ $schema_data['phpbb_styles_theme'] = array(

+ 'COLUMNS' => array(

+ 'theme_id' => array('USINT', NULL, 'auto_increment'),

+ 'theme_name' => array('VCHAR_UNI:255', ''),

+ 'theme_copyright' => array('VCHAR_UNI', ''),

+ 'theme_path' => array('VCHAR:100', ''),

+ 'theme_storedb' => array('BOOL', 0),

+ 'theme_mtime' => array('TIMESTAMP', 0),

+ 'theme_data' => array('MTEXT_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'theme_id',

+ 'KEYS' => array(

+ 'theme_name' => array('UNIQUE', 'theme_name'),

+ ),

+ );

+

+ $schema_data['phpbb_styles_imageset'] = array(

+ 'COLUMNS' => array(

+ 'imageset_id' => array('USINT', NULL, 'auto_increment'),

+ 'imageset_name' => array('VCHAR_UNI:255', ''),

+ 'imageset_copyright' => array('VCHAR_UNI', ''),

+ 'imageset_path' => array('VCHAR:100', ''),

+ ),

+ 'PRIMARY_KEY' => 'imageset_id',

+ 'KEYS' => array(

+ 'imgset_nm' => array('UNIQUE', 'imageset_name'),

+ ),

+ );

+

+ $schema_data['phpbb_styles_imageset_data'] = array(

+ 'COLUMNS' => array(

+ 'image_id' => array('USINT', NULL, 'auto_increment'),

+ 'image_name' => array('VCHAR:200', ''),

+ 'image_filename' => array('VCHAR:200', ''),

+ 'image_lang' => array('VCHAR:30', ''),

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

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

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

+ ),

+ 'PRIMARY_KEY' => 'image_id',

+ 'KEYS' => array(

+ 'i_d' => array('INDEX', 'imageset_id'),

+ ),

+ );

+

+ $schema_data['phpbb_topics'] = array(

+ 'COLUMNS' => array(

+ 'topic_id' => array('UINT', NULL, 'auto_increment'),

+ 'forum_id' => array('UINT', 0),

+ 'icon_id' => array('UINT', 0),

+ 'topic_attachment' => array('BOOL', 0),

+ 'topic_approved' => array('BOOL', 1),

+ 'topic_reported' => array('BOOL', 0),

+ 'topic_title' => array('XSTEXT_UNI', '', 'true_sort'),

+ 'topic_poster' => array('UINT', 0),

+ 'topic_time' => array('TIMESTAMP', 0),

+ 'topic_time_limit' => array('TIMESTAMP', 0),

+ 'topic_views' => array('UINT', 0),

+ 'topic_replies' => array('UINT', 0),

+ 'topic_replies_real' => array('UINT', 0),

+ 'topic_status' => array('TINT:3', 0),

+ 'topic_type' => array('TINT:3', 0),

+ 'topic_first_post_id' => array('UINT', 0),

+ 'topic_first_poster_name' => array('VCHAR_UNI', ''),

+ 'topic_first_poster_colour' => array('VCHAR:6', ''),

+ 'topic_last_post_id' => array('UINT', 0),

+ 'topic_last_poster_id' => array('UINT', 0),

+ 'topic_last_poster_name' => array('VCHAR_UNI', ''),

+ 'topic_last_poster_colour' => array('VCHAR:6', ''),

+ 'topic_last_post_subject' => array('XSTEXT_UNI', ''),

+ 'topic_last_post_time' => array('TIMESTAMP', 0),

+ 'topic_last_view_time' => array('TIMESTAMP', 0),

+ 'topic_moved_id' => array('UINT', 0),

+ 'topic_bumped' => array('BOOL', 0),

+ 'topic_bumper' => array('UINT', 0),

+ 'poll_title' => array('STEXT_UNI', ''),

+ 'poll_start' => array('TIMESTAMP', 0),

+ 'poll_length' => array('TIMESTAMP', 0),

+ 'poll_max_options' => array('TINT:4', 1),

+ 'poll_last_vote' => array('TIMESTAMP', 0),

+ 'poll_vote_change' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => 'topic_id',

+ 'KEYS' => array(

+ 'forum_id' => array('INDEX', 'forum_id'),

+ 'forum_id_type' => array('INDEX', array('forum_id', 'topic_type')),

+ 'last_post_time' => array('INDEX', 'topic_last_post_time'),

+ 'topic_approved' => array('INDEX', 'topic_approved'),

+ 'forum_appr_last' => array('INDEX', array('forum_id', 'topic_approved', 'topic_last_post_id')),

+ 'fid_time_moved' => array('INDEX', array('forum_id', 'topic_last_post_time', 'topic_moved_id')),

+ ),

+ );

+

+ $schema_data['phpbb_topics_track'] = array(

+ 'COLUMNS' => array(

+ 'user_id' => array('UINT', 0),

+ 'topic_id' => array('UINT', 0),

+ 'forum_id' => array('UINT', 0),

+ 'mark_time' => array('TIMESTAMP', 0),

+ ),

+ 'PRIMARY_KEY' => array('user_id', 'topic_id'),

+ 'KEYS' => array(

+ 'forum_id' => array('INDEX', 'forum_id'),

+ ),

+ );

+

+ $schema_data['phpbb_topics_posted'] = array(

+ 'COLUMNS' => array(

+ 'user_id' => array('UINT', 0),

+ 'topic_id' => array('UINT', 0),

+ 'topic_posted' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => array('user_id', 'topic_id'),

+ );

+

+ $schema_data['phpbb_topics_watch'] = array(

+ 'COLUMNS' => array(

+ 'topic_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ 'notify_status' => array('BOOL', 0),

+ ),

+ 'KEYS' => array(

+ 'topic_id' => array('INDEX', 'topic_id'),

+ 'user_id' => array('INDEX', 'user_id'),

+ 'notify_stat' => array('INDEX', 'notify_status'),

+ ),

+ );

+

+ $schema_data['phpbb_user_group'] = array(

+ 'COLUMNS' => array(

+ 'group_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ 'group_leader' => array('BOOL', 0),

+ 'user_pending' => array('BOOL', 1),

+ ),

+ 'KEYS' => array(

+ 'group_id' => array('INDEX', 'group_id'),

+ 'user_id' => array('INDEX', 'user_id'),

+ 'group_leader' => array('INDEX', 'group_leader'),

+ ),

+ );

+

+ $schema_data['phpbb_users'] = array(

+ 'COLUMNS' => array(

+ 'user_id' => array('UINT', NULL, 'auto_increment'),

+ 'user_type' => array('TINT:2', 0),

+ 'group_id' => array('UINT', 3),

+ 'user_permissions' => array('MTEXT', ''),

+ 'user_perm_from' => array('UINT', 0),

+ 'user_ip' => array('VCHAR:40', ''),

+ 'user_regdate' => array('TIMESTAMP', 0),

+ 'username' => array('VCHAR_CI', ''),

+ 'username_clean' => array('VCHAR_CI', ''),

+ 'user_password' => array('VCHAR_UNI:40', ''),

+ 'user_passchg' => array('TIMESTAMP', 0),

+ 'user_pass_convert' => array('BOOL', 0),

+ 'user_email' => array('VCHAR_UNI:100', ''),

+ 'user_email_hash' => array('BINT', 0),

+ 'user_birthday' => array('VCHAR:10', ''),

+ 'user_lastvisit' => array('TIMESTAMP', 0),

+ 'user_lastmark' => array('TIMESTAMP', 0),

+ 'user_lastpost_time' => array('TIMESTAMP', 0),

+ 'user_lastpage' => array('VCHAR_UNI:200', ''),

+ 'user_last_confirm_key' => array('VCHAR:10', ''),

+ 'user_last_search' => array('TIMESTAMP', 0),

+ 'user_warnings' => array('TINT:4', 0),

+ 'user_last_warning' => array('TIMESTAMP', 0),

+ 'user_login_attempts' => array('TINT:4', 0),

+ 'user_inactive_reason' => array('TINT:2', 0),

+ 'user_inactive_time' => array('TIMESTAMP', 0),

+ 'user_posts' => array('UINT', 0),

+ 'user_lang' => array('VCHAR:30', ''),

+ 'user_timezone' => array('DECIMAL', 0),

+ 'user_dst' => array('BOOL', 0),

+ 'user_dateformat' => array('VCHAR_UNI:30', 'd M Y H:i'),

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

+ 'user_rank' => array('UINT', 0),

+ 'user_colour' => array('VCHAR:6', ''),

+ 'user_new_privmsg' => array('TINT:4', 0),

+ 'user_unread_privmsg' => array('TINT:4', 0),

+ 'user_last_privmsg' => array('TIMESTAMP', 0),

+ 'user_message_rules' => array('BOOL', 0),

+ 'user_full_folder' => array('INT:11', -3),

+ 'user_emailtime' => array('TIMESTAMP', 0),

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

+ 'user_topic_sortby_type' => array('VCHAR:1', 't'),

+ 'user_topic_sortby_dir' => array('VCHAR:1', 'd'),

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

+ 'user_post_sortby_type' => array('VCHAR:1', 't'),

+ 'user_post_sortby_dir' => array('VCHAR:1', 'a'),

+ 'user_notify' => array('BOOL', 0),

+ 'user_notify_pm' => array('BOOL', 1),

+ 'user_notify_type' => array('TINT:4', 0),

+ 'user_allow_pm' => array('BOOL', 1),

+ 'user_allow_viewonline' => array('BOOL', 1),

+ 'user_allow_viewemail' => array('BOOL', 1),

+ 'user_allow_massemail' => array('BOOL', 1),

+ 'user_options' => array('UINT:11', 895),

+ 'user_avatar' => array('VCHAR', ''),

+ 'user_avatar_type' => array('TINT:2', 0),

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

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

+ 'user_sig' => array('MTEXT_UNI', ''),

+ 'user_sig_bbcode_uid' => array('VCHAR:8', ''),

+ 'user_sig_bbcode_bitfield' => array('VCHAR:255', ''),

+ 'user_from' => array('VCHAR_UNI:100', ''),

+ 'user_icq' => array('VCHAR:15', ''),

+ 'user_aim' => array('VCHAR_UNI', ''),

+ 'user_yim' => array('VCHAR_UNI', ''),

+ 'user_msnm' => array('VCHAR_UNI', ''),

+ 'user_jabber' => array('VCHAR_UNI', ''),

+ 'user_website' => array('VCHAR_UNI:200', ''),

+ 'user_occ' => array('TEXT_UNI', ''),

+ 'user_interests' => array('TEXT_UNI', ''),

+ 'user_actkey' => array('VCHAR:32', ''),

+ 'user_newpasswd' => array('VCHAR_UNI:40', ''),

+ 'user_form_salt' => array('VCHAR_UNI:32', ''),

+

+ ),

+ 'PRIMARY_KEY' => 'user_id',

+ 'KEYS' => array(

+ 'user_birthday' => array('INDEX', 'user_birthday'),

+ 'user_email_hash' => array('INDEX', 'user_email_hash'),

+ 'user_type' => array('INDEX', 'user_type'),

+ 'username_clean' => array('UNIQUE', 'username_clean'),

+ ),

+ );

+

+ $schema_data['phpbb_warnings'] = array(

+ 'COLUMNS' => array(

+ 'warning_id' => array('UINT', NULL, 'auto_increment'),

+ 'user_id' => array('UINT', 0),

+ 'post_id' => array('UINT', 0),

+ 'log_id' => array('UINT', 0),

+ 'warning_time' => array('TIMESTAMP', 0),

+ ),

+ 'PRIMARY_KEY' => 'warning_id',

+ );

+

+ $schema_data['phpbb_words'] = array(

+ 'COLUMNS' => array(

+ 'word_id' => array('UINT', NULL, 'auto_increment'),

+ 'word' => array('VCHAR_UNI', ''),

+ 'replacement' => array('VCHAR_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'word_id',

+ );

+

+ $schema_data['phpbb_zebra'] = array(

+ 'COLUMNS' => array(

+ 'user_id' => array('UINT', 0),

+ 'zebra_id' => array('UINT', 0),

+ 'friend' => array('BOOL', 0),

+ 'foe' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => array('user_id', 'zebra_id'),

+ );

+

+ return $schema_data;

+}

+

+?> \ No newline at end of file

+<?php

+/**

+* Rebuild BOTS

+*

+* You should make a backup from your whole database. Things can and will go wrong.

+* This will only work if no BOTs were added.

+*

+*/

+die("Please read the first lines of this script for instructions on how to enable it");

+

+set_time_limit(0);

+

+define('IN_PHPBB', true);

+$phpbb_root_path = './../';

+$phpEx = substr(strrchr(__FILE__, '.'), 1);

+include($phpbb_root_path . 'common.'.$phpEx);

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

+

+

+// Start session management

+$user->session_begin();

+$auth->acl($user->data);

+$user->setup();

+

+$bots = array(

+ 'AdsBot [Google]' => array('AdsBot-Google', ''),

+ 'Alexa [Bot]' => array('ia_archiver', ''),

+ 'Alta Vista [Bot]' => array('Scooter/', ''),

+ 'Ask Jeeves [Bot]' => array('Ask Jeeves', ''),

+ 'Baidu [Spider]' => array('Baiduspider+(', ''),

+ 'Exabot [Bot]' => array('Exabot/', ''),

+ 'FAST Enterprise [Crawler]' => array('FAST Enterprise Crawler', ''),

+ 'FAST WebCrawler [Crawler]' => array('FAST-WebCrawler/', ''),

+ 'Francis [Bot]' => array('http://www.neomo.de/', ''),

+ 'Gigabot [Bot]' => array('Gigabot/', ''),

+ 'Google Adsense [Bot]' => array('Mediapartners-Google', ''),

+ 'Google Desktop' => array('Google Desktop', ''),

+ 'Google Feedfetcher' => array('Feedfetcher-Google', ''),

+ 'Google [Bot]' => array('Googlebot', ''),

+ 'Heise IT-Markt [Crawler]' => array('heise-IT-Markt-Crawler', ''),

+ 'Heritrix [Crawler]' => array('heritrix/1.', ''),

+ 'IBM Research [Bot]' => array('ibm.com/cs/crawler', ''),

+ 'ICCrawler - ICjobs' => array('ICCrawler - ICjobs', ''),

+ 'ichiro [Crawler]' => array('ichiro/2', ''),

+ 'Majestic-12 [Bot]' => array('MJ12bot/', ''),

+ 'Metager [Bot]' => array('MetagerBot/', ''),

+ 'MSN NewsBlogs' => array('msnbot-NewsBlogs/', ''),

+ 'MSN [Bot]' => array('msnbot/', ''),

+ 'MSNbot Media' => array('msnbot-media/', ''),

+ 'NG-Search [Bot]' => array('NG-Search/', ''),

+ 'Nutch [Bot]' => array('http://lucene.apache.org/nutch/', ''),

+ 'Nutch/CVS [Bot]' => array('NutchCVS/', ''),

+ 'OmniExplorer [Bot]' => array('OmniExplorer_Bot/', ''),

+ 'Online link [Validator]' => array('online link validator', ''),

+ 'psbot [Picsearch]' => array('psbot/0', ''),

+ 'Seekport [Bot]' => array('Seekbot/', ''),

+ 'Sensis [Crawler]' => array('Sensis Web Crawler', ''),

+ 'SEO Crawler' => array('SEO search Crawler/', ''),

+ 'Seoma [Crawler]' => array('Seoma [SEO Crawler]', ''),

+ 'SEOSearch [Crawler]' => array('SEOsearch/', ''),

+ 'Snappy [Bot]' => array('Snappy/1.1 ( http://www.urltrends.com/ )', ''),

+ 'Steeler [Crawler]' => array('http://www.tkl.iis.u-tokyo.ac.jp/~crawler/', ''),

+ 'Synoo [Bot]' => array('SynooBot/', ''),

+ 'Telekom [Bot]' => array('crawleradmin.t-info@telekom.de', ''),

+ 'TurnitinBot [Bot]' => array('TurnitinBot/', ''),

+ 'Voyager [Bot]' => array('voyager/1.0', ''),

+ 'W3 [Sitesearch]' => array('W3 SiteSearch Crawler', ''),

+ 'W3C [Linkcheck]' => array('W3C-checklink/', ''),

+ 'W3C [Validator]' => array('W3C_*Validator', ''),

+ 'WiseNut [Bot]' => array('http://www.WISEnutbot.com', ''),

+ 'YaCy [Bot]' => array('yacybot', ''),

+ 'Yahoo MMCrawler [Bot]' => array('Yahoo-MMCrawler/', ''),

+ 'Yahoo Slurp [Bot]' => array('Yahoo! DE Slurp', ''),

+ 'Yahoo [Bot]' => array('Yahoo! Slurp', ''),

+ 'YahooSeeker [Bot]' => array('YahooSeeker/', ''),

+);

+

+$bot_ids = array();

+user_get_id_name($bot_ids, array_keys($bots), USER_IGNORE);

+foreach($bot_ids as $bot)

+{

+ user_delete('remove', $bot);

+}

+// Done

+add_bots($bots);

+echo 'done';

+

+

+/**

+* Add the search bots into the database

+* This code should be used in execute_last if the source database did not have bots

+* If you are converting bots this function should not be called

+* @todo We might want to look at sharing the bot list between the install code and this code for consistency

+*/

+function add_bots($bots)

+{

+ global $db, $config;

+

+ $sql = 'SELECT group_id FROM ' . GROUPS_TABLE . " WHERE group_name = 'BOTS'";

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

+ $group_id = (int) $db->sql_fetchfield('group_id', false, $result);

+ $db->sql_freeresult($result);

+ $db->sql_query('TRUNCATE TABLE ' . BOTS_TABLE);

+

+ if (!$group_id)

+ {

+ add_default_groups();

+

+ $sql = 'SELECT group_id FROM ' . GROUPS_TABLE . " WHERE group_name = 'BOTS'";

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

+ $group_id = (int) $db->sql_fetchfield('group_id', false, $result);

+ $db->sql_freeresult($result);

+

+ }

+

+

+

+

+ foreach ($bots as $bot_name => $bot_ary)

+ {

+ $user_row = array(

+ 'user_type' => USER_IGNORE,

+ 'group_id' => $group_id,

+ 'username' => $bot_name,

+ 'user_regdate' => time(),

+ 'user_password' => '',

+ 'user_colour' => '9E8DA7',

+ 'user_email' => '',

+ 'user_lang' => $config['default_lang'],

+ 'user_style' => 1,

+ 'user_timezone' => 0,

+ 'user_allow_massemail' => 0,

+ );

+

+ $user_id = user_add($user_row);

+

+ if ($user_id)

+ {

+ $sql = 'INSERT INTO ' . BOTS_TABLE . ' ' . $db->sql_build_array('INSERT', array(

+ 'bot_active' => 1,

+ 'bot_name' => $bot_name,

+ 'user_id' => $user_id,

+ 'bot_agent' => $bot_ary[0],

+ 'bot_ip' => $bot_ary[1])

+ );

+ $db->sql_query($sql);

+ }

+ }

+}

+

+?> \ No newline at end of file

+ <li><a href="#v30rc7">Changes since RC-7</a></li>

+ <a name="v30rc7"></a><h3>1.i. Changes since 3.0.RC7</h3>

+

+ <ul>

+ <li>[Fix] Fixed MSSQL related bug in the update system</li>

+ <li>[Fix] Display &quot;Return to&quot; links on unwritable forums (Bug #14824)</li>

+ <li>[Fix] Mitigating different realpath() handling between PHP versions (fixing confirm box redirects)</li>

+ <li>[Fix] Fix signature editing - ability to remove signature (Bug #14820)</li>

+ <li>[Fix] Send correct activation key by forcing reactivation for inactive user (Bug #14819)</li>

+ <li>[Fix] Adding correct IP for private messages sent by issuing warnings (Bug #14781)</li>

+ <li>[Fix] Open private message notification (Bug #14773)</li>

+ <li>[Fix] Fixing false new private message indicator (Bug #14627)</li>

+ <li>[Fix] Let newly activated passwords work if users were converted (Bug #14787)</li>

+ <li>[Fix] Quote bbcode fixes. Letting parse quote=&quot;[&quot; and re-allowing whitelisted bbcodes within username portion (Bug #14770)</li>

+ <li>[Fix] Allow alternative text for styled buttons if images turned off, but CSS staying on</li>

+ <li>[Sec] Fix bbcode helpline display for custom bbcodes - this requires style changes for any custom style (Bug #14850)</li>

+ <li>[Fix] Correctly count announcements when filtering forums by date (Bug #14877)</li>

+ <li>[Fix] Allow charset names containing underscores or spaces</li>

+ <li>[Fix] Don't allow previous/next links for non-existing topics (Bug #15039)</li>

+ <li>[Change] Do not assign converted votes to the first option in a vote.</li>

+ <li>[Fix] Use correct RFC 2822 date format in emails (Bug #15042)</li>

+ <li>[Fix] Require founder status for some actions on founder-only groups (Bug #15119)</li>

+ <li>[Fix] Allow changing the &quot;now&quot; option of date CPFs (Bug #15111)</li>

+ <li>[Change] Some improvements to the caching of avatars</li>

+ <li>[Change] Set template recompilation to be disabled by default. All mod and style authors and all those who want to modify their styles should enabled it after installation.</li>

+ <li>[Change] Disable debug mode. All mod and style authors should enable DEBUG and DEBUG_EXTRA.</li>

+ <li>[Fix] Check error reporting level for all error level. This fixes a problem for hosts having manipulated the error handler. (Bug #14831)</li>

+ <li>[Feature] Constant PHPBB_DB_NEW_LINK introduced which can be used to force phpBB to create a new database connection instead of reusing an existing one if the dbms supports it (Bug #14927)</li>

+ <li>[Fix] Automatic URL parsing no longer allows dots in the schema but can parse URLs starting after a dot (Bug #15110)</li>

+ <li>[Fix] Dynamic width for birthday select boxes (Bug #15149)</li>

+ <li>[Fix] Recache Moderators when copying permissions. (Bug #15384)</li>

+ <li>[Fix] Propagate sort options in mcp_forums (Bug #15464)</li>

+ <li>[Change] Do not allow [size=0] bbcodes (font-size of 0)</li>

+ <li>[Fix] No duplication of active topics (Bug #15474)</li>

+ </ul>

+

+ <a name="v30rc6"></a><h3>1.ii. Changes since 3.0.RC6</h3>

+ <a name="v30rc5"></a><h3>1.iii. Changes since 3.0.RC5</h3>

+ <a name="v30rc4"></a><h3>1.iv. Changes since 3.0.RC4</h3>

+ <a name="v30rc3"></a><h3>1.v. Changes since 3.0.RC3</h3>

+ <a name="v30rc2"></a><h3>1.vi. Changes since 3.0.RC2</h3>

+ <a name="v30rc1"></a><h3>1.vii. Changes since 3.0.RC1</h3>

+ <p>The full package is normally meant for new installations only, but if you want to replace all source files this package comes in handy.</p>

+ <p>This package is meant for those wanting to only replace changed files from a previous version to the latest version. This package normally contains the changed files from up to five previous versions.</p>

+

+ <p>The patch file package is for those wanting to update through the patch application, and being compfortable with it.</p>

+

+ <p>The patch file is one solution for those with many Modifications (MODs) or other changes who do not want to re-add them back to all the changed files if they use the method explained above. To use this you will need command line access to a standard UNIX type <strong>patch</strong> application. If you do not have access to such an application but still want to use this update approach, we strongly recommend the <a href="update_auto">Automatic update package</a> explained below. It is also the preferred update method.</p>

+ <p>This update method is the preferred method for updating. This package allows detecting changed files automatically and merges changes if needed.</p>

+

+ <p>To perform the update, either follow the instructions from the <code>Administration Control Panel-&gt;System</code> Tab - this should point out that you are running an outdated version and will guide you through the update - or follow the instructions listed below.</p>

+ <li>Go to the <a href="http://www.phpbb.com/downloads/">downloads page</a> and download the latest update package listed there, matching your current version.</li>

+ <li>Updates from phpBB3 RC1 to the latest version</li>

+ <li>Conversions from phpBB 2.0.x to the latest version</li>

+ <li>New installations of phpBB3 - always only the latest released version</li>

+ <p>Installation of these packages is straightforward, simply download the required language pack and unarchive it into the <samp>languages/</samp> folder. Please ensure you retain the directory structure when doing this! Once uploaded go to the <code>Admin-&gt;System-&gt;Language Packs</code> and install the now appeared new language pack. To install the style imageset you should download the imageset for your language and unarchive the file/s into the relevant imageset directory (styles/prosilver/imageset or styles/subsilver2/imageset), again you must retain the directory structure. Once installed the imageset will become immediately available.</p>

+ <p>If your language is not available please visit our forums where you will find a topic listing translations currently available or in preparation. This topic also gives you information should you wish to volunteer to translate a language not currently listed.</p>

+ <p><strong>Please note</strong> that if you create your own style or modify existing ones, please remember to enable the &quot;Recompile stale style components&quot; setting within the <code>Admin-&gt;General-&gt;Load Settings</code> screen. This setting allows the cache to detect changes made to the style and automatically refresh it. If this setting is disabled, you will not see your changes taking effect.</p>

+

+ <li>Smilies placed directly after bbcode tags will not get parsed. Smilies always need to be separated by spaces.</li>

+ <li><code>/includes/db/dbal.php</code><br />Base DBAL class, defining the overall framework</li>

+ <h4>Exiting</h4>

+

+ <p>Your page should either call <code>page_footer()</code> in the end to trigger output through the template engine and terminate the script, or alternatively at least call the <code>exit_handler()</code>. That call is necessary because it provides a method for external applications embedding phpBB to be called at the end of the script.</p>

+

+ {S_FORM_TOKEN}

+PHPBB_DB_NEW_LINK (overwrite new_link parameter for sql_connect)

+

+ // worst-case default

+ $browser = (!empty($_SERVER['HTTP_USER_AGENT'])) ? htmlspecialchars((string) $_SERVER['HTTP_USER_AGENT']) : 'msie 6.0';

+

+ $stamp = (int) substr(stristr($filename, '_'), 1);

+ $filename = (int) $filename;

+

+ // let's see if we have to send the file at all

+ $last_load = isset($_SERVER['HTTP_IF_MODIFIED_SINCE']) ? strtotime(trim($_SERVER['HTTP_IF_MODIFIED_SINCE'])) : false;

+ if (strpos(strtolower($browser), 'msie 6.0') === false)

+ {

+ if ($last_load !== false && $last_load <= $stamp)

+ {

+ header('Not Modified', true, 304);

+ // seems that we need those too ... browsers

+ header('Pragma: public');

+ header('Expires: ' . gmdate('D, d M Y H:i:s \G\M\T', time() + 31536000));

+ exit();

+ }

+ else

+ {

+ header('Last-Modified: ' . gmdate('D, d M Y H:i:s', $stamp) . ' GMT');

+ }

+ }

+

+ send_avatar_to_browser(($avatar_group ? 'g' : '') . $filename . '.' . $ext, $browser);

+function send_avatar_to_browser($file, $browser)

+ if ((@file_exists($file_path) && @is_readable($file_path)) && !headers_sent())

+<html>

+<head>

+<title></title>

+<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

+</head>

+

+<body bgcolor="#FFFFFF" text="#000000">

+

+</body>

+</html>

+

+ $this->vars = array();

+ $this->var_expires = array();

+ $this->sql_rowset = array();

+ $this->sql_row_pointer = array();

+ $this->vars = array();

+ $this->var_expires = array();

+ $this->sql_rowset = array();

+ $this->sql_row_pointer = array();

+

+ $errors[] = $user->lang['FORM_INVALID'];

+ cache_moderators();

+ if ($dir = @opendir($phpbb_root_path . $img_path))

+ while (($file = readdir($dir)) !== false)

+ if (is_file($phpbb_root_path . $img_path . '/' . $file) && preg_match('#\.pak$#i', $file))

+ {

+ $_paks[] = $file;

+ }

+ closedir($dir);

+ 'start' => $start,

+ include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);

+ $start = view_inactive_users($inactive, $inactive_count, $config['topics_per_page'], $start, $sql_where, $sql_sort);

+

+ 'U_ACTION' => $this->u_action . '&amp;start=' . $start,

+ cache_moderators();

+ closedir($avatar_dir);

+ $always_now = request_var('always_now', -1);

+

+ if ($always_now == 1 || ($always_now === -1 && $var == 'now'))

+ closedir($dp);

+ if (!file_exists("{$phpbb_root_path}cache/$filename"))

+ {

+ continue;

+ }

+

+ if ($dh = @opendir($imageset_root))

+ while (($fname = readdir($dh)) !== false)

+ if ($fname[0] != '.' && $fname != 'CVS' && is_dir("$imageset_root$fname"))

+ {

+ $files[key($files)]['exclude'] .= ',' . $fname . '/imageset.cfg';

+ }

+ closedir($dh);

+ $info = get_remote_file('www.phpbb.com', '/updatecheck', ((defined('PHPBB_QA')) ? '30x_qa.txt' : '30x.txt'), $errstr, $errno);

+ $submit = (isset($_POST['update']) && !isset($_POST['cancel'])) ? true : false;

+ else

+ {

+ // Grabbing the last confirm key - we only send a reminder

+ $sql = 'SELECT user_actkey

+ FROM ' . USERS_TABLE . '

+ WHERE user_id = ' . $user_id;

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

+ $user_actkey = (string) $db->sql_fetchfield('user_actkey');

+ $db->sql_freeresult($result);

+ }

+ 'user_password' => phpbb_hash($data['new_password']),

+ 'user_passchg' => time(),

+ 'user_pass_convert' => 0,

+

+ if ($group_id)

+ {

+ // Check the founder only entry for this group to make sure everything is well

+ $sql = 'SELECT group_founder_manage

+ FROM ' . GROUPS_TABLE . '

+ WHERE group_id = ' . $group_id;

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

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

+ $db->sql_freeresult($result);

+

+ if ($user->data['user_type'] != USER_FOUNDER && $founder_manage)

+ {

+ trigger_error($user->lang['NOT_ALLOWED_MANAGE_GROUP'] . adm_back_link($this->u_action . '&amp;u=' . $user_id), E_USER_WARNING);

+ }

+ }

+ else

+ {

+ $founder_manage = 0;

+ }

+

+ if (!$group_id)

+ {

+ trigger_error($user->lang['NO_GROUP'] . adm_back_link($this->u_action . '&amp;u=' . $user_id), E_USER_WARNING);

+ }

+* PHPBB_DB_NEW_LINK

+// QA-related

+// define('PHPBB_QA', 1);

+

+define('VOTE_CONVERTED', 9999);

+ LEFT JOIN sysobjects o ON c.id = o.id

+ $sql_default = " {$column_type} ";

+ // For adding columns we need the default definition

+ if (!is_null($column_data[1]))

+ $sql_default .= 'DEFAULT (' . $column_data[1] . ') ';

+ $sql_default .= 'DEFAULT (' . ((is_numeric($column_data[1])) ? $column_data[1] : "'{$column_data[1]}'") . ') ';

+ }

+ $sql_default .= 'NOT NULL';

+

+ $return_array['column_type_sql_default'] = $sql_default;

+ $statements[] = 'ALTER TABLE [' . $table_name . '] ADD [' . $column_name . '] ' . $column_data['column_type_sql_default'];

+$sql_db = (!empty($dbms)) ? 'dbal_' . basename($dbms) : 'dbal';

+ $default = current($default);

+ list($sub_key_type, $sub_type) = each($default);

+

+ // Check for DIRECTORY_SEPARATOR at the end (and remove it!)

+ if (substr($resolved, -1) == DIRECTORY_SEPARATOR)

+ {

+ return substr($resolved, 0, -1);

+ }

+

+ $path = realpath($path);

+

+ // Check for DIRECTORY_SEPARATOR at the end (and remove it!)

+ if (substr($path, -1) == DIRECTORY_SEPARATOR)

+ {

+ return substr($path, 0, -1);

+ }

+

+ return $path;

+ // we enforce a minimum value of half a minute here.

+ $timespan = max(30, $config['form_token_lifetime']);

+ $scheme = ($mode == 'url') ? '[a-z\d+\-.]' : '[a-z\d+]'; // avoid automatic parsing of "word" in "last word.http://..."

+ return "[a-z]$scheme*:/{2}(?:(?:[a-z0-9\-._~!$&'($inline*+,;=:@|]+|%[\dA-F]{2})+|[0-9.]+|\[[a-z0-9.]+:[a-z0-9.]+:[a-z0-9.:]+\])(?::\d*)?(?:/(?:[a-z0-9\-._~!$&'($inline*+,;=:@|]+|%[\dA-F]{2})*)*(?:\?(?:[a-z0-9\-._~!$&'($inline*+,;=:@/?|]+|%[\dA-F]{2})*)?(?:\#(?:[a-z0-9\-._~!$&'($inline*+,;=:@/?|]+|%[\dA-F]{2})*)?";

+ // Do not display notices if we suppress them via @

+ if (error_reporting() == 0)

+ {

+ return;

+ }

+

+ if (($errno & ((defined('DEBUG')) ? E_ALL : error_reporting())) == 0)

+ $sql = 'SELECT COUNT(user_id) AS user_count

+ FROM ' . USERS_TABLE . '

+ WHERE user_type = ' . USER_INACTIVE .

+ (($limit_days) ? " AND user_inactive_time >= $limit_days" : '');

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

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

+ $db->sql_freeresult($result);

+

+ if ($offset >= $user_count)

+ {

+ $offset = ($offset - $limit < 0) ? 0 : $offset - $limit;

+ }

+

+ return $offset;

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

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

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

+ $magic_url_match[] = '#(^|[\n\t (>.])(' . preg_quote($server_url, '#') . ')/(' . get_preg_expression('relative_url_inline') . ')#ie';

+ $magic_url_match[] = '#(^|[\n\t (>.])(' . get_preg_expression('url_inline') . ')#ie';

+ 'BBCODE_HELPLINE' => $row['bbcode_helpline'],

+ 'A_BBCODE_HELPLINE' => str_replace(array('&amp;', '&quot;', "'", '&lt;', '&gt;'), array('&', '"', "\'", '<', '>'), $row['bbcode_helpline']),

+ ));

+function connect_check_db($error_connect, &$error, $dbms_details, $table_prefix, $dbhost, $dbuser, $dbpasswd, $dbname, $dbport, $prefix_may_exist = false, $load_dbal = true, $unicode_check = true)

+ $dbms = $dbms_details['DRIVER'];

+

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

+ $sql_db = 'dbal_' . $dbms;

+ if ($dbms_details['DRIVER'] != 'sqlite' && $dbms_details['DRIVER'] != 'oracle' && $dbname === '')

+ if ($dbms_details['DRIVER'] == 'sqlite' && stripos(phpbb_realpath($dbhost), phpbb_realpath('../')) === 0)

+ switch ($dbms_details['DRIVER'])

+ switch ($dbms_details['DRIVER'])

+ trigger_error("Could not find email template file [ $tpl_file ]", E_USER_ERROR);

+ $headers[] = 'Date: ' . date('r', time());

+ include_once($phpbb_root_path . 'includes/functions_jabber.' . $phpEx);

+

+ include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);

+ $data['post_edit_reason'] = truncate_string($data['post_edit_reason'], 255, false);

+

+ $sql_data[POSTS_TABLE]['sql'] = array(

+* Update user PM count

+*/

+function update_pm_counts()

+{

+ global $user, $db;

+

+ // Update unread count

+ $sql = 'SELECT COUNT(msg_id) as num_messages

+ FROM ' . PRIVMSGS_TO_TABLE . '

+ WHERE pm_unread = 1

+ AND folder_id <> ' . PRIVMSGS_OUTBOX . '

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

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

+ $user->data['user_unread_privmsg'] = (int) $db->sql_fetchfield('num_messages');

+ $db->sql_freeresult($result);

+

+ // Update new pm count

+ $sql = 'SELECT COUNT(msg_id) as num_messages

+ FROM ' . PRIVMSGS_TO_TABLE . '

+ WHERE pm_new = 1

+ AND folder_id IN (' . PRIVMSGS_NO_BOX . ', ' . PRIVMSGS_HOLD_BOX . ')

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

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

+ $user->data['user_new_privmsg'] = (int) $db->sql_fetchfield('num_messages');

+ $db->sql_freeresult($result);

+

+ $db->sql_query('UPDATE ' . USERS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', array(

+ 'user_unread_privmsg' => (int) $user->data['user_unread_privmsg'],

+ 'user_new_privmsg' => (int) $user->data['user_new_privmsg'],

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

+

+ // Ok, here we need to repair something, other boxes than privmsgs_no_box and privmsgs_hold_box should not carry the pm_new flag.

+ if (!$user->data['user_new_privmsg'])

+ {

+ $sql = 'UPDATE ' . PRIVMSGS_TO_TABLE . '

+ SET pm_new = 0

+ WHERE pm_new = 1

+ AND folder_id NOT IN (' . PRIVMSGS_NO_BOX . ', ' . PRIVMSGS_HOLD_BOX . ')

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

+ $db->sql_query($sql);

+ }

+}

+

+/**

+ return array('not_moved' => 0, 'removed' => 0);

+ $num_removed = 0;

+ $folder_action = $message_removed = false;

+ $num_removed += sizeof($delete_ids);

+ $num_removed += sizeof($delete_ids);

+ // Update new/unread count

+ update_pm_counts();

+ // Now check how many messages got not moved...

+ $sql = 'SELECT COUNT(msg_id) as num_messages

+ FROM ' . PRIVMSGS_TO_TABLE . "

+ WHERE user_id = $user_id

+ AND folder_id = " . PRIVMSGS_HOLD_BOX;

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

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

+ $db->sql_freeresult($result);

+ return array('not_moved' => $num_not_moved, 'removed' => $num_removed);

+ $always_now = request_var('always_now', -1);

+ if ($always_now == -1)

+ {

+ $s_checked = ($this->vars['field_default_value'] == 'now') ? true : false;

+ }

+ else

+ {

+ $s_checked = ($always_now) ? true : false;

+ }

+ if ($user_row['user_avatar'] && $user_row['user_avatar_type'] == AVATAR_UPLOAD)

+ {

+ avatar_delete('user', $user_row);

+ }

+

+ global $db, $user, $auth, $cache;

+ $cache->destroy('sql', BANLIST_TABLE);

+

+ // There was nothing to ban/exclude. But destroying the cache because of the removal of stale bans.

+ $cache->destroy('sql', BANLIST_TABLE);

+

+ global $db, $user, $auth, $cache;

+ $cache->destroy('sql', BANLIST_TABLE);

+

+ if (!$dp)

+ {

+ return array($user->lang['NO_AVATAR_CATEGORY'] => array());

+ }

+

+ if ($dp2 = @opendir("$path/$file"))

+ while (($sub_file = readdir($dp2)) !== false)

+ if (preg_match('#^[^&\'"<>]+\.(?:gif|png|jpe?g)$#i', $sub_file))

+ $avatar_list[$file][$avatar_row_count][$avatar_col_count] = array(

+ 'file' => "$file/$sub_file",

+ 'filename' => $sub_file,

+ 'name' => ucfirst(str_replace('_', ' ', preg_replace('#^(.*)\..*$#', '\1', $sub_file))),

+ );

+ $avatar_col_count++;

+ if ($avatar_col_count == $items_per_column)

+ {

+ $avatar_row_count++;

+ $avatar_col_count = 0;

+ }

+ closedir($dp2);

+ $avatar_list = (isset($avatar_list[$category])) ? $avatar_list[$category] : array();

+ 'PAGINATION' => generate_pagination($url . "&amp;i=$id&amp;action=$action&amp;mode=$mode&amp;sd=$sort_dir&amp;sk=$sort_key&amp;st=$sort_days" . (($merge_select) ? $selected_ids : ''), $forum_topics, $topics_per_page, $start),

+ if (empty($post_list))

+ {

+ $total = 0;

+ }

+ }

+

+ if ($total)

+ {

+ foreach ($post_info as $post)

+ 'from_user_ip' => $user->ip,

+ // Do not allow size=0

+ if ($stx <= 0)

+ {

+ return '[size=' . $stx . ']' . $in . '[/size]';

+ }

+

+ * #3572 - [quote="[test]test"]test [ test[/quote] - (correct: parsed)

+ * #14667 - [quote]test[/quote] test ] and [ test [quote]test[/quote] (correct: parsed)

+ * #14770 - [quote="["]test[/quote] (correct: parsed)

+ * [quote="[i]test[/i]"]test[/quote] (correct: parsed)

+ * [quote="[quote]test[/quote]"]test[/quote] (correct: NOT parsed)

+ // To let the parser not catch tokens within quote_username quotes we encode them before we start this...

+ $in = preg_replace('#quote=&quot;(.*?)&quot;\]#ie', "'quote=&quot;' . str_replace(array('[', ']'), array('&#91;', '&#93;'), '\$1') . '&quot;]'", $in);

+

+ if (strtolower($buffer) == '/quote' && sizeof($close_tags) && substr($out, -1, 1) == '[')

+ $username = str_replace(array('&#91;', '&#93;'), array('[', ']'), $m[1]);

+ $username = preg_replace('#\[(?!b|i|u|color|url|email|/b|/i|/u|/color|/url|/email)#iU', '&#91;$1', $username);

+

+ $username = $m[1];

+ $pos1 = stripos($in, '[/quote');

+ if ($mode !== 'sig' && !utf8_clean_string($this->message))

+ mb_regex_encoding('UTF-8');

+ $cache_ttl = 3600;

+ $where_sql = array();

+ WHERE ';

+ $where_sql[] = "ban_email = ''";

+ $where_sql[] = "(ban_ip = '' OR ban_exclude = 1)";

+ $where_sql[] = '(ban_userid = 0 OR ban_exclude = 1)';

+ $cache_ttl = ($user_id == ANONYMOUS) ? 3600 : 0;

+ $_sql = '(ban_userid = ' . $user_id;

+ $_sql .= " OR ban_email <> ''";

+ $_sql .= " OR ban_ip <> ''";

+ $_sql .= ')';

+

+ $where_sql[] = $_sql;

+ $sql .= (sizeof($where_sql)) ? implode(' AND ', $where_sql) : '';

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

+ if ($row['ban_end'] && $row['ban_end'] < time())

+ {

+ continue;

+ }

+

+ // This seems to be no longer needed? - #14971

+// $this->session_create(ANONYMOUS);

+ // To circumvent session_begin returning a valid value and the check_ban() not called on second page view, we kill the session again

+ $this->session_kill(false);

+

+ 'user_newpasswd' => '',

+ 'user_pass_convert' => 0,

+ $release = request_var('release', 0);

+ $return = place_pm_into_folder($global_privmsgs_rules, $release);

+ $num_removed = $return['removed'];

+ $message_parser->message = $message_link . '[quote=&quot;' . $quote_username . '&quot;]' . censor_text(trim($message_parser->message)) . "[/quote]\n";

+ if (!preg_match('#^[a-z0-9_ \\-]+$#', $encoding))

+ 'version' => '1.0.RC8',

+ array('poll_option_id', VOTE_CONVERTED, ''),

+$updates_to_version = '3.0.RC8';

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

+ foreach ($smileys as $id => $code)

+ LEFT JOIN sysobjects o ON c.id = o.id

+ $sql_default = " {$column_type} ";

+ // For adding columns we need the default definition

+ if (!is_null($column_data[1]))

+ $sql_default .= 'DEFAULT (' . $column_data[1] . ') ';

+ $sql_default .= 'DEFAULT (' . ((is_numeric($column_data[1])) ? $column_data[1] : "'{$column_data[1]}'") . ') ';

+ }

+ $sql_default .= 'NOT NULL';

+

+ $return_array['column_type_sql_default'] = $sql_default;

+ $sql = 'ALTER TABLE [' . $table_name . '] ADD [' . $column_name . '] ' . $column_data['column_type_sql_default'];

+ 'U_NEW_ACTION' => $this->p_master->module_url . "?mode={$this->mode}&amp;sub=intro&amp;new_conv=1&amp;language=$language",

+ 'U_CONTINUE_ACTION' => $this->p_master->module_url . "?mode={$this->mode}&amp;sub=in_progress&amp;tag={$options['tag']}{$options['step']}&amp;language=$language",

+ global $lang, $language, $template, $phpbb_root_path, $phpEx;

+ 'U_CONVERT' => $this->p_master->module_url . "?mode={$this->mode}&amp;language=$language&amp;sub=settings&amp;tag=" . $convertors[$index]['tag'],

+ global $lang, $language, $template, $db, $phpbb_root_path, $phpEx, $config, $cache;

+ 'U_ACTION' => $this->p_master->module_url . "?mode={$this->mode}&amp;sub=in_progress&amp;tag=$convertor_tag&amp;language=$language",

+ 'U_ACTION' => $this->p_master->module_url . "?mode={$this->mode}&amp;sub=settings&amp;tag=$convertor_tag&amp;language=$language",

+ 'U_ACTION' => $this->p_master->module_url . "?mode={$this->mode}&amp;sub=in_progress&amp;tag={$convert->convertor_tag}&amp;language=$language",

+ foreach ($sql_data['select_fields'] as $select)

+ global $convert, $language;

+ return $this->p_master->module_url . "?mode={$this->mode}&amp;sub=in_progress&amp;tag={$convert->convertor_tag}$step&amp;language=$language";

+ global $db, $phpbb_root_path, $convert, $config, $language, $user, $template;

+ $url = $this->p_master->module_url . "?mode={$this->mode}&amp;sub=final&amp;language=$language";

+ $directories = array('config.' . $phpEx, 'images/avatars/upload/');

+ if (filesize($phpbb_root_path . 'config.' . $phpEx) > 10)

+ if (!isset($available_dbms[$data['dbms']]))

+ {

+ // Someone's been silly and tried providing a non-existant dbms

+ $this->p_master->redirect("index.$phpEx?mode=install");

+ }

+

+ $dbms = $available_dbms[$data['dbms']]['DRIVER'];

+

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

+ if (!isset($available_dbms[$data['dbms']]))

+ {

+ // Someone's been silly and tried providing a non-existant dbms

+ $this->p_master->redirect("index.$phpEx?mode=install");

+ }

+

+ $dbms = $available_dbms[$data['dbms']]['DRIVER'];

+

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

+ $file_list = $cache->get('_diff_files');

+ $info = get_remote_file('www.phpbb.com', '/updatecheck', ((defined('PHPBB_QA')) ? '30x_qa.txt' : '30x.txt'), $errstr, $errno);

+INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_tplcompile', '0');

+INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '3.0.RC8');

+ 'MAX_AVATAR_SIZE_EXPLAIN' => 'Width x Height in pixels.',

+ 'MIN_AVATAR_SIZE_EXPLAIN' => 'Width x Height in pixels.',

+ 'ICONS_NONE_ADDED' => 'No icons were added.',

+ 'ICONS_NONE_EDITED' => 'No icons were updated.',

+ 'TOPIC_LOCKED_SHORT'=> 'Topic locked',

+

+ 'INSTALL_INTRO_BODY' => 'With this option, it is possible to install phpBB3 onto your server.</p><p>In order to proceed, you will need your database settings. If you do not know your database settings, please contact your host and ask for them. You will not be able to continue without them. You need:</p>

+ 'OVERVIEW_BODY' => 'Welcome to phpBB3!<br /><br />phpBB™ is the most widely used open source bulletin board solution in the world. phpBB3 is the latest installment in a seven year long package lineup. Like its predecessors, phpBB3 is feature-rich, user-friendly, and fully supported by the phpBB Team. phpBB3 greatly improves on what made phpBB2 popular, and adds commonly requested features that were not present in previous versions. We hope it exceeds your expectations.<br /><br />This installation system will guide you through installing phpBB3, updating to the latest version of phpBB3 from past releases, as well as converting to phpBB3 from a different discussion board system (including phpBB2). For more information, we encourage you to read <a href="../docs/INSTALL.html">the installation guide</a>.<br /><br />To read the phpBB3 license or learn about obtaining support and our stance on it, please select the respective options from the side menu. To continue, please select the appropriate tab above.',

+ 'SUPPORT_BODY' => 'Full support will be provided for the current stable release of phpBB3, free of charge. This includes:</p><ul><li>installation</li><li>configuration</li><li>technical questions</li><li>problems relating to potential bugs in the software</li><li>updating from Release Candidate (RC) versions to the latest stable version</li><li>converting from phpBB 2.0.x to phpBB3</li><li>converting from other discussion board software to phpBB3 (please see the <a href="http://www.phpbb.com/community/viewforum.php?f=65">Convertors Forum</a>)</li></ul><p>We encourage users still running beta versions of phpBB3 to replace their installation with a fresh copy of the latest version.</p><h2>MODs / Styles</h2><p>For issues relating to MODs, please post in the appropriate <a href="http://www.phpbb.com/community/viewforum.php?f=81">Modifications Forum</a>.<br />For issues relating to styles, templates and imagesets, please post in the appropriate <a href="http://www.phpbb.com/community/viewforum.php?f=80">Styles Forum</a>.<br /><br />If your question relates to a specific package, please post directly in the topic dedicated to the package.</p><h2>Obtaining Support</h2><p><a href="http://www.phpbb.com/community/viewtopic.php?f=14&amp;t=571070">The phpBB Welcome Package</a><br /><a href="http://www.phpbb.com/support/">Support Section</a><br /><a href="http://www.phpbb.com/support/documentation/3.0/quickstart/">Quick Start Guide</a><br /><br />To ensure you stay up to date with the latest news and releases, why not <a href="http://www.phpbb.com/support/">subscribe to our mailing list</a>?<br /><br />',

+ 'CURRENT_FILE' => 'Beginning of current original file',

+ 'DIFF_SEP_EXPLAIN' => 'End of current original file / Beginning of new updated file',

+ 'NEW_FILE' => 'End of new updated file',

+ 'VOTE_CONVERTED' => 'Changing votes is not supported for converted polls.',

+ $message_parser->message = '[quote=&quot;' . $post_data['quote_username'] . '&quot;]' . censor_text(trim($message_parser->message)) . "[/quote]\n";

+ <param name="allowNetworking" value="internal" />

+ <embed src="{_file.U_DOWNLOAD_LINK}" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" width="{_file.WIDTH}" height="{_file.HEIGHT}" play="true" loop="true" quality="high" allowscriptaccess="never" allownetworking="internal"></embed>

+<!-- BEGIN flash --><object classid="clsid:D27CDB6E-AE6D-11CF-96B8-444553540000" codebase="http://active.macromedia.com/flash2/cabs/swflash.cab#version=5,0,0,0" width="{WIDTH}" height="{HEIGHT}"><param name="movie" value="{URL}" /><param name="play" value="false" /><param name="loop" value="false" /><param name="quality" value="high" /><param name="allowScriptAccess" value="never" /><param name="allowNetworking" value="internal" /><embed src="{URL}" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" width="{WIDTH}" height="{HEIGHT}" play="false" loop="false" quality="high" allowscriptaccess="never" allownetworking="internal"></embed></object><!-- END flash --> \ No newline at end of file

+ if (document.forms[form_name])

+

+

+ if (!document.forms[form_name])

+ {

+ document.body.focus();

+ }

+<!-- IF S_VIEWTOPIC -->

+ <p></p><p><a href="{U_VIEW_FORUM}" class="left-box {S_CONTENT_FLOW_BEGIN}" accesskey="r">{L_RETURN_TO} {FORUM_NAME}</a></p>

+<!-- ELSEIF S_VIEWFORUM -->

+ <p></p><p><a href="{U_INDEX}" class="left-box {S_CONTENT_FLOW_BEGIN}" accesskey="r">{L_RETURN_TO} {L_INDEX}</a></p>

+<!-- ELSEIF SEARCH_TOPIC -->

+ <p></p><p><a class="left-box {S_CONTENT_FLOW_BEGIN}" href="{U_SEARCH_TOPIC}" accesskey="r">{L_RETURN_TO}: {SEARCH_TOPIC}</a></p>

+<!-- ELSEIF S_SEARCH_ACTION -->

+ <p></p><p><a class="left-box {S_CONTENT_FLOW_BEGIN}" href="{U_SEARCH}" title="{L_SEARCH_ADV}" accesskey="r">{L_RETURN_TO_SEARCH_ADV}</a></p>

+<!-- ENDIF -->

+

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ </form>

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ </fieldset>

+ </fieldset>

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+</fieldset>

+

+<div>

+ {S_FORM_TOKEN}

+</div>

+ {S_FORM_TOKEN}

+</div>

+

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+</div>

+

+ {S_FORM_TOKEN}

+ {S_FORM_TOKEN}

+