From f3cd955b85092ea418d9c1de90be49c9f598527f Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Sat, 2 Sep 2017 14:06:41 +0200 Subject: [PATCH] Show target coords as soon as they are released --- lib/NDWeb/Controller/Root.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/lib/NDWeb/Controller/Root.pm b/lib/NDWeb/Controller/Root.pm index 4608240..5faa024 100644 --- a/lib/NDWeb/Controller/Root.pm +++ b/lib/NDWeb/Controller/Root.pm @@ -129,8 +129,8 @@ sub listTargets : Private { my $dbh = $c ->model; - my $query = $dbh->prepare(q{SELECT t.id, r.id AS raid, r.tick+c.wave-1 AS landingtick, - (released_coords AND old_claim(timestamp)) AS released_coords, coords(x,y,z),c.launched,c.wave,c.joinable + my $query = $dbh->prepare(q{SELECT t.id, r.id AS raid, r.tick+c.wave-1 AS landingtick, + released_coords, coords(x,y,z),c.launched,c.wave,c.joinable FROM raid_claims c JOIN raid_targets t ON c.target = t.id JOIN raids r ON t.raid = r.id -- 2.39.2