Skip to content
killerwife edited this page May 15, 2023 · 14 revisions

Back to world database list of tables.

The unit_condition table

Official table structure - used for condition checks on units

Structure

Field Type NULL Key Default Comments
Id int(11) unsigned NO PRIMARY 0 Primary Key
Flags int(11) unsigned NO 0
Variable_0 int(11) unsigned NO 0
Variable_1 int(11) unsigned NO 0
Variable_2 int(11) unsigned NO 0
Variable_3 int(11) unsigned NO 0
Variable_4 int(11) unsigned NO 0
Variable_5 int(11) unsigned NO 0
Variable_6 int(11) unsigned NO 0
Variable_7 int(11) unsigned NO 0
Op_0 int(11) unsigned NO 0
Op_1 int(11) unsigned NO 0
Op_2 int(11) unsigned NO 0
Op_3 int(11) unsigned NO 0
Op_4 int(11) unsigned NO 0
Op_5 int(11) unsigned NO 0
Op_6 int(11) unsigned NO 0
Op_7 int(11) unsigned NO 0
Value_0 int(11) unsigned NO 0
Value_1 int(11) unsigned NO 0
Value_2 int(11) unsigned NO 0
Value_3 int(11) unsigned NO 0
Value_4 int(11) unsigned NO 0
Value_5 int(11) unsigned NO 0
Value_6 int(11) unsigned NO 0
Value_7 int(11) unsigned NO 0

Uses

combat_condition
creature_spell_targeting

Description of the fields

Id

Numeric identifier

Flags

By default, multiple conditions are executed with AND operation. UNIT_CONDITION_FLAG_OR = 0x1 causes them to execute as OR.

Variable_0

Variable_1

Variable_2

Variable_3

Variable_4

Variable_5

Variable_6

Variable_7

Each condition has 3 parameters when evaluating: Condition source (Unit), Condition target (Unit), and Value (signed integer)
All variables are enum class UnitCondition:

NONE                                     = 0,
RACE                                     = 1,  Result: Race
CLASS                                    = 2,  Result: Class
LEVEL                                    = 3,  Result: Level
IS_SELF                                  = 4,  Result: 1 if self
IS_MY_PET                                = 5,  Result: 1 if target is my pet
IS_MASTER                                = 6,  Result: 1 if target is my master
IS_TARGET                                = 7,  Result: 1 if source is target of target
CAN_ASSIST                               = 8,  Result: 1 if source can assist target
CAN_ATTACK                               = 9,  Result: 1 if source can attack target
HAS_PET                                  = 10, Result: 1 if source has pet
HAS_WEAPON                               = 11, Result: 1 if source has weapon
HEALTH_PERCENT                           = 12, Result: source health percentage
MANA_PERCENT                             = 13, Result: source mana percentage
RAGE_PERCENT                             = 14, Result: source rage percentage
ENERGY_PERCENT                           = 15, Result: source energy percentage
COMBO_POINTS                             = 16, Result: source combo points
HAS_HELPFUL_AURA_SPELL                   = 17, Result: Value if source has helpful aura
HAS_HELPFUL_AURA_DISPEL_TYPE             = 18, Result: Value if source has helpful aura with dispel type in Value
HAS_HELPFUL_AURA_MECHANIC                = 19, Result: Value if source has helpful aura with mechanic type in Value
HAS_HARMFUL_AURA_SPELL                   = 20, Result: Value if source has harmful aura
HAS_HARMFUL_AURA_DISPEL_TYPE             = 21, Result: Value if source has harmful aura with dispel type in Value
HAS_HARMFUL_AURA_MECHANIC                = 22, Result: Value if source has harmful aura with mechanic type in Value
HAS_HARMFUL_AURA_SCHOOL                  = 23, Result: Value if source has harmful aura with school in Value
DAMAGE_PHYSICAL                          = 24, Result: UNUSED
DAMAGE_HOLY                              = 25, Result: UNUSED
DAMAGE_FIRE                              = 26, Result: UNUSED
DAMAGE_NATURE                            = 27, Result: UNUSED
DAMAGE_FROST                             = 28, Result: UNUSED
DAMAGE_SHADOW                            = 29, Result: UNUSED
DAMAGE_ARCANE                            = 30, Result: UNUSED
IN_COMBAT                                = 31, Result: 1 if source is in combat
IS_MOVING                                = 32, Result: 1 if source is moving
IS_CASTING                               = 33, Result: 1 if source is casting
IS_CASTING_SPELL                         = 34, Result: 1 if source is casting
IS_CHANNELING                            = 35, Result: 1 if source is channeling
IS_CHANNELING_SPELL                      = 36, Result: 1 if source is channeling
NUMBER_OF_MELEE_ATTACKERS                = 37, Result: Number of melee attackers on source
IS_ATTACKING_ME                          = 38, Result: 1 if
RANGE                                    = 39, Result: Range from source to target
IN_MELEE_RANGE                           = 40, Result: 1 if target is in melee range of source
PURSUIT_TIME                             = 41, Result: NYI - Notify should it be needed
HAS_HARMFUL_AURA_CANCELLED_BY_DAMAGE     = 42, Result: 1 if source has harmful aura cancellable by damage (AURA_INTERRUPT_FLAG_DAMAGE)
HAS_HARMFUL_AURA_WITH_PERIODIC_DAMAGE    = 43, Result: 1 if source has harmful aura with type SPELL_AURA_PERIODIC_DAMAGE
NUMBER_OF_ENEMIES                        = 44, Result: Number of enemies on threat list of source
NUMBER_OF_FRIENDS                        = 45, Result: UNK
THREAT_PHYSICAL                          = 46, Result: UNUSED
THREAT_HOLY                              = 47, Result: UNUSED
THREAT_FIRE                              = 48, Result: UNUSED
THREAT_NATURE                            = 49, Result: UNUSED
THREAT_FROST                             = 50, Result: UNUSED
THREAT_SHADOW                            = 51, Result: UNUSED
THREAT_ARCANE                            = 52, Result: UNUSED
IS_INTERRUPTIBLE                         = 53, Result: 1 if source has an interruptible spell
NUMBER_OF_ATTACKERS                      = 54, Result: Number of attackers on source
NUMBER_OF_RANGED_ATTACKERS               = 55, Result: Number of ranged attackers on source
CREATURE_TYPE                            = 56, Result: Creature type of source
IS_MELEE_ATTACKING                       = 57, Result: 1 if source is melee attacking target
IS_RANGED_ATTACKING                      = 58, Result: 1 if source is ranged attacking target
HEALTH                                   = 59, Result: Health of source
SPELL_KNOWN                              = 60, Result: Value if source knows spell Id in value
HAS_HARMFUL_AURA_EFFECT                  = 61, Result: 1 if source has harmful aura effect (Aura in cmangos)
IS_IMMUNE_TO_AREA_OF_EFFECT              = 62, Result: 1 if source is immune to AOE
IS_PLAYER                                = 63, Result: 1 if source is player
DAMAGE_MAGIC                             = 64, Result: UNUSED
DAMAGE_TOTAL                             = 65, Result: UNUSED
THREAT_MAGIC                             = 66, Result: UNUSED
THREAT_TOTAL                             = 67, Result: UNUSED
HAS_CRITTER                              = 68, Result: 1 if source has critter/mini pet
HAS_TOTEM_IN_SLOT_1                      = 69, Result: 1 if source has totem in slot 1
HAS_TOTEM_IN_SLOT_2                      = 70, Result: 1 if source has totem in slot 2
HAS_TOTEM_IN_SLOT_3                      = 71, Result: 1 if source has totem in slot 3
HAS_TOTEM_IN_SLOT_4                      = 72, Result: 1 if source has totem in slot 4
HAS_TOTEM_IN_SLOT_5                      = 73, Result: UNUSED
CREATURE_ID                              = 74, Result: Creature entry
STRING_ID                                = 75, Result: 1 if source has string Id (largely unused, we do not know official Ids for the most part)
HAS_AURA                                 = 76, Result: Value if source has aura Id in Value
IS_ENEMY                                 = 77, Result: 1 if target is enemy of source
IS_SPEC_MELEE                            = 78, Result: NYI - Can port from TC
IS_SPEC_TANK                             = 79, Result: NYI - Can port from TC
IS_SPEC_RANGED                           = 80, Result: NYI - Can port from TC
IS_SPEC_HEALER                           = 81, Result: NYI - Can port from TC
IS_PLAYER_CONTROLLED_NPC                 = 82, Result: 1 if source is npc and has UNIT_FLAG_PLAYER_CONTROLLED
IS_DYING                                 = 83, Result: 1 if source hp is 0
PATH_FAIL_COUNT                          = 84, Result: 1 if target is not reachable - HACK (for now)
UNUSED                                   = 85,
LABEL                                    = 86, Result: UNK

Op_0

Op_1

Op_2

Op_3

Op_4

Op_5

Op_6

Op_7

All op are operations from enum class ConditionOperation:

NONE                        = 0,
EQUAL_TO                    = 1,
NOT_EQUAL_TO                = 2,
LESS_THAN                   = 3,
LESS_THAN_OR_EQUAL_TO       = 4,
GREATER_THAN                = 5,
GREATER_THAN_OR_EQUAL_TO    = 6,

Used to compare result of condition against corresponding Value

Value_0

Value_1

Value_2

Value_3

Value_4

Value_5

Value_6

Value_7

Value for usage in specific unit condition types.

Clone this wiki locally