X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;ds=sidebyside;f=calls.pl;fp=calls.pl;h=ef7566441687efe8482095829c280b1b3fb760d4;hb=5ed240620d3e45fb765a35d3d387a09742ac6769;hp=0b843dfdb09dd910ad4e3481cced2294f39a4914;hpb=bea57618abafc540d48753f78400a6d0e4cde3f1;p=ndwebbie.git diff --git a/calls.pl b/calls.pl index 0b843df..ef75664 100644 --- a/calls.pl +++ b/calls.pl @@ -130,7 +130,7 @@ if ($call){ $BODY->param(Ignore => 'Open'); } my $fleets = $DBH->prepare(q{ -SELECT id,mission,landing_tick,eta, (landing_tick+eta-1) AS back FROM fleets WHERE uid = ? AND (fleet = 0 OR (landing_tick + eta > ? AND landing_tick - eta - 11 < ? )) +SELECT id,mission,landing_tick,eta, back FROM fleets WHERE uid = ? AND (fleet = 0 OR (landing_tick + eta > ? AND landing_tick - eta - 11 < ? )) ORDER BY fleet ASC}); my $ships = $DBH->prepare('SELECT ship,amount FROM fleet_ships WHERE fleet = ?'); $fleets->execute($call->{member},$call->{landing_tick},$call->{landing_tick});