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 to text 7_0

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

text0_1 to text 7_1

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

BroadcastTextID0 to BroadcastTextID7

The `broadcast_text`.`ID` field value for the `MaleText` in the `broadcast_text` table.

lang0 to lang7

The language of the text in game, as described in Languages.DBC. As of 3.3.5a, these are:

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

Probability0 to Probability7

The percent-chance (probability) that the NPC will say either text0_0 or text0_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.

em0_0-5 to em7_0-5

The ID of the emote that the NPC should do when displaying the text. The emotes are played after each order in order. To see a list of emotes, see Emotes.DBC

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.