Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Dekaron > Dekaron Private Server
You last visited: Today at 14:56

  • Please register to post and access all features, it's quick, easy and FREE!


[Release]CLEAN database + MSSQL cleaning script

Reply
 
Old   #1
 
elite*gold: 20
Join Date: Dec 2007
Posts: 1,450
Received Thanks: 823
[Release]CLEAN database + MSSQL cleaning script

My 666th post!


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
This is so that you wouldn't need to download the database over again, if you have the old one.
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.
Attached Files
File Type: rar CLEAN mssql FIXED.rar (1.41 MB, 2037 views)



Zombe is offline  
Thanks
36 Users
Old 09/14/2009, 16:49   #2
 
elite*gold: 20
Join Date: Nov 2007
Posts: 2,852
Received Thanks: 1,868
Thx maybe i will


janvier123 is offline  
Old 09/14/2009, 16:55   #3
 
elite*gold: 20
Join Date: Dec 2007
Posts: 1,450
Received Thanks: 823
Oh, ****, I forgot to leave the guild's mastercode... With this you can't create guilds.
1 second, I will reupload it and edit the script... Don't use it yet

EDIT: ok, changed the script and reuploaded the DB so that the mastercode is left.
EDIT2: Ok, now I'm having problems creating a GM char.. don't use this DB. yet.
Zombe is offline  
Old 09/15/2009, 09:47   #4
 
elite*gold: 0
Join Date: Jul 2009
Posts: 29
Received Thanks: 8
You are missing a bunch of exceptions. Just use my database cleaner at the end of the thread below...



FattyB is offline  
Old 09/15/2009, 16:47   #5
 
elite*gold: 20
Join Date: Dec 2007
Posts: 1,450
Received Thanks: 823
Fixed everything, updated the link, updated the script.
Everything seems to work
Zombe is offline  
Thanks
2 Users
Old 10/06/2009, 08:23   #6
 
elite*gold: 0
Join Date: Sep 2009
Posts: 24
Received Thanks: 7
THANKS MAN
skystar2001 is offline  
Old 10/06/2009, 09:36   #7
 
elite*gold: 0
Join Date: Jul 2009
Posts: 700
Received Thanks: 227
+#6 reported at GMT+3 : 2009 OCT 6 10:35 cause spam not first time you say thanks press thanks if you think your self want to say thanks
Bigshow107 is offline  
Old 12/17/2009, 21:32   #8
 
elite*gold: 0
Join Date: Mar 2008
Posts: 257
Received Thanks: 12
Any one tested this and verified working good? Im gonna try this.
EliteWarrior is offline  
Old 12/18/2009, 00:31   #9
 
elite*gold: 0
Join Date: Aug 2009
Posts: 1,297
Received Thanks: 920
it works, but if u have siege working in ur current DB, this will break it
Decima is offline  
Old 12/18/2009, 00:55   #10
 
elite*gold: 0
Join Date: Jul 2009
Posts: 912
Received Thanks: 250
and it delete the ip banned members
҉ THT ҉ is offline  
Old 02/15/2010, 13:01   #11
 
elite*gold: 0
Join Date: Oct 2007
Posts: 17
Received Thanks: 1
dont works for me =/ cause in my DB no Mastercodes like 'DEKARON_000001'.
I use the 1 click server from Silkbotter. Please can anyone send me a Clean Database without any Characters but with all Mastercodes what needed to create Chars?
razooor is offline  
Old 02/15/2010, 19:14   #12
 
elite*gold: 0
Join Date: Jul 2009
Posts: 912
Received Thanks: 250
Lol this works with 1 click server,, or just download the clean database
҉ THT ҉ is offline  
Old 02/15/2010, 21:44   #13
 
elite*gold: 0
Join Date: Oct 2007
Posts: 17
Received Thanks: 1
if i restore the clean database i dont found any Mastercodes in there... cant create Character

Do i have to delet the LogFiles?
razooor is offline  
Old 02/16/2010, 01:03   #14
 
elite*gold: 0
Join Date: Jul 2009
Posts: 912
Received Thanks: 250
No,, maybe you did something wrong with the job steps

But I am sure this works with 1 click server
҉ THT ҉ is offline  
Old 02/16/2010, 03:33   #15
 
elite*gold: 0
Join Date: Aug 2007
Posts: 554
Received Thanks: 136
yes it works on 1click servers.


xfactorbowler is offline  
Reply



« Incorrect password | need some help »

Similar Threads
[Release] PSC Database Script
Hallo, ich hatte langeweile und hab euch mal ein Paysafecard-Script geschrieben, das die Accountid und die Paysafecard-Nummer in der Database...
56 Replies - Metin2 PServer Guides & Strategies
Clean/Empty Private Server Database Files
I have taken the database files for the private server and cleaned them up. The new packed and rar'd file is 1.1mb. I used 'TRUNCATE TABLE <table...
20 Replies - Dekaron Private Server
[Urgent] Need help to clean user_character Database
sup guys?! i've got one database that was already in use. so there is there lots and lots of characters created and i want to delete them all. but...
12 Replies - Dekaron Private Server
Bugless DataBase clean!!
Hey from me too..I wanna share with u a db that it is mostly translated and bugless...and has a lot of great systems such as:auto-ep,stack...
31 Replies - EO PServer Hosting
Clean Database
Any1 Give Clean and Working Database ?
3 Replies - Dekaron Private Server



All times are GMT +2. The time now is 14:56.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.