H I T L E R
27-03-2019, 10:39 PM
انا واحد من ال كانو بيدورو علي الQuery ده بص ملقتش فايده روحت عملت واحد
فا انا قولت اخلي غيري يستفاد منو بالمره
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
PRINT ''
PRINT 'Edit in client too @ server_dep\silkroad\textdata\teleportbuilding'
PRINT ''
متنساش تعدل غلي الكلينت
teleportbuilding.txt
بالتوفيق
فا انا قولت اخلي غيري يستفاد منو بالمره
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
PRINT ''
PRINT 'Edit in client too @ server_dep\silkroad\textdata\teleportbuilding'
PRINT ''
متنساش تعدل غلي الكلينت
teleportbuilding.txt
بالتوفيق