Explicit ordering of fleets, so they're shown as normal unit scans

[ndwebbie.git] / NDWeb / Pages / Check.pm

diff --git a/NDWeb/Pages/Check.pm b/NDWeb/Pages/Check.pm
index cac7f92bef68c450de688c470ac052bf5d7df931..88e37e6dc5d98034613a53d7a85d12bb237f75e7 100644 (file)
--- 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};