]> git.wh0rd.org - tt-rss.git/blob - classes/feeds.php
format_article_tags: improve performance
[tt-rss.git] / classes / feeds.php
1 <?php
2 require_once "colors.php";
3
4 class Feeds extends Handler_Protected {
5
6 function csrf_ignore($method) {
7 $csrf_ignored = array("index", "feedbrowser", "quickaddfeed", "search");
8
9 return array_search($method, $csrf_ignored) !== false;
10 }
11
12 private function format_headline_subtoolbar($feed_site_url, $feed_title,
13 $feed_id, $is_cat, $search,
14 $search_mode, $view_mode, $error, $feed_last_updated) {
15
16 $page_prev_link = "viewFeedGoPage(-1)";
17 $page_next_link = "viewFeedGoPage(1)";
18 $page_first_link = "viewFeedGoPage(0)";
19
20 $catchup_page_link = "catchupPage()";
21 $catchup_feed_link = "catchupCurrentFeed()";
22 $catchup_sel_link = "catchupSelection()";
23
24 $archive_sel_link = "archiveSelection()";
25 $delete_sel_link = "deleteSelection()";
26
27 $sel_all_link = "selectArticles('all')";
28 $sel_unread_link = "selectArticles('unread')";
29 $sel_none_link = "selectArticles('none')";
30 $sel_inv_link = "selectArticles('invert')";
31
32 $tog_unread_link = "selectionToggleUnread()";
33 $tog_marked_link = "selectionToggleMarked()";
34 $tog_published_link = "selectionTogglePublished()";
35
36 $set_score_link = "setSelectionScore()";
37
38 if ($is_cat) $cat_q = "&is_cat=$is_cat";
39
40 if ($search) {
41 $search_q = "&q=$search&smode=$search_mode";
42 } else {
43 $search_q = "";
44 }
45
46 $rss_link = htmlspecialchars(get_self_url_prefix() .
47 "/public.php?op=rss&id=$feed_id$cat_q$search_q");
48
49 // right part
50
51 $reply .= "<span class='r'>";
52 $reply .= "<span id='selected_prompt'></span>";
53 $reply .= "<span id='feed_title'>";
54
55 if ($feed_site_url) {
56 $last_updated = T_sprintf("Last updated: %s",
57 $feed_last_updated);
58
59 $target = "target=\"_blank\"";
60 $reply .= "<a title=\"$last_updated\" $target href=\"$feed_site_url\">".
61 truncate_string($feed_title,30)."</a>";
62
63 if ($error) {
64 $reply .= " (<span class=\"error\" title=\"$error\">Error</span>)";
65 }
66
67 } else {
68 $reply .= $feed_title;
69 }
70
71 $reply .= "</span>";
72
73 $reply .= "
74 <a href=\"#\"
75 title=\"".__("View as RSS feed")."\"
76 onclick=\"displayDlg('".__("View as RSS")."','generatedFeed', '$feed_id:$is_cat:$rss_link')\">
77 <img class=\"noborder\" style=\"vertical-align : middle\" src=\"images/pub_set.svg\"></a>";
78
79 $reply .= "</span>";
80
81 // left part
82
83 $reply .= __('Select:')."
84 <a href=\"#\" onclick=\"$sel_all_link\">".__('All')."</a>,
85 <a href=\"#\" onclick=\"$sel_unread_link\">".__('Unread')."</a>,
86 <a href=\"#\" onclick=\"$sel_inv_link\">".__('Invert')."</a>,
87 <a href=\"#\" onclick=\"$sel_none_link\">".__('None')."</a></li>";
88
89 $reply .= " ";
90
91 $reply .= "<select dojoType=\"dijit.form.Select\"
92 onchange=\"headlineActionsChange(this)\">";
93 $reply .= "<option value=\"false\">".__('More...')."</option>";
94
95 $reply .= "<option value=\"0\" disabled=\"1\">".__('Selection toggle:')."</option>";
96
97 $reply .= "<option value=\"$tog_unread_link\">".__('Unread')."</option>
98 <option value=\"$tog_marked_link\">".__('Starred')."</option>
99 <option value=\"$tog_published_link\">".__('Published')."</option>";
100
101 $reply .= "<option value=\"0\" disabled=\"1\">".__('Selection:')."</option>";
102
103 $reply .= "<option value=\"$catchup_sel_link\">".__('Mark as read')."</option>";
104 $reply .= "<option value=\"$set_score_link\">".__('Set score')."</option>";
105
106 if ($feed_id != "0") {
107 $reply .= "<option value=\"$archive_sel_link\">".__('Archive')."</option>";
108 } else {
109 $reply .= "<option value=\"$archive_sel_link\">".__('Move back')."</option>";
110 $reply .= "<option value=\"$delete_sel_link\">".__('Delete')."</option>";
111
112 }
113
114 if (PluginHost::getInstance()->get_plugin("mail")) {
115 $reply .= "<option value=\"emailArticle(false)\">".__('Forward by email').
116 "</option>";
117 }
118
119 if (PluginHost::getInstance()->get_plugin("mailto")) {
120 $reply .= "<option value=\"mailtoArticle(false)\">".__('Forward by email').
121 "</option>";
122 }
123
124 $reply .= "<option value=\"0\" disabled=\"1\">".__('Feed:')."</option>";
125
126 //$reply .= "<option value=\"catchupPage()\">".__('Mark as read')."</option>";
127
128 $reply .= "<option value=\"displayDlg('".__("View as RSS")."','generatedFeed', '$feed_id:$is_cat:$rss_link')\">".__('View as RSS')."</option>";
129
130 $reply .= "</select>";
131
132 //$reply .= "</div>";
133
134 //$reply .= "</h2";
135
136 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_HEADLINE_TOOLBAR_BUTTON) as $p) {
137 echo $p->hook_headline_toolbar_button($feed_id, $is_cat);
138 }
139
140 return $reply;
141 }
142
143 private function format_headlines_list($feed, $method, $view_mode, $limit, $cat_view,
144 $next_unread_feed, $offset, $vgr_last_feed = false,
145 $override_order = false, $include_children = false) {
146
147 if (isset($_REQUEST["DevForceUpdate"]))
148 header("Content-Type: text/plain");
149
150 $disable_cache = false;
151
152 $reply = array();
153
154 $rgba_cache = array();
155
156 $timing_info = microtime(true);
157
158 $topmost_article_ids = array();
159
160 if (!$offset) $offset = 0;
161 if ($method == "undefined") $method = "";
162
163 $method_split = explode(":", $method);
164
165 if ($method == "ForceUpdate" && $feed > 0 && is_numeric($feed)) {
166 // Update the feed if required with some basic flood control
167
168 $result = $this->dbh->query(
169 "SELECT cache_images,".SUBSTRING_FOR_DATE."(last_updated,1,19) AS last_updated
170 FROM ttrss_feeds WHERE id = '$feed'");
171
172 if ($this->dbh->num_rows($result) != 0) {
173 $last_updated = strtotime($this->dbh->fetch_result($result, 0, "last_updated"));
174 $cache_images = sql_bool_to_bool($this->dbh->fetch_result($result, 0, "cache_images"));
175
176 if (!$cache_images && time() - $last_updated > 120 || isset($_REQUEST['DevForceUpdate'])) {
177 include "rssfuncs.php";
178 update_rss_feed($feed, true, true);
179 } else {
180 $this->dbh->query("UPDATE ttrss_feeds SET last_updated = '1970-01-01', last_update_started = '1970-01-01'
181 WHERE id = '$feed'");
182 }
183 }
184 }
185
186 if ($method_split[0] == "MarkAllReadGR") {
187 catchup_feed($method_split[1], false);
188 }
189
190 // FIXME: might break tag display?
191
192 if (is_numeric($feed) && $feed > 0 && !$cat_view) {
193 $result = $this->dbh->query(
194 "SELECT id FROM ttrss_feeds WHERE id = '$feed' LIMIT 1");
195
196 if ($this->dbh->num_rows($result) == 0) {
197 $reply['content'] = "<div align='center'>".__('Feed not found.')."</div>";
198 }
199 }
200
201 @$search = $this->dbh->escape_string($_REQUEST["query"]);
202
203 if ($search) {
204 $disable_cache = true;
205 }
206
207 @$search_mode = $this->dbh->escape_string($_REQUEST["search_mode"]);
208
209 if ($_REQUEST["debug"]) $timing_info = print_checkpoint("H0", $timing_info);
210
211 // error_log("format_headlines_list: [" . $feed . "] method [" . $method . "]");
212 if($search_mode == '' && $method != '' ){
213 $search_mode = $method;
214 }
215 // error_log("search_mode: " . $search_mode);
216
217 if (!$cat_view && is_numeric($feed) && $feed < PLUGIN_FEED_BASE_INDEX && $feed > LABEL_BASE_INDEX) {
218 $handler = PluginHost::getInstance()->get_feed_handler(
219 PluginHost::feed_to_pfeed_id($feed));
220
221 // function queryFeedHeadlines($feed, $limit, $view_mode, $cat_view, $search, $search_mode, $override_order = false, $offset = 0, $owner_uid = 0, $filter = false, $since_id = 0, $include_children = false, $ignore_vfeed_group = false) {
222
223 if ($handler) {
224 $options = array(
225 "limit" => $limit,
226 "view_mode" => $view_mode,
227 "cat_view" => $cat_view,
228 "search" => $search,
229 "search_mode" => $search_mode,
230 "override_order" => $override_order,
231 "offset" => $offset,
232 "owner_uid" => $_SESSION["uid"],
233 "filter" => false,
234 "since_id" => 0,
235 "include_children" => $include_children);
236
237 $qfh_ret = $handler->get_headlines(PluginHost::feed_to_pfeed_id($feed),
238 $options);
239 }
240
241 } else {
242 $qfh_ret = queryFeedHeadlines($feed, $limit, $view_mode, $cat_view,
243 $search, $search_mode, $override_order, $offset, 0,
244 false, 0, $include_children);
245 }
246
247 if ($_REQUEST["debug"]) $timing_info = print_checkpoint("H1", $timing_info);
248
249 $result = $qfh_ret[0];
250 $feed_title = $qfh_ret[1];
251 $feed_site_url = $qfh_ret[2];
252 $last_error = $qfh_ret[3];
253 $last_updated = strpos($qfh_ret[4], '1970-') === FALSE ?
254 make_local_datetime($qfh_ret[4], false) : __("Never");
255
256 $vgroup_last_feed = $vgr_last_feed;
257
258 $reply['toolbar'] = $this->format_headline_subtoolbar($feed_site_url,
259 $feed_title,
260 $feed, $cat_view, $search, $search_mode, $view_mode,
261 $last_error, $last_updated);
262
263 $headlines_count = $this->dbh->num_rows($result);
264
265 /* if (get_pref('COMBINED_DISPLAY_MODE')) {
266 $button_plugins = array();
267 foreach (explode(",", ARTICLE_BUTTON_PLUGINS) as $p) {
268 $pclass = "button_" . trim($p);
269
270 if (class_exists($pclass)) {
271 $plugin = new $pclass();
272 array_push($button_plugins, $plugin);
273 }
274 }
275 } */
276
277 if ($this->dbh->num_rows($result) > 0) {
278
279 $lnum = $offset;
280
281 $num_unread = 0;
282 $cur_feed_title = '';
283
284 $fresh_intl = get_pref("FRESH_ARTICLE_MAX_AGE") * 60 * 60;
285
286 if ($_REQUEST["debug"]) $timing_info = print_checkpoint("PS", $timing_info);
287
288 $expand_cdm = get_pref('CDM_EXPANDED');
289
290 while ($line = $this->dbh->fetch_assoc($result)) {
291 $class = ($lnum % 2) ? "even" : "odd";
292
293 $id = $line["id"];
294 $feed_id = $line["feed_id"];
295 $label_cache = $line["label_cache"];
296 $labels = false;
297
298 if ($label_cache) {
299 $label_cache = json_decode($label_cache, true);
300
301 if ($label_cache) {
302 if ($label_cache["no-labels"] == 1)
303 $labels = array();
304 else
305 $labels = $label_cache;
306 }
307 }
308
309 if (!is_array($labels)) $labels = get_article_labels($id);
310
311 $labels_str = "<span id=\"HLLCTR-$id\">";
312 $labels_str .= format_article_labels($labels, $id);
313 $labels_str .= "</span>";
314
315 if (count($topmost_article_ids) < 3) {
316 array_push($topmost_article_ids, $id);
317 }
318
319 if (sql_bool_to_bool($line["unread"])) {
320 $class .= " Unread";
321 ++$num_unread;
322 }
323
324 if (sql_bool_to_bool($line["marked"])) {
325 $marked_pic = "<img
326 src=\"images/mark_set.svg\"
327 class=\"markedPic\" alt=\"Unstar article\"
328 onclick='toggleMark($id)'>";
329 $class .= " marked";
330 } else {
331 $marked_pic = "<img
332 src=\"images/mark_unset.svg\"
333 class=\"markedPic\" alt=\"Star article\"
334 onclick='toggleMark($id)'>";
335 }
336
337 if (sql_bool_to_bool($line["published"])) {
338 $published_pic = "<img src=\"images/pub_set.svg\"
339 class=\"pubPic\"
340 alt=\"Unpublish article\" onclick='togglePub($id)'>";
341 $class .= " published";
342 } else {
343 $published_pic = "<img src=\"images/pub_unset.svg\"
344 class=\"pubPic\"
345 alt=\"Publish article\" onclick='togglePub($id)'>";
346 }
347
348 # $content_link = "<a target=\"_blank\" href=\"".$line["link"]."\">" .
349 # $line["title"] . "</a>";
350
351 # $content_link = "<a
352 # href=\"" . htmlspecialchars($line["link"]) . "\"
353 # onclick=\"view($id,$feed_id);\">" .
354 # $line["title"] . "</a>";
355
356 # $content_link = "<a href=\"javascript:viewContentUrl('".$line["link"]."');\">" .
357 # $line["title"] . "</a>";
358
359 $updated_fmt = make_local_datetime($line["updated"], false);
360 $date_entered_fmt = T_sprintf("Imported at %s",
361 make_local_datetime($line["date_entered"], false));
362
363 if (get_pref('SHOW_CONTENT_PREVIEW')) {
364 $content_preview = truncate_string(strip_tags($line["content_preview"]),
365 250);
366 }
367
368 $score = $line["score"];
369
370 $score_pic = "images/" . get_score_pic($score);
371
372 /* $score_title = __("(Click to change)");
373 $score_pic = "<img class='hlScorePic' src=\"images/$score_pic\"
374 onclick=\"adjustArticleScore($id, $score)\" title=\"$score $score_title\">"; */
375
376 $score_pic = "<img class='hlScorePic' score='$score' onclick='changeScore($id, this)' src=\"$score_pic\"
377 title=\"$score\">";
378
379 if ($score > 500) {
380 $hlc_suffix = "H";
381 } else if ($score < -100) {
382 $hlc_suffix = "L";
383 } else {
384 $hlc_suffix = "";
385 }
386
387 $entry_author = $line["author"];
388
389 if ($entry_author) {
390 $entry_author = " &mdash; $entry_author";
391 }
392
393 $has_feed_icon = feed_has_icon($feed_id);
394
395 if ($has_feed_icon) {
396 $feed_icon_img = "<img class=\"tinyFeedIcon\" src=\"".ICONS_URL."/$feed_id.ico\" alt=\"\">";
397 } else {
398 $feed_icon_img = "<img class=\"tinyFeedIcon\" src=\"images/pub_set.svg\" alt=\"\">";
399 }
400
401 $entry_site_url = $line["site_url"];
402
403 //setting feed headline background color, needs to change text color based on dark/light
404 $fav_color = $line['favicon_avg_color'];
405
406 require_once "colors.php";
407
408 if ($fav_color && $fav_color != 'fail') {
409 if (!isset($rgba_cache[$feed_id])) {
410 $rgba_cache[$feed_id] = join(",", _color_unpack($fav_color));
411 }
412
413 $rgba = $rgba_cache[$feed_id];
414
415 if (sql_bool_to_bool($line["unread"]))
416 $endalpha = '0.3';
417 else
418 $endalpha = '0.1';
419
420 // W3C definition seems to work in FF and Chrome
421 $row_background = "background-image : linear-gradient(to right, rgba(255, 255, 255, 0) 0%, rgba($rgba, $endalpha) 100%);";
422
423 /* $row_background = "background-image : -moz-linear-gradient(left, rgba(255, 255, 255, 0) 50%, rgba($rgba, 0.2) 100%);".
424 "background-image : linear-gradient(to right, rgba(255, 255, 255, 0) 50%, rgba($rgba, 0.2) 100%);";
425 "background-image : -webkit-gradient(linear, left top, right top, color-stop(50%, rgba(255,255,255,0)),
426 color-stop(100%, rgba($rgba, 0.2)));"; */
427 } else {
428 $row_background = "";
429 }
430
431 if (!get_pref('COMBINED_DISPLAY_MODE')) {
432
433 if (get_pref('VFEED_GROUP_BY_FEED')) {
434 if ($feed_id != $vgroup_last_feed && $line["feed_title"]) {
435
436 $cur_feed_title = $line["feed_title"];
437 $vgroup_last_feed = $feed_id;
438
439 $cur_feed_title = htmlspecialchars($cur_feed_title);
440
441 $vf_catchup_link = "(<a class='catchup' onclick='catchupFeedInGroup($feed_id);' href='#'>".__('Mark as read')."</a>)";
442
443 $reply['content'] .= "<div class='cdmFeedTitle'>".
444 "<div style=\"float : right\">$feed_icon_img</div>".
445 "<a class='title' href=\"#\" onclick=\"viewfeed($feed_id)\">".
446 $line["feed_title"]."</a> $vf_catchup_link</div>";
447
448 }
449 }
450
451 $mouseover_attrs = "onmouseover='postMouseIn(event, $id)'
452 onmouseout='postMouseOut($id)'";
453
454 $reply['content'] .= "<div class='hl $class' id='RROW-$id' $mouseover_attrs style='$row_background'>";
455
456 $reply['content'] .= "<div class='hlLeft'>";
457
458 $reply['content'] .= "<input dojoType=\"dijit.form.CheckBox\"
459 type=\"checkbox\" onclick=\"toggleSelectRow2(this)\"
460 class='rchk'>";
461
462 $reply['content'] .= "$marked_pic";
463 $reply['content'] .= "$published_pic";
464
465 $reply['content'] .= "</div>";
466
467 $reply['content'] .= "<div onclick='return hlClicked(event, $id)'
468 class=\"hlTitle\"><span class='hlContent$hlc_suffix'>";
469 $reply['content'] .= "<a id=\"RTITLE-$id\" class=\"title\"
470 href=\"" . htmlspecialchars($line["link"]) . "\"
471 onclick=\"\">" .
472 truncate_string($line["title"], 200);
473
474 if (get_pref('SHOW_CONTENT_PREVIEW')) {
475 if ($content_preview) {
476 $reply['content'] .= "<span class=\"contentPreview\"> - $content_preview</span>";
477 }
478 }
479
480 $reply['content'] .= "</a></span>";
481
482 $reply['content'] .= $labels_str;
483
484 $reply['content'] .= "</div>";
485
486 $reply['content'] .= "<span class=\"hlUpdated\">";
487
488 if (!get_pref('VFEED_GROUP_BY_FEED')) {
489 if (@$line["feed_title"]) {
490 $reply['content'] .= "<div class=\"hlFeed\">
491 <a href=\"#\" onclick=\"viewfeed($feed_id)\">".
492 truncate_string($line["feed_title"],30)."</a>
493 </div>";
494 }
495 }
496
497 $reply['content'] .= "<span title='$date_entered_fmt'>$updated_fmt</span>
498 </span>";
499
500 $reply['content'] .= "<div class=\"hlRight\">";
501
502 $reply['content'] .= $score_pic;
503
504 if ($line["feed_title"] && !get_pref('VFEED_GROUP_BY_FEED')) {
505
506 $reply['content'] .= "<span onclick=\"viewfeed($feed_id)\"
507 style=\"cursor : pointer\"
508 title=\"".htmlspecialchars($line['feed_title'])."\">
509 $feed_icon_img<span>";
510 }
511
512 $reply['content'] .= "</div>";
513 $reply['content'] .= "</div>";
514
515 } else {
516
517 if ($line["tag_cache"])
518 $tags = explode(",", $line["tag_cache"]);
519 else
520 $tags = false;
521
522 $line["content"] = sanitize($line["content_preview"],
523 sql_bool_to_bool($line['hide_images']), false, $entry_site_url);
524
525 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_RENDER_ARTICLE_CDM) as $p) {
526 $line = $p->hook_render_article_cdm($line);
527 }
528
529 if (get_pref('VFEED_GROUP_BY_FEED') && $line["feed_title"]) {
530 if ($feed_id != $vgroup_last_feed) {
531
532 $cur_feed_title = $line["feed_title"];
533 $vgroup_last_feed = $feed_id;
534
535 $cur_feed_title = htmlspecialchars($cur_feed_title);
536
537 $vf_catchup_link = "(<a class='catchup' onclick='javascript:catchupFeedInGroup($feed_id);' href='#'>".__('mark as read')."</a>)";
538
539 $has_feed_icon = feed_has_icon($feed_id);
540
541 if ($has_feed_icon) {
542 $feed_icon_img = "<img class=\"tinyFeedIcon\" src=\"".ICONS_URL."/$feed_id.ico\" alt=\"\">";
543 } else {
544 //$feed_icon_img = "<img class=\"tinyFeedIcon\" src=\"images/blank_icon.gif\" alt=\"\">";
545 }
546
547 $reply['content'] .= "<div class='cdmFeedTitle'>".
548 "<div style=\"float : right\">$feed_icon_img</div>".
549 "<a href=\"#\" class='title' onclick=\"viewfeed($feed_id)\">".
550 $line["feed_title"]."</a> $vf_catchup_link</div>";
551 }
552 }
553
554 $mouseover_attrs = "onmouseover='postMouseIn(event, $id)'
555 onmouseout='postMouseOut($id)'";
556
557 $expanded_class = $expand_cdm ? "expanded" : "expandable";
558
559 $reply['content'] .= "<div class=\"cdm $expanded_class $class\"
560 id=\"RROW-$id\" $mouseover_attrs>";
561
562 $reply['content'] .= "<div class=\"cdmHeader\" style=\"$row_background\">";
563 $reply['content'] .= "<div style=\"vertical-align : middle\">";
564
565 $reply['content'] .= "<input dojoType=\"dijit.form.CheckBox\"
566 type=\"checkbox\" onclick=\"toggleSelectRow2(this, false, true)\"
567 class='rchk'>";
568
569 $reply['content'] .= "$marked_pic";
570 $reply['content'] .= "$published_pic";
571
572 $reply['content'] .= "</div>";
573
574 $reply['content'] .= "<span id=\"RTITLE-$id\"
575 onclick=\"return cdmClicked(event, $id);\"
576 class=\"titleWrap$hlc_suffix\">
577 <a class=\"title\"
578 target=\"_blank\" href=\"".
579 htmlspecialchars($line["link"])."\">".
580 $line["title"] .
581 " <span class=\"author\">$entry_author</span></a>";
582
583 $reply['content'] .= $labels_str;
584
585 $reply['content'] .= "<span class='collapseBtn' style='display : none'>
586 <img src=\"images/collapse.png\" onclick=\"cdmCollapseArticle(event, $id)\"
587 title=\"".__("Collapse article")."\"/></span>";
588
589 if (!$expand_cdm)
590 $content_hidden = "style=\"display : none\"";
591 else
592 $excerpt_hidden = "style=\"display : none\"";
593
594 $reply['content'] .= "<span $excerpt_hidden
595 id=\"CEXC-$id\" class=\"cdmExcerpt\"> - $content_preview</span>";
596 $reply['content'] .= "</span>";
597
598 if (!get_pref('VFEED_GROUP_BY_FEED')) {
599 if (@$line["feed_title"]) {
600 $reply['content'] .= "<div class=\"hlFeed\">
601 <a href=\"#\" onclick=\"viewfeed($feed_id)\">".
602 truncate_string($line["feed_title"],30)."</a>
603 </div>";
604 }
605 }
606
607 $reply['content'] .= "<span class='updated' title='$date_entered_fmt'>
608 $updated_fmt</span>";
609
610 $reply['content'] .= "<div style=\"vertical-align : middle\">";
611 $reply['content'] .= "$score_pic";
612
613 if (!get_pref("VFEED_GROUP_BY_FEED") && $line["feed_title"]) {
614 $reply['content'] .= "<span style=\"cursor : pointer\"
615 title=\"".htmlspecialchars($line["feed_title"])."\"
616 onclick=\"viewfeed($feed_id)\">$feed_icon_img</span>";
617 }
618 $reply['content'] .= "</div>";
619
620 $reply['content'] .= "</div>";
621
622 $reply['content'] .= "<div class=\"cdmContent\" $content_hidden
623 onclick=\"return cdmClicked(event, $id);\"
624 id=\"CICD-$id\">";
625
626 $reply['content'] .= "<div id=\"POSTNOTE-$id\">";
627 if ($line['note']) {
628 $reply['content'] .= format_article_note($id, $line['note']);
629 }
630 $reply['content'] .= "</div>";
631
632 $reply['content'] .= "<div class=\"cdmContentInner\">";
633
634 if ($line["orig_feed_id"]) {
635
636 $tmp_result = $this->dbh->query("SELECT * FROM ttrss_archived_feeds
637 WHERE id = ".$line["orig_feed_id"]);
638
639 if ($this->dbh->num_rows($tmp_result) != 0) {
640
641 $reply['content'] .= "<div clear='both'>";
642 $reply['content'] .= __("Originally from:");
643
644 $reply['content'] .= "&nbsp;";
645
646 $tmp_line = $this->dbh->fetch_assoc($tmp_result);
647
648 $reply['content'] .= "<a target='_blank'
649 href=' " . htmlspecialchars($tmp_line['site_url']) . "'>" .
650 $tmp_line['title'] . "</a>";
651
652 $reply['content'] .= "&nbsp;";
653
654 $reply['content'] .= "<a target='_blank' href='" . htmlspecialchars($tmp_line['feed_url']) . "'>";
655 $reply['content'] .= "<img title='".__('Feed URL')."'class='tinyFeedIcon' src='images/pub_unset.svg'></a>";
656
657 $reply['content'] .= "</div>";
658 }
659 }
660
661 $reply['content'] .= "<span id=\"CWRAP-$id\">";
662
663 // if (!$expand_cdm) {
664 $reply['content'] .= "<span id=\"CENCW-$id\" style=\"display : none\">";
665 $reply['content'] .= htmlspecialchars($line["content"]);
666 $reply['content'] .= "</span.";
667
668 // } else {
669 // $reply['content'] .= $line["content"];
670 // }
671
672 $reply['content'] .= "</span>";
673
674 $always_display_enclosures = sql_bool_to_bool($line["always_display_enclosures"]);
675
676 $reply['content'] .= format_article_enclosures($id, $always_display_enclosures, $line["content"], sql_bool_to_bool($line["hide_images"]));
677
678 $reply['content'] .= "</div>";
679
680 $reply['content'] .= "<div class=\"cdmFooter\">";
681
682 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_ARTICLE_LEFT_BUTTON) as $p) {
683 $reply['content'] .= $p->hook_article_left_button($line);
684 }
685
686 $tags_str = format_tags_string($tags, $id);
687
688 $reply['content'] .= "<img src='images/tag.png' alt='Tags' title='Tags'>
689 <span id=\"ATSTR-$id\">$tags_str</span>
690 <a title=\"".__('Edit tags for this article')."\"
691 href=\"#\" onclick=\"editArticleTags($id)\">(+)</a>";
692
693 $num_comments = $line["num_comments"];
694 $entry_comments = "";
695
696 if ($num_comments > 0) {
697 if ($line["comments"]) {
698 $comments_url = htmlspecialchars($line["comments"]);
699 } else {
700 $comments_url = htmlspecialchars($line["link"]);
701 }
702 $entry_comments = "<a target='_blank' href=\"$comments_url\">$num_comments comments</a>";
703 } else {
704 if ($line["comments"] && $line["link"] != $line["comments"]) {
705 $entry_comments = "<a target='_blank' href=\"".htmlspecialchars($line["comments"])."\">comments</a>";
706 }
707 }
708
709 if ($entry_comments) $reply['content'] .= "&nbsp;($entry_comments)";
710
711 $reply['content'] .= "<div style=\"float : right\">";
712
713 // $reply['content'] .= "$marked_pic";
714 // $reply['content'] .= "$published_pic";
715
716 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_ARTICLE_BUTTON) as $p) {
717 $reply['content'] .= $p->hook_article_button($line);
718 }
719
720 $reply['content'] .= "</div>";
721 $reply['content'] .= "</div>";
722
723 $reply['content'] .= "</div>";
724
725 $reply['content'] .= "</div>";
726
727 }
728
729 ++$lnum;
730 }
731
732 if ($_REQUEST["debug"]) $timing_info = print_checkpoint("PE", $timing_info);
733
734 } else {
735 $message = "";
736
737 switch ($view_mode) {
738 case "unread":
739 $message = __("No unread articles found to display.");
740 break;
741 case "updated":
742 $message = __("No updated articles found to display.");
743 break;
744 case "marked":
745 $message = __("No starred articles found to display.");
746 break;
747 default:
748 if ($feed < LABEL_BASE_INDEX) {
749 $message = __("No articles found to display. You can assign articles to labels manually from article header context menu (applies to all selected articles) or use a filter.");
750 } else {
751 $message = __("No articles found to display.");
752 }
753 }
754
755 if (!$offset && $message) {
756 $reply['content'] .= "<div class='whiteBox'>$message";
757
758 $reply['content'] .= "<p><span class=\"insensitive\">";
759
760 $result = $this->dbh->query("SELECT ".SUBSTRING_FOR_DATE."(MAX(last_updated), 1, 19) AS last_updated FROM ttrss_feeds
761 WHERE owner_uid = " . $_SESSION['uid']);
762
763 $last_updated = $this->dbh->fetch_result($result, 0, "last_updated");
764 $last_updated = make_local_datetime($last_updated, false);
765
766 $reply['content'] .= sprintf(__("Feeds last updated at %s"), $last_updated);
767
768 $result = $this->dbh->query("SELECT COUNT(id) AS num_errors
769 FROM ttrss_feeds WHERE last_error != '' AND owner_uid = ".$_SESSION["uid"]);
770
771 $num_errors = $this->dbh->fetch_result($result, 0, "num_errors");
772
773 if ($num_errors > 0) {
774 $reply['content'] .= "<br/>";
775 $reply['content'] .= "<a class=\"insensitive\" href=\"#\" onclick=\"showFeedsWithErrors()\">".
776 __('Some feeds have update errors (click for details)')."</a>";
777 }
778 $reply['content'] .= "</span></p></div>";
779 }
780 }
781
782 if ($_REQUEST["debug"]) $timing_info = print_checkpoint("H2", $timing_info);
783
784 return array($topmost_article_ids, $headlines_count, $feed, $disable_cache,
785 $vgroup_last_feed, $reply);
786 }
787
788 function catchupAll() {
789 $this->dbh->query("UPDATE ttrss_user_entries SET
790 last_read = NOW(), unread = false WHERE unread = true AND owner_uid = " . $_SESSION["uid"]);
791 ccache_zero_all($_SESSION["uid"]);
792 }
793
794 function view() {
795 $timing_info = microtime(true);
796
797 $reply = array();
798
799 if ($_REQUEST["debug"]) $timing_info = print_checkpoint("0", $timing_info);
800
801 $omode = $this->dbh->escape_string($_REQUEST["omode"]);
802
803 $feed = $this->dbh->escape_string($_REQUEST["feed"]);
804 $method = $this->dbh->escape_string($_REQUEST["m"]);
805 $view_mode = $this->dbh->escape_string($_REQUEST["view_mode"]);
806 $limit = 30;
807 @$cat_view = $_REQUEST["cat"] == "true";
808 @$next_unread_feed = $this->dbh->escape_string($_REQUEST["nuf"]);
809 @$offset = $this->dbh->escape_string($_REQUEST["skip"]);
810 @$vgroup_last_feed = $this->dbh->escape_string($_REQUEST["vgrlf"]);
811 $order_by = $this->dbh->escape_string($_REQUEST["order_by"]);
812
813 if (is_numeric($feed)) $feed = (int) $feed;
814
815 /* Feed -5 is a special case: it is used to display auxiliary information
816 * when there's nothing to load - e.g. no stuff in fresh feed */
817
818 if ($feed == -5) {
819 print json_encode($this->generate_dashboard_feed());
820 return;
821 }
822
823 $result = false;
824
825 if ($feed < LABEL_BASE_INDEX) {
826 $label_feed = feed_to_label_id($feed);
827 $result = $this->dbh->query("SELECT id FROM ttrss_labels2 WHERE
828 id = '$label_feed' AND owner_uid = " . $_SESSION['uid']);
829 } else if (!$cat_view && is_numeric($feed) && $feed > 0) {
830 $result = $this->dbh->query("SELECT id FROM ttrss_feeds WHERE
831 id = '$feed' AND owner_uid = " . $_SESSION['uid']);
832 } else if ($cat_view && is_numeric($feed) && $feed > 0) {
833 $result = $this->dbh->query("SELECT id FROM ttrss_feed_categories WHERE
834 id = '$feed' AND owner_uid = " . $_SESSION['uid']);
835 }
836
837 if ($result && $this->dbh->num_rows($result) == 0) {
838 print json_encode($this->generate_error_feed(__("Feed not found.")));
839 return;
840 }
841
842 /* Updating a label ccache means recalculating all of the caches
843 * so for performance reasons we don't do that here */
844
845 if ($feed >= 0) {
846 ccache_update($feed, $_SESSION["uid"], $cat_view);
847 }
848
849 set_pref("_DEFAULT_VIEW_MODE", $view_mode);
850 set_pref("_DEFAULT_VIEW_ORDER_BY", $order_by);
851
852 /* bump login timestamp if needed */
853 if (time() - $_SESSION["last_login_update"] > 3600) {
854 $this->dbh->query("UPDATE ttrss_users SET last_login = NOW() WHERE id = " .
855 $_SESSION["uid"]);
856 $_SESSION["last_login_update"] = time();
857 }
858
859 if (!$cat_view && is_numeric($feed) && $feed > 0) {
860 $this->dbh->query("UPDATE ttrss_feeds SET last_viewed = NOW()
861 WHERE id = '$feed' AND owner_uid = ".$_SESSION["uid"]);
862 }
863
864 $reply['headlines'] = array();
865
866 if (!$next_unread_feed)
867 $reply['headlines']['id'] = $feed;
868 else
869 $reply['headlines']['id'] = $next_unread_feed;
870
871 $reply['headlines']['is_cat'] = (bool) $cat_view;
872
873 $override_order = false;
874
875 switch ($order_by) {
876 case "title":
877 $override_order = "ttrss_entries.title";
878 break;
879 case "date_reverse":
880 $override_order = "date_entered, updated";
881 break;
882 case "feed_dates":
883 $override_order = "updated DESC";
884 break;
885 }
886
887 if ($_REQUEST["debug"]) $timing_info = print_checkpoint("04", $timing_info);
888
889 $ret = $this->format_headlines_list($feed, $method,
890 $view_mode, $limit, $cat_view, $next_unread_feed, $offset,
891 $vgroup_last_feed, $override_order, true);
892
893 //$topmost_article_ids = $ret[0];
894 $headlines_count = $ret[1];
895 $returned_feed = $ret[2];
896 $disable_cache = $ret[3];
897 $vgroup_last_feed = $ret[4];
898
899 $reply['headlines']['content'] =& $ret[5]['content'];
900 $reply['headlines']['toolbar'] =& $ret[5]['toolbar'];
901
902 if ($_REQUEST["debug"]) $timing_info = print_checkpoint("05", $timing_info);
903
904 $reply['headlines-info'] = array("count" => (int) $headlines_count,
905 "vgroup_last_feed" => $vgroup_last_feed,
906 "disable_cache" => (bool) $disable_cache);
907
908 if ($_REQUEST["debug"]) $timing_info = print_checkpoint("30", $timing_info);
909
910 $reply['runtime-info'] = make_runtime_info();
911
912 print json_encode($reply);
913
914 }
915
916 private function generate_dashboard_feed() {
917 $reply = array();
918
919 $reply['headlines']['id'] = -5;
920 $reply['headlines']['is_cat'] = false;
921
922 $reply['headlines']['toolbar'] = '';
923 $reply['headlines']['content'] = "<div class='whiteBox'>".__('No feed selected.');
924
925 $reply['headlines']['content'] .= "<p><span class=\"insensitive\">";
926
927 $result = $this->dbh->query("SELECT ".SUBSTRING_FOR_DATE."(MAX(last_updated), 1, 19) AS last_updated FROM ttrss_feeds
928 WHERE owner_uid = " . $_SESSION['uid']);
929
930 $last_updated = $this->dbh->fetch_result($result, 0, "last_updated");
931 $last_updated = make_local_datetime($last_updated, false);
932
933 $reply['headlines']['content'] .= sprintf(__("Feeds last updated at %s"), $last_updated);
934
935 $result = $this->dbh->query("SELECT COUNT(id) AS num_errors
936 FROM ttrss_feeds WHERE last_error != '' AND owner_uid = ".$_SESSION["uid"]);
937
938 $num_errors = $this->dbh->fetch_result($result, 0, "num_errors");
939
940 if ($num_errors > 0) {
941 $reply['headlines']['content'] .= "<br/>";
942 $reply['headlines']['content'] .= "<a class=\"insensitive\" href=\"#\" onclick=\"showFeedsWithErrors()\">".
943 __('Some feeds have update errors (click for details)')."</a>";
944 }
945 $reply['headlines']['content'] .= "</span></p>";
946
947 $reply['headlines-info'] = array("count" => 0,
948 "vgroup_last_feed" => '',
949 "unread" => 0,
950 "disable_cache" => true);
951
952 return $reply;
953 }
954
955 private function generate_error_feed($error) {
956 $reply = array();
957
958 $reply['headlines']['id'] = -6;
959 $reply['headlines']['is_cat'] = false;
960
961 $reply['headlines']['toolbar'] = '';
962 $reply['headlines']['content'] = "<div class='whiteBox'>". $error . "</div>";
963
964 $reply['headlines-info'] = array("count" => 0,
965 "vgroup_last_feed" => '',
966 "unread" => 0,
967 "disable_cache" => true);
968
969 return $reply;
970 }
971
972 function quickAddFeed() {
973 print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\" name=\"op\" value=\"rpc\">";
974 print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\" name=\"method\" value=\"addfeed\">";
975
976 print "<div class=\"dlgSec\">".__("Feed or site URL")."</div>";
977 print "<div class=\"dlgSecCont\">";
978
979 print "<div style='float : right'>
980 <img style='display : none'
981 id='feed_add_spinner' src='images/indicator_white.gif'></div>";
982
983 print "<input style=\"font-size : 16px; width : 20em;\"
984 placeHolder=\"".__("Feed or site URL")."\"
985 dojoType=\"dijit.form.ValidationTextBox\" required=\"1\" name=\"feed\" id=\"feedDlg_feedUrl\">";
986
987 print "<hr/>";
988
989 if (get_pref('ENABLE_FEED_CATS')) {
990 print __('Place in category:') . " ";
991 print_feed_cat_select("cat", false, 'dojoType="dijit.form.Select"');
992 }
993
994 print "</div>";
995
996 print '<div id="feedDlg_feedsContainer" style="display : none">
997
998 <div class="dlgSec">' . __('Available feeds') . '</div>
999 <div class="dlgSecCont">'.
1000 '<select id="feedDlg_feedContainerSelect"
1001 dojoType="dijit.form.Select" size="3">
1002 <script type="dojo/method" event="onChange" args="value">
1003 dijit.byId("feedDlg_feedUrl").attr("value", value);
1004 </script>
1005 </select>'.
1006 '</div></div>';
1007
1008 print "<div id='feedDlg_loginContainer' style='display : none'>
1009
1010 <div class=\"dlgSec\">".__("Authentication")."</div>
1011 <div class=\"dlgSecCont\">".
1012
1013 " <input dojoType=\"dijit.form.TextBox\" name='login'\"
1014 placeHolder=\"".__("Login")."\"
1015 style=\"width : 10em;\"> ".
1016 " <input
1017 placeHolder=\"".__("Password")."\"
1018 dojoType=\"dijit.form.TextBox\" type='password'
1019 style=\"width : 10em;\" name='pass'\">
1020 </div></div>";
1021
1022
1023 print "<div style=\"clear : both\">
1024 <input type=\"checkbox\" name=\"need_auth\" dojoType=\"dijit.form.CheckBox\" id=\"feedDlg_loginCheck\"
1025 onclick='checkboxToggleElement(this, \"feedDlg_loginContainer\")'>
1026 <label for=\"feedDlg_loginCheck\">".
1027 __('This feed requires authentication.')."</div>";
1028
1029 print "</form>";
1030
1031 print "<div class=\"dlgButtons\">
1032 <button dojoType=\"dijit.form.Button\" onclick=\"return dijit.byId('feedAddDlg').execute()\">".__('Subscribe')."</button>";
1033
1034 if (!(defined('_DISABLE_FEED_BROWSER') && _DISABLE_FEED_BROWSER)) {
1035 print "<button dojoType=\"dijit.form.Button\" onclick=\"return feedBrowser()\">".__('More feeds')."</button>";
1036 }
1037
1038 print "<button dojoType=\"dijit.form.Button\" onclick=\"return dijit.byId('feedAddDlg').hide()\">".__('Cancel')."</button>
1039 </div>";
1040
1041 //return;
1042 }
1043
1044 function feedBrowser() {
1045 if (defined('_DISABLE_FEED_BROWSER') && _DISABLE_FEED_BROWSER) return;
1046
1047 $browser_search = $this->dbh->escape_string($_REQUEST["search"]);
1048
1049 print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\" name=\"op\" value=\"rpc\">";
1050 print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\" name=\"method\" value=\"updateFeedBrowser\">";
1051
1052 print "<div dojoType=\"dijit.Toolbar\">
1053 <div style='float : right'>
1054 <img style='display : none'
1055 id='feed_browser_spinner' src='images/indicator_white.gif'>
1056 <input name=\"search\" dojoType=\"dijit.form.TextBox\" size=\"20\" type=\"search\"
1057 onchange=\"dijit.byId('feedBrowserDlg').update()\" value=\"$browser_search\">
1058 <button dojoType=\"dijit.form.Button\" onclick=\"dijit.byId('feedBrowserDlg').update()\">".__('Search')."</button>
1059 </div>";
1060
1061 print " <select name=\"mode\" dojoType=\"dijit.form.Select\" onchange=\"dijit.byId('feedBrowserDlg').update()\">
1062 <option value='1'>" . __('Popular feeds') . "</option>
1063 <option value='2'>" . __('Feed archive') . "</option>
1064 </select> ";
1065
1066 print __("limit:");
1067
1068 print " <select dojoType=\"dijit.form.Select\" name=\"limit\" onchange=\"dijit.byId('feedBrowserDlg').update()\">";
1069
1070 foreach (array(25, 50, 100, 200) as $l) {
1071 $issel = ($l == $limit) ? "selected=\"1\"" : "";
1072 print "<option $issel value=\"$l\">$l</option>";
1073 }
1074
1075 print "</select> ";
1076
1077 print "</div>";
1078
1079 $owner_uid = $_SESSION["uid"];
1080
1081 require_once "feedbrowser.php";
1082
1083 print "<ul class='browseFeedList' id='browseFeedList'>";
1084 print make_feed_browser($search, 25);
1085 print "</ul>";
1086
1087 print "<div align='center'>
1088 <button dojoType=\"dijit.form.Button\" onclick=\"dijit.byId('feedBrowserDlg').execute()\">".__('Subscribe')."</button>
1089 <button dojoType=\"dijit.form.Button\" style='display : none' id='feed_archive_remove' onclick=\"dijit.byId('feedBrowserDlg').removeFromArchive()\">".__('Remove')."</button>
1090 <button dojoType=\"dijit.form.Button\" onclick=\"dijit.byId('feedBrowserDlg').hide()\" >".__('Cancel')."</button></div>";
1091
1092 }
1093
1094 function search() {
1095 $this->params = explode(":", $this->dbh->escape_string($_REQUEST["param"]), 2);
1096
1097 $active_feed_id = sprintf("%d", $this->params[0]);
1098 $is_cat = $this->params[1] != "false";
1099
1100 print "<div class=\"dlgSec\">".__('Look for')."</div>";
1101
1102 print "<div class=\"dlgSecCont\">";
1103
1104 print "<input dojoType=\"dijit.form.ValidationTextBox\"
1105 style=\"font-size : 16px; width : 20em;\"
1106 required=\"1\" name=\"query\" type=\"search\" value=''>";
1107
1108 print "<hr/>".__('Limit search to:')." ";
1109
1110 print "<select name=\"search_mode\" dojoType=\"dijit.form.Select\">
1111 <option value=\"all_feeds\">".__('All feeds')."</option>";
1112
1113 $feed_title = getFeedTitle($active_feed_id);
1114
1115 if (!$is_cat) {
1116 $feed_cat_title = getFeedCatTitle($active_feed_id);
1117 } else {
1118 $feed_cat_title = getCategoryTitle($active_feed_id);
1119 }
1120
1121 if ($active_feed_id && !$is_cat) {
1122 print "<option selected=\"1\" value=\"this_feed\">$feed_title</option>";
1123 } else {
1124 print "<option disabled=\"1\" value=\"false\">".__('This feed')."</option>";
1125 }
1126
1127 if ($is_cat) {
1128 $cat_preselected = "selected=\"1\"";
1129 }
1130
1131 if (get_pref('ENABLE_FEED_CATS') && ($active_feed_id > 0 || $is_cat)) {
1132 print "<option $cat_preselected value=\"this_cat\">$feed_cat_title</option>";
1133 } else {
1134 //print "<option disabled>".__('This category')."</option>";
1135 }
1136
1137 print "</select>";
1138
1139 print "</div>";
1140
1141 print "<div class=\"dlgButtons\">";
1142
1143 if (!SPHINX_ENABLED) {
1144 print "<div style=\"float : left\">
1145 <a class=\"visibleLink\" target=\"_blank\" href=\"http://tt-rss.org/wiki/SearchSyntax\">Search syntax</a>
1146 </div>";
1147 }
1148
1149 print "<button dojoType=\"dijit.form.Button\" onclick=\"dijit.byId('searchDlg').execute()\">".__('Search')."</button>
1150 <button dojoType=\"dijit.form.Button\" onclick=\"dijit.byId('searchDlg').hide()\">".__('Cancel')."</button>
1151 </div>";
1152 }
1153
1154
1155 }
1156 ?>