Das Update besteht ja aus mehrern Schritten! Also die Abfrage aus dem 2. Schritt(wo ich stecken bleibe).
Code: Alles auswählen
$sql[] = "UPDATE " . $table_prefix . "plus SET config_value = '0.3.0U' WHERE config_name = 'plus_version'";
$sql[] = "UPDATE " . $table_prefix . "config SET config_value='.0.22' WHERE config_name='version'";
$sql[] = "DROP TABLE `phpbb_captcha_config`;";
$sql[] = "DROP TABLE `phpbb_chatspot_messages`;";
$sql[] = "DROP TABLE `phpbb_chatspot_rooms`;";
$sql[] = "DROP TABLE `phpbb_chatspot_sessions`;";
$sql[] = "ALTER TABLE `phpbb_users` DROP `ct_logintry`;";
$sql[] = "ALTER TABLE `phpbb_users` DROP `ct_unsucclogin`;";
$sql[] = "ALTER TABLE `phpbb_users` DROP `ct_pwreset`;";
$sql[] = "ALTER TABLE `phpbb_users` DROP `ct_mailcount`;";
$sql[] = "ALTER TABLE `phpbb_users` DROP `ct_postcount`;";
$sql[] = "ALTER TABLE `phpbb_users` DROP `ct_posttime`;";
$sql[] = "ALTER TABLE `phpbb_users` DROP `ct_searchcount`;";
$sql[] = "ALTER TABLE `phpbb_users` DROP `ct_searchtime`;";
$sql[] = "CREATE TABLE `" . $table_prefix . "ctracker_config` (
`ct_config_name` varchar(255) NOT NULL,
`ct_config_value` varchar(255) NOT NULL,
PRIMARY KEY (`ct_config_name`)
)";
$sql[] = "CREATE TABLE `" . $table_prefix . "ctracker_filechk` (
`filepath` text,
`hash` varchar(32) default NULL
)";
$sql[] = "CREATE TABLE `" . $table_prefix . "ctracker_filescanner` (
`id` smallint(5) NOT NULL,
`filepath` text,
`safety` smallint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
)";
$sql[] = "CREATE TABLE `" . $table_prefix . "ctracker_ipblocker` (
`id` mediumint(8) unsigned NOT NULL,
`ct_blocker_value` varchar(250) default NULL,
PRIMARY KEY (`id`)
) AUTO_INCREMENT=33";
$sql[] = "CREATE TABLE `" . $table_prefix . "ctracker_loginhistory` (
`ct_user_id` int(10) default NULL,
`ct_login_ip` varchar(16) default NULL,
`ct_login_time` int(11) NOT NULL default '0'
)";
$sql[] = "CREATE TABLE " . $table_prefix . "upi2db_always_read (
topic_id mediumint(8) unsigned NOT NULL default 0,
forum_id mediumint(8) unsigned NOT NULL default 0,
user_id mediumint(8) unsigned NOT NULL default 0,
last_update int(11) NOT NULL default 0,
KEY forum_id (forum_id),
KEY topic_id (topic_id)
)";
$sql[] = "CREATE TABLE " . $table_prefix . "upi2db_last_posts (
post_id mediumint(8) unsigned NOT NULL default 0,
topic_id mediumint(8) unsigned NOT NULL default 0,
forum_id smallint(5) unsigned NOT NULL default 0,
poster_id mediumint(8) NOT NULL default 0,
post_time int(11) NOT NULL default 0,
post_edit_time int(11) NOT NULL default 0,
topic_type tinyint(1) NOT NULL default 0,
post_edit_by mediumint(8) NOT NULL default 0,
PRIMARY KEY (post_id)
)";
$sql[] = "CREATE TABLE " . $table_prefix . "upi2db_unread_posts (
post_id mediumint(8) unsigned NOT NULL default 0,
topic_id mediumint(8) unsigned NOT NULL default 0,
forum_id smallint(5) unsigned NOT NULL default 0,
user_id mediumint(8) unsigned NOT NULL default 0,
status tinyint(1) NOT NULL default 0,
topic_type tinyint(1) NOT NULL default 0,
last_update int(11) NOT NULL default 0,
KEY post_id (post_id),
KEY user_id (user_id)
)";
$sql[] = "CREATE TABLE " . $table_prefix . "error_report (
error_id mediumint(8) unsigned NOT NULL auto_increment,
error_userid varchar(10) default NULL,
error_time varchar(10) default NULL,
error_sql_code varchar(10) default NULL,
error_sql_text text,
error_file varchar(255) default NULL,
error_file_line varchar(10) default NULL,
error_sql_store text,
error_msg_title varchar(50) default NULL,
error_msg_text varchar(200) default NULL,
PRIMARY KEY (error_id)
) TYPE=MyISAM";
$sql[] = "CREATE TABLE `" . $table_prefix . "lexicon` (
`id` bigint(8) NOT NULL auto_increment,
`keyword` varchar(250) NOT NULL default '',
`explanation` longtext NOT NULL,
`bbcode_uid` varchar(10) default NULL,
`cat` int(8) NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `cat` (`cat`)
) TYPE=MyISAM";
$sql[] = "CREATE TABLE `" . $table_prefix . "lexicon_cat` (
`cat_id` int(8) NOT NULL auto_increment,
`cat_titel` varchar(80) NOT NULL default '',
PRIMARY KEY (`cat_id`)
) TYPE=MyISAM";
$sql[] = "CREATE TABLE `" . $table_prefix . "lexicon_config` (
`config_name` varchar(255) NOT NULL default '',
`config_value` varchar(255) NOT NULL default '',
PRIMARY KEY (`config_name`)
) TYPE=MyISAM";
$sql[] = "CREATE TABLE " . $table_prefix . "add_pages (
page_id MEDIUMINT(8) NOT NULL,
page_name VARCHAR(100) NOT NULL,
page_content TEXT,
page_auth TINYINT(1) NOT NULL,
html TINYINT(1) NOT NULL
)";
$sql[] = "CREATE TABLE " . $table_prefix . "notes (
post_id mediumint(8) unsigned NOT NULL auto_increment,
poster_id mediumint(8) NOT NULL DEFAULT '0',
post_subject varchar(60) DEFAULT NULL,
post_text text,
post_time int(11) NOT NULL DEFAULT '0',
bbcode_uid varchar(10) DEFAULT NULL,
bbcode TINYINT(1) DEFAULT '1' NOT NULL,
smilies TINYINT(1) DEFAULT '1' NOT NULL,
acronym TINYINT(1) DEFAULT '1' NOT NULL,
PRIMARY KEY (post_id),
KEY poster_id (poster_id),
KEY post_time (post_time)
) TYPE=MyISAM";
$sql[] = "ALTER TABLE `" . $table_prefix . "users` ADD `ct_search_time` INT( 11 ) NULL DEFAULT 1 AFTER `user_newpasswd`";
$sql[] = "ALTER TABLE `" . $table_prefix . "users` ADD `ct_search_count` MEDIUMINT( 8 ) NULL DEFAULT 1 AFTER `ct_search_time`";
$sql[] = "ALTER TABLE `" . $table_prefix . "users` ADD `ct_last_mail` INT( 11 ) NULL DEFAULT 1 AFTER `ct_search_count`";
$sql[] = "ALTER TABLE `" . $table_prefix . "users` ADD `ct_last_post` INT( 11 ) NULL DEFAULT 1 AFTER `ct_last_mail`";
$sql[] = "ALTER TABLE `" . $table_prefix . "users` ADD `ct_post_counter` MEDIUMINT( 8 ) NULL DEFAULT 1 AFTER `ct_last_post`";
$sql[] = "ALTER TABLE `" . $table_prefix . "users` ADD `ct_last_pw_reset` INT( 11 ) NULL DEFAULT 1 AFTER `ct_post_counter`";
$sql[] = "ALTER TABLE `" . $table_prefix . "users` ADD `ct_enable_ip_warn` TINYINT( 1 ) NULL DEFAULT 1 AFTER `ct_last_pw_reset`";
$sql[] = "ALTER TABLE `" . $table_prefix . "users` ADD `ct_last_used_ip` VARCHAR( 16 ) NULL DEFAULT '0.0.0.0' AFTER `ct_enable_ip_warn`";
$sql[] = "ALTER TABLE `" . $table_prefix . "users` ADD `ct_last_ip` VARCHAR( 16 ) NULL DEFAULT '0.0.0.0' AFTER `ct_last_used_ip`";
$sql[] = "ALTER TABLE `" . $table_prefix . "users` ADD `ct_login_count` MEDIUMINT( 8 ) NULL DEFAULT 1 AFTER `ct_last_used_ip`";
$sql[] = "ALTER TABLE `" . $table_prefix . "users` ADD `ct_login_vconfirm` TINYINT( 1 ) NULL DEFAULT 0 AFTER `ct_login_count`";
$sql[] = "ALTER TABLE `" . $table_prefix . "users` ADD `ct_last_pw_change` INT( 11 ) NULL DEFAULT 1 AFTER `ct_login_vconfirm`";
$sql[] = "ALTER TABLE `" . $table_prefix . "users` ADD `ct_global_msg_read` TINYINT( 1 ) NULL DEFAULT 0 AFTER `ct_last_pw_change`";
$sql[] = "ALTER TABLE `" . $table_prefix . "users` ADD `ct_miserable_user` TINYINT( 1 ) NULL DEFAULT 0 AFTER `ct_global_msg_read`";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('ipblock_enabled', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('ipblock_logsize', '100')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('auto_recovery', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('vconfirm_guest', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('autoban_mails', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('detect_misconfiguration', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('search_time_guest', '30')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('search_time_user', '20')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('search_count_guest', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('search_count_user', '4')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('massmail_protection', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('reg_protection', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('reg_blocktime', '30')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('reg_lastip', '0.0.0.0')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('pwreset_time', '20')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('massmail_time', '20')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('spammer_time', '30')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('spammer_postcount', '4')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('spammer_blockmode', '0')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('loginfeature', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('pw_reset_feature', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('reg_last_reg', '1155944976')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('login_history', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('login_history_count', '10')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('login_ip_check', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('pw_validity', '30')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('pw_complex_min', '4')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('pw_complex_mode', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('pw_control', '0')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('pw_complex', '0')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('last_file_scan', '1156000091')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('last_checksum_scan', '1156000082')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('logsize_logins', '100')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('logsize_spammer', '100')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('reg_ip_scan', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('global_message', 'Hello world!')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('global_message_type', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('logincount', '2')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('search_feature_enabled', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('spam_attack_boost', '0')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('spam_keyword_det', '0')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('footer_layout', '3')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (1, '*WebStripper*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (2, '*NetMechanic*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (3, '*CherryPicker*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (4, '*EmailCollector*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (5, '*EmailSiphon*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (6, '*WebBandit*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (7, '*EmailWolf*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (8, '*ExtractorPro*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (9, '*SiteSnagger*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (10, '*CheeseBot*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (11, '*ia_archiver*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (12, '*Website Quester*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (13, '*WebZip*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (14, '*moget*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (15, '*WebSauger*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (16, '*WebCopier*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (17, '*WWW-Collector*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (18, '*InfoNaviRobot*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (19, '*Harvest*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (20, '*Bullseye*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (21, '*LinkWalker*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (22, '*LinkextractorPro*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (23, '*WebProxy*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (24, '*BlowFish*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (25, '*WebEnhancer*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (26, '*TightTwatBot*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (27, '*LinkScan*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (28, '*WebDownloader*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (29, 'lwp')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (30, '*BruteForce*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (31, 'lwp-*')";
$sql[] = "INSERT INTO `" . $table_prefix . "ctracker_ipblocker` (`id`, `ct_blocker_value`) VALUES (32, '*anonym*')";
$sql[] = "ALTER TABLE " . $table_prefix . "users ADD user_upi2db_which_system TINYINT( 1 ) DEFAULT '1' NOT NULL";
$sql[] = "ALTER TABLE " . $table_prefix . "users ADD user_upi2db_disable TINYINT( 1 ) DEFAULT '0' NOT NULL";
$sql[] = "ALTER TABLE " . $table_prefix . "users ADD user_upi2db_datasync INT( 11 ) DEFAULT '0' NOT NULL";
$sql[] = "ALTER TABLE " . $table_prefix . "groups ADD upi2db_on TINYINT( 1 ) DEFAULT '1' NOT NULL";
$sql[] = "ALTER TABLE " . $table_prefix . "groups ADD upi2db_min_posts MEDIUMINT( 4 ) DEFAULT '0' NOT NULL";
$sql[] = "ALTER TABLE " . $table_prefix . "groups ADD upi2db_min_regdays MEDIUMINT( 4 ) DEFAULT '0' NOT NULL";
$sql[] = "ALTER TABLE " . $table_prefix . "users ADD user_upi2db_new_word TINYINT( 1 ) DEFAULT '1' NOT NULL";
$sql[] = "ALTER TABLE " . $table_prefix . "users ADD user_upi2db_edit_word TINYINT( 1 ) DEFAULT '1' NOT NULL";
$sql[] = "ALTER TABLE " . $table_prefix . "users ADD user_upi2db_unread_color TINYINT( 1 ) DEFAULT '1' NOT NULL";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('upi2db_max_permanent_topics', '20')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('upi2db_del_mark', '60')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('upi2db_del_perm','120')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('upi2db_max_mark_posts','10')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('upi2db_unread_color','00C000')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('upi2db_edit_color','FF7D77')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('upi2db_mark_color','FFFF00')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('upi2db_auto_read','30')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('upi2db_edit_as_new','1')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('upi2db_last_edit_as_new', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('upi2db_on', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('upi2db_edit_topic_first', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('upi2db_no_group_min_regdays', '0')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('upi2db_no_group_min_posts', '0')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('upi2db_no_group_upi2db_on', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('upi2db_install_time','$install_time')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('upi2db_delete_old_data','0')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('upi2db_max_new_posts','300')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('upi2db_max_new_posts_admin', '1000')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('upi2db_max_new_posts_mod', '500')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('upi2db_version', '3.0.7a')";
$sql[] = "INSERT INTO `" . $table_prefix . "lexicon` VALUES (1, '1th example', 'This is a testentry to example the character-navigation.\r\nBy default the numbers does not shown. They only will display if exist a entry.', '5d424e3a4a', 1)";
$sql[] = "INSERT INTO `" . $table_prefix . "lexicon` VALUES (2, 'Testentry', 'This is another entry to example the lexicon.', NULL, 1)";
$sql[] = "INSERT INTO `" . $table_prefix . "lexicon_cat` VALUES (1, 'default')";
$sql[] = "INSERT INTO `" . $table_prefix . "lexicon_config` VALUES ('titel', 'Lexicon v2 by AmigaLink')";
$sql[] = "INSERT INTO `" . $table_prefix . "lexicon_config` VALUES ('description', 'This mod based on a script by eXperienZ.NET')";
$sql[] = "INSERT INTO `" . $table_prefix . "lexicon_config` VALUES ('version', '.0.4')";
$sql[] = "INSERT INTO `" . $table_prefix . "lexicon_config` VALUES ('keywords_per_page', '25')";
$sql[] = "INSERT INTO `" . $table_prefix . "lexicon_config` VALUES ('allow_guest', '1')";
$sql[] = "ALTER TABLE " . $table_prefix . "users ADD COLUMN user_quote_open tinyint(1) NOT NULL DEFAULT 0";
$sql[] = "ALTER TABLE " . $table_prefix . "users ADD COLUMN user_code_open tinyint(1) NOT NULL DEFAULT 0";
$sql[] = "INSERT INTO " . $table_prefix . "config ( config_name , config_value ) VALUES ('notes', '20')";
$sql[] = "ALTER TABLE " . $table_prefix . "users ADD user_popup_notes TINYINT(1) DEFAULT '0'";
$sql[] = "CREATE TABLE `" . $table_prefix . "captcha_config` (
`config_name` varchar(255) NOT NULL default '',
`config_value` varchar(100) NOT NULL default '',
PRIMARY KEY (`config_name`)
) TYPE=MyISAM";
$sql[] = "INSERT INTO `" . $table_prefix . "captcha_config` VALUES ('width', '320')";
$sql[] = "INSERT INTO `" . $table_prefix . "captcha_config` VALUES ('height', '60')";
$sql[] = "INSERT INTO `" . $table_prefix . "captcha_config` VALUES ('exsample_code', 'SAMPLE')";
$sql[] = "INSERT INTO `" . $table_prefix . "captcha_config` VALUES ('background_color', '#E5ECF9')";
$sql[] = "INSERT INTO `" . $table_prefix . "captcha_config` VALUES ('jpeg', '0')";
$sql[] = "INSERT INTO `" . $table_prefix . "captcha_config` VALUES ('jpeg_quality', '50')";
$sql[] = "INSERT INTO `" . $table_prefix . "captcha_config` VALUES ('pre_letters', '0')";
$sql[] = "INSERT INTO `" . $table_prefix . "captcha_config` VALUES ('pre_letters_great', '0')";
$sql[] = "INSERT INTO `" . $table_prefix . "captcha_config` VALUES ('font', '0')";
$sql[] = "INSERT INTO `" . $table_prefix . "captcha_config` VALUES ('trans_letters', '0')";
$sql[] = "INSERT INTO `" . $table_prefix . "captcha_config` VALUES ('chess', '0')";
$sql[] = "INSERT INTO `" . $table_prefix . "captcha_config` VALUES ('ellipses', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "captcha_config` VALUES ('arcs', '0')";
$sql[] = "INSERT INTO `" . $table_prefix . "captcha_config` VALUES ('lines', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "captcha_config` VALUES ('image', '0')";
$sql[] = "INSERT INTO `" . $table_prefix . "captcha_config` VALUES ('bg_transition', '35')";
$sql[] = "INSERT INTO `" . $table_prefix . "captcha_config` VALUES ('gammacorrect', '0.8')";
$sql[] = "INSERT INTO `" . $table_prefix . "captcha_config` VALUES ('foreground_lattice_x', '15')";
$sql[] = "INSERT INTO `" . $table_prefix . "captcha_config` VALUES ('foreground_lattice_y', '15')";
$sql[] = "INSERT INTO `" . $table_prefix . "captcha_config` VALUES ('lattice_color', '#FFFFFF')";
$sql[] = "INSERT INTO `" . $table_prefix . "captcha_config` VALUES ('avc_version', '1.2.0')";
$sql[] = "ALTER TABLE `phpbb_confirm` CHANGE `code` `code` CHAR(10) NOT NULL";
$sql[] = "ALTER TABLE `" . $table_prefix . "confirm` CHANGE `code` `code` CHAR(10) NOT NULL";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('search_flood_interval', '0')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('rand_seed', '0')";
$sql[] = "ALTER TABLE " . $table_prefix . "search_results ADD COLUMN search_time int(11) DEFAULT '0' NOT NULL";
$sql[] = "UPDATE `" . $table_prefix . "captcha_config` SET config_value = '" . $new_release . "' WHERE config_name = 'avc_version'";
$sql[] = "ALTER TABLE ".USERS_TABLE." ADD `user_skype` VARCHAR( 255 ) AFTER `user_msnm` ;";
$sql[] = "ALTER TABLE ".USERS_TABLE." ADD FULLTEXT (`user_skype` );";
$sql[] = "INSERT INTO " . $table_prefix . "plus (`config_name`, `config_value`)VALUES ('atlas_required', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "plus (`config_name` ,`config_value`)VALUES ('show_last_topics', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "plus (`config_name` ,`config_value`)VALUES ('show_last_topics1', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "plus (config_name, config_value) VALUES ('show_count1', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "plus (config_name, config_value) VALUES ('show_birthdays1', '1')";
$sql[] = "CREATE TABLE " . $table_prefix . "gum_config (
config_name varchar(255) NOT NULL default '',
config_value text NOT NULL
) TYPE=MyISAM";
$sql[] = "INSERT INTO `" . $table_prefix . "gum_config` VALUES ('active', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "gum_config` VALUES ('inactive_text', 'Die Karte wurde vorübergehend deaktiviert. Sie können weiterhin die Wohnorte der eingetragenen Benutzer sehen, jedoch nicht Ihre eigenen Daten ändern oder nach Mitgliedern suchen.')";
$sql[] = "CREATE TABLE " . $table_prefix . "gum_plz (
plzid int(11) NOT NULL auto_increment,
plz varchar(5) NOT NULL default '',
breite double(9,6) NOT NULL default '0.000000',
laenge double(9,6) NOT NULL default '0.000000',
land varchar(50) NOT NULL default '',
ort varchar(100) NOT NULL default '',
PRIMARY KEY (plzid)
) TYPE=MyISAM";
$sql[] = "CREATE TABLE " . $table_prefix . "gum_users (
gum_id int(11) NOT NULL auto_increment,
gum_username varchar(25) NOT NULL default '',
gum_plz varchar(5) NOT NULL default '',
gum_land varchar(50) NOT NULL default '',
PRIMARY KEY (gum_id),
KEY gum_id (gum_id)
) TYPE=MyISAM";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('guest_profile','0')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('guest_search','1')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('guest_memberlist','0')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('guest_groupcp','0')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('guest_search_m','1')";
$sql[] = "INSERT INTO " . $table_prefix . "plus VALUES ('imp_zusatz', '')";
$sql[] = "INSERT INTO " . $table_prefix . "plus VALUES ('imp_gf', '')";
$sql[] = "ALTER TABLE `" . $table_prefix . "posts_text` ADD `post_extra` VARCHAR( 60 ) NULL AFTER `post_subject`";
$sql[] = "UPDATE " . $table_prefix . "plus SET config_value = '0' WHERE config_name = 'show_search'";
$sql[] = "ALTER TABLE " . $table_prefix . "users ADD `user_long` FLOAT( 6 ) NOT NULL , ADD `user_lat` FLOAT( 6 ) NOT NULL";
$sql[] = "ALTER TABLE " . $table_prefix . "vote_voters ADD vote_cast TINYINT( 4 ) UNSIGNED DEFAULT '0' NOT NULL";
$sql[] = "ALTER TABLE `" . $table_prefix . "posts` ADD `parsed` TINYINT( 1 ) DEFAULT '0' NOT NULL";
$sql[] = "ALTER TABLE `" . $table_prefix . "posts` ADD `dont_cache` TINYINT( 1 ) DEFAULT '0' NOT NULL";
$sql[] = "ALTER TABLE `" . $table_prefix . "posts` ADD `cache_file_md5` VARCHAR( 32 ) DEFAULT NULL";
$sql[] = "ALTER TABLE `" . $table_prefix . "topics` ADD `topic_cache_lock` TINYINT( 1 ) DEFAULT '0' NOT NULL";
$sql[] = "ALTER TABLE `" . $table_prefix . "topics` ADD INDEX ( `topic_cache_lock` )";
$sql[] = "INSERT INTO `" . $table_prefix . "config` VALUES ('enable_post_cache', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "config` VALUES ('allow_cache_moderate', '0')";
$sql[] = "INSERT INTO `" . $table_prefix . "config` VALUES ('min_post_cache_size', '100')";
$sql[] = "INSERT INTO `" . $table_prefix . "config` VALUES ('cache_each_template', '0')";
$sql[] = "INSERT INTO `" . $table_prefix . "config` VALUES ('show_cache_stats', '0')";
$sql[] = "INSERT INTO `" . $table_prefix . "config` VALUES ('cache_posts_version', '1.0.0')";
$sql[] = "ALTER TABLE `" . $table_prefix . "topics` ADD `topic_extra` VARCHAR( 60 ) CHARACTER SET latin1 COLLATE latin1_german2_ci NOT NULL AFTER `topic_title`";
$sql[] = "CREATE TABLE " . $table_prefix . "sessions_keys (
key_id varchar(32) DEFAULT '0' NOT NULL,
user_id mediumint(8) DEFAULT '0' NOT NULL,
last_ip varchar(8) DEFAULT '0' NOT NULL,
last_login int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (key_id, user_id),
KEY last_login (last_login)
)";
$sql[] = "ALTER TABLE " . $table_prefix . "users ADD COLUMN user_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL";
$sql[] = "ALTER TABLE " . $table_prefix . "users ADD COLUMN user_last_login_try int(11) DEFAULT '0' NOT NULL";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('max_login_attempts', '200')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('login_reset_time', '4')";
$sql[] = "DELETE FROM phpbb_sessions;";
$sql[] = "DELETE FROM phpbb_sessions_keys;";
for( $i = 0; $i < count($sql); $i++ )
{