Changeset 1313 for trunk/website/scripts/downloads.php

Timestamp:

11/14/2009 4:28:52 AM (4 years ago)

Author:

lowjoel

Message:

Make sure only that the last 3 nightly builds are available at any one time.

File:

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

trunk/website/scripts/downloads.php

@@ -217 +217 @@
         }
         
+        //Insert the build into the database.
         mysql_query('START TRANSACTION');
         mysql_query(sprintf('INSERT INTO downloads (Name, Released, `Type`, Version, PublisherID, Architecture, Filesize, Link)
@@ -237 +238 @@
         
         mysql_query('COMMIT');
+        
+        //Ensure that only 3 builds are not superseded at any one time.
+        mysql_query('START TRANSACTION');
+        mysql_query(sprintf('UPDATE downloads SET Superseded=1
+            WHERE Name LIKE \'%s%%\'', $path));
+        mysql_query(sprintf('UPDATE downloads SET Superseded=0
+            WHERE Name LIKE \'%s%%\'
+            ORDER BY DownloadID DESC
+            LIMIT 3', $path));
+        mysql_query('COMMIT');
+
         return $buildId;
     }