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

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:
https://www.youtube.com/watch?v=ojD3Ejtz4WQ
https://www.youtube.com/watch?v=QTuQlbDbeN8https://www.youtube.com/watch?v=QTuQlbDbeN8

https://mega.nz/#F!1hpkXTBD!rGc6dGjSLPpbWN73roJ6kQ

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.

- - - Updated - - -

here some pic on unoffical website,offical web site is off.
http://www.07073.com/dh105/jietu/

FULL version ?

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

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

- - - Updated - - -

Quote:

---

Originally Posted by xlw00tlx

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

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.

CODE105.SQL

AquaLung


.

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:
http://i66.tinypic.com/2jechzc.jpg
http://i66.tinypic.com/2usengh.png

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

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

.

@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: 《代号105》内测完整客户端高清版_客户端_宇望信息_17173游戏下载

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


AquaLung

.

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

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

.Attachment 158681

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

- - - Updated - - -

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

.

client in MEGA? Thank

@aqualung
the error says

Network Error
Kuai Moudule has been disconnected
Close

@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

.