[RELEASE] CHS C9 Server Files

[papka]

db mssql? not mysql?

 

[Windows8]

gameserver stops after

2015/06/13 20:08:26 [NOT] - 02FFAEE0 Open DB Connection ( Total Count : 6 )
2015/06/13 20:08:26 [NOT] - Connected to Rank DB
2015/06/13 20:08:26 [NOT] - ConnectDBManager
2015/06/13 20:08:26 [NOT] - Async Work Thread Started! [ 4 ]
2015/06/13 20:08:26 [NOT] - InitPackageManager
2015/06/13 20:08:26 [NOT] - InitNetworkServer

h:\DEV\C9\SERVER>

afterall rest is works even authserver

h:\DEV\C9\SERVER>c9authserver
ZoneNo: 1 AgentPortTcp: 11300
2015/06/13 20:12:28 [INF] - data_source:127.0.0.1,1433 db_name:C9Service account
_id:sa account_pw:lofasz
2015/06/13 20:12:28 [NOT] - 00591348 Open DB Connection ( Total Count : 1 )
2015/06/13 20:12:28 [INF] - data_source:127.0.0.1,1433 db_name:C9Service account
_id:sa account_pw:lofasz
2015/06/13 20:12:28 [NOT] - 00591378 Open DB Connection ( Total Count : 2 )
2015/06/13 20:12:28 [NOT] - Connected to Service DB
2015/06/13 20:12:28 [INF] - Load Block IP List...
2015/06/13 20:12:28 [NOT] - Async Work Thread Started! [ 8 ]
2015/06/13 20:12:28 [NOT] - Success to initialize QQLogin Module!!
2015/06/13 20:12:28 [CRT] - Start C9 Authorization Server [Nov  5 2013 18:46:11]

2015/06/13 20:12:28 [INF] -     Port Number  = 10721
2015/06/13 20:12:28 [INF] -     Thread Count = 4

and authbroker, there is no problem with them, but probably i made lot of mistakes at SQL.... i hate MSSQL so i need assistance for set up the correct things

clientversion in log is 1208...

I can help you on MSSQL friend

 

[Hycker]

i think i can compare mssql and mysql code... trust me this database its m$sql.
check DB files pls then. should i have to create more user like c9web, c9srv and so on?
atleast how to increase query lenght? there is 100mb+ sql file in database and i have no clue how to run it in management studio lol... this mssql too complicated to me :.... or im lazy

 

[Divin3]

For the client, you make a .bat with those instructions:

C9.exe IP,10721,

To open the server, make a .bat like that:

taskkill /f /im "MonitorClient.exe"
taskkill /f /im "C9*"
taskkill /f /im "Memcached.exe"


sc delete c9gameserverservice1
sc delete c9gameserverservice2
sc delete c9gameserverservice3
sc delete c9gameserverservice4
sc delete c9gameserverservice5
sc delete c9gameserverservice6
sc delete c9gameserverservice7
sc delete c9gameserverservice8
sc delete c9gameserverservice9
sc delete c9gameserverservice10
sc delete c9gameserverservice11
sc delete c9worldserverservice1
sc delete c9relayserverservice1
sc delete c9logserverservice1
sc delete c9stunserverservice1
sc delete c9communityserverservice1
sc delete c9datacacheserverservice1
sc delete c9authserverservice1
sc delete c9authbrokerserverservice1
sc delete c9auctionserverservice1
sc delete c9agentserverservice
sc delete c9localmanagementserverservice


H:\C9\Server\c9localmanagementserver -install
sc start c9localmanagementserverservice

H:\C9\Server\c9agentserver -install
sc start c9agentserverservice

H:\C9\Server\memcached.exe

Client link:

You must be registered to see links

OBS:
To make the server work you need to crack the ServerKey verification on AuthServer and GameServer.

 

[papka]

i think db mysql not mssql

left mysql / right mssql

 

[Theorist]

any tutorial ? how to setup ?

 

[lastfun]

To make the server work you need to crack the ServerKey verification on AuthServer and GameServer.

I do not see this as a big problem

 

[Hycker]

papka..... did u see mssql server in your life? tell me the default port for it.

 

[papka]

See every day

 

[Hycker]

TCP: 1433
what those server binaries use? oh wait 1433 instead of 3306 which is mysql
also if you check inside any sql file you will relalize (if you know the difference beetwen two languages) this is mssql

 

[papka]

hm, mb my bad =/

 

[Hycker]

OBS:
To make the server work you need to crack the ServerKey verification on AuthServer and GameServer.

related to this?

<ServerKey key="AmizBHGgfCw6205tDM8vnyc0ImRp+DxaWRl6gR+ff3JwilZS8XrY20vFrU33r+RP9Zxxap0++Kzg6mKu6LvLmzxO6a/MC5SELK/EhaBSHLAssvbnn52/m6vhyx6pMV14FQWfr1C7+LZeJUfPuU5einUuFplvqOyMTPup5gHiwJ4*" />

thats looks like base64

 

[Dzver]

Nice share thanks again. Will look closely when i have more free time

TCP: 1433
what those server binaries use? oh wait 1433 instead of 3306 which is mysql
also if you check inside any sql file you will relalize (if you know the difference beetwen two languages) this is mssql

Yup, you can easily separate both (mysql vs sql server) if you see this:

USE [master]
GO
...

Or that extension

/****** Object: Database [C9Audit] Script Date: 2014-04-04 오후 2:50:18 ******/
CREATE DATABASE [C9Audit] ON PRIMARY
( NAME = N'C9Audit', FILENAME = N'G:\DATA\CH_REAL\C9Audit_Data.mdf' , SIZE = 2GB , MAXSIZE = UNLIMITED, FILEGROWTH = 100MB )
LOG ON
( NAME = N'C9Audit_log', FILENAME = N'G:\DATA\CH_REAL\C9Audit_Log.ldf' , SIZE = 400MB , MAXSIZE = UNLIMITED, FILEGROWTH = 100MB)
...

Default SQL server port is always 1433, same as 3306 for mysql

I was curious at first what SQL Server version need those files since you cant just restore between different versions but since those backup of DBs arent usual *.BAK files but *.sql you should restore over any version (probably SQL Server 2008+)

turtorial how to start private c9

what about start reading and not just leeching?

 

[Hycker]

i have 2k8 r2 x64, servers connected lavly

 

[pkdor]

Our team worked on this file before posting it. The files work. But we can't go live since the bind ip problem. This is local connection only.

 

[InCube]

Damn! This game looks amazing! Are there any tools for the client ? I am too lazy to download and lookup myself.

 

[Theorist]

You must be registered to see links

and direct link from my vps

You must be registered to see links

edit pkdor can u share ur work server files? maybe we can work

 

[Seymour]

IP bind is such problem?how it is implemented?can not be cutted down from binary?thanks for release,anyway,let`s look inside

 

[InCube]

IP bind is such problem?how it is implemented?can not be cutted down from binary?thanks for release,anyway,let`s look inside

ip bind problem only comes when a person dont know how to port forward

 

[Hycker]

ip bind problem only comes when a person dont know how to port forward

or how to make loopback card :