Ok, so I know everyone is expecting the IPbanV2/3 from me as my next release, but I decided I will do this first, because it took me a lot less time.
ALL info is deleted, except what is required to run the server with all functions like in the silkbotter's database. Tested by myself, and working.
NOTE: Siege is not added, but you can add it easily with the script. I didn't add siege, because I thought that you will want to set the start time like you want to, yourself.
Restore the backup like with the full-of-chinese-crap silkbotter's database
And the MSSQL query:
Code:
/* -----{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
NOTE: I am not responsible for the data you lose, when you execute this script. It will delete all your characters, accounts, items and everything else.