Cheapgamer: Created page with "{| align="right" | TOC |} Category: SkyFire World database tables {{Back-to:World}} '''The `creature_text` table''' This table holds all the texts used w..."

2012-07-06T19:20:09Z

Created page with "{| align="right" | __TOC__ |} Category: SkyFire World database tables {{Back-to:World}} <big>'''The `creature_text` table'''</big> This table holds all the texts used w..."

New page

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

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

This table holds all the texts used within scripts. This table handles the actual text, display type (say/yell/emote) and corresponding sounds or emote (if any).

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attributes'''
|'''Key'''
|'''Null'''
|'''Default'''
|'''Extra'''
|'''Comment'''
|-
|[[#entry|entry]]
|mediumint(8)
|unsigned
|PRI
|NO
|0
|
|creature_template entry
|-
|[[#groupid|groupid]]
|tinyint(3)
|unsigned
|PRI
|NO
|0
|
|
|-
|[[#id|id]]
|tinyint(3)
|unsigned
|PRI
|NO
|0
|
|
|-
|[[#text|text]]
|longtext
|signed
|
|YES
|NULL
|
|
|-
|[[#type|type]]
|text
|signed
|
|YES
|NULL
|
|
|-
|[[#language|language]]
|tinyint(3)
|unsigned
|
|NO
|0
|
|
|-
|[[#probability|probability]]
|float
|signed
|
|NO
|0
|
|
|-
|[[#emote|emote]]
|mediumint(8)
|unsigned
|
|NO
|0
|
|
|-
|[[#duration|duration]]
|mediumint(8)
|unsigned
|
|NO
|0
|
|
|-
|[[#sound|sound]]
|mediumint(8)
|unsigned
|
|NO
|0
|
|
|-
|[[#comment|comment]]
|varchar(255)
|signed
|
|YES
|NULL
|
|
|}

<big>'''Description of the fields'''</big>

===entry===
This is the [[creature_template_SF#entry|creature_template.entry]] to which the script is linked to.

===groupid===
If there is more than one of the same entry (more than one text the creature says), this is the unique identifier that must be incremented for each new matching entry (ex. 0, 1, 2, 3...). If there is only one entry, this value should be 0.

===id===
Entry for grouped texts - a say will be randomly selected from one of these based on the group it belongs to.

===text===
The text the creature will say.

===type===
{| border=1 cellpadding=3 cellspacing=0
! Value !! Old value !! Localization
|-
| 12 || 0 || Say
|-
| 14 || 1 || Yell
|-
| 16 || 2 || Emote
|-
| 41 || 3 || Boss Emote
|-
| 15 || 4 || Whisper
|-
| 42 || 5 || Boss Whisper
|}

===language===
The value found in [[Languages.dbc_SF|Languages.dbc]] but if it's 0 than all understand.

===probability===
A value from 1-100 that represents the percentage chance that this text will be executed.

===emote===
The emote that the creature plays when the text is executed. Value is from [[Creature_addon_SF#emote|creature_addon.emote]]

===duration===
Time in ms to see text.
0 is default and calculated by core.

===sound===
The sound entry this creature will play at the same time the text is executed. Sounds are found in SoundEntries.dbc.

===comment===
This field allows you to label a text entry.

Creature text SF - Revision history

Cheapgamer: Created page with "{| align="right" | __TOC__ |} Category: SkyFire World database tables {{Back-to:World}} '''The `creature_text` table''' This table holds all the texts used w..."

Cheapgamer: Created page with "{| align="right" | TOC |} Category: SkyFire World database tables {{Back-to:World}} '''The `creature_text` table''' This table holds all the texts used w..."