diff options
author | Andrew Dolgov <[email protected]> | 2009-01-16 10:39:02 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2009-01-16 10:39:02 +0100 |
commit | 759c70a3eb41c0232bff26871bc6c178d3d3dfbd (patch) | |
tree | 672ffa91db1c2286a2d2327754e2cd8ec47fa762 | |
parent | 0c630ef32636378bbf8c25211da256b4d7a29069 (diff) |
feed browser: use cache table
-rw-r--r-- | modules/pref-feed-browser.php | 9 |
1 files changed, 7 insertions, 2 deletions
diff --git a/modules/pref-feed-browser.php b/modules/pref-feed-browser.php index d213268a7..7b1414bc2 100644 --- a/modules/pref-feed-browser.php +++ b/modules/pref-feed-browser.php @@ -90,12 +90,17 @@ $owner_uid = $_SESSION["uid"]; - $result = db_query($link, "SELECT feed_url,COUNT(id) AS subscribers +/* $result = db_query($link, "SELECT feed_url,COUNT(id) AS subscribers FROM ttrss_feeds WHERE (SELECT COUNT(id) = 0 FROM ttrss_feeds AS tf WHERE tf.feed_url = ttrss_feeds.feed_url AND (private IS true OR feed_url LIKE '%:%@%/%' OR owner_uid = '$owner_uid')) GROUP BY feed_url - ORDER BY subscribers DESC LIMIT $limit"); + ORDER BY subscribers DESC LIMIT $limit"); */ + + $result = db_query($link, "SELECT feed_url, subscribers FROM + ttrss_feedbrowser_cache WHERE (SELECT COUNT(id) = 0 FROM ttrss_feeds AS tf + WHERE tf.feed_url = ttrss_feedbrowser_cache.feed_url + AND owner_uid = '$owner_uid')"); print "<br/>"; |