Guide:Setting up paladin db and Halloween DB

DeathNoteEO · 11/22/2008, 11:29

This is my first guide first off i want to let everyone know i am just letting you all have a guide that i made but some of it was not made by me i just got some links and put them in here.

All the credits goes to the following people: Necron33, Dibiase, Jonhs22, Commandcom, Forcer, Funhacker, and Cyberghoser1.

Lets now see how all this work, simple, very simple.

Download here the server files:

Now download the client here:

Just use the External Mirror 1 also there is a torrent as well on there .

Now download the Client Patch:

Just put in the client and extract here and click yes to all and your done.

SETUP:

Very easy here, just install the client to where you like, i usualy use C:\EU
Extract the client patch somewhere then copy paste all the files over the client and overwrite
Put the oem.ini and oem.dat in the ini folder of client and overwrite
Make a shortcut of soul.exe in the desktop with the parameter blacknull or create a run.cmd file and put in @soul.exe blacknull and save this file within the main directory of the client then run game from there.

extract the server to C:\ so you will have C:\Server and not C:\Server\Server... (this prevent shortcuts missing target) Note : or you can extract on desktop too will work just as well.

LITTLE FIX BEFORE YOU RUN THE ACCOUNTSERVER.EXE GO IN THE ACCServer FOLDER OPEN WITH NOTEPAD THE AuthorizeDB.cfg AND YOU SHOULD SEE THIS:

Code:

127.0.0.1 root test my2 account name password id
count_stat server_name status
127.0.0.1 root 378b243e220ca493 account

REPLACE ALL THAT BY THIS:

Code:

127.0.0.1 root test my2 account name password id
count_stat server_name status
127.0.0.1 root 378b243e220ca493 my2

The server is ready to use, just run 1 to 4 (when you run winmysqladmin.exe make sure you have the little green light otherwise delete in C:\windows the my.ini and then run again winmysqladmin.exe Note: Also for vista users use winamp/msql in your serverfiles to run mysql , then download xamp and use only for Apache ONLY!!!.

Xamp download for Vista users:

.

Code:

Mysql login and pass are: root & test

Once Acount server Msg server & Npc are full loaded and running launch the game and connect using this account: cyberghoser1 and pass: explorer
or create a new one with the known method (go to C:\server\wamp\www\md5\eo.htm).

For people that want to change the server name and make it online its important to hexedit shell.dat in gameserver folder, so here is a link for hexedit:

.

Also remember to assign all privileges in database user ODBC otherwise any data on game will not be saved!
That's it enjoy your server and see you around!

Now that you have paladin DB oh waite u want Halloween event and new pets well i will explain what do.
First Download this:

This is the Halloween Data Base files.

Now that u downloaded it, go to your server files open it open mysql folder then open data then open my2Note:looks like somethig like this yourserver/wamp/mysql/data/my2) now go back to the Halloween Db Open it up and open the my2 or my folder that is in there now hit Ctrl+A then drag and drop the files into your server my2 and click yes to all now you have the Halloween Data Base .

Now take this Client Patch for the Halloween Data Base :

Extract it into your client and click yes to all. 80 percent translated.

Now take this Cq_action

. Copy all the contents inside and place in your server files and click yes to all looks like this Server/Mysql/Data/my2. 80 percent translated.

Now download this file cq_monster translation:

. Copy all the contents inside and place in your server files and click yes to all looks like this Server/Mysql/Data/my2. 90 percent translated.

Now download this file cq_itemtype translation:

Copy all the contents inside and place in your server files and click yes to all looks like this Server/Mysql/Data/my2. 85 percent Translated

Now that is it you are done you have successfully made a Paladin Database to a Halloween Database . Now if you wanna make it mannequin just do what i told on how to make the paladin to the Halloween database.

If you wanna add some things in the data base i will give some links on how to do it :

First if u wanna wipe all accounts,eudemons,ranks,legions,characters, and family, ect . You will need to go to your Navicat and go to tools click on Console and then enter this into your console and press enter.

Code:

DELETE from my2.cq_user;
DELETE from my2.cq_eudemon;
DELETE from my2.cq_item;
DELETE from my2.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;
DELETE from my2.cq_donation_dynasort_rec;
DELETE from my2.cq_friend;
DELETE from my2.cq_ad_log;
DELETE from my2.cq_announce;
DELETE from my2.cq_deluser;
DELETE from my2.cq_dyna_rank_rec;
DELETE from my2.cq_family;
DELETE from my2.cq_flower;
DELETE from my2.cq_magic;
DELETE from my2.cq_partner;
DELETE from my2.cq_pk_bonus;
DELETE from my2.cq_shortcut_key;
DELETE from my2.cq_special_status;
DELETE from my2.cq_statistic;
DELETE from my2.cq_synattr;
DELETE from my2.cq_syndicate;
DELETE from my2.cq_trade;
DELETE from my2.cq_tutor;
DELETE from my2.cq_tutor_contributions;

This completely Cleans the Database and make's it a fresh new server.

Now if u noticed on the game there is a npc called 100 that absolutely does nothing at all and you wanna get ride of him . Well it is very simple go to Navicat then go to cq_npc hit CTRL+F and type in Cyrus and click find and keep changing pages till u find him then u want to click the thing that looks like a arrow pointing -> and it will highlight the who colloum blue then right click and Delete record and your done. Note: i would advise you to make backups before u ever delete anything or add anything this credit goes to CyberGosher1.

Now if you Notice that the island Teleporter doesn't work i will show how too . First you go to Navicat then tools and console once again and u will want to add this end but it depends on what db u have too

Code:

UPDATE my.cq_npc SET task0 = 4007310 WHERE task0 = 3509020;

or if your database name is my2.

Code:

UPDATE my2.cq_npc SET task0 = 4007310 WHERE task0 = 3509020;

Credits go to TheGamer

Now if u wanna add exp ball or treb sell i will post the codes here
SpecialExp ball seller:

Code:

delete from cq_action where id >= 50000000 and id <= 50000012;
delete from cq_npc where id = 1550 ;
delete from cq_task where id = 50000000;
delete from cq_task where id = 50000003;
delete from cq_task where id = 50000005;

INSERT INTO `cq_npc` VALUES ('1550', '0', '0', 'MagePeppy', '0002', '15500', '0', '0', '-1', '1000', '0304', '0450', '50000000', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '?T', '0000', '00', '00', '0000', '01', '0000', '0000', '0000', '0000', '0000');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000000, 50000001, 0000, 0101, 0, 'My~name~is~MagePeppy.~Would~you~buy~some~Special~Expball~Packs?');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000001, 50000002, 0000, 0102, 0, 'I~would~like~few~Special~Expballs~for~20k~EPs. 50000003');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000002, 4000033, 0000, 0102, 0, 'Sorry~i~want~to~think~first. 0');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000003, 50000005, 50000004, 0508, 0, '1 0 50');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000004, 0000, 0000, 0126, 0, 'You~do~not~have~one~space~in~your~package!');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000005, 50000006, 50000008, 1001, 0, 'e_money < 20000');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000006, 50000007, 0000, 0101, 0, 'You~do~not~have~enough~EP~to~buy~a~Special~Expballs.~Come~back~when~you~do.');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000007, 4000033, 0000, 0102, 0, 'Sorry,~I~go~and~hunt~some. 0');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000008, 50000009, 0000, 0501, 724041, '');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000009, 50000010, 0000, 1085, 0, 'gmlog/action_log 330,%user_name[%user_id],0,1059,724041,0,0,0,50000000,0');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000010, 50000011, 0000, 1001, 0, 'e_money += -20000');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000011, 50000012, 0000, 0101, 0, 'Thank~You~for~buying~an~Special~Expball.~Hope~to~see~you~again.');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000012, 4000033, 0000, 0102, 0, 'Thanks 0');




INSERT INTO `cq_task` VALUES ('50000005', '50000005', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('50000000', '50000000', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('50000003', '50000003', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');

Treb Potion Seller:

Code:

 delete from cq_action where id >= 50000100 and id <= 50000112;
delete from cq_npc where id = 1551 ;
delete from cq_task where id = 50000100;
delete from cq_task where id = 50000103;
delete from cq_task where id = 50000105;

INSERT INTO `cq_npc` VALUES ('1551', '0', '0', 'MagePeppy', '0002', '15500', '0', '0', '-1', '1000', '0304', '0472', '50000100', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '?T', '0000', '00', '00', '0000', '01', '0000', '0000', '0000', '0000', '0000');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000100, 50000101, 0000, 0101, 0, 'My~name~is~MagePeppy.~Would~you~buy~some~3x~Exp~Potions?');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000101, 50000102, 0000, 0102, 0, 'I~would~like~one~3x~Exp~Potion~for~10k~EPs. 50000103');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000102, 4000033, 0000, 0102, 0, 'Sorry~i~want~to~think~first. 0');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000103, 50000105, 50000104, 0508, 0, '1 0 50');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000104, 0000, 0000, 0126, 0, 'You~do~not~have~one~space~in~your~package!');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000105, 50000106, 50000108, 1001, 0, 'e_money < 10000');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000106, 50000107, 0000, 0101, 0, 'You~do~not~have~enough~EP~to~buy~a~3x~Exp~Potion.~Come~back~when~you~do.');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000107, 4000033, 0000, 0102, 0, 'Sorry,~I~go~and~hunt~some. 0');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000108, 50000109, 0000, 0501, 810009, '');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000109, 50000110, 0000, 1085, 0, 'gmlog/action_log 330,%user_name[%user_id],0,1059,724041,0,0,0,50000100,0');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000110, 50000111, 0000, 1001, 0, 'e_money += -10000');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000111, 50000112, 0000, 0101, 0, 'Thank~You~for~buying~an~3x~Exp~Potion.~Hope~to~see~you~again.');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000112, 4000033, 0000, 0102, 0, 'Thanks 0');



INSERT INTO `cq_task` VALUES ('50000105', '50000105', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('50000100', '50000100', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('50000103', '50000103', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');

just put them into navicat tools console Credits go to Cybergosher1

All these i did not take credit for the first part of the guide was by cyberghoser1Note: execpt the client was by me the Halloween Db link was not by me it was a guy named 337918198 and the client patch goes to Spy520 he also did the translations for cq_monster,and cq_itemtype . now i did the guide that is all i am asking credit for and a thanks i told you who did what and what i did now if this guide was useful please give a thanks.

There you go i will release a new guide later .

funhacker · 11/22/2008, 13:08

i didnt read it but i guess least ya trying to help, but seriously i know im not a mod but that signature is annoying and i would prefer not to have to report it can you tone it down please

DeathNoteEO · 11/22/2008, 13:27

Quote:

Originally Posted by funhacker

i didnt read it but i guess least ya trying to help, but seriously i know im not a mod but that signature is annoying and i would prefer not to have to report it can you tone it down please

Better :P

funhacker · 11/22/2008, 13:36

thanks thats alot better

wesman2232 · 11/23/2008, 03:16

xD your links are still broken dude.

Quote:
Originally Posted by wesman2232
ok dude your problem is that your copy and pasting the link, right click the link and choose copy link location.
the link is going to here :
Code:
http://www.fileden.com/files/2008/11...91457/mobs.rar
the browser dosnt know what the dots are. get a full link >.>
I was keeping this, so you can try and figure out why its happening and fix it yourself.
and your links still dont work even on that thread.

from my post on RZ

DeathNoteEO · 11/23/2008, 03:36

Ok im am uplaoding all the files myself he must of took them out

wesman2232 · 11/23/2008, 03:46

no they are there. I have the threads open and they have the correct links.
here they are for ya :
85% cq_itemtype :

90% cq_monstertype :

80% translated patch :

DeathNoteEO · 11/23/2008, 04:06

Quote:

Originally Posted by wesman2232

no they are there. I have the threads open and they have the correct links.
here they are for ya :
85% cq_itemtype :
90% cq_monstertype :
80% translated patch :

Edit:Updated guide

MannequinDBseller · 11/27/2008, 01:08

nice man worked 100% the Mods and admins should make this one of the sticky threads anyone agree with me

|>SomeGuy<| · 11/27/2008, 12:48

Thanks for the guide man, even know i didn't use it your still contributing to the EPVP EO community which gets my thanks good job

Thanks,
SomeGuy

lilpubzy · 12/03/2008, 16:50

really helped me

MannequinDBseller · 12/05/2008, 21:09

lol

DeathNoteEO · 12/30/2008, 04:13

Fix some messed up links

ratson · 01/07/2009, 18:51

DeathnoteEO, could you re-upload the file for "Paladin Client Patch Download" it is not available anymore.

Also thanks for the wonderful guide, just needed to get the file missing I can be able to run the guide to the end. Thanks!

DeathNoteEO · 01/10/2009, 23:03

Quote:

Originally Posted by ratson

DeathnoteEO, could you re-upload the file for "Paladin Client Patch Download" it is not available anymore.

Also thanks for the wonderful guide, just needed to get the file missing I can be able to run the guide to the end. Thanks!

Works for me