A3 219 Server Files [Episode 5]

Page 1 of 20 12345678911 ... LastLast
Results 1 to 15 of 287
  1. #1
    Ultimate Member ramankamboj is offline
    MemberRank
    Oct 2007 Join Date
    195Posts

    A3 219 Server Files [Episode 5]


    RaGEZONE Recommends

    RaGEZONE Recommends

    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...(TTA3 client preferably)
    2. a3server files
    3. sql 2000
    4. sql 2000 servicepack3
    5. a hex editor

    Episode 5 A3 Client( TTa3 Client)
    http://tt-games.com/html/a3download.html

    Or you can download client from following link

    Gamefront


    A3 219 Server Files Modded by me
    Gamefront

    ***UPDATE***(10 March 2011)
    Beta Server
    A3 Legacy

    Download Server files:-
    JumboFiles.com - Dedicated Hosting

    Download Client Files:-
    DuckLoad.com � Easy streaming



    Important Files + A3 Client hexed to 127.0.0.1
    Gamefront

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


    Tools for editing server nd client files
    Gamefront
    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.
    Last edited by ramankamboj; 10-03-11 at 10:55 AM.


  2. #2
    Ultimate Member ramankamboj is offline
    MemberRank
    Oct 2007 Join Date
    195Posts

    Re: 219 Server Files(episode 5)

    Codes For Unique Sets Is from 3757 till 3810 smthing. But these do not have all unique sets i.e all g8 nd g9 unique sets of all classes.

    So if anyone have all codes or find the codes after setting his/her server then do share please.

    Also please share if you find and glitches or you are able to correct anything or nything constructive.

    UPDATE(11 July 2009)
    Codes for Unique Skill Scrolls
    10801 +
    10880 +.
    Unique skill Scroll codes are not in continuation. There are few scrolls near 10801 nd other are near 10880. So try all codes from 10801 to 10999 and most probably you will get all unique skill scrolls.

    UPDATE(29 July 2009)
    Item Slotting (Done through Episode 5 npc)

    Codes For Gems
    9834 to 9851

    Yellow Gems can be used with Armor ---Gem Codes: 9834 to 9839
    Red Gems can be Used with Unque Necklace --- Gem Codes: 9840 to 9845
    Blue Gems can be used with Unique Rings --- Gem Codes: 9846 to 9851

    Codes For Unique Necklace : 4156 to 4159
    Codes For Unique Rings : 5184 to 5187

    Codes For Items To be Used in Armory Slot : 9831, 9833, 9853, 9854

    Codes For items to be used in Improve Set Slot:
    9832 9852, 9855, any appropriate gem.

    Now Coming to The Slotting Part
    Armory slot is for putting unique option to normal Armor part so that you can add other unique option to armor by using improve set slot(not the gloves,helmet, pants,shield or boots)

    Now put the armor, unique ring or unique necklace in Improve set slot + 3 Items needed and the appropriate gem. It will give you a unique option.

    NOTE:- There are total of 6 gems of each colour but you can use maximum 3 gems on 1 item only. All 6 gems can't be used used on single item.

    ***UPDATE (10 March 2011)***

    For Information regarding thols and some other usefull information visit following thread
    http://forum.ragezone.com/f487/a3-se...pisode-730848/
    Last edited by ramankamboj; 10-03-11 at 10:58 AM.

  3. #3
    Ultimate Member ramankamboj is offline
    MemberRank
    Oct 2007 Join Date
    195Posts

    Re: 219 Server Files(episode 5)

    Have nyone been able to solve this "Failed To Allocate Power" problem.
    For more info check the attached image.

    If anyone here have solved it then please share or if someone have ny idea about how to solve it then also please share.
    Attached Thumbnails Attached Thumbnails 2009year 7month 12date 15hour 32minute 56second.JPG  
    Last edited by ramankamboj; 12-07-09 at 12:31 PM.

  4. #4
    Ultimate Member ramankamboj is offline
    MemberRank
    Oct 2007 Join Date
    195Posts

    Re: 219 Server Files(episode 5)

    ****** Why these forums don't have delete post option?*********************

  5. #5
    @work onyourrisk is offline
    True MemberRank
    Jan 2008 Join Date
    IndiaLocation
    708Posts

    Re: 219 Server Files(episode 5)

    Impressive post ! but still manything missing wishing you luck for that !
    [SIGPIC][/SIGPIC]

  6. #6
    Ultimate Member ramankamboj is offline
    MemberRank
    Oct 2007 Join Date
    195Posts

    Re: 219 Server Files(episode 5)

    Then be kind to point out the missing things.
    As far as setting up of server is concerned, the files i provided r enuf to get success with any epi 3 server setting guide.
    What all things according to you are missing? Spare some time nd make a list of missing things.

  7. #7
    Account Inactive Newbeee is offline
    InactiveRank
    May 2009 Join Date
    18Posts

    Re: 219 Server Files(episode 5)

    Is it only me who noticed that all the writing part is taken from Prot's Guide...

    Nyways..Thanks for ur Guide...Its good to have 1 guide rather than nthing..!! Thanks Mate..


    But me Still w8ing for Prot nd Charlie_ravi's Guide,..Coz its Noobest...Not much struggle in that..[:P]

  8. #8
    My LanHouse in Brazil!!!! Yag4mi2k is offline
    True MemberRank
    Feb 2007 Join Date
    CoNquEsT FrOm Br4ZiLianLocation
    721Posts

    Re: 219 Server Files(episode 5)

    thx, NICE WORK DUDE.........................

  9. #9
    Member gantolaakshay is offline
    MemberRank
    Jan 2009 Join Date
    Hyderabad/PilaniLocation
    54Posts

    Re: 219 Server Files(episode 5)

    ty dude cant w8 to try out will reply soon
    tnx again :)
    I just wanted to know, will this run on a 2 gb 2.5ghz C2D 256 Nvidia laptop?

  10. #10
    Account Inactive orkut_dude2007 is offline
    InactiveRank
    Jul 2009 Join Date
    3Posts

    Re: 219 Server Files(episode 5)

    @ above
    som1 told me 1gb ram minmum requirement to run a server...if thats true then party time for u
    and som1 do upload sql 2000

  11. #11
    @work onyourrisk is offline
    True MemberRank
    Jan 2008 Join Date
    IndiaLocation
    708Posts

    Re: 219 Server Files(episode 5)

    Lolypop - - - - - - - party time : :
    [SIGPIC][/SIGPIC]

  12. #12
    Ultimate Member ramankamboj is offline
    MemberRank
    Oct 2007 Join Date
    195Posts

    Re: 219 Server Files(episode 5)

    @gantolaakshay
    your pc config is more than enuf.
    I myself have tried it on pc with intel dual core processor, 1 gb ram and 128 mb nvidia geforce graphic card. Pc with this config can run server and client also, that also with no lag. Although comp. get bit slow after running zoneserver and then starting the client take 5-6 minutes but after 10 mins everything run smoothly even the client starts within 10-15 sec on second run.

  13. #13
    @work onyourrisk is offline
    True MemberRank
    Jan 2008 Join Date
    IndiaLocation
    708Posts

    Re: 219 Server Files(episode 5)

    Ya , but for hosting server on LAN or WAN your RAM must be over 2 GB if you want to run all maps . . .

    If you have 512MB ram than also no problem you can make some maps Mapxx=2 and run server in MapInfo.ini file . . .
    [SIGPIC][/SIGPIC]

  14. #14
    Account Inactive deepa is offline
    InactiveRank
    Mar 2009 Join Date
    BangaloreLocation
    19Posts

    Re: 219 Server Files(episode 5)

    ty DUDE thx a lot for posting i was w8 when u will cm thx u r ock bro

  15. #15
    Member gantolaakshay is offline
    MemberRank
    Jan 2009 Join Date
    Hyderabad/PilaniLocation
    54Posts

    Re: 219 Server Files(episode 5)

    while running the zoneserver 24.7 mb one as per ur guide i get a connect db error i am sure this is because of the a3serial id creation but i have already done that
    Note: i had the same problem with epi 3 server but some1 shared a zoneserver without the a3serial authentication, and that wrked well. Can u make the zonserver without the authentication?????
    plzzzzzz tyyyyyyyyyyyyyyyy BTW i Am using sql 2005 express edition ( same that I used for in epi 3)
    GOT IT DONE TY
    Last edited by gantolaakshay; 11-07-09 at 02:10 PM.




Page 1 of 20 12345678911 ... LastLast

Advertisement