AzerothCore
npc_text
Table Structure
This table contains the texts that are used for gossip. More research needs to be done on this table.
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| ID | MEDIUMINT | UNSIGNED | PRI | NO | 0 | ||
| text0_0 | longtext | SIGNED | YES | NULL | |||
| text0_1 | longtext | SIGNED | YES | NULL | |||
| lang0 | TINYINT | UNSIGNED | NO | 0 | |||
| Probability0 | FLOAT | SIGNED | NO | 0 | |||
| em0_0 | SMALLINT | UNSIGNED | NO | 0 | |||
| em0_1 | SMALLINT | UNSIGNED | NO | 0 | |||
| em0_2 | SMALLINT | UNSIGNED | NO | 0 | |||
| em0_3 | SMALLINT | UNSIGNED | NO | 0 | |||
| em0_4 | SMALLINT | UNSIGNED | NO | 0 | |||
| em0_5 | SMALLINT | UNSIGNED | NO | 0 | |||
| text1_0 | longtext | SIGNED | YES | NULL | |||
| text1_1 | longtext | SIGNED | YES | NULL | |||
| lang1 | TINYINT | UNSIGNED | NO | 0 | |||
| Probability1 | FLOAT | SIGNED | NO | 0 | |||
| em1_0 | SMALLINT | UNSIGNED | NO | 0 | |||
| em1_1 | SMALLINT | UNSIGNED | NO | 0 | |||
| em1_2 | SMALLINT | UNSIGNED | NO | 0 | |||
| em1_3 | SMALLINT | UNSIGNED | NO | 0 | |||
| em1_4 | SMALLINT | UNSIGNED | NO | 0 | |||
| em1_5 | SMALLINT | UNSIGNED | NO | 0 | |||
| text2_0 | longtext | SIGNED | YES | NULL | |||
| text2_1 | longtext | SIGNED | YES | NULL | |||
| lang2 | TINYINT | UNSIGNED | NO | 0 | |||
| Probability2 | FLOAT | SIGNED | NO | 0 | |||
| em2_0 | SMALLINT | UNSIGNED | NO | 0 | |||
| em2_1 | SMALLINT | UNSIGNED | NO | 0 | |||
| em2_2 | SMALLINT | UNSIGNED | NO | 0 | |||
| em2_3 | SMALLINT | UNSIGNED | NO | 0 | |||
| em2_4 | SMALLINT | UNSIGNED | NO | 0 | |||
| em2_5 | SMALLINT | UNSIGNED | NO | 0 | |||
| text3_0 | longtext | SIGNED | YES | NULL | |||
| text3_1 | longtext | SIGNED | YES | NULL | |||
| lang3 | TINYINT | UNSIGNED | NO | 0 | |||
| Probability3 | FLOAT | SIGNED | NO | 0 | |||
| em3_0 | SMALLINT | UNSIGNED | NO | 0 | |||
| em3_1 | SMALLINT | UNSIGNED | NO | 0 | |||
| em3_2 | SMALLINT | UNSIGNED | NO | 0 | |||
| em3_3 | SMALLINT | UNSIGNED | NO | 0 | |||
| em3_4 | SMALLINT | UNSIGNED | NO | 0 | |||
| em3_5 | SMALLINT | UNSIGNED | NO | 0 | |||
| text4_0 | longtext | SIGNED | YES | NULL | |||
| text4_1 | longtext | SIGNED | YES | NULL | |||
| lang4 | TINYINT | UNSIGNED | NO | 0 | |||
| Probability4 | FLOAT | SIGNED | NO | 0 | |||
| em4_0 | SMALLINT | UNSIGNED | NO | 0 | |||
| em4_1 | SMALLINT | UNSIGNED | NO | 0 | |||
| em4_2 | SMALLINT | UNSIGNED | NO | 0 | |||
| em4_3 | SMALLINT | UNSIGNED | NO | 0 | |||
| em4_4 | SMALLINT | UNSIGNED | NO | 0 | |||
| em4_5 | SMALLINT | UNSIGNED | NO | 0 | |||
| text5_0 | longtext | SIGNED | YES | NULL | |||
| text5_1 | longtext | SIGNED | YES | NULL | |||
| lang5 | TINYINT | UNSIGNED | NO | 0 | |||
| Probability5 | FLOAT | SIGNED | NO | 0 | |||
| em5_0 | SMALLINT | UNSIGNED | NO | 0 | |||
| em5_1 | SMALLINT | UNSIGNED | NO | 0 | |||
| em5_2 | SMALLINT | UNSIGNED | NO | 0 | |||
| em5_3 | SMALLINT | UNSIGNED | NO | 0 | |||
| em5_4 | SMALLINT | UNSIGNED | NO | 0 | |||
| em5_5 | SMALLINT | UNSIGNED | NO | 0 | |||
| text6_0 | longtext | SIGNED | YES | NULL | |||
| text6_1 | longtext | SIGNED | YES | NULL | |||
| lang5 | TINYINT | UNSIGNED | NO | 0 | |||
| Probability6 | FLOAT | SIGNED | NO | 0 | |||
| em6_0 | SMALLINT | UNSIGNED | NO | 0 | |||
| em6_1 | SMALLINT | UNSIGNED | NO | 0 | |||
| em6_2 | SMALLINT | UNSIGNED | NO | 0 | |||
| em6_3 | SMALLINT | UNSIGNED | NO | 0 | |||
| em6_4 | SMALLINT | UNSIGNED | NO | 0 | |||
| em6_5 | SMALLINT | UNSIGNED | NO | 0 | |||
| text7_0 | longtext | SIGNED | YES | NULL | |||
| text7_1 | longtext | SIGNED | YES | NULL | |||
| lang7 | TINYINT | UNSIGNED | NO | 0 | |||
| Probability7 | FLOAT | SIGNED | NO | 0 | |||
| em7_0 | SMALLINT | UNSIGNED | NO | 0 | |||
| em7_1 | SMALLINT | UNSIGNED | NO | 0 | |||
| em7_2 | SMALLINT | UNSIGNED | NO | 0 | |||
| em7_3 | SMALLINT | UNSIGNED | NO | 0 | |||
| em7_4 | SMALLINT | UNSIGNED | NO | 0 | |||
| em7_5 | SMALLINT | UNSIGNED | NO | 0 | |||
| VerifiedBuild | SMALLINT | SIGNED | YES | 1 |
Field Descriptions
ID
This is the ID of the text entry.
text0_0
This is the locale text that is displayed if the聽NPC is a male.
text0_1
This is the locale text that is displayed if the聽NPC is a female.
BroadcastTextID0
The `broadcast_text`.`ID` field value for the `MaleText` in the `broadcast_text` table.
lang0
The language of the text in game. Refer to this page for the available language IDs. If set to 0, then it doesn't require to know any specific language.
Probability0
The percent-chance (probability) that the NPC will say either text0_0 or text0_1 depending on the NPCs gender.
em0_0
The ID of the emote that the NPC should do upon greeting the player.
em0_1
The use of this field is unknown.
em0_2
The use of this field is unknown.
em0_3
The use of this field is unknown.
em0_4
The use of this field is unknown.
em0_5
The use of this field is unknown.
text1_0
This is the locale text that is displayed if the聽NPC is a male.
text1_1
This is the locale text that is displayed if the聽NPC is a female.
BroadcastTextID1
The `broadcast_text`.`ID` field value for the `FemaleText` in the `broadcast_text` table.
lang1
The language of the text in game. Refer to this page for the available language IDs.
Probability1
The percent-chance (probability) that the NPC will say either text1_0 or text1_1 depending on the NPCs gender.
em1_0
The ID of the emote that the NPC should do upon greeting the player.
em1_1
The use of this field is unknown.
em1_2
The use of this field is unknown.
em1_3
The use of this field is unknown.
em1_4
The use of this field is unknown.
em1_5
The use of this field is unknown.
text2_0
This is the locale text that is displayed if the聽NPC is a male.
text2_1
This is the locale text that is displayed if the聽NPC is a female.
BroadcastTextID2
The use of this field is unknown.
lang2
The language of the text in game. Refer to this page for the available language IDs.
Probability2
The percent-chance (probability) that the NPC will say either text2_0 or text2_1 depending on the NPCs gender.
em2_0
The ID of the emote that the NPC should do upon greeting the player.
em2_1
The use of this field is unknown.
em2_2
The use of this field is unknown.
em2_3
The use of this field is unknown.
em2_4
The use of this field is unknown.
em2_5
The use of this field is unknown.
text3_0
This is the locale text that is displayed if the聽NPC is a male.
text3_1
This is the locale text that is displayed if the聽NPC is a female.
BroadcastTextID3
The use of this field is unknown.
lang3
The language of the text in game. Refer to this page for the available language IDs.
Probability3
The percent-chance (probability) that the NPC will say either text3_0 or text3_1 depending on the NPCs gender.
em3_0
The ID of the emote that the NPC should do upon greeting the player.
em3_1
The use of this field is unknown.
em3_2
The use of this field is unknown.
em3_3
The use of this field is unknown.
em3_4
The use of this field is unknown.
em3_5
The use of this field is unknown.
text4_0
This is the locale text that is displayed if the聽NPC is a male.
text4_1
This is the locale text that is displayed if the聽NPC is a female.
BroadcastTextID4
The use of this field is unknown.
lang4
The language of the text in game. Refer to this page for the available language IDs.
Probability4
The percent-chance (probability) that the NPC will say either text4_0 or text4_1 depending on the NPCs gender.
em4_0
The ID of the emote that the NPC should do upon greeting the player.
em4_1
The use of this field is unknown.
em4_2
The use of this field is unknown.
em4_3
The use of this field is unknown.
em4_4
The use of this field is unknown.
em4_5
The use of this field is unknown.
text5_0
This is the locale text that is displayed if the聽NPC is a male.
text5_1
This is the locale text that is displayed if the聽NPC is a female.
BroadcastTextID5
The use of this field is unknown.
lang5
The language of the text in game. Refer to this page for the available language IDs.
Probability5
The percent-chance (probability) that the NPC will say either text5_0 or text5_1 depending on the NPCs gender.
em5_0
The ID of the emote that the NPC should do upon greeting the player.
em5_1
The use of this field is unknown.
em5_2
The use of this field is unknown.
em5_3
The use of this field is unknown.
em5_4
The use of this field is unknown.
em5_5
The use of this field is unknown.
text6_0
This is the locale text that is displayed if the聽NPC is a male.
text6_1
This is the locale text that is displayed if the聽NPC is a female.
BroadcastTextID6
The use of this field is unknown.
lang6
The language of the text in game. Refer to this page for the available language IDs.
Probability6
The percent-chance (probability) that the NPC will say either text6_0 or text6_1 depending on the NPCs gender.
em6_0
The ID of the emote that the NPC should do upon greeting the player.
em6_1
The use of this field is unknown.
em6_2
The use of this field is unknown.
em6_3
The use of this field is unknown.
em6_4
The use of this field is unknown.
em6_5
The use of this field is unknown.
text7_0
This is the locale text that is displayed if the NPC is a male.
text7_1
This is the locale text that is displayed if the聽NPC is a female.
BroadcastTextID7
The use of this field is unknown.
lang7
The language of the text in game. Refer to this page for the available language IDs.
Probability7
The percent-chance (probability) that the NPC will say either text7_0 or text7_1 depending on the NPCs gender.
em7_0
The ID of the emote that the NPC should do upon greeting the player.
em7_1
The use of this field is unknown.
em7_2
The use of this field is unknown.
em7_3
The use of this field is unknown.
em7_4
The use of this field is unknown.
em7_5
The use of this field is unknown.
VerifiedBuild
This field was used to determine whether a template has been verified from WDB files.
If value is 0 then it has not been parsed yet.
If value is above 0 then it has been parsed with WDB files from that specific client build.
If value is -1 then it is just a place holder until proper data are found on WDBs.