[Accepted]Ironbranch

[Fyriond]

--http://www.wowhead.com/npc=93030/ironbranch
--no herbalism_loot included
DELETE FROM `creature_loot_template` WHERE `entry`=93030;
UPDATE `creature_template` SET `lootid`='93030' WHERE `entry`='93030';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`)
VALUES
('93030', '121177', '0.9', '1', '0', '1', '1', ''),
('93030', '121217', '0.7', '1', '0', '1', '1', ''),
('93030', '121213', '0.4', '1', '0', '1', '1', ''),
('93030', '121218', '0.4', '1', '0', '1', '1', ''),
('93030', '121209', '0.4', '1', '0', '1', '1', ''),
('93030', '138817', '0.4', '1', '0', '1', '1', ''),
('93030', '121208', '0.3', '1', '0', '1', '1', ''),
('93030', '121210', '0.13', '1', '0', '1', '1', ''),
('93030', '121214', '0.07', '1', '0', '1', '1', ''),
('93030', '132204', '83', '1', '0', '1', '1', ''),
('93030', '132223', '29', '1', '0', '1', '1', ''),
('93030', '132219', '6', '1', '0', '1', '1', ''),
('93030', '132199', '5', '1', '0', '1', '1', ''),
('93030', '124437', '3', '1', '0', '1', '3', ''),
('93030', '121340', '0.7', '1', '0', '1', '1', ''),
('93030', '138781', '0.4', '1', '0', '1', '1', ''),
('93030', '121365', '0.4', '1', '0', '1', '1', ''),
('93030', '121336', '0.3', '1', '0', '1', '1', ''),
('93030', '121341', '0.13', '1', '0', '1', '1', ''),
('93030', '121370', '0.13', '1', '0', '1', '1', '');

 

[Misahky]

Hello!

Thanks for your patch but there are errors in it:

• Make sure to leave a space after -- else it will cause an error.
• The column itembonuses has been removed.

 

The correct patch would look like this:

UPDATE `creature_template` SET `lootid`=93030 WHERE `entry`=93030;
DELETE FROM `creature_loot_template` WHERE `entry`=93030;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(93030, 121171, 0.05, 1, 0, 1, 1) /* Kal'delar Pauldrons */, 
(93030, 121177, 0.69, 1, 0, 1, 1) /* Vale Walker's Cloak */, 
(93030, 121186, 0.05, 1, 0, 1, 1) /* Smolderhide Hood */, 
(93030, 121205, 0.05, 1, 0, 1, 1) /* Dreadroot Linked Belt */, 
(93030, 121208, 0.21, 1, 0, 1, 1) /* Dreadroot Linked Greaves */, 
(93030, 121209, 0.37, 1, 0, 1, 1) /* Dreadroot Linked Helm */, 
(93030, 121210, 0.16, 1, 0, 1, 1) /* Dreadroot Linked Legguards */, 
(93030, 121211, 0.05, 1, 0, 1, 1) /* Dreadroot Linked Spaulders */, 
(93030, 121213, 0.37, 1, 0, 1, 1) /* Crescent Vale Cord */, 
(93030, 121214, 0.05, 1, 0, 1, 1) /* Crescent Vale Cowl */, 
(93030, 121217, 0.69, 1, 0, 1, 1) /* Crescent Vale Robe */, 
(93030, 121218, 0.42, 1, 0, 1, 1) /* Crescent Vale Sandals */, 
(93030, 121341, 0.16, 1, 0, 1, 1) /* Robble's Staff of Discourse */, 
(93030, 121350, 0.05, 1, 0, 1, 1) /* Rust-Encrusted Leggings */, 
(93030, 121365, 0.32, 1, 0, 1, 1) /* Warped-Plate Leggings */, 
(93030, 121370, 0.11, 1, 0, 1, 1) /* Warped-Plate Stompers */, 
(93030, 124437, 3, 1, 0, 1, 3) /* Shal'dorei Silk */, 
(93030, 132199, 5, 1, 0, 1, 1) /* Congealed Felblood */, 
(93030, 132200, 0.9, 1, 0, 1, 1) /* Ashen Ring */, 
(93030, 132204, 83, 1, 0, 1, 1) /* Sticky Volatile Substance */, 
(93030, 132219, 6, 1, 0, 1, 1) /* Opposable Leaf */, 
(93030, 132223, 29, 1, 0, 1, 1) /* Elemental Droplet */, 
(93030, 138781, 0.53, 1, 0, 1, 1) /* Brief History of the Aeons */, 
(93030, 138782, 0.05, 1, 0, 1, 1) /* Brief History of the Ages */, 
(93030, 138817, 0.32, 1, 0, 1, 1) /* Demonic Runestone */, 
(93030, 140222, 0.05, 1, 0, 1, 1) /* Harvested Goods */, 
(93030, 141291, 0.05, 1, 0, 1, 1) /* Shala'nir Sproutling */;

 

Its corrected and applied with next update.

 

Regards,

Misahky