ItemStatsTable: Difference between revisions

From PSwiki
Jump to navigation Jump to search
← Older edit
VisualWikitext
Magodra (talk | contribs)
863 edits
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
= Item Stats Table =
= Item Stats Table =


{| border=1
 
 
{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|-
! field
|
! type
|id
! foreign key
|int(10) unsigned
! description
|PRI
|
|auto_increment
|unique item_stats id. Referenced by; Item_instancesTable. 
|-
|-
| id
|
| int
|stat_type
| N
|char(1)
| unique item_stats id. Referenced by; [[Item_instancesTable]].
|MUL
|B
|
| (B)asic stat or a (U)nique stat.
|-
|-
| stat_type
|
| char(1)
|name
| N
|varchar(60)
| (B)asic stat or a (U)nique stat.
|UNI
|
|
|The name of the item.
|-
|-
| name
|
| varchar(60)
|weight
| N
|float(10,3)
| The name of the item.
|
|0.000
|
|The weight of the item ( in pounds ).
|-
|-
| weight
|
| float(10,2)
|visible_distance
| N
|float(10,2)
| The weight of the item ( in pounds ).
|
|100.00
|
|The distance ( in meters ) before an item becomes visible.
|-
|-
| visible_distance
|
| float(10,2)
|size
| N
|float(10,3) unsigned
| The distance ( in meters ) before an item becomes visible.
|
|0.000
|
| Size of the longest side in feet. Example Claymore 6 feet.
|-
|-
| size
|
| int(5)
|container_max_size
| N
|int(5) unsigned
|  
|
|1
|
|The maximum size of items that can be placed inside container. 
|-
|-
| container_max_size
|
| int(5)
|container_max_slots
| N
|int(5) unsigned
| The maximum size of items that can be placed inside container.
|
|0
|
|The number of slots that will be available in this item to store items inside if it's a container  
|-
|-
| valid_slots
|
| varchar(255)
|valid_slots
| N
|varchar(255)
| The slots that this item can be in. (See ''[[#valid_slots|Additional Notes]]'' below this table)
|
|BULK
|
|The slots that this item can be in. (See Additional Notes below this table)  
|-
|-
| flags
|
| varchar(255)
|flags
| N
|varchar(255)
| Flags on this item (See ''[[#flags|Additional Notes]]'' below this table)
|
|
|
|Flags on this item (See Additional Notes below this table)
|-
|-
| decay_rate
|
| float (3,2)
|decay_rate
| N
|float(3,2)
| How this item decays as it is used.  
|
|0.10
|
|How this item decays as it is used.
|-
|-
| item_skill_id_1
|
| smallint(3)
|item_skill_id_1
| Y
|smallint(3)
| Key into the skills table for the type of skill required to use this item.  
|
| -1
|
|Key into the skills table for the type of skill required to use this item.
|-
|-
| item_skill_id_2
|
| smallint(3)
|item_skill_id_2
| Y
|smallint(3)
| Key into the skills table for the type of skill required to use this item.  
|
| -1
|
|Key into the skills table for the type of skill required to use this item.
|-
|-
| item_skill_id_3
| smallint(3)
| Y
| Key into the skills table for the type of skill required to use this item.
|-
| item_bonus_1_attr
| varchar(15)
| ?
|
|
|item_skill_id_3
|smallint(3)
|
| -1
|
|Key into the skills table for the type of skill required to use this item. 
|-
|-
| item_bonus_2_attr
| varchar(15)
| ?
|
|
|item_bonus_1_attr
|varchar(15)
|
|
|
|
|-
|-
| item_bonus_3_attr
|
| varchar(15)
|item_bonus_2_attr
| ?
|varchar(15)
|
|
|
|  
|  
|-  
|-
| item_bonus_1_max
| varchar(15)
| ?
|
|
|item_bonus_3_attr
|varchar(15)
|
|
|
|
|-
|-
| item_bonus_2_max
| varchar(15)
| ?
|
|
|item_bonus_1_max
|float(10,2)
|
|0.00
|
|
|-
|-
| item_bonus_3_max
|
| varchar(15)
|item_bonus_2_max
| ?
|float(10,2)
|
|0.00
|
|  
|  
|-  
|-
| dmg_slash
|
| float(10,2)
|item_bonus_3_max
| N
|float(10,2)
| Amount of slash damage this it will do.
|
|-
|0.00
| dmg_blunt
|
| float(10,2)
| N
| Amount of blunt damage this it will do.
|-
| dmg_pierce
| float(10,2)
| N
| Amount of pierce damage this it will do.
|-
| weapon_speed
| real
|  
|  
|-
|
|dmg_slash
|float(10,2)
|
|0.00
|
|Amount of slash damage this it will do. 
|-
|
|dmg_blunt
|float(10,2)
|
|0.00
|
|Amount of blunt damage this it will do. 
|-
|
|dmg_pierce
|float(10,2)
|
|0.00
|
|Amount of pierce damage this it will do. 
|-
|
|weapon_speed
|float(10,2)
|
|0.00
|
|  
|  
|-  
|-
| weapon_penetration
|
| real
|weapon_penetration
|float(10,2)
|
|0.00
|
|  
|  
|-
|
|weapon_block_targeted
|float(10,2)
|
|0.00
|
|  
|  
|-  
|-
| weapon_block_targeted
|
| real
|weapon_block_untargeted
|float(10,2)
|
|0.00
|
|  
|  
|-
|
|weapon_counterblock
|float(10,2)
|
|0.00
|
|  
|  
|-  
|-
| weapon_block_untargeted
|
| real
|armor_hardness
|float(10,2)
|
|0.00
|
|  
|  
|-
|
|cstr_gfx_mesh
|varchar(200)
|
|
|
|  
|  
|-  
|-
| weapon_counterblock
|
| real
|cstr_gfx_icon
|varchar(200)
|
|
|
|  
|  
|-
|
|cstr_gfx_texture
|varchar(200)
|
|
|
|  
|  
|-  
|-
| armor_hardness
|
| real
|cstr_part
|varchar(200)
|
|
|
|  
|  
|-
|
|cstr_part_mesh
|varchar(200)
|
|
|
|  
|  
|-  
|-
| cstr_id_gfx_mesh
|DIF
| integer
|removed_mesh
|varchar(5000)
|
|
|
|Lists the mesh to be removed when this item is equipped. It's defined in this format slotname:mesh1,mesh2; slotname:mesh3; mesh4,mesh5. slotname is optional.  Type used to be 'varchar(200)' in PSLegacy.
|-
|
|armorvsweapon_type
|varchar(20)
|
|
|
|  
|  
|-
|
|category_id
|int(8) unsigned
|
|0
|
|Key into the item_category table that describe what area this item is in. 
|-
|
|base_sale_price
|float(10,2)
|
|0.00
|
|  
|  
|-  
|-
| cstr_id_gfx_icon
|
| integer
|item_type
|varchar(30)
|
|
|
|  
|  
|-
|
|requirement_1_name
|varchar(30)
|
|
|
|  
|  
|-  
|-
| cstr_id_gfx_texture
|
| integer
|requirement_1_value
|float(10,2)
|
|0.00
|
|  
|  
|-
|
|requirement_2_name
|varchar(30)
|
|
|
|  
|  
|-  
|-
| cstr_id_part
|
| integer
|requirement_2_value
|float(10,2)
|
|0.00
|
|  
|  
|-
|
|requirement_3_name
|varchar(30)
|
|
|
|  
|  
|-  
|-
| cstr_id_part_mesh
|
| integer
|requirement_3_value
|float(10,2)
|
|0.00
|
|  
|  
|-
|
|item_type_id_ammo
|varchar(30)
|
|
|
|  
|  
|-  
|-
| armorvsweapon_type
|
| varchar
|spell_id_on_hit
|int(10) unsigned
|
|
|
|  
|  
|-
|
|spell_on_hit_prob
|float(6,4)
|
|0.0000
|
|  
|  
|-  
|-
| category_id
|
| int(8)
|spell_id_feature
| Y
|int(10) unsigned
| Key into the item_category table that describe what area this item is in.
|
|-
|
| base_sale_price
|
| real
|  
|  
|-
|
|spell_feature_charges
|int(10)
|
|0
|
|  
|  
|-  
|-
| item_type
|
| varchar
|spell_feature_timing
|int(10)
|
|
|
|  
|  
|-
|
|item_anim_id
|int(10) unsigned
|
|0
|
|  
|  
|-  
|-
| requirement_1_name
|
| varchar
|description
|text
|
|
|
|  
|  
|-
|
|sound
|varchar(40)
|
|nosound
|
|  
|  
|-  
|-
| requirement_1_value
|
| real
|item_max_quality
|int(4)
|
|100
|
|  
|  
|-
|
|equip_script
|text
|
|
|
|  
|  
|-  
|-
| requirement_2_name
|
| varchar
|consume_script
|text
|
|
|
|  
|  
|-
|
|creative_definition
|text
|
|
|
|This is used for map/sketch xml
|-
|
|max_charges
|int(3)
|
| -1
|
|  
|  
|-  
|-
| requirement_2_value
|
| real
|weapon_range
|float unsigned
|
|2
|
|  
|  
|
|-
| requirement_3_name
| varchar
|
|
|-
| requirement_3_value
| real
|
|
|-
| item_type_id_ammo
| varchar
|
|
|-
| spell_id_on_hit
| integer
|
|
|-
| spell_on_hit_prob
| real
|
|
|-
| spell_id_feature
| integer
|
|
|-
| spell_feature_charges
| integer
|
|
|-
| spell_feature_timing
| integer
|
|
|-
| item_anim_id
| integer
|
|
|-
| description
| longvarchar
|
|
|-
| sound
| varchar
|
|
|-
| item_max_quality
| integer
|
|
|-
| prg_evt_equip
| longvarchar
|
|
|-
| prg_evt_unequip
| longvarchar
|
|
|-
| prg_evt_consume
| longvarchar
|
| 
|-
|-
| creatative_definition
|
| text
|assigned_command
| N
|varchar(40)
| This is used for map/sketch xml
|
|-
|
| max_charges
|
| integer
|Used to determine if the item could be used with a specific command. Will be used to show it in the context menu when the item is equipped.
|  
|-
|  
|
|-
|spawnable
| weapon_range
|char(1)
| real
|
|  
|Y
|  
|
|Sets if the item should be spawnable from in game
|}
|}


Latest revision as of 15:05, 10 July 2022

Item Stats Table

UE Field Type Key Type Default Extra Description
id int(10) unsigned PRI auto_increment unique item_stats id. Referenced by; Item_instancesTable.
stat_type char(1) MUL B (B)asic stat or a (U)nique stat.
name varchar(60) UNI The name of the item.
weight float(10,3) 0.000 The weight of the item ( in pounds ).
visible_distance float(10,2) 100.00 The distance ( in meters ) before an item becomes visible.
size float(10,3) unsigned 0.000 Size of the longest side in feet. Example Claymore 6 feet.
container_max_size int(5) unsigned 1 The maximum size of items that can be placed inside container.
container_max_slots int(5) unsigned 0 The number of slots that will be available in this item to store items inside if it's a container
valid_slots varchar(255) BULK The slots that this item can be in. (See Additional Notes below this table)
flags varchar(255) Flags on this item (See Additional Notes below this table)
decay_rate float(3,2) 0.10 How this item decays as it is used.
item_skill_id_1 smallint(3) -1 Key into the skills table for the type of skill required to use this item.
item_skill_id_2 smallint(3) -1 Key into the skills table for the type of skill required to use this item.
item_skill_id_3 smallint(3) -1 Key into the skills table for the type of skill required to use this item.
item_bonus_1_attr varchar(15)
item_bonus_2_attr varchar(15)
item_bonus_3_attr varchar(15)
item_bonus_1_max float(10,2) 0.00
item_bonus_2_max float(10,2) 0.00
item_bonus_3_max float(10,2) 0.00
dmg_slash float(10,2) 0.00 Amount of slash damage this it will do.
dmg_blunt float(10,2) 0.00 Amount of blunt damage this it will do.
dmg_pierce float(10,2) 0.00 Amount of pierce damage this it will do.
weapon_speed float(10,2) 0.00
weapon_penetration float(10,2) 0.00
weapon_block_targeted float(10,2) 0.00
weapon_block_untargeted float(10,2) 0.00
weapon_counterblock float(10,2) 0.00
armor_hardness float(10,2) 0.00
cstr_gfx_mesh varchar(200)
cstr_gfx_icon varchar(200)
cstr_gfx_texture varchar(200)
cstr_part varchar(200)
cstr_part_mesh varchar(200)
DIF removed_mesh varchar(5000) Lists the mesh to be removed when this item is equipped. It's defined in this format slotname:mesh1,mesh2; slotname:mesh3; mesh4,mesh5. slotname is optional. Type used to be 'varchar(200)' in PSLegacy.
armorvsweapon_type varchar(20)
category_id int(8) unsigned 0 Key into the item_category table that describe what area this item is in.
base_sale_price float(10,2) 0.00
item_type varchar(30)
requirement_1_name varchar(30)
requirement_1_value float(10,2) 0.00
requirement_2_name varchar(30)
requirement_2_value float(10,2) 0.00
requirement_3_name varchar(30)
requirement_3_value float(10,2) 0.00
item_type_id_ammo varchar(30)
spell_id_on_hit int(10) unsigned
spell_on_hit_prob float(6,4) 0.0000
spell_id_feature int(10) unsigned
spell_feature_charges int(10) 0
spell_feature_timing int(10)
item_anim_id int(10) unsigned 0
description text
sound varchar(40) nosound
item_max_quality int(4) 100
equip_script text
consume_script text
creative_definition text This is used for map/sketch xml
max_charges int(3) -1
weapon_range float unsigned 2
assigned_command varchar(40) Used to determine if the item could be used with a specific command. Will be used to show it in the context menu when the item is equipped.
spawnable char(1) Y Sets if the item should be spawnable from in game


Additional Notes

valid_slots

This is a list of valid slot types in PS 0.4.03. A valid database entry is a list of any of these flags seperated by space or comma. The current list of valid slot types can be extracted from src/server/bulkobjects/psitemstats.h.

slot description
BULK
RIGHTHAND Item fits into the right hand slot.
LEFTHAND Item fits into the left hand slot.
BOTHHANDS
HELM Item fits into the helm slot.
LEFTFINGER Item fits into the left finger slot.
RIGHTFINGER Item fits into the right finger slot.
NECK Item fits into neck slot.
BACK
ARMS Item fits into arms slot.
GLOVES Item fits into gloves slot.
BOOTS Item fits into boots slot.
LEGS Item fits into legs slot.
BELT Item fits into belt slot.
BRACERS Item fits into bracers slot.
TORSO Item fits into torso slot.
MIND Item fits into mind slot.
BANK
CRYSTAL
AZURE
RED
DARK
BROWN
BLUE


flags

This is a list of valid item flags in PS 0.5.9.1 A valid database entry is a list of any of these flags seperated by space or comma. The current list of valid flags can be extracted from src/server/bulkobjects/psitemstats.h.

flag description
MELEEWEAPON
RANGEDWEAPON
SHIELD
AMMO
CONTAINER
TRAP
CONSTRUCTIBLE
USESAMMO
STACKABLE
GLYPH
CANTRANSFORM
TRIA
HEXA
OCTA
CIRCLE
CONSUMABLE
READABLE
ARMOR
EQUIP_STACKABLE
WRITEABLE
NOPICKUP
AVERAGEQUALITY
CREATIVE
BUY_PERSONALISE
RECHARGEABLE
Retrieved from "https://planeshift.top-ix.org//pswiki/index.php?title=ItemStatsTable&oldid=24445"