Pages

ACE Online 3.3

Step 1: Getting the files you need.
http://www.mediafire.com/?ot2i3b2mz03goqq
^This is a working link^

Password is x-rivals
On a side note:
-As I promised, the new files with the new monsters, items, maps, but for making the pets to work you need to fix some things in databases. Here is it:
New ep 3.5 with some features of episode 4

Also, if you need some files for client, go on www.war0nline.net at the Download section.
-If you need a client, download it from here:
http://dr-files.net/clients/current/...3.6.5).sfx.exe
http://installer.subagames.com/ace/ACEonline(3511).exe
Deposit Files
http://airrivals.net/main/download/client


-Download SQL 2k5 or 2k8, it's up to you. Out of personal preference, i use 2k5.
Go to Database Management | Data Mining & Warehousing | Microsoft SQL Server to get the trial version of SQL 2k8. Try to avoid getting Express if possible (It has a limitation on DB restores.

-Download Hamachi. It will give you a Virtual IP which will be used to connect to the server. You can download it from https://secure.logmein.com/products/hamachi2/ . Install it and run through the set up. Once running, click the power button. You'll have to create a Hamachi ID, it doesn't really matter what it is. Then, It'll ask you whether you want to Create a network or Join an existing one. Choose to create a new one, name it, give it a password. You're done with Hamachi for now.
[[[[This is in case that you want to use Hamachi instead of External IP]]]]

Step 2: Setting up the server.
-If you didn't extract the first file to the root of your HD already, do it now.

-Once extracted, go into the server folder. You should see 9 other folders inside (bin, config, DB_BAKS, htdocs, Lib, log, map, SCMonitor, SCVoIP)

-Go into the config folder and change the file named global.cfg with the one ATTACHED here, so odbc will work. After changing it, open it using Notepad.

-The top two IPs, change it to say your Hamachi IP (It'll start with a 5). This isn't completely necessary, you can just set it up as a 127.0.0.1 (Which for those of you who don't know, that means local host) However, this guide is made for people who want others to connect to your server (Say, a friend comes over and wants to play too, or some Ventrilo friends, take your pick). So for the sake of the guide, do the Hamachi IP.
If done right, it should look as follows:

[...]
$LOCAL_IP_ADDR  = 5.175.254.21 -(for hamachi) or u can put here ur local ip (ex: 192.168.25.10)
$LOCAL_PUBLIC_IP_ADDR  = 73.128.265.001 -(here you put your external IP in case u want to run it globally. Or just $LOCAL_IP_ADDR for hamachi.
$ARENA_IP_ADDR  = $LOCAL_PUBLIC_IP_ADDR  -Arena to work, globally, I puted here the external IP.
$WEBSRV_IP_ADDR  = $LOCAL_IP_ADDR
$FTPSRV_IP_ADDR  = $LOCAL_IP_ADDR
$IS_ARENA_SERVER  = FALSE
$SERVER_GROUP_NAME  = YourServerGroupName
$LANGUAGE_TYPE  = 1
[...]

-Now you're going to do a bit of copying.
What you're going to want to do is open up the server folder, go to the map folder. Now you're going to open up "server" that you dearchivated it, and go to "Server/map".
Open also your client go to /Res-Map/ and copy the .dat files in to the /server/map/

Go back in /server/ and open the /server/Res-Obj/
Go back in the /client/ and go to /client/Res-Obj/. Copy the objs to the folder /server/Res-Obj/

Go back in /server/map in /server/map/Res-Exe.
Go to your client and copy the Aceonline.atm in the /server/map/Res-Exe.

Go back in /server/map in /server/map/Res-Tex.
Go in to ur client in /client/Res-Tex. Copy the interface.tex, omi.tex and quest.tex in to the /server/map/Res-Tex.

Now you should be set with the files that you needed to copy over to both the client and the server. Now on to SQL Side of things!

Step 3: Setting up the server (SQL Side of things).
-Moving right on to SQL side of things, the installation is fairly simple, so i'm not going to walk you through it. You're a big kid, running your own server and stuff, i think you can figure it out. (When it asks what you want to install, select all. USe NT/System Authority, and Add current user for anything after that. Install it and you should be on your way. Figured i'd just give an overview

-Open the SQL Server Configuration Manager, click on SQL Server Network Configuration, and click on Protocols for MSSQLSERVER. Right click TCP/IP Settings. It should look like the following:

The images are attached as Step3 Step3.1 and so on.

If it doesn't make it look like that.
Now go over to the IP Addresses tab, and since you have Hamachi installed, the IP should already be there.
Or if you don't use the hamachi ip You just put ur local one.

Make it Active if it isn't, Enable it, and change the Port to 9979 or leave it as 1433. When you click okay, it will say that the service will have to be restarted for the changes to be applied.

Go to Start, type in services.msc, and scroll down until you find MSSQLSERVER, Restart it and you should be good.

-Now open up the Microsoft SQL Server Management Studio. Right click on Databases, and chose the restore option. if done successfully, you'll get to this screen:

Step3.3 photo.

All you have to do now is restore the databases. Do as follows:

Step3.4

Once you restore atum2_db_1, do the same for atum2_db_account:

Step3.5

Now you're set for that side of things. To make an account, go to Databases, atum2_db_account, Tables, and right click on dbo.td_Account, select "Edit top 200 rows"
You'll see 20 accounts as normal. You can leave them there or just take them out.
To create an account:
AccountName
Password
AccountType (0= Normal user, 128= GM, 256= Helper)

Now you're almost done, all you have to do now is add the odbc's and compile a batch file.

Step 4: Setting up the ODBC's

-What you have to do now is go to "Start", and Type odbc.
add User Data Sources as:
db_1
db_account
db_arena

Click finish and test it. If it passes successfully, do the same for the next 2 . Once all are done and successfully tested, congratulations. Only one more step to go.

Step 5: Getting the Batch file
If you don't know how to make a batch file, just use the following program and method:
Quote:

Quick BFC: http://www.abyssmedia.com/downloads/quickbfc.exe

Install and start the Program.
Now Type in:

echo off
start Launcher.atm (YOUR IP)

Click on Embedded Files and Browse for your client.ico (in your game folder).

Now click -> Project -> Compile.

Save it in your Game Folder as .exe

Now you can try to start your own compiled Start.exe


Mine for example was:
echo off
start Launcher.atm 5.207.74.185

You're going to use that Start.Exe to get the client to connect to your server. Now you're pretty much done. All you have to do is bring the server online. To do that, all you gotta do is go to the bin folder in your server, and open up, in this order, Preserver, IM Server, LogServer, Field Server, and then NPC Server. First three take next to nothing to boot, Field takes a little long and so does NPC. If you open task manager, and it says not responding, don't freak out. That means the server is actually booting up. Once Field server comes online you can launch into the game.

-----------------------------------------------
The thing is, its a GUIDE nearly the same as this one but for episode 2.
I tryed to make for 3.3 if some1 have a better idea or waisting his time other way, please come with better guides.

Thank you.

[Credits for most of the work to FallenProphett]
WARonline
Ragezone