From e40d1ab7a216d8e80fa66c83bca5d58a1f897483 Mon Sep 17 00:00:00 2001 From: Kitzunu <24550914+Kitzunu@users.noreply.github.com> Date: Tue, 3 Mar 2020 19:07:36 +0100 Subject: fix: World Tables Documentation updates (#189) - Removed information related to WOW versions above 3.3.5a Co-authored-by: Barbz --- docs/Database-Structure.md | 4 +- docs/locales_achievement_reward.md | 4 +- docs/locales_broadcast_text.md | 4 +- docs/locales_creature_text.md | 4 +- docs/locales_gossip_menu_option.md | 4 +- docs/locales_item.md | 4 +- docs/locales_item_set_names.md | 4 +- docs/locales_npc_text.md | 4 +- docs/locales_page_text.md | 4 +- docs/locales_points_of_interest.md | 4 +- docs/locales_quest.md | 4 +- docs/mail_level_reward.md | 2 +- docs/npc_trainer.md | 4 +- docs/outdoorpvp_template.md | 64 +++++++++++-- docs/player_factionchange_items.md | 2 +- docs/player_factionchange_quests.md | 4 +- docs/player_factionchange_reputations.md | 4 +- docs/player_factionchange_titles.md | 4 +- docs/playercreateinfo.md | 4 +- docs/playercreateinfo_spell.md | 4 +- docs/playercreateinfo_spell_custom.md | 8 +- docs/pool_creature.md | 7 +- docs/pool_gameobject.md | 7 +- docs/pool_pool.md | 7 +- docs/pool_quest.md | 4 +- docs/pool_quest_save.md | 4 +- docs/quest_poi.md | 7 +- docs/quest_poi_points.md | 159 +++++++++++++++++++++++++++++-- docs/quest_template.md | 45 +++------ docs/quest_template_addon.md | 32 +++---- docs/skill_extra_item_template.md | 2 +- docs/skill_fishing_base_level.md | 2 +- docs/smart_scripts.md | 14 ++- docs/spell_area.md | 20 ++-- docs/spell_dbc.md | 2 - docs/spell_group_stack_rules.md | 2 +- docs/spell_mixology.md | 4 +- docs/spell_proc_event.md | 4 +- docs/spell_ranks.md | 4 +- docs/spell_required.md | 4 +- docs/spell_target_position.md | 4 +- docs/spell_threat.md | 2 +- docs/vehicle_accessory.md | 6 +- docs/vehicle_template_accessory.md | 8 +- docs/waypoint_data.md | 4 +- docs/waypoints.md | 4 +- 46 files changed, 352 insertions(+), 150 deletions(-) (limited to 'docs') 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) + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field

Type

Attributes

Key

Null

Default

Extra

Comment

TypeId

tinyint(2)

unasigned

PRI

NO

ScriptName

char(64)

signed

NO

0

comment

text

signed

YES

NULL

+ +**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 WorldMapArea.dbc. +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 |   |   | + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field

Type

Attributes

Key

Null

Default

Extra

Comment

questid

int(10)

unasigned

PRI

NO

0

idx2

int(10)

unasigned

PRI

NO

0

x

int(10)

unasigned

NO

0

y

int(10)

unasigned

NO

0

VerifiedBuild

smallint

unasigned

YES

NULL

**Description of the fields** ### questid -The Quest Id from quest\_poi.questid +The Quest Id from [quest\_poi.questid](quest_poi#questid) ### idx1 @@ -29,7 +85,86 @@ Used to group multiple entries from quest\_poi.id. You must manually increment t ### idx2 -`field-no-description|3` +Used to group multiple entries in the quest poi points to draw the polygon for that point of interest. The actual points are the corners of each polygon. + +Example quest: Secreat Communication. + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

QuestID

idx1

idx2

x

y

VerifiedBuild

8318

3

0

-6231

-51

0

8318

3

1

-6236

-19

0

8318

3

2

-6241

-52

0

8318

3

3

-6316

-282

0

8318

3

4

-6413

-282

0

8318

3

5

-6483

-250

0

8318

3

6

-6483

-217

0

8318

3

7

-6326

-7

0

### x @@ -38,3 +173,7 @@ The X position of the question mark on the map. ### y The Y position of the question mark on the map. + +### VerifiedBuild + +VerifiedBuild diff --git a/docs/quest_template.md b/docs/quest_template.md index 7c990b3..4a1084b 100644 --- a/docs/quest_template.md +++ b/docs/quest_template.md @@ -1,5 +1,7 @@ # quest\_template +[<-Back-to:World](database-world.md) + **Table: quest\_template** Contains all basic definitions of available quests. @@ -801,9 +803,6 @@ Contains all basic definitions of available quests. -** -** - **Description of the fields** ### ID @@ -839,7 +838,7 @@ if **value < 0** then (**-value**) is quest sort id: (in general profession o ### QuestInfoID -These values are ID taken from QuestInfo.dbc +These values are ID taken from [QuestInfo.dbc](QuestInfo) ### SuggestedGroupNum @@ -851,8 +850,7 @@ Time in seconds that the player has to complete this quest. ### ~~RequiredClasses~~ -~~Classes required to get the quest. 0 means the quest is available for all classes.~~ -~~This field is a bitmask, you can combine class values. See [ChrClasses.dbc](https://trinitycore.atlassian.net/wiki/display/tc/ChrRaces)~~ +~~This field is a bitmask, you can combine class values. See [ChrClasses.dbc](ChrClasses)~~ ### AllowableRaces @@ -870,12 +868,6 @@ Examples: 1101 (1 + 4 + 8 + 64 + 1024) = Alliance Quest -**Mist of Pandaria and all Expansions after:** - -55378 (54432 + 256 + 128 + 32 + 16 + 2 + 512)  = Horde - -18875469 (16777216 + 2097152 + 1024 + 64 + 8 + 4 + 1) = Alliance - ### RepObjectiveFaction Faction ID for an objective to achieve a certain reputation value with. See Faction.dbc @@ -963,7 +955,7 @@ This flag field defines more specifically the type of quest it is. Aside from th

1

QUEST_FLAGS_STAY_ALIVE

-

If the player dies, the quest is failed.(question)

+

If the player dies, the quest is failed.

2

@@ -1139,7 +1131,7 @@ Note that some flags may not be supported by core. ### RewardTitleId -The title the character will receive upon completion of the quest. See CharTitles.dbc +The title the character will receive upon completion of the quest. See [CharTitles.dbc](CharTitles) ### RequiredPlayerKills @@ -1147,7 +1139,7 @@ Displays how much players you need to kill betd class=td class=a class=/td data- ### RewardTalents -Will give X bonus talents to the player completed the quest. Leave'"0"for No Bonus Talent Points.'' +Will give X bonus talents to the player completed the quest. Leave"0"for No Bonus Talent Points.'' ### RewardArenaPoints @@ -1164,20 +1156,20 @@ Will choose how many items will be added for reward. E.g "RewardChoiceItemId" is ### RewardItemId -[item Id](item_template_2130222.html#item_template-entry) given for reward (no choice). +[item Id](item_template#entry) given for reward (no choice). ### RewardItemCount -field-no-description|46 +`field-no-description|46` ### RewardFactionId -Faction Id (from Faction.dbc) for which the quest give reputation points. +Faction Id (from [Faction.dbc](Faction)) for which the quest give reputation points. Number of gain or lost reputation points for Faction at quest completion. This is special reputation rewarding. Normal reputation reward to quest rewarding creature faction calculated and added automatically. ### RewardFactionValueId -This field is used for reputation lookup in QuestFactionReward.dbc if [RewardFactionValueId](#quest_template-RewardFactionValueId) is 0. Value X in this field indicates RepX column of QuestFactionReward.dbc. If RewardRepValueId is positive, reputation from the first row of QuestFactionReward.dbc will be used, for negative values the second row is used. +This field is used for reputation lookup in [QuestFactionReward.dbc](QuestFactionReward) if [RewardFactionValueId](#quest_template-RewardFactionValueId) is 0. Value X in this field indicates RepX column of [QuestFactionReward.dbc](QuestFactionReward). If RewardRepValueId is positive, reputation from the first row of QuestFactionReward.dbc will be used, for negative values the second row is used. ### RewardFactionValueIdOverride @@ -1211,10 +1203,6 @@ Objectives of the quest. If empty, quest is an auto-complete quest that can be i The quest text. You can use certain placeholders that will be filled in in-game: $B - line break, $N - name, $R - race, $C - class, $Gmale:female; (male and female can be replace with any synonymn you want, but the order must stay the same. IE: boy:girl / man:woman / sir:madam / dude:chick) -### EndText - -field-no-description|57 - ### OfferRewardText First text send to the player by the NPC when completing the quest. You can use certain placeholders that will be filled in in-game: $B - line break, $N - name, $R - race, $C - class, $Gmale:female; (male and female can be replace with any synonymn you want, but the order must stay the same. IE: boy:girl / man:woman / sir:madam / dude:chick) @@ -1223,10 +1211,6 @@ First text send to the player by the NPC when completing the quest. You can use Text sent to player when the player tries to talk to the NPC with the quest active but incomplete. (The text under the "Progress" title in Wowhead.) You can use certain placeholders that will be filled in in-game: $B - line break, $N - name, $R - race, $C - class, $Gmale:female; (male and female can be replace with any synonymn you want, but the order must stay the same. IE: boy:girl / man:woman / sir:madam / dude:chick) -### CompletedText - -field-no-description|59 - ### RequiredNpcOrGo Value > 0:required creature\_template ID the player needs to kill/cast on in order to complete the quest. @@ -1247,7 +1231,7 @@ Item ID that is needed indirectly by the quest. For example, the quests asks for The maximum number of copies of the item in RequiredSourceItemId that can be picked up (and dropped by the core). ### RequiredItemId -Item\_template tc2 +[Item\_template](item_template#id) Id of required item to complete the quest. @@ -1257,7 +1241,7 @@ Amount of required items ### RequiredSpell -Spell Id required to cast on [RequiredNpcOrGo](#quest_template-RequiredNpcOrGo) to update Objective. +Spell Id required to cast on [RequiredNpcOrGo](quest_template#RequiredNpcOrGo) to update Objective. ### ObjectiveText @@ -1265,7 +1249,7 @@ Used to define non-standard objective texts, that show up in the questlog. Examp ### DetailsEmote -field-no-description|69 +`field-no-description|69` ### DetailsEmoteDelay @@ -1491,4 +1475,3 @@ Note: If player can choose between chain A or B may be determined by faction status (aldor or scryer), using ReqMinRepFaction = 1. Player should not be able to be neutral+1 with both at the same time. This may be the common threshold to obtain aldor or scryer quests (this is unsure). If that is the case, only the unlock of C, D and E after complete A2 *or* B2 is the impossible part.\_Note 2: With the [Conditions](conditions) table now every quest chain is possible.'' /table - diff --git a/docs/quest_template_addon.md b/docs/quest_template_addon.md index b2ff6bd..596293e 100644 --- a/docs/quest_template_addon.md +++ b/docs/quest_template_addon.md @@ -1,9 +1,10 @@ # quest\_template\_addon +[<-Back-to:World](database-world.md) + **Table: quest\_template\_addon** -** -**Contains extra definitions like linking quests, dependencies and requirements for the quests defined in the [quest\_template](https://trinitycore.atlassian.net/wiki/display/tc/quest_template) table to become available to the player. +Contains extra definitions like linking quests, dependencies and requirements for the quests defined in the [quest\_template](quest_template) table to become available to the player. **Structure:** @@ -30,7 +31,8 @@ 0
-Unique ID linked to quest_template.ID +Unique ID linked to quest_template.ID +Unique ID linked to quest_template.ID MaxLevel @@ -252,7 +254,7 @@ ### **ID** -Unique quest ID, matching the same quest ID in [quest\_template.ID](https://trinitycore.atlassian.net/wiki/display/tc/quest_template#quest_template-ID) +Unique quest ID, matching the same quest ID in [quest\_template.ID](quest_template#id) ### **MaxLevel** @@ -261,7 +263,7 @@ Maximum player level at which a character can get the quest. ### **AllowableClasses** Classes required to get the quest. 0 means the quest is available for all classes. -This field is a bitmask, you can combine class values. See [ChrClasses.dbc](https://trinitycore.atlassian.net/wiki/display/tc/ChrClasses) +This field is a bitmask, you can combine class values. See [ChrClasses.dbc](ChrClasses) ### **SourceSpellID** @@ -272,13 +274,13 @@ The spell ID cast on player upon starting the quest. - **if value > 0:** Contains the previous quest id, that must be completed before this quest can be started. - **If value < 0:** Contains the parent quest id, that must be active before this quest can be started. -See the [examples section](https://trinitycore.atlassian.net/wiki/display/tc/quest_template#quest_template-Examples) for examples. +See the [examples section](quest_template#examples-dealing-with-quests) for examples. ### **NextQuestID** Contains the next quest id, in case PrevQuestId of that other quest is not sufficient. -See the [examples section](https://trinitycore.atlassian.net/wiki/display/tc/quest_template#quest_template-Examples) for examples. +See the [examples section](quest_template#examples-dealing-with-quests) for examples. ### **ExclusiveGroup** @@ -290,19 +292,19 @@ Allows to define a group of quests of which only one may be chosen and completed Allows to define a group of quests of which all must be completed and rewarded to start next quest. E.g. if quest 1000 dependent from one of quests 1200, 1201 and 1202 and all this quests have same negative exclusive group then all this quest must be completed and rewarded before quest 1000 can be started. -Note: All quests that use an ExclusiveGroup must also have entries in pool\_template and pool\_quest in order for the core to choose one randomly. See the [examples section](https://trinitycore.atlassian.net/wiki/display/tc/quest_template#quest_template-Examples) for examples. +Note: All quests that use an ExclusiveGroup must also have entries in [pool\_template](pool_template) and [pool\_quest](quest_template#examples-dealing-with-quests) for examples. ### **RewardMailTemplateID** -If the quest gives as a reward an item from a possible list of items, the ID here corresponds to the proper loot template in [quest\_mail\_loot\_template](https://trinitycore.atlassian.net/wiki/display/tc/loot_template). According to the rules in that loot template, items "looted" will be sent by mail at the completion of the quest. +If the quest gives as a reward an item from a possible list of items, the ID here corresponds to the proper loot template in [quest\_mail\_loot\_template](loot_template). According to the rules in that loot template, items "looted" will be sent by mail at the completion of the quest. ### **RewardMailDelay** -How many seconds to wait until the mail is sent to the character that turned in a quest rewarding items from a loot template defined in [RewardMailTemplateId](https://trinitycore.atlassian.net/wiki/display/tc/quest_template#quest_template-RewardMailTemplateId) +How many seconds to wait until the mail is sent to the character that turned in a quest rewarding items from a loot template defined in [RewardMailTemplateId](quest_template#rewardmailtemplateid) ### **RequiredSkillID** -Skill required to know to accept the quest. See [SkillLine.dbc](https://trinitycore.atlassian.net/wiki/display/tc/SkillLine) +Skill required to know to accept the quest. See [SkillLine.dbc](SkillLine) 0 means no skill is required. ### **RequiredSkillPoints** @@ -311,11 +313,11 @@ Skill points required to have in order to accept the quest. ### **RequiredMinRepFaction** -Faction ID for reputation requirement. See [Faction.dbc](https://trinitycore.atlassian.net/wiki/display/tc/Faction) +Faction ID for reputation requirement. See [Faction.dbc](Faction) ### **RequiredMaxRepFaction** -The Faction ID for the faction that controls the maximum reputation value that the player can have and still get the quest. See [Faction.dbc](https://trinitycore.atlassian.net/wiki/display/tc/Faction) +The Faction ID for the faction that controls the maximum reputation value that the player can have and still get the quest. See [Faction.dbc](Faction) ### **RequiredMinRepValue** @@ -338,10 +340,8 @@ This field is a bitmask and is for controlling server side quest functions. Bliz -  1: Makes the quest repeatable. --  2: Makes the quest only completable by some external event (an entry in [areatrigger\_involvedrelation](https://trinitycore.atlassian.net/wiki/display/tc/areatrigger_involvedrelation), spell effect quest complete or an entry in [spell\_scripts](https://trinitycore.atlassian.net/wiki/display/tc/scripts) with command 7 as some examples) +- 2: Makes the quest only completable by some external event (an entry in [areatrigger\_involvedrelation](areatrigger_involvedrelation), spell effect quest complete or an entry in [spell\_scripts](scripts) with command 7 as some examples) -  4: Make quest auto-accept. As of patch 3.3.5a only quests in the starter area need this flag. -  8: Only used for Dungeon Finder quests - 16: Makes the quest monthly - 32: The quest requires RequiredOrNpcGo killcredit (a spell cast), but NOT an actual NPC kill. This action usually involves killing an invisible "bunny" NPC. - - diff --git a/docs/skill_extra_item_template.md b/docs/skill_extra_item_template.md index ac04abf..916f803 100644 --- a/docs/skill_extra_item_template.md +++ b/docs/skill_extra_item_template.md @@ -77,7 +77,7 @@ This table holds information about when using certain profession spells, you hav ### spellId -The spell ID that creates the item. See Spell.dbc +The spell ID that creates the item. See [Spell.dbc](Spell) ### requiredSpecialization diff --git a/docs/skill_fishing_base_level.md b/docs/skill_fishing_base_level.md index 17026cc..0c7350d 100644 --- a/docs/skill_fishing_base_level.md +++ b/docs/skill_fishing_base_level.md @@ -57,7 +57,7 @@ This table controls the minimum skill level required in fishing to fish in a cer ### entry -The area ID see AreaTable.dbc. +The area ID see [AreaTable.dbc](AreaTable). ### skill diff --git a/docs/smart_scripts.md b/docs/smart_scripts.md index 3979198..cc1ef53 100644 --- a/docs/smart_scripts.md +++ b/docs/smart_scripts.md @@ -1,7 +1,7 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [smart_scripts](smart_scripts) - # smart\_scripts +[<-Back-to:World](database-world.md) + **Table Structure** @@ -4411,9 +4411,13 @@ INSERT INTO `areatrigger_scripts` (`entry`, `ScriptName`) VALUES (y, 'SmartTrigg ### Invoker: -| | -|----------------------------------------------------------------------| -| // white list of events that actually have an invoker passed to them | +
+ + + + + +

// white list of events that actually have an invoker passed to them

Actions like SMART\_ACTION\_INVOKER\_CAST and targets like SMART\_TARGET\_ACTION\_INVOKER will work only if the event is in this list: diff --git a/docs/spell_area.md b/docs/spell_area.md index 1bd43b3..14cb520 100644 --- a/docs/spell_area.md +++ b/docs/spell_area.md @@ -161,7 +161,7 @@ Some examples: ### spell -The spell ID of the spell to be casted on the player. See Spell.dbc. +The spell ID of the spell to be casted on the player. See [Spell.dbc](Spell). ### area @@ -169,11 +169,11 @@ The area ID. Type ".gps" in-game and find the "Area:" number to use for this cel ### quest\_start -The entry of the quest which the player must have in the state defined by **quest\_start\_status**. See [quest\_template.id](quest_template_2130261.html#quest_template-id). +The entry of the quest which the player must have in the state defined by **quest\_start\_status**. See [quest\_template.id](quest_template#id). ### quest\_end -The entry of the quest which the player must not have in the state defined by **quest\_end\_status**. See [quest\_template.id](quest_template_2130261.html#quest_template-id). Setting both **quest\_start** and **quest\_end** to the same value is useless. +The entry of the quest which the player must not have in the state defined by **quest\_end\_status**. See [quest\_template.id](quest_template#id). Setting both **quest\_start** and **quest\_end** to the same value is useless. ### aura\_spell @@ -187,7 +187,7 @@ The value has the following effect: ### racemask -This ID is automatically called from [ChrRaces.dbc](https://trinitycore.atlassian.net/wiki/display/tc/ChrRaces). The bitmask is entered here. +This ID is automatically called from [ChrRaces.dbc](ChrRaces). The bitmask is entered here. MASTER: @@ -250,7 +250,10 @@ You should have the spell 92237 when entering the cavern IF : Here is the SQL for this example :  -INSERT INTO spell\_area (spell, area, quest\_start, quest\_end, autocast, quest\_start\_status, quest\_end\_status) VALUES (92237, 257, 28725, 28727, 1, 74, 11); +```sql +INSERT INTO spell_area (spell, area, quest_start, quest_end, autocast, quest_start_status, quest_end_status) VALUES +(92237, 257, 28725, 28727, 1, 74, 11); +``` | Quest Status | Flag | Explanation | |------------------------------------|---------------|-------------------------------------------------------------------------------------| @@ -267,10 +270,5 @@ Example for a SQL  For a \`quest\_end\_status\` that should contain QUEST\_STATUS\_NONE (1), QUEST\_STATUS\_COMPLETE (2) and QUEST\_STATUS\_INCOMPLETE (8): ``` sql - UPDATE `spell_area` SET `quest_end_status`= (1|2|8) WHERE `spell`=XXXXX AND `area`=YYYY; -- equivalent to `quest_end_status`= 11 +UPDATE `spell_area` SET `quest_end_status`= (1|2|8) WHERE `spell`=XXXXX AND `area`=YYYY; -- equivalent to `quest_end_status`= 11 ``` - -## Attachments: - -![](images/icons/bullet_blue.gif){width="8" height="8"} [spell\_custom\_attr.html](../2130105/) (text/html) - diff --git a/docs/spell_dbc.md b/docs/spell_dbc.md index c7c44a2..2dfcd47 100644 --- a/docs/spell_dbc.md +++ b/docs/spell_dbc.md @@ -6,8 +6,6 @@ This table contains data regarding serverside spells which are not to be found in Client DBC files. -**Note: **Not longer used since Warlords of Draenor Expansion (see [Hotfixes](https://trinitycore.atlassian.net/wiki/display/tc/Hotfixes)) - **Structure** diff --git a/docs/spell_group_stack_rules.md b/docs/spell_group_stack_rules.md index c3ae4d7..c449954 100644 --- a/docs/spell_group_stack_rules.md +++ b/docs/spell_group_stack_rules.md @@ -18,7 +18,7 @@ Notes: The table doesn't affect persistent area auras stacking or passive auras ### group\_id -Id of group in [spell\_group](spell_group_2130135.html#spell_group-id) table. The spell\_group may contain another spell\_groups inside, if so stacking rule needs to be defined for these groups separately. +Id of group in [spell\_group](spell_group#id) table. The spell\_group may contain another spell\_groups inside, if so stacking rule needs to be defined for these groups separately. ### stack\_rule diff --git a/docs/spell_mixology.md b/docs/spell_mixology.md index 98d742f..0e8b6cc 100644 --- a/docs/spell_mixology.md +++ b/docs/spell_mixology.md @@ -1,4 +1,6 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [spell_mixology](spell_mixology) +# spell_mixology + +[<-Back-to:World](database-world.md) Column | Type | Description --- | --- | --- diff --git a/docs/spell_proc_event.md b/docs/spell_proc_event.md index 21e3214..1c6a077 100644 --- a/docs/spell_proc_event.md +++ b/docs/spell_proc_event.md @@ -1,4 +1,6 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [spell_proc_event](spell_proc_event) +# spell_proc_event + +[<-Back-to:World](database-world.md) Column | Type | Description --- | --- | --- diff --git a/docs/spell_ranks.md b/docs/spell_ranks.md index 756bfff..0810bf4 100644 --- a/docs/spell_ranks.md +++ b/docs/spell_ranks.md @@ -67,11 +67,11 @@ Table used by the core to group different ranks of spells (the gray text seen on ### first\_spell\_id -SpellId from Spell.dbc which is first rank of spell rank chain. It identifies the whole chain. +SpellId from [Spell.dbc](Spell) which is first rank of spell rank chain. It identifies the whole chain. ### spell\_id -SpellId from Spell.dbc +SpellId from [Spell.dbc](Spell). ### rank diff --git a/docs/spell_required.md b/docs/spell_required.md index c2993ee..873c2b2 100644 --- a/docs/spell_required.md +++ b/docs/spell_required.md @@ -55,8 +55,8 @@ Table used to add restrictions for learning spells from trainer. Player can't le ### spell\_id -Spell ID from Spell.dbc, which require knowing \`req\_spell\` to learn from trainer. +Spell ID from [Spell.dbc](Spell), which require knowing \`req\_spell\` to learn from trainer. ### req\_spell -Spell ID from Spell.dbc, which is required to be known before \`spell\_id\` can be learned from trainer. +Spell ID from [Spell.dbc](Spell), which is required to be known before \`spell\_id\` can be learned from trainer. diff --git a/docs/spell_target_position.md b/docs/spell_target_position.md index 9a4fedf..429d273 100644 --- a/docs/spell_target_position.md +++ b/docs/spell_target_position.md @@ -97,11 +97,11 @@ This table holds coordinate information on where the player should be teleported ### id -The spell ID. See Spell.dbc +The spell ID. See [Spell.dbc](Spell) ### target\_map -Map where the player should be teleported to. See Map.dbc. +Map where the player should be teleported to. See [Map.dbc](Map). ### target\_position\_x diff --git a/docs/spell_threat.md b/docs/spell_threat.md index ade9310..f22d130 100644 --- a/docs/spell_threat.md +++ b/docs/spell_threat.md @@ -57,7 +57,7 @@ This table holds threat values on all spells that should either give or take awa ### entry -The spell ID. See Spell.dbc. +The spell ID. See [Spell.dbc](Spell). ### Threat diff --git a/docs/vehicle_accessory.md b/docs/vehicle_accessory.md index dd62fbd..b2b5493 100644 --- a/docs/vehicle_accessory.md +++ b/docs/vehicle_accessory.md @@ -4,7 +4,7 @@ **The \`vehicle\_accessory\` table** - This table is used to tell the server to spawn an additional NPC with this vehicle. +This table is used to tell the server to spawn an additional NPC with this vehicle. **Structure** @@ -116,7 +116,7 @@ Flying vehicles must have InhabitType set to (4 - Flying). ### seat\_id -Vehicle seat in witch the accessory should be spawned. See VehicleSeat.dbc +Vehicle seat in witch the accessory should be spawned. See [VehicleSeat.dbc](VehicleSeat) ### minion @@ -131,8 +131,6 @@ Comment ### summontype -Note: This is unknown past 3.3.5a. Cata versions may support this table. -
diff --git a/docs/vehicle_template_accessory.md b/docs/vehicle_template_accessory.md index 3c2638b..3f5f0be 100644 --- a/docs/vehicle_template_accessory.md +++ b/docs/vehicle_template_accessory.md @@ -4,7 +4,7 @@ **The \`vehicle\_template\_accessory\` table** -Records in this table can be overwritten by [vehicle\_accessory](https://trinitycore.atlassian.net/wiki/display/tc/vehicle_accessory) table +Records in this table can be overwritten by [vehicle\_accessory](vehicle_accessory) table **Structure** @@ -107,15 +107,15 @@ Records in this table can be overwritten by [vehicle\_accessory](https://trinity ### entry -Entry of creature to be used as Vehicle. Entry from creature\_template. +Entry of creature to be used as Vehicle. Entry from [creature_template](creature_template#entry). ### accessory\_entry -Entry from creature\_template to be used as the rider/turret/addon to the main vehicle. ID from creature\_template. +Entry from [creature_template](creature_template#entry) to be used as the rider/turret/addon to the main vehicle. ID from creature\_template. ### seat\_id -Vehicle seat in witch the accessory should be spawned. See VehicleSeat.dbc. +Vehicle seat in witch the accessory should be spawned. See [VehicleSeat.dbc](VehicleSeat). ### minion diff --git a/docs/waypoint_data.md b/docs/waypoint_data.md index f44ac0f..5e0484a 100644 --- a/docs/waypoint_data.md +++ b/docs/waypoint_data.md @@ -1,7 +1,7 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [waypoint_data](waypoint_data) - # waypoint\_data +[<-Back-to:World](database-world.md) + ### Information This table contains all the path data for creatures that use waypoints and waypoint scripts directly in their creature addon definition. See also [Waypoints-Information](Waypoints-Information) for general information about waypoints. diff --git a/docs/waypoints.md b/docs/waypoints.md index b3fa2f8..80d3bda 100644 --- a/docs/waypoints.md +++ b/docs/waypoints.md @@ -1,7 +1,7 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [waypoints](waypoints) - # waypoints +[<-Back-to:World](database-world.md) + ###### **Used by [SAI](smart_scripts)** ### Information -- cgit