X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-optimize.php;h=b0c13ba3903ab11de095c3cdd9746d078d77f2eb;hp=6b6143976313e05c788e5687e529b38710b4e962;hb=cca98f57dff720b174d21d071cee8303462485d7;hpb=f6ccb87413901e0352319385471134dd2d4ba966 diff --git a/inc/extensions/ext-optimize.php b/inc/extensions/ext-optimize.php index 6b61439763..b0c13ba390 100644 --- 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