{"action":"created","issue":{"url":"https://api.github.com/repos/classicdb/database/issues/901","repository_url":"https://api.github.com/repos/classicdb/database","labels_url":"https://api.github.com/repos/classicdb/database/issues/901/labels{/name}","comments_url":"https://api.github.com/repos/classicdb/database/issues/901/comments","events_url":"https://api.github.com/repos/classicdb/database/issues/901/events","html_url":"https://github.com/classicdb/database/pull/901","id":177957166,"number":901,"title":"Raid boss loot table revisions","user":{"login":"Stryg","id":17740211,"avatar_url":"https://avatars.githubusercontent.com/u/17740211?v=3","gravatar_id":"","url":"https://api.github.com/users/Stryg","html_url":"https://github.com/Stryg","followers_url":"https://api.github.com/users/Stryg/followers","following_url":"https://api.github.com/users/Stryg/following{/other_user}","gists_url":"https://api.github.com/users/Stryg/gists{/gist_id}","starred_url":"https://api.github.com/users/Stryg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Stryg/subscriptions","organizations_url":"https://api.github.com/users/Stryg/orgs","repos_url":"https://api.github.com/users/Stryg/repos","events_url":"https://api.github.com/users/Stryg/events{/privacy}","received_events_url":"https://api.github.com/users/Stryg/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"Tobschinski","id":4753528,"avatar_url":"https://avatars.githubusercontent.com/u/4753528?v=3","gravatar_id":"","url":"https://api.github.com/users/Tobschinski","html_url":"https://github.com/Tobschinski","followers_url":"https://api.github.com/users/Tobschinski/followers","following_url":"https://api.github.com/users/Tobschinski/following{/other_user}","gists_url":"https://api.github.com/users/Tobschinski/gists{/gist_id}","starred_url":"https://api.github.com/users/Tobschinski/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Tobschinski/subscriptions","organizations_url":"https://api.github.com/users/Tobschinski/orgs","repos_url":"https://api.github.com/users/Tobschinski/repos","events_url":"https://api.github.com/users/Tobschinski/events{/privacy}","received_events_url":"https://api.github.com/users/Tobschinski/received_events","type":"User","site_admin":false},"assignees":[{"login":"Tobschinski","id":4753528,"avatar_url":"https://avatars.githubusercontent.com/u/4753528?v=3","gravatar_id":"","url":"https://api.github.com/users/Tobschinski","html_url":"https://github.com/Tobschinski","followers_url":"https://api.github.com/users/Tobschinski/followers","following_url":"https://api.github.com/users/Tobschinski/following{/other_user}","gists_url":"https://api.github.com/users/Tobschinski/gists{/gist_id}","starred_url":"https://api.github.com/users/Tobschinski/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Tobschinski/subscriptions","organizations_url":"https://api.github.com/users/Tobschinski/orgs","repos_url":"https://api.github.com/users/Tobschinski/repos","events_url":"https://api.github.com/users/Tobschinski/events{/privacy}","received_events_url":"https://api.github.com/users/Tobschinski/received_events","type":"User","site_admin":false}],"milestone":null,"comments":4,"created_at":"2016-09-20T03:50:19Z","updated_at":"2016-10-02T00:19:53Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/classicdb/database/pulls/901","html_url":"https://github.com/classicdb/database/pull/901","diff_url":"https://github.com/classicdb/database/pull/901.diff","patch_url":"https://github.com/classicdb/database/pull/901.patch"},"body":"The members of Elitistjerks originally researched how Blizzard structured the raid loot tables back in 2006. Since EJ has died recently, the [original thread](http://forums.elitistjerks.com/forums/topic/6606-bosses-and-nonset-item-slots/) describing them is now lost to time. That's okay though, since we can simply retrace their steps by looking at the old DKP logs that are still up.\r\n\r\nhttp://www.ropetown.com/ropedkp/listitems.php?s=37dacb02f69a84424296198c78a70aca\r\nhttp://dkp2.furious-guild.com/listitems.php?s=3dbfa969b3dc768a1933197a8f58b97e\r\n\r\nThe critical observation here is that bosses never dropped duplicate loot in vanilla, with the exception of T2 set items and world bosses (Kazzak, etc.) So you might see Ragnaros drop double Stormrage Leggings, but you'd never see double Band of Accuria, because the items are divided up into non-overlapping loot tables. Using this information it becomes trivial to examine each instance of an item being dropped and noting what items can appear at the same time.\r\n\r\nFor example, looking at the item history for an item like [Band of Sulfuras](http://ropetown.com/ropedkp/viewitem.php?s=42b24947370b32227b677cdfbb987ade&i=4019) you can quickly build a table of the non-set items that aren't in its loot table. You will never see a Crown of Destruction, Choker of the Fire Lord, Essence of the Pure Flame, or Perdition's Blade drop at the same time as Band of Sulfuras, because they occupy the same loot pool. You can go through each item like this until you've built a complete picture of the boss's loot tables by process of elimination. This doesn't take very long, so I went through every vanilla raid boss that requires fixing and mapped the loot tables in this chart:\r\n\r\nhttps://docs.google.com/spreadsheets/d/1U2Ta49ulVygaT5IFCIFH03qoTRVY3JUHA65p2HNE03Q/edit?usp=sharing\r\n\r\nIf you have any doubts about a particular boss or item, just verify it with ropetown's item history.\r\n\r\nSome observations:\r\n1. Onyxia's weapons + Shard of the Scale, Ragnaros's two handers + Shard of the Flame, and C'thun's trinket occupy bonus loot tables. [When a Bonereaver's Edge drops](http://www.ropetown.com/ropedkp/viewraid.php?s=d8915296737a13d5df692e7b92cdf31a&r=745), it's in addition to two other non-set items and to the exclusion of a Spinal Reaper or Shard of the Flame. \r\n2.  In general, weapons in T2 and T2.5 content have half the drop rate of items they share a loot table with. So, Ashkandi (10%) has half the drop rate of Neltharion's Tear (20%). Claw of the Black Drake is the only exception to this that I've found. Weapons in T3 do not seem to follow this rule (e.g. Patchwerk's axe has the same drop % as his cloak and ring)\r\n3. While it's impossible to be completely certain on some item's drop percentage, we can still use Allakhazam's archived data to infer close approximations of what the item's drop rate should be. For example, we know that Golemagg has a 25% chance to drop Arcanist Robes, because it shares a loot table with 3 other T1 chests, and [looking at Allakhazam's data](http://web.archive.org/web/20061125223729/http://wow.allakhazam.com/db/mob.html?wmob=11988) we see that Golemagg's weapons all have an equal if not greater chance to drop. So, Golemagg's third loot table must look something like 100% = 25% Blastershot + 25% Staff of Dominance + 25% Azuresong Mageblade + 25% shared loot table (with Magmadar/Geddon/Garr).\r\n\r\nThis commit updates all of the bosses that require fixing, excepting Sapphiron and Kel'Thuzad. I don't have enough data on those bosses yet to construct accurate loot tables.\r\n\r\nMolten Core and Blackwing Lair benefit _a lot_ from this fix. Boss-specific items like Striker's Mark, Drillborer's Disk, Drake Fang Talisman, etc. were nonsensically rare with the way the old loot tables were structured. Ragnaros two handers and that silly health regen trinket no longer occupy the same loot table as more valuable PvE items. You will never see Chromaggus drop double Shimmering Getas. etc.\r\n\r\nBosses affected:\r\nOnyxia, Lucifron, Gehennas, Garr, Baron Geddon, Shazzrah, Sulfuron Harbinger,\r\nGolemagg the Incinerator, Majordomo Executus, Ragnaros, Firemaw, Ebonroc,\r\nFlamegor, Chromaggus, Nefarian, Hakkar, Ossirian the Unscarred, The Prophet Skeram,\r\nBattleguard Sartura, Fankriss the Unyielding, C'Thun"},"comment":{"url":"https://api.github.com/repos/classicdb/database/issues/comments/250945854","html_url":"https://github.com/classicdb/database/pull/901#issuecomment-250945854","issue_url":"https://api.github.com/repos/classicdb/database/issues/901","id":250945854,"user":{"login":"dagochen","id":5236186,"avatar_url":"https://avatars.githubusercontent.com/u/5236186?v=3","gravatar_id":"","url":"https://api.github.com/users/dagochen","html_url":"https://github.com/dagochen","followers_url":"https://api.github.com/users/dagochen/followers","following_url":"https://api.github.com/users/dagochen/following{/other_user}","gists_url":"https://api.github.com/users/dagochen/gists{/gist_id}","starred_url":"https://api.github.com/users/dagochen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dagochen/subscriptions","organizations_url":"https://api.github.com/users/dagochen/orgs","repos_url":"https://api.github.com/users/dagochen/repos","events_url":"https://api.github.com/users/dagochen/events{/privacy}","received_events_url":"https://api.github.com/users/dagochen/received_events","type":"User","site_admin":false},"created_at":"2016-10-02T00:19:53Z","updated_at":"2016-10-02T00:19:53Z","body":"@Rockette \r\nThats wrong. They actually could drop only 1 or none or 3 T2 gloves. Which made T2 gloves the hardest to get T2 from all set items in t2 content. Just check out several of the old dkp logs of guilds from classic content and you will see the proof."}}
{"actor":{"display_login":"dagochen"}}