diff options
| -rw-r--r-- | sql/updates/world/2015_05_09_04_world_335.sql | 34 |
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); |