X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-order.php;h=87b84ce3b43c9a8adbdda49125518a8991b4113a;hb=e17685c65d1a48c061b7c4f64c7a23c165430460;hp=22b73c559a44a3d37346571a45d2fdb96a4299b4;hpb=c3b4eaf29946349ff058691db2dcb615a5379bb2;p=mailer.git

diff --git a/inc/extensions/ext-order.php b/inc/extensions/ext-order.php
index 22b73c559a..87b84ce3b4 100644
--- a/inc/extensions/ext-order.php
+++ b/inc/extensions/ext-order.php
@@ -49,11 +49,12 @@ setExtensionVersionHistory(array('0.0', '0.1.0', '0.1.1', '0.1.2', '0.1.3', '0.1
 switch (getExtensionMode()) {
 	case 'register': // Do stuff when installation is running (modules.php?module=admin is called)
 		// SQL commands to run
-		addMemberMenuSql('order','order','Mailbuchung','N','Y',1);
+		addMemberMenuSql('order', 'order', 'Mailbuchung', 'N', 'Y', 1);
 		break;
 
 	case 'remove': // Do stuff when removing extension
 		// SQL commands to run
+		addDropTableSql('url_blacklist');
 		addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `what`='config_order' LIMIT 1");
 		addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE `action`='order'");
 		break;
@@ -73,7 +74,7 @@ switch (getExtensionMode()) {
 	case 'update': // Update an extension
 		switch (getCurrentExtensionVersion()) {
 			case '0.1.0': // SQL queries for v0.1
-				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `order_max_full` ENUM('ORDER','MAX') NOT NULL DEFAULT 'MAX'");
+				addConfigAddSql('order_max_full', "ENUM('ORDER','MAX') NOT NULL DEFAULT 'MAX'");
 				addAdminMenuSql('setup','config_order','Mailbuchungsseite','Einstellungen am Mailbuchungsformular.',7);
 
 				// Update notes (these will be set as task text!)
@@ -140,10 +141,10 @@ switch (getExtensionMode()) {
 				break;
 
 			case '0.2.3': // SQL queries for v0.2.3
-				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD order_min BIGINT(20) UNSIGNED NOT NULL DEFAULT 10");
+				addConfigAddSql('order_min', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT 10');
 
 				// Update notes (these will be set as task text!)
-				setExtensionUpdateNotes("Minimum an Empfänger pro Mailbuchung einstellbar. Standart: 10 Empfänger");
+				setExtensionUpdateNotes("Minimum an Empfänger pro Mailbuchung einstellbar. Standard: 10 Empfänger");
 				break;
 
 			case '0.2.4': // SQL queries for v0.2.4
@@ -192,8 +193,8 @@ nicht die vom Mitglied eingegebene. Resultat: Das Script beschwerte sich, der Us
 				break;
 
 			case '0.3.1': // SQL queries for v0.3.1
-				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD order_select VARCHAR(255) NOT NULL DEFAULT 'userid'");
-				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD order_mode ENUM('ASC','DESC') NOT NULL DEFAULT 'DESC'");
+				addConfigAddSql('order_select', "VARCHAR(255) NOT NULL DEFAULT 'userid'");
+				addConfigAddSql('order_mode', "ENUM('ASC','DESC') NOT NULL DEFAULT 'DESC'");
 
 				// Update notes (these will be set as task text!)
 				setExtensionUpdateNotes("Beworbene URL wird nun getestet.");
@@ -270,8 +271,8 @@ nicht die vom Mitglied eingegebene. Resultat: Das Script beschwerte sich, der Us
 				break;
 
 			case '0.4.6': // SQL queries for v0.4.6
-				addMemberMenuSql('order',NULL,'Mailbuchungen','N','Y',3);
-				addMemberMenuSql('order','order2','Framekiller-Mails','N','Y',2);
+				addMemberMenuSql('order', NULL, 'Mailbuchungen', 'N', 'Y', 3);
+				addMemberMenuSql('order', 'order2', 'Framekiller-Mails', 'N', 'Y', 2);
 				addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `action`='order', `sort`=1, `title`='Klick-Mails' WHERE `what`='order' LIMIT 1");
 
 				// Update notes (these will be set as task text!)
@@ -291,15 +292,15 @@ nicht die vom Mitglied eingegebene. Resultat: Das Script beschwerte sich, der Us
 				break;
 
 			case '0.4.9': // SQL queries for v0.4.9
-				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD repay_deleted_mails ENUM('REPAY','JACKPOT','SHRED') NOT NULL DEFAULT 'REPAY'");
+				addConfigAddSql('repay_deleted_mails', "ENUM('REPAY','JACKPOT','SHRED') NOT NULL DEFAULT 'REPAY'");
 
 				// Update notes (these will be set as task text!)
 				setExtensionUpdateNotes("Bei Löschung von Mailbuchungen kann nun scripteweit entschieden werden (Einstellungen also), ob die verbliebenen {?POINTS?} wieder gutgeschrieben werden sollen oder in den Jackpot landen.");
 				break;
 
 			case '0.5.0': // SQL queries for v0.5.0
-				addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_url_blacklist`');
-				addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_url_blacklist` (
+				addDropTableSql('url_blacklist');
+				addCreateTableSql('url_blacklist', "(
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `url` VARCHAR(255) NOT NULL DEFAULT '',
 `pool_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
@@ -313,10 +314,10 @@ INDEX (`pool_id`)
 				break;
 
 			case '0.5.2': // SQL queries for v0.5.2
-				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` DROP `test_text`");
-				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` DROP `test_subj`");
-				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `allow_url_in_text` ENUM('Y','N') NOT NULL DEFAULT 'N'");
-				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `allow_url_in_subject` ENUM('Y','N') NOT NULL DEFAULT 'N'");
+				addConfigDropSql('test_text');
+				addConfigDropSql('test_subj');
+				addConfigAddSql('allow_url_in_text', "ENUM('Y','N') NOT NULL DEFAULT 'N'");
+				addConfigAddSql('allow_url_in_subject', "ENUM('Y','N') NOT NULL DEFAULT 'N'");
 
 				// Update notes (these will be set as task text!)
 				setExtensionUpdateNotes("Inkonsistenz in Konfigurationsnamen korregiert.");
@@ -327,7 +328,7 @@ INDEX (`pool_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