spell_reagents
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| ID | int | unsigned | PRI | NO | 0 | ||
| SpellID | int | signed | NO | 0 | |||
| Reagent1 | int | signed | NO | 0 | |||
| Reagent2 | int | signed | NO | 0 | |||
| Reagent3 | int | signed | NO | 0 | |||
| Reagent4 | int | signed | NO | 0 | |||
| Reagent5 | int | signed | NO | 0 | |||
| Reagent6 | int | signed | NO | 0 | |||
| Reagent7 | int | signed | NO | 0 | |||
| Reagent8 | int | signed | NO | 0 | |||
| ReagentCount1 | smallint | signed | NO | 0 | |||
| ReagentCount2 | smallint | signed | NO | 0 | |||
| ReagentCount3 | smallint | signed | NO | 0 | |||
| ReagentCount4 | smallint | signed | NO | 0 | |||
| ReagentCount5 | smallint | signed | NO | 0 | |||
| ReagentCount6 | smallint | signed | NO | 0 | |||
| ReagentCount7 | smallint | signed | NO | 0 | |||
| ReagentCount8 | smallint | signed | NO | 0 | |||
| ReagentRecraftCount1 | smallint | signed | NO | 0 | |||
| ReagentRecraftCount2 | smallint | signed | NO | 0 | |||
| ReagentRecraftCount3 | smallint | signed | NO | 0 | |||
| ReagentRecraftCount4 | smallint | signed | NO | 0 | |||
| ReagentRecraftCount5 | smallint | signed | NO | 0 | |||
| ReagentRecraftCount6 | smallint | signed | NO | 0 | |||
| ReagentRecraftCount7 | smallint | signed | NO | 0 | |||
| ReagentRecraftCount8 | smallint | signed | NO | 0 | |||
| ReagentSource1 | tinyint | unsigned | NO | 0 | |||
| ReagentSource2 | tinyint | unsigned | NO | 0 | |||
| ReagentSource3 | tinyint | unsigned | NO | 0 | |||
| ReagentSource4 | tinyint | unsigned | NO | 0 | |||
| ReagentSource5 | tinyint | unsigned | NO | 0 | |||
| ReagentSource6 | tinyint | unsigned | NO | 0 | |||
| ReagentSource7 | tinyint | unsigned | NO | 0 | |||
| ReagentSource8 | tinyint | unsigned | NO | 0 | |||
| VerifiedBuild | int | signed | PRI | NO | 0 | ||
Description of fields
ID
- no description -
SpellID
- no description -
Reagent1
- no description -
Reagent2
- no description -
Reagent3
- no description -
Reagent4
- no description -
Reagent5
- no description -
Reagent6
- no description -
Reagent7
- no description -
Reagent8
- no description -
ReagentCount1
- no description -
ReagentCount2
- no description -
ReagentCount3
- no description -
ReagentCount4
- no description -
ReagentCount5
- no description -
ReagentCount6
- no description -
ReagentCount7
- no description -
ReagentCount8
- no description -
ReagentRecraftCount1
- no description -
ReagentRecraftCount2
- no description -
ReagentRecraftCount3
- no description -
ReagentRecraftCount4
- no description -
ReagentRecraftCount5
- no description -
ReagentRecraftCount6
- no description -
ReagentRecraftCount7
- no description -
ReagentRecraftCount8
- no description -
ReagentSource1
- no description -
ReagentSource2
- no description -
ReagentSource3
- no description -
ReagentSource4
- no description -
ReagentSource5
- no description -
ReagentSource6
- no description -
ReagentSource7
- no description -
ReagentSource8
- no description -
VerifiedBuild
This field is used by the TrinityDB Team to determine whether a template has been verified from WDB files.
If value is 0 then it has not been parsed yet.
If value is above 0 then it has been parsed with WDB files from that specific client build.
If value is -1 then it is just a place holder until proper data are found on WDBs.
If value is -Client Build then it was parsed with WDB files from that specific client build and manually edited later for some special necessity.