X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;ds=sidebyside;f=lib%2FNDWeb%2FController%2FAlliances.pm;h=ec6da88f2d634d648549dea75564f0209b1f2c3c;hb=cb527c92ddb92c89a8aa55ba92369cd2312763ed;hp=5f3372655474d454f355131c6ebd0c58d0390372;hpb=23470c3481cbd9e7dfa3bfa5cf05bbb41d098cc6;p=ndwebbie.git diff --git a/lib/NDWeb/Controller/Alliances.pm b/lib/NDWeb/Controller/Alliances.pm index 5f33726..ec6da88 100644 --- a/lib/NDWeb/Controller/Alliances.pm +++ b/lib/NDWeb/Controller/Alliances.pm @@ -193,7 +193,7 @@ sub hostile : Local { FROM calls c JOIN incomings i USING (call) JOIN current_planet_stats s USING (pid) -WHERE c.landing_tick - i.eta > $1 and c.landing_tick - i.eta < $2 +WHERE c.landing_tick BETWEEN $1 + i.eta AND $2 + i.eta GROUP BY s.aid,s.alliance ORDER BY hostile_count DESC });