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-03-2012, 06:10 PM
Curzon7
Fire Beetle
 
Join Date: Jun 2012
Posts: 10
Default

Well, I tried many many things, and eventually managed to disable the access restriction related to a certain item.

The first thing I tried was adding all key item id's to the loot table of an easy to get to mob. This did not work, I couldn't get any of my changes to loot to work at all, I'm thinking there's some relationship between the client and the server with respect to loot drops, because this also caused alot of errors to start showing up on my error log for the server. So I abandoned that idea for now, though I plan to revisit it with maybe adding the items to a merchant for purchase.

The next thing I tried was changing the key item id in the doors table. I used a lodi shield id (as my character in the world at the locked door happened to have one on him). This did not work, although it did add the lodi shield to that character's keyring.

What finally worked was setting the key item id AND the picklock field to zero for the door. For zones it seemed to work the same way, though I have only tested it through kunark at this point. I suspect this won't work for the PoP flags and so forth, but maybe it will.

I don't really know what I'm doing, but I've found so many posts like this that were helpful to me so far that I figured I'd take the time to share.

What sorv suggested is probably better, but I don't know enough to write a SQL.
Reply With Quote
Reply

Thread Tools
Display Modes

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 05:44 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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3