عاوز حل فى نقل مكان ال NPC
صور لتوضيح
ده مكان ال NPC الاصلى
الرابط مخفي
تسجيل الدخول
او
تسجيل
!!
الرابط مخفي
تسجيل الدخول
او
تسجيل
!!
و المكان الجديد
الرابط مخفي
تسجيل الدخول
او
تسجيل
!!
الرابط مخفي
تسجيل الدخول
او
تسجيل
!!
و زى ما فى الصور بقاء عندى 2 NPC المنقول و ال مش منقول عاوز حل و انا مستخدم الكورى ده
PHP:
SE [SRO_VT_SHARD]
----------------------------Made By [Dev]LegendKnight----------------------------
DECLARE @LEGENDKNIGHT1 VARCHAR(max)
DECLARE @CHARNAME VARCHAR(max)
SET @LEGENDKNIGHT1 = 'NPC_LEGENDKNIGHT09' ----- Your Npc Name
SET @CHARNAME = '1111' ----- Charactar name [ where you Want to set npc ]
Declare @LK1 int SET @LK1 = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @LEGENDKNIGHT1)
Declare @LK2 int SET @LK2 = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = @LK1)
Declare @LK3 int SET @LK3 = (SELECT dwNestID FROM Tab_RefNest WHERE dwTacticsID = @LK2)
declare @dwHiveID int = (select dwHiveID from Tab_RefNest where dwnestid = @lk3 and dwtacticsid = @lk2 )
Declare @LKpos1 int SET @LKpos1 = (SELECT latestregion FROM _char WHERE charname16 = @CHARNAME)
Declare @LKpos2 int SET @LKpos2 = (SELECT posx FROM _char WHERE charname16 = @CHARNAME)
Declare @LKpos3 int SET @LKpos3 = (SELECT posy FROM _char WHERE charname16 = @CHARNAME)
Declare @LKpos4 int SET @LKpos4 = (SELECT posz FROM _char WHERE charname16 = @CHARNAME)
insert into Tab_RefNest ([dwHiveID],[dwTacticsID],[nRegionDBID],[fLocalPosX],[fLocalPosY],[fLocalPosZ],[wInitialDir],[nRadius],[nGenerateRadius],[nChampionGenPercentage],[dwDelayTimeMin],[dwDelayTimeMax],[dwMaxTotalCount],[btFlag],[btRespawn],[btType])
values (@dwHiveID,@LK2,@lkpos1,@lkpos2,@lkpos3,@lkpos4,0,0,0,0,0,0,1,0,1,0)
