From The Mana World
(proposal for database layout to store custom equipment) |
(subcategory can be covered by the archetype id) |
||
Line 3: | Line 3: | ||
{{sqltablerow | id | INTEGER | PRIMARY KEY | tmw_customitem_modifiers.id, tmw_customitem_runes.id | unique identifier}} | {{sqltablerow | id | INTEGER | PRIMARY KEY | tmw_customitem_modifiers.id, tmw_customitem_runes.id | unique identifier}} | ||
{{sqltablerow | category | BYTE | | | slot the item is equipped in}} | {{sqltablerow | category | BYTE | | | slot the item is equipped in}} | ||
{{sqltablerow | 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.}} | |||
{{sqltablerow | archetype-id | INTEGER | | | entry from items.xml to determine the used sprite, item icon and description. In case of weapons it also affects the attack zone.}} | |||
{{sqltablerow | color | TEXT | | | colorization string}} | {{sqltablerow | color | TEXT | | | colorization string}} | ||
{{sqltablerow | name | TEXT | | | item name}} | {{sqltablerow | name | TEXT | | | item name}} |
Revision as of 15:54, 7 May 2009
Layout for the SQL table to store customized equipment
|
Stat modifiers during item creation. Also includes elemental modifiers.
|
Spell runes engraved in the item.
|