From dbb56523011bf9403a88fc4eb4e35bd0ed359178 Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Sun, 7 Oct 2007 12:22:32 +0200 Subject: [PATCH] Don't show fleets with unknown mission type on intel overview --- NDWeb/Pages/Intel.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/NDWeb/Pages/Intel.pm b/NDWeb/Pages/Intel.pm index 58a8c67..b129265 100644 --- a/NDWeb/Pages/Intel.pm +++ b/NDWeb/Pages/Intel.pm @@ -204,7 +204,7 @@ sub render_body { }elsif(!param('coords')){ my $query = $DBH->prepare(intelquery('o.alliance AS oalliance,coords(o.x,o.y,o.z) AS origin, t.alliance AS talliance,coords(t.x,t.y,t.z) AS target',qq{not ingal - AND ((( t.alliance_id != o.alliance_id OR t.alliance_id IS NULL OR o.alliance_id IS NULL) AND i.mission != 'Attack') + AND ((( t.alliance_id != o.alliance_id OR t.alliance_id IS NULL OR o.alliance_id IS NULL) AND (i.mission = 'Defend' OR i.mission = 'AllyDef' )) OR ( t.alliance_id = o.alliance_id AND i.mission = 'Attack')) AND i.sender NOT IN (SELECT planet FROM users u NATURAL JOIN groupmembers gm WHERE gid = 8 AND planet IS NOT NULL) $showticks})); -- 2.39.2