Before we start, yes i misspelled Guild, its Guide ;DDDDD
Okay I havent seen a mangos 2.1.1-2.1.2 yet on these forums, so here we go.
What you need...............
•••MYSQL•••
http://www.soft32.com/download/63-178244/mysql-5.0.37-win32.zip
=========================================================
•••NAVICAT•••
http://www.navicat.com/download/navicat8_mysql_en.exe
=========================================================
•••2.1.1-2.1.2 Mangos Server•••
http://filebeam.com/ac14a7ef025023e1a2b73e70c24f563e
=========================================================
Lets get started.
1. Download and install the Mysql.
1a. After installation, click "configure the server now"
1b. Click next
1c. Click Standard Configuration
1d. Click next
1e. Choose "Run as Windows" at top.
1f. Click next
1g. Put in a password (put password root for now)
1h. Click next, and click execute.
1i. After that completes, exit out Mysql.
2. Download and install Navicat.
2a. After installation, go ahead and download the server if you haven't already.
2b. After download, extract the folder somewhere on your computer.
(the folder might say 2.1.1, but it WILL work on 2.1.2)
3. Open up Navicat.
3a. Select "Create a New Connection"
3b. Now fill what I have in below....
=========================================================
Connection Name: Mangos
Hostname: 127.0.0.1
Port: 3306
Username: root
Password: root (or whatever password you put in at step 1)
=========================================================
4. Click "Test Connection", if successful, click "Ok".
4a. Rightclick the Connection you just made.
4b. Select "New Database"
4c. Name it "realmd"
4d. Click "Ok"
4e. Rightclick connection again.
4f. Select "New Database" again.
4g. Name it "mangos"
4f. Click "Ok"
5. Now open your connection by left clicking it once.
5a. Rightclick your "realmd" database
5b. Select "Execute Batch File"
5c. Now go into your Server Folder (wherever you extracted it to), click folder "sql", and click on the "realmd.sql" file.
5d. After that finishes do the same for the "mangos" database, but this time click on the "mangos.sql" file.
5e. This will take ALOT longer then realmd, so take a little break.
5f. After that finishes, close Navicat.
6. Go into your server folder (wherever you extracted it)
6a. Find and open the "realmd.conf" file with Notepad.
6b. Searching for following line...
=========================================================
=========================================================Code:LoginDatabaseInfo = "127.0.0.1;3306;root;[mysql pass];realmd
6c. Then of course replace where it says [mysql pass] with your password you put in step 1....."root" (take out brackets too)
6d. Save and close.
6e. Now open up "mangos.conf" with notepad and search for this line...
=========================================================
=========================================================Code:LoginDatabaseInfo = "127.0.0.1;3306;root;[mysql pass];realmd WorldDatabaseInfo = "127.0.0.1;3306;root;[mysql pass];mangos
6f. Again replace the [mysql pass] with your mysql password.
6e. Save and close.
7. Now, find the file "ad.exe" in your server folder.
7a. Move that file to your World of Warcraft folder.
(ex: C:\Program Files\World of Warcraft)
7b. Now create a new folder in your World of Warcraft folder named "maps"
7c. Now execute the "ad.exe" and wait until that finishes...
7d. After completion, copy the "maps" folder into your Server folder.
(By now you should know where that is)
8. Good Job, but your not done yet...
8a. To name your server, open up Navicat and go into your "realmd" database and select the table "realmlist".
8b. Now you should see a new window with a list of tabs at the top.
8c. Find the tab "name" and change it to whatever you want.
8d. Click the "checkmark" at the bottom to save and close that table for now.
8e. Now to create an account, click on the "account" table.
8f. You can either leave it like it is, or you can edit it the way you list.
8e. SOME IMPORTANT THINGS TO KNOW IN THE ACCOUNT TABLE...
=========================================================
-gm levels (0 - regular player, 1 = moderator, 2 = gamemaster, 3 = administator, 4 = root administator)
-you can enable tbc "The Burning Crusade" on your account by scrolling all the way to the right and change the tab "tbc" to 1 (1 = yes, 0 = no)
=========================================================
9. Now one more thing if you want to connect to your server...
9a. Go to your World of Warcraft folder and locate the file "realmlist.wtf"
9b. Open that file with NOTEPAD.
9c. Now change the contents of the file to..."set realmlist 127.0.0.1"
9d. Save and close.
10. Now to start up your server you can either run the "restarter" file in your server folder, or you can just run "realmd.exe", and then "mangos.exe".
=========================================================
Some things you might want to know...
You HAVE to have at least 2.1.1 or 2.1.2...either way works
If you want to change back to the official servers again, follow these steps..
•Go into your C: drive
•Locate the file "realmlist.wtf" in your C: drive, not your World of Warcraft.
•Now copy that file to your World of Warcraft folder, and when it says "overwrite exsisting file?" click on "yes".
Ignore the "quotes"
=========================================================
Some commands you might wanna know....
.commands (list of commands)
.modify speed #
.modify money #
.modify hp #
.tele [name]
.lookupcreature [name]
.lookupitem [name]
.addspw [creature_id]
.additem [item_id]
.gameobject [object_id]
=========================================================
•••MAKING YOUR SERVER PUBLIC•••
There are a couple ways of doing this.
==============================================
Way 1: No-IP
•Go tohttp://no-ip.com
•Click "Downloads" at top
•Download it
•Then once its downloaded, load it up and create a new ip-name
(ex: wow.no-ip.info)
•Once you created a name, copy the name into your realmlist.wtf file... it should look something like this...
set realmlist wow.no-ip.info
•Save and close
•Your not done yet! Open up Navicat.
•Go in "realmd" database and select the "realmlist" table
•Where it says 127.0.0.1, change it to your no-ip name
•Click the checkpoint at the bottom and close
•Your friends also have to change their realmlist.wtf to connect to your server.
Way 2: Hamachi
•Go to http://hamachi.cc
•Download it and install it.
•Create a new network, name it whatever you want, and set a password.
•Once you created a network, copy the hamachi address into your realmlist.wtf file... it should look something like this...
set realmlist 5.179.153.170
•Your not done yet! Open up Navicat.
•Go in "realmd" database and select the "realmlist" table
•Where it says 127.0.0.1, change it to your hamachi address
•Click the checkpoint at the bottom and close
•When your friends want to connect, they have to connect to your hamachi as well, so they have to download hamachi and connect to your network. (REMEMBER, The network name and password are CaSe-SeNsEtIvE)
•Your friends also have to change their realmlist.wtf....
=========================================================
=========================================================
IF YOUR HAVING PROBLEMS WITH YOUR REALMD FOLLOW THESE NEXT STEPS
11. download this file http://forum.ragezone.com/attachments/f114/41597d1182011300-mangos-2-1-1-server-realmd.rar
11a. extract the file on your desktop.
11b. now place the fixed "realmd.sql" in your (SERVER FOLDER\SQL\) folder, and overwrite the exsisting one in there.
11c. now you will have to redo some steps "sorry guys"
11d. open up your Navicat
11e. delete your "realmd" database
11f. create a new database and name it "realmd" again
11e. rightclick that database and select execute batch file, and locate the file you just downloaded a second ago
11f. once that is finished, you will have to redo your tables, because it reset...(sorry again =( )
11g. once that is complete, close Navicat and start it up!
11h. one more thing, don't mind the language on the realmd.exe, if you see a HOCH somewhere, then your good.
Features
•Black Temple (all creatures are level 1 except the boss (Illidan) which is level 74 elite) type .tele blacktemple in-game to teleport there.
•Tier 1-5 working, and tier 6 can be loaded into your server as well.
+rep is appreciated