Renamed templates, more usage of EL

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

diff --git a/inc/extensions/ext-register.php b/inc/extensions/ext-register.php
index be486be9146d80cdc1fd45fceb70c930ee371817..42809d622aa3b46808c2372442b729dcf1b5908e 100644 (file)
--- a/inc/extensions/ext-register.php
+++ b/inc/extensions/ext-register.php
@@ -49,13 +49,13 @@ setExtensionVersionHistory(array('0.0', '0.1.0', '0.1.1', '0.1.2', '0.1.3', '0.1
 switch (getExtensionMode()) {
        case 'register': // Do stuff when installation is running (modules.php?module=admin is called)
                // SQL commands to run
-               addGuestMenuSql('register', 'members', 'Anmeldung', 'Y', 'N', 2);
+               addGuestMenuSql('members', 'register', 'Anmeldung', 'Y', 'N', 2);
                break;
 
        case 'remove': // Do stuff when removing extension
                // SQL commands to run
-               addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `what`='config_register'");
-               addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_guest_menu` WHERE `what`='register'");
+               addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `what`='config_register' LIMIT 1");
+               addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_guest_menu` WHERE `what`='register' LIMIT 1");
                addDropTableSql('must_register');
 
                // Unregister a filter
@@ -76,12 +76,12 @@ switch (getExtensionMode()) {
                switch (getCurrentExtensionVersion()) {
                        case '0.1.0': // SQL queries for v0.1
                                addDropTableSql('must_register');
-                               addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_must_register` (
+                               addCreateTableSql('must_register', "(
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `field_name` VARCHAR(255) NOT NULL DEFAULT '',
 `field_required` ENUM('Y','N') NOT NULL DEFAULT 'Y',
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Data which fields the user must fill out'");
 
                                // Add all entries as required (DO NOT DELETE THEM FROM DATABASE!)
                                addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_must_register` (`field_name`, `field_required`) VALUES ('surname','Y')");