diff options
author | Andrew Dolgov <[email protected]> | 2009-01-16 10:47:12 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2009-01-16 10:47:12 +0100 |
commit | 5e96ca9df247ad24845531bf53f7fce4707a07c5 (patch) | |
tree | 2a42091201279cca1b74e1b942ef25bb8e2a01fb | |
parent | 2c2dd64d5d84b40d7f383b92ac3d35e532192ad2 (diff) |
move feedbrowser cache code to functions.php
-rw-r--r-- | functions.php | 30 | ||||
-rw-r--r-- | update_feedbrowser.php | 24 |
2 files changed, 31 insertions, 23 deletions
diff --git a/functions.php b/functions.php index 593edaf1f..473356886 100644 --- a/functions.php +++ b/functions.php @@ -5903,4 +5903,34 @@ } } } + + function update_feedbrowser_cache($link) { + + $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 '%:%@%/%')) + GROUP BY feed_url ORDER BY subscribers DESC"); + + db_query($link, "BEGIN"); + + db_query($link, "DELETE FROM ttrss_feedbrowser_cache"); + + $count = 0; + + while ($line = db_fetch_assoc($result)) { + $subscribers = db_escape_string($line["subscribers"]); + $feed_url = db_escape_string($line["feed_url"]); + + db_query($link, "INSERT INTO ttrss_feedbrowser_cache + (feed_url, subscribers) VALUES ('$feed_url', '$subscribers')"); + + ++$count; + } + + db_query($link, "COMMIT"); + + return $count; + + } ?> diff --git a/update_feedbrowser.php b/update_feedbrowser.php index b64bb2569..4698918d5 100644 --- a/update_feedbrowser.php +++ b/update_feedbrowser.php @@ -38,29 +38,7 @@ init_connection($link); - $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 '%:%@%/%')) - GROUP BY feed_url ORDER BY subscribers DESC"); - - db_query($link, "BEGIN"); - - db_query($link, "DELETE FROM ttrss_feedbrowser_cache"); - - $count = 0; - - while ($line = db_fetch_assoc($result)) { - $subscribers = db_escape_string($line["subscribers"]); - $feed_url = db_escape_string($line["feed_url"]); - - db_query($link, "INSERT INTO ttrss_feedbrowser_cache - (feed_url, subscribers) VALUES ('$feed_url', '$subscribers')"); - - ++$count; - } - - db_query($link, "COMMIT"); + $count = update_feedbrowser_cache($link); print "Finished, $count feeds processed.\n"; |