broadcast_text
This table (ref https://github.com/TrinityCore/TrinityCore/commit/60e87db) will have everything you need for your scripts' texts, such as: gossips, creature texts and npc_texts.
Its purpose is (will be) used as a globalized table containing the texts as mentionned above, and things like their sounds, their emotes and the languages in which the texts should be said.
All the values are from sniffs (ADBVerified) so, don't add things in it - Kinzcool.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| ID | int | unsigned | PRI | NO | 0 | ||
| LanguageID | int | unsigned | NO | 0 | |||
| Text | longtext | YES | NULL | ||||
| Text1 | longtext | YES | NULL | ||||
| EmoteID1 | int | unsigned | NO | 0 | |||
| EmoteID2 | int | unsigned | NO | 0 | |||
| EmoteID3 | int | unsigned | NO | 0 | |||
| EmoteDelay1 | int | unsigned | NO | 0 | |||
| EmoteDelay2 | int | unsigned | NO | 0 | |||
| EmoteDelay3 | int | unsigned | NO | 0 | |||
| SoundEntriesID | int | unsigned | NO | 0 | |||
| EmotesID | int | unsigned | NO | 0 | |||
| Flags | int | unsigned | NO | 0 | |||
| VerifiedBuild | int | signed | NO | 0 | |||
Description of fields
ID
Self description.
LanguageID
The Language ID in which the text will be broadcasted.
| ID | Language | ID | Language | |
|---|---|---|---|---|
| 1 | Orcish | 12 | Kalimag | |
| 2 | Darnassian | 13 | Gnomish | |
| 3 | Taurahe | 14 | Troll | |
| 6 | Dwarvish | 33 | Gutterspeak | |
| 7 | Common | 35 | Draenei | |
| 8 | Demonic | 36 | Zombie | |
| 9 | Titan | 37 | Gnomish Binary | |
| 10 | Thalassian | 38 | Goblin Binary | |
| 11 | Draconic | |||
Text
The text that the creature will broadcast.
Text1
The alternative text that the creature will broadcast.
EmoteID[1-3]
The Emote ID played when the texts are broadcasted.
EmoteDelay[1-3]
The delays of the broadcasted emotes.
SoundEntriesID
The SoundEntry ID played when the texts are broadcasted.
EmotesID
- no description -
Flags
- no description -
VerifiedBuild
This field is used by the TrinityDB 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.
If value is -Client Build then it was parsed with WDB files from that specific client build and manually edited later for some special necessity.