[HIDE]
[/HIDE]
SQL:
USE [SRO_VT_SHARD]
DECLARE @silkroadpvp VARCHAR (129)
DECLARE @CHARNAME VARCHAR (64)
SET @silkroadpvp = 'STORE_TQ_SNAKEGATE' ----- Hangi NPC yerini değiştiriyoruz
SET @CHARNAME = '[GM]PvP' ----- Charactar name [ Hangi Chardan koordinatları alalım ]
Declare @AS1 int SET @AS1 = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @silkroadpvp)
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
PRINT ''
PRINT 'Lütfen clientte düzenleyiz> @ server_dep\silkroad\textdata\teleportbuilding'
PRINT ''
