- 58
- 2025
- 25
[Location, Faction, Race] Mists of Pandaria endgame content (Golden Lotus dailies, Tillers farming, Troves of the Thunder King, Theramore scenario, Timeless Isle, Brawler's Guild, etc.), both factions, any race.
[Name, Type] 85 distinct container Items (item_template entry >= 80000, Flags bit 4 = ITEM_FLAG_HAS_LOOT). Five high-profile examples confirmed:
85223 Enigma Seed Pack (Tillers farming reward)
90041 Spoils of Theramore (Theramore scenario)
90625 Treasures of the Vale (Golden Lotus daily reward)
97153 Spoils of the Thunder King (Troves of the Thunder King scenario)
104034 Purse of Timeless Coins (Timeless Isle)
[Problem Description] 85 modern Pandaria container items are flagged as lootable (item_template.Flags has bit 4 = ITEM_FLAG_HAS_LOOT) but have ZERO rows in item_loot_template. When the player opens one of these containers in-game the item is consumed and nothing drops because there is no loot table to roll on. This silently breaks a large chunk of the MoP endgame reward economy - daily-quest bag rewards, scenario rewards, Tillers farming bags, Brawler's Guild bags, Timeless Isle drops, etc.
Reproducible DB queries (read-only, world DB):
SELECT COUNT(*) FROM item_template it LEFT JOIN item_loot_template ilt ON it.entry = ilt.entry WHERE (it.Flags & 4) <> 0 AND ilt.entry IS NULL AND it.entry >= 80000; -- 85
SELECT it.entry, it.name FROM item_template it LEFT JOIN item_loot_template ilt ON it.entry = ilt.entry WHERE (it.Flags & 4) <> 0 AND ilt.entry IS NULL AND it.entry IN (85223, 90041, 90625, 97153, 104034); -- 5 rows (the examples above)
[How it should work] Each of these 85 items needs its loot tables populated in item_loot_template (or pointed to an existing reference_loot_template via negative mincountOrRef) so opening the container produces the expected drops - the daily currency/coins/profession mats/cooking ingredients/etc. that retail Mists of Pandaria gives. Right now they are silent black holes.
Related: the Pet Supply bags reported in thread #18788 are the same class of bug for the pet-supply container item IDs. This issue is the broader audit - 85 items in the >=80000 range, including but not limited to the pet supplies.
Links: http://mop-shoot.tauri.hu/?item=85223 | http://mop-shoot.tauri.hu/?item=90625 | http://mop-shoot.tauri.hu/?item=97153 | http://mop-shoot.tauri.hu/?item=104034
[Name, Type] 85 distinct container Items (item_template entry >= 80000, Flags bit 4 = ITEM_FLAG_HAS_LOOT). Five high-profile examples confirmed:
85223 Enigma Seed Pack (Tillers farming reward)
90041 Spoils of Theramore (Theramore scenario)
90625 Treasures of the Vale (Golden Lotus daily reward)
97153 Spoils of the Thunder King (Troves of the Thunder King scenario)
104034 Purse of Timeless Coins (Timeless Isle)
[Problem Description] 85 modern Pandaria container items are flagged as lootable (item_template.Flags has bit 4 = ITEM_FLAG_HAS_LOOT) but have ZERO rows in item_loot_template. When the player opens one of these containers in-game the item is consumed and nothing drops because there is no loot table to roll on. This silently breaks a large chunk of the MoP endgame reward economy - daily-quest bag rewards, scenario rewards, Tillers farming bags, Brawler's Guild bags, Timeless Isle drops, etc.
Reproducible DB queries (read-only, world DB):
SELECT COUNT(*) FROM item_template it LEFT JOIN item_loot_template ilt ON it.entry = ilt.entry WHERE (it.Flags & 4) <> 0 AND ilt.entry IS NULL AND it.entry >= 80000; -- 85
SELECT it.entry, it.name FROM item_template it LEFT JOIN item_loot_template ilt ON it.entry = ilt.entry WHERE (it.Flags & 4) <> 0 AND ilt.entry IS NULL AND it.entry IN (85223, 90041, 90625, 97153, 104034); -- 5 rows (the examples above)
[How it should work] Each of these 85 items needs its loot tables populated in item_loot_template (or pointed to an existing reference_loot_template via negative mincountOrRef) so opening the container produces the expected drops - the daily currency/coins/profession mats/cooking ingredients/etc. that retail Mists of Pandaria gives. Right now they are silent black holes.
Related: the Pet Supply bags reported in thread #18788 are the same class of bug for the pet-supply container item IDs. This issue is the broader audit - 85 items in the >=80000 range, including but not limited to the pet supplies.
Links: http://mop-shoot.tauri.hu/?item=85223 | http://mop-shoot.tauri.hu/?item=90625 | http://mop-shoot.tauri.hu/?item=97153 | http://mop-shoot.tauri.hu/?item=104034