[Tutorial] Compiling your own ArcEmu repack/server for beginners.

[Ground Zero]

What you need.

1. Microsoft Framework 3.5
2. Tortoise SVN
3. Microsoft Visual Studio C++
4. MySQL Server
5. Navicat SQL

4 & 5 are optional depending if you already have a portable MySQL server or another Database editor.

Step 1.

You have now restarted your computer after finishing installing Microsoft Framework 3.5/Tortoise SVN and Visual Studio C++.

Lets start by downloading your "trunk" for your server.
Open a new blank folder on your desktop, call it trunk or anyother name you prefer.



Right Click on the folder and click SVN Checkout, when it asks you for a SVN Address input the following;



Click OK then wait for the download to fully complete.



Once completed your folder should now have a green tick on it like so.



Step 1 Complete!

Step 2.

Now your trunk is downloaded, open your trunk.

First: Go to trunk/extras/arcemu-windows-libraries/sources/VC90-pcre and open that file.
Now you will see Microsoft Visual Studios for the first time.
Make sure to select Release. Do not select debug! Then right click on the name and click build solution.



You will now see the output box spam some stuff and then you will see this.



Secondly: Go to Trunk\extras\arcemu-windows-libraries\VC\lib
You will see two things, one called pcre_release_win32 and one zlib_release_win32 rename them to pcre and zlib.

Next go to C:\Program Files\Microsoft Visual Studio 9.0\VC and move the folders "include" and "lib" from C:\Users\Theo\Desktop\Trunk\extras\arcemu-windows-libraries\VC to VC in Visual Studio 9.



Final Step: Go to C:\Users\Theo\Desktop\Trunk\win\arcemuVC90 - All Projects.sln and open it.
Do the same as you did with Zlib/pcre.



*Note if you get any errors scroll up until you find where the error came
from, eg Logonserver got 1 error, right click on Logonserver on the left box
click "Clean up" then click "Rebuild" and hopefully you won't get any more
errors.


Step 3

Now go to Trunk\bin\Release and you will see there is now something in it.

Create a new Folder on your Desktop. Call it Yournames Repack or whatever you want.

Inside create a Subfolder called "ArcEmu"
Inside ArcEmu copy the following things from your Release folder.



Then go into your Script bin folder and delete everything that I havn't highlighted in the picture.



Now go to Trunk and copy the Configs folder into ArcEmu.
Now go to Trunk/Extras/arcemu-windows-libraries\DLL Files and copy "libmySQL" and "libeay32" to your ArcEmu folder.

Congratulations, you've now compiled your ArcEmu server!

Step 4.

Setting up the Database.

First: Create a new folder on your desktop and call it database or whatever you want.

Using the same method as before right click it and click SVN Checkout.

Use any of the following databases for 3.3.2 ArcEmu.
lhdb - Revision 69: / - Light Hopes DB
Squire-DB - Revision 81: / - Squire DB
http://svn.xp-dev.com/svn/whydb-users - WhyDB

Then Download it.

Open up your MySQL.bat to start up MySQL. Open the tool included in your downloaded DB of your choice.

Then input your database information like so.



Wait for the tool to complete and then you've extracted world successfully!

Now for Logon and Character:

Keeping MySQL.bat open at all times, go to back to your Trunk and you will find xxxx_Logon_Structure and xxxx_Character_Structure.

Open up Navicat or your chosen DB editor like so and connect to your MySQL DB which by default for ArcEmu is:

host: Yourhost (localhost)
user: root
pass: ascent
port: 3306

You should see world there which you extracted earlier.

Right Click on world and select "New Database" and name it "logon" and click ok. Then double click "logon" and then right click it and select "Execute Batchfile"



And navigate to Trunk/sql/xxxx_logon_structure and execute that SQL.

Do the same with Character, create a database called character and execute character structure.

Now open "logon" and click "accounts" and create your account to log ingame with. WoTLK Flags are 24. Admin GM flags are "az".

Alright, you are now almost done!

Step 5.

DBCs & Maps.

You're almost there, just do this final step and you can play on your server.

Setting up your configs.

Open up ArcEmu/Configs/world.conf and edit the DB information at the top to show the following:

<WorldDatabase Hostname = "localhost" Username = "root" Password = "ascent" Name = "world" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "ascent" Name = "character" Port = "3306" Type = "1">

Go to Logon.conf and change the "Remote Password" from "change_me_logon" to "change_me_world" and change the DB info at the top to the following

<LogonDatabase Hostname = "localhost"
               Username = "root"
               Password = "ascent"
               Name     = "logon"
               Port     = "3306"
               Type     = "1">

Download your DBC Extractor and Map Extractor from Here:

Filebeam - Beam up that File Scottie!

Open up your DBC extractor and Select the following 3 things:

SFmpq
MPQE
enGB or which ever applies to you.

Move all those 3 to your World of Warcraft\enGB folder and run enGB and wait for them to extract into a new folder called "dbc" and then move the dbc folder to your ArcEmu folder.

Congratulations you are now ready to start your server up.

Just make sure MySQL is open, run arcemu-logonserver.exe and then arcemu-world.exe and then set your realmlist to 127.0.0.1 and login with your account you made earlier.

Optional Maps

You need these if your going to be using .gps and .worldport or working with coords.

Open your Map Extracter you downloaded earlier.
Go to 3.3.2 (Newest) and copy the ad.exe and maps folder to your World of Warcraft folder, run ad.exe as a admin if your on vista/win7 and wait for it to complete. Then finally move the maps folder to Servername/ArcEmu and you're done!

Finaly Result:


If you need any help just reply here.

[XC4T4LY5TX]

Arent there like 1000 of these guides?...either way, good guide

[stoneharry]

I'll tell you the same as I tell every guide I see:
Give extra information, it helps a lot. Also say why were doing something, someone can understand something a lot better if they know why and not just copying you. For example:
When checking out, what is it checking out? What is a revision? How can we get a different revision? If we checkout a specific revision how can we not get the latest ArcScripts etc. If we compile ArcEmu on debug, what is this? Why do we need to use release. What is Navicat? What can we use it for? Is there any alternatives. How can we compile our own map extractor and not download one? What are vmaps?
Nevertheless, good work.

[Zibenatum]

thanks for this =] always wanted to know how repacks are made

[davidknag]

like any other guide people would be like REPOST!!

[davidknag]

hey you know how repacks have a "server" folder?


i need apache and mysql for a repack.


I still host a live server that has more than 5k users.

I NEED a server folder so i can switch between databases.

[superryan666]

Thanks for this Tut, its good if you understand Mysql and all that, i found it very easy atualy so thanks Ground zero! its a very great tut +rep !

Ryan.

[tehgeekprvtsvr]

Thank you very much, so much mroe rewarding than just downloading a repack

[TGE985]

You didn't tell us what to do for step four... I'm stuck at "Enter a char:"...

[TGE985]

Is it against the rules to bump?
If not, bump.

[Ascelyn]

I keep getting this error when compiling arcemuvc90

"7>c:\Users\pc\Desktop\Trunk\src\arcemu-world\StdAfx.h(60) : fatal error C1083: Cannot open include file: 'zlib.h': No such file or directory"
And way more others.. I've selected the clean option it said it was succesfull, Then I've tried it again, Still same error

4>c:\users\pc\desktop\trunk\src\arcemu-shared\database\MySQLDatabase.h(26) : fatal error C1083: Cannot open include file: 'mysql/mysql.h': No such file or directory

3>collision - 0 error(s), 0 warning(s)
4>CircularBuffer.cpp
4>WowCrypt.cpp
4>Sha1.cpp
4>c:\users\pc\desktop\trunk\src\arcemu-shared\auth\WowCrypt.h(27) : fatal error C1083: Cannot open include file: 'openssl/sha.h': No such file or directory
4>MD5.cpp
4>c:\users\pc\desktop\trunk\src\arcemu-shared\auth\MD5.h(24) : fatal error C1083: Cannot open include file: 'openssl/md5.h': No such file or directory
4>crc32.cpp
4>BigNumber.cpp
4>c:\users\pc\desktop\trunk\src\arcemu-shared\auth\Sha1.h(25) : fatal error C1083: Cannot open include file: 'openssl/sha.h': No such file or directory
4>Config.cpp
4>..\..\src\arcemu-shared\Auth\BigNumber.cpp(21) : fatal error C1083: Cannot open include file: 'openssl/bn.h': No such file or directory
4>SQLiteDatabase.cpp
4>PostgresDatabase.cpp
4>MySQLDatabase.cpp
4>DBCStores.cpp
4>c:\users\pc\desktop\trunk\src\arcemu-shared\database\MySQLDatabase.h(26) : fatal error C1083: Cannot open include file: 'mysql/mysql.h': No such file or directory
4>DBC.cpp
4>dbcfile.cpp
4>Database.cpp
4>Build log was saved at "file://c:\Users\pc\Desktop\Trunk\win\VC90\arcemu-shared___Win32_Release\BuildLog.htm"
4>arcemu-shared - 6 error(s), 0 warning(s)

This is one of them. 3 succeeded 12 have failed :/ It's mostly the zlib.h :/

[hahabynow]

Thanks i used this and it worked

[basketballers24]

do you have an update for 3.3.3.a?

[Sprayer1]

it says to me login server not active...

[marijnz]

ty man : D, used this one to compile my wow server, did with repack first : ).
I didn't look google or something yet but : How to update this compiled server without any data loss ( chars, added npc's, malls, weps)

ty!