[Release][Tutorial] How to make the BR-Gunz work with orginal server files PART II

[willianmorvan]

dont work again.....




my old system,client,launcher etc... all old

[Rotana]

willianmorvan you unblocked 8900 ports tcp and UDP?

Yes

[willianmorvan]

yes rotana unblocked... for confirms ...how unblocked? Panel control>Firewall>add port?
dont work

Open Port Check Tool
port 8900 = Error: I could not see your service on myip on port (8900)
Reason: Connection refused
=[ =[ =[ =[ =[ =[

[MAXTRAXv4]

My locator.ini

[DB]
DNS="GunzDB"
USERNAME="sa"
PASSWORD="mypass"
[NETWORK]
IP="myip"
PORT="8900"
[ENV]
ID="1"
LOCATOR_UID_HIGH="5"
LOCATOR_UID_LOW="0"
MAX_ELAPSED_UPDATE_SERVER_STATUS_TIME="1000"
UDP_LIVE_TIME="10000000"
MAX_FREE_RECV_COUNT_PER_LIVE_TIME="9"
BLOCK_TIME="0"
UPDATE_UDP_MANAGER_ELAPSED_TIME="3"
MARGIN_OF_ERROR_MIN="500000"
USE_COUNTRY_CODE_FILTER="no"
GMT_DIFF="-3"
ELAPSED_TIME_UPDATE_LOCATOR_LOG="3600000"
ELAPSED_TIME_UPDATE_LOCATOR_LOG="10000"
ELAPSED_TIME_UPDATE_COUNTRYCODEFILTER_LOG="10000"
UPDATE_COUNTRY_CODE="66 89 69 77 73 83 65 78 68"
TEST_SERVER="0"


server.ini

[DB]
DNS="GunzDB"
USERNAME="sa"
PASSWORD="mypass"
[SERVER]
MAXUSER=1000
SERVERID=1
SERVERNAME="MatchServer1"
FREELOGINIP="myip"
KEEPERIP="myip"
MODE="test"
COUNTRY="u"
LANGUAGE="INTERNATIONAL"
USETICKET="0"
CheckPremiumIP="0"
DBAgentIP="myip"
GameCode=0
[LANGUAGE]
LANG_TYPE="eng"
[FILTER]
USE="0"
ACCEPT_INVALID_IP="1"
[ENVIRONMENT]
USE_HSHIELD="0"
USE_XTRAP="0"
USE_EVENT="0"
USE_FILECRC="0"


DB - BlockCountryCode

0 - myip - 0


CountryCode

0 - U


CustomIP

0 - 99999999 - 0 - 0 - All - 3/4/2007 00:00:00


IPCountry

0.0.0.0 - 255.255.255.255 - U - U - All



LocatorStatus

1 - myip - 8900 - 0 - 0 - 0 - 0 - 1000 - 3/4/2007 15:34:18



ServerStatus

1 - 0 - 1000 - 3/4/2007 15:34:11 - myip - 6000 - MatchServer1 - 1 - 5




ServerType

0 - Clan



all archives of my system.mrs





my system.xml

<?xml version="1.0" encoding="UTF-8" ?>
<XML>
<XMLHEADER>version="1.0" encoding="UTF-8"</XMLHEADER>
<SKIN>Default</SKIN>
<DEFFONT>Arial</DEFFONT>
<IME>true</IME>
<BAREPORT>
<ADDR>www.battlearena.com</ADDR>
<DIR>incoming/gunz_global</DIR>
</BAREPORT>
<HOMEPAGE>
<URL>http://www.gunzonline.com</URL>
<TITLE>GunZ the Dual</TITLE>
</HOMEPAGE>

<LOCATORLIST>
<LOCATOR id="1" IP="myip" />
</LOCATORLIST>

<TLOCATORLIST>
<LOCATOR id="1" IP="myip" />
</TLOCATORLIST>
</XML>



CORRECT? sorry emotions LOL

server.ini

[DB]
DNS="GunzDB"
USERNAME="sa"
PASSWORD="mypass"
[SERVER]
MAXUSER=1000
SERVERID=1
SERVERNAME="MatchServer1"
FREELOGINIP="myip"
KEEPERIP="myip"
MODE="test"
COUNTRY="u" change to COUNTRY="BR"
LANGUAGE="INTERNATIONAL" this dosent need to be changed
USETICKET="0"
CheckPremiumIP="0"
DBAgentIP="myip" change to DBAgentIP="127.0.0.1"
GameCode=0
[LANGUAGE]
LANG_TYPE="eng"
[FILTER]
USE="0"
ACCEPT_INVALID_IP="1"
[ENVIRONMENT]
USE_HSHIELD="0"
USE_XTRAP="0"
USE_EVENT="0"
USE_FILECRC="0"

DB -
ServerType

0 - Clan change to 3 - clan

BlockCountryCode
0 - myip - 0 change to 127.0.0

[willianmorvan]

dont work... aaaaaaaaaaaaaaaaaaaaa

crazy crazy crazy crazy =[ =[

[Rotana]

yes rotana unblocked... for confirms ...how unblocked? Panel control>Firewall>add port?
dont work

Open Port Check Tool
port 8900 = Error: I could not see your service on myip on port (8900)
Reason: Connection refused
=[ =[ =[ =[ =[ =[

You probelly have an firewall in your router or modem. Check it in there.

Its also possible that the virus scanner is blocking the locator.

Else add me to msn herman1@live.nl

[MAXTRAXv4]

or you havent updated the filelist.xml in system.mrs with the CRC code...

[kekku500]

Mine only problem is : cannot access server
Picture:

mine server.ini

[DB]
DNS="GunzDB"
USERNAME="sa"
PASSWORD="dont look XD"

[SERVER]
MAXUSER=1000
SERVERID=1
SERVERNAME="MatchServer1"
FREELOGINIP="80.235.55.44"
KEEPERIP="80.235.55.44"
MODE="test"
COUNTRY="BR"
LANGUAGE="INTERNATIONAL"
USETICKET="0"
CheckPremiumIP="0"
DBAgentIP="127.0.0.1"
GameCode=0

[LANGUAGE]
LANG_TYPE="eng"

[FILTER]
USE="0"
ACCEPT_INVALID_IP="1"

[ENVIRONMENT]
USE_HSHIELD="0"
USE_XTRAP="0"
USE_EVENT="0"
USE_FILECRC="0"

mine locator.ini

[DB]
DNS="GunzDB"
USERNAME="sa"
PASSWORD="dont look XD"

[NETWORK]
IP="80.235.55.44"
PORT="8900"

[ENV]
ID="1"
LOCATOR_UID_HIGH="5"
LOCATOR_UID_LOW="0"
MAX_ELAPSED_UPDATE_SERVER_STATUS_TIME="1000"
UDP_LIVE_TIME="10000000"
MAX_FREE_RECV_COUNT_PER_LIVE_TIME="9"
BLOCK_TIME="0"
UPDATE_UDP_MANAGER_ELAPSED_TIME="3"
MARGIN_OF_ERROR_MIN="500000"
USE_COUNTRY_CODE_FILTER="no"
GMT_DIFF="-3"
ELAPSED_TIME_UPDATE_LOCATOR_LOG="3600000"
ELAPSED_TIME_UPDATE_LOCATOR_LOG="10000"
ELAPSED_TIME_UPDATE_COUNTRYCODEFILTER_LOG="10000"
UPDATE_COUNTRY_CODE="66 89 69 77 73 83 65 78 68"
TEST_SERVER="0"

Table:
Server Status:

ServerID: 1
IP:80.235.55.44
Port:6000
Opened:1
Type: 4

system.xml

<?xml version="1.0" encoding="UTF-8" ?>
<XML>
<XMLHEADER>version="1.0" encoding="UTF-8"</XMLHEADER>

<SKIN>Default</SKIN>

<DEFFONT>Arial</DEFFONT>

<IME>true</IME>

<BAREPORT>
<ADDR>www.battlearena.com</ADDR>
<DIR>incoming/gunz_global</DIR>
</BAREPORT>

<HOMEPAGE>
<URL>http://www.gunzonline.com</URL>
<TITLE>GunZ the Dual</TITLE>
</HOMEPAGE>

<LOCATORLIST>
<LOCATOR id="1" IP="80.235.55.44" />
</LOCATORLIST>

<TLOCATORLIST>
<LOCATOR id="1" IP="80.235.55.44" />
</TLOCATORLIST>
</XML>

filelist.xml

<FILE NAME="system/system.xml" CRC32="5db92215"/>

port

Success: I can see your service on 80.235.55.44 on port (6000)
Your ISP is not blocking port 6000

Success: I can see your service on 80.235.55.44 on port (8900)
Your ISP is not blocking port 8900

[Rotana]

Mine only problem is : cannot access server
Picture:

mine server.ini


mine locator.ini



Table:
Server Status:


system.xml


filelist.xml


port

So far i can see the settings are fine, only the county and language i have for both BR or BRZ

[kekku500]

I changed to BRZ both now in matchserver is country :brazil but still cant connect

i use server and db(sql 2000) what i got from there: [Release] - Gunz Official Server 2007

.... look what i found
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.dbo.ConnLog'.
i think i need LogDB
anyone can give LogDB.bak ?

[Rotana]

Here you have the sql file for it.

Create an database name LogDB and execute this sql file.

[kekku500]

but i use sql2000 Evalutiaon Editon how i can put it there?

[Nekroido]

but i use sql2000 Evalutiaon Editon how i can put it there?

Use SQL 2005 — it's easy to understand and absolutely free.

[kekku500]

but with SQL 2005 some things in GunzDB wont exc like

Msg 2760, Level 16, State 1, Line 3
The specified schema name "game" either does not exist or you do not have permission to use it.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "game.dtproperties" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "game.dtproperties" because it does not exist or you do not have permissions.
Warning! The maximum key length is 900 bytes. The index 'IX_IPtoCountryCode_IPRange_060612' has maximum length of 24000 bytes. For some combination of large values, the insert/update operation will fail.
Warning: The maximum length of the row exceeds the permissible limit of 8060 bytes. For some combination of large values, the insert/update operation will fail.
Msg 7202, Level 11, State 2, Procedure Account_, Line 6
Could not find server 'SERVER' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
Msg 7202, Level 11, State 2, Procedure Login_, Line 6
Could not find server 'SERVER' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.

[Rotana]

you need to change the username game to dbo.
When you have openend the sql file. Press CTRL + H and type in [game] in the first textbox in the second one [dbo] then click replace all.