MaNGOS 6245 (UDB + PSDB), ScriptDev2 r474

Hello everyone! Its Colt45! I am glad to announce that MaNGOS Rev 6245 has been release (finally)! I am terribly sorry to inform you that I do not have a list of new feature that have been added to this release, but I should have a complete one for the next release. So here is the guide:

THIS GUIDE HAS BEEN BASED OFF OF OATMAN’S LAST GUIDE, PLEASE GIVE THE CREDIT TO HIM FOR THE GUIDE!!!

Step 1:  Install MySQL using the guide here >>>  (MySQL Installation and Configuration) 

NOTE: It does NOTmatter which verion of MySQL you get (either 5.0 or 5.1) as long as you do not get any older versions or beta versions!

Step 2:  Update your DBC’s, VMAP’s, and MAPS for 2.4.2!

If you already have your DBC’s, Vmaps’s, and Maps from a previous release that uses client 2.4.2 then you DO NOT have to re-extract them. If not then you must follow the Readme.txt files located in the extraction folders.

Step 3: Download Reaper-X-MaNGOS (below are list of mirror to file).

Links updated to the recompressed version (19.49MB) that use 7zip self extracting archive instead of zip compressed file

1. MediaFire Download

2. RapidShare Download

3. FileBeam Download

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

These files should still be compatible with this release

Custom Vendors Pack for this version

http://filebeam.com/a516a6d8281b96e506df995716381a02

Credits to Firane for creating the Custom Vendors Pack

Updated GM Command List for this version

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
Note: ad.exe included in this version will extract the dbc files and maps files, and so all you have to do is just put the ad.exe into your wow installation directory (for example, C:\program files\World of Warcraft) and run the ad.exe from there. But make sure to delete the maps and dbc directory if exist before running the ad.exe

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 Bin Image

MySQL BIN Image

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.

MaNGOS Batch Menu Image

Mangos batch 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

 Mangos.exe Image

Mangos EXE

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

Upgrading from 5953 Release:

1. This release still supports your 2.4.2 DBC’s, Maps, and Vmaps, so if you want to re-extract you may but I dont think there is much need.

2. Go into your WoW Reaper Server Directory, and open reaper-eazy-mangos.

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. (Default is C:\Program Files\MySQL\MySQL Server 5.0\bin)

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.

Update Batch Image

Updated Batch image

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”

In this release your DataDir is pre-set to C:\Reaper_MaNGOS_6245_SD2_474\Data  which means that if you extract the folder directly to your C Drive then you will not need to configure your DataDir, but you will still need to set your ROOT and PASSWORDS as shown below!

This is an example of what 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 MANGOS;MANGOS to your root DB name, likey it’s just root, and YOUR database (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.

Comment?

Note: Comment may not appear right away.

279 comments on “MaNGOS 6245 (UDB + PSDB), ScriptDev2 r474

  1. I’m not allowed to enter the dark portal og karazan… it tells me that i have to have the burning crusade installed… but I have that! any idea of what could be the problem ?

    /M

  2. kinda got it to work now..
    but wow says unable to validate game version..

    Think i’m running mangos 6245 and 2.4.3.8606-enGB-patch

  3. “2008-08-22 19:47:10 ERROR:SQL: SELECT MAX(guid) FROM characters
    2008-08-22 19:47:10 ERROR:query ERROR: Table ‘characters.characters’ doesn’t exist
    2008-08-22 19:47:10 ERROR:SQL: SELECT MAX(id) FROM character_pet
    2008-08-22 19:47:10 ERROR:query ERROR: Table ‘characters.character_pet’ doesn’t exist
    2008-08-22 19:47:10 ERROR:SQL: SELECT MAX(guid) FROM item_instance
    2008-08-22 19:47:10 ERROR:query ERROR: Table ‘characters.item_instance’ doesn’t exist
    2008-08-22 19:47:10 ERROR:SQL: DELETE FROM character_inventory WHERE item >= ‘1’
    2008-08-22 19:47:10 ERROR:SQL ERROR: Table ‘characters.character_inventory’ doesn’t exist
    2008-08-22 19:47:10 ERROR:SQL: DELETE FROM mail_items WHERE item_guid >= ‘1’
    2008-08-22 19:47:10 ERROR:SQL ERROR: Table ‘characters.mail_items’ doesn’t exist
    2008-08-22 19:47:10 ERROR:SQL: DELETE FROM auctionhouse WHERE itemguid >= ‘1’
    2008-08-22 19:47:10 ERROR:SQL ERROR: Table ‘characters.auctionhouse’ doesn’t exist
    2008-08-22 19:47:10 ERROR:SQL: DELETE FROM guild_bank_item WHERE item_guid >= ‘1’
    2008-08-22 19:47:10 ERROR:SQL ERROR: Table ‘characters.guild_bank_item’ doesn’t exist
    2008-08-22 19:47:10 ERROR:SQL: SELECT MAX(id) FROM auctionhouse
    2008-08-22 19:47:10 ERROR:query ERROR: Table ‘characters.auctionhouse’ doesn’t exist
    2008-08-22 19:47:10 ERROR:SQL: SELECT MAX(id) FROM mail
    2008-08-22 19:47:10 ERROR:query ERROR: Table ‘characters.mail’ doesn’t exist
    2008-08-22 19:47:10 ERROR:SQL: SELECT MAX(id) FROM item_text
    2008-08-22 19:47:10 ERROR:query ERROR: Table ‘characters.item_text’ doesn’t exist
    2008-08-22 19:47:10 ERROR:SQL: SELECT MAX(guid) FROM corpse
    2008-08-22 19:47:10 ERROR:query ERROR: Table ‘characters.corpse’ doesn’t exist
    2008-08-22 19:47:10
    2008-08-22 19:47:10 Loading MaNGOS strings…
    2008-08-22 19:47:10 ERROR:SQL: SELECT entry,content_default FROM mangos_string
    2008-08-22 19:47:10 ERROR:query ERROR: Table ‘mangos.mangos_string’ doesn’t exist
    2008-08-22 19:47:10
    2008-08-22 19:47:10 ERROR:>> Loaded 0 mangos strings. DB table `mangos_string` is empty. Cannot continue.

    How can I fix it?

    How did this get fixed?
    I’m having the same problem =/

  4. Never mind, a buddy of mine who also dabbles with this helped me get it working. Keep up the outstanding work, Reaper and Oatman, you’re helping preserve the sanity of some tired soldiers here in Iraq.

  5. Along with the ad.exe, in the readme, it says create a folder but does not give the name of the folder. What is the name it is supposed to be?

  6. Also, a friend of mine on Windows Vista is trying the same thing, he installed WoW and updated it to 2.4.2, ran the ReaperMangos file, then copied ad.exe into the WoW directory, but it hangs at 41%. Any ideas why?

  7. Not to sound like a noob, because this isn’t the first version of the private server I’ve set up, but what version of WoW does this server run with? I have the patches up to 2.4.3.8606.

  8. This error is keeping me from getting mine off the ground, and I don’t know what I am doing wrong, but I have the DBC and maps and Vmaps and Buildings folders all in the reapers/data

    Using configuration file mangosd.conf.
    MaNGOS/0.11.0-SVN (Revision 6245) (Win32,little-endian) (world-daemon)
    to stop.

    MM MM MM MM MMMMM MMMM MMMMM
    MM MM MM MM MMM MMM MM MM MMM MMM
    MMM MMM MMM MM MMM MMM MM MM MMM
    MM M MM MMMM MM MMM MM MM MMM
    MM M MM MMMMM MM MMMM MMM MM MM MMM
    MM M MM M MMM MM MMM MMMMMMM MM MM MMM
    MM MM MMM MM MM MM MMM MM MM MMM
    MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
    MM MM MM MMM MM MM MMMMMM MMMM MMMMM
    MM MMM http://www.mangosproject.org
    MMMMMM

    World Database: 127.0.0.1;3306;root;1337;mangos
    Connected to MySQL database at 127.0.0.1
    MySQL client library: 5.0.56
    MySQL server ver: 5.0.67-community-nt
    AUTOCOMMIT SUCCESSFULLY SET TO 1
    Character Database: 127.0.0.1;3306;root;1337;characters
    Connected to MySQL database at 127.0.0.1
    MySQL client library: 5.0.56
    MySQL server ver: 5.0.67-community-nt
    AUTOCOMMIT SUCCESSFULLY SET TO 1
    Login Database: 127.0.0.1;3306;root;1337;realmd
    Connected to MySQL database at 127.0.0.1
    MySQL client library: 5.0.56
    MySQL server ver: 5.0.67-community-nt
    AUTOCOMMIT SUCCESSFULLY SET TO 1
    Realm running as realm ID 1
    Using UDB 0.10.3 (357) for MaNGOS rev. 6240 with SD2 SQL for rev. 473
    Using DataDir C:\Private Server\World of Warcraft\Data/
    WORLD: VMap support included. LineOfSight:0, getHeight:0
    WORLD: VMap data directory is: C:\Private Server\World of Warcraft\Data/vmaps
    WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapId
    s, vmap.ignoreSpellIds

    Loading MaNGOS strings…
    ==================================================== 100%
    >> Loaded 503 MaNGOS strings

    Initialize data stores…
    ================================================== = 98%
    Some required *.dbc files (1 from 55) not found or not compatible:
    C:\Private Server\World of Warcraft\Data/dbc/Spell.dbc (exist, but have 216 fiel
    ds instead 213) Wrong client version DBC file?

    Help me please = )

    [email protected]

  9. OK. I’ve got ManGoS up and running, and I changed the realmlist.wtf file in my WoW driectory so it says set realmlist 127.0.0.1 but WoW is still only connecting the Blizzard’s servers. How do I get it to use my private server instead, because editing realmlist.wtf isn’t the answer, there has to me more.

  10. @Colt45

    thank you, there are a few quest/skill related things that are broken in this release, at least one of which is the paladin quest sets, which i have never gotten to work
    tome of the divine
    tome of valor
    and the rest of the progression for alliance paladins
    in fact, none of the ‘heal this person’ quests seem to work properly…
    2.4 all_myclass command adds a lot of misc./test skills, i wouldnt reccomend using it, there are however, some of the skills for WotLK in the DB that were mentioned on wowwiki
    there is an imp spawn in the bloodelf starting area that is hostile and high enough level, that i cant bypass it without using artifacts or the .die command
    there may be more bugs, but i dont want to be a total ass right now, thank you for the release Colt45, if not for the Reaper-X team i wouldnt be able to play WoW anymore as someone stole my account when i was in chemotherapy

  11. Thank you Reaper for this release. I had the problem of “cannot connect to database” but I changed the mangosd.conf and the other conf files and I worked out, as you suggested
    But now I have this problem. When I open mangosd.exe I have this:

    2008-08-22 19:47:09 Using configuration file mangosd.conf.
    2008-08-22 19:47:09 MaNGOS/0.11.0-SVN (Revision 6245) (Win32,little-endian) (world-daemon)
    2008-08-22 19:47:09 to stop.

    MM MM MM MM MMMMM MMMM MMMMM
    MM MM MM MM MMM MMM MM MM MMM MMM
    MMM MMM MMM MM MMM MMM MM MM MMM
    MM M MM MMMM MM MMM MM MM MMM
    MM M MM MMMMM MM MMMM MMM MM MM MMM
    MM M MM M MMM MM MMM MMMMMMM MM MM MMM
    MM MM MMM MM MM MM MMM MM MM MMM
    MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
    MM MM MM MMM MM MM MMMMMM MMMM MMMMM
    MM MMM http://www.mangosproject.org
    MMMMMM

    2008-08-22 19:47:09 World Database: 127.0.0.1;3306;root;password;mangos
    2008-08-22 19:47:09 MySQL client library: 5.0.56
    2008-08-22 19:47:09 MySQL server ver: 5.0.67-community-nt
    2008-08-22 19:47:09 Character Database: 127.0.0.1;3306;root;password;characters
    2008-08-22 19:47:09 MySQL client library: 5.0.56
    2008-08-22 19:47:09 MySQL server ver: 5.0.67-community-nt
    2008-08-22 19:47:09 Login Database: 127.0.0.1;3306;root;password;realmd
    2008-08-22 19:47:09 MySQL client library: 5.0.56
    2008-08-22 19:47:09 MySQL server ver: 5.0.67-community-nt
    2008-08-22 19:47:09 Realm running as realm ID 1
    2008-08-22 19:47:09 ERROR:SQL: SELECT version FROM db_version LIMIT 1
    2008-08-22 19:47:09 ERROR:SQL: UPDATE characters SET online = 0
    2008-08-22 19:47:09 ERROR:SQL ERROR: Table ‘characters.characters’ doesn’t exist
    2008-08-22 19:47:09 ERROR:query ERROR: Table ‘mangos.db_version’ doesn’t exist
    2008-08-22 19:47:09 Using unknown world database.
    2008-08-22 19:47:09 Using DataDir C:\Reaper_MaNGOS_6245_SD2_474\data/
    2008-08-22 19:47:09 WORLD: VMap support included. LineOfSight:0, getHeight:0
    2008-08-22 19:47:09 WORLD: VMap data directory is: C:\Reaper_MaNGOS_6245_SD2_474\data/vmaps
    2008-08-22 19:47:09 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
    2008-08-22 19:47:10 ERROR:SQL: SELECT MAX(guid) FROM characters
    2008-08-22 19:47:10 ERROR:query ERROR: Table ‘characters.characters’ doesn’t exist
    2008-08-22 19:47:10 ERROR:SQL: SELECT MAX(id) FROM character_pet
    2008-08-22 19:47:10 ERROR:query ERROR: Table ‘characters.character_pet’ doesn’t exist
    2008-08-22 19:47:10 ERROR:SQL: SELECT MAX(guid) FROM item_instance
    2008-08-22 19:47:10 ERROR:query ERROR: Table ‘characters.item_instance’ doesn’t exist
    2008-08-22 19:47:10 ERROR:SQL: DELETE FROM character_inventory WHERE item >= ‘1’
    2008-08-22 19:47:10 ERROR:SQL ERROR: Table ‘characters.character_inventory’ doesn’t exist
    2008-08-22 19:47:10 ERROR:SQL: DELETE FROM mail_items WHERE item_guid >= ‘1’
    2008-08-22 19:47:10 ERROR:SQL ERROR: Table ‘characters.mail_items’ doesn’t exist
    2008-08-22 19:47:10 ERROR:SQL: DELETE FROM auctionhouse WHERE itemguid >= ‘1’
    2008-08-22 19:47:10 ERROR:SQL ERROR: Table ‘characters.auctionhouse’ doesn’t exist
    2008-08-22 19:47:10 ERROR:SQL: DELETE FROM guild_bank_item WHERE item_guid >= ‘1’
    2008-08-22 19:47:10 ERROR:SQL ERROR: Table ‘characters.guild_bank_item’ doesn’t exist
    2008-08-22 19:47:10 ERROR:SQL: SELECT MAX(id) FROM auctionhouse
    2008-08-22 19:47:10 ERROR:query ERROR: Table ‘characters.auctionhouse’ doesn’t exist
    2008-08-22 19:47:10 ERROR:SQL: SELECT MAX(id) FROM mail
    2008-08-22 19:47:10 ERROR:query ERROR: Table ‘characters.mail’ doesn’t exist
    2008-08-22 19:47:10 ERROR:SQL: SELECT MAX(id) FROM item_text
    2008-08-22 19:47:10 ERROR:query ERROR: Table ‘characters.item_text’ doesn’t exist
    2008-08-22 19:47:10 ERROR:SQL: SELECT MAX(guid) FROM corpse
    2008-08-22 19:47:10 ERROR:query ERROR: Table ‘characters.corpse’ doesn’t exist
    2008-08-22 19:47:10
    2008-08-22 19:47:10 Loading MaNGOS strings…
    2008-08-22 19:47:10 ERROR:SQL: SELECT entry,content_default FROM mangos_string
    2008-08-22 19:47:10 ERROR:query ERROR: Table ‘mangos.mangos_string’ doesn’t exist
    2008-08-22 19:47:10
    2008-08-22 19:47:10 ERROR:>> Loaded 0 mangos strings. DB table `mangos_string` is empty. Cannot continue.

    How can I fix it?
    Sorry for my English

  12. Hi everyone, i also am having a few bugs…
    In the PSD the enemies attack at a freakish hy speed and kill me in 3 seconds.
    And in the Unified Database when i choose the blood elf the warlocks imp at the beggining of the scenario kill me every time.
    If someone could help me!

  13. Colt45,

    You have done an excellent job on this version of MaNGOS. I have my private server set up and am very pleased with everything. Keep on rocking!!!