Server Database Editor

[Garr]

@@Emistry

I think you misunderstood him a bit, he's having a laugh over himself for panicking and reporting the bug before checking all the things (I know how it feels >.&lt, and says that if it'll happen for sure he'll report that he was wrong once again. I don't see a threat here O_O

@@Tokeiburu

This:

loadedDb = database.LoadTable("C:itemInfo.lua")
But for idnum2 files

Because iirc if I try to use it with resnametable, I get something like "File is not a table" or something. Sorry, can't check now  for sure as I've just reinstalled my windows and need to reinstall all the things again >.<

Pretty much a python way to load idnum file and get them tuples

 

[Tokeiburu]

@@Emistry

I think you misunderstood him a bit, he's having a laugh over himself for panicking and reporting the bug before checking all the things (I know how it feels >.&lt, and says that if it'll happen for sure he'll report that he was wrong once again. I don't see a threat here O_O

@@Tokeiburu

This:

loadedDb = database.LoadTable("C:itemInfo.lua")But for idnum2 files

Because iirc if I try to use it with resnametable, I get something like "File is not a table" or something. Sorry, can't check now  for sure as I've just reinstalled my windows and need to reinstall all the things again >.<

Pretty much a python way to load idnum file and get them tuples

You can load such tables the same way as you just did, except the .txt names have to be exact. For example : 

loadedDb = database.LoadTable("C:idnum2itemdesctable.txt")for tuple in loadedDb: print tuple["id_description"]
Some tables cannot be loaded right now, such as cardpostfixnametable, cardprefixnametable and num2cardillustnametable. These will be available on the next release though.

@@Tokeiburu Thanks alot for you response. I want to report again. If we tick manage view ID automatically (headgear) some of the item (at accname and accesorry id) will become UNREGISTERED. 

why ?

The "unregistered" keyword comes from bad (missing) associations between your item_db and Client Items. Instead of removing the values, it fills them with default information. They shouldn't have any impact ingame though.

 

[mrlongshen]

@@Tokeiburu Thanks alot for you response. I want to report again. If we tick manage view ID automatically (headgear) some of the item (at accname and accesorry id) will become UNREGISTERED. 

why ?

The "unregistered" keyword comes from bad (missing) associations between your item_db and Client Items. Instead of removing the values, it fills them with default information. They shouldn't have any impact ingame though.

Yes true. no impact. but it change the the item name to the item id. Nevermind. Its just fine. hihi.

Sir, can your add new feature, like multiple Mob status to user need.

For example. I want to make a high rate server(so assume x3 mob strength). So there are button on SDE to multiply all mob status (str,dex,agi,hp and all) to (x3). So when user tick the button it will auto multiply the value. Is that possible ?

 

[Tokeiburu]

Yes true. no impact. but it change the the item name to the item id. Nevermind. Its just fine. hihi.

Sir, can your add new feature, like multiple Mob status to user need.

For example. I want to make a high rate server(so assume x3 mob strength). So there are button on SDE to multiply all mob status (str,dex,agi,hp and all) to (x3). So when user tick the button it will auto multiply the value. Is that possible ?

You could use the following (Tools > IronPython Script...) script. You may lag a few seconds.

def _mult(db, tuple, key, factor):
db[tuple.Key, key] = str(factor * int(tuple[key]))
returnattributes = ["str", "vit", "dex", "agi", "int", "luk", "hp"]

for tuple in mob_db:
for attribute in attributes:
_mult(mob_db, tuple, attribute, 3)
for tuple in mob_db2:
for attribute in attributes:
_mult(mob_db2, tuple, attribute, 3) 


You can easily find the other attribute names that you want to add to the x3 list. A source edit would probably be cleaner though, but that's up to you!

 

[mrlongshen]

@@Tokeiburu thanks alot! its very useful ! Yeahhh +1 for you 

 

 

[anacondaq]

I'm sorry but you're wrong.


When you see more details, and I'll finally be able to reproduce the error, I am aware of it here.

 

[Tokeiburu]

I'm sorry but you're wrong.


When you see more details, and I'll finally be able to reproduce the error, I am aware of it here.

You two are confusing each other, a lot xD. Anyway, everything's fine and the possible bugs are being looked into...! May take a couple days before I release a newer version.

 

[mrlongshen]

@@Tokeiburu Yeay ! cant wait it hihi 

 

[anacondaq]

again tokei, .22 server database editro (same version)

Then i was close SDE, and run it again.

Load last project

and violia:

WTF?

And all my last changes not saved

I will add today more data about this bug, please, stay tuned.

=====================

Now i was edit many items at client tab. (the item descriptions)

Then, when i complete all tasks, i was click save project in Menu, then Quick Save.

I was close Server Database Editor, reopen it, and i see next:

 

[Tokeiburu]

again tokei, .22 server database editro (same version)

Then i was close SDE, and run it again.

Load last project

and violia:

WTF?

And all my last changes not saved

I will add today more data about this bug, please, stay tuned.

=====================

Now i was edit many items at client tab. (the item descriptions)

Then, when i complete all tasks, i was click save project in Menu, then Quick Save.

I was close Server Database Editor, reopen it, and i see next:

Alright, I've found the issue and avoid testing this further as it can actually damage your client files. The problem comes from when you save the Client Items tab with your files being in the GRFs. By default, the GRFs are in readonly mode and when you save new information in them, it just... doesn't go too well. It works fine, up until you use "Reload database" and you now have out-of-sync GRF entries. If you close and reopen the software, the GRFs are fully read again so the problem disappears.

Anyhow, this issue should be fixed in 1.1.5.23, sorry for the inconvenience!

 

[anacondaq]

...

Alright, I've found the issue and avoid testing this further as it can actually damage your client files. The problem comes from when you save the Client Items tab with your files being in the GRFs. By default, the GRFs are in readonly mode and when you save new information in them, it just... doesn't go too well. It works fine, up until you use "Reload database" and you now have out-of-sync GRF entries. If you close and reopen the software, the GRFs are fully read again so the problem disappears.

Anyhow, this issue should be fixed in 1.1.5.23, sorry for the inconvenience!

Wow, thank you very much for your amazing fast reply & fix. I will try it today, but just for test reasons.

Now i understand (like you said to me before) + i use clientfiles outside the grf.

But just to confirm about fixed issue, i will do tests after few hours

 

[anacondaq]

Hi Dear Tokei, i have a problem not really related to Server Database Editor, but if you will find a solution for this, maybe you will improve quality of SDE.

I have big experience with GRFs / Custom items.

When i was apply around >1k items to my server i got only with these & few extra headgears the same error with right click error.

As you see on screenshot, i have sucesfully added custom item to the client, small images, sprites for ground / equip.

The problem only with right click image black_feather_beret.bmp which must be located in collection folder.

There is a screenshot from the game GRF:

So, as you see this .bmp file is exist in database.

My question: is it bug? Can you please just check for yourself this sprite? Because it's important.

IMRPOTANT: if i change this item to another id, with another grf -> i have no problems at all.

Suggestion: Is it possible to somehow avoid with SDE, i mean "forced detection of broken / bugged like this headgear checks"?

Feather Beret Link:

http://www.mediafire.com/download/fh4av4t77t6aruw/feather_beret.grf
 

Sorry for my english.

Problems:

This is old problem, and dear Tokeiburu already know about this issue. (related to weapon / armor detection for rathena / hercules) there are few screenshots to show the problem.

Suggestion:

Just add const radio / checkboxes at first screen, where a user can select is he using rAthena, or Hercules database. Just specially to avoid issues.

 

[Tokeiburu]

Hi Dear Tokei, i have a problem not really related to Server Database Editor, but if you will find a solution for this, maybe you will improve quality of SDE.

I have big experience with GRFs / Custom items.

When i was apply around >1k items to my server i got only with these & few extra headgears the same error with right click error.

As you see on screenshot, i have sucesfully added custom item to the client, small images, sprites for ground / equip.

The problem only with right click image black_feather_beret.bmp which must be located in collection folder.

There is a screenshot from the game GRF:

So, as you see this .bmp file is exist in database.

My question: is it bug? Can you please just check for yourself this sprite? Because it's important.

IMRPOTANT: if i change this item to another id, with another grf -> i have no problems at all.

Suggestion: Is it possible to somehow avoid with SDE, i mean "forced detection of broken / bugged like this headgear checks"?

Feather Beret Link:

http://www.mediafire.com/download/fh4av4t77t6aruw/feather_beret.grf

Sorry for my english.

Problems:

This is old problem, and dear Tokeiburu already know about this issue. (related to weapon / armor detection for rathena / hercules) there are few screenshots to show the problem.

Suggestion:

Just add const radio / checkboxes at first screen, where a user can select is he using rAthena, or Hercules database. Just specially to avoid issues.

The detection is not the problem, SDE knows what emulator you're using. The problem is that there's no consistency for item types 4/5 (weapon/armor) between either eAthena, rAthena or Hercules. Especially rAthena which reversed the item type at some point, so now it's rather messy. In your case, go in Tools > Settings > General > check, or uncheck "Switch item types 4 and 5", then restart.

For the missing GRF files, this has nothing to do with SDE. The file is either not present in your GRF, it is corrupted, the name is just wrong or the file format of the collection image is not supported. (That search box looks pretty bad on Windows XP, gotta fix that...)

I checked your image though, the DIB header has been saved with a 256-colors palette mode (biClrUsed = 0x100; with 24bpp), instead of a regular 24bit BGR format. Resave them with paint (with 24-bit Bitmap); it will fix your issues. That cannot be detected by SDE, it would require too much time to scan through all your collection images for the exact underlying format used, which may actually be valid on some client versions to begin with.

I think I covered everything in that post, let me know if I missed something xD.

 

[anacondaq]

Spoiler

Hi Dear Tokei, i have a problem not really related to Server Database Editor, but if you will find a solution for this, maybe you will improve quality of SDE.

I have big experience with GRFs / Custom items.

When i was apply around >1k items to my server i got only with these & few extra headgears the same error with right click error.

As you see on screenshot, i have sucesfully added custom item to the client, small images, sprites for ground / equip.

The problem only with right click image black_feather_beret.bmp which must be located in collection folder.

There is a screenshot from the game GRF:

So, as you see this .bmp file is exist in database.

My question: is it bug? Can you please just check for yourself this sprite? Because it's important.

IMRPOTANT: if i change this item to another id, with another grf -> i have no problems at all.

Suggestion: Is it possible to somehow avoid with SDE, i mean "forced detection of broken / bugged like this headgear checks"?

Feather Beret Link:

http://www.mediafire.com/download/fh4av4t77t6aruw/feather_beret.grf
 

Sorry for my english.

Problems:

This is old problem, and dear Tokeiburu already know about this issue. (related to weapon / armor detection for rathena / hercules) there are few screenshots to show the problem.

Suggestion:

Just add const radio / checkboxes at first screen, where a user can select is he using rAthena, or Hercules database. Just specially to avoid issues.

The detection is not the problem, SDE knows what emulator you're using. The problem is that there's no consistency for item types 4/5 (weapon/armor) between either eAthena, rAthena or Hercules. Especially rAthena which reversed the item type at some point, so now it's rather messy. In your case, go in Tools > Settings > General > check, or uncheck "Switch item types 4 and 5", then restart.

For the missing GRF files, this has nothing to do with SDE. The file is either not present in your GRF, it is corrupted, the name is just wrong or the file format of the collection image is not supported. (That search box looks pretty bad on Windows XP, gotta fix that...)

I checked your image though, the DIB header has been saved with a 256-colors palette mode (biClrUsed = 0x100; with 24bpp), instead of a regular 24bit BGR format. Resave them with paint (with 24-bit Bitmap); it will fix your issues. That cannot be detected by SDE, it would require too much time to scan through all your collection images for the exact underlying format used, which may actually be valid on some client versions to begin with.

I think I covered everything in that post, let me know if I missed something xD.

I did't know about this feature. Sorry, this is my fault. Thank you very much for support! I will try,

u rocks!

Hi Dear Tokei, i have a problem not really related to Server Database Editor, but if you will find a solution for this, maybe you will improve quality of SDE.

I have big experience with GRFs / Custom items.

When i was apply around >1k items to my server i got only with these & few extra headgears the same error with right click error.

As you see on screenshot, i have sucesfully added custom item to the client, small images, sprites for ground / equip.

The problem only with right click image black_feather_beret.bmp which must be located in collection folder.

There is a screenshot from the game GRF:

So, as you see this .bmp file is exist in database.

My question: is it bug? Can you please just check for yourself this sprite? Because it's important.

IMRPOTANT: if i change this item to another id, with another grf -> i have no problems at all.

Suggestion: Is it possible to somehow avoid with SDE, i mean "forced detection of broken / bugged like this headgear checks"?

Feather Beret Link:

http://www.mediafire.com/download/fh4av4t77t6aruw/feather_beret.grf
 

Sorry for my english.

Problems:

This is old problem, and dear Tokeiburu already know about this issue. (related to weapon / armor detection for rathena / hercules) there are few screenshots to show the problem.

Suggestion:

Just add const radio / checkboxes at first screen, where a user can select is he using rAthena, or Hercules database. Just specially to avoid issues.

The detection is not the problem, SDE knows what emulator you're using. The problem is that there's no consistency for item types 4/5 (weapon/armor) between either eAthena, rAthena or Hercules. Especially rAthena which reversed the item type at some point, so now it's rather messy. In your case, go in Tools > Settings > General > check, or uncheck "Switch item types 4 and 5", then restart.

For the missing GRF files, this has nothing to do with SDE. The file is either not present in your GRF, it is corrupted, the name is just wrong or the file format of the collection image is not supported. (That search box looks pretty bad on Windows XP, gotta fix that...)

I checked your image though, the DIB header has been saved with a 256-colors palette mode (biClrUsed = 0x100; with 24bpp), instead of a regular 24bit BGR format. Resave them with paint (with 24-bit Bitmap); it will fix your issues. That cannot be detected by SDE, it would require too much time to scan through all your collection images for the exact underlying format used, which may actually be valid on some client versions to begin with.

I think I covered everything in that post, let me know if I missed something xD.

Thank you!

So, i just write it here, and i will hope google will save this info:

If you have errors related to missing file in collection folder, but you have already this file in folder, just try to resave your bmp file with 24bit bmp.

 

[Tokeiburu]

@@Tokeiburu Yeay ! cant wait it hihi 

Alright, updated to 1.1.5.28. I've remade the lua engine for the headgears. This will remove most of your "UNREGISTERED" items and replace them with their AegisName instead. If you have any error with the lua files, let me know as soon as possible!

Big update : SFTP support added and FTP support dropped. This should make everyone's life much easier. Simply click on the little icon near the "Server DB path" :

The first time you access the repository, it will download all your files and cache them. This means the next times you access your files, it won't have to download everything so it should be pretty quick. If you find any error in this feature, let me know! You can debug some of the errors yourself from "Tools > Debug tables..."; this will show you the SFTP connection, which files it reads, which it uploads, etc. The cache files are obviously going to be updated if a newer version is found on the SFTP server.

* If the backup engine crashes with an SFTP connection, let me know as well. It shouldn't happen though (and even if it does, it won't have an impact on your files).

 

[anacondaq]

Suggestion for search form at SDE:

Can you please improve it for all values? 

For example, if you write in search field [item_id] > 10000, you will see in window below all items with ID > 10000;

if you will write for example [weight] < 100, you will see all items with weight < 100;

Sometimes, i need very fast sort items by some similar parameters, (for example find all MVP in db, and modify them), and i can't to do that.

Sure, i saw IronPython Script, but i do not know python, and it's very hard for me to understand how it work. 

 

[Tokeiburu]

Suggestion for search form at SDE:

Can you please improve it for all values?
For example, if you write in search field [item_id] > 10000, you will see in window below all items with ID > 10000;

if you will write for example [weight] < 100, you will see all items with weight < 100;

Sometimes, i need very fast sort items by some similar parameters, (for example find all MVP in db, and modify them), and i can't to do that.
Sure, i saw IronPython Script, but i do not know python, and it's very hard for me to understand how it work.

That turned out to be more complex than anticipated. (IronPython is really straightforward by the way ;P, plus there are samples.) Updated to 1.1.5.29

Anyway, the new search syntax recognizes the following symbols
and or && || ( ) > >= < <= == != ~= not * / + - % ^ << >> & |

Here are a few examples with their description :
[weight] < 1000 // Items with a weight below 1000
[weight] / 10 <= 50 // Items with an ingame weight below or equal 50
[weight] % 10 != 0 // Items with a fractional value (usually below 10)
[location] & 769 != 0 // All headgears
[location] & 7937 != 0 and [view_id] > 500 // All headgears and costumes with a View ID above 500
[equip_level] == "" // Items with no equip_level value
[equip_level] == 0 // Items with an equip_level value of 0 (empty fields are treated as 0)
[refineable] == false // Items that cannot be refined
[applicable_job] & 0x40 == 0x40 && [upper] == 2 // Items which can be used by the thief class and are for reborn classes only

If your search is valid, the background will be orange.

 

[evilpuncker]

@Up

that is awesome

 

[Garr]

Indeed, Python is pretty easy, but then again eAthena/rAthena/Herc scripting language is as well, but people are lazy to learn

+1 for awesome update.

 

[Tranquility]

Hello Tokei,

Would it be possible to allow for SQL imports? Seeing the export option is available, I thought this might be a nice addition. Naturally we'd have to indicate which emulator we're trying to import to smoothen the operation.

This question, or rather request, came up when I started moving from one emulator to another and decided to use txt versions for items & mobs. But after a lot of manual labour I wondered if this would be viable and possible.

Thanks in advance,

Tranquility