diff options
| author | Rushor <PBienati@web.de> | 2016-02-10 20:45:16 +0100 |
|---|---|---|
| committer | Rushor <PBienati@web.de> | 2016-02-10 20:45:16 +0100 |
| commit | 43f245d4b763d7213e1cdd92206decc326578e05 (patch) | |
| tree | 52ec438cb6fd62b1521fc61b2c37204e515ac0e9 | |
| parent | b1ea3df5e42112c38d3cb09d2cf55838a4e96b72 (diff) | |
DB/Creature: Loot for NPC Tunneling Worm
* by Shoxxo, Killyana, tkrokli
* closes #14270
| -rw-r--r-- | sql/updates/world/2016_02_10_02_world.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/world/2016_02_10_02_world.sql b/sql/updates/world/2016_02_10_02_world.sql new file mode 100644 index 00000000000..967295f1fec --- /dev/null +++ b/sql/updates/world/2016_02_10_02_world.sql @@ -0,0 +1,15 @@ +-- DB/Creature: Loot for NPC Tunneling Worm +UPDATE `creature_template` SET `lootid`= 34865 WHERE `entry`= 34865; +DELETE FROM `creature_loot_template` WHERE `entry`= 34865; +INSERT INTO `creature_loot_template` (`entry`,`item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES +(34865, 55973, 0, 75, 0,1,0,1,1,'Tunneling Worm - Inert Elemental Speck'), +(34865, 55983, 0, 25, 0,1,0,1,1,'Tunneling Worm - Inert Elemental Scintilla'), +(34865, 805, 0, 0.5, 0,1,0,1,1,'Tunneling Worm - Small Red Pouch'), +(34865, 828, 0, 0.5, 0,1,0,1,1,'Tunneling Worm - Small Blue Pouch'), +(34865, 1411, 0, 0.5, 0,1,0,1,1,'Tunneling Worm - Withered Staff'), +(34865, 1431, 0, 0.5, 0,1,0,1,1,'Tunneling Worm - Patchwork Pants'), +(34865, 2589, 0, 0.5, 0,1,0,1,1,'Tunneling Worm - Linen Cloth'), +(34865, 4469, 0, 0.5, 0,1,0,1,1,'Tunneling Worm - Rod of Order - Quest item'), +(34865, 5571, 0, 0.5, 0,1,0,1,1,'Tunneling Worm - Small Black Pouch'), +(34865, 5572, 0, 0.5, 0,1,0,1,1,'Tunneling Worm - Small Green Pouch'), +(34865, 23333, 0, 0.5, 0,1,0,1,1,'Tunneling Worm - Shattered Power Core'); |