I'm seeing a lot of doors in charasis with keyitem values of 1 (latest PEQ) and this was causing a zone crash when players clicked the door.
Based on some guides I've set what should be appropriate key items for keyed doors.
Code:
INSERT INTO `doors` (`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`,
`triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_instance`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `client_version_mask`, `is_ldon_door`) VALUES
(6481, 8, 'charasis', 0, 'SBDOOR102', 167.854, 6.95582, 18.002, 0, 22, 0, 201, 20511, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 100, 0, 4294967295, 0),
(6479, 10, 'charasis', 0, 'SBDOOR102', -167.853, -6.94283, 18.002, 256, 22, 0, 201, 20513, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 100, 0, 4294967295, 0),
(6478, 11, 'charasis', 0, 'SBDOOR102', -6.95046, 167.856, 18.002, 128, 22, 0, 201, 20512, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 100, 0, 4294967295, 0),
(6470, 29, 'charasis', 0, 'SBDOOR102', 62.0415, -735.728, 18.002, 256, 22, 0, 50, 20515, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 100, 0, 4294967295, 0),
(6468, 35, 'charasis', 0, 'SBDOOR102', -51.9493, 639.698, 18.002, 128, 22, 0, 201, 20515, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 100, 0, 4294967295, 0),
(6494, 40, 'charasis', 0, 'SBDOOR102', 541.793, 153.857, 0.002, 128, 22, 0, 201, 20514, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 100, 0, 4294967295, 0),
(6466, 46, 'charasis', 0, 'SBDOOR102', -705.694, -51.9199, 0.002, 256, 22, 0, 201, 20516, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 100, 0, 4294967295, 0);