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) :

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 :

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 :

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.
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.sqlCosmetic 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) :
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 :
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 :
To see the old (and wrong) settings in the existing table, use this query:
Output / result (check the column
action_menu_idto see that it is not in the correct order) :Solution: update the link in the table
gossip_menu_optionby arranging the values in the columnaction_menu_idin the correct order:It is also possible to use another column value in that table for the update query, like
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.