X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FAlliances.pm;fp=lib%2FNDWeb%2FController%2FAlliances.pm;h=d8b332017ae86043c314566bd25eca325274bba7;hp=6c9731cc087f94b599f2841e5203694dff49a2e2;hb=33a44a03fa129739264f7ccd983e38c96c11a677;hpb=a482ae605a2ecb265854e6a02672524bbae2ae7a diff --git a/lib/NDWeb/Controller/Alliances.pm b/lib/NDWeb/Controller/Alliances.pm index 6c9731c..d8b3320 100644 --- a/lib/NDWeb/Controller/Alliances.pm +++ b/lib/NDWeb/Controller/Alliances.pm @@ -136,7 +136,7 @@ sub fleet : Local { WITH aus AS (SELECT DISTINCT ON (pid) pid, fid, name,tick FROM fleets f join fleet_scans fs using (fid) - WHERE mission = 'Full fleet' and name = 'Advanced Unit' + WHERE mission = 'Full fleet' and name IN ('Advanced Unit', 'Military') ORDER BY pid,tick DESC) ,ships AS (SELECT pid, tick, ship, amount, id AS ship_id FROM fleet_ships fs JOIN aus USING(fid) JOIN ship_stats USING(ship))