X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=NDWeb%2FPages%2FRaids.pm;h=4b454589af81e11a6bebc19e4bba811a72d39a49;hb=e1dcc7600950592294588f5980bef59a018dd768;hp=0b342fa42022547358865b52e8d680c91cd0f222;hpb=b3d60946973fc4d48b32c2447522f0bba02087d3;p=ndwebbie.git diff --git a/NDWeb/Pages/Raids.pm b/NDWeb/Pages/Raids.pm index 0b342fa..4b45458 100644 --- a/NDWeb/Pages/Raids.pm +++ b/NDWeb/Pages/Raids.pm @@ -245,7 +245,9 @@ sub render_body { ORDER BY name,i.tick DESC }); $unitscans->execute($target->{planet}) or warn $DBH->errstr; - 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 = $unitscans->fetchrow_hashref){ my @ships;