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