Database
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
|
|
Netcode
- Item IDs are 32 bit unsigned integers
- Item IDs 1 - 65.535 are non-customized generic items which may exist multiple times
- Item IDs 65.536 - 4.294.967.296 are unique equipment items which may only exist once in the game.
- When sending the inventory data to a character, every high id is followed by its archetype-id and colorization string. All other information about the item can be requested on demand with an additional message.
- When sending look information about other characters the archetype-id and the colorisation are transfered