Npc text SF

From Project Skyfire
Jump to: navigation, search

Back to world database list of tables.


The `npc_text` table

This table contains the texts that are used for gossip. More research needs to be done on this table.


Structure

Field Type Attributes Key Null Default Extra Comment
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
prob0 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
prob1 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
prob2 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
prob3 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
prob4 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
prob5 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
lang6 tinyint(3) unsigned NO 0
prob6 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
prob7 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
WDBVerified smallint(5) signed YES 1


Description of the fields

ID

This is the ID of the text entry. This field comes from WDB and is not to be changed

text0_0-7_0

Is this the first choice of locale 0? This field comes from WDB and is not to be changed

text0_1-7_1

Second choice? This field comes from WDB and is not to be changed

lang0-7

The language of the text in game (post list of possible values). This field comes from WDB and is not to be changed

prob0-7

This is the probability that the NPC will say this text. This field comes from WDB and is not to be changed

em0_0

Emote on greet? This field comes from WDB and is not to be changed

em0_1-7_1

Emote on ? This field comes from WDB and is not to be changed

em0_2-7_2

Emote on ? This field comes from WDB and is not to be changed

em0_3-7_3

Emote on ? This field comes from WDB and is not to be changed

em0_4-7_4

Emote on ? This field comes from WDB and is not to be changed

em0_5-7_5

Emote on ? This field comes from WDB and is not to be changed

WDBVerified

This field is used by the SkyFireDB 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.