From: Michael Andreen <michael@andreen.dev>
Date: Fri, 13 Jan 2023 14:55:55 +0000 (+0100)
Subject: Planet government intel
X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=commitdiff_plain;h=82c8844f01d81e70b789cdbd455bedc4b2f94c87

Planet government intel
---

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>