Npc_gossip

Back to world database list of tables.

The `npc_gossip` table

This table is the link between NPCs and gossip text. When you click on an NPC that says something more than just "Greetings ", this is the table that links that NPC to the text.

Structure

Field	Type	Null	Key	Default	Extra
npc_guid	int(11) unsigned	NO	PRI	0
textid	int(11) unsigned	NO		0

Description of the fields

npc_guid

You place the GUID from creature.guid in this field for the NPC that you want to have gossip.

textid

This is the ID from npc_text.ID of the text that you want the NPC to say.

Now, to get your NPC to actually say something, you need to update creature_template.npcflag with the gossip flag, which is 1.