How to make your own WoW server (TBC!)

[Xirus]

How to make your own WOW private server TBC 2.0.12 UPDATED...


now this is mutch more easy then you think.. follow the guide and have your own server in less then 10-15 min..

1. Requirements:

- first of all you must have game client version 2.0.12 enGB or enUS PROPERLY installed!!! get the patches here if u dont got em
http://www.wowfiles.org/ if that one is down (it sometimes is) try this one http://a.wirebrain.de/wow/

- Microsoft .NET framework 1.1 = http://www.microsoft.com/downloads/d...displaylang=en

framework 2.0 = http://www.microsoft.com/downloads/d...displaylang=en

and framework 3.0 = http://www.microsoft.com/downloads/d...displaylang=en


- MaNGOS server (TBC)- download here http://www.sendspace.com/file/j6hxmq


- MaNGOS database (TBC) - http://sdb.unix7.net/forums/ (you must log in on the forum to get it..)
to make this guide very easy ill save you the time to search for it at the forum.. http://sdb.unix7.net/forums/index.php?showtopic=7055


- Mangos tools are optional but good to have (26MB) - SQLyog, Minimanager - http://www.sendspace.com/file/zn2l2t


- An to the last Mysql server 5.0 http://dev.mysql.com/downloads/mysql/5.0.html


Now make a new folder and put the files you downloaded in it.. it should be: mangos database,mangosserver,Mysql server and mangos tools in the folder... these files you should keep even when your done if you need to uinstall everything (that happens when you try to put other stuff in later that dont work and fucks it up for you when you start your server... backup is good..) the framework downloads you just install and trow away..

and one last thing... i did think most did know this but you need a program to open rar files... winace is a good one..



2. Installation:

(now also in video) ----->

http://www.youtube.com/watch?v=CZzj9fiHPMA

1 - Launch the MySQL installation application. (Setup.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 changed to "root"
When prompted select "Modify Security Settings". In the two empty dialog boxes, type in the password "mangos"
(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.)

2 - now install mangos tools

3 - install MaNGOS server wich will automatically extract all needed data, so it will be running for ~ 10 minutes!

4 - copy MaNGOS database SDB.SQL to C:/MANGOS/SQL/

5 - Now go into C:/Mangos/tools and you will find SQLog.exe push it and follow the wizard

- now you should have gotten a shortcut on the desktop.. push it.. then conect.. right click on MANGOS database in SQLyog, ( u then select IMPORT BATCH FILE and select SDB.SQL from C:/MANGOS/SQL/ and import it (just click OK) Execute

6 - Extract map files (not all need too do this)


- Place ad.exe into. ("C:\World of Warcraft") it might be in C/mangos or allready in C:\World of Warcraft
Create a subdirectory called 'maps'. ("C:\World of Warcraft\maps")
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, copy the folder "C:\World of Warcraft\maps" and place it in your ManGOS server directory ("C:\MaNGOS"). So you should now have a "C:\MaNGOS\maps" directory containing numerous (2400+) .map files.


- now you can give yourself a clap on the shoulder.. its only the easy stuff left now

- if you have old database lower than version 3500 then you have to import sql files from C:/MANGOS/SQL/UPDATES/

7. Config files
- configure MANGOS.CONF & REALMD.CONF for your needs, but they are already configured for default system (you can change exp,highest level and gold rate in the mangos.conf after your need and mutch more just save the file when you are done....but no need for that yet..)

8. Accounts
- you make an account by going into SQLyog then push on realmd (leftside) now you got a list.. then push account now
push table data (lower right side) put in username,password after your own wish and gm level (3 is good)
here you also put an 1 where it says tbc if you want to be able to enter outland now push the save button (the littel disk.. lol..) to change the realm name push realmlist in realmd.. now change the name and save

9. Starting server
- click MaNGOS restarter on your desktop!
now if you did all this should here a beep when the server is ready.. (takes 5-10 sec after you push the desktop ikon)
when you here the beep you are done

dont use the desktop shortcut by the way... use wow.exe in your wow folder.. also in your wow folder you got a file called realmlist.wtf open it with word or something and
change it to: set realmlist 127.0.0.1

now log in to your account by typing the accountname/password you picked...

You are now ready to rule your world

if this guide did help you like it should you may rep me for it(the green arrowup)
let me know what you think.. did i miss something pls tell.. hope you did enjoy reading it anyway...

FOR FUN :

now when you are in... type ".commands" without the "" in the textbox to see your power..

Try out ".modify fly 10" ( push enter) now type ".flymode on" (enter) and try to jump


Note:
if you set level 255 you will only have level 70 stats anyway.. right now they only have stats up to 255 for for non tbc databases..
this they are working on as we speak (lev70-255 stats) i will put in an link for it when i see its done...
"edit" i see i can go up to lev 215 with the stats of 215 but when i reach 220 it jumps down to 70 stats... might just be on my server..
and yes it is a command so that you can get bigger stats crits... so that you dont need the level part...

the power never stop

If you got an Q

if you get an error you got a text file in your mangos folder called dberror open the text file and see what it says maybe the error is easy to fix..
if you got a Q about an error you get pls double check the steps in the guide or check the forum posts here before posting it or pm me... i might already answerd your Q to another..
if you are planing to uinstall then reinstall remember to check that you have uinstalled everything but the backup.. cause 2 of a file you really just want 1 of may cause an error...

[hydrax]

Is this completely safe?

[Xirus]

what you mean safe? its not really legal but that aint downloading movies either... the links is safe.. all the stuff is virus free..
if you think blizz is gone take you for it thats just stupid... if you even want to be most "safe" you dont have to host it for others...
you just use it for yourself... safe...? what is safe....? living aint safe....

[Toxik]

I use others Private Servers but I could consider making my own. My RL Friend has one (DarkWizards) and it hasn't been working lately so I have been bored. This is a really good guide though.

[hydrax]

Sorry I forgot to clarify...I meant safe as in virus free and you already answered that for me thanks...the only other question I have is if I am hosting one how will my friends be able to see it? I didn't see anything written about the microsoft framework link also...is that required?

[Xirus]

Originally Posted by Toxik

I use others Private Servers but I could consider making my own. My RL Friend has one (DarkWizards) and it hasn't been working lately so I have been bored. This is a really good guide though.

thx.. i have looked at many guides and stuff and tryed to make this guide as easy as possible.. i hope other people think that too...
if you try setting up your own server i wanne know if it was easy or something i can improve on the guide for others..

Originally Posted by hydrax

Sorry I forgot to clarify...I meant safe as in virus free and you already answered that for me thanks...the only other question I have is if I am hosting one how will my friends be able to see it? I didn't see anything written about the microsoft framework link also...is that required?

yes it is required.. dont remb why again... i been up late now.. you can change the adress in SQLyog and your friends put that in their realmlist like when they play on other private servers... you can easy make an account for them in SQLyog with password and accountname..

hope that helped

if you find it hard ill put out an step by step guide for that too..

[hydrax]

Originally Posted by Xirus

yes it is required.. dont remb why again... i been up late now.. you can change the adress in SQLyog and your friends put that in their realmlist like when they play on other private servers... you can easy make an account for them in SQLyog with password and accountname..

hope that helped

if you find it hard ill put out an step by step guide for that too..

thank Xirus I will give it a shot...one of the sites is changing URL so I have to wait a bit.

[Xirus]

hmm i have taken a look at what i have done to make friends join... ill put out a miniguide for lan/non lan yes... well.. i will edit it in the guide anyway.. but not right now.. sleepytime..

[tumzone]

that website is down well i'll wait well after i install this patch 2.0.12 , use exe that for live server right?

[Xirus]

ill put in a new link for the patches... 2 sec.. http://a.wirebrain.de/wow/
enjoy...

[Xirus]

Originally Posted by tumzone

that website is down well i'll wait well after i install this patch 2.0.12 , use exe that for live server right?

i dont get the Q you ask... so far i have not made the miniguide "how to make it possible for others to join your server" if thats what you are asking..

[tumzone]

[7. Starting server
- click MaNGOS restarter on your desktop!
now if you did all this should here a beep when the server is ready.. (takes 5-10 sec after you push the desktop ikon)
when you here the beep you are done
now log in to your account by typing the accountname/password you picked...

after i clicked on MaNGOS restarter nothing happened only cmd mode turn on and off over and over, did i do something wrong?

[Xirus]

Originally Posted by tumzone

[7. Starting server
- click MaNGOS restarter on your desktop!
now if you did all this should here a beep when the server is ready.. (takes 5-10 sec after you push the desktop ikon)
when you here the beep you are done
now log in to your account by typing the accountname/password you picked...

after i clicked on MaNGOS restarter nothing happened only cmd mode turn on and off over and over, did i do something wrong?

did you execute the SDB.sql?

if you read the guide and follow the steps 1 by 1 all should work.. only reason i could see for this guide to dont work is if you dont use windows...

[tumzone]

2007-05-18 23:59:36 Using configuration file mangosd.conf.
2007-05-18 23:59:36 MaNGOS daemon /0.7-SVN (Win32)
2007-05-18 23:59:36 <Ctrl-C> to stop.


MM MM MM MM MMMMM MMMM MMMMM
MM MM MM MM MMM MMM MM MM MMM MMM
MMM MMM MMM MM MMM MMM MM MM MMM
MM M MM MMMM MM MMM MM MM MMM
MM M MM MMMMM MM MMMM MMM MM MM MMM
MM M MM M MMM MM MMM MMMMMMM MM MM MMM
MM MM MMM MM MM MM MMM MM MM MMM
MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
MM MM MM MMM MM MM MMMMMM MMMM MMMMM
MM MMM http://www.mangosproject.org
MMMMMM


2007-05-18 23:59:36 World Database: 127.0.0.1;3306;root;mangos;mangos
2007-05-18 23:59:36 Login Database: 127.0.0.1;3306;root;mangos;realmd
2007-05-18 23:59:36 Realm running as realm ID 1
2007-05-18 23:59:36 Using DataDir ./
2007-05-18 23:59:36 ERROR:Check existing of map file './maps/0004331.map': not exist!
2007-05-18 23:59:36 ERROR:Correct *.map files not found in path './maps'. Please place *.map files in the directory pointed by this path or correct the DataDir value in the mangosd.conf file.

i found it where can i get those maps?

[Xirus]

Originally Posted by tumzone

yes i did . . . . umm what should i do plz help

well go into C/mangos in it it should be a textfile named dberrors... what does it say?

[tumzone]

Originally Posted by Xirus

well go into C/mangos in it it should be a textfile named dberrors... what does it say?

2007-05-18 23:59:36 Using configuration file mangosd.conf.
2007-05-18 23:59:36 MaNGOS daemon /0.7-SVN (Win32)
2007-05-18 23:59:36 <Ctrl-C> to stop.


MM MM MM MM MMMMM MMMM MMMMM
MM MM MM MM MMM MMM MM MM MMM MMM
MMM MMM MMM MM MMM MMM MM MM MMM
MM M MM MMMM MM MMM MM MM MMM
MM M MM MMMMM MM MMMM MMM MM MM MMM
MM M MM M MMM MM MMM MMMMMMM MM MM MMM
MM MM MMM MM MM MM MMM MM MM MMM
MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
MM MM MM MMM MM MM MMMMMM MMMM MMMMM
MM MMM http://www.mangosproject.org
MMMMMM


2007-05-18 23:59:36 World Database: 127.0.0.1;3306;root;mangos;mangos
2007-05-18 23:59:36 Login Database: 127.0.0.1;3306;root;mangos;realmd
2007-05-18 23:59:36 Realm running as realm ID 1
2007-05-18 23:59:36 Using DataDir ./
2007-05-18 23:59:36 ERROR:Check existing of map file './maps/0004331.map': not exist!
2007-05-18 23:59:36 ERROR:Correct *.map files not found in path './maps'. Please place *.map files in the directory pointed by this path or correct the DataDir value in the mangosd.conf file.

[Xirus]

Originally Posted by tumzone

2007-05-18 23:59:36 Using configuration file mangosd.conf.
2007-05-18 23:59:36 MaNGOS daemon /0.7-SVN (Win32)
2007-05-18 23:59:36 <Ctrl-C> to stop.


MM MM MM MM MMMMM MMMM MMMMM
MM MM MM MM MMM MMM MM MM MMM MMM
MMM MMM MMM MM MMM MMM MM MM MMM
MM M MM MMMM MM MMM MM MM MMM
MM M MM MMMMM MM MMMM MMM MM MM MMM
MM M MM M MMM MM MMM MMMMMMM MM MM MMM
MM MM MMM MM MM MM MMM MM MM MMM
MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
MM MM MM MMM MM MM MMMMMM MMMM MMMMM
MM MMM http://www.mangosproject.org
MMMMMM


2007-05-18 23:59:36 World Database: 127.0.0.1;3306;root;mangos;mangos
2007-05-18 23:59:36 Login Database: 127.0.0.1;3306;root;mangos;realmd
2007-05-18 23:59:36 Realm running as realm ID 1
2007-05-18 23:59:36 Using DataDir ./
2007-05-18 23:59:36 ERROR:Check existing of map file './maps/0004331.map': not exist!
2007-05-18 23:59:36 ERROR:Correct *.map files not found in path './maps'. Please place *.map files in the directory pointed by this path or correct the DataDir value in the mangosd.conf file.

i found it where can i get those maps?

oh... 2 sec ill fix it for you... here


Extract map files


Place ad.exe into. ("C:\World of Warcraft") it might be in C/mangos or allready in C:\World of Warcraft
Create a subdirectory called 'maps'. ("C:\World of Warcraft\maps")
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, copy the folder "C:\World of Warcraft\maps" and place it in your ManGOS server directory ("C:\MaNGOS"). So you should now have a "C:\MaNGOS\maps" directory containing numerous (2400+) .map files.

[tumzone]

now i got another error plz

2007-05-19 01:27:12 ERROR:
Incorrect DataDir value in mangosd.conf or ALL required *.dbc files (31) not found by path: ./dbc

[Xirus]

Originally Posted by tumzone

now i got another error plz

2007-05-19 01:27:12 ERROR:
Incorrect DataDir value in mangosd.conf or ALL required *.dbc files (31) not found by path: ./dbc

ok i dont know how it ended this way.. but it sounds a bit messy.. i think you should uinstall and start back over (u still have the backup files in the folder you did put the downloads in so you dont have to download atleast..) + log into on http://www.mangosproject.org/forum/
and view this link http://www.mangosproject.org/forum/i...showtopic=7883 it should cover the most

still i dont see why you had to send over the map files and all that stuff and i dont.. oh well..

[tumzone]

woot i finally made it but some skill dosn't work like Arcane Power ,trinket of hero cham and some skill dosn't work too.

[Xirus]

Originally Posted by tumzone

woot i finally made it but some skill dosn't work like Arcane Power ,trinket of hero cham and some skill dosn't work too.

that are some bugs that they work on... its some other stuff to... at mangosproject they drop new updates now and then to fix bugs..
(many have the skills to fix the bugs themself but i find codeing stuff rather hard.. i could learn it but i wont go that deep i think..)


and gratz

[scark1]

Im a hugely confused with step 3 - copy / install MaNGOS database (usually SDB.SQL) to C:/MANGOS/SQL/

[tumzone]

hi if i want to Lan my server with other computer what should i do?

[Xirus]

Originally Posted by tumzone

hi if i want to Lan my server with other computer what should i do?

il put out a littel guide how to host with lan or behind a router.... comming soon...

cause i test the stuff myself to try to make the most easy guide.. i could take it from another page but then i cant answer your Q...

Originally Posted by scark1

Im a hugely confused with step 3 - copy / install MaNGOS database (usually SDB.SQL) to C:/MANGOS/SQL/

if you did follow the installs you should have file called SDB_0_6_4_full.sql this is the file i called SDB.SQL..
and you take this file into your folder SQL (inside your mangos folder) and put it there.. (remember to open the rar.file so that you only the text file in..) now continue the guide

[NICKx213]

ok ive installed everything and ive made my account and i started mangos restarter and i heard the beep and everything but how do i start up the game? cuz i started WoW like i normally would with the icon on my desktop but when i try to login with the acc name i have on SQLyog it doesnt work... wat do i have to do?

[Xirus]

Originally Posted by NICKx213

ok ive installed everything and ive made my account and i started mangos restarter and i heard the beep and everything but how do i start up the game? cuz i started WoW like i normally would with the icon on my desktop but when i try to login with the acc name i have on SQLyog it doesnt work... wat do i have to do?

your realmlist in your wow folder should say 127.0.0.1 just change it if it say wowblablabla change it into

set realmlist 127.0.0.1 and then save... try now...

oh and another thing many have problems when they use the desktop icon...try using the wow icon in your wow folder...

[iownwow132]

Hey I used your private server intstructions and everytime i click on Mangos for my server, this black screen with grey writing appears and when i looked at it i saw the word Error. It keeps restarted over and over and over and i dont know what to do... can you please help me?

[iownwow132]

ok i found out the stuff its saying... please help me with this

2007-05-20 17:45:05 Using configuration file mangosd.conf.
2007-05-20 17:45:05 MaNGOS daemon /0.7-SVN (Win32)
2007-05-20 17:45:05 <Ctrl-C> to stop.


MM MM MM MM MMMMM MMMM MMMMM
MM MM MM MM MMM MMM MM MM MMM MMM
MMM MMM MMM MM MMM MMM MM MM MMM
MM M MM MMMM MM MMM MM MM MMM
MM M MM MMMMM MM MMMM MMM MM MM MMM
MM M MM M MMM MM MMM MMMMMMM MM MM MMM
MM MM MMM MM MM MM MMM MM MM MMM
MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
MM MM MM MMM MM MM MMMMMM MMMM MMMMM
MM MMM http://www.mangosproject.org
MMMMMM


2007-05-20 17:45:05 World Database: 127.0.0.1;3306;root;mangos;mangos
2007-05-20 17:45:05 Login Database: 127.0.0.1;3306;root;mangos;realmd
2007-05-20 17:45:05 Realm running as realm ID 1
2007-05-20 17:45:05 ERROR:SQL: UPDATE `character` SET `online` = 0
2007-05-20 17:45:05 ERROR:SQL ERROR: Table 'mangos.character' doesn't exist
2007-05-20 17:45:05 Using DataDir ./
2007-05-20 17:45:05 ERROR:SQL: DELETE FROM `corpse` WHERE `bones_flag` = '1'
2007-05-20 17:45:05 ERROR:SQL ERROR: Table 'mangos.corpse' doesn't exist
2007-05-20 17:45:05 Initialize data stores...
2007-05-20 17:45:06
2007-05-20 17:45:06 >> Loaded 31 data stores
2007-05-20 17:45:06
2007-05-20 17:45:06 Cleaning up instances...
2007-05-20 17:45:06 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `creature_respawn` WHERE `instance` <> 0
2007-05-20 17:45:06 ERROR:query ERROR: Table 'mangos.creature_respawn' doesn't exist
2007-05-20 17:45:06 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `gameobject_respawn` WHERE `instance` <> 0
2007-05-20 17:45:06 ERROR:query ERROR: Table 'mangos.gameobject_respawn' doesn't exist
2007-05-20 17:45:06 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `character_instance`
2007-05-20 17:45:06 ERROR:query ERROR: Table 'mangos.character_instance' doesn't exist
2007-05-20 17:45:06 ERROR:SQL: SELECT `id` FROM `instance`
2007-05-20 17:45:06 ERROR:query ERROR: Table 'mangos.instance' doesn't exist
2007-05-20 17:45:06 ERROR:SQL: SELECT DISTINCT(`instance`.`id`) AS `id` FROM `instance` LEFT JOIN `character_instance` ON (`character_instance`.`instance` = `instance`.`id`) WHERE (`instance`.`id` = `character_instance`.`instance`) AND (`instance`.`resettime` > 1179697506)
2007-05-20 17:45:06 ERROR:query ERROR: Table 'mangos.instance' doesn't exist
2007-05-20 17:45:06
2007-05-20 17:45:06 >> Initialized 0 instances, deleted 0 old instances
2007-05-20 17:45:06 Packing instances...
2007-05-20 17:45:06 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `character_instance` WHERE `instance` <> 0
2007-05-20 17:45:06 ERROR:query ERROR: Table 'mangos.character_instance' doesn't exist
2007-05-20 17:45:06
2007-05-20 17:45:06 >> Instance numbers remapped, next instance id is 1
2007-05-20 17:45:06 Loading Game Object Templates...
2007-05-20 17:45:06 ERROR:SQL: SELECT MA`entry`) FROM `gameobject_template`
2007-05-20 17:45:06 ERROR:query ERROR: Table 'mangos.gameobject_template' doesn't exist
2007-05-20 17:45:06 ERROR:Error loading `gameobject_template` table (not exist?)

[Xirus]

Originally Posted by iownwow132

ok i found out the stuff its saying... please help me with this

2007-05-20 17:45:05 Using configuration file mangosd.conf.
2007-05-20 17:45:05 MaNGOS daemon /0.7-SVN (Win32)
2007-05-20 17:45:05 <Ctrl-C> to stop.


MM MM MM MM MMMMM MMMM MMMMM
MM MM MM MM MMM MMM MM MM MMM MMM
MMM MMM MMM MM MMM MMM MM MM MMM
MM M MM MMMM MM MMM MM MM MMM
MM M MM MMMMM MM MMMM MMM MM MM MMM
MM M MM M MMM MM MMM MMMMMMM MM MM MMM
MM MM MMM MM MM MM MMM MM MM MMM
MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
MM MM MM MMM MM MM MMMMMM MMMM MMMMM
MM MMM http://www.mangosproject.org
MMMMMM


2007-05-20 17:45:05 World Database: 127.0.0.1;3306;root;mangos;mangos
2007-05-20 17:45:05 Login Database: 127.0.0.1;3306;root;mangos;realmd
2007-05-20 17:45:05 Realm running as realm ID 1
2007-05-20 17:45:05 ERROR:SQL: UPDATE `character` SET `online` = 0
2007-05-20 17:45:05 ERROR:SQL ERROR: Table 'mangos.character' doesn't exist
2007-05-20 17:45:05 Using DataDir ./
2007-05-20 17:45:05 ERROR:SQL: DELETE FROM `corpse` WHERE `bones_flag` = '1'
2007-05-20 17:45:05 ERROR:SQL ERROR: Table 'mangos.corpse' doesn't exist
2007-05-20 17:45:05 Initialize data stores...
2007-05-20 17:45:06
2007-05-20 17:45:06 >> Loaded 31 data stores
2007-05-20 17:45:06
2007-05-20 17:45:06 Cleaning up instances...
2007-05-20 17:45:06 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `creature_respawn` WHERE `instance` <> 0
2007-05-20 17:45:06 ERROR:query ERROR: Table 'mangos.creature_respawn' doesn't exist
2007-05-20 17:45:06 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `gameobject_respawn` WHERE `instance` <> 0
2007-05-20 17:45:06 ERROR:query ERROR: Table 'mangos.gameobject_respawn' doesn't exist
2007-