Paylaşım SRO NPC Yer Değiştirmek | Taşımak

[gamepvps.com]

Beğenip Yorum Yaparak Konu Detaylarını Görebilirsiniz

[replyandthanks]

Administrator
Developer
Yönetici
Administrator
Katılım15 Temmuz 2019
Mesajlar7,211
Puanları9,044
KonumFrance
Web sitesimars-edit.com
USE SRO_VT_SHARD
GO
DECLARE @CharName VARCHAR (30)
DECLARE @NPCCode VARCHAR (MAX)
DECLARE @ID INT
DECLARE @TACTICSID INT
--------------------------------------------------------------------------------------------------|
SET @CharName = 'MARS'
SET @NPCCode = 'NPC_CH_TICKET'
--------------------------------------------------------------------------------------------------|
DECLARE @RegionID INT SET @RegionID = (SELECT LatestRegion FROM _Char WHERE CharName16 = @CharName)
DECLARE @PosX INT SET @PosX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CharName)
DECLARE @PosY INT SET @PosY = (SELECT (POSY) FROM _Char WHERE CharName16 = @CharName)
DECLARE @PosZ INT SET @PosZ = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CharName)

SET @ID = (SELECT ID FROM _RefObjCommon WHERE CodeName128=@NPCCode)
SET @TACTICSID =(SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID=@ID)

UPDATE Tab_RefNest SET fLocalPosX= @PosX,fLocalPosY= @PosY,fLocalPosZ= @PosZ,nRegionDBID= @RegionID WHERE dwTacticsID=@TACTICSID

[/replyandthanks]