NATURAL JOIN planet_stats) t ON i.target = t.id
AND t.tick = ( SELECT MAX(tick) FROM planet_stats)
WHERE i.sender = $1
- AND (i.tick > $2 - 14 OR i.mission = 'Full Fleet')
+ AND (i.tick > $2 - 14 OR i.mission = 'Full fleet')
ORDER BY i.tick,x,y,z
});
- my $ships = $DBH->prepare('SELECT ship,amount FROM fleet_ships WHERE id = ?');
+ my $ships = $DBH->prepare('SELECT ship,amount FROM fleet_ships WHERE id = ? ORDER BY num');
$outgoings->execute($call->{planet},$call->{landing_tick});
my @fleets;
while (my $fleet = $outgoings->fetchrow_hashref){
push @ships,$ship;
}
$fleet->{Ships} = \@ships;
- delete $fleet->{id};
push @defenders, $fleet;
}
$BODY->param(Defenders => \@defenders);