From 459088ff65ff780d2513f55973415f3fb65c9bf8 Mon Sep 17 00:00:00 2001 From: Killyana Date: Thu, 16 Nov 2017 11:16:34 +0100 Subject: DB/GameObject: Delete linked traps Closes #17412 --- sql/updates/world/master/2017_11_16_00_world.sql | 3 +++ 1 file changed, 3 insertions(+) create mode 100644 sql/updates/world/master/2017_11_16_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2017_11_16_00_world.sql b/sql/updates/world/master/2017_11_16_00_world.sql new file mode 100644 index 00000000000..2016c94c366 --- /dev/null +++ b/sql/updates/world/master/2017_11_16_00_world.sql @@ -0,0 +1,3 @@ +-- +DELETE FROM `gameobject_addon` WHERE `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` IN (208046, 19535, 209282, 208815, 202361, 185600, 181583, 181584, 182582, 182585, 183768, 184078, 184124, 184736, 184794, 184797, 184801, 184835, 184868, 184871, 184872, 185878, 183386, 183997, 19535, 185018, 184578, 184265, 181913, 186431, 190661, 185563, 201368, 178984, 209282, 177606, 177045, 186330, 176591, 176865, 201593, 208815, 195346, 202361, 180583,2061,2066,31442,179900,184843,191485,191370,190195,181376,203449, 178187, 178188, 178189, 178190, 178191, 178192, 178193)); +DELETE FROM `gameobject` WHERE `id` IN (208046, 19535, 209282, 208815, 202361, 185600, 181583, 181584, 182582, 182585, 183768, 184078, 184124, 184736, 184794, 184797, 184801, 184835, 184868, 184871, 184872, 185878, 183386, 183997, 19535, 185018, 184578, 184265, 181913, 186431, 190661, 185563, 201368, 178984, 209282, 177606, 177045, 186330, 176591, 176865, 201593, 208815, 195346, 202361, 180583,2061,2066,31442,179900,184843,191485,191370,190195,181376,203449, 178187, 178188, 178189, 178190, 178191, 178192, 178193); -- cgit v1.2.3