Pserver All things Guide[UPDATED]

[Necron33]

Welcome to this Updated Pserver all things Guide.as my first account "ahmedpotop" is banned.and i couldn't edit it ,so i made this
This is beginner stuff,i removed the useless thing in the old Thread and put only the important and direct stuff new db and etc...

Setting Up The Server! - by Drenferalis

 Spoiler

Please refer to this thread, as it's constantly updated and i can't follow it.

Setting up Register script. - by revolution23

 Spoiler

Here is a register script. Just extract this to your www folder. Only edit the config.php.
All the instructions are inside of config.php.


And for register page to work you have to run apache.

If CAPTCHA dont work got to your apache folder and replace the php.ini with this one. Then go to task manager and end all apache processes. Then re-run apache, and you will get about 6 errors, just press ok on them. Its supposed to happen.

Oh and if your a new and dont know how to get to register page go to



Or if you want to give reg page to others use
ur ip adress here/register.php
ww w.rar link:
php.rar link:

Ripped Eudemons Online Website - By Necron33.

 Spoiler

I've ripped Eudemons Online official homepage, in order to see it, you need to put it your www folder if you are using wamp, otherwise put it on a web server. then reach it here.
www rara link

Pet rankings, Leigon rankings web pages - By Necron33

 Spoiler

Pets Ranking:
Download This file and extract it in your www folder in your wamp then to see your page of eud go to this page
the PetsRankning File Link

TopLeigons:
Download This File and Extract it in your www folder in your wamp then to see your page go to here:

the TopLeigonsFile Link

Managing your Server:

Appointing characters as PlayerMasters :-

 Spoiler

open navicate --> open connection --> open my2 --> click on cq_user --> find your name --> put [PM] in it anywhere.

Changing Monster drops, and their rates :-

 Spoiler

ItemsList can be found somewhere on this forums, grab them and then grab item id. or simply, go to navicate --> my --> cq_itemtype, and begin grabbing ^^.
open my -->new query --> put this

update cq_dropitemrule set item0=ITEMIDHERE;
update cq_dropitemrule set item1=ITEMIDHERE;
update cq_dropitemrule set item2=ITEMIDHERE;
update cq_dropitemrule set item3=ITEMIDHERE;
update cq_dropitemrule set item4=ITEMIDHERE;
update cq_dropitemrule set item5=ITEMIDHERE;
update cq_dropitemrule set item6=ITEMIDHERE;
update cq_dropitemrule set item7=ITEMIDHERE;
update cq_dropitemrule set item8=ITEMIDHERE;
update cq_dropitemrule set item9=ITEMIDHERE;
update cq_dropitemrule set item10=ITEMIDHERE;
update cq_dropitemrule set item11=ITEMIDHERE;
update cq_dropitemrule set item12=ITEMIDHERE;
update cq_dropitemrule set item13=ITEMIDHERE;
update cq_dropitemrule set item14=ITEMIDHERE;

UPDATE CQ_DROPITEMRULE SET CHANCE=WHATEVERYOUWANTHERE;

Changing Compose Rates :-

 Spoiler

navicate --> my --> New query write this:-

Update cq_eudemon_rbn_rqr set min = (when it's lower, it's more harder, if you want to multiply them, which is the PERFECT solution, use "*x(the asterik means times, x is the number to multiply with, dividing is nearly the same. but with / instead of *);
Update cq_eudemon_rbn_rqr set max=(when it's lower, it's more harder, if you want to multiply them, which is the PERFECT solution, use "*x(the asterik means times, x is the number to multiply with, dividing is nearly the same. but with / instead of *);

#if you want compose rates to be x2 or xwhatever just write instead of "what you want here" *2.

More than 3 Eudemons summoning.

 Spoiler

Go to cq_user Select the char name go to medal_select set the number of summon eudemons you wanna summon.

Eudemons default born number of stars editing. :-

 Spoiler

open my --> Query, and write this scripts.

update cq_grade set rarity= Number you want;

Updating universals after setting the number of stars so they stay unique and composeable.

update cq_grade set rarity= 1500 where id= 1071980;
update cq_grade set rarity= 1500 where id= 1071981;
update cq_grade set rarity= 1500 where id= 1071982;

Default starting settings. :-

 Spoiler

Open your DB by Navicate right click on cq_user click Design Table Now See all That Set It To What

For Eps u have to put The right Eps and The Right Checksum

Add Important NPC'S to your Server - by commandcom:

 Spoiler

Exp Ball Seller:-

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~Expbal ls.~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');

X3 Exp Pot Seller:

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', 'X3Peppy', '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~P otions?');

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~se e~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');

Change your Eudemons number of stars. :-

 Spoiler

itemtype.dat & shop.dat (newones) editor.

 Spoiler

Thanks to all elitepvpers, everything is a copyright of it's respective owners.
Now after this, You WILL want to look to this threads, as you got a very simple, yet powerful server up, with all basic features.

Good luck on your journey, good luck!

[dani-filth0]

make connection
connection name : ur server name
hostname/ip address : localhost
port : 3306
username : root
password : test
then test connection if it said connection successful ithen press ok if not replace ur pass by root

[yammys31]

Originally Posted by dani-filth0

add me , i will do it for u
cuz some times notepad has such an errors

ty i managed to get it i just shortened server name in the end lol but i am still having problems, i am following necrons guide and when i start up the account sever it gives me a windows error saying it must close and to save all info, i'm not sure what i am doing wrong i have edited everything as he said to but still get the same message, racking my brains now for 3 days lol any ideas? and ty btw

i added you ty

[fallen90]

i have a problem with my AccountServer.exe, every time i open it, it just closes down automatically. Any help would be appreciated

[dipswitch]

this usually happens when accserver don't get connection to the database.
doublecheck all the ini files to make sure you entered all right. And check if mysql is running

[ChronoZero]

Originally Posted by fallen90

i have a problem with my AccountServer.exe, every time i open it, it just closes down automatically. Any help would be appreciated

what ever that guy said is wrong, when this happens 1 of 2 things are wrong

Either A. you arnt running your mysql database

Or B. your database is corrupted and the account server cant read it, make sure that your database is running and if there are any problems with it

Originally Posted by OnlyHope

umm some one help me plz i have every thing set up the only problem is my msg server wont connect to the account server and when i try to log in it says server is down plz help

now the guy's under you response is half right, also make sure that you have all your ports needed forwarded so the msg server can connect thru the internet to the account server

[karnyge]

12.Open C:/Server/AccServer/accountserver.exe ,C:/Server/GameServer/MSG.EXE,C:/Server/GameServer/NPC.EXE
Congratulations you have the Server

can't open the first of these files windows error closes, (windows has encountered a problem and needs to close)


what should i do????

[dani-filth0]

don't copy and past inter it

[rexes13]

u can get the client from ....

[DiobloSlayeR]

Originally Posted by Necron33

Bump,new patches released,site updated,forum now has much info!

Where? are you referring to your server? I know you are the thread starter but you should advertise your server in the corresponding thread you have made earlier. Thank you.

Originally Posted by timman1

Yeah Done. Got Server Up and Running btw could someone post here GM commands?


i did register and when im logging into my character creating an a char and bla..bla.. when trying to enter the world getting this Error

It's not a client problem, it's a font problem.

Follow the instructions n that link to get that error fixed.

[manruler123456789]

i know english i just dont get this
nsert into account (name,password,reg_date) values ('test','53b6320eb06e2c62888a6d1739cd24bd',now());

#This will make you the account

#username: test
#password: test

[DiobloSlayeR]

Open navicat, click on console(Up left corner, tools). Open Console. Copy that & run it.

[menezes19]

i Server(OK) acc(OK) and NPC(ok). mi client 1091 not conect .... "msg erro --->>> INVALID PASSOWRD! PLEASE CLICK TO FOLOWING BUTTONS TO REATRIVE YOU PASSOWRD..
command used add account >>> paolo test<<<< is correct ? i use MYSQL
insert into account (name,password,reg_date) values ('paolo','53b6320eb06e2c62888a6d1739cd24bd',now()) ;

[Jery16]

Got a problem with winmysqldamin.exe
im not seeing the db in database what i did wrong
because i did all steps till there carefully

[rexes13]

Originally Posted by Jery16

Got a problem with winmysqldamin.exe
im not seeing the db in database what i did wrong
because i did all steps till there carefully

delete my.ini and try again....