{"action":"opened","issue":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/21345","repository_url":"https://api.github.com/repos/TrinityCore/TrinityCore","labels_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/21345/labels{/name}","comments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/21345/comments","events_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/21345/events","html_url":"https://github.com/TrinityCore/TrinityCore/issues/21345","id":293507412,"number":21345,"title":"DB/Loot: Reference template 24078 corrections","user":{"login":"Teppic1","id":32468801,"avatar_url":"https://avatars3.githubusercontent.com/u/32468801?v=4","gravatar_id":"","url":"https://api.github.com/users/Teppic1","html_url":"https://github.com/Teppic1","followers_url":"https://api.github.com/users/Teppic1/followers","following_url":"https://api.github.com/users/Teppic1/following{/other_user}","gists_url":"https://api.github.com/users/Teppic1/gists{/gist_id}","starred_url":"https://api.github.com/users/Teppic1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Teppic1/subscriptions","organizations_url":"https://api.github.com/users/Teppic1/orgs","repos_url":"https://api.github.com/users/Teppic1/repos","events_url":"https://api.github.com/users/Teppic1/events{/privacy}","received_events_url":"https://api.github.com/users/Teppic1/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-02-01T12:11:50Z","updated_at":"2018-02-01T12:11:50Z","closed_at":null,"author_association":"NONE","body":"**Description:**\r\n\r\nReference template 24078 should contain generic green gear at ilvls 18-19.\r\n\r\n**Current behaviour:**\r\n\r\nSeveral items that should only drop from specific NPCs are contained in the template and so drop from hundreds of NPCs.\r\n\r\nThe patch removes all of the unique items and adds them to the correct NPCs. The items in question are documented in the patch. (I'm slowly going through all of the templates in level order.)\r\n\r\n**Branch(es):**\r\n\r\n3.3.5 only\r\n\r\n**TC rev. hash/commit:** \r\n\r\nTrinityCore rev. 2119a5979d7c 2018-01-30 18:13:23 +0100 (3.3.5 branch) (Unix, RelWithDebInfo, Static) \r\n\r\n**TDB version:** 335.63\r\n\r\n```sql\r\n-- Remove unique items from reference table 24078\r\nDELETE FROM `reference_loot_template` WHERE `Entry`=24078 AND `Item` IN (899, 1391, 1440, 1446, 1469, 1473, 1929, 1930, 1936, 1943, 1944, 1945, 1951, 2020, 4290, 10400, 10401, 10402);\r\n\r\n-- Add former items from reference table 24078 to their proper NPCs\r\nDELETE FROM `creature_loot_template` WHERE `Item` IN (899, 1391, 1440, 1446, 1469, 1473, 1929, 1930, 1936, 1943, 1944, 1945, 1951, 2020, 4290, 10400, 10401, 10402);\r\nINSERT INTO `creature_loot_template` (`Entry`, `Item`, `Chance`, `GroupId`, `Comment`) VALUES\r\n(217, 899, 0.1, 0, \"Venom Web Spider - Venom Web Fang\"),\r\n(453, 1391, 0.1, 0, \"Riverpaw Mystic - Riverpaw Mystic Staff\"),\r\n(446, 1440, 0.1, 0, \"Redridge Basher - Gnoll Skull Basher\"),\r\n(440, 1446, 0.1, 0, \"Blackrock Grunt - Blackrock Boots\"),\r\n(578, 1469, 0.1, 0, \"Murloc Scout - Scimitar of Atun\"),\r\n(14270, 1469, 1, 0, \"Squiddic - Scimitar of Atun\"),\r\n(545, 1473, 0.1, 0, \"Murloc Tidecaller - Riverside Staff\"),\r\n(1729, 1929, 0.1, 0, \"Defias Evoker - Silk-threaded Trousers\"),\r\n(4418, 1929, 0.1, 0, \"Defias Wizard - Silk-threaded Trousers\"),\r\n(598, 1930, 0.1, 0, \"Defias Miner - Stonemason Cloak\"),\r\n(622, 1936, 0.1, 0, \"Goblin Engineer - Goblin Screwdriver\"),\r\n(3947, 1943, 0.1, 0, \"Goblin Shipbuilder - Goblin Mail Leggings\"),\r\n(1731, 1944, 0.1, 0, \"Goblin Craftsman - Metalworking Gloves\"),\r\n(641, 1945, 0.1, 0, \"Goblin Woodcarver - Woodworking Gloves\"),\r\n(657, 1951, 0.1, 0, \"Defias Pirate - Blackwater Cutlass\"),\r\n(1732, 1951, 0.1, 0, \"Defias Squallshaper - Blackwater Cutlass\"),\r\n(539, 2020, 0.1, 0, \"Pygmy Venom Web Spider - Hollowfang Blade\"),\r\n(832, 4290, 0.5, 0, \"Dust Devil - Dust Bowl\"),\r\n(634, 10400, 0.5, 2, \"Defias Overseer - Blackened Defias Leggings\"),\r\n(4417, 10400, 0.5, 2, \"Defias Taskmaster - Blackened Defias Leggings\"),\r\n(634, 10401, 0.5, 2, \"Defias Overseer - Blackened Defias Gloves\"),\r\n(4417, 10401, 0.5, 2, \"Defias Taskmaster - Blackened Defias Gloves\"),\r\n(4416, 10402, 0.5, 0, \"Defias Strip Miner - Blackened Defias Boots\");\r\n```"}}
{"actor":{"display_login":"Teppic1"}}