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