X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-theme.php;h=1a95e558eff0b59115d55421216d690d6f3852d8;hb=3daede4c904e23905c3e48dd6749019deca0a0e0;hp=39d74b135dec01880b6a72f9841ddeff6bce7d9f;hpb=3b85bd5030ad591b0c5cb038ca534a7b50e1b319;p=mailer.git

diff --git a/inc/extensions/ext-theme.php b/inc/extensions/ext-theme.php
index 39d74b135d..1a95e558ef 100644
--- a/inc/extensions/ext-theme.php
+++ b/inc/extensions/ext-theme.php
@@ -54,7 +54,7 @@ case "register": // Do stuff when installation is running (modules.php?module=ad
 
 case "remove": // Do stuff when removing extension
 	// Drop theme table
-	$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_themes";
+	$SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_themes`";
 
 	// Delete admin menu
 	$SQLs[] = "DELETE LOW_PRIORITY FROM `"._MYSQL_PREFIX."_admin_menu` WHERE `action`='theme' LIMIT 4";
@@ -62,7 +62,7 @@ case "remove": // Do stuff when removing extension
 	// Delete guest menu entries
 	$SQLs[] = "DELETE LOW_PRIORITY FROM `"._MYSQL_PREFIX."_guest_menu` WHERE action='themes' LIMIT 1";
 
-	// Delete/update member menu entries
+	// Delete member menu entries
 	$SQLs[] = "DELETE LOW_PRIORITY FROM `"._MYSQL_PREFIX."_member_menu` WHERE action='themes' OR `what`='themes' LIMIT 2";
 	break;
 
@@ -110,24 +110,23 @@ case "update": // Update an extension
 		break;
 
 	case "0.0.7": // SQL queries for v0.0.7
-		$SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_themes ADD theme_name VARCHAR(255) NOT NULL DEFAULT ''";
-
 		// Update notes (these will be set as task text!)
-		$UPDATE_NOTES = "Designname (von Menschen lesbar) hinzugefügt.";
+		$UPDATE_NOTES = "Ungültiges Update.";
 		break;
 
 	case "0.0.8": // SQL queries for v0.0.8
 		// Theme table
-		$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_themes";
-		$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_themes (
+		$SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_themes`";
+		$SQLs[] = "CREATE TABLE `"._MYSQL_PREFIX."_themes` (
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 theme_path VARCHAR(255) NOT NULL DEFAULT '',
+theme_name VARCHAR(255) NOT NULL DEFAULT '',
 theme_active ENUM('Y','N') NOT NULL DEFAULT 'N',
 theme_ver VARCHAR(255) NOT NULL DEFAULT '0.0',
-PRIMARY KEY(`id`),
-UNIQUE KEY(`theme_path`),
-INDEX(`theme_active`),
-) TYPE=MyISAM";
+PRIMARY KEY (`id`),
+UNIQUE KEY (`theme_path`),
+INDEX (`theme_active`)
+) TYPE=MyISAM COMMENT='Themes'";
 
 		// Admin menu
 		$SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('theme', NULL, 'Themes','Verwalten Sie hier alle Designs (Themes) Ihres Mailtausch-Scriptes.', 8)";