<?
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
include($phpbb_root_path . 'includes/constants.'.$phpEx);
include($phpbb_root_path . 'includes/functions_selects.'.$phpEx);
//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//
if( $userdata['user_level'] == ADMIN)
{
$sql = "SELECT config_value
FROM ". $table_prefix ."plus
WHERE config_name = 'plus_version'";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Kann Plus-Version nicht auslesen!', '', __LINE__, __FILE__, $sql);
}
$version = $db->sql_fetchrow($result);
if ( $version['config_value'] != "1.52" )
{
message_die(GENERAL_MESSAGE, "Führe bitte ein Update auf die aktuelle Version durch.");
exit;
}
else
{
unset($sql);
$sql[] = "ALTER TABLE " . CATEGORIES_TABLE . " DROP cat_main_type";
$sql[] = "ALTER TABLE " . CATEGORIES_TABLE . " DROP cat_main";
$sql[] = "ALTER TABLE " . CATEGORIES_TABLE . " DROP cat_desc";
$sql[] = "ALTER TABLE " . CATEGORIES_TABLE . " DROP icon";
$sql[] = "ALTER TABLE " . FORUMS_TABLE . " DROP forum_link";
$sql[] = "ALTER TABLE " . FORUMS_TABLE . " DROP forum_link_internal";
$sql[] = "ALTER TABLE " . FORUMS_TABLE . " DROP forum_link_hit_count";
$sql[] = "ALTER TABLE " . FORUMS_TABLE . " DROP forum_link_hit";
$sql[] = "ALTER TABLE " . FORUMS_TABLE . " DROP icon";
$sql[] = "ALTER TABLE " . FORUMS_TABLE . " DROP main_type";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_sub_forum";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_split_cat";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_last_topic_title";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_sub_level_links";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_display_viewonline";
$sql[] = "ALTER TABLE " . FORUMS_TABLE . " DROP auth_global_announce";
$sql[] = "ALTER TABLE " . TOPICS_TABLE . " DROP topic_announce_duration";
$sql[] = "ALTER TABLE " . AUTH_ACCESS_TABLE . " DROP auth_global_announce";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_announcement_date_display";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_announcement_display";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_announcement_display_forum";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_announcement_split";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_announcement_forum";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_split_global_announce";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_split_announce";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_split_sticky";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_split_news";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_split_topic_split";
$sql[] = "DELETE FROM ". CONFIG_TABLE . " WHERE config_name = split_news";
$sql[] = "DELETE FROM ". CONFIG_TABLE . " WHERE config_name = google_visit_counter";
$sql[] = "ALTER TABLE ".USERS_TABLE." DROP user_birthday";
$sql[] = "ALTER TABLE ".USERS_TABLE." DROP user_next_birthday_greeting";
$sql[] = "DELETE FROM ".CONFIG_TABLE." WHERE config_name = birthday_required";
$sql[] = "DELETE FROM ".CONFIG_TABLE." WHERE config_name = birthday_greeting";
$sql[] = "DELETE FROM ".CONFIG_TABLE." WHERE config_name = max_user_age";
$sql[] = "DELETE FROM ".CONFIG_TABLE." WHERE config_name = min_user_age";
$sql[] = "DELETE FROM ".CONFIG_TABLE." WHERE config_name = birthday_check_day";
$sql[] = "ALTER TABLE ".USERS_TABLE." DROP user_gender";
$sql[] = "DROP TABLE " .$table_prefix. "attachments_config";
$sql[] = "DROP TABLE " .$table_prefix. "forbidden_extensions";
$sql[] = "DROP TABLE " .$table_prefix. "extension_groups";
$sql[] = "DROP TABLE " .$table_prefix. "extensions";
$sql[] = "DROP TABLE " .$table_prefix. "attachments_desc";
$sql[] = "DROP TABLE " .$table_prefix. "attachments";
$sql[] = "DROP TABLE " .$table_prefix. "quota_limits";
$sql[] = "DROP TABLE " .$table_prefix. "attach_quota";
$sql[] = "ALTER TABLE ".$table_prefix."forums DROP auth_download";
$sql[] = "ALTER TABLE ".$table_prefix."auth_access DROP auth_download";
$sql[] = "ALTER TABLE ".$table_prefix."posts DROP post_attachment";
$sql[] = "ALTER TABLE ".$table_prefix."topics DROP topic_attachment";
$sql[] = "ALTER TABLE ".$table_prefix."privmsgs DROP privmsgs_attachment";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = upload_dir";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = upload_img";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = topic_icon";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = display_order";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = max_filesize";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = attachment_quota";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = max_filesize_pm";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = max_attachments";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = max_attachments_pm";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = disable_mod";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = allow_pm_attach";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = attachment_topic_review";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = allow_ftp_upload";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = show_apcp";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = attach_version";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = default_upload_quota";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = default_pm_quota";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = ftp_server";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = ftp_path";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = download_path";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = ftp_user";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = ftp_pass";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = ftp_pasv_mode";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = img_display_inlined";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = img_max_width";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = img_max_height";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = img_link_width";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = img_link_height";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = img_create_thumbnail";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = img_min_thumb_filesize";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = img_imagick";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = wma_autoplay";
$sql[] = "DELETE FROM ".$table_prefix."attachments_config WHERE config_name = flash_autoplay";
$sql[] = "DROP TABLE ".$table_prefix."jr_admin_users";
$sql[] = "DROP TABLE ".$table_prefix."color_groups";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_color_group";
$sql[] = "ALTER TABLE ".$table_prefix."color_groups DROP hidden";
$sql[] = "ALTER TABLE ".$table_prefix."color_groups DROP order_num";
$sql[] = "ALTER TABLE ".$table_prefix."groups DROP group_color_group";
$sql[] = "ALTER TABLE ".USERS_TABLE." DROP user_lastlogon";
$sql[] = "DELETE FROM ".CONFIG_TABLE." WHERE config_name = hidde_last_logon";
$sql[] = "ALTER TABLE " . USERS_TABLE ." DROP user_totaltime";
$sql[] = "ALTER TABLE " . USERS_TABLE ." DROP user_totallogon";
$sql[] = "ALTER TABLE " . USERS_TABLE ." DROP user_totalpages";
$sql[] = "DROP TABLE " .$table_prefix. "flags";
$sql[] = "ALTER TABLE " . USERS_TABLE ." DROP user_from_flag";
$sql[] = "DROP TABLE " .$table_prefix. "anti_robotic_reg";
$sql[] = "DROP TABLE " .$table_prefix. "pa_cat";
$sql[] = "DROP TABLE " .$table_prefix. "pa_auth";
$sql[] = "DROP TABLE " .$table_prefix. "pa_comments";
$sql[] = "DROP TABLE " .$table_prefix. "pa_config";
$sql[] = "DROP TABLE " .$table_prefix. "pa_custom";
$sql[] = "DROP TABLE " .$table_prefix. "pa_customdata";
$sql[] = "DROP TABLE " .$table_prefix. "pa_download_info";
$sql[] = "DROP TABLE " .$table_prefix. "pa_files";
$sql[] = "DROP TABLE " .$table_prefix. "pa_license";
$sql[] = "DROP TABLE " .$table_prefix. "pa_mirrors";
$sql[] = "DROP TABLE " .$table_prefix. "pa_votes";
$sql[] = "DROP TABLE " .$table_prefix. "album";
$sql[] = "DROP TABLE " .$table_prefix. "album_rate";
$sql[] = "DROP TABLE " .$table_prefix. "album_comment";
$sql[] = "DROP TABLE " .$table_prefix. "album_cat";
$sql[] = "DROP TABLE " .$table_prefix. "album_config";
$sql[] = "ALTER TABLE " . TOPICS_TABLE . " DROP topic_icon";
$sql[] = "ALTER TABLE " . POSTS_TABLE . " DROP post_icon";
$sql[] = "ALTER TABLE " . TOPICS_TABLE . " DROP topic_calendar_time";
$sql[] = "ALTER TABLE " . TOPICS_TABLE . " DROP topic_calendar_duration";
$sql[] = "ALTER TABLE " . AUTH_ACCESS_TABLE . " DROP auth_cal";
$sql[] = "ALTER TABLE " . FORUMS_TABLE . " DROP auth_cal";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_calendar_display_open";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_calendar_header_cells";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_calendar_week_start";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_calendar_nb_row";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_calendar_birthday";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_calendar_forum";
$sql[] = "DROP TABLE " .$table_prefix. "plus";
$sql[] = "DROP TABLE " .$table_prefix. "bookmarks";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_setbm";
$sql[] = "DELETE FROM " . CONFIG_TABLE . " WHERE config_name = max_link_bookmarks";
$sql[] = "DROP TABLE " .$table_prefix. "banner";
$sql[] = "DROP TABLE " .$table_prefix. "banner_stats";
$sql[] = "DROP TABLE " .$table_prefix. "portal";
$sql[] = "DROP TABLE " .$table_prefix. "shout";
$sql[] = "DELETE FROM ".CONFIG_TABLE." WHERE config_name = prune_shouts";
$sql[] = "DROP TABLE " .$table_prefix. "news";
$sql[] = "ALTER TABLE " . TOPICS_TABLE . " DROP news_id";
$sql[] = "ALTER TABLE " . FORUMS_TABLE . " DROP auth_news";
$sql[] = "ALTER TABLE " . AUTH_ACCESS_TABLE . " DROP auth_news";
$sql[] = "INSERT INTO ".CONFIG_TABLE." WHERE config_name = allow_news";
$sql[] = "INSERT INTO ".CONFIG_TABLE." WHERE config_name = news_item_trim";
$sql[] = "INSERT INTO ".CONFIG_TABLE." WHERE config_name = news_title_trim";
$sql[] = "INSERT INTO ".CONFIG_TABLE." WHERE config_name = news_item_num";
$sql[] = "INSERT INTO ".CONFIG_TABLE." WHERE config_name = news_path";
$sql[] = "INSERT INTO ".CONFIG_TABLE." WHERE config_name = allow_rss";
$sql[] = "INSERT INTO ".CONFIG_TABLE." WHERE config_name = news_rss_desc";
$sql[] = "INSERT INTO ".CONFIG_TABLE." WHERE config_name = news_rss_language";
$sql[] = "INSERT INTO ".CONFIG_TABLE." WHERE config_name = news_rss_ttl";
$sql[] = "INSERT INTO ".CONFIG_TABLE." WHERE config_name = news_rss_cat";
$sql[] = "INSERT INTO ".CONFIG_TABLE." WHERE config_name = news_rss_image";
$sql[] = "INSERT INTO ".CONFIG_TABLE." WHERE config_name = news_rss_image_desc";
$sql[] = "INSERT INTO ".CONFIG_TABLE." WHERE config_name = news_rss_item_count";
$sql[] = "INSERT INTO ".CONFIG_TABLE." WHERE config_name = news_rss_show_abstract";
$sql[] = "INSERT INTO ".CONFIG_TABLE." WHERE config_name = news_base_url";
$sql[] = "INSERT INTO ".CONFIG_TABLE." WHERE config_name = news_index_file";
$sql[] = "DROP TABLE " .$table_prefix. "album_sp_config";
$sql[] = "DROP TABLE " .$table_prefix. "topic_view";
$sql[] = "DROP TABLE " .$table_prefix. "hacks_list";
$sql[] = "DROP TABLE " .$table_prefix. "stats_config";
$sql[] = "DROP TABLE " .$table_prefix. "stats_modules";
$sql[] = "DROP TABLE " .$table_prefix. "link_categories";
$sql[] = "DROP TABLE " .$table_prefix. "links";
$sql[] = "DROP TABLE " .$table_prefix. "link_config";
$sql[] = "ALTER TABLE ".FORUMS_TABLE." DROP auth_ban";
$sql[] = "ALTER TABLE ".FORUMS_TABLE." DROP auth_greencard";
$sql[] = "ALTER TABLE ".FORUMS_TABLE." DROP auth_bluecard";
$sql[] = "ALTER TABLE ".AUTH_ACCESS_TABLE." DROP auth_ban";
$sql[] = "ALTER TABLE ".AUTH_ACCESS_TABLE." DROP auth_greencard";
$sql[] = "ALTER TABLE ".AUTH_ACCESS_TABLE." DROP auth_bluecard";
$sql[] = "DELETE FROM ".CONFIG_TABLE." WHERE config_name = bluecard_limit";
$sql[] = "DELETE FROM ".CONFIG_TABLE." WHERE config_name = bluecard_limit_2";
$sql[] = "DELETE FROM ".CONFIG_TABLE." WHERE config_name = max_user_bancard";
$sql[] = "DELETE FROM ".CONFIG_TABLE." WHERE config_name = report_forum";
$sql[] = "ALTER TABLE ".USERS_TABLE." DROP user_warnings";
$sql[] = "ALTER TABLE ".POSTS_TABLE." DROP post_bluecard";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_passwd_change";
$sql[] = "DELETE FROM ". CONFIG_TABLE . " WHERE config_name = max_password_age";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_badlogin";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_blocktime";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_block_by";
$sql[] = "INSERT INTO ". CONFIG_TABLE . " WHERE config_name = block_time";
$sql[] = "INSERT INTO ". CONFIG_TABLE . " WHERE config_name = max_login_error";
$sql[] = "INSERT INTO ". CONFIG_TABLE . " WHERE config_name = min_password_len";
$sql[] = "INSERT INTO ". CONFIG_TABLE . " WHERE config_name = force_complex_password";
$sql[] = "INSERT INTO ". CONFIG_TABLE . " WHERE config_name = password_not_login";
$sql[] = "ALTER TABLE " . FORUMS_TABLE . " DROP count_posts";
$sql[] = "ALTER TABLE ".USERS_TABLE." DROP user_session_topic";
$sql[] = "ALTER TABLE ".SESSIONS_TABLE." DROP session_topic";
$sql[] = "DROP TABLE ".$table_prefix."acronyms";
$sql[] = "DELETE FROM ".$table_prefix."config WHERE config_name = board_disable_msg";
$sql[] = "ALTER TABLE ".$table_prefix."topics DROP topic_desc";
$sql[] = "DELETE FROM ". CONFIG_TABLE . " WHERE config_name = users_allow_absence";
$sql[] = "DELETE FROM ". CONFIG_TABLE . " WHERE config_name = mod_able_sent_absent";
$sql[] = "DELETE FROM ". CONFIG_TABLE . " WHERE config_name = absent_button";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_absence";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_absence_mode";
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP user_absence_text";
$sql[] = "DELETE FROM ".$table_prefix."themes WHERE themes_id = 1";
$sql[] = "DELETE FROM ".$table_prefix."themes_name WHERE themes_id = 1";
$sql[] = 'INSERT INTO '.$table_prefix.'themes (themes_id, template_name, style_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (1, \'subSilver\', \'subSilver\', \'subSilver.css\', \'\', \'E5E5E5\', \'000000\', \'006699\', \'5493B4\', \'\', \'DD6900\', \'EFEFEF\', \'DEE3E7\', \'D1D7DC\', \'\', \'\', \'\', \'98AAB1\', \'006699\', \'FFFFFF\', \'cellpic1.gif\', \'cellpic3.gif\', \'cellpic2.jpg\', \'FAFAFA\', \'FFFFFF\', \'\', \'row1\', \'row2\', \'\', \'Verdana, Arial, Helvetica, sans-serif\', \'Trebuchet MS\', \'Courier, \\\'Courier New\\\', sans-serif\', 10, 11, 12, \'444444\', \'006600\', \'FFA34F\', \'\', \'\', \'\')';
$sql[] = 'INSERT INTO '.$table_prefix.'themes_name (themes_id, tr_color1_name, tr_color2_name, tr_color3_name, tr_class1_name, tr_class2_name, tr_class3_name, th_color1_name, th_color2_name, th_color3_name, th_class1_name, th_class2_name, th_class3_name, td_color1_name, td_color2_name, td_color3_name, td_class1_name, td_class2_name, td_class3_name, fontface1_name, fontface2_name, fontface3_name, fontsize1_name, fontsize2_name, fontsize3_name, fontcolor1_name, fontcolor2_name, fontcolor3_name, span_class1_name, span_class2_name, span_class3_name) VALUES (1, \'Die hellste Zeilen-Farbe\', \'Die mittlere Zeilen-Farbe\', \'Die dunkelste Zeilen-Farbe\', \'\', \'\', \'\', \'Rahmen um die ganze Seite\', \'Rahmen der äußeren Tabelle\', \'Rahmen der inneren Tabelle\', \'Silbernes Verlaufbild\', \'Blaues Verlaufbild\', \'Übergangsbild auf der Hauptseite\', \'Hintergrund für Zitate\', \'Alle weissen Flächen\', \'\', \'Hintergrund für Themenbeiträge #1\', \'Hintergrund für Themenbeiträge #2\', \'\', \'Hauptschriften\', \'Zusätzliche Schrift für die Thementitel\', \'Formularschriften\', \'Kleinste Schriftgröße\', \'Mittlere Schriftgröße\', \'Standard-Schriftgröße\', \'Zitat- und Copyrighthinweis\', \'Schriftfarbe für code-BBCode\', \'Textfarbe der Haupttabelle\', \'\', \'\', \'\')';
$sql[] = "UPDATE ".CONFIG_TABLE." SET config_value = 1 WHERE config_name = override_user_style";
$sql[] = "UPDATE ".CONFIG_TABLE." SET config_value = 1 WHERE config_name = default_style";
$sql[] = "UPDATE ".USERS_TABLE." SET user_style = 1 WHERE user_style != 1";
for($x=0;$x<count($sql);$x++)
{
$db->sql_query($sql[$x]);
}
$message="Datenbankänderungen von phpBB2 Plus 1.5 wurden rückgängig gemacht ...";
message_die(GENERAL_MESSAGE, $message);
}
}
else
{
message_die(GENERAL_MESSAGE, $lang['Not_Authorised']);
}
?>
Bu forumu görüntüleyenler: Kayıtlı kullanıcı yok ve 0 misafir