DB/Waypoints: add waypoints for Doomsayer Jurim, thx Kelsarhu

Closes #8958

1 files changed, 153 insertions, 0 deletions

diff --git a/sql/updates/world/2013_03_04_00_world_waypoint_data.sql b/sql/updates/world/2013_03_04_00_world_waypoint_data.sql
new file mode 100644
index 00000000000..3a2001e7e36
--- /dev/null
+++ b/sql/updates/world/2013_03_04_00_world_waypoint_data.sql
@@ -0,0 +1,153 @@
+SET @GUID := 40470;
+SET @PATH := @GUID*10;
+DELETE FROM `creature` where `id`=18686;
+INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES 
+(@GUID,18686,530,1,1,0,0,-2847.327,3195.10722,7.4167,.0910940,300,0,0,9144,13525,2,0,0,0);
+-- Pathing Data
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`) VALUES 
+(@PATH,1,-2843.86,3205.97,5.45323,0,0,0,0,100),
+(@PATH,2,-2829.24,3218.81,9.59048,0,0,0,0,100),
+(@PATH,3,-2814.12,3235.72,10.1736,0,0,0,0,100),
+(@PATH,4,-2792.54,3259.91,5.91885,0,0,0,0,100),
+(@PATH,5,-2774.46,3280.17,2.8828,0,0,0,0,100),
+(@PATH,6,-2751.21,3306.24,0.199384,0,0,0,0,100),
+(@PATH,7,-2728.55,3318.21,-0.833018,0,0,0,0,100),
+(@PATH,8,-2719.59,3331.35,-1.04936,0,0,0,0,100),
+(@PATH,9,-2708.94,3349.74,-0.819842,0,0,0,0,100),
+(@PATH,10,-2694.72,3374.29,-0.156626,0,0,0,0,100),
+(@PATH,11,-2685.08,3390.93,0.328583,0,0,0,0,100),
+(@PATH,12,-2675.69,3407.16,0.474826,0,0,0,0,100),
+(@PATH,13,-2669.68,3416.29,0.743526,0,0,0,0,100),
+(@PATH,14,-2660.96,3425.20,0.805554,0,0,0,0,100),
+(@PATH,15,-2654.25,3430.82,0.77502,0,0,0,0,100),
+(@PATH,16,-2645.46,3437.83,1.28666,0,0,0,0,100),
+(@PATH,17,-2639.59,3442.50,3.25542,0,0,0,0,100),
+(@PATH,18,-2630.71,3449.41,1.86245,0,0,0,0,100),
+(@PATH,19,-2621.54,3456.21,0.653284,0,0,0,0,100),
+(@PATH,20,-2617.41,3460.51,0.593326,0,0,0,0,100),
+(@PATH,21,-2611.50,3471.52,0.520041,0,0,0,0,100),
+(@PATH,22,-2610.04,3475.69,0.53993,0,0,0,0,100),
+(@PATH,23,-2606.90,3480.85,0.492544,0,0,0,0,100),
+(@PATH,24,-2590.41,3502.84,0.225892,0,0,0,0,100),
+(@PATH,25,-2582.03,3512.00,0.101641,0,0,0,0,100),
+(@PATH,26,-2566.36,3522.06,0.189451,0,0,0,0,100),
+(@PATH,27,-2534.38,3523.07,1.3404,0,0,0,0,100),
+(@PATH,28,-2523.33,3527.83,1.66667,0,0,0,0,100),
+(@PATH,29,-2516.31,3533.95,1.65006,0,0,0,0,100),
+(@PATH,30,-2507.47,3544.67,1.56155,0,0,0,0,100),
+(@PATH,31,-2491.83,3549.68,1.43199,0,0,0,0,100),
+(@PATH,32,-2471.56,3551.98,1.23732,0,0,0,0,100),
+(@PATH,33,-2463.14,3555.66,1.03546,0,0,0,0,100),
+(@PATH,34,-2456.30,3555.25,0.942503,0,0,0,0,100),
+(@PATH,35,-2452.53,3537.02,0.402467,0,0,0,0,100),
+(@PATH,36,-2446.32,3528.59,-0.236494,0,0,0,0,100),
+(@PATH,37,-2462.93,3549.41,1.08819,0,0,0,0,100),
+(@PATH,38,-2460.92,3557.50,1.00403,0,0,0,0,100),
+(@PATH,39,-2425.49,3596.20,0.274173,0,0,0,0,100),
+(@PATH,40,-2405.20,3613.88,0.217946,0,0,0,0,100),
+(@PATH,41,-2391.31,3632.83,0.792431,0,0,0,0,100),
+(@PATH,42,-2383.97,3658.54,0.99065,0,0,0,0,100),
+(@PATH,43,-2351.54,3700.72,0.420721,0,0,0,0,100),
+(@PATH,44,-2314.59,3729.83,0.0297019,0,0,0,0,100),
+(@PATH,45,-2296.57,3749.89,0.363868,0,0,0,0,100),
+(@PATH,46,-2285.44,3767.70,0.291327,0,0,0,0,100),
+(@PATH,47,-2279.30,3787.95,0.314858,0,0,0,0,100),
+(@PATH,48,-2276.30,3799.32,0.521091,0,0,0,0,100),
+(@PATH,49,-2254.61,3831.13,2.70024,0,0,0,0,100),
+(@PATH,50,-2251.75,3848.92,5.15061,0,0,0,0,100),
+(@PATH,51,-2249.52,3869.55,2.39354,0,0,0,0,100),
+(@PATH,52,-2244.66,3893.46,1.58335,0,0,0,0,100),
+(@PATH,53,-2239.88,3904.19,1.10899,0,0,0,0,100),
+(@PATH,54,-2224.28,3927.45,0.706091,0,0,0,0,100),
+(@PATH,55,-2187.45,3958.22,0.921813,0,0,0,0,100),
+(@PATH,56,-2175.09,3978.98,0.929392,0,0,0,0,100),
+(@PATH,57,-2171.14,4011.04,0.450247,0,0,0,0,100),
+(@PATH,58,-2175.93,4027.88,0.519539,0,0,0,0,100),
+(@PATH,59,-2187.96,4064.43,1.42810,0,0,0,0,100),
+(@PATH,60,-2166.44,4102.49,4.27243,0,0,0,0,100), -- Had guid as action_id
+(@PATH,61,-1700.15,3993.57,55.6859,0,0,0,0,100),
+(@PATH,62,-1710.59,4034.97,60.6101,0,0,0,0,100),
+(@PATH,63,-1719.95,4059.83,62.7452,0,0,0,0,100),
+(@PATH,64,-1718.67,4104.32,64.3796,0,0,0,0,100),
+(@PATH,65,-1743.77,4151.60,62.3929,0,0,0,0,100),
+(@PATH,66,-1754.61,4173.29,58.3691,0,0,0,0,100),
+(@PATH,67,-1788.41,4206.51,44.1839,0,0,0,0,100),
+(@PATH,68,-1818.93,4214.12,33.1137,0,0,0,0,100),
+(@PATH,69,-1841.51,4228.10,22.0741,0,0,0,0,100),
+(@PATH,70,-1871.54,4263.50,8.22153,0,0,0,0,100),
+(@PATH,71,-1891.00,4295.91,3.23019,0,0,0,0,100),
+(@PATH,72,-1911.96,4351.49,1.66825,0,0,0,0,100),
+(@PATH,73,-1910.12,4389.42,1.77078,0,0,0,0,100),
+(@PATH,74,-1907.67,4417.31,2.99456,0,0,0,0,100),
+(@PATH,75,-1917.63,4452.07,6.27493,0,0,0,0,100),
+(@PATH,76,-1929.40,4473.47,8.90937,0,0,0,0,100),
+(@PATH,77,-1942.74,4489.67,11.1029,0,0,0,0,100),
+(@PATH,78,-1958.47,4508.45,12.7432,0,0,0,0,100),
+(@PATH,79,-1975.36,4519.94,13.1616,0,0,0,0,100),
+(@PATH,80,-1982.19,4524.49,13.0993,0,0,0,0,100),
+(@PATH,81,-1983.38,4507.03,12.7591,0,0,0,0,100),
+(@PATH,82,-1984.02,4496.55,11.9535,0,0,0,0,100),
+(@PATH,83,-1984.87,4482.57,11.1499,0,0,0,0,100),
+(@PATH,84,-1978.92,4509.87,12.6695,0,0,0,0,100),
+(@PATH,85,-1978.12,4527.35,13.36,0,0,0,0,100),
+(@PATH,86,-1967.33,4546.79,12.8741,0,0,0,0,100),
+(@PATH,87,-1953.04,4566.47,10.1123,0,0,0,0,100),
+(@PATH,88,-1946.50,4582.91,7.44598,0,0,0,0,100),
+(@PATH,89,-1948.30,4599.58,4.61956,0,0,0,0,100),
+(@PATH,90,-1955.08,4637.48,-0.0588505,0,0,0,0,100),
+(@PATH,91,-1943.63,4685.04,-2.18987,0,0,0,0,100),
+(@PATH,92,-1941.99,4705.25,-2.67768,0,0,0,0,100),
+(@PATH,93,-1945.22,4727.47,-3.22917,0,0,0,0,100),
+(@PATH,94,-1951.89,4748.79,-2.9388,0,0,0,0,100),
+(@PATH,95,-1957.77,4773.70,-1.42409,0,0,0,0,100),
+(@PATH,96,-1957.36,4798.11,-0.0807409,0,0,0,0,100),
+(@PATH,97,-1944.66,4829.17,0.67,0,0,0,0,100),
+(@PATH,98,-1929.68,4851.09,1.64973,0,0,0,0,100),
+(@PATH,99,-1918.23,4883.89,2.11937,0,0,0,0,100),
+(@PATH,100,-1901.18,4906.49,-1.12705,0,0,0,0,100),
+(@PATH,101,-1881.87,4926.69,-9.60835,0,0,0,0,100),
+(@PATH,102,-1870.05,4946.21,-17.0149,0,0,0,0,100),
+(@PATH,103,-1866.49,4960.25,-20.2899,0,0,0,0,100),
+(@PATH,104,-1860.94,5033.3,-26.0991,0,0,0,0,100),
+(@PATH,105,-1869.80,4962.46,-20.3781,0,0,0,0,100),
+(@PATH,106,-1884.86,4924.67,-8.30171,0,0,0,0,100),
+(@PATH,107,-1904.83,4905.16,-0.202733,0,0,0,0,100),
+(@PATH,108,-1922.67,4912.5,6.06643,0,0,0,0,100),
+(@PATH,109,-1937.46,4934.99,14.8054,0,0,0,0,100),
+(@PATH,110,-1953.22,4961.69,24.7149,0,0,0,0,100),
+(@PATH,111,-1958.07,4992.99,30.1767,0,0,0,0,100),
+(@PATH,112,-1958.74,5013.42,32.4293,0,0,0,0,100),
+(@PATH,113,-1947.03,5042.52,25.2899,0,0,0,0,100),
+(@PATH,114,-1942.58,5058.03,19.5292,0,0,0,0,100),
+(@PATH,115,-1963.32,5083.08,11.1075,0,0,0,0,100),
+(@PATH,116,-1984.50,5100.08,7.82778,0,0,0,0,100),
+(@PATH,117,-2004.59,5114.07,8.26657,0,0,0,0,100),
+(@PATH,118,-2029.48,5123.26,8.48839,0,0,0,0,100),
+(@PATH,119,-2055.94,5125.38,7.48301,0,0,0,0,100),
+(@PATH,120,-2089.33,5115.44,3.14184,0,0,0,0,100),
+(@PATH,121,-2112.53,5107.32,-2.40737,0,0,0,0,100),
+(@PATH,122,-2137.40,5108.51,-11.5709,0,0,0,0,100),
+(@PATH,123,-2155.69,5115.97,-18.1534,0,0,0,0,100),
+(@PATH,124,-2170.60,5125.13,-21.2824,0,0,0,0,100),
+(@PATH,125,-2182.81,5131.87,-21.667,0,0,0,0,100),
+(@PATH,126,-2198.88,5138.77,-21.2323,0,0,0,0,100),
+(@PATH,127,-2219.62,5144.57,-19.6848,0,0,0,0,100),
+(@PATH,128,-2238.57,5146.29,-17.4706,0,0,0,0,100),
+(@PATH,129,-2266.45,5144.26,-13.0598,0,0,0,0,100),
+(@PATH,130,-2290.86,5142.23,-9.17377,0,0,0,0,100),
+(@PATH,131,-2308.35,5142.09,-7.11532,0,0,0,0,100),
+(@PATH,132,-2333.72,5149.44,-5.0165,0,0,0,0,100),
+(@PATH,133,-2365.45,5157.88,-2.8501,0,0,0,0,100),
+(@PATH,134,-2390.26,5158.22,-1.19618,0,0,0,0,100),
+(@PATH,135,-2417.84,5153.35,0.775549,0,0,0,0,100),
+(@PATH,136,-2442.28,5142.04,3.53141,0,0,0,0,100),
+(@PATH,137,-2469.81,5120.56,6.76948,0,0,0,0,100),
+(@PATH,138,-2498.06,5115.06,7.87731,0,0,0,0,100),
+(@PATH,139,-2532.85,5118.89,7.54034,0,0,0,0,100),
+(@PATH,140,-2555.60,5120.59,7.69492,0,0,0,0,100), -- GUID+1 as action_id
+(@PATH,141,-2843.86,3205.97,5.45323,0,0,0,0,100);
+-- Assign Path
+DELETE FROM `creature_addon` WHERE `guid`=@GUID;
+INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES 
+(@GUID,@PATH);