[Mediv]

Lord Valthalak loot FIX

Добавление отсутствующего лута для босса Lord Valthalak (Black Rock Spire Upper)

=DOWNLOAD=

DELETE FROM `creature_loot_template` WHERE `entry` IN (16042);

INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES

('16042','22302','27.72','0','1','1','0','0','0'),
('16042','22337','23.37','0','1','1','0','0','0'),
('16042','22342','23.10','0','1','1','0','0','0'),
('16042','22343','20.11','0','1','1','0','0','0'),
('16042','22335','14.67','0','1','1','0','0','0'),
('16042','22336','17.66','0','1','1','0','0','0'),
('16042','22339','15.49','0','1','1','0','0','0'),
('16042','22340','17.66','0','1','1','0','0','0');

UPDATE `creature_template` SET `lootid` = 16042 WHERE `entry` IN (16042);

Warchief Rend Blackhand loot FIX

Фикс добавляет лут боссу, изменяет параметр armor.

=DOWNLOAD=

DELETE FROM `creature_loot_template` WHERE `entry` IN (10429);

INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES

('10429','12590','1.06','0','1','1','0','0','0'),
('10429','16733','13.39','0','1','1','0','0','0'),
('10429','22247','12.71','0','1','1','0','0','0'),
('10429','18102','14.35','0','1','1','0','0','0'),
('10429','12587','14.50','0','1','1','0','0','0'),
('10429','18104','15.30','0','1','1','0','0','0'),
('10429','12588','0.85','0','1','1','0','0','0'),
('10429','12935','15.05','0','1','1','0','0','0'),
('10429','12936','16.96','0','1','1','0','0','0'),
('10429','12939','7.61','0','1','1','0','0','0'),
('10429','12940','6.79','0','1','1','0','0','0'),
('10429','12583','7.44','0','1','1','0','0','0'),
('10429','18103','15.38','0','1','1','0','0','0');

UPDATE `creature_template` SET `lootid` = 10429 WHERE `entry` IN (10429);

UPDATE `creature_template` SET `armor` = 6000 WHERE `entry` IN (10429);

Amulet of Union loot FIX

Исправляет дроп пяти самоцветов и амулета духов для создания Amulet of Union

=DOWNLOAD=

DELETE FROM `creature_loot_template` WHERE `entry` IN (12240, 13742, 12239, 13741, 12241, 13740, 12242, 13739, 13738, 12243, 13718);

INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES

('12240','17761','100','0','1','1','0','0','0'),
('13742','17761','100','0','1','1','0','0','0'),
('12239','17762','100','0','1','1','0','0','0'),
('13741','17762','100','0','1','1','0','0','0'),
('12241','17763','100','0','1','1','0','0','0'),
('13740','17763','100','0','1','1','0','0','0'),
('12242','17764','100','0','1','1','0','0','0'),
('13739','17764','100','0','1','1','0','0','0'),
('13738','17765','100','0','1','1','0','0','0'),
('12243','17765','100','0','1','1','0','0','0'),
('13718','17757','100','0','1','1','0','0','0');

UPDATE `creature_template` SET `lootid` = 12240 WHERE `entry` IN (12240);
UPDATE `creature_template` SET `lootid` = 13742 WHERE `entry` IN (13742);
UPDATE `creature_template` SET `lootid` = 12239 WHERE `entry` IN (12239);
UPDATE `creature_template` SET `lootid` = 13741 WHERE `entry` IN (13741);
UPDATE `creature_template` SET `lootid` = 12241 WHERE `entry` IN (12241);
UPDATE `creature_template` SET `lootid` = 13740 WHERE `entry` IN (13740);
UPDATE `creature_template` SET `lootid` = 12242 WHERE `entry` IN (12242);
UPDATE `creature_template` SET `lootid` = 13739 WHERE `entry` IN (13739);
UPDATE `creature_template` SET `lootid` = 13738 WHERE `entry` IN (13738);
UPDATE `creature_template` SET `lootid` = 12243 WHERE `entry` IN (12243);
UPDATE `creature_template` SET `lootid` = 13718 WHERE `entry` IN (13718);