Reaper MaNGOS 5953 with ScriptDev 414|Server Compatible With 2.4.2 (UDB ONLY!)

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:

  • Completely re-done fishing loot template.
  • Fishing base skill level table added
  • Lots of Black Temple updates
  • Loot added for creatures that are mineable and gatherable
  • Rewards added for quests with quest flags|512 (Quests like Teron Gorefiend I am!)
  • Many quest fixes in general
  • 175 fishing holes added (like school of fish) with loot
  • Instance loot tables updated:
    • Zul’Farrak
    • Sunken Temple
    • Black Rock Depths
    • Dire Maul
    • Black Rock Spire 
  • World drop loot tables for levels 1-34 created (SIGNIFICANT decrease in creature_loot_template size again. All world drop tables are now created. Loot table size before world tables ~950000 rows — after 284594 rows. ~7mB instead of ~22mB)
  • Some 2.4.2 related item changes
  • L70ETC spawns / event included in the DB (still need the ACID script from the ACID team)
  • Fresh Installer Fixed!
  • Map/DBC Extractors Fixed!
  • ACID Included (Means Extra NPC’s and Such Have Been Scripted)
  • MaNGOSD.exe Errors Should Be Fixed!
  • Authentication Bug Should Be Fixed!
  • Vendors/GM Island Vendors Should Work Again if you Enable them by Going Into the Reaper-X-Mangos.bat File.
  • NO MORE EXE’s! I have decided to keep them in Batch format due to complaints about Errors/Trojans.

Shattered Sun Soldiers

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:

  1. http://rapidshare.com/files/120427182/maps.part01.rar
  2. http://rapidshare.com/files/120427405/maps.part02.rar
  3. http://rapidshare.com/files/120427402/maps.part03.rar

Vmaps from WoW 2.4.2:

  1. http://rapidshare.com/files/120495428/vmaps.part01.rar
  2. http://rapidshare.com/files/120495485/vmaps.part02.rar
  3. http://rapidshare.com/files/120495478/vmaps.part03.rar
  4. http://rapidshare.com/files/120495532/vmaps.part04.rar
  5. http://rapidshare.com/files/120495474/vmaps.part05.rar
  6. http://rapidshare.com/files/120495501/vmaps.part06.rar
  7. http://rapidshare.com/files/120495246/vmaps.part07.rar

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) ;)

MySQL Input Directory

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.

Jared ReaperMangos Version of Menu

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.
Upgrade Warning

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!

Comment?

Note: Comment may not appear right away.

784 comments on “Reaper MaNGOS 5953 with ScriptDev 414|Server Compatible With 2.4.2 (UDB ONLY!)

  1. Lewis under your mangosd.conf file there will be DataDir = “.”

    put “C:\Program Files\World of Warcraft”

    or wehrever ur wow files are :) had same problem for awhile

  2. hey i have mangos 2.4.2 setup for lan, when i log in it will go into the realm select and when i click on mangos realm is dosen’t let me in just keeps kicking me out? anyone know how i can fix this, i’m sure its just some setting i didn’t get quite right, plz help.

  3. All of the mobs are neutral and do not aggro, unless a hunter pet attacks them. Both in the world, and in instances. None of the defaults settings in mangosd.conf have been changed, other than the ones needed to get the server to run properly. Any ideas?

  4. hey i don’w know if ne1 else was having problems with the ad.exe from the other releases but if you need a working one i have the .exe from 2.3.3 :P email me i don’t know where i can upload it to. it works on vista \”\-_-/”/
    [email protected]

  5. Just got into this whole offline thing, tried to make a server, ended up with the “http://rapidshare.com/files/120427402/maps.part03.rar” up in the 2.4.2 maps being blocked by rapidshare. Im already playing with 3.0.2 in Blizz and I cant get any source where to get the 2.4.2 maps. Anyone point me to a “stable” server guide where ALL the resources can be accessed? Just a link or something then I’ll figure things out. Thanks much.

  6. I’ve read the comments saying AHBOT is in this release, but something appears to be incorrect. I’ve played with Mangos for almost a year now although I quit for the last few months. I just built a new server and used this release to do a “New Install”. I had to manually input the AHBOT mangos.conf entries but when mangos loads up, all it does is:

    Loading auctions…
    Loading

    It doesn’t do a progress bar and spends 0.000000001 of a second on it. I have like 100000 entries supposed to be listed in Alliance and Horde AH’s and 10000 in the Neutral but none appear. I’ve alerady put in the account number and GUID of the player and have those settings lit… Here’s what i got:

    # Auction House Bot
    AuctionHouseBot.Account = 5
    AuctionHouseBot.GUID = 3
    AuctionHouseBot.NoMail = 1
    AuctionHouseBot.AllianceItems = 100000
    AuctionHouseBot.HordeItems = 100000
    AuctionHouseBot.NeutralItems = 10000
    AuctionHouseBot.MinTime = 8
    AuctionHouseBot.MaxTime = 24
    AuctionHouseBot.PercentWhiteTradeGoods = 25
    AuctionHouseBot.PercentGreenTradeGoods = 13
    AuctionHouseBot.PercentBlueTradeGoods = 9
    AuctionHouseBot.PercentPurpleTradeGoods = 1
    AuctionHouseBot.PercentWhiteItems = 6
    AuctionHouseBot.PercentGreenItems = 30
    AuctionHouseBot.PercentBlueItems = 14
    AuctionHouseBot.PercentPurpleItems = 2
    AuctionHouseBot.MinPriceWhite = 150
    AuctionHouseBot.MaxPriceWhite = 250
    AuctionHouseBot.BidPriceWhite = 100
    AuctionHouseBot.MaxStackWhite = 0
    AuctionHouseBot.MinPriceGreen = 200
    AuctionHouseBot.MaxPriceGreen = 300
    AuctionHouseBot.BidPriceGreen = 100
    AuctionHouseBot.MaxStackGreen = 3
    AuctionHouseBot.MinPriceBlue = 250
    AuctionHouseBot.MaxPriceBlue = 350
    AuctionHouseBot.BidPriceBlue = 100
    AuctionHouseBot.MaxStackBlue = 2
    AuctionHouseBot.MinPricePurple = 300
    AuctionHouseBot.MaxPricePurple = 450
    AuctionHouseBot.BidPricePurple = 100
    AuctionHouseBot.MaxStackPurple = 1

    And yet, the AH never gets populated. I thought at one point i saw a comment from oatman that AHBOT got left out and it would be in the next release, but when i came back to search for it, I couldn’t find that post again.

  7. keep getting this message can anybody help with this plz?

    MPQ-Extractor v1.4 by WRS powered by Shad

    Output directory: .
    Extracting from locale-enGB.MPQ
    MPQ-Extractor v1.4 by WRS powered by Shad

    Output directory: .
    Extracting from patch-enGB.MPQ
    MPQ-Extractor v1.4 by WRS powered by Shad

    Output directory: .
    Extracting from patch-enGB-2.MPQ
    A duplicate file name exists, or the file
    cannot be found.
    Press any key to continue . . .

  8. Just to add more info:

    SQL: SELECT race, class, level, basehp, basemana, str, agi, sta, inte, spi from player_levelstats query ERROR: Unknown column ‘basehp’ in ‘field list’

  9. Hello,

    Reaper X.. Awesome Mangos, hey i have a problem. the Realmd worked, but then i run mangosd I get a ” Loaded 0 <–Zero Level stats definitions Error loading ‘player_levelstats table or empty table.

    what am i doing wrong here? please help.
    Thanks..

  10. i’m having trouble using the realmd and mangosd files, how do you change the psw from yes to your password?

    please awnser

  11. I have a problem, i did just solve my “couldnt find 0004331.map file and was thinking yes finnaly i can play… but no… another error apair spell.dbc isnt my friend atm, he hates me couse ive tryed every version of thoose AD.exe things ive seen on this site, but i wont just work it always say wrong client version… please help, and im Fresh install not a updater

  12. Hello everyone

    I know this might be a stupid question but how do you let other people from around the world join your server? Do I have to create a website or something?

    Thnx in advance.

  13. Hello guys. I am noob at this but I am really trying to learn. I followed these steps very carefully and got and did everything stated on the steps. maybe I am missing something. I dont really know what directory the extracted dbc and maps files are supposed to go in. But I have got the Mysql up and running as well as the realmd.exe and mangosd.exe start up with no problem.
    My problem is that when I try to log in to the server I get the ‘connecting’ signal but then I get ‘unable to connect’. Maybe I am doing something wrong, can someone help me out to get this running?
    [email protected]
    hustler_539 on ym

  14. I have set everything up nicely, after 6 hours of grinding work the game runs smooth except for one minor problem – I have setbc username 1
    and have expansions set at 1 in my mangos config, I do have burning c. installed however it does not allow me to go to those areas in game.

  15. i’m having trouble using the realmd and mangosd files, how do you change the psw from yes to your password?

  16. OK so when i boot up mangosd its saying that the maps file 0004331.map doesnt exist yet i can see it in the directory…

  17. more info on above…
    Other then not being able to get into those two main programs!!! it seems to be fine…im new to it but thats what it looks like, i just need to create an account for the private server