]>
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 == "mark") {
168 $mark = $_REQUEST["mark"];
169 $id = db_escape_string($_REQUEST["id"]);
177 // FIXME this needs collision testing
179 $result = db_query($link, "UPDATE ttrss_user_entries SET marked = $mark
180 WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]);
183 print "<message>UPDATE_COUNTERS</message>";
184 print "</rpc-reply>";
189 if ($subop == "delete") {
190 $ids = db_escape_string($_REQUEST["ids"]);
192 $result = db_query($link, "DELETE FROM ttrss_user_entries
193 WHERE ref_id IN ($ids) AND owner_uid = " . $_SESSION["uid"]);
196 print "<message>UPDATE_COUNTERS</message>";
197 print "</rpc-reply>";
202 if ($subop == "unarchive") {
203 $ids = db_escape_string($_REQUEST["ids"]);
205 $result = db_query($link, "UPDATE ttrss_user_entries
206 SET feed_id = orig_feed_id, orig_feed_id = NULL
207 WHERE ref_id IN ($ids) AND owner_uid = " . $_SESSION["uid"]);
210 print "<message>UPDATE_COUNTERS</message>";
211 print "</rpc-reply>";
216 if ($subop == "archive") {
217 $ids = split(",", db_escape_string($_REQUEST["ids"]));
219 foreach ($ids as $id) {
220 archive_article($link, $id, $_SESSION["uid"]);
224 print "<message>UPDATE_COUNTERS</message>";
225 print "</rpc-reply>";
231 if ($subop == "publ") {
232 $pub = $_REQUEST["pub"];
233 $id = db_escape_string($_REQUEST["id"]);
234 $note = trim(strip_tags(db_escape_string($_REQUEST["note"])));
242 if ($note != 'undefined') {
243 $note_qpart = "note = '$note',";
246 // FIXME this needs collision testing
248 $result = db_query($link, "UPDATE ttrss_user_entries SET
251 WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]);
256 if ($note != 'undefined') {
257 $note_size = strlen($note);
258 print "<note id=\"$id\" size=\"$note_size\">";
259 print "<![CDATA[" . format_article_note($id, $note) . "]]>";
263 print "<message>UPDATE_COUNTERS</message>";
265 print "</rpc-reply>";
270 if ($subop == "updateFeed") {
271 $feed_id = db_escape_string($_REQUEST["feed"]);
273 update_rss_feed($link, $feed_id);
276 print "<message>UPDATE_COUNTERS</message>";
277 print "</rpc-reply>";
282 if ($subop == "updateAllFeeds" ||
$subop == "getAllCounters") {
284 $last_article_id = (int) $_REQUEST["last_article_id"];
288 if ($last_article_id != getLastArticleId($link)) {
289 print "<counters><![CDATA[";
290 $omode = $_REQUEST["omode"];
293 print json_encode(getAllCounters($link, $omode));
295 print json_encode(getGlobalCounters($link));
297 print "]]></counters>";
300 print_runtime_info($link);
302 print "</rpc-reply>";
307 /* GET["cmode"] = 0 - mark as read, 1 - as unread, 2 - toggle */
308 if ($subop == "catchupSelected") {
310 $ids = split(",", db_escape_string($_REQUEST["ids"]));
311 $cmode = sprintf("%d", $_REQUEST["cmode"]);
313 catchupArticlesById($link, $ids, $cmode);
316 print "<message>UPDATE_COUNTERS</message>";
317 print "</rpc-reply>";
322 if ($subop == "markSelected") {
324 $ids = split(",", db_escape_string($_REQUEST["ids"]));
325 $cmode = sprintf("%d", $_REQUEST["cmode"]);
327 markArticlesById($link, $ids, $cmode);
330 print "<message>UPDATE_COUNTERS</message>";
331 print "</rpc-reply>";
336 if ($subop == "publishSelected") {
338 $ids = split(",", db_escape_string($_REQUEST["ids"]));
339 $cmode = sprintf("%d", $_REQUEST["cmode"]);
341 publishArticlesById($link, $ids, $cmode);
344 print "<message>UPDATE_COUNTERS</message>";
345 print "</rpc-reply>";
350 if ($subop == "sanityCheck") {
352 if (sanity_check($link)) {
353 print "<error error-code=\"0\"/>";
355 print "<init-params><![CDATA[";
356 print json_encode(make_init_params($link));
357 print "]]></init-params>";
359 print_runtime_info($link);
361 # assign client-passed params to session
362 $_SESSION["client.userAgent"] = $_REQUEST["ua"];
365 print "</rpc-reply>";
370 if ($subop == "globalPurge") {
373 global_purge_old_posts($link, true);
374 print "</rpc-reply>";
379 if ($subop == "getArticleLink") {
381 $id = db_escape_string($_REQUEST["id"]);
383 $result = db_query($link, "SELECT link FROM ttrss_entries, ttrss_user_entries
384 WHERE id = '$id' AND id = ref_id AND owner_uid = '".$_SESSION['uid']."'");
386 if (db_num_rows($result) == 1) {
387 $link = htmlspecialchars(strip_tags(db_fetch_result($result, 0, "link")));
388 print "<rpc-reply><link>$link</link><id>$id</id></rpc-reply>";
390 print "<rpc-reply><error>Article not found</error></rpc-reply>";
396 if ($subop == "setArticleTags") {
400 $id = db_escape_string($_REQUEST["id"]);
402 $tags_str = db_escape_string($_REQUEST["tags_str"]);
403 $tags = array_unique(trim_array(split(",", $tags_str)));
405 db_query($link, "BEGIN");
407 $result = db_query($link, "SELECT int_id FROM ttrss_user_entries WHERE
408 ref_id = '$id' AND owner_uid = '".$_SESSION["uid"]."' LIMIT 1");
410 if (db_num_rows($result) == 1) {
412 $tags_to_cache = array();
414 $int_id = db_fetch_result($result, 0, "int_id");
416 db_query($link, "DELETE FROM ttrss_tags WHERE
417 post_int_id = $int_id AND owner_uid = '".$_SESSION["uid"]."'");
419 foreach ($tags as $tag) {
420 $tag = sanitize_tag($tag);
422 if (!tag_is_valid($tag)) {
426 if (preg_match("/^[0-9]*$/", $tag)) {
430 // print "<!-- $id : $int_id : $tag -->";
433 db_query($link, "INSERT INTO ttrss_tags
434 (post_int_id, owner_uid, tag_name) VALUES ('$int_id', '".$_SESSION["uid"]."', '$tag')");
437 array_push($tags_to_cache, $tag);
440 /* update tag cache */
442 $tags_str = join(",", $tags_to_cache);
444 db_query($link, "UPDATE ttrss_user_entries
445 SET tag_cache = '$tags_str' WHERE ref_id = '$id'
446 AND owner_uid = " . $_SESSION["uid"]);
449 db_query($link, "COMMIT");
452 $obj_id = md5("TAGS:".$_SESSION["uid"].":$id");
453 $memcache->delete($obj_id);
456 $tags_str = format_tags_string(get_article_tags($link, $id), $id);
459 <tags-str id=\"$id\"><![CDATA[$tags_str]]></tags-str>
465 if ($subop == "regenOPMLKey") {
469 update_feed_access_key($link, 'OPML:Publish',
470 false, $_SESSION["uid"]);
472 $new_link = opml_publish_url($link);
473 print "<link><![CDATA[$new_link]]></link>";
474 print "</rpc-reply>";
478 if ($subop == "logout") {
484 if ($subop == "completeTags") {
486 $search = db_escape_string($_REQUEST["search"]);
488 $result = db_query($link, "SELECT DISTINCT tag_name FROM ttrss_tags
489 WHERE owner_uid = '".$_SESSION["uid"]."' AND
490 tag_name LIKE '$search%' ORDER BY tag_name
494 while ($line = db_fetch_assoc($result)) {
495 print "<li>" . $line["tag_name"] . "</li>";
502 if ($subop == "purge") {
503 $ids = split(",", db_escape_string($_REQUEST["ids"]));
504 $days = sprintf("%d", $_REQUEST["days"]);
508 print "<message><![CDATA[";
510 foreach ($ids as $id) {
512 $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE
513 id = '$id' AND owner_uid = ".$_SESSION["uid"]);
515 if (db_num_rows($result) == 1) {
516 purge_feed($link, $id, $days, true);
520 print "]]></message>";
522 print "</rpc-reply>";
527 /* if ($subop == "setScore") {
528 $id = db_escape_string($_REQUEST["id"]);
529 $score = sprintf("%d", $_REQUEST["score"]);
531 $result = db_query($link, "UPDATE ttrss_user_entries SET score = '$score'
532 WHERE ref_id = '$id' AND owner_uid = ".$_SESSION["uid"]);
534 print "<rpc-reply><message>Acknowledged.</message></rpc-reply>";
540 if ($subop == "getArticles") {
541 $ids = split(",", db_escape_string($_REQUEST["ids"]));
545 foreach ($ids as $id) {
547 outputArticleXML($link, $id, 0, false);
550 print "</rpc-reply>";
555 if ($subop == "checkDate") {
557 $date = db_escape_string($_REQUEST["date"]);
558 $date_parsed = strtotime($date);
563 print "<result>1</result>";
565 print "<result>0</result>";
568 print "</rpc-reply>";
573 if ($subop == "removeFromLabel") {
575 $ids = explode(",", db_escape_string($_REQUEST["ids"]));
576 $label_id = db_escape_string($_REQUEST["lid"]);
578 $label = db_escape_string(label_find_caption($link, $label_id,
582 print "<info-for-headlines>";
586 foreach ($ids as $id) {
587 label_remove_article($link, $id, $label, $_SESSION["uid"]);
589 print "<entry id=\"$id\"><![CDATA[";
591 $labels = get_article_labels($link, $id, $_SESSION["uid"]);
592 print format_article_labels($labels, $id);
599 print "</info-for-headlines>";
602 print "<message>UPDATE_COUNTERS</message>";
603 print "</rpc-reply>";
608 if ($subop == "assignToLabel") {
610 $ids = split(",", db_escape_string($_REQUEST["ids"]));
611 $label_id = db_escape_string($_REQUEST["lid"]);
613 $label = db_escape_string(label_find_caption($link, $label_id,
618 print "<info-for-headlines>";
622 foreach ($ids as $id) {
623 label_add_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 print "<message>UPDATE_COUNTERS</message>";
639 print "</rpc-reply>";
644 if ($subop == "updateFeedBrowser") {
646 $search = db_escape_string($_REQUEST["search"]);
647 $limit = db_escape_string($_REQUEST["limit"]);
648 $mode = db_escape_string($_REQUEST["mode"]);
653 $ctr = print_feed_browser($link, $search, $limit, $mode);
656 print "<num-results value=\"$ctr\"/>";
657 print "<mode value=\"$mode\"/>";
658 print "</rpc-reply>";
664 if ($subop == "massSubscribe") {
666 $ids = split(",", db_escape_string($_REQUEST["ids"]));
667 $mode = $_REQUEST["mode"];
669 $subscribed = array();
671 foreach ($ids as $id) {
674 $result = db_query($link, "SELECT feed_url,title FROM ttrss_feeds
676 } else if ($mode == 2) {
677 $result = db_query($link, "SELECT * FROM ttrss_archived_feeds
678 WHERE id = '$id' AND owner_uid = " . $_SESSION["uid"]);
679 $orig_id = db_escape_string(db_fetch_result($result, 0, "id"));
680 $site_url = db_escape_string(db_fetch_result($result, 0, "site_url"));
683 $feed_url = db_escape_string(db_fetch_result($result, 0, "feed_url"));
684 $title = db_escape_string(db_fetch_result($result, 0, "title"));
686 $title_orig = db_fetch_result($result, 0, "title");
688 $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE
689 feed_url = '$feed_url' AND owner_uid = " . $_SESSION["uid"]);
691 if (db_num_rows($result) == 0) {
693 $result = db_query($link,
694 "INSERT INTO ttrss_feeds (owner_uid,feed_url,title,cat_id)
695 VALUES ('".$_SESSION["uid"]."', '$feed_url', '$title', NULL)");
696 } else if ($mode == 2) {
697 $result = db_query($link,
698 "INSERT INTO ttrss_feeds (id,owner_uid,feed_url,title,cat_id,site_url)
699 VALUES ('$orig_id','".$_SESSION["uid"]."', '$feed_url', '$title', NULL, '$site_url')");
701 array_push($subscribed, $title_orig);
705 $num_feeds = count($subscribed);
708 print "<num-feeds value='$num_feeds'/>";
709 print "</rpc-reply>";
714 if ($subop == "download") {
715 $stage = (int) $_REQUEST["stage"];
716 $cidt = (int)db_escape_string($_REQUEST["cidt"]);
717 $cidb = (int)db_escape_string($_REQUEST["cidb"]);
718 $sync = db_escape_string($_REQUEST["sync"]);
719 //$amount = (int) $_REQUEST["amount"];
720 //$unread_only = db_escape_string($_REQUEST["unread_only"]);
721 //if (!$amount) $amount = 50;
723 /* Amount is not used by the frontend offline.js anymore, it goes by
724 * date_qpart below + cidb/cidt IDs */
731 $sync = split(";", $sync);
735 if (count($sync) > 0) {
736 if (strtotime($sync[0])) {
737 $last_online = db_escape_string($sync[0]);
739 print "<sync-point><![CDATA[$last_online]]></sync-point>";
741 for ($i = 1; $i < count($sync); $i++
) {
742 $e = split(",", $sync[$i]);
744 if (count($e) == 3) {
747 $unread = bool_to_sql_bool((bool) $e[1]);
748 $marked = (bool)$e[2];
751 $marked = bool_to_sql_bool($marked);
752 $marked_qpart = "marked = $marked,";
755 $query = "UPDATE ttrss_user_entries SET
758 last_read = '$last_online'
759 WHERE ref_id = '$id' AND
760 (last_read IS NULL OR last_read < '$last_online') AND
761 owner_uid = ".$_SESSION["uid"];
763 $result = db_query($link, $query);
765 print "<sync-ok id=\"$id\"/>";
770 /* Maybe we need to further update local DB for this client */
772 $query = "SELECT ref_id,unread,marked FROM ttrss_user_entries
773 WHERE last_read >= '$last_online' AND
774 owner_uid = ".$_SESSION["uid"] . " LIMIT 1000";
776 $result = db_query($link, $query);
778 while ($line = db_fetch_assoc($result)) {
779 $unread = (int) sql_bool_to_bool($line["unread"]);
780 $marked = (int) sql_bool_to_bool($line["marked"]);
782 print "<sync-ok unread=\"$unread\" marked=\"$marked\"
783 id=\"".$line["ref_id"]."\"/>";
794 $result = db_query($link, "SELECT id, title, cat_id FROM
795 ttrss_feeds WHERE owner_uid = ".$_SESSION["uid"]);
797 while ($line = db_fetch_assoc($result)) {
799 $has_icon = (int) feed_has_icon($line["id"]);
801 print "<feed has_icon=\"$has_icon\"
802 cat_id=\"".(int)$line["cat_id"]."\" id=\"".$line["id"]."\"><![CDATA[";
803 print $line["title"];
809 print "<feed-categories>";
811 $result = db_query($link, "SELECT id, title, collapsed FROM
812 ttrss_feed_categories WHERE owner_uid = ".$_SESSION["uid"]);
814 print "<category id=\"0\" collapsed=\"".
815 (int)get_pref($link, "_COLLAPSED_UNCAT")."\"><![CDATA[";
816 print __("Uncategorized");
817 print "]]></category>";
819 print "<category id=\"-1\" collapsed=\"".
820 (int)get_pref($link, "_COLLAPSED_SPECIAL")."\"><![CDATA[";
822 print "]]></category>";
824 print "<category id=\"-2\" collapsed=\"".
825 (int)get_pref($link, "_COLLAPSED_LABELS")."\"><![CDATA[";
827 print "]]></category>";
829 while ($line = db_fetch_assoc($result)) {
831 id=\"".$line["id"]."\"
832 collapsed=\"".(int)sql_bool_to_bool($line["collapsed"])."\"><![CDATA[";
833 print $line["title"];
834 print "]]></category>";
837 print "</feed-categories>";
841 $result = db_query($link, "SELECT * FROM
842 ttrss_labels2 WHERE owner_uid = ".$_SESSION["uid"]);
844 while ($line = db_fetch_assoc($result)) {
846 id=\"".$line["id"]."\"
847 fg_color=\"".$line["fg_color"]."\"
848 bg_color=\"".$line["bg_color"]."\"
850 print $line["caption"];
863 $skip = $limit*($stage-1);
865 print "<limit value=\"$limit\"/>";
867 if ($amount > 0) $amount -= $skip;
871 $limit = min($limit, $amount);
874 $unread_qpart = "(unread = true OR marked = true) AND ";
877 if ($cidt && $cidb) {
878 $cid_qpart = "(ttrss_entries.id > $cidt OR ttrss_entries.id < $cidb) AND ";
881 if (DB_TYPE
== "pgsql") {
882 $date_qpart = "updated >= NOW() - INTERVAL '1 week' AND";
884 $date_qpart = "updated >= DATE_SUB(NOW(), INTERVAL 1 WEEK) AND";
887 $result = db_query($link,
888 "SELECT DISTINCT ttrss_entries.id,ttrss_entries.title,
890 feed_id,content,updated,unread,marked FROM
891 ttrss_user_entries,ttrss_entries,ttrss_feeds
892 WHERE $unread_qpart $cid_qpart $date_qpart
893 ttrss_feeds.id = feed_id AND
894 ref_id = ttrss_entries.id AND
895 ttrss_user_entries.owner_uid = ".$_SESSION["uid"]."
896 ORDER BY updated DESC LIMIT $limit OFFSET $skip");
898 if (function_exists('json_encode')) {
900 while ($line = db_fetch_assoc($result)) {
901 print "<article><![CDATA[";
903 $line["marked"] = (int)sql_bool_to_bool($line["marked"]);
904 $line["unread"] = (int)sql_bool_to_bool($line["unread"]);
906 $line["labels"] = get_article_labels($link, $line["id"]);
909 // $line["tags"] = format_tags_string(
910 // get_article_tags($link, $line["id"]), $line["id"]);
912 print json_encode($line);
913 print "]]></article>";
923 print "</rpc-reply>";
928 if ($subop == "digest-get-contents") {
929 $article_id = db_escape_string($_REQUEST['article_id']);
931 $result = db_query($link, "SELECT content
932 FROM ttrss_entries, ttrss_user_entries
933 WHERE id = '$article_id' AND ref_id = id AND owner_uid = ".$_SESSION['uid']);
937 print "<article id=\"$article_id\"><![CDATA[";
939 $content = sanitize_rss($link, db_fetch_result($result, 0, "content"));
943 print "]]></article>";
945 print "</rpc-reply>";
950 if ($subop == "digest-update") {
951 $feed_id = db_escape_string($_REQUEST['feed_id']);
952 $offset = db_escape_string($_REQUEST['offset']);
953 $seq = db_escape_string($_REQUEST['seq']);
955 if (!$feed_id) $feed_id = -4;
956 if (!$offset) $offset = 0;
959 print "<seq>$seq</seq>";
961 $headlines = api_get_headlines($link, $feed_id, 10, $offset,
962 '', ($feed_id == -4), true, false, "unread", "updated DESC");
964 //function api_get_headlines($link, $feed_id, $limit, $offset,
965 // $filter, $is_cat, $show_excerpt, $show_content, $view_mode) {
967 print "<headlines-title><![CDATA[" . getFeedTitle($link, $feed_id) .
968 "]]></headlines-title>";
970 print "<headlines><![CDATA[" . json_encode($headlines) . "]]></headlines>";
972 print "</rpc-reply>";
976 if ($subop == "digest-init") {
979 $tmp_feeds = api_get_feeds($link, false, true, false, 0);
982 foreach ($tmp_feeds as $f) {
983 if ($f['id'] > 0 ||
$f['id'] == -4) array_push($feeds, $f);
986 print "<feeds><![CDATA[" . json_encode($feeds) . "]]></feeds>";
988 print "</rpc-reply>";
992 if ($subop == "catchupFeed") {
994 $feed_id = db_escape_string($_REQUEST['feed_id']);
995 $is_cat = db_escape_string($_REQUEST['is_cat']);
999 catchup_feed($link, $feed_id, $is_cat);
1001 print "</rpc-reply>";
1006 if ($subop == "sendEmail") {
1007 $secretkey = $_REQUEST['secretkey'];
1009 print "<rpc-reply>";
1011 if (DIGEST_ENABLE
&& $_SESSION['email_secretkey'] &&
1012 $secretkey == $_SESSION['email_secretkey']) {
1014 $_SESSION['email_secretkey'] = '';
1016 $destination = $_REQUEST['destination'];
1017 $subject = $_REQUEST['subject'];
1018 $content = $_REQUEST['content'];
1020 $replyto = strip_tags($_SESSION['email_replyto']);
1021 $fromname = strip_tags($_SESSION['email_fromname']);
1023 $mail = new PHPMailer();
1025 $mail->PluginDir
= "lib/phpmailer/";
1026 $mail->SetLanguage("en", "lib/phpmailer/language/");
1028 $mail->CharSet
= "UTF-8";
1030 $mail->From
= $replyto;
1031 $mail->FromName
= $fromname;
1032 $mail->AddAddress($destination);
1034 if (DIGEST_SMTP_HOST
) {
1035 $mail->Host
= DIGEST_SMTP_HOST
;
1036 $mail->Mailer
= "smtp";
1037 $mail->SMTPAuth
= DIGEST_SMTP_LOGIN
!= '';
1038 $mail->Username
= DIGEST_SMTP_LOGIN
;
1039 $mail->Password
= DIGEST_SMTP_PASSWORD
;
1042 $mail->IsHTML(false);
1043 $mail->Subject
= $subject;
1044 $mail->Body
= $content;
1046 $rc = $mail->Send();
1049 print "<error><![CDATA[" . $mail->ErrorInfo
. "]]></error>";
1051 save_email_address($link, db_escape_string($destination));
1052 print "<message>UPDATE_COUNTERS</message>";
1056 print "<error>Not authorized.</error>";
1059 print "</rpc-reply>";
1064 if ($subop == "completeEmails") {
1066 $search = db_escape_string($_REQUEST["search"]);
1070 foreach ($_SESSION['stored_emails'] as $email) {
1071 if (strpos($email, $search) !== false) {
1072 print "<li>$email</li>";
1081 if ($subop == "quickAddCat") {
1082 print "<rpc-reply>";
1084 $cat = db_escape_string($_REQUEST["cat"]);
1086 add_feed_category($link, $cat);
1088 $result = db_query($link, "SELECT id FROM ttrss_feed_categories WHERE
1089 title = '$cat' AND owner_uid = " . $_SESSION["uid"]);
1091 if (db_num_rows($result) == 1) {
1092 $id = db_fetch_result($result, 0, "id");
1097 print_feed_cat_select($link, "cat_id", $id);
1099 print "</rpc-reply>";
1104 if ($subop == "regenFeedKey") {
1105 $feed_id = db_escape_string($_REQUEST['id']);
1106 $is_cat = (bool) db_escape_string($_REQUEST['is_cat']);
1108 print "<rpc-reply>";
1110 $new_key = update_feed_access_key($link, $feed_id, $is_cat);
1112 print "<link><![CDATA[$new_key]]></link>";
1114 print "</rpc-reply>";
1119 if ($subop == "clearKeys") {
1121 db_query($link, "DELETE FROM ttrss_access_keys WHERE
1122 owner_uid = " . $_SESSION["uid"]);
1124 print "<rpc-reply>";
1125 print "<message>UPDATE_COUNTERS</message>";
1126 print "</rpc-reply>";
1131 print "<rpc-reply><error>Unknown method: $subop</error></rpc-reply>";