From 4d8da97942cdb099117f21fd292b865325a5b897 Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Wed, 26 Aug 2009 17:31:58 +0200 Subject: [PATCH] Need the pid --- Commands/PA.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Commands/PA.pm b/Commands/PA.pm index 7fb453d..500e93b 100644 --- a/Commands/PA.pm +++ b/Commands/PA.pm @@ -55,7 +55,7 @@ sub p } my $f = $c->model->prepare(q{ -WITH p AS (SELECT coords(x,y,z),ruler,planet,race,score,size,value,scorerank,sizerank, +WITH p AS (SELECT pid,coords(x,y,z),ruler,planet,race,score,size,value,scorerank,sizerank, valuerank, xp, xprank, alliance, relationship, nick, planet_status, hit_us, channel FROM current_planet_stats WHERE (x = $1 AND y = $2 and z = $3) OR nick ILIKE $4 LIMIT 1 -- 2.39.2