aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--sql/updates/world/3.3.5/2017_01_20_07_world_335.sql118
1 files changed, 118 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_01_20_07_world_335.sql b/sql/updates/world/3.3.5/2017_01_20_07_world_335.sql
new file mode 100644
index 00000000000..26a64d9944e
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_01_20_07_world_335.sql
@@ -0,0 +1,118 @@
+-- Sentinell Hill - Westfall
+-- Lumberjack
+
+UPDATE `creature` SET spawndist = 0, MovementType = 2 WHERE guid IN (44296,45524,89861);
+UPDATE `creature_addon` SET `emote`=0 WHERE `guid`=89861;
+UPDATE `creature_addon` SET `emote`=0 WHERE `guid`=44296;
+UPDATE `creature_addon` SET `emote`=234 WHERE `guid`=45477;
+
+SET @MAXGUID := 923;
+SET @SCRIPTID := 4429600;
+DELETE FROM `waypoint_scripts` WHERE id BETWEEN @SCRIPTID AND @SCRIPTID+3;
+INSERT INTO `waypoint_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`, `guid`) VALUES
+(@SCRIPTID+0, 3, 32, 308, 0, 0, 0, 0, 0, 0, (@MAXGUID := @MAXGUID + 1)),
+(@SCRIPTID+1, 3, 1, 234, 1, 0, 0, 0, 0, 0, (@MAXGUID := @MAXGUID + 1)),
+(@SCRIPTID+1, 97, 1, 0, 1, 0, 0, 0, 0, 0, (@MAXGUID := @MAXGUID + 1)),
+(@SCRIPTID+1, 100, 32, 89, 0, 0, 0, 0, 0, 0, (@MAXGUID := @MAXGUID + 1)),
+(@SCRIPTID+2, 2, 32, 89, 0, 0, 0, 0, 0, 0, (@MAXGUID := @MAXGUID + 1)),
+(@SCRIPTID+3, 3, 1, 234, 1, 0, 0, 0, 0, 0, (@MAXGUID := @MAXGUID + 1)),
+(@SCRIPTID+3, 97, 1, 0, 1, 0, 0, 0, 0, 0, (@MAXGUID := @MAXGUID + 1));
+
+SET @NPC := 44296;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `orientation`, `delay`, `action`) VALUES
+(@PATH, 1, -10612.1, 1181.01, 34.5176, 5.11381, 5000, @SCRIPTID+2),
+(@PATH, 2, -10614.8, 1180.44, 34.0654, 3.56192, 0, 0),
+(@PATH, 3, -10625.5, 1172.63, 34.2415, 3.88393, 0, 0),
+(@PATH, 4, -10636.7, 1159.96, 33.615, 3.9664, 0, 0),
+(@PATH, 5, -10643.8, 1154.6, 33.3617, 3.49516, 0, 0),
+(@PATH, 6, -10651, 1152.99, 33.4886, 3.77555, 0, 0),
+(@PATH, 7, -10653.1, 1148.23, 33.7335, 4.94657, 0, 0),
+(@PATH, 8, -10649.3, 1141.3, 33.7097, 4.53648, 0, 0),
+(@PATH, 9, -10651.8, 1136.93, 34.2028, 3.85711, 0, 0),
+(@PATH, 10, -10660.2, 1128.05, 34.197, 4.53255, 0, 0),
+(@PATH, 11, -10660, 1124.38, 34.197, 5.25119, 0, 0),
+(@PATH, 12, -10657.3, 1121.95, 34.197, 5.90698, 0, 0),
+(@PATH, 13, -10654, 1120.34, 35.6411, 5.72634, 0, 0),
+(@PATH, 14, -10650.7, 1118.12, 35.6286, 5.67922, 6000, @SCRIPTID+0),
+(@PATH, 15, -10653.9, 1120.45, 35.6388, 2.69648, 0, 0),
+(@PATH, 16, -10657.1, 1122.31, 34.1967, 2.65721, 0, 0),
+(@PATH, 17, -10660.2, 1127.8, 34.1967, 1.20579, 0, 0),
+(@PATH, 18, -10657.3, 1132.13, 34.1967, 0.718843, 0, 0),
+(@PATH, 19, -10649.3, 1139.81, 33.7333, 1.45555, 0, 0),
+(@PATH, 20, -10650.1, 1143.1, 33.7355, 2.14591, 0, 0),
+(@PATH, 21, -10653, 1148.6, 33.737, 1.65425, 0, 0),
+(@PATH, 22, -10651.6, 1152.36, 33.527, 0.97881, 0, 0),
+(@PATH, 23, -10648.3, 1153.99, 33.4183, 0.24996, 0, 0),
+(@PATH, 24, -10643.1, 1154.56, 33.3588, 0.440811, 0, 0),
+(@PATH, 25, -10633.7, 1162.3, 34.1228, 0.952139, 0, 0),
+(@PATH, 26, -10625.3, 1172.88, 34.2107, 0.930148, 0, 0),
+(@PATH, 27, -10616.4, 1182.21, 33.7023, 0.34267, 0, 0),
+(@PATH, 28, -10612.1, 1181.01, 34.5176, 5.11381, 97000, @SCRIPTID+3);
+
+
+SET @NPC := 45524;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`, `orientation`, `action`) VALUES
+(@PATH, 1, -10628.2, 1125.08, 33.7849, 1.81801, 0, 0),
+(@PATH, 2, -10631.9, 1139.7, 33.7312, 1.72611, 0, 0),
+(@PATH, 3, -10629.8, 1152.02, 34.0399, 0.853538, 0, 0),
+(@PATH, 4, -10624.8, 1156.86, 34.5346, 0.460053, 0, 0),
+(@PATH, 5, -10597.5, 1160.64, 38.4133, 0.0390802, 103000, @SCRIPTID+1),
+(@PATH, 6, -10616, 1156.68, 35.1913, 3.432, 0, 0),
+(@PATH, 7, -10624.7, 1153.97, 34.3801, 3.68176, 0, 0),
+(@PATH, 8, -10631.2, 1139.29, 33.7428, 4.53705, 0, 0),
+(@PATH, 9, -10627.9, 1123.15, 33.7433, 4.92032, 0, 0),
+(@PATH, 10, -10623.6, 1106.81, 33.839, 4.71298, 0, 0),
+(@PATH, 11, -10624.1, 1100.77, 33.7959, 4.37573, 0, 0),
+(@PATH, 12, -10626.3, 1098.61, 33.7164, 3.34293, 0, 0),
+(@PATH, 13, -10630.2, 1098.87, 33.7023, 2.58109, 0, 0),
+(@PATH, 14, -10636.6, 1103.93, 34.3049, 2.47899, 0, 0),
+(@PATH, 15, -10638.7, 1105.6, 35.6183, 2.72796, 0, 0),
+(@PATH, 16, -10644.3, 1107.04, 35.6515, 3.07197, 6000, @SCRIPTID+0),
+(@PATH, 17, -10641.1, 1107.4, 35.6302, 5.73997, 0, 0),
+(@PATH, 18, -10638.3, 1105.68, 35.6181, 5.5931, 0, 0),
+(@PATH, 19, -10636.5, 1104.16, 34.3292, 5.5931, 0, 0),
+(@PATH, 20, -10630.1, 1098.96, 33.7028, 5.92454, 0, 0),
+(@PATH, 21, -10626.7, 1098.35, 33.7094, 0.0984525, 0, 0),
+(@PATH, 22, -10624.6, 1100.14, 33.774, 0.868928, 0, 0),
+(@PATH, 23, -10623.7, 1101.87, 33.8117, 1.58364, 0, 0),
+(@PATH, 24, -10624, 1107.23, 33.8072, 1.68574, 0, 0);
+
+SET @NPC := 89861;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`, `orientation`, `action`) VALUES
+(@PATH, 1, -10584.8, 1144.22, 40.2218, 3.85718, 103000, @SCRIPTID+1),
+(@PATH, 2, -10582.4, 1140.78, 39.6677, 4.94343, 0, 0),
+(@PATH, 3, -10583.4, 1137.05, 39.0197, 4.28134, 0, 0),
+(@PATH, 4, -10599.1, 1117.84, 37.7277, 3.9986, 0, 0),
+(@PATH, 5, -10611.2, 1105.3, 35.982, 3.79833, 0, 0),
+(@PATH, 6, -10623.2, 1098.3, 33.8558, 3.27368, 0, 0),
+(@PATH, 7, -10628.8, 1097.99, 33.7034, 2.77888, 0, 0),
+(@PATH, 8, -10633.6, 1099.99, 34.1616, 2.51027, 0, 0),
+(@PATH, 9, -10637.4, 1102.69, 34.1628, 2.53776, 0, 0),
+(@PATH, 10, -10639.6, 1104.22, 35.6187, 2.53776, 0, 0),
+(@PATH, 11, -10644.4, 1106.43, 35.651, 2.84799, 6000, @SCRIPTID+0),
+(@PATH, 12, -10639.6, 1104.32, 35.6182, 5.79324, 0, 0),
+(@PATH, 13, -10636.9, 1102.73, 34.2156, 5.75004, 0, 0),
+(@PATH, 14, -10628.3, 1098.14, 33.7034, 6.14745, 0, 0),
+(@PATH, 15, -10617.2, 1100.93, 34.7838, 0.495724, 0, 0),
+(@PATH, 16, -10610.1, 1106.28, 36.1837, 0.739197, 0, 0),
+(@PATH, 17, -10597.7, 1119.31, 37.9428, 0.845226, 0, 0),
+(@PATH, 18, -10582.2, 1138.37, 39.1972, 1.1154, 0, 0),
+(@PATH, 19, -10582.3, 1141.47, 39.7775, 1.75786, 0, 0),
+(@PATH, 20, -10583.1, 1143.39, 40.0436, 2.16391, 0, 0);
+
+UPDATE `waypoint_data` SET `action_chance`=100 WHERE `action` BETWEEN @SCRIPTID+0 AND @SCRIPTID+3;