USE SRO_VT_SHARD
/*
This Query has been written by Senua for
Linkleri görebilmek için Turkmmo Forumuna
ÜYE olmanız gerekmektedir.
members
*/
--+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++--
DECLARE @Npc_Code VARCHAR(64)
DECLARE @CharName VARCHAR(64)
DECLARE @fLocalPosX REAL
DECLARE @fLocalPosY REAL
DECLARE @fLocalPosZ REAL
DECLARE @nRegionDBID REAL
DECLARE @WInitialDir REAL
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@--
SET @CharName='KARAKTER_ISMI_BURAYA_YAZILMALI'
SET @Npc_Code='NPC_KODU_BURAYA_YAZILMALI'
SET @WInitialDir=HESAPLANAN_wInitialDir_DEGERI_BURAYA_YAZILMALI
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@--
SET @fLocalPosX= (SELECT PosX FROM _Char WHERE CharName16=@CharName)
SET @fLocalPosY= (SELECT PosY FROM _Char WHERE CharName16=@CharName)
SET @fLocalPosZ= (SELECT PosZ FROM _Char WHERE CharName16=@CharName)
SET @nRegionDBID= (SELECT LatestRegion FROM _Char WHERE CharName16=@CharName)
-----------------------------------------------------------------------
UPDATE N1 SET
N1.nRegionDBID=@nRegionDBID ,
N1.fLocalPosX=@fLocalPosX ,
N1.fLocalPosY=@fLocalPosY ,
N1.fLocalPosZ=@fLocalPosZ ,
N1.wInitialDir=@WInitialDir
FROM _RefObjCommon AS M1
INNER JOIN Tab_RefTactics AS T1 ON M1.ID=T1.dwObjID
LEFT JOIN Tab_RefNest AS N1 ON T1.dwTacticsID=N1.dwTacticsID
WHERE M1.CodeName128=@Npc_Code
-----------------------------------------------------------------------
SELECT
M1.Service NPCService,
M1.CodeName128 NPCCodeName,
N1.nRegionDBID NPCRegion,
N1.fLocalPosX NPC_x_Coordinate,
N1.fLocalPosY NPC_y_Coordinate,
N1.fLocalPosZ NPC_z_Coordinate,
N1.wInitialDir NPC_wInıtialDir
FROM _RefObjCommon AS M1
INNER JOIN Tab_RefTactics AS T1 ON M1.ID=T1.dwObjID
LEFT JOIN Tab_RefNest AS N1 ON T1.dwTacticsID=N1.dwTacticsID
WHERE M1.CodeName128=@Npc_Code
--+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++--