Trade processesTable: Difference between revisions
Jump to navigation
Jump to search
m add to category (Engine documents) |
No edit summary |
||
Line 1: | Line 1: | ||
{| | {| class="wikitable" | ||
|+ | |||
!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 | |||
|- | |- | ||
| | | | ||
| varchar | |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 | ||
| 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. |