[RELEASE]Ascent Database Editor Version 1.0.5

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:
o Creatures
o Fishing
o Items
o GameObjects
o Pickpocketing
o Prospecting
o 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

Download:

Filebeam - Free Fast File Hosting
(If you don't have .NET Framework 2 installed, download it from Microsoft site)


Source Code: (For developers, written in VB.NET)
The source code is released under GNU GPL license (3.0): http://www.gnu.org/licenses/gpl-3.0.txt
Forms:

frmBonusChooser.vb - Socket Bonus Chooser
frmCompatiblityTester.vb - Compatiblity Tester window
frmDBDetails.vb - First window, database connection information
frmEditor.vb - ADE main window
frmGOChooser.vb - GameObject Chooser
frmItemChooser.vb - Item Chooser
frmNPCChooser.vb - NPC Chooser
frmPageChooser.vb - Page Chooser
frmQuestChooser.vb - Quest Chooser
frmLogging.vb - Logging Settings
frmSpellChooser.vb - Spell Chooser

Modules:

mdlLists.vb - Some functions for retrieving and setting data in controls
mdlMain.vb - Main module, contains database related functions

Source Code Download Link:
Filebeam - Free Fast File Hosting


Changelog:
Version 1.0.5: (Jan 15 2008)

* Added weather editing and moved item item pages editing to "More" tab.
* Changed Comaptibly Tester error messages, they are much more informative now (also fixed a little problem).
* When all races/classes checked, the flag will be -1 or 0 (items or quests).

Version 1.0.4: (Dec 23 2007)

* You can now import settings from Ascent configurations file (ascent.conf).
* Added "Clear" and "Defaults" on NPCs, items and quests.
* Replaced all gold fields with easier to use GUI (raised the maximum, also).
* Raised maximum items' durability.
* ADE is now changing item flag '4' whether the item is lootable or not.
* Compatible with latest NCDB revision (vendors max. amount and 'columns.dat').

Version 1.0.3: (Dec 17 2007)

* Added a message box before changing columns type with Compatibly Tester.
* Fixed a bug where when item race/class has a value of -1, ADE "thought" it was no race/class.
* Hopfully fixed problems with some MySQL configurations ("default values" and "cannot be null").

Version 1.0.2: (Dec 12 2007)

* Fixed required classes and races.
* Added spell chooser (DBC and `spells112` - thanks titus4k).
* Compatibly Tester now checks for default values and null too (hopfully the end of "Field 'x' doesn't have a default value.").
* Added fields for `ReqCastSpell1..4` (Quests).
* Text ComboBoxes now allows to type IDs instead of choosing.
* You can now double click in any chooser to choose.
* Moved data to files (instead of being hardcoded).
* Tweaked quest flags and special flags a bit.

Version 1.0.1: (Dec 9 2007)

* Removed the brackets in Export query.
* Much easier flags, races and classes choosing.
* Raised maximum item objective count to 30,000 (instead of 255).
* Completely redesigned quests editing UI.
* Page chooser will no longer throw an exception on pages with less than 50 letters.
* The character ' is now escapted in the log too.
* Update to support the newest NCDB version.
* Added buttons to move between previous and next quests.
* Linker\Quests: Added GameObjects starters/finishers and items starters.
* `RequiredRepFaction`, `RequiredRepValue` moved to requirements tab.
* Changed default integer fields value to zero to prevent errors on sozme MySQL servers.
* Quest title is shown outside "Texts" tab.
* Added a note about repeatable quests.

Version 1.0: (Dec 6 2007)

* ADE now saves just the changes (instead the whole query).
* Automatic checking of new versions.
* You can now export NPCs, items and quests directly from ADE.
* Added option to delete NPCs, items and quests.
* Item Pages: Added editor, chooser and a field in items editor.
* Shows DPS of weapons and NPCs (melee and ranged).
* Added GameObject chooser (in quests' objectives and linker).
* UI changes in quests requirements and items spells.
* Fixed a critical bug, disallowing NPC editing.
* Connection error is now more detailed.
* Bonus chooser is now case-insensitive.
* Added a minimize button.
* Fixed quests provided items.
* Much easier factions and zones selection.
* Choosers for NPCs and items Display IDs.
* List of skills (no need to know IDs), and removed sub-skill field.
* Shows a list of some spells.
* Fixed NPC familiy.
* Compatibly Tester:
o Notifying when database structure can't be fixed.
o Now check 14 tables (instead of just 4).
o Added an option to disable Compatibly Tester.
o Option to run ADE without fixing the problems.
o ADE won't restart after fixing.

Version 0.7: (Dec 4 2007)

* Main new feature - Linker:
o Quest starters and finishers.
o NPCs vendors and quests.
o Ability to change loot of:
+ Creatures
+ Fishing
+ Items
+ GameObjects
+ Pickpocketing
+ Prospecting
+ Skinning
* Fixed scale problem on some cultures.
* Compatibility Tester now fixing columns types.
* Added respawn time for NPCs.
* Fixed again (hopefully, the last time) GameObjects IDs.
* NPC flags summary is now showed.
* NPC damage (melee and ranged) fields now have error checking.
* You can now also search by Enter.
* Added ';' to some quries.

Version 0.6.5: (Dec 2 2007)

* Compatibility Tester finished.
* GameObject IDs is now fixed.
* Updated NPC flags (2.3).
* Fixed a problem with items' races and classes.

Version 0.6.1: (Nov 21 2007)

* Rewrote SQL building code. Easier to debug, read and edit.
* In any chooser, you can now click Enter instead of pressing the "Choose" button.
* Compatible with the latest structure.
* When creating NPC, item or a quest (without an entry ID), the entry field will be field with the generated entry ID.
* Added item visual position (sheathID).

Version 0.6: (Oct 18 2007)

* Some very minor interface changes.
* Fixed: Error when adding a quest without choosing a faction.
* Multi-Server - ADE will save multiple database information.
* Fixed: Unique and stack size are now fixed.
* Changed the range of some fields (Int32 to Int64).
* Whoops... Changed 'Databse' to 'Database'...
* ADE is now compatible with more MySQL versions (added ' to UPDATE/INSERT queries).
* "Power" stat type is now "Mana" (items editing).
* Item stats values can be negative now.
* List of sets name instead of ID.
* You can now edit NPC slots display IDs.
* Added sockets to item editing.
* Source code released!

Version 0.5: (Oct 1 2007)

* Item required faction is now drop-down.
* All quest factions fields are now drop-down.
* Reputation "reward" can now be negative.
* Quests texts new lines are now replaced with $B.
* Fixed: Items sub-classes.
* Fixed: NPC factions IDs.
* All Zone ID fields replaced with drop-down (5 fields).
* Added chooser for "Starts by a Quest" field.
* Added choosers (allows to choose by name instad of ID) for quest editing:
o Next and Previous quests.
o Required Quests.
o Source item and provided items.
o Objectives Items.
o Items Rewards.
o Items Reward Choices.
* All flags field show flag (total):
o NPC flags
o Required races and classes for items.
o Quests flags and special flags.
o Required races and classes for quests.
* New icon

Version 0.4: (Oct 1 2007)

* Added quest editing.
* Option to limit results in choosers.
* Note about inventory types.
* Added stack size to items editing.
* Structure Fix: `name` changed to `name1`.
* Structure Fix: `displayid` separated into `male_displayid` and `female_displayid`.
* Fixed: NPC flags are now working (*dOoM*).
* New About tab

Version 0.3: (Sep 5 2007)

* Fixed: A bug with the input validation system (Morfi).
* Fixed: Classes IDs of Shaman, Mage, Warlock and Druid were wrong (mastapain).

Version 0.2: (Sep 3 2007)

* Added items edit.

Version 0.1: (Aug 29 2007)

* Base version (just NPCs edit).

Can someone Remake it for Kobold Db Structure?

thanks' a lot very useful ;)

update for wotlk?

how do i check my database details thing

What do you mean detail things as in stats and stuff?

I have moved this thread to the appropriate section, as this belongs in the Ascent releases.

Impressive looking tool btw.

does this work for 3.0.8