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);

provocating · #2 02-12-2016, 12:26 PM

Pretty sure I saw a FRUGS303 model in there too, if you want to shake things up a little bit.

provocating · #3 02-12-2016, 02:19 PM

Actually do not use FRUGS303. I see what the OP did, he basicallly sunk the rug down below the surface some. He also put it at the post between 4 stalls and increased the size, very creative.

N0ctrnl · #4 02-12-2016, 02:25 PM

I took a great deal of care when placing them. I didn't want it to look too gaudy or just thrown together. I'm pleased with the placement and break points between the rugs for a 'best I could do under the circumstances' solution

provocating · #5 02-12-2016, 02:52 PM

Am i right though, you popped them under the zone z-axis for the floor? I cannot even see them.

N0ctrnl · #6 02-12-2016, 02:54 PM

They should show up. #reloadstatic? They're as low as I could drop them and have 'em still work, but they do still show up for me.

provocating · #7 02-12-2016, 03:00 PM

Maybe I am seeing them and did not know it. They are touching end to end?

N0ctrnl · #8 02-12-2016, 03:10 PM

Yeah. They're butted right up against each other. Beige, thatch pattern with darker stripes at the end.

provocating · #9 02-12-2016, 03:11 PM

I see what you did there! Brilliant!

N0ctrnl · #10 02-12-2016, 03:37 PM

It was about the least invasive thing I could come up with at the time :P

provocating · #11 02-12-2016, 03:38 PM

Seriously glad you shared, a very creative approach to the problem.

fryguy · #12 04-26-2016, 04:57 PM

Thank you so much for sharing this. However I have noticed an issue.

Starting a Trader requires you be on the rug, however once it is started, you can run off the rug and anywhere you want.

Anyone know a good fix for this?

chrsschb · #13 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);