If any one have any question or errors feel free to ask And I hope you guys like it.
First this is what you will learn:
Using Winrar (if you dont know what that is)
Setup MySQL and Navicat
Config the Arcemu config files
And to the end how to start the server without any errors
Now you need to download some stuff:
WinRAR 3.71
MySQL
Navicat 8.0.27
Rev465 by Syrtan
First thing we will do now is extracting nessecary files for your server.
1. Right click on the folder called "DBC" and choose "extract here" from the drop down menu.
2. Do the same with the folder called "arcemu-world.rar". Right click and choose "extract here" from the drop down menu.
Ok now we got that done we want to extract maps files from the wow folder.
1. Copy all files in "Extractors and Assambler" to your World of Warcraft folder.
2. Run ad.exe : Notice that this extractors could take some time but just start install the database in this time then.
3. Run vmapextract_v2.exe
4. Run vmap_assembler.exe
5. Copy all this files (maps, vmaps and buildings into your server folder
Time to install and setup MySQL
1. Extract it using WinRAR then run "setup.exe"
2. Click "Next"
3. Choose "Typical" and click "Next"
4. Click "install"
5. Click "Next"
6. Click "Next"
7. Mark the box called Configure the MySQL Server now and click "Finish"
8. Click "Next"
9. Choose "Standard Configuration" and click "Next
10. Click "Next"
11. Choose a password NOTICE:THIS IS THE PASSWORD YOUR GONNA USE LATER IN THE CONFIG FILES AND NAVICAT When you have done that click "Next"
12. Click "Execute"
13. Then "Finish"
How to setup Navicat
1. Just install the program by clicking next all the time. This program is a trial but im sure you could find a crack out there.
2. Open Navicat and hit the big button "Connection"
3. Fill in your information:
4. Then click "ok"Connection Name: Ascent
Hostname/IP address: localhost or 127.0.0.1 (this are default)
Port: 3306
User Name: root
Password: Your MySQL password
5. Double click on "Ascent" so it become green
6. Right click on "Ascent" and choose "New Database..." from the drop down menu.
7. Under "Enter Database name:" write "world" and click ok
8. repeat step 6 and 7 with the names logon and character.
9. Now you should have 3 databases world, logon and character.
10. Go to the folder you downloaded. Rev465 by Syrtan and click on the SQL folder. You will now see a winRAR folder named "World.rar" Right click and choose "extract here".
11. Open Navicat again.
12. double click on the database named "world"
13. Right click and choose "Execute Batch File..."
14. Click the "..." button and browse to the SQL folder inside Rev465 by Syrtan and choose "world.sql" click open
15. Then click start, now just wait
16. When that is done do the same with the database "character" just now choose "character.sql"
17. And after that do the same with "logon.sql"
18. Your done with the database and Navicat part=)
Now how to config the config files the right way.
1. Open the folder "configs" in your server folder
2. Then open arcemu-logonserver.conf with notepad
3. Scroll down to you see
4. Change the "host" to your database hostname. Default: localhost or 127.0.0.1<LogonDatabase Hostname = "host"
Username = "user"
Password = "pass"
Name = "dbname"
Port = "3306"
Type = "1">
5. Change the "user" to your MySQL username. Default: root
6. Change the "pass" to your MySQL password
7. Change the "dbname" to logon
8. Then again scroll down
9. Change "change_me_logon" to something you will remember. Ex ascent<LogonServer RemotePassword = "change_me_logon"
AllowedIPs = "***MUST BE COMPLETED***"
AllowedModIPs = "***MUST BE COMPLETED***">
10. Change both "***MUST BE COMPLETED***" to "127.0.0.1/24. Save and close down
11. Open arcemu-realms.conf and scroll down
12.13. Test Realm is the name of the server change it if you want. Save and close down<Realm1 Name = "Test Realm"
Address = "127.0.0.1:8129"
Icon = "PVP"
Population = "1.0"
TimeZone = "1">
14. Open arcemu-world.conf and scroll down
15. <WorldDatabase Hostname = "host" Username = "username" Password = "passwd" Name = "database" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "host" Username = "username" Password = "passwd" Name = "database" Port = "3306" Type = "1">
15. Again change "host" to localhost.
16. Change username to root
17. Change passwd to your MySQL password
18. Change light green database to world
19. Change dark green database to character.
20. You also have to the delete the two:Just delete it=) Save and close down#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Die Directive
#
# If this triggers it means you didn't read your config file!
# Just comment it or remove it when you've read this.
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
<die msg="I am a newb who didn't even read half my config file!">
How to make an account.
1. Open logon database in navicat.
2. Then open "account" table and fill the information.
3.Thoose columms i dident comment here dont need to be modified.login=account user name
password= account password
gm= az unlocks all commands from a-z
flags= 8=Bc enabled 0=non bc
So your done =)
Change the realmlist.
1. Open realmlist.wtf in notepad and delete all in there
2. Copy this and paste into the realmlist.wtfNow you can start your serverset realmlist 127.0.0.1
1. Run arcemu-logonserver.exe wait for it to say "Success! Ready for connections"
2. Then run arcemu-world.exe
Now you can login to world of warcraft with your account