SQL query fixed

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

diff --git a/inc/extensions/ext-doubler.php b/inc/extensions/ext-doubler.php
index 469547623e427a0c89c9366cbe433bff4011a0ab..1ba8512590461627074b07c4832c3d68162e201d 100644 (file)
--- a/inc/extensions/ext-doubler.php
+++ b/inc/extensions/ext-doubler.php
@@ -173,9 +173,6 @@ case "update": // Update an extension
                break;
 
        case "0.0.6": // SQL queries for v0.0.6
-               $SQLs[] = "UPDATE "._MYSQL_PREFIX."_config SET doubler_used=doubler_used+(SUM(d.points)*c.doubler_charge)
-FROM "._MYSQL_PREFIX."_doubler AS d, "._MYSQL_PREFIX."_config AS c
-WHERE d.completed='N'";
                $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_max_sent tinyint(4) not null default '1'";
                $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_group_sent tinyint(4) not null default '1'";
                $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_sent_all enum('Y', 'N') not null default 'Y'";
@@ -186,7 +183,7 @@ WHERE d.completed='N'";
 
        case "0.0.7": // SQL queries for v0.0.7
                // Update notes (these will be set as task text!)
-               $UPDATE_NOTES = "W&ouml;rter <STRONG>Mailtausch</STRONG>, <STRONG>Mailtausches</STRONG> und <STRONG>Mailtauscher</STRONG> sind austauschbar.<BR><BR>Minus-Guthaben des Verdoppler-Accounts repariert und Mitgliedsmail erweitert mit Transaktionsummer und IP-Nummer.";
+               $UPDATE_NOTES = "W&ouml;rter <STRONG>Mailtausch</STRONG>, <STRONG>Mailtausches</STRONG> und <STRONG>Mailtauscher</STRONG> sind austauschbar.<br /><br />Minus-Guthaben des Verdoppler-Accounts repariert und Mitgliedsmail erweitert mit Transaktionsummer und IP-Nummer.";
                break;
 
        case "0.0.8": // SQL queries for v0.0.8
@@ -199,7 +196,7 @@ WHERE d.completed='N'";
                $UPDATE_NOTES = "Abspeichern von Einstellungen repariert.";
                break;
 
-       case "0.1.0": // SQL queries for v0.1.0
+       case "0.1.0": // SQL queries for v0.2.1
                // Update notes (these will be set as task text!)
                $UPDATE_NOTES = "Vorbereitung auf die neue Mediendaten v0.0.4.";
                break;
@@ -239,29 +236,29 @@ WHERE d.completed='N'";
        break;
 
 default: // Do stuff when extension is loaded
-       $DUMMY = LOAD_CONFIG("0");
-       $CONFIG['doubler_charge']      = $DUMMY['doubler_charge'];
-       $CONFIG['doubler_jackpot']     = $DUMMY['doubler_jackpot'];
-       $CONFIG['doubler_own']         = $DUMMY['doubler_own'];
-       $CONFIG['doubler_uid']         = $DUMMY['doubler_uid'];
-       $CONFIG['doubler_points']      = $DUMMY['doubler_points'];
-       $CONFIG['doubler_used']        = $DUMMY['doubler_used'];
-       $CONFIG['doubler_send_mode']   = $DUMMY['doubler_send_mode'];
-       $CONFIG['doubler_timeout']     = $DUMMY['doubler_timeout'];
-       $CONFIG['doubler_display_new'] = $DUMMY['doubler_display_new'];
-       $CONFIG['doubler_display_pay'] = $DUMMY['doubler_display_pay'];
-       $CONFIG['doubler_display_old'] = $DUMMY['doubler_display_old'];
-       $CONFIG['doubler_ref']         = $DUMMY['doubler_ref'];
-       $CONFIG['doubler_min']         = $DUMMY['doubler_min'];
-       $CONFIG['doubler_max']         = $DUMMY['doubler_max'];
-       $CONFIG['doubler_left']        = $DUMMY['doubler_left'];
-       $CONFIG['doubler_counter']     = $DUMMY['doubler_counter'];
-       $CONFIG['doubler_max_sent']    = $DUMMY['doubler_max_sent'];
-       $CONFIG['doubler_group_sent']  = $DUMMY['doubler_group_sent'];
-       $CONFIG['doubler_sent_all']    = $DUMMY['doubler_sent_all'];
-       unset($DUMMY);
-
-       if ((defined('__DAILY_RESET')) && ($CONFIG['doubler_send_mode'] == "RESET"))
+       $dummy = LOAD_CONFIG();
+       $_CONFIG['doubler_charge']      = $dummy['doubler_charge'];
+       $_CONFIG['doubler_jackpot']     = $dummy['doubler_jackpot'];
+       $_CONFIG['doubler_own']         = $dummy['doubler_own'];
+       $_CONFIG['doubler_uid']         = $dummy['doubler_uid'];
+       $_CONFIG['doubler_points']      = $dummy['doubler_points'];
+       $_CONFIG['doubler_used']        = $dummy['doubler_used'];
+       $_CONFIG['doubler_send_mode']   = $dummy['doubler_send_mode'];
+       $_CONFIG['doubler_timeout']     = $dummy['doubler_timeout'];
+       $_CONFIG['doubler_display_new'] = $dummy['doubler_display_new'];
+       $_CONFIG['doubler_display_pay'] = $dummy['doubler_display_pay'];
+       $_CONFIG['doubler_display_old'] = $dummy['doubler_display_old'];
+       $_CONFIG['doubler_ref']         = $dummy['doubler_ref'];
+       $_CONFIG['doubler_min']         = $dummy['doubler_min'];
+       $_CONFIG['doubler_max']         = $dummy['doubler_max'];
+       $_CONFIG['doubler_left']        = $dummy['doubler_left'];
+       $_CONFIG['doubler_counter']     = $dummy['doubler_counter'];
+       $_CONFIG['doubler_max_sent']    = $dummy['doubler_max_sent'];
+       $_CONFIG['doubler_group_sent']  = $dummy['doubler_group_sent'];
+       $_CONFIG['doubler_sent_all']    = $dummy['doubler_sent_all'];
+       unset($dummy);
+
+       if ((defined('__DAILY_RESET')) && ($_CONFIG['doubler_send_mode'] == "RESET"))
        {
                // So let's check for points
                $INC_POOL[] = PATH."inc/doubler_send.php";
@@ -273,7 +270,7 @@ default: // Do stuff when extension is loaded
 $EXT_LANG_PREFIX = "doubler";
 
 // Extension is always active?
-$EXT_ALWAYS_ACTIVE = "N";
+$EXT_ALWAYS_ACTIVE = 'N';
 
 //
 ?>