X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FIntel.pm;fp=lib%2FNDWeb%2FController%2FIntel.pm;h=a67674714b71fa87f133ba3fe96eb0961ba60077;hp=9666282e1f805c31fafac2af5784a77866f8f269;hb=82c8844f01d81e70b789cdbd455bedc4b2f94c87;hpb=5464b9f340cc8f8b1e5b37ce244601a24b760677 diff --git a/lib/NDWeb/Controller/Intel.pm b/lib/NDWeb/Controller/Intel.pm index 9666282..a676747 100644 --- 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{