2 define(SCHEMA_VERSION
, 2);
6 if ($op == "rpc" ||
$op == "updateAllFeeds") {
7 header("Content-Type: application/xml");
10 require_once "config.php";
11 require_once "db.php";
12 require_once "db-prefs.php";
13 require_once "functions.php";
14 require_once "magpierss/rss_fetch.inc";
16 $script_started = getmicrotime();
18 $link = db_connect(DB_HOST
, DB_USER
, DB_PASS
, DB_NAME
);
21 if (DB_TYPE
== "mysql") {
24 // PG seems to display its own errors just fine by default.
28 if (DB_TYPE
== "pgsql") {
29 pg_query("set client_encoding = 'utf-8'");
33 $result = db_query($link, "SELECT schema_version FROM ttrss_version");
35 $schema_version = db_fetch_result($result, 0, "schema_version");
37 if ($schema_version != SCHEMA_VERSION) {
38 print "Error: database schema is invalid
39 (got version $schema_version; expected ".SCHEMA_VERSION.")";
44 $fetch = $_GET["fetch"];
46 /* FIXME this needs reworking */
48 function getGlobalCounters($link) {
49 $result = db_query($link, "SELECT count(id) as c_id FROM ttrss_entries
50 WHERE unread = true");
51 $c_id = db_fetch_result($result, 0, "c_id");
52 print "<counter id='global-unread' counter='$c_id'/>";
55 function getTagCounters($link) {
56 $result = db_query($link, "SELECT tag_name,count(ttrss_entries.id) AS count
57 FROM ttrss_tags,ttrss_entries WHERE
58 post_id = ttrss_entries.id AND unread = true GROUP BY tag_name
60 select tag_name,0 as count FROM ttrss_tags");
64 while ($line = db_fetch_assoc($result)) {
65 $tags[$line["tag_name"]] +
= $line["count"];
68 foreach (array_keys($tags) as $tag) {
69 $unread = $tags[$tag];
71 $tag = htmlspecialchars($tag);
72 print "<tag id=\"$tag\" counter=\"$unread\"/>";
76 function getLabelCounters($link) {
78 $result = db_query($link, "SELECT count(id) as count FROM ttrss_entries
79 WHERE marked = true AND unread = true");
81 $count = db_fetch_result($result, 0, "count");
83 print "<label id=\"-1\" counter=\"$count\"/>";
85 $result = db_query($link, "SELECT id,sql_exp,description FROM
86 ttrss_labels ORDER by description");
88 while ($line = db_fetch_assoc($result)) {
90 $id = -$line["id"] - 11;
94 $tmp_result = db_query($link, "SELECT count(id) as count FROM ttrss_entries
95 WHERE (" . $line["sql_exp"] . ") AND unread = true");
97 $count = db_fetch_result($tmp_result, 0, "count");
99 print "<label id=\"$id\" counter=\"$count\"/>";
101 error_reporting (E_ERROR | E_WARNING | E_PARSE
);
106 function getFeedCounter($link, $id) {
108 $result = db_query($link, "SELECT
109 count(id) as count FROM ttrss_entries
110 WHERE feed_id = '$id' AND unread = true");
112 $count = db_fetch_result($result, 0, "count");
114 print "<feed id=\"$id\" counter=\"$count\"/>";
117 function getFeedCounters($link) {
119 $result = db_query($link, "SELECT id,
120 (SELECT count(id) FROM ttrss_entries WHERE feed_id = ttrss_feeds.id
121 AND unread = true) as count
124 while ($line = db_fetch_assoc($result)) {
127 $count = $line["count"];
129 print "<feed id=\"$id\" counter=\"$count\"/>";
133 function outputFeedList($link, $tags = false) {
136 <title>Tiny Tiny RSS : Feedlist</title>
137 <link rel=\"stylesheet\" href=\"tt-rss.css\" type=\"text/css\">";
139 if (get_pref($link, 'USE_COMPACT_STYLESHEET')) {
140 print "<link rel=\"stylesheet\" type=\"text/css\"
141 href=\"tt-rss_compact.css\"/>";
143 print "<link title=\"Compact Stylesheet\" rel=\"alternate stylesheet\"
144 type=\"text/css\" href=\"tt-rss_compact.css\"/>";
147 print "<script type=\"text/javascript\" src=\"functions.js\"></script>
148 <script type=\"text/javascript\" src=\"feedlist.js\"></script>
149 <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">
150 </head><body onload=\"init()\">";
152 print "<ul class=\"feedList\" id=\"feedList\">";
158 $result = db_query($link, "SELECT count(id) as num_starred
159 FROM ttrss_entries WHERE marked = true AND unread = true");
160 $num_starred = db_fetch_result($result, 0, "num_starred");
164 if ($num_starred > 0) $class .= "Unread";
166 printFeedEntry(-1, $class, "Starred articles", $num_starred,
167 "images/mark_set.png", $link);
169 if (get_pref($link, 'ENABLE_LABELS')) {
171 $result = db_query($link, "SELECT id,sql_exp,description FROM
172 ttrss_labels ORDER by description");
174 if (db_num_rows($result) > 0) {
175 print "<li><hr></li>";
178 while ($line = db_fetch_assoc($result)) {
182 $tmp_result = db_query($link, "SELECT count(id) as count FROM ttrss_entries
183 WHERE (" . $line["sql_exp"] . ") AND unread = true");
185 $count = db_fetch_result($tmp_result, 0, "count");
193 error_reporting (E_ERROR | E_WARNING | E_PARSE
);
195 printFeedEntry(-$line["id"]-11,
196 $class, $line["description"], $count, "images/label.png", $link);
201 print "<li><hr></li>";
203 $result = db_query($link, "SELECT *,
204 (SELECT count(id) FROM ttrss_entries
205 WHERE feed_id = ttrss_feeds.id) AS total,
206 (SELECT count(id) FROM ttrss_entries
207 WHERE feed_id = ttrss_feeds.id AND unread = true) as unread
208 FROM ttrss_feeds ORDER BY title");
210 $actid = $_GET["actid"];
218 while ($line = db_fetch_assoc($result)) {
220 $feed = $line["title"];
221 $feed_id = $line["id"];
223 $subop = $_GET["subop"];
225 $total = $line["total"];
226 $unread = $line["unread"];
228 // $class = ($lnum % 2) ? "even" : "odd";
232 if ($unread > 0) $class .= "Unread";
234 if ($actid == $feed_id) {
235 $class .= "Selected";
238 $total_unread +
= $unread;
240 printFeedEntry($feed_id, $class, $feed, $unread, "icons/$feed_id.ico", $link);
248 $result = db_query($link, "SELECT tag_name,count(ttrss_entries.id) AS count
249 FROM ttrss_tags,ttrss_entries WHERE
250 post_id = ttrss_entries.id AND unread = true GROUP BY tag_name
252 select tag_name,0 as count FROM ttrss_tags");
256 while ($line = db_fetch_assoc($result)) {
257 $tags[$line["tag_name"]] +
= $line["count"];
260 foreach (array_keys($tags) as $tag) {
262 $unread = $tags[$tag];
270 printFeedEntry($tag, $class, $tag, $unread, "images/tag.png", $link);
276 if (db_num_rows($result) == 0) {
277 print "<li>No tags to display.</li>";
282 print "<div class=\"invisible\" id=\"FEEDTU\">$total_unread</div>";
289 $subop = $_GET["subop"];
291 if ($subop == "getLabelCounters") {
294 getLabelCounters($link);
296 getFeedCounter($link, $aid);
298 print "</rpc-reply>";
301 if ($subop == "getFeedCounters") {
303 getFeedCounters($link);
304 print "</rpc-reply>";
307 if ($subop == "getAllCounters") {
309 getLabelCounters($link);
310 getFeedCounters($link);
311 getTagCounters($link);
312 getGlobalCounters($link);
313 print "</rpc-reply>";
316 if ($subop == "mark") {
317 $mark = $_GET["mark"];
318 $id = db_escape_string($_GET["id"]);
326 $result = db_query($link, "UPDATE ttrss_entries SET marked = $mark
330 if ($subop == "updateFeed") {
331 $feed_id = db_escape_string($_GET["feed"]);
333 $result = db_query($link,
334 "SELECT feed_url FROM ttrss_feeds WHERE id = '$feed_id'");
336 if (db_num_rows($result) > 0) {
337 $feed_url = db_fetch_result($result, 0, "feed_url");
338 // update_rss_feed($link, $feed_url, $feed_id);
341 print "DONE-$feed_id";
346 if ($subop == "forceUpdateAllFeeds" ||
$subop == "updateAllFeeds") {
348 update_all_feeds($link, true);
350 $omode = $_GET["omode"];
352 if (!$omode) $omode = "tfl";
355 if (strchr($omode, "l")) getLabelCounters($link);
356 if (strchr($omode, "f")) getFeedCounters($link);
357 if (strchr($omode, "t")) getTagCounters($link);
358 getGlobalCounters($link);
359 print "</rpc-reply>";
362 if ($subop == "catchupPage") {
364 $ids = split(",", $_GET["ids"]);
366 foreach ($ids as $id) {
368 db_query($link, "UPDATE ttrss_entries SET unread=false,last_read = NOW()
373 print "Marked active page as read.";
376 if ($subop == "sanityCheck") {
380 $result = db_query($link, "SELECT schema_version FROM ttrss_version");
382 $schema_version = db_fetch_result($result, 0, "schema_version");
384 if ($schema_version != SCHEMA_VERSION
) {
388 print "<error code='$error_code'/>";
392 if ($op == "feeds") {
394 $tags = $_GET["tags"];
396 $subop = $_GET["subop"];
398 if ($subop == "catchupAll") {
399 db_query($link, "UPDATE ttrss_entries SET last_read = NOW(),unread = false");
402 outputFeedList($link, $tags);
409 $feed_id = $_GET["feed"];
411 $result = db_query($link, "UPDATE ttrss_entries SET unread = false,last_read = NOW() WHERE id = '$id'");
413 $addheader = $_GET["addheader"];
415 $result = db_query($link, "SELECT title,link,content,feed_id,comments,
416 (SELECT icon_url FROM ttrss_feeds WHERE id = feed_id) as icon_url
422 <title>Tiny Tiny RSS : Article $id</title>
423 <link rel=\"stylesheet\" href=\"tt-rss.css\" type=\"text/css\">
424 <script type=\"text/javascript\" src=\"functions.js\"></script>
425 <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">
431 $line = db_fetch_assoc($result);
433 if ($line["icon_url"]) {
434 $feed_icon = "<img class=\"feedIcon\" src=\"" . $line["icon_url"] . "\">";
436 $feed_icon = " ";
439 if ($line["comments"] && $line["link"] != $line["comments"]) {
440 $entry_comments = "(<a href=\"".$line["comments"]."\">Comments</a>)";
442 $entry_comments = "";
445 print "<div class=\"postReply\">";
447 print "<div class=\"postHeader\"><table>";
449 print "<tr><td><b>Title:</b></td>
450 <td width='100%'>" . $line["title"] . "</td></tr>";
452 print "<tr><td><b>Link:</b></td>
454 <a href=\"" . $line["link"] . "\">".$line["link"]."</a>
455 $entry_comments</td></tr>";
457 print "</table></div>";
459 print "<div class=\"postIcon\">" . $feed_icon . "</div>";
460 print "<div class=\"postContent\">" . $line["content"] . "</div>";
464 print "<script type=\"text/javascript\">
465 update_label_counters('$feed_id');
470 print "</body></html>";
474 if ($op == "viewfeed") {
476 $feed = $_GET["feed"];
477 $skip = $_GET["skip"];
478 $subop = $_GET["subop"];
479 $view_mode = $_GET["view"];
480 $addheader = $_GET["addheader"];
481 $limit = $_GET["limit"];
484 print "Error: no feed to display.";
488 if (!$skip) $skip = 0;
490 if ($subop == "undefined") $subop = "";
494 <title>Tiny Tiny RSS : Feed $feed</title>
495 <link rel=\"stylesheet\" href=\"tt-rss.css\" type=\"text/css\">";
497 if (get_pref($link, 'USE_COMPACT_STYLESHEET')) {
498 print "<link rel=\"stylesheet\"
499 type=\"text/css\" href=\"tt-rss_compact.css\"/>";
502 print "<link title=\"Compact Stylesheet\" rel=\"alternate stylesheet\"
503 type=\"text/css\" href=\"tt-rss_compact.css\"/>";
505 print "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">
506 <script type=\"text/javascript\" src=\"functions.js\"></script>
507 <script type=\"text/javascript\" src=\"viewfeed.js\"></script>
508 </head><body onload='init()'>";
511 if ($subop == "ForceUpdate" && sprintf("%d", $feed) > 0) {
513 $tmp_result = db_query($link, "SELECT feed_url FROM ttrss_feeds
514 WHERE id = '$feed'");
516 $feed_url = db_fetch_result($tmp_result, 0, "feed_url");
518 update_rss_feed($link, $feed_url, $feed);
522 if ($subop == "MarkAllRead") {
524 if (sprintf("%d", $feed) != 0) {
527 db_query($link, "UPDATE ttrss_entries
528 SET unread = false,last_read = NOW()
529 WHERE feed_id = '$feed'");
531 } else if ($feed < 0 && $feed > -10) { // special, like starred
534 db_query($link, "UPDATE ttrss_entries
535 SET unread = false,last_read = NOW()
536 WHERE marked = true");
539 } else if ($feed < -10) { // label
541 $label_id = -$feed - 11;
543 $tmp_result = db_query($link, "SELECT sql_exp FROM ttrss_labels
544 WHERE id = '$label_id'");
547 $sql_exp = db_fetch_result($tmp_result, 0, "sql_exp");
549 db_query($link, "UPDATE ttrss_entries
550 SET unread = false,last_read = NOW()
555 // FIXME, implement catchup for tags
560 print "<table class=\"headlinesList\" id=\"headlinesList\" width=\"100%\">";
562 $search = $_GET["search"];
564 $search_mode = $_GET["smode"];
567 $search_query_part = "(upper(title) LIKE upper('%$search%')
568 OR content LIKE '%$search%') AND";
570 $search_query_part = "";
573 $view_query_part = "";
575 if ($view_mode == "Starred") {
576 $view_query_part = " marked = true AND ";
579 if ($view_mode == "Unread") {
580 $view_query_part = " unread = true AND ";
583 if ($view_mode == "Unread or Starred") {
584 $view_query_part = " (unread = true OR marked = true) AND ";
587 if ($view_mode == "Unread or Updated") {
588 $view_query_part = " (unread = true OR last_read is NULL) AND ";
591 /* $result = db_query($link, "SELECT count(id) AS total_entries
592 FROM ttrss_entries WHERE
596 $total_entries = db_fetch_result($result, 0, "total_entries"); */
598 /* $result = db_query("SELECT count(id) AS unread_entries
599 FROM ttrss_entries WHERE
604 $unread_entries = db_fetch_result($result, 0, "unread_entries"); */
606 if ($limit && $limit != "All") {
607 $limit_query_part = "LIMIT " . $limit;
610 $vfeed_query_part = "";
612 // override query strategy and enable feed display when searching globally
613 if ($search_mode == "All feeds") {
614 $query_strategy_part = "id > 0";
615 $vfeed_query_part = "(SELECT title FROM ttrss_feeds WHERE
616 id = feed_id) as feed_title,";
617 } else if (sprintf("%d", $feed) == 0) {
618 $query_strategy_part = "ttrss_entries.id > 0";
619 $vfeed_query_part = "(SELECT title FROM ttrss_feeds WHERE
620 id = feed_id) as feed_title,";
621 } else if ($feed >= 0) {
622 $query_strategy_part = "feed_id = '$feed'";
623 } else if ($feed == -1) { // starred virtual feed
624 $query_strategy_part = "marked = true";
625 $vfeed_query_part = "(SELECT title FROM ttrss_feeds WHERE
626 id = feed_id) as feed_title,";
627 } else if ($feed <= -10) { // labels
628 $label_id = -$feed - 11;
630 $tmp_result = db_query($link, "SELECT sql_exp FROM ttrss_labels
631 WHERE id = '$label_id'");
633 $query_strategy_part = db_fetch_result($tmp_result, 0, "sql_exp");
635 $vfeed_query_part = "(SELECT title FROM ttrss_feeds WHERE
636 id = feed_id) as feed_title,";
638 $query_strategy_part = "id > 0"; // dumb
642 $order_by = "updated DESC";
644 // if ($feed < -10) {
645 // $order_by = "feed_id,updated DESC";
648 if ($feed < -10) error_reporting (0);
650 if (sprintf("%d", $feed) != 0) {
652 $result = db_query($link, "SELECT
653 id,title,updated,unread,feed_id,marked,link,last_read,
654 SUBSTRING(last_read,1,19) as last_read_noms,
656 SUBSTRING(updated,1,19) as updated_noms
662 $query_strategy_part ORDER BY $order_by
668 $result = db_query($link, "SELECT
669 ttrss_entries.id as id,title,updated,unread,feed_id,
670 marked,link,last_read,
671 SUBSTRING(last_read,1,19) as last_read_noms,
673 SUBSTRING(updated,1,19) as updated_noms
675 ttrss_entries,ttrss_tags
677 post_id = ttrss_entries.id AND tag_name = '$feed' AND
680 $query_strategy_part ORDER BY $order_by
685 print "<tr><td colspan='4' align='center'>
686 Could not display feed (query failed). Please check match syntax or local configuration.</td></tr>";
692 error_reporting (E_ERROR | E_WARNING | E_PARSE
);
696 while ($line = db_fetch_assoc($result)) {
698 $class = ($lnum %
2) ?
"even" : "odd";
701 $feed_id = $line["feed_id"];
703 // printf("L %d (%s) > U %d (%s) = %d<br>",
704 // strtotime($line["last_read_noms"]), $line["last_read_noms"],
705 // strtotime($line["updated"]), $line["updated"],
706 // strtotime($line["last_read"]) >= strtotime($line["updated"]));
708 /* if ($line["last_read"] != "" && $line["updated"] != "" &&
709 strtotime($line["last_read_noms"]) < strtotime($line["updated_noms"])) {
711 $update_pic = "<img id='FUPDPIC-$id' src=\"images/updated.png\"
716 $update_pic = "<img id='FUPDPIC-$id' src=\"images/blank_icon.gif\"
721 if ($line["last_read"] == "" &&
722 ($line["unread"] != "t" && $line["unread"] != "1")) {
724 $update_pic = "<img id='FUPDPIC-$id' src=\"images/updated.png\"
727 $update_pic = "<img id='FUPDPIC-$id' src=\"images/blank_icon.gif\"
731 if ($line["unread"] == "t" ||
$line["unread"] == "1") {
736 if ($line["marked"] == "t" ||
$line["marked"] == "1") {
737 $marked_pic = "<img id=\"FMARKPIC-$id\" src=\"images/mark_set.png\"
738 alt=\"Reset mark\" onclick='javascript:toggleMark($id, false)'>";
740 $marked_pic = "<img id=\"FMARKPIC-$id\" src=\"images/mark_unset.png\"
741 alt=\"Set mark\" onclick='javascript:toggleMark($id, true)'>";
744 $content_link = "<a id=\"FTITLE-$id\" href=\"javascript:view($id,$feed_id);\">" .
745 $line["title"] . "</a>";
747 print "<tr class='$class' id='RROW-$id'>";
748 // onclick=\"javascript:view($id,$feed_id)\">
750 print "<td valign='center' align='center'>$update_pic</td>";
751 print "<td valign='center' align='center'>$marked_pic</td>";
753 print "<td width='25%'>
754 <a href=\"javascript:view($id,$feed_id);\">".$line["updated"]."</a></td>";
756 if ($line["feed_title"]) {
757 print "<td width='50%'>$content_link</td>";
758 print "<td width='20%'>
759 <a href='javascript:viewfeed($feed_id)'>".$line["feed_title"]."</a></td>";
761 print "<td width='70%'>$content_link</td>";
770 print "<tr><td align='center'>No articles found.</td></tr>";
775 print "<script type=\"text/javascript\">
776 document.onkeydown = hotkey_handler;
777 update_label_counters('$feed');
781 print "</body></html>";
786 if ($op == "pref-rpc") {
788 $subop = $_GET["subop"];
790 if ($subop == "unread") {
791 $ids = split(",", $_GET["ids"]);
792 foreach ($ids as $id) {
793 db_query($link, "UPDATE ttrss_entries SET unread = true WHERE feed_id = '$id'");
796 print "Marked selected feeds as read.";
799 if ($subop == "read") {
800 $ids = split(",", $_GET["ids"]);
801 foreach ($ids as $id) {
802 db_query($link, "UPDATE ttrss_entries
803 SET unread = false,last_read = NOW() WHERE feed_id = '$id'");
806 print "Marked selected feeds as unread.";
812 if ($op == "pref-feeds") {
814 $subop = $_GET["subop"];
816 if ($subop == "editSave") {
817 $feed_title = db_escape_string($_GET["t"]);
818 $feed_link = db_escape_string($_GET["l"]);
819 $upd_intl = db_escape_string($_GET["ui"]);
820 $purge_intl = db_escape_string($_GET["pi"]);
821 $feed_id = $_GET["id"];
823 if (strtoupper($upd_intl) == "DEFAULT")
826 if (strtoupper($purge_intl) == "DEFAULT")
829 if (strtoupper($purge_intl) == "DISABLED")
832 $result = db_query($link, "UPDATE ttrss_feeds SET
833 title = '$feed_title', feed_url = '$feed_link',
834 update_interval = '$upd_intl',
835 purge_interval = '$purge_intl'
836 WHERE id = '$feed_id'");
840 if ($subop == "remove") {
842 if (!WEB_DEMO_MODE
) {
844 $ids = split(",", $_GET["ids"]);
846 foreach ($ids as $id) {
847 db_query($link, "DELETE FROM ttrss_feeds WHERE id = '$id'");
849 $icons_dir = get_pref($link, 'ICONS_DIR');
851 if (file_exists($icons_dir . "/$id.ico")) {
852 unlink($icons_dir . "/$id.ico");
858 if ($subop == "add") {
860 if (!WEB_DEMO_MODE
) {
862 $feed_link = db_escape_string($_GET["link"]);
864 $result = db_query($link,
865 "INSERT INTO ttrss_feeds (feed_url,title) VALUES ('$feed_link', '')");
867 $result = db_query($link,
868 "SELECT id FROM ttrss_feeds WHERE feed_url = '$feed_link'");
870 $feed_id = db_fetch_result($result, 0, "id");
873 update_rss_feed($link, $feed_link, $feed_id);
878 $result = db_query($link, "SELECT id,title,feed_url,last_error
879 FROM ttrss_feeds WHERE last_error != ''");
881 if (db_num_rows($result) > 0) {
883 print "<div class=\"warning\">";
885 print "<b>Feeds with update errors:</b>";
887 print "<ul class=\"nomarks\">";
889 while ($line = db_fetch_assoc($result)) {
890 print "<li>" . $line["title"] . " (" . $line["feed_url"] . "): " .
899 print "<table class=\"prefAddFeed\"><tr>
900 <td><input id=\"fadd_link\"></td>
901 <td colspan=\"4\" align=\"right\">
902 <a class=\"button\" href=\"javascript:addFeed()\">Add feed</a></td></tr>
905 $result = db_query($link, "SELECT
906 id,title,feed_url,substring(last_updated,1,16) as last_updated,
907 update_interval,purge_interval
909 ttrss_feeds ORDER by title");
911 print "<p><table width=\"100%\" class=\"prefFeedList\" id=\"prefFeedList\">";
912 print "<tr class=\"title\">
913 <td> </td><td>Select</td><td width=\"30%\">Title</td>
914 <td width=\"30%\">Link</td>
915 <td width=\"10%\">Update Interval</td>
916 <td width=\"10%\">Purge Days</td>
917 <td>Last updated</td></tr>";
921 while ($line = db_fetch_assoc($result)) {
923 $class = ($lnum %
2) ?
"even" : "odd";
925 $feed_id = $line["id"];
927 $edit_feed_id = $_GET["id"];
929 if ($subop == "edit" && $feed_id != $edit_feed_id) {
933 print "<tr class=\"$class\" id=\"FEEDR-$feed_id\">";
935 $icon_file = get_pref($link, 'ICONS_DIR') . "/$feed_id.ico";
937 if (file_exists($icon_file) && filesize($icon_file) > 0) {
938 $feed_icon = "<img width=\"16\" height=\"16\"
939 src=\"" . get_pref($link, 'ICONS_URL') . "/$feed_id.ico\">";
941 $feed_icon = " ";
943 print "<td align='center'>$feed_icon</td>";
945 $edit_title = htmlspecialchars(db_unescape_string($line["title"]));
946 $edit_link = htmlspecialchars(db_unescape_string($line["feed_url"]));
948 if (!$edit_feed_id ||
$subop != "edit") {
950 print "<td><input onclick='toggleSelectRow(this);'
951 type=\"checkbox\" id=\"FRCHK-".$line["id"]."\"></td>";
953 print "<td><a href=\"javascript:editFeed($feed_id);\">" .
954 $edit_title . "</a></td>";
955 print "<td><a href=\"javascript:editFeed($feed_id);\">" .
956 $edit_link . "</a></td>";
958 if ($line["update_interval"] == "0")
959 $line["update_interval"] = "Default";
961 print "<td><a href=\"javascript:editFeed($feed_id);\">" .
962 $line["update_interval"] . "</a></td>";
964 if ($line["purge_interval"] == "0")
965 $line["purge_interval"] = "Default";
967 if ($line["purge_interval"] < 0)
968 $line["purge_interval"] = "Disabled";
970 print "<td><a href=\"javascript:editFeed($feed_id);\">" .
971 $line["purge_interval"] . "</a></td>";
973 } else if ($feed_id != $edit_feed_id) {
975 print "<td><input disabled=\"true\" type=\"checkbox\"
976 id=\"FRCHK-".$line["id"]."\"></td>";
978 print "<td>$edit_title</td>";
979 print "<td>$edit_link</td>";
981 if ($line["update_interval"] == "0")
982 $line["update_interval"] = "Default";
984 print "<td>" . $line["update_interval"] . "</td>";
986 if ($line["purge_interval"] == "0")
987 $line["purge_interval"] = "Default";
989 if ($line["purge_interval"] < 0)
990 $line["purge_interval"] = "Disabled";
992 print "<td>" . $line["purge_interval"] . "</td>";
996 print "<td><input disabled=\"true\" type=\"checkbox\"></td>";
998 print "<td><input id=\"iedit_title\" value=\"$edit_title\"></td>";
999 print "<td><input id=\"iedit_link\" value=\"$edit_link\"></td>";
1000 print "<td><input id=\"iedit_updintl\" value=\"".$line["update_interval"]."\"></td>";
1001 print "<td><input id=\"iedit_purgintl\" value=\"".$line["purge_interval"]."\"></td>";
1005 if (!$line["last_updated"]) $line["last_updated"] = "Never";
1007 print "<td>" . $line["last_updated"] . "</td>";
1015 print "<tr><td colspan=\"5\" align=\"center\">No feeds defined.</td></tr>";
1022 if ($subop == "edit") {
1023 print "Edit feed:
1024 <input type=\"submit\" class=\"button\"
1025 onclick=\"javascript:feedEditCancel()\" value=\"Cancel\">
1026 <input type=\"submit\" class=\"button\"
1027 onclick=\"javascript:feedEditSave()\" value=\"Save\">";
1032 <input type=\"submit\" class=\"button\"
1033 onclick=\"javascript:editSelectedFeed()\" value=\"Edit\">
1034 <input type=\"submit\" class=\"button\"
1035 onclick=\"javascript:removeSelectedFeeds()\" value=\"Remove\">";
1037 if (get_pref($link, 'ENABLE_PREFS_CATCHUP_UNCATCHUP')) {
1039 <input type=\"submit\" class=\"button\"
1040 onclick=\"javascript:readSelectedFeeds()\" value=\"Mark as read\">
1041 <input type=\"submit\" class=\"button\"
1042 onclick=\"javascript:unreadSelectedFeeds()\" value=\"Mark as unread\"> ";
1046 <input type=\"submit\"
1047 class=\"button\" onclick=\"gotoExportOpml()\" value=\"Export OPML\">";
1051 print "<h3>OPML Import</h3>
1052 <form enctype=\"multipart/form-data\" method=\"POST\" action=\"opml.php\">
1053 File: <input id=\"opml_file\" name=\"opml_file\" type=\"file\">
1054 <input class=\"button\" name=\"op\" onclick=\"return validateOpmlImport();\"
1055 type=\"submit\" value=\"Import\">
1060 if ($op == "pref-filters") {
1062 $subop = $_GET["subop"];
1064 if ($subop == "editSave") {
1066 $regexp = db_escape_string($_GET["r"]);
1067 $descr = db_escape_string($_GET["d"]);
1068 $match = db_escape_string($_GET["m"]);
1069 $filter_id = db_escape_string($_GET["id"]);
1071 $result = db_query($link, "UPDATE ttrss_filters SET
1072 reg_exp = '$regexp',
1073 description = '$descr',
1074 filter_type = (SELECT id FROM ttrss_filter_types WHERE
1075 description = '$match')
1076 WHERE id = '$filter_id'");
1079 if ($subop == "remove") {
1081 if (!WEB_DEMO_MODE
) {
1083 $ids = split(",", $_GET["ids"]);
1085 foreach ($ids as $id) {
1086 db_query($link, "DELETE FROM ttrss_filters WHERE id = '$id'");
1092 if ($subop == "add") {
1094 if (!WEB_DEMO_MODE
) {
1096 $regexp = db_escape_string($_GET["regexp"]);
1097 $match = db_escape_string($_GET["match"]);
1099 $result = db_query($link,
1100 "INSERT INTO ttrss_filters (reg_exp,filter_type) VALUES
1101 ('$regexp', (SELECT id FROM ttrss_filter_types WHERE
1102 description = '$match'))");
1106 $result = db_query($link, "SELECT description
1107 FROM ttrss_filter_types ORDER BY description");
1109 $filter_types = array();
1111 while ($line = db_fetch_assoc($result)) {
1112 array_push($filter_types, $line["description"]);
1115 print "<table class=\"prefAddFeed\"><tr>
1116 <td><input id=\"fadd_regexp\"></td>
1118 print_select("fadd_match", "Title", $filter_types);
1120 print"</td><td colspan=\"4\" align=\"right\">
1121 <a class=\"button\" href=\"javascript:addFilter()\">Add filter</a></td></tr>
1124 $result = db_query($link, "SELECT
1125 id,reg_exp,description,
1126 (SELECT name FROM ttrss_filter_types WHERE
1127 id = filter_type) as filter_type_name,
1128 (SELECT description FROM ttrss_filter_types
1129 WHERE id = filter_type) as filter_type_descr
1131 ttrss_filters ORDER by reg_exp");
1133 print "<p><table width=\"100%\" class=\"prefFilterList\" id=\"prefFilterList\">";
1135 print "<tr class=\"title\">
1136 <td width=\"5%\">Select</td><td width=\"40%\">Filter expression</td>
1137 <td width=\"40%\">Description</td><td width=\"10%\">Match</td></tr>";
1141 while ($line = db_fetch_assoc($result)) {
1143 $class = ($lnum %
2) ?
"even" : "odd";
1145 $filter_id = $line["id"];
1146 $edit_filter_id = $_GET["id"];
1148 if ($subop == "edit" && $filter_id != $edit_filter_id) {
1152 print "<tr class=\"$class\" id=\"FILRR-$filter_id\">";
1154 $line["regexp"] = htmlspecialchars($line["reg_exp"]);
1155 $line["description"] = htmlspecialchars($line["description"]);
1157 if (!$edit_filter_id ||
$subop != "edit") {
1159 if (!$line["description"]) $line["description"] = "[No description]";
1161 print "<td><input onclick='toggleSelectRow(this);'
1162 type=\"checkbox\" id=\"FICHK-".$line["id"]."\"></td>";
1164 print "<td><a href=\"javascript:editFilter($filter_id);\">" .
1165 $line["reg_exp"] . "</td>";
1167 print "<td><a href=\"javascript:editFilter($filter_id);\">" .
1168 $line["description"] . "</td>";
1170 print "<td>".$line["filter_type_descr"]."</td>";
1172 } else if ($filter_id != $edit_filter_id) {
1174 if (!$line["description"]) $line["description"] = "[No description]";
1176 print "<td><input disabled=\"true\" type=\"checkbox\"
1177 id=\"FICHK-".$line["id"]."\"></td>";
1179 print "<td>".$line["reg_exp"]."</td>";
1180 print "<td>".$line["description"]."</td>";
1181 print "<td>".$line["filter_type_descr"]."</td>";
1185 print "<td><input disabled=\"true\" type=\"checkbox\"></td>";
1187 print "<td><input id=\"iedit_regexp\" value=\"".$line["reg_exp"].
1190 print "<td><input id=\"iedit_descr\" value=\"".$line["description"].
1194 print_select("iedit_match", $line["filter_type_descr"], $filter_types);
1206 print "<tr><td colspan=\"4\" align=\"center\">No filters defined.</td></tr>";
1213 if ($subop == "edit") {
1215 <input type=\"submit\" class=\"button\"
1216 onclick=\"javascript:filterEditCancel()\" value=\"Cancel\">
1217 <input type=\"submit\" class=\"button\"
1218 onclick=\"javascript:filterEditSave()\" value=\"Save\">";
1224 <input type=\"submit\" class=\"button\"
1225 onclick=\"javascript:editSelectedFilter()\" value=\"Edit\">
1226 <input type=\"submit\" class=\"button\"
1227 onclick=\"javascript:removeSelectedFilters()\" value=\"Remove\">";
1231 if ($op == "pref-labels") {
1233 $subop = $_GET["subop"];
1235 if ($subop == "editSave") {
1237 $sql_exp = $_GET["s"];
1238 $descr = $_GET["d"];
1239 $label_id = db_escape_string($_GET["id"]);
1241 // print "$sql_exp : $descr : $label_id";
1243 $result = db_query($link, "UPDATE ttrss_labels SET
1244 sql_exp = '$sql_exp',
1245 description = '$descr'
1246 WHERE id = '$label_id'");
1249 if ($subop == "remove") {
1251 if (!WEB_DEMO_MODE
) {
1253 $ids = split(",", $_GET["ids"]);
1255 foreach ($ids as $id) {
1256 db_query($link, "DELETE FROM ttrss_labels WHERE id = '$id'");
1262 if ($subop == "add") {
1264 if (!WEB_DEMO_MODE
) {
1266 $exp = $_GET["exp"];
1268 $result = db_query($link,
1269 "INSERT INTO ttrss_labels (sql_exp,description)
1270 VALUES ('$exp', '$exp')");
1274 print "<table class=\"prefAddFeed\"><tr>
1275 <td><input id=\"ladd_expr\"></td>";
1277 print"<td colspan=\"4\" align=\"right\">
1278 <a class=\"button\" href=\"javascript:addLabel()\">Add label</a></td></tr>
1281 $result = db_query($link, "SELECT
1282 id,sql_exp,description
1284 ttrss_labels ORDER by description");
1286 print "<p><table width=\"100%\" class=\"prefLabelList\" id=\"prefLabelList\">";
1288 print "<tr class=\"title\">
1289 <td width=\"5%\">Select</td><td width=\"40%\">SQL expression
1290 <a class=\"helpLink\" href=\"javascript:popupHelp(1)\">(?)</a>
1292 <td width=\"40%\">Caption</td></tr>";
1296 while ($line = db_fetch_assoc($result)) {
1298 $class = ($lnum %
2) ?
"even" : "odd";
1300 $label_id = $line["id"];
1301 $edit_label_id = $_GET["id"];
1303 if ($subop == "edit" && $label_id != $edit_label_id) {
1307 print "<tr class=\"$class\" id=\"LILRR-$label_id\">";
1309 $line["sql_exp"] = htmlspecialchars($line["sql_exp"]);
1310 $line["description"] = htmlspecialchars($line["description"]);
1312 if (!$edit_label_id ||
$subop != "edit") {
1314 if (!$line["description"]) $line["description"] = "[No caption]";
1316 print "<td><input onclick='toggleSelectRow(this);'
1317 type=\"checkbox\" id=\"LICHK-".$line["id"]."\"></td>";
1319 print "<td><a href=\"javascript:editLabel($label_id);\">" .
1320 $line["sql_exp"] . "</td>";
1322 print "<td><a href=\"javascript:editLabel($label_id);\">" .
1323 $line["description"] . "</td>";
1325 } else if ($label_id != $edit_label_id) {
1327 if (!$line["description"]) $line["description"] = "[No description]";
1329 print "<td><input disabled=\"true\" type=\"checkbox\"
1330 id=\"LICHK-".$line["id"]."\"></td>";
1332 print "<td>".$line["sql_exp"]."</td>";
1333 print "<td>".$line["description"]."</td>";
1337 print "<td><input disabled=\"true\" type=\"checkbox\"></td>";
1339 print "<td><input id=\"iedit_expr\" value=\"".$line["sql_exp"].
1342 print "<td><input id=\"iedit_descr\" value=\"".$line["description"].
1354 print "<tr><td colspan=\"4\" align=\"center\">No labels defined.</td></tr>";
1361 if ($subop == "edit") {
1363 <input type=\"submit\" class=\"button\"
1364 onclick=\"javascript:labelEditCancel()\" value=\"Cancel\">
1365 <input type=\"submit\" class=\"button\"
1366 onclick=\"javascript:labelEditSave()\" value=\"Save\">";
1372 <input type=\"submit\" class=\"button\"
1373 onclick=\"javascript:editSelectedLabel()\" value=\"Edit\">
1374 <input type=\"submit\" class=\"button\"
1375 onclick=\"javascript:removeSelectedLabels()\" value=\"Remove\">";
1379 if ($op == "error") {
1380 print "<div width=\"100%\" align='center'>";
1381 $msg = $_GET["msg"];
1386 if ($op == "help") {
1388 <title>Tiny Tiny RSS : Help</title>
1389 <link rel=\"stylesheet\" href=\"tt-rss.css\" type=\"text/css\">
1390 <script type=\"text/javascript\" src=\"functions.js\"></script>
1391 <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">
1394 $tid = sprintf("%d", $_GET["tid"]);
1396 /* FIXME this badly needs real implementation */
1398 print "<div class='helpResponse'>";
1402 <h1
>Help
for SQL expressions
</h1
>
1404 <h2
>Description
</h2
>
1406 <p
>The
«
;SQL expression
»
; is added to WHERE clause of
1407 view feed query
. You can match on ttrss_entries table fields
1408 and even
use subselect to query additional information
. This
1409 functionality is considered to be advanced
and requires basic
1410 understanding of SQL
.</p
>
1414 <pre
>unread
= true</pre
>
1416 Matches all unread articles
1418 <pre
>title like
'%Linux%'</pre
>
1420 Matches all articles which mention Linux in the title
. You get the idea
.
1422 <p
>See the database schema included in the distribution package
for gruesome
1427 print "<div align='center'>
1428 <a class=\"helpLink\"
1429 href=\"javascript:window.close()\">(Close this window)</a></div>";
1433 print "</body></html>";
1439 $param = $_GET["param"];
1441 if ($id == "quickAddFeed") {
1442 print "Feed URL: <input
1443 onblur=\"javascript:enableHotkeys()\" onfocus=\"javascript:disableHotkeys()\"
1445 <input class=\"button\"
1446 type=\"submit\" onclick=\"javascript:qafAdd()\" value=\"Add feed\">
1447 <input class=\"button\"
1448 type=\"submit\" onclick=\"javascript:closeDlg()\"
1452 if ($id == "quickDelFeed") {
1454 $param = db_escape_string($param);
1456 $result = db_query($link, "SELECT title FROM ttrss_feeds WHERE id = '$param'");
1460 $f_title = db_fetch_result($result, 0, "title");
1462 print "Remove current feed ($f_title)?
1463 <input class=\"button\"
1464 type=\"submit\" onclick=\"javascript:qfdDelete($param)\" value=\"Remove\">
1465 <input class=\"button\"
1466 type=\"submit\" onclick=\"javascript:closeDlg()\"
1469 print "Error: Feed $param not found.
1470 <input class=\"button\"
1471 type=\"submit\" onclick=\"javascript:closeDlg()\"
1476 if ($id == "search") {
1478 print "<input id=\"searchbox\" class=\"extSearch\"
1479 onblur=\"javascript:enableHotkeys()\" onfocus=\"javascript:disableHotkeys()\"
1480 onchange=\"javascript:search()\">
1481 <select id=\"searchmodebox\">
1482 <option selected>All feeds</option>
1483 <option>This feed</option>
1485 <input type=\"submit\"
1486 class=\"button\" onclick=\"javascript:search()\" value=\"Search\">
1487 <input class=\"button\"
1488 type=\"submit\" onclick=\"javascript:closeDlg()\"
1495 if ($op == "updateAllFeeds") {
1496 update_all_feeds($link, true);
1498 print "<rpc-reply>";
1499 getLabelCounters($link);
1500 getFeedCounters($link);
1501 getTagCounters($link);
1502 getGlobalCounters($link);
1503 print "</rpc-reply>";
1507 if ($op == "pref-prefs") {
1509 $subop = $_REQUEST["subop"];
1511 if ($subop == "Save configuration") {
1513 foreach (array_keys($_POST) as $pref_name) {
1515 $pref_name = db_escape_string($pref_name);
1516 $value = db_escape_string($_POST[$pref_name]);
1518 $result = db_query($link, "SELECT type_name
1519 FROM ttrss_prefs,ttrss_prefs_types
1520 WHERE pref_name = '$pref_name' AND type_id = ttrss_prefs_types.id");
1522 if (db_num_rows($result) > 0) {
1524 $type_name = db_fetch_result($result, 0, "type_name");
1526 // print "$pref_name : $type_name : $value<br>";
1528 if ($type_name == "bool") {
1529 if ($value == "1") {
1534 } else if ($type_name == "integer") {
1535 $value = sprintf("%d", $value);
1538 // print "$pref_name : $type_name : $value<br>";
1540 db_query($link, "UPDATE ttrss_prefs SET value = '$value'
1541 WHERE pref_name = '$pref_name'");
1545 header("Location: prefs.php");
1549 } else if ($subop == "getHelp") {
1551 $pref_name = db_escape_string($_GET["pn"]);
1553 $result = db_query($link, "SELECT help_text FROM ttrss_prefs
1554 WHERE pref_name = '$pref_name'");
1556 if (db_num_rows($result) > 0) {
1557 $help_text = db_fetch_result($result, 0, "help_text");
1560 print "Unknown option: $pref_name";
1563 } else if ($subop == "Reset to defaults") {
1565 db_query($link, "UPDATE ttrss_prefs SET value = def_value");
1567 header("Location: prefs.php");
1571 $result = db_query($link, "SELECT
1572 pref_name,short_desc,help_text,value,type_name,
1573 section_name,def_value
1574 FROM ttrss_prefs,ttrss_prefs_types,ttrss_prefs_sections
1575 WHERE type_id = ttrss_prefs_types.id AND
1576 section_id = ttrss_prefs_sections.id
1577 ORDER BY section_name,short_desc");
1579 print "<form action=\"backend.php\" method=\"POST\">";
1581 print "<table width=\"100%\" class=\"prefPrefsList\">";
1585 $active_section = "";
1587 while ($line = db_fetch_assoc($result)) {
1589 if ($active_section != $line["section_name"]) {
1591 if ($active_section != "") {
1592 print "</table><p><table width=\"100%\" class=\"prefPrefsList\">";
1595 $active_section = $line["section_name"];
1597 print "<tr><td colspan=\"3\"><h3>$active_section</h3></td></tr>";
1598 // print "<tr class=\"title\">
1599 // <td width=\"25%\">Option</td><td>Value</td></tr>";
1602 $class = ($lnum %
2) ?
"even" : "odd";
1604 print "<tr class=\"$class\">";
1606 $type_name = $line["type_name"];
1607 $pref_name = $line["pref_name"];
1608 $value = $line["value"];
1609 $def_value = $line["def_value"];
1610 $help_text = $line["help_text"];
1612 print "<td width=\"40%\" id=\"$pref_name\">" . $line["short_desc"];
1614 if ($help_text) print "<div class=\"prefHelp\">$help_text</div>";
1620 if ($type_name == "bool") {
1621 // print_select($pref_name, $value, array("true", "false"));
1623 if ($value == "true") {
1629 print_radio($pref_name, $value, array("Yes", "No"));
1632 print "<input class=\"editbox\" name=\"$pref_name\" value=\"$value\">";
1644 print "<input type=\"hidden\" name=\"op\" value=\"pref-prefs\">";
1646 print "<p><input class=\"button\" type=\"submit\"
1647 name=\"subop\" value=\"Save configuration\">";
1649 print " <input class=\"button\" type=\"submit\"
1650 name=\"subop\" value=\"Reset to defaults\"></p>";
1661 <!-- <?
= sprintf("Backend execution time: %.4f seconds", getmicrotime() - $script_started) ?
> -->