X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=inline;f=inc%2Fextensions%2Fext-payout.php;h=20cffee9d0d9f4f5ca6edf843db1eebe500e9a9d;hb=d3a1d413e55a4f7ed797d496469b3ba50e9cba33;hp=345965b2be17290fcd20693cfe809e0265215924;hpb=8f37a3b2708cfc4b4ef266f4be813a84511daa8f;p=mailer.git
diff --git a/inc/extensions/ext-payout.php b/inc/extensions/ext-payout.php
index 345965b2be..20cffee9d0 100644
--- a/inc/extensions/ext-payout.php
+++ b/inc/extensions/ext-payout.php
@@ -17,7 +17,7 @@
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
* Copyright (c) 2009 - 2011 by Mailer Developer Team *
- * For more information visit: http://www.mxchange.org *
+ * 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,21 +59,26 @@ 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);
- addMemberMenuSql('main','payout','Auszahlungen','N','N',11);
+
+ // Member menu
+ addMemberMenuSql('main', 'payout', 'Auszahlungen', 11);
break;
case 'remove': // Do stuff when removing extension
@@ -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 member_payout.tpl.");
+ setExtensionUpdateNotes("Auflistung der Auszahlungen ausgelagert in Template member_payout.tpl.");
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.");