[Guide] how to merge your main databases into one

03/02/2010 04:30 Knight^Hawk#1
This guide will show you how to put your account database into your my database. This is my first guide so bare with me.

lets start....

1. make sure everythings turned off ie acct, msg, npc servers, mysql, and xamp or wamp.

2. Make a back-up of both your my and account databases(they are located in your mysql/data folder. copy and paste them some where else.

3. open the account folder Right-Click-select all. Right-Click-cut.

4. open the my folder, Right-Click-paste. click No To All.

5. open Accserver folder. and change AuthourizeDB.cfg, gameserver.cfg, and config.ini

config.ini should look like this

Code:
[System]
LOGINLISTENPORT	= 9958
POINTLISTENPORT = 9865
SERVER_FULL_DELAY_SECS	= 3000
SERVER_BUSY_DELAY_SECS	= 1000
SERVERNAME = TEST
LOGINNAME = root
PASSWORD = rufeng
SERVERIP = YOUR IP HERE
[Database]
DBHOSTNAME=127.0.0.1
DATABASENAME=my   <=only thing you need to change
DBUSER=root
DBPASSWORD=rufeng
6. AuthorizeDB.cfg should look like this if your using the Candy db.
Code:
 127.0.0.1 root rufeng my account name password id
count_stat server_name status
127.0.0.1 root 0aba5bef155bc40b my

:::change rufeng if this is ur not your mysql password:::
if your useing a different db

Code:
127.0.0.1 root test my account name password id
count_stat server_name status
127.0.0.1 test 4871344843773d3d111 my

:::change test if this is ur not your mysql password:::
7. gameserver.cfg should look like this if using candy db.

Code:
600 1 127.0.0.1 root rufeng my

:::change rufeng if this is ur not your mysql password:::
if useing manni db

Code:
800 1 127.0.0.1 root test my

:::change test if this is ur not your mysql password:::
8. run mysql, servers and xamp or wamp



there you go you should have only my and mysql databases. xD

hope this helps.
03/02/2010 04:34 ~WARNING~#2
nice guide :D

thanked =P
03/02/2010 05:20 Knight^Hawk#3
Much appriciated ibeatuall xD
03/02/2010 05:38 ~WARNING~#4
haha np =P

its easy to follow :D i figured this out a long time ago, but i haven't had time to post it, good thing someone finally did
03/02/2010 11:39 mama12#5
LOL. Nice guide on how to cut and paste.
03/02/2010 14:55 chathouse#6
U have in the AuthorizeDB.cfg 2 Password entered

Code:
127.0.0.1 root [B]rufeng[/B] my account name password id
count_stat server_name status
127.0.0.1 root [B]0aba5bef155bc40b[/B] my
The first password is plain text which is the hash? MD5 or is required of all?
03/03/2010 01:03 Knight^Hawk#7
Quote:
Originally Posted by chathouse View Post
U have in the AuthorizeDB.cfg 2 Password entered

Code:
127.0.0.1 root [B]rufeng[/B] my account name password id
count_stat server_name status
127.0.0.1 root [B]0aba5bef155bc40b[/B] my
The first password is plain text which is the hash? MD5 or is required of all?

i believe its md5
03/03/2010 01:09 ~WARNING~#8
nah its not MD5

the MD5 hash for rufeng is: 3d8ebb4f08aeb2294f09c1f9f5de5c7a

its sha1 i believe

Off topic: btw knight, i added this to my all things guide, i hope you don't mind.
03/03/2010 03:23 Knight^Hawk#9
not at all
03/07/2010 21:52 chathouse#10
So I tried it once the password to changing.

The upper half of the password is clear, the plain text it is .. only what is now the lower your password?

Code:
127.0.0.1 root rufeng account account name password id
count_stat server_name status
127.0.0.1 root 0aba5bef155bc40b account
Change only the upper part, I will not work, .. the account server hangs or crashes.

Now I know it is not MD5 HASH value but it is not a SHA1 hash value.

Now it would interest me like what the encryption is.

I have also tried to insert password on both levels the same password. It did not work either. And it is clearly time, .. I would not have a password which is so simple, and 100000x was posted.

The only thing is I can change the user name .. this is the only lightest, .. I would just like to know .. which is used as hash value. I can not say yes yet none of you stood before this problem and have not solved it.

ty for help
03/07/2010 21:54 ~WARNING~#11
Alright, let me see if i can figure out what encryption method it is, it might take some time

EDIT: by the looks of it, it does look like MD5, but in a 4 bit algorithm, ill continue searching
03/07/2010 22:00 chathouse#12
k ty