X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-html_mail.php;h=aa270798f125baf18c914472cc2e0b21ee493192;hb=831c60d4cec333ea95e0ce23d9e53fd5d8133ce6;hp=346f7429d0b3086dc9f2130a86685eeca76973fb;hpb=8ba389b59f6d41f88752cae896143135e575f34a;p=mailer.git diff --git a/inc/extensions/ext-html_mail.php b/inc/extensions/ext-html_mail.php index 346f7429d0..aa270798f1 100644 --- a/inc/extensions/ext-html_mail.php +++ b/inc/extensions/ext-html_mail.php @@ -53,7 +53,7 @@ case "register": // Do stuff when installtion is running (modules.php?module=adm $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD html ENUM('Y','N') NOT NULL DEFAULT 'Y'"; $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_bonus ADD html_msg ENUM('Y','N') NOT NULL DEFAULT 'N'"; $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_pool ADD html_msg ENUM('Y','N') NOT NULL DEFAULT 'N'"; - $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_member_menu (action, what, title, sort, visible, locked) VALUES ('main','html_mail','HTML-Empfang','3','Y','Y')"; + $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_member_menu (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','html_mail','HTML-Empfang','3','Y','Y')"; break; case "remove": // Do stuff when removing extension @@ -61,17 +61,17 @@ case "remove": // Do stuff when removing extension $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data DROP html"; $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_bonus DROP html_msg"; $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_pool DROP html_msg"; - $SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_member_menu WHERE action='main' AND what='html_mail' LIMIT 1"; + $SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_member_menu WHERE what='html_mail' LIMIT 1"; break; case "activate": // Do stuff when admin activates this extension // SQL commands to run - $SQLs[] = "UPDATE "._MYSQL_PREFIX."_member_menu SET visible='Y', locked='N' WHERE action='main' AND what='html_mail' LIMIT 1"; + $SQLs[] = "UPDATE "._MYSQL_PREFIX."_member_menu SET visible='Y', locked='N' WHERE what='html_mail' LIMIT 1"; break; case "deactivate": // Do stuff when admin deactivates this extension // SQL commands to run - $SQLs[] = "UPDATE "._MYSQL_PREFIX."_member_menu SET visible='Y', locked='Y' WHERE action='main' AND what='html_mail' LIMIT 1"; + $SQLs[] = "UPDATE "._MYSQL_PREFIX."_member_menu SET visible='Y', locked='Y' WHERE what='html_mail' LIMIT 1"; break; case "update": // Update an extension