]> git.wh0rd.org - tt-rss.git/blame - modules/backend-rpc.php
rework initial sanitycheck to use JSON
[tt-rss.git] / modules / backend-rpc.php
CommitLineData
1d3a17c7 1<?php
01b3e191
AD
2 function handle_rpc_request($link) {
3
b4e75b2a 4 $subop = $_REQUEST["subop"];
6237ea05 5 $seq = (int) $_REQUEST["seq"];
01b3e191 6
91d16ff1 7 // Silent
d9084cf2
AD
8 if ($subop == "setprofile") {
9 $id = db_escape_string($_REQUEST["id"]);
10
11 $_SESSION["profile"] = $id;
12 $_SESSION["prefs_cache"] = array();
13 return;
14 }
15
91d16ff1 16 // Silent
d9084cf2
AD
17 if ($subop == "remprofiles") {
18 $ids = split(",", db_escape_string(trim($_REQUEST["ids"])));
19
20 foreach ($ids as $id) {
21 if ($_SESSION["profile"] != $id) {
22 db_query($link, "DELETE FROM ttrss_settings_profiles WHERE id = '$id' AND
23 owner_uid = " . $_SESSION["uid"]);
24 }
25 }
26 return;
27 }
28
91d16ff1 29 // Silent
d9084cf2
AD
30 if ($subop == "addprofile") {
31 $title = db_escape_string(trim($_REQUEST["title"]));
32 if ($title) {
33 db_query($link, "BEGIN");
34
35 $result = db_query($link, "SELECT id FROM ttrss_settings_profiles
36 WHERE title = '$title' AND owner_uid = " . $_SESSION["uid"]);
37
38 if (db_num_rows($result) == 0) {
39
40 db_query($link, "INSERT INTO ttrss_settings_profiles (title, owner_uid)
41 VALUES ('$title', ".$_SESSION["uid"] .")");
009646d2 42
d9084cf2
AD
43 $result = db_query($link, "SELECT id FROM ttrss_settings_profiles WHERE
44 title = '$title'");
009646d2 45
d9084cf2
AD
46 if (db_num_rows($result) != 0) {
47 $profile_id = db_fetch_result($result, 0, "id");
009646d2 48
d9084cf2 49 if ($profile_id) {
009646d2 50 initialize_user_prefs($link, $_SESSION["uid"], $profile_id);
d9084cf2
AD
51 }
52 }
53 }
54
55 db_query($link, "COMMIT");
56 }
57 return;
58 }
59
91d16ff1 60 // Silent
d9084cf2
AD
61 if ($subop == "saveprofile") {
62 $id = db_escape_string($_REQUEST["id"]);
63 $title = db_escape_string(trim($_REQUEST["value"]));
64
65 if ($id == 0) {
66 print __("Default profile");
67 return;
68 }
69
70 if ($title) {
71 db_query($link, "BEGIN");
72
73 $result = db_query($link, "SELECT id FROM ttrss_settings_profiles
74 WHERE title = '$title' AND owner_uid =" . $_SESSION["uid"]);
75
76 if (db_num_rows($result) == 0) {
77 db_query($link, "UPDATE ttrss_settings_profiles
78 SET title = '$title' WHERE id = '$id' AND
79 owner_uid = " . $_SESSION["uid"]);
80 print $title;
81 } else {
82 $result = db_query($link, "SELECT title FROM ttrss_settings_profiles
83 WHERE id = '$id' AND owner_uid =" . $_SESSION["uid"]);
84 print db_fetch_result($result, 0, "title");
85 }
86
87 db_query($link, "COMMIT");
009646d2 88 }
d9084cf2
AD
89 return;
90 }
91
91d16ff1 92 // Silent
ef88b1cc
AD
93 if ($subop == "remarchive") {
94 $ids = split(",", db_escape_string($_REQUEST["ids"]));
95
ef88b1cc
AD
96 foreach ($ids as $id) {
97 $result = db_query($link, "DELETE FROM ttrss_archived_feeds WHERE
009646d2 98 (SELECT COUNT(*) FROM ttrss_user_entries
ef88b1cc
AD
99 WHERE orig_feed_id = '$id') = 0 AND
100 id = '$id' AND owner_uid = ".$_SESSION["uid"]);
101
102 $rc = db_affected_rows($link, $result);
ef88b1cc 103 }
ef88b1cc
AD
104 return;
105 }
106
a5819bb3 107 if ($subop == "addfeed") {
e9175d13 108 header("Content-Type: text/plain");
a5819bb3
AD
109
110 $feed = db_escape_string($_REQUEST['feed']);
111 $cat = db_escape_string($_REQUEST['cat']);
112 $login = db_escape_string($_REQUEST['login']);
113 $pass = db_escape_string($_REQUEST['pass']);
114
115 $rc = subscribe_to_feed($link, $feed, $cat, $login, $pass);
116
e9175d13 117 print json_encode(array("result" => $rc));
a5819bb3
AD
118
119 return;
120
121 }
122
f0266f51 123 if ($subop == "extractfeedurls") {
e9175d13 124 header("Content-Type: text/plain");
f0266f51
CW
125
126 $urls = get_feeds_from_html($_REQUEST['url']);
f0266f51 127
e9175d13 128 print json_encode(array("urls" => $urls));
f0266f51
CW
129 return;
130 }
131
8a3e0b1a 132 if ($subop == "togglepref") {
74d12bab 133 header("Content-Type: text/plain");
8a3e0b1a
AD
134
135 $key = db_escape_string($_REQUEST["key"]);
8a3e0b1a 136 set_pref($link, $key, !get_pref($link, $key));
8a3e0b1a 137 $value = get_pref($link, $key);
01b3e191 138
74d12bab 139 print json_encode(array("param" =>$key, "value" => $value));
8a3e0b1a
AD
140 return;
141 }
142
143 if ($subop == "setpref") {
da661d71 144 header("Content-Type: text/plain");
01b3e191 145
5823f9fb
AD
146 $value = str_replace("\n", "<br/>", $_REQUEST['value']);
147
b4e75b2a 148 $key = db_escape_string($_REQUEST["key"]);
5823f9fb 149 $value = db_escape_string($value);
01b3e191
AD
150
151 set_pref($link, $key, $value);
152
da661d71 153 print json_encode(array("param" =>$key, "value" => $value));
85bd574b 154 return;
01b3e191
AD
155 }
156
01b3e191 157 if ($subop == "mark") {
74d12bab
AD
158 header("Content-Type: text/plain");
159
b4e75b2a
AD
160 $mark = $_REQUEST["mark"];
161 $id = db_escape_string($_REQUEST["id"]);
01b3e191
AD
162
163 if ($mark == "1") {
164 $mark = "true";
165 } else {
166 $mark = "false";
167 }
168
01b3e191
AD
169 $result = db_query($link, "UPDATE ttrss_user_entries SET marked = $mark
170 WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]);
49aa6de9 171
74d12bab 172 print json_encode(array("message" => "UPDATE_COUNTERS"));
85bd574b 173 return;
01b3e191
AD
174 }
175
e04c18a2 176 if ($subop == "delete") {
74d12bab
AD
177 header("Content-Type: text/plain");
178
b4e75b2a 179 $ids = db_escape_string($_REQUEST["ids"]);
e04c18a2 180
009646d2 181 $result = db_query($link, "DELETE FROM ttrss_user_entries
e04c18a2
AD
182 WHERE ref_id IN ($ids) AND owner_uid = " . $_SESSION["uid"]);
183
74d12bab 184 print json_encode(array("message" => "UPDATE_COUNTERS"));
e04c18a2
AD
185 return;
186 }
187
188 if ($subop == "unarchive") {
74d12bab
AD
189 header("Content-Type: text/plain");
190
b4e75b2a 191 $ids = db_escape_string($_REQUEST["ids"]);
e04c18a2 192
009646d2 193 $result = db_query($link, "UPDATE ttrss_user_entries
ef83538d 194 SET feed_id = orig_feed_id, orig_feed_id = NULL
e04c18a2
AD
195 WHERE ref_id IN ($ids) AND owner_uid = " . $_SESSION["uid"]);
196
74d12bab 197 print json_encode(array("message" => "UPDATE_COUNTERS"));
e04c18a2
AD
198 return;
199 }
200
201 if ($subop == "archive") {
74d12bab
AD
202 header("Content-Type: text/plain");
203
b4e75b2a 204 $ids = split(",", db_escape_string($_REQUEST["ids"]));
e04c18a2 205
16fdac16
AD
206 foreach ($ids as $id) {
207 archive_article($link, $id, $_SESSION["uid"]);
208 }
e04c18a2 209
74d12bab 210 print json_encode(array("message" => "UPDATE_COUNTERS"));
e04c18a2
AD
211 return;
212 }
213
e4f4b46f 214 if ($subop == "publ") {
741b6090
AD
215 header("Content-Type: text/plain");
216
c7e51de1
AD
217 $pub = $_REQUEST["pub"];
218 $id = db_escape_string($_REQUEST["id"]);
219 $note = trim(strip_tags(db_escape_string($_REQUEST["note"])));
e4f4b46f
AD
220
221 if ($pub == "1") {
0a8011eb 222 $pub = "true";
e4f4b46f
AD
223 } else {
224 $pub = "false";
225 }
226
009646d2 227 $result = db_query($link, "UPDATE ttrss_user_entries SET
c7e51de1 228 published = $pub
e4f4b46f 229 WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]);
49aa6de9 230
741b6090 231 print json_encode(array("message" => "UPDATE_COUNTERS"));
85bd574b 232 return;
e4f4b46f
AD
233 }
234
74d12bab 235/* if ($subop == "updateFeed") {
b4e75b2a 236 $feed_id = db_escape_string($_REQUEST["feed"]);
01b3e191 237
c633e370 238 update_rss_feed($link, $feed_id);
01b3e191 239
f8fb4498
AD
240 print "<rpc-reply>";
241 print "<message>UPDATE_COUNTERS</message>";
01b3e191 242 print "</rpc-reply>";
f8fb4498 243
01b3e191 244 return;
74d12bab 245 } */
01b3e191 246
773adf8b 247 if ($subop == "updateAllFeeds" || $subop == "getAllCounters") {
f8fb4498 248
563b9c78
AD
249 header("Content-Type: text/plain");
250
009646d2 251 $last_article_id = (int) $_REQUEST["last_article_id"];
01b3e191 252
563b9c78 253 $reply = array();
01b3e191 254
563b9c78 255 if ($seq) $reply['seq'] = $seq;
6237ea05 256
f8fb4498 257 if ($last_article_id != getLastArticleId($link)) {
6a7817c1 258 $omode = $_REQUEST["omode"];
f8fb4498 259
009646d2 260 if ($omode != "T")
563b9c78 261 $reply['counters'] = getAllCounters($link, $omode);
f8fb4498 262 else
563b9c78 263 $reply['counters'] = getGlobalCounters($link);
a06d0e5a 264 }
009646d2 265
563b9c78 266 $reply['runtime-info'] = make_runtime_info($link);
f54f515f 267
01b3e191 268
563b9c78 269 print json_encode($reply);
85bd574b 270 return;
01b3e191 271 }
472782e8 272
01b3e191
AD
273 /* GET["cmode"] = 0 - mark as read, 1 - as unread, 2 - toggle */
274 if ($subop == "catchupSelected") {
74d12bab 275 header("Content-Type: text/plain");
01b3e191 276
2855ee88
AD
277 $ids = split(",", db_escape_string($_REQUEST["ids"]));
278 $cmode = sprintf("%d", $_REQUEST["cmode"]);
01b3e191 279
472782e8 280 catchupArticlesById($link, $ids, $cmode);
01b3e191 281
74d12bab 282 print json_encode(array("message" => "UPDATE_COUNTERS"));
85bd574b 283 return;
01b3e191
AD
284 }
285
286 if ($subop == "markSelected") {
74d12bab 287 header("Content-Type: text/plain");
01b3e191 288
b4e75b2a
AD
289 $ids = split(",", db_escape_string($_REQUEST["ids"]));
290 $cmode = sprintf("%d", $_REQUEST["cmode"]);
01b3e191 291
18eddb2c
AD
292 markArticlesById($link, $ids, $cmode);
293
74d12bab 294 print json_encode(array("message" => "UPDATE_COUNTERS"));
85bd574b 295 return;
01b3e191
AD
296 }
297
e4f4b46f 298 if ($subop == "publishSelected") {
74d12bab 299 header("Content-Type: text/plain");
e4f4b46f 300
b4e75b2a
AD
301 $ids = split(",", db_escape_string($_REQUEST["ids"]));
302 $cmode = sprintf("%d", $_REQUEST["cmode"]);
e4f4b46f
AD
303
304 publishArticlesById($link, $ids, $cmode);
305
74d12bab 306 print json_encode(array("message" => "UPDATE_COUNTERS"));
85bd574b 307 return;
e4f4b46f
AD
308 }
309
01b3e191 310 if ($subop == "sanityCheck") {
ebb948c2 311 header("Content-Type: text/plain");
c3edc667
AD
312
313 $_SESSION["hasAudio"] = $_REQUEST["hasAudio"] === "true";
314
ebb948c2 315 $reply = array();
d8221301 316
ebb948c2 317 $reply['error'] = sanity_check($link);
d8221301 318
ebb948c2
AD
319 if ($reply['error']['code'] == 0) {
320 $reply['init-params'] = make_init_params($link);
321 $reply['runtime-info'] = make_runtime_info($link);
01b3e191 322 }
85bd574b 323
ebb948c2 324 print json_encode($reply);
85bd574b 325 return;
009646d2 326 }
01b3e191 327
da661d71 328/* if ($subop == "globalPurge") {
01b3e191
AD
329
330 print "<rpc-reply>";
331 global_purge_old_posts($link, true);
332 print "</rpc-reply>";
333
85bd574b 334 return;
da661d71 335 } */
3ac2b520 336
0b126ac2 337 if ($subop == "setArticleTags") {
ddcbbea2 338 header("Content-Type: text/plain");
14b6c54b 339
bd3f2ade
AD
340 global $memcache;
341
b4e75b2a 342 $id = db_escape_string($_REQUEST["id"]);
14b6c54b 343
b4e75b2a 344 $tags_str = db_escape_string($_REQUEST["tags_str"]);
d62a3b63 345 $tags = array_unique(trim_array(split(",", $tags_str)));
0b126ac2
AD
346
347 db_query($link, "BEGIN");
348
349 $result = db_query($link, "SELECT int_id FROM ttrss_user_entries WHERE
350 ref_id = '$id' AND owner_uid = '".$_SESSION["uid"]."' LIMIT 1");
351
352 if (db_num_rows($result) == 1) {
353
779560b7
AD
354 $tags_to_cache = array();
355
0b126ac2
AD
356 $int_id = db_fetch_result($result, 0, "int_id");
357
009646d2 358 db_query($link, "DELETE FROM ttrss_tags WHERE
0b126ac2
AD
359 post_int_id = $int_id AND owner_uid = '".$_SESSION["uid"]."'");
360
361 foreach ($tags as $tag) {
009646d2 362 $tag = sanitize_tag($tag);
0b126ac2 363
ef063748
AD
364 if (!tag_is_valid($tag)) {
365 continue;
366 }
367
0b126ac2
AD
368 if (preg_match("/^[0-9]*$/", $tag)) {
369 continue;
370 }
14b6c54b 371
307d187c 372// print "<!-- $id : $int_id : $tag -->";
009646d2 373
0b126ac2 374 if ($tag != '') {
009646d2 375 db_query($link, "INSERT INTO ttrss_tags
0b126ac2
AD
376 (post_int_id, owner_uid, tag_name) VALUES ('$int_id', '".$_SESSION["uid"]."', '$tag')");
377 }
779560b7
AD
378
379 array_push($tags_to_cache, $tag);
0b126ac2 380 }
0b126ac2 381
779560b7
AD
382 /* update tag cache */
383
384 $tags_str = join(",", $tags_to_cache);
385
009646d2 386 db_query($link, "UPDATE ttrss_user_entries
779560b7
AD
387 SET tag_cache = '$tags_str' WHERE ref_id = '$id'
388 AND owner_uid = " . $_SESSION["uid"]);
389 }
490c366d 390
0b126ac2
AD
391 db_query($link, "COMMIT");
392
bd3f2ade
AD
393 if ($memcache) {
394 $obj_id = md5("TAGS:".$_SESSION["uid"].":$id");
395 $memcache->delete($obj_id);
396 }
397
307d187c
AD
398 $tags_str = format_tags_string(get_article_tags($link, $id), $id);
399
ddcbbea2
AD
400 print json_encode(array("tags_str" => array("id" => $id,
401 "content" => $tags_str)));
0b126ac2 402
85bd574b 403 return;
0b126ac2 404 }
01a87dff 405
ef7b7bbd 406 if ($subop == "regenOPMLKey") {
91d16ff1 407 header("Content-Type: text/plain");
2e7f046f 408
009646d2 409 update_feed_access_key($link, 'OPML:Publish',
2e7f046f
AD
410 false, $_SESSION["uid"]);
411
009646d2 412 $new_link = opml_publish_url($link);
91d16ff1
AD
413
414 print json_encode(array("link" => $new_link));
ef7b7bbd
MK
415 return;
416 }
417
da661d71 418 // XML method
01a87dff
AD
419 if ($subop == "logout") {
420 logout_user();
421 print_error_xml(6);
85bd574b 422 return;
01a87dff
AD
423 }
424
05fcdf52 425 if ($subop == "completeTags") {
74d12bab 426 header("Content-Type: text/plain");
05fcdf52
AD
427
428 $search = db_escape_string($_REQUEST["search"]);
429
009646d2 430 $result = db_query($link, "SELECT DISTINCT tag_name FROM ttrss_tags
05fcdf52
AD
431 WHERE owner_uid = '".$_SESSION["uid"]."' AND
432 tag_name LIKE '$search%' ORDER BY tag_name
433 LIMIT 10");
434
435 print "<ul>";
436 while ($line = db_fetch_assoc($result)) {
437 print "<li>" . $line["tag_name"] . "</li>";
438 }
439 print "</ul>";
440
85bd574b 441 return;
05fcdf52
AD
442 }
443
81cd6cac 444 if ($subop == "purge") {
b4e75b2a
AD
445 $ids = split(",", db_escape_string($_REQUEST["ids"]));
446 $days = sprintf("%d", $_REQUEST["days"]);
81cd6cac 447
81cd6cac
AD
448 foreach ($ids as $id) {
449
450 $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE
451 id = '$id' AND owner_uid = ".$_SESSION["uid"]);
452
453 if (db_num_rows($result) == 1) {
74d12bab 454 purge_feed($link, $id, $days);
81cd6cac
AD
455 }
456 }
457
81cd6cac
AD
458 return;
459 }
460
9bf3f101 461/* if ($subop == "setScore") {
546499a9
AD
462 $id = db_escape_string($_REQUEST["id"]);
463 $score = sprintf("%d", $_REQUEST["score"]);
464
465 $result = db_query($link, "UPDATE ttrss_user_entries SET score = '$score'
466 WHERE ref_id = '$id' AND owner_uid = ".$_SESSION["uid"]);
467
468 print "<rpc-reply><message>Acknowledged.</message></rpc-reply>";
469
470 return;
471
9bf3f101 472 } */
546499a9 473
aa0fa9df 474 if ($subop == "getArticles") {
009646d2 475 header("Content-Type: text/plain");
aa0fa9df 476
009646d2
AD
477 $ids = split(",", db_escape_string($_REQUEST["ids"]));
478 $articles = array();
aa0fa9df
AD
479
480 foreach ($ids as $id) {
481 if ($id) {
009646d2 482 array_push($articles, format_article($link, $id, 0, false));
aa0fa9df
AD
483 }
484 }
aa0fa9df 485
009646d2
AD
486 print json_encode($articles);
487 return;
aa0fa9df
AD
488 }
489
d0da85c2 490 if ($subop == "checkDate") {
da661d71 491 header("Content-Type: text/plain");
d0da85c2
AD
492
493 $date = db_escape_string($_REQUEST["date"]);
494 $date_parsed = strtotime($date);
495
da661d71 496 print json_encode(array("result" => (bool)$date_parsed));
d0da85c2
AD
497 return;
498 }
499
8eb592ec
AD
500 if ($subop == "assignToLabel" || $subop == "removeFromLabel") {
501 header("Content-Type: text/plain");
933ba4ee 502
8eb592ec 503 $reply = array();
b8a637f3
AD
504
505 $ids = split(",", db_escape_string($_REQUEST["ids"]));
506 $label_id = db_escape_string($_REQUEST["lid"]);
507
009646d2 508 $label = db_escape_string(label_find_caption($link, $label_id,
7a13338b 509 $_SESSION["uid"]));
b8a637f3 510
8eb592ec 511 $reply["info-for-headlines"] = array();
f9247195 512
b8a637f3
AD
513 if ($label) {
514
515 foreach ($ids as $id) {
f9247195 516
8eb592ec
AD
517 if ($subop == "assignToLabel")
518 label_add_article($link, $id, $label, $_SESSION["uid"]);
519 else
520 label_remove_article($link, $id, $label, $_SESSION["uid"]);
f9247195
AD
521
522 $labels = get_article_labels($link, $id, $_SESSION["uid"]);
009646d2 523
8eb592ec
AD
524 array_push($reply["info-for-headlines"],
525 array("id" => $id, "labels" => format_article_labels($labels, $id)));
f9247195 526
b8a637f3
AD
527 }
528 }
529
8eb592ec 530 $reply["message"] = "UPDATE_COUNTERS";
f9247195 531
8eb592ec 532 print json_encode($reply);
b8a637f3
AD
533
534 return;
535 }
536
ef88b1cc 537 if ($subop == "updateFeedBrowser") {
4a16bda3 538 header("Content-Type: text/plain");
c2913898
AD
539
540 $search = db_escape_string($_REQUEST["search"]);
541 $limit = db_escape_string($_REQUEST["limit"]);
4a16bda3 542 $mode = (int) db_escape_string($_REQUEST["mode"]);
c2913898 543
4a16bda3
AD
544 print json_encode(array("content" =>
545 make_feed_browser($link, $search, $limit, $mode),
546 "mode" => $mode));
c2913898
AD
547 return;
548 }
549
91d16ff1 550 // Silent
ef88b1cc
AD
551 if ($subop == "massSubscribe") {
552
553 $ids = split(",", db_escape_string($_REQUEST["ids"]));
554 $mode = $_REQUEST["mode"];
555
556 $subscribed = array();
557
558 foreach ($ids as $id) {
559
560 if ($mode == 1) {
561 $result = db_query($link, "SELECT feed_url,title FROM ttrss_feeds
562 WHERE id = '$id'");
563 } else if ($mode == 2) {
564 $result = db_query($link, "SELECT * FROM ttrss_archived_feeds
565 WHERE id = '$id' AND owner_uid = " . $_SESSION["uid"]);
566 $orig_id = db_escape_string(db_fetch_result($result, 0, "id"));
567 $site_url = db_escape_string(db_fetch_result($result, 0, "site_url"));
568 }
009646d2 569
ef88b1cc
AD
570 $feed_url = db_escape_string(db_fetch_result($result, 0, "feed_url"));
571 $title = db_escape_string(db_fetch_result($result, 0, "title"));
009646d2 572
ef88b1cc 573 $title_orig = db_fetch_result($result, 0, "title");
009646d2 574
ef88b1cc
AD
575 $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE
576 feed_url = '$feed_url' AND owner_uid = " . $_SESSION["uid"]);
009646d2
AD
577
578 if (db_num_rows($result) == 0) {
ef88b1cc
AD
579 if ($mode == 1) {
580 $result = db_query($link,
009646d2 581 "INSERT INTO ttrss_feeds (owner_uid,feed_url,title,cat_id)
ef88b1cc
AD
582 VALUES ('".$_SESSION["uid"]."', '$feed_url', '$title', NULL)");
583 } else if ($mode == 2) {
584 $result = db_query($link,
009646d2 585 "INSERT INTO ttrss_feeds (id,owner_uid,feed_url,title,cat_id,site_url)
ef88b1cc
AD
586 VALUES ('$orig_id','".$_SESSION["uid"]."', '$feed_url', '$title', NULL, '$site_url')");
587 }
588 array_push($subscribed, $title_orig);
589 }
590 }
591
ef88b1cc 592 return;
009646d2 593 }
ef88b1cc 594
d8ea9902 595 if ($subop == "digest-get-contents") {
0fe841ef
AD
596 header("Content-Type: text/plain");
597
d8ea9902
AD
598 $article_id = db_escape_string($_REQUEST['article_id']);
599
009646d2 600 $result = db_query($link, "SELECT content
d8ea9902
AD
601 FROM ttrss_entries, ttrss_user_entries
602 WHERE id = '$article_id' AND ref_id = id AND owner_uid = ".$_SESSION['uid']);
603
d8ea9902
AD
604 $content = sanitize_rss($link, db_fetch_result($result, 0, "content"));
605
0fe841ef
AD
606 print json_encode(array("article" =>
607 array("id" => $id, "content" => $content)));
d8ea9902
AD
608 return;
609 }
610
1ca8997b 611 if ($subop == "digest-update") {
126cb765
AD
612 header("Content-Type: text/plain");
613
b41c2549 614 $feed_id = db_escape_string($_REQUEST['feed_id']);
1ca8997b 615 $offset = db_escape_string($_REQUEST['offset']);
e4c530dc 616 $seq = db_escape_string($_REQUEST['seq']);
009646d2 617
b41c2549 618 if (!$feed_id) $feed_id = -4;
1ca8997b 619 if (!$offset) $offset = 0;
1ca8997b 620
126cb765
AD
621 $reply = array();
622
623 $reply['seq'] = $seq;
e4c530dc 624
1ca8997b 625 $headlines = api_get_headlines($link, $feed_id, 10, $offset,
d8ea9902 626 '', ($feed_id == -4), true, false, "unread", "updated DESC");
1ca8997b
AD
627
628 //function api_get_headlines($link, $feed_id, $limit, $offset,
629 // $filter, $is_cat, $show_excerpt, $show_content, $view_mode) {
630
126cb765
AD
631 $reply['headlines'] = array();
632 $reply['headlines']['title'] = getFeedTitle($link, $feed_id);
633 $reply['headlines']['content'] = $headlines;
1ca8997b 634
126cb765 635 print json_encode($reply);
1ca8997b
AD
636 return;
637 }
638
639 if ($subop == "digest-init") {
126cb765
AD
640 header("Content-Type: text/plain");
641
a17d7219 642 $tmp_feeds = api_get_feeds($link, -3, true, false, 0);
911d4c08 643
911d4c08
AD
644 $feeds = array();
645
646 foreach ($tmp_feeds as $f) {
b41c2549 647 if ($f['id'] > 0 || $f['id'] == -4) array_push($feeds, $f);
911d4c08
AD
648 }
649
126cb765 650 print json_encode(array("feeds" => $feeds));
911d4c08 651
911d4c08
AD
652 return;
653 }
654
c1b5cd23 655 if ($subop == "catchupFeed") {
c1b5cd23
AD
656 $feed_id = db_escape_string($_REQUEST['feed_id']);
657 $is_cat = db_escape_string($_REQUEST['is_cat']);
658
c1b5cd23
AD
659 catchup_feed($link, $feed_id, $is_cat);
660
c1b5cd23
AD
661 return;
662 }
663
31a53903 664 if ($subop == "sendEmail") {
48efad70
AD
665 header("Content-Type: text/plain");
666
31a53903
AD
667 $secretkey = $_REQUEST['secretkey'];
668
48efad70 669 $reply = array();
31a53903 670
009646d2 671 if (DIGEST_ENABLE && $_SESSION['email_secretkey'] &&
31a53903
AD
672 $secretkey == $_SESSION['email_secretkey']) {
673
674 $_SESSION['email_secretkey'] = '';
675
676 $destination = $_REQUEST['destination'];
677 $subject = $_REQUEST['subject'];
678 $content = $_REQUEST['content'];
679
680 $replyto = strip_tags($_SESSION['email_replyto']);
681 $fromname = strip_tags($_SESSION['email_fromname']);
682
683 $mail = new PHPMailer();
684
685 $mail->PluginDir = "lib/phpmailer/";
686 $mail->SetLanguage("en", "lib/phpmailer/language/");
687
688 $mail->CharSet = "UTF-8";
689
690 $mail->From = $replyto;
691 $mail->FromName = $fromname;
692 $mail->AddAddress($destination);
693
694 if (DIGEST_SMTP_HOST) {
695 $mail->Host = DIGEST_SMTP_HOST;
696 $mail->Mailer = "smtp";
697 $mail->SMTPAuth = DIGEST_SMTP_LOGIN != '';
698 $mail->Username = DIGEST_SMTP_LOGIN;
699 $mail->Password = DIGEST_SMTP_PASSWORD;
700 }
701
702 $mail->IsHTML(false);
703 $mail->Subject = $subject;
704 $mail->Body = $content;
705
706 $rc = $mail->Send();
707
708 if (!$rc) {
48efad70 709 $reply['error'] = $mail->ErrorInfo;
31a53903
AD
710 } else {
711 save_email_address($link, db_escape_string($destination));
48efad70 712 $reply['message'] = "UPDATE_COUNTERS";
31a53903
AD
713 }
714
715 } else {
48efad70 716 $reply['error'] = "Not authorized.";
31a53903
AD
717 }
718
48efad70 719 print json_encode($reply);
31a53903
AD
720 return;
721 }
722
723 if ($subop == "completeEmails") {
a6fdab2e 724 header("Content-Type: text/plain");
31a53903
AD
725
726 $search = db_escape_string($_REQUEST["search"]);
727
728 print "<ul>";
729
730 foreach ($_SESSION['stored_emails'] as $email) {
731 if (strpos($email, $search) !== false) {
732 print "<li>$email</li>";
733 }
734 }
735
736 print "</ul>";
737
738 return;
739 }
740
5c7c7da9 741 if ($subop == "quickAddCat") {
a6fdab2e 742 header("Content-Type: text/plain");
5c7c7da9
AD
743
744 $cat = db_escape_string($_REQUEST["cat"]);
745
746 add_feed_category($link, $cat);
747
748 $result = db_query($link, "SELECT id FROM ttrss_feed_categories WHERE
749 title = '$cat' AND owner_uid = " . $_SESSION["uid"]);
750
751 if (db_num_rows($result) == 1) {
752 $id = db_fetch_result($result, 0, "id");
753 } else {
754 $id = 0;
755 }
756
5c7c7da9 757 print_feed_cat_select($link, "cat_id", $id);
5c7c7da9 758
5c7c7da9
AD
759 return;
760 }
761
8801fb01 762 if ($subop == "regenFeedKey") {
91d16ff1
AD
763 header("Content-Type: text/plain");
764
8801fb01
AD
765 $feed_id = db_escape_string($_REQUEST['id']);
766 $is_cat = (bool) db_escape_string($_REQUEST['is_cat']);
767
8801fb01
AD
768 $new_key = update_feed_access_key($link, $feed_id, $is_cat);
769
91d16ff1 770 print json_encode(array("link" => $new_key));
8801fb01
AD
771 return;
772 }
773
91d16ff1 774 // Silent
8d86f15f 775 if ($subop == "clearKeys") {
8d86f15f
AD
776 db_query($link, "DELETE FROM ttrss_access_keys WHERE
777 owner_uid = " . $_SESSION["uid"]);
778
8d86f15f
AD
779 return;
780 }
781
f705f206 782 if ($subop == "verifyRegexp") {
91d16ff1 783 header("Content-Type: text/plain");
f705f206 784
91d16ff1 785 $reg_exp = $_REQUEST["reg_exp"];
f705f206 786
91d16ff1 787 $status = @preg_match("/$reg_exp/i", "TEST") !== false;
f705f206 788
91d16ff1 789 print json_encode(array("status" => $status));
f705f206
AD
790 return;
791 }
792
a6fdab2e 793 // TODO: unify with digest-get-contents?
dd1c0680 794 if ($subop == "cdmGetArticle") {
74d12bab
AD
795 header("Content-Type: text/plain");
796
dd1c0680
AD
797 $id = db_escape_string($_REQUEST["id"]);
798
009646d2
AD
799 $result = db_query($link, "SELECT content,
800 ttrss_feeds.site_url AS site_url FROM ttrss_user_entries, ttrss_feeds,
dd1c0680 801 ttrss_entries
009646d2 802 WHERE feed_id = ttrss_feeds.id AND ref_id = '$id' AND
dd1c0680
AD
803 ttrss_entries.id = ref_id AND
804 ttrss_user_entries.owner_uid = ".$_SESSION["uid"]);
805
806 if (db_num_rows($result) != 0) {
807 $line = db_fetch_assoc($result);
808
009646d2 809 $article_content = sanitize_rss($link, $line["content"],
dd1c0680 810 false, false, $line['site_url']);
009646d2 811
dd1c0680
AD
812 } else {
813 $article_content = '';
814 }
815
74d12bab
AD
816 print json_encode(array("article" =>
817 array("id" => $id, "content" => $article_content)));
dd1c0680
AD
818
819 return;
820 }
821
428b704d 822 if ($subop == "scheduleFeedUpdate") {
74d12bab
AD
823 header("Content-Type: text/plain");
824
428b704d 825 $feed_id = db_escape_string($_REQUEST["id"]);
997429c2 826 $is_cat = db_escape_string($_REQUEST['is_cat']) == 'true';
428b704d
AD
827
828 $message = __("Your request could not be completed.");
829
830 if ($feed_id >= 0) {
831 if (!$is_cat) {
832 $message = __("Feed update has been scheduled.");
833
834 db_query($link, "UPDATE ttrss_feeds SET
835 last_update_started = '1970-01-01',
836 last_updated = '1970-01-01' WHERE id = '$feed_id' AND
837 owner_uid = ".$_SESSION["uid"]);
838
839 } else {
840 $message = __("Category update has been scheduled.");
841
009646d2 842 if ($feed_id)
428b704d
AD
843 $cat_query = "cat_id = '$feed_id'";
844 else
845 $cat_query = "cat_id IS NULL";
846
847 db_query($link, "UPDATE ttrss_feeds SET
848 last_update_started = '1970-01-01',
849 last_updated = '1970-01-01' WHERE $cat_query AND
850 owner_uid = ".$_SESSION["uid"]);
851 }
852 } else {
853 $message = __("Can't update this kind of feed.");
854 }
855
74d12bab 856 print json_encode(array("message" => $message));
428b704d
AD
857 return;
858 }
859
ba7e88e5 860 if ($subop == "getTweetInfo") {
563b9c78 861 header("Content-Type: text/plain");
ba7e88e5
AD
862 $id = db_escape_string($_REQUEST['id']);
863
009646d2 864 $result = db_query($link, "SELECT title, link
ba7e88e5
AD
865 FROM ttrss_entries, ttrss_user_entries
866 WHERE id = '$id' AND ref_id = id AND owner_uid = " .$_SESSION['uid']);
867
868 if (db_num_rows($result) != 0) {
869 $title = truncate_string(strip_tags(db_fetch_result($result, 0, 'title')),
870 100, '...');
871 $article_link = db_fetch_result($result, 0, 'link');
872 }
873
874 print json_encode(array("title" => $title, "link" => $article_link,
875 "id" => $id));
876
877 return;
878 }
879
741b6090
AD
880 if ($subop == "setNote") {
881 header("Content-Type: text/plain");
882
883 $id = db_escape_string($_REQUEST["id"]);
884 $note = strip_tags(db_escape_string($_REQUEST["note"]));
885
886 db_query($link, "UPDATE ttrss_user_entries SET note = '$note'
887 WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]);
888
889 $formatted_note = format_article_note($id, $note);
890
891 print json_encode(array("note" => $formatted_note));
892 return;
893 }
894
85bd574b 895 print "<rpc-reply><error>Unknown method: $subop</error></rpc-reply>";
01b3e191
AD
896 }
897?>