Making a GunZ server using an emulator.

[aV3PQmCJjM9L]

1. Get the required files.
2011 emulator binaries itself :

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

(Extract it to somewhere.)
Gunz client 2011 :

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

PostgreSQL database server (Directly linked to 9.2.4 version) :
Windows 32bit users :

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

Windows 64bit users :

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

PostgreSQL ODBC driver (Directly linked to 9.2 version) :

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

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

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

. 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

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 :

    <DATABASE>    <!-- PostgreSQL connection info. -->
        <USERNAME>postgres</USERNAME>
        <PASSWORD>[COLOR=#ff0000]password[/COLOR]</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.

 

[yerij007]

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

 

[wesman2232]

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

 

[Dave]

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

 

[jorklenis2]

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

 

[aV3PQmCJjM9L]

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

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.

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

Did you try : Right click > Run as administrator ?

 

[Patrick2607]

Thanks for the tut, will try this soon enough.

 

[Ragad Khamaisi]

nice tut but how no-ip?

 

[jorklenis2]

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

 

[aV3PQmCJjM9L]

Yes Right click administrador and not work...

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

and can you post it here?

 

[Ragad Khamaisi]

how no-ip

 

[jorklenis2]

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

and can you post it here?

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

 

[aV3PQmCJjM9L]

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

 

[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

 

[aV3PQmCJjM9L]

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?

 

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

 

[aV3PQmCJjM9L]

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 :

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

 

[drancerx]

If I did that.

so this my settings

regards

 

[aV3PQmCJjM9L]

If I did that.

so this my settings

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.

 

[drancerx]

This emulator works with ultra gunz?