Junior Spellweaver
- Joined
- Jul 15, 2020
- Messages
- 100
- Reaction score
- 15
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
Find this
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
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 = @[I][B][URL="http://forum.ragezone.com/members/2000206772.html"]World[/URL][/B][/I]AuthKey
WHERE UserNum = @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]NUM
IF @@ROWCOUNT = 0
BEGIN
INSERT INTO cabal_last_login_character
(UserNum, LastLoginChar, CharSlotOrder, WorldAuthKey)
VALUES
@[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]NUM, 0, 0, @[I][B][URL="http://forum.ragezone.com/members/2000206772.html"]World[/URL][/B][/I]AuthKey)
END
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