]> git.wh0rd.org - tt-rss.git/blame - classes/api.php
git.wh0rd.org / tt-rss.git / blame
? search:
summary | shortlog | log | commit | commitdiff | tree
blob | blame (incremental) | history | HEAD
Merge pull request #118 from vapier/x-sendfile
[tt-rss.git] / classes / api.php
CommitLineData
de8260cb
AD		 1<?php
2
3class API extends Handler {
4
efc6553d 5 const API_LEVEL = 5;
de8260cb
AD		 6
7 const STATUS_OK = 0;
8 const STATUS_ERR = 1;
9
10 private $seq;
11
12 function before($method) {
13 if (parent::before($method)) {
12f31782 14 header("Content-Type: text/json");
de8260cb
AD		 15
16 if (!$_SESSION["uid"] && $method != "login" && $method != "isloggedin") {
17 print $this->wrap(self::STATUS_ERR, array("error" => 'NOT_LOGGED_IN'));
18 return false;
19 }
20
21 if ($_SESSION["uid"] && $method != "logout" && !get_pref($this->link, 'ENABLE_API_ACCESS')) {
22 print $this->wrap(self::STATUS_ERR, array("error" => 'API_DISABLED'));
23 return false;
24 }
25
26 $this->seq = (int) $_REQUEST['seq'];
27
de8260cb
AD		 28 return true;
29 }
30 return false;
31 }
32
33 function wrap($status, $reply) {
34 print json_encode(array("seq" => $this->seq,
35 "status" => $status,
36 "content" => $reply));
37 }
38
39 function getVersion() {
40 $rv = array("version" => VERSION);
41 print $this->wrap(self::STATUS_OK, $rv);
42 }
43
44 function getApiLevel() {
a3b5394a 45 $rv = array("level" => self::API_LEVEL);
de8260cb
AD		 46 print $this->wrap(self::STATUS_OK, $rv);
47 }
48
49 function login() {
79bb5589 50 @session_destroy();
5160620c
AD		 51 @session_start();
52
3972bf59 53 $login = db_escape_string($this->link, $_REQUEST["user"]);
de8260cb
AD		 54 $password = $_REQUEST["password"];
55 $password_base64 = base64_decode($_REQUEST["password"]);
56
57 if (SINGLE_USER_MODE) $login = "admin";
58
59 $result = db_query($this->link, "SELECT id FROM ttrss_users WHERE login = '$login'");
60
61 if (db_num_rows($result) != 0) {
62 $uid = db_fetch_result($result, 0, "id");
63 } else {
64 $uid = 0;
65 }
66
67 if (!$uid) {
68 print $this->wrap(self::STATUS_ERR, array("error" => "LOGIN_ERROR"));
69 return;
70 }
71
72 if (get_pref($this->link, "ENABLE_API_ACCESS", $uid)) {
73 if (authenticate_user($this->link, $login, $password)) { // try login with normal password
5ba4ebc6
AD		 74 print $this->wrap(self::STATUS_OK, array("session_id" => session_id(),
75 "api_level" => self::API_LEVEL));
de8260cb 76 } else if (authenticate_user($this->link, $login, $password_base64)) { // else try with base64_decoded password
5ba4ebc6
AD		 77 print $this->wrap(self::STATUS_OK, array("session_id" => session_id(),
78 "api_level" => self::API_LEVEL));
de8260cb
AD		 79 } else { // else we are not logged in
80 print $this->wrap(self::STATUS_ERR, array("error" => "LOGIN_ERROR"));
81 }
82 } else {
83 print $this->wrap(self::STATUS_ERR, array("error" => "API_DISABLED"));
84 }
85
86 }
87
88 function logout() {
89 logout_user();
90 print $this->wrap(self::STATUS_OK, array("status" => "OK"));
91 }
92
93 function isLoggedIn() {
94 print $this->wrap(self::STATUS_OK, array("status" => $_SESSION["uid"] != ''));
95 }
96
97 function getUnread() {
3972bf59
AD		 98 $feed_id = db_escape_string($this->link, $_REQUEST["feed_id"]);
99 $is_cat = db_escape_string($this->link, $_REQUEST["is_cat"]);
de8260cb
AD		 100
101 if ($feed_id) {
102 print $this->wrap(self::STATUS_OK, array("unread" => getFeedUnread($this->link, $feed_id, $is_cat)));
103 } else {
104 print $this->wrap(self::STATUS_OK, array("unread" => getGlobalUnread($this->link)));
105 }
106 }
107
108 /* Method added for ttrss-reader for Android */
109 function getCounters() {
5b55e9e2 110 print $this->wrap(self::STATUS_OK, getAllCounters($this->link));
de8260cb
AD		 111 }
112
113 function getFeeds() {
3972bf59 114 $cat_id = db_escape_string($this->link, $_REQUEST["cat_id"]);
9955a134 115 $unread_only = sql_bool_to_bool($_REQUEST["unread_only"]);
3972bf59
AD		 116 $limit = (int) db_escape_string($this->link, $_REQUEST["limit"]);
117 $offset = (int) db_escape_string($this->link, $_REQUEST["offset"]);
9955a134 118 $include_nested = sql_bool_to_bool($_REQUEST["include_nested"]);
de8260cb 119
04f60eb7 120 $feeds = $this->api_get_feeds($this->link, $cat_id, $unread_only, $limit, $offset, $include_nested);
de8260cb
AD		 121
122 print $this->wrap(self::STATUS_OK, $feeds);
123 }
124
125 function getCategories() {
9955a134
AD		 126 $unread_only = sql_bool_to_bool($_REQUEST["unread_only"]);
127 $enable_nested = sql_bool_to_bool($_REQUEST["enable_nested"]);
b3575bd8 128 $include_empty = sql_bool_to_bool($_REQUEST['include_empty']);
de8260cb
AD		 129
130 // TODO do not return empty categories, return Uncategorized and standard virtual cats
131
48646336
AD		 132 if ($enable_nested)
133 $nested_qpart = "parent_cat IS NULL";
134 else
135 $nested_qpart = "true";
136
de8260cb 137 $result = db_query($this->link, "SELECT
d49dfa38
AD		 138 id, title, order_id, (SELECT COUNT(id) FROM
139 ttrss_feeds WHERE
7be3fcd5
AD		 140 ttrss_feed_categories.id IS NOT NULL AND cat_id = ttrss_feed_categories.id) AS num_feeds,
141 (SELECT COUNT(id) FROM
142 ttrss_feed_categories AS c2 WHERE
143 c2.parent_cat = ttrss_feed_categories.id) AS num_cats
d49dfa38 144 FROM ttrss_feed_categories
48646336 145 WHERE $nested_qpart AND owner_uid = " .
de8260cb
AD		 146 $_SESSION["uid"]);
147
148 $cats = array();
149
150 while ($line = db_fetch_assoc($result)) {
66ca7c30 151 if ($include_empty || $line["num_feeds"] > 0 || $line["num_cats"] > 0) {
d49dfa38
AD		 152 $unread = getFeedUnread($this->link, $line["id"], true);
153
154 if ($enable_nested)
155 $unread += getCategoryChildrenUnread($this->link, $line["id"]);
156
157 if ($unread || !$unread_only) {
158 array_push($cats, array("id" => $line["id"],
159 "title" => $line["title"],
160 "unread" => $unread,
161 "order_id" => (int) $line["order_id"],
162 ));
163 }
de8260cb
AD		 164 }
165 }
166
167 foreach (array(-2,-1,0) as $cat_id) {
c0a08063
AD		 168 if ($include_empty || !$this->isCategoryEmpty($cat_id)) {
169 $unread = getFeedUnread($this->link, $cat_id, true);
de8260cb 170
c0a08063
AD		 171 if ($unread || !$unread_only) {
172 array_push($cats, array("id" => $cat_id,
173 "title" => getCategoryTitle($this->link, $cat_id),
174 "unread" => $unread));
175 }
de8260cb
AD		 176 }
177 }
178
179 print $this->wrap(self::STATUS_OK, $cats);
180 }
181
182 function getHeadlines() {
3972bf59 183 $feed_id = db_escape_string($this->link, $_REQUEST["feed_id"]);
8aa3becc 184 if ($feed_id != "") {
de8260cb 185
3972bf59 186 $limit = (int)db_escape_string($this->link, $_REQUEST["limit"]);
1a740cf6
AD		 187
188 if (!$limit || $limit >= 60) $limit = 60;
189
3972bf59
AD		 190 $offset = (int)db_escape_string($this->link, $_REQUEST["skip"]);
191 $filter = db_escape_string($this->link, $_REQUEST["filter"]);
9955a134
AD		 192 $is_cat = sql_bool_to_bool($_REQUEST["is_cat"]);
193 $show_excerpt = sql_bool_to_bool($_REQUEST["show_excerpt"]);
194 $show_content = sql_bool_to_bool($_REQUEST["show_content"]);
de8260cb 195 /* all_articles, unread, adaptive, marked, updated */
3972bf59 196 $view_mode = db_escape_string($this->link, $_REQUEST["view_mode"]);
9955a134 197 $include_attachments = sql_bool_to_bool($_REQUEST["include_attachments"]);
3972bf59 198 $since_id = (int)db_escape_string($this->link, $_REQUEST["since_id"]);
9955a134 199 $include_nested = sql_bool_to_bool($_REQUEST["include_nested"]);
db9e00e3 200 $sanitize_content = true;
0bbd1414 201 $override_order = false;
202 switch ($_REQUEST["order_by"]) {
203 case "date_reverse":
204 $override_order = "date_entered, updated";
205 break;
206 case "feed_dates":
207 $override_order = "updated DESC";
208 break;
209 }
3e4af5b0
AD		 210 /* do not rely on params below */
211
3972bf59
AD		 212 $search = db_escape_string($this->link, $_REQUEST["search"]);
213 $search_mode = db_escape_string($this->link, $_REQUEST["search_mode"]);
3e4af5b0 214
04f60eb7 215 $headlines = $this->api_get_headlines($this->link, $feed_id, $limit, $offset,
0bbd1414 216 $filter, $is_cat, $show_excerpt, $show_content, $view_mode, $override_order,
ca5d9be4 217 $include_attachments, $since_id, $search, $search_mode,
db9e00e3 218 $include_nested, $sanitize_content);
de8260cb
AD		 219
220 print $this->wrap(self::STATUS_OK, $headlines);
221 } else {
222 print $this->wrap(self::STATUS_ERR, array("error" => 'INCORRECT_USAGE'));
223 }
224 }
225
226 function updateArticle() {
3972bf59
AD		 227 $article_ids = array_filter(explode(",", db_escape_string($this->link, $_REQUEST["article_ids"])), is_numeric);
228 $mode = (int) db_escape_string($this->link, $_REQUEST["mode"]);
229 $data = db_escape_string($this->link, $_REQUEST["data"]);
230 $field_raw = (int)db_escape_string($this->link, $_REQUEST["field"]);
de8260cb
AD		 231
232 $field = "";
233 $set_to = "";
234
235 switch ($field_raw) {
236 case 0:
237 $field = "marked";
7873d588 238 $additional_fields = ",last_marked = NOW()";
de8260cb
AD		 239 break;
240 case 1:
241 $field = "published";
7873d588 242 $additional_fields = ",last_published = NOW()";
de8260cb
AD		 243 break;
244 case 2:
245 $field = "unread";
7873d588 246 $additional_fields = ",last_read = NOW()";
de8260cb
AD		 247 break;
248 case 3:
249 $field = "note";
250 };
251
252 switch ($mode) {
253 case 1:
254 $set_to = "true";
255 break;
256 case 0:
257 $set_to = "false";
258 break;
259 case 2:
260 $set_to = "NOT $field";
261 break;
262 }
263
264 if ($field == "note") $set_to = "'$data'";
265
266 if ($field && $set_to && count($article_ids) > 0) {
267
268 $article_ids = join(", ", $article_ids);
269
7873d588 270 $result = db_query($this->link, "UPDATE ttrss_user_entries SET $field = $set_to $additional_fields WHERE ref_id IN ($article_ids) AND owner_uid = " . $_SESSION["uid"]);
de8260cb
AD		 271
272 $num_updated = db_affected_rows($this->link, $result);
273
274 if ($num_updated > 0 && $field == "unread") {
275 $result = db_query($this->link, "SELECT DISTINCT feed_id FROM ttrss_user_entries
276 WHERE ref_id IN ($article_ids)");
277
278 while ($line = db_fetch_assoc($result)) {
279 ccache_update($this->link, $line["feed_id"], $_SESSION["uid"]);
280 }
281 }
282
7873d588
AD		 283 if ($num_updated > 0 && $field == "published") {
284 if (PUBSUBHUBBUB_HUB) {
285 $rss_link = get_self_url_prefix() .
286 "/public.php?op=rss&id=-2&key=" .
287 get_feed_access_key($this->link, -2, false);
288
289 $p = new Publisher(PUBSUBHUBBUB_HUB);
290 $pubsub_result = $p->publish_update($rss_link);
291 }
292 }
293
de8260cb
AD		 294 print $this->wrap(self::STATUS_OK, array("status" => "OK",
295 "updated" => $num_updated));
296
297 } else {
298 print $this->wrap(self::STATUS_ERR, array("error" => 'INCORRECT_USAGE'));
299 }
300
301 }
302
303 function getArticle() {
304
3972bf59 305 $article_id = join(",", array_filter(explode(",", db_escape_string($this->link, $_REQUEST["article_id"])), is_numeric));
de8260cb 306
87764a50 307 $query = "SELECT id,title,link,content,cached_content,feed_id,comments,int_id,
de8260cb
AD		 308 marked,unread,published,
309 ".SUBSTRING_FOR_DATE."(updated,1,16) as updated,
310 author
311 FROM ttrss_entries,ttrss_user_entries
312 WHERE id IN ($article_id) AND ref_id = id AND owner_uid = " .
313 $_SESSION["uid"] ;
314
315 $result = db_query($this->link, $query);
316
317 $articles = array();
318
319 if (db_num_rows($result) != 0) {
320
321 while ($line = db_fetch_assoc($result)) {
322
323 $attachments = get_article_enclosures($this->link, $line['id']);
324
325 $article = array(
326 "id" => $line["id"],
327 "title" => $line["title"],
328 "link" => $line["link"],
329 "labels" => get_article_labels($this->link, $line['id']),
330 "unread" => sql_bool_to_bool($line["unread"]),
331 "marked" => sql_bool_to_bool($line["marked"]),
332 "published" => sql_bool_to_bool($line["published"]),
333 "comments" => $line["comments"],
334 "author" => $line["author"],
ef3da31c 335 "updated" => (int) strtotime($line["updated"]),
87764a50 336 "content" => $line["cached_content"] != "" ? $line["cached_content"] : $line["content"],
de8260cb
AD		 337 "feed_id" => $line["feed_id"],
338 "attachments" => $attachments
339 );
340
341 array_push($articles, $article);
342
343 }
344 }
345
346 print $this->wrap(self::STATUS_OK, $articles);
347
348 }
349
350 function getConfig() {
351 $config = array(
352 "icons_dir" => ICONS_DIR,
353 "icons_url" => ICONS_URL);
354
355 $config["daemon_is_running"] = file_is_locked("update_daemon.lock");
356
357 $result = db_query($this->link, "SELECT COUNT(*) AS cf FROM
358 ttrss_feeds WHERE owner_uid = " . $_SESSION["uid"]);
359
360 $num_feeds = db_fetch_result($result, 0, "cf");
361
362 $config["num_feeds"] = (int)$num_feeds;
363
364 print $this->wrap(self::STATUS_OK, $config);
365 }
366
367 function updateFeed() {
c1f6e5f8
AD		 368 require_once "include/rssfuncs.php";
369
370 $feed_id = (int) db_escape_string($this->link, $_REQUEST["feed_id"]);
de8260cb
AD		 371
372 update_rss_feed($this->link, $feed_id, true);
373
374 print $this->wrap(self::STATUS_OK, array("status" => "OK"));
375 }
376
377 function catchupFeed() {
3972bf59
AD		 378 $feed_id = db_escape_string($this->link, $_REQUEST["feed_id"]);
379 $is_cat = db_escape_string($this->link, $_REQUEST["is_cat"]);
de8260cb
AD		 380
381 catchup_feed($this->link, $feed_id, $is_cat);
382
383 print $this->wrap(self::STATUS_OK, array("status" => "OK"));
384 }
385
386 function getPref() {
3972bf59 387 $pref_name = db_escape_string($this->link, $_REQUEST["pref_name"]);
de8260cb
AD		 388
389 print $this->wrap(self::STATUS_OK, array("value" => get_pref($this->link, $pref_name)));
390 }
391
ea1c2903 392 function getLabels() {
3972bf59 393 //$article_ids = array_filter(explode(",", db_escape_string($this->link, $_REQUEST["article_ids"])), is_numeric);
ea1c2903
AD		 394
395 $article_id = (int)$_REQUEST['article_id'];
396
397 $rv = array();
398
399 $result = db_query($this->link, "SELECT id, caption, fg_color, bg_color
400 FROM ttrss_labels2
401 WHERE owner_uid = '".$_SESSION['uid']."' ORDER BY caption");
402
403 if ($article_id)
404 $article_labels = get_article_labels($this->link, $article_id);
405 else
406 $article_labels = array();
407
408 while ($line = db_fetch_assoc($result)) {
409
410 $checked = false;
411 foreach ($article_labels as $al) {
412 if ($al[0] == $line['id']) {
413 $checked = true;
414 break;
415 }
416 }
417
418 array_push($rv, array(
419 "id" => (int)$line['id'],
420 "caption" => $line['caption'],
421 "fg_color" => $line['fg_color'],
422 "bg_color" => $line['bg_color'],
423 "checked" => $checked));
424 }
425
426 print $this->wrap(self::STATUS_OK, $rv);
427 }
428
396bfdf9
AD		 429 function setArticleLabel() {
430
3972bf59
AD		 431 $article_ids = array_filter(explode(",", db_escape_string($this->link, $_REQUEST["article_ids"])), is_numeric);
432 $label_id = (int) db_escape_string($this->link, $_REQUEST['label_id']);
433 $assign = (bool) db_escape_string($this->link, $_REQUEST['assign']) == "true";
396bfdf9 434
3972bf59 435 $label = db_escape_string($this->link, label_find_caption($this->link,
396bfdf9
AD		 436 $label_id, $_SESSION["uid"]));
437
438 $num_updated = 0;
439
440 if ($label) {
441
442 foreach ($article_ids as $id) {
443
444 if ($assign)
445 label_add_article($this->link, $id, $label, $_SESSION["uid"]);
446 else
447 label_remove_article($this->link, $id, $label, $_SESSION["uid"]);
448
449 ++$num_updated;
450
451 }
452 }
453
454 print $this->wrap(self::STATUS_OK, array("status" => "OK",
455 "updated" => $num_updated));
456
457 }
458
de8260cb
AD		 459 function index() {
460 print $this->wrap(self::STATUS_ERR, array("error" => 'UNKNOWN_METHOD'));
461 }
462
8361e724 463 function shareToPublished() {
3972bf59
AD		 464 $title = db_escape_string($this->link, strip_tags($_REQUEST["title"]));
465 $url = db_escape_string($this->link, strip_tags($_REQUEST["url"]));
466 $content = db_escape_string($this->link, strip_tags($_REQUEST["content"]));
8361e724 467
50832719 468 if (Article::create_published_article($this->link, $title, $url, $content, "", $_SESSION["uid"])) {
8361e724
AD		 469 print $this->wrap(self::STATUS_OK, array("status" => 'OK'));
470 } else {
471 print $this->wrap(self::STATUS_ERR, array("error" => 'Publishing failed'));
472 }
473 }
04f60eb7
AD		 474
475 static function api_get_feeds($link, $cat_id, $unread_only, $limit, $offset, $include_nested = false) {
476
477 $feeds = array();
478
479 /* Labels */
480
481 if ($cat_id == -4 || $cat_id == -2) {
482 $counters = getLabelCounters($link, true);
483
484 foreach (array_values($counters) as $cv) {
485
486 $unread = $cv["counter"];
487
488 if ($unread || !$unread_only) {
489
490 $row = array(
491 "id" => $cv["id"],
492 "title" => $cv["description"],
493 "unread" => $cv["counter"],
494 "cat_id" => -2,
495 );
496
497 array_push($feeds, $row);
498 }
499 }
500 }
501
502 /* Virtual feeds */
503
504 if ($cat_id == -4 || $cat_id == -1) {
505 foreach (array(-1, -2, -3, -4, -6, 0) as $i) {
506 $unread = getFeedUnread($link, $i);
507
508 if ($unread || !$unread_only) {
509 $title = getFeedTitle($link, $i);
510
511 $row = array(
512 "id" => $i,
513 "title" => $title,
514 "unread" => $unread,
515 "cat_id" => -1,
516 );
517 array_push($feeds, $row);
518 }
519
520 }
521 }
522
523 /* Child cats */
524
525 if ($include_nested && $cat_id) {
526 $result = db_query($link, "SELECT
527 id, title FROM ttrss_feed_categories
528 WHERE parent_cat = '$cat_id' AND owner_uid = " . $_SESSION["uid"] .
529 " ORDER BY id, title");
530
531 while ($line = db_fetch_assoc($result)) {
532 $unread = getFeedUnread($link, $line["id"], true) +
533 getCategoryChildrenUnread($link, $line["id"]);
534
535 if ($unread || !$unread_only) {
536 $row = array(
537 "id" => $line["id"],
538 "title" => $line["title"],
539 "unread" => $unread,
540 "is_cat" => true,
541 );
542 array_push($feeds, $row);
543 }
544 }
545 }
546
547 /* Real feeds */
548
549 if ($limit) {
550 $limit_qpart = "LIMIT $limit OFFSET $offset";
551 } else {
552 $limit_qpart = "";
553 }
554
555 if ($cat_id == -4 || $cat_id == -3) {
556 $result = db_query($link, "SELECT
557 id, feed_url, cat_id, title, order_id, ".
558 SUBSTRING_FOR_DATE."(last_updated,1,19) AS last_updated
559 FROM ttrss_feeds WHERE owner_uid = " . $_SESSION["uid"] .
560 " ORDER BY cat_id, title " . $limit_qpart);
561 } else {
562
563 if ($cat_id)
564 $cat_qpart = "cat_id = '$cat_id'";
565 else
566 $cat_qpart = "cat_id IS NULL";
567
568 $result = db_query($link, "SELECT
569 id, feed_url, cat_id, title, order_id, ".
570 SUBSTRING_FOR_DATE."(last_updated,1,19) AS last_updated
571 FROM ttrss_feeds WHERE
572 $cat_qpart AND owner_uid = " . $_SESSION["uid"] .
573 " ORDER BY cat_id, title " . $limit_qpart);
574 }
575
576 while ($line = db_fetch_assoc($result)) {
577
578 $unread = getFeedUnread($link, $line["id"]);
579
580 $has_icon = feed_has_icon($line['id']);
581
582 if ($unread || !$unread_only) {
583
584 $row = array(
585 "feed_url" => $line["feed_url"],
586 "title" => $line["title"],
587 "id" => (int)$line["id"],
588 "unread" => (int)$unread,
589 "has_icon" => $has_icon,
590 "cat_id" => (int)$line["cat_id"],
ef3da31c 591 "last_updated" => (int) strtotime($line["last_updated"]),
04f60eb7
AD		 592 "order_id" => (int) $line["order_id"],
593 );
594
595 array_push($feeds, $row);
596 }
597 }
598
599 return $feeds;
600 }
601
602 static function api_get_headlines($link, $feed_id, $limit, $offset,
603 $filter, $is_cat, $show_excerpt, $show_content, $view_mode, $order,
604 $include_attachments, $since_id,
ca5d9be4 605 $search = "", $search_mode = "",
04f60eb7
AD		 606 $include_nested = false, $sanitize_content = true) {
607
608 $qfh_ret = queryFeedHeadlines($link, $feed_id, $limit,
ca5d9be4 609 $view_mode, $is_cat, $search, $search_mode,
04f60eb7
AD		 610 $order, $offset, 0, false, $since_id, $include_nested);
611
612 $result = $qfh_ret[0];
613 $feed_title = $qfh_ret[1];
614
615 $headlines = array();
616
617 while ($line = db_fetch_assoc($result)) {
618 $is_updated = ($line["last_read"] == "" &&
619 ($line["unread"] != "t" && $line["unread"] != "1"));
620
621 $tags = explode(",", $line["tag_cache"]);
622 $labels = json_decode($line["label_cache"], true);
623
624 //if (!$tags) $tags = get_article_tags($link, $line["id"]);
625 //if (!$labels) $labels = get_article_labels($link, $line["id"]);
626
627 $headline_row = array(
628 "id" => (int)$line["id"],
629 "unread" => sql_bool_to_bool($line["unread"]),
630 "marked" => sql_bool_to_bool($line["marked"]),
631 "published" => sql_bool_to_bool($line["published"]),
ef3da31c 632 "updated" => (int) strtotime($line["updated"]),
04f60eb7
AD		 633 "is_updated" => $is_updated,
634 "title" => $line["title"],
635 "link" => $line["link"],
636 "feed_id" => $line["feed_id"],
637 "tags" => $tags,
638 );
639
640 if ($include_attachments)
641 $headline_row['attachments'] = get_article_enclosures($link,
642 $line['id']);
643
644 if ($show_excerpt) {
645 $excerpt = truncate_string(strip_tags($line["content_preview"]), 100);
646 $headline_row["excerpt"] = $excerpt;
647 }
648
649 if ($show_content) {
650
651 if ($line["cached_content"] != "") {
652 $line["content_preview"] =& $line["cached_content"];
653 }
654
655 if ($sanitize_content) {
656 $headline_row["content"] = sanitize($link,
bfd61d3f
AD		 657 $line["content_preview"],
658 sql_bool_to_bool($line['hide_images']),
659 false, $line["site_url"]);
04f60eb7
AD		 660 } else {
661 $headline_row["content"] = $line["content_preview"];
662 }
663 }
664
665 // unify label output to ease parsing
666 if ($labels["no-labels"] == 1) $labels = array();
667
668 $headline_row["labels"] = $labels;
669
670 $headline_row["feed_title"] = $line["feed_title"];
671
672 $headline_row["comments_count"] = (int)$line["num_comments"];
673 $headline_row["comments_link"] = $line["comments"];
674
675 $headline_row["always_display_attachments"] = sql_bool_to_bool($line["always_display_enclosures"]);
676
583dbc56
AD		 677 $headline_row["author"] = $line["author"];
678
b6604c96
AD		 679 global $pluginhost;
680 foreach ($pluginhost->get_hooks($pluginhost::HOOK_RENDER_ARTICLE_API) as $p) {
681 $headline_row = $p->hook_render_article_api($headline_row);
682 }
683
04f60eb7
AD		 684 array_push($headlines, $headline_row);
685 }
686
687 return $headlines;
688 }
689
efc6553d
AD		 690 function unsubscribeFeed() {
691 $feed_id = (int) db_escape_string($this->link, $_REQUEST["feed_id"]);
692
693 $result = db_query($this->link, "SELECT id FROM ttrss_feeds WHERE
694 id = '$feed_id' AND owner_uid = ".$_SESSION["uid"]);
695
696 if (db_num_rows($result) != 0) {
697 Pref_Feeds::remove_feed($this->link, $feed_id, $_SESSION["uid"]);
698 print $this->wrap(self::STATUS_OK, array("status" => "OK"));
699 } else {
700 print $this->wrap(self::STATUS_ERR, array("error" => "FEED_NOT_FOUND"));
701 }
702 }
703
704 function subscribeToFeed() {
705 $feed_url = db_escape_string($this->link, $_REQUEST["feed_url"]);
706 $category_id = (int) db_escape_string($this->link, $_REQUEST["category_id"]);
707 $login = db_escape_string($this->link, $_REQUEST["login"]);
708 $password = db_escape_string($this->link, $_REQUEST["password"]);
709
710 if ($feed_url) {
711 $rc = subscribe_to_feed($this->link, $feed_url, $category_id,
712 $login, $password, false);
713
714 print $this->wrap(self::STATUS_OK, array("status" => $rc));
715 } else {
716 print $this->wrap(self::STATUS_ERR, array("error" => 'INCORRECT_USAGE'));
717 }
718 }
719
0bb5833b 720 function getFeedTree() {
b3575bd8 721 $include_empty = sql_bool_to_bool($_REQUEST['include_empty']);
66ca7c30 722
0bb5833b
AD		 723 $pf = new Pref_Feeds($this->link, $_REQUEST);
724
725 $_REQUEST['mode'] = 2;
66ca7c30 726 $_REQUEST['force_show_empty'] = $include_empty;
0bb5833b
AD		 727
728 if ($pf){
729 $data = $pf->makefeedtree();
730 print $this->wrap(self::STATUS_OK, array("categories" => $data));
731 } else {
732 print $this->wrap(self::STATUS_ERR, array("error" =>
733 'UNABLE_TO_INSTANTIATE_OBJECT'));
734 }
735
736 }
c0a08063 737
dc5a8a21 738 // only works for labels or uncategorized for the time being
c0a08063
AD		 739 private function isCategoryEmpty($id) {
740
741 if ($id == -2) {
742 $result = db_query($this->link, "SELECT COUNT(*) AS count FROM ttrss_labels2
743 WHERE owner_uid = " . $_SESSION["uid"]);
744
745 return db_fetch_result($result, 0, "count") == 0;
746
dc5a8a21
AD		 747 } else if ($id == 0) {
748 $result = db_query($this->link, "SELECT COUNT(*) AS count FROM ttrss_feeds
749 WHERE cat_id IS NULL AND owner_uid = " . $_SESSION["uid"]);
750
751 return db_fetch_result($result, 0, "count") == 0;
752
c0a08063
AD		 753 }
754
755 return false;
756 }
757
758
de8260cb
AD		 759}
760
761?>
web-based news feed (RSS/Atom) reader and aggregator; see https://tt-rss.org/