]> git.wh0rd.org - tt-rss.git/blame - classes/feeds.php
git.wh0rd.org / tt-rss.git / blame
? search:
summary | shortlog | log | commit | commitdiff | tree
blob | blame (incremental) | history | HEAD
db_escape_string: specify link parameter for consistency; sessions: do not force...
[tt-rss.git] / classes / feeds.php
CommitLineData
6afcbcd1
AD		 1<?php
2require_once "colors.php";
3
4class Feeds extends Handler_Protected {
5
6 function csrf_ignore($method) {
7 $csrf_ignored = array("index");
8
9 return array_search($method, $csrf_ignored) !== false;
10 }
11
12 private function make_gradient($end, $class) {
13 $start = $class == "even" ? "#f0f0f0" : "#ffffff";
14
15 return "style='background: linear-gradient(left , $start 6%, $end 100%);
16 background: -o-linear-gradient(left , $start 6%, $end 100%);
17 background: -moz-linear-gradient(left , $start 6%, $end 100%);
18 background: -webkit-linear-gradient(left , $start 6%, $end 100%);
19 background: -ms-linear-gradient(left , $start 6%, $end 100%);
20 background: -webkit-gradient(linear, left top, right top,
21 color-stop(0.06, $start), color-stop(1, $end));'";
22 }
23
24 private function format_headline_subtoolbar($feed_site_url, $feed_title,
ca5d9be4 25 $feed_id, $is_cat, $search,
6afcbcd1
AD		 26 $search_mode, $view_mode, $error) {
27
28 $page_prev_link = "viewFeedGoPage(-1)";
29 $page_next_link = "viewFeedGoPage(1)";
30 $page_first_link = "viewFeedGoPage(0)";
31
32 $catchup_page_link = "catchupPage()";
33 $catchup_feed_link = "catchupCurrentFeed()";
34 $catchup_sel_link = "catchupSelection()";
35
36 $archive_sel_link = "archiveSelection()";
37 $delete_sel_link = "deleteSelection()";
38
39 $sel_all_link = "selectArticles('all')";
40 $sel_unread_link = "selectArticles('unread')";
41 $sel_none_link = "selectArticles('none')";
42 $sel_inv_link = "selectArticles('invert')";
43
44 $tog_unread_link = "selectionToggleUnread()";
45 $tog_marked_link = "selectionToggleMarked()";
46 $tog_published_link = "selectionTogglePublished()";
47
48 $set_score_link = "setSelectionScore()";
49
50 if ($is_cat) $cat_q = "&is_cat=$is_cat";
51
52 if ($search) {
ca5d9be4 53 $search_q = "&q=$search&smode=$search_mode";
6afcbcd1
AD		 54 } else {
55 $search_q = "";
56 }
57
58 $rss_link = htmlspecialchars(get_self_url_prefix() .
59 "/public.php?op=rss&id=$feed_id$cat_q$search_q");
60
61 // right part
62
63 $reply .= "<span class='r'>";
64 $reply .= "<span id='feed_title'>";
65
66 if ($feed_site_url) {
67 $target = "target=\"_blank\"";
68 $reply .= "<a title=\"".__("Visit the website")."\" $target href=\"$feed_site_url\">".
69 truncate_string($feed_title,30)."</a>";
70
71 if ($error) {
72 $reply .= " (<span class=\"error\" title=\"$error\">Error</span>)";
73 }
74
75 } else {
76 $reply .= $feed_title;
77 }
78
79 $reply .= "</span>";
80
81 $reply .= "
82 <a href=\"#\"
83 title=\"".__("View as RSS feed")."\"
84 onclick=\"displayDlg('generatedFeed', '$feed_id:$is_cat:$rss_link')\">
85 <img class=\"noborder\" style=\"vertical-align : middle\" src=\"images/pub_set.svg\"></a>";
86
87 $reply .= "</span>";
88
89 // left part
90
91 $reply .= __('Select:')."
92 <a href=\"#\" onclick=\"$sel_all_link\">".__('All')."</a>,
93 <a href=\"#\" onclick=\"$sel_unread_link\">".__('Unread')."</a>,
94 <a href=\"#\" onclick=\"$sel_inv_link\">".__('Invert')."</a>,
95 <a href=\"#\" onclick=\"$sel_none_link\">".__('None')."</a></li>";
96
97 $reply .= " ";
98
99 $reply .= "<select dojoType=\"dijit.form.Select\"
100 onchange=\"headlineActionsChange(this)\">";
101 $reply .= "<option value=\"false\">".__('More...')."</option>";
102
103 $reply .= "<option value=\"0\" disabled=\"1\">".__('Selection toggle:')."</option>";
104
105 $reply .= "<option value=\"$tog_unread_link\">".__('Unread')."</option>
106 <option value=\"$tog_marked_link\">".__('Starred')."</option>
107 <option value=\"$tog_published_link\">".__('Published')."</option>";
108
109 $reply .= "<option value=\"0\" disabled=\"1\">".__('Selection:')."</option>";
110
111 $reply .= "<option value=\"$catchup_sel_link\">".__('Mark as read')."</option>";
112 $reply .= "<option value=\"$set_score_link\">".__('Set score')."</option>";
113
114 if ($feed_id != "0") {
115 $reply .= "<option value=\"$archive_sel_link\">".__('Archive')."</option>";
116 } else {
117 $reply .= "<option value=\"$archive_sel_link\">".__('Move back')."</option>";
118 $reply .= "<option value=\"$delete_sel_link\">".__('Delete')."</option>";
119
120 }
121
122 global $pluginhost;
123
124 if ($pluginhost->get_plugin("mail")) {
125 $reply .= "<option value=\"emailArticle(false)\">".__('Forward by email').
126 "</option>";
127 }
128
1d5cf085
AD		 129 if ($pluginhost->get_plugin("mailto")) {
130 $reply .= "<option value=\"mailtoArticle(false)\">".__('Forward by email').
131 "</option>";
132 }
133
6afcbcd1
AD		 134 $reply .= "<option value=\"0\" disabled=\"1\">".__('Feed:')."</option>";
135
136 $reply .= "<option value=\"catchupPage()\">".__('Mark as read')."</option>";
137
138 $reply .= "<option value=\"displayDlg('generatedFeed', '$feed_id:$is_cat:$rss_link')\">".__('View as RSS')."</option>";
139
140 $reply .= "</select>";
141
142 //$reply .= "</div>";
143
144 //$reply .= "</h2";
145
146 return $reply;
147 }
148
149 private function format_headlines_list($feed, $method, $view_mode, $limit, $cat_view,
150 $next_unread_feed, $offset, $vgr_last_feed = false,
151 $override_order = false, $include_children = false) {
152
153 if (isset($_REQUEST["DevForceUpdate"]))
154 header("Content-Type: text/plain");
155
156 $disable_cache = false;
157
158 $reply = array();
159
fa9e88c3 160 $timing_info = microtime(true);
6afcbcd1
AD		 161
162 $topmost_article_ids = array();
163
164 if (!$offset) $offset = 0;
165 if ($method == "undefined") $method = "";
166
167 $method_split = explode(":", $method);
168
169 if ($method == "ForceUpdate" && $feed > 0 && is_numeric($feed)) {
170 // Update the feed if required with some basic flood control
171
172 $result = db_query($this->link,
8349a32e 173 "SELECT cache_images,".SUBSTRING_FOR_DATE."(last_updated,1,19) AS last_updated
6afcbcd1
AD		 174 FROM ttrss_feeds WHERE id = '$feed'");
175
176 if (db_num_rows($result) != 0) {
177 $last_updated = strtotime(db_fetch_result($result, 0, "last_updated"));
178 $cache_images = sql_bool_to_bool(db_fetch_result($result, 0, "cache_images"));
6afcbcd1 179
8349a32e 180 if (!$cache_images && time() - $last_updated > 120 || isset($_REQUEST['DevForceUpdate'])) {
6afcbcd1
AD		 181 include "rssfuncs.php";
182 update_rss_feed($this->link, $feed, true, true);
183 } else {
184 db_query($this->link, "UPDATE ttrss_feeds SET last_updated = '1970-01-01', last_update_started = '1970-01-01'
185 WHERE id = '$feed'");
186 }
187 }
188 }
189
190 if ($method_split[0] == "MarkAllReadGR") {
191 catchup_feed($this->link, $method_split[1], false);
192 }
193
194 // FIXME: might break tag display?
195
196 if (is_numeric($feed) && $feed > 0 && !$cat_view) {
197 $result = db_query($this->link,
198 "SELECT id FROM ttrss_feeds WHERE id = '$feed' LIMIT 1");
199
200 if (db_num_rows($result) == 0) {
201 $reply['content'] = "<div align='center'>".__('Feed not found.')."</div>";
202 }
203 }
204
3972bf59 205 @$search = db_escape_string($this->link, $_REQUEST["query"]);
6afcbcd1
AD		 206
207 if ($search) {
208 $disable_cache = true;
209 }
210
3972bf59 211 @$search_mode = db_escape_string($this->link, $_REQUEST["search_mode"]);
6afcbcd1
AD		 212
213 if ($_REQUEST["debug"]) $timing_info = print_checkpoint("H0", $timing_info);
214
215// error_log("format_headlines_list: [" . $feed . "] method [" . $method . "]");
216 if( $search_mode == '' && $method != '' ){
217 $search_mode = $method;
218 }
219// error_log("search_mode: " . $search_mode);
220 $qfh_ret = queryFeedHeadlines($this->link, $feed, $limit, $view_mode, $cat_view,
ca5d9be4 221 $search, $search_mode, $override_order, $offset, 0,
6afcbcd1
AD		 222 false, 0, $include_children);
223
224 if ($_REQUEST["debug"]) $timing_info = print_checkpoint("H1", $timing_info);
225
226 $result = $qfh_ret[0];
227 $feed_title = $qfh_ret[1];
228 $feed_site_url = $qfh_ret[2];
229 $last_error = $qfh_ret[3];
6afcbcd1
AD		 230
231 $vgroup_last_feed = $vgr_last_feed;
232
233 $reply['toolbar'] = $this->format_headline_subtoolbar($feed_site_url,
234 $feed_title,
ca5d9be4 235 $feed, $cat_view, $search, $search_mode, $view_mode,
6afcbcd1
AD		 236 $last_error);
237
238 $headlines_count = db_num_rows($result);
239
240 /* if (get_pref($this->link, 'COMBINED_DISPLAY_MODE')) {
241 $button_plugins = array();
242 foreach (explode(",", ARTICLE_BUTTON_PLUGINS) as $p) {
243 $pclass = "button_" . trim($p);
244
245 if (class_exists($pclass)) {
246 $plugin = new $pclass($link);
247 array_push($button_plugins, $plugin);
248 }
249 }
250 } */
251
252 global $pluginhost;
253
254 if (db_num_rows($result) > 0) {
255
256 $lnum = $offset;
257
258 $num_unread = 0;
259 $cur_feed_title = '';
260
261 $fresh_intl = get_pref($this->link, "FRESH_ARTICLE_MAX_AGE") * 60 * 60;
262
263 if ($_REQUEST["debug"]) $timing_info = print_checkpoint("PS", $timing_info);
264
f0540b59
AD		 265 $expand_cdm = get_pref($this->link, 'CDM_EXPANDED');
266
6afcbcd1
AD		 267 while ($line = db_fetch_assoc($result)) {
268 $class = ($lnum % 2) ? "even" : "odd";
269
270 $id = $line["id"];
271 $feed_id = $line["feed_id"];
272 $label_cache = $line["label_cache"];
273 $labels = false;
274 $label_row_style = "";
275
276 if ($label_cache) {
277 $label_cache = json_decode($label_cache, true);
278
279 if ($label_cache) {
280 if ($label_cache["no-labels"] == 1)
281 $labels = array();
282 else
283 $labels = $label_cache;
284 }
285 }
286
287 if (!is_array($labels)) $labels = get_article_labels($this->link, $id);
288
289 if (count($labels) > 0) {
290 for ($i = 0; $i < min(4, count($labels)); $i++) {
291 $bg = rgb2hsl(_color_unpack($labels[$i][3]));
292
293 if ($bg && $bg[1] > 0) {
294 $bg[1] = 0.1;
295 $bg[2] = 1;
296
297 $bg = _color_pack(hsl2rgb($bg));
298 $label_row_style = $this->make_gradient($bg, $class);;
299
300 break;
301 }
302 }
303 }
304
305 $labels_str = "<span id=\"HLLCTR-$id\">";
306 $labels_str .= format_article_labels($labels, $id);
307 $labels_str .= "</span>";
308
309 if (count($topmost_article_ids) < 3) {
310 array_push($topmost_article_ids, $id);
311 }
312
313 if ($line["unread"] == "t" || $line["unread"] == "1") {
314 $class .= " Unread";
315 ++$num_unread;
316 $is_unread = true;
317 } else {
318 $is_unread = false;
319 }
320
321 if ($line["marked"] == "t" || $line["marked"] == "1") {
322 $marked_pic = "<img id=\"FMPIC-$id\"
2a3b6de0 323 src=\"images/mark_set.svg\"
6afcbcd1
AD		 324 class=\"markedPic\" alt=\"Unstar article\"
325 onclick='javascript:toggleMark($id)'>";
326 } else {
327 $marked_pic = "<img id=\"FMPIC-$id\"
2a3b6de0 328 src=\"images/mark_unset.svg\"
6afcbcd1
AD		 329 class=\"markedPic\" alt=\"Star article\"
330 onclick='javascript:toggleMark($id)'>";
331 }
332
333 if ($line["published"] == "t" || $line["published"] == "1") {
2a3b6de0 334 $published_pic = "<img id=\"FPPIC-$id\" src=\"images/pub_set.svg\"
6afcbcd1
AD		 335 class=\"markedPic\"
336 alt=\"Unpublish article\" onclick='javascript:togglePub($id)'>";
337 } else {
2a3b6de0 338 $published_pic = "<img id=\"FPPIC-$id\" src=\"images/pub_unset.svg\"
6afcbcd1
AD		 339 class=\"markedPic\"
340 alt=\"Publish article\" onclick='javascript:togglePub($id)'>";
341 }
342
343# $content_link = "<a target=\"_blank\" href=\"".$line["link"]."\">" .
344# $line["title"] . "</a>";
345
346# $content_link = "<a
347# href=\"" . htmlspecialchars($line["link"]) . "\"
348# onclick=\"view($id,$feed_id);\">" .
349# $line["title"] . "</a>";
350
351# $content_link = "<a href=\"javascript:viewContentUrl('".$line["link"]."');\">" .
352# $line["title"] . "</a>";
353
354 $updated_fmt = make_local_datetime($this->link, $line["updated_noms"], false);
355
356 if (get_pref($this->link, 'SHOW_CONTENT_PREVIEW')) {
357 $content_preview = truncate_string(strip_tags($line["content_preview"]),
358 100);
359 }
360
361 $score = $line["score"];
362
2a3b6de0 363 $score_pic = "images/" . get_score_pic($score);
6afcbcd1
AD		 364
365/* $score_title = __("(Click to change)");
366 $score_pic = "<img class='hlScorePic' src=\"images/$score_pic\"
367 onclick=\"adjustArticleScore($id, $score)\" title=\"$score $score_title\">"; */
368
369 $score_pic = "<img class='hlScorePic' score='$score' onclick='changeScore($id, this)' src=\"$score_pic\"
370 title=\"$score\">";
371
372 if ($score > 500) {
373 $hlc_suffix = "H";
374 } else if ($score < -100) {
375 $hlc_suffix = "L";
376 } else {
377 $hlc_suffix = "";
378 }
379
380 $entry_author = $line["author"];
381
382 if ($entry_author) {
383 $entry_author = " - $entry_author";
384 }
385
386 $has_feed_icon = feed_has_icon($feed_id);
387
388 if ($has_feed_icon) {
389 $feed_icon_img = "<img class=\"tinyFeedIcon\" src=\"".ICONS_URL."/$feed_id.ico\" alt=\"\">";
390 } else {
391 $feed_icon_img = "<img class=\"tinyFeedIcon\" src=\"images/pub_set.svg\" alt=\"\">";
392 }
393
08dfc223
AD		 394 $entry_site_url = $line["site_url"];
395
6afcbcd1
AD		 396 if (!get_pref($this->link, 'COMBINED_DISPLAY_MODE')) {
397
398 if (get_pref($this->link, 'VFEED_GROUP_BY_FEED')) {
399 if ($feed_id != $vgroup_last_feed && $line["feed_title"]) {
400
401 $cur_feed_title = $line["feed_title"];
402 $vgroup_last_feed = $feed_id;
403
404 $cur_feed_title = htmlspecialchars($cur_feed_title);
405
36b4cf2f 406 $vf_catchup_link = "(<a class='catchup' onclick='catchupFeedInGroup($feed_id);' href='#'>".__('Mark as read')."</a>)";
6afcbcd1
AD		 407
408 $reply['content'] .= "<div class='cdmFeedTitle'>".
409 "<div style=\"float : right\">$feed_icon_img</div>".
36b4cf2f 410 "<a class='title' href=\"#\" onclick=\"viewfeed($feed_id)\">".
6afcbcd1
AD		 411 $line["feed_title"]."</a> $vf_catchup_link</div>";
412
413 }
414 }
415
416 $mouseover_attrs = "onmouseover='postMouseIn($id)'
417 onmouseout='postMouseOut($id)'";
418
419 $reply['content'] .= "<div class='$class' id='RROW-$id' $label_row_style $mouseover_attrs>";
420
421 $reply['content'] .= "<div class='hlLeft'>";
422
524de8dc
AD		 423 $reply['content'] .= "<input dojoType=\"dijit.form.CheckBox\"
424 type=\"checkbox\" onclick=\"toggleSelectRow2(this)\"
6afcbcd1
AD		 425 id=\"RCHK-$id\">";
426
427 $reply['content'] .= "$marked_pic";
428 $reply['content'] .= "$published_pic";
429
430 $reply['content'] .= "</div>";
431
432 $reply['content'] .= "<div onclick='return hlClicked(event, $id)'
433 class=\"hlTitle\"><span class='hlContent$hlc_suffix'>";
434 $reply['content'] .= "<a id=\"RTITLE-$id\"
435 href=\"" . htmlspecialchars($line["link"]) . "\"
436 onclick=\"\">" .
437 truncate_string($line["title"], 200);
438
439 if (get_pref($this->link, 'SHOW_CONTENT_PREVIEW')) {
440 if ($content_preview) {
441 $reply['content'] .= "<span class=\"contentPreview\"> - $content_preview</span>";
442 }
443 }
444
445 $reply['content'] .= "</a></span>";
446
447 $reply['content'] .= $labels_str;
448
e17e99fb
AD		 449 $reply['content'] .= "</div>";
450
451 $reply['content'] .= "<span class=\"hlUpdated\">";
452
b830cca7
J		 453 if (!get_pref($this->link, 'VFEED_GROUP_BY_FEED')) {
454 if (@$line["feed_title"]) {
cf2f643e 455 $reply['content'] .= "<div class=\"hlFeed\">
e17e99fb 456 <a href=\"#\" onclick=\"viewfeed($feed_id)\">".
cf2f643e
AD		 457 $line["feed_title"]."</a>
458 </div>";
6afcbcd1 459 }
b830cca7 460 }
6afcbcd1 461
e17e99fb 462 $reply['content'] .= "$updated_fmt</span>";
6afcbcd1
AD		 463 $reply['content'] .= "<div class=\"hlRight\">";
464
465 $reply['content'] .= $score_pic;
466
467 if ($line["feed_title"] && !get_pref($this->link, 'VFEED_GROUP_BY_FEED')) {
468
469 $reply['content'] .= "<span onclick=\"viewfeed($feed_id)\"
470 style=\"cursor : pointer\"
471 title=\"".htmlspecialchars($line['feed_title'])."\">
472 $feed_icon_img<span>";
473 }
474
475 $reply['content'] .= "</div>";
476 $reply['content'] .= "</div>";
477
478 } else {
479
84d952f1
AD		 480 $line["tags"] = get_article_tags($this->link, $id, $_SESSION["uid"], $line["tag_cache"]);
481 unset($line["tag_cache"]);
482
483 $line["content"] = sanitize($this->link, $line["content_preview"],
bfd61d3f 484 sql_bool_to_bool($line['hide_images']), false, $entry_site_url);
84d952f1
AD		 485
486 foreach ($pluginhost->get_hooks($pluginhost::HOOK_RENDER_ARTICLE_CDM) as $p) {
487 $line = $p->hook_render_article_cdm($line);
488 }
489
6afcbcd1
AD		 490 if (get_pref($this->link, 'VFEED_GROUP_BY_FEED') && $line["feed_title"]) {
491 if ($feed_id != $vgroup_last_feed) {
492
493 $cur_feed_title = $line["feed_title"];
494 $vgroup_last_feed = $feed_id;
495
496 $cur_feed_title = htmlspecialchars($cur_feed_title);
497
36b4cf2f 498 $vf_catchup_link = "(<a class='catchup' onclick='javascript:catchupFeedInGroup($feed_id);' href='#'>".__('mark as read')."</a>)";
6afcbcd1
AD		 499
500 $has_feed_icon = feed_has_icon($feed_id);
501
502 if ($has_feed_icon) {
503 $feed_icon_img = "<img class=\"tinyFeedIcon\" src=\"".ICONS_URL."/$feed_id.ico\" alt=\"\">";
504 } else {
505 //$feed_icon_img = "<img class=\"tinyFeedIcon\" src=\"images/blank_icon.gif\" alt=\"\">";
506 }
507
508 $reply['content'] .= "<div class='cdmFeedTitle'>".
509 "<div style=\"float : right\">$feed_icon_img</div>".
36b4cf2f 510 "<a href=\"#\" class='title' onclick=\"viewfeed($feed_id)\">".
6afcbcd1
AD		 511 $line["feed_title"]."</a> $vf_catchup_link</div>";
512 }
513 }
514
6afcbcd1
AD		 515 $mouseover_attrs = "onmouseover='postMouseIn($id)'
516 onmouseout='postMouseOut($id)'";
517
3ac153f1
AD		 518 $expanded_class = $expand_cdm ? "expanded" : "";
519
520 $reply['content'] .= "<div class=\"cdm $expanded_class $class\"
6afcbcd1
AD		 521 id=\"RROW-$id\" $mouseover_attrs'>";
522
523 $reply['content'] .= "<div class=\"cdmHeader\">";
524
bdb7d62e 525 $reply['content'] .= "<div style=\"vertical-align : middle\">";
6afcbcd1 526
524de8dc
AD		 527 $reply['content'] .= "<input dojoType=\"dijit.form.CheckBox\"
528 type=\"checkbox\" onclick=\"toggleSelectRow2(this, false, true)\"
6afcbcd1
AD		 529 id=\"RCHK-$id\">";
530
531 $reply['content'] .= "$marked_pic";
532 $reply['content'] .= "$published_pic";
533
534 $reply['content'] .= "</div>";
535
536 $reply['content'] .= "<div id=\"PTITLE-FULL-$id\" style=\"display : none\">" .
537 htmlspecialchars(strip_tags($line['title'])) . "</div>";
538
539 $reply['content'] .= "<span id=\"RTITLE-$id\"
540 onclick=\"return cdmClicked(event, $id);\"
541 class=\"titleWrap$hlc_suffix\">
542 <a class=\"title\"
543 title=\"".htmlspecialchars($line['title'])."\"
544 target=\"_blank\" href=\"".
545 htmlspecialchars($line["link"])."\">".
546 $line["title"] .
82d69730 547 " <span class=\"author\">$entry_author</span></a>";
6afcbcd1
AD		 548
549 $reply['content'] .= $labels_str;
550
414191d4
AD		 551 $reply['content'] .= "<span class='collapseBtn' style='display : none'>
552 <img src=\"images/collapse.png\" onclick=\"cdmCollapseArticle(event, $id)\"
553 title=\"".__("Collapse article")."\"/></span>";
554
6afcbcd1
AD		 555 if (!$expand_cdm)
556 $content_hidden = "style=\"display : none\"";
557 else
558 $excerpt_hidden = "style=\"display : none\"";
559
560 $reply['content'] .= "<span $excerpt_hidden
561 id=\"CEXC-$id\" class=\"cdmExcerpt\"> - $content_preview</span>";
6afcbcd1
AD		 562 $reply['content'] .= "</span>";
563
d56ec700
AD		 564 if (!get_pref($this->link, 'VFEED_GROUP_BY_FEED')) {
565 if (@$line["feed_title"]) {
566 $reply['content'] .= "<div class=\"hlFeed\">
567 <a href=\"#\" onclick=\"viewfeed($feed_id)\">".
568 $line["feed_title"]."</a>
569 </div>";
570 }
571 }
572
6afcbcd1 573 $reply['content'] .= "<span class='updated'>$updated_fmt</span>";
e17e99fb
AD		 574
575 $reply['content'] .= "<div style=\"vertical-align : middle\">";
6afcbcd1
AD		 576 $reply['content'] .= "$score_pic";
577
578 if (!get_pref($this->link, "VFEED_GROUP_BY_FEED") && $line["feed_title"]) {
579 $reply['content'] .= "<span style=\"cursor : pointer\"
580 title=\"".htmlspecialchars($line["feed_title"])."\"
581 onclick=\"viewfeed($feed_id)\">$feed_icon_img</span>";
582 }
583 $reply['content'] .= "</div>";
584
585 $reply['content'] .= "</div>";
586
587 $reply['content'] .= "<div class=\"cdmContent\" $content_hidden
588 onclick=\"return cdmClicked(event, $id);\"
589 id=\"CICD-$id\">";
590
b999f4c7
AD		 591 $reply['content'] .= "<div id=\"POSTNOTE-$id\">";
592 if ($line['note']) {
593 $reply['content'] .= format_article_note($id, $line['note']);
594 }
595 $reply['content'] .= "</div>";
596
597
6afcbcd1
AD		 598 $reply['content'] .= "<div class=\"cdmContentInner\">";
599
600 if ($line["orig_feed_id"]) {
601
602 $tmp_result = db_query($this->link, "SELECT * FROM ttrss_archived_feeds
603 WHERE id = ".$line["orig_feed_id"]);
604
605 if (db_num_rows($tmp_result) != 0) {
606
607 $reply['content'] .= "<div clear='both'>";
608 $reply['content'] .= __("Originally from:");
609
610 $reply['content'] .= "&nbsp;";
611
612 $tmp_line = db_fetch_assoc($tmp_result);
613
614 $reply['content'] .= "<a target='_blank'
615 href=' " . htmlspecialchars($tmp_line['site_url']) . "'>" .
616 $tmp_line['title'] . "</a>";
617
618 $reply['content'] .= "&nbsp;";
619
620 $reply['content'] .= "<a target='_blank' href='" . htmlspecialchars($tmp_line['feed_url']) . "'>";
621 $reply['content'] .= "<img title='".__('Feed URL')."'class='tinyFeedIcon' src='images/pub_unset.svg'></a>";
622
623 $reply['content'] .= "</div>";
624 }
625 }
626
6afcbcd1 627 $reply['content'] .= "<span id=\"CWRAP-$id\">";
6afcbcd1 628
b74c5134
AD		 629// if (!$expand_cdm) {
630 $reply['content'] .= "<span id=\"CENCW-$id\" style=\"display : none\">";
f0540b59
AD		 631 $reply['content'] .= htmlspecialchars($line["content"]);
632 $reply['content'] .= "</span.";
633
b74c5134
AD		 634// } else {
635// $reply['content'] .= $line["content"];
636// }
6afcbcd1 637
f0540b59 638 $reply['content'] .= "</span>";
6afcbcd1
AD		 639
640 $always_display_enclosures = sql_bool_to_bool($line["always_display_enclosures"]);
641
33de3d37 642 $reply['content'] .= format_article_enclosures($this->link, $id, $always_display_enclosures, $line["content"], sql_bool_to_bool($line["hide_images"]));
6afcbcd1
AD		 643
644 $reply['content'] .= "</div>";
645
646 $reply['content'] .= "<div class=\"cdmFooter\">";
647
42ecc25b 648 $tags_str = format_tags_string($line["tags"], $id);
6afcbcd1 649
2a3b6de0 650 $reply['content'] .= "<img src='images/tag.png' alt='Tags' title='Tags'>
6afcbcd1
AD		 651 <span id=\"ATSTR-$id\">$tags_str</span>
652 <a title=\"".__('Edit tags for this article')."\"
653 href=\"#\" onclick=\"editArticleTags($id, $feed_id, true)\">(+)</a>";
654
655 $num_comments = $line["num_comments"];
656 $entry_comments = "";
657
658 if ($num_comments > 0) {
659 if ($line["comments"]) {
660 $comments_url = htmlspecialchars($line["comments"]);
661 } else {
662 $comments_url = htmlspecialchars($line["link"]);
663 }
664 $entry_comments = "<a target='_blank' href=\"$comments_url\">$num_comments comments</a>";
665 } else {
666 if ($line["comments"] && $line["link"] != $line["comments"]) {
667 $entry_comments = "<a target='_blank' href=\"".htmlspecialchars($line["comments"])."\">comments</a>";
668 }
669 }
670
671 if ($entry_comments) $reply['content'] .= "&nbsp;($entry_comments)";
672
673 $reply['content'] .= "<div style=\"float : right\">";
674
675 foreach ($pluginhost->get_hooks($pluginhost::HOOK_ARTICLE_BUTTON) as $p) {
676 $reply['content'] .= $p->hook_article_button($line);
677 }
678
679 $reply['content'] .= "</div>";
680 $reply['content'] .= "</div>";
681
682 $reply['content'] .= "</div>";
683
684 $reply['content'] .= "</div>";
685
686 }
687
688 ++$lnum;
689 }
690
691 if ($_REQUEST["debug"]) $timing_info = print_checkpoint("PE", $timing_info);
692
693 } else {
694 $message = "";
695
696 switch ($view_mode) {
697 case "unread":
698 $message = __("No unread articles found to display.");
699 break;
700 case "updated":
701 $message = __("No updated articles found to display.");
702 break;
703 case "marked":
704 $message = __("No starred articles found to display.");
705 break;
706 default:
707 if ($feed < -10) {
708 $message = __("No articles found to display. You can assign articles to labels manually (see the Actions menu above) or use a filter.");
709 } else {
710 $message = __("No articles found to display.");
711 }
712 }
713
714 if (!$offset && $message) {
715 $reply['content'] .= "<div class='whiteBox'>$message";
716
717 $reply['content'] .= "<p class=\"small\"><span class=\"insensitive\">";
718
719 $result = db_query($this->link, "SELECT ".SUBSTRING_FOR_DATE."(MAX(last_updated), 1, 19) AS last_updated FROM ttrss_feeds
720 WHERE owner_uid = " . $_SESSION['uid']);
721
722 $last_updated = db_fetch_result($result, 0, "last_updated");
723 $last_updated = make_local_datetime($this->link, $last_updated, false);
724
725 $reply['content'] .= sprintf(__("Feeds last updated at %s"), $last_updated);
726
727 $result = db_query($this->link, "SELECT COUNT(id) AS num_errors
728 FROM ttrss_feeds WHERE last_error != '' AND owner_uid = ".$_SESSION["uid"]);
729
730 $num_errors = db_fetch_result($result, 0, "num_errors");
731
732 if ($num_errors > 0) {
733 $reply['content'] .= "<br/>";
734 $reply['content'] .= "<a class=\"insensitive\" href=\"#\" onclick=\"showFeedsWithErrors()\">".
735 __('Some feeds have update errors (click for details)')."</a>";
736 }
737 $reply['content'] .= "</span></p></div>";
738 }
739 }
740
741 if ($_REQUEST["debug"]) $timing_info = print_checkpoint("H2", $timing_info);
742
743 return array($topmost_article_ids, $headlines_count, $feed, $disable_cache,
744 $vgroup_last_feed, $reply);
745 }
746
747 function catchupAll() {
748 db_query($this->link, "UPDATE ttrss_user_entries SET
1bad74ea 749 last_read = NOW(), unread = false WHERE unread = true AND owner_uid = " . $_SESSION["uid"]);
6afcbcd1
AD		 750 ccache_zero_all($this->link, $_SESSION["uid"]);
751 }
752
6afcbcd1 753 function view() {
fa9e88c3 754 $timing_info = microtime(true);
6afcbcd1
AD		 755
756 $reply = array();
757
758 if ($_REQUEST["debug"]) $timing_info = print_checkpoint("0", $timing_info);
759
3972bf59 760 $omode = db_escape_string($this->link, $_REQUEST["omode"]);
6afcbcd1 761
3972bf59
AD		 762 $feed = db_escape_string($this->link, $_REQUEST["feed"]);
763 $method = db_escape_string($this->link, $_REQUEST["m"]);
764 $view_mode = db_escape_string($this->link, $_REQUEST["view_mode"]);
6afcbcd1
AD		 765 $limit = (int) get_pref($this->link, "DEFAULT_ARTICLE_LIMIT");
766 @$cat_view = $_REQUEST["cat"] == "true";
3972bf59
AD		 767 @$next_unread_feed = db_escape_string($this->link, $_REQUEST["nuf"]);
768 @$offset = db_escape_string($this->link, $_REQUEST["skip"]);
769 @$vgroup_last_feed = db_escape_string($this->link, $_REQUEST["vgrlf"]);
770 $order_by = db_escape_string($this->link, $_REQUEST["order_by"]);
6afcbcd1
AD		 771
772 if (is_numeric($feed)) $feed = (int) $feed;
773
774 /* Feed -5 is a special case: it is used to display auxiliary information
775 * when there's nothing to load - e.g. no stuff in fresh feed */
776
777 if ($feed == -5) {
778 print json_encode($this->generate_dashboard_feed($this->link));
779 return;
780 }
781
782 $result = false;
783
784 if ($feed < -10) {
785 $label_feed = -11-$feed;
786 $result = db_query($this->link, "SELECT id FROM ttrss_labels2 WHERE
787 id = '$label_feed' AND owner_uid = " . $_SESSION['uid']);
788 } else if (!$cat_view && is_numeric($feed) && $feed > 0) {
789 $result = db_query($this->link, "SELECT id FROM ttrss_feeds WHERE
790 id = '$feed' AND owner_uid = " . $_SESSION['uid']);
791 } else if ($cat_view && is_numeric($feed) && $feed > 0) {
792 $result = db_query($this->link, "SELECT id FROM ttrss_feed_categories WHERE
793 id = '$feed' AND owner_uid = " . $_SESSION['uid']);
794 }
795
796 if ($result && db_num_rows($result) == 0) {
797 print json_encode($this->generate_error_feed($this->link, __("Feed not found.")));
798 return;
799 }
800
801 /* Updating a label ccache means recalculating all of the caches
802 * so for performance reasons we don't do that here */
803
804 if ($feed >= 0) {
805 ccache_update($this->link, $feed, $_SESSION["uid"], $cat_view);
806 }
807
808 set_pref($this->link, "_DEFAULT_VIEW_MODE", $view_mode);
809 set_pref($this->link, "_DEFAULT_VIEW_LIMIT", $limit);
810 set_pref($this->link, "_DEFAULT_VIEW_ORDER_BY", $order_by);
811
812 if (!$cat_view && is_numeric($feed) && $feed > 0) {
813 db_query($this->link, "UPDATE ttrss_feeds SET last_viewed = NOW()
814 WHERE id = '$feed' AND owner_uid = ".$_SESSION["uid"]);
815 }
816
817 $reply['headlines'] = array();
818
819 if (!$next_unread_feed)
820 $reply['headlines']['id'] = $feed;
821 else
822 $reply['headlines']['id'] = $next_unread_feed;
823
824 $reply['headlines']['is_cat'] = (bool) $cat_view;
825
826 $override_order = false;
827
828 if (get_pref($this->link, "SORT_HEADLINES_BY_FEED_DATE", $owner_uid)) {
829 $date_sort_field = "updated";
830 } else {
831 $date_sort_field = "date_entered";
832 }
833
834 switch ($order_by) {
835 case "date":
836 if (get_pref($this->link, 'REVERSE_HEADLINES', $owner_uid)) {
837 $override_order = "$date_sort_field";
838 } else {
839 $override_order = "$date_sort_field DESC";
840 }
841 break;
842
843 case "title":
844 if (get_pref($this->link, 'REVERSE_HEADLINES', $owner_uid)) {
845 $override_order = "title DESC, $date_sort_field";
846 } else {
847 $override_order = "title, $date_sort_field DESC";
848 }
849 break;
850
851 case "score":
852 if (get_pref($this->link, 'REVERSE_HEADLINES', $owner_uid)) {
853 $override_order = "score, $date_sort_field";
854 } else {
855 $override_order = "score DESC, $date_sort_field DESC";
856 }
857 break;
858 }
859
860 if ($_REQUEST["debug"]) $timing_info = print_checkpoint("04", $timing_info);
861
862 $ret = $this->format_headlines_list($feed, $method,
863 $view_mode, $limit, $cat_view, $next_unread_feed, $offset,
864 $vgroup_last_feed, $override_order, true);
865
b389aeb7 866 //$topmost_article_ids = $ret[0];
6afcbcd1
AD		 867 $headlines_count = $ret[1];
868 $returned_feed = $ret[2];
869 $disable_cache = $ret[3];
870 $vgroup_last_feed = $ret[4];
871
872 $reply['headlines']['content'] =& $ret[5]['content'];
873 $reply['headlines']['toolbar'] =& $ret[5]['toolbar'];
874
875 if ($_REQUEST["debug"]) $timing_info = print_checkpoint("05", $timing_info);
876
877 $reply['headlines-info'] = array("count" => (int) $headlines_count,
878 "vgroup_last_feed" => $vgroup_last_feed,
879 "disable_cache" => (bool) $disable_cache);
880
6afcbcd1
AD		 881 if ($_REQUEST["debug"]) $timing_info = print_checkpoint("30", $timing_info);
882
883 $reply['runtime-info'] = make_runtime_info($this->link);
884
885 print json_encode($reply);
886
887 }
888
889 private function generate_dashboard_feed($link) {
890 $reply = array();
891
892 $reply['headlines']['id'] = -5;
893 $reply['headlines']['is_cat'] = false;
894
895 $reply['headlines']['toolbar'] = '';
896 $reply['headlines']['content'] = "<div class='whiteBox'>".__('No feed selected.');
897
898 $reply['headlines']['content'] .= "<p class=\"small\"><span class=\"insensitive\">";
899
900 $result = db_query($link, "SELECT ".SUBSTRING_FOR_DATE."(MAX(last_updated), 1, 19) AS last_updated FROM ttrss_feeds
901 WHERE owner_uid = " . $_SESSION['uid']);
902
903 $last_updated = db_fetch_result($result, 0, "last_updated");
904 $last_updated = make_local_datetime($link, $last_updated, false);
905
906 $reply['headlines']['content'] .= sprintf(__("Feeds last updated at %s"), $last_updated);
907
908 $result = db_query($link, "SELECT COUNT(id) AS num_errors
909 FROM ttrss_feeds WHERE last_error != '' AND owner_uid = ".$_SESSION["uid"]);
910
911 $num_errors = db_fetch_result($result, 0, "num_errors");
912
913 if ($num_errors > 0) {
914 $reply['headlines']['content'] .= "<br/>";
915 $reply['headlines']['content'] .= "<a class=\"insensitive\" href=\"#\" onclick=\"showFeedsWithErrors()\">".
916 __('Some feeds have update errors (click for details)')."</a>";
917 }
918 $reply['headlines']['content'] .= "</span></p>";
919
920 $reply['headlines-info'] = array("count" => 0,
921 "vgroup_last_feed" => '',
922 "unread" => 0,
923 "disable_cache" => true);
924
925 return $reply;
926 }
927
928 private function generate_error_feed($link, $error) {
929 $reply = array();
930
931 $reply['headlines']['id'] = -6;
932 $reply['headlines']['is_cat'] = false;
933
934 $reply['headlines']['toolbar'] = '';
935 $reply['headlines']['content'] = "<div class='whiteBox'>". $error . "</div>";
936
937 $reply['headlines-info'] = array("count" => 0,
938 "vgroup_last_feed" => '',
939 "unread" => 0,
940 "disable_cache" => true);
941
942 return $reply;
943 }
944
6afcbcd1
AD		 945}
946?>
web-based news feed (RSS/Atom) reader and aggregator; see https://tt-rss.org/