]>
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 == "extractfeedurls") {
129 $urls = get_feeds_from_html($_REQUEST['url']);
130 print "<urls><![CDATA[" . json_encode($urls) . "]]></urls>";
132 print "</rpc-reply>";
136 if ($subop == "togglepref") {
139 $key = db_escape_string($_REQUEST["key"]);
141 set_pref($link, $key, !get_pref($link, $key));
143 $value = get_pref($link, $key);
145 print "<param-set key=\"$key\" value=\"$value\"/>";
147 print "</rpc-reply>";
152 if ($subop == "setpref") {
155 $key = db_escape_string($_REQUEST["key"]);
156 $value = db_escape_string($_REQUEST["value"]);
158 set_pref($link, $key, $value);
160 print "<param-set key=\"$key\" value=\"$value\"/>";
162 print "</rpc-reply>";
167 if ($subop == "getAllCounters") {
169 print "<counters><![CDATA[";
171 print json_encode(getAllCounters($link, $_REQUEST['omode']));
173 print "]]></counters>";
174 print_runtime_info($link);
175 print "</rpc-reply>";
180 if ($subop == "mark") {
181 $mark = $_REQUEST["mark"];
182 $id = db_escape_string($_REQUEST["id"]);
190 // FIXME this needs collision testing
192 $result = db_query($link, "UPDATE ttrss_user_entries SET marked = $mark
193 WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]);
195 print "<rpc-reply><counters><![CDATA[";
196 print json_encode(getAllCounters($link));
197 print "]]></counters></rpc-reply>";
202 if ($subop == "delete") {
203 $ids = db_escape_string($_REQUEST["ids"]);
205 $result = db_query($link, "DELETE FROM ttrss_user_entries
206 WHERE ref_id IN ($ids) AND owner_uid = " . $_SESSION["uid"]);
208 print "<rpc-reply><counters><![CDATA[";
209 print json_encode(getAllCounters($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><![CDATA[";
223 print json_encode(getAllCounters($link));
224 print "]]></counters></rpc-reply>";
229 if ($subop == "archive") {
230 $ids = split(",", db_escape_string($_REQUEST["ids"]));
232 foreach ($ids as $id) {
233 archive_article($link, $id, $_SESSION["uid"]);
236 print "<rpc-reply><counters><![CDATA[";
237 print json_encode(getAllCounters($link));
238 print "]]></counters></rpc-reply>";
244 if ($subop == "publ") {
245 $pub = $_REQUEST["pub"];
246 $id = db_escape_string($_REQUEST["id"]);
247 $note = trim(strip_tags(db_escape_string($_REQUEST["note"])));
255 if ($note != 'undefined') {
256 $note_qpart = "note = '$note',";
259 // FIXME this needs collision testing
261 $result = db_query($link, "UPDATE ttrss_user_entries SET
264 WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]);
269 print "<counters><![CDATA[";
270 print json_encode(getAllCounters($link));
271 print "]]></counters>";
273 if ($note != 'undefined') {
274 $note_size = strlen($note);
275 print "<note id=\"$id\" size=\"$note_size\">";
276 print "<![CDATA[" . format_article_note($id, $note) . "]]>";
280 print "</rpc-reply>";
285 if ($subop == "updateFeed") {
286 $feed_id = db_escape_string($_REQUEST["feed"]);
288 update_rss_feed($link, $feed_id);
291 print "<counters><![CDATA[";
292 print json_encode(getFeedCounters($link, $feed_id));
293 print "]]></counters>";
294 print "</rpc-reply>";
299 if ($subop == "updateAllFeeds") {
301 $global_unread_caller = sprintf("%d", $_REQUEST["uctr"]);
302 $global_unread = getGlobalUnread($link);
306 if ($global_unread_caller != $global_unread) {
307 print "<counters><![CDATA[";
308 $omode = $_REQUEST["omode"];
309 print json_encode(getAllCounters($link, $omode));
310 print "]]></counters>";
313 print_runtime_info($link);
315 print "</rpc-reply>";
320 /* GET["cmode"] = 0 - mark as read, 1 - as unread, 2 - toggle */
321 if ($subop == "catchupSelected") {
323 $ids = split(",", db_escape_string($_REQUEST["ids"]));
324 $cmode = sprintf("%d", $_REQUEST["cmode"]);
326 catchupArticlesById($link, $ids, $cmode);
329 print "<counters><![CDATA[";
330 print json_encode(getAllCounters($link, $_REQUEST['omode']));
331 print "]]></counters>";
333 print_runtime_info($link);
334 print "</rpc-reply>";
339 if ($subop == "markSelected") {
341 $ids = split(",", db_escape_string($_REQUEST["ids"]));
342 $cmode = sprintf("%d", $_REQUEST["cmode"]);
344 markArticlesById($link, $ids, $cmode);
347 print "<counters><![CDATA[";
348 print json_encode(getAllCounters($link, $_REQUEST['omode']));
349 print "]]></counters>";
350 print_runtime_info($link);
351 print "</rpc-reply>";
356 if ($subop == "publishSelected") {
358 $ids = split(",", db_escape_string($_REQUEST["ids"]));
359 $cmode = sprintf("%d", $_REQUEST["cmode"]);
361 publishArticlesById($link, $ids, $cmode);
364 print "<counters><![CDATA[";
365 print json_encode(getAllCounters($link, $_REQUEST['omode']));
366 print "]]></counters>";
367 print_runtime_info($link);
368 print "</rpc-reply>";
373 if ($subop == "sanityCheck") {
375 if (sanity_check($link)) {
376 print "<error error-code=\"0\"/>";
378 print "<init-params><![CDATA[";
379 print json_encode(make_init_params($link));
380 print "]]></init-params>";
382 print_runtime_info($link);
384 # assign client-passed params to session
385 $_SESSION["client.userAgent"] = $_REQUEST["ua"];
388 print "</rpc-reply>";
393 if ($subop == "globalPurge") {
396 global_purge_old_posts($link, true);
397 print "</rpc-reply>";
402 if ($subop == "getArticleLink") {
404 $id = db_escape_string($_REQUEST["id"]);
406 $result = db_query($link, "SELECT link FROM ttrss_entries, ttrss_user_entries
407 WHERE id = '$id' AND id = ref_id AND owner_uid = '".$_SESSION['uid']."'");
409 if (db_num_rows($result) == 1) {
410 $link = htmlspecialchars(strip_tags(db_fetch_result($result, 0, "link")));
411 print "<rpc-reply><link>$link</link><id>$id</id></rpc-reply>";
413 print "<rpc-reply><error>Article not found</error></rpc-reply>";
419 if ($subop == "setArticleTags") {
423 $id = db_escape_string($_REQUEST["id"]);
425 $tags_str = db_escape_string($_REQUEST["tags_str"]);
426 $tags = array_unique(trim_array(split(",", $tags_str)));
427 $tags_str = db_escape_string(join(",", $tags));
429 db_query($link, "BEGIN");
431 $result = db_query($link, "SELECT int_id FROM ttrss_user_entries WHERE
432 ref_id = '$id' AND owner_uid = '".$_SESSION["uid"]."' LIMIT 1");
434 if (db_num_rows($result) == 1) {
436 $int_id = db_fetch_result($result, 0, "int_id");
438 db_query($link, "DELETE FROM ttrss_tags WHERE
439 post_int_id = $int_id AND owner_uid = '".$_SESSION["uid"]."'");
441 foreach ($tags as $tag) {
442 $tag = sanitize_tag($tag);
444 if (!tag_is_valid($tag)) {
448 if (preg_match("/^[0-9]*$/", $tag)) {
452 // print "<!-- $id : $int_id : $tag -->";
455 db_query($link, "INSERT INTO ttrss_tags
456 (post_int_id, owner_uid, tag_name) VALUES ('$int_id', '".$_SESSION["uid"]."', '$tag')");
461 db_query($link, "UPDATE ttrss_user_entries
462 SET tag_cache = '$tags_str' WHERE ref_id = '$id'
463 AND owner_uid = " . $_SESSION["uid"]);
465 db_query($link, "COMMIT");
468 $obj_id = md5("TAGS:".$_SESSION["uid"].":$id");
469 $memcache->delete($obj_id);
472 $tags_str = format_tags_string(get_article_tags($link, $id), $id);
475 <tags-str id=\"$id\"><![CDATA[$tags_str]]></tags-str>
481 if ($subop == "regenOPMLKey") {
485 update_feed_access_key($link, 'OPML:Publish',
486 false, $_SESSION["uid"]);
488 $new_link = opml_publish_url($link);
489 print "<link><![CDATA[$new_link]]></link>";
490 print "</rpc-reply>";
494 if ($subop == "logout") {
500 if ($subop == "completeTags") {
502 $search = db_escape_string($_REQUEST["search"]);
504 $result = db_query($link, "SELECT DISTINCT tag_name FROM ttrss_tags
505 WHERE owner_uid = '".$_SESSION["uid"]."' AND
506 tag_name LIKE '$search%' ORDER BY tag_name
510 while ($line = db_fetch_assoc($result)) {
511 print "<li>" . $line["tag_name"] . "</li>";
518 if ($subop == "purge") {
519 $ids = split(",", db_escape_string($_REQUEST["ids"]));
520 $days = sprintf("%d", $_REQUEST["days"]);
524 print "<message><![CDATA[";
526 foreach ($ids as $id) {
528 $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE
529 id = '$id' AND owner_uid = ".$_SESSION["uid"]);
531 if (db_num_rows($result) == 1) {
532 purge_feed($link, $id, $days, true);
536 print "]]></message>";
538 print "</rpc-reply>";
543 /* if ($subop == "setScore") {
544 $id = db_escape_string($_REQUEST["id"]);
545 $score = sprintf("%d", $_REQUEST["score"]);
547 $result = db_query($link, "UPDATE ttrss_user_entries SET score = '$score'
548 WHERE ref_id = '$id' AND owner_uid = ".$_SESSION["uid"]);
550 print "<rpc-reply><message>Acknowledged.</message></rpc-reply>";
556 if ($subop == "getArticles") {
557 $ids = split(",", db_escape_string($_REQUEST["ids"]));
561 foreach ($ids as $id) {
563 outputArticleXML($link, $id, 0, false);
566 print "</rpc-reply>";
571 if ($subop == "checkDate") {
573 $date = db_escape_string($_REQUEST["date"]);
574 $date_parsed = strtotime($date);
579 print "<result>1</result>";
581 print "<result>0</result>";
584 print "</rpc-reply>";
589 if ($subop == "removeFromLabel") {
591 $ids = split(",", db_escape_string($_REQUEST["ids"]));
592 $label_id = db_escape_string($_REQUEST["lid"]);
594 $label = db_escape_string(label_find_caption($link, $label_id,
598 print "<info-for-headlines>";
602 foreach ($ids as $id) {
603 label_remove_article($link, $id, $label, $_SESSION["uid"]);
605 print "<entry id=\"$id\"><![CDATA[";
607 $labels = get_article_labels($link, $id, $_SESSION["uid"]);
608 print format_article_labels($labels, $id);
615 print "</info-for-headlines>";
617 print "<counters><![CDATA[";
618 print json_encode(getAllCounters($link, $_REQUEST['omode']));
619 print "]]></counters>";
620 print "</rpc-reply>";
625 if ($subop == "assignToLabel") {
627 $ids = split(",", db_escape_string($_REQUEST["ids"]));
628 $label_id = db_escape_string($_REQUEST["lid"]);
630 $label = db_escape_string(label_find_caption($link, $label_id,
635 print "<info-for-headlines>";
639 foreach ($ids as $id) {
640 label_add_article($link, $id, $label, $_SESSION["uid"]);
642 print "<entry id=\"$id\"><![CDATA[";
644 $labels = get_article_labels($link, $id, $_SESSION["uid"]);
645 print format_article_labels($labels, $id);
652 print "</info-for-headlines>";
654 print "<counters><![CDATA[";
655 print json_encode(getAllCounters($link, $_REQUEST['omode']));
656 print "]]></counters>";
657 print "</rpc-reply>";
662 if ($subop == "updateFeedBrowser") {
664 $search = db_escape_string($_REQUEST["search"]);
665 $limit = db_escape_string($_REQUEST["limit"]);
666 $mode = db_escape_string($_REQUEST["mode"]);
671 $ctr = print_feed_browser($link, $search, $limit, $mode);
674 print "<num-results value=\"$ctr\"/>";
675 print "<mode value=\"$mode\"/>";
676 print "</rpc-reply>";
682 if ($subop == "massSubscribe") {
684 $ids = split(",", db_escape_string($_REQUEST["ids"]));
685 $mode = $_REQUEST["mode"];
687 $subscribed = array();
689 foreach ($ids as $id) {
692 $result = db_query($link, "SELECT feed_url,title FROM ttrss_feeds
694 } else if ($mode == 2) {
695 $result = db_query($link, "SELECT * FROM ttrss_archived_feeds
696 WHERE id = '$id' AND owner_uid = " . $_SESSION["uid"]);
697 $orig_id = db_escape_string(db_fetch_result($result, 0, "id"));
698 $site_url = db_escape_string(db_fetch_result($result, 0, "site_url"));
701 $feed_url = db_escape_string(db_fetch_result($result, 0, "feed_url"));
702 $title = db_escape_string(db_fetch_result($result, 0, "title"));
704 $title_orig = db_fetch_result($result, 0, "title");
706 $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE
707 feed_url = '$feed_url' AND owner_uid = " . $_SESSION["uid"]);
709 if (db_num_rows($result) == 0) {
711 $result = db_query($link,
712 "INSERT INTO ttrss_feeds (owner_uid,feed_url,title,cat_id)
713 VALUES ('".$_SESSION["uid"]."', '$feed_url', '$title', NULL)");
714 } else if ($mode == 2) {
715 $result = db_query($link,
716 "INSERT INTO ttrss_feeds (id,owner_uid,feed_url,title,cat_id,site_url)
717 VALUES ('$orig_id','".$_SESSION["uid"]."', '$feed_url', '$title', NULL, '$site_url')");
719 array_push($subscribed, $title_orig);
723 $num_feeds = count($subscribed);
726 print "<num-feeds value='$num_feeds'/>";
727 print "</rpc-reply>";
732 if ($subop == "download") {
733 $stage = (int) $_REQUEST["stage"];
734 $cidt = (int)db_escape_string($_REQUEST["cidt"]);
735 $cidb = (int)db_escape_string($_REQUEST["cidb"]);
736 $sync = db_escape_string($_REQUEST["sync"]);
737 //$amount = (int) $_REQUEST["amount"];
738 //$unread_only = db_escape_string($_REQUEST["unread_only"]);
739 //if (!$amount) $amount = 50;
741 /* Amount is not used by the frontend offline.js anymore, it goes by
742 * date_qpart below + cidb/cidt IDs */
749 $sync = split(";", $sync);
753 if (count($sync) > 0) {
754 if (strtotime($sync[0])) {
755 $last_online = db_escape_string($sync[0]);
757 print "<sync-point><![CDATA[$last_online]]></sync-point>";
759 for ($i = 1; $i < count($sync); $i++
) {
760 $e = split(",", $sync[$i]);
762 if (count($e) == 3) {
765 $unread = bool_to_sql_bool((bool) $e[1]);
766 $marked = (bool)$e[2];
769 $marked = bool_to_sql_bool($marked);
770 $marked_qpart = "marked = $marked,";
773 $query = "UPDATE ttrss_user_entries SET
776 last_read = '$last_online'
777 WHERE ref_id = '$id' AND
778 (last_read IS NULL OR last_read < '$last_online') AND
779 owner_uid = ".$_SESSION["uid"];
781 $result = db_query($link, $query);
783 print "<sync-ok id=\"$id\"/>";
788 /* Maybe we need to further update local DB for this client */
790 $query = "SELECT ref_id,unread,marked FROM ttrss_user_entries
791 WHERE last_read >= '$last_online' AND
792 owner_uid = ".$_SESSION["uid"] . " LIMIT 1000";
794 $result = db_query($link, $query);
796 while ($line = db_fetch_assoc($result)) {
797 $unread = (int) sql_bool_to_bool($line["unread"]);
798 $marked = (int) sql_bool_to_bool($line["marked"]);
800 print "<sync-ok unread=\"$unread\" marked=\"$marked\"
801 id=\"".$line["ref_id"]."\"/>";
812 $result = db_query($link, "SELECT id, title, cat_id FROM
813 ttrss_feeds WHERE owner_uid = ".$_SESSION["uid"]);
815 while ($line = db_fetch_assoc($result)) {
817 $has_icon = (int) feed_has_icon($line["id"]);
819 print "<feed has_icon=\"$has_icon\"
820 cat_id=\"".(int)$line["cat_id"]."\" id=\"".$line["id"]."\"><![CDATA[";
821 print $line["title"];
827 print "<feed-categories>";
829 $result = db_query($link, "SELECT id, title, collapsed FROM
830 ttrss_feed_categories WHERE owner_uid = ".$_SESSION["uid"]);
832 print "<category id=\"0\" collapsed=\"".
833 (int)get_pref($link, "_COLLAPSED_UNCAT")."\"><![CDATA[";
834 print __("Uncategorized");
835 print "]]></category>";
837 print "<category id=\"-1\" collapsed=\"".
838 (int)get_pref($link, "_COLLAPSED_SPECIAL")."\"><![CDATA[";
840 print "]]></category>";
842 print "<category id=\"-2\" collapsed=\"".
843 (int)get_pref($link, "_COLLAPSED_LABELS")."\"><![CDATA[";
845 print "]]></category>";
847 while ($line = db_fetch_assoc($result)) {
849 id=\"".$line["id"]."\"
850 collapsed=\"".(int)sql_bool_to_bool($line["collapsed"])."\"><![CDATA[";
851 print $line["title"];
852 print "]]></category>";
855 print "</feed-categories>";
859 $result = db_query($link, "SELECT * FROM
860 ttrss_labels2 WHERE owner_uid = ".$_SESSION["uid"]);
862 while ($line = db_fetch_assoc($result)) {
864 id=\"".$line["id"]."\"
865 fg_color=\"".$line["fg_color"]."\"
866 bg_color=\"".$line["bg_color"]."\"
868 print $line["caption"];
881 $skip = $limit*($stage-1);
883 print "<limit value=\"$limit\"/>";
885 if ($amount > 0) $amount -= $skip;
889 $limit = min($limit, $amount);
892 $unread_qpart = "(unread = true OR marked = true) AND ";
895 if ($cidt && $cidb) {
896 $cid_qpart = "(ttrss_entries.id > $cidt OR ttrss_entries.id < $cidb) AND ";
899 if (DB_TYPE
== "pgsql") {
900 $date_qpart = "updated >= NOW() - INTERVAL '1 week' AND";
902 $date_qpart = "updated >= DATE_SUB(NOW(), INTERVAL 1 WEEK) AND";
905 $result = db_query($link,
906 "SELECT DISTINCT ttrss_entries.id,ttrss_entries.title,
908 feed_id,content,updated,unread,marked FROM
909 ttrss_user_entries,ttrss_entries,ttrss_feeds
910 WHERE $unread_qpart $cid_qpart $date_qpart
911 ttrss_feeds.id = feed_id AND
912 ref_id = ttrss_entries.id AND
913 ttrss_user_entries.owner_uid = ".$_SESSION["uid"]."
914 ORDER BY updated DESC LIMIT $limit OFFSET $skip");
916 if (function_exists('json_encode')) {
918 while ($line = db_fetch_assoc($result)) {
919 print "<article><![CDATA[";
921 $line["marked"] = (int)sql_bool_to_bool($line["marked"]);
922 $line["unread"] = (int)sql_bool_to_bool($line["unread"]);
924 $line["labels"] = get_article_labels($link, $line["id"]);
927 // $line["tags"] = format_tags_string(
928 // get_article_tags($link, $line["id"]), $line["id"]);
930 print json_encode($line);
931 print "]]></article>";
941 print "</rpc-reply>";
946 if ($subop == "digest-get-contents") {
947 $article_id = db_escape_string($_REQUEST['article_id']);
949 $result = db_query($link, "SELECT content
950 FROM ttrss_entries, ttrss_user_entries
951 WHERE id = '$article_id' AND ref_id = id AND owner_uid = ".$_SESSION['uid']);
955 print "<article id=\"$article_id\"><![CDATA[";
957 $content = sanitize_rss($link, db_fetch_result($result, 0, "content"));
961 print "]]></article>";
963 print "</rpc-reply>";
968 if ($subop == "digest-update") {
969 $feed_id = db_escape_string($_REQUEST['feed_id']);
970 $offset = db_escape_string($_REQUEST['offset']);
971 $seq = db_escape_string($_REQUEST['seq']);
973 if (!$feed_id) $feed_id = -4;
974 if (!$offset) $offset = 0;
977 print "<seq>$seq</seq>";
979 $headlines = api_get_headlines($link, $feed_id, 10, $offset,
980 '', ($feed_id == -4), true, false, "unread", "updated DESC");
982 //function api_get_headlines($link, $feed_id, $limit, $offset,
983 // $filter, $is_cat, $show_excerpt, $show_content, $view_mode) {
985 print "<headlines-title><![CDATA[" . getFeedTitle($link, $feed_id) .
986 "]]></headlines-title>";
988 print "<headlines><![CDATA[" . json_encode($headlines) . "]]></headlines>";
990 print "</rpc-reply>";
994 if ($subop == "digest-init") {
997 $tmp_feeds = api_get_feeds($link, false, true, false, 0);
1000 foreach ($tmp_feeds as $f) {
1001 if ($f['id'] > 0 ||
$f['id'] == -4) array_push($feeds, $f);
1004 print "<feeds><![CDATA[" . json_encode($feeds) . "]]></feeds>";
1006 print "</rpc-reply>";
1010 if ($subop == "catchupFeed") {
1012 $feed_id = db_escape_string($_REQUEST['feed_id']);
1013 $is_cat = db_escape_string($_REQUEST['is_cat']);
1015 print "<rpc-reply>";
1017 catchup_feed($link, $feed_id, $is_cat);
1019 print "</rpc-reply>";
1024 if ($subop == "sendEmail") {
1025 $secretkey = $_REQUEST['secretkey'];
1027 print "<rpc-reply>";
1029 if (DIGEST_ENABLE
&& $_SESSION['email_secretkey'] &&
1030 $secretkey == $_SESSION['email_secretkey']) {
1032 $_SESSION['email_secretkey'] = '';
1034 $destination = $_REQUEST['destination'];
1035 $subject = $_REQUEST['subject'];
1036 $content = $_REQUEST['content'];
1038 $replyto = strip_tags($_SESSION['email_replyto']);
1039 $fromname = strip_tags($_SESSION['email_fromname']);
1041 $mail = new PHPMailer();
1043 $mail->PluginDir
= "lib/phpmailer/";
1044 $mail->SetLanguage("en", "lib/phpmailer/language/");
1046 $mail->CharSet
= "UTF-8";
1048 $mail->From
= $replyto;
1049 $mail->FromName
= $fromname;
1050 $mail->AddAddress($destination);
1052 if (DIGEST_SMTP_HOST
) {
1053 $mail->Host
= DIGEST_SMTP_HOST
;
1054 $mail->Mailer
= "smtp";
1055 $mail->SMTPAuth
= DIGEST_SMTP_LOGIN
!= '';
1056 $mail->Username
= DIGEST_SMTP_LOGIN
;
1057 $mail->Password
= DIGEST_SMTP_PASSWORD
;
1060 $mail->IsHTML(false);
1061 $mail->Subject
= $subject;
1062 $mail->Body
= $content;
1064 $rc = $mail->Send();
1067 print "<error><![CDATA[" . $mail->ErrorInfo
. "]]></error>";
1069 save_email_address($link, db_escape_string($destination));
1070 print "<message>OK</message>";
1074 print "<error>Not authorized.</error>";
1077 print "</rpc-reply>";
1082 if ($subop == "completeEmails") {
1084 $search = db_escape_string($_REQUEST["search"]);
1088 foreach ($_SESSION['stored_emails'] as $email) {
1089 if (strpos($email, $search) !== false) {
1090 print "<li>$email</li>";
1099 if ($subop == "quickAddCat") {
1100 print "<rpc-reply>";
1102 $cat = db_escape_string($_REQUEST["cat"]);
1104 add_feed_category($link, $cat);
1106 $result = db_query($link, "SELECT id FROM ttrss_feed_categories WHERE
1107 title = '$cat' AND owner_uid = " . $_SESSION["uid"]);
1109 if (db_num_rows($result) == 1) {
1110 $id = db_fetch_result($result, 0, "id");
1115 print_feed_cat_select($link, "cat_id", $id);
1117 print "</rpc-reply>";
1122 if ($subop == "regenFeedKey") {
1123 $feed_id = db_escape_string($_REQUEST['id']);
1124 $is_cat = (bool) db_escape_string($_REQUEST['is_cat']);
1126 print "<rpc-reply>";
1128 $new_key = update_feed_access_key($link, $feed_id, $is_cat);
1130 print "<link><![CDATA[$new_key]]></link>";
1132 print "</rpc-reply>";
1137 if ($subop == "clearKeys") {
1139 db_query($link, "DELETE FROM ttrss_access_keys WHERE
1140 owner_uid = " . $_SESSION["uid"]);
1142 print "<rpc-reply><message>OK</message></rpc-reply>";
1147 print "<rpc-reply><error>Unknown method: $subop</error></rpc-reply>";