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. @Colt45
    Thanks! I am also havign issues figuring out ACID revisions used in the prior release and this one. I can do changelog from ACID 0.0.1r1 to current, but what is current?

    Thanks for the quick reply above!

    iotech

  2. @WantRogueBoots
    Yes UDB has left out some major items for season 4, etc. We hope this will be fixed in the next release!

    @Iotech
    UDB 0.10.3 was used in this release.

  3. @Colt45,

    I am rounding up changelogs and feature lists for everyone for this release compared to last (5953), but I dont know what version of the UDB you included in this release. Which is it?

    Thanks!

  4. I do not know if all Brutal sets are working all I know is that Guardian’s Leather Boots is not in this release ^^

  5. @Firane

    The last vendor pack created some opportunities for expoloit, for example two of my players found vendors that “sell” items for 0 cost then buy them back for good gold (specifically, these were Gem vendors, but I found others when I investigated by a pair of 10th level characters had arena gear).

    Q: Was this what you fixed in the new vendor pack?

    Thanks for the work on this, much appreciated!!

  6. i get the lan setup and stuff, but i dont have one. i dont use a router i just use a normal connection to my isp..

    at my dads i had it and it worked no problem..

    but at my flat i dont use a router or netwrok so i dont have a lan ip.

  7. @kevin
    Thanks for writing that guide out, lol or I would have had too :P but anyways PSDB is just another database, writen in a differant way, but still gets you the same results as UDB, but I have no experience with PSDB nor does Oatman. Reaper is the only one I believe has any experience with it.

    @Firane
    Hey and ya I understand but I don’t believe many people be using PSDB, so its not a big problem.

  8. @colt45/reaper/oatman
    also included say that the vendors only work with UDB.
    I don’t use PSDB so i didn’t feel like converting them to PSBD
    unless they already work
    in that case i haven’t tried it

  9. If you want to host on a lan make sure you change the realmlist table address (found in the realmd db) to point to your servers lan ip instead of 127.0.0.1 and add this

    localhost

    to your \windows\system32\drivers\etc\host file using notepad…for example…

    192.168.1.42 localhost

    You continue to use localhost everyone else on your lan would change the realmlist.wtf to

    set realmlist

    e.g. set realmlist 192.168.1.42

    If you want to host on the internet get a address from https://www.dyndns.com or http://no-ip.com. This is more secure than giving out your external ip. This goes in your realmlist table address(found in the realmd db) Make sure you ADD to your \windows\system32\drivers\etc\host file the following

    e.g.

    192.168.1.42 localhost
    82.61.204.112 my.game-server.cc

    IF YOU HAVE A ROUTER MAKE SURE YOU HAVE PORTS: 8085, 3724 AND 80 OPEN AND FORWARDED TO THE SERVER IP OTHERWISE YOU WILL HAVE PROBLEMS CONNECTING.

    I strongly advise against changing 127.0.0.1 entries in the files to your no-ip address as this just adds lag to your server
    by forcing the system to translate from the host file for every request and is totally unecessary!

  10. whats the difference beween Project Silvermoon and the base i was thinking about tring it

    Colt45 Item\Creature Packs sounds nice cant wait

  11. i have a wee problem i cant figure out howto fix can someone help me..

    ive setup all my files correctly, my ports are open as ive checked them when running the realm and mangois .exe files. but im unable to connect and so are my friends..

    i use a no-ip url and i DO NOT have a router.
    so i dont have a lan ip. only an external ip. which is configed for my ip.

    all i get it the handshakeing screen it wont go past it..

    all the “ip” parts point to my no-ip domain and my site for WoW loads. and shows the server online and stuff.. but for some mental reason we cant connect.

    my hosts file in windows says 127.0.0.1 xxxxxxx.servegame.com

    if i change it to my IP then the mysql says it cant connect. ive read the guides over and over, and it is setup as it should be.. any idears ?

  12. @Martzy
    Yes Sunwell should be spawned

    @Anderek
    Im not to sure if season 4 is active all though I believe it is.

    @Firane
    Hey thanks man, but I don’t have the ability to edit posts yet, only the ability to post them so ill let Reaper know and he can change it!

    @sab
    Reaper-X has been VERY busy with stuff.

    @SR2
    No I am sorry, but AH bot is not included, I am already working on the next release and am planning on adding it!

  13. great job

    oh some of the preist season 4 dont work and
    some of the Guardian dont eather

    but im loving it cheers keep up the good work

  14. I understand that there may be some errors with this release but I can guarantee there won’t be any in the next!