|
NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. |
Description of the 'npc_text' table for MaNGOSZero
This table contains the texts that are used for gossip.
More research needs to be done on this table !
Text is shown in the start of the talk window.
Table Notes
This table uses the 'MyISAM' DB Engine
The Field definitions follow:
| Field Name | Field Type | Nullable | Key | Default Value | Attributes | Notes |
|---|---|---|---|---|---|---|
| ID | mediumint(8) unsigned | NO | PRI | '0' | The unique identifier of the text entry. | |
| text0_0 | longtext | YES | NULL | This is the locale text that is displayed if the creature is male. | ||
| text0_1 | longtext | YES | NULL | This is the locale text that is displayed if the creature is female. | ||
| lang0 | tinyint(3) unsigned | NO | '0' | The language of the text ingame. | ||
| prob0 | float | NO | '0' | This is the probability that the creature will say this text. | ||
| em0_0_delay | smallint(5) | YES | NULL | Time to wait before the first emote is played. | ||
| em0_0 | smallint(5) | YES | NULL | Emote to play when text is displayed. | ||
| em0_1_delay | smallint(5) | YES | NULL | Time to wait after the first emote are played, before the second emote. | ||
| em0_1 | smallint(5) | YES | NULL | Second emote to play when text is displayed. | ||
| em0_2_delay | smallint(5) | YES | NULL | Time to wait after the second emote are played, before the third emote. | ||
| em0_2 | smallint(5) | YES | NULL | Third emote to play when text is displayed | ||
| text1_0 | longtext | YES | NULL | This is the locale text that is displayed if the creature is male. | ||
| text1_1 | longtext | YES | NULL | This is the locale text that is displayed if the creature is female. | ||
| lang1 | tinyint(3) unsigned | NO | '0' | The language of the text in game. | ||
| prob1 | float | NO | '0' | This is the probability that the creature will say this text. | ||
| em1_0_delay | smallint(5) | YES | NULL | Time to wait before the first emote is played. | ||
| em1_0 | smallint(5) | YES | NULL | emote to play when text is displayed. | ||
| em1_1_delay | smallint(5) | YES | NULL | Time to wait after the first emote are played, before the second emote. | ||
| em1_1 | smallint(5) | YES | NULL | Second emote to play when text is displayed. | ||
| em1_2_delay | smallint(5) | YES | NULL | Time to wait after the second emote are played, before the third emote. | ||
| em1_2 | smallint(5) | YES | NULL | Third emote to play when text is displayed. | ||
| text2_0 | longtext | YES | NULL | This is the locale text that is displayed if the creature is male. | ||
| text2_1 | longtext | YES | NULL | This is the locale text that is displayed if the creature is female. | ||
| lang2 | tinyint(3) unsigned | NO | '0' | The language of the text in game. | ||
| prob2 | float | NO | '0' | This is the probability that the creature will say this text. | ||
| em2_0_delay | smallint(5) | YES | NULL | Time to wait before the first emote is played. | ||
| em2_0 | smallint(5) | YES | NULL | emote to play when text is displayed. | ||
| em2_1_delay | smallint(5) | YES | NULL | Time to wait after the first emote are played, before the second emote. | ||
| em2_1 | smallint(5) | YES | NULL | Second emote to play when text is displayed. | ||
| em2_2_delay | smallint(5) | YES | NULL | Time to wait after the second emote are played, before the third emote. | ||
| em2_2 | smallint(5) | YES | NULL | Third emote to play when text is displayed. | ||
| text3_0 | longtext | YES | NULL | This is the locale text that is displayed if the creature is male. | ||
| text3_1 | longtext | YES | NULL | This is the locale text that is displayed if the creature is female. | ||
| lang3 | tinyint(3) unsigned | NO | '0' | The language of the text in game. | ||
| prob3 | float | NO | '0' | This is the probability that the creature will say this text. | ||
| em3_0_delay | smallint(5) | YES | NULL | Time to wait before the first emote is played. | ||
| em3_0 | smallint(5) | YES | NULL | emote to play when text is displayed. | ||
| em3_1_delay | smallint(5) | YES | NULL | Time to wait after the first emote are played, before the second emote. | ||
| em3_1 | smallint(5) | YES | NULL | Second emote to play when text is displayed. | ||
| em3_2_delay | smallint(5) | YES | NULL | Time to wait after the second emote are played, before the third emote. | ||
| em3_2 | smallint(5) | YES | NULL | Third emote to play when text is displayed. | ||
| text4_0 | longtext | YES | NULL | This is the locale text that is displayed if the creature is male. | ||
| text4_1 | longtext | YES | NULL | This is the locale text that is displayed if the creature is female. | ||
| lang4 | tinyint(3) unsigned | NO | '0' | The language of the text in game. | ||
| prob4 | float | NO | '0' | This is the probability that the creature will say this text. | ||
| em4_0_delay | smallint(5) | YES | NULL | Time to wait before the first emote is played. | ||
| em4_0 | smallint(5) | YES | NULL | emote to play when text is displayed. | ||
| em4_1_delay | smallint(5) | YES | NULL | Time to wait after the first emote are played, before the second emote. | ||
| em4_1 | smallint(5) | YES | NULL | Second emote to play when text is displayed. | ||
| em4_2_delay | smallint(5) | YES | NULL | Time to wait after the second emote are played, before the third emote. | ||
| em4_2 | smallint(5) | YES | NULL | Third emote to play when text is displayed. | ||
| text5_0 | longtext | YES | NULL | This is the locale text that is displayed if the creature is male. | ||
| text5_1 | longtext | YES | NULL | This is the locale text that is displayed if the creature is female. | ||
| lang5 | tinyint(3) unsigned | NO | '0' | The language of the text in game. | ||
| prob5 | float | NO | '0' | This is the probability that the creature will say this text. | ||
| em5_0_delay | smallint(5) | YES | NULL | Time to wait before the first emote is played. | ||
| em5_0 | smallint(5) | YES | NULL | emote to play when text is displayed. | ||
| em5_1_delay | smallint(5) | YES | NULL | Time to wait after the first emote are played, before the second emote. | ||
| em5_1 | smallint(5) | YES | NULL | Second emote to play when text is displayed. | ||
| em5_2_delay | smallint(5) | YES | NULL | Time to wait after the second emote are played, before the third emote. | ||
| em5_2 | smallint(5) | YES | NULL | Third emote to play when text is displayed. | ||
| text6_0 | longtext | YES | NULL | This is the locale text that is displayed if the creature is male. | ||
| text6_1 | longtext | YES | NULL | This is the locale text that is displayed if the creature is female. | ||
| lang6 | tinyint(3) unsigned | NO | '0' | The language of the text in game. | ||
| prob6 | float | NO | '0' | This is the probability that the creature will say this text. | ||
| em6_0_delay | smallint(5) | YES | NULL | Time to wait before the first emote is played. | ||
| em6_0 | smallint(5) | YES | NULL | emote to play when text is displayed. | ||
| em6_1_delay | smallint(5) | YES | NULL | Time to wait after the first emote are played, before the second emote. | ||
| em6_1 | smallint(5) | YES | NULL | Second emote to play when text is displayed. | ||
| em6_2_delay | smallint(5) | YES | NULL | Time to wait after the second emote are played, before the third emote. | ||
| em6_2 | smallint(5) | YES | NULL | Third emote to play when text is displayed. | ||
| text7_0 | longtext | YES | NULL | This is the locale text that is displayed if the creature is male. | ||
| text7_1 | longtext | YES | NULL | This is the locale text that is displayed if the creature is female. | ||
| lang7 | tinyint(3) unsigned | NO | '0' | The language of the text in game. | ||
| prob7 | float | NO | '0' | This is the probability that the creature will say this text. | ||
| em7_0_delay | smallint(5) | YES | NULL | Time to wait before the first emote is played. | ||
| em7_0 | smallint(5) | YES | NULL | emote to play when text is displayed. | ||
| em7_1_delay | smallint(5) | YES | NULL | Time to wait after the first emote are played, before the second emote. | ||
| em7_1 | smallint(5) | YES | NULL | Second emote to play when text is displayed. | ||
| em7_2_delay | smallint(5) | YES | NULL | Time to wait after the second emote are played, before the third emote. | ||
| em7_2 | smallint(5) | YES | NULL | Third emote to play when text is displayed. |
Description of the fields
ID mediumint(8) unsigned
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 longtext
This is the locale text that is displayed if the creature is male.
text0_1 longtext
This is the locale text that is displayed if the creature is female.
lang0 tinyint(3) unsigned
The language of the text ingame.
prob0 float
This is the probability that the creature will say this text.
em0_0_delay smallint(5)
Time to wait before the first emote is played.
em0_0 smallint(5)
Emote to play when text is displayed.
em0_1_delay smallint(5)
Time to wait after the first emote are played, before the second emote gets played.
em0_1 smallint(5)
Second emote to play when text is displayed.
em0_2_delay smallint(5)
Time to wait after the second emote are played, before the third emote gets played.
em0_2 smallint(5)
Third emote to play when text is displayed
text1_0 longtext
This is the locale text that is displayed if the creature is male.
text1_1 longtext
This is the locale text that is displayed if the creature is female.
lang1 tinyint(3) unsigned
The language of the text in game.
prob1 float
This is the probability that the creature will say this text.
em1_0_delay smallint(5)
Time to wait before the first emote is played.
em1_0 smallint(5)
emote to play when text is displayed.
em1_1_delay smallint(5)
Time to wait after the first emote are played, before the second emote gets played.
em1_1 smallint(5)
Second emote to play when text is displayed.
em1_2_delay smallint(5)
Time to wait after the second emote are played, before the third emote gets played.
em1_2 smallint(5)
Third emote to play when text is displayed.
text2_0 longtext
This is the locale text that is displayed if the creature is male.
text2_1 longtext
This is the locale text that is displayed if the creature is female.
lang2 tinyint(3) unsigned
The language of the text in game.
prob2 float
This is the probability that the creature will say this text.
em2_0_delay smallint(5)
Time to wait before the first emote is played.
em2_0 smallint(5)
emote to play when text is displayed.
em2_1_delay smallint(5)
Time to wait after the first emote are played, before the second emote gets played.
em2_1 smallint(5)
Second emote to play when text is displayed.
em2_2_delay smallint(5)
Time to wait after the second emote are played, before the third emote gets played.
em2_2 smallint(5)
Third emote to play when text is displayed.
text3_0 longtext
This is the locale text that is displayed if the creature is male.
text3_1 longtext
This is the locale text that is displayed if the creature is female.
lang3 tinyint(3) unsigned
The language of the text in game.
prob3 float
This is the probability that the creature will say this text.
em3_0_delay smallint(5)
Time to wait before the first emote is played.
em3_0 smallint(5)
emote to play when text is displayed.
em3_1_delay smallint(5)
Time to wait after the first emote are played, before the second emote gets played.
em3_1 smallint(5)
Second emote to play when text is displayed.
em3_2_delay smallint(5)
Time to wait after the second emote are played, before the third emote gets played.
em3_2 smallint(5)
Third emote to play when text is displayed.
text4_0 longtext
This is the locale text that is displayed if the creature is male.
text4_1 longtext
This is the locale text that is displayed if the creature is female.
lang4 tinyint(3) unsigned
The language of the text in game.
prob4 float
This is the probability that the creature will say this text.
em4_0_delay smallint(5)
Time to wait before the first emote is played.
em4_0 smallint(5)
emote to play when text is displayed.
em4_1_delay smallint(5)
Time to wait after the first emote are played, before the second emote gets played.
em4_1 smallint(5)
Second emote to play when text is displayed.
em4_2_delay smallint(5)
Time to wait after the second emote are played, before the third emote gets played.
em4_2 smallint(5)
Third emote to play when text is displayed.
text5_0 longtext
This is the locale text that is displayed if the creature is male.
text5_1 longtext
This is the locale text that is displayed if the creature is female.
lang5 tinyint(3) unsigned
The language of the text in game.
prob5 float
This is the probability that the creature will say this text.
em5_0_delay smallint(5)
Time to wait before the first emote is played.
em5_0 smallint(5)
emote to play when text is displayed.
em5_1_delay smallint(5)
Time to wait after the first emote are played, before the second emote gets played.
em5_1 smallint(5)
Second emote to play when text is displayed.
em5_2_delay smallint(5)
Time to wait after the second emote are played, before the third emote gets played.
em5_2 smallint(5)
Third emote to play when text is displayed.
text6_0 longtext
This is the locale text that is displayed if the creature is male.
text6_1 longtext
This is the locale text that is displayed if the creature is female.
lang6 tinyint(3) unsigned
The language of the text in game.
prob6 float
This is the probability that the creature will say this text.
em6_0_delay smallint(5)
Time to wait before the first emote is played.
em6_0 smallint(5)
emote to play when text is displayed.
em6_1_delay smallint(5)
Time to wait after the first emote are played, before the second emote gets played.
em6_1 smallint(5)
Second emote to play when text is displayed.
em6_2_delay smallint(5)
Time to wait after the second emote are played, before the third emote gets played.
em6_2 smallint(5)
Third emote to play when text is displayed.
text7_0 longtext
This is the locale text that is displayed if the creature is male.
text7_1 longtext
This is the locale text that is displayed if the creature is female.
lang7 tinyint(3) unsigned
The language of the text in game.
prob7 float
This is the probability that the creature will say this text.
em7_0_delay smallint(5)
Time to wait before the first emote is played.
em7_0 smallint(5)
emote to play when text is displayed.
em7_1_delay smallint(5)
Time to wait after the first emote are played, before the second emote gets played.
em7_1 smallint(5)
Second emote to play when text is displayed.
em7_2_delay smallint(5)
Time to wait after the second emote are played, before the third emote gets played.
em7_2 smallint(5)
Third emote to play when text is displayed.
auto-generated by the getMaNGOS.eu MAGNET dbdocs module
Edited by Antz
Recommended Comments
There are no comments to display.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now