Introduced wrapper function addCreateTableSql(), fixed parameter order:

[mailer.git] / inc / extensions / ext-theme.php

diff --git a/inc/extensions/ext-theme.php b/inc/extensions/ext-theme.php
index 94cad5d9d6ed5118f85452b843a5343306232904..ce0686a779e27cb0cf7e54d6be643eaf389def17 100644 (file)
--- 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