diff options
95 files changed, 2218 insertions, 1443 deletions
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/banne |