]>
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") {
445 $id = db_escape_string($_REQUEST["id"]);
447 $tags_str = db_escape_string($_REQUEST["tags_str"]);
449 $tags = array_unique(trim_array(split(",", $tags_str)));
451 db_query($link, "BEGIN");
453 $result = db_query($link, "SELECT int_id FROM ttrss_user_entries WHERE
454 ref_id = '$id' AND owner_uid = '".$_SESSION["uid"]."' LIMIT 1");
456 if (db_num_rows($result) == 1) {
458 $int_id = db_fetch_result($result, 0, "int_id");
460 db_query($link, "DELETE FROM ttrss_tags WHERE
461 post_int_id = $int_id AND owner_uid = '".$_SESSION["uid"]."'");
463 foreach ($tags as $tag) {
464 $tag = sanitize_tag($tag);
466 if (!tag_is_valid($tag)) {
470 if (preg_match("/^[0-9]*$/", $tag)) {
474 // print "<!-- $id : $int_id : $tag -->";
477 db_query($link, "INSERT INTO ttrss_tags
478 (post_int_id, owner_uid, tag_name) VALUES ('$int_id', '".$_SESSION["uid"]."', '$tag')");
483 db_query($link, "COMMIT");
486 $obj_id = md5("TAGS:".$_SESSION["uid"].":$id");
487 $memcache->delete($obj_id);
490 $tags_str = format_tags_string(get_article_tags($link, $id), $id);
493 <tags-str id=\"$id\"><![CDATA[$tags_str]]></tags-str>
499 if ($subop == "regenPubKey") {
503 set_pref($link, "_PREFS_PUBLISH_KEY", generate_publish_key(), $_SESSION["uid"]);
505 $new_link = article_publish_url($link);
507 print "<link><![CDATA[$new_link]]></link>";
509 print "</rpc-reply>";
514 if ($subop == "logout") {
520 if ($subop == "completeTags") {
522 $search = db_escape_string($_REQUEST["search"]);
524 $result = db_query($link, "SELECT DISTINCT tag_name FROM ttrss_tags
525 WHERE owner_uid = '".$_SESSION["uid"]."' AND
526 tag_name LIKE '$search%' ORDER BY tag_name
530 while ($line = db_fetch_assoc($result)) {
531 print "<li>" . $line["tag_name"] . "</li>";
538 if ($subop == "purge") {
539 $ids = split(",", db_escape_string($_REQUEST["ids"]));
540 $days = sprintf("%d", $_REQUEST["days"]);
544 print "<message><![CDATA[";
546 foreach ($ids as $id) {
548 $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE
549 id = '$id' AND owner_uid = ".$_SESSION["uid"]);
551 if (db_num_rows($result) == 1) {
552 purge_feed($link, $id, $days, true);
556 print "]]></message>";
558 print "</rpc-reply>";
563 /* if ($subop == "setScore") {
564 $id = db_escape_string($_REQUEST["id"]);
565 $score = sprintf("%d", $_REQUEST["score"]);
567 $result = db_query($link, "UPDATE ttrss_user_entries SET score = '$score'
568 WHERE ref_id = '$id' AND owner_uid = ".$_SESSION["uid"]);
570 print "<rpc-reply><message>Acknowledged.</message></rpc-reply>";
576 if ($subop == "getArticles") {
577 $ids = split(",", db_escape_string($_REQUEST["ids"]));
581 foreach ($ids as $id) {
583 outputArticleXML($link, $id, 0, false);
586 print "</rpc-reply>";
591 if ($subop == "checkDate") {
593 $date = db_escape_string($_REQUEST["date"]);
594 $date_parsed = strtotime($date);
599 print "<result>1</result>";
601 print "<result>0</result>";
604 print "</rpc-reply>";
609 if ($subop == "removeFromLabel") {
611 $ids = split(",", db_escape_string($_REQUEST["ids"]));
612 $label_id = db_escape_string($_REQUEST["lid"]);
614 $label = db_escape_string(label_find_caption($link, $label_id,
618 print "<info-for-headlines>";
622 foreach ($ids as $id) {
623 label_remove_article($link, $id, $label, $_SESSION["uid"]);
625 print "<entry id=\"$id\"><![CDATA[";
627 $labels = get_article_labels($link, $id, $_SESSION["uid"]);
628 print format_article_labels($labels, $id);
635 print "</info-for-headlines>";
638 getAllCounters($link, $omode);
640 print "</rpc-reply>";
645 if ($subop == "assignToLabel") {
647 $ids = split(",", db_escape_string($_REQUEST["ids"]));
648 $label_id = db_escape_string($_REQUEST["lid"]);
650 $label = db_escape_string(label_find_caption($link, $label_id,
655 print "<info-for-headlines>";
659 foreach ($ids as $id) {
660 label_add_article($link, $id, $label, $_SESSION["uid"]);
662 print "<entry id=\"$id\"><![CDATA[";
664 $labels = get_article_labels($link, $id, $_SESSION["uid"]);
665 print format_article_labels($labels, $id);
672 print "</info-for-headlines>";
675 getAllCounters($link, $omode);
677 print "</rpc-reply>";
682 if ($subop == "updateFeedBrowser") {
684 $search = db_escape_string($_REQUEST["search"]);
685 $limit = db_escape_string($_REQUEST["limit"]);
686 $mode = db_escape_string($_REQUEST["mode"]);
691 $ctr = print_feed_browser($link, $search, $limit, $mode);
694 print "<num-results value=\"$ctr\"/>";
695 print "<mode value=\"$mode\"/>";
696 print "</rpc-reply>";
702 if ($subop == "massSubscribe") {
704 $ids = split(",", db_escape_string($_REQUEST["ids"]));
705 $mode = $_REQUEST["mode"];
707 $subscribed = array();
709 foreach ($ids as $id) {
712 $result = db_query($link, "SELECT feed_url,title FROM ttrss_feeds
714 } else if ($mode == 2) {
715 $result = db_query($link, "SELECT * FROM ttrss_archived_feeds
716 WHERE id = '$id' AND owner_uid = " . $_SESSION["uid"]);
717 $orig_id = db_escape_string(db_fetch_result($result, 0, "id"));
718 $site_url = db_escape_string(db_fetch_result($result, 0, "site_url"));
721 $feed_url = db_escape_string(db_fetch_result($result, 0, "feed_url"));
722 $title = db_escape_string(db_fetch_result($result, 0, "title"));
724 $title_orig = db_fetch_result($result, 0, "title");
726 $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE
727 feed_url = '$feed_url' AND owner_uid = " . $_SESSION["uid"]);
729 if (db_num_rows($result) == 0) {
731 $result = db_query($link,
732 "INSERT INTO ttrss_feeds (owner_uid,feed_url,title,cat_id)
733 VALUES ('".$_SESSION["uid"]."', '$feed_url', '$title', NULL)");
734 } else if ($mode == 2) {
735 $result = db_query($link,
736 "INSERT INTO ttrss_feeds (id,owner_uid,feed_url,title,cat_id,site_url)
737 VALUES ('$orig_id','".$_SESSION["uid"]."', '$feed_url', '$title', NULL, '$site_url')");
739 array_push($subscribed, $title_orig);
743 $num_feeds = count($subscribed);
746 print "<num-feeds value='$num_feeds'/>";
747 print "</rpc-reply>";
752 if ($subop == "download") {
753 $stage = (int) $_REQUEST["stage"];
754 $cidt = (int)db_escape_string($_REQUEST["cidt"]);
755 $cidb = (int)db_escape_string($_REQUEST["cidb"]);
756 $sync = db_escape_string($_REQUEST["sync"]);
757 //$amount = (int) $_REQUEST["amount"];
758 //$unread_only = db_escape_string($_REQUEST["unread_only"]);
759 //if (!$amount) $amount = 50;
761 /* Amount is not used by the frontend offline.js anymore, it goes by
762 * date_qpart below + cidb/cidt IDs */
769 $sync = split(";", $sync);
773 if (count($sync) > 0) {
774 if (strtotime($sync[0])) {
775 $last_online = db_escape_string($sync[0]);
777 print "<sync-point><![CDATA[$last_online]]></sync-point>";
779 for ($i = 1; $i < count($sync); $i++
) {
780 $e = split(",", $sync[$i]);
782 if (count($e) == 3) {
785 $unread = bool_to_sql_bool((bool) $e[1]);
786 $marked = (bool)$e[2];
789 $marked = bool_to_sql_bool($marked);
790 $marked_qpart = "marked = $marked,";
793 $query = "UPDATE ttrss_user_entries SET
796 last_read = '$last_online'
797 WHERE ref_id = '$id' AND
798 (last_read IS NULL OR last_read < '$last_online') AND
799 owner_uid = ".$_SESSION["uid"];
801 $result = db_query($link, $query);
803 print "<sync-ok id=\"$id\"/>";
808 /* Maybe we need to further update local DB for this client */
810 $query = "SELECT ref_id,unread,marked FROM ttrss_user_entries
811 WHERE last_read >= '$last_online' AND
812 owner_uid = ".$_SESSION["uid"] . " LIMIT 1000";
814 $result = db_query($link, $query);
816 while ($line = db_fetch_assoc($result)) {
817 $unread = (int) sql_bool_to_bool($line["unread"]);
818 $marked = (int) sql_bool_to_bool($line["marked"]);
820 print "<sync-ok unread=\"$unread\" marked=\"$marked\"
821 id=\"".$line["ref_id"]."\"/>";
832 $result = db_query($link, "SELECT id, title, cat_id FROM
833 ttrss_feeds WHERE owner_uid = ".$_SESSION["uid"]);
835 while ($line = db_fetch_assoc($result)) {
837 $has_icon = (int) feed_has_icon($line["id"]);
839 print "<feed has_icon=\"$has_icon\"
840 cat_id=\"".(int)$line["cat_id"]."\" id=\"".$line["id"]."\"><![CDATA[";
841 print $line["title"];
847 print "<feed-categories>";
849 $result = db_query($link, "SELECT id, title, collapsed FROM
850 ttrss_feed_categories WHERE owner_uid = ".$_SESSION["uid"]);
852 print "<category id=\"0\" collapsed=\"".
853 (int)get_pref($link, "_COLLAPSED_UNCAT")."\"><![CDATA[";
854 print __("Uncategorized");
855 print "]]></category>";
857 print "<category id=\"-1\" collapsed=\"".
858 (int)get_pref($link, "_COLLAPSED_SPECIAL")."\"><![CDATA[";
860 print "]]></category>";
862 print "<category id=\"-2\" collapsed=\"".
863 (int)get_pref($link, "_COLLAPSED_LABELS")."\"><![CDATA[";
865 print "]]></category>";
867 while ($line = db_fetch_assoc($result)) {
869 id=\"".$line["id"]."\"
870 collapsed=\"".(int)sql_bool_to_bool($line["collapsed"])."\"><![CDATA[";
871 print $line["title"];
872 print "]]></category>";
875 print "</feed-categories>";
879 $result = db_query($link, "SELECT * FROM
880 ttrss_labels2 WHERE owner_uid = ".$_SESSION["uid"]);
882 while ($line = db_fetch_assoc($result)) {
884 id=\"".$line["id"]."\"
885 fg_color=\"".$line["fg_color"]."\"
886 bg_color=\"".$line["bg_color"]."\"
888 print $line["caption"];
901 $skip = $limit*($stage-1);
903 print "<limit value=\"$limit\"/>";
905 if ($amount > 0) $amount -= $skip;
909 $limit = min($limit, $amount);
912 $unread_qpart = "(unread = true OR marked = true) AND ";
915 if ($cidt && $cidb) {
916 $cid_qpart = "(ttrss_entries.id > $cidt OR ttrss_entries.id < $cidb) AND ";
919 if (DB_TYPE
== "pgsql") {
920 $date_qpart = "updated >= NOW() - INTERVAL '1 week' AND";
922 $date_qpart = "updated >= DATE_SUB(NOW(), INTERVAL 1 WEEK) AND";
925 $result = db_query($link,
926 "SELECT DISTINCT ttrss_entries.id,ttrss_entries.title,
928 feed_id,content,updated,unread,marked FROM
929 ttrss_user_entries,ttrss_entries,ttrss_feeds
930 WHERE $unread_qpart $cid_qpart $date_qpart
931 ttrss_feeds.id = feed_id AND
932 ref_id = ttrss_entries.id AND
933 ttrss_user_entries.owner_uid = ".$_SESSION["uid"]."
934 ORDER BY updated DESC LIMIT $limit OFFSET $skip");
936 if (function_exists('json_encode')) {
938 while ($line = db_fetch_assoc($result)) {
939 print "<article><![CDATA[";
941 $line["marked"] = (int)sql_bool_to_bool($line["marked"]);
942 $line["unread"] = (int)sql_bool_to_bool($line["unread"]);
944 $line["labels"] = get_article_labels($link, $line["id"]);
947 // $line["tags"] = format_tags_string(
948 // get_article_tags($link, $line["id"]), $line["id"]);
950 print json_encode($line);
951 print "]]></article>";
961 print "</rpc-reply>";
966 print "<rpc-reply><error>Unknown method: $subop</error></rpc-reply>";