[Guide] Understanding itemdb.xml

[Noonehere]

I've been looking into the parameters of itemdb.xml.
Here's a short guide on what the parameters mean. Feel free to add in your knowledge.
This guide doesn't contain everything about itemdb.xml (yet).

Last Update: 25/10/2018
Contributors: Rydian, Flipend0

Legend:
Parameter: Description

ID: Item ID (or Class ID, for debugging)
DB_StoreType: Always 1. Never seen it 0
Category: Allows the item to do some stuff based on what the client can do. Examples are being a Wand type, a blunt weapon, a book, enchantable, dyable, repairable, ego-able, etc
XML: Extra info that gets parsed out. Can be read easier by using an HTML un-escaper. Examples are custom idle motions, wings mesh locations, head/ears framework, extra stats, etc.
Text_Name0: Internal Item Text name. Often used in KR as the "engrish" name
Text_Name1: The name of the item you see on Mabi. Use with itemdb.<language>.xml (from Language.pack) to find the item you're looking for
Text_Desc1: The item description
Bundle_Type: Has 3 values. 0 is does not stack. 1 is does stack on itself. 2 is a bag that holds a number of the item determined by the XML param.
Bundle_Max: Max stack size or bag carry size
Price_Buy: Npc default shop price (The NPC can override the price to something else)

Attr_ActionFlag: More information about this below
Attr_Type: Allows the item to act a certain way (like equips in the slot, or thing holds money). More info below
Attr_Grade: Unsure what it does. Only 1 item has Attr_Grade="1"
Attr_RaceFilter: Applies restrictions on the item (Giant, human, elf, female, male)
File_MaleMesh: The pmg mesh that appears on human/elf males
File_FemaleMesh: The pmg mesh that appears on human/elf females
File_GiantMesh: The pmg mesh that appears on Giant males
File_FemaleGiantMesh: The pmg mesh that appears on Giant females
File_FieldMesh: The pmg mesh that appears when on the floor
File_InvImage: The image of the item in inventory

Inv_XSize: Size of the item on the X axis of your inv.
Inv_YSize: Size of the item on the Y axis of your inv
App_WeaponActionType:
App_WearType: Not sure what other values go here and what they do. More info below.
App_UseC4Layer: A flag for using the fourth colour layer. Possibly on the .dds
App_Color1: First dyeable spot. Determines Dye Palette. More info below
App_Color2: Second dyeable spot. Determines Dye Palette. More info below
App_Color3: Third dyeable spot. Determines Dye Palette. More info below
App_ColorOrder: Not sure

App_AnimationType: The animation set used for the weapon. Corresponds to sets in motion.xml. No idea what the numbers in the brackets mean
App_SittingType: Determines sitting posture for clothing. More Info below
Taste_anything: NPC Gifting values. More info in Mabniation

Metalware_UItooltip: Something about being Reforgable
Enchant_UItooltip: Something about being Enchantable
Upgrade_UItooltip: Something about being Upgradable
Par_BlockUseFlag: Possibly controls what can be ctrl+clicked or not
Par_UpgradeMax: Max number of upgrades it can go through
Par_GemUpgradeMax: Max number of gem upgrades it can go through
Par_DurabilityMax: Base dura
Par_Defense: Base defense
Par_ProtectRate: Base prot
Par_AttackMin: Minimum base attack
Par_AttackMax: Max base attack
Par_WAttackMin: Minimum base wound
Par_WAttackMax: Max base wound
Par_CriticalRate: Base crit
Par_AttackBalance: Base balance
Par_EffectiveRange: The effective range of the weapon
Par_AttackSpeed: Possibly determines Normal, Very Fast, Fast, Slow, Very Slow weapons. More Info below
Par_DownHitCount: How much knockdown you apply with weapon

SmartSearchFlag:
AuctionSearchFlag:


Values:

Attr_type="0" = Clothing
Attr_type="1" = Hats
Attr_type="2" = Glove
Attr_type="3" = Shoes
Attr_type="4" = Book
Attr_type="5" = Money
Attr_type="6" = Inv Bags
Attr_type="7" = 1h Weapons
Attr_type="8" = 2h Weapons
Attr_type="9" = Fun... tools?
Attr_type="10" = Instrument
Attr_type="11" = Shield
Attr_type="12" = Robe

According to the in-game debugging tooltips on items, some flags are named as such...

Attr_ActionFlag="0", "normal item" (normal crap)
Attr_ActionFlag="1", "static item" (Book Collector Bag, Super Gold Combo Card Pack, Dream Event Celebration Bag, Lorna's Adventure Bag)
Attr_ActionFlag="2", "important item" (Spirit weapon, Avon Feather, Adniel's Horn Bugle)
Attr_ActionFlag="3", "account personal item" (Homestead Fractal Well, Swimsuit (F), Aeira's Bookbag, Simon's Clothing Bag)
Attr_ActionFlag="4", "dungeon item" (Rusted Longsword, Dungeon Room Key)
Attr_ActionFlag="5", "character personal item" (Light of Palala, Advancement Test Discount Coupon, Incomplete Commerce Reforge Tool)
Attr_ActionFlag="6", "region fixed item"
Attr_ActionFlag="7", "bank blocked item"
Attr_ActionFlag="8", "new bag item"
Attr_ActionFlag="9", "bank blocked character personal"
Attr_ActionFlag="10", "guild item"
Attr_ActionFlag="11", "sealed item"
Attr_ActionFlag="12" "not deal item" (Special Tendering Potion S (Event), Chef's Bag, Student Pierrot Mini)
Attr_ActionFlag="13", "important2 item" (Brionac)
Attr_ActionFlag="14", "trade limit item" (Commerce Reforge Tool, Ancient Magic Powder-62067, items with 1 trade in general, trade unlocks on equippables do NOT change their attribute flag because flag is part of item class, not instance).
Attr_ActionFlag="15", "remove blocked item"
Attr_ActionFlag="16", "lord key item"
Attr_ActionFlag="17", "get item to personal item"

App_SittingType="1" = Male: Hand near chest. Female: Legs to the front and side
App_SittingType="2" = Male: Legs out. Female: Hands under knees
App_SittingType="3" = Both: Sitting on legs
App_SittingType="4" = Rank 9 rest

App_WearType="1" = Headgear, around the eyes
App_WearType="2" = Headgear, around the head
App_WearType="55" = Headgear that can be opened or closed
App_WearType="lsh" = Clothing with hoods
App_WearType="ssh" = Clothing with hoods... again?
App_WearType="llh" = Clothing with hoods... again?
App_WearType="ss" = Clothing that shows the arm2lr bone from gloves, but hide leg2lr
App_WearType="lm" = Clothing that hides the arm2lr bone from gloves, and clips through legs

More can be discovered

The numbers at the end of App_Color are taken out in this list since they all act the same. Palettes can be seen on the Mabi Wiki

App_Color="0" = Cannot be dyed. Also becomes "cannot be dyed" if the item does not allow it (like metal on cloth)
App_Color="1" = Regular Palette
App_Color="2" = Leather Palette
App_Color="3" = Pixie Palette
App_Color="4" = Nylon Palette
App_Color="5" = Armor Metal Palette
App_Color="23" = Weapon Metal Palette
App_Color="24" = Hilt Metal Palette
App_Color="33" = Winter Lights Palette
App_Color="58" = Panda Palette
App_Color="61" = Unknown Palette
App_Color="62" = Fur Palette
App_Color="65" = Giant Palette
App_Color="66" = Cotton Candy Red
App_Color="67" = Cotton Candy Orange
App_Color="68" = Cotton Candy Yellow
App_Color="69" = Cotton Candy Green
App_Color="70" = Cotton Candy Blue
App_Color="71" = Cotton Candy Indigo
App_Color="72" = Cotton Candy Violet
App_Color="73" = Cotton Candy White

Par_AttackSpeed="0" - Very Fast
Par_AttackSpeed="1" - Fast
Par_AttackSpeed="2" - Normal
Par_AttackSpeed="3" - Slow
Par_AttackSpeed="4" - Very Slow

Values 5+ seem to wrap around.

[Rydian]

Changes I'd make...

ID: Add a note that it's also referred to as the item's "Class ID" (debug values on items in-game use that phrase, as well as debug menus seen sometimes when Sabina doesn't clear her dev title before making a vid or some screenshots).

Category: Note that they're tags for various properties that various skills use (if something is bladed or not), as well as enchants (wooden, cloth, etc).

XML: Note that it's escaped, running it through an HTML un-escaper makes it easily readable.

Text_Name0: Also note that this is the "internal name", the (often engrish) name KR assigns it that shows up below the normal item name in KR (and in NA if that mod/feature is enabled).

Text_Name1: Describe how to find the file and line being referenced.

Price_Buy: Note that this is the item's default price in shops, but NPC shops can override the price on items, for example the Composing book isn't actually 80K, but is set to that price specifically when put in the Dunby book shop.

Taste: Determines how NPCs like it as a gift, each NPC has their own tastes.
http://mabination.com/threads/84968-NPC-Relations-Memory-Favor-Stress-And-Gifting

Par_AttackSpeed: 0-VeryFast, 1-Fast, 2-Normal, 3-Slow, 4-VerySlow, 5+ seem to wrap around.

[Noonehere]

Added your suggested changes.
Thank you Rydian!

[Rydian]

Alright so I ended up looking into trade options on items and found that the game uses the Attr_ActionFlag property (in addition to tags that may restriction options, and whether the item is "(player)-only").

According to the in-game debugging tooltips on items, some flags are named as such...
Attr_ActionFlag="0", "normal item" (normal crap)
Attr_ActionFlag="1", "static item" (Book Collector Bag, Super Gold Combo Card Pack, Dream Event Celebration Bag, Lorna's Adventure Bag)
Attr_ActionFlag="2", "important item" (Spirit weapon, Avon Feather, Adniel's Horn Bugle)
Attr_ActionFlag="3", "account personal item" (Homestead Fractal Well, Swimsuit (F), Aeira's Bookbag, Simon's Clothing Bag)
Attr_ActionFlag="4", "dungeon item" (Rusted Longsword, Dungeon Room Key)
Attr_ActionFlag="5", "character personal item" (Light of Palala, Advancement Test Discount Coupon, Incomplete Commerce Reforge Tool)
Attr_ActionFlag="12" "not deal item" (Special Tendering Potion S (Event), Chef's Bag, Student Pierrot Mini)
Attr_ActionFlag="13", "important2 item" (Brionac)
Attr_ActionFlag="14", "trade limit item" (Commerce Reforge Tool, Ancient Magic Powder-62067, items with 1 trade in general, trade unlocks on equippables do NOT change their attribute flag because flag is part of item class, not instance).

Yes that one says "important2 item".
http://i.imgur.com/OGACv1D.png

[Noonehere]

Added your findings. That's pretty interesting.
Thanks Rydian!

[Rydian]

I found the debug strings in memory, here's the names of the other attribute values.

6 = region fixed item
7 = bank blocked item
8 = new bag item
9 = bank blocked character personal
10 = guild item
11 = sealed item
15 = remove blocked item
16 = lord key item
17 = get item to personal item

[Noonehere]

Added. Thank you Rydian!

[Lady Playtime]

Stickied this, as the database of guides is still a WIP.

And of course, my usual request to completely steal all your lovely hard work, to shove it into the master guide compilation. <3

[Noonehere]

And of course, my usual request to completely steal all your lovely hard work, to shove it into the master guide compilation. <3

d('w'
Since it updates so frequently (Thanks Rydian), you're free to get the updates too.