DB/Spawns: Added Boralus guards

Closes #28351
Closes #28354

1 files changed, 445 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_10_10_01_world.sql b/sql/updates/world/master/2022_10_10_01_world.sql
new file mode 100644
index 00000000000..258265432ac
--- /dev/null
+++ b/sql/updates/world/master/2022_10_10_01_world.sql
@@ -0,0 +1,445 @@
+-- Harbor Guard, Boralus
+SET @PHASE := 0;
+SET @SWAP := -1;
+SET @CGUID := 850489;
+SET @TEXTID := 570009;
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+109;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(@CGUID+0, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1034.3021, -643.67883, 6.5981894, 5.769036769866943359, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+1, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1061.8959, -605.31946, 10.095992, 3.233160257339477539, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+2, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1041.3942, -650.84894, 6.601241, 2.507797002792358398, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+3, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1184.7084, -646.9149, 29.308945, 1.885871648788452148, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+4, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1152.0781, -621.30206, 29.030197, 4.007323741912841796, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+5, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1103.467, -625.17883, 17.69587, 3.104446887969970703, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+6, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1120.816, -653.52606, 28.76035, 1.857107400894165039, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+7, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1210.6979, -635.3941, 29.10672, 2.006209850311279296, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+8, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1103.0834, -619.0643, 17.692612, 3.102559328079223632, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+9, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1144.6858, -626.53644, 29.158125, 0.625758707523345947, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+10, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1181.6198, -647.6215, 29.19025, 1.72223055362701416, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+11, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1108.9445, -653.35767, 28.850712, 1.500683784484863281, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+12, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1204.0632, -594.7064, 29.726881, 4.568369865417480468, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+13, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1118.7916, -531.25696, 17.636873, 2.627381563186645507, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+14, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1212.2952, -597.7535, 29.998726, 2.945282459259033203, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+15, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1196.5122, -573.15454, 29.338512, 0.597621858119964599, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+16, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1121.3629, -526.1632, 17.636871, 2.663304805755615234, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+17, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1178.5851, -541.7344, 28.706894, 2.026967525482177734, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+18, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1215.0573, -573.4514, 29.999407, 3.042416572570800781, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+19, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1226.882, -632.1875, 29.917624, 3.031175851821899414, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+20, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1150.5504, -497.9462, 28.94168, 4.186792373657226562, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+21, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1137.0243, -492.36978, 28.88535, 4.381020545959472656, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+22, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1083.3281, -503.30557, 20.411716, 4.480020523071289062, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+23, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1077.8594, -501.7396, 20.411736, 4.422213554382324218, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+24, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1140.6146, -481.99652, 30.503826, 0.692293524742126464, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+25, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1154.901, -487.25, 30.503826, 2.095669031143188476, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+26, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1079.7101, -489.0955, 20.422256, 6.019900321960449218, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+27, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1088.1892, -491.84027, 20.745968, 2.924517393112182617, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+28, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1081.4774, -482.6632, 20.422256, 6.037154674530029296, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+29, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1089.9166, -485.24307, 20.745966, 2.849184989929199218, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+30, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1099.7135, -477.14584, 36.5165, 3.296612024307250976, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+31, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1056.2101, -487.01562, 9.783455, 0.874796748161315917, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+32, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1071.9983, -482.1979, 36.507454, 6.010880470275878906, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+33, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1098.8577, -467.89236, 15.752041, 1.268200516700744628, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+34, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1247.0122, -605.44446, 29.866236, 3.018009185791015625, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+35, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1251.7743, -573.5781, 30.08463, 2.821799278259277343, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+36, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1155.3802, -465.18228, 22.684223, 1.450215816497802734, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+37, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1139.651, -457.14758, 1.5553675, 1.341344237327575683, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+38, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1141.257, -437.01562, 1.5991011, 2.755962610244750976, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+39, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1075.2344, -469.4705, 36.46036, 6.021981239318847656, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+40, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1103.0312, -456.08682, 15.75465, 4.387400627136230468, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+41, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1130.1858, -434.28473, 9.151121, 4.266849994659423828, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+42, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1137.0122, -437.2639, 9.073485, 4.064449310302734375, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+43, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1057.4219, -478.59027, 44.455364, 2.887667655944824218, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+44, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1124.2865, -432.19965, 9.091909, 4.20603036880493164, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+45, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1064.8073, -458.96182, 36.388645, 0.055322378873825073, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+46, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1060.6198, -466.29514, 44.446175, 2.876565456390380859, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+47, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1094.1146, -415.12326, 8.244351, 3.864057540893554687, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+48, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1092.0892, -414.81647, 20.852787, 2.881898403167724609, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+49, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1084.9688, -412.40277, 8.24435, 5.091888427734375, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+50, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1070.7596, -414.58847, 20.30833, 1.330700993537902832, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+51, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1058.1562, -441.3837, 36.404633, 1.450215816497802734, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+52, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1067.1927, -428.17188, 8.211898, 5.984140872955322265, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+53, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1057.5312, -441.24133, 45.095848, 1.6782304048538208, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+54, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1045.9254, -473.96008, 8.469385, 2.958672761917114257, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+55, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1047.1754, -464.54514, 8.469385, 3.08473515510559082, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+56, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1027.3611, -454.15973, 8.469385, 3.934971332550048828, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+57, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1014.0313, -453.12848, 8.469384, 5.370421409606933593, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+58, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1019.5035, -473.06598, 44.40199, 1.416924715042114257, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+59, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 1009.3472, -472.04166, 44.39414, 1.416924715042114257, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+60, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 995.86285, -451.11285, 8.469383, 4.543698787689208984, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+61, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 993.43054, -472.51562, 8.469383, 2.07044839859008789, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+62, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 987.5399, -459.8559, 44.411095, 0.828307569026947021, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+63, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 975.3125, -435.49133, 45.09585, 1.404638528823852539, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+64, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 975.3906, -435.80557, 36.404907, 1.450215816497802734, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+65, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 975.1476, -456.4896, 9.354272, 4.78944253921508789, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+66, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 2, 970.6858, -488.85938, 50.51387, 1.449518084526062011, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+67, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 932.98267, -466.14758, 8.482045, 1.722745060920715332, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+68, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 931.16144, -473.2604, 44.39513, 1.586837649345397949, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+69, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 917.40454, -488.14932, 48.589867, 5.136312484741210937, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+70, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 941.3455, -472.55035, 44.39677, 1.586837649345397949, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+71, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 2, 937.0643, -486.93228, 46.56451, 1.813459157943725585, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+72, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 2, 895.36456, -495.09027, 50.508125, 1.449518084526062011, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+73, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 892.67883, -440.89236, 45.095848, 1.6782304048538208, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+74, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 889, -462.25522, 44.285713, 2.266650915145874023, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+75, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 892.6632, -441.56076, 36.404945, 1.812742948532104492, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+76, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 895.0278, -461.63196, 9.353762, 5.149339199066162109, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+77, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 880.0868, -492.42014, 48.58915, 5.043710708618164062, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+78, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 863.6198, -481.7587, 44.41159, 1.691204786300659179, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+79, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 853.5608, -483.533, 44.411636, 1.691204786300659179, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+80, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 2, 861.24133, -496.3264, 46.564507, 1.821044325828552246, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+81, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 839.0052, -466.8455, 8.518489, 5.061078548431396484, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+82, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 2, 685.55554, -562.38367, 46.56451, 1.915830612182617187, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+83, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 682.84375, -547.5226, 44.411537, 2.034405708312988281, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+84, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 668.5018, -571.76215, 48.588943, 5.451231956481933593, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+85, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 673.9653, -552.5764, 44.41169, 2.034405708312988281, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+86, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 2, 651.3768, -587.55206, 50.51471, 2.083998680114746093, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+87, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 625.184, -540.8403, 45.095848, 2.229593753814697265, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+88, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 625.5816, -541.40106, 36.404648, 2.256578445434570312, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+89, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 617.6042, -590.3924, 44.396873, 2.153968334197998046, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+90, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 609.3889, -596.4792, 44.397568, 2.153968334197998046, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+91, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 2, 621.9097, -604.4618, 46.56451, 2.085245609283447265, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+92, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 607.88367, -614.6458, 48.590736, 5.42398834228515625, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+93, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 559.934, -591.658, 36.40496, 2.256578445434570312, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+94, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 559.26044, -590.9653, 45.067493, 2.357693910598754882, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+95, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 2, 591.2934, -634.2969, 50.51132, 2.047462701797485351, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+96, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 2, 564.19965, -654.65625, 46.56451, 2.225885391235351562, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+97, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 557.80206, -641.23267, 44.41151, 2.306891918182373046, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+98, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 550.61115, -648.50696, 44.41157, 2.306891918182373046, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+99, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 550.21875, -668.9566, 48.59039, 5.74417734146118164, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+100, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 500.43057, -649.3524, 45.09585, 2.557073593139648437, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+101, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 500.70486, -649.7083, 36.40481, 2.403389930725097656, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+102, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 2, 537.96356, -688.2969, 50.508606, 2.269807815551757812, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+103, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 2, 513.6667, -712.3351, 46.56451, 2.582665443420410156, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+104, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 505.592, -699.36285, 44.411507, 2.426956892013549804, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+105, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 499.32465, -707.44617, 44.411568, 2.426956892013549804, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+106, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 501.5104, -727.5347, 48.589497, 6.022709846496582031, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+107, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 450.04514, -715.3316, 36.404766, 2.609012603759765625, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+108, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 2, 491.56424, -748.3524, 50.51389, 2.260369777679443359, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0),
+(@CGUID+109, 136633, 1643, 0, 0, 0, @PHASE, 0, @SWAP, 0, 1, 449.72223, -715.0625, 45.095848, 2.523899555206298828, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0);
+
+DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+109;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`MountCreatureID`,`bytes1`,`bytes2`,`emote`,`aiAnimKit`,`movementAnimKit`,`meleeAnimKit`,`visibilityDistanceType`,`auras`) VALUES
+(@CGUID+0,0,0,0,0,1,717,0,0,0,0,'131700'),
+(@CGUID+1,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+2,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+3,0,0,0,0,1,717,0,0,0,0,'131700'),
+(@CGUID+4,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+5,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+6,0,0,0,0,1,717,0,0,0,0,'131700'),
+(@CGUID+7,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+8,0,0,0,0,1,717,0,0,0,0,'131700'),
+(@CGUID+9,0,0,0,0,1,717,0,0,0,0,'131700'),
+(@CGUID+10,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+11,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+12,0,82148,0,0,1,0,0,0,0,0,'131700'),
+(@CGUID+13,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+14,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+15,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+16,0,0,0,0,1,884,0,0,0,0,'131700'),
+(@CGUID+17,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+18,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+19,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+20,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+21,0,0,0,0,1,717,0,0,0,0,'131700'),
+(@CGUID+22,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+23,0,0,0,0,1,884,0,0,0,0,'131700'),
+(@CGUID+24,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+25,0,0,0,0,1,717,0,0,0,0,'131700'),
+(@CGUID+26,0,0,0,0,1,717,0,0,0,0,'131700'),
+(@CGUID+27,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+28,0,0,0,0,1,717,0,0,0,0,'131700'),
+(@CGUID+29,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+30,0,0,0,0,0,0,0,0,0,0,'131700'),
+(@CGUID+31,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+32,0,0,0,0,1,716,0,0,0,0,'131700'),
+(@CGUID+33,0,0,0,0,1,717,0,0,0,0,'131700'),
+(@CGUID+34,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+35,0,0,0,0,1,717,0,0,0,0,'131700'),
+(@CGUID+36,0,0,0,0,2,214,0,0,0,0,'131700'),
+(@CGUID+37,0,0,0,0,2,214,0,0,0,0,'131700'),
+(@CGUID+38,0,0,0,0,2,214,0,0,0,0,'131700'),
+(@CGUID+39,0,0,0,0,1,716,0,0,0,0,'131700'),
+(@CGUID+40,0,0,0,0,1,716,0,0,0,0,'131700'),
+(@CGUID+41,0,0,0,0,2,214,0,0,0,0,'131700'),
+(@CGUID+42,0,0,0,0,2,214,0,0,0,0,'131700'),
+(@CGUID+43,0,0,0,0,1,716,0,0,0,0,'131700'),
+(@CGUID+44,0,0,0,0,2,214,0,0,0,0,'131700'),
+(@CGUID+45,0,0,0,0,2,214,0,0,0,0,'131700'),
+(@CGUID+46,0,0,0,0,1,716,0,0,0,0,'131700'),
+(@CGUID+47,0,0,0,0,1,716,0,0,0,0,'131700'),
+(@CGUID+48,0,0,0,0,2,0,15908,0,0,0,'131700'),
+(@CGUID+49,0,0,0,0,1,717,0,0,0,0,'131700'),
+(@CGUID+50,0,0,0,0,2,0,15908,0,0,0,'131700'),
+(@CGUID+51,0,0,0,0,2,214,0,0,0,0,'131700'),
+(@CGUID+52,0,0,0,0,1,716,0,0,0,0,'131700'),
+(@CGUID+53,0,0,0,0,2,214,0,0,0,0,'131700'),
+(@CGUID+54,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+55,0,0,0,0,1,884,0,0,0,0,'131700'),
+(@CGUID+56,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+57,0,0,0,0,1,884,0,0,0,0,'131700'),
+(@CGUID+58,0,0,0,0,1,716,0,0,0,0,'131700'),
+(@CGUID+59,0,0,0,0,1,716,0,0,0,0,'131700'),
+(@CGUID+60,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+61,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+62,0,0,0,0,0,0,0,0,0,0,'131700'),
+(@CGUID+63,0,0,0,0,2,214,0,0,0,0,'131700'),
+(@CGUID+64,0,0,0,0,2,214,0,0,0,0,'131700'),
+(@CGUID+65,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+66,0,0,0,0,0,714,0,0,0,0,'131700'),
+(@CGUID+67,0,0,0,0,1,716,0,0,0,0,'131700'),
+(@CGUID+68,0,0,0,0,1,716,0,0,0,0,'131700'),
+(@CGUID+69,0,0,0,0,2,214,0,0,0,0,'131700'),
+(@CGUID+70,0,0,0,0,1,716,0,0,0,0,'131700'),
+(@CGUID+71,0,0,0,0,0,714,0,0,0,0,'131700'),
+(@CGUID+72,0,0,0,0,0,714,0,0,0,0,'131700'),
+(@CGUID+73,0,0,0,0,2,214,0,0,0,0,'131700'),
+(@CGUID+74,0,0,0,0,0,0,0,0,0,0,'131700'),
+(@CGUID+75,0,0,0,0,2,214,0,0,0,0,'131700'),
+(@CGUID+76,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+77,0,0,0,0,2,214,0,0,0,0,'131700'),
+(@CGUID+78,0,0,0,0,1,716,0,0,0,0,'131700'),
+(@CGUID+79,0,0,0,0,1,716,0,0,0,0,'131700'),
+(@CGUID+80,0,0,0,0,0,714,0,0,0,0,'131700'),
+(@CGUID+81,0,0,0,0,1,885,0,0,0,0,'131700'),
+(@CGUID+82,0,0,0,0,0,714,0,0,0,0,'131700'),
+(@CGUID+83,0,0,0,0,1,716,0,0,0,0,'131700'),
+(@CGUID+84,0,0,0,0,2,214,0,0,0,0,'131700'),
+(@CGUID+85,0,0,0,0,1,716,0,0,0,0,'131700'),
+(@CGUID+86,0,0,0,0,0,714,0,0,0,0,'131700'),
+(@CGUID+87,0,0,0,0,2,214,0,0,0,0,'131700'),
+(@CGUID+88,0,0,0,0,2,214,0,0,0,0,'131700'),
+(@CGUID+89,0,0,0,0,1,716,0,0,0,0,'131700'),
+(@CGUID+90,0,0,0,0,1,716,0,0,0,0,'131700'),
+(@CGUID+91,0,0,0,0,0,714,0,0,0,0,'131700'),
+(@CGUID+92,0,0,0,0,2,214,0,0,0,0,'131700'),
+(@CGUID+93,0,0,0,0,2,214,0,0,0,0,'131700'),
+(@CGUID+94,0,0,0,0,2,214,0,0,0,0,'131700'),
+(@CGUID+95,0,0,0,0,0,714,0,0,0,0,'131700'),
+(@CGUID+96,0,0,0,0,0,714,0,0,0,0,'131700'),
+(@CGUID+97,0,0,0,0,1,716,0,0,0,0,'131700'),
+(@CGUID+98,0,0,0,0,1,716,0,0,0,0,'131700'),
+(@CGUID+99,0,0,0,0,2,214,0,0,0,0,'131700'),
+(@CGUID+100,0,0,0,0,2,214,0,0,0,0,'131700'),
+(@CGUID+101,0,0,0,0,2,214,0,0,0,0,'131700'),
+(@CGUID+102,0,0,0,0,0,714,0,0,0,0,'131700'),
+(@CGUID+103,0,0,0,0,0,714,0,0,0,0,'131700'),
+(@CGUID+104,0,0,0,0,1,716,0,0,0,0,'131700'),
+(@CGUID+105,0,0,0,0,1,716,0,0,0,0,'131700'),
+(@CGUID+106,0,0,0,0,2,214,0,0,0,0,'131700'),
+(@CGUID+107,0,0,0,0,2,214,0,0,0,0,'131700'),
+(@CGUID+108,0,0,0,0,0,714,0,0,0,0,'131700'),
+(@CGUID+109,0,0,0,0,2,214,0,0,0,0,'131700');
+
+-- Pathing for Harbor Guard Entry: 136633
+SET @NPC := @CGUID+12;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `wander_distance`=0,`MovementType`=2,`position_x`=1163.6649,`position_y`=-542.0018,`position_z`=29.019638 WHERE `guid`=@NPC;
+UPDATE `creature_addon` SET `path_id`=@PATH WHERE `guid`=@NPC;
+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,1174.3837,-537.92883,28.892218,NULL,0,0,0,100,0),
+(@PATH,2,1180.4688,-536.34894,28.642218,NULL,0,0,0,100,0),
+(@PATH,3,1189.8108,-537.0052,28.392218,NULL,0,0,0,100,0),
+(@PATH,4,1193.2153,-543.15625,28.517218,NULL,0,0,0,100,0),
+(@PATH,5,1198.1302,-554.40625,29.014044,NULL,0,0,0,100,0),
+(@PATH,6,1202.5885,-565.91144,29.190498,NULL,0,0,0,100,0),
+(@PATH,7,1203.3524,-578.3889,29.649534,NULL,0,0,0,100,0),
+(@PATH,8,1204.2483,-593.43054,29.680296,NULL,0,0,0,100,0),
+(@PATH,9,1202.2084,-607.5347,29.933348,NULL,0,0,0,100,0),
+(@PATH,10,1200.7865,-618.3316,29.090208,NULL,0,0,0,100,0),
+(@PATH,11,1199.1841,-631.65625,28.949871,NULL,0,0,0,100,0),
+(@PATH,12,1184.4879,-639.1476,28.993471,NULL,0,0,0,100,0),
+(@PATH,13,1163.5139,-643.48615,29.032167,NULL,0,0,0,100,0),
+(@PATH,14,1153.4584,-630.5382,29.030197,NULL,0,0,0,100,0),
+(@PATH,15,1149.4653,-625.11633,29.030197,NULL,4000,0,0,100,0),
+(@PATH,16,1153.4584,-630.5382,29.030197,NULL,0,0,0,100,0),
+(@PATH,17,1163.5139,-643.48615,29.032167,NULL,0,0,0,100,0),
+(@PATH,18,1184.4879,-639.1476,28.993471,NULL,0,0,0,100,0),
+(@PATH,19,1199.1841,-631.65625,28.949871,NULL,0,0,0,100,0),
+(@PATH,20,1200.7865,-618.3316,29.090208,NULL,0,0,0,100,0),
+(@PATH,21,1202.2084,-607.5347,29.933348,NULL,0,0,0,100,0),
+(@PATH,22,1204.2483,-593.43054,29.680296,NULL,0,0,0,100,0),
+(@PATH,23,1203.3524,-578.3889,29.649534,NULL,0,0,0,100,0),
+(@PATH,24,1202.5885,-565.91144,29.190498,NULL,0,0,0,100,0),
+(@PATH,25,1198.1302,-554.40625,29.014044,NULL,0,0,0,100,0),
+(@PATH,26,1193.2153,-543.15625,28.517218,NULL,0,0,0,100,0),
+(@PATH,27,1189.8108,-537.0052,28.392218,NULL,0,0,0,100,0),
+(@PATH,28,1180.4688,-536.34894,28.642218,NULL,0,0,0,100,0),
+(@PATH,29,1174.3837,-537.92883,28.892218,NULL,0,0,0,100,0),
+(@PATH,30,1163.6649,-542.0018,29.019638,NULL,4000,0,0,100,0);
+
+-- Pathing for Harbor Guard Entry: 136633
+SET @NPC := @CGUID+48;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `wander_distance`=0,`MovementType`=2,`position_x`=1075.7665,`position_y`=-410.47943,`position_z`=20.753847 WHERE `guid`=@NPC;
+UPDATE `creature_addon` SET `path_id`=@PATH WHERE `guid`=@NPC;
+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,1075.7665,-410.47943,20.753847,NULL,0,0,0,100,0),
+(@PATH,2,1108.625,-419.21008,20.894451,NULL,0,0,0,100,0);
+
+-- Pathing for Harbor Guard Entry: 136633
+SET @NPC := @CGUID+50;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `wander_distance`=0,`MovementType`=2,`position_x`=1066.4219,`position_y`=-432.30557,`position_z`=20.309467 WHERE `guid`=@NPC;
+UPDATE `creature_addon` SET `path_id`=@PATH WHERE `guid`=@NPC;
+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,1066.4219,-432.30557,20.309467,NULL,0,0,0,100,0),
+(@PATH,2,1070.9028,-414.00348,20.311993,NULL,0,0,0,100,0);
+
+-- Missing POI for Harbor Guard gossip
+DELETE FROM `points_of_interest` WHERE `ID` IN (5781,5785,5811,5761,5820,5762,5763,5787,5764,5765,5808,5990,5791,5827,5766,5786,5767,5768,5769,5770,5771,5772,5773,5774,5775,5776,5777,5778,5779,5780,5759,5782,5783,5784);
+INSERT INTO `points_of_interest` (`ID`,`PositionX`,`PositionY`,`PositionZ`,`Icon`,`Flags`,`Importance`,`Name`,`Unknown905`,`VerifiedBuild`) VALUES
+(5781,1102.95,-621.983,17.539,7,99,0,'Boralus Bank',57416,45745),
+(5785,995.472,-423.542,13.0858,7,99,0,'Boralus Barber',57242,45745),
+(5811,-607.333,3128.97,323.964,7,99,0,'Order of Embers Emissary',0,45745),
+(5761,1075.6,-477.736,9.70013,7,99,0,'Proudmoore Admiralty Emissary',57708,45745),
+(5820,2539.57,-21.9497,54.416,7,99,0,'Storm''s Wake Emissary',0,45745),
+(5762,3785.04,1042.2,8.87555,7,99,0,'Tortollan Seekers Emissary',0,45745),
+(5763,1153.86,-467.995,31.292,7,99,0,'Tradewinds Market Flight Master',57427,45745),
+(5787,1147.85,-517.068,28.9041,7,99,0,'Boralus Guild Master & Vendor',59020,45745),
+(5764,1181.9,-596.163,31.6579,7,99,0,'Boralus Inn',59019,45745),
+(5765,1035.35,-595.653,1.4034,7,99,0,'Boralus Ferry Master',55946,45745),
+(5808,1028,-651.729,6.51333,7,99,0,'Boralus Ship to Stormwind',0,45745),
+(5990,1013.92,-485.451,21.8422,7,99,0,'Alliance Ship to Zandalar',0,45745),
+(5791,1042.79,-410.582,4.84288,7,99,0,'Boralus Training Dummies',0,45745),
+(5827,1118.04,-527.735,17.5536,7,99,0,'Boralus Portals',54774,45745),
+(5766,1139.99,-645.859,29.3481,7,99,0,'Boralus Scrapper',0,45745),
+(5786,1176.09,-515.113,28.9326,7,99,0,'Boralus Stable Master',0,45745),
+(5767,1254.16,-598.438,30.3638,7,99,0,'Boralus Alchemy Trainer',53985,45745),
+(5768,1231.98,-492.358,32.7131,7,99,0,'Boralus Archaeology Trainer',56825,45745),
+(5769,1231.58,-583.481,25.4333,7,99,0,'Boralus Blacksmithing Trainer',0,45745),
+(5770,1205.71,-543.972,29.9404,7,99,0,'Boralus Cooking Trainer',58757,45745),
+(5771,1195.19,-594.561,29.7135,7,99,0,'Boralus Enchanting Trainer',0,45745),
+(5772,1161.93,-659.085,29.0116,7,99,0,'Boralus Engineering Trainer',57070,45745),
+(5773,1265.64,-596.531,40.2596,7,99,0,'Boralus Fishing Trainer',55949,45745),
+(5774,1265.93,-545.67,33.3579,7,99,0,'Boralus Herbalism Trainer',0,45745),
+(5775,1257.64,-583.148,31.0732,7,99,0,'Boralus Inscription Trainer',53985,45745),
+(5776,1215.18,-615.585,29.7355,7,99,0,'Boralus Jewelcrafting Trainer',0,45745),
+(5777,1182.65,-620.378,29.4332,7,99,0,'Boralus Leatherworking Trainer',55945,45745),
+(5778,1242.96,-616.021,30.1357,7,99,0,'Boralus Mining Trainer',0,45745),
+(5779,1173.19,-623.764,29.241,7,99,0,'Boralus Skinning Trainer',55944,45745),
+(5780,1199.85,-646.623,29.1744,7,99,0,'Boralus Tailoring Trainer',57071,45745),
+(5759,1163.55,-557.992,28.9018,7,99,0,'Boralus Transmogrifier',59020,45745),
+(5782,1121.73,-569.995,17.1779,7,99,0,'Boralus General Goods Vendor',59020,45745),
+(5783,1139.8,-596.28,20.5492,7,99,0,'Boralus Repair Vendor',59020,45745),
+(5784,1196.2,-578.976,29.6297,7,99,0,'Boralus Trade Goods Vendor',55946,45745);
+
+-- Missing gossip_menu_option for Harbor Guard gossip
+DELETE FROM `gossip_menu_option` WHERE `MenuID` IN (23083,23088);
+INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionNpc`, `OptionText`, `OptionBroadcastTextId`, `Language`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES
+(23083, 0, 0, 'Order of Embers Emissary', 160750, 0, 23175, 5811, 0, 0, NULL, 0, 45745),
+(23083, 1, 0, 'Proudmoore Admiralty Emissary', 160197, 0, 23084, 5761, 0, 0, NULL, 0, 45745),
+(23083, 2, 0, 'Storm\'s Wake Emissary', 160769, 0, 23178, 5820, 0, 0, NULL, 0, 45745),
+(23083, 3, 0, 'Tortollan Seekers Emissary', 159630, 0, 23085, 5762, 0, 0, NULL, 0, 45745),
+(23088, 0, 0, 'Ferry Master', 160218, 0, 23089, 5765, 0, 0, NULL, 0, 45745),
+(23088, 1, 0, 'Ship to Stormwind', 160714, 0, 23170, 5808, 0, 0, NULL, 0, 45745),
+(23088, 2, 0, 'Ship to Zandalar', 167082, 0, 23699, 5990, 0, 0, NULL, 0, 45745),
+(23088, 3, 0, 'Training Dummies', 159714, 0, 23146, 5791, 0, 0, NULL, 0, 45745);
+
+-- Update gossip_menu_option for Harbor Guard gossip
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23082, `ActionPoiID`=5781 WHERE `MenuID`=23077 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23123, `ActionPoiID`=5785 WHERE `MenuID`=23077 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23083, `ActionPoiID`=0 WHERE `MenuID`=23077 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23175, `ActionPoiID`=5811 WHERE `MenuID`=23083 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23084, `ActionPoiID`=5761 WHERE `MenuID`=23083 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23178, `ActionPoiID`=5820 WHERE `MenuID`=23083 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23085, `ActionPoiID`=5762 WHERE `MenuID`=23083 AND `OptionID`=3;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23086, `ActionPoiID`=5763 WHERE `MenuID`=23077 AND `OptionID`=3;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23126, `ActionPoiID`=5787 WHERE `MenuID`=23077 AND `OptionID`=4;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23087, `ActionPoiID`=5764 WHERE `MenuID`=23077 AND `OptionID`=5;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23088, `ActionPoiID`=0 WHERE `MenuID`=23077 AND `OptionID`=6;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23089, `ActionPoiID`=5765 WHERE `MenuID`=23088 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23170, `ActionPoiID`=5808 WHERE `MenuID`=23088 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23699, `ActionPoiID`=5990 WHERE `MenuID`=23088 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23146, `ActionPoiID`=5791 WHERE `MenuID`=23088 AND `OptionID`=3;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23245, `ActionPoiID`=5827 WHERE `MenuID`=23077 AND `OptionID`=7;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23090, `ActionPoiID`=5766 WHERE `MenuID`=23077 AND `OptionID`=8;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23125, `ActionPoiID`=5786 WHERE `MenuID`=23077 AND `OptionID`=9;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23092, `ActionPoiID`=0 WHERE `MenuID`=23077 AND `OptionID`=10;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23093, `ActionPoiID`=5767 WHERE `MenuID`=23092 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23095, `ActionPoiID`=5768 WHERE `MenuID`=23092 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23097, `ActionPoiID`=5769 WHERE `MenuID`=23092 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23098, `ActionPoiID`=5770 WHERE `MenuID`=23092 AND `OptionID`=3;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23102, `ActionPoiID`=5771 WHERE `MenuID`=23092 AND `OptionID`=4;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23103, `ActionPoiID`=5772 WHERE `MenuID`=23092 AND `OptionID`=5;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23104, `ActionPoiID`=5773 WHERE `MenuID`=23092 AND `OptionID`=6;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23105, `ActionPoiID`=5774 WHERE `MenuID`=23092 AND `OptionID`=7;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23106, `ActionPoiID`=5775 WHERE `MenuID`=23092 AND `OptionID`=8;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23107, `ActionPoiID`=5776 WHERE `MenuID`=23092 AND `OptionID`=9;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23108, `ActionPoiID`=5777 WHERE `MenuID`=23092 AND `OptionID`=10;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23109, `ActionPoiID`=5778 WHERE `MenuID`=23092 AND `OptionID`=11;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23113, `ActionPoiID`=5779 WHERE `MenuID`=23092 AND `OptionID`=12;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23116, `ActionPoiID`=5780 WHERE `MenuID`=23092 AND `OptionID`=13;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23117, `ActionPoiID`=5759 WHERE `MenuID`=23077 AND `OptionID`=11;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23118, `ActionPoiID`=0 WHERE `MenuID`=23077 AND `OptionID`=12;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23119, `ActionPoiID`=5782 WHERE `MenuID`=23118 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23121, `ActionPoiID`=5783 WHERE `MenuID`=23118 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=23122, `ActionPoiID`=5784 WHERE `MenuID`=23118 AND `OptionID`=2;
+
+-- Missing gossip_menu for Harbor Guard gossip
+DELETE FROM `gossip_menu` WHERE `MenuID` IN (23123,23083,23175,23084,23178,23085,23086,23126,23125,23089,23170,23699,23093,23245,23095,23098,23102,23103,23106,23108,23113,23116,23119,23121,23122);
+INSERT INTO `gossip_menu` (`MenuID`,`TextID`,`VerifiedBuild`) VALUES
+(23116,@TEXTID,45745),
+(23119,@TEXTID+1,45745),
+(23121,@TEXTID+2,45745),
+(23122,@TEXTID+3,45745),
+(23123,@TEXTID+4,45745),
+(23125,@TEXTID+5,45745),
+(23126,@TEXTID+6,45745),
+(23083,@TEXTID+7,45745),
+(23084,@TEXTID+8,45745),
+(23085,@TEXTID+9,45745),
+(23086,@TEXTID+10,45745),
+(23089,@TEXTID+11,45745),
+(23093,@TEXTID+12,45745),
+(23095,@TEXTID+13,45745),
+(23699,@TEXTID+14,45745),
+(23098,@TEXTID+15,45745),
+(23102,@TEXTID+16,45745),
+(23170,@TEXTID+17,45745),
+(23103,@TEXTID+18,45745),
+(23106,@TEXTID+19,45745),
+(23108,@TEXTID+20,45745),
+(23175,@TEXTID+21,45745),
+(23245,@TEXTID+22,45745),
+(23178,@TEXTID+23,45745),
+(23113,@TEXTID+24,45745);
+
+-- Missing npc_text for Harbor Guard gossip
+DELETE FROM `npc_text` WHERE `ID` BETWEEN @TEXTID AND @TEXTID + 24;
+INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES
+(@TEXTID, 1, 0, 0, 0, 0, 0, 0, 0, 160323, 0, 0, 0, 0, 0, 0, 0, 45745),
+(@TEXTID+1, 1, 0, 0, 0, 0, 0, 0, 0, 160329, 0, 0, 0, 0, 0, 0, 0, 45745),
+(@TEXTID+2, 1, 0, 0, 0, 0, 0, 0, 0, 160333, 0, 0, 0, 0, 0, 0, 0, 45745),
+(@TEXTID+3, 1, 0, 0, 0, 0, 0, 0, 0, 160335, 0, 0, 0, 0, 0, 0, 0, 45745),
+(@TEXTID+4, 1, 0, 0, 0, 0, 0, 0, 0, 160338, 0, 0, 0, 0, 0, 0, 0, 45745),
+(@TEXTID+5, 1, 0, 0, 0, 0, 0, 0, 0, 160339, 0, 0, 0, 0, 0, 0, 0, 45745),
+(@TEXTID+6, 1, 0, 0, 0, 0, 0, 0, 0, 160340, 0, 0, 0, 0, 0, 0, 0, 45745),
+(@TEXTID+7, 1, 0, 0, 0, 0, 0, 0, 0, 160196, 0, 0, 0, 0, 0, 0, 0, 45745),
+(@TEXTID+8, 1, 0, 0, 0, 0, 0, 0, 0, 160198, 0, 0, 0, 0, 0, 0, 0, 45745),
+(@TEXTID+9, 1, 0, 0, 0, 0, 0, 0, 0, 160202, 0, 0, 0, 0, 0, 0, 0, 45745),
+(@TEXTID+10, 1, 0, 0, 0, 0, 0, 0, 0, 160212, 0, 0, 0, 0, 0, 0, 0, 45745),
+(@TEXTID+11, 1, 0, 0, 0, 0, 0, 0, 0, 160219, 0, 0, 0, 0, 0, 0, 0, 45745),
+(@TEXTID+12, 1, 0, 0, 0, 0, 0, 0, 0, 160260, 0, 0, 0, 0, 0, 0, 0, 45745),
+(@TEXTID+13, 1, 0, 0, 0, 0, 0, 0, 0, 160262, 0, 0, 0, 0, 0, 0, 0, 45745),
+(@TEXTID+14, 1, 0, 0, 0, 0, 0, 0, 0, 167081, 0, 0, 0, 0, 0, 0, 0, 45745),
+(@TEXTID+15, 1, 0, 0, 0, 0, 0, 0, 0, 160268, 0, 0, 0, 0, 0, 0, 0, 45745),
+(@TEXTID+16, 1, 0, 0, 0, 0, 0, 0, 0, 160279, 0, 0, 0, 0, 0, 0, 0, 45745),
+(@TEXTID+17, 1, 0, 0, 0, 0, 0, 0, 0, 160715, 0, 0, 0, 0, 0, 0, 0, 45745),
+(@TEXTID+18, 1, 0, 0, 0, 0, 0, 0, 0, 160299, 0, 0, 0, 0, 0, 0, 0, 45745),
+(@TEXTID+19, 1, 0, 0, 0, 0, 0, 0, 0, 160306, 0, 0, 0, 0, 0, 0, 0, 45745),
+(@TEXTID+20, 1, 0, 0, 0, 0, 0, 0, 0, 160309, 0, 0, 0, 0, 0, 0, 0, 45745),
+(@TEXTID+21, 1, 0, 0, 0, 0, 0, 0, 0, 160754, 0, 0, 0, 0, 0, 0, 0, 45745),
+(@TEXTID+22, 1, 0, 0, 0, 0, 0, 0, 0, 161188, 0, 0, 0, 0, 0, 0, 0, 45745),
+(@TEXTID+23, 1, 0, 0, 0, 0, 0, 0, 0, 160770, 0, 0, 0, 0, 0, 0, 0, 45745),
+(@TEXTID+24, 1, 0, 0, 0, 0, 0, 0, 0, 160322, 0, 0, 0, 0, 0, 0, 0, 45745);
+
+-- Harbor Guard Entry: 136633 SAI
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=136633;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (-@CGUID-30,-@CGUID-62,-@CGUID-74) 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(-@CGUID-30,0,0,0,1,0,100,0,5000,15000,5000,15000,0,10,1,6,273,274,0,0,1,0,0,0,0,0,0,0,0,'Harbor Guard - OOC - Do random emote'),
+(-@CGUID-62,0,0,0,1,0,100,0,5000,15000,5000,15000,0,10,1,6,273,274,0,0,1,0,0,0,0,0,0,0,0,'Harbor Guard - OOC - Do random emote'),
+(-@CGUID-74,0,0,0,1,0,100,0,5000,15000,5000,15000,0,10,1,6,273,274,0,0,1,0,0,0,0,0,0,0,0,'Harbor Guard - OOC - Do random emote');
+