diff options
| -rw-r--r-- | db/alert_types.sql | 11 | ||||
| -rwxr-xr-x | web/rss.cgi | 4 |
2 files changed, 13 insertions, 2 deletions
diff --git a/db/alert_types.sql b/db/alert_types.sql index fc7300032..a512d7619 100644 --- a/db/alert_types.sql +++ b/db/alert_types.sql @@ -20,6 +20,17 @@ values ('new_problems', '', '', 'problem', 'problem.state in (\'confirmed\', \'fixed\')', 'created desc', '{{title}}, {{confirmed}}', '/?id={{id}}', '{{detail}}', 'alert-problem'); +-- New fixed problems anywhere on the site +insert into alert_type +(ref, head_sql_query, head_table, + head_title, head_link, head_description, + item_table, item_where, item_order, + item_title, item_link, item_description, template) +values ('new_fixed_problems', '', '', + 'Problems recently reported fixed on FixMyStreet', '/', 'The latest problems reported fixed by users', + 'problem', 'problem.state in (\'fixed\')', 'lastupdate desc', + '{{title}}, {{confirmed}}', '/?id={{id}}', '{{detail}}', 'alert-problem'); + -- New problems around a location insert into alert_type (ref, head_sql_query, head_table, diff --git a/web/rss.cgi b/web/rss.cgi index 1d357efbb..39c2c89cb 100755 --- a/web/rss.cgi +++ b/web/rss.cgi @@ -6,7 +6,7 @@ # Copyright (c) 2007 UK Citizens Online Democracy. All rights reserved. # Email: matthew@mysociety.org. WWW: http://www.mysociety.org # -# $Id: rss.cgi,v 1.21 2008-05-23 09:53:10 matthew Exp $ +# $Id: rss.cgi,v 1.22 2008-09-01 17:17:58 matthew Exp $ use strict; use Standard; @@ -26,7 +26,7 @@ sub main { my $id = $q->param('id'); my $qs = '?id='.$id; $out = mySociety::Alert::generate_rss($type, $qs, [$id]); - } elsif ($type eq 'new_problems') { + } elsif ($type eq 'new_problems' || $type eq 'new_fixed_problems') { $out = mySociety::Alert::generate_rss($type, ''); } elsif ($type eq 'council_problems') { my $id = $q->param('id'); |