From 6b9e80f09a9046b35ce4c069c7ce83791a24f87f Mon Sep 17 00:00:00 2001 From: Kitzunu <24550914+Kitzunu@users.noreply.github.com> Date: Sat, 12 Jun 2021 16:06:54 +0200 Subject: A (#516) --- docs/account.md | 6 +- docs/account_access.md | 8 +-- docs/account_banned.md | 10 +-- docs/account_data.md | 12 ++-- docs/account_instance_times.md | 4 +- docs/account_muted.md | 8 +-- docs/account_tutorial.md | 22 +++---- docs/achievement.md | 4 +- docs/achievement_criteria.md | 118 +++++++++++++++++----------------- docs/achievement_criteria_data.md | 10 +-- docs/achievement_dbc.md | 22 +++---- docs/achievement_reward.md | 22 +++---- docs/achievement_reward_locale.md | 34 +++++----- docs/acore_string.md | 22 +++---- docs/addons.md | 8 +-- docs/areatable.md | 6 +- docs/areatrigger.md | 26 ++++---- docs/areatrigger_involvedrelation.md | 6 +- docs/areatrigger_scripts.md | 8 +-- docs/areatrigger_tavern.md | 8 +-- docs/areatrigger_teleport.md | 16 ++--- docs/arena_team.md | 30 ++++----- docs/arena_team_member.md | 8 +-- docs/auctionhouse.md | 24 +++---- docs/autobroadcast.md | 12 ++-- docs/spell_area.md | 12 ++-- docs/spell_dbc.md | 120 +++++++++++++++++------------------ 27 files changed, 293 insertions(+), 293 deletions(-) (limited to 'docs') diff --git a/docs/account.md b/docs/account.md index 81fa38e..cc6ac1a 100644 --- a/docs/account.md +++ b/docs/account.md @@ -7,7 +7,7 @@ **Structure** | Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|-----------------------|--------------|------------|-----|------|-------------------|----------------|------------| +| --------------------- | ------------ | ---------- | --- | ---- | ----------------- | -------------- | ---------- | | [id][1] | INT | UNSIGNED | PRI | NO | | AUTO_INCREMENT | Identifier | | [username][2] | VARCHAR(32) | | UNI | NO | | | | | [salt][3] | BINARY(32) | | | NO | | | | @@ -20,7 +20,7 @@ | [last_ip][10] | VARCHAR(15) | | | NO | 127.0.0.1 | | | | [last_attempt_ip][11] | VARCHAR(15) | | | NO | 127.0.0.1 | | | | [failed_logins][12] | INT | UNSIGNED | | NO | 0 | | | -| [locked][13] | TINYINT | UNSIGNED | | NO | 0 | | | +| [locked][13] | TINYINT | UNSIGNED | | NO | 0 | | | | [lock_country][14] | VARCHAR(2) | | | NO | 0 | | | | [last_login][15] | TIMESTAMP | | | YES | NULL | | | | [online][16] | INT | UNSIGNED | | NO | 0 | | | @@ -164,7 +164,7 @@ Boolean 0 or 1 controlling if the account is currently logged in and online. Integer 0, 1 or 2 controlling if the client logged in on the account has any expansions. (for example if client is TBC, but expansion is set to 0, it will not be able to enter outlands and etc.) | Value | Expansion | -|-------|--------------------------------| +| ----- | ------------------------------ | | 0 | Classic | | 1 | The Burning Crusade (TBC) | | 2 | Wrath of the Lich King (WotLK) | diff --git a/docs/account_access.md b/docs/account_access.md index 3d5a8c5..c6594c7 100644 --- a/docs/account_access.md +++ b/docs/account_access.md @@ -9,10 +9,10 @@ This table holds security access level for any realm in [realmlist](realmlist) t **Structure** | Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|--------------|--------------|------------|-----|------|---------|-------|---------| -| [id][1] | INT | UNSIGNED | PRI | NO | | | | -| [gmlevel][2] | TINYINT | UNSIGNED | | NO | | | | -| [RealmID][3] | INT | SIGNED | PRI | NO | -1 | | | +| ------------ | ------------ | ---------- | --- | ---- | ------- | ----- | ------- | +| [id][1] | INT | UNSIGNED | PRI | NO | | | | +| [gmlevel][2] | TINYINT | UNSIGNED | | NO | | | | +| [RealmID][3] | INT | SIGNED | PRI | NO | -1 | | | | [comment][4] | VARCHAR(255) | | | YES | | | | [1]: #id diff --git a/docs/account_banned.md b/docs/account_banned.md index 112cfc5..da7f763 100644 --- a/docs/account_banned.md +++ b/docs/account_banned.md @@ -9,13 +9,13 @@ This table lists all of the accounts that have been banned along with the date w **Structure** | Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|----------------|--------------|------------|-----|------|---------|-------|------------| -| [id][1] | INT | UNSIGNED | PRI | NO | 0 | | Account id | -| [bandate][2] | INT | UNSIGNED | PRI | NO | 0 | | | -| [unbandate][3] | INT | UNSIGNED | | NO | 0 | | | +| -------------- | ------------ | ---------- | --- | ---- | ------- | ----- | ---------- | +| [id][1] | INT | UNSIGNED | PRI | NO | 0 | | Account id | +| [bandate][2] | INT | UNSIGNED | PRI | NO | 0 | | | +| [unbandate][3] | INT | UNSIGNED | | NO | 0 | | | | [bannedby][4] | VARCHAR(50) | | | NO | | | | | [banreason][5] | VARCHAR(255) | | | NO | | | | -| [active][6] | TINYINT | UNSIGNED | | NO | 1 | | | +| [active][6] | TINYINT | UNSIGNED | | NO | 1 | | | [1]: #id [2]: #bandate diff --git a/docs/account_data.md b/docs/account_data.md index 702db9b..14b5c1f 100644 --- a/docs/account_data.md +++ b/docs/account_data.md @@ -8,12 +8,12 @@ Contains data about client account and settings. **Structure** -| Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|--------------|------------|------------|-----|------|---------|-------|---------| -| [account][1] | INT | UNSIGNED | PRI | NO | 0 | | | +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ------------ | ------- | ---------- | --- | ---- | ------- | ----- | ------- | +| [account][1] | INT | UNSIGNED | PRI | NO | 0 | | | | [type][2] | TINYINT | UNSIGNED | PRI | NO | 0 | | | -| [time][3] | INT | UNSIGNED | | NO | 0 | | | -| [data][4] | BLOB | SIGNED | | NO | | | | +| [time][3] | INT | UNSIGNED | | NO | 0 | | | +| [data][4] | BLOB | SIGNED | | NO | | | | [1]: #account [2]: #type @@ -29,7 +29,7 @@ Contains data about client account and settings. ### type | Value | Description | -|-------|-------------------------------| +| ----- | ----------------------------- | | 0 | Global-account config cache | | 2 | Global-account bindings cache | | 4 | Global-account macros cache | diff --git a/docs/account_instance_times.md b/docs/account_instance_times.md index 9bc15bf..06d87b3 100644 --- a/docs/account_instance_times.md +++ b/docs/account_instance_times.md @@ -8,8 +8,8 @@ This table controls how many instances the account's characters have been in las **Structure** -| Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|------------------|------------|------------|-----|------|---------|-------|---------| +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ---------------- | ------ | ---------- | --- | ---- | ------- | ----- | ------- | | [accountId][1] | INT | UNSIGNED | PRI | NO | | | | | [instanceId][2] | INT | UNSIGNED | PRI | NO | 0 | | | | [releaseTime][3] | BIGINT | UNSIGNED | | NO | 0 | | | diff --git a/docs/account_muted.md b/docs/account_muted.md index 8d582d3..97353c9 100644 --- a/docs/account_muted.md +++ b/docs/account_muted.md @@ -13,10 +13,10 @@ Disable chat messaging for any character from account of character $playerName ( **Structure** | Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|-----------------|--------------|------------|-----|------|---------|-------|--------------------------| -| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | Global Unique Identifier | -| [mutedate][2] | INT | UNSIGNED | PRI | NO | 0 | | | -| [mutetime][3] | INT | UNSIGNED | | NO | 0 | | | +| --------------- | ------------ | ---------- | --- | ---- | ------- | ----- | ------------------------ | +| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | Global Unique Identifier | +| [mutedate][2] | INT | UNSIGNED | PRI | NO | 0 | | | +| [mutetime][3] | INT | UNSIGNED | | NO | 0 | | | | [mutedby][4] | VARCHAR(50) | | | NO | | | | | [mutereason][5] | VARCHAR(255) | | | NO | | | | diff --git a/docs/account_tutorial.md b/docs/account_tutorial.md index e834e88..6989f39 100644 --- a/docs/account_tutorial.md +++ b/docs/account_tutorial.md @@ -8,17 +8,17 @@ This table is used to store the tutorial state of all the accounts. **Structure** -| Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|----------------|---------|------------|-----|------|---------|--------|--------------------| -| [accountId][1] | INT | UNSIGNED | PRI | NO | 0 | Unique | Account Identifier | -| [tut0][2] | INT | UNSIGNED | | NO | 0 | | | -| [tut1][3] | INT | UNSIGNED | | NO | 0 | | | -| [tut2][4] | INT | UNSIGNED | | NO | 0 | | | -| [tut3][5] | INT | UNSIGNED | | NO | 0 | | | -| [tut4][6] | INT | UNSIGNED | | NO | 0 | | | -| [tut5][7] | INT | UNSIGNED | | NO | 0 | | | -| [tut6][8] | INT | UNSIGNED | | NO | 0 | | | -| [tut7][9] | INT | UNSIGNED | | NO | 0 | | | +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| -------------- | ---- | ---------- | --- | ---- | ------- | ------ | ------------------ | +| [accountId][1] | INT | UNSIGNED | PRI | NO | 0 | Unique | Account Identifier | +| [tut0][2] | INT | UNSIGNED | | NO | 0 | | | +| [tut1][3] | INT | UNSIGNED | | NO | 0 | | | +| [tut2][4] | INT | UNSIGNED | | NO | 0 | | | +| [tut3][5] | INT | UNSIGNED | | NO | 0 | | | +| [tut4][6] | INT | UNSIGNED | | NO | 0 | | | +| [tut5][7] | INT | UNSIGNED | | NO | 0 | | | +| [tut6][8] | INT | UNSIGNED | | NO | 0 | | | +| [tut7][9] | INT | UNSIGNED | | NO | 0 | | | [1]: #accountid [2]: #tut0 diff --git a/docs/achievement.md b/docs/achievement.md index 569cca2..8af11a6 100644 --- a/docs/achievement.md +++ b/docs/achievement.md @@ -15,7 +15,7 @@ This DBC contains all achievements. ## Structure | Column | Field | Type | Notes | -|--------|----------------------|--------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| +| ------ | -------------------- | ------------ | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | 1 | ID | Integer | Achievement ID | | 2 | Faction | Integer | -1: both, 0: Horde or 1: Alliance | | 3 | Map | Integer | Only set if achievement is related to a zone, otherwise set to -1 | @@ -38,7 +38,7 @@ This DBC contains all achievements. ## Content | ID | Name | -|------|--------------------------------------------------------------------------------| +| ---- | ------------------------------------------------------------------------------ | | 6 | Level 10 | | 7 | Level 20 | | 8 | Level 30 | diff --git a/docs/achievement_criteria.md b/docs/achievement_criteria.md index d6b0ed7..bc29f3d 100644 --- a/docs/achievement_criteria.md +++ b/docs/achievement_criteria.md @@ -15,7 +15,7 @@ This DBC has been added with WoW 3.0.1.8303 and contains the needed criteria to ## Structure | Column | Field | Type | Notes | -|--------|-------------------|---------|----------------------------------------------------------------------| +| ------ | ----------------- | ------- | -------------------------------------------------------------------- | | 1 | ID | Integer | Criteria ID | | 2 | Achievement | iRefID | Reference to the achievement this criteria is needed for. | | 3 | Type | Integer | Which type is this criteria? This defines the rows below. See below. | @@ -44,7 +44,7 @@ This information is retrieved from DBCStructure.h. *Also used for player deaths..* | Column | Field | Type | -|--------|------------|---------| +| ------ | ---------- | ------- | | 4 | creatureID | Integer | | 5 | killCount | Integer | @@ -53,48 +53,48 @@ This information is retrieved from DBCStructure.h. *There are further criterias instead just winning* | Column | Field | Type | -|--------|------------|---------| +| ------ | ---------- | ------- | | 4 | [Map](Map) | iRefID | | 5 | winCount | Integer | #### REACH\_LEVEL = 5 | Column | Field | Type | -|--------|--------|---------| +| ------ | ------ | ------- | | 4 | unused | Integer | | 5 | level | Integer | #### REACH\_SKILL\_LEVEL = 7 | Column | Field | Type | Notes | -|--------|------------|---------|-------------------------------------| +| ------ | ---------- | ------- | ----------------------------------- | | 4 | skillID | iRefID | [SkillLine.dbc](SkillLine) or what? | | 5 | skillLevel | Integer | | #### COMPLETE\_ACHIEVEMENT = 8 | Column | Field | Type | -|--------|----------------------------|--------| +| ------ | -------------------------- | ------ | | 4 | [Achievement](Achievement) | iRefID | #### COMPLETE\_QUEST\_COUNT = 9 | Column | Field | Type | -|--------|-----------------|---------| +| ------ | --------------- | ------- | | 4 | unused | Integer | | 5 | totalQuestCount | Integer | #### COMPLETE\_DAILY\_QUEST\_DAILY = 10 | Column | Field | Type | -|--------|--------------|---------| +| ------ | ------------ | ------- | | 4 | unused | Integer | | 5 | numberOfDays | Integer | #### COMPLETE\_QUESTS\_IN\_ZONE = 11 | Column | Field | Type | -|--------|------------|---------| +| ------ | ---------- | ------- | | 4 | zoneID | Integer | | 5 | questCount | Integer | @@ -103,7 +103,7 @@ This information is retrieved from DBCStructure.h. #### COMPLETE\_DAILY\_QUEST = 14 | Column | Field | Type | -|--------|------------|---------| +| ------ | ---------- | ------- | | 4 | unused | Integer | | 5 | questCount | Integer | @@ -112,44 +112,44 @@ This information is retrieved from DBCStructure.h. #### DEATH\_AT\_MAP = 16 | Column | Field | Type | -|--------|------------|--------| +| ------ | ---------- | ------ | | 4 | [Map](Map) | iRefID | #### DEATH\_IN\_DUNGEON = 18 | Column | Field | Type | -|--------|----------|---------| +| ------ | -------- | ------- | | 4 | manLimit | Integer | #### COMPLETE\_RAID = 19 | Column | Field | Type | Notes | -|--------|-----------|---------|--------------------| +| ------ | --------- | ------- | ------------------ | | 4 | groupSize | Integer | can be 5, 10 or 25 | #### KILLED\_BY\_CREATURE = 20 | Column | Field | Type | -|--------|---------------|---------| +| ------ | ------------- | ------- | | 4 | creatureEntry | Integer | #### FALL\_WITHOUT\_DYING = 24 | Column | Field | Type | -|--------|------------|---------| +| ------ | ---------- | ------- | | 4 | unused | Integer | | 5 | fallHeight | Integer | #### DEATHS\_FROM = 26 | Column | Field | Type | -|--------|---------------------|--------| +| ------ | ------------------- | ------ | | 4 | EnvironmentalDamage | iRefID | #### COMPLETE\_QUEST = 27 | Column | Field | Type | -|--------|------------|---------| +| ------ | ---------- | ------- | | 4 | questID | Integer | | 5 | questCount | Integer | @@ -158,7 +158,7 @@ This information is retrieved from DBCStructure.h. #### BE\_SPELL\_TARGET2 = 69 | Column | Field | Type | -|--------|----------------|---------| +| ------ | -------------- | ------- | | 4 | [Spell](Spell) | iRefID | | 5 | spellCount | Integer | @@ -167,21 +167,21 @@ This information is retrieved from DBCStructure.h. #### CAST\_SPELL2 = 110 | Column | Field | Type | -|--------|----------------|---------| +| ------ | -------------- | ------- | | 4 | [Spell](Spell) | iRefID | | 5 | castCount | Integer | #### BG\_OBJECTIVE\_CAPTURE = 30 | Column | Field | Type | Notes | -|--------|----------|---------|-----------------------------| +| ------ | -------- | ------- | --------------------------- | | 4 | unknow | Integer | value 42 = capture the flag | | 5 | count(?) | Integer | how many captures required | #### HONORABLE\_KILL\_AT\_AREA = 31 | Column | Field | Type | -|--------|-------------------|---------| +| ------ | ----------------- | ------- | | 4 | [Area](AreaTable) | iRefID | | 5 | killCount | Integer | @@ -190,13 +190,13 @@ This information is retrieved from DBCStructure.h. #### PLAY\_ARENA = 33 | Column | Field | Type | -|--------|------------|--------| +| ------ | ---------- | ------ | | 4 | [Map](Map) | iRefID | #### LEARN\_SPELL = 34 | Column | Field | Type | -|--------|----------------|--------| +| ------ | -------------- | ------ | | 4 | [Spell](Spell) | iRefID | #### OWN\_ITEM = 36 @@ -204,7 +204,7 @@ This information is retrieved from DBCStructure.h. #### WIN\_RATED\_ARENA = 37 | Column | Field | Type | Notes | -|--------|--------|---------|------------| +| ------ | ------ | ------- | ---------- | | 4 | unused | Integer | | | 5 | count | Integer | | | 6 | flag | Integer | 4=in a row | @@ -212,20 +212,20 @@ This information is retrieved from DBCStructure.h. #### HIGHEST\_TEAM\_RATING = 38 | Column | Field | Type | Notes | -|--------|----------|---------|---------| +| ------ | -------- | ------- | ------- | | 4 | teamtype | Integer | {2,3,5} | #### REACH\_TEAM\_RATING = 39 | Column | Field | Type | Notes | -|--------|------------|---------|---------| +| ------ | ---------- | ------- | ------- | | 4 | teamtype | Integer | {2,3,5} | | 5 | teamrating | Integer | | #### LEARN\_SKILL\_LEVEL = 40 | Column | Field | Type | Notes | -|--------|------------|---------|---------------------------------------------------------------------------| +| ------ | ---------- | ------- | ------------------------------------------------------------------------- | | 4 | skillID | iRefID | [SkillLine.dbc](SkillLine) or what? | | 5 | skillLevel | Integer | apprentice=1, journeyman=2, expert=3, artisan=4, master=5, grand master=6 | @@ -238,7 +238,7 @@ This information is retrieved from DBCStructure.h. - This areaReference is **NOT** the index from [AreaTable.dbc.](AreaTable) It's from WorldMapOverlay.dbc. | Column | Field | Type | -|--------|---------------|---------| +| ------ | ------------- | ------- | | 4 | areaReference | Integer | #### OWN\_RANK = 44 @@ -246,43 +246,43 @@ This information is retrieved from DBCStructure.h. - This rank is **NOT** the index from [CharTitles.dbc](CharTitles) | Column | Field | Type | -|--------|-------|---------| +| ------ | ----- | ------- | | 4 | rank | Integer | #### BUY\_BANK\_SLOT = 45 | Column | Field | Type | -|--------|---------------|---------| +| ------ | ------------- | ------- | | 4 | unused | Integer | | 5 | numberOfSlots | Integer | #### GAIN\_REPUTATION = 46 | Column | Field | Type | Notes | -|--------|--------------------|---------|---------------------------------------------| +| ------ | ------------------ | ------- | ------------------------------------------- | | 4 | [Faction](Faction) | iRefID | | | 5 | reputationAmount | Integer | Total reputation amount, so 42000 = exalted | #### GAIN\_EXALTED\_REPUTATION= 47 | Column | Field | Type | -|--------|-------------------------|---------| +| ------ | ----------------------- | ------- | | 4 | unused | Integer | | 5 | numberOfExaltedFactions | Integer | #### VISIT\_BARBER\_SHOP = 48 | Column | Field | Type | -|--------|----------------|---------| +| ------ | -------------- | ------- | | 4 | unused | Integer | -| 5 | numberOfVisits | Integer |  +| 5 | numberOfVisits | Integer | #### EQUIP\_EPIC\_ITEM = 49 - Where is the required itemlevel stored? | Column | Field | Type | -|--------|----------|---------| +| ------ | -------- | ------- | | 4 | itemSlot | Integer | #### ROLL\_NEED\_ON\_LOOT = 50 @@ -290,21 +290,21 @@ This information is retrieved from DBCStructure.h. #### ROLL\_GREED\_ON\_LOOT = 51 | Column | Field | Type | -|--------|-----------|---------| +| ------ | --------- | ------- | | 4 | rollValue | Integer | | 5 | count | Integer | #### HK\_CLASS = 52 | Column | Field | Type | -|--------|---------------------|---------| +| ------ | ------------------- | ------- | | 4 | [Class](ChrClasses) | iRefID | | 5 | count | Integer | #### HK\_RACE = 53 | Column | Field | Type | -|--------|------------------|---------| +| ------ | ---------------- | ------- | | 4 | [Race](ChrRaces) | iRefID | | 5 | count | Integer | @@ -313,7 +313,7 @@ This information is retrieved from DBCStructure.h. - where is the information about the target stored? | Column | Field | Type | Notes | -|--------|-----------------|---------|-----------------------------------------------------------------| +| ------ | --------------- | ------- | --------------------------------------------------------------- | | 4 | [Emote](Emotes) | iRefID | | | 5 | count | Integer | count of emotes, always required special target or requirements | @@ -322,7 +322,7 @@ This information is retrieved from DBCStructure.h. #### GET\_KILLING\_BLOWS = 56 | Column | Field | Type | Notes | -|--------|----------------|---------|----------------------------| +| ------ | -------------- | ------- | -------------------------- | | 4 | unused | Integer | | | 5 | count | Integer | | | 6 | flag | Integer | 3 for battleground healing | @@ -331,7 +331,7 @@ This information is retrieved from DBCStructure.h. #### EQUIP\_ITEM = 57 | Column | Field | Type | -|--------|--------------|---------| +| ------ | ------------ | ------- | | 4 | [Item](Item) | iRefID | | 5 | itemCount | Integer | @@ -340,14 +340,14 @@ This information is retrieved from DBCStructure.h. #### LOOT\_MONEY = 67 | Column | Field | Type | -|--------|--------------|---------| +| ------ | ------------ | ------- | | 4 | unused | Integer | | 5 | goldInCopper | Integer | #### USE\_GAMEOBJECT = 68 | Column | Field | Type | -|--------|----------|---------| +| ------ | -------- | ------- | | 4 | goEntry | Integer | | 5 | useCount | Integer | @@ -356,87 +356,87 @@ This information is retrieved from DBCStructure.h. - Are those special criteria stored in the dbc? | Column | Field | Type | -|--------|-----------|---------| +| ------ | --------- | ------- | | 4 | unused | Integer | | 5 | killCount | Integer | #### FISH\_IN\_GAMEOBJECT = 72 | Column | Field | Type | -|--------|-----------|---------| +| ------ | --------- | ------- | | 4 | goEntry | Integer | -| 5 | lootCount | Integer |  +| 5 | lootCount | Integer | #### LEARN\_SKILLLINE\_SPELLS = 75 | Column | Field | Type | -|--------|------------------------|---------| +| ------ | ---------------------- | ------- | | 4 | [SkillLine](SkillLine) | iRefID | | 5 | spellCount | Integer | #### WIN\_DUEL = 76 | Column | Field | Type | -|--------|-----------|---------| +| ------ | --------- | ------- | | 4 | unused | Integer | -| 5 | duelCount | Integer |  +| 5 | duelCount | Integer | #### HIGHEST\_POWER = 96 | Column | Field | Type | Notes | -|--------|-----------|---------|-----------------------------------------| +| ------ | --------- | ------- | --------------------------------------- | | 4 | powerType | Integer | 0=mana, 1=rage, 3=energy, 6=runic power | #### HIGHEST\_STAT = 97 | Column | Field | Type | Notes | -|--------|----------|---------|-----------------------------------------------| +| ------ | -------- | ------- | --------------------------------------------- | | 4 | statType | Integer | 4=spirit, 3=int, 2=stamina, 1=agi, 0=strength | #### HIGHEST\_SPELLPOWER = 98 | Column | Field | Type | Notes | -|--------|-------------|--------|---------------------------------------| +| ------ | ----------- | ------ | ------------------------------------- | | 4 | spellSchool | iRefID | [SkillLine](SkillLine) or Resistances | #### HIGHEST\_RATING = 100 | Column | Field | Type | -|--------|------------|---------| +| ------ | ---------- | ------- | | 4 | ratingType | Integer | #### LOOT\_TYPE = 109 | Column | Field | Type | Notes | -|--------|---------------|---------|----------------------------------------| +| ------ | ------------- | ------- | -------------------------------------- | | 4 | lootType | Integer | 3=fishing, 2=pickpocket, 4=disentchant | | 5 | lootTypeCount | Integer | | #### LEARN\_SKILL\_LINE = 112 | Column | Field | Type | -|--------|------------------------|---------| +| ------ | ---------------------- | ------- | | 4 | [SkillLine](SkillLine) | iRefID | | 5 | spellCount | Integer | #### EARN\_HONORABLE\_KILL = 113 | Column | Field | Type | -|--------|-----------|---------| +| ------ | --------- | ------- | | 4 | unused | Integer | | 5 | killCount | Integer | #### ACCEPTED\_SUMMONS = 114 | Column | Field | Type | -|--------|---------------------------------------------|---------| +| ------ | ------------------------------------------- | ------- | | 4 | unused | Integer | | 5 | Here comes a 1 in, because it's a Statistic | Integer | #### ACHIVEMENTPOINTS\_REACHED = 115 | Column | Field | Type | -|--------|--------|---------| +| ------ | ------ | ------- | | 4 | unused | Integer | | 5 | unused | Integer | @@ -445,6 +445,6 @@ This information is retrieved from DBCStructure.h. #### RANDOM\_DUNGEON\_PLAYERCOUNT = 119 | Column | Field | Type | -|--------|-------------|---------| +| ------ | ----------- | ------- | | 4 | unused | Integer | | 5 | PlayerCount | Integer | diff --git a/docs/achievement_criteria_data.md b/docs/achievement_criteria_data.md index ea7202f..0726c7b 100644 --- a/docs/achievement_criteria_data.md +++ b/docs/achievement_criteria_data.md @@ -8,13 +8,13 @@ This table contains the data that a player needs to obtain / complete in order t **Structure** -| Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|------------------|--------------|------------|-----|------|---------|-------|---------| +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ---------------- | --------- | ---------- | --- | ---- | ------- | ----- | ------- | | [criteria_id][1] | MEDIUMINT | | PRI | NO | | | | | [type][2] | TINYINT | UNSIGNED | PRI | NO | 0 | | | | [value1][3] | MEDIUMINT | UNSIGNED | | NO | 0 | | | | [value2][4] | MEDIUMINT | UNSIGNED | | NO | 0 | | | -| [ScriptName][5] | char(64) | | | NO | | | | +| [ScriptName][5] | char(64) | | | NO | | | | [1]: #criteria_id [2]: #type @@ -33,7 +33,7 @@ This is the ID from [Achievement\_Criteria.dbc](Achievement+Criteria). Depending on this value, it will determine how value1 and value2 are used. | Type | Name | -|------|---------------------------| +| ---- | ------------------------- | | 0 | TYPE_NONE | | 1 | TYPE_T_CREATURE | | 2 | TYPE_T_PLAYER_CLASS_RACE | @@ -191,7 +191,7 @@ Depending on this value, it will determine how value1 and value2 are used. **TYPE\_VALUE** | ComparisationType | -|--------------------------| +| ------------------------ | | COMP\_TYPE\_EQ = 0 | | COMP\_TYPE\_HIGH = 1 | | COMP\_TYPE\_LOW = 2 | diff --git a/docs/achievement_dbc.md b/docs/achievement_dbc.md index 06418eb..99122c1 100644 --- a/docs/achievement_dbc.md +++ b/docs/achievement_dbc.md @@ -8,15 +8,15 @@ Stores achievement data that is missing in [Achievement.dbc](Achievement) **Structure** -| Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|----------------------|---------|------------|-----|------|---------|-------|----------------------------------------------------------------------------------| -| [ID][1] | INT | UNSIGNED | PRI | NO | | | | -| [requiredFaction][2] | INT | SIGNED | | NO | -1 | | | -| [mapID][3] | INT | SIGNED | | NO | -1 | | | -| [points][4] | INT | UNSIGNED | | NO | 0 | | Achievement points awarded for completing the achievement, has no use serverside | -| [flags][5] | INT | UNSIGNED | | NO | 0 | | | -| [count][6] | INT | UNSIGNED | | NO | 0 | | | -| [refAchievement][7] | INT | UNSIGNED | | NO | 0 | | | +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| -------------------- | ---- | ---------- | --- | ---- | ------- | ----- | -------------------------------------------------------------------------------- | +| [ID][1] | INT | UNSIGNED | PRI | NO | | | | +| [requiredFaction][2] | INT | SIGNED | | NO | -1 | | | +| [mapID][3] | INT | SIGNED | | NO | -1 | | | +| [points][4] | INT | UNSIGNED | | NO | 0 | | Achievement points awarded for completing the achievement, has no use serverside | +| [flags][5] | INT | UNSIGNED | | NO | 0 | | | +| [count][6] | INT | UNSIGNED | | NO | 0 | | | +| [refAchievement][7] | INT | UNSIGNED | | NO | 0 | | | [1]: #id [2]: #requiredfaction @@ -35,7 +35,7 @@ This is the ID of the achievement from [Achievement\_Criteria.dbc](Achievement+C ### requiredFaction | Condition | Faction | -|-----------|---------| +| --------- | ------- | | Both | -1 | | Horde | 0 | | Alliance | 1 | @@ -51,7 +51,7 @@ Achievement points awarded for completing the achievement, has no use serverside ### flags | 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" | diff --git a/docs/achievement_reward.md b/docs/achievement_reward.md index 4bc0949..437a658 100644 --- a/docs/achievement_reward.md +++ b/docs/achievement_reward.md @@ -9,15 +9,15 @@ This table describes the reward that you will receive when you obtain a given ac **Structure** | Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|---------------------|--------------|------------|-----|------|---------|-------|---------| -| [ID][1] | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | | -| [TitleA][2] | MEDIUMINT | UNSIGNED | | NO | 0 | | | -| [TitleH][3] | MEDIUMINT | UNSIGNED | | NO | 0 | | | -| [ItemID][4] | MEDIUMINT | UNSIGNED | | NO | 0 | | | -| [Sender][5] | MEDIUMINT | UNSIGNED | | NO | 0 | | | +| ------------------- | ------------ | ---------- | --- | ---- | ------- | ----- | ------- | +| [ID][1] | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | | +| [TitleA][2] | MEDIUMINT | UNSIGNED | | NO | 0 | | | +| [TitleH][3] | MEDIUMINT | UNSIGNED | | NO | 0 | | | +| [ItemID][4] | MEDIUMINT | UNSIGNED | | NO | 0 | | | +| [Sender][5] | MEDIUMINT | UNSIGNED | | NO | 0 | | | | [Subject][6] | VARCHAR(255) | | | YES | | | | | [Body][7] | text | | | YES | | | | -| [MailTemplateID][8] | MEDIUMINT | UNSIGNED | | YES | 0 | | | +| [MailTemplateID][8] | MEDIUMINT | UNSIGNED | | YES | 0 | | | [1]: #id [2]: #titlea @@ -64,7 +64,7 @@ Id of the MailTemplate from `MailTemplate.dbc` of that mail that the player will ### Example -| ID | TitleA | TitleH | ItemID | Sender | Subject | -|----|--------|--------|--------|--------|---------------------| -| 13 | 0 | 0 | 41426 | 16128 | Level 80 | -| 45 | 0 | 0 | 43348 | 28070 | You've Been Around! | +| ID | TitleA | TitleH | ItemID | Sender | Subject | +| --- | ------ | ------ | ------ | ------ | ------------------- | +| 13 | 0 | 0 | 41426 | 16128 | Level 80 | +| 45 | 0 | 0 | 43348 | 28070 | You've Been Around! | diff --git a/docs/achievement_reward_locale.md b/docs/achievement_reward_locale.md index 79a6d67..49c3bff 100644 --- a/docs/achievement_reward_locale.md +++ b/docs/achievement_reward_locale.md @@ -8,12 +8,12 @@ It is the table that stores the translations of the table `achievement_reward`, **Structure** -| Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|--------------|--------------|------------|-----|------|---------|-------|---------| -| [ID][1] | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | | -| [Locale][2] | VARCHAR(4) | | PRI | NO | | | | -| [Subject][3] | text | | | YES | | | | -| [Text][4] | text | | | YES | | | | +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ------------ | ---------- | ---------- | --- | ---- | ------- | ----- | ------- | +| [ID][1] | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | | +| [Locale][2] | VARCHAR(4) | | PRI | NO | | | | +| [Subject][3] | text | | | YES | | | | +| [Text][4] | text | | | YES | | | | [1]: #id [2]: #locale @@ -30,17 +30,17 @@ It is the [ID](achievement_reward#id) of the achievement obtained from `achievem This is the language of the gaming client. -| ID | Language | -|----|----------| -| 0 | enUS | -| 1 | koKR | -| 2 | frFR | -| 3 | deDE | -| 4 | zhCN | -| 5 | zhTW | -| 6 | esES | -| 7 | esMX | -| 8 | ruRU | +| ID | Language | +| --- | -------- | +| 0 | enUS | +| 1 | koKR | +| 2 | frFR | +| 3 | deDE | +| 4 | zhCN | +| 5 | zhTW | +| 6 | esES | +| 7 | esMX | +| 8 | ruRU | ### Subject diff --git a/docs/acore_string.md b/docs/acore_string.md index 6139e89..0db3a95 100644 --- a/docs/acore_string.md +++ b/docs/acore_string.md @@ -12,18 +12,18 @@ NOTE: The % arguments need to stay in the exact same order as they are provided **Structure** -| Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|----------------------|--------------|------------|-----|------|---------|-------|---------| +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| -------------------- | --------- | ---------- | --- | ---- | ------- | ----- | ------- | | [entry][1] | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | | -| [content_default][2] | text | | | NO | | | | -| [locale_koKR][3] | text | | | YES | | | | -| [locale_frFR][3] | text | | | YES | | | | -| [locale_deDE][3] | text | | | YES | | | | -| [locale_zhCN][3] | text | | | YES | | | | -| [locale_zhTW][3] | text | | | YES | | | | -| [locale_esES][3] | text | | | YES | | | | -| [locale_esMX][3] | text | | | YES | | | | -| [locale_ruRU][3] | text | | | YES | | | | +| [content_default][2] | text | | | NO | | | | +| [locale_koKR][3] | text | | | YES | | | | +| [locale_frFR][3] | text | | | YES | | | | +| [locale_deDE][3] | text | | | YES | | | | +| [locale_zhCN][3] | text | | | YES | | | | +| [locale_zhTW][3] | text | | | YES | | | | +| [locale_esES][3] | text | | | YES | | | | +| [locale_esMX][3] | text | | | YES | | | | +| [locale_ruRU][3] | text | | | YES | | | | [1]: #entry [2]: #content\_default diff --git a/docs/addons.md b/docs/addons.md index ee3986f..26560d3 100644 --- a/docs/addons.md +++ b/docs/addons.md @@ -1,6 +1,6 @@ [Database Structure](Database-Structure) > [Character-Database](Character-Database) > [addons](addons) -Column | Type | Description ---- | --- | --- -Name | VARCHAR(120) | -Crc | INT UNSIGNED | +| Column | Type | Description | +| ------ | ------------ | ----------- | +| Name | VARCHAR(120) | +| Crc | INT UNSIGNED | diff --git a/docs/areatable.md b/docs/areatable.md index 001eae9..b3f6a27 100644 --- a/docs/areatable.md +++ b/docs/areatable.md @@ -15,7 +15,7 @@ This dbc contains the zone and subzone lists. For the purposes of this wiki arti ## Structure | Column | Name | Type | Notes | -|--------|------------------|--------|---------------------------------------------------------------| +| ------ | ---------------- | ------ | ------------------------------------------------------------- | | 1 | ID | Int | Zone Area | | 2 | MapID | Int | Map or Continent | | 3 | AreaID | Int | SubArea of Map | @@ -33,7 +33,7 @@ This dbc contains the zone and subzone lists. For the purposes of this wiki arti ## Flags | Value | Name | Notes | -|------------|--------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| +| ---------- | ------------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | 0x00000001 | AREA_FLAG_SNOW | snow (only Dun Morogh, Naxxramas, Razorfen Downs and Winterspring) | | 0x00000002 | AREA_FLAG_UNK1 | may be necropolis? | | 0x00000004 | AREA_FLAG_UNK2 | Only used for areas on map 571 (development before) | @@ -69,7 +69,7 @@ This dbc contains the zone and subzone lists. For the purposes of this wiki arti ## Content | Field Nb | Name | MapID | AreaID | -|----------|------------------------------------------------------|-------|--------| +| -------- | ---------------------------------------------------- | ----- | ------ | | 1 | Dun Morogh | 0 | 0 | | 2 | Longshore | 0 | 40 | | 3 | Badlands | 0 | 0 | diff --git a/docs/areatrigger.md b/docs/areatrigger.md index faede76..7933124 100644 --- a/docs/areatrigger.md +++ b/docs/areatrigger.md @@ -8,18 +8,18 @@ This table contains trigger points for events in certain coordinates in the maps **Structure** -| Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|-------------|---------|------------|-----|------|---------|----------------|------------------------------------------------------| -| entry | INT | UNSIGNED | PRI | NO | | AUTO_INCREMENT | | -| map | INT | UNSIGNED | | NO | 0 | | | -| x | FLOAT | | | NO | 0 | | | -| y | FLOAT | | | NO | 0 | | | -| z | FLOAT | | | NO | 0 | | | -| radius | FLOAT | | | NO | 0 | | Seems to be a box of size yards with center at x,y,z | -| length | FLOAT | | | NO | 0 | | Most commonly used when size is 0, but not always | -| width | FLOAT | | | NO | 0 | | Most commonly used when size is 0, but not always | -| height | FLOAT | | | NO | 0 | | Most commonly used when size is 0, but not always | -| orientation | FLOAT | | | NO | 0 | | Most commonly used when size is 0, but not always | +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ----------- | ----- | ---------- | --- | ---- | ------- | -------------- | ---------------------------------------------------- | +| entry | INT | UNSIGNED | PRI | NO | | AUTO_INCREMENT | | +| map | INT | UNSIGNED | | NO | 0 | | | +| x | FLOAT | | | NO | 0 | | | +| y | FLOAT | | | NO | 0 | | | +| z | FLOAT | | | NO | 0 | | | +| radius | FLOAT | | | NO | 0 | | Seems to be a box of size yards with center at x,y,z | +| length | FLOAT | | | NO | 0 | | Most commonly used when size is 0, but not always | +| width | FLOAT | | | NO | 0 | | Most commonly used when size is 0, but not always | +| height | FLOAT | | | NO | 0 | | Most commonly used when size is 0, but not always | +| orientation | FLOAT | | | NO | 0 | | Most commonly used when size is 0, but not always | **Description of the fields** @@ -46,7 +46,7 @@ these fields contain the values for the physics and behavior of a given trigger. ### Example | entry | map | x | y | z | radius | length | width | height | orientation | -|-------|-----|----------|----------|---------|--------|--------|-------|--------|-------------| +| ----- | --- | -------- | -------- | ------- | ------ | ------ | ----- | ------ | ----------- | | 45 | 0 | 2924.38 | -798.429 | 161.611 | 8 | 0 | 0 | 0 | 0 | | 71 | 0 | -10645.9 | 1179.06 | 48.1781 | 27 | 0 | 0 | 0 | 0 | | 78 | 0 | -11208.5 | 1685.34 | 25.7612 | 7 | 0 | 0 | 0 | 0 | diff --git a/docs/areatrigger_involvedrelation.md b/docs/areatrigger_involvedrelation.md index abe873c..58b0e1f 100644 --- a/docs/areatrigger_involvedrelation.md +++ b/docs/areatrigger_involvedrelation.md @@ -10,8 +10,8 @@ If there is a record in the table for a quest, then the quest will not be comple **Structure** -| Field | Type | Attributes | Key | Null | Default | Extra | Comments | -|------------|--------------|------------|-----|------|---------|-------|------------------| +| Field | Type | Attributes | Key | Null | Default | Extra | Comments | +| ---------- | --------- | ---------- | --- | ---- | ------- | ----- | ---------------- | | [id][1] | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | Identifier | | [quest][2] | MEDIUMINT | UNSIGNED | | NO | 0 | | Quest Identifier | @@ -31,7 +31,7 @@ This is the quest id that the trigger is tied to. ### Example | id | quest | -|-----|-------| +| --- | ----- | | 78 | 155 | | 87 | 76 | | 88 | 62 | diff --git a/docs/areatrigger_scripts.md b/docs/areatrigger_scripts.md index 2c889ae..13273ed 100644 --- a/docs/areatrigger_scripts.md +++ b/docs/areatrigger_scripts.md @@ -8,10 +8,10 @@ Allows for an area trigger to be scripted with Trinity Script. **Structure** -| Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|-----------------|--------------|------------|-----|------|---------|-------|---------| +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| --------------- | --------- | ---------- | --- | ---- | ------- | ----- | ------- | | [entry][1] | MEDIUMINT | | PRI | NO | | | | -| [ScriptName][2] | char(64) | | | NO | | | | +| [ScriptName][2] | char(64) | | | NO | | | | [1]: #entry [2]: #scriptname @@ -30,7 +30,7 @@ This might also be 'SmartTrigger'. It will than use [SmartAI](smart_scripts). ### Examples | entry | ScriptName | -|-------|-------------------| +| ----- | ----------------- | | 302 | at_sentry_point | | 962 | SmartTrigger | | 1447 | SmartTrigger | diff --git a/docs/areatrigger_tavern.md b/docs/areatrigger_tavern.md index 41011eb..c1f22fc 100644 --- a/docs/areatrigger_tavern.md +++ b/docs/areatrigger_tavern.md @@ -8,10 +8,10 @@ Enable a trigger when player enters a city or tavern. This causes the player to **Structure** -| Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|-----------|--------------|------------|-----|------|---------|-------|------------| +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| --------- | --------- | ---------- | --- | ---- | ------- | ----- | ---------- | | [id][1] | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | Identifier | -| [name][2] | text | | | YES | | | | +| [name][2] | text | | | YES | | | | [1]: #id [2]: #name @@ -29,7 +29,7 @@ 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 | diff --git a/docs/areatrigger_teleport.md b/docs/areatrigger_teleport.md index 4bd7b52..2eb6991 100644 --- a/docs/areatrigger_teleport.md +++ b/docs/areatrigger_teleport.md @@ -8,15 +8,15 @@ Contains all the teleport triggers definition. This table is used to complete .d **Structure** -| Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|-------------------------|--------------|------------|-----|------|---------|-------|---------| +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ----------------------- | --------- | ---------- | --- | ---- | ------- | ----- | ------- | | [ID][1] | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | | -| [Name][2] | text | | MUL | YES | | | | +| [Name][2] | text | | MUL | YES | | | | | [target_map][3] | SMALLINT | UNSIGNED | | NO | 0 | | | -| [target_position_x][4] | FLOAT | | | NO | 0 | | | -| [target_position_y][5] | FLOAT | | | NO | 0 | | | -| [target_position_z][6] | FLOAT | | | NO | 0 | | | -| [target_orientation][7] | FLOAT | | | NO | 0 | | | +| [target_position_x][4] | FLOAT | | | NO | 0 | | | +| [target_position_y][5] | FLOAT | | | NO | 0 | | | +| [target_position_z][6] | FLOAT | | | NO | 0 | | | +| [target_orientation][7] | FLOAT | | | NO | 0 | | | [1]: #id [2]: #name @@ -59,7 +59,7 @@ Orientation the player will get when appearing at this location ### Examples | ID | Name | target_map | target_position_x | target_position_y | target_position_z | target_orientation | -|-----|------------------------------------------|------------|-------------------|-------------------|-------------------|--------------------| +| --- | ---------------------------------------- | ---------- | ----------------- | ----------------- | ----------------- | ------------------ | | 45 | Scarlet Monastery - Graveyard (Entrance) | 189 | 1688.99 | 1053.48 | 18.6775 | 0.00117 | | 78 | DeadMines Entrance | 36 | -16.4 | -383.07 | 61.78 | 1.86 | | 101 | Stormwind Stockades Entrance | 34 | 54.23 | 0.28 | -18.34 | 6.26 | diff --git a/docs/arena_team.md b/docs/arena_team.md index 89d1e03..6949de6 100644 --- a/docs/arena_team.md +++ b/docs/arena_team.md @@ -9,22 +9,22 @@ This table holds the main ArenaTeam information. All created teams or all teams **Structure** | Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|-----------------------|-------------|------------|-----|------|---------|--------|---------| -| [arenaTeamId][1] | INT | UNSIGNED | PRI | NO | | Unique | | +| --------------------- | ----------- | ---------- | --- | ---- | ------- | ------ | ------- | +| [arenaTeamId][1] | INT | UNSIGNED | PRI | NO | | Unique | | | [name][2] | VARCHAR(24) | | | NO | | | | -| [captainGuid][3] | INT | UNSIGNED | | NO | | | | -| [type][4] | TINYINT | UNSIGNED | | NO | | | | -| [rating][5] | SMALLINT | UNSIGNED | | NO | | | | -| [seasonGames][6] | SMALLINT | UNSIGNED | | NO | | | | -| [seasonWins][7] | SMALLINT | UNSIGNED | | NO | | | | -| [weekGames][8] | SMALLINT | UNSIGNED | | NO | | | | -| [weekWins][9] | SMALLINT | UNSIGNED | | NO | | | | -| [rank][10] | INT | UNSIGNED | | NO | | | | -| [BackgroundColor][11] | INT | UNSIGNED | | NO | | | | -| [EmblemStyle][12] | TINYINT | UNSIGNED | | NO | | | | -| [EmblemColor][13] | INT | UNSIGNED | | NO | | | | -| [BorderStyle][14] | TINYINT | UNSIGNED | | NO | | | | -| [BorderColor][15] | INT | UNSIGNED | | NO | | | | +| [captainGuid][3] | INT | UNSIGNED | | NO | | | | +| [type][4] | TINYINT | UNSIGNED | | NO | | | | +| [rating][5] | SMALLINT | UNSIGNED | | NO | | | | +| [seasonGames][6] | SMALLINT | UNSIGNED | | NO | | | | +| [seasonWins][7] | SMALLINT | UNSIGNED | | NO | | | | +| [weekGames][8] | SMALLINT | UNSIGNED | | NO | | | | +| [weekWins][9] | SMALLINT | UNSIGNED | | NO | | | | +| [rank][10] | INT | UNSIGNED | | NO | | | | +| [BackgroundColor][11] | INT | UNSIGNED | | NO | | | | +| [EmblemStyle][12] | TINYINT | UNSIGNED | | NO | | | | +| [EmblemColor][13] | INT | UNSIGNED | | NO | | | | +| [BorderStyle][14] | TINYINT | UNSIGNED | | NO | | | | +| [BorderColor][15] | INT | UNSIGNED | | NO | | | | [1]: #arenateamid [2]: #name diff --git a/docs/arena_team_member.md b/docs/arena_team_member.md index 5450f9f..6eddd2f 100644 --- a/docs/arena_team_member.md +++ b/docs/arena_team_member.md @@ -8,10 +8,10 @@ This table holds arena info about specific team members. All arena\_team members **Structure** -| Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|---------------------|-------------|------------|-----|------|---------|-------|---------| -| [arenaTeamId][1] | INT | UNSIGNED | PRI | NO | 0 | | | -| [guid][2] | INT | UNSIGNED | PRI | NO | 0 | | | +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ------------------- | -------- | ---------- | --- | ---- | ------- | ----- | ------- | +| [arenaTeamId][1] | INT | UNSIGNED | PRI | NO | 0 | | | +| [guid][2] | INT | UNSIGNED | PRI | NO | 0 | | | | [personalRating][3] | SMALLINT | UNSIGNED | | NO | 0 | | | | [weekGames][4] | SMALLINT | UNSIGNED | | NO | 0 | | | | [weekWins][5] | SMALLINT | UNSIGNED | | NO | 0 | | | diff --git a/docs/auctionhouse.md b/docs/auctionhouse.md index 166d811..6564331 100644 --- a/docs/auctionhouse.md +++ b/docs/auctionhouse.md @@ -10,18 +10,18 @@ This table is used by Trinity while running and not a table that you would usual **Structure** -| Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|---------------------|---------|------------|-----|------|---------|-------|---------| -| [id][1] | INT | UNSIGNED | PRI | NO | 0 | | | -| [auctioneerguid][2] | INT | UNSIGNED | | NO | 0 | | | -| [itemguid][3] | INT | UNSIGNED | UNI | NO | 0 | | | -| [itemowner][4] | INT | UNSIGNED | | NO | 0 | | | -| [buyoutprice][5] | INT | UNSIGNED | | NO | 0 | | | -| [time][6] | INT | UNSIGNED | | NO | 0 | | | -| [buyguid][7] | INT | UNSIGNED | | NO | 0 | | | -| [lastbid][8] | INT | UNSIGNED | | NO | 0 | | | -