[HIDE]
USE SRO_VT_SHARD
declare @minLv int = 99
declare @MaxLv int = 100
declare @MaxSpawn int = 5 -- Maximum 6-7 yapmanız yeterli olacaktır
declare @respawnTimeMin int = 0 -- Saniye
declare @respawnTimeMax int = 0 -- Saniye
declare @nMRadius int = 15 --Mobun Spawn olağı yarı çap
declare @nMGenerateRadius int = 30 -- Mob spawn olduktan sonra gezeceği yarı çap
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
end
[/HIDE]
USE SRO_VT_SHARD
declare @minLv int = 99
declare @MaxLv int = 100
declare @MaxSpawn int = 5 -- Maximum 6-7 yapmanız yeterli olacaktır
declare @respawnTimeMin int = 0 -- Saniye
declare @respawnTimeMax int = 0 -- Saniye
declare @nMRadius int = 15 --Mobun Spawn olağı yarı çap
declare @nMGenerateRadius int = 30 -- Mob spawn olduktan sonra gezeceği yarı çap
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
end
[/HIDE]
