TrinityCore : npc_text

Back-to:World

The `npc_text` table

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

Structure

<t/tdptd class=/tdtd class=/atd class=d class="confluenceTd">lang6

Field	Type	Attributes	Key	Null	Default	Extra	Comment
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
prob0	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
prob1	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
prob2	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
prob3	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
prob4	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
prob5	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
tinyint(3)	unsigned		NO	0
prob6	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
prob7	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
WDBVerified	smallint(5)	signed		YES	1

Description of the fields

ID

This is the ID of the text entry. WDB-fields

text0_0-7_0

This is the locale text that is displayed if the npc is a male WDB-fields

text0_1-7_1

This is the locale text that is displayed if the npc is a female WDB-fields

lang0-7

The language of the text in game (post list of possible values). WDB-fields

prob0-7

This is the probability that the NPC will say this text. WDB-fields

em0_0

Emote on greet? WDB-fields

em0_1-7_1

Emote on ? WDB-fields

em0_2-7_2

Emote on ? WDB-fields

em0_3-7_3

Emote on ? WDB-fields

em0_4-7_4

Emote on ? WDB-fields

em0_5-7_5

Emote on ? WDB-fields

WDBVerified

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.

td class= td class=