X-Git-Url: https://ruin.nu/git/?p=NDIRC.git;a=blobdiff_plain;f=Commands%2FPA.pm;h=500e93b8e7b65874ca948978566bd566d6307b6e;hp=7fb453db9f78c513e759d679ad7db1916132a9db;hb=4d8da97942cdb099117f21fd292b865325a5b897;hpb=6869ced9b1972cf5839e0c9049d900031d1466b6 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