[H I T L E R]

USE [SRO_VT_SHARD]
----Query Created By Hitler----
DECLARE @HITLER2 VARCHAR (129)
DECLARE @CHARNAME VARCHAR (64)

SET @HITLER2 = 'STORE_TQ_SNAKEGATE' ----- Your Npc Name
SET @CHARNAME = '[GM]Hitler' ----- Charactar name [ where you Want to set npc ]

Declare @AS1 int SET @AS1 = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @HITLER2)

Declare @ASpos1 int SET @ASpos1 = (SELECT latestregion FROM _char WHERE charname16 = @CHARNAME)
Declare @ASpos2 int SET @ASpos2 = (SELECT posx FROM _char WHERE charname16 = @CHARNAME)
Declare @ASpos3 int SET @ASpos3 = (SELECT posy FROM _char WHERE charname16 = @CHARNAME)
Declare @ASpos4 int SET @ASpos4 = (SELECT posz FROM _char WHERE charname16 = @CHARNAME)


UPDATE _RefObjCommon
SET RegionID = @ASpos1,
OffsetX = @ASpos2,
OffsetY = @ASpos3,
OffsetZ = @ASpos4
WHERE ID = @as1

عيش