conditions

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

Sign In

Categories

conditions

Description of the 'conditions' table for MaNGOSZero

User Feedback

Recommended Comments

Create an account or sign in to comment

Create an account

Sign in

Recently Browsing 0 members

Contact Us

Repositories

Support

Wiki

Browse

Activity

My Activity Streams

Important Information