SQL query fixed
authorRoland Häder <roland@mxchange.org>
Tue, 5 Aug 2008 14:18:54 +0000 (14:18 +0000)
committerRoland Häder <roland@mxchange.org>
Tue, 5 Aug 2008 14:18:54 +0000 (14:18 +0000)
inc/extensions/ext-doubler.php

index 0f4b83d7e5c4ed893434ee4e3b0edfdcf83e1801..1ba8512590461627074b07c4832c3d68162e201d 100644 (file)
@@ -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'";