[MoP] Timeless Isle [Firestorm Egg]

[Avoel]

• bugtracker Link: None
• wowhead link: Firestorm Egg
• correction: Added loot

Quote

-- Fixed Loot Template of Object Firestorm Egg (222688)
-- Default Loot Template
DELETE FROM `gameobject_loot_template` WHERE `entry`='222688';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
('222688', '104257', '5', '1', '0', '1', '1'),
('222688', '777', '100', '1', '0', '1', '50');
UPDATE `gameobject_loot_template` SET `lootid`='222688' WHERE `entry`='84925';

 

[Mikrole]

6 hours ago, Tweedy said:

• bugtracker Link: None
• wowhead link: Firestorm Egg
• correction: Added loot

 

Hay there, it need a minus by the currency ID in *loot_template, otherwise it will drop an item.

('222688', '-777', '100', '1', '0', '1', '50');

 

[Avoel]

Just now, Mikrole said:

Hay there, it need a minus by the currency ID in *loot_template, otherwise it will drop an item.

('222688', '-777', '100', '1', '0', '1', '50');

 

Oh shit , forget it since i was kinda busy and wanted to fix it fast , haha thanks anyway

Quote

-- Fixed Loot Template of Object Firestorm Egg (222688)
-- Default Loot Template
DELETE FROM `gameobject_loot_template` WHERE `entry`='222688';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
('222688', '104257', '5', '1', '0', '1', '1'),
('222688', '-777', '100', '1', '0', '1', '50');
UPDATE `gameobject_loot_template` SET `lootid`='222688' WHERE `entry`='84925';

 

[Mikrole]

 

DELETE FROM `gameobject_loot_template` WHERE `entry`='222688';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
('222688', '104257', '-5', '1', '0', '1', '1'),
('222688', '-777', '100', '1', '0', '1', '50');
UPDATE `gameobject_template` SET `data1`='222688' WHERE `entry`='222688';

Patch accepted, merged soon on live realms. Thanks