diff options
| -rw-r--r-- | sql/updates/world/2015_03_26_00_world_f335.sql | 586 |
1 files changed, 586 insertions, 0 deletions
diff --git a/sql/updates/world/2015_03_26_00_world_f335.sql b/sql/updates/world/2015_03_26_00_world_f335.sql new file mode 100644 index 00000000000..ab759e628f6 --- /dev/null +++ b/sql/updates/world/2015_03_26_00_world_f335.sql @@ -0,0 +1,586 @@ +-- Pathing for Stonevault Ambusher Entry: 7175 'TDB FORMAT' +SET @NPC := 27536; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-210.1764,`position_y`=109.2886,`position_z`=-47.71453 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,-210.1764,109.2886,-47.71453,0,0,1,0,100,0), -- 19:46:17 +(@PATH,2,-210.9264,115.0386,-47.71453,0,0,1,0,100,0), -- 19:46:17 +(@PATH,3,-211.1764,117.7886,-46.96453,0,0,1,0,100,0), -- 19:46:17 +(@PATH,4,-211.4264,120.0386,-46.46453,0,0,1,0,100,0), -- 19:46:17 +(@PATH,5,-211.3505,121.1287,-46.46464,0,0,1,0,100,0), -- 19:46:20 +(@PATH,6,-211.3505,124.6287,-46.46464,0,0,1,0,100,0), -- 19:46:20 +(@PATH,7,-211.3505,126.8787,-46.46464,0,0,1,0,100,0), -- 19:46:20 +(@PATH,8,-206.7831,137.7592,-46.55875,0,0,1,0,100,0), -- 19:46:21 +(@PATH,9,-204.5331,138.0092,-46.55875,0,0,1,0,100,0), -- 19:46:21 +(@PATH,10,-200.7831,138.2592,-46.55875,0,0,1,0,100,0), -- 19:46:21 +(@PATH,11,-199.5331,138.5092,-46.55875,0,0,1,0,100,0), -- 19:46:21 +(@PATH,12,-198.5331,138.5092,-47.05875,0,0,1,0,100,0), -- 19:46:21 +(@PATH,13,-198.2273,138.9003,-47.06185,0,0,1,0,100,0), -- 19:46:23 +(@PATH,14,-192.7273,139.1503,-47.06185,0,0,1,0,100,0), -- 19:46:23 +(@PATH,15,-174.9689,143.976,-47.15791,0,0,1,0,100,0), -- 19:46:25 +(@PATH,16,-174.9137,144.2064,-47.1599,0,0,1,0,100,0), -- 19:46:26 +(@PATH,17,-174.1637,144.9564,-47.1599,0,0,1,0,100,0), -- 19:46:26 +(@PATH,18,-174.2672,156.425,-47.16148,0,0,1,0,100,0), -- 19:46:27 +(@PATH,19,-178.1581,166.2433,-47.16,0,0,1,0,100,0), -- 19:46:28 +(@PATH,20,-182.0437,167.7564,-47.15718,0,0,1,0,100,0), -- 19:46:29 +(@PATH,21,-187.5437,168.5064,-47.15718,0,0,1,0,100,0), -- 19:46:29 +(@PATH,22,-198.6023,169.4236,-47.01919,0,0,1,0,100,0), -- 19:46:30 +(@PATH,23,-199.8523,169.4236,-46.26919,0,0,1,0,100,0), -- 19:46:30 +(@PATH,24,-206.3523,169.1736,-44.51919,0,0,1,0,100,0), -- 19:46:30 +(@PATH,25,-208.6023,169.1736,-44.51919,0,0,1,0,100,0), -- 19:46:30 +(@PATH,26,-211.6879,169.1373,-44.53472,0,0,1,0,100,0), -- 19:46:33 +(@PATH,27,-215.1879,168.8873,-44.53472,0,0,1,0,100,0), -- 19:46:33 +(@PATH,28,-219.4723,168.7791,-44.37992,0,0,1,0,100,0), -- 19:46:34 +(@PATH,29,-239.9498,168.602,-44.37992,0,0,1,0,100,0), -- 19:46:37 +(@PATH,30,-246.9581,168.9306,-44.51655,0,0,1,0,100,0), -- 19:46:38 +(@PATH,31,-249.2081,168.9306,-44.51655,0,0,1,0,100,0), -- 19:46:38 +(@PATH,32,-252.4581,169.1806,-45.51655,0,0,1,0,100,0), -- 19:46:38 +(@PATH,33,-255.7081,169.4306,-46.26655,0,0,1,0,100,0), -- 19:46:38 +(@PATH,34,-256.7081,169.4306,-47.01655,0,0,1,0,100,0), -- 19:46:38 +(@PATH,35,-256.8999,169.2992,-47.01842,0,0,1,0,100,0), -- 19:46:39 +(@PATH,36,-260.1499,169.5492,-47.01842,0,0,1,0,100,0), -- 19:46:39 +(@PATH,37,-271.5681,169.6401,-47.15585,0,0,1,0,100,0), -- 19:46:40 +(@PATH,38,-278.7491,167.1944,-47.1574,0,0,1,0,100,0), -- 19:46:41 +(@PATH,39,-281.8345,159.0635,-47.15884,0,0,1,0,100,0), -- 19:46:43 +(@PATH,40,-281.6717,149.2611,-47.15874,0,0,1,0,100,0), -- 19:46:44 +(@PATH,41,-281.4217,147.0111,-47.15874,0,0,1,0,100,0), -- 19:46:44 +(@PATH,42,-280.9217,143.0111,-47.15874,0,0,1,0,100,0), -- 19:46:44 +(@PATH,43,-280.6221,142.876,-47.15683,0,0,1,0,100,0), -- 19:46:45 +(@PATH,44,-280.6221,141.876,-47.15683,0,0,1,0,100,0), -- 19:46:45 +(@PATH,45,-279.6221,141.376,-47.15683,0,0,1,0,100,0), -- 19:46:45 +(@PATH,46,-273.4069,138.0354,-47.15511,0,0,1,0,100,0), -- 19:46:46 +(@PATH,47,-256.2716,137.7599,-46.55902,0,0,1,0,100,0), -- 19:46:47 +(@PATH,48,-251.2716,137.7599,-46.55902,0,0,1,0,100,0), -- 19:46:47 +(@PATH,49,-245.0504,137.672,-46.46387,0,0,1,0,100,0), -- 19:46:50 +(@PATH,50,-230.932,137.3019,-46.46301,0,0,1,0,100,0), -- 19:46:51 +(@PATH,51,-219.4549,136.5503,-46.46327,0,0,1,0,100,0), -- 19:46:52 +(@PATH,52,-212.4549,136.0503,-46.46327,0,0,1,0,100,0), -- 19:46:52 +(@PATH,53,-211.8714,135.753,-46.46384,0,0,1,0,100,0), -- 19:46:54 +(@PATH,54,-211.8714,127.003,-46.46384,0,0,1,0,100,0), -- 19:46:54 +(@PATH,55,-211.7341,126.9009,-46.65929,0,0,1,0,100,0), -- 19:46:55 +(@PATH,56,-211.7341,124.6509,-46.65929,0,0,1,0,100,0), -- 19:46:55 +(@PATH,57,-211.7341,123.6509,-46.65929,0,0,1,0,100,0), -- 19:46:55 +(@PATH,58,-211.7341,119.9009,-46.65929,0,0,1,0,100,0), -- 19:46:55 +(@PATH,59,-211.7341,117.6509,-47.15929,0,0,1,0,100,0), -- 19:46:55 +(@PATH,60,-211.7341,115.1509,-47.65929,0,0,1,0,100,0), -- 19:46:55 +(@PATH,61,-211.6735,112.9518,-47.72739,0,0,1,0,100,0); -- 19:46:57 +-- 0x1C16F408C00701C00059E900030B2760 .go -210.1764 109.2886 -47.71453 + +-- Pathing for Stonevault Ambusher Entry: 7175 'TDB FORMAT' +SET @NPC := 27535; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-260.9756,`position_y`=61.2314,`position_z`=-48.54825 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,-260.9756,61.2314,-48.54825,0,0,1,0,100,0), -- 19:46:55 +(@PATH,2,-279.7831,63.47712,-48.54804,0,0,1,0,100,0), -- 19:46:57 +(@PATH,3,-282.5231,65.95476,-48.55443,0,0,1,0,100,0), -- 19:46:58 +(@PATH,4,-288.7731,67.95476,-48.55443,0,0,1,0,100,0), -- 19:46:58 +(@PATH,5,-293.4806,70.74025,-48.55671,0,0,1,0,100,0), -- 19:47:00 +(@PATH,6,-295.2306,72.99025,-48.55671,0,0,1,0,100,0), -- 19:47:00 +(@PATH,7,-292.8817,80.33412,-48.55592,0,0,1,0,100,0), -- 19:47:01 +(@PATH,8,-288.8817,83.33412,-48.55592,0,0,1,0,100,0), -- 19:47:01 +(@PATH,9,-280.2568,88.74796,-48.5517,0,0,1,0,100,0), -- 19:47:03 +(@PATH,10,-273.2597,91.43516,-48.54511,0,0,1,0,100,0), -- 19:47:05 +(@PATH,11,-256.2809,91.47353,-47.96152,0,0,1,0,100,0), -- 19:47:06 +(@PATH,12,-254.0309,91.47353,-47.96152,0,0,1,0,100,0), -- 19:47:06 +(@PATH,13,-250.0309,91.47353,-47.96152,0,0,1,0,100,0), -- 19:47:06 +(@PATH,14,-246.0933,91.76448,-47.96255,0,0,1,0,100,0), -- 19:47:07 +(@PATH,15,-244.1956,114.8135,-47.86117,0,0,1,0,100,0), -- 19:47:09 +(@PATH,16,-244.0928,116.6703,-47.67337,0,0,1,0,100,0), -- 19:47:11 +(@PATH,17,-244.0928,119.6703,-46.42337,0,0,1,0,100,0), -- 19:47:11 +(@PATH,18,-244.3428,126.6703,-46.42337,0,0,1,0,100,0), -- 19:47:11 +(@PATH,19,-244.2846,127.0505,-46.63219,0,0,1,0,100,0), -- 19:47:12 +(@PATH,20,-251.2605,136.6456,-46.55659,0,0,1,0,100,0), -- 19:47:13 +(@PATH,21,-256.0104,137.6456,-46.55659,0,0,1,0,100,0), -- 19:47:13 +(@PATH,22,-257.2604,137.8956,-47.05659,0,0,1,0,100,0), -- 19:47:13 +(@PATH,23,-259.69,138.2683,-47.05939,0,0,1,0,100,0), -- 19:47:16 +(@PATH,24,-278.1556,142.2052,-47.15575,0,0,1,0,100,0), -- 19:47:17 +(@PATH,25,-278.9056,143.2052,-47.15575,0,0,1,0,100,0), -- 19:47:17 +(@PATH,26,-281.2275,147.3071,-47.15728,0,0,1,0,100,0), -- 19:47:18 +(@PATH,27,-281.9775,148.5571,-47.15728,0,0,1,0,100,0), -- 19:47:18 +(@PATH,28,-277.5583,166.0385,-47.15807,0,0,1,0,100,0), -- 19:47:20 +(@PATH,29,-270.8185,168.1763,-47.15633,0,0,1,0,100,0), -- 19:47:21 +(@PATH,30,-257.0093,169.4798,-47.01865,0,0,1,0,100,0), -- 19:47:23 +(@PATH,31,-256.0093,169.4798,-46.26865,0,0,1,0,100,0), -- 19:47:23 +(@PATH,32,-252.7593,169.4798,-45.51865,0,0,1,0,100,0), -- 19:47:23 +(@PATH,33,-249.2593,169.4798,-44.51865,0,0,1,0,100,0), -- 19:47:23 +(@PATH,34,-247.0093,169.4798,-44.51865,0,0,1,0,100,0), -- 19:47:23 +(@PATH,35,-246.7646,169.5961,-44.52259,0,0,1,0,100,0), -- 19:47:25 +(@PATH,36,-244.5146,169.5961,-44.52259,0,0,1,0,100,0), -- 19:47:25 +(@PATH,37,-240.0146,169.5961,-44.52259,0,0,1,0,100,0), -- 19:47:25 +(@PATH,38,-215.2646,169.3461,-44.52259,0,0,1,0,100,0), -- 19:47:25 +(@PATH,39,-208.8364,169.3836,-44.51604,0,0,1,0,100,0), -- 19:47:29 +(@PATH,40,-206.5864,169.6336,-44.51604,0,0,1,0,100,0), -- 19:47:29 +(@PATH,41,-200.0864,169.8836,-46.26604,0,0,1,0,100,0), -- 19:47:29 +(@PATH,42,-198.8364,169.8836,-47.01604,0,0,1,0,100,0), -- 19:47:29 +(@PATH,43,-197.5312,170.0583,-47.003,0,0,1,0,100,0), -- 19:47:31 +(@PATH,44,-186.4549,169.675,-47.1562,0,0,1,0,100,0), -- 19:47:33 +(@PATH,45,-178.1893,166.1073,-47.15907,0,0,1,0,100,0), -- 19:47:34 +(@PATH,46,-174.5692,160.0448,-47.16045,0,0,1,0,100,0), -- 19:47:35 +(@PATH,47,-177.7394,141.6598,-47.16039,0,0,1,0,100,0), -- 19:47:36 +(@PATH,48,-178.7611,140.6003,-47.15852,0,0,1,0,100,0), -- 19:47:37 +(@PATH,49,-187.544,138.534,-47.15597,0,0,1,0,100,0), -- 19:47:38 +(@PATH,50,-199.6097,138.1275,-46.55952,0,0,1,0,100,0), -- 19:47:40 +(@PATH,51,-200.3597,138.1275,-46.55952,0,0,1,0,100,0), -- 19:47:40 +(@PATH,52,-204.6097,138.1275,-46.55952,0,0,1,0,100,0), -- 19:47:40 +(@PATH,53,-210.2272,138.1704,-46.66569,0,0,1,0,100,0), -- 19:47:41 +(@PATH,54,-219.309,137.7214,-46.46365,0,0,1,0,100,0), -- 19:47:42 +(@PATH,55,-227.5786,137.2641,-46.46313,0,0,1,0,100,0), -- 19:47:43 +(@PATH,56,-241.2292,133.3628,-46.46293,0,0,1,0,100,0), -- 19:47:45 +(@PATH,57,-244.0938,127.9868,-46.65569,0,0,1,0,100,0), -- 19:47:46 +(@PATH,58,-244.0938,126.7368,-46.65569,0,0,1,0,100,0), -- 19:47:46 +(@PATH,59,-244.0938,119.9868,-46.65569,0,0,1,0,100,0), -- 19:47:46 +(@PATH,60,-244.0938,117.7368,-47.15569,0,0,1,0,100,0), -- 19:47:46 +(@PATH,61,-244.1458,117.4128,-47.17364,0,0,1,0,100,0), -- 19:47:47 +(@PATH,62,-244.1458,115.9128,-47.67364,0,0,1,0,100,0), -- 19:47:47 +(@PATH,63,-243.8958,107.6628,-47.67364,0,0,1,0,100,0), -- 19:47:47 +(@PATH,64,-244.0653,104.803,-47.8754,0,0,1,0,100,0), -- 19:47:50 +(@PATH,65,-249.939,90.39037,-47.9633,0,0,1,0,100,0), -- 19:47:51 +(@PATH,66,-253.939,90.64037,-47.9633,0,0,1,0,100,0), -- 19:47:51 +(@PATH,67,-256.189,90.64037,-47.9633,0,0,1,0,100,0), -- 19:47:51 +(@PATH,68,-257.189,90.64037,-48.4633,0,0,1,0,100,0), -- 19:47:51 +(@PATH,69,-261.1644,90.57747,-48.46085,0,0,1,0,100,0), -- 19:47:53 +(@PATH,70,-278.2355,87.77667,-48.54754,0,0,1,0,100,0), -- 19:47:54 +(@PATH,71,-282.5812,77.72125,-48.55171,0,0,1,0,100,0), -- 19:47:56 +(@PATH,72,-282.8312,75.47125,-48.55171,0,0,1,0,100,0), -- 19:47:56 +(@PATH,73,-283.0587,72.90546,-48.55147,0,0,1,0,100,0), -- 19:47:57 +(@PATH,74,-280.5587,63.15546,-48.55147,0,0,1,0,100,0), -- 19:47:57 +(@PATH,75,-279.8492,62.23659,-48.55054,0,0,1,0,100,0); -- 19:47:58 +-- 0x1C16F408C00701C00059E900038B2760 .go -260.9756 61.2314 -48.54825 + +-- Pathing for Shrike Bat Entry: 4861 'TDB FORMAT' +SET @NPC := 30081; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-116.1971,`position_y`=317.7787,`position_z`=-46.08444 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,-116.1971,317.7787,-46.08444,0,0,0,0,100,0), -- 19:46:24 +(@PATH,2,-118.9047,317.3614,-45.29679,0,0,0,0,100,0), -- 19:46:29 +(@PATH,3,-126.8644,318.512,-44.13009,0,0,0,0,100,0), -- 19:46:31 +(@PATH,4,-131.6838,323.5452,-43.69198,0,0,0,0,100,0), -- 19:46:33 +(@PATH,5,-133.1838,326.0452,-43.94198,0,0,0,0,100,0), -- 19:46:33 +(@PATH,6,-134.4338,328.2952,-44.19198,0,0,0,0,100,0), -- 19:46:33 +(@PATH,7,-139.5984,330.833,-44.22396,0,0,0,0,100,0), -- 19:46:38 +(@PATH,8,-141.3152,330.4821,-44.35117,0,0,0,0,100,0), -- 19:46:41 +(@PATH,9,-145.4463,327.2668,-46.04215,0,0,0,0,100,0), -- 19:46:43 +(@PATH,10,-153.1682,320.1992,-48.49626,0,0,0,0,100,0), -- 19:46:46 +(@PATH,11,-157.6236,320.5594,-49.23671,0,0,0,0,100,0), -- 19:46:48 +(@PATH,12,-163.7113,322.522,-50.1132,0,0,0,0,100,0), -- 19:46:52 +(@PATH,13,-172.0462,323.2635,-51.23209,0,0,0,0,100,0), -- 19:46:54 +(@PATH,14,-173.7962,323.2635,-51.48209,0,0,0,0,100,0), -- 19:46:54 +(@PATH,15,-177.0651,319.9081,-52.49401,0,0,0,0,100,0), -- 19:46:58 +(@PATH,16,-179.3571,312.8132,-52.80653,0,0,0,0,100,0), -- 19:47:01 +(@PATH,17,-179.3571,311.8132,-52.80653,0,0,0,0,100,0), -- 19:47:01 +(@PATH,18,-181.0257,301.3842,-50.73584,0,0,0,0,100,0), -- 19:47:05 +(@PATH,19,-183.2724,293.4999,-48.85449,0,0,0,0,100,0), -- 19:47:09 +(@PATH,20,-183.7724,292.4999,-48.60449,0,0,0,0,100,0), -- 19:47:09 +(@PATH,21,-184.433,290.7685,-48.27169,0,0,0,0,100,0), -- 19:47:11 +(@PATH,22,-184.683,289.2685,-47.77169,0,0,0,0,100,0), -- 19:47:11 +(@PATH,23,-184.933,288.0185,-47.52169,0,0,0,0,100,0), -- 19:47:11 +(@PATH,24,-187.3712,282.3932,-47.8597,0,0,0,0,100,0), -- 19:47:14 +(@PATH,25,-187.4142,282.2362,-47.91491,0,0,0,0,100,0), -- 19:47:19 +(@PATH,26,-185.3188,287.8494,-47.45733,0,0,0,0,100,0), -- 19:47:21 +(@PATH,27,-185.0688,289.0994,-47.70733,0,0,0,0,100,0), -- 19:47:21 +(@PATH,28,-184.179,290.8317,-48.2381,0,0,0,0,100,0), -- 19:47:23 +(@PATH,29,-183.679,292.5817,-48.4881,0,0,0,0,100,0), -- 19:47:23 +(@PATH,30,-183.429,293.3317,-48.7381,0,0,0,0,100,0), -- 19:47:23 +(@PATH,31,-182.929,295.3317,-49.9881,0,0,0,0,100,0), -- 19:47:23 +(@PATH,32,-180.9205,303.2869,-51.47765,0,0,0,0,100,0), -- 19:47:27 +(@PATH,33,-179.3741,312.776,-52.76653,0,0,0,0,100,0), -- 19:47:31 +(@PATH,34,-179.1241,314.276,-52.76653,0,0,0,0,100,0), -- 19:47:31 +(@PATH,35,-177.1773,319.9679,-52.64116,0,0,0,0,100,0), -- 19:47:34 +(@PATH,36,-176.4273,322.2179,-52.14116,0,0,0,0,100,0), -- 19:47:34 +(@PATH,37,-173.9601,323.1776,-51.58164,0,0,0,0,100,0), -- 19:47:38 +(@PATH,38,-172.4601,323.4276,-51.58164,0,0,0,0,100,0), -- 19:47:38 +(@PATH,39,-167.9601,323.6776,-50.83164,0,0,0,0,100,0), -- 19:47:38 +(@PATH,40,-163.9189,322.6101,-50.14185,0,0,0,0,100,0), -- 19:47:41 +(@PATH,41,-162.9189,322.3601,-49.64185,0,0,0,0,100,0), -- 19:47:41 +(@PATH,42,-158.5166,320.7068,-49.43653,0,0,0,0,100,0), -- 19:47:44 +(@PATH,43,-149.9316,322.1074,-48.67955,0,0,0,0,100,0), -- 19:47:46 +(@PATH,44,-145.6857,327.386,-45.98837,0,0,0,0,100,0), -- 19:47:50 +(@PATH,45,-141.4396,330.4873,-44.44178,0,0,0,0,100,0), -- 19:47:52 +(@PATH,46,-139.9884,330.9608,-44.31651,0,0,0,0,100,0), -- 19:47:55 +(@PATH,47,-131.8122,323.8088,-43.84772,0,0,0,0,100,0), -- 19:47:57 +(@PATH,48,-129.3122,319.8088,-44.34772,0,0,0,0,100,0), -- 19:47:57 +(@PATH,49,-127.2311,318.8854,-44.18322,0,0,0,0,100,0), -- 19:48:01 +(@PATH,50,-123.7311,317.3854,-44.43322,0,0,0,0,100,0), -- 19:48:01 +(@PATH,51,-119.1036,317.5869,-45.31766,0,0,0,0,100,0); -- 19:48:03 +-- 0x1C16F408C004BF400059E900000B2760 .go -116.1971 317.7787 -46.08444 + +-- Pathing for Shrike Bat Entry: 4861 'TDB FORMAT' +SET @NPC := 33522; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-34.35824,`position_y`=349.1816,`position_z`=-44.71794 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,-34.35824,349.1816,-44.71794,0,0,0,0,100,0), -- 19:54:43 +(@PATH,2,-39.45177,352.6617,-46.25263,0,0,0,0,100,0), -- 19:54:48 +(@PATH,3,-41.51308,355.655,-46.53062,0,0,0,0,100,0), -- 19:54:52 +(@PATH,4,-43.01308,359.905,-47.28062,0,0,0,0,100,0), -- 19:54:52 +(@PATH,5,-44.79412,364.367,-48.26569,0,0,0,0,100,0), -- 19:54:55 +(@PATH,6,-45.79412,367.367,-48.51569,0,0,0,0,100,0), -- 19:54:55 +(@PATH,7,-48.12923,369.0743,-49.55631,0,0,0,0,100,0), -- 19:54:57 +(@PATH,8,-49.62923,369.5743,-49.80631,0,0,0,0,100,0), -- 19:54:57 +(@PATH,9,-58.34222,370.8102,-50.34889,0,0,0,0,100,0), -- 19:55:02 +(@PATH,10,-64.80667,367.5034,-50.34549,0,0,0,0,100,0), -- 19:55:05 +(@PATH,11,-71.09432,360.0078,-51.03568,0,0,0,0,100,0), -- 19:55:08 +(@PATH,12,-72.84432,359.0078,-51.28568,0,0,0,0,100,0), -- 19:55:08 +(@PATH,13,-77.36659,356.679,-50.97245,0,0,0,0,100,0), -- 19:55:12 +(@PATH,14,-79.61659,355.929,-50.72245,0,0,0,0,100,0), -- 19:55:12 +(@PATH,15,-83.36659,354.429,-50.97245,0,0,0,0,100,0), -- 19:55:12 +(@PATH,16,-85.8164,353.4018,-50.05049,0,0,0,0,100,0), -- 19:55:16 +(@PATH,17,-90.8164,351.9018,-49.30049,0,0,0,0,100,0), -- 19:55:16 +(@PATH,18,-99.78505,351.1479,-48.29544,0,0,0,0,100,0), -- 19:55:20 +(@PATH,19,-102.785,351.3979,-48.29544,0,0,0,0,100,0), -- 19:55:20 +(@PATH,20,-96.03415,350.9953,-48.6471,0,0,0,0,100,0), -- 19:55:27 +(@PATH,21,-86.49751,353.2874,-49.41515,0,0,0,0,100,0), -- 19:55:31 +(@PATH,22,-84.99751,353.7874,-50.41515,0,0,0,0,100,0), -- 19:55:31 +(@PATH,23,-84.28488,354.1664,-50.5457,0,0,0,0,100,0), -- 19:55:35 +(@PATH,24,-79.78488,355.6664,-50.5457,0,0,0,0,100,0), -- 19:55:35 +(@PATH,25,-77.28488,356.6664,-50.7957,0,0,0,0,100,0), -- 19:55:35 +(@PATH,26,-71.36815,359.9686,-51.01308,0,0,0,0,100,0), -- 19:55:40 +(@PATH,27,-68.36815,361.9686,-50.76308,0,0,0,0,100,0), -- 19:55:40 +(@PATH,28,-65.49499,366.807,-50.34712,0,0,0,0,100,0), -- 19:55:44 +(@PATH,29,-58.40037,370.9284,-50.30991,0,0,0,0,100,0), -- 19:55:46 +(@PATH,30,-57.15037,371.1784,-50.30991,0,0,0,0,100,0), -- 19:55:46 +(@PATH,31,-55.87487,371.4779,-50.10828,0,0,0,0,100,0), -- 19:55:50 +(@PATH,32,-50.62487,369.9779,-49.85828,0,0,0,0,100,0), -- 19:55:50 +(@PATH,33,-48.12487,369.4779,-49.60828,0,0,0,0,100,0), -- 19:55:50 +(@PATH,34,-45.93803,367.2723,-48.61888,0,0,0,0,100,0), -- 19:55:53 +(@PATH,35,-44.93803,364.7723,-48.36888,0,0,0,0,100,0), -- 19:55:53 +(@PATH,36,-43.17387,359.995,-47.31218,0,0,0,0,100,0), -- 19:55:56 +(@PATH,37,-41.67387,356.745,-46.56218,0,0,0,0,100,0), -- 19:55:56 +(@PATH,38,-35.86934,350.4595,-45.71741,0,0,0,0,100,0); -- 19:56:01 +-- 0x1C16F408C004BF400059E900000B2761 .go -34.35824 349.1816 -44.71794 + +-- Pathing for Shrike Bat Entry: 4861 'TDB FORMAT' +SET @NPC := 30085; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-142.7949,`position_y`=225.2512,`position_z`=-45.7625 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,-142.7949,225.2512,-45.7625,0,0,0,0,100,0), -- 19:46:47 +(@PATH,2,-136.7979,229.3257,-47.20895,0,0,0,0,100,0), -- 19:46:54 +(@PATH,3,-135.2979,230.3257,-47.45895,0,0,0,0,100,0), -- 19:46:54 +(@PATH,4,-133.7979,231.3257,-47.20895,0,0,0,0,100,0), -- 19:46:54 +(@PATH,5,-132.9678,231.759,-47.66918,0,0,0,0,100,0), -- 19:46:58 +(@PATH,6,-130.4678,233.759,-47.66918,0,0,0,0,100,0), -- 19:46:58 +(@PATH,7,-124.7075,239.272,-48.10035,0,0,0,0,100,0), -- 19:47:01 +(@PATH,8,-122.997,243.3047,-47.74892,0,0,0,0,100,0), -- 19:47:04 +(@PATH,9,-122.2632,250.6377,-48.21873,0,0,0,0,100,0), -- 19:47:06 +(@PATH,10,-122.0635,253.1956,-47.99726,0,0,0,0,100,0), -- 19:47:09 +(@PATH,11,-124.687,265.2274,-46.29008,0,0,0,0,100,0), -- 19:47:11 +(@PATH,12,-125.7654,267.4338,-45.58253,0,0,0,0,100,0), -- 19:47:15 +(@PATH,13,-126.7654,270.4338,-45.58253,0,0,0,0,100,0), -- 19:47:15 +(@PATH,14,-127.0154,271.6838,-45.58253,0,0,0,0,100,0), -- 19:47:15 +(@PATH,15,-128.2654,275.6838,-45.83253,0,0,0,0,100,0), -- 19:47:15 +(@PATH,16,-129.7654,280.1838,-45.58253,0,0,0,0,100,0), -- 19:47:15 +(@PATH,17,-132.0325,283.5439,-45.71447,0,0,0,0,100,0), -- 19:47:21 +(@PATH,18,-133.5325,285.2939,-45.96447,0,0,0,0,100,0), -- 19:47:21 +(@PATH,19,-134.5325,286.5439,-45.96447,0,0,0,0,100,0), -- 19:47:21 +(@PATH,20,-135.2825,287.5439,-45.71447,0,0,0,0,100,0), -- 19:47:21 +(@PATH,21,-136.0218,288.4235,-45.95388,0,0,0,0,100,0), -- 19:47:24 +(@PATH,22,-139.2718,292.4235,-45.95388,0,0,0,0,100,0), -- 19:47:24 +(@PATH,23,-140.0702,299.2286,-46.03945,0,0,0,0,100,0), -- 19:47:27 +(@PATH,24,-140.2864,299.1003,-45.87361,0,0,0,0,100,0), -- 19:47:32 +(@PATH,25,-139.1992,292.5916,-45.83009,0,0,0,0,100,0), -- 19:47:33 +(@PATH,26,-133.8004,285.6141,-45.93703,0,0,0,0,100,0), -- 19:47:37 +(@PATH,27,-132.0504,283.6141,-45.68703,0,0,0,0,100,0), -- 19:47:37 +(@PATH,28,-129.9505,280.1571,-45.59953,0,0,0,0,100,0), -- 19:47:39 +(@PATH,29,-128.7005,275.6571,-45.84953,0,0,0,0,100,0), -- 19:47:39 +(@PATH,30,-127.2005,271.6571,-45.59953,0,0,0,0,100,0), -- 19:47:39 +(@PATH,31,-126.7005,270.4071,-45.59953,0,0,0,0,100,0), -- 19:47:39 +(@PATH,32,-125.7005,267.4071,-45.59953,0,0,0,0,100,0), -- 19:47:39 +(@PATH,33,-123.5866,262.6984,-47.1854,0,0,0,0,100,0), -- 19:47:46 +(@PATH,34,-122.0696,253.5793,-48.02232,0,0,0,0,100,0), -- 19:47:50 +(@PATH,35,-122.1644,250.7279,-48.18776,0,0,0,0,100,0), -- 19:47:52 +(@PATH,36,-122.1644,248.4779,-48.18776,0,0,0,0,100,0), -- 19:47:52 +(@PATH,37,-122.9575,243.5141,-47.85612,0,0,0,0,100,0), -- 19:47:55 +(@PATH,38,-127.747,236.1646,-47.66065,0,0,0,0,100,0), -- 19:47:57 +(@PATH,39,-130.1325,234.0169,-47.69135,0,0,0,0,100,0), -- 19:48:00 +(@PATH,40,-136.8559,229.2036,-47.26409,0,0,0,0,100,0), -- 19:48:02 +(@PATH,41,-138.6059,227.9536,-46.76409,0,0,0,0,100,0); -- 19:48:02 +-- 0x1C16F408C004BF400059E900010B2760 .go -142.7949 225.2512 -45.7625 + +-- Pathing for Stone Steward Entry: 4860 'TDB FORMAT' +SET @NPC := 28365; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=157.359,`position_y`=278.6508,`position_z`=-26.48766 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,157.359,278.6508,-26.48766,0,0,0,0,100,0), -- 19:58:53 +(@PATH,2,158.1053,277.0509,-26.33149,0,0,0,0,100,0), -- 19:59:03 +(@PATH,3,159.3106,274.6482,-26.47079,0,0,0,0,100,0), -- 19:59:10 +(@PATH,4,161.3106,270.6482,-27.72079,0,0,0,0,100,0), -- 19:59:10 +(@PATH,5,162.0606,268.6482,-28.22079,0,0,0,0,100,0), -- 19:59:10 +(@PATH,6,162.5606,267.6482,-28.97079,0,0,0,0,100,0), -- 19:59:10 +(@PATH,7,169.1669,252.4363,-29.11036,0,0,0,0,100,0), -- 19:59:20 +(@PATH,8,170.2946,247.0149,-29.11045,0,0,0,0,100,0), -- 19:59:22 +(@PATH,9,141.0065,231.4473,-42.17465,0,0,0,0,100,0), -- 19:59:26 +(@PATH,10,135.2668,228.6892,-42.44057,0,0,0,0,100,0), -- 19:59:38 +(@PATH,11,126.2668,224.4392,-42.44057,0,0,0,0,100,0), -- 19:59:38 +(@PATH,12,125.0168,223.9392,-42.44057,0,0,0,0,100,0), -- 19:59:38 +(@PATH,13,117.7668,220.4392,-42.44057,0,0,0,0,100,0), -- 19:59:38 +(@PATH,14,115.0168,219.1892,-42.44057,0,0,0,0,100,0), -- 19:59:38 +(@PATH,15,112.5168,217.9392,-42.44057,0,0,0,0,100,0), -- 19:59:38 +(@PATH,16,111.5168,217.4392,-42.44057,0,0,0,0,100,0), -- 19:59:38 +(@PATH,17,110.6416,216.7866,-42.73357,0,0,0,0,100,0), -- 19:59:50 +(@PATH,18,91.14159,207.5366,-54.48357,0,0,0,0,100,0), -- 19:59:50 +(@PATH,19,89.71228,206.7954,-54.72824,0,0,0,0,100,0), -- 20:00:01 +(@PATH,20,81.51923,204.1784,-54.72749,0,0,0,0,100,0), -- 20:00:03 +(@PATH,21,70.45786,225.8585,-53.83768,0,0,0,0,100,0), -- 20:00:07 +(@PATH,22,67.45786,231.8585,-52.08768,0,0,0,0,100,0), -- 20:00:07 +(@PATH,23,66.45786,233.8585,-52.08768,0,0,0,0,100,0), -- 20:00:07 +(@PATH,24,65.99206,234.5262,-51.94806,0,0,0,0,100,0), -- 20:00:18 +(@PATH,25,57.07329,252.1399,-51.94805,0,0,0,0,100,0), -- 20:00:25 +(@PATH,26,56.98771,251.7677,-52.19805,0,0,0,0,100,0), -- 20:00:31 +(@PATH,27,57.20819,251.6948,-51.94805,0,0,0,0,100,0), -- 20:00:32 +(@PATH,28,70.53458,225.9198,-53.83727,0,0,0,0,100,0), -- 20:00:41 +(@PATH,29,71.03458,224.9198,-54.58727,0,0,0,0,100,0), -- 20:00:41 +(@PATH,30,78.36176,210.3076,-54.72746,0,0,0,0,100,0), -- 20:00:52 +(@PATH,31,81.43523,204.0119,-54.72772,0,0,0,0,100,0), -- 20:00:54 +(@PATH,32,91.10306,207.5477,-54.68492,0,0,0,0,100,0), -- 20:00:58 +(@PATH,33,115.051,219.2345,-42.26912,0,0,0,0,100,0), -- 20:01:09 +(@PATH,34,117.551,220.4845,-42.26912,0,0,0,0,100,0), -- 20:01:09 +(@PATH,35,124.801,223.7345,-42.26912,0,0,0,0,100,0), -- 20:01:09 +(@PATH,36,126.301,224.4845,-42.26912,0,0,0,0,100,0), -- 20:01:09 +(@PATH,37,135.301,228.7345,-42.26912,0,0,0,0,100,0), -- 20:01:09 +(@PATH,38,141.7687,232.0445,-42.17444,0,0,0,0,100,0), -- 20:01:21 +(@PATH,39,163.1443,242.3607,-29.2016,0,0,0,0,100,0), -- 20:01:33 +(@PATH,40,170.1688,247.0374,-29.11083,0,0,0,0,100,0), -- 20:01:37 +(@PATH,41,162.2002,268.689,-28.2213,0,0,0,0,100,0), -- 20:01:39 +(@PATH,42,161.2002,270.689,-27.7213,0,0,0,0,100,0), -- 20:01:39 +(@PATH,43,159.4502,274.689,-26.4713,0,0,0,0,100,0), -- 20:01:39 +(@PATH,44,158.2711,277.0461,-26.35968,0,0,0,0,100,0); -- 20:01:49 +-- 0x1C16F408C004BF000059E900020B2760 .go 157.359 278.6508 -26.48766 + +-- Pathing for Stone Steward Entry: 4860 'TDB FORMAT' +SET @NPC := 27473; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-15.69449,`position_y`=279.0179,`position_z`=-47.67377 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,-15.69449,279.0179,-47.67377,0,0,0,0,100,0), -- 19:46:43 +(@PATH,2,-20.67551,276.4372,-47.63821,0,0,0,0,100,0), -- 19:46:46 +(@PATH,3,-21.52459,276.0081,-47.67233,0,0,0,0,100,0), -- 19:46:47 +(@PATH,4,-24.52459,275.5081,-47.92233,0,0,0,0,100,0), -- 19:46:47 +(@PATH,5,-25.77459,275.0081,-47.92233,0,0,0,0,100,0), -- 19:46:47 +(@PATH,6,-34.79898,273.5978,-48.29856,0,0,0,0,100,0), -- 19:46:51 +(@PATH,7,-36.04898,273.5978,-48.29856,0,0,0,0,100,0), -- 19:46:51 +(@PATH,8,-38.79898,273.0978,-48.54856,0,0,0,0,100,0), -- 19:46:51 +(@PATH,9,-39.34219,272.8535,-48.79059,0,0,0,0,100,0), -- 19:46:56 +(@PATH,10,-41.08632,250.9034,-48.67182,0,0,0,0,100,0), -- 19:47:00 +(@PATH,11,-41.49896,245.6531,-48.172,0,0,0,0,100,0), -- 19:47:05 +(@PATH,12,-41.49896,242.6531,-48.172,0,0,0,0,100,0), -- 19:47:05 +(@PATH,13,-41.49896,241.4031,-48.172,0,0,0,0,100,0), -- 19:47:05 +(@PATH,14,-41.85809,240.7104,-48.07686,0,0,0,0,100,0), -- 19:47:08 +(@PATH,15,-53.59785,238.2883,-48.27911,0,0,0,0,100,0), -- 19:47:12 +(@PATH,16,-59.84785,238.2883,-48.02911,0,0,0,0,100,0), -- 19:47:12 +(@PATH,17,-62.09785,238.2883,-48.77911,0,0,0,0,100,0), -- 19:47:12 +(@PATH,18,-64.84785,238.2883,-49.27911,0,0,0,0,100,0), -- 19:47:12 +(@PATH,19,-59.91378,238.0276,-48.03023,0,0,0,0,100,0), -- 19:47:20 +(@PATH,20,-53.66378,238.0276,-48.28023,0,0,0,0,100,0), -- 19:47:20 +(@PATH,21,-52.16378,238.0276,-48.28023,0,0,0,0,100,0), -- 19:47:20 +(@PATH,22,-49.32967,238.2136,-48.07516,0,0,0,0,100,0), -- 19:47:25 +(@PATH,23,-41.65893,245.4057,-48.07581,0,0,0,0,100,0), -- 19:47:29 +(@PATH,24,-41.10932,250.7121,-48.67118,0,0,0,0,100,0), -- 19:47:33 +(@PATH,25,-40.51412,262.4556,-48.76871,0,0,0,0,100,0), -- 19:47:37 +(@PATH,26,-34.8937,273.3388,-48.22985,0,0,0,0,100,0), -- 19:47:42 +(@PATH,27,-32.8937,273.5888,-48.47985,0,0,0,0,100,0), -- 19:47:42 +(@PATH,28,-24.87062,275.2746,-47.7992,0,0,0,0,100,0), -- 19:47:46 +(@PATH,29,-22.12062,275.7746,-47.7992,0,0,0,0,100,0), -- 19:47:46 +(@PATH,30,-18.17185,277.6628,-47.70597,0,0,0,0,100,0); -- 19:47:50 +-- 0x1C16F408C004BF000059E900028B2760 .go -15.69449 279.0179 -47.67377 + +-- Pathing for Stone Steward Entry: 4860 'TDB FORMAT' +SET @NPC := 27472; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-90.22527,`position_y`=312.3529,`position_z`=-50.81741 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,-90.22527,312.3529,-50.81741,0,0,0,0,100,0), -- 19:46:26 +(@PATH,2,-89.75098,303.8569,-50.53365,0,0,0,0,100,0), -- 19:46:32 +(@PATH,3,-89.58408,299.2126,-49.18354,0,0,0,0,100,0), -- 19:46:37 +(@PATH,4,-89.58408,298.2126,-48.93354,0,0,0,0,100,0), -- 19:46:37 +(@PATH,5,-89.58408,293.9626,-47.43354,0,0,0,0,100,0), -- 19:46:37 +(@PATH,6,-89.33408,291.7126,-47.43354,0,0,0,0,100,0), -- 19:46:37 +(@PATH,7,-89.01637,285.0681,-47.38007,0,0,0,0,100,0), -- 19:46:43 +(@PATH,8,-89.01088,254.6502,-47.48074,0,0,0,0,100,0), -- 19:46:50 +(@PATH,9,-89.01088,251.4002,-47.48074,0,0,0,0,100,0), -- 19:46:50 +(@PATH,10,-88.93411,260.2717,-47.48082,0,0,0,0,100,0), -- 19:46:58 +(@PATH,11,-89.04137,285.1695,-47.38035,0,0,0,0,100,0), -- 19:47:03 +(@PATH,12,-89.46567,293.7497,-47.41035,0,0,0,0,100,0), -- 19:47:12 +(@PATH,13,-89.46567,298.2497,-48.91035,0,0,0,0,100,0), -- 19:47:12 +(@PATH,14,-89.46567,299.2497,-49.16035,0,0,0,0,100,0), -- 19:47:12 +(@PATH,15,-90.22608,307.6347,-50.82426,0,0,0,0,100,0); -- 19:47:18 +-- 0x1C16F408C004BF000059E900030B2760 .go -90.22527 312.3529 -50.81741 + +-- Pathing for Stone Steward Entry: 4860 'TDB FORMAT' +SET @NPC := 27471; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-107.2204,`position_y`=202.1764,`position_z`=-40.99639 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,-107.2204,202.1764,-40.99639,0,0,0,0,100,0), -- 19:50:58 +(@PATH,2,-106.9112,202.3231,-40.72182,0,0,0,0,100,0), -- 19:50:59 +(@PATH,3,-102.3103,204.8115,-39.65949,0,0,0,0,100,0), -- 19:51:00 +(@PATH,4,-97.74992,214.5336,-41.63697,0,0,0,0,100,0), -- 19:51:03 +(@PATH,5,-96.3933,219.4432,-43.16748,0,0,0,0,100,0), -- 19:51:06 +(@PATH,6,-93.05585,222.2282,-44.29628,0,0,0,0,100,0), -- 19:51:08 +(@PATH,7,-91.30585,222.4782,-45.79628,0,0,0,0,100,0), -- 19:51:08 +(@PATH,8,-89.56384,221.7615,-46.28793,0,0,0,0,100,0), -- 19:51:11 +(@PATH,9,-88.31384,220.2615,-46.03793,0,0,0,0,100,0), -- 19:51:11 +(@PATH,10,-84.37595,219.1314,-47.14322,0,0,0,0,100,0), -- 19:51:14 +(@PATH,11,-82.37595,219.8814,-48.39322,0,0,0,0,100,0), -- 19:51:14 +(@PATH,12,-79.37595,220.6314,-49.39322,0,0,0,0,100,0), -- 19:51:14 +(@PATH,13,-76.82669,224.0322,-49.37569,0,0,0,0,100,0), -- 19:51:17 +(@PATH,14,-75.57669,227.0322,-49.37569,0,0,0,0,100,0), -- 19:51:17 +(@PATH,15,-74.57669,229.2822,-49.37569,0,0,0,0,100,0), -- 19:51:17 +(@PATH,16,-71.33888,233.2636,-49.4961,0,0,0,0,100,0), -- 19:51:22 +(@PATH,17,-65.08888,237.0136,-49.4961,0,0,0,0,100,0), -- 19:51:22 +(@PATH,18,-62.24201,238.0235,-48.78309,0,0,0,0,100,0), -- 19:51:27 +(@PATH,19,-59.99201,238.2735,-48.03309,0,0,0,0,100,0), -- 19:51:27 +(@PATH,20,-53.99201,238.5235,-48.03309,0,0,0,0,100,0), -- 19:51:27 +(@PATH,21,-52.93201,238.7369,-48.07719,0,0,0,0,100,0), -- 19:51:32 +(@PATH,22,-43.56981,231.3157,-48.09142,0,0,0,0,100,0), -- 19:51:35 +(@PATH,23,-42.54251,216.3974,-48.08791,0,0,0,0,100,0), -- 19:51:40 +(@PATH,24,-42.79251,212.3974,-48.08791,0,0,0,0,100,0), -- 19:51:40 +(@PATH,25,-45.2256,206.4191,-48.07826,0,0,0,0,100,0), -- 19:51:46 +(@PATH,26,-45.29718,206.2893,-48.07718,0,0,0,0,100,0), -- 19:51:51 +(@PATH,27,-42.43665,216.1878,-48.09149,0,0,0,0,100,0), -- 19:51:54 +(@PATH,28,-42.18665,219.1878,-48.09149,0,0,0,0,100,0), -- 19:51:54 +(@PATH,29,-43.43148,231.2084,-48.08014,0,0,0,0,100,0), -- 19:51:58 +(@PATH,30,-52.35088,238.3348,-48.08712,0,0,0,0,100,0), -- 19:52:03 +(@PATH,31,-59.86867,238.2005,-48.0407,0,0,0,0,100,0), -- 19:52:08 +(@PATH,32,-62.11867,237.9505,-48.7907,0,0,0,0,100,0), -- 19:52:08 +(@PATH,33,-65.00171,237.1759,-49.39082,0,0,0,0,100,0), -- 19:52:12 +(@PATH,34,-71.50171,233.1759,-49.39082,0,0,0,0,100,0), -- 19:52:12 +(@PATH,35,-74.66057,229.2685,-49.48391,0,0,0,0,100,0), -- 19:52:17 +(@PATH,36,-75.16057,227.0185,-49.48391,0,0,0,0,100,0), -- 19:52:17 +(@PATH,37,-76.66057,224.0185,-49.48391,0,0,0,0,100,0), -- 19:52:17 +(@PATH,38,-77.41057,221.7685,-49.48391,0,0,0,0,100,0), -- 19:52:17 +(@PATH,39,-79.18384,220.6745,-49.24834,0,0,0,0,100,0), -- 19:52:22 +(@PATH,40,-82.18384,219.6745,-48.24834,0,0,0,0,100,0), -- 19:52:22 +(@PATH,41,-83.43384,219.4245,-47.49834,0,0,0,0,100,0), -- 19:52:22 +(@PATH,42,-89.23185,221.8512,-46.51452,0,0,0,0,100,0), -- 19:52:25 +(@PATH,43,-92.72166,222.22,-44.23815,0,0,0,0,100,0), -- 19:52:27 +(@PATH,44,-94.97166,221.72,-43.73815,0,0,0,0,100,0), -- 19:52:27 +(@PATH,45,-96.1684,219.4541,-43.43246,0,0,0,0,100,0), -- 19:52:30 +(@PATH,46,-98.76186,211.6802,-40.79076,0,0,0,0,100,0), -- 19:52:32 +(@PATH,47,-102.1261,204.7718,-39.52556,0,0,0,0,100,0), -- 19:52:36 +(@PATH,48,-103.2557,203.5211,-39.62801,0,0,0,0,100,0); -- 19:52:39 +-- 0x1C16F408C004BF000059E900038B2760 .go -107.2204 202.1764 -40.99639 + +-- Pathing for Stonevault Brawler Entry: 4855 'TDB FORMAT' +SET @NPC := 30106; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=9.185728,`position_y`=361.806,`position_z`=-42.52501 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,9.185728,361.806,-42.52501,0,0,0,0,100,0), -- 19:55:52 +(@PATH,2,10.68573,361.306,-42.77501,0,0,0,0,100,0), -- 19:55:52 +(@PATH,3,11.68573,361.056,-43.02501,0,0,0,0,100,0), -- 19:55:52 +(@PATH,4,14.93573,360.306,-43.27501,0,0,0,0,100,0), -- 19:55:52 +(@PATH,5,16.43573,360.056,-43.27501,0,0,0,0,100,0), -- 19:55:52 +(@PATH,6,17.27649,359.817,-43.0314,0,0,0,0,100,0), -- 19:55:56 +(@PATH,7,21.02649,359.317,-42.7814,0,0,0,0,100,0), -- 19:55:56 +(@PATH,8,22.77649,359.067,-42.5314,0,0,0,0,100,0), -- 19:55:56 +(@PATH,9,30.55592,356.7866,-42.15283,0,0,0,0,100,0), -- 19:56:01 +(@PATH,10,35.82129,353.2513,-42.55444,0,0,0,0,100,0), -- 19:56:03 +(@PATH,11,38.37708,347.7673,-42.24792,0,0,0,0,100,0), -- 19:56:05 +(@PATH,12,38.87708,346.7673,-41.99792,0,0,0,0,100,0), -- 19:56:05 +(@PATH,13,40.62708,342.7673,-42.24792,0,0,0,0,100,0), -- 19:56:05 +(@PATH,14,39.82348,338.4128,-42.98926,0,0,0,0,100,0), -- 19:56:09 +(@PATH,15,34.19891,331.8911,-42.67289,0,0,0,0,100,0), -- 19:56:13 +(@PATH,16,33.44891,331.1411,-42.17289,0,0,0,0,100,0), -- 19:56:13 +(@PATH,17,31.19891,329.6411,-41.92289,0,0,0,0,100,0), -- 19:56:13 +(@PATH,18,27.54275,327.8886,-40.85126,0,0,0,0,100,0), -- 19:56:18 +(@PATH,19,20.32842,326.7422,-39.95414,0,0,0,0,100,0), -- 19:56:19 +(@PATH,20,19.07842,326.4922,-39.95414,0,0,0,0,100,0), -- 19:56:19 +(@PATH,21,9.621592,325.83,-38.5783,0,0,0,0,100,0), -- 19:56:23 +(@PATH,22,7.871592,325.83,-38.3283,0,0,0,0,100,0), -- 19:56:23 +(@PATH,23,9.734783,325.8379,-38.52752,0,0,0,0,100,0), -- 19:56:27 +(@PATH,24,13.93066,326.2504,-38.2508,0,0,0,0,100,0), -- 19:56:31 +(@PATH,25,22.48125,319.4749,-39.35741,0,0,0,0,100,0), -- 19:56:32 +(@PATH,26,26.9873,314.6351,-39.25242,0,0,0,0,100,0), -- 19:56:37 +(@PATH,27,27.76221,314.1161,-39.14816,0,0,0,0,100,0), -- 19:56:38 +(@PATH,28,37.06132,309.7848,-38.86451,0,0,0,0,100,0), -- 19:56:41 +(@PATH,29,41.82753,309.0237,-39.42388,0,0,0,0,100,0), -- 19:56:43 +(@PATH,30,43.02345,310.306,-39.93136,0,0,0,0,100,0), -- 19:56:44 +(@PATH,31,43.73434,313.0781,-41.1359,0,0,0,0,100,0), -- 19:56:45 +(@PATH,32,43.48434,313.8281,-41.3859,0,0,0,0,100,0), -- 19:56:45 +(@PATH,33,42.98434,315.8281,-41.6359,0,0,0,0,100,0), -- 19:56:45 +(@PATH,34,42.48434,317.0781,-42.1359,0,0,0,0,100,0), -- 19:56:45 +(@PATH,35,42.1835,317.9608,-42.14388,0,0,0,0,100,0), -- 19:56:48 +(@PATH,36,40.1835,321.7108,-42.14388,0,0,0,0,100,0), -- 19:56:48 +(@PATH,37,36.3874,327.808,-42.69028,0,0,0,0,100,0), -- 19:56:52 +(@PATH,38,34.34555,331.4348,-42.79681,0,0,0,0,100,0), -- 19:56:54 +(@PATH,39,36.48765,335.1658,-43.15406,0,0,0,0,100,0), -- 19:56:55 +(@PATH,40,39.48765,338.1658,-43.15406,0,0,0,0,100,0), -- 19:56:55 +(@PATH,41,39.95882,338.9326,-42.81082,0,0,0,0,100,0), -- 19:56:59 +(@PATH,42,40.59457,346.0652,-41.82687,0,0,0,0,100,0), -- 19:57:01 +(@PATH,43,37.89469,351.2465,-42.51594,0,0,0,0,100,0), -- 19:57:02 +(@PATH,44,36.39469,353.2465,-42.51594,0,0,0,0,100,0), -- 19:57:02 +(@PATH,45,35.03273,354.4401,-42.57788,0,0,0,0,100,0), -- 19:57:06 +(@PATH,46,25.94484,356.5529,-42.75359,0,0,0,0,100,0), -- 19:57:09 +(@PATH,47,22.69484,357.5529,-43.00359,0,0,0,0,100,0), -- 19:57:09 +(@PATH,48,16.94927,359.168,-43.14427,0,0,0,0,100,0), -- 19:57:12 +(@PATH,49,11.69927,360.918,-42.89427,0,0,0,0,100,0), -- 19:57:12 +(@PATH,50,10.69927,361.168,-42.64427,0,0,0,0,100,0); -- 19:57:12 +-- 0x1C16F408C004BDC00059E900020B2760 .go 9.185728 361.806 -42.52501 + +-- Pathing for Ancient Stone Keeper Entry: 7206 'TDB FORMAT' +SET @NPC := 27553; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-38.42904,`position_y`=221.2527,`position_z`=-48.3663 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,-38.42904,221.2527,-48.3663,3.159046,40000,0,0,100,0), -- 20:00:31 +(@PATH,2,-46.91619,220.9454,-48.09736,0,0,0,0,100,0), -- 20:01:17 +(@PATH,3,-54.90334,220.6381,-48.32841,0,40000,0,0,100,0), -- 20:01:17 +(@PATH,4,-43.16619,221.1954,-48.09736,0,0,0,0,100,0); -- 20:02:18 +-- 0x1C16F408C00709800059E900000B2760 .go -38.42904 221.2527 -48.3663 + +-- Add animation +DELETE FROM `creature_addon` WHERE `guid` IN (29384, 29488, 29574, 29573, 28536, 28539, 28538, 28537, 28798); +INSERT INTO `creature_addon` (`guid`, `bytes2`, `emote`, `auras`) VALUES +(29384, 4097, 233, NULL), +(29488, 4097, 233, NULL), +(29574, 4097, 233, NULL), +(29573, 4097, 233, NULL), +(28536, 4097, 233, NULL), +(28539, 4097, 233, NULL), +(28538, 4097, 233, NULL), +(28537, 4097, 233, NULL), +(28798, 4097, 233, NULL), +(28544, 4097, 233, NULL), +(28541, 4097, 233, NULL), +(28542, 4097, 233, NULL), +(28543, 4097, 233, NULL); + +-- Remove too many spawns +DELETE FROM `creature` WHERE `guid` IN (33523, 33512, 28800, 28799, 28798, 28797, 28796, 28786); |