Server Database Editor

[Angelmelody]

Hi~@@Tokeiburu, 

If you still accept suggestion,hoping for npc shop codifying feature to SDE ,so we can modify npc with the item icon list

instead of  only text list that is kinda hard to imagine what it look like..

npcmerchantsshops.txt

 

[evilpuncker]

@@Tokeiburu

new mob_db format coming?

 

[mrlongshen]

@@Angelmelody Hope @Tokeiburu Implement it. I also need it. Currently Im searching the npc view at Ai4ei site.

 

[Nova]

He's already working on the new mob_db format.

 

[Dastgir]

It just hangs off(at exact 13.04% each time) and continues to consume more and more memory for editing item_db.

 

[Tokeiburu]

It just hangs off(at exact 13.04% each time) and continues to consume more and more memory for editing item_db.

13% is when it loads the client items dbs. I'm unable to reproduce the issue on my end, could you send me your client db files via pm? Thank you.

 

[Dastgir]

It just hangs off(at exact 13.04% each time) and continues to consume more and more memory for editing item_db.

 13% is when it loads the client items dbs. I'm unable to reproduce the issue on my end, could you send me your client db files via pm? Thank you.

Ok figured out I was bymistakely loading compiled lua, so that problem is fixed .However , I see that many items are missing from the item Editor, but they exist in item_db...

 

[Tokeiburu]

Ok figured out I was bymistakely loading compiled lua, so that problem is fixed .

However , I see that many items are missing from the item Editor, but they exist in item_db...

Can you give me an example of missing item? Usually when that happens, you would get warnings in the "Error console" tab about parsing errors.

 

[Dastgir]

ID: Old_C_Album_Weapon, file: dbreitem_group.conf', line: 3804, exception: 'Item ID 'Pinguicula_Card' couldn't be found in group 'Old_C_Album_Weapon'.'
I have alot of these errors(Almost 1206), using clean Hercules

Items like Sleipnir is not shown..(All Items > 2183 and < 4639 are missing)

There's many other range of missing items too.(Using renewal db)

Edit: Found out mistake,

seems SDE is not handling comments properly

Item 2182 is having comment

/* When you receive Melee Physical damage, chance of casting Protective Light for 60 seconds. *//* Cancels Stun, Sleep, Curse, Stone Curse, Poison, Blind, Silence, Bleeding, Chaos, and Frozen. *//* Protects the user against such effects for a set duration. */
for some reason SDE is considering comment is still open and on item 4638, there's one more comment, so SDE recognizes that comment ends there, and comments out all items from  2183 to 4638..

Edit2:

Matk and BindOnEquip is not editable..

also ForceSerial field is absent.

 

[Tokeiburu]

Updated to 1.1.5.31

• ForceSerial field added, however... the field probably needs some documentation in doc/item_db.txt (I have yet to know what it does).
• The comment issue had already been resolved in recent versions. I'll update the version uploaded on Hercules later today.
• Buying store and Matk fields have been re-enabled for Hercules.
• New mob_db format supported. Be careful about failed conversions between AegisName and their IDs (they will be removed when saving the DBs). You'll find the warnings in the "Error console" tab.
• The item names are now added by default in item_trade.txt.
• Fixed an issue with item_db2 overwriting some fields from item_db (rAthena only).
• Decompiles itemInfo.lub automatically.
  

Hi~@@Tokeiburu, 
 
If you still accept suggestion,hoping for npc shop codifying feature to SDE ,so we can modify npc with the item icon list
instead of  only text list that is kinda hard to imagine what it look like..
npcmerchantsshops.txt

 
Shop simulator added via Tool > Shop simulator. Copy paste your shop NPC in the bottom textbox.

 
A table validation tool has been added via Tools > Validate table. It has been there for a while, hidden (not fully completed), but due to lack of time it's now accessible.

 

[Nova]

Nice touch including that currency box!

 

[Dastgir]

a bug

All Refine: false are converted to true.

 

[Emistry]

about the shop code in shop simulator,  I havent tried it personally, but in Hercules the format for NPC shop has changed.

it look like this

alb2trea,87,65,5 trader Tool Dealer#alb 4_M_01,{OnInit: sellitem Arrow; sellitem Silver_Arrow; sellitem Fire_Arrow; sellitem Red_Potion; sellitem Orange_Potion; sellitem Yellow_Potion; sellitem White_Potion; sellitem Green_Potion; sellitem Center_Potion; sellitem Awakening_Potion;}
most of it are using trader type now.

is this format available too ? =D

anyway, it's great to have a Create Shop Tool ... its has been so long since the Shopper v3.0 which they release it many year ago.

 

[Tokeiburu]

a bug

All Refine: false are converted to true.

Fixed, 1.1.5.32 bug introduced from .31.

about the shop code in shop simulator,  I havent tried it personally, but in Hercules the format for NPC shop has changed.

it look like this

alb2trea,87,65,5 trader Tool Dealer#alb 4_M_01,{OnInit: sellitem Arrow; sellitem Silver_Arrow; sellitem Fire_Arrow; sellitem Red_Potion; sellitem Orange_Potion; sellitem Yellow_Potion; sellitem White_Potion; sellitem Green_Potion; sellitem Center_Potion; sellitem Awakening_Potion;}
most of it are using trader type now.

is this format available too ? =D

anyway, it's great to have a Create Shop Tool ... its has been so long since the Shopper v3.0 which they release it many year ago.

It currently does not. I'll add this format later today.

 

[Jedzkie]

a bug

All Refine: false are converted to true.

Fixed, 1.1.5.32 bug introduced from .31.

>about the shop code in shop simulator,  I havent tried it personally, but in Hercules the format for NPC shop has changed.

it look like this

alb2trea,87,65,5 trader Tool Dealer#alb 4_M_01,{OnInit: sellitem Arrow; sellitem Silver_Arrow; sellitem Fire_Arrow; sellitem Red_Potion; sellitem Orange_Potion; sellitem Yellow_Potion; sellitem White_Potion; sellitem Green_Potion; sellitem Center_Potion; sellitem Awakening_Potion;}
most of it are using trader type now.

is this format available too ? =D

anyway, it's great to have a Create Shop Tool ... its has been so long since the Shopper v3.0 which they release it many year ago.

It currently does not. I'll add this format later today.

Great! xD

 

[Garr]

Hmm, as much as I'd like to update my version, I hesitate. Can I still choose which format of mob_db I'll be using, even though I'll be importing Herc? It's just that I have 2 mob dbs to maintain, updated and non-updated one (I'm still in the process of updating source, and thus I have both variants, and I'd still like to make adjustments to old dbs while I'm updating). And if non-updated one will be converted without asking I'll better refrain.

 

[Tokeiburu]

Hmm, as much as I'd like to update my version, I hesitate. Can I still choose which format of mob_db I'll be using, even though I'll be importing Herc? It's just that I have 2 mob dbs to maintain, updated and non-updated one (I'm still in the process of updating source, and thus I have both variants, and I'd still like to make adjustments to old dbs while I'm updating). And if non-updated one will be converted without asking I'll better refrain.

The format of the mob_db depends of your current folder. There are no automatic conversions; if your folder uses mob_db.conf, then it will save in the mob_db.conf and the same is true for your mob_db.txt file. Basically, as long as you use two different folders for each DB, then there won't be any issues.

 

[Tranquility]

Hmm, as much as I'd like to update my version, I hesitate. Can I still choose which format of mob_db I'll be using, even though I'll be importing Herc? It's just that I have 2 mob dbs to maintain, updated and non-updated one (I'm still in the process of updating source, and thus I have both variants, and I'd still like to make adjustments to old dbs while I'm updating). And if non-updated one will be converted without asking I'll better refrain.

The format of the mob_db depends of your current folder. There are no automatic conversions; if your folder uses mob_db.conf, then it will save in the mob_db.conf and the same is true for your mob_db.txt file. Basically, as long as you use two different folders for each DB, then there won't be any issues.

Will it be an 'automatic' conversion if you export to Herc format through the file menu? Because which Herc format will it default to ;p?

 

[Tokeiburu]

Will it be an 'automatic' conversion if you export to Herc format through the file menu? Because which Herc format will it default to ;p?

Exporting always goes for the version officially supported, which happens to be mob_db.conf here. It's the same principle for item_db.conf or other similar files ;].

 

[Tranquility]

Will it be an 'automatic' conversion if you export to Herc format through the file menu? Because which Herc format will it default to ;p?

Exporting always goes for the version officially supported, which happens to be mob_db.conf here. It's the same principle for item_db.conf or other similar files ;].

That would make it possible for @@Garr to mix & match his databases! And for me for future referrences, thanks again.