X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FTextExport.pm;h=74118d17f0a35f495edb65101ee6e00e8b97162e;hb=d07ef82b1587636cf2eafd479caad48e3416cde4;hp=37772ee6ebf21d91c7c02969597bc101d7c2e006;hpb=f5639def9af1ddcef6c9d17d6c6ab534aeb6adda;p=ndwebbie.git diff --git a/lib/NDWeb/Controller/TextExport.pm b/lib/NDWeb/Controller/TextExport.pm index 37772ee..74118d1 100644 --- a/lib/NDWeb/Controller/TextExport.pm +++ b/lib/NDWeb/Controller/TextExport.pm @@ -30,7 +30,7 @@ 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 ORDER BY x,y,z});