DECLARE @MonsterID INT
DECLARE @Monster varchar(129)
DECLARE @Rate INT
SET @Rate=3 ( add the spawn rate you want )
SET @Monster='MOB_CH_MANGNYANG'
SET @MonsterID = (select ID from _RefObjCommon where CodeName128=@Monster)
UPDATE Tab_RefNest
SET dwMaxTotalCount=dwMaxTotalCount*@Rate
FROM Tab_RefNest as n
INNER JOIN Tab_RefTactics AS t
ON n.dwTacticsID = t.dwTacticsID WHERE t.dwObjID=@MonsterID
|