Warp Character to Position

You will need to obtain the coordinates for the destination. 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 = 'base_character_name'

You will also need to obtain the character ID of the character you want to move. You can use the following query to get the character ID from the database.

SELECT CharID FROM _OnlinePlayers WHERE CharName16 = 'character_name'

Stored Procedure: _Char_WarpToPosition

Parameters:

@CharID INT - Target character ID
@WorldID SMALLINT - Destination world ID
@RegionID SMALLINT - Destination region ID
@PosX INT - Position X
@PosY INT - Position Y
@PosZ INT - Position Z

Let us first test whether the command works by using the following code, which will move a specific character to the Donwhang South Gate area.

USE [vPlus]
GO
DECLARE @CharID INT = (SELECT CharID FROM _OnlinePlayers WHERE CharName16 = 'character_name')
EXEC _Char_WarpToPosition @CharID, 1, 26009, 958, -112, 1398;

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

EXEC _Char_WarpToPosition @CharID, 1, 26009, 958, -112, 1398;

Cookies

Warp Character to Position