diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2025_02_07_01_world.sql | 58 |
1 files changed, 58 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2025_02_07_01_world.sql b/sql/updates/world/3.3.5/2025_02_07_01_world.sql new file mode 100644 index 00000000000..135844efac3 --- /dev/null +++ b/sql/updates/world/3.3.5/2025_02_07_01_world.sql @@ -0,0 +1,58 @@ +-- Pathing for Mirelow Entry: 14424 +SET @NPC=14424; +SET @GUID=91113; +SET @PATH=@GUID * 10; +DELETE FROM `creature` WHERE `id` = @NPC AND `guid` != (@GUID); +DELETE FROM `pool_template` WHERE `entry`=@NPC; +DELETE FROM `pool_members` WHERE `Type`=0 AND `poolSpawnId`=1072; +UPDATE `creature` SET `position_x`=-2752.9434,`position_y`=-1311.9869,`position_z`=6.144358,`wander_distance`=0,`MovementType`=2 WHERE `id`=@NPC AND `guid`=@GUID; +UPDATE `creature_template` SET `MovementType`=2,`speed_walk`=1 WHERE `entry`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `MountCreatureID`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvPFlags`, `emote`, `visibilityDistanceType`, `auras`) VALUES +(@GUID, @PATH, 0, 0, 0, 0, 0, 1, 0, 0, 0, NULL); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(@PATH, 1, -2752.9434, -1311.9869, 6.144358, NULL, 0, 0, 0, 100, 0), +(@PATH, 2, -2779.3325, -1318.1886, 6.212498, NULL, 0, 0, 0, 100, 0), +(@PATH, 3, -2802.5144, -1327.2316, 6.2124987, NULL, 0, 0, 0, 100, 0), +(@PATH, 4, -2841.5269, -1356.3691, 6.2124963, NULL, 0, 0, 0, 100, 0), +(@PATH, 5, -2868.5942, -1383.6816, 6.2125034, NULL, 0, 0, 0, 100, 0), +(@PATH, 6, -2888.584, -1418.0055, 6.2125034, NULL, 0, 0, 0, 100, 0), +(@PATH, 7, -2915.9563, -1455.4119, 6.2125106, NULL, 0, 0, 0, 100, 0), +(@PATH, 8, -2948.1558, -1477.9122, 6.2125034, NULL, 0, 0, 0, 100, 0), +(@PATH, 9, -2979.6265, -1493.0153, 6.2125106, NULL, 0, 0, 0, 100, 0), +(@PATH, 10, -3007.2742, -1519.1643, 6.1943064, NULL, 0, 0, 0, 100, 0), +(@PATH, 11, -3030.377, -1531.1482, 1.8713083, NULL, 0, 0, 0, 100, 0), +(@PATH, 12, -3050.034, -1538.9908, 2.2948234, NULL, 0, 0, 0, 100, 0), +(@PATH, 13, -3068.111, -1529.2074, 4.6410594, NULL, 0, 0, 0, 100, 0), +(@PATH, 14, -3048.722, -1507.4395, 2.3030105, NULL, 0, 0, 0, 100, 0), +(@PATH, 15, -3045.1477, -1488.9481, 6.1078167, NULL, 0, 0, 0, 100, 0), +(@PATH, 16, -3037.5547, -1465.8003, 6.2125444, NULL, 0, 0, 0, 100, 0), +(@PATH, 17, -3013.2668, -1444.2893, 6.2125444, NULL, 0, 0, 0, 100, 0), +(@PATH, 18, -2992.2075, -1423.2106, 6.2125444, NULL, 0, 0, 0, 100, 0), +(@PATH, 19, -2982.6704, -1384.7448, 6.2125444, NULL, 0, 0, 0, 100, 0), +(@PATH, 20, -2976.297, -1355.0217, 6.1414337, NULL, 0, 0, 0, 100, 0), +(@PATH, 21, -2972.429, -1315.0929, 6.212561, NULL, 0, 0, 0, 100, 0), +(@PATH, 22, -2959.098, -1289.4697, 6.212534, NULL, 0, 0, 0, 100, 0), +(@PATH, 23, -2946.3533, -1262.2607, 6.212534, NULL, 0, 0, 0, 100, 0), +(@PATH, 24, -2940.9849, -1235.0204, 6.212534, NULL, 0, 0, 0, 100, 0), +(@PATH, 25, -2927.3582, -1214.3258, 6.276264, NULL, 0, 0, 0, 100, 0), +(@PATH, 26, -2913.8328, -1184.8007, 6.2125435, NULL, 0, 0, 0, 100, 0), +(@PATH, 27, -2913.718, -1156.6484, 6.380024, NULL, 0, 0, 0, 100, 0), +(@PATH, 28, -2906.6707, -1130.346, 6.3375435, NULL, 0, 0, 0, 100, 0), +(@PATH, 29, -2924.4268, -1129.007, 6.262104, NULL, 0, 0, 0, 100, 0), +(@PATH, 30, -2948.263, -1141.3658, 6.581269, NULL, 0, 0, 0, 100, 0), +(@PATH, 31, -2981.483, -1160.7555, 6.2125306, NULL, 0, 0, 0, 100, 0), +(@PATH, 32, -3008.991, -1189.4165, 6.3375306, NULL, 0, 0, 0, 100, 0), +(@PATH, 33, -3033.5713, -1223.1588, 3.6263075, NULL, 0, 0, 0, 100, 0), +(@PATH, 34, -3058.1658, -1243.8303, 6.385656, NULL, 0, 0, 0, 100, 0), +(@PATH, 35, -3084.6208, -1262.775, 6.2125497, NULL, 0, 0, 0, 100, 0), +(@PATH, 36, -3110.9539, -1251.6007, 5.657193, NULL, 0, 0, 0, 100, 0), +(@PATH, 37, -3127.4268, -1279.7166, 6.2125597, NULL, 0, 0, 0, 100, 0), +(@PATH, 38, -3140.0647, -1310.3094, 6.2125597, NULL, 0, 0, 0, 100, 0), +(@PATH, 39, -3129.7153, -1336.1788, 6.2125444, NULL, 0, 0, 0, 100, 0), +(@PATH, 40, -3135.3235, -1368.5166, 6.2125444, NULL, 0, 0, 0, 100, 0), +(@PATH, 41, -3156.5852, -1393.152, 6.2125444, NULL, 0, 0, 0, 100, 0), +(@PATH, 42, -3176.052, -1410.8157, 6.2125344, NULL, 0, 0, 0, 100, 0), +(@PATH, 43, -3184.6921, -1435.9547, 6.2125344, NULL, 0, 0, 0, 100, 0), +(@PATH, 44, -3201.1177, -1461.5942, 6.2125344, NULL, 0, 0, 0, 100, 0); |