X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-theme.php;h=ce0686a779e27cb0cf7e54d6be643eaf389def17;hp=94cad5d9d6ed5118f85452b843a5343306232904;hb=be39a7fb887473487fd2c5f8d550aa03b720cb73;hpb=c8d76610eb94093d4eed4fcd8a6cb72e74c8f6d8

diff --git a/inc/extensions/ext-theme.php b/inc/extensions/ext-theme.php
index 94cad5d9d6..ce0686a779 100644
--- a/inc/extensions/ext-theme.php
+++ b/inc/extensions/ext-theme.php
@@ -16,7 +16,7 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009, 2010 by Mailer Developer Team                    *
+ * Copyright (c) 2009 - 2011 by Mailer Developer Team                   *
  * For more information visit: http://www.mxchange.org                  *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -53,7 +53,7 @@ switch (getExtensionMode()) {
 
 	case 'remove': // Do stuff when removing extension
 		// Drop theme table
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_themes`');
+		addDropTableSql('themes');
 
 		// Delete admin menu
 		addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `action`='theme'");
@@ -71,12 +71,14 @@ switch (getExtensionMode()) {
 
 	case 'activate': // Do stuff when admin activates this extension
 		// SQL commands to run
-		addExtensionSql('');
+		addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_guest_menu` SET `visible`='Y', `locked`='N' WHERE `action`='theme' LIMIT 1");
+		addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `visible`='Y', `locked`='N' WHERE `action`='themes' OR `what`='themes' LIMIT 2");
 		break;
 
 	case 'deactivate': // Do stuff when admin deactivates this extension
 		// SQL commands to run
-		addExtensionSql('');
+		addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_guest_menu` SET `visible`='N', `locked`='Y' WHERE `action`='theme' LIMIT 1");
+		addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `visible`='N', `locked`='Y' WHERE `action`='themes' OR `what`='themes' LIMIT 2");
 		break;
 
 	case 'update': // Update an extension
@@ -118,8 +120,8 @@ switch (getExtensionMode()) {
 
 			case '0.0.8': // SQL queries for v0.0.8
 				// Theme table
-				addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_themes`');
-				addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_themes` (
+				addDropTableSql('themes');
+				addCreateTableSql('themes', "(
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `theme_path` VARCHAR(255) NOT NULL DEFAULT '',
 `theme_name` VARCHAR(255) NOT NULL DEFAULT '',
@@ -128,12 +130,12 @@ switch (getExtensionMode()) {
 PRIMARY KEY (`id`),
 UNIQUE KEY (`theme_path`),
 INDEX (`theme_active`)
-) TYPE={?_TABLE_TYPE?} COMMENT='Themes'");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Themes'");
 
 				// Admin menu
 				addAdminMenuSql('theme', NULL, 'Themes','Verwalten Sie hier alle Designs (Themes) Ihres {OPEN_CONFIG}mt_word2{CLOSE_CONFIG}.', 8);
 				addAdminMenuSql('theme','theme_import','Importieren','Es wird das Verzeichnis "theme" nach neuen Ordnern durchsucht und anschliessend in die Datenbank gesperrt aufgenommen.', 1);
-				addAdminMenuSql('theme','theme_edit','Modifizieren','Ändern Sie Titel, Freigaben usw. an den Themes. Sie können bis auf das Standart-Theme "default" auch Themes aus der Datenbank entfernen. Vorher sollten Sie es jedoch vom Server löschen, damit es niht erneut importiert werden kann.', 2);
+				addAdminMenuSql('theme','theme_edit','Modifizieren','Ändern Sie Titel, Freigaben usw. an den Themes. Sie können bis auf das Standard-Theme "default" auch Themes aus der Datenbank entfernen. Vorher sollten Sie es jedoch vom Server löschen, damit es niht erneut importiert werden kann.', 2);
 
 				// Guest menu
 				addGuestMenuSql('themes',NULL,'Design-Auswahl','Y','N',4);
@@ -153,7 +155,7 @@ INDEX (`theme_active`)
 
 			case '0.0.9': // SQL queries for v0.0.9
 				// Config SQL
-				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `default_theme` VARCHAR(255) NOT NULL DEFAULT 'default'");
+				addConfigAddSql('default_theme', "VARCHAR(255) NOT NULL DEFAULT 'default'");
 
 				// Update notes (these will be set as task text!)
 				setExtensionUpdateNotes("Fehlende Konfiguration hinzugefügt.");
@@ -188,7 +190,7 @@ INDEX (`theme_active`)
 	case 'modify': // When the extension got modified
 		break;
 
-	case 'test': // For testing purposes. For details see file inc/modules/admin/what-extensions.php, arround line 305.
+	case 'test': // For testing purposes
 		break;
 
 	case 'init': // Do stuff when extension is initialized