Revive Character to Position

You will need to obtain the coordinates for the location where you want to send the character after reviving. To do that, move your character to the desired location, then use the following query to get the exact coordinates.

SELECT WorldID, LatestRegion, PosX, PosY, PosZ
FROM SRO_VT_SHARD.._Char
WHERE CharName16 = 'Basic character name'

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

SELECT CharID FROM _OnlinePlayers WHERE CharName16 = 'Target character name'

Stored Procedure: _Char_ReviveAtPosition

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 revive a specific character and send it to Donwhang South Gate.

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

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

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

Cookies

Revive Character to Position