Thread: Compiling 3.3.5 Arcemu Core and Database for the not-so-advanced user (:

First things first: This is not an attempt to be "orginal", because I can see that others have posted guide's like this.. This is just an attempt to get all the info you need for this squeezed into one guide, along with screenshots of possible problems you could encounter, what you should be seeing as you go through these steps, and how to fix any problems you could experience. Credits go to -Sidefx, Truster, and Samgartell
from here[mmotop] for all of their patience, help and support while I learned to do this, and for helping me fix all the issues I ran into (: What you will learn:
How to compile an ArcEmu core, and WhyDB
How to change your config files so everything works right
How to fix common problems when setting up your server, etc

If I missed ANYTHING or you have any suggestions on re-phrasing, clarification, terminology, etc please let me know and I will include your correction and give you credit for helping because I am new at this stuff after all lol (:

You will need the following programs:
Microsoft Visual C++ Express Edition(which you can find on microsofts website)

Navicat or Hedisql (if you don't have either go with Navicat, as this tutorial is based on it, you can google either one to find a DL) - Don't get spoiled to Navicat unless you are going to buy it after the trial! I would learn to use Heidsql afterwards if you don't already know how!

TortoiseSVN(which you can DL from [Only registered and activated users can see links. ])

WinZip (which you can DL from [Only registered and activated users can see links. ])(or the equivalent)

and your mysql/apache server stuff [download but leave on desktop for now] ( [Only registered and activated users can see links. ] )

Download and install everything, then restart your computer.

For the core:

1. Make a new folder on your desktop, and name it whatever you want [for this we will say 'Arcemu']
2.Right click, and choose 'SVN checkout'
3.A window should pop up that should look something like this



For url of Repository put this: [Only registered and activated users can see links. ]
For checkout depth it should be fully recursive by default, if not change it to that, and leave omit externals unchecked. Make sure HEAD REVISION is selected.
4. Click ok
5. Now a window should come up and and begin doing stuff. This COULD take FOREVER, but if you want your own core bad enough you will just have to suck it up now wont you (:
It should look something like this:



6. After the svn checkout is finished doing it's thing, Go to the folder you just created and open extras, then Arcemu-Windows-Libraries.
7.Copy the VC folder. Go to Program Files, and open the Microsoft Visual Studio 10.0 folder. Paste VC into it and click yes to everything.
8.Go to Arcemu, then Win and open "arcemuVC100 - All Projects. sln"
9. Once it opens and loads, select 'Debug' from the menu at the top, change to release.



10. Go to 'Debug' and then 'Build Solution. This will also take awhile. If it finished successfully nothing should have failed.



11. Now go to C [or whatever drive WoW is installed on] and create a new folder called ArcEmu 3.3.5 Repack. [or whatever suits your fancy]
12.Open that folder and create two separate folders called Core and name the other Server.
13. Go to Arcemu on your desktop, then Bin and release and copy everything to the core folder. Then create a folder inside core called Configs.
14.Now go to Arcemu again, open Configs and copy all 4 .config files into your config folder [the one you created].
15.Now go to Arcemu,/extras/Arcemu-Windows-Library. Open DLL Files and copy everything into the new core folder.
FOR VISTA 64 BIT go back to Arcemu-Windows-Library and open up DLL Files (x64). Copy those two files into the Core folder and overwrite.

16. Ok, now for your SQL stuff, just extract it [using WinZIP or the equivalent] to your Server folder.

For the Database:

1.Make a new folder on your Desktop called WhyDB, right click it and select SVN checkout
2.When the window pops up, put http://svn.xp-dev.com/svn/whydb-users for the URL of Repository. Click ok and wait.
3. After your Database is done, go to the Server folder you created under Arcemu Repack 3.3.5, double click Mysql.bat
4.leave that running in the background and go to your WhyDB folder, double click Tool.bat
5.It will ask for your Mysql server address, type this: 127.0.0.1 and hit enter.
6. When it asks for username type root, then hit enter. Then it will ask you for password, type ascent, and hit enter again. Now you need to import your database, so hit the letter i, then enter again and wait for it to finish.



Now to update: Right click your WhyDB check out folder, click 'Update svn, let that finish. Then run tool.bat again, fill in the info, then when your logged in hit 'U' and it will ask you to give a changeset number, just hit 'A' as this will import all of them to your DB (: Now you are done updating your database.


7. Now open Navicat, you MUST have mysql running to be able to log in. Double click 'LocalHost_3306, Your password will be the same as in Mysql(ascent).
8.Now you need 3 new Databases - To do this right click localhost_3306 and select 'New Database'. name the first one logon, the second world, and the third character.
9.(not sure this part is necessarry BUT to play it SAFE, unless you know for sure otherwise, go ahead and do it)
Double click whydb_world, then when it collapses, right click it and select 'Execute SQL file', You should get this:



Navigate to your Desktop/Arcemu/sql and double click xxxx_logon_structure.sql. Do the same for xxxx_Character_Structure.sql.



10. Now double click, then right click the logon DB that you created earlier, select 'execute SQL file', then navigate to Desktop/arcemu/trunks/sql and double click xxxx_logon_structure.sql. Do the same with your Character DB except you want to execute xxxx_Character_Structure.sql, and execute xxxx_world_structure.sql from world.
11.Now you need to get your DBC files. Go here to get them: [Only registered and activated users can see links. ]
12.Extract those files to Warcraft\data\enUS [or whatever your language is ;-)] This will put several different language batch files in there. You only need to run the one that corresponds with your language folder [for example, my folder is called enUS so I would click the file that says 'enUS']
13.When that's done, look for a folder called DBC, inside will be all your new dbc files. Copy the just the files over to C:/Arcemu Repack 3.3.5/Core/DBC.

Now just some final touches:

Go to your WoW Directory, open Data/EnUS and find your realmlist.wtf file, open with notepad and clear all the text inside and put this - 'set realmlist 127.0.0.1' [without the quotes]
NOTE: If you want to make it public I can help you out but only if you're going to do it using Hamachi, otherwise I can't help you too much.

Go to your configs folder, open Logon.config, and make sure the following sections have this info;

Code:

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

Code:

<LogonServer RemotePassword = "ascent"
             AllowedIPs = "127.0.0.1/24"
             AllowedModIPs = "127.0.0.1/24">

Save any changes, then close and open World.config;

Code:

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

To make an account, make sure you have Mysql.bat AND Apache.bat running, then open your browser [Firefox, IE, Opera, Chrome, etc] and type 127.0.0.1 and fill out the form (: [THANK YOU INFLAMESACE88CA FOR FEEDBACK:)]
Then to make sure you're account is GM, go to Navicat, double click the table called Accounts, then go under the collum called Gm and put in "az" (w/out the quotes)
AND
Also, If you have WotLK installed, scroll over to the collum called Flags, go under it and make sure that it says 24, if you have only bc, change it to 16 and for original WoW do 1.

To start your server so you can play, go to Arcemu Repack 3.3.5, then open server and double click Mysql and then Apache. Then go back again and open Core, then double click Logonserver.exe, then logonworld.exe

Now for the many issues you could encounter:

1. "Mysql could not be started, press any key to continue"
Open task manager, and look for anything that has mysql in it, and end process. Try again and it should work then.

2.

(Samgartell gave me this link in a post when I had this issue, thanks! :)) [Only registered and activated users can see links. ]
Copy and past that file into C/World of warcraft/Data/EnXX/DBC when it asks to overwrite click yes, then copy and past it into C/Arcemu repack 3.3.5/Core/DBC and yes to overwrite again (:

3. If you get anything about Unknown Database, etc etc.. chances are you missed something and you should refer back to the config part and double check to be sure everything is right (:



Now to update your core:
(It isn't necessary to update right after you compile your core, you could just do so in a day or two)
1. Right click your Arcemu folder (the one on your desktop of course)
2. Click update SVN (shouldn't take long this time)
3. When it's finished go to Arcemu then Win, then open arcemuVC100 - All Projects
4. Once everything loads make sure Debug is switched to Release.
5. Then right-click "Solution 'arcemuVC100 - All Projects' xx projects" and select Rebuild solution.
6. Close it when it finishes, go to Arcemu/Win/Release and copy the files there, then go to your core folder and paste everything there, overwrite when it asks.

There are optional editing stuffs you can do.. but I'm not too clear on how to do all that and would just be blind leading the blind so I can't help you too much there lol.

Again I know there are guides on this already, but I wanted to make one that included more information for the not-so-advanced user. And I felt a serious need to contribute after the plethora of help I recieved on this forum while I was learning to do the same thing (:

If you run into any issues I will do my best to help you, but I can't promise I will be able to on every issue as I am inexperienced with these things, but again I will do my best (:

I hope this helps someone (:

Th-th-th-That's all, folks!

Nice guide pretty detailed ^^ looks like you have learned much since the first time you came to this forum. Hope you continue to learn and write more guides :)
Doesn't matter if we have more of these guides. There are always someone who doesn't understand 1 guide then look for another one who maybe he understand better and so on.

Wow thanks guys! (:

@Truster - Yeah lol I owe most of that to you b/c you helped me out tons when I was having trouble getting mine set up xD

Well no problem ^^ glad i could help you.

Originally Posted by ace88ca

"To make an account, make sure you have Mysql running, then open your browser and type 127.0.0.1 and fill out the form (:"

this is the one thing that confused me, it may be a dumb question but what browser do I open and type the 127.0.0.1 in?

Whichever you want mate ^^ should work with every browser like firefox, explorer, chrome etc.

That's what it's supposed to show ^_^ find register.php [the text should be blue] and click on that and wala (: