aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorJinnaix <Jinnaix@users.noreply.github.com>2020-03-16 22:57:23 +0100
committerKillyana <morphone1@gmail.com>2020-03-16 22:57:23 +0100
commit365ec7b28e023625ae84859c42b2d32ce3a4317a (patch)
treef0a2500e190efbbad276cccac5d5fefa6c5db3ed
parent28e83a9fee7082671ff5e0bfef4e6ed6fe56261f (diff)
DB/Creature: Remove Defias Companion as summoned via spell as pet
Ref #24314
-rw-r--r--sql/updates/world/3.3.5/2020_03_16_12_world.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_03_16_12_world.sql b/sql/updates/world/3.3.5/2020_03_16_12_world.sql
new file mode 100644
index 00000000000..aa61a597456
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_03_16_12_world.sql
@@ -0,0 +1,3 @@
+--
+DELETE FROM `creature` WHERE `guid` IN (79288,79291,79295,79317,79318,79332,79342,79350,79356,79358,79389) AND `id`=3450;
+DELETE FROM `linked_respawn` WHERE `guid` IN (79288,79291,79295,79317,79318,79332,79342,79350,79356,79358,79389);