DB/Spawning: Add Chill-Out Zone in Feralas

1 files changed, 411 insertions, 0 deletions

diff --git a/sql/updates/world/2015_03_26_01_world.sql b/sql/updates/world/2015_03_26_01_world.sql
new file mode 100644
index 00000000000..698dc0242ed
--- /dev/null
+++ b/sql/updates/world/2015_03_26_01_world.sql
@@ -0,0 +1,411 @@
+-- Chill-out-zone in Feralas
+SET @CGUID := 286261;
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+203;
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
+(@CGUID+0, 51722, 1, 1, 1, -5833.622, 526.6389, 176.4752, 1.139901, 120, 5, 1), -- 51722 (Area: -1) (possible waypoints or random movement)
+(@CGUID+1, 51865, 1, 1, 1, -5820.382, 532.1875, 194.2173, 2.356194, 120, 0, 0), -- 51865 (Area: -1)
+(@CGUID+2, 51865, 1, 1, 1, -5819.071, 530.6371, 193.9381, 6.091199, 120, 0, 0), -- 51865 (Area: -1)
+(@CGUID+3, 54228, 1, 1, 1, -5817.061, 490.6267, 183.8121, 0, 120, 0, 0), -- 54228 (Area: -1) (Auras: 96028 - 96028)
+(@CGUID+4, 54228, 1, 1, 1, -5810.71, 488.6788, 183.4907, 2.216568, 120, 0, 0), -- 54228 (Area: -1) (Auras: 96040 - 96040)
+(@CGUID+5, 51718, 1, 1, 1, -5812.771, 489.2899, 183.534, 1.151917, 120, 0, 0), -- 51718 (Area: -1)
+(@CGUID+6, 51714, 1, 1, 1, -5838.839, 459.3503, 177.5797, 3.756243, 120, 0, 0), -- 51714 (Area: -1)
+(@CGUID+7, 51757, 1, 1, 1, -5814.559, 498.2431, 183.3129, 4.555309, 120, 0, 0), -- 51757 (Area: -1)
+(@CGUID+8, 51722, 1, 1, 1, -5828.743, 529.9427, 176.5139, 5.009095, 120, 0, 0), -- 51722 (Area: -1)
+(@CGUID+9, 51714, 1, 1, 1, -5860.543, 410.9887, 182.0474, 6.183322, 120, 0, 0), -- 51714 (Area: -1)
+(@CGUID+10, 51865, 1, 1, 1, -5835.231, 512.3212, 193.9373, 6.073746, 120, 0, 0), -- 51865 (Area: -1)
+(@CGUID+11, 51865, 1, 1, 1, -5820.609, 531.1719, 194.1476, 1.396263, 120, 0, 0), -- 51865 (Area: -1)
+(@CGUID+12, 51714, 1, 1, 1, -5908.986, 601.248, 160.9332, 1.891346, 120, 0, 0), -- 51714 (Area: -1)
+(@CGUID+13, 51752, 1, 1, 1, -5988.24, 389.5609, 164.9274, 1.203695, 120, 0, 0), -- 51752 (Area: -1)
+(@CGUID+14, 51752, 1, 1, 1, -6078.896, 491.4083, 152.2478, 5.975255, 120, 0, 0), -- 51752 (Area: 5706)
+(@CGUID+15, 51752, 1, 1, 1, -6057.95, 469.7435, 150.8158, 6.124453, 120, 0, 0), -- 51752 (Area: 5706)
+(@CGUID+16, 51752, 1, 1, 1, -6067.034, 521.338, 146.5664, 1.711865, 120, 0, 0), -- 51752 (Area: 5706)
+(@CGUID+17, 51752, 1, 1, 1, -5977.059, 423.1778, 172.9921, 4.071449, 120, 0, 0), -- 51752 (Area: 5706)
+(@CGUID+18, 51752, 1, 1, 1, -5963.903, 500.7011, 154.703, 2.678033, 120, 0, 0), -- 51752 (Area: 5706)
+(@CGUID+19, 51752, 1, 1, 1, -5970.467, 459.6813, 174.096, 1.529866, 120, 0, 0), -- 51752 (Area: 5706)
+(@CGUID+20, 51752, 1, 1, 1, -5976.205, 520.6515, 153.9384, 3.080031, 120, 0, 0), -- 51752 (Area: 5706)
+(@CGUID+21, 51752, 1, 1, 1, -5992.32, 358.3326, 164.653, 0.9494663, 120, 0, 0), -- 51752 (Area: 5706)
+(@CGUID+22, 51865, 1, 1, 1, -5843.563, 511.5486, 193.9623, 0.9599311, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+23, 51714, 1, 1, 1, -5776.128, 443.1764, 196.293, 2.607668, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+24, 51714, 1, 1, 1, -5843.026, 483.1286, 182.3018, 4.233008, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+25, 51756, 1, 1, 1, -5770.584, 476.897, 183.4999, 5.395369, 120, 5, 1), -- 51756 (Area: 5706) (possible waypoints or random movement)
+(@CGUID+26, 54228, 1, 1, 1, -5788.821, 478.2326, 183.5699, 5.323254, 120, 0, 0), -- 54228 (Area: 5706) (Auras: 96040 - 96040)
+(@CGUID+27, 54228, 1, 1, 1, -5782.837, 474.6424, 183.651, 2.548181, 120, 0, 0), -- 54228 (Area: 5706) (Auras: 96028 - 96028)
+(@CGUID+28, 54228, 1, 1, 1, -5803.561, 483.4983, 183.5872, 0.715585, 120, 0, 0), -- 54228 (Area: 5706) (Auras: 96028 - 96028)
+(@CGUID+29, 51714, 1, 1, 1, -5848.987, 451.9886, 177.6204, 6.022725, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+30, 51714, 1, 1, 1, -5858.383, 470.8597, 180.5947, 0.8780586, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+31, 51714, 1, 1, 1, -5809.133, 425.7376, 195.5264, 2.47713, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+32, 53418, 1, 1, 1, -5869.285, 498.0226, 176.9977, 3.001966, 120, 0, 0), -- 53418 (Area: 5706)
+(@CGUID+33, 51714, 1, 1, 1, -5815.361, 408.014, 195.5388, 0.95924, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+34, 51865, 1, 1, 1, -5853.597, 510.9844, 193.8445, 3.874631, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+35, 51714, 1, 1, 1, -5824.243, 440.3729, 183.7047, 2.263534, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+36, 51718, 1, 1, 1, -5799.51, 486.1354, 183.2788, 5.183628, 120, 0, 0), -- 51718 (Area: 5706)
+(@CGUID+37, 51865, 1, 1, 1, -5836.851, 513.5625, 193.8926, 5.462881, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+38, 51719, 1, 1, 1, -5786.854, 477.2396, 183.4653, 0.6283185, 120, 0, 0), -- 51719 (Area: 5706)
+(@CGUID+39, 51865, 1, 1, 1, -5852.749, 510.8906, 193.8817, 4.607669, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+40, 51755, 1, 1, 1, -5775.304, 515.1766, 176.5595, 0.3552933, 120, 5, 1), -- 51755 (Area: 5706) (possible waypoints or random movement)
+(@CGUID+41, 52057, 1, 1, 1, -5848.952, 606.2587, 162.6436, 2.530727, 120, 0, 0), -- 52057 (Area: 5706)
+(@CGUID+42, 51714, 1, 1, 1, -5825.332, 341.6033, 226.0715, 5.481623, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+43, 51865, 1, 1, 1, -5781.887, 509.5851, 194.7077, 0.7504916, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+44, 51714, 1, 1, 1, -5740.958, 416.2426, 191.8828, 0.01742927, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+45, 51865, 1, 1, 1, -5774.441, 507.8472, 194.3099, 1.710423, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+46, 53418, 1, 1, 1, -5761.615, 502.9688, 176.5606, 4.904375, 120, 0, 0), -- 53418 (Area: 5706)
+(@CGUID+47, 51865, 1, 1, 1, -5790.071, 512.0643, 194.686, 5.811946, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+48, 51865, 1, 1, 1, -5781.984, 511.6632, 194.7883, 2.042035, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+49, 51865, 1, 1, 1, -5810.505, 536.4601, 194.3137, 5.846853, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+50, 51722, 1, 1, 1, -5771.483, 518.7049, 176.5595, 1.762783, 120, 0, 0), -- 51722 (Area: 5706)
+(@CGUID+51, 51714, 1, 1, 1, -5853.271, 350.8911, 223.5589, 5.182024, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+52, 51714, 1, 1, 1, -5782.701, 375.5263, 195.2083, 0.6107414, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+53, 51722, 1, 1, 1, -5872.847, 509.8906, 176.8662, 0.5061455, 120, 0, 0), -- 51722 (Area: 5706)
+(@CGUID+54, 51865, 1, 1, 1, -5789.413, 513.2604, 194.3942, 0.5235988, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+55, 51865, 1, 1, 1, -5810.993, 536.1563, 194.2216, 5.113815, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+56, 51865, 1, 1, 1, -5811.823, 537.8507, 194.0482, 1.343904, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+57, 51722, 1, 1, 1, -5818.374, 537.2257, 176.3231, 1.919862, 120, 0, 0), -- 51722 (Area: 5706)
+(@CGUID+58, 51722, 1, 1, 1, -5806.168, 533.3299, 176.5178, 2.827433, 120, 0, 0), -- 51722 (Area: 5706)
+(@CGUID+59, 51714, 1, 1, 1, -5729.734, 437.4757, 191.8828, 4.213965, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+60, 51714, 1, 1, 1, -5735.756, 466.9708, 194.1166, 5.325943, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+61, 51722, 1, 1, 1, -5749.45, 498.5434, 176.5606, 2.268928, 120, 0, 0), -- 51722 (Area: 5706)
+(@CGUID+62, 51714, 1, 1, 1, -5714.741, 482.6237, 194.6329, 5.168834, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+63, 51714, 1, 1, 1, -5694.937, 445.9204, 191.8638, 2.747071, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+64, 51714, 1, 1, 1, -5682.681, 409.7939, 191.8828, 4.055, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+65, 51714, 1, 1, 1, -5638.822, 394.0143, 194.3154, 2.944314, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+66, 51722, 1, 1, 1, -5702.979, 515.4583, 176.545, 1.780236, 120, 0, 0), -- 51722 (Area: 5706)
+(@CGUID+67, 51865, 1, 1, 1, -5726.524, 522.6893, 194.7015, 4.206244, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+68, 51865, 1, 1, 1, -5711.851, 522.5972, 194.2767, 2.216568, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+69, 51865, 1, 1, 1, -5702.165, 520.6389, 194.34, 1.32645, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+70, 51865, 1, 1, 1, -5718.627, 521.0486, 194.4333, 0.9948376, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+71, 51758, 1, 1, 1, -5722.866, 530.9305, 176.6105, 0, 120, 0, 0), -- 51758 (Area: 5706)
+(@CGUID+72, 51865, 1, 1, 1, -5727.182, 521.3646, 194.6415, 1.954769, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+73, 51865, 1, 1, 1, -5710.327, 521.4149, 194.4212, 2.234021, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+74, 51865, 1, 1, 1, -5718.733, 522.9983, 194.4557, 2.216568, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+75, 51865, 1, 1, 1, -5702.774, 522.1805, 193.7672, 2.216568, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+76, 51865, 1, 1, 1, -5700.931, 520.5695, 194.3047, 5.707227, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+77, 51755, 1, 1, 1, -5716.146, 521.3535, 176.8095, 3.353502, 120, 5, 1), -- 51755 (Area: 5706) (possible waypoints or random movement)
+(@CGUID+78, 51865, 1, 1, 1, -5700.877, 521.632, 194.0545, 0.3490658, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+79, 51722, 1, 1, 1, -5707.057, 526.4653, 176.5595, 2.984513, 120, 5, 1), -- 51722 (Area: 5706) (possible waypoints or random movement)
+(@CGUID+80, 51756, 1, 1, 1, -5730.926, 519.2454, 176.8095, 6.001951, 120, 5, 1), -- 51756 (Area: 5706) (possible waypoints or random movement)
+(@CGUID+81, 51714, 1, 1, 1, -5676.871, 469.0516, 194.5918, 4.121607, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+82, 51735, 1, 1, 1, -5752.766, 523.9653, 176.5178, 1.937315, 120, 0, 0), -- 51735 (Area: 5706)
+(@CGUID+83, 51865, 1, 1, 1, -5702.354, 534.0573, 194.0202, 1.029744, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+84, 51865, 1, 1, 1, -5703.543, 533.9114, 193.9504, 2.199115, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+85, 51714, 1, 1, 1, -5596.824, 443.1241, 186.7278, 4.277407, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+86, 51865, 1, 1, 1, -5703.813, 532.7483, 194.0125, 3.595378, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+87, 51865, 1, 1, 1, -5702.287, 532.8733, 194.2383, 5.864306, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+88, 51714, 1, 1, 1, -5627.504, 444.7137, 199.3283, 5.61794, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+89, 51757, 1, 1, 1, -5615.571, 524.7413, 163.3397, 2.111848, 120, 0, 0), -- 51757 (Area: 5706)
+(@CGUID+90, 51714, 1, 1, 1, -5622.894, 340.6817, 211.8644, 0.9264227, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+91, 51714, 1, 1, 1, -5562.518, 424.447, 187.0178, 3.015223, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+92, 51755, 1, 1, 1, -5593.307, 523.6389, 163.4918, 2.86234, 120, 0, 0), -- 51755 (Area: 5706)
+(@CGUID+93, 51726, 1, 1, 1, -5570.662, 368.8301, 215.8023, 5.126477, 120, 0, 0), -- 51726 (Area: 5706)
+(@CGUID+94, 51755, 1, 1, 1, -5606.859, 532.4739, 162.5823, 2.792527, 120, 0, 0), -- 51755 (Area: 5706)
+(@CGUID+95, 51757, 1, 1, 1, -5622.413, 536.6545, 162.9509, 6.038839, 120, 0, 0), -- 51757 (Area: 5706)
+(@CGUID+96, 51865, 1, 1, 1, -5721.603, 549.7639, 194.3203, 2.059489, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+97, 51722, 1, 1, 1, -5714.45, 545.8212, 176.5179, 4.031711, 120, 0, 0), -- 51722 (Area: 5706)
+(@CGUID+98, 51865, 1, 1, 1, -5721.965, 551.7413, 194.3925, 1.448623, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+99, 51722, 1, 1, 1, -5693.285, 545.8299, 176.284, 3.246312, 120, 0, 0), -- 51722 (Area: 5706)
+(@CGUID+100, 53418, 1, 1, 1, -5709.608, 538.2778, 176.518, 0.4014257, 120, 0, 0), -- 53418 (Area: 5706)
+(@CGUID+101, 51945, 1, 1, 1, -5715.84, 541.0382, 176.5258, 0.9599311, 120, 0, 0), -- 51945 (Area: 5706)
+(@CGUID+102, 51757, 1, 1, 1, -5707.749, 644.0608, 163.3819, 1.204277, 120, 0, 0), -- 51757 (Area: 5706)
+(@CGUID+103, 51936, 1, 1, 1, -5683.043, 647.9236, 163.3177, 5.585053, 120, 0, 0), -- 51936 (Area: 5706)
+(@CGUID+104, 51936, 1, 1, 1, -5714.335, 606.4132, 163.5486, 5.88176, 120, 0, 0), -- 51936 (Area: 5706)
+(@CGUID+105, 51942, 1, 1, 1, -5719.022, 621.6649, 163.4219, 5.899213, 120, 0, 0), -- 51942 (Area: 5706)
+(@CGUID+106, 51936, 1, 1, 1, -5685.469, 645.0625, 163.309, 5.846853, 120, 0, 0), -- 51936 (Area: 5706)
+(@CGUID+107, 51717, 1, 1, 1, -5715.403, 604.3837, 163.6398, 0.3316126, 120, 0, 0), -- 51717 (Area: 5706)
+(@CGUID+108, 51717, 1, 1, 1, -5701.385, 631.2604, 163.3387, 0.8028514, 120, 0, 0), -- 51717 (Area: 5706)
+(@CGUID+109, 51865, 1, 1, 1, -5738.972, 550.6684, 194.3103, 0.2268928, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+110, 51717, 1, 1, 1, -5691.924, 638.1754, 163.3039, 5.637414, 120, 0, 0), -- 51717 (Area: 5706)
+(@CGUID+111, 51722, 1, 1, 1, -5735.545, 548.4618, 176.5177, 2.338741, 120, 0, 0), -- 51722 (Area: 5706)
+(@CGUID+112, 51946, 1, 1, 1, -5725.933, 625.9695, 163.4957, 3.218016, 120, 0, 0), -- 51946 (Area: 5706)
+(@CGUID+113, 51865, 1, 1, 1, -5738.043, 549.8143, 194.3333, 0.5934119, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+114, 51942, 1, 1, 1, -5698.42, 633.5555, 163.3207, 5.445427, 120, 0, 0), -- 51942 (Area: 5706)
+(@CGUID+115, 51717, 1, 1, 1, -5713.769, 601.9254, 163.6719, 0.9075712, 120, 0, 0), -- 51717 (Area: 5706)
+(@CGUID+116, 51944, 1, 1, 1, -5714.068, 620.9114, 163.3864, 3.141593, 120, 0, 0), -- 51944 (Area: 5706)
+(@CGUID+117, 51717, 1, 1, 1, -5680.056, 641.1556, 163.0777, 0.8292802, 120, 5, 1), -- 51717 (Area: 5706) (possible waypoints or random movement)
+(@CGUID+118, 51936, 1, 1, 1, -5696.321, 635.7864, 163.3174, 6.126106, 120, 0, 0), -- 51936 (Area: 5706)
+(@CGUID+119, 51717, 1, 1, 1, -5720.672, 645.9879, 163.3825, 5.72468, 120, 0, 0), -- 51717 (Area: 5706)
+(@CGUID+120, 51936, 1, 1, 1, -5718.535, 646.1962, 163.3824, 3.490659, 120, 0, 0), -- 51936 (Area: 5706)
+(@CGUID+121, 51758, 1, 1, 1, -5703.066, 648.3286, 163.3895, 1.426456, 120, 5, 1), -- 51758 (Area: 5706) (possible waypoints or random movement)
+(@CGUID+122, 51942, 1, 1, 1, -5681.543, 661.691, 163.4648, 0, 120, 0, 0), -- 51942 (Area: 5706)
+(@CGUID+123, 51942, 1, 1, 1, -5681.253, 658.8629, 163.3542, 0.2268928, 120, 0, 0), -- 51942 (Area: 5706)
+(@CGUID+124, 51717, 1, 1, 1, -5719.08, 643.309, 163.3895, 1.780236, 120, 0, 0), -- 51717 (Area: 5706)
+(@CGUID+125, 51756, 1, 1, 1, -5710.2, 651.7934, 163.3819, 5.323254, 120, 0, 0), -- 51756 (Area: 5706)
+(@CGUID+126, 51946, 1, 1, 1, -5727.759, 631.1744, 163.551, 4.018413, 120, 5, 1), -- 51946 (Area: 5706) (possible waypoints or random movement)
+(@CGUID+127, 51942, 1, 1, 1, -5678.137, 660.4566, 163.3114, 3.124139, 120, 0, 0), -- 51942 (Area: 5706)
+(@CGUID+128, 51717, 1, 1, 1, -5682.747, 669.4233, 163.2782, 2.46456, 120, 5, 1), -- 51717 (Area: 5706) (possible waypoints or random movement)
+(@CGUID+129, 51758, 1, 1, 1, -5739.536, 641.6185, 163.4391, 1.417402, 120, 0, 0), -- 51758 (Area: 5706)
+(@CGUID+130, 51755, 1, 1, 1, -5744.328, 637.9358, 163.6499, 5.375614, 120, 0, 0), -- 51755 (Area: 5706)
+(@CGUID+131, 51756, 1, 1, 1, -5775.607, 610.2629, 165.2272, 4.035974, 120, 5, 1), -- 51756 (Area: 5706) (possible waypoints or random movement)
+(@CGUID+132, 51946, 1, 1, 1, -5704.965, 671.8438, 163.3821, 4.014257, 120, 0, 0), -- 51946 (Area: 5706)
+(@CGUID+133, 51945, 1, 1, 1, -5706.755, 668.5781, 163.3823, 4.18879, 120, 0, 0), -- 51945 (Area: 5706)
+(@CGUID+134, 51942, 1, 1, 1, -5688.882, 672.9827, 163.3063, 1.117011, 120, 0, 0), -- 51942 (Area: 5706)
+(@CGUID+135, 51944, 1, 1, 1, -5705.99, 670.283, 163.3821, 4.258604, 120, 0, 0), -- 51944 (Area: 5706)
+(@CGUID+136, 51941, 1, 1, 1, -5733.848, 654.0132, 163.3379, 0.2841505, 120, 0, 0), -- 51941 (Area: 5706)
+(@CGUID+137, 51935, 1, 1, 1, -5711.467, 667.875, 163.3824, 0.08726646, 120, 0, 0), -- 51935 (Area: 5706)
+(@CGUID+138, 51943, 1, 1, 1, -5716.115, 684.0538, 163.3142, 1.623156, 120, 0, 0), -- 51943 (Area: 5706)
+(@CGUID+139, 51717, 1, 1, 1, -5685.757, 670.8802, 163.4533, 0.9773844, 120, 0, 0), -- 51717 (Area: 5706)
+(@CGUID+140, 52008, 1, 1, 1, -5708.797, 662.9184, 163.3823, 0.9773844, 120, 0, 0), -- 52008 (Area: 5706)
+(@CGUID+141, 51943, 1, 1, 1, -5669.949, 687.1072, 163.1411, 2.415381, 120, 0, 0), -- 51943 (Area: 5706)
+(@CGUID+142, 51943, 1, 1, 1, -5707.717, 666.6094, 163.3823, 4.223697, 120, 0, 0), -- 51943 (Area: 5706)
+(@CGUID+143, 51944, 1, 1, 1, -5698.58, 678.2795, 163.4202, 4.388422, 120, 0, 0), -- 51944 (Area: 5706)
+(@CGUID+144, 51945, 1, 1, 1, -5713.346, 684.4566, 163.2969, 2.583087, 120, 0, 0), -- 51945 (Area: 5706)
+(@CGUID+145, 51733, 1, 1, 1, -5763.861, 550.1215, 176.5641, 4.729842, 120, 0, 0), -- 51733 (Area: 5706)
+(@CGUID+146, 51942, 1, 1, 1, -5688.769, 668.5851, 163.3454, 2.478368, 120, 0, 0), -- 51942 (Area: 5706)
+(@CGUID+147, 51755, 1, 1, 1, -5745.418, 630.5882, 164.2644, 2.879585, 120, 0, 0), -- 51755 (Area: 5706)
+(@CGUID+148, 51756, 1, 1, 1, -5784.477, 624.1635, 164.3154, 0.6682549, 120, 5, 1), -- 51756 (Area: 5706) (possible waypoints or random movement)
+(@CGUID+149, 51945, 1, 1, 1, -5750.272, 673.0625, 163.2886, 4.468043, 120, 0, 0), -- 51945 (Area: 5706)
+(@CGUID+150, 51941, 1, 1, 1, -5742.143, 675.9983, 163.3009, 1.850049, 120, 0, 0), -- 51941 (Area: 5706)
+(@CGUID+151, 51941, 1, 1, 1, -5772.908, 636.5851, 163.5573, 1.099557, 120, 0, 0), -- 51941 (Area: 5706)
+(@CGUID+152, 51941, 1, 1, 1, -5754.41, 669.7274, 163.3047, 5.585053, 120, 0, 0), -- 51941 (Area: 5706)
+(@CGUID+153, 51757, 1, 1, 1, -5781.788, 625.9861, 164.2517, 4.677482, 120, 0, 0), -- 51757 (Area: 5706)
+(@CGUID+154, 51941, 1, 1, 1, -5756.162, 667.7274, 163.3201, 0.05235988, 120, 0, 0), -- 51941 (Area: 5706)
+(@CGUID+155, 52562, 1, 1, 1, -5752.019, 667.3038, 163.3164, 2.321288, 120, 0, 0), -- 52562 (Area: 5706)
+(@CGUID+156, 51945, 1, 1, 1, -5738.276, 676.3906, 163.3239, 1.58825, 120, 0, 0), -- 51945 (Area: 5706)
+(@CGUID+157, 51941, 1, 1, 1, -5748.988, 669.3646, 163.316, 2.70526, 120, 0, 0), -- 51941 (Area: 5706)
+(@CGUID+158, 51935, 1, 1, 1, -5775.333, 637.4288, 163.4965, 0.1047198, 120, 0, 0), -- 51935 (Area: 5706)
+(@CGUID+159, 51941, 1, 1, 1, -5753.147, 672.3889, 163.2966, 4.799655, 120, 0, 0), -- 51941 (Area: 5706)
+(@CGUID+160, 51945, 1, 1, 1, -5718.125, 685.2118, 163.2882, 0.8726646, 120, 0, 0), -- 51945 (Area: 5706)
+(@CGUID+161, 51758, 1, 1, 1, -5709.035, 689.8316, 163.1528, 0, 120, 0, 0), -- 51758 (Area: 5706)
+(@CGUID+162, 51935, 1, 1, 1, -5788.397, 620.0635, 164.4618, 0.09207957, 120, 5, 1), -- 51935 (Area: 5706) (possible waypoints or random movement)
+(@CGUID+163, 51757, 1, 1, 1, -5788.203, 635.3854, 163.4523, 4.572762, 120, 0, 0), -- 51757 (Area: 5706)
+(@CGUID+164, 51941, 1, 1, 1, -5753.615, 687.9913, 163.1164, 5.707227, 120, 0, 0), -- 51941 (Area: 5706)
+(@CGUID+165, 51714, 1, 1, 1, -5627.134, 709.618, 154.8987, 2.548122, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+166, 51941, 1, 1, 1, -5749.288, 689.9566, 163.0284, 3.700098, 120, 0, 0), -- 51941 (Area: 5706)
+(@CGUID+167, 51945, 1, 1, 1, -5771.991, 661.6979, 163.2977, 2.268928, 120, 0, 0), -- 51945 (Area: 5706)
+(@CGUID+168, 51945, 1, 1, 1, -5793.417, 647.441, 163.309, 2.687807, 120, 0, 0), -- 51945 (Area: 5706)
+(@CGUID+169, 51714, 1, 1, 1, -5740.46, 787.8705, 153.5386, 0.05536608, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+170, 51943, 1, 1, 1, -5795.859, 644.7031, 163.3025, 2.391101, 120, 0, 0), -- 51943 (Area: 5706)
+(@CGUID+171, 51941, 1, 1, 1, -5800.465, 624.0608, 163.3946, 2.740167, 120, 0, 0), -- 51941 (Area: 5706)
+(@CGUID+172, 51935, 1, 1, 1, -5811.563, 604.5035, 163.934, 1.064651, 120, 0, 0), -- 51935 (Area: 5706)
+(@CGUID+173, 51943, 1, 1, 1, -5800.446, 626.8195, 163.3526, 3.420845, 120, 0, 0), -- 51943 (Area: 5706)
+(@CGUID+174, 51943, 1, 1, 1, -5807.573, 607.6702, 163.7157, 2.827433, 120, 0, 0), -- 51943 (Area: 5706)
+(@CGUID+175, 51944, 1, 1, 1, -5793.934, 590.691, 165.2877, 4.694936, 120, 0, 0), -- 51944 (Area: 5706)
+(@CGUID+176, 51945, 1, 1, 1, -5809.887, 609.2344, 163.5477, 5.183628, 120, 0, 0), -- 51945 (Area: 5706)
+(@CGUID+177, 51945, 1, 1, 1, -5802.615, 622.842, 163.3542, 2.216568, 120, 0, 0), -- 51945 (Area: 5706)
+(@CGUID+178, 51942, 1, 1, 1, -5793.905, 591.5278, 165.2813, 4.625123, 120, 0, 0), -- 51942 (Area: 5706)
+(@CGUID+179, 51714, 1, 1, 1, -5825.147, 690.5084, 156.8976, 5.554952, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+180, 51941, 1, 1, 1, -5793.838, 589.2899, 165.291, 4.607669, 120, 0, 0), -- 51941 (Area: 5706)
+(@CGUID+181, 51714, 1, 1, 1, -5837.444, 585.0133, 163.1623, 3.782508, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+182, 51717, 1, 1, 1, -5793.882, 585.3507, 165.2953, 4.747295, 120, 0, 0), -- 51717 (Area: 5706)
+(@CGUID+183, 51942, 1, 1, 1, -5796.575, 588.0746, 165.2912, 3.01942, 120, 0, 0), -- 51942 (Area: 5706)
+(@CGUID+184, 51942, 1, 1, 1, -5798.483, 589.0989, 165.29, 0.1396263, 120, 0, 0), -- 51942 (Area: 5706)
+(@CGUID+185, 51722, 1, 1, 1, -5784.766, 554.6545, 176.4327, 0.9424778, 120, 0, 0), -- 51722 (Area: 5706)
+(@CGUID+186, 51945, 1, 1, 1, -5793.906, 587.9288, 165.2906, 4.852015, 120, 0, 0), -- 51945 (Area: 5706)
+(@CGUID+187, 51942, 1, 1, 1, -5796.556, 588.9722, 165.2891, 3.054326, 120, 0, 0), -- 51942 (Area: 5706)
+(@CGUID+188, 51944, 1, 1, 1, -5793.894, 586.7361, 165.2928, 4.747295, 120, 0, 0), -- 51944 (Area: 5706)
+(@CGUID+189, 51865, 1, 1, 1, -5776.588, 550.0243, 194.095, 0.9075712, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+190, 51945, 1, 1, 1, -5824.613, 598.4288, 163.4235, 2.583087, 120, 0, 0), -- 51945 (Area: 5706)
+(@CGUID+191, 51722, 1, 1, 1, -5781.566, 543.5347, 176.5179, 1.134464, 120, 0, 0), -- 51722 (Area: 5706)
+(@CGUID+192, 52008, 1, 1, 1, -5795.094, 582.132, 165.5414, 1.48353, 120, 0, 0), -- 52008 (Area: 5706)
+(@CGUID+193, 51941, 1, 1, 1, -5827.691, 596.3333, 163.3924, 2.129302, 120, 0, 0), -- 51941 (Area: 5706)
+(@CGUID+194, 51865, 1, 1, 1, -5776.42, 548.9705, 194.171, 6.091199, 120, 0, 0), -- 51865 (Area: 5706)
+(@CGUID+195, 51750, 1, 1, 1, -5837.288, 603.3195, 162.9044, 3.490659, 120, 0, 0), -- 51750 (Area: 5706)
+(@CGUID+196, 51714, 1, 1, 1, -5861.537, 554.002, 163.6794, 1.694182, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+197, 53418, 1, 1, 1, -5800.891, 538.6614, 176.5178, 3.228859, 120, 0, 0), -- 53418 (Area: 5706)
+(@CGUID+198, 51714, 1, 1, 1, -5903.984, 648.61, 153.8709, 0.06720779, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+199, 51722, 1, 1, 1, -5787.196, 542.7465, 176.5179, 4.939282, 120, 0, 0), -- 51722 (Area: 5706)
+(@CGUID+200, 51722, 1, 1, 1, -5795.538, 539.5989, 176.5179, 5.096361, 120, 0, 0), -- 51722 (Area: 5706)
+(@CGUID+201, 51734, 1, 1, 1, -5774.717, 523.9167, 176.6318, 0.8552113, 120, 0, 0), -- 51734 (Area: 5706)
+(@CGUID+202, 51714, 1, 1, 1, -5884.849, 620.7791, 158.0151, 5.168957, 120, 0, 0), -- 51714 (Area: 5706)
+(@CGUID+203, 51752, 1, 1, 1, -5930.05, 526.5265, 154.2203, 4.382598, 120, 0, 0); -- 51752 (Area: 5706)
+
+SET @OGUID := 200280;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+30;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
+(@OGUID+0, 208322, 1, 1, 1, -5807.332, 533.5417, 176.4345, 5.969027, 0, 0, 0, 1, 120, 255, 1), -- 208322 (Area: 5706)
+(@OGUID+1, 208201, 1, 1, 1, -5688.999, 606.559, 163.0309, 0, 0, 0, 0, 1, 120, 255, 1), -- 208201 (Area: 5706)
+(@OGUID+2, 208201, 1, 1, 1, -5676.182, 637.5139, 163.02, 0, 0, 0, 0, 1, 120, 255, 1), -- 208201 (Area: 5706)
+(@OGUID+3, 208201, 1, 1, 1, -5720.035, 619.2014, 163.3823, 0, 0, 0, 0, 1, 120, 255, 1), -- 208201 (Area: 5706)
+(@OGUID+4, 208201, 1, 1, 1, -5714.158, 607.4792, 164.3322, 6.19592, 0, 0, 0, 1, 120, 255, 1), -- 208201 (Area: 5706)
+(@OGUID+5, 208203, 1, 1, 1, -5699.99, 632.7969, 163.259, 0.4363316, 0, 0, 0, 1, 120, 255, 1), -- 208203 (Area: 5706)
+(@OGUID+6, 208203, 1, 1, 1, -5672.493, 653.809, 162.9627, 0, 0, 0, 0, 1, 120, 255, 1), -- 208203 (Area: 5706)
+(@OGUID+7, 208201, 1, 1, 1, -5683.978, 647.3195, 163.2395, 0, 0, 0, 0, 1, 120, 255, 1), -- 208201 (Area: 5706)
+(@OGUID+8, 208203, 1, 1, 1, -5682.505, 659.8993, 163.2843, 0, 0, 0, 0, 1, 120, 255, 1), -- 208203 (Area: 5706)
+(@OGUID+9, 208202, 1, 1, 1, -5707.547, 661.9636, 164.5816, 0, 0, 0, 0, 1, 120, 255, 1), -- 208202 (Area: 5706)
+(@OGUID+10, 208203, 1, 1, 1, -5690.106, 674.0712, 163.2372, 0, 0, 0, 0, 1, 120, 255, 1), -- 208203 (Area: 5706)
+(@OGUID+11, 208201, 1, 1, 1, -5710.354, 664.9948, 163.299, 0, 0, 0, 0, 1, 120, 255, 1), -- 208201 (Area: 5706)
+(@OGUID+12, 208203, 1, 1, 1, -5711.762, 663.6059, 164.7674, 0, 0, 0, 0, 1, 120, 255, 1), -- 208203 (Area: 5706)
+(@OGUID+13, 208202, 1, 1, 1, -5738.927, 667.0139, 163.2099, 0, 0, 0, 0, 1, 120, 255, 1), -- 208202 (Area: 5706)
+(@OGUID+14, 208201, 1, 1, 1, -5731.021, 690.5243, 163.0176, 0, 0, 0, 0, 1, 120, 255, 1), -- 208201 (Area: 5706)
+(@OGUID+15, 208201, 1, 1, 1, -5720.979, 686.0035, 163.1892, 0, 0, 0, 0, 1, 120, 255, 1), -- 208201 (Area: 5706)
+(@OGUID+16, 208201, 1, 1, 1, -5736.818, 676.941, 163.2449, 0, 0, 0, 0, 1, 120, 255, 1), -- 208201 (Area: 5706)
+(@OGUID+17, 208202, 1, 1, 1, -5751.677, 692.0938, 162.9395, 0, 0, 0, 0, 1, 120, 255, 1), -- 208202 (Area: 5706)
+(@OGUID+18, 208203, 1, 1, 1, -5775.547, 662.4236, 164.0997, 0, 0, 0, 0, 1, 120, 255, 1), -- 208203 (Area: 5706)
+(@OGUID+19, 208202, 1, 1, 1, -5712.768, 697.8854, 162.9631, 0, 0, 0, 0, 1, 120, 255, 1), -- 208202 (Area: 5706)
+(@OGUID+20, 208202, 1, 1, 1, -5793.753, 649.1111, 163.208, 0, 0, 0, 0, 1, 120, 255, 1), -- 208202 (Area: 5706)
+(@OGUID+21, 208202, 1, 1, 1, -5792.893, 589.033, 165.9749, 0, 0, 0, 0, 1, 120, 255, 1), -- 208202 (Area: 5706)
+(@OGUID+22, 208203, 1, 1, 1, -5803.34, 622.2344, 164.2114, 0, 0, 0, 0, 1, 120, 255, 1), -- 208203 (Area: 5706)
+(@OGUID+23, 208324, 1, 1, 1, -5780.96, 544.8264, 176.4345, 4.293511, 0, 0, 0, 1, 120, 255, 1), -- 208324 (Area: 5706)
+(@OGUID+24, 208202, 1, 1, 1, -5873.549, 620.4827, 165.652, 0, 0, 0, 0, 1, 120, 255, 1), -- 208202 (Area: 5706)
+(@OGUID+25, 208202, 1, 1, 1, -5797.971, 590.5278, 165.2003, 0, 0, 0, 0, 1, 120, 255, 1), -- 208202 (Area: 5706)
+(@OGUID+26, 208202, 1, 1, 1, -5869.266, 617.1614, 170.3381, 0, 0, 0, 0, 1, 120, 255, 1), -- 208202 (Area: 5706)
+(@OGUID+27, 208202, 1, 1, 1, -5872.731, 620.2656, 165.606, 0, 0, 0, 0, 1, 120, 255, 1), -- 208202 (Area: 5706)
+(@OGUID+28, 208202, 1, 1, 1, -5795.085, 584.3073, 166.4064, 0, 0, 0, 0, 1, 120, 255, 1), -- 208202 (Area: 5706)
+(@OGUID+29, 208202, 1, 1, 1, -5825.406, 597.3542, 163.4057, 0, 0, 0, 0, 1, 120, 255, 1), -- 208202 (Area: 5706)
+(@OGUID+30, 208323, 1, 1, 1, -5778.668, 543.3333, 176.4345, 3.953173, 0, 0, 0, 1, 120, 255, 1); -- 208323 (Area: 5706)
+
+UPDATE `creature_template` SET `InhabitType`=4 WHERE  `entry`=51865;
+UPDATE `creature` SET `spawndist`=1, `MovementType`=5 WHERE `id` IN (51714,51752);
+-- Resort Guest SAI
+SET @GUID := -286377;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=51944;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(@GUID,0,0,0,1,0,100,0,300,5000,6000,8000,5,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Resort Guest - Out of Combat - Play Emote 1");
+
+-- Resort Guest SAI
+SET @GUID := -286388;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=51942;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(@GUID,0,0,0,1,0,100,0,100,500,3000,6000,5,94,0,0,0,0,0,1,0,0,0,0,0,0,0,"Resort Guest - Out of Combat - Play Emote 94");
+
+-- Resort Guest SAI
+SET @GUID := -286419;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=51935;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(@GUID,0,0,0,1,0,100,0,200,3000,6000,7000,5,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Resort Guest - Out of Combat - Play Emote 1");
+
+-- Resort Guest SAI
+SET @GUID := -286380;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=51935;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(@GUID,0,0,0,1,0,100,0,200,3000,6000,7000,5,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Resort Guest - Out of Combat - Play Emote 1");
+
+-- Resort Guest SAI
+SET @GUID := -286385;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=51935;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(@GUID,0,0,0,1,0,100,0,200,3000,6000,7000,5,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Resort Guest - Out of Combat - Play Emote 1");
+
+-- Resort Guest SAI
+SET @GUID := -286381;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=51935;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(@GUID,0,0,0,1,0,100,0,200,3000,6000,7000,5,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Resort Guest - Out of Combat - Play Emote 1");
+
+DELETE FROM `creature_addon` WHERE `guid` IN (286307,286287,286265,286264,286289,286288,286293,286458,286361,286444,286448,286445,286413,286454,286451,286433,286438,286432,286434,286431,286429,286428,286420,286410,286416,286418,286411,286417,286421,286399,286405,286404,286398,286395,286400,286407,286383,286384,286364,286367,286371,286379,286375,286369,286366,286365,286368,286376);
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES 
+(286376,0,0,0,1,415, ''),
+(286368,0,0,0,1,415, ''),
+(286365,0,0,0,1,415, ''),
+(286366,0,0,0,1,415, ''),
+(286369,0,0,0,0,69, ''),
+(286375,0,0,0,1,415, ''),
+(286379,0,0,0,1,415, ''),
+(286371,0,0,3,1,0, ''),
+(286367,0,0,0,1,415, ''),
+(286364,0,0,0,1,415, ''),
+(286384,0,0,0,1,415, ''),
+(286383,0,0,3,1,0, ''),
+(286407,0,0,0,1,69, ''),
+(286400,0,0,0,1,415, ''),
+(286395,0,0,0,1,415, ''),
+(286398,0,0,0,1,23, ''),
+(286404,0,0,3,1,0, ''),
+(286405,0,0,0,1,415, ''),
+(286399,0,0,0,1,415, ''),
+(286421,0,0,0,1,415, ''),
+(286417,0,0,0,1,415, ''),
+(286411,0,0,0,1,415, ''),
+(286418,0,0,0,1,415, ''),
+(286416,0,0,0,1,415, ''),
+(286410,0,0,8,1,0, ''),
+(286420,0,0,8,1,0, ''),
+(286413,0,0,8,1,0, ''),
+(286428,0,0,0,1,415, ''),
+(286429,0,0,0,1,415, ''),
+(286431,0,0,0,1,415, ''),
+(286434,0,0,0,1,415, ''),
+(286432,0,0,0,1,415, ''),
+(286438,0,0,0,1,415, ''),
+(286433,0,0,0,1,10, ''),
+(286451,0,0,0,1,415, ''),
+(286454,0,0,0,1,415, ''),
+(286445,0,0,0,1,7, ''),
+(286448,0,0,0,1,7, ''),
+(286444,0,0,0,1,7, ''),
+(286361,0,0,0,1,234, ''),
+(286458,0,0,0,1,234, ''),
+(286293,0,0,0,1,234, ''),
+(286307,0,0,0,1,234, ''),
+(286288,0,0,0,1,0, '96028'),
+(286289,0,0,0,1,0, '96028'),
+(286264,0,0,0,1,0, '96028'),
+(286265,0,0,0,1,0, '96040'),
+(286287,0,0,0,1,0, '96040');
+
+-- Pathing for  Entry: 51946 'TDB FORMAT' 
+SET @NPC := 286387;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5788.926,`position_y`=607.9293,`position_z`=165.2974 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,-5788.926,607.9293,165.2974,0,0,0,0,100,0),
+(@PATH,2,-5790.426,617.9293,164.5474,0,0,0,0,100,0),
+(@PATH,3,-5791.426,623.4293,164.2974,0,0,0,0,100,0),
+(@PATH,4,-5792.438,629.6313,163.5284,0,0,0,0,100,0),
+(@PATH,5,-5781.063,644.6859,163.6394,0,0,0,0,100,0),
+(@PATH,6,-5773.629,649.9146,163.5963,0,0,0,0,100,0),
+(@PATH,7,-5755.208,659.1642,163.3571,0,0,0,0,100,0),
+(@PATH,8,-5731.594,666.4515,163.6333,0,0,0,0,100,0),
+(@PATH,9,-5716.327,658.214,163.6395,0,0,0,0,100,0),
+(@PATH,10,-5707.683,637.6583,163.6191,0,0,0,0,100,0),
+(@PATH,11,-5710.278,622.7555,163.4361,0,0,0,0,100,0),
+(@PATH,12,-5712.528,625.0055,163.4361,0,0,0,0,100,0),
+(@PATH,13,-5716.778,626.0055,163.4361,0,0,0,0,100,0),
+(@PATH,14,-5718.528,626.5055,163.4361,0,0,0,0,100,0),
+(@PATH,15,-5719.528,626.5055,163.4361,0,0,0,0,100,0),
+(@PATH,16,-5720.528,626.5055,163.4361,0,0,0,0,100,0),
+(@PATH,17,-5721.528,626.5055,163.4361,0,0,0,0,100,0),
+(@PATH,18,-5722.778,626.5055,163.6861,0,0,0,0,100,0),
+(@PATH,19,-5724.778,626.0055,163.6861,0,0,0,0,100,0),
+(@PATH,20,-5725.048,626.0278,163.8128,0,0,0,0,100,0),
+(@PATH,21,-5727.048,625.7778,163.8128,0,0,0,0,100,0),
+(@PATH,22,-5732.548,619.2778,164.3128,0,0,0,0,100,0),
+(@PATH,23,-5735.298,616.2778,164.8128,0,0,0,0,100,0),
+(@PATH,24,-5735.542,616.0571,165.0257,0,0,0,0,100,0),
+(@PATH,25,-5736.542,615.0571,165.0257,0,0,0,0,100,0),
+(@PATH,26,-5742.292,611.3071,165.5257,0,0,0,0,100,0);
+
+-- Pathing for  Entry: 51946 'TDB FORMAT' 
+SET @NPC := 286373;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5732.034,`position_y`=626.0606,`position_z`=163.8376 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,-5732.034,626.0606,163.8376,0,0,0,0,100,0),
+(@PATH,2,-5732.243,625.7847,163.7238,0,0,0,0,100,0),
+(@PATH,3,-5732.04,625.6913,164.0835,0,0,0,0,100,0),
+(@PATH,4,-5730.54,612.1913,164.5835,0,0,0,0,100,0),
+(@PATH,5,-5731.412,621.9445,164.1074,0,0,0,0,100,0),
+(@PATH,6,-5732.08,625.9236,163.8257,0,0,0,0,100,0);
+
+-- Pathing for  Entry: 51722 'TDB FORMAT' 
+SET @NPC := 286311;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5773.932,`position_y`=536.3438,`position_z`=176.7003 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,-5773.932,536.3438,176.7003,0,10000,0,0,100,0),
+(@PATH,2,-5773.641,536.2739,176.8456,0,0,0,0,100,0),
+(@PATH,3,-5770.578,533.2537,176.616,0,0,0,0,100,0),
+(@PATH,4,-5770.363,532.8978,176.8072,0,0,0,0,100,0),
+(@PATH,5,-5767.863,530.8978,176.8072,0,0,0,0,100,0),
+(@PATH,6,-5766.079,524.7371,176.799,0,0,0,0,100,0),
+(@PATH,7,-5771.483,518.7049,176.5595,0,0,0,0,100,0),
+(@PATH,8,-5771.483,518.7049,176.5595,1.762783,10000,0,0,100,0),
+(@PATH,9,-5767.021,521.6589,176.497,0,0,0,0,100,0),
+(@PATH,10,-5766.021,525.1589,176.497,0,0,0,0,100,0),
+(@PATH,11,-5767.771,530.9089,176.497,0,0,0,0,100,0),
+(@PATH,12,-5770.771,533.4089,176.497,0,0,0,0,100,0),
+(@PATH,13,-5773.771,536.1589,176.747,0,0,0,0,100,0),
+(@PATH,14,-5778.271,539.9089,176.747,0,0,0,0,100,0);