MKZ MMOFPS [Files-Database-Client [EN] Complete]

str8killa · Jun 27, 2012

i did

[22:08:20:558][6416 ][Failed ] Build YP server(127.0.0.1:9998) failed[22:08:20:658][6416 ][Warning ] LdbiClient TcpClient Îª¿Õ!
[22:08:21:668][6416 ][Failed ] Build YP server(127.0.0.1:9998) failed
[22:08:21:768][6416 ][Warning ] LdbiClient TcpClient Îª¿Õ!
[22:08:22:778][6416 ][Failed ] Build YP server(127.0.0.1:9998) failed
[22:08:22:878][6416 ][Warning ] LdbiClient TcpClient Îª¿Õ!
[22:08:23:888][6416 ][Failed ] Build YP server(127.0.0.1:9998) failed
[22:08:23:988][6416 ][Warning ] LdbiClient TcpClient Îª¿Õ!
[22:08:24:989][6416 ][Failed ] Build YP server(127.0.0.1:9998) failed

======================================= 2012-06-26 22:06:51 New log started =======================================Error: CADODatabase Error
Code: 80004005
Error: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
ConnStr: Provider=sqloledb;Data Source=128.204.199.25;Initial Catalog=MKZDB;
2012-06-26 22:07:24 0xE0010000 4 4 Z:\MKZStableVersion\175\Code\Projects\BaseDef\Source\ado2.cpp 175
Error: Áª½Ó·þÎñÆ÷ÅäÖÃÊý¾Ý¿âÊ§°Ü(DBError = CADODatabase Error
Code: 80004005
Error: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
ConnStr: Provider=sqloledb;Data Source=128.204.199.25;Initial Catalog=MKZDB;

i get stuck on proxy server but all the info is right etc

Connected · Jun 27, 2012

^
^ are you done with instal.bat in dbproxy folder? and make sure your done with odbc DB

DELUXX · Jun 27, 2012

str8killa said:
i do but i cant get my server working -_

guys show me how to setup client to connect server wana test if my server work ok and if all is ok i will make a nice guid and maby we even get a ragezone section :w00t:

anyone got the code175 ftp password, there is a patch for client there

To view the content, you need to sign in or register

sys3rr0r · Jun 27, 2012

I do not know how to set the launcher, but I have found a way how to start the client anyway. (and sry for my "bad" english :wink:

)

@echo on
system\MetalKnightZeroClient.exe -SHELLCONNECT -LSIP 127.0.0.1 -LSPORT 4502 -P2PIP 127.0.0.1 -P2PPORT 60481 -GSIP 127.0.0.1 -GSPORT 2008 -USER test -PWD test -CHECKID test -CHECKTEX test -PartnerCode ??? -BIGZONEID 1 -BIGZONENAME [Test] -ZONEID 1 -ZONENAME [Test] -GSID 1 -GSNAME Test
pause

save it as a bat and edit the red text first..
edit: test the new, only edit the ip/user/pwd

DELUXX · Jun 27, 2012

sys3rr0r said:
I do not know how to set the launcher, but I have found a way how to start the client anyway. (and sry for my "bad" english )

save it as a bat and edit the red text first..

can you tell me what exactly to put on the all red names? just wana make sure i do all right in case i got an error

sys3rr0r · Jun 27, 2012

test the new, only edit the ip/user/pwd..
( i have editet my old post)
i self cant test it, my dbproxy are not running.

[2012-06-27 15:34:55] startup service
[2012-06-27 15:34:55] MKZ_DBProxyS
[2012-06-27 15:34:55] DSN=HLdbi_UserDB;uid=sa;pwd=123456
[2012-06-27 15:34:56] Open DSN=HLdbi_UserDB;uid=sa;pwd=123456 ok
[2012-06-27 15:34:56] Start BNListS Error..
[2012-06-27 15:34:56] DBProxy Service Stopped.

DELUXX · Jun 27, 2012

curtns - MKZ MMOFPS [Files-Database-Client [EN] Complete] - RaGEZONE Forums

im stuk at this now

DELUXX · Jun 27, 2012

sys3rr0r said:
test the new, only edit the ip/user/pwd..
( i have editet my old post)
i self cant test it, my dbproxy are not running.

problem solved with DBProxy service
,

to setup DBProxy make sure the Install.Bat point on the right path to your
regservice install MKZ_DBProxyS C:\mkz-server\DBProxy\DBProxyS.exe
if is on the right path press the install.bat
now go to ODBC and make 1 more connection , but this time make to System DNS and make HLdbi_UserDB to point to MKZ_LUserDB_30
now time to start DBProxyS.exe and bcaz is a windows service we will start this from cmd with this command net start MKZ_DBProxyS and press enterfor stop is net stop MKZ_DBProxyS

problem solved on 8LZ.exe
how to make 8LZ.exe work:

Go to ODBC manager and make 2 ODBC ocnnection
1- MKZ_LZ_RDB to point to MKZ_LGameDB_30
2- MKZ_LS_UserDB to point to MKZ_LUserDB_30
make sure the settings on EZS.ini for ip`s and DNS logins ar ok
now start 8LZ.exe

now i got incorect password
anyone know exactly where is the user table and in what db? ,the db is so mesy

sys3rr0r · Jun 27, 2012

@DELUXX
i have no problem with the database.
the only problem is the dbproxy find not a table or a list.
"[2012-06-27 15:34:56] Start BNListS Error.."

DELUXX · Jun 27, 2012

woot im in

fk thei use a webshop in game ... so we dont have the shop from this game ...

ModGift · Jun 27, 2012

DELUXX said:
woot im in

fk thei use a webshop in game ... so we dont have the shop from this game ...

We are waiting full guide for setup

)
You are awesome

DELUXX · Jun 27, 2012

... after 30 sec dc server crash and client ...

behemoth93 · Jun 27, 2012

Could you tell me what this is 175.COM a hosting?

Naty48 · Jun 27, 2012

upload your logs lets see what cause it ?

DELUXX · Jun 27, 2012

naty48 said:
upload your logs lets see what cause it ?

nvm all work "fine" , i will make a guide soon wen i have time bcaz take much time

papra · Jun 27, 2012

Failed to start game system

MetalKnightZeroServer_vc8.exe

MKZLogDB initialized
±¾·þÎñÆ÷°æ±¾£º 839
The server's version: 839
¡ïÊý¾ÝÍ¨µÀÎª£ºP2P
*data channel: P2P
¡ïÍøÂçÀàÐÍÎª£ºÆÕÍ¨ÍøÂçÀàÐÍ
*The type of the network is: common
--------³õÊ¼»¯·þÎñÆ÷ÅäÖÃÊ§°Ü--------
--------Failed to initialize server configuration--------
ÕýÔÚÊÍ·ÅºóÌ¨Í³¼Æ´¦ÀíÏß³Ì ...
ÊÍ·ÅºóÌ¨´¦ÀíÏß³Ì³É¹¦
Background proceeding thread released
ÕýÔÚÊÍ·ÅºóÌ¨´¦ÀíÏß³Ì ...
Releasing background proceeding thread ...
ÊÍ·ÅºóÌ¨´¦ÀíÏß³Ì³É¹¦
Background proceeding thread released
ÇåÀí±¾·þÎñÆ÷µÄÓÃ»§µÇÂ½ÐÅÏ¢³É¹¦
Uses' log-in information in this server is cleared
ÊÍ·ÅÊý¾Ý¿âÄ£¿é³É¹¦
Database module released
ÊÍ·ÅClientToGSÍøÂçÄ£¿é³É¹¦
ClientToGS network module released
ÊÍ·ÅInternetPSToGSÍøÂçÄ£¿é³É¹¦
InternetPSToGS network module released
ÊÍ·ÅGSToLDBIÍøÂçÄ£¿é³É¹¦
GSToLDBI network module released
Æô¶¯ÓÎÏ·ÏµÍ³Ê§°Ü¡£
Failed to start game system

Help me

Connected · Jun 27, 2012

papra said:
Failed to start game system

MetalKnightZeroServer_vc8.exe

Help me

edit n change IP in DB change all IP to your IP

and dont forget change host also in db, standar use user, to make easy change your computer name to user

Taipeipei · Jun 27, 2012

Awesome, i`ll work on webshop as soon as i make the server and client work
Great release man... thanx

str8killa · Jun 27, 2012

DELUXX said:
nvm all work "fine" , i will make a guide soon wen i have time bcaz take much time

could you make one today?

DELUXX · Jun 27, 2012

MKZ local server setup

1. Download server files
To view the content, you need to sign in or register
2. Install Msql 2008 db
To view the content, you need to sign in or register
3. Unrar the server files to you C partition on your HDD ( C:\mkz-server\ )
4. In mkz-server you will find a DataBase.zip, unrar that anywhere
5. Now atach the db files to your msql 2008 (if you don`t know how google)
6. Now we need to change PC name to user :

PHP:

-Right click  to MyComputer on desktop
-Click on Properties
-Select Computer Name tab
-Now press change button
-Type in Computer name              user
-Press ok and restart pc

7. Now we need to change lan ip to 192.168.0.104,for me this was ok

To view the content, you need to sign in or register

8. Now make the ODBC connection to you db

User DNS

PHP:

    - _yp_db = MKZ_RUserDB_30
    - HLdbi_GameDB = MKZ_LGameDB_30
    - HLdbi_UserDB = MKZ_LUserDB_30

System DNS

PHP:

    - _yp_db = MKZ_RUserDB_30
    - HLdbi_GameDB = MKZ_LGameDB_30
    - HLdbi_UserDB = MKZ_LUserDB_30
    - MKZ_LS_UserDB = MKZ_LUserDB_30
    - MKZ_LZ_RDB    = MKZ_LGameDB_30

Now we will setup the 1Ldbi.exe

- in LDBI.ini find and edit the :

PHP:

LUSERDBUSERNAME= your msql 2008 username
LUSERDBPASSWORD= your msql 2008 passowrd
----------------------------------------
LGAMEDBUSERNAME= your msql 2008 username
LGAMEDBPASSWORD= your msql 2008 passowrd

ok now save the LDBI.ini .

Now we will setup the 2YPServer.exe in ypserver folder open EZS.ini and edit this:

PHP:

YPDBUSERNAME= your msql 2008 username
YPDBPASSWORD= your msql 2008 passowrd

ok now save the EZS.ini

Now we will setup the 3MKZBroadcastServer.exe in BS\cfg\ folder open server.cfg and edit this:

PHP:

[__GLOBAL__]
;MKZDB数据库配置项
MKZDB_ServerIP="192.168.0.104,1433"
MKZDB_UserName="your msql 2008 username"
MKZDB_Password="your msql 2008 passowrd"
MKZDB_DatabaseName="MKZDB"

;WEB数据库配置项
MKZWebDB_ServerIP="192.168.0.104,1433"
MKZWebDB_UserName="your msql 2008 username"
MKZWebDB_Password="your msql 2008 passowrd"
MKZWebDB_DatabaseName="MKZWEB"

;统计系统数据库配置项
MKZStateDB_ServerIP="192.168.0.104,1433"
MKZStateDB_UserName="your msql 2008 username"
MKZStateDB_Password="your msql 2008 passowrd"
MKZStateDB_DatabaseName="MKZStatDB"

;LOGDB数据库配置项
MKZLOGDB_ServerIP="192.168.0.104,1433"
MKZLOGDB_UserName="your msql 2008 username"
MKZLOGDB_Password="your msql 2008 passowrd"
MKZLOGDB_DatabaseName="MKZLOGDB"

;MKZMAININFODB(mkz中心信息数据库)
MKZMAININFODB_ServerIP="192.168.0.104,1433"
MKZMAININFODB_UserName="your msql 2008 username"
MKZMAININFODB_Password="your msql 2008 passowrd"
MKZMAININFODB_DatabaseName="MKZMAININFODB"

ok now save the server.cfg

Now we will setup the 4MKZProxyServer.exe, open C:\mkz-server\ProxyServer\ProxyServer\cfg server.cfg and edit this:

PHP:

[__GLOBAL__]
;MKZDB数据库配置项
MKZDB_ServerIP="192.168.0.104,1433"
MKZDB_UserName="msql 2008 username"
MKZDB_Password="msql 2008 password"
MKZDB_DatabaseName="MKZDB"

;WEB数据库配置项
MKZWebDB_ServerIP="192.168.0.104,1433"
MKZWebDB_UserName="msql 2008 username"
MKZWebDB_Password="msql 2008 password"
MKZWebDB_DatabaseName="MKZWEB"

;统计系统数据库配置项
MKZStateDB_ServerIP="192.168.0.104,1433"
MKZStateDB_UserName="msql 2008 username"
MKZStateDB_Password="msql 2008 password"
MKZStateDB_DatabaseName="MKZStatDB"

;LOGDB数据库配置项
MKZLOGDB_ServerIP="192.168.0.104,1433"
MKZLOGDB_UserName="msql 2008 username"
MKZLOGDB_Password="msql 2008 password"
MKZLOGDB_DatabaseName="MKZLOGDB"

;MKZMAININFODB(mkz中心信息数据库)
MKZMAININFODB_ServerIP="192.168.0.104,1433"
MKZMAININFODB_UserName="msql 2008 username"
MKZMAININFODB_Password="msql 2008 password"
MKZMAININFODB_DatabaseName="MKZMAININFODB"

close and save.

Now download this
To view the content, you need to sign in or register
Extract the MKZWorldServer.exe from MKZWorldServer过期补丁.zip and past to C:\mkz-server\WS\system ,
Now right click on MKZWorldServer.exe and make a Create a Shortcut ,
rename that Shortcut to 5MKZWorldServer.exe ,copy and past that Shortcut to C:\mkz-server (even replace).

Now we ar ready to setup the 5MKZWorldServer.exe, open C:\mkz-server\WS\cfg server.cfg

PHP:

[__GLOBAL__]
;MKZDB数据库配置项
MKZDB_ServerIP="192.168.0.104,1433"
MKZDB_UserName="msql 2008 username"
MKZDB_Password="msql 2008 password"
MKZDB_DatabaseName="MKZDB"

;WEB数据库配置项
MKZWebDB_ServerIP="192.168.0.104,1433"
MKZWebDB_UserName="msql 2008 username"
MKZWebDB_Password="msql 2008 password"
MKZWebDB_DatabaseName="MKZWEB"

;统计系统数据库配置项
MKZStateDB_ServerIP="192.168.0.104,1433"
MKZStateDB_UserName="msql 2008 username"
MKZStateDB_Password="msql 2008 password"
MKZStateDB_DatabaseName="MKZStatDB"

;LOGDB数据库配置项
MKZLOGDB_ServerIP="192.168.0.104,1433"
MKZLOGDB_UserName="msql 2008 username"
MKZLOGDB_Password="msql 2008 password"
MKZLOGDB_DatabaseName="MKZLOGDB"

;MKZMAININFODB(mkz中心信息数据库)
MKZMAININFODB_ServerIP="192.168.0.104,1433"
MKZMAININFODB_UserName="msql 2008 username"
MKZMAININFODB_Password="msql 2008 password"
MKZMAININFODB_DatabaseName="MKZMAININFODB"

close and save.

Now we will setup the 6MetalKnightZeroServer_vc8.exe,

- open C:\mkz-server\GS\GS\cfg server.cfg and edit this:

PHP:

[__GLOBAL__]
;MKZDB数据库配置项
MKZDB_ServerIP="192.168.0.104,1433"
MKZDB_UserName="msql 2008 username"
MKZDB_Password="msql 2008 password"
MKZDB_DatabaseName="MKZDB"

;WEB数据库配置项
MKZWebDB_ServerIP="192.168.0.104,1433"
MKZWebDB_UserName="msql 2008 username"
MKZWebDB_Password="msql 2008 password"
MKZWebDB_DatabaseName="MKZWEB"

;统计系统数据库配置项
MKZStateDB_ServerIP="192.168.0.104,1433"
MKZStateDB_UserName="msql 2008 username"
MKZStateDB_Password="msql 2008 password"
MKZStateDB_DatabaseName="MKZStatDB"

;LOGDB数据库配置项
MKZLOGDB_ServerIP="192.168.0.104,1433"
MKZLOGDB_UserName="msql 2008 username"
MKZLOGDB_Password="msql 2008 password"
MKZLOGDB_DatabaseName="MKZLOGDB"

;MKZMAININFODB(mkz中心信息数据库)
MKZMAININFODB_ServerIP="192.168.0.104,1433"
MKZMAININFODB_UserName="msql 2008 username"
MKZMAININFODB_Password="msql 2008 password"
MKZMAININFODB_DatabaseName="MKZMAININFODB"

close and save.

- open C:\mkz-server\GS\GS\cfg ProxyServer.cfg and edit this:

PHP:

[__GLOBAL__]
DBServer="192.168.0.104,1433"
UserName="msql 2008 username"
Password="msql 2008 password"
DatabaseName="MKZDB"

close and save.

Now we will setup the DBProxyS.exe:

- open C:\mkz-server\DBProxy DBProxy.ini and edit this:

PHP:

DSN="HLdbi_UserDB"
USERNAME="msql 2008 username"
PASSWORD="msql 2008 password"

- open C:\mkz-server\DBProxy Install.Bat ,right click and select edit and make sure it look this that:

PHP:

regservice install db C:\mkz-server\DBProxy\DBProxyS.exe
PAUSE

close and save and start Install.Bat

- now open windows cmd and type :

net start db

Now we will setup the 8LZ.exe:

- open C:\mkz-server\LZ EZS.ini and edit this:

PHP:

[YP]
;ypdb
YPDBDSN=_yp_db
YPDBUSERNAME=msql 2008 username
YPDBPASSWORD=msql 2008 password

[EZS]
;gameDB
GAMEDBDSN=MKZ_LZ_RDB
GAMEDBUSERNAME=msql 2008 username
GAMEDBPASSWORD=msql 2008 password
;userDB
USERDBDSN=MKZ_LS_UserDB
USERDBUSERNAME=msql 2008 username
USERDBPASSWORD=msql 2008 password

close and save.

Ok if you made all that like in tutorial server will work just fine now.

Let`s start the server in this order:

1Ldbi.exe
2YPServer.exe
3MKZBroadcastServer.exe
4MKZProxyServer.exe
5MKZWorldServer.exe
6MetalKnightZeroServer_vc8.exe
7ES.exe
8LZ.exe

------------------------ Client setup to connect - server ------------------------

Download client from
To view the content, you need to sign in or register
and install
After you installed the client go where you installed (for me is this D:\Program Files\175PT\MetalKnightZero )
make there a start.bat and add this in file:

PHP:

@echo on
system\MetalKnightZeroClient.exe -SHELLCONNECT -LSIP 192.168.0.104 -LSPORT 4502 -P2PIP 192.168.0.104 -P2PPORT 60481 -GSIP 192.168.0.104 -GSPORT 2008 -USER twly000001 -PWD 96e79218965eb72c92a549dd5a330112 -CHECKID test2 -CHECKTEX test -PartnerCode ??? -BIGZONEID 1 -BIGZONENAME [Test] -ZONEID 1 -ZONENAME [Test] -GSID 1 -GSNAME test
pause

note the user: twly000001

and
pwd: 96e79218965eb72c92a549dd5a330112

(password is in md5 format not decrypted)
both user and password can be found in db:

-MKZ_RUserDB_30 / table- T_UserCore

close and save and start start.bat

云和山的彼端 - for releasing the files!

hsca10156 - Sharing the password !! [Thanks alot mate!]

Naty48 - For creating the theard and gather all the info&mirrors .

ModGift - For creating the ftp links

GameDebug - For releasing the MKZWorldServer.exe cracked

sys3rr0r - For releasing the start.bat config

DELUXX (Me) - For first full tutorial

MKZ MMOFPS [Files-Database-Client [EN] Complete]

Socius Decennalis

Junior Spellweaver

Socius Decennalis

Newbie Spellweaver

Socius Decennalis

Newbie Spellweaver

Socius Decennalis

Socius Decennalis

Newbie Spellweaver

Socius Decennalis

Socius Decennalis

Socius Decennalis

Newbie Spellweaver

CPP/C#/PHP/ASM

Socius Decennalis

Newbie Spellweaver

Junior Spellweaver

Newbie Spellweaver

Socius Decennalis

Socius Decennalis

RaGEZONE Sponsor

About RaGEZONE

Forum Statistics

RaGEZONE Partners