X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=ND%2FWeb%2FXMLPage.pm;fp=ND%2FWeb%2FXMLPage.pm;h=9e5fce64f846f32f6e11e25a370ca3509bf31d84;hb=0121660a54d34d0e14a4550fa88beef63705e69d;hp=d1804f1a02ea2c40d8a7d417209868f460258b81;hpb=f628343d025725e197503f845a76a322bf9e7780;p=ndwebbie.git diff --git a/ND/Web/XMLPage.pm b/ND/Web/XMLPage.pm index d1804f1..9e5fce6 100644 --- a/ND/Web/XMLPage.pm +++ b/ND/Web/XMLPage.pm @@ -39,7 +39,8 @@ sub process : method { sub listTargets () : method { my $self = shift; my $DBH = $self->{DBH}; - my $query = $DBH->prepare(qq{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 + my $query = $DBH->prepare(qq{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 FROM raid_claims c JOIN raid_targets t ON c.target = t.id JOIN raids r ON t.raid = r.id