Add Item to Everyone (Character)

You will need to obtain the item ID that you want to add. 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'

Stored Procedure: _Command_AddItemToChestAllCharacters

Parameters:

• @RefItemID INT - Target item ID
• @Data INT - Amount to add. If 0 is used, a full stack will be added.
• @OptLevel TINYINT - The plus value of the item
• @TypeStr VARCHAR(64) - Reason for adding the item

Let us first test whether the command works by using the following code, which will add 10 Arena Coins to all character chests.

USE [vPlus]
GO
EXEC _Command_AddItemToChestAllCharacters 25834, 10, 0, 'Reward';