A3 219 Server Files [Episode 5]

[Sabertooth]

sorry for double post. But i suddenly face one more error. I created a Clan but after a server restart the clan got deleted and besides the character name comes [].. how to solve this error???

 

[chrissdegrece]

For the Clan I can't be sure, but it makes me think that clan info can't be stored. Have you created the right folders?

 

[ramankamboj]

For the Clan I can't be sure, but it makes me think that clan info can't be stored. Have you created the right folders?

Yea that's right. Clan info is not getting stored in the database, that's why on restart the clan get deleted and you have [] in place of clan name...

The datatype and length of the fields in the Clan table in ASD database was not correct. Will try to correct it, and if i am successful then will share with you all.

 

[chrissdegrece]

I don't think it has to do with the database, because I use the db backups you posted with the 219 files and it's working for me. So I suppose it has to do with the folders.

 

[XwithZing]

Guys is it possible to backup my server ?? If yes then how ?? What files do i need to copy ??

ramankamboj, dude the codes for shue eggs and 255 lvl shues dont seem to work properly. I get cheat activated message but instead of shue egg or super shue some white rectangle card gets added to my inventory. U got any idea to solve that ??
I need to add super shues to my characters. please help....

 

[chrissdegrece]

Guys is it possible to backup my server ?? If yes then how ?? What files do i need to copy ??

ramankamboj, dude the codes for shue eggs and 255 lvl shues dont seem to work properly. I get cheat activated message but instead of shue egg or super shue some white rectangle card gets added to my inventory. U got any idea to solve that ??
I need to add super shues to my characters. please help....

a) Server Backup
This is not a single step process. 1st you have to backup your database to separate backup files.
Then you just copy / compress all the folders that contain the server files,logs,accounts etc.
Remember, don't backup stuff while server is running. Shutdown everything and do the backup or there may be inconsistencies.

b) Shue eggs can't be spawned like:
@ITEM?<shuecode>

Shues can only be used from SQL or through any GM utility that supports inventory editing, or directly from M$ SQL Server Mgmt Studio. Check A3CharEdit utility, you can copy/paste shue codes directly.

 

[XwithZing]

a) Server Backup
This is not a single step process. 1st you have to backup your database to separate backup files.
Then you just copy / compress all the folders that contain the server files,logs,accounts etc.
Remember, don't backup stuff while server is running. Shutdown everything and do the backup or there may be inconsistencies.

b) Shue eggs can't be spawned like:
@ITEM?<shuecode>

Shues can only be used from SQL or through any GM utility that supports inventory editing, or directly from M$ SQL Server Mgmt Studio. Check A3CharEdit utility, you can copy/paste shue codes directly.

very helpful info mate.. ty

Server backup thing i will have to experiment.
Shue, i was able to add through ur "A3CharEdit utility" great utility that.

 

[ramankamboj]

very helpful info mate.. ty

Server backup thing i will have to experiment.
Shue, i was able to add through ur "A3CharEdit utility" great utility that.

Ya, the ingame codes are for the items which you use in your inventory, since the shue have a different inventory and shue eggs can't be placed in main inventory, hence if you try to spawn shue ingame using gm command then you get white item....


Btw here are few New stuffs from a3 returns, Big thanks to jack_roseiway for helping

 

[Sabertooth]

Super shues are needed to be added through SQL. Not throught the codes.

 

[chrissdegrece]

Btw here are few New stuffs from a3 returns, Big thanks to jack_roseiway for helping

Nicee, I wonder, will we ever get our hands on those? :?:

 

[Sabertooth]

How to add a kh to the Thol and all? How to make a country shout after that too ???

 

[chrissdegrece]

I would like to know that too

 

[praddy]

hi again ...
is npcsummon is working for anyone ???????????
in ma server its not working ..
npc summon and monster exchange scroll also ....
please help ..

 

[Sabertooth]

There are a few stuff i will need your guidance. Please help me on that:-

1. I will like to know about adding a clan in Thol and the Exclusive Garment. And also about the country shout.

2. I will like to know about the translation of some messages we get in game. Eg:- while shouting, upgrading an item(No Settion %(number))

3. I will also like to know about the codes for all the unique sets. The range you provided has almost all the sets. But some parts are not there. By the grace of God, there is atleast 1 full set per class to check the thing.

4. The thing is, I dont see other GOD bosses around in the maps of SkyGarden. I see duneru, and one other but I dont see the small HK looking GOD bosses. I will like to know how to make them visible too.

5. While killing duneru, I get woonz when i hit with a AoE (Area of Effect) skills, that means creeps are there but not visible. How to solve that too?

Thanks for providing the server files. Hope you can help me on these.

Cheerz

 

[ramankamboj]

There are a few stuff i will need your guidance. Please help me on that:-

1. I will like to know about adding a clan in Thol and the Exclusive Garment. And also about the country shout.

2. I will like to know about the translation of some messages we get in game. Eg:- while shouting, upgrading an item(No Settion %(number))

3. I will also like to know about the codes for all the unique sets. The range you provided has almost all the sets. But some parts are not there. By the grace of God, there is atleast 1 full set per class to check the thing.

4. The thing is, I dont see other GOD bosses around in the maps of SkyGarden. I see duneru, and one other but I dont see the small HK looking GOD bosses. I will like to know how to make them visible too.

5. While killing duneru, I get woonz when i hit with a AoE (Area of Effect) skills, that means creeps are there but not visible. How to solve that too?

Thanks for providing the server files. Hope you can help me on these.

Cheerz

1. Haven't checked that from long time, and till the time i tried, had no success.
2. I would also like to know this.
3. Those are all unique sets. I dn't know why actoz made it this way but every class have 3 unique sets out of which 1 have all 5 parts, second set have 4 parts and third set have 3 parts. I came to know about this after checking screen shots on few websites, no website have scrrnshots of more than 1 full set of any class.

@Praddy
NPCSUMMON is working. The maps have some problem, copy the map files from some episode 3 server. Copy the map files of all those maps where NPCSUMMON can be used.

 

[deepa]

@ramankamboj
the day when u firts posted this guide i was the first to setup the server and i was fully working i also enjoyed playing it

now my pc had been formatted and i had not been playing A3 since 5 months i again installed every thing but i got one problem that is in zoneserver

the problem is in zoneserver i had the same problem when u first posted this guide i solved bymyself but its been long time i forgot about it need some help

GameInit Fail

[ERR200]****Authentication Fail****(this was the error i got from zoneserver)

guide me
thx bhai in Advance

 

[Iam]

@ramankamboj
the day when u firts posted this guide i was the first to setup the server and i was fully working i also enjoyed playing it

now my pc had been formatted and i had not been playing A3 since 5 months i again installed every thing but i got one problem that is in zoneserver

the problem is in zoneserver i had the same problem when u first posted this guide i solved bymyself but its been long time i forgot about it need some help

GameInit Fail

[ERR200]****Authentication Fail****(this was the error i got from zoneserver)

guide me
thx bhai in Advance

****Authentication Fail**** = ATZ key not Cracked

ATZ key cracked Zone server was Released in Rage zone

Please Check Forums

 

[cyberinferno]

Okey at last the wait is over. Now all can have their own episode 5 server of A3.
The Guide is more or less same as that of episode 3 server with almost no change provided you use the files given by me in my post.


OK lets start with the first step to host an a3 server ..
but first of all .. this guide is for one who is setting up the server for the first time so u have to compromise with some facts to get 100% success.. (eg the pass used) u can change it later.
u need some files ...
1. a3 client...(A3Mania client, TTA3 client or the client hosted
2. a3server files
3. sql 2000
4. sql 2000 servicepack3
5. a hex editor

Episode 5 A3 Client( TTa3 Client)

You must be registered to see links

A3 219 Server Files Modded by me

You must be registered to see links

Important Files + A3 Client hexed to 127.0.0.1

You must be registered to see links

GT.ULL to be used with Client for Coverting ingame messages to English

You must be registered to see links

Tools for editing server nd client files

You must be registered to see links

Microsoft is no more hosting the SQL server 2000 so you can use sql server 2005.

first of all install sql 2000 & its service pack...
i m trying to explain the process in brief..
double click the sql 2000 setup file(SQLEVAL.exe)
extract it to c:\ or whatever location u want...
then go to the location & double click the setup.exe
press next> next> next>
then put the name as "sa" (without ")..
next> yes> next> next> next>
select the "use the local system account"..
next>
select the mixed mode & put password as ley (u can choose any other password too but u have to change some file`s content if u choose other password..so i recommend u to choose this password for the first time & after u become an expert use ur own password)
next> next>Finish.
now double click the sql 2000 service pack3 & just click next next (don't change any selection)..
now restart ur computer once..

second step is to place the server files to the correct place

extract the a3server files to d:\

be sure that the location must be as d:\a3server\..... not d:\a3server\a3server\...

now extract the files provided in the folder named C to put in C drive (obviously extract it to c:\)
then go to C:\clan & double click on the mkdir.exe

now go to start>program files>Microsoft SQL server>Service Manager
& click start server..
be sure to remember the server name there coz u ll need the name later..
now go to start>all programs>Microsoft SQL Server>Enterprise Manager
now go to microsoft SQL Servers>SQL server group>(local)(Windows NT)>Databases
now u have to create some new databases here by going to action>new database..

1.ASD
2.Character
3.itemstorage
4.Clan
5.A3ItemEvent
6.FriendDB
7.HSDB
after making these all databases u have to restore some databases by this process
Go to Tools>Restore Database
select A3ItemEvent
choose "from devices" option
click on select devices
click add
click "..."
provide the location d:\A3server\db\A3ItemEvent
now press OK OK OK OK
now u have to do the same process with all these databases
1.A3ItemEvent (done)
2.ASD
3.clan
4.FriendDB
5.HSDB

now go to security tab (found in left hand side)
press Action>New Login
this is the process where many do a mistake ..... do this process carefully]
put
name = a3serial
Password = dkdlxpawprhdnpc
Database = A3ItemEvent
select the database access tab & tick the a3ItemEvent, then tick the db_owner
& press OK
it will ask for the password again put dkdlxpawprhdnpc & press OK
(some times it gives an error "Login serial already exists" .. if u too get this error message then go to Databases>A3itemEvent>users & delete the a3serial there... then again do the process mentioned above)
the next step is ODBC
go to start>control panel>administrative tools>Data Sources (ODBC)>System DSN
now press add
select sql server.. press Finish.
now put
name = A3ItemEvent
server = {your server name} (the name i told to remember previously.. if u forgot then go to start>program files>Microsoft SQL server>Service Manager
& click start server ... u ll see the server name there)
now press next
now it will show 2 options there .. select the second option & put
Login ID : sa
Password : ley
now press next
select change database to .. & select A3ItemEvent there
now press next... finish .. OK
u have to do this same process with some more databases too

here is the list

A3Friend = FriendDB
A3RcvResult = A3ItemEvent
A3SerialList = A3ItemEvent
ASD = ASD
EventA3 = ASD
FriendDB = FriendDB
HSDB = HSDB
LETTERDB = ASD
LocalServer = ASD
Login202 = ASD
NEWASD = ASD

the next process is to make a .reg file..
a .reg file is already given in the serverfiles in the folder named important files & shortcuts
if its there then just double click on it & press yes yes
or if u r using any otherserver files then u have to make a .reg file by the following process
first of all copy the text which i m giving below


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"








now go to start>run
type notepad
press enter
now paste the text in it & save it on the desktop by putting its name as ODBC.reg
now go to your desktop & just double click on the ODBC.reg file... press yes OK ..
& u r almost done



the server is now ready to run....
but its only for ur own PC... if u want it to run on LAN then u have to change some .ini files...
Put ur LAN or wan ip in place of 127.0.0.1 in these places

1.d:\A3server\Loginagent\LoginAgent.ini


;//////////////////////////////////////////////////////////////////////////////////////////
;//GameServer ȯ°æ º¯¼ö ¼³Á¤ ÆÄÀÏ
;//////////////////////////////////////////////////////////////////////////////////////////

[VersionInfo]

HighVersion = 300 ;//CurrVersion <= HighVersion
LowVersion = 136 ;//CurrVersion > LowVersion


[LoginAgent] ;//tcp

IPADDR = 127.0.0.1
PORT = 3550


2.d:\a3server\Loginserver\Loginserver.ini

[STARTUP]
APPNAME=LOGINSERVER
ZONEAGENTLISTENPORT=3200
LOGINAGENTLISTENPORT=3210
STARTID=3

[LOGINASD]
COUNT=1
IP0=127.0.0.1
PORT0=7770

3.d:\a3server\Zoneagent\ZoneAgent.ini

[STARTUP]
APPNAME=ZONEAGENT
SERVERID=0
AGENTID=0
#ZONE AGENT ³o¸Ì«ü¥»¾÷ªº IP
IP=127.0.0.1
PORT=3300




be sure .. don't change any other ip instead of above mentioned 3 ips...

1 more thing u have to edit some .ini files to make ur char a GM char...
first go to D:\a3server\Battleserver\Gminfo.ini & delete hawkiii & put ur Id(i ll tell later that how to make id.. so just put the id u wanna create for ur char)

do the same in D:\a3server\Mainserver\Gminfo.ini & D:\a3server\Zoneserver\Gminfo.ini & D:\a3server\accountserver\Gminfo.ini


your server is ready to run...

but first u have to make ur id
there is a tool named a3acc.dat in the important files & shortcuts folder.. just put the id , press enter then put pass , again enter, enter , enter
this will make a new notepad in the same folder named a3acc.txt
open the a3acc.txt & copy the text.... for those who don't have the a3acc.dat tool i m giving u a text
put id in place of xxx & password in place of yyy

INSERT INTO account (c_id, c_sheadera, c_sheaderb, c_sheaderc, c_headera, c_headerb, c_headerc, d_cdate, c_status, m_body) VALUES ('xxx','yyy','yyy','yyy','yyy','yyy','yyy','1/1/2003 12:00:00','A','yyy')


copy this full text & go to start>all programs>Microsoft SQL Server>Query Analyzer
put ur server name
Login ID : sa
Password : ley
change the master to ASD on the toolbar on the top of the window
now paste the copied text in the notepad provided there
then press ctrl+f5 then press f5
your account is created
create some accounts for ur friends too


OK .................
now time to start the server

Bute before running server, install Borland Database Engine provided in folder "bde".

Now run the exe in following order
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

Note: Zoneserver always takes time to run. So after clicking zoneserver.exe, leave your pc as it is and wait for zoeserver to run. It may take 2-5 minutes to run.



last process is to hex ur Episode 5 A3client ip to your ip or 127.0.0.1 if u wanna play it alone in ur PC (remember, use the ip u used earlier i.e.if u used ur wan ip then put ur wan ip & if u used 127.0.0.1 then use this one only)
hope u know how to hex A3client`s ip....
I have providing a3client.exe hexed to 127.0.0.1 . in 'Important files and Shortcuts' you can use that a3client.


thanx to Akaruz(the Godfather of A3 Private Servers), Legendary, protisback, charlie_ravi and all.....
This guide is developed from the work of above mentioned people. I have slightly modified it for epi 5 server.

I've done exactly whats there in this guide but after i login my server with account it comes loading but it doesnt load.. wat may be the problem??

 

[chrissdegrece]

Zoneagent or Zoneserver

 

[cyberinferno]

At last successful in creating my server... Btw the problem was in ODBC.. Ty RZ for helping me till now.. Now searchin threads regarding manipulation of my server's Teleportation,NPC,Exp,Monster drops etc.. It would be help if someone collected links for all this and post it here...:/: