my $attackers = $c->model->prepare(q{
SELECT coords(p.x,p.y,p.z), ruler, planet FROM current_planet_stats p
JOIN planet_stats ps using (id)
-WHERE ps.tick = $1 AND (2000.0*$2*$3/ps.value)::int = $4
+WHERE ps.tick = $1 AND trunc(2000.0*$2*$3/ps.value)::int = $4
});
$attackers->execute($tick,$agents,$value,$stolen);
if ($attackers->rows == 0){