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