# npc\_text [<-Back-to:World](database-world.md) **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](Languages) 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](Languages) 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](Languages) 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](Languages) 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](Languages) 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](Languages) 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](Languages) 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](Languages) 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.