Hello Everyone! Here is another one of my releases for the Reaper-X-MaNGOS-WoW Developement Project. In this release I have looked through my previous bugs/errors and have cleaned them out and I am almost positive that they all have been resolved. So if you have any questions comments or concerns please leave us a comment, when you do myself and the community will be glad to assist you!
Updated in this Revision:

REQUIREMENTS:
1. MySQL Database and the Guide on how to Install MySQL
2. World of Warcraft Client version 2.4.2
3. Updated DBC’s, VMAP’s, and MAPS Updated for 2.4.2!
DBC’s are already included as part of this release! Also if you already have the 2.4.2 DBC’s, Maps, and VMaps then there is no reason to extract them again.
4. Reaper-Mangos Server :
Reaper Mangos 5953 SD2 414 (UDB ONLY) FULL | 16.6 MB | File Beam
Reaper Mangos 5953 SD2 414 (UDB ONLY) FULL | 16.6 MB | Rapidshare
Reaper Mangos 5953 SD2 414 (UDB ONLY) FULL | 16.6 MB | Mega Upload
Reaper Mangos 5953 SD2 414 (UDB ONLY) FULL | 16.6 MB | Media Fire
Update:
Davtex from www.blitz.sk have uploaded vmaps and maps extracted from WoW 2.4.2 so to those who have problem perhaps can try downloading the extracted maps and vmaps files by Davtex ;)
2.4.2 Maps:
Vmaps from WoW 2.4.2:
Thanks to Davtex for uploading the maps and vmaps files
Custom Vendors Pack
http://filebeam.com/ba76aee3d934e0ab9d7e2f7c4d40452a
Credits to Firane for creating the Custom Vendors Pack
DBC and Maps Extractor:
Just in case the included ad.exe (map extractor) and dbc extractor isn’t working for you (like you keep getting message about maps or dbc file is not compatible), you can try using this one:
DBC and Map Extractor (131KB)
That archive just contain only one file (ad.exe) … and all you have to do is just put it into your WoW installation directory (where wow.exe and launcher.exe can be found) … and delete maps and dbc folder there if exist and then run the new ad.exe … and it’ll extract the maps and dbc files automatically (the output will be in maps and dbc directory)
Fresh Install:
Important Note : Fresh installation will overwrite your database
1. First you’ll need to install MySQL
2. Extracting Maps, DBC and VMaps from your World of Warcraft installation
(You can safely ignore the Patch-2, or any not found xxx-2 message)–This only happens if your extracting from patch 2.4.0
3. Run the reaper-x-mangos.bat inside the reaper-x-mangos folder, and you’ll see something like below image for an example, and then you just need to write the full path to your mysql installation directory (where mysql.exe and mysqldump.exe can be found) ;)

4. Selection Option 1 by pressing “1&Prime on the keyboard and pressing enter.
Note: This will wipe out any previous versions of WoW you have in your database.

6. After finished with all of the above process, all you have to do now is just open the realmlist.wtf file in your World of Warcraft installation directory (the default location can be found at C:\Program Files\World of Warcraft) using Notepad, Wordpad, or your favorite text editor and then …
Replace :
set realmlist us.logon.worldofwarcraft.com
set patchlist us.version.worldofwarcraft.com
With :
set realmlist 127.0.0.1
and then save it and close realmlist.wtf File.
7. Now you just need to run mangosd.exe and realmd.exe from your mangos directory and then the next step would be creating your own username with your desired password for your own WoW server account as shown on below image followed by typing setgm to give yourself a GM level account

By the way, if you can’t see what you should type inside the mangosd window from the above image, actually you just need to type :
create username password
to create the account
setgm username 1-3
to give yourself GM Access at certain level (3 is the highest level and should only be used on your account while normal player is 0)
8. Finally if you have Burning Crusade client installed and want to be able to create Burning Crusade specific character, all you have to do is just type :
setbc username 1
to enable burning crusade expansion for your account :)
Optional :
If you want to change the server name into something else, you can use the reaper-x-mangos.bat to adjust it :)
Upgrading from 5953 Release:
1. Re-extract vmaps, maps and dbc because this version no longer supports the old World of Warcraft 2.3.3 installation and only supports the new 2.4.2 (YOU MAY SKIP RE-EXTRACTING IF YOUR DBC’S, MAPS, AND VMAPS ARE ALREADY FROM A 2.4.2 CLIENT!)
2. Go into your WoW Reaper Server Directory, and open reaper-eazy-mangos. Next I recommend opening the batch file and backing up your character data. This is optional though.
3. Open the Folder called “Upgrade” and run reaper-x-upgrade.bat.
4. Next type in the directory to the Bin Folder where your mysql.exe and mysqldump.exe files are located.
5. Then make sure that you are upgrading from the latest previous version or else you WILL corrupt your database and possibly lose your character data.
Guide on how to Edit Mangos.Conf
Thanks for the Mangosd.conf edit guide Jeremy!
First off make sure that you have your MySQL running before doing anything.
You need to go back into the reaper folder (C:\Reaper-X-Easy-MaNGOS\reaper-eazy-mangos)
And run the batch file called reaper-x-mangos, there is an option there to setup your LAN or IP for use, This new batch file does correctly setup your DB to the IP you enter in this batch file. Once you’ve done that, if you haven’t gone back in to edit the config files in your reaper folder mentioned above, you need to do that, there is a section in there with this.
# Data directory setting.
# Important: DataDir needs to be quoted, as it is a string which may
# contain space characters.
DataDir = “C:\Reaper-X\data”
This is an example of waht it may look like. You need to change this to the path where you put your data folder with the maps, vmaps, and dbc’s.
Second, …
# Database connection settings for the world server.
# Default: hostname;port;username;password;database
# .;somenumber;username;password;database – use named pipes at Windows
# Named pipes: mySQL required adding “enable-named-pipe” to [mysqld] section my.ini
# .;/path/to/unix_socket;username;password;database – use Unix sockets at Unix/Linux
# Unix sockets: experimental, not tested
LoginDatabaseInfo = “127.0.0.1;3306;ROOT;PASSWORD;realmd”
WorldDatabaseInfo = “127.0.0.1;3306;ROOT;PASSWORD;mangos”
CharacterDatabaseInfo = “127.0.0.1;3306;ROOT;PASSWORD;characters”
Above, you need to change the MANGO;MANGOS to your root DB name, likey it’s just root, and YOUR batabase (DB) password (you should know this)
YOU DO NOT CHANGE THE IP’S here or in the realmd file, ONLY THROUGH THAT BATCH FILE, i mentioned above. (that file does it for you)
Next open scriptdev2.conf and realmd.conf and edit the info for them to connect to your database as well.
Hope you enjoy this release if you have any questions feel free to post them as a comment below!
Leave a response
I’m getting error’s like:
Loading Items...
[**************************************************] 100%
>> Loaded 23551 item prototypes
Item (Entry: 8591) has wrong Subclass value (5) for class 15
Item (Entry: 13086) has wrong Subclass value (5) for class 15
Item (Entry: 13335) has wrong Subclass value (5) for class 15
Item (Entry: 18245) has wrong Subclass value (5) for class 15
Item (Entry: 18246) has wrong Subclass value (5) for class 15
Item (Entry: 18247) has wrong Subclass value (5) for class 15
Item (Entry: 18248) has wrong Subclass value (5) for class 15
Item (Entry: 19029) has wrong Subclass value (5) for class 15
Item (Entry: 19030) has wrong Subclass value (5) for class 15
Item (Entry: 19872) has wrong Subclass value (5) for class 15
Item (Entry: 19902) has wrong Subclass value (5) for class 15
Item (Entry: 21176) has wrong Subclass value (5) for class 15
Item (Entry: 21218) has wrong Subclass value (5) for class 15
Item (Entry: 21321) has wrong Subclass value (5) for class 15
Item (Entry: 21323) has wrong Subclass value (5) for class 15
Item (Entr
tim@LAMP:/opt/mangos/bin$ screen -a
insertPendingThread()
1 pending-thread added.
Thread joining...
Thread exiting...
insertPendingThread()
1 pending-thread added.
Thread joining...
Thread exiting...
insertPendingThread()
1 pending-thread added.
ThreadQueue waiting on remaining threads...
pollUserThreads()
pollPendingThreads()
Thread destroyed.
1 pending-thread reclaimed.
Thread destroyed.
1 pending-thread reclaimed.
Thread destroyed.
1 pending-thread reclaimed.
pollReferenceThreads()
Thread destroyed.
1 reference-thread reclaimed.
ThreadQueue destroyed
And it stops at the:
Loading Creature templates i dont know why
srry if this question was already asked…but can i update this newer one from the 2.3.3 one (Mangos 5472 release) so i still have my characters…..or do i need to update with the first 2.4.2 one and then go from there?
thankz
erm, fixed the realmlist.wtf and got in
ok, so I did a fresh install and everything seems to be working except that I get stuck at the Authenticating screen when logging in, any clues?
will this work with patch 2.4.1
DBC’s were included with the release.
After restoring my characters I cant loging myself getting that old unknown column Sha_Pass_Hash error in the field list trying to log in; must be some difference with the old PSDB I was running before. DB was clean fresh install, hmm, Extraneous DLL’s maybe I’ll make a clean mangos folder. Otherwise may scrap all and start fresh.
I just made a fresh install and copy back my character and realmd data but i still cant complete any quests with mob counts in it.
Even when i remove the quest and get it again i cant complete them with killing the ricght mobs.
Hope someone can help me.
Greetz Brutus
ive been trying to get mine to work i got the new pack and still got the same error about no items so i was looking thru the postes and grabed the new mysql6.0 installed it vuseing the reaper page on howto do it and made sure to have a bin well i had to name it mysql4 it wouldnt let me use mysql even tho i deleted the 5.0 i had and now the realmd wont connect says it cant find it dies any1 have any ideas thanx
Can someone upload 2.4.2 dbc files plz
Hi, I hope someone can help me.
After i installed this update. I cant complete quests with mob counts in it. So you need to kill 10 of these and 10 of those and then your done. But de mobs aren’t counted in de quests. Its hard to level at this point :P
Hope someone can help me.
Greeting Brutus
Can anyone help me?
Whenever i try to run mangosd it gets up to 88% but then it says some required .dbc files not found or compatible?
how do i fix this?
Ah – after some more reading – If I read this correctly, it is only set to run with the unified database (UDB) not the project silvermoon (PSDB) with all the custom vendors. Still if you know your custom vendors insert SQL script code as in my prior post you can insert some custom vendors into any database pretty much.
@Elderslayer:
Custom vendors require data in three tables. Creature, npc_vendor and creature_template. If you didn’t backup your old custom vendors they could be gone from this database.
I try to keep a batch of SQL scripts just for creating my personal custom vendors like my level 40 armor greens vendor in gadgetzan looks like this. http://www.reaper-x.com/2008/03/23/reaper-mangos-5472-easy-wow-private-server-for-world-of-warcraft-233/#comment-88563
The other question you had was regarding web pages. I’m thinking there are several out there and they include step by steps and seems like the main thing to do would be opening forwarding port 8080 on your router firewall and desktop firewall. This is a risk you should take carefully, if you have never run a public web site before. just as we forward ports 8085 and 3724 for realmd to make them publicly visible.
The only other thing is to configure your web page so it knows your mysql login and password so it can update/insert people into your database.
Hope that helps. I’ve been gone playing the new dailies in quel’danas on retail wow if anyone was wondering where I’d gone. I have to catch up and install this latest version but glad to see you folks are all still plugging away at the ole Mangos. Thanks Reaper / Oatman!
@dopey
yes i did it but i realized after i put that up that none of the creatures in the release for SW or ORG had locations so i got them to work but they weren’t spawned and i didn’t feel like spawning everything
WOOOT YOU FUCKING ROCK!!!!!!!!!!!!!!!!!!!
is this compatible with vista
If you are getting the vmap error at mangosd startup, recreate the maps (not vmaps).
AD.EXE has been updated in this release. So if you created the maps using an earlier version of ad.exe from your 2.4.2, you’ll need to do it again using this version.
This needs maps only, not vmaps.
#Phen
Yes, I tried the extract-map.bat and ad.exe by itself, but both consistently crash at exactly 41%. I did some googling and apparently some others are having the exact same problem, but no one seems to be able to figure out why.
I’m guessing Vista has something to do with it since I hear the Linux version does not have the same problem. :P
My GM Island is bombing out on line 24, which is the creature INSERT, not the NPC. Any ideas on columns there?
Thanks!
There’s a couple of downloadable Brutal Gladiator + Guardian items on mmowned.com, but I just can’t ‘em to work. It would be awesome if someone could post a link to a working “.sql” or query here that is working for this version of mangos.
Thanks :D
One step closer, edited the realmlist.wtf and added the port to the WORLD (8085) and got through to authenticating, still, I got stuck there and about a min later the mangosd.exe crashed
ok, it’s confirmed when “uptime” reaches 1 min it chrashes, 3 times in a row I’ve had “info” give uptime 59s and next it crashes
hmm…now I’ve got a problem with mangosd.exe crashing about every minute…
also, when I try to connect I get the “unable to connect” error
ahh, problem solved, I just noticed I’ve got a “‘” which seems to start a quote.. even though it’s in the quote, removed it and it seems to work
ok, so the error msg I get now is:
C:\Games\WoWServer>mangosd
DOTCONF++: file ‘C:\Games\WoWServer\mangosd.conf’, line 425: unterminated quote
Could not find the configuration file mangosd.conf
thing is, it reads the conf file and then says it can’t be found.
also, the line 426 is:
Motd = “Welcome to Mickwald’s WoW Server”
which doesn’t have any unterminated quotes..
any clues?
ok, so the smart me forgot that you can run it in cmd to get the complete error msg without the window closing, going to check that now xD
Hi,let me start by saying what an excellent job at this and keep up the good work.
But i have one question.
All the spells are not there for my druid.
When i create a druid i cannot get the flight form from the trainer,not even the level 68 normal one.
Does anyone know what i have to do to be able to learn it from the trainer and also be able to obtain the quest for the epic one?
thanks in advance.
i got the ‘ExtendedCost’ error when i import my 5472 item, but i use Quice122 to check other official item in the 5953 database and cannot find the ExtendedCost line in those. so what can i do for that?
hi~
how can i import my custom item txt from 5472 database to 5953 database?
thanks
ok, through some microing I found out that it complains about line 426, unfinished quote…would anyone know which line this is(in the mangos.conf) (microing = printscreen at startup, through vnc in school xD)
I have got this wrong info: Check Existing of map file ‘./maps/0004331.map’: not exist! Correct *.map files not found in path ‘./maps’ or *.vmap/*vmdir files in ‘./vmaps’. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
I checked the maps folder. I found the map of 0004331.map. I don’t know why it showed these messages above. And the mangos stopped running.
#Scott
Are you using the provided extract-map.bat file to run the ad.exe?
modified vendors file? how would i get it and then how would i apply it
@ Firane,
Did you get the modified vendors file posted that you refered to earlier?
For all those looking for custom vendors:
I have only been able to get them back one way.
(WARNING: THIS METHOD IS SOMEWHAT INVOLVED AND REQUIRES DATABASE EDITING. ANYONE UNWILLING OR UNABLE TO DO THIS SHOULD WAIT UNTIL REAPER OR OATMAN RELEASE A FIX TO THE VENDORS)
BTW this is NOT the GM Island vendors. These are the vendors that were in the 5472 release that were in Stormwind and Orgrimmar.
1) Backup your characters using the reaper tool
2) completely delete your database (use SQLyog or other tool, right click on mangos, realmd, characters, and scriptdev2 databases and click drop database)
3) Download 5472 release and do a fresh install of that release.
4) in the reaper tool for the 5472 release select the custom stuff and install custom vendors.
5) Download 5931 release and do upgrade option
6) Run 5953 upgrade.
7) ReRun 5953 reaper tool and restore characters.
8) use SQLyog (or other tool) and go into mangos/creature.
9) sort by guid
10)scroll down until you hit the guids that are above 2 million.
11) all guids that are above 2 million need to be renamed as it causes a guid overflow error. What I did was I started at the first one and renumbered it 500000. the next one was 500001 and so on and so forth.
12) now when you start your server you should have most if not all of the custom vendors
Hope this helps you guys get your vendors back.
-Dopey
@Brent
you probably set it up right, but did u change your realmlist to the new address?
Im having a problem making my server live, everyone time I run the reaper-x-mangos.bat or whatever and do the server setup for lan play/whatever it wont let me connect from a another computer or even the computer running the server
I’m having a weird problem with ad.exe. It gets to 41% and then crashes. Anyone having this problem or know a work around?
smb — funny! but the program asks with capital ‘Y’ in Yes. thanks, a bit misleading.
mangosd crashes when trying to do fishing quest (red snappers). i’m playing as a draenei character. i tried to cast the net on red snappers. i get disconnected message in-game. when i exit wow, i see no manosd dos window.
anyone figured out how to get the vendors alive yet?>
Hey Reaper,
just commenting to say good job, and i hope your feeling better! ^_^
~Jink
2008-05-26 19:04:28 MySQL client library: 5.0.56
2008-05-26 19:04:28 MySQL server ver: 6.0.4-alpha-community
2008-05-26 19:04:28 ERROR:SQL: SELECT id, name, address, port, icon, color, timezone, allowedSecurityLevel, population FROM realmlist WHERE color 3 ORDER BY name
2008-05-26 19:04:28 ERROR:query ERROR: Table ‘mangos.realmlist’ doesn’t exist
2008-05-26 19:04:28 ERROR:No valid realms specified.
anyone?
Any ETA on any 2.4.3? ;)
Does this support World of Warcraft Wrath of the Lich King?
there use to be an option to configure the config files, now you have to do it manually, so as they have your password, read up on the instruct and some posts.
still havent got a fix for my prob :-(
hey reaper this is the first version iv tried to install mangos and its asked me my mysql username and password and such and i did all that and it installed but then when i opened mangosd.exe it said:
2008-05-26 18:35:29 World Database: 127.0.0.1;3306;root;mangos;mangos
2008-05-26 18:35:29 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user ‘root’@'localhost’ (using password: YES)
2008-05-26 18:35:29 ERROR:Cannot connect to world database 127.0.0.1;3306;root;mangos;mangos
Do not use cap Y in “Yes”
Type
yes all in lower
I can’t exit:
[ 8 ] Exit
8
You are Now Leaving
Are you sure you want to leave ? Yes/No
Yes
“Yes” is incorrect
Press any key to continue . . .
But looks like it completes without error.
ok now i freaking love this release jared you are so AWESOME!!!!!!!
#Jacob
No idea about your first question, but I extracted the commands from the database and posted them here:
http://forums.reaper-x.com/topic/gm-commands#post-5091
The list may not be complete, but it’s a start. :3
#Alex P
The data directory can be anywhere you put your maps and vmaps and dbc folders.
When you extract the first two using the provided tools these folders are created in the main WoW installation folder and the dbc folder is already in the pack.
You have to create a ‘data’ folder (I recommend a subfolder of your Mangos installation) and move the maps, vmaps and dbc folders there, then edit the resulting path into the mangosd.conf file.