[Accepted][Legion] Elven Treasure Chest

[Tavari]

-- Elven Treasure Chest (http://www.wowhead.com/object=256790/elven-treasure-chest)
DELETE FROM `gameobject_loot_template` WHERE `entry`='256790';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`,`itembonuses`) VALUES
('256790', '139816', '18', '1', '0', '1', '1',''),
('256790', '140571', '17', '1', '0', '1', '1',''),
('256790', '141883', '11', '1', '0', '1', '1',''),
('256790', '139867', '11', '1', '0', '1', '1',''),
('256790', '140572', '9', '1', '0', '1', '1',''),
('256790', '139847', '5', '1', '0', '1', '1',''),
('256790', '139792', '5', '1', '0', '1', '1',''),
('256790', '140581', '5', '1', '0', '1', '1',''),
('256790', '139795', '4', '1', '0', '1', '1',''),
('256790', '140582', '1.6', '1', '0', '1', '1',''),
('256790', '139023', '0.5', '1', '0', '1', '1',''),
('256790', '139813', '0.3', '1', '0', '1', '1',''),
('256790', '138244', '117', '1', '0', '4', '10',''),
('256790', '138243', '86', '1', '0', '1', '1',''),
('256790', '138246', '84', '1', '0', '1', '3',''),
('256790', '138307', '67', '1', '0', '5', '5','')
('256790', '121413', '30', '1', '0', '1', '1',''),
('256790', '121387', '26', '1', '0', '1', '1',''),
('256790', '121415', '24', '1', '0', '1', '1',''),
('256790', '121396', '21', '1', '0', '1', '1',''),
('256790', '121404', '16', '1', '0', '1', '1',''),
('256790', '121406', '16', '1', '0', '1', '1',''),
('256790', '121376', '15', '1', '0', '1', '1',''),
('256790', '121395', '15', '1', '0', '1', '1',''),
('256790', '121412', '15', '1', '0', '1', '1',''),
('256790', '121391', '15', '1', '0', '1', '1',''),
('256790', '121394', '15', '1', '0', '1', '1',''),
('256790', '121400', '15', '1', '0', '1', '1',''),
('256790', '121414', '15', '1', '0', '1', '1',''),
('256790', '121410', '14', '1', '0', '1', '1',''),
('256790', '121397', '14', '1', '0', '1', '1',''),
('256790', '121392', '14', '1', '0', '1', '1',''),
('256790', '121403', '14', '1', '0', '1', '1',''),
('256790', '121411', '14', '1', '0', '1', '1',''),
('256790', '121398', '13', '1', '0', '1', '1',''),
('256790', '121384', '12', '1', '0', '1', '1',''),
('256790', '121407', '12', '1', '0', '1', '1',''),
('256790', '121409', '12', '1', '0', '1', '1',''),
('256790', '121405', '11', '1', '0', '1', '1',''),
('256790', '121393', '11', '1', '0', '1', '1',''),
('256790', '121399', '10', '1', '0', '1', '1',''),
('256790', '121390', '9', '1', '0', '1', '1',''),
('256790', '121388', '9', '1', '0', '1', '1',''),
('256790', '121389', '7', '1', '0', '1', '1',''),
('256790', '121402', '6', '1', '0', '1', '1',''),
('256790', '138250', '3', '1', '0', '1', '1',''),
('256790', '138242', '3', '1', '0', '1', '1',''),
('256790', '121386', '2', '1', '0', '1', '1','')
('256790', '121385', '2', '1', '0', '1', '1',''),
('256790', '138249', '2', '1', '0', '1', '1',''),
('256790', '138245', '1.3', '1', '0', '1', '3',''),
('256790', '121401', '0.8', '1', '0', '1', '1',''),
('256790', '138247', '0.5', '1', '0', '1', '1',''),
('256790', '138251', '0.3', '1', '0', '5', '5',''),
('256790', '121408', '0.3', '1', '0', '1', '1',''),
('256790', '138248', '0.3', '1', '0', '1', '1','');
UPDATE `gameobject_template` SET `data1`='256790' WHERE `entry`='256790';

 

[Misahky]

Greetings!

Thanks for submitting this patch.

The patch itself looks good but there's an issue which makes it unable to execute.

• Never forget any comma.

 

Patch applied on next restart  / crash.

 

Regards,

Misahky

Database Developer