(DNS) Duplicate Npc Spawn

[egsro]

• well i got this idea when a friend asked me to help him to add Arabia npc's and i was too lazy to re-create the hole npc's from scratch . so i tried this method (duplicating npc spawn means the same npc with 2x spawn at different places) and it worked just fine

• there was no problem while buying from or selling to the duplicated npc

• i made it into tool to make it easier for noobs

IT WILL ONLY LOAD THE SPAWNED NPC CODENAMES MEANS THAT YOU CANT DUPLICATED UnSpawned NPC !

Download
Duplicate NPC spawn.zip

[MentaL]

[Avira]

Nice Good Released Bro +1

[hhhhhhhh]

thnx dude

[minhkienxh]

good.Thanks

[Kira]

Nice Job +1

[LogiN]

FOR ME!! MY FRIEND!

[DieEyes]

Good work , Thanks dude keep sharing.

[shmantr2018]

nice Jop but i wanna know i can add new npc to my Server or Change Area of npc only ?

and if i can add new npc by This Program name This npc TrySro how i can Do It

[bdeniz]

you doesnt have to use program.


USE [SRO_VT_SHARD]
update Tab_RefNest set
nRegionDBID=26737 ,
fLocalPosX=705 ,
fLocalPosY=272.922821 ,
fLocalPosZ=1466

WHERE dwTacticsID in (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID in
(SELECT ID FROM _RefObjCommon WHERE Codename128 like '%NPC_BERKAY%'))

look chars latestregion,X,Y, Z and change values in query.

but it is not duplicates. only changes the npc's location.

you can copy the line from tab_Refnest and duplicate it.

[romio10]

nice jop

[egsro]

you doesnt have to use program.


USE [SRO_VT_SHARD]
update Tab_RefNest set
nRegionDBID=26737 ,
fLocalPosX=705 ,
fLocalPosY=272.922821 ,
fLocalPosZ=1466

WHERE dwTacticsID in (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID in
(SELECT ID FROM _RefObjCommon WHERE Codename128 like '%NPC_BERKAY%'))

look chars latestregion,X,Y, Z and change values in query.

but it is not duplicates. only changes the npc's location.

you can copy the line from tab_Refnest and duplicate it.

i said it 100000000 time before

this tool will spawn 2 or 3 x of 56679797x from the same npc in 100000000 different places at the same time !
and my tool will save much much much much time from doing it like you wrote up there ;)

[xxNukertube]

Epic ??

LOL
kkkkkkkkkkkkkkkkkk

See This

Old

My Query

@egsro,DECLARE @GAMEWORDID INT = 1 its is for Tab_RefHive
and not need

your tool can use only 1 time for 1 npc

@xxNukertube
DECLARE @GAMEWORDID INT = 1 in my tool disabled (automatically gets gameworld)
its totally miss xD
main = much more optimized than yours
how ever good work ;)

USE [SRO_VT_SHARD]
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[_AddNewSpotForNpcOrMob] 
--------------------------
@CHARNAME    VARCHAR(32),
@NPCNAME    VARCHAR(64),
@NPCRotação    VARCHAR(64)
--------------------------
AS
BEGIN
    ----------------------
DECLARE    @GetTACTICSID            INT            =    (SELECT TOP 1[dwTacticsID]FROM[dbo].[Tab_RefTactics]WHERE[dwObjID]=(SELECT[ID]FROM[dbo].[_RefObjCommon]WHERE[CodeName128]=@NPCNAME))
DECLARE    @Rotação                INT            =    (SELECT TOP 1[wInitialDir]FROM[dbo].[Tab_RefNest]WHERE[dwTacticsID]=(SELECT TOP 1[dwTacticsID]FROM[dbo].[Tab_RefTactics]WHERE[dwObjID]=(SELECT[ID]FROM[dbo].[_RefObjCommon]WHERE[CodeName128]=@NPCRotação)))
DECLARE    @NESTID                    INT            =    (SELECT MAX ([dwNestID])FROM[dbo].[Tab_RefNest])+1
DECLARE    @HIVEID                    INT            =    (SELECT TOP 1[dwHiveID]FROM[dbo].[Tab_RefNest]WHERE[dwTacticsID]=@GetTACTICSID)
DECLARE    @TACTICSID                INT            =    (@GetTACTICSID)
DECLARE    @REGION                    VARCHAR(30)    =    (SELECT[LatestRegion]FROM[dbo].[_Char]WHERE[CharName16]=@CHARNAME)
DECLARE    @POSX                    VARCHAR(30)    =    (SELECT[POSX]FROM[dbo].[_Char]WHERE[CharName16]=@CHARNAME)
DECLARE    @POSY                    VARCHAR(30)    =    (SELECT[POSY]FROM[dbo].[_Char]WHERE[CharName16]=@CHARNAME)
DECLARE    @POSZ                    VARCHAR(30)    =    (SELECT[POSZ]FROM[dbo].[_Char]WHERE[CharName16]=@CHARNAME)
DECLARE    @wInitialDir            INT            =    (@Rotação)
DECLARE    @nRadius                INT            =    (SELECT TOP 1[nRadius]FROM[dbo].[Tab_RefNest]WHERE[dwTacticsID]=@GetTACTICSID)
DECLARE    @nGenerateRadius        INT            =    (SELECT TOP 1[nGenerateRadius]FROM[dbo].[Tab_RefNest]WHERE[dwTacticsID]=@GetTACTICSID)
DECLARE    @nChampionGenPercentage    INT            =    (SELECT TOP 1[nChampionGenPercentage]FROM[dbo].[Tab_RefNest]WHERE[dwTacticsID]=@GetTACTICSID)
DECLARE    @dwDelayTimeMin            INT            =    (SELECT TOP 1[dwDelayTimeMin]FROM[dbo].[Tab_RefNest]WHERE[dwTacticsID]=@GetTACTICSID)
DECLARE    @dwDelayTimeMax            INT            =    (SELECT TOP 1[dwDelayTimeMax]FROM[dbo].[Tab_RefNest]WHERE[dwTacticsID]=@GetTACTICSID)
DECLARE    @dwMaxTotalCount        INT            =    (SELECT TOP 1[dwMaxTotalCount]FROM[dbo].[Tab_RefNest]WHERE[dwTacticsID]=@GetTACTICSID)
DECLARE    @btFlag                    INT            =    (SELECT TOP 1[btFlag]FROM[dbo].[Tab_RefNest]WHERE[dwTacticsID]=@GetTACTICSID)
DECLARE    @btRespawn                INT            =    (SELECT TOP 1[btRespawn]FROM[dbo].[Tab_RefNest]WHERE[dwTacticsID]=@GetTACTICSID)
DECLARE    @btType                    INT            =    (SELECT TOP 1[btType]FROM[dbo].[Tab_RefNest]WHERE[dwTacticsID]=@GetTACTICSID)
/**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**/
SET IDENTITY_INSERT Tab_RefNest ON 
INSERT    INTO[dbo].[Tab_RefNest]
([dwNestID],[dwHiveID],[dwTacticsID],[nRegionDBID],[fLocalPosX],[fLocalPosY],[fLocalPosZ],[wInitialDir],[nRadius],[nGenerateRadius],[nChampionGenPercentage],[dwDelayTimeMin],[dwDelayTimeMax],[dwMaxTotalCount],[btFlag],[btRespawn],[btType])
VALUES
(@NESTID,@HIVEID,@TACTICSID,@REGION,@POSX,@POSY,@POSZ,@Rotação,@nRadius,@nGenerateRadius,@nChampionGenPercentage,@dwDelayTimeMin,@dwDelayTimeMax,@dwMaxTotalCount,@btFlag,@btRespawn,@btType)
SET IDENTITY_INSERT Tab_RefNest OFF
PRINT 'EgSRO Noob'
END
GO 

••••• EXEC

USE [SRO_VT_SHARD]
DECLARE    @CHARNAME    VARCHAR(32)='dinei'--CharName
DECLARE    @NPCNAME    VARCHAR(64)='NPC_SD_M_AREA_SMITH'--NPC or Mob Name...
DECLARE    @NPCRotação    VARCHAR(64)='NPC_CH_ACCESSORY'--NPC for [wInitialDir] Base
------------------------------------------------------------------------------
EXEC [dbo].[_AddNewSpotForNpcOrMob]@CHARNAME,@NPCNAME,@NPCRotação 

For NPC and Mob

[egsro]

@xxNukertube
DECLARE @GAMEWORDID INT = 1 in my tool disabled (automatically gets gameworld)
its totally miss xD
main = much more optimized than yours
how ever good work ;)

[egsro]

71% yes
i wont stop those epic tools :D

[Crue]

Thank's egsro