Duplicate Npc Query

**DrugDealers** · 22-08-13

Code:

/* 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,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTimeMax,dwMaxTotalCount,btFlag,btRespawn,btType)
Values (@dwNestID,@dwHiveID,@dwTacticsID,@nRegionDBID,@fLocalPosX,@fLocalPosY,@fLocalPosZ,@wInitialDir,0,0,0,0,0,1,0,1,0)
print 'gratz you have copied NPC'
end

have fun guys