]> git.wh0rd.org - tt-rss.git/blob - include/functions2.php
git.wh0rd.org / tt-rss.git / blob
? search:
summary | shortlog | log | commit | commitdiff | tree
blame | history | raw | HEAD
Add unread category to build-in Search
[tt-rss.git] / include / functions2.php
1 <?php
2 function make_init_params() {
3 $params = array();
4
5 foreach (array("ON_CATCHUP_SHOW_NEXT_FEED", "HIDE_READ_FEEDS",
6 "ENABLE_FEED_CATS", "FEEDS_SORT_BY_UNREAD", "CONFIRM_FEED_CATCHUP",
7 "CDM_AUTO_CATCHUP", "FRESH_ARTICLE_MAX_AGE",
8 "HIDE_READ_SHOWS_SPECIAL", "COMBINED_DISPLAY_MODE") as $param) {
9
10 $params[strtolower($param)] = (int) get_pref($param);
11 }
12
13 $params["icons_url"] = ICONS_URL;
14 $params["cookie_lifetime"] = SESSION_COOKIE_LIFETIME;
15 $params["default_view_mode"] = get_pref("_DEFAULT_VIEW_MODE");
16 $params["default_view_limit"] = (int) get_pref("_DEFAULT_VIEW_LIMIT");
17 $params["default_view_order_by"] = get_pref("_DEFAULT_VIEW_ORDER_BY");
18 $params["bw_limit"] = (int) $_SESSION["bw_limit"];
19 $params["label_base_index"] = (int) LABEL_BASE_INDEX;
20
21 $theme = get_pref( "USER_CSS_THEME", false, false);
22 $params["theme"] = theme_valid("$theme") ? $theme : "";
23
24 $params["plugins"] = implode(", ", PluginHost::getInstance()->get_plugin_names());
25
26 $params["php_platform"] = PHP_OS;
27 $params["php_version"] = PHP_VERSION;
28
29 $params["sanity_checksum"] = sha1(file_get_contents("include/sanity_check.php"));
30
31 $result = db_query("SELECT MAX(id) AS mid, COUNT(*) AS nf FROM
32 ttrss_feeds WHERE owner_uid = " . $_SESSION["uid"]);
33
34 $max_feed_id = db_fetch_result($result, 0, "mid");
35 $num_feeds = db_fetch_result($result, 0, "nf");
36
37 $params["max_feed_id"] = (int) $max_feed_id;
38 $params["num_feeds"] = (int) $num_feeds;
39
40 $params["hotkeys"] = get_hotkeys_map();
41
42 $params["csrf_token"] = $_SESSION["csrf_token"];
43 $params["widescreen"] = (int) $_COOKIE["ttrss_widescreen"];
44
45 $params['simple_update'] = defined('SIMPLE_UPDATE_MODE') && SIMPLE_UPDATE_MODE;
46
47 return $params;
48 }
49
50 function get_hotkeys_info() {
51 $hotkeys = array(
52 __("Navigation") => array(
53 "next_feed" => __("Open next feed"),
54 "prev_feed" => __("Open previous feed"),
55 "next_article" => __("Open next article"),
56 "prev_article" => __("Open previous article"),
57 "next_article_noscroll" => __("Open next article (don't scroll long articles)"),
58 "prev_article_noscroll" => __("Open previous article (don't scroll long articles)"),
59 "next_article_noexpand" => __("Move to next article (don't expand or mark read)"),
60 "prev_article_noexpand" => __("Move to previous article (don't expand or mark read)"),
61 "search_dialog" => __("Show search dialog")),
62 __("Article") => array(
63 "toggle_mark" => __("Toggle starred"),
64 "toggle_publ" => __("Toggle published"),
65 "toggle_unread" => __("Toggle unread"),
66 "edit_tags" => __("Edit tags"),
67 "dismiss_selected" => __("Dismiss selected"),
68 "dismiss_read" => __("Dismiss read"),
69 "open_in_new_window" => __("Open in new window"),
70 "catchup_below" => __("Mark below as read"),
71 "catchup_above" => __("Mark above as read"),
72 "article_scroll_down" => __("Scroll down"),
73 "article_scroll_up" => __("Scroll up"),
74 "select_article_cursor" => __("Select article under cursor"),
75 "email_article" => __("Email article"),
76 "close_article" => __("Close/collapse article"),
77 "toggle_expand" => __("Toggle article expansion (combined mode)"),
78 "toggle_widescreen" => __("Toggle widescreen mode"),
79 "toggle_embed_original" => __("Toggle embed original")),
80 __("Article selection") => array(
81 "select_all" => __("Select all articles"),
82 "select_unread" => __("Select unread"),
83 "select_marked" => __("Select starred"),
84 "select_published" => __("Select published"),
85 "select_invert" => __("Invert selection"),
86 "select_none" => __("Deselect everything")),
87 __("Feed") => array(
88 "feed_refresh" => __("Refresh current feed"),
89 "feed_unhide_read" => __("Un/hide read feeds"),
90 "feed_subscribe" => __("Subscribe to feed"),
91 "feed_edit" => __("Edit feed"),
92 "feed_catchup" => __("Mark as read"),
93 "feed_reverse" => __("Reverse headlines"),
94 "feed_debug_update" => __("Debug feed update"),
95 "catchup_all" => __("Mark all feeds as read"),
96 "cat_toggle_collapse" => __("Un/collapse current category"),
97 "toggle_combined_mode" => __("Toggle combined mode"),
98 "toggle_cdm_expanded" => __("Toggle auto expand in combined mode")),
99 __("Go to") => array(
100 "goto_all" => __("All articles"),
101 "goto_fresh" => __("Fresh"),
102 "goto_marked" => __("Starred"),
103 "goto_published" => __("Published"),
104 "goto_tagcloud" => __("Tag cloud"),
105 "goto_prefs" => __("Preferences")),
106 __("Other") => array(
107 "create_label" => __("Create label"),
108 "create_filter" => __("Create filter"),
109 "collapse_sidebar" => __("Un/collapse sidebar"),
110 "help_dialog" => __("Show help dialog"))
111 );
112
113 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_HOTKEY_INFO) as $plugin) {
114 $hotkeys = $plugin->hook_hotkey_info($hotkeys);
115 }
116
117 return $hotkeys;
118 }
119
120 function get_hotkeys_map() {
121 $hotkeys = array(
122 // "navigation" => array(
123 "k" => "next_feed",
124 "j" => "prev_feed",
125 "n" => "next_article",
126 "p" => "prev_article",
127 "(38)|up" => "prev_article",
128 "(40)|down" => "next_article",
129 // "^(38)|Ctrl-up" => "prev_article_noscroll",
130 // "^(40)|Ctrl-down" => "next_article_noscroll",
131 "(191)|/" => "search_dialog",
132 // "article" => array(
133 "s" => "toggle_mark",
134 "*s" => "toggle_publ",
135 "u" => "toggle_unread",
136 "*t" => "edit_tags",
137 "*d" => "dismiss_selected",
138 "*x" => "dismiss_read",
139 "o" => "open_in_new_window",
140 "c p" => "catchup_below",
141 "c n" => "catchup_above",
142 "*n" => "article_scroll_down",
143 "*p" => "article_scroll_up",
144 "*(38)|Shift+up" => "article_scroll_up",
145 "*(40)|Shift+down" => "article_scroll_down",
146 "a *w" => "toggle_widescreen",
147 "a e" => "toggle_embed_original",
148 "e" => "email_article",
149 "a q" => "close_article",
150 // "article_selection" => array(
151 "a a" => "select_all",
152 "a u" => "select_unread",
153 "a *u" => "select_marked",
154 "a p" => "select_published",
155 "a i" => "select_invert",
156 "a n" => "select_none",
157 // "feed" => array(
158 "f r" => "feed_refresh",
159 "f a" => "feed_unhide_read",
160 "f s" => "feed_subscribe",
161 "f e" => "feed_edit",
162 "f q" => "feed_catchup",
163 "f x" => "feed_reverse",
164 "f *d" => "feed_debug_update",
165 "f *c" => "toggle_combined_mode",
166 "f c" => "toggle_cdm_expanded",
167 "*q" => "catchup_all",
168 "x" => "cat_toggle_collapse",
169 // "goto" => array(
170 "g a" => "goto_all",
171 "g f" => "goto_fresh",
172 "g s" => "goto_marked",
173 "g p" => "goto_published",
174 "g t" => "goto_tagcloud",
175 "g *p" => "goto_prefs",
176 // "other" => array(
177 "(9)|Tab" => "select_article_cursor", // tab
178 "c l" => "create_label",
179 "c f" => "create_filter",
180 "c s" => "collapse_sidebar",
181 "^(191)|Ctrl+/" => "help_dialog",
182 );
183
184 if (get_pref('COMBINED_DISPLAY_MODE')) {
185 $hotkeys["^(38)|Ctrl-up"] = "prev_article_noscroll";
186 $hotkeys["^(40)|Ctrl-down"] = "next_article_noscroll";
187 }
188
189 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_HOTKEY_MAP) as $plugin) {
190 $hotkeys = $plugin->hook_hotkey_map($hotkeys);
191 }
192
193 $prefixes = array();
194
195 foreach (array_keys($hotkeys) as $hotkey) {
196 $pair = explode(" ", $hotkey, 2);
197
198 if (count($pair) > 1 && !in_array($pair[0], $prefixes)) {
199 array_push($prefixes, $pair[0]);
200 }
201 }
202
203 return array($prefixes, $hotkeys);
204 }
205
206 function check_for_update() {
207 if (defined("GIT_VERSION_TIMESTAMP")) {
208 $content = @fetch_file_contents("http://tt-rss.org/version.json");
209
210 if ($content) {
211 $content = json_decode($content, true);
212
213 if ($content && isset($content["changeset"])) {
214 if ((int)GIT_VERSION_TIMESTAMP < (int)$content["changeset"]["timestamp"] &&
215 GIT_VERSION_HEAD != $content["changeset"]["id"]) {
216
217 return $content["changeset"]["id"];
218 }
219 }
220 }
221 }
222
223 return "";
224 }
225
226 function make_runtime_info() {
227 $data = array();
228
229 $result = db_query("SELECT MAX(id) AS mid, COUNT(*) AS nf FROM
230 ttrss_feeds WHERE owner_uid = " . $_SESSION["uid"]);
231
232 $max_feed_id = db_fetch_result($result, 0, "mid");
233 $num_feeds = db_fetch_result($result, 0, "nf");
234
235 $data["max_feed_id"] = (int) $max_feed_id;
236 $data["num_feeds"] = (int) $num_feeds;
237
238 $data['last_article_id'] = getLastArticleId();
239 $data['cdm_expanded'] = get_pref('CDM_EXPANDED');
240
241 $data['dep_ts'] = calculate_dep_timestamp();
242 $data['reload_on_ts_change'] = !defined('_NO_RELOAD_ON_TS_CHANGE');
243
244
245 if (CHECK_FOR_UPDATES && $_SESSION["last_version_check"] + 86400 + rand(-1000, 1000) < time()) {
246 $update_result = @check_for_update();
247
248 $data["update_result"] = $update_result;
249
250 $_SESSION["last_version_check"] = time();
251 }
252
253 if (file_exists(LOCK_DIRECTORY . "/update_daemon.lock")) {
254
255 $data['daemon_is_running'] = (int) file_is_locked("update_daemon.lock");
256
257 if (time() - $_SESSION["daemon_stamp_check"] > 30) {
258
259 $stamp = (int) @file_get_contents(LOCK_DIRECTORY . "/update_daemon.stamp");
260
261 if ($stamp) {
262 $stamp_delta = time() - $stamp;
263
264 if ($stamp_delta > 1800) {
265 $stamp_check = 0;
266 } else {
267 $stamp_check = 1;
268 $_SESSION["daemon_stamp_check"] = time();
269 }
270
271 $data['daemon_stamp_ok'] = $stamp_check;
272
273 $stamp_fmt = date("Y.m.d, G:i", $stamp);
274
275 $data['daemon_stamp'] = $stamp_fmt;
276 }
277 }
278 }
279
280 return $data;
281 }
282
283 function search_to_sql($search) {
284
285 $search_query_part = "";
286
287 $keywords = str_getcsv($search, " ");
288 $query_keywords = array();
289 $search_words = array();
290
291 foreach ($keywords as $k) {
292 if (strpos($k, "-") === 0) {
293 $k = substr($k, 1);
294 $not = "NOT";
295 } else {
296 $not = "";
297 }
298
299 $commandpair = explode(":", mb_strtolower($k), 2);
300
301 switch ($commandpair[0]) {
302 case "title":
303 if ($commandpair[1]) {
304 array_push($query_keywords, "($not (LOWER(ttrss_entries.title) LIKE '%".
305 db_escape_string(mb_strtolower($commandpair[1]))."%'))");
306 } else {
307 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
308 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
309 array_push($search_words, $k);
310 }
311 break;
312 case "author":
313 if ($commandpair[1]) {
314 array_push($query_keywords, "($not (LOWER(author) LIKE '%".
315 db_escape_string(mb_strtolower($commandpair[1]))."%'))");
316 } else {
317 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
318 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
319 array_push($search_words, $k);
320 }
321 break;
322 case "note":
323 if ($commandpair[1]) {
324 if ($commandpair[1] == "true")
325 array_push($query_keywords, "($not (note IS NOT NULL AND note != ''))");
326 else if ($commandpair[1] == "false")
327 array_push($query_keywords, "($not (note IS NULL OR note = ''))");
328 else
329 array_push($query_keywords, "($not (LOWER(note) LIKE '%".
330 db_escape_string(mb_strtolower($commandpair[1]))."%'))");
331 } else {
332 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
333 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
334 if (!$not) array_push($search_words, $k);
335 }
336 break;
337 case "star":
338
339 if ($commandpair[1]) {
340 if ($commandpair[1] == "true")
341 array_push($query_keywords, "($not (marked = true))");
342 else
343 array_push($query_keywords, "($not (marked = false))");
344 } else {
345 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
346 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
347 if (!$not) array_push($search_words, $k);
348 }
349 break;
350 case "pub":
351 if ($commandpair[1]) {
352 if ($commandpair[1] == "true")
353 array_push($query_keywords, "($not (published = true))");
354 else
355 array_push($query_keywords, "($not (published = false))");
356
357 } else {
358 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
359 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
360 if (!$not) array_push($search_words, $k);
361 }
362 break;
363 case "unread":
364 if ($commandpair[1]) {
365 if ($commandpair[1] == "true")
366 array_push($query_keywords, "($not (unread = true))");
367 else
368 array_push($query_keywords, "($not (unread = false))");
369
370 } else {
371 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
372 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
373 if (!$not) array_push($search_words, $k);
374 }
375 break;
376 default:
377 if (strpos($k, "@") === 0) {
378
379 $user_tz_string = get_pref('USER_TIMEZONE', $_SESSION['uid']);
380 $orig_ts = strtotime(substr($k, 1));
381 $k = date("Y-m-d", convert_timestamp($orig_ts, $user_tz_string, 'UTC'));
382
383 //$k = date("Y-m-d", strtotime(substr($k, 1)));
384
385 array_push($query_keywords, "(".SUBSTRING_FOR_DATE."(updated,1,LENGTH('$k')) $not = '$k')");
386 } else {
387 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
388 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
389
390 if (!$not) array_push($search_words, $k);
391 }
392 }
393 }
394
395 $search_query_part = implode("AND", $query_keywords);
396
397 return array($search_query_part, $search_words);
398 }
399
400 function getParentCategories($cat, $owner_uid) {
401 $rv = array();
402
403 $result = db_query("SELECT parent_cat FROM ttrss_feed_categories
404 WHERE id = '$cat' AND parent_cat IS NOT NULL AND owner_uid = $owner_uid");
405
406 while ($line = db_fetch_assoc($result)) {
407 array_push($rv, $line["parent_cat"]);
408 $rv = array_merge($rv, getParentCategories($line["parent_cat"], $owner_uid));
409 }
410
411 return $rv;
412 }
413
414 function getChildCategories($cat, $owner_uid) {
415 $rv = array();
416
417 $result = db_query("SELECT id FROM ttrss_feed_categories
418 WHERE parent_cat = '$cat' AND owner_uid = $owner_uid");
419
420 while ($line = db_fetch_assoc($result)) {
421 array_push($rv, $line["id"]);
422 $rv = array_merge($rv, getChildCategories($line["id"], $owner_uid));
423 }
424
425 return $rv;
426 }
427
428 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, $override_strategy = false, $override_vfeed = false, $start_ts = false) {
429
430 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
431
432 $ext_tables_part = "";
433 $search_words = array();
434
435 if ($search) {
436 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_SEARCH) as $plugin) {
437 list($search_query_part, $search_words) = $plugin->hook_search($search);
438 break;
439 }
440
441 // fall back in case of no plugins
442 if (!$search_query_part) {
443 list($search_query_part, $search_words) = search_to_sql($search);
444 }
445 $search_query_part .= " AND ";
446 } else {
447 $search_query_part = "";
448 }
449
450 if ($filter) {
451
452 if (DB_TYPE == "pgsql") {
453 $query_strategy_part .= " AND updated > NOW() - INTERVAL '14 days' ";
454 } else {
455 $query_strategy_part .= " AND updated > DATE_SUB(NOW(), INTERVAL 14 DAY) ";
456 }
457
458 $override_order = "updated DESC";
459
460 $filter_query_part = filter_to_sql($filter, $owner_uid);
461
462 // Try to check if SQL regexp implementation chokes on a valid regexp
463
464
465 $result = db_query("SELECT true AS true_val
466 FROM ttrss_entries
467 JOIN ttrss_user_entries ON ttrss_entries.id = ttrss_user_entries.ref_id
468 JOIN ttrss_feeds ON ttrss_feeds.id = ttrss_user_entries.feed_id
469 WHERE $filter_query_part LIMIT 1", false);
470
471 if ($result) {
472 $test = db_fetch_result($result, 0, "true_val");
473
474 if (!$test) {
475 $filter_query_part = "false AND";
476 } else {
477 $filter_query_part .= " AND";
478 }
479 } else {
480 $filter_query_part = "false AND";
481 }
482
483 } else {
484 $filter_query_part = "";
485 }
486
487 if ($since_id) {
488 $since_id_part = "ttrss_entries.id > $since_id AND ";
489 } else {
490 $since_id_part = "";
491 }
492
493 $view_query_part = "";
494
495 if ($view_mode == "adaptive") {
496 if ($search) {
497 $view_query_part = " ";
498 } else if ($feed != -1) {
499
500 $unread = getFeedUnread($feed, $cat_view);
501
502 if ($cat_view && $feed > 0 && $include_children)
503 $unread += getCategoryChildrenUnread($feed);
504
505 if ($unread > 0)
506 $view_query_part = " unread = true AND ";
507
508 }
509 }
510
511 if ($view_mode == "marked") {
512 $view_query_part = " marked = true AND ";
513 }
514
515 if ($view_mode == "has_note") {
516 $view_query_part = " (note IS NOT NULL AND note != '') AND ";
517 }
518
519 if ($view_mode == "published") {
520 $view_query_part = " published = true AND ";
521 }
522
523 if ($view_mode == "unread" && $feed != -6) {
524 $view_query_part = " unread = true AND ";
525 }
526
527 if ($limit > 0) {
528 $limit_query_part = "LIMIT " . $limit;
529 }
530
531 $allow_archived = false;
532
533 $vfeed_query_part = "";
534
535 // override query strategy and enable feed display when searching globally
536 if ($search && $search_mode == "all_feeds") {
537 $query_strategy_part = "true";
538 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
539 /* tags */
540 } else if (!is_numeric($feed)) {
541 $query_strategy_part = "true";
542 $vfeed_query_part = "(SELECT title FROM ttrss_feeds WHERE
543 id = feed_id) as feed_title,";
544 } else if ($search && $search_mode == "this_cat") {
545 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
546
547 if ($feed > 0) {
548 if ($include_children) {
549 $subcats = getChildCategories($feed, $owner_uid);
550 array_push($subcats, $feed);
551 $cats_qpart = join(",", $subcats);
552 } else {
553 $cats_qpart = $feed;
554 }
555
556 $query_strategy_part = "ttrss_feeds.cat_id IN ($cats_qpart)";
557
558 } else {
559 $query_strategy_part = "ttrss_feeds.cat_id IS NULL";
560 }
561
562 } else if ($feed > 0) {
563
564 if ($cat_view) {
565
566 if ($feed > 0) {
567 if ($include_children) {
568 # sub-cats
569 $subcats = getChildCategories($feed, $owner_uid);
570
571 array_push($subcats, $feed);
572 $query_strategy_part = "cat_id IN (".
573 implode(",", $subcats).")";
574
575 } else {
576 $query_strategy_part = "cat_id = '$feed'";
577 }
578
579 } else {
580 $query_strategy_part = "cat_id IS NULL";
581 }
582
583 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
584
585 } else {
586 $query_strategy_part = "feed_id = '$feed'";
587 }
588 } else if ($feed == 0 && !$cat_view) { // archive virtual feed
589 $query_strategy_part = "feed_id IS NULL";
590 $allow_archived = true;
591 } else if ($feed == 0 && $cat_view) { // uncategorized
592 $query_strategy_part = "cat_id IS NULL AND feed_id IS NOT NULL";
593 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
594 } else if ($feed == -1) { // starred virtual feed
595 $query_strategy_part = "marked = true";
596 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
597 $allow_archived = true;
598
599 if (!$override_order) {
600 $override_order = "last_marked DESC, date_entered DESC, updated DESC";
601 }
602
603 } else if ($feed == -2) { // published virtual feed OR labels category
604
605 if (!$cat_view) {
606 $query_strategy_part = "published = true";
607 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
608 $allow_archived = true;
609
610 if (!$override_order) {
611 $override_order = "last_published DESC, date_entered DESC, updated DESC";
612 }
613
614 } else {
615 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
616
617 $ext_tables_part = ",ttrss_labels2,ttrss_user_labels2";
618
619 $query_strategy_part = "ttrss_labels2.id = ttrss_user_labels2.label_id AND
620 ttrss_user_labels2.article_id = ref_id";
621
622 }
623 } else if ($feed == -6) { // recently read
624 $query_strategy_part = "unread = false AND last_read IS NOT NULL";
625 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
626 $allow_archived = true;
627 $ignore_vfeed_group = true;
628
629 if (!$override_order) $override_order = "last_read DESC";
630
631 /* } else if ($feed == -7) { // shared
632 $query_strategy_part = "uuid != ''";
633 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
634 $allow_archived = true; */
635 } else if ($feed == -3) { // fresh virtual feed
636 $query_strategy_part = "unread = true AND score >= 0";
637
638 $intl = get_pref("FRESH_ARTICLE_MAX_AGE", $owner_uid);
639
640 if (DB_TYPE == "pgsql") {
641 $query_strategy_part .= " AND date_entered > NOW() - INTERVAL '$intl hour' ";
642 } else {
643 $query_strategy_part .= " AND date_entered > DATE_SUB(NOW(), INTERVAL $intl HOUR) ";
644 }
645
646 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
647 } else if ($feed == -4) { // all articles virtual feed
648 $allow_archived = true;
649 $query_strategy_part = "true";
650 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
651 } else if ($feed <= LABEL_BASE_INDEX) { // labels
652 $label_id = feed_to_label_id($feed);
653
654 $query_strategy_part = "label_id = '$label_id' AND
655 ttrss_labels2.id = ttrss_user_labels2.label_id AND
656 ttrss_user_labels2.article_id = ref_id";
657
658 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
659 $ext_tables_part = ",ttrss_labels2,ttrss_user_labels2";
660 $allow_archived = true;
661
662 } else {
663 $query_strategy_part = "true";
664 }
665
666 $order_by = "score DESC, date_entered DESC, updated DESC";
667
668 if ($view_mode == "unread_first") {
669 $order_by = "unread DESC, $order_by";
670 }
671
672 if ($override_order) {
673 $order_by = $override_order;
674 }
675
676 if ($override_strategy) {
677 $query_strategy_part = $override_strategy;
678 }
679
680 if ($override_vfeed) {
681 $vfeed_query_part = $override_vfeed;
682 }
683
684 $feed_title = "";
685
686 if ($search) {
687 $feed_title = T_sprintf("Search results: %s", $search);
688 } else {
689 if ($cat_view) {
690 $feed_title = getCategoryTitle($feed);
691 } else {
692 if (is_numeric($feed) && $feed > 0) {
693 $result = db_query("SELECT title,site_url,last_error,last_updated
694 FROM ttrss_feeds WHERE id = '$feed' AND owner_uid = $owner_uid");
695
696 $feed_title = db_fetch_result($result, 0, "title");
697 $feed_site_url = db_fetch_result($result, 0, "site_url");
698 $last_error = db_fetch_result($result, 0, "last_error");
699 $last_updated = db_fetch_result($result, 0, "last_updated");
700 } else {
701 $feed_title = getFeedTitle($feed);
702 }
703 }
704 }
705
706
707 $content_query_part = "content, ";
708
709
710 if (is_numeric($feed)) {
711
712 if ($feed >= 0) {
713 $feed_kind = "Feeds";
714 } else {
715 $feed_kind = "Labels";
716 }
717
718 if ($limit_query_part) {
719 $offset_query_part = "OFFSET $offset";
720 }
721
722 // proper override_order applied above
723 if ($vfeed_query_part && !$ignore_vfeed_group && get_pref('VFEED_GROUP_BY_FEED', $owner_uid)) {
724 if (!$override_order) {
725 $order_by = "ttrss_feeds.title, $order_by";
726 } else {
727 $order_by = "ttrss_feeds.title, $override_order";
728 }
729 }
730
731 if (!$allow_archived) {
732 $from_qpart = "ttrss_entries,ttrss_user_entries,ttrss_feeds$ext_tables_part";
733 $feed_check_qpart = "ttrss_user_entries.feed_id = ttrss_feeds.id AND";
734
735 } else {
736 $from_qpart = "ttrss_entries$ext_tables_part,ttrss_user_entries
737 LEFT JOIN ttrss_feeds ON (feed_id = ttrss_feeds.id)";
738 }
739
740 if ($vfeed_query_part)
741 $vfeed_query_part .= "favicon_avg_color,";
742
743 if ($start_ts) {
744 $start_ts_formatted = date("Y/m/d H:i:s", strtotime($start_ts));
745 $start_ts_query_part = "date_entered >= '$start_ts_formatted' AND";
746 } else {
747 $start_ts_query_part = "";
748 }
749
750 $query = "SELECT DISTINCT
751 date_entered,
752 guid,
753 ttrss_entries.id,ttrss_entries.title,
754 updated,
755 label_cache,
756 tag_cache,
757 always_display_enclosures,
758 site_url,
759 note,
760 num_comments,
761 comments,
762 int_id,
763 uuid,
764 lang,
765 hide_images,
766 unread,feed_id,marked,published,link,last_read,orig_feed_id,
767 last_marked, last_published,
768 $vfeed_query_part
769 $content_query_part
770 author,score
771 FROM
772 $from_qpart
773 WHERE
774 $feed_check_qpart
775 ttrss_user_entries.ref_id = ttrss_entries.id AND
776 ttrss_user_entries.owner_uid = '$owner_uid' AND
777 $search_query_part
778 $start_ts_query_part
779 $filter_query_part
780 $view_query_part
781 $since_id_part
782 $query_strategy_part ORDER BY $order_by
783 $limit_query_part $offset_query_part";
784
785 if ($_REQUEST["debug"]) print $query;
786
787 $result = db_query($query);
788
789 } else {
790 // browsing by tag
791
792 $select_qpart = "SELECT DISTINCT " .
793 "date_entered," .
794 "guid," .
795 "note," .
796 "ttrss_entries.id as id," .
797 "title," .
798 "updated," .
799 "unread," .
800 "feed_id," .
801 "orig_feed_id," .
802 "marked," .
803 "num_comments, " .
804 "comments, " .
805 "tag_cache," .
806 "label_cache," .
807 "link," .
808 "lang," .
809 "uuid," .
810 "last_read," .
811 "(SELECT hide_images FROM ttrss_feeds WHERE id = feed_id) AS hide_images," .
812 "last_marked, last_published, " .
813 $since_id_part .
814 $vfeed_query_part .
815 $content_query_part .
816 "score ";
817
818 $feed_kind = "Tags";
819 $all_tags = explode(",", $feed);
820 if ($search_mode == 'any') {
821 $tag_sql = "tag_name in (" . implode(", ", array_map("db_quote", $all_tags)) . ")";
822 $from_qpart = " FROM ttrss_entries,ttrss_user_entries,ttrss_tags ";
823 $where_qpart = " WHERE " .
824 "ref_id = ttrss_entries.id AND " .
825 "ttrss_user_entries.owner_uid = $owner_uid AND " .
826 "post_int_id = int_id AND $tag_sql AND " .
827 $view_query_part .
828 $search_query_part .
829 $query_strategy_part . " ORDER BY $order_by " .
830 $limit_query_part;
831
832 } else {
833 $i = 1;
834 $sub_selects = array();
835 $sub_ands = array();
836 foreach ($all_tags as $term) {
837 array_push($sub_selects, "(SELECT post_int_id from ttrss_tags WHERE tag_name = " . db_quote($term) . " AND owner_uid = $owner_uid) as A$i");
838 $i++;
839 }
840 if ($i > 2) {
841 $x = 1;
842 $y = 2;
843 do {
844 array_push($sub_ands, "A$x.post_int_id = A$y.post_int_id");
845 $x++;
846 $y++;
847 } while ($y < $i);
848 }
849 array_push($sub_ands, "A1.post_int_id = ttrss_user_entries.int_id and ttrss_user_entries.owner_uid = $owner_uid");
850 array_push($sub_ands, "ttrss_user_entries.ref_id = ttrss_entries.id");
851 $from_qpart = " FROM " . implode(", ", $sub_selects) . ", ttrss_user_entries, ttrss_entries";
852 $where_qpart = " WHERE " . implode(" AND ", $sub_ands);
853 }
854 // error_log("TAG SQL: " . $tag_sql);
855 // $tag_sql = "tag_name = '$feed'"; DEFAULT way
856
857 // error_log("[". $select_qpart . "][" . $from_qpart . "][" .$where_qpart . "]");
858 $result = db_query($select_qpart . $from_qpart . $where_qpart);
859 }
860
861 return array($result, $feed_title, $feed_site_url, $last_error, $last_updated, $search_words);
862
863 }
864
865 function iframe_whitelisted($entry) {
866 $whitelist = array("youtube.com", "youtu.be", "vimeo.com");
867
868 @$src = parse_url($entry->getAttribute("src"), PHP_URL_HOST);
869
870 if ($src) {
871 foreach ($whitelist as $w) {
872 if ($src == $w || $src == "www.$w")
873 return true;
874 }
875 }
876
877 return false;
878 }
879
880 function sanitize($str, $force_remove_images = false, $owner = false, $site_url = false, $highlight_words = false, $article_id = false) {
881 if (!$owner) $owner = $_SESSION["uid"];
882
883 $res = trim($str); if (!$res) return '';
884
885 $charset_hack = '<head>
886 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
887 </head>';
888
889 $res = trim($res); if (!$res) return '';
890
891 libxml_use_internal_errors(true);
892
893 $doc = new DOMDocument();
894 $doc->loadHTML($charset_hack . $res);
895 $xpath = new DOMXPath($doc);
896
897 $entries = $xpath->query('(//a[@href]|//img[@src])');
898
899 foreach ($entries as $entry) {
900
901 if ($site_url) {
902
903 if ($entry->hasAttribute('href')) {
904 $entry->setAttribute('href',
905 rewrite_relative_url($site_url, $entry->getAttribute('href')));
906
907 $entry->setAttribute('rel', 'noreferrer');
908 }
909
910 if ($entry->hasAttribute('src')) {
911 $src = rewrite_relative_url($site_url, $entry->getAttribute('src'));
912
913 $cached_filename = CACHE_DIR . '/images/' . sha1($src) . '.png';
914
915 if (file_exists($cached_filename)) {
916 $src = SELF_URL_PATH . '/public.php?op=cached_image&hash=' . sha1($src);
917 }
918
919 $entry->setAttribute('src', $src);
920 }
921
922 if ($entry->nodeName == 'img') {
923 if (($owner && get_pref("STRIP_IMAGES", $owner)) ||
924 $force_remove_images || $_SESSION["bw_limit"]) {
925
926 $p = $doc->createElement('p');
927
928 $a = $doc->createElement('a');
929 $a->setAttribute('href', $entry->getAttribute('src'));
930
931 $a->appendChild(new DOMText($entry->getAttribute('src')));
932 $a->setAttribute('target', '_blank');
933
934 $p->appendChild($a);
935
936 $entry->parentNode->replaceChild($p, $entry);
937 }
938 }
939 }
940
941 if (strtolower($entry->nodeName) == "a") {
942 $entry->setAttribute("target", "_blank");
943 }
944 }
945
946 $entries = $xpath->query('//iframe');
947 foreach ($entries as $entry) {
948 if (!iframe_whitelisted($entry)) {
949 $entry->setAttribute('sandbox', 'allow-scripts');
950 } else {
951 if ($_SERVER['HTTPS'] == "on") {
952 $entry->setAttribute("src",
953 str_replace("http://", "https://",
954 $entry->getAttribute("src")));
955 }
956 }
957 }
958
959 $allowed_elements = array('a', 'address', 'audio', 'article', 'aside',
960 'b', 'bdi', 'bdo', 'big', 'blockquote', 'body', 'br',
961 'caption', 'cite', 'center', 'code', 'col', 'colgroup',
962 'data', 'dd', 'del', 'details', 'div', 'dl', 'font',
963 'dt', 'em', 'footer', 'figure', 'figcaption',
964 'h1', 'h2', 'h3', 'h4', 'h5', 'h6', 'header', 'html', 'i',
965 'img', 'ins', 'kbd', 'li', 'main', 'mark', 'nav', 'noscript',
966 'ol', 'p', 'pre', 'q', 'ruby', 'rp', 'rt', 's', 'samp', 'section',
967 'small', 'source', 'span', 'strike', 'strong', 'sub', 'summary',
968 'sup', 'table', 'tbody', 'td', 'tfoot', 'th', 'thead', 'time',
969 'tr', 'track', 'tt', 'u', 'ul', 'var', 'wbr', 'video' );
970
971 if ($_SESSION['hasSandbox']) $allowed_elements[] = 'iframe';
972
973 $disallowed_attributes = array('id', 'style', 'class');
974
975 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_SANITIZE) as $plugin) {
976 $retval = $plugin->hook_sanitize($doc, $site_url, $allowed_elements, $disallowed_attributes, $article_id);
977 if (is_array($retval)) {
978 $doc = $retval[0];
979 $allowed_elements = $retval[1];
980 $disallowed_attributes = $retval[2];
981 } else {
982 $doc = $retval;
983 }
984 }
985
986 $doc->removeChild($doc->firstChild); //remove doctype
987 $doc = strip_harmful_tags($doc, $allowed_elements, $disallowed_attributes);
988
989 if ($highlight_words) {
990 foreach ($highlight_words as $word) {
991
992 // http://stackoverflow.com/questions/4081372/highlight-keywords-in-a-paragraph
993
994 $elements = $xpath->query("//*/text()");
995
996 foreach ($elements as $child) {
997
998 $fragment = $doc->createDocumentFragment();
999 $text = $child->textContent;
1000
1001 while (($pos = mb_stripos($text, $word)) !== false) {
1002 $fragment->appendChild(new DomText(mb_substr($text, 0, $pos)));
1003 $word = mb_substr($text, $pos, mb_strlen($word));
1004 $highlight = $doc->createElement('span');
1005 $highlight->appendChild(new DomText($word));
1006 $highlight->setAttribute('class', 'highlight');
1007 $fragment->appendChild($highlight);
1008 $text = mb_substr($text, $pos + mb_strlen($word));
1009 }
1010
1011 if (!empty($text)) $fragment->appendChild(new DomText($text));
1012
1013 $child->parentNode->replaceChild($fragment, $child);
1014 }
1015 }
1016 }
1017
1018 $res = $doc->saveHTML();
1019
1020 return $res;
1021 }
1022
1023 function strip_harmful_tags($doc, $allowed_elements, $disallowed_attributes) {
1024 $xpath = new DOMXPath($doc);
1025 $entries = $xpath->query('//*');
1026
1027 foreach ($entries as $entry) {
1028 if (!in_array($entry->nodeName, $allowed_elements)) {
1029 $entry->parentNode->removeChild($entry);
1030 }
1031
1032 if ($entry->hasAttributes()) {
1033 $attrs_to_remove = array();
1034
1035 foreach ($entry->attributes as $attr) {
1036
1037 if (strpos($attr->nodeName, 'on') === 0) {
1038 array_push($attrs_to_remove, $attr);
1039 }
1040
1041 if (in_array($attr->nodeName, $disallowed_attributes)) {
1042 array_push($attrs_to_remove, $attr);
1043 }
1044 }
1045
1046 foreach ($attrs_to_remove as $attr) {
1047 $entry->removeAttributeNode($attr);
1048 }
1049 }
1050 }
1051
1052 return $doc;
1053 }
1054
1055 function catchupArticlesById($ids, $cmode, $owner_uid = false) {
1056
1057 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
1058 if (count($ids) == 0) return;
1059
1060 $tmp_ids = array();
1061
1062 foreach ($ids as $id) {
1063 array_push($tmp_ids, "ref_id = '$id'");
1064 }
1065
1066 $ids_qpart = join(" OR ", $tmp_ids);
1067
1068 if ($cmode == 0) {
1069 db_query("UPDATE ttrss_user_entries SET
1070 unread = false,last_read = NOW()
1071 WHERE ($ids_qpart) AND owner_uid = $owner_uid");
1072 } else if ($cmode == 1) {
1073 db_query("UPDATE ttrss_user_entries SET
1074 unread = true
1075 WHERE ($ids_qpart) AND owner_uid = $owner_uid");
1076 } else {
1077 db_query("UPDATE ttrss_user_entries SET
1078 unread = NOT unread,last_read = NOW()
1079 WHERE ($ids_qpart) AND owner_uid = $owner_uid");
1080 }
1081
1082 /* update ccache */
1083
1084 $result = db_query("SELECT DISTINCT feed_id FROM ttrss_user_entries
1085 WHERE ($ids_qpart) AND owner_uid = $owner_uid");
1086
1087 while ($line = db_fetch_assoc($result)) {
1088 ccache_update($line["feed_id"], $owner_uid);
1089 }
1090 }
1091
1092 function get_article_tags($id, $owner_uid = 0, $tag_cache = false) {
1093
1094 $a_id = db_escape_string($id);
1095
1096 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
1097
1098 $query = "SELECT DISTINCT tag_name,
1099 owner_uid as owner FROM
1100 ttrss_tags WHERE post_int_id = (SELECT int_id FROM ttrss_user_entries WHERE
1101 ref_id = '$a_id' AND owner_uid = '$owner_uid' LIMIT 1) ORDER BY tag_name";
1102
1103 $tags = array();
1104
1105 /* check cache first */
1106
1107 if ($tag_cache === false) {
1108 $result = db_query("SELECT tag_cache FROM ttrss_user_entries
1109 WHERE ref_id = '$id' AND owner_uid = $owner_uid");
1110
1111 $tag_cache = db_fetch_result($result, 0, "tag_cache");
1112 }
1113
1114 if ($tag_cache) {
1115 $tags = explode(",", $tag_cache);
1116 } else {
1117
1118 /* do it the hard way */
1119
1120 $tmp_result = db_query($query);
1121
1122 while ($tmp_line = db_fetch_assoc($tmp_result)) {
1123 array_push($tags, $tmp_line["tag_name"]);
1124 }
1125
1126 /* update the cache */
1127
1128 $tags_str = db_escape_string(join(",", $tags));
1129
1130 db_query("UPDATE ttrss_user_entries
1131 SET tag_cache = '$tags_str' WHERE ref_id = '$id'
1132 AND owner_uid = $owner_uid");
1133 }
1134
1135 return $tags;
1136 }
1137
1138 function trim_array($array) {
1139 $tmp = $array;
1140 array_walk($tmp, 'trim');
1141 return $tmp;
1142 }
1143
1144 function tag_is_valid($tag) {
1145 if ($tag == '') return false;
1146 if (preg_match("/^[0-9]*$/", $tag)) return false;
1147 if (mb_strlen($tag) > 250) return false;
1148
1149 if (!$tag) return false;
1150
1151 return true;
1152 }
1153
1154 function render_login_form() {
1155 header('Cache-Control: public');
1156
1157 require_once "login_form.php";
1158 exit;
1159 }
1160
1161 function format_warning($msg, $id = "") {
1162 return "<div class=\"warning\" id=\"$id\">
1163 <span><img src=\"images/alert.png\"></span><span>$msg</span></div>";
1164 }
1165
1166 function format_notice($msg, $id = "") {
1167 return "<div class=\"notice\" id=\"$id\">
1168 <span><img src=\"images/information.png\"></span><span>$msg</span></div>";
1169 }
1170
1171 function format_error($msg, $id = "") {
1172 return "<div class=\"error\" id=\"$id\">
1173 <span><img src=\"images/alert.png\"></span><span>$msg</span></div>";
1174 }
1175
1176 function print_notice($msg) {
1177 return print format_notice($msg);
1178 }
1179
1180 function print_warning($msg) {
1181 return print format_warning($msg);
1182 }
1183
1184 function print_error($msg) {
1185 return print format_error($msg);
1186 }
1187
1188
1189 function T_sprintf() {
1190 $args = func_get_args();
1191 return vsprintf(__(array_shift($args)), $args);
1192 }
1193
1194 function format_inline_player($url, $ctype) {
1195
1196 $entry = "";
1197
1198 $url = htmlspecialchars($url);
1199
1200 if (strpos($ctype, "audio/") === 0) {
1201
1202 if ($_SESSION["hasAudio"] && (strpos($ctype, "ogg") !== false ||
1203 $_SESSION["hasMp3"])) {
1204
1205 $entry .= "<audio preload=\"none\" controls>
1206 <source type=\"$ctype\" src=\"$url\"></source>
1207 </audio>";
1208
1209 } else {
1210
1211 $entry .= "<object type=\"application/x-shockwave-flash\"
1212 data=\"lib/button/musicplayer.swf?song_url=$url\"
1213 width=\"17\" height=\"17\" style='float : left; margin-right : 5px;'>
1214 <param name=\"movie\"
1215 value=\"lib/button/musicplayer.swf?song_url=$url\" />
1216 </object>";
1217 }
1218
1219 if ($entry) $entry .= "&nbsp; <a target=\"_blank\"
1220 href=\"$url\">" . basename($url) . "</a>";
1221
1222 return $entry;
1223
1224 }
1225
1226 return "";
1227
1228 /* $filename = substr($url, strrpos($url, "/")+1);
1229
1230 $entry .= " <a target=\"_blank\" href=\"" . htmlspecialchars($url) . "\">" .
1231 $filename . " (" . $ctype . ")" . "</a>"; */
1232
1233 }
1234
1235 function format_article($id, $mark_as_read = true, $zoom_mode = false, $owner_uid = false) {
1236 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
1237
1238 $rv = array();
1239
1240 $rv['id'] = $id;
1241
1242 /* we can figure out feed_id from article id anyway, why do we
1243 * pass feed_id here? let's ignore the argument :(*/
1244
1245 $result = db_query("SELECT feed_id FROM ttrss_user_entries
1246 WHERE ref_id = '$id'");
1247
1248 $feed_id = (int) db_fetch_result($result, 0, "feed_id");
1249
1250 $rv['feed_id'] = $feed_id;
1251
1252 //if (!$zoom_mode) { print "<article id='$id'><![CDATA["; };
1253
1254 if ($mark_as_read) {
1255 $result = db_query("UPDATE ttrss_user_entries
1256 SET unread = false,last_read = NOW()
1257 WHERE ref_id = '$id' AND owner_uid = $owner_uid");
1258
1259 ccache_update($feed_id, $owner_uid);
1260 }
1261
1262 $result = db_query("SELECT id,title,link,content,feed_id,comments,int_id,lang,
1263 ".SUBSTRING_FOR_DATE."(updated,1,16) as updated,
1264 (SELECT site_url FROM ttrss_feeds WHERE id = feed_id) as site_url,
1265 (SELECT title FROM ttrss_feeds WHERE id = feed_id) as feed_title,
1266 (SELECT hide_images FROM ttrss_feeds WHERE id = feed_id) as hide_images,
1267 (SELECT always_display_enclosures FROM ttrss_feeds WHERE id = feed_id) as always_display_enclosures,
1268 num_comments,
1269 tag_cache,
1270 author,
1271 orig_feed_id,
1272 note
1273 FROM ttrss_entries,ttrss_user_entries
1274 WHERE id = '$id' AND ref_id = id AND owner_uid = $owner_uid");
1275
1276 if ($result) {
1277
1278 $line = db_fetch_assoc($result);
1279
1280 $line["tags"] = get_article_tags($id, $owner_uid, $line["tag_cache"]);
1281 unset($line["tag_cache"]);
1282
1283 $line["content"] = sanitize($line["content"],
1284 sql_bool_to_bool($line['hide_images']),
1285 $owner_uid, $line["site_url"], false, $line["id"]);
1286
1287 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_RENDER_ARTICLE) as $p) {
1288 $line = $p->hook_render_article($line);
1289 }
1290
1291 $num_comments = $line["num_comments"];
1292 $entry_comments = "";
1293
1294 if ($num_comments > 0) {
1295 if ($line["comments"]) {
1296 $comments_url = htmlspecialchars($line["comments"]);
1297 } else {
1298 $comments_url = htmlspecialchars($line["link"]);
1299 }
1300 $entry_comments = "<a class=\"postComments\"
1301 target='_blank' href=\"$comments_url\">$num_comments ".
1302 _ngettext("comment", "comments", $num_comments)."</a>";
1303
1304 } else {
1305 if ($line["comments"] && $line["link"] != $line["comments"]) {
1306 $entry_comments = "<a class=\"postComments\" target='_blank' href=\"".htmlspecialchars($line["comments"])."\">".__("comments")."</a>";
1307 }
1308 }
1309
1310 if ($zoom_mode) {
1311 header("Content-Type: text/html");
1312 $rv['content'] .= "<html><head>
1313 <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"/>
1314 <title>Tiny Tiny RSS - ".$line["title"]."</title>".
1315 stylesheet_tag("css/tt-rss.css").
1316 stylesheet_tag("css/zoom.css").
1317 stylesheet_tag("css/dijit.css")."
1318
1319 <link rel=\"shortcut icon\" type=\"image/png\" href=\"images/favicon.png\">
1320 <link rel=\"icon\" type=\"image/png\" sizes=\"72x72\" href=\"images/favicon-72px.png\">
1321
1322 <script type=\"text/javascript\">
1323 function openSelectedAttachment(elem) {
1324 try {
1325 var url = elem[elem.selectedIndex].value;
1326
1327 if (url) {
1328 window.open(url);
1329 elem.selectedIndex = 0;
1330 }
1331
1332 } catch (e) {
1333 exception_error(\"openSelectedAttachment\", e);
1334 }
1335 }
1336 </script>
1337 </head><body id=\"ttrssZoom\">";
1338 }
1339
1340 $rv['content'] .= "<div class=\"postReply\" id=\"POST-$id\">";
1341
1342 $rv['content'] .= "<div class=\"postHeader\" id=\"POSTHDR-$id\">";
1343
1344 $entry_author = $line["author"];
1345
1346 if ($entry_author) {
1347 $entry_author = __(" - ") . $entry_author;
1348 }
1349
1350 $parsed_updated = make_local_datetime($line["updated"], true,
1351 $owner_uid, true);
1352
1353 if (!$zoom_mode)
1354 $rv['content'] .= "<div class=\"postDate\">$parsed_updated</div>";
1355
1356 if ($line["link"]) {
1357 $rv['content'] .= "<div class='postTitle'><a target='_blank'
1358 title=\"".htmlspecialchars($line['title'])."\"
1359 href=\"" .
1360 htmlspecialchars($line["link"]) . "\">" .
1361 $line["title"] . "</a>" .
1362 "<span class='author'>$entry_author</span></div>";
1363 } else {
1364 $rv['content'] .= "<div class='postTitle'>" . $line["title"] . "$entry_author</div>";
1365 }
1366
1367 if ($zoom_mode) {
1368 $feed_title = "<a href=\"".htmlspecialchars($line["site_url"]).
1369 "\" target=\"_blank\">".
1370 htmlspecialchars($line["feed_title"])."</a>";
1371
1372 $rv['content'] .= "<div class=\"postFeedTitle\">$feed_title</div>";
1373
1374 $rv['content'] .= "<div class=\"postDate\">$parsed_updated</div>";
1375 }
1376
1377 $tags_str = format_tags_string($line["tags"], $id);
1378 $tags_str_full = join(", ", $line["tags"]);
1379
1380 if (!$tags_str_full) $tags_str_full = __("no tags");
1381
1382 if (!$entry_comments) $entry_comments = "&nbsp;"; # placeholder
1383
1384 $rv['content'] .= "<div class='postTags' style='float : right'>
1385 <img src='images/tag.png'
1386 class='tagsPic' alt='Tags' title='Tags'>&nbsp;";
1387
1388 if (!$zoom_mode) {
1389 $rv['content'] .= "<span id=\"ATSTR-$id\">$tags_str</span>
1390 <a title=\"".__('Edit tags for this article')."\"
1391 href=\"#\" onclick=\"editArticleTags($id, $feed_id)\">(+)</a>";
1392
1393 $rv['content'] .= "<div dojoType=\"dijit.Tooltip\"
1394 id=\"ATSTRTIP-$id\" connectId=\"ATSTR-$id\"
1395 position=\"below\">$tags_str_full</div>";
1396
1397 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_ARTICLE_BUTTON) as $p) {
1398 $rv['content'] .= $p->hook_article_button($line);
1399 }
1400
1401 } else {
1402 $tags_str = strip_tags($tags_str);
1403 $rv['content'] .= "<span id=\"ATSTR-$id\">$tags_str</span>";
1404 }
1405 $rv['content'] .= "</div>";
1406 $rv['content'] .= "<div clear='both'>";
1407
1408 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_ARTICLE_LEFT_BUTTON) as $p) {
1409 $rv['content'] .= $p->hook_article_left_button($line);
1410 }
1411
1412 $rv['content'] .= "$entry_comments</div>";
1413
1414 if ($line["orig_feed_id"]) {
1415
1416 $tmp_result = db_query("SELECT * FROM ttrss_archived_feeds
1417 WHERE id = ".$line["orig_feed_id"]);
1418
1419 if (db_num_rows($tmp_result) != 0) {
1420
1421 $rv['content'] .= "<div clear='both'>";
1422 $rv['content'] .= __("Originally from:");
1423
1424 $rv['content'] .= "&nbsp;";
1425
1426 $tmp_line = db_fetch_assoc($tmp_result);
1427
1428 $rv['content'] .= "<a target='_blank'
1429 href=' " . htmlspecialchars($tmp_line['site_url']) . "'>" .
1430 $tmp_line['title'] . "</a>";
1431
1432 $rv['content'] .= "&nbsp;";
1433
1434 $rv['content'] .= "<a target='_blank' href='" . htmlspecialchars($tmp_line['feed_url']) . "'>";
1435 $rv['content'] .= "<img title='".__('Feed URL')."' class='tinyFeedIcon' src='images/pub_set.png'></a>";
1436
1437 $rv['content'] .= "</div>";
1438 }
1439 }
1440
1441 $rv['content'] .= "</div>";
1442
1443 $rv['content'] .= "<div id=\"POSTNOTE-$id\">";
1444 if ($line['note']) {
1445 $rv['content'] .= format_article_note($id, $line['note'], !$zoom_mode);
1446 }
1447 $rv['content'] .= "</div>";
1448
1449 if (!$line['lang']) $line['lang'] = 'en';
1450
1451 $rv['content'] .= "<div class=\"postContent\" lang=\"".$line['lang']."\">";
1452
1453 $rv['content'] .= $line["content"];
1454 $rv['content'] .= format_article_enclosures($id,
1455 sql_bool_to_bool($line["always_display_enclosures"]),
1456 $line["content"],
1457 sql_bool_to_bool($line["hide_images"]));
1458
1459 $rv['content'] .= "</div>";
1460
1461 $rv['content'] .= "</div>";
1462
1463 }
1464
1465 if ($zoom_mode) {
1466 $rv['content'] .= "
1467 <div class='footer'>
1468 <button onclick=\"return window.close()\">".
1469 __("Close this window")."</button></div>";
1470 $rv['content'] .= "</body></html>";
1471 }
1472
1473 return $rv;
1474
1475 }
1476
1477 function print_checkpoint($n, $s) {
1478 $ts = microtime(true);
1479 echo sprintf("<!-- CP[$n] %.4f seconds -->\n", $ts - $s);
1480 return $ts;
1481 }
1482
1483 function sanitize_tag($tag) {
1484 $tag = trim($tag);
1485
1486 $tag = mb_strtolower($tag, 'utf-8');
1487
1488 $tag = preg_replace('/[\'\"\+\>\<]/', "", $tag);
1489
1490 // $tag = str_replace('"', "", $tag);
1491 // $tag = str_replace("+", " ", $tag);
1492 $tag = str_replace("technorati tag: ", "", $tag);
1493
1494 return $tag;
1495 }
1496
1497 function get_self_url_prefix() {
1498 if (strrpos(SELF_URL_PATH, "/") === strlen(SELF_URL_PATH)-1) {
1499 return substr(SELF_URL_PATH, 0, strlen(SELF_URL_PATH)-1);
1500 } else {
1501 return SELF_URL_PATH;
1502 }
1503 }
1504
1505 /**
1506 * Compute the Mozilla Firefox feed adding URL from server HOST and REQUEST_URI.
1507 *
1508 * @return string The Mozilla Firefox feed adding URL.
1509 */
1510 function add_feed_url() {
1511 //$url_path = ($_SERVER['HTTPS'] != "on" ? 'http://' : 'https://') . $_SERVER["HTTP_HOST"] . parse_url($_SERVER["REQUEST_URI"], PHP_URL_PATH);
1512
1513 $url_path = get_self_url_prefix() .
1514 "/public.php?op=subscribe&feed_url=%s";
1515 return $url_path;
1516 } // function add_feed_url
1517
1518 function encrypt_password($pass, $salt = '', $mode2 = false) {
1519 if ($salt && $mode2) {
1520 return "MODE2:" . hash('sha256', $salt . $pass);
1521 } else if ($salt) {
1522 return "SHA1X:" . sha1("$salt:$pass");
1523 } else {
1524 return "SHA1:" . sha1($pass);
1525 }
1526 } // function encrypt_password
1527
1528 function load_filters($feed_id, $owner_uid, $action_id = false) {
1529 $filters = array();
1530
1531 $cat_id = (int)getFeedCategory($feed_id);
1532
1533 if ($cat_id == 0)
1534 $null_cat_qpart = "cat_id IS NULL OR";
1535 else
1536 $null_cat_qpart = "";
1537
1538 $result = db_query("SELECT * FROM ttrss_filters2 WHERE
1539 owner_uid = $owner_uid AND enabled = true ORDER BY order_id, title");
1540
1541 $check_cats = join(",", array_merge(
1542 getParentCategories($cat_id, $owner_uid),
1543 array($cat_id)));
1544
1545 while ($line = db_fetch_assoc($result)) {
1546 $filter_id = $line["id"];
1547
1548 $result2 = db_query("SELECT
1549 r.reg_exp, r.inverse, r.feed_id, r.cat_id, r.cat_filter, t.name AS type_name
1550 FROM ttrss_filters2_rules AS r,
1551 ttrss_filter_types AS t
1552 WHERE
1553 ($null_cat_qpart (cat_id IS NULL AND cat_filter = false) OR cat_id IN ($check_cats)) AND
1554 (feed_id IS NULL OR feed_id = '$feed_id') AND
1555 filter_type = t.id AND filter_id = '$filter_id'");
1556
1557 $rules = array();
1558 $actions = array();
1559
1560 while ($rule_line = db_fetch_assoc($result2)) {
1561 # print_r($rule_line);
1562
1563 $rule = array();
1564 $rule["reg_exp"] = $rule_line["reg_exp"];
1565 $rule["type"] = $rule_line["type_name"];
1566 $rule["inverse"] = sql_bool_to_bool($rule_line["inverse"]);
1567
1568 array_push($rules, $rule);
1569 }
1570
1571 $result2 = db_query("SELECT a.action_param,t.name AS type_name
1572 FROM ttrss_filters2_actions AS a,
1573 ttrss_filter_actions AS t
1574 WHERE
1575 action_id = t.id AND filter_id = '$filter_id'");
1576
1577 while ($action_line = db_fetch_assoc($result2)) {
1578 # print_r($action_line);
1579
1580 $action = array();
1581 $action["type"] = $action_line["type_name"];
1582 $action["param"] = $action_line["action_param"];
1583
1584 array_push($actions, $action);
1585 }
1586
1587
1588 $filter = array();
1589 $filter["match_any_rule"] = sql_bool_to_bool($line["match_any_rule"]);
1590 $filter["inverse"] = sql_bool_to_bool($line["inverse"]);
1591 $filter["rules"] = $rules;
1592 $filter["actions"] = $actions;
1593
1594 if (count($rules) > 0 && count($actions) > 0) {
1595 array_push($filters, $filter);
1596 }
1597 }
1598
1599 return $filters;
1600 }
1601
1602 function get_score_pic($score) {
1603 if ($score > 100) {
1604 return "score_high.png";
1605 } else if ($score > 0) {
1606 return "score_half_high.png";
1607 } else if ($score < -100) {
1608 return "score_low.png";
1609 } else if ($score < 0) {
1610 return "score_half_low.png";
1611 } else {
1612 return "score_neutral.png";
1613 }
1614 }
1615
1616 function feed_has_icon($id) {
1617 return is_file(ICONS_DIR . "/$id.ico") && filesize(ICONS_DIR . "/$id.ico") > 0;
1618 }
1619
1620 function init_plugins() {
1621 PluginHost::getInstance()->load(PLUGINS, PluginHost::KIND_ALL);
1622
1623 return true;
1624 }
1625
1626 function format_tags_string($tags, $id) {
1627 if (!is_array($tags) || count($tags) == 0) {
1628 return __("no tags");
1629 } else {
1630 $maxtags = min(5, count($tags));
1631
1632 for ($i = 0; $i < $maxtags; $i++) {
1633 $tags_str .= "<a class=\"tag\" href=\"#\" onclick=\"viewfeed('".$tags[$i]."')\">" . $tags[$i] . "</a>, ";
1634 }
1635
1636 $tags_str = mb_substr($tags_str, 0, mb_strlen($tags_str)-2);
1637
1638 if (count($tags) > $maxtags)
1639 $tags_str .= ", &hellip;";
1640
1641 return $tags_str;
1642 }
1643 }
1644
1645 function format_article_labels($labels, $id) {
1646
1647 if (!is_array($labels)) return '';
1648
1649 $labels_str = "";
1650
1651 foreach ($labels as $l) {
1652 $labels_str .= sprintf("<span class='hlLabelRef'
1653 style='color : %s; background-color : %s'>%s</span>",
1654 $l[2], $l[3], $l[1]);
1655 }
1656
1657 return $labels_str;
1658
1659 }
1660
1661 function format_article_note($id, $note, $allow_edit = true) {
1662
1663 $str = "<div class='articleNote' onclick=\"editArticleNote($id)\">
1664 <div class='noteEdit' onclick=\"editArticleNote($id)\">".
1665 ($allow_edit ? __('(edit note)') : "")."</div>$note</div>";
1666
1667 return $str;
1668 }
1669
1670
1671 function get_feed_category($feed_cat, $parent_cat_id = false) {
1672 if ($parent_cat_id) {
1673 $parent_qpart = "parent_cat = '$parent_cat_id'";
1674 $parent_insert = "'$parent_cat_id'";
1675 } else {
1676 $parent_qpart = "parent_cat IS NULL";
1677 $parent_insert = "NULL";
1678 }
1679
1680 $result = db_query(
1681 "SELECT id FROM ttrss_feed_categories
1682 WHERE $parent_qpart AND title = '$feed_cat' AND owner_uid = ".$_SESSION["uid"]);
1683
1684 if (db_num_rows($result) == 0) {
1685 return false;
1686 } else {
1687 return db_fetch_result($result, 0, "id");
1688 }
1689 }
1690
1691 function add_feed_category($feed_cat, $parent_cat_id = false) {
1692
1693 if (!$feed_cat) return false;
1694
1695 db_query("BEGIN");
1696
1697 if ($parent_cat_id) {
1698 $parent_qpart = "parent_cat = '$parent_cat_id'";
1699 $parent_insert = "'$parent_cat_id'";
1700 } else {
1701 $parent_qpart = "parent_cat IS NULL";
1702 $parent_insert = "NULL";
1703 }
1704
1705 $feed_cat = mb_substr($feed_cat, 0, 250);
1706
1707 $result = db_query(
1708 "SELECT id FROM ttrss_feed_categories
1709 WHERE $parent_qpart AND title = '$feed_cat' AND owner_uid = ".$_SESSION["uid"]);
1710
1711 if (db_num_rows($result) == 0) {
1712
1713 $result = db_query(
1714 "INSERT INTO ttrss_feed_categories (owner_uid,title,parent_cat)
1715 VALUES ('".$_SESSION["uid"]."', '$feed_cat', $parent_insert)");
1716
1717 db_query("COMMIT");
1718
1719 return true;
1720 }
1721
1722 return false;
1723 }
1724
1725 function getArticleFeed($id) {
1726 $result = db_query("SELECT feed_id FROM ttrss_user_entries
1727 WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]);
1728
1729 if (db_num_rows($result) != 0) {
1730 return db_fetch_result($result, 0, "feed_id");
1731 } else {
1732 return 0;
1733 }
1734 }
1735
1736 /**
1737 * Fixes incomplete URLs by prepending "http://".
1738 * Also replaces feed:// with http://, and
1739 * prepends a trailing slash if the url is a domain name only.
1740 *
1741 * @param string $url Possibly incomplete URL
1742 *
1743 * @return string Fixed URL.
1744 */
1745 function fix_url($url) {
1746 if (strpos($url, '://') === false) {
1747 $url = 'http://' . $url;
1748 } else if (substr($url, 0, 5) == 'feed:') {
1749 $url = 'http:' . substr($url, 5);
1750 }
1751
1752 //prepend slash if the URL has no slash in it
1753 // "http://www.example" -> "http://www.example/"
1754 if (strpos($url, '/', strpos($url, ':') + 3) === false) {
1755 $url .= '/';
1756 }
1757
1758 if ($url != "http:///")
1759 return $url;
1760 else
1761 return '';
1762 }
1763
1764 function validate_feed_url($url) {
1765 $parts = parse_url($url);
1766
1767 return ($parts['scheme'] == 'http' || $parts['scheme'] == 'feed' || $parts['scheme'] == 'https');
1768
1769 }
1770
1771 function get_article_enclosures($id) {
1772
1773 $query = "SELECT * FROM ttrss_enclosures
1774 WHERE post_id = '$id' AND content_url != ''";
1775
1776 $rv = array();
1777
1778 $result = db_query($query);
1779
1780 if (db_num_rows($result) > 0) {
1781 while ($line = db_fetch_assoc($result)) {
1782 array_push($rv, $line);
1783 }
1784 }
1785
1786 return $rv;
1787 }
1788
1789 /* function save_email_address($email) {
1790 // FIXME: implement persistent storage of emails
1791
1792 if (!$_SESSION['stored_emails'])
1793 $_SESSION['stored_emails'] = array();
1794
1795 if (!in_array($email, $_SESSION['stored_emails']))
1796 array_push($_SESSION['stored_emails'], $email);
1797 } */
1798
1799
1800 function get_feed_access_key($feed_id, $is_cat, $owner_uid = false) {
1801
1802 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
1803
1804 $sql_is_cat = bool_to_sql_bool($is_cat);
1805
1806 $result = db_query("SELECT access_key FROM ttrss_access_keys
1807 WHERE feed_id = '$feed_id' AND is_cat = $sql_is_cat
1808 AND owner_uid = " . $owner_uid);
1809
1810 if (db_num_rows($result) == 1) {
1811 return db_fetch_result($result, 0, "access_key");
1812 } else {
1813 $key = db_escape_string(uniqid(base_convert(rand(), 10, 36)));
1814
1815 $result = db_query("INSERT INTO ttrss_access_keys
1816 (access_key, feed_id, is_cat, owner_uid)
1817 VALUES ('$key', '$feed_id', $sql_is_cat, '$owner_uid')");
1818
1819 return $key;
1820 }
1821 return false;
1822 }
1823
1824 function get_feeds_from_html($url, $content)
1825 {
1826 $url = fix_url($url);
1827 $baseUrl = substr($url, 0, strrpos($url, '/') + 1);
1828
1829 libxml_use_internal_errors(true);
1830
1831 $doc = new DOMDocument();
1832 $doc->loadHTML($content);
1833 $xpath = new DOMXPath($doc);
1834 $entries = $xpath->query('/html/head/link[@rel="alternate" and '.
1835 '(contains(@type,"rss") or contains(@type,"atom"))]|/html/head/link[@rel="feed"]');
1836 $feedUrls = array();
1837 foreach ($entries as $entry) {
1838 if ($entry->hasAttribute('href')) {
1839 $title = $entry->getAttribute('title');
1840 if ($title == '') {
1841 $title = $entry->getAttribute('type');
1842 }
1843 $feedUrl = rewrite_relative_url(
1844 $baseUrl, $entry->getAttribute('href')
1845 );
1846 $feedUrls[$feedUrl] = $title;
1847 }
1848 }
1849 return $feedUrls;
1850 }
1851
1852 function is_html($content) {
1853 return preg_match("/<html|DOCTYPE html/i", substr($content, 0, 20)) !== 0;
1854 }
1855
1856 function url_is_html($url, $login = false, $pass = false) {
1857 return is_html(fetch_file_contents($url, false, $login, $pass));
1858 }
1859
1860 function print_label_select($name, $value, $attributes = "") {
1861
1862 $result = db_query("SELECT caption FROM ttrss_labels2
1863 WHERE owner_uid = '".$_SESSION["uid"]."' ORDER BY caption");
1864
1865 print "<select default=\"$value\" name=\"" . htmlspecialchars($name) .
1866 "\" $attributes onchange=\"labelSelectOnChange(this)\" >";
1867
1868 while ($line = db_fetch_assoc($result)) {
1869
1870 $issel = ($line["caption"] == $value) ? "selected=\"1\"" : "";
1871
1872 print "<option value=\"".htmlspecialchars($line["caption"])."\"
1873 $issel>" . htmlspecialchars($line["caption"]) . "</option>";
1874
1875 }
1876
1877 # print "<option value=\"ADD_LABEL\">" .__("Add label...") . "</option>";
1878
1879 print "</select>";
1880
1881
1882 }
1883
1884 function format_article_enclosures($id, $always_display_enclosures,
1885 $article_content, $hide_images = false) {
1886
1887 $result = get_article_enclosures($id);
1888 $rv = '';
1889
1890 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_FORMAT_ENCLOSURES) as $plugin) {
1891 $retval = $plugin->hook_format_enclosures($rv, $result, $id, $always_display_enclosures, $article_content, $hide_images);
1892 if (is_array($retval)) {
1893 $rv = $retval[0];
1894 $result = $retval[1];
1895 } else {
1896 $rv = $retval;
1897 }
1898 }
1899
1900 if ($rv === '' && !empty($result)) {
1901 $entries_html = array();
1902 $entries = array();
1903 $entries_inline = array();
1904
1905 foreach ($result as $line) {
1906
1907 $url = $line["content_url"];
1908 $ctype = $line["content_type"];
1909 $title = $line["title"];
1910 $width = $line["width"];
1911 $height = $line["height"];
1912
1913 if (!$ctype) $ctype = __("unknown type");
1914
1915 $filename = substr($url, strrpos($url, "/")+1);
1916
1917 $player = format_inline_player($url, $ctype);
1918
1919 if ($player) array_push($entries_inline, $player);
1920
1921 # $entry .= " <a target=\"_blank\" href=\"" . htmlspecialchars($url) . "\">" .
1922 # $filename . " (" . $ctype . ")" . "</a>";
1923
1924 $entry = "<div onclick=\"window.open('".htmlspecialchars($url)."')\"
1925 dojoType=\"dijit.MenuItem\">$filename ($ctype)</div>";
1926
1927 array_push($entries_html, $entry);
1928
1929 $entry = array();
1930
1931 $entry["type"] = $ctype;
1932 $entry["filename"] = $filename;
1933 $entry["url"] = $url;
1934 $entry["title"] = $title;
1935 $entry["width"] = $width;
1936 $entry["height"] = $height;
1937
1938 array_push($entries, $entry);
1939 }
1940
1941 if ($_SESSION['uid'] && !get_pref("STRIP_IMAGES") && !$_SESSION["bw_limit"]) {
1942 if ($always_display_enclosures ||
1943 !preg_match("/<img/i", $article_content)) {
1944
1945 foreach ($entries as $entry) {
1946
1947 if (preg_match("/image/", $entry["type"]) ||
1948 preg_match("/\.(jpg|png|gif|bmp)/i", $entry["filename"])) {
1949
1950 if (!$hide_images) {
1951 $encsize = '';
1952 if ($entry['height'] > 0)
1953 $encsize .= ' height="' . intval($entry['width']) . '"';
1954 if ($entry['width'] > 0)
1955 $encsize .= ' width="' . intval($entry['height']) . '"';
1956 $rv .= "<p><img
1957 alt=\"".htmlspecialchars($entry["filename"])."\"
1958 src=\"" .htmlspecialchars($entry["url"]) . "\"
1959 " . $encsize . " /></p>";
1960 } else {
1961 $rv .= "<p><a target=\"_blank\"
1962 href=\"".htmlspecialchars($entry["url"])."\"
1963 >" .htmlspecialchars($entry["url"]) . "</a></p>";
1964 }
1965
1966 if ($entry['title']) {
1967 $rv.= "<div class=\"enclosure_title\">${entry['title']}</div>";
1968 }
1969 }
1970 }
1971 }
1972 }
1973
1974 if (count($entries_inline) > 0) {
1975 $rv .= "<hr clear='both'/>";
1976 foreach ($entries_inline as $entry) { $rv .= $entry; };
1977 $rv .= "<hr clear='both'/>";
1978 }
1979
1980 $rv .= "<select class=\"attachments\" onchange=\"openSelectedAttachment(this)\">".
1981 "<option value=''>" . __('Attachments')."</option>";
1982
1983 foreach ($entries as $entry) {
1984 if ($entry["title"])
1985 $title = "&mdash; " . truncate_string($entry["title"], 30);
1986 else
1987 $title = "";
1988
1989 $rv .= "<option value=\"".htmlspecialchars($entry["url"])."\">" . htmlspecialchars($entry["filename"]) . "$title</option>";
1990
1991 };
1992
1993 $rv .= "</select>";
1994 }
1995
1996 return $rv;
1997 }
1998
1999 function getLastArticleId() {
2000 $result = db_query("SELECT ref_id AS id FROM ttrss_user_entries
2001 WHERE owner_uid = " . $_SESSION["uid"] . " ORDER BY ref_id DESC LIMIT 1");
2002
2003 if (db_num_rows($result) == 1) {
2004 return db_fetch_result($result, 0, "id");
2005 } else {
2006 return -1;
2007 }
2008 }
2009
2010 function build_url($parts) {
2011 return $parts['scheme'] . "://" . $parts['host'] . $parts['path'];
2012 }
2013
2014 /**
2015 * Converts a (possibly) relative URL to a absolute one.
2016 *
2017 * @param string $url Base URL (i.e. from where the document is)
2018 * @param string $rel_url Possibly relative URL in the document
2019 *
2020 * @return string Absolute URL
2021 */
2022 function rewrite_relative_url($url, $rel_url) {
2023 if (strpos($rel_url, ":") !== false) {
2024 return $rel_url;
2025 } else if (strpos($rel_url, "://") !== false) {
2026 return $rel_url;
2027 } else if (strpos($rel_url, "//") === 0) {
2028 # protocol-relative URL (rare but they exist)
2029 return $rel_url;
2030 } else if (strpos($rel_url, "/") === 0)
2031 {
2032 $parts = parse_url($url);
2033 $parts['path'] = $rel_url;
2034
2035 return build_url($parts);
2036
2037 } else {
2038 $parts = parse_url($url);
2039 if (!isset($parts['path'])) {
2040 $parts['path'] = '/';
2041 }
2042 $dir = $parts['path'];
2043 if (substr($dir, -1) !== '/') {
2044 $dir = dirname($parts['path']);
2045 $dir !== '/' && $dir .= '/';
2046 }
2047 $parts['path'] = $dir . $rel_url;
2048
2049 return build_url($parts);
2050 }
2051 }
2052
2053 function cleanup_tags($days = 14, $limit = 1000) {
2054
2055 if (DB_TYPE == "pgsql") {
2056 $interval_query = "date_updated < NOW() - INTERVAL '$days days'";
2057 } else if (DB_TYPE == "mysql") {
2058 $interval_query = "date_updated < DATE_SUB(NOW(), INTERVAL $days DAY)";
2059 }
2060
2061 $tags_deleted = 0;
2062
2063 while ($limit > 0) {
2064 $limit_part = 500;
2065
2066 $query = "SELECT ttrss_tags.id AS id
2067 FROM ttrss_tags, ttrss_user_entries, ttrss_entries
2068 WHERE post_int_id = int_id AND $interval_query AND
2069 ref_id = ttrss_entries.id AND tag_cache != '' LIMIT $limit_part";
2070
2071 $result = db_query($query);
2072
2073 $ids = array();
2074
2075 while ($line = db_fetch_assoc($result)) {
2076 array_push($ids, $line['id']);
2077 }
2078
2079 if (count($ids) > 0) {
2080 $ids = join(",", $ids);
2081
2082 $tmp_result = db_query("DELETE FROM ttrss_tags WHERE id IN ($ids)");
2083 $tags_deleted += db_affected_rows($tmp_result);
2084 } else {
2085 break;
2086 }
2087
2088 $limit -= $limit_part;
2089 }
2090
2091 return $tags_deleted;
2092 }
2093
2094 function print_user_stylesheet() {
2095 $value = get_pref('USER_STYLESHEET');
2096
2097 if ($value) {
2098 print "<style type=\"text/css\">";
2099 print str_replace("<br/>", "\n", $value);
2100 print "</style>";
2101 }
2102
2103 }
2104
2105 function filter_to_sql($filter, $owner_uid) {
2106 $query = array();
2107
2108 if (DB_TYPE == "pgsql")
2109 $reg_qpart = "~";
2110 else
2111 $reg_qpart = "REGEXP";
2112
2113 foreach ($filter["rules"] AS $rule) {
2114 $rule['reg_exp'] = str_replace('/', '\/', $rule["reg_exp"]);
2115 $regexp_valid = preg_match('/' . $rule['reg_exp'] . '/',
2116 $rule['reg_exp']) !== FALSE;
2117
2118 if ($regexp_valid) {
2119
2120 $rule['reg_exp'] = db_escape_string($rule['reg_exp']);
2121
2122 switch ($rule["type"]) {
2123 case "title":
2124 $qpart = "LOWER(ttrss_entries.title) $reg_qpart LOWER('".
2125 $rule['reg_exp'] . "')";
2126 break;
2127 case "content":
2128 $qpart = "LOWER(ttrss_entries.content) $reg_qpart LOWER('".
2129 $rule['reg_exp'] . "')";
2130 break;
2131 case "both":
2132 $qpart = "LOWER(ttrss_entries.title) $reg_qpart LOWER('".
2133 $rule['reg_exp'] . "') OR LOWER(" .
2134 "ttrss_entries.content) $reg_qpart LOWER('" . $rule['reg_exp'] . "')";
2135 break;
2136 case "tag":
2137 $qpart = "LOWER(ttrss_user_entries.tag_cache) $reg_qpart LOWER('".
2138 $rule['reg_exp'] . "')";
2139 break;
2140 case "link":
2141 $qpart = "LOWER(ttrss_entries.link) $reg_qpart LOWER('".
2142 $rule['reg_exp'] . "')";
2143 break;
2144 case "author":
2145 $qpart = "LOWER(ttrss_entries.author) $reg_qpart LOWER('".
2146 $rule['reg_exp'] . "')";
2147 break;
2148 }
2149
2150 if (isset($rule['inverse'])) $qpart = "NOT ($qpart)";
2151
2152 if (isset($rule["feed_id"]) && $rule["feed_id"] > 0) {
2153 $qpart .= " AND feed_id = " . db_escape_string($rule["feed_id"]);
2154 }
2155
2156 if (isset($rule["cat_id"])) {
2157
2158 if ($rule["cat_id"] > 0) {
2159 $children = getChildCategories($rule["cat_id"], $owner_uid);
2160 array_push($children, $rule["cat_id"]);
2161
2162 $children = join(",", $children);
2163
2164 $cat_qpart = "cat_id IN ($children)";
2165 } else {
2166 $cat_qpart = "cat_id IS NULL";
2167 }
2168
2169 $qpart .= " AND $cat_qpart";
2170 }
2171
2172 $qpart .= " AND feed_id IS NOT NULL";
2173
2174 array_push($query, "($qpart)");
2175
2176 }
2177 }
2178
2179 if (count($query) > 0) {
2180 $fullquery = "(" . join($filter["match_any_rule"] ? "OR" : "AND", $query) . ")";
2181 } else {
2182 $fullquery = "(false)";
2183 }
2184
2185 if ($filter['inverse']) $fullquery = "(NOT $fullquery)";
2186
2187 return $fullquery;
2188 }
2189
2190 if (!function_exists('gzdecode')) {
2191 function gzdecode($string) { // no support for 2nd argument
2192 return file_get_contents('compress.zlib://data:who/cares;base64,'.
2193 base64_encode($string));
2194 }
2195 }
2196
2197 function get_random_bytes($length) {
2198 if (function_exists('openssl_random_pseudo_bytes')) {
2199 return openssl_random_pseudo_bytes($length);
2200 } else {
2201 $output = "";
2202
2203 for ($i = 0; $i < $length; $i++)
2204 $output .= chr(mt_rand(0, 255));
2205
2206 return $output;
2207 }
2208 }
2209
2210 function read_stdin() {
2211 $fp = fopen("php://stdin", "r");
2212
2213 if ($fp) {
2214 $line = trim(fgets($fp));
2215 fclose($fp);
2216 return $line;
2217 }
2218
2219 return null;
2220 }
2221
2222 function tmpdirname($path, $prefix) {
2223 // Use PHP's tmpfile function to create a temporary
2224 // directory name. Delete the file and keep the name.
2225 $tempname = tempnam($path,$prefix);
2226 if (!$tempname)
2227 return false;
2228
2229 if (!unlink($tempname))
2230 return false;
2231
2232 return $tempname;
2233 }
2234
2235 function getFeedCategory($feed) {
2236 $result = db_query("SELECT cat_id FROM ttrss_feeds
2237 WHERE id = '$feed'");
2238
2239 if (db_num_rows($result) > 0) {
2240 return db_fetch_result($result, 0, "cat_id");
2241 } else {
2242 return false;
2243 }
2244
2245 }
2246
2247 function implements_interface($class, $interface) {
2248 return in_array($interface, class_implements($class));
2249 }
2250
2251 function geturl($url, $depth = 0, $nobody = true){
2252
2253 if ($depth == 20) return $url;
2254
2255 if (!function_exists('curl_init'))
2256 return user_error('CURL Must be installed for geturl function to work. Ask your host to enable it or uncomment extension=php_curl.dll in php.ini', E_USER_ERROR);
2257
2258 $curl = curl_init();
2259 $header[0] = "Accept: text/xml,application/xml,application/xhtml+xml,";
2260 $header[0] .= "text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5";
2261 $header[] = "Cache-Control: max-age=0";
2262 $header[] = "Connection: keep-alive";
2263 $header[] = "Keep-Alive: 300";
2264 $header[] = "Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7";
2265 $header[] = "Accept-Language: en-us,en;q=0.5";
2266 $header[] = "Pragma: ";
2267
2268 curl_setopt($curl, CURLOPT_URL, $url);
2269 curl_setopt($curl, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows NT 5.1; rv:5.0) Gecko/20100101 Firefox/5.0 Firefox/5.0');
2270 curl_setopt($curl, CURLOPT_HTTPHEADER, $header);
2271 curl_setopt($curl, CURLOPT_HEADER, true);
2272 curl_setopt($curl, CURLOPT_NOBODY, $nobody);
2273 curl_setopt($curl, CURLOPT_REFERER, $url);
2274 curl_setopt($curl, CURLOPT_ENCODING, 'gzip,deflate');
2275 curl_setopt($curl, CURLOPT_AUTOREFERER, true);
2276 curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
2277 //curl_setopt($curl, CURLOPT_FOLLOWLOCATION, true); //CURLOPT_FOLLOWLOCATION Disabled...
2278 curl_setopt($curl, CURLOPT_TIMEOUT, 60);
2279 curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
2280
2281 if (defined('_CURL_HTTP_PROXY')) {
2282 curl_setopt($curl, CURLOPT_PROXY, _CURL_HTTP_PROXY);
2283 }
2284
2285 $html = curl_exec($curl);
2286
2287 $status = curl_getinfo($curl);
2288
2289 if($status['http_code']!=200){
2290
2291 // idiot site not allowing http head
2292 if($status['http_code'] == 405) {
2293 curl_close($curl);
2294 return geturl($url, $depth +1, false);
2295 }
2296
2297 if($status['http_code'] == 301 || $status['http_code'] == 302) {
2298 curl_close($curl);
2299 list($header) = explode("\r\n\r\n", $html, 2);
2300 $matches = array();
2301 preg_match("/(Location:|URI:)[^(\n)]*/", $header, $matches);
2302 $url = trim(str_replace($matches[1],"",$matches[0]));
2303 $url_parsed = parse_url($url);
2304 return (isset($url_parsed))? geturl($url, $depth + 1):'';
2305 }
2306
2307 global $fetch_last_error;
2308
2309 $fetch_last_error = curl_errno($curl) . " " . curl_error($curl);
2310 curl_close($curl);
2311
2312 # $oline='';
2313 # foreach($status as $key=>$eline){$oline.='['.$key.']'.$eline.' ';}
2314 # $line =$oline." \r\n ".$url."\r\n-----------------\r\n";
2315 # $handle = @fopen('./curl.error.log', 'a');
2316 # fwrite($handle, $line);
2317 return FALSE;
2318 }
2319 curl_close($curl);
2320 return $url;
2321 }
2322
2323 function get_minified_js($files) {
2324 require_once 'lib/jshrink/Minifier.php';
2325
2326 $rv = '';
2327
2328 foreach ($files as $js) {
2329 if (!isset($_GET['debug'])) {
2330 $cached_file = CACHE_DIR . "/js/".basename($js).".js";
2331
2332 if (file_exists($cached_file) && is_readable($cached_file) && filemtime($cached_file) >= filemtime("js/$js.js")) {
2333
2334 list($header, $contents) = explode("\n", file_get_contents($cached_file), 2);
2335
2336 if ($header && $contents) {
2337 list($htag, $hversion) = explode(":", $header);
2338
2339 if ($htag == "tt-rss" && $hversion == VERSION) {
2340 $rv .= $contents;
2341 continue;
2342 }
2343 }
2344 }
2345
2346 $minified = JShrink\Minifier::minify(file_get_contents("js/$js.js"));
2347 file_put_contents($cached_file, "tt-rss:" . VERSION . "\n" . $minified);
2348 $rv .= $minified;
2349
2350 } else {
2351 $rv .= file_get_contents("js/$js.js"); // no cache in debug mode
2352 }
2353 }
2354
2355 return $rv;
2356 }
2357
2358 function stylesheet_tag($filename) {
2359 $timestamp = filemtime($filename);
2360
2361 return "<link rel=\"stylesheet\" type=\"text/css\" href=\"$filename?$timestamp\"/>\n";
2362 }
2363
2364 function javascript_tag($filename) {
2365 $query = "";
2366
2367 if (!(strpos($filename, "?") === FALSE)) {
2368 $query = substr($filename, strpos($filename, "?")+1);
2369 $filename = substr($filename, 0, strpos($filename, "?"));
2370 }
2371
2372 $timestamp = filemtime($filename);
2373
2374 if ($query) $timestamp .= "&$query";
2375
2376 return "<script type=\"text/javascript\" charset=\"utf-8\" src=\"$filename?$timestamp\"></script>\n";
2377 }
2378
2379 function calculate_dep_timestamp() {
2380 $files = array_merge(glob("js/*.js"), glob("css/*.css"));
2381
2382 $max_ts = -1;
2383
2384 foreach ($files as $file) {
2385 if (filemtime($file) > $max_ts) $max_ts = filemtime($file);
2386 }
2387
2388 return $max_ts;
2389 }
2390
2391 function T_js_decl($s1, $s2) {
2392 if ($s1 && $s2) {
2393 $s1 = preg_replace("/\n/", "", $s1);
2394 $s2 = preg_replace("/\n/", "", $s2);
2395
2396 $s1 = preg_replace("/\"/", "\\\"", $s1);
2397 $s2 = preg_replace("/\"/", "\\\"", $s2);
2398
2399 return "T_messages[\"$s1\"] = \"$s2\";\n";
2400 }
2401 }
2402
2403 function init_js_translations() {
2404
2405 print 'var T_messages = new Object();
2406
2407 function __(msg) {
2408 if (T_messages[msg]) {
2409 return T_messages[msg];
2410 } else {
2411 return msg;
2412 }
2413 }
2414
2415 function ngettext(msg1, msg2, n) {
2416 return __((parseInt(n) > 1) ? msg2 : msg1);
2417 }';
2418
2419 $l10n = _get_reader();
2420
2421 for ($i = 0; $i < $l10n->total; $i++) {
2422 $orig = $l10n->get_original_string($i);
2423 if(strpos($orig, "\000") !== FALSE) { // Plural forms
2424 $key = explode(chr(0), $orig);
2425 print T_js_decl($key[0], _ngettext($key[0], $key[1], 1)); // Singular
2426 print T_js_decl($key[1], _ngettext($key[0], $key[1], 2)); // Plural
2427 } else {
2428 $translation = __($orig);
2429 print T_js_decl($orig, $translation);
2430 }
2431 }
2432 }
2433
2434 function label_to_feed_id($label) {
2435 return LABEL_BASE_INDEX - 1 - abs($label);
2436 }
2437
2438 function feed_to_label_id($feed) {
2439 return LABEL_BASE_INDEX - 1 + abs($feed);
2440 }
2441
2442 function theme_valid($file) {
2443 if ($file == "default.css" || $file == "night.css") return true; // needed for array_filter
2444 $file = "themes/" . basename($file);
2445
2446 if (file_exists($file) && is_readable($file)) {
2447 $fh = fopen($file, "r");
2448
2449 if ($fh) {
2450 $header = fgets($fh);
2451 fclose($fh);
2452
2453 return strpos($header, "supports-version:" . VERSION_STATIC) !== FALSE;
2454 }
2455 }
2456
2457 return false;
2458 }
2459 ?>
web-based news feed (RSS/Atom) reader and aggregator; see https://tt-rss.org/