X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-payout.php;h=c79b935663ff9fad7d0bcd2b3683b4ae89f1aaa3;hp=be3ef40a8e2d95a7a009632938ca3433dce67a63;hb=c5a4b89497cf1430b387b43e0c7808ef6dac0acd;hpb=7f104f6fe558bb56b4205241435a2357c2feece1

diff --git a/inc/extensions/ext-payout.php b/inc/extensions/ext-payout.php
index be3ef40a8e..c79b935663 100644
--- a/inc/extensions/ext-payout.php
+++ b/inc/extensions/ext-payout.php
@@ -48,17 +48,17 @@ $EXT_VER_HISTORY = array("0.0", "0.1", "0.1.1", "0.1.2", "0.1.3", "0.1.4", "0.1.
 
 switch ($EXT_LOAD_MODE)
 {
-case "register": // Do stuff when installtion is running (modules.php?module=admin&action=login is called)
+case "register": // Do stuff when installation is running (modules.php?module=admin&action=login is called)
 	// SQL commands to run
 	$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_user_payouts";
 	$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_user_payouts (
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
-userid BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
-payout_total DOUBLE(22,3) UNSIGNED NOT NULL DEFAULT '0.000',
+userid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+payout_total FLOAT(22,3) UNSIGNED NOT NULL DEFAULT '0.000',
 target_account VARCHAR(255) NOT NULL DEFAULT '',
 target_bank VARCHAR(255) NOT NULL DEFAULT '',
-payout_id BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
-payout_timestamp VARCHAR(10) NOT NULL DEFAULT '0',
+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',
 KEY(userid),
 KEY(payout_id),
@@ -68,13 +68,13 @@ PRIMARY KEY(id)
 	$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_payout_types (
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 type VARCHAR(255) NOT NULL DEFAULT '',
-rate DOUBLE(22,3) UNSIGNED NOT NULL DEFAULT '0.000',
-min_points BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+rate FLOAT(22,3) UNSIGNED NOT NULL DEFAULT '0.000',
+min_points BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 PRIMARY KEY(id)
 ) TYPE=MyISAM";
-	$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES('setup','config_payouts','Auszahlungen','Auszahlungsarten einstellen, neu anlegen oder löschen.','15')";
-	$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES('payouts','list_payouts','Anfragen auflisten','Listet alle Auszahlungsanfragen Ihrer Mitglieder auf.','16')";
-	$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_member_menu (`action`,`what`,`title`,`visible`,`locked`,`sort`) VALUES('main','payout','Auszahlungen','N','N','11')";
+	$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','config_payouts','Auszahlungen','Auszahlungsarten einstellen, neu anlegen oder löschen.','15')";
+	$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('payouts','list_payouts','Anfragen auflisten','Listet alle Auszahlungsanfragen Ihrer Mitglieder auf.','16')";
+	$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_member_menu (`action`,`what`,`title`,`visible`,`locked`,`sort`) VALUES ('main','payout','Auszahlungen','N','N','11')";
 	break;
 
 case "remove": // Do stuff when removing extension
@@ -92,14 +92,14 @@ case "activate": // Do stuff when admin activates this extension
 
 case "deactivate": // Do stuff when admin deactivates this extension
 	// SQL commands to run
-	$SQLs[] = "UPDATE "._MYSQL_PREFIX."_member_menu SET visible='Y', locked='Y' WHERE what='payout' LIMIT 1";
+	$SQLs[] = "UPDATE "._MYSQL_PREFIX."_member_menu SET visible='N', locked='Y' WHERE what='payout' LIMIT 1";
 	break;
 
 case "update": // Update an extension
 	switch ($EXT_VER)
 	{
 	case "0.1.2": // SQL queries for v0.1.2
-		$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES('payouts', NULL, 'Auszahlungsmanagement','Management der Auszahlungsarten.','8')";
+		$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('payouts', NULL, 'Auszahlungsmanagement','Management der Auszahlungsarten.','8')";
 		$SQLs[] = "UPDATE "._MYSQL_PREFIX."_admin_menu SET action='payouts', title='Einstellungen' WHERE action='setup' AND what='config_payouts' LIMIT 1";
 		break;
 
@@ -143,8 +143,8 @@ case "update": // Update an extension
 		break;
 
 	case "0.2.1": // SQL queries for v0.2.1
-		$SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_payouts CHANGE payout_total payout_total DOUBLE(22,5) NOT NULL DEFAULT '0.00000'";
-		$SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types CHANGE rate rate DOUBLE(22,5) NOT NULL DEFAULT '0.00000'";
+		$SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_payouts CHANGE payout_total payout_total FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000";
+		$SQLs[] = "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!)
 		$UPDATE_NOTES = "Problem mit Speicherung der Einstellungen beseitigt.";
@@ -242,8 +242,5 @@ default: // Do stuff when extension is loaded
 	break;
 }
 
-// Language file prefix
-$EXT_LANG_PREFIX = "payout";
-
 //
 ?>