From The Mana World
< User:Crush
Revision as of 16:09, 7 May 2009 by Crush2 (talk | contribs) (netcode notes)

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