WoW Mangos 4488, ScriptDev2 134 with Project Silvermoon DB Rev17

Looks cool isn't it ?

I just compiled another Mangos revision and this time it is using Mangos SVN Revision 4488 with ScriptDev2 revision 134 (it’s clean compile without any other patch). As a note, i only tested on my own computer using World of Warcraft The Burning Crusade 2.1.3 enUS client, so if you’re using other client version i don’t know if it’s going to work or not with your wow tbc

The first file is to those who’s already have Mangos database installed and already configured, and don’t want to start all over again (i assume you already know on how to upgrade your mangos database) :) … so all you have to do is just importing the mangos core updates and the scriptdev2 sql into your database and you’re finished

Update : I just released the new Mangos 4505 with Scriptdev2 R136, so try using the new version instead :)

~~#1 – Mangos R4488 with ScriptDev2 R134 (DBC Extractor, VMaps Extractor and Map Extractor Included) (2.14MB)~~

While the second file, is to those who’s just want a fresh start or want to create their own private wow server for the first time (i know the pain of using slow internet connection to download large file). The only differences between this version with the above version is, this version include the Project Silvermoon Database Revision 17 (and all the necessary sql update already included too). So without further ado here are the steps :

~~#2 – Mangos R4488 with ScriptDev2 R134 and Full Database Dump (DBC Extractor, VMaps Extractor and Map Extractor Included) (9.98MB)~~

Update : To those who’s having problem on extracting the DBC files, i just uploaded mine (WoW-TBC-2.1.3–enUS DBC 2.85MB) … btw because i’m using the enUS client i’m not to sure if it’s going to with other region version, but it’s not hurt to try, right ?

Note : I assume you’ve configured and installed MySQL properly, if you want to know how to install MySQL, refer to my previous post about MySQL installation Guide for Windows

Note 2 : Adjust your World of Warcraft Game installation path accordingly

1. Extract the rar archive somewhere, for example C:\Mangos

2. Open Command Prompt

3. Execute these commands (must be in order) :

cd C:\Mangos\reaper-eazy-mangos
mysql -u root -p -v < drop_mysql.sql
mysql -u root -p -v < create_mysql.sql
mysql -u root -p -v -D realmd < realmd.sql
mysql -u root -p -v -D mangos < rx-mangos-4488-silvermoon17-scriptdev134.sql

4. Copy the ad.exe from MapExtractor Directory into C:\Program Files\World of Warcraft

5. Create new folder called maps, and then run the ad.exe … and wait until this process finished (don’t interrupt it)

6. Copy all files inside VmapExtractAssembler into C:\Program Files\World of Warcraft and run the makevmaps_SIMPLE.bat … and wait again until it finished

7. Copy all files inside DBC Extractor into C:\Program Files\World of Warcraft\Data\enUS … and run the extract.bat … and wait until it finished

8. Move vmaps, maps, and dbc folder from your World of Warcraft installation path into C:\Mangos\data (create folder named data first)

9. Open Mangosd.conf using Wordpad … and then find this line :

DataDir = "@prefix@/share/mangos"

Change it to :

"C:\Mangos\data"

10. Open realmlist.wtf file from C:\Program Files\World of Warcraft using Notepad and change the :

set realmlist us.logon.worldofwarcraft.com

into

set realmlist 127.0.0.1

11. Run Mangosd.exe and Realmd.exe …

12. At the Mangosd window type these :

create myusername mypassword

setgm myusername 3

13. Run World of Warcraft … and then login using myusername as username, and mypassword as password

14. Done …

Stairway to heaven :P

As a side note, if there’re many people downloading this … perhaps i’m going to simplify the steps in the future by creating batch file :)

And to those who prefer to see a detailed guide with images, feel free to look at my previous post about Creating WoW Private Server … enjoy ;)

And here’s for the list of Mangos GM Commands

P.S If i’m missing something just let me know about it

Comments Navigation 1 2 3 ... 6 Next »

Byzan said Sep 23, 2007 at 7:25 am

Just a question… is there any way to get past the raids holds on instances? I kinda wanna take on the world!! IE- Karazhan! :P But the raid issue is annoying… And WOW! The Spectral Swift Tiger looks awesome! You all should get one in your bags ;P

Thanks again!

Link to this comment Reply to this comment
Reaper-X said Sep 23, 2007 at 7:20 am

that’s great :) .. but im sure previously there’s something wrong with the configuration or .. you didn’t import the sql properly ;)

Link to this comment Reply to this comment
Seventh101 said Sep 23, 2007 at 6:27 am

Hey reaper. i rienstalled the entire thing and my server and it works perfectly now. pondering what i did wrong the last time but at least its working now.

Link to this comment Reply to this comment
Reaper-X said Sep 23, 2007 at 6:23 am

# tacd

ah lol actually i just tested it right away and no problem for me that’s why it took a while to reply to your and bryzan comment lol

btw here’s the link to the screenshot

and thanks for telling me about that weapon :P because well .. i know nothing about the wow game itself (this is why you should play on official server first in order to learn about the game itself) lol

# Bryzan

Cleaned up your uncompleted post ;)

btw glad you found the solution :D

Link to this comment Reply to this comment
tacd said Sep 23, 2007 at 6:08 am

nm works now

Link to this comment Reply to this comment
Byzan said Sep 23, 2007 at 6:05 am

Err…. That last post didnt work right! But yeah.. Thanks for all the work!!! And the Help! And yeah!!! So now lets get those GM codes… heh… And GM LAND TIME!!! woo! Thanks so much man! This has been awesome.

Link to this comment Reply to this comment
Byzan said Sep 23, 2007 at 6:03 am

ok then! Well nevermind… I was stupid and forgot a quotation mark!!! Thanks for the help overall though! I just hope this works after all of this, lol. If it doesn’t well.. EESH! This is gonna suck lol.

Nice Tutorial and awesome help though, regardless!

Link to this comment Reply to this comment
Byzan said Sep 23, 2007 at 5:59 am

Hmm.. Alright then.. It has something about my file link being wrong for mangos as to where to find the “data” path… It has it as completely contrary to what I put in earlier.. Infact, its missing a good few words even! So umm.. how do I re-edit this to see the correct file path?

Link to this comment Reply to this comment
tacd said Sep 23, 2007 at 5:54 am

hmm i got dual wield skill to work but when i try to wield “http://wow.allakhazam.com/db/item.html?witem=32837&locale=enUS;source=live” (Warglaive of Azzinoth set) my rogue keeps on saying “i’ll never be able to equip that”. what am i doing wrong?

Link to this comment Reply to this comment
Reaper-X said Sep 23, 2007 at 5:52 am

# Byzan

Open and close immediately ? aah … to see the error message, try opening the Server.log in your mangos directory

Link to this comment Reply to this comment
Byzan said Sep 23, 2007 at 5:47 am

Yeah… I just hit another issue for some reason or another! (Oh and thanks for that update! Still wouldn’t work.. and I also had to run everything under Administrator mode to get it to work.. Dern read/write privelges with Vista! Its a pain sometimes…)

But everytime I open Mangosd, It opens then closes immediately… I have no idea whats up with this so I was wondering if you could help me out there! Up The realmd sets up perfectly fine.. And when I tried this on the whole.. Shadowhunter repack of Mangos, the code would boot up. But anyway! If you could help me out with this issue :\ (And it lasts for less than a second on activation so I cant tell ya anything that its saying! :\)

Thanks again!

Link to this comment Reply to this comment
tacd said Sep 23, 2007 at 5:35 am

Aha! i kept on trying .lookupskill…. epic failure there! Thanks for your quick reply reaper. Got it working now woohoo.

Link to this comment Reply to this comment
Reaper-X said Sep 23, 2007 at 5:28 am

# Thomas

Could you tell me what’s inside the Server.log and Realmd.log

# Seventh101

Could you tell me what you’re trying to do when you get that message ?

from your description, it seems that you want to execute this sql query :

mangosmangos

# tacd

it’s working (actually dual wield works since the old mangos version)

you just need to type :

.lookupspell dual wield

or

.lookupspell dual

to get the skill id

and then type :

.learn IDNUMBER

that’s it :D

to see the screenshot look at my very first post about WoW

btw the screenshot was taken with mangos R3642 (which is the old version for WoW Classic only)

Link to this comment Reply to this comment
tacd said Sep 23, 2007 at 4:57 am

one question, does dual wield skill not work? cant get it to work by doing all the .learn all / .learn all_crafts, etc commands.

Link to this comment Reply to this comment
Seventh101 said Sep 23, 2007 at 4:33 am

I love this guid! best one on the internet.

Link to this comment Reply to this comment
Seventh101 said Sep 23, 2007 at 3:44 am

Hey reaper i’m having an issue with trying to run the mangos and realmd.exe files on my end. Ive done every thing els correctly but thes files just open and shut off real quick.

I decided to run sqlyog and when i tried to run the bat file from that it says

Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘mangosmangos’ at line 1
(0 ms taken)

Do I have to rienstall the whole thing or is there a way to get it to work correctly?

Link to this comment Reply to this comment
Thomas said Sep 23, 2007 at 3:07 am

Hi,

Firstly a great guide, but i got a problem.
Everything works up until i try to logon to the server: i just get “unable to connect” – and i’ve checked my realm list and it is set to 127.0.0.1. Besides that the server and realmd seem to start up fine :\

Any feed back would be greatly appreciated,
Thanks

Link to this comment Reply to this comment
Reaper-X said Sep 23, 2007 at 3:04 am

# Byzan

Since i havent tried vista yet (perhaps later if lots of application im using now, has been supported to work with vista :P)

You could try downloading the extracted files instead (just uploaded it few hours ago), the link to download it can be found under the Mangos with database dump

as a side note,

If you get this error message when running the extract.bat :

Fatal: Could not locate SFmpq.dll

copy the SFmpq.dll into the same directory as the MPQE.exe ;)

Link to this comment Reply to this comment
Byzan said Sep 23, 2007 at 2:23 am

Yeah- Im having an issue with the DBC extractor.

Everytime I go to run it, it says that it cannot find the file SFmpq file.. I am running vista so that could be part of the problem but I do not know what I can do to solve that problem… I hope you can help because so far, this has seemed like the most likely to work Emulator I’ve tried to use.

Thank you in advance for any help you could possibly give me! Great Tutorial! :)

Link to this comment Reply to this comment
Reaper-X said Sep 23, 2007 at 1:45 am

# tacd

Thanks tacd :)

# Noah

I just uploaded the DBC file extracted from WoW 2.1.3 enUS client, try looking at the update part to get the link

# Jbon007

If you’re looking for the extracted dbc files, see the update part ;)

Link to this comment Reply to this comment
Jbon007 said Sep 22, 2007 at 11:53 pm

i found out why my maps are incomplete…i didn’t the the \data\expansion in my WoW folder…any idea where can i get it? Thanks again!

Link to this comment Reply to this comment
Noah said Sep 22, 2007 at 11:47 pm

I still can’t get the DBC extractor to work. Ive tried changeing the filename and the filename in extract to the same thing but even that won’t work. Could there be a problem with the extractor itself? Thanks for helping.

Link to this comment Reply to this comment
tacd said Sep 22, 2007 at 11:29 pm

It worked, thanks! Looking forward to see more from you :)

Link to this comment Reply to this comment
Reaper-X said Sep 22, 2007 at 4:46 pm

# Teus

Well .. since i never played on official server i dont know much about it (i wish i could) … but i’m pretty sure that i managed to find bugs on the project silvermoon database, you can always report it to their forums directly ;)

http://projectsilvermoon.net/index.php

Have I wrong databases ? What can I do to fix this problem ?

as for temporary fix, you can always edit the database directly by using your favorite MySQL Client ;)

# Pete

If you’re using enGB client, try open the extract.bat file inside DBC Extractor directory using Notepad / Wordpad, and then change these :

locale-enUS.MPQ
patch-enUS.MPQ
patch-enUS-2.MPQ

into

locale-enGB.MPQ
patch-enGB.MPQ
patch-enGB-2.MPQ

btw if it’s for work you, let me know about it, i’ll add it in the future :)

# JBon007

I believe you didn’t extract the Maps files correctly, try running the Map Extractor, Vmaps Extractor, and DBC Extractor to fix it :)

# Noah

First you need to know which WoW version you’re using, and then change the Patch-enUS into your WoW Region ;) .. for example look at my answer to Pete question

# Dylan

You need to get Microsoft .NET 2 Runtime installed in order to run DBC Extractor :)

Click here to get .NET 2 Runtime

and then run the dbc extractor again

# Naomi Wiflath

I need some information first to see why you can’t connect to your server

so, open the Server.log file inside your mangos directory, and see what’s the error message

btw just in case you didnt know, you need to keep the Mangosd.exe and Realmd.exe running in background when you want to connect to your own server ;)

# ANdreN

You just need to wait for the VMaps assembler to assembly the VMaps files :)

Link to this comment Reply to this comment
ANdreN said Sep 22, 2007 at 3:23 pm

Hello i have a little problem with step 6. when i dothat step the Command Prompt start and then it works and works for a long time and now it says “Work complete. No errors.” but there are still vmap files coming in to the vmaips folder… what is wrong?

Link to this comment Reply to this comment
Naomi Wiflath said Sep 22, 2007 at 10:22 am

Hello again! Ive tried changing around the realmlist, but it still cant connect to my main server. Is it my realmlist? Its set to 127.0.0.1
Ty :)

Link to this comment Reply to this comment
dylan said Sep 22, 2007 at 9:42 am

i have it as
DataDir = “D:\Mangos\data”

as i have it in D :S

Link to this comment Reply to this comment
dylan said Sep 22, 2007 at 9:38 am

ok this sux… i just wnt a server i can screw around on >.>

Link to this comment Reply to this comment
dylan said Sep 22, 2007 at 9:28 am

no i mean it wont let me extract the dbc it just says this app i unable to start wtf?

Link to this comment Reply to this comment
Noah said Sep 22, 2007 at 8:09 am

I fixed my previous problem but now I see that my DBC files are outdated. So I tried to run the extractor and it gets to patch-enUS-2.MPQ then it says it could not be found, however I see the file in the folder. Thanks for helping.

Link to this comment Reply to this comment
Jbon007 said Sep 22, 2007 at 7:59 am

Hi Reaper,

First of all, thank you very much for your excellent guide! I really enjoyed myself playing my own server of WoW classic. But now when i tried to upgrade to tbc, i have this problem on mangosd.exe

The log display:

2007-09-21 20:50:07 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-09-21 20:50:07 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-09-21 20:50:07 Realm running as realm ID 1
2007-09-21 20:50:07 Using unknown world database.
2007-09-21 20:50:07 Using DataDir C:\Mangos\data/
2007-09-21 20:50:07 WORLD: VMap support included. LineOfSight:0, getHeight:0
2007-09-21 20:50:07 WORLD: VMap data directory is: C:\Mangos\data/vmaps
2007-09-21 20:50:07 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2007-09-21 20:50:07 ERROR:Check existing of map file ‘C:\Mangos\data/maps/5301243.map’: not exist!
2007-09-21 20:50:07 ERROR:Correct *.map files not found in path ‘C:\Mangos\data/maps’ or *.vmap/*vmdir files in ‘C:\Mangos\data/vmaps’. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.

I followed your step by step using the ‘Mangos R4488 with ScriptDev2 R134 and Full Database Dump’. I started from scratch again. I patch my WoW up until 2.1.3. I dont know where i went wrong. Please advice. Thanks!

Link to this comment Reply to this comment
Noah said Sep 22, 2007 at 7:41 am

I did all the steps until I did the create_mysql.sql file where it says:

Error 1146 (42S02)at line 1: Table mysql.user does not exist.

Link to this comment Reply to this comment
Pete said Sep 22, 2007 at 3:52 am

Followed every step exactly, once i try to log on it just says unable to connect, any ideas? I’m fully patched but on enGB, think this could be the cause?

Link to this comment Reply to this comment
Naomi Wiflath said Sep 22, 2007 at 2:00 am

Hey! I followed the instructions and everything seems to be working well- but I cannot connect to the server. I’ll log in, and it will give me the “unable to connect” message.
Also, how would I allow others to connect to me?
Thanks!

Link to this comment Reply to this comment
Teus said Sep 22, 2007 at 1:02 am

Great info !
Server work very well !

Only few questions: mobs appears “little” than official servers, and lev 1 yellow mobs around birth pg place (northshire, azuremyst isle, ecc) hits too strong than 1 level pg (240/250 pf per hit).

Have I wrong databases ? What can I do to fix this problem ?

Link to this comment Reply to this comment
Reaper-X said Sep 21, 2007 at 9:31 pm

First make sure you’ve .NET 2 Runtime from Microsoft installed on your computer (search microsoft.com website for NET Runtime)

as for mangos / ascent quickly flashes that’s because you didn’t configure it properly

make sure you’ve configured everything in mangosd.conf and realmd.conf

if you’re using this distribution of mangos and you’ve extracted the DBC, Vmaps, and Maps correctly

you just need to edit the DATADIR into the correct path and you’re done ;)

Link to this comment Reply to this comment
dylan said Sep 21, 2007 at 8:11 pm

ive also tried an antrix server and an acsent but each time i get to that stage nothing at all…. also just to add ive been trying to start up the realmd. before everything finished (:P) just to see something.. but the screen quickly flashes on then dissapears is this normal and do i have to wait for everything to finish or is that a complete and utter problem.. sorry for the 3 posts in a row thing

Link to this comment Reply to this comment
dylan said Sep 21, 2007 at 8:09 pm

ok wait to explain this easier il just type the whole thing out….

The application failed to initialize properly (0×0000135), Click on OK to terminate the application

Link to this comment Reply to this comment
dylan said Sep 21, 2007 at 8:06 pm

ok wtf when i try to run the batch file eve AFTER ive done the maps and vmaps it says it cant work or sum shit like ?????

Link to this comment Reply to this comment
Reaper-X said Sep 21, 2007 at 7:23 pm

Of course, basically SQLYog is just a 3rd party application designed to perform mysql related task easier

but as a reminder, you’ll need MySQL installed first in order for SQLYog to work ;)

as for mysql community edition gone from mysql .. im pretty sure you just didn’t notice the link to the community edition release ;) because they just redesigned their web site

click here to mysql community edition (open source, freeware)

and grab the 42.4 MB version

Link to this comment Reply to this comment
dylan said Sep 21, 2007 at 6:52 pm

can this be done with SQLyog as i cant find the community edition its just gone poof…..

Link to this comment Reply to this comment
Reaper-X said Sep 21, 2007 at 4:56 pm

it’s the window that launched after you run the mangosd.exe ;)

you’ll see that there are two window after you execute / run the mangosd.exe and realmd.exe, now you just need to type inside that window :)

Link to this comment Reply to this comment
Nevur said Sep 21, 2007 at 4:56 pm

figured it out. Had / instead of \ for the data dir. Don’t laugh, very tired!

Link to this comment Reply to this comment
Nevur said Sep 21, 2007 at 3:27 pm

Fixed, but I do not know what you mean by ‘mangosd window’. Where will I find it?

Link to this comment Reply to this comment
Nevur said Sep 21, 2007 at 3:09 pm

maybe I did something wrong. I noticed I had the same problem as prinnysquadleader and tried the fix, but it is still giving me the same error message.

Link to this comment Reply to this comment
Reaper-X said Sep 21, 2007 at 3:03 pm

Ah … actually you just need to type at the mangosd window where it shows you something like this :

tele – Teleport player to location.
mangos>

and the result would be like this

mangos> create myusername mypassword

and then

mangos> setgm myusername 3

to get the highest level of game master known as Administrator :P

Link to this comment Reply to this comment
Nevur said Sep 21, 2007 at 2:57 pm

I get stuck at step 12. I run mangosd.exe and realmd.exe, but I cannot figure out the prompt to create a username and password

Link to this comment Reply to this comment
Reaper-X said Sep 21, 2007 at 1:47 pm

Im really sorry packaged the wrong drop_mysql.sql

to fix it you just need to open the drop_mysql.sql using Wordpad

and then delete everything except for these two lines :

DROP DATABASE IF EXISTS `mangos` ;
DROP DATABASE IF EXISTS `realmd` ;

Link to this comment Reply to this comment
Prinnysquadleader said Sep 21, 2007 at 1:26 pm

I get this error entering the drop_mysql.sql command~ BTW great guide bro, I’ve set up other servers using this guide and it was a sinch, but this stumps me :X

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear ”localhost” at line 1

Link to this comment Reply to this comment
Prinnysquadleader said Sep 21, 2007 at 11:42 am

Hmmm for some odd reason, I get an improper syntax on the first step with the drop_mysql, but the other 3 work, is it something I’m doing wrong? I’m starting from scratch with this version so I dunno if the drop is releated to an update or what not.

Link to this comment Reply to this comment