X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FCalls.pm;fp=lib%2FNDWeb%2FController%2FCalls.pm;h=8515212ac1340db26ab395e7b0bc3a27bad78f68;hb=8c8aadb2e9a2076dbf00d12ea5acf2779f706aae;hp=2afedadab8e430e0cadfae04a1a43239a83b8705;hpb=831088fa9ab0362a5091b54b33db1f61437ccdfc;p=ndwebbie.git 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