Clean/Empty Private Server Database Files

[Reporter4000]

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 name>' for most of the tables and 'DELETE FROM <table name>' for anything else that would truncate.

Use these files in the same way you would the other database backups.

Enjoy.
(Thanks if you use it please!!)

Main Link:

Mirrors: None yet, provide them if you can.

YOU MUST START YOUR USER_IDS FROM: '08053118000306' THEN ADD ONE FOR EVERY USER.. DONT ASK WHY I DONT KNOW!

[EliteDKTrader]

Ty Man. I was looking for clean DB files but I didnt find any yet.
Lots of ty :P

[silkbotter]

have4 you tried to create a new account, and to register a new char with those dbs?
i cleaned mine and had some weird errors..
i hope yours are working fine

[trane.]

Upload it to megaupload/mediafire, thanks.

[Reporter4000]

Originally Posted by silkbotter

have4 you tried to create a new account, and to register a new char with those dbs?
i cleaned mine and had some weird errors..
i hope yours are working fine

You mean errors like:

600,300?
An error occored?
This id is allready connected?

Stuff like that? Cause i'm getting them now xD

[bllade7]

Any tut how to create pserver with these files?

[5had0w]

you guys can't create char's it's so easy to clean db without getting errors.

[silkbotter]

Originally Posted by Reporter4000

You mean errors like:

600,300?
An error occored?
This id is allready connected?

Stuff like that? Cause i'm getting them now xD

not quite^^
thew id already exists is what the error says ^^
the funny thing is: when you create a new char you got the empty error. if you look into your db, you'll see a registered char.
when you log-off you won't be able to connect again :/

Originally Posted by bllade7

Any tut how to create pserver with these files?

look at the topics.. there's one topic created by me ^^

[{^_^}]

Originally Posted by ~trane~

Upload it to megaupload/mediafire, thanks.

Links:

[mandarina]

Dont works

[silkbotter]

just use mine!
they've got empty accounts.
there are still some characters on the character db, but that will be no problem since no account will be able to connect with those characters.

[inkredibil]

Originally Posted by silkbotter

just use mine!
they've got empty accounts.
there are still some characters on the character db, but that will be no problem since no account will be able to connect with those characters.

Can you tell me how did you clean the accounts , what tools you used ...

[Kraim]

Originally Posted by inkredibil

Can you tell me how did you clean the accounts , what tools you used ...

you can delete the rows one by one by clicking on the row you want o delete...but that takes much time(cause there are more than 4000 accounts >.> ..but i dunno another way..

[Zero4Zero]

Originally Posted by SpeedBasher

you can delete the rows one by one by clicking on the row you want o delete...but that takes much time(cause there are more than 4000 accounts >.> ..but i dunno another way..

Or simply mark the one left in the first line scroll down till the end, mark the last one left while holding shift and then deleting all 4000 accounts once..



Greets

[Zektor]

Do character's "ACTUALLY" work on this one?