From 3acd9a7c4f7f4372b27f0e1a15c18b00435c9a03 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 --- sql/updates/world/3.3.5/2018_02_08_10_world.sql | 3 +++ 1 file changed, 3 insertions(+) create mode 100644 sql/updates/world/3.3.5/2018_02_08_10_world.sql (limited to 'sql') 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)); -- cgit v1.2.3