From: Michael Andreen Date: Sat, 21 Mar 2009 17:49:47 +0000 (+0100) Subject: Add race to text export of alliance listing X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=commitdiff_plain;h=d07ef82b1587636cf2eafd479caad48e3416cde4 Add race to text export of alliance listing --- 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});