aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2025-01-10 21:22:28 +0100
committerOvahlord <dreadkiller@gmx.de>2025-01-10 22:47:14 +0100
commit2693d73383d46240f9726123ddab8c80c37533d8 (patch)
tree401ecc02aaf63945efc5ff1dae95808e78125785 /sql
parent4bc721aa25487ef55f7ee31b504d717f958e4276 (diff)
Core/AreaTriggers: Replace fixed movement times in database for areatriggers with speed
(cherry picked from commit 069771e22ef29e47298c62e6cb9d7dce72375348) # Conflicts: # sql/updates/world/cata_classic/2025_01_10_00_world.sql # src/server/game/Entities/AreaTrigger/AreaTrigger.cpp # src/server/scripts/BrokenIsles/MawOfSouls/boss_ymiron_the_fallen_king.cpp # src/server/scripts/Shadowlands/SepulcherOfTheFirstOnes/boss_anduin_wrynn.cpp # src/server/scripts/Spells/spell_priest.cpp # src/server/scripts/World/areatrigger_scripts.cpp
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/cata_classic/2025_01_10_01_world_2025_01_10_00_world.sql17
1 files changed, 17 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2025_01_10_01_world_2025_01_10_00_world.sql b/sql/updates/world/cata_classic/2025_01_10_01_world_2025_01_10_00_world.sql
new file mode 100644
index 00000000000..df38842bcfe
--- /dev/null
+++ b/sql/updates/world/cata_classic/2025_01_10_01_world_2025_01_10_00_world.sql
@@ -0,0 +1,17 @@
+ALTER TABLE `areatrigger_create_properties`
+ DROP `TimeToTarget`,
+ ADD `Speed` float NOT NULL DEFAULT 1 AFTER `TimeToTargetScale`;
+
+UPDATE `areatrigger_create_properties` SET `Speed`=40 WHERE `Id`=1315 AND `IsCustom`=0;
+UPDATE `areatrigger_create_properties` SET `Speed`=40 WHERE `Id`=1316 AND `IsCustom`=0;
+UPDATE `areatrigger_create_properties` SET `Speed`=20 WHERE `Id`=1612 AND `IsCustom`=0;
+UPDATE `areatrigger_create_properties` SET `Speed`=26 WHERE `Id`=2148 AND `IsCustom`=0;
+UPDATE `areatrigger_create_properties` SET `Speed`=6.5 WHERE `Id`=5838 AND `IsCustom`=0;
+UPDATE `areatrigger_create_properties` SET `Speed`=7 WHERE `Id`=6887 AND `IsCustom`=0;
+UPDATE `areatrigger_create_properties` SET `Speed`=15 WHERE `Id`=8661 AND `IsCustom`=0;
+UPDATE `areatrigger_create_properties` SET `Speed`=5 WHERE `Id`=13339 AND `IsCustom`=0;
+UPDATE `areatrigger_create_properties` SET `Speed`=7 WHERE `Id`=13734 AND `IsCustom`=0;
+UPDATE `areatrigger_create_properties` SET `Speed`=18 WHERE `Id`=24322 AND `IsCustom`=0;
+UPDATE `areatrigger_create_properties` SET `Speed`=14 WHERE `Id`=24599 AND `IsCustom`=0;
+UPDATE `areatrigger_create_properties` SET `Speed`=15 WHERE `Id`=24740 AND `IsCustom`=0;
+UPDATE `areatrigger_create_properties` SET `Speed`=18 WHERE `Id`=24741 AND `IsCustom`=0;