Thread: Game Mechanics: Locked doors/Lockpick skill
View Single Post
  #18  
Old 04-30-2010, 02:23 AM
nilbog nilbog is offline
Project Manager

nilbog's Avatar

Join Date: Oct 2009
Posts: 14,672
Default

Quote:
Originally Posted by PearlJammzz [You must be logged in to view images. Log in or Register.]
From what Nilbog says with the zone/location of the door it is insanely simple to check.
Insanely simple.

Code:
SELECT
doors.zone,
doors.pos_y,
doors.pos_x,
doors.pos_z,
doors.id,
doors.doorid,
doors.lockpick
FROM
doors
WHERE
doors.lockpick >  '0'
Here are all the doors where lockpick > 0. Let me know what needs changing. Not many on the list.. could be missing some?

[You must be logged in to view images. Log in or Register.]