diff options
| author | Andrew Dolgov <[email protected]> | 2007-08-23 09:05:40 +0100 |
|---|---|---|
| committer | Andrew Dolgov <[email protected]> | 2007-08-23 09:05:40 +0100 |
| commit | c1d7e6c344a6228df812e40a669303d4a3a06739 (patch) | |
| tree | 371f0784aa1c69b338c159ecc72aa7caa975ca23 /functions.php | |
| parent | 2d24f03266de2be331b18150886039aed50e6816 (diff) | |
new option: FRESH_ARTICLE_MAX_AGE (bump schema)
Diffstat (limited to 'functions.php')
| -rw-r--r-- | functions.php | 18 |
1 files changed, 12 insertions, 6 deletions
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,"; |