npc_text

This table contains the texts that are used for gossip. More research needs to be done on this table.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
ID	int	unsigned	PRI	NO	0
text0_0	longtext			YES	NULL
text0_1	longtext			YES	NULL
BroadcastTextID0	int	signed		NO	0
lang0	tinyint	unsigned		NO	0
Probability0	float			NO	0
EmoteDelay0_0	smallint	unsigned		NO	0
Emote0_0	smallint	unsigned		NO	0
EmoteDelay0_1	smallint	unsigned		NO	0
Emote0_1	smallint	unsigned		NO	0
EmoteDelay0_2	smallint	unsigned		NO	0
Emote0_2	smallint	unsigned		NO	0
text1_0	longtext			YES	NULL
text1_1	longtext			YES	NULL
BroadcastTextID1	int	signed		NO	0
lang1	tinyint	unsigned		NO	0
Probability1	float			NO	0
EmoteDelay1_0	smallint	unsigned		NO	0
Emote1_0	smallint	unsigned		NO	0
EmoteDelay1_1	smallint	unsigned		NO	0
Emote1_1	smallint	unsigned		NO	0
EmoteDelay1_2	smallint	unsigned		NO	0
Emote1_2	smallint	unsigned		NO	0
text2_0	longtext			YES	NULL
text2_1	longtext			YES	NULL
BroadcastTextID2	int	signed		NO	0
lang2	tinyint	unsigned		NO	0
Probability2	float			NO	0
EmoteDelay2_0	smallint	unsigned		NO	0
Emote2_0	smallint	unsigned		NO	0
EmoteDelay2_1	smallint	unsigned		NO	0
Emote2_1	smallint	unsigned		NO	0
EmoteDelay2_2	smallint	unsigned		NO	0
Emote2_2	smallint	unsigned		NO	0
text3_0	longtext			YES	NULL
text3_1	longtext			YES	NULL
BroadcastTextID3	int	signed		NO	0
lang3	tinyint	unsigned		NO	0
Probability3	float			NO	0
EmoteDelay3_0	smallint	unsigned		NO	0
Emote3_0	smallint	unsigned		NO	0
EmoteDelay3_1	smallint	unsigned		NO	0
Emote3_1	smallint	unsigned		NO	0
EmoteDelay3_2	smallint	unsigned		NO	0
Emote3_2	smallint	unsigned		NO	0
text4_0	longtext			YES	NULL
text4_1	longtext			YES	NULL
BroadcastTextID4	int	signed		NO	0
lang4	tinyint	unsigned		NO	0
Probability4	float			NO	0
EmoteDelay4_0	smallint	unsigned		NO	0
Emote4_0	smallint	unsigned		NO	0
EmoteDelay4_1	smallint	unsigned		NO	0
Emote4_1	smallint	unsigned		NO	0
EmoteDelay4_2	smallint	unsigned		NO	0
Emote4_2	smallint	unsigned		NO	0
text5_0	longtext			YES	NULL
text5_1	longtext			YES	NULL
BroadcastTextID5	int	signed		NO	0
lang5	tinyint	unsigned		NO	0
Probability5	float			NO	0
EmoteDelay5_0	smallint	unsigned		NO	0
Emote5_0	smallint	unsigned		NO	0
EmoteDelay5_1	smallint	unsigned		NO	0
Emote5_1	smallint	unsigned		NO	0
EmoteDelay5_2	smallint	unsigned		NO	0
Emote5_2	smallint	unsigned		NO	0
text6_0	longtext			YES	NULL
text6_1	longtext			YES	NULL
BroadcastTextID6	int	signed		NO	0
lang6	tinyint	unsigned		NO	0
Probability6	float			NO	0
EmoteDelay6_0	smallint	unsigned		NO	0
Emote6_0	smallint	unsigned		NO	0
EmoteDelay6_1	smallint	unsigned		NO	0
Emote6_1	smallint	unsigned		NO	0
EmoteDelay6_2	smallint	unsigned		NO	0
Emote6_2	smallint	unsigned		NO	0
text7_0	longtext			YES	NULL
text7_1	longtext			YES	NULL
BroadcastTextID7	int	signed		NO	0
lang7	tinyint	unsigned		NO	0
Probability7	float			NO	0
EmoteDelay7_0	smallint	unsigned		NO	0
Emote7_0	smallint	unsigned		NO	0
EmoteDelay7_1	smallint	unsigned		NO	0
Emote7_1	smallint	unsigned		NO	0
EmoteDelay7_2	smallint	unsigned		NO	0
Emote7_2	smallint	unsigned		NO	0
VerifiedBuild	int	signed		YES	NULL

Description of fields

ID

This is the ID of the text entry.  

text[0-7]_0

This is the text that is displayed if the NPC is male.  

text[0-7]_1

This is the text that is displayed if the NPC is female.  

BroadcastTextID[0-7]

The broadcast_text.ID of this definition. It will entirely override this entry.  

lang[0-7]

The Language ID of the text in game.

ID	Language		ID	Language
1	Orcish		12	Kalimag
2	Darnassian		13	Gnomish
3	Taurahe		14	Troll
6	Dwarvish		33	Gutterspeak
7	Common		35	Draenei
8	Demonic		36	Zombie
9	Titan		37	Gnomish Binary
10	Thalassian		38	Goblin Binary
11	Draconic

 

Probability[0-7]

The percent-chance (probability) that the NPC will say either text*_0 or text*_1 depending on the NPCs gender. 1 will always show this text, while 0.5 will show this text 50% of the time and then choose another text in the current row. The total of all probabilities in the current row should equal 1.  

EmoteDelay[0-7]_[0-2]

The delay in milliseconds after which the next emote can be played.  

Emote[0-7]_[0-2]

The Emote ID that the NPC should do when displaying the text. The emotes are played after each other in order (0 – 2).  

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.

If value is -Client Build then it was parsed with WDB files from that specific client build and manually edited later for some special necessity.