AzerothCore
Posts (Latest 10 updated) :
Read all

npc_text

<-Back-to:World

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 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 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.