Changeset 1766

Timestamp:

2/8/2010 6:54:30 AM (3 years ago)

Author:

lowjoel

Message:

• Fixed naming of the download: Just add Eraser to the version number, and there's no need for branch name since it's implicit in the full version number
• Fixed the algorithm to set superseded status on old builds

File:

• trunk/website/scripts/downloads.php (modified) (2 diffs)

trunk/website/scripts/downloads.php

@@ -257 +257 @@
         mysql_query(sprintf('INSERT INTO downloads (Name, Released, `Type`, Version, PublisherID, Architecture, Filesize, Link)
                 VALUES (
-                    \'%1$s %2$s.%3$d\', \'%5$s\' , \'build\', \'%2$s.%3$d\', 1, \'any\', %4$d, \'?%6$s\'
+                    \'Eraser %1$s.%2$d\', \'%4$s\' , \'build\', \'%1$s.%2$d\', 1, \'any\', %3$d, \'?%5$s\'
                 )',
-            mysql_real_escape_string($branch), mysql_real_escape_string($version), intval($revision),
+            mysql_real_escape_string($version), intval($revision),
             $installerSize, PhpToMySqlTimestamp(filemtime($buildPath)),
             mysql_real_escape_string($installerPath)))
@@ -293 +293 @@
         mysql_query(sprintf('UPDATE downloads SET Superseded=1
             WHERE DownloadID IN (
-                SELECT DownloadID FROM builds
+                SELECT downloads.DownloadID FROM downloads
+                    INNER JOIN builds ON downloads.DownloadID=builds.DownloadID
                     WHERE Branch=\'%s\' AND
                     Superseded=0 AND
-                    DownloadID NOT IN (%s)
+                    downloads.DownloadID NOT IN (%s)
             )',
             mysql_real_escape_string($branch), $ignoredBuilds));