Server Database Editor

I have a really small remark for this great tool of yours:

When you're adding new skills to monsters, if you won't change state from default "any", it will write state down as "0" instead of "any". This covers both mob_skill and mob_skill2 files. So far the only way to avoid that for me was to change state to something else and then change back to "any".

 
I have a really small remark for this great tool of yours:

When you're adding new skills to monsters, if you won't change state from default "any", it will write state down as "0" instead of "any". This covers both mob_skill and mob_skill2 files. So far the only way to avoid that for me was to change state to something else and then change back to "any".
Changes in 1.1.2.5 ( http://www.mediafire.com/download/p0zhcc8ipa6cjt3 )

  • Fixed the default State attribute for the mob_skill dbs (set to "any").
  • Fixed the DataConverter used for the RequiredSatus attribute in the skill_require_db (rAthena only).
  • Using "Copy to" in mob_skill dbs now duplicate the entries.

 
You're way too awesome /no1

ETA: And mediafire died when I was just about to download
default_sad.png


 
Last edited by a moderator:
I have a really small remark for this great tool of yours:

When you're adding new skills to monsters, if you won't change state from default "any", it will write state down as "0" instead of "any". This covers both mob_skill and mob_skill2 files. So far the only way to avoid that for me was to change state to something else and then change back to "any".
Changes in 1.1.2.5 ( http://www.mediafire.com/download/p0zhcc8ipa6cjt3 )

  • Fixed the default State attribute for the mob_skill dbs (set to "any").
  • Fixed the DataConverter used for the RequiredSatus attribute in the skill_require_db (rAthena only).
  • Using "Copy to" in mob_skill dbs now duplicate the entries.
hey dude, I tried to import display name field but it seems to be broken the utf8 support: in the editor is fine: 
s4HDcIl.png
 however in conf file not: 
sMVIvar.png
, by the way the file was in ANSI and the SDE changed it to utf8 w/o boom, if I select ANSI encode in SDE, it changes Poção to > Pocao, what I'm doing wrong? xD and sorry for images

 
hey dude, I tried to import display name field but it seems to be broken the utf8 support: in the editor is fine: however in conf file not: , by the way the file was in ANSI and the SDE changed it to utf8 w/o boom, if I select ANSI encode in SDE, it changes Poção to > Pocao, what I'm doing wrong? xD and sorry for images
Each file has a different encoding, which is... fairly annoying erm! I've changed how the encodings are being handled recently to separate the server files and the client files. When you're importing the text file, the parser thinks it's a client file and uses the client encoding to convert it (which will screw up the rest later on). The encoding detection can never be 100% accurate either, it's a guess and it tries to be as helpful as it possibly can, but... it may fail. Like it does in your case; I've improved it in 1.1.2.6. If it still fails, then you'll have to manually change the file encoding in your text file (set it to Encode in ANSI, or use Convert to ANSI).

You should be using Utf8 for the server encoding and nothing else. Your file will be saved using Utf8 without BOM and this is normal. As for the client encoding, it should be either Korean or Default (I wouldn't recommend using Utf8 as it'll screw up your GRF if you save the files directly in it).

1.1.2.6 : http://www.mediafire.com/download/p0zhcc8ipa6cjt3

 
thanks for clarifying it
default_smile.png
btw hercules itemdb files comes in ANSI by default xD I've changed it to utf8 w/o boom and worked fine in 1126, thanks

 
Hi~Tokie,I have a trouble on SDE..that's When I click save databse,the CRLF characters in item_db.confwill be convert to LF characters,Can you make SDE to keep the original newline characters (CRLF or LF)?

 
Last edited by a moderator:
I found one bug as well. When you're in the client tab with text files(idnum2resnametable), if you'll use ctrl+G (autocomplete) it'll save item description in the resnametable instead of actual sprite name.

 
Hi~Tokie,I have a trouble on SDE..that's When I click save databse,the CRLF characters in item_db.conf

will be convert to LF characters,Can you make SDE to keep the original newline characters (CRLF or LF)?
The UNIX/OSX new line format is preferred for Hercules (it is the default format of the file).

I found one bug as well. When you're in the client tab with text files(idnum2resnametable), if you'll use ctrl+G (autocomplete) it'll save item description in the resnametable instead of actual sprite name.
Heya, would you mind providing more information? The item description is saved in idnum2itemdesctable.txt and the identified resources are saved in idnum2itemresnametable.txt. The autocomplete works as intended as far as I can tell. Take a screenshot of the issue, or give me the required steps to reproduce!

 
1) Check the idnum2resnametable before opening/resaving it with SDE:

http://i60.tinypic.com/a44f40.jpg

2) Open SDE and use text files for the client:

http://i62.tinypic.com/2wqv7u8.jpg

3) Use ctrl+G (autocomplete) on any item and save the result:

http://i62.tinypic.com/2napngj.jpg

4) Check the resulting idnum2resnametable

http://i62.tinypic.com/m7uf45.jpg

Hope this helps.
Ah, well the issue is in the settings : the unidentified description text file (num2itemdesctable.txt) is set to (id)num2itemresnametable.txt, which will of course cause weird issues while saving. Look at your settings >

b1dj0Xb.png


 
Last edited by a moderator:
Ooh right >.< Sorry for that
default_sad.png


 
Last edited by a moderator:
Hmm, mediafire link is dead.
default_smile.png
I hope the project is still active^^

Very nice software.

 
Hmm, mediafire link is dead.
default_smile.png
I hope the project is still active^^

Very nice software.
Yes the project is still alive, the mediafire link in the description is wrong (I had an issue with mediafire at some point). Anyway, the new link goes as follow : 

http://www.mediafire.com/download/p0zhcc8ipa6cjt3

All posts, on both rAthena and Hercules, were already edited with the correct link. I forgot to edit the link in the description last time I updated on Hercules though!

 
(today I'm illuminated lol using all of your tools
default_tongue.png
 )

any chance to make the following:

- make the import field from... feature to support the selection of multiple files instead of one .txt per time?

- make the import field from... function to warn us about errors!!!!!!! like, invalid format of structure, a line missed a # in the end and messed up the entire iteminfo file

- make an option to remove all unidentified content from iteminfo.lua file? (I set my server in source to drop identified items by default so having the double of info into iteminfo file is kinda useless) and maybe even make it alter the main function (at the end of the file) so it doesn't read unidentified items (I did it manually already but would be awesome to have it changed as well)

default_blush.png


 
Last edited by a moderator:
(today I'm illuminated lol using all of your tools
default_tongue.png
 )

any chance to make the following:

- make the import field from... feature to support the selection of multiple files instead of one .txt per time?

- make the import field from... function to warn us about errors!!!!!!! like, invalid format of structure, a line missed a # in the end and messed up the entire iteminfo file

- make an option to remove all unidentified content from iteminfo.lua file? (I set my server in source to drop identified items by default so having the double of info into iteminfo file is kinda useless) and maybe even make it alter the main function (at the end of the file) so it doesn't read unidentified items (I did it manually already but would be awesome to have it changed as well)

default_blush.png
make the import field from... feature to support the selection of multiple files instead of one .txt per time?

The behaviors with this tool vary way too much depending of the file read. I can allow multiple files, but it will simply loop through each one.

make the import field from... function to warn us about errors!!!!!!!

If the error is serious, it will show it to you. In your case though it managed to read the file, so there are no errors to be shown. Parsing errors are usually shown in the "Error console". You may want to send me your file if you think it should really be treated as an error.

make an option to remove all unidentified content from iteminfo.lua file?

That will be done via Tools > Settings > Db Writer > Disable the itemInfo.lua fields you want to ignore while writing the file (you will need to edit something in the Client Items to trigger a itemInfo rewrite).

Updated to 1.1.5

On a side note... a couple updates :

[*]Bind on equip field has been unlocked.

[*]Matk field has been unlocked (if renewal).

[*]Keep after use field has been added.

[*]The buy field will show double the sell price if empty.

[*]Cleaned up the Settings tab, moved a lot of stuff in Tools > Settings instead.

Integrated dialogs

All fields with extensions (the "..." buttons) can be opened without having to use a dialog. This makes the edition much easier, and more comfortable.

nrGaCBA.png


(Disabled by default, can be enabled via Tools > Settings > Dialogs > ...)

Entry edition applied on all selected items

By selecting multiple items, you can edit all of them at the same time without having to use the "Replace all..." and "Copy all..." tools.

p24j48S.png


(Disabled by default, can be enabled via Tools > Settings > General > "Apply modifications on all selected items")

Tabs can be moved around (detached)

Right-click on a tab and use "Detach" to make a tab into a window instead. This is handy to edit items from both Item and Item2.

PaZQXLA.png


Add multiple entries at once

This is an attempt to make adding new items an easier process. After copying an item with Ctrl-C, press down Ctrl-Shift-V or Ctrl-B to auto-increment the new pasted item. Alternatively, you can use Edit > Add range... > fill in the fields. This is pretty much the same.

Z8ObYjP.png


Changelog [1.1.5]

Code:
The KeepAfterUse field has been added for Hercules.mob_avail.txt support.Better codepage support.Some comments in files will be autogenerated (can be disabled).Tools > Settings > offers many additional options.You can now detach tabs by using right-click > Detach.The option to copy from Tab1 to Tab2 directly.When changing tab, it will automatically focus on the list view, allowing copy/paste operations to work more efficiently.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...If multiple items are selected, the modifications will be applied to all of them.eAthena basic support, with the ExpPer field for the Mob tables.Bind on equip and Matk fields have been unlocked for Hercules.Commands remove themselves better.The Buy and Sell previews will now show properly.The lag when opening the lua options has been removed.The reset button, for the paths in the settings, wasn't working properly.The resource fields as well as lua related items accept any encoding.Copying boolean values (from the "Copy" tool) wasn't copying properly.The Trade and NoUse attributes weren't working properly with undo and redo.
 
@@Tokeiburu

actually in my res name txt file there were 4 items missing and ending # so in the generated iteminfo file it missed (and messed) all items in range of those ids
default_tongue.png


 
@@Tokeiburu

In my previous PR in item_db

I put some comment in some items, like item id 2182

Look like SDE stop parsing after this line.... eg : /* comment */

mind checking?

 
@@Tokeiburu

actually in my res name txt file there were 4 items missing and ending # so in the generated iteminfo file it missed (and messed) all items in range of those ids
default_tongue.png
Aah, the parser used for resname tables is a bit different and it was using the generic version. It should work properly now, the allowed format goes as follow :

id#name# - expected

id#name

#name  - won't show anything

id##

id - won't show anything

id# - won't show anything

name - won't show anything

name# - NOT allowed

id#name#id2#name2# - nothing will be read after that second #, so id2 won't be read

- Fixed an encoding issue when importing fields.

Updated to 1.5.1.1

@@Tokeiburu

In my previous PR in item_db

I put some comment in some items, like item id 2182

Look like SDE stop parsing after this line.... eg : /* comment */

mind checking?
The comment blocks weren't fully supported, this has been fixed. You should use "//" for one-liner. That being said, most comments are not preserved when saving with SDE.

I see that you erased your previous post. I'll try and add a simple tool to manage the client resources anyway! Will be useful.

 
Back
Top