AzerothCore
Pages :
Important: As of 19/09/24 all versions of MariaDB, MySQL 5.7 and 8.1 will no longer be supported. Consider upgrading to MySQL 8.0 or 8.4.
dungeon_access_requirements
The `dungeon_access_requirements` table
Table Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| dungeon_access_id | TINYINT | UNSIGNED | PRI | NO | |||
| requirement_type | TINYINT | UNSIGNED | PRI | NO | |||
| requirement_id | MEDIUMINT | UNSIGNED | PRI | NO | |||
| requirement_note | VARCHAR(255) | YES | NULL | ||||
| faction | TINYINT | UNSIGNED | NO | 2 | |||
| priority | TINYINT | UNSIGNED | YES | NULL | |||
| leader_only | TINYINT | SIGNED | NO | 0 | |||
| comment | VARCHAR(255) | YES | NULL |
Description of the fields
dungeon_access_id
ID from dungeon_access_template.id.
requirement_type
| Value | Type | Comment |
|---|---|---|
| 0 | Achievement | |
| 1 | Quest | |
| 2 | Item | The item cannot be in the bank. |
requirement_id
ID for Achievement, Quest or Item depending on chosen requirement_type.
requirement_note
The text that is shown if you try and enter the instance without meeting the requirements.
faction
| Value | Comment |
|---|---|
| 0 | Alliance |
| 1 | Horde |
| 2 | Both |
priority
Priority order for the requirement, sorted by type. 0 is the highest priority.
leader_only
0 = Check the requirement for each player trying to enter.
1 = Only check the requirement for the party leader.