[latruwski]

<b>

ADE ME 1.2.2 for 2.4 released!

Ascent Database Editor ME 1.2.2

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.

Releases:

- Ascent DB Editor Modified Edition 1.2.2 Download:

[Only registered and activated users can see links. ]


Changelog:

 ## 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:
- 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.

ToDo:
- Item Example
- Creatures Tab > equipinfo1, 2 and 3 Dropdown
- GameObjects Tab
- Custom Table Names
- Character DB Implementation
- Creature/NPC/GameObject Spawner/World View Spawns (Tool to see existing spawns/add new spawns cordinated via X, Y and Z positions)

My post were originally posted at AscentEmu.com, but sadly, they have now closed and i've been waiting a few days now to see how OpenAscent.com have been working out, and i do see potential in the work you are doing here.
So from now on, i'll hang out around here and keep ADE Modified Edition uptodate with OpenAscent's work on the Ascent emulator.

Originally Posted by FleX

I'll be updating my thread here within a few days with new information about my work on ADE, and i'm sorry you've not got the source yet, but i won't release the source until i've completed my ToDo list and also becuase there's still ALOT of loose ends in the source wich i need to fix/add etc.

Originally Posted by FleX

I know it's released under the GNUGPL, but that doesn't mean i can't hold back my modified source till i've fixed all the loose ends i've made. As my source is atm. you'd get nothing outta getting it, as it has so many loose ends and messed up code becuase i'm not coding the same way as vbCrLf does. So i'm not breaking the GNUGPL license, becuase i AM gonna release the source along with the finished version and my modified edition isn't even released yet actually, some people just asked for a pre-taste of it, so you can somehow call it a beta version of what i'm gonna do to it.

So simply said: I don't release half work, these releases are just pre-tastes of the finished ADE Modified Edition.

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 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:











Download:
[Only registered and activated users can see links. ]
(If you don't have .NET Framework 2 installed, download it from [Only registered and activated users can see links. ] site)


Source Code: (For developers, written in VB.NET)
The source code is released under GNU GPL license (3.0): [Only registered and activated users can see links. ]
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:
[Only registered and activated users can see links. ]


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:
  • Notifying when database structure can't be fixed.
  • Now check 14 tables (instead of just 4).
  • Added an option to disable Compatibly Tester.
  • Option to run ADE without fixing the problems.
  • ADE won't restart after fixing.

Version 0.7: (Dec 4 2007)

• Main new feature - Linker:
  • Quest starters and finishers.
  • NPCs vendors and quests.
  • 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:
  • Next and Previous quests.
  • Required Quests.
  • Source item and provided items.
  • Objectives Items.
  • Items Rewards.
  • Items Reward Choices.
• All flags field show flag (total):
  • NPC flags
  • Required races and classes for items.
  • Quests flags and special flags.
  • 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).

Great thanks to titus4k for his help!</b>

credits still go to vbCrLf from ascent forums


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


grtz

[Hallowsend]

So... can this be used as a hack or is it just for people who know the MySQL pass

[latruwski]

Originally Posted by Imperfection

So... can this be used as a hack or is it just for people who know the MySQL pass

this is the emulation section... so this is a program for server owners lol

the section for hacks/bots:
[Only registered and activated users can see links. ]
but i see a lot of people confuse them :-/

grtz

[Aldaus]

I love this,
thank man ^^

[damegu]

Great work

[latruwski]

post updated with new version !

grtz

[Viter]

nice one +rep

[Gawdlaw]

Damn Nice! +rep

[evan1612]

If I could, I would definitely + rep you! I really needed this, because I make items/creatures/quests on the server I GM on, so it helped A LOT!

[*TraPStaR*]

yeah this is pretty nice i use it alot thanks

[kayleta]

Pretty useful for editing NPCs and items, I think I will download this

[latruwski]

thx for the comments i keep this updated

grtz

[Gastricpenguin]

Dude everywhere i go i see you post something more amazing then the last xD
This will definately come in handy later

[latruwski]

Originally Posted by Gastricpenguin

Dude everywhere i go i see you post something more amazing then the last xD
This will definately come in handy later

i posted some nice stuff... like precompiled core revs (updated frequently) but people are probably confused what the topic is about :-/ now the topic is not on first page anymore and i know a lot of people are too lazy to read more then 1 page xD well when i post a new update for that topic it will be on first page again, then maybe people will check it
(sooo much people were asking for a place to download ascent core revs... and when there is finally a topic about it they don't even read it )

thx for the comment, i appreciate it

edit: btw i emailed you on the emailadress you gave me... :P

grtz

[jtmurkz]

Nice! But what do i open it with o.O