Back to 'npc_spellclick_spells' Return to world Go to 'npc_text_locale'
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 | Extra | Comment |
|---|---|---|---|---|---|---|---|
| ID | mediumint | unsigned | PRI | NO | 0 | ||
| text0_0 | longtext | YES | NULL | ||||
| text0_1 | longtext | YES | NULL | ||||
| BroadcastTextID0 | mediumint | signed | NO | 0 | |||
| lang0 | tinyint | unsigned | NO | 0 | |||
| Probability0 | float | NO | 0 | ||||
| EmoteDelay0_0 | smallint | unsigned | NO | 0 | |||
| Emote0_0 | smallint | unsigned | NO | 0 | |||
| EmoteDelay0_1 | smallint | unsigned | NO | 0 | |||
| Emote0_1 | smallint | unsigned | NO | 0 | |||
| EmoteDelay0_2 | smallint | unsigned | NO | 0 | |||
| Emote0_2 | smallint | unsigned | NO | 0 | |||
| text1_0 | longtext | YES | NULL | ||||
| text1_1 | longtext | YES | NULL | ||||
| BroadcastTextID1 | mediumint | signed | NO | 0 | |||
| lang1 | tinyint | unsigned | NO | 0 | |||
| Probability1 | float | NO | 0 | ||||
| EmoteDelay1_0 | smallint | unsigned | NO | 0 | |||
| Emote1_0 | smallint | unsigned | NO | 0 | |||
| EmoteDelay1_1 | smallint | unsigned | NO | 0 | |||
| Emote1_1 | smallint | unsigned | NO | 0 | |||
| EmoteDelay1_2 | smallint | unsigned | NO | 0 | |||
| Emote1_2 | smallint | unsigned | NO | 0 | |||
| text2_0 | longtext | YES | NULL | ||||
| text2_1 | longtext | YES | NULL | ||||
| BroadcastTextID2 | mediumint | signed | NO | 0 | |||
| lang2 | tinyint | unsigned | NO | 0 | |||
| Probability2 | float | NO | 0 | ||||
| EmoteDelay2_0 | smallint | unsigned | NO | 0 | |||
| Emote2_0 | smallint | unsigned | NO | 0 | |||
| EmoteDelay2_1 | smallint | unsigned | NO | 0 | |||
| Emote2_1 | smallint | unsigned | NO | 0 | |||
| EmoteDelay2_2 | smallint | unsigned | NO | 0 | |||
| Emote2_2 | smallint | unsigned | NO | 0 | |||
| text3_0 | longtext | YES | NULL | ||||
| text3_1 | longtext | YES | NULL | ||||
| BroadcastTextID3 | mediumint | signed | NO | 0 | |||
| lang3 | tinyint | unsigned | NO | 0 | |||
| Probability3 | float | NO | 0 | ||||
| EmoteDelay3_0 | smallint | unsigned | NO | 0 | |||
| Emote3_0 | smallint | unsigned | NO | 0 | |||
| EmoteDelay3_1 | smallint | unsigned | NO | 0 | |||
| Emote3_1 | smallint | unsigned | NO | 0 | |||
| EmoteDelay3_2 | smallint | unsigned | NO | 0 | |||
| Emote3_2 | smallint | unsigned | NO | 0 | |||
| text4_0 | longtext | YES | NULL | ||||
| text4_1 | longtext | YES | NULL | ||||
| BroadcastTextID4 | mediumint | signed | NO | 0 | |||
| lang4 | tinyint | unsigned | NO | 0 | |||
| Probability4 | float | NO | 0 | ||||
| EmoteDelay4_0 | smallint | unsigned | NO | 0 | |||
| Emote4_0 | smallint | unsigned | NO | 0 | |||
| EmoteDelay4_1 | smallint | unsigned | NO | 0 | |||
| Emote4_1 | smallint | unsigned | NO | 0 | |||
| EmoteDelay4_2 | smallint | unsigned | NO | 0 | |||
| Emote4_2 | smallint | unsigned | NO | 0 | |||
| text5_0 | longtext | YES | NULL | ||||
| text5_1 | longtext | YES | NULL | ||||
| BroadcastTextID5 | mediumint | signed | NO | 0 | |||
| lang5 | tinyint | unsigned | NO | 0 | |||
| Probability5 | float | NO | 0 | ||||
| EmoteDelay5_0 | smallint | unsigned | NO | 0 | |||
| Emote5_0 | smallint | unsigned | NO | 0 | |||
| EmoteDelay5_1 | smallint | unsigned | NO | 0 | |||
| Emote5_1 | smallint | unsigned | NO | 0 | |||
| EmoteDelay5_2 | smallint | unsigned | NO | 0 | |||
| Emote5_2 | smallint | unsigned | NO | 0 | |||
| text6_0 | longtext | YES | NULL | ||||
| text6_1 | longtext | YES | NULL | ||||
| BroadcastTextID6 | mediumint | signed | NO | 0 | |||
| lang6 | tinyint | unsigned | NO | 0 | |||
| Probability6 | float | NO | 0 | ||||
| EmoteDelay6_0 | smallint | unsigned | NO | 0 | |||
| Emote6_0 | smallint | unsigned | NO | 0 | |||
| EmoteDelay6_1 | smallint | unsigned | NO | 0 | |||
| Emote6_1 | smallint | unsigned | NO | 0 | |||
| EmoteDelay6_2 | smallint | unsigned | NO | 0 | |||
| Emote6_2 | smallint | unsigned | NO | 0 | |||
| text7_0 | longtext | YES | NULL | ||||
| text7_1 | longtext | YES | NULL | ||||
| BroadcastTextID7 | mediumint | signed | NO | 0 | |||
| lang7 | tinyint | unsigned | NO | 0 | |||
| Probability7 | float | NO | 0 | ||||
| EmoteDelay7_0 | smallint | unsigned | NO | 0 | |||
| Emote7_0 | smallint | unsigned | NO | 0 | |||
| EmoteDelay7_1 | smallint | unsigned | NO | 0 | |||
| Emote7_1 | smallint | unsigned | NO | 0 | |||
| EmoteDelay7_2 | smallint | unsigned | NO | 0 | |||
| Emote7_2 | smallint | unsigned | NO | 0 | |||
| VerifiedBuild | smallint | signed | YES | 0 |
This is the ID of the text entry.
This is the text that is displayed if the NPC is male.
This is the text that is displayed if the NPC is female.
The broadcast_text.ID of this definition. It will entirely override this entry.
The Language ID of the text in game.
| ID | Language | ID | Language | |
|---|---|---|---|---|
| 1 | Orcish | 12 | Kalimag | |
| 2 | Darnassian | 13 | Gnomish | |
| 3 | Taurahe | 14 | Troll | |
| 6 | Dwarvish | 33 | Gutterspeak | |
| 7 | Common | 35 | Draenei | |
| 8 | Demonic | 36 | Zombie | |
| 9 | Titan | 37 | Gnomish Binary | |
| 10 | Thalassian | 38 | Goblin Binary | |
| 11 | Draconic |
The percent-chance (probability) that the NPC will say either text*_0 or text*_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.
The delay in milliseconds after which the next emote can be played.
The Emote ID that the NPC should do when displaying the text. The emotes are played after each other in order (0 - 2).
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.
If value is -Client Build then it was parsed with WDB files from that specific client build and manually edited later for some special necessity.
Back to 'npc_spellclick_spells' Return to world Go to 'npc_text_locale'