From 82c8844f01d81e70b789cdbd455bedc4b2f94c87 Mon Sep 17 00:00:00 2001
From: Michael Andreen <michael@andreen.dev>
Date: Fri, 13 Jan 2023 15:55:55 +0100
Subject: [PATCH] Planet government intel

---
 lib/NDWeb/Controller/Intel.pm | 4 +++-
 root/src/intel/planet.tt2     | 4 ++--
 2 files changed, 5 insertions(+), 3 deletions(-)

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{
diff --git a/root/src/intel/planet.tt2 b/root/src/intel/planet.tt2
index 86fbff9..ce46268 100644
--- a/root/src/intel/planet.tt2
+++ b/root/src/intel/planet.tt2
@@ -21,8 +21,8 @@
 		</tr>
 		<tr><td>Government</td>
 			<td><select name="gov">
-[% FOR gov IN govs %]
-				<option value="[% gov %]" [% IF gov == p.gov %]selected[% END %]> [% gov %]</option>
+[% FOR g IN govs %]
+				<option value="[% g.gov %]" [% IF g.gov == p.gov %]selected[% END %]> [% g.gov_name %]</option>
 [% END %]
 				</select></td>
 			<td><input type="checkbox" name="cgov"></td>
-- 
2.39.2