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

npc_text#ID

mediumint(8)

unsigned

PRI

NO

0

npc_text#text0_0

longtext

signed


YES

NULL

npc_text#text0_1

longtext

signed


YES

NULL

npc_text#lang0

tinyint(3)

unsigned


NO

0

npc_text#Probability0

float

signed


NO

0

npc_text#em0_0

smallint(5)

unsigned


NO

0

npc_text#em0_1

smallint(5)

unsigned


NO

0

npc_text#em0_2

smallint(5)

unsigned


NO

0

npc_text#em0_3

smallint(5)

unsigned


NO

0

npc_text#em0_4

smallint(5)

unsigned


NO

0

npc_text#em0_5

smallint(5)

unsigned


NO

0

text1_0

longtext

signed


YES

NULL

text1_1

longtext

signed


YES

NULL

lang1

tinyint(3)

unsigned


NO

0

npc_text#Probability1

float

signed


NO

0

npc_text#em1_0

smallint(5)

unsigned


NO

0

npc_text#em1_1

smallint(5)

unsigned


NO

0

npc_text#em1_2

smallint(5)

unsigned


NO

0

npc_text#em1_3

smallint(5)

unsigned


NO

0

npc_text#em1_4

smallint(5)

unsigned


NO

0

npc_text#em1_5

smallint(5)

unsigned


NO

0

npc_text#text2_0

longtext

signed


YES

NULL

npc_text#text2_1

longtext

signed


YES

NULL

npc_text#lang2

tinyint(3)

unsigned


NO

0

npc_text#Probability2

float

signed


NO

0

npc_text#em2_0

smallint(5)

unsigned


NO

0

npc_text#em2_1

smallint(5)

unsigned


NO

0

npc_text#em2_2

smallint(5)

unsigned


NO

0

npc_text#em2_3

smallint(5)

unsigned


NO

0

npc_text#em2_4

smallint(5)

unsigned


NO

0

npc_text#em2_5

smallint(5)

unsigned


NO

0

npc_text#text3_0

longtext

signed


YES

NULL

npc_text#text3_1

longtext

signed


YES

NULL

npc_text#lang3

tinyint(3)

unsigned


NO

0

npc_text#Probability3

float

signed


NO

0

npc_text#em3_0

smallint(5)

unsigned


NO

0

npc_text#em3_1

smallint(5)

unsigned


NO

0

npc_text#em3_2

smallint(5)

unsigned


NO

0

npc_text#em3_3

smallint(5)

unsigned


NO

0

npc_text#em3_4

smallint(5)

unsigned


NO

0

npc_text#em3_5

smallint(5)

unsigned


NO

0

npc_text#text4_0

longtext

signed


YES

NULL

npc_text#text4_1

longtext

signed


YES

NULL

npc_text#lang4

tinyint(3)

unsigned


NO

0

npc_text#Probability4

float

signed


NO

0

npc_text#em4_0

smallint(5)

unsigned


NO

0

npc_text#em4_1

smallint(5)

unsigned


NO

0

npc_text#em4_2

smallint(5)

unsigned


NO

0

npc_text#em4_3

smallint(5)

unsigned


NO

0

npc_text#em4_4

smallint(5)

unsigned


NO

0

npc_text#em4_5

smallint(5)

unsigned


NO

0

npc_text#text5_0

longtext

signed


YES

NULL

npc_text#text5_1

longtext

signed


YES

NULL

npc_text#lang5

tinyint(3)

unsigned


NO

0

npc_text#Probability5

float

signed


NO

0

npc_text#em5_0

smallint(5)

unsigned


NO

0

npc_text#em5_1

smallint(5)

unsigned


NO

0

npc_text#em5_2

smallint(5)

unsigned


NO

0

npc_text#em5_3

smallint(5)

unsigned


NO

0

npc_text#em5_4

smallint(5)

unsigned


NO

0

npc_text#em5_5

smallint(5)

unsigned


NO

0

npc_text#text6_0

longtext

signed


YES

NULL

npc_text#text6_1

longtext

signed


YES

NULL

lang5tinyint(3)unsigned
NO0

npc_text#Probability6

float

signed


NO

0

npc_text#em6_0

smallint(5)

unsigned


NO

0

npc_text#em6_1

smallint(5)

unsigned


NO

0

npc_text#em6_2

smallint(5)

unsigned


NO

0

npc_text#em6_3

smallint(5)

unsigned


NO

0

npc_text#em6_4

smallint(5)

unsigned


NO

0

npc_text#em6_5

smallint(5)

unsigned


NO

0

npc_text#text7_0

longtext

signed


YES

NULL

npc_text#text7_1

longtext

signed


YES

NULL

npc_text#lang7

tinyint(3)

unsigned


NO

0

npc_text#Probability7

float

signed


NO

0

npc_text#em7_0

smallint(5)

unsigned


NO

0

npc_text#em7_1

smallint(5)

unsigned


NO

0

npc_text#em7_2

smallint(5)

unsigned


NO

0

npc_text#em7_3

smallint(5)

unsigned


NO

0

npc_text#em7_4

smallint(5)

unsigned


NO

0

npc_text#em7_5

smallint(5)

unsigned


NO

0

npc_text#VerifiedBuild

smallint(5)

signed


YES

1

Field Descriptions

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.