“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.