All red text are important.
All green text refer to Forrest's All-in-one Repack directories.
All orange text refer to your computer's directories.
All light-blue text refer to folders.
All yellow text refer to files. :wave:
All pink texts refer to sections.
This guide is correct as of March 24, 2008 6):
This guide was simplified on March 25, 2008 as I realized that more and more people were approaching me for help because this guide was too complicated.
This is a step-by-step guide compiled by ME aka Forrest that aims to be simple and noob-friendly. I will no longer be providing first-hand tutorials on creating servers. However, you can still add me on MSN: [email protected] (I'm asian and probably live in a 12 hour timezone difference from you, meaning my day = your night, don't b*tch about it if I'm not online) to report any discrepancies within this guide. Pleas for help to make your server will not be entertained. You will be deleted & blocked if you do.
WARNING!! Emulators / private servers are against Blizzard's EULA. If you have an active account with WoW, you agree to this every time you logon after a patch. Your account can be banned for playing on a private server. You might want to weigh whether losing access to your characters is worth it. Running (making) a emulator / private server is actually illegal. Blizzard is one of the only game companies to win court cases against the operators of private servers.
Q u o t e: Only Blizzard or its licensees have the right to host the Game. You may not host or provide matchmaking services for the Game, or intercept, emulate or redirect the proprietary communication protocols used by Blizzard in connection with the Program, regardless of the method used to do so. Such prohibited methods may include, but are not limited to, protocol emulation, reverse engineering, modifying the Program, adding unauthorized components to the Program, or using a packet sniffer while the Program is running.
Q u o t e: (iv) facilitate, create or maintain any unauthorized connection to the Game or the Service, including without limitation any connection to any unauthorized server that emulates, or attempts to emulate, the Service. All connections to the Game and/or the Service, whether created by the Game Client or by other tools and utilities, may only be made through methods and means expressly approved by Blizzard. Under no circumstances may you connect, or create tools that allow you or others to connect, to the Game's proprietary interface other than those expressly provided by Blizzard for public use.
twocents YOU HAVE BEEN WARNED. IF YOU UNDERSTAND THE RISKS INVOLVED, PROCEED. IF NOT, DO NOT READ FURTHER. twocents
NOW ON TO THE MAKING OF ONE!
Credits
ALL server related guide content within is credited to z-vap, Spuddlethud, elegos87 from Mangos Community Forums. ALL ScriptDev2 related guide content within is credited to Ntsc from ScriptDev2 Community Forums
The setup for your Mangos Server will ONLY require the following software:
1. World of Warcraft 2.3.3 ONLY with or without BC installed (Doesn't matter as you server supports both BC and non-BC WoW) (Buy it!)
2. Forrest's All-in-one Pack v 1.0 downloaded @ Forrest's All-in-one Pack.rar and/or at Hicara's link RapidShare: 1-Click Webhosting (I will be updating this periodically so that you can check back to download the latest version)
!! Mangos strives to create the most blizz-like environment server for the MMORPG World of Warcraft for teaching & experimenting purposes, nothing more. If you're looking for custom content such as those found within funservers, this is not the guide for you. My challenge to you is to try Mangos out for a change, you'll find that Mangos is not just a private server, Mangos is a teacher of programming & scripting.
If you're looking for scripting and connection issues, check out my other guides:
1. Configuring Wireless/wired routers with or w/o static IP addresses @ http://www.mmowned.com/forums/mangos...tml#post675131
2. Scripting with UDB, generating your own custom content (soon to come)
3. GM commands within Mangos and how to use them @
http://www.mmowned.com/forums/mangos...tml#post563507
This Guide will be taught in 2 main phases:
1. Setting up your server & extracting your maps and dbc files
2. Configuring your server stats
I. Setting up your server & extracting your maps and dbc files
1. After download, Unzip my all-in-one pack in your C drive. (Or anywhere you prefer, however, this guide will follow the assumption that you unzipped my pack into C drive by default)(C:\Forrest's All-in-one Pack)
2. Install MySQL
* Launch the MySQL installation application from (Forrest's All-in-one Pack\Installers\MySQLSetup.exe)
* When prompted, select "Typical" for setup type.
* When prompted, select "Skip Sign-Up".
* When install is complete you will be given the option to "Configure the MySQL Server Now". Make sure this is checked, then press finish.
* When prompted, select "Standard Configuration"
* When prompted, place a check in "Install as Windows Service" and "Launch the MySQL Server Automatically". Service name should be "MySQL"
* When prompted select "Modify Security Settings". In the two empty dialog boxes, type in the password you wish to use for the MySQL root (aka Administrator) account. This is the most important account on MySQL and has full access to all databases and functionality. It's recommended you use a very strong password to prevent access to your MySQL server instance. (If you plan on administering your MySQL instance from a remote machine, then select "Enable root access from remote machines". If you don't know if you need this, then do not select it.)
* Select execute to apply all of your configuration settings.
3. Install SQLyog
* Launch SQLyog installation application. (Forrest's All-in-one Pack\Installers\SQLyog604.exe)
* Accept license agreement when prompted.
* Install in default location when prompted. (You can install in an alternate directory if you prefer.)
* When installation is complete, place a check in the box for "Run SQLyog 6.04".
* When SQLyog launches you will be prompted to fill in the following:
* MySQL host address: localhost
* UserName: root
* Password: [Type the password you selected in your MySQL installation for the root account from step 2 above].
* Database(s): realmd;characters;mangos;scriptdev2
* Leave other options to defaults.
* Press Connect. This will connect you to your MySQL instance.
* Once the interface opens, right-click on root@localhost in the left pane, and select "Create Database".
* When prompted for a database name type "mangos". * Rinse and Repeat the prior two steps above and type "realmd" for the second database. Once again for "characters". Once again for "scriptdev2".
4. Extract map files
* Copy ad.exe (Forrest's All-in-one Pack\Map Extractor\ad.exe) into the client's root directory. ("C:\Program Files\World of Warcraft")(default)
* Create a folder called 'maps' inside. ("C:\Program Files\World of Warcraft\maps")(default)
* Launch ad.exe. This will begin the extraction of map files. (This can take a long time depending on your system.)
* When ad.exe has finished, CUT the folder "C:\Program Files\World of Warcraft\maps" and PASTE it in your Forrest's All-in-one Pack folder. ("C:\Forrest's All-in-one Pack"). So you should now have a "C:\Forrest's All-in-one Pack\maps" folder containing numerous (3400+) .map files.
5. Extract *.dbc files
* Create a folder for your .dbc files titled "dbc" in the Forrest's All-in-one Pack directory. ("C:\Forrest's All-in-one Pack\dbc")
* Copy all files within the DBC Extrator folder in Forrest's All-in-one Pack directory to your World of Warcraft enUS/enGB directory (default)("C:\Program Files\World of Warcraft\Data\enUS") OR ("C:\Program Files\World of Warcraft\Data\enGB")
* Depending on which version you're running on (enUS or enGB), RUN EITHER enUS.cmd OR enGB.cmd (NOTE: NEVER RUN BOTH)
* This will extract all *.dbc files into a folder called MPQOUT (default) ("C:\Program Files\World of Warcraft\data\MPQOUT")
* When mpqe.exe has completed, copy the content of all of the .dbc files from the output directory listed in the previous step to your Forrest's All-in-one Pack dbc folder. ("C:\Forrest's All-in-one Pack\dbc") You should have 176 .dbc files. You may now delete the client output directory folder ("C:\Program Files\World of Warcraft\data\MPQOUT") if you wish.
6. Build the Vmap Files
* Find the batch file "makevmaps_SIMPLE.bat" in Forrest's All-in-one Pack\Vmap.
* Double Click. Depending on your system, this step may take quite some time.
* Alternately you could run "make vmaps.bat" instead, but additional prompts will come up in the process.
* You may need to rebuild these files more than once. Pay attention to future release notes.
* CUT the vmaps folder ("C:\Forrest's All-in-one Pack\Vmap\vmaps") and PASTE into the root of the Forrest's All-in-one Pack ("C:\Forrest's All-in-one Pack")
7. (UNITED DATABASE) UDB installation
Realmd Database
* Connect to your MySQL server through SQLyog. (As learned in Step 3)
* In the left pane, right-click on realmd and select "Restore from SQL Dump". (Note: some older versions may read "Import Batch File".)
* Browse to the "realmd.sq" file in your Forrest's All-in-one Pack folder. ("Forrest's All-in-one Pack\SQL\BasicReqs\realmd.sql")
* Execute. This should only take a moment and you will get a message that it's complete.
* Close Dialog.
Character Database
* In the left pane, right-click on characters and select "Restore from SQL Dump". (Note: some older versions may read "Import Batch File".)
* Browse to the "characters.sq" file in your Forrest's All-in-one Pack SQL folder. ("Forrest's All-in-one Pack\SQL\BasicReqs\characters.sql")
* Execute. This should only take a moment and you will get a message that it's complete.
* Close Dialog.
ScriptDev2 Database
* In the left pane, right-click on scriptdev2 and select "Restore from SQL Dump". (Note: some older versions may read "Import Batch File".)
* Browse to the "scriptdev2_structure.sql" file in your Forrest's All-in-one Pack SQL folder. ("Forrest's All-in-one Pack\SQL\BasicReqs\scriptdev2_structure.sql")
* Execute. This should only take a moment and you will get a message that it's complete.
* Browse to the "EAI_0.0.3_293.sql" file in your Forrest's All-in-one Pack SQL folder. ("Forrest's All-in-one Pack\SQL\UDB\EAI_0.0.3_293.sql")
* Execute. This should only take a moment and you will get a message that it's complete.
* Close Dialog.
Mangos Database
* In the left pane, right-click on mangos and select "Restore from SQL Dump". (Note: some older versions may read "Import Batch File".)
* Browse to the "UDB_0.9.2_Core_5242_SD2_259.sql" file in your Forrest's All-in-one Pack SQL folder. ("Forrest's All-in-one Pack\SQL\UDB\UDB_0.9.2_Core_5242_SD2_259.sql")
* Execute. This will take quite some time depending on your system. At points it may seem like it's hung. LET IT RUN!
* At this point of time, you need to restore all changesets/updates. In this case, your database is configured for Mangos revision 5242 as stated in the "UDB_0.9.2_Core_5242_SD2_259.sql" file, however, you're running a revision of 5483, hence, it won't work! But first......
* Browse to the "mangos_full_scripts.sql" file in your Forrest's All-in-one Pack SQL folder. ("Forrest's All-in-one Pack\SQL\BasicReqs\mangos_full_scripts.sql")
* Execute.
* Browse to the "mangos_additional_req.sql" file in your Forrest's All-in-one Pack SQL folder. ("Forrest's All-in-one Pack\SQL\BasicReqs\mangos_additional_req.sql")
* Execute.
* Finally, to get it working, restore the following .sql dump files to your mangos database from your "Forrest's All-in-one Pack\SQL\" folder:
* 5243_mangos_spell_affect.sql
* 5249_mangos_spell_learn_skill.sql
* 5254_mangos_spell_affect.sql
* 5254_mangos_spell_proc_event.sql
* 5258_characters_character.sql
* 5265_mangos_spell_proc_event.sql
* 5269_mangos_uptime.sql
* 5270_mangos_gameobject_scripts.sql
* 5272_mangos_mangos_string.sql
* 5286_characters_character_pet.sql
* 5292_mangos_spell_proc_event.sql
* 5295_mangos_creature_template.sql
* 5297_characters.sql
* 5297_mangos.sql
* 5297_realmd_account.sql
* 5302_mangos_player_levelstats.sql
* 5311_mangos_spell_affect.sql
* 5326_mangos_spell_affect.sql
* 5335_mangos_mangos_string.sql
* 5343_mangos_spell_proc_event.sql
* 5347_mangos_spell_affect.sql
* 5350_mangos_spell_affect.sql
* 5351_mangos_spell_proc_event.sql
* 5363_mangos_creature_template.sql
* 5366_mangos_spell_proc_event.sql
* 5367_mangos_spell_affect.sql
* 5370_mangos_spell_affect.sql
* 5374_mangos_spell_affect.sql
* 5378_mangos_spell_proc_event.sql
* 5379_mangos_spell_proc_event.sql
* 5402_mangos_spell_proc_event.sql
* 5408_characters_mail_items.sql
* 5411_mangos_spell_affect.sql
* 5419_mangos_spell_affect.sql
* 5420_characters_mail_items.sql
* 5422_mangos_spell_proc_event.sql
* 5441_characters_petition_petition_sign.sql
* 5443_mangos_item_template.sql
* 5445_mangos_spell_affect.sql
* 5446_mangos_creature_template.sql
* 5451_characters_petition_petition_sign.sql
* 5457_realmd_account.sql
* 5460_mangos_spell_proc_event.sql
* 5462_mangos_spell_affect.sql
* 5463_mangos_command.sql
* 5466_mangos_spell_affect.sql
NOTE: Pay attention to the names of these changesets, 5462_mangos_spell_affect.sql is for restoring to the MANGOS database but a 5457_realmd_account.sql is for restoring to the REALMD database and 5451_characters_petition_petition_sign.sql is for restoring to the CHARACTERS database, NOT the mangos database. Also, pay attention to my future packs, ALWAYS remember to add all changesets before adding any update packs.
* Now restore 340_updatepack_mangos.sql & 341_updatepack_mangos.sql & 342_updatepack_mangos.sql & 343_updatepack_mangos.sql from your "Forrest's All-in-one Pack\SQL\UDB" folder to your MANGOS database.
* Close Dialog.* When these are complete you will have all the data you need to run MaNGOS with United Database.
II. Configuring Your Server Stats
1. Setup your realm
* Connect to your MySQL server. (Follow points 5 & 6 from Step 3 of "I.Setting up your server and extracting your maps and dbc files")
* Open the realmd branch in the left pane and select "realmlist".
* At the bottom of SQLyog click on the "Table Data" tab.
* Change the "name" field to your preferred realm name. It CANNOT be the default "MaNGOS".
* For now leave the address to "localhost" or "127.0.0.1". (This will be the same address that your clients must set in their realmlist.wtf files to connect.)
* Select the "Save Changes" button.
2. Configure realmd.conf
* Open realmd.conf in notepad. It should be in your root server directory ("Forrest's All-in-one Pack\realmd.conf").
* Find the command * Change it to
LoginDatabaseInfo = "127.0.0.1;3306;root;[password];realmd"
(for "[password]", fill in your password from point 5 of Step 3 of "I.Setting up your server and extracting your maps and dbc files")
* Save and close file.
3. Configure mangosd.conf
* Open mangosd.conf in notepad. It should be in your root server directory ("Forrest's All-in-one Pack\mangosd.conf"). Find these lines and set as shown:
*
WorldDatabaseInfo = "127.0.0.1;3306;root;[password];mangos"
(for "[password]", fill in your password from point 5 of Step 3 of "I.Setting up your server and extracting your maps and dbc files")
*
LoginDatabaseInfo = "127.0.0.1;3306;root;[password];realmd"
(for "[password]", fill in your password from point 5 of Step 3 of "I.Setting up your server and extracting your maps and dbc files")
*
CharacterDatabaseInfo = "127.0.0.1;3306;root;[password];characters"
(for "[password]", fill in your password from point 5 of Step 3 of "I.Setting up your server and extracting your maps and dbc files")
* Take some time to look through your mangosd.conf and realmd.conf files, they provide all the settings of your server.
* Save and close file.
4. Configure scriptdev2.conf
* Open scriptdev2.conf in notepad. It should be in your root server directory ("Forrest's All-in-one Pack\scriptdev2.conf").
*
ScriptDev2DatabaseInfo = "127.0.0.1;3306;root;[password];scriptdev2"
(for "[password]", fill in your password from point 5 of Step 3 of "I.Setting up your server and extracting your maps and dbc files")
* Save and close file.
CONGRATULATIONS! MANGOS IS NOW READY TO RUN!
* Launch realmd.exe then mangosd.exe. When the server is ready you will hear a system beep. Clients can then login. Make sure you utilize the mangosd server commands to create and delete accounts. Also, turning on/off of TBC can be done from here. The commands are very simple and user friendly. Here is an example of a GM Lvl 3 account creation and deletion, assuming user is running Burning Crusade:
Creates account Gilgamesh with password 123456
Sets Gilgamesh account to Burning Crusade account. No need to use this command if BC not installed.
Sets Gilgamesh account as a GM Level 3 account, granting all powers.
Deletes account Gilgamesh and all affiliated characters.
* All clients that wish to connect to your server must modify their realmlist.wtf file in their client directory (C:\Program Files\World of Warcraft)(default) to match your realm information as you specified in SQL.
For example: "set realmlist 127.0.0.1". In this case, 127.0.0.1 is a loopback address to your own machine, hence, only you can connect to your server.
* There are 4 basic accounts already provided when you start. To view these accounts and their passwords you will need to look at the "account" table in the realmd database. It is advisable that you change these four passwords. The GM levels should be self-explanatory in their default settings.
* If you are getting a realmlist loop, or other connectivity issues on a local setup then you have not specified your IP address as 127.0.0.1 in all the correct locations: mangosd.conf, realmd.conf, realmlist.wtf, scriptdev2.conf and the realmlist table in the realmd database.
* IF YOU WANT TO LEARN HOW TO ALLOW OTHERS TO CONNECT TO YOUR SERVER, CHECK OUT MY GUIDE @ http://www.mmowned.com/forums/mangos...tml#post675131
+Rep me if you found this useful. It would really be a great encouragement for me to continue making more guides on various server issues. Thanks if you do.
FOR ANY QUESTIONS, DO NOT POST THEM IN THIS THREAD, THIS SUB-FORUM IS HOLDING A NO-QUESTION POSTS POLICY. PLEASE RESPECT THAT. PM ME INSTEAD.