(DNS) Duplicate Npc Spawn

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

Quote:

---

Originally Posted by 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 ;)

---

PHP Code:

---

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

PHP Code:

---

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 


---

Quote:

---

Originally Posted by xxNukertube

Epic ??

LOL
kkkkkkkkkkkkkkkkkk

See This

Old

My Query

PHP Code:

---

 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?

see my last post

in this thread

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.

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

nice job thank you bro:D

It's a really epic release!