]>
git.wh0rd.org - tt-rss.git/blob - classes/rpc.php
2 class RPC
extends Handler_Protected
{
4 function csrf_ignore($method) {
5 $csrf_ignored = array("sanitycheck", "completelabels", "saveprofile");
7 return array_search($method, $csrf_ignored) !== false;
10 function setprofile() {
11 $_SESSION["profile"] = $_REQUEST["id"];
14 if (!$_SESSION["profile"]) $_SESSION["profile"] = null;
17 function remprofiles() {
18 $ids = explode(",", trim($_REQUEST["ids"]));
20 foreach ($ids as $id) {
21 if ($_SESSION["profile"] != $id) {
22 $sth = $this->pdo
->prepare("DELETE FROM ttrss_settings_profiles WHERE id = ? AND
24 $sth->execute([$id, $_SESSION['uid']]);
30 function addprofile() {
31 $title = trim($_REQUEST["title"]);
34 $this->pdo
->beginTransaction();
36 $sth = $this->pdo
->prepare("SELECT id FROM ttrss_settings_profiles
37 WHERE title = ? AND owner_uid = ?");
38 $sth->execute([$title, $_SESSION['uid']]);
42 $sth = $this->pdo
->prepare("INSERT INTO ttrss_settings_profiles (title, owner_uid)
45 $sth->execute([$title, $_SESSION['uid']]);
47 $sth = $this->pdo
->prepare("SELECT id FROM ttrss_settings_profiles WHERE
48 title = ? AND owner_uid = ?");
49 $sth->execute([$title, $_SESSION['uid']]);
51 if ($row = $sth->fetch()) {
52 $profile_id = $row['id'];
55 initialize_user_prefs($_SESSION["uid"], $profile_id);
64 function saveprofile() {
65 $id = $_REQUEST["id"];
66 $title = trim($_REQUEST["value"]);
69 print __("Default profile");
74 $sth = $this->pdo
->prepare("UPDATE ttrss_settings_profiles
75 SET title = ? WHERE id = ? AND
78 $sth->execute([$title, $id, $_SESSION['uid']]);
84 function remarchive() {
85 $ids = explode(",", $_REQUEST["ids"]);
87 $sth = $this->pdo
->prepare("DELETE FROM ttrss_archived_feeds WHERE
88 (SELECT COUNT(*) FROM ttrss_user_entries
89 WHERE orig_feed_id = :id) = 0 AND
90 id = :id AND owner_uid = :uid");
92 foreach ($ids as $id) {
93 $sth->execute([":id" => $id, ":uid" => $_SESSION['uid']]);
98 $feed = $_REQUEST['feed'];
99 $cat = $_REQUEST['cat'];
100 $login = $_REQUEST['login'];
101 $pass = trim($_REQUEST['pass']);
103 $rc = Feeds
::subscribe_to_feed($feed, $cat, $login, $pass);
105 print json_encode(array("result" => $rc));
108 function togglepref() {
109 $key = $_REQUEST["key"];
110 set_pref($key, !get_pref($key));
111 $value = get_pref($key);
113 print json_encode(array("param" =>$key, "value" => $value));
117 // set_pref escapes input, so no need to double escape it here
118 $key = $_REQUEST['key'];
119 $value = str_replace("\n", "<br/>", $_REQUEST['value']);
121 set_pref($key, $value, false, $key != 'USER_STYLESHEET');
123 print json_encode(array("param" =>$key, "value" => $value));
127 $mark = $_REQUEST["mark"];
128 $id = $_REQUEST["id"];
130 $sth = $this->pdo
->prepare("UPDATE ttrss_user_entries SET marked = ?,
132 WHERE ref_id = ? AND owner_uid = ?");
134 $sth->execute([$mark, $id, $_SESSION['uid']]);
136 print json_encode(array("message" => "UPDATE_COUNTERS"));
140 $ids = explode(",", $_REQUEST["ids"]);
141 $ids_qmarks = arr_qmarks($ids);
143 $sth = $this->pdo
->prepare("DELETE FROM ttrss_user_entries
144 WHERE ref_id IN ($ids_qmarks) AND owner_uid = ?");
145 $sth->execute(array_merge($ids, [$_SESSION['uid']]));
147 Article
::purge_orphans();
149 print json_encode(array("message" => "UPDATE_COUNTERS"));
152 function unarchive() {
153 $ids = explode(",", $_REQUEST["ids"]);
155 foreach ($ids as $id) {
156 $this->pdo
->beginTransaction();
158 $sth = $this->pdo
->prepare("SELECT feed_url,site_url,title FROM ttrss_archived_feeds
159 WHERE id = (SELECT orig_feed_id FROM ttrss_user_entries WHERE ref_id = :id
160 AND owner_uid = :uid) AND owner_uid = :uid");
161 $sth->execute([":uid" => $_SESSION['uid'], ":id" => $id]);
163 if ($row = $sth->fetch()) {
164 $feed_url = $row['feed_url'];
165 $site_url = $row['site_url'];
166 $title = $row['title'];
168 $sth = $this->pdo
->prepare("SELECT id FROM ttrss_feeds WHERE feed_url = ?
170 $sth->execute([$feed_url, $_SESSION['uid']]);
172 if ($row = $sth->fetch()) {
173 $feed_id = $row["id"];
175 if (!$title) $title = '[Unknown]';
177 $sth = $this->pdo
->prepare("INSERT INTO ttrss_feeds
178 (owner_uid,feed_url,site_url,title,cat_id,auth_login,auth_pass,update_method)
179 VALUES (?, ?, ?, ?, NULL, '', '', 0)");
180 $sth->execute([$_SESSION['uid'], $feed_url, $site_url, $title]);
182 $sth = $this->pdo
->prepare("SELECT id FROM ttrss_feeds WHERE feed_url = ?
184 $sth->execute([$feed_url, $_SESSION['uid']]);
186 if ($row = $sth->fetch()) {
187 $feed_id = $row['id'];
192 $sth = $this->pdo
->prepare("UPDATE ttrss_user_entries
193 SET feed_id = ?, orig_feed_id = NULL
194 WHERE ref_id = ? AND owner_uid = ?");
195 $sth->execute([$feed_id, $id, $_SESSION['uid']]);
199 $this->pdo
->commit();
202 print json_encode(array("message" => "UPDATE_COUNTERS"));
206 $ids = explode(",", $_REQUEST["ids"]);
208 foreach ($ids as $id) {
209 $this->archive_article($id, $_SESSION["uid"]);
212 print json_encode(array("message" => "UPDATE_COUNTERS"));
215 private function archive_article($id, $owner_uid) {
216 $this->pdo
->beginTransaction();
218 if (!$owner_uid) $owner_uid = $_SESSION['uid'];
220 $sth = $this->pdo
->prepare("SELECT feed_id FROM ttrss_user_entries
221 WHERE ref_id = ? AND owner_uid = ?");
222 $sth->execute([$id, $owner_uid]);
224 if ($row = $sth->fetch()) {
226 /* prepare the archived table */
228 $feed_id = (int) $row['feed_id'];
231 $sth = $this->pdo
->prepare("SELECT id FROM ttrss_archived_feeds
232 WHERE id = ? AND owner_uid = ?");
233 $sth->execute([$feed_id, $owner_uid]);
235 if ($row = $sth->fetch()) {
236 $new_feed_id = $row['id'];
238 $row = $this->pdo
->query("SELECT MAX(id) AS id FROM ttrss_archived_feeds")->fetch();
239 $new_feed_id = (int)$row['id'] +
1;
241 $sth = $this->pdo
->prepare("INSERT INTO ttrss_archived_feeds
242 (id, owner_uid, title, feed_url, site_url)
243 SELECT ?, owner_uid, title, feed_url, site_url from ttrss_feeds
246 $sth->execute([$new_feed_id, $feed_id]);
249 $sth = $this->pdo
->prepare("UPDATE ttrss_user_entries
250 SET orig_feed_id = ?, feed_id = NULL
251 WHERE ref_id = ? AND owner_uid = ?");
252 $sth->execute([$new_feed_id, $id, $owner_uid]);
256 $this->pdo
->commit();
260 $pub = $_REQUEST["pub"];
261 $id = $_REQUEST["id"];
263 $sth = $this->pdo
->prepare("UPDATE ttrss_user_entries SET
264 published = ?, last_published = NOW()
265 WHERE ref_id = ? AND owner_uid = ?");
267 $sth->execute([$pub, $id, $_SESSION['uid']]);
269 print json_encode(array("message" => "UPDATE_COUNTERS"));
272 function getAllCounters() {
273 $last_article_id = (int) $_REQUEST["last_article_id"];
277 if (!empty($_REQUEST['seq'])) $reply['seq'] = (int) $_REQUEST['seq'];
279 if ($last_article_id != Article
::getLastArticleId()) {
280 $reply['counters'] = Counters
::getAllCounters();
283 $reply['runtime-info'] = make_runtime_info();
285 print json_encode($reply);
288 /* GET["cmode"] = 0 - mark as read, 1 - as unread, 2 - toggle */
289 function catchupSelected() {
290 $ids = explode(",", $_REQUEST["ids"]);
291 $cmode = sprintf("%d", $_REQUEST["cmode"]);
293 Article
::catchupArticlesById($ids, $cmode);
295 print json_encode(array("message" => "UPDATE_COUNTERS", "ids" => $ids));
298 function markSelected() {
299 $ids = explode(",", $_REQUEST["ids"]);
300 $cmode = (int)$_REQUEST["cmode"];
302 $this->markArticlesById($ids, $cmode);
304 print json_encode(array("message" => "UPDATE_COUNTERS"));
307 function publishSelected() {
308 $ids = explode(",", $_REQUEST["ids"]);
309 $cmode = (int)$_REQUEST["cmode"];
311 $this->publishArticlesById($ids, $cmode);
313 print json_encode(array("message" => "UPDATE_COUNTERS"));
316 function sanityCheck() {
317 $_SESSION["hasAudio"] = $_REQUEST["hasAudio"] === "true";
318 $_SESSION["hasSandbox"] = $_REQUEST["hasSandbox"] === "true";
319 $_SESSION["hasMp3"] = $_REQUEST["hasMp3"] === "true";
320 $_SESSION["clientTzOffset"] = $_REQUEST["clientTzOffset"];
324 $reply['error'] = sanity_check();
326 if ($reply['error']['code'] == 0) {
327 $reply['init-params'] = make_init_params();
328 $reply['runtime-info'] = make_runtime_info(true);
331 print json_encode($reply);
334 function completeLabels() {
335 $search = $_REQUEST["search"];
337 $sth = $this->pdo
->prepare("SELECT DISTINCT caption FROM
339 WHERE owner_uid = ? AND
340 LOWER(caption) LIKE LOWER(?) ORDER BY caption
342 $sth->execute([$_SESSION['uid'], "%$search%"]);
345 while ($line = $sth->fetch()) {
346 print "<li>" . $line["caption"] . "</li>";
351 function updateFeedBrowser() {
352 if (defined('_DISABLE_FEED_BROWSER') && _DISABLE_FEED_BROWSER
) return;
354 $search = $_REQUEST["search"];
355 $limit = $_REQUEST["limit"];
356 $mode = (int) $_REQUEST["mode"];
358 require_once "feedbrowser.php";
360 print json_encode(array("content" =>
361 make_feed_browser($search, $limit, $mode),
366 function massSubscribe() {
368 $payload = json_decode($_REQUEST["payload"], false);
369 $mode = $_REQUEST["mode"];
371 if (!$payload ||
!is_array($payload)) return;
374 foreach ($payload as $feed) {
377 $feed_url = $feed[1];
379 $sth = $this->pdo
->prepare("SELECT id FROM ttrss_feeds WHERE
380 feed_url = ? AND owner_uid = ?");
381 $sth->execute([$feed_url, $_SESSION['uid']]);
383 if (!$sth->fetch()) {
384 $sth = $this->pdo
->prepare("INSERT INTO ttrss_feeds
385 (owner_uid,feed_url,title,cat_id,site_url)
386 VALUES (?, ?, ?, NULL, '')");
388 $sth->execute([$_SESSION['uid'], $feed_url, $title]);
391 } else if ($mode == 2) {
393 foreach ($payload as $id) {
394 $sth = $this->pdo
->prepare("SELECT * FROM ttrss_archived_feeds
395 WHERE id = ? AND owner_uid = ?");
396 $sth->execute([$id, $_SESSION['uid']]);
398 if ($row = $sth->fetch()) {
399 $site_url = $row['site_url'];
400 $feed_url = $row['feed_url'];
401 $title = $row['title'];
403 $sth = $this->pdo
->prepare("SELECT id FROM ttrss_feeds WHERE
404 feed_url = ? AND owner_uid = ?");
405 $sth->execute([$feed_url, $_SESSION['uid']]);
407 if (!$sth->fetch()) {
408 $sth = $this->pdo
->prepare("INSERT INTO ttrss_feeds
409 (owner_uid,feed_url,title,cat_id,site_url)
410 VALUES (?, ?, ?, NULL, ?)");
412 $sth->execute([$_SESSION['uid'], $feed_url, $title, $site_url]);
419 function catchupFeed() {
420 $feed_id = $_REQUEST['feed_id'];
421 $is_cat = $_REQUEST['is_cat'] == "true";
422 $mode = $_REQUEST['mode'];
423 $search_query = $_REQUEST['search_query'];
424 $search_lang = $_REQUEST['search_lang'];
426 Feeds
::catchup_feed($feed_id, $is_cat, false, $mode, [$search_query, $search_lang]);
428 print json_encode(array("message" => "UPDATE_COUNTERS"));
431 function setpanelmode() {
432 $wide = (int) $_REQUEST["wide"];
434 setcookie("ttrss_widescreen", $wide,
435 time() + COOKIE_LIFETIME_LONG
);
437 print json_encode(array("wide" => $wide));
440 static function updaterandomfeed_real() {
442 // Test if the feed need a update (update interval exceded).
443 if (DB_TYPE
== "pgsql") {
444 $update_limit_qpart = "AND ((
445 ttrss_feeds.update_interval = 0
446 AND ttrss_feeds.last_updated < NOW() - CAST((ttrss_user_prefs.value || ' minutes') AS INTERVAL)
448 ttrss_feeds.update_interval > 0
449 AND ttrss_feeds.last_updated < NOW() - CAST((ttrss_feeds.update_interval || ' minutes') AS INTERVAL)
450 ) OR ttrss_feeds.last_updated IS NULL
451 OR last_updated = '1970-01-01 00:00:00')";
453 $update_limit_qpart = "AND ((
454 ttrss_feeds.update_interval = 0
455 AND ttrss_feeds.last_updated < DATE_SUB(NOW(), INTERVAL CONVERT(ttrss_user_prefs.value, SIGNED INTEGER) MINUTE)
457 ttrss_feeds.update_interval > 0
458 AND ttrss_feeds.last_updated < DATE_SUB(NOW(), INTERVAL ttrss_feeds.update_interval MINUTE)
459 ) OR ttrss_feeds.last_updated IS NULL
460 OR last_updated = '1970-01-01 00:00:00')";
463 // Test if feed is currently being updated by another process.
464 if (DB_TYPE
== "pgsql") {
465 $updstart_thresh_qpart = "AND (ttrss_feeds.last_update_started IS NULL OR ttrss_feeds.last_update_started < NOW() - INTERVAL '5 minutes')";
467 $updstart_thresh_qpart = "AND (ttrss_feeds.last_update_started IS NULL OR ttrss_feeds.last_update_started < DATE_SUB(NOW(), INTERVAL 5 MINUTE))";
470 $random_qpart = sql_random_function();
474 // we could be invoked from public.php with no active session
475 if ($_SESSION["uid"]) {
476 $owner_check_qpart = "AND ttrss_feeds.owner_uid = ".$pdo->quote($_SESSION["uid"]);
478 $owner_check_qpart = "";
481 // We search for feed needing update.
482 $res = $pdo->query("SELECT ttrss_feeds.feed_url,ttrss_feeds.id
484 ttrss_feeds, ttrss_users, ttrss_user_prefs
486 ttrss_feeds.owner_uid = ttrss_users.id
487 AND ttrss_users.id = ttrss_user_prefs.owner_uid
488 AND ttrss_user_prefs.pref_name = 'DEFAULT_UPDATE_INTERVAL'
491 $updstart_thresh_qpart
492 ORDER BY $random_qpart LIMIT 30");
498 while ($line = $res->fetch()) {
499 $feed_id = $line["id"];
501 if (time() - $tstart < ini_get("max_execution_time") * 0.7) {
502 RSSUtils
::update_rss_feed($feed_id, true);
509 // Purge orphans and cleanup tags
510 Article
::purge_orphans();
511 //cleanup_tags(14, 50000);
513 if ($num_updated > 0) {
514 print json_encode(array("message" => "UPDATE_COUNTERS",
515 "num_updated" => $num_updated));
517 print json_encode(array("message" => "NOTHING_TO_UPDATE"));
522 function updaterandomfeed() {
523 RPC
::updaterandomfeed_real();
526 private function markArticlesById($ids, $cmode) {
528 $ids_qmarks = arr_qmarks($ids);
531 $sth = $this->pdo
->prepare("UPDATE ttrss_user_entries SET
532 marked = false, last_marked = NOW()
533 WHERE ref_id IN ($ids_qmarks) AND owner_uid = ?");
534 } else if ($cmode == 1) {
535 $sth = $this->pdo
->prepare("UPDATE ttrss_user_entries SET
536 marked = true, last_marked = NOW()
537 WHERE ref_id IN ($ids_qmarks) AND owner_uid = ?");
539 $sth = $this->pdo
->prepare("UPDATE ttrss_user_entries SET
540 marked = NOT marked,last_marked = NOW()
541 WHERE ref_id IN ($ids_qmarks) AND owner_uid = ?");
544 $sth->execute(array_merge($ids, [$_SESSION['uid']]));
547 private function publishArticlesById($ids, $cmode) {
549 $ids_qmarks = arr_qmarks($ids);
552 $sth = $this->pdo
->prepare("UPDATE ttrss_user_entries SET
553 published = false, last_published = NOW()
554 WHERE ref_id IN ($ids_qmarks) AND owner_uid = ?");
555 } else if ($cmode == 1) {
556 $sth = $this->pdo
->prepare("UPDATE ttrss_user_entries SET
557 published = true, last_published = NOW()
558 WHERE ref_id IN ($ids_qmarks) AND owner_uid = ?");
560 $sth = $this->pdo
->prepare("UPDATE ttrss_user_entries SET
561 published = NOT published,last_published = NOW()
562 WHERE ref_id IN ($ids_qmarks) AND owner_uid = ?");
565 $sth->execute(array_merge($ids, [$_SESSION['uid']]));
568 function getlinktitlebyid() {
569 $id = $_REQUEST['id'];
571 $sth = $this->pdo
->prepare("SELECT link, title FROM ttrss_entries, ttrss_user_entries
572 WHERE ref_id = ? AND ref_id = id AND owner_uid = ?");
573 $sth->execute([$id, $_SESSION['uid']]);
575 if ($row = $sth->fetch()) {
576 $link = $row['link'];
577 $title = $row['title'];
579 echo json_encode(array("link" => $link, "title" => $title));
581 echo json_encode(array("error" => "ARTICLE_NOT_FOUND"));
586 $msg = $_REQUEST['msg'];
587 $file = basename($_REQUEST['file']);
588 $line = (int) $_REQUEST['line'];
589 $context = $_REQUEST['context'];
592 Logger
::get()->log_error(E_USER_WARNING
,
593 $msg, 'client-js:' . $file, $line, $context);
595 echo json_encode(array("message" => "HOST_ERROR_LOGGED"));
597 echo json_encode(array("error" => "MESSAGE_NOT_FOUND"));