From: Michael Andreen <harv@ruin.nu>
Date: Sun, 4 Oct 2009 08:28:44 +0000 (+0200)
Subject: Make the tick range inclusive instead of exclusive
X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=commitdiff_plain;h=cb527c92ddb92c89a8aa55ba92369cd2312763ed

Make the tick range inclusive instead of exclusive
---

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
 		});