Changeset 645 for branches/website/updates/index.php

Timestamp:

11/30/2008 9:38:47 AM (4 years ago)

Author:

lowjoel

Message:

Updated the schema a little.

File:

• branches/website/updates/index.php (modified) (2 diffs)

branches/website/updates/index.php

@@ -12 +12 @@
 
 //Output the list of mirrors
-$query = mysql_query('SELECT * FROM mirrors ORDER By Continent, Country, City');
+$query = mysql_query('SELECT * FROM updater_mirrors ORDER By Continent, Country, City');
 echo '  <mirrors>
     <mirror location="(automatically decide)">http://downloads.sourceforge.net/eraser/</mirror>' . "\n";
@@ -23 +23 @@
 
 //Prepare the list of updates
-$query = mysql_query(sprintf('SELECT * FROM downloads WHERE
-    (MinVersion IS NULL AND MaxVersion IS NULL) OR
-    (MinVersion IS NULL AND MaxVersion > \'%1$s\') OR
-    (MinVersion <= \'%1$s\' AND MaxVersion IS NULL) OR
-    (MinVersion <= \'%1$s\' AND MaxVersion > \'%1$s\')
+$query = mysql_query(sprintf('SELECT updater_downloads.*, updater_publishers.Name as PublisherName
+    FROM updater_downloads
+    INNER JOIN updater_publishers ON
+        updater_downloads.PublisherID=updater_publishers.PublisherID
+    WHERE
+        (MinVersion IS NULL AND MaxVersion IS NULL) OR
+        (MinVersion IS NULL AND MaxVersion > \'%1$s\') OR
+        (MinVersion <= \'%1$s\' AND MaxVersion IS NULL) OR
+        (MinVersion <= \'%1$s\' AND MaxVersion > \'%1$s\')
     ORDER BY `Type` ASC', $version));