diff options
Diffstat (limited to 'docs/access_requirement.md')
| -rw-r--r-- | docs/access_requirement.md | 252 |
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 |
