Changeset 1759 for branches/multiuser/cls/channels.php

Timestamp:

09/26/07 08:57:31 (14 months ago)

Author:

mdodoo

Message:

Lots of things are still not working, but I think this code is better than what was currently committed ([1639]
should have been reverted, and the person who committed should have had their SVN access pulled, for example).
Created this by grabbing the trunk code and then manually inserting the MU branch's changes in. This is probably
not usable in an actual installation (no support for creating new user accounts yet, for example), but patches are
welcome.

Not sure why I write so much here - I am not sure anyone other than my fellow devs actually read them...

Files:

• branches/multiuser/cls/channels.php (modified) (3 diffs)

branches/multiuser/cls/channels.php

@@ -224 +224 @@
             ." from " . getTable('item2user') ." i2u "
             . " inner join " . getTable('channels2user') . " c2u on c2u.fkuid=" . rss_user_id()
-            . " inner join " . getTable('folders') ." f on c2u.parent=f.id"
+            . " inner join " . getTable('channels') . " c on c.id = c2u.fkcid"
+            . " inner join " . getTable('folders') ." f on c.parent=f.id"
             ." where i2u.flgunread =1 "
             ." and i2u.flgdeleted=0 ";
@@ -252 +253 @@
         _pf('FeedList->populate() ...');
         $sql = "select "
-        ." c.id, c.title, c.url, c.siteurl, f.name, c2u.parent, c2u.icon, c.descr, c2u.flgdeleted,c2u.flgprivate "
+        ." c.id, c.title, c.url, c.siteurl, f.name, c.parent, c2u.icon, c.descr, c2u.flgdeleted,c2u.flgprivate "
         ." from ".getTable("channels")." c "
         . " inner join " . getTable("channels2user")." c2u on c2u.fkcid=c.id "
@@ -265 +266 @@
 
         if (getConfig('rss.config.absoluteordering')) {
-            $sql .= " order by f.position asc, c2u.position asc";
+            $sql .= " order by f.position asc, c.position asc";
         } else {
             $sql .= " order by f.name, c.title asc";