الكويري هتسهل علينا حاجات كتير عشان لو هتعملها Manual هتكون الدنيا صعبه
طبعا الكويري من صنع اخويا محمود LegendKnight
PHP:
USE [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)
or
DECLARE @NPCNAME VARCHAR (max)
DECLARE @CHARNAME VARCHAR (64)
SET @NPCNAME = 'NPC_SD_ARENA_MANAGER' ----- Your Npc Name
SET @CHARNAME = 'test_hero' ----- Charactar name [ where you Want to set npc ]
declare @npcid int = (select id from _refobjcommon where codename128 = @NPCNAME )
DECLARE @TACTICSID INT SET @TACTICSID = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+10
INSERT INTO Tab_RefTactics VALUES
(@TACTICSID,@npcid,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,@NPCNAME)
BEGIN
DECLARE @HIVEID INT SET @HIVEID = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1
INSERT INTO Tab_RefHive VALUES
(@HIVEID,0,0,0,0,0,0,1,2,@NPCNAME)
END
BEGIN
DECLARE @REGION VARCHAR (30) SET @REGION = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSX VARCHAR (30) SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSY VARCHAR (30) SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSZ VARCHAR (30) SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @NESTID INT SET @NESTID = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1
INSERT INTO Tab_RefNest VALUES
(@NESTID,@HIVEID,@TACTICSID,@REGION,@POSX,@POSY,@POSZ,0,0,0,0,0,0,1,0,1,0)
ENDكل اللي هتعمله انك هتغير 1111 بأسم الشخصيه اللي انت عاور تجيب ال npc مكنها
و هتغير NPC_LEGENDKNIGHT09 بأسم الNpc بتاعك
و بعدها تعمل Restart للجيم و الف مبروك عليك
