]>
git.wh0rd.org - tt-rss.git/blob - xml-rpc.php
2 require "xmlrpc/lib/xmlrpc.inc";
3 require "xmlrpc/lib/xmlrpcs.inc";
5 $xmlrpc_defencoding = "UTF8";
7 require_once "sanity_check.php";
8 require_once "config.php";
10 require_once "db.php";
11 require_once "db-prefs.php";
12 require_once "functions.php";
14 $link = db_connect(DB_HOST
, DB_USER
, DB_PASS
, DB_NAME
);
17 if (DB_TYPE
== "mysql") {
20 // PG seems to display its own errors just fine by default.
24 if (DB_TYPE
== "pgsql") {
25 pg_query("set client_encoding = 'utf-8'");
28 function getSubscribedFeeds($msg) {
31 $login_o = $msg->getParam(0);
32 $pass_o = $msg->getParam(1);
34 $login = $login_o->scalarval();
35 $pass = $pass_o->scalarval();
37 $user_id = authenticate_user($link, $login, $pass);
39 if (authenticate_user($link, $login, $pass)) {
41 $result = db_query($link, "SELECT
42 id, feed_url, title, SUBSTRING(last_updated,1,19) AS last_updated
43 FROM ttrss_feeds WHERE owner_uid = " .
48 while ($line = db_fetch_assoc($result)) {
50 $line_struct = new xmlrpcval(
52 "feed_url" => new xmlrpcval($line["feed_url"]),
53 "title" => new xmlrpcval($line["title"]),
54 "id" => new xmlrpcval($line["id"], "int"),
55 "last_updated" => new xmlrpcval(strtotime($line["last_updated"]), "int")
59 array_push($feeds, $line_struct);
62 $reply = new xmlrpcval($feeds, "array");
65 $reply = new xmlrpcval("Login failed.");
68 return new xmlrpcresp($reply);
71 function subscribeToFeed($msg) {
76 $login_o = $msg->getParam(0);
77 $pass_o = $msg->getParam(1);
78 $feed_url_o = $msg->getParam(2);
80 $login = $login_o->scalarval();
81 $pass = $pass_o->scalarval();
82 $feed_url = $feed_url_o->scalarval();
84 if (authenticate_user($link, $login, $pass)) {
85 if (subscribe_to_feed($link, $feed_url)) {
86 $reply_msg = "Subscribed successfully.";
88 $reply_msg = "Feed already exists in the database.";
92 $reply_msg = "Login failed.";
96 if ($error_code != 0) {
97 return new xmlrpcresp(0, $error_code, $reply_msg);
99 return new xmlrpcresp(new xmlrpcval($reply_msg));
103 function getFeedHeadlines($msg) {
108 $login_o = $msg->getParam(0);
109 $pass_o = $msg->getParam(1);
110 $feed_id_o = $msg->getParam(2);
111 $limit_o = $msg->getParam(3);
112 $filter_o = $msg->getParam(4);
114 $login = $login_o->scalarval();
115 $pass = $pass_o->scalarval();
116 $feed_id = $feed_id_o->scalarval();
117 $limit = $limit_o->scalarval();
118 $filter = $filter_o->scalarval();
120 if (authenticate_user($link, $login, $pass)) {
123 $limit_query_part = "LIMIT $limit";
127 $query_strategy_part = "unread = true";
128 } else if ($filter == 2) {
129 $query_strategy_part = "marked = true";
131 $query_strategy_part = "ttrss_entries.id > 0";
135 ttrss_entries.id,ttrss_entries.title,
136 SUBSTRING(updated,1,16) as updated,
137 unread,feed_id,marked,link,last_read,
138 SUBSTRING(last_read,1,19) as last_read_noms,
139 SUBSTRING(updated,1,19) as updated_noms
141 ttrss_entries,ttrss_user_entries,ttrss_feeds
143 ttrss_feeds.id = '$feed_id' AND
144 ttrss_user_entries.feed_id = ttrss_feeds.id AND
145 ttrss_user_entries.ref_id = ttrss_entries.id AND
146 ttrss_user_entries.owner_uid = '".$_SESSION["uid"]."' AND
147 $query_strategy_part ORDER BY updated
150 $result = db_query($link, $query);
154 while ($line = db_fetch_assoc($result)) {
157 $line_struct = new xmlrpcval(
159 "id" => new xmlrpcval($line["id"], "int"),
160 "unread" => new xmlrpcval(sql_bool_to_bool($line["unread"]), "boolean"),
161 "marked" => new xmlrpcval(sql_bool_to_bool($line["marked"]), "boolean"),
162 "updated" => new xmlrpcval(strtotime($line["updated"]), "int"),
163 "title" => new xmlrpcval($line["title"])
167 array_push($articles, $line_struct);
171 $reply = new xmlrpcval($articles, "array");
174 $reply_msg = "Login failed.";
178 if ($error_code != 0) {
179 return new xmlrpcresp(0, $error_code, $reply_msg);
181 return new xmlrpcresp($reply);
186 function getArticle($msg) {
191 $login_o = $msg->getParam(0);
192 $pass_o = $msg->getParam(1);
193 $article_id_o = $msg->getParam(2);
195 $login = $login_o->scalarval();
196 $pass = $pass_o->scalarval();
197 $article_id = $article_id_o->scalarval();
199 if (authenticate_user($link, $login, $pass)) {
201 $query = "SELECT title,link,content,feed_id,comments,int_id,
203 SUBSTRING(updated,1,16) as updated,
205 FROM ttrss_entries,ttrss_user_entries
206 WHERE id = '$article_id' AND ref_id = id AND owner_uid = " . $_SESSION["uid"] ;
208 $result = db_query($link, $query);
210 if (db_num_rows($result) == 1) {
212 $line = db_fetch_assoc($result);
214 $reply = new xmlrpcval(
216 "title" => new xmlrpcval($line["title"]),
217 "link" => new xmlrpcval($line["link"]),
218 "unread" => new xmlrpcval(sql_bool_to_bool($line["unread"]), "boolean"),
219 "marked" => new xmlrpcval(sql_bool_to_bool($line["marked"]), "boolean"),
220 "comments" => new xmlrpcval($line["comments"]),
221 "author" => new xmlrpcval($line["author"]),
222 "updated" => new xmlrpcval(strtotime($line["updated"], "int")),
223 "content" => new xmlrpcval($line["content"])
228 $reply_msg = "Article not found.";
233 $reply_msg = "Login failed.";
237 if ($error_code != 0) {
238 return new xmlrpcresp(0, $error_code, $reply_msg);
240 return new xmlrpcresp($reply);
244 function setArticleMarked($msg) {
249 $login_o = $msg->getParam(0);
250 $pass_o = $msg->getParam(1);
251 $article_id_o = $msg->getParam(2);
252 $marked_o = $msg->getParam(3);
254 $login = $login_o->scalarval();
255 $pass = $pass_o->scalarval();
256 $article_id = $article_id_o->scalarval();
257 $marked = $marked_o->scalarval();
259 if (authenticate_user($link, $login, $pass)) {
262 $query_strategy_part = "marked = false";
263 } else if ($marked == 1) {
264 $query_strategy_part = "marked = true";
265 } else if ($marked == 2) {
266 $query_strategy_part = "marked = NOT marked";
269 $result = db_query($link, "UPDATE ttrss_user_entries SET
270 $query_strategy_part WHERE ref_id = '$article_id' AND
271 owner_uid = " . $_SESSION["uid"]);
273 if (db_affected_rows($link, $result) == 1) {
277 $reply_msg = "Failed to update article.";
281 $reply_msg = "Login failed.";
285 if ($error_code != 0) {
286 return new xmlrpcresp(0, $error_code, $reply_msg);
288 return new xmlrpcresp(new xmlrpcval($reply_msg));
293 function setArticleRead($msg) {
298 $login_o = $msg->getParam(0);
299 $pass_o = $msg->getParam(1);
300 $article_id_o = $msg->getParam(2);
301 $read_o = $msg->getParam(3);
303 $login = $login_o->scalarval();
304 $pass = $pass_o->scalarval();
305 $article_id = $article_id_o->scalarval();
306 $read = $read_o->scalarval();
308 if (authenticate_user($link, $login, $pass)) {
311 $query_strategy_part = "unread = true";
312 } else if ($read == 1) {
313 $query_strategy_part = "unread = false";
314 } else if ($read == 2) {
315 $query_strategy_part = "unread = NOT unread";
318 $result = db_query($link, "UPDATE ttrss_user_entries SET
319 $query_strategy_part WHERE ref_id = '$article_id' AND
320 owner_uid = " . $_SESSION["uid"]);
322 if (db_affected_rows($link, $result) == 1) {
326 $reply_msg = "Failed to update article.";
330 $reply_msg = "Login failed.";
334 if ($error_code != 0) {
335 return new xmlrpcresp(0, $error_code, $reply_msg);
337 return new xmlrpcresp(new xmlrpcval($reply_msg));
342 $subscribeToFeed_sig = array(array($xmlrpcString,
343 $xmlrpcString, $xmlrpcString, $xmlrpcString));
345 $getSubscribedFeeds_sig = array(array($xmlrpcString,
346 $xmlrpcString, $xmlrpcString));
348 $getFeedHeadlines_sig = array(array($xmlrpcString,
349 $xmlrpcString, $xmlrpcString, $xmlrpcInt, $xmlrpcInt, $xmlrpcInt));
351 $getArticle_sig = array(array($xmlrpcString,
352 $xmlrpcString, $xmlrpcString, $xmlrpcInt));
354 $setArticleMarked_sig = array(array($xmlrpcString,
355 $xmlrpcString, $xmlrpcString, $xmlrpcInt, $xmlrpcInt));
357 $setArticleUnread_sig = array(array($xmlrpcString,
358 $xmlrpcString, $xmlrpcString, $xmlrpcInt, $xmlrpcInt));
360 $s = new xmlrpc_server(
362 "rss.setArticleRead" => array("function" => "setArticleRead",
363 "signature" => $setArticleRead_sig),
364 "rss.setArticleMarked" => array("function" => "setArticleMarked",
365 "signature" => $setArticleMarked_sig),
366 "rss.getArticle" => array("function" => "getArticle",
367 "signature" => $getArticle_sig),
368 "rss.getFeedHeadlines" => array("function" => "getFeedHeadlines",
369 "signature" => $getFeedHeadlines_sig),
370 "rss.getSubscribedFeeds" => array("function" => "getSubscribedFeeds",
371 "signature" => $getSubscribedFeeds_sig),
372 "rss.subscribeToFeed" => array("function" => "subscribeToFeed",
373 "signature" => $subscribeToFeed_sig))