Cheapgamer: Created page with "{| align="right" | TOC |} Category: SkyFire World database tables {{Back-to:World}} '''The `npc_text` table''' This table contains the texts that are use..."

2012-07-06T19:30:49Z

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..."

New page

{| align="right"
| __TOC__
|}
[[Category: SkyFire World database tables]]
{{Back-to:World}}

<big>'''The `npc_text` table'''</big>

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

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attributes'''
|'''Key'''
|'''Null'''
|'''Default'''
|'''Extra'''
|'''Comment'''
|-
|[[#ID|ID]]
|mediumint(8)
|unsigned
|PRI
|NO
|0
|
|
|-
|[[#text0_0-7_0|text0_0]]
|longtext
|signed
|
|YES
|NULL
|
|
|-
|[[#text0_1-7_1|text0_1]]
|longtext
|signed
|
|YES
|NULL
|
|
|-
|[[#lang0-7|lang0]]
|tinyint(3)
|unsigned
|
|NO
|0
|
|
|-
|[[#prob0-7|prob0]]
|float
|signed
|
|NO
|0
|
|
|-
|[[#em0_0-7_0|em0_0]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_1-7_1|em0_1]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_2-7_2|em0_2]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_3-7_3|em0_3]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_4-7_4|em0_4]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_5-7_5|em0_5]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#text0_0-7_0|text1_0]]
|longtext
|signed
|
|YES
|NULL
|
|
|-
|[[#text0_1-7_1|text1_1]]
|longtext
|signed
|
|YES
|NULL
|
|
|-
|[[#lang0-7|lang1]]
|tinyint(3)
|unsigned
|
|NO
|0
|
|
|-
|[[#prob0-7|prob1]]
|float
|signed
|
|NO
|0
|
|
|-
|[[#em0_0-7_0|em1_0]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_1-7_1|em1_1]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_2-7_2|em1_2]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_3-7_3|em1_3]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_4-7_4|em1_4]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_5-7_5|em1_5]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#text0_0-7_0|text2_0]]
|longtext
|signed
|
|YES
|NULL
|
|
|-
|[[#text0_1-7_1|text2_1]]
|longtext
|signed
|
|YES
|NULL
|
|
|-
|[[#lang0-7|lang2]]
|tinyint(3)
|unsigned
|
|NO
|0
|
|
|-
|[[#prob0-7|prob2]]
|float
|signed
|
|NO
|0
|
|
|-
|[[#em0_0-7_0|em2_0]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_1-7_1|em2_1]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_2-7_2|em2_2]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_3-7_3|em2_3]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_4-7_4|em2_4]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_5-7_5|em2_5]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#text0_0-7_0|text3_0]]
|longtext
|signed
|
|YES
|NULL
|
|
|-
|[[#text0_1-7_1|text3_1]]
|longtext
|signed
|
|YES
|NULL
|
|
|-
|[[#lang0-7|lang3]]
|tinyint(3)
|unsigned
|
|NO
|0
|
|
|-
|[[#prob0-7|prob3]]
|float
|signed
|
|NO
|0
|
|
|-
|[[#em0_0-7_0|em3_0]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_1-7_1|em3_1]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_2-7_2|em3_2]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_3-7_3|em3_3]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_4-7_4|em3_4]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_5-7_5|em3_5]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#text0_0-7_0|text4_0]]
|longtext
|signed
|
|YES
|NULL
|
|
|-
|[[#text0_1-7_1|text4_1]]
|longtext
|signed
|
|YES
|NULL
|
|
|-
|[[#lang0-7|lang4]]
|tinyint(3)
|unsigned
|
|NO
|0
|
|
|-
|[[#prob0-7|prob4]]
|float
|signed
|
|NO
|0
|
|
|-
|[[#em0_0-7_0|em4_0]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_1-7_1|em4_1]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_2-7_2|em4_2]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_3-7_3|em4_3]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_4-7_4|em4_4]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_5-7_5|em4_5]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#text0_0-7_0|text5_0]]
|longtext
|signed
|
|YES
|NULL
|
|
|-
|[[#text0_1-7_1|text5_1]]
|longtext
|signed
|
|YES
|NULL
|
|
|-
|[[#lang0-7|lang5]]
|tinyint(3)
|unsigned
|
|NO
|0
|
|
|-
|[[#prob0-7|prob5]]
|float
|signed
|
|NO
|0
|
|
|-
|[[#em0_0-7_0|em5_0]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_1-7_1|em5_1]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_2-7_2|em5_2]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_3-7_3|em5_3]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_4-7_4|em5_4]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_5-7_5|em5_5]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#text0_0-7_0|text6_0]]
|longtext
|signed
|
|YES
|NULL
|
|
|-
|[[#text0_1-7_1|text6_1]]
|longtext
|signed
|
|YES
|NULL
|
|
|-
|[[#lang0-7|lang6]]
|tinyint(3)
|unsigned
|
|NO
|0
|
|
|-
|[[#prob0-7|prob6]]
|float
|signed
|
|NO
|0
|
|
|-
|[[#em0_0-7_0|em6_0]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_1-7_1|em6_1]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_2-7_2|em6_2]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_3-7_3|em6_3]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_4-7_4|em6_4]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_5-7_5|em6_5]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#text0_0-7_0|text7_0]]
|longtext
|signed
|
|YES
|NULL
|
|
|-
|[[#text0_1-7_1|text7_1]]
|longtext
|signed
|
|YES
|NULL
|
|
|-
|[[#lang0-7|lang7]]
|tinyint(3)
|unsigned
|
|NO
|0
|
|
|-
|[[#prob0-7|prob7]]
|float
|signed
|
|NO
|0
|
|
|-
|[[#em0_0-7_0|em7_0]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_1-7_1|em7_1]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_2-7_2|em7_2]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_3-7_3|em7_3]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_4-7_4|em7_4]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#em0_5-7_5|em7_5]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#WDBVerified|WDBVerified]]
|smallint(5)
|signed
|
|YES
|1
|
|
|}

<big>'''Description of the fields'''</big>
====ID====
This is the ID of the text entry. {{WDB-fields}}

====text0_0-7_0====
Is this the first choice of locale 0? {{WDB-fields}}

====text0_1-7_1====
Second choice? {{WDB-fields}}

====lang0-7====
The language of the text in game (post list of possible values). {{WDB-fields}}

====prob0-7====
This is the probability that the NPC will say this text. {{WDB-fields}}

====em0_0====
Emote on greet? {{WDB-fields}}
====em0_1-7_1====
Emote on ? {{WDB-fields}}
====em0_2-7_2====
Emote on ? {{WDB-fields}}
====em0_3-7_3====
Emote on ? {{WDB-fields}}
====em0_4-7_4====
Emote on ? {{WDB-fields}}
====em0_5-7_5====
Emote on ? {{WDB-fields}}

====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 [[realmlist_SF#gamebuild|client build]].

If value is -1 then it is just a place holder until proper data are found on WDBs.

Npc text SF - Revision history

Cheapgamer: Created page with "{| align="right" | __TOC__ |} Category: SkyFire World database tables {{Back-to:World}} '''The `npc_text` table''' This table contains the texts that are use..."

Cheapgamer: Created page with "{| align="right" | TOC |} Category: SkyFire World database tables {{Back-to:World}} '''The `npc_text` table''' This table contains the texts that are use..."