]> git.mxchange.org Git - mailer.git/blobdiff - inc/extensions/ext-optimize.php
isNicknameUsed() does no longer check for ext-nickname
[mailer.git] / inc / extensions / ext-optimize.php
index 79ce41bff5be7b27b89ec3353f37602e6c2f7d6e..df97fc64ab0204d08dbd9e19aa56997deeffa135 100644 (file)
@@ -1,6 +1,6 @@
 <?php
 /************************************************************************
- * MXChange v0.2.1                                    Start: 03/22/2004 *
+ * Mailer v0.2.1-FINAL                                Start: 03/22/2004 *
  * ================                             Last change: 06/28/2004 *
  *                                                                      *
  * -------------------------------------------------------------------- *
@@ -53,18 +53,19 @@ setExtensionAlwaysActive('Y');
 switch (getExtensionMode()) {
        case 'register': // Do stuff when installation is running (modules.php?module=admin is called)
                // SQL commands to run
-               addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_optimize_gain`(
-  id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
-  gain decimal(10,3) NOT NULL DEFAULT '0.000',
-  PRIMARY KEY (id)
+               addExtensionSql("DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_optimize_gain`");
+               addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_optimize_gain` (
+`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`gain` decimal(10,3) NOT NULL DEFAULT '0.000',
+PRIMARY KEY (`id`)
 ) TYPE={?_TABLE_TYPE?}");
-               addAdminMenuSql('misc','optimize','DB optimieren','F&uuml;hren Sie dies ab und an aus, damit &uuml;berfl&uuml;ssige Daten aus der Datenbank entfernt werden.','5');
+               addAdminMenuSql('misc','optimize','DB optimieren','F&uuml;hren Sie dies ab und an aus, damit &uuml;berfl&uuml;ssige Bin&auml;rdaten aus der Datenbank entfernt werden.',5);
                break;
 
        case 'remove': // Do stuff when removing extension
                // SQL commands to run
                addExtensionSql("DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_optimize_gain`");
-               addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `what`='optimize'");
+               addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `what`='optimize' LIMIT 1");
                break;
 
        case 'activate': // Do stuff when admin activates this extension