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. Madmax said:

    Hello when i try to install the optional GM island vendors i get the fallowing error

    error 1136 (21s01) as line 24: column count doesn’t match value at row 1.

    I’m having the same error, I think that happens becose in the new SQL Table called npc_vendor there is a new column called ExtendedCost, and the SQL structure of the vendors are build like the old one without that column, I just tried to add it with the mysql query browser steep by steep and just including in the row a ,0), more. And it worked. Lets look the example –>

    INSERT INTO `npc_vendor` VALUES (500000,16677,0,0),(500000,16679,0,0); –>[here i get the Column count dosen’t match value count at row 1]

    Ok thats the old structure, i just changed that –>

    INSERT INTO `npc_vendor` VALUES (500000,16677,0,0,0) , (500000,16679,0,0,0); [WooT! it works now!!]

    If you see there is a “,0)” more, why that? becose in the new npc_vendor table there is one more column the ExtendedCost. I think that the solution is just to ad that ,0) in each of all the npc_vendor values but… I dont know if there is some “automatizated” way of doinf this… its kinda “hardcore” to do it with your own hand.

  2. reaper gave us a PS only custom vendor and then didn’t give us the PS DB. Ironic?
    Well I did a workaround and got a file to load into the UDB for custom vendors so ill put it up for DL on like filebeam in a sec.

  3. i logged and restarted realmd and got this
    2008-05-26 00:42:54 ERROR:SQL: UPDATE realmlist SET color = 0, population = 0 WHERE id = ‘1’
    2008-05-26 00:42:54 ERROR:SQL ERROR: Table ‘mangos.realmlist’ doesn’t exist
    2008-05-26 00:46:15 ERROR:SQL: UPDATE realmlist SET color = 2 WHERE id = ‘1’
    2008-05-26 00:46:15 ERROR:SQL ERROR: Table ‘mangos.realmlist’ doesn’t exist
    2008-05-26 00:46:15 ERROR:SQL: UPDATE characters SET online = 0
    2008-05-26 00:46:15 ERROR:SQL: UPDATE account SET online = 0 WHERE online > 0 AND id IN (SELECT acctid FROM realmcharacters WHERE realmid = ‘1’)
    2008-05-26 00:46:15 ERROR:SQL ERROR: Table ‘mangos.characters’ doesn’t exist
    2008-05-26 00:46:15 ERROR:SQL ERROR: Table ‘mangos.account’ doesn’t exist
    2008-05-26 00:46:15 Halting process…

  4. ok all is good i got everything working but the gm island vendors any ideas on how to get that installed..and does anyone have a guide ro anything to make this public so like if my friend across the country wants to connect to it he can style u know what i mean?

  5. i’m getting “ERROR 1045 : Access denied for user ‘root’@’localhost’ ”
    anyone know how to get over this error? i’ve tried installing older versions, but they give the same error.

    i’m using all the default database names

  6. BTW Oatman,

    If you are looking for better instructions for PSDB, there is a new ‘how-to’ post on the PS website. Longer read but better detailed. Maybe this will help you to include PSDB in your future releases.

    Keep up the good work, you rock!

  7. Hello when i try to install the optional GM island vendors i get the fallowing error

    error 1136 (21s01) as line 24: column count doesn’t match value at row 1

    and thats the best part i like… and clue of how to fix this ?

  8. Maybe I’m doing something wrong but after doing a fresh install the GM island vendors aren’t installing properly. It’s telling me that the columns don’t match. Any ideas?

  9. Exactly – it will sort-of look like the vmaps process has finished, but it is quietly going through the split-maps config and making the vmaps folder after the buildings folder has been created. IT TAKES A LONG TIME. Go mow the lawn (or someone else’s if you don’t have one), then take a nap, then come back and it should be done.

  10. i took the realmd and mangosd config files from reaper 5472 and put them in 5931 and it loaded fine

  11. Follow the instructions carefully and it will work fine, a thing many people forget is to WAIT after vmaps_simple is finished (or not) until you get press any key to continue message.

  12. i cant extract any of the maps i can extract the data but not maps my wow client is 2.4.2 fully updated and everything and im trying to do a fresh install anyone got some help for me? im nto fully sure how to do this

  13. I tried yesterday to add Brutal gladiator and the new Guardian parts myself but it didnt work, got some wrong bla bla at row 1 … :<

  14. ok i got it figure out… what is different from this version and old ones is. Like where it ask what data base you like to use (MaNGOS) . I used to just hit enter it would use default with out me halfing to type in anything. Now its not like that. You got to type it in

  15. Sorry but i am still getting this same error when i try to install

    ERROR 1045 (28000):access denied for user ‘-p####’@’localhost’ (using password: no/0
    mysql: option ‘-D’ requires an argument

    Not sure why this repaer version gives me this trouble.. the other ones installed ok. Can you give me the order of the SQL.files and ill just import them

  16. Thank you so much for releasing the rev 5953. how to transfer the old Mangos rev 3462’s database to the new Mangos rev 5472 or higher? Please , help me!

  17. #Anderek

    Yea I am aware of that and there isn’t any in this release either. Its more of a prep for when its ready.

  18. Also not sure if you know this but there are no mobs in the sunwell raid, i was also having problems with more than one person getting inside of it.

  19. #Anderek

    Yep they are on their way!

    #Viktor

    Yea those are in there yet I believe but they will be in there in a future release for sure. I mainly released this so early because of so many errors and complaints in the previous release.