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