AzerothCore
creature_text_locale
The `creature_text_locale` table
This table is used to provide to localized clients with localized string for creatures texts.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| CreatureID | MEDIUMINT | UNSIGNED | PRI | NO | 0 | ||
| GroupID | TINYINT | UNSIGNED | PRI | NO | 0 | ||
| ID | TINYINT | UNSIGNED | PRI | NO | 0 | ||
| Locale | VARCHAR(4) | PRI | NO | ||||
| Text | TEXT | YES | NULL |
Description of the fields
CreatureID
This is the 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 column is used to choose if it is a random say or an ordered list.聽If a creature has got more than one say text to be shown in a given order,聽it must be incremented for each new matching entry (ex. 0, 1, 2, 3...). If there is only one entry or only one group, this value should be 0. If there are multiple groups of texts, this value stays the same within the group while the id increments within the same group.
ID
Entry for each group of texts.聽This is the unique identifier when entry (creature) is the same and groupid is unchanged, it must be incremented (ex. 0, 1, 2, 3...).聽A creature say will be randomly selected from this list based on the groupid it belongs to.
Locale
It is the language in which you want to make the translation. You can choose from the following:
| ID | Language |
|---|---|
| 1 | koKR |
| 2 | frFR |
| 3 | deDE |
| 4 | zhCN |
| 5 | zhTW |
| 6 | esES |
| 7 | esMX |
| 8 | ruRU |
Text
The translated text the creature will say.