ItemStatsTable - Revision history

Talad: /* Item Stats Table */

2022-07-10T15:05:10Z

Item Stats Table

← Older revision		Revision as of 15:05, 10 July 2022
Line 59:		Line 59:
	\|0.000		\|0.000
	\|		\|
	\|		\| Size of the longest side in feet. Example Claymore 6 feet.
	\|-		\|-
	\|		\|

Grimston at 12:30, 11 January 2022

2022-01-11T12:30:52Z

Show changes

Magodra: /* Item Stats Table */

2012-07-18T22:23:10Z

Item Stats Table

← Older revision		Revision as of 22:23, 18 July 2012
Line 11:		Line 11:
	\| int		\| int
	\| N		\| N
	\| unique item_stats id		\| unique item_stats id. Referenced by; [[Item_instancesTable]].
	\|-		\|-
	\| stat_type		\| stat_type

Magodra: /* flags */

2012-07-18T22:10:05Z

flags

← Older revision		Revision as of 22:10, 18 July 2012
Line 393:		Line 393:
	=== flags ===		=== flags ===

	This is a list of valid item flags 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 flags can be extracted from '''src/server/bulkobjects/psitemstats.h'''.		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'''.

	{\| border=1		{\| border=1
Line 413:		Line 413:
	\|-		\|-
	\| CONTAINER		\| CONTAINER
			\|
			\|-
			\| TRAP
			\|
			\|-
			\| CONSTRUCTIBLE
	\|		\|
	\|-		\|-

Magodra: /* Item Stats Table */

2012-07-18T22:05:27Z

Item Stats Table

← Older revision		Revision as of 22:05, 18 July 2012
Line 46:		Line 46:
	\| varchar(255)		\| varchar(255)
	\| N		\| N
	\| The slots that this item can be in. (See ''[[#~~Additional_Notes~~\|Additional Notes]]'' below this table)		\| The slots that this item can be in. (See ''[[#valid_slots\|Additional Notes]]'' below this table)
	\|-		\|-
	\| flags		\| flags
	\| varchar(255)		\| varchar(255)
	\| N		\| N
	\| Flags on this item (See ''Additional Notes'' below this table)		\| Flags on this item (See ''[[#flags\|Additional Notes]]'' below this table)
	\|-		\|-
	\| decay_rate		\| decay_rate

Magodra: /* Item Stats Table */

2012-07-18T22:04:13Z

Item Stats Table

← Older revision		Revision as of 22:04, 18 July 2012
Line 46:		Line 46:
	\| varchar(255)		\| varchar(255)
	\| N		\| N
	\| The slots that this item can be in. (See ''[[#~~Additional_Note~~\|Additional Notes]]'' below this table)		\| The slots that this item can be in. (See ''[[#Additional_Notes\|Additional Notes]]'' below this table)
	\|-		\|-
	\| flags		\| flags

Magodra: /* Item Stats Table */

2012-07-18T22:03:46Z

Item Stats Table

← Older revision		Revision as of 22:03, 18 July 2012
Line 46:		Line 46:
	\| varchar(255)		\| varchar(255)
	\| N		\| N
	\| The slots that this item can be in. (See ''Additional Notes'' below this table)		\| The slots that this item can be in. (See ''[[#Additional_Note\|Additional Notes]]'' below this table)
	\|-		\|-
	\| flags		\| flags

Magodra at 22:02, 18 July 2012

2012-07-18T22:02:10Z

← Older revision		Revision as of 22:02, 18 July 2012
Line 1:		Line 1:
			= Item Stats Table =

	{\| border=1		{\| border=1
	\|-		\|-

Ethryn: add to category (Engine documents)

2010-10-23T00:11:51Z

add to category (Engine documents)

← Older revision		Revision as of 00:11, 23 October 2010
Line 467:		Line 467:
	\|		\|
	\|}		\|}


			[[Category:Engine documents]]

Talad: Created page with '{| border=1 |- ! field ! type ! foreign key ! description |- | id | int | N | unique item_stats id |- | stat_type | char(1) | N | (B)asic stat or a (U)nique stat. |- | name | var…'

2010-10-12T22:23:13Z

Created page with '{| border=1 |- ! field ! type ! foreign key ! description |- | id | int | N | unique item_stats id |- | stat_type | char(1) | N | (B)asic stat or a (U)nique stat. |- | name | var…'

New page

{| border=1
|-
! field
! type
! foreign key
! description
|-
| id
| int
| N
| unique item_stats id
|-
| stat_type
| char(1)
| N
| (B)asic stat or a (U)nique stat.
|-
| name
| varchar(60)
| N
| The name of the item.
|-
| weight
| float(10,2)
| N
| The weight of the item ( in pounds ).
|-
| visible_distance
| float(10,2)
| N
| The distance ( in meters ) before an item becomes visible.
|-
| size
| int(5)
| N
|
|-
| container_max_size
| int(5)
| N
| The maximum size of items that can be placed inside container.
|-
| valid_slots
| varchar(255)
| N
| The slots that this item can be in. (See ''Additional Notes'' below this table)
|-
| flags
| varchar(255)
| N
| Flags on this item (See ''Additional Notes'' below this table)
|-
| decay_rate
| float (3,2)
| N
| How this item decays as it is used.
|-
| item_skill_id_1
| smallint(3)
| Y
| Key into the skills table for the type of skill required to use this item.
|-
| item_skill_id_2
| smallint(3)
| Y
| 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_bonus_2_attr
| varchar(15)
| ?
|
|-
| item_bonus_3_attr
| varchar(15)
| ?
|
|-
| item_bonus_1_max
| varchar(15)
| ?
|
|-
| item_bonus_2_max
| varchar(15)
| ?
|
|-
| item_bonus_3_max
| varchar(15)
| ?
|
|-
| dmg_slash
| float(10,2)
| N
| Amount of slash damage this it will do.
|-
| 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
|
|
|-
| weapon_penetration
| real
|
|
|-
| weapon_block_targeted
| real
|
|
|-
| weapon_block_untargeted
| real
|
|
|-
| weapon_counterblock
| real
|
|
|-
| armor_hardness
| real
|
|
|-
| cstr_id_gfx_mesh
| integer
|
|
|-
| cstr_id_gfx_icon
| integer
|
|
|-
| cstr_id_gfx_texture
| integer
|
|
|-
| cstr_id_part
| integer
|
|
|-
| cstr_id_part_mesh
| integer
|
|
|-
| armorvsweapon_type
| varchar
|
|
|-
| category_id
| int(8)
| Y
| Key into the item_category table that describe what area this item is in.
|-
| base_sale_price
| real
|
|
|-
| item_type
| varchar
|
|
|-
| requirement_1_name
| varchar
|
|
|-
| requirement_1_value
| real
|
|
|-
| requirement_2_name
| varchar
|
|
|-
| requirement_2_value
| real
|
|
|-
| 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
| N
| This is used for map/sketch xml
|-
| max_charges
| integer
|
|
|-
| weapon_range
| real
|
|
|}

== 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'''.

{| border=1
|-
! 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.4.03. 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'''.

{| border=1
|-
! flag
! description
|-
| MELEEWEAPON
|
|-
| RANGEDWEAPON
|
|-
| SHIELD
|
|-
| AMMO
|
|-
| CONTAINER
|
|-
| USESAMMO
|
|-
| STACKABLE
|
|-
| GLYPH
|
|-
| CANTRANSFORM
|
|-
| TRIA
|
|-
| HEXA
|
|-
| OCTA
|
|-
| CIRCLE
|
|-
| CONSUMABLE
|
|-
| READABLE
|
|-
| ARMOR
|
|-
| EQUIP_STACKABLE
|
|-
| WRITEABLE
|
|-
| NOPICKUP
|
|-
| AVERAGEQUALITY
|
|-
| CREATIVE
|
|-
| BUY_PERSONALISE
|
|-
| RECHARGEABLE
|
|}