Remove Item by Unique ID (Character)

You will need to obtain the item ID that you want to remove. You can use the following query to get the item ID from the database.

SELECT ID FROM SRO_VT_SHARD.._RefObjCommon WHERE CodeName128 = 'ITEM_ETC_ARENA_COIN'

You will also need the item's unique ID. This is the ID from the _CharChest table, so you will need to obtain it directly from that table.

Stored Procedure: _Char_RemoveChestItemByUniqueID

Parameters:

• @CharID INT - Target character ID
• @UniqueID INT - Target item unique ID

Let us first test whether the command works by using the following code, which will remove a specific item by its unique ID from the character chest.

USE [vPlus]
GO
DECLARE @CharID INT = (SELECT CharID FROM _OnlinePlayers WHERE CharName16 = 'character_name')
EXEC _Char_RemoveChestItemByUniqueID @CharID, @TheUniqueID;

For real usage, use @CharID directly from your calling procedure.

EXEC _Char_RemoveChestItemByUniqueID @CharID, @TheUniqueID;