[0.6 Hermes] MaNGOS Database Manager

[Kalash47]

MaNGOS Database Manager
MaNGOS Database Manager is an application written in Visual Basic .NET 2008 that is specifically used to develop, customize and edit your MaNGOS World Database. The tool boasts several editing features such as

• Support for editing Items
• Support for editing Creatures
• Support for editing Quests
• Support for editing Loot
• Support for editing Links
  
  • Creature & Gameobject Quest Start/Finish
• Support for editing Vendor content
• Tracks changes (Logging support)
• Support for saving multiple connections
  
  • Secure with encrypted data file
• Support for latest MaNGOS Revision
• Support for 2.4.3

Milestone 0.6: Hermes
The milestone has been worked on for several months, and with the latest release we've not only added more or less full implementation for all Item, Creature, and Quest tables, but we've also purged most if not all of the bugs in Hermes. For full changes, few the full changelog below:

	+ General
		+ All new database entries start with a number of 100,000 - 200,000 or higher on all editors
		+ Logging Settings button moved to "Home" tab (we need the space for upcoming tabs on main editor)
		+ Rewrote Subclasses, Stat Type, Damage Type and other comboboxes to support latest MaNGOS revision
		+ General code clean up for faster performance and easier maintanability
		+ Fixed ReqSpellCast Bug
		+ Fix in EntryID/DisplayID mix in areas of the app
	+ Item Editor Code Clean Up
		+ Support for PageMaterial + LanguageID + TotemCategory + BagFamily + Material columns
		+ Support for RequiredDisenchantSkill + Food Type + ScriptName + Duration columns
		+ Item Flags support
		+ btnItemChooseQuest implementation (Item Editor -> Misc Tab)
	+ NPC Editor Code Clean Up
		+ NPC Editor Interface changes, new tabs corresponding to added support for new tables
		+ Support for npcflags, dynamicflags, flag1, mechanic_immune_mask, flags_extra columns
		+ Support for regular, skinning and pickpocketing loot id columns
			+ edit button for each of these
				+ removal of creature loot edit button 
		+ Support for trainer_type, trainer_spell, class, race columns
		+ Support for regenhealth, equipment_id columns
		+ Verticle Scroll bar for Flags MiniTab
		+ CharTitleID support
		+ Flags now show if user clicks on corresponding label
		+ Added default values for npc editor loot tab & trainer info tab control/s

	+ Quest Editor
		+ Provided Items Buttons function
	+ Loot Editor
		+ Now links to specific loot id specified within each object rather than the object entry id
		  (unless it's supposed to be that way)
	+ Linker
		+ Support for add/remove for gameobject starter, gameobject finisher, item starter
		+ (npc vendor edit) column discrepency issues (now data is loaded properly, and updated properly) 
		+ (npc vendor edit) default value for mtbLNExtendedCost

Screenshot

Thanks to Dythzer

Download
You can get the file from our downloads section.
Please post any mirrors you would like to add to this post.

Resources
Please report bugs in the Bug Reporting section.
If you have any issues with the app, post here.

Regards,
MDM Development.

PS. I realize that there is a user who shared the previous release of our tool BUT I am the official developer of MDM and I will be updating this particular thread with new updates & releases.

[tukotih]

This works really good!
Well done job!

Although, Making it compatible with the WotLK Mangos database you will get far more real-active users

[Rashidali]

Well I dont get it i start the program which database do i link it to? sorry Noob SQL x.x

[Kalash47]

This works really good!
Well done job!

Although, Making it compatible with the WotLK Mangos database you will get far more real-active users

It should work If you have any issues, please report it in our forum and I will get it fixed.

Well I dont get it i start the program which database do i link it to? sorry Noob SQL x.x

Your world database, the one with items, creatures, quest, and so forth.

[Dythzer]

PS. I realize that there is a user who shared the previous release of our tool BUT I am the official developer of MDM and I will be updating this particular thread with new updates & releases.

Of course Nice to see you still working on it. Deleting the old thread.

[Kugro]

Sorry I'm noob but I'm not entirely sure what this program is for.. Is this for editing servers? Or for creating your own server? Or..something else? Because I don't know what to type in for database..

[Kalash47]

Sorry I'm noob but I'm not entirely sure what this program is for.. Is this for editing servers? Or for creating your own server? Or..something else? Because I don't know what to type in for database..

It's for editing your WORLD database (with items, creatures, quests, etc) and it is exactly for editing these types of things. Notice the Item, Creature, Quest editors in the screenshot.

It will allow you for editing this information & creating brand new stuff.

[Dj-Dejan]

nice prog!

[Kalash47]

Hotfix 0.6.1 has been released on our forums.

Check it out.

[Kalash47]

friendly bump

[fccs]

And how to setup my Connection....hmmm didnt answer it here. Maybe its on the other forum....hmmm not there either. Noobs here go by what is posted and what is posted is not enough to help. =) How do I setup my World Connection

[Kalash47]

The link has been fixed.

Also, it's pretty straight forward considering you've had the knowledge to setup your server.

You apply the same information as you did for the server to connect.

If your MySQL server is on the same computer as the app, then your server is "localhost", port is usually 3306, so leave that at default, and you fill in with your username and password (sometimes root/root, or root/<blank>, or whatever you set it too) and finally, the name of the database (usually mangos or world).

[fccs]

Oh my god! I was trying flie paths. I had no clue to just type in MaNGOS. That is easy. Well I got no problem anymore. Thanks bud I am enjoying this program to the fullest.

[Kalash47]

Oh my god! I was trying flie paths. I had no clue to just type in MaNGOS. That is easy. Well I got no problem anymore. Thanks bud I am enjoying this program to the fullest.

Wonderful, glad to hear everything worked out great.

[Sounddead]

Even though I don't use MaNGOS (Still a Ascent junkie) it looks like a really nice programs, and I love everything you do in emulation :P.

+rep when I can