ok guys since you were having too many problems , there's the compilation of the server :
1. all maps.
2. 80% of mobs , 20% of items in quests are in english.
3. petcount fix.
4. 300% xp , Item drop increased .
5. Quest levels fixed ( 80% ).
6. Dog Race & Lottery Events On.
7. Clan Working.
8. Clan quests working.
http://mmorpg.ragezone.com/a3/a3servereng.exeBeing uploaded ( FILE SIZE = 11MB )
ITS MADE to work on D:
inside the exe = a3server , and all dirs that should be on d:\ ( root )
if you change your drive you need to HEX the files ( at least Accountserver , mainserver and zoneserver ones ( change d:\ to c:\ ( or the drive you use )
inside loginserver.cfg change also to the drive you have your files )
YOU ONLY NEED TO CHANGE the 192.168.0.2 TO YOUR LAN IP OR YOUR WAN IP ( DO NOT TOUCH ON THE 127.0.0.1 ONES
Check also the paths where point to D: you change to the drive you want )
When restoring the DB ( if you change the drive you need to be caution and set the target dir to the correct one )
Just CHANGE all si26208$$ to your SA password ( its like the ADMIN password for sql ( YOU SET IT when you install the SQL for the 1st time )
you need SQL2000 + Service PACK 3 ( SQL service pack ), Case Sensitive Coallition
THE ODBCS you can set to Windows Authentication
Inside d:\a3server you have a manual
d:\a3server\Tools ( 4 files , Client patch ( english ones ) , A3GM-Tools ( its just a program to log into db and change the stats you want ( ITs BUGGED ) , Ull decoder ( BACK UP your files before doing anything )
NOTE:
if its your 1st time installing it ( you need to run the 1st time dir ( inside A3 Links dir ) to set up DBE , account dir and clan dir )
On the 1st 3 links ( AFTER RUNNING THE 1st time ) the links need to be started like 1st button , 2nd button , ( WHEN 3rd BUTTON APPEARS in BLACK you click on it ( ONLY GO to the next LINK AFTER SEEING THE GREEN LIGHT ( RUNNING )
Only after having the 3 links in GREEN you move to the next link
Clans:
( YOU DONT NEED TO USE Link4 - that MDWCLAN is for Webclan and its not working ) ( to the admin ones you can get item 806,807,808,809 ( grail , tig , red and blue handbook ( use the one of your country )
You need level 80 or higher , 30,000 lore , 1,000,000 Gold
Method 1: Fast
Example go to itemstorage and on your char do 806;0;1 ( log into your char then pick it , go back to sql and insert 808;0;1
( this is on itemstorage db , on the itemstorage of your char )
( example = 808= item code ;0 = id of code ; 1 = storage position ; )
Then go to the statue ( Pakistan (blue ) or 2nd map of red ), 2nd tab , you can create your clan , to add ppl to clan they need to ask your to join clan ( SHIFT CLICK - choose clan )
Method 2 = Slow do the quest with 3 mates
go to your character db and on CQUEST part , you change the 65355 to 1067 ( just the number not the 0 ( keep them )
when you enter on game you will have the quest 1067 running ( you need to get 1 heart from wolf 4 ( the girls ) and then deliver to the duel npc ( behind portal girl )
he will give you a tig and the handbook
with those 2 items you get +3 players with you ( level 80 or higher ) all party and go to the statue ( Pakistan = blue country ) click on it you will go to another map
in that map you have 10 min to find the entrance to the Treasure room, you need to kill someone to get the grail
then on the same statue , 2nd tab , you can create your clan , to add ppl to clan they need to ask your to join clan ( SHIFT CLICK - choose clan )
Ok and thats all
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
- Quote :
- [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 :
Edit all the following files in A3Server Folder
Loginserver/Loginserver.ini
- Quote :
- [STARTUP]
APPNAME=LOGINSERVER
ZONEAGENTLISTENPORT=3200
LOGINAGENTLISTENPORT=3210s
STARTID=151796
[LOGINASD]
COUNT=1
IP0= Put your Internet IP(WAN IP) address here
PORT0=7770
[PAYASD]
COUNT=0
IP0=127.0.0.1
PORT0=3450
[SERVER_GROUP]
COUNT=1
ID0=0
NAME0=Put name of your server here
Loginagent/Loginagent.ini
- Quote :
- ;//////////////////////////////////////////////////////////////////////////////////////////
;//GameServer ȯ°æ º¯¼ö ¼³Á¤ ÆÄÀÏ
;//////////////////////////////////////////////////////////////////////////////////////////
[VersionInfo]
HighVersion = 600 ;//CurrVersion <= HighVersion
LowVersion = 100 ;//CurrVersion > LowVersion
[LoginAgent] ;//tcp
IPADDR = Put your Internet IP(WAN IP) address here
PORT = 3550
IO_MODE = 1 ;// iocp = 1, block = -1
APPNAME = LOGINAGENT
AGENTID = 1
[LoginServer] ;//tcp
IPADDR =
PORT = 3210
IO_MODE = -1 ;// iocp = 1, block = -1
[LOG_FILE] ;//log set
GS_LOGFILE_NAME = ./LogFile/gs_log
LC_LOGFILE_NAME = ./LogFile/lc_log
DB_LOGFILE_NAME = ./LogFile/db_log
MAINPROCESS_LOGFILE_NAME = ./LogFile/mp_log
ZoneAgent/Zoneagent.ini
- Quote :
- [STARTUP]
APPNAME=ZONEAGENT
#¥Nªí²Ä´X²Õ,²Ä 5 ²Õ´Nñ 5
SERVERID=0
#¥Nªí³o²Õ²Ä´X? ZONE AGAIN, 0 ~ 3
AGENTID=0
#ZONE AGENT ³o¸Ì??¾÷ªº IP
IP=Put your Internet IP(WAN IP) address here
PORT=3300
[ZONESERVER]
#¥Nªí ZONE SERVER ªº¼Æq
COUNT=4
#³oO©T©wªº*n³s¨ì ACCOUNT SERVER
ID0=255
IP0=127.0.0.1
PORT0=5589
#ZONE SERVER ?©w
#¥Nªí²Ä 1 ²Õ
ID1=0
IP1=127.0.0.1
PORT1=6999
#¥Nªí²Ä 2 ²Õ
ID2=1
IP2=127.0.0.1
PORT2=7090
ID3=4
IP3=127.0.0.1
PORT3=7990
#ID4=3
#IP4=127.0.0.1
#PORT4=7090
#ID5=4
#IP5=127.0.0.1
#PORT5=6699
[LOGINSERVER]
#³oO©T©wªº*n³s¨ì LOGINSERVER §Ú?³o¸ÌO 211.105.139.79
IP=Put your Internet IP(WAN IP) address here
PORT=3200
In the Accountserver, Mainserver and Zoneserver replace all ips with "127.0.0.1" which is local system ip.
Creating an account
I have attached a tool that will help create a query in a3acc.txt.
Open Query Analyser and then login with your sa password
On the top in the dropdown select Character database
Just copy paste that a3acc.txt there and press F5.
Your account is created!
You need to backup databases. You need to create a database and use the backup file to restore it! I have attached the required files. Just go to query analyser and execute them!