summaryrefslogtreecommitdiff
path: root/plugins
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2015-07-15 13:15:00 +0300
committerAndrew Dolgov <[email protected]>2015-07-15 13:15:07 +0300
commit9264ec7055de0ccf5f592af04519feb46db5c6b1 (patch)
tree9c3c808d1a2c5f435f8a52bcd60da30c7781cd09 /plugins
parenta950fbecb5c71fbed6adcf76fc1d4787f05ecb7f (diff)
af_psql_trgm: enable checking for similar articles in the source feed as long as guid is different
Diffstat (limited to 'plugins')
-rw-r--r--plugins/af_psql_trgm/init.php6
1 files changed, 3 insertions, 3 deletions
diff --git a/plugins/af_psql_trgm/init.php b/plugins/af_psql_trgm/init.php
index 263851144..ad24559c5 100644
--- a/plugins/af_psql_trgm/init.php
+++ b/plugins/af_psql_trgm/init.php
@@ -270,7 +270,7 @@ class Af_Psql_Trgm extends Plugin {
$owner_uid = $article["owner_uid"];
- $feed_id = $article["feed"]["id"];
+ $entry_guid = $article["guid_hashed"];
$title_escaped = db_escape_string($article["title"]);
// trgm does not return similarity=1 for completely equal strings
@@ -279,7 +279,7 @@ class Af_Psql_Trgm extends Plugin {
FROM ttrss_entries, ttrss_user_entries WHERE ref_id = id AND
date_entered >= NOW() - interval '1 day' AND
title = '$title_escaped' AND
- feed_id != '$feed_id' AND
+ guid != '$entry_guid' AND
owner_uid = $owner_uid");
$nequal = db_fetch_result($result, 0, "nequal");
@@ -293,7 +293,7 @@ class Af_Psql_Trgm extends Plugin {
$result = db_query("SELECT MAX(SIMILARITY(title, '$title_escaped')) AS ms
FROM ttrss_entries, ttrss_user_entries WHERE ref_id = id AND
date_entered >= NOW() - interval '1 day' AND
- feed_id != '$feed_id' AND
+ guid != '$entry_guid' AND
owner_uid = $owner_uid");
$similarity_result = db_fetch_result($result, 0, "ms");