From 55c623c547ea0354209b33faa184a71a3cdda102 Mon Sep 17 00:00:00 2001 From: "Julio A. Leyva Osorio" Date: Thu, 22 Jul 2021 13:36:46 -0400 Subject: docs: Update db-characters-en (#606) --- docs/account_data.md | 2 +- docs/addons.md | 5 ++-- docs/arena_team.md | 2 +- docs/arena_team_member.md | 4 +-- docs/auctionhouse.md | 2 -- docs/banned_addons.md | 8 +++--- docs/battleground_deserters.md | 8 +++--- docs/bugreport.md | 5 ++-- docs/calendar_events.md | 9 +++---- docs/calendar_invites.md | 6 ++--- docs/channels.md | 6 ++--- docs/channels_bans.md | 4 +-- docs/channels_rights.md | 3 +-- docs/character_account_data.md | 2 +- docs/character_achievement.md | 2 +- docs/character_action.md | 4 +-- docs/character_arena_stats.md | 8 +++--- docs/character_aura.md | 8 +++--- docs/character_banned.md | 4 +-- docs/character_battleground_random.md | 21 +++++++++++++++ docs/character_brew_of_the_month.md | 4 +-- docs/character_declinedname.md | 2 +- docs/character_entry_point.md | 2 +- docs/character_equipmentsets.md | 44 ++++++++++++++++---------------- docs/character_gifts.md | 2 +- docs/character_instance.md | 2 +- docs/character_inventory.md | 2 +- docs/character_queststatus.md | 4 +-- docs/character_queststatus_daily.md | 4 +-- docs/character_queststatus_monthly.md | 3 +-- docs/character_reputation.md | 2 +- docs/character_social.md | 4 +-- docs/character_spell.md | 2 +- docs/character_spell_cooldown.md | 2 +- docs/character_talent.md | 2 +- docs/characters.md | 5 ++-- docs/corpse.md | 2 +- docs/creature_respawn.md | 2 +- docs/database-characters.md | 4 ++- docs/game_event_condition_save.md | 2 +- docs/game_event_save.md | 4 +-- docs/gameobject_respawn.md | 2 +- docs/gm_subsurvey.md | 4 +-- docs/gm_survey.md | 2 +- docs/gm_ticket.md | 2 +- docs/group_member.md | 6 ++--- docs/groups.md | 6 ++--- docs/guild.md | 2 +- docs/guild_bank_eventlog.md | 2 +- docs/guild_bank_item.md | 4 +-- docs/guild_bank_right.md | 4 +-- docs/guild_bank_tab.md | 4 +-- docs/guild_eventlog.md | 2 +- docs/guild_member.md | 2 +- docs/guild_member_withdraw.md | 2 +- docs/guild_rank.md | 2 +- docs/instance.md | 2 +- docs/instance_reset.md | 2 +- docs/item_instance.md | 48 +++++++++++++++++------------------ docs/item_loot_storage.md | 22 ++++++++-------- docs/item_refund_instance.md | 6 ++--- docs/item_soulbound_trade_data.md | 2 +- docs/lag_reports.md | 4 +-- docs/log_arena_fights.md | 2 +- docs/log_arena_memberstats.md | 2 +- docs/log_encounter.md | 2 +- docs/log_money.md | 2 +- docs/mail.md | 8 +++--- docs/mail_items.md | 6 ++--- docs/pet_aura.md | 2 +- docs/pet_spell.md | 2 +- docs/pet_spell_cooldown.md | 2 +- docs/petition.md | 4 +-- docs/petition_sign.md | 6 ++--- docs/pool_quest_save.md | 14 +++++----- docs/pvpstats_battlegrounds.md | 10 ++++---- docs/pvpstats_players.md | 6 ++--- docs/quest_tracker.md | 2 +- docs/recovery_item.md | 2 +- docs/reserved_name.md | 4 +-- docs/version_db_characters.md | 6 ++--- docs/warden_action.md | 2 +- 82 files changed, 221 insertions(+), 208 deletions(-) create mode 100644 docs/character_battleground_random.md diff --git a/docs/account_data.md b/docs/account_data.md index 992d708..07d717c 100644 --- a/docs/account_data.md +++ b/docs/account_data.md @@ -24,7 +24,7 @@ Contains data about client account and settings. ### accountId -The [account id](account#id). +The [account.id](account#id). ### type diff --git a/docs/addons.md b/docs/addons.md index 52fe345..6beac35 100644 --- a/docs/addons.md +++ b/docs/addons.md @@ -8,10 +8,9 @@ | Field | Type | Attributes | Key | Null | Default | Extra | Comment | | -------------- | ------------ | ---------- | --- | ---- | ------- | ------ | ------- | -| [name][1] | VARCHAR(120) | | PRI | NO | '' | PRI | | +| [name][1] | VARCHAR(120) | SIGNED | PRI | NO | '' | PRI | | | [crc][2] | INT | UNSIGNED | | NO | 0 | | | - [1]: #name [2]: #crc @@ -23,4 +22,4 @@ ### crc -`field-no-description|2` \ No newline at end of file +`field-no-description|2` diff --git a/docs/arena_team.md b/docs/arena_team.md index d728f56..1857397 100644 --- a/docs/arena_team.md +++ b/docs/arena_team.md @@ -11,7 +11,7 @@ This table holds the main ArenaTeam information. All created teams or all teams | Field | Type | Attributes | Key | Null | Default | Extra | Comment | | --------------------- | ----------- | ---------- | --- | ---- | ------- | ------ | ------- | | [arenaTeamId][1] | INT | UNSIGNED | PRI | NO | 0 | Unique | | -| [name][2] | VARCHAR(24) | | | NO | | | | +| [name][2] | VARCHAR(24) | SIGNED | | NO | | | | | [captainGuid][3] | INT | UNSIGNED | | NO | 0 | | | | [type][4] | TINYINT | UNSIGNED | | NO | 0 | | | | [rating][5] | SMALLINT | UNSIGNED | | NO | 0 | | | diff --git a/docs/arena_team_member.md b/docs/arena_team_member.md index 607193e..07942a1 100644 --- a/docs/arena_team_member.md +++ b/docs/arena_team_member.md @@ -30,7 +30,7 @@ This table holds arena info about specific team members. All arena\_team members ### arenaTeamId -ID of arena team. See Team Id. +ID of arena team. See [arena\_team#arenateamid]. ### guid @@ -54,4 +54,4 @@ Number of games won this **season**. ### personalrating -The player's personal arena rating. \ No newline at end of file +The player's personal arena rating. diff --git a/docs/auctionhouse.md b/docs/auctionhouse.md index 9e06b61..c295905 100644 --- a/docs/auctionhouse.md +++ b/docs/auctionhouse.md @@ -6,8 +6,6 @@ Contains all information about the currently ongoing auctions in the auction houses. It controls what items are put up for auction and who put it up, who is the highest bidder, etc. -This table is used by Trinity while running and not a table that you would usually edit. - **Structure** | Field | Type | Attributes | Key | Null | Default | Extra | Comment | diff --git a/docs/banned_addons.md b/docs/banned_addons.md index 74fa8e2..431b127 100644 --- a/docs/banned_addons.md +++ b/docs/banned_addons.md @@ -9,9 +9,9 @@ | Field | Type | Attributes | Key | Null | Default | Extra | Comment | | -------------- | ------------ | ---------- | --- | ---- | ----------------- | ------ | ------- | | [Id][1] | INT | UNSIGNED | PRI | NO | | | | -| [Name][2] | VARCHAR(255) | | | NO | | UNIQUE | | -| [Version][3] | VARCHAR(255) | | | NO | '' | UNIQUE | | -| [Timestamp][4] | TIMESTAMP | | | NO | CURRENT_TIMESTAMP | | | +| [Name][2] | VARCHAR(255) | SIGNED | | NO | | UNIQUE | | +| [Version][3] | VARCHAR(255) | SIGNED | | NO | '' | UNIQUE | | +| [Timestamp][4] | TIMESTAMP | SIGNED | | NO | CURRENT_TIMESTAMP | | | [1]: #id [2]: #name @@ -34,4 +34,4 @@ ### Timestamp -`field-no-description|4` \ No newline at end of file +`field-no-description|4` diff --git a/docs/battleground_deserters.md b/docs/battleground_deserters.md index 32a957c..d3c29ca 100644 --- a/docs/battleground_deserters.md +++ b/docs/battleground_deserters.md @@ -4,15 +4,15 @@ **The \`battleground\_deserters\` table** -This table holds datas about BattleGrounds deserters. To enable storing this kind of informations, set **Battleground . TrackDeserters . Enable   =   1** in **worldserver.config** file. +This table holds datas about BattleGrounds deserters. To enable storing this kind of informations, set **Battleground.TrackDeserters.Enable = 1** in **worldserver.config** file. **Structure** | Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|---------------|----------|------------|-----|------|---------|-------|-------------------------- | +| ------------- | -------- | ---------- | --- | ---- | ------- | ----- | ------------------------- | | [guid][1] | INT | UNSIGNED | | NO | | | characters.guid | | [type][2] | TINYINT | UNSIGNED | | NO | | | type of the desertion | -| [datetime][3] | DATETIME | | | NO | | | datetime of the desertion | +| [datetime][3] | DATETIME | SIGNED | | NO | | | datetime of the desertion | [1]: #guid [2]: #type @@ -27,7 +27,7 @@ Link to [characters.guid](characters#guid). ### type | Value | Description | -|-------|---------------------------------------------------------| +| ----- | ------------------------------------------------------- | | 0 | player leaves the BG | | 1 | player is kicked from BG because offline | | 2 | player is invited to join and refuses to do it | diff --git a/docs/bugreport.md b/docs/bugreport.md index e23017d..239d13f 100644 --- a/docs/bugreport.md +++ b/docs/bugreport.md @@ -9,8 +9,8 @@ | Field | Type | Attributes | Key | Null | Default | Extra | Comment | | -------------- | -------- | ---------- | --- | ---- | ------- | -------------- | ---------- | | [id][1] | INT | UNSIGNED | PRI | NO | | AUTO_INCREMENT | Identifier | -| [type][2] | LONGTEXT | | | NO | | | | -| [content][3] | LONGTEXT | | | NO | | | | +| [type][2] | LONGTEXT | SIGNED | | NO | | | | +| [content][3] | LONGTEXT | SIGNED | | NO | | | | [1]: #id [2]: #type @@ -29,4 +29,3 @@ ### content `field-no-description|3` - diff --git a/docs/calendar_events.md b/docs/calendar_events.md index ed5b2c5..3205d16 100644 --- a/docs/calendar_events.md +++ b/docs/calendar_events.md @@ -7,13 +7,13 @@ **Structure** | Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|----------------- |------------- |------------|-----|------|---------|-------|--------- | +| ---------------- | ------------ | ---------- | --- | ---- | ------- | ----- | -------- | | [id][1] | BIGINT | UNSIGNED | PRI | NO | 0 | | | | [creator][2] | INT | UNSIGNED | | NO | 0 | | | -| [title][3] | VARCHAR(255) | | | NO | '' | | | -| [description][4] | VARCHAR(255) | | | NO | '' | | | +| [title][3] | VARCHAR(255) | SIGNED | | NO | '' | | | +| [description][4] | VARCHAR(255) | SIGNED | | NO | '' | | | | [type][5] | TINYINT | UNSIGNED | | NO | 4 | | | -| [dungeon][6] | INT | | | NO | -1 | | | +| [dungeon][6] | INT | SIGNED | | NO | -1 | | | | [eventtime][7] | INT | UNSIGNED | | NO | 0 | | | | [flags][8] | INT | UNSIGNED | | NO | 0 | | | | [time2][9] | INT | UNSIGNED | | NO | 0 | | | @@ -65,4 +65,3 @@ ### time2 `field-no-description|9` - diff --git a/docs/calendar_invites.md b/docs/calendar_invites.md index 7f39990..8d231b5 100644 --- a/docs/calendar_invites.md +++ b/docs/calendar_invites.md @@ -7,7 +7,7 @@ **Structure** | Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|----------------- |------------- |------------|-----|------|---------|-------|--------- | +| ---------------- |------------- |----------- | --- | ---- | ------- | ----- | -------- | | [id][1] | BIGINT | UNSIGNED | PRI | NO | 0 | | | | [event][2] | BIGINT | UNSIGNED | | NO | 0 | | | | [invitee][3] | INT | UNSIGNED | | NO | 0 | | | @@ -15,7 +15,7 @@ | [status][5] | TINYINT | UNSIGNED | | NO | 0 | | | | [statustime][6] | INT | UNSIGNED | | NO | 0 | | | | [rank][7] | TINYINT | UNSIGNED | | NO | 0 | | | -| [text][8] | VARCHAR(255) | | | NO | '' | | | +| [text][8] | VARCHAR(255) | SIGNED | | NO | '' | | | [1]: #id [2]: #event @@ -58,4 +58,4 @@ ### text -`field-no-description|8` \ No newline at end of file +`field-no-description|8` diff --git a/docs/channels.md b/docs/channels.md index 19d9b00..cf8d7ad 100644 --- a/docs/channels.md +++ b/docs/channels.md @@ -6,7 +6,7 @@ Information and settings for ingame, player-based chat channels (not affecting the default system channels). -## Structure +**Structure** | Field | Type | Attributes | Key | Null | Default | Extra | Comment | | --------------- | ------------ | ---------- | --- | ---- | ------- | -------------- | ------- | @@ -43,7 +43,7 @@ Allow access to channel from specified player faction ID. For multirace channels, two (or more) separate entries must exist with the EXACT same settings for all fields apart from this (it needs a different `team id`). | Faction | Value | -|----------|-------| +| -------- | ----- | | Horde | 67 | | Alliance | 469 | @@ -69,4 +69,4 @@ Empty, or a standard string-based password (no spaces allowed). ### lastUsed -Used for automated cleaning of unused channels from database. Time is in unixtime. \ No newline at end of file +Used for automated cleaning of unused channels from database. Time is in unixtime. diff --git a/docs/channels_bans.md b/docs/channels_bans.md index 24ce138..d21f26b 100644 --- a/docs/channels_bans.md +++ b/docs/channels_bans.md @@ -4,7 +4,7 @@ **The \`channels\_bans\` table** -## Structure +**Structure** | Field | Type | Attributes | Key | Null | Default | Extra | Comment | | --------------- | ----- | ---------- | --- | ---- | ------- | ------ | ------- | @@ -20,7 +20,7 @@ ### channelId -The [channel id](channels#channelId). +The [channel.id](channels#channelid). ### playerGUID diff --git a/docs/channels_rights.md b/docs/channels_rights.md index ea5b57f..3e70c24 100644 --- a/docs/channels_rights.md +++ b/docs/channels_rights.md @@ -15,7 +15,6 @@ | [delaymessage][5] | VARCHAR(255) | SIGNED | | NO | '' | | | | [moderators][6] | TEXT | SIGNED | | YES | | | | - [1]: #name [2]: #flags [3]: #speakdelay @@ -47,4 +46,4 @@ ### moderators -`field-no-description|6` \ No newline at end of file +`field-no-description|6` diff --git a/docs/character_account_data.md b/docs/character_account_data.md index 659410b..26b2535 100644 --- a/docs/character_account_data.md +++ b/docs/character_account_data.md @@ -29,7 +29,7 @@ The character global unique identifier. See [characters.guid](characters#guid). ### type | Value | Description | -|-------|------------------------------| +|------ | ---------------------------- | | 1 | Config cache per character | | 3 | Bindings cache per character | | 5 | Macros cache per character | diff --git a/docs/character_achievement.md b/docs/character_achievement.md index 2c1905b..08b0cb7 100644 --- a/docs/character_achievement.md +++ b/docs/character_achievement.md @@ -4,7 +4,7 @@ **The \`character\_achievement\` table** -This table holds information on the achievements a character has earned / completed. +This table holds information on the achievements a character has earned/completed. **Note:** if you delete a "realm first" achievement from the characters database, you have to reboot the server to take it into account. diff --git a/docs/character_action.md b/docs/character_action.md index 7e254eb..81c9a19 100644 --- a/docs/character_action.md +++ b/docs/character_action.md @@ -41,7 +41,7 @@ Special bars are used for stances, auras, pets, stealth, and other similar speci **Possible values** | Button IDs | Set (key) | -|------------|------------------------------------| +| ---------- | ---------------------------------- | | 1-11 | 1 (SHIFT + 1) | | 12-23 | 2 (SHIFT + 2) | | 24-35 | 3 (SHIFT + 3) h1. Right Side Bar | @@ -64,7 +64,7 @@ The type of action: **Possible types** | Value | Description | -|-------|-------------| +| ----- | ----------- | | 0 | Spell | | 1 | Click | | 32 | Eq set | diff --git a/docs/character_arena_stats.md b/docs/character_arena_stats.md index 4c05e71..be49a16 100644 --- a/docs/character_arena_stats.md +++ b/docs/character_arena_stats.md @@ -9,7 +9,7 @@ This table holds information about character's matchmaker rating in all team typ **Structure** | Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|-----------------------|-------------|------------|-----|------|---------|-------|---------| +| --------------------- | ----------- | ---------- | --- | ---- | ------- | ----- | ------- | | [guid][1] | INT | UNSIGNED | PRI | NO | | | | | [slot][2] | TINYINT | UNSIGNED | PRI | NO | | | | | [matchmakerRating][3] | SMALLINT | UNSIGNED | | NO | | | | @@ -31,15 +31,15 @@ The GUID of the character. See [characters.guid](characters#guid). Arena slot index: | Value | Description | -|-------|-------------| +| ----- | ----------- | | 0 | 2v2 | | 1 | 3v3 | | 2 | 5v5 | ### matchmakerRating -Player's matchmaker rating +Player's matchmaker rating. ### maxMMR -`field-no-description|4` \ No newline at end of file +`field-no-description|4` diff --git a/docs/character_aura.md b/docs/character_aura.md index 31c3e4f..a6b9dd1 100644 --- a/docs/character_aura.md +++ b/docs/character_aura.md @@ -9,7 +9,7 @@ Contains aura information that is loaded when a character is loaded, so the aura **Structure** | Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|-----------------------|-----------|------------|-----|------|---------|-------|-------------------------------| +| --------------------- | --------- | ---------- | --- | ---- | ------- | ----- | ----------------------------- | | [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | Global Unique Identifier | | [casterGuid][2] | BIGINT | UNSIGNED | PRI | NO | 0 | | Full Global Unique Identifier | | [itemGuid][3] | BIGINT | UNSIGNED | PRI | NO | 0 | | | @@ -37,9 +37,9 @@ Contains aura information that is loaded when a character is loaded, so the aura [8]: #amount [9]: #amount [10]: #amount -[11]: #base_amount0 -[12]: #base_amount1 -[13]: #base_amount2 +[11]: #baseamount0 +[12]: #baseamount1 +[13]: #baseamount2 [14]: #maxduration [15]: #remaintime [16]: #remaincharges diff --git a/docs/character_banned.md b/docs/character_banned.md index 3b8e508..70be80e 100644 --- a/docs/character_banned.md +++ b/docs/character_banned.md @@ -9,7 +9,7 @@ This table lists all of the characters that have been banned along with the date **Structure** | Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|----------------|--------------|------------|-----|------|---------|-------|--------------------------| +| -------------- | ------------ | ---------- | --- | ---- | ------- | ----- | ------------------------ | | [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | Global Unique Identifier | | [bandate][2] | INT | UNSIGNED | PRI | NO | 0 | | | | [unbandate][3] | INT | UNSIGNED | | NO | 0 | | | @@ -48,4 +48,4 @@ The reason for the ban. ### active -Boolean 0 or 1 controlling if the ban is currently active or not. \ No newline at end of file +Boolean 0 or 1 controlling if the ban is currently active or not. diff --git a/docs/character_battleground_random.md b/docs/character_battleground_random.md new file mode 100644 index 0000000..cb43cf9 --- /dev/null +++ b/docs/character_battleground_random.md @@ -0,0 +1,21 @@ +# character\_battleground\_random + +[<-Back-to:Characters](database-characters.md) + +**The \`character\_battleground\_random\` table** + +This table stores battlegrounds IDs for random battleground sessions. + +**Structure** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| --------- | -------- | ---------- | --- | ---- | ------- | ----- | ------- | +| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | | + +[1]: #guid + +**Description of the fields** + +### guid + +The guid of the character who has already won random battleground today. See [characters.guid](characters#guid). diff --git a/docs/character_brew_of_the_month.md b/docs/character_brew_of_the_month.md index 59ab127..5014769 100644 --- a/docs/character_brew_of_the_month.md +++ b/docs/character_brew_of_the_month.md @@ -7,7 +7,7 @@ **Structure** | Field | Type | Attributes | Key | Null | Default | Extra | Comment | -| ---------------- | ---- | ---------- | --- | ---- | ------- | ----- | ------- | +| ---------------- | ---- | ---------- | --- | ---- | ------- | ----- | -------- | | [guid][1] | INT | UNSIGNED | PRI | NO | | | | | [lastEventId][2] | INT | UNSIGNED | | NO | 0 | | | @@ -22,4 +22,4 @@ ### lastEventId -`field-no-description|2` \ No newline at end of file +`field-no-description|2` diff --git a/docs/character_declinedname.md b/docs/character_declinedname.md index 5fac181..1b5009d 100644 --- a/docs/character_declinedname.md +++ b/docs/character_declinedname.md @@ -7,7 +7,7 @@ **Structure** | Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|--------------------|-------------|------------|-----|------|---------|-------|--------------------------| +| ------------------ | ----------- | ---------- | --- | ---- | ------- | ----- | ------------------------ | | [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | Global Unique Identifier | | [genitive][2] | VARCHAR(15) | SIGNED | | NO | '' | | | | [dative][3] | VARCHAR(15) | SIGNED | | NO | '' | | | diff --git a/docs/character_entry_point.md b/docs/character_entry_point.md index 9189be9..512a44a 100644 --- a/docs/character_entry_point.md +++ b/docs/character_entry_point.md @@ -58,4 +58,4 @@ Map Identifier. ### mountSpell -`field-no-description|8` \ No newline at end of file +`field-no-description|8` diff --git a/docs/character_equipmentsets.md b/docs/character_equipmentsets.md index eb3adf3..3075ea1 100644 --- a/docs/character_equipmentsets.md +++ b/docs/character_equipmentsets.md @@ -41,26 +41,26 @@ This table holds info about player's equipment manager settings. [3]: #setindex [4]: #name [5]: #iconname -[6]: #ignore_mask -[7]: #item0 -[8]: #item1 -[9]: #item2 -[10]: #item3 -[11]: #item4 -[12]: #item5 -[13]: #item6 -[14]: #item7 -[15]: #item8 -[16]: #item9 -[17]: #item10 -[18]: #item11 -[19]: #item12 -[20]: #item13 -[21]: #item14 -[22]: #item15 -[23]: #item16 -[24]: #item17 -[25]: #item18 +[6]: #ignoremask +[7]: #item +[8]: #item +[9]: #item +[10]: #item +[11]: #item +[12]: #item +[13]: #item +[14]: #item +[15]: #item +[16]: #item +[17]: #item +[18]: #item +[19]: #item +[20]: #item +[21]: #item +[22]: #item +[23]: #item +[24]: #item +[25]: #item **Description of the fields** @@ -88,12 +88,12 @@ Name taken from ItemDisplayInfo.dbc, column 6. `field-no-description|6` -### item0-18 +### item Values taken from [item\_instance.guid](item_instance#guid). | ID | Name | -|----|-----------| +| -- | --------- | | 0 | Head | | 1 | Neck | | 2 | Shoulder | diff --git a/docs/character_gifts.md b/docs/character_gifts.md index 7d38247..13fd319 100644 --- a/docs/character_gifts.md +++ b/docs/character_gifts.md @@ -28,7 +28,7 @@ The GUID of the character. See [characters.guid](characters#guid). ### item\_guid -The GUID of the item. See [item\_instance.guid](item_instance#guid) +The GUID of the item. See [item\_instance.guid](item_instance#guid). ### entry diff --git a/docs/character_instance.md b/docs/character_instance.md index 489b2b0..756eafd 100644 --- a/docs/character_instance.md +++ b/docs/character_instance.md @@ -36,4 +36,4 @@ Boolean 0 or 1 controlling if the player has been bound to the instance. A playe ### extended -`field-no-description|4` \ No newline at end of file +`field-no-description|4` diff --git a/docs/character_inventory.md b/docs/character_inventory.md index 623afae..4bea93e 100644 --- a/docs/character_inventory.md +++ b/docs/character_inventory.md @@ -37,7 +37,7 @@ If the bag field is non-zero, then the slot is the slot in the bag where the ite If the bag field is zero, then the slot has a range of 0 to 130 and the value stands for the following: | Slot | Value | -|---------|----------------------------------------| +| ------- | -------------------------------------- | | 0 | Head | | 1 | Neck | | 2 | Shoulders | diff --git a/docs/character_queststatus.md b/docs/character_queststatus.md index 09bbc87..ed8c86a 100644 --- a/docs/character_queststatus.md +++ b/docs/character_queststatus.md @@ -9,7 +9,7 @@ Holds information on the quest status of each character. **Structure** | Field | Type | Attributes | Key | Null | Default | Extra | Comment | -| ----------------- | -------- | ---------- | --- | ---- | ------- |-------|--------------------------| +| ----------------- | -------- | ---------- | --- | ---- | ------- |------ | ------------------------ | | [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | Global Unique Identifier | | [quest][2] | INT | UNSIGNED | PRI | NO | 0 | | Quest Identifier | | [status][3] | TINYINT | UNSIGNED | | NO | 0 | | | @@ -61,7 +61,7 @@ The current quest status. **Possible values** | Value | Status | Comments | -|-------|----------------------------|---------------------------------------------| +| ----- | -------------------------- | ------------------------------------------- | | 0 | QUEST\_STATUS\_NONE | Quest isn't shown in quest list; default | | 1 | QUEST\_STATUS\_COMPLETE | Quest has been completed | | 2 | QUEST\_STATUS\_UNAVAILABLE | NOT USED | diff --git a/docs/character_queststatus_daily.md b/docs/character_queststatus_daily.md index 822ef6e..e95a8ba 100644 --- a/docs/character_queststatus_daily.md +++ b/docs/character_queststatus_daily.md @@ -9,7 +9,7 @@ Holds information on the daily quest status of every player. The quest must have **Structure** | Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|------------|---------|------------|-----|------|---------|-------|--------------------------| +|----------- | ------- | ---------- | --- | ---- | ------- | ----- | ------------------------ | | [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | Global Unique Identifier | | [quest][2] | INT | UNSIGNED | PRI | NO | 0 | | Quest Identifier | | [time][3] | INT | UNSIGNED | | NO | 0 | | | @@ -26,7 +26,7 @@ The character GUID. See [characters.guid](characters#guid). ### quest -The quest ID of the daily quest. See [quest\_template.entry](quest\_template.entry). +The quest ID of the daily quest. See [quest\_template.entry](quest\_template#entry). ### time diff --git a/docs/character_queststatus_monthly.md b/docs/character_queststatus_monthly.md index a4c0cd0..95ec323 100644 --- a/docs/character_queststatus_monthly.md +++ b/docs/character_queststatus_monthly.md @@ -14,7 +14,6 @@ [1]: #guid [2]: #quest - **Description of the fields** ### guid @@ -23,4 +22,4 @@ The character guid. See [characters.guid](characters#guid). ### quest -The quest ID of the rewarded quest. See [quest\_template.id](quest_template#id). \ No newline at end of file +The quest ID of the rewarded quest. See [quest\_template.id](quest_template#id). diff --git a/docs/character_reputation.md b/docs/character_reputation.md index bea2165..86c683b 100644 --- a/docs/character_reputation.md +++ b/docs/character_reputation.md @@ -39,7 +39,7 @@ The current reputation value that the character has. This field is a bitmask containing flags that apply to the faction and how it's displayed to the character. Just like any flag field, you can combine flags by adding them together. If this field is 0, then it is not shown in the reputation list in-game. | Flag | Name | Comments | -|------|-------------------------------|--------------------------------------------------------------------------| +|----- | ----------------------------- | ------------------------------------------------------------------------ | | 1 | FACTION_FLAG_VISIBLE | Displayed in the reputation tab | | 2 | FACTION_FLAG_AT_WAR | Active when the player sets the at war checkbox | | 4 | FACTION_FLAG_HIDDEN | Hidden faction from reputation pane in client | diff --git a/docs/character_social.md b/docs/character_social.md index c705f9d..8497e38 100644 --- a/docs/character_social.md +++ b/docs/character_social.md @@ -4,7 +4,7 @@ **The \`character\_social\` table** -Contains data about characters' friends/ignored list. +Contains data about character's friends/ignored list. **Structure** @@ -33,7 +33,7 @@ The GUID of the friend/ignored. See [characters.guid](characters#guid). ### flags | Value | Description | -|-------|---------------------------------------------------------------------------| +|------ | ------------------------------------------------------------------------- | | 0 | Unused entry - previously listed as friend or blocked (removed/unblocked) | | 1 | Added as friend | | 2 | Added as blocked user | diff --git a/docs/character_spell.md b/docs/character_spell.md index 7198c92..a59078b 100644 --- a/docs/character_spell.md +++ b/docs/character_spell.md @@ -30,4 +30,4 @@ The spell ID. See [Spell.dbc](spell) column 1. ### specMask -Boolean 1 or 0 signifying whether the spell is active (appears in the spell book). \ No newline at end of file +Boolean 1 or 0 signifying whether the spell is active (appears in the spell book). diff --git a/docs/character_spell_cooldown.md b/docs/character_spell_cooldown.md index f64eced..be66856 100644 --- a/docs/character_spell_cooldown.md +++ b/docs/character_spell_cooldown.md @@ -42,4 +42,4 @@ The time when the spell cooldown will finish, measured in [Unix time](http://en. ### needSend -`field-no-description|5` \ No newline at end of file +`field-no-description|5` diff --git a/docs/character_talent.md b/docs/character_talent.md index b83a992..5fc01a7 100644 --- a/docs/character_talent.md +++ b/docs/character_talent.md @@ -33,4 +33,4 @@ The spell ID. See [Spell.dbc](spell) column 1. | Value | Data | | ----- | ------------------ | | 0 | is the first spec | -| 1 | is the second spec | \ No newline at end of file +| 1 | is the second spec | diff --git a/docs/characters.md b/docs/characters.md index 9370541..47cff28 100644 --- a/docs/characters.md +++ b/docs/characters.md @@ -6,7 +6,7 @@ This table holds vital static information for each character. It is used to create the player objects in-game. -## Structure +**Structure** | Field | Type | Attributes | Key | Null | Default | Extra | Comment | | -------------------------- | ------------ | ---------- | --- | ---- | ----------------- | ------ | ------------------------ | @@ -280,7 +280,6 @@ A bitmask that represents what Player flags the player has. Each bit controls a | 16777216 | 0x01000000 | PLAYER_FLAGS_UNK25 | disabled all melee ability on tab include autoattack | | 33554432 | 0x02000000 | PLAYER_FLAGS_NO_XP_GAIN | | - ### position\_x The x position of the character's location. @@ -573,4 +572,4 @@ Stores the name of character if the character is deleted and CharDelete.Method i ### deleteDate -Stores the date when the character was deleted and CharDelete.Method in worldserver.conf.dist is set to 1. Will be checked by worldserver against CharDelete.KeepDays in worldserver.conf.dist. If this value is lower than deleteDate + CharDelete.KeepDays the character will be purged. \ No newline at end of file +Stores the date when the character was deleted and CharDelete.Method in worldserver.conf.dist is set to 1. Will be checked by worldserver against CharDelete.KeepDays in worldserver.conf.dist. If this value is lower than deleteDate + CharDelete.KeepDays the character will be purged. diff --git a/docs/corpse.md b/docs/corpse.md index 45ebe73..05a5500 100644 --- a/docs/corpse.md +++ b/docs/corpse.md @@ -112,4 +112,4 @@ The character guid. See [characters.guid](characters#guid). ### instanceId -`field-no-description|17` \ No newline at end of file +`field-no-description|17` diff --git a/docs/creature_respawn.md b/docs/creature_respawn.md index 4158e84..14ae514 100644 --- a/docs/creature_respawn.md +++ b/docs/creature_respawn.md @@ -36,4 +36,4 @@ The time when the creature should be respawned in Unix time. ### instance -If the creature was killed in an instance, this field holds the instance ID where this creature should be respawned. Each instance is different depending on the group so this field is vital in keeping track of which creatures should be respawned for which players at what time. \ No newline at end of file +If the creature was killed in an instance, this field holds the instance ID where this creature should be respawned. Each instance is different depending on the group so this field is vital in keeping track of which creatures should be respawned for which players at what time. diff --git a/docs/database-characters.md b/docs/database-characters.md index d0adc36..352a537 100644 --- a/docs/database-characters.md +++ b/docs/database-characters.md @@ -1,4 +1,6 @@ -NOTE: the DB documentation is still a work in progress. We need your help to make it better, please read [this](https://github.com/azerothcore/wiki/issues/11). +# Database Characters + +The auth database currently has 95 tables, which mainly store information related to user accounts. Although some of them have other functionalities. The last synchronization was done: [20-07-2021](https://github.com/azerothcore/wiki/pull/584). If you detect that any table is outdated, you can create an [issue](https://github.com/azerothcore/wiki/issues) within our repository or make a [pull request](https://github.com/azerothcore/wiki/pulls) with the modification of the information. - [account_data](account_data.md) - [account_instance_times](account_instance_times.md) diff --git a/docs/game_event_condition_save.md b/docs/game_event_condition_save.md index 4120a42..c248ef6 100644 --- a/docs/game_event_condition_save.md +++ b/docs/game_event_condition_save.md @@ -28,4 +28,4 @@ See [game\_event\_condition.condition\_id](game_event_condition#condition_id). ### done -Indicates how much has been done. See [game\_event\_condition.req\_num](game_event_condition#req_num). \ No newline at end of file +Indicates how much has been done. See [game\_event\_condition.req\_num](game_event_condition#req_num). diff --git a/docs/game_event_save.md b/docs/game_event_save.md index af701b7..b6de7f6 100644 --- a/docs/game_event_save.md +++ b/docs/game_event_save.md @@ -14,7 +14,7 @@ [1]: #evententry [2]: #state -[3]: #next_start +[3]: #nextstart **Description of the fields** @@ -28,4 +28,4 @@ ### next\_start -`field-no-description|3` \ No newline at end of file +`field-no-description|3` diff --git a/docs/gameobject_respawn.md b/docs/gameobject_respawn.md index 14c8e0c..d1c80cc 100644 --- a/docs/gameobject_respawn.md +++ b/docs/gameobject_respawn.md @@ -36,4 +36,4 @@ The time when the game object should be respawned in Unix time. ### instanceId -If the game object belonged in an instance, this field holds the instance ID where this game object should be respawned. Each instance is different depending on the group so this field is vital in keeping track of which game objects should be respawned for which players at what time. \ No newline at end of file +If the game object belonged in an instance, this field holds the instance ID where this game object should be respawned. Each instance is different depending on the group so this field is vital in keeping track of which game objects should be respawned for which players at what time. diff --git a/docs/gm_subsurvey.md b/docs/gm_subsurvey.md index 0bfec27..b8f3a60 100644 --- a/docs/gm_subsurvey.md +++ b/docs/gm_subsurvey.md @@ -2,7 +2,7 @@ [<-Back-to:Characters](database-characters.md) -## The \`gm\_subsurvey\` table +**The \`gm\_subsurvey\` table** This table contains the answers to the survey questions. It's linked to `gm_survey`. @@ -36,4 +36,4 @@ This table contains the answers to the survey questions. It's linked to `gm_surv ### answerComment -`field-no-description|4` \ No newline at end of file +`field-no-description|4` diff --git a/docs/gm_survey.md b/docs/gm_survey.md index 129276e..17f9bf1 100644 --- a/docs/gm_survey.md +++ b/docs/gm_survey.md @@ -46,4 +46,4 @@ ### maxMMR -`field-no-description|6` \ No newline at end of file +`field-no-description|6` diff --git a/docs/gm_ticket.md b/docs/gm_ticket.md index fbabb9e..9c02718 100644 --- a/docs/gm_ticket.md +++ b/docs/gm_ticket.md @@ -2,7 +2,7 @@ [<-Back-to:Characters](database-characters.md) -## The \`gm\_tickets\` table +**The \`gm\_tickets\` table** This table stores all tickets. diff --git a/docs/group_member.md b/docs/group_member.md index 99bfb29..bdaf576 100644 --- a/docs/group_member.md +++ b/docs/group_member.md @@ -33,7 +33,7 @@ GUID of the group. See [groups.guid](groups#guid). GUID of the character member of the group. See [characters.guid](characters#guid). | Name | Value | Unique | -|------------------------|-------|--------| +|----------------------- | ----- | ------ | | MEMBER_FLAG_ASSISTANT | 0x01 | | | MEMBER_FLAG_MAINTANK | 0x02 | (U) | | MEMBER_FLAG_MAINASSIST | 0x04 | (U) | @@ -48,9 +48,9 @@ There can only be 5 membes in one subgroup per raid group. ### roles | Value | Name | Comments | -|-------|-------------|------------------------------------------------------------------| +|------ | ----------- | ---------------------------------------------------------------- | | 0 | ROLE_NONE | | | 1 | ROLE_LEADER | The character has signed to Random Dungeon Finder as experienced | | 2 | ROLE_TANK | The character has signed to Random Dungeon Finder as tank | | 4 | ROLE_HEALER | The character has signed to Random Dungeon Finder as healer | -| 8 | ROLE_DAMAGE | The character has signed to Random Dungeon Finder as dps | \ No newline at end of file +| 8 | ROLE_DAMAGE | The character has signed to Random Dungeon Finder as dps | diff --git a/docs/groups.md b/docs/groups.md index 03fd88c..11a846b 100644 --- a/docs/groups.md +++ b/docs/groups.md @@ -59,7 +59,7 @@ The GUID of the character. See [characters.guid](characters#guid). ### lootMethod | Value | Name | Comments | -|-------|-------------------|----------| +|------ | ----------------- | -------- | | 0 | FREE_FOR_ALL | | | 1 | ROUND_ROBIN | | | 2 | MASTER_LOOT | | @@ -82,7 +82,7 @@ If [lootMethod](groups#lootmethod) is not 2, then it's group leader's guid. ### groupType | Value | Name | Comments | -|-------|------------------|----------------------------------------| +|------ | ---------------- | -------------------------------------- | | 0 | GROUPTYPE_NORMAL | | | 1 | GROUPTYPE_BG | | | 2 | GROUPTYPE_RAID | | @@ -100,4 +100,4 @@ If [lootMethod](groups#lootmethod) is not 2, then it's group leader's guid. ### masterLooterGuid -`field-no-description|17` \ No newline at end of file +`field-no-description|17` diff --git a/docs/guild.md b/docs/guild.md index 7ffe105..49f9c84 100644 --- a/docs/guild.md +++ b/docs/guild.md @@ -84,4 +84,4 @@ The date when the guild was created. ### BankMoney -The total money, in copper, that is currently in the guild's guild bank. \ No newline at end of file +The total money, in copper, that is currently in the guild's guild bank. diff --git a/docs/guild_bank_eventlog.md b/docs/guild_bank_eventlog.md index dbe24b3..a5a7737 100644 --- a/docs/guild_bank_eventlog.md +++ b/docs/guild_bank_eventlog.md @@ -74,4 +74,4 @@ Destination Tab Id. ### TimeStamp -Event UNIX time. \ No newline at end of file +Event UNIX time. diff --git a/docs/guild_bank_item.md b/docs/guild_bank_item.md index bfdb4b4..e79b0ce 100644 --- a/docs/guild_bank_item.md +++ b/docs/guild_bank_item.md @@ -18,7 +18,7 @@ This table holds all item information for items that are stored in the guild ban [1]: #guildid [2]: #tabid [3]: #slotid -[4]: #item_guid +[4]: #itemguid **Description of the fields** @@ -36,4 +36,4 @@ The slot that the item is placed in in the tab. ### item\_guid -The item guid. See [item\_instance.guid](item_instance#guid). \ No newline at end of file +The item guid. See [item\_instance.guid](item_instance#guid). diff --git a/docs/guild_bank_right.md b/docs/guild_bank_right.md index 80c6566..b2b16d5 100644 --- a/docs/guild_bank_right.md +++ b/docs/guild_bank_right.md @@ -43,7 +43,7 @@ The permissions you want to give to a player of that rank on the tab. This is a FLAGS: | Value | Description | -|-------|------------------------------------------------| +|------ | ---------------------------------------------- | | 1 | view items | | 2 | deposit items | | 4 | update item name shown when navigating the tab | @@ -52,4 +52,4 @@ FLAGS: ### SlotPerDay -The number of items that a player can withdraw per day (if permissions give him the right to withdraw items). \ No newline at end of file +The number of items that a player can withdraw per day (if permissions give him the right to withdraw items). diff --git a/docs/guild_bank_tab.md b/docs/guild_bank_tab.md index efe563c..039eccb 100644 --- a/docs/guild_bank_tab.md +++ b/docs/guild_bank_tab.md @@ -9,7 +9,7 @@ This table holds information on all the tabs in use for all guilds that make use **Structure** | Field | Type | Attributes | Key | Null | Default | Extra | Comment | -| ------------ | ------------ | ---------- | --- | ---- | ------- | ----- | --------| +| ------------ | ------------ | ---------- | --- | ---- | ------- | ----- | ------- | | [guildid][1] | INT | UNSIGNED | PRI | NO | 0 | | | | [TabId][2] | TINYINT | UNSIGNED | PRI | NO | 0 | | | | [TabName][3] | VARCHAR(16) | SIGNED | | NO | " | | | @@ -42,4 +42,4 @@ The icon assigned to the tab. ### TabText -The text assigned to the tab. \ No newline at end of file +The text assigned to the tab. diff --git a/docs/guild_eventlog.md b/docs/guild_eventlog.md index d8fb2a2..93d2562 100644 --- a/docs/guild_eventlog.md +++ b/docs/guild_eventlog.md @@ -59,4 +59,4 @@ New rank (in case of promotion/demotion). ### timestamp -Event UNIX time. \ No newline at end of file +Event UNIX time. diff --git a/docs/guild_member.md b/docs/guild_member.md index eb935b2..f636792 100644 --- a/docs/guild_member.md +++ b/docs/guild_member.md @@ -42,4 +42,4 @@ The note set by the player that can be read by everyone. ### offnote -The note set by officers in the guild that can only be read by other officers of the guild. \ No newline at end of file +The note set by officers in the guild that can only be read by other officers of the guild. diff --git a/docs/guild_member_withdraw.md b/docs/guild_member_withdraw.md index bfc0b03..7c3a03b 100644 --- a/docs/guild_member_withdraw.md +++ b/docs/guild_member_withdraw.md @@ -38,4 +38,4 @@ ### money -`field-no-description|8` \ No newline at end of file +`field-no-description|8` diff --git a/docs/guild_rank.md b/docs/guild_rank.md index 363e722..5b01c87 100644 --- a/docs/guild_rank.md +++ b/docs/guild_rank.md @@ -64,4 +64,4 @@ The rights a player with this rank has in the guild. The calculation of multiple ### BankMoneyPerDay -The total money per day, in copper, that a person with this rank can take out. Use the maximum value of an UNSIGNED INT (4294967295) to specify unlimited amount. \ No newline at end of file +The total money per day, in copper, that a person with this rank can take out. Use the maximum value of an UNSIGNED INT (4294967295) to specify unlimited amount. diff --git a/docs/instance.md b/docs/instance.md index 93a50f3..ea3a5bb 100644 --- a/docs/instance.md +++ b/docs/instance.md @@ -56,4 +56,4 @@ The difficulty of the current instance. ### data -Specific data belonging to the individual instance. \ No newline at end of file +Specific data belonging to the individual instance. diff --git a/docs/instance_reset.md b/docs/instance_reset.md index 996e35d..bb4b1e4 100644 --- a/docs/instance_reset.md +++ b/docs/instance_reset.md @@ -9,7 +9,7 @@ Date and time when heroic and raid instances will be reset (i.e. instances which **Structure** | Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|-----------------|-------------|------------|-----|------|---------|-------|---------| +|---------------- | ----------- | ---------- | --- | ---- | ------- | ----- | ------- | | [mapid][1] | SMALLINT | UNSIGNED | PRI | NO | 0 | | | | [difficulty][2] | TINYINT | UNSIGNED | PRI | NO | 0 | | | | [resettime][3] | INT | UNSIGNED | | NO | 0 | | | diff --git a/docs/item_instance.md b/docs/item_instance.md index f3fbd25..dee57f5 100644 --- a/docs/item_instance.md +++ b/docs/item_instance.md @@ -8,26 +8,26 @@ This table holds individual item instance information for all items currently eq **Structure** -| Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|------------------------|--------------|------------|-----|------|---------|-------|---------| -| [guid][1] | INT | UNSIGNED | PRI | NO | | | | -| [itemEntry][2] | MEDIUMINT | UNSIGNED | | NO | | | | -| [owner_guid][3] | INT | UNSIGNED | | NO | | | | -| [creatorGuid][4] | INT | UNSIGNED | | NO | | | | -| [giftCreatorGuid][5] | INT | UNSIGNED | | NO | | | | -| [count][6] | INT | UNSIGNED | | NO | | | | -| [duration][7] | INT | UNSIGNED | | NO | | | | -| [charges][8] | tinytext | | | YES | NULL | | | -| [flags][9] | mediunint(8) | UNSIGNED | | NO | | | | -| [enchantments][10] | text | | | NO | | | | -| [randomPropertyId][11] | SMALLINT | SIGNED | | NO | | | | -| [durability][12] | SMALLINT | UNSIGNED | | NO | | | | -| [playedTime][13] | INT | UNSIGNED | | NO | | | | -| [text][14] | text | | | YES | NULL | | | +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ---------------------- | --------- | ---------- | --- | ---- | ------- | ----- | ------- | +| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | | +| [itemEntry][2] | MEDIUMINT | UNSIGNED | | NO | 0 | | | +| [owner_guid][3] | INT | UNSIGNED | | NO | 0 | | | +| [creatorGuid][4] | INT | UNSIGNED | | NO | 0 | | | +| [giftCreatorGuid][5] | INT | UNSIGNED | | NO | 0 | | | +| [count][6] | INT | UNSIGNED | | NO | 1 | | | +| [duration][7] | INT | SIGNED | | NO | 0 | | | +| [charges][8] | TINYTEXT | SIGNED | | YES | | | | +| [flags][9] | MEDIUNINT | UNSIGNED | | NO | 0 | | | +| [enchantments][10] | TEXT | SIGNED | | NO | | | | +| [randomPropertyId][11] | SMALLINT | SIGNED | | NO | 0 | | | +| [durability][12] | SMALLINT | UNSIGNED | | NO | 0 | | | +| [playedTime][13] | INT | UNSIGNED | | NO | 0 | | | +| [text][14] | TEXT | SIGNED | | YES | | | | [1]: #guid [2]: #itementry -[3]: #owner_guid +[3]: #ownerguid [4]: #creatorguid [5]: #giftcreatorguid [6]: #count @@ -48,19 +48,19 @@ The GUID of the item. This number is unique for each item instance. ### itemEnry -[Item](item_template_2130222.html#item_template-entry) entry. +[Item_template.entry](item_template#entry). ### owner\_guid -The GUID of the character who has ownership of this item. See [characters.guid](2129969.html#characters(table)-guid) +The GUID of the character who has ownership of this item. See [characters.guid](characters#guid). ### creatorGuid -[GUID](2129969.html#characters(table)-guid) of character who created the item. +[Characters.guid](characters#guid) of character who created the item. ### giftCreatorGuid -[GUID](2129969.html#characters(table)-guid) of character who created the [item](character_gifts_2129986.html#character_gifts-item_guid). +[Characters.guid](characters#guid) of character who created the [item](character_gifts#item_guid). ### count @@ -72,7 +72,7 @@ Current number of item copies in the stack. ### charges -`The number of charges for each of the five possible spellcharges on an item,  specified via five space separated integers.` +The number of charges for each of the five possible spellcharges on an item, specified via five space separated integers. ### flags @@ -92,10 +92,8 @@ Current item durability. ### playedTime -Time in seconds +Time in seconds. ### text The text contained in that specific item. - -data-anchor= diff --git a/docs/item_loot_storage.md b/docs/item_loot_storage.md index 462ee33..80df576 100644 --- a/docs/item_loot_storage.md +++ b/docs/item_loot_storage.md @@ -26,12 +26,12 @@ [3]: #count [4]: #randompropertyid [5]: #randomsuffix -[6]: #follow_loot_rules +[6]: #followlootrules [7]: #freeforall -[8]: #is_blocked -[9]: #is_counted -[10]: #is_underthreshold -[11]: #needs_quest +[8]: #isblocked +[9]: #iscounted +[10]: #isunderthreshold +[11]: #needsquest [12]: #conditionlootid **Description of the fields** @@ -56,7 +56,7 @@ `field-no-description|5` -### follow_loot_rules +### follow\_loot\_rules `field-no-description|6` @@ -64,22 +64,22 @@ `field-no-description|7` -### is_blocked +### is\_blocked `field-no-description|8` -### is_counted +### is\_counted `field-no-description|9` -### is_underthreshold +### is\_underthreshold `field-no-description|10` -### needs_quest +### needs\_quest `field-no-description|11` ### conditionLootId -`field-no-description|12` \ No newline at end of file +`field-no-description|12` diff --git a/docs/item_refund_instance.md b/docs/item_refund_instance.md index bed14ef..f7e862d 100644 --- a/docs/item_refund_instance.md +++ b/docs/item_refund_instance.md @@ -15,8 +15,8 @@ This table serves as a receipt of refundable purchases during a 2 hour ingame ti | [paidMoney][3] | INT | UNSIGNED | | NO | 0 | | | | [paidExtendedCost][4] | SMALLINT | UNSIGNED | | NO | 0 | | | -[1]: #item_guid -[2]: #player_guid +[1]: #itemguid +[2]: #playerguid [3]: #paidmoney [4]: #paidextendedcost @@ -36,4 +36,4 @@ The amount of money (in copper) paid for the item. ### paidExtendedCost -The ItemExtendedCost.dbc ID that was paid for the item. \ No newline at end of file +The ItemExtendedCost.dbc ID that was paid for the item. diff --git a/docs/item_soulbound_trade_data.md b/docs/item_soulbound_trade_data.md index 4855a44..0e199a2 100644 --- a/docs/item_soulbound_trade_data.md +++ b/docs/item_soulbound_trade_data.md @@ -24,4 +24,4 @@ The GUID of the item that can be traded. See [item\_instance.guid](item_instance ### alowedPlayers -GUIDs of players eligible for the trade separated by space. See [characters.guid](characters#guid). \ No newline at end of file +GUIDs of players eligible for the trade separated by space. See [characters.guid](characters#guid). diff --git a/docs/lag_reports.md b/docs/lag_reports.md index b4a6a0d..8d43b47 100644 --- a/docs/lag_reports.md +++ b/docs/lag_reports.md @@ -6,7 +6,7 @@ This table stores the lag reports made by players ingame (when they click on "Help Request"). -## Structure +**Structure** | Field | Type | Attributes | Key | Null | Default | Extra | Comment | | --------------- | -------- | ---------- | --- | ---- | ------- | -------------- | ------- | @@ -30,7 +30,7 @@ This table stores the lag reports made by players ingame (when they click on "He [8]: #latency [9]: #createtime -## Description of the fields +**Description of the fields** ### reportId diff --git a/docs/log_arena_fights.md b/docs/log_arena_fights.md index adf2ff5..5bdb7ac 100644 --- a/docs/log_arena_fights.md +++ b/docs/log_arena_fights.md @@ -88,4 +88,4 @@ ### curronline -`field-no-description|13` \ No newline at end of file +`field-no-description|13` diff --git a/docs/log_arena_memberstats.md b/docs/log_arena_memberstats.md index 2e448f3..7faa1cf 100644 --- a/docs/log_arena_memberstats.md +++ b/docs/log_arena_memberstats.md @@ -70,4 +70,4 @@ ### kblows -`field-no-description|10` \ No newline at end of file +`field-no-description|10` diff --git a/docs/log_encounter.md b/docs/log_encounter.md index eddf7a7..eedc8df 100644 --- a/docs/log_encounter.md +++ b/docs/log_encounter.md @@ -46,4 +46,4 @@ ### playersInfo -`field-no-description|6` \ No newline at end of file +`field-no-description|6` diff --git a/docs/log_money.md b/docs/log_money.md index fa937ac..9a789ac 100644 --- a/docs/log_money.md +++ b/docs/log_money.md @@ -64,4 +64,4 @@ ### date -`field-no-description|9` \ No newline at end of file +`field-no-description|9` diff --git a/docs/mail.md b/docs/mail.md index b477a1c..17ba0b8 100644 --- a/docs/mail.md +++ b/docs/mail.md @@ -34,9 +34,9 @@ This table contains main data about all mails in the game. [6]: #receiver [7]: #subject [8]: #body -[9]: #has_items -[10]: #expire_time -[11]: #deliver_time +[9]: #hasitems +[10]: #expiretime +[11]: #delivertime [12]: #money [13]: #cod [14]: #checked @@ -129,4 +129,4 @@ when is set to 1, that field \`money\` stores gold for COD. ### auctionId -`field-no-description|14` \ No newline at end of file +`field-no-description|14` diff --git a/docs/mail_items.md b/docs/mail_items.md index 9dfa338..e5bd3d7 100644 --- a/docs/mail_items.md +++ b/docs/mail_items.md @@ -14,8 +14,8 @@ This table contains data regarding items from item\_instance which are being sen | [item_guid][2] | INT | UNSIGNED | PRI | NO | 0 | | | | [receiver][3] | INT | UNSIGNED | | NO | 0 | | Character Global Unique Identifier | -[1]: #mail_id -[2]: #item_guid +[1]: #mailid +[2]: #itemguid [3]: #receiver **Description of the fields** @@ -30,4 +30,4 @@ This is the guid of the item from [item\_instance.guid](item_instance#guid). ### receiver -Character guid which should receive this item. \ No newline at end of file +Character guid which should receive this item. diff --git a/docs/pet_aura.md b/docs/pet_aura.md index a67da4b..5f5dd27 100644 --- a/docs/pet_aura.md +++ b/docs/pet_aura.md @@ -84,4 +84,4 @@ The time remaining in seconds on the aura. -1 means that the aura is indefinite. ### remainCharges -The number of charges remaining on the aura. \ No newline at end of file +The number of charges remaining on the aura. diff --git a/docs/pet_spell.md b/docs/pet_spell.md index 8490872..9e348a7 100644 --- a/docs/pet_spell.md +++ b/docs/pet_spell.md @@ -30,4 +30,4 @@ The spell ID. See [Spell.dbc](spell) column 1. ### active -Boolean 0 or 1 controlling if the spell is active or not. \ No newline at end of file +Boolean 0 or 1 controlling if the spell is active or not. diff --git a/docs/pet_spell_cooldown.md b/docs/pet_spell_cooldown.md index cfe4446..8d597f1 100644 --- a/docs/pet_spell_cooldown.md +++ b/docs/pet_spell_cooldown.md @@ -30,4 +30,4 @@ The spell ID to which the cooldown applies. See [Spell.dbc](spell) column 1. ### time -The time when the cooldown expires, in Unix time. \ No newline at end of file +The time when the cooldown expires, in Unix time. diff --git a/docs/petition.md b/docs/petition.md index 4a246a0..f29581e 100644 --- a/docs/petition.md +++ b/docs/petition.md @@ -28,7 +28,7 @@ The petition's owner's GUID. See [characters.guid](characters#guid). ### petitionguid -The GUID of the petition item. See [item\_instance.guid](item_instance#guid) +The GUID of the petition item. See [item\_instance.guid](item_instance#guid). ### name @@ -39,7 +39,7 @@ The name of the guild or arena team that the player is trying to ask for petitio The type of the petition. | ID | Type | -|----|--------------------| +|--- | ------------------ | | 2 | 2vs2 Arena charter | | 3 | 3vs3 Arena charter | | 5 | 5vs5 Arena charter | diff --git a/docs/petition_sign.md b/docs/petition_sign.md index 02b62d0..0c3ca53 100644 --- a/docs/petition_sign.md +++ b/docs/petition_sign.md @@ -19,7 +19,7 @@ This table holds information on all the signatures of a petition for either a gu [1]: #ownerguid [2]: #petitionguid [3]: #playerguid -[4]: #player_account +[4]: #playeraccount [5]: #type **Description of the fields** @@ -45,8 +45,8 @@ The account ID of the player that has signed the charter. No two players can sig The type of the petition. | ID | Type | -|--- | -------------------| +|--- | ------------------ | | 2 | 2vs2 Arena charter | | 3 | 3vs3 Arena charter | | 5 | 5vs5 Arena charter | -| 9 | Guild charter | \ No newline at end of file +| 9 | Guild charter | diff --git a/docs/pool_quest_save.md b/docs/pool_quest_save.md index 70a3539..43763f3 100644 --- a/docs/pool_quest_save.md +++ b/docs/pool_quest_save.md @@ -6,13 +6,13 @@ **Structure** -| Field | Type | Attributes | Key | Null | Default | Extra | Comment | -| ------------- | ------- | ---------- | --- | ---- | ------- | ----- | ------- | -| [pool_id][1] | INT | UNSIGNED | PRI | NO | 0 | | | -| [quest_id][2] | INT | UNSIGNED | PRI | NO | 0 | | | +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ------------- | ---- | ---------- | --- | ---- | ------- | ----- | ------- | +| [pool_id][1] | INT | UNSIGNED | PRI | NO | 0 | | | +| [quest_id][2] | INT | UNSIGNED | PRI | NO | 0 | | | -[1]: #pool_id -[2]: #quest_id +[1]: #poolid +[2]: #questid **Description of the fields** @@ -22,4 +22,4 @@ ### quest\_id -[quest\_template.id](quest_template#id). \ No newline at end of file +[quest\_template.id](quest_template#id). diff --git a/docs/pvpstats_battlegrounds.md b/docs/pvpstats_battlegrounds.md index 64f86f8..552c8f2 100644 --- a/docs/pvpstats_battlegrounds.md +++ b/docs/pvpstats_battlegrounds.md @@ -11,14 +11,14 @@ This table holds datas about BattleGrounds scores. To enable storing this kind o | Field | Type | Attributes | Key | Null | Default | Extra | Comment | | ------------------- | -------- | ---------- | --- | ---- | ------- | -------------- | ------- | | [id][1] | BIGINT | UNSIGNED | PRI | NO | | AUTO_INCREMENT | | -| [winner_faction][2] | TINYINT | | | NO | | | | +| [winner_faction][2] | TINYINT | SIGNED | | NO | | | | | [bracket_id][3] | TINYINT | UNSIGNED | | NO | | | | | [type][4] | TINYINT | UNSIGNED | | NO | | | | -| [date][5] | DATETIME | | | NO | | | | +| [date][5] | DATETIME | SIGNED | | NO | | | | [1]: #id -[2]: #winner_faction -[3]: #bracket_id +[2]: #winnerfaction +[3]: #bracketid [4]: #type [5]: #date @@ -68,4 +68,4 @@ The BattleGround type: ### date -Date and time of BattleGround ending. \ No newline at end of file +Date and time of BattleGround ending