Skip to content
Schmoozerd edited this page Apr 14, 2013 · 1 revision

Back to world database list of tables.

The `gossip_menu` table

This table is used for displaying gossip when a player talks to an NPC.

Structure

Field Type Attributes Key Null Default
entry smallint(6) unsigned PRI NO 0
text_id mediumint(8) unsigned PRI NO 0
cond_1 tinyint(3) unsigned NO 0
cond_1_val_1 mediumint(8) unsigned NO 0
cond_1_val_2 mediumint(8) unsigned NO 0
cond_2 tinyint(3) unsigned NO 0
cond_2_val_1 mediumint(8) unsigned NO 0
cond_2_val_2 mediumint(8) unsigned NO 0
condition_id mediumint(8) unsigned NO 0

Description of the fields

entry

Gossip ID from gossip_menu_id and gameobject_template.GAMEOBJECT_TYPE_QUESTGIVER.data3

text_id

Reference to npc_text.id.

condition

condition_value1-2 fields can provide conditions on when the gossip is aktive.

Value Condition Comments
0 CONDITION_NONE Regular drop
1 CONDITION_AURA Player looting must have an aura active
2 CONDITION_ITEM Player must have a number of items in his/her inventory
3 CONDITION_ITEM_EQUIPPED Player must have an item equipped
4 CONDITION_ZONEID Player must be in a certain zone
5 CONDITION_REPUTATION_RANK Player must have a certain reputation rank with a certain faction
6 CONDITION_TEAM Player must be part of the specified team (Alliance or Horde)
7 CONDITION_SKILL Player must have a certain skill value
8 CONDITION_QUESTREWARDED Player must have completed a quest first
9 CONDITION_QUESTTAKEN Players must have the quest in the quest log and not completed yet
10 CONDITION_AD_COMMISSION_AURA
11 CONDITION_NO_AURA Miss some aura.
12 CONDITION_ACTIVE_EVENT event]] is active.
13 CONDITION_AREA_FLAG
14 CONDITION_RACE_CLASS Has special race or class.
15 CONDITION_LEVEL Has special level.
16 CONDITION_NOITEM Has not enouth items yet.
17 CONDITION_SPELL Knows some spell.
18 CONDITION_INSTANCE_SCRIPT SD2-Based condition
19 CONDITION_QUESTAVAILABLE Some quest is availible.
20 CONDITION_ACHIEVEMENT Has or has no special achievement.
21 CONDITION_ACHIEVEMENT_REALM Realm-wideversion of 20.
22 CONDITION_QUEST_NONE Has not taken a quest yet.
23 CONDITION_ITEM_WITH_BANK Check’s presens of req. amount of items in inventory or bank.
24 CONDITION_NOITEM_WITH_BANK Check’s absentee of req. amount of items in inventory or bank.
25 CONDITION_NOT_ACTIVE_GAME_EVENT
26 CONDITION_ACTIVE_HOLIDAY
27 CONDITION_NOT_ACTIVE_HOLIDAY
28 CONDITION_LEARNABLE_ABILITY Check’s if the palyer has high enought skilllevel and may check if a special item is in the inventory.

NOTE: For reference entries this field has no meaning, not used by the core in any way and should have the default value of 0.

condition_value

The values in the condition_value1 and condition_value2 fields depend on what condition was put in condition.

  • CONDITION_AURA
    • condition_value1: The spell ID from where the aura came from.
    • condition_value2: The effect index of the spell that applied the aura (0, 1, or 2)
  • CONDITION_ITEM
    • condition_value1: Item ID
    • condition_value2: Count
  • CONDITION_ITEM_EQUIPPED
    • condition_value1: Item ID
    • condition_value2: Always 0
  • CONDITION_ZONEID
    • condition_value1: Zone ID
    • condition_value2: Always 0
  • CONDITION_REPUTATION_RANK
    • condition_value1: Faction ID
    • condition_value2: Minimum rank
  • CONDITION_TEAM
    • condition_value1: Player team (469 – Alliance, 67 – Horde)
    • condition_value2: Always 0
  • CONDITION_SKILL
    • condition_value1: Skill ID (SkillLine.dbc)
    • condition_value2: Skill value needed
  • CONDITION_QUESTREWARDED
    • condition_value1: Quest ID
    • condition_value2: Always 0
  • CONDITION_QUESTTAKEN
    • condition_value1: Quest ID
    • condition_value2: 1: quest is taken but not completed, 2: quest is taken and already completed, 0 (or or any other value except 1 or 2): quest is taken and doesn’t depend if quest is completed or not
  • CONDITION_AD_COMMISSION_AURA
    • condition_value1: Always 0
    • condition_value2: Always 0
  • CONDITION_NO_AURA
    • condition_value1: spellid
    • condition_value2: EffectIndex
  • CONDITION_ACTIVE_EVENT
    • condition_value1: event
    • condition_value2: Always 0
  • CONDITION_AREA_FLAG
    • condition_value1: area_flag
    • condition_value2: not_have_flag
  • CONDITION_RACE_CLASS
    • condition_value1: race_mask
    • condition_value2: class_mask
  • CONDITION_LEVEL
    • condition_value1: level
    • condition_value2: 0: equal to, 1: equal or higher than, 2: equal or less than
  • CONDITION_NOITEM
    • condition_value1: itemid
    • condition_value2: count
  • CONDITION_SPELL
    • condition_value1: spellid
    • condition_value2: 0: has spell, 1: has no spell
  • CONDITION_QUESTAVAILABLE
    • condition_value1: questid
    • condition_value2: 0
  • CONDITION_ACHIEVEMENT
    • condition_value1: achievementid
    • condition_value2: 0: has achievement, 1: has no achievement
  • CONDITION_ACHIEVEMENT_REALM
    • condition_value1: achievementid
    • condition_value2: 0: has achievement, 1: has no achievement
  • CONDITION_QUEST_NONE
    • condition_value1: questid
    • condition_value2: Always 0
  • CONDITION_ITEM_WITH_BANK
    • condition_value1: item_id
    • condition_value2: count
  • CONDITION_NOITEM_WITH_BANK
    • condition_value1: item_id
    • condition_value2: count
  • CONDITION_NOT_ACTIVE_GAME_EVENT
    • condition_value1: event_id
    • condition_value2: 0
  • CONDITION_ACTIVE_HOLIDAY
    • condition_value1: holiday_id
    • condition_value2: 0
  • CONDITION_NOT_ACTIVE_HOLIDAY
    • condition_value1: holiday_id
    • condition_value2: 0
  • CONDITION_LEARNABLE_ABILITY
    • condition_value1: spell_id
    • condition_value2: 0 or item_id

condition_id

condition_id

Clone this wiki locally