View Single Post
  #105  
Old 10-21-2019, 04:15 PM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,333
Default

If you copy and paste this into a query, it will put those deleted pok book entries back in the doors table.

Code:
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `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 (12283, 78, 'nektulos', 0, 'POKTELE500', 742.973, -342.478, -8.34902, 267.81, 58, 0, 0, 0, 0, 0, 0, 0, 0, 77, 'poknowledge', 0, 132, -841, -157, 1, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `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 (5070, 1, 'Innothule', 0, 'POKTELE500', -729.133, -29.9866, -29.2157, 477.21, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, 69, -813, -145, 0, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `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 (9, 8, 'Tox', 0, 'POKTELE500', 2324.96, -582.532, -47.8143, 120, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, 35.9378, 630, -145, 128, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `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 (4969, 109, 'Gfaydark', 0, 'POKTELE500', -173.6, -757.995, -4.09175, 163.29, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, 884, 871, -155, 0, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `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 (4968, 108, 'Gfaydark', 0, 'POKTELE500', -2260.51, -1820.6, -1.68313, 17, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, 73, 811, -155, 0, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `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 (3415, 1, 'Everfrost', 0, 'POKTELE500', 2887.25, -78.1207, -64.1542, 238.73, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, 132.109, 873, -145, 128, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `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 (4139, 44, 'Misty', 0, 'POKTELE500', -559.555, -1262.71, 6.89263, 2, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, 1229, 871, -155, 128, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `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 (5337, 77, 'feerrott', 0, 'POKTELE500', 867.158, -161.403, -9.75448, 504, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, 444, -844, -157, 255, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `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 (2353, 7, 'Tox', 0, 'POKTELE500', -2344.14, 295.884, -49.748, 371.01, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, 1228, -893, -152, 252, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `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 (2561, 46, 'Steamfont', 0, 'POKTELE500', -1373.04, 933.79, -111.662, 0, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, -75, -421, -155, 0, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `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 (6623, 77, 'fieldofbone', 0, 'POKTELE500', -3010.88, 1843.5, 8.377, 0, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, 36, -655, -157, 1, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `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 (5783, 177, 'freportw', 0, 'POKTELE500', -682.064, 77.3664, -34.8048, 0, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, -234, -406, -157, 2, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `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 (5996, 77, 'qeynos2', 0, 'POKTELE500', 183.698, 484.484, 0.002, 3, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, -289, 147, -157, 127, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `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 (7123, 77, 'overthere', 0, 'POKTELE500', 3134.56, 1937.59, -53.3417, 384, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, 884, -840, -157, 254, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `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 (9363, 78, 'shadeweaver', 0, 'POKTELE500', -3011.8, -2425.1, -218.342, 494, 58, 0, 0, 0, 0, 0, 0, 0, 0, 77, 'poknowledge', 0, -293, 364, -157, 192, 0, 511, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `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 (14156, 37, 'crescent', 0, 'POKTELE500', -1213, -2761, -113.5, 130, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, -127, 58, -155.9, 63, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `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 (12797, 212, 'rathemtn', 0, 'POKTELE500', -1176.75, 305, -3, 32, 58, 0, 0, 0, 0, 0, 0, 0, 0, 23, 'poknowledge', 0, 1182, 771, -156, 128, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `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 (12913, 78, 'butcher', 0, 'POKTELE500', 1754.95, -506.765, -3.65425, 258.958, 58, 0, 0, 0, 0, 0, 0, 0, 0, 77, 'poknowledge', 0, 474, 829, -157, 255, 0, 511, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `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 (17404, 77, 'innothuleb', 0, 'POKTELE500', -443.25, -361.75, 2.5, 0, 58, 0, 0, 0, 0, 0, 0, 0, 0, 77, 'poknowledge', 0, 95, -812, -157, 384, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `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 (33835, 77, 'arena', 0, 'POKTELE500', -1022.76, 147.807, 46.7928, 504.45, 58, 0, 0, 0, 0, 0, 0, 0, 0, 77, 'poknowledge', 0, 140, -430, -152, 260, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `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 (34179, 4, 'feerrott2', 0, 'POKTELE500', 1300, 212, 50, 201, 58, 0, 0, 0, 0, 0, 0, 0, 0, 25, 'poknowledge', 0, 444, -844, -157, 127.5, 0, 0, 100, 0, 4294967295, 0);
__________________
Hanging out at Antonica.World
Reply With Quote