DB/Misc: Remove Midsummer Double Spawns

By sirikfoll, closes #14623

1 files changed, 34 insertions, 0 deletions

diff --git a/sql/updates/world/2015_05_09_04_world_335.sql b/sql/updates/world/2015_05_09_04_world_335.sql
new file mode 100644
index 00000000000..814459be957
--- /dev/null
+++ b/sql/updates/world/2015_05_09_04_world_335.sql
@@ -0,0 +1,34 @@
+-- Remove Midsummer Double Spawns
+DELETE FROM `creature` WHERE (`guid` IN (94696,94723,94698,94724) AND `id`=16781) OR (`guid`=94513 AND `id`=25994);-- Tanaris Horde
+DELETE FROM `creature` WHERE (`guid` IN (94735,94734,94716,94733) AND `id`=16781) OR (`guid`=86895 AND `id`=25962);-- Tanaris Alliance
+DELETE FROM `creature` WHERE (`guid` IN (94710,94656,94711,94694) AND `id`=16781) OR (`guid`=94518 AND `id`=25994);-- Stranglethorn Horde
+DELETE FROM `creature` WHERE (`guid` IN (94553,94551,94554,94555) AND `id`=16781) OR (`guid`=86711 AND `id`=25962);-- Stranglethorn Alliance
+DELETE FROM `creature` WHERE (`guid` IN (94557,94605,94556,94704) AND `id`=16781) OR (`guid`=90490 AND `id`=25962);-- Arathi Alliance
+DELETE FROM `creature` WHERE (`guid` IN (94649,94738,94700,94579) AND `id`=16781) OR (`guid`=86704 AND `id`=25962);-- Silithus Alliance
+DELETE FROM `creature` WHERE `guid` IN (202858,202859,202860,202861) AND `id`=16781;-- Ironforge
+DELETE FROM `creature` WHERE `guid`=202862 AND `id`=16817;
+DELETE FROM `creature` WHERE `guid`=202863 AND `id`=25975;
+DELETE FROM `creature` WHERE `guid`=86165 AND `id`=26123;
+
+DELETE FROM `game_event_creature` WHERE `eventEntry`=1 AND `guid` IN (94696,94723,94698,94724,94513);
+DELETE FROM `game_event_creature` WHERE `eventEntry`=1 AND `guid` IN (94735,94734,94716,94733,86895);
+DELETE FROM `game_event_creature` WHERE `eventEntry`=1 AND `guid` IN (94710,94656,94711,94694,94518);
+DELETE FROM `game_event_creature` WHERE `eventEntry`=1 AND `guid` IN (94553,94551,94554,94555,86711);
+DELETE FROM `game_event_creature` WHERE `eventEntry`=1 AND `guid` IN (94557,94605,94556,94704,90490);
+DELETE FROM `game_event_creature` WHERE `eventEntry`=1 AND `guid` IN (94649,94738,94700,94579,86704);
+DELETE FROM `game_event_creature` WHERE `eventEntry`=1 AND `guid` IN (202858,202859,202860,202861,202862,202863,86165);
+
+DELETE FROM `gameobject` WHERE `guid` IN (51596,52357,50996,50855,50750,50747,52277,52467,51350,50692,52548,52284,51349);-- Tanaris horde
+DELETE FROM `gameobject` WHERE `guid` IN (52273,52527,52275,50683,51343,52272,52279,50994,50854,50710,52466,50709,51342);-- Tanaris Alliance
+DELETE FROM `gameobject` WHERE `guid` IN (51791,50690,52560,52333,52329,52511,50740,50741,50869,52399,52334);-- Stranglethorn horde
+DELETE FROM `gameobject` WHERE `guid` IN (52393,52541,50682,51782,52325,51028,51797,51798,50784,50871,50785,51545,52331,52509); -- Stranglethorn Alliance
+DELETE FROM `gameobject` WHERE `guid` IN (52335,51814,52409,51573,51014,51554,51579,51981,52412,52407,51578,50931,52481,52542,50836,51580,50553,51820,50802,50897,50803); -- Arathi Alliance
+DELETE FROM `gameobject` WHERE `guid` IN (52344,50991,50743,50852,52463,50679,52267,52526);-- Silithus Alliance
+DELETE FROM `gameobject` WHERE `guid`=49313;-- Silithus Horde
+
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=1 AND `guid` IN (51596,52357,50996,50855,50750,50747,52277,52467,51350,50692,52548,52284,51349);
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=1 AND `guid` IN (52273,52527,52275,50683,51343,52272,52279,50994,50854,50710,52466,50709,51342);
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=1 AND `guid` IN (51791,50690,52560,52333,52329,52511,50740,50741,50869,52399,52334);
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=1 AND `guid` IN (52393,52541,50682,51782,52325,51028,51797,51798,50784,50871,50785,51545,52331,52509);
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=1 AND `guid` IN (52335,51814,52409,51573,51014,51554,51579,51981,52412,52407,51578,50931,52481,52542,50836,51580,50553,51820,50802,50897,50803);
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=1 AND `guid` IN (52344,50991,50743,50852,52463,50679,52267,52526);