include/functions2.php

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