dungeon_access_template
The `dungeon_access_template` table
Table Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| 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 😃