]>
git.wh0rd.org - tt-rss.git/blob - include/functions2.php
2 function make_init_params() {
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) {
10 $params[strtolower($param)] = (int) get_pref($param);
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
;
21 $theme = get_pref( "USER_CSS_THEME", false, false);
22 $params["theme"] = theme_valid("$theme") ?
$theme : "";
24 $params["plugins"] = implode(", ", PluginHost
::getInstance()->get_plugin_names());
26 $params["php_platform"] = PHP_OS
;
27 $params["php_version"] = PHP_VERSION
;
29 $params["sanity_checksum"] = sha1(file_get_contents("include/sanity_check.php"));
31 $result = db_query("SELECT MAX(id) AS mid, COUNT(*) AS nf FROM
32 ttrss_feeds WHERE owner_uid = " . $_SESSION["uid"]);
34 $max_feed_id = db_fetch_result($result, 0, "mid");
35 $num_feeds = db_fetch_result($result, 0, "nf");
37 $params["max_feed_id"] = (int) $max_feed_id;
38 $params["num_feeds"] = (int) $num_feeds;
40 $params["hotkeys"] = get_hotkeys_map();
42 $params["csrf_token"] = $_SESSION["csrf_token"];
43 $params["widescreen"] = (int) $_COOKIE["ttrss_widescreen"];
45 $params['simple_update'] = defined('SIMPLE_UPDATE_MODE') && SIMPLE_UPDATE_MODE
;
50 function get_hotkeys_info() {
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 "open_in_new_window" => __("Open in new window"),
68 "catchup_below" => __("Mark below as read"),
69 "catchup_above" => __("Mark above as read"),
70 "article_scroll_down" => __("Scroll down"),
71 "article_scroll_up" => __("Scroll up"),
72 "select_article_cursor" => __("Select article under cursor"),
73 "email_article" => __("Email article"),
74 "close_article" => __("Close/collapse article"),
75 "toggle_expand" => __("Toggle article expansion (combined mode)"),
76 "toggle_widescreen" => __("Toggle widescreen mode"),
77 "toggle_embed_original" => __("Toggle embed original")),
78 __("Article selection") => array(
79 "select_all" => __("Select all articles"),
80 "select_unread" => __("Select unread"),
81 "select_marked" => __("Select starred"),
82 "select_published" => __("Select published"),
83 "select_invert" => __("Invert selection"),
84 "select_none" => __("Deselect everything")),
86 "feed_refresh" => __("Refresh current feed"),
87 "feed_unhide_read" => __("Un/hide read feeds"),
88 "feed_subscribe" => __("Subscribe to feed"),
89 "feed_edit" => __("Edit feed"),
90 "feed_catchup" => __("Mark as read"),
91 "feed_reverse" => __("Reverse headlines"),
92 "feed_toggle_vgroup" => __("Toggle headline grouping"),
93 "feed_debug_update" => __("Debug feed update"),
94 "feed_debug_viewfeed" => __("Debug viewfeed()"),
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")),
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"))
113 foreach (PluginHost
::getInstance()->get_hooks(PluginHost
::HOOK_HOTKEY_INFO
) as $plugin) {
114 $hotkeys = $plugin->hook_hotkey_info($hotkeys);
120 function get_hotkeys_map() {
122 // "navigation" => array(
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",
137 "o" => "open_in_new_window",
138 "c p" => "catchup_below",
139 "c n" => "catchup_above",
140 "*n" => "article_scroll_down",
141 "*p" => "article_scroll_up",
142 "*(38)|Shift+up" => "article_scroll_up",
143 "*(40)|Shift+down" => "article_scroll_down",
144 "a *w" => "toggle_widescreen",
145 "a e" => "toggle_embed_original",
146 "e" => "email_article",
147 "a q" => "close_article",
148 // "article_selection" => array(
149 "a a" => "select_all",
150 "a u" => "select_unread",
151 "a *u" => "select_marked",
152 "a p" => "select_published",
153 "a i" => "select_invert",
154 "a n" => "select_none",
156 "f r" => "feed_refresh",
157 "f a" => "feed_unhide_read",
158 "f s" => "feed_subscribe",
159 "f e" => "feed_edit",
160 "f q" => "feed_catchup",
161 "f x" => "feed_reverse",
162 "f g" => "feed_toggle_vgroup",
163 "f *d" => "feed_debug_update",
164 "f *g" => "feed_debug_viewfeed",
165 "f *c" => "toggle_combined_mode",
166 "f c" => "toggle_cdm_expanded",
167 "*q" => "catchup_all",
168 "x" => "cat_toggle_collapse",
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",
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",
184 if (get_pref('COMBINED_DISPLAY_MODE')) {
185 $hotkeys["^(38)|Ctrl-up"] = "prev_article_noscroll";
186 $hotkeys["^(40)|Ctrl-down"] = "next_article_noscroll";
189 foreach (PluginHost
::getInstance()->get_hooks(PluginHost
::HOOK_HOTKEY_MAP
) as $plugin) {
190 $hotkeys = $plugin->hook_hotkey_map($hotkeys);
195 foreach (array_keys($hotkeys) as $hotkey) {
196 $pair = explode(" ", $hotkey, 2);
198 if (count($pair) > 1 && !in_array($pair[0], $prefixes)) {
199 array_push($prefixes, $pair[0]);
203 return array($prefixes, $hotkeys);
206 function check_for_update() {
207 if (defined("GIT_VERSION_TIMESTAMP")) {
208 $content = @fetch_file_contents
(array("url" => "http://tt-rss.org/version.json", "timeout" => 5));
211 $content = json_decode($content, true);
213 if ($content && isset($content["changeset"])) {
214 if ((int)GIT_VERSION_TIMESTAMP
< (int)$content["changeset"]["timestamp"] &&
215 GIT_VERSION_HEAD
!= $content["changeset"]["id"]) {
217 return $content["changeset"]["id"];
226 function make_runtime_info($disable_update_check = false) {
229 $result = db_query("SELECT MAX(id) AS mid, COUNT(*) AS nf FROM
230 ttrss_feeds WHERE owner_uid = " . $_SESSION["uid"]);
232 $max_feed_id = db_fetch_result($result, 0, "mid");
233 $num_feeds = db_fetch_result($result, 0, "nf");
235 $data["max_feed_id"] = (int) $max_feed_id;
236 $data["num_feeds"] = (int) $num_feeds;
238 $data['last_article_id'] = getLastArticleId();
239 $data['cdm_expanded'] = get_pref('CDM_EXPANDED');
241 $data['dep_ts'] = calculate_dep_timestamp();
242 $data['reload_on_ts_change'] = !defined('_NO_RELOAD_ON_TS_CHANGE');
245 if (CHECK_FOR_UPDATES
&& !$disable_update_check && $_SESSION["last_version_check"] +
86400 +
rand(-1000, 1000) < time()) {
246 $update_result = @check_for_update
();
248 $data["update_result"] = $update_result;
250 $_SESSION["last_version_check"] = time();
253 if (file_exists(LOCK_DIRECTORY
. "/update_daemon.lock")) {
255 $data['daemon_is_running'] = (int) file_is_locked("update_daemon.lock");
257 if (time() - $_SESSION["daemon_stamp_check"] > 30) {
259 $stamp = (int) @file_get_contents
(LOCK_DIRECTORY
. "/update_daemon.stamp");
262 $stamp_delta = time() - $stamp;
264 if ($stamp_delta > 1800) {
268 $_SESSION["daemon_stamp_check"] = time();
271 $data['daemon_stamp_ok'] = $stamp_check;
273 $stamp_fmt = date("Y.m.d, G:i", $stamp);
275 $data['daemon_stamp'] = $stamp_fmt;
283 function search_to_sql($search, $search_language) {
285 $keywords = str_getcsv(trim($search), " ");
286 $query_keywords = array();
287 $search_words = array();
288 $search_query_leftover = array();
290 if ($search_language)
291 $search_language = db_escape_string(mb_strtolower($search_language));
293 $search_language = "english";
295 foreach ($keywords as $k) {
296 if (strpos($k, "-") === 0) {
303 $commandpair = explode(":", mb_strtolower($k), 2);
305 switch ($commandpair[0]) {
307 if ($commandpair[1]) {
308 array_push($query_keywords, "($not (LOWER(ttrss_entries.title) LIKE '%".
309 db_escape_string(mb_strtolower($commandpair[1]))."%'))");
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);
317 if ($commandpair[1]) {
318 array_push($query_keywords, "($not (LOWER(author) LIKE '%".
319 db_escape_string(mb_strtolower($commandpair[1]))."%'))");
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);
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 = ''))");
333 array_push($query_keywords, "($not (LOWER(note) LIKE '%".
334 db_escape_string(mb_strtolower($commandpair[1]))."%'))");
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);
343 if ($commandpair[1]) {
344 if ($commandpair[1] == "true")
345 array_push($query_keywords, "($not (marked = true))");
347 array_push($query_keywords, "($not (marked = false))");
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);
355 if ($commandpair[1]) {
356 if ($commandpair[1] == "true")
357 array_push($query_keywords, "($not (published = true))");
359 array_push($query_keywords, "($not (published = false))");
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);
368 if ($commandpair[1]) {
369 if ($commandpair[1] == "true")
370 array_push($query_keywords, "($not (unread = true))");
372 array_push($query_keywords, "($not (unread = false))");
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);
381 if (strpos($k, "@") === 0) {
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'));
387 //$k = date("Y-m-d", strtotime(substr($k, 1)));
389 array_push($query_keywords, "(".SUBSTRING_FOR_DATE
."(updated,1,LENGTH('$k')) $not = '$k')");
392 if (DB_TYPE
== "pgsql") {
393 $k = mb_strtolower($k);
394 array_push($search_query_leftover, $not ?
"!$k" : $k);
396 array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
397 OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
400 if (!$not) array_push($search_words, $k);
405 if (count($search_query_leftover) > 0) {
406 $search_query_leftover = db_escape_string(implode(" & ", $search_query_leftover));
408 if (DB_TYPE
== "pgsql") {
409 array_push($query_keywords,
410 "(tsvector_combined @@ to_tsquery('$search_language', '$search_query_leftover'))");
415 $search_query_part = implode("AND", $query_keywords);
417 return array($search_query_part, $search_words);
420 function getParentCategories($cat, $owner_uid) {
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");
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));
434 function getChildCategories($cat, $owner_uid) {
437 $result = db_query("SELECT id FROM ttrss_feed_categories
438 WHERE parent_cat = '$cat' AND owner_uid = $owner_uid");
440 while ($line = db_fetch_assoc($result)) {
441 array_push($rv, $line["id"]);
442 $rv = array_merge($rv, getChildCategories($line["id"], $owner_uid));
448 function queryFeedHeadlines($params) {
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 $skip_first_id_check = isset($params["skip_first_id_check"]) ?
$params["skip_first_id_check"] : false;
468 $ext_tables_part = "";
469 $query_strategy_part = "";
471 $search_words = array();
474 foreach (PluginHost
::getInstance()->get_hooks(PluginHost
::HOOK_SEARCH
) as $plugin) {
475 list($search_query_part, $search_words) = $plugin->hook_search($search);
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);
483 $search_query_part .= " AND ";
485 $search_query_part = "";
489 $since_id_part = "ttrss_entries.id > $since_id AND ";
494 $view_query_part = "";
496 if ($view_mode == "adaptive") {
498 $view_query_part = " ";
499 } else if ($feed != -1) {
501 $unread = getFeedUnread($feed, $cat_view);
503 if ($cat_view && $feed > 0 && $include_children)
504 $unread +
= getCategoryChildrenUnread($feed);
507 $view_query_part = " unread = true AND ";
512 if ($view_mode == "marked") {
513 $view_query_part = " marked = true AND ";
516 if ($view_mode == "has_note") {
517 $view_query_part = " (note IS NOT NULL AND note != '') AND ";
520 if ($view_mode == "published") {
521 $view_query_part = " published = true AND ";
524 if ($view_mode == "unread" && $feed != -6) {
525 $view_query_part = " unread = true AND ";
529 $limit_query_part = "LIMIT " . $limit;
532 $allow_archived = false;
534 $vfeed_query_part = "";
537 if (!is_numeric($feed)) {
538 $query_strategy_part = "true";
539 $vfeed_query_part = "(SELECT title FROM ttrss_feeds WHERE
540 id = feed_id) as feed_title,";
541 } else if ($feed > 0) {
546 if ($include_children) {
548 $subcats = getChildCategories($feed, $owner_uid);
550 array_push($subcats, $feed);
551 $query_strategy_part = "cat_id IN (".
552 implode(",", $subcats).")";
555 $query_strategy_part = "cat_id = '$feed'";
559 $query_strategy_part = "cat_id IS NULL";
562 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
565 $query_strategy_part = "feed_id = '$feed'";
567 } else if ($feed == 0 && !$cat_view) { // archive virtual feed
568 $query_strategy_part = "feed_id IS NULL";
569 $allow_archived = true;
570 } else if ($feed == 0 && $cat_view) { // uncategorized
571 $query_strategy_part = "cat_id IS NULL AND feed_id IS NOT NULL";
572 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
573 } else if ($feed == -1) { // starred virtual feed
574 $query_strategy_part = "marked = true";
575 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
576 $allow_archived = true;
578 if (!$override_order) {
579 $override_order = "last_marked DESC, date_entered DESC, updated DESC";
582 } else if ($feed == -2) { // published virtual feed OR labels category
585 $query_strategy_part = "published = true";
586 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
587 $allow_archived = true;
589 if (!$override_order) {
590 $override_order = "last_published DESC, date_entered DESC, updated DESC";
594 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
596 $ext_tables_part = "ttrss_labels2,ttrss_user_labels2,";
598 $query_strategy_part = "ttrss_labels2.id = ttrss_user_labels2.label_id AND
599 ttrss_user_labels2.article_id = ref_id";
602 } else if ($feed == -6) { // recently read
603 $query_strategy_part = "unread = false AND last_read IS NOT NULL";
605 if (DB_TYPE
== "pgsql") {
606 $query_strategy_part .= " AND last_read > NOW() - INTERVAL '1 DAY' ";
608 $query_strategy_part .= " AND last_read > DATE_SUB(NOW(), INTERVAL 1 DAY) ";
611 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
612 $allow_archived = true;
613 $ignore_vfeed_group = true;
615 if (!$override_order) $override_order = "last_read DESC";
617 } else if ($feed == -3) { // fresh virtual feed
618 $query_strategy_part = "unread = true AND score >= 0";
620 $intl = get_pref("FRESH_ARTICLE_MAX_AGE", $owner_uid);
622 if (DB_TYPE
== "pgsql") {
623 $query_strategy_part .= " AND date_entered > NOW() - INTERVAL '$intl hour' ";
625 $query_strategy_part .= " AND date_entered > DATE_SUB(NOW(), INTERVAL $intl HOUR) ";
628 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
629 } else if ($feed == -4) { // all articles virtual feed
630 $allow_archived = true;
631 $query_strategy_part = "true";
632 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
633 } else if ($feed <= LABEL_BASE_INDEX
) { // labels
634 $label_id = feed_to_label_id($feed);
636 $query_strategy_part = "label_id = '$label_id' AND
637 ttrss_labels2.id = ttrss_user_labels2.label_id AND
638 ttrss_user_labels2.article_id = ref_id";
640 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
641 $ext_tables_part = "ttrss_labels2,ttrss_user_labels2,";
642 $allow_archived = true;
645 $query_strategy_part = "true";
648 $order_by = "score DESC, date_entered DESC, updated DESC";
650 if ($override_order) {
651 $order_by = $override_order;
654 if ($override_strategy) {
655 $query_strategy_part = $override_strategy;
658 if ($override_vfeed) {
659 $vfeed_query_part = $override_vfeed;
665 $feed_title = T_sprintf("Search results: %s", $search);
668 $feed_title = getCategoryTitle($feed);
670 if (is_numeric($feed) && $feed > 0) {
671 $result = db_query("SELECT title,site_url,last_error,last_updated
672 FROM ttrss_feeds WHERE id = '$feed' AND owner_uid = $owner_uid");
674 $feed_title = db_fetch_result($result, 0, "title");
675 $feed_site_url = db_fetch_result($result, 0, "site_url");
676 $last_error = db_fetch_result($result, 0, "last_error");
677 $last_updated = db_fetch_result($result, 0, "last_updated");
679 $feed_title = getFeedTitle($feed);
685 $content_query_part = "content, ";
687 if ($limit_query_part) {
688 $offset_query_part = "OFFSET $offset";
690 $offset_query_part = "";
693 if (is_numeric($feed)) {
694 // proper override_order applied above
695 if ($vfeed_query_part && !$ignore_vfeed_group && get_pref('VFEED_GROUP_BY_FEED', $owner_uid)) {
696 if (!$override_order) {
697 $order_by = "ttrss_feeds.title, $order_by";
699 $order_by = "ttrss_feeds.title, $override_order";
703 if (!$allow_archived) {
704 $from_qpart = "${ext_tables_part}ttrss_entries LEFT JOIN ttrss_user_entries ON (ref_id = ttrss_entries.id),ttrss_feeds";
705 $feed_check_qpart = "ttrss_user_entries.feed_id = ttrss_feeds.id AND";
708 $from_qpart = "${ext_tables_part}ttrss_entries LEFT JOIN ttrss_user_entries ON (ref_id = ttrss_entries.id)
709 LEFT JOIN ttrss_feeds ON (feed_id = ttrss_feeds.id)";
712 if ($vfeed_query_part) $vfeed_query_part .= "favicon_avg_color,";
715 $start_ts_formatted = date("Y/m/d H:i:s", strtotime($start_ts));
716 $start_ts_query_part = "date_entered >= '$start_ts_formatted' AND";
718 $start_ts_query_part = "";
722 $first_id_query_strategy_part = $query_strategy_part;
725 $first_id_query_strategy_part = "true";
727 if (DB_TYPE
== "pgsql") {
728 $sanity_interval_qpart = "date_entered >= NOW() - INTERVAL '1 hour' AND";
730 $sanity_interval_qpart = "date_entered >= DATE_SUB(NOW(), INTERVAL 1 hour) AND";
733 if (!$search && !$skip_first_id_check) {
734 // if previous topmost article id changed that means our current pagination is no longer valid
735 $query = "SELECT DISTINCT
752 ttrss_user_entries.owner_uid = '$owner_uid' AND
756 $sanity_interval_qpart
757 $first_id_query_strategy_part ORDER BY $order_by LIMIT 1";
759 if ($_REQUEST["debug"]) {
763 $result = db_query($query);
764 if ($result && db_num_rows($result) > 0) {
765 $first_id = (int)db_fetch_result($result, 0, "id");
767 if ($offset > 0 && $first_id && $check_first_id && $first_id != $check_first_id) {
768 return array(-1, $feed_title, $feed_site_url, $last_error, $last_updated, $search_words, $first_id);
773 $query = "SELECT DISTINCT
776 ttrss_entries.id,ttrss_entries.title,
780 always_display_enclosures,
789 unread,feed_id,marked,published,link,last_read,orig_feed_id,
790 last_marked, last_published,
798 ttrss_user_entries.owner_uid = '$owner_uid' AND
803 $query_strategy_part ORDER BY $order_by
804 $limit_query_part $offset_query_part";
806 if ($_REQUEST["debug"]) print $query;
808 $result = db_query($query);
813 $query = "SELECT DISTINCT
817 ttrss_entries.id as id,
833 (SELECT hide_images FROM ttrss_feeds WHERE id = feed_id) AS hide_images,
834 last_marked, last_published,
839 FROM ttrss_entries, ttrss_user_entries, ttrss_tags
841 ref_id = ttrss_entries.id AND
842 ttrss_user_entries.owner_uid = $owner_uid AND
843 post_int_id = int_id AND
844 tag_name = '$feed' AND
847 $query_strategy_part ORDER BY $order_by
848 $limit_query_part $offset_query_part";
850 if ($_REQUEST["debug"]) print $query;
852 $result = db_query($query);
855 return array($result, $feed_title, $feed_site_url, $last_error, $last_updated, $search_words, $first_id);
859 function iframe_whitelisted($entry) {
860 $whitelist = array("youtube.com", "youtu.be", "vimeo.com", "player.vimeo.com");
862 @$src = parse_url($entry->getAttribute("src"), PHP_URL_HOST
);
865 foreach ($whitelist as $w) {
866 if ($src == $w ||
$src == "www.$w")
874 function sanitize($str, $force_remove_images = false, $owner = false, $site_url = false, $highlight_words = false, $article_id = false) {
875 if (!$owner) $owner = $_SESSION["uid"];
877 $res = trim($str); if (!$res) return '';
879 $charset_hack = '<head>
880 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
883 $res = trim($res); if (!$res) return '';
885 libxml_use_internal_errors(true);
887 $doc = new DOMDocument();
888 $doc->loadHTML($charset_hack . $res);
889 $xpath = new DOMXPath($doc);
891 $entries = $xpath->query('(//a[@href]|//img[@src])');
893 $ttrss_uses_https = parse_url(get_self_url_prefix(), PHP_URL_SCHEME
) === 'https';
895 foreach ($entries as $entry) {
899 if ($entry->hasAttribute('href')) {
900 $entry->setAttribute('href',
901 rewrite_relative_url($site_url, $entry->getAttribute('href')));
903 $entry->setAttribute('rel', 'noreferrer');
906 if ($entry->hasAttribute('src')) {
907 $src = rewrite_relative_url($site_url, $entry->getAttribute('src'));
909 $cached_filename = CACHE_DIR
. '/images/' . sha1($src) . '.png';
911 if (file_exists($cached_filename)) {
912 $src = SELF_URL_PATH
. '/public.php?op=cached_image&hash=' . sha1($src);
914 if ($entry->hasAttribute('srcset')) {
915 $entry->removeAttribute('srcset');
918 if ($entry->hasAttribute('sizes')) {
919 $entry->removeAttribute('sizes');
923 $entry->setAttribute('src', $src);
926 if ($entry->nodeName
== 'img') {
927 if ($entry->hasAttribute('src')) {
928 $is_https_url = parse_url($entry->getAttribute('src'), PHP_URL_SCHEME
) === 'https';
930 if ($ttrss_uses_https && !$is_https_url) {
932 if ($entry->hasAttribute('srcset')) {
933 $entry->removeAttribute('srcset');
936 if ($entry->hasAttribute('sizes')) {
937 $entry->removeAttribute('sizes');
942 if (($owner && get_pref("STRIP_IMAGES", $owner)) ||
943 $force_remove_images ||
$_SESSION["bw_limit"]) {
945 $p = $doc->createElement('p');
947 $a = $doc->createElement('a');
948 $a->setAttribute('href', $entry->getAttribute('src'));
950 $a->appendChild(new DOMText($entry->getAttribute('src')));
951 $a->setAttribute('target', '_blank');
955 $entry->parentNode
->replaceChild($p, $entry);
960 if (strtolower($entry->nodeName
) == "a") {
961 $entry->setAttribute("target", "_blank");
965 $entries = $xpath->query('//iframe');
966 foreach ($entries as $entry) {
967 if (!iframe_whitelisted($entry)) {
968 $entry->setAttribute('sandbox', 'allow-scripts');
970 if ($_SERVER['HTTPS'] == "on") {
971 $entry->setAttribute("src",
972 str_replace("http://", "https://",
973 $entry->getAttribute("src")));
978 $allowed_elements = array('a', 'address', 'audio', 'article', 'aside',
979 'b', 'bdi', 'bdo', 'big', 'blockquote', 'body', 'br',
980 'caption', 'cite', 'center', 'code', 'col', 'colgroup',
981 'data', 'dd', 'del', 'details', 'description', 'div', 'dl', 'font',
982 'dt', 'em', 'footer', 'figure', 'figcaption',
983 'h1', 'h2', 'h3', 'h4', 'h5', 'h6', 'header', 'html', 'i',
984 'img', 'ins', 'kbd', 'li', 'main', 'mark', 'nav', 'noscript',
985 'ol', 'p', 'pre', 'q', 'ruby', 'rp', 'rt', 's', 'samp', 'section',
986 'small', 'source', 'span', 'strike', 'strong', 'sub', 'summary',
987 'sup', 'table', 'tbody', 'td', 'tfoot', 'th', 'thead', 'time',
988 'tr', 'track', 'tt', 'u', 'ul', 'var', 'wbr', 'video', 'xml:namespace' );
990 if ($_SESSION['hasSandbox']) $allowed_elements[] = 'iframe';
992 $disallowed_attributes = array('id', 'style', 'class');
994 foreach (PluginHost
::getInstance()->get_hooks(PluginHost
::HOOK_SANITIZE
) as $plugin) {
995 $retval = $plugin->hook_sanitize($doc, $site_url, $allowed_elements, $disallowed_attributes, $article_id);
996 if (is_array($retval)) {
998 $allowed_elements = $retval[1];
999 $disallowed_attributes = $retval[2];
1005 $doc->removeChild($doc->firstChild
); //remove doctype
1006 $doc = strip_harmful_tags($doc, $allowed_elements, $disallowed_attributes);
1008 if ($highlight_words) {
1009 foreach ($highlight_words as $word) {
1011 // http://stackoverflow.com/questions/4081372/highlight-keywords-in-a-paragraph
1013 $elements = $xpath->query("//*/text()");
1015 foreach ($elements as $child) {
1017 $fragment = $doc->createDocumentFragment();
1018 $text = $child->textContent
;
1020 while (($pos = mb_stripos($text, $word)) !== false) {
1021 $fragment->appendChild(new DomText(mb_substr($text, 0, $pos)));
1022 $word = mb_substr($text, $pos, mb_strlen($word));
1023 $highlight = $doc->createElement('span');
1024 $highlight->appendChild(new DomText($word));
1025 $highlight->setAttribute('class', 'highlight');
1026 $fragment->appendChild($highlight);
1027 $text = mb_substr($text, $pos +
mb_strlen($word));
1030 if (!empty($text)) $fragment->appendChild(new DomText($text));
1032 $child->parentNode
->replaceChild($fragment, $child);
1037 $res = $doc->saveHTML();
1039 /* strip everything outside of <body>...</body> */
1041 $res_frag = array();
1042 if (preg_match('/<body>(.*)<\/body>/is', $res, $res_frag)) {
1043 return $res_frag[1];
1049 function strip_harmful_tags($doc, $allowed_elements, $disallowed_attributes) {
1050 $xpath = new DOMXPath($doc);
1051 $entries = $xpath->query('//*');
1053 foreach ($entries as $entry) {
1054 if (!in_array($entry->nodeName
, $allowed_elements)) {
1055 $entry->parentNode
->removeChild($entry);
1058 if ($entry->hasAttributes()) {
1059 $attrs_to_remove = array();
1061 foreach ($entry->attributes
as $attr) {
1063 if (strpos($attr->nodeName
, 'on') === 0) {
1064 array_push($attrs_to_remove, $attr);
1067 if ($attr->nodeName
== 'href' && stripos($attr->value
, 'javascript:') === 0) {
1068 array_push($attrs_to_remove, $attr);
1071 if (in_array($attr->nodeName
, $disallowed_attributes)) {
1072 array_push($attrs_to_remove, $attr);
1076 foreach ($attrs_to_remove as $attr) {
1077 $entry->removeAttributeNode($attr);
1085 function catchupArticlesById($ids, $cmode, $owner_uid = false) {
1087 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
1088 if (count($ids) == 0) return;
1092 foreach ($ids as $id) {
1093 array_push($tmp_ids, "ref_id = '$id'");
1096 $ids_qpart = join(" OR ", $tmp_ids);
1099 db_query("UPDATE ttrss_user_entries SET
1100 unread = false,last_read = NOW()
1101 WHERE ($ids_qpart) AND owner_uid = $owner_uid");
1102 } else if ($cmode == 1) {
1103 db_query("UPDATE ttrss_user_entries SET
1105 WHERE ($ids_qpart) AND owner_uid = $owner_uid");
1107 db_query("UPDATE ttrss_user_entries SET
1108 unread = NOT unread,last_read = NOW()
1109 WHERE ($ids_qpart) AND owner_uid = $owner_uid");
1114 $result = db_query("SELECT DISTINCT feed_id FROM ttrss_user_entries
1115 WHERE ($ids_qpart) AND owner_uid = $owner_uid");
1117 while ($line = db_fetch_assoc($result)) {
1118 ccache_update($line["feed_id"], $owner_uid);
1122 function get_article_tags($id, $owner_uid = 0, $tag_cache = false) {
1124 $a_id = db_escape_string($id);
1126 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
1128 $query = "SELECT DISTINCT tag_name,
1129 owner_uid as owner FROM
1130 ttrss_tags WHERE post_int_id = (SELECT int_id FROM ttrss_user_entries WHERE
1131 ref_id = '$a_id' AND owner_uid = '$owner_uid' LIMIT 1) ORDER BY tag_name";
1135 /* check cache first */
1137 if ($tag_cache === false) {
1138 $result = db_query("SELECT tag_cache FROM ttrss_user_entries
1139 WHERE ref_id = '$id' AND owner_uid = $owner_uid");
1141 if (db_num_rows($result) != 0)
1142 $tag_cache = db_fetch_result($result, 0, "tag_cache");
1146 $tags = explode(",", $tag_cache);
1149 /* do it the hard way */
1151 $tmp_result = db_query($query);
1153 while ($tmp_line = db_fetch_assoc($tmp_result)) {
1154 array_push($tags, $tmp_line["tag_name"]);
1157 /* update the cache */
1159 $tags_str = db_escape_string(join(",", $tags));
1161 db_query("UPDATE ttrss_user_entries
1162 SET tag_cache = '$tags_str' WHERE ref_id = '$id'
1163 AND owner_uid = $owner_uid");
1169 function trim_array($array) {
1171 array_walk($tmp, 'trim');
1175 function tag_is_valid($tag) {
1176 if ($tag == '') return false;
1177 if (is_numeric($tag)) return false;
1178 if (mb_strlen($tag) > 250) return false;
1180 if (!$tag) return false;
1185 function render_login_form() {
1186 header('Cache-Control: public');
1188 require_once "login_form.php";
1192 function format_warning($msg, $id = "") {
1193 return "<div class=\"alert\" id=\"$id\">$msg</div>";
1196 function format_notice($msg, $id = "") {
1197 return "<div class=\"alert alert-info\" id=\"$id\">$msg</div>";
1200 function format_error($msg, $id = "") {
1201 return "<div class=\"alert alert-danger\" id=\"$id\">$msg</div>";
1204 function print_notice($msg) {
1205 return print format_notice($msg);
1208 function print_warning($msg) {
1209 return print format_warning($msg);
1212 function print_error($msg) {
1213 return print format_error($msg);
1217 function T_sprintf() {
1218 $args = func_get_args();
1219 return vsprintf(__(array_shift($args)), $args);
1222 function format_inline_player($url, $ctype) {
1226 $url = htmlspecialchars($url);
1228 if (strpos($ctype, "audio/") === 0) {
1230 if ($_SESSION["hasAudio"] && (strpos($ctype, "ogg") !== false ||
1231 $_SESSION["hasMp3"])) {
1233 $entry .= "<audio preload=\"none\" controls>
1234 <source type=\"$ctype\" src=\"$url\"/>
1239 $entry .= "<object type=\"application/x-shockwave-flash\"
1240 data=\"lib/button/musicplayer.swf?song_url=$url\"
1241 width=\"17\" height=\"17\" style='float : left; margin-right : 5px;'>
1242 <param name=\"movie\"
1243 value=\"lib/button/musicplayer.swf?song_url=$url\" />
1247 if ($entry) $entry .= " <a target=\"_blank\"
1248 href=\"$url\">" . basename($url) . "</a>";
1256 /* $filename = substr($url, strrpos($url, "/")+1);
1258 $entry .= " <a target=\"_blank\" href=\"" . htmlspecialchars($url) . "\">" .
1259 $filename . " (" . $ctype . ")" . "</a>"; */
1263 function format_article($id, $mark_as_read = true, $zoom_mode = false, $owner_uid = false) {
1264 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
1270 /* we can figure out feed_id from article id anyway, why do we
1271 * pass feed_id here? let's ignore the argument :(*/
1273 $result = db_query("SELECT feed_id FROM ttrss_user_entries
1274 WHERE ref_id = '$id'");
1276 $feed_id = (int) db_fetch_result($result, 0, "feed_id");
1278 $rv['feed_id'] = $feed_id;
1280 //if (!$zoom_mode) { print "<article id='$id'><![CDATA["; };
1282 if ($mark_as_read) {
1283 $result = db_query("UPDATE ttrss_user_entries
1284 SET unread = false,last_read = NOW()
1285 WHERE ref_id = '$id' AND owner_uid = $owner_uid");
1287 ccache_update($feed_id, $owner_uid);
1290 $result = db_query("SELECT id,title,link,content,feed_id,comments,int_id,lang,
1291 ".SUBSTRING_FOR_DATE
."(updated,1,16) as updated,
1292 (SELECT site_url FROM ttrss_feeds WHERE id = feed_id) as site_url,
1293 (SELECT title FROM ttrss_feeds WHERE id = feed_id) as feed_title,
1294 (SELECT hide_images FROM ttrss_feeds WHERE id = feed_id) as hide_images,
1295 (SELECT always_display_enclosures FROM ttrss_feeds WHERE id = feed_id) as always_display_enclosures,
1301 FROM ttrss_entries,ttrss_user_entries
1302 WHERE id = '$id' AND ref_id = id AND owner_uid = $owner_uid");
1306 $line = db_fetch_assoc($result);
1308 $line["tags"] = get_article_tags($id, $owner_uid, $line["tag_cache"]);
1309 unset($line["tag_cache"]);
1311 $line["content"] = sanitize($line["content"],
1312 sql_bool_to_bool($line['hide_images']),
1313 $owner_uid, $line["site_url"], false, $line["id"]);
1315 foreach (PluginHost
::getInstance()->get_hooks(PluginHost
::HOOK_RENDER_ARTICLE
) as $p) {
1316 $line = $p->hook_render_article($line);
1319 $num_comments = $line["num_comments"];
1320 $entry_comments = "";
1322 if ($num_comments > 0) {
1323 if ($line["comments"]) {
1324 $comments_url = htmlspecialchars($line["comments"]);
1326 $comments_url = htmlspecialchars($line["link"]);
1328 $entry_comments = "<a class=\"postComments\"
1329 target='_blank' href=\"$comments_url\">$num_comments ".
1330 _ngettext("comment", "comments", $num_comments)."</a>";
1333 if ($line["comments"] && $line["link"] != $line["comments"]) {
1334 $entry_comments = "<a class=\"postComments\" target='_blank' href=\"".htmlspecialchars($line["comments"])."\">".__("comments")."</a>";
1339 header("Content-Type: text/html");
1340 $rv['content'] .= "<html><head>
1341 <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"/>
1342 <title>Tiny Tiny RSS - ".$line["title"]."</title>".
1343 stylesheet_tag("css/tt-rss.css").
1344 stylesheet_tag("css/zoom.css").
1345 stylesheet_tag("css/dijit.css")."
1347 <link rel=\"shortcut icon\" type=\"image/png\" href=\"images/favicon.png\">
1348 <link rel=\"icon\" type=\"image/png\" sizes=\"72x72\" href=\"images/favicon-72px.png\">
1350 </head><body id=\"ttrssZoom\">";
1353 $rv['content'] .= "<div class=\"postReply\" id=\"POST-$id\">";
1355 $rv['content'] .= "<div class=\"postHeader\" id=\"POSTHDR-$id\">";
1357 $entry_author = $line["author"];
1359 if ($entry_author) {
1360 $entry_author = __(" - ") . $entry_author;
1363 $parsed_updated = make_local_datetime($line["updated"], true,
1367 $rv['content'] .= "<div class=\"postDate\">$parsed_updated</div>";
1369 if ($line["link"]) {
1370 $rv['content'] .= "<div class='postTitle'><a target='_blank'
1371 title=\"".htmlspecialchars($line['title'])."\"
1373 htmlspecialchars($line["link"]) . "\">" .
1374 $line["title"] . "</a>" .
1375 "<span class='author'>$entry_author</span></div>";
1377 $rv['content'] .= "<div class='postTitle'>" . $line["title"] . "$entry_author</div>";
1381 $feed_title = htmlspecialchars($line["feed_title"]);
1383 $rv['content'] .= "<div class=\"postFeedTitle\">$feed_title</div>";
1385 $rv['content'] .= "<div class=\"postDate\">$parsed_updated</div>";
1388 $tags_str = format_tags_string($line["tags"], $id);
1389 $tags_str_full = join(", ", $line["tags"]);
1391 if (!$tags_str_full) $tags_str_full = __("no tags");
1393 if (!$entry_comments) $entry_comments = " "; # placeholder
1395 $rv['content'] .= "<div class='postTags' style='float : right'>
1396 <img src='images/tag.png'
1397 class='tagsPic' alt='Tags' title='Tags'> ";
1400 $rv['content'] .= "<span id=\"ATSTR-$id\">$tags_str</span>
1401 <a title=\"".__('Edit tags for this article')."\"
1402 href=\"#\" onclick=\"editArticleTags($id, $feed_id)\">(+)</a>";
1404 $rv['content'] .= "<div dojoType=\"dijit.Tooltip\"
1405 id=\"ATSTRTIP-$id\" connectId=\"ATSTR-$id\"
1406 position=\"below\">$tags_str_full</div>";
1408 foreach (PluginHost
::getInstance()->get_hooks(PluginHost
::HOOK_ARTICLE_BUTTON
) as $p) {
1409 $rv['content'] .= $p->hook_article_button($line);
1413 $tags_str = strip_tags($tags_str);
1414 $rv['content'] .= "<span id=\"ATSTR-$id\">$tags_str</span>";
1416 $rv['content'] .= "</div>";
1417 $rv['content'] .= "<div clear='both'>";
1419 foreach (PluginHost
::getInstance()->get_hooks(PluginHost
::HOOK_ARTICLE_LEFT_BUTTON
) as $p) {
1420 $rv['content'] .= $p->hook_article_left_button($line);
1423 $rv['content'] .= "$entry_comments</div>";
1425 if ($line["orig_feed_id"]) {
1427 $tmp_result = db_query("SELECT * FROM ttrss_archived_feeds
1428 WHERE id = ".$line["orig_feed_id"] . " AND owner_uid = " . $_SESSION["uid"]);
1430 if (db_num_rows($tmp_result) != 0) {
1432 $rv['content'] .= "<div clear='both'>";
1433 $rv['content'] .= __("Originally from:");
1435 $rv['content'] .= " ";
1437 $tmp_line = db_fetch_assoc($tmp_result);
1439 $rv['content'] .= "<a target='_blank'
1440 href=' " . htmlspecialchars($tmp_line['site_url']) . "'>" .
1441 $tmp_line['title'] . "</a>";
1443 $rv['content'] .= " ";
1445 $rv['content'] .= "<a target='_blank' href='" . htmlspecialchars($tmp_line['feed_url']) . "'>";
1446 $rv['content'] .= "<img title='".__('Feed URL')."' class='tinyFeedIcon' src='images/pub_set.png'></a>";
1448 $rv['content'] .= "</div>";
1452 $rv['content'] .= "</div>";
1454 $rv['content'] .= "<div id=\"POSTNOTE-$id\">";
1455 if ($line['note']) {
1456 $rv['content'] .= format_article_note($id, $line['note'], !$zoom_mode);
1458 $rv['content'] .= "</div>";
1460 if (!$line['lang']) $line['lang'] = 'en';
1462 $rv['content'] .= "<div class=\"postContent\" lang=\"".$line['lang']."\">";
1464 $rv['content'] .= $line["content"];
1467 $rv['content'] .= format_article_enclosures($id,
1468 sql_bool_to_bool($line["always_display_enclosures"]),
1470 sql_bool_to_bool($line["hide_images"]));
1473 $rv['content'] .= "</div>";
1475 $rv['content'] .= "</div>";
1481 <div class='footer'>
1482 <button onclick=\"return window.close()\">".
1483 __("Close this window")."</button></div>";
1484 $rv['content'] .= "</body></html>";
1491 function print_checkpoint($n, $s) {
1492 $ts = microtime(true);
1493 echo sprintf("<!-- CP[$n] %.4f seconds -->\n", $ts - $s);
1497 function sanitize_tag($tag) {
1500 $tag = mb_strtolower($tag, 'utf-8');
1502 $tag = preg_replace('/[,\'\"\+\>\<]/', "", $tag);
1504 if (DB_TYPE
== "mysql") {
1505 $tag = preg_replace('/[\x{10000}-\x{10FFFF}]/u', "\xEF\xBF\xBD", $tag);
1511 function get_self_url_prefix() {
1512 if (strrpos(SELF_URL_PATH
, "/") === strlen(SELF_URL_PATH
)-1) {
1513 return substr(SELF_URL_PATH
, 0, strlen(SELF_URL_PATH
)-1);
1515 return SELF_URL_PATH
;
1520 * Compute the Mozilla Firefox feed adding URL from server HOST and REQUEST_URI.
1522 * @return string The Mozilla Firefox feed adding URL.
1524 function add_feed_url() {
1525 //$url_path = ($_SERVER['HTTPS'] != "on" ? 'http://' : 'https://') . $_SERVER["HTTP_HOST"] . parse_url($_SERVER["REQUEST_URI"], PHP_URL_PATH);
1527 $url_path = get_self_url_prefix() .
1528 "/public.php?op=subscribe&feed_url=%s";
1530 } // function add_feed_url
1532 function encrypt_password($pass, $salt = '', $mode2 = false) {
1533 if ($salt && $mode2) {
1534 return "MODE2:" . hash('sha256', $salt . $pass);
1536 return "SHA1X:" . sha1("$salt:$pass");
1538 return "SHA1:" . sha1($pass);
1540 } // function encrypt_password
1542 function load_filters($feed_id, $owner_uid, $action_id = false) {
1545 $cat_id = (int)getFeedCategory($feed_id);
1548 $null_cat_qpart = "cat_id IS NULL OR";
1550 $null_cat_qpart = "";
1552 $result = db_query("SELECT * FROM ttrss_filters2 WHERE
1553 owner_uid = $owner_uid AND enabled = true ORDER BY order_id, title");
1555 $check_cats = join(",", array_merge(
1556 getParentCategories($cat_id, $owner_uid),
1559 while ($line = db_fetch_assoc($result)) {
1560 $filter_id = $line["id"];
1562 $result2 = db_query("SELECT
1563 r.reg_exp, r.inverse, r.feed_id, r.cat_id, r.cat_filter, t.name AS type_name
1564 FROM ttrss_filters2_rules AS r,
1565 ttrss_filter_types AS t
1567 ($null_cat_qpart (cat_id IS NULL AND cat_filter = false) OR cat_id IN ($check_cats)) AND
1568 (feed_id IS NULL OR feed_id = '$feed_id') AND
1569 filter_type = t.id AND filter_id = '$filter_id'");
1574 while ($rule_line = db_fetch_assoc($result2)) {
1575 # print_r($rule_line);
1578 $rule["reg_exp"] = $rule_line["reg_exp"];
1579 $rule["type"] = $rule_line["type_name"];
1580 $rule["inverse"] = sql_bool_to_bool($rule_line["inverse"]);
1582 array_push($rules, $rule);
1585 $result2 = db_query("SELECT a.action_param,t.name AS type_name
1586 FROM ttrss_filters2_actions AS a,
1587 ttrss_filter_actions AS t
1589 action_id = t.id AND filter_id = '$filter_id'");
1591 while ($action_line = db_fetch_assoc($result2)) {
1592 # print_r($action_line);
1595 $action["type"] = $action_line["type_name"];
1596 $action["param"] = $action_line["action_param"];
1598 array_push($actions, $action);
1603 $filter["match_any_rule"] = sql_bool_to_bool($line["match_any_rule"]);
1604 $filter["inverse"] = sql_bool_to_bool($line["inverse"]);
1605 $filter["rules"] = $rules;
1606 $filter["actions"] = $actions;
1608 if (count($rules) > 0 && count($actions) > 0) {
1609 array_push($filters, $filter);
1616 function get_score_pic($score) {
1618 return "score_high.png";
1619 } else if ($score > 0) {
1620 return "score_half_high.png";
1621 } else if ($score < -100) {
1622 return "score_low.png";
1623 } else if ($score < 0) {
1624 return "score_half_low.png";
1626 return "score_neutral.png";
1630 function feed_has_icon($id) {
1631 return is_file(ICONS_DIR
. "/$id.ico") && filesize(ICONS_DIR
. "/$id.ico") > 0;
1634 function init_plugins() {
1635 PluginHost
::getInstance()->load(PLUGINS
, PluginHost
::KIND_ALL
);
1640 function format_tags_string($tags, $id) {
1641 if (!is_array($tags) ||
count($tags) == 0) {
1642 return __("no tags");
1644 $maxtags = min(5, count($tags));
1647 for ($i = 0; $i < $maxtags; $i++
) {
1648 $tags_str .= "<a class=\"tag\" href=\"#\" onclick=\"viewfeed({feed:'".$tags[$i]."'})\">" . $tags[$i] . "</a>, ";
1651 $tags_str = mb_substr($tags_str, 0, mb_strlen($tags_str)-2);
1653 if (count($tags) > $maxtags)
1654 $tags_str .= ", …";
1660 function format_article_labels($labels, $id) {
1662 if (!is_array($labels)) return '';
1666 foreach ($labels as $l) {
1667 $labels_str .= sprintf("<span class='hlLabelRef'
1668 style='color : %s; background-color : %s'>%s</span>",
1669 $l[2], $l[3], $l[1]);
1676 function format_article_note($id, $note, $allow_edit = true) {
1678 $str = "<div class='articleNote' onclick=\"editArticleNote($id)\">
1679 <div class='noteEdit' onclick=\"editArticleNote($id)\">".
1680 ($allow_edit ?
__('(edit note)') : "")."</div>$note</div>";
1686 function get_feed_category($feed_cat, $parent_cat_id = false) {
1687 if ($parent_cat_id) {
1688 $parent_qpart = "parent_cat = '$parent_cat_id'";
1689 $parent_insert = "'$parent_cat_id'";
1691 $parent_qpart = "parent_cat IS NULL";
1692 $parent_insert = "NULL";
1696 "SELECT id FROM ttrss_feed_categories
1697 WHERE $parent_qpart AND title = '$feed_cat' AND owner_uid = ".$_SESSION["uid"]);
1699 if (db_num_rows($result) == 0) {
1702 return db_fetch_result($result, 0, "id");
1706 function add_feed_category($feed_cat, $parent_cat_id = false) {
1708 if (!$feed_cat) return false;
1712 if ($parent_cat_id) {
1713 $parent_qpart = "parent_cat = '$parent_cat_id'";
1714 $parent_insert = "'$parent_cat_id'";
1716 $parent_qpart = "parent_cat IS NULL";
1717 $parent_insert = "NULL";
1720 $feed_cat = mb_substr($feed_cat, 0, 250);
1723 "SELECT id FROM ttrss_feed_categories
1724 WHERE $parent_qpart AND title = '$feed_cat' AND owner_uid = ".$_SESSION["uid"]);
1726 if (db_num_rows($result) == 0) {
1729 "INSERT INTO ttrss_feed_categories (owner_uid,title,parent_cat)
1730 VALUES ('".$_SESSION["uid"]."', '$feed_cat', $parent_insert)");
1740 function getArticleFeed($id) {
1741 $result = db_query("SELECT feed_id FROM ttrss_user_entries
1742 WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]);
1744 if (db_num_rows($result) != 0) {
1745 return db_fetch_result($result, 0, "feed_id");
1752 * Fixes incomplete URLs by prepending "http://".
1753 * Also replaces feed:// with http://, and
1754 * prepends a trailing slash if the url is a domain name only.
1756 * @param string $url Possibly incomplete URL
1758 * @return string Fixed URL.
1760 function fix_url($url) {
1762 // support schema-less urls
1763 if (strpos($url, '//') === 0) {
1764 $url = 'https:' . $url;
1767 if (strpos($url, '://') === false) {
1768 $url = 'http://' . $url;
1769 } else if (substr($url, 0, 5) == 'feed:') {
1770 $url = 'http:' . substr($url, 5);
1773 //prepend slash if the URL has no slash in it
1774 // "http://www.example" -> "http://www.example/"
1775 if (strpos($url, '/', strpos($url, ':') +
3) === false) {
1779 if ($url != "http:///")
1785 function validate_feed_url($url) {
1786 $parts = parse_url($url);
1788 return ($parts['scheme'] == 'http' ||
$parts['scheme'] == 'feed' ||
$parts['scheme'] == 'https');
1792 function get_article_enclosures($id) {
1794 $query = "SELECT * FROM ttrss_enclosures
1795 WHERE post_id = '$id' AND content_url != ''";
1799 $result = db_query($query);
1801 if (db_num_rows($result) > 0) {
1802 while ($line = db_fetch_assoc($result)) {
1803 array_push($rv, $line);
1810 /* function save_email_address($email) {
1811 // FIXME: implement persistent storage of emails
1813 if (!$_SESSION['stored_emails'])
1814 $_SESSION['stored_emails'] = array();
1816 if (!in_array($email, $_SESSION['stored_emails']))
1817 array_push($_SESSION['stored_emails'], $email);
1821 function get_feed_access_key($feed_id, $is_cat, $owner_uid = false) {
1823 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
1825 $sql_is_cat = bool_to_sql_bool($is_cat);
1827 $result = db_query("SELECT access_key FROM ttrss_access_keys
1828 WHERE feed_id = '$feed_id' AND is_cat = $sql_is_cat
1829 AND owner_uid = " . $owner_uid);
1831 if (db_num_rows($result) == 1) {
1832 return db_fetch_result($result, 0, "access_key");
1834 $key = db_escape_string(uniqid_short());
1836 $result = db_query("INSERT INTO ttrss_access_keys
1837 (access_key, feed_id, is_cat, owner_uid)
1838 VALUES ('$key', '$feed_id', $sql_is_cat, '$owner_uid')");
1845 function get_feeds_from_html($url, $content)
1847 $url = fix_url($url);
1848 $baseUrl = substr($url, 0, strrpos($url, '/') +
1);
1850 libxml_use_internal_errors(true);
1852 $doc = new DOMDocument();
1853 $doc->loadHTML($content);
1854 $xpath = new DOMXPath($doc);
1855 $entries = $xpath->query('/html/head/link[@rel="alternate" and '.
1856 '(contains(@type,"rss") or contains(@type,"atom"))]|/html/head/link[@rel="feed"]');
1857 $feedUrls = array();
1858 foreach ($entries as $entry) {
1859 if ($entry->hasAttribute('href')) {
1860 $title = $entry->getAttribute('title');
1862 $title = $entry->getAttribute('type');
1864 $feedUrl = rewrite_relative_url(
1865 $baseUrl, $entry->getAttribute('href')
1867 $feedUrls[$feedUrl] = $title;
1873 function is_html($content) {
1874 return preg_match("/<html|DOCTYPE html/i", substr($content, 0, 100)) !== 0;
1877 function url_is_html($url, $login = false, $pass = false) {
1878 return is_html(fetch_file_contents($url, false, $login, $pass));
1881 function print_label_select($name, $value, $attributes = "") {
1883 $result = db_query("SELECT caption FROM ttrss_labels2
1884 WHERE owner_uid = '".$_SESSION["uid"]."' ORDER BY caption");
1886 print "<select default=\"$value\" name=\"" . htmlspecialchars($name) .
1887 "\" $attributes onchange=\"labelSelectOnChange(this)\" >";
1889 while ($line = db_fetch_assoc($result)) {
1891 $issel = ($line["caption"] == $value) ?
"selected=\"1\"" : "";
1893 print "<option value=\"".htmlspecialchars($line["caption"])."\"
1894 $issel>" . htmlspecialchars($line["caption"]) . "</option>";
1898 # print "<option value=\"ADD_LABEL\">" .__("Add label...") . "</option>";
1905 function format_article_enclosures($id, $always_display_enclosures,
1906 $article_content, $hide_images = false) {
1908 $result = get_article_enclosures($id);
1911 foreach (PluginHost
::getInstance()->get_hooks(PluginHost
::HOOK_FORMAT_ENCLOSURES
) as $plugin) {
1912 $retval = $plugin->hook_format_enclosures($rv, $result, $id, $always_display_enclosures, $article_content, $hide_images);
1913 if (is_array($retval)) {
1915 $result = $retval[1];
1920 unset($retval); // Unset to prevent breaking render if there are no HOOK_RENDER_ENCLOSURE hooks below.
1922 if ($rv === '' && !empty($result)) {
1923 $entries_html = array();
1925 $entries_inline = array();
1927 foreach ($result as $line) {
1929 $url = $line["content_url"];
1930 $ctype = $line["content_type"];
1931 $title = $line["title"];
1932 $width = $line["width"];
1933 $height = $line["height"];
1935 if (!$ctype) $ctype = __("unknown type");
1937 $filename = substr($url, strrpos($url, "/")+
1);
1939 $player = format_inline_player($url, $ctype);
1941 if ($player) array_push($entries_inline, $player);
1943 # $entry .= " <a target=\"_blank\" href=\"" . htmlspecialchars($url) . "\">" .
1944 # $filename . " (" . $ctype . ")" . "</a>";
1946 $entry = "<div onclick=\"window.open('".htmlspecialchars($url)."')\"
1947 dojoType=\"dijit.MenuItem\">$filename ($ctype)</div>";
1949 array_push($entries_html, $entry);
1953 $entry["type"] = $ctype;
1954 $entry["filename"] = $filename;
1955 $entry["url"] = $url;
1956 $entry["title"] = $title;
1957 $entry["width"] = $width;
1958 $entry["height"] = $height;
1960 array_push($entries, $entry);
1963 if ($_SESSION['uid'] && !get_pref("STRIP_IMAGES") && !$_SESSION["bw_limit"]) {
1964 if ($always_display_enclosures ||
1965 !preg_match("/<img/i", $article_content)) {
1967 foreach ($entries as $entry) {
1969 foreach (PluginHost
::getInstance()->get_hooks(PluginHost
::HOOK_RENDER_ENCLOSURE
) as $plugin)
1970 $retval = $plugin->hook_render_enclosure($entry, $hide_images);
1977 if (preg_match("/image/", $entry["type"]) ||
1978 preg_match("/\.(jpg|png|gif|bmp)/i", $entry["filename"])) {
1980 if (!$hide_images) {
1982 if ($entry['height'] > 0)
1983 $encsize .= ' height="' . intval($entry['height']) . '"';
1984 if ($entry['width'] > 0)
1985 $encsize .= ' width="' . intval($entry['width']) . '"';
1987 alt=\"".htmlspecialchars($entry["filename"])."\"
1988 src=\"" .htmlspecialchars($entry["url"]) . "\"
1989 " . $encsize . " /></p>";
1991 $rv .= "<p><a target=\"_blank\"
1992 href=\"".htmlspecialchars($entry["url"])."\"
1993 >" .htmlspecialchars($entry["url"]) . "</a></p>";
1996 if ($entry['title']) {
1997 $rv.= "<div class=\"enclosure_title\">${entry['title']}</div>";
2005 if (count($entries_inline) > 0) {
2006 $rv .= "<hr clear='both'/>";
2007 foreach ($entries_inline as $entry) { $rv .= $entry; };
2008 $rv .= "<hr clear='both'/>";
2011 $rv .= "<div class=\"attachments\" dojoType=\"dijit.form.DropDownButton\">".
2012 "<span>" . __('Attachments')."</span>";
2014 $rv .= "<div dojoType=\"dijit.Menu\" style=\"display: none;\">";
2016 foreach ($entries as $entry) {
2017 if ($entry["title"])
2018 $title = "— " . truncate_string($entry["title"], 30);
2022 $rv .= "<div onclick='window.open(\"".htmlspecialchars($entry["url"])."\")'
2023 dojoType=\"dijit.MenuItem\">".htmlspecialchars($entry["filename"])."$title</div>";
2034 function getLastArticleId() {
2035 $result = db_query("SELECT ref_id AS id FROM ttrss_user_entries
2036 WHERE owner_uid = " . $_SESSION["uid"] . " ORDER BY ref_id DESC LIMIT 1");
2038 if (db_num_rows($result) == 1) {
2039 return db_fetch_result($result, 0, "id");
2045 function build_url($parts) {
2046 return $parts['scheme'] . "://" . $parts['host'] . $parts['path'];
2050 * Converts a (possibly) relative URL to a absolute one.
2052 * @param string $url Base URL (i.e. from where the document is)
2053 * @param string $rel_url Possibly relative URL in the document
2055 * @return string Absolute URL
2057 function rewrite_relative_url($url, $rel_url) {
2058 if (strpos($rel_url, "://") !== false) {
2060 } else if (strpos($rel_url, "//") === 0) {
2061 # protocol-relative URL (rare but they exist)
2063 } else if (preg_match("/^[a-z]+:/i", $rel_url)) {
2064 # magnet:, feed:, etc
2066 } else if (strpos($rel_url, "/") === 0) {
2067 $parts = parse_url($url);
2068 $parts['path'] = $rel_url;
2070 return build_url($parts);
2073 $parts = parse_url($url);
2074 if (!isset($parts['path'])) {
2075 $parts['path'] = '/';
2077 $dir = $parts['path'];
2078 if (substr($dir, -1) !== '/') {
2079 $dir = dirname($parts['path']);
2080 $dir !== '/' && $dir .= '/';
2082 $parts['path'] = $dir . $rel_url;
2084 return build_url($parts);
2088 function cleanup_tags($days = 14, $limit = 1000) {
2090 if (DB_TYPE
== "pgsql") {
2091 $interval_query = "date_updated < NOW() - INTERVAL '$days days'";
2092 } else if (DB_TYPE
== "mysql") {
2093 $interval_query = "date_updated < DATE_SUB(NOW(), INTERVAL $days DAY)";
2098 while ($limit > 0) {
2101 $query = "SELECT ttrss_tags.id AS id
2102 FROM ttrss_tags, ttrss_user_entries, ttrss_entries
2103 WHERE post_int_id = int_id AND $interval_query AND
2104 ref_id = ttrss_entries.id AND tag_cache != '' LIMIT $limit_part";
2106 $result = db_query($query);
2110 while ($line = db_fetch_assoc($result)) {
2111 array_push($ids, $line['id']);
2114 if (count($ids) > 0) {
2115 $ids = join(",", $ids);
2117 $tmp_result = db_query("DELETE FROM ttrss_tags WHERE id IN ($ids)");
2118 $tags_deleted +
= db_affected_rows($tmp_result);
2123 $limit -= $limit_part;
2126 return $tags_deleted;
2129 function print_user_stylesheet() {
2130 $value = get_pref('USER_STYLESHEET');
2133 print "<style type=\"text/css\">";
2134 print str_replace("<br/>", "\n", $value);
2140 function filter_to_sql($filter, $owner_uid) {
2143 if (DB_TYPE
== "pgsql")
2146 $reg_qpart = "REGEXP";
2148 foreach ($filter["rules"] AS $rule) {
2149 $rule['reg_exp'] = str_replace('/', '\/', $rule["reg_exp"]);
2150 $regexp_valid = preg_match('/' . $rule['reg_exp'] . '/',
2151 $rule['reg_exp']) !== FALSE;
2153 if ($regexp_valid) {
2155 $rule['reg_exp'] = db_escape_string($rule['reg_exp']);
2157 switch ($rule["type"]) {
2159 $qpart = "LOWER(ttrss_entries.title) $reg_qpart LOWER('".
2160 $rule['reg_exp'] . "')";
2163 $qpart = "LOWER(ttrss_entries.content) $reg_qpart LOWER('".
2164 $rule['reg_exp'] . "')";
2167 $qpart = "LOWER(ttrss_entries.title) $reg_qpart LOWER('".
2168 $rule['reg_exp'] . "') OR LOWER(" .
2169 "ttrss_entries.content) $reg_qpart LOWER('" . $rule['reg_exp'] . "')";
2172 $qpart = "LOWER(ttrss_user_entries.tag_cache) $reg_qpart LOWER('".
2173 $rule['reg_exp'] . "')";
2176 $qpart = "LOWER(ttrss_entries.link) $reg_qpart LOWER('".
2177 $rule['reg_exp'] . "')";
2180 $qpart = "LOWER(ttrss_entries.author) $reg_qpart LOWER('".
2181 $rule['reg_exp'] . "')";
2185 if (isset($rule['inverse'])) $qpart = "NOT ($qpart)";
2187 if (isset($rule["feed_id"]) && $rule["feed_id"] > 0) {
2188 $qpart .= " AND feed_id = " . db_escape_string($rule["feed_id"]);
2191 if (isset($rule["cat_id"])) {
2193 if ($rule["cat_id"] > 0) {
2194 $children = getChildCategories($rule["cat_id"], $owner_uid);
2195 array_push($children, $rule["cat_id"]);
2197 $children = join(",", $children);
2199 $cat_qpart = "cat_id IN ($children)";
2201 $cat_qpart = "cat_id IS NULL";
2204 $qpart .= " AND $cat_qpart";
2207 $qpart .= " AND feed_id IS NOT NULL";
2209 array_push($query, "($qpart)");
2214 if (count($query) > 0) {
2215 $fullquery = "(" . join($filter["match_any_rule"] ?
"OR" : "AND", $query) . ")";
2217 $fullquery = "(false)";
2220 if ($filter['inverse']) $fullquery = "(NOT $fullquery)";
2225 if (!function_exists('gzdecode')) {
2226 function gzdecode($string) { // no support for 2nd argument
2227 return file_get_contents('compress.zlib://data:who/cares;base64,'.
2228 base64_encode($string));
2232 function get_random_bytes($length) {
2233 if (function_exists('openssl_random_pseudo_bytes')) {
2234 return openssl_random_pseudo_bytes($length);
2238 for ($i = 0; $i < $length; $i++
)
2239 $output .= chr(mt_rand(0, 255));
2245 function read_stdin() {
2246 $fp = fopen("php://stdin", "r");
2249 $line = trim(fgets($fp));
2257 function tmpdirname($path, $prefix) {
2258 // Use PHP's tmpfile function to create a temporary
2259 // directory name. Delete the file and keep the name.
2260 $tempname = tempnam($path,$prefix);
2264 if (!unlink($tempname))
2270 function getFeedCategory($feed) {
2271 $result = db_query("SELECT cat_id FROM ttrss_feeds
2272 WHERE id = '$feed'");
2274 if (db_num_rows($result) > 0) {
2275 return db_fetch_result($result, 0, "cat_id");
2282 function implements_interface($class, $interface) {
2283 return in_array($interface, class_implements($class));
2286 function get_minified_js($files) {
2287 require_once 'lib/jshrink/Minifier.php';
2291 foreach ($files as $js) {
2292 if (!isset($_GET['debug'])) {
2293 $cached_file = CACHE_DIR
. "/js/".basename($js).".js";
2295 if (file_exists($cached_file) && is_readable($cached_file) && filemtime($cached_file) >= filemtime("js/$js.js")) {
2297 list($header, $contents) = explode("\n", file_get_contents($cached_file), 2);
2299 if ($header && $contents) {
2300 list($htag, $hversion) = explode(":", $header);
2302 if ($htag == "tt-rss" && $hversion == VERSION
) {
2309 $minified = JShrink\Minifier
::minify(file_get_contents("js/$js.js"));
2310 file_put_contents($cached_file, "tt-rss:" . VERSION
. "\n" . $minified);
2314 $rv .= file_get_contents("js/$js.js"); // no cache in debug mode
2321 function stylesheet_tag($filename) {
2322 $timestamp = filemtime($filename);
2324 return "<link rel=\"stylesheet\" type=\"text/css\" href=\"$filename?$timestamp\"/>\n";
2327 function javascript_tag($filename) {
2330 if (!(strpos($filename, "?") === FALSE)) {
2331 $query = substr($filename, strpos($filename, "?")+
1);
2332 $filename = substr($filename, 0, strpos($filename, "?"));
2335 $timestamp = filemtime($filename);
2337 if ($query) $timestamp .= "&$query";
2339 return "<script type=\"text/javascript\" charset=\"utf-8\" src=\"$filename?$timestamp\"></script>\n";
2342 function calculate_dep_timestamp() {
2343 $files = array_merge(glob("js/*.js"), glob("css/*.css"));
2347 foreach ($files as $file) {
2348 if (filemtime($file) > $max_ts) $max_ts = filemtime($file);
2354 function T_js_decl($s1, $s2) {
2356 $s1 = preg_replace("/\n/", "", $s1);
2357 $s2 = preg_replace("/\n/", "", $s2);
2359 $s1 = preg_replace("/\"/", "\\\"", $s1);
2360 $s2 = preg_replace("/\"/", "\\\"", $s2);
2362 return "T_messages[\"$s1\"] = \"$s2\";\n";
2366 function init_js_translations() {
2368 print 'var T_messages = new Object();
2371 if (T_messages[msg]) {
2372 return T_messages[msg];
2378 function ngettext(msg1, msg2, n) {
2379 return __((parseInt(n) > 1) ? msg2 : msg1);
2382 $l10n = _get_reader();
2384 for ($i = 0; $i < $l10n->total
; $i++
) {
2385 $orig = $l10n->get_original_string($i);
2386 if(strpos($orig, "\000") !== FALSE) { // Plural forms
2387 $key = explode(chr(0), $orig);
2388 print T_js_decl($key[0], _ngettext($key[0], $key[1], 1)); // Singular
2389 print T_js_decl($key[1], _ngettext($key[0], $key[1], 2)); // Plural
2391 $translation = __($orig);
2392 print T_js_decl($orig, $translation);
2397 function label_to_feed_id($label) {
2398 return LABEL_BASE_INDEX
- 1 - abs($label);
2401 function feed_to_label_id($feed) {
2402 return LABEL_BASE_INDEX
- 1 +
abs($feed);
2405 function get_theme_path($theme) {
2406 $check = "themes/$theme";
2407 if (file_exists($check)) return $check;
2409 $check = "themes.local/$theme";
2410 if (file_exists($check)) return $check;
2413 function theme_valid($theme) {
2414 if ($theme == "default.css" ||
$theme == "night.css") return true; // needed for array_filter
2415 $file = "themes/" . basename($theme);
2417 if (!file_exists($file)) $file = "themes.local/" . basename($theme);
2419 if (file_exists($file) && is_readable($file)) {
2420 $fh = fopen($file, "r");
2423 $header = fgets($fh);
2426 return strpos($header, "supports-version:" . VERSION_STATIC
) !== FALSE;
2433 function error_json($code) {
2434 require_once "errors.php";
2436 @$message = $ERRORS[$code];
2438 return json_encode(array("error" =>
2439 array("code" => $code, "message" => $message)));
2443 function abs_to_rel_path($dir) {
2444 $tmp = str_replace(dirname(__DIR__
), "", $dir);
2446 if (strlen($tmp) > 0 && substr($tmp, 0, 1) == "/") $tmp = substr($tmp, 1);
2451 function get_upload_error_message($code) {
2454 0 => __('There is no error, the file uploaded with success'),
2455 1 => __('The uploaded file exceeds the upload_max_filesize directive in php.ini'),
2456 2 => __('The uploaded file exceeds the MAX_FILE_SIZE directive that was specified in the HTML form'),
2457 3 => __('The uploaded file was only partially uploaded'),
2458 4 => __('No file was uploaded'),
2459 6 => __('Missing a temporary folder'),
2460 7 => __('Failed to write file to disk.'),
2461 8 => __('A PHP extension stopped the file upload.'),
2464 return $errors[$code];