AzerothCore
Pages :

npc_text

<-Back-to:World

Table Structure

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 INT UNSIGNED PRI NO 0
text0_0 longtext YES
text0_1 longtext YES
BroadcastTextID0 INT NO 0
lang0 TINYINT UNSIGNED NO 0
Probability0 FLOAT NO 0
em0_0 SMALLINT UNSIGNED NO 0
em0_1 SMALLINT UNSIGNED NO 0
em0_2 SMALLINT UNSIGNED NO 0
em0_3 SMALLINT UNSIGNED NO 0
em0_4 SMALLINT UNSIGNED NO 0
em0_5 SMALLINT UNSIGNED NO 0
text1_0 longtext YES
text1_1 longtext YES
BroadcastTextID1 INT NO 0
lang1 TINYINT UNSIGNED NO 0
Probability1 FLOAT NO 0
em1_0 SMALLINT UNSIGNED NO 0
em1_1 SMALLINT UNSIGNED NO 0
em1_2 SMALLINT UNSIGNED NO 0
em1_3 SMALLINT UNSIGNED NO 0
em1_4 SMALLINT UNSIGNED NO 0
em1_5 SMALLINT UNSIGNED NO 0
text2_0 longtext YES
text2_1 longtext YES
BroadcastTextID2 INT NO 0
lang2 TINYINT UNSIGNED NO 0
Probability2 FLOAT NO 0
em2_0 SMALLINT UNSIGNED NO 0
em2_1 SMALLINT UNSIGNED NO 0
em2_2 SMALLINT UNSIGNED NO 0
em2_3 SMALLINT UNSIGNED NO 0
em2_4 SMALLINT UNSIGNED NO 0
em2_5 SMALLINT UNSIGNED NO 0
text3_0 longtext YES
text3_1 longtext YES
BroadcastTextID3 INT NO 0
lang3 TINYINT UNSIGNED NO 0
Probability3 FLOAT NO 0
em3_0 SMALLINT UNSIGNED NO 0
em3_1 SMALLINT UNSIGNED NO 0
em3_2 SMALLINT UNSIGNED NO 0
em3_3 SMALLINT UNSIGNED NO 0
em3_4 SMALLINT UNSIGNED NO 0
em3_5 SMALLINT UNSIGNED NO 0
text4_0 longtext YES
text4_1 longtext YES
BroadcastTextID4 INT NO 0
lang4 TINYINT UNSIGNED NO 0
Probability4 FLOAT NO 0
em4_0 SMALLINT UNSIGNED NO 0
em4_1 SMALLINT UNSIGNED NO 0
em4_2 SMALLINT UNSIGNED NO 0
em4_3 SMALLINT UNSIGNED NO 0
em4_4 SMALLINT UNSIGNED NO 0
em4_5 SMALLINT UNSIGNED NO 0
text5_0 longtext YES
text5_1 longtext YES
BroadcastTextID5 INT NO 0
lang5 TINYINT UNSIGNED NO 0
Probability5 FLOAT NO 0
em5_0 SMALLINT UNSIGNED NO 0
em5_1 SMALLINT UNSIGNED NO 0
em5_2 SMALLINT UNSIGNED NO 0
em5_3 SMALLINT UNSIGNED NO 0
em5_4 SMALLINT UNSIGNED NO 0
em5_5 SMALLINT UNSIGNED NO 0
text6_0 longtext YES
text6_1 longtext YES
BroadcastTextID6 INT NO 0
lang6 TINYINT UNSIGNED NO 0
Probability6 FLOAT NO 0
em6_0 SMALLINT UNSIGNED NO 0
em6_1 SMALLINT UNSIGNED NO 0
em6_2 SMALLINT UNSIGNED NO 0
em6_3 SMALLINT UNSIGNED NO 0
em6_4 SMALLINT UNSIGNED NO 0
em6_5 SMALLINT UNSIGNED NO 0
text7_0 longtext YES
text7_1 longtext YES
BroadcastTextID7 INT NO 0
lang7 TINYINT UNSIGNED NO 0
Probability7 FLOAT NO 0
em7_0 SMALLINT UNSIGNED NO 0
em7_1 SMALLINT UNSIGNED NO 0
em7_2 SMALLINT UNSIGNED NO 0
em7_3 SMALLINT UNSIGNED NO 0
em7_4 SMALLINT UNSIGNED NO 0
em7_5 SMALLINT UNSIGNED NO 0
VerifiedBuild INT YES NULL

Field Descriptions

ID

This is the ID of the text entry.

text0_0 to text7_0

This is the locale text that is displayed if the聽NPC is a male.

text0_1 to text7_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. Refer to this page for the available language IDs. If set to 0, then it doesn't require to know any specific language.

Probability0 to Probability7

The chance that the NPC will say either text0_0 or text0_1 depending on the NPCs gender.

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 was used 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.