functions.php

   1 <?php
   2
   3 /*      if ($_GET["debug"]) {
   4                 define('DEFAULT_ERROR_LEVEL', E_ALL);
   5         } else {
   6                 define('DEFAULT_ERROR_LEVEL', E_ERROR | E_WARNING | E_PARSE);
   7         } */
   8
   9         require_once 'config.php';
  10         require_once 'db-prefs.php';
  11         require_once 'compat.php';
  12         require_once 'errors.php';
  13         require_once 'version.php';
  14
  15         if (RSS_BACKEND_TYPE == "magpie") {
  16                 require_once "magpierss/rss_fetch.inc";
  17                 require_once 'magpierss/rss_utils.inc';
  18         } else if (RSS_BACKEND_TYPE == "simplepie") {
  19                 require_once 'simplepie/simplepie.inc';
  20         }
  21
  22         define('MAGPIE_OUTPUT_ENCODING', 'UTF-8');
  23
  24         function purge_feed($link, $feed_id, $purge_interval, $debug = false) {
  25
  26                 $rows = -1;
  27
  28                 if (DB_TYPE == "pgsql") {
  29 /*                      $result = db_query($link, "DELETE FROM ttrss_user_entries WHERE
  30                                 marked = false AND feed_id = '$feed_id' AND
  31                                 (SELECT date_entered FROM ttrss_entries WHERE
  32                                         id = ref_id) < NOW() - INTERVAL '$purge_interval days'"); */
  33
  34                         $pg_version = get_pgsql_version($link);
  35
  36                         if (preg_match("/^7\./", $pg_version) || preg_match("/^8\.0/", $pg_version)) {
  37
  38                                 $result = db_query($link, "DELETE FROM ttrss_user_entries WHERE
  39                                         ttrss_entries.id = ref_id AND
  40                                         marked = false AND
  41                                         feed_id = '$feed_id' AND
  42                                         ttrss_entries.date_entered < NOW() - INTERVAL '$purge_interval days'");
  43
  44                         } else {
  45
  46                                 $result = db_query($link, "DELETE FROM ttrss_user_entries
  47                                         USING ttrss_entries
  48                                         WHERE ttrss_entries.id = ref_id AND
  49                                         marked = false AND
  50                                         feed_id = '$feed_id' AND
  51                                         ttrss_entries.date_entered < NOW() - INTERVAL '$purge_interval days'");
  52                         }
  53
  54                         $rows = pg_affected_rows($result);
  55
  56                 } else {
  57
  58 /*                      $result = db_query($link, "DELETE FROM ttrss_user_entries WHERE
  59                                 marked = false AND feed_id = '$feed_id' AND
  60                                 (SELECT date_entered FROM ttrss_entries WHERE
  61                                         id = ref_id) < DATE_SUB(NOW(), INTERVAL $purge_interval DAY)"); */
  62
  63                         $result = db_query($link, "DELETE FROM ttrss_user_entries
  64                                 USING ttrss_user_entries, ttrss_entries
  65                                 WHERE ttrss_entries.id = ref_id AND
  66                                 marked = false AND
  67                                 feed_id = '$feed_id' AND
  68                                 ttrss_entries.date_entered < DATE_SUB(NOW(), INTERVAL $purge_interval DAY)");
  69
  70                         $rows = mysql_affected_rows($link);
  71
  72                 }
  73
  74                 if ($debug) {
  75                         print "Purged feed $feed_id ($purge_interval): deleted $rows articles\n";
  76                 }
  77         }
  78
  79         function global_purge_old_posts($link, $do_output = false, $limit = false) {
  80
  81                 $random_qpart = sql_random_function();
  82
  83                 if ($limit) {
  84                         $limit_qpart = "LIMIT $limit";
  85                 } else {
  86                         $limit_qpart = "";
  87                 }
  88
  89                 $result = db_query($link,
  90                         "SELECT id,purge_interval,owner_uid FROM ttrss_feeds
  91                                 ORDER BY $random_qpart $limit_qpart");
  92
  93                 while ($line = db_fetch_assoc($result)) {
  94
  95                         $feed_id = $line["id"];
  96                         $purge_interval = $line["purge_interval"];
  97                         $owner_uid = $line["owner_uid"];
  98
  99                         if ($purge_interval == 0) {
 100
 101                                 $tmp_result = db_query($link,
 102                                         "SELECT value FROM ttrss_user_prefs WHERE
 103                                                 pref_name = 'PURGE_OLD_DAYS' AND owner_uid = '$owner_uid'");
 104
 105                                 if (db_num_rows($tmp_result) != 0) {
 106                                         $purge_interval = db_fetch_result($tmp_result, 0, "value");
 107                                 }
 108                         }
 109
 110                         if ($do_output) {
 111 //                              print "Feed $feed_id: purge interval = $purge_interval\n";
 112                         }
 113
 114                         if ($purge_interval > 0) {
 115                                 purge_feed($link, $feed_id, $purge_interval, $do_output);
 116                         }
 117                 }
 118
 119                 // purge orphaned posts in main content table
 120                 db_query($link, "DELETE FROM ttrss_entries WHERE
 121                         (SELECT COUNT(int_id) FROM ttrss_user_entries WHERE ref_id = id) = 0");
 122
 123         }
 124
 125         function purge_old_posts($link) {
 126
 127                 $user_id = $_SESSION["uid"];
 128
 129                 $result = db_query($link, "SELECT id,purge_interval FROM ttrss_feeds
 130                         WHERE owner_uid = '$user_id'");
 131
 132                 while ($line = db_fetch_assoc($result)) {
 133
 134                         $feed_id = $line["id"];
 135                         $purge_interval = $line["purge_interval"];
 136
 137                         if ($purge_interval == 0) $purge_interval = get_pref($link, 'PURGE_OLD_DAYS');
 138
 139                         if ($purge_interval > 0) {
 140                                 purge_feed($link, $feed_id, $purge_interval);
 141                         }
 142                 }
 143
 144                 // purge orphaned posts in main content table
 145                 db_query($link, "DELETE FROM ttrss_entries WHERE
 146                         (SELECT COUNT(int_id) FROM ttrss_user_entries WHERE ref_id = id) = 0");
 147         }
 148
 149         function update_all_feeds($link, $fetch, $user_id = false, $force_daemon = false) {
 150
 151                 if (WEB_DEMO_MODE) return;
 152
 153                 if (!$user_id) {
 154                         $user_id = $_SESSION["uid"];
 155                         purge_old_posts($link);
 156                 }
 157
 158 //              db_query($link, "BEGIN");
 159
 160                 if (MAX_UPDATE_TIME > 0) {
 161                         if (DB_TYPE == "mysql") {
 162                                 $q_order = "RAND()";
 163                         } else {
 164                                 $q_order = "RANDOM()";
 165                         }
 166                 } else {
 167                         $q_order = "last_updated DESC";
 168                 }
 169
 170                 $result = db_query($link, "SELECT feed_url,id,
 171                         SUBSTRING(last_updated,1,19) AS last_updated,
 172                         update_interval FROM ttrss_feeds WHERE owner_uid = '$user_id'
 173                         ORDER BY $q_order");
 174
 175                 $upd_start = time();
 176
 177                 while ($line = db_fetch_assoc($result)) {
 178                         $upd_intl = $line["update_interval"];
 179
 180                         if (!$upd_intl || $upd_intl == 0) {
 181                                 $upd_intl = get_pref($link, 'DEFAULT_UPDATE_INTERVAL', $user_id);
 182                         }
 183
 184                         if ($upd_intl < 0) {
 185                                 // Updates for this feed are disabled
 186                                 continue;
 187                         }
 188
 189                         if ($fetch || (!$line["last_updated"] ||
 190                                 time() - strtotime($line["last_updated"]) > ($upd_intl * 60))) {
 191
 192 //                              print "<!-- feed: ".$line["feed_url"]." -->";
 193
 194                                 update_rss_feed($link, $line["feed_url"], $line["id"], $force_daemon);
 195
 196                                 $upd_elapsed = time() - $upd_start;
 197
 198                                 if (MAX_UPDATE_TIME > 0 && $upd_elapsed > MAX_UPDATE_TIME) {
 199                                         return;
 200                                 }
 201                         }
 202                 }
 203
 204 //              db_query($link, "COMMIT");
 205
 206         }
 207
 208         function fetch_file_contents($url) {
 209                 if (USE_CURL_FOR_ICONS) {
 210                         $tmpfile = tempnam(TMP_DIRECTORY, "ttrss-tmp");
 211
 212                         $ch = curl_init($url);
 213                         $fp = fopen($tmpfile, "w");
 214
 215                         if ($fp) {
 216                                 curl_setopt($ch, CURLOPT_FILE, $fp);
 217                                 curl_exec($ch);
 218                                 curl_close($ch);
 219                                 fclose($fp);
 220                         }
 221
 222                         $contents =  file_get_contents($tmpfile);
 223                         unlink($tmpfile);
 224
 225                         return $contents;
 226
 227                 } else {
 228                         return file_get_contents($url);
 229                 }
 230
 231         }
 232
 233         // adapted from wordpress favicon plugin by Jeff Minard (http://thecodepro.com/)
 234         // http://dev.wp-plugins.org/file/favatars/trunk/favatars.php
 235
 236         function get_favicon_url($url) {
 237
 238                 if ($html = @fetch_file_contents($url)) {
 239
 240                         if ( preg_match('/<link[^>]+rel="(?:shortcut )?icon"[^>]+?href="([^"]+?)"/si', $html, $matches)) {
 241                                 // Attempt to grab a favicon link from their webpage url
 242                                 $linkUrl = html_entity_decode($matches[1]);
 243
 244                                 if (substr($linkUrl, 0, 1) == '/') {
 245                                         $urlParts = parse_url($url);
 246                                         $faviconURL = $urlParts['scheme'].'://'.$urlParts['host'].$linkUrl;
 247                                 } else if (substr($linkUrl, 0, 7) == 'http://') {
 248                                         $faviconURL = $linkUrl;
 249                                 } else if (substr($url, -1, 1) == '/') {
 250                                         $faviconURL = $url.$linkUrl;
 251                                 } else {
 252                                         $faviconURL = $url.'/'.$linkUrl;
 253                                 }
 254
 255                         } else {
 256                                 // If unsuccessful, attempt to "guess" the favicon location
 257                                 $urlParts = parse_url($url);
 258                                 $faviconURL = $urlParts['scheme'].'://'.$urlParts['host'].'/favicon.ico';
 259                         }
 260                 }
 261
 262                 // Run a test to see if what we have attempted to get actually exists.
 263                 if(USE_CURL_FOR_ICONS || url_validate($faviconURL)) {
 264                         return $faviconURL;
 265                 } else {
 266                         return false;
 267                 }
 268         }
 269
 270         function url_validate($link) {
 271
 272                 $url_parts = @parse_url($link);
 273
 274                 if ( empty( $url_parts["host"] ) )
 275                                 return false;
 276
 277                 if ( !empty( $url_parts["path"] ) ) {
 278                                 $documentpath = $url_parts["path"];
 279                 } else {
 280                                 $documentpath = "/";
 281                 }
 282
 283                 if ( !empty( $url_parts["query"] ) )
 284                                 $documentpath .= "?" . $url_parts["query"];
 285
 286                 $host = $url_parts["host"];
 287                 $port = $url_parts["port"];
 288
 289                 if ( empty($port) )
 290                                 $port = "80";
 291
 292                 $socket = @fsockopen( $host, $port, $errno, $errstr, 30 );
 293
 294                 if ( !$socket )
 295                                 return false;
 296
 297                 fwrite ($socket, "HEAD ".$documentpath." HTTP/1.0\r\nHost: $host\r\n\r\n");
 298
 299                 $http_response = fgets( $socket, 22 );
 300
 301                 $responses = "/(200 OK)|(30[0-9] Moved)/";
 302                 if ( preg_match($responses, $http_response) ) {
 303                                 fclose($socket);
 304                                 return true;
 305                 } else {
 306                                 return false;
 307                 }
 308
 309         }
 310
 311         function check_feed_favicon($site_url, $feed, $link) {
 312                 $favicon_url = get_favicon_url($site_url);
 313
 314 #               print "FAVICON [$site_url]: $favicon_url\n";
 315
 316                 error_reporting(0);
 317
 318                 $icon_file = ICONS_DIR . "/$feed.ico";
 319
 320                 if ($favicon_url && !file_exists($icon_file)) {
 321                         $contents = fetch_file_contents($favicon_url);
 322
 323                         $fp = fopen($icon_file, "w");
 324
 325                         if ($fp) {
 326                                 fwrite($fp, $contents);
 327                                 fclose($fp);
 328                                 chmod($icon_file, 0644);
 329                         }
 330                 }
 331
 332                 error_reporting(DEFAULT_ERROR_LEVEL);
 333
 334         }
 335
 336         function update_rss_feed($link, $feed_url, $feed, $ignore_daemon = false) {
 337
 338                 if (WEB_DEMO_MODE) return;
 339
 340                 if (DAEMON_REFRESH_ONLY && !$_GET["daemon"] && !$ignore_daemon) {
 341                         return;
 342                 }
 343
 344                 $result = db_query($link, "SELECT update_interval,auth_login,auth_pass
 345                         FROM ttrss_feeds WHERE id = '$feed'");
 346
 347                 $auth_login = db_unescape_string(db_fetch_result($result, 0, "auth_login"));
 348                 $auth_pass = db_unescape_string(db_fetch_result($result, 0, "auth_pass"));
 349
 350                 $update_interval = db_fetch_result($result, 0, "update_interval");
 351
 352                 if ($update_interval < 0) { return; }
 353
 354                 $feed = db_escape_string($feed);
 355
 356                 $fetch_url = $feed_url;
 357
 358                 if ($auth_login && $auth_pass) {
 359                         $url_parts = array();
 360                         preg_match("/(^[^:]*):\/\/(.*)/", $fetch_url, $url_parts);
 361
 362                         if ($url_parts[1] && $url_parts[2]) {
 363                                 $fetch_url = $url_parts[1] . "://$auth_login:$auth_pass@" . $url_parts[2];
 364                         }
 365
 366                 }
 367
 368                 if (RSS_BACKEND_TYPE == "magpie") {
 369                         error_reporting(0);
 370                         $rss = fetch_rss($fetch_url);
 371                         error_reporting (DEFAULT_ERROR_LEVEL);
 372                 } else if (RSS_BACKEND_TYPE == "simplepie") {
 373
 374                         if (!file_exists(SIMPLEPIE_CACHE_DIR)) {
 375                                         mkdir(SIMPLEPIE_CACHE_DIR);
 376                         }
 377
 378                         $rss = new SimplePie();
 379                         $rss->feed_url($fetch_url);
 380                         $rss->cache_location(SIMPLEPIE_CACHE_DIR);
 381                         $rss->init();
 382                 }
 383
 384                 $feed = db_escape_string($feed);
 385
 386                 $rss_check = $rss;
 387
 388                 if (RSS_BACKEND_TYPE == "simplepie") {
 389                         $rss_check = $rss->data;
 390                 }
 391
 392                 if ($rss_check) {
 393
 394 //                      db_query($link, "BEGIN");
 395
 396                         $result = db_query($link, "SELECT title,icon_url,site_url,owner_uid
 397                                 FROM ttrss_feeds WHERE id = '$feed'");
 398
 399                         $registered_title = db_fetch_result($result, 0, "title");
 400                         $orig_icon_url = db_fetch_result($result, 0, "icon_url");
 401                         $orig_site_url = db_fetch_result($result, 0, "site_url");
 402
 403                         $owner_uid = db_fetch_result($result, 0, "owner_uid");
 404
 405                         if (get_pref($link, 'ENABLE_FEED_ICONS', $owner_uid, false)) {
 406                                 check_feed_favicon($rss->channel["link"], $feed, $link);
 407                         }
 408
 409                         if (!$registered_title || $registered_title == "[Unknown]") {
 410
 411                                 if (RSS_BACKEND_TYPE == "magpie") {
 412                                         $feed_title = db_escape_string($rss->channel["title"]);
 413                                 } else {
 414                                         $feed_title = $rss->get_feed_title();
 415                                 }
 416
 417                                 db_query($link, "UPDATE ttrss_feeds SET
 418                                         title = '$feed_title' WHERE id = '$feed'");
 419                         }
 420
 421                         if (RSS_BACKEND_TYPE == "magpie") {
 422                                 $site_url = $rss->channel["link"];
 423                                 // weird, weird Magpie
 424                                 if (!$site_url) $site_url = db_escape_string($rss->channel["link_"]);
 425                         } else {
 426                                 $site_url = $rss->get_feed_link();
 427                         }
 428
 429                         if ($site_url && $orig_site_url != db_escape_string($site_url)) {
 430                                 db_query($link, "UPDATE ttrss_feeds SET
 431                                         site_url = '$site_url' WHERE id = '$feed'");
 432                         }
 433
 434 //                      print "I: " . $rss->channel["image"]["url"];
 435
 436                         if (RSS_BACKEND_TYPE == "magpie") {
 437                                 $icon_url = $rss->image["url"];
 438                         } else {
 439                                 $icon_url = $rss->get_image_url(); # FIXME
 440                         }
 441
 442                         if ($icon_url && !$orig_icon_url != db_escape_string($icon_url)) {
 443                                 $icon_url = db_escape_string($icon_url);
 444                                 db_query($link, "UPDATE ttrss_feeds SET icon_url = '$icon_url' WHERE id = '$feed'");
 445                         }
 446
 447
 448                         $filters = array();
 449
 450                         $result = db_query($link, "SELECT reg_exp,
 451                                 ttrss_filter_types.name AS name,
 452                                 ttrss_filter_actions.name AS action
 453                                 FROM ttrss_filters,ttrss_filter_types,ttrss_filter_actions WHERE
 454                                         enabled = true AND
 455                                         owner_uid = $owner_uid AND
 456                                         ttrss_filter_types.id = filter_type AND
 457                                         ttrss_filter_actions.id = action_id AND
 458                                 (feed_id IS NULL OR feed_id = '$feed')");
 459
 460                         while ($line = db_fetch_assoc($result)) {
 461                                 if (!$filters[$line["name"]]) $filters[$line["name"]] = array();
 462
 463                                 $filter["reg_exp"] = $line["reg_exp"];
 464                                 $filter["action"] = $line["action"];
 465
 466                                 array_push($filters[$line["name"]], $filter);
 467                         }
 468
 469                         if (RSS_BACKEND_TYPE == "magpie") {
 470                                 $iterator = $rss->items;
 471
 472                                 if (!$iterator || !is_array($iterator)) $iterator = $rss->entries;
 473                                 if (!$iterator || !is_array($iterator)) $iterator = $rss;
 474
 475                         } else {
 476                                 $iterator = $rss->get_items();
 477                         }
 478
 479                         if (!is_array($iterator)) {
 480                                 /* db_query($link, "UPDATE ttrss_feeds
 481                                         SET last_error = 'Parse error: can\'t find any articles.'
 482                                                 WHERE id = '$feed'"); */
 483                                 return; // WTF?
 484                         }
 485
 486                         foreach ($iterator as $item) {
 487
 488                                 if (RSS_BACKEND_TYPE == "magpie") {
 489
 490                                         $entry_guid = $item["id"];
 491
 492                                         if (!$entry_guid) $entry_guid = $item["guid"];
 493                                         if (!$entry_guid) $entry_guid = $item["link"];
 494                                         if (!$entry_guid) $entry_guid = make_guid_from_title($item["title"]);
 495
 496                                         if (!$entry_guid) continue;
 497
 498                                         $entry_timestamp = "";
 499
 500                                         $rss_2_date = $item['pubdate'];
 501                                         $rss_1_date = $item['dc']['date'];
 502                                         $atom_date = $item['issued'];
 503                                         if (!$atom_date) $atom_date = $item['updated'];
 504
 505                                         if ($atom_date != "") $entry_timestamp = parse_w3cdtf($atom_date);
 506                                         if ($rss_1_date != "") $entry_timestamp = parse_w3cdtf($rss_1_date);
 507                                         if ($rss_2_date != "") $entry_timestamp = strtotime($rss_2_date);
 508
 509                                         if ($entry_timestamp == "") {
 510                                                 $entry_timestamp = time();
 511                                                 $no_orig_date = 'true';
 512                                         } else {
 513                                                 $no_orig_date = 'false';
 514                                         }
 515
 516                                         $entry_timestamp_fmt = strftime("%Y/%m/%d %H:%M:%S", $entry_timestamp);
 517
 518                                         $entry_title = trim(strip_tags($item["title"]));
 519
 520                                         // strange Magpie workaround
 521                                         $entry_link = $item["link_"];
 522                                         if (!$entry_link) $entry_link = $item["link"];
 523
 524                                         if (!$entry_title) continue;
 525 #                                       if (!$entry_link) continue;
 526
 527                                         $entry_link = strip_tags($entry_link);
 528
 529                                         $entry_content = $item["content:escaped"];
 530
 531                                         if (!$entry_content) $entry_content = $item["content:encoded"];
 532                                         if (!$entry_content) $entry_content = $item["content"];
 533                                         if (!$entry_content) $entry_content = $item["atom_content"];
 534                                         if (!$entry_content) $entry_content = $item["summary"];
 535                                         if (!$entry_content) $entry_content = $item["description"];
 536
 537         //                              if (!$entry_content) continue;
 538
 539                                         // WTF
 540                                         if (is_array($entry_content)) {
 541                                                 $entry_content = $entry_content["encoded"];
 542                                                 if (!$entry_content) $entry_content = $entry_content["escaped"];
 543                                         }
 544
 545         //                              print_r($item);
 546         //                              print_r(htmlspecialchars($entry_content));
 547         //                              print "<br>";
 548
 549                                         $entry_content_unescaped = $entry_content;
 550                                         $content_hash = "SHA1:" . sha1(strip_tags($entry_content));
 551
 552                                         $entry_comments = strip_tags($item["comments"]);
 553
 554                                         $entry_author = db_escape_string(strip_tags($item['dc']['creator']));
 555                                         $entry_guid = db_escape_string(strip_tags($entry_guid));
 556
 557                                         $result = db_query($link, "SELECT id FROM       ttrss_entries
 558                                                 WHERE guid = '$entry_guid'");
 559
 560                                         $entry_content = db_escape_string($entry_content);
 561                                         $entry_title = db_escape_string($entry_title);
 562                                         $entry_link = db_escape_string($entry_link);
 563                                         $entry_comments = db_escape_string($entry_comments);
 564
 565                                         $num_comments = db_escape_string($item["slash"]["comments"]);
 566
 567                                         if (!$num_comments) $num_comments = 0;
 568                                 }
 569
 570                                 # sanitize content
 571
 572                                 $entry_content = sanitize_rss($entry_content);
 573
 574                                 db_query($link, "BEGIN");
 575
 576                                 if (db_num_rows($result) == 0) {
 577
 578                                         // base post entry does not exist, create it
 579
 580                                         $result = db_query($link,
 581                                                 "INSERT INTO ttrss_entries
 582                                                         (title,
 583                                                         guid,
 584                                                         link,
 585                                                         updated,
 586                                                         content,
 587                                                         content_hash,
 588                                                         no_orig_date,
 589                                                         date_entered,
 590                                                         comments,
 591                                                         num_comments,
 592                                                         author)
 593                                                 VALUES
 594                                                         ('$entry_title',
 595                                                         '$entry_guid',
 596                                                         '$entry_link',
 597                                                         '$entry_timestamp_fmt',
 598                                                         '$entry_content',
 599                                                         '$content_hash',
 600                                                         $no_orig_date,
 601                                                         NOW(),
 602                                                         '$entry_comments',
 603                                                         '$num_comments',
 604                                                         '$entry_author')");
 605                                 } else {
 606                                         // we keep encountering the entry in feeds, so we need to
 607                                         // update date_entered column so that we don't get horrible
 608                                         // dupes when the entry gets purged and reinserted again e.g.
 609                                         // in the case of SLOW SLOW OMG SLOW updating feeds
 610
 611                                         $base_entry_id = db_fetch_result($result, 0, "id");
 612
 613                                         db_query($link, "UPDATE ttrss_entries SET date_entered = NOW()
 614                                                 WHERE id = '$base_entry_id'");
 615                                 }
 616
 617                                 // now it should exist, if not - bad luck then
 618
 619                                 $result = db_query($link, "SELECT
 620                                                 id,content_hash,no_orig_date,title,
 621                                                 substring(date_entered,1,19) as date_entered,
 622                                                 substring(updated,1,19) as updated,
 623                                                 num_comments
 624                                         FROM
 625                                                 ttrss_entries
 626                                         WHERE guid = '$entry_guid'");
 627
 628                                 if (db_num_rows($result) == 1) {
 629
 630                                         // this will be used below in update handler
 631                                         $orig_content_hash = db_fetch_result($result, 0, "content_hash");
 632                                         $orig_title = db_fetch_result($result, 0, "title");
 633                                         $orig_num_comments = db_fetch_result($result, 0, "num_comments");
 634                                         $orig_date_entered = strtotime(db_fetch_result($result,
 635                                                 0, "date_entered"));
 636
 637                                         $ref_id = db_fetch_result($result, 0, "id");
 638
 639                                         // check for user post link to main table
 640
 641                                         // do we allow duplicate posts with same GUID in different feeds?
 642                                         if (get_pref($link, "ALLOW_DUPLICATE_POSTS", $owner_uid, false)) {
 643                                                 $dupcheck_qpart = "AND feed_id = '$feed'";
 644                                         } else {
 645                                                 $dupcheck_qpart = "";
 646                                         }
 647
 648 //                                      error_reporting(0);
 649
 650                                         $filter_name = get_filter_name($entry_title, $entry_content,
 651                                                 $entry_link, $filters);
 652
 653                                         if ($filter_name == "filter") {
 654                                                 continue;
 655                                         }
 656
 657 //                                      error_reporting (DEFAULT_ERROR_LEVEL);
 658
 659                                         $result = db_query($link,
 660                                                 "SELECT ref_id FROM ttrss_user_entries WHERE
 661                                                         ref_id = '$ref_id' AND owner_uid = '$owner_uid'
 662                                                         $dupcheck_qpart");
 663
 664                                         // okay it doesn't exist - create user entry
 665                                         if (db_num_rows($result) == 0) {
 666
 667                                                 if ($filter_name != 'catchup') {
 668                                                         $unread = 'true';
 669                                                         $last_read_qpart = 'NULL';
 670                                                 } else {
 671                                                         $unread = 'false';
 672                                                         $last_read_qpart = 'NOW()';
 673                                                 }
 674
 675                                                 if ($filter_name == 'mark') {
 676                                                         $marked = 'true';
 677                                                 } else {
 678                                                         $marked = 'false';
 679                                                 }
 680
 681                                                 $result = db_query($link,
 682                                                         "INSERT INTO ttrss_user_entries
 683                                                                 (ref_id, owner_uid, feed_id, unread, last_read, marked)
 684                                                         VALUES ('$ref_id', '$owner_uid', '$feed', $unread,
 685                                                                 $last_read_qpart, $marked)");
 686                                         }
 687
 688                                         $post_needs_update = false;
 689
 690                                         if (get_pref($link, "UPDATE_POST_ON_CHECKSUM_CHANGE", $owner_uid, false) &&
 691                                                 ($content_hash != $orig_content_hash)) {
 692                                                 $post_needs_update = true;
 693                                         }
 694
 695                                         if ($orig_title != $entry_title) {
 696                                                 $post_needs_update = true;
 697                                         }
 698
 699                                         if ($orig_num_comments != $num_comments) {
 700                                                 $post_needs_update = true;
 701                                         }
 702
 703 //                                      this doesn't seem to be very reliable
 704 //
 705 //                                      if ($orig_timestamp != $entry_timestamp && !$orig_no_orig_date) {
 706 //                                              $post_needs_update = true;
 707 //                                      }
 708
 709                                         // if post needs update, update it and mark all user entries
 710                                         // linking to this post as updated
 711                                         if ($post_needs_update) {
 712
 713 //                                              print "<!-- post $orig_title needs update : $post_needs_update -->";
 714
 715                                                 db_query($link, "UPDATE ttrss_entries
 716                                                         SET title = '$entry_title', content = '$entry_content',
 717                                                                 num_comments = '$num_comments'
 718                                                         WHERE id = '$ref_id'");
 719
 720                                                 if (get_pref($link, "MARK_UNREAD_ON_UPDATE", $owner_uid, false)) {
 721                                                         db_query($link, "UPDATE ttrss_user_entries
 722                                                                 SET last_read = null, unread = true WHERE ref_id = '$ref_id'");
 723                                                 } else {
 724                                                         db_query($link, "UPDATE ttrss_user_entries
 725                                                                 SET last_read = null WHERE ref_id = '$ref_id' AND unread = false");
 726                                                 }
 727
 728                                         }
 729                                 }
 730
 731                                 db_query($link, "COMMIT");
 732
 733                                 /* taaaags */
 734                                 // <a href="http://technorati.com/tag/Xorg" rel="tag">Xorg</a>, //
 735
 736                                 $entry_tags = null;
 737
 738                                 preg_match_all("/<a.*?href=.http:\/\/.*?technorati.com\/tag\/([^\"\'>]+)/i",
 739                                         $entry_content_unescaped, $entry_tags);
 740
 741 //                              print "<br>$entry_title : $entry_content_unescaped<br>";
 742 //                              print_r($entry_tags);
 743 //                              print "<br>";
 744
 745                                 $entry_tags = $entry_tags[1];
 746
 747                                 if (count($entry_tags) > 0) {
 748
 749                                         db_query($link, "BEGIN");
 750
 751                                         $result = db_query($link, "SELECT id,int_id
 752                                                 FROM ttrss_entries,ttrss_user_entries
 753                                                 WHERE guid = '$entry_guid'
 754                                                 AND feed_id = '$feed' AND ref_id = id
 755                                                 AND owner_uid = '$owner_uid'");
 756
 757                                         if (db_num_rows($result) == 1) {
 758
 759                                                 $entry_id = db_fetch_result($result, 0, "id");
 760                                                 $entry_int_id = db_fetch_result($result, 0, "int_id");
 761
 762                                                 foreach ($entry_tags as $tag) {
 763                                                         $tag = db_escape_string(strtolower($tag));
 764
 765                                                         $tag = str_replace("+", " ", $tag);
 766                                                         $tag = str_replace("technorati tag: ", "", $tag);
 767
 768                                                         $result = db_query($link, "SELECT id FROM ttrss_tags
 769                                                                 WHERE tag_name = '$tag' AND post_int_id = '$entry_int_id' AND
 770                                                                 owner_uid = '$owner_uid' LIMIT 1");
 771
 772         //                                              print db_fetch_result($result, 0, "id");
 773
 774                                                         if ($result && db_num_rows($result) == 0) {
 775
 776         //                                                      print "tagging $entry_id as $tag<br>";
 777
 778                                                                 db_query($link, "INSERT INTO ttrss_tags
 779                                                                         (owner_uid,tag_name,post_int_id)
 780                                                                         VALUES ('$owner_uid','$tag', '$entry_int_id')");
 781                                                         }
 782                                                 }
 783                                         }
 784                                         db_query($link, "COMMIT");
 785                                 }
 786                         }
 787
 788                         db_query($link, "UPDATE ttrss_feeds
 789                                 SET last_updated = NOW(), last_error = '' WHERE id = '$feed'");
 790
 791 //                      db_query($link, "COMMIT");
 792
 793                 } else {
 794                         $error_msg = db_escape_string(magpie_error());
 795                         db_query($link,
 796                                 "UPDATE ttrss_feeds SET last_error = '$error_msg',
 797                                         last_updated = NOW() WHERE id = '$feed'");
 798                 }
 799
 800         }
 801
 802         function print_select($id, $default, $values, $attributes = "") {
 803                 print "<select name=\"$id\" id=\"$id\" $attributes>";
 804                 foreach ($values as $v) {
 805                         if ($v == $default)
 806                                 $sel = " selected";
 807                          else
 808                                 $sel = "";
 809
 810                         print "<option$sel>$v</option>";
 811                 }
 812                 print "</select>";
 813         }
 814
 815         function print_select_hash($id, $default, $values, $attributes = "") {
 816                 print "<select name=\"$id\" id='$id' $attributes>";
 817                 foreach (array_keys($values) as $v) {
 818                         if ($v == $default)
 819                                 $sel = "selected";
 820                          else
 821                                 $sel = "";
 822
 823                         print "<option $sel value=\"$v\">".$values[$v]."</option>";
 824                 }
 825
 826                 print "</select>";
 827         }
 828
 829         function get_filter_name($title, $content, $link, $filters) {
 830
 831                 if ($filters["title"]) {
 832                         foreach ($filters["title"] as $filter) {
 833                                 $reg_exp = $filter["reg_exp"];
 834                                 if (preg_match("/$reg_exp/i", $title)) {
 835                                         return $filter["action"];
 836                                 }
 837                         }
 838                 }
 839
 840                 if ($filters["content"]) {
 841                         foreach ($filters["content"] as $filter) {
 842                                 $reg_exp = $filter["reg_exp"];
 843                                 if (preg_match("/$reg_exp/i", $content)) {
 844                                         return $filter["action"];
 845                                 }
 846                         }
 847                 }
 848
 849                 if ($filters["both"]) {
 850                         foreach ($filters["both"] as $filter) {
 851                                 $reg_exp = $filter["reg_exp"];
 852                                 if (preg_match("/$reg_exp/i", $title) ||
 853                                         preg_match("/$reg_exp/i", $content)) {
 854                                         return $filter["action"];
 855                                 }
 856                         }
 857                 }
 858
 859                 if ($filters["link"]) {
 860                         $reg_exp = $filter["reg_exp"];
 861                         foreach ($filters["link"] as $filter) {
 862                                 $reg_exp = $filter["reg_exp"];
 863                                 if (preg_match("/$reg_exp/i", $link)) {
 864                                         return $filter["action"];
 865                                 }
 866                         }
 867                 }
 868
 869                 return false;
 870         }
 871
 872         function printFeedEntry($feed_id, $class, $feed_title, $unread, $icon_file, $link,
 873                 $rtl_content = false, $last_updated = false, $last_error = false) {
 874
 875                 if (file_exists($icon_file) && filesize($icon_file) > 0) {
 876                                 $feed_icon = "<img id=\"FIMG-$feed_id\" src=\"$icon_file\">";
 877                 } else {
 878                         $feed_icon = "<img id=\"FIMG-$feed_id\" src=\"images/blank_icon.gif\">";
 879                 }
 880
 881                 if ($rtl_content) {
 882                         $rtl_tag = "dir=\"rtl\"";
 883                 } else {
 884                         $rtl_tag = "dir=\"ltr\"";
 885                 }
 886
 887                 $error_notify_msg = "";
 888
 889                 if ($last_error) {
 890                         $link_title = "Error: $last_error ($last_updated)";
 891                         $error_notify_msg = "(Error)";
 892                 } else if ($last_updated) {
 893                         $link_title = "Updated: $last_updated";
 894                 }
 895
 896                 $feed = "<a title=\"$link_title\" id=\"FEEDL-$feed_id\" href=\"javascript:viewfeed('$feed_id', '', false);\">$feed_title</a>";
 897
 898                 print "<li id=\"FEEDR-$feed_id\" class=\"$class\">";
 899                 if (get_pref($link, 'ENABLE_FEED_ICONS')) {
 900                         print "$feed_icon";
 901                 }
 902
 903                 print "<span $rtl_tag id=\"FEEDN-$feed_id\">$feed</span>";
 904
 905                 if ($unread != 0) {
 906                         $fctr_class = "";
 907                 } else {
 908                         $fctr_class = "class=\"invisible\"";
 909                 }
 910
 911                 print " <span $rtl_tag $fctr_class id=\"FEEDCTR-$feed_id\">
 912                          (<span id=\"FEEDU-$feed_id\">$unread</span>)</span>";
 913
 914                 if (get_pref($link, "EXTENDED_FEEDLIST")) {
 915                         print "<div class=\"feedExtInfo\">
 916                                 <span id=\"FLUPD-$feed_id\">$last_updated $error_notify_msg</span></div>";
 917                 }
 918
 919                 print "</li>";
 920
 921         }
 922
 923         function getmicrotime() {
 924                 list($usec, $sec) = explode(" ",microtime());
 925                 return ((float)$usec + (float)$sec);
 926         }
 927
 928         function print_radio($id, $default, $values, $attributes = "") {
 929                 foreach ($values as $v) {
 930
 931                         if ($v == $default)
 932                                 $sel = "checked";
 933                          else
 934                                 $sel = "";
 935
 936                         if ($v == "Yes") {
 937                                 $sel .= " value=\"1\"";
 938                         } else {
 939                                 $sel .= " value=\"0\"";
 940                         }
 941
 942                         print "<input class=\"noborder\"
 943                                 type=\"radio\" $sel $attributes name=\"$id\">&nbsp;$v&nbsp;";
 944
 945                 }
 946         }
 947
 948         function initialize_user_prefs($link, $uid) {
 949
 950                 $uid = db_escape_string($uid);
 951
 952                 db_query($link, "BEGIN");
 953
 954                 $result = db_query($link, "SELECT pref_name,def_value FROM ttrss_prefs");
 955
 956                 $u_result = db_query($link, "SELECT pref_name
 957                         FROM ttrss_user_prefs WHERE owner_uid = '$uid'");
 958
 959                 $active_prefs = array();
 960
 961                 while ($line = db_fetch_assoc($u_result)) {
 962                         array_push($active_prefs, $line["pref_name"]);
 963                 }
 964
 965                 while ($line = db_fetch_assoc($result)) {
 966                         if (array_search($line["pref_name"], $active_prefs) === FALSE) {
 967 //                              print "adding " . $line["pref_name"] . "<br>";
 968
 969                                 db_query($link, "INSERT INTO ttrss_user_prefs
 970                                         (owner_uid,pref_name,value) VALUES
 971                                         ('$uid', '".$line["pref_name"]."','".$line["def_value"]."')");
 972
 973                         }
 974                 }
 975
 976                 db_query($link, "COMMIT");
 977
 978         }
 979
 980         function lookup_user_id($link, $user) {
 981
 982                 $result = db_query($link, "SELECT id FROM ttrss_users WHERE
 983                         login = '$login'");
 984
 985                 if (db_num_rows($result) == 1) {
 986                         return db_fetch_result($result, 0, "id");
 987                 } else {
 988                         return false;
 989                 }
 990         }
 991
 992         function http_authenticate_user($link) {
 993
 994                 if (!$_SERVER["PHP_AUTH_USER"]) {
 995
 996                         header('WWW-Authenticate: Basic realm="Tiny Tiny RSS RSSGen"');
 997                         header('HTTP/1.0 401 Unauthorized');
 998                         exit;
 999
1000                 } else {
1001                         $auth_result = authenticate_user($link,
1002                                 $_SERVER["PHP_AUTH_USER"], $_SERVER["PHP_AUTH_PW"]);
1003
1004                         if (!$auth_result) {
1005                                 header('WWW-Authenticate: Basic realm="Tiny Tiny RSS RSSGen"');
1006                                 header('HTTP/1.0 401 Unauthorized');
1007                                 exit;
1008                         }
1009                 }
1010
1011                 return true;
1012         }
1013
1014         function authenticate_user($link, $login, $password) {
1015
1016                 if (!SINGLE_USER_MODE) {
1017
1018                         $pwd_hash = 'SHA1:' . sha1($password);
1019
1020                         $result = db_query($link, "SELECT id,login,access_level FROM ttrss_users WHERE
1021                                 login = '$login' AND pwd_hash = '$pwd_hash'");
1022
1023                         if (db_num_rows($result) == 1) {
1024                                 $_SESSION["uid"] = db_fetch_result($result, 0, "id");
1025                                 $_SESSION["name"] = db_fetch_result($result, 0, "login");
1026                                 $_SESSION["access_level"] = db_fetch_result($result, 0, "access_level");
1027
1028                                 db_query($link, "UPDATE ttrss_users SET last_login = NOW() WHERE id = " .
1029                                         $_SESSION["uid"]);
1030
1031                                 $user_theme = get_user_theme_path($link);
1032
1033                                 $_SESSION["theme"] = $user_theme;
1034                                 $_SESSION["ip_address"] = $_SERVER["REMOTE_ADDR"];
1035
1036                                 initialize_user_prefs($link, $_SESSION["uid"]);
1037
1038                                 return true;
1039                         }
1040
1041                         return false;
1042
1043                 } else {
1044
1045                         $_SESSION["uid"] = 1;
1046                         $_SESSION["name"] = "admin";
1047
1048                         $user_theme = get_user_theme_path($link);
1049
1050                         $_SESSION["theme"] = $user_theme;
1051                         $_SESSION["ip_address"] = $_SERVER["REMOTE_ADDR"];
1052
1053                         initialize_user_prefs($link, $_SESSION["uid"]);
1054
1055                         return true;
1056                 }
1057         }
1058
1059         function make_password($length = 8) {
1060
1061                 $password = "";
1062                 $possible = "0123456789abcdfghjkmnpqrstvwxyzABCDFGHJKMNPQRSTVWXYZ";
1063
1064         $i = 0;
1065
1066                 while ($i < $length) {
1067                         $char = substr($possible, mt_rand(0, strlen($possible)-1), 1);
1068
1069                         if (!strstr($password, $char)) {
1070                                 $password .= $char;
1071                                 $i++;
1072                         }
1073                 }
1074                 return $password;
1075         }
1076
1077         // this is called after user is created to initialize default feeds, labels
1078         // or whatever else
1079
1080         // user preferences are checked on every login, not here
1081
1082         function initialize_user($link, $uid) {
1083
1084                 db_query($link, "insert into ttrss_labels (owner_uid,sql_exp,description)
1085                         values ('$uid','unread = true', 'Unread articles')");
1086
1087                 db_query($link, "insert into ttrss_labels (owner_uid,sql_exp,description)
1088                         values ('$uid','last_read is null and unread = false', 'Updated articles')");
1089
1090                 db_query($link, "insert into ttrss_feeds (owner_uid,title,feed_url)
1091                         values ('$uid', 'Tiny Tiny RSS: New Releases',
1092                         'http://tt-rss.spb.ru/releases.rss')");
1093
1094         }
1095
1096         function logout_user() {
1097                 session_destroy();
1098                 if (isset($_COOKIE[session_name()])) {
1099                    setcookie(session_name(), '', time()-42000, '/');
1100                 }
1101         }
1102
1103         function get_script_urlpath() {
1104                 return preg_replace('/\/[^\/]*$/', "", $_SERVER["REQUEST_URI"]);
1105         }
1106
1107         function get_login_redirect() {
1108                 $server = $_SERVER["SERVER_NAME"];
1109
1110                 if (ENABLE_LOGIN_SSL) {
1111                         $protocol = "https";
1112                 } else {
1113                         $protocol = "http";
1114                 }
1115
1116                 $url_path = get_script_urlpath();
1117
1118                 $redirect_uri = "$protocol://$server$url_path/login.php";
1119
1120                 return $redirect_uri;
1121         }
1122
1123         function validate_session($link) {
1124                 if (SESSION_CHECK_ADDRESS && $_SESSION["uid"]) {
1125                         if ($_SESSION["ip_address"]) {
1126                                 if ($_SESSION["ip_address"] != $_SERVER["REMOTE_ADDR"]) {
1127                                         return false;
1128                                 }
1129                         }
1130                 }
1131                 return true;
1132         }
1133
1134         function basic_nosid_redirect_check() {
1135                 if (!SINGLE_USER_MODE) {
1136                         if (!$_COOKIE[get_session_cookie_name()]) {
1137                                 $redirect_uri = get_login_redirect();
1138                                 $return_to = preg_replace('/.*?\//', '', $_SERVER["REQUEST_URI"]);
1139                                 header("Location: $redirect_uri?rt=$return_to");
1140                                 exit;
1141                         }
1142                 }
1143         }
1144
1145         function login_sequence($link) {
1146                 if (!SINGLE_USER_MODE) {
1147
1148                         if (!validate_session($link)) {
1149                                 logout_user();
1150                                 $redirect_uri = get_login_redirect();
1151                                 $return_to = preg_replace('/.*?\//', '', $_SERVER["REQUEST_URI"]);
1152                                 header("Location: $redirect_uri?rt=$return_to");
1153                                 exit;
1154                         }
1155
1156                         if (!USE_HTTP_AUTH) {
1157                                 if (!$_SESSION["uid"]) {
1158                                         $redirect_uri = get_login_redirect();
1159                                         $return_to = preg_replace('/.*?\//', '', $_SERVER["REQUEST_URI"]);
1160                                         header("Location: $redirect_uri?rt=$return_to");
1161                                         exit;
1162                                 }
1163                         } else {
1164                                 if (!$_SESSION["uid"]) {
1165                                         if (!$_SERVER["PHP_AUTH_USER"]) {
1166
1167                                                 header('WWW-Authenticate: Basic realm="Tiny Tiny RSS"');
1168                                                 header('HTTP/1.0 401 Unauthorized');
1169                                                 exit;
1170
1171                                         } else {
1172                                                 $auth_result = authenticate_user($link,
1173                                                         $_SERVER["PHP_AUTH_USER"], $_SERVER["PHP_AUTH_PW"]);
1174
1175                                                 if (!$auth_result) {
1176                                                         header('WWW-Authenticate: Basic realm="Tiny Tiny RSS"');
1177                                                         header('HTTP/1.0 401 Unauthorized');
1178                                                         exit;
1179                                                 }
1180                                         }
1181                                 }
1182                         }
1183                 } else {
1184                         return authenticate_user($link, "admin", null);
1185                 }
1186         }
1187
1188         function truncate_string($str, $max_len) {
1189                 if (mb_strlen($str, "utf-8") > $max_len - 3) {
1190                         return mb_substr($str, 0, $max_len, "utf-8") . "...";
1191                 } else {
1192                         return $str;
1193                 }
1194         }
1195
1196         function get_user_theme_path($link) {
1197                 $result = db_query($link, "SELECT theme_path
1198                         FROM
1199                                 ttrss_themes,ttrss_users
1200                         WHERE ttrss_themes.id = theme_id AND ttrss_users.id = " . $_SESSION["uid"]);
1201                 if (db_num_rows($result) != 0) {
1202                         return db_fetch_result($result, 0, "theme_path");
1203                 } else {
1204                         return null;
1205                 }
1206         }
1207
1208         function smart_date_time($timestamp) {
1209                 if (date("Y.m.d", $timestamp) == date("Y.m.d")) {
1210                         return date("G:i", $timestamp);
1211                 } else if (date("Y", $timestamp) == date("Y")) {
1212                         return date("M d, G:i", $timestamp);
1213                 } else {
1214                         return date("Y/m/d G:i", $timestamp);
1215                 }
1216         }
1217
1218         function smart_date($timestamp) {
1219                 if (date("Y.m.d", $timestamp) == date("Y.m.d")) {
1220                         return "Today";
1221                 } else if (date("Y", $timestamp) == date("Y")) {
1222                         return date("D m", $timestamp);
1223                 } else {
1224                         return date("Y/m/d", $timestamp);
1225                 }
1226         }
1227
1228         function sql_bool_to_string($s) {
1229                 if ($s == "t" || $s == "1") {
1230                         return "true";
1231                 } else {
1232                         return "false";
1233                 }
1234         }
1235
1236         function sql_bool_to_bool($s) {
1237                 if ($s == "t" || $s == "1") {
1238                         return true;
1239                 } else {
1240                         return false;
1241                 }
1242         }
1243
1244
1245         function toggleEvenOdd($a) {
1246                 if ($a == "even")
1247                         return "odd";
1248                 else
1249                         return "even";
1250         }
1251
1252         function sanity_check($link) {
1253
1254                 error_reporting(0);
1255
1256                 $error_code = 0;
1257                 $result = db_query($link, "SELECT schema_version FROM ttrss_version");
1258                 $schema_version = db_fetch_result($result, 0, "schema_version");
1259
1260                 if ($schema_version != SCHEMA_VERSION) {
1261                         $error_code = 5;
1262                 }
1263
1264                 if (DB_TYPE == "mysql") {
1265                         $result = db_query($link, "SELECT true", false);
1266                         if (db_num_rows($result) != 1) {
1267                                 $error_code = 10;
1268                         }
1269                 }
1270
1271                 error_reporting (DEFAULT_ERROR_LEVEL);
1272
1273                 if ($error_code != 0) {
1274                         print_error_xml($error_code);
1275                         return false;
1276                 } else {
1277                         return true;
1278                 }
1279         }
1280
1281         function file_is_locked($filename) {
1282                 error_reporting(0);
1283                 $fp = fopen($filename, "r");
1284                 error_reporting(DEFAULT_ERROR_LEVEL);
1285                 if ($fp) {
1286                         if (flock($fp, LOCK_EX | LOCK_NB)) {
1287                                 flock($fp, LOCK_UN);
1288                                 fclose($fp);
1289                                 return false;
1290                         }
1291                         fclose($fp);
1292                         return true;
1293                 }
1294                 return false;
1295         }
1296
1297         function make_lockfile($filename) {
1298                 $fp = fopen($filename, "w");
1299
1300                 if (flock($fp, LOCK_EX | LOCK_NB)) {
1301                         return $fp;
1302                 } else {
1303                         return false;
1304                 }
1305         }
1306
1307         function sql_random_function() {
1308                 if (DB_TYPE == "mysql") {
1309                         return "RAND()";
1310                 } else {
1311                         return "RANDOM()";
1312                 }
1313         }
1314
1315         function catchup_feed($link, $feed, $cat_view) {
1316
1317                         if (preg_match("/^-?[0-9][0-9]*$/", $feed) != false) {
1318
1319                                 if ($cat_view) {
1320
1321                                         if ($feed > 0) {
1322                                                 $cat_qpart = "cat_id = '$feed'";
1323                                         } else {
1324                                                 $cat_qpart = "cat_id IS NULL";
1325                                         }
1326
1327                                         $tmp_result = db_query($link, "SELECT id
1328                                                 FROM ttrss_feeds WHERE $cat_qpart AND owner_uid = " .
1329                                                 $_SESSION["uid"]);
1330
1331                                         while ($tmp_line = db_fetch_assoc($tmp_result)) {
1332
1333                                                 $tmp_feed = $tmp_line["id"];
1334
1335                                                 db_query($link, "UPDATE ttrss_user_entries
1336                                                         SET unread = false,last_read = NOW()
1337                                                         WHERE feed_id = '$tmp_feed' AND owner_uid = " . $_SESSION["uid"]);
1338                                         }
1339
1340                                 } else if ($feed > 0) {
1341
1342                                         $tmp_result = db_query($link, "SELECT id
1343                                                 FROM ttrss_feeds WHERE parent_feed = '$feed'
1344                                                 ORDER BY cat_id,title");
1345
1346                                         $parent_ids = array();
1347
1348                                         if (db_num_rows($tmp_result) > 0) {
1349                                                 while ($p = db_fetch_assoc($tmp_result)) {
1350                                                         array_push($parent_ids, "feed_id = " . $p["id"]);
1351                                                 }
1352
1353                                                 $children_qpart = implode(" OR ", $parent_ids);
1354
1355                                                 db_query($link, "UPDATE ttrss_user_entries
1356                                                         SET unread = false,last_read = NOW()
1357                                                         WHERE (feed_id = '$feed' OR $children_qpart)
1358                                                         AND owner_uid = " . $_SESSION["uid"]);
1359
1360                                         } else {
1361                                                 db_query($link, "UPDATE ttrss_user_entries
1362                                                         SET unread = false,last_read = NOW()
1363                                                         WHERE feed_id = '$feed' AND owner_uid = " . $_SESSION["uid"]);
1364                                         }
1365
1366                                 } else if ($feed < 0 && $feed > -10) { // special, like starred
1367
1368                                         if ($feed == -1) {
1369                                                 db_query($link, "UPDATE ttrss_user_entries
1370                                                         SET unread = false,last_read = NOW()
1371                                                         WHERE marked = true AND owner_uid = ".$_SESSION["uid"]);
1372                                         }
1373
1374                                 } else if ($feed < -10) { // label
1375
1376                                         // TODO make this more efficient
1377
1378                                         $label_id = -$feed - 11;
1379
1380                                         $tmp_result = db_query($link, "SELECT sql_exp FROM ttrss_labels
1381                                                 WHERE id = '$label_id'");
1382
1383                                         if ($tmp_result) {
1384                                                 $sql_exp = db_fetch_result($tmp_result, 0, "sql_exp");
1385
1386                                                 db_query($link, "BEGIN");
1387
1388                                                 $tmp2_result = db_query($link,
1389                                                         "SELECT
1390                                                                 int_id
1391                                                         FROM
1392                                                                 ttrss_user_entries,ttrss_entries,ttrss_feeds
1393                                                         WHERE
1394                                                                 ref_id = ttrss_entries.id AND
1395                                                                 ttrss_user_entries.feed_id = ttrss_feeds.id AND
1396                                                                 $sql_exp AND
1397                                                                 ttrss_user_entries.owner_uid = " . $_SESSION["uid"]);
1398
1399                                                 while ($tmp_line = db_fetch_assoc($tmp2_result)) {
1400                                                         db_query($link, "UPDATE
1401                                                                 ttrss_user_entries
1402                                                         SET
1403                                                                 unread = false, last_read = NOW()
1404                                                         WHERE
1405                                                                 int_id = " . $tmp_line["int_id"]);
1406                                                 }
1407
1408                                                 db_query($link, "COMMIT");
1409
1410 /*                                              db_query($link, "UPDATE ttrss_user_entries,ttrss_entries
1411                                                         SET unread = false,last_read = NOW()
1412                                                         WHERE $sql_exp
1413                                                         AND ref_id = id
1414                                                         AND owner_uid = ".$_SESSION["uid"]); */
1415                                         }
1416                                 }
1417                         } else { // tag
1418                                 db_query($link, "BEGIN");
1419
1420                                 $tag_name = db_escape_string($feed);
1421
1422                                 $result = db_query($link, "SELECT post_int_id FROM ttrss_tags
1423                                         WHERE tag_name = '$tag_name' AND owner_uid = " . $_SESSION["uid"]);
1424
1425                                 while ($line = db_fetch_assoc($result)) {
1426                                         db_query($link, "UPDATE ttrss_user_entries SET
1427                                                 unread = false, last_read = NOW()
1428                                                 WHERE int_id = " . $line["post_int_id"]);
1429                                 }
1430                                 db_query($link, "COMMIT");
1431                         }
1432         }
1433
1434         function update_generic_feed($link, $feed, $cat_view) {
1435                         if ($cat_view) {
1436
1437                                 if ($feed > 0) {
1438                                         $cat_qpart = "cat_id = '$feed'";
1439                                 } else {
1440                                         $cat_qpart = "cat_id IS NULL";
1441                                 }
1442
1443                                 $tmp_result = db_query($link, "SELECT feed_url FROM ttrss_feeds
1444                                         WHERE $cat_qpart AND owner_uid = " . $_SESSION["uid"]);
1445
1446                                 while ($tmp_line = db_fetch_assoc($tmp_result)) {
1447                                         $feed_url = $tmp_line["feed_url"];
1448                                         update_rss_feed($link, $feed_url, $feed, ENABLE_UPDATE_DAEMON);
1449                                 }
1450
1451                         } else {
1452                                 $tmp_result = db_query($link, "SELECT feed_url FROM ttrss_feeds
1453                                         WHERE id = '$feed'");
1454                                 $feed_url = db_fetch_result($tmp_result, 0, "feed_url");
1455                                 update_rss_feed($link, $feed_url, $feed, ENABLE_UPDATE_DAEMON);
1456                         }
1457         }
1458
1459         function getAllCounters($link) {
1460                 getLabelCounters($link);
1461                 getFeedCounters($link);
1462                 getTagCounters($link);
1463                 getGlobalCounters($link);
1464                 if (get_pref($link, 'ENABLE_FEED_CATS')) {
1465                         getCategoryCounters($link);
1466                 }
1467         }
1468
1469         function getCategoryCounters($link) {
1470                 $result = db_query($link, "SELECT cat_id,SUM((SELECT COUNT(int_id)
1471                                 FROM ttrss_user_entries WHERE feed_id = ttrss_feeds.id
1472                                         AND unread = true)) AS unread FROM ttrss_feeds
1473                         WHERE
1474                                 hidden = false AND owner_uid = ".$_SESSION["uid"]." GROUP BY cat_id");
1475
1476                 while ($line = db_fetch_assoc($result)) {
1477                         $line["cat_id"] = sprintf("%d", $line["cat_id"]);
1478                         print "<counter type=\"category\" id=\"".$line["cat_id"]."\" counter=\"".
1479                                 $line["unread"]."\"/>";
1480                 }
1481         }
1482
1483         function getCategoryUnread($link, $cat) {
1484
1485                 if ($cat != 0) {
1486                         $cat_query = "cat_id = '$cat'";
1487                 } else {
1488                         $cat_query = "cat_id IS NULL";
1489                 }
1490
1491                 $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE $cat_query
1492                                 AND hidden = false
1493                                 AND owner_uid = " . $_SESSION["uid"]);
1494
1495                 $cat_feeds = array();
1496                 while ($line = db_fetch_assoc($result)) {
1497                         array_push($cat_feeds, "feed_id = " . $line["id"]);
1498                 }
1499
1500                 if (count($cat_feeds) == 0) return 0;
1501
1502                 $match_part = implode(" OR ", $cat_feeds);
1503
1504                 $result = db_query($link, "SELECT COUNT(int_id) AS unread
1505                         FROM ttrss_user_entries
1506                         WHERE   unread = true AND ($match_part) AND owner_uid = " . $_SESSION["uid"]);
1507
1508                 $unread = 0;
1509
1510                 # this needs to be rewritten
1511                 while ($line = db_fetch_assoc($result)) {
1512                         $unread += $line["unread"];
1513                 }
1514
1515                 return $unread;
1516
1517         }
1518
1519         function getFeedUnread($link, $feed, $is_cat = false) {
1520                 $n_feed = sprintf("%d", $feed);
1521
1522                 if ($is_cat) {
1523                         return getCategoryUnread($link, $n_feed);
1524                 } else if ($n_feed == -1) {
1525                         $match_part = "marked = true";
1526                 } else if ($n_feed > 0) {
1527
1528                         $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE parent_feed = '$n_feed'
1529                                         AND hidden = false
1530                                         AND owner_uid = " . $_SESSION["uid"]);
1531
1532                         if (db_num_rows($result) > 0) {
1533
1534                                 $linked_feeds = array();
1535                                 while ($line = db_fetch_assoc($result)) {
1536                                         array_push($linked_feeds, "feed_id = " . $line["id"]);
1537                                 }
1538
1539                                 $match_part = implode(" OR ", $linked_feeds);
1540
1541                                 $result = db_query($link, "SELECT COUNT(int_id) AS unread
1542                                         FROM ttrss_user_entries
1543                                         WHERE   unread = true AND ($match_part) AND owner_uid = " . $_SESSION["uid"]);
1544
1545                                 $unread = 0;
1546
1547                                 # this needs to be rewritten
1548                                 while ($line = db_fetch_assoc($result)) {
1549                                         $unread += $line["unread"];
1550                                 }
1551
1552                                 return $unread;
1553
1554                         } else {
1555                                 $match_part = "feed_id = '$n_feed'";
1556                         }
1557                 } else if ($feed < -10) {
1558
1559                         $label_id = -$feed - 11;
1560
1561                         $result = db_query($link, "SELECT sql_exp FROM ttrss_labels WHERE
1562                                 id = '$label_id' AND owner_uid = " . $_SESSION["uid"]);
1563
1564                         $match_part = db_fetch_result($result, 0, "sql_exp");
1565                 }
1566
1567                 if ($match_part) {
1568
1569                         $result = db_query($link, "SELECT count(int_id) AS unread
1570                                 FROM ttrss_user_entries,ttrss_feeds,ttrss_entries WHERE
1571                                 ttrss_user_entries.feed_id = ttrss_feeds.id AND
1572                                 ttrss_user_entries.ref_id = ttrss_entries.id AND
1573                                 ttrss_feeds.hidden = false AND
1574                                 unread = true AND ($match_part) AND ttrss_user_entries.owner_uid = " . $_SESSION["uid"]);
1575
1576                 } else {
1577
1578                         $result = db_query($link, "SELECT COUNT(post_int_id) AS unread
1579                                 FROM ttrss_tags,ttrss_user_entries
1580                                 WHERE tag_name = '$feed' AND post_int_id = int_id AND unread = true AND
1581                                         ttrss_tags.owner_uid = " . $_SESSION["uid"]);
1582                 }
1583
1584                 $unread = db_fetch_result($result, 0, "unread");
1585
1586                 return $unread;
1587         }
1588
1589         /* FIXME this needs reworking */
1590
1591         function getGlobalUnread($link, $user_id = false) {
1592
1593                 if (!$user_id) {
1594                         $user_id = $_SESSION["uid"];
1595                 }
1596
1597                 $result = db_query($link, "SELECT count(ttrss_entries.id) as c_id FROM ttrss_entries,ttrss_user_entries,ttrss_feeds
1598                         WHERE unread = true AND
1599                         ttrss_user_entries.feed_id = ttrss_feeds.id AND
1600                         ttrss_user_entries.ref_id = ttrss_entries.id AND
1601                         hidden = false AND
1602                         ttrss_user_entries.owner_uid = '$user_id'");
1603                 $c_id = db_fetch_result($result, 0, "c_id");
1604                 return $c_id;
1605         }
1606
1607         function getGlobalCounters($link, $global_unread = -1) {
1608                 if ($global_unread == -1) {
1609                         $global_unread = getGlobalUnread($link);
1610                 }
1611                 print "<counter type=\"global\" id='global-unread'
1612                         counter='$global_unread'/>";
1613
1614                 $result = db_query($link, "SELECT COUNT(id) AS fn FROM
1615                         ttrss_feeds WHERE owner_uid = " . $_SESSION["uid"]);
1616
1617                 $subscribed_feeds = db_fetch_result($result, 0, "fn");
1618
1619                 print "<counter type=\"global\" id='subscribed-feeds'
1620                         counter='$subscribed_feeds'/>";
1621
1622         }
1623
1624         function getTagCounters($link, $smart_mode = SMART_RPC_COUNTERS) {
1625
1626                 if ($smart_mode) {
1627                         if (!$_SESSION["tctr_last_value"]) {
1628                                 $_SESSION["tctr_last_value"] = array();
1629                         }
1630                 }
1631
1632                 $old_counters = $_SESSION["tctr_last_value"];
1633
1634                 $tctrs_modified = false;
1635
1636 /*              $result = db_query($link, "SELECT tag_name,count(ttrss_entries.id) AS count
1637                         FROM ttrss_tags,ttrss_entries,ttrss_user_entries WHERE
1638                         ttrss_user_entries.ref_id = ttrss_entries.id AND
1639                         ttrss_tags.owner_uid = ".$_SESSION["uid"]." AND
1640                         post_int_id = ttrss_user_entries.int_id AND unread = true GROUP BY tag_name
1641                 UNION
1642                         select tag_name,0 as count FROM ttrss_tags
1643                         WHERE ttrss_tags.owner_uid = ".$_SESSION["uid"]); */
1644
1645                 $result = db_query($link, "SELECT tag_name,SUM((SELECT COUNT(int_id)
1646                         FROM ttrss_user_entries WHERE int_id = post_int_id
1647                                 AND unread = true)) AS count FROM ttrss_tags
1648                         WHERE owner_uid = 2 GROUP BY tag_name ORDER BY tag_name");
1649
1650                 $tags = array();
1651
1652                 while ($line = db_fetch_assoc($result)) {
1653                         $tags[$line["tag_name"]] += $line["count"];
1654                 }
1655
1656                 foreach (array_keys($tags) as $tag) {
1657                         $unread = $tags[$tag];
1658
1659                         $tag = htmlspecialchars($tag);
1660
1661                         if (!$smart_mode || $old_counters[$tag] != $unread) {
1662                                 $old_counters[$tag] = $unread;
1663                                 $tctrs_modified = true;
1664                                 print "<counter type=\"tag\" id=\"$tag\" counter=\"$unread\"/>";
1665                         }
1666
1667                 }
1668
1669                 if ($smart_mode && $tctrs_modified) {
1670                         $_SESSION["tctr_last_value"] = $old_counters;
1671                 }
1672
1673         }
1674
1675         function getLabelCounters($link, $smart_mode = SMART_RPC_COUNTERS, $ret_mode = false) {
1676
1677                 if ($smart_mode) {
1678                         if (!$_SESSION["lctr_last_value"]) {
1679                                 $_SESSION["lctr_last_value"] = array();
1680                         }
1681                 }
1682
1683                 $ret_arr = array();
1684
1685                 $old_counters = $_SESSION["lctr_last_value"];
1686                 $lctrs_modified = false;
1687
1688                 $result = db_query($link, "SELECT count(ttrss_entries.id) as count FROM ttrss_entries,ttrss_user_entries,ttrss_feeds
1689                         WHERE marked = true AND ttrss_user_entries.ref_id = ttrss_entries.id AND
1690                         ttrss_user_entries.feed_id = ttrss_feeds.id AND
1691                         unread = true AND ttrss_user_entries.owner_uid = ".$_SESSION["uid"]);
1692
1693                 $count = db_fetch_result($result, 0, "count");
1694
1695                 if (!$ret_mode) {
1696                         print "<counter type=\"label\" id=\"-1\" counter=\"$count\"/>";
1697                 } else {
1698                         $ret_arr["-1"]["counter"] = $count;
1699                         $ret_arr["-1"]["description"] = "Starred";
1700                 }
1701
1702                 $result = db_query($link, "SELECT owner_uid,id,sql_exp,description FROM
1703                         ttrss_labels WHERE owner_uid = ".$_SESSION["uid"]." ORDER by description");
1704
1705                 while ($line = db_fetch_assoc($result)) {
1706
1707                         $id = -$line["id"] - 11;
1708
1709                         $label_name = $line["description"];
1710
1711                         error_reporting (0);
1712
1713                         $tmp_result = db_query($link, "SELECT count(ttrss_entries.id) as count FROM ttrss_user_entries,ttrss_entries,ttrss_feeds
1714                                 WHERE (" . $line["sql_exp"] . ") AND unread = true AND
1715                                 ttrss_feeds.hidden = false AND
1716                                 ttrss_user_entries.feed_id = ttrss_feeds.id AND
1717                                 ttrss_user_entries.ref_id = ttrss_entries.id AND
1718                                 ttrss_user_entries.owner_uid = ".$_SESSION["uid"]);
1719
1720                         $count = db_fetch_result($tmp_result, 0, "count");
1721
1722                         if (!$smart_mode || $old_counters[$id] != $count) {
1723                                 $old_counters[$id] = $count;
1724                                 $lctrs_modified = true;
1725                                 if (!$ret_mode) {
1726                                         print "<counter type=\"label\" id=\"$id\" counter=\"$count\"/>";
1727                                 } else {
1728                                         $ret_arr[$id]["counter"] = $count;
1729                                         $ret_arr[$id]["description"] = $label_name;
1730                                 }
1731                         }
1732
1733                         error_reporting (DEFAULT_ERROR_LEVEL);
1734                 }
1735
1736                 if ($smart_mode && $lctrs_modified) {
1737                         $_SESSION["lctr_last_value"] = $old_counters;
1738                 }
1739
1740                 return $ret_arr;
1741         }
1742
1743 /*      function getFeedCounter($link, $id) {
1744
1745                 $result = db_query($link, "SELECT
1746                                 count(id) as count,last_error
1747                         FROM ttrss_entries,ttrss_user_entries,ttrss_feeds
1748                         WHERE feed_id = '$id' AND unread = true
1749                         AND ttrss_user_entries.feed_id = ttrss_feeds.id
1750                         AND ttrss_user_entries.ref_id = ttrss_entries.id");
1751
1752                         $count = db_fetch_result($result, 0, "count");
1753                         $last_error = htmlspecialchars(db_fetch_result($result, 0, "last_error"));
1754
1755                         print "<counter type=\"feed\" id=\"$id\" counter=\"$count\" error=\"$last_error\"/>";
1756         } */
1757
1758         function getFeedCounters($link, $smart_mode = SMART_RPC_COUNTERS) {
1759
1760                 if ($smart_mode) {
1761                         if (!$_SESSION["fctr_last_value"]) {
1762                                 $_SESSION["fctr_last_value"] = array();
1763                         }
1764                 }
1765
1766                 $old_counters = $_SESSION["fctr_last_value"];
1767
1768                 $result = db_query($link, "SELECT id,last_error,parent_feed,
1769                         SUBSTRING(last_updated,1,19) AS last_updated,
1770                         (SELECT count(id)
1771                                 FROM ttrss_entries,ttrss_user_entries
1772                                 WHERE feed_id = ttrss_feeds.id AND
1773                                         ttrss_user_entries.ref_id = ttrss_entries.id
1774                                 AND unread = true AND owner_uid = ".$_SESSION["uid"].") as count
1775                         FROM ttrss_feeds WHERE owner_uid = ".$_SESSION["uid"] . "
1776                                 AND parent_feed IS NULL");
1777
1778                 $fctrs_modified = false;
1779
1780                 $short_date = get_pref($link, 'SHORT_DATE_FORMAT');
1781
1782                 while ($line = db_fetch_assoc($result)) {
1783
1784                         $id = $line["id"];
1785                         $count = $line["count"];
1786                         $last_error = htmlspecialchars($line["last_error"]);
1787
1788                         if (get_pref($link, 'HEADLINES_SMART_DATE')) {
1789                                 $last_updated = smart_date_time(strtotime($line["last_updated"]));
1790                         } else {
1791                                 $last_updated = date($short_date, strtotime($line["last_updated"]));
1792                         }
1793
1794                         $has_img = is_file(ICONS_DIR . "/$id.ico");
1795
1796                         $tmp_result = db_query($link,
1797                                 "SELECT id,COUNT(unread) AS unread
1798                                 FROM ttrss_feeds LEFT JOIN ttrss_user_entries
1799                                         ON (ttrss_feeds.id = ttrss_user_entries.feed_id)
1800                                 WHERE parent_feed = '$id' AND unread = true GROUP BY ttrss_feeds.id");
1801
1802                         if (db_num_rows($tmp_result) > 0) {
1803                                 while ($l = db_fetch_assoc($tmp_result)) {
1804                                         $count += $l["unread"];
1805                                 }
1806                         }
1807
1808                         if (!$smart_mode || $old_counters[$id] != $count) {
1809                                 $old_counters[$id] = $count;
1810                                 $fctrs_modified = true;
1811
1812                                 if ($last_error) {
1813                                         $error_part = "error=\"$last_error\"";
1814                                 } else {
1815                                         $error_part = "";
1816                                 }
1817
1818                                 if ($has_img) {
1819                                         $has_img_part = "hi=\"$has_img\"";
1820                                 } else {
1821                                         $has_img_part = "";
1822                                 }
1823
1824                                 print "<counter type=\"feed\" id=\"$id\" counter=\"$count\" $has_img_part $error_part updated=\"$last_updated\"/>";
1825                         }
1826                 }
1827
1828                 if ($smart_mode && $fctrs_modified) {
1829                         $_SESSION["fctr_last_value"] = $old_counters;
1830                 }
1831         }
1832
1833         function get_script_dt_add() {
1834                 if (strpos(VERSION, "99") === false) {
1835                         return VERSION;
1836                 } else {
1837                         return time();
1838                 }
1839         }
1840
1841         function get_pgsql_version($link) {
1842                 $result = db_query($link, "SELECT version() AS version");
1843                 $version = split(" ", db_fetch_result($result, 0, "version"));
1844                 return $version[1];
1845         }
1846
1847         function print_error_xml($code, $add_msg = "") {
1848                 global $ERRORS;
1849
1850                 $error_msg = $ERRORS[$code];
1851
1852                 if ($add_msg) {
1853                         $error_msg = "$error_msg; $add_msg";
1854                 }
1855
1856                 print "<rpc-reply>";
1857                 print "<error error-code=\"$code\" error-msg=\"$error_msg\"/>";
1858                 print "</rpc-reply>";
1859         }
1860
1861         function subscribe_to_feed($link, $feed_link, $cat_id = 0) {
1862
1863                 $feed_link = preg_replace("/^feed:/", "", $feed_link);
1864
1865                 if ($cat_id == "0" || !$cat_id) {
1866                         $cat_qpart = "NULL";
1867                 } else {
1868                         $cat_qpart = "'$cat_id'";
1869                 }
1870
1871                 $result = db_query($link,
1872                         "SELECT id FROM ttrss_feeds
1873                         WHERE feed_url = '$feed_link' AND owner_uid = ".$_SESSION["uid"]);
1874
1875                 if (db_num_rows($result) == 0) {
1876
1877                         $result = db_query($link,
1878                                 "INSERT INTO ttrss_feeds (owner_uid,feed_url,title,cat_id)
1879                                 VALUES ('".$_SESSION["uid"]."', '$feed_link',
1880                                 '[Unknown]', $cat_qpart)");
1881
1882                         $result = db_query($link,
1883                                 "SELECT id FROM ttrss_feeds WHERE feed_url = '$feed_link'
1884                                 AND owner_uid = " . $_SESSION["uid"]);
1885
1886                         $feed_id = db_fetch_result($result, 0, "id");
1887
1888                         if ($feed_id) {
1889                                 update_rss_feed($link, $feed_link, $feed_id, true);
1890                         }
1891
1892                         return true;
1893                 } else {
1894                         return false;
1895                 }
1896         }
1897
1898         function print_feed_select($link, $id, $default_id = "",
1899                 $attributes = "", $include_all_feeds = true) {
1900
1901                 print "<select id=\"$id\" name=\"$id\" $attributes>";
1902                 if ($include_all_feeds) {
1903                         print "<option value=\"0\">All feeds</option>";
1904                 }
1905
1906                 $result = db_query($link, "SELECT id,title FROM ttrss_feeds
1907                         WHERE owner_uid = ".$_SESSION["uid"]." ORDER BY title");
1908
1909                 if (db_num_rows($result) > 0 && $include_all_feeds) {
1910                         print "<option disabled>--------</option>";
1911                 }
1912
1913                 while ($line = db_fetch_assoc($result)) {
1914                         if ($line["id"] == $default_id) {
1915                                 $is_selected = "selected";
1916                         } else {
1917                                 $is_selected = "";
1918                         }
1919                         printf("<option $is_selected value='%d'>%s</option>",
1920                                 $line["id"], htmlspecialchars(db_unescape_string($line["title"])));
1921                 }
1922
1923                 print "</select>";
1924         }
1925
1926         function print_feed_cat_select($link, $id, $default_id = "",
1927                 $attributes = "", $include_all_cats = true) {
1928
1929                 print "<select id=\"$id\" name=\"$id\" $attributes>";
1930
1931                 if ($include_all_cats) {
1932                         print "<option value=\"0\">Uncategorized</option>";
1933                 }
1934
1935                 $result = db_query($link, "SELECT id,title FROM ttrss_feed_categories
1936                         WHERE owner_uid = ".$_SESSION["uid"]." ORDER BY title");
1937
1938                 if (db_num_rows($result) > 0 && $include_all_cats) {
1939                         print "<option disabled>--------</option>";
1940                 }
1941
1942                 while ($line = db_fetch_assoc($result)) {
1943                         if ($line["id"] == $default_id) {
1944                                 $is_selected = "selected";
1945                         } else {
1946                                 $is_selected = "";
1947                         }
1948                         printf("<option $is_selected value='%d'>%s</option>",
1949                                 $line["id"], htmlspecialchars(db_unescape_string($line["title"])));
1950                 }
1951
1952                 print "</select>";
1953         }
1954
1955         function checkbox_to_sql_bool($val) {
1956                 return ($val == "on") ? "true" : "false";
1957         }
1958
1959         function getFeedCatTitle($link, $id) {
1960                 if ($id == -1) {
1961                         return "Special";
1962                 } else if ($id < -10) {
1963                         return "Labels";
1964                 } else if ($id > 0) {
1965                         $result = db_query($link, "SELECT ttrss_feed_categories.title
1966                                 FROM ttrss_feeds, ttrss_feed_categories WHERE ttrss_feeds.id = '$id' AND
1967                                         cat_id = ttrss_feed_categories.id");
1968                         if (db_num_rows($result) == 1) {
1969                                 return db_fetch_result($result, 0, "title");
1970                         } else {
1971                                 return "Uncategorized";
1972                         }
1973                 } else {
1974                         return "getFeedCatTitle($id) failed";
1975                 }
1976
1977         }
1978
1979         function getFeedTitle($link, $id) {
1980                 if ($id == -1) {
1981                         return "Starred articles";
1982                 } else if ($id < -10) {
1983                         $label_id = -10 - $id;
1984                         $result = db_query($link, "SELECT description FROM ttrss_labels WHERE id = '$label_id'");
1985                         if (db_num_rows($result) == 1) {
1986                                 return db_fetch_result($result, 0, "description");
1987                         } else {
1988                                 return "Unknown label ($label_id)";
1989                         }
1990
1991                 } else if ($id > 0) {
1992                         $result = db_query($link, "SELECT title FROM ttrss_feeds WHERE id = '$id'");
1993                         if (db_num_rows($result) == 1) {
1994                                 return db_fetch_result($result, 0, "title");
1995                         } else {
1996                                 return "Unknown feed ($id)";
1997                         }
1998                 } else {
1999                         return "getFeedTitle($id) failed";
2000                 }
2001
2002         }
2003
2004         function get_session_cookie_name() {
2005                 return ((!defined('TTRSS_SESSION_NAME')) ? "ttrss_sid" : TTRSS_SESSION_NAME);
2006         }
2007
2008         function print_init_params($link) {
2009                 print "<init-params>";
2010                 if ($_SESSION["stored-params"]) {
2011                         foreach (array_keys($_SESSION["stored-params"]) as $key) {
2012                                 if ($key) {
2013                                         $value = htmlspecialchars($_SESSION["stored-params"][$key]);
2014                                         print "<param key=\"$key\" value=\"$value\"/>";
2015                                 }
2016                         }
2017                 }
2018
2019                 print "<param key=\"daemon_enabled\" value=\"" . ENABLE_UPDATE_DAEMON . "\"/>";
2020                 print "<param key=\"feeds_frame_refresh\" value=\"" . FEEDS_FRAME_REFRESH . "\"/>";
2021                 print "<param key=\"daemon_refresh_only\" value=\"" . DAEMON_REFRESH_ONLY . "\"/>";
2022
2023                 print "<param key=\"on_catchup_show_next_feed\" value=\"" .
2024                         get_pref($link, "ON_CATCHUP_SHOW_NEXT_FEED") . "\"/>";
2025
2026                 print "<param key=\"hide_read_feeds\" value=\"" .
2027                         sprintf("%d", get_pref($link, "HIDE_READ_FEEDS")) . "\"/>";
2028
2029                 print "<param key=\"feeds_sort_by_unread\" value=\"" .
2030                         sprintf("%d", get_pref($link, "FEEDS_SORT_BY_UNREAD")) . "\"/>";
2031
2032                 print "<param key=\"confirm_feed_catchup\" value=\"" .
2033                         sprintf("%d", get_pref($link, "CONFIRM_FEED_CATCHUP")) . "\"/>";
2034
2035                 print "</init-params>";
2036         }
2037
2038         function print_runtime_info($link) {
2039                 print "<runtime-info>";
2040                 if (ENABLE_UPDATE_DAEMON) {
2041                         print "<param key=\"daemon_is_running\" value=\"".
2042                                 sprintf("%d", file_is_locked("update_daemon.lock")) . "\"/>";
2043                 }
2044                 print "</runtime-info>";
2045         }
2046
2047         function getSearchSql($search, $match_on) {
2048
2049                 $search_query_part = "";
2050
2051                 $keywords = split(" ", $search);
2052                 $query_keywords = array();
2053
2054                 if ($match_on == "both") {
2055
2056                         foreach ($keywords as $k) {
2057                                 array_push($query_keywords, "(UPPER(ttrss_entries.title) LIKE UPPER('%$k%')
2058                                         OR UPPER(ttrss_entries.content) LIKE UPPER('%$k%'))");
2059                         }
2060
2061                         $search_query_part = implode("AND", $query_keywords) . " AND ";
2062
2063                 } else if ($match_on == "title") {
2064
2065                         foreach ($keywords as $k) {
2066                                 array_push($query_keywords, "(UPPER(ttrss_entries.title) LIKE UPPER('%$k%'))");
2067                         }
2068
2069                         $search_query_part = implode("AND", $query_keywords) . " AND ";
2070
2071                 } else if ($match_on == "content") {
2072
2073                         foreach ($keywords as $k) {
2074                                 array_push($query_keywords, "(UPPER(ttrss_entries.content) LIKE UPPER('%$k%'))");
2075                         }
2076                 }
2077
2078                 $search_query_part = implode("AND", $query_keywords);
2079
2080                 return $search_query_part;
2081         }
2082
2083         function queryFeedHeadlines($link, $feed, $limit, $view_mode, $cat_view, $search, $search_mode, $match_on, $override_order = false) {
2084                         if ($search) {
2085
2086                                 $search_query_part = getSearchSql($search, $match_on);
2087                                 $search_query_part .= " AND ";
2088
2089                         } else {
2090                                 $search_query_part = "";
2091                         }
2092
2093                         $view_query_part = "";
2094
2095                         if ($view_mode == "adaptive") {
2096                                 if ($search) {
2097                                         $view_query_part = " ";
2098                                 } else if ($feed != -1) {
2099                                         $unread = getFeedUnread($link, $feed, $cat_view);
2100                                         if ($unread > 0) {
2101                                                 $view_query_part = " unread = true AND ";
2102                                         }
2103                                 }
2104                         }
2105
2106                         if ($view_mode == "marked") {
2107                                 $view_query_part = " marked = true AND ";
2108                         }
2109
2110                         if ($view_mode == "unread") {
2111                                 $view_query_part = " unread = true AND ";
2112                         }
2113
2114                         if ($limit > 0) {
2115                                 $limit_query_part = "LIMIT " . $limit;
2116                         }
2117
2118                         $vfeed_query_part = "";
2119
2120                         // override query strategy and enable feed display when searching globally
2121                         if ($search && $search_mode == "all_feeds") {
2122                                 $query_strategy_part = "ttrss_entries.id > 0";
2123                                 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2124                         } else if (preg_match("/^-?[0-9][0-9]*$/", $feed) == false) {
2125                                 $query_strategy_part = "ttrss_entries.id > 0";
2126                                 $vfeed_query_part = "(SELECT title FROM ttrss_feeds WHERE
2127                                         id = feed_id) as feed_title,";
2128                         } else if ($feed >= 0 && $search && $search_mode == "this_cat") {
2129
2130                                 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2131
2132                                 $tmp_result = false;
2133
2134                                 if ($cat_view) {
2135                                         $tmp_result = db_query($link, "SELECT id
2136                                                 FROM ttrss_feeds WHERE cat_id = '$feed'");
2137                                 } else {
2138                                         $tmp_result = db_query($link, "SELECT id
2139                                                 FROM ttrss_feeds WHERE cat_id = (SELECT cat_id FROM ttrss_feeds
2140                                                         WHERE id = '$feed') AND id != '$feed'");
2141                                 }
2142
2143                                 $cat_siblings = array();
2144
2145                                 if (db_num_rows($tmp_result) > 0) {
2146                                         while ($p = db_fetch_assoc($tmp_result)) {
2147                                                 array_push($cat_siblings, "feed_id = " . $p["id"]);
2148                                         }
2149
2150                                         $query_strategy_part = sprintf("(feed_id = %d OR %s)",
2151                                                 $feed, implode(" OR ", $cat_siblings));
2152
2153                                 } else {
2154                                         $query_strategy_part = "ttrss_entries.id > 0";
2155                                 }
2156
2157                         } else if ($feed >= 0) {
2158
2159                                 if ($cat_view) {
2160
2161                                         if ($feed > 0) {
2162                                                 $query_strategy_part = "cat_id = '$feed'";
2163                                         } else {
2164                                                 $query_strategy_part = "cat_id IS NULL";
2165                                         }
2166
2167                                         $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2168
2169                                 } else {
2170                                         $tmp_result = db_query($link, "SELECT id
2171                                                 FROM ttrss_feeds WHERE parent_feed = '$feed'
2172                                                 ORDER BY cat_id,title");
2173
2174                                         $parent_ids = array();
2175
2176                                         if (db_num_rows($tmp_result) > 0) {
2177                                                 while ($p = db_fetch_assoc($tmp_result)) {
2178                                                         array_push($parent_ids, "feed_id = " . $p["id"]);
2179                                                 }
2180
2181                                                 $query_strategy_part = sprintf("(feed_id = %d OR %s)",
2182                                                         $feed, implode(" OR ", $parent_ids));
2183
2184                                                 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2185                                         } else {
2186                                                 $query_strategy_part = "feed_id = '$feed'";
2187                                         }
2188                                 }
2189                         } else if ($feed == -1) { // starred virtual feed
2190                                 $query_strategy_part = "marked = true";
2191                                 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2192                         } else if ($feed <= -10) { // labels
2193                                 $label_id = -$feed - 11;
2194
2195                                 $tmp_result = db_query($link, "SELECT sql_exp FROM ttrss_labels
2196                                         WHERE id = '$label_id'");
2197
2198                                 $query_strategy_part = db_fetch_result($tmp_result, 0, "sql_exp");
2199
2200                                 $vfeed_query_part = "ttrss_feeds.title AS feed_title,";
2201                         } else {
2202                                 $query_strategy_part = "id > 0"; // dumb
2203                         }
2204
2205                         if (get_pref($link, 'REVERSE_HEADLINES')) {
2206                                 $order_by = "updated";
2207                         } else {
2208                                 $order_by = "updated DESC";
2209                         }
2210
2211                         if ($override_order) {
2212                                 $order_by = $override_order;
2213                         }
2214
2215                         $feed_title = "";
2216
2217                         if ($search && $search_mode == "all_feeds") {
2218                                 $feed_title = "Global search results ($search)";
2219                         } else if ($search && preg_match('/^-?[0-9][0-9]*$/', $feed) == false) {
2220                                 $feed_title = "Tag search results ($search, $feed)";
2221                         } else if (preg_match('/^-?[0-9][0-9]*$/', $feed) == false) {
2222                                 $feed_title = $feed;
2223                         } else if (preg_match('/^-?[0-9][0-9]*$/', $feed) != false && $feed >= 0) {
2224
2225                                 if ($cat_view) {
2226
2227                                         if ($feed != 0) {
2228                                                 $result = db_query($link, "SELECT title FROM ttrss_feed_categories
2229                                                         WHERE id = '$feed' AND owner_uid = " . $_SESSION["uid"]);
2230                                                 $feed_title = db_fetch_result($result, 0, "title");
2231                                         } else {
2232                                                 $feed_title = "Uncategorized";
2233                                         }
2234
2235                                         if ($search) {
2236                                                 $feed_title = "Category search results ($search, $feed_title)";
2237                                         }
2238
2239                                 } else {
2240
2241                                         $result = db_query($link, "SELECT title,site_url,last_error FROM ttrss_feeds
2242                                                 WHERE id = '$feed' AND owner_uid = " . $_SESSION["uid"]);
2243
2244                                         $feed_title = db_fetch_result($result, 0, "title");
2245                                         $feed_site_url = db_fetch_result($result, 0, "site_url");
2246                                         $last_error = db_fetch_result($result, 0, "last_error");
2247
2248                                         if ($search) {
2249                                                 $feed_title = "Feed search results ($search, $feed_title)";
2250                                         }
2251                                 }
2252
2253                         } else if ($feed == -1) {
2254                                 $feed_title = "Starred articles";
2255                         } else if ($feed < -10) {
2256                                 $label_id = -$feed - 11;
2257                                 $result = db_query($link, "SELECT description FROM ttrss_labels
2258                                         WHERE id = '$label_id'");
2259                                 $feed_title = db_fetch_result($result, 0, "description");
2260
2261                                 if ($search) {
2262                                         $feed_title = "Label search results ($search, $feed_title)";
2263                                 }
2264                         } else {
2265                                 $feed_title = "?";
2266                         }
2267
2268                         $feed_title = db_unescape_string($feed_title);
2269
2270                         if ($feed < -10) error_reporting (0);
2271
2272                         if (preg_match("/^-?[0-9][0-9]*$/", $feed) != false) {
2273
2274                                 if ($feed >= 0) {
2275                                         $feed_kind = "Feeds";
2276                                 } else {
2277                                         $feed_kind = "Labels";
2278                                 }
2279
2280                                 $content_query_part = "content as content_preview,";
2281
2282                                 $query = "SELECT
2283                                                 guid,
2284                                                 ttrss_entries.id,ttrss_entries.title,
2285                                                 SUBSTRING(updated,1,16) as updated,
2286                                                 unread,feed_id,marked,link,last_read,
2287                                                 SUBSTRING(last_read,1,19) as last_read_noms,
2288                                                 $vfeed_query_part
2289                                                 $content_query_part
2290                                                 SUBSTRING(updated,1,19) as updated_noms
2291                                         FROM
2292                                                 ttrss_entries,ttrss_user_entries,ttrss_feeds
2293                                         WHERE
2294                                         ttrss_feeds.hidden = false AND
2295                                         ttrss_user_entries.feed_id = ttrss_feeds.id AND
2296                                         ttrss_user_entries.ref_id = ttrss_entries.id AND
2297                                         ttrss_user_entries.owner_uid = '".$_SESSION["uid"]."' AND
2298                                         $search_query_part
2299                                         $view_query_part
2300                                         $query_strategy_part ORDER BY $order_by
2301                                         $limit_query_part";
2302
2303                                 $result = db_query($link, $query);
2304
2305                                 if ($_GET["debug"]) print $query;
2306
2307                         } else {
2308                                 // browsing by tag
2309
2310                                 $feed_kind = "Tags";
2311
2312                                 $result = db_query($link, "SELECT
2313                                         guid,
2314                                         ttrss_entries.id as id,title,
2315                                         SUBSTRING(updated,1,16) as updated,
2316                                         unread,feed_id,
2317                                         marked,link,last_read,
2318                                         SUBSTRING(last_read,1,19) as last_read_noms,
2319                                         $vfeed_query_part
2320                                         $content_query_part
2321                                         SUBSTRING(updated,1,19) as updated_noms
2322                                         FROM
2323                                                 ttrss_entries,ttrss_user_entries,ttrss_tags
2324                                         WHERE
2325                                                 ref_id = ttrss_entries.id AND
2326                                                 ttrss_user_entries.owner_uid = '".$_SESSION["uid"]."' AND
2327                                                 post_int_id = int_id AND tag_name = '$feed' AND
2328                                                 $view_query_part
2329                                                 $search_query_part
2330                                                 $query_strategy_part ORDER BY $order_by
2331                                         $limit_query_part");
2332                         }
2333
2334                         return array($result, $feed_title, $feed_site_url, $last_error);
2335
2336         }
2337
2338         function generate_syndicated_feed($link, $feed, $is_cat,
2339                 $search, $search_mode, $match_on) {
2340
2341                 $qfh_ret = queryFeedHeadlines($link, $feed,
2342                                 30, false, $is_cat, $search, $search_mode, $match_on, "updated DESC");
2343
2344                 $result = $qfh_ret[0];
2345                 $feed_title = htmlspecialchars($qfh_ret[1]);
2346                 $feed_site_url = $qfh_ret[2];
2347                 $last_error = $qfh_ret[3];
2348
2349                 print "<rss version=\"2.0\">
2350                         <channel>
2351                         <title>$feed_title</title>
2352                         <link>$feed_site_url</link>
2353                         <generator>Tiny Tiny RSS v".VERSION."</generator>";
2354
2355                 while ($line = db_fetch_assoc($result)) {
2356                         print "<item>";
2357                         print "<id>" . htmlspecialchars($line["guid"]) . "</id>";
2358                         print "<link>" . htmlspecialchars($line["link"]) . "</link>";
2359
2360                         $rfc822_date = date('r', strtotime($line["updated"]));
2361
2362                         print "<pubDate>$rfc822_date</pubDate>";
2363
2364                         print "<title>" .
2365                                 htmlspecialchars($line["title"]) . "</title>";
2366
2367                         print "<description>" .
2368                                 htmlspecialchars($line["content_preview"]) . "</description>";
2369
2370                         print "</item>";
2371                 }
2372
2373                 print "</channel></rss>";
2374
2375         }
2376
2377         function getCategoryTitle($link, $cat_id) {
2378
2379                 $result = db_query($link, "SELECT title FROM ttrss_feed_categories WHERE
2380                         id = '$cat_id'");
2381
2382                 if (db_num_rows($result) == 1) {
2383                         return db_fetch_result($result, 0, "title");
2384                 } else {
2385                         return "Uncategorized";
2386                 }
2387         }
2388
2389         function sanitize_rss($str) {
2390                 $res = $str;
2391
2392                 $res = preg_replace('/<script.*?>/i',
2393                         "<p class=\"scriptWarn\">Disabled script: ", $res);
2394
2395                 $res = preg_replace('/<\/script.*?>/i', "</p>", $res);
2396
2397 /*              $res = preg_replace('/<embed.*?>/i', "", $res);
2398
2399                 $res = preg_replace('/<object.*?>.*?<\/object>/i',
2400                         "<p class=\"objectWarn\">(Disabled html object
2401                         - flash or other embedded content)</p>", $res);  */
2402
2403                 return $res;
2404         }
2405
2406         function send_headlines_digests($link, $limit = 100) {
2407
2408                 if (!DIGEST_ENABLE) return false;
2409
2410                 $user_limit = DIGEST_EMAIL_LIMIT;
2411                 $days = 1;
2412
2413                 print "Sending digests, batch of max $user_limit users, days = $days, headline limit = $limit\n\n";
2414
2415                 if (DB_TYPE == "pgsql") {
2416                         $interval_query = "last_digest_sent < NOW() - INTERVAL '$days days'";
2417                 } else if (DB_TYPE == "mysql") {
2418                         $interval_query = "last_digest_sent < DATE_SUB(NOW(), INTERVAL $days DAY)";
2419                 }
2420
2421                 $result = db_query($link, "SELECT id,email FROM ttrss_users
2422                                 WHERE email != '' AND (last_digest_sent IS NULL OR $interval_query)");
2423
2424                 while ($line = db_fetch_assoc($result)) {
2425                         if (get_pref($link, 'DIGEST_ENABLE', $line['id'], false)) {
2426                                 print "Sending digest for UID:" . $line['id'] . " - " . $line["email"] . " ... ";
2427
2428                                 $tuple = prepare_headlines_digest($link, $line["id"], $days, $limit);
2429                                 $digest = $tuple[0];
2430                                 $headlines_count = $tuple[1];
2431
2432                                 if ($headlines_count > 0) {
2433                                         $rc = mail($line["login"] . " <" . $line["email"] . ">",
2434                                                 "[tt-rss] New headlines for last 24 hours", $digest,
2435                                                 "From: " . MAIL_FROM . "\n".
2436                                                 "Content-Type: text/plain; charset=\"utf-8\"\n".
2437                                                 "Content-Transfer-Encoding: 8bit\n");
2438                                         print "RC=$rc\n";
2439                                         db_query($link, "UPDATE ttrss_users SET last_digest_sent = NOW()
2440                                                         WHERE id = " . $line["id"]);
2441                                 } else {
2442                                         print "No headlines\n";
2443                                 }
2444                         }
2445                 }
2446
2447 //              $digest = prepare_headlines_digest($link, $user_id, $days, $limit);
2448
2449         }
2450
2451         function prepare_headlines_digest($link, $user_id, $days = 1, $limit = 100) {
2452                 $tmp =  "New headlines for last 24 hours, as of " . date("Y/m/d H:m") . "\n";
2453                 $tmp .= "=======================================================\n\n";
2454
2455                 if (DB_TYPE == "pgsql") {
2456                         $interval_query = "ttrss_entries.date_entered > NOW() - INTERVAL '$days days'";
2457                 } else if (DB_TYPE == "mysql") {
2458                         $interval_query = "ttrss_entries.date_entered > DATE_SUB(NOW(), INTERVAL $days DAY)";
2459                 }
2460
2461                 $result = db_query($link, "SELECT ttrss_entries.title,
2462                                 ttrss_feeds.title AS feed_title,
2463                                 date_entered,
2464                                 link,
2465                                 SUBSTRING(last_updated,1,19) AS last_updated
2466                         FROM
2467                                 ttrss_user_entries,ttrss_entries,ttrss_feeds
2468                         WHERE
2469                                 ref_id = ttrss_entries.id AND feed_id = ttrss_feeds.id
2470                                 AND include_in_digest = true
2471                                 AND $interval_query
2472                                 AND ttrss_user_entries.owner_uid = $user_id
2473                                 AND unread = true ORDER BY ttrss_feeds.title, date_entered DESC
2474                         LIMIT $limit");
2475
2476                 $cur_feed_title = "";
2477
2478                 $headlines_count = db_num_rows($result);
2479
2480                 while ($line = db_fetch_assoc($result)) {
2481                         $updated = smart_date_time(strtotime($line["last_updated"]));
2482                         $feed_title = $line["feed_title"];
2483
2484                         if ($cur_feed_title != $feed_title) {
2485                                 $cur_feed_title = $feed_title;
2486
2487                                 $tmp .= "$feed_title\n\n";
2488                         }
2489
2490                         $tmp .= " * " . trim($line["title"]) . " - $updated\n";
2491                         $tmp .= "   " . trim($line["link"]) . "\n";
2492                         $tmp .= "\n";
2493                 }
2494
2495                 $tmp .= "--- \n";
2496                 $tmp .= "You have been sent this email because you have enabled daily digests in Tiny Tiny RSS at " .
2497                         DIGEST_HOSTNAME . "\n".
2498                         "To unsubscribe, visit your configuration options or contact instance owner.\n";
2499
2500
2501                 return array($tmp, $headlines_count);
2502         }
2503
2504         function check_for_update($link) {
2505                 $releases_feed = "http://tt-rss.spb.ru/releases.rss";
2506
2507                 if (!CHECK_FOR_NEW_VERSION || $_SESSION["access_level"] < 10) {
2508                         return;
2509                 }
2510
2511                 error_reporting(0);
2512                 $rss = fetch_rss($releases_feed);
2513                 error_reporting (DEFAULT_ERROR_LEVEL);
2514
2515                 if ($rss) {
2516
2517                         $items = $rss->items;
2518
2519                         if (!$items || !is_array($items)) $items = $rss->entries;
2520                         if (!$items || !is_array($items)) $items = $rss;
2521
2522                         if (!is_array($items) || count($items) == 0) {
2523                                 return;
2524                         }
2525
2526                         $latest_item = $items[0];
2527
2528                         $latest_version = trim(preg_replace("/(Milestone)|(completed)/", "", $latest_item["title"]));
2529
2530                         $release_url = sanitize_rss($latest_item["link"]);
2531                         $content = sanitize_rss($latest_item["description"]);
2532
2533                         if (version_compare(VERSION, $latest_version) == -1) {
2534                                 return "<div class=\"notice\"><a href=\"javascript:showBlockElement('milestoneDetails')\">
2535                                         New version of Tiny-Tiny RSS ($latest_version) is available (click for details)</a>
2536                                         <div id=\"milestoneDetails\">$content</div></div>";
2537                         }
2538                 }
2539         }
2540
2541         function markArticlesById($link, $ids, $cmode) {
2542
2543                 $tmp_ids = array();
2544
2545                 foreach ($ids as $id) {
2546                         array_push($tmp_ids, "ref_id = '$id'");
2547                 }
2548
2549                 $ids_qpart = join(" OR ", $tmp_ids);
2550
2551                 if ($cmode == 0) {
2552                         db_query($link, "UPDATE ttrss_user_entries SET
2553                         marked = false,last_read = NOW()
2554                         WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
2555                 } else if ($cmode == 1) {
2556                         db_query($link, "UPDATE ttrss_user_entries SET
2557                         marked = true
2558                         WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
2559                 } else {
2560                         db_query($link, "UPDATE ttrss_user_entries SET
2561                         marked = NOT marked,last_read = NOW()
2562                         WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
2563                 }
2564         }
2565
2566         function catchupArticlesById($link, $ids, $cmode) {
2567
2568                 $tmp_ids = array();
2569
2570                 foreach ($ids as $id) {
2571                         array_push($tmp_ids, "ref_id = '$id'");
2572                 }
2573
2574                 $ids_qpart = join(" OR ", $tmp_ids);
2575
2576                 if ($cmode == 0) {
2577                         db_query($link, "UPDATE ttrss_user_entries SET
2578                         unread = false,last_read = NOW()
2579                         WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
2580                 } else if ($cmode == 1) {
2581                         db_query($link, "UPDATE ttrss_user_entries SET
2582                         unread = true
2583                         WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
2584                 } else {
2585                         db_query($link, "UPDATE ttrss_user_entries SET
2586                         unread = NOT unread,last_read = NOW()
2587                         WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
2588                 }
2589         }
2590
2591         function escape_for_form($s) {
2592                 return htmlspecialchars(db_unescape_string($s));
2593         }
2594
2595         function make_guid_from_title($title) {
2596                 return preg_replace("/[ \"\',.:;]/", "-",
2597                         mb_strtolower(strip_tags($title)));
2598         }
2599
2600         function print_headline_subtoolbar($link, $feed_site_url, $feed_title,
2601                         $bottom = false, $rtl_content = false, $feed_id = 0,
2602                         $is_cat = false, $search = false, $match_on = false,
2603                         $search_mode = false) {
2604
2605                         if (!$bottom) {
2606                                 $class = "headlinesSubToolbar";
2607                                 $tid = "headlineActionsTop";
2608                         } else {
2609                                 $class = "headlinesSubToolbar";
2610                                 $tid = "headlineActionsBottom";
2611                         }
2612
2613                         print "<table class=\"$class\" id=\"$tid\"
2614                                 width=\"100%\" cellspacing=\"0\" cellpadding=\"0\"><tr>";
2615
2616                         if ($rtl_content) {
2617                                 $rtl_cpart = "RTL";
2618                         } else {
2619                                 $rtl_cpart = "";
2620                         }
2621
2622                         if (!get_pref($link, 'COMBINED_DISPLAY_MODE')) {
2623
2624                                 print "<td class=\"headlineActions$rtl_cpart\">
2625                                         Select:
2626                                                                 <a href=\"javascript:selectTableRowsByIdPrefix('headlinesList', 'RROW-', 'RCHK-', true, '', true)\">All</a>,
2627                                                                 <a href=\"javascript:selectTableRowsByIdPrefix('headlinesList', 'RROW-', 'RCHK-', true, 'Unread', true)\">Unread</a>,
2628                                                                 <a href=\"javascript:selectTableRowsByIdPrefix('headlinesList', 'RROW-', 'RCHK-', false)\">None</a>
2629                                                 &nbsp;&nbsp;
2630                                                 Toggle: <a href=\"javascript:selectionToggleUnread()\">Unread</a>,
2631                                                         <a href=\"javascript:selectionToggleMarked()\">Starred</a>
2632                                                 &nbsp;&nbsp;
2633                                                 Mark as read:
2634                                                         <a href=\"#\" onclick=\"catchupPage()\">Page</a>,
2635                                                         <a href=\"#\" onclick=\"catchupCurrentFeed()\">Feed</a>";
2636                                 print "</td>";
2637
2638                                 if ($search && $feed_id > 0 && get_pref($link, 'ENABLE_LABELS') && GLOBAL_ENABLE_LABELS) {
2639                                         print "<td class=\"headlineActions$rtl_cpart\">
2640                                                 <a href=\"javascript:labelFromSearch('$search', '$search_mode',
2641                                                                 '$match_on', '$feed_id', '$is_cat');\">
2642                                                         Convert this search to label</a></td>";
2643                                 }
2644
2645                         } else {
2646
2647                                 print "<td class=\"headlineActions$rtl_cpart\">
2648                                         Select:
2649                                                                 <a href=\"javascript:cdmSelectArticles('all')\">All</a>,
2650                                                                 <a href=\"javascript:cdmSelectArticles('unread')\">Unread</a>,
2651                                                                 <a href=\"javascript:cdmSelectArticles('none')\">None</a>
2652                                                 &nbsp;&nbsp;
2653                                                 Toggle: <a href=\"javascript:selectionToggleUnread(true)\">Unread</a>,
2654                                                                 <a href=\"javascript:selectionToggleMarked(true)\">Starred</a>";
2655
2656                                 print "</td>";
2657
2658                         }
2659
2660                         print "<td class=\"headlineTitle$rtl_cpart\">";
2661
2662                         if ($feed_site_url) {
2663                                 if (!$bottom) {
2664                                         $target = "target=\"_blank\"";
2665                                 }
2666                                 print "<a $target href=\"$feed_site_url\">$feed_title</a>";
2667                         } else {
2668                                 print $feed_title;
2669                         }
2670
2671                         if ($search) {
2672                                 $search_q = "&q=$search&m=$match_on&smode=$search_mode";
2673                         }
2674
2675                         if (!$bottom) {
2676                                 print "&nbsp;
2677                                         <a target=\"_new\"
2678                                                 href=\"backend.php?op=rss&id=$feed_id&is_cat=$is_cat$search_q\">
2679                                                 <img class=\"noborder\"
2680                                                         alt=\"Generated feed\" src=\"images/feed-icon-12x12.png\">
2681                                         </a>";
2682                         }
2683
2684                         print "</td>";
2685                         print "</tr></table>";
2686
2687                 }
2688
2689 ?>