Video Guide C9 - Server + Databases setup

[Juntoa]

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

[MentaL]

[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

[Juntoa]

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

Sent from my SM-N900T using Tapatalk

[Juntoa]

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.

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

[WildWild]

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

[Juntoa]

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

Sent from my SM-N900T using Tapatalk

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

[WildWild]

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

Poor resolution :)
Credit to @lastfun, he post this list

[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

[Sun12]

Thanks bro,Maybe need admin tool?

[WildWild]

Thanks bro,Maybe need admin tool?

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

Thank you.

[lastfun]

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)

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

[luis R]

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

[Juntoa]

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.