der gesamte fix aus https://redmine.rising-gods.de/issues/13633 ist noch aktiv
-- Fix token drops in ICC #13633
-- Remove duplicated entry in reference_loot_template with the same items and chances as entry 34278
DELETE FROM `reference_loot_template` WHERE `entry` = 38437;
SET @REF_NM := 34278;
SET @REF_HM := 34279;
-- Chance for normal token (dropped in 25 NM and 10 HM)
UPDATE `reference_loot_template` SET `ChanceOrQuestChance` = 40 WHERE `entry` = @REF_NM AND `item` = 52025; -- rogue, deathknight, mage, druid
UPDATE `reference_loot_template` SET `ChanceOrQuestChance` = 30 WHERE `entry` = @REF_NM AND `item` = 52026; -- warrior, hunter, schaman
UPDATE `reference_loot_template` SET `ChanceOrQuestChance` = 30 WHERE `entry` = @REF_NM AND `item` = 52027; -- paladin, priest, warlock
-- Chance for heroic token (dropped in 25 HM)
UPDATE `reference_loot_template` SET `ChanceOrQuestChance` = 40 WHERE `entry` = @REF_HM AND `item` = 52028; -- rogue, deathknight, mage, druid
UPDATE `reference_loot_template` SET `ChanceOrQuestChance` = 30 WHERE `entry` = @REF_HM AND `item` = 52029; -- warrior, hunter, schaman
UPDATE `reference_loot_template` SET `ChanceOrQuestChance` = 30 WHERE `entry` = @REF_HM AND `item` = 52030; -- paladin, priest, warlock
-- Saurfang 25 NM already drops 2 NM tokens
-- Saurfang 10 HM should drop only 1 NM token
UPDATE `gameobject_loot_template` SET `maxcount` = 1 WHERE `entry` = 28058 AND `item` = 2;
-- Saurfang 25 HM should drop 2 NM tokens and 1 HM
DELETE FROM `gameobject_loot_template` WHERE `entry` = 28088 AND `item` IN(2, 3); -- remove current token drop
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `mincountOrRef`, `maxcount`) VALUES (28088, 2, -@REF_NM, 2); -- 2 NM tokens
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `mincountOrRef`, `maxcount`) VALUES (28088, 3, -@REF_HM, 1); -- 1 HM token
-- Professor 25 NM already drops 2 NM tokens
-- Professor 10 HM already drops 1 NM token
-- Professor 25 HM should drop 2 NM tokens and 1 HM
DELETE FROM `creature_loot_template` WHERE `entry` = 38586 AND `item` IN(1, 2); -- remove current token drop
INSERT INTO `creature_loot_template` (`entry`, `item`, `mincountOrRef`, `maxcount`) VALUES (38586, 1, -@REF_NM, 2); -- 2 NM tokens
INSERT INTO `creature_loot_template` (`entry`, `item`, `mincountOrRef`, `maxcount`) VALUES (38586, 2, -@REF_HM, 1); -- 1 HM token
-- Blood-Queen 25 NM already drops 2 NM tokens
-- Blood-Queen 10 HM already drops 1 NM token
-- Blood-Queen 25 HM should drop 2 NM tokens and 1 HM
DELETE FROM `creature_loot_template` WHERE `entry` = 38436 AND `item` IN(2, 3); -- remove current token drop
INSERT INTO `creature_loot_template` (`entry`, `item`, `mincountOrRef`, `maxcount`) VALUES (38436, 2, -@REF_NM, 2); -- 2 NM tokens
INSERT INTO `creature_loot_template` (`entry`, `item`, `mincountOrRef`, `maxcount`) VALUES (38436, 3, -@REF_HM, 1); -- 1 HM token
-- Sindragosa 25 NM already drops 2 NM tokens
-- Sindragosa 10 HM already drops 1 NM token
-- Sindragosa 25 HM should drop 2 NM tokens and 1 HM
DELETE FROM `creature_loot_template` WHERE `entry` = 38267 AND `item` IN(2, 3); -- remove current token drop
INSERT INTO `creature_loot_template` (`entry`, `item`, `mincountOrRef`, `maxcount`) VALUES (38267, 2, -@REF_NM, 2); -- 2 NM tokens
INSERT INTO `creature_loot_template` (`entry`, `item`, `mincountOrRef`, `maxcount`) VALUES (38267, 3, -@REF_HM, 1); -- 1 HM token
-- Lich King 25 NM already drops 2 NM tokens
-- Lich King 10 HM already drops 1 NM token
-- Lich King 25 HM should drop 2 NM tokens and 1 HM
DELETE FROM `creature_loot_template` WHERE `entry` = 39168 AND `item` IN(2, 3); -- remove current token drop
INSERT INTO `creature_loot_template` (`entry`, `item`, `mincountOrRef`, `maxcount`) VALUES (39168, 2, -@REF_NM, 2); -- 2 NM tokens
INSERT INTO `creature_loot_template` (`entry`, `item`, `mincountOrRef`, `maxcount`) VALUES (39168, 3, -@REF_HM, 1); -- 1 HM token
hast wohl einfach kein glück ^^
Von 
Von 
Von