Changeset 1744 for trunk

Timestamp:

07/16/07 20:43:31 (17 months ago)

Author:

mbonetti

Message:

Fix for [487] - do not export deprecated feeds

Files:

• trunk/gregarius/opml.php (modified) (1 diff)

trunk/gregarius/opml.php

@@ -137 +137 @@
       ." c.id, c.title, c.url, c.siteurl, d.name, c.parent, c.descr "
       ." from ". getTable("channels") . " c "
-      ." inner join " . getTable("folders") ." d on d.id = c.parent ";
+      ." inner join " . getTable("folders") ." d on d.id = c.parent "
+      ." where not (c.mode & ".  RSS_MODE_DELETED_STATE .") ";
       
     if (hidePrivate()) {
-        $sql .=" where not(c.mode & " . RSS_MODE_PRIVATE_STATE .") ";         
+        $sql .=" and not(c.mode & " . RSS_MODE_PRIVATE_STATE .") ";       
     }