“npc_gossip” table

The npc_gossip table holds the link between creatures and gossip text.

Table structure

Field Type Null Key Default Extra
npc_guid int(10) unsigned NO PRI 0  
textid mediumint(8) unsigned NO   0  

Fields

npc_guid

This references the “creature” table tables guid field for which the entry is valid.

textid

This references the “npc_text” table tables unique ID of the NPC text for which the entry is valid.

Note

To actually make a creature display a gossip dialogue with the linked text, you will have to update the “creature_template” table as follows:

SET @CREATURE_FLAG_NPC_GOSSIP                   = 1;

UPDATE `creature_template`
SET
    `NpcFlags`              = `NpcFlags` | @CREATURE_FLAG_NPC_GOSSIP,
WHERE
    `entry`                 = YOUR-CREATURE;

This will add the gossip flag to any existing flags and thus enable the link text to be displayed.