Change database structure for planets and alliances + PG 8.4 changes

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

diff --git a/lib/NDWeb/Controller/TextExport.pm b/lib/NDWeb/Controller/TextExport.pm
index 74118d17f0a35f495edb65101ee6e00e8b97162e..dc0b99d58a250de99d33fc3f52f1306739537528 100644 (file)
--- a/lib/NDWeb/Controller/TextExport.pm
+++ b/lib/NDWeb/Controller/TextExport.pm
@@ -32,7 +32,7 @@ sub alliance : Local {
 
        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);