include/functions.php

   1 <?php
   2         define('EXPECTED_CONFIG_VERSION', 26);
   3         define('SCHEMA_VERSION', 123);
   4
   5         define('LABEL_BASE_INDEX', -1024);
   6         define('PLUGIN_FEED_BASE_INDEX', -128);
   7
   8         define('COOKIE_LIFETIME_LONG', 86400*365);
   9
  10         $fetch_last_error = false;
  11         $fetch_last_error_code = false;
  12         $fetch_last_content_type = false;
  13         $fetch_curl_used = false;
  14         $suppress_debugging = false;
  15
  16         mb_internal_encoding("UTF-8");
  17         date_default_timezone_set('UTC');
  18         if (defined('E_DEPRECATED')) {
  19                 error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);
  20         } else {
  21                 error_reporting(E_ALL & ~E_NOTICE);
  22         }
  23
  24         require_once 'config.php';
  25
  26         /**
  27          * Define a constant if not already defined
  28          *
  29          * @param string $name The constant name.
  30          * @param mixed $value The constant value.
  31          * @access public
  32          * @return boolean True if defined successfully or not.
  33          */
  34         function define_default($name, $value) {
  35                 defined($name) or define($name, $value);
  36         }
  37
  38         ///// Some defaults that you can override in config.php //////
  39
  40         define_default('FEED_FETCH_TIMEOUT', 45);
  41         // How may seconds to wait for response when requesting feed from a site
  42         define_default('FEED_FETCH_NO_CACHE_TIMEOUT', 15);
  43         // How may seconds to wait for response when requesting feed from a
  44         // site when that feed wasn't cached before
  45         define_default('FILE_FETCH_TIMEOUT', 45);
  46         // Default timeout when fetching files from remote sites
  47         define_default('FILE_FETCH_CONNECT_TIMEOUT', 15);
  48         // How many seconds to wait for initial response from website when
  49         // fetching files from remote sites
  50
  51         if (DB_TYPE == "pgsql") {
  52                 define('SUBSTRING_FOR_DATE', 'SUBSTRING_FOR_DATE');
  53         } else {
  54                 define('SUBSTRING_FOR_DATE', 'SUBSTRING');
  55         }
  56
  57         /**
  58          * Return available translations names.
  59          *
  60          * @access public
  61          * @return array A array of available translations.
  62          */
  63         function get_translations() {
  64                 $tr = array(
  65                                         "auto"  => "Detect automatically",
  66                                         "ca_CA" => "Català",
  67                                         "cs_CZ" => "Česky",
  68                                         "en_US" => "English",
  69                                         "es_ES" => "Español",
  70                                         "de_DE" => "Deutsch",
  71                                         "fr_FR" => "Français",
  72                                         "hu_HU" => "Magyar (Hungarian)",
  73                                         "it_IT" => "Italiano",
  74                                         "ja_JP" => "日本語 (Japanese)",
  75                                         "lv_LV" => "Latviešu",
  76                                         "nb_NO" => "Norwegian bokmål",
  77                                         "nl_NL" => "Dutch",
  78                                         "pl_PL" => "Polski",
  79                                         "ru_RU" => "Русский",
  80                                         "pt_BR" => "Portuguese/Brazil",
  81                                         "zh_CN" => "Simplified Chinese",
  82                                         "sv_SE" => "Svenska",
  83                                         "fi_FI" => "Suomi",
  84                                         "tr_TR" => "Türkçe");
  85
  86                 return $tr;
  87         }
  88
  89         require_once "lib/accept-to-gettext.php";
  90         require_once "lib/gettext/gettext.inc";
  91
  92         require_once "lib/languagedetect/LanguageDetect.php";
  93
  94         function startup_gettext() {
  95
  96                 # Get locale from Accept-Language header
  97                 $lang = al2gt(array_keys(get_translations()), "text/html");
  98
  99                 if (defined('_TRANSLATION_OVERRIDE_DEFAULT')) {
 100                         $lang = _TRANSLATION_OVERRIDE_DEFAULT;
 101                 }
 102
 103                 if ($_SESSION["uid"] && get_schema_version() >= 120) {
 104                         $pref_lang = get_pref("USER_LANGUAGE", $_SESSION["uid"]);
 105
 106                         if ($pref_lang && $pref_lang != 'auto') {
 107                                 $lang = $pref_lang;
 108                         }
 109                 }
 110
 111                 if ($lang) {
 112                         if (defined('LC_MESSAGES')) {
 113                                 _setlocale(LC_MESSAGES, $lang);
 114                         } else if (defined('LC_ALL')) {
 115                                 _setlocale(LC_ALL, $lang);
 116                         }
 117
 118                         _bindtextdomain("messages", "locale");
 119
 120                         _textdomain("messages");
 121                         _bind_textdomain_codeset("messages", "UTF-8");
 122                 }
 123         }
 124
 125         require_once 'db-prefs.php';
 126         require_once 'version.php';
 127         require_once 'ccache.php';
 128         require_once 'labels.php';
 129
 130         define('SELF_USER_AGENT', 'Tiny Tiny RSS/' . VERSION . ' (http://tt-rss.org/)');
 131         ini_set('user_agent', SELF_USER_AGENT);
 132
 133         require_once 'lib/pubsubhubbub/publisher.php';
 134
 135         $schema_version = false;
 136
 137         function _debug_suppress($suppress) {
 138                 global $suppress_debugging;
 139
 140                 $suppress_debugging = $suppress;
 141         }
 142
 143         /**
 144          * Print a timestamped debug message.
 145          *
 146          * @param string $msg The debug message.
 147          * @return void
 148          */
 149         function _debug($msg, $show = true) {
 150                 global $suppress_debugging;
 151
 152                 //echo "[$suppress_debugging] $msg $show\n";
 153
 154                 if ($suppress_debugging) return false;
 155
 156                 $ts = strftime("%H:%M:%S", time());
 157                 if (function_exists('posix_getpid')) {
 158                         $ts = "$ts/" . posix_getpid();
 159                 }
 160
 161                 if ($show && !(defined('QUIET') && QUIET)) {
 162                         print "[$ts] $msg\n";
 163                 }
 164
 165                 if (defined('LOGFILE'))  {
 166                         $fp = fopen(LOGFILE, 'a+');
 167
 168                         if ($fp) {
 169                                 $locked = false;
 170
 171                                 if (function_exists("flock")) {
 172                                         $tries = 0;
 173
 174                                         // try to lock logfile for writing
 175                                         while ($tries < 5 && !$locked = flock($fp, LOCK_EX | LOCK_NB)) {
 176                                                 sleep(1);
 177                                                 ++$tries;
 178                                         }
 179
 180                                         if (!$locked) {
 181                                                 fclose($fp);
 182                                                 return;
 183                                         }
 184                                 }
 185
 186                                 fputs($fp, "[$ts] $msg\n");
 187
 188                                 if (function_exists("flock")) {
 189                                         flock($fp, LOCK_UN);
 190                                 }
 191
 192                                 fclose($fp);
 193                         }
 194                 }
 195
 196         } // function _debug
 197
 198         /**
 199          * Purge a feed old posts.
 200          *
 201          * @param mixed $link A database connection.
 202          * @param mixed $feed_id The id of the purged feed.
 203          * @param mixed $purge_interval Olderness of purged posts.
 204          * @param boolean $debug Set to True to enable the debug. False by default.
 205          * @access public
 206          * @return void
 207          */
 208         function purge_feed($feed_id, $purge_interval, $debug = false) {
 209
 210                 if (!$purge_interval) $purge_interval = feed_purge_interval($feed_id);
 211
 212                 $rows = -1;
 213
 214                 $result = db_query(
 215                         "SELECT owner_uid FROM ttrss_feeds WHERE id = '$feed_id'");
 216
 217                 $owner_uid = false;
 218
 219                 if (db_num_rows($result) == 1) {
 220                         $owner_uid = db_fetch_result($result, 0, "owner_uid");
 221                 }
 222
 223                 if ($purge_interval == -1 || !$purge_interval) {
 224                         if ($owner_uid) {
 225                                 ccache_update($feed_id, $owner_uid);
 226                         }
 227                         return;
 228                 }
 229
 230                 if (!$owner_uid) return;
 231
 232                 if (FORCE_ARTICLE_PURGE == 0) {
 233                         $purge_unread = get_pref("PURGE_UNREAD_ARTICLES",
 234                                 $owner_uid, false);
 235                 } else {
 236                         $purge_unread = true;
 237                         $purge_interval = FORCE_ARTICLE_PURGE;
 238                 }
 239
 240                 if (!$purge_unread) $query_limit = " unread = false AND ";
 241
 242                 if (DB_TYPE == "pgsql") {
 243                         $pg_version = get_pgsql_version();
 244
 245                         if (preg_match("/^7\./", $pg_version) || preg_match("/^8\.0/", $pg_version)) {
 246
 247                                 $result = db_query("DELETE FROM ttrss_user_entries WHERE
 248                                         ttrss_entries.id = ref_id AND
 249                                         marked = false AND
 250                                         feed_id = '$feed_id' AND
 251                                         $query_limit
 252                                         ttrss_entries.date_updated < NOW() - INTERVAL '$purge_interval days'");
 253
 254                         } else {
 255
 256                                 $result = db_query("DELETE FROM ttrss_user_entries
 257                                         USING ttrss_entries
 258                                         WHERE ttrss_entries.id = ref_id AND
 259                                         marked = false AND
 260                                         feed_id = '$feed_id' AND
 261                                         $query_limit
 262                                         ttrss_entries.date_updated < NOW() - INTERVAL '$purge_interval days'");
 263                         }
 264
 265                 } else {
 266
 267 /*                      $result = db_query("DELETE FROM ttrss_user_entries WHERE
 268                                 marked = false AND feed_id = '$feed_id' AND
 269                                 (SELECT date_updated FROM ttrss_entries WHERE
 270                                         id = ref_id) < DATE_SUB(NOW(), INTERVAL $purge_interval DAY)"); */
 271
 272                         $result = db_query("DELETE FROM ttrss_user_entries
 273                                 USING ttrss_user_entries, ttrss_entries
 274                                 WHERE ttrss_entries.id = ref_id AND
 275                                 marked = false AND
 276                                 feed_id = '$feed_id' AND
 277                                 $query_limit
 278                                 ttrss_entries.date_updated < DATE_SUB(NOW(), INTERVAL $purge_interval DAY)");
 279                 }
 280
 281                 $rows = db_affected_rows($result);
 282
 283                 ccache_update($feed_id, $owner_uid);
 284
 285                 if ($debug) {
 286                         _debug("Purged feed $feed_id ($purge_interval): deleted $rows articles");
 287                 }
 288
 289                 return $rows;
 290         } // function purge_feed
 291
 292         function feed_purge_interval($feed_id) {
 293
 294                 $result = db_query("SELECT purge_interval, owner_uid FROM ttrss_feeds
 295                         WHERE id = '$feed_id'");
 296
 297                 if (db_num_rows($result) == 1) {
 298                         $purge_interval = db_fetch_result($result, 0, "purge_interval");
 299                         $owner_uid = db_fetch_result($result, 0, "owner_uid");
 300
 301                         if ($purge_interval == 0) $purge_interval = get_pref(
 302                                 'PURGE_OLD_DAYS', $owner_uid);
 303
 304                         return $purge_interval;
 305
 306                 } else {
 307                         return -1;
 308                 }
 309         }
 310
 311         function purge_orphans($do_output = false) {
 312
 313                 // purge orphaned posts in main content table
 314                 $result = db_query("DELETE FROM ttrss_entries WHERE
 315                         (SELECT COUNT(int_id) FROM ttrss_user_entries WHERE ref_id = id) = 0");
 316
 317                 if ($do_output) {
 318                         $rows = db_affected_rows($result);
 319                         _debug("Purged $rows orphaned posts.");
 320                 }
 321         }
 322
 323         function get_feed_update_interval($feed_id) {
 324                 $result = db_query("SELECT owner_uid, update_interval FROM
 325                         ttrss_feeds WHERE id = '$feed_id'");
 326
 327                 if (db_num_rows($result) == 1) {
 328                         $update_interval = db_fetch_result($result, 0, "update_interval");
 329                         $owner_uid = db_fetch_result($result, 0, "owner_uid");
 330
 331                         if ($update_interval != 0) {
 332                                 return $update_interval;
 333                         } else {
 334                                 return get_pref('DEFAULT_UPDATE_INTERVAL', $owner_uid, false);
 335                         }
 336
 337                 } else {
 338                         return -1;
 339                 }
 340         }
 341
 342         function fetch_file_contents($url, $type = false, $login = false, $pass = false, $post_query = false, $timeout = false, $timestamp = 0, $useragent = false) {
 343
 344                 global $fetch_last_error;
 345                 global $fetch_last_error_code;
 346                 global $fetch_last_content_type;
 347                 global $fetch_curl_used;
 348
 349                 $url = str_replace(' ', '%20', $url);
 350
 351                 if (!defined('NO_CURL') && function_exists('curl_init')) {
 352
 353                         $fetch_curl_used = true;
 354
 355                         if (ini_get("safe_mode") || ini_get("open_basedir")) {
 356                                 $new_url = geturl($url);
 357                                 if (!$new_url) {
 358                                     // geturl has already populated $fetch_last_error
 359                                     return false;
 360                                 }
 361                                 $ch = curl_init($new_url);
 362                         } else {
 363                                 $ch = curl_init($url);
 364                         }
 365
 366                         if ($timestamp && !$post_query) {
 367                                 curl_setopt($ch, CURLOPT_HTTPHEADER,
 368                                         array("If-Modified-Since: ".gmdate('D, d M Y H:i:s \G\M\T', $timestamp)));
 369                         }
 370
 371                         curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, $timeout ? $timeout : FILE_FETCH_CONNECT_TIMEOUT);
 372                         curl_setopt($ch, CURLOPT_TIMEOUT, $timeout ? $timeout : FILE_FETCH_TIMEOUT);
 373                         curl_setopt($ch, CURLOPT_FOLLOWLOCATION, !ini_get("safe_mode") && !ini_get("open_basedir"));
 374                         curl_setopt($ch, CURLOPT_MAXREDIRS, 20);
 375                         curl_setopt($ch, CURLOPT_BINARYTRANSFER, true);
 376                         curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
 377                         curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
 378                         curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_ANY);
 379                         curl_setopt($ch, CURLOPT_USERAGENT, $useragent ? $useragent :
 380                                 SELF_USER_AGENT);
 381                         curl_setopt($ch, CURLOPT_ENCODING, "");
 382                         curl_setopt($ch, CURLOPT_REFERER, $url);
 383
 384                         if (!ini_get("safe_mode") && !ini_get("open_basedir")) {
 385                                 curl_setopt($ch, CURLOPT_COOKIEJAR, "/dev/null");
 386                         }
 387
 388                         if (defined('_CURL_HTTP_PROXY')) {
 389                                 curl_setopt($ch, CURLOPT_PROXY, _CURL_HTTP_PROXY);
 390                         }
 391
 392                         if ($post_query) {
 393                                 curl_setopt($ch, CURLOPT_POST, true);
 394                                 curl_setopt($ch, CURLOPT_POSTFIELDS, $post_query);
 395                         }
 396
 397                         if ((OPENSSL_VERSION_NUMBER >= 0x0090808f) && (OPENSSL_VERSION_NUMBER < 0x10000000)) {
 398                                 curl_setopt($ch, CURLOPT_SSLVERSION, 3);
 399                         }
 400
 401                         if ($login && $pass)
 402                                 curl_setopt($ch, CURLOPT_USERPWD, "$login:$pass");
 403
 404                         $contents = @curl_exec($ch);
 405
 406                         if (curl_errno($ch) === 23 || curl_errno($ch) === 61) {
 407                                 curl_setopt($ch, CURLOPT_ENCODING, 'none');
 408                                 $contents = @curl_exec($ch);
 409                         }
 410
 411                         if ($contents === false) {
 412                                 $fetch_last_error = curl_errno($ch) . " " . curl_error($ch);
 413                                 curl_close($ch);
 414                                 return false;
 415                         }
 416
 417                         $http_code = curl_getinfo($ch, CURLINFO_HTTP_CODE);
 418                         $fetch_last_content_type = curl_getinfo($ch, CURLINFO_CONTENT_TYPE);
 419
 420                         $fetch_last_error_code = $http_code;
 421
 422                         if ($http_code != 200 || $type && strpos($fetch_last_content_type, "$type") === false) {
 423                                 if (curl_errno($ch) != 0) {
 424                                         $fetch_last_error = curl_errno($ch) . " " . curl_error($ch);
 425                                 } else {
 426                                         $fetch_last_error = "HTTP Code: $http_code";
 427                                 }
 428                                 curl_close($ch);
 429                                 return false;
 430                         }
 431
 432                         curl_close($ch);
 433
 434                         return $contents;
 435                 } else {
 436
 437                         $fetch_curl_used = false;
 438
 439                         if ($login && $pass){
 440                                 $url_parts = array();
 441
 442                                 preg_match("/(^[^:]*):\/\/(.*)/", $url, $url_parts);
 443
 444                                 $pass = urlencode($pass);
 445
 446                                 if ($url_parts[1] && $url_parts[2]) {
 447                                         $url = $url_parts[1] . "://$login:$pass@" . $url_parts[2];
 448                                 }
 449                         }
 450
 451                         if (!$post_query && $timestamp) {
 452                                 $context = stream_context_create(array(
 453                                         'http' => array(
 454                                                 'method' => 'GET',
 455                                                 'header' => "If-Modified-Since: ".gmdate("D, d M Y H:i:s \\G\\M\\T\r\n", $timestamp)
 456                                         )));
 457                         } else {
 458                                 $context = NULL;
 459                         }
 460
 461                         $old_error = error_get_last();
 462
 463                         $data = @file_get_contents($url, false, $context);
 464
 465                         $fetch_last_content_type = false;  // reset if no type was sent from server
 466                         if (isset($http_response_header) && is_array($http_response_header)) {
 467                                 foreach ($http_response_header as $h) {
 468                                         if (substr(strtolower($h), 0, 13) == 'content-type:') {
 469                                                 $fetch_last_content_type = substr($h, 14);
 470                                                 // don't abort here b/c there might be more than one
 471                                                 // e.g. if we were being redirected -- last one is the right one
 472                                         }
 473
 474                                         if (substr(strtolower($h), 0, 7) == 'http/1.') {
 475                                                 $fetch_last_error_code = (int) substr($h, 9, 3);
 476                                         }
 477                                 }
 478                         }
 479
 480                         if (!$data) {
 481                                 $error = error_get_last();
 482
 483                                 if ($error['message'] != $old_error['message']) {
 484                                         $fetch_last_error = $error["message"];
 485                                 } else {
 486                                         $fetch_last_error = "HTTP Code: $fetch_last_error_code";
 487                                 }
 488                         }
 489                         return $data;
 490                 }
 491
 492         }
 493
 494         /**
 495          * Try to determine the favicon URL for a feed.
 496          * adapted from wordpress favicon plugin by Jeff Minard (http://thecodepro.com/)
 497          * http://dev.wp-plugins.org/file/favatars/trunk/favatars.php
 498          *
 499          * @param string $url A feed or page URL
 500          * @access public
 501          * @return mixed The favicon URL, or false if none was found.
 502          */
 503         function get_favicon_url($url) {
 504
 505                 $favicon_url = false;
 506
 507                 if ($html = @fetch_file_contents($url)) {
 508
 509                         libxml_use_internal_errors(true);
 510
 511                         $doc = new DOMDocument();
 512                         $doc->loadHTML($html);
 513                         $xpath = new DOMXPath($doc);
 514
 515                         $base = $xpath->query('/html/head/base');
 516                         foreach ($base as $b) {
 517                                 $url = $b->getAttribute("href");
 518                                 break;
 519                         }
 520
 521                         $entries = $xpath->query('/html/head/link[@rel="shortcut icon" or @rel="icon"]');
 522                         if (count($entries) > 0) {
 523                                 foreach ($entries as $entry) {
 524                                         $favicon_url = rewrite_relative_url($url, $entry->getAttribute("href"));
 525                                         break;
 526                                 }
 527                         }
 528                 }
 529
 530                 if (!$favicon_url)
 531                         $favicon_url = rewrite_relative_url($url, "/favicon.ico");
 532
 533                 return $favicon_url;
 534         } // function get_favicon_url
 535
 536         function check_feed_favicon($site_url, $feed) {
 537 #               print "FAVICON [$site_url]: $favicon_url\n";
 538
 539                 $icon_file = ICONS_DIR . "/$feed.ico";
 540
 541                 if (!file_exists($icon_file)) {
 542                         $favicon_url = get_favicon_url($site_url);
 543
 544                         if ($favicon_url) {
 545                                 // Limiting to "image" type misses those served with text/plain
 546                                 $contents = fetch_file_contents($favicon_url); // , "image");
 547
 548                                 if ($contents) {
 549                                         // Crude image type matching.
 550                                         // Patterns gleaned from the file(1) source code.
 551                                         if (preg_match('/^\x00\x00\x01\x00/', $contents)) {
 552                                                 // 0       string  \000\000\001\000        MS Windows icon resource
 553                                                 //error_log("check_feed_favicon: favicon_url=$favicon_url isa MS Windows icon resource");
 554                                         }
 555                                         elseif (preg_match('/^GIF8/', $contents)) {
 556                                                 // 0       string          GIF8            GIF image data
 557                                                 //error_log("check_feed_favicon: favicon_url=$favicon_url isa GIF image");
 558                                         }
 559                                         elseif (preg_match('/^\x89PNG\x0d\x0a\x1a\x0a/', $contents)) {
 560                                                 // 0       string          \x89PNG\x0d\x0a\x1a\x0a         PNG image data
 561                                                 //error_log("check_feed_favicon: favicon_url=$favicon_url isa PNG image");
 562                                         }
 563                                         elseif (preg_match('/^\xff\xd8/', $contents)) {
 564                                                 // 0       beshort         0xffd8          JPEG image data
 565                                                 //error_log("check_feed_favicon: favicon_url=$favicon_url isa JPG image");
 566                                         }
 567                                         else {
 568                                                 //error_log("check_feed_favicon: favicon_url=$favicon_url isa UNKNOWN type");
 569                                                 $contents = "";
 570                                         }
 571                                 }
 572
 573                                 if ($contents) {
 574                                         $fp = @fopen($icon_file, "w");
 575
 576                                         if ($fp) {
 577                                                 fwrite($fp, $contents);
 578                                                 fclose($fp);
 579                                                 chmod($icon_file, 0644);
 580                                         }
 581                                 }
 582                         }
 583             return $icon_file;
 584                 }
 585         }
 586
 587         function print_select($id, $default, $values, $attributes = "") {
 588                 print "<select name=\"$id\" id=\"$id\" $attributes>";
 589                 foreach ($values as $v) {
 590                         if ($v == $default)
 591                                 $sel = "selected=\"1\"";
 592                          else
 593                                 $sel = "";
 594
 595                         $v = trim($v);
 596
 597                         print "<option value=\"$v\" $sel>$v</option>";
 598                 }
 599                 print "</select>";
 600         }
 601
 602         function print_select_hash($id, $default, $values, $attributes = "") {
 603                 print "<select name=\"$id\" id='$id' $attributes>";
 604                 foreach (array_keys($values) as $v) {
 605                         if ($v == $default)
 606                                 $sel = 'selected="selected"';
 607                          else
 608                                 $sel = "";
 609
 610                         $v = trim($v);
 611
 612                         print "<option $sel value=\"$v\">".$values[$v]."</option>";
 613                 }
 614
 615                 print "</select>";
 616         }
 617
 618         function print_radio($id, $default, $true_is, $values, $attributes = "") {
 619                 foreach ($values as $v) {
 620
 621                         if ($v == $default)
 622                                 $sel = "checked";
 623                          else
 624                                 $sel = "";
 625
 626                         if ($v == $true_is) {
 627                                 $sel .= " value=\"1\"";
 628                         } else {
 629                                 $sel .= " value=\"0\"";
 630                         }
 631
 632                         print "<input class=\"noborder\" dojoType=\"dijit.form.RadioButton\"
 633                                 type=\"radio\" $sel $attributes name=\"$id\">&nbsp;$v&nbsp;";
 634
 635                 }
 636         }
 637
 638         function initialize_user_prefs($uid, $profile = false) {
 639
 640                 $uid = db_escape_string($uid);
 641
 642                 if (!$profile) {
 643                         $profile = "NULL";
 644                         $profile_qpart = "AND profile IS NULL";
 645                 } else {
 646                         $profile_qpart = "AND profile = '$profile'";
 647                 }
 648
 649                 if (get_schema_version() < 63) $profile_qpart = "";
 650
 651                 db_query("BEGIN");
 652
 653                 $result = db_query("SELECT pref_name,def_value FROM ttrss_prefs");
 654
 655                 $u_result = db_query("SELECT pref_name
 656                         FROM ttrss_user_prefs WHERE owner_uid = '$uid' $profile_qpart");
 657
 658                 $active_prefs = array();
 659
 660                 while ($line = db_fetch_assoc($u_result)) {
 661                         array_push($active_prefs, $line["pref_name"]);
 662                 }
 663
 664                 while ($line = db_fetch_assoc($result)) {
 665                         if (array_search($line["pref_name"], $active_prefs) === FALSE) {
 666 //                              print "adding " . $line["pref_name"] . "<br>";
 667
 668                                 $line["def_value"] = db_escape_string($line["def_value"]);
 669                                 $line["pref_name"] = db_escape_string($line["pref_name"]);
 670
 671                                 if (get_schema_version() < 63) {
 672                                         db_query("INSERT INTO ttrss_user_prefs
 673                                                 (owner_uid,pref_name,value) VALUES
 674                                                 ('$uid', '".$line["pref_name"]."','".$line["def_value"]."')");
 675
 676                                 } else {
 677                                         db_query("INSERT INTO ttrss_user_prefs
 678                                                 (owner_uid,pref_name,value, profile) VALUES
 679                                                 ('$uid', '".$line["pref_name"]."','".$line["def_value"]."', $profile)");
 680                                 }
 681
 682                         }
 683                 }
 684
 685                 db_query("COMMIT");
 686
 687         }
 688
 689         function get_ssl_certificate_id() {
 690                 if ($_SERVER["REDIRECT_SSL_CLIENT_M_SERIAL"]) {
 691                         return sha1($_SERVER["REDIRECT_SSL_CLIENT_M_SERIAL"] .
 692                                 $_SERVER["REDIRECT_SSL_CLIENT_V_START"] .
 693                                 $_SERVER["REDIRECT_SSL_CLIENT_V_END"] .
 694                                 $_SERVER["REDIRECT_SSL_CLIENT_S_DN"]);
 695                 }
 696                 if ($_SERVER["SSL_CLIENT_M_SERIAL"]) {
 697                         return sha1($_SERVER["SSL_CLIENT_M_SERIAL"] .
 698                                 $_SERVER["SSL_CLIENT_V_START"] .
 699                                 $_SERVER["SSL_CLIENT_V_END"] .
 700                                 $_SERVER["SSL_CLIENT_S_DN"]);
 701                 }
 702                 return "";
 703         }
 704
 705         function authenticate_user($login, $password, $check_only = false) {
 706
 707                 if (!SINGLE_USER_MODE) {
 708                         $user_id = false;
 709
 710                         foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_AUTH_USER) as $plugin) {
 711
 712                                 $user_id = (int) $plugin->authenticate($login, $password);
 713
 714                                 if ($user_id) {
 715                                         $_SESSION["auth_module"] = strtolower(get_class($plugin));
 716                                         break;
 717                                 }
 718                         }
 719
 720                         if ($user_id && !$check_only) {
 721                                 @session_start();
 722
 723                                 $_SESSION["uid"] = $user_id;
 724                                 $_SESSION["version"] = VERSION_STATIC;
 725
 726                                 $result = db_query("SELECT login,access_level,pwd_hash FROM ttrss_users
 727                                         WHERE id = '$user_id'");
 728
 729                                 $_SESSION["name"] = db_fetch_result($result, 0, "login");
 730                                 $_SESSION["access_level"] = db_fetch_result($result, 0, "access_level");
 731                                 $_SESSION["csrf_token"] = uniqid(rand(), true);
 732
 733                                 db_query("UPDATE ttrss_users SET last_login = NOW() WHERE id = " .
 734                                         $_SESSION["uid"]);
 735
 736                                 $_SESSION["ip_address"] = $_SERVER["REMOTE_ADDR"];
 737                                 $_SESSION["user_agent"] = sha1($_SERVER['HTTP_USER_AGENT']);
 738                                 $_SESSION["pwd_hash"] = db_fetch_result($result, 0, "pwd_hash");
 739
 740                                 $_SESSION["last_version_check"] = time();
 741
 742                                 initialize_user_prefs($_SESSION["uid"]);
 743
 744                                 return true;
 745                         }
 746
 747                         return false;
 748
 749                 } else {
 750
 751                         $_SESSION["uid"] = 1;
 752                         $_SESSION["name"] = "admin";
 753                         $_SESSION["access_level"] = 10;
 754
 755                         $_SESSION["hide_hello"] = true;
 756                         $_SESSION["hide_logout"] = true;
 757
 758                         $_SESSION["auth_module"] = false;
 759
 760                         if (!$_SESSION["csrf_token"]) {
 761                                 $_SESSION["csrf_token"] = uniqid(rand(), true);
 762                         }
 763
 764                         $_SESSION["ip_address"] = $_SERVER["REMOTE_ADDR"];
 765
 766                         initialize_user_prefs($_SESSION["uid"]);
 767
 768                         return true;
 769                 }
 770         }
 771
 772         function make_password($length = 8) {
 773
 774                 $password = "";
 775                 $possible = "0123456789abcdfghjkmnpqrstvwxyzABCDFGHJKMNPQRSTVWXYZ";
 776
 777         $i = 0;
 778
 779                 while ($i < $length) {
 780                         $char = substr($possible, mt_rand(0, strlen($possible)-1), 1);
 781
 782                         if (!strstr($password, $char)) {
 783                                 $password .= $char;
 784                                 $i++;
 785                         }
 786                 }
 787                 return $password;
 788         }
 789
 790         // this is called after user is created to initialize default feeds, labels
 791         // or whatever else
 792
 793         // user preferences are checked on every login, not here
 794
 795         function initialize_user($uid) {
 796
 797                 db_query("insert into ttrss_feeds (owner_uid,title,feed_url)
 798                         values ('$uid', 'Tiny Tiny RSS: New Releases',
 799                         'http://tt-rss.org/releases.rss')");
 800
 801                 db_query("insert into ttrss_feeds (owner_uid,title,feed_url)
 802                         values ('$uid', 'Tiny Tiny RSS: Forum',
 803                                 'http://tt-rss.org/forum/rss.php')");
 804         }
 805
 806         function logout_user() {
 807                 session_destroy();
 808                 if (isset($_COOKIE[session_name()])) {
 809                    setcookie(session_name(), '', time()-42000, '/');
 810                 }
 811         }
 812
 813         function validate_csrf($csrf_token) {
 814                 return $csrf_token == $_SESSION['csrf_token'];
 815         }
 816
 817         function load_user_plugins($owner_uid) {
 818                 if ($owner_uid && SCHEMA_VERSION >= 100) {
 819                         $plugins = get_pref("_ENABLED_PLUGINS", $owner_uid);
 820
 821                         PluginHost::getInstance()->load($plugins, PluginHost::KIND_USER, $owner_uid);
 822
 823                         if (get_schema_version() > 100) {
 824                                 PluginHost::getInstance()->load_data();
 825                         }
 826                 }
 827         }
 828
 829         function login_sequence() {
 830                 if (SINGLE_USER_MODE) {
 831                         @session_start();
 832                         authenticate_user("admin", null);
 833                         startup_gettext();
 834                         load_user_plugins($_SESSION["uid"]);
 835                 } else {
 836                         if (!validate_session()) $_SESSION["uid"] = false;
 837
 838                         if (!$_SESSION["uid"]) {
 839
 840                                 if (AUTH_AUTO_LOGIN && authenticate_user(null, null)) {
 841                                     $_SESSION["ref_schema_version"] = get_schema_version(true);
 842                                 } else {
 843                                          authenticate_user(null, null, true);
 844                                 }
 845
 846                                 if (!$_SESSION["uid"]) {
 847                                         @session_destroy();
 848                                         setcookie(session_name(), '', time()-42000, '/');
 849
 850                                         render_login_form();
 851                                         exit;
 852                                 }
 853
 854                         } else {
 855                                 /* bump login timestamp */
 856                                 db_query("UPDATE ttrss_users SET last_login = NOW() WHERE id = " .
 857                                         $_SESSION["uid"]);
 858                                 $_SESSION["last_login_update"] = time();
 859                         }
 860
 861                         if ($_SESSION["uid"]) {
 862                                 startup_gettext();
 863                                 load_user_plugins($_SESSION["uid"]);
 864
 865                                 /* cleanup ccache */
 866
 867                                 db_query("DELETE FROM ttrss_counters_cache WHERE owner_uid = ".
 868                                         $_SESSION["uid"] . " AND
 869                                                 (SELECT COUNT(id) FROM ttrss_feeds WHERE
 870                                                         ttrss_feeds.id = feed_id) = 0");
 871
 872                                 db_query("DELETE FROM ttrss_cat_counters_cache WHERE owner_uid = ".
 873                                         $_SESSION["uid"] . " AND
 874                                                 (SELECT COUNT(id) FROM ttrss_feed_categories WHERE
 875                                                         ttrss_feed_categories.id = feed_id) = 0");
 876
 877                         }
 878
 879                 }
 880         }
 881
 882         function truncate_string($str, $max_len, $suffix = '&hellip;') {
 883                 if (mb_strlen($str, "utf-8") > $max_len) {
 884                         return mb_substr($str, 0, $max_len, "utf-8") . $suffix;
 885                 } else {
 886                         return $str;
 887                 }
 888         }
 889
 890         function convert_timestamp($timestamp, $source_tz, $dest_tz) {
 891
 892                 try {
 893                         $source_tz = new DateTimeZone($source_tz);
 894                 } catch (Exception $e) {
 895                         $source_tz = new DateTimeZone('UTC');
 896                 }
 897
 898                 try {
 899                         $dest_tz = new DateTimeZone($dest_tz);
 900                 } catch (Exception $e) {
 901                         $dest_tz = new DateTimeZone('UTC');
 902                 }
 903
 904                 $dt = new DateTime(date('Y-m-d H:i:s', $timestamp), $source_tz);
 905                 return $dt->format('U') + $dest_tz->getOffset($dt);
 906         }
 907
 908         function make_local_datetime($timestamp, $long, $owner_uid = false,
 909                                         $no_smart_dt = false) {
 910
 911                 if (!$owner_uid) $owner_uid = $_SESSION['uid'];
 912                 if (!$timestamp) $timestamp = '1970-01-01 0:00';
 913
 914                 global $utc_tz;
 915                 global $user_tz;
 916
 917                 if (!$utc_tz) $utc_tz = new DateTimeZone('UTC');
 918
 919                 $timestamp = substr($timestamp, 0, 19);
 920
 921                 # We store date in UTC internally
 922                 $dt = new DateTime($timestamp, $utc_tz);
 923
 924                 $user_tz_string = get_pref('USER_TIMEZONE', $owner_uid);
 925
 926                 if ($user_tz_string != 'Automatic') {
 927
 928                         try {
 929                                 if (!$user_tz) $user_tz = new DateTimeZone($user_tz_string);
 930                         } catch (Exception $e) {
 931                                 $user_tz = $utc_tz;
 932                         }
 933
 934                         $tz_offset = $user_tz->getOffset($dt);
 935                 } else {
 936                         $tz_offset = (int) -$_SESSION["clientTzOffset"];
 937                 }
 938
 939                 $user_timestamp = $dt->format('U') + $tz_offset;
 940
 941                 if (!$no_smart_dt) {
 942                         return smart_date_time($user_timestamp,
 943                                 $tz_offset, $owner_uid);
 944                 } else {
 945                         if ($long)
 946                                 $format = get_pref('LONG_DATE_FORMAT', $owner_uid);
 947                         else
 948                                 $format = get_pref('SHORT_DATE_FORMAT', $owner_uid);
 949
 950                         return date($format, $user_timestamp);
 951                 }
 952         }
 953
 954         function smart_date_time($timestamp, $tz_offset = 0, $owner_uid = false) {
 955                 if (!$owner_uid) $owner_uid = $_SESSION['uid'];
 956
 957                 if (date("Y.m.d", $timestamp) == date("Y.m.d", time() + $tz_offset)) {
 958                         return date("G:i", $timestamp);
 959                 } else if (date("Y", $timestamp) == date("Y", time() + $tz_offset)) {
 960                         $format = get_pref('SHORT_DATE_FORMAT', $owner_uid);
 961                         return date($format, $timestamp);
 962                 } else {
 963                         $format = get_pref('LONG_DATE_FORMAT', $owner_uid);
 964                         return date($format, $timestamp);
 965                 }
 966         }
 967
 968         function sql_bool_to_bool($s) {
 969                 if ($s == "t" || $s == "1" || strtolower($s) == "true") {
 970                         return true;
 971                 } else {
 972                         return false;
 973                 }
 974         }
 975
 976         function bool_to_sql_bool($s) {
 977                 if ($s) {
 978                         return "true";
 979                 } else {
 980                         return "false";
 981                 }
 982         }
 983
 984         // Session caching removed due to causing wrong redirects to upgrade
 985         // script when get_schema_version() is called on an obsolete session
 986         // created on a previous schema version.
 987         function get_schema_version($nocache = false) {
 988                 global $schema_version;
 989
 990                 if (!$schema_version && !$nocache) {
 991                         $result = db_query("SELECT schema_version FROM ttrss_version");
 992                         $version = db_fetch_result($result, 0, "schema_version");
 993                         $schema_version = $version;
 994                         return $version;
 995                 } else {
 996                         return $schema_version;
 997                 }
 998         }
 999
1000         function sanity_check() {
1001                 require_once 'errors.php';
1002
1003                 $error_code = 0;
1004                 $schema_version = get_schema_version(true);
1005
1006                 if ($schema_version != SCHEMA_VERSION) {
1007                         $error_code = 5;
1008                 }
1009
1010                 if (DB_TYPE == "mysql") {
1011                         $result = db_query("SELECT true", false);
1012                         if (db_num_rows($result) != 1) {
1013                                 $error_code = 10;
1014                         }
1015                 }
1016
1017                 if (db_escape_string("testTEST") != "testTEST") {
1018                         $error_code = 12;
1019                 }
1020
1021                 return array("code" => $error_code, "message" => $ERRORS[$error_code]);
1022         }
1023
1024         function file_is_locked($filename) {
1025                 if (file_exists(LOCK_DIRECTORY . "/$filename")) {
1026                         if (function_exists('flock')) {
1027                                 $fp = @fopen(LOCK_DIRECTORY . "/$filename", "r");
1028                                 if ($fp) {
1029                                         if (flock($fp, LOCK_EX | LOCK_NB)) {
1030                                                 flock($fp, LOCK_UN);
1031                                                 fclose($fp);
1032                                                 return false;
1033                                         }
1034                                         fclose($fp);
1035                                         return true;
1036                                 } else {
1037                                         return false;
1038                                 }
1039                         }
1040                         return true; // consider the file always locked and skip the test
1041                 } else {
1042                         return false;
1043                 }
1044         }
1045
1046
1047         function make_lockfile($filename) {
1048                 $fp = fopen(LOCK_DIRECTORY . "/$filename", "w");
1049
1050                 if ($fp && flock($fp, LOCK_EX | LOCK_NB)) {
1051                         $stat_h = fstat($fp);
1052                         $stat_f = stat(LOCK_DIRECTORY . "/$filename");
1053
1054                         if (strtoupper(substr(PHP_OS, 0, 3)) !== 'WIN') {
1055                                 if ($stat_h["ino"] != $stat_f["ino"] ||
1056                                                 $stat_h["dev"] != $stat_f["dev"]) {
1057
1058                                         return false;
1059                                 }
1060                         }
1061
1062                         if (function_exists('posix_getpid')) {
1063                                 fwrite($fp, posix_getpid() . "\n");
1064                         }
1065                         return $fp;
1066                 } else {
1067                         return false;
1068                 }
1069         }
1070
1071         function make_stampfile($filename) {
1072                 $fp = fopen(LOCK_DIRECTORY . "/$filename", "w");
1073
1074                 if (flock($fp, LOCK_EX | LOCK_NB)) {
1075                         fwrite($fp, time() . "\n");
1076                         flock($fp, LOCK_UN);
1077                         fclose($fp);
1078                         return true;
1079                 } else {
1080                         return false;
1081                 }
1082         }
1083
1084         function sql_random_function() {
1085                 if (DB_TYPE == "mysql") {
1086                         return "RAND()";
1087                 } else {
1088                         return "RANDOM()";
1089                 }
1090         }
1091
1092         function catchup_feed($feed, $cat_view, $owner_uid = false, $max_id = false, $mode = 'all') {
1093
1094                         if (!$owner_uid) $owner_uid = $_SESSION['uid'];
1095
1096                         //if (preg_match("/^-?[0-9][0-9]*$/", $feed) != false) {
1097
1098                         // Todo: all this interval stuff needs some generic generator function
1099
1100                         $date_qpart = "false";
1101
1102                         switch ($mode) {
1103                         case "1day":
1104                                 if (DB_TYPE == "pgsql") {
1105                                         $date_qpart = "date_entered < NOW() - INTERVAL '1 day' ";
1106                                 } else {
1107                                         $date_qpart = "date_entered < DATE_SUB(NOW(), INTERVAL 1 DAY) ";
1108                                 }
1109                                 break;
1110                         case "1week":
1111                                 if (DB_TYPE == "pgsql") {
1112                                         $date_qpart = "date_entered < NOW() - INTERVAL '1 week' ";
1113                                 } else {
1114                                         $date_qpart = "date_entered < DATE_SUB(NOW(), INTERVAL 1 WEEK) ";
1115                                 }
1116                                 break;
1117                         case "2week":
1118                                 if (DB_TYPE == "pgsql") {
1119                                         $date_qpart = "date_entered < NOW() - INTERVAL '2 week' ";
1120                                 } else {
1121                                         $date_qpart = "date_entered < DATE_SUB(NOW(), INTERVAL 2 WEEK) ";
1122                                 }
1123                                 break;
1124                         default:
1125                                 $date_qpart = "true";
1126                         }
1127
1128                         if (is_numeric($feed)) {
1129                                 if ($cat_view) {
1130
1131                                         if ($feed >= 0) {
1132
1133                                                 if ($feed > 0) {
1134                                                         $children = getChildCategories($feed, $owner_uid);
1135                                                         array_push($children, $feed);
1136
1137                                                         $children = join(",", $children);
1138
1139                                                         $cat_qpart = "cat_id IN ($children)";
1140                                                 } else {
1141                                                         $cat_qpart = "cat_id IS NULL";
1142                                                 }
1143
1144                                                 db_query("UPDATE ttrss_user_entries
1145                                                         SET unread = false, last_read = NOW() WHERE ref_id IN
1146                                                                 (SELECT id FROM
1147                                                                         (SELECT id FROM ttrss_entries, ttrss_user_entries WHERE ref_id = id
1148                                                                                 AND owner_uid = $owner_uid AND unread = true AND feed_id IN
1149                                                                                         (SELECT id FROM ttrss_feeds WHERE $cat_qpart) AND $date_qpart) as tmp)");
1150
1151                                         } else if ($feed == -2) {
1152
1153                                                 db_query("UPDATE ttrss_user_entries
1154                                                         SET unread = false,last_read = NOW() WHERE (SELECT COUNT(*)
1155                                                                 FROM ttrss_user_labels2, ttrss_entries WHERE article_id = ref_id AND id = ref_id AND $date_qpart) > 0
1156                                                                 AND unread = true AND owner_uid = $owner_uid");
1157                                         }
1158
1159                                 } else if ($feed > 0) {
1160
1161                                         db_query("UPDATE ttrss_user_entries
1162                                                 SET unread = false, last_read = NOW() WHERE ref_id IN
1163                                                         (SELECT id FROM
1164                                                                 (SELECT id FROM ttrss_entries, ttrss_user_entries WHERE ref_id = id
1165                                                                         AND owner_uid = $owner_uid AND unread = true AND feed_id = $feed AND $date_qpart) as tmp)");
1166
1167                                 } else if ($feed < 0 && $feed > LABEL_BASE_INDEX) { // special, like starred
1168
1169                                         if ($feed == -1) {
1170                                                 db_query("UPDATE ttrss_user_entries
1171                                                         SET unread = false, last_read = NOW() WHERE ref_id IN
1172                                                                 (SELECT id FROM
1173                                                                         (SELECT id FROM ttrss_entries, ttrss_user_entries WHERE ref_id = id
1174                                                                                 AND owner_uid = $owner_uid AND unread = true AND marked = true AND $date_qpart) as tmp)");
1175                                         }
1176
1177                                         if ($feed == -2) {
1178                                                 db_query("UPDATE ttrss_user_entries
1179                                                         SET unread = false, last_read = NOW() WHERE ref_id IN
1180                                                                 (SELECT id FROM
1181                                                                         (SELECT id FROM ttrss_entries, ttrss_user_entries WHERE ref_id = id
1182                                                                                 AND owner_uid = $owner_uid AND unread = true AND published = true AND $date_qpart) as tmp)");
1183                                         }
1184
1185                                         if ($feed == -3) {
1186
1187                                                 $intl = get_pref("FRESH_ARTICLE_MAX_AGE");
1188
1189                                                 if (DB_TYPE == "pgsql") {
1190                                                         $match_part = "date_entered > NOW() - INTERVAL '$intl hour' ";
1191                                                 } else {
1192                                                         $match_part = "date_entered > DATE_SUB(NOW(),
1193                                                                 INTERVAL $intl HOUR) ";
1194                                                 }
1195
1196                                                 db_query("UPDATE ttrss_user_entries
1197                                                         SET unread = false, last_read = NOW() WHERE ref_id IN
1198                                                                 (SELECT id FROM
1199                                                                         (SELECT id FROM ttrss_entries, ttrss_user_entries WHERE ref_id = id
1200                                                                                 AND owner_uid = $owner_uid AND unread = true AND $date_qpart AND $match_part) as tmp)");
1201                                         }
1202
1203                                         if ($feed == -4) {
1204                                                 db_query("UPDATE ttrss_user_entries
1205                                                         SET unread = false, last_read = NOW() WHERE ref_id IN
1206                                                                 (SELECT id FROM
1207                                                                         (SELECT id FROM ttrss_entries, ttrss_user_entries WHERE ref_id = id
1208                                                                                 AND owner_uid = $owner_uid AND unread = true AND $date_qpart) as tmp)");
1209                                         }
1210
1211                                 } else if ($feed < LABEL_BASE_INDEX) { // label
1212
1213                                         $label_id = feed_to_label_id($feed);
1214
1215                                         db_query("UPDATE ttrss_user_entries
1216                                                 SET unread = false, last_read = NOW() WHERE ref_id IN
1217                                                         (SELECT id FROM
1218                                                                 (SELECT ttrss_entries.id FROM ttrss_entries, ttrss_user_entries, ttrss_user_labels2 WHERE ref_id = id
1219                                                                         AND label_id = '$label_id' AND ref_id = article_id
1220                                                                         AND owner_uid = $owner_uid AND unread = true AND $date_qpart) as tmp)");
1221
1222                                 }
1223
1224                                 ccache_update($feed, $owner_uid, $cat_view);
1225
1226                         } else { // tag
1227                                 db_query("UPDATE ttrss_user_entries
1228                                         SET unread = false, last_read = NOW() WHERE ref_id IN
1229                                                 (SELECT id FROM
1230                                                         (SELECT ttrss_entries.id FROM ttrss_entries, ttrss_user_entries, ttrss_tags WHERE ref_id = ttrss_entries.id
1231                                                                 AND post_int_id = int_id AND tag_name = '$feed'
1232                                                                 AND ttrss_user_entries.owner_uid = $owner_uid AND unread = true AND $date_qpart) as tmp)");
1233
1234                         }
1235         }
1236
1237         function getAllCounters() {
1238                 $data = getGlobalCounters();
1239
1240                 $data = array_merge($data, getVirtCounters());
1241                 $data = array_merge($data, getLabelCounters());
1242                 $data = array_merge($data, getFeedCounters());
1243                 $data = array_merge($data, getCategoryCounters());
1244
1245                 return $data;
1246         }
1247
1248         function getCategoryTitle($cat_id) {
1249
1250                 if ($cat_id == -1) {
1251                         return __("Special");
1252                 } else if ($cat_id == -2) {
1253                         return __("Labels");
1254                 } else {
1255
1256                         $result = db_query("SELECT title FROM ttrss_feed_categories WHERE
1257                                 id = '$cat_id'");
1258
1259                         if (db_num_rows($result) == 1) {
1260                                 return db_fetch_result($result, 0, "title");
1261                         } else {
1262                                 return __("Uncategorized");
1263                         }
1264                 }
1265         }
1266
1267
1268         function getCategoryCounters() {
1269                 $ret_arr = array();
1270
1271                 /* Labels category */
1272
1273                 $cv = array("id" => -2, "kind" => "cat",
1274                         "counter" => getCategoryUnread(-2));
1275
1276                 array_push($ret_arr, $cv);
1277
1278                 $result = db_query("SELECT id AS cat_id, value AS unread,
1279                         (SELECT COUNT(id) FROM ttrss_feed_categories AS c2
1280                                 WHERE c2.parent_cat = ttrss_feed_categories.id) AS num_children
1281                         FROM ttrss_feed_categories, ttrss_cat_counters_cache
1282                         WHERE ttrss_cat_counters_cache.feed_id = id AND
1283                         ttrss_cat_counters_cache.owner_uid = ttrss_feed_categories.owner_uid AND
1284                         ttrss_feed_categories.owner_uid = " . $_SESSION["uid"]);
1285
1286                 while ($line = db_fetch_assoc($result)) {
1287                         $line["cat_id"] = (int) $line["cat_id"];
1288
1289                         if ($line["num_children"] > 0) {
1290                                 $child_counter = getCategoryChildrenUnread($line["cat_id"], $_SESSION["uid"]);
1291                         } else {
1292                                 $child_counter = 0;
1293                         }
1294
1295                         $cv = array("id" => $line["cat_id"], "kind" => "cat",
1296                                 "counter" => $line["unread"] + $child_counter);
1297
1298                         array_push($ret_arr, $cv);
1299                 }
1300
1301                 /* Special case: NULL category doesn't actually exist in the DB */
1302
1303                 $cv = array("id" => 0, "kind" => "cat",
1304                         "counter" => (int) ccache_find(0, $_SESSION["uid"], true));
1305
1306                 array_push($ret_arr, $cv);
1307
1308                 return $ret_arr;
1309         }
1310
1311         // only accepts real cats (>= 0)
1312         function getCategoryChildrenUnread($cat, $owner_uid = false) {
1313                 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
1314
1315                 $result = db_query("SELECT id FROM ttrss_feed_categories WHERE parent_cat = '$cat'
1316                                 AND owner_uid = $owner_uid");
1317
1318                 $unread = 0;
1319
1320                 while ($line = db_fetch_assoc($result)) {
1321                         $unread += getCategoryUnread($line["id"], $owner_uid);
1322                         $unread += getCategoryChildrenUnread($line["id"], $owner_uid);
1323                 }
1324
1325                 return $unread;
1326         }
1327
1328         function getCategoryUnread($cat, $owner_uid = false) {
1329
1330                 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
1331
1332                 if ($cat >= 0) {
1333
1334                         if ($cat != 0) {
1335                                 $cat_query = "cat_id = '$cat'";
1336                         } else {
1337                                 $cat_query = "cat_id IS NULL";
1338                         }
1339
1340                         $result = db_query("SELECT id FROM ttrss_feeds WHERE $cat_query
1341                                         AND owner_uid = " . $owner_uid);
1342
1343                         $cat_feeds = array();
1344                         while ($line = db_fetch_assoc($result)) {
1345                                 array_push($cat_feeds, "feed_id = " . $line["id"]);
1346                         }
1347
1348                         if (count($cat_feeds) == 0) return 0;
1349
1350                         $match_part = implode(" OR ", $cat_feeds);
1351
1352                         $result = db_query("SELECT COUNT(int_id) AS unread
1353                                 FROM ttrss_user_entries
1354                                 WHERE   unread = true AND ($match_part)
1355                                 AND owner_uid = " . $owner_uid);
1356
1357                         $unread = 0;
1358
1359                         # this needs to be rewritten
1360                         while ($line = db_fetch_assoc($result)) {
1361                                 $unread += $line["unread"];
1362                         }
1363
1364                         return $unread;
1365                 } else if ($cat == -1) {
1366                         return getFeedUnread(-1) + getFeedUnread(-2) + getFeedUnread(-3) + getFeedUnread(0);
1367                 } else if ($cat == -2) {
1368
1369                         $result = db_query("
1370                                 SELECT COUNT(unread) AS unread FROM
1371                                         ttrss_user_entries, ttrss_user_labels2
1372                                 WHERE article_id = ref_id AND unread = true
1373                                         AND ttrss_user_entries.owner_uid = '$owner_uid'");
1374
1375                         $unread = db_fetch_result($result, 0, "unread");
1376
1377                         return $unread;
1378
1379                 }
1380         }
1381
1382         function getFeedUnread($feed, $is_cat = false) {
1383                 return getFeedArticles($feed, $is_cat, true, $_SESSION["uid"]);
1384         }
1385
1386         function getLabelUnread($label_id, $owner_uid = false) {
1387                 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
1388
1389                 $result = db_query("SELECT COUNT(ref_id) AS unread FROM ttrss_user_entries, ttrss_user_labels2
1390                         WHERE owner_uid = '$owner_uid' AND unread = true AND label_id = '$label_id' AND article_id = ref_id");
1391
1392                 if (db_num_rows($result) != 0) {
1393                         return db_fetch_result($result, 0, "unread");
1394                 } else {
1395                         return 0;
1396                 }
1397         }
1398
1399         function getFeedArticles($feed, $is_cat = false, $unread_only = false,
1400                 $owner_uid = false) {
1401
1402                 $n_feed = (int) $feed;
1403                 $need_entries = false;
1404
1405                 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
1406
1407                 if ($unread_only) {
1408                         $unread_qpart = "unread = true";
1409                 } else {
1410                         $unread_qpart = "true";
1411                 }
1412
1413                 if ($is_cat) {
1414                         return getCategoryUnread($n_feed, $owner_uid);
1415                 } else if ($n_feed == -6) {
1416                         return 0;
1417                 } else if ($feed != "0" && $n_feed == 0) {
1418
1419                         $feed = db_escape_string($feed);
1420
1421                         $result = db_query("SELECT SUM((SELECT COUNT(int_id)
1422                                 FROM ttrss_user_entries,ttrss_entries WHERE int_id = post_int_id
1423                                         AND ref_id = id AND $unread_qpart)) AS count FROM ttrss_tags
1424                                 WHERE owner_uid = $owner_uid AND tag_name = '$feed'");
1425                         return db_fetch_result($result, 0, "count");
1426
1427                 } else if ($n_feed == -1) {
1428                         $match_part = "marked = true";
1429                 } else if ($n_feed == -2) {
1430                         $match_part = "published = true";
1431                 } else if ($n_feed == -3) {
1432                         $match_part = "unread = true AND score >= 0";
1433
1434                         $intl = get_pref("FRESH_ARTICLE_MAX_AGE", $owner_uid);
1435
1436                         if (DB_TYPE == "pgsql") {
1437                                 $match_part .= " AND date_entered > NOW() - INTERVAL '$intl hour' ";
1438                         } else {
1439                                 $match_part .= " AND date_entered > DATE_SUB(NOW(), INTERVAL $intl HOUR) ";
1440                         }
1441
1442                         $need_entries = true;
1443
1444                 } else if ($n_feed == -4) {
1445                         $match_part = "true";
1446                 } else if ($n_feed >= 0) {
1447
1448                         if ($n_feed != 0) {
1449                                 $match_part = "feed_id = '$n_feed'";
1450                         } else {
1451                                 $match_part = "feed_id IS NULL";
1452                         }
1453
1454                 } else if ($feed < LABEL_BASE_INDEX) {
1455
1456                         $label_id = feed_to_label_id($feed);
1457
1458                         return getLabelUnread($label_id, $owner_uid);
1459
1460                 }
1461
1462                 if ($match_part) {
1463
1464                         if ($need_entries) {
1465                                 $from_qpart = "ttrss_user_entries,ttrss_entries";
1466                                 $from_where = "ttrss_entries.id = ttrss_user_entries.ref_id AND";
1467                         } else {
1468                                 $from_qpart = "ttrss_user_entries";
1469                                 $from_where = "";
1470                         }
1471
1472                         $query = "SELECT count(int_id) AS unread
1473                                 FROM $from_qpart WHERE
1474                                 $unread_qpart AND $from_where ($match_part) AND ttrss_user_entries.owner_uid = $owner_uid";
1475
1476                         //echo "[$feed/$query]\n";
1477
1478                         $result = db_query($query);
1479
1480                 } else {
1481
1482                         $result = db_query("SELECT COUNT(post_int_id) AS unread
1483                                 FROM ttrss_tags,ttrss_user_entries,ttrss_entries
1484                                 WHERE tag_name = '$feed' AND post_int_id = int_id AND ref_id = ttrss_entries.id
1485                                 AND $unread_qpart AND ttrss_tags.owner_uid = " . $owner_uid);
1486                 }
1487
1488                 $unread = db_fetch_result($result, 0, "unread");
1489
1490                 return $unread;
1491         }
1492
1493         function getGlobalUnread($user_id = false) {
1494
1495                 if (!$user_id) {
1496                         $user_id = $_SESSION["uid"];
1497                 }
1498
1499                 $result = db_query("SELECT SUM(value) AS c_id FROM ttrss_counters_cache
1500                         WHERE owner_uid = '$user_id' AND feed_id > 0");
1501
1502                 $c_id = db_fetch_result($result, 0, "c_id");
1503
1504                 return $c_id;
1505         }
1506
1507         function getGlobalCounters($global_unread = -1) {
1508                 $ret_arr = array();
1509
1510                 if ($global_unread == -1) {
1511                         $global_unread = getGlobalUnread();
1512                 }
1513
1514                 $cv = array("id" => "global-unread",
1515                         "counter" => (int) $global_unread);
1516
1517                 array_push($ret_arr, $cv);
1518
1519                 $result = db_query("SELECT COUNT(id) AS fn FROM
1520                         ttrss_feeds WHERE owner_uid = " . $_SESSION["uid"]);
1521
1522                 $subscribed_feeds = db_fetch_result($result, 0, "fn");
1523
1524                 $cv = array("id" => "subscribed-feeds",
1525                         "counter" => (int) $subscribed_feeds);
1526
1527                 array_push($ret_arr, $cv);
1528
1529                 return $ret_arr;
1530         }
1531
1532         function getVirtCounters() {
1533
1534                 $ret_arr = array();
1535
1536                 for ($i = 0; $i >= -4; $i--) {
1537
1538                         $count = getFeedUnread($i);
1539
1540                         if ($i == 0 || $i == -1 || $i == -2)
1541                                 $auxctr = getFeedArticles($i, false);
1542                         else
1543                                 $auxctr = 0;
1544
1545                         $cv = array("id" => $i,
1546                                 "counter" => (int) $count,
1547                                 "auxcounter" => $auxctr);
1548
1549 //                      if (get_pref('EXTENDED_FEEDLIST'))
1550 //                              $cv["xmsg"] = getFeedArticles($i)." ".__("total");
1551
1552                         array_push($ret_arr, $cv);
1553                 }
1554
1555                 $feeds = PluginHost::getInstance()->get_feeds(-1);
1556
1557                 if (is_array($feeds)) {
1558                         foreach ($feeds as $feed) {
1559                                 $cv = array("id" => PluginHost::pfeed_to_feed_id($feed['id']),
1560                                         "counter" => $feed['sender']->get_unread($feed['id']));
1561
1562                                 if (method_exists($feed['sender'], 'get_total'))
1563                                         $cv["auxcounter"] = $feed['sender']->get_total($feed['id']);
1564
1565                                 array_push($ret_arr, $cv);
1566                         }
1567                 }
1568
1569                 return $ret_arr;
1570         }
1571
1572         function getLabelCounters($descriptions = false) {
1573
1574                 $ret_arr = array();
1575
1576                 $owner_uid = $_SESSION["uid"];
1577
1578                 $result = db_query("SELECT id,caption,SUM(CASE WHEN u1.unread = true THEN 1 ELSE 0 END) AS unread, COUNT(u1.unread) AS total
1579                         FROM ttrss_labels2 LEFT JOIN ttrss_user_labels2 ON
1580                                 (ttrss_labels2.id = label_id)
1581                                 LEFT JOIN ttrss_user_entries AS u1 ON u1.ref_id = article_id
1582                                 WHERE ttrss_labels2.owner_uid = $owner_uid GROUP BY ttrss_labels2.id,
1583                                         ttrss_labels2.caption");
1584
1585                 while ($line = db_fetch_assoc($result)) {
1586
1587                         $id = label_to_feed_id($line["id"]);
1588
1589                         $cv = array("id" => $id,
1590                                 "counter" => (int) $line["unread"],
1591                                 "auxcounter" => (int) $line["total"]);
1592
1593                         if ($descriptions)
1594                                 $cv["description"] = $line["caption"];
1595
1596                         array_push($ret_arr, $cv);
1597                 }
1598
1599                 return $ret_arr;
1600         }
1601
1602         function getFeedCounters($active_feed = false) {
1603
1604                 $ret_arr = array();
1605
1606                 $query = "SELECT ttrss_feeds.id,
1607                                 ttrss_feeds.title,
1608                                 ".SUBSTRING_FOR_DATE."(ttrss_feeds.last_updated,1,19) AS last_updated,
1609                                 last_error, value AS count
1610                         FROM ttrss_feeds, ttrss_counters_cache
1611                         WHERE ttrss_feeds.owner_uid = ".$_SESSION["uid"]."
1612                                 AND ttrss_counters_cache.owner_uid = ttrss_feeds.owner_uid
1613                                 AND ttrss_counters_cache.feed_id = id";
1614
1615                 $result = db_query($query);
1616
1617                 while ($line = db_fetch_assoc($result)) {
1618
1619                         $id = $line["id"];
1620                         $count = $line["count"];
1621                         $last_error = htmlspecialchars($line["last_error"]);
1622
1623                         $last_updated = make_local_datetime($line['last_updated'], false);
1624
1625                         $has_img = feed_has_icon($id);
1626
1627                         if (date('Y') - date('Y', strtotime($line['last_updated'])) > 2)
1628                                 $last_updated = '';
1629
1630                         $cv = array("id" => $id,
1631                                 "updated" => $last_updated,
1632                                 "counter" => (int) $count,
1633                                 "has_img" => (int) $has_img);
1634
1635                         if ($last_error)
1636                                 $cv["error"] = $last_error;
1637
1638 //                      if (get_pref('EXTENDED_FEEDLIST'))
1639 //                              $cv["xmsg"] = getFeedArticles($id)." ".__("total");
1640
1641                         if ($active_feed && $id == $active_feed)
1642                                 $cv["title"] = truncate_string($line["title"], 30);
1643
1644                         array_push($ret_arr, $cv);
1645
1646                 }
1647
1648                 return $ret_arr;
1649         }
1650
1651         function get_pgsql_version() {
1652                 $result = db_query("SELECT version() AS version");
1653                 $version = explode(" ", db_fetch_result($result, 0, "version"));
1654                 return $version[1];
1655         }
1656
1657         /**
1658          * @return array (code => Status code, message => error message if available)
1659          *
1660          *                 0 - OK, Feed already exists
1661          *                 1 - OK, Feed added
1662          *                 2 - Invalid URL
1663          *                 3 - URL content is HTML, no feeds available
1664          *                 4 - URL content is HTML which contains multiple feeds.
1665          *                     Here you should call extractfeedurls in rpc-backend
1666          *                     to get all possible feeds.
1667          *                 5 - Couldn't download the URL content.
1668          *                 6 - Content is an invalid XML.
1669          */
1670         function subscribe_to_feed($url, $cat_id = 0,
1671                         $auth_login = '', $auth_pass = '') {
1672
1673                 global $fetch_last_error;
1674
1675                 require_once "include/rssfuncs.php";
1676
1677                 $url = fix_url($url);
1678
1679                 if (!$url || !validate_feed_url($url)) return array("code" => 2);
1680
1681                 $contents = @fetch_file_contents($url, false, $auth_login, $auth_pass);
1682
1683                 if (!$contents) {
1684                         return array("code" => 5, "message" => $fetch_last_error);
1685                 }
1686
1687                 if (is_html($contents)) {
1688                         $feedUrls = get_feeds_from_html($url, $contents);
1689
1690                         if (count($feedUrls) == 0) {
1691                                 return array("code" => 3);
1692                         } else if (count($feedUrls) > 1) {
1693                                 return array("code" => 4, "feeds" => $feedUrls);
1694                         }
1695                         //use feed url as new URL
1696                         $url = key($feedUrls);
1697                 }
1698
1699                 /* libxml_use_internal_errors(true);
1700                 $doc = new DOMDocument();
1701                 $doc->loadXML($contents);
1702                 $error = libxml_get_last_error();
1703                 libxml_clear_errors();
1704
1705                 if ($error) {
1706                         $error_message = format_libxml_error($error);
1707
1708                         return array("code" => 6, "message" => $error_message);
1709                 } */
1710
1711                 if ($cat_id == "0" || !$cat_id) {
1712                         $cat_qpart = "NULL";
1713                 } else {
1714                         $cat_qpart = "'$cat_id'";
1715                 }
1716
1717                 $result = db_query(
1718                         "SELECT id FROM ttrss_feeds
1719                         WHERE feed_url = '$url' AND owner_uid = ".$_SESSION["uid"]);
1720
1721                 if (strlen(FEED_CRYPT_KEY) > 0) {
1722                         require_once "crypt.php";
1723                         $auth_pass = substr(encrypt_string($auth_pass), 0, 250);
1724                         $auth_pass_encrypted = 'true';
1725                 } else {
1726                         $auth_pass_encrypted = 'false';
1727                 }
1728
1729                 $auth_pass = db_escape_string($auth_pass);
1730
1731                 if (db_num_rows($result) == 0) {
1732                         $result = db_query(
1733                                 "INSERT INTO ttrss_feeds
1734                                         (owner_uid,feed_url,title,cat_id, auth_login,auth_pass,update_method,auth_pass_encrypted)
1735                                 VALUES ('".$_SESSION["uid"]."', '$url',
1736                                 '[Unknown]', $cat_qpart, '$auth_login', '$auth_pass', 0, $auth_pass_encrypted)");
1737
1738                         $result = db_query(
1739                                 "SELECT id FROM ttrss_feeds WHERE feed_url = '$url'
1740                                         AND owner_uid = " . $_SESSION["uid"]);
1741
1742                         $feed_id = db_fetch_result($result, 0, "id");
1743
1744                         if ($feed_id) {
1745                                 update_rss_feed($feed_id, true);
1746                         }
1747
1748                         return array("code" => 1);
1749                 } else {
1750                         return array("code" => 0);
1751                 }
1752         }
1753
1754         function print_feed_select($id, $default_id = "",
1755                 $attributes = "", $include_all_feeds = true,
1756                 $root_id = false, $nest_level = 0) {
1757
1758                 if (!$root_id) {
1759                         print "<select id=\"$id\" name=\"$id\" $attributes>";
1760                         if ($include_all_feeds) {
1761                                 $is_selected = ("0" == $default_id) ? "selected=\"1\"" : "";
1762                                 print "<option $is_selected value=\"0\">".__('All feeds')."</option>";
1763                         }
1764                 }
1765
1766                 if (get_pref('ENABLE_FEED_CATS')) {
1767
1768                         if ($root_id)
1769                                 $parent_qpart = "parent_cat = '$root_id'";
1770                         else
1771                                 $parent_qpart = "parent_cat IS NULL";
1772
1773                         $result = db_query("SELECT id,title,
1774                                 (SELECT COUNT(id) FROM ttrss_feed_categories AS c2 WHERE
1775                                         c2.parent_cat = ttrss_feed_categories.id) AS num_children
1776                                 FROM ttrss_feed_categories
1777                                 WHERE owner_uid = ".$_SESSION["uid"]." AND $parent_qpart ORDER BY title");
1778
1779                         while ($line = db_fetch_assoc($result)) {
1780
1781                                 for ($i = 0; $i < $nest_level; $i++)
1782                                         $line["title"] = " - " . $line["title"];
1783
1784                                 $is_selected = ("CAT:".$line["id"] == $default_id) ? "selected=\"1\"" : "";
1785
1786                                 printf("<option $is_selected value='CAT:%d'>%s</option>",
1787                                         $line["id"], htmlspecialchars($line["title"]));
1788
1789                                 if ($line["num_children"] > 0)
1790                                         print_feed_select($id, $default_id, $attributes,
1791                                                 $include_all_feeds, $line["id"], $nest_level+1);
1792
1793                                 $feed_result = db_query("SELECT id,title FROM ttrss_feeds
1794                                         WHERE cat_id = '".$line["id"]."' AND owner_uid = ".$_SESSION["uid"] . " ORDER BY title");
1795
1796                                 while ($fline = db_fetch_assoc($feed_result)) {
1797                                         $is_selected = ($fline["id"] == $default_id) ? "selected=\"1\"" : "";
1798
1799                                         $fline["title"] = " + " . $fline["title"];
1800
1801                                         for ($i = 0; $i < $nest_level; $i++)
1802                                                 $fline["title"] = " - " . $fline["title"];
1803
1804                                         printf("<option $is_selected value='%d'>%s</option>",
1805                                                 $fline["id"], htmlspecialchars($fline["title"]));
1806                                 }
1807                         }
1808
1809                         if (!$root_id) {
1810                                 $default_is_cat = ($default_id == "CAT:0");
1811                                 $is_selected = $default_is_cat ? "selected=\"1\"" : "";
1812
1813                                 printf("<option $is_selected value='CAT:0'>%s</option>",
1814                                         __("Uncategorized"));
1815
1816                                 $feed_result = db_query("SELECT id,title FROM ttrss_feeds
1817                                         WHERE cat_id IS NULL AND owner_uid = ".$_SESSION["uid"] . " ORDER BY title");
1818
1819                                 while ($fline = db_fetch_assoc($feed_result)) {
1820                                         $is_selected = ($fline["id"] == $default_id && !$default_is_cat) ? "selected=\"1\"" : "";
1821
1822                                         $fline["title"] = " + " . $fline["title"];
1823
1824                                         for ($i = 0; $i < $nest_level; $i++)
1825                                                 $fline["title"] = " - " . $fline["title"];
1826
1827                                         printf("<option $is_selected value='%d'>%s</option>",
1828                                                 $fline["id"], htmlspecialchars($fline["title"]));
1829                                 }
1830                         }
1831
1832                 } else {
1833                         $result = db_query("SELECT id,title FROM ttrss_feeds
1834                                 WHERE owner_uid = ".$_SESSION["uid"]." ORDER BY title");
1835
1836                         while ($line = db_fetch_assoc($result)) {
1837
1838                                 $is_selected = ($line["id"] == $default_id) ? "selected=\"1\"" : "";
1839
1840                                 printf("<option $is_selected value='%d'>%s</option>",
1841                                         $line["id"], htmlspecialchars($line["title"]));
1842                         }
1843                 }
1844
1845                 if (!$root_id) {
1846                         print "</select>";
1847                 }
1848         }
1849
1850         function print_feed_cat_select($id, $default_id,
1851                 $attributes, $include_all_cats = true, $root_id = false, $nest_level = 0) {
1852
1853                         if (!$root_id) {
1854                                         print "<select id=\"$id\" name=\"$id\" default=\"$default_id\" onchange=\"catSelectOnChange(this)\" $attributes>";
1855                         }
1856
1857                         if ($root_id)
1858                                 $parent_qpart = "parent_cat = '$root_id'";
1859                         else
1860                                 $parent_qpart = "parent_cat IS NULL";
1861
1862                         $result = db_query("SELECT id,title,
1863                                 (SELECT COUNT(id) FROM ttrss_feed_categories AS c2 WHERE
1864                                         c2.parent_cat = ttrss_feed_categories.id) AS num_children
1865                                 FROM ttrss_feed_categories
1866                                 WHERE owner_uid = ".$_SESSION["uid"]." AND $parent_qpart ORDER BY title");
1867
1868                         while ($line = db_fetch_assoc($result)) {
1869                                 if ($line["id"] == $default_id) {
1870                                         $is_selected = "selected=\"1\"";
1871                                 } else {
1872                                         $is_selected = "";
1873                                 }
1874
1875                                 for ($i = 0; $i < $nest_level; $i++)
1876                                         $line["title"] = " - " . $line["title"];
1877
1878                                 if ($line["title"])
1879                                         printf("<option $is_selected value='%d'>%s</option>",
1880                                                 $line["id"], htmlspecialchars($line["title"]));
1881
1882                                 if ($line["num_children"] > 0)
1883                                         print_feed_cat_select($id, $default_id, $attributes,
1884                                                 $include_all_cats, $line["id"], $nest_level+1);
1885                         }
1886
1887                         if (!$root_id) {
1888                                 if ($include_all_cats) {
1889                                         if (db_num_rows($result) > 0) {
1890                                                 print "<option disabled=\"1\">--------</option>";
1891                                         }
1892
1893                                         if ($default_id == 0) {
1894                                                 $is_selected = "selected=\"1\"";
1895                                         } else {
1896                                                 $is_selected = "";
1897                                         }
1898
1899                                         print "<option $is_selected value=\"0\">".__('Uncategorized')."</option>";
1900                                 }
1901                                 print "</select>";
1902                         }
1903                 }
1904
1905         function checkbox_to_sql_bool($val) {
1906                 return ($val == "on") ? "true" : "false";
1907         }
1908
1909         function getFeedCatTitle($id) {
1910                 if ($id == -1) {
1911                         return __("Special");
1912                 } else if ($id < LABEL_BASE_INDEX) {
1913                         return __("Labels");
1914                 } else if ($id > 0) {
1915                         $result = db_query("SELECT ttrss_feed_categories.title
1916                                 FROM ttrss_feeds, ttrss_feed_categories WHERE ttrss_feeds.id = '$id' AND
1917                                         cat_id = ttrss_feed_categories.id");
1918                         if (db_num_rows($result) == 1) {
1919                                 return db_fetch_result($result, 0, "title");
1920                         } else {
1921                                 return __("Uncategorized");
1922                         }
1923                 } else {
1924                         return "getFeedCatTitle($id) failed";
1925                 }
1926
1927         }
1928
1929         function getFeedIcon($id) {
1930                 switch ($id) {
1931                 case 0:
1932                         return "images/archive.png";
1933                         break;
1934                 case -1:
1935                         return "images/star.png";
1936                         break;
1937                 case -2:
1938                         return "images/feed.png";
1939                         break;
1940                 case -3:
1941                         return "images/fresh.png";
1942                         break;
1943                 case -4:
1944                         return "images/folder.png";
1945                         break;
1946                 case -6:
1947                         return "images/time.png";
1948                         break;
1949                 default:
1950                         if ($id < LABEL_BASE_INDEX) {
1951                                 return "images/label.png";
1952                         } else {
1953                                 if (file_exists(ICONS_DIR . "/$id.ico"))
1954                                         return ICONS_URL . "/$id.ico";
1955                         }
1956                         break;
1957                 }
1958
1959                 return false;
1960         }
1961
1962         function getFeedTitle($id, $cat = false) {
1963                 if ($cat) {
1964                         return getCategoryTitle($id);
1965                 } else if ($id == -1) {
1966                         return __("Starred articles");
1967                 } else if ($id == -2) {
1968                         return __("Published articles");
1969                 } else if ($id == -3) {
1970                         return __("Fresh articles");
1971                 } else if ($id == -4) {
1972                         return __("All articles");
1973                 } else if ($id === 0 || $id === "0") {
1974                         return __("Archived articles");
1975                 } else if ($id == -6) {
1976                         return __("Recently read");
1977                 } else if ($id < LABEL_BASE_INDEX) {
1978                         $label_id = feed_to_label_id($id);
1979                         $result = db_query("SELECT caption FROM ttrss_labels2 WHERE id = '$label_id'");
1980                         if (db_num_rows($result) == 1) {
1981                                 return db_fetch_result($result, 0, "caption");
1982                         } else {
1983                                 return "Unknown label ($label_id)";
1984                         }
1985
1986                 } else if (is_numeric($id) && $id > 0) {
1987                         $result = db_query("SELECT title FROM ttrss_feeds WHERE id = '$id'");
1988                         if (db_num_rows($result) == 1) {
1989                                 return db_fetch_result($result, 0, "title");
1990                         } else {
1991                                 return "Unknown feed ($id)";
1992                         }
1993                 } else {
1994                         return $id;
1995                 }
1996         }
1997
1998         function make_init_params() {
1999                 $params = array();
2000
2001                 foreach (array("ON_CATCHUP_SHOW_NEXT_FEED", "HIDE_READ_FEEDS",
2002                         "ENABLE_FEED_CATS", "FEEDS_SORT_BY_UNREAD", "CONFIRM_FEED_CATCHUP",
2003                         "CDM_AUTO_CATCHUP", "FRESH_ARTICLE_MAX_AGE",
2004                         "HIDE_READ_SHOWS_SPECIAL", "COMBINED_DISPLAY_MODE") as $param) {
2005
2006                                  $params[strtolower($param)] = (int) get_pref($param);
2007                  }
2008
2009                 $params["icons_url"] = ICONS_URL;
2010                 $params["cookie_lifetime"] = SESSION_COOKIE_LIFETIME;
2011                 $params["default_view_mode"] = get_pref("_DEFAULT_VIEW_MODE");
2012                 $params["default_view_limit"] = (int) get_pref("_DEFAULT_VIEW_LIMIT");
2013                 $params["default_view_order_by"] = get_pref("_DEFAULT_VIEW_ORDER_BY");
2014                 $params["bw_limit"] = (int) $_SESSION["bw_limit"];
2015                 $params["label_base_index"] = (int) LABEL_BASE_INDEX;
2016
2017                 $result = db_query("SELECT MAX(id) AS mid, COUNT(*) AS nf FROM
2018                         ttrss_feeds WHERE owner_uid = " . $_SESSION["uid"]);
2019
2020                 $max_feed_id = db_fetch_result($result, 0, "mid");
2021                 $num_feeds = db_fetch_result($result, 0, "nf");
2022
2023                 $params["max_feed_id"] = (int) $max_feed_id;
2024                 $params["num_feeds"] = (int) $num_feeds;
2025
2026                 $params["hotkeys"] = get_hotkeys_map();
2027
2028                 $params["csrf_token"] = $_SESSION["csrf_token"];
2029                 $params["widescreen"] = (int) $_COOKIE["ttrss_widescreen"];
2030
2031                 $params['simple_update'] = defined('SIMPLE_UPDATE_MODE') && SIMPLE_UPDATE_MODE;
2032
2033                 return $params;
2034         }
2035
2036         function get_hotkeys_info() {
2037                 $hotkeys = array(
2038                         __("Navigation") => array(
2039                                 "next_feed" => __("Open next feed"),
2040                                 "prev_feed" => __("Open previous feed"),
2041                                 "next_article" => __("Open next article"),
2042                                 "prev_article" => __("Open previous article"),
2043                                 "next_article_noscroll" => __("Open next article (don't scroll long articles)"),
2044                                 "prev_article_noscroll" => __("Open previous article (don't scroll long articles)"),
2045                                 "next_article_noexpand" => __("Move to next article (don't expand or mark read)"),
2046                                 "prev_article_noexpand" => __("Move to previous article (don't expand or mark read)"),
2047                                 "search_dialog" => __("Show search dialog")),
2048                         __("Article") => array(
2049                                 "toggle_mark" => __("Toggle starred"),
2050                                 "toggle_publ" => __("Toggle published"),
2051                                 "toggle_unread" => __("Toggle unread"),
2052                                 "edit_tags" => __("Edit tags"),
2053                                 "dismiss_selected" => __("Dismiss selected"),
2054                                 "dismiss_read" => __("Dismiss read"),
2055                                 "open_in_new_window" => __("Open in new window"),
2056                                 "catchup_below" => __("Mark below as read"),
2057                                 "catchup_above" => __("Mark above as read"),
2058                                 "article_scroll_down" => __("Scroll down"),
2059                                 "article_scroll_up" => __("Scroll up"),
2060                                 "select_article_cursor" => __("Select article under cursor"),
2061                                 "email_article" => __("Email article"),
2062                                 "close_article" => __("Close/collapse article"),
2063                                 "toggle_expand" => __("Toggle article expansion (combined mode)"),
2064                                 "toggle_widescreen" => __("Toggle widescreen mode"),
2065                                 "toggle_embed_original" => __("Toggle embed original")),
2066                         __("Article selection") => array(
2067                                 "select_all" => __("Select all articles"),
2068                                 "select_unread" => __("Select unread"),
2069                                 "select_marked" => __("Select starred"),
2070                                 "select_published" => __("Select published"),
2071                                 "select_invert" => __("Invert selection"),
2072                                 "select_none" => __("Deselect everything")),
2073                         __("Feed") => array(
2074                                 "feed_refresh" => __("Refresh current feed"),
2075                                 "feed_unhide_read" => __("Un/hide read feeds"),
2076                                 "feed_subscribe" => __("Subscribe to feed"),
2077                                 "feed_edit" => __("Edit feed"),
2078                                 "feed_catchup" => __("Mark as read"),
2079                                 "feed_reverse" => __("Reverse headlines"),
2080                                 "feed_debug_update" => __("Debug feed update"),
2081                                 "catchup_all" => __("Mark all feeds as read"),
2082                                 "cat_toggle_collapse" => __("Un/collapse current category"),
2083                                 "toggle_combined_mode" => __("Toggle combined mode"),
2084                                 "toggle_cdm_expanded" => __("Toggle auto expand in combined mode")),
2085                         __("Go to") => array(
2086                                 "goto_all" => __("All articles"),
2087                                 "goto_fresh" => __("Fresh"),
2088                                 "goto_marked" => __("Starred"),
2089                                 "goto_published" => __("Published"),
2090                                 "goto_tagcloud" => __("Tag cloud"),
2091                                 "goto_prefs" => __("Preferences")),
2092                         __("Other") => array(
2093                                 "create_label" => __("Create label"),
2094                                 "create_filter" => __("Create filter"),
2095                                 "collapse_sidebar" => __("Un/collapse sidebar"),
2096                                 "help_dialog" => __("Show help dialog"))
2097                         );
2098
2099                 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_HOTKEY_INFO) as $plugin) {
2100                         $hotkeys = $plugin->hook_hotkey_info($hotkeys);
2101                 }
2102
2103                 return $hotkeys;
2104         }
2105
2106         function get_hotkeys_map() {
2107                 $hotkeys = array(
2108 //                      "navigation" => array(
2109                                 "k" => "next_feed",
2110                                 "j" => "prev_feed",
2111                                 "n" => "next_article",
2112                                 "p" => "prev_article",
2113                                 "(38)|up" => "prev_article",
2114                                 "(40)|down" => "next_article",
2115 //                              "^(38)|Ctrl-up" => "prev_article_noscroll",
2116 //                              "^(40)|Ctrl-down" => "next_article_noscroll",
2117                                 "(191)|/" => "search_dialog",
2118 //                      "article" => array(
2119                                 "s" => "toggle_mark",
2120                                 "*s" => "toggle_publ",
2121                                 "u" => "toggle_unread",
2122                                 "*t" => "edit_tags",
2123                                 "*d" => "dismiss_selected",
2124                                 "*x" => "dismiss_read",
2125                                 "o" => "open_in_new_window",
2126                                 "c p" => "catchup_below",
2127                                 "c n" => "catchup_above",
2128                                 "*n" => "article_scroll_down",
2129                                 "*p" => "article_scroll_up",
2130                                 "*(38)|Shift+up" => "article_scroll_up",
2131                                 "*(40)|Shift+down" => "article_scroll_down",
2132                                 "a *w" => "toggle_widescreen",
2133                                 "a e" => "toggle_embed_original",
2134                                 "e" => "email_article",
2135                                 "a q" => "close_article",
2136 //                      "article_selection" => array(
2137                                 "a a" => "select_all",
2138                                 "a u" => "select_unread",
2139                                 "a *u" => "select_marked",
2140                                 "a p" => "select_published",
2141                                 "a i" => "select_invert",
2142                                 "a n" => "select_none",
2143 //                      "feed" => array(
2144                                 "f r" => "feed_refresh",
2145                                 "f a" => "feed_unhide_read",
2146                                 "f s" => "feed_subscribe",
2147                                 "f e" => "feed_edit",
2148                                 "f q" => "feed_catchup",
2149                                 "f x" => "feed_reverse",
2150                                 "f *d" => "feed_debug_update",
2151                                 "f *c" => "toggle_combined_mode",
2152                                 "f c" => "toggle_cdm_expanded",
2153                                 "*q" => "catchup_all",
2154                                 "x" => "cat_toggle_collapse",
2155 //                      "goto" => array(
2156                                 "g a" => "goto_all",
2157                                 "g f" => "goto_fresh",
2158                                 "g s" => "goto_marked",
2159                                 "g p" => "goto_published",
2160                                 "g t" => "goto_tagcloud",
2161                                 "g *p" => "goto_prefs",
2162 //                      "other" => array(
2163                                 "(9)|Tab" => "select_article_cursor", // tab
2164                                 "c l" => "create_label",
2165                                 "c f" => "create_filter",
2166                                 "c s" => "collapse_sidebar",
2167                                 "^(191)|Ctrl+/" => "help_dialog",
2168                         );
2169
2170                 if (get_pref('COMBINED_DISPLAY_MODE')) {
2171                         $hotkeys["^(38)|Ctrl-up"] = "prev_article_noscroll";
2172                         $hotkeys["^(40)|Ctrl-down"] = "next_article_noscroll";
2173                 }
2174
2175                 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_HOTKEY_MAP) as $plugin) {
2176                         $hotkeys = $plugin->hook_hotkey_map($hotkeys);
2177                 }
2178
2179                 $prefixes = array();
2180
2181                 foreach (array_keys($hotkeys) as $hotkey) {
2182                         $pair = explode(" ", $hotkey, 2);
2183
2184                         if (count($pair) > 1 && !in_array($pair[0], $prefixes)) {
2185                                 array_push($prefixes, $pair[0]);
2186                         }
2187                 }
2188
2189                 return array($prefixes, $hotkeys);
2190         }
2191
2192         function make_runtime_info() {
2193                 $data = array();
2194
2195                 $result = db_query("SELECT MAX(id) AS mid, COUNT(*) AS nf FROM
2196                         ttrss_feeds WHERE owner_uid = " . $_SESSION["uid"]);
2197
2198                 $max_feed_id = db_fetch_result($result, 0, "mid");
2199                 $num_feeds = db_fetch_result($result, 0, "nf");
2200
2201                 $data["max_feed_id"] = (int) $max_feed_id;
2202                 $data["num_feeds"] = (int) $num_feeds;
2203
2204                 $data['last_article_id'] = getLastArticleId();
2205                 $data['cdm_expanded'] = get_pref('CDM_EXPANDED');
2206
2207                 $data['dep_ts'] = calculate_dep_timestamp();
2208                 $data['reload_on_ts_change'] = !defined('_NO_RELOAD_ON_TS_CHANGE');
2209
2210                 if (file_exists(LOCK_DIRECTORY . "/update_daemon.lock")) {
2211
2212                         $data['daemon_is_running'] = (int) file_is_locked("update_daemon.lock");
2213
2214                         if (time() - $_SESSION["daemon_stamp_check"] > 30) {
2215
2216                                 $stamp = (int) @file_get_contents(LOCK_DIRECTORY . "/update_daemon.stamp");
2217
2218                                 if ($stamp) {
2219                                         $stamp_delta = time() - $stamp;
2220
2221                                         if ($stamp_delta > 1800) {
2222                                                 $stamp_check = 0;
2223                                         } else {
2224                                                 $stamp_check = 1;
2225                                                 $_SESSION["daemon_stamp_check"] = time();
2226                                         }
2227
2228                                         $data['daemon_stamp_ok'] = $stamp_check;
2229
2230                                         $stamp_fmt = date("Y.m.d, G:i", $stamp);
2231
2232                                         $data['daemon_stamp'] = $stamp_fmt;
2233                                 }
2234                         }
2235                 }
2236
2237                 if ($_SESSION["last_version_check"] + 86400 + rand(-1000, 1000) < time()) {
2238                                 $new_version_details = @check_for_update();
2239
2240                                 $data['new_version_available'] = (int) ($new_version_details != false);
2241
2242                                 $_SESSION["last_version_check"] = time();
2243                                 $_SESSION["version_data"] = $new_version_details;
2244                 }
2245
2246                 return $data;
2247         }
2248
2249         function search_to_sql($search) {
2250
2251                 $search_query_part = "";
2252
2253                 $keywords = str_getcsv($search, " ");
2254                 $query_keywords = array();
2255                 $search_words = array();
2256
2257                 foreach ($keywords as $k) {
2258                         if (strpos($k, "-") === 0) {
2259                                 $k = substr($k, 1);
2260                                 $not = "NOT";
2261                         } else {
2262                                 $not = "";
2263                         }
2264
2265                         $commandpair = explode(":", mb_strtolower($k), 2);
2266
2267                         switch ($commandpair[0]) {
2268                         case "title":
2269                                 if ($commandpair[1]) {
2270                                         array_push($query_keywords, "($not (LOWER(ttrss_entries.title) LIKE '%".
2271                                                 db_escape_string(mb_strtolower($commandpair[1]))."%'))");
2272                                 } else {
2273                                         array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
2274                                                         OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
2275                                         array_push($search_words, $k);
2276                                 }
2277                                 break;
2278                         case "author":
2279                                 if ($commandpair[1]) {
2280                                         array_push($query_keywords, "($not (LOWER(author) LIKE '%".
2281                                                 db_escape_string(mb_strtolower($commandpair[1]))."%'))");
2282                                 } else {
2283                                         array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
2284                                                         OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
2285                                         array_push($search_words, $k);
2286                                 }
2287                                 break;
2288                         case "note":
2289                                 if ($commandpair[1]) {
2290                                         if ($commandpair[1] == "true")
2291                                                 array_push($query_keywords, "($not (note IS NOT NULL AND note != ''))");
2292                                         else if ($commandpair[1] == "false")
2293                                                 array_push($query_keywords, "($not (note IS NULL OR note = ''))");
2294                                         else
2295                                                 array_push($query_keywords, "($not (LOWER(note) LIKE '%".
2296                                                         db_escape_string(mb_strtolower($commandpair[1]))."%'))");
2297                                 } else {
2298                                         array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
2299                                                         OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
2300                                         if (!$not) array_push($search_words, $k);
2301                                 }
2302                                 break;
2303                         case "star":
2304
2305                                 if ($commandpair[1]) {
2306                                         if ($commandpair[1] == "true")
2307                                                 array_push($query_keywords, "($not (marked = true))");
2308                                         else
2309                                                 array_push($query_keywords, "($not (marked = false))");
2310                                 } else {
2311                                         array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
2312                                                         OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
2313                                         if (!$not) array_push($search_words, $k);
2314                                 }
2315                                 break;
2316                         case "pub":
2317                                 if ($commandpair[1]) {
2318                                         if ($commandpair[1] == "true")
2319                                                 array_push($query_keywords, "($not (published = true))");
2320                                         else
2321                                                 array_push($query_keywords, "($not (published = false))");
2322
2323                                 } else {
2324                                         array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
2325                                                         OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
2326                                         if (!$not) array_push($search_words, $k);
2327                                 }
2328                                 break;
2329                         default:
2330                                 if (strpos($k, "@") === 0) {
2331
2332                                         $user_tz_string = get_pref('USER_TIMEZONE', $_SESSION['uid']);
2333                                         $orig_ts = strtotime(substr($k, 1));
2334                                         $k = date("Y-m-d", convert_timestamp($orig_ts, $user_tz_string, 'UTC'));
2335
2336                                         //$k = date("Y-m-d", strtotime(substr($k, 1)));
2337
2338                                         array_push($query_keywords, "(".SUBSTRING_FOR_DATE."(updated,1,LENGTH('$k')) $not = '$k')");
2339                                 } else {
2340                                         array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
2341                                                         OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
2342
2343                                         if (!$not) array_push($search_words, $k);
2344                                 }
2345                         }
2346                 }
2347
2348                 $search_query_part = implode("AND", $query_keywords);
2349
2350                 return array($search_query_part, $search_words);
2351         }
2352
2353         function getParentCategories($cat, $owner_uid) {
2354                 $rv = array();
2355
2356                 $result = db_query("SELECT parent_cat FROM ttrss_feed_categories
2357                         WHERE id = '$cat' AND parent_cat IS NOT NULL AND owner_uid = $owner_uid");
2358
2359                 while ($line = db_fetch_assoc($result)) {
2360                         array_push($rv, $line["parent_cat"]);
2361                         $rv = array_merge($rv, getParentCategories($line["parent_cat"], $owner_uid));
2362                 }
2363
2364                 return $rv;
2365         }
2366
2367         function getChildCategories($cat, $owner_uid) {
2368                 $rv = array();
2369
2370                 $result = db_query("SELECT id FROM ttrss_feed_categories
2371                         WHERE parent_cat = '$cat' AND owner_uid = $owner_uid");
2372
2373                 while ($line = db_fetch_assoc($result)) {
2374                         array_push($rv, $line["id"]);
2375                         $rv = array_merge($rv, getChildCategories($line["id"], $owner_uid));
2376                 }
2377
2378                 return $rv;
2379         }
2380
2381         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) {
2382
2383                 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
2384
2385                 $ext_tables_part = "";
2386                 $search_words = array();
2387
2388                         if ($search) {
2389
2390                                 if (SPHINX_ENABLED) {
2391                                         $ids = join(",", @sphinx_search($search, 0, 500));
2392
2393                                         if ($ids)
2394                                                 $search_query_part = "ref_id IN ($ids) AND ";
2395                                         else
2396                                                 $search_query_part = "ref_id = -1 AND ";
2397
2398                                 } else {
2399                                         list($search_query_part, $search_words) = search_to_sql($search);
2400                                         $search_query_part .= " AND ";
2401                                 }
2402
2403                         } else {
2404                                 $search_query_part = "";
2405                         }
2406
2407                         if ($filter) {
2408
2409                                 if (DB_TYPE == "pgsql") {
2410                                         $query_strategy_part .= " AND updated > NOW() - INTERVAL '14 days' ";
2411                                 } else {
2412                                         $query_strategy_part .= " AND updated > DATE_SUB(NOW(), INTERVAL 14 DAY) ";
2413                                 }
2414
2415                                 $override_order = "updated DESC";
2416
2417                                 $filter_query_part = filter_to_sql($filter, $owner_uid);
2418
2419                                 // Try to check if SQL regexp implementation chokes on a valid regexp
2420
2421
2422                                 $result = db_query("SELECT true AS true_val FROM ttrss_entries,
2423                                         ttrss_user_entries, ttrss_feeds
2424                                         WHERE $filter_query_part LIMIT 1", false);
2425
2426                                 if ($result) {
2427                                         $test = db_fetch_result($result, 0, "true_val");
2428
2429                                         if (!$test) {
2430                                                 $filter_query_part = "false AND";
2431                                         } else {
2432                                                 $filter_query_part .= " AND";
2433                                         }
2434                                 } else {
2435                                         $filter_query_part = "false AND";
2436                                 }
2437
2438                         } else {
2439                                 $filter_query_part = "";
2440                         }
2441
2442                         if ($since_id) {
2443                                 $since_id_part = "ttrss_entries.id > $since_id AND ";
2444                         } else {
2445                                 $since_id_part = "";
2446                         }
2447
2448                         $view_query_part = "";
2449
2450                         if ($view_mode == "adaptive") {
2451                                 if ($search) {
2452                                         $view_query_part = " ";
2453                                 } else if ($feed != -1) {
2454
2455                                         $unread = getFeedUnread($feed, $cat_view);
2456
2457                                         if ($cat_view && $feed > 0 && $include_children)
2458                                                 $unread += getCategoryChildrenUnread($feed);
2459
2460                                         if ($unread > 0)
2461                                 $view_query_part = " unread = true AND ";
2462
2463                                 }
2464                         }
2465
2466                         if ($view_mode == "marked") {
2467                                 $view_query_part = " marked = true AND ";
2468                         }
2469
2470                         if ($view_mode == "has_note") {
2471                                 $view_query_part = " (note IS NOT NULL AND note != '') AND ";
2472                         }
2473
2474                         if ($view_mode == "published") {
2475                                 $view_query_part = " published = true AND ";
2476                         }
2477
2478                         if ($view_mode == "unread" && $feed != -6) {
2479                                 $view_query_part = " unread = true AND ";
2480                         }
2481
2482                         if ($limit > 0) {
2483                                 $limit_query_part = "LIMIT " . $limit;
2484                         }
2485
2486                         $allow_archived = false;
2487
2488                         $vfeed_query_part = "";
2489
2490                         // override query strategy and enable feed display when searching globally
2491                         if ($search && $search_mode == "all_feeds") {
2492                                 $query_strategy_part = "true";
2493                                 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2494                         /* tags */
2495                         } else if (!is_numeric($feed)) {
2496                                 $query_strategy_part = "true";
2497                                 $vfeed_query_part = "(SELECT title FROM ttrss_feeds WHERE
2498                                         id = feed_id) as feed_title,";
2499                         } else if ($search && $search_mode == "this_cat") {
2500                                 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2501
2502                                 if ($feed > 0) {
2503                                         if ($include_children) {
2504                                                 $subcats = getChildCategories($feed, $owner_uid);
2505                                                 array_push($subcats, $feed);
2506                                                 $cats_qpart = join(",", $subcats);
2507                                         } else {
2508                                                 $cats_qpart = $feed;
2509                                         }
2510
2511                                         $query_strategy_part = "ttrss_feeds.cat_id IN ($cats_qpart)";
2512
2513                                 } else {
2514                                         $query_strategy_part = "ttrss_feeds.cat_id IS NULL";
2515                                 }
2516
2517                         } else if ($feed > 0) {
2518
2519                                 if ($cat_view) {
2520
2521                                         if ($feed > 0) {
2522                                                 if ($include_children) {
2523                                                         # sub-cats
2524                                                         $subcats = getChildCategories($feed, $owner_uid);
2525
2526                                                         array_push($subcats, $feed);
2527                                                         $query_strategy_part = "cat_id IN (".
2528                                                                         implode(",", $subcats).")";
2529
2530                                                 } else {
2531                                                         $query_strategy_part = "cat_id = '$feed'";
2532                                                 }
2533
2534                                         } else {
2535                                                 $query_strategy_part = "cat_id IS NULL";
2536                                         }
2537
2538                                         $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2539
2540                                 } else {
2541                                         $query_strategy_part = "feed_id = '$feed'";
2542                                 }
2543                         } else if ($feed == 0 && !$cat_view) { // archive virtual feed
2544                                 $query_strategy_part = "feed_id IS NULL";
2545                                 $allow_archived = true;
2546                         } else if ($feed == 0 && $cat_view) { // uncategorized
2547                                 $query_strategy_part = "cat_id IS NULL AND feed_id IS NOT NULL";
2548                                 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2549                         } else if ($feed == -1) { // starred virtual feed
2550                                 $query_strategy_part = "marked = true";
2551                                 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2552                                 $allow_archived = true;
2553
2554                                 if (!$override_order) {
2555                                         $override_order = "last_marked DESC, date_entered DESC, updated DESC";
2556                                 }
2557
2558                         } else if ($feed == -2) { // published virtual feed OR labels category
2559
2560                                 if (!$cat_view) {
2561                                         $query_strategy_part = "published = true";
2562                                         $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2563                                         $allow_archived = true;
2564
2565                                         if (!$override_order) {
2566                                                 $override_order = "last_published DESC, date_entered DESC, updated DESC";
2567                                         }
2568
2569                                 } else {
2570                                         $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2571
2572                                         $ext_tables_part = ",ttrss_labels2,ttrss_user_labels2";
2573
2574                                         $query_strategy_part = "ttrss_labels2.id = ttrss_user_labels2.label_id AND
2575                                                 ttrss_user_labels2.article_id = ref_id";
2576
2577                                 }
2578                         } else if ($feed == -6) { // recently read
2579                                 $query_strategy_part = "unread = false AND last_read IS NOT NULL";
2580                                 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2581                                 $allow_archived = true;
2582
2583                                 if (!$override_order) $override_order = "last_read DESC";
2584
2585 /*                      } else if ($feed == -7) { // shared
2586                                 $query_strategy_part = "uuid != ''";
2587                                 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2588                                 $allow_archived = true; */
2589                         } else if ($feed == -3) { // fresh virtual feed
2590                                 $query_strategy_part = "unread = true AND score >= 0";
2591
2592                                 $intl = get_pref("FRESH_ARTICLE_MAX_AGE", $owner_uid);
2593
2594                                 if (DB_TYPE == "pgsql") {
2595                                         $query_strategy_part .= " AND date_entered > NOW() - INTERVAL '$intl hour' ";
2596                                 } else {
2597                                         $query_strategy_part .= " AND date_entered > DATE_SUB(NOW(), INTERVAL $intl HOUR) ";
2598                                 }
2599
2600                                 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2601                         } else if ($feed == -4) { // all articles virtual feed
2602                                 $allow_archived = true;
2603                                 $query_strategy_part = "true";
2604                                 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2605                         } else if ($feed <= LABEL_BASE_INDEX) { // labels
2606                                 $label_id = feed_to_label_id($feed);
2607
2608                                 $query_strategy_part = "label_id = '$label_id' AND
2609                                         ttrss_labels2.id = ttrss_user_labels2.label_id AND
2610                                         ttrss_user_labels2.article_id = ref_id";
2611
2612                                 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2613                                 $ext_tables_part = ",ttrss_labels2,ttrss_user_labels2";
2614                                 $allow_archived = true;
2615
2616                         } else {
2617                                 $query_strategy_part = "true";
2618                         }
2619
2620                         $order_by = "score DESC, date_entered DESC, updated DESC";
2621
2622                         if ($view_mode == "unread_first") {
2623                                 $order_by = "unread DESC, $order_by";
2624                         }
2625
2626                         if ($override_order) {
2627                                 $order_by = $override_order;
2628                         }
2629
2630                         if ($override_strategy) {
2631                                 $query_strategy_part = $override_strategy;
2632                         }
2633
2634                         if ($override_vfeed) {
2635                                 $vfeed_query_part = $override_vfeed;
2636                         }
2637
2638                         $feed_title = "";
2639
2640                         if ($search) {
2641                                 $feed_title = T_sprintf("Search results: %s", $search);
2642                         } else {
2643                                 if ($cat_view) {
2644                                         $feed_title = getCategoryTitle($feed);
2645                                 } else {
2646                                         if (is_numeric($feed) && $feed > 0) {
2647                                                 $result = db_query("SELECT title,site_url,last_error,last_updated
2648                                                         FROM ttrss_feeds WHERE id = '$feed' AND owner_uid = $owner_uid");
2649
2650                                                 $feed_title = db_fetch_result($result, 0, "title");
2651                                                 $feed_site_url = db_fetch_result($result, 0, "site_url");
2652                                                 $last_error = db_fetch_result($result, 0, "last_error");
2653                                                 $last_updated = db_fetch_result($result, 0, "last_updated");
2654                                         } else {
2655                                                 $feed_title = getFeedTitle($feed);
2656                                         }
2657                                 }
2658                         }
2659
2660
2661                         $content_query_part = "content, ";
2662
2663
2664                         if (is_numeric($feed)) {
2665
2666                                 if ($feed >= 0) {
2667                                         $feed_kind = "Feeds";
2668                                 } else {
2669                                         $feed_kind = "Labels";
2670                                 }
2671
2672                                 if ($limit_query_part) {
2673                                         $offset_query_part = "OFFSET $offset";
2674                                 }
2675
2676                                 // proper override_order applied above
2677                                 if ($vfeed_query_part && !$ignore_vfeed_group && get_pref('VFEED_GROUP_BY_FEED', $owner_uid)) {
2678                                         if (!$override_order) {
2679                                                 $order_by = "ttrss_feeds.title, $order_by";
2680                                         } else {
2681                                                 $order_by = "ttrss_feeds.title, $override_order";
2682                                         }
2683                                 }
2684
2685                                 if (!$allow_archived) {
2686                                         $from_qpart = "ttrss_entries,ttrss_user_entries,ttrss_feeds$ext_tables_part";
2687                                         $feed_check_qpart = "ttrss_user_entries.feed_id = ttrss_feeds.id AND";
2688
2689                                 } else {
2690                                         $from_qpart = "ttrss_entries$ext_tables_part,ttrss_user_entries
2691                                                 LEFT JOIN ttrss_feeds ON (feed_id = ttrss_feeds.id)";
2692                                 }
2693
2694                                 if ($vfeed_query_part)
2695                                         $vfeed_query_part .= "favicon_avg_color,";
2696
2697                                 $query = "SELECT DISTINCT
2698                                                 date_entered,
2699                                                 guid,
2700                                                 ttrss_entries.id,ttrss_entries.title,
2701                                                 updated,
2702                                                 label_cache,
2703                                                 tag_cache,
2704                                                 always_display_enclosures,
2705                                                 site_url,
2706                                                 note,
2707                                                 num_comments,
2708                                                 comments,
2709                                                 int_id,
2710                                                 uuid,
2711                                                 lang,
2712                                                 hide_images,
2713                                                 unread,feed_id,marked,published,link,last_read,orig_feed_id,
2714                                                 last_marked, last_published,
2715                                                 $vfeed_query_part
2716                                                 $content_query_part
2717                                                 author,score
2718                                         FROM
2719                                                 $from_qpart
2720                                         WHERE
2721                                         $feed_check_qpart
2722                                         ttrss_user_entries.ref_id = ttrss_entries.id AND
2723                                         ttrss_user_entries.owner_uid = '$owner_uid' AND
2724                                         $search_query_part
2725                                         $filter_query_part
2726                                         $view_query_part
2727                                         $since_id_part
2728                                         $query_strategy_part ORDER BY $order_by
2729                                         $limit_query_part $offset_query_part";
2730
2731                                 if ($_REQUEST["debug"]) print $query;
2732
2733                                 $result = db_query($query);
2734
2735                         } else {
2736                                 // browsing by tag
2737
2738                                 $select_qpart = "SELECT DISTINCT " .
2739                                                                 "date_entered," .
2740                                                                 "guid," .
2741                                                                 "note," .
2742                                                                 "ttrss_entries.id as id," .
2743                                                                 "title," .
2744                                                                 "updated," .
2745                                                                 "unread," .
2746                                                                 "feed_id," .
2747                                                                 "orig_feed_id," .
2748                                                                 "marked," .
2749                                                                 "num_comments, " .
2750                                                                 "comments, " .
2751                                                                 "tag_cache," .
2752                                                                 "label_cache," .
2753                                                                 "link," .
2754                                                                 "lang," .
2755                                                                 "uuid," .
2756                                                                 "last_read," .
2757                                                                 "(SELECT hide_images FROM ttrss_feeds WHERE id = feed_id) AS hide_images," .
2758                                                                 "last_marked, last_published, " .
2759                                                                 $since_id_part .
2760                                                                 $vfeed_query_part .
2761                                                                 $content_query_part .
2762                                                                 "score ";
2763
2764                                 $feed_kind = "Tags";
2765                                 $all_tags = explode(",", $feed);
2766                                 if ($search_mode == 'any') {
2767                                         $tag_sql = "tag_name in (" . implode(", ", array_map("db_quote", $all_tags)) . ")";
2768                                         $from_qpart = " FROM ttrss_entries,ttrss_user_entries,ttrss_tags ";
2769                                         $where_qpart = " WHERE " .
2770                                                                    "ref_id = ttrss_entries.id AND " .
2771                                                                    "ttrss_user_entries.owner_uid = $owner_uid AND " .
2772                                                                    "post_int_id = int_id AND $tag_sql AND " .
2773                                                                    $view_query_part .
2774                                                                    $search_query_part .
2775                                                                    $query_strategy_part . " ORDER BY $order_by " .
2776                                                                    $limit_query_part;
2777
2778                                 } else {
2779                                         $i = 1;
2780                                         $sub_selects = array();
2781                                         $sub_ands = array();
2782                                         foreach ($all_tags as $term) {
2783                                                 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");
2784                                                 $i++;
2785                                         }
2786                                         if ($i > 2) {
2787                                                 $x = 1;
2788                                                 $y = 2;
2789                                                 do {
2790                                                         array_push($sub_ands, "A$x.post_int_id = A$y.post_int_id");
2791                                                         $x++;
2792                                                         $y++;
2793                                                 } while ($y < $i);
2794                                         }
2795                                         array_push($sub_ands, "A1.post_int_id = ttrss_user_entries.int_id and ttrss_user_entries.owner_uid = $owner_uid");
2796                                         array_push($sub_ands, "ttrss_user_entries.ref_id = ttrss_entries.id");
2797                                         $from_qpart = " FROM " . implode(", ", $sub_selects) . ", ttrss_user_entries, ttrss_entries";
2798                                         $where_qpart = " WHERE " . implode(" AND ", $sub_ands);
2799                                 }
2800                                 //                              error_log("TAG SQL: " . $tag_sql);
2801                                 // $tag_sql = "tag_name = '$feed'";   DEFAULT way
2802
2803                                 //                              error_log("[". $select_qpart . "][" . $from_qpart . "][" .$where_qpart . "]");
2804                                 $result = db_query($select_qpart . $from_qpart . $where_qpart);
2805                         }
2806
2807                         return array($result, $feed_title, $feed_site_url, $last_error, $last_updated, $search_words);
2808
2809         }
2810
2811         function sanitize($str, $force_remove_images = false, $owner = false, $site_url = false, $highlight_words = false, $article_id = false) {
2812                 if (!$owner) $owner = $_SESSION["uid"];
2813
2814                 $res = trim($str); if (!$res) return '';
2815
2816                 $charset_hack = '<head>
2817                         <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
2818                 </head>';
2819
2820                 $res = trim($res); if (!$res) return '';
2821
2822                 libxml_use_internal_errors(true);
2823
2824                 $doc = new DOMDocument();
2825                 $doc->loadHTML($charset_hack . $res);
2826                 $xpath = new DOMXPath($doc);
2827
2828                 $entries = $xpath->query('(//a[@href]|//img[@src])');
2829
2830                 foreach ($entries as $entry) {
2831
2832                         if ($site_url) {
2833
2834                                 if ($entry->hasAttribute('href')) {
2835                                         $entry->setAttribute('href',
2836                                                 rewrite_relative_url($site_url, $entry->getAttribute('href')));
2837
2838                                         $entry->setAttribute('rel', 'noreferrer');
2839                                 }
2840
2841                                 if ($entry->hasAttribute('src')) {
2842                                         $src = rewrite_relative_url($site_url, $entry->getAttribute('src'));
2843
2844                                         $cached_filename = CACHE_DIR . '/images/' . sha1($src) . '.png';
2845
2846                                         if (file_exists($cached_filename)) {
2847                                                 $src = SELF_URL_PATH . '/image.php?hash=' . sha1($src);
2848                                         }
2849
2850                                         $entry->setAttribute('src', $src);
2851                                 }
2852
2853                                 if ($entry->nodeName == 'img') {
2854                                         if (($owner && get_pref("STRIP_IMAGES", $owner)) ||
2855                                                         $force_remove_images || $_SESSION["bw_limit"]) {
2856
2857                                                 $p = $doc->createElement('p');
2858
2859                                                 $a = $doc->createElement('a');
2860                                                 $a->setAttribute('href', $entry->getAttribute('src'));
2861
2862                                                 $a->appendChild(new DOMText($entry->getAttribute('src')));
2863                                                 $a->setAttribute('target', '_blank');
2864
2865                                                 $p->appendChild($a);
2866
2867                                                 $entry->parentNode->replaceChild($p, $entry);
2868                                         }
2869                                 }
2870                         }
2871
2872                         if (strtolower($entry->nodeName) == "a") {
2873                                 $entry->setAttribute("target", "_blank");
2874                         }
2875                 }
2876
2877                 $entries = $xpath->query('//iframe');
2878                 foreach ($entries as $entry) {
2879                         $entry->setAttribute('sandbox', 'allow-scripts');
2880
2881                 }
2882
2883                 $allowed_elements = array('a', 'address', 'audio', 'article', 'aside',
2884                         'b', 'bdi', 'bdo', 'big', 'blockquote', 'body', 'br',
2885                         'caption', 'cite', 'center', 'code', 'col', 'colgroup',
2886                         'data', 'dd', 'del', 'details', 'div', 'dl', 'font',
2887                         'dt', 'em', 'footer', 'figure', 'figcaption',
2888                         'h1', 'h2', 'h3', 'h4', 'h5', 'h6', 'header', 'html', 'i',
2889                         'img', 'ins', 'kbd', 'li', 'main', 'mark', 'nav', 'noscript',
2890                         'ol', 'p', 'pre', 'q', 'ruby', 'rp', 'rt', 's', 'samp', 'section',
2891                         'small', 'source', 'span', 'strike', 'strong', 'sub', 'summary',
2892                         'sup', 'table', 'tbody', 'td', 'tfoot', 'th', 'thead', 'time',
2893                         'tr', 'track', 'tt', 'u', 'ul', 'var', 'wbr', 'video' );
2894
2895                 if ($_SESSION['hasSandbox']) $allowed_elements[] = 'iframe';
2896
2897                 $disallowed_attributes = array('id', 'style', 'class');
2898
2899                 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_SANITIZE) as $plugin) {
2900                         $retval = $plugin->hook_sanitize($doc, $site_url, $allowed_elements, $disallowed_attributes, $article_id);
2901                         if (is_array($retval)) {
2902                                 $doc = $retval[0];
2903                                 $allowed_elements = $retval[1];
2904                                 $disallowed_attributes = $retval[2];
2905                         } else {
2906                                 $doc = $retval;
2907                         }
2908                 }
2909
2910                 $doc->removeChild($doc->firstChild); //remove doctype
2911                 $doc = strip_harmful_tags($doc, $allowed_elements, $disallowed_attributes);
2912
2913                 if ($highlight_words) {
2914                         foreach ($highlight_words as $word) {
2915
2916                                 // http://stackoverflow.com/questions/4081372/highlight-keywords-in-a-paragraph
2917
2918                                 $elements = $xpath->query("//*/text()");
2919
2920                                 foreach ($elements as $child) {
2921
2922                                         $fragment = $doc->createDocumentFragment();
2923                                         $text = $child->textContent;
2924
2925                                         while (($pos = mb_stripos($text, $word)) !== false) {
2926                                                 $fragment->appendChild(new DomText(mb_substr($text, 0, $pos)));
2927                                                 $word = mb_substr($text, $pos, mb_strlen($word));
2928                                                 $highlight = $doc->createElement('span');
2929                                                 $highlight->appendChild(new DomText($word));
2930                                                 $highlight->setAttribute('class', 'highlight');
2931                                                 $fragment->appendChild($highlight);
2932                                                 $text = mb_substr($text, $pos + mb_strlen($word));
2933                                         }
2934
2935                                         if (!empty($text)) $fragment->appendChild(new DomText($text));
2936
2937                                         $child->parentNode->replaceChild($fragment, $child);
2938                                 }
2939                         }
2940                 }
2941
2942                 $res = $doc->saveHTML();
2943
2944                 return $res;
2945         }
2946
2947         function strip_harmful_tags($doc, $allowed_elements, $disallowed_attributes) {
2948                 $xpath = new DOMXPath($doc);
2949                 $entries = $xpath->query('//*');
2950
2951                 foreach ($entries as $entry) {
2952                         if (!in_array($entry->nodeName, $allowed_elements)) {
2953                                 $entry->parentNode->removeChild($entry);
2954                         }
2955
2956                         if ($entry->hasAttributes()) {
2957                                 $attrs_to_remove = array();
2958
2959                                 foreach ($entry->attributes as $attr) {
2960
2961                                         if (strpos($attr->nodeName, 'on') === 0) {
2962                                                 array_push($attrs_to_remove, $attr);
2963                                         }
2964
2965                                         if (in_array($attr->nodeName, $disallowed_attributes)) {
2966                                                 array_push($attrs_to_remove, $attr);
2967                                         }
2968                                 }
2969
2970                                 foreach ($attrs_to_remove as $attr) {
2971                                         $entry->removeAttributeNode($attr);
2972                                 }
2973                         }
2974                 }
2975
2976                 return $doc;
2977         }
2978
2979         function check_for_update() {
2980                 if (CHECK_FOR_NEW_VERSION && $_SESSION['access_level'] >= 10) {
2981                         $version_url = "http://tt-rss.org/version.php?ver=" . VERSION .
2982                                 "&iid=" . sha1(SELF_URL_PATH);
2983
2984                         $version_data = @fetch_file_contents($version_url);
2985
2986                         if ($version_data) {
2987                                 $version_data = json_decode($version_data, true);
2988                                 if ($version_data && $version_data['version']) {
2989                                         if (version_compare(VERSION_STATIC, $version_data['version']) == -1) {
2990                                                 return $version_data;
2991                                         }
2992                                 }
2993                         }
2994                 }
2995                 return false;
2996         }
2997
2998         function catchupArticlesById($ids, $cmode, $owner_uid = false) {
2999
3000                 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
3001                 if (count($ids) == 0) return;
3002
3003                 $tmp_ids = array();
3004
3005                 foreach ($ids as $id) {
3006                         array_push($tmp_ids, "ref_id = '$id'");
3007                 }
3008
3009                 $ids_qpart = join(" OR ", $tmp_ids);
3010
3011                 if ($cmode == 0) {
3012                         db_query("UPDATE ttrss_user_entries SET
3013                         unread = false,last_read = NOW()
3014                         WHERE ($ids_qpart) AND owner_uid = $owner_uid");
3015                 } else if ($cmode == 1) {
3016                         db_query("UPDATE ttrss_user_entries SET
3017                         unread = true
3018                         WHERE ($ids_qpart) AND owner_uid = $owner_uid");
3019                 } else {
3020                         db_query("UPDATE ttrss_user_entries SET
3021                         unread = NOT unread,last_read = NOW()
3022                         WHERE ($ids_qpart) AND owner_uid = $owner_uid");
3023                 }
3024
3025                 /* update ccache */
3026
3027                 $result = db_query("SELECT DISTINCT feed_id FROM ttrss_user_entries
3028                         WHERE ($ids_qpart) AND owner_uid = $owner_uid");
3029
3030                 while ($line = db_fetch_assoc($result)) {
3031                         ccache_update($line["feed_id"], $owner_uid);
3032                 }
3033         }
3034
3035         function get_article_tags($id, $owner_uid = 0, $tag_cache = false) {
3036
3037                 $a_id = db_escape_string($id);
3038
3039                 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
3040
3041                 $query = "SELECT DISTINCT tag_name,
3042                         owner_uid as owner FROM
3043                         ttrss_tags WHERE post_int_id = (SELECT int_id FROM ttrss_user_entries WHERE
3044                         ref_id = '$a_id' AND owner_uid = '$owner_uid' LIMIT 1) ORDER BY tag_name";
3045
3046                 $tags = array();
3047
3048                 /* check cache first */
3049
3050                 if ($tag_cache === false) {
3051                         $result = db_query("SELECT tag_cache FROM ttrss_user_entries
3052                                 WHERE ref_id = '$id' AND owner_uid = $owner_uid");
3053
3054                         $tag_cache = db_fetch_result($result, 0, "tag_cache");
3055                 }
3056
3057                 if ($tag_cache) {
3058                         $tags = explode(",", $tag_cache);
3059                 } else {
3060
3061                         /* do it the hard way */
3062
3063                         $tmp_result = db_query($query);
3064
3065                         while ($tmp_line = db_fetch_assoc($tmp_result)) {
3066                                 array_push($tags, $tmp_line["tag_name"]);
3067                         }
3068
3069                         /* update the cache */
3070
3071                         $tags_str = db_escape_string(join(",", $tags));
3072
3073                         db_query("UPDATE ttrss_user_entries
3074                                 SET tag_cache = '$tags_str' WHERE ref_id = '$id'
3075                                 AND owner_uid = $owner_uid");
3076                 }
3077
3078                 return $tags;
3079         }
3080
3081         function trim_array($array) {
3082                 $tmp = $array;
3083                 array_walk($tmp, 'trim');
3084                 return $tmp;
3085         }
3086
3087         function tag_is_valid($tag) {
3088                 if ($tag == '') return false;
3089                 if (preg_match("/^[0-9]*$/", $tag)) return false;
3090                 if (mb_strlen($tag) > 250) return false;
3091
3092                 if (!$tag) return false;
3093
3094                 return true;
3095         }
3096
3097         function render_login_form() {
3098                 header('Cache-Control: public');
3099
3100                 require_once "login_form.php";
3101                 exit;
3102         }
3103
3104         function format_warning($msg, $id = "") {
3105                 return "<div class=\"warning\" id=\"$id\">
3106                         <span><img src=\"images/alert.png\"></span><span>$msg</span></div>";
3107         }
3108
3109         function format_notice($msg, $id = "") {
3110                 return "<div class=\"notice\" id=\"$id\">
3111                         <span><img src=\"images/information.png\"></span><span>$msg</span></div>";
3112         }
3113
3114         function format_error($msg, $id = "") {
3115                 return "<div class=\"error\" id=\"$id\">
3116                         <span><img src=\"images/alert.png\"></span><span>$msg</span></div>";
3117         }
3118
3119         function print_notice($msg) {
3120                 return print format_notice($msg);
3121         }
3122
3123         function print_warning($msg) {
3124                 return print format_warning($msg);
3125         }
3126
3127         function print_error($msg) {
3128                 return print format_error($msg);
3129         }
3130
3131
3132         function T_sprintf() {
3133                 $args = func_get_args();
3134                 return vsprintf(__(array_shift($args)), $args);
3135         }
3136
3137         function format_inline_player($url, $ctype) {
3138
3139                 $entry = "";
3140
3141                 $url = htmlspecialchars($url);
3142
3143                 if (strpos($ctype, "audio/") === 0) {
3144
3145                         if ($_SESSION["hasAudio"] && (strpos($ctype, "ogg") !== false ||
3146                                 $_SESSION["hasMp3"])) {
3147
3148                                 $entry .= "<audio preload=\"none\" controls>
3149                                         <source type=\"$ctype\" src=\"$url\"></source>
3150                                         </audio>";
3151
3152                         } else {
3153
3154                                 $entry .= "<object type=\"application/x-shockwave-flash\"
3155                                         data=\"lib/button/musicplayer.swf?song_url=$url\"
3156                                         width=\"17\" height=\"17\" style='float : left; margin-right : 5px;'>
3157                                         <param name=\"movie\"
3158                                                 value=\"lib/button/musicplayer.swf?song_url=$url\" />
3159                                         </object>";
3160                         }
3161
3162                         if ($entry) $entry .= "&nbsp; <a target=\"_blank\"
3163                                 href=\"$url\">" . basename($url) . "</a>";
3164
3165                         return $entry;
3166
3167                 }
3168
3169                 return "";
3170
3171 /*              $filename = substr($url, strrpos($url, "/")+1);
3172
3173                 $entry .= " <a target=\"_blank\" href=\"" . htmlspecialchars($url) . "\">" .
3174                         $filename . " (" . $ctype . ")" . "</a>"; */
3175
3176         }
3177
3178         function format_article($id, $mark_as_read = true, $zoom_mode = false, $owner_uid = false) {
3179                 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
3180
3181                 $rv = array();
3182
3183                 $rv['id'] = $id;
3184
3185                 /* we can figure out feed_id from article id anyway, why do we
3186                  * pass feed_id here? let's ignore the argument :(*/
3187
3188                 $result = db_query("SELECT feed_id FROM ttrss_user_entries
3189                         WHERE ref_id = '$id'");
3190
3191                 $feed_id = (int) db_fetch_result($result, 0, "feed_id");
3192
3193                 $rv['feed_id'] = $feed_id;
3194
3195                 //if (!$zoom_mode) { print "<article id='$id'><![CDATA["; };
3196
3197                 if ($mark_as_read) {
3198                         $result = db_query("UPDATE ttrss_user_entries
3199                                 SET unread = false,last_read = NOW()
3200                                 WHERE ref_id = '$id' AND owner_uid = $owner_uid");
3201
3202                         ccache_update($feed_id, $owner_uid);
3203                 }
3204
3205                 $result = db_query("SELECT id,title,link,content,feed_id,comments,int_id,lang,
3206                         ".SUBSTRING_FOR_DATE."(updated,1,16) as updated,
3207                         (SELECT site_url FROM ttrss_feeds WHERE id = feed_id) as site_url,
3208                         (SELECT title FROM ttrss_feeds WHERE id = feed_id) as feed_title,
3209                         (SELECT hide_images FROM ttrss_feeds WHERE id = feed_id) as hide_images,
3210                         (SELECT always_display_enclosures FROM ttrss_feeds WHERE id = feed_id) as always_display_enclosures,
3211                         num_comments,
3212                         tag_cache,
3213                         author,
3214                         orig_feed_id,
3215                         note
3216                         FROM ttrss_entries,ttrss_user_entries
3217                         WHERE   id = '$id' AND ref_id = id AND owner_uid = $owner_uid");
3218
3219                 if ($result) {
3220
3221                         $line = db_fetch_assoc($result);
3222
3223                         $line["tags"] = get_article_tags($id, $owner_uid, $line["tag_cache"]);
3224                         unset($line["tag_cache"]);
3225
3226                         $line["content"] = sanitize($line["content"],
3227                                 sql_bool_to_bool($line['hide_images']),
3228                                 $owner_uid, $line["site_url"], false, $line["id"]);
3229
3230                         foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_RENDER_ARTICLE) as $p) {
3231                                 $line = $p->hook_render_article($line);
3232                         }
3233
3234                         $num_comments = $line["num_comments"];
3235                         $entry_comments = "";
3236
3237                         if ($num_comments > 0) {
3238                                 if ($line["comments"]) {
3239                                         $comments_url = htmlspecialchars($line["comments"]);
3240                                 } else {
3241                                         $comments_url = htmlspecialchars($line["link"]);
3242                                 }
3243                                 $entry_comments = "<a class=\"postComments\"
3244                                         target='_blank' href=\"$comments_url\">$num_comments ".
3245                                         _ngettext("comment", "comments", $num_comments)."</a>";
3246
3247                         } else {
3248                                 if ($line["comments"] && $line["link"] != $line["comments"]) {
3249                                         $entry_comments = "<a class=\"postComments\" target='_blank' href=\"".htmlspecialchars($line["comments"])."\">".__("comments")."</a>";
3250                                 }
3251                         }
3252
3253                         if ($zoom_mode) {
3254                                 header("Content-Type: text/html");
3255                                 $rv['content'] .= "<html><head>
3256                                                 <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"/>
3257                                                 <title>Tiny Tiny RSS - ".$line["title"]."</title>".
3258                                                 stylesheet_tag("css/tt-rss.css").
3259                                                 stylesheet_tag("css/zoom.css").
3260                                                 stylesheet_tag("css/dijit.css")."
3261
3262                                                 <link rel=\"shortcut icon\" type=\"image/png\" href=\"images/favicon.png\">
3263                                                 <link rel=\"icon\" type=\"image/png\" sizes=\"72x72\" href=\"images/favicon-72px.png\">
3264
3265                                                 <script type=\"text/javascript\">
3266                                                 function openSelectedAttachment(elem) {
3267                                                         try {
3268                                                                 var url = elem[elem.selectedIndex].value;
3269
3270                                                                 if (url) {
3271                                                                         window.open(url);
3272                                                                         elem.selectedIndex = 0;
3273                                                                 }
3274
3275                                                         } catch (e) {
3276                                                                 exception_error(\"openSelectedAttachment\", e);
3277                                                         }
3278                                                 }
3279                                         </script>
3280                                         </head><body id=\"ttrssZoom\">";
3281                         }
3282
3283                         $rv['content'] .= "<div class=\"postReply\" id=\"POST-$id\">";
3284
3285                         $rv['content'] .= "<div class=\"postHeader\" id=\"POSTHDR-$id\">";
3286
3287                         $entry_author = $line["author"];
3288
3289                         if ($entry_author) {
3290                                 $entry_author = __(" - ") . $entry_author;
3291                         }
3292
3293                         $parsed_updated = make_local_datetime($line["updated"], true,
3294                                 $owner_uid, true);
3295
3296                         if (!$zoom_mode)
3297                                 $rv['content'] .= "<div class=\"postDate\">$parsed_updated</div>";
3298
3299                         if ($line["link"]) {
3300                                 $rv['content'] .= "<div class='postTitle'><a target='_blank'
3301                                         title=\"".htmlspecialchars($line['title'])."\"
3302                                         href=\"" .
3303                                         htmlspecialchars($line["link"]) . "\">" .
3304                                         $line["title"] . "</a>" .
3305                                         "<span class='author'>$entry_author</span></div>";
3306                         } else {
3307                                 $rv['content'] .= "<div class='postTitle'>" . $line["title"] . "$entry_author</div>";
3308                         }
3309
3310                         if ($zoom_mode) {
3311                                 $feed_title = "<a href=\"".htmlspecialchars($line["site_url"]).
3312                                         "\" target=\"_blank\">".
3313                                         htmlspecialchars($line["feed_title"])."</a>";
3314
3315                                 $rv['content'] .= "<div class=\"postFeedTitle\">$feed_title</div>";
3316
3317                                 $rv['content'] .= "<div class=\"postDate\">$parsed_updated</div>";
3318                         }
3319
3320                         $tags_str = format_tags_string($line["tags"], $id);
3321                         $tags_str_full = join(", ", $line["tags"]);
3322
3323                         if (!$tags_str_full) $tags_str_full = __("no tags");
3324
3325                         if (!$entry_comments) $entry_comments = "&nbsp;"; # placeholder
3326
3327                         $rv['content'] .= "<div class='postTags' style='float : right'>
3328                                 <img src='images/tag.png'
3329                                 class='tagsPic' alt='Tags' title='Tags'>&nbsp;";
3330
3331                         if (!$zoom_mode) {
3332                                 $rv['content'] .= "<span id=\"ATSTR-$id\">$tags_str</span>
3333                                         <a title=\"".__('Edit tags for this article')."\"
3334                                         href=\"#\" onclick=\"editArticleTags($id, $feed_id)\">(+)</a>";
3335
3336                                 $rv['content'] .= "<div dojoType=\"dijit.Tooltip\"
3337                                         id=\"ATSTRTIP-$id\" connectId=\"ATSTR-$id\"
3338                                         position=\"below\">$tags_str_full</div>";
3339
3340                                 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_ARTICLE_BUTTON) as $p) {
3341                                         $rv['content'] .= $p->hook_article_button($line);
3342                                 }
3343
3344                         } else {
3345                                 $tags_str = strip_tags($tags_str);
3346                                 $rv['content'] .= "<span id=\"ATSTR-$id\">$tags_str</span>";
3347                         }
3348                         $rv['content'] .= "</div>";
3349                         $rv['content'] .= "<div clear='both'>";
3350
3351                         foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_ARTICLE_LEFT_BUTTON) as $p) {
3352                                 $rv['content'] .= $p->hook_article_left_button($line);
3353                         }
3354
3355                         $rv['content'] .= "$entry_comments</div>";
3356
3357                         if ($line["orig_feed_id"]) {
3358
3359                                 $tmp_result = db_query("SELECT * FROM ttrss_archived_feeds
3360                                         WHERE id = ".$line["orig_feed_id"]);
3361
3362                                 if (db_num_rows($tmp_result) != 0) {
3363
3364                                         $rv['content'] .= "<div clear='both'>";
3365                                         $rv['content'] .= __("Originally from:");
3366
3367                                         $rv['content'] .= "&nbsp;";
3368
3369                                         $tmp_line = db_fetch_assoc($tmp_result);
3370
3371                                         $rv['content'] .= "<a target='_blank'
3372                                                 href=' " . htmlspecialchars($tmp_line['site_url']) . "'>" .
3373                                                 $tmp_line['title'] . "</a>";
3374
3375                                         $rv['content'] .= "&nbsp;";
3376
3377                                         $rv['content'] .= "<a target='_blank' href='" . htmlspecialchars($tmp_line['feed_url']) . "'>";
3378                                         $rv['content'] .= "<img title='".__('Feed URL')."' class='tinyFeedIcon' src='images/pub_set.png'></a>";
3379
3380                                         $rv['content'] .= "</div>";
3381                                 }
3382                         }
3383
3384                         $rv['content'] .= "</div>";
3385
3386                         $rv['content'] .= "<div id=\"POSTNOTE-$id\">";
3387                                 if ($line['note']) {
3388                                         $rv['content'] .= format_article_note($id, $line['note'], !$zoom_mode);
3389                                 }
3390                         $rv['content'] .= "</div>";
3391
3392                         if (!$line['lang']) $line['lang'] = 'en';
3393
3394                         $rv['content'] .= "<div class=\"postContent\" lang=\"".$line['lang']."\">";
3395
3396                         $rv['content'] .= $line["content"];
3397                         $rv['content'] .= format_article_enclosures($id,
3398                                 sql_bool_to_bool($line["always_display_enclosures"]),
3399                                 $line["content"],
3400                                 sql_bool_to_bool($line["hide_images"]));
3401
3402                         $rv['content'] .= "</div>";
3403
3404                         $rv['content'] .= "</div>";
3405
3406                 }
3407
3408                 if ($zoom_mode) {
3409                         $rv['content'] .= "
3410                                 <div class='footer'>
3411                                 <button onclick=\"return window.close()\">".
3412                                         __("Close this window")."</button></div>";
3413                         $rv['content'] .= "</body></html>";
3414                 }
3415
3416                 return $rv;
3417
3418         }
3419
3420         function print_checkpoint($n, $s) {
3421                 $ts = microtime(true);
3422                 echo sprintf("<!-- CP[$n] %.4f seconds -->\n", $ts - $s);
3423                 return $ts;
3424         }
3425
3426         function sanitize_tag($tag) {
3427                 $tag = trim($tag);
3428
3429                 $tag = mb_strtolower($tag, 'utf-8');
3430
3431                 $tag = preg_replace('/[\'\"\+\>\<]/', "", $tag);
3432
3433 //              $tag = str_replace('"', "", $tag);
3434 //              $tag = str_replace("+", " ", $tag);
3435                 $tag = str_replace("technorati tag: ", "", $tag);
3436
3437                 return $tag;
3438         }
3439
3440         function get_self_url_prefix() {
3441                 if (strrpos(SELF_URL_PATH, "/") === strlen(SELF_URL_PATH)-1) {
3442                         return substr(SELF_URL_PATH, 0, strlen(SELF_URL_PATH)-1);
3443                 } else {
3444                         return SELF_URL_PATH;
3445                 }
3446         }
3447
3448         /**
3449          * Compute the Mozilla Firefox feed adding URL from server HOST and REQUEST_URI.
3450          *
3451          * @return string The Mozilla Firefox feed adding URL.
3452          */
3453         function add_feed_url() {
3454                 //$url_path = ($_SERVER['HTTPS'] != "on" ? 'http://' :  'https://') . $_SERVER["HTTP_HOST"] . parse_url($_SERVER["REQUEST_URI"], PHP_URL_PATH);
3455
3456                 $url_path = get_self_url_prefix() .
3457                         "/public.php?op=subscribe&feed_url=%s";
3458                 return $url_path;
3459         } // function add_feed_url
3460
3461         function encrypt_password($pass, $salt = '', $mode2 = false) {
3462                 if ($salt && $mode2) {
3463                         return "MODE2:" . hash('sha256', $salt . $pass);
3464                 } else if ($salt) {
3465                         return "SHA1X:" . sha1("$salt:$pass");
3466                 } else {
3467                         return "SHA1:" . sha1($pass);
3468                 }
3469         } // function encrypt_password
3470
3471         function load_filters($feed_id, $owner_uid, $action_id = false) {
3472                 $filters = array();
3473
3474                 $cat_id = (int)getFeedCategory($feed_id);
3475
3476                 if ($cat_id == 0)
3477                         $null_cat_qpart = "cat_id IS NULL OR";
3478                 else
3479                         $null_cat_qpart = "";
3480
3481                 $result = db_query("SELECT * FROM ttrss_filters2 WHERE
3482                         owner_uid = $owner_uid AND enabled = true ORDER BY order_id, title");
3483
3484                 $check_cats = join(",", array_merge(
3485                         getParentCategories($cat_id, $owner_uid),
3486                         array($cat_id)));
3487
3488                 while ($line = db_fetch_assoc($result)) {
3489                         $filter_id = $line["id"];
3490
3491                         $result2 = db_query("SELECT
3492                                 r.reg_exp, r.inverse, r.feed_id, r.cat_id, r.cat_filter, t.name AS type_name
3493                                 FROM ttrss_filters2_rules AS r,
3494                                 ttrss_filter_types AS t
3495                                 WHERE
3496                                         ($null_cat_qpart (cat_id IS NULL AND cat_filter = false) OR cat_id IN ($check_cats)) AND
3497                                         (feed_id IS NULL OR feed_id = '$feed_id') AND
3498                                         filter_type = t.id AND filter_id = '$filter_id'");
3499
3500                         $rules = array();
3501                         $actions = array();
3502
3503                         while ($rule_line = db_fetch_assoc($result2)) {
3504 #                               print_r($rule_line);
3505
3506                                 $rule = array();
3507                                 $rule["reg_exp"] = $rule_line["reg_exp"];
3508                                 $rule["type"] = $rule_line["type_name"];
3509                                 $rule["inverse"] = sql_bool_to_bool($rule_line["inverse"]);
3510
3511                                 array_push($rules, $rule);
3512                         }
3513
3514                         $result2 = db_query("SELECT a.action_param,t.name AS type_name
3515                                 FROM ttrss_filters2_actions AS a,
3516                                 ttrss_filter_actions AS t
3517                                 WHERE
3518                                         action_id = t.id AND filter_id = '$filter_id'");
3519
3520                         while ($action_line = db_fetch_assoc($result2)) {
3521 #                               print_r($action_line);
3522
3523                                 $action = array();
3524                                 $action["type"] = $action_line["type_name"];
3525                                 $action["param"] = $action_line["action_param"];
3526
3527                                 array_push($actions, $action);
3528                         }
3529
3530
3531                         $filter = array();
3532                         $filter["match_any_rule"] = sql_bool_to_bool($line["match_any_rule"]);
3533                         $filter["inverse"] = sql_bool_to_bool($line["inverse"]);
3534                         $filter["rules"] = $rules;
3535                         $filter["actions"] = $actions;
3536
3537                         if (count($rules) > 0 && count($actions) > 0) {
3538                                 array_push($filters, $filter);
3539                         }
3540                 }
3541
3542                 return $filters;
3543         }
3544
3545         function get_score_pic($score) {
3546                 if ($score > 100) {
3547                         return "score_high.png";
3548                 } else if ($score > 0) {
3549                         return "score_half_high.png";
3550                 } else if ($score < -100) {
3551                         return "score_low.png";
3552                 } else if ($score < 0) {
3553                         return "score_half_low.png";
3554                 } else {
3555                         return "score_neutral.png";
3556                 }
3557         }
3558
3559         function feed_has_icon($id) {
3560                 return is_file(ICONS_DIR . "/$id.ico") && filesize(ICONS_DIR . "/$id.ico") > 0;
3561         }
3562
3563         function init_plugins() {
3564                 PluginHost::getInstance()->load(PLUGINS, PluginHost::KIND_ALL);
3565
3566                 return true;
3567         }
3568
3569         function format_tags_string($tags, $id) {
3570                 if (!is_array($tags) || count($tags) == 0) {
3571                         return __("no tags");
3572                 } else {
3573                         $maxtags = min(5, count($tags));
3574
3575                         for ($i = 0; $i < $maxtags; $i++) {
3576                                 $tags_str .= "<a class=\"tag\" href=\"#\" onclick=\"viewfeed('".$tags[$i]."')\">" . $tags[$i] . "</a>, ";
3577                         }
3578
3579                         $tags_str = mb_substr($tags_str, 0, mb_strlen($tags_str)-2);
3580
3581                         if (count($tags) > $maxtags)
3582                                 $tags_str .= ", &hellip;";
3583
3584                         return $tags_str;
3585                 }
3586         }
3587
3588         function format_article_labels($labels, $id) {
3589
3590                 if (!is_array($labels)) return '';
3591
3592                 $labels_str = "";
3593
3594                 foreach ($labels as $l) {
3595                         $labels_str .= sprintf("<span class='hlLabelRef'
3596                                 style='color : %s; background-color : %s'>%s</span>",
3597                                         $l[2], $l[3], $l[1]);
3598                         }
3599
3600                 return $labels_str;
3601
3602         }
3603
3604         function format_article_note($id, $note, $allow_edit = true) {
3605
3606                 $str = "<div class='articleNote'        onclick=\"editArticleNote($id)\">
3607                         <div class='noteEdit' onclick=\"editArticleNote($id)\">".
3608                         ($allow_edit ? __('(edit note)') : "")."</div>$note</div>";
3609
3610                 return $str;
3611         }
3612
3613
3614         function get_feed_category($feed_cat, $parent_cat_id = false) {
3615                 if ($parent_cat_id) {
3616                         $parent_qpart = "parent_cat = '$parent_cat_id'";
3617                         $parent_insert = "'$parent_cat_id'";
3618                 } else {
3619                         $parent_qpart = "parent_cat IS NULL";
3620                         $parent_insert = "NULL";
3621                 }
3622
3623                 $result = db_query(
3624                         "SELECT id FROM ttrss_feed_categories
3625                         WHERE $parent_qpart AND title = '$feed_cat' AND owner_uid = ".$_SESSION["uid"]);
3626
3627                 if (db_num_rows($result) == 0) {
3628                         return false;
3629                 } else {
3630                         return db_fetch_result($result, 0, "id");
3631                 }
3632         }
3633
3634         function add_feed_category($feed_cat, $parent_cat_id = false) {
3635
3636                 if (!$feed_cat) return false;
3637
3638                 db_query("BEGIN");
3639
3640                 if ($parent_cat_id) {
3641                         $parent_qpart = "parent_cat = '$parent_cat_id'";
3642                         $parent_insert = "'$parent_cat_id'";
3643                 } else {
3644                         $parent_qpart = "parent_cat IS NULL";
3645                         $parent_insert = "NULL";
3646                 }
3647
3648                 $feed_cat = mb_substr($feed_cat, 0, 250);
3649
3650                 $result = db_query(
3651                         "SELECT id FROM ttrss_feed_categories
3652                         WHERE $parent_qpart AND title = '$feed_cat' AND owner_uid = ".$_SESSION["uid"]);
3653
3654                 if (db_num_rows($result) == 0) {
3655
3656                         $result = db_query(
3657                                 "INSERT INTO ttrss_feed_categories (owner_uid,title,parent_cat)
3658                                 VALUES ('".$_SESSION["uid"]."', '$feed_cat', $parent_insert)");
3659
3660                         db_query("COMMIT");
3661
3662                         return true;
3663                 }
3664
3665                 return false;
3666         }
3667
3668         function getArticleFeed($id) {
3669                 $result = db_query("SELECT feed_id FROM ttrss_user_entries
3670                         WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]);
3671
3672                 if (db_num_rows($result) != 0) {
3673                         return db_fetch_result($result, 0, "feed_id");
3674                 } else {
3675                         return 0;
3676                 }
3677         }
3678
3679         /**
3680          * Fixes incomplete URLs by prepending "http://".
3681          * Also replaces feed:// with http://, and
3682          * prepends a trailing slash if the url is a domain name only.
3683          *
3684          * @param string $url Possibly incomplete URL
3685          *
3686          * @return string Fixed URL.
3687          */
3688         function fix_url($url) {
3689                 if (strpos($url, '://') === false) {
3690                         $url = 'http://' . $url;
3691                 } else if (substr($url, 0, 5) == 'feed:') {
3692                         $url = 'http:' . substr($url, 5);
3693                 }
3694
3695                 //prepend slash if the URL has no slash in it
3696                 // "http://www.example" -> "http://www.example/"
3697                 if (strpos($url, '/', strpos($url, ':') + 3) === false) {
3698                         $url .= '/';
3699                 }
3700
3701                 if ($url != "http:///")
3702                         return $url;
3703                 else
3704                         return '';
3705         }
3706
3707         function validate_feed_url($url) {
3708                 $parts = parse_url($url);
3709
3710                 return ($parts['scheme'] == 'http' || $parts['scheme'] == 'feed' || $parts['scheme'] == 'https');
3711
3712         }
3713
3714         function get_article_enclosures($id) {
3715
3716                 $query = "SELECT * FROM ttrss_enclosures
3717                         WHERE post_id = '$id' AND content_url != ''";
3718
3719                 $rv = array();
3720
3721                 $result = db_query($query);
3722
3723                 if (db_num_rows($result) > 0) {
3724                         while ($line = db_fetch_assoc($result)) {
3725                                 array_push($rv, $line);
3726                         }
3727                 }
3728
3729                 return $rv;
3730         }
3731
3732         function save_email_address($email) {
3733                 // FIXME: implement persistent storage of emails
3734
3735                 if (!$_SESSION['stored_emails'])
3736                         $_SESSION['stored_emails'] = array();
3737
3738                 if (!in_array($email, $_SESSION['stored_emails']))
3739                         array_push($_SESSION['stored_emails'], $email);
3740         }
3741
3742
3743         function get_feed_access_key($feed_id, $is_cat, $owner_uid = false) {
3744
3745                 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
3746
3747                 $sql_is_cat = bool_to_sql_bool($is_cat);
3748
3749                 $result = db_query("SELECT access_key FROM ttrss_access_keys
3750                         WHERE feed_id = '$feed_id'      AND is_cat = $sql_is_cat
3751                         AND owner_uid = " . $owner_uid);
3752
3753                 if (db_num_rows($result) == 1) {
3754                         return db_fetch_result($result, 0, "access_key");
3755                 } else {
3756                         $key = db_escape_string(uniqid(base_convert(rand(), 10, 36)));
3757
3758                         $result = db_query("INSERT INTO ttrss_access_keys
3759                                 (access_key, feed_id, is_cat, owner_uid)
3760                                 VALUES ('$key', '$feed_id', $sql_is_cat, '$owner_uid')");
3761
3762                         return $key;
3763                 }
3764                 return false;
3765         }
3766
3767         function get_feeds_from_html($url, $content)
3768         {
3769                 $url     = fix_url($url);
3770                 $baseUrl = substr($url, 0, strrpos($url, '/') + 1);
3771
3772                 libxml_use_internal_errors(true);
3773
3774                 $doc = new DOMDocument();
3775                 $doc->loadHTML($content);
3776                 $xpath = new DOMXPath($doc);
3777                 $entries = $xpath->query('/html/head/link[@rel="alternate"]');
3778                 $feedUrls = array();
3779                 foreach ($entries as $entry) {
3780                         if ($entry->hasAttribute('href')) {
3781                                 $title = $entry->getAttribute('title');
3782                                 if ($title == '') {
3783                                         $title = $entry->getAttribute('type');
3784                                 }
3785                                 $feedUrl = rewrite_relative_url(
3786                                         $baseUrl, $entry->getAttribute('href')
3787                                 );
3788                                 $feedUrls[$feedUrl] = $title;
3789                         }
3790                 }
3791                 return $feedUrls;
3792         }
3793
3794         function is_html($content) {
3795                 return preg_match("/<html|DOCTYPE html/i", substr($content, 0, 20)) !== 0;
3796         }
3797
3798         function url_is_html($url, $login = false, $pass = false) {
3799                 return is_html(fetch_file_contents($url, false, $login, $pass));
3800         }
3801
3802         function print_label_select($name, $value, $attributes = "") {
3803
3804                 $result = db_query("SELECT caption FROM ttrss_labels2
3805                         WHERE owner_uid = '".$_SESSION["uid"]."' ORDER BY caption");
3806
3807                 print "<select default=\"$value\" name=\"" . htmlspecialchars($name) .
3808                         "\" $attributes onchange=\"labelSelectOnChange(this)\" >";
3809
3810                 while ($line = db_fetch_assoc($result)) {
3811
3812                         $issel = ($line["caption"] == $value) ? "selected=\"1\"" : "";
3813
3814                         print "<option value=\"".htmlspecialchars($line["caption"])."\"
3815                                 $issel>" . htmlspecialchars($line["caption"]) . "</option>";
3816
3817                 }
3818
3819 #               print "<option value=\"ADD_LABEL\">" .__("Add label...") . "</option>";
3820
3821                 print "</select>";
3822
3823
3824         }
3825
3826         function format_article_enclosures($id, $always_display_enclosures,
3827                                         $article_content, $hide_images = false) {
3828
3829                 $result = get_article_enclosures($id);
3830                 $rv = '';
3831
3832                 if (count($result) > 0) {
3833
3834                         $entries_html = array();
3835                         $entries = array();
3836                         $entries_inline = array();
3837
3838                         foreach ($result as $line) {
3839
3840                                 $url = $line["content_url"];
3841                                 $ctype = $line["content_type"];
3842                                 $title = $line["title"];
3843
3844                                 if (!$ctype) $ctype = __("unknown type");
3845
3846                                 $filename = substr($url, strrpos($url, "/")+1);
3847
3848                                 $player = format_inline_player($url, $ctype);
3849
3850                                 if ($player) array_push($entries_inline, $player);
3851
3852 #                               $entry .= " <a target=\"_blank\" href=\"" . htmlspecialchars($url) . "\">" .
3853 #                                       $filename . " (" . $ctype . ")" . "</a>";
3854
3855                                 $entry = "<div onclick=\"window.open('".htmlspecialchars($url)."')\"
3856                                         dojoType=\"dijit.MenuItem\">$filename ($ctype)</div>";
3857
3858                                 array_push($entries_html, $entry);
3859
3860                                 $entry = array();
3861
3862                                 $entry["type"] = $ctype;
3863                                 $entry["filename"] = $filename;
3864                                 $entry["url"] = $url;
3865                                 $entry["title"] = $title;
3866
3867                                 array_push($entries, $entry);
3868                         }
3869
3870                         if ($_SESSION['uid'] && !get_pref("STRIP_IMAGES") && !$_SESSION["bw_limit"]) {
3871                                 if ($always_display_enclosures ||
3872                                                         !preg_match("/<img/i", $article_content)) {
3873
3874                                         foreach ($entries as $entry) {
3875
3876                                                 if (preg_match("/image/", $entry["type"]) ||
3877                                                                 preg_match("/\.(jpg|png|gif|bmp)/i", $entry["filename"])) {
3878
3879                                                                 if (!$hide_images) {
3880                                                                         $rv .= "<p><img
3881                                                                         alt=\"".htmlspecialchars($entry["filename"])."\"
3882                                                                         src=\"" .htmlspecialchars($entry["url"]) . "\"/></p>";
3883                                                                 } else {
3884                                                                         $rv .= "<p><a target=\"_blank\"
3885                                                                         href=\"".htmlspecialchars($entry["url"])."\"
3886                                                                         >" .htmlspecialchars($entry["url"]) . "</a></p>";
3887                                                                 }
3888
3889                                                                 if ($entry['title']) {
3890                                                                         $rv.= "<div class=\"enclosure_title\">${entry['title']}</div>";
3891                                                                 }
3892                                                 }
3893                                         }
3894                                 }
3895                         }
3896
3897                         if (count($entries_inline) > 0) {
3898                                 $rv .= "<hr clear='both'/>";
3899                                 foreach ($entries_inline as $entry) { $rv .= $entry; };
3900                                 $rv .= "<hr clear='both'/>";
3901                         }
3902
3903                         $rv .= "<select class=\"attachments\" onchange=\"openSelectedAttachment(this)\">".
3904                                 "<option value=''>" . __('Attachments')."</option>";
3905
3906                         foreach ($entries as $entry) {
3907                                 if ($entry["title"])
3908                                         $title = "&mdash; " . truncate_string($entry["title"], 30);
3909                                 else
3910                                         $title = "";
3911
3912                                 $rv .= "<option value=\"".htmlspecialchars($entry["url"])."\">" . htmlspecialchars($entry["filename"]) . "$title</option>";
3913
3914                         };
3915
3916                         $rv .= "</select>";
3917                 }
3918
3919                 return $rv;
3920         }
3921
3922         function getLastArticleId() {
3923                 $result = db_query("SELECT MAX(ref_id) AS id FROM ttrss_user_entries
3924                         WHERE owner_uid = " . $_SESSION["uid"]);
3925
3926                 if (db_num_rows($result) == 1) {
3927                         return db_fetch_result($result, 0, "id");
3928                 } else {
3929                         return -1;
3930                 }
3931         }
3932
3933         function build_url($parts) {
3934                 return $parts['scheme'] . "://" . $parts['host'] . $parts['path'];
3935         }
3936
3937         /**
3938          * Converts a (possibly) relative URL to a absolute one.
3939          *
3940          * @param string $url     Base URL (i.e. from where the document is)
3941          * @param string $rel_url Possibly relative URL in the document
3942          *
3943          * @return string Absolute URL
3944          */
3945         function rewrite_relative_url($url, $rel_url) {
3946                 if (strpos($rel_url, ":") !== false) {
3947                         return $rel_url;
3948                 } else if (strpos($rel_url, "://") !== false) {
3949                         return $rel_url;
3950                 } else if (strpos($rel_url, "//") === 0) {
3951                         # protocol-relative URL (rare but they exist)
3952                         return $rel_url;
3953                 } else if (strpos($rel_url, "/") === 0)
3954                 {
3955                         $parts = parse_url($url);
3956                         $parts['path'] = $rel_url;
3957
3958                         return build_url($parts);
3959
3960                 } else {
3961                         $parts = parse_url($url);
3962                         if (!isset($parts['path'])) {
3963                                 $parts['path'] = '/';
3964                         }
3965                         $dir = $parts['path'];
3966                         if (substr($dir, -1) !== '/') {
3967                                 $dir = dirname($parts['path']);
3968                                 $dir !== '/' && $dir .= '/';
3969                         }
3970                         $parts['path'] = $dir . $rel_url;
3971
3972                         return build_url($parts);
3973                 }
3974         }
3975
3976         function sphinx_search($query, $offset = 0, $limit = 30) {
3977                 require_once 'lib/sphinxapi.php';
3978
3979                 $sphinxClient = new SphinxClient();
3980
3981                 $sphinxpair = explode(":", SPHINX_SERVER, 2);
3982
3983                 $sphinxClient->SetServer($sphinxpair[0], (int)$sphinxpair[1]);
3984                 $sphinxClient->SetConnectTimeout(1);
3985
3986                 $sphinxClient->SetFieldWeights(array('title' => 70, 'content' => 30,
3987                         'feed_title' => 20));
3988
3989                 $sphinxClient->SetMatchMode(SPH_MATCH_EXTENDED2);
3990                 $sphinxClient->SetRankingMode(SPH_RANK_PROXIMITY_BM25);
3991                 $sphinxClient->SetLimits($offset, $limit, 1000);
3992                 $sphinxClient->SetArrayResult(false);
3993                 $sphinxClient->SetFilter('owner_uid', array($_SESSION['uid']));
3994
3995                 $result = $sphinxClient->Query($query, SPHINX_INDEX);
3996
3997                 $ids = array();
3998
3999                 if (is_array($result['matches'])) {
4000                         foreach (array_keys($result['matches']) as $int_id) {
4001                                 $ref_id = $result['matches'][$int_id]['attrs']['ref_id'];
4002                                 array_push($ids, $ref_id);
4003                         }
4004                 }
4005
4006                 return $ids;
4007         }
4008
4009         function cleanup_tags($days = 14, $limit = 1000) {
4010
4011                 if (DB_TYPE == "pgsql") {
4012                         $interval_query = "date_updated < NOW() - INTERVAL '$days days'";
4013                 } else if (DB_TYPE == "mysql") {
4014                         $interval_query = "date_updated < DATE_SUB(NOW(), INTERVAL $days DAY)";
4015                 }
4016
4017                 $tags_deleted = 0;
4018
4019                 while ($limit > 0) {
4020                         $limit_part = 500;
4021
4022                         $query = "SELECT ttrss_tags.id AS id
4023                                 FROM ttrss_tags, ttrss_user_entries, ttrss_entries
4024                                 WHERE post_int_id = int_id AND $interval_query AND
4025                                 ref_id = ttrss_entries.id AND tag_cache != '' LIMIT $limit_part";
4026
4027                         $result = db_query($query);
4028
4029                         $ids = array();
4030
4031                         while ($line = db_fetch_assoc($result)) {
4032                                 array_push($ids, $line['id']);
4033                         }
4034
4035                         if (count($ids) > 0) {
4036                                 $ids = join(",", $ids);
4037
4038                                 $tmp_result = db_query("DELETE FROM ttrss_tags WHERE id IN ($ids)");
4039                                 $tags_deleted += db_affected_rows($tmp_result);
4040                         } else {
4041                                 break;
4042                         }
4043
4044                         $limit -= $limit_part;
4045                 }
4046
4047                 return $tags_deleted;
4048         }
4049
4050         function print_user_stylesheet() {
4051                 $value = get_pref('USER_STYLESHEET');
4052
4053                 if ($value) {
4054                         print "<style type=\"text/css\">";
4055                         print str_replace("<br/>", "\n", $value);
4056                         print "</style>";
4057                 }
4058
4059         }
4060
4061         function filter_to_sql($filter, $owner_uid) {
4062                 $query = array();
4063
4064                 if (DB_TYPE == "pgsql")
4065                         $reg_qpart = "~";
4066                 else
4067                         $reg_qpart = "REGEXP";
4068
4069                 foreach ($filter["rules"] AS $rule) {
4070                         $rule['reg_exp'] = str_replace('/', '\/', $rule["reg_exp"]);
4071                         $regexp_valid = preg_match('/' . $rule['reg_exp'] . '/',
4072                                 $rule['reg_exp']) !== FALSE;
4073
4074                         if ($regexp_valid) {
4075
4076                                 $rule['reg_exp'] = db_escape_string($rule['reg_exp']);
4077
4078                                         switch ($rule["type"]) {
4079                                         case "title":
4080                                                 $qpart = "LOWER(ttrss_entries.title) $reg_qpart LOWER('".
4081                                                         $rule['reg_exp'] . "')";
4082                                                 break;
4083                                         case "content":
4084                                                 $qpart = "LOWER(ttrss_entries.content) $reg_qpart LOWER('".
4085                                                         $rule['reg_exp'] . "')";
4086                                                 break;
4087                                         case "both":
4088                                                 $qpart = "LOWER(ttrss_entries.title) $reg_qpart LOWER('".
4089                                                         $rule['reg_exp'] . "') OR LOWER(" .
4090                                                         "ttrss_entries.content) $reg_qpart LOWER('" . $rule['reg_exp'] . "')";
4091                                                 break;
4092                                         case "tag":
4093                                                 $qpart = "LOWER(ttrss_user_entries.tag_cache) $reg_qpart LOWER('".
4094                                                         $rule['reg_exp'] . "')";
4095                                                 break;
4096                                         case "link":
4097                                                 $qpart = "LOWER(ttrss_entries.link) $reg_qpart LOWER('".
4098                                                         $rule['reg_exp'] . "')";
4099                                                 break;
4100                                         case "author":
4101                                                 $qpart = "LOWER(ttrss_entries.author) $reg_qpart LOWER('".
4102                                                         $rule['reg_exp'] . "')";
4103                                                 break;
4104                                 }
4105
4106                                 if (isset($rule['inverse'])) $qpart = "NOT ($qpart)";
4107
4108                                 if (isset($rule["feed_id"]) && $rule["feed_id"] > 0) {
4109                                         $qpart .= " AND feed_id = " . db_escape_string($rule["feed_id"]);
4110                                 }
4111
4112                                 if (isset($rule["cat_id"])) {
4113
4114                                         if ($rule["cat_id"] > 0) {
4115                                                 $children = getChildCategories($rule["cat_id"], $owner_uid);
4116                                                 array_push($children, $rule["cat_id"]);
4117
4118                                                 $children = join(",", $children);
4119
4120                                                 $cat_qpart = "cat_id IN ($children)";
4121                                         } else {
4122                                                 $cat_qpart = "cat_id IS NULL";
4123                                         }
4124
4125                                         $qpart .= " AND $cat_qpart";
4126                                 }
4127
4128                                 $qpart .= " AND feed_id IS NOT NULL";
4129
4130                                 array_push($query, "($qpart)");
4131
4132                         }
4133                 }
4134
4135                 if (count($query) > 0) {
4136                         $fullquery = "(" . join($filter["match_any_rule"] ? "OR" : "AND", $query) . ")";
4137                 } else {
4138                         $fullquery = "(false)";
4139                 }
4140
4141                 if ($filter['inverse']) $fullquery = "(NOT $fullquery)";
4142
4143                 return $fullquery;
4144         }
4145
4146         if (!function_exists('gzdecode')) {
4147                 function gzdecode($string) { // no support for 2nd argument
4148                         return file_get_contents('compress.zlib://data:who/cares;base64,'.
4149                                 base64_encode($string));
4150                 }
4151         }
4152
4153         function get_random_bytes($length) {
4154                 if (function_exists('openssl_random_pseudo_bytes')) {
4155                         return openssl_random_pseudo_bytes($length);
4156                 } else {
4157                         $output = "";
4158
4159                         for ($i = 0; $i < $length; $i++)
4160                                 $output .= chr(mt_rand(0, 255));
4161
4162                         return $output;
4163                 }
4164         }
4165
4166         function read_stdin() {
4167                 $fp = fopen("php://stdin", "r");
4168
4169                 if ($fp) {
4170                         $line = trim(fgets($fp));
4171                         fclose($fp);
4172                         return $line;
4173                 }
4174
4175                 return null;
4176         }
4177
4178         function tmpdirname($path, $prefix) {
4179                 // Use PHP's tmpfile function to create a temporary
4180                 // directory name. Delete the file and keep the name.
4181                 $tempname = tempnam($path,$prefix);
4182                 if (!$tempname)
4183                         return false;
4184
4185                 if (!unlink($tempname))
4186                         return false;
4187
4188        return $tempname;
4189         }
4190
4191         function getFeedCategory($feed) {
4192                 $result = db_query("SELECT cat_id FROM ttrss_feeds
4193                         WHERE id = '$feed'");
4194
4195                 if (db_num_rows($result) > 0) {
4196                         return db_fetch_result($result, 0, "cat_id");
4197                 } else {
4198                         return false;
4199                 }
4200
4201         }
4202
4203         function implements_interface($class, $interface) {
4204                 return in_array($interface, class_implements($class));
4205         }
4206
4207         function geturl($url, $depth = 0){
4208
4209                 if ($depth == 20) return $url;
4210
4211                 if (!function_exists('curl_init'))
4212                         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);
4213
4214                 $curl = curl_init();
4215                 $header[0] = "Accept: text/xml,application/xml,application/xhtml+xml,";
4216                 $header[0] .= "text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5";
4217                 $header[] = "Cache-Control: max-age=0";
4218                 $header[] = "Connection: keep-alive";
4219                 $header[] = "Keep-Alive: 300";
4220                 $header[] = "Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7";
4221                 $header[] = "Accept-Language: en-us,en;q=0.5";
4222                 $header[] = "Pragma: ";
4223
4224                 curl_setopt($curl, CURLOPT_URL, $url);
4225                 curl_setopt($curl, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows NT 5.1; rv:5.0) Gecko/20100101 Firefox/5.0 Firefox/5.0');
4226                 curl_setopt($curl, CURLOPT_HTTPHEADER, $header);
4227                 curl_setopt($curl, CURLOPT_HEADER, true);
4228                 curl_setopt($curl, CURLOPT_REFERER, $url);
4229                 curl_setopt($curl, CURLOPT_ENCODING, 'gzip,deflate');
4230                 curl_setopt($curl, CURLOPT_AUTOREFERER, true);
4231                 curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
4232                 //curl_setopt($curl, CURLOPT_FOLLOWLOCATION, true); //CURLOPT_FOLLOWLOCATION Disabled...
4233                 curl_setopt($curl, CURLOPT_TIMEOUT, 60);
4234                 curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
4235
4236                 if (defined('_CURL_HTTP_PROXY')) {
4237                         curl_setopt($curl, CURLOPT_PROXY, _CURL_HTTP_PROXY);
4238                 }
4239
4240                 if ((OPENSSL_VERSION_NUMBER >= 0x0090808f) && (OPENSSL_VERSION_NUMBER < 0x10000000)) {
4241                         curl_setopt($curl, CURLOPT_SSLVERSION, 3);
4242                 }
4243
4244                 $html = curl_exec($curl);
4245
4246                 $status = curl_getinfo($curl);
4247
4248                 if($status['http_code']!=200){
4249                         if($status['http_code'] == 301 || $status['http_code'] == 302) {
4250                                 curl_close($curl);
4251                                 list($header) = explode("\r\n\r\n", $html, 2);
4252                                 $matches = array();
4253                                 preg_match("/(Location:|URI:)[^(\n)]*/", $header, $matches);
4254                                 $url = trim(str_replace($matches[1],"",$matches[0]));
4255                                 $url_parsed = parse_url($url);
4256                                 return (isset($url_parsed))? geturl($url, $depth + 1):'';
4257                         }
4258
4259                         global $fetch_last_error;
4260
4261                         $fetch_last_error = curl_errno($curl) . " " . curl_error($curl);
4262                         curl_close($curl);
4263
4264 #                       $oline='';
4265 #                       foreach($status as $key=>$eline){$oline.='['.$key.']'.$eline.' ';}
4266 #                       $line =$oline." \r\n ".$url."\r\n-----------------\r\n";
4267 #                       $handle = @fopen('./curl.error.log', 'a');
4268 #                       fwrite($handle, $line);
4269                         return FALSE;
4270                 }
4271                 curl_close($curl);
4272                 return $url;
4273         }
4274
4275         function get_minified_js($files) {
4276                 require_once 'lib/jshrink/Minifier.php';
4277
4278                 $rv = '';
4279
4280                 foreach ($files as $js) {
4281                         if (!isset($_GET['debug'])) {
4282                                 $cached_file = CACHE_DIR . "/js/".basename($js).".js";
4283
4284                                 if (file_exists($cached_file) &&
4285                                                 is_readable($cached_file) &&
4286                                                 filemtime($cached_file) >= filemtime("js/$js.js")) {
4287
4288                                         $rv .= file_get_contents($cached_file);
4289
4290                                 } else {
4291                                         $minified = JShrink\Minifier::minify(file_get_contents("js/$js.js"));
4292                                         file_put_contents($cached_file, $minified);
4293                                         $rv .= $minified;
4294                                 }
4295                         } else {
4296                                 $rv .= file_get_contents("js/$js.js");
4297                         }
4298                 }
4299
4300                 return $rv;
4301         }
4302
4303         function stylesheet_tag($filename) {
4304                 $timestamp = filemtime($filename);
4305
4306                 return "<link rel=\"stylesheet\" type=\"text/css\" href=\"$filename?$timestamp\"/>\n";
4307         }
4308
4309         function javascript_tag($filename) {
4310                 $query = "";
4311
4312                 if (!(strpos($filename, "?") === FALSE)) {
4313                         $query = substr($filename, strpos($filename, "?")+1);
4314                         $filename = substr($filename, 0, strpos($filename, "?"));
4315                 }
4316
4317                 $timestamp = filemtime($filename);
4318
4319                 if ($query) $timestamp .= "&$query";
4320
4321                 return "<script type=\"text/javascript\" charset=\"utf-8\" src=\"$filename?$timestamp\"></script>\n";
4322         }
4323
4324         function calculate_dep_timestamp() {
4325                 $files = array_merge(glob("js/*.js"), glob("css/*.css"));
4326
4327                 $max_ts = -1;
4328
4329                 foreach ($files as $file) {
4330                         if (filemtime($file) > $max_ts) $max_ts = filemtime($file);
4331                 }
4332
4333                 return $max_ts;
4334         }
4335
4336         function T_js_decl($s1, $s2) {
4337                 if ($s1 && $s2) {
4338                         $s1 = preg_replace("/\n/", "", $s1);
4339                         $s2 = preg_replace("/\n/", "", $s2);
4340
4341                         $s1 = preg_replace("/\"/", "\\\"", $s1);
4342                         $s2 = preg_replace("/\"/", "\\\"", $s2);
4343
4344                         return "T_messages[\"$s1\"] = \"$s2\";\n";
4345                 }
4346         }
4347
4348         function init_js_translations() {
4349
4350         print 'var T_messages = new Object();
4351
4352                 function __(msg) {
4353                         if (T_messages[msg]) {
4354                                 return T_messages[msg];
4355                         } else {
4356                                 return msg;
4357                         }
4358                 }
4359
4360                 function ngettext(msg1, msg2, n) {
4361                         return __((parseInt(n) > 1) ? msg2 : msg1);
4362                 }';
4363
4364                 $l10n = _get_reader();
4365
4366                 for ($i = 0; $i < $l10n->total; $i++) {
4367                         $orig = $l10n->get_original_string($i);
4368                         if(strpos($orig, "\000") !== FALSE) { // Plural forms
4369                                 $key = explode(chr(0), $orig);
4370                                 print T_js_decl($key[0], _ngettext($key[0], $key[1], 1)); // Singular
4371                                 print T_js_decl($key[1], _ngettext($key[0], $key[1], 2)); // Plural
4372                         } else {
4373                                 $translation = __($orig);
4374                                 print T_js_decl($orig, $translation);
4375                         }
4376                 }
4377         }
4378
4379         function label_to_feed_id($label) {
4380                 return LABEL_BASE_INDEX - 1 - abs($label);
4381         }
4382
4383         function feed_to_label_id($feed) {
4384                 return LABEL_BASE_INDEX - 1 + abs($feed);
4385         }
4386
4387         function format_libxml_error($error) {
4388                 return T_sprintf("LibXML error %s at line %d (column %d): %s",
4389                                 $error->code, $error->line, $error->column,
4390                                 $error->message);
4391         }
4392
4393 ?>