diff options
author | Andrew Dolgov <[email protected]> | 2012-06-15 10:43:58 +0400 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2012-06-15 10:43:58 +0400 |
commit | a62812a6b4a0d5dd24d0046e894f93322becb52d (patch) | |
tree | 5f998e4e9ca755988e50061aa91759216fcfe353 /classes | |
parent | ca6a0741b4819207e19d1afca02044db9885b94d (diff) |
show amount of feeds category holds in category editor
Diffstat (limited to 'classes')
-rw-r--r-- | classes/pref_feeds.php | 10 |
1 files changed, 7 insertions, 3 deletions
diff --git a/classes/pref_feeds.php b/classes/pref_feeds.php index 6c34c2712..da454b48a 100644 --- a/classes/pref_feeds.php +++ b/classes/pref_feeds.php @@ -1192,9 +1192,11 @@ class Pref_Feeds extends Protected_Handler { print "</div>"; - $result = db_query($this->link, "SELECT title,id FROM ttrss_feed_categories - WHERE owner_uid = ".$_SESSION["uid"]." - ORDER BY title"); + $result = db_query($this->link, "SELECT c.title, c.id,COUNT(f.*) AS count + FROM ttrss_feed_categories AS c LEFT JOIN ttrss_feeds AS f ON + (f.cat_id = c.id) + WHERE c.owner_uid = ".$_SESSION["uid"]." + GROUP BY c.title, c.id ORDER BY title"); if (db_num_rows($result) != 0) { @@ -1241,6 +1243,8 @@ class Pref_Feeds extends Protected_Handler { </script> </span>"; + print "<td align='right' class='insensitive'>"; + echo T_sprintf("%d feeds", $line['count']); print "</td></tr>"; ++$lnum; |