Planet government intel

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

diff --git a/lib/NDWeb/Controller/Intel.pm b/lib/NDWeb/Controller/Intel.pm
index 9666282e1f805c31fafac2af5784a77866f8f269..a67674714b71fa87f133ba3fe96eb0961ba60077 100644 (file)
--- a/lib/NDWeb/Controller/Intel.pm
+++ b/lib/NDWeb/Controller/Intel.pm
@@ -80,7 +80,9 @@ sub planet : Local {
        $c->forward('/listAlliances');
        $c->forward('/forum/findPosts',[$p->{ftid}]);
 
-       $c->stash(govs => ["","Feu", "Dic", "Dem","Uni"]);
+       my $governments = $dbh->prepare(q{SELECT gov, gov_name FROM governments});
+       $governments->execute;
+       $c->stash(govs => $governments->fetchall_arrayref({}));
        $c->stash(planetstatus => ["","Friendly", "NAP", "Hostile"]);
 
        $query = $dbh->prepare(q{