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 NameField TypeNullableKeyDefault ValueAttributesNotes
condition_entrymediumint(8) unsignedNOPRINULL‘auto_increment’Identifier
typetinyint(3)NOMUL‘0’ Type of the condition.
value1mediumint(8) unsignedNO ‘0’ Data field One for the condition.
value2mediumint(8) unsignedNO ‘0’ Data field Two for the condition.

Description of the fields

‘condition_entry’ mediumint(8) unsigned

Identifier

‘type’ tinyint(3)

Type of the condition:

IDTypeDescription
-3CONDITION_NOTUsed to evaluate if another condition is NOT true.
-2CONDITION_ORUsed to evaluate if condition OR condition is true.
-1CONDITION_ANDUsed to evaluate if condition AND condition is true.
0CONDITION_NONEThis condition is not used at all.
1CONDITION_AURAChecks target currently has the specified aura on him/her.
2CONDITION_ITEMChecks if the player has the required amount (value2) of items in his/hers inventory.
3CONDITION_ITEM_EQUIPPEDChecks if the player has the specified item equipped.
4CONDITION_AREAIDChecks if the player is within the specified area.
5CONDITION_REPUTATION_RANK_MINChecks if the player has the minimum required reputation rank with a specific faction.
6CONDITION_TEAMChecks what team the target is a member of.
7CONDITION_SKILLChecks if the player has the required minimum skill value of the specified skill.
8CONDITION_QUESTREWARDEDChecks if the player has been rewarded for the specified quest.
9CONDITION_QUESTTAKENChecks if the player has taken the quest (as in has it in his/hers quest log.)
10CONDITION_AD_COMMISSION_AURATODO
11CONDITION_NO_AURAChecks if the target DOES NOT currently have the specified aura on him/her.
12CONDITION_ACTIVE_GAME_EVENTChecks if a game event is currently active.
13CONDITION_AREA_FLAGChecks 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)
14CONDITION_RACE_CLASSChecks if the target is a certain race AND/OR class.
15CONDITION_LEVELChecks the targets level.
16CONDITION_NOITEMChecks if the player DOES NOT have the required amount (value2) of items in his/hers inventory.
17CONDITION_SPELLChecks if the target has or hasn’t (value2) the specified spell.
18CONDITION_INSTANCE_SCRIPTTODO
19CONDITION_QUESTAVAILABLEChecks if the specified quest is available (can start it) for the player.
20CONDITION_RESERVED_1Reserved for later usage
21CONDITION_RESERVED_2Reserved for later usage
22CONDITION_QUEST_NONEChecks if the player has NOT taken the quest AND has NOT been rewarded for the quest.
23CONDITION_ITEM_WITH_BANKChecks if the player has the required amount (value2) of items in his/hers inventory OR bank.
24CONDITION_NOITEM_WITH_BANKChecks if the player DOES NOT have count (value2) of items in his/hers inventory OR bank.
25CONDITION_NOT_ACTIVE_GAME_EVENTChecks if a game event is currently NOT active.
26CONDITION_ACTIVE_HOLIDAYChecks if a holiday is active
27CONDITION_NOT_ACTIVE_HOLIDAYChecks if a holiday is not active
28CONDITION_LEARNABLE_ABILITYChecks 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.
29CONDITION_SKILL_BELOWTODO
30CONDITION_REPUTATION_RANK_MAXChecks if the player has a higher reputation rank than specified a faction.
31CONDITION_RESERVED_3Reserved for later usage
32CONDITION_SOURCE_AURAChecks if the source of the condition (like looted npc) has an aura.
33CONDITION_LAST_WAYPOINTChecks the waypoint-state of the source of the condition.
34CONDITION_RESERVED_4Reserved for later usage
35CONDITION_GENDERChecks the gender of a player.
36CONDITION_DEAD_OR_AWAYChecks if a player, a player’s group, all players in an instance, or a creature is dead or left the map.
37CONDITION_CREATURE_IN_RANGEChecks if the creature (alive) is in the defined range.
38CONDITION_GAMEOBJECT_IN_RANGEChecks 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:

IDTypeDescription
-3CONDITION_NOTUsed to evaluate if another condition is NOT true.
-2CONDITION_ORUsed to evaluate if condition OR condition is true.
-1CONDITION_ANDUsed to evaluate if condition AND condition is true.
0CONDITION_NONEThis condition is not used at all.
1CONDITION_AURAChecks target currently has the specified aura on him/her.
2CONDITION_ITEMChecks if the player has the required amount (value2) of items in his/hers inventory.
3CONDITION_ITEM_EQUIPPEDChecks if the player has the specified item equipped.
4CONDITION_AREAIDChecks if the player is within the specified area.
5CONDITION_REPUTATION_RANK_MINChecks if the player has the minimum required reputation rank with a specific faction.
6CONDITION_TEAMChecks what team the target is a member of.
7CONDITION_SKILLChecks if the player has the required minimum skill value of the specified skill.
8CONDITION_QUESTREWARDEDChecks if the player has been rewarded for the specified quest.
9CONDITION_QUESTTAKENChecks if the player has taken the quest (as in has it in his/hers quest log.)
10CONDITION_AD_COMMISSION_AURATODO
11CONDITION_NO_AURAChecks if the target DOES NOT currently have the specified aura on him/her.
12CONDITION_ACTIVE_GAME_EVENTChecks if a game event is currently active.
13CONDITION_AREA_FLAGChecks 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)
14CONDITION_RACE_CLASSChecks if the target is a certain race AND/OR class.
15CONDITION_LEVELChecks the targets level.
16CONDITION_NOITEMChecks if the player DOES NOT have the required amount (value2) of items in his/hers inventory.
17CONDITION_SPELLChecks if the target has or hasn’t (value2) the specified spell.
18CONDITION_INSTANCE_SCRIPTTODO
19CONDITION_QUESTAVAILABLEChecks if the specified quest is available (can start it) for the player.
20CONDITION_RESERVED_1Reserved for later usage
21CONDITION_RESERVED_2Reserved for later usage
22CONDITION_QUEST_NONEChecks if the player has NOT taken the quest AND has NOT been rewarded for the quest.
23CONDITION_ITEM_WITH_BANKChecks if the player has the required amount (value2) of items in his/hers inventory OR bank.
24CONDITION_NOITEM_WITH_BANKChecks if the player DOES NOT have count (value2) of items in his/hers inventory OR bank.
25CONDITION_NOT_ACTIVE_GAME_EVENTChecks if a game event is currently NOT active.
26CONDITION_ACTIVE_HOLIDAYChecks if a holiday is active
27CONDITION_NOT_ACTIVE_HOLIDAYChecks if a holiday is not active
28CONDITION_LEARNABLE_ABILITYChecks 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.
29CONDITION_SKILL_BELOWTODO
30CONDITION_REPUTATION_RANK_MAXChecks if the player has a higher reputation rank than specified a faction.
31CONDITION_RESERVED_3Reserved for later usage
32CONDITION_SOURCE_AURAChecks if the source of the condition (like looted npc) has an aura.
33CONDITION_LAST_WAYPOINTChecks the waypoint-state of the source of the condition.
34CONDITION_RESERVED_4Reserved for later usage
35CONDITION_GENDERChecks the gender of a player.
36CONDITION_DEAD_OR_AWAYChecks if a player, a player’s group, all players in an instance, or a creature is dead or left the map.
37CONDITION_CREATURE_IN_RANGEChecks if the creature (alive) is in the defined range.
38CONDITION_GAMEOBJECT_IN_RANGEChecks if the gameobject is in the range.

 

发表评论

您的电子邮箱地址不会被公开。 必填项已用*标注

Captcha Code