diff options
author | Andrew Dolgov <[email protected]> | 2005-11-19 11:15:56 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2005-11-19 11:15:56 +0100 |
commit | 35d8cf43bcf037a7017462e01a0b21bcede6f0db (patch) | |
tree | 5d4ff9b0872ade04483e78f3cf47389ca6811b2e | |
parent | c62d62f65e0ee9feaaa18f0b3eb8860e4400f97c (diff) |
fix and enable purge_feed()
-rw-r--r-- | functions.php | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/functions.php b/functions.php index 36741a199..7e2eb90a2 100644 --- a/functions.php +++ b/functions.php @@ -8,16 +8,16 @@ function purge_feed($link, $feed_id, $purge_interval) { - return; // FIXME disabled for now - if (DB_TYPE == "pgsql") { - db_query($link, "DELETE FROM ttrss_entries WHERE + db_query($link, "DELETE FROM ttrss_user_entries WHERE marked = false AND feed_id = '$feed_id' AND - date_entered < NOW() - INTERVAL '$purge_interval days'"); + (SELECT date_entered FROM ttrss_entries WHERE + id = ref_id) < NOW() - INTERVAL '$purge_interval days'"); } else { - db_query($link, "DELETE FROM ttrss_entries WHERE + db_query($link, "DELETE FROM ttrss_user_entries WHERE marked = false AND feed_id = '$feed_id' AND - date_entered < DATE_SUB(NOW(), INTERVAL $purge_interval DAY)"); + (SELECT date_entered FROM ttrss_entries WHERE + id = ref_id) < DATE_SUB(NOW(), INTERVAL $purge_interval DAY)"); } } |