Changeset 1640 for branches/multiuser/cls
- Timestamp:
- 11/25/06 08:02:19 (2 years ago)
- Files:
-
- 1 modified
-
branches/multiuser/cls/channels.php (modified) (3 diffs)
Legend:
- Unmodified
- Added
- Removed
-
branches/multiuser/cls/channels.php
r1604 r1640 220 220 } 221 221 222 //get unread count per folder 222 //get unread count per folder 223 223 $sql = "select f.id, f.name, count(*) as cnt " 224 224 ." from " . getTable('item2user') ." i2u " … … 230 230 $sql .=" and i2u.flgprivate =0 "; 231 231 } 232 $sql .= " and c2u.flgdeleted=0 " ;232 $sql .= " and c2u.flgdeleted=0 " 233 233 ." group by f.id"; 234 234 _pf('query'); … … 255 255 ." from ".getTable("channels")." c " 256 256 . " inner join " . getTable("channels2user")." c2u on c2u.fkcid=c.id " 257 . " inner join " . getTable("folders") . " f .id = c.parent "257 . " inner join " . getTable("folders") . " f on f.id = c.parent " 258 258 259 259 ." where c2u.fkuid=" . rss_user_id();
