[HIDE]
[/HIDE]
Kod:
Use SRO_VT_SHARD
declare @minLevel int = 1 -- Minimum mob level.
declare @MaxLevel int = 2 -- Maximum mob level.
declare @MaxSpawnCount int = 1 -- Spawn rate (Max. 10 yapmanız önerilir.)
update Tab_RefNest
set dwMaxTotalCount = @MaxSpawnCount
from Tab_RefNest as A
inner join Tab_RefTactics as B
on A.dwTacticsID = B.dwTacticsID
inner join _RefObjCommon as C
on B.dwObjID = C.ID
inner join _RefObjChar as D
on C.Link = D.ID
where D.Lvl between @minLevel and @MaxLevel and CodeName128 like 'MOB%' and Rarity = 0 and dwMaxTotalCount > 0
