Changeset 1544 for trunk/gregarius/api.php

Timestamp:

08/24/06 01:14:02 (4 years ago)

Author:

cfriesen

Message:

Feel free to scream if this breaks something...

Files:

• trunk/gregarius/api.php (modified) (2 diffs)

trunk/gregarius/api.php

@@ -66 +66 @@
     $sql = "select "
            ." c.id, c.title, c.url, c.siteurl, f.name "
-           ." from ".getTable("channels")." c, "
-           .getTable("folders")." f "." where f.id = c.parent";
+           ." from ".getTable("channels")." c "
+           ." inner join " . getTable("folders")." f "
+           ."  on f.id = c.parent";
 
     if (hidePrivate()) {
@@ -135 +136 @@
            ." c.descr as cdescr, c.url as curl, i.author as iauth, i.url as iurl, "
            ." unix_timestamp(ifnull(i.pubdate, i.added)) as idate ,i.id as iid"
-           ." from ".getTable('item')." i, ".getTable('channels') ." c "
-           ." where i.cid=c.id and i.unread & ". RSS_MODE_UNREAD_STATE ." and c.id=$cid";
+           ." from ".getTable('item')." i "
+           ." inner join " .getTable('channels') ." c "
+           ."  on c.id = i.cid "
+           ." where i.unread & ". RSS_MODE_UNREAD_STATE ." and c.id=$cid";
 
     if ($date) {