]>
git.wh0rd.org - tt-rss.git/blob - modules/backend-rpc.php
2 function handle_rpc_request($link) {
4 $subop = $_REQUEST["subop"];
6 if ($subop == "setprofile") {
7 $id = db_escape_string($_REQUEST["id"]);
9 $_SESSION["profile"] = $id;
10 $_SESSION["prefs_cache"] = array();
14 if ($subop == "remprofiles") {
15 $ids = split(",", db_escape_string(trim($_REQUEST["ids"])));
17 foreach ($ids as $id) {
18 if ($_SESSION["profile"] != $id) {
19 db_query($link, "DELETE FROM ttrss_settings_profiles WHERE id = '$id' AND
20 owner_uid = " . $_SESSION["uid"]);
26 if ($subop == "addprofile") {
27 $title = db_escape_string(trim($_REQUEST["title"]));
29 db_query($link, "BEGIN");
31 $result = db_query($link, "SELECT id FROM ttrss_settings_profiles
32 WHERE title = '$title' AND owner_uid = " . $_SESSION["uid"]);
34 if (db_num_rows($result) == 0) {
36 db_query($link, "INSERT INTO ttrss_settings_profiles (title, owner_uid)
37 VALUES ('$title', ".$_SESSION["uid"] .")");
39 $result = db_query($link, "SELECT id FROM ttrss_settings_profiles WHERE
42 if (db_num_rows($result) != 0) {
43 $profile_id = db_fetch_result($result, 0, "id");
46 initialize_user_prefs($link, $_SESSION["uid"], $profile_id);
51 db_query($link, "COMMIT");
56 if ($subop == "saveprofile") {
57 $id = db_escape_string($_REQUEST["id"]);
58 $title = db_escape_string(trim($_REQUEST["value"]));
61 print __("Default profile");
66 db_query($link, "BEGIN");
68 $result = db_query($link, "SELECT id FROM ttrss_settings_profiles
69 WHERE title = '$title' AND owner_uid =" . $_SESSION["uid"]);
71 if (db_num_rows($result) == 0) {
72 db_query($link, "UPDATE ttrss_settings_profiles
73 SET title = '$title' WHERE id = '$id' AND
74 owner_uid = " . $_SESSION["uid"]);
77 $result = db_query($link, "SELECT title FROM ttrss_settings_profiles
78 WHERE id = '$id' AND owner_uid =" . $_SESSION["uid"]);
79 print db_fetch_result($result, 0, "title");
82 db_query($link, "COMMIT");
87 if ($subop == "remarchive") {
88 $ids = split(",", db_escape_string($_REQUEST["ids"]));
92 foreach ($ids as $id) {
93 $result = db_query($link, "DELETE FROM ttrss_archived_feeds WHERE
94 (SELECT COUNT(*) FROM ttrss_user_entries
95 WHERE orig_feed_id = '$id') = 0 AND
96 id = '$id' AND owner_uid = ".$_SESSION["uid"]);
98 $rc = db_affected_rows($link, $result);
100 print "<feed id='$id' rc='$rc'/>";
104 print "</rpc-reply>";
109 if ($subop == "addfeed") {
111 $feed = db_escape_string($_REQUEST['feed']);
112 $cat = db_escape_string($_REQUEST['cat']);
113 $login = db_escape_string($_REQUEST['login']);
114 $pass = db_escape_string($_REQUEST['pass']);
116 $rc = subscribe_to_feed($link, $feed, $cat, $login, $pass);
119 print "<result code='$rc'/>";
120 print "</rpc-reply>";
126 if ($subop == "setpref") {
133 $key = db_escape_string($_REQUEST["key"]);
134 $value = db_escape_string($_REQUEST["value"]);
136 set_pref($link, $key, $value);
138 print "<param-set key=\"$key\" value=\"$value\"/>";
140 print "</rpc-reply>";
145 if ($subop == "getAllCounters") {
149 $omode = $_REQUEST["omode"];
151 getAllCounters($link, $omode);
153 print_runtime_info($link);
154 print "</rpc-reply>";
159 if ($subop == "mark") {
160 $mark = $_REQUEST["mark"];
161 $id = db_escape_string($_REQUEST["id"]);
169 // FIXME this needs collision testing
171 $result = db_query($link, "UPDATE ttrss_user_entries SET marked = $mark
172 WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]);
174 print "<rpc-reply><counters>";
175 getGlobalCounters($link);
176 getVirtCounters($link);
177 getLabelCounters($link);
178 if (get_pref($link, 'ENABLE_FEED_CATS')) {
179 getCategoryCounters($link);
181 print "</counters></rpc-reply>";
186 if ($subop == "delete") {
187 $ids = db_escape_string($_REQUEST["ids"]);
189 $result = db_query($link, "DELETE FROM ttrss_user_entries
190 WHERE ref_id IN ($ids) AND owner_uid = " . $_SESSION["uid"]);
192 print "<rpc-reply><counters>";
193 getGlobalCounters($link);
194 getVirtCounters($link);
195 if (get_pref($link, 'ENABLE_FEED_CATS')) {
196 getCategoryCounters($link);
198 print "</counters></rpc-reply>";
203 if ($subop == "unarchive") {
204 $ids = db_escape_string($_REQUEST["ids"]);
206 $result = db_query($link, "UPDATE ttrss_user_entries
207 SET feed_id = orig_feed_id, orig_feed_id = NULL
208 WHERE ref_id IN ($ids) AND owner_uid = " . $_SESSION["uid"]);
210 print "<rpc-reply><counters>";
211 getGlobalCounters($link);
212 getVirtCounters($link);
213 if (get_pref($link, 'ENABLE_FEED_CATS')) {
214 getCategoryCounters($link);
216 print "</counters></rpc-reply>";
221 if ($subop == "archive") {
222 $ids = split(",", db_escape_string($_REQUEST["ids"]));
224 foreach ($ids as $id) {
225 archive_article($link, $id, $_SESSION["uid"]);
228 print "<rpc-reply><counters>";
229 getGlobalCounters($link);
230 getVirtCounters($link);
231 if (get_pref($link, 'ENABLE_FEED_CATS')) {
232 getCategoryCounters($link);
234 print "</counters></rpc-reply>";
240 if ($subop == "publ") {
241 $pub = $_REQUEST["pub"];
242 $id = db_escape_string($_REQUEST["id"]);
243 $note = trim(strip_tags(db_escape_string($_REQUEST["note"])));
251 if ($note != 'undefined') {
252 $note_qpart = "note = '$note',";
255 // FIXME this needs collision testing
257 $result = db_query($link, "UPDATE ttrss_user_entries SET
260 WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]);
266 getGlobalCounters($link);
267 getVirtCounters($link);
268 getLabelCounters($link);
269 if (get_pref($link, 'ENABLE_FEED_CATS')) {
270 getCategoryCounters($link);
274 if ($note != 'undefined') {
275 $note_size = strlen($note);
276 print "<note id=\"$id\" size=\"$note_size\">";
277 print "<![CDATA[" . format_article_note($id, $note) . "]]>";
281 print "</rpc-reply>";
286 if ($subop == "updateFeed") {
287 $feed_id = db_escape_string($_REQUEST["feed"]);
289 $result = db_query($link,
290 "SELECT feed_url FROM ttrss_feeds WHERE id = '$feed_id'
291 AND owner_uid = " . $_SESSION["uid"]);
293 if (db_num_rows($result) > 0) {
294 $feed_url = db_fetch_result($result, 0, "feed_url");
295 update_rss_feed($link, $feed_url, $feed_id);
300 getFeedCounter($link, $feed_id);
302 print "</rpc-reply>";
307 if ($subop == "forceUpdateAllFeeds" ||
$subop == "updateAllFeeds") {
309 $global_unread_caller = sprintf("%d", $_REQUEST["uctr"]);
310 $global_unread = getGlobalUnread($link);
316 if ($global_unread_caller != $global_unread) {
318 $omode = $_REQUEST["omode"];
320 if (!$omode) $omode = "tflc";
322 getVirtCounters($link);
324 if (strchr($omode, "l")) getLabelCounters($link);
326 if (strchr($omode, "c")) {
327 if (get_pref($link, 'ENABLE_FEED_CATS')) {
328 getCategoryCounters($link);
332 if (strchr($omode, "f")) getFeedCounters($link);
333 if (strchr($omode, "t")) getTagCounters($link);
335 getGlobalCounters($link, $global_unread);
340 print_runtime_info($link);
342 print "</rpc-reply>";
347 /* GET["cmode"] = 0 - mark as read, 1 - as unread, 2 - toggle */
348 if ($subop == "catchupSelected") {
350 $ids = split(",", db_escape_string($_REQUEST["ids"]));
351 $cmode = sprintf("%d", $_REQUEST["cmode"]);
353 catchupArticlesById($link, $ids, $cmode);
357 getAllCounters($link, $_REQUEST["omode"]);
359 print_runtime_info($link);
360 print "</rpc-reply>";
365 if ($subop == "markSelected") {
367 $ids = split(",", db_escape_string($_REQUEST["ids"]));
368 $cmode = sprintf("%d", $_REQUEST["cmode"]);
370 markArticlesById($link, $ids, $cmode);
374 getAllCounters($link, $_REQUEST["omode"]);
376 print_runtime_info($link);
377 print "</rpc-reply>";
382 if ($subop == "publishSelected") {
384 $ids = split(",", db_escape_string($_REQUEST["ids"]));
385 $cmode = sprintf("%d", $_REQUEST["cmode"]);
387 publishArticlesById($link, $ids, $cmode);
391 getAllCounters($link, $_REQUEST["omode"]);
393 print_runtime_info($link);
394 print "</rpc-reply>";
399 if ($subop == "sanityCheck") {
401 if (sanity_check($link)) {
402 print "<error error-code=\"0\"/>";
403 print_init_params($link);
404 print_runtime_info($link);
406 # assign client-passed params to session
407 $_SESSION["client.userAgent"] = $_REQUEST["ua"];
410 print "</rpc-reply>";
415 if ($subop == "globalPurge") {
418 global_purge_old_posts($link, true);
419 print "</rpc-reply>";
424 if ($subop == "getArticleLink") {
426 $id = db_escape_string($_REQUEST["id"]);
428 $result = db_query($link, "SELECT link FROM ttrss_entries, ttrss_user_entries
429 WHERE id = '$id' AND id = ref_id AND owner_uid = '".$_SESSION['uid']."'");
431 if (db_num_rows($result) == 1) {
432 $link = htmlspecialchars(strip_tags(db_fetch_result($result, 0, "link")));
433 print "<rpc-reply><link>$link</link><id>$id</id></rpc-reply>";
435 print "<rpc-reply><error>Article not found</error></rpc-reply>";
441 if ($subop == "setArticleTags") {
443 $id = db_escape_string($_REQUEST["id"]);
445 $tags_str = db_escape_string($_REQUEST["tags_str"]);
447 $tags = array_unique(trim_array(split(",", $tags_str)));
449 db_query($link, "BEGIN");
451 $result = db_query($link, "SELECT int_id FROM ttrss_user_entries WHERE
452 ref_id = '$id' AND owner_uid = '".$_SESSION["uid"]."' LIMIT 1");
454 if (db_num_rows($result) == 1) {
456 $int_id = db_fetch_result($result, 0, "int_id");
458 db_query($link, "DELETE FROM ttrss_tags WHERE
459 post_int_id = $int_id AND owner_uid = '".$_SESSION["uid"]."'");
461 foreach ($tags as $tag) {
462 $tag = sanitize_tag($tag);
464 if (!tag_is_valid($tag)) {
468 if (preg_match("/^[0-9]*$/", $tag)) {
472 // print "<!-- $id : $int_id : $tag -->";
475 db_query($link, "INSERT INTO ttrss_tags
476 (post_int_id, owner_uid, tag_name) VALUES ('$int_id', '".$_SESSION["uid"]."', '$tag')");
481 db_query($link, "COMMIT");
483 $tags_str = format_tags_string(get_article_tags($link, $id), $id);
486 <tags-str id=\"$id\"><![CDATA[$tags_str]]></tags-str>
492 if ($subop == "regenPubKey") {
496 set_pref($link, "_PREFS_PUBLISH_KEY", generate_publish_key(), $_SESSION["uid"]);
498 $new_link = article_publish_url($link);
500 print "<link><![CDATA[$new_link]]></link>";
502 print "</rpc-reply>";
507 if ($subop == "logout") {
513 if ($subop == "completeTags") {
515 $search = db_escape_string($_REQUEST["search"]);
517 $result = db_query($link, "SELECT DISTINCT tag_name FROM ttrss_tags
518 WHERE owner_uid = '".$_SESSION["uid"]."' AND
519 tag_name LIKE '$search%' ORDER BY tag_name
523 while ($line = db_fetch_assoc($result)) {
524 print "<li>" . $line["tag_name"] . "</li>";
531 if ($subop == "purge") {
532 $ids = split(",", db_escape_string($_REQUEST["ids"]));
533 $days = sprintf("%d", $_REQUEST["days"]);
537 print "<message><![CDATA[";
539 foreach ($ids as $id) {
541 $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE
542 id = '$id' AND owner_uid = ".$_SESSION["uid"]);
544 if (db_num_rows($result) == 1) {
545 purge_feed($link, $id, $days, true);
549 print "]]></message>";
551 print "</rpc-reply>";
556 /* if ($subop == "setScore") {
557 $id = db_escape_string($_REQUEST["id"]);
558 $score = sprintf("%d", $_REQUEST["score"]);
560 $result = db_query($link, "UPDATE ttrss_user_entries SET score = '$score'
561 WHERE ref_id = '$id' AND owner_uid = ".$_SESSION["uid"]);
563 print "<rpc-reply><message>Acknowledged.</message></rpc-reply>";
569 if ($subop == "getArticles") {
570 $ids = split(",", db_escape_string($_REQUEST["ids"]));
574 foreach ($ids as $id) {
576 outputArticleXML($link, $id, 0, false);
579 print "</rpc-reply>";
584 if ($subop == "checkDate") {
586 $date = db_escape_string($_REQUEST["date"]);
587 $date_parsed = strtotime($date);
592 print "<result>1</result>";
594 print "<result>0</result>";
597 print "</rpc-reply>";
602 if ($subop == "removeFromLabel") {
604 $ids = split(",", db_escape_string($_REQUEST["ids"]));
605 $label_id = db_escape_string($_REQUEST["lid"]);
607 $label = db_escape_string(label_find_caption($link, $label_id,
611 print "<info-for-headlines>";
615 foreach ($ids as $id) {
616 label_remove_article($link, $id, $label, $_SESSION["uid"]);
618 print "<entry id=\"$id\"><![CDATA[";
620 $labels = get_article_labels($link, $id, $_SESSION["uid"]);
621 print format_article_labels($labels, $id);
628 print "</info-for-headlines>";
631 getAllCounters($link, $omode);
633 print "</rpc-reply>";
638 if ($subop == "assignToLabel") {
640 $ids = split(",", db_escape_string($_REQUEST["ids"]));
641 $label_id = db_escape_string($_REQUEST["lid"]);
643 $label = db_escape_string(label_find_caption($link, $label_id,
648 print "<info-for-headlines>";
652 foreach ($ids as $id) {
653 label_add_article($link, $id, $label, $_SESSION["uid"]);
655 print "<entry id=\"$id\"><![CDATA[";
657 $labels = get_article_labels($link, $id, $_SESSION["uid"]);
658 print format_article_labels($labels, $id);
665 print "</info-for-headlines>";
668 getAllCounters($link, $omode);
670 print "</rpc-reply>";
675 if ($subop == "updateFeedBrowser") {
677 $search = db_escape_string($_REQUEST["search"]);
678 $limit = db_escape_string($_REQUEST["limit"]);
679 $mode = db_escape_string($_REQUEST["mode"]);
684 $ctr = print_feed_browser($link, $search, $limit, $mode);
687 print "<num-results value=\"$ctr\"/>";
688 print "<mode value=\"$mode\"/>";
689 print "</rpc-reply>";
695 if ($subop == "massSubscribe") {
697 $ids = split(",", db_escape_string($_REQUEST["ids"]));
698 $mode = $_REQUEST["mode"];
700 $subscribed = array();
702 foreach ($ids as $id) {
705 $result = db_query($link, "SELECT feed_url,title FROM ttrss_feeds
707 } else if ($mode == 2) {
708 $result = db_query($link, "SELECT * FROM ttrss_archived_feeds
709 WHERE id = '$id' AND owner_uid = " . $_SESSION["uid"]);
710 $orig_id = db_escape_string(db_fetch_result($result, 0, "id"));
711 $site_url = db_escape_string(db_fetch_result($result, 0, "site_url"));
714 $feed_url = db_escape_string(db_fetch_result($result, 0, "feed_url"));
715 $title = db_escape_string(db_fetch_result($result, 0, "title"));
717 $title_orig = db_fetch_result($result, 0, "title");
719 $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE
720 feed_url = '$feed_url' AND owner_uid = " . $_SESSION["uid"]);
722 if (db_num_rows($result) == 0) {
724 $result = db_query($link,
725 "INSERT INTO ttrss_feeds (owner_uid,feed_url,title,cat_id)
726 VALUES ('".$_SESSION["uid"]."', '$feed_url', '$title', NULL)");
727 } else if ($mode == 2) {
728 $result = db_query($link,
729 "INSERT INTO ttrss_feeds (id,owner_uid,feed_url,title,cat_id,site_url)
730 VALUES ('$orig_id','".$_SESSION["uid"]."', '$feed_url', '$title', NULL, '$site_url')");
732 array_push($subscribed, $title_orig);
736 $num_feeds = count($subscribed);
739 print "<num-feeds value='$num_feeds'/>";
740 print "</rpc-reply>";
745 if ($subop == "download") {
746 $stage = (int) $_REQUEST["stage"];
747 $cidt = (int)db_escape_string($_REQUEST["cidt"]);
748 $cidb = (int)db_escape_string($_REQUEST["cidb"]);
749 $sync = db_escape_string($_REQUEST["sync"]);
750 //$amount = (int) $_REQUEST["amount"];
751 //$unread_only = db_escape_string($_REQUEST["unread_only"]);
752 //if (!$amount) $amount = 50;
754 /* Amount is not used by the frontend offline.js anymore, it goes by
755 * date_qpart below + cidb/cidt IDs */
762 $sync = split(";", $sync);
766 if (count($sync) > 0) {
767 if (strtotime($sync[0])) {
768 $last_online = db_escape_string($sync[0]);
770 print "<sync-point><![CDATA[$last_online]]></sync-point>";
772 for ($i = 1; $i < count($sync); $i++
) {
773 $e = split(",", $sync[$i]);
775 if (count($e) == 3) {
778 $unread = bool_to_sql_bool((bool) $e[1]);
779 $marked = (bool)$e[2];
782 $marked = bool_to_sql_bool($marked);
783 $marked_qpart = "marked = $marked,";
786 $query = "UPDATE ttrss_user_entries SET
789 last_read = '$last_online'
790 WHERE ref_id = '$id' AND
791 (last_read IS NULL OR last_read < '$last_online') AND
792 owner_uid = ".$_SESSION["uid"];
794 $result = db_query($link, $query);
796 print "<sync-ok id=\"$id\"/>";
801 /* Maybe we need to further update local DB for this client */
803 $query = "SELECT ref_id,unread,marked FROM ttrss_user_entries
804 WHERE last_read >= '$last_online' AND
805 owner_uid = ".$_SESSION["uid"] . " LIMIT 1000";
807 $result = db_query($link, $query);
809 while ($line = db_fetch_assoc($result)) {
810 $unread = (int) sql_bool_to_bool($line["unread"]);
811 $marked = (int) sql_bool_to_bool($line["marked"]);
813 print "<sync-ok unread=\"$unread\" marked=\"$marked\"
814 id=\"".$line["ref_id"]."\"/>";
825 $result = db_query($link, "SELECT id, title, cat_id FROM
826 ttrss_feeds WHERE owner_uid = ".$_SESSION["uid"]);
828 while ($line = db_fetch_assoc($result)) {
830 $has_icon = (int) feed_has_icon($line["id"]);
832 print "<feed has_icon=\"$has_icon\"
833 cat_id=\"".(int)$line["cat_id"]."\" id=\"".$line["id"]."\"><![CDATA[";
834 print $line["title"];
840 print "<feed-categories>";
842 $result = db_query($link, "SELECT id, title, collapsed FROM
843 ttrss_feed_categories WHERE owner_uid = ".$_SESSION["uid"]);
845 print "<category id=\"0\" collapsed=\"".
846 (int)get_pref($link, "_COLLAPSED_UNCAT")."\"><![CDATA[";
847 print __("Uncategorized");
848 print "]]></category>";
850 print "<category id=\"-1\" collapsed=\"".
851 (int)get_pref($link, "_COLLAPSED_SPECIAL")."\"><![CDATA[";
853 print "]]></category>";
855 print "<category id=\"-2\" collapsed=\"".
856 (int)get_pref($link, "_COLLAPSED_LABELS")."\"><![CDATA[";
858 print "]]></category>";
860 while ($line = db_fetch_assoc($result)) {
862 id=\"".$line["id"]."\"
863 collapsed=\"".(int)sql_bool_to_bool($line["collapsed"])."\"><![CDATA[";
864 print $line["title"];
865 print "]]></category>";
868 print "</feed-categories>";
872 $result = db_query($link, "SELECT * FROM
873 ttrss_labels2 WHERE owner_uid = ".$_SESSION["uid"]);
875 while ($line = db_fetch_assoc($result)) {
877 id=\"".$line["id"]."\"
878 fg_color=\"".$line["fg_color"]."\"
879 bg_color=\"".$line["bg_color"]."\"
881 print $line["caption"];
894 $skip = $limit*($stage-1);
896 print "<limit value=\"$limit\"/>";
898 if ($amount > 0) $amount -= $skip;
902 $limit = min($limit, $amount);
905 $unread_qpart = "(unread = true OR marked = true) AND ";
908 if ($cidt && $cidb) {
909 $cid_qpart = "(ttrss_entries.id > $cidt OR ttrss_entries.id < $cidb) AND ";
912 if (DB_TYPE
== "pgsql") {
913 $date_qpart = "updated >= NOW() - INTERVAL '1 week' AND";
915 $date_qpart = "updated >= DATE_SUB(NOW(), INTERVAL 1 WEEK) AND";
918 $result = db_query($link,
919 "SELECT DISTINCT ttrss_entries.id,ttrss_entries.title,
921 feed_id,content,updated,unread,marked FROM
922 ttrss_user_entries,ttrss_entries,ttrss_feeds
923 WHERE $unread_qpart $cid_qpart $date_qpart
924 ttrss_feeds.id = feed_id AND
925 ref_id = ttrss_entries.id AND
926 ttrss_user_entries.owner_uid = ".$_SESSION["uid"]."
927 ORDER BY updated DESC LIMIT $limit OFFSET $skip");
929 if (function_exists('json_encode')) {
931 while ($line = db_fetch_assoc($result)) {
932 print "<article><![CDATA[";
934 $line["marked"] = (int)sql_bool_to_bool($line["marked"]);
935 $line["unread"] = (int)sql_bool_to_bool($line["unread"]);
937 $line["labels"] = get_article_labels($link, $line["id"]);
940 // $line["tags"] = format_tags_string(
941 // get_article_tags($link, $line["id"]), $line["id"]);
943 print json_encode($line);
944 print "]]></article>";
954 print "</rpc-reply>";
959 print "<rpc-reply><error>Unknown method: $subop</error></rpc-reply>";