“npc_text” table

The npc_text table holds the texts that are used for gossip.

Table structure

Field Type Null Key Default Extra
ID mediumint(8) unsigned NO PRI 0  
text0_0 longtext YES   NULL  
text0_1 longtext YES   NULL  
lang0 tinyint(3) unsigned NO   0  
prob0 float NO   0  
em0_0_delay smallint(5) unsigned NO   0  
em0_0 smallint(5) unsigned NO   0  
em0_1_delay smallint(5) unsigned NO   0  
em0_1 smallint(5) unsigned NO   0  
em0_2_delay smallint(5) unsigned NO   0  
em0_2 smallint(5) unsigned NO   0  
text1_0 longtext YES   NULL  
text1_1 longtext YES   NULL  
lang1 tinyint(3) unsigned NO   0  
prob1 float NO   0  
em1_0_delay smallint(5) unsigned NO   0  
em1_0 smallint(5) unsigned NO   0  
em1_1_delay smallint(5) unsigned NO   0  
em1_1 smallint(5) unsigned NO   0  
em1_2_delay smallint(5) unsigned NO   0  
em1_2 smallint(5) unsigned NO   0  
text2_0 longtext YES   NULL  
text2_1 longtext YES   NULL  
lang2 tinyint(3) unsigned NO   0  
prob2 float NO   0  
em2_0_delay smallint(5) unsigned NO   0  
em2_0 smallint(5) unsigned NO   0  
em2_1_delay smallint(5) unsigned NO   0  
em2_1 smallint(5) unsigned NO   0  
em2_2_delay smallint(5) unsigned NO   0  
em2_2 smallint(5) unsigned NO   0  
text3_0 longtext YES   NULL  
text3_1 longtext YES   NULL  
lang3 tinyint(3) unsigned NO   0  
prob3 float NO   0  
em3_0_delay smallint(5) unsigned NO   0  
em3_0 smallint(5) unsigned NO   0  
em3_1_delay smallint(5) unsigned NO   0  
em3_1 smallint(5) unsigned NO   0  
em3_2_delay smallint(5) unsigned NO   0  
em3_2 smallint(5) unsigned NO   0  
text4_0 longtext YES   NULL  
text4_1 longtext YES   NULL  
lang4 tinyint(3) unsigned NO   0  
prob4 float NO   0  
em4_0_delay smallint(5) unsigned NO   0  
em4_0 smallint(5) unsigned NO   0  
em4_1_delay smallint(5) unsigned NO   0  
em4_1 smallint(5) unsigned NO   0  
em4_2_delay smallint(5) unsigned NO   0  
em4_2 smallint(5) unsigned NO   0  
text5_0 longtext YES   NULL  
text5_1 longtext YES   NULL  
lang5 tinyint(3) unsigned NO   0  
prob5 float NO   0  
em5_0_delay smallint(5) unsigned NO   0  
em5_0 smallint(5) unsigned NO   0  
em5_1_delay smallint(5) unsigned NO   0  
em5_1 smallint(5) unsigned NO   0  
em5_2_delay smallint(5) unsigned NO   0  
em5_2 smallint(5) unsigned NO   0  
text6_0 longtext YES   NULL  
text6_1 longtext YES   NULL  
lang6 tinyint(3) unsigned NO   0  
prob6 float NO   0  
em6_0_delay smallint(5) unsigned NO   0  
em6_0 smallint(5) unsigned NO   0  
em6_1_delay smallint(5) unsigned NO   0  
em6_1 smallint(5) unsigned NO   0  
em6_2_delay smallint(5) unsigned NO   0  
em6_2 smallint(5) unsigned NO   0  
text7_0 longtext YES   NULL  
text7_1 longtext YES   NULL  
lang7 tinyint(3) unsigned NO   0  
prob7 float NO   0  
em7_0_delay smallint(5) unsigned NO   0  
em7_0 smallint(5) unsigned NO   0  
em7_1_delay smallint(5) unsigned NO   0  
em7_1 smallint(5) unsigned NO   0  
em7_2_delay smallint(5) unsigned NO   0  
em7_2 smallint(5) unsigned NO   0  

Fields

ID

The unique identifier of the text entry. Please note that the identifier is acquired from the game client by parsing the local WDB cache files.

It is unknown if text identifiers required a specific identifier to work.

text0_0

This is the locale text that is displayed if the creature is male.

text0_1

This is the locale text that is displayed if the creature is female.

lang0

The language of the text in game.

prob0

This is the probability that the creature will say this text.

em0_0_delay

Time to wait before the first emote is played.

em0_0

Emote to play when text is displayed.

em0_1_delay

Time to wait after the first emote are played, before the second emote gets played.

em0_1

Second emote to play when text is displayed.

em0_2_delay

Time to wait after the second emote are played, before the third emote gets played.

em0_2

Third emote to play when text is displayed.

text1_0

This is the locale text that is displayed if the creature is male.

text1_1

This is the locale text that is displayed if the creature is female.

lang1

The language of the text in game.

prob1

This is the probability that the creature will say this text.

em1_0_delay

Time to wait before the first emote is played.

em1_0

Emote to play when text is displayed.

em1_1_delay

Time to wait after the first emote are played, before the second emote gets played.

em1_1

Second emote to play when text is displayed.

em1_2_delay

Time to wait after the second emote are played, before the third emote gets played.

em1_2

Third emote to play when text is displayed.

text2_0

This is the locale text that is displayed if the creature is male.

text2_1

This is the locale text that is displayed if the creature is female.

lang2

The language of the text in game.

prob2

This is the probability that the creature will say this text.

em2_0_delay

Time to wait before the first emote is played.

em2_0

Emote to play when text is displayed.

em2_1_delay

Time to wait after the first emote are played, before the second emote gets played.

em2_1

Second emote to play when text is displayed.

em2_2_delay

Time to wait after the second emote are played, before the third emote gets played.

em2_2

Third emote to play when text is displayed.

text3_0

This is the locale text that is displayed if the creature is male.

text3_1

This is the locale text that is displayed if the creature is female.

lang3

The language of the text in game.

prob3

This is the probability that the creature will say this text.

em3_0_delay

Time to wait before the first emote is played.

em3_0

Emote to play when text is displayed.

em3_1_delay

Time to wait after the first emote are played, before the second emote gets played.

em3_1

Second emote to play when text is displayed.

em3_2_delay

Time to wait after the second emote are played, before the third emote gets played.

em3_2

Third emote to play when text is displayed.

text4_0

This is the locale text that is displayed if the creature is male.

text4_1

This is the locale text that is displayed if the creature is female.

lang4

The language of the text in game.

prob4

This is the probability that the creature will say this text.

em4_0_delay

Time to wait before the first emote is played.

em4_0

Emote to play when text is displayed.

em4_1_delay

Time to wait after the first emote are played, before the second emote gets played.

em4_1

Second emote to play when text is displayed.

em4_2_delay

Time to wait after the second emote are played, before the third emote gets played.

em4_2

Third emote to play when text is displayed.

text5_0

This is the locale text that is displayed if the creature is male.

text5_1

This is the locale text that is displayed if the creature is female.

lang5

The language of the text in game.

prob5

This is the probability that the creature will say this text.

em5_0_delay

Time to wait before the first emote is played.

em5_0

Emote to play when text is displayed.

em5_1_delay

Time to wait after the first emote are played, before the second emote gets played.

em5_1

Second emote to play when text is displayed.

em5_2_delay

Time to wait after the second emote are played, before the third emote gets played.

em5_2

Third emote to play when text is displayed.

text6_0

This is the locale text that is displayed if the creature is male.

text6_1

This is the locale text that is displayed if the creature is female.

lang6

The language of the text in game.

prob6

This is the probability that the creature will say this text.

em6_0_delay

Time to wait before the first emote is played.

em6_0

Emote to play when text is displayed.

em6_1_delay

Time to wait after the first emote are played, before the second emote gets played.

em6_1

Second emote to play when text is displayed.

em6_2_delay

Time to wait after the second emote are played, before the third emote gets played.

em6_2

Third emote to play when text is displayed.

text7_0

This is the locale text that is displayed if the creature is male.

text7_1

This is the locale text that is displayed if the creature is female.

lang7

The language of the text in game.

prob7

This is the probability that the creature will say this text.

em7_0_delay

Time to wait before the first emote is played.

em7_0

Emote to play when text is displayed.

em7_1_delay

Time to wait after the first emote are played, before the second emote gets played.

em7_1

Second emote to play when text is displayed.

em7_2_delay

Time to wait after the second emote are played, before the third emote gets played.

em7_2

Third emote to play when text is displayed.