diff options
Diffstat (limited to 'web/index.cgi')
-rwxr-xr-x | web/index.cgi | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/web/index.cgi b/web/index.cgi index 292c0699a..5819b707b 100755 --- a/web/index.cgi +++ b/web/index.cgi @@ -6,7 +6,7 @@ # Copyright (c) 2006 UK Citizens Online Democracy. All rights reserved. # Email: matthew@mysociety.org. WWW: http://www.mysociety.org # -# $Id: index.cgi,v 1.133 2007-05-15 13:43:21 matthew Exp $ +# $Id: index.cgi,v 1.134 2007-05-16 10:55:46 matthew Exp $ use strict; require 5.8.0; @@ -551,9 +551,10 @@ sub display_problem { # Get all information from database my $problem = dbh()->selectrow_hashref( - "select state, easting, northing, title, detail, name, extract(epoch from confirmed) as time, photo, anonymous, - extract(epoch from whensent-confirmed) as whensent, council, id, - extract(epoch from ms_current_timestamp()-lastupdate) as duration + "select id, easting, northing, council, category, title, detail, photo, + used_map, name, anonymous, extract(epoch from confirmed) as time, + state, extract(epoch from whensent-confirmed) as whensent, + extract(epoch from ms_current_timestamp()-lastupdate) as duration from problem where id=? and state in ('confirmed','fixed', 'hidden')", {}, $input{id}); return display_location($q, 'Unknown problem ID') unless $problem; return front_page($q, 'That problem has been hidden from public view as it contained inappropriate public details') if $problem->{state} eq 'hidden'; |