Old Bazaar - Make trader stalls work

N0ctrnl · #1 02-12-2016, 11:53 AM

So I've been using the old Bazaar for quite a while now. I added rugs under each of the stalls with the correct door type to enable trader mode when standing on them. I was pretty meticulous when I added them, so they should be spaced pretty well.

I'm dropping this here in case anybody wants to use it or improve on it. I didn't spent any effort on trying to find a door model I could hide or anything, but that would probably be the next step.

You may need to tinker with the id of them depending on your database.

Code:

INSERT INTO `doors` (`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `altkeyitem`, `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
(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),
(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),
(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),
(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),
(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),
(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),
(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),
(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),
(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),
(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),
(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),
(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),
(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),
(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),
(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),
(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),
(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),
(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),
(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);