npc_text
This table contains the texts that are used for gossip. More research needs to be done on this table.
Field | Type | Attributes | Key | Null | Default |
mediumint(8) | unsigned | PRI | NO | 0 | |
longtext | signed | YES | NULL | ||
longtext | signed | YES | NULL | ||
tinyint(3) | unsigned | NO | 0 | ||
float | signed | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
longtext | signed | YES | NULL | ||
longtext | signed | YES | NULL | ||
tinyint(3) | unsigned | NO | 0 | ||
float | signed | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
longtext | signed | YES | NULL | ||
longtext | signed | YES | NULL | ||
tinyint(3) | unsigned | NO | 0 | ||
float | signed | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
longtext | signed | YES | NULL | ||
longtext | signed | YES | NULL | ||
tinyint(3) | unsigned | NO | 0 | ||
float | signed | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
longtext | signed | YES | NULL | ||
longtext | signed | YES | NULL | ||
tinyint(3) | unsigned | NO | 0 | ||
float | signed | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
longtext | signed | YES | NULL | ||
longtext | signed | YES | NULL | ||
tinyint(3) | unsigned | NO | 0 | ||
float | signed | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
longtext | signed | YES | NULL | ||
longtext | signed | YES | NULL | ||
lang5 | tinyint(3) | unsigned | NO | 0 | |
float | signed | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
longtext | signed | YES | NULL | ||
longtext | signed | YES | NULL | ||
tinyint(3) | unsigned | NO | 0 | ||
float | signed | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | unsigned | NO | 0 | ||
smallint(5) | signed | YES | 1 |
ID
This is the ID of the text entry.
text0_0 to text 7_0
This is the locale text that is displayed if the NPC is a male.
text0_1 to text 7_1
This is the locale text that is displayed if the NPC is a female.
BroadcastTextID0 to BroadcastTextID7
The `broadcast_text`.`ID` field value for the `MaleText` in the `broadcast_text` table.
lang0 to lang7
The language of the text in game, as described in Languages.DBC. As of 3.3.5a, these are:
ID | Name |
1 | Orcish |
2 | Darnassian |
3 | Taurahe |
6 | Dwarvish |
7 | Common |
8 | Demonic |
9 | Titan |
10 | Thalassian |
11 | Draconic |
12 | Kalimag |
13 | Gnomish |
14 | Troll |
33 | Gutterspeak |
35 | Draenei |
36 | Zombie |
37 | Gnomish Binary |
38 | Goblin Binary |
Probability0 to Probability7
The percent-chance (probability) that the NPC will say either text0_0 or text0_1 depending on the NPCs gender. 1 will always show this text, while 0.5 will show this text 50% of the time and then choose another text in the current row. The total of all probabilities in the current row should equal 1.
em0_0-5 to em7_0-5
The ID of the emote that the NPC should do when displaying the text. The emotes are played after each order in order. To see a list of emotes, see Emotes.DBC
VerifiedBuild
This field is used by the TrinityDB Team to determine whether a template has been verified from WDB files.
If value is 0 then it has not been parsed yet.
If value is above 0 then it has been parsed with WDB files from that specific client build.
If value is -1 then it is just a place holder until proper data are found on WDBs.