List defenders using fake defend mission

[ndwebbie.git] / lib / NDWeb / Controller / Calls.pm

diff --git a/lib/NDWeb/Controller/Calls.pm b/lib/NDWeb/Controller/Calls.pm
index 467c7321fc40451ba6056754c25c852b996e76f9..7203bc11bfe82285750ee66f2266ac828a8ea840 100644 (file)
--- a/lib/NDWeb/Controller/Calls.pm
+++ b/lib/NDWeb/Controller/Calls.pm
@@ -135,7 +135,7 @@ sub edit : Local {
        }
 
        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'
@@ -156,7 +156,7 @@ FROM fleets f
                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
        });