PoTimeB Doors

[Genesis]

Sup all,

I've been tinkering with a solo/group server with a mate of mine, and we're up to doing some work on PoTimeB.

Unfortunately, I can't seem to find the doors in the doors table to unlock them to allow an individual or a group to complete Phase 1.

Does anyone know where I can find the doors in the database, or if I have to put them in myself before I can edit them?

Any help would be appreciated.

[Capheus]

Easy way for PotimeB doors is to do a sort by zone. PotimeB clocl doors will have a -1 for a lockpick value and a 1 for a keyitem value. I'd give you the exact ones but I changed mine already and not entirely sure which is which unless I got /loc em all.

They are prolly listed as TMDOOR500, ...501, ...502, ...503, not 100% sure though

[blackdragonsdg]

The potimeb doors information is in the doors table but each door has multiple pieces so it can be confusing. Here is the data for the doors but it is from a few db revisions ago so it may have changed.



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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11385, 16, 'potimeb', 0, 'TMDOOR503', 708.825, 465.931, 493.984, 384, 81, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11386, 15, 'potimeb', 0, 'TMDOOR501', 708.825, 465.932, 512.974, 384, 79, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11387, 14, 'potimeb', 0, 'TMDOOR500', 708.824, 465.931, 512.974, 384, 78, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11388, 13, 'potimeb', 0, 'TMDOOR502', 708.825, 465.932, 493.984, 384, 80, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11389, 8, 'potimeb', 0, 'TMDOOR502', 574.69, 90.0528, 493.954, 128, 80, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11390, 7, 'potimeb', 0, 'TMDOOR500', 574.69, 90.0528, 512.944, 128, 78, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11391, 6, 'potimeb', 0, 'TMDOOR501', 574.69, 90.0528, 512.945, 128, 79, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11392, 5, 'potimeb', 0, 'TMDOOR503', 574.69, 90.0524, 493.954, 128, 81, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11393, 25, 'potimeb', 0, 'TMDOOR502', 868.419, 89.9697, 494.169, 384, 80, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11394, 26, 'potimeb', 0, 'TMDOOR500', 868.419, 89.9697, 513.169, 384, 78, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11395, 27, 'potimeb', 0, 'TMDOOR501', 868.419, 89.9697, 513.169, 384, 79, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11396, 28, 'potimeb', 0, 'TMDOOR503', 868.419, 89.9697, 494.169, 384, 81, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11397, 29, 'potimeb', 0, 'TMDOOR502', 1109.72, 89.946, 493.998, 384, 80, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11398, 30, 'potimeb', 0, 'TMDOOR500', 1109.72, 89.9458, 512.989, 384, 78, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11399, 31, 'potimeb', 0, 'TMDOOR501', 1109.72, 89.946, 512.99, 384, 79, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11400, 32, 'potimeb', 0, 'TMDOOR503', 1109.72, 89.9457, 493.998, 384, 81, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11401, 33, 'potimeb', 0, 'TMDOOR502', 1110, 466.118, 494.149, 384, 80, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11402, 34, 'potimeb', 0, 'TMDOOR500', 1109.99, 466.118, 513.139, 384, 78, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11403, 35, 'potimeb', 0, 'TMDOOR501', 1110, 466.118, 513.139, 384, 79, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11404, 36, 'potimeb', 0, 'TMDOOR503', 1110, 466.118, 494.148, 384, 81, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);

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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11365, 49, 'potimeb', 0, 'TMDOOR503', 1355.2, 89.9725, 493.686, 384, 81, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11366, 48, 'potimeb', 0, 'TMDOOR501', 1355.2, 89.9722, 512.678, 384, 79, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11367, 47, 'potimeb', 0, 'TMDOOR500', 1355.21, 89.9724, 512.678, 384, 78, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11368, 46, 'potimeb', 0, 'TMDOOR502', 1355.2, 89.9722, 493.687, 384, 80, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11369, 45, 'potimeb', 0, 'TMDOOR503', 1645, 90.125, 494.038, 128, 81, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11370, 44, 'potimeb', 0, 'TMDOOR501', 1645, 90.1247, 513.029, 128, 79, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11371, 43, 'potimeb', 0, 'TMDOOR500', 1645, 90.1249, 513.029, 128, 78, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11372, 42, 'potimeb', 0, 'TMDOOR502', 1645, 90.1247, 494.038, 128, 80, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11373, 41, 'potimeb', 0, 'TMDOOR503', 1503.95, 466.144, 494.116, 128, 81, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11374, 40, 'potimeb', 0, 'TMDOOR501', 1503.95, 466.143, 513.108, 128, 79, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11375, 39, 'potimeb', 0, 'TMDOOR500', 1503.95, 466.143, 513.108, 128, 78, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);
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_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`) VALUES (11376, 38, 'potimeb', 0, 'TMDOOR502', 1503.95, 466.143, 494.117, 128, 80, 0, -1, 1, 0, 0, 0, 0, 12, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0, 0);

[Genesis]

Thanks for the swift replies, all sorted now. Cheers!