diff options
| -rw-r--r-- | sql/updates/world/master/2022_10_10_01_world.sql | 445 |
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'); + |