[Guide] How to get rid off certain ppl

You got some problems with hackers who hack from cafe ?
Some guys from certain country/city hack your server ?

If yes, this guide/release is for you ^^

First, few words of explanation


This script is working by disconnecting and deleteing accounts from
tables : MEMB_STAT, MEMB_INFO, VI_CURR_INFO, Character,
AccountCharacter by determined ip wich is set by admin.

So you see that some guys from country 'XxX' are hacking and you wish
them to get the hell out of your server. So you find hacker's account,
memb_stat table and look at his ip
then simply get two first values of his ip example : 66.666.666.666 [ bolded thing interests us ]. Then simply fill the script with them.
It's used to ban/delete whole country/city/cafe/provider.

Now i will give You the code and you just need to make it as a SQL Job
The code
Code:
UPDATE MEMB_STAT
SET MEMB_STAT.ConnectStat = 0
WHERE (MEMB_STAT.IP LIKE 'xxx.xxx.%')

DELETE Character
FROM Character JOIN VI_CURR_INFO ON Character.AccountID = VI_CURR_INFO.memb___id COLLATE latin1_general_ci_as
DELETE VI_CURR_INFO
FROM VI_CURR_INFO JOIN MEMB_INFO ON VI_CURR_INFO.memb___id = MEMB_INFO.memb___id COLLATE latin1_general_ci_as
DELETE MEMB_INFO
FROM MEMB_INFO JOIN AccountCharacter ON MEMB_INFO.memb___id = AccountCharacter.ID COLLATE latin1_general_ci_as
DELETE AccountCharacter
FROM AccountCharacter JOIN MEMB_STAT ON AccountCharacter.ID = MEMB_STAT.memb___id COLLATE latin1_general_ci_as
DELETE MEMB_STAT
WHERE (MEMB_STAT.IP LIKE 'xxx.xxx.%')
Replace x with numbers you got from ip.

Wish you all best.

I made this script cause friend's request.
Anyway i didn't searched if script like this exist.
But if it exists i hope some MOD will delete my thread.
If any of You made similar script or he just feel he own some credits in here, just pm me and i will post ur credits.

We are community/united no need of some damm conflicts cause of copyrights ...

Regards, thanks to UFO Mu owner for all inspirations and chellenges wich he come up with.

ANYWAY GUYS MAKE A BACKUP OF YOUR DATABASE BEFORE YOU USE ANY SQL SCRIPT