'forum_name' => 'phpBB 2.0.x',

'version' => '1.0.3',

'phpbb_version' => '3.1.0-dev',

'dbms' => $dbms,

'dbhost' => $dbhost,

'dbport' => $dbport,

*

*/

define('UPDATES_TO_VERSION', '3.1.0-dev');

// Enter any version to update from to test updates. The version within the db will not be updated.

$debug_from_version = DEBUG_FROM_VERSION;

$oldest_from_version = OLDEST_FROM_VERSION;

@set_time_limit(0);

// Include essential scripts

die("Please read: <a href='../docs/INSTALL.html'>INSTALL.html</a> before attempting to update.");

}

// Include files

require($phpbb_root_path . 'includes/class_loader.' . $phpEx);

require($phpbb_root_path . 'includes/functions.' . $phpEx);

phpbb_require_updated('includes/functions_content.' . $phpEx, true);

define('EXT_TABLE', $table_prefix . 'ext');

}

$phpbb_class_loader->register();

// set up caching

// make sure request_var uses this request instance

request_var('', 0, false, false, $request); // "dependency injection" for a function

</div>

<div id="page-footer">

</div>

</div>

{

global $db;

{

echo "<br />\n{$sql}\n<br />";

}

function _add_modules($modules_to_install)

{

// modules require an extension manager

if (empty($phpbb_extension_manager))

{

}

include_once($phpbb_root_path . 'includes/acp/acp_modules.' . $phpEx);

),

),

),

/** @todo DROP LOGIN_ATTEMPT_TABLE.attempt_id in 3.0.12-RC1 */

'style_parent_tree' => array('TEXT', ''),

),

REPORTS_TABLE => array(

),

),

'change_columns' => array(

case '3.0.11-RC1':

break;

// Changes from 3.1.0-dev to 3.1.0-A1

case '3.1.0-dev':

// Create config value for displaying last subject on forum list

if (!isset($config['display_last_subject']))

$config->set('display_last_subject', '1');

}

if (!isset($config['assets_version']))

{

$db_tools->sql_column_remove(USERS_TABLE, 'user_dst');

}

break;

}

}

*

*/

/**#@+

* @ignore

*/

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

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

{

}

function phpbb_require_updated($path, $optional = false)

// Include essential scripts

require($phpbb_root_path . 'includes/class_loader.' . $phpEx);

require($phpbb_root_path . 'includes/functions.' . $phpEx);

phpbb_require_updated('includes/functions_content.' . $phpEx, true);

include($phpbb_root_path . 'includes/utf/utf_tools.' . $phpEx);

require($phpbb_root_path . 'includes/functions_install.' . $phpEx);

$phpbb_class_loader->register();

// set up caching

// make sure request_var uses this request instance

request_var('', 0, false, false, $request); // "dependency injection" for a function

$phpbb_style_resource_locator = new phpbb_style_resource_locator();

$phpbb_style_path_provider = new phpbb_style_path_provider();

$phpbb_style = new phpbb_style($phpbb_root_path, $phpEx, $config, $user, $phpbb_style_resource_locator, $phpbb_style_path_provider, $template);

$phpbb_style->set_ext_dir_prefix('adm/');

$phpbb_style->set_custom_style('admin', '../adm/style', '');

$template->assign_vars(array(

'L_CHANGE' => $lang['CHANGE'],

'L_INSTALL_PANEL' => $lang['INSTALL_PANEL'],

'L_SELECT_LANG' => $lang['SELECT_LANG'],

'L_SKIP' => $lang['SKIP'],

echo ' </div>';

echo ' </div>';

echo ' <div id="page-footer">';

echo ' </div>';

echo '</div>';

echo '</body>';

$template->assign_block_vars('checks', array(

'TITLE' => "skip_rows = $skip_rows",

));

$mtime = explode(' ', microtime());

}

// When we reach this point, either the current table has been processed or we're running out of time.

{

$skip_rows = 0;

$current_table++;

sync('topic', 'range', 'topic_id BETWEEN ' . $sync_batch . ' AND ' . $end, true, true);

$template->assign_block_vars('checks', array(

'RESULT' => $user->lang['DONE'],

));

global $convert;

// Can we use IGNORE with this DBMS?

$insert_query = 'INSERT ' . $sql_ignore . 'INTO ' . $schema['target'] . ' (';

$aliases = array();

// Test the minimum PHP version

$php_version = PHP_VERSION;

{

$result = '<strong style="color:red">' . $lang['NO'] . '</strong>';

}

'S_EXPLAIN' => true,

'S_LEGEND' => false,

));

// Check for php json support

if (@extension_loaded('json'))

{

'S_LEGEND' => false,

));

$passed['mbstring'] = true;

if (@extension_loaded('mbstring'))

{

{

if (!@extension_loaded($dll))

{

}

$template->assign_block_vars('checks', array(

$written = false;

// Create a list of any PHP modules we wish to have loaded

$available_dbms = get_available_dbms($data['dbms']);

// Create a lock file to indicate that there is an install in progress

$fp = @fopen($phpbb_root_path . 'cache/install_lock', 'wb');

@chmod($phpbb_root_path . 'cache/install_lock', 0777);

// Time to convert the data provided into a config file

// Attempt to write out the config file directly. If it works, this is the easiest way to do it ...

if ((file_exists($phpbb_root_path . 'config.' . $phpEx) && phpbb_is_writable($phpbb_root_path . 'config.' . $phpEx)) || phpbb_is_writable($phpbb_root_path))

WHERE config_name = 'dbms_version'",

);

{

$sql_ary[] = 'UPDATE ' . $data['table_prefix'] . "config

SET config_value = 'phpbb_captcha_gd'

*/

function add_modules($mode, $sub)

{

// modules require an extension manager

if (empty($phpbb_extension_manager))

{

}

include_once($phpbb_root_path . 'includes/acp/acp_modules.' . $phpEx);

foreach ($this->module_categories[$module_class] as $cat_name => $subs)

{

$module_data = array(

'module_enabled' => 1,

'module_display' => 1,

'parent_id' => 0,

{

foreach ($subs as $level2_name)

{

$module_data = array(

'module_enabled' => 1,

'module_display' => 1,

'parent_id' => (int) $categories[$cat_name]['id'],

'user_timezone' => 'UTC',

'user_dateformat' => $lang['default_dateformat'],

'user_allow_massemail' => 0,

);

$user_id = user_add($user_row);

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

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

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

'FAST Enterprise [Crawler]' => array('FAST Enterprise Crawler', ''),

'FAST WebCrawler [Crawler]' => array('FAST-WebCrawler/', ''),

'Francis [Bot]' => array('http://www.neomo.de/', ''),

'MSN NewsBlogs' => array('msnbot-NewsBlogs/', ''),

'MSN [Bot]' => array('msnbot/', ''),

'MSNbot Media' => array('msnbot-media/', ''),

'Nutch [Bot]' => array('http://lucene.apache.org/nutch/', ''),

'Online link [Validator]' => array('online link validator', ''),

'psbot [Picsearch]' => array('psbot/0', ''),

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

'Telekom [Bot]' => array('crawleradmin.t-info@telekom.de', ''),

'TurnitinBot [Bot]' => array('TurnitinBot/', ''),

'W3 [Sitesearch]' => array('W3 SiteSearch Crawler', ''),

'W3C [Linkcheck]' => array('W3C-checklink/', ''),

'YaCy [Bot]' => array('yacybot', ''),

'Yahoo MMCrawler [Bot]' => array('Yahoo-MMCrawler/', ''),

'Yahoo Slurp [Bot]' => array('Yahoo! DE Slurp', ''),

'UCP_ZEBRA' => null,

),

);

var $module_extras = array(

'acp' => array(

function main($mode, $sub)

{

global $request;

$this->tpl_name = 'install_update';

$test_connection = false;

if ($test_ftp_connection || $submit)

{

$test_connection = $transfer->open_session();

// Make sure that the directory is correct by checking for the existence of common.php

}

else

{

$transfer->open_session();

}

report_closed INTEGER DEFAULT 0 NOT NULL,

report_time INTEGER DEFAULT 0 NOT NULL,

report_text BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,

);;

ALTER TABLE phpbb_reports ADD PRIMARY KEY (report_id);;

[report_closed] [int] DEFAULT (0) NOT NULL ,

[report_time] [int] DEFAULT (0) NOT NULL ,

[report_text] [text] DEFAULT ('') NOT NULL ,

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

report_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

report_text mediumblob NOT NULL,

reported_post_text mediumblob NOT NULL,

PRIMARY KEY (report_id),

KEY post_id (post_id),

KEY pm_id (pm_id)

report_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

report_text mediumtext NOT NULL,

reported_post_text mediumtext NOT NULL,

PRIMARY KEY (report_id),

KEY post_id (post_id),

KEY pm_id (pm_id)

report_time number(11) DEFAULT '0' NOT NULL,

report_text clob DEFAULT '' ,

reported_post_text clob DEFAULT '' ,

CONSTRAINT pk_phpbb_reports PRIMARY KEY (report_id)

)

/

report_time INT4 DEFAULT '0' NOT NULL CHECK (report_time >= 0),

report_text TEXT DEFAULT '' NOT NULL,

reported_post_text TEXT DEFAULT '' NOT NULL,

PRIMARY KEY (report_id)

);

INSERT INTO phpbb_config (config_name, config_value) VALUES ('session_gc', '3600');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('session_length', '3600');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('site_desc', '{L_CONFIG_SITE_DESC}');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitename', '{L_CONFIG_SITENAME}');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_path', 'images/smilies');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_per_page', '50');

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_bots', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_clearlogs', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_email', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_fauth', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_forum', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_forumadd', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_chggrp', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_chgname', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_chgpasswd', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_download', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_hideonline', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_ignoreflood', 1);

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 22, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'f_%' AND auth_option NOT IN ('f_announce', 'f_attach', 'f_bump', 'f_delete', 'f_flash', 'f_icons', 'f_ignoreflood', 'f_sticky', 'f_user_lock', 'f_votechg');

# New Member (u_)

# New Member (f_)

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 24, auth_option_id, 0 FROM phpbb_acl_options WHERE auth_option LIKE 'f_%' AND auth_option IN ('f_noapprove');

report_closed INTEGER UNSIGNED NOT NULL DEFAULT '0',

report_time INTEGER UNSIGNED NOT NULL DEFAULT '0',

report_text mediumtext(16777215) NOT NULL DEFAULT '',

);

CREATE INDEX phpbb_reports_post_id ON phpbb_reports (post_id);