From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/npc_text.md | 1138 +++++++++++++++++++++++++++++++++++++++++++++++++----- 1 file changed, 1052 insertions(+), 86 deletions(-) (limited to 'docs/npc_text.md') diff --git a/docs/npc_text.md b/docs/npc_text.md index 508f949..87b6ad7 100644 --- a/docs/npc_text.md +++ b/docs/npc_text.md @@ -1,86 +1,1052 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [npc_text](npc_text) - -Column | Type | Description ---- | --- | --- -ID | mediumint(8) unsigned | -Text0_0 | longtext | -Text0_1 | longtext | -Lang0 | tinyint(3) unsigned | -Probability0 | float | -Em0_0 | smallint(5) unsigned | -Em0_1 | smallint(5) unsigned | -Em0_2 | smallint(5) unsigned | -Em0_3 | smallint(5) unsigned | -Em0_4 | smallint(5) unsigned | -Em0_5 | smallint(5) unsigned | -Text1_0 | longtext | -Text1_1 | longtext | -Lang1 | tinyint(3) unsigned | -Probability1 | float | -Em1_0 | smallint(5) unsigned | -Em1_1 | smallint(5) unsigned | -Em1_2 | smallint(5) unsigned | -Em1_3 | smallint(5) unsigned | -Em1_4 | smallint(5) unsigned | -Em1_5 | smallint(5) unsigned | -Text2_0 | longtext | -Text2_1 | longtext | -Lang2 | tinyint(3) unsigned | -Probability2 | float | -Em2_0 | smallint(5) unsigned | -Em2_1 | smallint(5) unsigned | -Em2_2 | smallint(5) unsigned | -Em2_3 | smallint(5) unsigned | -Em2_4 | smallint(5) unsigned | -Em2_5 | smallint(5) unsigned | -Text3_0 | longtext | -Text3_1 | longtext | -Lang3 | tinyint(3) unsigned | -Probability3 | float | -Em3_0 | smallint(5) unsigned | -Em3_1 | smallint(5) unsigned | -Em3_2 | smallint(5) unsigned | -Em3_3 | smallint(5) unsigned | -Em3_4 | smallint(5) unsigned | -Em3_5 | smallint(5) unsigned | -Text4_0 | longtext | -Text4_1 | longtext | -Lang4 | tinyint(3) unsigned | -Probability4 | float | -Em4_0 | smallint(5) unsigned | -Em4_1 | smallint(5) unsigned | -Em4_2 | smallint(5) unsigned | -Em4_3 | smallint(5) unsigned | -Em4_4 | smallint(5) unsigned | -Em4_5 | smallint(5) unsigned | -Text5_0 | longtext | -Text5_1 | longtext | -Lang5 | tinyint(3) unsigned | -Probability5 | float | -Em5_0 | smallint(5) unsigned | -Em5_1 | smallint(5) unsigned | -Em5_2 | smallint(5) unsigned | -Em5_3 | smallint(5) unsigned | -Em5_4 | smallint(5) unsigned | -Em5_5 | smallint(5) unsigned | -Text6_0 | longtext | -Text6_1 | longtext | -Lang6 | tinyint(3) unsigned | -Probability6 | float | -Em6_0 | smallint(5) unsigned | -Em6_1 | smallint(5) unsigned | -Em6_2 | smallint(5) unsigned | -Em6_3 | smallint(5) unsigned | -Em6_4 | smallint(5) unsigned | -Em6_5 | smallint(5) unsigned | -Text7_0 | longtext | -Text7_1 | longtext | -Lang7 | tinyint(3) unsigned | -Probability7 | float | -Em7_0 | smallint(5) unsigned | -Em7_1 | smallint(5) unsigned | -Em7_2 | smallint(5) unsigned | -Em7_3 | smallint(5) unsigned | -Em7_4 | smallint(5) unsigned | -Em7_5 | smallint(5) unsigned | -VerifiedBuild | smallint(6) | +# 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

ID

mediumint(8)

unsigned

PRI

NO

0

text0_0

longtext

signed

 

YES

NULL

text0_1

longtext

signed

 

YES

NULL

lang0

tinyint(3)

unsigned

 

NO

0

Probability0

float

signed

 

NO

0

em0_0

smallint(5)

unsigned

 

NO

0

em0_1

smallint(5)

unsigned

 

NO

0

em0_2

smallint(5)

unsigned

 

NO

0

em0_3

smallint(5)

unsigned

 

NO

0

em0_4

smallint(5)

unsigned

 

NO

0

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

Probability1

float

signed

 

NO

0

em1_0

smallint(5)

unsigned

 

NO

0

em1_1

smallint(5)

unsigned

 

NO

0

em1_2

smallint(5)

unsigned

 

NO

0

em1_3

smallint(5)

unsigned

 

NO

0

em1_4

smallint(5)

unsigned

 

NO

0

em1_5

smallint(5)

unsigned

 

NO

0

text2_0

longtext

signed

 

YES

NULL

text2_1

longtext

signed

 

YES

NULL

lang2

tinyint(3)

unsigned

 

NO

0

Probability2

float

signed

 

NO

0

em2_0

smallint(5)

unsigned

 

NO

0

em2_1

smallint(5)

unsigned

 

NO

0

em2_2

smallint(5)

unsigned

 

NO

0

em2_3

smallint(5)

unsigned

 

NO

0

em2_4

smallint(5)

unsigned

 

NO

0

em2_5

smallint(5)

unsigned

 

NO

0

text3_0

longtext

signed

 

YES

NULL

text3_1

longtext

signed

 

YES

NULL

lang3

tinyint(3)

unsigned

 

NO

0

Probability3

float

signed

 

NO

0

em3_0

smallint(5)

unsigned

 

NO

0

em3_1

smallint(5)

unsigned

 

NO

0

em3_2

smallint(5)

unsigned

 

NO

0

em3_3

smallint(5)

unsigned

 

NO

0

em3_4

smallint(5)

unsigned

 

NO

0

em3_5

smallint(5)

unsigned

 

NO

0

text4_0

longtext

signed

 

YES

NULL

text4_1

longtext

signed

 

YES

NULL

lang4

tinyint(3)

unsigned

 

NO

0

Probability4

float

signed

 

NO

0

em4_0

smallint(5)

unsigned

 

NO

0

em4_1

smallint(5)

unsigned

 

NO

0

em4_2

smallint(5)

unsigned

 

NO

0

em4_3

smallint(5)

unsigned

 

NO

0

em4_4

smallint(5)

unsigned

 

NO

0

em4_5

smallint(5)

unsigned

 

NO

0

text5_0

longtext

signed

 

YES

NULL

text5_1

longtext

signed

 

YES

NULL

lang5

tinyint(3)

unsigned

 

NO

0

Probability5

float

signed

 

NO

0

em5_0

smallint(5)

unsigned

 

NO

0

em5_1

smallint(5)

unsigned

 

NO

0

em5_2

smallint(5)

unsigned

 

NO

0

em5_3

smallint(5)

unsigned

 

NO

0

em5_4

smallint(5)

unsigned

 

NO

0

em5_5

smallint(5)

unsigned

 

NO

0

text6_0

longtext

signed

 

YES

NULL

text6_1

longtext

signed

 

YES

NULL

lang5tinyint(3)unsigned NO0

Probability6

float

signed

 

NO

0

em6_0

smallint(5)

unsigned

 

NO

0

em6_1

smallint(5)

unsigned

 

NO

0

em6_2

smallint(5)

unsigned

 

NO

0

em6_3

smallint(5)

unsigned

 

NO

0

em6_4

smallint(5)

unsigned

 

NO

0

em6_5

smallint(5)

unsigned

 

NO

0

text7_0

longtext

signed

 

YES

NULL

text7_1

longtext

signed

 

YES

NULL

lang7

tinyint(3)

unsigned

 

NO

0

Probability7

float

signed

 

NO

0

em7_0

smallint(5)

unsigned

 

NO

0

em7_1

smallint(5)

unsigned

 

NO

0

em7_2

smallint(5)

unsigned

 

NO

0

em7_3

smallint(5)

unsigned

 

NO

0

em7_4

smallint(5)

unsigned

 

NO

0

em7_5

smallint(5)

unsigned

 

NO

0

VerifiedBuild

smallint(5)

signed

 

YES

1

+ +**Field Descriptions** + +### ID + +This is the ID of the text entry. + +### text0\_0 + +This is the locale text that is displayed if the NPC is a male. + +### text0\_1 + +This is the locale text that is displayed if the NPC is a female. + +### BroadcastTextID0 + +The \`broadcast\_text\`.\`ID\` field value for the \`MaleText\` in the \`broadcast\_text\` table. + +### lang0 + +The language of the text in game. Refer to [this page](http://collab.kpsn.org/display/tc/Languages) 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](http://collab.kpsn.org/display/tc/Languages) 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](http://collab.kpsn.org/display/tc/Languages) 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](http://collab.kpsn.org/display/tc/Languages) for the available language IDs. + +### Probability3 + +The percent-chance (probability) that the NPC will say either text3\_0 or text3\_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](http://collab.kpsn.org/display/tc/Languages) 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](http://collab.kpsn.org/display/tc/Languages) 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](http://collab.kpsn.org/display/tc/Languages) 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](http://collab.kpsn.org/display/tc/Languages) 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 + +The ID of the emote that the NPC should do upon greeting the player. + +### 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. + +### 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. -- cgit