This is a persistent chest system I have written that uses the MySQL database. Obviously it requires nwnx fully functioning.
This is NOT scripted for SQL lite, sorry.
Please read the read-me file for information on how the system works and how to set it up. The steps are very simple in general but of course that will vary on user experience. I have included contact information in the Read me file so feel free to contact me about anything related to this system whether it be questions, suggestions or bugs.
UPDATE:
a) I have fixed an issue where when the chest is auto-closed after 10 minutes of having been unlocked but the chest container screen remained opened. I now close the gui screen at the same time as when the chest is locked. Otherwise if a chest auto-closed but the container gui was still open and more items were added to it, the items added after the chest was already locked would not save (as the script would not run).
b) I've also updated the chest placeable to have 1 hp so that it can be interacted with and have an inventory.
Hope no one ran into this issue otherwise I believe the system is solid.
Make sure the chest you made is a container (check the box that it's a container under blue-print properties) otherwise it will be just a placeable hence why you may be seeing only the option to use/examine it.
Posted by pcentobie at 2010-08-24 20:28:13 Voted 8.00 on 08/24/10
I have been able to get everythign workign up to the point where the chest and key are spawned from the item I created that the NPC I created sold to me using the pc_buy conversation.
I was having a little trouble with the item I originally created so I just named it pc_chest_placer to get things working for now.
When I try to click on the chest I just get "use" and "examine" options. I try "use" and nothing seems to happen. It seems that at this point it is supposed to unlock the chest if I have the key. I did not see an uption for "unlock"
The key I have matches the chest like "Chest #1" "key #1".
I can see the entries created in the MySQL database so I know it is communicating with the database and no errors in the mysql.txt log in NWNX.
Any help is appreciated. Great work, I just need to get the last part working.
10 - A Masterpiece, Genuinely Groundbreaking 9 - Outstanding, a Must Have 8 - Excellent, Recommended to Anyone 7 - Very Good, Deserves a Look 6 - Good, Qualified Recommendation 5 - Fair, Solid yet Unremarkable 4 - Some Merit, Requires Improvements 3 - Poor Execution, Potential Unrealized 2 - Very Little Appeal 1 - Not Recommended to Anyone