X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=NDWeb%2FPages%2FCheck.pm;fp=NDWeb%2FPages%2FCheck.pm;h=88e37e6dc5d98034613a53d7a85d12bb237f75e7;hb=e1dcc7600950592294588f5980bef59a018dd768;hp=cac7f92bef68c450de688c470ac052bf5d7df931;hpb=a9d6b3fc8849921b91fb3591cd1658582041fea9;p=ndwebbie.git diff --git a/NDWeb/Pages/Check.pm b/NDWeb/Pages/Check.pm index cac7f92..88e37e6 100644 --- a/NDWeb/Pages/Check.pm +++ b/NDWeb/Pages/Check.pm @@ -147,7 +147,9 @@ sub render_body { ORDER BY i.tick,x,y,z }); $query->execute($planet_id); - my $ships = $DBH->prepare(q{SELECT ship,amount FROM fleet_ships WHERE id = ?}); + my $ships = $DBH->prepare(q{SELECT ship,amount FROM fleet_ships + WHERE id = ? ORDER BY num + }); my @missions; while (my $mission = $query->fetchrow_hashref){ $mission->{CLASS} = $mission->{mission};