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 07-14-2012, 11:55 AM
Tabasco's Avatar
Tabasco
Discordant
 
Join Date: Sep 2009
Posts: 269
Default Charasis Doors

I'm seeing a lot of doors in charasis with keyitem values of 1 (latest PEQ) and this was causing a zone crash when players clicked the door.

Based on some guides I've set what should be appropriate key items for keyed doors.
This should be every door that requires a key for that zone:
Code:
INSERT INTO `doors` (`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `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
(6481, 8, 'charasis', 0, 'SBDOOR102', 167.854, 6.95582, 18.002, 0, 22, 0, 201, 20511, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 100, 0, 4294967295, 0),
(6479, 10, 'charasis', 0, 'SBDOOR102', -167.853, -6.94283, 18.002, 256, 22, 0, 201, 20513, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 100, 0, 4294967295, 0),
(6478, 11, 'charasis', 0, 'SBDOOR102', -6.95046, 167.856, 18.002, 128, 22, 0, 201, 20512, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 100, 0, 4294967295, 0),
(6470, 29, 'charasis', 0, 'SBDOOR102', 62.0415, -735.728, 18.002, 256, 22, 0, 50, 20515, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 100, 0, 4294967295, 0),
(6468, 35, 'charasis', 0, 'SBDOOR102', -51.9493, 639.698, 18.002, 128, 22, 0, 201, 20515, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 100, 0, 4294967295, 0),
(6494, 40, 'charasis', 0, 'SBDOOR102', 541.793, 153.857, 0.002, 128, 22, 0, 201, 20514, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 100, 0, 4294967295, 0),
(6466, 46, 'charasis', 0, 'SBDOOR102', -705.694, -51.9199, 0.002, 256, 22, 0, 201, 20516, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 0, 100, 0, 4294967295, 0);
Reply With Quote
  #2  
Old 07-14-2012, 08:16 PM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

Edit: Was looking at the wrong column. We do indeed have doors in charasis as keyitem 1, but they are correct and are handled by Perl since multiple keys open those doors.

It doesn't crash on Linux, so perhpas a code update is needed to fix that under Windows.
Reply With Quote
  #3  
Old 07-14-2012, 10:56 PM
Tabasco's Avatar
Tabasco
Discordant
 
Join Date: Sep 2009
Posts: 269
Default

I honestly didn't look into it that deeply since the guides I found said nothing of multiple keys and one door had an expected item key while the others did not.

I'm running on debian, so it's not a windows issue either.
I apologize for putting up such a hasty fix though. I'll investigate it further and let you know what I find.
Reply With Quote
  #4  
Old 07-14-2012, 11:04 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

I didn't see where this was a long-standing problem or something that has crept up recently.

When I modified doors.cpp I did not alter the way that doors are actually checked, just how the client action is processed.

If it turns out to be something that I did, let me know and I'll be glad to take a look at it.
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #5  
Old 07-15-2012, 01:32 AM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

Each door can open with a specific key, or a master key that opens them all. I didn't set this up, but it's pretty well documented on the PEQ forums.

I'll take a look at it and see if I can get it to crash, though I haven't seen any door related core dumps lately and I am sure I would have heard about it on the PEQ forums by now.
Reply With Quote
  #6  
Old 07-15-2012, 09:01 PM
Tabasco's Avatar
Tabasco
Discordant
 
Join Date: Sep 2009
Posts: 269
Default

I wasn't familiar enough with the area and a player could consistently reproduce a crash so I didn't investigate in places where I should have.

It appears to be client related, but not in terms of SoF/SoD/HoT, etc. but rather an individual player install (With and without 3rd party stuff). I don't even know how that would happen, it makes no sense, but I can key for charasis on an unprivileged account and it all works fine.

This can be nuked or ignored.
Reply With Quote
  #7  
Old 07-15-2012, 11:50 PM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

Quote:
Originally Posted by Tabasco View Post
It appears to be client related, but not in terms of SoF/SoD/HoT, etc. but rather an individual player install (With and without 3rd party stuff). I don't even know how that would happen, it makes no sense, but I can key for charasis on an unprivileged account and it all works fine.
Welcome to my world.
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 12:59 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