{"action":"opened","issue":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14861","labels_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14861/labels{/name}","comments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14861/comments","events_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14861/events","html_url":"https://github.com/TrinityCore/TrinityCore/issues/14861","id":86731110,"number":14861,"title":"[3.3.5] DB/Gossip: Senani Thunderheart gossip option 2+3 crosslinked","user":{"login":"tkrokli","id":4903600,"avatar_url":"https://avatars.githubusercontent.com/u/4903600?v=3","gravatar_id":"","url":"https://api.github.com/users/tkrokli","html_url":"https://github.com/tkrokli","followers_url":"https://api.github.com/users/tkrokli/followers","following_url":"https://api.github.com/users/tkrokli/following{/other_user}","gists_url":"https://api.github.com/users/tkrokli/gists{/gist_id}","starred_url":"https://api.github.com/users/tkrokli/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tkrokli/subscriptions","organizations_url":"https://api.github.com/users/tkrokli/orgs","repos_url":"https://api.github.com/users/tkrokli/repos","events_url":"https://api.github.com/users/tkrokli/events{/privacy}","received_events_url":"https://api.github.com/users/tkrokli/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-06-09T20:48:48Z","updated_at":"2015-06-09T20:48:48Z","closed_at":null,"body":"TrinityCore rev. cac4f9597698 2015-06-06 16:08:25 +0200 (3.3.5 branch) (Win64, Release)\r\nTDB 335.58 + updates up to and including `2015_06_08_00_world.sql`\r\n\r\n**Cosmetic issue:**\r\nIn the gossip menu from [[Senani Thunderheart]](http://wotlk.openwow.com/npc=12696) as soon as your character has \"handed in\" the prequest [[The Ashenvale Hunt]](http://wotlk.openwow.com/quest=6383), the **second** and **third** options have got cross-linked answers (gossip texts) :\r\n\r\n![senani_thunderheart_main_gossip](https://cloud.githubusercontent.com/assets/4903600/8066260/f774d6ea-0ee6-11e5-832c-78ffaf80349e.png)\r\n\r\nWhen selecting **question/option 2**, \"What can you tell me about the nightsaber cat - Shadumbra?\",\r\nyou get the answer to **question/option 3**, like in **this** image :\r\n\r\n![senani_thunderheart_sharptalon_gossip_option](https://cloud.githubusercontent.com/assets/4903600/8066272/074fc0de-0ee7-11e5-8204-fb4982cf1d48.png)\r\n\r\nAnd when selecting **question/option 3**, \"What can you tell me about the hippogryph - Sharptalon?\",\r\nyou get the answer to **question/option 2**, like in **this** image :\r\n\r\n![senani_thunderheart_shadumbra_gossip_option](https://cloud.githubusercontent.com/assets/4903600/8066281/11bd0086-0ee7-11e5-9b8c-04db8a016f1d.png)\r\n\r\nTo see the old (and wrong) settings in the existing table, use this query:\r\n```sql\r\nSELECT * FROM `gossip_menu_option` WHERE `menu_id`= 4346;\r\n```\r\nOutput / result (check the column `action_menu_id` to see that it is not in the correct order) :\r\n```\r\nmenu_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  \r\n-------  ------  -----------  -------------------------------------------------------------  ---------------------  ---------  ------------------  --------------  -------------  ---------  ---------  --------  --------------------\r\n   4346       0            0  What can you tell to me about the bear - Ursangous?                             8229          1                   1            4381              0          0          0  (NULL)                       0\r\n   4346       1            0  What can you tell to me about the nightsaber cat - Shadumbra?                   8230          1                   1            4383              0          0          0  (NULL)                       0\r\n   4346       2            0  What can you tell to me about the hippogryph - Sharptalon?                      8231          1                   1            4382              0          0          0  (NULL)                       0\r\n```\r\n**Solution:** update the link in the table `gossip_menu_option` by arranging the values in the column `action_menu_id` in the correct order:\r\n```sql\r\nUPDATE `gossip_menu_option` SET `action_menu_id`=4382 WHERE `menu_id`=4346 AND `id`=1;\r\nUPDATE `gossip_menu_option` SET `action_menu_id`=4383 WHERE `menu_id`=4346 AND `id`=2;\r\n```\r\nIt is also possible to use another column value in that table for the update query, like\r\n```sql\r\n[ ... ] WHERE `menu_id`=4346 AND `OptionBroadcastTextID`=8230;\r\n[ ... ] WHERE `menu_id`=4346 AND `OptionBroadcastTextID`=8231;\r\n```\r\nI just thought it would be shorter, simpler and just as valid to use the first available unique value.\r\n\r\nThis solution is tested on my current local server and it works as intended. :+1:"}}