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