Skip to content

[3.3.5] DB/Gossip: Senani Thunderheart gossip options #14861

Description

TrinityCore rev. cac4f95 2015-06-06 16:08:25 +0200 (3.3.5 branch) (Win64, Release)
TDB 335.58 + updates up to and including 2015_06_08_00_world.sql

Cosmetic issue:
In the gossip menu from [Senani Thunderheart] as soon as your character has "handed in" the prequest [The Ashenvale Hunt], the second and third options have got cross-linked answers (gossip texts) :

senani_thunderheart_main_gossip

When selecting question/option 2, "What can you tell me about the nightsaber cat - Shadumbra?",
you get the answer to question/option 3, like in this image :

senani_thunderheart_sharptalon_gossip_option

And when selecting question/option 3, "What can you tell me about the hippogryph - Sharptalon?",
you get the answer to question/option 2, like in this image :

senani_thunderheart_shadumbra_gossip_option

To see the old (and wrong) settings in the existing table, use this query:

SELECT * FROM `gossip_menu_option` WHERE `menu_id`= 4346;

Output / result (check the column action_menu_id to see that it is not in the correct order) :

menu_id      id  option_icon  option_text                                                    OptionBroadcastTextID  option_id  npc_option_npcflag  action_menu_id  action_poi_id  box_coded  box_money  box_text  BoxBroadcastTextID  
-------  ------  -----------  -------------------------------------------------------------  ---------------------  ---------  ------------------  --------------  -------------  ---------  ---------  --------  --------------------
   4346       0            0  What can you tell to me about the bear - Ursangous?                             8229          1                   1            4381              0          0          0  (NULL)                       0
   4346       1            0  What can you tell to me about the nightsaber cat - Shadumbra?                   8230          1                   1            4383              0          0          0  (NULL)                       0
   4346       2            0  What can you tell to me about the hippogryph - Sharptalon?                      8231          1                   1            4382              0          0          0  (NULL)                       0

Solution: update the link in the table gossip_menu_option by arranging the values in the column action_menu_id in the correct order:

UPDATE `gossip_menu_option` SET `action_menu_id`=4382 WHERE `menu_id`=4346 AND `id`=1;
UPDATE `gossip_menu_option` SET `action_menu_id`=4383 WHERE `menu_id`=4346 AND `id`=2;

It is also possible to use another column value in that table for the update query, like

[ ... ] WHERE `menu_id`=4346 AND `OptionBroadcastTextID`=8230;
[ ... ] WHERE `menu_id`=4346 AND `OptionBroadcastTextID`=8231;

I just thought it would be shorter, simpler and just as valid to use the first available unique value.

This solution is tested on my current local server and it works as intended. 👍

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions