diff options
Diffstat (limited to 'docs')
30 files changed, 1257 insertions, 6020 deletions
diff --git a/docs/achievement_dbc.md b/docs/achievement_dbc.md index 0b25073..cbd9483 100644 --- a/docs/achievement_dbc.md +++ b/docs/achievement_dbc.md @@ -1,6 +1,6 @@ # achievement\_dbc -` Back-to:World ` +[<-Back-to:World](database-world.md) **The \`achievement\_dbc\` table** @@ -8,100 +8,23 @@ Stores achievement data that is missing in [Achievement.dbc](Achievement) **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> </p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -<tr class="odd"> -<td><p><a href="#requiredfaction">requiredFaction</a></p></td> -<td><p>int(11)</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> -<tr class="even"> -<td><p><a href="#mapid">mapID</a></p></td> -<td><p>int(11)</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> -<tr class="odd"> -<td><p><a href="#points">points</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>Achievement points awarded for completing the achievement, has no use serverside</p></td> -</tr> -<tr class="even"> -<td><p><a href="#flags">flags</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="#count">count</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="even"> -<td><p><a href="#refachievement">refAchievement</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> -</tbody> -</table> +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|----------------------|---------|------------|-----|------|---------|-------|----------------------------------------------------------------------------------| +| [ID][1] | int(10) | unsigned | PRI | NO | | | | +| [requiredFaction][2] | int(11) | signed | | NO | -1 | | | +| [mapID][3] | int(11) | signed | | NO | -1 | | | +| [points][4] | int(10) | unsigned | | NO | 0 | | Achievement points awarded for completing the achievement, has no use serverside | +| [flags][5] | int(10) | unsigned | | NO | 0 | | | +| [count][6] | int(10) | unsigned | | NO | 0 | | | +| [refAchievement][7] | int(10) | unsigned | | NO | 0 | | | + +[1]: #id +[2]: #requiredfaction +[3]: #mapid +[4]: #points +[5]: #flags +[6]: #count +[7]: #refachievement **Description of the fields** @@ -111,10 +34,11 @@ This is the ID of the achievement from [Achievement\_Criteria.dbc](Achievement+C ### requiredFaction -- Condition: - - Both: -1, - - Horde: 0, - - Alliance: 1 +| Condition | Faction | +|-----------|---------| +| Both | -1 | +| Horde | 0 | +| Alliance | 1 | ### mapID @@ -126,72 +50,18 @@ Achievement points awarded for completing the achievement, has no use serverside ### flags -<table> -<colgroup> -<col width="33%" /> -<col width="33%" /> -<col width="33%" /> -</colgroup> -<thead> -<tr class="header"> -<th><p>Name</p></th> -<th><p>Value</p></th> -<th><p>Comment</p></th> -</tr> -</thead> -<tbody> -<tr class="odd"> -<td><p>ACHIEVEMENT_FLAG_COUNTER</p></td> -<td><p>0x00000001</p></td> -<td><p>Just count statistic (never stop and complete)</p></td> -</tr> -<tr class="even"> -<td><p>ACHIEVEMENT_FLAG_HIDDEN</p></td> -<td><p>0x00000002</p></td> -<td><p>Not sent to client - internal use only</p></td> -</tr> -<tr class="odd"> -<td><p>ACHIEVEMENT_FLAG_STORE_MAX_VALUE</p></td> -<td><p>0x00000004</p></td> -<td><p>Store only max value? used only in "Reach level xx"</p></td> -</tr> -<tr class="even"> -<td><p>ACHIEVEMENT_FLAG_SUMM</p></td> -<td><p>0x00000008</p></td> -<td><p>Use summ criteria value from all reqirements (and calculate max value)</p></td> -</tr> -<tr class="odd"> -<td><p>ACHIEVEMENT_FLAG_MAX_USED</p></td> -<td><p>0x00000010</p></td> -<td><p>Show max criteria (and calculate max value ??)</p></td> -</tr> -<tr class="even"> -<td><p>ACHIEVEMENT_FLAG_REQ_COUNT</p></td> -<td><p>0x00000020</p></td> -<td><p>Use not zero req count (and calculate max value)</p></td> -</tr> -<tr class="odd"> -<td><p>ACHIEVEMENT_FLAG_AVERAGE</p></td> -<td><p>0x00000040</p></td> -<td><p>Show as average value (value / time_in_days) depend from other flag (by def use last criteria value)</p></td> -</tr> -<tr class="even"> -<td><p>ACHIEVEMENT_FLAG_BAR</p></td> -<td><p>0x00000080</p></td> -<td><p>Show as progress bar (value / max vale) depend from other flag (by def use last criteria value)</p></td> -</tr> -<tr class="odd"> -<td><p>ACHIEVEMENT_FLAG_REALM_FIRST_REACH</p></td> -<td><p>0x00000100</p></td> -<td><p> </p></td> -</tr> -<tr class="even"> -<td><p>ACHIEVEMENT_FLAG_REALM_FIRST_KILL</p></td> -<td><p>0x00000200</p></td> -<td><p> </p></td> -</tr> -</tbody> -</table> +| Name | Value | Comment | +|------------------------------------|------------|------------------------------------------------------------------------------------------------------| +| ACHIEVEMENT_FLAG_COUNTER | 0x00000001 | Just count statistic (never stop and complete) | +| ACHIEVEMENT_FLAG_HIDDEN | 0x00000002 | Not sent to client - internal use only | +| ACHIEVEMENT_FLAG_STORE_MAX_VALUE | 0x00000004 | Store only max value? used only in "Reach level xx" | +| ACHIEVEMENT_FLAG_SUMM | 0x00000008 | Use summ criteria value from all reqirements (and calculate max value) | +| ACHIEVEMENT_FLAG_MAX_USED | 0x00000010 | Show max criteria (and calculate max value ??) | +| ACHIEVEMENT_FLAG_REQ_COUNT | 0x00000020 | Use not zero req count (and calculate max value) | +| ACHIEVEMENT_FLAG_AVERAGE | 0x00000040 | Show as average value (value / time_in_days) depend from other flag (by def use last criteria value) | +| ACHIEVEMENT_FLAG_BAR | 0x00000080 | Show as progress bar (value / max vale) depend from other flag (by def use last criteria value) | +| ACHIEVEMENT_FLAG_REALM_FIRST_REACH | 0x00000100 | | +| ACHIEVEMENT_FLAG_REALM_FIRST_KILL | 0x00000200 | | ### count diff --git a/docs/areatrigger_scripts.md b/docs/areatrigger_scripts.md index ab7a988..89bf584 100644 --- a/docs/areatrigger_scripts.md +++ b/docs/areatrigger_scripts.md @@ -8,50 +8,13 @@ Allows for an area trigger to be scripted with Trinity Script. **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="#entry">entry</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="#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>NULL</p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -</tbody> -</table> +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------------|--------------|------------|-----|------|---------|-------|---------| +| [entry][1] | mediumint(8) | signed | PRI | NO | NULL | | | +| [ScriptName][2] | char(64) | signed | | NO | NULL | | | + +[1]: #entry +[2]: #scriptname **Description of the fields** @@ -63,3 +26,13 @@ This is the trigger identifier from [AreaTrigger.dbc](DBC-AreaTrigger) The ScriptName for when scripting it in the core. This might also be 'SmartTrigger'. It will than use [SmartAI](smart_scripts). + +### Examples + +| entry | ScriptName | +|-------|-------------------| +| 302 | at_sentry_point | +| 962 | SmartTrigger | +| 1447 | SmartTrigger | +| 1526 | at_ring_of_law | +| 1726 | at_scent_larkorwi | diff --git a/docs/areatrigger_tavern.md b/docs/areatrigger_tavern.md index 257a091..8a7941f 100644 --- a/docs/areatrigger_tavern.md +++ b/docs/areatrigger_tavern.md @@ -8,50 +8,13 @@ Enable a trigger when player enters a city or tavern. This causes the player to **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>mediumint(8)</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>Identifier</p></td> -</tr> -<tr class="odd"> -<td><p><a href="#name">name</a></p></td> -<td><p>text</p></td> -<td><p>signed</p></td> -<td><p> </p></td> -<td><p>YES</p></td> -<td><p>NULL</p></td> -<td><p> </p></td> -<td><p> </p></td> -</tr> -</tbody> -</table> +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------|--------------|------------|-----|------|---------|-------|------------| +| [id][1] | mediumint(8) | unsigned | PRI | NO | 0 | | Identifier | +| [name][2] | text | signed | | YES | NULL | | | + +[1]: #id +[2]: #name **Description of the fields** @@ -62,3 +25,13 @@ This is the trigger identifier, see [AreaTrigger.dbc](DBC-AreaTrigger) ### name Name of the city or tavern. This is purely for descriptive purposes. + +### Example + +| id | name | +|-----|----------------------------------------------| +| 71 | Westfall - Sentinel Hill Inn | +| 98 | Nesingwary's Expedition | +| 178 | Strahnbrad | +| 562 | Elwynn Forest - Goldshire - Lion's Pride Inn | +| 682 | Redridge Mountains - Lakeshire Inn | diff --git a/docs/areatrigger_template_actions.md b/docs/areatrigger_template_actions.md index 9e4147e..0b9513a 100644 --- a/docs/areatrigger_template_actions.md +++ b/docs/areatrigger_template_actions.md @@ -8,72 +8,17 @@ This table contains the description of areatrigger actions. **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="#areatriggerid">AreaTriggerId</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><br /> -</p></td> -<td><p><br /> -</p></td> -<td><p><br /> -</p></td> -</tr> -<tr class="odd"> -<td><p><a href="#actiontype">ActionType</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><br /> -</p></td> -<td><p><br /> -</p></td> -<td><p><br /> -</p></td> -</tr> -<tr class="even"> -<td><p><a href="#actionparam">ActionParam</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><br /> -</p></td> -<td><p><br /> -</p></td> -<td><p><br /> -</p></td> -</tr> -<tr class="odd"> -<td><a href="#targettype">TargetType</a></td> -<td>int(10)</td> -<td>unsigned</td> -<td><br /> -</td> -<td>NO</td> -<td>0</td> -<td><br /> -</td> -<td><br /> -</td> -</tr> -</tbody> -</table> +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|--------------------|---------|------------|-----|------|---------|-------|---------| +| [AreaTriggerId][1] | int(10) | unsigned | PRI | NO | | | | +| [ActionType][2] | int(10) | unsigned | PRI | NO | | | | +| [ActionParam][3] | int(10) | unsigned | PRI | NO | | | | +| [TargetType][4] | int(10) | unsigned | | NO | 0 | | | + +[1]: #areatriggerid +[2]: #actiontype +[3]: #actionparam +[4]: #targettype **Description of the fields** diff --git a/docs/battlemaster_entry.md b/docs/battlemaster_entry.md index cbdfaa5..73c94a7 100644 --- a/docs/battlemaster_entry.md +++ b/docs/battlemaster_entry.md @@ -8,50 +8,13 @@ Holds information on which NPC can start what battleground or arena. **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="#entry">entry</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>0</p></td> -<td><p> </p></td> -<td><p>Entry of a creature</p></td> -</tr> -<tr class="odd"> -<td><p><a href="#bg_template">bg_template</a></p></td> -<td><p>mediumint(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>Batleground template id</p></td> -</tr> -</tbody> -</table> +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|------------------|--------------|------------|-----|------|---------|-------|-------------------------| +| [entry][1] | mediumint(8) | unsigned | PRI | NO | 0 | | Entry of a creature | +| [bg_template][2] | mediumint(8) | unsigned | | NO | 0 | | Batleground template id | + +[1]: #entry +[2]: #bg_template **Description of the fields** diff --git a/docs/character_battleground_random.md b/docs/character_battleground_random.md index b5787d4..f26afe5 100644 --- a/docs/character_battleground_random.md +++ b/docs/character_battleground_random.md @@ -8,40 +8,11 @@ This table stores battlegrounds IDs for random battleground sessions. **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="#guid">guid</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> -</tbody> -</table> +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------|----------|------------|-----|------|---------|-------|---------| +| [guid][1] | int (10) | unsigned | PRI | NO | 0 | | | + +[1]: #guid **Description of the fields** diff --git a/docs/character_queststatus_weekly.md b/docs/character_queststatus_weekly.md index f00c0d7..46a7336 100644 --- a/docs/character_queststatus_weekly.md +++ b/docs/character_queststatus_weekly.md @@ -8,50 +8,13 @@ Holds information on the weekly quest status of every player. The timers reset a **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="#guid">guid</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>Global Unique Identifier</p></td> -</tr> -<tr class="odd"> -<td><p><a href="#quest">quest</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>Quest Identifier</p></td> -</tr> -</tbody> -</table> +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|------------|---------|------------|-----|------|---------|-------|--------------------------| +| [guid][1] | int(10) | unsigned | PRI | NO | 0 | | Global Unique Identifier | +| [quest][2] | int(10) | unsigned | PRI | NO | 0 | | Quest Identifier | + +[1]: #guid +[2]: #quest **Description of the fields** diff --git a/docs/creature_onkill_reputation.md b/docs/creature_onkill_reputation.md index 32b1bb1..ac40b84 100644 --- a/docs/creature_onkill_reputation.md +++ b/docs/creature_onkill_reputation.md @@ -8,130 +8,29 @@ This table controls the reputation given by creatures when killed by other playe **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="#creature_id">creature_id</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>0</p></td> -<td><p> </p></td> -<td><p>Creature Identifier</p></td> -</tr> -<tr class="odd"> -<td><p><a href="#rewonkillrepfaction">RewOnKillRepFaction1</a></p></td> -<td><p>smallint(6)</p></td> -<td><p>signed</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="#rewonkillrepfaction">RewOnKillRepFaction2</a></p></td> -<td><p>smallint(6)</p></td> -<td><p>signed</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="#maxstanding">MaxStanding1</a></p></td> -<td><p>tinyint(4)</p></td> -<td><p>signed</p></td> -<td><p> </p></td> -<td><p>NO</p></td> -<td><p>0</p></td> -<td><p> </p></td> -<td><p> </p></td |