Item instancesTable - Revision history

Talad at 17:01, 4 November 2023

2023-11-04T17:01:57Z

← Older revision		Revision as of 17:01, 4 November 2023
Line 171:		Line 171:
	\|Key into the ItemStatsTable for the standard version of this item.		\|Key into the ItemStatsTable for the standard version of this item.
	\|-		\|-
	\|		\|ADD
	\|~~item_stats_id_unique~~		\|min_faction
	\|int(10) unsigned		\|int(10) unsigned
	\|		\|
	\|0		\|0
	\|		\|
	\|~~Key into the ItemStatsTable for unique versions of~~ this item.		\|minimum faction score needed to buy this item from a merchant
	\|-		\|-
	\|		\|

Grimston at 14:44, 11 January 2022

2022-01-11T14:44:07Z

← Older revision		Revision as of 14:44, 11 January 2022
Line 219:		Line 219:
	\|		\|
	\|-		\|-
	\|~~DIF~~		\|
	\|item_description		\|item_description
	\|text		\|text
Line 225:		Line 225:
	\|		\|
	\|		\|
	\| ~~Type used to be 'varchar(255)' in PSLegacy. Default used to be '' in PSLegacy.~~		\|
	\|-		\|-
	\|		\|

Grimston at 12:25, 11 January 2022

2022-01-11T12:25:27Z

Show changes

Magodra at 22:20, 18 July 2012

2012-07-18T22:20:03Z

← Older revision		Revision as of 22:20, 18 July 2012
Line 14:		Line 14:
	\| int(10) unsigned		\| int(10) unsigned
	\| Y		\| Y
	\|		\| Key into the [[CharactersTable]] for the owner of this item.
	\|-		\|-
	\| char_id_guardian		\| char_id_guardian
	\| int(10) unsigned		\| int(10) unsigned
	\| Y		\| Y
	\|		\| Key into the [[CharactersTable]] for the guardian of this item.
	\|-		\|-
	\| parent_item_id		\| parent_item_id
Line 39:		Line 39:
	\| int(10) unsigned		\| int(10) unsigned
	\| Y		\| Y
	\|		\| Key into the [[CharactersTable]] for the creator of this item if craftet.
	\|-		\|-
	\| guild_mark_id		\| guild_mark_id
Line 94:		Line 94:
	\| int(10) unsigned		\| int(10) unsigned
	\| Y		\| Y
	\|		\| Key into the [[ItemStatsTable]] for the standard version of this item.
	\|-		\|-
	\| item_stats_id_unique		\| item_stats_id_unique
	\| int(10) unsigned		\| int(10) unsigned
	\| Y		\| Y
	\|		\| Key into the [[ItemStatsTable]] for unique versions of this item.
	\|-		\|-
	\| flags		\| flags

Magodra at 22:14, 18 July 2012

2012-07-18T22:14:08Z

← Older revision		Revision as of 22:14, 18 July 2012
Line 13:		Line 13:
	\| char_id_owner		\| char_id_owner
	\| int(10) unsigned		\| int(10) unsigned
	\|		\| Y
	\|		\|
	\|-		\|-
	\| char_id_guardian		\| char_id_guardian
	\| int(10) unsigned		\| int(10) unsigned
	\|		\| Y
	\|		\|
	\|-		\|-
	\| parent_item_id		\| parent_item_id
	\| int(10) unsigned		\| int(10) unsigned
	\|		\| Y
	\|		\|
	\|-		\|-
Line 38:		Line 38:
	\| creator_mark_id		\| creator_mark_id
	\| int(10) unsigned		\| int(10) unsigned
	\|		\| Y
	\|		\|
	\|-		\|-
	\| guild_mark_id		\| guild_mark_id
	\| int(10) unsigned		\| int(10) unsigned
	\|		\| Y
	\|		\|
	\|-		\|-
Line 53:		Line 53:
	\| loc_sector_id		\| loc_sector_id
	\| smallint(4) unsigned		\| smallint(4) unsigned
	\|		\| Y
	\|		\|
	\|-		\|-
Line 93:		Line 93:
	\| item_stats_id_standard		\| item_stats_id_standard
	\| int(10) unsigned		\| int(10) unsigned
	\|		\| Y
	\|		\|
	\|-		\|-
	\| item_stats_id_unique		\| item_stats_id_unique
	\| int(10) unsigned		\| int(10) unsigned
	\|		\| Y
	\|		\|
	\|-		\|-

Talad: Reverted edits by Kuru (Talk) to last revision by Ethryn

2010-12-10T23:14:32Z

Reverted edits by Kuru (Talk) to last revision by Ethryn

← Older revision		Revision as of 23:14, 10 December 2010
Line 1:		Line 1:
	~~spam~~		{\| border=1
			\|-
			! field
			! type
			! foreign key
			! description
			\|-
			\| id
			\| int(10) unsigned
			\|
			\|
			\|-
			\| char_id_owner
			\| int(10) unsigned
			\|
			\|
			\|-
			\| char_id_guardian
			\| int(10) unsigned
			\|
			\|
			\|-
			\| parent_item_id
			\| int(10) unsigned
			\|
			\|
			\|-
			\| location_in_parent
			\| smallint(4)
			\|
			\|
			\|-
			\| stack_count
			\| int(10) unsigned
			\|
			\|
			\|-
			\| creator_mark_id
			\| int(10) unsigned
			\|
			\|
			\|-
			\| guild_mark_id
			\| int(10) unsigned
			\|
			\|
			\|-
			\| loc_instance
			\| int(11) unsigned
			\|
			\|
			\|-
			\| loc_sector_id
			\| smallint(4) unsigned
			\|
			\|
			\|-
			\| loc_x
			\| float(14,6)
			\|
			\|
			\|-
			\| loc_y
			\| float(14,6)
			\|
			\|
			\|-
			\| loc_z
			\| float(14,6)
			\|
			\|
			\|-
			\| loc_yrot
			\| float(14,6)
			\|
			\|
			\|-
			\| decay_resistance
			\| float(3,2)
			\|
			\|
			\|-
			\| item_quality
			\| float(5,2)
			\|
			\|
			\|-
			\| crafted_quality
			\| float(5,2)
			\|
			\|
			\|-
			\| item_stats_id_standard
			\| int(10) unsigned
			\|
			\|
			\|-
			\| item_stats_id_unique
			\| int(10) unsigned
			\|
			\|
			\|-
			\| flags
			\| varchar(200)
			\|
			\|
			\|-
			\| lock_str
			\| int(5)
			\|
			\|
			\|-
			\| lock_skill
			\| int(2)
			\|
			\|
			\|-
			\| openable_locks
			\| varchar(100)
			\|
			\|
			\|-
			\| item_name
			\| varchar(100)
			\|
			\|
			\|-
			\| item_description
			\| varchar(255)
			\|
			\|
			\|-
			\| charges
			\| int(3)
			\|
			\|
			\|}


			[[Category:Engine documents]]

Kuru at 21:22, 10 December 2010

2010-12-10T21:22:41Z

← Older revision		Revision as of 21:22, 10 December 2010
Line 1:		Line 1:
	~~{\| border=1~~		spam
	\|-
	~~! field~~
	~~! type~~
	~~! foreign key~~
	~~! description~~
	\|-
	~~\| id~~
	~~\| int(10) unsigned~~
	\|
	\|
	\|-
	~~\| char_id_owner~~
	~~\| int(10) unsigned~~
	\|
	\|
	\|-
	~~\| char_id_guardian~~
	~~\| int(10) unsigned~~
	\|
	\|
	\|-
	~~\| parent_item_id~~
	~~\| int(10) unsigned~~
	\|
	\|
	\|-
	~~\| location_in_parent~~
	~~\| smallint(4)~~
	\|
	\|
	\|-
	~~\| stack_count~~
	~~\| int(10) unsigned~~
	\|
	\|
	\|-
	~~\| creator_mark_id~~
	~~\| int(10) unsigned~~
	\|
	\|
	\|-
	~~\| guild_mark_id~~
	~~\| int(10) unsigned~~
	\|
	\|
	\|-
	~~\| loc_instance~~
	~~\| int(11) unsigned~~
	\|
	\|
	\|-
	~~\| loc_sector_id~~
	~~\| smallint(4) unsigned~~
	\|
	\|
	\|-
	~~\| loc_x~~
	~~\| float(14,6)~~
	\|
	\|
	\|-
	~~\| loc_y~~
	~~\| float(14,6)~~
	\|
	\|
	\|-
	~~\| loc_z~~
	~~\| float(14,6)~~
	\|
	\|
	\|-
	~~\| loc_yrot~~
	~~\| float(14,6)~~
	\|
	\|
	\|-
	~~\| decay_resistance~~
	~~\| float(3,2)~~
	\|
	\|
	\|-
	~~\| item_quality~~
	~~\| float(5,2)~~
	\|
	\|
	\|-
	~~\| crafted_quality~~
	~~\| float(5,2)~~
	\|
	\|
	\|-
	~~\| item_stats_id_standard~~
	~~\| int(10) unsigned~~
	\|
	\|
	\|-
	~~\| item_stats_id_unique~~
	~~\| int(10) unsigned~~
	\|
	\|
	\|-
	~~\| flags~~
	~~\| varchar(200)~~
	\|
	\|
	\|-
	~~\| lock_str~~
	~~\| int(5)~~
	\|
	\|
	\|-
	~~\| lock_skill~~
	~~\| int(2)~~
	\|
	\|
	\|-
	~~\| openable_locks~~
	~~\| varchar(100)~~
	\|
	\|
	\|-
	~~\| item_name~~
	~~\| varchar(100)~~
	\|
	\|
	\|-
	~~\| item_description~~
	~~\| varchar(255)~~
	\|
	\|
	\|-
	~~\| charges~~
	~~\| int(3)~~
	\|
	\|
	\|}


	~~[[Category:Engine documents]]~~

Ethryn: add to category (Engine documents)

2010-10-23T00:20:14Z

add to category (Engine documents)

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


			[[Category:Engine documents]]

Talad: Created page with '{| border=1 |- ! field ! type ! foreign key ! description |- | id | int(10) unsigned | | |- | char_id_owner | int(10) unsigned | | |- | char_id_guardian | int(10) unsigned | | …'

2010-10-12T22:23:07Z

Created page with '{| border=1 |- ! field ! type ! foreign key ! description |- | id | int(10) unsigned | | |- | char_id_owner | int(10) unsigned | | |- | char_id_guardian | int(10) unsigned | | …'

New page

{| border=1
|-
! field
! type
! foreign key
! description
|-
| id
| int(10) unsigned
|
|
|-
| char_id_owner
| int(10) unsigned
|
|
|-
| char_id_guardian
| int(10) unsigned
|
|
|-
| parent_item_id
| int(10) unsigned
|
|
|-
| location_in_parent
| smallint(4)
|
|
|-
| stack_count
| int(10) unsigned
|
|
|-
| creator_mark_id
| int(10) unsigned
|
|
|-
| guild_mark_id
| int(10) unsigned
|
|
|-
| loc_instance
| int(11) unsigned
|
|
|-
| loc_sector_id
| smallint(4) unsigned
|
|
|-
| loc_x
| float(14,6)
|
|
|-
| loc_y
| float(14,6)
|
|
|-
| loc_z
| float(14,6)
|
|
|-
| loc_yrot
| float(14,6)
|
|
|-
| decay_resistance
| float(3,2)
|
|
|-
| item_quality
| float(5,2)
|
|
|-
| crafted_quality
| float(5,2)
|
|
|-
| item_stats_id_standard
| int(10) unsigned
|
|
|-
| item_stats_id_unique
| int(10) unsigned
|
|
|-
| flags
| varchar(200)
|
|
|-
| lock_str
| int(5)
|
|
|-
| lock_skill
| int(2)
|
|
|-
| openable_locks
| varchar(100)
|
|
|-
| item_name
| varchar(100)
|
|
|-
| item_description
| varchar(255)
|
|
|-
| charges
| int(3)
|
|
|}

← Older revision		Revision as of 21:22, 10 December 2010
Line 1:		Line 1:
	~~{\| border=1~~		spam
	\|-
	~~! field~~
	~~! type~~
	~~! foreign key~~
	~~! description~~
	\|-
	~~\| id~~
	~~\| int(10) unsigned~~
	\|
	\|
	\|-
	~~\| char_id_owner~~
	~~\| int(10) unsigned~~
	\|
	\|
	\|-
	~~\| char_id_guardian~~
	~~\| int(10) unsigned~~
	\|
	\|
	\|-
	~~\| parent_item_id~~
	~~\| int(10) unsigned~~
	\|
	\|
	\|-
	~~\| location_in_parent~~
	~~\| smallint(4)~~
	\|
	\|
	\|-
	~~\| stack_count~~
	~~\| int(10) unsigned~~
	\|
	\|
	\|-
	~~\| creator_mark_id~~
	~~\| int(10) unsigned~~
	\|
	\|
	\|-
	~~\| guild_mark_id~~
	~~\| int(10) unsigned~~
	\|
	\|
	\|-
	~~\| loc_instance~~
	~~\| int(11) unsigned~~
	\|
	\|
	\|-
	~~\| loc_sector_id~~
	~~\| smallint(4) unsigned~~
	\|
	\|
	\|-
	~~\| loc_x~~
	~~\| float(14,6)~~
	\|
	\|
	\|-
	~~\| loc_y~~
	~~\| float(14,6)~~
	\|
	\|
	\|-
	~~\| loc_z~~
	~~\| float(14,6)~~
	\|
	\|
	\|-
	~~\| loc_yrot~~
	~~\| float(14,6)~~
	\|
	\|
	\|-
	~~\| decay_resistance~~
	~~\| float(3,2)~~
	\|
	\|
	\|-
	~~\| item_quality~~
	~~\| float(5,2)~~
	\|
	\|
	\|-
	~~\| crafted_quality~~
	~~\| float(5,2)~~
	\|
	\|
	\|-
	~~\| item_stats_id_standard~~
	~~\| int(10) unsigned~~
	\|
	\|
	\|-
	~~\| item_stats_id_unique~~
	~~\| int(10) unsigned~~
	\|
	\|
	\|-
	~~\| flags~~
	~~\| varchar(200)~~
	\|
	\|
	\|-
	~~\| lock_str~~
	~~\| int(5)~~
	\|
	\|
	\|-
	~~\| lock_skill~~
	~~\| int(2)~~
	\|
	\|
	\|-
	~~\| openable_locks~~
	~~\| varchar(100)~~
	\|
	\|
	\|-
	~~\| item_name~~
	~~\| varchar(100)~~
	\|
	\|
	\|-
	~~\| item_description~~
	~~\| varchar(255)~~
	\|
	\|
	\|-
	~~\| charges~~
	~~\| int(3)~~
	\|
	\|
	\|}


	~~[[Category:Engine documents]]~~