So Leute da ich den WoW Bereich auch mal leben lassen wollte , werde ich hier ein Guide mal releasen wie man einen WoW Server aufsetzt jedoch die Bedingung ist das ihr es auch compiled bekommt. ;)


So ihr bekommt den Guide erstmal auf English werde ihn später auch in Deutsch posten!.

TABLE OF CONTENTS

PART 1 - Forums ---------------------------------------------- Page 1
PART 2 - Requirement ----------------------------------------- Page 1
PART 3 - Definition -------------------------------------------- Page 1
PART 4 - Software Installation --------------------------------- Page 1
PART 5 - Cloning Mangos -------------------------------------- Page 1
PART 6 - Cloning ScriptDev2 ----------------------------------- Page 1
PART 7 - Configuring C++ -------------------------------------- Page 1
PART 8 - Compiling Mangos and ScriptDev2 --------------------- Page 1
PART 9 - Installing Mangos ------------------------------------ Page 1
PART 10 - Verify your Versions --------------------------------- Page 1
PART 11 - Extracting Files From Your Client --------------------- Page 1
PART 12 - Installing and Configuring MySQL --------------------- Page 1
PART 13 - Setting Up the SQL Connection ---------------------- Page 1
PART 14 - Adding Databases ----------------------------------- Page 1
PART 15 - Updating your Database with SQL Files --------------- Page 1
PART 16 - Adding ACID ---------------------------------------- Page 1

PART 1 - FORUMS

• Mangos (getmangos.com > Home)
• UDB (UDBForums - Index)
• ScriptDev2 (SD2 Forum - Powered by vBulletin)



PART 2 - REQUIREMENT

• World of Warcraft client (Updated to Mangos client version. See PART 10 - Verify your Versions)
Patches Downloads | FilePlanet

• GIT client (ex. : msysgit, This will download your Mangos Source Files)
Downloads - msysgit - Project Hosting on Google Code

• Tortoise SVN (This will download your scriptdev2)
TortoiseSVN downloads | TortoiseSVN

• Visual Studio C++ 2005 or better (Recommended Version: Visual Studio 2008 Express)
microsoft.com/express/Downloads/

• MySQL server community edition (In the “Generally Available Release” Tab)
MySQL :: Download MySQL Community Server

• MySQL client (ex. : SQLyog Community)
Downloads - sqlyog - Project Hosting on Google Code

• Newest UDB database
unifieddb.svn.sourceforge.net/…/unifieddb/trunk/Full_DB/

• The latest UDB update packs
unifieddb.svn.sourceforge.net/…/unifieddb/trunk/Updates/

• Advanced Creature Intelligence Database for Mangos (ACID)
sd2-acid.svn.sourceforge.net/svnroot/sd2-acid/trunk/


Default

PART 3 - DEFINITION

World Of Warcraft Client

When we are referring to the client, it’s your on copy of the game. A client connect to a server

GIT

GIT is a free distributed revision control or software source code management project with an emphasis on being fast
Git itself is a suite (collection) of tools to manage a git repository (virtual filesystem).
Some website provide free source code hosting for GIT repositories
A Git repository is an object-based VFS, all repositories are equal each other. You can clone already cloned repository locally
In other word, with your GIT Client, you’ll copy from a website the Mangos Project

GIT Client

GIT Client is a software that will help you manage and work in your different repository
Msysgit is a GIT client you can use
Basically, this will be use to clone the Mangos repository. The project will later on be compile to make a software witch we could call the core of your World Of Warcraft Server

Mangos

Mangos is your software that manages all the game inquiries and accesses your SQL Database to get the information needed
It’s also being referred as the Mangos Project

Tortoise SVN

This is a free-software, witch allow you to clone a Repository from a location. This has a similar purpose than the GIT client but for a different type of support.
This will download your ScriptDev2 Database

ScripDev2

This is a C++ Project witch is added to Mangos that handles special events, quests, encounters and Bosses

ACID

Abbreviation for “Advanced Creature Intelligence Database”
This is an SQL Database that contains code that handles regular mobs and bosses
ACID and ScripDev2 are use for the same purpose but are developed by different entities. Those 2 entities working together nearly transfer everything that can be handle by SQL to ACID while the rest will remain in ScriptDev2
Since the requirement for ACID and ScriptDev2 as bin added in Mangos, they do not require each other to work properly. Although for the game purpose, you should need both

Microsoft Visual C++

Software used to created, modify and compile codes using C, C++, and C++/CLI programming languages.
This will be used to compile your Mangos Project and ScripDev2 Project

MySQL server community edition

MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases.
In other words, after you’ve created the databases, tables and imported data in theses tables, this will contain your entire World for World Of Warcraft

MySQL Client

This is a software that will allow you to connect to your database such World Of Warcraft Client connect to a World Of Warcraft Server
This will be the interface your going to use to import and change the data in each SQL Database
SQLyog Community is a MySQL client you can use

UDB Database

Your Unified Database ( UDB ) is a database that contains all your World details inside World Of Warcraft. This will become your core for the Mangos Database
There is other World Database that can be used instead such YTDB
The Realm and Characters Database witch are also part of Mangos can receives updates but the Core only refers to the Mangos Database

UDB Update Pack

The UDB Updates packs are used to update your Mangos Database after UDB Core. They are blocks of updates



PART 4 - SOFTWARE INSTALLATION

** Use default settings for the following installation

• Install your GIT client
• Install your C++ software
• Install Tortoise SVN and reboot as required at the end of your installation

** In this guide, I will assume that you want to install Mangos and World of Warcraft in your C:\ directory. Otherwise, use your head to put them wherever you want and refer to the appropriate path when needed. World of Warcraft does not required to be installed on your server. Although when extracting the files, you’ll need to do so on a computer that has the client installed.

PART 5 - CLONING MANGOS

• Launch “GIT GUI” from your list of programs
• In the new window, click on “Clone Existing Repository”
• In the new window, enter with the keyboard the following information

Source Location: git://github.com/mangos/mangos.git
Target Directory: C:\Mangos

** The Target Directory must not exist

• Click “Clone” and wait for the task to finish
• Close your “GIT GUI”

PART 6 - CLONING SCRIPTDEV2

• Create the folder C:\Mangos\src\bindings\ScriptDev2
• Right click on that folder and choose SVN Checkout
• Put the following information:

URL of Repository : scriptdev2.svn.sourceforge.net/svnroot/scriptdev2
"https://" + "scriptdev2.svn.sourceforge.net/svnroot/scriptdev2"

Checkout Directory: C:\Mangos\src\bindings\ScriptDev2

** When the transfer is completed, you can see the revision at the bottom such “At revision: 1643”

• Click OK
• Right click on C:\Mangos and choose “Git Bash”
• Type the following command replacing the XXXX by the numbers within the file name located in C:\Mangos\src\bindings\ScriptDev2\patches:

git am src/bindings/ScriptDev2/patches/MaNGOS-XXXX-ScriptDev2.patch

** This is not required, although it is needed to avoid deletion of untracked folders/files in GIT-directory when using certain GIT commands (example: git clean -f -d)

• Close the GIT Bash window



PART 7 - CONFIGURING C++

• Open Visual C++
• Go to “Tools”, “Options”
• Click the “+” next to Projects and Solutions, then click VC++ Directories
• Make sure the drop down menu says “Executable Files”
• Add a new entry by clicking on an empty row at the bottom of the list and then clicking on the “...” on the right edge. Put your SDKs Bin folder path such as following:

C:\Program Files\Microsoft SDKs\Windows\v6.0A\Bin

** Do not modify existing entries

• Click the drop down menu and make sure it says “Include Files”, then do the same as previous for the Include folder:

C:\Program Files\Microsoft SDKs\Windows\v6.0A\Include

• Click the drop down menu and make sure it says “Library Files”, then do the same as previous for the Lib folder:

C:\Program Files\Microsoft SDKs\Windows\v6.0A\Lib

PART 8 - COMPILING MANGOS AND SCRIPTDEV2

** While installing your server: You might want to start the first and second part of the Auction House Add-on if you intend to use it (See AHBot Part 1 – Creating the Patch file and AHBot Part 2 – Auction House Patch – Require the software to be re-compile)

• Go to your C:\Mangos\Win folder
• Open the “sln” file that fit your version of C++

mangosdVC80 for C++ 2005
mangosdVC90 for C++ 2008
mangosdVC100 for a newer version of C++

• Wait for C++ to finish loading. You’ll see a message on the bottom saying “Updating Intellisense”. It will change for “Ready” it’s done.
• Click “Build” in the menu and select “Configuration Manager”
• Click “Release” in the drop down box for “Active Solution Configuration”
• The drop down box “Active Solution Platform” should already be set to “Win32”
• Click on “Close”
• Then, click “Build” in the menu and select “Build Solution”

** This will take a long time. You might get some warning messages...If you do, don't worry about it, it's normal

** You shouldn’t get any error message, although if you do so, you could click “Build”, “Clean Solution”, then restart the compile but this will only drop the error for the compile to work. You may end up missing some information’s.

• Close the window when it’s done
• Go to your C:\Mangos\src\bindings\ScriptDev2
• Open the “sln” file that fit your version of C++

scriptVC80 For C++ 2005
scriptVC90.sln For C++ 2008

• Wait for C++ to finish loading. You’ll see a message on the bottom saying “Updating Intellisense”. It will change for “Ready” it’s done.
• Click “Build” in the menu and select “Configuration Manager”
• Click “Release” in the drop down box for “Active Solution Configuration”
• The drop down box “Active Solution Platform” should already be set to “Win32”
• Click on “Close”
• Then, click “Build” in the menu and select “Build Solution”
• Close the window when it’s done



PART 9 - INSTALLING MANGOS

• Transfer the files from your compile folder into C:\Mangos

** They should be in C:\Mangos\bin\Win32_Release

• Go to C:\Mangos\src\mangosd and copy “mangosd.conf.dist.in” to “mangosd.conf” in C:\Mangos
• Go to C:\Mangos\src\realmd and copy “realmd.conf.dist.in” to “realmd.conf” in C:\Mangos
• Go to C:\Mangos\src\bindings\ScriptDev2 and copy “scriptdev2.conf.dist.in” to “scriptdev2.conf” in C:\Mangos

PART 10 - VERIFY YOUR VERSIONS

• Open the file C:\Mangos\News in notepad. (The file doesn’t have an extension)
• The version of the supported World of Warcraft client will be mentioned

Ex.: “Upgrade to client version 3.3.3 (build 11723)”

** 3.3.3 (build 11723) is your World of Warcraft client requirement. Big patch will change the version number although smaller patch will only affect the build number within the same version. You must match the exact build version with your client

** The version can also be found later on in PART 15 - Updating your Database with SQL Files in the Mangos Database

• Download newest UDB database and the latest UDB update packs
• Update your World of Warcraft client to the supported version



PART 11 - EXTRACTING FILES FROM YOUR CLIENT

• Copy C:\Mangos\contrib\extractor\ad.exe in your C:\World of Warcraft
• Run Ad.exe from your C:\World of Warcraft

** It all depends of your computer speed but this will take few minutes to extract the files

• When finish, move the folders Maps and DBC that has been created in your C:\World of Warcraft to your C:\Mangos
• Run C:\Mangos\contrib\vmap_extract_assembler_bin\makev maps_Simple.bat

** Even on fast computer, this will take a while. You can expect this to take 30 minutes and more…

• When completed, move the folders Vmaps and Buildings that has been created in your C:\Mangos\contrib\vmap_extract_assembler_bin to your C:\Mangos

PART 12 - INSTALLING AND CONFIGURING MYSQL

• Install MySQL Server choosing Typical or Complete setup
• When the installation is completed

a) Keep the check mark to “configure the MySQL server now”
b) Remove the check mark from “register the MySQL server now”

• Choose “Standard Configuration” when asked

a) Put a check mark to “Install as Windows Service” and “Launch MySQL Server Automatically”
b) The service name stays “MySQL”

• Click next

a) Keep the check mark to “Modify Security Settings”
b) Choose a password for your Mangos Server
c) Put a check mark to “Enable root access from remote machines” unless you know your won’t need it

** Default server password is mangos, you should change it if you are making an online server for other players or activating that last option

** If you plan to use the IP of the machine instead of localhost, 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, “Enable Root Access from Remote Machines” needs to be activated

• Complete the configuration clicking on next and execute



PART 13 - SETTING UP THE SQL CONNECTION

• Install and Run your SQLclient. In this case “SQLyog”
• Click the “New...” button at the top of the window to create a new connection
• Name the connection anything you like such “World Of Warcraft SQL Server”
• Fill out the fields as indicated below:

a) MySQL Host Address: This is “127.0.0.1” or “localhost” if your SQLclient is on the same machine as the MySQL server. If you’re accessing this from another computer, put the LAN IP address or the Internet IP address depending on your needs.

b) Username: Type in “root”

c) Password: This is the password you set up when you’ve installed the MySQL Community Server (See PART 12 - Installing and Configuring MySQL)

d) Database(s): Leave this blank for now

• Click “Connect” and save the change



PART 14 - ADDING DATABASES

• In the top left-hand side, right-click “root@(IP here)”
• Click “Create Database” and create the following database:

a) realmd
b) mangos
c) characters

• Select mangos database on the left (any database could do for now)
• Open with notepad

C:\Mangos\src\bindings\ScriptDev2\sql\scriptdev2_c reate_database.sql

• Empty the “query” textbox to the right of SQLyog and paste the contents of the .sql file
• Select all the text in the textbox (Ctrl-A), then press the play button (F9) in the toolbar at the top of SQLyog
• Click “File” in the menu at the top of SQLyog
• Click “New Connection”
• This time in the databases field, type:

realmd;mangos;characters;scriptdev2

• Click “Save”
• Click “Connect”
• Now, in the left-hand database list, right-click “realmd” and select “Import”, “Restore from SQL Dump”
• Click “Browse”, and select C:\Mangos\sql\realmd.sql
• Click “Execute”
• Right-click “characters” and select “Import”, “Restore from SQL Dump”
• Click “Browse”, and select C:\Mangos\sql\characters.sql
• Click “Execute”
• Right-click “mangos” and select “Import”, “Restore from SQL Dump”
• Click “Browse”, and select the UDB database Core file you’ve download

Ex.: UDB_0.11.6_Core_8734_SD2_1480.sql

• Click “Execute”
• Select the ScriptDev2 database on the left
• Open with notepad:

C:\Mangos\src\bindings\ScriptDev2\sql\scriptdev2_c reate_structure_mysql.sql

• Empty the “query” textbox to the right of SQLyog and paste the contents of the .sql file
• Select all the text in the textbox (Ctrl-A), then press the play button (F9) in the toolbar at the top of SQLyog
• Keep ScriptDev2 database selected and do the same for:

C:\Mangos\src\bindings\ScriptDev2\sql\scriptdev2_s cript_full.sql

• Select the Mangos database on the left and do the same for:

C:\Mangos\src\bindings\ScriptDev2\sql\mangos_scrip tname_full.sql



PART 15 - UPDATING YOUR DATABASE WITH SQL FILES

• Open SQLyog and connect to your server if you’re not already there

** UDB Corepatch and UDB Updatepack aren’t the same

** A UDB Corepatch is a bunch of C:\Mangos\sql\Updates made by the Mangos team. This is the structure of your tables in the database. They are empty

** A UDB Updatepack will populate your tables

** If you follow the logic, you need to upgrade your table before you put your data in them

** First thing to do is to determine your databases versions

• For each Database go into the following tables to find out the database and software version. There’s an example in bold of what you can find:

a) Database Characters – Table Characters_DB_Version

Required_9375_01_characters_character_glyphs

b) Database Mangos – Table DB_Version

Version: UDB 0.12.0 (388) for Mangos 9582 with SD2 SQL for rev. 1639
Creature_AI_Version: ACID 3.0.3 – Full Release for Mangos (3.2.2a Client)
Cache_ID: 388
Required_9590_01_mangos_db_script_string

c) Database Realmd – Table Realmd_DB_Version

Required_9010_01_realmd_realmlist

** Looking at the information above, this tells u that the only database that can receive something else than core pack is the Mangos Database. We are talking about update pack

** The sequence for the update is simple. You need to apply the update witch is the next number in line. You need to understand that the numbers are not necessary incremented by 1. If your character table is 9375, then the next number may be 9380 or 9385, but if you have both numbers, then you need to do 9380 first and then 9385. You just need to check your files in C:\Mangos\sql\Updates and figure what’s the next one. This should be the way to follow to upgrade the Characters and Realm database

** Upgrading your Mangos database may be done as above but to have a head start, you can also use the file from UDB. You can figure out what’s your next patch looking at the Cache ID even though it refers to the Updatepack, not the Corepatch. Best thing to do is also take a look at the file name witch will tell you what upgrade it is covering. So in this example, I’ll need to upgrade the core with 389 and so on. After I’m done with the UDB Corepatch, then I’ll need to go in my C:\Mangos\sql\Updates and complete the upgrade as describe above by looking at the new Database version. You may have to reconnect to your database to refresh the data. Although you can simply look at the last UDB Corepatch file name you’ve used.

** Keep in mind that when you upgrade your Mangos, Characters or Realmd databases, if you try to apply a patch that was already applied, it shouldn’t matter since it will simply tell you that the modification already existed. So yes, if you had to upgrade with sql\Updates file this time, if you use the next UDB Corepatch when they will release a new one, it may say that some of the information already existed. Applying Scriptdev2 update twice may cause errors

** When the Mangos Database core has bin upgrade, I can now upgrade my content with the UDB Updatepack. Since Cache ID is 388, then next Updatepack will be 389 and so on

** The Cache_ID tells u the actual version of the UDB Contents. The next update pack to get from UDB would be the update pack 389 but only after you’ve updated your mangos core

** Of course, talking about updates, you will see the name of the database and version that will be applied in the file name. Make sure that the appropriate database is selected on the left of the windows when your performing an update

• Locate the updates you will need to apply on the database. Either in your C:\Mangos\SQL\Updates folder or from the files you’ve downloaded (UDB Updates Pack)
• Open with Notepad the .sql file you are going to use to update the database
• Select the database to be updated
• Empty the “query” textbox to the right of SQLyog and paste the contents of the .sql file
• Select all the text in the textbox (Ctrl-A), then press the play button (F9) in the toolbar at the top of SQLyog
• Parts of the application will become greyed, wait for the query to finish executing

** While installing your server: If you intend to use the Auction House Add-On, you might want to add the SQL part from the Auction House section after you’ve updated your database version. (See AHBot Part 3 – Adding the SQL code in the Database and then AHBot Part 6 – Tuning the SQL Database)

** You can put more than one update in the Query box for the same database. Although you need to keep them in the appropriate order

** If you did your update and you want to see the new version number, you’ll need to refresh the data. For example, reconnect to your MySQL server



PART 16 - ADDING ACID

• Download ACID for your Client version if it’s not done (Basic, The Burning Crusade or Wrath Of The Lich King)
• Still in SQLYog, select your Mangos Database.
• Empty the “query” textbox to the right of SQLyog, past the contents of the .sql file you’ve downloaded
• Select all the text in the textbox (Ctrl-A), then press the play button (F9) in the toolbar at the top of SQLyog and wait for this to be complete
• Close SQLYog

** It is recommended that ACID be added at the very end of all your database manipulation



At the End i hope you get the files ready to work! Have fun !

Credits to Temporary

TerrorSonic;136379 schrieb:

Jetzt mal im Ernst, sehr sehr sehr viele User, haben kein Bock drauf zu lesen, weil es
1: Keine Screen's hat
2: Englisch ist, und xxx User es nich verstehen
3: Es ist sehr Kompliziert für viele hier.

Sogar ich verstehs zum Teil garnich^^

1. Wozu sollte man immer Screens needen, jeder der English kann sollte es verstehen.

2. Look to 1

3. Es ist alles Schritt für Schritt erklärt!