From c5a19db607b88a8d96a017e56cd92963bf8e69ea Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Tue, 2 Feb 2010 17:06:50 +0100 Subject: [PATCH] Fix in case planets happens to be 0 --- lib/NDWeb/Controller/Stats.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/NDWeb/Controller/Stats.pm b/lib/NDWeb/Controller/Stats.pm index e2c784d..9379e99 100644 --- a/lib/NDWeb/Controller/Stats.pm +++ b/lib/NDWeb/Controller/Stats.pm @@ -62,7 +62,7 @@ FROM galaxies g GROUP BY raid,p.tick,x,y ) AS a JOIN galaxies g USING (tick,x,y) - WHERE a.count::float / g.planets >= 0.5 + WHERE a.count::float / NULLIF(g.planets,0) >= 0.5 ORDER BY x,y,tick ) AS raid USING (x,y) -- 2.39.2