diff options
| author | Kitzunu <24550914+Kitzunu@users.noreply.github.com> | 2020-03-03 19:07:36 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-03-03 19:07:36 +0100 |
| commit | e40d1ab7a216d8e80fa66c83bca5d58a1f897483 (patch) | |
| tree | 4ac3c36a666454a647363190508d851af88fada4 /docs | |
| parent | 2c0fde01dd5a3ae9b8ff4849a2139b614ee9916a (diff) | |
| download | wiki-e40d1ab7a216d8e80fa66c83bca5d58a1f897483.tar.gz wiki-e40d1ab7a216d8e80fa66c83bca5d58a1f897483.tar.bz2 wiki-e40d1ab7a216d8e80fa66c83bca5d58a1f897483.zip | |
fix: World Tables Documentation updates (#189)
- Removed information related to WOW versions above 3.3.5a
Co-authored-by: Barbz <BarbzYHOOL@users.noreply.github.com>
Diffstat (limited to 'docs')
46 files changed, 352 insertions, 150 deletions
diff --git a/docs/Database-Structure.md b/docs/Database-Structure.md index 5a106a2..7a6e42d 100644 --- a/docs/Database-Structure.md +++ b/docs/Database-Structure.md @@ -4,6 +4,4 @@ Generated with that tool: https://github.com/Kaev/MySQL-To-CSharp -**WARNING**: we are restructuring our DB, meanwhile some tables may have a different structure (or missing documentation). Meanwhile, you can have a look at the TC DB documentation to fill the gaps: - -https://trinitycore.atlassian.net/wiki/spaces/tc/pages/74663833/World+3.3.5
\ No newline at end of file +**WARNING**: we are restructuring our DB, meanwhile some tables may have a different structure (or missing documentation). Meanwhile, you can have a look at the [TC DB documentation](https://trinitycore.atlassian.net/wiki/spaces/tc/pages/74663833/World+3.3.5) to fill the gaps. diff --git a/docs/locales_achievement_reward.md b/docs/locales_achievement_reward.md index a65f072..5982c5d 100644 --- a/docs/locales_achievement_reward.md +++ b/docs/locales_achievement_reward.md @@ -1,4 +1,6 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [locales_achievement_reward](locales_achievement_reward) +# locales_achievement_reward + +[<-Back-to:World](database-world.md) Column | Type | Description --- | --- | --- diff --git a/docs/locales_broadcast_text.md b/docs/locales_broadcast_text.md index bb2fe09..4ac8538 100644 --- a/docs/locales_broadcast_text.md +++ b/docs/locales_broadcast_text.md @@ -1,4 +1,6 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [locales_broadcast_text](locales_broadcast_text) +# locales_broadcast_text + +[<-Back-to:World](database-world.md) Column | Type | Description --- | --- | --- diff --git a/docs/locales_creature_text.md b/docs/locales_creature_text.md index 67cf88d..b923cea 100644 --- a/docs/locales_creature_text.md +++ b/docs/locales_creature_text.md @@ -1,4 +1,6 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [locales_creature_text](locales_creature_text) +# locales_creature_text + +[<-Back-to:World](database-world.md) Column | Type | Description --- | --- | --- diff --git a/docs/locales_gossip_menu_option.md b/docs/locales_gossip_menu_option.md index d64aba8..9bc5cf7 100644 --- a/docs/locales_gossip_menu_option.md +++ b/docs/locales_gossip_menu_option.md @@ -1,4 +1,6 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [locales_gossip_menu_option](locales_gossip_menu_option) +# locales_gossip_menu_option + +[<-Back-to:World](database-world.md) Column | Type | Description --- | --- | --- diff --git a/docs/locales_item.md b/docs/locales_item.md index 6fedeca..b6f5c0b 100644 --- a/docs/locales_item.md +++ b/docs/locales_item.md @@ -1,4 +1,6 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [locales_item](locales_item) +# locales_item + +[<-Back-to:World](database-world.md) Column | Type | Description --- | --- | --- diff --git a/docs/locales_item_set_names.md b/docs/locales_item_set_names.md index 770b7c8..df0ab05 100644 --- a/docs/locales_item_set_names.md +++ b/docs/locales_item_set_names.md @@ -1,4 +1,6 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [locales_item_set_names](locales_item_set_names) +# locales_item_set_names + +[<-Back-to:World](database-world.md) Column | Type | Description --- | --- | --- diff --git a/docs/locales_npc_text.md b/docs/locales_npc_text.md index edb3511..eed84e6 100644 --- a/docs/locales_npc_text.md +++ b/docs/locales_npc_text.md @@ -1,4 +1,6 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [locales_npc_text](locales_npc_text) +# locales_npc_text + +[<-Back-to:World](database-world.md) Column | Type | Description --- | --- | --- diff --git a/docs/locales_page_text.md b/docs/locales_page_text.md index 66ade04..0ce71a5 100644 --- a/docs/locales_page_text.md +++ b/docs/locales_page_text.md @@ -1,4 +1,6 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [locales_page_text](locales_page_text) +# locales_page_text + +[<-Back-to:World](database-world.md) Column | Type | Description --- | --- | --- diff --git a/docs/locales_points_of_interest.md b/docs/locales_points_of_interest.md index b3cd4e6..98843b8 100644 --- a/docs/locales_points_of_interest.md +++ b/docs/locales_points_of_interest.md @@ -1,4 +1,6 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [locales_points_of_interest](locales_points_of_interest) +# locales_points_of_intrest + +[<-Back-to:World](database-world.md) Column | Type | Description --- | --- | --- diff --git a/docs/locales_quest.md b/docs/locales_quest.md index 539f5a2..6580782 100644 --- a/docs/locales_quest.md +++ b/docs/locales_quest.md @@ -1,4 +1,6 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [locales_quest](locales_quest) +# locales_quest + +[<-Back-to:World](database-world.md) Column | Type | Description --- | --- | --- diff --git a/docs/mail_level_reward.md b/docs/mail_level_reward.md index 7a3b109..a6865de 100644 --- a/docs/mail_level_reward.md +++ b/docs/mail_level_reward.md @@ -86,7 +86,7 @@ Mask required to receive mail. ### mailTemplateId -Mail ID to be send. See MailTemplate.dbc +Mail ID to be send. See [MailTemplate.dbc](MailTemplate) ### senderEntry diff --git a/docs/npc_trainer.md b/docs/npc_trainer.md index 4c44274..6c19d51 100644 --- a/docs/npc_trainer.md +++ b/docs/npc_trainer.md @@ -22,11 +22,11 @@ This table contains all the spells that each trainer can teach. ### ID -Usually, this would be an entry of a creature referring to [creature\_template.entry](creature_template_2130008.html#creature_template-entry). However, Biohazard included several trainer lists by refering to their id. For more information, see [Reference\_list](Trainer_reference). +Usually, this would be an entry of a creature referring to [creature\_template.entry](creature_template#creature_template-entry). However, Biohazard included several trainer lists by refering to their id. For more information, see [Reference\_list](Trainer_reference). ### SpellID -The spell ID from Spell.dbc. If the ID is negative, it's pointing to a reference template. +The spell ID from [Spell.dbc](Spell). If the ID is negative, it's pointing to a reference template. ### MoneyCost diff --git a/docs/outdoorpvp_template.md b/docs/outdoorpvp_template.md index 46ee180..bc4396e 100644 --- a/docs/outdoorpvp_template.md +++ b/docs/outdoorpvp_template.md @@ -1,7 +1,59 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [outdoorpvp_template](outdoorpvp_template) +# outdoorpvp_template -Column | Type | Description ---- | --- | --- -TypeId | tinyint(3) unsigned | -ScriptName | char(64) | -Comment | text | +[<-Back-to:World](database-world.md) + +<table> +<tbody> +<tr class="even"> +<td><p><strong>Field</strong></p></td> +<td><p><strong>Type</strong></p></td> +<td><p><strong>Attributes</strong></p></td> +<td><p><strong>Key</strong></p></td> +<td><p><strong>Null</strong></p></td> +<td><p><strong>Default</strong></p></td> +<td><p><strong>Extra</strong></p></td> +<td><p><strong>Comment</strong></p></td> +</tr> +<tr class="even"> +<td><p><a href="#TypeId">TypeId</a></p></td> +<td><p>tinyint(2)</p></td> +<td><p>unasigned</p></td> +<td><p>PRI</p></td> +<td><p>NO</p></td> +<td><p></p></td> +<td><p></p></td> +<td><p></p></td> +</tr> +<tr class="even"> +<td><p><a href="#ScriptName">ScriptName</a></p></td> +<td><p>char(64)</p></td> +<td><p>signed</p></td> +<td><p></p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p></p></td> +<td><p></p></td> +</tr> +<tr class="even"> +<td><p><a href="#comment">comment</a></p></td> +<td><p>text</p></td> +<td><p>signed</p></td> +<td><p></p></td> +<td><p>YES</p></td> +<td><p>NULL</p></td> +<td><p></p></td> +<td><p></p></td> +</tr> +</tbody> +</table> + +**Description of the fields** + +### TypeId +`field-no-description|1` + +### ScriptName +The name of the script that this outdoor pvp uses. This ties a script from a scripting engine to this outdoor pvp. + +### comment +The script name for the given outdoorpvp_template.
\ No newline at end of file diff --git a/docs/player_factionchange_items.md b/docs/player_factionchange_items.md index 1bc7d4a..13faad3 100644 --- a/docs/player_factionchange_items.md +++ b/docs/player_factionchange_items.md @@ -111,7 +111,7 @@ This is for easy item name identifying. Comment style should be name(ItemLevel) Not implemented. -See item\_template.AllowableRace +See [item\_template.AllowableRace](item_template#allowablerace) ### horde\_id diff --git a/docs/player_factionchange_quests.md b/docs/player_factionchange_quests.md index 282268d..68eb33f 100644 --- a/docs/player_factionchange_quests.md +++ b/docs/player_factionchange_quests.md @@ -1,4 +1,6 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [player_factionchange_quests](player_factionchange_quests) +# player_factionchange_quest + +[<-Back-to:World](database-world.md) Column | Type | Description --- | --- | --- diff --git a/docs/player_factionchange_reputations.md b/docs/player_factionchange_reputations.md index 1d6b41d..ab25df3 100644 --- a/docs/player_factionchange_reputations.md +++ b/docs/player_factionchange_reputations.md @@ -57,10 +57,10 @@ Basically all faction/reputation changes made when player changes faction. This is the alliance reputation ID. If you convert to horde and your reputations have a record in his table, they will be converted to [\#horde\_id](#player_factionchange_reputations-horde_id) -See character\_reputation.faction +See [character\_reputation.faction](character_reputation#faction) ### horde\_id This is the horde reputation ID. If you convert to alliance and your reputations have a record in his table, they will be converted to [\#alliance\_id](#player_factionchange_reputations-alliance_id) -See character\_reputation.faction +See [character\_reputation.faction](character_reputation#faction) diff --git a/docs/player_factionchange_titles.md b/docs/player_factionchange_titles.md index 396930c..b247a41 100644 --- a/docs/player_factionchange_titles.md +++ b/docs/player_factionchange_titles.md @@ -1,4 +1,6 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [player_factionchange_titles](player_factionchange_titles) +# player_factionchange_titles + +[<-Back-to:World](database-world.md) Column | Type | Description --- | --- | --- diff --git a/docs/playercreateinfo.md b/docs/playercreateinfo.md index 4f6f38f..4b892d8 100644 --- a/docs/playercreateinfo.md +++ b/docs/playercreateinfo.md @@ -127,11 +127,11 @@ The character's class. ### map -The map ID. See Map.dbc +The map ID. See [Map.dbc](Map) ### zone -The zone ID. See AreaTable.dbc +The zone ID. See [AreaTable.dbc](AreaTable) ### position\_x diff --git a/docs/playercreateinfo_spell.md b/docs/playercreateinfo_spell.md index 5dc7f06..674c467 100644 --- a/docs/playercreateinfo_spell.md +++ b/docs/playercreateinfo_spell.md @@ -1,4 +1,6 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [playercreateinfo_spell](playercreateinfo_spell) +# playercreateinfo_spell + +[<-Back-to:World](database-world.md) Column | Type | Description --- | --- | --- diff --git a/docs/playercreateinfo_spell_custom.md b/docs/playercreateinfo_spell_custom.md index b7b0fce..4d13648 100644 --- a/docs/playercreateinfo_spell_custom.md +++ b/docs/playercreateinfo_spell_custom.md @@ -1,6 +1,6 @@ # playercreateinfo\_spell\_custom -# playercreateinfo\_spell\_custom table +[<-Back-to:World](database-world.md) This table holds information on what spells newly created characters should start out with if the PlayerStart.AllSpells setting in enabled in TrinityCore.conf. A character in this table is defined by his/her race and class combination. @@ -77,15 +77,15 @@ Please note you'll have to set PlayerStart.AllSpells to 1 in config, else this t ### racemask -One or more character's race. See [ChrRaces](ChrRaces). +One or more character's race. See [ChrRaces.dbc](ChrRaces). ### classmask -One or more character's class. See ChrClasses. +One or more character's class. See [ChrClasses.dbc](ChrClasses) ### Spell -Spell id. See Spell.dbc +Spell id. See [Spell.dbc](Spell) ### Note diff --git a/docs/pool_creature.md b/docs/pool_creature.md index 45e29f3..b49cb44 100644 --- a/docs/pool_creature.md +++ b/docs/pool_creature.md @@ -77,17 +77,18 @@ This table contains a list of creatures that are tied to a specific pool. ### guid -Creature's guid. +[creature.guid](creature#guid) ### pool\_entry -The pool that this creature is in. Refers to pool\_template entry. +The pool that this creature is in. Refers to [pool\_template.entry](pool_template#entry). ### chance The explicit percentage chance that this creature will be spawned. -If the pool spawns just one creature (max\_limit = 1 in the respective pool\_template), the core selects the creature to be spawned in a two-step process: First, only the explicitly-chanced (chance > 0) creatures of the pool are rolled. If this roll does not produce any creature, all the creatures without explicit chance (chance = 0) are rolled with equal chance. +If the pool spawns just one creature (max\_limit = 1 in the respective [pool\_template](pool_template)), the core selects the creature to be spawned in a two-step process: First, only the explicitly-chanced (chance > 0) creatures of the pool are rolled. If this roll does not produce any creature, all the creatures without an explicit chance (chance = 0) are rolled with equal chance. + If the pool spawns more than one creature, the chance is ignored and all the creatures in the pool are rolled in one step with equal chance. In case the pool spawns just one creature and all the creatures have a nonzero chance, the sum of the chances for all the creatures must equal to 100, otherwise the pool won't be spawned. diff --git a/docs/pool_gameobject.md b/docs/pool_gameobject.md index 54db66b..5b59392 100644 --- a/docs/pool_gameobject.md +++ b/docs/pool_gameobject.md @@ -78,17 +78,18 @@ This table can only contain gameobjects that have a type of GAMEOBJECT\_TYPE\_CH ### guid -Gameobject's guid. +[gameobject.guid](gameobject#guid) ### pool\_entry -The pool that this gameobject is in. Refers to pool\_template entry. +The pool that this gameobject is in. Refers to [pool\_template.entry](pool_template#entry). ### chance The explicit percentage chance that this gameobject will be spawned. -If the pool spawns just one gameobject (max\_limit = 1 in the respective pool\_template), the core selects the gameobject to be spawned in a two-step process: First, only the explicitly-chanced (chance > 0) gameobjects of the pool are rolled. If this roll does not produce any gameobject, all the gameobjects without explicit chance (chance = 0) are rolled with equal chance. +If the pool spawns just one gameobject (max\_limit = 1 in the respective [pool\_template](pool_template)), the core selects the gameobject to be spawned in a two-step process: First, only the explicitly-chanced (chance > 0) gameobjects of the pool are rolled. If this roll does not produce any gameobject, all the gameobjects without an explicit chance (chance = 0) are rolled with equal chance. + If the pool spawns more than one gameobject, the chance is ignored and all the gameobjects in the pool are rolled in one step with equal chance. In case the pool spawns just one gameobject and all the gameobjects have a nonzero chance, the sum of the chances for all the gameobjects must equal to 100, otherwise the pool won't be spawned. diff --git a/docs/pool_pool.md b/docs/pool_pool.md index f9ec9aa..228547a 100644 --- a/docs/pool_pool.md +++ b/docs/pool_pool.md @@ -77,17 +77,18 @@ This is the pool of pools table. You can create a pool with a chance of a range ### pool\_id -The ID of the pool\_template that you want to include in this "pool of pools" as a child pool. +The ID of the [pool\_template](pool_template)) that you want to include in this "pool of pools" as a child pool. ### mother\_pool -The ID of the pool\_template that defines this "pool of pools". +The ID of the [pool\_template](pool_template)) that defines this "pool of pools". ### chance The explicit percentage chance that this child pool will be spawned. -If the mother pool spawns just one child pool (max\_limit = 1 in the respective mother pool's pool\_template), the core selects the child pool to be spawned in a two-step process: First, only the explicitly-chanced (chance > 0) child pools of the mother pool are rolled. If this roll does not produce any child pool, all the child pools without explicit chance (chance = 0) are rolled with equal chance. +If the mother pool spawns just one child pool (max\_limit = 1 in the respective mother pool's [pool\_template](pool_template), the core selects the child pool to be spawned in a two-step process: First, only the explicitly-chanced (chance > 0) child pools of the mother pool are rolled. If this roll does not produce any child pool, all the child pools without an explicit chance (chance = 0) are rolled with equal chance. + If the mother pool spawns more than one child pool, the chance is ignored and all the child pools in the mother pool are rolled in one step with equal chance. In case the mother pool spawns just one child pool and all the child pools have a nonzero chance, the sum of the chances for all the child pools must equal to 100, otherwise the mother pool won't function correctly. diff --git a/docs/pool_quest.md b/docs/pool_quest.md index 7e4af9e..71ba32d 100644 --- a/docs/pool_quest.md +++ b/docs/pool_quest.md @@ -67,11 +67,11 @@ This table contains a list of quests that are tied to a specific pool. ### entry -Quest [id](quest_template_2130261.html#quest_template-id). +Quest [id](quest_template#id). ### pool\_entry -The [pool](pool_template_2130267.html#pool_template-entry) that this quest is in. Refers to [pool\_template entry](pool_template_2130267.html#pool_template-entry). +The [pool](pool_template#entry) that this quest is in. Refers to [pool\_template entry](pool_template#entry). ### description diff --git a/docs/pool_quest_save.md b/docs/pool_quest_save.md index ac51487..5cf4b50 100644 --- a/docs/pool_quest_save.md +++ b/docs/pool_quest_save.md @@ -57,8 +57,8 @@ ### pool\_id -[pool\_quest.entry](Pool+quest+tc2#Poolquesttc2-pool_entry) +[pool\_quest.entry](pool_quest#id) ### quest\_id -[quest\_template.id](Quest+template+tc2#Questtemplatetc2-Id) +[quest\_template.id](quest_template#id) diff --git a/docs/quest_poi.md b/docs/quest_poi.md index 51972a6..87bb1c8 100644 --- a/docs/quest_poi.md +++ b/docs/quest_poi.md @@ -129,8 +129,7 @@ Comes from sniffs. ### QuestID -The Quest Id from quest\_template.id -. +The Quest Id from [quest\_template.id](quest_template#id) ### id @@ -142,11 +141,11 @@ if -1 than position of npc where you can complete quest ### MapID -The Map id from Map.dbc +The Map id from [Map.dbc](Map) ### WorldMapAreaId -The ID from <a href="https://wowdev.wiki/DB/WorldMapArea">WorldMapArea.dbc</a>. +The ID from [WorldMapArea.dbc](WorldMapArea). ### Floor diff --git a/docs/quest_poi_points.md b/docs/quest_poi_points.md index 269ed5e..cbb4c29 100644 --- a/docs/quest_poi_points.md +++ b/docs/quest_poi_points.md @@ -8,20 +8,76 @@ Comes from sniffs. Visually speaking, this table is used to identify the X and Y **Structure** -| | | | | | | | | -|--------------------------------------|----------|----------------|---------|----------|-------------|-----------|-------------| -| **Field** | **Type** | **Attributes** | **Key** | **Null** | **Default** | **Extra** | **Comment** | -| [questid](#quest_poi_points-questid) | int(10) | unsigned | PRI | NO | 0 | | | -| [id](#quest_poi_points-id)x1 | int(10) | unsigned | PRI | NO | 0 | | | -| [idx](#quest_poi_points-idx)2 | int(10) | unsigned | PRI | NO | 0 | | | -| [x](#quest_poi_points-x) | int(10) | unsigned | | NO | 0 | | | -| [y](#quest_poi_points-y) | int(10) | unsigned | | NO | 0 | | | +<table> +<tbody> +<tr class="even"> +<td><p><strong>Field</strong></p></td> +<td><p><strong>Type</strong></p></td> +<td><p><strong>Attributes</strong></p></td> +<td><p><strong>Key</strong></p></td> +<td><p><strong>Null</strong></p></td> +<td><p><strong>Default</strong></p></td> +<td><p><strong>Extra</strong></p></td> +<td><p><strong>Comment</strong></p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_poi_points-questid">questid</a></p></td> +<td><p>int(10)</p></td> +<td><p>unasigned</p></td> +<td><p>PRI</p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p></p></td> +<td><p></p></td> +</tr> +<tr class="even"> +<td><p><a href="#quest_poi_points-idx">idx</a>2</p></td> +<td><p>int(10)</p></td> +<td><p>unasigned</p></td> +<td><p>PRI</p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p></p></td> |