[golanka]

Tools you will be needed

Quote:

• A copy of World of Warcraft either enUS or enGB.
• MaNGOS Bins (Rev 3200 + MCH) -> [Only registered and activated users can see links. ]
• SDB 0.6.1 -> [Only registered and activated users can see links. ]
• The map extracting tool ad.exe -> [Only registered and activated users can see links. ]
• The *.dbc extraction tool mpqe.exe -> [Only registered and activated users can see links. ]
• MySQL -> [Only registered and activated users can see links. ]
• A MySQL admin tool, such as Navicat or SQLyog, in this guide I will be using SQLyog because it is free and is almost the same as Navicat -> [Only registered and activated users can see links. ]
• WAMP PHP5 Apache MySQL (For your website) -> [Only registered and activated users can see links. ]

Step 1: Creating your Workspace + Installing your files
Extracting MaNGOS Bins

1. Download and extract your MaNGOS bins wherever you want, but this is where your server files will be placed. I will be referring to this as the MaNGOS directory. Please make sure that once you open that folder, there is no folder inside, so when you open your MaNGOS Dir. you will see the batch files mangosd.exe and realmd.exe, and other files. If you do not see these, cut the files and put them in the correct folder.

Installing tools

1. After [Only registered and activated users can see links. ], double click the MySQL installation tool and begin installing your files. You don't need to sign up to use this, but you can do this later (I think it's free). After skipping the sign up, pick whatever dir. you want to install it (feel free to leave it as default), and then beginning installing. After it's completely, make sure that "Configure my MySQL Server Now" is checked off and then click Finish.

Configuring your MySQL Server

1. Once the window pops up introducing you to the config wizard, click next
2. Choose standard configuration then click next
   
3. Then choose to Install As Windows Service then click next
   
4. In the two empty dialog boxes, type in the password you wish to use for the MySQL root (aka Administrator) [Only registered and activated users can see links. ]. 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. Also, if you want to make your server public, check off "Enable root access from remote machines". Then click next
   
5. In this new window you should see 4 white bullets, and below a button called Execute. Click that button and wait for it to finish, it should then say below those 4 buttons in black that you have succesfully configured your MySQL server. That's when you click finish.

Getting Maps + DBCs
Maps

1. Copy your ad.exe folder to your 1.12.1 enUS/enGB WoW Directory.
2. Create a folder called maps in your 1.12.1 enUS/enGB WoW Directory
3. Double click the ad.exe tool. Wait till it has finished extracting the map files.
4. Once completely copy&paste or cut&paste the "maps" folder which should have 2400+ map files / 700mb of space to your Mangos Directory. Your Mangos Directory should now have the folders "maps" and "sql".

DBC's[list=1][*]Download this: [Only registered and activated users can see links. ][*]Extract the folder into your Mangos Directory


Step 2: Setting up your Database
Connecting to your MySQL Server

1. Open up SQLyog. Please make sure it looks something like this:
   
   The difference would be that firstly, the "password" you put was the one in step 4 for MySQL configuration, aka, your MySQL root password. [b]Make sure that at the bottom it has the 2 databases: realmd;mangos (not mangod).

Creating Empty Databases

1. Click connect.
2. On the left there is a tab called root@localhost. To create your databases. Right click that and click "Create new database" Name it "mangos"
3. Repeat this step but name it this time "realmd"
4. If the databases are already there, then you can skip these steps

Creating Spawned Databases
I suggest you close your SQLyog and open it again so you can see the new databases, which should look like this on the left tab:

If it looks like this, then we can move onto the next step, if it doesn't then it sux2beu (or I suggest you re-do EVERYTHING).

1. Right click Realmd and click Restore from SQL Dump. This will open a new window. At the top there is a white [Only registered and activated users can see links. ], to the right there is a button with "..." inside, click that button, then go to your Mangos Directory, click the "sql" folder, and double click realmd. It should take you back to that window, now you can click execute. After it finishes, close the window.
2. Right click mangos and click Restore from SQL Dump. This will open a new window. At the top there is a white bar, to the right there is a button with "..." inside, click that button, then look for where you extracted SDB (if you haven't do so now and then refresh the folder). Double click the SQL file and click Execute. Wait till it finishes loading (this may take a while depending on your [Only registered and activated users can see links. ]). After it's finished entirely, close the window.

Configuring MaNGOS!
Alright, so you have set up all your files, and you have gotten everything in tip top shape So then one last step until you are ready to starting up your MaNGOS LAN Server.

1. Open up your MaNGOS Directory
2. Right click on realmd.conf and open as Notepad, Textpad, anything with "pad" at the end :P
3. Find
   Quote:
   LoginDatabaseInfo =" Change it to "LoginDatabaseInfo = "127.0.0.1;3306;root;[password];realmd"
   Your password should be the MySQL Root Password and then everything else should look like what's in the code. After edited, save and close realmd.conf
4. Right click on mangos.conf and open as Notepad or Textpad
5. Open mangosd.conf in notepad. It should be in your root server directory ("C:\MaNGOS).
6. Find these lines and set as shown:
   o DataDir = "."
   o WorldDatabaseInfo = "127.0.0.1;3306;root;[password];mangos"
   o LoginDatabaseInfo = "127.0.0.1;3306;root;[password];realmd"
7. Save and close file.

CONGRATULATIONS, MANGOS IS NOW FULLY CONFIGURED AND FUNCTIONAL

Connecting to your MaNGOS Server

1. Go to your MaNGOS Directory
2. Double click on realmd.exe
3. Double click on mangos.exe
4. While it's loading, go to your WoW Directory, open up the realmlist, and change the contents to:
   Quote:
   set realmlist 127.0.0.1
5. Start up your WoW.exe
6. Wait for the "beep" which indicates that MaNGOS has loaded and you can connect. Then log in with the following sample info (for maximum commands
   Quote:
   user: administrator
   pass: administrator

Voila! Create your characters and screw around!

[Zackala]

no offense but is this really your guide? u just uploaded another guide in the antrix section wich is completely differently struvturized than this one

[Jaman007]

LINK for The map extracting tool ad.exe doesn't work and when i download new ad.exe and copy folder maps in to the mangos dir it says some sort of error cuz of outdated file and mangosd is closed right away. What should I do?

[golanka]

hmm not sure. i didnt get the problem.

This is my guide tho

[LGB]

I get a execute prob its says: "There was an error while executing a query.
The query and the error message has been logged at:
C:\Documents and Settings\"My Comuter name"\Programdata\SQLyog\sqlyog.err.
Please click on "Open Error File..." to open the error file."

[LGB]

i found it out did all over again

[LGB]

Hey! another prob got up. On the WAMP5 says: none of 2 services running should it says so or shouldn't it? And do you know anny tips when wow can't validate the game version?

[ace216]

hello can you post me the

mangosd
cof file
so i can delete it all and put it how its mean't to be plz

[Eriqoball]

the link to the maps is not working

[jordy5000]

Are these DB's complete because i see no table for items...

[zaronz]

Wish i could rep+ u mate, but the Lazy leecher curse wont let me

[mettlehead]

This post deserves some rep. Good guide.

[Ikookniet]

yo guys i have a question i want to start up my server but i can start realmd.exe but when i want to start mangosd.exe it shows the msdos and then closes what do i need to do PLZ HELP

[karpis]

This is server 1.12.1 server guide I think, this is like a 1.12.1 ManGOS server guide. U have in mind 2.3.0 server ? U realy think man this is 2.3.0?? server guide?

[Tom_2001]

lol retard guide.