diff options
| author | Killyana <morphone1@gmail.com> | 2017-11-16 11:16:34 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2017-11-16 11:16:34 +0100 |
| commit | 459088ff65ff780d2513f55973415f3fb65c9bf8 (patch) | |
| tree | 63bc79301720745a376d422644d6ae3a4cf68824 | |
| parent | ea99801cd6ff687462df4fdbb69c06071dedfcf0 (diff) | |
DB/GameObject: Delete linked traps
Closes #17412
| -rw-r--r-- | sql/updates/world/master/2017_11_16_00_world.sql | 3 |
1 files changed, 3 insertions, 0 deletions
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); |