[Akaruz]

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 )

Quote:

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"

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 :

[Akaruz]

Accountserver dir

svrinfo.ini

Quote:

#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

Quote:

[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

Quote:

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

Quote:

[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

[Akaruz]

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

[Ch4rLi3]

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?

[Ch4rLi3]

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

[Akaruz]

Thread Cleaned

For ATZ key Hex crack you need to UNPACK the EXE if they arent yet