From 884ae7a94181284beb1669458e33935751f5266d Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Wed, 12 Aug 2015 10:02:46 +0300 Subject: [PATCH] limit recently read feed to 1 day of read headlines --- include/functions2.php | 7 +++++++ 1 file changed, 7 insertions(+) diff --git a/include/functions2.php b/include/functions2.php index 6ccdc9a5..af92b134 100644 --- a/include/functions2.php +++ b/include/functions2.php @@ -604,6 +604,13 @@ } } else if ($feed == -6) { // recently read $query_strategy_part = "unread = false AND last_read IS NOT NULL"; + + if (DB_TYPE == "pgsql") { + $query_strategy_part .= " AND date_entered > NOW() - INTERVAL '1 DAY' "; + } else { + $query_strategy_part .= " AND date_entered > DATE_SUB(NOW(), INTERVAL 1 DAY) "; + } + $vfeed_query_part = "ttrss_feeds.title AS feed_title,"; $allow_archived = true; $ignore_vfeed_group = true; -- 2.39.5