X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fextensions%2Fext-sponsor.php;h=7fe78722ac049d4d97cd668d5aec7144b559114d;hb=ac44d82d5d014d6eb388813e51c34497214d76dd;hp=d31bbffea46fdd66f0b56b0fd894cedeaf56580c;hpb=9725980ca9c052e5c1a9edb8b815e8506b876448;p=mailer.git

diff --git a/inc/extensions/ext-sponsor.php b/inc/extensions/ext-sponsor.php
index d31bbffea4..7fe78722ac 100644
--- a/inc/extensions/ext-sponsor.php
+++ b/inc/extensions/ext-sponsor.php
@@ -60,7 +60,7 @@ switch (getExtensionMode()) {
 		//
 		// Sponsor data
 		//
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_sponsor_data`');
+		addDropTableSql('sponsor_data');
 		addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_sponsor_data` (
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `company` VARCHAR(255) NOT NULL DEFAULT '',
@@ -102,7 +102,7 @@ PRIMARY KEY (`id`)
 		//
 		// Sponsor orders
 		//
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_sponsor_orders`');
+		addDropTableSql('sponsor_orders');
 		addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_sponsor_orders` (
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `sponsor_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
@@ -122,7 +122,7 @@ PRIMARY KEY (`id`)
 		//
 		// Pay-types
 		//
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_sponsor_paytypes`');
+		addDropTableSql('sponsor_paytypes');
 		addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_sponsor_paytypes` (
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `pay_name` VARCHAR(255) NOT NULL DEFAULT '',
@@ -134,7 +134,7 @@ PRIMARY KEY (`id`)
 		//
 		// Points-to-action converting
 		//
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_sponsor_action_convert`');
+		addDropTableSql('sponsor_action_convert');
 		addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_sponsor_action_convert` (
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `ext_name` VARCHAR(255) NOT NULL DEFAULT 'sponsor',
@@ -146,7 +146,7 @@ PRIMARY KEY (`id`)
 		//
 		// Sponsor menu system (default)
 		//
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_sponsor_menu`');
+		addDropTableSql('sponsor_menu');
 		addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_sponsor_menu` (
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `action` VARCHAR(255) NOT NULL DEFAULT '',
@@ -162,7 +162,7 @@ PRIMARY KEY (`id`)
 		//
 		// Registry for performable actions by your sponsors
 		//
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_sponsor_registry`');
+		addDropTableSql('sponsor_registry');
 		addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_sponsor_registry` (
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `admin_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
@@ -176,7 +176,7 @@ PRIMARY KEY (`id`)
 		//
 		// URLs from the sponsors
 		//
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_sponsor_urls`');
+		addDropTableSql('sponsor_urls');
 		addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_sponsor_urls` (
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `sponsor_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
@@ -190,7 +190,7 @@ PRIMARY KEY (`id`)
 		//
 		// Banners of any size from the sponsors
 		//
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_sponsor_banner`');
+		addDropTableSql('sponsor_banner');
 		addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_sponsor_banner` (
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `sponsor_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
@@ -206,7 +206,7 @@ PRIMARY KEY (`id`)
 		//
 		// Campaigns
 		//
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_sponsor_campaigns`');
+		addDropTableSql('sponsor_campaigns');
 		addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_sponsor_campaigns` (
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `sponsor_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
@@ -229,7 +229,7 @@ PRIMARY KEY (`id`)
 		//
 		// Campaigns + URLs + Banner
 		//
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_sponsor_campaign_assigns`');
+		addDropTableSql('sponsor_campaign_assigns');
 		addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_sponsor_campaign_assigns` (
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `campaignid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
@@ -245,7 +245,7 @@ PRIMARY KEY (`id`)
 		//
 		// Allowed data to display (administrative)
 		//
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_sponsor_admin_data`');
+		addDropTableSql('sponsor_admin_data');
 		addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_sponsor_admin_data` (
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `data_row` VARCHAR(255) NOT NULL DEFAULT '',
@@ -255,7 +255,7 @@ PRIMARY KEY (`id`)
 		//
 		// Allowed data to display (sponsor-side)
 		//
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_sponsor_display_data`');
+		addDropTableSql('sponsor_display_data');
 		addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_sponsor_display_data` (
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `sponsor_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
@@ -387,18 +387,18 @@ PRIMARY KEY (`id`)
 
 	case 'remove': // Do stuff when removing extension
 		// SQL commands to run
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_sponsor_data`');
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_sponsor_orders`');
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_sponsor_action_convert`');
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_sponsor_paytypes`');
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_sponsor_menu`');
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_sponsor_registry`');
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_sponsor_urls`');
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_sponsor_banner`');
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_sponsor_campaigns`');
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_sponsor_campaign_assigns`');
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_sponsor_admin_data`');
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_sponsor_display_data`');
+		addDropTableSql('sponsor_data');
+		addDropTableSql('sponsor_orders');
+		addDropTableSql('sponsor_action_convert');
+		addDropTableSql('sponsor_paytypes');
+		addDropTableSql('sponsor_menu');
+		addDropTableSql('sponsor_registry');
+		addDropTableSql('sponsor_urls');
+		addDropTableSql('sponsor_banner');
+		addDropTableSql('sponsor_campaigns');
+		addDropTableSql('sponsor_campaign_assigns');
+		addDropTableSql('sponsor_admin_data');
+		addDropTableSql('sponsor_display_data');
 		addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `action`='sponsor' OR `what` IN('repr_sponsor','sponsor_medit','sponsor_madd')");
 		addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_guest_menu` WHERE `action`='sponsor'");
 		addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE `what` IN('sponsor_list','sponsor_reg')");