Show category and whether map was used; tabs.

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';