All database names are now 'back-ticked' and constant _MYSQL_PREFIX is wrapped. Partl...

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

diff --git a/inc/extensions/ext-optimize.php b/inc/extensions/ext-optimize.php
index 6b6143976313e05c788e5687e529b38710b4e962..b0c13ba3903ab11de095c3cdd9746d078d77f2eb 100644 (file)
--- a/inc/extensions/ext-optimize.php
+++ b/inc/extensions/ext-optimize.php
@@ -50,18 +50,18 @@ switch ($EXT_LOAD_MODE)
 {
 case "register": // Do stuff when installation is running (modules.php?module=admin&action=login is called)
        // SQL commands to run
-       $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_optimize_gain(
+       $SQLs[] = "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=MyISAM";
-       $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('misc','optimize','DB optimieren','Führen Sie dies ab und an aus, damit überflüssige Daten aus der Datenbank entfernt werden.','5')";
+       $SQLs[] = "INSERT INTO `{!MYSQL_PREFIX!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('misc','optimize','DB optimieren','Führen Sie dies ab und an aus, damit überflüssige Daten aus der Datenbank entfernt werden.','5')";
        break;
 
 case "remove": // Do stuff when removing extension
        // SQL commands to run
-       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_optimize_gain";
-       $SQLs[] = "DELETE LOW_PRIORITY FROM `"._MYSQL_PREFIX."_admin_menu` WHERE what='optimize' LIMIT 1";
+       $SQLs[] = "DROP TABLE IF EXISTS `{!MYSQL_PREFIX!}_optimize_gain`";
+       $SQLs[] = "DELETE LOW_PRIORITY FROM `{!MYSQL_PREFIX!}_admin_menu` WHERE what='optimize' LIMIT 1";
        break;
 
 case "activate": // Do stuff when admin activates this extension