vSRO Mob Spawn Anlık Yeniden Doğma Bölgeye Göre

USE SRO_VT_SHARD

declare @minLv int = 110

declare @MaxLv int = 110

declare @MaxSpawn int = 4 -- 7 üstünde yapmayın

declare @respawnTimeMin int = 0 --  Saniye

declare @respawnTimeMax int = 1 -- Saniye

declare @nMRadius int = 20    --Mobun Spawn olağı yarı çap

declare @nMGenerateRadius int = 40   -- Mob spawn olduktan sonra gezeceği yarı çap

DECLARE @RegionName varchar(128) = 'KingsValley' -- _RefRegion >>> 'ContinentName' sütunundaki bölgenin Adı

--****************** BURDAN AŞAĞI DOKUNMA ********************************* BURDAN AŞAĞI DOKUNMA ********************************************************

BEGIN
       --select D.*

       update D set dwDelayTimeMin = @respawnTimeMin, dwDelayTimeMax = @respawnTimeMax, dwMaxTotalCount = @MaxSpawn, nRadius = @nMRadius, nGenerateRadius = @nMGenerateRadius

       from _RefObjCommon as A
       inner join _RefObjChar as B on A.Link = B.ID and A.CodeName128 like 'MOB%' and A.Rarity = 0 and B.Lvl between @minLv and @MaxLv
       inner join Tab_RefTactics as C on C.dwObjID = A.ID
       inner join Tab_RefNest as D on D.dwTacticsID = C.dwTacticsID and D.dwMaxTotalCount > 0 and D.dwDelayTimeMin >= 0 and D.nRadius > 0 and D.nGenerateRadius > 0
       and D.dwTacticsID in (Select dwTacticsID FROM Tab_RefNest Where nRegionDBID in (select wRegionID From _RefRegion Where ContinentName in ( @RegionName )))

END

--****************** BURDAN AŞAĞI DOKUNMA ********************************* BURDAN AŞAĞI DOKUNMA ********************************************************