Need help making my own 3.3 mangos or arcemu server

[pocketpc2004]

i have tried a few guides on how to make a mangos server and a arc emu server from scratch but i never seem to get things right so i was wondering if someone with enough knowledge could help me with getting the latest programs, database, and core files and helping me with setting it up. i dont want to download a repack. anyway thanks in advance for anyone who can help me.
please

[09SMalone]

I would be happy to help, although I suggest strongly that you consider trying a nice repack as your first time option. Let's get started. Let's find out what type of server you want to make first.
Question 1: Are you interested in making a funserver, or a blizzlike server?
Question 2: Are you looking to add custom content?
Question 3: Will your server be public?
Question 4: Are you experienced with either mangos or arc emu?

[pocketpc2004]

Waited a long time for someone to answer . So alright here is what I want. I would like a blizzlike server. 100% blizzlike if possible, so adding custom content wouldnt be necessary. I would like my server to be online so I could play with my gf's stepfather. I used mangos repacks before so i was a little used with using the commands (just creating accounts and stuff). I would realy prefer to build my own server then use a repack. I already tried but using some old threads and could never get them to work. oh yea I am using windows 7 64bit. Thank you in advance 09SMalone :heart:

[Brucey125]

Step 1
It begins: You will need a bunch of programs to be able to get everything you need, in this tutorial I will be using the following:
XAMPP for Windows
Git-1.6.2.2
Navicat Lite for MySQL(Windows version)
Microsoft Visual C++ Express Edition
TortoiseSVN



Step 2
Installation: Install all the programs listed above and if you can't do that I sincerely advice you to stop reading this tutorial. The only thing that I'm going to go a little deeper into in the installation part is the XAMPP installation:

- When installing BE SURE TO CHOOSE: Install Apache as service AND Install MySQL as service because otherwise you'll end up with some troubles later on.




Step 3
Security: Now when we have the XAMPP server installed, let's make it secure with a password for the databases to prevent hackers from getting in a little easier. Move into the folder where you have chosen to install XAMPP, for example: C:\xampp\
-Start up the XAMPP Control Panel Application, the file: xampp-control.exe
-Click on Start button for both Apache and MySQL, it should take some seconds and then they will be running. If you end up with having some problems using the control panel, simple use the file: xampp_restart.exe instead.
-Open up your internet (internet explorer / firefox / opera / etc) and write : http://127.0.0.1/security/xamppsecurity.php OR http://localhost/security/xamppsecurity.php , it's the same thing.
- You will now be in the security section where you are to choose a password. In this guide we will use the password: root
- Write down your password somewhere because you will need it later to access your databases. The password you've chosen will not be changed until you restart MySQL and Apache.


Step 4
Preparations: And then it's time to get all the things we need for the server; MaNGOS Core, Scriptdev2, ACID, UDB. We'll start with the core:
- Start up Git, using the Git Bash in the programs meny. the CMD will start up and in here you write: git clone git://github.com/mangos/mangos.git
- The download will start and after it is finished simply shut Git Bash down by writing: Exit OR click on: Ctrl + C
- The folder where the mangos core has been downloaded to probably is at this location in your computer:
C:\Documents and Settings\Your_Name\mangos\
- We can download the Scriptdev2 aswell, move in to the folder:
C:\Documents and Settings\Your_Name\mangos\src\bindings
- Create a folder called Scriptdev2, right click on it and choose: "SVN Checkout..."
- A box will appear and in the URL of repository write the following: https://scriptdev2.svn.sourceforge.n...ot/scriptdev2/
- Click OK and the download will start. Wait for it to finish and click OK.
- Create a folder called "MaNGOS server" anywhere you want and create another folder called "ACID sql" inside.
- Do the same thing as you did with the Scriptdev2 folder but change the URL of repository to: SourceForge.net Repository - [sd2-acid] Index of /acid_archive/0.1.0
- This will download the ACID scripts.
- Create another folder in the "MaNGOS Server" folder called "UDB sql"
- Download UDB svn, right click on the UDB sql folder and choose SVN Checkout... again, but this time use this in the URL of repository: https://unifieddb.svn.sourceforge.ne...nifieddb/trunk
- Now you have all the things you need for your database! One step closer to gaming Wink


Step 5
Compiling: Compiling your core isn't as hard as it sounds, it's quite easy. Move into the following folder:
C:\Documents and Settings\Your_Name\mangos\win\
- Double click on the mangosdVC90.sln file, this will start up Microsoft Visual C++ Express Edition.
- Click on Build and then on Configuration Manager on the top.
- A box will appear and instead of having Debug as an Active Solution Configuration, choose Release and Close it.
- Click on Build again and then on Build Solution.
- The compiling of your core has begun. It will take some time, be patience.
- After the compile is done it should say, for exampel: "Build: 9 succeeded, 0 failed, 0 up-to-date, 0 skipped" as long as there isn't any FAILED ones you are good to go.
- Move back to the Scriptdev2 folder:
C:\Documents and Settings\Your_Name\mangos\src\bindings\Scriptdev2\
- Double click on the scriptVC90.sln file and do the same thing as you did with the MaNGOS core.
- Your Scriptdev2 and MaNGOS core has been compiled and can be found in the:
C:\Documents and Settings\Your_Name\mangos\bin\release\
- One more thing you have to do is to copy over your configurations files, they can be found in the:
C:\Documents and Settings\Your_Name\mangos\src\mangosd\ ::: for mangosd.conf.dist.in
C:\Documents and Settings\Your_Name\mangos\src\realmd\ ::: for realmd.conf.dist.in
C:\Documents and Settings\Your_Name\mangos\src\bindings\Scriptdev2\ ::: for scriptdev2.conf.dist.in
-Copy these three configuration files over to the:
C:\Documents and Settings\Your_Name\mangos\bin\release\
where you have the compiled cores and change their names by deleting the ".dist.in" in the end.
- Copy all the files within the folder with the configuration files and compiled cores over to your "MaNGOS Server" folder you created before.


Step 6
Databases: Wow, let's take a break, na I'm just kidding, KEEP ON WORKING!
- Make sure you have MySQL up and running with the new password you've chosen.
- Start up Navicat and to the left you will have an empty box, right click on it and choose "New Connection...", another box will appear.
- Do the following:
Connection Name: Localhost
Host name/IP address: Localhost
Port: 3306
User name: root
Password: **the password you've chosen**( for this tutorial it's: root)
- Click Ok and the connection will be available to the left. Right click it and choose, Open Connection. You are now connected to your MySQL.
- Right click again on it and choose New Database..., create the following 4 databases with the names:
characters
mangos
realmd
scriptdev2
- Right click on the characters database and choose Open database.
- Right click again on it and choose Execute Batch File... , a box will appear and you have to choose a file to execute, the file needed for the characters database is: characters.sql and can be found in
C:\Documents and Settings\Your_Name\mangos\sql\
choose it and click on Start. The importing will begin and after it's finished click on close and close the database.
- So the following files shall be executed into it's proper database:
:: characters.sql ---> Characters Database
:: mangos.sql ---> Mangos Database
:: realmd.sql ---> Realmd Database

- For the Scriptdev2 database you will need to execute the following files in the order I've written them in:
:: scriptdev2_create_structure_mysql.sql ---> scriptdev2 database
:: scriptdev2_script_full.sql ---> scriptdev2 database
These can be found in the Scriptdev2 folder at:
C:\Documents and Settings\Your_Name\mangos\src\bindings\Scriptdev2\sql\

- Now to UDB's part of the job, open up your mangos database and execute the following sql files in the order I've written them in:
:: UDB_0.11.6_Core_8734_SD2_1480.sql -> mangos database (Full dump)
:: 385_corepatch_mangos_8735_to_8798.sql-> mangos database
:: 385_updatepack_mangos.sql -> mangos database
:: 386_corepatch_mangos_8799_to_8994.sql-> mangos database
:: 386_updatepack_mangos.sql -> mangos database
These can be found in the UDB sql folder in your MaNGOS Server folder.

- After the import is done you could start execute the script sql's from ACID and Scriptdev2 to your mangos database and to Scriptdev2 database
:: mangos_scriptname_full.sql ---> mangos database
:: 010_acid.sql ---> mangos database

The mangos_scriptname_full.sql can be found in the;
C:\Documents and Settings\Your_Name\mangos\src\bindings\Scriptdev2\sql\
and the other two in the ACID sql folder in your MaNGOS Server folder.

- Note that you don't have to apply the 367_corepatch_characters_7070_to_7109.sql and the others to the characters database since they are already up-to-date. Another thing to know is that when you have done all the importing you can't use the latest mangos core since UDB database doesn't support it yet, you could use the mangos sql updates from the update folder(C:\Documents and Settings\Your_Name\mangos\sql\updates\) and individually import all the updates, for example:

:: 7536_01_mangos_spell_chain.sql ---> mangos database

- And continue on doing all the others updates that's in the same folder until you reach the latest and then you will be able to use the latest mangos core.

------------------------------------------------------

While I'm writing here I'll just continue on explaining how to know what updates to apply if someone else got problems with that.
I'll take the following as an example:

7536_01_mangos_spell_chain.sql :::: This shows to which core the database will be supported to.
7536_01_mangos_spell_chain.sql :::: This shows to which database this update shall be imported to.

So if you have imported all the releases and updates from UDB the database should support: 7681 MaNGOS core
But if you have imported all the updates from the MaNGOS updates folder the database should support: The newest MaNGOS core


Step 7
Maps, Vmaps & DBC: Jumping directly over to extracting the maps, Vmaps, Buildings & the DBC's from your world of warcraft folder.
- ad.exe only extracts the Maps & DBC files and can be found in:
C:\Documents and Settings\Your_Name\mangos\contrib\extractor\
- Copy ad.exe over from that folder over to your World of Warcraft folder and double click it, the extraction of DBC's and maps will begin. Two folders will be created, Maps and DBC. Just let them be for now.
-To get the Vmaps you need to use the file: makevmaps_SIMPLE.bat found in
C:\Documents and Settings\Your_name\mangos\contrib\vmap_extract_assembler_bin \
-Be sure to copy ALL the files in that folder over to your World of Warcraft folder and click on file I mentioned above. It will take some time, get some coffee or some cookies, read the news, whatever. DO NOT CLOSE DOWN THE PROGRAM OR MOVE THE FOLDERS during the extract even if it looks done, just wait until it closes by itself.
- When the extraction is done you will have 4 folders having the name: Maps, Vmaps, Buildings and DBC.
- Cut them and paste them in your MaNGOS Server folder.


Personal Message (Offline)


[Tutorial] From nothing to online server - Part 3
« Reply #2 on: April 13, 2009, 09:47:22 pm »
Reply with quoteQuote
In this part you will learn how to extract what you need from your World of Warcraft folder and configurate it Smiley

Part 1 - What programs you need, how to install MySQL/Apache, secure it from hackers and how to download and from where
Part 2 - How to compile the core and fixing the database
Part 3 - How to extract what you need from your World of Warcraft folder and configurate it
Part 4 - How to get a Blizzlike Website and how to make your server go public!




Step 7
Maps, Vmaps & DBC: Jumping directly over to extracting the maps, Vmaps, Buildings & the DBC's from your world of warcraft folder.
- ad.exe only extracts the Maps & DBC files and can be found in:
C:\Documents and Settings\Your_Name\mangos\contrib\extractor\
- Copy ad.exe over from that folder over to your World of Warcraft folder and double click it, the extraction of DBC's and maps will begin. Two folders will be created, Maps and DBC. Just let them be for now.
-To get the Vmaps you need to use the file: makevmaps_SIMPLE.bat found in
C:\Documents and Settings\Your_name\mangos\contrib\vmap_extract_assembler_bin \
-Be sure to copy ALL the files in that folder over to your World of Warcraft folder and click on file I mentioned above. It will take some time, get some coffee or some cookies, read the news, whatever. DO NOT CLOSE DOWN THE PROGRAM OR MOVE THE FOLDERS during the extract even if it looks done, just wait until it closes by itself.
- When the extraction is done you will have 4 folders having the name: Maps, Vmaps, Buildings and DBC.
- Cut them and paste them in your MaNGOS Server folder.




Step 8
Configuration: You copied three configurations files over to the MaNGOS Server folder before and now we need to make them connect the right way to the databases. First off is the mangosd.conf file.
- Right click on the file and open it with wordpad.
-Inside you will find something like this:

RealmID = 1
DataDir = "."
LogsDir = ""
LoginDatabaseInfo = "127.0.0.1;3306;root;PASSWORD HERE(in this tutorial it's: root);realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;PASSWORD HERE(in this tutorial it's: root);mangos"
CharacterDatabaseInfo = "127.0.0.1;3306;root;PASSWORD HERE(in this tutorial it's: root);characters"
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"

It's really easy actually, there is great descriptions of what every code does and I suggest you read the whole thing through before you move on to the next step. The most important things is that you have written the right password at the right place and that the following for vmaps:

vmap.enableLOS = 1
vmap.enableHeight = 1
vmap.ignoreMapIds = "369"
vmap.ignoreSpellIds = "7720"

-Vmaps has been activated for use.
-Do the same thing for the Scriptdev2.conf and the realmd.conf with the right password and username.
-You could actually start up your server right now and play but it's still "offline" and nobody can join from the outside.

Step 9
Webpage and making the server Online!: Alright, we need a webpage for the players to post whatever they want to, a creation page and some other random stuff so they are happy. In this tutorial we will be using the following webpage:
:: Webow Blizzlike Website by Zynaga, configured by the WebowTeam
- First we need to download it everything.
- Create a folder anywhere and name it "Blizzlike Webpage". Download the website from here: Webwow
- Wait for it to finish the download and unzip/unrar the Webwow3.x.x file. After the process have been done, move all the files to the Blizzlike Webpage folder.
- Copy everything in the Blizzlike Webpage folder and paste it in the htdocs folder inside the XAMPP folder, for example:
C:\xampp\htdocs\
- If you restart Apache and MySQL and then start up your internet again and writes, cPanel you will end up at the new webpage and it's installation, follow the guide and when it asks for an username and password use the following:
username: webow
password: webow
- Hopefully will it be success and you have installed your Webpage for the players!
- Now to make it ONLINE you need to forward some ports if you sit behind a router.
- Log on to your router in the network and open up the following ports(the following ports that are listed are standard ports listed in the .conf files) to your computer:
:: 80 ---> The webpage you've installed (so players can get redirect to your IP in the network and see the webpage where they create their accounts)
:: 8085 ---> MaNGOS world server port (so players can enter your realm)
:: 3724 ---> Realm server port (so players can see the realms in the realmlist)

- Alright, let's see if this works then, you need to know what your IP adress is on the internet so check it out here: My Ip is...
- Let's say, for example, that my internet IP adress is 66.666.666.66, put these numbers in your internet search and you should end up at the blizzlike webpage you've installed Smiley Kinda fussy aye? But it ain't nice having your IP swarming around so to style it up a bit you could redirect it by using;
No-IP - Dynamic DNS, Static DNS for Your Dynamic IP
- The last thing we need to change is some small things in the realmd database, open it up using Navicat and double click on realmlist.
You will see different rows like ID, NAME, ADDRESS etc...
- In the Address it probably says: 127.0.0.1 , change it to your internet IP adress OR the redirect address you got by No-IP - Dynamic DNS, Static DNS for Your Dynamic IP.
- Here you could also change the Name of the realm('s) to whatever you like the realm to have as name.

Step 10
The last touch!: We are here! Finally, after all the hard work.
- Go to your World of Warcraft folder -> Data -> xxXX -> realmlist.wtf , for example:
C:\Program\World of Warcraft\Data\enGB\
- Open the file realmlist.wtf with wordpad and it could say this:

set realmlist eu.logon.worldofwarcraft.com
set patchlist eu.version.worldofwarcraft.com
set realmlistbn ""
set portal eu

Change it to this :::

set realmlist 66.666.666.66
set patchlist 66.666.666.66
set realmlistbn ""
set portal eu

OR

set realmlist *the redirect from www.no-ip.com*
set patchlist *the redirect from www.no-ip.com*
set realmlistbn ""
set portal eu

- If you would like to save but not connect to the EU realms you could just write like this:

###set realmlist eu.logon.worldofwarcraft.com
###set patchlist eu.version.worldofwarcraft.com
###set realmlistbn ""
###set portal eu

set realmlist *the redirect from www.no-ip.com*
set patchlist *the redirect from www.no-ip.com*
set realmlistbn ""
set portal eu

- Save and Close.
- Start up your server by clicking on the mangosd.exe & the realmd.exe file being in your MaNGOS Server folder.
- Wait for it to finish loading.
- Start World of Warcraft and log in with an account you've made on the website or the ones that are already created in the realmd database.
- PLAY!


Regardz - Brucey :P enjoy

[Vragoth]

I would recommend using a mangos repack for now since it seems your new to emulation.

[pocketpc2004]

hey thanks brucey, i will try what your post says and ill get back to you after

[pocketpc2004]

cant download the acid scripts