X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fextensions%2Fext-newsletter.php;h=56fdfda8f9ffb3af41764f0ae1f5c5460f472a97;hb=b6c301dece2d7a3375321d4f3c0498ceaeb5a2a6;hp=81a22978ae42eeb0f911b33b16df6e213faafcf5;hpb=c3b4eaf29946349ff058691db2dcb615a5379bb2;p=mailer.git diff --git a/inc/extensions/ext-newsletter.php b/inc/extensions/ext-newsletter.php index 81a22978ae..56fdfda8f9 100644 --- a/inc/extensions/ext-newsletter.php +++ b/inc/extensions/ext-newsletter.php @@ -59,9 +59,9 @@ switch (getExtensionMode()) { // SQL commands to run addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `action`='newsletter'"); addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE `what`='newsletter'"); - addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_newsletter_data`'); - addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_newsletter_topics`'); - addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_newsletter_orders`'); + addDropTableSql('newsletter_data'); + addDropTableSql('newsletter_topics'); + addDropTableSql('newsletter_orders'); break; case 'activate': // Do stuff when admin activates this extension @@ -139,7 +139,7 @@ switch (getExtensionMode()) { case '0.2.0': // SQL queries for v0.2.0 // Tables: // - Main data table - addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_newsletter_data`'); + addDropTableSql('newsletter_data'); addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_newsletter_data` ( `nl_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `nl_subject` VARCHAR(255) NOT NULL DEFAULT '{OPEN_CONFIG}nl_default_subject{CLOSE_CONFIG}', @@ -158,7 +158,7 @@ PRIMARY KEY (`nl_id`) ) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'General newsletter data'"); // - Topics data table - addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_newsletter_topics`'); + addDropTableSql('newsletter_topics'); addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_newsletter_topics` ( `nl_topic_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `nl_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, @@ -170,7 +170,7 @@ PRIMARY KEY (`nl_topic_id`) ) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Newsletter topics'"); // - Sponsor orders data table - addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_newsletter_orders`'); + addDropTableSql('newsletter_orders'); addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_newsletter_orders` ( `nl_order_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `nl_sponsor_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, @@ -209,7 +209,7 @@ PRIMARY KEY (`nl_order_id`) case 'modify': // When the extension got modified break; - case 'test': // For testing purposes. For details see file inc/modules/admin/what-extensions.php, arround line 305. + case 'test': // For testing purposes break; case 'init': // Do stuff when extension is initialized