}
my $available = $dbh->prepare(q{
-SELECT ship,amount from ships_home WHERE planet = $1 AND tick = $2
+SELECT ship,amount from ships_home WHERE pid = $1 AND tick = $2
});
$available->execute($call->{pid}, $call->{landing_tick});
my $fleet = {fid => $call->{member}, mission => 'Available'
FROM launch_confirmations
WHERE pid = $1 AND landing_tick = $2
) lc USING (fid)
-WHERE mission = 'Defend'
+WHERE mission IN ('Defend', 'Fake Defend')
ORDER BY x,y,z
});