[Release ]A3 Server 219 files - Episode 5 - ZoneServer Taiwan IV

[suruchi_sogano1]

Releasing Fixed, 219 server files.
1. Battle Server working.
2. Quests Translated.
3. Login server messages translated (english).
4. 70% server messages translated (english).
5. Teleporter problem fixed.
6. Potions added to Healers.
7. NPCSUMMON working on most maps of Episode-1. Tried on Carode, Wolfreck, Vermedon, Nifilgar. Also works on bughaye, of colorance.
8. Included a KH for how to make thol and enter into Castle.
9. Show Kh in shop info.
10. Lots of blah blah blah.
11. These are originally raman's file. And all Credits on bug solving goes to Chriss, Me and Raman.

Guide???? here is raman's one
================================================
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 @bhishek1 (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 Drive" 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 : @bhishek1
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 : @bhishek1
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....

thanx to Akaruz(the Godfather of A3 Private Servers), Legendary, protisback, charlie_ravi and all.....
====================
Beta Server:-

You must be registered to see links

===================================================
Download Server files:-

You must be registered to see links

Download Client Files:-

You must be registered to see links

 

[suruchi_sogano1]

Re: A3 Server 219 files - Episode 5 - ZoneServer Taiwan IV

Client Download:-

You must be registered to see links

=====================================================
Links Added by Chriss:-

You must be registered to see links

You must be registered to see links

You must be registered to see links

Btw i forgot to say, Chriss's GM Tool is already inside Server, Configure it to your own db, else keep Password to what i gave, and it shall work.
=====================================================

Q> How to make thol?
Ans> Find Kh file of "StripperS" in C:\Clan folder.
Convert StripperS to ASCII value to find its file,like, for StripperS it will be
S=83,t=116 and so on
So, filename for StripperS kh = 83.116.114.105.112.112.101.114.83.guil

Open that file in hex editor like XVI 32. Look for value 05 there, just after 01.
01 is for Quanto, and 05 = Thol.
01 = Ertakin Healer,
02 = Ertakin xxxxx,
03 = Ertakin xxxxx,
04 = Ertakin xxxxx,
05 = Thol,
06 = Thol too, no idea whats the difference,some times it crashes login.
Q> Ok thol made, how to get into the castle?
Ans> Get your KH's clan ID, either in chat mode use GM command "@CLANID?KH_NAME", or run A3ClanView.exe
from 5A3_Util, and search you KH name there. Remember, don't save your kh using that tool, just read from it.
Ok you got Clan ID.
Now, open AgitOwnershiptbl.txt from C:\A3Log into some text editor, and insert kh id there.
StripperS ID is already there for your guidance.
First Colmun = Town (0=Temoz,1=Quanto),
Second Column= Sequence Number(1 to 28 for each town).
Third Column = Clan ID
Fourth Column= Storage Name to be shown in Castle NPC
rest, no idea

Q> Ok am able to enter into castle, how to show my kh name on shop info?
Ans> Open tax.dat from C:\A3Log into some hex editor, and find the equivalent strings after seeing in shop info and replace them.

Q> How to get tax collection working in A3?
Ans> You need to hex tax.dat for that, i forgot where too, catch raman for that please
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

I would like to help if anyone wana host a real server, not just for one, get me one GM account
=======================================
I also got Mybb Forum integrator plugin to work with A3 SQL Server.
It works like,
Create account in Forum = account created in a3 game.
Change password in forum = password changed in game.
Ban a user in forum = banned user in game.

Char editing option to Forum's Supermod, and some more features.
===========================================
Remember RZ community is dead because no one wana share what they learn, and those who are ready to share, have shared everything they know.
It is upto you, you wana keep this game alive or not.

---------- Post added at 11:34 PM ---------- Previous post was at 11:08 PM ----------

Use this A3Client.exe for your Clients. Hex to your ip, currently it is hexed to 127.0.0.1 (your own computer).

You must be registered to see links

 

[Pon]

Re: A3 Server 219 files - Episode 5 - ZoneServer Taiwan IV

Thank you very much, your kindly share total both server and client. This file will keep this game alive. Cheers......

 

[aslanistempid]

Re: A3 Server 219 files - Episode 5 - ZoneServer Taiwan IV

n1 suruchi 1 guy is there who is free to hlp get me ur no. pplz
i will tell u somthng personal m gonna host real 1 after may m in progress gimme ur email id.

 

[holy003]

Re: A3 Server 219 files - Episode 5 - ZoneServer Taiwan IV

suruchi_sogano1 Nice Work .If U Translate The remaking 30 % Then It will me More UseFull.
And Dont Waste Your Time With that noob aslanistempid !! He is Really Imba Noob !!

 

[suruchi_sogano1]

Re: A3 Server 219 files - Episode 5 - ZoneServer Taiwan IV

I have Attached my php editor, in the First post.
Use that to edit rest of server messages

 

[holy003]

Re: A3 Server 219 files - Episode 5 - ZoneServer Taiwan IV

how to use php editor ???

 

[aslanistempid]

Re: A3 Server 219 files - Episode 5 - ZoneServer Taiwan IV

abe noob holy003 FO re dnt mess with me ur gm char has g1 kit

n first learn to start ur arena then say me noob running server website on
webs n puting page whch is eshop rofl............

 

[suruchi_sogano1]

Re: A3 Server 219 files - Episode 5 - ZoneServer Taiwan IV

Change all messages to numbers like 01@, 02@
See messages in game,
And change accordingly again using this php file.

How to use?
1. put your A3_msgzone.dat file in the same folder as of these files.
2. Point your browser to your folder/Edit.php (Eg,

You must be registered to see links

)
3. Edit and save file.
4. Your folder will have file as A3_msgzone.dat.out(something like that, i made this long time ago).
5. Rename it to A3_msgzone.dat and put back in your zoneserver.
6. Run game.

I won't answer any queries, please download and try to learn wamp, if you have no idea to run php.

---------- Post added at 12:27 PM ---------- Previous post was at 12:25 PM ----------

I'll delete the files immediately, if i see this thread getting flamed.

Don't tell me later, you have been warned.

 

[zarut]

Re: A3 Server 219 files - Episode 5 - ZoneServer Taiwan IV

Moved to releases where it belongs.

 

[getdeepz]

Re: A3 Server 219 files - Episode 5 - ZoneServer Taiwan IV

Moved to releases where it belongs.

What more bugs do you got to solve?

 

[chrissdegrece]

Re: A3 Server 219 files - Episode 5 - ZoneServer Taiwan IV

There is plenty of stuff getdeepz (btw nice post u made in devshed, good work )

This thing is not "Production ready", lots of things still need fixing.

Anyways, as a safety measure I re-uploaded it to :

You must be registered to see links

Hope that ppl stop wasting time in same & same stuff, improve it and who knows, maybe someone, some day, might share.

I also cleared all (i hope) old txt logfiles which were there since 2004+ and saved lots of space, used Ultra compression with 7-zip and uploaded to:

a)

You must be registered to see links

b)

You must be registered to see links

Abhi, Raman, Sachin , thanks guys we had a good time with this.

 

[krobleus]

Re: A3 Server 219 files - Episode 5 - ZoneServer Taiwan IV

These files are good and i have one prob with back up one i cant back ur files to my sql server check it once and reply asap

 

[suruchi_sogano1]

Re: A3 Server 219 files - Episode 5 - ZoneServer Taiwan IV

Hmm.. ok thanks for the info krobleus.
Will check and reply asap. KORBLEUS, which SQL SERVER VERSION are you using, i used SQL SERVER 2005 for running A3 Server, i suggest use it, because backups have been made in that only.

@deep, buddy, well i already asked you to add me on any chat client you use.
Hit me up there

Yup, chriss, had been crazy days lol. Only A3 in head. Lets now concentrate more on our next project

Oh and for the records, why i quited, because in some post i saw Korean ZS part-V. I still feel, that was fake but who knows. Thinking of going creative now, instead of reverse engineering

 

[krobleus]

Re: A3 Server 219 files - Episode 5 - ZoneServer Taiwan IV

Hmm.. ok thanks for the info krobleus.
Will check and reply asap. KORBLEUS, which SQL SERVER VERSION are you using, i used SQL SERVER 2005 for running A3 Server, i suggest use it, because backups have been made in that only.

ok me using sql 2000 i think this might be probleum

and one more thing u guys can check Tower event and that Dress implementation also na and Tower is not included in Epi V zs only

 

[suruchi_sogano1]

Re: A3 Server 219 files - Episode 5 - ZoneServer Taiwan IV

Dresses only work with pure korean Client, one that uses A3Client.exe (Korean version).
Because Dresses details and all lies in ID.ull, and upto epi-4 A3Client.exe, none use ID.ull. So you won't be able to use dresses, untill you find a way to run korean client with your server, I have included the ZS 1.20, and LA 1.20 which works with Korean Client but doesn't co-ordinates with Mainserver and accountserver of this server for some reason.

For tower event, i think you can make a teleporter to get into another ZoneServer (epi-3), first fix that ZS for tower.
Than run tower event in that zs. Refer to Chriss info on that, to have event on different zs.

You will need to work hard, if you wana know A3 deep.

 

[krobleus]

Re: A3 Server 219 files - Episode 5 - ZoneServer Taiwan IV

OK ty da for giving information

 

[cvrdheeraj]

Re: A3 Server 219 files - Episode 5 - ZoneServer Taiwan IV

Good Work!

 

[Deadlykill3r]

Re: A3 Server 219 files - Episode 5 - ZoneServer Taiwan IV

Q> How to make thol?
Ans> Find Kh file of "StripperS" in C:\Clan folder.
Convert StripperS to ASCII value to find its file,like, for StripperS it will be
S=83,t=116 and so on
So, filename for StripperS kh = 83.116.114.105.112.112.101.114.83.guil

Open that file in hex editor like XVI 32. Look for value 05 there, just after 01.
01 is for Quanto, and 05 = Thol.
01 = Ertakin Healer,
02 = Ertakin xxxxx,
03 = Ertakin xxxxx,
04 = Ertakin xxxxx,
05 = Thol,
06 = Thol too, no idea whats the difference,some times it crashes login.

First Of all Heartful thanks for sharing On How to Make a thol.
but i am getting with a Prob ... m not able to figure Out which 01 u are asking to Look for . and I dont find and 05 preceeding 01

m sure i amybe going silly somwhere ..but Plzz try sorting it out. or better lemme Know Ur contact Info .

Hoping for a quick response.

 

[chrissdegrece]

Re: A3 Server 219 files - Episode 5 - ZoneServer Taiwan IV

http://forum.ragezone.com/f98/thol-netrean-729347/#post6185296