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