From cc2295480ae9acde53cd38d11aa28c56b0d9db34 Mon Sep 17 00:00:00 2001
From: Michael Andreen <harv@ruin.nu>
Date: Thu, 26 Mar 2009 07:29:50 +0100
Subject: [PATCH] Show nick when pasting coords

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

diff --git a/lib/NDWeb/Controller/Intel.pm b/lib/NDWeb/Controller/Intel.pm
index 94bbfa1..535ca28 100644
--- a/lib/NDWeb/Controller/Intel.pm
+++ b/lib/NDWeb/Controller/Intel.pm
@@ -49,7 +49,7 @@ sub index :Path : Args(0) {
 		while ($coords =~ m/(\d+:\d+:\d+)/g){
 			push @coords,$1;
 		}
-		my $planets = $dbh->prepare(q{SELECT id,coords(x,y,z), alliance
+		my $planets = $dbh->prepare(q{SELECT id,coords(x,y,z), alliance, nick
 			FROM current_planet_stats p
 			WHERE coords(x,y,z) = ANY($1)
 			ORDER BY alliance, p.x, p.y, p.z
diff --git a/root/src/intel/index.tt2 b/root/src/intel/index.tt2
index cb96bf9..f4e067f 100644
--- a/root/src/intel/index.tt2
+++ b/root/src/intel/index.tt2
@@ -2,11 +2,12 @@
 
 [% IF coordslist %]
 <table class="stats">
-	<tr><th>Coords</th><th>Alliance</th></tr>
+	<tr><th>Coords</th><th>Alliance</th><th>Nick</th></tr>
 	[% FOR p IN coordslist %]
 	<tr>
 		<td><a href="[% c.uri_for('planet',p.id) %]">[% p.coords %]</a></td>
 		<td>[% p.alliance %]</td>
+		<td>[% p.nick %]</td>
 	</tr>
 	[% END %]
 </table>
-- 
2.39.2