{"action":"created","issue":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14113","labels_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14113/labels{/name}","comments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14113/comments","events_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14113/events","html_url":"https://github.com/TrinityCore/TrinityCore/issues/14113","id":57360798,"number":14113,"title":"Sealed Chest","user":{"login":"Frytiks","id":5080979,"avatar_url":"https://avatars.githubusercontent.com/u/5080979?v=3","gravatar_id":"","url":"https://api.github.com/users/Frytiks","html_url":"https://github.com/Frytiks","followers_url":"https://api.github.com/users/Frytiks/followers","following_url":"https://api.github.com/users/Frytiks/following{/other_user}","gists_url":"https://api.github.com/users/Frytiks/gists{/gist_id}","starred_url":"https://api.github.com/users/Frytiks/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Frytiks/subscriptions","organizations_url":"https://api.github.com/users/Frytiks/orgs","repos_url":"https://api.github.com/users/Frytiks/repos","events_url":"https://api.github.com/users/Frytiks/events{/privacy}","received_events_url":"https://api.github.com/users/Frytiks/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/Priority-Cosmetic","name":"Priority-Cosmetic","color":"e102d8"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":12,"created_at":"2015-02-11T19:04:36Z","updated_at":"2015-04-29T14:06:55Z","closed_at":null,"body":"rev: https://github.com/TrinityCore/TrinityCore/commit/73709e7c1334521189d8882ab1ba33fe259a12dc\r\nDB: 11.57\r\n\r\nThis item http://www.wowhead.com/item=51315/sealed-chest dropping normally, but players can't loot it. Just when player click, it don't loot to your bag.\r\n\r\n<bountysource-plugin>\r\n---\r\nWant to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/8496294-sealed-chest?utm_campaign=plugin&utm_content=tracker%2F1310&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F1310&utm_medium=issues&utm_source=github).\r\n</bountysource-plugin>"},"comment":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/comments/97438448","html_url":"https://github.com/TrinityCore/TrinityCore/issues/14113#issuecomment-97438448","issue_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14113","id":97438448,"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},"created_at":"2015-04-29T14:06:55Z","updated_at":"2015-04-29T14:06:55Z","body":"The player will be able to see and loot the chest if Shadowmourne is equiped and he don't have the chest in his bags or bank and if the quest The Lich King''s Last Stand is taken, completed or rewarded and if the quest Personal Property is not complete or rewarded\r\n``` sql\r\nDELETE FROM creature_loot_template WHERE entry IN (36597, 39167) AND Item= 51315; -- Delete Sealed Chest from 10 difficulties loot list\r\nDELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=1 AND `SourceEntry`=51315;\r\nINSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`Scriptname`,`Comment`) VALUES\r\n-- Lich King 25N\r\n(1,39166,51315,0,0,2,0,51315,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player doesn''t have it already'),\r\n(1,39166,51315,0,0,3,0,49623,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player is wielding Shadowmourne'),\r\n(1,39166,51315,0,0,28,0,24914,0,0,1,0 ,'' , 'Sealed Chest will drop only if the player hasn''t \"Personal Property\" in their quest log completed'),\r\n(1,39166,51315,0,0,9,0,24748,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player has \"The Lich King''s Last Stand\" in their quest log'),\r\n--\r\n(1,39166,51315,0,1,2,0,51315,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player doesn''t have it already'),\r\n(1,39166,51315,0,1,3,0,49623,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player is wielding Shadowmourne'),\r\n(1,39166,51315,0,1,8,0,24914,0,0,1,0 ,'' , 'Sealed Chest will drop only if the player hasn''t \"Personal Property\" in their quest log Rewarded'),\r\n(1,39166,51315,0,1,9,0,24748,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player has \"The Lich King''s Last Stand\" in their quest log'),\r\n--\r\n(1,39166,51315,0,2,2,0,51315,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player doesn''t have it already'),\r\n(1,39166,51315,0,2,3,0,49623,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player is wielding Shadowmourne'),\r\n(1,39166,51315,0,2,28,0,24914,0,0,1,0 ,'' , 'Sealed Chest will drop only if the player hasn''t \"Personal Property\" in their quest log completed'),\r\n(1,39166,51315,0,2,8,0,24748,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player has \"The Lich King''s Last Stand\" rewarded'),\r\n--\r\n(1,39166,51315,0,3,2,0,51315,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player doesn''t have it already'),\r\n(1,39166,51315,0,3,3,0,49623,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player is wielding Shadowmourne'),\r\n(1,39166,51315,0,3,8,0,24914,0,0,1,0 ,'' , 'Sealed Chest will drop only if the player hasn''t \"Personal Property\" in their quest log Rewarded'),\r\n(1,39166,51315,0,3,8,0,24748,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player has \"The Lich King''s Last Stand\" rewarded'),\r\n\r\n--\r\n(1,39166,51315,0,4,2,0,51315,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player doesn''t have it already'),\r\n(1,39166,51315,0,4,3,0,49623,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player is wielding Shadowmourne'),\r\n(1,39166,51315,0,4,28,0,24914,0,0,1,0 ,'' , 'Sealed Chest will drop only if the player hasn''t \"Personal Property\" in their quest log completed'),\r\n(1,39166,51315,0,4,28,0,24748,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player has \"The Lich King''s Last Stand\" Completed'),\r\n\r\n(1,39166,51315,0,5,2,0,51315,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player doesn''t have it already'),\r\n(1,39166,51315,0,5,3,0,49623,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player is wielding Shadowmourne'),\r\n(1,39166,51315,0,5,8,0,24914,0,0,1,0 ,'' , 'Sealed Chest will drop only if the player hasn''t \"Personal Property\" in their quest log Rewarded'),\r\n(1,39166,51315,0,5,28,0,24748,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player has \"The Lich King''s Last Stand\" Completed'),\r\n-- Lich King 25H\r\n(1,39168,51315,0,0,2,0,51315,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player doesn''t have it already'),\r\n(1,39168,51315,0,0,3,0,49623,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player is wielding Shadowmourne'),\r\n(1,39168,51315,0,0,28,0,24914,0,0,1,0 ,'' , 'Sealed Chest will drop only if the player hasn''t \"Personal Property\" in their quest log completed'),\r\n(1,39168,51315,0,0,9,0,24748,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player has \"The Lich King''s Last Stand\" in their quest log'),\r\n--\r\n(1,39168,51315,0,1,2,0,51315,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player doesn''t have it already'),\r\n(1,39168,51315,0,1,3,0,49623,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player is wielding Shadowmourne'),\r\n(1,39168,51315,0,1,8,0,24914,0,0,1,0 ,'' , 'Sealed Chest will drop only if the player hasn''t \"Personal Property\" in their quest log Rewarded'),\r\n(1,39168,51315,0,1,9,0,24748,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player has \"The Lich King''s Last Stand\" in their quest log'),\r\n--\r\n(1,39168,51315,0,2,2,0,51315,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player doesn''t have it already'),\r\n(1,39168,51315,0,2,3,0,49623,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player is wielding Shadowmourne'),\r\n(1,39168,51315,0,2,28,0,24914,0,0,1,0 ,'' , 'Sealed Chest will drop only if the player hasn''t \"Personal Property\" in their quest log completed'),\r\n(1,39168,51315,0,2,8,0,24748,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player has \"The Lich King''s Last Stand\" rewarded'),\r\n--\r\n(1,39168,51315,0,3,2,0,51315,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player doesn''t have it already'),\r\n(1,39168,51315,0,3,3,0,49623,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player is wielding Shadowmourne'),\r\n(1,39168,51315,0,3,8,0,24914,0,0,1,0 ,'' , 'Sealed Chest will drop only if the player hasn''t \"Personal Property\" in their quest log Rewarded'),\r\n(1,39168,51315,0,3,8,0,24748,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player has \"The Lich King''s Last Stand\" rewarded'),\r\n--\r\n(1,39168,51315,0,4,2,0,51315,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player doesn''t have it already'),\r\n(1,39168,51315,0,4,3,0,49623,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player is wielding Shadowmourne'),\r\n(1,39168,51315,0,4,28,0,24914,0,0,1,0 ,'' , 'Sealed Chest will drop only if the player hasn''t \"Personal Property\" in their quest log completed'),\r\n(1,39168,51315,0,4,28,0,24748,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player has \"The Lich King''s Last Stand\" Completed'),\r\n--\r\n(1,39168,51315,0,5,2,0,51315,1,1,1,0 ,'' , 'Sealed Chest will drop only if the player doesn''t have it already'),\r\n(1,39168,51315,0,5,3,0,49623,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player is wielding Shadowmourne'),\r\n(1,39168,51315,0,5,8,0,24914,0,0,1,0 ,'' , 'Sealed Chest will drop only if the player hasn''t \"Personal Property\" in their quest log Rewarded'),\r\n(1,39168,51315,0,5,28,0,24748,0,0,0,0 ,'' , 'Sealed Chest will drop only if the player has \"The Lich King''s Last Stand\" Completed');"}}