]> git.mxchange.org Git - mailer.git/blobdiff - inc/extensions/ext-forced.php
New wrapper functions introduced, some one-line parameter monsters killed:
[mailer.git] / inc / extensions / ext-forced.php
index 8d4af26ab78b6d8ab608f006626e6b8d95e7677f..53c89cea1a0db384a56387e766a87255a6ace026 100644 (file)
@@ -55,7 +55,7 @@ switch (getExtensionMode()) {
                addExtensionDependency('sponsor');
 
                // - Ads
-               addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_forced_ads`');
+               addDropTableSql('forced_ads');
                addExtensionSql("CREATE TABLE IF NOT EXIST `{?_MYSQL_PREFIX?}_forced_ads` (
 `forced_ads_id` BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
 `forced_ads_ad_url` VARCHAR( 255 ) NULL DEFAULT NULL ,
@@ -72,7 +72,7 @@ PRIMARY KEY ( `forced_ads_id` )
 ) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Forced Ads Data'");
 
                // - Campaigns
-               addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_forced_campaigns`');
+               addDropTableSql('forced_campaigns');
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_forced_campaigns` (
 `forced_campaign_id` BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
 `forced_campaign_created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
@@ -89,7 +89,7 @@ PRIMARY KEY ( `forced_campaign_id` )
 ) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Forced Campaign Data'");
 
                // - Campaigns <-> Ads
-               addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_forced_campaigns_ads`');
+               addDropTableSql('forced_campaigns_ads');
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_forced_campaigns_ads` (
 `forced_campaign_ads_id` BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
 `forced_campaign_id` BIGINT( 20 ) UNSIGNED NULL DEFAULT NULL ,
@@ -99,7 +99,7 @@ PRIMARY KEY ( `forced_campaign_ads_id` )
 ) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Forced Campaigns<->Ads'");
 
                // - Campaigns <-> User
-               addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_forced_campaigns_user`');
+               addDropTableSql('forced_campaigns_user');
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_forced_campaigns_user` (
 `forced_id` BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
 `forced_campaign_id` BIGINT( 20 ) UNSIGNED NULL DEFAULT NULL ,
@@ -111,7 +111,7 @@ PRIMARY KEY ( `forced_id` )
 ) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Forced Campaigns<->User'");
 
                // - Campaign costs
-               addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_forced_costs`');
+               addDropTableSql('forced_costs');
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_forced_costs` (
 `forced_costs_id` BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
 `forced_costs_price_click` FLOAT( 20, 5 ) UNSIGNED NULL DEFAULT NULL ,
@@ -121,7 +121,7 @@ PRIMARY KEY ( `forced_costs_id` )
 ) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Forced Campaign Costs'");
 
                // - Campaign Statistics
-               addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_forced_stats`');
+               addDropTableSql('forced_stats');
                addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_forced_stats` (
 `forced_stats_id` BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
 `forced_stats_campaign_id` BIGINT( 20 ) UNSIGNED NULL DEFAULT NULL ,
@@ -141,12 +141,12 @@ PRIMARY KEY ( `forced_stats_id` )
 
        case 'remove': // Do stuff when removing extension
                // SQL commands to run
-               addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_forced_ads`');
-               addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_forced_campaigns`');
-               addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_forced_campaigns_ads`');
-               addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_forced_campaigns_user`');
-               addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_forced_costs`');
-               addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_forced_stats`');
+               addDropTableSql('forced_ads');
+               addDropTableSql('forced_campaigns');
+               addDropTableSql('forced_campaigns_ads');
+               addDropTableSql('forced_campaigns_user');
+               addDropTableSql('forced_costs');
+               addDropTableSql('forced_stats');
                break;
 
        case 'activate': // Do stuff when admin activates this extension