User:Crush/Customized Equipment Technical

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