X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-payout.php;h=421771e65f69f540965dbd4c9e9f218c324e9375;hb=96d8f54d3fee1d51c38dd6b79c28215f7f5c83ec;hp=91b9fba016ab725df9bed7fbdb3ad2dd95dd473b;hpb=9f30db83eedcaf1d265d973e4bffcd3fa7df9bde;p=mailer.git

diff --git a/inc/extensions/ext-payout.php b/inc/extensions/ext-payout.php
index 91b9fba016..421771e65f 100644
--- a/inc/extensions/ext-payout.php
+++ b/inc/extensions/ext-payout.php
@@ -16,8 +16,8 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2011 by Mailer Developer Team                   *
- * For more information visit: http://www.mxchange.org                  *
+ * Copyright (c) 2009 - 2012 by Mailer Developer Team                   *
+ * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
  * it under the terms of the GNU General Public License as published by *
@@ -50,7 +50,7 @@ switch (getExtensionMode()) {
 	case 'register': // Do stuff when installation is running
 		// SQL commands to run
 		addDropTableSql('user_payouts');
-		addCreateTableSql('user_payouts', "(
+		addCreateTableSql('user_payouts', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `payout_total` FLOAT(22,3) UNSIGNED NOT NULL DEFAULT 0.000,
@@ -59,20 +59,25 @@ switch (getExtensionMode()) {
 `payout_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `payout_timestamp` VARCHAR(10) NOT NULL DEFAULT 0,
 `status` ENUM('NEW','ACCEPTED','REJECTED') NOT NULL DEFAULT 'NEW',
+PRIMARY KEY (`id`),
 INDEX (`userid`),
-INDEX (`payout_id`),
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Done user payouts (and status)'");
+INDEX (`payout_id`)",
+			'Done user payouts (and status)');
+
 		addDropTableSql('payout_types');
-		addCreateTableSql('payout_types', "(
+		addCreateTableSql('payout_types', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `type` VARCHAR(255) NOT NULL DEFAULT '',
 `rate` FLOAT(22,3) UNSIGNED NOT NULL DEFAULT 0.000,
 `min_points` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Payout types'");
+PRIMARY KEY (`id`)",
+			'Payout types');
+
+		// Admin menu
 		addAdminMenuSql('setup','config_payouts','Auszahlungen','Auszahlungsarten einstellen, neu anlegen oder löschen.',15);
 		addAdminMenuSql('payouts','list_payouts','Anfragen auflisten','Listet alle Auszahlungsanfragen Ihrer Mitglieder auf.',16);
+
+		// Member menu
 		addMemberMenuSql('main', 'payout', 'Auszahlungen', 11);
 		break;
 
@@ -86,19 +91,19 @@ PRIMARY KEY (`id`)
 
 	case 'activate': // Do stuff when admin activates this extension
 		// SQL commands to run
-		addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `visible`='Y', `locked`='N' WHERE `what`='payout' LIMIT 1");
+		addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `visible`='Y',`locked`='N' WHERE `what`='payout' LIMIT 1");
 		break;
 
 	case 'deactivate': // Do stuff when admin deactivates this extension
 		// SQL commands to run
-		addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `visible`='N', `locked`='Y' WHERE `what`='payout' LIMIT 1");
+		addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `visible`='N',`locked`='Y' WHERE `what`='payout' LIMIT 1");
 		break;
 
 	case 'update': // Update an extension
 		switch (getCurrentExtensionVersion()) {
 			case '0.1.2': // SQL queries for v0.1.2
 				addAdminMenuSql('payouts', NULL, 'Auszahlungsmanagement','Management der Auszahlungsarten.',8);
-				addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_admin_menu` SET `action`='payouts', `title`='Einstellungen' WHERE `action`='setup' AND `what`='config_payouts' LIMIT 1");
+				addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_admin_menu` SET `action`='payouts',`title`='Einstellungen' WHERE `action`='setup' AND `what`='config_payouts' LIMIT 1");
 				break;
 
 			case '0.1.3': // SQL queries for v0.1.3
@@ -122,12 +127,12 @@ PRIMARY KEY (`id`)
 				break;
 
 			case '0.1.6': // SQL queries for v0.1.6
-				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_payout_types` CHANGE pass_enc pass_enc ENUM('md5','base64','xxx') NOT NULL DEFAULT 'xxx'");
+				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_payout_types` CHANGE `pass_enc` `pass_enc` ENUM('md5','base64','xxx') NOT NULL DEFAULT 'xxx'");
 				break;
 
 			case '0.1.8': // SQL queries for v0.1.8
 				// Update notes (these will be set as task text!)
-				setExtensionUpdateNotes("Auflistung der Auszahlungen ausgelagert in Template <em>member_payout.tpl</em>.");
+				setExtensionUpdateNotes("Auflistung der Auszahlungen ausgelagert in Template <span class=\"bad\">member_payout.tpl</span>.");
 				break;
 
 			case '0.1.9': // SQL queries for v0.1.9
@@ -141,8 +146,8 @@ PRIMARY KEY (`id`)
 				break;
 
 			case '0.2.1': // SQL queries for v0.2.1
-				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_user_payouts` CHANGE payout_total payout_total FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000");
-				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_payout_types` CHANGE rate rate FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000");
+				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_user_payouts` CHANGE `payout_total` `payout_total` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000");
+				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_payout_types` CHANGE `rate` `rate` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000");
 
 				// Update notes (these will be set as task text!)
 				setExtensionUpdateNotes("Problem mit Speicherung der Einstellungen beseitigt.");