Spawn Monster

You will need to obtain the coordinates where you want to spawn the monster. 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 monster ID that you want to spawn. You can use the following query to get the monster ID from the database.

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

Stored Procedure: _Command_SpawnMonster

Parameters:

@RefMonsterID INT - Target monster ID
@WorldID SMALLINT - Destination world ID
@RegionID SMALLINT - Destination region ID
@PosX INT - Position X
@PosY INT - Position Y
@PosZ INT - Position Z
@Count INT - Number of monsters to spawn

Let us first test whether the command works by using the following code, which will spawn [Tiger Girl] 3 times outside Jangan South Gate.

USE [vPlus]
GO
DECLARE @RefMonsterID INT = (SELECT ID FROM SRO_VT_SHARD.._RefObjCommon WHERE CodeName128 = 'MOB_CH_TIGERWOMAN')
EXEC _Command_SpawnMonster @RefMonsterID, 1, 24744, 1011, -12, 1257, 3;

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

EXEC _Command_SpawnMonster @RefMonsterID, 1, 24744, 1011, -12, 1257, 3;

Cookies