Versiones comparadas

Clave

  • Se ha añadido esta línea.
  • Se ha eliminado esta línea.
  • El formato se ha cambiado.
Comentarios: Cleaned up unecessary repetition. Fixed broken links to DBC files

...

Panel
titleTable 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

ID74260855

mediumint(8)

unsigned

PRI

NO

0text0_0

74260855

longtext

signed 


YES

NULL

text0_174260855

longtext

signed

 


YES

NULL

lang074260855

tinyint(3)

unsigned 


NO

0

Probability074260855

float

signed 


NO

0em0_0

74260855

smallint(5)

unsigned

 


NO

0

em0_174260855

smallint(5)

unsigned 


NO

0

em0_274260855

smallint(5)

unsigned

 


NO

0

em0_374260855

smallint(5)

unsigned

 


NO

0

em0_474260855

smallint(5)

unsigned 


NO

0

em0_574260855

smallint(5)

unsigned

 


NO

0

text1_0

longtext

signed

 


YES

NULL

text1_1

longtext

signed 


YES

NULL

lang1

tinyint(3)

unsigned 


NO

0

Probability174260855

float

signed

 


NO

0em1_0

74260855

smallint(5)

unsigned

 


NO

0

em1_174260855

smallint(5)

unsigned

 


NO

0

em1_274260855

smallint(5)

unsigned

 


NO

0

em1_374260855

smallint(5)

unsigned 


NO

0

em1_474260855

smallint(5)

unsigned

 


NO

0

em1_574260855

smallint(5)

unsigned

 


NO

0text2_0

74260855

longtext

signed 


YES

NULL

text2_174260855

longtext

signed

 


YES

NULL

lang274260855

tinyint(3)

unsigned 


NO

0

Probability274260855

float

signed 


NO

0em2_0

74260855

smallint(5)

unsigned

 


NO

0

em2_174260855

smallint(5)

unsigned 


NO

0

em2_274260855

smallint(5)

unsigned 


NO

0

em2_374260855

smallint(5)

unsigned 


NO

0

em2_474260855

smallint(5)

unsigned 


NO

0

em2_574260855

smallint(5)

unsigned

 


NO

0text3_0

74260855

longtext

signed

 


YES

NULL

text3_174260855

longtext

signed 


YES

NULL

lang374260855

tinyint(3)

unsigned 


NO

0

Probability374260855

float

signed 


NO

0em3_0

74260855

smallint(5)

unsigned 


NO

0

em3_174260855

smallint(5)

unsigned

 


NO

0

em3_274260855

smallint(5)

unsigned 


NO

0

em3_374260855

smallint(5)

unsigned 


NO

0

em3_474260855

smallint(5)

unsigned 


NO

0

em3_574260855

smallint(5)

unsigned 


NO

0text4_0

74260855

longtext

signed 


YES

NULL

text4_174260855

longtext

signed 


YES

NULL

lang474260855

tinyint(3)

unsigned

 


NO

0

Probability474260855

float

signed 


NO

0em4_0

74260855

smallint(5)

unsigned

 


NO

0

em4_174260855

smallint(5)

unsigned

 


NO

0

em4_274260855

smallint(5)

unsigned

 


NO

0

em4_374260855

smallint(5)

unsigned

 


NO

0

em4_474260855

smallint(5)

unsigned 


NO

0

em4_574260855

smallint(5)

unsigned

 


NO

0text5_0

74260855

longtext

signed

 


YES

NULL

text5_174260855

longtext

signed 


YES

NULL

lang574260855

tinyint(3)

unsigned 


NO

0

Probability574260855

float

signed 


NO

0em5_0

74260855

smallint(5)

unsigned 


NO

0

em5_174260855

smallint(5)

unsigned

 


NO

0

em5_274260855

smallint(5)

unsigned 


NO

0

em5_374260855

smallint(5)

unsigned 


NO

0

em5_474260855

smallint(5)

unsigned 


NO

0

em5_574260855

smallint(5)

unsigned 


NO

0text6_0

74260855

longtext

signed

 


YES

NULL

text6_174260855

longtext

signed

 


YES

NULL

lang5tinyint(3)unsigned 
NO0

Probability674260855

float

signed 


NO

0em6_0

74260855

smallint(5)

unsigned 


NO

0

em6_174260855

smallint(5)

unsigned

 


NO

0

em6_274260855

smallint(5)

unsigned

 


NO

0

em6_374260855

smallint(5)

unsigned

 


NO

0

em6_474260855

smallint(5)

unsigned

 


NO

0

em6_574260855

smallint(5)

unsigned 


NO

0text7_0

74260855

longtext

signed

 


YES

NULL

text7_174260855

longtext

signed

 


YES

NULL

lang774260855

tinyint(3)

unsigned

 


NO

0

Probability774260855

float

signed 


NO

0em7_0

74260855

smallint(5)

unsigned 


NO

0

em7_174260855

smallint(5)

unsigned 


NO

0

em7_274260855

smallint(5)

unsigned

 


NO

0

em7_374260855

smallint(5)

unsigned 


NO

0

em7_474260855

smallint(5)

unsigned 


NO

0

em7_574260855

smallint(5)

unsigned 


NO

0

VerifiedBuild74260855

smallint(5)

signed 


YES

1



Panel
titleField 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. Refer to this page for the available language IDs.

Probability0

The percent-chance (probability) that the NPC will say either text0_0 or text0_1 depending on the NPCs gender.

em0_0

The ID of the emote that the NPC should do upon greeting the player.

em0_1

The use of this field is unknown.

em0_2

The use of this field is unknown.

em0_3

The use of this field is unknown.

em0_4

The use of this field is unknown.

em0_5

The use of this field is unknown.

text1_0

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

text1_1

This is the locale text that is displayed if the NPC is a female.

BroadcastTextID1

The `broadcast_text`.`ID` field value for the `FemaleText` in the `broadcast_text` table.

lang1

The language of the text in game. Refer to this page for the available language IDs.

Probability1

The percent-chance (probability) that the NPC will say either text1_0 or text1_1 depending on the NPCs gender.

em1_0

The ID of the emote that the NPC should do upon greeting the player.

em1_1

The use of this field is unknown.

em1_2

The use of this field is unknown.

em1_3

The use of this field is unknown.

em1_4

The use of this field is unknown.

em1_5

The use of this field is unknown.

text2_0

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

text2_1

This is the locale text that is displayed if the NPC is a female.

BroadcastTextID2

The use of this field is unknown.

lang2

The language of the text in game. Refer to this page for the available language IDs.

Probability2

The percent-chance (probability) that the NPC will say either text2_0 or text2_1 depending on the NPCs gender.

em2_0

The ID of the emote that the NPC should do upon greeting the player.

em2_1

The use of this field is unknown.

em2_2

The use of this field is unknown.

em2_3

The use of this field is unknown.

em2_4

The use of this field is unknown.

em2_5

The use of this field is unknown.

text3_0

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

text3_1

This is the locale text that is displayed if the NPC is a female.

BroadcastTextID3

The use of this field is unknown.

lang3

The language of the text in game. Refer to this page for the available language IDs.

Probability3

, 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 text3text0_0 or text3text0_1 depending on the NPCs gender.

em3_0

The ID of the emote that the NPC should do upon greeting the player.

em3_1

The use of this field is unknown.

em3_2

The use of this field is unknown.

em3_3

The use of this field is unknown.

em3_4

The use of this field is unknown.

em3_5

The use of this field is unknown.

text4_0

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

text4_1

This is the locale text that is displayed if the NPC is a female.

BroadcastTextID4

The use of this field is unknown.

lang4

The language of the text in game. Refer to this page for the available language IDs.

Probability4

The percent-chance (probability) that the NPC will say either text4_0 or text4_1 depending on the NPCs gender.

em4_0

The ID of the emote that the NPC should do upon greeting the player.

em4_1

The use of this field is unknown.

em4_2

The use of this field is unknown.

em4_3

The use of this field is unknown.

em4_4

The use of this field is unknown.

em4_5

The use of this field is unknown.

text5_0

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

text5_1

This is the locale text that is displayed if the NPC is a female.

BroadcastTextID5

The use of this field is unknown.

lang5

The language of the text in game. Refer to this page for the available language IDs.

Probability5

The percent-chance (probability) that the NPC will say either text5_0 or text5_1 depending on the NPCs gender.

em5_0

The ID of the emote that the NPC should do upon greeting the player.

em5_1

The use of this field is unknown.

em5_2

The use of this field is unknown.

em5_3

The use of this field is unknown.

em5_4

The use of this field is unknown.

em5_5

The use of this field is unknown.

text6_0

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

text6_1

This is the locale text that is displayed if the NPC is a female.

BroadcastTextID6

The use of this field is unknown.

lang6

The language of the text in game. Refer to this page for the available language IDs.

Probability6

The percent-chance (probability) that the NPC will say either text6_0 or text6_1 depending on the NPCs gender.

em6_0

The ID of the emote that the NPC should do upon greeting the player.

em6_1

The use of this field is unknown.

em6_2

The use of this field is unknown.

em6_3

The use of this field is unknown.

em6_4

The use of this field is unknown.

em6_5

The use of this field is unknown.

text7_0

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

text7_1

This is the locale text that is displayed if the NPC is a female.

BroadcastTextID7

The use of this field is unknown.

lang7

The language of the text in game. Refer to this page for the available language IDs.

Probability7

The percent-chance (probability) that the NPC will say either text7_0 or text7_1 depending on the NPCs gender.

em7_0

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 upon greeting when displaying the playertext.

em7_1

The use of this field is unknown.

em7_2

The use of this field is unknown.

em7_3

The use of this field is unknown.

em7_4

The use of this field is unknown.

em7_5

The use of this field is unknown.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.

...