A3 202/205 Server Guide

A3 202/205 Server Guide

Things that you need:

Server Files
Recommended Server Files:
Filefront:
[You must be registered and logged in to see this link.]
Rapidshare
[You must be registered and logged in to see this link.]


Additional Server Files can be found at:
[You must be registered and logged in to see this link.]

Client
Client is uploaded into 5 parts:
[You must be registered and logged in to see this link.]

Microsoft SQL Server 2000
[You must be registered and logged in to see this link.]



Microsoft SQL Server Service Pack 4 Update
[You must be registered and logged in to see this link.]

*****All Links are Updated and working fine! (29th May 2008 10:20:44 PM)*****


Setting Up server:
I have writen the Guide in accordance with the Recommended server files keeping in mind the

default configs. If you use any other server files, you need to edit some basic stuff first!

First of all, we must install the SQL Server 2000.
SQL Server is Structured Query Language, which is a database software which stores the data

pertaining to our A3 Server. Hence we need to configure it to store our Server's data!
The Installation of SQL Server is depicted in the following Screenshots!



Select Local Computer if you are installing databases on the same computer.



Select Create a new instance



Provide your Personal Information



Accept the License Agreement



Select Server and Client Tools



Check the Default Instance and Click Next



Select the Installation type



Check the "Use Local System Account button"



Now this is the Important Step! Select Mixed Authentication Mode and now Enter User ID as

"sa" and password is your wish.



Once you have finished installing SQL Server, you need to start the SQL Server Service. To

Start this,

Start -> Programs -> Microsoft SQL Server -> Service Manger

Service Manager will look like this:


Under Services, select SQL Server and then click on the Play(Start) button to start the

service. Once the service is started, a Play button is indication near the server figure!

Now, you need to Create and Restore databases! To do this,
Start -> Programs -> Microsoft SQL Server -> Enterprise Manager

Now in the Enterprise Manager, on the left hand side of Hirarichal window, Expand the Local

System key, and then expand the Databases Key

Now right click on the Right hand side of the Enterprise Manager and select "New Database"
The following window will Pop up!



In the Database Name, just enter ASD and click OK. A new Database is now created.
In the same way, you need to create a total of

ASD (already created)

Character

A3ItemEvent

Itemstorage

FriendDB

HSDB

Once you have finished creating the databases, you need to restore the databases!
To restore the databases, follow the following steps!

Right Click on the ASD Database. Select "All tasks" and then select "Restore Database"
A Window Pops up! Now Select "From Device". Click on "Select Devices" and then click on

"Add". The following window pops up!


Now You need to select the ASD.bak file which is present in the Database Backup folder of

the A3Server files.

In the same way, you need to restore all the databases


ASD - ASD.bak (already restored)

Character - Character.bak

A3ItemEvent - A3Itemevent.bak

Itemstorage - Itemstorage.bak

FriendDB - FriendDB.bak

HSDB - HSDB.bak

After finishing the database restore, you need to create a new user login!

On the Left pane of the Enterprise Manager, Expand Security Key and then click on Logins.
Right click in the right pane and click on New Login. The procedure is depicted in the

screenshot



In the Name, type "a3serial". Select SQL Authentication and in the Password box, type the

following password "dkdlxpawprhdnpc". The procedure is depiced in the Screenshot


Once done, click on the Database Access Tab.
Tick Pemit Check Box for the A3ItemEvent Database. In the bottom window check mark

"db_owner". The procedure is depicted in the screenshot.



Now, You need to create ODBC for your SQL Server Databases. This can be done either by

adding values directly to Registry or by adding them manually. Inorder to Make it easy, I

have included a ODBCSetup.reg file in A3Server folder of the Server Files. Just execute it

and all the ODBC are created automatically.

You need to install Borland Database Engine, which is needed by the server to connect to the

SQL Database. This Library is present in the Server Files (BDESetup)

Open the Drive C folder in the A3 Server Files that you have downloaded. Copy all those

directories and paste them in C:\ root directory.

Starting The server.

Inorder to start a server, you need to run different servers in a particular order!

Setting Up 7770, 8880, 9990
In the Server Files, you will find 3 folders named 7770, 8880 and 9990. They have 2 files in

them!

Now, Open the tbd.ini present in the 7770 folder
It contains the following;

Quote:
[main]
title=A3ASD 7770
keepalive=10

[dbconnection]
00=h3db00 A3ASD sa sa account 0 1
01=h3db01 A3ASD sa sa account 0 1
02=h3db02 A3ASD sa sa account 0 1
03=h3db03 A3ASD sa sa account 0 1
04=h3db04 A3ASD sa sa account 0 1
05=h3db05 A3ASD sa sa account 0 1
06=h3db06 A3ASD sa sa account 0 1
07=h3db07 A3ASD sa sa account 0 1
08=h3db08 A3ASD sa sa account 0 1
09=h3db09 A3ASD sa sa account 0 1
10=h3db10 A3ASD sa sa account 0 1
11=h3db11 A3ASD sa sa account 0 1
12=h3db12 A3ASD sa sa account 0 1
13=h3db13 A3ASD sa sa account 0 1
14=h3db14 A3ASD sa sa account 0 1
15=h3db15 A3ASD sa sa account 0 1

[socket]
port=7770
Here, you need to replace the second "sa" with the sa password that you have provided during

your SQL Server Installation. Suppose you have provided the password "mania", then the

config file should look like this!

Quote:
[main]
title=A3ASD 7770
keepalive=10

[dbconnection]
00=h3db00 A3ASD sa mania account 0 1
01=h3db01 A3ASD sa mania account 0 1
02=h3db02 A3ASD sa mania account 0 1
03=h3db03 A3ASD sa mania account 0 1
04=h3db04 A3ASD sa mania account 0 1
05=h3db05 A3ASD sa mania account 0 1
06=h3db06 A3ASD sa mania account 0 1
07=h3db07 A3ASD sa mania account 0 1
08=h3db08 A3ASD sa mania account 0 1
09=h3db09 A3ASD sa mania account 0 1
10=h3db10 A3ASD sa mania account 0 1
11=h3db11 A3ASD sa mania account 0 1
12=h3db12 A3ASD sa mania account 0 1
13=h3db13 A3ASD sa mania account 0 1
14=h3db14 A3ASD sa mania account 0 1
15=h3db15 A3ASD sa mania account 0 1

[socket]
port=7770
Save the File and then run the asd_mw_v1.1.19a.exe which is present in the same folder.
Click on the first "Click" button. Then click on second "Click" button and then click on

"Start". If you have followed the guide fine, it will look as follows



Similarly you need to edit tbd.ini files in both 8880 as well as 9990.

7770 - Account
8880 - Character
9990 - Itemstorage
These servers are responsible to connect the Mainservers to the Database!
at last ur server is ready
run the following files
1: D:\a3server\0DB_PORT\7770\asd_mw_v1.3.21a Similarly do it in 8880 & 9990 folders
2: D:\a3server\1LoginServer\newLoginServer
3: D:\a3server\2Loginagent\enLoginAgentr (Wait until you get run OK message else run it again)
4: D:\a3server\3Zoneagent\EnZa_v2.0.16a
5: D:\a3server\4mainserver\MainServer.exe
6: D:\a3server\6accountserver\AccountServer.exe
7: D:\a3server\7Zoneserver\Zoneserver.exe(24.7mb)
8: D:\a3server\8BattleServer\BattleServer.exe
9: D:\a3server\9new\CenterServer.exe
10: D:\a3server\5A3_Util\MWCLDB.exe

if all goes well u server starts and enjoy

How to hex IP?