X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-payout.php;h=7994ab2d1cce202ec1a8043545aed960804b65e5;hb=fe6fe72f6e020b48d22956e38a970a05d04a8051;hp=dae6531eb2c47ba3565c489efeacc22d94f75388;hpb=5c4d360166de238420eec3e5f4e694befb09ab5d;p=mailer.git diff --git a/inc/extensions/ext-payout.php b/inc/extensions/ext-payout.php index dae6531eb2..7994ab2d1c 100644 --- a/inc/extensions/ext-payout.php +++ b/inc/extensions/ext-payout.php @@ -43,14 +43,14 @@ if (!defined('__SECURITY')) { // Version of this extension setThisExtensionVersion('0.3.8'); -// Version history array (add more with , '0.1.0' and so on) -setExtensionVersionHistory(array('0.0', '0.1.0', '0.1.1', '0.1.2', '0.1.3', '0.1.4', '0.1.5', '0.1.6', '0.1.7', '0.1.8', '0.1.9', '0.2.0', '0.2.1', '0.2.2', '0.2.3', '0.2.4', '0.2.5', '0.2.6', '0.2.7', '0.2.8', '0.2.9', '0.3.0', '0.3.1', '0.3.2', '0.3.3', '0.3.4', '0.3.5', '0.3.6', '0.3.7', '0.3.8')); +// Version history array (add more with , '0.0.1' and so on) +setExtensionVersionHistory(array('0.0.0', '0.1.0', '0.1.1', '0.1.2', '0.1.3', '0.1.4', '0.1.5', '0.1.6', '0.1.7', '0.1.8', '0.1.9', '0.2.0', '0.2.1', '0.2.2', '0.2.3', '0.2.4', '0.2.5', '0.2.6', '0.2.7', '0.2.8', '0.2.9', '0.3.0', '0.3.1', '0.3.2', '0.3.3', '0.3.4', '0.3.5', '0.3.6', '0.3.7', '0.3.8')); 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 @@ -95,8 +100,7 @@ PRIMARY KEY (`id`) break; case 'update': // Update an extension - switch (getCurrentExtensionVersion()) - { + 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"); @@ -234,7 +238,7 @@ PRIMARY KEY (`id`) // Update notes (these will be set as task text!) setExtensionUpdateNotes("Fehlerhinweis bei deaktivierter Erweiterung verbessert."); break; - } + } // END - switch break; case 'modify': // When the extension got modified