classes/handler/public.php

   1 <?php
   2 class Handler_Public extends Handler {
   3
   4         private function generate_syndicated_feed($owner_uid, $feed, $is_cat,
   5                 $limit, $offset, $search, $search_mode, $match_on,
   6                 $view_mode = false, $format = 'atom') {
   7
   8                 require_once "lib/MiniTemplator.class.php";
   9
  10                 $note_style =   "background-color : #fff7d5;
  11                         border-width : 1px; ".
  12                         "padding : 5px; border-style : dashed; border-color : #e7d796;".
  13                         "margin-bottom : 1em; color : #9a8c59;";
  14
  15                 if (!$limit) $limit = 100;
  16
  17                 if (get_pref($this->link, "SORT_HEADLINES_BY_FEED_DATE", $owner_uid)) {
  18                         $date_sort_field = "updated";
  19                 } else {
  20                         $date_sort_field = "date_entered";
  21                 }
  22
  23                 if ($feed == -2)
  24                         $date_sort_field = "last_read";
  25
  26                 $qfh_ret = queryFeedHeadlines($this->link, $feed,
  27                         $limit, $view_mode, $is_cat, $search, $search_mode,
  28                         $match_on, "$date_sort_field DESC", $offset, $owner_uid);
  29
  30                 $result = $qfh_ret[0];
  31                 $feed_title = htmlspecialchars($qfh_ret[1]);
  32                 $feed_site_url = $qfh_ret[2];
  33                 $last_error = $qfh_ret[3];
  34
  35                 $feed_self_url = get_self_url_prefix() .
  36                         "/public.php?op=rss&id=-2&key=" .
  37                         get_feed_access_key($this->link, -2, false, $owner_uid);
  38
  39                 if (!$feed_site_url) $feed_site_url = get_self_url_prefix();
  40
  41                 if ($format == 'atom') {
  42                         $tpl = new MiniTemplator;
  43
  44                         $tpl->readTemplateFromFile("templates/generated_feed.txt");
  45
  46                         $tpl->setVariable('FEED_TITLE', $feed_title, true);
  47                         $tpl->setVariable('VERSION', VERSION, true);
  48                         $tpl->setVariable('FEED_URL', htmlspecialchars($feed_self_url), true);
  49
  50                         if (PUBSUBHUBBUB_HUB && $feed == -2) {
  51                                 $tpl->setVariable('HUB_URL', htmlspecialchars(PUBSUBHUBBUB_HUB), true);
  52                                 $tpl->addBlock('feed_hub');
  53                         }
  54
  55                         $tpl->setVariable('SELF_URL', htmlspecialchars(get_self_url_prefix()), true);
  56
  57                         while ($line = db_fetch_assoc($result)) {
  58                                 $tpl->setVariable('ARTICLE_ID', htmlspecialchars($line['link']), true);
  59                                 $tpl->setVariable('ARTICLE_LINK', htmlspecialchars($line['link']), true);
  60                                 $tpl->setVariable('ARTICLE_TITLE', htmlspecialchars($line['title']), true);
  61                                 $tpl->setVariable('ARTICLE_EXCERPT',
  62                                         truncate_string(strip_tags($line["content_preview"]), 100, '...'), true);
  63
  64                                 $content = sanitize($this->link, $line["content_preview"], false, $owner_uid);
  65
  66                                 if ($line['note']) {
  67                                         $content = "<div style=\"$note_style\">Article note: " . $line['note'] . "</div>" .
  68                                                 $content;
  69                                 }
  70
  71                                 $tpl->setVariable('ARTICLE_CONTENT', $content, true);
  72
  73                                 $tpl->setVariable('ARTICLE_UPDATED_ATOM',
  74                                         date('c', strtotime($line["updated"])), true);
  75                                 $tpl->setVariable('ARTICLE_UPDATED_RFC822',
  76                                         date(DATE_RFC822, strtotime($line["updated"])), true);
  77
  78                                 $tpl->setVariable('ARTICLE_AUTHOR', htmlspecialchars($line['author']), true);
  79
  80                                 $tags = get_article_tags($this->link, $line["id"], $owner_uid);
  81
  82                                 foreach ($tags as $tag) {
  83                                         $tpl->setVariable('ARTICLE_CATEGORY', htmlspecialchars($tag), true);
  84                                         $tpl->addBlock('category');
  85                                 }
  86
  87                                 $enclosures = get_article_enclosures($this->link, $line["id"]);
  88
  89                                 foreach ($enclosures as $e) {
  90                                         $type = htmlspecialchars($e['content_type']);
  91                                         $url = htmlspecialchars($e['content_url']);
  92                                         $length = $e['duration'];
  93
  94                                         $tpl->setVariable('ARTICLE_ENCLOSURE_URL', $url, true);
  95                                         $tpl->setVariable('ARTICLE_ENCLOSURE_TYPE', $type, true);
  96                                         $tpl->setVariable('ARTICLE_ENCLOSURE_LENGTH', $length, true);
  97
  98                                         $tpl->addBlock('enclosure');
  99                                 }
 100
 101                                 $tpl->addBlock('entry');
 102                         }
 103
 104                         $tmp = "";
 105
 106                         $tpl->addBlock('feed');
 107                         $tpl->generateOutputToString($tmp);
 108
 109                         header("Content-Type: text/xml; charset=utf-8");
 110
 111                         print $tmp;
 112                 } else if ($format == 'json') {
 113
 114                         $feed = array();
 115
 116                         $feed['title'] = $feed_title;
 117                         $feed['version'] = VERSION;
 118                         $feed['feed_url'] = $feed_self_url;
 119
 120                         if (PUBSUBHUBBUB_HUB && $feed == -2) {
 121                                 $feed['hub_url'] = PUBSUBHUBBUB_HUB;
 122                         }
 123
 124                         $feed['self_url'] = get_self_url_prefix();
 125
 126                         $feed['articles'] = array();
 127
 128                         while ($line = db_fetch_assoc($result)) {
 129                                 $article = array();
 130
 131                                 $article['id'] = $line['link'];
 132                                 $article['link']        = $line['link'];
 133                                 $article['title'] = $line['title'];
 134                                 $article['excerpt'] = truncate_string(strip_tags($line["content_preview"]), 100, '...');
 135                                 $article['content'] = sanitize($this->link, $line["content_preview"], false, $owner_uid);
 136                                 $article['updated'] = date('c', strtotime($line["updated"]));
 137
 138                                 if ($line['note']) $article['note'] = $line['note'];
 139                                 if ($article['author']) $article['author'] = $line['author'];
 140
 141                                 $tags = get_article_tags($this->link, $line["id"], $owner_uid);
 142
 143                                 if (count($tags) > 0) {
 144                                         $article['tags'] = array();
 145
 146                                         foreach ($tags as $tag) {
 147                                                 array_push($article['tags'], $tag);
 148                                         }
 149                                 }
 150
 151                                 $enclosures = get_article_enclosures($this->link, $line["id"]);
 152
 153                                 if (count($enclosures) > 0) {
 154                                         $article['enclosures'] = array();
 155
 156                                         foreach ($enclosures as $e) {
 157                                                 $type = $e['content_type'];
 158                                                 $url = $e['content_url'];
 159                                                 $length = $e['duration'];
 160
 161                                                 array_push($article['enclosures'], array("url" => $url, "type" => $type, "length" => $length));
 162                                         }
 163                                 }
 164
 165                                 array_push($feed['articles'], $article);
 166                         }
 167
 168                         header("Content-Type: text/plain; charset=utf-8");
 169
 170                         print json_encode($feed);
 171
 172                 } else {
 173                         header("Content-Type: text/plain; charset=utf-8");
 174                         print json_encode(array("error" => array("message" => "Unknown format")));
 175                 }
 176         }
 177
 178         function getUnread() {
 179                 $login = db_escape_string($_REQUEST["login"]);
 180                 $fresh = $_REQUEST["fresh"] == "1";
 181
 182                 $result = db_query($this->link, "SELECT id FROM ttrss_users WHERE login = '$login'");
 183
 184                 if (db_num_rows($result) == 1) {
 185                         $uid = db_fetch_result($result, 0, "id");
 186
 187                         print getGlobalUnread($this->link, $uid);
 188
 189                         if ($fresh) {
 190                                 print ";";
 191                                 print getFeedArticles($this->link, -3, false, true, $uid);
 192                         }
 193
 194                 } else {
 195                         print "-1;User not found";
 196                 }
 197
 198         }
 199
 200         function getProfiles() {
 201                 $login = db_escape_string($_REQUEST["login"]);
 202
 203                 $result = db_query($this->link, "SELECT * FROM ttrss_settings_profiles,ttrss_users
 204                         WHERE ttrss_users.id = ttrss_settings_profiles.owner_uid AND login = '$login' ORDER BY title");
 205
 206                 print "<select dojoType='dijit.form.Select' style='width : 220px; margin : 0px' name='profile'>";
 207
 208                 print "<option value='0'>" . __("Default profile") . "</option>";
 209
 210                 while ($line = db_fetch_assoc($result)) {
 211                         $id = $line["id"];
 212                         $title = $line["title"];
 213
 214                         print "<option value='$id'>$title</option>";
 215                 }
 216
 217                 print "</select>";
 218         }
 219
 220         function pubsub() {
 221                 $mode = db_escape_string($_REQUEST['hub_mode']);
 222                 $feed_id = (int) db_escape_string($_REQUEST['id']);
 223                 $feed_url = db_escape_string($_REQUEST['hub_topic']);
 224
 225                 if (!PUBSUBHUBBUB_ENABLED) {
 226                         header('HTTP/1.0 404 Not Found');
 227                         echo "404 Not found";
 228                         return;
 229                 }
 230
 231                 // TODO: implement hub_verifytoken checking
 232
 233                 $result = db_query($this->link, "SELECT feed_url FROM ttrss_feeds
 234                         WHERE id = '$feed_id'");
 235
 236                 if (db_num_rows($result) != 0) {
 237
 238                         $check_feed_url = db_fetch_result($result, 0, "feed_url");
 239
 240                         if ($check_feed_url && ($check_feed_url == $feed_url || !$feed_url)) {
 241                                 if ($mode == "subscribe") {
 242
 243                                         db_query($this->link, "UPDATE ttrss_feeds SET pubsub_state = 2
 244                                                 WHERE id = '$feed_id'");
 245
 246                                         print $_REQUEST['hub_challenge'];
 247                                         return;
 248
 249                                 } else if ($mode == "unsubscribe") {
 250
 251                                         db_query($this->link, "UPDATE ttrss_feeds SET pubsub_state = 0
 252                                                 WHERE id = '$feed_id'");
 253
 254                                         print $_REQUEST['hub_challenge'];
 255                                         return;
 256
 257                                 } else if (!$mode) {
 258
 259                                         // Received update ping, schedule feed update.
 260                                         //update_rss_feed($this->link, $feed_id, true, true);
 261
 262                                         db_query($this->link, "UPDATE ttrss_feeds SET
 263                                                 last_update_started = '1970-01-01',
 264                                                 last_updated = '1970-01-01' WHERE id = '$feed_id'");
 265
 266                                 }
 267                         } else {
 268                                 header('HTTP/1.0 404 Not Found');
 269                                 echo "404 Not found";
 270                         }
 271                 } else {
 272                         header('HTTP/1.0 404 Not Found');
 273                         echo "404 Not found";
 274                 }
 275
 276         }
 277
 278         function logout() {
 279                 logout_user();
 280                 header("Location: index.php");
 281         }
 282
 283         function fbexport() {
 284
 285                 $access_key = db_escape_string($_POST["key"]);
 286
 287                 // TODO: rate limit checking using last_connected
 288                 $result = db_query($this->link, "SELECT id FROM ttrss_linked_instances
 289                         WHERE access_key = '$access_key'");
 290
 291                 if (db_num_rows($result) == 1) {
 292
 293                         $instance_id = db_fetch_result($result, 0, "id");
 294
 295                         $result = db_query($this->link, "SELECT feed_url, site_url, title, subscribers
 296                                 FROM ttrss_feedbrowser_cache ORDER BY subscribers DESC LIMIT 100");
 297
 298                         $feeds = array();
 299
 300                         while ($line = db_fetch_assoc($result)) {
 301                                 array_push($feeds, $line);
 302                         }
 303
 304                         db_query($this->link, "UPDATE ttrss_linked_instances SET
 305                                 last_status_in = 1 WHERE id = '$instance_id'");
 306
 307                         print json_encode(array("feeds" => $feeds));
 308                 } else {
 309                         print json_encode(array("error" => array("code" => 6)));
 310                 }
 311         }
 312
 313         function share() {
 314                 $uuid = db_escape_string($_REQUEST["key"]);
 315
 316                 $result = db_query($this->link, "SELECT ref_id, owner_uid FROM ttrss_user_entries WHERE
 317                         uuid = '$uuid'");
 318
 319                 if (db_num_rows($result) != 0) {
 320                         header("Content-Type: text/html");
 321
 322                         $id = db_fetch_result($result, 0, "ref_id");
 323                         $owner_uid = db_fetch_result($result, 0, "owner_uid");
 324
 325                         $article = format_article($this->link, $id, false, true, $owner_uid);
 326
 327                         print_r($article['content']);
 328
 329                 } else {
 330                         print "Article not found.";
 331                 }
 332
 333         }
 334
 335         function rss() {
 336                 $feed = db_escape_string($_REQUEST["id"]);
 337                 $key = db_escape_string($_REQUEST["key"]);
 338                 $is_cat = $_REQUEST["is_cat"] != false;
 339                 $limit = (int)db_escape_string($_REQUEST["limit"]);
 340                 $offset = (int)db_escape_string($_REQUEST["offset"]);
 341
 342                 $search = db_escape_string($_REQUEST["q"]);
 343                 $match_on = db_escape_string($_REQUEST["m"]);
 344                 $search_mode = db_escape_string($_REQUEST["smode"]);
 345                 $view_mode = db_escape_string($_REQUEST["view-mode"]);
 346
 347                 $format = db_escape_string($_REQUEST['format']);
 348
 349                 if (!$format) $format = 'atom';
 350
 351                 if (SINGLE_USER_MODE) {
 352                         authenticate_user($this->link, "admin", null);
 353                 }
 354
 355                 $owner_id = false;
 356
 357                 if ($key) {
 358                         $result = db_query($this->link, "SELECT owner_uid FROM
 359                                 ttrss_access_keys WHERE access_key = '$key' AND feed_id = '$feed'");
 360
 361                         if (db_num_rows($result) == 1)
 362                                 $owner_id = db_fetch_result($result, 0, "owner_uid");
 363                 }
 364
 365                 if ($owner_id) {
 366                         $this->generate_syndicated_feed($owner_id, $feed, $is_cat, $limit,
 367                                 $offset, $search, $search_mode, $match_on, $view_mode, $format);
 368                 } else {
 369                         header('HTTP/1.1 403 Forbidden');
 370                 }
 371         }
 372
 373         function globalUpdateFeeds() {
 374                 include "rssfuncs.php";
 375                 // Update all feeds needing a update.
 376                 update_daemon_common($this->link, 0, true, false);
 377         }
 378
 379         function sharepopup() {
 380                 if (SINGLE_USER_MODE) {
 381                         login_sequence($this->link);
 382                 }
 383
 384                 header('Content-Type: text/html; charset=utf-8');
 385                 print "<html>
 386                                 <head>
 387                                         <title>Tiny Tiny RSS</title>
 388                                         <link rel=\"stylesheet\" type=\"text/css\" href=\"utility.css\">
 389                                         <script type=\"text/javascript\" src=\"lib/prototype.js\"></script>
 390                                         <script type=\"text/javascript\" src=\"lib/scriptaculous/scriptaculous.js?load=effects,dragdrop,controls\"></script>
 391                                         <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"/>
 392                                 </head>
 393                                 <body id='sharepopup'>";
 394
 395                 $action = $_REQUEST["action"];
 396
 397                 if ($_SESSION["uid"]) {
 398
 399                         if ($action == 'share') {
 400
 401                                 $title = db_escape_string(strip_tags($_REQUEST["title"]));
 402                                 $url = db_escape_string(strip_tags($_REQUEST["url"]));
 403                                 $content = db_escape_string(strip_tags($_REQUEST["content"]));
 404                                 $labels = db_escape_string(strip_tags($_REQUEST["labels"]));
 405
 406                                 create_published_article($this->link, $title, $url, $content, $labels,
 407                                         $_SESSION["uid"]);
 408
 409                                 print "<script type='text/javascript'>";
 410                                 print "window.close();";
 411                                 print "</script>";
 412
 413                         } else {
 414                                 $title = htmlspecialchars($_REQUEST["title"]);
 415                                 $url = htmlspecialchars($_REQUEST["url"]);
 416
 417                                 ?>
 418
 419                                 <table height='100%' width='100%'><tr><td colspan='2'>
 420                                 <h1><?php echo __("Share with Tiny Tiny RSS") ?></h1>
 421                                 </td></tr>
 422
 423                                 <form id='share_form' name='share_form'>
 424
 425                                 <input type="hidden" name="op" value="sharepopup">
 426                                 <input type="hidden" name="action" value="share">
 427
 428                                 <tr><td align='right'><?php echo __("Title:") ?></td>
 429                                 <td width='80%'><input name='title' value="<?php echo $title ?>"></td></tr>
 430                                 <tr><td align='right'><?php echo __("URL:") ?></td>
 431                                 <td><input name='url' value="<?php echo $url ?>"></td></tr>
 432                                 <tr><td align='right'><?php echo __("Content:") ?></td>
 433                                 <td><input name='content' value=""></td></tr>
 434                                 <tr><td align='right'><?php echo __("Labels:") ?></td>
 435                                 <td><input name='labels' id="labels_value"
 436                                         placeholder='Alpha, Beta, Gamma' value="">
 437                                 </td></tr>
 438
 439                                 <tr><td>
 440                                         <div class="autocomplete" id="labels_choices"
 441                                                 style="display : block"></div></td></tr>
 442
 443                                 <script type='text/javascript'>document.forms[0].title.focus();</script>
 444
 445                                 <script type='text/javascript'>
 446                                         new Ajax.Autocompleter('labels_value', 'labels_choices',
 447                                    "backend.php?op=rpc&method=completeLabels",
 448                                    { tokens: ',', paramName: "search" });
 449                                 </script>
 450
 451                                 <tr><td colspan='2'>
 452                                         <div style='float : right' class='insensitive-small'>
 453                                         <?php echo __("Shared article will appear in the Published feed.") ?>
 454                                         </div>
 455                                         <button type="submit"><?php echo __('Share') ?></button>
 456                                         <button onclick="return window.close()"><?php echo __('Cancel') ?></button>
 457                                         </div>
 458
 459                                 </form>
 460                                 </td></tr></table>
 461                                 </body></html>
 462                                 <?php
 463
 464                         }
 465
 466                 } else {
 467
 468                         $return = urlencode($_SERVER["REQUEST_URI"])
 469                         ?>
 470
 471                         <form action="public.php?return=<?php echo $return ?>"
 472                                 method="POST" id="loginForm" name="loginForm">
 473
 474                         <input type="hidden" name="op" value="login">
 475
 476                         <table height='100%' width='100%'><tr><td colspan='2'>
 477                         <h1><?php echo __("Not logged in") ?></h1></td></tr>
 478
 479                         <tr><td align="right"><?php echo __("Login:") ?></td>
 480                         <td align="right"><input name="login"
 481                                 value="<?php echo $_SESSION["fake_login"] ?>"></td></tr>
 482                                 <tr><td align="right"><?php echo __("Password:") ?></td>
 483                                 <td align="right"><input type="password" name="password"
 484                                 value="<?php echo $_SESSION["fake_password"] ?>"></td></tr>
 485                         <tr><td align="right"><?php echo __("Language:") ?></td>
 486                         <td align="right">
 487                         <?php
 488                                 print_select_hash("language", $_COOKIE["ttrss_lang"], get_translations(),
 489                                         "style='width : 100%''");
 490
 491                         ?>
 492                         </td></tr>
 493                         <tr><td colspan='2'>
 494                                 <button type="submit">
 495                                         <?php echo __('Log in') ?></button>
 496
 497                                 <button onclick="return window.close()">
 498                                         <?php echo __('Cancel') ?></button>
 499                         </td></tr>
 500                         </table>
 501
 502                         </form>
 503                         <?php
 504                 }
 505         }
 506
 507         function login() {
 508
 509                 $_SESSION["prefs_cache"] = array();
 510
 511                 if (!SINGLE_USER_MODE) {
 512
 513                         $login = db_escape_string($_POST["login"]);
 514                         $password = $_POST["password"];
 515                         $remember_me = $_POST["remember_me"];
 516
 517                         if (authenticate_user($this->link, $login, $password)) {
 518                                 $_POST["password"] = "";
 519
 520                                 $_SESSION["language"] = $_POST["language"];
 521                                 $_SESSION["ref_schema_version"] = get_schema_version($this->link, true);
 522                                 $_SESSION["bw_limit"] = !!$_POST["bw_limit"];
 523
 524                                 if ($_POST["profile"]) {
 525
 526                                         $profile = db_escape_string($_POST["profile"]);
 527
 528                                         $result = db_query($this->link, "SELECT id FROM ttrss_settings_profiles
 529                                                 WHERE id = '$profile' AND owner_uid = " . $_SESSION["uid"]);
 530
 531                                         if (db_num_rows($result) != 0) {
 532                                                 $_SESSION["profile"] = $profile;
 533                                                 $_SESSION["prefs_cache"] = array();
 534                                         }
 535                                 }
 536                         } else {
 537                                 $_SESSION["login_error_msg"] = __("Incorrect username or password");
 538                         }
 539
 540                         if ($_REQUEST['return']) {
 541                                 header("Location: " . $_REQUEST['return']);
 542                         } else {
 543                                 header("Location: " . SELF_URL_PATH);
 544                         }
 545                 }
 546         }
 547
 548         function subscribe() {
 549                 if (SINGLE_USER_MODE) {
 550                         login_sequence($this->link);
 551                 }
 552
 553                 if ($_SESSION["uid"]) {
 554
 555                         $feed_url = db_escape_string(trim($_REQUEST["feed_url"]));
 556
 557                         header('Content-Type: text/html; charset=utf-8');
 558                         print "<html>
 559                                 <head>
 560                                         <title>Tiny Tiny RSS</title>
 561                                         <link rel=\"stylesheet\" type=\"text/css\" href=\"utility.css\">
 562                                         <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"/>
 563                                 </head>
 564                                 <body>
 565                                 <img class=\"floatingLogo\" src=\"images/logo_wide.png\"
 566                                         alt=\"Tiny Tiny RSS\"/>
 567                                         <h1>".__("Subscribe to feed...")."</h1>";
 568
 569                         $rc = subscribe_to_feed($this->link, $feed_url);
 570
 571                         switch ($rc['code']) {
 572                         case 0:
 573                                 print_warning(T_sprintf("Already subscribed to <b>%s</b>.", $feed_url));
 574                                 break;
 575                         case 1:
 576                                 print_notice(T_sprintf("Subscribed to <b>%s</b>.", $feed_url));
 577                                 break;
 578                         case 2:
 579                                 print_error(T_sprintf("Could not subscribe to <b>%s</b>.", $feed_url));
 580                                 break;
 581                         case 3:
 582                                 print_error(T_sprintf("No feeds found in <b>%s</b>.", $feed_url));
 583                                 break;
 584                         case 4:
 585                                 print_notice(__("Multiple feed URLs found."));
 586                                 $feed_urls = $rc["feeds"];
 587                                 break;
 588                         case 5:
 589                                 print_error(T_sprintf("Could not subscribe to <b>%s</b>.<br>Can't download the Feed URL.", $feed_url));
 590                                 break;
 591                         }
 592
 593                         if ($feed_urls) {
 594
 595                                 print "<form action=\"public.php\">";
 596                                 print "<input type=\"hidden\" name=\"op\" value=\"subscribe\">";
 597
 598                                 print "<select name=\"feed_url\">";
 599
 600                                 foreach ($feed_urls as $url => $name) {
 601                                         $url = htmlspecialchars($url);
 602                                         $name = htmlspecialchars($name);
 603
 604                                         print "<option value=\"$url\">$name</option>";
 605                                 }
 606
 607                                 print "<input type=\"submit\" value=\"".__("Subscribe to selected feed").
 608                                         "\">";
 609
 610                                 print "</form>";
 611                         }
 612
 613                         $tp_uri = get_self_url_prefix() . "/prefs.php";
 614                         $tt_uri = get_self_url_prefix();
 615
 616                         if ($rc['code'] <= 2){
 617                                 $result = db_query($this->link, "SELECT id FROM ttrss_feeds WHERE
 618                                         feed_url = '$feed_url' AND owner_uid = " . $_SESSION["uid"]);
 619
 620                                 $feed_id = db_fetch_result($result, 0, "id");
 621                         } else {
 622                                 $feed_id = 0;
 623                         }
 624                         print "<p>";
 625
 626                         if ($feed_id) {
 627                                 print "<form method=\"GET\" style='display: inline'
 628                                         action=\"$tp_uri\">
 629                                         <input type=\"hidden\" name=\"tab\" value=\"feedConfig\">
 630                                         <input type=\"hidden\" name=\"method\" value=\"editFeed\">
 631                                         <input type=\"hidden\" name=\"methodparam\" value=\"$feed_id\">
 632                                         <input type=\"submit\" value=\"".__("Edit subscription options")."\">
 633                                         </form>";
 634                         }
 635
 636                         print "<form style='display: inline' method=\"GET\" action=\"$tt_uri\">
 637                                 <input type=\"submit\" value=\"".__("Return to Tiny Tiny RSS")."\">
 638                                 </form></p>";
 639
 640                         print "</body></html>";
 641
 642                 } else {
 643                         render_login_form($this->link);
 644                 }
 645         }
 646
 647         function subscribe2() {
 648                 $feed_url = db_escape_string(trim($_REQUEST["feed_url"]));
 649                 $cat_id = db_escape_string($_REQUEST["cat_id"]);
 650                 $from = db_escape_string($_REQUEST["from"]);
 651
 652                 /* only read authentication information from POST */
 653
 654                 $auth_login = db_escape_string(trim($_POST["auth_login"]));
 655                 $auth_pass = db_escape_string(trim($_POST["auth_pass"]));
 656
 657                 $rc = subscribe_to_feed($this->link, $feed_url, $cat_id, $auth_login, $auth_pass);
 658
 659                 switch ($rc) {
 660                 case 1:
 661                         print_notice(T_sprintf("Subscribed to <b>%s</b>.", $feed_url));
 662                         break;
 663                 case 2:
 664                         print_error(T_sprintf("Could not subscribe to <b>%s</b>.", $feed_url));
 665                         break;
 666                 case 3:
 667                         print_error(T_sprintf("No feeds found in <b>%s</b>.", $feed_url));
 668                         break;
 669                 case 0:
 670                         print_warning(T_sprintf("Already subscribed to <b>%s</b>.", $feed_url));
 671                         break;
 672                 case 4:
 673                         print_notice(__("Multiple feed URLs found."));
 674
 675                         $feed_urls = get_feeds_from_html($feed_url);
 676                         break;
 677                 case 5:
 678                         print_error(T_sprintf("Could not subscribe to <b>%s</b>.<br>Can't download the Feed URL.", $feed_url));
 679                         break;
 680                 }
 681
 682                 if ($feed_urls) {
 683                         print "<form action=\"backend.php\">";
 684                         print "<input type=\"hidden\" name=\"op\" value=\"pref-feeds\">";
 685                         print "<input type=\"hidden\" name=\"quiet\" value=\"1\">";
 686                         print "<input type=\"hidden\" name=\"method\" value=\"add\">";
 687
 688                         print "<select name=\"feed_url\">";
 689
 690                         foreach ($feed_urls as $url => $name) {
 691                                 $url = htmlspecialchars($url);
 692                                 $name = htmlspecialchars($name);
 693                                 print "<option value=\"$url\">$name</option>";
 694                         }
 695
 696                         print "<input type=\"submit\" value=\"".__("Subscribe to selected feed")."\">";
 697                         print "</form>";
 698                 }
 699
 700                 $tp_uri = get_self_url_prefix() . "/prefs.php";
 701                 $tt_uri = get_self_url_prefix();
 702
 703                 if ($rc <= 2){
 704                         $result = db_query($this->link, "SELECT id FROM ttrss_feeds WHERE
 705                                 feed_url = '$feed_url' AND owner_uid = " . $_SESSION["uid"]);
 706
 707                         $feed_id = db_fetch_result($result, 0, "id");
 708                 } else {
 709                         $feed_id = 0;
 710                 }
 711
 712                 print "<p>";
 713
 714                 if ($feed_id) {
 715                         print "<form method=\"GET\" style='display: inline'
 716                                 action=\"$tp_uri\">
 717                                 <input type=\"hidden\" name=\"tab\" value=\"feedConfig\">
 718                                 <input type=\"hidden\" name=\"method\" value=\"editFeed\">
 719                                 <input type=\"hidden\" name=\"methodparam\" value=\"$feed_id\">
 720                                 <input type=\"submit\" value=\"".__("Edit subscription options")."\">
 721                                 </form>";
 722                 }
 723
 724                 print "<form style='display: inline' method=\"GET\" action=\"$tt_uri\">
 725                         <input type=\"submit\" value=\"".__("Return to Tiny Tiny RSS")."\">
 726                         </form></p>";
 727
 728                 print "</body></html>";
 729         }
 730
 731         function index() {
 732                 header("Content-Type: text/plain");
 733                 print json_encode(array("error" => array("code" => 7)));
 734         }
 735
 736 }
 737 ?>