# 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

ID

mediumint(8)

unsigned

PRI

NO

0

text0_0

longtext

signed

 

YES

NULL

text0_1

longtext

signed

 

YES

NULL

lang0

tinyint(3)

unsigned

 

NO

0

Probability0

float

signed

 

NO

0

em0_0

smallint(5)

unsigned

 

NO

0

em0_1

smallint(5)

unsigned

 

NO

0

em0_2

smallint(5)

unsigned

 

NO

0

em0_3

smallint(5)

unsigned

 

NO

0

em0_4

smallint(5)

unsigned

 

NO

0

em0_5

smallint(5)

unsigned

 

NO

0

text1_0

longtext

signed

 

YES

NULL

text1_1

longtext

signed

 

YES

NULL

lang1

tinyint(3)

unsigned

 

NO

0

Probability1

float

signed

 

NO

0

em1_0

smallint(5)

unsigned

 

NO

0

em1_1

smallint(5)

unsigned

 

NO

0

em1_2

smallint(5)

unsigned

 

NO

0

em1_3

smallint(5)

unsigned

 

NO

0

em1_4

smallint(5)

unsigned

 

NO

0

em1_5

smallint(5)

unsigned

 

NO

0

text2_0

longtext

signed

 

YES

NULL

text2_1

longtext

signed

 

YES

NULL

lang2

tinyint(3)

unsigned

 

NO

0

Probability2

float

signed

 

NO

0

em2_0

smallint(5)

unsigned

 

NO

0

em2_1

smallint(5)

unsigned

 

NO

0

em2_2

smallint(5)

unsigned

 

NO

0

em2_3

smallint(5)

unsigned

 

NO

0

em2_4

smallint(5)

unsigned

 

NO

0

em2_5

smallint(5)

unsigned

 

NO

0

text3_0

longtext

signed

 

YES

NULL

text3_1

longtext

signed

 

YES

NULL

lang3

tinyint(3)

unsigned

 

NO

0

Probability3

float

signed

 

NO

0

em3_0

smallint(5)

unsigned

 

NO

0

em3_1

smallint(5)

unsigned

 

NO

0

em3_2

smallint(5)

unsigned

 

NO

0

em3_3

smallint(5)

unsigned

 

NO

0

em3_4

smallint(5)

unsigned

 

NO

0

em3_5

smallint(5)

unsigned

 

NO

0

text4_0

longtext

signed

 

YES

NULL

text4_1

longtext

signed

 

YES

NULL

lang4

tinyint(3)

unsigned

 

NO

0

Probability4

float

signed

 

NO

0

em4_0

smallint(5)

unsigned

 

NO

0

em4_1

smallint(5)

unsigned

 

NO

0

em4_2

smallint(5)

unsigned

 

NO

0

em4_3

smallint(5)

unsigned

 

NO

0

em4_4

smallint(5)

unsigned

 

NO

0

em4_5

smallint(5)

unsigned

 

NO

0

text5_0

longtext

signed

 

YES

NULL

text5_1

longtext

signed

 

YES

NULL

lang5

tinyint(3)

unsigned

 

NO

0

Probability5

float

signed

 

NO

0

em5_0

smallint(5)

unsigned

 

NO

0

em5_1

smallint(5)

unsigned

 

NO

0

em5_2

smallint(5)

unsigned

 

NO

0

em5_3

smallint(5)

unsigned

 

NO

0

em5_4

smallint(5)

unsigned

 

NO

0

em5_5

smallint(5)

unsigned

 

NO

0

text6_0

longtext

signed

 

YES

NULL

text6_1

longtext

signed

 

YES

NULL

lang5 tinyint(3) unsigned   NO 0

Probability6

float

signed

 

NO

0

em6_0

smallint(5)

unsigned

 

NO

0

em6_1

smallint(5)

unsigned

 

NO

0

em6_2

smallint(5)

unsigned

 

NO

0

em6_3

smallint(5)

unsigned

 

NO

0

em6_4

smallint(5)

unsigned

 

NO

0

em6_5

smallint(5)

unsigned

 

NO

0

text7_0

longtext

signed

 

YES

NULL

text7_1

longtext

signed

 

YES

NULL

lang7

tinyint(3)

unsigned

 

NO

0

Probability7

float

signed

 

NO

0

em7_0

smallint(5)

unsigned

 

NO

0

em7_1

smallint(5)

unsigned

 

NO

0

em7_2

smallint(5)

unsigned

 

NO

0

em7_3

smallint(5)

unsigned

 

NO

0

em7_4

smallint(5)

unsigned

 

NO

0

em7_5

smallint(5)

unsigned

 

NO

0

VerifiedBuild

smallint(5)

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. ### 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 is used by the TrinityDB Team 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.