[GUIDE]DK Administration for Dummies

How to install:

1: Open up your query analyser.

2: Paste this query, but don't execute yet.

Code:
USE master
CREATE DATABASE ban_info ON PRIMARY
(
NAME = baninfodata,
FILENAME = 'C:\DATABASES\baninfodata.mdf',
SIZE = 20MB,
MAXSIZE = UNLIMITED
)
LOG ON
(
NAME = baninfolog,
FILENAME = 'C:\DATABASES\baninfolog.ldf',
SIZE = 5MB,
MAXSIZE = UNLIMITED
)
GO

CREATE TABLE ban_info.dbo.ban_log
(
IP varchar(50) NOT NULL,
ip2long varchar(50),
Reason varchar(50),
ReasonInfo varchar(50),
DateBanned varchar(50),
Action_taken varchar(50),
PRIMARY KEY (IP)
)

GO
USE ban_info;

GO
/*
Name: Anti-GM-Hack

Version: V2.1

Description
1: Deletes all GM characters not stated in this procedure.
2: Automaticly bans their accounts and IPs.
3: Logs each ban.


3: Find the place in the query where it says:

AND character_name <> '[GM]Zombe'
AND character_name <> '[GM]YourName'
AND character_name <> '[GM]Etcetera'

Replace the names with the GM names you want to be excluded from banning.
If you would like, you can add more names, or delete. Just add another line under these, like
AND character_name <> 'GM's name'

4: Scroll up to the top of the script, find the place where it says:
FILENAME = 'C:\DATABASES\baninfodata.mdf'
and
FILENAME = 'C:\DATABASES\baninfolog.ldf'
Replace the directory (C:\DATABASES\) to where you keep your database files (sergcool uses C:\ but I think that's stupid.). Make sure the directory exists!

5: Once you have done that, run the query.

6: Turn on the SQL Server Agent from the SQL service manager.

7: Go to the Enterprise Manager,
go Management --> SQL Server Agent --> Jobs.

8: Create a new job, name it for example AntiGmHackV2.

9: Go to steps, press NEW, name it lets say "Execute stored procedure", select database ban_info, and at command write:

Code:
exec AntiGmHack;
Press OK.

10: Create new step, name it lets say "Wait", set database to ban_info (though its not 100% necessary), write the command:

Code:
WAITFOR DELAY '000:00:02';
Go advanced, set both on success and on failure actions to:
Goto step [1] Execute Stored Procedure
We want the on failure to that too, so that if the job accidentally lags for a bit, it still keeps running.

11: Open step 1 again, go advanced, set both on success and on failure actions to:
Goto step [2] Wait

12: Press OK in the job, click YES when it asks you.

13: If you have AntiGmHack V1 by silkbotter running, stop that job.

14: Rightclick the job, click start job, then START.

AntiGmHack V2 is running!


To edit the GMs list (If lets say a new GM joins):
1: Go to Databases --> ban_info --> Stored Procedures --> Doubleclick AntiGmHack

2:
Find

AND character_name <> 'Your 1st gm'
AND character_name <> 'Your 2nd GM'
etc

And delete 1 line, or add 1 line, according to your GM's name.

3: Press OK.

Your GM list is modified.

/* -----{Zombe's database cleaning script}----- */

use account;
DELETE FROM C_IP_BAN;
DELETE FROM C_IP_PERMIT;
DELETE FROM C_IP_PWD;
DELETE FROM C_LOGINIPBLOCK_LOG;
DELETE FROM C_SEQUENCE;
DELETE FROM CP_USER_PROFILE;
DELETE FROM MB_USR_IP;
DELETE FROM MB_USR_PUN;
DELETE FROM Tbl_user;
DELETE FROM USER_CONNLOG_KEY;
DELETE FROM USER_PROFILE;
GO
use billing;
DELETE FROM bl_error_log;
DELETE FROM c_sequence;
DELETE FROM dba_online_daily;
DELETE FROM dba_online_daily_notok;
DELETE FROM Tbl_KeepId;
DELETE FROM user_account;
DELETE FROM user_account;
DELETE FROM user_charge_log;
DELETE FROM user_everyday_use_info;
DELETE FROM user_give_log;
DELETE FROM user_use_log;
DELETE FROM user_use_log_bk;
GO
use cash;
DELETE FROM bl_error_log;
DELETE FROM Tbl_Cash_zj;
DELETE FROM user_cash;
DELETE FROM user_charge_log;
DELETE FROM user_use_log;
GO
use character;
DELETE FROM C_EVENT_ITEM_OP
DELETE FROM c_restword;
DELETE FROM char_connlog;
DELETE FROM CHAR_CONNLOG_KEY;
DELETE FROM DEL_USER_CHAR_LIST;
DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
DELETE FROM GM_ITEM_MST;
DELETE FROM GUILD_CHAR_INFO;
DELETE FROM GUILD_INFO
WHERE guild_code NOT LIKE 'MASTERCODE';
DELETE FROM GUILD_INFO_SECEDE;
DELETE FROM GUILD_PEERAGE
WHERE guild_code NOT LIKE 'MASTERCODE';
DELETE FROM MSSNGR_CHAR_LIST;
DELETE FROM SIEGE_INFO;
DELETE FROM SIEGE_RESULT_LOG;
DELETE FROM user_bag
WHERE character_no NOT LIKE 'DEKARON_000001';
DELETE FROM user_bag_copy;
DELETE FROM user_bag_secede;
DELETE FROM user_character
WHERE character_no NOT LIKE 'DEKARON_000001';
DELETE FROM user_character_secede;
DELETE FROM USER_POSTBOX;
DELETE FROM USER_POSTBOX_SECEDE;
DELETE FROM User_Quest_Doing;
DELETE FROM user_quest_doing_secede;
DELETE FROM User_Quest_Done;
DELETE FROM user_quest_done_secede;
DELETE FROM user_skill
WHERE character_no NOT LIKE 'DEKARON_000001';
DELETE FROM user_skill_secede
DELETE FROM user_slot
WHERE character_no NOT LIKE 'DEKARON_000001';
DELETE FROM user_storage;
DELETE FROM user_storage_copy;
DELETE FROM USER_STORE;
DELETE FROM USER_STORE_copy;
DELETE FROM USER_STORE_SECEDE;
DELETE FROM user_suit
WHERE character_no NOT LIKE 'DEKARON_000001';
DELETE FROM user_suit_copy;
DELETE FROM user_suit_secede;
GO

This is a very easy program to use if you are CSV editing!
Download [Only registered and activated users can see links. Click Here To Register...]
Download [Only registered and activated users can see links. Click Here To Register...]