X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FTextExport.pm;h=dc0b99d58a250de99d33fc3f52f1306739537528;hb=9519c80241167db071e44cbdd1e1843daad6e305;hp=37772ee6ebf21d91c7c02969597bc101d7c2e006;hpb=d9e0bd63f3f0522b4eaebe7d525048570fe43ef6;p=ndwebbie.git diff --git a/lib/NDWeb/Controller/TextExport.pm b/lib/NDWeb/Controller/TextExport.pm index 37772ee..dc0b99d 100644 --- a/lib/NDWeb/Controller/TextExport.pm +++ b/lib/NDWeb/Controller/TextExport.pm @@ -30,9 +30,9 @@ sub alliance : Local { my ( $self, $c, $ally ) = @_; my $dbh = $c->model; - my $query = $dbh->prepare(q{SELECT coords(x,y,z), size, score, value, COALESCE(nick,'') AS nick + my $query = $dbh->prepare(q{SELECT coords(x,y,z), size, score, value,race, COALESCE(nick,'') AS nick FROM current_planet_stats - WHERE alliance_id = $1 + WHERE aid = $1 ORDER BY x,y,z}); $query->execute($ally);