aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorGildor <gildor55@gmail.com>2020-08-12 17:24:41 +0200
committerGitHub <noreply@github.com>2020-08-12 17:24:41 +0200
commit7035a9caf12c72d6710bfec71dc2641eccf82eaf (patch)
tree521380f8d65f3c4d5a9a53e2ba127d59b252c72b /sql
parenta375f15ae26472202daf02c88d292f2ce6a1470f (diff)
Scripts/Naxxramas: Adjust Frogger event timer (#25214)
* Scripts/Naxxramas: Adjust Frogger event timer Co-authored-by: Carbenium <carbenium@outlook.com>
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/3.3.5/2020_08_12_01_world.sql6
1 files changed, 6 insertions, 0 deletions
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);