How to BAN IPs and accounts ?

[mmoobb]

In last days we got some problems with some crazy players ... we tryed different methods to ban IPs and / or Accounts but without success ...

Can any1 tell us how we can ban? ... because i never saw any1 asking this around ...

[MentaL]

[cypher]

I should have watched my mouth and not said/talked shit to DeadlyData telling him things like your are not welcome here because then I become the one who is truly not welcome here.

[mmoobb]

ok cyper ... i will wait your BUZZ on mess because i can't find it -.-" ...

i thought that there is a query for this ...

[cypher]

I should have watched my mouth and not said/talked shit to DeadlyData telling him things like your are not welcome here because then I become the one who is truly not welcome here.

[mmoobb]

Ok . We found out how to ban accounts ... but how we can ban IPs? ...

[Sk8TeR]

For ban account

with account db select
on query analizer

update cabal_auth_table
set Authtype = 2
where id = 'Account'

[cypher]

I should have watched my mouth and not said/talked shit to DeadlyData telling him things like your are not welcome here because then I become the one who is truly not welcome here.

[mmoobb]

Thanks for answers ... now another question >.<

How i can know the UserNum or account if i know the Character Name and CharIdx ?

[mirceagab]

I have the same problem

[[hidden]]

Thanks for answers ... now another question >.<

How i can know the UserNum or account if i know the Character Name and CharIdx ?

Query Analyzer :

determine character id number based on character name

use gamedb;
select characteridx, name from cabal_character_table where name = 'CHARACTER NAME'

determine account based on character id number

use account;
select usernum, id from cabal_auth_table where usernum = (CHARACTER ID NUMBER/8)

then ban the violator

use account;
update cabal_auth_table
set authtype = '2'
where usernum = (USER NUMBER HERE)