Don't show unit scans in raid if they're older than the AU

[ndwebbie.git] / lib / NDWeb / Controller / TextExport.pm

diff --git a/lib/NDWeb/Controller/TextExport.pm b/lib/NDWeb/Controller/TextExport.pm
index 37772ee6ebf21d91c7c02969597bc101d7c2e006..dc0b99d58a250de99d33fc3f52f1306739537528 100644 (file)
--- 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);