2.02 Server guide (May 2006) LOOK HERE

2.02 Server Guide

Ok.. Alot of people in ragezone are having problems setting up their servers or just can't seem to understand what the SEARCH button is for... Well this guide is for those who want to set up a A3 2.02 Server... credit goes to Akaruz for the first guide

First, you need the SERVER FILES : GO LOOK FOR THEM

Still can't get your server up? READ THIS GUIDE again...



First, you need Microsoft SQL 2000.. you can get it at the following links:

Microsoft SQL 2000 = http://www.microsoft.com/downloads/d...displaylang=en

Microsoft SQL update = http://download.microsoft.com/downlo...2/sql2ksp3.exe

A Hex editor = http://www.chmaas.handshake.de/delph...vi32/xvi32.htm

Note: This server is meant to work on D drive not on C:/.. if you do not have a second HDD or drive, simply create a "virtual" drive by downloading this tool : http://www.j-a-associates.com/vdc.htm

Install SQL... Go read the other threads on how to install if you don't know.. your server WILL NOT WORK if you screw the MSSQL 2000 installation..

Install SP3 for MS SQL 2000 (IMPORTANT)

Download the Server file and then unzip the file to D:/ (Make sure it is D:/A3server NOT D:/A3server/A3server..)

IMPORTANT: YOU NEED BDE.. either LOOK for it using google or use it from the 1.20 files.
If you FOLLOW all the steps I have mentioned, it should work...

First click start and go to Microsoft SQL server > Service Manager
Click START server

Go to D:/A3server.. There should be 17 Folders there...

Creating the Databases

Open the SQL server Enterprise manager.. >click start and go to Microsoft SQL server > Enterprise Manager
Go and add 4 databases, A3ItemEvent, ASD, FriendDB, HSDB

Restoring the Databases

You got to restore the DBs.. BUT, instead of looking endlessly for the BAK files in the A3server dir (cos you'll never find it), SQL scripts are PROVIDED instead..

In D:/A3server/Part3SQL
There should be some .SQL and .TXT files inside..

click start and go to Microsoft SQL server > Query Analyser
Connect to your SQL server.. use your username and password..
After that, Click file and open; go to D:/A3server/Part3SQL and select ASD.sql
A whole list of commands should appear in the box.. RIGHT CLICK the box and click EXECUTE... Restoration of ASD DB is complete..

Now do the same method for the 3 other DBs using the table below.. you click new/Blank query for each time..

DATABASE : FILE
ASD : ASD.sql (DONE)
HSDB : A3HSDB.txt
FriendDB : Friend24.txt
A3ItemEvent : A3itemEvent.txt

Next, go and Create a new user login;

Create a new user,

Login = a3serial
Password = dkdlxpawprhdnpc

Set DB Owner = A3ItemEvent.txt

its all on 新数据库配置说明.txt file...

This is the ODBC reg file that Akuraz posted in his guide:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI]

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3Friend ]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="FriendDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3RcvRes ult]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="A3ItemEvent"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3Serial List]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="A3ItemEvent"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\EventA3]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="ASD"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\FriendDB ]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="HSDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\HSDB]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="HSDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LETTERDB ]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="FriendDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LocalSer ver]
"Description"=""
"Server"="(Local)"
"Trusted_connection"=""
"UseProcForPrepare"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Login202 ]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="ASD"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\NEWASD]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="ASD"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
"LocalServer"="SQL Server"
"A3RcvResult"="SQL Server"
"A3SerialList"="SQL Server"
"FriendDB"="SQL Server"
"NEWASD"="SQL Server"
"Login202"="SQL Server"
"LETTERDB"="SQL Server"
"EventA3"="SQL Server"
"A3Friend"="SQL Server"
"HSDB"="SQL Server"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC File DSN]
"DefaultDSNDir"="C:\\Program Files\\Common Files\\ODBC\\Data Sources"="(Local)"

First, COPY the whole reg text into your notepad... Change all those "Server"="(Local)"
to your Server name.. for example, if your server name is SERVER4 then change it to "Server"="(SERVER4)"

Change it for all of them.. It's as simple as that... then, save it as A3.reg.. and run it.. click ok and the reg will be added to your registry... your ODBC entries are done..

After that, change every single IP address to your IP address (192.168.X.X for LAN or your IP address for WAN) in all the .ini and .cfg files..

After that, LOOK at all the ini/cfg for your username and password and replace them respectively..

Create:

C:\A3log
C:\Clan
C:\Zonelog
C:\A3LogBackup
C:\A3_ClanMarkData


If all goes well, you can start your server;
do in the following order:

1- 01Account = 7770 dir
2- 02Character = 8880 dir
3- 03ItemStorage = 9990 dir
4- 04LoginServer = Loginserver dir
5- 05LoginAgent = Loginagent dir
6- 06Zoneagent = Zoneagent dir
7- 07MainServer= Mainserver dir
8- 08Accountserver= Accountserver dir
9- 09Zoneserver = Zoneserver dir (If it has Game init Error, LOOK the Guide again)
10- 10Battleserver = Battleserver dir

If all goes well, your server should be running.. next you must find a suitable client to run with your server.. you can try to find the ara3 client (which I think is impossible to find) or the A3 SG's client ; www.a3.com.sg
Like what I mention in my other guide, Hex the A3client.exe to change your IPs to your server's....

That's all.. I will update as soon as I have more "strong" solutions..

yup... it was through the game init errors I read through the console that I was able to finally get my zoneserver to run..

hi..!
i abit confuse at then instruction when :

Next, go and Create a new user login;

Create a new user,

Login = a3serial
Password = dkdlxpawprhdnpc

Set DB Owner = A3ItemEvent.txt

its all on 新数据库配置说明.txt file...
------------------------------------------------------------

is it like this security>logins>new login i cant seems to find the login and password or even the " Set DB Owner" fields.

sorry if i done some mistake and hope you can explain it in more detailed procedure..!
hopefully you can help me with this..

okok no problem, go to Enterprise manager, click on your server... there should be Database Database transformation services, Management etc etc..

Click on Security > right click logins and New Logins..

Name put a3serial

then select the SQL auth. Box and put in the password I mentioned there. (I'm too lazy to type it out in this post.)

Click on the database acess tab and select A3ItemEvent, then below, select db_owner..

hope this helps..

Cheers,
Ghoststalker

thanks Legendary you so helpfully..!
your guides are even more specific and better to understand then the moderator explain..!
also thanks to RudyMartin for explaining about the sql stuff...
thanks again..

like RudyMartin remind us that some server file are infected with virus..
yes indeed i have download the current files and my pc-cillin trend micro detect a various kind of thread like trojan horse and worms..
i hope moderator of this section can clear this bad server files

hi legendary. i have a problem with the zoneserver. just like u post up there it has a game init error. i have triple check the guide. can u help me?

ok can you post a screenshot of what the zoneserver.exe console says? I think I might be able to help

Quote:

---

Originally Posted by Legendary

2.02 Server Guide

Ok.. Alot of people in ragezone are having problems setting up their servers or just can't seem to understand what the SEARCH button is for... Well this guide is for those who want to set up a A3 2.02 Server... credit goes to Akaruz for the first guide

First, you need the SERVER FILES : http://files.filefront.com/a/fileinfo.html

Still can't get your server up? READ THIS GUIDE again...



First, you need Microsoft SQL 2000.. you can get it at the following links:

Microsoft SQL 2000 = http://www.microsoft.com/downloads/d...displaylang=en

Microsoft SQL update = http://download.microsoft.com/downlo...2/sql2ksp3.exe

A Hex editor = http://www.chmaas.handshake.de/delph...vi32/xvi32.htm

Note: This server is meant to work on D drive not on C:/.. if you do not have a second HDD or drive, simply create a "virtual" drive by downloading this tool : http://www.j-a-associates.com/vdc.htm

Install SQL... Go read the other threads on how to install if you don't know.. your server WILL NOT WORK if you screw the MSSQL 2000 installation..

Install SP3 for MS SQL 2000 (IMPORTANT)

Download the Server file and then unzip the file to D:/ (Make sure it is D:/A3server NOT D:/A3server/A3server..)

IMPORTANT: YOU NEED BDE.. either LOOK for it using google or use it from the 1.20 files.
If you FOLLOW all the steps I have mentioned, it should work...

First click start and go to Microsoft SQL server > Service Manager
Click START server

Go to D:/A3server.. There should be 17 Folders there...

Creating the Databases

Open the SQL server Enterprise manager.. >click start and go to Microsoft SQL server > Enterprise Manager
Go and add 4 databases, A3ItemEvent, ASD, FriendDB, HSDB

Restoring the Databases

You got to restore the DBs.. BUT, instead of looking endlessly for the BAK files in the A3server dir (cos you'll never find it), SQL scripts are PROVIDED instead..

In D:/A3server/Part3SQL
There should be some .SQL and .TXT files inside..

click start and go to Microsoft SQL server > Query Analyser
Connect to your SQL server.. use your username and password..
After that, Click file and open; go to D:/A3server/Part3SQL and select ASD.sql
A whole list of commands should appear in the box.. RIGHT CLICK the box and click EXECUTE... Restoration of ASD DB is complete..

Now do the same method for the 3 other DBs using the table below.. you click new/Blank query for each time..

DATABASE : FILE
ASD : ASD.sql (DONE)
HSDB : A3HSDB.txt
FriendDB : Friend24.txt
A3ItemEvent : A3itemEvent.txt

Next, go and Create a new user login;

Create a new user,

Login = a3serial
Password = dkdlxpawprhdnpc

Set DB Owner = A3ItemEvent.txt

its all on 新数据库配置说明.txt file...

This is the ODBC reg file that Akuraz posted in his guide:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI]

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3Friend ]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="FriendDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3RcvRes ult]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="A3ItemEvent"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3Serial List]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="A3ItemEvent"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\EventA3]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="ASD"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\FriendDB ]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="HSDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\HSDB]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="HSDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LETTERDB ]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="FriendDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LocalSer ver]
"Description"=""
"Server"="(Local)"
"Trusted_connection"=""
"UseProcForPrepare"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Login202 ]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="ASD"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\NEWASD]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="ASD"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
"LocalServer"="SQL Server"
"A3RcvResult"="SQL Server"
"A3SerialList"="SQL Server"
"FriendDB"="SQL Server"
"NEWASD"="SQL Server"
"Login202"="SQL Server"
"LETTERDB"="SQL Server"
"EventA3"="SQL Server"
"A3Friend"="SQL Server"
"HSDB"="SQL Server"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC File DSN]
"DefaultDSNDir"="C:\\Program Files\\Common Files\\ODBC\\Data Sources"="(Local)"

First, COPY the whole reg text into your notepad... Change all those "Server"="(Local)"
to your Server name.. for example, if your server name is SERVER4 then change it to "Server"="(SERVER4)"

Change it for all of them.. It's as simple as that... then, save it as A3.reg.. and run it.. click ok and the reg will be added to your registry... your ODBC entries are done..

After that, change every single IP address to your IP address (192.168.X.X for LAN or your IP address for WAN) in all the .ini and .cfg files..

After that, LOOK at all the ini/cfg for your username and password and replace them respectively..

Create:

C:\A3log
C:\Clan
C:\Zonelog
C:\A3LogBackup
C:\A3_ClanMarkData


If all goes well, you can start your server;
do in the following order:

1- 01Account = 7770 dir
2- 02Character = 8880 dir
3- 03ItemStorage = 9990 dir
4- 04LoginServer = Loginserver dir
5- 05LoginAgent = Loginagent dir
6- 06Zoneagent = Zoneagent dir
7- 07MainServer= Mainserver dir
8- 08Accountserver= Accountserver dir
9- 09Zoneserver = Zoneserver dir (If it has Game init Error, LOOK the Guide again)
10- 10Battleserver = Battleserver dir

If all goes well, your server should be running.. next you must find a suitable client to run with your server.. you can try to find the ara3 client (which I think is impossible to find) or the A3 SG's client ; www.a3.com.sg
Like what I mention in my other guide, Hex the A3client.exe to change your IPs to your server's....

That's all.. I will update as soon as I have more "strong" solutions..

---

Can u erase http://files.filefront.com/ileinfo.html this?

There is my page...........and i don't want anyone to know my page anymore.
Because i'm using my page for our server's foreigners.

Plz erase that address as soon as possible.

Thank you.

Where i can download 2.02 client ? Thanks

Quote:

---

Originally Posted by toxic3

Can u erase this?

There is my page...........and i don't want anyone to know my page anymore.
Because i'm using my page for our server's foreigners.

Plz erase that address as soon as possible.

Thank you.

---

ok sure.. sorry for using your page ^_^

here i attach the error screenshot. hope u can help me :)

Your 2 quotas still show the link! ;) zomg zomg thx :P

edit the server link

to the guy with the screenshot its tooooooooo small i cant see it

sorry that the image was way toooo small :). well heres another one

check your DB entry.. I will give you a clue, your ODBC is WRONG.. read the guide and try again