include/functions.php

   1 <?php
   2         define('EXPECTED_CONFIG_VERSION', 26);
   3         define('SCHEMA_VERSION', 123);
   4
   5         define('LABEL_BASE_INDEX', -1024);
   6         define('PLUGIN_FEED_BASE_INDEX', -128);
   7
   8         define('COOKIE_LIFETIME_LONG', 86400*365);
   9
  10         $fetch_last_error = false;
  11         $fetch_last_error_code = false;
  12         $fetch_last_content_type = false;
  13         $fetch_curl_used = false;
  14         $suppress_debugging = false;
  15
  16         mb_internal_encoding("UTF-8");
  17         date_default_timezone_set('UTC');
  18         if (defined('E_DEPRECATED')) {
  19                 error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);
  20         } else {
  21                 error_reporting(E_ALL & ~E_NOTICE);
  22         }
  23
  24         require_once 'config.php';
  25
  26         /**
  27          * Define a constant if not already defined
  28          *
  29          * @param string $name The constant name.
  30          * @param mixed $value The constant value.
  31          * @access public
  32          * @return boolean True if defined successfully or not.
  33          */
  34         function define_default($name, $value) {
  35                 defined($name) or define($name, $value);
  36         }
  37
  38         ///// Some defaults that you can override in config.php //////
  39
  40         define_default('FEED_FETCH_TIMEOUT', 45);
  41         // How may seconds to wait for response when requesting feed from a site
  42         define_default('FEED_FETCH_NO_CACHE_TIMEOUT', 15);
  43         // How may seconds to wait for response when requesting feed from a
  44         // site when that feed wasn't cached before
  45         define_default('FILE_FETCH_TIMEOUT', 45);
  46         // Default timeout when fetching files from remote sites
  47         define_default('FILE_FETCH_CONNECT_TIMEOUT', 15);
  48         // How many seconds to wait for initial response from website when
  49         // fetching files from remote sites
  50
  51         if (DB_TYPE == "pgsql") {
  52                 define('SUBSTRING_FOR_DATE', 'SUBSTRING_FOR_DATE');
  53         } else {
  54                 define('SUBSTRING_FOR_DATE', 'SUBSTRING');
  55         }
  56
  57         /**
  58          * Return available translations names.
  59          *
  60          * @access public
  61          * @return array A array of available translations.
  62          */
  63         function get_translations() {
  64                 $tr = array(
  65                                         "auto"  => "Detect automatically",
  66                                         "ca_CA" => "Català",
  67                                         "cs_CZ" => "Česky",
  68                                         "en_US" => "English",
  69                                         "es_ES" => "Español",
  70                                         "de_DE" => "Deutsch",
  71                                         "fr_FR" => "Français",
  72                                         "hu_HU" => "Magyar (Hungarian)",
  73                                         "it_IT" => "Italiano",
  74                                         "ja_JP" => "日本語 (Japanese)",
  75                                         "lv_LV" => "Latviešu",
  76                                         "nb_NO" => "Norwegian bokmål",
  77                                         "nl_NL" => "Dutch",
  78                                         "pl_PL" => "Polski",
  79                                         "ru_RU" => "Русский",
  80                                         "pt_BR" => "Portuguese/Brazil",
  81                                         "zh_CN" => "Simplified Chinese",
  82                                         "sv_SE" => "Svenska",
  83                                         "fi_FI" => "Suomi");
  84
  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,SUM(CASE WHEN u1.unread = true THEN 1 ELSE 0 END) AS unread, COUNT(u1.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
1564                                 WHERE ttrss_labels2.owner_uid = $owner_uid GROUP BY ttrss_labels2.id,
1565                                         ttrss_labels2.caption");
1566
1567                 while ($line = db_fetch_assoc($result)) {
1568
1569                         $id = label_to_feed_id($line["id"]);
1570
1571                         $cv = array("id" => $id,
1572                                 "counter" => (int) $line["unread"],
1573                                 "auxcounter" => (int) $line["total"]);
1574
1575                         if ($descriptions)
1576                                 $cv["description"] = $line["caption"];
1577
1578                         array_push($ret_arr, $cv);
1579                 }
1580
1581                 return $ret_arr;
1582         }
1583
1584         function getFeedCounters($active_feed = false) {
1585
1586                 $ret_arr = array();
1587
1588                 $query = "SELECT ttrss_feeds.id,
1589                                 ttrss_feeds.title,
1590                                 ".SUBSTRING_FOR_DATE."(ttrss_feeds.last_updated,1,19) AS last_updated,
1591                                 last_error, value AS count
1592                         FROM ttrss_feeds, ttrss_counters_cache
1593                         WHERE ttrss_feeds.owner_uid = ".$_SESSION["uid"]."
1594                                 AND ttrss_counters_cache.owner_uid = ttrss_feeds.owner_uid
1595                                 AND ttrss_counters_cache.feed_id = id";
1596
1597                 $result = db_query($query);
1598                 $fctrs_modified = false;
1599
1600                 while ($line = db_fetch_assoc($result)) {
1601
1602                         $id = $line["id"];
1603                         $count = $line["count"];
1604                         $last_error = htmlspecialchars($line["last_error"]);
1605
1606                         $last_updated = make_local_datetime($line['last_updated'], false);
1607
1608                         $has_img = feed_has_icon($id);
1609
1610                         if (date('Y') - date('Y', strtotime($line['last_updated'])) > 2)
1611                                 $last_updated = '';
1612
1613                         $cv = array("id" => $id,
1614                                 "updated" => $last_updated,
1615                                 "counter" => (int) $count,
1616                                 "has_img" => (int) $has_img);
1617
1618                         if ($last_error)
1619                                 $cv["error"] = $last_error;
1620
1621 //                      if (get_pref('EXTENDED_FEEDLIST'))
1622 //                              $cv["xmsg"] = getFeedArticles($id)." ".__("total");
1623
1624                         if ($active_feed && $id == $active_feed)
1625                                 $cv["title"] = truncate_string($line["title"], 30);
1626
1627                         array_push($ret_arr, $cv);
1628
1629                 }
1630
1631                 return $ret_arr;
1632         }
1633
1634         function get_pgsql_version() {
1635                 $result = db_query("SELECT version() AS version");
1636                 $version = explode(" ", db_fetch_result($result, 0, "version"));
1637                 return $version[1];
1638         }
1639
1640         /**
1641          * @return array (code => Status code, message => error message if available)
1642          *
1643          *                 0 - OK, Feed already exists
1644          *                 1 - OK, Feed added
1645          *                 2 - Invalid URL
1646          *                 3 - URL content is HTML, no feeds available
1647          *                 4 - URL content is HTML which contains multiple feeds.
1648          *                     Here you should call extractfeedurls in rpc-backend
1649          *                     to get all possible feeds.
1650          *                 5 - Couldn't download the URL content.
1651          *                 6 - Content is an invalid XML.
1652          */
1653         function subscribe_to_feed($url, $cat_id = 0,
1654                         $auth_login = '', $auth_pass = '') {
1655
1656                 global $fetch_last_error;
1657
1658                 require_once "include/rssfuncs.php";
1659
1660                 $url = fix_url($url);
1661
1662                 if (!$url || !validate_feed_url($url)) return array("code" => 2);
1663
1664                 $contents = @fetch_file_contents($url, false, $auth_login, $auth_pass);
1665
1666                 if (!$contents) {
1667                         return array("code" => 5, "message" => $fetch_last_error);
1668                 }
1669
1670                 if (is_html($contents)) {
1671                         $feedUrls = get_feeds_from_html($url, $contents);
1672
1673                         if (count($feedUrls) == 0) {
1674                                 return array("code" => 3);
1675                         } else if (count($feedUrls) > 1) {
1676                                 return array("code" => 4, "feeds" => $feedUrls);
1677                         }
1678                         //use feed url as new URL
1679                         $url = key($feedUrls);
1680                 }
1681
1682                 /* libxml_use_internal_errors(true);
1683                 $doc = new DOMDocument();
1684                 $doc->loadXML($contents);
1685                 $error = libxml_get_last_error();
1686                 libxml_clear_errors();
1687
1688                 if ($error) {
1689                         $error_message = format_libxml_error($error);
1690
1691                         return array("code" => 6, "message" => $error_message);
1692                 } */
1693
1694                 if ($cat_id == "0" || !$cat_id) {
1695                         $cat_qpart = "NULL";
1696                 } else {
1697                         $cat_qpart = "'$cat_id'";
1698                 }
1699
1700                 $result = db_query(
1701                         "SELECT id FROM ttrss_feeds
1702                         WHERE feed_url = '$url' AND owner_uid = ".$_SESSION["uid"]);
1703
1704                 if (strlen(FEED_CRYPT_KEY) > 0) {
1705                         require_once "crypt.php";
1706                         $auth_pass = substr(encrypt_string($auth_pass), 0, 250);
1707                         $auth_pass_encrypted = 'true';
1708                 } else {
1709                         $auth_pass_encrypted = 'false';
1710                 }
1711
1712                 $auth_pass = db_escape_string($auth_pass);
1713
1714                 if (db_num_rows($result) == 0) {
1715                         $result = db_query(
1716                                 "INSERT INTO ttrss_feeds
1717                                         (owner_uid,feed_url,title,cat_id, auth_login,auth_pass,update_method,auth_pass_encrypted)
1718                                 VALUES ('".$_SESSION["uid"]."', '$url',
1719                                 '[Unknown]', $cat_qpart, '$auth_login', '$auth_pass', 0, $auth_pass_encrypted)");
1720
1721                         $result = db_query(
1722                                 "SELECT id FROM ttrss_feeds WHERE feed_url = '$url'
1723                                         AND owner_uid = " . $_SESSION["uid"]);
1724
1725                         $feed_id = db_fetch_result($result, 0, "id");
1726
1727                         if ($feed_id) {
1728                                 update_rss_feed($feed_id, true);
1729                         }
1730
1731                         return array("code" => 1);
1732                 } else {
1733                         return array("code" => 0);
1734                 }
1735         }
1736
1737         function print_feed_select($id, $default_id = "",
1738                 $attributes = "", $include_all_feeds = true,
1739                 $root_id = false, $nest_level = 0) {
1740
1741                 if (!$root_id) {
1742                         print "<select id=\"$id\" name=\"$id\" $attributes>";
1743                         if ($include_all_feeds) {
1744                                 $is_selected = ("0" == $default_id) ? "selected=\"1\"" : "";
1745                                 print "<option $is_selected value=\"0\">".__('All feeds')."</option>";
1746                         }
1747                 }
1748
1749                 if (get_pref('ENABLE_FEED_CATS')) {
1750
1751                         if ($root_id)
1752                                 $parent_qpart = "parent_cat = '$root_id'";
1753                         else
1754                                 $parent_qpart = "parent_cat IS NULL";
1755
1756                         $result = db_query("SELECT id,title,
1757                                 (SELECT COUNT(id) FROM ttrss_feed_categories AS c2 WHERE
1758                                         c2.parent_cat = ttrss_feed_categories.id) AS num_children
1759                                 FROM ttrss_feed_categories
1760                                 WHERE owner_uid = ".$_SESSION["uid"]." AND $parent_qpart ORDER BY title");
1761
1762                         while ($line = db_fetch_assoc($result)) {
1763
1764                                 for ($i = 0; $i < $nest_level; $i++)
1765                                         $line["title"] = " - " . $line["title"];
1766
1767                                 $is_selected = ("CAT:".$line["id"] == $default_id) ? "selected=\"1\"" : "";
1768
1769                                 printf("<option $is_selected value='CAT:%d'>%s</option>",
1770                                         $line["id"], htmlspecialchars($line["title"]));
1771
1772                                 if ($line["num_children"] > 0)
1773                                         print_feed_select($id, $default_id, $attributes,
1774                                                 $include_all_feeds, $line["id"], $nest_level+1);
1775
1776                                 $feed_result = db_query("SELECT id,title FROM ttrss_feeds
1777                                         WHERE cat_id = '".$line["id"]."' AND owner_uid = ".$_SESSION["uid"] . " ORDER BY title");
1778
1779                                 while ($fline = db_fetch_assoc($feed_result)) {
1780                                         $is_selected = ($fline["id"] == $default_id) ? "selected=\"1\"" : "";
1781
1782                                         $fline["title"] = " + " . $fline["title"];
1783
1784                                         for ($i = 0; $i < $nest_level; $i++)
1785                                                 $fline["title"] = " - " . $fline["title"];
1786
1787                                         printf("<option $is_selected value='%d'>%s</option>",
1788                                                 $fline["id"], htmlspecialchars($fline["title"]));
1789                                 }
1790                         }
1791
1792                         if (!$root_id) {
1793                                 $default_is_cat = ($default_id == "CAT:0");
1794                                 $is_selected = $default_is_cat ? "selected=\"1\"" : "";
1795
1796                                 printf("<option $is_selected value='CAT:0'>%s</option>",
1797                                         __("Uncategorized"));
1798
1799                                 $feed_result = db_query("SELECT id,title FROM ttrss_feeds
1800                                         WHERE cat_id IS NULL AND owner_uid = ".$_SESSION["uid"] . " ORDER BY title");
1801
1802                                 while ($fline = db_fetch_assoc($feed_result)) {
1803                                         $is_selected = ($fline["id"] == $default_id && !$default_is_cat) ? "selected=\"1\"" : "";
1804
1805                                         $fline["title"] = " + " . $fline["title"];
1806
1807                                         for ($i = 0; $i < $nest_level; $i++)
1808                                                 $fline["title"] = " - " . $fline["title"];
1809
1810                                         printf("<option $is_selected value='%d'>%s</option>",
1811                                                 $fline["id"], htmlspecialchars($fline["title"]));
1812                                 }
1813                         }
1814
1815                 } else {
1816                         $result = db_query("SELECT id,title FROM ttrss_feeds
1817                                 WHERE owner_uid = ".$_SESSION["uid"]." ORDER BY title");
1818
1819                         while ($line = db_fetch_assoc($result)) {
1820
1821                                 $is_selected = ($line["id"] == $default_id) ? "selected=\"1\"" : "";
1822
1823                                 printf("<option $is_selected value='%d'>%s</option>",
1824                                         $line["id"], htmlspecialchars($line["title"]));
1825                         }
1826                 }
1827
1828                 if (!$root_id) {
1829                         print "</select>";
1830                 }
1831         }
1832
1833         function print_feed_cat_select($id, $default_id,
1834                 $attributes, $include_all_cats = true, $root_id = false, $nest_level = 0) {
1835
1836                         if (!$root_id) {
1837                                         print "<select id=\"$id\" name=\"$id\" default=\"$default_id\" onchange=\"catSelectOnChange(this)\" $attributes>";
1838                         }
1839
1840                         if ($root_id)
1841                                 $parent_qpart = "parent_cat = '$root_id'";
1842                         else
1843                                 $parent_qpart = "parent_cat IS NULL";
1844
1845                         $result = db_query("SELECT id,title,
1846                                 (SELECT COUNT(id) FROM ttrss_feed_categories AS c2 WHERE
1847                                         c2.parent_cat = ttrss_feed_categories.id) AS num_children
1848                                 FROM ttrss_feed_categories
1849                                 WHERE owner_uid = ".$_SESSION["uid"]." AND $parent_qpart ORDER BY title");
1850
1851                         while ($line = db_fetch_assoc($result)) {
1852                                 if ($line["id"] == $default_id) {
1853                                         $is_selected = "selected=\"1\"";
1854                                 } else {
1855                                         $is_selected = "";
1856                                 }
1857
1858                                 for ($i = 0; $i < $nest_level; $i++)
1859                                         $line["title"] = " - " . $line["title"];
1860
1861                                 if ($line["title"])
1862                                         printf("<option $is_selected value='%d'>%s</option>",
1863                                                 $line["id"], htmlspecialchars($line["title"]));
1864
1865                                 if ($line["num_children"] > 0)
1866                                         print_feed_cat_select($id, $default_id, $attributes,
1867                                                 $include_all_cats, $line["id"], $nest_level+1);
1868                         }
1869
1870                         if (!$root_id) {
1871                                 if ($include_all_cats) {
1872                                         if (db_num_rows($result) > 0) {
1873                                                 print "<option disabled=\"1\">--------</option>";
1874                                         }
1875
1876                                         if ($default_id == 0) {
1877                                                 $is_selected = "selected=\"1\"";
1878                                         } else {
1879                                                 $is_selected = "";
1880                                         }
1881
1882                                         print "<option $is_selected value=\"0\">".__('Uncategorized')."</option>";
1883                                 }
1884                                 print "</select>";
1885                         }
1886                 }
1887
1888         function checkbox_to_sql_bool($val) {
1889                 return ($val == "on") ? "true" : "false";
1890         }
1891
1892         function getFeedCatTitle($id) {
1893                 if ($id == -1) {
1894                         return __("Special");
1895                 } else if ($id < LABEL_BASE_INDEX) {
1896                         return __("Labels");
1897                 } else if ($id > 0) {
1898                         $result = db_query("SELECT ttrss_feed_categories.title
1899                                 FROM ttrss_feeds, ttrss_feed_categories WHERE ttrss_feeds.id = '$id' AND
1900                                         cat_id = ttrss_feed_categories.id");
1901                         if (db_num_rows($result) == 1) {
1902                                 return db_fetch_result($result, 0, "title");
1903                         } else {
1904                                 return __("Uncategorized");
1905                         }
1906                 } else {
1907                         return "getFeedCatTitle($id) failed";
1908                 }
1909
1910         }
1911
1912         function getFeedIcon($id) {
1913                 switch ($id) {
1914                 case 0:
1915                         return "images/archive.png";
1916                         break;
1917                 case -1:
1918                         return "images/star.png";
1919                         break;
1920                 case -2:
1921                         return "images/feed.png";
1922                         break;
1923                 case -3:
1924                         return "images/fresh.png";
1925                         break;
1926                 case -4:
1927                         return "images/folder.png";
1928                         break;
1929                 case -6:
1930                         return "images/time.png";
1931                         break;
1932                 default:
1933                         if ($id < LABEL_BASE_INDEX) {
1934                                 return "images/label.png";
1935                         } else {
1936                                 if (file_exists(ICONS_DIR . "/$id.ico"))
1937                                         return ICONS_URL . "/$id.ico";
1938                         }
1939                         break;
1940                 }
1941
1942                 return false;
1943         }
1944
1945         function getFeedTitle($id, $cat = false) {
1946                 if ($cat) {
1947                         return getCategoryTitle($id);
1948                 } else if ($id == -1) {
1949                         return __("Starred articles");
1950                 } else if ($id == -2) {
1951                         return __("Published articles");
1952                 } else if ($id == -3) {
1953                         return __("Fresh articles");
1954                 } else if ($id == -4) {
1955                         return __("All articles");
1956                 } else if ($id === 0 || $id === "0") {
1957                         return __("Archived articles");
1958                 } else if ($id == -6) {
1959                         return __("Recently read");
1960                 } else if ($id < LABEL_BASE_INDEX) {
1961                         $label_id = feed_to_label_id($id);
1962                         $result = db_query("SELECT caption FROM ttrss_labels2 WHERE id = '$label_id'");
1963                         if (db_num_rows($result) == 1) {
1964                                 return db_fetch_result($result, 0, "caption");
1965                         } else {
1966                                 return "Unknown label ($label_id)";
1967                         }
1968
1969                 } else if (is_numeric($id) && $id > 0) {
1970                         $result = db_query("SELECT title FROM ttrss_feeds WHERE id = '$id'");
1971                         if (db_num_rows($result) == 1) {
1972                                 return db_fetch_result($result, 0, "title");
1973                         } else {
1974                                 return "Unknown feed ($id)";
1975                         }
1976                 } else {
1977                         return $id;
1978                 }
1979         }
1980
1981         function make_init_params() {
1982                 $params = array();
1983
1984                 foreach (array("ON_CATCHUP_SHOW_NEXT_FEED", "HIDE_READ_FEEDS",
1985                         "ENABLE_FEED_CATS", "FEEDS_SORT_BY_UNREAD", "CONFIRM_FEED_CATCHUP",
1986                         "CDM_AUTO_CATCHUP", "FRESH_ARTICLE_MAX_AGE",
1987                         "HIDE_READ_SHOWS_SPECIAL", "COMBINED_DISPLAY_MODE") as $param) {
1988
1989                                  $params[strtolower($param)] = (int) get_pref($param);
1990                  }
1991
1992                 $params["icons_url"] = ICONS_URL;
1993                 $params["cookie_lifetime"] = SESSION_COOKIE_LIFETIME;
1994                 $params["default_view_mode"] = get_pref("_DEFAULT_VIEW_MODE");
1995                 $params["default_view_limit"] = (int) get_pref("_DEFAULT_VIEW_LIMIT");
1996                 $params["default_view_order_by"] = get_pref("_DEFAULT_VIEW_ORDER_BY");
1997                 $params["bw_limit"] = (int) $_SESSION["bw_limit"];
1998                 $params["label_base_index"] = (int) LABEL_BASE_INDEX;
1999
2000                 $result = db_query("SELECT MAX(id) AS mid, COUNT(*) AS nf FROM
2001                         ttrss_feeds WHERE owner_uid = " . $_SESSION["uid"]);
2002
2003                 $max_feed_id = db_fetch_result($result, 0, "mid");
2004                 $num_feeds = db_fetch_result($result, 0, "nf");
2005
2006                 $params["max_feed_id"] = (int) $max_feed_id;
2007                 $params["num_feeds"] = (int) $num_feeds;
2008
2009                 $params["hotkeys"] = get_hotkeys_map();
2010
2011                 $params["csrf_token"] = $_SESSION["csrf_token"];
2012                 $params["widescreen"] = (int) $_COOKIE["ttrss_widescreen"];
2013
2014                 $params['simple_update'] = defined('SIMPLE_UPDATE_MODE') && SIMPLE_UPDATE_MODE;
2015
2016                 return $params;
2017         }
2018
2019         function get_hotkeys_info() {
2020                 $hotkeys = array(
2021                         __("Navigation") => array(
2022                                 "next_feed" => __("Open next feed"),
2023                                 "prev_feed" => __("Open previous feed"),
2024                                 "next_article" => __("Open next article"),
2025                                 "prev_article" => __("Open previous article"),
2026                                 "next_article_noscroll" => __("Open next article (don't scroll long articles)"),
2027                                 "prev_article_noscroll" => __("Open previous article (don't scroll long articles)"),
2028                                 "next_article_noexpand" => __("Move to next article (don't expand or mark read)"),
2029                                 "prev_article_noexpand" => __("Move to previous article (don't expand or mark read)"),
2030                                 "search_dialog" => __("Show search dialog")),
2031                         __("Article") => array(
2032                                 "toggle_mark" => __("Toggle starred"),
2033                                 "toggle_publ" => __("Toggle published"),
2034                                 "toggle_unread" => __("Toggle unread"),
2035                                 "edit_tags" => __("Edit tags"),
2036                                 "dismiss_selected" => __("Dismiss selected"),
2037                                 "dismiss_read" => __("Dismiss read"),
2038                                 "open_in_new_window" => __("Open in new window"),
2039                                 "catchup_below" => __("Mark below as read"),
2040                                 "catchup_above" => __("Mark above as read"),
2041                                 "article_scroll_down" => __("Scroll down"),
2042                                 "article_scroll_up" => __("Scroll up"),
2043                                 "select_article_cursor" => __("Select article under cursor"),
2044                                 "email_article" => __("Email article"),
2045                                 "close_article" => __("Close/collapse article"),
2046                                 "toggle_expand" => __("Toggle article expansion (combined mode)"),
2047                                 "toggle_widescreen" => __("Toggle widescreen mode"),
2048                                 "toggle_embed_original" => __("Toggle embed original")),
2049                         __("Article selection") => array(
2050                                 "select_all" => __("Select all articles"),
2051                                 "select_unread" => __("Select unread"),
2052                                 "select_marked" => __("Select starred"),
2053                                 "select_published" => __("Select published"),
2054                                 "select_invert" => __("Invert selection"),
2055                                 "select_none" => __("Deselect everything")),
2056                         __("Feed") => array(
2057                                 "feed_refresh" => __("Refresh current feed"),
2058                                 "feed_unhide_read" => __("Un/hide read feeds"),
2059                                 "feed_subscribe" => __("Subscribe to feed"),
2060                                 "feed_edit" => __("Edit feed"),
2061                                 "feed_catchup" => __("Mark as read"),
2062                                 "feed_reverse" => __("Reverse headlines"),
2063                                 "feed_debug_update" => __("Debug feed update"),
2064                                 "catchup_all" => __("Mark all feeds as read"),
2065                                 "cat_toggle_collapse" => __("Un/collapse current category"),
2066                                 "toggle_combined_mode" => __("Toggle combined mode"),
2067                                 "toggle_cdm_expanded" => __("Toggle auto expand in combined mode")),
2068                         __("Go to") => array(
2069                                 "goto_all" => __("All articles"),
2070                                 "goto_fresh" => __("Fresh"),
2071                                 "goto_marked" => __("Starred"),
2072                                 "goto_published" => __("Published"),
2073                                 "goto_tagcloud" => __("Tag cloud"),
2074                                 "goto_prefs" => __("Preferences")),
2075                         __("Other") => array(
2076                                 "create_label" => __("Create label"),
2077                                 "create_filter" => __("Create filter"),
2078                                 "collapse_sidebar" => __("Un/collapse sidebar"),
2079                                 "help_dialog" => __("Show help dialog"))
2080                         );
2081
2082                 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_HOTKEY_INFO) as $plugin) {
2083                         $hotkeys = $plugin->hook_hotkey_info($hotkeys);
2084                 }
2085
2086                 return $hotkeys;
2087         }
2088
2089         function get_hotkeys_map() {
2090                 $hotkeys = array(
2091 //                      "navigation" => array(
2092                                 "k" => "next_feed",
2093                                 "j" => "prev_feed",
2094                                 "n" => "next_article",
2095                                 "p" => "prev_article",
2096                                 "(38)|up" => "prev_article",
2097                                 "(40)|down" => "next_article",
2098 //                              "^(38)|Ctrl-up" => "prev_article_noscroll",
2099 //                              "^(40)|Ctrl-down" => "next_article_noscroll",
2100                                 "(191)|/" => "search_dialog",
2101 //                      "article" => array(
2102                                 "s" => "toggle_mark",
2103                                 "*s" => "toggle_publ",
2104                                 "u" => "toggle_unread",
2105                                 "*t" => "edit_tags",
2106                                 "*d" => "dismiss_selected",
2107                                 "*x" => "dismiss_read",
2108                                 "o" => "open_in_new_window",
2109                                 "c p" => "catchup_below",
2110                                 "c n" => "catchup_above",
2111                                 "*n" => "article_scroll_down",
2112                                 "*p" => "article_scroll_up",
2113                                 "*(38)|Shift+up" => "article_scroll_up",
2114                                 "*(40)|Shift+down" => "article_scroll_down",
2115                                 "a *w" => "toggle_widescreen",
2116                                 "a e" => "toggle_embed_original",
2117                                 "e" => "email_article",
2118                                 "a q" => "close_article",
2119 //                      "article_selection" => array(
2120                                 "a a" => "select_all",
2121                                 "a u" => "select_unread",
2122                                 "a *u" => "select_marked",
2123                                 "a p" => "select_published",
2124                                 "a i" => "select_invert",
2125                                 "a n" => "select_none",
2126 //                      "feed" => array(
2127                                 "f r" => "feed_refresh",
2128                                 "f a" => "feed_unhide_read",
2129                                 "f s" => "feed_subscribe",
2130                                 "f e" => "feed_edit",
2131                                 "f q" => "feed_catchup",
2132                                 "f x" => "feed_reverse",
2133                                 "f *d" => "feed_debug_update",
2134                                 "f *c" => "toggle_combined_mode",
2135                                 "f c" => "toggle_cdm_expanded",
2136                                 "*q" => "catchup_all",
2137                                 "x" => "cat_toggle_collapse",
2138 //                      "goto" => array(
2139                                 "g a" => "goto_all",
2140                                 "g f" => "goto_fresh",
2141                                 "g s" => "goto_marked",
2142                                 "g p" => "goto_published",
2143                                 "g t" => "goto_tagcloud",
2144                                 "g *p" => "goto_prefs",
2145 //                      "other" => array(
2146                                 "(9)|Tab" => "select_article_cursor", // tab
2147                                 "c l" => "create_label",
2148                                 "c f" => "create_filter",
2149                                 "c s" => "collapse_sidebar",
2150                                 "^(191)|Ctrl+/" => "help_dialog",
2151                         );
2152
2153                 if (get_pref('COMBINED_DISPLAY_MODE')) {
2154                         $hotkeys["^(38)|Ctrl-up"] = "prev_article_noscroll";
2155                         $hotkeys["^(40)|Ctrl-down"] = "next_article_noscroll";
2156                 }
2157
2158                 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_HOTKEY_MAP) as $plugin) {
2159                         $hotkeys = $plugin->hook_hotkey_map($hotkeys);
2160                 }
2161
2162                 $prefixes = array();
2163
2164                 foreach (array_keys($hotkeys) as $hotkey) {
2165                         $pair = explode(" ", $hotkey, 2);
2166
2167                         if (count($pair) > 1 && !in_array($pair[0], $prefixes)) {
2168                                 array_push($prefixes, $pair[0]);
2169                         }
2170                 }
2171
2172                 return array($prefixes, $hotkeys);
2173         }
2174
2175         function make_runtime_info() {
2176                 $data = array();
2177
2178                 $result = db_query("SELECT MAX(id) AS mid, COUNT(*) AS nf FROM
2179                         ttrss_feeds WHERE owner_uid = " . $_SESSION["uid"]);
2180
2181                 $max_feed_id = db_fetch_result($result, 0, "mid");
2182                 $num_feeds = db_fetch_result($result, 0, "nf");
2183
2184                 $data["max_feed_id"] = (int) $max_feed_id;
2185                 $data["num_feeds"] = (int) $num_feeds;
2186
2187                 $data['last_article_id'] = getLastArticleId();
2188                 $data['cdm_expanded'] = get_pref('CDM_EXPANDED');
2189
2190                 $data['dep_ts'] = calculate_dep_timestamp();
2191                 $data['reload_on_ts_change'] = !defined('_NO_RELOAD_ON_TS_CHANGE');
2192
2193                 if (file_exists(LOCK_DIRECTORY . "/update_daemon.lock")) {
2194
2195                         $data['daemon_is_running'] = (int) file_is_locked("update_daemon.lock");
2196
2197                         if (time() - $_SESSION["daemon_stamp_check"] > 30) {
2198
2199                                 $stamp = (int) @file_get_contents(LOCK_DIRECTORY . "/update_daemon.stamp");
2200
2201                                 if ($stamp) {
2202                                         $stamp_delta = time() - $stamp;
2203
2204                                         if ($stamp_delta > 1800) {
2205                                                 $stamp_check = 0;
2206                                         } else {
2207                                                 $stamp_check = 1;
2208                                                 $_SESSION["daemon_stamp_check"] = time();
2209                                         }
2210
2211                                         $data['daemon_stamp_ok'] = $stamp_check;
2212
2213                                         $stamp_fmt = date("Y.m.d, G:i", $stamp);
2214
2215                                         $data['daemon_stamp'] = $stamp_fmt;
2216                                 }
2217                         }
2218                 }
2219
2220                 if ($_SESSION["last_version_check"] + 86400 + rand(-1000, 1000) < time()) {
2221                                 $new_version_details = @check_for_update();
2222
2223                                 $data['new_version_available'] = (int) ($new_version_details != false);
2224
2225                                 $_SESSION["last_version_check"] = time();
2226                                 $_SESSION["version_data"] = $new_version_details;
2227                 }
2228
2229                 return $data;
2230         }
2231
2232         function search_to_sql($search) {
2233
2234                 $search_query_part = "";
2235
2236                 $keywords = explode(" ", $search);
2237                 $query_keywords = array();
2238                 $search_words = array();
2239
2240                 foreach ($keywords as $k) {
2241                         if (strpos($k, "-") === 0) {
2242                                 $k = substr($k, 1);
2243                                 $not = "NOT";
2244                         } else {
2245                                 $not = "";
2246                         }
2247
2248                         $commandpair = explode(":", mb_strtolower($k), 2);
2249
2250                         switch ($commandpair[0]) {
2251                         case "title":
2252                                 if ($commandpair[1]) {
2253                                         array_push($query_keywords, "($not (LOWER(ttrss_entries.title) LIKE '%".
2254                                                 db_escape_string(mb_strtolower($commandpair[1]))."%'))");
2255                                 } else {
2256                                         array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
2257                                                         OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
2258                                         array_push($search_words, $k);
2259                                 }
2260                                 break;
2261                         case "author":
2262                                 if ($commandpair[1]) {
2263                                         array_push($query_keywords, "($not (LOWER(author) LIKE '%".
2264                                                 db_escape_string(mb_strtolower($commandpair[1]))."%'))");
2265                                 } else {
2266                                         array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
2267                                                         OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
2268                                         array_push($search_words, $k);
2269                                 }
2270                                 break;
2271                         case "note":
2272                                 if ($commandpair[1]) {
2273                                         if ($commandpair[1] == "true")
2274                                                 array_push($query_keywords, "($not (note IS NOT NULL AND note != ''))");
2275                                         else if ($commandpair[1] == "false")
2276                                                 array_push($query_keywords, "($not (note IS NULL OR note = ''))");
2277                                         else
2278                                                 array_push($query_keywords, "($not (LOWER(note) LIKE '%".
2279                                                         db_escape_string(mb_strtolower($commandpair[1]))."%'))");
2280                                 } else {
2281                                         array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
2282                                                         OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
2283                                         if (!$not) array_push($search_words, $k);
2284                                 }
2285                                 break;
2286                         case "star":
2287
2288                                 if ($commandpair[1]) {
2289                                         if ($commandpair[1] == "true")
2290                                                 array_push($query_keywords, "($not (marked = true))");
2291                                         else
2292                                                 array_push($query_keywords, "($not (marked = false))");
2293                                 } else {
2294                                         array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
2295                                                         OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
2296                                         if (!$not) array_push($search_words, $k);
2297                                 }
2298                                 break;
2299                         case "pub":
2300                                 if ($commandpair[1]) {
2301                                         if ($commandpair[1] == "true")
2302                                                 array_push($query_keywords, "($not (published = true))");
2303                                         else
2304                                                 array_push($query_keywords, "($not (published = false))");
2305
2306                                 } else {
2307                                         array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
2308                                                         OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
2309                                         if (!$not) array_push($search_words, $k);
2310                                 }
2311                                 break;
2312                         default:
2313                                 if (strpos($k, "@") === 0) {
2314
2315                                         $user_tz_string = get_pref('USER_TIMEZONE', $_SESSION['uid']);
2316                                         $orig_ts = strtotime(substr($k, 1));
2317                                         $k = date("Y-m-d", convert_timestamp($orig_ts, $user_tz_string, 'UTC'));
2318
2319                                         //$k = date("Y-m-d", strtotime(substr($k, 1)));
2320
2321                                         array_push($query_keywords, "(".SUBSTRING_FOR_DATE."(updated,1,LENGTH('$k')) $not = '$k')");
2322                                 } else {
2323                                         array_push($query_keywords, "(UPPER(ttrss_entries.title) $not LIKE UPPER('%$k%')
2324                                                         OR UPPER(ttrss_entries.content) $not LIKE UPPER('%$k%'))");
2325
2326                                         if (!$not) array_push($search_words, $k);
2327                                 }
2328                         }
2329                 }
2330
2331                 $search_query_part = implode("AND", $query_keywords);
2332
2333                 return array($search_query_part, $search_words);
2334         }
2335
2336         function getParentCategories($cat, $owner_uid) {
2337                 $rv = array();
2338
2339                 $result = db_query("SELECT parent_cat FROM ttrss_feed_categories
2340                         WHERE id = '$cat' AND parent_cat IS NOT NULL AND owner_uid = $owner_uid");
2341
2342                 while ($line = db_fetch_assoc($result)) {
2343                         array_push($rv, $line["parent_cat"]);
2344                         $rv = array_merge($rv, getParentCategories($line["parent_cat"], $owner_uid));
2345                 }
2346
2347                 return $rv;
2348         }
2349
2350         function getChildCategories($cat, $owner_uid) {
2351                 $rv = array();
2352
2353                 $result = db_query("SELECT id FROM ttrss_feed_categories
2354                         WHERE parent_cat = '$cat' AND owner_uid = $owner_uid");
2355
2356                 while ($line = db_fetch_assoc($result)) {
2357                         array_push($rv, $line["id"]);
2358                         $rv = array_merge($rv, getChildCategories($line["id"], $owner_uid));
2359                 }
2360
2361                 return $rv;
2362         }
2363
2364         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) {
2365
2366                 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
2367
2368                 $ext_tables_part = "";
2369                 $search_words = array();
2370
2371                         if ($search) {
2372
2373                                 if (SPHINX_ENABLED) {
2374                                         $ids = join(",", @sphinx_search($search, 0, 500));
2375
2376                                         if ($ids)
2377                                                 $search_query_part = "ref_id IN ($ids) AND ";
2378                                         else
2379                                                 $search_query_part = "ref_id = -1 AND ";
2380
2381                                 } else {
2382                                         list($search_query_part, $search_words) = search_to_sql($search);
2383                                         $search_query_part .= " AND ";
2384                                 }
2385
2386                         } else {
2387                                 $search_query_part = "";
2388                         }
2389
2390                         if ($filter) {
2391
2392                                 if (DB_TYPE == "pgsql") {
2393                                         $query_strategy_part .= " AND updated > NOW() - INTERVAL '14 days' ";
2394                                 } else {
2395                                         $query_strategy_part .= " AND updated > DATE_SUB(NOW(), INTERVAL 14 DAY) ";
2396                                 }
2397
2398                                 $override_order = "updated DESC";
2399
2400                                 $filter_query_part = filter_to_sql($filter, $owner_uid);
2401
2402                                 // Try to check if SQL regexp implementation chokes on a valid regexp
2403
2404
2405                                 $result = db_query("SELECT true AS true_val FROM ttrss_entries,
2406                                         ttrss_user_entries, ttrss_feeds
2407                                         WHERE $filter_query_part LIMIT 1", false);
2408
2409                                 if ($result) {
2410                                         $test = db_fetch_result($result, 0, "true_val");
2411
2412                                         if (!$test) {
2413                                                 $filter_query_part = "false AND";
2414                                         } else {
2415                                                 $filter_query_part .= " AND";
2416                                         }
2417                                 } else {
2418                                         $filter_query_part = "false AND";
2419                                 }
2420
2421                         } else {
2422                                 $filter_query_part = "";
2423                         }
2424
2425                         if ($since_id) {
2426                                 $since_id_part = "ttrss_entries.id > $since_id AND ";
2427                         } else {
2428                                 $since_id_part = "";
2429                         }
2430
2431                         $view_query_part = "";
2432
2433                         if ($view_mode == "adaptive") {
2434                                 if ($search) {
2435                                         $view_query_part = " ";
2436                                 } else if ($feed != -1) {
2437
2438                                         $unread = getFeedUnread($feed, $cat_view);
2439
2440                                         if ($cat_view && $feed > 0 && $include_children)
2441                                                 $unread += getCategoryChildrenUnread($feed);
2442
2443                                         if ($unread > 0)
2444                                 $view_query_part = " unread = true AND ";
2445
2446                                 }
2447                         }
2448
2449                         if ($view_mode == "marked") {
2450                                 $view_query_part = " marked = true AND ";
2451                         }
2452
2453                         if ($view_mode == "has_note") {
2454                                 $view_query_part = " (note IS NOT NULL AND note != '') AND ";
2455                         }
2456
2457                         if ($view_mode == "published") {
2458                                 $view_query_part = " published = true AND ";
2459                         }
2460
2461                         if ($view_mode == "unread" && $feed != -6) {
2462                                 $view_query_part = " unread = true AND ";
2463                         }
2464
2465                         if ($limit > 0) {
2466                                 $limit_query_part = "LIMIT " . $limit;
2467                         }
2468
2469                         $allow_archived = false;
2470
2471                         $vfeed_query_part = "";
2472
2473                         // override query strategy and enable feed display when searching globally
2474                         if ($search && $search_mode == "all_feeds") {
2475                                 $query_strategy_part = "true";
2476                                 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2477                         /* tags */
2478                         } else if (!is_numeric($feed)) {
2479                                 $query_strategy_part = "true";
2480                                 $vfeed_query_part = "(SELECT title FROM ttrss_feeds WHERE
2481                                         id = feed_id) as feed_title,";
2482                         } else if ($search && $search_mode == "this_cat") {
2483                                 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2484
2485                                 if ($feed > 0) {
2486                                         if ($include_children) {
2487                                                 $subcats = getChildCategories($feed, $owner_uid);
2488                                                 array_push($subcats, $feed);
2489                                                 $cats_qpart = join(",", $subcats);
2490                                         } else {
2491                                                 $cats_qpart = $feed;
2492                                         }
2493
2494                                         $query_strategy_part = "ttrss_feeds.cat_id IN ($cats_qpart)";
2495
2496                                 } else {
2497                                         $query_strategy_part = "ttrss_feeds.cat_id IS NULL";
2498                                 }
2499
2500                         } else if ($feed > 0) {
2501
2502                                 if ($cat_view) {
2503
2504                                         if ($feed > 0) {
2505                                                 if ($include_children) {
2506                                                         # sub-cats
2507                                                         $subcats = getChildCategories($feed, $owner_uid);
2508
2509                                                         array_push($subcats, $feed);
2510                                                         $query_strategy_part = "cat_id IN (".
2511                                                                         implode(",", $subcats).")";
2512
2513                                                 } else {
2514                                                         $query_strategy_part = "cat_id = '$feed'";
2515                                                 }
2516
2517                                         } else {
2518                                                 $query_strategy_part = "cat_id IS NULL";
2519                                         }
2520
2521                                         $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2522
2523                                 } else {
2524                                         $query_strategy_part = "feed_id = '$feed'";
2525                                 }
2526                         } else if ($feed == 0 && !$cat_view) { // archive virtual feed
2527                                 $query_strategy_part = "feed_id IS NULL";
2528                                 $allow_archived = true;
2529                         } else if ($feed == 0 && $cat_view) { // uncategorized
2530                                 $query_strategy_part = "cat_id IS NULL AND feed_id IS NOT NULL";
2531                                 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2532                         } else if ($feed == -1) { // starred virtual feed
2533                                 $query_strategy_part = "marked = true";
2534                                 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2535                                 $allow_archived = true;
2536
2537                                 if (!$override_order) {
2538                                         $override_order = "last_marked DESC, date_entered DESC, updated DESC";
2539                                 }
2540
2541                         } else if ($feed == -2) { // published virtual feed OR labels category
2542
2543                                 if (!$cat_view) {
2544                                         $query_strategy_part = "published = true";
2545                                         $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2546                                         $allow_archived = true;
2547
2548                                         if (!$override_order) {
2549                                                 $override_order = "last_published DESC, date_entered DESC, updated DESC";
2550                                         }
2551
2552                                 } else {
2553                                         $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2554
2555                                         $ext_tables_part = ",ttrss_labels2,ttrss_user_labels2";
2556
2557                                         $query_strategy_part = "ttrss_labels2.id = ttrss_user_labels2.label_id AND
2558                                                 ttrss_user_labels2.article_id = ref_id";
2559
2560                                 }
2561                         } else if ($feed == -6) { // recently read
2562                                 $query_strategy_part = "unread = false AND last_read IS NOT NULL";
2563                                 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2564                                 $allow_archived = true;
2565
2566                                 if (!$override_order) $override_order = "last_read DESC";
2567
2568 /*                      } else if ($feed == -7) { // shared
2569                                 $query_strategy_part = "uuid != ''";
2570                                 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2571                                 $allow_archived = true; */
2572                         } else if ($feed == -3) { // fresh virtual feed
2573                                 $query_strategy_part = "unread = true AND score >= 0";
2574
2575                                 $intl = get_pref("FRESH_ARTICLE_MAX_AGE", $owner_uid);
2576
2577                                 if (DB_TYPE == "pgsql") {
2578                                         $query_strategy_part .= " AND date_entered > NOW() - INTERVAL '$intl hour' ";
2579                                 } else {
2580                                         $query_strategy_part .= " AND date_entered > DATE_SUB(NOW(), INTERVAL $intl HOUR) ";
2581                                 }
2582
2583                                 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2584                         } else if ($feed == -4) { // all articles virtual feed
2585                                 $allow_archived = true;
2586                                 $query_strategy_part = "true";
2587                                 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2588                         } else if ($feed <= LABEL_BASE_INDEX) { // labels
2589                                 $label_id = feed_to_label_id($feed);
2590
2591                                 $query_strategy_part = "label_id = '$label_id' AND
2592                                         ttrss_labels2.id = ttrss_user_labels2.label_id AND
2593                                         ttrss_user_labels2.article_id = ref_id";
2594
2595                                 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2596                                 $ext_tables_part = ",ttrss_labels2,ttrss_user_labels2";
2597                                 $allow_archived = true;
2598
2599                         } else {
2600                                 $query_strategy_part = "true";
2601                         }
2602
2603                         $order_by = "score DESC, date_entered DESC, updated DESC";
2604
2605                         if ($view_mode == "unread_first") {
2606                                 $order_by = "unread DESC, $order_by";
2607                         }
2608
2609                         if ($override_order) {
2610                                 $order_by = $override_order;
2611                         }
2612
2613                         if ($override_strategy) {
2614                                 $query_strategy_part = $override_strategy;
2615                         }
2616
2617                         if ($override_vfeed) {
2618                                 $vfeed_query_part = $override_vfeed;
2619                         }
2620
2621                         $feed_title = "";
2622
2623                         if ($search) {
2624                                 $feed_title = T_sprintf("Search results: %s", $search);
2625                         } else {
2626                                 if ($cat_view) {
2627                                         $feed_title = getCategoryTitle($feed);
2628                                 } else {
2629                                         if (is_numeric($feed) && $feed > 0) {
2630                                                 $result = db_query("SELECT title,site_url,last_error,last_updated
2631                                                         FROM ttrss_feeds WHERE id = '$feed' AND owner_uid = $owner_uid");
2632
2633                                                 $feed_title = db_fetch_result($result, 0, "title");
2634                                                 $feed_site_url = db_fetch_result($result, 0, "site_url");
2635                                                 $last_error = db_fetch_result($result, 0, "last_error");
2636                                                 $last_updated = db_fetch_result($result, 0, "last_updated");
2637                                         } else {
2638                                                 $feed_title = getFeedTitle($feed);
2639                                         }
2640                                 }
2641                         }
2642
2643
2644                         $content_query_part = "content, content AS content_preview, ";
2645
2646
2647                         if (is_numeric($feed)) {
2648
2649                                 if ($feed >= 0) {
2650                                         $feed_kind = "Feeds";
2651                                 } else {
2652                                         $feed_kind = "Labels";
2653                                 }
2654
2655                                 if ($limit_query_part) {
2656                                         $offset_query_part = "OFFSET $offset";
2657                                 }
2658
2659                                 // proper override_order applied above
2660                                 if ($vfeed_query_part && !$ignore_vfeed_group && get_pref('VFEED_GROUP_BY_FEED', $owner_uid)) {
2661                                         if (!$override_order) {
2662                                                 $order_by = "ttrss_feeds.title, $order_by";
2663                                         } else {
2664                                                 $order_by = "ttrss_feeds.title, $override_order";
2665                                         }
2666                                 }
2667
2668                                 if (!$allow_archived) {
2669                                         $from_qpart = "ttrss_entries,ttrss_user_entries,ttrss_feeds$ext_tables_part";
2670                                         $feed_check_qpart = "ttrss_user_entries.feed_id = ttrss_feeds.id AND";
2671
2672                                 } else {
2673                                         $from_qpart = "ttrss_entries$ext_tables_part,ttrss_user_entries
2674                                                 LEFT JOIN ttrss_feeds ON (feed_id = ttrss_feeds.id)";
2675                                 }
2676
2677                                 if ($vfeed_query_part)
2678                                         $vfeed_query_part .= "favicon_avg_color,";
2679
2680                                 $query = "SELECT DISTINCT
2681                                                 date_entered,
2682                                                 guid,
2683                                                 ttrss_entries.id,ttrss_entries.title,
2684                                                 updated,
2685                                                 label_cache,
2686                                                 tag_cache,
2687                                                 always_display_enclosures,
2688                                                 site_url,
2689                                                 note,
2690                                                 num_comments,
2691                                                 comments,
2692                                                 int_id,
2693                                                 uuid,
2694                                                 lang,
2695                                                 hide_images,
2696                                                 unread,feed_id,marked,published,link,last_read,orig_feed_id,
2697                                                 last_marked, last_published,
2698                                                 $vfeed_query_part
2699                                                 $content_query_part
2700                                                 author,score
2701                                         FROM
2702                                                 $from_qpart
2703                                         WHERE
2704                                         $feed_check_qpart
2705                                         ttrss_user_entries.ref_id = ttrss_entries.id AND
2706                                         ttrss_user_entries.owner_uid = '$owner_uid' AND
2707                                         $search_query_part
2708                                         $filter_query_part
2709                                         $view_query_part
2710                                         $since_id_part
2711                                         $query_strategy_part ORDER BY $order_by
2712                                         $limit_query_part $offset_query_part";
2713
2714                                 if ($_REQUEST["debug"]) print $query;
2715
2716                                 $result = db_query($query);
2717
2718                         } else {
2719                                 // browsing by tag
2720
2721                                 $select_qpart = "SELECT DISTINCT " .
2722                                                                 "date_entered," .
2723                                                                 "guid," .
2724                                                                 "note," .
2725                                                                 "ttrss_entries.id as id," .
2726                                                                 "title," .
2727                                                                 "updated," .
2728                                                                 "unread," .
2729                                                                 "feed_id," .
2730                                                                 "orig_feed_id," .
2731                                                                 "marked," .
2732                                                                 "num_comments, " .
2733                                                                 "comments, " .
2734                                                                 "tag_cache," .
2735                                                                 "label_cache," .
2736                                                                 "link," .
2737                                                                 "lang," .
2738                                                                 "uuid," .
2739                                                                 "last_read," .
2740                                                                 "(SELECT hide_images FROM ttrss_feeds WHERE id = feed_id) AS hide_images," .
2741                                                                 "last_marked, last_published, " .
2742                                                                 $since_id_part .
2743                                                                 $vfeed_query_part .
2744                                                                 $content_query_part .
2745                                                                 "score ";
2746
2747                                 $feed_kind = "Tags";
2748                                 $all_tags = explode(",", $feed);
2749                                 if ($search_mode == 'any') {
2750                                         $tag_sql = "tag_name in (" . implode(", ", array_map("db_quote", $all_tags)) . ")";
2751                                         $from_qpart = " FROM ttrss_entries,ttrss_user_entries,ttrss_tags ";
2752                                         $where_qpart = " WHERE " .
2753                                                                    "ref_id = ttrss_entries.id AND " .
2754                                                                    "ttrss_user_entries.owner_uid = $owner_uid AND " .
2755                                                                    "post_int_id = int_id AND $tag_sql AND " .
2756                                                                    $view_query_part .
2757                                                                    $search_query_part .
2758                                                                    $query_strategy_part . " ORDER BY $order_by " .
2759                                                                    $limit_query_part;
2760
2761                                 } else {
2762                                         $i = 1;
2763                                         $sub_selects = array();
2764                                         $sub_ands = array();
2765                                         foreach ($all_tags as $term) {
2766                                                 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");
2767                                                 $i++;
2768                                         }
2769                                         if ($i > 2) {
2770                                                 $x = 1;
2771                                                 $y = 2;
2772                                                 do {
2773                                                         array_push($sub_ands, "A$x.post_int_id = A$y.post_int_id");
2774                                                         $x++;
2775                                                         $y++;
2776                                                 } while ($y < $i);
2777                                         }
2778                                         array_push($sub_ands, "A1.post_int_id = ttrss_user_entries.int_id and ttrss_user_entries.owner_uid = $owner_uid");
2779                                         array_push($sub_ands, "ttrss_user_entries.ref_id = ttrss_entries.id");
2780                                         $from_qpart = " FROM " . implode(", ", $sub_selects) . ", ttrss_user_entries, ttrss_entries";
2781                                         $where_qpart = " WHERE " . implode(" AND ", $sub_ands);
2782                                 }
2783                                 //                              error_log("TAG SQL: " . $tag_sql);
2784                                 // $tag_sql = "tag_name = '$feed'";   DEFAULT way
2785
2786                                 //                              error_log("[". $select_qpart . "][" . $from_qpart . "][" .$where_qpart . "]");
2787                                 $result = db_query($select_qpart . $from_qpart . $where_qpart);
2788                         }
2789
2790                         return array($result, $feed_title, $feed_site_url, $last_error, $last_updated, $search_words);
2791
2792         }
2793
2794         function sanitize($str, $force_remove_images = false, $owner = false, $site_url = false, $highlight_words = false, $article_id = false) {
2795                 if (!$owner) $owner = $_SESSION["uid"];
2796
2797                 $res = trim($str); if (!$res) return '';
2798
2799                 $charset_hack = '<head>
2800                         <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
2801                 </head>';
2802
2803                 $res = trim($res); if (!$res) return '';
2804
2805                 libxml_use_internal_errors(true);
2806
2807                 $doc = new DOMDocument();
2808                 $doc->loadHTML($charset_hack . $res);
2809                 $xpath = new DOMXPath($doc);
2810
2811                 $entries = $xpath->query('(//a[@href]|//img[@src])');
2812
2813                 foreach ($entries as $entry) {
2814
2815                         if ($site_url) {
2816
2817                                 if ($entry->hasAttribute('href'))
2818                                         $entry->setAttribute('href',
2819                                                 rewrite_relative_url($site_url, $entry->getAttribute('href')));
2820
2821                                 if ($entry->hasAttribute('src')) {
2822                                         $src = rewrite_relative_url($site_url, $entry->getAttribute('src'));
2823
2824                                         $cached_filename = CACHE_DIR . '/images/' . sha1($src) . '.png';
2825
2826                                         if (file_exists($cached_filename)) {
2827                                                 $src = SELF_URL_PATH . '/image.php?hash=' . sha1($src);
2828                                         }
2829
2830                                         $entry->setAttribute('src', $src);
2831                                 }
2832
2833                                 if ($entry->nodeName == 'img') {
2834                                         if (($owner && get_pref("STRIP_IMAGES", $owner)) ||
2835                                                         $force_remove_images || $_SESSION["bw_limit"]) {
2836
2837                                                 $p = $doc->createElement('p');
2838
2839                                                 $a = $doc->createElement('a');
2840                                                 $a->setAttribute('href', $entry->getAttribute('src'));
2841
2842                                                 $a->appendChild(new DOMText($entry->getAttribute('src')));
2843                                                 $a->setAttribute('target', '_blank');
2844
2845                                                 $p->appendChild($a);
2846
2847                                                 $entry->parentNode->replaceChild($p, $entry);
2848                                         }
2849                                 }
2850                         }
2851
2852                         if (strtolower($entry->nodeName) == "a") {
2853                                 $entry->setAttribute("target", "_blank");
2854                         }
2855                 }
2856
2857                 $entries = $xpath->query('//iframe');
2858                 foreach ($entries as $entry) {
2859                         $entry->setAttribute('sandbox', 'allow-scripts');
2860
2861                 }
2862
2863                 $allowed_elements = array('a', 'address', 'audio', 'article', 'aside',
2864                         'b', 'bdi', 'bdo', 'big', 'blockquote', 'body', 'br',
2865                         'caption', 'cite', 'center', 'code', 'col', 'colgroup',
2866                         'data', 'dd', 'del', 'details', 'div', 'dl', 'font',
2867                         'dt', 'em', 'footer', 'figure', 'figcaption',
2868                         'h1', 'h2', 'h3', 'h4', 'h5', 'h6', 'header', 'html', 'i',
2869                         'img', 'ins', 'kbd', 'li', 'main', 'mark', 'nav', 'noscript',
2870                         'ol', 'p', 'pre', 'q', 'ruby', 'rp', 'rt', 's', 'samp', 'section',
2871                         'small', 'source', 'span', 'strike', 'strong', 'sub', 'summary',
2872                         'sup', 'table', 'tbody', 'td', 'tfoot', 'th', 'thead', 'time',
2873                         'tr', 'track', 'tt', 'u', 'ul', 'var', 'wbr', 'video' );
2874
2875                 if ($_SESSION['hasSandbox']) $allowed_elements[] = 'iframe';
2876
2877                 $disallowed_attributes = array('id', 'style', 'class');
2878
2879                 foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_SANITIZE) as $plugin) {
2880                         $retval = $plugin->hook_sanitize($doc, $site_url, $allowed_elements, $disallowed_attributes, $article_id);
2881                         if (is_array($retval)) {
2882                                 $doc = $retval[0];
2883                                 $allowed_elements = $retval[1];
2884                                 $disallowed_attributes = $retval[2];
2885                         } else {
2886                                 $doc = $retval;
2887                         }
2888                 }
2889
2890                 $doc->removeChild($doc->firstChild); //remove doctype
2891                 $doc = strip_harmful_tags($doc, $allowed_elements, $disallowed_attributes);
2892
2893                 if ($highlight_words) {
2894                         foreach ($highlight_words as $word) {
2895
2896                                 // http://stackoverflow.com/questions/4081372/highlight-keywords-in-a-paragraph
2897
2898                                 $elements = $xpath->query("//*/text()");
2899
2900                                 foreach ($elements as $child) {
2901
2902                                         $fragment = $doc->createDocumentFragment();
2903                                         $text = $child->textContent;
2904                                         $stubs = array();
2905
2906                                         while (($pos = mb_stripos($text, $word)) !== false) {
2907                                                 $fragment->appendChild(new DomText(mb_substr($text, 0, $pos)));
2908                                                 $word = mb_substr($text, $pos, mb_strlen($word));
2909                                                 $highlight = $doc->createElement('span');
2910                                                 $highlight->appendChild(new DomText($word));
2911                                                 $highlight->setAttribute('class', 'highlight');
2912                                                 $fragment->appendChild($highlight);
2913                                                 $text = mb_substr($text, $pos + mb_strlen($word));
2914                                         }
2915
2916                                         if (!empty($text)) $fragment->appendChild(new DomText($text));
2917
2918                                         $child->parentNode->replaceChild($fragment, $child);
2919                                 }
2920                         }
2921                 }
2922
2923                 $res = $doc->saveHTML();
2924
2925                 return $res;
2926         }
2927
2928         function strip_harmful_tags($doc, $allowed_elements, $disallowed_attributes) {
2929                 $xpath = new DOMXPath($doc);
2930                 $entries = $xpath->query('//*');
2931
2932                 foreach ($entries as $entry) {
2933                         if (!in_array($entry->nodeName, $allowed_elements)) {
2934                                 $entry->parentNode->removeChild($entry);
2935                         }
2936
2937                         if ($entry->hasAttributes()) {
2938                                 $attrs_to_remove = array();
2939
2940                                 foreach ($entry->attributes as $attr) {
2941
2942                                         if (strpos($attr->nodeName, 'on') === 0) {
2943                                                 array_push($attrs_to_remove, $attr);
2944                                         }
2945
2946                                         if (in_array($attr->nodeName, $disallowed_attributes)) {
2947                                                 array_push($attrs_to_remove, $attr);
2948                                         }
2949                                 }
2950
2951                                 foreach ($attrs_to_remove as $attr) {
2952                                         $entry->removeAttributeNode($attr);
2953                                 }
2954                         }
2955                 }
2956
2957                 return $doc;
2958         }
2959
2960         function check_for_update() {
2961                 if (CHECK_FOR_NEW_VERSION && $_SESSION['access_level'] >= 10) {
2962                         $version_url = "http://tt-rss.org/version.php?ver=" . VERSION .
2963                                 "&iid=" . sha1(SELF_URL_PATH);
2964
2965                         $version_data = @fetch_file_contents($version_url);
2966
2967                         if ($version_data) {
2968                                 $version_data = json_decode($version_data, true);
2969                                 if ($version_data && $version_data['version']) {
2970                                         if (version_compare(VERSION_STATIC, $version_data['version']) == -1) {
2971                                                 return $version_data;
2972                                         }
2973                                 }
2974                         }
2975                 }
2976                 return false;
2977         }
2978
2979         function catchupArticlesById($ids, $cmode, $owner_uid = false) {
2980
2981                 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
2982                 if (count($ids) == 0) return;
2983
2984                 $tmp_ids = array();
2985
2986                 foreach ($ids as $id) {
2987                         array_push($tmp_ids, "ref_id = '$id'");
2988                 }
2989
2990                 $ids_qpart = join(" OR ", $tmp_ids);
2991
2992                 if ($cmode == 0) {
2993                         db_query("UPDATE ttrss_user_entries SET
2994                         unread = false,last_read = NOW()
2995                         WHERE ($ids_qpart) AND owner_uid = $owner_uid");
2996                 } else if ($cmode == 1) {
2997                         db_query("UPDATE ttrss_user_entries SET
2998                         unread = true
2999                         WHERE ($ids_qpart) AND owner_uid = $owner_uid");
3000                 } else {
3001                         db_query("UPDATE ttrss_user_entries SET
3002                         unread = NOT unread,last_read = NOW()
3003                         WHERE ($ids_qpart) AND owner_uid = $owner_uid");
3004                 }
3005
3006                 /* update ccache */
3007
3008                 $result = db_query("SELECT DISTINCT feed_id FROM ttrss_user_entries
3009                         WHERE ($ids_qpart) AND owner_uid = $owner_uid");
3010
3011                 while ($line = db_fetch_assoc($result)) {
3012                         ccache_update($line["feed_id"], $owner_uid);
3013                 }
3014         }
3015
3016         function get_article_tags($id, $owner_uid = 0, $tag_cache = false) {
3017
3018                 $a_id = db_escape_string($id);
3019
3020                 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
3021
3022                 $query = "SELECT DISTINCT tag_name,
3023                         owner_uid as owner FROM
3024                         ttrss_tags WHERE post_int_id = (SELECT int_id FROM ttrss_user_entries WHERE
3025                         ref_id = '$a_id' AND owner_uid = '$owner_uid' LIMIT 1) ORDER BY tag_name";
3026
3027                 $tags = array();
3028
3029                 /* check cache first */
3030
3031                 if ($tag_cache === false) {
3032                         $result = db_query("SELECT tag_cache FROM ttrss_user_entries
3033                                 WHERE ref_id = '$id' AND owner_uid = $owner_uid");
3034
3035                         $tag_cache = db_fetch_result($result, 0, "tag_cache");
3036                 }
3037
3038                 if ($tag_cache) {
3039                         $tags = explode(",", $tag_cache);
3040                 } else {
3041
3042                         /* do it the hard way */
3043
3044                         $tmp_result = db_query($query);
3045
3046                         while ($tmp_line = db_fetch_assoc($tmp_result)) {
3047                                 array_push($tags, $tmp_line["tag_name"]);
3048                         }
3049
3050                         /* update the cache */
3051
3052                         $tags_str = db_escape_string(join(",", $tags));
3053
3054                         db_query("UPDATE ttrss_user_entries
3055                                 SET tag_cache = '$tags_str' WHERE ref_id = '$id'
3056                                 AND owner_uid = $owner_uid");
3057                 }
3058
3059                 return $tags;
3060         }
3061
3062         function trim_array($array) {
3063                 $tmp = $array;
3064                 array_walk($tmp, 'trim');
3065                 return $tmp;
3066         }
3067
3068         function tag_is_valid($tag) {
3069                 if ($tag == '') return false;
3070                 if (preg_match("/^[0-9]*$/", $tag)) return false;
3071                 if (mb_strlen($tag) > 250) return false;
3072
3073                 if (!$tag) return false;
3074
3075                 return true;
3076         }
3077
3078         function render_login_form() {
3079                 header('Cache-Control: public');
3080
3081                 require_once "login_form.php";
3082                 exit;
3083         }
3084
3085         function format_warning($msg, $id = "") {
3086                 global $link;
3087                 return "<div class=\"warning\" id=\"$id\">
3088                         <span><img src=\"images/alert.png\"></span><span>$msg</span></div>";
3089         }
3090
3091         function format_notice($msg, $id = "") {
3092                 global $link;
3093                 return "<div class=\"notice\" id=\"$id\">
3094                         <span><img src=\"images/information.png\"></span><span>$msg</span></div>";
3095         }
3096
3097         function format_error($msg, $id = "") {
3098                 global $link;
3099                 return "<div class=\"error\" id=\"$id\">
3100                         <span><img src=\"images/alert.png\"></span><span>$msg</span></div>";
3101         }
3102
3103         function print_notice($msg) {
3104                 return print format_notice($msg);
3105         }
3106
3107         function print_warning($msg) {
3108                 return print format_warning($msg);
3109         }
3110
3111         function print_error($msg) {
3112                 return print format_error($msg);
3113         }
3114
3115
3116         function T_sprintf() {
3117                 $args = func_get_args();
3118                 return vsprintf(__(array_shift($args)), $args);
3119         }
3120
3121         function format_inline_player($url, $ctype) {
3122
3123                 $entry = "";
3124
3125                 $url = htmlspecialchars($url);
3126
3127                 if (strpos($ctype, "audio/") === 0) {
3128
3129                         if ($_SESSION["hasAudio"] && (strpos($ctype, "ogg") !== false ||
3130                                 $_SESSION["hasMp3"])) {
3131
3132                                 $entry .= "<audio preload=\"none\" controls>
3133                                         <source type=\"$ctype\" src=\"$url\"></source>
3134                                         </audio>";
3135
3136                         } else {
3137
3138                                 $entry .= "<object type=\"application/x-shockwave-flash\"
3139                                         data=\"lib/button/musicplayer.swf?song_url=$url\"
3140                                         width=\"17\" height=\"17\" style='float : left; margin-right : 5px;'>
3141                                         <param name=\"movie\"
3142                                                 value=\"lib/button/musicplayer.swf?song_url=$url\" />
3143                                         </object>";
3144                         }
3145
3146                         if ($entry) $entry .= "&nbsp; <a target=\"_blank\"
3147                                 href=\"$url\">" . basename($url) . "</a>";
3148
3149                         return $entry;
3150
3151                 }
3152
3153                 return "";
3154
3155 /*              $filename = substr($url, strrpos($url, "/")+1);
3156
3157                 $entry .= " <a target=\"_blank\" href=\"" . htmlspecialchars($url) . "\">" .
3158                         $filename . " (" . $ctype . ")" . "</a>"; */
3159
3160         }
3161
3162         function format_article($id, $mark_as_read = true, $zoom_mode = false, $owner_uid = false) {
3163                 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
3164
3165                 $rv = array();
3166
3167                 $rv['id'] = $id;
3168
3169                 /* we can figure out feed_id from article id anyway, why do we
3170                  * pass feed_id here? let's ignore the argument :(*/
3171
3172                 $result = db_query("SELECT feed_id FROM ttrss_user_entries
3173                         WHERE ref_id = '$id'");
3174
3175                 $feed_id = (int) db_fetch_result($result, 0, "feed_id");
3176
3177                 $rv['feed_id'] = $feed_id;
3178
3179                 //if (!$zoom_mode) { print "<article id='$id'><![CDATA["; };
3180
3181                 if ($mark_as_read) {
3182                         $result = db_query("UPDATE ttrss_user_entries
3183                                 SET unread = false,last_read = NOW()
3184                                 WHERE ref_id = '$id' AND owner_uid = $owner_uid");
3185
3186                         ccache_update($feed_id, $owner_uid);
3187                 }
3188
3189                 $result = db_query("SELECT id,title,link,content,feed_id,comments,int_id,lang,
3190                         ".SUBSTRING_FOR_DATE."(updated,1,16) as updated,
3191                         (SELECT site_url FROM ttrss_feeds WHERE id = feed_id) as site_url,
3192                         (SELECT title FROM ttrss_feeds WHERE id = feed_id) as feed_title,
3193                         (SELECT hide_images FROM ttrss_feeds WHERE id = feed_id) as hide_images,
3194                         (SELECT always_display_enclosures FROM ttrss_feeds WHERE id = feed_id) as always_display_enclosures,
3195                         num_comments,
3196                         tag_cache,
3197                         author,
3198                         orig_feed_id,
3199                         note
3200                         FROM ttrss_entries,ttrss_user_entries
3201                         WHERE   id = '$id' AND ref_id = id AND owner_uid = $owner_uid");
3202
3203                 if ($result) {
3204
3205                         $line = db_fetch_assoc($result);
3206
3207                         $tag_cache = $line["tag_cache"];
3208
3209                         $line["tags"] = get_article_tags($id, $owner_uid, $line["tag_cache"]);
3210                         unset($line["tag_cache"]);
3211
3212                         $line["content"] = sanitize($line["content"],
3213                                 sql_bool_to_bool($line['hide_images']),
3214                                 $owner_uid, $line["site_url"], false, $line["id"]);
3215
3216                         foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_RENDER_ARTICLE) as $p) {
3217                                 $line = $p->hook_render_article($line);
3218                         }
3219
3220                         $num_comments = $line["num_comments"];
3221                         $entry_comments = "";
3222
3223                         if ($num_comments > 0) {
3224                                 if ($line["comments"]) {
3225                                         $comments_url = htmlspecialchars($line["comments"]);
3226                                 } else {
3227                                         $comments_url = htmlspecialchars($line["link"]);
3228                                 }
3229                                 $entry_comments = "<a class=\"postComments\"
3230                                         target='_blank' href=\"$comments_url\">$num_comments ".
3231                                         _ngettext("comment", "comments", $num_comments)."</a>";
3232
3233                         } else {
3234                                 if ($line["comments"] && $line["link"] != $line["comments"]) {
3235                                         $entry_comments = "<a class=\"postComments\" target='_blank' href=\"".htmlspecialchars($line["comments"])."\">".__("comments")."</a>";
3236                                 }
3237                         }
3238
3239                         if ($zoom_mode) {
3240                                 header("Content-Type: text/html");
3241                                 $rv['content'] .= "<html><head>
3242                                                 <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"/>
3243                                                 <title>Tiny Tiny RSS - ".$line["title"]."</title>
3244                                                 <link rel=\"stylesheet\" type=\"text/css\" href=\"css/tt-rss.css\">
3245                                                 <link rel=\"shortcut icon\" type=\"image/png\" href=\"images/favicon.png\">
3246                                                 <link rel=\"icon\" type=\"image/png\" sizes=\"72x72\" href=\"images/favicon-72px.png\">
3247
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 ?>