I generated a corrupt item and I'd like to remove it from my inventory but every time I move my mouse over it the game closes. How can I delete the item from my inventory via the files? I've scanned every .shn file I can find to simply delete all the items in my character's inventory but I can't find an item list. If anyone can't point me in the right direction I'd appreciate it.
World00_Character/w00_Character - dbo.tItem
Appreciate the info but the item is located in my character storage, not on my character itself. I now know how to reference the item via the item ID#, thanks to you aqua. It gives me a direction to look. Now all I need is to know which dbo. file my character storage items are in and I can delete it. Thanks again.
tStorage
EDIT: My bad i just answered fast wasn't reading nor thinking about my answer. Easiest fix is to delete all items associated with your char.
Last edited by aqua512; 04-01-15 at 12:32 PM.
Under which sub headings? There are a lot of them and odb.tStorage could be anywhere.
- - - Updated - - -
If it's under W00_Character/Tables/ then I don't see it there.
- - - Updated - - -
Ya, I've looking for hours and I can't seem to find odb.tStorage.
- - - Updated - - -
And I'm to stupid to know how to run a simple search to find it... I would if I knew how. If I did this wouldn't have taken so long.
dbo.tItem.
Just look in the nItemID Column. I figure the storage columns define which storage the item is held in.
Not sure,
Well, if I delete all items associated with my character all it will do is delete all the SC style items I have. I've double checked all the nItemID#'s and the only items listed there are the SC style ones. I need to find a list of all the normal items my character has. Now I'm starting to wonder if they are stored locally in my Client file. Will keep working the problem until it's fixed. Still looking for all the advice, tips, and info anyone can give me.
- - - Updated - - -
Still can't delete item in character inventory. Still need help.
Wait is it in the character inventory or the storage? You keep saying both.
I assume it's in the storage. It's still in w00_tCharacter..tItem but when it's in storage the nOwnerNo is set to your accounts nEMID/nUserNo rather than nCharNo. I think that the nStorageType is set to 6 rather than 8 when the item is in storage. Instead of finding that particular item, it would be faster to just remove that item from every character/account with a query.
Change 250 with your bugged item's ItemID from ItemInfo.shnCode:DELETE FROM w00_tCharacter..tItem WHERE nItemID = '250';
i would suggest for easiest altering of the characters is to just setup the operation tool and use it.
I'm not saying both! Character Inventory is not the same as equipped to character. The item is in my character's inventory bags (the rows of boxes where items you pickup in the game go).
- - - Updated - - -
tItems list only special items and items equipped to your character. General character inventory items must be somewhere else.
- - - Updated - - -
I don't know how to set up the operation tool. I would if I did.
- - - Updated - - -
I don't know how to run a query. I would if I knew how. Sorry but I'm learning as fast as I can. Please teach me if you know how.
- - - Updated - - -
The item number (per ItemInfo.shn) is 63070 but when I look for it (via Find and Replace in SQL) it says that there is no such entry.
- - - Updated - - -
in the odb.tItem.
- - - Updated - - -
YAY! I did it. Thanks, William! You're awesome! I did have to change your code from DELETE FROM w00_tCharacter..tItem WHERE nItemID = '250'; to DELETE FROM W00_tCharacter..tItem WHERE nItemID = '250'; (It's a capital "W" not "w") but I did it and now all the items are gone! I will remember and us that code should I ever make that mistake again! Thanks a million, William!
- - - Updated - - -
Thanks again to everyone who contributed to the answer to this problem. I appreciate it and you've all helped me learn a lot. I will continue to learn as much as I can from this community.
Reply With Quote
