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.
|