Revision as of 15:55, 7 May 2009
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
|
|