include/functions2.php

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