[Windows] Set up ArcEmu from scratch, in detail with pictures. (Updated 30/1/11)

[Facerolling]

Hello There, it's been a while since another ArcEmu tutorial has been updated.

Before we begin, THIS IS FOR A 3.3.5a SERVER. YOU WILL NEED A 3.3.5a CLIENT TO EXTRACT THE VMAPS, MAPS AND DBC, AND TO PLAY.

I have put spoilers on all the pictures as they are very large.

Contents:
Chapter 1: Preparation
Chapter 2: Pulling the ArcEmu Source and Compiling
Chapter 3: Filling your Complete Folder
Chapter 4: Creating and Filling the MySQL Server
Chapter 5: dbc, maps and vmaps
Chapter 6: Changing Config Files
Chapter 7: Adding an Account and Playing

Chapter 1: Preparation

You will need:

TortoiseSVN: TortoiseSVN - Downloads
[SPOILER][/SPOILER]
Most people will be using a 32 bit OS, so click the large blue "TortoiseSVN 32-bit" button and install it.


Visual C++ 2010 Express: Microsoft Express Downloads - Visual Studio Express and SQL Server Express
[SPOILER][/SPOILER]
Click the Visual C++ 2010 Express option and select your language, when installing, do not take the MySQL integration.

Chapter 2: Pulling the ArcEmu Source

Create a folder anywhere you like, for the sake of simplicity, I have created one on the desktop. Right click this folder and pick "SVN Checkout..."
[SPOILER][/SPOILER]

In the new checkout screen, put the url of the checkout as:

https://arcemu.svn.sourceforge.net/svnroot/arcemu/trunk/

[SPOILER][/SPOILER]
After it has completed, it should look like this:
[SPOILER][/SPOILER]

After this has completed, go into your folder, and into the new "win" folder. Double click on "arcemuVC100 - All Projects"
[SPOILER][/SPOILER]
You may get this popup here, click the top one and click Ok.
[SPOILER][/SPOILER]

Once this has loaded up, right click the solution at the top of the solution explorer, and click "Configuration Manager"
[SPOILER][/SPOILER]

Click on the dropdown menu and change the solution configuration from Debug to Release. Then click close.
[SPOILER][/SPOILER]

Right click the solution again, and click "Build Solution".
[SPOILER][/SPOILER]

Once this has finished, you should see in the Output "15 succeeded, 0 failed, 0 up-to-date, 1 skipped".
EDIT: As of Revision 4038, luabridge will compile with this, so you should see "16 succeeded, 0 failed, 0 up-to-date, 0 skipped" I think.
[SPOILER][/SPOILER]

Chapter 3: Filling your Complete Folder

Create a new folder anywhere on your computer, again. I'm going to do it on my Desktop and call it ArcEmu Compiled.
[SPOILER][/SPOILER]

Open up your SVN Folder and your Compiled folder, and copy the folder "configs" from the SVN folder to the Compiled folder.
[SPOILER][/SPOILER]

Now go into **YOUR SVN FOLDER**/bin/release_32 and copy these items into your compiled folder.
Edit: You do not need the maps folder.
[SPOILER][/SPOILER]

Finally, go to **YOUR SVN FOLDER**/extras/arcemu-windows-libraries/DLL Files (DLL Files x64 if you are on a 64bit OS) and copy the 2 .dlls into your compiled folder.
[SPOILER][/SPOILER]

Chapter 4: Creating and Filling the MySQL Server

Download MySQL Essntials here : http://dev.mysql.com/get/Downloads/M...www.mysql.com/

When you are installing, click custom setup and include the Lib files by clicking the box and selecting "This feature will be installed on local hard drive."
[SPOILER][/SPOILER]

After has it installed, we want to configure the server. Check the box and click finish.
[SPOILER][/SPOILER]

Click standard configuration, click next.
[SPOILER][/SPOILER]

Click Install as Windows Service, click next.
[SPOILER][/SPOILER]

For the root password in this guide, I will be using "ascent", put ascent as the password and click next.
[SPOILER][/SPOILER]

Click Execute and wait until finished.
[SPOILER][/SPOILER]
[SPOILER][/SPOILER]


Download Navicat here: Navicat Lite (Free Multiple Database GUI) - Free software downloads and software reviews - CNET Download.com

Download and install Navicat. Open it up.
[SPOILER][/SPOILER]

Click file, Click New connection. Input this in the entries, the password is ascent for my guide. Click OK.
[SPOILER][/SPOILER]

Double Click on "Arcemu Server" in the left panel to connect to your MySQL server. You should see 3 grey databases appear.
[SPOILER][/SPOILER]

Right click in the left panel, and click on "New Database"
[SPOILER][/SPOILER]

Name this database world, and click OK.
[SPOILER][/SPOILER]

Repeat this to create 3 databases: "world", "character" and "logon"

Once you have done this, double click on each of the databases to make them turn green.
[SPOILER][/SPOILER]

Right click the character database, and click "Execute SQL File"
[SPOILER][/SPOILER]

click the "..." button and browse to **YOUR SVN FOLDER**/sql/ , double click on the character structure sql file shown in the picture.
[SPOILER][/SPOILER]

Click start, when the queries are executed successfully, click close.
[SPOILER][/SPOILER]

Right Click the logon database and repeat, but use the logon structure file.

For the world database however, we are going to use WhyDB. Create another new folder anywhere. You guessed it, i'm going to use my desktop. Right Click the folder and SVN Checkout it.
[SPOILER][/SPOILER]

Instead of the ArcEmu SVN url, we will use the WhyDB SVN url which is:

http://svn.xp-dev.com/svn/whydb-users/

[SPOILER][/SPOILER]

Click OK, and wait until it is finished, like the ArcEmu source pulling.

Go into the folder and click on the tool.bat to start the whydb installation.
[SPOILER][/SPOILER]

Insert the following data:
[SPOILER][/SPOILER]

At the menu, press i and then enter to start the installation. Once it has finished, you can close it.
[SPOILER][/SPOILER]

Chapter 4: dbc, maps and vmaps

In this chapter I have to whizz off my virtual machine and onto my real machine.

For this chapter you will need:
WinRAR if you do not already have it : http://www.rarlab.com/rar/wrar40b5.exe
Extractor tools : Filebeam - Beam up that File Scottie!

Download and unrar my folder of extractor tools, and place this folder into your 3.3.5a installation. Hopefully this is C://Program Files/World of Warcraft but it really depends where your copy of WoW is.

Next, move these 3 files into the main part of your WoW installation.
[SPOILER][/SPOILER]

Double click on ad.exe to start the map extraction process. Wait until this is finished.
[SPOILER][/SPOILER]

After this, you will want to run "vmapextract_v3.exe". This will start to extract the vmaps. Wait for this to finish.
[SPOILER][/SPOILER]

Finally, you will want to run "vmap_assembler.exe" to convert the data to the correct format. Wait for this to finish.
[SPOILER][/SPOILER]

After these steps have finished, you will have 2 new folders (actually 3, but we don't need buildings) in your WoW folder, maps and vmaps. Copy the folders "maps" and "vmaps" to your compiled folder.
[SPOILER][/SPOILER]

From your wow installation folder, go into **WOW FOLDER**/Data/enGB (could be enUS) move the "ArcEmu English DBC Extractor" to this folder and run it. It may look like it has crashed, but it should complete properly.
[SPOILER][/SPOILER]
[SPOILER][/SPOILER]

You should now have a dbc folder in there, copy that to your compiled folder.
[SPOILER][/SPOILER]

Chapter 6: Changing Config Files

Let's head now to your compiled folder. It should now look like this:
[SPOILER][/SPOILER]

go into the configs folder, and open up logon.conf with notepad.
[SPOILER][/SPOILER]

Change these lines so it looks like the picture.
[SPOILER][/SPOILER]

Save and close logon.conf, open up world.conf and change these lines so it looks like the picture.
[SPOILER][/SPOILER]

Save and close. Go back to your compiled folder. Run the logonserver, then the world server. If you have followed this guide, it should come up with this.
[SPOILER][/SPOILER]

Chapter 7: Adding an Account and Playing

Congratulations, you have successfully compiled your own ArcEmu Core. To play on it, change your realmlist.wtf file found in **YOUR WOW FOLDER**/Data/enGB (or enUS) with notepad. change the top line to:

set realmlist localhost

Open up Navicat again, double click on "Arcemu Server" and Double click on the logon Database. You should see in the right panel a table called "accounts", double click that to bring up the table.

To make it easier to read, click the "form view" button at the top, then input this data.
[SPOILER][/SPOILER]

press control+S, close down your logonserver.exe and worldserver.exe if they're running and restart them. You can now log in with your username: Admin password: admin


Thank you for reading this guide, if you have and suggestions and queries, feel free to ask them. Feedback is greatly appreciated

[Facerolling]

Allowed to bump own threads?

[Cryosepsis]

Hey there! I'm following your guide, but unfortunately there's no picture attached to this step:

Now go into **YOUR SVN FOLDER**/bin/release_32 and copy these items into your compiled folder.
Edit: You do not need the maps folder.

[Facerolling]

Thank you for pointing this out, reuploading.

[Cryosepsis]

Thanks for the prompt reply.
Alright then, back to it.

---------- Post added at 08:01 PM ---------- Previous post was at 07:18 PM ----------

Found another missing picture under:

click the "..." button and browse to **YOUR SVN FOLDER**/sql/ , double click on the character structure sql file shown in the picture.

edit: Though I'm assuming you're referring to 3800_character_structure.sql

[Facerolling]

Yes I am, will re-upload the pictures tomorrow morning, sorry for the delay but it's 1:28 am here

[Cryosepsis]

I went through the rest of the pictures and they all seem to be intact. Have a good night!

[bergianz]

Is there any way of making it work with 4.0.3 or do I have to de-patch my install?

[Cryosepsis]

From what I understand berg, there aren't any reliable Cataclysm emulations available yet, and won't likely be any for quite a while.

---------- Post added at 10:56 PM ---------- Previous post was at 09:47 PM ----------

"After these steps have finished, you will have 2 new folders (actually 3, but we don't need buildings) in your WoW folder, maps and vmaps. Copy the folders "maps" and "vmaps" to your compiled folder."

I have a maps and buildings folder, but no vmap folder was created. Suggestions?


---------- Post added at 11:25 PM ---------- Previous post was at 10:56 PM ----------

fixed: I created a vmaps folder of my own, then ran the assembler again. Assembler converted vmaps and filled the vmaps folder I had created. I'm all "hurray!" and o.O at the same time.

---------- Post added 02-07-2011 at 12:49 AM ---------- Previous post was 02-06-2011 at 11:25 PM ----------

"From your wow installation folder, go into **WOW FOLDER**/Data/enGB (could be enUS) move the "ArcEmu English DBC Extractor" to this folder and run it. It may look like it has crashed, but it should complete properly."

The first thing I learned after this didn't work for me is that you actually need to put three files into /data/language; those being ArcEmu English DBC Extractor, mpqe_cpp and SFmpq.dll.
The next thing I learned was that this DBC extractor simply doesn't work for me. :/ I'm still not really sure why that is.
Fortunately, Stoneharry's DBC Extractor did the trick for me. Hurray!


---------- Post added at 01:50 AM ---------- Previous post was at 12:49 AM ----------

[01:47][Arcemu]!!! possible invalid format in file DBC/Spell.dbc (us: 234, them: 240)

From what I've gathered, this results from my WoW client version not matching the server version. Does us/them suggest that this Arcemu core is compatible with a lower version of WoW than I have? I patched to 3.3.5a as you adviced.

[Facerolling]

My DBC extractor should work, I found that if I used another dbc extractor it gave me the same error.

I will PM you regarding the dbcs for reasons I will explain in the PM.

Thanks.

[Cryosepsis]

Thanks facerolling, the info you sent me fixed that problem. But now I get this:

[13:56][Arcemu]Authentication request from 127.0.0.1, result FAIL.

in logonserver and a similar message in world. Thoughts?

[Facerolling]

Ah, That's what I forgot to include in my tutorial, Silly me!

You're extremely close to finish, just need to change one word even!



Change what you should have in your World config file (I think it's change_me_world) to "change_me_logon"

[Cryosepsis]

Yup, that worked.

One more question, Facerolling. I logged in with admin info, all is well. But it goes straight to "downloading updates." Is this normal? Should I let it run?

edit: I might add for clarification, I launched with wow.exe, logged on as admin, and then it takes to the downloading updates screen. I did not use the blizzard launcher.

[Facerolling]

Did you change your realmlist?

That is not meant to happen, and you should not let it download. If you've changed "set realmlist localhost", try changing "set patchlist" to localhost too.

Remember to save the file x)

[Cryosepsis]

Both realmlist and patchlist are set to "localhost." It's still going to downloading updates from login. oO