a5051c9bf5
* work against more correctly assigning instance mode to entities and loot
- added manually collected data for difficulty versions of gameobjects, just boss chests for now.
update setup/source to default object source to base difficulty version if able
- update spelldifficulty table to contain the (likely) mapmode it will be used in
* refactored class loot
- implement loot mode indicators on listview for creature and gameobject loot
- show 'drops' listview tab on instance zone page
- fixes against tribute chest systems (toc / ulduar)
- fix icc gunship battle chest ownership
42 lines
2.6 KiB
SQL
42 lines
2.6 KiB
SQL
DROP TABLE IF EXISTS `aowow_objectdifficulty`;
|
|
CREATE TABLE `aowow_objectdifficulty` (
|
|
`normal10` mediumint(8) unsigned NOT NULL,
|
|
`normal25` mediumint(8) unsigned NOT NULL,
|
|
`heroic10` mediumint(8) unsigned NOT NULL,
|
|
`heroic25` mediumint(8) unsigned NOT NULL,
|
|
`mapType` tinyint(3) unsigned NOT NULL,
|
|
KEY `normal10` (`normal10`),
|
|
KEY `normal25` (`normal25`),
|
|
KEY `heroic10` (`heroic10`),
|
|
KEY `heroic25` (`heroic25`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
INSERT INTO `aowow_objectdifficulty` VALUES
|
|
(181366, 193426, 0, 0 , 2), -- naxxramas: four horsemen chest
|
|
(193905, 193967, 0, 0 , 2), -- eoe: alexstrasza's gift
|
|
(194307, 194308, 194200, 194201, 2), -- ulduar: cache of winter
|
|
(194312, 194314, 194313, 194315, 2), -- ulduar: cache of storms
|
|
(194324, 194328, 194325, 194329, 2), -- ulduar: freya's gift +1 elder
|
|
(194324, 194328, 194326, 194330, 2), -- ulduar: freya's gift +2 elder
|
|
(194324, 194328, 194327, 194331, 2), -- ulduar: freya's gift +3 elder
|
|
(194789, 194956, 194957, 194958, 2), -- ulduar: cache of innovation
|
|
(194821, 194822, 0, 0 , 2), -- ulduar: gift of the observer
|
|
(195046, 195047, 0, 0 , 2), -- ulduar: cache of living stone
|
|
(195631, 195632, 195633, 195635, 2), -- toc25: champions' cache
|
|
(202178, 202180, 202177, 202179, 2), -- icc: gunship armory (horde)
|
|
(201873, 201874, 201872, 201875, 2), -- icc: gunship armory (alliance)
|
|
(202239, 202240, 202238, 202241, 2), -- icc: deathbringer's cache
|
|
(201959, 202339, 202338, 202340, 2), -- icc: cache of the dreamwalker
|
|
(0, 0, 195668, 195672, 2), -- toc25: argent crusade tribute chest 1TL
|
|
(0, 0, 195667, 195671, 2), -- toc25: argent crusade tribute chest 25TL
|
|
(0, 0, 195666, 195670, 2), -- toc25: argent crusade tribute chest 45TL
|
|
(0, 0, 195665, 195669, 2), -- toc25: argent crusade tribute chest 50TL
|
|
(185168, 185169, 0, 0 , 1), -- hellfire ramparts: reinforced fel iron chest
|
|
(184465, 184849, 0, 0 , 1), -- mechanar: cache of the legion
|
|
(190586, 193996, 0, 0 , 1), -- halls of stone: tribunal chest
|
|
(190663, 193597, 0, 0 , 1), -- cot - cos: dark runed chest
|
|
(191349, 193603, 0, 0 , 1), -- oculus: cache of eregos
|
|
(195709, 195710, 0, 0 , 1), -- toc5: champion's cache
|
|
(195323, 195324, 0, 0 , 1), -- toc5: confessor's cache
|
|
(195374, 195375, 0, 0 , 1), -- toc5: eadric's cache
|
|
(201710, 202336, 0, 0 , 1); -- hor: captain's chest
|