aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/3.3.5/2024_10_26_00_world.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_10_26_00_world.sql b/sql/updates/world/3.3.5/2024_10_26_00_world.sql
new file mode 100644
index 00000000000..31d5d1c2af7
--- /dev/null
+++ b/sql/updates/world/3.3.5/2024_10_26_00_world.sql
@@ -0,0 +1,7 @@
+-- Stormwind Guard movement update
+SET @GUID=79875;
+SET @PATH=@GUID * 10;
+
+UPDATE `creature` SET `MovementType`=0 WHERE `guid`=@GUID;
+UPDATE `creature_addon` SET `path_id`=0 WHERE `guid`=@GUID AND `path_id`=@PATH;
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;