Layout for the SQL table to store customized equipment
| tmw_customitem
|
| Column name |
Datatype |
Nullable |
References |
Description
|
| id
|
INTEGER
|
PRIMARY KEY
|
tmw_customitem_modifiers.id, tmw_customitem_runes.id
|
unique identifier
|
| category
|
BYTE
|
|
|
slot the item is equipped in
|
| archetype-id
|
INTEGER
|
|
|
entry from items.xml to determine the used sprite, item icon and description. In case of weapons it also affects the weapon category (used skill) and the attack zone.
|
| color
|
TEXT
|
|
|
colorization string
|
| name
|
TEXT
|
|
|
item name
|
| inscription
|
TEXT
|
|
|
custom description which can be added by the crafting character
|
| durability
|
INTEGER
|
|
|
remaining durability of the item
|
| initial-durability
|
INTEGER
|
|
|
initial durability of the item
|
| weight
|
INTEGER
|
|
|
weight
|
| value
|
INTEGER
|
|
|
price NPCs pay for this item
|
| rune-slots
|
INTEGER
|
|
|
number of slots for spell runes
|
|
Stat modifiers during item creation. Also includes elemental modifiers.
| tmw_customitem_modifiers
|
| Column name |
Datatype |
Nullable |
References |
Description
|
| id
|
INTEGER
|
PRIMARY KEY
|
|
id of the custom item affected
|
| attribute
|
BYTE
|
|
|
affected character attribute or modified element
|
| absolute
|
INTEGER
|
|
|
linear attribute modifier
|
| multiplier
|
FLOAT
|
|
|
attribute multiplier in case of character attribute. Elemental damage multiplier in case of element attribute.
|
| time
|
INTEGER
|
|
|
time when the modifier wears off (for temporary enchantments)
|
|
Spell runes engraved in the item.
| tmw_customitem_runes
|
| Column name |
Datatype |
Nullable |
References |
Description
|
| id
|
INTEGER
|
PRIMARY KEY
|
|
id of the custom item affected
|
| spell
|
INTEGER
|
|
|
spell of the rune
|
|
