From 9fd9a07f1c51200cdaf4fd5e13e7cec24fe3bbcd Mon Sep 17 00:00:00 2001 From: "Julio A. Leyva Osorio" Date: Fri, 16 Jul 2021 16:23:43 -0400 Subject: chore: characters (#584) * Update account_data.md * Update account_instance_times.md * Update account_tutorial.md * Update addons.md * Update arena_team.md * Fix arena_team.md * Update arena_team_member.md * Update auctionhouse.md * Update banned_addons.md * Update battleground_deserters.md * Update bugreport.md * Update calendar_events.md * fix calendar_events.md * fix * fix * fix3 * update calendar_invites.md * update channels.md * fix channels.md * fix channels.md * update channels_bans.md * update channels_bans.md * update petition.md * fix 4 * Update characters.md * Update worlstates.md * Update gm_ticket.md * + Update * + update 2.md * + update 3 * update + characters.md * + update 4.md * + update 5.md * update characters, thanks @r-o-b-o-t-o * fix + * + Update 6 * + Update 7 * + Update 8 * + Update 9 * Fix + @Kitzunu --- docs/account_data.md | 22 +- docs/account_instance_times.md | 4 +- docs/account_tutorial.md | 32 ++- docs/addons.md | 30 ++- docs/arena_team.md | 52 ++-- docs/arena_team_member.md | 28 ++- docs/auctionhouse.md | 14 +- docs/banned_addons.md | 41 ++- docs/battleground_deserters.md | 14 +- docs/bugreport.md | 37 ++- docs/calendar_events.md | 81 +++++- docs/calendar_invites.md | 73 +++++- docs/channels.md | 65 +++-- docs/channels_bans.md | 36 ++- docs/channels_rights.md | 60 ++++- docs/character_account_data.md | 16 +- docs/character_achievement.md | 12 +- docs/character_achievement_progress.md | 18 +- docs/character_action.md | 22 +- docs/character_arena_stats.md | 14 +- docs/character_aura.md | 78 +++--- docs/character_banned.md | 12 +- docs/character_battleground_random.md | 21 -- docs/character_brew_of_the_month.md | 29 ++- docs/character_declinedname.md | 14 +- docs/character_entry_point.md | 73 +++++- docs/character_equipmentsets.md | 58 ++--- docs/character_gifts.md | 18 +- docs/character_glyphs.md | 47 ++-- docs/character_homebind.md | 20 +- docs/character_instance.md | 18 +- docs/character_inventory.md | 18 +- docs/character_pet.md | 60 ++--- docs/character_pet_declinedname.md | 8 +- docs/character_queststatus.md | 70 +++--- docs/character_queststatus_daily.md | 10 +- docs/character_queststatus_monthly.md | 30 ++- docs/character_queststatus_rewarded.md | 14 +- docs/character_queststatus_seasonal.md | 12 +- docs/character_queststatus_weekly.md | 10 +- docs/character_reputation.md | 14 +- docs/character_skills.md | 8 +- docs/character_social.md | 14 +- docs/character_spell.md | 24 +- docs/character_spell_cooldown.md | 26 +- docs/character_stats.md | 84 +++---- docs/character_talent.md | 23 +- docs/characters.md | 446 ++++++++++++++------------------- docs/corpse.md | 137 ++++++++-- docs/creature_respawn.md | 26 +- docs/es/home.md | 4 +- docs/game_event_condition_save.md | 16 +- docs/game_event_save.md | 18 +- docs/gameobject_respawn.md | 26 +- docs/gm_subsurvey.md | 43 +++- docs/gm_survey.md | 40 +-- docs/gm_ticket.md | 64 ++--- docs/group_member.md | 14 +- docs/groups.md | 72 +++--- docs/guild.md | 30 +-- docs/guild_bank_eventlog.md | 40 ++- docs/guild_bank_item.md | 14 +- docs/guild_bank_right.md | 10 +- docs/guild_bank_tab.md | 10 +- docs/guild_eventlog.md | 34 ++- docs/guild_member.md | 66 +---- docs/guild_member_withdraw.md | 53 +++- docs/guild_rank.md | 20 +- docs/instance.md | 20 +- docs/instance_reset.md | 10 +- docs/item_loot_storage.md | 94 ++++++- docs/item_refund_instance.md | 16 +- docs/item_soulbound_trade_data.md | 14 +- docs/lag_reports.md | 51 ++-- docs/lfg_data.md | 12 +- docs/log_arena_fights.md | 108 ++++++-- docs/log_arena_memberstats.md | 87 +++++-- docs/log_encounter.md | 59 ++++- docs/log_money.md | 80 +++++- docs/mail.md | 32 ++- docs/mail_items.md | 14 +- docs/pet_aura.md | 78 +++--- docs/pet_spell.md | 12 +- docs/pet_spell_cooldown.md | 14 +- docs/petition.md | 12 +- docs/petition_sign.md | 22 +- docs/pool_quest_save.md | 8 +- docs/pvpstats_battlegrounds.md | 26 +- docs/pvpstats_players.md | 42 ++-- docs/quest_tracker.md | 58 ++--- docs/recovery_item.md | 20 +- docs/reserved_name.md | 22 +- docs/version_db_characters.md | 42 +++- docs/warden_action.md | 29 ++- docs/worldstates.md | 12 +- 95 files changed, 2218 insertions(+), 1443 deletions(-) delete mode 100644 docs/character_battleground_random.md (limited to 'docs') diff --git a/docs/account_data.md b/docs/account_data.md index 14b5c1f..992d708 100644 --- a/docs/account_data.md +++ b/docs/account_data.md @@ -8,23 +8,23 @@ Contains data about client account and settings. **Structure** -| 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 | | | | - -[1]: #account +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| -------------- | ------- | ---------- | --- | ---- | ------- | ----- | ------------------ | +| [accountId][1] | INT | UNSIGNED | PRI | NO | 0 | | Account Identifier | +| [type][2] | TINYINT | UNSIGNED | PRI | NO | 0 | | | +| [time][3] | INT | UNSIGNED | | NO | 0 | | | +| [data][4] | BLOB | SIGNED | | NO | | | | + +[1]: #accountid [2]: #type [3]: #time [4]: #data **Description of the fields** -### account +### accountId -[Account.id](http://www.azerothcore.org/wiki/account#id). +The [account id](account#id). ### type @@ -36,7 +36,7 @@ Contains data about client account and settings. ### time -Time of last modification in Unixtime +Time of last modification in Unixtime. ### data diff --git a/docs/account_instance_times.md b/docs/account_instance_times.md index 06d87b3..c01b15d 100644 --- a/docs/account_instance_times.md +++ b/docs/account_instance_times.md @@ -22,11 +22,11 @@ This table controls how many instances the account's characters have been in las ### accountId -Account of the player. See [account.id](account_2130004.html#account-id). +Account of the player. See [account.id](account#id). ### instanceId -This is the instance.id which characters of this account has been past 5 hours. +This is the instance id which characters of this account has been past 5 hours. ### releaseTime diff --git a/docs/account_tutorial.md b/docs/account_tutorial.md index 6989f39..f0143b6 100644 --- a/docs/account_tutorial.md +++ b/docs/account_tutorial.md @@ -34,9 +34,37 @@ This table is used to store the tutorial state of all the accounts. ### guid -Account of the player. See [account.id](account_2130004.html#account-id). +Account of the player. See [account.id](account#id). -### tut0-7 +### tut0 + +`field-no-description|2` + +### tut1 + +`field-no-description|3` + +### tut2 + +`field-no-description|4` + +### tut3 + +`field-no-description|5` + +### tut4 + +`field-no-description|6` + +### tut5 + +`field-no-description|7` + +### tut6 + +`field-no-description|8` + +### tut7 These values 32bits flags. So 8 x 32bits values makes 256 bits available to store 256 tutorial messages status. diff --git a/docs/addons.md b/docs/addons.md index 26560d3..52fe345 100644 --- a/docs/addons.md +++ b/docs/addons.md @@ -1,6 +1,26 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [addons](addons) +# addons -| Column | Type | Description | -| ------ | ------------ | ----------- | -| Name | VARCHAR(120) | -| Crc | INT UNSIGNED | +[<-Back-to:Characters](database-characters.md) + +**The \`addons\` table** + +**Structure** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| -------------- | ------------ | ---------- | --- | ---- | ------- | ------ | ------- | +| [name][1] | VARCHAR(120) | | PRI | NO | '' | PRI | | +| [crc][2] | INT | UNSIGNED | | NO | 0 | | | + + +[1]: #name +[2]: #crc + +**Description of the fields** + +### name + +`field-no-description|1` + +### crc + +`field-no-description|2` \ No newline at end of file diff --git a/docs/arena_team.md b/docs/arena_team.md index 6949de6..d728f56 100644 --- a/docs/arena_team.md +++ b/docs/arena_team.md @@ -10,21 +10,21 @@ 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 | | Unique | | +| [arenaTeamId][1] | INT | UNSIGNED | PRI | NO | 0 | 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 | 0 | | | +| [type][4] | TINYINT | UNSIGNED | | NO | 0 | | | +| [rating][5] | SMALLINT | UNSIGNED | | NO | 0 | | | +| [seasonGames][6] | SMALLINT | UNSIGNED | | NO | 0 | | | +| [seasonWins][7] | SMALLINT | UNSIGNED | | NO | 0 | | | +| [weekGames][8] | SMALLINT | UNSIGNED | | NO | 0 | | | +| [weekWins][9] | SMALLINT | UNSIGNED | | NO | 0 | | | +| [rank][10] | INT | UNSIGNED | | NO | 0 | | | +| [BackgroundColor][11] | INT | UNSIGNED | | NO | 0 | | | +| [emblemStyle][12] | TINYINT | UNSIGNED | | NO | 0 | | | +| [emblemColor][13] | INT | UNSIGNED | | NO | 0 | | | +| [borderStyle][14] | TINYINT | UNSIGNED | | NO | 0 | | | +| [borderColor][15] | INT | UNSIGNED | | NO | 0 | | | [1]: #arenateamid [2]: #name @@ -46,15 +46,15 @@ This table holds the main ArenaTeam information. All created teams or all teams ### arenaTeamId -The ID of the ArenaTeam. This number is unique to each team and is the main method to identify a team.1 +The ID of the ArenaTeam. This number is unique to each team and is the main method to identify a team. ### name -Name of the Arena team +Name of the Arena team. ### captainGuid -The GUID of the character who created the ArenaTeam. See [characters.guid](2129969.html#characters(table)-guid) +The GUID of the character who created the ArenaTeam. See [characters.guid](characters#guid). ### type @@ -90,20 +90,20 @@ Rank of teams in the competition by rating. ### BackgroundColor -Team-tabard BackgroundColor (same as guild-tabard) +Team-tabard BackgroundColor (same as guild-tabard). -### EmblemStyle +### emblemStyle -Team-tabard Emblem (same as guild-tabard) +Team-tabard Emblem (same as guild-tabard). -### EmblemColor +### emblemColor -Team-tabard EmblemColor (same as guild-tabard) +Team-tabard emblemColor (same as guild-tabard). -### BorderStyle +### borderStyle -Team-tabard Bordertype (same as guild-tabard) +Team-tabard Bordertype (same as guild-tabard). -### BorderColor +### borderColor -Team-tabard BorderColor (same as guild-tabard) +Team-tabard borderColor (same as guild-tabard). diff --git a/docs/arena_team_member.md b/docs/arena_team_member.md index 6eddd2f..607193e 100644 --- a/docs/arena_team_member.md +++ b/docs/arena_team_member.md @@ -12,29 +12,29 @@ This table holds arena info about specific team members. All arena\_team members | ------------------- | -------- | ---------- | --- | ---- | ------- | ----- | ------- | | [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 | | | -| [seasonGames][6] | SMALLINT | UNSIGNED | | NO | 0 | | | -| [seasonWins][7] | SMALLINT | UNSIGNED | | NO | 0 | | | +| [weekGames][3] | SMALLINT | UNSIGNED | | NO | 0 | | | +| [weekWins][4] | SMALLINT | UNSIGNED | | NO | 0 | | | +| [seasonGames][5] | SMALLINT | UNSIGNED | | NO | 0 | | | +| [seasonWins][6] | SMALLINT | UNSIGNED | | NO | 0 | | | +| [personalRating][7] | SMALLINT | UNSIGNED | | NO | 0 | | | [1]: #arenateamid [2]: #guid -[3]: #personalrating -[4]: #weekgames -[5]: #weekwins -[6]: #seasongames -[7]: #seasonwins +[3]: #weekgames +[4]: #weekwins +[5]: #seasongames +[6]: #seasonwins +[7]: #personalrating **Description of the fields** ### arenaTeamId -ID of arena team. See Team Id +ID of arena team. See Team Id. ### guid -Player's GUID. See characters.guid +Player's GUID. See [characters.guid](characters#guid). ### weekGames @@ -51,3 +51,7 @@ Number of games played this **season**. ### seasonWins Number of games won this **season**. + +### personalrating + +The player's personal arena rating. \ No newline at end of file diff --git a/docs/auctionhouse.md b/docs/auctionhouse.md index 6564331..9e06b61 100644 --- a/docs/auctionhouse.md +++ b/docs/auctionhouse.md @@ -13,7 +13,7 @@ This table is used by Trinity while running and not a table that you would usual | Field | Type | Attributes | Key | Null | Default | Extra | Comment | | ------------------- | ---- | ---------- | --- | ---- | ------- | ----- | ------- | | [id][1] | INT | UNSIGNED | PRI | NO | 0 | | | -| [auctioneerguid][2] | INT | UNSIGNED | | NO | 0 | | | +| [houseid][2] | INT | UNSIGNED | | NO | 0 | | | | [itemguid][3] | INT | UNSIGNED | UNI | NO | 0 | | | | [itemowner][4] | INT | UNSIGNED | | NO | 0 | | | | [buyoutprice][5] | INT | UNSIGNED | | NO | 0 | | | @@ -24,7 +24,7 @@ This table is used by Trinity while running and not a table that you would usual | [deposit][10] | INT | UNSIGNED | | NO | 0 | | | [1]: #id -[2]: #auctioneerguid +[2]: #houseid [3]: #itemguid [4]: #itemowner [5]: #buyoutprice @@ -40,17 +40,17 @@ This table is used by Trinity while running and not a table that you would usual Unique identifier for every auction. -### auctioneerguid +### houseid -The GUID of the creature where the auction item was added. See creature.guid +The GUID of the creature where the auction item was added. See [creature.guid](creature#guid). ### itemguid -The GUID of the item that is up for auction. See item\_instance.guid +The GUID of the item that is up for auction. See [item\_instance.guid](item_instance#guid). ### itemowner -The GUID of the owner of the item up for auction. See characters.guid +The GUID of the owner of the item up for auction. See [characters.guid](characters#guid). ### buyoutprice @@ -62,7 +62,7 @@ The time when the auction will end, measured in [Unix time](http://en.wikipedia. ### buyguid -The GUID of the highest bidder. See characters.guid +The GUID of the highest bidder. See [characters.guid](characters#guid). ### lastbid diff --git a/docs/banned_addons.md b/docs/banned_addons.md index fffb2f4..74fa8e2 100644 --- a/docs/banned_addons.md +++ b/docs/banned_addons.md @@ -1,8 +1,37 @@ +# banned\_addons + [<-Back-to:Characters](database-characters.md) -Column | Type | Description ---- | --- | --- -Id | INT UNSIGNED | -Name | VARCHAR(255) | -Version | VARCHAR(255) | -TIMESTAMP | TIMESTAMP | +**The \`banned\_addons\` table** + +**Structure** + +| 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 | | | + +[1]: #id +[2]: #name +[3]: #version +[4]: #timestamp + +**Description of the fields** + +### Id + +`field-no-description|1` + +### Name + +`field-no-description|2` + +### Version + +`field-no-description|3` + +### Timestamp + +`field-no-description|4` \ No newline at end of file diff --git a/docs/battleground_deserters.md b/docs/battleground_deserters.md index ea2e2b5..32a957c 100644 --- a/docs/battleground_deserters.md +++ b/docs/battleground_deserters.md @@ -8,11 +8,11 @@ This table holds datas about BattleGrounds deserters. To enable storing this kin **Structure** -| Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|---------------|----------|------------|-----|------|---------|-------|---------| -| [guid][1] | INT | UNSIGNED | | | | | | -| [type][2] | TINYINT | UNSIGNED | | | | | | -| [datetime][3] | datetime | | | | | | | +| 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 | [1]: #guid [2]: #type @@ -22,7 +22,7 @@ This table holds datas about BattleGrounds deserters. To enable storing this kin ### guid -Link to characters.guid +Link to [characters.guid](characters#guid). ### type @@ -36,4 +36,4 @@ Link to characters.guid ### datetime -date and time of the event +Date and time of the event. diff --git a/docs/bugreport.md b/docs/bugreport.md index bc9f01a..e23017d 100644 --- a/docs/bugreport.md +++ b/docs/bugreport.md @@ -1,7 +1,32 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [bugreport](bugreport) +# bugreport + +[<-Back-to:Characters](database-characters.md) + +**The \`bugreport\` table** + +**Structure** + +| 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 | | | | + +[1]: #id +[2]: #type +[3]: #content + +**Description of the fields** + +### id + +`field-no-description|1` + +### type + +`field-no-description|2` + +### content + +`field-no-description|3` -Column | Type | Description ---- | --- | --- -Id | INT UNSIGNED | -Type | longtext | -Content | longtext | diff --git a/docs/calendar_events.md b/docs/calendar_events.md index 20e0428..ed5b2c5 100644 --- a/docs/calendar_events.md +++ b/docs/calendar_events.md @@ -1,13 +1,68 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [calendar_events](calendar_events) - -Column | Type | Description ---- | --- | --- -Id | BIGINT UNSIGNED | -Creator | INT UNSIGNED | -Title | VARCHAR(255) | -Description | VARCHAR(255) | -Type | TINYINT UNSIGNED | -Dungeon | INT | -Eventtime | INT UNSIGNED | -Flags | INT UNSIGNED | -Time2 | INT UNSIGNED | +# calendar\_events + +[<-Back-to:Characters](database-characters.md) + +**The \`calendar\_events\` table** + +**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 | '' | | | +| [type][5] | TINYINT | UNSIGNED | | NO | 4 | | | +| [dungeon][6] | INT | | | NO | -1 | | | +| [eventtime][7] | INT | UNSIGNED | | NO | 0 | | | +| [flags][8] | INT | UNSIGNED | | NO | 0 | | | +| [time2][9] | INT | UNSIGNED | | NO | 0 | | | + +[1]: #id +[3]: #creator +[4]: #title +[5]: #description +[6]: #type +[7]: #dungeon +[8]: #eventtime +[9]: #flags +[10]: #time2 + +**Description of the fields** + +### id + +`field-no-description|1` + +### creator + +`field-no-description|2` + +### title + +`field-no-description|3` + +### description + +`field-no-description|4` + +### type + +`field-no-description|5` + +### dungeon + +`field-no-description|6` + +### eventtime + +`field-no-description|7` + +### flags + +`field-no-description|8` + +### time2 + +`field-no-description|9` + diff --git a/docs/calendar_invites.md b/docs/calendar_invites.md index ae52dc4..7f39990 100644 --- a/docs/calendar_invites.md +++ b/docs/calendar_invites.md @@ -1,12 +1,61 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [calendar_invites](calendar_invites) - -Column | Type | Description ---- | --- | --- -Id | BIGINT UNSIGNED | -Event | BIGINT UNSIGNED | -Invitee | INT UNSIGNED | -Sender | INT UNSIGNED | -Status | TINYINT UNSIGNED | -Statustime | INT UNSIGNED | -Rank | TINYINT UNSIGNED | -Text | VARCHAR(255) | +# calendar\_invites + +[<-Back-to:Characters](database-characters.md) + +**The \`calendar\_invites\` table** + +**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 | | | +| [sender][4] | INT | UNSIGNED | | NO | '' | | | +| [status][5] | TINYINT | UNSIGNED | | NO | 0 | | | +| [statustime][6] | INT | UNSIGNED | | NO | 0 | | | +| [rank][7] | TINYINT | UNSIGNED | | NO | 0 | | | +| [text][8] | VARCHAR(255) | | | NO | '' | | | + +[1]: #id +[2]: #event +[3]: #invitee +[4]: #sender +[5]: #status +[6]: #statustime +[7]: #rank +[8]: #text + +**Description of the fields** + +### id + +`field-no-description|1` + +### event + +`field-no-description|2` + +### invitee + +`field-no-description|3` + +### sender + +`field-no-description|4` + +### status + +`field-no-description|5` + +### rank + +`field-no-description|6` + +### eventtime + +`field-no-description|7` + +### text + +`field-no-description|8` \ No newline at end of file diff --git a/docs/channels.md b/docs/channels.md index 4722dc5..19d9b00 100644 --- a/docs/channels.md +++ b/docs/channels.md @@ -2,43 +2,45 @@ [<-Back-to:Characters](database-characters.md) -# Table: channels +**The \`channels\` table** -Information and settings for ingame, player-based chat channels (not affecting the default system channels) +Information and settings for ingame, player-based chat channels (not affecting the default system channels). ## Structure -| Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|-----------------|--------------|------------|-----|------|---------|-------|---------| -| [name][1] | VARCHAR(128) | SIGNED | PRI | NO | | | | -| [team][2] | INT | UNSIGNED | PRI | NO | | | | -| [announce][3] | TINYINT | UNSIGNED | | NO | 1 | | | -| [ownership][4] | TINYINT | UNSIGNED | | NO | 1 | | | -| [password][5] | VARCHAR(32) | SIGNED | | YES | NULL | | | -| [bannedList][6] | text | SIGNED | | YES | | | | -| [lastUsed][7] | INT | UNSIGNED | | NO | | | | - -[1]: #name -[2]: #team -[3]: #announce -[4]: #ownership -[5]: #password -[6]: #bannedlist +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| --------------- | ------------ | ---------- | --- | ---- | ------- | -------------- | ------- | +| [channelId][1] | INT | SIGNED | PRI | NO | | AUTO_INCREMENT | | +| [name][2] | VARCHAR(128) | SIGNED | | NO | | | | +| [team][3] | INT | UNSIGNED | | NO | | | | +| [announce][4] | TINYINT | UNSIGNED | | NO | 1 | | | +| [ownership][5] | TINYINT | UNSIGNED | | NO | 1 | | | +| [password][6] | VARCHAR(32) | SIGNED | | YES | | | | +| [lastUsed][7] | INT | UNSIGNED | | NO | | | | + +[1]: #channelid +[2]: #name +[3]: #team +[4]: #announce +[5]: #ownership +[6]: #password [7]: #lastused -## Description of the fields +**Description of the fields** -### name +### channelId + +The id of channel. -**Channel name** +### name -Name of the channel +Name of the channel. ### team -**team id** Allow access to channel from specified player faction ID +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**) +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 | |----------|-------| @@ -47,29 +49,24 @@ For multirace channels, two (or more) separate entries must exist with the EXACT ### announce -**Channel announce (0/1)** +Channel announce (0/1). - 0 = Channel join/part actions will not be sent - 1 = Channel join/part actions will be sent ### ownership -**Channel ownership (0/1)** +Channel ownership. - 0 = No one will ever be an owner. - 1 = Ownership is the first person in the channel. ### password -**Channel password** - -Empty, or a standard string-based password (no spaces allowed) - -### bannedList (NOT IMPLEMENTED FOR NOW) +Channel password. -**Channel banlist** -List of banned player names, separated by spaces +Empty, or a standard string-based password (no spaces allowed). ### lastUsed -Used for automated cleaning of unused channels from database. Time is in unixtime. +Used for automated cleaning of unused channels from database. Time is in unixtime. \ No newline at end of file diff --git a/docs/channels_bans.md b/docs/channels_bans.md index 105d779..24ce138 100644 --- a/docs/channels_bans.md +++ b/docs/channels_bans.md @@ -1,7 +1,31 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [channels_bans](channels_bans) +# channels\_bans -Column | Type | Description ---- | --- | --- -ChannelId | INT UNSIGNED | -PlayerGUID | INT UNSIGNED | -BanTime | INT UNSIGNED | +[<-Back-to:Characters](database-characters.md) + +**The \`channels\_bans\` table** + +## Structure + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| --------------- | ----- | ---------- | --- | ---- | ------- | ------ | ------- | +| [channelId][1] | INT | UNSIGNED | PRI | NO | | | | +| [playerGUID][2] | INT | UNSIGNED | PRI | NO | | | | +| [banTime][3] | INT | UNSIGNED | | NO | | | | + +[1]: #channelid +[2]: #playerguid +[3]: #banTime + +**Description of the fields** + +### channelId + +The [channel id](channels#channelId). + +### playerGUID + +`field-no-description|2` + +### banTime + +The ban time of de [channel](channels#channelId). diff --git a/docs/channels_rights.md b/docs/channels_rights.md index d3708f7..ea5b57f 100644 --- a/docs/channels_rights.md +++ b/docs/channels_rights.md @@ -1,10 +1,50 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [channels_rights](channels_rights) - -Column | Type | Description ---- | --- | --- -Name | VARCHAR(128) | -Flags | INT UNSIGNED | -Speakdelay | INT UNSIGNED | -Joinmessage | VARCHAR(255) | -Delaymessage | VARCHAR(255) | -Moderators | text | +# channels\_rights + +[<-Back-to:Characters](database-characters.md) + +**The \`channels\_rights\` table** + +**Structure** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ----------------- | ------------ | ---------- | --- | ---- | ------- | ----- | ------- | +| [name][1] | VARCHAR(128) | SIGNED | PRI | NO | | | | +| [flags][2] | INT | UNSIGNED | | NO | | | | +| [speakdelay][3] | INT | UNSIGNED | | NO | | | | +| [joinmessage][4] | VARCHAR(255) | SIGNED | | NO | '' | | | +| [delaymessage][5] | VARCHAR(255) | SIGNED | | NO | '' | | | +| [moderators][6] | TEXT | SIGNED | | YES | | | | + + +[1]: #name +[2]: #flags +[3]: #speakdelay +[4]: #joinmessage +[5]: #delaymessage +[6]: #moderators + +**Description of the fields** + +### name + +`field-no-description|1` + +### flags + +`field-no-description|2` + +### speakdelay + +`field-no-description|3` + +### joinmessage + +`field-no-description|4` + +### delaymessage + +`field-no-description|5` + +### moderators + +`field-no-description|6` \ No newline at end of file diff --git a/docs/character_account_data.md b/docs/character_account_data.md index f31bc23..659410b 100644 --- a/docs/character_account_data.md +++ b/docs/character_account_data.md @@ -8,12 +8,12 @@ Contains data about character settings. **Structure** -| Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|-----------|------------|------------|-----|------|---------|-------|---------| -| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | | -| [type][2] | INT | UNSIGNED | PRI | NO | 0 | | | -| [time][3] | BIGINT | UNSIGNED | | NO | 0 | | | -| [data][4] | BLOB | SIGNED | | NO | | | | +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| --------- | ------- | ---------- | --- | ---- | ------- | ----- | ------- | +| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | | +| [type][2] | TINYINT | UNSIGNED | PRI | NO | 0 | | | +| [time][3] | INT | UNSIGNED | | NO | 0 | | | +| [data][4] | BLOB | SIGNED | | NO | | | | [1]: #guid [2]: #type @@ -24,7 +24,7 @@ Contains data about character settings. ### guid -The character global unique identifier. See [Characters.guid](2129969.html#characters(table)-guid) +The character global unique identifier. See [characters.guid](characters#guid). ### type @@ -38,7 +38,7 @@ The character global unique identifier. See [Characters.guid](2129969.html#chara ### time -Time of last modification in Unixtime +Time of last modification in Unixtime. ### data diff --git a/docs/character_achievement.md b/docs/character_achievement.md index e1c841b..2c1905b 100644 --- a/docs/character_achievement.md +++ b/docs/character_achievement.md @@ -10,11 +10,11 @@ This table holds information on the achievements a character has earned / comple **Structure** -| Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|------------------|-------------|------------|-----|------|---------|-------|---------| -| [guid][1] | INT | UNSIGNED | PRI | NO | | | | +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ---------------- | -------- | ---------- | --- | ---- | ------- | ----- | ------- | +| [guid][1] | INT | UNSIGNED | PRI | NO | | | | | [achievement][2] | SMALLINT | UNSIGNED | PRI | NO | | | | -| [date][3] | INT | UNSIGNED | | NO | 0 | | | +| [date][3] | INT | UNSIGNED | | NO | 0 | | | [1]: #guid [2]: #achievement @@ -24,11 +24,11 @@ This table holds information on the achievements a character has earned / comple ### guid -The GUID of the character. See [characters.guid](characters_table_) +The GUID of the character. See [characters.guid](characters#guid). ### achievement -The ID of the achievement from [Achievement.dbc](Achievement). +The ID of the achievement from [Achievement.dbc](achievement). ### date diff --git a/docs/character_achievement_progress.md b/docs/character_achievement_progress.md index a3426f6..440da17 100644 --- a/docs/character_achievement_progress.md +++ b/docs/character_achievement_progress.md @@ -4,16 +4,14 @@ **The \`character\_achievement\_progress\` table** -`table-no-description` - **Structure** | Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|---------------|-------------|------------|-----|------|---------|-------|---------| -| [guid][1] | INT | UNSIGNED | PRI | NO | | | | -| [criteria][2] | SMALLINT | UNSIGNED | PRI | NO | | | | -| [counter][3] | INT | UNSIGNED | | NO | | | | -| [date][4] | INT | UNSIGNED | | NO | 0 | | | +| ------------- | ----------- | ---------- | --- | ---- | ------- | ----- | ------- | +| [guid][1] | INT | UNSIGNED | PRI | NO | | | | +| [criteria][2] | SMALLINT | UNSIGNED | PRI | NO | | | | +| [counter][3] | INT | UNSIGNED | | NO | | | | +| [date][4] | INT | UNSIGNED | | NO | 0 | | | [1]: #guid [2]: #criteria @@ -24,11 +22,11 @@ ### guid -The GUID of the character. See characters.guid +The GUID of the character. See [characters.guid](characters#guid). ### criteria -Criteria from [Achievement\_Criteria.dbc](Achievement_Criteria) +Criteria from [Achievement\_Criteria.dbc](achievement_criteria). ### counter @@ -36,4 +34,4 @@ Criteria from [Achievement\_Criteria.dbc](Achievement_Criteria) ### date -The date when this achievement was earned. See [Unix timestamp Calculator](http://www.unixtimestamp.com/index.php) +The date when this achievement was earned. See [Unix timestamp Calculator](http://www.unixtimestamp.com/index.php). diff --git a/docs/character_action.md b/docs/character_action.md index b0f106d..7e254eb 100644 --- a/docs/character_action.md +++ b/docs/character_action.md @@ -8,19 +8,25 @@ Contains all the individual button data for each character. A button is any of t **Structure** -| Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|--------|------------|------------|-----|------|---------|-------|---------| -| guid | INT | UNSIGNED | PRI | NO | 0 | | | -| spec | TINYINT | UNSIGNED | PRI | NO | 0 | | | -| button | TINYINT | UNSIGNED | PRI | NO | 0 | | | -| action | INT | UNSIGNED | | NO | 0 | | | -| type | TINYINT | UNSIGNED | | NO | 0 | | | +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ----------- | ---------- | ---------- | --- | ---- | ------- | ----- | ------- | +| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | | +| [spec][2] | TINYINT | UNSIGNED | PRI | NO | 0 | | | +| [button][3] | TINYINT | UNSIGNED | PRI | NO | 0 | | | +| [action][4] | INT | UNSIGNED | | NO | 0 | | | +| [type][5] | TINYINT | UNSIGNED | | NO | 0 | | | + +[1]: #guid +[2]: #spec +[3]: #button +[4]: #action +[5]: #type **Description of the fields** ### guid -The GUID of the character. See characters.guid +The GUID of the character. See [characters.guid](characters#guid). ### spec diff --git a/docs/character_arena_stats.md b/docs/character_arena_stats.md index adae4d0..4c05e71 100644 --- a/docs/character_arena_stats.md +++ b/docs/character_arena_stats.md @@ -10,19 +10,21 @@ This table holds information about character's matchmaker rating in all team typ | Field | Type | Attributes | Key | Null | Default | Extra | Comment | |-----------------------|-------------|------------|-----|------|---------|-------|---------| -| [guid][1] | INT | SIGNED | PRI | NO | | | | -| [slot][2] | TINYINT | SIGNED | PRI | NO | | | | -| [matchmakerRating][3] | SMALLINT | SIGNED | | NO | | | | +| [guid][1] | INT | UNSIGNED | PRI | NO | | | | +| [slot][2] | TINYINT | UNSIGNED | PRI | NO | | | | +| [matchmakerRating][3] | SMALLINT | UNSIGNED | | NO | | | | +| [maxMMR][4] | SMALLINT | SIGNED | | NO | | | | [1]: #guid [2]: #slot [3]: #matchmakerrating +[4]: #maxmmr **Description of the fields** ### guid -The GUID of the character. See characters.guid +The GUID of the character. See [characters.guid](characters#guid). ### slot @@ -37,3 +39,7 @@ Arena slot index: ### matchmakerRating Player's matchmaker rating + +### maxMMR + +`field-no-description|4` \ No newline at end of file diff --git a/docs/character_aura.md b/docs/character_aura.md index 9b457a8..31c3e4f 100644 --- a/docs/character_aura.md +++ b/docs/character_aura.md @@ -8,35 +8,35 @@ 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 | | | Global Unique Identifier | -| [caster_guid][2] | BIGINT | UNSIGNED | PRI | NO | | | Full Global Unique Identifier | -| [item_guid][3] | BIGINT | UNSIGNED | PRI | NO | | | | -| [spell][4] | MEDIUMINT | UNSIGNED | PRI | NO | | | | -| [effect_mask][5] | TINYINT | UNSIGNED | PRI | NO | | | | -| [recalculate_mask][6] | TINYINT | UNSIGNED | | NO | | | | -| [stackcount][7] | TINYINT | UNSIGNED | | NO | | | | -| [amount0][8] | INT | SIGNED | | NO | | | | -| [amount1][9] | INT | SIGNED | | NO | | | | -| [amount2][10] | INT | SIGNED | | NO | | | | -| [base_amount0][11] | INT | SIGNED | | NO | | | | -| [base_amount1][12] | INT | SIGNED | | NO | | | | -| [base_amount2][13] | INT | SIGNED | | NO | | | | -| [maxduration][14] | INT | SIGNED | | NO | | | | -| [remaintime][15] | INT | SIGNED | | NO | | | | -| [remaincharges][16] | TINYINT | UNSIGNED | | NO | | | | +| 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 | | | +| [spell][4] | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | | +| [effectMask][5] | TINYINT | UNSIGNED | PRI | NO | 0 | | | +| [recalculateMask][6] | TINYINT | UNSIGNED | | NO | 0 | | | +| [stackCount][7] | TINYINT | UNSIGNED | | NO | 1 | | | +| [amount0][8] | INT | SIGNED | | NO | 0 | | | +| [amount1][9] | INT | SIGNED | | NO | 0 | | | +| [amount2][10] | INT | SIGNED | | NO | 0 | | | +| [base_amount0][11] | INT | SIGNED | | NO | 0 | | | +| [base_amount1][12] | INT | SIGNED | | NO | 0 | | | +| [base_amount2][13] | INT | SIGNED | | NO | 0 | | | +| [maxDuration][14] | INT | SIGNED | | NO | 0 | | | +| [remainTime][15] | INT | SIGNED | | NO | 0 | | | +| [remainCharges][16] | TINYINT | UNSIGNED | | NO | 0 | | | [1]: #guid -[2]: #caster_guid -[3]: #item_guid +[2]: #casterguid +[3]: #itemguid [4]: #spell -[5]: #effect_mask -[6]: #recalculate_mask +[5]: #effectmask +[6]: #recalculatemask [7]: #stackcount -[8]: #amount0 -[9]: #amount1 -[10]: #amount2 +[8]: #amount +[9]: #amount +[10]: #amount [11]: #base_amount0 [12]: #base_amount1 [13]: #base_amount2 @@ -48,25 +48,25 @@ Contains aura information that is loaded when a character is loaded, so the aura ### guid -The GUID of the target affected by the aura. See characters.guid +The GUID of the target affected by the aura. See [characters.guid](characters#guid). -### caster\_guid +### casterGuid -The GUID of the player who casted the aura. See characters.guid +The GUID of the player who casted the aura. See [characters.guid](characters#guid). -### item\_guid +### itemGuid -The GUID of the item which casted the aura. See item\_instance.guid +The GUID of the item which casted the aura. See [item\_instance.guid](item\_instance#guid). ### spell -The spell from which the aura was applied. See Spell.dbc column 1 +The spell from which the aura was applied. See [Spell.dbc](spell) column 1. -### effect\_mask +### effectMask The effect index of the spell from which the aura came from. A spell has up to three effects, with the index being 0, 1, or 2. -### recalculate\_mask +### recalculateMask `field-no-description|5` @@ -78,9 +78,17 @@ Determines how many stacks of the spell the character has. The modifier value associated with the aura. -### base\_amount +### base\_amount0 -`field-no-description|8` +`field-no-description|11` + +### base\_amount1 + +`field-no-description|12` + +### base\_amount2 + +`field-no-description|13` ### maxduration diff --git a/docs/character_banned.md b/docs/character_banned.md index aea67f2..3b8e508 100644 --- a/docs/character_banned.md +++ b/docs/character_banned.md @@ -10,12 +10,12 @@ This table lists all of the characters that have been banned along with the date | 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 | | | +| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | Global Unique Identifier | +| [bandate][2] | INT | UNSIGNED | PRI | NO | 0 | | | +| [unbandate][3] | INT | UNSIGNED | | NO | 0 | | | | [bannedby][4] | VARCHAR(50) | SIGNED | | NO | | | | | [banreason][5] | VARCHAR(255) | SIGNED | | NO | | | | -| [active][6] | TINYINT | UNSIGNED | | NO | 1 | | | +| [active][6] | TINYINT | UNSIGNED | | NO | 1 | | | [1]: #guid [2]: #bandate @@ -28,7 +28,7 @@ This table lists all of the characters that have been banned along with the date ### guid -The character guid. See [characters.guid](2129969.html#characters(table)-id). +The character guid. See [characters.guid](characters#guid). ### bandate @@ -48,4 +48,4 @@ The reason for the ban. ### active -Boolean 0 or 1 controlling if the ban is currently active or not. +Boolean 0 or 1 controlling if the ban is currently active or not. \ No newline at end of file diff --git a/docs/character_battleground_random.md b/docs/character_battleground_random.md deleted file mode 100644 index 79ab44e..0000000 --- a/docs/character_battleground_random.md +++ /dev/null @@ -1,21 +0,0 @@ -# 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 (10) | 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](2129969.html#characters(table)-guid) diff --git a/docs/character_brew_of_the_month.md b/docs/character_brew_of_the_month.md index b466bfc..59ab127 100644 --- a/docs/character_brew_of_the_month.md +++ b/docs/character_brew_of_the_month.md @@ -1,6 +1,25 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [character_brew_of_the_month](character_brew_of_the_month) +# character\_brew\_of\_the\_month -Column | Type | Description ---- | --- | --- -Guid | INT UNSIGNED | -LastEventId | INT UNSIGNED | +[<-Back-to:Characters](database-characters.md) + +**The \`character\_brew\_of\_the\_month\` table** + +**Structure** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ---------------- | ---- | ---------- | --- | ---- | ------- | ----- | ------- | +| [guid][1] | INT | UNSIGNED | PRI | NO | | | | +| [lastEventId][2] | INT | UNSIGNED | | NO | 0 | | | + +[1]: #guid +[2]: #lastEventId + +**Description of the fields** + +### guid + +`field-no-description|1` + +### lastEventId + +`field-no-description|2` \ No newline at end of file diff --git a/docs/character_declinedname.md b/docs/character_declinedname.md index 02e0c36..5fac181 100644 --- a/docs/character_declinedname.md +++ b/docs/character_declinedname.md @@ -4,18 +4,16 @@ **The \`character\_declinedname\` table** -`table-no-description` - **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 | NULL | | | -| [dative][3] | VARCHAR(15) | SIGNED | | NO | NULL | | | -| [accusative][4] | VARCHAR(15) | SIGNED | | NO | NULL | | | -| [instrumental][5] | VARCHAR(15) | SIGNED | | NO | NULL | | | -| [prepositional][6] | VARCHAR(15) | SIGNED | | NO | NULL | | | +| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | Global Unique Identifier | +| [genitive][2] | VARCHAR(15) | SIGNED | | NO | '' | | | +| [dative][3] | VARCHAR(15) | SIGNED | | NO | '' | | | +| [accusative][4] | VARCHAR(15) | SIGNED | | NO | '' | | | +| [instrumental][5] | VARCHAR(15) | SIGNED | | NO | '' | | | +| [prepositional][6] | VARCHAR(15) | SIGNED | | NO | '' | | | [1]: #guid [2]: #genitive diff --git a/docs/character_entry_point.md b/docs/character_entry_point.md index 40b4a18..9189be9 100644 --- a/docs/character_entry_point.md +++ b/docs/character_entry_point.md @@ -1,12 +1,61 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [character_entry_point](character_entry_point) - -Column | Type | Description ---- | --- | --- -Guid | INT UNSIGNED | -JoinX | FLOAT | -JoinY | FLOAT | -JoinZ | FLOAT | -JoinO | FLOAT | -JoinMapId | INT UNSIGNED | -TaxiPath | text | -MountSpell | INT UNSIGNED | +# character\_entry\_point + +[<-Back-to:Characters](database-characters.md) + +**The \`character\_entry\_point\` table** + +**Structure** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| --------------- | ----- | ---------- | --- | ---- | ------- | ----- | ------------------------ | +| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | Global Unique Identifier | +| [joinX][2] | FLOAT | SIGNED | | NO | 0 | | | +| [joinY][3] | FLOAT | SIGNED | | NO | 0 | | | +| [joinZ][4] | FLOAT | SIGNED | | NO | 0 | | | +| [joinO][5] | FLOAT | SIGNED | | NO | 0 | | | +| [joinMapId][6] | INT | UNSIGNED | | YES | 0 | | Map Identifier | +| [taxiPath][7] | TEXT | SIGNED | | NO | 0 | | | +| [mountSpell][8] | INT | UNSIGNED | | NO | 0 | | | + +[1]: #guid +[2]: #joinx +[3]: #joiny +[4]: #joinz +[5]: #joino +[6]: #joinmapid +[7]: #taxipath +[8]: #mountspell + +**Description of the fields** + +### guid + +Global Unique Identifier. + +### joinX + +`field-no-description|2` + +### joinY + +`field-no-description|3` + +### joinZ + +`field-no-description|4` + +### joinO + +`field-no-description|5` + +### joinMapId + +Map Identifier. + +### taxiPath + +`field-no-description|7` + +### mountSpell + +`field-no-description|8` \ No newline at end of file diff --git a/docs/character_equipmentsets.md b/docs/character_equipmentsets.md index 39ca0b9..eb3adf3 100644 --- a/docs/character_equipmentsets.md +++ b/docs/character_equipmentsets.md @@ -9,32 +9,32 @@ This table holds info about player's equipment manager settings. **Structure** | Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|------------------|--------------|------------|-----|------|---------|----------------|---------| -| [guid][1] | INT | SIGNED | | NO | | | | -| [setguid][2] | BIGINT | SIGNED | PRI | NO | | Auto Increment | | -| [setindex][3] | TINYINT | SIGNED | | NO | | | | -| [name][4] | VARCHAR(31) | | | NO | | | | -| [iconname][5] | VARCHAR(100) | | | NO | | | | -| [ignore_mask][6] | INT | UNSIGNED | | NO | | | | -| [item0][7] | INT | UNSIGNED | | NO | | | | -| [item1][8] | INT | UNSIGNED | | NO | | | | -| [item2][9] | INT | UNSIGNED | | NO | | | | -| [item3][10] | INT | UNSIGNED | | NO | | | | -| [item4][11] | INT | UNSIGNED | | NO | | | | -| [item5][12] | INT | UNSIGNED | | NO | | | | -| [item6][13] | INT | UNSIGNED | | NO | | | | -| [item7][14] | INT | UNSIGNED | | NO | | | | -| [item8][15] | INT | UNSIGNED | | NO | | | | -| [item9][16] | INT | UNSIGNED | | NO | | | | -| [item10][17] | INT | UNSIGNED | | NO | | | | -| [item11][18] | INT | UNSIGNED | | NO | | | | -| [item12][19] | INT | UNSIGNED | | NO | | | | -| [item13][20] | INT | UNSIGNED | | NO | | | | -| [item14][21] | INT | UNSIGNED | | NO | | | | -| [item15][22] | INT | UNSIGNED | | NO | | | | -| [item16][23] | INT | UNSIGNED | | NO | | | | -| [item17][24] | INT | UNSIGNED | | NO | | | | -| [item18][25] | INT | UNSIGNED | | NO | | | | +| ---------------- | ------------ | ---------- | --- | ---- | ------- | -------------- | ------- | +| [guid][1] | INT | SIGNED | | NO | | UNIQUE | | +| [setguid][2] | BIGINT | SIGNED | PRI | NO | | UNIQUE | | +| [setindex][3] | TINYINT | UNSIGNED | | NO | | UNIQUE | | +| [name][4] | VARCHAR(31) | SIGNED | | NO | | | | +| [iconname][5] | VARCHAR(100) | SIGNED | | NO | | | | +| [ignore_mask][6] | INT | UNSIGNED | | NO | | | | +| [item0][7] | INT | UNSIGNED | | NO | | | | +| [item1][8] | INT | UNSIGNED | | NO | | | | +| [item2][9] | INT | UNSIGNED | | NO | | | | +| [item3][10] | INT | UNSIGNED | | NO | | | | +| [item4][11] | INT | UNSIGNED | | NO | | | | +| [item5][12] | INT | UNSIGNED | | NO | | | | +| [item6][13] | INT | UNSIGNED | | NO | | | | +| [item7][14] | INT | UNSIGNED | | NO | | | | +| [item8][15] | INT | UNSIGNED | | NO | | | | +| [item9][16] | INT | UNSIGNED | | NO | | | | +| [item10][17] | INT | UNSIGNED | | NO | | | | +| [item11][18] | INT | UNSIGNED | | NO | | | | +| [item12][19] | INT | UNSIGNED | | NO | | | | +| [item13][20] | INT | UNSIGNED | | NO | | | | +| [item14][21] | INT | UNSIGNED | | NO | | | | +| [item15][22] | INT | UNSIGNED | | NO | | | | +| [item16][23] | INT | UNSIGNED | | NO | | | | +| [item17][24] | INT | UNSIGNED | | NO | | | | +| [item18][25] | INT | UNSIGNED | | NO | | | | [1]: #guid [2]: #setguid @@ -66,7 +66,7 @@ This table holds info about player's equipment manager settings. ### guid -Player's GUID. See characters.guid +Player's GUID. See [characters.guid](characters#guid). ### setguid @@ -82,7 +82,7 @@ Individual. Name is set by player. ### iconname -Name taken from ItemDisplayInfo.dbc, column 6 +Name taken from ItemDisplayInfo.dbc, column 6. ### ignore\_mask @@ -90,7 +90,7 @@ Name taken from ItemDisplayInfo.dbc, column 6 ### item0-18 -Values taken from item\_instance.guid +Values taken from [item\_instance.guid](item_instance#guid). | ID | Name | |----|-----------| diff --git a/docs/character_gifts.md b/docs/character_gifts.md index 42684fb..7d38247 100644 --- a/docs/character_gifts.md +++ b/docs/character_gifts.md @@ -8,12 +8,12 @@ This table holds data about wrapped/gift items. **Structure** -| Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|----------------|---------|------------|-----|------|---------|-------|---------| -| [guid][1] | INT | UNSIGNED | | NO | 0 | | | -| [item_guid][2] | INT | UNSIGNED | PRI | NO | 0 | | | -| [entry][3] | INT | UNSIGNED | | NO | 0 | | | -| [flags][4] | INT | UNSIGNED | | NO | 0 | | | +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| -------------- | ---- | ---------- | --- | ---- | ------- | ----- | ------- | +| [guid][1] | INT | UNSIGNED | | NO | 0 | | | +| [item_guid][2] | INT | UNSIGNED | PRI | NO | 0 | | | +| [entry][3] | INT | UNSIGNED | | NO | 0 | | | +| [flags][4] | INT | UNSIGNED | | NO | 0 | | | [1]: #guid [2]: #item_guid @@ -24,15 +24,15 @@ This table holds data about wrapped/gift items. ### guid -The GUID of the character. See characters.guid +The GUID of the character. See [characters.guid](characters#guid). ### item\_guid -The GUID of the item. See item\_instance.guid +The GUID of the item. See [item\_instance.guid](item_instance#guid) ### entry -The entry of the item. See item\_template.entry +The entry of the item. See [item\_template.entry](item_template#entry). ### flags diff --git a/docs/character_glyphs.md b/docs/character_glyphs.md index b2fefff..93ce809 100644 --- a/docs/character_glyphs.md +++ b/docs/character_glyphs.md @@ -8,36 +8,39 @@ Contains all the individual glyph data for each character. **Structure