|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc. |
|
|
|
02-12-2016, 11:53 AM
|
|
Discordant
|
|
Join Date: Jan 2007
Posts: 443
|
|
Old Bazaar - Make trader stalls work
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);
|
|
|
|
02-12-2016, 12:26 PM
|
|
Demi-God
|
|
Join Date: Nov 2007
Posts: 2,175
|
|
Pretty sure I saw a FRUGS303 model in there too, if you want to shake things up a little bit.
|
02-12-2016, 02:19 PM
|
|
Demi-God
|
|
Join Date: Nov 2007
Posts: 2,175
|
|
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.
|
02-12-2016, 02:25 PM
|
|
Discordant
|
|
Join Date: Jan 2007
Posts: 443
|
|
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
|
02-12-2016, 02:52 PM
|
|
Demi-God
|
|
Join Date: Nov 2007
Posts: 2,175
|
|
Am i right though, you popped them under the zone z-axis for the floor? I cannot even see them.
|
02-12-2016, 02:54 PM
|
|
Discordant
|
|
Join Date: Jan 2007
Posts: 443
|
|
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.
|
02-12-2016, 03:00 PM
|
|
Demi-God
|
|
Join Date: Nov 2007
Posts: 2,175
|
|
Maybe I am seeing them and did not know it. They are touching end to end?
|
02-12-2016, 03:10 PM
|
|
Discordant
|
|
Join Date: Jan 2007
Posts: 443
|
|
Yeah. They're butted right up against each other. Beige, thatch pattern with darker stripes at the end.
|
02-12-2016, 03:11 PM
|
|
Demi-God
|
|
Join Date: Nov 2007
Posts: 2,175
|
|
I see what you did there! Brilliant!
|
02-12-2016, 03:37 PM
|
|
Discordant
|
|
Join Date: Jan 2007
Posts: 443
|
|
It was about the least invasive thing I could come up with at the time :P
|
02-12-2016, 03:38 PM
|
|
Demi-God
|
|
Join Date: Nov 2007
Posts: 2,175
|
|
Seriously glad you shared, a very creative approach to the problem.
|
04-26-2016, 04:57 PM
|
Sarnak
|
|
Join Date: May 2007
Posts: 50
|
|
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?
|
|
|
|
07-20-2024, 10:53 AM
|
|
Dragon
|
|
Join Date: Nov 2008
Location: GA
Posts: 904
|
|
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);
|
|
|
|
Thread Tools |
|
Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 10:31 PM.
|
|
|
|
|
|
|
|
|
|
|
|
|