Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 02-12-2016, 11:53 AM
N0ctrnl's Avatar
N0ctrnl
Discordant
 
Join Date: Jan 2007
Posts: 443
Default 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);
__________________
Ender - Lead GM/Developer
Vegarlson Asylum Server - http://www.vegarlson-server.org/
Reply With Quote
  #2  
Old 02-12-2016, 12:26 PM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

Pretty sure I saw a FRUGS303 model in there too, if you want to shake things up a little bit.
Reply With Quote
  #3  
Old 02-12-2016, 02:19 PM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

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.
Reply With Quote
  #4  
Old 02-12-2016, 02:25 PM
N0ctrnl's Avatar
N0ctrnl
Discordant
 
Join Date: Jan 2007
Posts: 443
Default

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
__________________
Ender - Lead GM/Developer
Vegarlson Asylum Server - http://www.vegarlson-server.org/
Reply With Quote
  #5  
Old 02-12-2016, 02:52 PM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

Am i right though, you popped them under the zone z-axis for the floor? I cannot even see them.
Reply With Quote
  #6  
Old 02-12-2016, 02:54 PM
N0ctrnl's Avatar
N0ctrnl
Discordant
 
Join Date: Jan 2007
Posts: 443
Default

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.
__________________
Ender - Lead GM/Developer
Vegarlson Asylum Server - http://www.vegarlson-server.org/
Reply With Quote
  #7  
Old 02-12-2016, 03:00 PM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

Maybe I am seeing them and did not know it. They are touching end to end?
Reply With Quote
  #8  
Old 02-12-2016, 03:10 PM
N0ctrnl's Avatar
N0ctrnl
Discordant
 
Join Date: Jan 2007
Posts: 443
Default

Yeah. They're butted right up against each other. Beige, thatch pattern with darker stripes at the end.
__________________
Ender - Lead GM/Developer
Vegarlson Asylum Server - http://www.vegarlson-server.org/
Reply With Quote
  #9  
Old 02-12-2016, 03:11 PM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

I see what you did there! Brilliant!
Reply With Quote
  #10  
Old 02-12-2016, 03:37 PM
N0ctrnl's Avatar
N0ctrnl
Discordant
 
Join Date: Jan 2007
Posts: 443
Default

It was about the least invasive thing I could come up with at the time :P
__________________
Ender - Lead GM/Developer
Vegarlson Asylum Server - http://www.vegarlson-server.org/
Reply With Quote
  #11  
Old 02-12-2016, 03:38 PM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

Seriously glad you shared, a very creative approach to the problem.
Reply With Quote
  #12  
Old 04-26-2016, 04:57 PM
fryguy
Sarnak
 
Join Date: May 2007
Posts: 47
Default

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?
Reply With Quote
  #13  
Old 07-20-2024, 10:53 AM
chrsschb's Avatar
chrsschb
Dragon
 
Join Date: Nov 2008
Location: GA
Posts: 904
Default

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);
__________________
Clumsy's World: Resurgence [2019-Present]
Clumsy's World 2.0 [2014-2016]
Clumsy's World [2006-2012]
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 03:27 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3