diff options
82 files changed, 221 insertions, 208 deletions
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 | | |</ |