Overall performance increased

[mailer.git] / inc / extensions / ext-payout.php

diff --git a/inc/extensions/ext-payout.php b/inc/extensions/ext-payout.php
index dfaf38b4b9ffc2d23648278d62c6bc71373735c4..2951770584a269f994c91699daf82c1cee939553 100644 (file)
--- a/inc/extensions/ext-payout.php
+++ b/inc/extensions/ext-payout.php
@@ -59,7 +59,7 @@ 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',
-status ENUM('NEW', 'ACCEPTED', 'REJECTED') NOT NULL DEFAULT 'NEW',
+status ENUM('NEW','ACCEPTED','REJECTED') NOT NULL DEFAULT 'NEW',
 KEY(userid),
 KEY(payout_id),
 PRIMARY KEY(id)
@@ -72,9 +72,9 @@ rate DOUBLE(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
@@ -99,7 +99,7 @@ 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;
 
@@ -109,7 +109,7 @@ case "update": // Update an extension
                $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types ADD engine_url VARCHAR(255) NOT NULL DEFAULT ''";
                $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types ADD engine_ret_ok VARCHAR(255) NOT NULL DEFAULT ''";
                $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types ADD engine_ret_failed VARCHAR(255) NOT NULL DEFAULT ''";
-               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types ADD pass_enc ENUM('md5', 'base64', 'none') NOT NULL DEFAULT 'md5'";
+               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types ADD pass_enc ENUM('md5','base64','none') NOT NULL DEFAULT 'md5'";
                break;
 
        case "0.1.4": // SQL queries for v0.1.4
@@ -120,11 +120,11 @@ case "update": // Update an extension
                $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_payouts ADD target_url LONGBLOB NOT NULL";
                $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_payouts ADD banner_url LONGBLOB NOT NULL";
                $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_payouts ADD link_text VARCHAR(30) NOT NULL DEFAULT ''";
-               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types ADD allow_url ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
+               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types ADD allow_url ENUM('Y','N') NOT NULL DEFAULT 'N'";
                break;
 
        case "0.1.6": // SQL queries for v0.1.6
-               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types CHANGE pass_enc pass_enc ENUM('md5', 'base64', 'xxx') NOT NULL DEFAULT 'xxx'";
+               $SQLs[] = "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