From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/access_requirement.md | 252 ++++++++++++++++++++++++++++++++++++++++++--- 1 file changed, 236 insertions(+), 16 deletions(-) (limited to 'docs/access_requirement.md') 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** + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field

Type

Attributes

Key

Null

Default

Extra

Comment

mapId

mediumint (8)

unsigned

PRI

NO

NULL


+


+

difficulty

tinyint(3)

unsigned

PRI

NO

0


+


+

level_min

tinyint(3)

unsigned


+

NO

0


+


+

level_max

tinyint(3)

unsigned


+

NO

0


+


+

item_levelsmallint(5)unsigned
+		NO0
+
+

item

mediumint(8)

unsigned


+

NO

0


+


+

item2

mediumint(8)

unsigned


+

NO

0


+


+

quest_done_A

mediumint(8)

unsigned


+

NO

0


+


+

quest_done_H

mediumint(8)

unsigned


+

NO

0


+


+

completed_achievement

mediumint(8)

unsigned


+

NO

0


+


+

quest_failed_text

text

signed


+

YES

NULL


+


+

comment

text

signed


+

YES

NULL


+


+

+ +**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 -- cgit