dungeon_access_template

The `dungeon_access_template` table

Structure

Field	Type	Attributes	Key	Null	Default	Extra
id	TINYINT	UNSIGNED	PRI	NO		AUTO_INCREMENT
map_id	MEDIUMINT	UNSIGNED	KEY	NO		FK_dungeon_access_template__instance_template
difficulty	TINYINT	UNSIGNED		NO	0
min_level	TINYINT	UNSIGNED		YES	NULL
max_level	TINYINT	UNSIGNED		YES	NULL
min_avg_item_level	SMALLINT	UNSIGNED		YES	NULL
comment	VARCHAR(255)			YES	NULL

Description of the fields

id

The dungeon template ID

map_id

Map ID from instance_template.map.

difficulty

5 man: 0 = normal, 1 = heroic, 2 = epic (Mythic, not implemented in 3.3.5)
10 man: 0 = normal, 2 = heroic
25 man: 1 = normal, 3 = heroic

min_level

The minimum level you must be to enter the instance.

max_level

The maximum level you can be to enter the instance.

min_avg_item_level

Min average ilvl required to enter the instance.

All WotLK Heroics require at least an average item level of 180.
Trial of the Champion, Pit of Saron, and the Forge of Souls require an average item level of 200.
Halls of Reflection requires an average item level of 219.

Note: this requirement only applies to the Dungeon Finder and the Raid Browser, not to a dungeon/raid portal (and it's blizzlike). This also means a guild could try to clear a raid while being undergeared :)

目录