From cb527c92ddb92c89a8aa55ba92369cd2312763ed Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Sun, 4 Oct 2009 10:28:44 +0200 Subject: [PATCH] Make the tick range inclusive instead of exclusive --- lib/NDWeb/Controller/Alliances.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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 }); -- 2.39.2