Show
Ignore:
Timestamp:
08/24/06 01:14:02 (4 years ago)
Author:
cfriesen
Message:

Feel free to scream if this breaks something...

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • trunk/gregarius/cls/update.php

    r1516 r1544  
    7676 
    7777    function populate($updatePrivateAlso = false) { 
    78         $sql = "select c.id, c.url, c.title from ".getTable("channels") . " c, " 
    79                . getTable('folders') . " f "; 
    80         $sql .= " where not(c.mode & ".RSS_MODE_DELETED_STATE.") "; 
    81         $sql .= " and c.parent = f.id "; 
     78        $sql = "select c.id, c.url, c.title from ".getTable("channels") . " c " 
     79             . " inner join " . getTable('folders') . " f on f.id = c.parent " 
     80             . " where not(c.mode & ".RSS_MODE_DELETED_STATE.") "; 
    8281 
    8382        if (hidePrivate() && !$updatePrivateAlso) {