summaryrefslogtreecommitdiff
path: root/classes/rssutils.php
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2019-03-06 20:02:06 +0300
committerAndrew Dolgov <[email protected]>2019-03-06 20:02:06 +0300
commit0b74db5ad7b3b93cf97b7fa65b467f929f6b232f (patch)
tree3f4a22fe3dd73ee030e98fe14457e9f48b7d3b6e /classes/rssutils.php
parent0881d0a00d8941a245b9541a880b5d408ad769f4 (diff)
remove feedbrowser (other feeds)
Diffstat (limited to 'classes/rssutils.php')
-rwxr-xr-xclasses/rssutils.php50
1 files changed, 0 insertions, 50 deletions
diff --git a/classes/rssutils.php b/classes/rssutils.php
index 8684a2c5d..36236bafe 100755
--- a/classes/rssutils.php
+++ b/classes/rssutils.php
@@ -19,53 +19,6 @@ class RSSUtils {
return preg_replace('/[\x{10000}-\x{10FFFF}]/u', "\xEF\xBF\xBD", $str);
}
- static function update_feedbrowser_cache() {
-
- $pdo = Db::pdo();
-
- $sth = $pdo->query("SELECT feed_url, site_url, title, COUNT(id) AS subscribers
- FROM ttrss_feeds WHERE feed_url NOT IN (SELECT feed_url FROM ttrss_feeds
- WHERE private IS true OR auth_login != '' OR auth_pass != '' OR feed_url LIKE '%:%@%/%')
- GROUP BY feed_url, site_url, title ORDER BY subscribers DESC LIMIT 1000");
-
- $pdo->beginTransaction();
-
- $pdo->query("DELETE FROM ttrss_feedbrowser_cache");
-
- $count = 0;
-
- while ($line = $sth->fetch()) {
-
- $subscribers = $line["subscribers"];
- $feed_url = $line["feed_url"];
- $title = $line["title"];
- $site_url = $line["site_url"];
-
- $tmph = $pdo->prepare("SELECT subscribers FROM
- ttrss_feedbrowser_cache WHERE feed_url = ?");
- $tmph->execute([$feed_url]);
-
- if (!$tmph->fetch()) {
-
- $tmph = $pdo->prepare("INSERT INTO ttrss_feedbrowser_cache
- (feed_url, site_url, title, subscribers)
- VALUES
- (?, ?, ?, ?)");
-
- $tmph->execute([$feed_url, $site_url, $title, $subscribers]);
-
- ++$count;
-
- }
-
- }
-
- $pdo->commit();
-
- return $count;
-
- }
-
static function update_daemon_common($limit = DAEMON_FEED_LIMIT) {
$schema_version = get_schema_version();
@@ -1542,9 +1495,6 @@ class RSSUtils {
RSSUtils::expire_error_log();
RSSUtils::expire_feed_archive();
- $count = RSSUtils::update_feedbrowser_cache();
- Debug::log("Feedbrowser updated, $count feeds processed.");
-
Article::purge_orphans();
RSSUtils::cleanup_counters_cache();