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