aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2020-05-21 01:29:29 +0200
committerShauren <shauren.trinity@gmail.com>2022-01-06 16:05:56 +0100
commita4016b9767bfd97867cabe4c7db4ed01eec8e983 (patch)
tree46c574cff3492b934d4973cc50985920ec559800
parent070da4f7111b8295d88af2bf513906a5ec28b1a0 (diff)
DB/Loot: Remove loot from creature Water Terror
Closes #24671 (cherry picked from commit abd8140681c007a110a78ccb97a5677816bb94ba)
-rw-r--r--sql/updates/world/master/2022_01_06_12_world_2020_05_20_02_world.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_06_12_world_2020_05_20_02_world.sql b/sql/updates/world/master/2022_01_06_12_world_2020_05_20_02_world.sql
new file mode 100644
index 00000000000..768f9fccd0c
--- /dev/null
+++ b/sql/updates/world/master/2022_01_06_12_world_2020_05_20_02_world.sql
@@ -0,0 +1,3 @@
+-- Only one item added due to bad sorting
+DELETE FROM `creature_loot_template` WHERE `entry` = 30633;
+UPDATE `creature_template` SET `lootid` = 0 WHERE `entry` = 30633;