| Revog16 |
24-08-2013 02:55 AM |
دلوقتي ممكن تغير مكان الــ Npc
دلوقتي ممكن تغير مكان الــ Npc بسهوله جداااااااااااااااااااااااااااااااااا
ملحوظه الكوري دي بمجهودي ويايت اللي هينقلها يذكر الأسم :)
كود بلغة HTML:
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'
---------------------------------------------------------------------------------------
|
