include/functions.php

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