query how increase mob spanw here :D

Results 1 to 2 of 2
  1. #1
    Enthusiast feliped is offline
    MemberRank
    Jun 2012 Join Date
    36Posts

    cool query how increase mob spanw here :D

    UPDATE dbo.Tab_RefNest SET dwmaxtotalcount=1


    like!


  2. #2
    Apprentice N3vermore is offline
    MemberRank
    Feb 2013 Join Date
    12Posts

    Re: query how increase mob spanw here :D

    More like this....


    DECLARE @MonsterID INT
    DECLARE @Monster varchar(129)
    DECLARE @Rate INT
    SET @Rate=3
    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



Advertisement