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