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