diff options
Diffstat (limited to 'docs')
50 files changed, 719 insertions, 3749 deletions
diff --git a/docs/Languages.md b/docs/Languages.md index 231eff9..585642b 100644 --- a/docs/Languages.md +++ b/docs/Languages.md @@ -4,12 +4,11 @@ This DBC contains languages that can be used in texts. The player must have competence in this language to understand what is written. -| | | | -|------------|----------|-----------------------------------------| -| **Column** | **Type** | **Notes** | -| 1 | long | The ID of the language. Must be unique. | -| 2 | str | The name of the language goes here. | -| 18 | flags | The purpose of this column is unknown. | +| Column | Type | Notes | +|--------|-------|-----------------------------------------| +| 1 | long | The ID of the language. Must be unique. | +| 2 | str | The name of the language goes here. | +| 18 | flags | The purpose of this column is unknown. | Any unlisted columns are not used within the DBC file. @@ -17,87 +16,22 @@ Any unlisted columns are not used within the DBC file. All of the races, along with their IDs, from the *Languages.dbc* file are as follows. -<table> -<colgroup> -<col width="50%" /> -<col width="50%" /> -</colgroup> -<tbody> -<tr class="odd"> -<td><p><strong>ID</strong></p></td> -<td><p><strong>Name</strong></p></td> -</tr> -<tr class="even"> -<td><p>1</p></td> -<td><p>Orcish</p></td> -</tr> -<tr class="odd"> -<td><p>2</p></td> -<td><p>Darnassian</p></td> -</tr> -<tr class="even"> -<td><p>3</p></td> -<td><p>Taurahe</p></td> -</tr> -<tr class="odd"> -<td><p>6</p></td> -<td><p>Dwarvish</p></td> -</tr> -<tr class="even"> -<td><p>7</p></td> -<td><p>Common</p></td> -</tr> -<tr class="odd"> -<td><p>8</p></td> -<td><p>Demonic</p></td> -</tr> -<tr class="even"> -<td><p>9</p></td> -<td><p>Titan</p></td> -</tr> -<tr class="odd"> -<td><p>10</p></td> -<td><p>Thalassian</p></td> -</tr> -<tr class="even"> -<td><p>11</p></td> -<td><p>Draconic</p></td> -</tr> -<tr class="odd"> -<td><p>12</p></td> -<td><p>Kalimag</p></td> -</tr> -<tr class="even"> -<td><p>13</p></td> -<td><p>Gnomish</p></td> -</tr> -<tr class="odd"> -<td><p>14</p></td> -<td><p>Troll</p></td> -</tr> -<tr class="even"> -<td><p>33</p></td> -<td><p>Gutterspeak</p></td> -</tr> -<tr class="odd"> -<td><p>35</p></td> -<td><p>Draenei</p></td> -</tr> -<tr class="even"> -<td><p>36</p></td> -<td><p>Zombie</p></td> -</tr> -<tr class="odd"> -<td><p>37</p></td> -<td><p>Gnomish Binary</p></td> -</tr> -<tr class="even"> -<td><p>38</p></td> -<td><p>Goblin Binary</p></td> -</tr> -</tbody> -</table> - - - - +| ID | Name | +|----|----------------| +| 1 | Orcish | +| 2 | Darnassian | +| 3 | Taurahe | +| 6 | Dwarvish | +| 7 | Common | +| 8 | Demonic | +| 9 | Titan | +| 10 | Thalassian | +| 11 | Draconic | +| 12 | Kalimag | +| 13 | Gnomish | +| 14 | Troll | +| 33 | Gutterspeak | +| 35 | Draenei | +| 36 | Zombie | +| 37 | Gnomish Binary | +| 38 | Goblin Binary | diff --git a/docs/account_banned.md b/docs/account_banned.md index b025197..7b30c55 100644 --- a/docs/account_banned.md +++ b/docs/account_banned.md @@ -8,90 +8,21 @@ This table lists all of the accounts that have been banned along with the date w **Structure** -<table> -<colgroup> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -</colgroup> -<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="#id">id</a></p></td> -<td><p>int(10)</p></td> -<td><p>unsigned</p></td> -<td><p>PRI</p></td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td><p> </p></td> -<td><p>Account id</p></td> -</tr> -<tr class="odd"> -<td><p><a href="#bandate">bandate</a></p></td> -<td><p>int(10)</p></td> -<td><p>signed</p></td> -<td><p>PRI</p></td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="even"> -<td><p><a href="#unbandate">unbandate</a></p></td> -<td><p>int(10)</p></td> -<td><p>unsigned</p></td> -<td><p> </p></td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="odd"> -<td><p><a href="#bannedby">bannedby</a></p></td> -<td><p>varchar(50)</p></td> -<td><p>signed</p></td> -<td><p> </p></td> -<td><p>NO</p></td> -<td><p> </p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="even"> -<td><p><a href="#banreason">banreason</a></p></td> -<td><p>varchar(255)</p></td> -<td><p>signed</p></td> -<td><p> </p></td> -<td><p>NO</p></td> -<td><p> </p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="odd"> -<td><p><a href="#active">active</a></p></td> -<td><p>tinyint(3)</p></td> -<td><p>signed</p></td> -<td><p> </p></td> -<td><p>NO</p></td> -<td><p>1</p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -</tbody> -</table> +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|----------------|--------------|------------|-----|------|---------|-------|------------| +| [id][1] | int(10) | unsigned | PRI | NO | 0 | | Account id | +| [bandate][2] | int(10) | signed | PRI | NO | 0 | | | +| [unbandate][3] | int(10) | unsigned | | NO | 0 | | | +| [bannedby][4] | varchar(50) | signed | | NO | | | | +| [banreason][5] | varchar(255) | signed | | NO | | | | +| [active][6] | tinyint(3) | signed | | NO | 1 | | | + +[1]: #id +[2]: #bandate +[3]: #unbandate +[4]: #bannedby +[5]: #banreason +[6]: #active **Description of the fields** diff --git a/docs/account_data.md b/docs/account_data.md index 9ea8c0c..1484152 100644 --- a/docs/account_data.md +++ b/docs/account_data.md @@ -8,70 +8,17 @@ Contains data about client account and settings. **Structure** -<table> -<colgroup> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -</colgroup> -<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="#account">account</a></p></td> -<td><p>int(10)</p></td> -<td><p>unsigned</p></td> -<td><p>PRI</p></td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="odd"> -<td><p><a href="#type">type</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> </p></td> -<td><p> </p></td> -</tr> -<tr class="even"> -<td><p><a href="#time">time</a></p></td> -<td><p>int(10)</p></td> -<td><p>unsigned</p></td> -<td><p> </p></td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="odd"> -<td><p><a href="#data">data</a></p></td> -<td><p>blob</p></td> -<td><p>signed</p></td> -<td><p> </p></td> -<td><p>NO</p></td> -<td><p> </p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -</tbody> -</table> +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|--------------|------------|------------|-----|------|---------|-------|---------| +| [account][1] | int(10) | unsigned | PRI | NO | 0 | | | +| [type][2] | tinyint(3) | unsigned | PRI | NO | 0 | | | +| [time][3] | int(10) | unsigned | | NO | 0 | | | +| [data][4] | blob | signed | | NO | | | | + +[1]: #account +[2]: #type +[3]: #time +[4]: #data **Description of the fields** @@ -81,9 +28,11 @@ Contains data about client account and settings. ### type -- 0 = Global-account config cache -- 2 = Global-account bindings cache -- 4 = Global-account macros cache +| Value | Description | +|-------|-------------------------------| +| 0 | Global-account config cache | +| 2 | Global-account bindings cache | +| 4 | Global-account macros cache | ### time diff --git a/docs/account_instance_times.md b/docs/account_instance_times.md index 2abb829..a6760cf 100644 --- a/docs/account_instance_times.md +++ b/docs/account_instance_times.md @@ -8,60 +8,15 @@ This table controls how many instances the account's characters have been in las **Structure** -<table> -<colgroup> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -</colgroup> -<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="#accountid">accountId</a></p></td> -<td><p>int(10)</p></td> -<td><p>unsigned</p></td> -<td><p>PRI</p></td> -<td><p>NO</p></td> -<td><p> </p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="odd"> -<td><p><a href="#instanceid">instanceId</a></p></td> -<td><p>int(10)</p></td> -<td><p>unsigned</p></td> -<td><p>PRI</p></td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="even"> -<td><p><a href="#releasetime">releaseTime</a></p></td> -<td><p>bigint(20)</p></td> -<td><p>unsigned</p></td> -<td><p> </p></td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -</tbody> -</table> +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|------------------|------------|------------|-----|------|---------|-------|---------| +| [accountId][1] | int(10) | unsigned | PRI | NO | | | | +| [instanceId][2] | int(10) | unsigned | PRI | NO | 0 | | | +| [releaseTime][3] | bigint(20) | unsigned | | NO | 0 | | | + +[1]: #accountid +[2]: #instanceid +[3]: #releasetime **Description of the fields** diff --git a/docs/achievement_criteria_data.md b/docs/achievement_criteria_data.md index f7b3781..17f9dac 100644 --- a/docs/achievement_criteria_data.md +++ b/docs/achievement_criteria_data.md @@ -1,6 +1,6 @@ # achievement\_criteria\_data -` Back-to:World ` +[<-Back-to:World](database-world.md) **The \`achievement\_criteria\_data\` table** @@ -8,80 +8,19 @@ This table contains the data that a player needs to obtain / complete in order t **Structure** -<table> -<colgroup> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -<col width="12%" /> -</colgroup> -<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="#criteria_id">criteria_id</a></p></td> -<td><p>mediumint(8)</p></td> -<td><p>signed</p></td> -<td><p>PRI</p></td> -<td><p>NO</p></td> -<td><p>NULL</p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="odd"> -<td><p><a href="#type">type</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> </p></td> -<td><p> </p></td> -</tr> -<tr class="even"> -<td><p><a href="#value1">value1</a></p></td> -<td><p>medium(8)</p></td> -<td><p>unsigned</p></td> -<td><p> </p></td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="odd"> -<td><p><a href="#value2">value2</a></p></td> -<td><p>medium(8)</p></td> -<td><p>unsigned</p></td> -<td><p> </p></td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="even"> -<td><p><a href="#scriptname">ScriptName</a></p></td> -<td><p>char(64)</p></td> -<td><p>signed</p></td> -<td><p> </p></td> -<td><p>NO</p></td> -<td><p> </p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -</tbody> -</table> +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|------------------|--------------|------------|-----|------|---------|-------|---------| +| [criteria_id][1] | mediumint(8) | signed | PRI | NO | NULL | | | +| [type][2] | tinyint(3) | unsigned | PRI | NO | 0 | | | +| [value1][3] | medium(8) | unsigned | | NO | 0 | | | +| [value2][4] | medium(8) | unsigned | | NO | 0 | | | +| [ScriptName][5] | char(64) | signed | | NO | | | | + +[1]: #criteria_id +[2]: #type +[3]: #value1 +[4]: #value2 +[5]: #scriptname **Description of the fields** @@ -93,116 +32,32 @@ This is the ID from [Achievement\_Criteria.dbc](Achievement+Criteria). Depending on this value, it will determine how value1 and value2 are used. -<table> -<colgroup> -<col width="50%" /> -<col width="50%" /> -</colgroup> -<thead> -<tr class="header"> -<th><p>Type</p></th> -<th><p>Name</p></th> -</tr> -</thead> -<tbody> -<tr class="odd"> -<td><p>0</p></td> -<td><p>TYPE_NONE</p></td> -</tr> -<tr class="even"> -<td><p>1</p></td> -<td><p>TYPE_T_CREATURE</p></td> -</tr> -<tr class="odd"> -<td><p>2</p></td> -<td><p>TYPE_T_PLAYER_CLASS_RACE</p></td> -</tr> -<tr class="even"> -<td><p>3</p></td> -<td><p>TYPE_T_PLAYER_LESS_HEALTH</p></td> -</tr> -<tr class="odd"> -<td><p>4</p></td> -<td><p>TYPE_T_PLAYER_DEAD</p></td> -</tr> -<tr class="even"> -<td><p>5</p></td> -<td><p>TYPE_S_AURA</p></td> -</tr> -<tr class="odd"> -<td><p>6</p></td> -<td><p>TYPE_S_AREA</p></td> -</tr> -<tr class="even"> -<td><p>7</p></td> -<td><p>TYPE_T_AURA</p></td> -</tr> -<tr class="odd"> -<td><p>8</p></td> -<td><p>TYPE_VALUE</p></td> -</tr> -<tr class="even"> -<td><p>9</p></td> -<td><p>TYPE_T_LEVEL</p></td> -</tr> -<tr class="odd"> -<td><p>10</p></td> -<td><p>TYPE_T_GENDER</p></td> -</tr> -<tr class="even"> -<td><p>11</p></td> -<td><p>TYPE_SCRIPT</p></td> -</tr> -<tr class="odd"> -<td><p>12</p></td> -<td><p>TYPE_MAP_DIFFICULTY</p></td> -</tr> -<tr class="even"> -<td><p>13</p></td> -<td><p>TYPE_MAP_PLAYER_COUNT</p></td> -</tr> -<tr class="odd"> -<td><p>14</p></td> -<td><p>TYPE_T_TEAM</p></td> -</tr> -<tr class="even"> -<td><p>15</p></td> -<td><p>TYPE_S_DRUNK</p></td> -</tr> -<tr class="odd"> -<td><p>16</p></td> -<td><p>TYPE_HOLIDAY</p></td> -</tr> -<tr class="even"> -<td><p>17</p></td> -<td><p>TYPE_BG_LOSS_TEAM_SCORE</p></td> -</tr> -<tr class="odd"> -<td><p>18</p></td> -<td><p>TYPE_INSTANCE_SCRIPT</p></td> -</tr> -<tr class="even"> -<td><p>19</p></td> -<td><p>TYPE_S_EQUIPED_ITEM</p></td> -</tr> -<tr class="odd"> -<td><p>20</p></td> -<td><p>TYPE_MAP_ID</p></td> -</tr> -<tr class="even"> -<td><p>21</p></td> -<td><p>TYPE_S_PLAYER_CLASS_RACE</p></td> -</tr> -<tr class="odd"> -<td>22</td> -<td>TYPE_NTH_BIRTHDAY</td> -</tr> -<tr class="even"> -<td>23</td> -<td>TYPE_S_KNOWN_TITLE</td> -</tr> -</tbody> -</table> +| Type | Name | +|------|---------------------------| +| 0 | TYPE_NONE | +| 1 | TYPE_T_CREATURE | +| 2 | TYPE_T_PLAYER_CLASS_RACE | +| 3 | TYPE_T_PLAYER_LESS_HEALTH | +| 4 | TYPE_T_PLAYER_DEAD | +| 5 | TYPE_S_AURA | +| 6 | TYPE_S_AREA | +| 7 | TYPE_T_AURA | +| 8 | TYPE_VALUE | +| 9 | TYPE_T_LEVEL | +| 10 | TYPE_T_GENDER | +| 11 | TYPE_SCRIPT | +| 12 | TYPE_MAP_DIFFICULTY | +| 13 | TYPE_MAP_PLAYER_COUNT |