X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FCalls.pm;h=7203bc11bfe82285750ee66f2266ac828a8ea840;hb=935116e73806d105bf3097b62e3e231fe834d672;hp=467c7321fc40451ba6056754c25c852b996e76f9;hpb=aa42aa5497f10f957d426f5777a746f3af49f534;p=ndwebbie.git diff --git a/lib/NDWeb/Controller/Calls.pm b/lib/NDWeb/Controller/Calls.pm index 467c732..7203bc1 100644 --- 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 });