aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2018-02-08 22:26:58 +0100
committerKillyana <morphone1@gmail.com>2018-02-08 22:26:58 +0100
commit3acd9a7c4f7f4372b27f0e1a15c18b00435c9a03 (patch)
treedeb8a88ed1fb679198045892714d2684f66b10bc
parent23dd63da981c92e489bd6f2b53cb0ba777f84dbb (diff)
DB/Creature: Remove Tamed Sporebat spawns, summoned as pets by other npcs
-rw-r--r--sql/updates/world/3.3.5/2018_02_08_10_world.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_02_08_10_world.sql b/sql/updates/world/3.3.5/2018_02_08_10_world.sql
new file mode 100644
index 00000000000..ae24d4fd453
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_02_08_10_world.sql
@@ -0,0 +1,3 @@
+--
+DELETE FROM `creature` WHERE `id` IN (18201);
+DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (18201));