[Release] Zhu Xian 2 - 9 Classes - mySQL Server Enabled

Setup instructions:

(Note: this server is for VMWare)

Start the virtual machine and login with the following:
username: root
password: ragezone

The VM is set to bridged so you may or may not have to change that.

This server is set at 192.168.0.103 and you may have to change it for your system
(just google how to do this). After logging into the server, enter:
> ifconfig
to see your IP address.

Using WinSCP go to /opt/lampp/htdocs/zx.php and change the below bolded lines to your IP.
If the database name is "zx" change it to "sm"

$DBHost = "192.168.0.103"; // Host IP
$DBUser = "root"; // database user
$DBPassword = "123456"; // database password
$DBName = "zx"; // database name
$ServerIP = "192.168.0.103"; // server IP
$ServerPort = "29000"; // server port

Do the same with /opt/lampp/htdocs/config.php

$DBHost = "192.168.0.103";
$DBUser = "root";
$DBPassword = "123456";
$DBName = "sm"; // this is "zx" but should be "sm"

And finally change the following file found at /opt/lampp/htdocs/yb/conn.php

<?php
mysql_connect("192.168.0.103","root","123456"); // connect to MySQL
mysql_select_db("sm"); // select database
?>

Start the server with:
> ./start

You can access the registration page at http://192.168.0.103/register.php (replace the bold text with your IP address).

Let me know if you have any problems with it and I'll see what I can do to help.

MediaFire Links (18 parts)
Part 1 zx2mysql.part01.rar --- Part 10 zx2mysql.part10.rar
Part 2 zx2mysql.part02.rar --- Part 11 zx2mysql.part11.rar
Part 3 zx2mysql.part03.rar --- Part 12 zx2mysql.part12.rar
Part 4 zx2mysql.part04.rar --- Part 13 zx2mysql.part13.rar
Part 5 zx2mysql.part05.rar --- Part 14 zx2mysql.part14.rar
Part 6 zx2mysql.part06.rar --- Part 15 zx2mysql.part15.rar
Part 7 zx2mysql.part07.rar --- Part 16 zx2mysql.part16.rar
Part 8 zx2mysql.part08.rar --- Part 17 zx2mysql.part17.rar
Part 9 zx2mysql.part09.rar --- Part 18 zx2mysql.part18.rar

FileFactory Mirror
Part 1 http://www.filefactory.com/file/3fvm...sql_part01_rar --- Part 10 http://www.filefactory.com/file/5uln...sql_part10_rar
Part 2 http://www.filefactory.com/file/5ql9...sql_part02_rar --- Part 11 http://www.filefactory.com/file/7iaj...sql_part11_rar
Part 3 http://www.filefactory.com/file/4z3y...sql_part03_rar --- Part 12 http://www.filefactory.com/file/8s1a...sql_part12_rar
Part 4 http://www.filefactory.com/file/664v...sql_part04_rar --- Part 13 l]http://www.filefactory.com/file/10qd...sql_part13_rar
Part 5 http://www.filefactory.com/file/2iee...sql_part05_rar --- Part 14 http://www.filefactory.com/file/7ii4...sql_part14_rar
Part 6 http://www.filefactory.com/file/5mf4...sql_part06_rar --- Part 15 http://www.filefactory.com/file/4gxd...sql_part15_rar
Part 7 http://www.filefactory.com/file/1vyn...sql_part07_rar --- Part 16 http://www.filefactory.com/file/6kfs...sql_part16_rar
Part 8 http://www.filefactory.com/file/4j5v...sql_part08_rar --- Part 17 http://www.filefactory.com/file/1yk5...sql_part17_rar
Part 9 http://www.filefactory.com/file/4g91...sql_part09_rar --- Part 18 http://www.filefactory.com/file/5on6...sql_part18_rar

Let's try and work out the bugs!:thumbup1:

Edit:
Patching with the following worked for me on a v2.2.8 client.
http://www.filedropper.com/clientpatch

Also, these are in chinese and need to be translated:
NPC names
Quest Names
Cash Shop

...

nice work i'll try is, thanks

Is this converted via my 422 MYSQL guide?

Do you know where can I download client for that server?

thanks for sharing, edited the configs you explained in 1st post and could login flawless.
now to find out what is working and what not :)

the link 14 it not work, can u upload new link thanks

you can share source for mysql ?
thanks

Right now I'm working on putting together an English language client that'll work with this server.

im actually using the installer from the official jade dynasty site i just didnt let it patch the client.
everything is in english xcept for the itemdescriptions in the cash shop

Quote:

---

Originally Posted by beyastard

Setup instructions:
[snip]

$DBHost = "192.168.0.103"; // Host IP
$DBUser = "root"; // database user
$DBPassword = "123456"; // database password
$DBName = "zx"; // database name
$ServerIP = "192.168.0.103"; // server IP
$ServerPort = "29000"; // server port

Do the same with /opt/lampp/htdocs/config.php

$DBHost = "192.168.0.103";
$DBUser = "root";
$DBPassword = "123456";
$DBName = "sm"; // this is "zx" but should be "sm"

And finally change the following file found at /opt/lampp/htdocs/yb/conn.php

<?php
mysql_connect("192.168.0.103","root","123456"); // connect to MySQL
mysql_select_db("sm"); // select database
?>

---

I'd recommend using "localhost" as the DBHOST... Saves from having to do guess work.

Mirror added for your convenience...

nice finally we have newer server for JD.. hope we can get most of the files into English ;) can i ask it is this server files uses the same RAM(memory) as the old one? that uses only 1.5GB for the DB to work property?

thank's i will try it.. and posting if i found bug..

this's 997 version,from mcncc.com

this server my be only use Red hat linux.. i try to use ubuntu 11 not work.. get eroor on gs..

this server is harder then loc123 server, is there any video guide for this new server =P

how can this be harder lol OP showed exactly wich files to edit with your ipadress and if you edit exactly like it says in the 1st post this vm image works perfect

Agreed. This server is ten times easier to install.

yes.. but not tool for this server.. only tool 1.3.6 server

How to enter in WinSCP? I enter 127.0.0.1, port: 22, User name: root, Password: ragezone, File protocol: SFTP. Vmware enabled.
http://s019.radikal.ru/i606/1203/76/31425fbf2fb4.jpg

Quote:

---

Originally Posted by extazy20

How to enter in WinSCP? I enter 127.0.0.1, port: 22, User name: root, Password: ragezone, File protocol: SFTP. Vmware enabled.
http://s019.radikal.ru/i606/1203/76/31425fbf2fb4.jpg

---

it's not 127.0.0.1, it is your redhat IP

How to change ip to your system? srry for asking, can anyone help me.Ty
Aleardy googled but...

How to change IP Address on Linux Redhat | Linglom.com took me a whole 3 secs to google....

on a sidenote anyone want to point me in the direction how to change exp/drop rates?
i tried a search and i found the race_player thing but it gives me a stream read error when i try to save so im guessing it just cant read the elements.data properly.

Quote:

---

Originally Posted by morbitangel

How to change IP Address on Linux Redhat | Linglom.com took me a whole 3 secs to google....

on a sidenote anyone want to point me in the direction how to change exp/drop rates?
i tried a search and i found the race_player thing but it gives me a stream read error when i try to save so im guessing it just cant read the elements.data properly.

---

To my internal or external ip?
also i tink exp are modi for ptf template ,saw something about in mcncc forum

ptemplate.conf never worked for editing rates actually tried that last night for fun and giggles.
and you shouldnt put you internal or external ipadress in the vm you should give it a ipadress thats on the same subnet as your computer itself so you can use winscp to connect to it.

Thanks, but how to get to the desktop in Red Hat?

Quote:

---

Originally Posted by extazy20

Thanks, but how to get to the desktop in Red Hat?

---

that is server OS.. only use command, no dekstop like windows.. u need learn abaout linux..
http://docs.redhat.com/docs/en-US/Re...l-started.html

nvm i got it work thanks but how to set GM with winscp

Having a problem downloading a working english client - when I get the one from PWI is
v328 - and without updating if I try to connect to any official server it says it's v3.0.1 build 1318. Could someone post up a link to where they downloaded their client from please?

EDIT: Found one on Gamershell, downloading now.

Quote:

---

Originally Posted by beyastard

Right now I'm working on putting together an English language client that'll work with this server.

---

I have the english version of 2.2.8 but it seems the elements.data, gshop.dat etc do not compatible with the server?

http://forum.ragezone.com/attachment...1&d=1332907676

Quote:

---

Originally Posted by Sh1mmy

I have the english version of 2.2.8 but it seems the elements.data, gshop.dat etc do not compatible with the server?

http://forum.ragezone.com/attachment...1&d=1332907676

---

See first post at the bottom for the "patch" that includes the element.data and gshop.data for the client.

Quote:

---

Originally Posted by Sh1mmy

I have the english version of 2.2.8 but it seems the elements.data, gshop.dat etc do not compatible with the server?

http://forum.ragezone.com/attachment...1&d=1332907676

---

upload element.data gshop, from client to u server.. that cant work.. and i have test work fine:thumbup1:

Quote:

---

Originally Posted by Sebastain007

upload element.data gshop, from client to u server.. that cant work.. and i have test work fine:thumbup1:

---

That don't work I'd tried both way uploaded elements.data etc..from client to server, server to client...still no work it seems server one is abit newer version I think
Posted via Mobile Device

Quote:

---

Originally Posted by Sh1mmy

That don't work I'd tried both way uploaded elements.data etc..from client to server, server to client...still no work it seems server one is abit newer version I think
Posted via Mobile Device

---

only client 2.2.8 Build 1309 mybe work.. i have tired version 2.2.8 Build 1309 indonesia version.. work perfect

sadly im a nub at this i have sucessfully loaded server into vmware and i did the ifconfig and i get the address of 127.0.0.1 which is localhost is that an error? also to log into it via winscp what would my host, port, username and password would be thanks.


Nvm I have found out how to work it the only thing is alot of it still in chinese, do you have any version that has more english?

Quote:

---

Originally Posted by Sebastain007

only client 2.2.8 Build 1309 mybe work.. i have tired version 2.2.8 Build 1309 indonesia version.. work perfect

---

Nope not mine if you check my attachment you'll see my version and elements nor the gshop don't work on the server side . The gs won't load when executed or the client side gave an error when launched
Posted via Mobile Device

I have problem
err : glinkd::disconnect from gameserver. gameserver 1, sid=20
info : GameDBServer::OnDelSession, sid=18.
err : gdelivery::Erase gameserver 1,sid=86
TRACE : SiegeManager OnDisconnect: gs_id=1, status=1
TRACE : Territory gs 1 disconnected

Link No free lines

anyone successfully changed the exp rate? i keep getting a "stream read error" when trying to edit the exp with race_player_TT
any tips/hints would be appreciated

found these npcgen on mcncc.com they add some missing npc's to sunstream that i didnt see in this release like the jade exchange maiden and lonzan imperial agent

I am currently working on a custom linux build that will have the necessary scripts to automate the entire setup. I'll post it when it's complete and tested.

Quote:

---

Originally Posted by mo0mo0

sadly im a nub at this i have sucessfully loaded server into vmware and i did the ifconfig and i get the address of 127.0.0.1 which is localhost is that an error? also to log into it via winscp what would my host, port, username and password would be thanks.


Nvm I have found out how to work it the only thing is alot of it still in chinese, do you have any version that has more english?

---

If you are using a router use the following to set your IP

> dhcpcd eth0

I would like to know like just say I edited element.data i know exactly where to place it in my client...but where would it locate in my server? also is it normal that im using JD from perfectworld client I get some english and alot in chinese...does the name and such in english depend on my client or my server?

Quote:

---

Originally Posted by beyastard

I am currently working on a custom linux build that will have the necessary scripts to automate the entire setup. I'll post it when it's complete and tested.



If you are using a router use the following to set your IP

> dhcpcd eth0

---

Thanks for reply i have figured out last night and server is running great.

I finally look thru my whole system and found a backup of my ENG_2.2.8

Yup. It's working! :ott1:


http://forum.ragezone.com/attachment...1&d=1332998728

Quote:

---

Originally Posted by Sh1mmy

I finally look thru my whole system and found a backup of my ENG_2.2.8

Yup. It's working! :ott1:


http://forum.ragezone.com/attachment...1&d=1332998728

---

Shimmy is there a way to contact you... i got my server working but its all in chinese name mind sharing your insider tips?

How to change EXP rate.

Will the owner of this thread work with me? Im currently working on the project to have this server perfected I have host already with atleast 100mb connection so please let me know if we can partner up somehow and make a sucessful server

Senks all work fine

Quote:

---

Originally Posted by AlexProo

Senks all work fine

---

it seem like everyone get stuff to work for them but im just wondering how to set gm and also where the gm panel is at ig if anyone can give me a direct contact such as yahoo messenger or any other option to chat that will be great.

search for a program called batgm it allows you to set accounts as gm and/or ban accounts and view wich accounts are online

Thanks for the answer, Alex has helped me out with the gm section anyone know how to set the drop rate and exp rate for this server? and when i make an update to element.data and i want to auto patch my client with it how can i do so?

Quote:

---

Originally Posted by morbitangel

search for a program called batgm it allows you to set accounts as gm and/or ban accounts and view wich accounts are online

---

still trying to find a tool to set the rates myself since i cant find a tool that can actually properly read my elements.data.
the elements.data im using is basically already completely in english minus item descriptions in cash shop but the npc's quests etc are already all in english. ill attach my elements and gshop for anyone interrested.
im using a clean retail client from english jade dynasty

since 99% already is in english in my elements.data i would ofc much rather find a tool that can actually read it than have to work with a chinese elements.data and have to translate everything xD

Quote:

---

Originally Posted by morbitangel

still trying to find a tool to set the rates myself since i cant find a tool that can actually properly read my elements.data.
the elements.data im using is basically already completely in english minus item descriptions in cash shop but the npc's quests etc are already all in english. ill attach my elements and gshop for anyone interrested.
im using a clean retail client from english jade dynasty

since 99% already is in english in my elements.data i would ofc much rather find a tool that can actually read it than have to work with a chinese elements.data and have to translate everything xD

---

Thanks for the great data package, i know where to place this in the client side but how bout the server side for this typical server which directory I would put it or how would i make this data to be auto patched into my clean jd?

Quote:

---

Originally Posted by mochi

How to change EXP rate.

---

open the file /usr/zx2/gamed/ptemplate.conf and change the following lines:

#exp_bonus = 0
#sp_bonus = 0
#money_bonus = 0

again like i said in 2 other threads changing the exp rate in ptemplate.conf doesnt work.

/usr/zx2/gamed/config is where the data files are server side( reply to mo0mo0's question)

Quote:

---

Originally Posted by morbitangel

still trying to find a tool to set the rates myself since i cant find a tool that can actually properly read my elements.data.
the elements.data im using is basically already completely in english minus item descriptions in cash shop but the npc's quests etc are already all in english. ill attach my elements and gshop for anyone interrested.
im using a clean retail client from english jade dynasty

since 99% already is in english in my elements.data i would ofc much rather find a tool that can actually read it than have to work with a chinese elements.data and have to translate everything xD

---

You can share tools fix NPC,Gshop,...elements.data for me? Please? thank you very much

Quote:

---

Originally Posted by morbitangel

again like i said in 2 other threads changing the exp rate in ptemplate.conf doesnt work.

/usr/zx2/gamed/config is where the data files are server side( reply to mo0mo0's question)

---

cool great, do you have a way to do auto patcher like the darknight comming thread? seem very easy that way but i guess since he put alot of work into his server already...


btw the exp editing dont work ive tried it couple of times still nothing

editing ptemplate.conf has never worked as far as i know not even on the older version of the files.
ppl used race_player_TT to change rates but i cant get it to save my elements.data after i change the exp rate.
im guessing the elements.data is in a newer format than the program can read.
there's probably some auto-updater for the client on mcncc.com but it will be in chinese i can have a look around later today.

hey morbit how do you use the file that you posted on page 3 for the missing npc... i placed that into my server and client and still those npc dont show up? kindda odd i placed under usr directory

uhm did you overwrite the old ones or just extracted the folders to usr? cos youre supposed to copy the npcgen files inside those folders to the server side so for example in the archive theres a folder called "z1" inside that is a npcgen file now on your server you have a folder called /usr/zx2/gamed/config/z1 inside it is also npcgen overwrite that with the one from the archive and do the same for the other 2

Quote:

---

Originally Posted by beyastard

open the file /usr/zx2/gamed/ptemplate.conf and change the following lines:

#exp_bonus = 0
#sp_bonus = 0
#money_bonus = 0

---

With # or remove
#exp_bonus = 5000
#sp_bonus = 2000
#money_bonus = 3000
or
exp_bonus = 5000 <-- not work
sp_bonus = 2000
money_bonus = 3000

Quote:

---

Originally Posted by morbitangel

uhm did you overwrite the old ones or just extracted the folders to usr? cos youre supposed to copy the npcgen files inside those folders to the server side so for example in the archive theres a folder called "z1" inside that is a npcgen file now on your server you have a folder called /usr/zx2/gamed/config/z1 inside it is also npcgen overwrite that with the one from the archive and do the same for the other 2

---

i overide it inside the corresponding folder but still nothing....i noticed out in the config directory there is also a file called npcgen should i leave it alone?

i only overwrote the 3 npcgen in my server that matched the ones in the archive nothing more
so z1/z2/z3 folder those npcgen i never touched the one thats in config

Tell me the reason why I do follow your direction but not yet?

Quote:

---

Originally Posted by morbitangel

i only overwrote the 3 npcgen in my server that matched the ones in the archive nothing more
so z1/z2/z3 folder those npcgen i never touched the one thats in config

---

once again to confirm is it z3 or z23?

its 23 typo on my part ><

also btw what client u use and can you also post me your gshop and element file if possible thanks

because i dont get it i use the official version of jd as stated

http://forum.ragezone.com/6928449-post50.html
im using the official jd client without letting the updater run

Anyway to add GM ? cause i never seen this phpsqlite thing before,neither know how to use it

the weird thing is this...i reinstalled the client to a fresh perfectworld client, deleted element.data and all the shop.data and replace it with yours on client side and server side, on server side i went to z1,z2,z23 and replace it with your file when i go in game still donot see all the missing npc.

Adding the z1,2 and 23 made me cant login no more,so i wont be using it..

Quote:

---

Originally Posted by Pronetix

Anyway to add GM ? cause i never seen this phpsqlite thing before,neither know how to use it

---

use batgm

Is it just me or everyone else that this server only allow you to load just one realm?
Posted via Mobile Device

Anyone Know's How to change rates?

Quote:

---

Originally Posted by Pronetix

Anyone Know's How to change rates?

---

Ohh me need too

Quote:

---

Originally Posted by morbitangel

search for a program called batgm it allows you to set accounts as gm and/or ban accounts and view wich accounts are online

---

BatGM not work for me i dont known why, im use windows 7 is this batGM work with all windows?:O::?:

BatGM worked,found some 100x rates elements data ,everything goes well,next on list,How to spawn citadel npc,Maiden and teritory guy?

Quote:

---

Originally Posted by Pronetix

BatGM worked,found some 100x rates elements data ,everything goes well,next on list,How to spawn citadel npc,Maiden and teritory guy?

---

On page 3 download morbitangel's attachment file and upload to your server config folders.
Posted via Mobile Device

Only server side ?

Quote:

---

Originally Posted by Pronetix

Only server side ?

---

Yes.
Posted via Mobile Device

Thanks you :)

I'm so frustrated right now. Has anybody had tried to run this server on a clean install Ubuntu server? I have! but no luck of getting these errors out of the way:::::

gdelivery:: connect GameDB failed.
gdelievery::connect to GAuth server failed. Reconnecting....

Any Ubuntu expert knows how to solve this problem? lol
Give me some advises or your pro solutions! hehehe
If not, imma go with clean RedHat ..........................

dude what did you set the password to for mysql? cause we are trying to add phpmyadmin and it wont let is log into the mysql.

Quote:

---

Originally Posted by jamezilla

dude what did you set the password to for mysql? cause we are trying to add phpmyadmin and it wont let is log into the mysql.

---

Pass is 123456

Quote:

---

Originally Posted by jamezilla

dude what did you set the password to for mysql? cause we are trying to add phpmyadmin and it wont let is log into the mysql.

---

as "root" ?

we tried 123456

Login: root
Pass: 123456
Database: sm

It works fine for me.

vm idk whats wrong with my pc but winscp wotn even log in i uninstalled and reinstalled i cant get ping....its a mess it was working fine before and idk where loc is he hasnt been responding

Add me on skype. I will do it for you tomorrow.

Henmoro is there a way i can contact you directly? via skype or yahoo needed some assitants

here is my client JD OFFICIAL 2.2.8 build 1309
Copied the element @ gshop data to both server
Copied z1 z2 z23 to server

...................................................
Boot up login great!
NPC still missing

This is what it look like in my game missing the portal to fair

http://ledfive.com/images/moo.bmp

this is fully working for me,with all NPC's and with 100x exp rates :) thanks for the awesome release
NOTE : there are ALOT of bugs like,last t5 part(wont teleport me at skyscream)

http://i41.tinypic.com/2lsaa2q.jpg

its the path datas

thank.I'll try. ;)

Who cnow how change EXP rate?
tools for gs?

Quote:

---

Originally Posted by AlexProo

Who cnow how change EXP rate?
tools for gs?

---

search in page 3 beyastar already post it.

Who know how to set noob charracter with lvl 150 no need to train?:D:

Quote:

---

Originally Posted by zoneoflove

search in page 3 beyastar already post it.

Who know how to set noob charracter with lvl 150 no need to train?:D:

---

Where?

http://s019.radikal.ru/i613/1204/49/1527ca3335f5t.jpg
does not connect to the database and do not get connected using winscp

Quote:

---

Originally Posted by kimigura

http://s019.radikal.ru/i613/1204/49/1527ca3335f5t.jpg
does not connect to the database and do not get connected using winscp

---

What worked for me when i first ran the server and the blue screen pops up for hardware setup, i chose to remove the old network configs, then config them again, and there where it asks your ip and stuff i chose the automatic one on the top (press space to select it) and then ok. after that i was able to config the network properly.

Still trying to find a way to change the XP rates =/

Thanks

No i need tools for change EXP my server in Russian
Please give me PM

how can i set gm for my account, i heard somebody said that to use batgm, but i don't know where is it? Please somebody help me!!

Quote:

---

Originally Posted by nhatminh312

how can i set gm for my account, i heard somebody said that to use batgm, but i don't know where is it? Please somebody help me!!

---

batgm0.8.zip

There you go :)