[MANGOS]Set up your Mangos Server 2.0.8 TBC with EasyPHP

[Hakuji]

First of all you must have World of Warcraft: The Buning Crusade 2.0.8
you can download patches from Here

PART 1: DOWNLOADS

1. Download SQLyog at SQLyog Downloads Page

2. Download the latest version of EasyPHP at EasyPHP Downloads Page

3. Download the server:

DOWNLOAD LINKS BY DJRavine:

DOWNLOAD: MaNGOS v2.0.8 [COMPLETE].rar - 233.93MB [FileCrocodile.com]
DOWNLOAD: MaNGOS v2.0.8 [COMPLETE].rar - 233.93MB [SendSpace]
DOWNLOAD: MaNGOS v2.0.8 [COMPLETE].rar - 233.93MB [UpLoading.com]


PART 2: INSTALL

1. Install EasyPHP

2. Install SQLyog

3. Extract MaNGOS_TBC_v2.0.8_COMPLETE.rar to "C:\Mangos"

PART 3: SETTING UP YOUR PASSWORD

1. Run EasyPHP (Be sure that Apache and Mysql are on "Running" status, right-click on his icon in trayicon, on the bottom-right side of the screen, and click Run or press F2)

2. Open your EasyPHP folder (Eg. C:\Program files\EasyPHP 2.0b1) and copy phpmyadmin folder in www folder.

3. Open your browser and go to http://127.0.0.1/phpmyadmin

4. Click on Privileges

5. Click Edit Privileges of root user (the right sided icon with a guy with a pencil)

6. Edit there your password (it will be usefull for mangosd.exe and realmd.exe connection to databases)

PART 4: SETTING UP YOUR DATABASES

1. Now open SQLyog

2. Put "localhost" as MySQL Host Address, "root" as User Name, the password of your database as Password and "3306" as port

3. Click Save and then click on Connect

4. Right-Click on root@localhost group and then select "Create Database"

5. Type "mangos"

6. Repeat step 4 and then step 5 but type "realmd" instead of mangos this time

7. Now right-click on mangos database and select "Restore From SQL Dump"

8. Find the mangos_bc.sql and load it (it should be in "C:\mangos\sql" folder)

9. Wait a little and then repeat step 7 but now for realmd database

10. Same as step 8 but now you've to load realmd.sql

PART 5: SETTING UP REALM(realmd.exe) AND WORLD(mangosd.exe) CONNECTIONS

1. In C:\Mangos folder open realmd.conf with notepad.

2. edit LoginDatabaseInfo like this -> LoginDatabaseInfo = "localhost;3306;root;mypass;realmd" (delete "mypass" and type your password that you've set up in phpmyadmin)

3. Now open realmd.conf with notepad.

4. edit LoginDatabaseInfo as in step 2 and
WorldDatabaseInfo like this -> WorldDatabaseInfo = "127.0.0.1;3306;root;mypass;mangos"

PART 6: RUN YOUR SERVER

1. Run realmd.exe

2. Run mangosd.exe

PART 7: SET UP YOUR CLIENT TO CONNECT TO YOUR SERVER

1. Open realmlist.wtf with notepad.

2. Delete everything and type: "set realmlist 127.0.0.1" (or "set realmlist <your ip>)

Part 8(Optional): INSTALL WEB PORTAL

1. Download Web Portal (Link By BurningDappa from forum.wowps.com)

2. Extract it on your www EasyPHP folder ("C:\Program Files\EasyPHP 2.0b1\www" or something like that)

3. Now Open SQLyog

4. Connect into your sql server

5. Right-Click on realmd database database and select "Restore From SQL Dump"

6. Load "sql_account_extends.sql" in sql folder ("C:\Program Files\EasyPHP 2.0b1\www\sql" or where you've extracted the web portal)

7. Do step 5 and then step 6 for "sql_newtables.sql" and then in "C:\Program Files\EasyPHP 2.0b1\www\sql\updates" load 22.sql

8. Edit config.php in www folder like this:

<?php
$config = array(
'template'       => 'offlike', //Default template
'lang'           => 'en',        // Default language
'db_type'        => 'mysql', //Database type
'db_host'        => '127.0.0.1', //Database IP
'db_port'        => '3306', // Database Port
'db_username'    => 'root',// Database Username
'db_password'    => 'mypass',// Database Password
'db_name'        => 'realmd', //Name of Realm Database
'db_encoding'    => 'CP1251'     // Very important, check your mysql "my.ini"
);

$news_forum_id = 0;            // forum id for frontpage news.
$bugs_forum_id = 0;            // forum id for "bugtracker" forums

$templates = array('offlike');
$languages = array(
    'en' => 'English',
    'ru' => 'Russian',
    'de' => 'German',
    'hu' => 'Hungarian',
    'es' => 'Spanish'
);
?>

If you have some question... just ask it!

I hope this guide could be usefull for every one that wants to open a new 2.0.8 tbc server ;)

Cya.

By Hakuji.

[MentaL]

[Hakuji]

added eighth step for Part 8... for set-up web portal proprieties ;) (i've forgot it :P)

[pidarasss]

transport is working ? or ships ? explore ?

[Soliphied]

hi i am new and i want have a new web link for sql_account_extend.sql. Have a good day ;)

[seanterisu]

I fixed my problem with working with commands, but now whenever I try to look at my character's attributes, the game locks up and gives me an error which is far too long to post in here... dunno what's wrong with it :/

[shadowflare]

Question, the link in step 3 doesnt work for me. do i have to go to that link?

[sidieous77]

ok got it all working but for some reason cant get past the relm list it wont let me in the actual game someone plz hep me this is the closest ive come in 5 days to a working server for me and a few friends that are too poor to pay blizz lol

[sidieous77]

shadowflare make sure nothing like skype or yahoo msnger is useing a port and try

[iNViSiGOD]

ok got it all working but for some reason cant get past the relm list it wont let me in the actual game someone plz hep me this is the closest ive come in 5 days to a working server for me and a few friends that are too poor to pay blizz lol

Make sure your default worldport setting in the mangos.conf matches the same port number listed in your realmlist located under your realmd database.

[sidieous77]

ok well got over that hurdle now its telling me that i dont have burning crusades and that i need to go to blizzards website
ill work on it more later and try to get it up ty for your help

[sidieous77]

yay were working now only one minor issue i dont know what file to change to make myself a gm and this is a must because a few things i need to change someone plz tell me what file it is i need to change my pl to 6 and where its located and ty for this actual working guide better than some of the stuff out there:jester:

[g0d_anubis]

i have a problem .... when i click on the players online or realm status it says that the server is off .... how can i fix it .... ive folowed the guide ... but still dosent work .... pls help

[Dunkmydonuts]

ok, im on step 7, where is the realmlist.wtf file located? its not in the Mangos folder i made... should it be???

[XWoW]

I have a small problem. I can get the website to show up on my web browser with 127.0.0.1:1337 we've set the Listen 80 to Listen 1337 and unblocked the port, the realm and server/game runs fine, we simply can't get the website to show up for other players to register accounts...any idea why, or how to resolve this problem?

[prozah]

First of all you must have World of Warcraft: The Buning Crusade 2.0.8
you can download patches from Here

PART 1: DOWNLOADS

1. Download SQLyog at SQLyog Downloads Page

2. Download the latest version of EasyPHP at EasyPHP Downloads Page

3. Download the server:

DOWNLOAD LINKS BY DJRavine:

DOWNLOAD: MaNGOS v2.0.8 [COMPLETE].rar - 233.93MB [FileCrocodile.com]
DOWNLOAD: MaNGOS v2.0.8 [COMPLETE].rar - 233.93MB [SendSpace]
DOWNLOAD: MaNGOS v2.0.8 [COMPLETE].rar - 233.93MB [UpLoading.com]


PART 2: INSTALL

1. Install EasyPHP

2. Install SQLyog

3. Extract MaNGOS_TBC_v2.0.8_COMPLETE.rar to "C:\Mangos"

PART 3: SETTING UP YOUR PASSWORD

1. Run EasyPHP (Be sure that Apache and Mysql are on "Running" status, right-click on his icon in trayicon, on the bottom-right side of the screen, and click Run or press F2)

2. Open your EasyPHP folder (Eg. C:\Program files\EasyPHP 2.0b1) and copy phpmyadmin folder in www folder.

3. Open your browser and go to http://127.0.0.1/phpmyadmin

4. Click on Privileges

5. Click Edit Privileges of root user (the right sided icon with a guy with a pencil)

6. Edit there your password (it will be usefull for mangosd.exe and realmd.exe connection to databases)

PART 4: SETTING UP YOUR DATABASES

1. Now open SQLyog

2. Put "localhost" as MySQL Host Address, "root" as User Name, the password of your database as Password and "3306" as port

3. Click Save and then click on Connect

4. Right-Click on root@localhost group and then select "Create Database"

5. Type "mangos"

6. Repeat step 4 and then step 5 but type "realmd" instead of mangos this time

7. Now right-click on mangos database and select "Restore From SQL Dump"

8. Find the mangos_bc.sql and load it (it should be in "C:\mangos\sql" folder)

9. Wait a little and then repeat step 7 but now for realmd database

10. Same as step 8 but now you've to load realmd.sql

PART 5: SETTING UP REALM(realmd.exe) AND WORLD(mangosd.exe) CONNECTIONS

1. In C:\Mangos folder open realmd.conf with notepad.

2. edit LoginDatabaseInfo like this -> LoginDatabaseInfo = "localhost;3306;root;mypass;realmd" (delete "mypass" and type your password that you've set up in phpmyadmin)

3. Now open realmd.conf with notepad.

4. edit LoginDatabaseInfo as in step 2 and
WorldDatabaseInfo like this -> WorldDatabaseInfo = "127.0.0.1;3306;root;mypass;mangos"

PART 6: RUN YOUR SERVER

1. Run realmd.exe

2. Run mangosd.exe

PART 7: SET UP YOUR CLIENT TO CONNECT TO YOUR SERVER

1. Open realmlist.wtf with notepad.

2. Delete everything and type: "set realmlist 127.0.0.1" (or "set realmlist <your ip>)

Part 8(Optional): INSTALL WEB PORTAL

1. Download Web Portal (Link By BurningDappa from forum.wowps.com)

2. Extract it on your www EasyPHP folder ("C:\Program Files\EasyPHP 2.0b1\www" or something like that)

3. Now Open SQLyog

4. Connect into your sql server

5. Right-Click on realmd database database and select "Restore From SQL Dump"

6. Load "sql_account_extends.sql" in sql folder ("C:\Program Files\EasyPHP 2.0b1\www\sql" or where you've extracted the web portal)

7. Do step 5 and then step 6 for "sql_newtables.sql" and then in "C:\Program Files\EasyPHP 2.0b1\www\sql\updates" load 22.sql

8. Edit config.php in www folder like this:

<?php
$config = array(
'template'       => 'offlike', //Default template
'lang'           => 'en',        // Default language
'db_type'        => 'mysql', //Database type
'db_host'        => '127.0.0.1', //Database IP
'db_port'        => '3306', // Database Port
'db_username'    => 'root',// Database Username
'db_password'    => 'mypass',// Database Password
'db_name'        => 'realmd', //Name of Realm Database
'db_encoding'    => 'CP1251'     // Very important, check your mysql "my.ini"
);

$news_forum_id = 0;            // forum id for frontpage news.
$bugs_forum_id = 0;            // forum id for "bugtracker" forums

$templates = array('offlike');
$languages = array(
    'en' => 'English',
    'ru' => 'Russian',
    'de' => 'German',
    'hu' => 'Hungarian',
    'es' => 'Spanish'
);
?>

If you have some question... just ask it!

I hope this guide could be usefull for every one that wants to open a new 2.0.8 tbc server ;)

Cya.

By Hakuji.

man? hy !
7. Do step 5 and then step 6 for "sql_newtables.sql" and then in "C:\Program Files\EasyPHP 2.0b1\www\sql\updates" load 22.sql
what can i do it gives me an error like "There was an error while executing a query.
The query and the error message has been logged at:
C.
Please click on "Open Error File..." to open the error file."
what im must to do ? i wait an answer! thanks

[katmiaugo]

It does not enter the options of the administrator, I cannot add the news, aid please

[Shadoworcgz]

Why doesnt my realmd.exe and mangosd.exe stay up can somone help me and is it possible for somone too send me a nice copy of the mangosd.conf and realmd.conf I dont know how too set it up plz add me at Arttwod2@hotmail.com
or just post here plz and ty

[Niggel]

I want to play withe Hamahi, but if i wont Conect he dont past the realmlist it wont let me in the actual game

PLEASE HELP!!!!!

Sorry for Bad English i am German

[bboy1991]

some people say that you need an recomend system to run it but i dont think that.
i run an server its played by 60 ppl at 1 time and i run it on an p4 2.2ghz 512mb Ram computer:sq_yellow

[unknownn]

Okay... I have set up my server through a remote sql server... both the mangosd.exe and realmd.exe work and load... but when i go to connect to the server, i put in the login information and it gets up to the "Success" and stops.... can anyone help me out on this?

[Shadoworcgz]

Il help if u give me GM when its fixed lawlz

[unknownn]

I could do that, but I need more players as well... :P What i need is to get this working though, so I will do that... :P

[Anhi]

My admin panel is bugged the error is : "Admin panel Dont Work !" WHY ?

[killervalon]

can you extract the Folder to other than C:\Mangos ??

[bateiv4o]

sql_newtables.sql this is my problem. i can't load it (in part 8) pls tell me what to do ?