DB/Creature: Add loot to some low level creatures

By Malcrom

1 files changed, 26 insertions, 0 deletions

diff --git a/sql/updates/world/master/2017_11_07_01_world.sql b/sql/updates/world/master/2017_11_07_01_world.sql
new file mode 100644
index 00000000000..464da9c5088
--- /dev/null
+++ b/sql/updates/world/master/2017_11_07_01_world.sql
@@ -0,0 +1,26 @@
+-- Blackrock Worg
+SET @ENTRY := 49871;
+UPDATE `creature_template` SET `lootid`=@ENTRY, `mingold`=0, `maxgold`=0 WHERE `entry`=@ENTRY;
+DELETE FROM `creature_loot_template` WHERE `Entry`=@ENTRY;
+INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES
+(@ENTRY,62328,0,90,0,1,0,1,1, 'Shed Fur'),
+(@ENTRY,3300,0,10,0,1,0,1,1, 'Rabbits Foot');
+
+-- Gug Fatcandle
+SET @ENTRY := 62;
+UPDATE `creature_template` SET `lootid`=@ENTRY, `mingold`=1, `maxgold`=8 WHERE `entry`=@ENTRY;
+DELETE FROM `creature_loot_template` WHERE `Entry`=@ENTRY;
+INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES
+(@ENTRY,56147,0,100,0,1,0,1,1, 'Fatcandle Bag');
+
+-- Blackrock Invader
+SET @ENTRY := 42937;
+UPDATE `creature_template` SET `lootid`=@ENTRY, `mingold`=1, `maxgold`=5 WHERE `entry`=@ENTRY;
+DELETE FROM `creature_loot_template` WHERE `Entry`=@ENTRY;
+INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES
+(@ENTRY,58361,0,100,1,1,0,1,1, 'Blackrock Orc Weapon'),
+(@ENTRY,117,0,1,0,1,1,1,1, 'Tough Jerky');
+
+-- Kurtok the Slayer
+SET @ENTRY := 42938;
+UPDATE `creature_template` SET `lootid`=0, `mingold`=1, `maxgold`=5 WHERE `entry`=@ENTRY;