summaryrefslogtreecommitdiff
path: root/docs/access_requirement.md
diff options
context:
space:
mode:
Diffstat (limited to 'docs/access_requirement.md')
-rw-r--r--docs/access_requirement.md252
1 files changed, 236 insertions, 16 deletions
diff --git a/docs/access_requirement.md b/docs/access_requirement.md
index 9e5766f..7b386df 100644
--- a/docs/access_requirement.md
+++ b/docs/access_requirement.md
@@ -1,16 +1,236 @@
-[Database Structure](Database-Structure) > [World-Database](World-Database) > [access_requirement](access_requirement)
-
-Column | Type | Description
---- | --- | ---
-MapId | mediumint(8) unsigned |
-Difficulty | tinyint(3) unsigned |
-Level_min | tinyint(3) unsigned |
-Level_max | tinyint(3) unsigned |
-Item_level | smallint(5) unsigned |
-Item | mediumint(8) unsigned |
-Item2 | mediumint(8) unsigned |
-Quest_done_A | mediumint(8) unsigned |
-Quest_done_H | mediumint(8) unsigned |
-Completed_achievement | mediumint(8) unsigned |
-Quest_failed_text | text |
-Comment | text |
+# access\_requirement
+
+`Back-to:World`
+
+**The \`access\_requirement\` table**
+
+This table contains the access requirements to enter an instance.
+
+**Structure**
+
+<table>
+<tbody>
+<tr class="odd">
+<td><p><strong>Field</strong></p></td>
+<td><p><strong>Type</strong></p></td>
+<td><p><strong>Attributes</strong></p></td>
+<td><p><strong>Key</strong></p></td>
+<td><p><strong>Null</strong></p></td>
+<td><p><strong>Default</strong></p></td>
+<td><p><strong>Extra</strong></p></td>
+<td><p><strong>Comment</strong></p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#access_requirement335-mapId">mapId</a></p></td>
+<td><p>mediumint (8)</p></td>
+<td><p>unsigned</p></td>
+<td><p>PRI</p></td>
+<td><p>NO</p></td>
+<td><p>NULL</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#access_requirement335-difficulty">difficulty</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p>PRI</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#access_requirement335-level_min">level_min</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#access_requirement335-level_max">level_max</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><a href="#access_requirement335-item_level">item_level</a></td>
+<td>smallint(5)</td>
+<td>unsigned</td>
+<td><br />
+</td>
+<td>NO</td>
+<td>0</td>
+<td><br />
+</td>
+<td><br />
+</td>
+</tr>
+<tr class="odd">
+<td><p><a href="#access_requirement335-item">item</a></p></td>
+<td><p>mediumint(8)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#access_requirement335-item2">item2</a></p></td>
+<td><p>mediumint(8)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#access_requirement335-quest_done_A">quest_done_A</a></p></td>
+<td><p>mediumint(8)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#access_requirement335-quest_done_H">quest_done_H</a></p></td>
+<td><p>mediumint(8)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#access_requirement335-completed_achievement">completed_achievement</a></p></td>
+<td><p>mediumint(8)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#access_requirement335-quest_failed_text">quest_failed_text</a></p></td>
+<td><p>text</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>YES</p></td>
+<td><p>NULL</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#access_requirement335-comment">comment</a></p></td>
+<td><p>text</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>YES</p></td>
+<td><p>NULL</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+</tbody>
+</table>
+
+**Description of the fields**
+
+### mapId
+
+This is the [access\_id](instance_template_2130198.html#instance_template-access_id) field from the [instance\_template](instance_template) table. It is an arbitrary number that merely links the requirements to an [instance\_template](instance_template), or [areatrigger\_teleport](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](item_template_2130222.html#item_template-entry) that you must have in your inventory to enter the instance. This item can not be in the bank.
+
+### item2
+
+A second [item](item_template_2130222.html#item_template-entry) that you must have in your inventory. This item can not be in the bank.
+
+### quest\_done\_A
+
+A [quest](quest_template_2130261.html#quest_template-id) that you must have completed. This field is only for alliance.
+
+### quest\_done\_H
+
+A [quest](quest_template_2130261.html#quest_template-id) that you must have completed. This field is only for horde.
+
+### completed\_achievement
+
+An [achievement](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. \ No newline at end of file