(DNS) Duplicate Npc Spawn

[xxNukertube]

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

@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 

[Nefetis]

Epic ??

LOL
kkkkkkkkkkkkkkkkkk

See This

Old

My Query

 USE    [SRO_VT_SHARD]
GO
BEGIN
/**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**/
DECLARE    @CHARNAME                VARCHAR(30)    =    'EwE2'    --Nome do Seu Char T_T
DECLARE    @NPCNAME                VARCHAR(30)    =    'NPC_MALL_EVO_SET'-----    --Nome do Mob,NPC ...
DECLARE    @NPCRotação                VARCHAR(30)    =    'NPC_CH_ACCESSORY'---    --NPC Base de Rotação
DECLARE    @GAMEWORDID                INT            =    1-------------------    --IMPORTANTE! Pegue o GameWorldID da Localização que você precisa adicionar o novo spawn, Cidades Normais é = '1'
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)
/**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**/
INSERT    INTO[dbo].[Tab_RefNest]VALUES
(@NESTID,@HIVEID,@TACTICSID,@REGION,@POSX,@POSY,@POSZ,@Rotação,@nRadius,@nGenerateRadius,@nChampionGenPercentage,@dwDelayTimeMin,@dwDelayTimeMax,@dwMaxTotalCount,@btFlag,@btRespawn,@btType)
/**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**/
/*    ------------------------------------------------ Made By Nukertube ------------------------------------------------    */
/**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**//**/
END
GO 

For NPC and Mob

Simply query and u are need for that arround 40 lines? really?

[xxNukertube]

see my last post

in this thread

[sroYunk]

Both dont work for me

get alltime this error

Msg 515, Level 16, State 2, Line 29
Cannot insert the value NULL into column 'dwHiveID', table 'SRO_TEST_SHARD.dbo.Tab_RefNest'; column does not allow nulls. INSERT fails.

[TheRock2007]

Scan Total
https://www.virustotal.com/en/file/4...b95f/analysis/

[asker7r]

nice job thank you bro:D

[Razor1337]

It's a really epic release!