$c->forward('findRaid');
$raid = $c->stash->{raid};
- $c->stash(raid => $raid->{id});
my $planet;
if ($c->user->planet){
my $query = $dbh->prepare(q{SELECT value, score,x,y FROM current_planet_stats WHERE pid = ?});
$target->{claims} = \@claims;
my $num = pow(10,length($target->{score})-2);
- $target->{score} = "Hidden"; #ceil($target->{score}/$num)*$num;
+ $target->{score} = "Hidden" unless $raid->{released_coords}; #ceil($target->{score}/$num)*$num;
$num = pow(10,length($target->{value})-2);
- $target->{value} = "Hidden"; #ceil($target->{value}/$num)*$num;
+ $target->{value} = "Hidden" unless $raid->{released_coords}; #ceil($target->{value}/$num)*$num;
$num = pow(10,length($target->{size})-2);
$target->{size} = floor($target->{size}/$num)*$num;
$num = pow(10,length($target->{fleetvalue})-2);
);
my $ships = $dbh->prepare(q{
-SELECT id, amount FROM fleet_ships fs JOIN ship_stats s ON s.name = fs.ship
+SELECT id, amount FROM fleet_ships fs JOIN ship_stats s USING (ship)
WHERE fid = $1
});
SELECT $1,pid,array_to_string(array_agg(
fleet || ': eta=' || eta || ', amount=' || amount || ', type=' || shiptype
|| ' landing=' || landing_tick || 'back=' || landing_tick + eta
- ),'\n')
+ ),E'\n')
FROM calls c
JOIN incomings i USING (call)
JOIN current_planet_stats p USING (pid)