From bfedfe697bb8893473795ec832fb60fec1ed651f Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Wed, 4 May 2011 14:56:49 +0400 Subject: [PATCH] backend/la: properly handle situation when article has multiple ref_ids on one account (closes #342) --- backend.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/backend.php b/backend.php index 58f921e6..6b93d1b3 100644 --- a/backend.php +++ b/backend.php @@ -181,7 +181,8 @@ $id = db_escape_string($_REQUEST['id']); $result = db_query($link, "SELECT link FROM ttrss_entries, ttrss_user_entries - WHERE id = '$id' AND id = ref_id AND owner_uid = '".$_SESSION['uid']."'"); + WHERE id = '$id' AND id = ref_id AND owner_uid = '".$_SESSION['uid']."' + LIMIT 1"); if (db_num_rows($result) == 1) { $article_url = db_fetch_result($result, 0, 'link'); -- 2.39.5