AzerothCore
Posts (Latest 10 updated) :
Read all

access_requirement

<-Back-to:World

The `access_requirement` table

This table contains the access requirements to enter an instance.

Structure

Field

Type

Attributes

Key

Null

Default

Extra

Comment

mapId

mediumint (8)

unsigned

PRI

NO

NULL



difficulty

tinyint(3)

unsigned

PRI

NO

0



level_min

tinyint(3)

unsigned


NO

0



level_max

tinyint(3)

unsigned


NO

0



item_level smallint(5) unsigned
NO 0

item

mediumint(8)

unsigned


NO

0



item2

mediumint(8)

unsigned


NO

0



quest_done_A

mediumint(8)

unsigned


NO

0



quest_done_H

mediumint(8)

unsigned


NO

0



completed_achievement

mediumint(8)

unsigned


NO

0



quest_failed_text

text

signed


YES

NULL



comment

text

signed


YES

NULL



Description of the fields

mapId

This is the access_id field from the instance_template table. It is an arbitrary number that merely links the requirements to an instance_template, or areatrigger_teleport

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 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.