diff options
| -rw-r--r-- | sql/updates/world/master/2017_05_24_00_world.sql | 325 |
1 files changed, 325 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_05_24_00_world.sql b/sql/updates/world/master/2017_05_24_00_world.sql new file mode 100644 index 00000000000..1dbe3ba3432 --- /dev/null +++ b/sql/updates/world/master/2017_05_24_00_world.sql @@ -0,0 +1,325 @@ +-- Pathing for Stormwind Guard Entry: 1423 'TDB FORMAT' +SET @NPC := 281479; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-9621.585,`position_y`=-1009.805,`position_z`=41.4601 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,257,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`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-9621.585,-1009.805,41.4601,0,0,0,0,100,0), +(@PATH,2,-9622.979,-993.5161,42.51941,0,0,0,0,100,0), +(@PATH,3,-9616.812,-971.4866,43.64319,0,0,0,0,100,0), +(@PATH,4,-9605.688,-952.9254,43.84697,0,0,0,0,100,0), +(@PATH,5,-9589.601,-935.541,43.71594,0,0,0,0,100,0), +(@PATH,6,-9581.84,-917.2405,43.88842,0,0,0,0,100,0), +(@PATH,7,-9582.131,-892.7952,43.52868,0,0,0,0,100,0), +(@PATH,8,-9587.052,-870.2479,43.77868,0,0,0,0,100,0), +(@PATH,9,-9603.133,-848.3824,43.8069,0,0,0,0,100,0), +(@PATH,10,-9635.435,-813.6964,43.84379,0,0,0,0,100,0), +(@PATH,11,-9646.747,-797.5594,43.59379,0,0,0,0,100,0), +(@PATH,12,-9651.212,-783.6508,44.32621,0,0,0,0,100,0), +(@PATH,13,-9651.457,-762.5749,44.47965,0,0,0,0,100,0), +(@PATH,14,-9656.33,-740.673,44.61954,0,0,0,0,100,0), +(@PATH,15,-9656.645,-723.0509,44.66413,0,0,0,0,100,0), +(@PATH,16,-9649.04,-701.8206,46.00813,0,0,0,0,100,0), +(@PATH,17,-9643.346,-663.4222,49.36496,0,0,0,0,100,0), +(@PATH,18,-9628.837,-641.6657,51.14138,0,0,0,0,100,0), +(@PATH,19,-9622.42,-603.7773,52.84998,0,0,0,0,100,0), +(@PATH,20,-9619.694,-574.7324,54.19883,0,0,0,0,100,0), +(@PATH,21,-9617.313,-551.6019,54.49004,0,0,0,0,100,0), +(@PATH,22,-9611.551,-532.0573,54.7783,0,0,0,0,100,0), +(@PATH,23,-9602.272,-517.8843,56.76878,0,0,0,0,100,0), +(@PATH,24,-9593.436,-504.3423,57.52607,0,0,0,0,100,0), +(@PATH,25,-9589.494,-487.5282,57.76851,0,0,0,0,100,0), +(@PATH,26,-9590.743,-469.7306,57.8166,0,0,0,0,100,0), +(@PATH,27,-9600.497,-453.0271,57.78099,0,0,0,0,100,0), +(@PATH,28,-9608.497,-436.1051,57.36327,0,0,0,0,100,0), +(@PATH,29,-9614.505,-416.2884,57.66486,0,0,0,0,100,0), +(@PATH,30,-9617.868,-395.8977,57.95574,0,0,0,0,100,0), +(@PATH,31,-9619.874,-371.5169,57.58074,0,0,0,0,100,0), +(@PATH,32,-9620.904,-344.161,57.28194,0,0,0,0,100,0), +(@PATH,33,-9620.884,-320.5441,57.52703,0,0,0,0,100,0), +(@PATH,34,-9618.642,-297.6285,57.18179,0,0,0,0,100,0), +(@PATH,35,-9612.653,-276.4153,57.76284,0,0,0,0,100,0), +(@PATH,36,-9608.691,-255.3432,57.32165,0,0,0,0,100,0), +(@PATH,37,-9598.686,-228.6033,57.3935,0,0,0,0,100,0), +(@PATH,38,-9588.345,-202.6797,57.81245,0,0,0,0,100,0), +(@PATH,39,-9578.535,-171.4949,57.50352,0,0,0,0,100,0), +(@PATH,40,-9567.966,-150.9942,57.1911,0,0,0,0,100,0), +(@PATH,41,-9553.459,-136.2681,57.28034,0,0,0,0,100,0), +(@PATH,42,-9549.182,-112.0365,57.55236,0,0,0,0,100,0), +(@PATH,43,-9548.437,-83.4119,57.64455,0,0,0,0,100,0), +(@PATH,44,-9546.561,-64.21647,57.19081,0,0,0,0,100,0), +(@PATH,45,-9542.052,-43.97417,56.69081,0,0,0,0,100,0), +(@PATH,46,-9531.666,-17.71886,56.00526,0,0,0,0,100,0), +(@PATH,47,-9518.505,4.58865,56.11089,0,0,0,0,100,0), +(@PATH,48,-9505.715,31.62967,56.48589,0,0,0,0,100,0), +(@PATH,49,-9495.036,54.66113,55.81353,0,0,0,0,100,0), +(@PATH,50,-9492.798,64.35981,56.02752,0,6000,0,0,100,0), +(@PATH,51,-9497.884,48.81619,55.94793,0,0,0,0,100,0), +(@PATH,52,-9503.121,36.35319,56.42255,0,0,0,0,100,0), +(@PATH,53,-9509.772,23.9451,56.53191,0,0,0,0,100,0), +(@PATH,54,-9517.83,6.747939,56.11089,0,0,0,0,100,0), +(@PATH,55,-9529.744,-15.72743,55.8871,0,0,0,0,100,0), +(@PATH,56,-9541.357,-44.91298,56.76772,0,0,0,0,100,0), +(@PATH,57,-9547.372,-71.95128,57.51955,0,0,0,0,100,0), +(@PATH,58,-9549.507,-109.4462,57.5067,0,0,0,0,100,0), +(@PATH,59,-9556.684,-136.5528,57.55939,0,0,0,0,100,0), +(@PATH,60,-9567.811,-151.0182,57.1723,0,0,0,0,100,0), +(@PATH,61,-9578.885,-170.2882,57.37852,0,0,0,0,100,0), +(@PATH,62,-9586.776,-195.1395,57.62852,0,0,0,0,100,0), +(@PATH,63,-9598.216,-224.6504,57.30341,0,0,0,0,100,0), +(@PATH,64,-9608.648,-258.0852,57.30822,0,0,0,0,100,0), +(@PATH,65,-9614.821,-289.097,57.59048,0,0,0,0,100,0), +(@PATH,66,-9618.106,-312.9915,57.58343,0,0,0,0,100,0), +(@PATH,67,-9620.264,-340.5638,57.52462,0,0,0,0,100,0), +(@PATH,68,-9619.762,-370.9549,57.58074,0,0,0,0,100,0), +(@PATH,69,-9618.118,-393.6722,57.83074,0,0,0,0,100,0), +(@PATH,70,-9610.834,-427.7363,57.52277,0,0,0,0,100,0), +(@PATH,71,-9602.774,-445.216,57.62401,0,0,0,0,100,0), +(@PATH,72,-9596.105,-461.7981,57.74839,0,0,0,0,100,0), +(@PATH,73,-9591.105,-476.2582,57.76851,0,0,0,0,100,0), +(@PATH,74,-9591.471,-488.4674,57.84004,0,0,0,0,100,0), +(@PATH,75,-9593.778,-501.4398,57.38178,0,0,0,0,100,0), +(@PATH,76,-9598.513,-512.4593,57.47431,0,0,0,0,100,0), +(@PATH,77,-9609.811,-533.6465,54.86504,0,0,0,0,100,0), +(@PATH,78,-9615.971,-550.82,54.49004,0,0,0,0,100,0), +(@PATH,79,-9618.966,-571.0148,54.37461,0,0,0,0,100,0), +(@PATH,80,-9620.506,-590.8423,53.78599,0,0,0,0,100,0), +(@PATH,81,-9623.524,-620.6938,51.94861,0,0,0,0,100,0), +(@PATH,82,-9628.995,-638.2269,51.17922,0,0,0,0,100,0), +(@PATH,83,-9636.7,-653.1119,49.69407,0,0,0,0,100,0), +(@PATH,84,-9641.278,-663.9442,49.39695,0,0,0,0,100,0), +(@PATH,85,-9645.316,-681.183,48.00885,0,0,0,0,100,0), +(@PATH,86,-9650.676,-701.9413,45.99372,0,0,0,0,100,0), +(@PATH,87,-9653.724,-722.3216,44.67292,0,0,0,0,100,0), +(@PATH,88,-9654.573,-742.368,44.55119,0,0,0,0,100,0), +(@PATH,89,-9652.612,-766.4833,44.30216,0,0,0,0,100,0), +(@PATH,90,-9648.009,-792.9749,43.62431,0,0,0,0,100,0), +(@PATH,91,-9638.621,-808.6445,43.71879,0,0,0,0,100,0), +(@PATH,92,-9626.769,-822.2813,43.88491,0,0,0,0,100,0), +(@PATH,93,-9613.571,-836.7086,43.62306,0,0,0,0,100,0), +(@PATH,94,-9600.535,-851.837,43.6819,0,0,0,0,100,0), +(@PATH,95,-9589.787,-865.6964,43.83097,0,0,0,0,100,0), +(@PATH,96,-9585.493,-875.5536,43.90368,0,0,0,0,100,0), +(@PATH,97,-9584.774,-898.893,43.90368,0,0,0,0,100,0), +(@PATH,98,-9586.063,-915.4184,43.90355,0,0,0,0,100,0), +(@PATH,99,-9592.028,-931.4844,43.74437,0,0,0,0,100,0), +(@PATH,100,-9598.08,-942.4412,43.92321,0,0,0,0,100,0), +(@PATH,101,-9607.78,-959.0113,43.49467,0,0,0,0,100,0), +(@PATH,102,-9615.448,-974.1688,43.85193,0,0,0,0,100,0), +(@PATH,103,-9620.891,-993.4722,42.6139,0,0,0,0,100,0), +(@PATH,104,-9620.597,-1003.663,42.25624,0,0,0,0,100,0), +(@PATH,105,-9620.338,-1014.109,41.06777,0,0,0,0,100,0), +(@PATH,106,-9619.945,-1024.693,40.49306,0,0,0,0,100,0), +(@PATH,107,-9619.242,-1036.472,39.87387,0,6000,0,0,100,0); + +-- Pathing for Stormwind Guard Entry: 1423 'TDB FORMAT' +SET @NPC := 280111; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-9083.599,`position_y`=-53.3508,`position_z`=86.42607 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,257,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`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-9083.599,-53.3508,86.42607,0,0,0,0,100,0), +(@PATH,2,-9098.672,-65.61827,84.054,0,0,0,0,100,0), +(@PATH,3,-9109.419,-75.7207,82.09222,0,0,0,0,100,0), +(@PATH,4,-9125.424,-85.16591,78.16302,0,0,0,0,100,0), +(@PATH,5,-9142.284,-95.87967,75.0947,0,0,0,0,100,0), +(@PATH,6,-9163.195,-108.5354,72.56712,0,0,0,0,100,0), +(@PATH,7,-9176.171,-111.9833,71.24508,0,0,0,0,100,0), +(@PATH,8,-9195.773,-112.7946,71.12057,0,0,0,0,100,0), +(@PATH,9,-9208.957,-109.3175,71.1289,0,0,0,0,100,0), +(@PATH,10,-9225.822,-104.7172,71.1289,0,0,0,0,100,0), +(@PATH,11,-9238.654,-99.04698,70.70847,0,0,0,0,100,0), +(@PATH,12,-9249.91,-91.48221,70.40672,0,0,0,0,100,0), +(@PATH,13,-9268.238,-77.89268,68.6869,0,0,0,0,100,0), +(@PATH,14,-9280.204,-67.65853,68.24964,0,0,0,0,100,0), +(@PATH,15,-9297.876,-60.61285,67.34437,0,0,0,0,100,0), +(@PATH,16,-9322.913,-53.6008,66.44393,0,0,0,0,100,0), +(@PATH,17,-9335.962,-49.37478,65.8247,0,0,0,0,100,0), +(@PATH,18,-9351.479,-40.11382,64.81542,0,0,0,0,100,0), +(@PATH,19,-9362.026,-29.91482,63.76466,0,0,0,0,100,0), +(@PATH,20,-9376.168,-14.78429,62.24424,0,0,0,0,100,0), +(@PATH,21,-9397.745,6.895725,60.04395,0,0,0,0,100,0), +(@PATH,22,-9409.909,21.16298,58.82724,0,0,0,0,100,0), +(@PATH,23,-9438.457,54.57856,56.02,0,6000,0,0,100,0), +(@PATH,24,-9431.209,46.55914,56.69352,0,0,0,0,100,0), +(@PATH,25,-9421.634,36.47081,57.31852,0,0,0,0,100,0), +(@PATH,26,-9411.369,24.51682,58.24777,0,0,0,0,100,0), +(@PATH,27,-9401.32,13.38477,59.67916,0,0,0,0,100,0), +(@PATH,28,-9390.167,-1.145291,60.82187,0,0,0,0,100,0), +(@PATH,29,-9378.083,-13.01411,61.88828,0,0,0,0,100,0), +(@PATH,30,-9365.354,-27.72938,63.36524,0,0,0,0,100,0), +(@PATH,31,-9351.892,-40.30295,64.81542,0,0,0,0,100,0), +(@PATH,32,-9337.786,-50.15527,65.67455,0,0,0,0,100,0), +(@PATH,33,-9329.192,-52.84429,66.13094,0,0,0,0,100,0), +(@PATH,34,-9314.485,-56.48058,66.70492,0,0,0,0,100,0), +(@PATH,35,-9302.469,-59.14703,66.93221,0,0,0,0,100,0), +(@PATH,36,-9290.404,-63.35688,67.5221,0,0,0,0,100,0), +(@PATH,37,-9281.472,-69.32259,68.09779,0,0,0,0,100,0), +(@PATH,38,-9270.33,-77.17632,68.6869,0,0,0,0,100,0), +(@PATH,39,-9258.729,-86.89681,69.7136,0,0,0,0,100,0), +(@PATH,40,-9245.781,-95.48481,70.52708,0,0,0,0,100,0), +(@PATH,41,-9235.747,-101.5669,70.77646,0,0,0,0,100,0), +(@PATH,42,-9228.748,-104.1309,70.99169,0,0,0,0,100,0), +(@PATH,43,-9219.661,-106.7042,71.2539,0,0,0,0,100,0), +(@PATH,44,-9208.192,-109.8,71.17455,0,0,0,0,100,0), +(@PATH,45,-9197.428,-112.1889,71.09542,0,0,0,0,100,0), +(@PATH,46,-9185.816,-112.7407,70.99557,0,0,0,0,100,0), +(@PATH,47,-9174.032,-111.8417,71.54903,0,0,0,0,100,0), +(@PATH,48,-9159.315,-106.846,73.04197,0,0,0,0,100,0), +(@PATH,49,-9149.284,-100.6613,74.23655,0,0,0,0,100,0), +(@PATH,50,-9135.363,-91.4846,76.24387,0,0,0,0,100,0), +(@PATH,51,-9119.705,-80.96517,79.70452,0,0,0,0,100,0), +(@PATH,52,-9109.234,-73.00748,82.2177,0,0,0,0,100,0), +(@PATH,53,-9097.453,-63.84201,84.35332,0,0,0,0,100,0), +(@PATH,54,-9090.091,-58.36013,85.42094,0,0,0,0,100,0), +(@PATH,55,-9084.711,-52.9579,86.38237,0,0,0,0,100,0), +(@PATH,56,-9079.419,-48.8967,87.35429,0,0,0,0,100,0), +(@PATH,57,-9070.88,-43.41764,88.0645,0,6000,0,0,100,0); + +-- Pathing for Kira Songshine Entry: 3937 'TDB FORMAT' +SET @NPC := 280672; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-9493.627,`position_y`=67.18815,`position_z`=56.24675 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,257,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`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-9493.627,67.18815,56.24675,0,0,0,0,100,0), +(@PATH,2,-9486.809,89.65723,56.21941,0,0,0,0,100,0), +(@PATH,3,-9483.946,102.302,56.50797,0,0,0,0,100,0), +(@PATH,4,-9480.245,126.3048,56.63297,0,0,0,0,100,0), +(@PATH,5,-9482.919,145.2651,56.43309,0,0,0,0,100,0), +(@PATH,6,-9485.429,167.3975,56.05416,0,0,0,0,100,0), +(@PATH,7,-9484.816,180.0712,55.42916,0,0,0,0,100,0), +(@PATH,8,-9493.019,196.9338,54.55416,0,0,0,0,100,0), +(@PATH,9,-9508.471,218.0667,52.96415,0,0,0,0,100,0), +(@PATH,10,-9533.104,242.1964,50.86973,0,0,0,0,100,0), +(@PATH,11,-9519.216,232.3553,51.83915,0,0,0,0,100,0), +(@PATH,12,-9515.605,227.5241,52.2238,0,0,0,0,100,0), +(@PATH,13,-9503.669,216.6386,52.90214,0,0,0,0,100,0), +(@PATH,14,-9498.017,202.3757,54.15273,0,0,0,0,100,0), +(@PATH,15,-9486.037,183.3565,55.22677,0,0,0,0,100,0), +(@PATH,16,-9483.614,166.1485,56.05247,0,0,0,0,100,0), +(@PATH,17,-9481.871,138.393,56.67747,0,0,0,0,100,0), +(@PATH,18,-9483.646,118.8074,56.60807,0,0,0,0,100,0), +(@PATH,19,-9486.335,100.2849,56.50797,0,0,0,0,100,0), +(@PATH,20,-9487.605,81.91924,56.0739,0,0,0,0,100,0), +(@PATH,21,-9485.286,71.61192,56.40178,0,0,0,0,100,0), +(@PATH,22,-9479.711,67.17296,56.32232,0,0,0,0,100,0), +(@PATH,23,-9467.877,61.33068,56.1054,0,0,0,0,100,0), +(@PATH,24,-9454.594,66.6288,56.20298,0,0,0,0,100,0), +(@PATH,25,-9415.596,86.5546,56.99038,0,0,0,0,100,0), +(@PATH,26,-9402.721,93.8989,58.41055,0,0,0,0,100,0), +(@PATH,27,-9383.628,105.0891,60.03624,0,0,0,0,100,0), +(@PATH,28,-9362.592,111.672,61.55702,0,0,0,0,100,0), +(@PATH,29,-9337.428,124.4685,63.71767,0,0,0,0,100,0), +(@PATH,30,-9316.489,136.0714,64.95474,0,0,0,0,100,0), +(@PATH,31,-9298.161,143.4155,65.91209,0,0,0,0,100,0), +(@PATH,32,-9273.096,151.2024,67.00413,0,0,0,0,100,0), +(@PATH,33,-9256.78,159.3222,67.66848,0,0,0,0,100,0), +(@PATH,34,-9242.877,174.1646,67.97204,0,0,0,0,100,0), +(@PATH,35,-9232.261,186.1395,67.72204,0,0,0,0,100,0), +(@PATH,36,-9217.805,203.6647,69.03122,0,0,0,0,100,0), +(@PATH,37,-9201.397,220.0502,71.15402,0,0,0,0,100,0), +(@PATH,38,-9188.232,236.8916,72.44244,0,0,0,0,100,0), +(@PATH,39,-9182.984,255.7783,73.85345,0,0,0,0,100,0), +(@PATH,40,-9182.252,275.1166,75.44212,0,0,0,0,100,0), +(@PATH,41,-9180.925,301.3294,78.33094,0,0,0,0,100,0), +(@PATH,42,-9178.171,323.0379,80.88319,0,0,0,0,100,0), +(@PATH,43,-9173.903,335.753,83.66998,0,0,0,0,100,0), +(@PATH,44,-9168.686,347.0231,86.27471,0,0,0,0,100,0), +(@PATH,45,-9142.421,375.9646,90.75526,0,0,0,0,100,0), +(@PATH,46,-9125.449,389.9619,91.57055,0,0,0,0,100,0), +(@PATH,47,-9144.014,376.6461,90.75526,0,0,0,0,100,0), +(@PATH,48,-9150.359,370.6424,90.63026,0,0,0,0,100,0), +(@PATH,49,-9159.769,358.9712,89.09229,0,0,0,0,100,0), +(@PATH,50,-9169.689,347.3052,86.06768,0,0,0,0,100,0), +(@PATH,51,-9176.393,336.1326,83.34795,0,0,0,0,100,0), +(@PATH,52,-9179.039,324.0334,81.12244,0,0,0,0,100,0), +(@PATH,53,-9181.582,310.6828,79.00208,0,0,0,0,100,0), +(@PATH,54,-9182.38,299.1464,77.95396,0,0,0,0,100,0), +(@PATH,55,-9183.653,286.0146,76.42735,0,0,0,0,100,0), +(@PATH,56,-9184.186,259.5755,74.10345,0,0,0,0,100,0), +(@PATH,57,-9187.476,239.7987,72.50726,0,0,0,0,100,0), +(@PATH,58,-9193.939,228.3685,71.82954,0,0,0,0,100,0), +(@PATH,59,-9217.061,204.2547,69.10202,0,0,0,0,100,0), +(@PATH,60,-9229.925,191.6477,68.03234,0,0,0,0,100,0), +(@PATH,61,-9239.118,181.4567,67.84704,0,0,0,0,100,0), +(@PATH,62,-9252.867,160.5058,67.88796,0,0,0,0,100,0), +(@PATH,63,-9270.517,152.484,67.12913,0,0,0,0,100,0), +(@PATH,64,-9281.984,150.6615,66.75413,0,0,0,0,100,0), +(@PATH,65,-9303.524,142.9477,65.81363,0,0,0,0,100,0), +(@PATH,66,-9326.493,133.6549,64.28152,0,0,0,0,100,0), +(@PATH,67,-9338.177,126.1314,63.79213,0,0,0,0,100,0), +(@PATH,68,-9357.066,114.8676,62.03004,0,0,0,0,100,0), +(@PATH,69,-9376.01,105.7821,60.5753,0,0,0,0,100,0), +(@PATH,70,-9396.483,100.0127,58.82322,0,0,0,0,100,0), +(@PATH,71,-9415.729,90.13653,57.42837,0,0,0,0,100,0), +(@PATH,72,-9430.02,79.53779,56.53139,0,0,0,0,100,0), +(@PATH,73,-9441.903,69.07547,56.12108,0,0,0,0,100,0), +(@PATH,74,-9459.128,61.95774,55.895,0,0,0,0,100,0), +(@PATH,75,-9471.797,63.62576,56.15252,0,0,0,0,100,0), +(@PATH,76,-9492.84,58.88786,55.85588,0,0,0,0,100,0), +(@PATH,77,-9502.176,40.73476,56.34699,0,0,0,0,100,0), +(@PATH,78,-9513.744,15.73003,56.48589,0,0,0,0,100,0), +(@PATH,79,-9519.953,3.746257,56.11089,0,0,0,0,100,0), +(@PATH,80,-9526.677,-8.577745,55.88026,0,0,0,0,100,0), +(@PATH,81,-9535.507,-27.89106,55.83387,0,0,0,0,100,0), +(@PATH,82,-9544.865,-53.43615,56.81581,0,0,0,0,100,0), +(@PATH,83,-9550.579,-84.43788,57.65163,0,0,0,0,100,0), +(@PATH,84,-9550.719,-113.8145,57.65856,0,0,0,0,100,0), +(@PATH,85,-9549.074,-80.8469,57.51955,0,0,0,0,100,0), +(@PATH,86,-9543.954,-52.83002,56.81581,0,0,0,0,100,0), +(@PATH,87,-9537.006,-30.56196,55.88392,0,0,0,0,100,0), +(@PATH,88,-9529.335,-14.98915,55.83778,0,0,0,0,100,0), +(@PATH,89,-9522.49,-4.730361,55.99379,0,0,0,0,100,0), +(@PATH,90,-9517.441,9.093316,56.23589,0,0,0,0,100,0), +(@PATH,91,-9508.014,28.54688,56.48589,0,0,0,0,100,0), +(@PATH,92,-9496.207,50.32487,55.88494,0,0,0,0,100,0); + +-- Pathing for Stormwind Royal Guard Entry: 1756 'TDB FORMAT' +SET @NPC := 314291; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-8415.07,`position_y`=299.125,`position_z`=147.0138 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,257,0, '131700'); +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,-8415.07,299.125,147.0138,0,0,0,0,100,0), +(@PATH,2,-8409.74,292.457,147.2607,0,0,0,0,100,0), +(@PATH,3,-8389.694,267.0654,155.3475,0,0,0,0,100,0), +(@PATH,4,-8381.73,257.153,155.3472,0,0,0,0,100,0), +(@PATH,5,-8363.61,254.408,155.3472,0,0,0,0,100,0), +(@PATH,6,-8384.62,237.797,155.3471,0,0,0,0,100,0), +(@PATH,7,-8383.19,255.96,155.3434,0,0,0,0,100,0), +(@PATH,8,-8391.108,265.9411,155.3471,0,0,0,0,100,0), +(@PATH,9,-8411.21,291.196,147.2786,0,0,0,0,100,0), +(@PATH,10,-8417.51,299.163,147.0138,0,0,0,0,100,0), +(@PATH,11,-8434.2,321.583,145.1534,0,4000,0,0,100,0), +(@PATH,12,-8416.243,300.5492,147.0542,0,0,0,0,100,0), +(@PATH,13,-8401.91,311.34,147.0138,0,0,0,0,100,0), +(@PATH,14,-8399.65,329.141,147.0138,0,0,0,0,100,0), +(@PATH,15,-8381.1,327.168,147.0138,0,0,0,0,100,0), +(@PATH,16,-8383.38,308.866,147.0138,0,0,0,0,100,0), +(@PATH,17,-8401.068,310.4666,147.0138,0,0,0,0,100,0); + +-- Pathing for Stormwind City Guard Entry: 68 'TDB FORMAT' +SET @NPC := 313891; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-9144.325,`position_y`=374.0361,`position_z`=90.75526 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,257,0, '131700'); +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,-9144.325,374.0361,90.75526,0,0,0,0,100,0), +(@PATH,2,-9125.303,391.6143,91.78637,0,0,0,0,100,0), +(@PATH,3,-9091.403,414.3217,92.16946,0,0,0,0,100,0), +(@PATH,4,-9073.301,427.18,92.02811,0,0,0,0,100,0), +(@PATH,5,-9091.403,414.3217,92.16946,0,0,0,0,100,0), +(@PATH,6,-9125.303,391.6143,91.78637,0,0,0,0,100,0), +(@PATH,7,-9144.325,374.0361,90.75526,0,0,0,0,100,0), +(@PATH,8,-9165.44,351.6357,87.38135,0,0,0,0,100,0); |