[Tutorial] GM buff on Relog and Nation War (disable) buff

[monstrebel]

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

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

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

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

 

[mmorpg1]

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

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

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

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

how about other buff and where ican find the code for each buff