diff options
author | Andrew Dolgov <[email protected]> | 2005-09-03 08:50:18 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2005-09-03 08:50:18 +0100 |
commit | 0afbd8519316ed633db6e1729653728913f63ebc (patch) | |
tree | 304151cbe2e4c3c9753aea508f0d9061776ab61d | |
parent | de435974523438840fbe250160523d87568f960e (diff) |
implemented filter editor, piggified default filter
-rw-r--r-- | backend.php | 39 | ||||
-rw-r--r-- | prefs.php | 2 | ||||
-rw-r--r-- | ttrss_schema.sql | 4 |
3 files changed, 34 insertions, 11 deletions
diff --git a/backend.php b/backend.php index 3b07bd38d..2c87cb7c6 100644 --- a/backend.php +++ b/backend.php @@ -490,7 +490,7 @@ print "<p><table width=\"100%\" class=\"prefFeedList\" id=\"prefFeedList\">"; print "<tr class=\"title\"> <td> </td><td>Select</td><td width=\"40%\">Title</td> - <td width=\"40%\">Link</td><td>Last Updated</td></tr>"; + <td width=\"40%\">Link</td><td>Last updated</td></tr>"; $lnum = 0; @@ -545,7 +545,9 @@ print "<td><input id=\"iedit_link\" value=\"".$line["feed_url"]."\"></td>"; } - + + if (!$line["last_updated"]) $line["last_updated"] = "Never"; + print "<td>" . $line["last_updated"] . "</td>"; print "</tr>"; @@ -553,6 +555,10 @@ ++$lnum; } + if ($lnum == 0) { + print "<tr><td colspan=\"5\" align=\"center\">No feeds defined.</td></tr>"; + } + print "</table>"; print "<p>"; @@ -589,13 +595,18 @@ $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'"); */ + $regexp = pg_escape_string($_GET["r"]); + $descr = pg_escape_string($_GET["d"]); + $match = pg_escape_string($_GET["m"]); + $filter_id = pg_escape_string($_GET["id"]); + + $result = pg_query("UPDATE ttrss_filters SET + regexp = '$regexp', + description = '$descr', + filter_type = (SELECT id FROM ttrss_filter_types WHERE + description = '$match') + WHERE id = '$filter_id'"); } if ($subop == "remove") { @@ -655,8 +666,8 @@ 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>"; + <td width=\"5%\">Select</td><td width=\"40%\">Filter expression</td> + <td width=\"40%\">Description</td><td width=\"10%\">Match</td></tr>"; $lnum = 0; @@ -675,6 +686,8 @@ if (!$edit_filter_id || $subop != "edit") { + if (!$line["description"]) $line["description"] = "[No description]"; + print "<td><input onclick='toggleSelectRow(this);' type=\"checkbox\" id=\"FICHK-".$line["id"]."\"></td>"; @@ -688,6 +701,8 @@ } else if ($filter_id != $edit_filter_id) { + if (!$line["description"]) $line["description"] = "[No description]"; + print "<td><input disabled=\"true\" type=\"checkbox\" id=\"FICHK-".$line["id"]."\"></td>"; @@ -717,6 +732,10 @@ ++$lnum; } + if ($lnum == 0) { + print "<tr><td colspan=\"4\" align=\"center\">No filters defined.</td></tr>"; + } + print "</table>"; print "<p>"; @@ -28,8 +28,8 @@ </tr> </tr> <td id="prefContent" class="prefContent" valign="top" colspan="2"> + <h2>Feed Configuration</h2> <div id="piggie"> </div> - <h2>Feed Configuration</h2> <div class="expPane" id="feedConfPane"> <a href="javascript:expandPane('feedConfPane')">Click to expand >></a> diff --git a/ttrss_schema.sql b/ttrss_schema.sql index 79a58677c..d78e0b16c 100644 --- a/ttrss_schema.sql +++ b/ttrss_schema.sql @@ -59,3 +59,7 @@ create table ttrss_filters (id serial primary key, regexp varchar(250) not null, description varchar(250) not null default ''); +COPY ttrss_filters (id, filter_type, regexp, description) FROM stdin; +1 3 PIGGIES MOORE! MOOOOORE PIGGIES! +\. + |