Changeset 646

Timestamp:

11/30/2008 10:09:33 AM (5 years ago)

Author:

lowjoel

Message:

Okay, I finally tested the code.

File:

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

branches/website/updates/index.php

@@ -12 +12 @@
 
 //Output the list of mirrors
-$query = mysql_query('SELECT * FROM updater_mirrors ORDER By Continent, Country, City');
+$query = mysql_query('SELECT * FROM mirrors ORDER By Continent, Country, City');
 echo '  <mirrors>
-    <mirror location="(automatically decide)">http://downloads.sourceforge.net/eraser/</mirror>' . "\n";
+        <mirror location="(automatically decide)">http://downloads.sourceforge.net/eraser/</mirror>' . "\n";
 while ($row = mysql_fetch_array($query))
 {
@@ -23 +23 @@
 
 //Prepare the list of updates
-$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
+$query = mysql_query(sprintf('SELECT downloads.*, publishers.Name as PublisherName
+    FROM downloads
+    INNER JOIN publishers ON
+        downloads.PublisherID=publishers.PublisherID
     WHERE
         (MinVersion IS NULL AND MaxVersion IS NULL) OR
@@ -46 +46 @@
 
     printf('        <item name="%s" version="%s" publisher="%s" architecture="%s" filesize="%d">%s</item>
-', htmlentities($row['Name']), $row['Version'], htmlentities($row['Publisher']), $row['Architecture'],
+', htmlentities($row['Name']), $row['Version'], htmlentities($row['PublisherName']), $row['Architecture'],
             $row['Filesize'], htmlentities($row['Link']));
 }
 
+if (!empty($lastItemType))
+    printf('    </%s>' . "\n", $lastItemType);
 echo '</updateList>
 ';