Hello,

I want to share one query for all of you. Was looking on ragezone and couldnt find the query to disable gm buff in Nation War. Original query was shared by W3rnis. I added another line to disable the buff in nation war.

GM buff used in this tutorial is for Blessing Lv.3

Code:

BEGIN IF ((@CH_LEV < 201) AND (@CH_WORLDIDX != 15 | 16)) BEGIN SET @GMBuff = 0xCE01000001000000FD4E3200BDD02C00 END IF ((@CH_LEV < 201) AND (@CH_WORLDIDX = 15 | 16)) BEGIN SET @GMBuff = 0x END END

Find this

Code:

UPDATE cabal_last_login_character SET worldAuthKey = @WorldAuthKey WHERE UserNum = @userNUM IF @@ROWCOUNT = 0 BEGIN INSERT INTO cabal_last_login_character (UserNum, LastLoginChar, CharSlotOrder, WorldAuthKey) VALUES @userNUM, 0, 0, @WorldAuthKey) END

inside dbo.cabal_get_character

and add the query above below it. Run query to save the stored procedure

Even the player received GM buff in Channel 1,2,3, once he joined war lobby or TG, the buff will be automatically removed.

Hope it helps
-M

+ Recent posts