Pserver all Things GUIDE

05/28/2008 20:25 ahmedpotop#1
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... please

Now we begin.....
The first 5 steps are downloads.
1. Download your Eudemons Online client, if you already have it great!
Click [Only registered and activated users can see links. Click Here To Register...]"" for client download. .

Eudemons patch 1091 Download [Only registered and activated users can see links. Click Here To Register...]
Note: Must be disconected from internet when running patch, or it will auto patch till the newst TQ client)


2. If you have anything other then [Only registered and activated users can see links. Click Here To Register...]remove it. I only know how to use wamp. It also
has mySQL version 4.0.1, wich makes it so the legion run fine. Install to your C:/ (C:/wamp)

3.Create a new folder in your C:/ named "Serv.Programs"
Download database files and Server Programs. I will have 2 server files you can download. The first one named [Only registered and activated users can see links. Click Here To Register...] is
the database files I use, wich are translated. But grammar work needs to be done. lol
The second one named [Only registered and activated users can see links. Click Here To Register...] is the basic database files where nothing is translated(youll have to
start from scratch):/ Extract this into C:/Serv.Programs/
Download ""[Only registered and activated users can see links. Click Here To Register...] for Server Programs like Accserver.exe, Msgserver.exe, and NPCServer.exe. Extract these to your Serv.Program folder you created earlier.

4. The next download you will need is Navicat. This program is used for editing your database files
and translating. This Link [Only registered and activated users can see links. Click Here To Register...] )

5. If you want to run your server with Hamachi, you will need to download the program ""[Only registered and activated users can see links. Click Here To Register...]"".
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:/Serv.Programs/ then copy and paste the "my" 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.
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 Serv.Program files. So go to C:/Serv.Programs/ 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.


[Account1]
SERVERNAME=servernamehere
LOGINNAME=root
PASSWORD=test
FREE_DEBUG=3


13. Then open your config.ini, then edit it like in the pic below.



[System]
LOGINLISTENPORT = 9958
POINTLISTENPORT = 9870
SERVER_FULL_DELAY_SECS = 5000
SERVER_BUSY_DELAY_SECS = 3000
SERVERTITLE = servernamehere
SERVERNAME = servernamehere
LOGINNAME = root
PASSWORD = test
SERVERIP = Your-IP-address

[Database]
DBHOSTNAME=127.0.0.1
DATABASENAME=my
DBUSER=root
DBPASSWORD=test


14. Now you will have to go to C:/Serv.Programs/GameServer/
First open your config.ini and edit it to look like this



; 配置文件


[System]
SERVERNAME = servernamehere
MONSTER_ACTIVE_LIMIT = 4000

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

[GameServer]
GAMESERVER_IP = your-IP-address

GAMESERVER_PORT = 5816
SND_SIZE = 64000
RCV_SIZE = 16000

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



[Database]
DB_IP = 127.0.0.1
DB_USER = root
DB_PW = test
DB_NAME = my

LOGIN_KEY = dfkKO23k'[cvK934

[InternetPort]
MASTER_IP = your-IP-address
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


; 外壳配置文件
; 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 = root
DB_PW = test
DB_DB = my


[AccountServer]
ACCOUNT_IP = your-IP-address


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

LOGIN_KEY = dfkKO23k'[cvK934

[InternetPort]
MASTER_IP = your-IP-address
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. Download link above.
Right click on the Navicat screen and go to new connection. For the connection name go ahead and put what ever your server name is. And for the
IP address out either your hamachi or PC's IP address, wich ever you choose to use in the begging. And leave the port default, I think its port 3306.
Then for your user put 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 where it says then user root@localhost double click it. It should open up and have 4 databases. Mysql, Test, ACcount, and MY.
Click on the account database, then click select all. Save it once you do that. Do the same thing for the database My.

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 user 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
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:/Serv.Programs/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:/Serv.Programs/GameServer/ and run your MsgServer.exe, then your NPCServer.exe. These ones take alot longer to load upo then the
accountserver.exe, so be patient.

23. Now you will you will need to make yourself an account. Use this command in your mysql command client

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 [Only registered and activated users can see links. Click Here To Register...]then..go to navicat,account and account it should be like this account@account,after that write the pass and Id there


[SIZE="6"]How To Put A Reg Script In ur Server:[/SIZE] 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

[Only registered and activated users can see links. Click Here To Register...]

Or if you want to give reg page to others use
ur ip adress here/register.php

Thanks would be appreciated :]

[Only registered and activated users can see links. Click Here To Register...] link:[Only registered and activated users can see links. Click Here To Register...]
php.rar link:[Only registered and activated users can see links. Click Here To Register...]

How To Put Tqs Script In ur Server By Me
I got Tqs Home Page Script It is There but needs a Lot Of Work here i will put the link of the [Only registered and activated users can see links. Click Here To Register...]
extract it in ur www folder in ur wamp folder then open the apache,to see that page go here [Only registered and activated users can see links. Click Here To Register...]
www rara link [Only registered and activated users can see links. Click Here To Register...]

To Get LeigonRanking,EudRanking,PlayersRanking By Me

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 [Only registered and activated users can see links. Click Here To Register...]
the EudRankning File Link [Only registered and activated users can see links. Click Here To Register...]

TopLeigons:
Download This File and Extract it in ur www folder in ur wamp then to see ur page go to here: [Only registered and activated users can see links. Click Here To Register...]

the TopLeigonsFile Link [Only registered and activated users can see links. Click Here To Register...]

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: [Only registered and activated users can see links. Click Here To Register...]
Ranking File: Link [Only registered and activated users can see links. Click Here To Register...]

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

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 Me

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 Me

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 Me(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 [Only registered and activated users can see links. Click Here To Register...]

Show You How To Add Eud in Ur Server: By Me 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:

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

Some Thanks Go to 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

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:

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:

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;

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 Me
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
Solve--> make the website in the oem this simpol -

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 MSG server that supports Up to 6000* more than That and the eud start will Deacrease [Only registered and activated users can see links. Click Here To Register...]

Soon More Proplems will be Placed Here i Just Made this Post and IM Tottally Sleepy so it is not Perfect so Soon More

If you Have More Questions Post Here


Mice Eud By hacileveli
Download This Sqql Script From [Only registered and activated users can see links. Click Here To Register...]
Then Download Theese 2 Patches From [Only registered and activated users can see links. Click Here To Register...]-[Only registered and activated users can see links. Click Here To Register...]

FourSummonStone By haciveli
Download This Sql Script From [Only registered and activated users can see links. Click Here To Register...]

Dye Systems By funhacker
Download the Files From [Only registered and activated users can see links. Click Here To Register...]


To Make A Site To Be Like Obaneo.co.nr:By Me

First Make ur Site using [Only registered and activated users can see links. Click Here To Register...]
then go to this site [Only registered and activated users can see links. Click Here To Register...] Put ur FreeWebs Site there and it Will Redirect it so it be Like ur FreeWebs site but .co.nr

To Make a Fourm: By Me

Just go to This Site and Make a One [Only registered and activated users can see links. Click Here To Register...]

.To Make A chat Box : By Me

Just Make a one From Here and Put its Code in ur Website [Only registered and activated users can see links. Click Here To Register...]



Any Questions Just Post here

Enjoy
05/28/2008 20:32 Rawsteeey#2
Just wonderfull!
Really good choice to make it sticky! PS: I send msg to mod to make it sticky :P

so rly good !
05/28/2008 20:57 IcedEarth#3
wow.. how many tuts did you leech this from?
05/28/2008 23:03 theahmahm#4
thanxxx vm

this is great
05/29/2008 00:01 ahmedpotop#5
47 views not even 1 thank
05/29/2008 02:54 apoxdeath#6
Quote:
Originally Posted by ahmedpotop View Post
47 views not even 1 thank
cuz there is lik 10 other guides out there....urs is no diff then the others and there are easier releases :)
05/29/2008 03:28 ahmedpotop#7
but there is no Guide with all theese things
05/29/2008 17:32 Bongkerz#8
ye but wat u have post has been ripped from other ppls threads so its not realy ur work, only ur time in putting all info in1 thread which really a good idea but none of its ur work and therefore no thanks should be given or unless someone is in a good mood and feels like making u happy.
05/29/2008 17:37 ahmedpotop#9
at least a Thank Cuz I collected All theese guide into 1
05/29/2008 22:25 PsykoChyld#10
hey ahmedpotop leave me a message on here i can give you a link to a version of navicat that wont expire and is a "thinstall" version. No its not hacked or cracked or anything like that.
05/29/2008 22:34 ahmedpotop#11
What is the Link
05/29/2008 22:54 spy_dude2000#12
navicat lite....
05/30/2008 14:41 liviu_wwe#13
all things work fine but i have a problem with navicat are expired and it dont work
help me please
05/30/2008 19:43 spy_dude2000#14
use navicat lite , google it .....
05/30/2008 21:16 ahmedpotop#15
Man use Navicate Lite