{"action":"created","issue":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14720","labels_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14720/labels{/name}","comments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14720/comments","events_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14720/events","html_url":"https://github.com/TrinityCore/TrinityCore/issues/14720","id":77704814,"number":14720,"title":"DB/NPC: Fixing some Stable Masters","user":{"login":"Killyana","id":6587064,"avatar_url":"https://avatars.githubusercontent.com/u/6587064?v=3","gravatar_id":"","url":"https://api.github.com/users/Killyana","html_url":"https://github.com/Killyana","followers_url":"https://api.github.com/users/Killyana/followers","following_url":"https://api.github.com/users/Killyana/following{/other_user}","gists_url":"https://api.github.com/users/Killyana/gists{/gist_id}","starred_url":"https://api.github.com/users/Killyana/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Killyana/subscriptions","organizations_url":"https://api.github.com/users/Killyana/orgs","repos_url":"https://api.github.com/users/Killyana/repos","events_url":"https://api.github.com/users/Killyana/events{/privacy}","received_events_url":"https://api.github.com/users/Killyana/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Comp-Database","name":"Comp-Database","color":"FF6600"},{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Feedback-PatchFix","name":"Feedback-PatchFix","color":"d7e102"},{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Sub-Gossips/Texts","name":"Sub-Gossips/Texts","color":"e10c02"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-05-18T15:42:51Z","updated_at":"2015-05-18T20:50:10Z","closed_at":null,"body":"Seems like there's a condition to hide all gossip_options from non hunt class if the npc is stable master, this will be a problem to show the option required to recover lost pets.\r\n``` sql\r\nUPDATE `creature_template` SET `npcflag`=4194305 WHERE `entry`=9988;\r\nUPDATE `conditions` SET `ConditionValue1` =4 WHERE `SourceGroup`=9576 AND `SourceTypeOrReferenceId`=15;\r\nUPDATE `creature_template` SET `npcflag`=4194305 WHERE  `npcflag`=4194304 ;\r\nUPDATE `creature_template` SET `npcflag`=4194307 WHERE  `npcflag`=4194306 ;\r\nUPDATE `creature_template` SET `gossip_menu_id`=9821 WHERE `entry` IN (9976,9978,9979,9982,9985,9986,10048,10049,10051,10052,10057,10058,11105,13616,15131,16094,16586,16656,16824,17896,18984,19018,21336,21517,22469,9896,19325,22551,22577,23392,24905,24974,25037,25519,29251,30155,31991,32105,35290);\r\n\r\nDELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (14) AND `SourceGroup`=9821;\r\nINSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`, `NegativeCondition`) VALUES\r\n(14, 9821, 13557, 0, 15, 4, 0, 0, 0, '', 'Show gossip text if player is a hunter', 0),\r\n(14, 9821, 13584, 0, 15, 4, 0, 0, 0, '', 'Show gossip text if player is not a hunter', 1);\r\n\r\n-- UPDATE `gossip_menu_option` SET `option_id`=1, `npc_option_npcflag`=1, `action_menu_id`=9820 WHERE `menu_id`=9821 AND `id`=1;\r\n"},"comment":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/comments/103206705","html_url":"https://github.com/TrinityCore/TrinityCore/issues/14720#issuecomment-103206705","issue_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14720","id":103206705,"user":{"login":"msoky","id":3620508,"avatar_url":"https://avatars.githubusercontent.com/u/3620508?v=3","gravatar_id":"","url":"https://api.github.com/users/msoky","html_url":"https://github.com/msoky","followers_url":"https://api.github.com/users/msoky/followers","following_url":"https://api.github.com/users/msoky/following{/other_user}","gists_url":"https://api.github.com/users/msoky/gists{/gist_id}","starred_url":"https://api.github.com/users/msoky/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/msoky/subscriptions","organizations_url":"https://api.github.com/users/msoky/orgs","repos_url":"https://api.github.com/users/msoky/repos","events_url":"https://api.github.com/users/msoky/events{/privacy}","received_events_url":"https://api.github.com/users/msoky/received_events","type":"User","site_admin":false},"created_at":"2015-05-18T20:50:10Z","updated_at":"2015-05-18T20:50:10Z","body":"does this fix https://github.com/TrinityCore/TrinityCore/issues/11094 ?"}}