From 956c762979b6751f1cbe369df6a92f4640808724 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Tue, 16 May 2006 08:33:51 +0100 Subject: add xmlrpc library & server --- functions.php | 50 +++++++++++++++++++++++++++++++++++++++++++++++++- 1 file changed, 49 insertions(+), 1 deletion(-) (limited to 'functions.php') diff --git a/functions.php b/functions.php index bb0217d3e..e11eafcb2 100644 --- a/functions.php +++ b/functions.php @@ -801,7 +801,19 @@ db_query($link, "COMMIT"); } - + + function lookup_user_id($link, $user) { + + $result = db_query($link, "SELECT id FROM ttrss_users WHERE + login = '$login'"); + + if (db_num_rows($result) == 1) { + return db_fetch_result($result, 0, "id"); + } else { + return false; + } + } + function authenticate_user($link, $login, $password) { $pwd_hash = 'SHA1:' . sha1($password); @@ -1511,4 +1523,40 @@ print ""; } + + function subscribe_to_feed($link, $feed_link, $cat_id = 0) { + + if ($cat_id == "0" || !$cat_id) { + $cat_qpart = "NULL"; + } else { + $cat_qpart = "'$cat_id'"; + } + + $result = db_query($link, + "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,cat_id) + VALUES ('".$_SESSION["uid"]."', '$feed_link', + '[Unknown]', $cat_qpart)"); + + $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, true); + } + + return true; + } else { + return false; + } + } + ?> -- cgit v1.2.3