Npc text SF: Difference between revisions
Cheapgamer (talk | contribs) (Created page with "{| align="right" | __TOC__ |} Category: SkyFire World database tables {{Back-to:World}} <big>'''The `npc_text` table'''</big> This table contains the texts that are use...") |
(No difference)
|
Latest revision as of 14:30, 6 July 2012
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.