]> ruin.nu Git - NDIRC.git/commitdiff
Need the pid
authorMichael Andreen <harv@ruin.nu>
Wed, 26 Aug 2009 15:31:58 +0000 (17:31 +0200)
committerMichael Andreen <harv@ruin.nu>
Wed, 26 Aug 2009 15:31:58 +0000 (17:31 +0200)
Commands/PA.pm

index 7fb453db9f78c513e759d679ad7db1916132a9db..500e93b8e7b65874ca948978566bd566d6307b6e 100644 (file)
@@ -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