Change NPC Place

[[KoTa]]

لما بنقل الnpc بى كيوري بتتنقل وتمام بس المشكله مبتتنقلش فى المكان الى انا عوزه بتتنقل مكان نزوال البلير فى نص المدينه لو حد يعرف السبب يقلى علاشان انا اتبضنت :irvine::surprise:


ودى الكيوري الى انا بستخدمها USE SRO_VT_SHARD
DECLARE @RefID int,
@Cord_X int,
@Cord_Y int,
@Cord_Z int,
@Region int

SELECT @Cord_X = PosX,
@Cord_Y = PosY,
@Cord_Z = PosZ,
@Region = LatestRegion

FROM _Char WHERE CharName16 = 'xExorcist'

SELECT @RefID = R.dwTacticsID
FROM Tab_RefTactics R
JOIN _RefObjCommon O
ON O.ID = R.dwObjID
WHERE O.CodeName128 LIKE 'NPC_CODE_HERE'

UPDATE TAB_RefNest
SET fLocalPosX = @CORD_X,
fLocalPosY = @CORD_Y,
fLocalPosZ = @CORD_Z,
nRegionDBID = @Region
WHERE dwTacticsID = @RefID

[محمد منتصر]

أستخدم الكويري دي USE [SRO_VT_SHARD]
----------------------------Made By [GM]T0P----------------------------
DECLARE @KINGEDITOR1 VARCHAR (129)
DECLARE @CHARNAME VARCHAR (64)

SET @KINGEDITOR1 = 'SN_NPC_NEW_QUEST_[GM]T0P' ----- Your Npc Name
SET @CHARNAME = '[GM]T0P' ----- Charactar name [ where you Want to set npc ]

Declare @AS1 int SET @AS1 = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @KINGEDITOR1)
Declare @AS2 int SET @AS2 = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = @AS1)
Declare @AS3 int SET @AS3 = (SELECT dwNestID FROM Tab_RefNest WHERE dwTacticsID = @AS2)

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 Tab_RefNest
SET nregiondbid = @ASpos1,
flocalposx = @ASpos2,
flocalposy = @ASpos3,
flocalposz = @ASpos4
WHERE dwnestid = @AS3 and dwtacticsid = @AS2
:cool:

[[KoTa]]

نفس المشكله

http://i.epvpimg.com/Bebeb.jpg (http://epvpimg.com/Bebeb)

[[KoTa]]

شكراا على كل واحد رد عليا انا حلاتها خلاص من غير كيوري :mf_w00t1:

##

[Dev.Ri3o]

##