Changeset 645


Ignore:
Timestamp:
11/30/08 09:38:47 (6 years ago)
Author:
lowjoel
Message:

Updated the schema a little.

Location:
branches/website
Files:
1 added
1 edited

Legend:

Unmodified
Added
Removed
  • branches/website/updates/index.php

    r643 r645  
    1212 
    1313//Output the list of mirrors 
    14 $query = mysql_query('SELECT * FROM mirrors ORDER By Continent, Country, City'); 
     14$query = mysql_query('SELECT * FROM updater_mirrors ORDER By Continent, Country, City'); 
    1515echo '  <mirrors> 
    1616    <mirror location="(automatically decide)">http://downloads.sourceforge.net/eraser/</mirror>' . "\n"; 
     
    2323 
    2424//Prepare the list of updates 
    25 $query = mysql_query(sprintf('SELECT * FROM downloads WHERE 
    26     (MinVersion IS NULL AND MaxVersion IS NULL) OR 
    27     (MinVersion IS NULL AND MaxVersion > \'%1$s\') OR 
    28     (MinVersion <= \'%1$s\' AND MaxVersion IS NULL) OR 
    29     (MinVersion <= \'%1$s\' AND MaxVersion > \'%1$s\') 
     25$query = mysql_query(sprintf('SELECT updater_downloads.*, updater_publishers.Name as PublisherName 
     26    FROM updater_downloads 
     27    INNER JOIN updater_publishers ON 
     28        updater_downloads.PublisherID=updater_publishers.PublisherID 
     29    WHERE 
     30        (MinVersion IS NULL AND MaxVersion IS NULL) OR 
     31        (MinVersion IS NULL AND MaxVersion > \'%1$s\') OR 
     32        (MinVersion <= \'%1$s\' AND MaxVersion IS NULL) OR 
     33        (MinVersion <= \'%1$s\' AND MaxVersion > \'%1$s\') 
    3034    ORDER BY `Type` ASC', $version)); 
    3135 
Note: See TracChangeset for help on using the changeset viewer.