X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FCalls.pm;h=d3a44e301eb3c1c0418975ed588c71e6d92f87df;hb=c66b1b9074d880fb13a825bc75c1bc842ec65f75;hp=cbb78da89284aefc63a5e27bc4e8440930a6f254;hpb=5b6c3c7d0003d636c1c3da6d25734e4aad5736a5;p=ndwebbie.git

diff --git a/lib/NDWeb/Controller/Calls.pm b/lib/NDWeb/Controller/Calls.pm
index cbb78da..d3a44e3 100644
--- a/lib/NDWeb/Controller/Calls.pm
+++ b/lib/NDWeb/Controller/Calls.pm
@@ -54,7 +54,8 @@ sub list : Local {
 
 	my $query = $dbh->prepare(qq{
 		SELECT id,coords(x,y,z),planet,landing_tick,dc,curreta,fleets
-			,(0.2*(attack_points/a.attack)+ 0.4*(defense_points/a.defense)
+			,(0.2*(attack_points/GREATEST(a.attack,1))
+				+ 0.4*(defense_points/GREATEST(a.defense,1))
 				+ 0.2*(c.size/a.size) + 0.05*(c.score/a.score)
 				+ 0.15*(c.value/a.value))::Numeric(3,2) AS defprio
 			,array_accum(COALESCE(race::text,'')) AS race