NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. |
Description of the 'conditions' table for MaNGOSZero
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
areatrigger_teleport
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. | ||
comments | varchar(200) | YES | {Blank String} |
Detailed description of available condition types The meaning of the values |
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. See Note 1 |
-2 | CONDITION_OR | Used to evaluate if condition OR condition is true. See Note 1 |
-1 | CONDITION_AND | Used to evaluate if condition AND condition is true. See Note 1 |
0 | CONDITION_NONE | This condition is not used at all. Always returns true. |
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/zone. |
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 (Alliance or Horde). |
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 complete the specified quest. |
9 | CONDITION_QUESTTAKEN | Checks if the player has taken the quest (as in has it in his/hers quest log.) and not completed it yet. |
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 | SD3 based condition |
19 | CONDITION_QUESTAVAILABLE | Checks if the specified quest is available (can start it) for the player. |
20 | CONDITION_ACHIEVEMENT | Has or has no special achievement. |
21 | CONDITION_ACHIEVEMENT_REALM | Realm wide achievement (like 20 above but realm wide). |
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 [See 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_COMPLETED_ENCOUNTER | Checks if an encounter has been completed. |
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_XP_USER | Checks if a player has turned XP earning on/off |
35 | CONDITION_GENDER | Checks the gender of a player. |
36 | CONDITION_DEAD_OR_AWAY | TODO |
37 | CONDITION_CREATURE_IN_RANGE | TODO |
38 | CONDITION_PVP_SCRIPT | TODO |
39 | CONDITION_SPAWN_COUNT | Returns if specified count of creature entry exists on map. |
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. |
Note 1:
Meta-Condition types CONDITION_AND (-1) and CONDITION_OR (-2) which are used as: value1 (as condition_entry) AND / OR value2 (as condition_entry). With these meta-conditions it is possible to create tree like and very complicated combined conditions (like HasAura && (HasItem || HasQuest))
value1 mediumint(8) unsigned
Data field One for the condition.
value2 mediumint(8) unsigned
Data field Two for the condition.
comments varchar(200)
Detailed description of available condition types
The meaning of the values in value1 / value2 depend of the type of the condition
Value | CONDITION_TYPE Name | Value1 | Value2 | Notes & Return value |
---|---|---|---|---|
-3 | CONDITION_NOT | condition_entry |
Must have higher condition_entry than value1 Returns NOT condition (of value1) |
|
-2 | CONDITION_OR | condition_entry | condition_entry |
Must have higher condition_entry than value1 OR value2 Returns condition (of value1) OR condition (of value2) |
-1 | CONDITION_AND | condition_entry | condition_entry |
Must have higher condition_entry than value1 OR value2 Returns condition (of value1) AND condition (of value2) |
0 | CONDITION_NONE |
No condition, is always met True |
||
1 | CONDITION_AURA | The spell ID from where the aura came from. | The effect index of the spell that applied the aura (0, 1, or 2) | Returns if a player has an aura |
2 | CONDITION_ITEM | Item ID | Count | Returns if a player has Count items in his inventory |
3 | CONDITION_ITEM_EQUIPPED | Item ID | Returns if a player has an item equipped | |
4 | CONDITION_AREAID | Area ID | 0, 1 (0: in (sub)area, 1: not in (sub)area) | Returns if (or if not depending on value2) a player is in an area/zone |
5 | CONDITION_REPUTATION_RANK_MIN | Faction ID | Minimum rank | Returns if a player has at least (>=) minimum rank at the given faction. See Ranks below. |
6 | CONDITION_TEAM | Player team (469 - Alliance, 67 - Horde) | Returns if a player has the team of value1 | |
7 | CONDITION_SKILL | Skill ID [See SkillLine.dbc] | Skill value needed | Returns if a player has Skill ID of value |
8 | CONDITION_QUESTREWARDED | Quest ID | Returns if a player already got a quest rewarded | |
9 | CONDITION_QUESTTAKEN | Quest ID | 0,1 or 2 |
0 - Returns true if quest is taken, no matter if completed or not 1 - Returns true if quest is taken but not completed 2 - Returns true if quest is taken and completed |
10 | CONDITION_AD_COMMISSION_AURA | Returns if a Player has any Argent Dawn Commission Aura Active (17670,23930,24198,29112,29113) | ||
11 | CONDITION_NO_AURA | spellid | EffectIndex | Returns if a player has not an aura |
12 | CONDITION_ACTIVE_EVENT | event | Returns if a event is active | |
13 | CONDITION_AREA_FLAG | area_flag | not_have_flag | Returns 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 | race_mask | class_mask | Returns if a player is of race (if race_mask set != 0) AND if a player is of class (if class_mask != 0) See Races & Classes below. |
15 | CONDITION_LEVEL | level | 0,1 or 2 |
0: equal to 1: equal or higher than 2: equal or less than Returns if a player is of/ has a higher/ has a lower level |
16 | CONDITION_NOITEM | itemid | count | Returns if a player has not count items in Inventory |
17 | CONDITION_SPELL | spellid | 0,1 |
0: has spell 1: does not have spell Returns if a player has (not) learned a spell. |
18 | CONDITION_INSTANCE_SCRIPT | instance_condition_id |
see InstanceData.h enum InstanceConditionIDs To 'communicate' with the instance script, there are a few instance_condition_id predefined, which can be used for hard-mode loot (0: normal, 1: Hard, 2: Harder mode), review the Instance conditions table below. Returns the result of the current instance's instance-script function CheckConditionCriteriaMeet (which must be implemented for such an instance) |
|
19 | CONDITION_QUESTAVAILABLE | questid | Returns if a player could start a quest (ie. if all requirements for accepting like pre-quests are met) | |
20 | CONDITION_ACHIEVEMENT | achievementid | 0,1 |
0: has achievement 1: has no achievement Returns if a player has (not) earned an achievement |
21 | CONDITION_ACHIEVEMENT_REALM | achievementid | 0,1 |
0: has achievement 1: has no achievement Returns if an achivement was (not) already earned by any player on the realm |
22 | CONDITION_QUEST_NONE | questid | Returns if a player has a quest neither taken nor ever rewarded | |
23 | CONDITION_ITEM_WITH_BANK | item_id | count | Returns if a player has at least count of items (including inventory stored in the bank) |
24 | CONDITION_NOITEM_WITH_BANK | item_id | count | Returns if a player has less than count of items (including inventory stored in the bank) |
25 | CONDITION_NOT_ACTIVE_GAME_EVENT | event_id | Returns if a game event is not active. | |
26 | CONDITION_ACTIVE_HOLIDAY | holiday_id | Returns if a holiday is active. | |
27 | CONDITION_NOT_ACTIVE_HOLIDAY | holiday_id | Returns if a holiday is not active. | |
28 | CONDITION_LEARNABLE_ABILITY | spell_id | 0 or item_id |
Returns player can learn ability using min skill value from (See SkillLineAbility.dbc). Item_id can be defined in addition, to check if player has one (1) item in inventory or bank. When player has spell or has item (when defined), condition return false. |
29 | CONDITION_SKILL_BELOW | skill_id | skill_value |
Returns if player has skill skill_id and skill less than (and not equal) skill_value (for skill_value > 1) If skill_value == 1, then true if player does not have skill skill_id |
30 | CONDITION_REPUTATION_RANK_MAX | faction_id | max_rank |
refer to the Ranks table below. Returns if a player has at most (<=) max_rank with a faction |
31 | CONDITION_COMPLETED_ENCOUNTER | encounter_id (See DungeonEncounter.dbc#id) | encounter_id2 (See DungeonEncounter.dbc#id) | Returns if encounter_id is complete (if encounter_id2 provided it will return if encounter_id is completed OR if encounter_id2 is completed) |
32 | CONDITION_SOURCE_AURA | spell_id | effindex | Returns true if the source of the condition check has aura of spell_id, effIndex |
33 | CONDITION_LAST_WAYPOINT | waypointId | 0,1 or 2 |
0 = exact 1: wp <= waypointId 2: wp > waypointId Returns if the source of the condition is on/ has reached/ has passed a waypoint |
34 | CONDITION_XP_USER | 0, 1 |
0: XP off, 1: XP on Returns if a player has his XP earning turned off/on |
|
35 | CONDITION_GENDER | 0,1 or 2 |
0 = male, 1 = female, 2 = none (See enum Gender) Returns if a player is male or female (none cannot happen) |
|
36 | CONDITION_DEAD_OR_AWAY | 0,1,2 or 3 | optional_range |
0=player dead, 1=player is dead (with group dead), 2=player in instance are dead, 3=creature is dead Returns if a player / a player's group / all players in an instance / or a creature is dead or left the map. If the optional_range is provided the condition will also fail if the player[s] are out of range |
37 | CONDITION_CREATURE_IN_RANGE | creatureEntry | range | Returns if the creature of the given entry is found in the given range |
38 | CONDITION_PVP_SCRIPT | area_id of the outdoor PvP script | opvp_condition_id (defined in the actual script) | Returns the result of the outdoor PvP script function IsConditionFulfilled (which must be implemented for the required scripts) |
39 | CONDITION_SPAWN_COUNT | creature_template.entry | Minimum amount of specified creature to exist on map for condition to return true |
Condition returns true if there are more than or equal amounts of creature on map. Note: The creature specified in value1 must have ExtraFlags CREATURE_EXTRA_FLAG_COUNT_SPAWNS set! |
Ranks
Name | Value |
---|---|
REP_HATED | 0 |
REP_HOSTILE | 1 |
REP_UNFRIENDLY | 2 |
REP_NEUTRAL | 3 |
REP_FRIENDLY | 4 |
REP_HONORED | 5 |
REP_REVERED | 6 |
REP_EXALTED | 7 |
Races
Race | Mask Value (hex) | Mask Value (dec) |
---|---|---|
Human | 0x1 | 1 |
Orc | 0x2 | 2 |
Dwarf | 0x4 | 4 |
Night Elf | 0x8 | 8 |
Undead | 0x10 | 16 |
Tauren | 0x20 | 32 |
Gnome | 0x40 | 64 |
Troll | 0x80 | 128 |
Goblin | 0x100 | 256 |
Blood Elf | 0x200 | 512 |
Dranei | 0x400 | 1024 |
Classes
Class | Value (hex) | Value (dec) |
---|---|---|
CLASS_WARRIOR | 0x1 | 1 |
CLASS_PALADIN | 0x2 | 2 |
CLASS_HUNTER | 0x4 | 4 |
CLASS_ROGUE | 0x8 | 8 |
CLASS_PRIEST | 0x10 | 16 |
CLASS_DEATHKNIGHT | 0x20 | 32 |
CLASS_SHAMAN | 0x40 | 64 |
CLASS_MAGE | 0x80 | 128 |
CLASS_WARLOCK | 0x100 | 256 |
CLASS_DRUID | 0x400 | 1024 |
Instance Conditions
Condition Name | Value | Notes |
---|---|---|
INSTANCE_CONDITION_ID_NORMAL_MODE | 0 | |
INSTANCE_CONDITION_ID_HARD_MODE | 1 | |
INSTANCE_CONDITION_ID_HARD_MODE_2 | 2 | |
INSTANCE_CONDITION_ID_HARD_MODE_3 | 3 | |
INSTANCE_CONDITION_ID_HARD_MODE_4 | 4 | |
INSTANCE_CONDITION_ID_TEAM_HORDE | 67 | To check for which team the instance is doing scripts |
INSTANCE_CONDITION_ID_TEAM_ALLIANCE | 469 | To check for which team the instance is doing scripts |
auto-generated by the getMaNGOS.eu MAGNET dbdocs module
Edited by Antz
Recommended Comments
There are no comments to display.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now