diff options
| author | Walter Pagani <paganiwalter@gmail.com> | 2021-01-13 15:17:00 -0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-01-13 19:17:00 +0100 |
| commit | b9e52ee0f8e70ab9b46480b935d1d61f7a12630b (patch) | |
| tree | f9cb8356176b87448cac4b090f6ca50411d1bfc3 | |
| parent | 2a6b711251ce581a99aa1e01bb8b857d79aaf856 (diff) | |
| download | wiki-b9e52ee0f8e70ab9b46480b935d1d61f7a12630b.tar.gz wiki-b9e52ee0f8e70ab9b46480b935d1d61f7a12630b.tar.bz2 wiki-b9e52ee0f8e70ab9b46480b935d1d61f7a12630b.zip | |
Review and update: access_requirement (#359)
* Review and update: access_requirement
* Cutting example and adding SQL used.
| -rw-r--r-- | docs/access_requirement.md | 41 |
1 files changed, 27 insertions, 14 deletions
diff --git a/docs/access_requirement.md b/docs/access_requirement.md index 2b6a4f6..b8bdef1 100644 --- a/docs/access_requirement.md +++ b/docs/access_requirement.md @@ -9,20 +9,20 @@ This table contains the access requirements to enter an instance. **Structure** -| Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|-----------------------------|---------------|------------|-----|------|---------|-------|---------| -| [mapId][1] | mediumint (8) | unsigned | PRI | NO | | | | -| [difficulty][2] | tinyint(3) | unsigned | PRI | NO | | | | -| [level_min][3] | tinyint(3) | unsigned | | NO | | | | -| [level_max][4] | tinyint(3) | unsigned | | NO | | | | -| [item_level][5] | smallint(5) | unsigned | | NO | | | | -| [item][6] | mediumint(8) | unsigned | | NO | | | | -| [item2][7] | mediumint(8) | unsigned | | NO | | | | -| [quest_done_A][8] | mediumint(8) | unsigned | | NO | | | | -| [quest_done_H][9] | mediumint(8) | unsigned | | NO | | | | -| [completed_achievement][10] | mediumint(8) | unsigned | | NO | | | | -| [quest_failed_text][11] | text | | | YES | NULL | | | -| [comment][12] | text | | | YES | NULL | | | +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------------------------|--------------|------------|-----|------|---------|-------|---------| +| [mapId][1] | mediumint(8) | unsigned | PRI | NO | | | | +| [difficulty][2] | tinyint(3) | unsigned | PRI | NO | 0 | | | +| [level_min][3] | tinyint(3) | unsigned | | NO | 0 | | | +| [level_max][4] | tinyint(3) | unsigned | | NO | 0 | | | +| [item_level][5] | smallint(5) | unsigned | | NO | 0 | | | +| [item][6] | mediumint(8) | unsigned | | NO | 0 | | | +| [item2][7] | mediumint(8) | unsigned | | NO | 0 | | | +| [quest_done_A][8] | mediumint(8) | unsigned | | NO | 0 | | | +| [quest_done_H][9] | mediumint(8) | unsigned | | NO | 0 | | | +| [completed_achievement][10] | mediumint(8) | unsigned | | NO | 0 | | | +| [quest_failed_text][11] | text | | | YES | | | | +| [comment][12] | text | | | YES | | | | [1]: #mapid [2]: #difficulty @@ -94,3 +94,16 @@ The text that is shown if you try and enter the instance without having complete ### comment This field is for any comment you want to make about the requirements or the instance. It is arbitrary text. + +### Example + +| mapId | difficulty | level_min | level_max | comment | +|-------|------------|-----------|-----------|------------------------------| +| 33 | 0 | 14 | 0 | Shadowfang Keep Entrance | +| 34 | 0 | 15 | 0 | Stormwind Stockades Entrance | + +**Note:** The table, has more attributes, but as an example, it was not necessary to show them all, because most did not have values and thus, avoid the table is very extensive. The executed SQL query is the following: + +```sql +SELECT `mapId`, `difficulty`, `level_min`, `level_max`, `comment` FROM `access_requirement` LIMIT 2; +``` |