Npc_text

Back to world database list of tables.

The `npc_text` table

This table contains the texts that are used for gossip. More research needs to be done on this table.
Text is showed in start of talk window.

Structure

Field	Type	Null	Key	Default	Extra
ID	int(11) unsigned	NO	PRI	0
text0_0	longtext	YES
text0_1	longtext	YES
lang0	bigint(20) unsigned	NO		0
prob0	float	NO		0
em0_0	bigint(20) unsigned	NO		0
em0_1	bigint(20) unsigned	NO		0
em0_2	bigint(20) unsigned	NO		0
em0_3	bigint(20) unsigned	NO		0
em0_4	bigint(20) unsigned	NO		0
em0_5	bigint(20) unsigned	NO		0
text1_0	longtext	YES
text1_1	longtext	YES
lang1	bigint(20) unsigned	NO		0
prob1	float	NO		0
em1_0	bigint(20) unsigned	NO		0
em1_1	bigint(20) unsigned	NO		0
em1_2	bigint(20) unsigned	NO		0
em1_3	bigint(20) unsigned	NO		0
em1_4	bigint(20) unsigned	NO		0
em1_5	bigint(20) unsigned	NO		0
text2_0	longtext	YES
text2_1	longtext	YES
lang2	bigint(20) unsigned	NO		0
prob2	float	NO		0
em2_0	bigint(20) unsigned	NO		0
em2_1	bigint(20) unsigned	NO		0
em2_2	bigint(20) unsigned	NO		0
em2_3	bigint(20) unsigned	NO		0
em2_4	bigint(20) unsigned	NO		0
em2_5	bigint(20) unsigned	NO		0
text3_0	longtext	YES
text3_1	longtext	YES
lang3	bigint(20) unsigned	NO		0
prob3	float	NO		0
em3_0	bigint(20) unsigned	NO		0
em3_1	bigint(20) unsigned	NO		0
em3_2	bigint(20) unsigned	NO		0
em3_3	bigint(20) unsigned	NO		0
em3_4	bigint(20) unsigned	NO		0
em3_5	bigint(20) unsigned	NO		0
text4_0	longtext	YES
text4_1	longtext	YES
lang4	bigint(20) unsigned	NO		0
prob4	float	NO		0
em4_0	bigint(20) unsigned	NO		0
em4_1	bigint(20) unsigned	NO		0
em4_2	bigint(20) unsigned	NO		0
em4_3	bigint(20) unsigned	NO		0
em4_4	bigint(20) unsigned	NO		0
em4_5	bigint(20) unsigned	NO		0
text5_0	longtext	YES
text5_1	longtext	YES
lang5	bigint(20) unsigned	NO		0
prob5	float	NO		0
em5_0	bigint(20) unsigned	NO		0
em5_1	bigint(20) unsigned	NO		0
em5_2	bigint(20) unsigned	NO		0
em5_3	bigint(20) unsigned	NO		0
em5_4	bigint(20) unsigned	NO		0
em5_5	bigint(20) unsigned	NO		0
text6_0	longtext	YES
text6_1	longtext	YES
lang6	bigint(20) unsigned	NO		0
prob6	float	NO		0
em6_0	bigint(20) unsigned	NO		0
em6_1	bigint(20) unsigned	NO		0
em6_2	bigint(20) unsigned	NO		0
em6_3	bigint(20) unsigned	NO		0
em6_4	bigint(20) unsigned	NO		0
em6_5	bigint(20) unsigned	NO		0
text7_0	longtext	YES
text7_1	longtext	YES
lang7	bigint(20) unsigned	NO		0
prob7	float	NO		0
em7_0	bigint(20) unsigned	NO		0
em7_1	bigint(20) unsigned	NO		0
em7_2	bigint(20) unsigned	NO		0
em7_3	bigint(20) unsigned	NO		0
em7_4	bigint(20) unsigned	NO		0
em7_5	bigint(20) unsigned	NO		0

Description of the fields

ID

This is the ID of the text entry. This ID comes from WDB cache. (First initialized to database from Blizzard WDB cache)

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.

lang0

The language of the text in game (post list of possible values)

prob0

This is the probability that the NPC will say this text

• 1 means always.

em0_0

emX_[0,2,6] – Delay for emote 1,2,3
emX_[1,3,5] – EmoteID 1,2,3

em0_1

Emote on ?

em0_2

Emote on ?

em0_3

Emote on ?

em0_4

Emote on ?

em0_5

Emote on ?

text1_0

text1_1

lang1

prob1

em1_0

em1_1

em1_2

em1_3

em1_4

em1_5

text2_0

text2_1

lang2

prob2

em2_0

em2_1

em2_2

em2_3

em2_4

em2_5

text3_0

text3_1

lang3

prob3

em3_0

em3_1

em3_2

em3_3

em3_4

em3_5

text4_0

text4_1

lang4

prob4

em4_0

em4_1

em4_2

em4_3

em4_4

em4_5

text5_0

text5_1

lang5

prob5

em5_0

em5_1

em5_2

em5_3

em5_4

em5_5

text6_0

text6_1

lang6

prob6

em6_0

em6_1

em6_2

em6_3

em6_4

em6_5

text7_0

text7_1

lang7

prob7

em7_0

em7_1

em7_2

em7_3

em7_4

em7_5