DB/Misc: Death knights area rework part7

Original work done by Grz3s on Cmangos

(cherry picked from commit a4b2c9988a51d83aa87741776769313d5aa5a648)

1 files changed, 319 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_02_18_08_world_2017_12_05_00_world.sql b/sql/updates/world/master/2021_02_18_08_world_2017_12_05_00_world.sql
new file mode 100644
index 00000000000..3707ef18f3c
--- /dev/null
+++ b/sql/updates/world/master/2021_02_18_08_world_2017_12_05_00_world.sql
@@ -0,0 +1,319 @@
+-- DK Starting Zone - phase 64
+-- Duplicates removed
+DELETE FROM `creature` WHERE `guid` IN (130751,130657,130620,130670,130808,130674,130569,130599,130719,130565,130609,130566,130717,130741,130799,130821,130668,130667,130800,130708,130664,130750,130666,130807,130817,130814,130681,130822,130816,130673,130680,130672,130678,130684,130823);
+DELETE FROM `creature_addon` WHERE `guid` IN (130751,130657,130620,130670,130808,130674,130569,130599,130719,130565,130609,130566,130717,130741,130799,130821,130668,130667,130800,130708,130664,130750,130666,130807,130817,130814,130681,130822,130816,130673,130680,130672,130678,130684,130823);
+-- Rampaging Abomination
+UPDATE `creature` SET `spawntimesecs` = 5, `spawndist` = 20, `movementType` = 1 WHERE `id` = 29115;
+-- Volatile Ghoul
+UPDATE `creature` SET `spawntimesecs` = 5 WHERE `id` = 29136;
+UPDATE `creature` SET `position_x` = 2198.392090, `position_y` = -5828.402832, `position_z` = 101.502411 WHERE `guid` = 130923;
+UPDATE `creature` SET `position_x` = 2175.717285, `position_y` = -5816.032715, `position_z` = 101.343269 WHERE `guid` = 130951;
+UPDATE `creature` SET `position_x` = 2089.767090, `position_y` = -5782.844727, `position_z` = 99.5929110 WHERE `guid` = 130932;
+UPDATE `creature` SET `position_x` = 2156.671875, `position_y` = -5757.208984, `position_z` = 100.663902 WHERE `guid` = 130949;
+UPDATE `creature` SET `position_x` = 2238.655518, `position_y` = -5845.669434, `position_z` = 101.297417 WHERE `guid` = 130926;
+UPDATE `creature` SET `position_x` = 2223.981934, `position_y` = -5862.010742, `position_z` = 101.434555 WHERE `guid` = 130937;
+-- Crusaders
+UPDATE `creature` SET `Spawndist` = 0, `MovementType` = 0 WHERE `guid` = 130616;
+UPDATE `creature` SET `position_x` = 2171.041504, `position_y` = -5746.948242, `position_z` = 101.453552, `orientation` = 4.915133, `Spawndist` = 10, `MovementType` = 1 WHERE `guid` = 130665;
+UPDATE `creature` SET `position_x` = 2021.283081, `position_y` = -5767.769043, `position_z` = 102.069725, `orientation` = 0.455777 WHERE `guid` = 130663;
+UPDATE `creature` SET `position_x` = 1938.300537, `position_y` = -5806.917480, `position_z` = 100.326469, `orientation` = 0.036730 WHERE `guid` = 130669;
+UPDATE `creature` SET `position_x` = 1822.585205, `position_y` = -5806.501465, `position_z` = 103.471199, `orientation` = 6.123573 WHERE `guid` = 130676;
+UPDATE `creature` SET `position_x` = 1886.295898, `position_y` = -5815.069824, `position_z` = 102.595604, `orientation` = 0.085570 WHERE `guid` = 130803;
+UPDATE `creature` SET `position_x` = 1919.796875, `position_y` = -5810.199707, `position_z` = 100.092346, `orientation` = 0.194942 WHERE `guid` = 130671;
+UPDATE `creature` SET `position_x` = 2062.375000, `position_y` = -5827.616211, `position_z` = 101.632080, `orientation` = 6.049894 WHERE `guid` = 130789;
+UPDATE `creature` SET `position_x` = 2062.264404, `position_y` = -5863.437988, `position_z` = 103.230919, `orientation` = 0.077718 WHERE `guid` = 130662;
+UPDATE `creature` SET `position_x` = 1847.384644, `position_y` = -5861.911621, `position_z` = 102.175438, `orientation` = 6.141752 WHERE `guid` = 130679; 
+UPDATE `creature` SET `position_x` = 1872.653320, `position_y` = -5855.841309, `position_z` = 102.853523, `orientation` = 0.010887 WHERE `guid` = 130811;
+UPDATE `creature` SET `position_x` = 1887.613525, `position_y` = -5854.142578, `position_z` = 102.406212, `orientation` = 0.058871 WHERE `guid` = 130809;
+UPDATE `creature` SET `position_x` = 1897.007813, `position_y` = -5852.924805, `position_z` = 101.451141, `orientation` = 0.009392 WHERE `guid` = 130805;
+UPDATE `creature` SET `position_x` = 1919.654297, `position_y` = -5846.907715, `position_z` = 100.235977, `orientation` = 0.124753 WHERE `guid` = 130804;
+UPDATE `creature` SET `position_x` = 1935.207397, `position_y` = -5843.156250, `position_z` = 100.510971, `orientation` = 0.203284 WHERE `guid` = 130810;
+UPDATE `creature` SET `position_x` = 2105.251221, `position_y` = -5900.707031, `position_z` = 104.638618, `orientation` = 6.202802 WHERE `guid` = 130754;
+UPDATE `creature` SET `position_x` = 1982.372559, `position_y` = -5917.364258, `position_z` = 104.190681, `orientation` = 0.246334 WHERE `guid` = 130801;
+UPDATE `creature` SET `position_x` = 1928.129761, `position_y` = -5933.635742, `position_z` = 103.063942, `orientation` = 6.162736 WHERE `guid` = 130677;
+UPDATE `creature` SET `position_x` = 1888.227783, `position_y` = -5932.001465, `position_z` = 104.198326, `orientation` = 0.181147 WHERE `guid` = 130802;
+UPDATE `creature` SET `position_x` = 1887.905151, `position_y` = -5911.649414, `position_z` = 102.921516, `orientation` = 0.015411 WHERE `guid` = 130813;
+UPDATE `creature` SET `position_x` = 1846.163696, `position_y` = -5901.961426, `position_z` = 104.819687, `orientation` = 0.024871 WHERE `guid` = 130675;
+UPDATE `creature` SET `position_x` = 1860.970825, `position_y` = -5927.291504, `position_z` = 104.586868, `orientation` = 0.181141 WHERE `guid` = 130825;
+-- Waypoints
+UPDATE `creature` SET `spawntimesecs` = 30, `Spawndist` = 0, `MovementType` = 2 WHERE `guid` IN (130615,130653,130788,130791,130820,130663,130669,130819,130676,130812,130803,130806,130671,130789,130662,130679,130811,130809,130805,130804,130810,130754,130801,130677,130802,130813,130675,130825);
+DELETE FROM `creature_addon` WHERE `guid` IN (130615,130653,130788,130791,130820,130663,130669,130819,130676,130812,130803,130806,130671,130789,130662,130679,130811,130809,130805,130804,130810,130754,130801,130677,130802,130813,130675,130825);
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(130615,1306150,0,0,1, 0,''),
+(130653,1306530,0,0,1, 0,''),
+(130788,1307880,0,0,1, 0,''),
+(130791,1307910,0,0,1, 0,''),
+(130820,1308200,0,0,1, 0,''),
+(130663,1306630,0,0,1, 0,''),
+(130669,1306690,0,0,1, 0,''),
+(130819,1308190,0,0,1, 0,''),
+(130676,1306760,0,0,1, 0,''),
+(130812,1308120,0,0,1, 0,''),
+(130803,1308030,0,0,1, 0,''),
+(130806,1308060,0,0,1, 0,''),
+(130671,1306710,0,0,1, 0,''),
+(130789,1307890,0,0,1, 0,''),
+(130662,1306620,0,0,1, 0,''),
+(130679,1306790,0,0,1, 0,''),
+(130811,1308110,0,0,1, 0,''),
+(130809,1308090,0,0,1, 0,''),
+(130805,1308050,0,0,1, 0,''),
+(130804,1308040,0,0,1, 0,''),
+(130810,1308100,0,0,1, 0,''),
+(130754,1307540,0,0,1, 0,''),
+(130801,1308010,0,0,1, 0,''),
+(130677,1306770,0,0,1, 0,''),
+(130802,1308020,0,0,1, 0,''),
+(130813,1308130,0,0,1, 0,''),
+(130675,1306750,0,0,1, 0,''),
+(130825,1308250,0,0,1, 0,'');
+DELETE FROM `waypoint_data` WHERE `id` IN (1306150,1306530,1307880,1307910,1308200,1306630,1306690,1308190,1306760,1308120,1308030,1308060,1306710,1307890,1306620,1306790,1308110,1308090,1308050,1308040,1308100,1307540,1308010,1306770,1308020,1308130,1306750,1308250);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `action`, `orientation`, `action_chance`, `move_type`) VALUES
+(1308200,1,2110.63,-5730.45,100.176,1500,0,4.8397,100,1),
+(1308200,2,2122.33,-5722.27,100.328,0,0,0.410476,100,1),
+(1308200,3,2139.85,-5717.74,100.963,0,0,0.558131,100,1),
+(1308200,4,2169.78,-5698.14,106.245,0,0,0.644525,100,1),
+(1308200,5,2201.61,-5670.41,116.544,0,0,0.691649,100,1),
+(1308200,6,2221.2,-5654.19,126.493,0,0,0.49687,100,1),
+(1308200,7,2247.14,-5647.54,134.152,0,0,0.100244,100,1),
+(1308200,8,2281.82,-5649.43,144.037,10000,1188,6.15959,100,1),
+(1306150,1,2082.57,-5729.92,100.968,1500,0,-3.0862,100,1),
+(1306150,2,2120.29,-5721.2,100.326,0,0,0.206275,100,1),
+(1306150,3,2144.6,-5714.86,101.333,0,0,0.611541,100,1),
+(1306150,4,2164.79,-5698.69,105.338,0,0,0.701862,100,1),
+(1306150,5,2185.95,-5676.26,112.802,0,0,0.862868,100,1),
+(1306150,6,2205.62,-5656.75,121.586,0,0,0.752912,100,1),
+(1306150,7,2235.14,-5646.35,131.467,0,0,0.214915,100,1),
+(1306150,8,2282.81,-5638.38,145.358,10000,1188,0.210988,100,1),
+(1307880,1,2076.79,-5733.08,100.771,1500,0,0.948046,100,1),
+(1307880,2,2105.55,-5727.9,100.32,0,0,0.301308,100,1),
+(1307880,3,2146.32,-5717.57,101.241,0,0,0.577768,100,1),
+(1307880,4,2176.44,-5699.26,106.766,0,0,0.485091,100,1),
+(1307880,5,2197.89,-5686.52,111.027,0,0,0.593476,100,1),
+(1307880,6,2213.47,-5677.43,117.313,0,0,0.628819,100,1),
+(1307880,7,2227.61,-5672.47,125.733,0,0,0.150511,100,1),
+(1307880,8,2241.09,-5668.24,133.771,0,0,0.150512,100,1),
+(1307880,9,2251.19,-5671.61,140.211,0,0,6.05592,100,1),
+(1307880,10,2260.7,-5667.87,139.602,0,0,0.602901,100,1),
+(1307880,11,2279.49,-5654.93,143.935,10000,1188,0.602901,100,1),
+(1307910,1,2050.23,-5752.25,98.5459,1500,0,0.39066,100,1),
+(1307910,2,2084.27,-5739.38,100.087,0,0,0.382198,100,1),
+(1307910,3,2124.82,-5722.72,100.35,0,0,0.360207,100,1),
+(1307910,4,2161.06,-5706.96,103.656,0,0,0.712851,100,1),
+(1307910,5,2179.11,-5688.84,109.467,0,0,0.791391,100,1),
+(1307910,6,2204.98,-5664.79,119.164,0,0,0.720705,100,1),
+(1307910,7,2239.17,-5651.26,131.423,0,0,0.225904,100,1),
+(1307910,8,2280.17,-5649.69,143.613,10000,1188,6.26169,100,1),
+(1306530,1,2047.67,-5750.46,98.8524,1500,0,0.017199,100,1),
+(1306530,2,2082.62,-5736.98,100.434,0,0,0.682447,100,1),
+(1306530,3,2136.05,-5719.88,100.712,0,0,0.382425,100,1),
+(1306530,4,2169.42,-5696.4,106.528,0,0,0.739781,100,1),
+(1306530,5,2191.5,-5675.34,113.472,0,0,0.77748,100,1),
+(1306530,6,2207.61,-5659.48,121.455,0,0,0.77748,100,1),
+(1306530,7,2233.29,-5643.46,131.681,0,0,0.520655,100,1),
+(1306530,8,2280.33,-5637.12,145.183,10000,1188,0.0706218,100,1),
+(1306630,1,2021.283081,-5767.769043,102.069725,1500,0,0.455777,100,1),
+(1306630,2,2057,-5753.29,98.0162,0,0,0.389378,100,1),
+(1306630,3,2087.16,-5739.97,99.9644,0,0,0.440429,100,1),
+(1306630,4,2123.28,-5722.97,100.322,0,0,0.45221,100,1),
+(1306630,5,2151.2,-5708.97,102.328,0,0,0.602221,100,1),
+(1306630,6,2178.39,-5680.06,111.376,0,0,0.821347,100,1),
+(1306630,7,2201.81,-5659.44,119.913,0,0,0.711391,100,1),
+(1306630,8,2228.17,-5646.67,129.653,0,0,0.414511,100,1),
+(1306630,9,2278.72,-5651.94,143.384,10000,1188,5.70338,100,1),
+(1306690,1,1938.300537,-5806.917480,100.326469,1500,0,0.036730,100,1),
+(1306690,2,1983.64,-5790.51,100.901,0,0,0.378378,100,1),
+(1306690,3,2022.91,-5769.81,102.141,0,0,0.539385,100,1),
+(1306690,4,2045.72,-5758.77,98.3942,0,0,0.386232,100,1),
+(1306690,5,2076.32,-5743.14,99.4291,0,0,0.456918,100,1),
+(1306690,6,2109.68,-5727.88,100.259,0,0,0.421575,100,1),
+(1306690,7,2143.97,-5714.37,101.331,0,0,0.496973,100,1),
+(1306690,8,2175.38,-5689.75,108.822,0,0,0.680756,100,1),
+(1306690,9,2199.47,-5669.2,116.494,0,0,0.716099,100,1),
+(1306690,10,2222.41,-5653.69,126.852,0,0,0.567659,100,1),
+(1306690,11,2252.28,-5644.34,136.182,0,0,0.200093,100,1),
+(1306690,12,2282.95,-5638.85,145.296,10000,1188,0.273134,100,1),
+(1308190,1,1848.26,-5817.4,100.084,1500,0,0.031333,100,1),
+(1308190,2,1885.95,-5813.1,102.329,0,0,0.127844,100,1),
+(1308190,3,1939.43,-5807.45,100.38,0,0,0.151406,100,1),
+(1308190,4,1987.9,-5788.39,100.894,0,0,0.383098,100,1),
+(1308190,5,2042.2,-5757.65,98.5925,0,0,0.44593,100,1),
+(1308190,6,2089.15,-5735.17,100.139,0,0,0.438076,100,1),
+(1308190,7,2128.01,-5720.92,100.474,0,0,0.28885,100,1),
+(1308190,8,2170.04,-5695.56,106.79,0,0,0.650134,100,1),
+(1308190,9,2196.58,-5672.94,114.801,0,0,0.712966,100,1),
+(1308190,10,2235.65,-5650.01,130.788,0,0,0.461638,100,1),
+(1308190,11,2287.21,-5648.74,145.223,10000,1188,6.18012,100,1),
+(1306760,1,1822.585205,-5806.501465,103.471199,1500,0,6.123573,100,1),
+(1306760,2,1860.7,-5814.45,100.235,0,0,6.13614,100,1),
+(1306760,3,1902.01,-5807.95,100.908,0,0,0.00610447,100,1),
+(1306760,4,1944.01,-5807.69,100.583,0,0,0.00610447,100,1),
+(1306760,5,1989.78,-5789.95,100.913,0,0,0.482841,100,1),
+(1306760,6,2025.41,-5769.5,102.127,0,0,0.593583,100,1),
+(1306760,7,2037.01,-5761.67,99.3255,0,0,0.593583,100,1),
+(1306760,8,2081.03,-5738.27,100.278,0,0,0.389379,100,1),
+(1306760,9,2121.93,-5722.76,100.309,0,0,0.354036,100,1),
+(1306760,10,2158.34,-5704.48,103.737,0,0,0.683903,100,1),
+(1306760,11,2184.91,-5680.44,111.729,0,0,0.759302,100,1),
+(1306760,12,2207.65,-5658.66,121.698,0,0,0.767156,100,1),
+(1306760,13,2232.85,-5646.12,130.964,0,0,0.399589,100,1),
+(1306760,14,2281.53,-5657.82,144.979,10000,1188,5.88874,100,1),
+(1308120,1,1871.52,-5814.89,100.977,1500,0,0.149239,100,1),
+(1308120,2,1911.67,-5811.62,100.215,0,0,0.166323,100,1),
+(1308120,3,1978.48,-5793.12,100.877,0,0,0.434929,100,1),
+(1308120,4,2036.66,-5758.3,98.9885,0,0,0.44671,100,1),
+(1308120,5,2100.58,-5730.91,100.349,0,0,0.399586,100,1),
+(1308120,6,2155.04,-5707.06,102.968,0,0,0.509542,100,1),
+(1308120,7,2201.83,-5665.23,118.262,0,0,0.737308,100,1),
+(1308120,8,2256.58,-5647.82,136.801,0,0,0.266069,100,1),
+(1308120,9,2287.16,-5648.41,145.2,10000,1188,6.24295,100,1),
+(1308030,1,1886.295898,-5815.069824,102.595604,1500,0,0.085570,100,1),
+(1308030,2,1940.44,-5807.54,100.42,0,0,0.329044,100,1),
+(1308030,3,1996.59,-5784.59,100.768,0,0,0.441355,100,1),
+(1308030,4,2037.36,-5758.5,98.9918,0,0,0.517539,100,1),
+(1308030,5,2095.88,-5728.01,100.327,0,0,0.156255,100,1),
+(1308030,6,2142.68,-5713.79,101.296,0,0,0.442926,100,1),
+(1308030,7,2192.1,-5676.26,113.266,0,0,0.717815,100,1),
+(1308030,8,2229.92,-5650.07,129.412,0,0,0.521466,100,1),
+(1308030,9,2286.4,-5645.88,144.972,10000,1188,0.0266647,100,1),
+(1308060,1,1901.66,-5809.61,100.974,1500,0,0.342551,100,1),
+(1308060,2,1941.71,-5807.93,100.478,0,0,0.0728286,100,1),
+(1308060,3,1998.5,-5780,100.674,0,0,0.41055,100,1),
+(1308060,4,2043,-5758.39,98.5521,0,0,0.430185,100,1),
+(1308060,5,2100.37,-5732.46,100.333,0,0,0.426258,100,1),
+(1308060,6,2154.27,-5707.19,102.864,0,0,0.481236,100,1),
+(1308060,7,2193.28,-5674.47,113.916,0,0,0.650096,100,1),
+(1308060,8,2232.26,-5647.25,130.574,0,0,0.204775,100,1),
+(1308060,9,2297.9,-5651.41,147.427,10000,1188,6.19931,100,1),
+(1306710,1,1919.796875,-5810.199707,100.092346,1500,0,0.194942,100,1),
+(1306710,2,1984.03,-5789.59,100.889,0,0,0.472187,100,1),
+(1306710,3,2039.46,-5758.65,98.8531,0,0,0.511457,100,1),
+(1306710,4,2097.4,-5732.33,100.316,0,0,0.319035,100,1),
+(1306710,5,2151.62,-5712.35,101.993,0,0,0.57429,100,1),
+(1306710,6,2176.82,-5720.66,102.775,10000,1188,5.69509,100,1),
+(1307890,1,2062.375,-5827.616211,101.632080,1500,0,6.049894,100,1),
+(1307890,2,2080.54,-5829.92,102.423,0,0,5.93994,100,1),
+(1307890,3,2115.34,-5840.62,102.029,0,0,5.92109,100,1),
+(1307890,4,2158.14,-5843.73,102.082,0,0,6.26274,100,1),
+(1307890,5,2229.69,-5844.69,101.44,10000,1188,0.0463068,100,1),
+(1306620,1,2062.264404,-5863.437988,103.230919,1500,0,0.077718,100,1),
+(1306620,2,2086.83,-5858.89,102.861,0,0,0.160184,100,1),
+(1306620,3,2132.76,-5855.41,101.544,0,0,6.21011,100,1),
+(1306620,4,2168.02,-5845.59,101.368,0,0,0.292129,100,1),
+(1306620,5,2251.48,-5838.18,101.258,10000,1188,0.190027,100,1),
+(1306790,1,1847.384644,-5861.911621,102.175438,1500,0,6.141752,100,1),
+(1306790,2,1891.38,-5854.81,102.046,0,0,0.11303,100,1),
+(1306790,3,1949.22,-5847.57,100.357,0,0,0.0109272,100,1),
+(1306790,4,1995.6,-5848.39,100.826,0,0,6.18809,100,1),
+(1306790,5,2053.46,-5857.73,103.066,0,0,0.124811,100,1),
+(1306790,6,2094.38,-5854.87,103.519,0,0,0.128738,100,1),
+(1306790,7,2155.67,-5844.05,102.032,0,0,0.0384166,100,1),
+(1306790,8,2220.64,-5849.55,101.569,10000,1188,6.14489,100,1),
+(1308110,1,1872.653320,-5855.841309,102.853523,1500,0,0.010887,100,1),
+(1308110,2,1945.15,-5846.42,100.348,0,0,0.152258,100,1),
+(1308110,3,2009.83,-5844.98,100.555,0,0,0.0108862,100,1),
+(1308110,4,2081.97,-5842.18,103.485,0,0,0.0462298,100,1),
+(1308110,5,2156.12,-5816.6,101.968,0,0,0.305411,100,1),
+(1308110,6,2206.36,-5808.57,101.34,10000,1188,0.219017,100,1),
+(1308090,1,1887.613525,-5854.142578,102.406212,1500,0,0.058871,100,1),
+(1308090,2,1946.51,-5847.73,100.335,0,0,0.180608,100,1),
+(1308090,3,2008.43,-5844.67,100.563,0,0,0.0313824,100,1),
+(1308090,4,2073.83,-5841.62,103.163,0,0,0.0235284,100,1),
+(1308090,5,2143.41,-5819.68,100.946,0,0,0.28271,100,1),
+(1308090,6,2205.36,-5821.85,101.321,10000,1188,6.10251,100,1),
+(1308050,1,1897.007813,-5852.924805,101.451141,1500,0,0.009392,100,1), 
+(1308050,2,1946.35,-5847.82,100.335,0,0,0.107488,100,1),
+(1308050,3,2034.81,-5850.42,100.401,0,0,6.17862,100,1),
+(1308050,4,2104.6,-5857.17,102.44,0,0,0.00538468,100,1),
+(1308050,5,2156.86,-5859.74,101.353,0,0,6.03332,100,1),
+(1308050,6,2179.67,-5864.91,101.337,0,0,0.00302753,100,1),
+(1308050,7,2226.17,-5848.94,101.294,10000,1188,0.372165,100,1),
+(1308040,1,1919.654297,-5846.907715,100.235977,1500,0,0.124753,100,1),
+(1308040,2,1989.29,-5843.83,100.667,0,0,0.0422862,100,1),
+(1308040,3,2053.05,-5844.47,101.489,0,0,6.28227,100,1),
+(1308040,4,2115.32,-5842.73,102.499,0,0,0.085484,100,1),
+(1308040,5,2173.43,-5843.51,101.35,0,0,6.24301,100,1),
+(1308040,6,2218.12,-5839.82,101.329,10000,1188,0.101191,100,1),
+(1308100,1,1935.207397,-5843.156250,100.510971,1500,0,0.203284,100,1),
+(1308100,2,1981.56,-5842.15,100.582,0,0,6.24299,100,1),
+(1308100,3,2016.35,-5842.54,100.545,0,0,6.25556,100,1),
+(1308100,4,2079.2,-5845.73,102.93,0,0,6.22021,100,1),
+(1308100,5,2161.35,-5845.08,101.875,0,0,0.0312731,100,1),
+(1308100,6,2223.11,-5844.07,101.298,10000,1188,6.23199,100,1),
+(1307540,1,2105.251221,-5900.707031,104.638618,1500,0,6.202802,100,1),
+(1307540,2,2147.59,-5901.54,101.074,0,0,0.0138609,100,1),
+(1307540,3,2207.9,-5900.44,100.831,0,0,0.0138609,100,1),
+(1307540,4,2248.68,-5894.8,101.004,10000,1188,0.135598,100,1),
+(1308010,1,1982.372559,-5917.364258,104.190681,1500,0,0.246334,100,1),
+(1308010,2,2060.33,-5911.86,106.458,0,0,0.0177885,100,1),
+(1308010,3,2129.89,-5903.91,102.994,0,0,0.139525,100,1),
+(1308010,4,2190.71,-5899.29,101.074,0,0,6.28134,100,1),
+(1308010,5,2244.32,-5898.24,100.877,10000,1188,0.0609853,100,1),
+(1306770,1,1928.129761,-5933.635742,103.063942,1500,0,6.162736,100,1),
+(1306770,2,1981.24,-5929.33,103.63,0,0,0.115955,100,1),
+(1306770,3,2046.15,-5921.03,106.025,0,0,0.22591,100,1),
+(1306770,4,2119.48,-5903.34,104.28,0,0,0.0491957,100,1),
+(1306770,5,2173.87,-5897.81,100.759,0,0,0.025634,100,1),
+(1306770,6,2216.33,-5899.95,100.666,0,0,6.21065,100,1),
+(1306770,7,2243.88,-5903.52,100.662,10000,1188,6.15567,100,1),
+(1308020,1,1888.227783,-5932.001465,104.198326,1500,0,0.181147,100,1),
+(1308020,2,1957.72,-5914.99,102.575,0,0,0.224344,100,1),
+(1308020,3,2025.95,-5907.58,104.953,0,0,0.0633372,100,1),
+(1308020,4,2078.47,-5904.05,105.728,0,0,0.0358482,100,1),
+(1308020,5,2141.54,-5898.15,102.3,0,0,0.0162122,100,1),
+(1308020,6,2192.28,-5899.28,101.138,0,0,6.18552,100,1),
+(1308020,7,2245.25,-5899.67,100.817,10000,1188,6.26406,100,1),
+(1308130,1,1887.905151,-5911.649414,102.921516,1500,0,0.015411,100,1),
+(1308130,2,1950.41,-5906.33,101.542,0,0,0.125367,100,1),
+(1308130,3,2024.78,-5907.01,104.901,0,0,6.27111,100,1),
+(1308130,4,2070.91,-5897.83,104.986,0,0,6.1965,100,1),
+(1308130,5,2126.33,-5901.08,103.446,0,0,0.0193386,100,1),
+(1308130,6,2249.12,-5903.34,100.523,10000,1188,6.22398,100,1),
+(1306750,1,1846.163696,-5901.961426,104.819687,1500,0,0.024871,100,1),
+(1306750,2,1894.25,-5906.52,102.022,0,0,6.17061,100,1),
+(1306750,3,1961.34,-5907.78,102.362,0,0,6.257,100,1),
+(1306750,4,2031.98,-5908.53,105.049,0,0,0.0405757,100,1),
+(1306750,5,2098.74,-5905.52,105.628,0,0,6.28056,100,1),
+(1306750,6,2160.55,-5915.42,100.01,0,0,6.0528,100,1),
+(1306750,7,2196.82,-5919.73,101.013,0,0,0.0829842,100,1),
+(1306750,8,2250.08,-5905.68,100.325,10000,1188,0.42149,100,1),
+(1308250,1,1860.970825,-5927.291504,104.586868,1500,0,0.181141,100,1),
+(1308250,2,1919.96,-5923.4,102.163,0,0,0.137944,100,1),
+(1308250,3,1994.91,-5908.86,103.971,0,0,0.102601,100,1),
+(1308250,4,2050.26,-5906.36,105.613,0,0,0.122236,100,1),
+(1308250,5,2112.05,-5908.49,104.778,0,0,0.00835337,100,1),
+(1308250,6,2173.17,-5899.52,100.583,0,0,0.0829662,100,1),
+(1308250,7,2251.93,-5902.93,100.478,10000,1188,6.20122,100,1);
+-- Balista defenders
+DELETE FROM `creature_addon` WHERE `guid` IN (130630,130625,130759,130629,130631,130628,130627,130626,130760,130710,130725,130699,130583,130575,130643,130633,130638,130764,130767,130611,130639,130766,130774);
+INSERT INTO `creature_addon` (`guid`,`path_id`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(130630,0,0,1,333,""),
+(130625,0,0,1,333,""),
+(130759,0,0,1,333,""),
+(130629,0,0,1,333,""),
+(130631,0,0,1,333,""),
+(130628,0,0,1,333,""),
+(130627,0,0,1,333,""),
+(130626,0,0,1,333,""),
+(130760,0,0,1,333,""),
+(130710,0,0,1,333,""),
+(130725,0,0,1,333,""),
+(130699,0,0,1,333,""),
+(130583,0,0,1,333,""),
+(130575,0,0,1,333,""),
+(130643,0,0,1,333,""),
+(130633,0,0,1,333,""),
+(130638,0,0,1,333,""),
+(130764,0,0,1,333,""),
+(130767,0,0,1,333,""),
+(130611,0,0,1,333,""),
+(130639,0,0,1,333,""),
+(130766,0,0,1,333,""),
+(130774,0,0,1,333,"");
+-- Citizen of Havenshire -- Phase 1
+DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 28576);
+DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 28577);
+DELETE FROM `creature_template_addon` WHERE `entry` IN (28576,28577);
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(28576,0,0,1,0,""),
+(28577,0,0,1,0,"");