diff options
| author | matthew <matthew> | 2007-05-16 17:47:41 +0000 |
|---|---|---|
| committer | matthew <matthew> | 2007-05-16 17:47:41 +0000 |
| commit | b779fee01c0aaf1070d550e101edc9f834c46df2 (patch) | |
| tree | 1bf4c0836c1dae872e3d0187bc70fb1686f0d78a /db | |
| parent | 00fee19b9dff2b7be957434cf9276bda19a7f7cf (diff) | |
Make distance a parameter.
Diffstat (limited to 'db')
| -rw-r--r-- | db/alert_types.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/db/alert_types.sql b/db/alert_types.sql index 9b0c99a1b..63322f986 100644 --- a/db/alert_types.sql +++ b/db/alert_types.sql @@ -25,7 +25,7 @@ insert into alert_type item_title, item_link, item_description, template) values ('local_problems', '', '', 'New local problems on Neighbourhood Fix-It', '/', 'The latest local problems reported by users', - 'problem_find_nearby(?, ?, 10) as nearby,problem', 'nearby.problem_id = problem.id and problem.state in (\'confirmed\', \'fixed\')', 'created desc', + 'problem_find_nearby(?, ?, ?) as nearby,problem', 'nearby.problem_id = problem.id and problem.state in (\'confirmed\', \'fixed\')', 'created desc', '{{title}}', '/?id={{id}}', '{{detail}}', 'alert-problem'); insert into alert_type |