From 328f6f48732af669de53175dd366958c89f25335 Mon Sep 17 00:00:00 2001 From: Killyana Date: Thu, 8 Feb 2018 22:26:58 +0100 Subject: DB/Creature: Remove Tamed Sporebat spawns, summoned as pets by other npcs (cherry picked from commit 3acd9a7c4f7f4372b27f0e1a15c18b00435c9a03) --- sql/updates/world/master/2021_06_19_14_world_2018_02_08_10_world.sql | 3 +++ 1 file changed, 3 insertions(+) create mode 100644 sql/updates/world/master/2021_06_19_14_world_2018_02_08_10_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2021_06_19_14_world_2018_02_08_10_world.sql b/sql/updates/world/master/2021_06_19_14_world_2018_02_08_10_world.sql new file mode 100644 index 00000000000..ae24d4fd453 --- /dev/null +++ b/sql/updates/world/master/2021_06_19_14_world_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)); -- cgit v1.2.3