DB/Creature: Dread Tactician

closes #14361

1 files changed, 234 insertions, 0 deletions

diff --git a/sql/updates/world/2015_03_15_05_world.sql b/sql/updates/world/2015_03_15_05_world.sql
new file mode 100644
index 00000000000..8aed78b7305
--- /dev/null
+++ b/sql/updates/world/2015_03_15_05_world.sql
@@ -0,0 +1,234 @@
+-- Dread Tactician
+-- Pathing for  Entry: 16959 'TDB FORMAT' 
+SET @NPC := 59170;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-306.8688,`position_y`=1556.233,`position_z`=41.73843 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,-306.8688,1556.233,41.73843,0,0,0,0,100,0),
+(@PATH,2,-303.8688,1555.983,40.73843,0,0,0,0,100,0),
+(@PATH,3,-299.8688,1555.483,40.23843,0,0,0,0,100,0),
+(@PATH,4,-297.8688,1555.233,39.48843,0,0,0,0,100,0),
+(@PATH,5,-295.1188,1554.983,38.73843,0,0,0,0,100,0),
+(@PATH,6,-292.1188,1554.483,38.48843,0,0,0,0,100,0),
+(@PATH,7,-289.1188,1554.233,37.73843,0,0,0,0,100,0),
+(@PATH,8,-287.1188,1553.983,37.23843,0,0,0,0,100,0),
+(@PATH,9,-284.1188,1553.983,36.48843,0,0,0,0,100,0),
+(@PATH,10,-283.8904,1553.79,36.20832,0,0,0,0,100,0),
+(@PATH,11,-281.8904,1553.54,35.95832,0,0,0,0,100,0),
+(@PATH,12,-275.6404,1556.04,35.70832,0,0,0,0,100,0),
+(@PATH,13,-269.0029,1558.513,35.23201,0,0,0,0,100,0),
+(@PATH,14,-270.5029,1562.263,35.98201,0,0,0,0,100,0),
+(@PATH,15,-271.7529,1565.013,36.48201,0,0,0,0,100,0),
+(@PATH,16,-272.7529,1567.513,36.98201,0,0,0,0,100,0),
+(@PATH,17,-274.0029,1570.263,37.73201,0,0,0,0,100,0),
+(@PATH,18,-275.0029,1573.013,38.48201,0,0,0,0,100,0),
+(@PATH,19,-276.4716,1576.198,39.42199,0,0,0,0,100,0),
+(@PATH,20,-278.2216,1576.948,39.92199,0,0,0,0,100,0),
+(@PATH,21,-280.9716,1578.448,40.92199,0,0,0,0,100,0),
+(@PATH,22,-283.7216,1579.698,41.67199,0,0,0,0,100,0),
+(@PATH,23,-285.4716,1580.448,42.17199,0,0,0,0,100,0),
+(@PATH,24,-287.9716,1581.698,42.92199,0,0,0,0,100,0),
+(@PATH,25,-289.7216,1582.448,43.67199,0,0,0,0,100,0),
+(@PATH,26,-291.4716,1583.448,44.42199,0,0,0,0,100,0),
+(@PATH,27,-294.2216,1584.698,45.17199,0,0,0,0,100,0),
+(@PATH,28,-294.3971,1584.785,45.42167,0,0,0,0,100,0),
+(@PATH,29,-295.1471,1585.035,45.42167,0,0,0,0,100,0),
+(@PATH,30,-304.3971,1576.535,45.92167,0,0,0,0,100,0),
+(@PATH,31,-312.2731,1568.967,46.45709,0,0,0,0,100,0),
+(@PATH,32,-318.7731,1561.467,45.70709,0,0,0,0,100,0),
+(@PATH,33,-333.8887,1543.732,45.3224,0,0,0,0,100,0),
+(@PATH,34,-333.6387,1540.732,44.5724,0,0,0,0,100,0),
+(@PATH,35,-333.3887,1538.732,43.8224,0,0,0,0,100,0),
+(@PATH,36,-333.3887,1536.732,43.3224,0,0,0,0,100,0),
+(@PATH,37,-333.1387,1533.732,42.5724,0,0,0,0,100,0),
+(@PATH,38,-332.8887,1531.732,41.8224,0,0,0,0,100,0),
+(@PATH,39,-332.8887,1529.732,41.0724,0,0,0,0,100,0),
+(@PATH,40,-332.6387,1527.732,40.5724,0,0,0,0,100,0),
+(@PATH,41,-332.3887,1525.732,39.8224,0,0,0,0,100,0),
+(@PATH,42,-332.3887,1523.732,39.3224,0,0,0,0,100,0),
+(@PATH,43,-332.1387,1521.982,38.8224,0,0,0,0,100,0),
+(@PATH,44,-331.8887,1518.982,38.3224,0,0,0,0,100,0),
+(@PATH,45,-331.8887,1516.982,37.5724,0,0,0,0,100,0),
+(@PATH,46,-331.8887,1513.982,36.8224,0,0,0,0,100,0),
+(@PATH,47,-331.6387,1510.982,36.3224,0,0,0,0,100,0),
+(@PATH,48,-331.3887,1508.232,35.5724,0,0,0,0,100,0),
+(@PATH,49,-331.1387,1505.232,34.8224,0,0,0,0,100,0),
+(@PATH,50,-330.8887,1502.232,34.3224,0,0,0,0,100,0),
+(@PATH,51,-330.4729,1499.82,33.45189,0,0,0,0,100,0),
+(@PATH,52,-325.4729,1496.82,32.70189,0,0,0,0,100,0),
+(@PATH,53,-320.9729,1494.32,31.95189,0,0,0,0,100,0),
+(@PATH,54,-316.2229,1491.57,31.45189,0,0,0,0,100,0),
+(@PATH,55,-311.7229,1489.07,30.95189,0,0,0,0,100,0),
+(@PATH,56,-307.4729,1486.57,30.20189,0,0,0,0,100,0),
+(@PATH,57,-307.3154,1486.395,29.88731,0,0,0,0,100,0),
+(@PATH,58,-305.8154,1485.645,29.63731,0,0,0,0,100,0),
+(@PATH,59,-299.8154,1485.645,28.88731,0,0,0,0,100,0),
+(@PATH,60,-294.0654,1485.395,28.38731,0,0,0,0,100,0),
+(@PATH,61,-287.0654,1485.395,27.88731,0,0,0,0,100,0),
+(@PATH,62,-281.0654,1485.395,27.38731,0,0,0,0,100,0),
+(@PATH,63,-280.6106,1485.449,27.23963,0,0,0,0,100,0),
+(@PATH,64,-278.6106,1485.199,27.23963,0,0,0,0,100,0),
+(@PATH,65,-270.6106,1498.699,27.48963,0,0,0,0,100,0),
+(@PATH,66,-268.6106,1502.199,27.98963,0,0,0,0,100,0),
+(@PATH,67,-268.5272,1502.318,28.20654,0,0,0,0,100,0),
+(@PATH,68,-267.5272,1503.818,28.20654,0,0,0,0,100,0),
+(@PATH,69,-270.5272,1504.568,28.70654,0,0,0,0,100,0),
+(@PATH,70,-274.2772,1505.568,29.20654,0,0,0,0,100,0),
+(@PATH,71,-278.5582,1506.635,29.73862,0,0,0,0,100,0),
+(@PATH,72,-290.8082,1500.885,30.23862,0,0,0,0,100,0),
+(@PATH,73,-296.4533,1498.203,30.9129,0,0,0,0,100,0),
+(@PATH,74,-300.2033,1498.953,31.4129,0,0,0,0,100,0),
+(@PATH,75,-304.2033,1499.703,31.9129,0,0,0,0,100,0),
+(@PATH,76,-307.9533,1500.453,32.4129,0,0,0,0,100,0),
+(@PATH,77,-313.7033,1501.203,33.1629,0,0,0,0,100,0),
+(@PATH,78,-317.4067,1502.011,33.47455,0,0,0,0,100,0),
+(@PATH,79,-319.6567,1504.011,33.97455,0,0,0,0,100,0),
+(@PATH,80,-322.1567,1506.511,34.47455,0,0,0,0,100,0),
+(@PATH,81,-325.2614,1509.541,35.46749,0,0,0,0,100,0),
+(@PATH,82,-325.7614,1512.541,35.96749,0,0,0,0,100,0),
+(@PATH,83,-326.0114,1515.541,36.71749,0,0,0,0,100,0),
+(@PATH,84,-326.2614,1517.541,37.21749,0,0,0,0,100,0),
+(@PATH,85,-326.2614,1520.541,38.21749,0,0,0,0,100,0),
+(@PATH,86,-326.5114,1522.541,38.71749,0,0,0,0,100,0),
+(@PATH,87,-326.7614,1525.291,39.46749,0,0,0,0,100,0),
+(@PATH,88,-327.0114,1527.291,39.96749,0,0,0,0,100,0),
+(@PATH,89,-327.2614,1529.291,40.71749,0,0,0,0,100,0),
+(@PATH,90,-327.7614,1533.291,41.46749,0,0,0,0,100,0),
+(@PATH,91,-328.0114,1535.041,41.96749,0,0,0,0,100,0),
+(@PATH,92,-328.2614,1538.041,42.71749,0,0,0,0,100,0);
+-- 0x1C39AC4240108FC00000210000037184 .go -306.8688 1556.233 41.73843
+
+
+-- Pathing for  Entry: 16959 'TDB FORMAT' 
+SET @NPC := 59171;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-110.5204,`position_y`=1566.893,`position_z`=42.31397 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,-110.5204,1566.893,42.31397,0,0,0,0,100,0),
+(@PATH,2,-120.2704,1568.393,41.81397,0,0,0,0,100,0),
+(@PATH,3,-127.0204,1569.893,41.31397,0,0,0,0,100,0),
+(@PATH,4,-134.6927,1571.43,40.71382,0,0,0,0,100,0),
+(@PATH,5,-139.6927,1571.68,40.21382,0,0,0,0,100,0),
+(@PATH,6,-144.6927,1571.93,39.46382,0,0,0,0,100,0),
+(@PATH,7,-149.4427,1572.18,38.71382,0,0,0,0,100,0),
+(@PATH,8,-152.4427,1572.43,38.21382,0,0,0,0,100,0),
+(@PATH,9,-155.4427,1572.68,37.71382,0,0,0,0,100,0),
+(@PATH,10,-158.4427,1572.68,36.96382,0,0,0,0,100,0),
+(@PATH,11,-161.4427,1572.93,36.46382,0,0,0,0,100,0),
+(@PATH,12,-163.4427,1573.18,35.71382,0,0,0,0,100,0),
+(@PATH,13,-163.4854,1573.449,35.89986,0,0,0,0,100,0),
+(@PATH,14,-164.2354,1573.449,35.64986,0,0,0,0,100,0),
+(@PATH,15,-163.9854,1576.449,36.39986,0,0,0,0,100,0),
+(@PATH,16,-163.7824,1580.185,36.84877,0,0,0,0,100,0),
+(@PATH,17,-161.7824,1580.435,37.59877,0,0,0,0,100,0),
+(@PATH,18,-159.0324,1580.935,38.34877,0,0,0,0,100,0),
+(@PATH,19,-155.0324,1581.935,38.84877,0,0,0,0,100,0),
+(@PATH,20,-152.2824,1582.685,39.59877,0,0,0,0,100,0),
+(@PATH,21,-148.5324,1583.435,40.34877,0,0,0,0,100,0),
+(@PATH,22,-145.5324,1584.185,41.09877,0,0,0,0,100,0),
+(@PATH,23,-145.3761,1584.15,41.32778,0,0,0,0,100,0),
+(@PATH,24,-144.1261,1584.4,41.57778,0,0,0,0,100,0),
+(@PATH,25,-139.1261,1583.9,42.32778,0,0,0,0,100,0),
+(@PATH,26,-135.1261,1583.65,43.07778,0,0,0,0,100,0),
+(@PATH,27,-130.1261,1583.15,43.57778,0,0,0,0,100,0),
+(@PATH,28,-126.3761,1582.65,44.07778,0,0,0,0,100,0),
+(@PATH,29,-123.3761,1582.4,44.82778,0,0,0,0,100,0),
+(@PATH,30,-117.3761,1582.15,45.32778,0,0,0,0,100,0),
+(@PATH,31,-113.3761,1581.65,46.07778,0,0,0,0,100,0),
+(@PATH,32,-109.0603,1580.944,46.36949,0,0,0,0,100,0),
+(@PATH,33,-84.0918,1569.51,46.44577,0,0,0,0,100,0),
+(@PATH,34,-82.3418,1566.01,45.44577,0,0,0,0,100,0),
+(@PATH,35,-81.3418,1564.26,44.94577,0,0,0,0,100,0),
+(@PATH,36,-80.0918,1561.51,44.19577,0,0,0,0,100,0),
+(@PATH,37,-79.0918,1559.76,43.69577,0,0,0,0,100,0),
+(@PATH,38,-78.0918,1558.01,42.94577,0,0,0,0,100,0),
+(@PATH,39,-76.5918,1554.76,42.19577,0,0,0,0,100,0),
+(@PATH,40,-75.8418,1553.01,41.69577,0,0,0,0,100,0),
+(@PATH,41,-74.8418,1551.26,41.19577,0,0,0,0,100,0),
+(@PATH,42,-73.3418,1548.51,40.44577,0,0,0,0,100,0),
+(@PATH,43,-72.5918,1546.76,39.94577,0,0,0,0,100,0),
+(@PATH,44,-71.5918,1545.01,39.19577,0,0,0,0,100,0),
+(@PATH,45,-70.3418,1542.26,38.69577,0,0,0,0,100,0),
+(@PATH,46,-70.29829,1541.94,38.42153,0,0,0,0,100,0),
+(@PATH,47,-69.29829,1540.19,37.67153,0,0,0,0,100,0),
+(@PATH,48,-69.54829,1538.19,37.17153,0,0,0,0,100,0),
+(@PATH,49,-70.04829,1535.19,36.17153,0,0,0,0,100,0),
+(@PATH,50,-70.04829,1533.44,35.67153,0,0,0,0,100,0),
+(@PATH,51,-70.54829,1529.44,35.17153,0,0,0,0,100,0),
+(@PATH,52,-71.04829,1525.69,34.42153,0,0,0,0,100,0),
+(@PATH,53,-71.54829,1521.69,33.92153,0,0,0,0,100,0),
+(@PATH,54,-71.54829,1518.69,33.17153,0,0,0,0,100,0),
+(@PATH,55,-72.10271,1515.561,32.53027,0,0,0,0,100,0),
+(@PATH,56,-73.35271,1512.811,31.53027,0,0,0,0,100,0),
+(@PATH,57,-74.35271,1511.061,30.78027,0,0,0,0,100,0),
+(@PATH,58,-75.10271,1509.311,30.28027,0,0,0,0,100,0),
+(@PATH,59,-76.35271,1506.561,29.78027,0,0,0,0,100,0),
+(@PATH,60,-78.10271,1502.811,29.03027,0,0,0,0,100,0),
+(@PATH,61,-79.10271,1500.311,30.03027,0,0,0,0,100,0),
+(@PATH,62,-82.35271,1493.061,29.28027,0,0,0,0,100,0),
+(@PATH,63,-84.10271,1489.561,28.53027,0,0,0,0,100,0),
+(@PATH,64,-84.42598,1489.16,28.3833,0,0,0,0,100,0),
+(@PATH,65,-85.17598,1487.41,28.1333,0,0,0,0,100,0),
+(@PATH,66,-102.3677,1477.751,27.65215,0,0,0,0,100,0),
+(@PATH,67,-123.1177,1477.501,26.90215,0,0,0,0,100,0),
+(@PATH,68,-137.5984,1477.31,26.80837,0,0,0,0,100,0),
+(@PATH,69,-145.5984,1482.56,27.05837,0,0,0,0,100,0),
+(@PATH,70,-153.8199,1488.331,27.38618,0,0,0,0,100,0),
+(@PATH,71,-178.7361,1511.036,27.3082,0,0,0,0,100,0),
+(@PATH,72,-185.2269,1510.27,27.05297,0,0,0,0,100,0),
+(@PATH,73,-182.9769,1508.27,27.05297,0,0,0,0,100,0),
+(@PATH,74,-172.9769,1500.02,26.80297,0,0,0,0,100,0),
+(@PATH,75,-170.7269,1498.27,27.05297,0,0,0,0,100,0),
+(@PATH,76,-169.2269,1496.02,27.05297,0,0,0,0,100,0),
+(@PATH,77,-167.7269,1494.02,26.80297,0,0,0,0,100,0),
+(@PATH,78,-167.7269,1492.02,26.80297,0,0,0,0,100,0),
+(@PATH,79,-167.7269,1489.77,26.80297,0,0,0,0,100,0),
+(@PATH,80,-167.4919,1489.571,26.64043,0,0,0,0,100,0),
+(@PATH,81,-168.4919,1488.071,26.64043,0,0,0,0,100,0),
+(@PATH,82,-158.2419,1482.071,26.14043,0,0,0,0,100,0),
+(@PATH,83,-147.591,1475.386,26.25293,0,0,0,0,100,0),
+(@PATH,84,-139.841,1477.636,27.00293,0,0,0,0,100,0),
+(@PATH,85,-132.341,1479.636,27.25293,0,0,0,0,100,0),
+(@PATH,86,-125.591,1481.386,28.00293,0,0,0,0,100,0),
+(@PATH,87,-121.841,1482.636,28.50293,0,0,0,0,100,0),
+(@PATH,88,-120.2695,1483.081,29.04744,0,0,0,0,100,0),
+(@PATH,89,-118.5195,1484.081,29.54744,0,0,0,0,100,0),
+(@PATH,90,-115.7695,1485.331,30.29744,0,0,0,0,100,0),
+(@PATH,91,-115.0195,1485.831,31.04744,0,0,0,0,100,0),
+(@PATH,92,-113.0195,1486.831,32.04744,0,0,0,0,100,0),
+(@PATH,93,-107.0195,1489.581,31.29744,0,0,0,0,100,0),
+(@PATH,94,-95.5195,1495.331,30.79744,0,0,0,0,100,0),
+(@PATH,95,-95.16714,1495.663,31.08524,0,0,0,0,100,0),
+(@PATH,96,-94.66714,1495.913,31.08524,0,0,0,0,100,0),
+(@PATH,97,-93.66714,1499.913,31.33524,0,0,0,0,100,0),
+(@PATH,98,-92.16714,1506.413,31.83524,0,0,0,0,100,0),
+(@PATH,99,-90.66714,1512.163,32.58524,0,0,0,0,100,0),
+(@PATH,100,-89.91714,1514.913,31.83524,0,0,0,0,100,0),
+(@PATH,101,-89.75613,1515.401,32.07003,0,0,0,0,100,0),
+(@PATH,102,-89.25613,1516.401,31.82003,0,0,0,0,100,0),
+(@PATH,103,-89.25613,1523.401,32.57003,0,0,0,0,100,0),
+(@PATH,104,-89.25613,1524.401,33.32003,0,0,0,0,100,0),
+(@PATH,105,-89.25613,1525.401,34.07003,0,0,0,0,100,0),
+(@PATH,106,-89.00613,1526.401,34.57003,0,0,0,0,100,0),
+(@PATH,107,-89.00613,1528.401,35.82003,0,0,0,0,100,0),
+(@PATH,108,-89.00613,1529.401,36.07003,0,0,0,0,100,0),
+(@PATH,109,-88.75613,1533.151,36.82003,0,0,0,0,100,0),
+(@PATH,110,-88.75613,1535.151,37.32003,0,0,0,0,100,0),
+(@PATH,111,-88.50613,1538.151,38.07003,0,0,0,0,100,0),
+(@PATH,112,-88.50613,1541.151,38.82003,0,0,0,0,100,0),
+(@PATH,113,-88.25613,1544.151,39.57003,0,0,0,0,100,0),
+(@PATH,114,-88.1545,1544.429,39.72079,0,0,0,0,100,0),
+(@PATH,115,-88.1545,1545.429,39.97079,0,0,0,0,100,0),
+(@PATH,116,-91.1545,1548.179,40.47079,0,0,0,0,100,0),
+(@PATH,117,-94.6545,1551.679,40.97079,0,0,0,0,100,0),
+(@PATH,118,-99.4045,1556.429,41.72079,0,0,0,0,100,0),
+(@PATH,119,-110.481,1566.873,42.2832,0,0,0,0,100,0),
+(@PATH,120,-120.231,1568.623,41.7832,0,0,0,0,100,0),
+(@PATH,121,-126.981,1569.873,41.2832,0,0,0,0,100,0);
+-- 0x1C39AC4240108FC000002100007FC923 .go -110.5204 1566.893 42.31397