[Guide]Making your own MaNGOS WOW server for Windows

[DreaM]

Welcome to Blupig's MaNGOS server creation tutorial (Windows)

 

 

THINGS YOU'RE GOING TO NEED:

-A Windows operating system-

-World of Warcraft version 2.4.2 ONLY-

-A compiled binary of MaNGOS (click here - AHbot for low population servers included)-

-A map extraction tool; ad.exe (click here)-

-A .dbc extraction tool; mpqe.exe (click here) NOTE: Requires .NET framework-

-MySQL Community Server (click here)-

-Any SQL Client (SQLyog will be used in this tut, click here to download it)-

 

 

 

STEP 1

 

 

SQL applications installation

 

 

~@MySQL SERVER INSTALLATION INSTRUCTIONS@~

 

-Open the setup.exe

-Select "typical" as the installation type

-If you're asked to sign up, select "Skip Sign-Up"

-When the installation is done, make sure the "Configure the MySQL server now" is checked, then click "Finish"

-Select "Standard Configuration"

-Check off "Install as Windows Service" and "Launch MySQL server automatically", the server's name should be MySQL

-When asked select "Modify Security Settings"

-Type in a password, and for the username type in "root"

-If you are planning on working on your server from a remote machine, select "Enable root access from remote machines"

-Select execute

 

 

~@SQLyog INSTALLATION INSTRUCTIONS@~

 

-Open the installation program

-Install it where-ever

-When the installation is finished, run SQLyog

-When SQLyog loads up, you'll be asked for:

> MySQL host address: The IP where your server will be run (for a LAN server use "localhost" or "127.0.0.1"

> UserName: Type in "root"

> Password: This is the password you set in your MySQL server installation

> Database(s): Type in "realmd;mangos;characters"

> Leave anything else the way it is

-Click connect; this connects you to your MySQL server

-In the top-left corner, right click the "root@localhost" (the "localhost" could be replaced by your server's IP), select "Create database"

-Make 3 databases; "mangos", "realmd" and "characters"

 

 

STEP 2

 

 

Setting up MaNGOS

 

-Make a folder for your binaries

-Put all of your compiled binaries into that file

 

 

STEP 3

 

 

Extraction of .dbc and map files

 

~@MAP EXTRACTION@~

 

-Put the map extractor (ad.exe) in your WoW installation folder

-Make a new folder inside your WoW folder called "maps"

-Execute ad.exe (this could take a while)

-When it's done, copy the map folder and place it in your MaNGOS folder

-You can delete the map folder inside your WoW folder now if you like

-You should have a good 3300+ maps extracted

 

 

~@.DBC EXTRACTION@~

 

-Make a folder in your MaNGOS folder called "dbc"

-Place the dbc extraction tool (mpqe.exe) in your World of Warcraft >> Data >> enUS folder

-Open DOS (press Start -> "Run", type in "cmd")

-When DOS comes up, type in "cd "#" (# is your World of Warcraft >> Data >> enUS file path, so for example "C:\World of Warcraft\data\enUS")

-Type this in:

mpqe /p locale-enUS.MPQ DBFilesClient\*.dbc

 

-Mpqe will now start extracting dbc files (they will be extracted to World of Warcraft >> Data >> enUS >> MPQOUT >> DBFilesClient)

-It should extract dbc files from the following:

>Patch-enUS-2.mpq

>Patch-enUS.mpq

>Locale-enUS.mpq

-When the extraction is done, copy the dbc files from the folder stated above, and put them in your dbc folder in you MaNGOS folder

-You can now delete the dbc output folder in your WoW folder (you should have 176 dbc files)

 

 

Step 4

 

 

 

Building and extracting vMaps

 

vMap: A vMap is to help out with "Line of Sight" issues.

 

 

-Find the batch file named "makevmaps_SIMPLE.bat" (MaNGOS >> Vmap) (if you don't have any vmap files, get them here)

-Open that batch file; this extraction takes a hell of a long time

-When the extraction is done, move MaNGOS >> Vmap >> Vmaps folder into your main MaNGOS folder (you should then have MaNGOS >> Vmaps)

 

Step 5

 

 

Installing the databases

 

~@REALMD DATABASE@~

 

-Open SQLyog and connect to your MySQL server

-In the big box to the left, right click on "realmd" and select "Restore from SQL dump"

-Browse and select "realmd.sql" in your MaNGOS >> sql folder

-Click the execute button

-Close the dialog when it's done

 

 

~@MANGOS DATABASE@~

 

-Right click "mangos" in the big box to the left (over or under "realmd" from the step above)

-Select "Restore from SQL dump"

IMPORTANT:

>If you're interested in making your own database from scratch, browse and execute "mangos.sql" in your MaNGOS >> sql folder

> Download the latest full UnifiedDB database (click here, 2.4.1 database released), then do the same as stated above

 

STEP 6

 

Configuring MaNGOS

 

~@SETTING UP YOUR REALM@~

 

 

-Connect to your MySQL server

-Click the "+" sign beside "realmd" in the big box on the left

-Select "realmlist"

-Below the big text box to the right of the application (at the top), click the "table data" tab

-Change the "name" property to whatever you want your realm to be called (it CAN'T be called MaNGOS)

-Change the "address" property to your server's IP (for testing keep it on "localhost" or "127.0.0.1")

-Click the image of the floppy disk above the spreadsheet you're working in, that's the "save" button

 

 

~@CONFIGURING THE REALMD CONFIGURATION FILE@~

 

-Open "realmd.conf" in your MaNGOS folder in notepad

-Find "LoginDatabaseInfo =", and change it to "LoginDatabaseInfo = "[server IP];3306;root;[password];realmd"

-Save and close "realmd.conf"

 

 

~@CONFIGURING THE MANGOS CONFIGURATION FILE@~

 

 

-Open "mangosd.conf" in your MaNGOS folder in notepad

-Find these lines and change them to what is shown:

>Datadir = "."

>WorldDatabaseInfo = "[server IP];3306;root;[password];mangos"

>LoginDatabaseInfo = "[server IP];3306;root;[password];realmd"

>CharacterDatabaseInfo = "[server IP];3306;root;[password];characters"

-Save and close "mangosd.conf"

 

 

STEP 7

 

 

Updating your database and MaNGOS to the current version

 

~@UPDATING MANGOS@~

-Click here for all the listed MaNGOS updates

-To update MaNGOS, connect to your MySQL server, select "root@localhost" and in the big textbox in the top-right of SQLyog, copy all updates after 5625(the binary revision I gave you is revision 5633, but just to be clear of errors update it from 5625)

 

 

~@UPDATING YOUR DATABASE@~"

 

-Do the same for updating the database as you did for updating MaNGOS

 

STEP 8

 

 

-Run "realmd.exe" and "mangosd.exe" in your MaNGOS folder, keep them up and play WoW!

-There are 3 premade accounts that come in the database;

>User: "Administrator" Pass: "Administrator" (administrative powers)

>User: "Gamemaster" Pass: "Gamemaster" (GM powers)

>User: "Player" Pass: "Player" (no powers)

[norka25]

thx a lot , everything is clear expalined

[zEx_Drax]

Tnx for this HaCkz0r,

Good Job.

[xXDeveloperXx]

good job a wotlk guide will be good too...

[DeaThLine]

Thx man. The Guide is easy to understand it and that helps