diff options
author | Andrew Dolgov <[email protected]> | 2005-12-29 16:09:51 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2005-12-29 16:09:51 +0100 |
commit | 8926aab826ced7a664760813229ea818b92de74c (patch) | |
tree | 4f8dd4dd545faf24bd0ec97ebdf4cba70795ea0e | |
parent | 649e0af9feecfb58c064addd8ee2fb7568ac45c8 (diff) |
fix expiry-generated dupes (see changeset)
-rw-r--r-- | functions.php | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/functions.php b/functions.php index 26fcbbdcd..c67a7a99b 100644 --- a/functions.php +++ b/functions.php @@ -370,12 +370,23 @@ NOW(), '$entry_comments', '$num_comments')"); + } else { + // we keep encountering the entry in feeds, so we need to + // update date_entered column so that we don't get horrible + // dupes when the entry gets purged and reinserted again e.g. + // in the case of SLOW SLOW OMG SLOW updating feeds + + $base_entry_id = db_fetch_result($result, 0, "id"); + + db_query($link, "UPDATE ttrss_entries SET date_entered = NOW() + WHERE id = '$base_entry_id'"); } // now it should exist, if not - bad luck then $result = db_query($link, "SELECT id,content_hash,no_orig_date,title, + substring(date_entered,1,19) as date_entered, substring(updated,1,19) as updated, num_comments FROM @@ -388,6 +399,8 @@ $orig_content_hash = db_fetch_result($result, 0, "content_hash"); $orig_title = db_fetch_result($result, 0, "title"); $orig_num_comments = db_fetch_result($result, 0, "num_comments"); + $orig_date_entered = strtotime(db_fetch_result($result, + 0, "date_entered")); $ref_id = db_fetch_result($result, 0, "id"); |