Custom Search
MaNGOS 6245 (UDB + PSDB), ScriptDev2 r474
Posted by Colt45 Jul 11 2008 11:14 am
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
2.4.2 Maps:
- http://rapidshare.com/files/120427182/maps.part01.rar
- http://rapidshare.com/files/120427405/maps.part02.rar
- http://rapidshare.com/files/120427402/maps.part03.rar
Vmaps from WoW 2.4.2:
- http://rapidshare.com/files/120495428/vmaps.part01.rar
- http://rapidshare.com/files/120495485/vmaps.part02.rar
- http://rapidshare.com/files/120495478/vmaps.part03.rar
- http://rapidshare.com/files/120495532/vmaps.part04.rar
- http://rapidshare.com/files/120495474/vmaps.part05.rar
- http://rapidshare.com/files/120495501/vmaps.part06.rar
- 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
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
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
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
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.
Trackbacks/Pingbacks
Leave a response
Connect with me
@Colt45
The extractor is a great idea, but if you can’t get it this time, I know I won’t cry, I’m just happy you’re doing all this work. :) So ty, no worries.
@anyone
Hey, I am scanning through everything, and I’m not finding it. Is there a way to change the stats of my character? I would like to try and tweak some settings so its actually a fair fight if I do a LAN party w/5 friends vs 25 man boss.
if you use the us games dbc with a uk game will it work???
is the new ad.exe that does maps and the dbc going to work with the uk game
Oh and the ultimate extractor I was working on isnt work out, so ima try to have it ready for next release, but not in this one!
@Summonence
Thanks for understanding :P
@Kazza
You need to place your maps, vmaps, and dbcs folders here: D:\Reaper_MaNGOS_6245_SD2_474\Data\
can you help me
2008-07-26 19:01:56 Using DataDir D:\Reaper_MaNGOS_6245_SD2_474\Data/
2008-07-26 19:01:56 WORLD: VMap support included. LineOfSight:0, getHeight:0
2008-07-26 19:01:56 WORLD: VMap data directory is: D:\Reaper_MaNGOS_6245_SD2_474\Data/vmaps
2008-07-26 19:01:56 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2008-07-26 19:01:56 ERROR:Check existing of map file ‘D:\Reaper_MaNGOS_6245_SD2_474\Data/maps/5301243.map’: not exist!
2008-07-26 19:01:56 ERROR:Correct *.map files not found in path ‘D:\Reaper_MaNGOS_6245_SD2_474\Data/maps’ or *.vmap/*vmdir files in ‘D:\Reaper_MaNGOS_6245_SD2_474\Data/vmaps’. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
im using 2.4.2 classic wow and i cant find 5301243.map in my maps folder
No i know you have a personal life, why i disappear from time to time, if im not playing game. I have a fiancee etc. It’s all good, just wanted to know if you have a ETA, get some of these guys, to settle down abit. lol. I think they are grinding there teeth too much :P
yes I know its been taking a while but I do have a personal life as well lol! Sunday latest, and most likely tommarow!
Awesome, that sounds great. I will love the new extractor :)
Do you happen to have a ETA?
Yes i have already added the AH bot and and working on some new features you will most likely enjoy!
ARCANE-FIRE EXTRA FEATURES: 1. Ultimate extractor (extracts everything without copy and pasting, moving files, it even moves the maps and stuff back into your UR1 folder)! 2. Colt45’s Custom Creature\Item pack will not contain any custom items this time (sorry), but hope it will next time! 3. MySQL Downloader, downloads MySQL 5.0 or 5.1 without opening up website page after page!
i got a problem with mangos
2008-07-26 10:46:25 ERROR:Check existing of map file ‘D:\WoW\Data/maps/5301243.map’: not exist!
2008-07-26 10:46:25 ERROR:Correct *.map files not found in path ‘D:\WoW\Data/maps’ or *.vmap/*vmdir files in ‘D:\WoW\Data/vmaps’. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
i have wow 2.4.2 classic , running windows xp sp2.
Is the new release going to have Auction house bot. I think you mentioned something about it so this is mainly a reminder. Awesome job by the way. :)
Oh just a note, Colt45 if you don’t mind, double check the backup function is working. Just had a bit of that problem today, forgot it was glitched out. Thanks bud :)
:) I basically said that :) Colt45 if you need a hand with anything let me know
NO if you havent already went bak to 2.4.2 DONT! I am release Arcane-Fire hopefully today!
@ Colt45
Hey buddy, it’s not a problem. Your not always free to help people out. So i can simply help people out.
@ Striike
Same towards you bud. :) I just hope it works for you when you get the upgraded version. So you can extract your maps, etc. better. :)
Just curious Colt45, do you have a ~timing? I’m just wondering if I should go to the trouble of going back to 2.4.2. If you expect the new one to be out in the next day or so, I’ll just wait for it. Thanks for all your work. :)
hey Colt45
i found a bug on a hunter’s ability, the eyes of the beast doesn’t work properly and i don’t know how to debug the error. could you fix it on next mangos database version. i reinstall several times but still can use this spell.
thank you
@Summonence
Thank you for helping everyone out!
@EVERYBODY
Sorry for the delay, but ys I am working on UR1 MaNGOS “Arcane-Fire” which will support 2.4.3 client, and also has a UDB update that should be fixing most of your problems!
@Summonence
Oh, and on the “/” “\” comment. I just typed word for word the error message I got, so I may have miss typed a “/”.
@Summonence
No worries, I’m just happy that I got it right. Thank you for being helpfull.
@ Striike
Hey i noticed when you said they you link it to location c:\Documents and Settings\Ken\Desktop\Reaper_MaNGOS_6245_SD2_474\Data/vmap you do notice that \Data/vmap as in your changing your pathing from a location location to a remote. the slashes need to all be the proper direction. Umm you could also where the path leads to “blah blah blah” just change it to “.” that sets it to the current location. Umm secondly also, when your gathering the vmaps and maps, etc. Yes you need to have the correct version of the client that matches the server capability. Good news is, MaNGOS released a 2.4.3 version today, so we are just waiting on a upgrade from Colt45 and Oatman :) Sorry for the issues. Hopefully it will be fixed soon.
@Bear – Thanks man :)
Guys, I’ve set up a server that my friends can connect to with the intent of doing a little PvP against each other and maybe see some new content (we all quit ages ago due to time factors). However, some of the abilities seem buggy and I’ve noticed that most of the bosses I’ve done are different too… is this normal and if so is there a way for me to fix it?
I’m just trying to work out if my database is corrupt or if I should be looking for ways to script events and reprogram skills. Has anyone been down this path and fixed some of the bugs?
Ok, this is what I’ve had to do so far to fix my problem.
1. Open and edit mangosdCONF file, open and edit realmdCONF file changing candy9 to my password.
2. Edit mangosdCONF file so that it looked for .map files in the wow\data folder rather than c:\Documents and Settings\Ken\Desktop\Reaper_MaNGOS_6245_SD2_474\Data/vmaps which is where it was pointed after install (who is Ken, lol)
I pointed out the above as just an fyi, can’t believe no one else ran into this before me, or maybe its just obvious to everyone but me, I am new at this.
I am stuck at the following point, I’m assuming its because I have 2.4.3 installed and this release is for 2.4.2? Error message follows:
Some required *.dbc files not found or not compatible: E:\wow\data/dbc/spell.dbc Wrong client version DBC file?
I am just making sure I did everything correctly up to this point. I am about to re-instal windows (going RAID0), so I’m not too worried about getting it working just yet, but I want to go full out in a couple days. I am anxiously waiting the version compatible with 2.4.3. Sorry for the long post.
Definitely not in GM mode. And just to be on the safe side, I created a non-gm account (setgm=0) and created a completely new toon.
I can definitely see the mob, even though the Creature Template Addons aura field is set to 8202 (and I don’t have that buff).
Are you testing this out with gm mode on? Cause when your in GM mode, you will always see the mobs, Spirit Healers etc. .gm off try that. see if it works then.
aura question… I’m using Quice to edit both the Creature Template Addons and Creature Addons so that they should be visible only if someone has a particular aura.
eg.. you should have aura 8202 (Sapta Sight) to see the mob 5891. However, when applied it doesn’t seem to work… the creature is always visible.
Can anyone with experience with this type of thing show me what the correct settings are to ensure a creature is only visible if a player has a specified aura?
I have got my server upgraded to Mangos 6245 and I was looking through the new S4 gear and noticed the boots were missing for all classes. Were they missed out of the new release or am I missing something on my database?
@ Striike
Alright, that sounds good. If you have any problems, i will be online most of the day and will be viewing the site about once every 30 minutes. So I can check on updates for the server, and posts. Hope it works out. If not, try opening My computer, and manually find the mysql bin folder. like i said in the above post that you will most likely are linking to the wrong location. If the problem consists still you most likely fastest and easiest way to get it working is uninstall mysql and reinstall it, making sure your using root and then setup your own password for it. Might have accidentally changed the username during installation, you can change it, but by default its root. I program with PHP5 and MySQL on a regular basis, and i still use Root. Thanks.
@Summonence
Ok, thanks for the tips on the mySQL, I’ll give it a shot tonight.
I understand what you are saying about the step numbers, its just in previous versions step 5 included some database building (or something to that effect). Once again, I’ll try it tonight, and if I have trouble, I’ll post better description of my problem (I’m posting at work atm).
For those of you getting “field 63 or 64″ errors on the SQL Creatures table….chances are you are accidently running the old 5953 mangos.exe instead of the 6245. Probably you’re launching an old shortcut on your desktop and didn’t update it.
Mangos Project just released version 2.4.3 today. So its only a matter of time for Oatman, and Colt 45 to upgrade us :)
@ Striike
The missing step #, its just a number pretend 6 is 5.
Now its saying its not connecting to the MySQL server. it’s most likely cause it can’t find the MySQL folder. When i download MySQL and it installs It’s usually 5.0. The Reaper-x usually has it set up to find folder for 5.1. The different in MySQL is too small for you to notice so that is fine. Hopefully you installed it into the default location. c:\Program Files\MySQL Server 5.0\bin After that just hit enter,that will find the required MySQL programs to install the databases and tables.
When you are talking about the username, if you don’t know your username. It mostlikely when you installed MySQL you didn’t change the user, so its ‘root’ but default (without the quotes). The password though is your part.
Oh, and how do you only install up to 2.4.2?
First, I don’t see step 5 listed above, the directions are kind of confusing for Noob like me.
Second, I tried this twice last night (second time because I though I made a mistake) and it failed both times. I’ll get an exact copy of the error message, but it stated that it couldn’t connect to mySQL.
Third, when I ran the reaper .bat file, it asked for the mySQL user name (most likely “root”). I guessed and put down root as the user name, is this correct?
@147
Anytime soon :P?
ARGH! Auto updated to 2.4.3 (on a mac so there’s no repair tool)!
What’s the ETA (roughly) of the next release???
Ahh figured as much, thanks DSH.
PS, any set time for the next release?
This may be a n00b question, but w\e, is there any specific reason why Ragnaros doesn’t spawn in Molten Core anymore. Majordomo Executus isn’t spwaned either. Help pl0x \:D/
Thanks for all the realeses and guides. :DDDD
@ Bear and Hexxus
6245 is only compatible with World of Warcraft patch 2.4.2, not 2.4.3. Be sure that World of Warcraft is only updated to 2.4.2!
Yeah Im having incompatibilities with the newest patch too. Anyone have any ideas? Or do we just wait for the next release?
Thanks!
Hey, I’ve got the server installed and running and overall it works really well. I’ve just noticed a few bugs and broken abilities and was wondering if they’re known issues with the release or if I’ve just screwed something up.
Just a couple of examples are:
Blink rarely works and when it does it can make you fall through the world.
Arcane blast debuff doesn’t actually decrease the cast time (the tooltip is adjusted but it doesn’t actually work).
Devastate doesn’t apply sunder armor, just refreshes.
Rampage refreshes oddly by itself, but when you cast it again (with it still up) it resets the changes to 1.
If anyone knows a way to fix this kind of thing, please let me know.
Hey all, got a question, I did an upgrade on my database and now when I try and connect its telling me it can’t validate game version, is the 6245 not compatible with the current patch right now or no?
For any of the others that are having problems keeping track of all the commands, and running them. There is a very easy yet powerful add-on you can use for your GM’s. My GM’s and myself use it for easier use.
http://code.google.com/p/mangadmin/
On the right side there is version 106 out released today, its updated usually almost daily/weekly, and very easy to understand. It also run the same and installs the same as the others Add-ons. So just extract this into your interface/addons folder and enjoy.
@ Jakslade
Sorry I meant to both of these into the same post, accidently posted two times.
Firstly lookup the creature name/id via.
.lookup creature
then add the creature
.npc add
If you happen to spawn the wrong creature, just click on the creature that is spawned. and type
.npc delete
Newly up-to-date GM Command list is http://www.reaper-x.com/2007/09/21/wow-mangos-gm-game-master-commands/
@ Garrett
The Candy9 is just a password for testing out the server on his test server. He just forgot to rename it as password. Not a actual password, and not a security flaw. Thanks for the note though.
Another Questioned
Whats the Gm Command for Spawning Creatures
It use to be .addspw
but that doesnt work any more
hey just thought id let someone know that in this release someone left there password for a root directory in the .conf files idk if someone already stated this but i thought id let you know incase its any of yours
Hello Colt45, I got one problem to ask for your help. It’s that when my friends and I try to join Arena even 2v2, 3v3 or 5v5 we always start in a place looklike in sky. Could you help me to make Arena work properly ?
i’ve get the same problem as yours but it seem unsolvable. so i decide to use other database instead UDB. however, i get another problem on PSDB. i think i should wait for next release