From 7608b38af83681727e5422be8173e8fbb01759e3 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Sat, 17 May 2008 15:54:55 +0100 Subject: [PATCH] fresh feed: match FRESH_ARTICLE_MAX_AGE to ttrss_entries.updated, not date_entered --- functions.php | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/functions.php b/functions.php index cf17a2a9..2696f9f2 100644 --- a/functions.php +++ b/functions.php @@ -2091,9 +2091,9 @@ $intl = get_pref($link, "FRESH_ARTICLE_MAX_AGE"); if (DB_TYPE == "pgsql") { - $match_part = "date_entered > NOW() - INTERVAL '$intl hour' "; + $match_part = "updated > NOW() - INTERVAL '$intl hour' "; } else { - $match_part = "date_entered > DATE_SUB(NOW(), + $match_part = "updated > DATE_SUB(NOW(), INTERVAL $intl HOUR) "; } @@ -2330,9 +2330,9 @@ $intl = get_pref($link, "FRESH_ARTICLE_MAX_AGE"); if (DB_TYPE == "pgsql") { - $match_part .= " AND date_entered > NOW() - INTERVAL '$intl hour' "; + $match_part .= " AND updated > NOW() - INTERVAL '$intl hour' "; } else { - $match_part .= " AND date_entered > DATE_SUB(NOW(), INTERVAL $intl HOUR) "; + $match_part .= " AND updated > DATE_SUB(NOW(), INTERVAL $intl HOUR) "; } } else if ($n_feed > 0) { @@ -3156,9 +3156,9 @@ $intl = get_pref($link, "FRESH_ARTICLE_MAX_AGE", $owner_uid); if (DB_TYPE == "pgsql") { - $query_strategy_part .= " AND date_entered > NOW() - INTERVAL '$intl hour' "; + $query_strategy_part .= " AND updated > NOW() - INTERVAL '$intl hour' "; } else { - $query_strategy_part .= " AND date_entered > DATE_SUB(NOW(), INTERVAL $intl HOUR) "; + $query_strategy_part .= " AND updated > DATE_SUB(NOW(), INTERVAL $intl HOUR) "; } $vfeed_query_part = "ttrss_feeds.title AS feed_title,"; -- 2.39.5