aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/2015_04_01_01_world.sql376
1 files changed, 376 insertions, 0 deletions
diff --git a/sql/updates/world/2015_04_01_01_world.sql b/sql/updates/world/2015_04_01_01_world.sql
new file mode 100644
index 00000000000..b53c739e2dd
--- /dev/null
+++ b/sql/updates/world/2015_04_01_01_world.sql
@@ -0,0 +1,376 @@
+-- Pathing for Silvermoon City Guardian Entry: 16222 'TDB FORMAT'
+SET @NPC := 56892;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=9797.032,`position_y`=-7418.94,`position_z`=14.02596 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`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,9797.032,-7418.94,14.02596,0,0,0,0,100,0), -- 20:03:32
+(@PATH,2,9795.906,-7402.565,13.77626,0,0,0,0,100,0), -- 20:03:42
+(@PATH,3,9795.656,-7400.315,13.77626,0,0,0,0,100,0), -- 20:03:42
+(@PATH,4,9790.018,-7397.717,14.59705,0,0,0,0,100,0), -- 20:03:50
+(@PATH,5,9788.768,-7397.717,14.84705,0,0,0,0,100,0), -- 20:03:50
+(@PATH,6,9775.768,-7396.717,14.84705,0,0,0,0,100,0), -- 20:03:50
+(@PATH,7,9770.018,-7396.217,14.84705,0,0,0,0,100,0), -- 20:03:50
+(@PATH,8,9767.188,-7400.526,14.03701,0,0,0,0,100,0), -- 20:04:01
+(@PATH,9,9767.188,-7402.276,14.03701,0,0,0,0,100,0), -- 20:04:01
+(@PATH,10,9765.688,-7412.526,13.78701,0,0,0,0,100,0), -- 20:04:01
+(@PATH,11,9758.99,-7418.586,13.32115,0,0,0,0,100,0), -- 20:04:10
+(@PATH,12,9713.854,-7426.193,13.51967,0,0,0,0,100,0), -- 20:04:24
+(@PATH,13,9707.104,-7429.193,13.51967,0,0,0,0,100,0), -- 20:04:24
+(@PATH,14,9700.104,-7432.693,13.51967,0,0,0,0,100,0), -- 20:04:24
+(@PATH,15,9687.424,-7434.536,13.54329,0,0,0,0,100,0), -- 20:04:39
+(@PATH,16,9650.786,-7425.012,13.54389,0,0,0,0,100,0), -- 20:04:50
+(@PATH,17,9611.484,-7423.664,13.54949,0,0,0,0,100,0), -- 20:04:59
+(@PATH,18,9602.561,-7429.987,13.43456,0,0,0,0,100,0), -- 20:05:15
+(@PATH,19,9602.061,-7430.737,13.93456,0,0,0,0,100,0), -- 20:05:15
+(@PATH,20,9600.311,-7432.487,13.68456,0,0,0,0,100,0), -- 20:05:15
+(@PATH,21,9578.125,-7435.431,15.78367,0,0,0,0,100,0), -- 20:05:23
+(@PATH,22,9573.875,-7434.931,15.78367,0,0,0,0,100,0), -- 20:05:23
+(@PATH,23,9570.875,-7434.681,15.78367,0,0,0,0,100,0), -- 20:05:23
+(@PATH,24,9561.199,-7425.627,17.48535,0,0,0,0,100,0), -- 20:05:36
+(@PATH,25,9560.949,-7424.377,17.98535,0,0,0,0,100,0), -- 20:05:36
+(@PATH,26,9560.449,-7422.627,18.73535,0,0,0,0,100,0), -- 20:05:36
+(@PATH,27,9560.199,-7420.877,19.48535,0,0,0,0,100,0), -- 20:05:36
+(@PATH,28,9562.604,-7417.716,19.62811,0,0,0,0,100,0), -- 20:05:42
+(@PATH,29,9564.242,-7407.687,19.65438,0,0,0,0,100,0), -- 20:05:44
+(@PATH,30,9564.242,-7403.187,17.15438,0,0,0,0,100,0), -- 20:05:44
+(@PATH,31,9555.359,-7396.585,17.08825,0,0,0,0,100,0), -- 20:05:52
+(@PATH,32,9547.609,-7396.585,17.08825,0,0,0,0,100,0), -- 20:05:52
+(@PATH,33,9539.609,-7396.835,17.08825,0,0,0,0,100,0), -- 20:05:52
+(@PATH,34,9538.109,-7396.835,17.08825,0,0,0,0,100,0), -- 20:05:52
+(@PATH,35,9536.859,-7396.835,17.08825,0,0,0,0,100,0), -- 20:05:52
+(@PATH,36,9534.359,-7396.835,17.08825,0,0,0,0,100,0), -- 20:05:52
+(@PATH,37,9530.609,-7397.085,17.08825,0,0,0,0,100,0), -- 20:05:52
+(@PATH,38,9528.309,-7396.823,17.08099,0,0,0,0,100,0), -- 20:06:06
+(@PATH,39,9515.559,-7396.823,15.08099,0,0,0,0,100,0), -- 20:06:06
+(@PATH,40,9508.986,-7383.027,14.37308,0,0,0,0,100,0), -- 20:06:15
+(@PATH,41,9507.986,-7368.527,14.37308,0,0,0,0,100,0), -- 20:06:15
+(@PATH,42,9509.079,-7334.869,14.47609,0,0,0,0,100,0), -- 20:06:29
+(@PATH,43,9509.329,-7333.369,14.47609,0,0,0,0,100,0), -- 20:06:29
+(@PATH,44,9509.329,-7332.369,14.47609,0,0,0,0,100,0), -- 20:06:29
+(@PATH,45,9509.579,-7330.119,14.47609,0,0,0,0,100,0), -- 20:06:29
+(@PATH,46,9509.579,-7329.119,14.22609,0,0,0,0,100,0), -- 20:06:29
+(@PATH,47,9510.201,-7311.316,14.32034,0,0,0,0,100,0), -- 20:06:45
+(@PATH,48,9510.201,-7306.066,14.32034,0,0,0,0,100,0), -- 20:06:45
+(@PATH,49,9510.451,-7298.816,14.32034,0,0,0,0,100,0), -- 20:06:45
+(@PATH,50,9510.451,-7293.316,14.07034,0,0,0,0,100,0), -- 20:06:45
+(@PATH,51,9510.329,-7300.647,14.09887,0,0,0,0,100,0), -- 20:06:54
+(@PATH,52,9510.372,-7292.951,14.05711,0,0,0,0,100,0), -- 20:10:02
+(@PATH,53,9515.844,-7278.31,14.22743,0,0,0,0,100,0), -- 20:10:09
+(@PATH,54,9526.344,-7277.31,13.97743,0,0,0,0,100,0), -- 20:10:09
+(@PATH,55,9537.094,-7276.31,14.22743,0,0,0,0,100,0), -- 20:10:09
+(@PATH,56,9555.932,-7274.813,14.1918,0,0,0,0,100,0), -- 20:10:27
+(@PATH,57,9620.014,-7275.292,14.19181,0,0,0,0,100,0), -- 20:10:43
+(@PATH,58,9664.584,-7274.804,13.9807,0,0,0,0,100,0), -- 20:11:00
+(@PATH,59,9667.084,-7274.804,14.2307,0,0,0,0,100,0), -- 20:11:00
+(@PATH,60,9676.5,-7289.921,13.96391,0,0,0,0,100,0), -- 20:11:16
+(@PATH,61,9676.75,-7291.921,14.21391,0,0,0,0,100,0), -- 20:11:16
+(@PATH,62,9682.359,-7296.356,14.19385,0,0,0,0,100,0), -- 20:11:25
+(@PATH,63,9693.359,-7297.106,14.44385,0,0,0,0,100,0), -- 20:11:25
+(@PATH,64,9695.359,-7297.106,14.44385,0,0,0,0,100,0), -- 20:11:25
+(@PATH,65,9698.109,-7297.356,14.69385,0,0,0,0,100,0), -- 20:11:25
+(@PATH,66,9699.902,-7303.835,15.57155,0,0,0,0,100,0), -- 20:11:34
+(@PATH,67,9699.902,-7308.335,15.32155,0,0,0,0,100,0), -- 20:11:34
+(@PATH,68,9695.211,-7310.05,14.5845,0,0,0,0,100,0), -- 20:11:39
+(@PATH,69,9693.211,-7310.3,14.5845,0,0,0,0,100,0), -- 20:11:39
+(@PATH,70,9682.211,-7310.8,14.3345,0,0,0,0,100,0), -- 20:11:39
+(@PATH,71,9676.809,-7317.146,14.0487,0,0,0,0,100,0), -- 20:11:48
+(@PATH,72,9676.059,-7328.396,13.7987,0,0,0,0,100,0), -- 20:11:48
+(@PATH,73,9675.559,-7335.146,12.5487,0,0,0,0,100,0), -- 20:11:48
+(@PATH,74,9675.311,-7342.5,12.11859,0,0,0,0,100,0), -- 20:11:59
+(@PATH,75,9675.311,-7345.75,12.11859,0,0,0,0,100,0), -- 20:11:59
+(@PATH,76,9675.311,-7347.5,12.11859,0,0,0,0,100,0), -- 20:11:59
+(@PATH,77,9675.311,-7348.5,12.11859,0,0,0,0,100,0), -- 20:11:59
+(@PATH,78,9669.002,-7356.422,12.18507,0,0,0,0,100,0), -- 20:12:06
+(@PATH,79,9668.814,-7361.282,12.18596,0,0,0,0,100,0), -- 20:12:10
+(@PATH,80,9668.77,-7364.439,12.18267,0,0,0,0,100,0), -- 20:12:12
+(@PATH,81,9690.079,-7381.311,12.09861,0,0,0,0,100,0), -- 20:12:22
+(@PATH,82,9687.182,-7384.319,11.74371,0,0,0,0,100,0), -- 20:12:24
+(@PATH,83,9686.182,-7384.319,11.74371,0,0,0,0,100,0), -- 20:12:24
+(@PATH,84,9683.373,-7392.788,12.14598,0,0,0,0,100,0), -- 20:12:28
+(@PATH,85,9683.373,-7394.288,12.14598,0,0,0,0,100,0), -- 20:12:28
+(@PATH,86,9682.873,-7403.288,11.89598,0,0,0,0,100,0), -- 20:12:28
+(@PATH,87,9682.623,-7408.288,11.89598,0,0,0,0,100,0), -- 20:12:28
+(@PATH,88,9682.373,-7411.788,11.89598,0,0,0,0,100,0), -- 20:12:28
+(@PATH,89,9682.123,-7420.038,13.89598,0,0,0,0,100,0), -- 20:12:28
+(@PATH,90,9681.873,-7421.538,13.89598,0,0,0,0,100,0), -- 20:12:28
+(@PATH,91,9682.331,-7411.838,12.38935,0,0,0,0,100,0), -- 20:12:44
+(@PATH,92,9682.581,-7408.338,11.88935,0,0,0,0,100,0), -- 20:12:44
+(@PATH,93,9682.581,-7403.338,12.13935,0,0,0,0,100,0), -- 20:12:44
+(@PATH,94,9683.081,-7394.338,12.13935,0,0,0,0,100,0), -- 20:12:44
+(@PATH,95,9683.081,-7392.838,12.13935,0,0,0,0,100,0), -- 20:12:44
+(@PATH,96,9683.331,-7390.088,12.13935,0,0,0,0,100,0), -- 20:12:44
+(@PATH,97,9687.128,-7384.611,11.93381,0,0,0,0,100,0), -- 20:12:58
+(@PATH,98,9689.84,-7379.5,12.07366,0,0,0,0,100,0), -- 20:13:02
+(@PATH,99,9689.515,-7378.112,12.14712,0,0,0,0,100,0), -- 20:13:04
+(@PATH,100,9668.722,-7361.385,12.18551,0,0,0,0,100,0), -- 20:13:14
+(@PATH,101,9668.566,-7356.804,12.18437,0,0,0,0,100,0), -- 20:13:18
+(@PATH,102,9675.295,-7347.331,12.04761,0,0,0,0,100,0), -- 20:13:20
+(@PATH,103,9675.295,-7346.081,12.04761,0,0,0,0,100,0), -- 20:13:20
+(@PATH,104,9675.045,-7342.581,12.04761,0,0,0,0,100,0), -- 20:13:20
+(@PATH,105,9675.82,-7328.544,13.847,0,0,0,0,100,0), -- 20:13:27
+(@PATH,106,9676.07,-7317.294,14.097,0,0,0,0,100,0), -- 20:13:27
+(@PATH,107,9676.32,-7315.294,14.097,0,0,0,0,100,0), -- 20:13:27
+(@PATH,108,9693.324,-7310.449,14.44139,0,0,0,0,100,0), -- 20:13:38
+(@PATH,109,9695.074,-7310.449,14.44139,0,0,0,0,100,0), -- 20:13:38
+(@PATH,110,9697.824,-7310.199,14.69139,0,0,0,0,100,0), -- 20:13:38
+(@PATH,111,9699.779,-7303.936,15.51412,0,0,0,0,100,0), -- 20:13:48
+(@PATH,112,9700.029,-7299.436,15.51412,0,0,0,0,100,0), -- 20:13:48
+(@PATH,113,9698.18,-7297.467,15.08991,0,0,0,0,100,0), -- 20:13:53
+(@PATH,114,9695.18,-7297.467,14.58991,0,0,0,0,100,0), -- 20:13:53
+(@PATH,115,9693.43,-7297.217,14.58991,0,0,0,0,100,0), -- 20:13:53
+(@PATH,116,9682.43,-7296.467,14.33991,0,0,0,0,100,0), -- 20:13:53
+(@PATH,117,9680.68,-7296.467,14.08991,0,0,0,0,100,0), -- 20:13:53
+(@PATH,118,9676.986,-7292.785,14.18614,0,0,0,0,100,0), -- 20:14:01
+(@PATH,119,9676.736,-7290.035,13.93614,0,0,0,0,100,0), -- 20:14:01
+(@PATH,120,9676.486,-7284.785,14.18614,0,0,0,0,100,0), -- 20:14:01
+(@PATH,121,9664.668,-7274.95,13.98935,0,0,0,0,100,0), -- 20:14:11
+(@PATH,122,9641.668,-7275.45,13.98935,0,0,0,0,100,0), -- 20:14:11
+(@PATH,123,9600.16,-7275.033,14.19062,0,0,0,0,100,0), -- 20:14:27
+(@PATH,124,9596.66,-7275.033,14.19062,0,0,0,0,100,0), -- 20:14:27
+(@PATH,125,9595.887,-7274.914,14.19024,0,0,0,0,100,0), -- 20:14:43
+(@PATH,126,9526.42,-7277.001,14.22749,0,0,0,0,100,0), -- 20:14:59
+(@PATH,127,9515.92,-7278.001,14.22749,0,0,0,0,100,0), -- 20:14:59
+(@PATH,128,9513.92,-7278.251,14.22749,0,0,0,0,100,0), -- 20:14:59
+(@PATH,129,9510.681,-7293.288,14.06322,0,0,0,0,100,0), -- 20:15:17
+(@PATH,130,9510.681,-7298.788,14.31322,0,0,0,0,100,0), -- 20:15:17
+(@PATH,131,9510.681,-7306.038,14.31322,0,0,0,0,100,0), -- 20:15:17
+(@PATH,132,9510.431,-7311.288,14.31322,0,0,0,0,100,0), -- 20:15:17
+(@PATH,133,9510.431,-7314.288,14.31322,0,0,0,0,100,0), -- 20:15:17
+(@PATH,134,9509.529,-7330.155,14.47821,0,0,0,0,100,0), -- 20:15:34
+(@PATH,135,9509.279,-7332.405,14.47821,0,0,0,0,100,0), -- 20:15:34
+(@PATH,136,9509.279,-7333.405,14.47821,0,0,0,0,100,0), -- 20:15:34
+(@PATH,137,9509.029,-7334.905,14.47821,0,0,0,0,100,0), -- 20:15:34
+(@PATH,138,9507.779,-7356.905,14.47821,0,0,0,0,100,0), -- 20:15:34
+(@PATH,139,9508.02,-7368.424,14.58394,0,0,0,0,100,0), -- 20:15:49
+(@PATH,140,9508.77,-7382.924,14.58394,0,0,0,0,100,0), -- 20:15:49
+(@PATH,141,9508.77,-7385.174,14.58394,0,0,0,0,100,0), -- 20:15:49
+(@PATH,142,9528.405,-7396.765,17.07827,0,0,0,0,100,0), -- 20:16:04
+(@PATH,143,9534.251,-7396.64,16.96906,0,0,0,0,100,0), -- 20:16:13
+(@PATH,144,9537.001,-7396.64,16.96906,0,0,0,0,100,0), -- 20:16:13
+(@PATH,145,9538.001,-7396.64,16.96906,0,0,0,0,100,0), -- 20:16:13
+(@PATH,146,9539.751,-7396.64,16.96906,0,0,0,0,100,0), -- 20:16:13
+(@PATH,147,9547.501,-7396.64,16.96906,0,0,0,0,100,0), -- 20:16:13
+(@PATH,148,9555.251,-7396.39,16.96906,0,0,0,0,100,0), -- 20:16:13
+(@PATH,149,9556.751,-7396.39,16.96906,0,0,0,0,100,0), -- 20:16:13
+(@PATH,150,9564.121,-7407.653,19.65082,0,0,0,0,100,0), -- 20:16:26
+(@PATH,151,9564.121,-7411.653,19.65082,0,0,0,0,100,0), -- 20:16:26
+(@PATH,152,9562.407,-7417.577,19.72515,0,0,0,0,100,0), -- 20:16:34
+(@PATH,153,9560.863,-7424.275,17.98024,0,0,0,0,100,0), -- 20:16:37
+(@PATH,154,9561.113,-7425.525,17.48024,0,0,0,0,100,0), -- 20:16:37
+(@PATH,155,9561.613,-7427.275,16.73024,0,0,0,0,100,0), -- 20:16:37
+(@PATH,156,9573.232,-7434.738,15.66694,0,0,0,0,100,0), -- 20:16:43
+(@PATH,157,9577.982,-7435.488,15.66694,0,0,0,0,100,0), -- 20:16:43
+(@PATH,158,9581.732,-7435.988,14.16694,0,0,0,0,100,0), -- 20:16:43
+(@PATH,159,9601.162,-7431.205,13.72673,0,0,0,0,100,0), -- 20:16:55
+(@PATH,160,9602.662,-7430.205,13.47673,0,0,0,0,100,0), -- 20:16:55
+(@PATH,161,9604.162,-7428.705,13.47673,0,0,0,0,100,0), -- 20:16:55
+(@PATH,162,9611.602,-7423.619,13.54987,0,0,0,0,100,0), -- 20:17:04
+(@PATH,163,9661.816,-7430.175,13.54431,0,0,0,0,100,0), -- 20:17:19
+(@PATH,164,9691.869,-7434.476,13.54329,0,0,0,0,100,0), -- 20:17:29
+(@PATH,165,9699.86,-7432.892,13.52494,0,0,0,0,100,0), -- 20:17:39
+(@PATH,166,9707.11,-7429.142,13.52494,0,0,0,0,100,0), -- 20:17:39
+(@PATH,167,9713.61,-7426.142,13.52494,0,0,0,0,100,0), -- 20:17:39
+(@PATH,168,9720.36,-7422.642,13.52494,0,0,0,0,100,0), -- 20:17:39
+(@PATH,169,9760.865,-7418.738,13.57886,0,0,0,0,100,0), -- 20:17:53
+(@PATH,170,9766.886,-7402.463,13.85978,0,0,0,0,100,0), -- 20:18:08
+(@PATH,171,9767.136,-7400.463,13.85978,0,0,0,0,100,0), -- 20:18:08
+(@PATH,172,9767.636,-7397.713,14.10978,0,0,0,0,100,0), -- 20:18:08
+(@PATH,173,9769.994,-7396.318,14.46496,0,0,0,0,100,0), -- 20:18:18
+(@PATH,174,9775.994,-7396.568,14.96496,0,0,0,0,100,0), -- 20:18:18
+(@PATH,175,9788.744,-7397.568,14.96496,0,0,0,0,100,0), -- 20:18:18
+(@PATH,176,9789.994,-7397.818,14.96496,0,0,0,0,100,0), -- 20:18:18
+(@PATH,177,9792.994,-7398.068,14.46496,0,0,0,0,100,0), -- 20:18:18
+(@PATH,178,9795.314,-7400.193,14.02223,0,0,0,0,100,0), -- 20:18:29
+(@PATH,179,9795.564,-7402.443,14.02223,0,0,0,0,100,0), -- 20:18:29
+(@PATH,180,9796.064,-7407.193,14.02223,0,0,0,0,100,0), -- 20:18:29
+(@PATH,181,9796.564,-7412.443,14.02223,0,0,0,0,100,0); -- 20:18:29
+
+-- Pathing for Silvermoon City Guardian Entry: 16222 'TDB FORMAT'
+SET @NPC := 56891;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=9617.148,`position_y`=-7372.344,`position_z`=14.95278 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`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,9617.148,-7372.344,14.95278,0,0,0,0,100,0), -- 11:38:44
+(@PATH,2,9617.634,-7381.962,14.90948,0,0,0,0,100,0), -- 11:38:50
+(@PATH,3,9613.992,-7385.066,14.11522,0,0,0,0,100,0), -- 11:38:55
+(@PATH,4,9611.742,-7385.566,14.11522,0,0,0,0,100,0), -- 11:38:55
+(@PATH,5,9607.742,-7386.316,13.86522,0,0,0,0,100,0), -- 11:38:55
+(@PATH,6,9601.742,-7387.316,13.86522,0,0,0,0,100,0), -- 11:38:55
+(@PATH,7,9600.242,-7387.566,13.86522,0,0,0,0,100,0), -- 11:38:55
+(@PATH,8,9595.152,-7394.241,13.41057,0,0,0,0,100,0), -- 11:39:05
+(@PATH,9,9601.703,-7417.196,13.54557,0,0,0,0,100,0), -- 11:39:12
+(@PATH,10,9605.453,-7422.946,13.54557,0,0,0,0,100,0), -- 11:39:12
+(@PATH,11,9611.395,-7424.344,13.54924,0,0,0,0,100,0), -- 11:39:20
+(@PATH,12,9669.465,-7433.946,13.54404,0,0,0,0,100,0), -- 11:39:37
+(@PATH,13,9692.181,-7435.465,13.54329,0,0,0,0,100,0), -- 11:39:47
+(@PATH,14,9706.28,-7428.034,13.54329,0,0,0,0,100,0), -- 11:39:57
+(@PATH,15,9712.78,-7423.784,13.54329,0,0,0,0,100,0), -- 11:39:57
+(@PATH,16,9755.95,-7419.636,13.33486,0,0,0,0,100,0), -- 11:40:07
+(@PATH,17,9758.95,-7419.636,13.33486,0,0,0,0,100,0), -- 11:40:07
+(@PATH,18,9760.95,-7419.386,13.58486,0,0,0,0,100,0), -- 11:40:07
+(@PATH,19,9765.676,-7425.275,13.87941,0,0,0,0,100,0), -- 11:40:26
+(@PATH,20,9766.176,-7435.275,13.87941,0,0,0,0,100,0), -- 11:40:26
+(@PATH,21,9766.426,-7437.275,13.87941,0,0,0,0,100,0), -- 11:40:26
+(@PATH,22,9766.676,-7440.525,14.12941,0,0,0,0,100,0), -- 11:40:26
+(@PATH,23,9769.751,-7441.452,14.42178,0,0,0,0,100,0), -- 11:40:36
+(@PATH,24,9775.751,-7441.702,14.92178,0,0,0,0,100,0), -- 11:40:36
+(@PATH,25,9782.751,-7441.952,14.92178,0,0,0,0,100,0), -- 11:40:36
+(@PATH,26,9785.001,-7441.952,14.92178,0,0,0,0,100,0), -- 11:40:36
+(@PATH,27,9791.501,-7442.202,14.92178,0,0,0,0,100,0), -- 11:40:36
+(@PATH,28,9793.707,-7440.501,14.62286,0,0,0,0,100,0), -- 11:40:45
+(@PATH,29,9794.207,-7437.501,14.12286,0,0,0,0,100,0), -- 11:40:45
+(@PATH,30,9794.707,-7435.501,14.12286,0,0,0,0,100,0), -- 11:40:45
+(@PATH,31,9795.457,-7431.251,13.87286,0,0,0,0,100,0), -- 11:40:45
+(@PATH,32,9796.457,-7426.001,13.87286,0,0,0,0,100,0), -- 11:40:45
+(@PATH,33,9796.707,-7424.001,13.87286,0,0,0,0,100,0), -- 11:40:45
+(@PATH,34,9802.908,-7420.202,13.36064,0,0,0,0,100,0), -- 11:40:55
+(@PATH,35,9865.802,-7420.71,13.53932,0,0,0,0,100,0), -- 11:41:14
+(@PATH,36,9880.648,-7415.182,13.51911,0,0,0,0,100,0), -- 11:41:27
+(@PATH,37,9885.898,-7409.932,13.51911,0,0,0,0,100,0), -- 11:41:27
+(@PATH,38,9886.761,-7404.89,13.40958,0,0,0,0,100,0), -- 11:41:33
+(@PATH,39,9888.123,-7384.329,15.85358,0,0,0,0,100,0), -- 11:41:40
+(@PATH,40,9888.623,-7369.579,20.85358,0,0,0,0,100,0), -- 11:41:40
+(@PATH,41,9873.136,-7363.303,20.90705,0,0,0,0,100,0), -- 11:41:51
+(@PATH,42,9867.386,-7362.553,19.65705,0,0,0,0,100,0), -- 11:41:51
+(@PATH,43,9863.198,-7364.229,19.0695,0,0,0,0,100,0), -- 11:42:00
+(@PATH,44,9859.948,-7366.479,19.0695,0,0,0,0,100,0), -- 11:42:00
+(@PATH,45,9841.254,-7366.119,18.845,0,0,0,0,100,0), -- 11:42:07
+(@PATH,46,9836.004,-7362.869,18.845,0,0,0,0,100,0), -- 11:42:07
+(@PATH,47,9833.344,-7362.54,18.90108,0,0,0,0,100,0), -- 11:42:15
+(@PATH,48,9829.344,-7362.79,20.65108,0,0,0,0,100,0), -- 11:42:15
+(@PATH,49,9827.594,-7363.04,20.90108,0,0,0,0,100,0), -- 11:42:15
+(@PATH,50,9821.844,-7363.54,20.90108,0,0,0,0,100,0), -- 11:42:15
+(@PATH,51,9829.27,-7362.814,20.40145,0,0,0,0,100,0), -- 11:42:26
+(@PATH,52,9833.27,-7362.314,19.65145,0,0,0,0,100,0), -- 11:42:26
+(@PATH,53,9835.859,-7362.992,19.06359,0,0,0,0,100,0), -- 11:42:34
+(@PATH,54,9841.109,-7365.992,19.06359,0,0,0,0,100,0), -- 11:42:34
+(@PATH,55,9850.109,-7370.992,19.06359,0,0,0,0,100,0), -- 11:42:34
+(@PATH,56,9859.49,-7366.387,18.84956,0,0,0,0,100,0), -- 11:42:41
+(@PATH,57,9863.24,-7364.137,18.84956,0,0,0,0,100,0), -- 11:42:41
+(@PATH,58,9873.046,-7363.469,20.91313,0,0,0,0,100,0), -- 11:42:48
+(@PATH,59,9874.796,-7363.469,20.91313,0,0,0,0,100,0), -- 11:42:48
+(@PATH,60,9887.834,-7384.231,15.64358,0,0,0,0,100,0), -- 11:42:58
+(@PATH,61,9887.834,-7387.231,14.64358,0,0,0,0,100,0), -- 11:42:58
+(@PATH,62,9886.838,-7404.881,13.63869,0,0,0,0,100,0), -- 11:43:08
+(@PATH,63,9876.497,-7419.251,13.51794,0,0,0,0,100,0), -- 11:43:16
+(@PATH,64,9865.785,-7420.523,13.54063,0,0,0,0,100,0), -- 11:43:22
+(@PATH,65,9859.535,-7420.523,13.54063,0,0,0,0,100,0), -- 11:43:22
+(@PATH,66,9801.332,-7420.127,13.66687,0,0,0,0,100,0), -- 11:43:36
+(@PATH,67,9796.978,-7424.1,13.69735,0,0,0,0,100,0), -- 11:43:53
+(@PATH,68,9796.728,-7425.85,13.94735,0,0,0,0,100,0), -- 11:43:53
+(@PATH,69,9795.728,-7431.35,13.94735,0,0,0,0,100,0), -- 11:43:53
+(@PATH,70,9794.978,-7435.35,13.69735,0,0,0,0,100,0), -- 11:43:53
+(@PATH,71,9794.478,-7437.6,13.94735,0,0,0,0,100,0), -- 11:43:53
+(@PATH,72,9793.978,-7440.6,14.19735,0,0,0,0,100,0), -- 11:43:53
+(@PATH,73,9791.54,-7442.293,14.44685,0,0,0,0,100,0), -- 11:44:02
+(@PATH,74,9785.04,-7442.043,14.94685,0,0,0,0,100,0), -- 11:44:02
+(@PATH,75,9782.79,-7442.043,14.94685,0,0,0,0,100,0), -- 11:44:02
+(@PATH,76,9775.54,-7441.793,14.94685,0,0,0,0,100,0), -- 11:44:02
+(@PATH,77,9769.79,-7441.543,14.94685,0,0,0,0,100,0), -- 11:44:02
+(@PATH,78,9766.505,-7435.237,13.99367,0,0,0,0,100,0), -- 11:44:13
+(@PATH,79,9765.755,-7425.237,13.74367,0,0,0,0,100,0), -- 11:44:13
+(@PATH,80,9765.755,-7423.487,13.74367,0,0,0,0,100,0), -- 11:44:13
+(@PATH,81,9758.748,-7419.551,13.30211,0,0,0,0,100,0), -- 11:44:22
+(@PATH,82,9755.748,-7419.551,13.30211,0,0,0,0,100,0), -- 11:44:22
+(@PATH,83,9720.498,-7421.301,13.30211,0,0,0,0,100,0), -- 11:44:22
+(@PATH,84,9706.665,-7428.206,13.52816,0,0,0,0,100,0), -- 11:44:41
+(@PATH,85,9699.915,-7432.456,13.52816,0,0,0,0,100,0), -- 11:44:41
+(@PATH,86,9688.145,-7435.444,13.54329,0,0,0,0,100,0), -- 11:44:52
+(@PATH,87,9661.658,-7430.764,13.54354,0,0,0,0,100,0), -- 11:45:01
+(@PATH,88,9650.658,-7426.014,13.54354,0,0,0,0,100,0), -- 11:45:01
+(@PATH,89,9611.502,-7424.288,13.54895,0,0,0,0,100,0), -- 11:45:10
+(@PATH,90,9601.961,-7417.239,13.55362,0,0,0,0,100,0), -- 11:45:27
+(@PATH,91,9600.711,-7415.739,13.55362,0,0,0,0,100,0), -- 11:45:27
+(@PATH,92,9595.22,-7392.367,13.64975,0,0,0,0,100,0), -- 11:45:36
+(@PATH,93,9601.827,-7387.457,13.94776,0,0,0,0,100,0), -- 11:45:43
+(@PATH,94,9607.577,-7386.457,13.94776,0,0,0,0,100,0), -- 11:45:43
+(@PATH,95,9611.827,-7385.707,13.69776,0,0,0,0,100,0), -- 11:45:43
+(@PATH,96,9613.827,-7385.457,13.94776,0,0,0,0,100,0), -- 11:45:43
+(@PATH,97,9616.577,-7384.957,14.19776,0,0,0,0,100,0), -- 11:45:43
+(@PATH,98,9617.488,-7381.918,14.6536,0,0,0,0,100,0), -- 11:45:53
+(@PATH,99,9617.488,-7376.918,14.9036,0,0,0,0,100,0), -- 11:45:53
+(@PATH,100,9617.238,-7372.168,14.9036,0,0,0,0,100,0), -- 11:45:53
+(@PATH,101,9617.634,-7381.962,14.90948,0,0,0,0,100,0), -- 11:46:00
+(@PATH,102,9613.973,-7385.057,14.11319,0,0,0,0,100,0), -- 11:46:04
+(@PATH,103,9611.723,-7385.557,14.11319,0,0,0,0,100,0), -- 11:46:04
+(@PATH,104,9607.723,-7386.307,13.86319,0,0,0,0,100,0), -- 11:46:04
+(@PATH,105,9601.973,-7387.307,13.86319,0,0,0,0,100,0), -- 11:46:04
+(@PATH,106,9600.223,-7387.557,13.86319,0,0,0,0,100,0), -- 11:46:04
+(@PATH,107,9595.393,-7394.153,13.41572,0,0,0,0,100,0), -- 11:46:14
+(@PATH,108,9601.696,-7417.232,13.54363,0,0,0,0,100,0), -- 11:46:21
+(@PATH,109,9605.696,-7422.982,13.54363,0,0,0,0,100,0), -- 11:46:21
+(@PATH,110,9611.418,-7424.264,13.54923,0,0,0,0,100,0); -- 11:46:29
+
+DELETE FROM `creature_formations` WHERE `leaderGUID`=56878;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES
+(56878, 56878, 0, 0, 2),
+(56878, 56877, 3, 90, 2);
+
+-- Pathing for Silvermoon Guardian Entry: 16221 'TDB FORMAT'
+SET @NPC := 56878;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=9102.456,`position_y`=-7482.04,`position_z`=78.35519 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`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,9102.456,-7482.04,78.35519,0,0,0,0,100,0), -- 19:43:23
+(@PATH,2,9103.248,-7482.65,78.35519,0,0,0,0,100,0), -- 19:43:23
+(@PATH,3,9104.715,-7483.78,78.2541,0,0,0,0,100,0), -- 19:43:23
+(@PATH,4,9109.629,-7484.697,77.63239,0,0,0,0,100,0), -- 19:43:23
+(@PATH,5,9115.527,-7485.799,77.00739,0,0,0,0,100,0), -- 19:43:23
+(@PATH,6,9120.441,-7486.717,76.38239,0,0,0,0,100,0), -- 19:43:23
+(@PATH,7,9124.373,-7487.451,75.75739,0,0,0,0,100,0), -- 19:43:23
+(@PATH,8,9129.287,-7488.369,75.13239,0,0,0,0,100,0), -- 19:43:23
+(@PATH,9,9137.15,-7489.838,74.58031,0,0,0,0,100,0), -- 19:43:23
+(@PATH,10,9141.082,-7490.572,73.95531,0,0,0,0,100,0), -- 19:43:23
+(@PATH,11,9142.2,-7490.788,73.90916,0,0,0,0,100,0), -- 19:43:23
+(@PATH,12,9142.2,-7490.788,73.90916,0,0,0,0,100,0), -- 19:43:23
+(@PATH,13,9149.529,-7476.493,69.95045,0,0,0,0,100,0), -- 19:43:29
+(@PATH,14,9161.441,-7460.135,63.98,0,0,0,0,100,0), -- 19:43:35
+(@PATH,15,9179.331,-7453.608,56.39117,0,0,0,0,100,0), -- 19:43:44
+(@PATH,16,9198.095,-7455.712,49.39744,0,0,0,0,100,0), -- 19:43:52
+(@PATH,17,9232.926,-7447.019,39.44244,0,0,0,0,100,0), -- 19:44:00
+(@PATH,18,9244.291,-7433.579,36.1172,0,0,0,0,100,0), -- 19:44:16
+(@PATH,19,9245.047,-7432.797,36.07084,0,0,0,0,100,0), -- 19:44:22
+(@PATH,20,9258.551,-7433.484,36.12626,0,0,0,0,100,0), -- 19:44:28
+(@PATH,21,9265.053,-7448.939,36.07185,0,0,0,0,100,0), -- 19:44:34
+(@PATH,22,9260.291,-7466.419,35.95266,0,0,0,0,100,0), -- 19:44:41
+(@PATH,23,9259.721,-7483.818,35.70003,0,0,0,0,100,0), -- 19:44:49
+(@PATH,24,9260.23,-7465.513,35.81084,0,0,0,0,100,0), -- 19:44:56
+(@PATH,25,9248.131,-7424.455,35.23894,0,0,0,0,100,0), -- 19:45:04
+(@PATH,26,9250.974,-7376.712,29.71493,0,0,0,0,100,0), -- 19:45:17
+(@PATH,27,9269.848,-7341.41,22.52634,0,0,0,0,100,0), -- 19:45:36
+(@PATH,28,9290.326,-7305.721,18.07349,0,0,0,0,100,0), -- 19:45:53
+(@PATH,29,9309.75,-7283.949,14.86156,0,0,0,0,100,0), -- 19:46:10
+(@PATH,30,9296.104,-7297.955,16.94801,0,0,0,0,100,0), -- 19:46:23
+(@PATH,31,9273.268,-7335.548,21.18934,0,0,0,0,100,0), -- 19:46:32
+(@PATH,32,9252.006,-7373.276,28.924,0,0,0,0,100,0), -- 19:46:50
+(@PATH,33,9247.184,-7419.163,34.14049,0,0,0,0,100,0), -- 19:47:07
+(@PATH,34,9261.941,-7441.854,35.80672,0,0,0,0,100,0), -- 19:47:26
+(@PATH,35,9264.699,-7445.521,36.01838,0,0,0,0,100,0), -- 19:47:37
+(@PATH,36,9260.029,-7465.688,35.94786,0,0,0,0,100,0), -- 19:47:46
+(@PATH,37,9259.739,-7483.936,35.70295,0,0,0,0,100,0), -- 19:47:53
+(@PATH,38,9260.128,-7466.218,35.80263,0,0,0,0,100,0), -- 19:48:00
+(@PATH,39,9264.906,-7448.786,36.13476,0,0,0,0,100,0), -- 19:48:08
+(@PATH,40,9258.107,-7433.702,36.05851,0,0,0,0,100,0), -- 19:48:15
+(@PATH,41,9235.605,-7445.421,38.64949,0,0,0,0,100,0), -- 19:48:20
+(@PATH,42,9200.038,-7455.543,49.04723,0,0,0,0,100,0), -- 19:48:27
+(@PATH,43,9182.41,-7453.483,55.13942,0,0,0,0,100,0), -- 19:48:43
+(@PATH,44,9164.158,-7457.769,62.62826,0,0,0,0,100,0), -- 19:48:50
+(@PATH,45,9151.068,-7474.071,68.90013,0,0,0,0,100,0), -- 19:48:59
+(@PATH,46,9142.732,-7490.235,73.94332,0,0,0,0,100,0), -- 19:49:07
+(@PATH,47,9110.125,-7484.632,77.80888,0,0,0,0,100,0), -- 19:49:15
+(@PATH,48,9090.791,-7472.85,80.36261,0,0,0,0,100,0), -- 19:49:30
+(@PATH,49,9082.396,-7462.425,82.50674,0,0,0,0,100,0), -- 19:49:38
+(@PATH,50,9077.785,-7456.682,83.13695,0,0,0,0,100,0), -- 19:49:45
+(@PATH,51,9066.736,-7450.874,83.24338,0,0,0,0,100,0), -- 19:49:50
+(@PATH,52,9066.793,-7450.982,83.18549,0,0,0,0,100,0), -- 19:49:57
+(@PATH,53,9067.023,-7451.012,83.33182,0,0,0,0,100,0), -- 19:50:02
+(@PATH,54,9089.325,-7471.378,80.84378,0,0,0,0,100,0); -- 19:50:06