- A functional wow private server using Mangos
This is the most important thing, if you haven’t configured your wow server properly, please check how to configure mangos first

- WoW Model Viewer – http://code.google.com/p/wowmodelviewer/
This is needed in order to get WoW Display ID. And in this case to get the display / model id for specific creature

As a side note, actually you can also get the display ID of creatures you want by looking through UDB database which we’ve installed previously. But because i never play on official server, i know nothing about any cool creatures that can be found inside WoW World so looking through Model Viewer seems to be the best choice for me because i can see how the creature looks :P

And make sure that mangosd.exe process isn’t running before starting this process

All you have to do is just open WOW Model Viewer and then choose View -> View NPC to see NPC Model with it’s Display ID (Display ID is listed as the second value) and you’ll get the creature display id

In this example we’re going to create a new custom vendor + repair npc (4224) for mangos using The Lich King Model (28672) with creature id 100001 plus 100000 health called Reaper-X with subname www.reaper-x.com (obviously you’re free to change the npc name to your liking)

Anyway, now we need to open command prompt as usual, then type this

mysql -uroot -p
# switch database to mangos
use mangos
# inserting new rows for creature on mangos
INSERT INTO creature_template (entry, modelid_A, modelid_H, name, subname, minhealth, maxhealth, npcflag) VALUES
( 100001, 28672, 28672, 'Reaper-X', 'www.reaper-x.com', 100000, 100000, 4224 );
# checking whether the previous value has been inserted to database
SELECT entry, name, subname from creature_template where entry = 100001;
# quit mysql
quit

1. Delete everything inside your WoW cache directory (Your WoW Installation Directory\Cache)

2. Now start mangosd.exe and then open your wow client, and finally log on to your server

3. Choose the best position on where your new custom npc should be placed (the new custom npc will be added to your current character position in WoW, and also facing the same position as your character so make sure to position your character properly)

4. type .npc add 100001

5. And voila! you’re done adding your new custom vendor npc

1. Click on the npc

2. Type .lookup item itemname where itemname should be replaced with whatever item you want your new custom vendor sell (in this example i choose Shadowmourne)

3. Type .npc additem #itemid where itemid should be replaced with previous value displayed on the previous lookup (in this example i type .npc additem 49623 to add Shadowmourne to the npc)

4. You’re done

If you asked me, on where did i get the NPCFlag value from, well the answer is you can see the NPCFlag by looking at the source code of Mangos (unit.h). And to make things easier for you, here’s an example of where i get that 4224 value (Vendor NPC + Repairer)

Mangos NPCFlag

enum NPCFlags
{
UNIT_NPC_FLAG_NONE = 0x00000000,
UNIT_NPC_FLAG_GOSSIP = 0x00000001, // 100%
UNIT_NPC_FLAG_QUESTGIVER = 0x00000002, // guessed, probably ok
UNIT_NPC_FLAG_UNK1 = 0x00000004,
UNIT_NPC_FLAG_UNK2 = 0x00000008,
UNIT_NPC_FLAG_TRAINER = 0x00000010, // 100%
UNIT_NPC_FLAG_TRAINER_CLASS = 0x00000020, // 100%
UNIT_NPC_FLAG_TRAINER_PROFESSION = 0x00000040, // 100%
UNIT_NPC_FLAG_VENDOR = 0x00000080, // 100%
UNIT_NPC_FLAG_VENDOR_AMMO = 0x00000100, // 100%, general goods vendor
UNIT_NPC_FLAG_VENDOR_FOOD = 0x00000200, // 100%
UNIT_NPC_FLAG_VENDOR_POISON = 0x00000400, // guessed
UNIT_NPC_FLAG_VENDOR_REAGENT = 0x00000800, // 100%
UNIT_NPC_FLAG_REPAIR = 0x00001000, // 100%
UNIT_NPC_FLAG_FLIGHTMASTER = 0x00002000, // 100%
UNIT_NPC_FLAG_SPIRITHEALER = 0x00004000, // guessed
UNIT_NPC_FLAG_SPIRITGUIDE = 0x00008000, // guessed
UNIT_NPC_FLAG_INNKEEPER = 0x00010000, // 100%
UNIT_NPC_FLAG_BANKER = 0x00020000, // 100%
UNIT_NPC_FLAG_PETITIONER = 0x00040000, // 100% 0xC0000 = guild petitions, 0x40000 = arena team petitions
UNIT_NPC_FLAG_TABARDDESIGNER = 0x00080000, // 100%
UNIT_NPC_FLAG_BATTLEMASTER = 0x00100000, // 100%
UNIT_NPC_FLAG_AUCTIONEER = 0x00200000, // 100%
UNIT_NPC_FLAG_STABLEMASTER = 0x00400000, // 100%
UNIT_NPC_FLAG_GUILD_BANKER = 0x00800000, // cause client to send 997 opcode
UNIT_NPC_FLAG_SPELLCLICK = 0x01000000, // cause client to send 1015 opcode (spell click), dynamic, set at loading and don't must be set in DB
UNIT_NPC_FLAG_GUARD = 0x10000000 // custom flag for guards
};

As you can see from the above code we’re using this value to create our custom vendor + repair npc

UNIT_NPC_FLAG_VENDOR = 0x00000080
UNIT_NPC_FLAG_REPAIR = 0x00001000

According to the above value, if we count that two value we get 1080 as the result, and you might be wondering on where does the 4224 came from? the answer is, because the value displayed as hexadecimal, we need to convert it to decimal first and 1080 (80+1000) hexadecimal equal to 4224 decimal

World of Warcraft Client version 3.3.3 (11723)
This guide is tested on WoW 3.3.3a client, so if you’re using newer version or older version of WoW, then it may / may not work for you

MySQL
If you currently don’t have MySQL installed on your computer, please follow my previous guide on how to install MySQL on Windows XP or how to install MySQL on Windows Vista

Compiled Mangos Binary / Executable
Check my previous mangos compile guide because without the binary / executable itself, you won’t be able to run your own WoW private server. And beside this guide is based on my mangos compilation guide. So if you follow my previous guide completely (including the directory structure) then it’ll make thing easier for you

TortoiseSVN
This is needed in order to get the database for Mangos, as for the installation process i’ve described it on the compile guide. So if you follow the previous compile guide then you don’t need to reinstall it again

UDB and ACID Database
UDB and ACID is required so you can see NPC and doing quest in the WoW World, see below for instruction to get UDB and ACID

Downloading UDB and ACID

The first step is obviously downloading the required database in order for your WoW server to function as it should be, to do this we’re going to use TortoiseSVN to fetch the required files

1. Open Windows Explorer and right click on an empty space then choose SVN Checkout and type

http://unifieddb.svn.sourceforge.net/svnroot/unifieddb/trunk

as the repository address

2. After finished with the above process, wow we need to download SD2 ACID. Type

http://sd2-acid.svn.sourceforge.net/svnroot/sd2-acid

as the svn repository url

And now we’re done with the requirements

Creating Directory Structure

Create new folder in C:\ named WoW and inside the WoW directory you just created, create two directories named data and mangos. So it’ll look like this

Although this step can be considered non essential, but if you created a directory structure, it can make upgrading Mangos and the required files such as DBC and Maps much easier later and beside in this guide i’m using the directory structure specified here so other than that it can make things easier for you to follow this guide

Extracting DBC and Maps

1. Copy the ad.exe from contrib directory inside your mangos compile directory (on my compile example, the mangos compile directory is C:\Mangos-git) into your WoW installation directory. Then run the ad.exe and when it’s done you’ll see two new folders created named DBC and Maps

2. After finished with the extraction process, now you need to move the DBC and Maps directory from your WoW installation directory to C:\WoW\data

Copying Mangos Config Files

Remember the directory structure we’ve created earlier? if yes, then that’s good because in this example i’m going to use the directory structure created earlier, if you choose to skip the creating directory structure part then make sure to adjust everything accordingly

1. Now you’ll need to copy the mangosd.conf.in, realmd.conf.in, scriptdev2.conf.in from your Mangos compile directory (use the search function as shown at below image) to C:\WoW\Mangos

2. And then copy everything from the Bin directory inside your mangos compile directory into C:\WoW\Mangos and then rename mangosd.conf.in, realmd.conf.in and scriptdev2.conf.in into mangosd.conf, realmd.conf, scriptdev2.conf. So in the end, you have these files (see below image) inside C:\WoW\Mangos directory

Setting Mangos Datadir

Go to directory C:\WoW\Mangos and open mangosd.conf and search for

DataDir = "."

and replace it with

DataDir = "C:\WoW\data"

Installing Mangos Databases

Before starting in this process, please note that the directory structure used is based on the mangos compile guide so if you use different path, make sure to adjust them accordingly. Also if you get "mysql is not recognized as an internal or external command, operable program or batch file." that means you didn’t set up MySQL to be installed to your Environment Variables PATH. See the MySQL Installation Guide on my previous guide for more info

1. Open Command prompt, and then type

cd /d c:\mangos-git\sql

then followed by

mysql -uroot -p -v < create_mysql.sql

This will create mangos database structure and also create the necessary user (because using root is dangerous)

2. Then type

mysql -uroot -p -v -D realmd < realmd.sql

This will import the necessary realmd tables into the realmd database

3. Finally type (but don’t close the command prompt yet)

mysql -uroot -p -v -D characters < characters.sql

This will import the necessary tables into the characters database

Installing UDB (Unified Database)

1. Remember the part about downloading database? if yes, then go to the directory where you download the UDB database, and then extract the UDB_0.12.0_mangos_9582_SD2_1639.zip inside the Full DB directory of your UnifiedDatabase directory so it’ll look like this

2. And now we’re going to import the database (it may take a while depending on how fast your computer is). From the command prompt window from before, type (don’t close the command prompt window yet again)

cd /d C:\unifieddb\Full_DB

mysql -uroot -p -v -D mangos < UDB_0.12.0_mangos_9582_SD2_1639.sql

Updating Mangos Database

Because the Full UDB database is designed for Mangos Revision 9582, and at the time i wrote this my current Mangos compile is at Revision 9771, so of course we need to perform the database upgrade first or else Mangos will refuse to run

Tips: look at the UDB filename it state mangos 9582 which means that every mangos core update before and equal to Mangos 9582 has been applied and so we need to apply sql update that is released after revision 9582 as for checking your mangos revision, just run mangosd.exe or realmd.exe and it’ll display your Mangos revision

So because the current UDB full release is at 9582, we need to look at any sql\updates file in your mangos compile directory that is above 9582 revision and then manually import each sql file one by one

For example right after 9582 in sql\updates\0.16 in mangos compile directory there is a sql file named 9589_01_mangos_creature_template.sql, so we need to import that one first and you can do this by simply typing:

mysql -uroot -p -v -D mangos < 9589_01_mangos_creature_template.sql

and right after 9589_01_mangos_creature_template.sql there’s another sql update filename called 9590_01_mangos_db_script_string.sql, so then you need to type

mysql -uroot -p -v -D mangos < 9590_01_mangos_db_script_string.sql

and so on, basically you’ll need to locate each sql update file that contain mangos in the filename (ignore the realmd and characters), and then manually import each sql file accordingly

and in the future, in case you want to upgrade your mangos installation, you can do so by executing each sql file including the realmd. But why we didn’t import the characters and realmd sql file in this guide? the answer is simple, because we’re doing a fresh installation the realmd database and characters database already contain the latest update, but of course in the future the realmd and characters database might be different because there’ll be another update, so you’ll have to import all sql files one by one

For example, 9767_03_characters_characters.sql. Means that it should be imported to characters database and to import it you need to type

mysql -uroot -p -v -D characters < 9767_03_characters_characters.sql

And for realmd update, the sql filename 9748_01_realmd_realmlist.sql and to import it you need to type

mysql -uroot -p -v -D realmd < 9748_01_realmd_realmlist.sql

That’s it basically, this may be confusing at the beginning but once you get used to it, it’ll be easy for you

Updating UDB

Now we need to update our UDB database too (because there’s an update at the time i wrote this), here’s how to do this

cd /d c:\unifieddb\Updated\0.12.0_additions

mysql -uroot -p -v -D mangos < 389_updatepack_mangos.sql

mysql -uroot -p -v -D mangos < 390_updatepack_mangos.sql

Tips: if there’s an update for UDB in the future all you have to do is just import the correct update accordingly

Installing Scriptdev2

From the command prompt type

cd /d c:\scriptdev2\sql

mysql -uroot -p -v < scriptdev2_create_database.sql

mysql -uroot -p -v -D scriptdev2 < scriptdev2_create_structure_mysql.sql

mysql -uroot -p -v -D scriptdev2 < scriptdev2_script_full.sql

mysql -uroot -p -v -D mangos < mangos_scriptname_full.sql

Installing ACID Database

From the command prompt again type

cd /d c:\sd2-acid\trunk\wotlk\3.0.4

mysql -uroot -p -v -D mangos < 3.0.4_acid.sql

Editing realmlist.wtf

The next step would be editing your realmlist.wtf file located inside your wow installation directory\data\enUS (or your WoW Region like enGB, etc) and insert this

set realmlist 127.0.0.1

replacing everything inside the realmlist.wtf (make sure to create backup)

Creating GM Account

Now before getting into the World of Warcraft world, you need to create an account first for you to use, and to do that first you need to make sure realmd and mangosd process is running and then in the mangosd window type

account create username password

Where username is whatever username you want, and password is whatever you want for the account password. And then type

account set addon username 2

To set the expansion pack to Wrath of the Lich King (0 = Classic WoW, 1 = The Burning Crusade, 2 = Wrath of the Lich King) for the username you choose. And finally type

account set gmlevel username 3

To give the highest GM (Game Master) level to the username you choose, so he/she can do anything he/she want from wreaking havoc to causing apocalypse

in the example above, i create a new gm account with reaper as username and ilovekeikokitagawa as the password (p.s don’t take the password seriously) :P

That’s it you’re done … if i forgot something, don’t be shy just let me know so i can fix it immediately. And if you got any questions or have a request for the next article, feel free to post your comment :)

And, if you want to create custom npc on your mangos server, please check how to create custom npc guide

And, if you feel overwhelmed by this (even the fast method isn’t working for you) i can help you directly by using Teamviewer and don’t worry it’s free (but of course i also accept donation to pay for this monthly server bill). If you want me to help you directly make sure to contact me first by using the contact form

Optional: Setting up Public WoW Server

If you want to host your own wow private server from home, then there’s one small change you need to apply so other people can connect to your wow server, and here’s the guide

First of all you need to open the command prompt and type

mysql -uroot -p

now type

use realmd;

and finally type

select * from realmlist;

and you’ll see the realm address is set to 127.0.0.1 by default, but because we’re going to allow other people to connect to our server, we need to change the ip address into your Public IP Address. The simple way to know your public ip address is by visiting whatismyip.com and make a note of your IP Address

Once we’ve obtained the public ip address the next step would be changing the ip address in the realmlist table, to do this just type

update realmlist set address = 'your public ip address';

then to make sure the change has been applied successfully, we need to type

select * from realmlist;

If you’ve changed it successfully then you’ll see your new public ip address instead of 127.0.0.1

The next step is restart realmd.exe, and mangosd.exe process in order for the change to take effect

Now after finished with the above process, you’ll need to open your realmlist.wtf and change the set realmlist into your public IP Address …. and tell your client to use the your public ip address in their realmlist.wtf file and you’re all set ;)

p.s if you’re behind router, make sure to forward port 3724 and 8085 (default port used by WoW) on your router

To those with Dynamic IP Address

If your provider gave you a dynamic ip address, then the solution is to get yourself a dyndns address first, and to do this you need to go to www.dyndns.com and register an account there, and i assume that your wow server is called mycoolwowserver.dyndns.com

Then after finished with the registration process, all you have to do is just follow the setting up public wow server and replace public ip address with your dyndns.com address

For example at this part:

update realmlist set address = 'your public ip address';

You need to replace the command with

update realmlist set address = 'mycoolwowserver.dyndns.com';

And then continue with the rest of setting up public wow server part. And after finished with all public wow server part, now you need to open hosts file located in Windows\System32\drivers\etc (C:\Windows\System32\drivers\etc\hosts), and then add this at the bottom of the file

127.0.0.1 mycoolwowserver.dyndns.com

And you’re done configuring your public wow server :)

If you feel overwhelmed by everything listed in this guide then feel free to use this option, but make sure you have mysql installed as listed on mysql guide for vista (for vista users) and mysql guide for xp for windows xp users

1. Extract the file into C:\
2. Copy ad.exe from tools directory into your WoW installation directory and let ad.exe finished with extracting DBC and MAPS and then move the DBC and MAPS directory to C:\WoW\data
3. Edit realmlist.wtf in your WoW installation directory (it’s located in Data\enUS or enGB or your WoW region) and set realmlist 127.0.0.1

4. Run import.bat and when prompted for password, enter your mysql root password
5. Start realmd.exe and mangosd.exe
6. Create account as described in the Final adjustment part … and play

Enjoy, consider this as a supplement for this extremely long guide and oh make sure your WoW client is version 3.3.3 and it’ll create a fresh installation so if you previously have used mangos and don’t want to lose your precious data make sure to create backup first

Download Supplement from Megaupload | Download Supplement from Rapidshare