Drop Item at Position

You will need to obtain the coordinates where you want to drop the item. To do that, move your character to the desired location, then use the following query to retrieve the exact coordinates.

SELECT WorldID, LatestRegion, PosX, PosY, PosZ
FROM SRO_VT_SHARD.._Char
WHERE CharName16 = 'character_name'

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

Parameters:

• @RefItemID INT - Target item ID
• @WorldID SMALLINT - Target world ID
• @RegionID SMALLINT - Target region ID
• @PosX INT - Position X
• @PosY INT - Position Y
• @PosZ INT - Position Z
• @Data INT - Quantity

Let us first test whether the command works by using the following code, which will drop 100 Arena Coins in the Jangan town area.

USE [vPlus]
GO
EXEC _Command_DropItem 25834, 1, 25000, 1006, -32, 1147, 100;