aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorariel- <ariel-@users.noreply.github.com>2017-01-21 12:48:02 -0300
committerariel- <ariel-@users.noreply.github.com>2017-01-21 12:51:19 -0300
commit689526f8a9ee9422f4fa048c5f7513fa69d965a8 (patch)
tree68820ad308c4b990a69fd17cff27147b0ec7edf5
parent591a25500d98a17eaf70215329080ca2f41783ed (diff)
DB/Misc: killed some ugly whitespace
-rw-r--r--sql/updates/world/3.3.5/2017_01_20_06_world_335.sql66
-rw-r--r--sql/updates/world/3.3.5/2017_01_20_07_world_335.sql156
2 files changed, 111 insertions, 111 deletions
diff --git a/sql/updates/world/3.3.5/2017_01_20_06_world_335.sql b/sql/updates/world/3.3.5/2017_01_20_06_world_335.sql
index e0ef3f750e1..877043a867e 100644
--- a/sql/updates/world/3.3.5/2017_01_20_06_world_335.sql
+++ b/sql/updates/world/3.3.5/2017_01_20_06_world_335.sql
@@ -1,8 +1,8 @@
-- SCRIPT 1
-SET @MAXGUID := 919;
-SET @SCRIPTID := 8014900;
+SET @MAXGUID := 919;
+SET @SCRIPTID := 8014900;
DELETE FROM `waypoint_scripts` WHERE `id` IN (@SCRIPTID+0);
-INSERT INTO `waypoint_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`, `guid`) VALUES
+INSERT INTO `waypoint_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`, `guid`) VALUES
(@SCRIPTID+0, 1, 35, 1, 5, 0, 0, 0, 0, 0, (@MAXGUID := @MAXGUID + 1)),
(@SCRIPTID+0, 20, 35, 2, 0, 801490, 0, 0, 0, 0, (@MAXGUID := @MAXGUID + 1));
@@ -13,15 +13,15 @@ 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`, `move_type`, `action`) VALUES
-(@PATH, 1, -9008.89, -320.603, 75.8279, 2.8812, 1000, 1, 0),
-(@PATH, 2, -8981.22, -335.138, 73.3474, 5.82645, 0, 1, 0),
-(@PATH, 3, -8946.51, -338.891, 71.1134, 5.82409, 0, 1, 0),
-(@PATH, 4, -8912.77, -352.085, 72.5823, 5.88143, 0, 1, 0),
-(@PATH, 5, -8881.49, -355.84, 73.1462, 6.17595, 0, 1, 0),
-(@PATH, 6, -8910.65, -346.602, 71.1023, 2.81837, 0, 0, 0),
-(@PATH, 7, -8883.13, -352.739, 72.9499, 2.75397, 0, 0, 0),
-(@PATH, 8, -8911.38, -347.166, 71.3269, 2.95582, 0, 0, 0),
-(@PATH, 9, -8947.63, -337.566, 70.9275, 2.87728, 0, 0, 0),
+(@PATH, 1, -9008.89, -320.603, 75.8279, 2.8812, 1000, 1, 0),
+(@PATH, 2, -8981.22, -335.138, 73.3474, 5.82645, 0, 1, 0),
+(@PATH, 3, -8946.51, -338.891, 71.1134, 5.82409, 0, 1, 0),
+(@PATH, 4, -8912.77, -352.085, 72.5823, 5.88143, 0, 1, 0),
+(@PATH, 5, -8881.49, -355.84, 73.1462, 6.17595, 0, 1, 0),
+(@PATH, 6, -8910.65, -346.602, 71.1023, 2.81837, 0, 0, 0),
+(@PATH, 7, -8883.13, -352.739, 72.9499, 2.75397, 0, 0, 0),
+(@PATH, 8, -8911.38, -347.166, 71.3269, 2.95582, 0, 0, 0),
+(@PATH, 9, -8947.63, -337.566, 70.9275, 2.87728, 0, 0, 0),
(@PATH, 10, -9008.89, -320.603, 75.8279, 2.8812, 25000, 0, @SCRIPTID);
UPDATE `waypoint_data` SET `action_chance`=100 WHERE `action` IN (@SCRIPTID);
@@ -50,9 +50,9 @@ 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`, `move_type`) VALUES
-(@PATH, 1, -9120.29, -275.579, 72.9006, 1.03043, 2000, 1),
-(@PATH, 2, -9112.23, -263.542, 74.4268, 1.06342, 3000, 0),
-(@PATH, 3, -9110.18, -259.698, 74.7637, 3.91441, 0, 1),
+(@PATH, 1, -9120.29, -275.579, 72.9006, 1.03043, 2000, 1),
+(@PATH, 2, -9112.23, -263.542, 74.4268, 1.06342, 3000, 0),
+(@PATH, 3, -9110.18, -259.698, 74.7637, 3.91441, 0, 1),
(@PATH, 4, -9120.29, -269.848, 73.5204, 3.94322, 4000, 0);
-- SCRIPT 4
@@ -63,11 +63,11 @@ 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`, `move_type`) VALUES
-(@PATH, 1, -9131.36, -306.832, 73.5301, 4.49767, 0, 1),
-(@PATH, 2, -9132.83, -313.89, 73.306, 4.49767, 4000, 1),
-(@PATH, 3, -9124.91, -379.208, 73.2856, 4.81183, 3000, 0),
-(@PATH, 4, -9125.01, -372.703, 73.5785, 1.77234, 0, 1),
-(@PATH, 5, -9138.42, -339.389, 72.5674, 1.2202, 0, 1),
+(@PATH, 1, -9131.36, -306.832, 73.5301, 4.49767, 0, 1),
+(@PATH, 2, -9132.83, -313.89, 73.306, 4.49767, 4000, 1),
+(@PATH, 3, -9124.91, -379.208, 73.2856, 4.81183, 3000, 0),
+(@PATH, 4, -9125.01, -372.703, 73.5785, 1.77234, 0, 1),
+(@PATH, 5, -9138.42, -339.389, 72.5674, 1.2202, 0, 1),
(@PATH, 6, -9123.32, -311.799, 72.985, 1.2202, 4000, 0);
-- SCRIPT 5
@@ -119,10 +119,10 @@ INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type
(@ENTRY,9,1,0,0,0,100,0,4000,4000,0,0,5,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Defias Thug - On Script - Play Emote 1");
-- SCRIPT 8
-SET @MAXGUID := 921;
-SET @SCRIPTID := 8025100;
+SET @MAXGUID := 921;
+SET @SCRIPTID := 8025100;
DELETE FROM `waypoint_scripts` WHERE `id` IN (@SCRIPTID+0);
-INSERT INTO `waypoint_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`, `guid`) VALUES
+INSERT INTO `waypoint_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`, `guid`) VALUES
(@SCRIPTID+0, 1, 35, 1, 5, 0, 0, 0, 0, 0, (@MAXGUID := @MAXGUID + 1)),
(@SCRIPTID+0, 20, 35, 2, 0, 802510, 0, 0, 0, 0, (@MAXGUID := @MAXGUID + 1));
@@ -133,16 +133,16 @@ 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`, `move_type`, `action`) VALUES
-(@PATH, 1, -8878.29, -410.994, 65.6802, 4.63836, 1000, 1, 0),
-(@PATH, 2, -8880.02, -399.363, 66.0983, 2.83464, 0, 1, 0),
-(@PATH, 3, -8898.18, -391.582, 68.6285, 3.16417, 0, 1, 0),
-(@PATH, 4, -8914.49, -391.059, 69.3006, 2.22326, 0, 1, 0),
-(@PATH, 5, -8928.27, -375.636, 71.218, 3.22857, 0, 1, 0),
-(@PATH, 6, -8958.87, -373.826, 72.3354, 3.34245, 5000, 1, 0),
-(@PATH, 7, -8921.43, -376.858, 71.1848, 0.534655, 0, 1, 0),
-(@PATH, 8, -8909.08, -366.763, 72.135, 6.05679, 0, 1, 0),
-(@PATH, 9, -8870.04, -371.407, 71.997, 4.63836, 0, 1, 0),
-(@PATH, 10, -8878.29, -410.994, 65.6802, 4.63836, 0, 1, 0),
+(@PATH, 1, -8878.29, -410.994, 65.6802, 4.63836, 1000, 1, 0),
+(@PATH, 2, -8880.02, -399.363, 66.0983, 2.83464, 0, 1, 0),
+(@PATH, 3, -8898.18, -391.582, 68.6285, 3.16417, 0, 1, 0),
+(@PATH, 4, -8914.49, -391.059, 69.3006, 2.22326, 0, 1, 0),
+(@PATH, 5, -8928.27, -375.636, 71.218, 3.22857, 0, 1, 0),
+(@PATH, 6, -8958.87, -373.826, 72.3354, 3.34245, 5000, 1, 0),
+(@PATH, 7, -8921.43, -376.858, 71.1848, 0.534655, 0, 1, 0),
+(@PATH, 8, -8909.08, -366.763, 72.135, 6.05679, 0, 1, 0),
+(@PATH, 9, -8870.04, -371.407, 71.997, 4.63836, 0, 1, 0),
+(@PATH, 10, -8878.29, -410.994, 65.6802, 4.63836, 0, 1, 0),
(@PATH, 11, -8878.29, -410.994, 65.6802, 4.63836, 25000, 1, @SCRIPTID);
UPDATE `waypoint_data` SET `action_chance`=100 WHERE `action` IN (@SCRIPTID);
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
index 26a64d9944e..be70da37df2 100644
--- 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
@@ -6,10 +6,10 @@ 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;
+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
+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)),
@@ -24,36 +24,36 @@ 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);
-
+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;
@@ -61,31 +61,31 @@ 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);
+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;
@@ -93,26 +93,26 @@ 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),
+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;