عاوز كويري نقل NPC او نسخ NPC

[Tyko]

جربت الاتنين دول
بيقولى Succues بس مافيش اي حاجة بتحصل

USE [SRO_VT_SHARD]
----------------------------Made By AnTaKa----------------------------
DECLARE @KINGEDITOR1 VARCHAR (129)
DECLARE @CHARNAME VARCHAR (64)

SET @KINGEDITOR1 = 'NPC_D13_ITEMS' ----- Your Npc Name
SET @CHARNAME = '[GM]Tyko' ----- 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


------------------------------------------------------------

* this is query created by KingDollar not others , don't copy and post it under your name god see you xD */ Declare @CharName varchar(MAX) Declare @CodeName varchar(MAX) Declare @dwNestID int Declare @dwHiveID int Declare @dwTacticsID int Declare @nRegionDBID int Declare @fLocalPosX int Declare @fLocalPosY int Declare @fLocalPosZ int Declare @wInitialDir int set @CharName = (Select CharName16 From _Char Where CharName16 = 'KingDollar') -- Your Character Name set @CodeName = (Select ID From _RefObjCommon Where CodeName128 = 'NPC_CA_POTION') -- Your Npc Code Name set @dwNestID = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1 set @dwHiveID = '2' set @dwTacticsID = (Select dwTacticsID From Tab_RefTactics Where dwObjID = @CodeName) set @nRegionDBID = (Select LatestRegion From _Char Where CharName16 = @CharName) set @fLocalPosX = (Select PosX From _Char Where CharName16 = @CharName) set @fLocalPosY = (Select PosY From _Char Where CharName16 = @CharName) set @fLocalPosZ = (Select PosZ From _Char Where CharName16 = @CharName) set @wInitialDir = '-32587' if (@CharName is null) begin print 'please be sure from charname which you write because its back null no result so please be sure from it' end else if (@CodeName is null) begin print 'please be sure from codename which you write because its back null no result so please be sure from it' end else if (@CharName is not null) And (@CodeName is not null) begin insert into Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalP osX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGen erateRadius,nChampionGenPercentage,dwDelayTimeMin, dwDelayTimeMax,dwMaxTotalCount,btFlag,btRespawn,bt Type) Values (@dwNestID,@dwHiveID,@dwTacticsID,@nRegionDBID,@fL ocalPosX,@fLocalPosY,@fLocalPosZ,@wInitialDir,0,0, 0,0,0,1,0,1,0) print 'gratz you have copied NPC'