Make the tick range inclusive instead of exclusive

[ndwebbie.git] / lib / NDWeb / Controller / Alliances.pm

diff --git a/lib/NDWeb/Controller/Alliances.pm b/lib/NDWeb/Controller/Alliances.pm
index 5f3372655474d454f355131c6ebd0c58d0390372..ec6da88f2d634d648549dea75564f0209b1f2c3c 100644 (file)
--- 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
                });