X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-bonus.php;h=3da3ec1cfe7d8ea4ea6eb37c61c2470a29336df6;hp=256675914b32b9a8549043d89f4e0438b67d0d6b;hb=16b311c338bb4f8436e2ed9e76cb1cd5f3741640;hpb=c4823d28fd0bd22250b16d73f2034f36fc54abda

diff --git a/inc/extensions/ext-bonus.php b/inc/extensions/ext-bonus.php
index 256675914b..3da3ec1cfe 100644
--- a/inc/extensions/ext-bonus.php
+++ b/inc/extensions/ext-bonus.php
@@ -54,7 +54,7 @@ switch (getExtensionMode()) {
 		// SQL commands to run
 		addAdminMenuSql('email','send_bonus','Bonusmail senden','Versenden Sie hier Bonus-Mails an alle Mitglieder oder nur an alle aus einer Kategorie. Es spielt keine Rolle, wie viele Mails bereits versendet worden, Sie können hier immer senden.', 5);
 		addMemberMenuSql('main','bonus','Bonuspunkte','N','Y',7);
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_bonus`');
+		addDropTableSql('bonus`');
 		addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_bonus` (
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `cat_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
@@ -85,10 +85,10 @@ PRIMARY KEY  (`id`)
 		addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `what` IN ('bonus','config_bonus','send_bonus','list_bonus','list_notifications')");
 		addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE `what`='bonus' LIMIT 1");
 		addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_guest_menu` WHERE `action`='bonus'");
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_bonus`');
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_bonus_urls`');
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_bonus_customer`');
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_bonus_turbo`');
+		addDropTableSql('bonus');
+		addDropTableSql('bonus_urls');
+		addDropTableSql('bonus_customer');
+		addDropTableSql('bonus_turbo');
 
 		// Unregister filter
 		unregisterFilter(__FUNCTION__, __LINE__, 'member_login_check', 'ADD_LOGIN_BONUS', true, isExtensionDryRun());
@@ -138,7 +138,7 @@ PRIMARY KEY  (`id`)
 				break;
 
 			case '0.2.2': // SQL queries for v0.2.2
-				addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_bonus_turbo`');
+				addDropTableSql('bonus_turbo');
 				addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_bonus_turbo` (
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
@@ -171,8 +171,8 @@ INDEX `userid` (`userid`)
 				break;
 
 			case '0.2.5': // SQL queries for v0.2.5
-				addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_bonus_urls`');
-				addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_bonus_customer`');
+				addDropTableSql('bonus_urls');
+				addDropTableSql('bonus_customer');
 
 				// Update notes (these will be set as task text!)
 				setExtensionUpdateNotes("Tabellen <u>{?_MYSQL_PREFIX?}_bonus_urls</u> und <u>{?_MYSQL_PREFIX?}_bonus_customer</u> entfernt, da dies bald von der Erweiterung <u>sponsor</u> erledigt wird.");