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: Paladin Server Files Download
Now download the client here: Paladin Client Download
Just use the External Mirror 1 also there is a torrent as well on there .
Now download the Client Patch: PPaladin Client Patch Download 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: Xamp Download.
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: HexEditor Download .
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: Halloween Server Files Download 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 : Halloween Client Patch Extract it into your client and click yes to all. 80 percent translated.
Now take this Cq_action Cq_action Download . 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: 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: Cq_itemtype 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, 0**** 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, 0**** 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, 0**** 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
(50000**** 50000**** 0000, 0**** 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
(50000**** 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, 50000**** 50000**** 0508, 0, '1 0 50');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(50000**** 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
(50000**** 50000106, 50000108, 1001, 0, 'e_money < 10000');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(50000106, 50000107, 0000, 0**** 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, 50000**** 0000, 0501, 810009, '');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(50000**** 50000**** 0000, 1085, 0, 'gmlog/action_log 330,%user_name[%user_id],0,1059,724041,0,0,0,50000****0');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(50000**** 50000**** 0000, 1001, 0, 'e_money += -10000');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(50000**** 50000**** 0000, 0**** 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
(50000**** 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.
Subject: Guide:Setting up paladin db and Halloween db 
Sun Aug 30, 2009 9:19 am
