Query to ban/kick a player

[wanqwer]

Hello guys!

I wanted to know if there is a db query that kicks, or even better - bans a player that is playing in the server? Not after a user quits game, but instant - when user is active.
I need a query and not a tool to do this, because I want to automate this process.

thanks in advance

 

[Dens666]

No, query like this does not exists. If u want insta-kick someone u need to do it using in game command /_kick characteridx.

 

[wanqwer]

That's really sad :/

 

[Lodelight]

This will ban, but won't kick. So you would have to kick then run this query.

USE Account
GO
UPDATE cabal_auth_table SET AuthType = '2' WHERE ID = 'username-here'

To unban, change the 2 to a 1.

 

[Dens666]

This will ban, but won't kick. So you would have to kick then run this query.

USE Account
GO
UPDATE cabal_auth_table SET AuthType = '2' WHERE ID = 'username-here'

To unban, change the 2 to a 1.

Not after a user quits game, but instant - when user is active.

Thats the problem.

 

[Lodelight]

Thats the problem.

I'm new to cabal in general, but there might be some ways to "beat around it". Has anyone tried seeing if u change the value of them being logged in when they are logged in to force them out? Or just an idea here, run a query to delete the char while user is in game not sure what type of issues this one would cause and i would only try char deletion on a test server first LOL.

 

[TriEdge]

you cant DC someone from DB. But you can DC someone with IRIS tool. But you need to rewrite it for ep8

 

[golddragooon]

There is trick to DC everyone from server without restarting channel and without beeing in game

 

[megingjard]

why not use firewall ? iptable kick them *** haha

 

[golddragooon]

why not use firewall ? iptable kick them *** haha

+1

 

[Ron]

Use a script to have your firewall temporarily block their IP for a few minutes, effectively kicking them from the sever.