Wiki: Wiki

achievement_criteria_requirement

Tue, 04 Feb 2020 08:56:51 +0000

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 'achievement_criteria_requirement' table for MaNGOSFour

This table contains what needs to be done to complete an achievement criteria.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Field Name	Field Type	Nullable	Key	Default Value	Notes
criteria_id	mediumint(8)	NO	PRI	NULL	Matching ID from achievement_criteria.dbc
type	tinyint(3) unsigned	NO	PRI	'0'	The Type of Criteria
value1	mediumint(8) unsigned	NO		'0'
value2	mediumint(8) unsigned	NO		'0'

Description of the fields

criteria_id mediumint(8)

Column 0 (ID) of [See achievement_criteria.dbc] This DBC contains the achievement_id on 2nd column and will be later extracted to show relations.

type tinyint(3) unsigned

The Type of Criteria

Type Id	Critieria Name	Value1	Value2
0	TYPE_NONE
1	TYPE_T_CREATURE	Target creature_template.entry
2	TYPE_T_PLAYER_CLASS_RACE	Target Player Class	Target Player Race
3	TYPE_T_PLAYER_LESS_HEALTH	Target Health percentage
4	TYPE_T_PLAYER_DEAD	Team value the source player and target dead player must both meet
5	TYPE_S_AURA	Spell Id	Effect Index
6	TYPE_S_AREA	Area Id from [See AreaTable.dbc]
7	TYPE_T_AURA	Spell Id	Effect Index
8	TYPE_VALUE	Min Value. Value provided with achievement update must be not less that limit
9	TYPE_T_LEVEL	Target Min Level
10	TYPE_T_GENDER	Gender: 0=Male, 1=Female
11	TYPE_DISABLED	Used to prevent achievement criteria to complete if not all requirements are implemented and listed in this table
12	TYPE_MAP_DIFFICULTY	Map Difficulty, Refer to Table Below
13	TYPE_MAP_PLAYER_COUNT	Count. For criteria 'with less than %u people in the zone'
14	TYPE_T_TEAM	Team: HORDE = 67, ALLIANCE = 469
15	TYPE_S_DRUNK	An entry from the Drunken State table below
16	TYPE_HOLIDAY	Holiday ID which must be active from (See Holiday.dbc) and game_event
17	TYPE_BG_LOSS_TEAM_SCORE	min_score	max_score
18	TYPE_INSTANCE_SCRIPT	Make instance script call for check current criteria requirements fit
19	TYPE_S_EQUIPED_ITEM_LVL	Item Level	Item Quality
20	TYPE_REQUIRE_NTH_BIRTHDAY	nth-birthday
21	TYPE_REQUIRE_KNOWN_TITLE	title_id

Map Difficulty Table

Description	Value
DUNGEON_DIFFICULTY_NORMAL	0
DUNGEON_DIFFICULTY_HEROIC	1
RAID_DIFFICULTY_10MAN_NORMAL	0
RAID_DIFFICULTY_25MAN_NORMAL	1
RAID_DIFFICULTY_10MAN_HEROIC	2
RAID_DIFFICULTY_25MAN_HEROIC	3

Drunken State Table

Drunken Name	Value
DRUNKEN_SOBER	0
DRUNKEN_TIPSY	1
DRUNKEN_DRUNK	2
DRUNKEN_SMASHED	3

value1 mediumint(8) unsigned

The meaning of this field is based on the Type, see the table above.

value2 mediumint(8) unsigned

The meaning of this field is based on the Type, see the table above.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Mangos Four Mangos DB Information coming soon

Tue, 02 Aug 2016 22:20:33 +0000

Mangos Four Mangos DB Information coming soon

spell_area

Tue, 04 Feb 2020 08:54:15 +0000

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 'spell_area' table for MaNGOSFour

This table holds information on what spells are applied to npcs/players in some areas.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Field Name	Field Type	Nullable	Key	Default Value	Notes
spell	mediumint(8) unsigned	NO	PRI	'0'	Spell ID [See Spell.dbc].
area	mediumint(8) unsigned	NO	PRI	'0'	Area ID [See AreaTable.dbc].
quest_start	mediumint(8) unsigned	NO	PRI	'0'	Quest ID [See quest_template.entry].
quest_start_active	tinyint(1) unsigned	NO	PRI	'0'	Flag for quest_start.
quest_end	mediumint(8) unsigned	NO		'0'	Quest ID [See quest_template.entry].
condition_id	mediumint(8) unsigned	NO		'0'	Condition ID [See conditions.condition_entry].
aura_spell	mediumint(8)	NO	PRI	'0'	Spell ID [See Spell.dbc].
racemask	mediumint(8) unsigned	NO	PRI	'0'	Race mask value.
gender	tinyint(1) unsigned	NO	PRI	'2'	The gender of characters to which the spell is applied.
autocast	tinyint(1) unsigned	NO		'0'	Autocast flag.

Description of the fields

spell mediumint(8) unsigned

Spell ID, see Spell.dbc. The spell is either cast on the character or allows the character to cast.

area mediumint(8) unsigned

Area ID, see AreaTable.dbc. If equals to 0, is not limited to any zone.

quest_start mediumint(8) unsigned

Quest ID [See quest_template.entry] that should be either active or rewarded.

quest_start_active tinyint(1) unsigned

If set, this flag allows the quest mentioned in the quest_start field to be rewarded, not only be active.

quest_end mediumint(8) unsigned

Quest ID [See quest_template.entry] of the quest that should not be rewarded.

condition_id mediumint(8) unsigned

Condition ID [See conditions.condition_entry] of the condition which should be fulfilled.

aura_spell mediumint(8)

Spell ID [See Spell.dbc] of the aura spell which the character should already have applied (if positive) or do not have (if negative).

racemask mediumint(8) unsigned

Race mask value. The entries may be combined by simple adding.

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

gender tinyint(1) unsigned

The gender of characters to which the spell is applied. The following table list available values.

Gender of the creature

Value	Gender
0	Male
1	Female
2	Both

autocast tinyint(1) unsigned

If set, this flag requires the spell to be cast on the character as they enter the area. If unset, the spell is enabled for the character to cast.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module