Video Guide C9 - Server + Databases setup

https://www.youtube.com/watch?v=L_7G...s#action=share

http://www.mediafire.com/download/r2...tc/C9-Mssql.7z

Thanks to lastfun and everyone who contributed to fix the files!

Game files and guide is provided here in the post:

https://forum.ragezone.com/f857/rele...ml#post8528791

Started with a fresh VM and installed dotnet 4.0:
Microsoft Mssql Server here is a Link:

https://www.microsoft.com/en-us/down....aspx?id=30438

Select this Version: SQLEXPRWT_x64_ENU.exe on the following screen.

Here are the bat files used to update the odbc connection: Remember must run them as Administrator!

https://www.mediafire.com/folder/63b832v38vjj2/c9

I still have connection problem using my VPS I followed your tutorial but still no luck but when I use my PC as local it work just my VPS not working

Check your fire wall that the ports are open fir vps.

Sent from my SM-N900T using Tapatalk

Quote:

---

Originally Posted by luis R

I still have connection problem using my VPS I followed your tutorial but still no luck but when I use my PC as local it work just my VPS not working

---

That ip in the error is 127.0.0.1, and your vps would have had a non 127.0.0.1, ip. So your world server may not be able to connect on 127.0.0.1 if it was changed.

Quote:

---

Originally Posted by Juntoa

https://www.youtube.com/watch?v=L_7GQbEW2Zs#action=share

http://www.mediafire.com/download/r2...tc/C9-Mssql.7z

Thanks to lastfun and everyone who contributed to fix the files!

Game files and guide is provided here in the post:

https://forum.ragezone.com/f857/rele...ml#post8528791

Started with a fresh VM and installed dotnet 4.0:
Microsoft Mssql Server here is a Link:

https://www.microsoft.com/en-us/down....aspx?id=30438

Select this Version: SQLEXPRWT_x64_ENU.exe on the following screen.

Here are the bat files used to update the odbc connection: Remember must run them as Administrator!

https://www.mediafire.com/folder/63b832v38vjj2/c9

---

Sent from my SM-N900T using Tapatalk

@Juntoa : can you show me cash shop in client ? My VM server only have 4 item in that, i want config new VM.

Thank you.

Yeah, thats all i have, i not sure how to add more items yet.

Sent from my SM-N900T using Tapatalk

Sorry, where we can see gm comand?Are only /levelup 10 and /enthance +10?And where we can see list om cp_npc for moster id ?

Quote:

---

Originally Posted by Sun12

Sorry, where we can see gm comand?Are only /levelup 10 and /enthance +10?And where we can see list om cp_npc for moster id ?

---

About Monster IP you can find them in Client, path : *\ClientC9\Character\chr_mon
And here is full GM command, but many command i dont know what to do :(
https://forum.ragezone.com/cache.php...%2FsWsgV7d.png
Poor resolution :)
Credit to @lastfun, he post this list

They should be in the gameserver exe, i have had a busy week, so i have not found them yet.

Sent from my SM-N900T using Tapatalk

Thanks bro,Maybe need admin tool?

Quote:

---

Originally Posted by Sun12

Thanks bro,Maybe need admin tool?

---

Can you take your Cash shop picture and send it to me ?

Thank you.

Quote:

---

Originally Posted by Juntoa

They should be in the gameserver exe, i have had a busy week, so i have not found them yet.

Sent from my SM-N900T using Tapatalk

---

where they are not explicitly ("createnpc", "rank", etc.), they come out of the packet chat as ID (number)

I don't understant, In TUT video why Juntoa change IP form 127.0.0.1 to 192.168.1.xxx ?
If database running in localhost why we must change it ?

Quote:

---

Originally Posted by WildWild

I don't understant, In TUT video why Juntoa change IP form 127.0.0.1 to 192.168.1.xxx ?
If database running in localhost why we must change it ?

---

It's because he uses VPS/DDS to host server remotely :) and so everyone can enter in game if they want :)

Quote:

---

Originally Posted by WildWild

I don't understant, In TUT video why Juntoa change IP form 127.0.0.1 to 192.168.1.xxx ?
If database running in localhost why we must change it ?

---

The database entries can stay 127.0.0.1 only if your database is on the same machine as the server. Loopback address = 127.0.0.1 only same machine can communicate on that ip. But I left mine 127.0.0.1 in the video. I changed everything else to eliminate possible errors since I'm not sure how the servers actually connect.

http://s17.postimg.org/6c5zu2zzz/201...0_16_44_59.jpg

I knew how add item, fashion to my character
Here is command :
/itemkey ID Number
Full ID list translate by google : https://mega.nz/#!K5UlDCLa!4vqc88O3_...UycZ7w-9TzMZS8
http://i.imgur.com/qXgWlvql.jpg[/URL]
http://i.imgur.com/Zo4Wi5cl.jpg[/URL]
http://i.imgur.com/nYZqRzal.jpg[/URL]
http://i.imgur.com/P0nB2lfl.jpg[/URL]
http://i.imgur.com/Y5dYYNIl.jpg[/URL]

I hope GM tool will release soon by someone ^^

Quote:

---

Originally Posted by WildWild

I knew how add item, fashion to my character
Here is command :
/itemkey ID Number
Full ID list translate by google : https://mega.nz/#!K5UlDCLa!4vqc88O3_...UycZ7w-9TzMZS8
http://i.imgur.com/qXgWlvql.jpg[/URL]
http://i.imgur.com/Zo4Wi5cl.jpg[/URL]
http://i.imgur.com/nYZqRzal.jpg[/URL]
http://i.imgur.com/P0nB2lfl.jpg[/URL]
http://i.imgur.com/Y5dYYNIl.jpg[/URL]

I hope GM tool will release soon by someone ^^

---

I stole it in the tutorial )))

Can somebody tell me requirements for PC to run a server ?

Quote:

---

Originally Posted by Haarhus

Can somebody tell me requirements for PC to run a server ?

---

1.2GB Ram for Min start
2.7GB Ram for Max Start

how to launch the game sir??? its not working...

great tut @Juntoa i make it work in lan, but goin live im stuck in turning on the bridge mode, can u help?

Quote:

---

Originally Posted by Juntoa

https://www.youtube.com/watch?v=L_7GQbEW2Zs#action=share

http://www.mediafire.com/download/r2...tc/C9-Mssql.7z

Thanks to lastfun and everyone who contributed to fix the files!

Game files and guide is provided here in the post:

https://forum.ragezone.com/f857/rele...ml#post8528791

Started with a fresh VM and installed dotnet 4.0:
Microsoft Mssql Server here is a Link:

https://www.microsoft.com/en-us/down....aspx?id=30438

Select this Version: SQLEXPRWT_x64_ENU.exe on the following screen.

Here are the bat files used to update the odbc connection: Remember must run them as Administrator!

https://www.mediafire.com/folder/63b832v38vjj2/c9

---

password rar client ??

Quote:

---

Originally Posted by Juntoa

https://www.youtube.com/watch?v=L_7GQbEW2Zs#action=share

http://www.mediafire.com/download/r2...tc/C9-Mssql.7z

Thanks to lastfun and everyone who contributed to fix the files!



Game files and guide is provided here in the post:

https://forum.ragezone.com/f857/rele...ml#post8528791

Started with a fresh VM and installed dotnet 4.0:
Microsoft Mssql Server here is a Link:

https://www.microsoft.com/en-us/down....aspx?id=30438

Select this Version: SQLEXPRWT_x64_ENU.exe on the following screen.

Here are the bat files used to update the odbc connection: Remember must run them as Administrator!

https://www.mediafire.com/folder/63b832v38vjj2/c9

---

what's the password?

No Password.

- - - Updated - - -

I haven't been on here much. But I have been working on a project for this!

https://www.mediafire.com/convkey/8d...zwog6zb66g.jpg
Plain webpage with a few options!
https://www.mediafire.com/convkey/c4...h352mz846g.jpg
Login page
https://www.mediafire.com/convkey/27...9477b5a66g.jpg
User name along with characters stats level exp mana health. Also the map the character is in.
https://www.mediafire.com/convkey/a1...6h7t8j7z6g.jpg
Guild page and a few stats from database.
https://www.mediafire.com/convkey/4e...zwuvxshj6g.jpg
Register page

This is the pre build I plan on adding some error capture in the code and fine tuning the interface.
Maybe add Gm Panel not sure yet!
This is my first website built from the ground up in Asp.net with c# backend.
I plan on releasing this when it it more stable!

User can change password on the password change page.

Quote:

---

Originally Posted by Juntoa

No Password.

- - - Updated - - -

I haven't been on here much. But I have been working on a project for this!

https://forum.ragezone.com/cache.php...zwog6zb66g.jpg
Plain webpage with a few options!
https://forum.ragezone.com/cache.php...h352mz846g.jpg
Login page
https://forum.ragezone.com/cache.php...9477b5a66g.jpg
User name along with characters stats level exp mana health. Also the map the character is in.
https://forum.ragezone.com/cache.php...6h7t8j7z6g.jpg
Guild page and a few stats from database.
https://forum.ragezone.com/cache.php...zwuvxshj6g.jpg
Register page

This is the pre build I plan on adding some error capture in the code and fine tuning the interface.
Maybe add Gm Panel not sure yet!
This is my first website built from the ground up in Asp.net with c# backend.
I plan on releasing this when it it more stable!

User can change password on the password change page.

---

bro when i extract your file 6G its saying passowrd
Screenshot by Lightshot

no need Game. only game pass?
you need first database and server setup.

Juntoa
bro can u told me the password of your file {game.rar} [IMG][img=http://s17.postimg.org/8lvt5z1i3/Ll_Eo3_E1.jpg][/IMG]

Quote:

---

Originally Posted by ahmedtops2

Juntoa
bro can u told me the password of your file {game.rar} [IMG][img=http://s17.postimg.org/8lvt5z1i3/Ll_Eo3_E1.jpg][/IMG]

---

Mike with capital M, that client won't install it will just unpack along with the english patch applied to it.

Screenshot by Lightshot

anyone have any idea about why i can put start

Quote:

---

Originally Posted by ahmedtops2

Screenshot by Lightshot

anyone have any idea about why i can put start

---

https://www.youtube.com/watch?v=L_7GQbEW2Zs
https://www.youtube.com/watch?v=9qtS1oc4tsw

Quote:

---

Originally Posted by CrazyGuardian

https://www.youtube.com/watch?v=L_7GQbEW2Zs
https://www.youtube.com/watch?v=9qtS1oc4tsw

---

Screenshot by Lightshot

can u tell me what's wrong ?

how to add itemshop ??

Quote:

---

Originally Posted by ahmedtops2

Screenshot by Lightshot

can u tell me what's wrong ?

---

client 2000 setup(game)+ lastfun c9 startbat

how can i add ensilort map ?

got this error .

http://i63.tinypic.com/25f2jp3.jpg

Quote:

---

Originally Posted by Oraclebr

got this error .

https://forum.ragezone.com/cache.php...%2F25f2jp3.jpg

---

use virtual machine? i think hdd full .

i solved the problem using prompt and run the script


C:\>sqlcmd -E -S<ServerName> -d<dbName> -iD:\<inputfile>
Changed database context to '<dbName>'.

https://forum.ragezone.com/f600/sect...3/#post8548143

@Shoelace sir please move this Thread here https://forum.ragezone.com/f933/ Thanks

Quote:

---

Originally Posted by Juntoa

No Password.

- - - Updated - - -

I haven't been on here much. But I have been working on a project for this!


Plain webpage with a few options!

Login page

User name along with characters stats level exp mana health. Also the map the character is in.

Guild page and a few stats from database.

Register page

This is the pre build I plan on adding some error capture in the code and fine tuning the interface.
Maybe add Gm Panel not sure yet!
This is my first website built from the ground up in Asp.net with c# backend.
I plan on releasing this when it it more stable!

User can change password on the password change page.

---

Hey Jun,

I'm a web designer and developer and I'd like to assist in this project so I can give back to the C9 community and help kick it off strongly where I can contribute.

As an example of what I can do, I made a custom revamp of the Aion PowerWeb CMS - https://forum.ragezone.com/f587/rele...erweb-1062722/

Let me know if you'd like to work together and I can make a theme for your work and assist with some of the PHP perhaps.

I've started making themes for EVERYONE as I haven't heard back from Juntao yet. So this was going to be the CMS exclusive one to accompany it, but now it's open to the community. The code will come next week along with the actual .psd file for people to modify.

Thread link - https://forum.ragezone.com/f931/deve...theme-1087960/

Quote:

---

Originally Posted by fallenfate

I've started making themes for EVERYONE as I haven't heard back from Juntao yet. So this was going to be the CMS exclusive one to accompany it, but now it's open to the community. The code will come next week along with the actual .psd file for people to modify.

Thread link - https://forum.ragezone.com/f931/deve...theme-1087960/

---

Thank for the offer, been really busy at work, plan on sharing soon and you can do with it what you want for now I plan on finishing it by my own.

Sent from my SM-N920C using Tapatalk

All good @Juntoa, best of luck with the project.

has any 1 alse been able to get these files working on there external ip i can get it working on hamatchi but when i change the same hamatchi ip for my external ip with i think all the ports forded it still refuses the connection even with the firewalls off temp i dont understand whats going on the server windows open then close and the few windows that stay open are saying computer activly refused the connection

but yet when im useing hamatchi ip it all connects proply please help im at a real hurdal with this o.0

i think hamatchi dont work. i know localserver(you real pc ip)so lag so bad & vds server nice..dont free :))

i think hamatchi good work.
your head does not work - it's bad

Quote:

---

Originally Posted by lastfun

i think hamatchi good work.
your head does not work - it's bad

---

i will test tomorrow ^^

if i will do loopback adapter will i will be able to use it publicly?

Need Help here.. I have downloaded the Client 2000 Completely
I uninstall and Reinstall
but i have always this issue.
.
.

Attachment 155107
i was thinking that this "C9.exe" need Patch..
i don't have the patch of this client.
Link patch.. for those who read this message..
.
.
Please Responce for this issue..

:(::(::(::(::(::(:

Quote:

---

Originally Posted by reymark321

Need Help here.. I have downloaded the Client 2000 Completely
I uninstall and Reinstall
but i have always this issue.
.
.

Attachment 155107
i was thinking that this "C9.exe" need Patch..
i don't have the patch of this client.
Link patch.. for those who read this message..
.
.
Please Responce for this issue..

:(::(::(::(::(::(:

---

It's mentioning a file so I doubt it's the actual .exe, I think your client itself needs a patch.

Sir.. do you have a link for the working patch.?
i have downloaded some patch but it's have the same issue.. :(
please help me.
can you please link.

Quote:

---

Originally Posted by reymark321

Sir.. do you have a link for the working patch.?
i have downloaded some patch but it's have the same issue.. :(
please help me.
can you please link.

---

All I did was download the client, and then use the attached C9.exe and it works. If it still doesn't work for you, something is happening while you download.

C9.exe - MEGA.co.nz

tnx.!!
its working sir. :D <3
sir can i ask something..

why i dont have Ensilrot in my map sir.?
but i found file Ensilrot map and the client..
how to fix this issue??


please help sir.

Quote:

---

Originally Posted by reymark321

tnx.!!
its working sir. :D <3
sir can i ask something..

why i dont have Ensilrot in my map sir.?
but i found file Ensilrot map and the client..
how to fix this issue??


please help sir.

---

Glad I could help out, :).

Not sure if this will fix your issues, but try patching your client. Use these steps just in case:

1) Download the first patch (don't run yet) - https://mega.nz/#!et1yhArQ%21vv9_2NS...edbwBVhRyy5eMQ
2) Download the remaining patches (don't run yet) - https://mega.nz/#!6t8VnTLI%21JflKclm...ZWBjEz704zYeos
3) Make a copy of your client folder in case the patches make the client not work.
4) Run the first patch.
5) Run the remaining patches IN ORDER.
6) Download this archive and copy over all files into your client folder.
7) Try running the client.

Hopefully that works for you, I haven't tried Ensilrot yet as I'm testing as a player and only a level 24 Assassin and making a CMS on the side. I patched my client and still used the C9.exe I gave you and the client still works, so it shouldn't be broken at least.

Let me know how it goes, :).

i specially thanks to you that you'll help me sir..
thank for updating me. sir "fallenfate"
.
.
.

i try everything that i can do,
i have many idea and ways that i try with.
but.
all i got is this sir..


Error Issue..

Attachment 155173Attachment 155174


do you know some idea on how or what was wrong?

@reymark321
a lot of ideas, as much as 2 pieces!
You, sir, are using a bad (very bad) client/or bad datapack ... You, sir, need to open their eyes, and download the "right" с9.eхe
sir, repeat for you:
https://forum.ragezone.com/f932/rele...ml#post8528791
sir, you have trolls?

Ensilrot woerks fine you8 just need to run as max config

for those trying to run min config you will only have basic things dont expect the game to fully work running min config it just wont work that way max config opens all the game server for each map and other things its also sagested to add the guild to the chanel list to be able to enter guild house and other things

@reymark321 The character creation issue when the client is fully patched seems to be fixed, download the archive from the edited step 6 in the above post.

Thanks @Thi_Chanwiset for providing the fix!

@lastfun, @fallenfate
Thank for the info sir.. "lastfun"

i tried download other "c9.exe" but..
i have another error.
Attachment 155189

the "CHI" error was gone..
and this is the next problem..

sir.. please help me..

Quote:

---

Originally Posted by reymark321

@lastfun, @fallenfate
Thank for the info sir.. "lastfun"

i tried download other "c9.exe" but..
i have another error.
Attachment 155189

the "CHI" error was gone..
and this is the next problem..

sir.. please help me..

---

Did you replace the C9.exe like I said to? This is because you're using the wrong C9.exe file.

- - - Updated - - -

Quote:

---

Originally Posted by fallenfate

Did you replace the C9.exe like I said to? This is because you're using the wrong C9.exe file.

---

Try this one for the 20131 version - MEGA.co.nz

@lastfun and @fallenfate.

Thank you guys.. its working now.!!
Cool..
Attachment 155214
but..
the next problem is this sir. :(
Attachment 155215

how to fix this issue sir
Please help.

this problem is easy... make sure you chance like this the files LMSConfig.dat and ServerBaseConfig.dat

put this code below in order..

Code:

---

<Server Param="ServerType=Game ServerNo=9 IP=25.11.218.78 PublicIP=25.11.218.78 TcpPort=10509 ChannelNo=1 GameServerType=NOR MapKey=186 MaxUser=500 Community=1 Auction=1 ChatLog=1 LogServer=1 DataCache=1 LogFile=1 LogConsole=1 LogLevel=8 Autoblock=0 Threshold=0 PcTradeThreshold=0 " />

---

understood?

Quote:

---

Originally Posted by Oraclebr

this problem is easy... make sure you chance like this the files LMSConfig.dat and ServerBaseConfig.dat

put this code below in order..

Code:

---

<Server Param="ServerType=Game ServerNo=9 IP=25.11.218.78 PublicIP=25.11.218.78 TcpPort=10509 ChannelNo=1 GameServerType=NOR MapKey=186 MaxUser=500 Community=1 Auction=1 ChatLog=1 LogServer=1 DataCache=1 LogFile=1 LogConsole=1 LogLevel=8 Autoblock=0 Threshold=0 PcTradeThreshold=0 " />

---

understood?

---

and startmax.bat
ping -n 10 localhost > nullstart C9GameServer.exe 5
ping -n 10 localhost > null
start C9GameServer.exe 6
ping -n 10 localhost > null
start C9GameServer.exe 7
ping -n 10 localhost > null
start C9GameServer.exe 8
ping -n 10 localhost > null
start C9GameServer.exe 9
^^think +9

yes :) ! nice !

thanks guys its working.. :) <3
how about.. making c9 luncher sir..?
please help me..

Very easy to set up with this video.
Thank you Juntoa for the time and effort you put into this video.
And Thank you to all persons involved in getting this C9 section up and runnin!

Love playing this on my dedi hosting win server 2012. +100000 to all.:w00t:

i want password of file C9game.7z. :)

Quote:

---

Originally Posted by Manus D Law

i want password of file C9game.7z. :)

---

what? which file?

Mike33 is that password.

Sent from my SM-N920T using Tapatalk

Quote:

---

Originally Posted by Juntoa

Mike with capital M, that client won't install it will just unpack along with the english patch applied to it.

---

this pass ....

@lastfun @Juntoa @Oraclebr

View image: Ll Eo3 E1

pass = Mike

How to Play Hell Mode not Use party Who know? (sorry for my English Skill :D::stupido3::biggrin:)

Quote:

---

Originally Posted by idmzoom

How to Play Hell Mode not Use party Who know? (sorry for my English Skill :D::stupido3::biggrin:)

---

This hasn't been achieved yet if I recall correctly. So the short answer is you can't at the moment.

Hey guys, sorry if this is a bad place to ask, but once I ran the server in Bridged Mode, I get an error "Connecting" and then it goes off. Meanwhile in NAT it's working. Any solutions? Thanks in advance!

Anyone understand why i am getting this when i run start_max shortcut to test server https://postimg.org/image/8yyt3t0jz/

2. when i try installing the client that the download gives it always keep saying im missing dll files which i am not.

ip change

Dear Juntoa,
today I watched your amazing video tutorial. Since today I didn't watched much video tutorials, because they are
mostly terrible. Mostly with techno music.
But you are the big exception. Explaining by your words. Very calm and relaxed.
Are you living in the USA? Sometimes I had problems to understand you.
Keep the chewing gum out of your mouth.:wink:
It's fine that we can see yourself in the video. It gives the video a personal note. :top:

You helped me a lot with your video. I had problems to connect.

I give you 6 of 5 stars. Excellent.

Have a nice day and a nive weekend,
bluebyte :ciao:

Excuse my terrible english. I am out of school since 1981. :):

Quote:

---

Originally Posted by WildWild

I knew how add item, fashion to my character
Here is command :
/itemkey ID Number
Full ID list translate by google : https://mega.nz/#!K5UlDCLa!4vqc88O3_...UycZ7w-9TzMZS8
http://i.imgur.com/qXgWlvql.jpg[/URL]
http://i.imgur.com/Zo4Wi5cl.jpg[/URL]
http://i.imgur.com/nYZqRzal.jpg[/URL]
http://i.imgur.com/P0nB2lfl.jpg[/URL]
http://i.imgur.com/Y5dYYNIl.jpg[/URL]

I hope GM tool will release soon by someone ^^

---

can you reupload it

the video tutorial is gone can any make another tutorial thanks

@Jessyborton I will eventually, just stay tuned, it will be a really clear one.

Quote:

---

Originally Posted by Stunn

@Jessyborton I will eventually, just stay tuned, it will be a really clear one.

---

Best guy around, thanks for everything Stunn.

https://www.youtube.com/watch?v=XxwEriRD8PI

Why can't I see the previous video?

@hernancb17 thanks alot <3, I do expect to see you on lost ark tho :)