diff options
| author | Kitzunu <24550914+Kitzunu@users.noreply.github.com> | 2021-05-01 12:28:31 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-05-01 12:28:31 +0200 |
| commit | e12fb303c30fcbf83df7197b433beba44171d682 (patch) | |
| tree | 8a6aae921b54592c55abe608b854d4d314920a5c /docs/dungeon_access_template.md | |
| parent | 29b1eb3ed30e0dd50ba1cfe222a33b070e3e6e0b (diff) | |
| download | wiki-e12fb303c30fcbf83df7197b433beba44171d682.tar.gz wiki-e12fb303c30fcbf83df7197b433beba44171d682.tar.bz2 wiki-e12fb303c30fcbf83df7197b433beba44171d682.zip | |
fix(docs): Add dungeon requirement tables (#450)
* fix(docs): Add dungeon requirement tables
* Update dungeon_access_template.md
* make it more clear
* Update dungeon_access_requirements.md
* Update dungeon_access_template.md
Diffstat (limited to 'docs/dungeon_access_template.md')
| -rw-r--r-- | docs/dungeon_access_template.md | 65 |
1 files changed, 65 insertions, 0 deletions
diff --git a/docs/dungeon_access_template.md b/docs/dungeon_access_template.md new file mode 100644 index 0000000..b271dc6 --- /dev/null +++ b/docs/dungeon_access_template.md @@ -0,0 +1,65 @@ +# dungeon\_access\_template + +[<-Back-to:World](database-world.md) + +**The \`dungeon\_access\_template\` table** + +**Structure** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------------------------|--------------|------------|-----|------|---------|-----------------------------------------------|---------| +| [id][1] | TINYINT | UNSIGNED | PRI | NO | | AUTO_INCREMENT | | +| [map_id][2] | MEDIUMINT | UNSIGNED | KEY | NO | | FK_dungeon_access_template__instance_template | | +| [difficulty][3] | TINYINT | UNSIGNED | | NO | 0 | | | +| [min_level][4] | TINYINT | UNSIGNED | | YES | NULL | | | +| [max_level][5] | TINYINT | UNSIGNED | | YES | NULL | | | +| [min_avg_item_level][6] | SMALLINT | UNSIGNED | | YES | NULL | | | +| [comment][7] | VARCHAR(255) | | | YES | NULL | | | + +[1]: #id +[2]: #map_id +[3]: #difficulty +[4]: #min_level +[5]: #max_level +[6]: #min_avg_item_level +[7]: #comment + +**Description of the fields** + +### id + +The dungeon template ID + +### map_id + +Map ID from [instance_template.map](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 :) + +### comment |
