backend.php

   1 <?
   2 //      header("Content-Type: application/xml");
   3
   4         require_once "config.php";
   5         require_once "db.php";
   6         require_once "functions.php";
   7         require_once "magpierss/rss_fetch.inc";
   8
   9         $link = db_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);
  10
  11         if (DB_TYPE == "pgsql") {
  12                 pg_query("set client_encoding = 'utf-8'");
  13         }
  14
  15         $op = $_GET["op"];
  16         $fetch = $_GET["fetch"];
  17
  18         function outputFeedList($link) {
  19
  20                 print "<html><head>
  21                         <title>Tiny Tiny RSS : Feedlist</title>
  22                         <link rel=\"stylesheet\" href=\"tt-rss.css\" type=\"text/css\">
  23                         <script type=\"text/javascript\" src=\"functions.js\"></script>
  24                         <script type=\"text/javascript\" src=\"feedlist.js\"></script>
  25                         <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">
  26                         </head><body>";
  27
  28                 print "<ul class=\"feedList\" id=\"feedList\">";
  29
  30                 /* virtual feeds */
  31
  32                 $result = db_query($link, "SELECT count(id) as num_starred
  33                         FROM ttrss_entries WHERE marked = true");
  34                 $num_starred = db_fetch_result($result, 0, "num_starred");
  35
  36                 printFeedEntry(-1, "odd", "Starred articles", $num_starred, "images/mark_set.png");
  37
  38                 if (ENABLE_LABELS) {
  39
  40                         $result = db_query($link, "SELECT id,description FROM
  41                                 ttrss_labels ORDER by description");
  42
  43                         if (db_num_rows($result) > 0) {
  44                                 print "<li><hr></li>";
  45                         }
  46
  47                         while ($line = db_fetch_assoc($result)) {
  48
  49                                 printFeedEntry(-$line["id"]-11,
  50                                         "odd", $line["description"], 0, "images/label.png");
  51
  52                         }
  53                 }
  54
  55                 print "<li><hr></li>";
  56
  57                 $result = db_query($link, "SELECT *,
  58                         (SELECT count(id) FROM ttrss_entries
  59                                 WHERE feed_id = ttrss_feeds.id) AS total,
  60                         (SELECT count(id) FROM ttrss_entries
  61                                 WHERE feed_id = ttrss_feeds.id AND unread = true) as unread
  62                         FROM ttrss_feeds ORDER BY title");
  63
  64                 $actid = $_GET["actid"];
  65
  66                 /* real feeds */
  67
  68                 $lnum = 0;
  69
  70                 $total_unread = 0;
  71
  72                 while ($line = db_fetch_assoc($result)) {
  73
  74                         $feed = $line["title"];
  75                         $feed_id = $line["id"];
  76
  77                         $subop = $_GET["subop"];
  78
  79                         $total = $line["total"];
  80                         $unread = $line["unread"];
  81
  82 //                      $class = ($lnum % 2) ? "even" : "odd";
  83
  84                         $class = "odd";
  85
  86                         if ($unread > 0) $class .= "Unread";
  87
  88                         if ($actid == $feed_id) {
  89                                 $class .= "Selected";
  90                         }
  91
  92                         $total_unread += $unread;
  93
  94                         printFeedEntry($feed_id, $class, $feed, $unread, "icons/$feed_id.ico");
  95
  96                         ++$lnum;
  97                 }
  98
  99                 print "</table>";
 100
 101                 print "<div class=\"invisible\" id=\"FEEDTU\">$total_unread</div>";
 102
 103         }
 104
 105
 106         if ($op == "rpc") {
 107
 108                 $subop = $_GET["subop"];
 109
 110                 if ($subop == "mark") {
 111                         $mark = $_GET["mark"];
 112                         $id = db_escape_string($_GET["id"]);
 113
 114                         if ($mark == "1") {
 115                                 $mark = "true";
 116                         } else {
 117                                 $mark = "false";
 118                         }
 119
 120                         $result = db_query($link, "UPDATE ttrss_entries SET marked = $mark
 121                                 WHERE id = '$id'");
 122                 }
 123
 124                 if ($subop == "updateFeed") {
 125                         $feed_id = db_escape_string($_GET["feed"]);
 126
 127                         $result = db_query($link,
 128                                 "SELECT feed_url FROM ttrss_feeds WHERE id = '$feed_id'");
 129
 130                         if (db_num_rows($result) > 0) {
 131                                 $feed_url = db_fetch_result($result, 0, "feed_url");
 132 //                              update_rss_feed($link, $feed_url, $feed_id);
 133                         }
 134
 135                         print "DONE-$feed_id";
 136
 137                         return;
 138                 }
 139
 140                 if ($subop == "forceUpdateAllFeeds") {
 141                         update_all_feeds($link, true);
 142                 }
 143
 144                 if ($subop == "updateAllFeeds") {
 145                         update_all_feeds($link, false);
 146                 }
 147
 148                 if ($subop == "catchupPage") {
 149
 150                         $ids = split(",", $_GET["ids"]);
 151
 152                         foreach ($ids as $id) {
 153
 154                                 db_query($link, "UPDATE ttrss_entries SET unread=false,last_read = NOW()
 155                                         WHERE id = '$id'");
 156
 157                         }
 158
 159                         print "Marked active page as read.";
 160                 }
 161
 162         }
 163
 164         if ($op == "feeds") {
 165
 166                 $subop = $_GET["subop"];
 167
 168                 if ($subop == "catchupAll") {
 169                         db_query($link, "UPDATE ttrss_entries SET last_read = NOW(),unread = false");
 170                 }
 171
 172                 outputFeedList($link);
 173
 174         }
 175
 176         if ($op == "view") {
 177
 178                 $id = $_GET["id"];
 179
 180                 $result = db_query($link, "UPDATE ttrss_entries SET unread = false,last_read = NOW() WHERE id = '$id'");
 181
 182                 $addheader = $_GET["addheader"];
 183
 184                 $result = db_query($link, "SELECT title,link,content,feed_id,comments,
 185                         (SELECT icon_url FROM ttrss_feeds WHERE id = feed_id) as icon_url
 186                         FROM ttrss_entries
 187                         WHERE   id = '$id'");
 188
 189                 if ($addheader) {
 190                         print "<html><head>
 191                                 <title>Tiny Tiny RSS : Article $id</title>
 192                                 <link rel=\"stylesheet\" href=\"tt-rss.css\" type=\"text/css\">
 193                                 <script type=\"text/javascript\" src=\"functions.js\"></script>
 194                                 <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">
 195                                 </head><body>";
 196                 }
 197
 198                 if ($result) {
 199
 200                         $line = db_fetch_assoc($result);
 201
 202                         if ($line["icon_url"]) {
 203                                 $feed_icon = "<img class=\"feedIcon\" src=\"" . $line["icon_url"] . "\">";
 204                         } else {
 205                                 $feed_icon = "&nbsp;";
 206                         }
 207
 208                         if ($line["comments"] && $line["link"] != $line["comments"]) {
 209                                 $entry_comments = "(<a href=\"".$line["comments"]."\">Comments</a>)";
 210                         } else {
 211                                 $entry_comments = "";
 212                         }
 213
 214                         print "<div class=\"postReply\">";
 215
 216                         print "<div class=\"postHeader\"><table>";
 217
 218                         print "<tr><td><b>Title:</b></td>
 219                                 <td width='100%'>" . $line["title"] . "</td></tr>";
 220
 221                         print "<tr><td><b>Link:</b></td>
 222                                 <td width='100%'>
 223                                 <a href=\"" . $line["link"] . "\">".$line["link"]."</a>
 224                                 $entry_comments</td></tr>";
 225
 226                         print "</table></div>";
 227
 228                         print "<div class=\"postIcon\">" . $feed_icon . "</div>";
 229                         print "<div class=\"postContent\">" . $line["content"] . "</div>";
 230
 231                         print "</div>";
 232
 233                 }
 234
 235                 if ($addheader) {
 236                         print "</body></html>";
 237                 }
 238         }
 239
 240         if ($op == "viewfeed") {
 241
 242                 $feed = $_GET["feed"];
 243                 $skip = $_GET["skip"];
 244                 $subop = $_GET["subop"];
 245                 $view_mode = $_GET["view"];
 246                 $addheader = $_GET["addheader"];
 247                 $limit = $_GET["limit"];
 248
 249                 if (!$feed) {
 250                         print "Error: no feed to display.";
 251                         return;
 252                 }
 253
 254                 if (!$skip) $skip = 0;
 255
 256                 if ($subop == "undefined") $subop = "";
 257
 258                 if ($addheader) {
 259                         print "<html><head>
 260                                 <title>Tiny Tiny RSS : Feed $feed</title>
 261                                 <link rel=\"stylesheet\" href=\"tt-rss.css\" type=\"text/css\">
 262                                 <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">
 263                                 <script type=\"text/javascript\" src=\"functions.js\"></script>
 264                                 <script type=\"text/javascript\" src=\"viewfeed.js\"></script>
 265                                 </head><body>";
 266                 }
 267
 268                 if ($feed >= 0) {
 269
 270                         $result = db_query($link,
 271                                 "SELECT *,SUBSTRING(last_updated,1,16) as last_updated_s
 272                                 FROM ttrss_feeds WHERE id = '$feed'");
 273
 274                         if ($result) {
 275
 276                                 $line = db_fetch_assoc($result);
 277
 278                                 update_rss_feed($link, $line["feed_url"], $feed);
 279
 280                                 if ($subop == "MarkAllRead")  {
 281
 282                                         db_query($link, "UPDATE ttrss_entries SET unread = false,last_read = NOW()
 283                                                 WHERE feed_id = '$feed'");
 284                                 }
 285                         }
 286                 }
 287
 288                 print "<table class=\"headlinesList\" id=\"headlinesList\" width=\"100%\">";
 289
 290                 $search = $_GET["search"];
 291
 292                 if ($search) {
 293                         $search_query_part = "(upper(title) LIKE upper('%$search%')
 294                                 OR content LIKE '%$search%') AND";
 295                 } else {
 296                         $search_query_part = "";
 297                 }
 298
 299                 $view_query_part = "";
 300
 301                 if ($view_mode == "Starred") {
 302                         $view_query_part = " marked = true AND ";
 303                 }
 304
 305                 if ($view_mode == "Unread") {
 306                         $view_query_part = " unread = true AND ";
 307                 }
 308
 309 /*              $result = db_query($link, "SELECT count(id) AS total_entries
 310                         FROM ttrss_entries WHERE
 311                         $search_query_part
 312                         feed_id = '$feed'");
 313
 314                 $total_entries = db_fetch_result($result, 0, "total_entries"); */
 315
 316 /*              $result = db_query("SELECT count(id) AS unread_entries
 317                         FROM ttrss_entries WHERE
 318                         $search_query_part
 319                         unread = true AND
 320                         feed_id = '$feed'");
 321
 322                 $unread_entries = db_fetch_result($result, 0, "unread_entries"); */
 323
 324                 if ($limit && $limit != "All") {
 325                         $limit_query_part = "LIMIT " . $limit;
 326                 }
 327
 328                 $vfeed_query_part = "";
 329
 330                 if ($feed >= 0) {
 331                         $query_strategy_part = "feed_id = '$feed'";
 332                 } else if ($feed == -1) { // starred virtual feed
 333                         $query_strategy_part = "marked = true";
 334                         $vfeed_query_part = "(SELECT title FROM ttrss_feeds WHERE
 335                                 id = feed_id) as feed_title,";
 336                 } else if ($feed <= -10) { // labels
 337                         $label_id = -$feed - 11;
 338
 339                         $tmp_result = db_query($link, "SELECT sql_exp FROM ttrss_labels
 340                                 WHERE id = '$label_id'");
 341
 342                         $query_strategy_part = db_fetch_result($tmp_result, 0, "sql_exp");
 343
 344                         $vfeed_query_part = "(SELECT title FROM ttrss_feeds WHERE
 345                                 id = feed_id) as feed_title,";
 346                 } else {
 347                         $query_strategy_part = "id > 0"; // dumb
 348                 }
 349
 350                 if ($feed < -10) error_reporting (0);
 351
 352                 $result = db_query($link, "SELECT
 353                                 id,title,updated,unread,feed_id,marked,link,last_read,
 354                                 SUBSTRING(last_read,1,19) as last_read_noms,
 355                                 $vfeed_query_part
 356                                 SUBSTRING(updated,1,19) as updated_noms
 357                         FROM
 358                                 ttrss_entries
 359                         WHERE
 360                         $search_query_part
 361                         $view_query_part
 362                         $query_strategy_part ORDER BY updated DESC
 363                         $limit_query_part");
 364
 365                 if (!$result) {
 366                         print "<tr><td colspan='4' align='center'>
 367                                 Could not display feed (query failed). Please check match syntax or local configuration.</td></tr>";
 368                         return;
 369                 }
 370
 371                 $lnum = 0;
 372
 373                 error_reporting (E_ERROR | E_WARNING | E_PARSE);
 374
 375                 $num_unread = 0;
 376
 377                 while ($line = db_fetch_assoc($result)) {
 378
 379                         $class = ($lnum % 2) ? "even" : "odd";
 380
 381                         $id = $line["id"];
 382                         $feed_id = $line["feed_id"];
 383
 384 //                      printf("L %d (%s) &gt; U %d (%s) = %d<br>",
 385 //                              strtotime($line["last_read_noms"]), $line["last_read_noms"],
 386 //                              strtotime($line["updated"]), $line["updated"],
 387 //                              strtotime($line["last_read"]) >= strtotime($line["updated"]));
 388
 389                         if ($line["last_read"] != "" && $line["updated"] != "" &&
 390                                 strtotime($line["last_read_noms"]) < strtotime($line["updated_noms"])) {
 391
 392                                 $update_pic = "<img id='FUPDPIC-$id' src=\"images/updated.png\"
 393                                         alt=\"Updated\">";
 394
 395                         } else {
 396
 397                                 $update_pic = "<img id='FUPDPIC-$id' src=\"images/blank_icon.gif\"
 398                                         alt=\"Updated\">";
 399
 400                         }
 401
 402                         if ($line["unread"] == "t" || $line["unread"] == "1") {
 403                                 $class .= "Unread";
 404                                 ++$num_unread;
 405                         }
 406
 407                         if ($line["marked"] == "t" || $line["marked"] == "1") {
 408                                 $marked_pic = "<img id=\"FMARKPIC-$id\" src=\"images/mark_set.png\"
 409                                         alt=\"Reset mark\" onclick='javascript:toggleMark($id, false)'>";
 410                         } else {
 411                                 $marked_pic = "<img id=\"FMARKPIC-$id\" src=\"images/mark_unset.png\"
 412                                         alt=\"Set mark\" onclick='javascript:toggleMark($id, true)'>";
 413                         }
 414
 415                         $content_link = "<a id=\"FTITLE-$id\" href=\"javascript:view($id,$feed_id);\">" .
 416                                 $line["title"] . "</a>";
 417
 418                         print "<tr class='$class' id='RROW-$id'>";
 419                         // onclick=\"javascript:view($id,$feed_id)\">
 420
 421                         print "<td valign='center' align='center'>$update_pic</td>";
 422                         print "<td valign='center' align='center'>$marked_pic</td>";
 423
 424                         print "<td width='25%'>
 425                                 <a href=\"javascript:view($id,$feed_id);\">".$line["updated"]."</a></td>";
 426
 427                         if ($line["feed_title"]) {
 428                                 print "<td width='50%'>$content_link</td>";
 429                                 print "<td width='20%'>".$line["feed_title"]."</td>";
 430                         } else {
 431                                 print "<td width='70%'>$content_link</td>";
 432                         }
 433
 434                         print "</tr>";
 435
 436                         ++$lnum;
 437                 }
 438
 439                 if ($lnum == 0) {
 440                         print "<tr><td align='center'>No entries found.</td></tr>";
 441                 }
 442
 443 /*              while ($lnum < HEADLINES_PER_PAGE) {
 444                         ++$lnum;
 445                         print "<tr><td>&nbsp;</td></tr>";
 446                 } */
 447
 448                 print "</table>";
 449
 450                 if ($feed >= 0) {
 451
 452                         $result = db_query($link, "SELECT count(id) as unread FROM ttrss_entries
 453                                 WHERE feed_id = ttrss_feeds.id AND $query_strategy_part
 454                                 AND unread = true");
 455
 456                         $unread = db_fetch_result($result, 0, "unread");
 457
 458                 } else if ($feed == -1) {
 459                         $result = db_query($link, "SELECT count(id) as unread FROM ttrss_entries
 460                                 WHERE $query_strategy_part");
 461
 462                         $unread = db_fetch_result($result, 0, "unread");
 463
 464                 } else {
 465 //                      print "[viewfeed] feed type not implemented<br>";
 466                         $unread = 0;
 467                 }
 468
 469                 // update unread/total counters and status for active feed in the feedlist
 470                 // kludge, because iframe doesn't seem to support onload()
 471
 472                 print "<script type=\"text/javascript\">
 473                         document.onkeydown = hotkey_handler;
 474
 475                         var p_document = parent.frames['feeds-frame'].document;
 476
 477                         var feedr = p_document.getElementById(\"FEEDR-\" + $feed);
 478                         var feedu = p_document.getElementById(\"FEEDU-\" + $feed);
 479
 480                         if (feedu) {
 481                                 feedu.innerHTML = \"$unread\";
 482                         }
 483
 484                         var feedctr = p_document.getElementById(\"FEEDCTR-\" + $feed);
 485
 486                         if ($unread > 0 && $feed != -1 && !feedr.className.match(\"Unread\")) {
 487                                         feedr.className = feedr.className + \"Unread\";
 488                                         feedctr.className = '';
 489                         } else if ($unread <= 0) {
 490                                         feedr.className = feedr.className.replace(\"Unread\", \"\");
 491                                         feedctr.className = 'invisible';
 492                         }
 493
 494 //                      p_notify(\"\");
 495
 496                 </script>";
 497
 498                 if ($addheader) {
 499                         print "</body></html>";
 500                 }
 501
 502         }
 503
 504         if ($op == "pref-rpc") {
 505
 506                 $subop = $_GET["subop"];
 507
 508                 if ($subop == "unread") {
 509                         $ids = split(",", $_GET["ids"]);
 510                         foreach ($ids as $id) {
 511                                 db_query($link, "UPDATE ttrss_entries SET unread = true WHERE feed_id = '$id'");
 512                         }
 513
 514                         print "Marked selected feeds as read.";
 515                 }
 516
 517                 if ($subop == "read") {
 518                         $ids = split(",", $_GET["ids"]);
 519                         foreach ($ids as $id) {
 520                                 db_query($link, "UPDATE ttrss_entries
 521                                         SET unread = false,last_read = NOW() WHERE feed_id = '$id'");
 522                         }
 523
 524                         print "Marked selected feeds as unread.";
 525
 526                 }
 527
 528         }
 529
 530         if ($op == "pref-feeds") {
 531
 532                 $subop = $_GET["subop"];
 533
 534                 if ($subop == "editSave") {
 535                         $feed_title = db_escape_string($_GET["t"]);
 536                         $feed_link = db_escape_string($_GET["l"]);
 537                         $feed_id = $_GET["id"];
 538
 539                         $result = db_query($link, "UPDATE ttrss_feeds SET
 540                                 title = '$feed_title', feed_url = '$feed_link' WHERE id = '$feed_id'");
 541
 542                 }
 543
 544                 if ($subop == "remove") {
 545
 546                         if (!WEB_DEMO_MODE) {
 547
 548                                 $ids = split(",", $_GET["ids"]);
 549
 550                                 foreach ($ids as $id) {
 551                                         db_query($link, "BEGIN");
 552                                         db_query($link, "DELETE FROM ttrss_entries WHERE feed_id = '$id'");
 553                                         db_query($link, "DELETE FROM ttrss_feeds WHERE id = '$id'");
 554                                         db_query($link, "COMMIT");
 555
 556                                         if (file_exists(ICONS_DIR . "/$id.ico")) {
 557                                                 unlink(ICONS_DIR . "/$id.ico");
 558                                         }
 559                                 }
 560                         }
 561                 }
 562
 563                 if ($subop == "add") {
 564
 565                         if (!WEB_DEMO_MODE) {
 566
 567                                 $feed_link = db_escape_string($_GET["link"]);
 568
 569                                 $result = db_query($link,
 570                                         "INSERT INTO ttrss_feeds (feed_url,title) VALUES ('$feed_link', '')");
 571
 572                                 $result = db_query($link,
 573                                         "SELECT id FROM ttrss_feeds WHERE feed_url = '$feed_link'");
 574
 575                                 $feed_id = db_fetch_result($result, 0, "id");
 576
 577                                 if ($feed_id) {
 578                                         update_rss_feed($link, $feed_link, $feed_id);
 579                                 }
 580                         }
 581                 }
 582
 583                 print "<table class=\"prefAddFeed\"><tr>
 584                         <td><input id=\"fadd_link\"></td>
 585                         <td colspan=\"4\" align=\"right\">
 586                                 <a class=\"button\" href=\"javascript:addFeed()\">Add feed</a></td></tr>
 587                 </table>";
 588
 589                 $result = db_query($link, "SELECT
 590                                 id,title,feed_url,substring(last_updated,1,16) as last_updated
 591                         FROM
 592                                 ttrss_feeds ORDER by title");
 593
 594                 print "<p><table width=\"100%\" class=\"prefFeedList\" id=\"prefFeedList\">";
 595                 print "<tr class=\"title\">
 596                                         <td>&nbsp;</td><td>Select</td><td width=\"40%\">Title</td>
 597                                         <td width=\"40%\">Link</td><td>Last updated</td></tr>";
 598
 599                 $lnum = 0;
 600
 601                 while ($line = db_fetch_assoc($result)) {
 602
 603                         $class = ($lnum % 2) ? "even" : "odd";
 604
 605                         $feed_id = $line["id"];
 606
 607                         $edit_feed_id = $_GET["id"];
 608
 609                         if ($subop == "edit" && $feed_id != $edit_feed_id) {
 610                                 $class .= "Grayed";
 611                         }
 612
 613                         print "<tr class=\"$class\" id=\"FEEDR-$feed_id\">";
 614
 615                         $icon_file = ICONS_DIR . "/$feed_id.ico";
 616
 617                         if (file_exists($icon_file) && filesize($icon_file) > 0) {
 618                                         $feed_icon = "<img width=\"16\" height=\"16\"
 619                                                 src=\"" . ICONS_URL . "/$feed_id.ico\">";
 620                         } else {
 621                                 $feed_icon = "&nbsp;";
 622                         }
 623                         print "<td align='center'>$feed_icon</td>";
 624
 625                         if (!$edit_feed_id || $subop != "edit") {
 626
 627                                 print "<td><input onclick='toggleSelectRow(this);'
 628                                 type=\"checkbox\" id=\"FRCHK-".$line["id"]."\"></td>";
 629
 630                                 print "<td><a href=\"javascript:editFeed($feed_id);\">" .
 631                                         $line["title"] . "</td>";
 632                                 print "<td><a href=\"javascript:editFeed($feed_id);\">" .
 633                                         $line["feed_url"] . "</td>";
 634
 635
 636                         } else if ($feed_id != $edit_feed_id) {
 637
 638                                 print "<td><input disabled=\"true\" type=\"checkbox\"
 639                                         id=\"FRCHK-".$line["id"]."\"></td>";
 640
 641                                 print "<td>".$line["title"]."</td>";
 642                                 print "<td>".$line["feed_url"]."</td>";
 643
 644                         } else {
 645
 646                                 print "<td><input disabled=\"true\" type=\"checkbox\"></td>";
 647
 648                                 print "<td><input id=\"iedit_title\" value=\"".$line["title"]."\"></td>";
 649                                 print "<td><input id=\"iedit_link\" value=\"".$line["feed_url"]."\"></td>";
 650
 651                         }
 652
 653                         if (!$line["last_updated"]) $line["last_updated"] = "Never";
 654
 655                         print "<td>" . $line["last_updated"] . "</td>";
 656
 657                         print "</tr>";
 658
 659                         ++$lnum;
 660                 }
 661
 662                 if ($lnum == 0) {
 663                         print "<tr><td colspan=\"5\" align=\"center\">No feeds defined.</td></tr>";
 664                 }
 665
 666                 print "</table>";
 667
 668                 print "<p>";
 669
 670                 if ($subop == "edit") {
 671                         print "Edit feed:&nbsp;
 672                                 <input type=\"submit\" class=\"button\"
 673                                         onclick=\"javascript:feedEditCancel()\" value=\"Cancel\">
 674                                 <input type=\"submit\" class=\"button\"
 675                                         onclick=\"javascript:feedEditSave()\" value=\"Save\">";
 676                         } else {
 677
 678                         print "
 679                                 Selection:&nbsp;
 680                         <input type=\"submit\" class=\"button\"
 681                                 onclick=\"javascript:editSelectedFeed()\" value=\"Edit\">
 682                         <input type=\"submit\" class=\"button\"
 683                                 onclick=\"javascript:removeSelectedFeeds()\" value=\"Remove\">";
 684
 685                         if (ENABLE_PREFS_CATCHUP_UNCATCHUP) {
 686                                 print "
 687                                 <input type=\"submit\" class=\"button\"
 688                                         onclick=\"javascript:readSelectedFeeds()\" value=\"Mark as read\">
 689                                 <input type=\"submit\" class=\"button\"
 690                                         onclick=\"javascript:unreadSelectedFeeds()\" value=\"Mark as unread\">&nbsp;";
 691                         }
 692                         print "
 693                         All feeds:
 694                                 <input type=\"submit\"
 695                                         class=\"button\" onclick=\"gotoExportOpml()\" value=\"Export OPML\">";
 696
 697                         }
 698
 699         }
 700
 701         if ($op == "pref-filters") {
 702
 703                 $subop = $_GET["subop"];
 704
 705                 if ($subop == "editSave") {
 706
 707                         $regexp = db_escape_string($_GET["r"]);
 708                         $descr = db_escape_string($_GET["d"]);
 709                         $match = db_escape_string($_GET["m"]);
 710                         $filter_id = db_escape_string($_GET["id"]);
 711
 712                         $result = db_query($link, "UPDATE ttrss_filters SET
 713                                 reg_exp = '$regexp',
 714                                 description = '$descr',
 715                                 filter_type = (SELECT id FROM ttrss_filter_types WHERE
 716                                         description = '$match')
 717                                 WHERE id = '$filter_id'");
 718                 }
 719
 720                 if ($subop == "remove") {
 721
 722                         if (!WEB_DEMO_MODE) {
 723
 724                                 $ids = split(",", $_GET["ids"]);
 725
 726                                 foreach ($ids as $id) {
 727                                         db_query($link, "DELETE FROM ttrss_filters WHERE id = '$id'");
 728
 729                                 }
 730                         }
 731                 }
 732
 733                 if ($subop == "add") {
 734
 735                         if (!WEB_DEMO_MODE) {
 736
 737                                 $regexp = db_escape_string($_GET["regexp"]);
 738                                 $match = db_escape_string($_GET["match"]);
 739
 740                                 $result = db_query($link,
 741                                         "INSERT INTO ttrss_filters (reg_exp,filter_type) VALUES
 742                                                 ('$regexp', (SELECT id FROM ttrss_filter_types WHERE
 743                                                         description = '$match'))");
 744                         }
 745                 }
 746
 747                 $result = db_query($link, "SELECT description
 748                         FROM ttrss_filter_types ORDER BY description");
 749
 750                 $filter_types = array();
 751
 752                 while ($line = db_fetch_assoc($result)) {
 753                         array_push($filter_types, $line["description"]);
 754                 }
 755
 756                 print "<table class=\"prefAddFeed\"><tr>
 757                         <td><input id=\"fadd_regexp\"></td>
 758                         <td>";
 759                         print_select("fadd_match", "Title", $filter_types);
 760
 761                 print"</td><td colspan=\"4\" align=\"right\">
 762                                 <a class=\"button\" href=\"javascript:addFilter()\">Add filter</a></td></tr>
 763                 </table>";
 764
 765                 $result = db_query($link, "SELECT
 766                                 id,reg_exp,description,
 767                                 (SELECT name FROM ttrss_filter_types WHERE
 768                                         id = filter_type) as filter_type_name,
 769                                 (SELECT description FROM ttrss_filter_types
 770                                         WHERE id = filter_type) as filter_type_descr
 771                         FROM
 772                                 ttrss_filters ORDER by reg_exp");
 773
 774                 print "<p><table width=\"100%\" class=\"prefFilterList\" id=\"prefFilterList\">";
 775
 776                 print "<tr class=\"title\">
 777                                         <td width=\"5%\">Select</td><td width=\"40%\">Filter expression</td>
 778                                         <td width=\"40%\">Description</td><td width=\"10%\">Match</td></tr>";
 779
 780                 $lnum = 0;
 781
 782                 while ($line = db_fetch_assoc($result)) {
 783
 784                         $class = ($lnum % 2) ? "even" : "odd";
 785
 786                         $filter_id = $line["id"];
 787                         $edit_filter_id = $_GET["id"];
 788
 789                         if ($subop == "edit" && $filter_id != $edit_filter_id) {
 790                                 $class .= "Grayed";
 791                         }
 792
 793                         print "<tr class=\"$class\" id=\"FILRR-$filter_id\">";
 794
 795                         $line["regexp"] = htmlspecialchars($line["reg_exp"]);
 796                         $line["description"] = htmlspecialchars($line["description"]);
 797
 798                         if (!$edit_filter_id || $subop != "edit") {
 799
 800                                 if (!$line["description"]) $line["description"] = "[No description]";
 801
 802                                 print "<td><input onclick='toggleSelectRow(this);'
 803                                 type=\"checkbox\" id=\"FICHK-".$line["id"]."\"></td>";
 804
 805                                 print "<td><a href=\"javascript:editFilter($filter_id);\">" .
 806                                         $line["reg_exp"] . "</td>";
 807
 808                                 print "<td><a href=\"javascript:editFilter($filter_id);\">" .
 809                                         $line["description"] . "</td>";
 810
 811                                 print "<td>".$line["filter_type_descr"]."</td>";
 812
 813                         } else if ($filter_id != $edit_filter_id) {
 814
 815                                 if (!$line["description"]) $line["description"] = "[No description]";
 816
 817                                 print "<td><input disabled=\"true\" type=\"checkbox\"
 818                                         id=\"FICHK-".$line["id"]."\"></td>";
 819
 820                                 print "<td>".$line["reg_exp"]."</td>";
 821                                 print "<td>".$line["description"]."</td>";
 822                                 print "<td>".$line["filter_type_descr"]."</td>";
 823
 824                         } else {
 825
 826                                 print "<td><input disabled=\"true\" type=\"checkbox\"></td>";
 827
 828                                 print "<td><input id=\"iedit_regexp\" value=\"".$line["reg_exp"].
 829                                         "\"></td>";
 830
 831                                 print "<td><input id=\"iedit_descr\" value=\"".$line["description"].
 832                                         "\"></td>";
 833
 834                                 print "<td>";
 835                                 print_select("iedit_match", $line["filter_type_descr"], $filter_types);
 836                                 print "</td>";
 837
 838                         }
 839
 840
 841                         print "</tr>";
 842
 843                         ++$lnum;
 844                 }
 845
 846                 if ($lnum == 0) {
 847                         print "<tr><td colspan=\"4\" align=\"center\">No filters defined.</td></tr>";
 848                 }
 849
 850                 print "</table>";
 851
 852                 print "<p>";
 853
 854                 if ($subop == "edit") {
 855                         print "Edit feed:
 856                                 <input type=\"submit\" class=\"button\"
 857                                         onclick=\"javascript:filterEditCancel()\" value=\"Cancel\">
 858                                 <input type=\"submit\" class=\"button\"
 859                                         onclick=\"javascript:filterEditSave()\" value=\"Save\">";
 860
 861                 } else {
 862
 863                         print "
 864                                 Selection:
 865                         <input type=\"submit\" class=\"button\"
 866                                 onclick=\"javascript:editSelectedFilter()\" value=\"Edit\">
 867                         <input type=\"submit\" class=\"button\"
 868                                 onclick=\"javascript:removeSelectedFilters()\" value=\"Remove\">";
 869                 }
 870         }
 871
 872         if ($op == "pref-labels") {
 873
 874                 $subop = $_GET["subop"];
 875
 876                 if ($subop == "editSave") {
 877
 878                         $sql_exp = $_GET["s"];
 879                         $descr = $_GET["d"];
 880                         $label_id = db_escape_string($_GET["id"]);
 881
 882 //                      print "$sql_exp : $descr : $label_id";
 883
 884                         $result = db_query($link, "UPDATE ttrss_labels SET
 885                                 sql_exp = '$sql_exp',
 886                                 description = '$descr'
 887                                 WHERE id = '$label_id'");
 888                 }
 889
 890                 if ($subop == "remove") {
 891
 892                         if (!WEB_DEMO_MODE) {
 893
 894                                 $ids = split(",", $_GET["ids"]);
 895
 896                                 foreach ($ids as $id) {
 897                                         db_query($link, "DELETE FROM ttrss_labels WHERE id = '$id'");
 898
 899                                 }
 900                         }
 901                 }
 902
 903                 if ($subop == "add") {
 904
 905                         if (!WEB_DEMO_MODE) {
 906
 907                                 $exp = $_GET["exp"];
 908
 909                                 $result = db_query($link,
 910                                         "INSERT INTO ttrss_labels (sql_exp,description)
 911                                                 VALUES ('$exp', '$exp')");
 912                         }
 913                 }
 914
 915                 print "<table class=\"prefAddFeed\"><tr>
 916                         <td><input id=\"ladd_expr\"></td>";
 917
 918                 print"<td colspan=\"4\" align=\"right\">
 919                                 <a class=\"button\" href=\"javascript:addLabel()\">Add label</a></td></tr>
 920                 </table>";
 921
 922                 $result = db_query($link, "SELECT
 923                                 id,sql_exp,description
 924                         FROM
 925                                 ttrss_labels ORDER by description");
 926
 927                 print "<p><table width=\"100%\" class=\"prefLabelList\" id=\"prefLabelList\">";
 928
 929                 print "<tr class=\"title\">
 930                                         <td width=\"5%\">Select</td><td width=\"40%\">SQL expression</td>
 931                                         <td width=\"40%\">Caption</td></tr>";
 932
 933                 $lnum = 0;
 934
 935                 while ($line = db_fetch_assoc($result)) {
 936
 937                         $class = ($lnum % 2) ? "even" : "odd";
 938
 939                         $label_id = $line["id"];
 940                         $edit_label_id = $_GET["id"];
 941
 942                         if ($subop == "edit" && $label_id != $edit_label_id) {
 943                                 $class .= "Grayed";
 944                         }
 945
 946                         print "<tr class=\"$class\" id=\"LILRR-$label_id\">";
 947
 948                         $line["sql_exp"] = htmlspecialchars($line["sql_exp"]);
 949                         $line["description"] = htmlspecialchars($line["description"]);
 950
 951                         if (!$edit_label_id || $subop != "edit") {
 952
 953                                 if (!$line["description"]) $line["description"] = "[No caption]";
 954
 955                                 print "<td><input onclick='toggleSelectRow(this);'
 956                                 type=\"checkbox\" id=\"LICHK-".$line["id"]."\"></td>";
 957
 958                                 print "<td><a href=\"javascript:editLabel($label_id);\">" .
 959                                         $line["sql_exp"] . "</td>";
 960
 961                                 print "<td><a href=\"javascript:editLabel($label_id);\">" .
 962                                         $line["description"] . "</td>";
 963
 964                         } else if ($label_id != $edit_label_id) {
 965
 966                                 if (!$line["description"]) $line["description"] = "[No description]";
 967
 968                                 print "<td><input disabled=\"true\" type=\"checkbox\"
 969                                         id=\"LICHK-".$line["id"]."\"></td>";
 970
 971                                 print "<td>".$line["sql_exp"]."</td>";
 972                                 print "<td>".$line["description"]."</td>";
 973
 974                         } else {
 975
 976                                 print "<td><input disabled=\"true\" type=\"checkbox\"></td>";
 977
 978                                 print "<td><input id=\"iedit_expr\" value=\"".$line["sql_exp"].
 979                                         "\"></td>";
 980
 981                                 print "<td><input id=\"iedit_descr\" value=\"".$line["description"].
 982                                         "\"></td>";
 983
 984                         }
 985
 986
 987                         print "</tr>";
 988
 989                         ++$lnum;
 990                 }
 991
 992                 if ($lnum == 0) {
 993                         print "<tr><td colspan=\"4\" align=\"center\">No labels defined.</td></tr>";
 994                 }
 995
 996                 print "</table>";
 997
 998                 print "<p>";
 999
1000                 if ($subop == "edit") {
1001                         print "Edit label:
1002                                 <input type=\"submit\" class=\"button\"
1003                                         onclick=\"javascript:labelEditCancel()\" value=\"Cancel\">
1004                                 <input type=\"submit\" class=\"button\"
1005                                         onclick=\"javascript:labelEditSave()\" value=\"Save\">";
1006
1007                 } else {
1008
1009                         print "
1010                                 Selection:
1011                         <input type=\"submit\" class=\"button\"
1012                                 onclick=\"javascript:editSelectedLabel()\" value=\"Edit\">
1013                         <input type=\"submit\" class=\"button\"
1014                                 onclick=\"javascript:removeSelectedLabels()\" value=\"Remove\">";
1015                 }
1016         }
1017
1018         if ($op == "error") {
1019                 print "<div width=\"100%\" align='center'>";
1020                 $msg = $_GET["msg"];
1021                 print $msg;
1022                 print "</div>";
1023         }
1024
1025         db_close($link);
1026 ?>