Show nick when pasting coords

diff --git a/lib/NDWeb/Controller/Intel.pm b/lib/NDWeb/Controller/Intel.pm
index 94bbfa15841418ccb574ba9ec14ce30046ddbfab..535ca28bbf0a4d7109796df30001a2750416895e 100644 (file)
--- 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 cb96bf9d6f8f4c6686e9773cd0daa8eefedd77c8..f4e067f437bd61ed72bcc1206c5c96a44767737b 100644 (file)
--- 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>