[WoD] Dread Ship Vazuvius drop

[Csabikaa97]

Dread Ship Vazuvius items drops and rates fix.

 

source: http://www.wowhead.com/npc=73281/dread-ship-vazuvius

I skipped some items that are not working in firestorm like: http://www.wowhead.com/item=102318 ( Tested on Grommash 2015/dec/03 ) 

 

DELETE FROM `creature_loot_template` WHERE `entry`='67071';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES 
(67071, 105715, 64, 1, 0, 1, 3),
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES 
(67071, 104294, 14, 1, 0, 1, 1),
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES 
(67071, 103982, 4, 1, 0, 1, 1),

 

[Hypnos]

If you arent going to add the full loot, you try to dont use delete because you can delete any item which drops nowdays.You use "replace into" instead if you want only to add any item in the loot.

Fields used in every loot table are : `entry`,`item`,`chanceorquestchance`,`lootmode`,`groupid`,`mincountorref`,`maxcount`,`itembonuses`.

Every query finishs with a semicolon ;

In item 105715 the maxcount is 1 instead of 3, be carefull with it.

And you can add the 3 items with 1 query:

REPLACE INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`,`itembonuses`) VALUES 
(67071, 105715, 64, 1, 0, 1, 1,''),
(67071, 104294, 14, 1, 0, 1, 1,''),
(67071, 103982, 4, 1, 0, 1, 1,'');

Thanks you for the patch, it will be added in the next updates.