|
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 MaNGOSThree
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 'InnoDB' 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 | smallint(5) unsigned | NO | '0' | Emote to play when text is displayed. | ||
| em0_1 | smallint(5) unsigned | NO | '0' | Second emote to play when text is displayed. | ||
| em0_2 | smallint(5) unsigned | NO | '0' | Third emote to play when text is displayed | ||
| em0_3 | smallint(5) unsigned | NO | '0' | |||
| em0_4 | smallint(5) unsigned | NO | '0' | |||
| em0_5 | smallint(5) unsigned | NO | '0' | |||
| 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 | smallint(5) unsigned | NO | '0' | emote to play when text is displayed. | ||
| em1_1 | smallint(5) unsigned | NO | '0' | Second emote to play when text is displayed. | ||
| em1_2 | smallint(5) unsigned | NO | '0' | Third emote to play when text is displayed. | ||
| em1_3 | smallint(5) unsigned | NO | '0' | |||
| em1_4 | smallint(5) unsigned | NO | '0' | |||
| em1_5 | smallint(5) unsigned | NO | '0' | |||
| 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 | smallint(5) unsigned | NO | '0' | emote to play when text is displayed. | ||
| em2_1 | smallint(5) unsigned | NO | '0' | Second emote to play when text is displayed. | ||
| em2_2 | smallint(5) unsigned | NO | '0' | Third emote to play when text is displayed. | ||
| em2_3 | smallint(5) unsigned | NO | '0' | |||
| em2_4 | smallint(5) unsigned | NO | '0' | |||
| em2_5 | smallint(5) unsigned | NO | '0' | |||
| 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 | smallint(5) unsigned | NO | '0' | emote to play when text is displayed. | ||
| em3_1 | smallint(5) unsigned | NO | '0' | Second emote to play when text is displayed. | ||
| em3_2 | smallint(5) unsigned | NO | '0' | Third emote to play when text is displayed. | ||
| em3_3 | smallint(5) unsigned | NO | '0' | |||
| em3_4 | smallint(5) unsigned | NO | '0' | |||
| em3_5 | smallint(5) unsigned | NO | '0' | |||
| 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 | smallint(5) unsigned | NO | '0' | emote to play when text is displayed. | ||
| em4_1 | smallint(5) unsigned | NO | '0' | Second emote to play when text is displayed. | ||
| em4_2 | smallint(5) unsigned | NO | '0' | Third emote to play when text is displayed. | ||
| em4_3 | smallint(5) unsigned | NO | '0' | |||
| em4_4 | smallint(5) unsigned | NO | '0' | |||
| em4_5 | smallint(5) unsigned | NO | '0' | |||
| 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 | smallint(5) unsigned | NO | '0' | emote to play when text is displayed. | ||
| em5_1 | smallint(5) unsigned | NO | '0' | Second emote to play when text is displayed. | ||
| em5_2 | smallint(5) unsigned | NO | '0' | Third emote to play when text is displayed. | ||
| em5_3 | smallint(5) unsigned | NO | '0' | |||
| em5_4 | smallint(5) unsigned | NO | '0' | |||
| em5_5 | smallint(5) unsigned | NO | '0' | |||
| 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 | smallint(5) unsigned | NO | '0' | emote to play when text is displayed. | ||
| em6_1 | smallint(5) unsigned | NO | '0' | Second emote to play when text is displayed. | ||
| em6_2 | smallint(5) unsigned | NO | '0' | Third emote to play when text is displayed. | ||
| em6_3 | smallint(5) unsigned | NO | '0' | |||
| em6_4 | smallint(5) unsigned | NO | '0' | |||
| em6_5 | smallint(5) unsigned | NO | '0' | |||
| 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 | smallint(5) unsigned | NO | '0' | emote to play when text is displayed. | ||
| em7_1 | smallint(5) unsigned | NO | '0' | Second emote to play when text is displayed. | ||
| em7_2 | smallint(5) unsigned | NO | '0' | Third emote to play when text is displayed. | ||
| em7_3 | smallint(5) unsigned | NO | '0' | |||
| em7_4 | smallint(5) unsigned | NO | '0' | |||
| em7_5 | smallint(5) unsigned | NO | '0' |
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 smallint(5) unsigned
Emote to play when text is displayed.
em0_1 smallint(5) unsigned
Second emote to play when text is displayed.
em0_2 smallint(5) unsigned
Third emote to play when text is displayed
em0_3 smallint(5) unsigned
em0_4 smallint(5) unsigned
em0_5 smallint(5) unsigned
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 smallint(5) unsigned
emote to play when text is displayed.
em1_1 smallint(5) unsigned
Second emote to play when text is displayed.
em1_2 smallint(5) unsigned
Third emote to play when text is displayed.
em1_3 smallint(5) unsigned
em1_4 smallint(5) unsigned
em1_5 smallint(5) unsigned
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 smallint(5) unsigned
emote to play when text is displayed.
em2_1 smallint(5) unsigned
Second emote to play when text is displayed.
em2_2 smallint(5) unsigned
Third emote to play when text is displayed.
em2_3 smallint(5) unsigned
em2_4 smallint(5) unsigned
em2_5 smallint(5) unsigned
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 smallint(5) unsigned
emote to play when text is displayed.
em3_1 smallint(5) unsigned
Second emote to play when text is displayed.
em3_2 smallint(5) unsigned
Third emote to play when text is displayed.
em3_3 smallint(5) unsigned
em3_4 smallint(5) unsigned
em3_5 smallint(5) unsigned
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 smallint(5) unsigned
emote to play when text is displayed.
em4_1 smallint(5) unsigned
Second emote to play when text is displayed.
em4_2 smallint(5) unsigned
Third emote to play when text is displayed.
em4_3 smallint(5) unsigned
em4_4 smallint(5) unsigned
em4_5 smallint(5) unsigned
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 smallint(5) unsigned
emote to play when text is displayed.
em5_1 smallint(5) unsigned
Second emote to play when text is displayed.
em5_2 smallint(5) unsigned
Third emote to play when text is displayed.
em5_3 smallint(5) unsigned
em5_4 smallint(5) unsigned
em5_5 smallint(5) unsigned
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 smallint(5) unsigned
emote to play when text is displayed.
em6_1 smallint(5) unsigned
Second emote to play when text is displayed.
em6_2 smallint(5) unsigned
Third emote to play when text is displayed.
em6_3 smallint(5) unsigned
em6_4 smallint(5) unsigned
em6_5 smallint(5) unsigned
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 smallint(5) unsigned
emote to play when text is displayed.
em7_1 smallint(5) unsigned
Second emote to play when text is displayed.
em7_2 smallint(5) unsigned
Third emote to play when text is displayed.
em7_3 smallint(5) unsigned
em7_4 smallint(5) unsigned
em7_5 smallint(5) unsigned
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