دلوقتي ممكن تغير مكان الــ Npc

[Revog16]

دلوقتي ممكن تغير مكان الــ Npc بسهوله جداااااااااااااااااااااااااااااااااا


ملحوظه الكوري دي بمجهودي ويايت اللي هينقلها يذكر الأسم :)

Declare @trcid as varchar (MAX)
Declare @NPC as varchar (200)
Declare @ref as varchar (250)
Declare @x as varchar (250)
Declare @y as varchar (250)
Declare @z as varchar (250)
Declare @char as varchar (MAX)

Set @char = 'Charname''      --- Char Name tsd2 ano 7ram 3lya ana :_
Set @NPC = 'NPC_CODE' -- NPC Code here 
-----------------------------------------------------------------------------------
Set @x = (Select PosX From _Char Where CharName16 = @char)
Set @y = (Select PosY From _Char Where CharName16 = @char)
Set @z = (Select PosZ From _Char Where CharName16 = @char)
set @trcid = (Select dwTacticsID from Tab_RefTactics where dwObjID = (Select ID from _RefObjCommon where CodeName128 = @NPC ))
UPDATE Tab_RefNest set fLocalPosX = @x , fLocalPosY = @y , fLocalPosZ = @z where dwTacticsID = @trcid

Print 'Query Made by alaa2k'
print 'Grats Npc has moved Succesfull'
---------------------------------------------------------------------------------------