[RELEASE] ManGOS DB Handler

[feal87]

So you've finally come to this post right?
Let's talk a little...WHAT IS Mangos Database Handler?

Mangos Database Handler (MDH for short) is a open source development effort for making a management software, still in heavy developing, that will allow MaNGOS Users to manage the related database. It's primary focus is EASY TO USE, allowing this way even the most newbie MaNGOS user to mess with the information contained in the database. (actually i'm the only one developer )

It's developed in several different modules that are structured to give the chance to modify separated parts of the database (items,characters, quests, etc..). These modules are interconnected each other giving more feature to the end-user.

Mangos Database Handler have Import/Export feature for Accounts/Chars that allow MaNGOS server administrator to easily backup every needed tables inside portable .EMA files compressed and ready to be imported on another server if needed. (very useful after database upgrade)

The software is made completely in C# and it's fully OpenSource under the BSD licence (you must accept the licence to use the software or use the sourcecode).

Copyright © 2006, Ferreri Alessio
All rights reserved.

Redistributions of this software by other people than the copyright owner is NOT allowed in any forms. (source or binary).
This software is maked for an education reason by the COPYRIGHT OWNER and it can be used or modified for educational/private use ONLY.
THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

All title, ownership rights and intellectual property rights in and to the program and all copies thereof (including without limitation any titles, computer code, methods of operation, moral rights, and any related documentation) are owned or licensed by Ferreri Alessio. The Program is protected by the copyright laws, international treaties and conventions, and other laws.

You hereby agree that Ferreri Alessio would be irreparably damaged if the terms of this License Agreement were not specifically enforced, and therefore you agree that Ferreri Alessio shall be entitled, without bond, other security, or proof of damages, to appropriate equitable remedies with respect to breaches of this License Agreement, in addition to such other remedies as Ferreri Alessio may otherwise have available to it under applicable laws. In the event any litigation is brought by either party in connection with this License Agreement, the prevailing party in such litigation shall be entitled to recover from the other party all the costs, attorneys' fees and other expenses incurred by such prevailing party in the litigation.

REMINDER FOR THE BEST USAGE :

1) You need latest Mangos Revision
2) Mangos Database WITHOUT STARTING NUMBER CHARACTER (2177 = WRONG | Hello = GOOD)
3) You need .NET Framework 2.0
4) You need MySQL 5.*
5) You need MySQL to be configured to allow remote connection.

The actual latest revision can be founded at this page with some screenshot too :

To view the content, you need to sign in or register

To view the content, you need to sign in or register

Report in this thread every critic, bug report, feature request, comments or even only thanks.

feal87, MDH Main Developer

 

[commykipp]

I wish there was something like this for wowemu.

 

[Zmiffy]

I love this guys work

 

[feal87]

Posted Revision 22 with these changes from Revision 19 :

1 - FIX Select automatically the first element of the list when loading.
2 - Added Spellid_?,spelltrigger_?,spellcharges_?,spellcooldown_?,spellcategory_?,spellcategorycooldown_? at the items management page.
3 - Added DB.DB and related management code that contain all spells information for lookup while browsing or modifying items.
4 - Named all labels
5 - Added a SpellDB browser with searches enabled.
6- Fixed a little bug with ' in the realm name
7- Fixed some bugs inside configuration file.
8- Fixed a problem with the item modification

 

[derpenner]

WoW!

Nice work bro

 

[tr4shm4n]

This looks promesing .
Dunno if it is ment to do this i have added 2 weapons before i installed this need program however when i search for them in the items screen it caant find them .

Keep it going m8 so far it looks nice .

 

[feal87]

Search actually should work fine, maybe you aren't searching correctly, anyway...
Tell me the name of the item and the search syntax you are using so i can try to reproduce the problem and fix the bug if there is one.

 

[commykipp]

Here is an idea for the program. If you could add and option for changing the creatures max level and stuff meaning there will be question like "Whats the max level of your server?" you type in 100 then it adjusts the creatures for a level 100 server. Meaning if the highest level non boss mob is level 60 they are now level 100 and the rest of the mobs follows suit. So you would have to find the percentage increase from level 60 to level 100 then multiply that number to the max health max mana and max damage.

 

[feal87]

Here is an idea for the program. If you could add and option for changing the creatures max level and stuff meaning there will be question like "Whats the max level of your server?" you type in 100 then it adjusts the creatures for a level 100 server. Meaning if the highest level non boss mob is level 60 they are now level 100 and the rest of the mobs follows suit. So you would have to find the percentage increase from level 60 to level 100 then multiply that number to the max health max mana and max damage.

It's a nice idea but first i have to complete all the basic part of the software. The old style management. After that i'll work on "special" feature like this.

Anyway POSTED REVISION 24. (we are very near to a full items management page)
Changes from revision 22:

1 - Deleted lots of wrong entry in the SPELL DB
2 - Added displayID, ReqSkill?, ReqSkillLvl?, ReqSpell? fields in the item management page.
3 - Added the Faction DB and the Skill DB for lookup.

4 - Fixed an exception when writing crap in the lookup field.
5 - Fixed an exception when writing too high number that does not exist in the lookup field.
6 - Fixed a problem with items with the same name. (Now you can select every single item with the same name)
7 - Fixed a problem with deleting items with a ' in their name.
8 - Changed the rest of the code according to the new system.

 

[tr4shm4n]

well i chearshed with the name i used for the item in this case it was an weapon that i have took out of cronos pack specialy for gamemasters . I copied the name from navicat in shearsh fuction but it could not find it also i added Corrupted Ashbringer to my db witch not could be found as well . It's not an real big problem at the momment for me becouse item adding is not that hard tru navicat but your program make it an loot easyer .

 

[feal87]

well i chearshed with the name i used for the item in this case it was an weapon that i have took out of cronos pack specialy for gamemasters . I copied the name from navicat in shearsh fuction but it could not find it also i added Corrupted Ashbringer to my db witch not could be found as well . It's not an real big problem at the momment for me becouse item adding is not that hard tru navicat but your program make it an loot easyer .

try to search instead of Corrupted Ashbringer only Ashbringer or only Corrupted or only bringer and so on.
The program will do a filter and show you the relevant results. Its strange that he don't find the item.

Try this way and tell me what happen.


UPDATE - Anyway the adding of new items will be included very soon after i've reviewed every item fields.

 

[tr4shm4n]

Already tryed that normal ashbringer was found and it start shearshing but never found the corrupted one .

I use rev 24 and 22 both are finding other items well only not my added ones thats basicly all it dont give any error masage it just cant find it .

 

[feal87]

Can you extract via navicat the lines regarding the corrupted ashbringer?
So i can test on my PC.

 

[Fearlest]

niceeee an item creater for mangos allready ^^

 

[feal87]

Posted Revision 25 WITH ADD FUNCTION ENABLED

Changes from Revision 24 :

1 - Added Extra, ScriptName?, itemset, ContainerSlots?, RequiredCityRank?, MaxDurability?, StartQuest?, RangedModRange?, and every other fields remaining to the item management page.
2 - Added the Itemset DB.
3 - Inserted Licence in the new files.
4 - Added a first beta of the ADD item feature.

 

[kneppercr]

Alrighty, I may just be dumb, but I can't figure out how to edit items. It seems that any change I make to any item will not be saved either before or after I hit the edit button. My database names locations and passwords are correct because I can edit accounts easily. A little help would be great. Thanks and great work.

 

[Zmiffy]

kneppercr when you edit the item in the database does it change there? if it does.. You have to delete your WDB folder in the wow folder and then add the item

 

[feal87]

yep Zmiffy is right, because WoW cache lots of item and other things in the WDB folder, and this way it appear like nothing changed.

 

[tr4shm4n]

here is info of ashbringer and my gmsword i made . It was not done with the item editor i have edit them in DB manualy

INSERT INTO item_template
  (entry, class, subclass, name, name2, name3, name4, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, Extra, block, itemset, MaxDurability, area, Unknown1, ScriptName)
VALUES
  (22691, 2, 8, "Corrupted Ashbringer", "Corrupted Ashbringer", "Corrupted Ashbringer", "Corrupted Ashbringer", 35097, 4, 0, 1, 10000000, 100000, 17, -1, -1, 85, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, -25, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 259, 389, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 28282, 1, 0, -1, 0, -1, 7598, 1, 0, -1, 0, -1, 15464, 1, 0, -1, 0, -1, 29155, 3, 0, -1, 0, -1, 0, 0, 0, 0, 0, 0, 1, "Blade of the Scarlet Highlord", 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 120, 0, 0, "internalitemhandler");

INSERT INTO item_template
  (entry, class, subclass, name, name2, name3, name4, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, Extra, block, itemset, MaxDurability, area, Unknown1, ScriptName)
VALUES
  (85510, 2, 7, "Sword of the mighty Game Masters", "Sword of the mighty Game Masters", "Sword of the mighty Game Masters", "Sword of the mighty Game Masters", 32603, 6, 0, 1, 0, 0, 13, -1, -1, 255, 255, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 99999, 3, 99999, 4, 99999, 5, 99999, 6, 99999, 7, 99999, 0, 0, 0, 0, 0, 0, 0, 0, 999999, 10000000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 50000, 99999, 99999, 99999, 99999, 99999, 500, 0, 0, 15821, 1, 0, -1, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "When you have this weapon you must be an game master", 0, 0, 0, 0, 0, 1, 3, 0, 0, 8500, 255, 0, 0, "0");

 

[feal87]

I searched and founded the ashbringer without any problem.
There is however a new problem.
Was the -25 stamina...i did not allow minus value.

Resolved and posted Revision 26.