Add or delete an item into or out of someones inventory

[corri800]

Hello Ragezooners,

I have a quesiton again.

How am I able to add / delete an item into or out of someones inventory? I want to perform this in sql but I dont know what to do with the information in tItem table.

1. nItemKey - I dont know what this is or where to get it.
2. nStorageType - Dont know again.
3. nOwner - I thought this could be the char ID but it isnt.
4. nStorage - The same as in 3
5. nItemID - Item ID ;)
6. nFlags - Isnt needable I think.
7. dDate - Everyone knows this.

I hope someone of you is able to help me.

Best regards,
Corri

[MentaL]

[Canic]

1. nItemKey - Identify ID for the Item
2. nStorageType - Inventory/Reward Inventory/Storage
3. nOwner - nCharNo from tCharacter
4. nStorage - Slot of Inventory/Storage
5. nItemID - ID from ItemInfo
6. nFlags - Idk (Should be something like used or unused or whatever)
7. dDate - Date

[JustAnotherWnB]

Hello Ragezooners,

How am I able to add / delete an item into or out of someones inventory? I want to perform this in sql but I dont know what to do with the information in tItem table.

(I guess you are using odin files so idk if this works with older files)

Execute this query in w00_character

Deleting a Item:
Delete from dbo.tItem where nOwner = [Insert nOwner here, is nCharNo in tCharacters.] and nItemID = [Insert Item ID here (Check ItemInfo.shn)]

Example:
Delete from dbo.tItem where nOwner = 70 and nItemID = 0

This will delete the item Leather Boots from the inventory of user 70

Inserting them:
I think pretty much the same just with Insert instead of Delete. Maybe I am wrong try it o:

[corri800]

Thank you for your fast replies, but how do I get this Identify ID ?

[Delius]

Iteminfo

[corri800]

In ItemInfo is no "Identify ID" there is just the normal Item ID.

[NextIdea]

@Delius

1. nItemKey - Identify ID for the Item
...

corri800 means that.

@corri800
You don't need it. It's just a unique key in DB to prevent duplicate rows.

[corri800]

@NextIdea Thank you :)

Can you please help me with another problem so I dont have to open another thread?

Everytime I want to port from Elderine to Roumen I get a server disconnect.
With portscrolls or portals its always the same but you can port to Roumen from any other place without any problems.