diff options
author | Andrew Dolgov <[email protected]> | 2005-11-19 18:57:14 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2005-11-19 18:57:14 +0100 |
commit | 7e9a3986378cae5c60631c7c8c30dafd8785d5c2 (patch) | |
tree | 23540261a08725431b2532f099e959b1e4b2f32a | |
parent | f72dbbdefc1a16e35786765d310c6326d8f495c1 (diff) |
don't allow duplicate feeds for user
-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>"; } } } |