player_condition

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
ID	int	unsigned	PRI	NO	0
RaceMask	bigint	signed		NO	0
FailureDescription	text			YES	NULL
ClassMask	int	signed		NO	0
SkillLogic	int	unsigned		NO	0
LanguageID	int	signed		NO	0
MinLanguage	tinyint	unsigned		NO	0
MaxLanguage	int	signed		NO	0
MaxFactionID	smallint	unsigned		NO	0
MaxReputation	tinyint	unsigned		NO	0
ReputationLogic	int	unsigned		NO	0
CurrentPvpFaction	tinyint	signed		NO	0
PvpMedal	tinyint	unsigned		NO	0
PrevQuestLogic	int	unsigned		NO	0
CurrQuestLogic	int	unsigned		NO	0
CurrentCompletedQuestLogic	int	unsigned		NO	0
SpellLogic	int	unsigned		NO	0
ItemLogic	int	unsigned		NO	0
ItemFlags	tinyint	unsigned		NO	0
AuraSpellLogic	int	unsigned		NO	0
WorldStateExpressionID	smallint	unsigned		NO	0
WeatherID	int	signed		NO	0
PartyStatus	tinyint	unsigned		NO	0
LifetimeMaxPVPRank	tinyint	unsigned		NO	0
AchievementLogic	int	unsigned		NO	0
Gender	tinyint	signed		NO	0
NativeGender	tinyint	signed		NO	0
AreaLogic	int	unsigned		NO	0
LfgLogic	int	unsigned		NO	0
CurrencyLogic	int	unsigned		NO	0
QuestKillID	int	signed		NO	0
QuestKillLogic	int	unsigned		NO	0
MinExpansionLevel	tinyint	signed		NO	0
MaxExpansionLevel	tinyint	signed		NO	0
MinAvgItemLevel	int	signed		NO	0
MaxAvgItemLevel	int	signed		NO	0
MinAvgEquippedItemLevel	smallint	unsigned		NO	0
MaxAvgEquippedItemLevel	smallint	unsigned		NO	0
PhaseUseFlags	int	signed		NO	0
PhaseID	smallint	unsigned		NO	0
PhaseGroupID	int	unsigned		NO	0
Flags	int	signed		NO	0
ChrSpecializationIndex	tinyint	signed		NO	0
ChrSpecializationRole	tinyint	signed		NO	0
ModifierTreeID	int	unsigned		NO	0
PowerType	tinyint	signed		NO	0
PowerTypeComp	tinyint	signed		NO	0
PowerTypeValue	tinyint	unsigned		NO	0
WeaponSubclassMask	int	signed		NO	0
MaxGuildLevel	tinyint	unsigned		NO	0
MinGuildLevel	tinyint	unsigned		NO	0
MaxExpansionTier	tinyint	signed		NO	0
MinExpansionTier	tinyint	signed		NO	0
MinPVPRank	tinyint	unsigned		NO	0
MaxPVPRank	tinyint	unsigned		NO	0
ContentTuningID	int	signed		NO	0
CovenantID	int	signed		NO	0
TraitNodeEntryLogic	int	unsigned		NO	0
SkillID1	smallint	unsigned		NO	0
SkillID2	smallint	unsigned		NO	0
SkillID3	smallint	unsigned		NO	0
SkillID4	smallint	unsigned		NO	0
MinSkill1	smallint	unsigned		NO	0
MinSkill2	smallint	unsigned		NO	0
MinSkill3	smallint	unsigned		NO	0
MinSkill4	smallint	unsigned		NO	0
MaxSkill1	smallint	unsigned		NO	0
MaxSkill2	smallint	unsigned		NO	0
MaxSkill3	smallint	unsigned		NO	0
MaxSkill4	smallint	unsigned		NO	0
MinFactionID1	int	unsigned		NO	0
MinFactionID2	int	unsigned		NO	0
MinFactionID3	int	unsigned		NO	0
MinReputation1	tinyint	unsigned		NO	0
MinReputation2	tinyint	unsigned		NO	0
MinReputation3	tinyint	unsigned		NO	0
PrevQuestID1	int	signed		NO	0
PrevQuestID2	int	signed		NO	0
PrevQuestID3	int	signed		NO	0
PrevQuestID4	int	signed		NO	0
CurrQuestID1	int	signed		NO	0
CurrQuestID2	int	signed		NO	0
CurrQuestID3	int	signed		NO	0
CurrQuestID4	int	signed		NO	0
CurrentCompletedQuestID1	int	signed		NO	0
CurrentCompletedQuestID2	int	signed		NO	0
CurrentCompletedQuestID3	int	signed		NO	0
CurrentCompletedQuestID4	int	signed		NO	0
SpellID1	int	signed		NO	0
SpellID2	int	signed		NO	0
SpellID3	int	signed		NO	0
SpellID4	int	signed		NO	0
ItemID1	int	signed		NO	0
ItemID2	int	signed		NO	0
ItemID3	int	signed		NO	0
ItemID4	int	signed		NO	0
ItemCount1	int	unsigned		NO	0
ItemCount2	int	unsigned		NO	0
ItemCount3	int	unsigned		NO	0
ItemCount4	int	unsigned		NO	0
Explored1	smallint	unsigned		NO	0
Explored2	smallint	unsigned		NO	0
Time1	int	unsigned		NO	0
Time2	int	unsigned		NO	0
AuraSpellID1	int	signed		NO	0
AuraSpellID2	int	signed		NO	0
AuraSpellID3	int	signed		NO	0
AuraSpellID4	int	signed		NO	0
AuraStacks1	tinyint	unsigned		NO	0
AuraStacks2	tinyint	unsigned		NO	0
AuraStacks3	tinyint	unsigned		NO	0
AuraStacks4	tinyint	unsigned		NO	0
Achievement1	smallint	unsigned		NO	0
Achievement2	smallint	unsigned		NO	0
Achievement3	smallint	unsigned		NO	0
Achievement4	smallint	unsigned		NO	0
AreaID1	smallint	unsigned		NO	0
AreaID2	smallint	unsigned		NO	0
AreaID3	smallint	unsigned		NO	0
AreaID4	smallint	unsigned		NO	0
LfgStatus1	tinyint	unsigned		NO	0
LfgStatus2	tinyint	unsigned		NO	0
LfgStatus3	tinyint	unsigned		NO	0
LfgStatus4	tinyint	unsigned		NO	0
LfgCompare1	tinyint	unsigned		NO	0
LfgCompare2	tinyint	unsigned		NO	0
LfgCompare3	tinyint	unsigned		NO	0
LfgCompare4	tinyint	unsigned		NO	0
LfgValue1	int	unsigned		NO	0
LfgValue2	int	unsigned		NO	0
LfgValue3	int	unsigned		NO	0
LfgValue4	int	unsigned		NO	0
CurrencyID1	int	unsigned		NO	0
CurrencyID2	int	unsigned		NO	0
CurrencyID3	int	unsigned		NO	0
CurrencyID4	int	unsigned		NO	0
CurrencyCount1	int	unsigned		NO	0
CurrencyCount2	int	unsigned		NO	0
CurrencyCount3	int	unsigned		NO	0
CurrencyCount4	int	unsigned		NO	0
QuestKillMonster1	int	unsigned		NO	0
QuestKillMonster2	int	unsigned		NO	0
QuestKillMonster3	int	unsigned		NO	0
QuestKillMonster4	int	unsigned		NO	0
QuestKillMonster5	int	unsigned		NO	0
QuestKillMonster6	int	unsigned		NO	0
MovementFlags1	int	signed		NO	0
MovementFlags2	int	signed		NO	0
TraitNodeEntryID1	int	signed		NO	0
TraitNodeEntryID2	int	signed		NO	0
TraitNodeEntryID3	int	signed		NO	0
TraitNodeEntryID4	int	signed		NO	0
TraitNodeEntryMinRank1	smallint	unsigned		NO	0
TraitNodeEntryMinRank2	smallint	unsigned		NO	0
TraitNodeEntryMinRank3	smallint	unsigned		NO	0
TraitNodeEntryMinRank4	smallint	unsigned		NO	0
TraitNodeEntryMaxRank1	smallint	unsigned		NO	0
TraitNodeEntryMaxRank2	smallint	unsigned		NO	0
TraitNodeEntryMaxRank3	smallint	unsigned		NO	0
TraitNodeEntryMaxRank4	smallint	unsigned		NO	0
VerifiedBuild	int	signed	PRI	NO	0

Description of fields

ID

- no description -  

RaceMask

- no description -  

FailureDescription

- no description -  

ClassMask

- no description -  

SkillLogic

- no description -  

LanguageID

- no description -  

MinLanguage

- no description -  

MaxLanguage

- no description -  

MaxFactionID

- no description -  

MaxReputation

- no description -  

ReputationLogic

- no description -  

CurrentPvpFaction

- no description -  

PvpMedal

- no description -  

PrevQuestLogic

- no description -  

CurrQuestLogic

- no description -  

CurrentCompletedQuestLogic

- no description -  

SpellLogic

- no description -  

ItemLogic

- no description -  

ItemFlags

- no description -  

AuraSpellLogic

- no description -  

WorldStateExpressionID

- no description -  

WeatherID

- no description -  

PartyStatus

- no description -  

LifetimeMaxPVPRank

- no description -  

AchievementLogic

- no description -  

Gender

- no description -  

NativeGender

- no description -  

AreaLogic

- no description -  

LfgLogic

- no description -  

CurrencyLogic

- no description -  

QuestKillID

- no description -  

QuestKillLogic

- no description -  

MinExpansionLevel

- no description -  

MaxExpansionLevel

- no description -  

MinAvgItemLevel

- no description -  

MaxAvgItemLevel

- no description -  

MinAvgEquippedItemLevel

- no description -  

MaxAvgEquippedItemLevel

- no description -  

PhaseUseFlags

- no description -  

PhaseID

- no description -  

PhaseGroupID

- no description -  

Flags

- no description -  

ChrSpecializationIndex

- no description -  

ChrSpecializationRole

- no description -  

ModifierTreeID

- no description -  

PowerType

- no description -  

PowerTypeComp

- no description -  

PowerTypeValue

- no description -  

WeaponSubclassMask

- no description -  

MaxGuildLevel

- no description -  

MinGuildLevel

- no description -  

MaxExpansionTier

- no description -  

MinExpansionTier

- no description -  

MinPVPRank

- no description -  

MaxPVPRank

- no description -  

ContentTuningID

- no description -  

CovenantID

- no description -  

TraitNodeEntryLogic

- no description -  

SkillID1

- no description -  

SkillID2

- no description -  

SkillID3

- no description -  

SkillID4

- no description -  

MinSkill1

- no description -  

MinSkill2

- no description -  

MinSkill3

- no description -  

MinSkill4

- no description -  

MaxSkill1

- no description -  

MaxSkill2

- no description -  

MaxSkill3

- no description -  

MaxSkill4

- no description -  

MinFactionID1

- no description -  

MinFactionID2

- no description -  

MinFactionID3

- no description -  

MinReputation1

- no description -  

MinReputation2

- no description -  

MinReputation3

- no description -  

PrevQuestID1

- no description -  

PrevQuestID2

- no description -  

PrevQuestID3

- no description -  

PrevQuestID4

- no description -  

CurrQuestID1

- no description -  

CurrQuestID2

- no description -  

CurrQuestID3

- no description -  

CurrQuestID4

- no description -  

CurrentCompletedQuestID1

- no description -  

CurrentCompletedQuestID2

- no description -  

CurrentCompletedQuestID3

- no description -  

CurrentCompletedQuestID4

- no description -  

SpellID1

- no description -  

SpellID2

- no description -  

SpellID3

- no description -  

SpellID4

- no description -  

ItemID1

- no description -  

ItemID2

- no description -  

ItemID3

- no description -  

ItemID4

- no description -  

ItemCount1

- no description -  

ItemCount2

- no description -  

ItemCount3

- no description -  

ItemCount4

- no description -  

Explored1

- no description -  

Explored2

- no description -  

Time1

- no description -  

Time2

- no description -  

AuraSpellID1

- no description -  

AuraSpellID2

- no description -  

AuraSpellID3

- no description -  

AuraSpellID4

- no description -  

AuraStacks1

- no description -  

AuraStacks2

- no description -  

AuraStacks3

- no description -  

AuraStacks4

- no description -  

Achievement1

- no description -  

Achievement2

- no description -  

Achievement3

- no description -  

Achievement4

- no description -  

AreaID1

- no description -  

AreaID2

- no description -  

AreaID3

- no description -  

AreaID4

- no description -  

LfgStatus1

- no description -  

LfgStatus2

- no description -  

LfgStatus3

- no description -  

LfgStatus4

- no description -  

LfgCompare1

- no description -  

LfgCompare2

- no description -  

LfgCompare3

- no description -  

LfgCompare4

- no description -  

LfgValue1

- no description -  

LfgValue2

- no description -  

LfgValue3

- no description -  

LfgValue4

- no description -  

CurrencyID1

- no description -  

CurrencyID2

- no description -  

CurrencyID3

- no description -  

CurrencyID4

- no description -  

CurrencyCount1

- no description -  

CurrencyCount2

- no description -  

CurrencyCount3

- no description -  

CurrencyCount4

- no description -  

QuestKillMonster1

- no description -  

QuestKillMonster2

- no description -  

QuestKillMonster3

- no description -  

QuestKillMonster4

- no description -  

QuestKillMonster5

- no description -  

QuestKillMonster6

- no description -  

MovementFlags1

- no description -  

MovementFlags2

- no description -  

TraitNodeEntryID1

- no description -  

TraitNodeEntryID2

- no description -  

TraitNodeEntryID3

- no description -  

TraitNodeEntryID4

- no description -  

TraitNodeEntryMinRank1

- no description -  

TraitNodeEntryMinRank2

- no description -  

TraitNodeEntryMinRank3

- no description -  

TraitNodeEntryMinRank4

- no description -  

TraitNodeEntryMaxRank1

- no description -  

TraitNodeEntryMaxRank2

- no description -  

TraitNodeEntryMaxRank3

- no description -  

TraitNodeEntryMaxRank4

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