include/functions2.php

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