[merazz012]

المشاركة الأصلية كتبت بواسطة Mr.Rover عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

أو تستخدم الكويرى دى

USE [SRO_VT_SHARD]---By Mr.Rover---DECLARE @ROVER1 VARCHAR (129)DECLARE @CHARNAME VARCHAR (64)SET @ROVER1 = 'NPC_CODE' ----- Your Npc NameSET @CHARNAME = 'Char_Name' ----- Charactar name [which is going to be the place of npc]
Declare @AS1 int SET @AS1 = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @ROVER1)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_RefNestSET nregiondbid = @ASpos1,flocalposx = @ASpos2,flocalposy = @ASpos3,flocalposz = @ASpos4WHERE dwnestid = @AS3 and dwtacticsid = @AS2

كويري فيه اخطاء كتير