[Mediv]

Ragnaros loot FIX

Фикс добавляет лут и самого босса.

DELETE FROM `creature` WHERE `id` IN (11502);

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

INSERT INTO `creature` (`guid`, `id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES ('160386','11502','409','0','0','838.384','-830.921','-232.181','2.52474','1000000','5','0','330000','0','0','1');

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

(11502,16915,17,0,1,1,0,0,0),
(11502,16922,17,0,1,1,0,0,0),
(11502,16930,17,0,1,1,0,0,0),
(11502,16909,17,0,1,1,0,0,0),
(11502,16901,17,0,1,1,0,0,0),
(11502,16938,17,0,1,1,0,0,0),
(11502,16946,17,0,1,1,0,0,0),
(11502,16962,17,0,1,1,0,0,0),
(11502,16954,17,0,1,1,0,0,0),
(11502,17204,1,0,1,1,0,0,0),
(11502,17182,1,0,1,1,0,0,0),
(11502,19017,-100,0,1,1,0,0,0),
(11502,19019,1,0,1,1,0,0,0),
(11502,17102,14,0,1,1,0,0,0),
(11502,17107,15,0,1,1,0,0,0),
(11502,18817,17,0,1,1,0,0,0),
(11502,19137,13,0,1,1,0,0,0),
(11502,17104,4,0,1,1,0,0,0),
(11502,17076,5,0,1,1,0,0,0),
(11502,18816,16,0,1,1,0,0,0),
(11502,17106,14,0,1,1,0,0,0),
(11502,18815,18,0,1,1,0,0,0),
(11502,18814,16,0,1,1,0,0,0),
(11502,19138,15,0,1,1,0,0,0),
(11502,17063,15,0,1,1,0,0,0),
(11502,17082,5,0,1,1,0,0,0);

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