MaNGOS表-conditions
Description of the MaNGOSZero conditions Table.
With this table and the new conditions it is possible to create tree like and very complicated combined conditions (like HasAura && (HasItem || HasQuest)) Used in: DBScript gossip_menu gossip_menu_option npc_spellclick_spells spell_area
Table Notes
This table uses the 'MyISAM' DB Engine
The Field definitions follow
Field Name | Field Type | Nullable | Key | Default Value | Attributes | Notes |
condition_entry | mediumint(8) unsigned | NO | PRI | NULL | 'auto_increment' | Identifier |
type | tinyint(3) | NO | MUL | '0' | Type of the condition. | |
value1 | mediumint(8) unsigned | NO | '0' | Data field One for the condition. | ||
value2 | mediumint(8) unsigned | NO | '0' | Data field Two for the condition. |
Description of the fields
'condition_entry' mediumint(8) unsigned
Identifier
'type' tinyint(3)
Type of the condition:
ID | Type | Description |
-3 | CONDITION_NOT | Used to evaluate if another condition is NOT true. |
-2 | CONDITION_OR | Used to evaluate if condition OR condition is true. |
-1 | CONDITION_AND | Used to evaluate if condition AND condition is true. |
0 | CONDITION_NONE | This condition is not used at all. |
1 | CONDITION_AURA | Checks target currently has the specified aura on him/her. |
2 | CONDITION_ITEM | Checks if the player has the required amount (value2) of items in his/hers inventory. |
3 | CONDITION_ITEM_EQUIPPED | Checks if the player has the specified item equipped. |
4 | CONDITION_AREAID | Checks if the player is within the specified area. |
5 | CONDITION_REPUTATION_RANK_MIN | Checks if the player has the minimum required reputation rank with a specific faction. |
6 | CONDITION_TEAM | Checks what team the target is a member of. |
7 | CONDITION_SKILL | Checks if the player has the required minimum skill value of the specified skill. |
8 | CONDITION_QUESTREWARDED | Checks if the player has been rewarded for the specified quest. |
9 | CONDITION_QUESTTAKEN | Checks if the player has taken the quest (as in has it in his/hers quest log.) |
10 | CONDITION_AD_COMMISSION_AURA | TODO |
11 | CONDITION_NO_AURA | Checks if the target DOES NOT currently have the specified aura on him/her. |
12 | CONDITION_ACTIVE_GAME_EVENT | Checks if a game event is currently active. |
13 | CONDITION_AREA_FLAG | Checks if area_flag is present in current area (if area_flag set != 0) AND if not_have_flag is not present in current area (if not_have_flag != 0) |
14 | CONDITION_RACE_CLASS | Checks if the target is a certain race AND/OR class. |
15 | CONDITION_LEVEL | Checks the targets level. |
16 | CONDITION_NOITEM | Checks if the player DOES NOT have the required amount (value2) of items in his/hers inventory. |
17 | CONDITION_SPELL | Checks if the target has or hasn’t (value2) the specified spell. |
18 | CONDITION_INSTANCE_SCRIPT | TODO |
19 | CONDITION_QUESTAVAILABLE | Checks if the specified quest is available (can start it) for the player. |
20 | CONDITION_RESERVED_1 | Reserved for later usage |
21 | CONDITION_RESERVED_2 | Reserved for later usage |
22 | CONDITION_QUEST_NONE | Checks if the player has NOT taken the quest AND has NOT been rewarded for the quest. |
23 | CONDITION_ITEM_WITH_BANK | Checks if the player has the required amount (value2) of items in his/hers inventory OR bank. |
24 | CONDITION_NOITEM_WITH_BANK | Checks if the player DOES NOT have count (value2) of items in his/hers inventory OR bank. |
25 | CONDITION_NOT_ACTIVE_GAME_EVENT | Checks if a game event is currently NOT active. |
26 | CONDITION_ACTIVE_HOLIDAY | Checks if a holiday is active |
27 | CONDITION_NOT_ACTIVE_HOLIDAY | Checks if a holiday is not active |
28 | CONDITION_LEARNABLE_ABILITY | Checks if the player can learn ability (using minimum skill value from SkillLineAbility.dbc.) If the player has spell or has item (when defined) the condition will evaluate to false. |
29 | CONDITION_SKILL_BELOW | TODO |
30 | CONDITION_REPUTATION_RANK_MAX | Checks if the player has a higher reputation rank than specified a faction. |
31 | CONDITION_RESERVED_3 | Reserved for later usage |
32 | CONDITION_SOURCE_AURA | Checks if the source of the condition (like looted npc) has an aura. |
33 | CONDITION_LAST_WAYPOINT | Checks the waypoint-state of the source of the condition. |
34 | CONDITION_RESERVED_4 | Reserved for later usage |
35 | CONDITION_GENDER | Checks the gender of a player. |
36 | CONDITION_DEAD_OR_AWAY | Checks if a player, a player's group, all players in an instance, or a creature is dead or left the map. |
37 | CONDITION_CREATURE_IN_RANGE | Checks if the creature (alive) is in the defined range. |
38 | CONDITION_GAMEOBJECT_IN_RANGE | Checks if the gameobject is in the range. |
'value1' mediumint(8) unsigned
Data field One for the condition.
'value2' mediumint(8) unsigned
Data field Two for the condition.
Condition Types:
ID | Type | Description |
-3 | CONDITION_NOT | Used to evaluate if another condition is NOT true. |
-2 | CONDITION_OR | Used to evaluate if condition OR condition is true. |
-1 | CONDITION_AND | Used to evaluate if condition AND condition is true. |
0 | CONDITION_NONE | This condition is not used at all. |
1 | CONDITION_AURA | Checks target currently has the specified aura on him/her. |
2 | CONDITION_ITEM | Checks if the player has the required amount (value2) of items in his/hers inventory. |
3 | CONDITION_ITEM_EQUIPPED | Checks if the player has the specified item equipped. |
4 | CONDITION_AREAID | Checks if the player is within the specified area. |
5 | CONDITION_REPUTATION_RANK_MIN | Checks if the player has the minimum required reputation rank with a specific faction. |
6 | CONDITION_TEAM | Checks what team the target is a member of. |
7 | CONDITION_SKILL | Checks if the player has the required minimum skill value of the specified skill. |
8 | CONDITION_QUESTREWARDED | Checks if the player has been rewarded for the specified quest. |
9 | CONDITION_QUESTTAKEN | Checks if the player has taken the quest (as in has it in his/hers quest log.) |
10 | CONDITION_AD_COMMISSION_AURA | TODO |
11 | CONDITION_NO_AURA | Checks if the target DOES NOT currently have the specified aura on him/her. |
12 | CONDITION_ACTIVE_GAME_EVENT | Checks if a game event is currently active. |
13 | CONDITION_AREA_FLAG | Checks if area_flag is present in current area (if area_flag set != 0) AND if not_have_flag is not present in current area (if not_have_flag != 0) |
14 | CONDITION_RACE_CLASS | Checks if the target is a certain race AND/OR class. |
15 | CONDITION_LEVEL | Checks the targets level. |
16 | CONDITION_NOITEM | Checks if the player DOES NOT have the required amount (value2) of items in his/hers inventory. |
17 | CONDITION_SPELL | Checks if the target has or hasn’t (value2) the specified spell. |
18 | CONDITION_INSTANCE_SCRIPT | TODO |
19 | CONDITION_QUESTAVAILABLE | Checks if the specified quest is available (can start it) for the player. |
20 | CONDITION_RESERVED_1 | Reserved for later usage |
21 | CONDITION_RESERVED_2 | Reserved for later usage |
22 | CONDITION_QUEST_NONE | Checks if the player has NOT taken the quest AND has NOT been rewarded for the quest. |
23 | CONDITION_ITEM_WITH_BANK | Checks if the player has the required amount (value2) of items in his/hers inventory OR bank. |
24 | CONDITION_NOITEM_WITH_BANK | Checks if the player DOES NOT have count (value2) of items in his/hers inventory OR bank. |
25 | CONDITION_NOT_ACTIVE_GAME_EVENT | Checks if a game event is currently NOT active. |
26 | CONDITION_ACTIVE_HOLIDAY | Checks if a holiday is active |
27 | CONDITION_NOT_ACTIVE_HOLIDAY | Checks if a holiday is not active |
28 | CONDITION_LEARNABLE_ABILITY | Checks if the player can learn ability (using minimum skill value from SkillLineAbility.dbc.) If the player has spell or has item (when defined) the condition will evaluate to false. |
29 | CONDITION_SKILL_BELOW | TODO |
30 | CONDITION_REPUTATION_RANK_MAX | Checks if the player has a higher reputation rank than specified a faction. |
31 | CONDITION_RESERVED_3 | Reserved for later usage |
32 | CONDITION_SOURCE_AURA | Checks if the source of the condition (like looted npc) has an aura. |
33 | CONDITION_LAST_WAYPOINT | Checks the waypoint-state of the source of the condition. |
34 | CONDITION_RESERVED_4 | Reserved for later usage |
35 | CONDITION_GENDER | Checks the gender of a player. |
36 | CONDITION_DEAD_OR_AWAY | Checks if a player, a player's group, all players in an instance, or a creature is dead or left the map. |
37 | CONDITION_CREATURE_IN_RANGE | Checks if the creature (alive) is in the defined range. |
38 | CONDITION_GAMEOBJECT_IN_RANGE | Checks if the gameobject is in the range. |