X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FUsers.pm;h=67fb97f6545c4e9213d41bfa5120a35fb3e6ed87;hb=6a9e5393fb419bef37a90ff92fb1ec557f8290dc;hp=a77d93d9f10402ed8a1b573197671bb8c3066924;hpb=635963fffb6fb1a05e7fcf2812f9df1b006be7fd;p=ndwebbie.git diff --git a/lib/NDWeb/Controller/Users.pm b/lib/NDWeb/Controller/Users.pm index a77d93d..67fb97f 100644 --- a/lib/NDWeb/Controller/Users.pm +++ b/lib/NDWeb/Controller/Users.pm @@ -130,7 +130,7 @@ sub findUser : Private { my $query = $dbh->prepare(q{ SELECT uid,username,hostmask,attack_points,defense_points,scan_points,humor_points,info, email, sms - ,COALESCE(coords(x,y,z),'') AS planet + ,COALESCE(coords(x,y,z),'') AS planet, pid FROM users u LEFT OUTER JOIN current_planet_stats p USING (pid) WHERE uid = ?; });