Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

A3 202/205 Server Setup Guide (Akaruz)

Status
Not open for further replies.
Joined
Dec 1, 2003
Messages
14,812
Reaction score
77
Since you guys dont bother looking to the files the server has

SQLS DB

all on Part3SQL directory

Files = SQL DB names
db.sql = ASD
A3ItemEvent.txt = A3Itemevent
A3HSDB.txt = HSDB
Friend24.txt = FriendDB

SQL LOGINS
Create a new user

Login = a3serial
PAssword = dkdlxpawprhdnpc

Db Owner = A3ItemEvent.txt

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


ODBCS -
This is my odbc.reg file ( i think its better give you like this since you guys cant even look for them )
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\A3RcvResult]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="A3ItemEvent"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3SerialList]
"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\LocalServer]
"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"

Directories to create

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


Install BDE ( you can find it on 1.20 server if you dont have it or search on the Internet
Use the Mkdir.exe inside the \ACCOUNT dir and \CLAN dir to make the directories ( 000-999 )

edit the tdb.ini inside 7770 , 8880 9990 to meet your login and password of your sql ( SA in this case )

edit on Accountserver dir :
 
Joined
Dec 1, 2003
Messages
14,812
Reaction score
77
Accountserver dir

svrinfo.ini
#Account Server Info.
[SvrInfo]
ServerVersion=202

#World Information
#酚 MAIN SERVER  CONFIG 跑笆
WorldIndex=0
WorldName=Server

#This Server Information ( 砞﹚ ACCOUNT SERVER )
ThisServerID=255
ThisServerIP=127.0.0.1
ThisServerPort=5589

#MainServer Information ( 砞﹚ MAIN SERVER)
MainServerIP=127.0.0.1
MainServerPort=7789

#Gate count ( 砞﹚ ZONE AGENT 计ヘ )
GateServerNum=1

#Account File DB Path
AccountRootPath=E:\Server\A3server\Account : Edit it to meet your account path

#DB ( comment temporarily )
AccntCharDBServer=Login202
AccntCharDBLogin=sa
AccntCharDBPasswd= your sa password

# For monitoring service
UDPPort=9000
ServicePort=9500
Loginservre dir
Loginserver.ini
[STARTUP]
APPNAME=LOGINSERVER
ZONEAGENTLISTENPORT=3200
LOGINAGENTLISTENPORT=3210
STARTID=10063

[LOGINASD]
COUNT=1
IP0=192.168.0.3 Put your wan ip here
PORT0=7770 you might have the wrong port this is the correct

[PAYASD]
COUNT=0
IP0=127.0.0.1
PORT0=3450

[SERVER_GROUP]
COUNT=1

ID0=0
NAME0=Server

Mainserver dir
svrinfo.ini
....
...
[ODBC]
ODBCNAME=FriendDB
ODBCID=sa
ODBCPASS= your sa password

[Update Log Info]
ClanPath=C:\clan : Edit to meet your clan dir
LogPath=C:\clan\LOG : Edit to meet your clan dir

[Clan Web DB Info]
SourceName=ASD
UserName=sa
PassWd= your sa password

[ClanInfo]
;bInitNameTable=1
;nSaveClanLog=1

[HSDB]
ODBCNAME=HSDB
ODBCID=sa
ODBCPASS= your sa password
Zoneagent dir
zoneagent.ini

[STARTUP]
APPNAME=ZONEAGENT
SERVERID=0
AGENTID=0
#ZONE AGENT 硂柑セ诀 IP
IP=192.168.0.3 : Put your wan ip here
PORT=3300

[ZONESERVER]
COUNT=3


#Account SErver
ID0=255
IP0=127.0.0.1
PORT0=5589

#Zoneserver1
ID1=0
IP1=127.0.0.1
PORT1=6689

#BattleServer
ID2=1
IP2=127.0.0.1
PORT2=6999

[LOGINSERVER]
IP=127.0.0.1
PORT=3200
 
Last edited:
Joined
Dec 1, 2003
Messages
14,812
Reaction score
77
and I think this is enough for you

btw to start server =


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
10- 10Battleserver = Battleserver dir
 
Junior Spellweaver
Joined
Nov 18, 2005
Messages
125
Reaction score
0
Where
Zoneagent
search 84 C0 75 1F B2 01 B8 DC C7 46 00
replace 84 C0 EB 1F B2 01 B8 DC C7 46 00
Mainserver
search 85 C0 75 14 68 7C 51 4E 00
replace 85 C0 EB 14 68 7C 51 4E 00
AccountServer
Search 85 C0 75 07 33 C0
Replace 85 C0 EB 07 33 C0
Zoneserver
search 85 C0 74 14 68 38 99 65 00
replace 85 C0 EB 14 68 38 99 65 00
Locate ? at where?
and how to change it?
 
Junior Spellweaver
Joined
Nov 18, 2005
Messages
125
Reaction score
0
Can some 1 post working link without change
this ==>>Zoneagent
search 84 C0 75 1F B2 01 B8 DC C7 46 00
replace 84 C0 EB 1F B2 01 B8 DC C7 46 00
Mainserver
search 85 C0 75 14 68 7C 51 4E 00
replace 85 C0 EB 14 68 7C 51 4E 00
AccountServer
Search 85 C0 75 07 33 C0
Replace 85 C0 EB 07 33 C0
Zoneserver
search 85 C0 74 14 68 38 99 65 00
replace 85 C0 EB 14 68 38 99 65 00
 
Status
Not open for further replies.
Back
Top