access_requirement

This table contains the access requirements to enter an instance.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
mapId	int	unsigned	PRI	NO
difficulty	tinyint	unsigned	PRI	NO	0
level_min	tinyint	unsigned		NO	0
level_max	tinyint	unsigned		NO	0
item_level	smallint	unsigned		NO	0
item	int	unsigned		NO	0
item2	int	unsigned		NO	0
quest_done_A	int	unsigned		NO	0
quest_done_H	int	unsigned		NO	0
completed_achievement	int	unsigned		NO	0
quest_failed_text	mediumtext			YES	NULL
comment	mediumtext			YES	NULL

Description of fields

mapId

The Map ID of the instance.  

difficulty

5 man dungeons - 0 for normal, 1 for heroic, 2 for epic (not used yet) 10 man dungeons - 0 for normal, 2 for heroic 25 man dungeons - 1 for normal, 3 for heroic  

level_min

The minimum level that you must be in order to enter the instance.  

level_max

The maximum level that you can be in order to enter the instance.  

item_level

The at least required item level for a 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.  

item

An item that you must have in your inventory to enter the instance. This item can not be in the bank.  

item2

A second item that you must have in your inventory. This item can not be in the bank.  

quest_done_A

A quest that you must have completed. This field is only for alliance.  

quest_done_H

A quest that you must have completed. This field is only for horde.  

completed_achievement

An Achievement ID that must be completed by the player to enter an instance.  

quest_failed_text

The text that is shown if you try and enter the instance without having completed the quest.  

comment

This field is for any comment you want to make about the requirements. It is arbitrary text.