]>
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 == "togglepref") {
129 $key = db_escape_string($_REQUEST["key"]);
131 set_pref($link, $key, !get_pref($link, $key));
133 $value = get_pref($link, $key);
135 print "<param-set key=\"$key\" value=\"$value\"/>";
137 print "</rpc-reply>";
142 if ($subop == "setpref") {
145 $key = db_escape_string($_REQUEST["key"]);
146 $value = db_escape_string($_REQUEST["value"]);
148 set_pref($link, $key, $value);
150 print "<param-set key=\"$key\" value=\"$value\"/>";
152 print "</rpc-reply>";
157 if ($subop == "getAllCounters") {
161 $omode = $_REQUEST["omode"];
163 getAllCounters($link, $omode);
165 print_runtime_info($link);
166 print "</rpc-reply>";
171 if ($subop == "mark") {
172 $mark = $_REQUEST["mark"];
173 $id = db_escape_string($_REQUEST["id"]);
181 // FIXME this needs collision testing
183 $result = db_query($link, "UPDATE ttrss_user_entries SET marked = $mark
184 WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]);
186 print "<rpc-reply><counters>";
187 getGlobalCounters($link);
188 getVirtCounters($link);
189 getLabelCounters($link);
190 if (get_pref($link, 'ENABLE_FEED_CATS')) {
191 getCategoryCounters($link);
193 print "</counters></rpc-reply>";
198 if ($subop == "delete") {
199 $ids = db_escape_string($_REQUEST["ids"]);
201 $result = db_query($link, "DELETE FROM ttrss_user_entries
202 WHERE ref_id IN ($ids) AND owner_uid = " . $_SESSION["uid"]);
204 print "<rpc-reply><counters>";
205 getGlobalCounters($link);
206 getVirtCounters($link);
207 if (get_pref($link, 'ENABLE_FEED_CATS')) {
208 getCategoryCounters($link);
210 print "</counters></rpc-reply>";
215 if ($subop == "unarchive") {
216 $ids = db_escape_string($_REQUEST["ids"]);
218 $result = db_query($link, "UPDATE ttrss_user_entries
219 SET feed_id = orig_feed_id, orig_feed_id = NULL
220 WHERE ref_id IN ($ids) AND owner_uid = " . $_SESSION["uid"]);
222 print "<rpc-reply><counters>";
223 getGlobalCounters($link);
224 getVirtCounters($link);
225 if (get_pref($link, 'ENABLE_FEED_CATS')) {
226 getCategoryCounters($link);
228 print "</counters></rpc-reply>";
233 if ($subop == "archive") {
234 $ids = split(",", db_escape_string($_REQUEST["ids"]));
236 foreach ($ids as $id) {
237 archive_article($link, $id, $_SESSION["uid"]);
240 print "<rpc-reply><counters>";
241 getGlobalCounters($link);
242 getVirtCounters($link);
243 if (get_pref($link, 'ENABLE_FEED_CATS')) {
244 getCategoryCounters($link);
246 print "</counters></rpc-reply>";
252 if ($subop == "publ") {
253 $pub = $_REQUEST["pub"];
254 $id = db_escape_string($_REQUEST["id"]);
255 $note = trim(strip_tags(db_escape_string($_REQUEST["note"])));
263 if ($note != 'undefined') {
264 $note_qpart = "note = '$note',";
267 // FIXME this needs collision testing
269 $result = db_query($link, "UPDATE ttrss_user_entries SET
272 WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]);
278 getGlobalCounters($link);
279 getVirtCounters($link);
280 getLabelCounters($link);
281 if (get_pref($link, 'ENABLE_FEED_CATS')) {
282 getCategoryCounters($link);
286 if ($note != 'undefined') {
287 $note_size = strlen($note);
288 print "<note id=\"$id\" size=\"$note_size\">";
289 print "<![CDATA[" . format_article_note($id, $note) . "]]>";
293 print "</rpc-reply>";
298 if ($subop == "updateFeed") {
299 $feed_id = db_escape_string($_REQUEST["feed"]);
301 update_rss_feed($link, $feed_id);
305 getFeedCounter($link, $feed_id);
307 print "</rpc-reply>";
312 if ($subop == "forceUpdateAllFeeds" ||
$subop == "updateAllFeeds") {
314 $global_unread_caller = sprintf("%d", $_REQUEST["uctr"]);
315 $global_unread = getGlobalUnread($link);
321 if ($global_unread_caller != $global_unread) {
323 $omode = $_REQUEST["omode"];
325 if (!$omode) $omode = "tflc";
327 getVirtCounters($link);
329 if (strchr($omode, "l")) getLabelCounters($link);
331 if (strchr($omode, "c")) {
332 if (get_pref($link, 'ENABLE_FEED_CATS')) {
333 getCategoryCounters($link);
337 if (strchr($omode, "f")) getFeedCounters($link);
338 if (strchr($omode, "t")) getTagCounters($link);
340 getGlobalCounters($link, $global_unread);
345 print_runtime_info($link);
347 print "</rpc-reply>";
352 /* GET["cmode"] = 0 - mark as read, 1 - as unread, 2 - toggle */
353 if ($subop == "catchupSelected") {
355 $ids = split(",", db_escape_string($_REQUEST["ids"]));
356 $cmode = sprintf("%d", $_REQUEST["cmode"]);
358 catchupArticlesById($link, $ids, $cmode);
362 getAllCounters($link, $_REQUEST["omode"]);
364 print_runtime_info($link);
365 print "</rpc-reply>";
370 if ($subop == "markSelected") {
372 $ids = split(",", db_escape_string($_REQUEST["ids"]));
373 $cmode = sprintf("%d", $_REQUEST["cmode"]);
375 markArticlesById($link, $ids, $cmode);
379 getAllCounters($link, $_REQUEST["omode"]);
381 print_runtime_info($link);
382 print "</rpc-reply>";
387 if ($subop == "publishSelected") {
389 $ids = split(",", db_escape_string($_REQUEST["ids"]));
390 $cmode = sprintf("%d", $_REQUEST["cmode"]);
392 publishArticlesById($link, $ids, $cmode);
396 getAllCounters($link, $_REQUEST["omode"]);
398 print_runtime_info($link);
399 print "</rpc-reply>";
404 if ($subop == "sanityCheck") {
406 if (sanity_check($link)) {
407 print "<error error-code=\"0\"/>";
408 print_init_params($link);
409 print_runtime_info($link);
411 # assign client-passed params to session
412 $_SESSION["client.userAgent"] = $_REQUEST["ua"];
415 print "</rpc-reply>";
420 if ($subop == "globalPurge") {
423 global_purge_old_posts($link, true);
424 print "</rpc-reply>";
429 if ($subop == "getArticleLink") {
431 $id = db_escape_string($_REQUEST["id"]);
433 $result = db_query($link, "SELECT link FROM ttrss_entries, ttrss_user_entries
434 WHERE id = '$id' AND id = ref_id AND owner_uid = '".$_SESSION['uid']."'");
436 if (db_num_rows($result) == 1) {
437 $link = htmlspecialchars(strip_tags(db_fetch_result($result, 0, "link")));
438 print "<rpc-reply><link>$link</link><id>$id</id></rpc-reply>";
440 print "<rpc-reply><error>Article not found</error></rpc-reply>";
446 if ($subop == "setArticleTags") {
450 $id = db_escape_string($_REQUEST["id"]);
452 $tags_str = db_escape_string($_REQUEST["tags_str"]);
454 $tags = array_unique(trim_array(split(",", $tags_str)));
456 db_query($link, "BEGIN");
458 $result = db_query($link, "SELECT int_id FROM ttrss_user_entries WHERE
459 ref_id = '$id' AND owner_uid = '".$_SESSION["uid"]."' LIMIT 1");
461 if (db_num_rows($result) == 1) {
463 $int_id = db_fetch_result($result, 0, "int_id");
465 db_query($link, "DELETE FROM ttrss_tags WHERE
466 post_int_id = $int_id AND owner_uid = '".$_SESSION["uid"]."'");
468 foreach ($tags as $tag) {
469 $tag = sanitize_tag($tag);
471 if (!tag_is_valid($tag)) {
475 if (preg_match("/^[0-9]*$/", $tag)) {
479 // print "<!-- $id : $int_id : $tag -->";
482 db_query($link, "INSERT INTO ttrss_tags
483 (post_int_id, owner_uid, tag_name) VALUES ('$int_id', '".$_SESSION["uid"]."', '$tag')");
488 db_query($link, "COMMIT");
491 $obj_id = md5("TAGS:".$_SESSION["uid"].":$id");
492 $memcache->delete($obj_id);
495 $tags_str = format_tags_string(get_article_tags($link, $id), $id);
498 <tags-str id=\"$id\"><![CDATA[$tags_str]]></tags-str>
504 if ($subop == "regenPubKey") {
508 set_pref($link, "_PREFS_PUBLISH_KEY", generate_publish_key(), $_SESSION["uid"]);
510 $new_link = article_publish_url($link);
512 print "<link><![CDATA[$new_link]]></link>";
514 print "</rpc-reply>";
519 if ($subop == "logout") {
525 if ($subop == "completeTags") {
527 $search = db_escape_string($_REQUEST["search"]);
529 $result = db_query($link, "SELECT DISTINCT tag_name FROM ttrss_tags
530 WHERE owner_uid = '".$_SESSION["uid"]."' AND
531 tag_name LIKE '$search%' ORDER BY tag_name
535 while ($line = db_fetch_assoc($result)) {
536 print "<li>" . $line["tag_name"] . "</li>";
543 if ($subop == "purge") {
544 $ids = split(",", db_escape_string($_REQUEST["ids"]));
545 $days = sprintf("%d", $_REQUEST["days"]);
549 print "<message><![CDATA[";
551 foreach ($ids as $id) {
553 $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE
554 id = '$id' AND owner_uid = ".$_SESSION["uid"]);
556 if (db_num_rows($result) == 1) {
557 purge_feed($link, $id, $days, true);
561 print "]]></message>";
563 print "</rpc-reply>";
568 /* if ($subop == "setScore") {
569 $id = db_escape_string($_REQUEST["id"]);
570 $score = sprintf("%d", $_REQUEST["score"]);
572 $result = db_query($link, "UPDATE ttrss_user_entries SET score = '$score'
573 WHERE ref_id = '$id' AND owner_uid = ".$_SESSION["uid"]);
575 print "<rpc-reply><message>Acknowledged.</message></rpc-reply>";
581 if ($subop == "getArticles") {
582 $ids = split(",", db_escape_string($_REQUEST["ids"]));
586 foreach ($ids as $id) {
588 outputArticleXML($link, $id, 0, false);
591 print "</rpc-reply>";
596 if ($subop == "checkDate") {
598 $date = db_escape_string($_REQUEST["date"]);
599 $date_parsed = strtotime($date);
604 print "<result>1</result>";
606 print "<result>0</result>";
609 print "</rpc-reply>";
614 if ($subop == "removeFromLabel") {
616 $ids = split(",", db_escape_string($_REQUEST["ids"]));
617 $label_id = db_escape_string($_REQUEST["lid"]);
619 $label = db_escape_string(label_find_caption($link, $label_id,
623 print "<info-for-headlines>";
627 foreach ($ids as $id) {
628 label_remove_article($link, $id, $label, $_SESSION["uid"]);
630 print "<entry id=\"$id\"><![CDATA[";
632 $labels = get_article_labels($link, $id, $_SESSION["uid"]);
633 print format_article_labels($labels, $id);
640 print "</info-for-headlines>";
643 getAllCounters($link, $omode);
645 print "</rpc-reply>";
650 if ($subop == "assignToLabel") {
652 $ids = split(",", db_escape_string($_REQUEST["ids"]));
653 $label_id = db_escape_string($_REQUEST["lid"]);
655 $label = db_escape_string(label_find_caption($link, $label_id,
660 print "<info-for-headlines>";
664 foreach ($ids as $id) {
665 label_add_article($link, $id, $label, $_SESSION["uid"]);
667 print "<entry id=\"$id\"><![CDATA[";
669 $labels = get_article_labels($link, $id, $_SESSION["uid"]);
670 print format_article_labels($labels, $id);
677 print "</info-for-headlines>";
680 getAllCounters($link, $omode);
682 print "</rpc-reply>";
687 if ($subop == "updateFeedBrowser") {
689 $search = db_escape_string($_REQUEST["search"]);
690 $limit = db_escape_string($_REQUEST["limit"]);
691 $mode = db_escape_string($_REQUEST["mode"]);
696 $ctr = print_feed_browser($link, $search, $limit, $mode);
699 print "<num-results value=\"$ctr\"/>";
700 print "<mode value=\"$mode\"/>";
701 print "</rpc-reply>";
707 if ($subop == "massSubscribe") {
709 $ids = split(",", db_escape_string($_REQUEST["ids"]));
710 $mode = $_REQUEST["mode"];
712 $subscribed = array();
714 foreach ($ids as $id) {
717 $result = db_query($link, "SELECT feed_url,title FROM ttrss_feeds
719 } else if ($mode == 2) {
720 $result = db_query($link, "SELECT * FROM ttrss_archived_feeds
721 WHERE id = '$id' AND owner_uid = " . $_SESSION["uid"]);
722 $orig_id = db_escape_string(db_fetch_result($result, 0, "id"));
723 $site_url = db_escape_string(db_fetch_result($result, 0, "site_url"));
726 $feed_url = db_escape_string(db_fetch_result($result, 0, "feed_url"));
727 $title = db_escape_string(db_fetch_result($result, 0, "title"));
729 $title_orig = db_fetch_result($result, 0, "title");
731 $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE
732 feed_url = '$feed_url' AND owner_uid = " . $_SESSION["uid"]);
734 if (db_num_rows($result) == 0) {
736 $result = db_query($link,
737 "INSERT INTO ttrss_feeds (owner_uid,feed_url,title,cat_id)
738 VALUES ('".$_SESSION["uid"]."', '$feed_url', '$title', NULL)");
739 } else if ($mode == 2) {
740 $result = db_query($link,
741 "INSERT INTO ttrss_feeds (id,owner_uid,feed_url,title,cat_id,site_url)
742 VALUES ('$orig_id','".$_SESSION["uid"]."', '$feed_url', '$title', NULL, '$site_url')");
744 array_push($subscribed, $title_orig);
748 $num_feeds = count($subscribed);
751 print "<num-feeds value='$num_feeds'/>";
752 print "</rpc-reply>";
757 if ($subop == "download") {
758 $stage = (int) $_REQUEST["stage"];
759 $cidt = (int)db_escape_string($_REQUEST["cidt"]);
760 $cidb = (int)db_escape_string($_REQUEST["cidb"]);
761 $sync = db_escape_string($_REQUEST["sync"]);
762 //$amount = (int) $_REQUEST["amount"];
763 //$unread_only = db_escape_string($_REQUEST["unread_only"]);
764 //if (!$amount) $amount = 50;
766 /* Amount is not used by the frontend offline.js anymore, it goes by
767 * date_qpart below + cidb/cidt IDs */
774 $sync = split(";", $sync);
778 if (count($sync) > 0) {
779 if (strtotime($sync[0])) {
780 $last_online = db_escape_string($sync[0]);
782 print "<sync-point><![CDATA[$last_online]]></sync-point>";
784 for ($i = 1; $i < count($sync); $i++
) {
785 $e = split(",", $sync[$i]);
787 if (count($e) == 3) {
790 $unread = bool_to_sql_bool((bool) $e[1]);
791 $marked = (bool)$e[2];
794 $marked = bool_to_sql_bool($marked);
795 $marked_qpart = "marked = $marked,";
798 $query = "UPDATE ttrss_user_entries SET
801 last_read = '$last_online'
802 WHERE ref_id = '$id' AND
803 (last_read IS NULL OR last_read < '$last_online') AND
804 owner_uid = ".$_SESSION["uid"];
806 $result = db_query($link, $query);
808 print "<sync-ok id=\"$id\"/>";
813 /* Maybe we need to further update local DB for this client */
815 $query = "SELECT ref_id,unread,marked FROM ttrss_user_entries
816 WHERE last_read >= '$last_online' AND
817 owner_uid = ".$_SESSION["uid"] . " LIMIT 1000";
819 $result = db_query($link, $query);
821 while ($line = db_fetch_assoc($result)) {
822 $unread = (int) sql_bool_to_bool($line["unread"]);
823 $marked = (int) sql_bool_to_bool($line["marked"]);
825 print "<sync-ok unread=\"$unread\" marked=\"$marked\"
826 id=\"".$line["ref_id"]."\"/>";
837 $result = db_query($link, "SELECT id, title, cat_id FROM
838 ttrss_feeds WHERE owner_uid = ".$_SESSION["uid"]);
840 while ($line = db_fetch_assoc($result)) {
842 $has_icon = (int) feed_has_icon($line["id"]);
844 print "<feed has_icon=\"$has_icon\"
845 cat_id=\"".(int)$line["cat_id"]."\" id=\"".$line["id"]."\"><![CDATA[";
846 print $line["title"];
852 print "<feed-categories>";
854 $result = db_query($link, "SELECT id, title, collapsed FROM
855 ttrss_feed_categories WHERE owner_uid = ".$_SESSION["uid"]);
857 print "<category id=\"0\" collapsed=\"".
858 (int)get_pref($link, "_COLLAPSED_UNCAT")."\"><![CDATA[";
859 print __("Uncategorized");
860 print "]]></category>";
862 print "<category id=\"-1\" collapsed=\"".
863 (int)get_pref($link, "_COLLAPSED_SPECIAL")."\"><![CDATA[";
865 print "]]></category>";
867 print "<category id=\"-2\" collapsed=\"".
868 (int)get_pref($link, "_COLLAPSED_LABELS")."\"><![CDATA[";
870 print "]]></category>";
872 while ($line = db_fetch_assoc($result)) {
874 id=\"".$line["id"]."\"
875 collapsed=\"".(int)sql_bool_to_bool($line["collapsed"])."\"><![CDATA[";
876 print $line["title"];
877 print "]]></category>";
880 print "</feed-categories>";
884 $result = db_query($link, "SELECT * FROM
885 ttrss_labels2 WHERE owner_uid = ".$_SESSION["uid"]);
887 while ($line = db_fetch_assoc($result)) {
889 id=\"".$line["id"]."\"
890 fg_color=\"".$line["fg_color"]."\"
891 bg_color=\"".$line["bg_color"]."\"
893 print $line["caption"];
906 $skip = $limit*($stage-1);
908 print "<limit value=\"$limit\"/>";
910 if ($amount > 0) $amount -= $skip;
914 $limit = min($limit, $amount);
917 $unread_qpart = "(unread = true OR marked = true) AND ";
920 if ($cidt && $cidb) {
921 $cid_qpart = "(ttrss_entries.id > $cidt OR ttrss_entries.id < $cidb) AND ";
924 if (DB_TYPE
== "pgsql") {
925 $date_qpart = "updated >= NOW() - INTERVAL '1 week' AND";
927 $date_qpart = "updated >= DATE_SUB(NOW(), INTERVAL 1 WEEK) AND";
930 $result = db_query($link,
931 "SELECT DISTINCT ttrss_entries.id,ttrss_entries.title,
933 feed_id,content,updated,unread,marked FROM
934 ttrss_user_entries,ttrss_entries,ttrss_feeds
935 WHERE $unread_qpart $cid_qpart $date_qpart
936 ttrss_feeds.id = feed_id AND
937 ref_id = ttrss_entries.id AND
938 ttrss_user_entries.owner_uid = ".$_SESSION["uid"]."
939 ORDER BY updated DESC LIMIT $limit OFFSET $skip");
941 if (function_exists('json_encode')) {
943 while ($line = db_fetch_assoc($result)) {
944 print "<article><![CDATA[";
946 $line["marked"] = (int)sql_bool_to_bool($line["marked"]);
947 $line["unread"] = (int)sql_bool_to_bool($line["unread"]);
949 $line["labels"] = get_article_labels($link, $line["id"]);
952 // $line["tags"] = format_tags_string(
953 // get_article_tags($link, $line["id"]), $line["id"]);
955 print json_encode($line);
956 print "]]></article>";
966 print "</rpc-reply>";
971 print "<rpc-reply><error>Unknown method: $subop</error></rpc-reply>";