[Release] Ascent Database Editor

[titus4k]

[Release] Ascent Database Editor - ADE version 1.0.3

just want to let you know, ascent got a fine database editor made by vbCrLf.
Official thread:

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

Download: version 1.0.3:

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

The source code is released under GNU GPL license (3.0):

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

Download: version 1.0.3 sourcecode:

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

Changelog:
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 quries).
"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!

Because many people asked me, the source code is released! (VB.NET)

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).

t4k

 

[frozenrat]

Anyone got a direct link for this?

 

[jab416171]

yeah
I registered for the forum
and I can't get it
direct link or mirror please

 

[fr34x0r]

Anyone got a direct link for this?

ditto

 

[deathtilldusk]

i went to emupedia and they had a link.

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

 

[KingXCrosses]

thx death for the link
now i can finally try this

EDIT: npc doesn't really work, and quest doesn't really work either :\

 

[deathtilldusk]

no problem.

 

[vbCrLf]

If you want to see the official thread on AscentEmu.com register there and click here:

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

KingXCrosses, what isn't working? Many people are using it and its working perfect for them.
Which DB are you using and what error is showed?

 

[Shue]

Im recieving an error:

Help?

 

[vbCrLf]

Update your database structure to the latest structure. You have two options:
1. Update your DB (NCDB, ODBC, etc) - just if you haven't changed anything in your database.
2. If you already edited your database and you don't want to lose your changes, manually change "displayid" to "male_displayid" and add a column called "female_displayid".

 

[titus4k]

vbCrLf has released an update to ADE (links above):

Changelog:
Version 0.6 released!

Changelog:
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 quries).
"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!

Because many people asked me, the source code is released! (VB.NET)

t4k

 

[mortanies]

Ok I am new this but for the most part I got most of it figured out, exsept for a few things. I am unsure to how I remove the spawns I have made. I do have a command .npc delete but that removed them from my game so I had to start over.. its all good, if u know the command that would be great ty. also.. I downloaded Ascent Database Editor and I keep getting. (Error while connecting. please check your input

I am seting it up in this order plz let me know what I am typing wrong.

Host:Localhost
Username:root
Password:root
Database:ascent

I have also tryed to use other names it seems to be something I cant figure out.. server works fine just wanted to play with the NPC's make it more interesting.

 

[titus4k]

hmm, i guess there is no command to just remove a spawn entry. have a look here for all commands (not sure if its uptodate):

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

and check the new version 0.6.5.
the setting you gave should work. instaed of localhost you can try 127.0.0.1 . the Database should be our world-database (look for the correct name in ascent.conf, there you once edited the name of world-db).

t4k

 

[janvitos]

I just installed release 0.6.5 and found a bug (correct me if i'm wrong).

When you modify / create items, if they are to be allowed by everyone, the flag will be set at "0".
In my database, allowables by everyone are set at "-1".
What happens is when the flag is at "0" the item is not wearable by anyone.
When i go in the database and change the flag back to "-1" manually, the item is wearable by everyone again.

Anyways this happens to me, maybe you can investigate or tell me if i'm doing something wrong.

 

[titus4k]

try version 0.7. has many corrections and intresting additions.
not sure, but the problem you are reporting is hopefull fixed

t4k

 

[Paco44]

Newest version looks good. I'll give this program a try, and leave some feedback later. Thank you for this release.

 

[titus4k]

version 1.0.3 is out ( Dec 17 2007).
using it with latest ncdb (7xx) might give problems, since database structure has been changed again.
there will be an update soo, i'm sure.

t4k

 

[oliprik121]

Error says that I need something called .NET framwork 2.0

 

[scylla]

lol, you get .net framework from microsoft update site. Useless if you use pirated windows which is probably the case here.

 

[penguinator6]

I needs a little help making these items here. I made the item and all, then did update, went in game and typed .additem and the ID number, said its not valid, help plz