broadcast_text - cmangos/issues GitHub Wiki
Back to world database list of tables.
The broadcast_text table
holds all texts previously held by dbscript_string, creature_ai_texts and more.
There are even unused texts in this table, which indicate missing scripts / missing variety of texts a npc can use.
Structure
| Field | Type | Null | Key | Default | Comment |
|---|---|---|---|---|---|
| Id | int(11) unsigned | NO | Primary Key | 0 | Primary Key |
| Text | NULL | YES | NULL | 0 | Male text |
| Text1 | NULL | YES | NULL | 0 | Female text |
| ChatTypeID | int(11) unsigned | YES | NULL | 0 | Text Type - enum ChatMsg |
| LanguageID | int(11) unsigned | YES | NULL | 0 | Text Language - enum Language |
| ConditionID | int(11) unsigned | YES | NULL | 0 | Unused |
| EmotesID | int(11) unsigned | YES | NULL | 0 | Unused |
| Flags | int(11) unsigned | YES | NULL | 0 | Unused |
| SoundEntriesID1 | int(11) unsigned | YES | NULL | 0 | Sound on broadcast (male?) |
| SoundEntriesID2 | int(11) unsigned | YES | NULL | 0 | Sound on broadcast (female?) - Unused |
| EmoteID1 | int(11) unsigned | YES | NULL | 0 | Emote on gossip |
| EmoteID2 | int(11) unsigned | YES | NULL | 0 | Emote on gossip |
| EmoteID3 | int(11) unsigned | YES | NULL | 0 | Emote on gossip |
| EmoteDelay1 | int(11) unsigned | YES | NULL | 0 | Emote delay on gossip |
| EmoteDelay2 | int(11) unsigned | YES | NULL | 0 | Emote delay on gossip |
| EmoteDelay3 | int(11) unsigned | YES | NULL | 0 | Emote delay on gossip |
| VerifiedBuild | int(11) unsigned | YES | NULL | 0 | Build of bruteforce |
Id
Primary Key
ChatTypeID
This is the text type of the text. "enum ChatMsg"
| Value | Type | Original Value | Example |
|---|---|---|---|
| 0 | Say | 12 (MonsterSay) |  |
| 1 | Yell | 14 (MonsterYell) |  |
| 2 | Text Emote | 16 (MonsterEmote) |  |
| 3 | Boss Emote | 41 (RaidBossEmote) |  |
| 4 | Whisper | 15 (MonsterWhisper) |  |
| 5 | Boss Whisper | 42 (RaidBossWhisper) |  |
| 6 | Zone Yell | 14 (MonsterYell) with zone wide visibility |  |
| 7 | Zone Text Emote | 16 (MonsterEmote) with zone wide visibility |  |
LanguageID
This is the ingame language of the text. "enum Language"
| ID | Name | Description |
|---|---|---|
| 0 | UNIVERSAL | Text in this language is understood by ALL Races. |
| 1 | ORCISH | Text in this language is understood ONLY by Horde Races. |
| 2 | DARNASSIAN | Text in this language is understood ONLY by the Night Elf Race. |
| 3 | TAURAHE | Text in this language is understood ONLY by the Tauren Race. |
| 6 | DWARVISH | Text in this language is understood ONLY by the Dwarf Race. |
| 7 | COMMON | Text in this language is understood ONLY by Alliance Races. |
| 8 | DEMONIC | Text in this language is understood ONLY by the Demon Race (Not Implemented). |
| 9 | TITAN | This language was used by Sargeras to speak with other Titians (Not Implemented). |
| 10 | THALASSIAN | Text in this language is understood ONLY by the Blood Elf Race. |
| 11 | DRACONIC | Text in this language is understood ONLY by the Dragon Race. |
| 12 | KALIMAG | Text will display as Kalimag (not readable by players, language of all elementals) |
| 13 | GNOMISH | Text in this language is understood ONLY by the Gnome Race. |
| 14 | TROLL | Text in this language is understood ONLY by the Troll Race. |
| 33 | GUTTERSPEAK | Text in this language is understood ONLY by the Undead Race. |
| 35 | DRAENEI | Text in this language is understood ONLY by the Draenai Race. |
| 36 | ZOMBIE | (not currently used?) |
| 37 | GNOMISH BINARY | Binary language used by Alliance when drinking Binary Brew |
| 38 | GOBLIN BINARY | Binary language used by Horce when drinking Binary Brew |