Changeset 841

Timestamp:

09/03/05 13:33:19 (3 years ago)

Author:

mbonetti

Message:

Fixes #138

Files:

• trunk/rss/cls/categories.php (modified) (2 diffs)

trunk/rss/cls/categories.php

@@ -27 +27 @@
     var $tagCnt = 0;
     var $taggedFeedCnt = 0;
+    var $feedCnt = 0;
     
     function CatList() {
@@ -37 +38 @@
     }
     
+    function getFeedCount() {
+        // cached?
+        if ($this -> feedCnt > 0) {
+            return $this -> feedCnt;
+        }
+    
+        $sql = "select "
+                ." count(*) as cnt "
+                ." from ".getTable("channels")." c "
+                ." where  not(c.mode & ".FEED_MODE_DELETED_STATE.") ";
+
+        if (hidePrivate()) {
+            $sql .= " and not(c.mode & ".FEED_MODE_PRIVATE_STATE.") ";
+        }
+
+
+        list($this -> feedCnt) = rss_fetch_row(rss_query($sql));
+
+        return $this -> feedCnt;
+    }