From f8cba63eb7044ed95f8b8f2fdcf0bb53abf93642 Mon Sep 17 00:00:00 2001 From: Killyana Date: Wed, 10 Jul 2019 18:35:14 +0200 Subject: DB: Remove old spawns --- sql/updates/world/master/2019_07_10_01_world.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/master/2019_07_10_01_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2019_07_10_01_world.sql b/sql/updates/world/master/2019_07_10_01_world.sql new file mode 100644 index 00000000000..a6a7e97b06d --- /dev/null +++ b/sql/updates/world/master/2019_07_10_01_world.sql @@ -0,0 +1,5 @@ +-- +DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `map` IN (648) AND `guid`<389369); +DELETE FROM `creature` WHERE `map` IN (648) AND `guid`<389369; +DELETE FROM `gameobject_addon` WHERE `guid` IN (SELECT `guid` FROM `gameobject` WHERE `map` IN (648) AND `guid`<238547); +DELETE FROM `gameobject` WHERE `map` IN (648) AND `guid`<238547; -- cgit v1.2.3