[Guide] Setting Up Your Server

[iNs@nE]

SETTING UP YOUR OWN TANKY ONLINE SERVER

Step 1: Downloading the required files.

Server Files:

You must be registered to see links

Client:

You must be registered to see links

- Thanks To whitemist for the upload.
SQL Server 2000:

You must be registered to see links

(Upgrade to SQL Server 2000 SP3 Patch Recommended)

Step 2: Setting Up The Databases

After downloading the SQL Server 2000 and the server files - install and extract them to their respective folders.

> Then open Enterprise Manager in SQL Server 2000.
> Then to go Databases and create a new database by right clicking. Name it qtank.
> Then go to Logins and create a new login by right clicking it. Set the name to tanky and the password to 1111 (the password should be in the SQL Authentication column). Once this is done, set the login master database to qtank and give it owner rights by setting it as the db_owner.

Now the database has been created. You need to restore the database.

> Open Query Analyzer in SQL Server 2000.
> Authenticate using your SQL master password and you will enter Query Analyzer.
> There you need to open the tanky.sql file that comes along with the server files. Once this is opened, set your database to qtank at the top and click on the green button (which looks like play button) or inshort, RUN it.

Congratulations, You have successfully restored your database.

Step 3: Setting Up the ODBC's

> Open Control Panel - Administrative Tools - Data Sources (ODBC) - System DSN Tab
> Click Add and choose SQL Server (which is at the end of the list).
> Enter the name as qtank and set your server name (which you can find in the Service Manager of SQL Server 2000).
> Then set to SQL Server Authentication and enter your ID: sa and Password: (your master password)
> Then tick change default database to and choose qtank
> In the end - Test Database and it it works successfully, then you are all set.

Congratulations on setting your ODBC's correctly.

Step 4: Configuring Your Server Files

Open your server files folder where you will find LoginServerSetup.dat and ServerSetup.dat. Open these files using Wordpad.

LoginServerSetup.dat

[SERVERDATA]
VERSION = 101001

This is the version of your server. Your server and client version should match each other to avoid incompatibility problems.

ServerSetup.dat

[LOGINSERVERIP]
IP =127.0.0.1
[SERVERDATA]
SN = 2
NAME =Tanky RaGEZONE

Set your IP Address to either you local (127.0.0.1) if you want to host it offline or to your LAN (192.168.1.XXX) if you want to host it on your local area network and your WAN IP if you want to host it over the internet.

SN Value is the number of rooms setup on the server.
Name is the name of your server which your clients will see.

Step 5: Configuring Your Client

> In your client folder, you will find the following files - ClientSetup.dat
> Open the file in WordPad and edit the IP line to the same you mentioned in the ServerSetup.dat

Congratulations! You have successfully configured your server and client files.

Step 6: Launching Your Server

Execute your LogInServer.exe first and then your QTankSvr.exe. After executing both, you should see a value 1 and the IP setup on your Login Server. This means your server has started with no errors.

Congratulations On Setting Up Your Server!

Miscellaneous: Editing Your Databases

Creating A User ID:
> Open your Enterprise Manager - Databases -Tables
> Go to the table "UserData" and right click it. Go to Open Table - Return All Rows.
> Here you can enter the values you wish and create your User ID.

You can also do the same for the rest of the tables present in the database to edit the respective stuff they stand for.

Thank You,
-- iNs@nE
​

 

[trespazzer]

Thank you very much for your guide. Perfect.

One question ? You think this game is boring or fun ? Pls share.

Thank you again.

 

[ThuGie]

One question why sp3 when there's a sp4 ?

You must be registered to see links

 

[chaicity]

What error ????

 

[livewirecebu]

One question why sp3 when there's a sp4 ?

You must be registered to see links

I think its just a recommended to run the server and SP4 i think is much better.

 

[somchai2006]

What error ????

i have same ploblem. Please Help..

 

[Equal]

i have same ploblem. Please Help..

The database is not complete.

I attached a sql query file which should have the Log-in problem fixed. (Not much edited only added two tables.) Still has the bug when disconnecting from a room the server crashes.

Good luck.

 

[ThuGie]

Right i will install mssql and check if i can fix the errors it shouldnt be a to big of problem i will tell the progress .

 

[markmark]

What error ????

Same error

 

[somchai2006]

The database is not complete.

I attached a sql query file which should have the Log-in problem fixed. (Not much edited only added two tables.) Still has the bug when disconnecting from a room the server crashes.

Good luck.

not work!

Server: Msg 2715, Level 16, State 7, Line 2
Column or parameter #22: Cannot find data type date.
Server: Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'dbo.UserData' because this table does not exist in database 'qtank'.

why not?..........

 

[Equal]

My mistake, re-download and run in the query analyzer. Instructions below.

Now the database has been created. You need to restore the database.

> Open Query Analyzer in SQL Server 2000.
> Authenticate using your SQL master password and you will enter Query Analyzer.
> There you need to open the tanky.sql file that comes from Equal's attachment. Once this is opened, set your database to qtank at the top and click on the green button (which looks like play button) or inshort, RUN it.

Congratulations, You have successfully restored your database.

 

[somchai2006]

My mistake, re-download and run in the query analyzer. Instructions below.

not work!...

Server: Msg 2716, Level 16, State 1, Line 2
Column or parameter #22: Cannot specify a column width on data type datetime.
Server: Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'dbo.UserData' because this table does not exist in database 'master'.

you can test file before post.Thank.:flag_schw

 

[iNs@nE]

not work!...

Server: Msg 2716, Level 16, State 1, Line 2
Column or parameter #22: Cannot specify a column width on data type datetime.
Server: Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'dbo.UserData' because this table does not exist in database 'master'.

you can test file before post.Thank.:flag_schw

Read that line. It says your dbo.UserData does not exist in db 'master'. Restore your db to the master database too. It's evident. No need to be mentioned. Your problem will be fixed.

 

[melikeme]

Funny XD << thanks alot for guide so usefull

 

[ThuGie]

Here's the resource page so you know how much memory etc you will need to play the game itself found it at

You must be registered to see links

ofcourse what needed translation is translated so far i was guessing what it should be .

you could put it on your private server webpage or something .

 

[melikeme]

The database is not complete.

I attached a sql query file which should have the Log-in problem fixed. (Not much edited only added two tables.) Still has the bug when disconnecting from a room the server crashes.

Good luck.

This one is bugged i used the normal one is correct it has userdata but this dosent

 

[Equal]

This has UserData but I made another mistake >.> Just make a snm and PlayTime table into UserData and it should be fixed.

 

[ThuGie]

i think it should be placed here but enter your ingame name into snm .
currently i havent found out why it crashes when you leave.. but i just started.

 

[RedMG]

Many thanks Insane for a perfect guide. You always make me happy whenever i read your post !!! Keep on doing your job !

 

[Vampire]

Thnx Ins@ne for ur Guide and good work but i prefer SQL 2005 with new update