X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FIntel.pm;h=535ca28bbf0a4d7109796df30001a2750416895e;hb=2a703f7250ea25f2f556eb25b644dcb7268f92ce;hp=94bbfa15841418ccb574ba9ec14ce30046ddbfab;hpb=7d478421939145912a4155865ad6b521e1bff08f;p=ndwebbie.git 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