Skip to content

broadcast_text Table

Central repository for in-game NPC text strings. Supports gender-specific variants, sound, chat type, language, and emotes.

Schema Summary

Field Type Key Null Default Extra
entry mediumint(8) unsigned PRI NO 0
male_text longtext YES
female_text longtext YES
chat_type tinyint(3) unsigned NO 0
sound_id smallint(5) unsigned NO 0
language_id tinyint(3) unsigned NO 0
emote_id1 smallint(5) unsigned NO 0
emote_id2 smallint(5) unsigned NO 0
emote_id3 smallint(5) unsigned NO 0
emote_delay1 mediumint(8) unsigned NO 0
emote_delay2 mediumint(8) unsigned NO 0
emote_delay3 mediumint(8) unsigned NO 0

Field Breakdown

  • entry - Primary Key. Unique text ID. IDs ≥ 100000 are custom.
  • male_text - Text spoken with a male voice.
  • female_text - Text spoken with a female voice.
  • chat_type - Output channel:
  • 0 - Say
  • 1 - Yell
  • 2 - Text Emote
  • 3 - Boss Emote
  • 4 - Whisper
  • 5 - Boss Whisper
  • 6 - Zone Yell
  • 7 - Zone Emote
  • sound_id - Sound to play from sound_entries.id.
  • language_id - Language the line is spoken in (language skill gating). (see Languages.dbc)
  • emote_id1 - Up to three emotes performed while speaking the line.
  • emote_id2 - Up to three emotes performed while speaking the line.
  • emote_id3 - Up to three emotes performed while speaking the line.
  • emote_delay1 - Delay (ms) before each corresponding emote fires.
  • emote_delay2 - Delay (ms) before each corresponding emote fires.
  • emote_delay3 - Delay (ms) before each corresponding emote fires. Referenced by: npc_text and gossip_menu_option.