From ad8bad95c4d95cb09f017667df3dca47a994fe05 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Mon, 15 May 2023 07:28:06 +0200 Subject: DB/Creature: Add random movement to Thelsamar Mountaineers closes #28984 by CraftedRO --- sql/updates/world/3.3.5/2023_05_15_00_world.sql | 23 +++++++++++++++++++++++ 1 file changed, 23 insertions(+) create mode 100644 sql/updates/world/3.3.5/2023_05_15_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2023_05_15_00_world.sql b/sql/updates/world/3.3.5/2023_05_15_00_world.sql new file mode 100644 index 00000000000..84e0462615f --- /dev/null +++ b/sql/updates/world/3.3.5/2023_05_15_00_world.sql @@ -0,0 +1,23 @@ +-- Add random movement +-- Mountaineer Swarth +UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8233 AND `id` = 2518; +-- Mountaineer Harn +UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8239 AND `id` = 2506; +-- Mountaineer Roghan +UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8306 AND `id` = 2512; +-- Mountaineer Fazgard +UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8238 AND `id` = 2515; +-- Mountaineer Janha +UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8237 AND `id` = 2513; +-- Mountaineer Cragg +UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8234 AND `id` = 2509; +-- Mountaineer Wuar +UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8240 AND `id` = 2508; +-- Mountaineer Dalk +UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8235 AND `id` = 1338; +-- Mountaineer Uthan +UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8302 AND `id` = 2507; +-- Mountaineer Bludd +UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8303 AND `id` = 2511; +-- Mountaineer Ozmok +UPDATE `creature` SET `wander_distance` = 5, `MovementType` = 1 WHERE `guid` = 8745 AND `id` = 2510; -- cgit v1.2.3