Old Bazaar - Make trader stalls work

chrsschb · #1 07-20-2024, 10:53 AM

Old post but the results still work. I updated the sql for current binaries/databases if anyone is looking for and finds this.

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`, `close_timer_ms`, `dz_switch_id`, `min_expansion`, `max_expansion`, `content_flags`, `content_flags_disabled`) VALUES
(37419, 124, 'bazaar', 0, 'FRUGS302', -628.5, 95.5, 0.77, 128, 155, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'NONE', 0, 0, 0, 0, 0, 0, 0, 900, 0, 4294967295, 0, 5000, 0, -1, -1, NULL, NULL),
(37420, 125, 'bazaar', 0, 'FRUGS302', -681.5, 95.5, 0.77, 128, 155, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'NONE', 0, 0, 0, 0, 0, 0, 0, 900, 0, 4294967295, 0, 5000, 0, -1, -1, NULL, NULL),
(37421, 126, 'bazaar', 0, 'FRUGS302', -734.5, 95.5, 0.77, 128, 155, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'NONE', 0, 0, 0, 0, 0, 0, 0, 900, 0, 4294967295, 0, 5000, 0, -1, -1, NULL, NULL),
(37422, 127, 'bazaar', 0, 'FRUGS302', -628.5, -104.75, 0.77, 128, 155, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'NONE', 0, 0, 0, 0, 0, 0, 0, 900, 0, 4294967295, 0, 5000, 0, -1, -1, NULL, NULL),
(37423, 128, 'bazaar', 0, 'FRUGS302', -681.5, -104.75, 0.77, 128, 155, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'NONE', 0, 0, 0, 0, 0, 0, 0, 900, 0, 4294967295, 0, 5000, 0, -1, -1, NULL, NULL),
(37424, 129, 'bazaar', 0, 'FRUGS302', -734.5, -104.75, 0.77, 128, 155, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'NONE', 0, 0, 0, 0, 0, 0, 0, 900, 0, 4294967295, 0, 5000, 0, -1, -1, NULL, NULL),
(37428, 133, 'bazaar', 0, 'FRUGS302', -674.999, -203.982, 0.77, 128, 155, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 900, 0, 4294967295, 0, 5000, 0, -1, -1, NULL, NULL),
(37738, 134, 'bazaar', 0, 'FRUGS302', -568.999, -203.982, 0.77, 128, 155, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 900, 0, 4294967295, 0, 5000, 0, -1, -1, NULL, NULL),
(37739, 135, 'bazaar', 0, 'FRUGS302', -621.999, -203.982, 0.77, 128, 155, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 900, 0, 4294967295, 0, 5000, 0, -1, -1, NULL, NULL),
(37740, 136, 'bazaar', 0, 'FRUGS302', -348.499, -104.732, 0.77, 128, 155, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 900, 0, 4294967295, 0, 5000, 0, -1, -1, NULL, NULL),
(37741, 137, 'bazaar', 0, 'FRUGS302', -454.499, -104.732, 0.77, 128, 155, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 900, 0, 4294967295, 0, 5000, 0, -1, -1, NULL, NULL),
(37742, 138, 'bazaar', 0, 'FRUGS302', -401.499, -104.732, 0.77, 128, 155, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 900, 0, 4294967295, 0, 5000, 0, -1, -1, NULL, NULL),
(37743, 139, 'bazaar', 0, 'FRUGS302', -348.499, 95.268, 0.77, 128, 155, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 900, 0, 4294967295, 0, 5000, 0, -1, -1, NULL, NULL),
(37744, 140, 'bazaar', 0, 'FRUGS302', -454.499, 95.268, 0.77, 128, 155, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 900, 0, 4294967295, 0, 5000, 0, -1, -1, NULL, NULL),
(37745, 141, 'bazaar', 0, 'FRUGS302', -401.499, 95.268, 0.77, 128, 155, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 900, 0, 4294967295, 0, 5000, 0, -1, -1, NULL, NULL),
(37746, 142, 'bazaar', 0, 'FRUGS302', -541.749, 68.4, 0.77, 256, 155, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 900, 0, 4294967295, 0, 5000, 0, -1, -1, NULL, NULL),
(37747, 143, 'bazaar', 0, 'FRUGS302', -541.749, -37.6, 0.77, 256, 155, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 900, 0, 4294967295, 0, 5000, 0, -1, -1, NULL, NULL),
(37748, 144, 'bazaar', 0, 'FRUGS302', -541.749, 15.4, 0.77, 256, 155, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 900, 0, 4294967295, 0, 5000, 0, -1, -1, NULL, NULL),
(37749, 145, 'bazaar', 0, 'FRUGS302', -541.749, -77.6, 0.77, 256, 155, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 900, 0, 4294967295, 0, 5000, 0, -1, -1, NULL, NULL);