diff options
| author | Andrew Dolgov <[email protected]> | 2011-04-20 20:05:10 +0400 |
|---|---|---|
| committer | Andrew Dolgov <[email protected]> | 2011-04-20 20:05:10 +0400 |
| commit | 109662e12f858bf067f14a37942a1106c900b527 (patch) | |
| tree | d34f48dcb375bf8c79639aa2cd089b5571af8ebe /functions.php | |
| parent | 6f907113ef20b09976b1fddbc698a49dbe283519 (diff) | |
feedbrowser_cache & linked feeds: add site url (bump schema)
Diffstat (limited to 'functions.php')
| -rw-r--r-- | functions.php | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/functions.php b/functions.php index 7fd9df780..3978e5af9 100644 --- a/functions.php +++ b/functions.php @@ -5881,11 +5881,11 @@ function update_feedbrowser_cache($link) { - $result = db_query($link, "SELECT feed_url,title, COUNT(id) AS subscribers + $result = db_query($link, "SELECT feed_url, site_url, title, 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, title ORDER BY subscribers DESC LIMIT 1000"); + GROUP BY feed_url, site_url, title ORDER BY subscribers DESC LIMIT 1000"); db_query($link, "BEGIN"); @@ -5897,6 +5897,7 @@ $subscribers = db_escape_string($line["subscribers"]); $feed_url = db_escape_string($line["feed_url"]); $title = db_escape_string($line["title"]); + $site_url = db_escape_string($line["site_url"]); $tmp_result = db_query($link, "SELECT subscribers FROM ttrss_feedbrowser_cache WHERE feed_url = '$feed_url'"); @@ -5904,8 +5905,8 @@ if (db_num_rows($tmp_result) == 0) { db_query($link, "INSERT INTO ttrss_feedbrowser_cache - (feed_url, title, subscribers) VALUES ('$feed_url', - '$title', '$subscribers')"); + (feed_url, site_url, title, subscribers) VALUES ('$feed_url', + '$site_url', '$title', '$subscribers')"); ++$count; |