TeH MaNgOs SuPeR TuT GuIdE ThInG

[gangstagreen]

Installing a World of Warcraft: The Burning Crusade Private Server on Windows Using Mangos

What you're going to need (click the links to download):
-World of Warcraft: The Burning Crusade (updated to version 2.4.3 ONLY)
-MySQL Community Server
-SQLyog Community
-Map Extractor (ad.exe)
-DBC Extrator (MPQE)
-Compiled Mangos Binaries, Click Here to Learn How to Compile Your Own
-Newest UDB Database

Installing the MySQL Community Server
-Run the setup file
-Choose "Typical" setup when asked
-When the installation is finished, you're going to be asked if you want to configure the server; make sure that's checked off

Configuring the MySQL Community Server
-Choose "Standard Configuration" when asked
-Check off "Install as Windows Service" and "Launch MySQL Server Automatically" when asked (the name of the service should be "MySQL")
-Choose "Modify Security Settings" when asked
-Type in a password, make sure it's one you will remember (Note: Default server password is mangos, use that if you are not putting your server online for other players)
-If you plan on having a registration page on another machine, or plan on being able to access the database from another machine other than the one the databases are hosted on, check off "Enable Root Access from Remote Machines"

Installing SQLyog Community
-Run the installation file

Extracting Maps and DBCs
Extracting Maps
-Put the ad.exe file in your WoW installation folder
-Make a folder in your WoW installation folder called "maps"
-Run ad.exe (takes some time)

Extracting DBCs
-Click your Windows Start button, then click "Run"
-Type in "cmd" then press enter
-Change your directory to the enUS/enGB folder in your data folder in your WoW installation directory (type cd [WoW installation path here\data\enUS])
For example (when changing your directory):
Code:

cd C:\Program Files\World of Warcraft\data\enUS

-Type the following in:
Code:

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

-This could take a while depending on your system's speed; normally goes relatively quickly


Setting Up Mangos
-Make a folder somewhere that you will remember, this will be your Mangos folder
-Extract all your binary files into that folder
-Make a new folder called "dbc"
-Cut and paste your maps from your WoW installation folder into your Mangos folder
-Go into your WoW installation folder, then into data, then into enUS/enGB, then into MPQOUT then into DBFilesClient; cut and paste everything in there into the "dbc" folder in your Mangos folder (you can delete the MPQOUT folder afterwards)


Setting Up the Databases
-Run SQLyog
-Click the "New Connection" button at the top of the connection window somewhere
-Name the connection anything you like
-Fill out the fields as indicated below:
MySQL Host Address: This is "127.0.0.1" or "localhost" for playing singleplayer; if you want to put your server online, put this as the IP or DNS of the server that Mangos is being hosted on.
Username: Type in "root".
Password: This is the password you set up when you installed the MySQL Community Server.
Database(s): Leave this blank for now.
-Click "Connect"

Adding Databases
-In the top left-hand side, right-click "root@(IP here)"
-Click "Create Database"
-For the database name type in "realmd"
-Do the same, except for two more databases named "mangos" and "characters"

Once that's done...

-Click "File" in the menu at the top of SQLyog
-Click "New Connection"
-This time in the databases field, type:
Code:

realmd;mangos;characters

-When SQLyog asks if you'd like to save the changes, choose yes
-Click "Connect"
-Now, in the left-hand database list, right-click "realmd" and click "Restore from SQL Dump"
-Click "Browse", and select the realmd.sql in your Mangos -> sql folder
-Click "Execute"

Once that's done...

-Right-click "characters" and select "Restore from SQL Dump"
-Click "Browse", and select the characters.sql in your Mangos -> sql folder
-Click "Execute"

Once that's done...

Important! You have two choices here...
Choice #1:
-If you're experienced and want to make all new content completely from scratch, right-click "mangos", click "Restore from SQL Dump" and select mangos.sql in your Mangos -> sql folder, click "Execute"

Choice #2:
-For everything already made for you, right-click "mangos", select "Restore from SQL Dump" and select your database SQL file, where-ever you put it, click "Execute" (this SQL usually takes a while to execute; UDB database provided at the top of the guide)

Updating Your Databases
Note: This usually fixes several of the console issues when running the server; make sure you do this properly.

When you compile your core pay attention to the revision number!

-Go here
-Click every single link that has the first number bigger than the core (binaries) revision you have; copy and paste the SQL code into the top right textbox in SQLyog, then press the play button in the toolbar at the top (also known as "Execute Query"); this has to be done for every update newer than your core revision!

UDB Update Packs (these should be applied in addition to the Mangos database updates above)
-Go here
-Do the same as you did for the Mangos database updates, except apply all updates that are available there

Configuring

Realm Configuration
-Go into your Mangos folder
-Open realmd.conf in Notepad or another text editor
-Look for the following code (and change it as necessary):
Code:

LoginDatabaseInfo = "[Server IP];3306;root;[SQL password];realmd"

-Save, exit

Mangos Configuration
-Go into your Mangos folder
-Open mangosd.conf in Notepad or another text editor
-Look for the part "DataDir ="
-Make sure it looks like the following:
Code:

Datadir="."

-Look for the following codes (and change them as necessary):
Code:

WorldDatabaseInfo = "[Server IP];3306;root;[SQL password];mangos"
LoginDatabaseInfo = "[Server IP];3306;root;[SQL password];realmd"
CharacterDatabaseInfo = "[Server IP];3306;root;[SQL password];characters"

-Save, exit

Running Your Server
-Go into your WoW installation folder
-Open realmlist.wtf in Notepad or another text editor
-Change the addresses there to your server's IP

-Go into your Mangos folder
-Run mangosd.exe and realmd.exe
-Log-in to WoW

Creating Accounts Without a Registration Page
-Once everything in mangosd.exe has loaded, type-in the following (with some cores there is tons of text flooding the command prompt; not to worry, keep typing anyway, it doesn't matter):

Creating the actual account
Code:

create [username] [password]

Enabling the Burning Crusade for a user
Code:

setbc [username] 1

Changing GM levels
Code:

setgm [username] [anything from 0 to 3, 3 being administrator, 0 being player]

Congratulations! You're now ready to play on your very own private server.

partial credz to "BluPig"

[Tornad0z]

Looks good, but some screenshots wouldn't hurt :-)

[gangstagreen]

tru that, will maybe in the future