[RELEASE] code105 ol,server and client,but no sql

[exe19890522]

hello,friends,i get this for a long time,but i have no time to fix the sql.
so if someone is free,your can try to fix the sql(mysql).
i rar it with the log files,it may will help you.
when i run the server and mysql at first time ,it not give me any error.
but after i fix some sql,it will give me some errors.
maybe you will success.

code105 is a chinese game,like lol for 3d.here two video:

You must be registered to see links

You must be registered to see links

You must be registered to see links

You must be registered to see links

if someone can fix the sql.please share the full .sql files.
it have 3 sql:ArkAccount,ArkDB,ArkDataCollection,,at least 3,maybe will have more.
if you want to change the sql connection info please see the file ServerInfo.ini in config folder.



here some pic on unoffical website,offical web site is off.

You must be registered to see links

 

[superspace]

Re: code105 ol,server and client,but no sql

FULL version ?

 

[xlw00tlx]

Re: code105 ol,server and client,but no sql

no databases and server exes try to run in H:\ theres no config to change that

 

[exe19890522]

Re: code105 ol,server and client,but no sql

when i get this,it is have no sql,just for all i updata here,

no databases and server exes try to run in H:\ theres no config to change that

i run this in h:/tdpath/code105/,,,

are you good at mysql??

 

[aqualung]

Re: code105 ol,server and client,but no sql

Had some time, here is DB I threw together for starters, server runs without error, you just need to work on getting the client to connect. Point all 3 DB's at this, I used code105 as DB Name.

You must be registered to see links

AquaLung


.

 

[hodias]

Re: code105 ol,server and client,but no sql

I fixed the server, fixed the errors, fixed the connection of the client to the server, have some problem with the version of the client or port of connection with LoginServer.
Sorry my bad english

Images:

 

[exe19890522]

Re: code105 ol,server and client,but no sql

aqualung very thank you,i run the server without error tip now.but i have two question:
1.how can i fix the sql?i use smsniff to get the package between server and server,but failed,just only can fix a little.i want to learn this.which tool do you use?
2.even i change something setting in config files,but the client will tip "server may closed".
i change ServerInfo.ini in config folder for server with [
[AccountDB]
DBIP=127.0.0.1 ;数据库服务器IP
DBPort=3306 ;数据库服务器端口
DBName=code105 ;数据库名称
DBUser=root ;数据库用户名
DBPassword=1234 ;数据库密码

[CharacterDB]
DBIP=127.0.0.1 ;数据库服务器IP
DBPort=3306 ;数据库服务器端口
DBName=code105 ;数据库名称
DBUser=root ;数据库用户名
DBPassword=1234 ;数据库密码

[CollectionDB]
DBIP=127.0.0.1 ;数据库服务器IP
DBPort=3306 ;数据库服务器端口
DBName=code105 ;数据库名称
DBUser=root ;数据库用户名
DBPassword=1234 ;数据库密码
...]
and change GameRegion.ini in client folder with
[
[regionCount]
count=1

[region0]
name=test server
ip=127.0.0.1
port=10020
]
but when i want login into game at the account login window,it will give me a tip "目的服务器可能关闭" ，which means "server may closed".
i don't know why.did you try to login it??
===============
hodias did you login into game? i change the version to 1000 in the Launch.ini file fo client.
[update]
version=1000
http=http://127.0.0.1/game/update_hd

but when i want login into game at the account login window,it will give me a tip "目的服务器可能关闭" ，which means "server may closed".

 

[aqualung]

Re: code105 ol,server and client,but no sql

I think login server default for server files is 10000:
This is what I used:

[region0]
name=TEST_SERVER
ip=127.0.0.1
port=10000
]

but in login log, I get: ClientPlayerManager::RemovePlayer(UserID=-1, Count=0), because: End of file...OK

maybe wrong client version..........( Need to find more client versions or patches....)

Not sure if initial connection should be CLIENT -> LOGIN SERVER(10000) or CLIENT -> FRONTEND SERVER(10006) ????

Any idea? Also is there an unpack tool for .zpk files?


For DB, I used plain old hex editor to find DB calls and created tables in mysql.

AquaLung

.

 

[hodias]

Re: code105 ol,server and client,but no sql

aqualung
The client version is different from the server. The customer is too old, so the error. Here is the correct client link. If you want to download and upload in MEGA it will be great.

(Version 1005 and 1006)
Link:

You must be registered to see links

 

[aqualung]

Re: code105 ol,server and client,but no sql

I already tried this DL with thunder and fails, DL never starts. Need another source.....


AquaLung

.

 

[hodias]

Re: code105 ol,server and client,but no sql

aqualung

Upload client in MEGA? My download from this client gave an error. I'm going to do more tests and what I'm discovering, I'll be posting here on the topic.

 

[aqualung]

Re: code105 ol,server and client,but no sql

@hodias
Don't have the client, link points back to code105.com and site is dead...
Need new source for dl.
AquaLung


Anyone translate this message?

.

Login Server says: ClientPlayerManager::RemovePlayer(UserID=-1, Count=0), because: 定时关闭此连接...OK
.



SERVER COMMANDS:

LOGIN SERVER:
stopServer
saveLog
changeServerState
reloadConfig

FRONTEND SERVER:
stopServer
printMaxTickTime

DATABASE SERVER:
stopServer
saveLog

DATA COLLECTION SERVER:
stopServer
saveLog

GAME SERVER:
stopServer
saveAILog
saveLog
printPoolInfo

PAY USER MANAGER SERVER:
stopServer
saveLog

WORLD SERVER:
stopServer
saveLog
printUserCount
printGameCount
printMaxTickTime


AquaLung

.

 

[datcom]

Re: code105 ol,server and client,but no sql

client in MEGA? Thank

 

[xlw00tlx]

Re: code105 ol,server and client,but no sql

aqualung
the error says

Network Error
Kuai Moudule has been disconnected
Close

 

[aqualung]

Re: code105 ol,server and client,but no sql

@xlw00tlx
ok, thanks!

That is with v1002 client. Cannot find any newer version around v1015, v1016. Need client file dated around 2014-06-18

AquaLung

.

 

[wahaha]

Re: code105 ol,server and client,but no sql

网络连接已断开==the newwork have disconnect.... i will upload the other client....wait

 

[aqualung]

Re: code105 ol,server and client,but no sql

网络连接已断开==the newwork have disconnect.... i will upload the other client....wait

OK, waiting. Thanks!

AquaLung

 

[exe19890522]

Re: code105 ol,server and client,but no sql

aqualung
The client version is different from the server. The customer is too old, so the error. Here is the correct client link. If you want to download and upload in MEGA it will be great.

(Version 1005 and 1006)
Link:

You must be registered to see links

i share the client is 1006.and this game may not have standed patch.

 

[aqualung]

Re: code105 ol,server and client,but no sql

i share the client is 1006.and this game may not have standed patch.

The link you provide is dead, points to location code105.com and site is dead, need another source.....

AquaLung

.

 

[exe19890522]

here is another client v=1013,maybe help you aqualung hodias

You must be registered to see links