From 7035a9caf12c72d6710bfec71dc2641eccf82eaf Mon Sep 17 00:00:00 2001 From: Gildor Date: Wed, 12 Aug 2020 17:24:41 +0200 Subject: Scripts/Naxxramas: Adjust Frogger event timer (#25214) * Scripts/Naxxramas: Adjust Frogger event timer Co-authored-by: Carbenium --- sql/updates/world/3.3.5/2020_08_12_01_world.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/3.3.5/2020_08_12_01_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2020_08_12_01_world.sql b/sql/updates/world/3.3.5/2020_08_12_01_world.sql new file mode 100644 index 00000000000..0f5ddaee20a --- /dev/null +++ b/sql/updates/world/3.3.5/2020_08_12_01_world.sql @@ -0,0 +1,6 @@ +-- Remove speed hack from Living Poison and disable movement flag updates for it +UPDATE `creature_template` SET `flags_extra`=`flags_extra`|512,`speed_run`= 1.42857 WHERE `entry`= 16027; +-- Delete unneeded spawn groups +DELETE FROM `creature_summon_groups` WHERE `summonerId`=16082 AND `summonerType`=0; +-- Delete unneeded waypoints +DELETE FROM `waypoint_data` WHERE `id` IN (160270,160271,160272); -- cgit v1.2.3