Server Database Editor 1.1.8


9 Screenshots

About This File

Heya!

This is a new project I've made aiming to manage the various databases as easily as possible. This tool was initially developped using Client database editor's engine, a tool from GRF Editor. It has been adapted to support more database formats and many of the features have been improved.

How to install

  • Download the zip archive provided from the download link at the top right corner of this description or directly from there : http://www.mediafire.com/download/p0zhcc8ipa6cjt3 .
  • Install the application with SDE Installer.exe; if you are missing a .NET Framework you will be prompted to download it.
  • Once you are done, you can start the program from the link on your desktop.

Features

  • Both rAthena and Hercules' formats are supported by the application.
  • Many conversions between rAthena and Hercules are possible. Converting items can be done simply by right-clicking on the elements and selecting "Copy entries to clipboard (ServerType)".
  • Undo and redo commands are available, as well as navigation commands (quite useful when switching tabs a lot).
  • There are many shortcuts within the application, all of which are shown when right-clicking items or going through the menus. I do plan on adding more as well.
  • The databases are 'merged' between each other to offer an easier view. This is true mostly for the item and mob databases.
  • Flag fields can be entered with either an hexadecimal value or an integer value. You will have to add "0x" if you want to enter an hexadecimal number though.
  • For Windows XP users, the program's layout may change a bit. The Aero theme is applied to make sure the application looks like it should.

Getting started

Create a new project from File > New project. Go in the settings tab and set the path of your database. If you're using pre-renewal, then drop the pre-re folder in the "Server DB path" box (drop the re folder otherwise). Don't drop your "db" folder, it simply won't work!

Save your project file to avoid redoing this step everytime you reload the application by going in File > Save project info. The project info file is automatically saved, so you don't need to save it everytime you do a modification in the settings. If you associate .sde files with this tool, you will be able to start up your project from the project file directly (which is more convenient).

The last setting is the resource files and it is optional. Simply drag and drop a GRF in the paths list. This will add icons in the items list view (it will also make the application slower when scrolling for that list).

tjf4tkf.png

Easy input fields

All the fields are easy to set and most of them have tooltips. For example, to edit the drops of a mob, simply right-click on the items and change the drop value (both float and integer values are accepted in the field : typing 5.20 is the same as typing 520).

rDISHdi.png

How to save the database

There are multiple ways to save the database : quick save, full save and export. Quick save keeps the commands you've applied on the database (Ctrl-S), this is the saving option you should be using. Full save (Ctrl-Shift-S) does not keep the commands and you will not be able to undo any operations afterwards. Export (File > Export to db/SQL) exports the database to another folder and this is normally used to convert databases.

When saving, the comments are preserved as much as possible, but this is not always possible. For example, the items table from Hercules is always rewritten, so the comments will be lost in this file.

Unmodified tables will not be saved. Disabling a tab will also prevent the associated table from being rewritten/saved. This can be achieved by right-clicking on a tab and selecting "Disable 'table name'".

kGFCrfl.png

SQL support

You can export your current database to SQL from File > Export to SQL > ... The first option in the list is the current database format. The other options are used for conversions between rAthena and Hercules.

ULAstHD.png

Backups system

The application automatically creates backups everytime you save the database (can be disabled in Settings > Enable backups manager). You can revert to a previous date by going in Tools > Backups manager. This tool's purpose is to make sure you never lose any important data (as well as preventing data corruption).

Xa3ov3d.png

Merging or adding lines from another database

It is possible to merge databases by going in Edit > Add item from raw db line. Simply copy and paste the lines from the database you want to add. You must select the corresponding table before doing so, of course. (Known bug : adding lines with invalid parameters will put the database in an invalid state).

Synchronize with client database files

If "Synchronize with client database files" is checked in the Settings tab, you'll be able to turn on all the following features.

Bind item tabs together (suggested by UltraCat)

This feature enables you to quickly alternate between the Item and Client Items tabs. Whenever you switch table, it will autoselect the item previously selected. The text search filter will also be applied to all three tables (Item/Item2/Client Items). Subfilters (such as item description, script, etc) will be ignored if the item isn't included in the search result.

Manage view IDs automatically (suggested by UltraCat)

This feature allows you to completely ignore the view IDs for headgears and costumes. Only the identified resource's field is taken into account when synchronizing with the client databases, so make sure you set at least this field! You must also set up the lua paths; go in any item table and click on the wheel next to the "View ID" field.

CErEQ7w.png

This will bring up a dialog to setup the paths (preferably, the files should be located in your data folder to avoid saving the GRF all the time). They will be automatically decompiled if necessary.

vVYhG7n.png

If everything has been properly set, the View ID field for the headgears and costumes will be grayed out. When saving, you'll notice some view IDs will be switched around, but SDE will try to keep your original IDs as much as possible. The view names will be changed to the item's Aegis Name (has no effect ingame).

Mob sprites edition

In the mob tables, you will find a wheel button, similar to the view IDs. Setting up the paths will allow you to see the mob sprites as they will appear ingame (except for granny models, like emperium for instance). The "..." button can let you select the sprites from the mob folder in the GRFs (or data folder).

Preview images

With the client tables synchronization, the preview image for items in the list view will be properly displayed. This is handy for custom items.

Notepad++ support

There is support for Notepad++ to easily find items in a text (or conf) database. Right-click an item and use "Select in Notepad++".

588z36y.png

Search feature

The search engine is the same used as CDE, so it should make it easy to find an item. There is also a hidden search option : if you type "[number_of_slots] 4" it will give all the items with 4 slots or "[refineable] true" will give you all refineable items. This can be applied to any attribute in the table which are not shown in the search panel.

3TAcP4S.png

Todo list

  • Import from SQL (is that even necessary?).
  • Automatically create a table from a file.
  • Batch files / command line methods (would be similar to GrfCL).
  • Known bug : exporting mob_skill_db from Hercules to SqlRenewalHercules doesn't seem to be parsing properly (for this file only).
  • Type safety (check for invalid inputs, use the same SQL rules when loading the databases).

Hope you enjoy this tool! The sources will be available on githut for the next release. If you have a feedback or suggestions, let me know and I'll probably add them to the software.

Sources


What's New in Version 1.1.8   See changelog

Released

  • [Added] : The backup manager now uses a different thread, so you can save much faster.
  • [Added] : Some fields will show their item/mob names rather than their IDs.
  • [Fixed] : It is now compatible with the latest rAthena database structure.
  • [Fixed] : The lua tables had the wrong labels in their settings window.
  • [Removed] : No longer supports the item groups db.
  • Updated source files.
  • Previous patch notes:
  • 2015-10-28 [1.1.6]
  • [Added] SDE : The ForceSerial field has been added for Hercules.
  • [Added] SDE : A "Shop simulator" tool has been added via Tools > Shop simulator.
  • [Added] SDE : You can now validate your tables by using going into Tools > Validate table. It has a wide range of options.
  • [Added] SDE : Conditional searches are now possible and uses the lua syntax. Ex: "[buy] > 20".
  • [Added] SDE : SFTP is now fully supported; this allows you to edit your db files directly from a VPS for instance.
  • [Fixed] SDE : The Matk and other fields will now be enabled accordlingly to your database type (Herc vs rA).
  • [Fixed] SDE : Various other bug fixes.
  • 2015-06-17 [1.1.5.29]
  • [Added] SDE : IronPython's scripting engine has been added to SDE. This feature is very useful for automated tasks.
  • [Added] SDE : [Copy to] feature now allows regex expressions to copy items more easily (feature requested).
  • [Added] SDE : 'null' prices are now allowed.
  • [Added] SDE : If the text encoding is not supported, it will be written with the \### ascii notation automatically.
  • [Added] SDE : Ingame ViewID preview for weapons, shields, backpacks, wings and headgears.
  • [Added] SDE : Color picker for editing client text descriptions.
  • [Modified] SDE : item_group.conf, item_db.conf and itemInfo.lua parsers have been remade.
  • [Fixed] SDE : Fixed an error with the data resource folder not being able to find some files.
  • [Fixed] SDE : When changing the project file twice, some data wasn't being cleared and it caused errors.
  • [Fixed] SDE : Saving the game client's text files had an issue with escaping characters (" vs \")
  • [Fixed] SDE : Upon resaving your client files, tabs and quotes will be repaired.
  • [Fixed] SDE : Invalid scripts will be read correctly and an error will be returned.
  • [Fixed] SDE : Changing project files now releases the non-used GRFs from the previous project.
  • 2015-04-15 [1.1.5]
  • [Added] SDE : The KeepAfterUse field has been added for Hercules.
  • [Added] SDE : mob_avail.txt support.
  • [Added] SDE : Better codepage support.
  • [Added] SDE : Some comments in files will be autogenerated (can be disabled).
  • [Added] SDE : Tools > Settings > offers many additional options.
  • [Added] SDE : You can now detach tabs by using right-click > Detach.
  • [Added] SDE : The option to copy from Tab1 to Tab2 directly.
  • [Added] SDE : When changing tab, it will automatically focus on the list view, allowing copy/paste operations to work more efficiently.
  • [Added] SDE : There is a new integrated window option (which allows you to edit flag values much more easily). This behavior can be changed in Tools > Settings > General > Integrated dialogs...
  • [Added] SDE : If multiple items are selected, the modifications will be applied to all of them.
  • [Added] SDE : eAthena basic support, with the ExpPer field for the Mob tables.
  • [Fixed] SDE : Bind on equip and Matk fields have been unlocked for Hercules.
  • [Fixed] SDE : Commands remove themselves better.
  • [Fixed] SDE : The Buy and Sell previews will now show properly.
  • [Fixed] SDE : The lag when opening the lua options has been removed.
  • [Fixed] SDE : The reset button, for the paths in the settings, wasn't working properly.
  • [Fixed] SDE : The resource fields as well as lua related items accept any encoding.
  • [Fixed] SDE : Copying boolean values (from the "Copy" tool) wasn't copying properly.
  • [Fixed] SDE : The Trade and NoUse attributes weren't working properly with undo and redo.
  • 2015-04-15 [1.1.4.1]
  • [Added] SDE : eAthena supports.
  • [Added] SDE : It is now possible to forcibly revert the item types 4 and 5 (rAthena bugfix + eAthena compatibility).
  • [Fixed] SDE : Fixed the massive UI lag when clicking opening the View ID settings.
  • Version 1.1.6
  • 2015-10-28 [1.1.6]
  • [Added] SDE : The ForceSerial field has been added for Hercules.
  • [Added] SDE : A "Shop simulator" tool has been added via Tools > Shop simulator.
  • [Added] SDE : You can now validate your tables by using going into Tools > Validate table. It has a wide range of options.
  • [Added] SDE : Conditional searches are now possible and uses the lua syntax. Ex: "[buy] > 20".
  • [Added] SDE : SFTP is now fully supported; this allows you to edit your db files directly from a VPS for instance.
  • [Fixed] SDE : The Matk and other fields will now be enabled accordlingly to your database type (Herc vs rA).
  • [Fixed] SDE : Various other bug fixes.
  • 2015-06-17 [1.1.5.29]
  • [Added] SDE : IronPython's scripting engine has been added to SDE. This feature is very useful for automated tasks.
  • [Added] SDE : [Copy to] feature now allows regex expressions to copy items more easily (feature requested).
  • [Added] SDE : 'null' prices are now allowed.
  • [Added] SDE : If the text encoding is not supported, it will be written with the \### ascii notation automatically.
  • [Added] SDE : Ingame ViewID preview for weapons, shields, backpacks, wings and headgears.
  • [Added] SDE : Color picker for editing client text descriptions.
  • [Modified] SDE : item_group.conf, item_db.conf and itemInfo.lua parsers have been remade.
  • [Fixed] SDE : Fixed an error with the data resource folder not being able to find some files.
  • [Fixed] SDE : When changing the project file twice, some data wasn't being cleared and it caused errors.
  • [Fixed] SDE : Saving the game client's text files had an issue with escaping characters (" vs \")
  • [Fixed] SDE : Upon resaving your client files, tabs and quotes will be repaired.
  • [Fixed] SDE : Invalid scripts will be read correctly and an error will be returned.
  • [Fixed] SDE : Changing project files now releases the non-used GRFs from the previous project.
  • 2015-04-15 [1.1.5]
  • [Added] SDE : The KeepAfterUse field has been added for Hercules.
  • [Added] SDE : mob_avail.txt support.
  • [Added] SDE : Better codepage support.
  • [Added] SDE : Some comments in files will be autogenerated (can be disabled).
  • [Added] SDE : Tools > Settings > offers many additional options.
  • [Added] SDE : You can now detach tabs by using right-click > Detach.
  • [Added] SDE : The option to copy from Tab1 to Tab2 directly.
  • [Added] SDE : When changing tab, it will automatically focus on the list view, allowing copy/paste operations to work more efficiently.
  • [Added] SDE : There is a new integrated window option (which allows you to edit flag values much more easily). This behavior can be changed in Tools > Settings > General > Integrated dialogs...
  • [Added] SDE : If multiple items are selected, the modifications will be applied to all of them.
  • [Added] SDE : eAthena basic support, with the ExpPer field for the Mob tables.
  • [Fixed] SDE : Bind on equip and Matk fields have been unlocked for Hercules.
  • [Fixed] SDE : Commands remove themselves better.
  • [Fixed] SDE : The Buy and Sell previews will now show properly.
  • [Fixed] SDE : The lag when opening the lua options has been removed.
  • [Fixed] SDE : The reset button, for the paths in the settings, wasn't working properly.
  • [Fixed] SDE : The resource fields as well as lua related items accept any encoding.
  • [Fixed] SDE : Copying boolean values (from the "Copy" tool) wasn't copying properly.
  • [Fixed] SDE : The Trade and NoUse attributes weren't working properly with undo and redo.
  • 2015-04-15 [1.1.4.1]
  • [Added] SDE : eAthena supports.
  • [Added] SDE : It is now possible to forcibly revert the item types 4 and 5 (rAthena bugfix + eAthena compatibility).
  • [Fixed] SDE : Fixed the massive UI lag when clicking opening the View ID settings.
  • Upvote 9
  • Love 1