diff options
| -rw-r--r-- | sql/updates/world/2015_04_01_01_world.sql | 376 |
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 |