Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Eudemons Online > EO PServer Hosting > EO PServer Guides & Releases
You last visited: Today at 16:46

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Make a PServer All Things Guide With Everything!

Discussion on Make a PServer All Things Guide With Everything! within the EO PServer Guides & Releases forum part of the EO PServer Hosting category.

Closed Thread
 
Old   #1
 
mama020153's Avatar
 
elite*gold: 0
Join Date: May 2008
Posts: 800
Received Thanks: 450
Cool Make a PServer All Things Guide With Everything!

First i Would like to Thank ppl who helped me cuz 70% of the Guide Copied From Them
Other 30% my Work.

Ok guyz/girlz here is All the DBs Download Links here:
Holloween/Paly DB/Client: DB:
Code:
[url=http://rapidshare.com/files/163725190/Server.rar]RapidShare: Easy Filehosting[/url]
Client:
Code:
[url=http://www.megaupload.com/?d=77XVYM70]MEGAUPLOAD - The leading online storage and file delivery service[/url]
Guide for the Holloween DB At the Bottom.
By: thegamer1907

Paly DB:
Code:
[url=http://www.megaupload.com/?d=0MZAISCX]MEGAUPLOAD - The leading online storage and file delivery service[/url]
By: dibiase-cyberghoser1-deathnote.

Manequin English Server/DB + Client:
Code:
[url=http://www.megaupload.com/?d=8N2PD5QV]MEGAUPLOAD - The leading online storage and file delivery service[/url]
By: cyberghoser1-Joey123-Spy520-Necron33 - Guide for This DB at the Bottom.

Necron's Official DB Here:
Code:
[URL="http://www.zshare.net/download/5324870396ab281a/"]http://www.zshare.net/download/5324870396ab281a/[/URL]
By: Necron33

Newest DB as of [12-24-2008]
This is the Newest DB as of [12-24-2008] Here:
Code:
[URL="http://www.45z.cn/plus/download.php?open=1&aid=8368&cid=3&link=aHR0cDovL3NvZnQxLjQ1ei5jbi80NXpzb2Z0LzQ1emZpbGUvMjAwODEyMjQyMjU4XzQ1ei5yYXI%3D"]http://www.45z.cn/plus/download.php?open=1&aid=8368&cid=3&link=aHR0cDovL3NvZnQxLjQ1ei5jbi80NXpzb2Z0LzQ1emZpbGUvMjAwODEyMjQyMjU4XzQ1ei5yYXI%3D[/URL]
By: DeathNoteEO

1.How To Make a Pserver Guide :
By: Necron33 and mama020153-Edited the Files and info

Ok everyone, I hope you can find this as simple as I wish I did....
Im going to teach you how to create your own private server.
First of all I want to say thank you to Hot_Place, GunShot, and a few others
for teaching me everything I know now.
One more thing, please dont critisize this post, and if you use my guide thank me... please

Now we begin.....
The first 5 steps are downloads.
1. Download your Eudemons Online client, if you already have it great less Downloading and faster Geting the Server Up for you!
But if you need a Client Check the Place's Below...

Id say try these Places for a GOOD Client:

ACME elite online: Owner (nooneatall & forcer)
Site:
Code:
[url=http://acmeeo.com/]Acme Elite Online MMORPG[/url]
Very Good Site Check here First.
FallenHeroes: Owner (DeadPool)
Site:
Code:
[url=http://www.fheo.esro.us/]Welcome to Fallen Heroes Eo[/url]
Very Good Site Not UptoDate with Palys Yet tho.
NewDomain: Owner (Joey)
Site:
Code:
[url=http://newdomain2008.com/]New Domain :: With a new day, comes a new dawn[/url]
Very Good Site With ACME Both have Good Clients.
DarklordsOnline: Owner (mama020153)
Site:
Code:
[url=http://darklordsonline.*********/]DarklordsOnline and UnderworldOnline - Main[/url]
Good Client Wouldent Count it as the Best tho ACME Number.1 Client.
Code:
Pls Tell Them Thanks if you use there Client.
2. You Will need Wamp5.0 or if that dont work Use Xampp Usely best for Vista Links Here:

Code:
Wamp5.0: [url=http://www.megaupload.com/?d=0MZAISCX]MEGAUPLOAD - The leading online storage and file delivery service[/url]
Xampp: [url=http://www.apachefriends.org/en/xampp.html]apache friends - xampp[/url]
Install to your C:/ (C:/wamp) or (C:/xampp)

3.Create a new folder in your C:/ named "EO ServerFiles"
Download the Server Files.
The Server files that you need, witch are Some what translated. But grammar work needs to be done. Link's Here:

Server Files here:

Paly DB:
Server Files:
Code:
[url=http://www.megaupload.com/?d=0MZAISCX]MEGAUPLOAD - The leading online storage and file delivery service[/url] 
By: DeathNoteEO and dibiase
Holloween DB/Client:
Server Files:
Code:
[url=http://rapidshare.com/files/163725190/Server.rar]RapidShare: Easy Filehosting[/url]
By: xXDoombringerxX
Client:
Code:
[url=http://www.megaupload.com/?d=77XVYM70]MEGAUPLOAD - The leading online storage and file delivery service[/url]
Manequin English Server/DB + Client:
Server Files:
Code:
[url=http://www.megaupload.com/?d=8N2PD5QV]MEGAUPLOAD - The leading online storage and file delivery service[/url] 
By: cyberghoser1
Extract this into C:/EO ServerFiles/

4. The next download you will need is Navicat. This program is used for editing your database files
and translating. This Link Here

5. If you want to run your server with Hamachi, you will need to download the program .
Then you will have to create a network and give it a password. If ppl want to play they need to connect to your
network.

Ok now you have all the programs needed to make your server. :]
Lets move on.....

6. Open C:/EO ServerFiles/ or C:/Manequin/ManequinServerFiles then copy and paste the
"my2" and "account" folders to the following location
C:/wamp/mysql/data/

7. Now you will need to open C:/WINDOWS
Look for the my.ini file. Once you have found it delete it.

8. Go to C:/wamp/mysql/bin/ and run the winmysqladmin.exe. Then it open then close, and ask for a username and password.
Code:
Use the following username: test password: test
Use this Code if The top one Dont Work.
Code:
Use the following username: root password: test
9. Now you will have to edit the IP adress. Put your computers IP address, or your hamachi IP address.
Wich ever you plan to use. Then save your modification.

10. Now right click anywhere on the admin screen. Then click "stop the service".

11. Now you will need to edit your Server Files. So go to C:/EO ServerFiles/ Then Open AccServer folder.

12. Open account.ini and edit it like in the pic below. You will only change your server name.
Now save the changes.

Code:
[Account1]
SERVERNAME=Server-Name-Here
LOGINNAME=test
PASSWORD=test
FREE_DEBUG=3
13. Then open your config.ini, then edit it like in the pic below.


Code:
[System]
LOGINLISTENPORT = 9958
POINTLISTENPORT = 9870
SERVER_FULL_DELAY_SECS = 5000
SERVER_BUSY_DELAY_SECS = 3000
SERVERTITLE = Server-Name-Here
SERVERNAME = Server-Name-Here
LOGINNAME = test
PASSWORD = test
SERVERIP =  your-IP-address or Hamachi Ip
[Database]
DBHOSTNAME=127.0.0.1
DATABASENAME=my2
DBUSER=test
DBPASSWORD=test
14. Now you will have to go to C:/EO ServerFiles/GameServer/
First open your config.ini and edit it to look like this

Code:
; 配置文件


[System]
SERVERNAME = Server-Name-Here
MONSTER_ACTIVE_LIMIT = 4000

ONLINETABLESIZE=600
ONLINEHEARTBEATSECS=600
HEARTBEATKICKSECS=1500
REJOINTIMEWAITSECS=0

[GameServer]
GAMESERVER_IP =  your-IP-address or Hamachi Ip

GAMESERVER_PORT = 5816
SND_SIZE = 64000
RCV_SIZE = 16000

[AccountServer]
ACCOUNTSERVER_IP = your-IP-address or Hamachi Ip
ACCOUNTSERVER_PORT = 5816
SND_SIZE = 64000
RCV_SIZE = 16000



[Database]
DB_IP = 127.0.0.1
DB_USER = test
DB_PW = test
DB_NAME = my2

LOGIN_KEY = dfkKO23k'[cvK934

[InternetPort]
MASTER_IP =  your-IP-address or Hamachi Ip
MASTER_PORT = 8653
PORT_SIZE = 53
CURRENT_PORTID = 1


[BusySleep]
LEVEL1 = 20 ; > 1000 sleep 20%
LEVEL2 = 30 ; > 2000
LEVEL3 = 40 ; > 3000
LEVEL4 = 50 ; > 4000
LEVEL5 = 60 ; > 5000
Now save your changes....

15. Next you will need to open your shell.ini, edit it to look like this

Code:
; 外壳配置文件
; 2007.10.21

[System]
MAPGROUP_SIZE = 1
ACCEPT_MS = 500

[StreamType]
TYPE = 0 ;0=正常从SOCKET,1=SOCKET记录到文件, 2=从文件读(程序调试用)

[Database]
DB_IP = 127.0.0.1
DB_USER = test
DB_PW = test
DB_DB = my2


[AccountServer]
ACCOUNT_IP =  your-IP-address or Hamachi Ip


ACCOUNT_PORT = 9870
SERVERNAME = Server-Name-Here
LOGINNAME = test
PASSWORD = test
; 登录表尺寸, 10-5000
MAXLOGINTABLESIZE=5000
; 登录表超时秒数,0-86400
LOGINOVERTIMESECS=120

LOGIN_KEY = dfkKO23k'[cvK934

[InternetPort]
MASTER_IP =  your-IP-address or Hamachi Ip
MASTER_PORT = 8653
PORT_SIZE = 53
CURRENT_PORTID = 1
Now save your changes....

16. Go back to C:/wamp/mysql/bin/ and run the winmysqladmin.exe again. Then go to the tab where it says database and make sure you
see your my and account databases. If not repeat step 6 again.

17. If you have both of the databases there then you will need open your navicat program. The Download link is above.
Right click on the Navicat screen and go Click New connection. For the connection name go ahead and put what ever your server name is or Something. And for the
IP address put either your hamachi IP or PC's IP address, witch ever you choose to use in the begging. And leave the port default, The port is 3306.
Then for your user put test and if test dont work use root. And leave the password blank. Then test the connection.

18. If the connection is succsessfull double click on it. That should open it. Once it is open you will need to go to Manage Users.
Then if you used User: test looks like this test@localhost or if you used User: root it will look like this root@localhost double click it. It should open up and have 4 databases. Mysql, Test, account, and my2 but all you need is the main 2.
Code:
my2 and account
Click on the account database, then click select all. Save it once you do that. Do the same thing for the database my2.

19. Now that you have granted all of the privilges to these user you will need to set the password test to it. While you are still in the manage user
section, click on the test@localhost or root@localhost again. Then select Edit User. If will come up with a screen where you can set a password. Put the password as test. Make shur
you use the password test..... nothing else.

20. Now you will need to go back to the winmysqladmin.exe again. Right click on it, then go to stop the service. Then go ahead and start it back up again.

21. Now go to C:/EO ServerFiles/AccServ/ and run the Accountserver.exe. If you have followed the steps it should open up just fine. If not then follow steps
6 to 18 again.

22. Then go to C:/EO ServerFiles/GameServer/ and run your MsgServer.exe, then your NPCServer.exe.
Code:
The MSGServer and NPCServer Can Take up to 5 min's to Pull up...
23. Now you will you will need to make yourself an account. Use this command in your mysql command client. Its Located Here:
Code:
C:\wamp\mysql\bin\mysql.exe run that then put the code in There.
Code:
insert into account.account (name,password,reg_date) values ('test','53b6320eb06e2c62888a6d1739cd24bd',now());
This will make you the Account:

Username: test
Password: test


How To Make an acc WithOut Needing a Reg Script: By HellCryer


Make an acc herethen..go to navicat,account and account it should be like this account@account,after that write the pass and Id there


How To Put A Reg Script In ur Server: By Revolution


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

Thanks would be appreciated :]

link:elitepvpers
php.rar link:elitepvpers

How To Put Tqs Script In ur Server By Necron33
I got Tqs Home Page Script It is There but needs a Lot Of Work here i will put the link of the elitepvpers
extract it in ur www folder in ur wamp folder then open the apache,to see that page go here
www rara link HERE

To Get LeigonRanking,EudRanking,PlayersRanking By Necron33

Eud Ranking: By: Necron33
Download This file and extract it in ur www folder in ur wamp then to see ur page of eud go to this page
the EudRankning File Link Here

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

the TopLeigonsFile Link HERE

For Player Ranking I think revoloution realesed it i will Just put the playerranking but it is Reevolution not mine
download this file and put it in www folder then u will have this page:
Ranking File: Link HERE

How To Make Ur Char A PM: By HellCryer

Go to cq_user in Ur my db by Navicate find your name then add [PM] to the beginning or end of your name

To Get DropRates Higher: By netlog_stefan

Open Ur Navicate Click On My database Click On query and right This then click run
Code:
update cq_dropitemrule set item0=729017;
update cq_dropitemrule set item1=729017;
update cq_dropitemrule set item2=729017;
update cq_dropitemrule set item3=729017;
update cq_dropitemrule set item4=729017;
update cq_dropitemrule set item5=729017;
update cq_dropitemrule set item6=729017;
update cq_dropitemrule set item7=729017;
update cq_dropitemrule set item8=729017;
update cq_dropitemrule set item9=729017;
update cq_dropitemrule set item10=729017;
update cq_dropitemrule set item11=729017;
update cq_dropitemrule set item12=729017;
update cq_dropitemrule set item13=729017;
update cq_dropitemrule set item14=729017;
To Get The Compose Rates Higher: By netlog_stefan

Open ur Navicate Database my then open Query wite that in it
Code:
Update cq_eudemon_rbn_rqr set min=what u want here;
Update cq_eudemon_rbn_rqr set max=what u want here;
To Make More Than summon 3 Eud: By HellCryer

Go to cq_user Select the char name go to medal_select set the number of summon eud u want

To Make 19*-29*,12*-22*: By Me
Code:
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;
Show You How to Change New Comer Default Settings: By Necron33

Open ur my db by Navicate right click on cq_user click Desigen Table NowSee all THT Set It To What

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

If u Need any Help Post Here

How To Put an Item in Ur ShoppingMall of ur Srvr: By cyberghoser1

Here is How to Add items to ur Eo srvr
Lets Take GS as an example:
1.Go to your cq_goods make a new record put in id ANy Thing Like 789091 in owner id write 1207 that means shoppingmall at the item type id put the god stone pm code,
2.Now open ur make new record cq_itemtype in id put 789091 or what ever the id u want then go to emoney put the price u want there
3.Edit ur Shop.dat By HexEditing and put ur new item in it
4.Edit ur ItemType.dat By Hex Editing i think Most Things are in ur itemtype.dat
5.Any Questions Post Here(No Asking Abt HexEDITING)

InCase you Dont know Hex Editing For ItemType.dat: By Necron33(The Tool Made by Pfj511)

Well After 1000 Years Of Searching Found a Tool That Can Open and Read the Item Type So Easy I will Show u a Pic of it now
I Will Put The Link Here
Code:
[URL="http://www.elitepvpers.com/forum/eo-pserver-hosting/189204-guide-hexedit-shopping-mall-replace-items-equipment-eggs.html"]http://www.elitepvpers.com/forum/eo-pserver-hosting/189204-guide-hexedit-shopping-mall-replace-items-equipment-eggs.html[/URL]
Show You How To Add Eud in Ur Server: By Necron33 but with Help Of DarkBebi and funhacker

Hey Much PPl Asked for How Here i Put An Example And Some Info Lets Take The Mouse Eudemon Mercutio:
Code:
1.Cq_ItemType:

1081490 Mercutio 0 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 500
815030 Mercutio 0 0 0 0 0 0 0 0 28 0 3000000 4008940 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 1081490 0 0 0 500
1071490 Mercutio 0 0 0 0 0 0 0 0 0 0 250 0 0 0 0 0 3000 0 0 1 1 0 32 0 0 0 0 0 0 0 0 10000 71490 0 2 1 0
1071491 Mercutio 0 0 0 0 0 0 0 0 0 0 250 0 0 0 0 0 3000 0 0 1 1 0 32 0 0 0 0 0 0 0 0 10000 71491 0 2 1 0
1071492 Mercutio 0 0 0 0 0 0 0 0 0 0 250 0 0 0 0 0 3000 0 0 1 1 0 32 0 0 0 0 0 0 0 0 10000 71492 0 2 1 0
1079490 Mercutio 0 0 0 0 0 0 0 0 0 0 250 0 0 0 0 0 3000 0 0 1 1 0 32 0 0 0 0 0 0 0 0 10000 79490 0 2 1 0
1079491 Mercutio 0 0 0 0 0 0 0 0 0 0 250 0 0 0 0 0 3000 0 0 1 1 0 32 0 0 0 0 0 0 0 0 10000 79491 0 2 1 0
1079492 Mercutio 0 0 0 0 0 0 0 0 0 0 250 0 0 0 0 0 3000 0 0 1 1 0 32 0 0 0 0 0 0 0 0 10000 79492 0 2 1 0

1081490 is The Egg Code
815030 is The Egg Bag Code
1071440 is the eudemon that first comes out of the egg
1071441 is the first evolve when it reaches level 20
1071442 is the second evolve when it passes 40

1079440 is the thundered pet of the first pet
1079441 is the thundered pet of the first evolve
1079442 is the thundered pet of the second evolve
Cq_MonsterType

71490 Mercutio 1 323 0 0 100 0 0 0 0 0 0 0 0 0 0 7 15 0 1000 0 1 32775 0 0 3 0 0 99 99 99 99 99 99 99 0 200000 5000 0 75 75 1 10000 0 0 0 0 323 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
71491 Mercutio 1 323 0 0 100 0 0 0 0 0 0 0 0 0 0 7 15 0 1000 0 1 32775 0 0 3 0 0 99 99 99 99 99 99 99 0 200000 5000 0 75 75 1 10000 0 0 0 0 323 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
71492 Mercutio 1 323 0 0 100 0 0 0 0 0 0 0 0 0 0 7 15 0 1000 0 1 32775 0 0 3 0 0 99 99 99 99 99 99 99 0 200000 5000 0 75 75 1 10000 0 0 0 0 323 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
79490 Mercutio 1 323 0 0 100 0 0 0 0 0 0 0 0 0 0 7 15 0 1000 0 1 32775 0 0 3 0 0 99 99 99 99 99 99 99 0 200000 5000 0 75 75 1 10000 0 0 0 0 323 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
79491 Mercutio 1 323 0 0 100 0 0 0 0 0 0 0 0 0 0 7 15 0 1000 0 1 32775 0 0 3 0 0 99 99 99 99 99 99 99 0 200000 5000 0 75 75 1 10000 0 0 0 0 323 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
79492 Mercutio 1 323 0 0 100 0 0 0 0 0 0 0 0 0 0 7 15 0 1000 0 1 32775 0 0 3 0 0 99 99 99 99 99 99 99 0 200000 5000 0 75 75 1 10000 0 0 0 0 323 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
71490 In all Theese We Take the Last 3 Numbers of the Real id in order i mean that 1071490 the 490 we take and put after it means we only make the 10 go from the Real Id

Cq_dyna_rank_type

1343 1149010 120
1344 1149011 120
1345 1149012 120
1346 1149013 120
1347 1149014 120
1348 1149015 120
1349 1149016 120
1350 1149020 120
1351 1149021 120
1352 1149022 120
1353 1149023 120
1354 1149024 120
1355 1149025 120
1356 1149026 120
1357 1149040 120
1358 2149010 120
1359 2149011 120
1360 2149012 120
1361 2149013 120
1362 2149014 120
1363 2149015 120
1364 2149016 120
1365 2149020 120
1366 2149021 120
1367 2149022 120
1368 2149023 120
1369 2149024 120
1370 2149025 120
1371 2149026 120
1372 2149040 120

Cq_eudemon_rbn_type

1079490 1 1 1 1 1
1079491 1 1 1 1 1
1079492 1 1 1 1 1
1071490 1 1 1 1 1
1071491 1 1 1 1 1
1071492 1 1 1 1 1

Cq_grade

1071490 188 188 0 3000 7500 148 0 0 0 0 0 0 0 0 0 0 0 0 88 88 0 9000 22500 121 88 88 0 8000 20000 347 88 88 0 12000 30000 102 88 88 0 5000 12500 1844 50 100 200 0 380 0 2500 0 0
1071491 188 188 0 3000 7500 148 0 0 0 0 0 0 0 0 0 0 0 0 88 88 0 9000 22500 121 88 88 0 8000 20000 347 88 88 0 12000 30000 102 88 88 0 5000 12500 1844 50 100 200 0 380 0 2500 0 0
1071492 188 188 0 3000 7500 148 0 0 0 0 0 0 0 0 0 0 0 0 88 88 0 9000 22500 121 88 88 0 8000 20000 347 88 88 0 12000 30000 102 88 88 0 5000 12500 1844 50 100 200 0 380 0 2500 0 0
1079490 188 188 0 3000 7500 148 0 0 0 0 0 0 0 0 0 0 0 0 88 88 0 9000 22500 121 88 88 0 8000 20000 347 88 88 0 12000 30000 102 88 88 0 5000 12500 1844 50 100 200 100 380 0 2500 0 0
1079491 188 188 0 3000 7500 148 0 0 0 0 0 0 0 0 0 0 0 0 88 88 0 9000 22500 121 88 88 0 8000 20000 347 88 88 0 12000 30000 102 88 88 0 5000 12500 1844 50 100 200 100 380 0 2500 0 0
1079492 188 188 0 3000 7500 148 0 0 0 0 0 0 0 0 0 0 0 0 88 88 0 9000 22500 121 88 88 0 8000 20000 347 88 88 0 12000 30000 102 88 88 0 5000 12500 1844 50 100 200 100 380 0 2500 0 0
Done Now Go and Write in ur Client that have the Files of the Mice Eud /awarditem 1081490

U get ur Eudemon Mercutio

By: DarkBebi and Funhacker

For The Mice Eud To Workk use DarkBebis Client and Patches


3 NPCS For Ur Server By CommandCom

I Have Three Npcs u would Need open ur Navicate then open click on my then click on query

1.Pally Gear Selling Npc
Code:
delete from cq_action where id >= 50000200 and id <= 50000219; delete from cq_npc where id = 1552 ; delete from cq_task where id = 50000200; delete from cq_task where id = 50000203; delete from cq_task where id = 50000205; INSERT INTO `cq_npc` VALUES ('1552', '0', '0', 'MagePeppy', '0002', '15500', '0', '0', '-1', '1000', '0287', '0468', '50000200', '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 (50000200, 50000201, 0000, 0101, 0, 'My~name~is~MagePeppy.~Would~you~buy~Elite~Paladin ~gear?'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000201, 50000202, 0000, 0102, 0, 'I~would~like~one~Elite~Paladin~gear~for~10k~EPs. 50000203'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000202, 4000033, 0000, 0102, 0, 'Sorry~i~want~to~think~first. 0'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000203, 50000205, 50000204, 0508, 0, '15 0 50'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000204, 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 (50000205, 50000206, 50000208, 1001, 0, 'e_money < 10000'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000206, 50000207, 0000, 0101, 0, 'You~do~not~have~enough~EP~to~buy~a~Elite~Paladin~ gear.~Come~back~when~you~do.'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000207, 4000033, 0000, 0102, 0, 'Sorry,~I~go~and~hunt~some. 0'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000209, 50000210, 0000, 1085, 0, 'gmlog/action_log 330,%user_name[%user_id],0,1059,724041,0,0,0,50000200,0'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000210, 50000211, 0000, 1001, 0, 'e_money += -10000'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000211, 50000212, 0000, 0101, 0, 'Thank~You~for~buying~an~Elite~Paladin~gear.~Hope~ to~see~you~again.'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000212, 4000033, 0000, 0102, 0, 'Thanks 0'); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000208, 50000214, 0000, 0501, 113003, ''); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000214, 50000215, 0000, 0501, 123003, ''); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000215, 50000216, 0000, 0501, 133003, ''); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000216, 50000217, 0000, 0501, 143003, ''); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000217, 50000218, 0000, 0501, 163003, ''); INSERT INTO cq_action (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES (50000218, 50000209, 0000, 0501, 490003, ''); INSERT INTO `cq_task` VALUES ('50000205', '50000205', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('50000200', '50000200', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('50000203', '50000203', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
SpecialExpBalls 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~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');
Treble ExpPot 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', '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');
PkTour Boxes Fix: By: Noneatall
use my;
Code:
delete from cq_action where id ='3911910';
delete from cq_action where id ='3911911';
delete from cq_action where id ='3911912';
delete from cq_action where id ='3911913';
delete from cq_action where id ='3911914';
delete from cq_action where id ='3911915';
delete from cq_action where id ='3911916';
delete from cq_action where id ='3911940';
delete from cq_action where id ='3911941';
delete from cq_action where id ='3911942';
delete from cq_action where id ='3911943';
delete from cq_action where id ='3911944';
delete from cq_action where id ='3911945';
delete from cq_action where id ='3911946';
delete from cq_action where id ='3911200';
delete from cq_action where id ='3911201';
delete from cq_action where id ='3911202';
delete from cq_action where id ='3911203';
delete from cq_action where id ='3911204';
delete from cq_action where id ='3911205';
delete from cq_action where id ='3911206';
delete from cq_action where id ='3911207';
delete from cq_action where id ='3911208';
delete from cq_action where id ='3911209';
delete from cq_action where id ='3911210';
delete from cq_action where id ='3911211';
delete from cq_action where id ='3911970';
delete from cq_action where id ='3911971';
delete from cq_action where id ='3911972';
delete from cq_action where id ='3911973';
delete from cq_action where id ='3911974';
delete from cq_action where id ='3911975';
delete from cq_action where id ='3911976';
delete from cq_action where id ='3911977';
delete from cq_action where id ='3912000';
delete from cq_action where id ='3912001';
delete from cq_action where id ='3912002';
delete from cq_action where id ='3912003';
delete from cq_action where id ='3912004';
delete from cq_action where id ='3912005';
delete from cq_action where id ='3912006';
delete from cq_action where id ='3912007';
delete from cq_action where id ='3912008';
delete from cq_action where id ='3912009';
delete from cq_action where id ='3912010';
delete from cq_action where id ='3912011';
delete from cq_action where id ='3912030';
delete from cq_action where id ='3912031';
delete from cq_action where id ='3912032';
delete from cq_action where id ='3912033';
delete from cq_action where id ='3912034';
delete from cq_action where id ='3912035';
delete from cq_action where id ='3912036';
delete from cq_action where id ='3912037';
delete from cq_action where id ='3912038';
delete from cq_action where id ='3912060';
delete from cq_action where id ='3912061';
delete from cq_action where id ='3912062';
delete from cq_action where id ='3912063';
delete from cq_action where id ='3912064';
delete from cq_action where id ='3912065';
delete from cq_action where id ='3912066';
delete from cq_action where id ='3912067';
delete from cq_action where id ='3912068';
delete from cq_action where id ='3912090';
delete from cq_action where id ='3912091';
delete from cq_action where id ='3912092';
delete from cq_action where id ='3912093';
delete from cq_action where id ='3912094';
delete from cq_action where id ='3912095';
delete from cq_action where id ='3912096';
delete from cq_action where id ='3912097';
delete from cq_action where id ='3912098';
delete from cq_action where id ='3912099';
delete from cq_action where id ='3912100';
delete from cq_action where id ='3912101';
delete from cq_action where id ='3912120';
delete from cq_action where id ='3912121';
delete from cq_action where id ='3912122';
delete from cq_action where id ='3912123';
delete from cq_action where id ='3912124';
delete from cq_action where id ='3912125';
delete from cq_action where id ='3912126';
delete from cq_action where id ='3912127';
delete from cq_action where id ='3912128';
delete from cq_action where id ='3912129';
delete from cq_action where id ='3912130';
delete from cq_action where id ='3912131';

INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(3911910, 3911911, 3911915, 508, 0, '2 0 50');

INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(3911911, 3911912, 0000, 502, 729217, '');

INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(3911912, 3911913, 0000, 501, 724024, '');

INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(3911913, 3911914, 0000, 501, 724040, '');

INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(3911914, 0000, 0000, 126, 0, 'Congratulations~you~won~the~tourney');

INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(3911915, 0000, 0000, 126, 0, 'leave~2~slots~in~your~inventory~free');





INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(3911940, 3911941, 3911945, 508, 0, '2 0 50');
Some Server Proplems and its Solve: By Necron33
1.Out Game Proplems
1.Cant Connect To Navicate or Open the Server Files=Mysql Error
Solve-->Just Replace The Mysql With a New One

2.Error on Reg Page With Apache u should get abt 3 or 4 eroors mor ethan That Means Reg Page Wont Work i found That Proplem With Commandcom Apache
Solve--> u Have To Replace The Apache with a New One

3.When U ReLog all ur Items Gone Means cq_item got Crashed
Solve--> Replace cq_item with a New One

4.When u Relog all ur Eud Gone cq_eudemon Got Crashed
Solve--> Replace cq_eudemon with a New One

5.Leigons Dont Work It Means u using a Mysql Higher than 4.0
Solve--> use Mysql 4.0

InGame Proplems

1.Oem says Server DOWN
Solved--> Download This Link Below:
Code:
[URL="http://24.230.56.126/OmeFix.rar"]http://24.230.56.126/OmeFix.rar[/URL]
By: Me
2.ShoppingMall Dont Work and u cant see ur items or Eud Incorupt Item Type or Shop.dat
Solve-->Replace the itemtype and shop.dat with the right ones

3.Cant get Hairs and Avatars when using PJF Patces
Solve--> Download the itemtype.dat that haci made

4.Eud Dead After Going Up More Than 80* It is Due to Checksum
Solve--> Download this New MSG server Here:
Code:
[URL="http://24.230.56.126/MsgServer.exe"]http://24.230.56.126/MsgServer.exe[/URL]
By: Me
Soon More Proplems will be Placed Here.

If you Have More Questions Post Here


Mice Eud By hacileveli
Download This Sqql Script From Here:
Code:
[url=http://www.elitepvpers.com/forum/attachments/eo-pserver-hosting/13576d1214407025-release-4-mice-pet-sql-script-client-files-micepets.rar]elitepvpers[/url]
FourSummonStone By haciveli
Download This Sql Script From Here:
Code:
[url=http://www.elitepvpers.com/forum/attachments/eo-pserver-hosting/13595d1214465277-release-4-mice-pet-sql-script-client-files-4th-summon.rar]elitepvpers[/url]
Dye Systems By funhacker
Download the Files From Here:
Code:
[url=http://www.elitepvpers.com/forum/attachments/eo-pserver-hosting/11918d1209362668-release-dye-system-database.zip]elitepvpers[/url]
To Make A Site To Be Like Obaneo.co.nr:

First Make ur Site using Freewebs.com - Free website, free hosting, free webpage - Make a web site with photo albums, blogs, videos, forums and more!
then go to this site Free URL Redirection, No Ads! Short Free Domain Name (you.co.nr) Put ur FreeWebs Site there and it Will Redirect it so it be Like ur FreeWebs site but .co.nr

To Make a Fourm: Necron33

Just go to This Site and Make a One InvisionFree

.To Make A chat Box : Necron33

Just Make a one From Here and Put its Code in ur Website XAT

Fix Eud Skills Here: By:zuikislol

XMas Tree in your Server add this to cq_npc:
Code:
50000    0    0    xmastree    0    27640    0    0    -1    1000    298    478    0    0    0    0    0    0    0    0    0    0    0    0    无    0    0    0    0    0    0    0    0    0    0
Originally Posted by thegamer1907
Advanced Level Guide
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 Necron33's Thread here:
Download Pally DB

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.


Code:
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:

Code:
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:

Games On Net File Library :: Eudemons Online v1130 Client - 20080826EudemonsV1130.exe (No Registration Required)

2. After installing it, Download this patch:
Paladin 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:
Oem.dat download

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 making 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)

Setting up Register script.by Revolution23
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

Thanks would be appreciated :]
ww w.rar link:elitepvpers
php.rar link:elitepvpers

Change the drops and Drop rate by doing this :-
open my2 -->new query --> put this

Code:
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:- my2-->New query write this:-

Code:
Update cq_eudemon_rbn_rqr set min=what u want here;
Update cq_eudemon_rbn_rqr set max=what u want here;
Editing the Eudemon's * when it borns,Editing Unis to higher or lesser:-

Code:
update cq_grade set rarity= Number you want;Code:
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;
Add 2 Important NPC'S to your Server:
Exp 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~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:
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', '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');
Originally Posted by pfj511
now ,if you use new msg which i had released ,when your edu star over 85 (8500 score),you willnt callout it! so how to remove this require or how to change this star limit requirement! today i will show you !

first you must have a unpacked msg (MSG2.2901 is a unpacked file ,actually is is just the 2.2883 MSG only change the logo and the verb by others )and use the od (OllyDBG.EXE) tool !

first run the od (OllyDBG.EXE) tool , open the your smg exe file :
file --open ----choose the msg ---ok

then we must the find the key character in this msg! in the game we can find if we callout the edu wich star over score over 8500,the system will show us :edu data is wrrong cant call out (i had translate it to english ) when we open it it via the hex editor ,we can find this key character behind these words : eud_callout......, so it is just the key character we can use in the msg ! now we can continue our work:

click the right on the mouse on the main windows (blue line ) , choose the serach for and choose the all referenced text strings ,here is the pic:


after this , we will see a new windows :right click mouse ,and choose the serach for text open a small windows , here is the pic :


write this strings in this small windows : eud_callout ( just the key character we find above) then serach it and we can find this strings in it ,here is the pic :


right mouse on this blue line and choose the follow in disassembler ,then we will return the main windows where this strings have, here the pic:


lol it is very cloose to the place we are seraching, now we srtach in this main winodws code upwards,and find those code :


Code:
CMP EAX,****
JL ********show you a pic where the place we can find :
now let me explain this two line code to you


Code:
CMP EAX,2134
JL 005BF75A
CMP EAX,2134 |:compare the EAX number and the 2134 ,, this 2134 numnber , we can change hex number to algorism ,it will be 8500 , lol can you find now what is it means?
just the score require when you callout your over star edu ,here ,EAX number is just your edu star score , do you understand ? lol !

now we have two way to solve this problem :

first : we can modify the define umber 2134 to an other one ,for instance 3A98 (15000 in algorism )
second : we can modify the next code JL to JMP ,for this we can jump the detect ,if this you can call out any star edu in your svr !

now let me show you how to make the first step :

like the pic above ,we can edit this CMP line code ,modify the 2134 to 3A98 ,here is the pic :




till now , the rest work is only to save the new exe file ! how ? i wont to explain just show some pic ,it may be clearly than my words ,lol! mybe some one know how to save this file !





release some file you can use it !



Itemtype.dat Editer
Originally Posted by Necron33
I've Translated it Thanks to spy520 for sharing
I've translated only the outer look things marked with Unknown means idk it
Link:

Add TQ Baby That Switchs your class here:

Add E.M.E Warrior Weapons System. By E.M.E Here:

How to add Weapons By E.M.E Here:
Hi guys here another usefull guide feel like adding new weapon? here is a full guide step by step of it.

1 - Go to you client ini folder and open weapon.ini ... scroll down and add 5 new weapons ID from normal to super... but u see usually Blades come 41xxxx swords with 42xxxx and staffs 44xxxx oh and don't forget the paladin's which is 49xxxx, so follow the same IDs... TQ max weapons is to 4x0240 - 4x0244 so we chose 4x0250 to 4x0254 for example lets make blades... 410250 - 410254 so scroll down and add


Code:
[410250]
Part=1
Mesh0=410250
Texture0=410250
MixTex0=0
MixOpt0=0
Asb0=5
Adb0=6
Material0=default

[410251]
Part=1
Mesh0=410250
Texture0=410250
MixTex0=0
MixOpt0=0
Asb0=5
Adb0=6
Material0=default

[410252]
Part=1
Mesh0=410250
Texture0=410250
MixTex0=0
MixOpt0=0
Asb0=5
Adb0=6
Material0=default

[410253]
Part=1
Mesh0=410250
Texture0=410250
MixTex0=0
MixOpt0=0
Asb0=5
Adb0=6
Material0=default

[410254]
Part=1
Mesh0=410250
Texture0=410250
MixTex0=0
MixOpt0=0
Asb0=5
Adb0=6
Material0=default2 - open 3DTexture.ini and scroll down then add
Code:
410250=c3/texture/410250.ddsthis is the weapon texture place we will reach the required texture part later...
3 - now we need to add the Mesh file of the weapon which is actully the shape of the weapon so open 3Dobj.ini and add

Code:
410250=c3/weapon/410250.c34 - we finished adding the textures locations and the weapons new ids now we will have to create new effect for this and ability for the weapon to access skills like ... Flying Chops / Chain Chops... which alll this goes under Action3DEffect.ini.. open this folder and add this
Code:
1.350.410.250=a410250+v_r_weapon
1.350.410.250=a410250+v_r_weapon
1.350.410.250=a410250+v_r_weapon
1.350.410.250=a410250+v_r_weapon
1.351.410.251=a410250+v_r_weapon
1.352.410.251=a410250+v_r_weapon
1.350.410.252=a410250+v_r_weapon
1.351.410.252=a410250+v_r_weapon
1.352.410.252=a410250+v_r_weapon
1.350.410.253=a410250+v_r_weapon
1.351.410.253=a410250+v_r_weapon
1.352.410.253=a410250+v_r_weapon
1.350.410.254=a410250+v_r_weapon
1.351.410.254=a410250+v_r_weapon
1.352.410.254=a410250+v_r_weapon
1.999.410.254=a410250+v_r_weapon
2.350.410.250=a410250+v_r_weapon
2.351.410.250=a410250+v_r_weapon
2.352.410.250=a410250+v_r_weapon
2.350.410.251=a410250+v_r_weapon
2.351.410.251=a410250+v_r_weapon
2.352.410.251=a410250+v_r_weapon
2.350.410.252=a410250+v_r_weapon
2.351.410.252=a410250+v_r_weapon
2.352.410.252=a410250+v_r_weapon
2.350.410.253=a410250+v_r_weapon
2.351.410.253=a410250+v_r_weapon
2.351.410.253=a410250+v_r_weapon
2.350.410.254=a410250+v_r_weapon
2.351.410.254=a410250+v_r_weapon
2.352.410.254=a410250+v_r_weapon
2.999.410.254=a410250+v_r_weapon

1.350.410.250=410250+v_r_weapon
1.350.410.250=410250+v_r_weapon
1.350.410.250=410250+v_r_weapon
1.350.410.251=410250+v_r_weapon
1.351.410.251=410250+v_r_weapon
1.352.410.251=410250+v_r_weapon
1.350.410.252=410250+v_r_weapon
1.351.410.252=410250+v_r_weapon
1.352.410.252=410250+v_r_weapon
1.350.410.253=410250+v_r_weapon
1.351.410.253=410250+v_r_weapon
1.352.410.253=410250+v_r_weapon
1.350.410.254=410250+v_r_weapon
1.351.410.254=410250+v_r_weapon
1.352.410.254=410250+v_r_weapon
1.999.410.254=410250+v_r_weapon
2.350.410.250=410250+v_r_weapon
2.351.410.250=410250+v_r_weapon
2.352.410.250=410250+v_r_weapon
2.350.410.251=410250+v_r_weapon
2.351.410.251=410250+v_r_weapon
2.352.410.251=410250+v_r_weapon
2.350.410.252=410250+v_r_weapon
2.351.410.252=410250+v_r_weapon
2.352.410.252=410250+v_r_weapon
2.350.410.253=410250+v_r_weapon
2.351.410.253=410250+v_r_weapon
2.351.410.253=410250+v_r_weapon
2.350.410.254=410250+v_r_weapon
2.351.410.254=410250+v_r_weapon
2.352.410.254=410250+v_r_weapon
2.999.410.254=410250+v_r_weapon

1.350.410.250=aj410250+v_r_weapon
1.350.410.250=aj410250+v_r_weapon
1.350.410.250=aj410250+v_r_weapon
1.350.410.251=aj410250+v_r_weapon
1.351.410.251=aj410250+v_r_weapon
1.352.410.251=aj410250+v_r_weapon
1.350.410.252=aj410250+v_r_weapon
1.351.410.252=aj410250+v_r_weapon
1.352.410.252=aj410250+v_r_weapon
1.350.410.253=aj410250+v_r_weapon
1.351.410.253=aj410250+v_r_weapon
1.352.410.253=aj410250+v_r_weapon
1.350.410.254=aj410250+v_r_weapon
1.351.410.254=aj410250+v_r_weapon
1.352.410.254=aj410250+v_r_weapon
1.999.410.254=aj410250+v_r_weapon
2.350.410.250=aj410250+v_r_weapon
2.351.410.250=aj410250+v_r_weapon
2.352.410.250=aj410250+v_r_weapon
2.350.410.251=aj410250+v_r_weapon
2.351.410.251=aj410250+v_r_weapon
2.352.410.251=aj410250+v_r_weapon
2.350.410.252=aj410250+v_r_weapon
2.351.410.252=aj410250+v_r_weapon
2.352.410.252=aj410250+v_r_weapon
2.350.410.253=aj410250+v_r_weapon
2.351.410.253=aj410250+v_r_weapon
2.351.410.253=aj410250+v_r_weapon
2.350.410.254=aj410250+v_r_weapon
2.351.410.254=aj410250+v_r_weapon
2.352.410.254=aj410250+v_r_weapon
2.999.410.254=aj410250+v_r_weaponwhen u added a weapon with diff ID you will need to change the 410.25 only never touch the 0s or 1s or w/e comes after 410.25
for exmple we are making a weapon with the id 420500 we change the 2.351.410.253=aj410250+v_r_weapon or any other line to 2.351.420.503=aj420500+v_r_weapon

5 - and here we done adding new effect and access to weapons but we need to connect them to the correct weapon which is one of the hardest part.

6 - Open 3DEffect.ini and scroll down then add

Code:
[410250+v_r_weapon]
Amount=5
EffectId0=8001
TextureId0=8001
ASB0=5
ADB0=2
EffectId1=8002
TextureId1=8002
ASB1=5
ADB1=2
EffectId2=8003
TextureId2=8003
ASB2=5
ADB2=2
EffectId3=8004
TextureId3=8004
ASB3=5
ADB3=2
EffectId4=8005
TextureId4=8005
ASB4=5
ADB4=2
Delay=0
LoopTime=999999
FrameInterval=33
LoopInterval=0
OffsetX=0
OffsetY=0
OffsetZ=0

[a410250+v_r_weapon]
Amount=5
EffectId0=8001
TextureId0=8001
ASB0=5
ADB0=2
EffectId1=8002
TextureId1=8002
ASB1=5
ADB1=2
EffectId2=8003
TextureId2=8003
ASB2=5
ADB2=2
EffectId3=8004
TextureId3=8004
ASB3=5
ADB3=2
EffectId4=8005
TextureId4=8005
ASB4=5
ADB4=2
Delay=0
LoopTime=999999
FrameInterval=33
LoopInterval=0
OffsetX=0
OffsetY=0
OffsetZ=0

[aj410250+v_r_weapon]
Amount=5
EffectId0=8001
TextureId0=8001
ASB0=5
ADB0=2
EffectId1=8002
TextureId1=8002
ASB1=5
ADB1=2
EffectId2=8003
TextureId2=8003
ASB2=5
ADB2=2
EffectId3=8004
TextureId3=8004
ASB3=5
ADB3=2
EffectId4=8005
TextureId4=8005
ASB4=5
ADB4=2
Delay=0
LoopTime=999999
FrameInterval=33
LoopInterval=0
OffsetX=0
OffsetY=0
OffsetZ=0this depends from effect to effect some come with 1 some with 5 some with 8 but i used 5 for exmple and the ids 8001 to 8005 is the texture and mesh for the effects which mean on each effect u need to create new IDs for it and add the ids under the effect ID
7 - now we need to add the effects texture and mesh IDs
go to 3DTexture.ini again scroll down and add

Code:
8001=c3/effect/weapon/410250/1.dds
8002=c3/effect/weapon/410250/2.dds
8003=c3/effect/weapon/410250/3.dds
8004=c3/effect/weapon/410250/4.dds
8005=c3/effect/weapon/410250/5.ddsthe open 3DEffectObj.ini and add down
Code:
8001=c3/effect/weapon/410250/1.c3
8002=c3/effect/weapon/410250/2.c3
8003=c3/effect/weapon/410250/3.c3
8004=c3/effect/weapon/410250/4.c3
8005=c3/effect/weapon/410250/5.c38 - now we need to do an easy part which Requires pfj511 itemtype.dat editor or any method you use to add new id on it
open your itemtype.dat with it and add 5 new ids
410250 - 410251 - 410252 - 410253 - 410254
and give them a name for Exmple "EMETestBlade"
if u want a level requirement you can add aswell but make sure u remember each letter you add here for your weapons ID's or else you will fail the next part.
Like this we done all the client side works

so lets go to db side and get it done.

9- Open cq_itemtype on your DB using Navicat and press insert from your keyboard to insert new raw ... add the new 5 ids you added on Itemtype.dat with the same info you aded there aswell like if u added req_level 125 u add on cq_itemtype 125 under req_level and if u add the name "EMETestBlade"
you add exactly the same on Cq_itemtype don't miss any CAPS.

and like this u done adding your weapon info all you need now to add the weapon textures and mesh to your client...

so let say you want to copy the item 410240 "Which is the level 125 TQ blade"

go to c3/Texture search for 410240 and make a copy and name it 410250
then
go to c3/weapon and search again for 410240 make a copy and name it 410250
now we need to add the effect texture and mesh

so go to c3/effect/410109 << This is the effect folder for the weapon 410240.... make a copy and name it 410250 because we named our effect id with that on the INI's and open the folder inside check how many textures and mesh files inside... in other words c3 files

and edit the step 6 and 7 to suit them and here we got a new weapons.... to spawn them use /awarditem command for the ids
410250 Normal - 410251 Refined - 410252 Unique - 410253 Elite - 410254 Super

the Refined to Super appears by the client near the items so itemtype.dat and cq_itemtype has nothing with that just add the name u want like the one on exmple without adding refined to super....



for unpacking more weapons use .dnp unpacker which been released by Bfj511 aswell... and for more weapons you can use TQ other games clients like Zero Online or Crazy Tao... i prefer Zero weapons they rocks XD and unpack the c3 there to view there weapons and place them to your EO client

and i would also like to remind you all :P pressing thanks isn't hard and this is hard thing to do so any question post them on this topic and also thanks to Webert for working with me on the Action3DEffect.ini he done a great help on it to figure the work of it



this guide isn't leeched i wrote it... and i found out how to do all this things so please don't come flame this post ... alpha team dosn't have any credits on this... iam the one who worked on the weapons for them

Make Play.exe work to your Server here:
Your-Ip-Here
;this is config file for play.exe
;change top line to your hostname, that will resolve your ip
;ip will be written to oem.ini and AutoPatch/SocketConfig.ini
;be sure your server is first in oem.ini (Server1)

Open ur ur Play.ini in ur client folder put that in it then follow the instruction
Some Thanks Go to Forcer

How to add Items to your Server Here:
Code:
Here is How to Add items to ur Eo srvr 
Lets Take GS as an example:
1.Go to your cq_goods make a new record put in id ANy Thing Like 789091 in owner id write 1207 that means shoppingmall at the item type id put the god stone pm code,
2.Now open ur make new record cq_itemtype in id put 789091 or what ever the id u want then go to emoney put the price u want there 
3.Edit ur Shop.dat By HexEditing and put ur new item in it
4.Any Questions Post Here(No Asking Abt HexEDITING)
5.Plzzz if THis Guide was usefull to u Senda Thank D:

How to add Euds to your Server here:
ok i have made a One b4 but lots of ppl didnt understand here is a one that i will show every thing in it 
I would Like to say Thank for Funhacker and DarkBebi for teaching Me Every thing

No.1 Client Side

Ok To Add new Eud the Main Side is Client Side Here is what u have to Do

1.You should have the .c3 files But where can be it located in?
answer it should be in c3 folder then monster folder there u will find numbers as 182 much i dont know them all theese c3 files in db are named LookFaces 
theese files u cant make cuze TQ have putted them in a 3d studiomax Extension which i have tried to open with 3d studioMax and it didnt work

2.Ids You should have existing IDS of an eudemon lets take the PandaDemonIDs as an Example

We start With The Egg id
EggId: 1081380
TheID of the Eudemon when it hatches: 1071380
The id of the eudemon when it Evolves: 1071381
the ID of the eudemon when it Evolve the 2ndEvolve: 1071382
The id Of The eudemon when it hatches in Thunder:1079380
the idof the Eudmeon when it evolves in thunder:1079381
the idof the Eudemon when it evolves the second evolve in thunder:1079382

What can i Notice Here?

that the egg id 1081380 contains 81380
in the eudemon id when it hatch the 81380 turns into 71380 then we add 2 more numbers to the 0 so we have the 2 evolves

in the thundereudemon id when it hatches the 81380 changes into 79380 then we add 2 numbers to the 0 so we get the 2 Evolves 

3.Data Folder 
ok DataFolder is the folder which contains the Pic of the EGG and the Petface
hwo can i edit it Open ur DataFolder then Egg Folder Their will be The eggs
The pet face is located in data/Petface folder there is 2 Folders There is 128 and round PetFace the 2 contains the 2 eudmon Faces when its Dead and Alive
there is some thing else u have to add the textures in textures folder which im 100Percent sure that No One can add any Textures of Eud so textures should come with the client files of the eud

Ini and ANI Files here is a list of ini and ANI files u have to put the new eudemon in


3dsimpleRole.ini
3Dsimpleobj.ini
3dmotion.ini
3dobj.ini
3dtexture.ini
armor.ini
petdescribe.ini
dynamicrank,ini
changeegg.ini
itemminicon.ANI
mapitemicon.ANI
petface.ANI

you must also change your shop.dat as well as your Itemtype.dat.
Client Side is Done Then
Code:
Server Side
Server Side is the side of the Database of the eud its so easy i will here Explain all exept cq_action Part cuze i dont know anything about cq_action lol

No.1 Cq_Monster Type

The cq_Monster is the Place where u have to put the new eudemon in cq_monstertype where the new eudemon is known where u have to put the lookface every eudemon has 6 IDS that i explained see what u have to do i will here put only 1 monster type line query

INSERT INTO cq_monstertype
(`id`, `name`, `type`, `lookface`, `length`, `fat`, `life`, `mana`, `attack_max`, `attack_min`, `defence`, `dexterity`, `dodge`, `helmet_type`, `armor_type`, `weaponr_type`, `weaponl_type`, `attack_range`, `view_range`, `escape_life`, `attack_speed`, `move_speed`, `level`, `attack_user`, `drop_money_min`, `drop_money_max`, `size_add`, `action`, `run_speed`, `drop_armet`, `drop_necklace`, `drop_armor`, `drop_ring`, `drop_weapon`, `drop_shield`, `drop_shoes`, `drop_money_chance`, `drop_item_chance`, `magic_type`, `magic_def`, `magic_hitrate`, `atk_hitrate`, `ai_type`, `defence2`, `explode_item_chance1`, `explode_item_chance2`, `explode_item_chance3`, `drop_item_rule`, `profession`, `magic1`, `magic2`, `magic3`, `frequency`, `extra_battlelev`, `extra_exp`, `extra_damage`, `earth_def`, `water_def`, `fire_def`, `wind_def`, `drop_egg_coe`, `drop_weapon_coe`, `drop_armet_coe`, `drop_armor_coe`, `drop_necklace_coe`, `drop_bracelet_coe`, `drop_shoes_coe`, `drop_stone_coe`, `drop_gem_coe`, `drop_explode_coe`, `drop_special_coe`, `special_type`, `drop_deltalev_coe`)
VALUES
(71380, 'PandaDemon', 1, 380, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 15, 0, 1000, 0, 1, 32775, 0, 0, 3, 0, 0, 99, 99, 99, 99, 99, 99, 99, 0, 0, 0, 0, 0, 75, 1, 10000, 0, 0, 0, 0, 323, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

Every time u make a new eudemon u have to edit the lookface and the id 
the monstertype id is the last 5 numbers of the normal id
the look face is the last 3 numbers of the normal ids and put the rest 5 ids 

2.cq_itemtype
it is the place where u will add the ids of the eudemon all of them
here is an example of a cq_itemtype query line

INSERT INTO cq_itemtype
(`id`, `name`, `req_profession`, `level`, `req_level`, `req_sex`, `req_force`, `req_dex`, `req_health`, `req_soul`, `monopoly`, `weight`, `price`, `id_action`, `attack_max`, `attack_min`, `defense`, `magic_atk_min`, `dodge`, `life`, `mana`, `amount`, `amount_limit`, `ident`, `gem1`, `gem2`, `magic1`, `magic2`, `magic3`, `magic_atk_max`, `magic_def`, `atk_range`, `atk_speed`, `hitrate`, `monster_type`, `target`, `able_mask`, `exp_type`, `emoney`)
VALUES
(1071380, 'PandaDemon', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 530, 470, 200, 0, 3000, 2000, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 150, 0, 0, 0, 71380, 0, 3, 1, 0);

u have to add that and the eggbag and the egg
every time u add a new eudemon u have to change the monster_type id in the cq_itemtype and the id and put the rest 5 ids

3.Cq_Grade

it the place where u will add the status wthat the eudemon gets when it hatches then Evolve u can define in it qas u want but every time u add a new eudemon u have to change the id and put the rest 5 ids

INSERT INTO cq_grade
(`id`, `life_a`, `life_b`, `life_c`, `life_grow_a`, `life_grow_b`, `life_grow_c`, `phy_min_a`, `phy_min_b`, `phy_min_c`, `phy_min_grow_a`, `phy_min_grow_b`, `phy_min_grow_c`, `phy_max_a`, `phy_max_b`, `phy_max_c`, `phy_max_grow_a`, `phy_max_grow_b`, `phy_max_grow_c`, `phy_def_a`, `phy_def_b`, `phy_def_c`, `phy_def_grow_a`, `phy_def_grow_b`, `phy_def_grow_c`, `mgc_min_a`, `mgc_min_b`, `mgc_min_c`, `mgc_min_grow_a`, `mgc_min_grow_b`, `mgc_min_grow_c`, `mgc_max_a`, `mgc_max_b`, `mgc_max_c`, `mgc_max_grow_a`, `mgc_max_grow_b`, `mgc_max_grow_c`, `mgc_def_a`, `mgc_def_b`, `mgc_def_c`, `mgc_def_grow_a`, `mgc_def_grow_b`, `mgc_def_grow_c`, `luck_a`, `luck_b`, `luck_c`, `dmg_type`, `rarity`, `metempsychosis`, `reborn_limit`, `rbn_rqr_type`, `auto_trade_type`)
VALUES
(1071380, 188, 188, 0, 3000, 7500, 296, 88, 88, 0, 9400, 23000, 138, 88, 88, 0, 15600, 39000, 46, 88, 88, 0, 9000, 22500, 243, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 88, 88, 0, 5000, 12500, 1844, 50, 100, 200, 0, 380, 0, 9999, 0, 0);

4.Cq_rbn_Type
have no info about that just evry time u add a new eudemon u have to change the ids and put the rest 5 ids


INSERT INTO cq_eudemon_rbn_type
(`id`, `life`, `phy_atk`, `phy_def`, `mgc_atk`, `mgc_def`)
VALUES
(1079380, 1, 1, 1, 0, 1);

5.Cq_eudemon_exgh_egg
its used so u can change the eudemon to an egg from the npc in market that does it every time u add a new eudemon u have to change this itemtype id and putt the rest 5 ids and change the normal id 



INSERT INTO cq_eudemon_exchg_egg
(`id`, `itemtype_id`, `emoney_cost`)
VALUES
(280, 1071380, 1);

cq_totem_pole_type
its where ur eudemon totem the totem wont show up unless u add it in ini file of the totems evry time u add a new eudemon u have to change the id and type and the other 5 ids and types 


INSERT INTO cq_totem_pole_type
(`id`, `type`, `Variety`)
VALUES
(90,1071380, 1);

Cq_Goods 
its where u have to put the EGGBAG id so u buy from shoppingmall

INSERT INTO cq_goods
(`id`, `ownerid`, `itemtype`)
VALUES
(815019, 1207, 815019);
now go in ur eo that u have changed the ini files in and write
/awarditem THEEGGIDHERE

and start hatching ur new eudemon
i know i havent putted anyinfo about the egg bag but soon will when i be 100% sure im putting it working

Here is some Questions PPl asked me:
Why The Hell My New Eud Dont Learn Skilss

------->Here is the Solve<---------------That was my answer

if you want your edu learn the skill you must add new script in the cq_action

first: find the edu skill item in cq_itemtype, at the same lin find the id_action,then find this id number in cq_action

for example windbead item id :1033110 we can define this skill id_action number to 9101000 in cq_itemtype ,then we can creat those script in cq_action


Code:
9101000 9101028 9101001 4003 30000 107107 * 33
9101001 9101028 9101002 4003 30000 107120 * 33
9101002 9101028 9101003 4003 30000 107121 * 33
9101003 9101028 9101004 4003 30000 107122 * 33
9101004 9101028 9101005 4003 30000 107123 * 33
9101005 9101028 9101006 4003 30000 107124 * 33
9101006 9101028 9101007 4003 30000 107150 * 33
9101007 9101028 9101008 4003 30000 107151 * 33
9101008 9101028 9101009 4003 30000 107153 * 33
9101009 9101028 9101010 4003 30000 107154 * 33
9101010 9101028 9101011 4003 30000 107155 * 33
9101011 9101028 9101012 4003 30000 107156 * 33
9101012 9101028 9101013 4003 30000 107172 * 33
9101013 9101028 9101014 4003 30000 107173 * 33
9101014 9101028 9101015 4003 30000 107907 * 33
9101015 9101028 9101016 4003 30000 107920 * 33
9101016 9101028 9101017 4003 30000 107921 * 33
9101017 9101028 9101018 4003 30000 107922 * 33
9101018 9101028 9101019 4003 30000 107923 * 33
9101019 9101028 9101020 4003 30000 107924 * 33
9101020 9101028 9101021 4003 30000 107950 * 33
9101021 9101028 9101022 4003 30000 107951 * 33
9101022 9101028 9101023 4003 30000 107953 * 33
9101023 9101028 9101024 4003 30000 107954 * 33
9101024 9101028 9101025 4003 30000 107955 * 33
9101025 9101028 9101026 4003 30000 107956 * 33
9101026 9101028 9101027 4003 30000 107972 * 33
9101027 9101028 0 4003 30000 107973 * 33
9101028 9101029 0 502 1033110 
9101029 0 0 1010 2005 your edu had learn the winbead skill succeed!107107 * 33 here 107107 is the one edu type id ,one edu has two type id
Code:
107107 means 1071070 1071071 1071072 
107907 means 1079070 1079071 1079072 here 9 is means this edu is thunder type
Code:
33 means only the edu lev over 33 it will beable learn this skill !
Code:
30000 means windbead skill code , you can find this code in cq_migctype table !
Code:
4003 means edu learn type number in cq_action table!
so you can add your edu in the script if your want ! make sure all the skill learn total line number dont over 32 !or it ccant run and the log will show you too game action ,last action 0!!!

Add Legion,Family,Pet and more Ranks to your Site Look here:
Hey PPl Well here I s Those Scripts:
Eud Ranking:
Download This file and extract it in ur www folder in ur wamp then to see ur page of eud go to this page
the EudRankning File Ling Here: Hey PPl Well here I s Those Scripts:
Eud Ranking:
Download This file and extract it in ur www folder in ur wamp then to see ur page of eud go to this page
the EudRankning File Link Here
TopLeigons:
Download This File and Extract it in ur www folder in ur wamp then to see ur page go to here:

the TopLeigonsFile Link HERE

For Player Ranking I think revoloution realesed it i will Just put the playerranking but it is Reevolution not mine
download this file and put it in www folder then u will have this page:
Ranking File: Link HERE

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

the TopLeigonsFile Link HERE

For Player Ranking I think revoloution realesed it i will Just put the playerranking but it is Reevolution not mine
download this file and put it in www folder then u will have this page:
Ranking File:

Manequin DB Guide:
Guide on how to use it:

1.Very simple here, download the whole client+server from the link above
2.Extract it to C:\ or whatever you like
3.Go to yourpath\ManequinFull\mannequin\ and there you see server and mysql folders, launch mysql as usual from winmysqladmin.exe

4.In ManequinFull is the whole client, make a shortcut of soul.exe with parameter blacknull or make a file run.bat edit it and add into it
Code:
@soul.exe blacknull
and launch game from there.

5.Ready account for game user: dark pass: explorer
Code:
Mysql login: root pass: test
By: cyberghoser1

Holloween DB Guide Here: By: thegamer1907

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)

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!!!
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:
Code:
http://www.physics.ohio-state.edu/~p...it/hexedit.exe
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 that is Halloween DB
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 DB.

Now download this file cq_monster translation patch here and download it open it place the files in your server wamp/mysql/data/my2 now your monsters are 90% translated.

All PM Comands Here:
[code]
By: Everybody i Beleve :P

[ITEM ID'S]
101010103

Paladin Items:

Highest Gear
(Super Only)
163094 - Level 91 - Boots - Unknown
143094 - Level 90 - Bracelet - Unknown
133094 - Level 88 - Robe - Unknown
123094 - Level 89 - Necklace - Unknown
113094 - Level 86 - Helm - Unknown
490244 - Level 89 - Ring - Unknown


Warrior Items:

Highest Gear
(Super Only)
111114 - Level 120 - Helm - CavalierHelmet
121114 - Level 120 - Necklace -%
Attached Images
File Type: jpg 5.jpg (23.0 KB, 391 views)
File Type: jpg 6.jpg (43.6 KB, 643 views)
File Type: jpg 005a33.jpg (64.3 KB, 383 views)
mama020153 is offline  
Thanks
27 Users
Old 12/20/2008, 12:43   #2
 
rexes13's Avatar
 
elite*gold: 20
Join Date: Nov 2008
Posts: 1,408
Received Thanks: 405
wtf this guide is only a copy and paste from several guides..but anyway u ve done good work..
rexes13 is offline  
Old 12/20/2008, 15:13   #3
 
PhantomNyte's Avatar
 
elite*gold: 0
Join Date: Jun 2008
Posts: 345
Received Thanks: 179
/agree all this things u sayd here there copyed (as u sayd ) but good job for getting all the links togetter but u didnt put the download links and the pics from pfjs guide and the links from 4 serve rall thing guide try and edit and put all pics but still u get a thx from me for putting all the links togeter i thing its the most complet guide and try and change revolurions guide with a newer one theat has the manequin or the pally with halloween
PhantomNyte is offline  
Old 12/20/2008, 15:36   #4
 
mama020153's Avatar
 
elite*gold: 0
Join Date: May 2008
Posts: 800
Received Thanks: 450
Yea im Still working on the Links Some didnt go through...But i will keep up to Date for you guyz/Girlz
mama020153 is offline  
Old 12/20/2008, 16:21   #5
 
dani-filth0's Avatar
 
elite*gold: 0
Join Date: Oct 2008
Posts: 1,128
Received Thanks: 261
nice work
dani-filth0 is offline  
Old 12/20/2008, 16:40   #6
 
DiobloSlayeR's Avatar
 
elite*gold: 0
Join Date: Jun 2008
Posts: 802
Received Thanks: 341
You claimed some of the things as your work. Like an example: Show You How to Change New Comer Default Settings: By Me. It was actually ahmedpotop aka necron's post, but you claimed as it was your guide "By ME". Remember to give credits to actual poster or the guide maker. Also if you gave the credits, I don't think this is actually a bad idea.
DiobloSlayeR is offline  
Old 12/20/2008, 17:05   #7
 
dani-filth0's Avatar
 
elite*gold: 0
Join Date: Oct 2008
Posts: 1,128
Received Thanks: 261
/agree with diabloslayer
dani-filth0 is offline  
Old 12/20/2008, 17:12   #8
 
mama020153's Avatar
 
elite*gold: 0
Join Date: May 2008
Posts: 800
Received Thanks: 450
Sorry about some things Say me form Copy and paste Still working on that Guyz/Girlz and sorry if it was anybodys posted it says im still geting fixed... But thanks for Leting me know im doing a good Job
mama020153 is offline  
Old 12/20/2008, 17:16   #9
 
rexes13's Avatar
 
elite*gold: 20
Join Date: Nov 2008
Posts: 1,408
Received Thanks: 405
u should have written where the credits go...
rexes13 is offline  
Old 12/20/2008, 17:21   #10
 
mama020153's Avatar
 
elite*gold: 0
Join Date: May 2008
Posts: 800
Received Thanks: 450
i Am...
mama020153 is offline  
Old 12/20/2008, 17:33   #11
 
rexes13's Avatar
 
elite*gold: 20
Join Date: Nov 2008
Posts: 1,408
Received Thanks: 405
no u didnt..
rexes13 is offline  
Old 12/20/2008, 18:04   #12
 
mama020153's Avatar
 
elite*gold: 0
Join Date: May 2008
Posts: 800
Received Thanks: 450
Go Check the Work now i Updated all the Info now the Stuff Made by other people is Fixed and just to let you know Thanks for telling me i did a good Job and all but you do nothing but complain now i see why nobody here helps you...
mama020153 is offline  
Old 12/20/2008, 18:40   #13
 
rexes13's Avatar
 
elite*gold: 20
Join Date: Nov 2008
Posts: 1,408
Received Thanks: 405
now not before..
rexes13 is offline  
Old 12/20/2008, 18:51   #14
 
mama020153's Avatar
 
elite*gold: 0
Join Date: May 2008
Posts: 800
Received Thanks: 450
See If you would have Read my Treats i put Still Updateing the Files pls Give me time.
You: "no u didnt.."
...
mama020153 is offline  
Old 12/20/2008, 20:32   #15
 
rexes13's Avatar
 
elite*gold: 20
Join Date: Nov 2008
Posts: 1,408
Received Thanks: 405
Quote:
Originally Posted by mama020153 View Post
See If you would have Read my Treats i put Still Updateing the Files pls Give me time.
You: "no u didnt.."
...
ok bro take ur time.......
rexes13 is offline  
Closed Thread


Similar Threads Similar Threads
Pserver all Things GUIDE
07/03/2010 - EO PServer Guides & Releases - 199 Replies
First i Would like to thank ppl who helped me cuz 60% of the Guide Copied From Them Onother 40% my Work 1.How To Make a Pserver Noobs Guide : By Revolution Ok everyone, I hope you can find this as simple as I wish I did.... Im going to teach you how to create your own private server. First of all I want to say thank you to Hot_Place, GunShot, and a few others for teaching me everything I know now. One more thing, please dont critisize this post, and if you use my guide thank me......
Pserver All things Guide[UPDATED]
06/27/2010 - EO PServer Guides & Releases - 90 Replies
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 :D 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...



All times are GMT +1. The time now is 16:48.


Powered by vBulletin®
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2025 elitepvpers All Rights Reserved.