[MoP] Icecrown Citadel [Sealed/Unsealed - Chest]

[Avoel]

• Bugtracker Link: https://firestorm-servers.com/us/report/see_report/7323
• wowhead Link: http://www.wowhead.com/item=51316/unsealed-chest
• correction: Added Loot to http://www.wowhead.com/item=51316/unsealed-chest

Unsealed Chest [Sealed Chest(?)]

Spoiler

Quote

-- Unsealed Chest (http://www.wowhead.com/item=51316/unsealed-chest)
-- Object ID #51316
-- Added Loot by Tweedy
DELETE FROM `gameobject_loot_template` WHERE `entry`='51316';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
('51316', '51319', '100' '1', '0', '1', '1'),
('51316', '51320', '100' '1', '0', '1', '1'),
('51316', '51321', '100' '1', '0', '1', '1'),
('51316', '51318', '100' '1', '0', '1', '1'),
('51316', '51317', '100', '1', '0', '1', '1');
UPDATE `gameobject_template` SET `data1`='51316' WHERE `entry`='51316';

 

 

[Avoel]

1 hour ago, Tweedy said:

• Bugtracker Link: https://firestorm-servers.com/us/report/see_report/7323
• wowhead Link: Unsealed Chest
• correction: Added Loot to Unsealed Chest

Unsealed Chest [Sealed Chest(?)] BUGFIX!

  Hide contents

-- Unsealed Chest (http://www.wowhead.com/item=51316/unsealed-chest)
-- Object ID #51316
-- Added Loot by Tweedy
DELETE FROM `prospering_loot_template` WHERE `entry`='51316';
INSERT INTO `prospering_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
('51316', '51319', '100' '1', '0', '1', '1'),
('51316', '51320', '100' '1', '0', '1', '1'),
('51316', '51321', '100' '1', '0', '1', '1'),
('51316', '51318', '100' '1', '0', '1', '1'),
('51316', '51317', '100', '1', '0', '1', '1');
UPDATE `prospering_template` SET `data1`='51316' WHERE `entry`='51316';

 

 

Edited April 21, 2016 by Tweedy

[Hypnos]

Same error than before, the comma between the values. Be carefull with it .

[Mikrole]

prospering_loot_template prospecting, not prospering  And prospering_template doesn't exist.

[Avoel]

13 hours ago, Tweedy said:

-- Unsealed Chest (http://www.wowhead.com/item=51316/unsealed-chest)
-- Object ID #51316
-- Added Loot by Tweedy
DELETE FROM `prospecting_loot_template` WHERE `entry`='51316';
INSERT INTO `prospecting_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
('51316', '51319', '100', '1', '0', '1', '1'),
('51316', '51320', '100', '1', '0', '1', '1'),
('51316', '51321', '100', '1', '0', '1', '1'),
('51316', '51318', '100', '1', '0', '1', '1'),
('51316', '51317', '100', '1', '0', '1', '1');
UPDATE `prospecting_loot_template` SET `data1`='51316' WHERE `entry`='51316';

[Hypnos]

Meh im really lost with your patch, dunno what you want to fix :P. Well the first thing is that the item is in the loot already, so the patch isnt need.

For your patch, a little advices:

- Lich king drops the item, so it would be creature_loot_template table.

- if you delete the full loot with that delete so you have to add the full loot again. For deleting one item only its:

DELETE FROM `creature_loot_template` WHERE `entry`=36597 AND `item`=51315;

- Entry is the id of the creature in this case lich king and the item is the unsealed chest 51315 (be carefull with items's ids please, you used 51316).

-- Dunno if there is a guide for adding loot, if not i will do one soon. And by the way adding loot for a boss is different that to normal npcs....

Regards.