Npc text SF
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.