From 77bd36f5189b0de25ff99ffec16d9e9187feb2fd Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Tue, 2 Dec 2008 11:13:26 +0100 Subject: [PATCH] bugfix, show planet_status on raid edit --- lib/NDWeb/Controller/Raids.pm | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/lib/NDWeb/Controller/Raids.pm b/lib/NDWeb/Controller/Raids.pm index f2bfa0a..217ce37 100644 --- a/lib/NDWeb/Controller/Raids.pm +++ b/lib/NDWeb/Controller/Raids.pm @@ -237,7 +237,8 @@ sub edit : Local { $order .= 'p.x,p.y,p.z'; } - my $targetquery = $dbh->prepare(qq{SELECT r.id,coords(x,y,z),comment,size,score,value,race,planet_status AS planetstatus,relationship,comment,r.planet, s.scans + my $targetquery = $dbh->prepare(qq{SELECT r.id,coords(x,y,z),comment,size + ,score,value,race,planet_status,relationship,comment,r.planet, s.scans FROM raid_targets r JOIN current_planet_stats p ON p.id = r.planet LEFT OUTER JOIN ( SELECT planet, array_accum(s::text) AS scans -- 2.39.2