From a256f948514c130726874b6020689dcdb3676fe3 Mon Sep 17 00:00:00 2001
From: SnapperRy <snapperryen@gmail.com>
Date: Mon, 3 Oct 2016 13:34:57 +0200
Subject: DB/Creature: remove loot and experience for Webbed Creature.

(cherry picked from commit a01f7ad47067af36184c6758401c5fc1b0ade571)
---
 sql/updates/world/master/2017_03_04_28_world_2016_10_03_00_world.sql | 3 +++
 1 file changed, 3 insertions(+)
 create mode 100644 sql/updates/world/master/2017_03_04_28_world_2016_10_03_00_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/master/2017_03_04_28_world_2016_10_03_00_world.sql b/sql/updates/world/master/2017_03_04_28_world_2016_10_03_00_world.sql
new file mode 100644
index 00000000000..68fd91a2096
--- /dev/null
+++ b/sql/updates/world/master/2017_03_04_28_world_2016_10_03_00_world.sql
@@ -0,0 +1,3 @@
+--
+UPDATE `creature_template` SET `lootid`=0, `flags_extra`=`flags_extra`|0x40 WHERE `entry`=17680;
+DELETE FROM `creature_loot_template` WHERE `entry`=17680;
-- 
cgit v1.2.3