Dzetki
The Prodigal Son Returns
- Jul 16, 2010
- 990
- 220
Don't you know what GunZ looks like? Well, click the spoiler below to view a video of it!
Recent Updates:
- Added Dynamic IP Settings
- Added French and Spanish Translation pages
- Replaced theduel.exe (fix for no servers showing even tho all settings are correct)
I put this tutorial together because alot of similar tutorials here are either too complicated, poorly structured or just wrong. THIS TUTORIAL WAS MADE TO GET YOUR SERVER RUNNING AND PLAYABLE. NOTHING MORE!
I also translated this page into French and Spanish for the non-English users here.
Français:
Español:
DOWNLOADS
Server:
Client:
MRS Decompiler:
Microsoft SQL Server 2005:
Microsoft SQL Server Management Studio Express:
Your anti-virus may detect the launcher as a virus, so it may get deleted.
Before you do anything, you are going to need to install Microsoft SQL Server 2005 using MIXED MODE, NOT WINDOWS AUTHENTICATION, then install Microsoft SQL Server Management Studio Express. NOTE: The downloads for these two files are windows xp, and might not work with windows 7 or x64 computers.
Server Management Studio Express Setup
Setup
1) Start up Server Management Studio Express and connect using the following settings:
2) Within the Object Explorer Panel, right click the "database" folder, then click "New Database". A New Database form will open. In the text input type "GunzDB" and click OK, your database has been created.
3) The next thing you are going to do is load the Database. Click File > Open > File... and locate "Database_GunzDB.sql" in your Gunz ServerFiles Rev 5/Database folder and open it.
4) In the toolbar there is a drop-down menu with the "master" database selected, click on the arrow and select the 'GunzDB' database and click the red ! button next to the drop-down menu to execute.
IGNORE ANY ERRORS
5) Expand the 'Database' folder if it hasn't already been done.
6) Expand "GunzDB", then expand 'Tables' and right click on 'dbo.Account' and 'Open Table'. If there are no tables, repeat step 4 until there is.
7) Enter the information below. (Enter data by clicking where it says "null" in the boxes in the table)
AID: Generated automatically at the end of account creation
UserID: Desired username used for logging in.
UGradeID: Refer to the grades below
Code:
Account Grades
Administrator - 255
Developer - 254
Banned - 253
Administrator (with normal name) - 252
Jjang - 2 (event winner)
Normal User - 0
PGradeID: Same as UGradeID
RegDate: 0
Name: Your first name.
8) Hit enter, then click Execute (the red "!" up top) and your done with account.dbo
9) Right click on 'dbo.Login' and 'Open table'.
10) Enter the AID of your account, your username and your desired password.
11) Hit enter, then click Execute (the red "!" up top) and your done with Login.dbo
12) Right click on 'dbo.ServerStatus' and 'Open table'.
13) Change the settings to this:
Code:
16) Hit enter, then click Execute (the red "!" up top) and your done with Microsoft SQL Server Management Studio Express.
NOTE: Everytime your finished editing a table, you need to hit Enter to save the Table, then hit Execute (the red "!" up top) so it saves to the Database.
ODBC Setup
1) Click Start> Run> and type 'odbcad32'.
Windows XP: You should already be in the User DSN tab so switch to the System DSN tab, and click "Add"
Windows Vista/7: You should already be in the User DSN tab so just click "Add"
2) In the new window, scroll all the way down to the bottom and select 'SQL Server' then click 'Finish'.
3) Another window will pop-up, enter the info below:
4) Click next
5) In the next window, change the connection type from Windows NT to SQL Server Authentication, and check "Connect to Sql Server" and enter your Login/pass. Click next.
6) Now in this next part, click on the tick box and select 'GunzDB' from the drop-down menu and click Next and finally click Finish.
7) Click "OK" again to finish.
Server Setup
1) Make this directory: "C:\GunzServer", and extract the server files into it.
2) Replace the contents of the following files with the code I have provided:
(YOURWANIP can be found at: IP Chicken - Whats my IP address? ip address lookup, but if you have a dynamic ip you must use your no-ip.biz host.)
Server.ini in MatchServer folder"
Code:
Client Setup
1) Download the client provided.
2) Extract the contents to the Desktop.
3) Decompile system.mrs using the "How to Compile/Decompile .mrs files" method below.
4) Once decmpiled, Right click "system.xml" and select open with wordpad.
5) Replace the contents with this code:
Code:
6) Save and Compile system.mrs (using the How to Compile/Decompile .mrs files guide below)
7) Open Gunz Client and Right click "config.xml" and select open with wordpad.
8) Change the top part with this:
Code:
9) Save
How to Compile/Decompile .mrs files
Download the MRS Decompiler.exe included and extract the files to C:\GunzServer\MRS
To Decompile:
1) Copy your desired .mrs file to the "C:\GunzServer\MRS" directory.
2) Run MRS Decompiler.exe and in the "decompile" box, type in "system". Your newly generated decompiled .mrs folder should appear!
To Compile:
1) Run the MRS Decompiler.exe and in the "compile" box, type in "system". Your newly generated compiled .mrs file should appear!
2) Paste the newly generated system.mrs over the existing one in the Gunz Client
Port Forwarding (ONLY IF YOU HAVE A ROUTER)
1) Click Start> Run> and type "cmd"
2) Once you are prompted with a black window, type "ipconfig"
3) Find "Default Gateway" and remember it
4) Find "IP Adress" and remember that also
5) Open your internet browser and type your Default Gateway into the url box.
6) Enter the username (default admin) and password (default admin) when prompted. If you don't know your username/password go here: Default Router Passwords - The internets most comprehensive router password database
7) Find your Port Fowarding page and enter this information:
8) Enter the last 3 numbers of your IP Address (from ipconfig) and enter those numbers into the IP Address boxes.
9) Check to see if your ports are open using this program:
Your done! To host your server and get it running, Open MatchServer.exe, MatchAgent.exe, and Locator.exe IN THAT ORDER
~ Credits to:
eagledude4 for fixing and restructuring MAXTRAXV3's tutorial.
MAXTRAXV3's tutorial for links and tutorial base.
Anyone else who deserves credits for the files.
STILL NOT WORKING? Make sure you have:
- Used my Server and Client files which I have provided
- Configured all Server files (Server.ini, AgentConfig.xml and Locator.ini)
- Configured all Client files (Config.xml, system.xml)
- Modified all the Server dependant tables (dbo.ServerStatus and dbo.LocatorStatus)
- Configured the ODBCAD32
- Portforwarded and checked to see if they are open using the Portforward.com Port check tool provided.
DO NOT MESSAGE eagledude4 OR ADD eagledude4 ON MSN UNTIL YOU HAVE COMPLETED THE STEPS ABOVE
--------------------------------------------------------------------------------------------------------------------------------------------------
Recent Updates:
- Added Dynamic IP Settings
- Added French and Spanish Translation pages
- Replaced theduel.exe (fix for no servers showing even tho all settings are correct)
I put this tutorial together because alot of similar tutorials here are either too complicated, poorly structured or just wrong. THIS TUTORIAL WAS MADE TO GET YOUR SERVER RUNNING AND PLAYABLE. NOTHING MORE!
I also translated this page into French and Spanish for the non-English users here.
Français:
You must be registered for see links
Español:
You must be registered for see links
DOWNLOADS
Server:
You must be registered for see links
Client:
You must be registered for see links
MRS Decompiler:
You must be registered for see links
Microsoft SQL Server 2005:
You must be registered for see links
Microsoft SQL Server Management Studio Express:
You must be registered for see links
Your anti-virus may detect the launcher as a virus, so it may get deleted.
Before you do anything, you are going to need to install Microsoft SQL Server 2005 using MIXED MODE, NOT WINDOWS AUTHENTICATION, then install Microsoft SQL Server Management Studio Express. NOTE: The downloads for these two files are windows xp, and might not work with windows 7 or x64 computers.
Server Management Studio Express Setup
Setup
1) Start up Server Management Studio Express and connect using the following settings:
Code:
Server Type: Database Engine
Server Name: (If this box is empty, click the drop down arrow and choose browse for more, than expand the database engine using the + and select whatever comes up)
Authentication: Sql Server Authentication
Username: sa
Password: (whatever you used when installing SQl Server 2005)3) The next thing you are going to do is load the Database. Click File > Open > File... and locate "Database_GunzDB.sql" in your Gunz ServerFiles Rev 5/Database folder and open it.
4) In the toolbar there is a drop-down menu with the "master" database selected, click on the arrow and select the 'GunzDB' database and click the red ! button next to the drop-down menu to execute.
IGNORE ANY ERRORS
5) Expand the 'Database' folder if it hasn't already been done.
6) Expand "GunzDB", then expand 'Tables' and right click on 'dbo.Account' and 'Open Table'. If there are no tables, repeat step 4 until there is.
7) Enter the information below. (Enter data by clicking where it says "null" in the boxes in the table)
AID: Generated automatically at the end of account creation
UserID: Desired username used for logging in.
UGradeID: Refer to the grades below
Code:
Account Grades
Administrator - 255
Developer - 254
Banned - 253
Administrator (with normal name) - 252
Jjang - 2 (event winner)
Normal User - 0
PGradeID: Same as UGradeID
RegDate: 0
Name: Your first name.
8) Hit enter, then click Execute (the red "!" up top) and your done with account.dbo
9) Right click on 'dbo.Login' and 'Open table'.
10) Enter the AID of your account, your username and your desired password.
11) Hit enter, then click Execute (the red "!" up top) and your done with Login.dbo
12) Right click on 'dbo.ServerStatus' and 'Open table'.
13) Change the settings to this:
Code:
Code:
ServerID= 1
CurrPlayer= 0
MaxPlayer= 50
Time= 0:00:00
IP= YOURWANIP
Port= 6000
ServerName= MatchServer1
Opened= 1
Type=4
14) Hit enter, then click Execute (the red "!" up top) and proceed to locatorstatus.dbo
15) Change the settings to the ones below:
[CODE]LocatorID: 1
IP: YOURWANIP
Port: 8900
RecvCount: 0
SendCount: 0
BlockCount: 0
DuplicatedCount: 0
UpdateElapsed: 1000
Last Update: 11/9/2009 12:00:00 AMNOTE: Everytime your finished editing a table, you need to hit Enter to save the Table, then hit Execute (the red "!" up top) so it saves to the Database.
ODBC Setup
1) Click Start> Run> and type 'odbcad32'.
Windows XP: You should already be in the User DSN tab so switch to the System DSN tab, and click "Add"
Windows Vista/7: You should already be in the User DSN tab so just click "Add"
2) In the new window, scroll all the way down to the bottom and select 'SQL Server' then click 'Finish'.
3) Another window will pop-up, enter the info below:
Code:
Name: GunzDB
Description: Type whatever you like
Server: "Server name" that you use to login to Sql Server Management Stdio express5) In the next window, change the connection type from Windows NT to SQL Server Authentication, and check "Connect to Sql Server" and enter your Login/pass. Click next.
6) Now in this next part, click on the tick box and select 'GunzDB' from the drop-down menu and click Next and finally click Finish.
7) Click "OK" again to finish.
Server Setup
1) Make this directory: "C:\GunzServer", and extract the server files into it.
2) Replace the contents of the following files with the code I have provided:
(YOURWANIP can be found at: IP Chicken - Whats my IP address? ip address lookup, but if you have a dynamic ip you must use your no-ip.biz host.)
Server.ini in MatchServer folder"
Code:
Code:
[DB]
DNS="GunzDB"
USERNAME="sa"
PASSWORD="Password you use for SQL Server management express"
[SERVER]
MAXUSER=50
SERVERID=1
SERVERNAME="MatchServer1"
FREELOGINIP="WAN IP (or no-ip host)"
KEEPERIP="WAN IP (or no-ip host)"
MONITORIP="127.0.0.1"
MONITORPORT=9000
MODE="test"
COUNTRY="BRZ"
LANGUAGE="BRZ"
USETICKET="0"
[LANGUAGE]
LANG_TYPE="eng"
[LOCALE]
DBAgentPort=5100
DBAgentIP=127.0.0.1
[FILTER]
USE="0"
ACCEPT_INVALID_IP="1"
[ENVIRONMENT]
USE_HSHIELD="0"
USE_XTRAP="0"
USE_EVENT="0"
USE_FILECRC="0"
USE_MD5="0"
AgentConfig.xml in MatchAgent folder
Code:
<?xml version="1.0" encoding="euc-kr"?>
<XML>
<AGENTCONFIG>
<NAME>MatchServer1</NAME>
<MAXCLIENT>200</MAXCLIENT>
<MATCHSERVERADDRESS ip="127.0.0.1" tcpport="6000"/>
<ADDRESS ip="YOURWANIP (or NO-IP Address if you have a dynamic IP)" tcpport="7777" udpport="5100"/>
</AGENTCONFIG>
</XML>
locator.ini in Locator folder
Code:
[DB]
DNS="GunzDB"
USERNAME="sa"
PASSWORD="Password you use for SQL Server management express"
[NETWORK]
IP="WANIP (or NO-IP Address if you have a dynamic IP)"
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"Client Setup
1) Download the client provided.
2) Extract the contents to the Desktop.
3) Decompile system.mrs using the "How to Compile/Decompile .mrs files" method below.
4) Once decmpiled, Right click "system.xml" and select open with wordpad.
5) Replace the contents with this code:
Code:
Code:
<?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>
<EMBLEM_URL>http://gunzonline.com/emblems/</EMBLEM_URL>
<TEMBLEM_URL>http://gunzonline.com/emblems/</TEMBLEM_URL>
<LOCATORLIST>
<LOCATOR id="1" IP="YOURWANIP (or NO-IP Address if you have a dynamic IP)" />
</LOCATORLIST>
<TLOCATORLIST>
<LOCATOR id="1" IP="YOURWANIP (or NO-IP Address if you have a dynamic IP)" />
</TLOCATORLIST>
</XML>7) Open Gunz Client and Right click "config.xml" and select open with wordpad.
8) Change the top part with this:
Code:
Code:
<?xml version="1.0" encoding="UTF-8"?>
<XML>
<SERVER>
<IP>WANIP (or NO-IP Address if you have a dynamic IP)</IP>
<PORT>6000</PORT>
</SERVER>How to Compile/Decompile .mrs files
Download the MRS Decompiler.exe included and extract the files to C:\GunzServer\MRS
To Decompile:
1) Copy your desired .mrs file to the "C:\GunzServer\MRS" directory.
2) Run MRS Decompiler.exe and in the "decompile" box, type in "system". Your newly generated decompiled .mrs folder should appear!
To Compile:
1) Run the MRS Decompiler.exe and in the "compile" box, type in "system". Your newly generated compiled .mrs file should appear!
2) Paste the newly generated system.mrs over the existing one in the Gunz Client
Port Forwarding (ONLY IF YOU HAVE A ROUTER)
1) Click Start> Run> and type "cmd"
2) Once you are prompted with a black window, type "ipconfig"
3) Find "Default Gateway" and remember it
4) Find "IP Adress" and remember that also
5) Open your internet browser and type your Default Gateway into the url box.
6) Enter the username (default admin) and password (default admin) when prompted. If you don't know your username/password go here: Default Router Passwords - The internets most comprehensive router password database
7) Find your Port Fowarding page and enter this information:
8) Enter the last 3 numbers of your IP Address (from ipconfig) and enter those numbers into the IP Address boxes.
9) Check to see if your ports are open using this program:
You must be registered for see links
Your done! To host your server and get it running, Open MatchServer.exe, MatchAgent.exe, and Locator.exe IN THAT ORDER
~ Credits to:
eagledude4 for fixing and restructuring MAXTRAXV3's tutorial.
MAXTRAXV3's tutorial for links and tutorial base.
Anyone else who deserves credits for the files.
STILL NOT WORKING? Make sure you have:
- Used my Server and Client files which I have provided
- Configured all Server files (Server.ini, AgentConfig.xml and Locator.ini)
- Configured all Client files (Config.xml, system.xml)
- Modified all the Server dependant tables (dbo.ServerStatus and dbo.LocatorStatus)
- Configured the ODBCAD32
- Portforwarded and checked to see if they are open using the Portforward.com Port check tool provided.
DO NOT MESSAGE eagledude4 OR ADD eagledude4 ON MSN UNTIL YOU HAVE COMPLETED THE STEPS ABOVE
.
