From 8c8aadb2e9a2076dbf00d12ea5acf2779f706aae Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Wed, 18 Feb 2009 09:55:41 +0100 Subject: [PATCH] List all fleets for defenders --- lib/NDWeb/Controller/Calls.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/NDWeb/Controller/Calls.pm b/lib/NDWeb/Controller/Calls.pm index 2afedad..8515212 100644 --- a/lib/NDWeb/Controller/Calls.pm +++ b/lib/NDWeb/Controller/Calls.pm @@ -167,7 +167,7 @@ sub edit : Local { $c->stash(fleets => \@fleets); my $defenders = $dbh->prepare(q{ -SELECT DISTINCT ON (x,y,z,s.id,name,amount) fid,mission, name, eta +SELECT DISTINCT ON (x,y,z,s.id,name,amount,back) fid,mission, name, eta , amount, coords(x,y,z) AS coords, landing_tick AS tick, f.planet ,back, (back <> landing_tick + eta - 1) AS recalled FROM launch_confirmations lc -- 2.39.2