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