diff options
-rw-r--r-- | backend.php | 28 |
1 files changed, 21 insertions, 7 deletions
diff --git a/backend.php b/backend.php index afa04fe16..3eca4eda7 100644 --- a/backend.php +++ b/backend.php @@ -949,17 +949,31 @@ if (!WEB_DEMO_MODE) { $feed_link = db_escape_string($_GET["link"]); - - $result = db_query($link, - "INSERT INTO ttrss_feeds (owner_uid,feed_url,title) VALUES ('".$_SESSION["uid"]."', '$feed_link', '')"); $result = db_query($link, - "SELECT id FROM ttrss_feeds WHERE feed_url = '$feed_link' AND owner_uid = " . $_SESSION["uid"]); + "SELECT id FROM ttrss_feeds + WHERE feed_url = '$feed_link' AND owner_uid = ".$_SESSION["uid"]); + + if (db_num_rows($result) == 0) { + + $result = db_query($link, + "INSERT INTO ttrss_feeds (owner_uid,feed_url,title) + VALUES ('".$_SESSION["uid"]."', '$feed_link', '')"); - $feed_id = db_fetch_result($result, 0, "id"); + $result = db_query($link, + "SELECT id FROM ttrss_feeds WHERE feed_url = '$feed_link' + AND owner_uid = " . $_SESSION["uid"]); + + $feed_id = db_fetch_result($result, 0, "id"); + + if ($feed_id) { + update_rss_feed($link, $feed_link, $feed_id); + } + } else { - if ($feed_id) { - update_rss_feed($link, $feed_link, $feed_id); + print "<div class=\"warning\"> + Feed <b>$feed_link</b> already exists in the database. + </div>"; } } } |