summaryrefslogtreecommitdiff
path: root/docs/dungeon_access_template.md
diff options
context:
space:
mode:
authorKitzunu <24550914+Kitzunu@users.noreply.github.com>2021-05-01 12:28:31 +0200
committerGitHub <noreply@github.com>2021-05-01 12:28:31 +0200
commite12fb303c30fcbf83df7197b433beba44171d682 (patch)
tree8a6aae921b54592c55abe608b854d4d314920a5c /docs/dungeon_access_template.md
parent29b1eb3ed30e0dd50ba1cfe222a33b070e3e6e0b (diff)
downloadwiki-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.md65
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