]> ruin.nu Git - ndwebbie.git/commitdiff
Make the tick range inclusive instead of exclusive
authorMichael Andreen <harv@ruin.nu>
Sun, 4 Oct 2009 08:28:44 +0000 (10:28 +0200)
committerMichael Andreen <harv@ruin.nu>
Sun, 4 Oct 2009 08:28:44 +0000 (10:28 +0200)
lib/NDWeb/Controller/Alliances.pm

index 5f3372655474d454f355131c6ebd0c58d0390372..ec6da88f2d634d648549dea75564f0209b1f2c3c 100644 (file)
@@ -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
                });