GUIDE: Setting up Pally DB

[thegamer1907]

After seeing how many people having problems with the db Necron released, i've decided to make this guide for all of you.

By the way i'm not using wampp for this, i'm using MySQL.

Part:
I: Setting up the DB
II: Configuration
III: Client

K lets get started:

Part I:

Setting up the db:

1. Download the db from Necron's Thread here:


2. Extract it, and copy the my2 folder to your database location ( Wammp directory/MYSQL directory )

3. Now login to MySQL with Navicat/MySQL Browser and run this query:
EDIT: THIS STEP IS TOTALLY OPTIONAL. IT WILL NOT AFFECT YOUR SERVER JUST THAT PAST INFO/ACCOUNTS ARE STILL THERE.

DELETE from my.cq_user;
DELETE from my2.cq_eudemon;
DELETE from my2.cq_item;
DELETE from my2.cq_account;
DELETE from my2.cq_castle;
DELETE from my2.cq_castleitem;
DELETE from my2.cq_castlemap;
DELETE from my2.cq_enemy;
DELETE from my2.e_money;

What it does is to clean your whole database. The database necron provided still has info of the past server (eg: accounts/characters etc.)
The query doesn't completely clean your db yet theres still other tables to clean and i'll leave it to you to clean the rest.

Part II:
Configuration:

1. Go into your Accserver folder.

2. Edit the info in account.ini/config.ini, authorize_db.cfg and gamserver.cfg (use notepad/hexeditor to edit the cfg file)

3. Now go to gameserver folder.

4. Edit the info in config.ini/shell/ini , gamserver.cfg and Shell.dat (use a hexeditor, if you dont have one google " HexWorkshop " )

5. If you open shell.dat with a hexeditor you will see something like this:

127.0.0.1.......Alpha........test............test.............&......

Don't worry if your's is different cos mine is editted.
Well, as u can see, the just change the ip , Alpha is the server name, the first test is your Database user and the second is your password. Dont bother the extra &.
And by the way you needn't bother the config_auto.ini file
We are almost done. What's left now is the Client.

Part III:
Client

1. Client version V1091 & 1130 WORKS WITH THIS. PLEASE AND I MEAN PLEASE DO NOT USE OTHER SERVER'S CLIENT . V1130 WORKS PERFECT WITH THIS GUIDE. Scrunch/Valkyrie/vanquisher and soem pets dont work in V1091. I feel bad if people using my guide use other server's client because of me. You can get V1130 client here:



2. After installing it, Download this patch:


3. Extract the patch in your client folder.

4. One more step to go! Now go to the ini folder in your client directory and find oem.dat.

5. Open it with a hexeditor and now you see many Alpha in it.
Dont bother the urls for now, you can edit them in the future. Scroll down til you find the ip and change it to yours. And then at the bottom what's needed to be editted is self explanatory : the server name and group name.

6. Now start up your server, run accserver.exe then msgserver.exe then npcserver.exe.
They should start up fine if you followed my steps. If not, check again. You may have missed out editting a file.
Now create a test account for yourself and runt he client. If you login without problems, then Congrats. If it tells yout hat the server is down, fret not.

7. Now if you get server is down when trying to login, download this oem.dat:


8. then hex edit it again to match your server and replace the one in the Client ini folder.

9. Now start your server again, it should work now.

10. Enjoy your pally Server!

EDIT: Run Alpha-Online.exe to start the client or with blacknull.

Credits:
Major credits to Necron for releasing the Database. We should be thankful to him.
Me for makign this guide. ( i did it from scratch, no ripping )
and a little credit to dibiase (no, not for the DB, i got it from Necron. For the Patch/Client links)


If you think this guide helped, please leave a thanks.

[pktman]

i have a 128 mb dsl connection, will it be enough to run a server? Bro u have yahoo i wanna talk to u...

[thegamer1907]

yes its enuf. i dont have yahoo but a msn.

[funhacker]

I think you should ask FHEO if you can post their client here as it is their bandwidth you're going to be using for your guide.

[DEADP00L]

FHEo client has now been removed since people dont bother asking and like to steal other peoples work. Way to go. I love how people ruin things for others. Its not that i am aginst the sharing of information But it would of been nice to have been asked first.

Infact i am honestly thinking about releasing ALL the known TQ databases in one zip file. (zero, EO, MnM, and Warlord) and warlord aint even released to english players yet. But then again all those files can be found on Rage Zone for free. (just thought i would share that bit of information for those who are trying to make a quick buck off files that can easily be found elsewhere for free)

[thegamer1907]

well i didnt know about it because i see dibiase using your client for his server so i just took the link. Well i removed the link and im really sorry

[lightnin86]

just tested client 1091 with alphas patch before and it works.

[zuikislol]

please help me, the account server wont run....

[thegamer1907]

Originally Posted by lightnin86

just tested client 1091 with alphas patch before and it works.

ok thanks ill update the guide.

[thegamer1907]

have you changed the stuff in the two CFG files zuki? and hex edit shell.dat?

[zuikislol]

yes i have but i am not sure if i've done it right? i hav to change the ip only or the test test as well?

[DiobloSlayeR]

Ya just can upload it to another link, but ask DEADP00L before doing it

[zuikislol]

ok

[zuikislol]

1 more thing, which mysql shall i use....

[cordellreid]

hey whats ur msn? and uhhm... im stuck with #3 =\