[Release] Simple IP Ban

[WooAf]

Procedure structure for [WZ_ACCOUNT_LOGIN_EXEC]

-- check if ip banned
    declare @idccid int
    SELECT
        @idccid=cid
    FROM BannedIP 
    WHERE ip=@in_IP
    
    if (@@ROWCOUNT != 0) begin
        select
            3 as LoginResult,
            0 as CustomerID,
            998 as AccountStatus
        return
    end

BannedIP Table:

CREATE TABLE [dbo].[BannedIP](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [cid] [int] NOT NULL,
    [ip] [varchar](15) NOT NULL,
    [reason] [varchar](max) NOT NULL,
    [bannedby] [int] NOT NULL,
    [date] [datetime] NOT NULL
) ON [PRIMARY]

(You can edit the table how you want it)



You can also change the error message on the launcher for the grade 998



RSUpdate/Updater.cpp

case CLoginHelper::ANS_IPBANNED:
        loginErrMsg_ = "Your IP has been banned";
        break;

RSUpdate/WOLoginHelper.cpp

if(AccountStatus == 998) {
        loginAnswerCode = ANS_IPBANNED;
        return;
    }

[MentaL]

[JonnyTruant]

How do I ban players using the BannedIP table?

[WooAf]

How do I ban players using the BannedIP table?

Just add a query with the banned ip wanted

[JonnyTruant]

Just add a query with the banned ip wanted

Could you tell me an example please?

[WooAf]

Could you tell me an example please?

INSERT INTO BannedIP VALUES (1000000, '123.456.789.123', 'Hacking', 1000000, '2013-01-01 00:00:00')

[JonnyTruant]

INSERT INTO BannedIP VALUES (1000000, '123.456.789.123', 'Hacking', 1000000, '2013-01-01 00:00:00')

For some reason when I ban my IP I get "invalid username or password"

[WooAf]

For some reason when I ban my IP I get "invalid username or password"

Yep, you need to add a message on your launcher

Follow the step after :

You can also change the error message on the launcher for the grade 998

[JonnyTruant]

Yep, you need to add a message on your launcher

Follow the step after :

How so would it be?

[WooAf]

Just follow my guide

Sent from my Galaxy Nexus using Tapatalk 4 Beta

[MtHx62210]

very thanks for you Ipbanned

[JonnyTruant]

Well, I didn't understand your explanation "change message for grade 998"

[MtHx62210]

Hello I have a question here is Ipban walks very well but here is for example when I me banns and when I am at stake I owe disconnect me from the game it do not disconnect me directly have you a solution

Know how to expel you how a player who is at stake because for example I banns a player but if he does not disconnect completely from the game(set,play) this one can continue to play:s


A little better expressed sorry for my bad inglish

[eXtremousZ]

Hello I have a question here is Ipban walks very well but here is for example when I me banns and when I am at stake I owe disconnect me from the game it do not disconnect me directly have you a solution

Know how to expel you how a player who is at stake because for example I banns a player but if he does not disconnect completely from the game(set,play) this one can continue to play:s


A little better expressed sorry for my bad inglish

MtHx that can't be fixed. Say to them that they received Free GC and they have to restart their games. You can also kick players if you are Developer if you use the following command: "/kick", Just remember you can't kick players with space in their name. And if player is using different characters in name press Report button and copy the name press /kick namehere and you are done.
I am also playing in your server, good luck with it! :)

[WooAf]

Hello I have a question here is Ipban walks very well but here is for example when I me banns and when I am at stake I owe disconnect me from the game it do not disconnect me directly have you a solution

Know how to expel you how a player who is at stake because for example I banns a player but if he does not disconnect completely from the game(set,play) this one can continue to play:s


A little better expressed sorry for my bad inglish

You can simply hook a in game command and make it check if the account is ip banned..

Or you can just block the ip in your firewall..

Sent from my Google Nexus

[Syxn]

Thanks for sharing this :)