include/functions2.php

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