diff options
author | Andrew Dolgov <[email protected]> | 2005-09-03 08:22:29 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2005-09-03 08:22:29 +0100 |
commit | a0d5388913ca8f9a97fa1ef257517230412bafdd (patch) | |
tree | 6c331d48d6a8a93d612875564c3a273b7b9a84bb /backend.php | |
parent | f92db4f5e750358bf49f4aa81d6f91b00e006494 (diff) |
reworked preferences dialog, start work on post filters (schema updated)
Diffstat (limited to 'backend.php')
-rw-r--r-- | backend.php | 167 |
1 files changed, 166 insertions, 1 deletions
diff --git a/backend.php b/backend.php index ef6caf0b1..9c0b5c8b0 100644 --- a/backend.php +++ b/backend.php @@ -475,7 +475,13 @@ } } } - + + print "<table class=\"prefAddFeed\"><tr> + <td><input id=\"fadd_link\"></td> + <td colspan=\"4\" align=\"right\"> + <a class=\"button\" href=\"javascript:addFeed()\">Add feed</a></td></tr> + </table>"; + $result = pg_query("SELECT id,title,feed_url,substring(last_updated,1,16) as last_updated FROM @@ -578,5 +584,164 @@ } + if ($op == "pref-filters") { + + $subop = $_GET["subop"]; + + if ($subop == "editSave") { +/* $feed_title = pg_escape_string($_GET["t"]); + $feed_link = pg_escape_string($_GET["l"]); + $feed_id = $_GET["id"]; + + $result = pg_query("UPDATE ttrss_feeds SET + title = '$feed_title', feed_url = '$feed_link' WHERE id = '$feed_id'"); */ + + } + + if ($subop == "remove") { + + if (!WEB_DEMO_MODE) { + + $ids = split(",", $_GET["ids"]); + + foreach ($ids as $id) { + pg_query("DELETE FROM ttrss_filters WHERE id = '$id'"); + + } + } + } + + if ($subop == "add") { + +/* if (!WEB_DEMO_MODE) { + + $feed_link = pg_escape_string($_GET["link"]); + + $result = pg_query( + "INSERT INTO ttrss_feeds (feed_url,title) VALUES ('$feed_link', '')"); + + $result = pg_query( + "SELECT id FROM ttrss_feeds WHERE feed_url = '$feed_link'"); + + $feed_id = pg_fetch_result($result, 0, "id"); + + if ($feed_id) { + update_rss_feed($link, $feed_link, $feed_id); + } + } */ + } + + $result = pg_query("SELECT description + FROM ttrss_filter_types ORDER BY description"); + + $filter_types = array(); + + while ($line = pg_fetch_assoc($result)) { + array_push($filter_types, $line["description"]); + } + + print "<table class=\"prefAddFeed\"><tr> + <td>Expr: <input id=\"fadd_regexp\"></td> + <td>"; + print_select("fadd_match", "", $filter_types); + + print"</td><td colspan=\"4\" align=\"right\"> + <a class=\"button\" href=\"javascript:addFilter()\">Add filter</a></td></tr> + </table>"; + + $result = pg_query("SELECT + id,regexp,description, + (SELECT name FROM ttrss_filter_types WHERE + id = filter_type) as filter_type_name, + (SELECT description FROM ttrss_filter_types + WHERE id = filter_type) as filter_type_descr + FROM + ttrss_filters ORDER by id"); + + print "<p><table width=\"100%\" class=\"prefFilterList\" id=\"prefFilterList\">"; + + print "<tr class=\"title\"> + <td>Select</td><td width=\"40%\">Filter Expression</td> + <td width=\"40%\">Description</td><td>Match</td></tr>"; + + $lnum = 0; + + while ($line = pg_fetch_assoc($result)) { + + $class = ($lnum % 2) ? "even" : "odd"; + + $filter_id = $line["id"]; + $edit_filter_id = $_GET["id"]; + + if ($subop == "edit" && $filter_id != $edit_filter_id) { + $class .= "Grayed"; + } + + print "<tr class=\"$class\" id=\"FILRR-$filter_id\">"; + + if (!$edit_filter_id || $subop != "edit") { + + print "<td><input onclick='toggleSelectRow(this);' + type=\"checkbox\" id=\"FICHK-".$line["id"]."\"></td>"; + + print "<td><a href=\"javascript:editFilter($filter_id);\">" . + $line["regexp"] . "</td>"; + + print "<td><a href=\"javascript:editFilter($filter_id);\">" . + $line["description"] . "</td>"; + + print "<td>".$line["filter_type_descr"]."</td>"; + + } else if ($filter_id != $edit_filter_id) { + + print "<td><input disabled=\"true\" type=\"checkbox\" + id=\"FICHK-".$line["id"]."\"></td>"; + + print "<td>".$line["regexp"]."</td>"; + print "<td>".$line["description"]."</td>"; + print "<td>".$line["filter_type_descr"]."</td>"; + + } else { + + print "<td><input disabled=\"true\" type=\"checkbox\"></td>"; + + print "<td><input id=\"iedit_regexp\" value=\"".$line["regexp"]. + "\"></td>"; + + print "<td><input id=\"iedit_descr\" value=\"".$line["description"]. + "\"></td>"; + + print "<td>"; + print_select("iedit_match", $line["filter_type_descr"], $filter_types); + print "</td>"; + + } + + + print "</tr>"; + + ++$lnum; + } + + print "</table>"; + + print "<p>"; + + if ($subop == "edit") { + print "Edit feed: + <a class=\"button\" href=\"javascript:filterEditCancel()\">Cancel</a> + <a class=\"button\" href=\"javascript:filterEditSave()\">Save</a>"; + + } else { + + print " + Selection: + <a class=\"button\" + href=\"javascript:editSelectedFilter()\">Edit</a> + <a class=\"buttonWarn\" + href=\"javascript:removeSelectedFilters()\">Remove</a> "; + } + } + pg_close($link); ?> |