DBViewer Version 0.5.1.0 and DBEditor Version 0.0.2.0

Notable additions for DBViewer:

• Added support to load multiple compact database files
• Added basic achievements page
• Added support for 5.x and 10.x clients
• Various addition information for NPC, including spawners and others

Notable additions for DBEditor:

• Updated DBEditor to be on par with current AAEmu develop branch for compatibility
• Added a simple Auction Bot Tool to DBEditor that allows you to run a automatic AH populating tool that can be configured

Full Changelog: v0.5.0.0-e0.0.1.3...v0.5.1.0-e0.0.2.0

DBViewer 0.5.0.0 - DBEditor 0.0.1.3

DBViewer updates:

New look using tool buttons with icons rather than the old tab pages. As well as several new pages.
Added shortcut keys for the following
F2 - Quests
F3 - Skills
F4 - Doodads
F5 - Buffs
F6 - NPCs
F7 - Items
F8 - Localizer
F9 - Map
The keys are chosen for the most common uses and the F-key is always somewhat above the first letter of the tab with (as on a qwerty keyboard)

You can now use Ctrl + (shift +) Subtract to go to the previous (next) tab you have opened.

Added a system to create profiles on the settings tab. A profiles saves the currently loaded DB, game_pak and locale settings. IT can be loaded from the settings tab, or from the File menu.

Other details:

• Skill execution TreeView now shows all of the fields of the skills table fields with exception of name and description fields.
• Added more icon support to custom property nodes
• Added Ability (skill tree) names to custom property nodes
• Added Schedule tab that shows seasonal or in-game events.
• In-game scheduled events will also show their related quests, doodads and NPC spawners
• Added loading of QuestMonsterNpcs
• Added loading of TowerDef schedules. You can find them under Schedules -> Rifts
• Added 3.x compatibility for TowerDef
• Added more info to NPC tab
• Schedules will now correctly show in Selected Data tab
• Split up MainForm.cs into multiple files as it was getting to big
• Did some minor name fixing
• Added Spheres tab
• Added functionality to TreeNodeWithInfo to allow pinning things on the map when double-clicked
• Fixed line counter when loading quest sign sphere file
• Added loading of unit_reqs
• Added requirements node to skills
• Added GameUnitReqsKindId names and descriptions in it's comments
• Added requirements for Armor and Weapons, It is added to the item description.
• Fixed some alignments of panels that happened when I was switching from multi-row to single row panels
• Added Spheres tab to menu
• Localizer now shows keys and category for ui_texts table
• Added a grid option for use with level paths folders. It creates a 256x256 grid, and the number represent the xxx_yyy folder names of the instance.
• Added Zoom +/- buttons to MapView
• Moved the settings to a actual settings page.
• Added a few more GM Command labels
• Added unit stats and buff modifier info to buffs
• The ComboBoxes with search history should now correctly enable the related Search button when picked from the list
• Moved all form event functions back to the mainform.cs as it was getting annoying when trying to do editing on already existing events that are in other files.
• Added history for spheres

DBViewer Version 0.4.2.0 and DBEditor Version 0.0.1.3

DBViewer

• Added some basic NPC spawner information to the NPCs
• Added NP Skills view to NPCs
• Added Initial Buffs to the NPCs
• Added Interactions to the NPCs
• Added AI file name to NPCs
• Added loot pack items node (by Nikes)
• Added NPC base skills
• Added search text history for the following search boxes: Buffs, Doodads, Items, NPCs, Quests, Skills and the manual SQL text box.
• Fixed buff search anchor settings so it doesn't deform anymore when you resize
• Changed search histories so they are now saved with the character case instead of all lowercase (needed mostly for SQL history)
• Fixed a issue where Monster Group Names data was always empty. Also fixes duplicate entry issues for NpcInteractions and AiFiles if the DB was changed at runtime.
• Added Passive Buffs and Initial buffs and skills to the Vehicles tab
• Enhanced the search of vehicles to also include the model type description
• Double-Click on custom node properties now uses the Id rather than the name for auto-search functions
• Fixed the issues where auto-search from a double-click would not first enable the search button. Making the initial search not work.
• Added Vehicle bindings
• Fixes for compatibility with database version 3.0.3.0
• Skill effects will now display their trigger rate based on their weight (if they are weighted)
• Added skill id to skill tree plot root
• Added Owner names to the Faction search
• Removed Owner Name localization field and replaced it with grabbing from the NPCs table.
• Added experimental new Loot table view to NPC tab

DBEditor

• Updated EF to most recent develop version of the AAEmu DB as of 2024 May 25
• Fixed the issue where it was not possible to add a SKU if there were not previous ones.
• Added basic item search
• Item Form is now decently searchable
• Added new iteration of ClipboardHelper
• Labels on the Items form can now be copied to clipboard like in DBViewer
• ICS Shop Editor now has buttons added to lookup ItemIds for SKU and item display overrides
• Added support to Server -> Accounts to allow Add, Delete, change Username or Password for accounts
• Added Random password generator for accounts
• Added filter option for the accounts list, can use account names or character names to filter
• Account editor now allows editing Labor, Credits, Loyalty and AccessLevel (account level only)
• Added warning when trying it edit to remaining sales on a ShopItem and it's value had changed.
• Fixed issue where account details would not update if it was changed by the game server while the editor was running.
• Added and enabled character server data viewing
• Moved GetMoney function to AaTextHelper class as CopperToString
• Added tab page for owned objects like Pets and Houses
• Character Stats tab now contains more stats
• Character class name now has it's name as well as it's individual skill trees displayed

Co-authored-by: NL0bP
Co-authored-by: nikes

DBViewer Version 0.4.1 and DBEditor Version 0.0.1.1

• Fix map coordinate constant
• Added support to load AAEmu water bodies definitions onto the map as paths.
• Calculated more accurate loot rates
• Added localized names to the doodad execution tree. Also added this name for next_phase fields in the tree.
• Added human readable time values in execute tree
• Added DBEditor project using EF
• Added account viewer to DBEditor
• Added In-Game Cash Shop editor to DBEditor
• The field "zone_id" will now decode to both the zone key and the zone group id in DBViewer
• Updated all projects to .NET 8.0

Version 0.4

• Added quest workflow in the same style as the last doodad workflow change
• Added some more info about quests, and a simple quest overview similar to how it's shown in your quest tracker
• You can now double-click on properties in the Treeview for doodads and quests workflow to copy the entry to clipboard.
  When it is a entry that has auto-completed values on it, like for items, skills, etc. it will also open the search-tab for the selected entry and search for it.
• Added skill effects listing to the Skill Plot Tree
• Buff in the skill plot effects list will now show their icon if available.
• Added auto-complete on fields with "tag_id"
• Added buff trigger view
• Added trigger effect actual name & id
• Added Better trigger node, style like existing
• Removed the tabs for buffs, and also added support for double-click on their properties.
• Added descriptions for special_effect_type_id.
• Set the scrollbar property for the other values flow panel
• Hide empty fields button for Buffs
• More icons to properties
• Added a tag search tab
• Fixed anchors on tvQuestWorkflow and on the listboxes of the Trades Tab
• Toggling the checkboxes to show/hide empty values will now trigger a reload of the related treeview
• If Id's for custom map PoI data is not found in the DB, it will try to read the json's name property
• Now allows loading of localization from a external file that is in the same directory and extension as the source DB, but with the localization name as it's name
• Added new range filter "Extra" to Item search
• "Optimized" item search, limited the results, and added a "progress bar"
• Updated base AAPak code, and added customkey support.
  Added small hack and optimization for memory usage
• Added Language selector for external DB
• Removed Fody
• Added support to search items based on their impl_id (item type/class)
• Added support for effects with fields that have a translation. It now now show the translation instead of the original value for these in a different color
• Added a splitter to the Skill tab so you can resize the search list and the execution tree and details info
• Added name for wi_id in the skill tree view
• Added more details for skill plots (conditions and effects)

Version 0.3.7

• Added in-level (zonekey) offset in the mapview statusbar
• Added more options on the map viewer's popup menu
• Added Doodad exporter
• Added Doodad Workflow Tab that shows details about phases
• Added a drop-down box to search only region specific items (id >= 8000000)
• Improved colorings in description boxes for items, skills, buffs
• Items will now also list their use effect in the description like in-game

Version 0.3.3

• Changes to how the map is drawn
• Added label for /addbuff command
• Added find doodads in zone button
• Search by equipment slot should now work correctly
• Added area shape viewer
• Added questnames to export
• Added SubZone viewing by Spiral
• Added WIP Skill Plot viewer
• Searching NPC and Doodads from within the Zone tab now goes WAY faster
• Selected and Nearby Points of Interest are now also shown in the statusbar of the map viewer
• Added customizable popup menu in the map viewer that allows you to copy data to clipboard about the selected item

Version 0.3.1

• Quest Sign Spheres now display at the correct location.
• Added json exporter for NPC data
• Added instance selector to the map viewer (only affects drawing of the maps, not the displayed data)
• Added a text filter box for the tables list
• Added a grid size selector for the map viewer when units are selected as grid type

Version 0.3

Added map viewer (check new Map tab)
You can view NPCs, Doodads, vehicle paths and housing
For NPCs and Doodads (at the new tools tab) you can use the find button on their tabs
Note that for now, quest sign sphere data shows incorrect locations.
Supports 1.2 and 3.5 clients (others might work, but not tested)

Version 0.2.5

Added banned zone tags
Added Quest Components and Acts view
Added Localizer tab for quick searching localized texts
Added Buffs viewer
Added simple view for tags for Buffs, Items, NPCs and Skills