Trade processesTable: Difference between revisions

From PSwiki
Jump to navigation Jump to search
Ethryn (talk | contribs)
m add to category (Engine documents)
Grimston (talk | contribs)
No edit summary
Line 1: Line 1:
{| border="1"
{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|-
! field
|
! type
|process_id
! foreign key
|int(10) unsigned
! description
|PRI
|
|
|
|-
|-
| process_id
|
| integer
|subprocess_number
|  
|int(4) unsigned
|  
|PRI
|
|
|subprocess number
|-
|-
| subprocess_number
|
| integer
|name
|  
|varchar(40)
|  
|
|
|
|process name
|-
|-
| name
|
| varchar
|animation
|  
|varchar(30)
|  
|
|
|
|transformation animation
|-
|-
| animation
|DIF
| varchar
|render_effect
|  
|char(32)
|  
|
|
|
|transformation render effect  Type used to be 'char(1)' in PSLegacy.
|-
|-
| render_effect
|
| char
|workitem_id
|  
|int(10) unsigned
|  
|
|
|
|target item to complete transformation
|-
|-
| workitem_id
|
| integer
|equipment_id
|  
|int(10) unsigned
|  
|
|
|
|required equipped item
|-
|-
| equipment_id
|
| integer
|constraints
|  
|varchar(64)
|  
|
|
|
|constraints that apply to the transformation
|-
|-
| constraints
|
| varchar
|garbage_id
|  
|int(10) unsigned
|  
|
|
|
|garbage item for flubbed transformations
|-
|-
| garbage_id
|
| integer
|garbage_qty
|  
|int(8) unsigned
|  
|
|
|
|garbage quantity for flubbed transformations
|-
|-
| garbage_qty
|
| integer
|primary_skill_id
|  
|int(10)
|  
|
|
|
|primary skill for transformation
|-
|-
| primary_skill_id
|
| integer
|primary_min_skill
|  
|int(8) unsigned
|  
|
|
|
|minimum primary skill level required to perform the transformation, 0 is no minimum
|-
|-
| primary_min_skill
|
| integer
|primary_max_skill
|  
|int(8) unsigned
|  
|
|
|
|maximum primary skill level at which practice and quality are affected, 0 is no maximum
|-
|-
| primary_max_skill
|
| integer
|primary_practice_points
|  
|int(4)
|  
|
|
|
|number of practice primary skill points gained for performing transformation
|-
|-
| primary_practice_points
|
| integer
|primary_quality_factor
|  
|int(3) unsigned
|  
|
|0
|
|percentage of the primary skill range that applies to quality
|-
|-
| primary_quality_factor
|
| integer
|secondary_skill_id
|  
|int(10)
|  
|
|
|
|secondary skill foreign key
|-
|-
| secondary_skill_id
|
| integer
|secondary_min_skill
|  
|int(8) unsigned
|  
|
|
|
|minimum secondary skill level required to perform the transformation, 0 is no minimum
|-
|-
| secondary_min_skill
|
| integer
|secondary_max_skill
|  
|int(8) unsigned
|  
|
|
|
|maximum secondary skill level at which practice and quality are affected, 0 is no maximum
|-
|-
| secondary_max_skill
|
| integer
|secondary_practice_points
|  
|int(4)
|  
|
|
|
|number of practice secondary skill points gained for performing transformation
|-
|-
| secondary_practice_points
|
| integer
|secondary_quality_factor
|  
|int(3) unsigned
|  
|
|
|
|percentage of the secondary skill range that applies to quality
|-
|-
| secondary_quality_factor
|
| integer
|description
|  
|varchar(255)
|
|
|
|  
|  
|-
|-
| description
|ADD
| varchar
|script
|  
|varchar(255)
|  
|
|Apply Post Trade Process
|
|A script to run after a process has been completed. In order to apply custom effects to the result.
|}
|}


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

Revision as of 13:24, 11 January 2022

UE Field Type Key Type Default Extra Description
process_id int(10) unsigned PRI
subprocess_number int(4) unsigned PRI subprocess number
name varchar(40) process name
animation varchar(30) transformation animation
DIF render_effect char(32) transformation render effect Type used to be 'char(1)' in PSLegacy.
workitem_id int(10) unsigned target item to complete transformation
equipment_id int(10) unsigned required equipped item
constraints varchar(64) constraints that apply to the transformation
garbage_id int(10) unsigned garbage item for flubbed transformations
garbage_qty int(8) unsigned garbage quantity for flubbed transformations
primary_skill_id int(10) primary skill for transformation
primary_min_skill int(8) unsigned minimum primary skill level required to perform the transformation, 0 is no minimum
primary_max_skill int(8) unsigned maximum primary skill level at which practice and quality are affected, 0 is no maximum
primary_practice_points int(4) number of practice primary skill points gained for performing transformation
primary_quality_factor int(3) unsigned 0 percentage of the primary skill range that applies to quality
secondary_skill_id int(10) secondary skill foreign key
secondary_min_skill int(8) unsigned minimum secondary skill level required to perform the transformation, 0 is no minimum
secondary_max_skill int(8) unsigned maximum secondary skill level at which practice and quality are affected, 0 is no maximum
secondary_practice_points int(4) number of practice secondary skill points gained for performing transformation
secondary_quality_factor int(3) unsigned percentage of the secondary skill range that applies to quality
description varchar(255)
ADD script varchar(255) Apply Post Trade Process A script to run after a process has been completed. In order to apply custom effects to the result.