From c1d7e6c344a6228df812e40a669303d4a3a06739 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Thu, 23 Aug 2007 09:05:40 +0100 Subject: new option: FRESH_ARTICLE_MAX_AGE (bump schema) --- functions.php | 18 ++++++++++++------ 1 file changed, 12 insertions(+), 6 deletions(-) (limited to 'functions.php') diff --git a/functions.php b/functions.php index 272d50c5d..0de5c1289 100644 --- a/functions.php +++ b/functions.php @@ -1648,11 +1648,13 @@ if ($feed == -3) { + $intl = get_pref($link, "FRESH_ARTICLE_MAX_AGE"); + if (DB_TYPE == "pgsql") { - $match_part .= " AND date_entered > NOW() - INTERVAL '1 day' "; + $match_part .= " AND date_entered > NOW() - INTERVAL '$intl hour' "; } else { $match_part .= " AND date_entered > DATE_SUB(NOW(), - INTERVAL 1 DAY) "; + INTERVAL $intl HOUR) "; } db_query($link, "UPDATE ttrss_user_entries @@ -1856,10 +1858,12 @@ } else if ($n_feed == -3) { $match_part = "unread = true"; + $intl = get_pref($link, "FRESH_ARTICLE_MAX_AGE"); + if (DB_TYPE == "pgsql") { - $match_part .= " AND date_entered > NOW() - INTERVAL '1 day' "; + $match_part .= " AND date_entered > NOW() - INTERVAL '$intl hour' "; } else { - $match_part .= " AND date_entered > DATE_SUB(NOW(), INTERVAL 1 DAY) "; + $match_part .= " AND date_entered > DATE_SUB(NOW(), INTERVAL $intl HOUR) "; } } else if ($n_feed > 0) { @@ -2637,10 +2641,12 @@ } else if ($feed == -3) { // fresh virtual feed $query_strategy_part = "unread = true"; + $intl = get_pref($link, "FRESH_ARTICLE_MAX_AGE"); + if (DB_TYPE == "pgsql") { - $query_strategy_part .= " AND date_entered > NOW() - INTERVAL '1 day' "; + $query_strategy_part .= " AND date_entered > NOW() - INTERVAL '$intl hour' "; } else { - $query_strategy_part .= " AND date_entered > DATE_SUB(NOW(), INTERVAL 1 DAY) "; + $query_strategy_part .= " AND date_entered > DATE_SUB(NOW(), INTERVAL $intl HOUR) "; } $vfeed_query_part = "ttrss_feeds.title AS feed_title,"; -- cgit v1.2.3