{"action":"created","issue":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15743","labels_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15743/labels{/name}","comments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15743/comments","events_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15743/events","html_url":"https://github.com/TrinityCore/TrinityCore/issues/15743","id":112300981,"number":15743,"title":"[335] Young Thistle Boar - Wrong Skinning Loot","user":{"login":"MrSmite","id":1168404,"avatar_url":"https://avatars.githubusercontent.com/u/1168404?v=3","gravatar_id":"","url":"https://api.github.com/users/MrSmite","html_url":"https://github.com/MrSmite","followers_url":"https://api.github.com/users/MrSmite/followers","following_url":"https://api.github.com/users/MrSmite/following{/other_user}","gists_url":"https://api.github.com/users/MrSmite/gists{/gist_id}","starred_url":"https://api.github.com/users/MrSmite/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MrSmite/subscriptions","organizations_url":"https://api.github.com/users/MrSmite/orgs","repos_url":"https://api.github.com/users/MrSmite/repos","events_url":"https://api.github.com/users/MrSmite/events{/privacy}","received_events_url":"https://api.github.com/users/MrSmite/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Branch-3.3.5a","name":"Branch-3.3.5a","color":"188846"},{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Branch-6.x","name":"Branch-6.x","color":"188846"},{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Comp-Database","name":"Comp-Database","color":"FF6600"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-10-20T07:02:43Z","updated_at":"2015-10-20T08:56:38Z","closed_at":null,"body":"__Core:__ 747ea7c\r\n__DB:__ TDB_full_335.59_2015_07_14 + updates\r\n\r\n__Bug:__\r\n\r\n[Young Thistle Boar](http://www.wowhead.com/npc=1984/young-thistle-boar#skinning) should only drop Ruined Leather Scraps when skinned. Currently its template drops 5 items.\r\n\r\n```SQL\r\nSELECT * FROM `skinning_loot_template` WHERE `Entry`=(SELECT `skinloot` FROM `creature_template` WHERE `entry`=1984);\r\n\r\n\"Entry\"\t\"Item\"\t\"Reference\"\t\"Chance\"\t\"QuestRequired\"\t\"LootMode\"\t\"GroupId\"\t\"MinCount\"\t\"MaxCount\"\t\"Comment\"\r\n\"100008\"\t\"783\"\t\"0\"\t\"3\"\t\"0\"\t\"1\"\t\"1\"\t\"1\"\t\"1\"\r\n\"100008\"\t\"2318\"\t\"0\"\t\"37\"\t\"0\"\t\"1\"\t\"1\"\t\"1\"\t\"2\"\r\n\"100008\"\t\"2319\"\t\"0\"\t\"45\"\t\"0\"\t\"1\"\t\"1\"\t\"1\"\t\"1\"\r\n\"100008\"\t\"4232\"\t\"0\"\t\"5\"\t\"0\"\t\"1\"\t\"1\"\t\"1\"\t\"1\"\r\n\"100008\"\t\"7287\"\t\"0\"\t\"10\"\t\"0\"\t\"1\"\t\"1\"\t\"1\"\t\"1\"\r\n```\r\n\r\nNote: Sorry, I don't know how to get Github to format data into a proper chart.\r\nNote: I am aware of https://github.com/TrinityCore/TrinityCore/issues/10744 but since that's been a \"WIP\" for almost three years now, perhaps it's best to handle the bug reports as they come in considering these loot tables are mostly an exploit allowing players to powerlevel leatherworking."},"comment":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/comments/149482922","html_url":"https://github.com/TrinityCore/TrinityCore/issues/15743#issuecomment-149482922","issue_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15743","id":149482922,"user":{"login":"Rushor","id":5568820,"avatar_url":"https://avatars.githubusercontent.com/u/5568820?v=3","gravatar_id":"","url":"https://api.github.com/users/Rushor","html_url":"https://github.com/Rushor","followers_url":"https://api.github.com/users/Rushor/followers","following_url":"https://api.github.com/users/Rushor/following{/other_user}","gists_url":"https://api.github.com/users/Rushor/gists{/gist_id}","starred_url":"https://api.github.com/users/Rushor/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Rushor/subscriptions","organizations_url":"https://api.github.com/users/Rushor/orgs","repos_url":"https://api.github.com/users/Rushor/repos","events_url":"https://api.github.com/users/Rushor/events{/privacy}","received_events_url":"https://api.github.com/users/Rushor/received_events","type":"User","site_admin":false},"created_at":"2015-10-20T08:56:38Z","updated_at":"2015-10-20T08:56:38Z","body":"this should be all\r\n\r\n```sql\r\nUPDATE `creature_template` SET `skinloot`=1984 WHERE  `entry`=1984;\r\nDELETE FROM `skinning_loot_template` WHERE `Entry`=1984;\r\nINSERT INTO `skinning_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES \r\n(1984, 2934, 0, 80, 0, 1, 1, 1, 1, NULL);\r\n```"}}