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

enum Difficulty

Value	Name
0	RAID_DIFFICULTY_10MAN_NORMAL / DUNGEON_DIFFICULTY_NORMAL / REGULAR_DIFFICULTY
1	RAID_DIFFICULTY_25MAN_NORMAL / DUNGEON_DIFFICULTY_HEROIC
2	RAID_DIFFICULTY_10MAN_HEROIC
3	RAID_DIFFICULTY_25MAN_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 minimum average item level required to enter

• 219 for Halls of Reflection.
• 200 for Trial of the Champion, Pit of Saron and The Forge of Souls.
• 180 for all other WotLK Heroic Dungeons.
   

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.