Making a GunZ server using an emulator.

1. Get the required files.
2011 emulator binaries itself : http://www.sendspace.com/file/o1uf6x (Extract it to somewhere.)
Gunz client 2011 : https://mega.co.nz/#!5Rx0zbQR!Ti8adC...8VdEuhmi1svHfw
PostgreSQL database server (Directly linked to 9.2.4 version) :
Windows 32bit users : Thank you for downloading PostgreSQL! | EnterpriseDB
Windows 64bit users : Thank you for downloading PostgreSQL! | EnterpriseDB
PostgreSQL ODBC driver (Directly linked to 9.2 version) : http://ftp.postgresql.org/pub/odbc/v...09_02_0100.zip

This tutorial is made by Windows 7 32bit, but it's same as most of 64bit.

2. Install PostgreSQL database server.
Run postgresql-9.2.4-1-windows.exe. (for 64bit, there is "x64" in file name.)
Welcome to the PostgreSQL Setup wizard. Press Next.
Installation directory. Keep it default and press Next.
Data Directory. Change directory path to C:\PostgreSQL data\9.2 (In case of PostgreSQL version 9.2.x) and press Next.
Password. Determine your favorite password for PostgreSQL. Of course, don't forget this password. press Next.
Port. Keep it default and press Next.
Advanced Options. Select C Locale and press Next.
Ready to Install. Press Next and install it. This may take several minutes.
Complete Setup wizard. Untick Stack Builder checkbox and press Finish.

3. Install PostgreSQL ODBC driver.
Extract psqlodbc_09_02_0100.zip to somewhere directory and Run psqlodbc.msi.
Welcome to the psqlODBC Setup Wizard. Press Next.
End-User License Agreement. It's called LGPL. Tick "I accept the terms in the License Agreement" checkbox and press Next.
Custom Setup. Keep it default and press Next.
Press Install and wait.
Setup complete. Press Finish.

4. Create a Gunz Database.
Find pgAdmin III from the start menu. and Run.
There is tree in left-side called Object browser.
Go to Server Groups > Server > PostgreSQL 9.2 (localhost:5432).
Enter your determined password when install. Press OK.
Now you can access the database server from the Object browser.
Right click Databases and select New Database....
Enter gunzdb to the name field and Press OK.
Click newly created database 'gunzdb'. Press Ctrl + E.
Find gunzdb_130706.sql from Emulator files. Drag and Drop it to the Query Tools window.
I think upper right says gunzdb on postgres@localhost:5432. (If it says 'postgres on postgres@localhost:5432' or something else, reselect it to gunzdb.)
Now press F5 button. The gunzdb creation is done.

But an additionally, Query Tool window > Menu > New Window.
Enter

Code:

---

INSERT INTO serverstatus (id, maxplayer, ip, port, name, opened, type)
VALUES(1, 1000, '127.0.0.1', 6000, 'MatchServer1', true, 2);
SELECT insertaccount("id1", "pw");

---

to the query box (Large text field).
Press F5 again.

5. Configure ODBC data source for 'gunzdb'.
(I don't have English version of WIndows OS. The following Window titles and Button names may different.)
Press Windows Key + R. and type :
32bit users : %WINDIR%\system32\odbcad32.exe
64bit users : %WINDIR%\SysWOW64\odbcad32.exe
ODBC data source administrator, We'll add 'gunzdb' to User DSN. Press Add(D).
Create new data source. Select PostgreSQL ANSI from the ODBC dirver list and press Done.
Data Source name. Enter gunzdb.
Server name. Enter localhost.
Database name. Enter gunzdb.
Default authentication. Enter postgres to the Username. and Enter the Password you determined.
Press Test. If it not tells 'Connection Successful', you did something wrong.
Press Save.
Press OK.

6. Configure Emulator.
Go to the emulator folder that you extracted.
Open matchserver.xml and you'll see :

Code:

---

    <DATABASE>    <!-- PostgreSQL connection info. -->
        <USERNAME>postgres</USERNAME>
        <PASSWORD>password</PASSWORD>
        <DSN>gunzdb</DSN>
    </DATABASE>

---

If you completely followed this tutorial, you'll only edit the Red marked part.
Replace with your determined database password.
Save the file.

Also do the same thing to locator.xml.

7. Run Emulator.
Run MatchServer.exe and Locator.exe.
Run client : Gunz.exe (there is in ijjiClone-20130615-2.zip).

Login to MatchServer1 using ID : id1 PW : pw .

Enjoy.


EDIT : Locator problem fixed.

Really really nice work.
I like it.
Thanks 4 the tutorial i was waiting 4 this.

I was expecting something like
1)Make emulator
2)Run emulator
3)Run client
4)???
5)Profit.

Does PostgreSQL have any advantages next to being open-source?
Faster at writing/reading? (When having hundreds of thousands of records?)

I do not understand this part, open the installer and open the console and does not open the installer.

http://oi42.tinypic.com/zxlhfq.jpg

Quote:

---

Originally Posted by wesman2232

I was expecting something like
1)Make emulator
2)Run emulator
3)Run client
4)???
5)Profit.

---

I don't know what should I write...

Quote:

---

Originally Posted by Dave

Does PostgreSQL have any advantages next to being open-source?
Faster at writing/reading? (When having hundreds of thousands of records?)

---

No, there's no great advantages. I just wanted to use it.

Quote:

---

Originally Posted by jorklenis2

I do not understand this part, open the installer and open the console and does not open the installer.

http://oi42.tinypic.com/zxlhfq.jpg

---

Did you try : Right click > Run as administrator ?

Thanks for the tut, will try this soon enough.

nice tut but how no-ip?

Quote:

---

Originally Posted by aV3PQmCJjM9L

I don't know what should I write...


No, there's no great advantages. I just wanted to use it.


Did you try : Right click > Run as administrator ?

---

Yes Right click administrador and not work...

Quote:

---

Originally Posted by jorklenis2

Yes Right click administrador and not work...

---

1. Windows Key + R.
2. Find install-postgresql.log.

and can you post it here?

how no-ip

Quote:

---

Originally Posted by aV3PQmCJjM9L

1. Windows Key + R.
2. Find install-postgresql.log.

and can you post it here?

---

no run never log of "install-postgresql.log."

Quote:

---

Originally Posted by jorklenis2

no run never log of "install-postgresql.log."

---

I can't find the cause of the problem anymore.
If you want to use this emu anyway, it seems require a virtual machine.
Thank you for trying out my emulator...

i have a problem

[ODBC SQL Server Driver] [SQL Server] Login failed for user 'postgres'.
[16/07/2013 12:53:15]

put the user id and password postgres dns odbcad well but when I open the emulator exits only

Quote:

---

Originally Posted by drancerx

i have a problem

[ODBC SQL Server Driver] [SQL Server] Login failed for user 'postgres'.
[16/07/2013 12:53:15]

put the user id and password postgres dns odbcad well but when I open the emulator exits only

---

You're trying to connect to MSSQL ODBC driver that's not supported.
Have you installed PostgreSQL and the ODBC driver?

install it as it says in the tutorial that you put here.

but I did on a virtual pc

you think it is that the problem?

Quote:

---

Originally Posted by drancerx

install it as it says in the tutorial that you put here.

but I did on a virtual pc

you think it is that the problem?

---

Maybe this part :

Quote:

---

Originally Posted by aV3PQmCJjM9L

Create new data source. Select PostgreSQL ANSI from the ODBC dirver list and press Done.

---

If I did that.

so this my settings

http://i39.tinypic.com/333ipow.jpg

regards

Quote:

---

Originally Posted by drancerx

If I did that.

so this my settings

http://i39.tinypic.com/333ipow.jpg

regards

---

Are you sure you installed latest ODBC driver?
Well anyways, In that case, you can change DSN to PostgreSQL30 from gunzdb, in locator.xml and matchserver.xml.

This emulator works with ultra gunz?

Quote:

---

Originally Posted by drancerx

This emulator works with ultra gunz?

---

with current full client of GunZ Ultra, I guess it will work. but you will need to edit system.xml IP and dump all .mef files.

I have a problem when I put "insert in to server status ..... select insertaccount (" idl "," pw "),"

I get this message when giving f5

ERROR: There is no column 'id1'
LINE 3: SELECT insertaccount ("id1", "pw");

Error ********** **********

ERROR: There is no column 'id1'
SQL state: 42703
Character: 155

http://i41.tinypic.com/dg3z1e.jpg

when I want to go with id1, pw

will not let me enter the server says the password is incorrect or id

Problem solved

Umm.. Mind if I can have the emulator files? D:
The link isn't working anymore