AscentDatabase Editor 1.2.2

Quote:

---

Originally Posted by FleX
Hello everyone, i'm modifying the Ascent DB Editor made by vbCrLf.
So if you have any suggestions for me to add to it, then just let me know.

!IMPORTANT! Before reporting bugs please make sure your database structure is fully updated.

I've now released my work on Ascent DB Editor, it's not complete yet and alot of my additional functions is disabled so far.
But it will all be working in one of the following updates i'll release.

Also please send bug reports/suggestions via PM.

---

Change log

Code:

---


 ## Version 1.2.2 ##
- Corrected Item Weapon Subclasses
 
## Version 1.2.1 ##
- Items > Spell Cooldown and Spell Category Cooldown can now be set to -1 wich it couldn't before.
- When loading an item, it now also loads the item Flags.
- Re-ordered all Creatures/NPCs and Item Interface TabIndexes
 
## Version 1.1.8 Pre-Taste ##
- Added "Weapon Expertise Rating" to the Stat Type modifier.
- Fixed a few TabIndexes
- The SQL Gen. Button now generates a working SQL Query even if Item Name/Description has ' in it.
 
## Version 1.1.5 Pre-Taste ##
- Added the Generate SQL function for inserting items, but still need to add it to generate the update query.
- Added Isle of Quel'Danas Zone ID
 
## Version 1.1.3 Pre-Taste ##
- Fixed the Gold Chooser to load/save the correct values, where it before would round ie. 8640 to 1g 86s 40c.
 
## Version 1.1.2 Pre-Taste ##
- Fixed version checker to now link to the right mirror
 
## Version 1.1.1 Pre-Taste ##
- Fixed a bug where it rounded the walk/run/fly speed to a non-decimal number when loading a creature/NPC

---

Features added

Code:

---

Features Added:
- SQL Tab
- Creatures Tab > Gen. SQL Button (Will generate the SQL Query for the Creature and throw it into some textboxes in the SQL Tab)
- Creatures Tab > Database Details Button (Will show the Database Details dialog again, so you can change connection)
- Creatures Tab > Armor Field
- Creatures Tab > Resistance Fields
- Creatures Tab > Male/Female DisplayId2 Fields
- Creatures Tab > Mount Display ID Field
- Creatures Tab > Money Drop Field
- Creatures Tab > Invisibility Type Dropdown
- Creatures Tab > Death State Dropdown
- Creatures Tab > Walk, Run and Fly Speed Fields (Now with Default values: 2.5, 8 and 14)
- Items Tab Modified (Now works again, with the current structure)
- Items Tab > Item Flag Dropdown
- Items Tab > Added stat_type/value 9 and 10
- Items Tab > Required Disenchant Skill Field (Only works if the CheckBox is checked)
- Items Tab > Unique now only works if the CheckBox is checked, otherwise the value will be 0
- Items Tab > Container Slots Field is now only enabled if Class is set to Bag or Quiver, otherwise value will be 0
- Items Tab > Container Slots Max Value is now set to 36.

---

Download: http://rapidshare.com/files/12012080...1.2.2.zip.html



All credits for the ME version go to flex from ascentforums !

I'll still leave the link to the 1.0.5 version since a lot of people still use it [IMG]http://www.************/forums/images/smilies/smile.gif[/IMG] here it is:
Ascent Database Editor Version 1.0.5
(Source code released)


Features:

• Complete NPCs, items, quests and items pages editing, creating and exporting.
• Import settings from Ascent configurations file.
• Automatic updater.
• No need to know ID of anything (NPCs, items, quests, bonuses, etc).
• Option to log the queries (for making patches).
• Automatic structure problems fixer.
• Option to change quests starters and finishers.
• Ability to change vendors' items and quests.
• Very easy to use GUI.
• Edit loot of:
  
  • Creatures
  • Fishing
  • Items
  • GameObjects
  • Pickpocketing
  • Prospecting
  • Skinning

Screenshots
http://img360.imageshack.us/img360/4484/npcwf4.png http://img360.imageshack.us/img360/9926/itemxn2.png

http://img360.imageshack.us/img360/4849/qucn8.png http://img518.imageshack.us/img518/194/lqjr5.png

http://img505.imageshack.us/img505/8971/lnyz4.png http://img514.imageshack.us/img514/2964/llpv6.png

http://img213.imageshack.us/img213/6189/dbuk8.png http://img338.imageshack.us/img338/7961/loggjm0.png

http://img514.imageshack.us/img514/7733/compew2.png http://img81.imageshack.us/img81/6886/npcchul1.png