diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2018_04_04_01_world_335.sql | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_04_04_01_world_335.sql b/sql/updates/world/3.3.5/2018_04_04_01_world_335.sql new file mode 100644 index 00000000000..be714b22e58 --- /dev/null +++ b/sql/updates/world/3.3.5/2018_04_04_01_world_335.sql @@ -0,0 +1,36 @@ +-- Pathing for Scarlet Smith +UPDATE `creature` SET `position_x`=2990.86, `position_y`=-1458.58, `position_z`=146.273, `spawndist`=0, `MovementType`=2 WHERE `guid`=61634; + +DELETE FROM `creature_addon` WHERE `guid`=61634; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(61634,616340,0,0,1,0,""); + +DELETE FROM `waypoint_data` WHERE `id`=616340; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(616340,1,2990.86,-1458.58,146.273,0,0,0,0,100,0), +(616340,2,2978.03,-1450.18,145.989,0,0,0,0,100,0), +(616340,3,2962.46,-1452.65,145.716,0,0,0,0,100,0), +(616340,4,2963.32,-1464.52,145.592,0,0,0,0,100,0), +(616340,5,2973.34,-1468.99,145.754,0,0,0,0,100,0), +(616340,6,2974.3,-1475.57,145.509,0,0,0,0,100,0), +(616340,7,2974.67,-1484.54,146.999,0,0,0,0,100,0), +(616340,8,2975.15,-1490.23,147.022,0,0,0,0,100,0), +(616340,9,2984.02,-1491.19,147.042,6.18384,20000,0,616340,100,0), +(616340,10,2974.94,-1498.83,147.042,3.80251,20000,0,616340,100,0), +(616340,11,2978.95,-1500.69,146.999,0,0,0,0,100,0), +(616340,12,2979.92,-1509.63,145.319,0,0,0,0,100,0), +(616340,13,2996.73,-1508.11,146.204,0,0,0,0,100,0), +(616340,14,3004.9,-1514.71,145.967,0,0,0,0,100,0), +(616340,15,3005.29,-1522.01,146.069,0,0,0,0,100,0), +(616340,16,2992.68,-1516.82,146.041,0,0,0,0,100,0), +(616340,17,2996.49,-1507.15,146.152,0,0,0,0,100,0), +(616340,18,3004.37,-1496.56,146.397,0,0,0,0,100,0), +(616340,19,3005.32,-1481.19,145.908,0,0,0,0,100,0), +(616340,20,3008.27,-1470.62,146.531,0,0,0,0,100,0), +(616340,21,3002.19,-1461.06,146.273,0,0,0,0,100,0), +(616340,22,2998.02,-1460.04,145.81,0,0,0,0,100,0); + +DELETE FROM `waypoint_scripts` WHERE `id`=616340; +INSERT INTO `waypoint_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`, `guid`) VALUES +(616340,1,1,69,1,0,0,0,0,0,5), +(616340,18,1,0,1,0,0,0,0,0,6); |