[Little-Release] GBR Security

[[ADM]Narcotic]

This function must have active GameLog-ActionLog and the Custom Commands system.

It is a very simple security, It detect if the character that attacks the boss 1-15 or 20-30 is level +31. That avoids the map bugging done by reviving 60+ characters in zone 30 in GBR.

You must modify the Damage Boss in ActionLog StoredProcedure section:

 Spoiler

---Damage to bosss

ELSE IF @ActionType = 173
BEGIN

---BANEO A PJS ILEGALES EN GBR 15 Y 30 ---
IF @3 IN (1855, 1853)
BEGIN
DECLARE @CharLevelGBR varchar(50) = (SELECT [Level] FROM PS_GameData.dbo.Chars WHERE CharName = @3)
DECLARE @IDGBR int = (SELECT UserUID FROM PS_GameData.dbo.Chars WHERE CharName = @3)
DECLARE @GBR varchar(50) = (SELECT UserID FROM PS_GameData.dbo.Chars WHERE CharName = @3)

IF @CharLevelGBR > 30 AND @3 IN (1855, 1853)
BEGIN
WAITFOR DELAY '00:00:03'
DECLARE @BossAtacadoGBR int = (SELECT TOP 1 MobID FROM PS_GameLog.dbo.Boss_Damage Where MobID = @3 and Text3 = @3 ORDER BY ActionTime)
IF @BossAtacadoGBR IS NULL
BEGIN
INSERT INTO PS_GameLog.dbo.Boss_Damage (MobID, MapID, ActionTime, ActionType, Text1, Text3, CharLevel) VALUES @3, @MapID, @ActionTime, @ActionType, @, @3, @CharLevelGBR)
DECLARE @ReTuRn_valuebannotice int
DECLARE @bossatacado varchar(max) = N'/nt ' + @ + ' fue atacado ilegalmente por ' + @3 + '. Recibe baneo.'

EXEC @ReTuRn_valuebannotice = [OMG_GameWEB].[dbo].[Command]
@serviceName = N'ps_game',
@cmmd = @bossatacado

UPDATE PS_UserData.dbo.Users_Master SET [Status] = -5 WHERE UserUID = @IDGBR

DECLARE @bossban varchar(max) = N'/kickun ' @GBR
DECLARE @ReTuRn_valueban int

EXEC @ReTuRn_valueban = [OMG_GameWEB].[dbo].[Command]
@serviceName = N'ps_game',
@cmmd = @bossban

END
END
END

I know that many people can make the code more efficient but it seems like a good start.

[beetols]

Originally Posted by [ADM]Narcotic

I know that many people can make the code more efficient but it seems like a good start.

I gave a look and there is a much easier way. one IF is enough and if the char is level 31+ and mobid is one of those you can directly kick it. I don't belive need to ban the account since he wont be able to log back to GRB map until next week.

IF @ActionType = 173 AND @Value3 IN (1855, 1853) AND @CharLevel > 30 AND @MapID = 50
BEGIN
DECLARE @Return varchar(max) = N'/kickuid ' STR(@useruid)
EXEC @Return = [OMG_GameWEB].[dbo].[Command]
@serviceName = N'ps_game',
@cmmd = @bossban
END

[mielnicky]

Hi, you can only revive like this with the Resurrection Rune of Target .. For that, just edit the level to 31 and characters under 30 will not be able to use it. Cheers

[Elemental Shock]

Thanks for the release, but anyway i highly recommend to instead edit Grb to fully avoid the 'Classic grb issues'.

Just open the portals for max level at svmap, this should prevent any kind of abuse.
Regards.

[XareL]

Originally Posted by Elemental Shock

Thanks for the release, but anyway i highly recommend to instead edit Grb to fully avoid the 'Classic grb issues'.

Just open the portals for max level at svmap, this should prevent any kind of abuse.
Regards.

This will not work.
Some players will go through the wall and cut other bosses when the cheat is used.