Forrest's Idiot-proof Guide to Setting Up Your Own MangoS Server

[Forrest]

Ok I will try redo that xtraction thingy - tomorrow, my brother needs my comfort on bioshock lolz

And yes you reminded me a thing, I have not the US version of WoW instead the GB, you think it is ok just rename wat is called enGB to enUS? That's wat I had to do - trick it
And yes I got the same ammount of files as you in TBS map


Ohhh.... just fixed it, didn't realized when copying those you need the files direktly on the dbc place xD

Hm, I am so close finish this, but when I start ManGos.exe it loads a lot, say some errors to A LOT of quests or something and begins a ritual of an endless moving of some places....
When I tried dump 5108_characters.sql into mangos server I got an error and I couldn't do it.... might be there I have the trouble start Mangos, but how to fix that? Opening error file and I get a empty notepad... and yes, I've updated the map usin tourtoise and ewen managed to find that and download it separarly....

Mastis, 5108_characters.sql, from the name of the file, it should be restored in your CHARACTERS database, not your MANGOS database. And your problem of having alot of errors when loading Mangosd.exe, its a incomplete database error, re-read the portion of this guide on restoring sql dumps and make sure you haven't missed anything. Read it? Read it AGAIN. Regards.

Type in the following in dos-prompt for enGB versions for your mpqe extractor: "mpqe.exe /p locale-engb.mpq dbfilesclient\*.dbc", "mpqe.exe patch-engb.mpq dbfilesclient\*.dbc" and "mpqe.exe patch-engb-2.mpq dbfilesclient\*.dbc"

[Mastis]

Mastis, 5108_characters.sql, from the name of the file, it should be restored in your CHARACTERS database, not your MANGOS database. And your problem of having alot of errors when loading Mangosd.exe, its a incomplete database error, re-read the portion of this guide on restoring sql dumps and make sure you haven't missed anything. Read it? Read it AGAIN. Regards.

Type in the following in dos-prompt for enGB versions for your mpqe extractor: "mpqe.exe /p locale-engb.mpq dbfilesclient*.dbc", "mpqe.exe patch-engb.mpq dbfilesclient*.dbc" and "mpqe.exe patch-engb-2.mpq dbfilesclient*.dbc"

Dump 5108_characters.sql in characters database but the error still exists
And when extracting the dbc files I get 2 files to many...

[Forrest]

Dump 5108_characters.sql in characters database but the error still exists
And when extracting the dbc files I get 2 files to many...

Don't worry if you have 2 files more than me Mastis, you're holding a different version of WoW. As to your dumping sql files problem, I would suggest that you empty ALL your databases and start all over following the sql dumping part of my guide closely without skipping any steps. With abit of patience, I'm sure it can be done.

[Mastis]

I've redone the databases, and now I jus got 1 error and that's still the mangos...

17:19:04 Table `quest_end_scripts` has not existing quest (Id: 4465) as script i
d
17:19:04 Table `quest_end_scripts` has not existing quest (Id: 4466) as script i
d
17:19:04 Table `quest_end_scripts` has not existing quest (Id: 4467) as script i
d
17:19:04 Table `quest_end_scripts` has not existing quest (Id: 505 as script i
d
17:19:04 Table `quest_end_scripts` has not existing quest (Id: 5059) as script i
d
17:19:04 Table `quest_end_scripts` has not existing quest (Id: 7786) as script i
d
17:19:04 Table `quest_end_scripts` has not existing quest (Id: 9565) as script i
d
17:19:04 Table `quest_end_scripts` has not existing quest (Id: 10289) as script
id
17:19:04 spell_scripts :
=17:19:04 Table `spell_scripts` has invalid quest (ID: 10923) in SCRIPT_COMMAND_
QUEST_EXPLORED in `datalong` for script id 39239
17:19:04 Table `spell_scripts` has invalid quest (ID: 5056) in SCRIPT_COMMAND_QU
EST_EXPLORED in `datalong` for script id 16796
=17:19:04 ========================================== 100%
17:19:04 >> Loaded 277 script definitions

17:19:04 button_scripts :
=17:19:04 ========================================== 100%
17:19:04 >> Loaded 19 script definitions

17:19:04 Initializing Scripts...
Scripts Library MaNGOSScript.dll was successfully loaded.
17:19:04 DEBUG:: Initialize game time and timers
17:19:04 Mail timer set to: 780, mail return is called every 1440 minutes
17:19:04 Starting Map System
17:19:04 Starting BattleGround System
=17:19:04 Loading map ./maps/4892929.map = 24%
17:19:04 Loading map ./maps/4893029.map
17:19:04 BatteGroundWS: BG objects and spirit guides spawned
=17:19:04 ========================================== 100%
17:19:04 >> Loaded 8 battlegrounds

17:19:04 Loading Transports...
=17:19:04 ========================================== 100%
17:19:04 >> Loaded 9 transports

17:19:04 Deleting expired bans...
17:19:04 Calculate next daily quest reset time...
17:19:04 Starting Game Event system...
17:19:04 GameEvent 3 "Darkmoon Faire (Terokkar Forest)" started.
17:19:04 GameEvent 16 "Gurubashi Arena Booty Run" started.
17:19:04 GameEvent 20 "Call to Arms: Arathi Basin!" started.
17:19:04 Next game event check in 6057 secondes.
17:19:04 Game Event system initialized.
17:19:04 WORLD: World initialized
17:19:05
17:19:05 mangosd process priority class set to HIGH
help - Display this help message.
broadcast - Announce in-game message.
create - Create account.
delete - Delete account and characters.
info - Display Server infomation.
uptime - Displays the server uptime.
motd - Change or display motd.
kick - Kick user.
ban - Ban account|ip.
listbans - List bans.
unban - Remove ban from account|ip.
setgm - Edit user privileges.
setpass - Set password for account.
setbc - Set user expansion allowed.
listgm - Display user privileges.
loadscripts - Load script library.
setloglevel - Set Log Level.
corpses - Manually call corpses erase global even code.
version - Display server version.
idleshutdown - Shutdown server with some delay when not active connections at s
erver.
shutdown - Shutdown server with some delay.
exit - Shutdown server NOW.
writepdump - Write a player dump to a file.
loadpdump - Load a player dump from a file.
saveall - Save all players.
send - Send message to a player.
tele - Teleport player to location.
plimit - Show or set player login limitations.
17:19:05
mangos>17:19:05 Menethil Harbor - Auberdine moved to -3523.732178 -628.891602 0.
000000 0
17:19:05 Menethil Harbor - Auberdine moved to -3600.942871 -643.600403 0.000000
0
17:19:05 Menethil Harbor - Auberdine moved to -3663.400635 -625.203918 0.000000
0
17:19:05 Teldrassil - Auberdine moved to 8477.710938 1233.387695 0.000000 1
17:19:05 Teldrassil - Auberdine moved to 8543.003906 1152.313965 0.000000 1
17:19:05 Teldrassil - Auberdine moved to 8534.299805 1017.963684 0.000000 1
17:19:05 Teldrassil - Auberdine moved to 8510.687500 887.278320 0.000000 1
17:19:05 Teldrassil - Auberdine moved to 8452.564453 826.837708 0.000000 1
17:19:05 Teldrassil - Auberdine moved to 8348.133789 803.345947 0.000000 1
17:19:05 Teldrassil - Auberdine moved to 8138.049316 764.671692 0.000000 1
17:19:05 Teldrassil - Auberdine moved to 7917.783203 752.641235 0.000000 1
17:19:05 Teldrassil - Auberdine moved to 7612.221191 747.083740 0.000000 1
17:19:05 Teldrassil - Auberdine moved to 7304.404785 650.353821 0.000000 1
17:19:05 Teldrassil - Auberdine moved to 6968.393066 577.969604 0.000000 1
17:19:05 Teldrassil - Auberdine moved to 6816.708496 572.039856 0.000000 1
17:19:05 Teldrassil - Auberdine moved to 6682.596680 581.849304 0.000000 1
17:19:05 Teldrassil - Auberdine moved to 6569.318848 636.360779 0.000000 1
17:19:05 Teldrassil - Auberdine moved to 6594.591797 769.797485 0.000000 1
17:19:05 Teldrassil - Auberdine moved to 6639.033203 888.564575 0.000000 1
17:19:05 Grom'Gol Base Camp - Undercity moved to -12406.890625 211.837677 49.698
437 0
17:19:05 Grom'Gol Base Camp - Undercity moved to -12366.496094 34.187283 91.6149
67 0
17:19:05 Grom'Gol Base Camp - Undercity moved to -12302.458984 -85.874130 139.30
9540 0
17:19:05 Grom'Gol Base Camp - Undercity moved to -12184.920898 -257.317047 155.8
37738 0
17:19:05 Grom'Gol Base Camp - Undercity moved to -12007.930664 -390.698151 170.8
10257 0
17:19:05 Grom'Gol Base Camp - Undercity moved to -11704.909180 -408.353516 190.3
94821 0
17:19:05 Grom'Gol Base Camp - Undercity moved to -11440.033203 -401.015839 210.6
72516 0
17:19:05 Grom'Gol Base Camp - Undercity moved to -11372.654297 -402.066406 214.8
94485 0
17:19:05 Proudmore's Treasure moved to -4088.895752 -599.143433 0.000000 0
17:19:05 Proudmore's Treasure moved to -3996.335205 -611.284058 0.000000 0
17:19:05 Proudmore's Treasure moved to -3905.224854 -585.808472 0.000000 0
17:19:05 Proudmore's Treasure moved to -3832.377197 -521.335754 0.000000 0
17:19:05 Proudmore's Treasure moved to -3801.907959 -383.616852 0.000000 0
17:19:05 Grom'Gol Base Camp - Orgrimmar moved to -12464.008789 231.564774 49.534
367 0
17:19:05 Orgrimmar - Undercity moved to 1309.850220 -4707.400391 71.082626 1
17:19:05 Orgrimmar - Undercity moved to 1318.106812 -4658.046875 71.860428 1
17:19:05 Orgrimmar - Undercity moved to 1295.419189 -4555.832520 71.082626 1
17:19:05 Orgrimmar - Undercity moved to 1263.461060 -4536.258301 71.082626 1
17:19:05 Orgrimmar - Undercity moved to 1223.926270 -4564.258789 71.082626 1
17:19:05 Orgrimmar - Undercity moved to 1218.905640 -4625.025391 71.082626 1
17:19:05 Orgrimmar - Undercity moved to 1238.706665 -4700.279297 71.082626 1
17:19:05 Orgrimmar - Undercity moved to 1255.504517 -4831.162109 71.082626 1
17:19:05 Orgrimmar - Undercity moved to 1267.830200 -4961.873535 71.082626 1
17:19:05 Orgrimmar - Undercity moved to 1988.927368 779.695740 153.445450 0
17:19:05 Orgrimmar - Undercity moved to 1949.879150 599.789490 153.021271 0
17:19:05 Orgrimmar - Undercity moved to 1945.676636 465.378479 130.640030 0
17:19:05 Orgrimmar - Undercity moved to 1988.025146 342.534515 119.556183 0
17:19:05 Orgrimmar - Undercity moved to 2062.375977 292.998047 114.972954 0
17:19:05 Booty Bay Ship moved to -1154.220703 -3887.805176 0.000000 1
17:19:05 Booty Bay Ship moved to -1105.529419 -3824.107178 0.000000 1
17:19:05 Booty Bay Ship moved to -1058.489136 -3818.875488 0.000000 1
17:19:05 Booty Bay Ship moved to -1005.613403 -3841.647705 0.000000 1

This is how it looks like when I started ManGos in the end of it all.... so strange And the last move thing just seem to repeat itself with various places to move and places to move them to (notice errors in start and end of this)

[Forrest]

I've redone the databases, and now I jus got 1 error and that's still the mangos...

This is how it looks like when I started ManGos in the end of it all.... so strange And the last move thing just seem to repeat itself with various places to move and places to move them to (notice errors in start and end of this)

From what I can see, your mangos server is working. Just that your database is wrongly restored, if you really need professional help, you can add me on MSN. See my guide for my MSN contact. Rgds.

[Mastis]

From what I can see, your mangos server is working. Just that your database is wrongly restored, if you really need professional help, you can add me on MSN. See my guide for my MSN contact. Rgds.

I do so den, [email protected] will contact you, and I will try see if you are online at the times you posted theese posts and sutch (since that's my best thing to go on at the moment)

[Mastis]

I really tell you all ppl, this thing roxx!!! I can't w8 for more guides from forrest, when you see this guide you might take a deep breath and wonder if you have the guts go throught it all, and I tell you you got! And if not forrest is here you help you with it aswell

[bassist0587]

Awesome guide, very useful

[dudeman6790]

Awesome guide Forrest, I actually have been using mangoes for about a year and a half now. I just got done using this guide from the official site to update my server so friends could connect with out patching down there wow, I know a bit about programing to, If you ever get overwhelmed with questions, you can send some my way and i will get them answered to help you out. any ways, great post!

[ixiuz]

wtf.. do we need to pay for SQL or something.. cant you make this easyer on us??

[Rewcore]

I'm Having a Problem with opening up and installing Microsoft Platform SDK everytime i try to open it a window pops up saying

"The installation package could not be opened. Verify that the package exists and that you can access it, or contact the application vendor to verify that it is a valid Windows Installer Package"

Any help would be great.

[dudeman6790]

wtf.. do we need to pay for SQL or something.. cant you make this easyer on us??

No, are you using the MYSQL program? and if your talking about a connection client. You can download some sort of program and just continue reinstalling every time the client trial runs out.

I'm Having a Problem with opening up and installing Microsoft Platform SDK everytime i try to open it a window pops up saying

"The installation package could not be opened. Verify that the package exists and that you can access it, or contact the application vendor to verify that it is a valid Windows Installer Package"

Any help would be great.

I Had the exact same problem. i would suggest completely deleting the file, and then making sure you have net framework installed (needed for previous steps) and then download again and try to install again. To fix my problem i just downloaded a Pre- compiled binary.

I could email you the link of the compiled binary i used if you would like.

[Blast Jack]

Omg Thx! It works! Great Job!

[2dgreengiant]

not bad guide, slightly bigger font n some colors would be good

[Rewcore]

Yes could you plz send me that link