diff options
| -rw-r--r-- | sql/updates/world/master/2025_01_02_21_world.sql | 1616 |
1 files changed, 1616 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_01_02_21_world.sql b/sql/updates/world/master/2025_01_02_21_world.sql new file mode 100644 index 00000000000..6f39ccc8ed3 --- /dev/null +++ b/sql/updates/world/master/2025_01_02_21_world.sql @@ -0,0 +1,1616 @@ +SET @CGUID := 10005013; +SET @OGUID := 10001328; + +-- Creature +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+225; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES +(@CGUID+0, 227660, 2127, 10416, 15535, '0', 0, 0, 0, 0, 2027.23095703125, 92.111114501953125, 0.083333335816860198, 3.438897609710693359, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Sandsifting Hardshell (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+1, 234853, 2127, 10416, 15535, '0', 0, 0, 0, 0, 2073.569580078125, 35.75, 0.530348062515258789, 0, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Invasive Rat (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 179665 - Disable ALL Mounts) (possible waypoints or random movement) +(@CGUID+2, 230398, 2127, 10416, 15535, '0', 0, 0, 0, 0, 1943.798583984375, 90.01909637451171875, -0.14476442337036132, 5.244240760803222656, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Tidal Kroling (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+3, 234851, 2127, 10416, 15535, '0', 0, 0, 0, 0, 2023.626708984375, 32.20138931274414062, -0.08702368289232254, 0.736637532711029052, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Island Crab (Area: -Unknown- - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+4, 230398, 2127, 10416, 15535, '0', 0, 0, 0, 0, 2022.140625, 96.5, -0.14314198493957519, 4.208696365356445312, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Tidal Kroling (Area: -Unknown- - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+5, 234851, 2127, 10416, 15535, '0', 0, 0, 0, 0, 2050.34716796875, 57.8836822509765625, 1.133304476737976074, 0.90985041856765747, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Island Crab (Area: -Unknown- - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+6, 227664, 2127, 10416, 15535, '0', 0, 0, 0, 0, 1927.4444580078125, 51.6805572509765625, 0.083333335816860198, 0.918576300144195556, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Tidal Sandskitter (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+7, 228156, 2127, 10416, 15535, '0', 0, 0, 0, 0, 1970.3663330078125, 40.25520706176757812, 0.098791442811489105, 4.344352245330810546, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Driftwave Sealion (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 123169 - Mod Scale 105-110%) +(@CGUID+8, 227664, 2127, 10416, 15535, '0', 0, 0, 0, 0, 2038.05908203125, 74.77951812744140625, 0.218385428190231323, 0.84721386432647705, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Tidal Sandskitter (Area: -Unknown- - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+9, 234851, 2127, 10416, 15535, '0', 0, 0, 0, 0, 1922.4635009765625, 76.66146087646484375, -0.21766072511672973, 0.14524368941783905, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Island Crab (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+10, 227664, 2127, 10416, 15535, '0', 0, 0, 0, 0, 1981.810791015625, 71.27083587646484375, 0.593426883220672607, 0, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Tidal Sandskitter (Area: -Unknown- - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+11, 227668, 2127, 10416, 15535, '0', 0, 0, 0, 0, 1929.201416015625, 47.85416793823242187, 24.16259574890136718, 1.374450445175170898, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Seafeather Albatross (Area: -Unknown- - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+12, 227668, 2127, 10416, 15535, '0', 0, 0, 0, 0, 2072.6806640625, 97.2569427490234375, 21.39101409912109375, 1.374440193176269531, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Seafeather Albatross (Area: -Unknown- - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+13, 228156, 2127, 10416, 15535, '0', 0, 0, 0, 0, 1950.1597900390625, 5.779513835906982421, -16.7186012268066406, 5.300185680389404296, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Driftwave Sealion (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 123169 - Mod Scale 105-110%) +(@CGUID+14, 228156, 2127, 10416, 15535, '0', 0, 0, 0, 0, 1984.3629150390625, 39.72569656372070312, 0.500359833240509033, 0.336792945861816406, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Driftwave Sealion (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 123169 - Mod Scale 105-110%) +(@CGUID+15, 234851, 2127, 10416, 15535, '0', 0, 0, 0, 0, 1986.7100830078125, 52.23263931274414062, -0.18822914361953735, 0.761784076690673828, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Island Crab (Area: -Unknown- - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+16, 234854, 2127, 10416, 15535, '0', 0, 0, 0, 0, 2051.37841796875, -43.7951393127441406, 36.68460845947265625, 3.308553218841552734, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Gull (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+17, 234854, 2127, 10416, 15535, '0', 0, 0, 0, 0, 2023.77783203125, -56.6319465637207031, 31.53132820129394531, 1.865431904792785644, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Gull (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+18, 234854, 2127, 10416, 15535, '0', 0, 0, 0, 0, 2005.2239990234375, -29.5086803436279296, 34.24971771240234375, 0.570143878459930419, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Gull (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+19, 234854, 2127, 10416, 15535, '0', 0, 0, 0, 0, 2002.578125, -33.6857643127441406, 35.39815521240234375, 0.731823861598968505, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Gull (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+20, 234854, 2127, 10416, 15535, '0', 0, 0, 0, 0, 2063.951416015625, -62.5017356872558593, 42.7236785888671875, 1.475477576255798339, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Gull (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+21, 234854, 2127, 10416, 15535, '0', 0, 0, 0, 0, 2011.907958984375, -33.9548606872558593, 34.67316436767578125, 1.112473249435424804, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Gull (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+22, 234854, 2127, 10416, 15535, '0', 0, 0, 0, 0, 2007.0711669921875, -32.9444465637207031, 34.7632904052734375, 0.790683984756469726, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Gull (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+23, 234854, 2127, 10416, 15535, '0', 0, 0, 0, 0, 2063.232666015625, -72.2916641235351562, 44.9658660888671875, 3.366559982299804687, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Gull (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+24, 234854, 2127, 10416, 15539, '0', 0, 0, 0, 0, 2086.835205078125, 139.0277862548828125, 25.20261764526367187, 2.288547277450561523, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Gull (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+25, 234854, 2127, 10416, 15539, '0', 0, 0, 0, 0, 2055.017333984375, 124.2170181274414062, 21.98205184936523437, 3.469411849975585937, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Gull (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+26, 234854, 2127, 10416, 15539, '0', 0, 0, 0, 0, 2111.326416015625, 94.12152862548828125, 7.907581806182861328, 4.293814659118652343, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Gull (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+27, 229527, 2127, 10416, 15539, '0', 0, 0, 0, 0, 2117.6962890625, 213.2465362548828125, 73.204864501953125, 4.359185695648193359, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Sirentusk (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+28, 234959, 2127, 10416, 15539, '0', 0, 0, 0, 0, 2114.859375, 212.6979217529296875, 72.01806640625, 0, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Sirentusk Piglet (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+29, 229625, 2127, 10416, 15539, '0', 0, 0, 0, 0, 2045.373291015625, 159.3715362548828125, 49.19057083129882812, 5.939780235290527343, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Skittersong Krolusk (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 368927 - Cosmetic - Sleep Zzz (With Aggro Change) - Breath) +(@CGUID+30, 234865, 2127, 10416, 15539, '0', 0, 0, 0, 0, 2056.4619140625, 218.67535400390625, 53.74904632568359375, 6.128665447235107421, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Island Cockroach (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+31, 229534, 2127, 10416, 15539, '0', 0, 0, 0, 0, 2037.0972900390625, 209.6215362548828125, 42.16444015502929687, 3.222462177276611328, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Stormfeather Falcon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+32, 234865, 2127, 10416, 15539, '0', 0, 0, 0, 0, 2132.88720703125, 234.329864501953125, 86.10894775390625, 5.167903900146484375, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Island Cockroach (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+33, 229527, 2127, 10416, 15539, '0', 0, 0, 0, 0, 2057.796875, 253.2100677490234375, 55.56175613403320312, 3.231825590133666992, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Sirentusk (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+34, 234865, 2127, 10416, 15944, '0', 0, 0, 0, 0, 2177.4619140625, 174.095489501953125, 63.71451187133789062, 2.144599437713623046, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Island Cockroach (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+35, 229527, 2127, 10416, 15944, '0', 0, 0, 0, 0, 2113.373291015625, 276.411468505859375, 82.7557373046875, 3.733592987060546875, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Sirentusk (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+36, 234099, 2127, 10416, 15944, '0', 0, 0, 0, 0, 2088.90283203125, 289.760406494140625, 71.93972015380859375, 5.393119335174560546, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Rusty Kroling (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+37, 229534, 2127, 10416, 15944, '0', 0, 0, 0, 0, 2141.064208984375, 225.9756927490234375, 105.8573837280273437, 3.222462177276611328, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Stormfeather Falcon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+38, 229522, 2127, 10416, 15944, '0', 0, 0, 0, 0, 2243.42529296875, 279.414947509765625, 204.9890899658203125, 2.612544059753417968, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 466036 - -Unknown-) +(@CGUID+39, 234711, 2127, 10416, 15944, '0', 0, 0, 0, 0, 2256.03466796875, 271.838531494140625, 201.6432037353515625, 4.979306221008300781, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Cub (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+40, 229522, 2127, 10416, 15944, '0', 0, 0, 0, 0, 2291.23095703125, 272.8975830078125, 197.3053741455078125, 0.90164196491241455, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 466036 - -Unknown-) +(@CGUID+41, 229534, 2127, 10416, 15944, '0', 0, 0, 0, 0, 2181.513916015625, 221.8802032470703125, 130.8322296142578125, 1.083864688873291015, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Stormfeather Falcon (Area: -Unknown- - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+42, 229534, 2127, 10416, 15944, '0', 0, 0, 0, 0, 2204.46875, 209.142364501953125, 114.3970489501953125, 6.10028696060180664, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Stormfeather Falcon (Area: -Unknown- - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+43, 229534, 2127, 10416, 15944, '0', 0, 0, 0, 0, 2174.810791015625, 305.732635498046875, 141.53009033203125, 2.280828714370727539, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Stormfeather Falcon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+44, 234711, 2127, 10416, 15944, '0', 0, 0, 0, 0, 2304.34716796875, 266.54339599609375, 195.1990814208984375, 5.355052947998046875, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Cub (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+45, 234711, 2127, 10416, 15944, '0', 0, 0, 0, 0, 2324.24658203125, 253.1371612548828125, 197.499053955078125, 5.291934967041015625, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Cub (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+46, 229522, 2127, 10416, 15944, '0', 0, 0, 0, 0, 2307.2744140625, 252.9583282470703125, 196.683868408203125, 4.005887508392333984, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 466036 - -Unknown-) +(@CGUID+47, 233254, 2127, 10416, 15944, '0', 0, 0, 0, 0, 2221.182373046875, 247.28125, 205.610015869140625, 1.121444582939147949, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+48, 229522, 2127, 10416, 15944, '0', 0, 0, 0, 0, 2316.94091796875, 252.2899322509765625, 205.610015869140625, 1.121444225311279296, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+49, 229522, 2127, 10416, 15944, '0', 0, 0, 0, 0, 2254.657958984375, 296.1875, 219.7012176513671875, 6.089354991912841796, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+50, 229522, 2127, 10416, 15944, '0', 0, 0, 0, 0, 2332.548583984375, 252.171875, 198.287078857421875, 0.689892947673797607, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 466036 - -Unknown-) +(@CGUID+51, 233254, 2127, 10416, 15944, '0', 0, 0, 0, 0, 2143.447998046875, 334.998260498046875, 174.290313720703125, 1.317789554595947265, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+52, 229534, 2127, 10416, 15944, '0', 0, 0, 0, 0, 2309.272705078125, 212.392364501953125, 186.4283447265625, 1.083864688873291015, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Stormfeather Falcon (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+53, 229522, 2127, 10416, 15944, '0', 0, 0, 0, 0, 2326.545166015625, 332.265625, 163.6073760986328125, 2.466090917587280273, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 466036 - -Unknown-) +(@CGUID+54, 229522, 2127, 10416, 15944, '0', 0, 0, 0, 0, 2316.94091796875, 302.795135498046875, 198.7538299560546875, 2.408536195755004882, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+55, 229522, 2127, 10416, 15944, '0', 0, 0, 0, 0, 2315.85595703125, 349.05035400390625, 186.3469085693359375, 1.121446847915649414, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+56, 229522, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2176.98095703125, 361.99652099609375, 116.0739288330078125, 1.521881461143493652, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+57, 229534, 2127, 10416, 15537, '0', 0, 0, 0, 0, 1924.1944580078125, 137.876739501953125, 55.79175949096679687, 6.10028696060180664, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Stormfeather Falcon (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+58, 229534, 2127, 10416, 15537, '0', 0, 0, 0, 0, 1956.796875, 147.84375, 50.43305206298828125, 1.083878755569458007, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Stormfeather Falcon (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+59, 229527, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1952.123291015625, 239.1371612548828125, 11.01924896240234375, 0.99367755651473999, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Sirentusk (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+60, 229527, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1990.4635009765625, 198.939239501953125, 11.66646575927734375, 5.411586761474609375, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Sirentusk (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+61, 234959, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1987.626708984375, 198.390625, 11.8001251220703125, 0, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Sirentusk Piglet (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+62, 229625, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1968.6875, 272.916656494140625, 8.610489845275878906, 0.770676672458648681, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Skittersong Krolusk (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+63, 234865, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1983.1285400390625, 161.0555572509765625, 14.08278560638427734, 1.988789916038513183, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Island Cockroach (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+64, 234865, 2127, 10416, 15539, '0', 0, 0, 0, 0, 2030.048583984375, 194.03125, 16.31655120849609375, 6.249970436096191406, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Island Cockroach (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+65, 234865, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1993.7916259765625, 223.703125, 11.59474754333496093, 0, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Island Cockroach (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+66, 234099, 2127, 10416, 15539, '0', 0, 0, 0, 0, 2017.9254150390625, 298.828125, 40.04198074340820312, 3.717081069946289062, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Rusty Kroling (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+67, 229534, 2127, 10416, 15539, '0', 0, 0, 0, 0, 2034.923583984375, 283.453125, 45.4671203173828125, 4.543957710266113281, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Stormfeather Falcon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+68, 229534, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1847.326416015625, 285.536468505859375, 45.05569839477539062, 1.280220508575439453, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Stormfeather Falcon (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+69, 229534, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1921.328125, 336.49652099609375, 51.33281707763671875, 5.56693124771118164, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Stormfeather Falcon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+70, 229534, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1910.0677490234375, 360.65625, 61.7496337890625, 5.010857582092285156, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Stormfeather Falcon (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+71, 230398, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1854.060791015625, 320.69097900390625, 0.168390899896621704, 0.795986294746398925, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Tidal Kroling (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+72, 229527, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1909.93408203125, 396.671875, 18.96063613891601562, 3.004358291625976562, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Sirentusk (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+73, 229527, 2127, 10416, 15539, '0', 0, 0, 0, 0, 2008.8038330078125, 376.592010498046875, 32.73346710205078125, 4.254858970642089843, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Sirentusk (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+74, 234959, 2127, 10416, 15539, '0', 0, 0, 0, 0, 2005.967041015625, 376.04339599609375, 32.70138931274414062, 5.781704902648925781, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Sirentusk Piglet (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+75, 229527, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1871.046875, 395.3507080078125, 20.45760726928710937, 2.638800621032714843, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Sirentusk (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+76, 234099, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1985.0989990234375, 378.048614501953125, 31.09188652038574218, 5.527447223663330078, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Rusty Kroling (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+77, 234099, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1900.734375, 420.572906494140625, 23.17969894409179687, 2.57462930679321289, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Rusty Kroling (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+78, 234865, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1932.796875, 334.510406494140625, 19.43044471740722656, 3.80194711685180664, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Island Cockroach (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+79, 234959, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1977.638916015625, 451.024322509765625, 77.720489501953125, 6.226195335388183593, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Sirentusk Piglet (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+80, 229527, 2127, 10416, 15539, '0', 0, 0, 0, 0, 2058.507080078125, 490.126739501953125, 78.48291778564453125, 4.979095458984375, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Sirentusk (Area: -Unknown- - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+81, 229527, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1953.9478759765625, 457.41839599609375, 81.8173828125, 5.338360309600830078, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Sirentusk (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+82, 234099, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1917.7274169921875, 549.2413330078125, 65.21747589111328125, 0.283523112535476684, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Rusty Kroling (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+83, 229527, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1980.4757080078125, 451.572906494140625, 77.95660400390625, 5.981166839599609375, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Sirentusk (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+84, 234099, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1986.748291015625, 431.432281494140625, 69.9344024658203125, 2.634169578552246093, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Rusty Kroling (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+85, 234853, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1968.9600830078125, 481.685760498046875, 88.32049560546875, 4.594828605651855468, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Invasive Rat (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+86, 229527, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1926.2291259765625, 531.59722900390625, 72.869293212890625, 1.683080196380615234, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Sirentusk (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+87, 234865, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1995.123291015625, 512.67706298828125, 87.4129180908203125, 2.343951702117919921, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Island Cockroach (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+88, 229534, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1941.0347900390625, 487.508697509765625, 111.7027587890625, 1.198615312576293945, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Stormfeather Falcon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+89, 229534, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1965.4478759765625, 477.58160400390625, 106.5946426391601562, 4.004210948944091796, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Stormfeather Falcon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+90, 234853, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1981.4444580078125, 502.30902099609375, 88.31912994384765625, 2.0209503173828125, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Invasive Rat (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+91, 234097, 2127, 10416, 15539, '0', 0, 0, 0, 0, 2067.494873046875, 492.34027099609375, 78.85050201416015625, 0, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Rusty Kroling (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+92, 229534, 2127, 10416, 0, '0', 0, 0, 0, 0, 1941.1007080078125, 554.67535400390625, 89.48978424072265625, 3.767864227294921875, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Stormfeather Falcon (Area: 0 - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+93, 229527, 2127, 10416, 0, '0', 0, 0, 0, 0, 1921.9722900390625, 600.5242919921875, 69.645050048828125, 0.996105492115020751, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Sirentusk (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+94, 229534, 2127, 10416, 0, '0', 0, 0, 0, 0, 2015.2882080078125, 520.467041015625, 122.9087066650390625, 5.010858535766601562, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Stormfeather Falcon (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+95, 229534, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1963.4444580078125, 538.87677001953125, 137.46405029296875, 1.083879709243774414, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Stormfeather Falcon (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+96, 229527, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1920.2603759765625, 475.151031494140625, 81.1893310546875, 1.738385796546936035, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Sirentusk (Area: -Unknown- - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+97, 229522, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1900.7083740234375, 453.21527099609375, 89.27056884765625, 1.525108218193054199, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 466036 - -Unknown-) +(@CGUID+98, 229522, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1879.38720703125, 491.626739501953125, 64.03379058837890625, 0.752108633518218994, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+99, 230398, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1799.77783203125, 517.48614501953125, 0.419917881488800048, 3.724616050720214843, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Tidal Kroling (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+100, 234711, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1886.486083984375, 463.461822509765625, 67.70041656494140625, 0.606532216072082519, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Cub (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+101, 231589, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1899.826416015625, 452.961822509765625, 90.641326904296875, 0.476450264453887939, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cowardly Cliffreach Cub (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 1213137 - -Unknown-) +(@CGUID+102, 231589, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1899.78125, 450.430572509765625, 90.75608062744140625, 0.715500831604003906, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cowardly Cliffreach Cub (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 1213137 - -Unknown-) +(@CGUID+103, 234711, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1878.564208984375, 443.848968505859375, 61.80588150024414062, 2.266613721847534179, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Cub (Area: -Unknown- - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+104, 233254, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1859.13720703125, 448.765625, 154.96612548828125, 1.317789554595947265, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+105, 229522, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1845.0225830078125, 394.203125, 77.74973297119140625, 1.121442079544067382, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: ) (possible waypoints or random movement) +(@CGUID+106, 229522, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1861.8316650390625, 402.088531494140625, 75.5367279052734375, 1.554098248481750488, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 466036 - -Unknown-) +(@CGUID+107, 233254, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1920.814208984375, 478.44964599609375, 122.0972137451171875, 1.317789554595947265, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+108, 234710, 2127, 10416, 15539, '0', 0, 0, 0, 0, 1834.6024169921875, 451.067718505859375, 58.63663482666015625, 0, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Cub (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 69641 - Gryphon/Wyvern Pet - Mounting Check Aura) (possible waypoints or random movement) +(@CGUID+109, 228156, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1768.970458984375, 402.458343505859375, 0.46875, 3.946761608123779296, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Driftwave Sealion (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 123169 - Mod Scale 105-110%) (possible waypoints or random movement) +(@CGUID+110, 233254, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1782.7916259765625, 530.6336669921875, 106.524078369140625, 1.317789554595947265, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+111, 231589, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1859.703125, 402.296875, 76.034332275390625, 0.985746443271636962, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cowardly Cliffreach Cub (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 1213137 - -Unknown-) +(@CGUID+112, 229522, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1796.0208740234375, 486.05035400390625, 81.85687255859375, 0.501943230628967285, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+113, 227668, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1749.49658203125, 491.552093505859375, 15.99021720886230468, 5.617852210998535156, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Seafeather Albatross (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+114, 229622, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1851.3367919921875, 443.689239501953125, 65.81896209716796875, 3.915972709655761718, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Matriarch (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 466036 - -Unknown-) +(@CGUID+115, 230398, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1787.1597900390625, 447.586822509765625, 1.448400378227233886, 4.064474105834960937, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Tidal Kroling (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+116, 228156, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1771.1475830078125, 435.739593505859375, -0.23698934912681579, 5.633904457092285156, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Driftwave Sealion (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 123169 - Mod Scale 105-110%) +(@CGUID+117, 229522, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1795.1024169921875, 644.5625, 43.5179290771484375, 0.639944851398468017, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+118, 231589, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1811.4305419921875, 645.7899169921875, 76.47113037109375, 3.103939056396484375, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Cowardly Cliffreach Cub (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 1213137 - -Unknown-) +(@CGUID+119, 229522, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1857.3177490234375, 618.2899169921875, 63.91638946533203125, 5.098846435546875, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+120, 231589, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1811.671875, 650.5625, 77.07080841064453125, 4.505937099456787109, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Cowardly Cliffreach Cub (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 1213137 - -Unknown-) +(@CGUID+121, 231589, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1814.18408203125, 649.08856201171875, 78.08223724365234375, 1.132803916931152343, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Cowardly Cliffreach Cub (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 1213137 - -Unknown-) (possible waypoints or random movement) +(@CGUID+122, 234711, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1873.99658203125, 650.170166015625, 65.69577789306640625, 2.987303972244262695, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Cub (Area: -Unknown- - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+123, 229522, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1803.3125, 598.19268798828125, 39.58112335205078125, 4.42891550064086914, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+124, 229622, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1776.4010009765625, 634.01910400390625, 36.18164825439453125, 4.170447349548339843, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Matriarch (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 466036 - -Unknown-) +(@CGUID+125, 231589, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1765.6353759765625, 680.1024169921875, 41.480377197265625, 0.85072404146194458, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Cowardly Cliffreach Cub (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 1213137 - -Unknown-) +(@CGUID+126, 229622, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1766.27783203125, 684.45489501953125, 41.84798431396484375, 5.61969614028930664, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Matriarch (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 466036 - -Unknown-) +(@CGUID+127, 231589, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1771.65625, 635.984375, 36.53092193603515625, 0.983655214309692382, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Cowardly Cliffreach Cub (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 1213137 - -Unknown-) +(@CGUID+128, 229522, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1786.1441650390625, 657.44793701171875, 79.5866546630859375, 1.121443152427673339, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+129, 229522, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1719, 662.95660400390625, 27.94429588317871093, 1.121443152427673339, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+130, 234711, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1792.2117919921875, 676.30902099609375, 41.97451019287109375, 2.425073862075805664, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Cub (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+131, 231589, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1770.8802490234375, 685.2569580078125, 42.25356674194335937, 1.662934780120849609, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Cowardly Cliffreach Cub (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 1213137 - -Unknown-) +(@CGUID+132, 231589, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1760.9305419921875, 684.4305419921875, 42.06891632080078125, 5.761165618896484375, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Cowardly Cliffreach Cub (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 1213137 - -Unknown-) +(@CGUID+133, 229522, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1829.326416015625, 598.19268798828125, 39.58112335205078125, 4.022546291351318359, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+134, 234711, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1879.8472900390625, 659.97393798828125, 145.7376861572265625, 5.992696762084960937, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Cub (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+135, 229522, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1895.5242919921875, 634.84027099609375, 114.0138320922851562, 4.865655899047851562, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 466036 - -Unknown-) +(@CGUID+136, 231589, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1843.3038330078125, 640.07989501953125, 114.8230667114257812, 0.786879956722259521, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Cowardly Cliffreach Cub (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 1213137 - -Unknown-) +(@CGUID+137, 229622, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1842.1353759765625, 638.1492919921875, 114.3545074462890625, 4.931416511535644531, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Matriarch (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+138, 229522, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1869.4010009765625, 642.482666015625, 147.976226806640625, 1.121443152427673339, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+139, 233254, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1830.3975830078125, 646.37677001953125, 167.4515838623046875, 1.317789554595947265, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+140, 229522, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1876.1978759765625, 709.203125, 124.5502166748046875, 0.501942634582519531, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+141, 233254, 2127, 10416, 10416, '0', 0, 0, 0, 0, 1964.970458984375, 691.09375, 295.28662109375, 1.317789554595947265, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: Abandoned Mines - Difficulty: 0) CreateObject2 +(@CGUID+142, 229522, 2127, 10416, 10416, '0', 0, 0, 0, 0, 2054.765625, 594.1024169921875, 182.889404296875, 2.920064449310302734, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: Abandoned Mines - Difficulty: 0) CreateObject2 (Auras: 466036 - -Unknown-) +(@CGUID+143, 229534, 2127, 10416, 10416, '0', 0, 0, 0, 0, 2105.645751953125, 549.89581298828125, 147.41839599609375, 1.083865642547607421, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Stormfeather Falcon (Area: Abandoned Mines - Difficulty: 0) CreateObject2 +(@CGUID+144, 229522, 2127, 10416, 10416, '0', 0, 0, 0, 0, 2095.822998046875, 600.87847900390625, 178.305908203125, 4.865655899047851562, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: Abandoned Mines - Difficulty: 0) CreateObject2 (Auras: 466036 - -Unknown-) +(@CGUID+145, 233254, 2127, 10416, 10416, '0', 0, 0, 0, 0, 2075.944580078125, 514.0538330078125, 165.75128173828125, 1.317789554595947265, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: Abandoned Mines - Difficulty: 0) CreateObject2 +(@CGUID+146, 229522, 2127, 10416, 10416, '0', 0, 0, 0, 0, 2090.869873046875, 601.59027099609375, 178.086700439453125, 4.4498748779296875, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: Abandoned Mines - Difficulty: 0) CreateObject2 (Auras: 466036 - -Unknown-) +(@CGUID+147, 234851, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2315.40283203125, 590.61981201171875, -15.5883235931396484, 2.692171096801757812, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Island Crab (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+148, 229625, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2312.697998046875, 477.401031494140625, 3.954866647720336914, 0.382205665111541748, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Skittersong Krolusk (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: ) (possible waypoints or random movement) +(@CGUID+149, 234711, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2239.30029296875, 594.27606201171875, 41.771820068359375, 6.167208671569824218, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Cub (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+150, 229625, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2285.932373046875, 584.48089599609375, 9.554223060607910156, 5.117957592010498046, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Skittersong Krolusk (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 368927 - Cosmetic - Sleep Zzz (With Aggro Change) - Breath) +(@CGUID+151, 229625, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2256.86279296875, 483.1632080078125, 0.775561690330505371, 5.558712005615234375, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Skittersong Krolusk (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+152, 234711, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2216.60595703125, 614.734375, 38.47676849365234375, 4.605159759521484375, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Cub (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+153, 234854, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2268.89404296875, 510.12847900390625, 22.9790191650390625, 5.80934906005859375, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Gull (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+154, 229625, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2284.734375, 570.74481201171875, 9.697809219360351562, 3.360787868499755859, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Skittersong Krolusk (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+155, 234711, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2193.529541015625, 578.6180419921875, 38.26985931396484375, 0, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Cub (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+156, 234854, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2284.302001953125, 543.2725830078125, 17.41774177551269531, 5.80934906005859375, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Gull (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+157, 234854, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2281.8212890625, 542.40802001953125, 17.58270263671875, 4.400577068328857421, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Gull (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+158, 229522, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2266.053955078125, 560.78125, 43.60708999633789062, 3.616588592529296875, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 466036 - -Unknown-) +(@CGUID+159, 229522, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2235.111083984375, 580.328125, 88.86792755126953125, 3.915761947631835937, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+160, 234854, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2276.460205078125, 514.420166015625, 12.61083602905273437, 5.95587015151977539, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Gull (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+161, 234851, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2294.6875, 500.65972900390625, 0.275600463151931762, 3.411942243576049804, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Island Crab (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+162, 234854, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2324.982666015625, 509.607635498046875, 9.317589759826660156, 4.480603218078613281, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Gull (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+163, 234854, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2231.239501953125, 516.0086669921875, 7.43719482421875, 2.510854959487915039, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Gull (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+164, 234854, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2267.692626953125, 508.87152099609375, 23.02444267272949218, 5.104508399963378906, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Gull (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+165, 234854, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2311.119873046875, 530.763916015625, 6.202540397644042968, 3.87837386131286621, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Gull (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+166, 230398, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2176.77783203125, 436.87847900390625, 2.901411294937133789, 5.94722604751586914, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Tidal Kroling (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+167, 234851, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2223.647705078125, 490.94097900390625, -14.9128980636596679, 1.078991055488586425, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Island Crab (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+168, 230398, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2225.640625, 408.057281494140625, 0.71316605806350708, 4.974559783935546875, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Tidal Kroling (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: ) (possible waypoints or random movement) +(@CGUID+169, 234851, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2263.126708984375, 523.6649169921875, -10.9261960983276367, 3.188102245330810546, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Island Crab (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+170, 229625, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2200.732666015625, 465.868072509765625, -10.9895534515380859, 5.543344497680664062, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Skittersong Krolusk (Area: -Unknown- - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+171, 234851, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2247.609375, 444.310760498046875, 1.265911102294921875, 2.346276283264160156, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Island Crab (Area: -Unknown- - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+172, 229625, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2145.53466796875, 451.604156494140625, -2.08858871459960937, 2.150033473968505859, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Skittersong Krolusk (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+173, 229625, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2222.829833984375, 395.42535400390625, 2.241379499435424804, 0.92891162633895874, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Skittersong Krolusk (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+174, 234851, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2145.979248046875, 459.779510498046875, -5.53929805755615234, 0.128566071391105651, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Island Crab (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+175, 234851, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2124.470458984375, 446.055572509765625, 0.070717178285121917, 3.239376544952392578, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Island Crab (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+176, 234851, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2109.288330078125, 447.248260498046875, 0.63620924949645996, 6.041200637817382812, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Island Crab (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+177, 230398, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2156.64404296875, 375.546875, 40.06418991088867187, 0.91167914867401123, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Tidal Kroling (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+178, 229625, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2155.861083984375, 373.557281494140625, 41.054443359375, 5.30739450454711914, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Skittersong Krolusk (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+179, 229625, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2099.74658203125, 438.61285400390625, 32.042327880859375, 3.360787868499755859, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Skittersong Krolusk (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 368927 - Cosmetic - Sleep Zzz (With Aggro Change) - Breath) +(@CGUID+180, 229625, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2160.442626953125, 363.18402099609375, 42.39817047119140625, 0.439459383487701416, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Skittersong Krolusk (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 368927 - Cosmetic - Sleep Zzz (With Aggro Change) - Breath) +(@CGUID+181, 230398, 2127, 10416, 15536, '0', 0, 0, 0, 0, 2157.451416015625, 368.80902099609375, 41.63422393798828125, 5.119905471801757812, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Tidal Kroling (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+182, 227668, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1697.5191650390625, 580.515625, 15.95536136627197265, 0.066827230155467987, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Seafeather Albatross (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+183, 227668, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1695.751708984375, 572.7100830078125, 6.460476875305175781, 3.826427698135375976, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Seafeather Albatross (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+184, 234851, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1718.375, 562.04339599609375, 0.423856765031814575, 4.900136947631835937, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Island Crab (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+185, 227668, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1716.6180419921875, 556.4913330078125, 0.347947120666503906, 2.259165287017822265, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Seafeather Albatross (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+186, 231698, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1708.484375, 591.78125, -0.90543591976165771, 6.008106708526611328, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Driftwave Bull (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 123169 - Mod Scale 105-110%) +(@CGUID+187, 230398, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1729.0260009765625, 584.11285400390625, 0.276197373867034912, 2.419386625289916992, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Tidal Kroling (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+188, 227668, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1650.263916015625, 600.263916015625, 11.62514686584472656, 1.182811617851257324, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Seafeather Albatross (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+189, 228156, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1705.96875, 594.5711669921875, -3.47569465637207031, 2.461423158645629882, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Driftwave Sealion (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 123169 - Mod Scale 105-110%) +(@CGUID+190, 234851, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1631.4930419921875, 512.62847900390625, 0.236880630254745483, 5.484361648559570312, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Island Crab (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+191, 227668, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1716.8160400390625, 558.7430419921875, 0.367652535438537597, 3.478940248489379882, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Seafeather Albatross (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+192, 227668, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1698.546875, 500.052093505859375, 33.77408599853515625, 1.288265824317932128, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Seafeather Albatross (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+193, 234851, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1657.0555419921875, 522.8125, 0.217620491981506347, 3.496802806854248046, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Island Crab (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+194, 227668, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1598.890625, 544.46875, 40.03278350830078125, 1.374449968338012695, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Seafeather Albatross (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+195, 227668, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1651.7135009765625, 510.414947509765625, 47.84217071533203125, 1.182811617851257324, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Seafeather Albatross (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+196, 232674, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1594.935791015625, 531.18927001953125, 51.5555419921875, 0.623105108737945556, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Seafeather Chick (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+197, 232674, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1583.6927490234375, 510.982635498046875, 58.77104949951171875, 3.57555556297302246, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Seafeather Chick (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+198, 232674, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1594.359375, 531.3836669921875, 51.53062057495117187, 1.817382693290710449, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Seafeather Chick (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+199, 227668, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1550.2882080078125, 460.838531494140625, 25.14907073974609375, 1.374450445175170898, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Seafeather Albatross (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+200, 232674, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1599.9722900390625, 522.90802001953125, 38.8090667724609375, 1.201133608818054199, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Seafeather Chick (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+201, 233254, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1627.8941650390625, 530.6336669921875, 50.80457687377929687, 1.317789554595947265, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Cliffreach Pridetalon (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+202, 227668, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1609.0677490234375, 501.798614501953125, 34.21367263793945312, 0.416228652000427246, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Seafeather Albatross (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+203, 227668, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1626.092041015625, 494.767364501953125, 59.22515869140625, 1.374450445175170898, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Seafeather Albatross (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+204, 227668, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1599.5972900390625, 523.0086669921875, 38.5869903564453125, 1.171936869621276855, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Seafeather Albatross (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+205, 232674, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1624.126708984375, 499.65277099609375, 57.36232376098632812, 1.164172053337097167, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Seafeather Chick (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+206, 227668, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1604.982666015625, 523.19964599609375, 64.285797119140625, 2.584350109100341796, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Seafeather Albatross (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+207, 227668, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1740.7413330078125, 467.23785400390625, 28.56869888305664062, 1.374450445175170898, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Seafeather Albatross (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+208, 227668, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1723.9010009765625, 444.744781494140625, 23.92162322998046875, 4.95099496841430664, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Seafeather Albatross (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+209, 227668, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1732.3646240234375, 400.28125, 35.39431381225585937, 1.374450445175170898, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Seafeather Albatross (Area: -Unknown- - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+210, 227664, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1744.798583984375, 365.14410400390625, 0.040812607854604721, 2.427169084548950195, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Tidal Sandskitter (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+211, 227668, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1753.2742919921875, 427.493072509765625, 0.568414688110351562, 5.388520717620849609, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Seafeather Albatross (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+212, 227668, 2127, 10416, 15538, '0', 0, 0, 0, 0, 1627.578125, 444.701385498046875, 24.55088233947753906, 4.643327236175537109, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Seafeather Albatross (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+213, 227660, 2127, 10416, 15537, '0', 0, 0, 0, 0, 1720.3629150390625, 303.0694580078125, -0.00455134361982345, 3.483798503875732421, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Sandsifting Hardshell (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+214, 228156, 2127, 10416, 15537, '0', 0, 0, 0, 0, 1706.0260009765625, 278.578125, -0.02964365482330322, 3.503863096237182617, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Driftwave Sealion (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 123169 - Mod Scale 105-110%) +(@CGUID+215, 227664, 2127, 10416, 15537, '0', 0, 0, 0, 0, 1664.5660400390625, 241.421875, -0.24576556682586669, 5.320774078369140625, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Tidal Sandskitter (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+216, 234851, 2127, 10416, 15537, '0', 0, 0, 0, 0, 1690.6336669921875, 255.8975677490234375, -0.9925045371055603, 3.170015811920166015, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Island Crab (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+217, 228156, 2127, 10416, 15537, '0', 0, 0, 0, 0, 1713.5850830078125, 289.1875, -0.55086982250213623, 2.156193494796752929, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Driftwave Sealion (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 123169 - Mod Scale 105-110%) +(@CGUID+218, 227668, 2127, 10416, 15537, '0', 0, 0, 0, 0, 1633.5, 224.9375, 14.81439685821533203, 0.342828720808029174, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Seafeather Albatross (Area: -Unknown- - Difficulty: 0) CreateObject2 (Auras: 258247 - Perched) +(@CGUID+219, 234851, 2127, 10416, 15537, '0', 0, 0, 0, 0, 1653.984375, 239.3177032470703125, -0.31109777092933654, 5.294445991516113281, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Island Crab (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+220, 227660, 2127, 10416, 15537, '0', 0, 0, 0, 0, 1680.0225830078125, 246.9479217529296875, -0.32090705633163452, 4.234796524047851562, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 58238), -- Sandsifting Hardshell (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+221, 229534, 2127, 10416, 15537, '0', 0, 0, 0, 0, 1799.3160400390625, 115.270843505859375, 53.3480224609375, 6.10028696060180664, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Stormfeather Falcon (Area: -Unknown- - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+222, 229534, 2127, 10416, 15537, '0', 0, 0, 0, 0, 1846.111083984375, 126.5885391235351562, 48.28297042846679687, 6.100286483764648437, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Stormfeather Falcon (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+223, 229534, 2127, 10416, 15537, '0', 0, 0, 0, 0, 1752.7882080078125, 30.77083396911621093, 108.289306640625, 6.100286483764648437, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Stormfeather Falcon (Area: -Unknown- - Difficulty: 0) CreateObject2 +(@CGUID+224, 229534, 2127, 10416, 15537, '0', 0, 0, 0, 0, 1724.40625, 67.31076812744140625, 59.10849761962890625, 6.100286483764648437, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238), -- Stormfeather Falcon (Area: -Unknown- - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+225, 229534, 2127, 10416, 15537, '0', 0, 0, 0, 0, 1820.73095703125, -4.83159732818603515, 92.50832366943359375, 6.100286483764648437, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 58238); -- Stormfeather Falcon (Area: -Unknown- - Difficulty: 0) CreateObject2 +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+225; +INSERT INTO `creature_addon` (`guid`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+185, 0, 0, 0, 0, 0, 1, 0, 735, 0, 0, 0, 0, ''), -- Seafeather Albatross +(@CGUID+191, 0, 0, 0, 0, 0, 1, 0, 735, 0, 0, 0, 0, ''), -- Seafeather Albatross +(@CGUID+202, 0, 0, 0, 0, 0, 1, 0, 735, 0, 0, 0, 0, ''), -- Seafeather Albatross +(@CGUID+211, 0, 0, 0, 0, 0, 1, 0, 735, 0, 0, 0, 0, ''); -- Seafeather Albatross + +-- GameObject +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+21; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 476637, 2127, 10416, 15538, '0', 0, 0, 1609.5555419921875, 513.763916015625, 34.2382965087890625, 5.878577232360839843, 0.013854026794433593, -0.05166530609130859, -0.19951534271240234, 0.978433609008789062, 120, 255, 1, 58238), -- Albatross Nest (Area: -Unknown- - Difficulty: 0) CreateObject1 +(@OGUID+1, 456065, 2127, 10416, 15538, '0', 0, 0, 1607.4010009765625, 510.196197509765625, 34.05609130859375, 2.356800079345703125, -0.16408967971801757, -0.3059539794921875, 0.871318817138671875, 0.346800029277801513, 120, 255, 1, 58238), -- Gorged Bones (Area: -Unknown- - Difficulty: 0) CreateObject1 +(@OGUID+2, 456065, 2127, 10416, 15538, '0', 0, 0, 1624.326416015625, 500.20660400390625, 57.53203582763671875, 2.509921073913574218, -0.29104375839233398, -0.50109386444091796, 0.796764373779296875, 0.171362191438674926, 120, 255, 1, 58238), -- Gorged Bones (Area: -Unknown- - Difficulty: 0) CreateObject1 +(@OGUID+3, 476637, 2127, 10416, 15538, '0', 0, 0, 1599.7535400390625, 523.140625, 39.32863616943359375, 5.679018497467041015, 0.062085151672363281, 0.061903953552246093, -0.29940032958984375, 0.950090944766998291, 120, 255, 1, 58238), -- Albatross Nest (Area: -Unknown- - Difficulty: 0) CreateObject1 +(@OGUID+4, 248399, 2127, 10416, 15538, '0', 0, 0, 1609.423583984375, 513.72222900390625, 34.29759597778320312, 6.23342132568359375, 0.009889125823974609, -0.04669475555419921, -0.0243377685546875, 0.998563706874847412, 120, 255, 1, 58238), -- Fish Bones (Area: -Unknown- - Difficulty: 0) CreateObject1 +(@OGUID+5, 456051, 2127, 10416, 15538, '0', 0, 0, 1610.546875, 502.227447509765625, 34.32147598266601562, 1.87542736530303955, -0.07508659362792968, -0.05027389526367187, 0.804460525512695312, 0.587092697620391845, 120, 255, 1, 58238), -- Gorged Bones (Area: -Unknown- - Difficulty: 0) CreateObject1 +(@OGUID+6, 476637, 2127, 10416, 15538, '0', 0, 0, 1617.654541015625, 497.755218505859375, 49.31754684448242187, 0.273599177598953247, -0.11471319198608398, -0.21971988677978515, 0.102374076843261718, 0.963370978832244873, 120, 255, 1, 58238), -- Albatross Nest (Area: -Unknown- - Difficulty: 0) CreateObject1 +(@OGUID+7, 476637, 2127, 10416, 15538, '0', 0, 0, 1612.9375, 507.798614501953125, 34.54149627685546875, 5.878577232360839843, 0.013854026794433593, -0.05166530609130859, -0.19951534271240234, 0.978433609008789062, 120, 255, 1, 58238), -- Albatross Nest (Area: -Unknown- - Difficulty: 0) CreateObject1 +(@OGUID+8, 476637, 2127, 10416, 15538, '0', 0, 0, 1623.9444580078125, 499.40277099609375, 57.31214141845703125, 5.973977565765380859, -0.19122314453125, -0.04037666320800781, -0.1637725830078125, 0.966944634914398193, 120, 255, 1, 58238), -- Albatross Nest (Area: -Unknown- - Difficulty: 0) CreateObject1 +(@OGUID+9, 248399, 2127, 10416, 15538, '0', 0, 0, 1614.8802490234375, 503.65277099609375, 34.86443328857421875, 0.634432673454284667, 0, 0, 0.311923027038574218, 0.950107336044311523, 120, 255, 1, 58238), -- Fish Bones (Area: -Unknown- - Difficulty: 0) CreateObject1 +(@OGUID+10, 476637, 2127, 10416, 15538, '0', 0, 0, 1594.4774169921875, 531.0694580078125, 51.35242462158203125, 5.076344490051269531, -0.11725473403930664, 0.008715629577636718, -0.56851100921630859, 0.814230084419250488, 120, 255, 1, 58238), -- Albatross Nest (Area: -Unknown- - Difficulty: 0) CreateObject1 +(@OGUID+11, 476637, 2127, 10416, 15538, '0', 0, 0, 1615.2430419921875, 506.286468505859375, 34.9220123291015625, 6.048951625823974609, -0.03913211822509765, -0.09047412872314453, -0.11894607543945312, 0.987995445728302001, 120, 255, 1, 58238), -- Albatross Nest (Area: -Unknown- - Difficulty: 0) CreateObject1 +(@OGUID+12, 476637, 2127, 10416, 15538, '0', 0, 0, 1614.9600830078125, 503.62152099609375, 34.73263931274414062, 5.878577232360839843, 0.013854026794433593, -0.05166530609130859, -0.19951534271240234, 0.978433609008789062, 120, 255, 1, 58238), -- Albatross Nest (Area: -Unknown- - Difficulty: 0) CreateObject1 +(@OGUID+13, 456065, 2127, 10416, 15538, '0', 0, 0, 1614.532958984375, 503.545135498046875, 35.03441619873046875, 0.130720853805541992, -0.1470494270324707, 0.1179962158203125, 0.082124710083007812, 0.978626012802124023, 120, 255, 1, 58238), -- Gorged Bones (Area: -Unknown- - Difficulty: 0) CreateObject1 +(@OGUID+14, 476637, 2127, 10416, 15538, '0', 0, 0, 1607.532958984375, 509.536468505859375, 33.89764404296875, 5.878577232360839843, 0.013854026794433593, -0.05166530609130859, -0.19951534271240234, 0.978433609008789062, 120, 255, 1, 58238), -- Albatross Nest (Area: -Unknown- - Difficulty: 0) CreateObject1 +(@OGUID+15, 476637, 2127, 10416, 15538, '0', 0, 0, 1606.7691650390625, 504.359375, 33.91953659057617187, 5.878577232360839843, 0.013854026794433593, -0.05166530609130859, -0.19951534271240234, 0.978433609008789062, 120, 255, 1, 58238), -- Albatross Nest (Area: -Unknown- - Difficulty: 0) CreateObject1 +(@OGUID+16, 476637, 2127, 10416, 15538, '0', 0, 0, 1632.032958984375, 498.758697509765625, 51.50532913208007812, 6.014680862426757812, -0.0564126968383789, 0.0146026611328125, -0.1332244873046875, 0.989371299743652343, 120, 255, 1, 58238), -- Albatross Nest (Area: -Unknown- - Difficulty: 0) CreateObject1 +(@OGUID+17, 476637, 2127, 10416, 15538, '0', 0, 0, 1599.201416015625, 507.9757080078125, 35.53594589233398437, 6.048951625823974609, -0.03913211822509765, -0.09047412872314453, -0.11894607543945312, 0.987995445728302001, 120, 255, 1, 58238), -- Albatross Nest (Area: -Unknown- - Difficulty: 0) CreateObject1 +(@OGUID+18, 456065, 2127, 10416, 15538, '0', 0, 0, 1613.3853759765625, 510.743072509765625, 34.55577850341796875, 0.048385359346866607, -0.30393505096435546, -0.08406639099121093, -0.00177192687988281, 0.948974788188934326, 120, 255, 1, 58238), -- Gorged Bones (Area: -Unknown- - Difficulty: 0) CreateObject1 +(@OGUID+19, 476637, 2127, 10416, 15538, '0', 0, 0, 1604.107666015625, 505.29339599609375, 33.74602127075195312, 5.878577232360839843, 0.013854026794433593, -0.05166530609130859, -0.19951534271240234, 0.978433609008789062, 120, 255, 1, 58238), -- Albatross Nest (Area: -Unknown- - Difficulty: 0) CreateObject1 +(@OGUID+20, 476637, 2127, 10416, 15538, '0', 0, 0, 1583.907958984375, 511.180572509765625, 58.64616775512695312, 5.878577232360839843, 0.013854026794433593, -0.05166530609130859, -0.19951534271240234, 0.978433609008789062, 120, 255, 1, 58238), -- Albatross Nest (Area: -Unknown- - Difficulty: 0) CreateObject1 +(@OGUID+21, 476637, 2127, 10416, 15538, '0', 0, 0, 1584.1978759765625, 525.45831298828125, 60.34513473510742187, 5.878577232360839843, 0.013854026794433593, -0.05166530609130859, -0.19951534271240234, 0.978433609008789062, 120, 255, 1, 58238); -- Albatross Nest (Area: -Unknown- - Difficulty: 0) CreateObject1 + +-- Template Addon +DELETE FROM `creature_template_addon` WHERE `entry` IN (228156, 231698, 234854, 229522, 233254, 234711, 229622); +INSERT INTO `creature_template_addon` (`entry`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(228156, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123169'), -- Driftwave Sealion - 123169 - Mod Scale 105-110% +(231698, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123169'), -- 231698 (Driftwave Bull) - Mod Scale 105-110% +(234854, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 234854 (Gull) +(229522, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 229522 (Cliffreach Pridetalon) +(233254, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 3, ''), -- 233254 (Cliffreach Pridetalon) +(234711, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 234711 (Cliffreach Cub) +(229622, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 0, ''); -- 229622 (Cliffreach Matriarch) + +-- Template +DELETE FROM `gameobject_template` WHERE `entry` = 476637; -- Albatross Nest +INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `Data24`, `Data25`, `Data26`, `Data27`, `Data28`, `Data29`, `Data30`, `Data31`, `Data32`, `Data33`, `Data34`, `ContentTuningId`, `VerifiedBuild`) VALUES +(476637, 5, 7527, 'Albatross Nest', '', '', '', 0.5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 58238); -- Albatross Nest + +UPDATE `creature_template` SET `faction`=188, `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=234853; -- Invasive Rat +UPDATE `creature_template` SET `faction`=188, `npcflag`=1073741824, `speed_run`=0.857142865657806396, `BaseAttackTime`=2000, `unit_flags`=0x200, `unit_flags2`=0x800 WHERE `entry`=230394; -- Tidal Kroling +UPDATE `creature_template` SET `faction`=190, `BaseAttackTime`=2000, `unit_flags2`=0x800, `unit_flags3`=0x4000000 WHERE `entry`=229534; -- Stormfeather Falcon +UPDATE `creature_template` SET `faction`=14, `speed_run`=1.428571462631225585, `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=229625; -- Skittersong Krolusk +UPDATE `creature_template` SET `faction`=188, `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=234865; -- Island Cockroach +UPDATE `creature_template` SET `faction`=31, `speed_run`=1.428571462631225585, `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=234854; -- Gull +UPDATE `creature_template` SET `faction`=2156, `BaseAttackTime`=2000, `unit_flags2`=0x800, `unit_flags3`=0x4000000 WHERE `entry`=227668; -- Seafeather Albatross +UPDATE `creature_template` SET `faction`=188, `speed_run`=0.857142865657806396, `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=230398; -- Tidal Kroling +UPDATE `creature_template` SET `faction`=190, `BaseAttackTime`=2000, `unit_flags2`=0x800, `unit_flags3`=0x4000000 WHERE `entry`=227664; -- Tidal Sandskitter +UPDATE `creature_template` SET `faction`=188, `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=234851; -- Island Crab +UPDATE `creature_template` SET `faction`=2753, `speed_walk`=0.60000002384185791, `BaseAttackTime`=2000, `unit_flags2`=0x800, `unit_flags3`=0x4000000 WHERE `entry`=229527; -- Sirentusk +UPDATE `creature_template` SET `faction`=2753, `speed_walk`=0.60000002384185791, `BaseAttackTime`=2000, `unit_flags2`=0x800, `unit_flags3`=0x4000000 WHERE `entry`=234959; -- Sirentusk Piglet +UPDATE `creature_template` SET `faction`=190, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=228156; -- Driftwave Sealion +UPDATE `creature_template` SET `faction`=190, `BaseAttackTime`=2000, `unit_flags2`=0x800, `unit_flags3`=0x4000000 WHERE `entry`=227660; -- Sandsifting Hardshell +UPDATE `creature_template` SET `faction`=188, `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=234711; -- Cliffreach Cub +UPDATE `creature_template` SET `faction`=14, `speed_run`=1.428571462631225585, `BaseAttackTime`=2000, `unit_flags2`=0x800, `unit_flags3`=0x4000000 WHERE `entry` IN (229522, 233254); -- Cliffreach Pridetalon +UPDATE `creature_template` SET `faction`=188, `speed_run`=0.857142865657806396, `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=234099; -- Rusty Kroling +UPDATE `creature_template` SET `faction`=188, `npcflag`=1073741824, `speed_run`=0.857142865657806396, `BaseAttackTime`=2000, `unit_flags`=0x200, `unit_flags2`=0x800 WHERE `entry`=234097; -- Rusty Kroling +UPDATE `creature_template` SET `faction`=14, `speed_run`=1.428571462631225585, `BaseAttackTime`=2000, `unit_flags2`=0x800, `unit_flags3`=0x4000000 WHERE `entry`=229622; -- Cliffreach Matriarch +UPDATE `creature_template` SET `faction`=188, `npcflag`=1073741824, `BaseAttackTime`=2000, `unit_flags`=0x200, `unit_flags2`=0x800 WHERE `entry`=234710; -- Cliffreach Cub +UPDATE `creature_template` SET `faction`=188, `speed_run`=0.857142865657806396, `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=231589; -- Cowardly Cliffreach Cub +UPDATE `creature_template` SET `faction`=14, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=231698; -- Driftwave Bull +UPDATE `creature_template` SET `faction`=31, `speed_run`=1.428571462631225585, `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=232674; -- Seafeather Chick + +-- Difficulty +UPDATE `creature_template_difficulty` SET `ContentTuningID`=3004, `StaticFlags1`=0x10000000, `VerifiedBuild`=58238 WHERE (`Entry`=229527 AND `DifficultyID`=0); -- 229527 (Sirentusk) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=3004, `StaticFlags1`=0x10000000, `VerifiedBuild`=58238 WHERE (`Entry`=234959 AND `DifficultyID`=0); -- 234959 (Sirentusk Piglet) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=81, `StaticFlags1`=0x10000000, `VerifiedBuild`=58238 WHERE (`Entry`=234853 AND `DifficultyID`=0); -- 234853 (Invasive Rat) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=3004, `StaticFlags1`=0x30000000, `VerifiedBuild`=58238 WHERE (`Entry`=229534 AND `DifficultyID`=0); -- 229534 (Stormfeather Falcon) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=3004, `StaticFlags1`=0x10000000, `VerifiedBuild`=58238 WHERE (`Entry`=229625 AND `DifficultyID`=0); -- 229625 (Skittersong Krolusk) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=81, `StaticFlags1`=0x10000000, `VerifiedBuild`=58238 WHERE (`Entry`=234865 AND `DifficultyID`=0); -- 234865 (Island Cockroach) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=81, `StaticFlags1`=0x30000000, `VerifiedBuild`=58238 WHERE (`Entry`=234854 AND `DifficultyID`=0); -- 234854 (Gull) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=3004, `StaticFlags1`=0x30000000, `VerifiedBuild`=58238 WHERE (`Entry`=227668 AND `DifficultyID`=0); -- 227668 (Seafeather Albatross) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=3004, `StaticFlags1`=0x10000000, `VerifiedBuild`=58238 WHERE (`Entry`=228156 AND `DifficultyID`=0); -- 228156 (Driftwave Sealion) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=3004, `StaticFlags1`=0x10000000, `VerifiedBuild`=58238 WHERE (`Entry`=227660 AND `DifficultyID`=0); -- 227660 (Sandsifting Hardshell) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=3004, `StaticFlags1`=0x10000000, `VerifiedBuild`=58238 WHERE (`Entry`=227664 AND `DifficultyID`=0); -- 227664 (Tidal Sandskitter) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=371, `StaticFlags1`=0x30000000, `VerifiedBuild`=58238 WHERE (`Entry`=234711 AND `DifficultyID`=0); -- 234711 (Cliffreach Cub) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=3004, `StaticFlags1`=0x30000000, `VerifiedBuild`=58238 WHERE (`Entry`=229522 AND `DifficultyID`=0); -- 229522 (Cliffreach Pridetalon) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=3004, `StaticFlags1`=0x30000000, `VerifiedBuild`=58238 WHERE (`Entry`=233254 AND `DifficultyID`=0); -- 233254 (Cliffreach Pridetalon) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=371, `StaticFlags1`=0x10000000, `VerifiedBuild`=58238 WHERE (`Entry`=234099 AND `DifficultyID`=0); -- 234099 (Rusty Kroling) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=371, `StaticFlags1`=0x10000000, `VerifiedBuild`=58238 WHERE (`Entry`=234097 AND `DifficultyID`=0); -- 234097 (Rusty Kroling) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=3004, `StaticFlags1`=0x30000000, `VerifiedBuild`=58238 WHERE (`Entry`=229622 AND `DifficultyID`=0); -- 229622 (Cliffreach Matriarch) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=371, `StaticFlags1`=0x30000000, `VerifiedBuild`=58238 WHERE (`Entry`=234710 AND `DifficultyID`=0); -- 234710 (Cliffreach Cub) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=3004, `StaticFlags1`=0x20000000, `VerifiedBuild`=58238 WHERE (`Entry`=231589 AND `DifficultyID`=0); -- 231589 (Cowardly Cliffreach Cub) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=3004, `StaticFlags1`=0x10000000, `VerifiedBuild`=58238 WHERE (`Entry`=231698 AND `DifficultyID`=0); -- 231698 (Driftwave Bull) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=81, `StaticFlags1`=0x30000000, `VerifiedBuild`=58238 WHERE (`Entry`=232674 AND `DifficultyID`=0); -- 232674 (Seafeather Chick) - CanSwim, Floating + +-- Gull smart ai +SET @ENTRY := 234854; +UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY; +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`, `action_param7`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`, `Difficulties`) VALUES +(@ENTRY, 0, 0, 0, 1, 0, 100, 1, 1000, 1000, 0, 0, 0, 85, 258247, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Time = 1 seconds (OOC) - Self: Cast spell 258247 on self', ''); + +DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId` = 22 AND `SourceGroup` = 1 AND `SourceEntry` = @ENTRY); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `Comment`) VALUES +(22, 1, @ENTRY, 0, 0, 58, 1, 0, 0, 0, 'ChannelPerched', 0, 'Scripted creature has StringId ''ChannelPerched'''); + +UPDATE `creature` SET `StringId`='ChannelPerched' WHERE `guid` IN (@CGUID+18, @CGUID+19, @CGUID+22, @CGUID+21, @CGUID+20, @CGUID+23, @CGUID+25, @CGUID+157, @CGUID+156, @CGUID+160, @CGUID+153, @CGUID+164); + +-- Seafeather Albatross ai +SET @ENTRY := 227668; +UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY; +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`, `action_param7`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`, `Difficulties`) VALUES +(@ENTRY, 0, 0, 0, 1, 0, 100, 1, 1000, 1000, 0, 0, 0, 85, 258247, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Time = 1 seconds (OOC) - Self: Cast spell 258247 on self', ''); + +DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId` = 22 AND `SourceGroup` = 1 AND `SourceEntry` = @ENTRY); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `Comment`) VALUES +(22, 1, @ENTRY, 0, 0, 58, 1, 0, 0, 0, 'ChannelPerched', 0, 'Scripted creature has StringId ''ChannelPerched'''); + +UPDATE `creature` SET `StringId`='ChannelPerched' WHERE `guid` IN (@CGUID+113, @CGUID+183, @CGUID+182, @CGUID+188, @CGUID+192, @CGUID+195, @CGUID+204, @CGUID+218); + +-- Seafeather Chick ai +SET @ENTRY := 232674; +UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY; +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`, `action_param7`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`, `Difficulties`) VALUES +(@ENTRY, 0, 0, 0, 1, 0, 100, 1, 1000, 1000, 0, 0, 0, 85, 258247, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Time = 1 seconds (OOC) - Self: Cast spell 258247 on self', ''); + +DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId` = 22 AND `SourceGroup` = 1 AND `SourceEntry` = @ENTRY); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `Comment`) VALUES +(22, 1, @ENTRY, 0, 0, 58, 1, 0, 0, 0, 'ChannelPerched', 0, 'Scripted creature has StringId ''ChannelPerched'''); + +UPDATE `creature` SET `StringId`='ChannelPerched' WHERE `guid` IN (@CGUID+205, @CGUID+197, @CGUID+196, @CGUID+198, @CGUID+200); + +-- Stormfeather Falcon ai +SET @ENTRY := 229534; +UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY; +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`, `action_param7`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`, `Difficulties`) VALUES +(@ENTRY, 0, 0, 0, 1, 0, 100, 1, 1000, 1000, 0, 0, 0, 85, 258247, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Time = 1 seconds (OOC) - Self: Cast spell 258247 on self', ''); + +DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId` = 22 AND `SourceGroup` = 1 AND `SourceEntry` = @ENTRY); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `Comment`) VALUES +(22, 1, @ENTRY, 0, 0, 58, 1, 0, 0, 0, 'ChannelPerched', 0, 'Scripted creature has StringId ''ChannelPerched'''); + +UPDATE `creature` SET `StringId`='ChannelPerched' WHERE `guid` IN (@CGUID+37, @CGUID+31, @CGUID+43, @CGUID+67, @CGUID+69, @CGUID+88, @CGUID+89, @CGUID+92); + +-- Cliffreach Pridetalon ai +SET @ENTRY := 229522; +UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY; +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`, `action_param7`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`, `Difficulties`) VALUES +(@ENTRY, 0, 0, 0, 1, 0, 100, 1, 1000, 1000, 0, 0, 0, 85, 466036, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Time = 1 seconds (OOC) - Self: Cast spell 466036 on self', ''); + +DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId` = 22 AND `SourceGroup` = 1 AND `SourceEntry` = @ENTRY); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `Comment`) VALUES +(22, 1, @ENTRY, 0, 0, 58, 1, 0, 0, 0, 'ChannelPerched', 0, 'Scripted creature has StringId ''ChannelPerched'''); + +UPDATE `creature` SET `StringId`='ChannelPerched' WHERE `guid` IN (@CGUID+38, @CGUID+40, @CGUID+46, @CGUID+50, @CGUID+53, @CGUID+98, @CGUID+97, @CGUID+106, @CGUID+135, @CGUID+126, @CGUID+124, @CGUID+123, @CGUID+142, @CGUID+146, @CGUID+144, @CGUID+158); + +-- Cliffreach Matriarch ai +SET @ENTRY := 229622; +UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY; +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`, `action_param7`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`, `Difficulties`) VALUES +(@ENTRY, 0, 0, 0, 1, 0, 100, 1, 1000, 1000, 0, 0, 0, 85, 466036, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Time = 1 seconds (OOC) - Self: Cast spell 466036 on self', ''); + +DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId` = 22 AND `SourceGroup` = 1 AND `SourceEntry` = @ENTRY); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `Comment`) VALUES +(22, 1, @ENTRY, 0, 0, 58, 1, 0, 0, 0, 'ChannelPerched', 0, 'Scripted creature has StringId ''ChannelPerched'''); + +UPDATE `creature` SET `StringId`='ChannelPerched' WHERE `guid` IN (@CGUID+114); + +-- Path for Sirentusk +SET @MOVERGUID := @CGUID+72; +SET @ENTRY := 229527; +SET @PATHOFFSET := 0; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x0, NULL, 'Sirentusk - Cosmetic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1903.7673, 399.05557, 18.896818, NULL, 0), +(@PATH, 1, 1902.7067, 401.7014, 19.175179, NULL, 0), +(@PATH, 2, 1903.3229, 404.55902, 19.689682, NULL, 0), +(@PATH, 3, 1904.3055, 408.84375, 20.909504, NULL, 0), +(@PATH, 4, 1904.1442, 412.6059, 21.920263, NULL, 0), +(@PATH, 5, 1901.0156, 416.68057, 22.22253, NULL, 0), +(@PATH, 6, 1896.368, 419.7934, 22.176025, NULL, 0), +(@PATH, 7, 1892.8541, 420.97397, 22.410347, NULL, 0), +(@PATH, 8, 1887.0712, 420.9566, 21.943201, NULL, 0), +(@PATH, 9, 1883.7705, 418.69922, 20.320347, NULL, 0), +(@PATH, 10, 1882.9805, 416.8457, 19.728977, NULL, 0), +(@PATH, 11, 1882.207, 415.00195, 19.23576, NULL, 0), +(@PATH, 12, 1881.5955, 413.54102, 18.98115, NULL, 0), +(@PATH, 13, 1881.5625, 408.7986, 18.905052, NULL, 0), +(@PATH, 14, 1884.3142, 406.29166, 19.070824, NULL, 0), +(@PATH, 15, 1887.2101, 404.21008, 19.157682, NULL, 0), +(@PATH, 16, 1890.7448, 404.3837, 18.744457, NULL, 0), +(@PATH, 17, 1891.3716, 405.54514, 18.731804, NULL, 0), +(@PATH, 18, 1887.2101, 404.21008, 19.157682, NULL, 0), +(@PATH, 19, 1884.3142, 406.29166, 19.070824, NULL, 0), +(@PATH, 20, 1881.5625, 408.7986, 18.905052, NULL, 0), +(@PATH, 21, 1881.5955, 413.54102, 18.98115, NULL, 0), +(@PATH, 22, 1883.7535, 418.68924, 20.51408, NULL, 0), +(@PATH, 23, 1887.0547, 420.94727, 22.084435, NULL, 0), +(@PATH, 24, 1892.8541, 420.97397, 22.410347, NULL, 0), +(@PATH, 25, 1896.368, 419.7934, 22.176025, NULL, 0), +(@PATH, 26, 1901.0156, 416.68057, 22.22253, NULL, 0), +(@PATH, 27, 1904.1442, 412.6059, 21.920263, NULL, 0), +(@PATH, 28, 1904.3055, 408.84375, 20.909504, NULL, 0), +(@PATH, 29, 1903.3229, 404.55902, 19.689682, NULL, 0), +(@PATH, 30, 1902.7067, 401.7014, 19.175179, NULL, 0), +(@PATH, 31, 1903.7673, 399.05557, 18.896818, NULL, 0), +(@PATH, 32, 1906.1442, 397.50174, 18.793955, NULL, 0), +(@PATH, 33, 1908.8906, 396.81598, 18.840582, NULL, 0), +(@PATH, 34, 1910.875, 396.54688, 18.903534, NULL, 0), +(@PATH, 35, 1906.1442, 397.50174, 18.793955, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Seafeather Albatross +SET @MOVERGUID := @CGUID+11; +SET @ENTRY := 227668; +SET @PATHOFFSET := 0; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 8.5454, 'Seafeather Albatross - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1931.485, 59.334667, 24.162596, NULL, 0), +(@PATH, 1, 1937.9882, 69.06737, 24.162596, NULL, 0), +(@PATH, 2, 1947.721, 75.57055, 24.162596, NULL, 0), +(@PATH, 3, 1959.2014, 77.85417, 24.162596, NULL, 0), +(@PATH, 4, 1970.6819, 75.57056, 24.162596, NULL, 0), +(@PATH, 5, 1980.4147, 69.067375, 24.162596, NULL, 0), +(@PATH, 6, 1986.9178, 59.33467, 24.162596, NULL, 0), +(@PATH, 7, 1989.2014, 47.854168, 24.162596, NULL, 0), +(@PATH, 8, 1986.9178, 36.373665, 24.162596, NULL, 0), +(@PATH, 9, 1980.4147, 26.640965, 24.162596, NULL, 0), +(@PATH, 10, 1970.6819, 20.137783, 24.162596, NULL, 0), +(@PATH, 11, 1959.2014, 17.854168, 24.162596, NULL, 0), +(@PATH, 12, 1947.721, 20.137783, 24.162596, NULL, 0), +(@PATH, 13, 1937.9882, 26.640965, 24.162596, NULL, 0), +(@PATH, 14, 1931.485, 36.373665, 24.162596, NULL, 0), +(@PATH, 15, 1929.2014, 47.854164, 24.162596, NULL, 0), +(@PATH, 16, 1931.485, 59.334667, 24.162596, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Seafeather Albatross +SET @MOVERGUID := @CGUID+12; +SET @ENTRY := 227668; +SET @PATHOFFSET := 1; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 8.5454, 'Seafeather Albatross - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 2074.9644, 108.73744, 21.391014, NULL, 0), +(@PATH, 1, 2081.4675, 118.47014, 21.391014, NULL, 0), +(@PATH, 2, 2091.2002, 124.97333, 21.391014, NULL, 0), +(@PATH, 3, 2102.6807, 127.25694, 21.391014, NULL, 0), +(@PATH, 4, 2114.1611, 124.97333, 21.391014, NULL, 0), +(@PATH, 5, 2123.8938, 118.470146, 21.391014, NULL, 0), +(@PATH, 6, 2130.397, 108.73745, 21.391014, NULL, 0), +(@PATH, 7, 2132.6807, 97.25694, 21.391014, NULL, 0), +(@PATH, 8, 2130.397, 85.77644, 21.391014, NULL, 0), +(@PATH, 9, 2123.8938, 76.04374, 21.391014, NULL, 0), +(@PATH, 10, 2114.1611, 69.54056, 21.391014, NULL, 0), +(@PATH, 11, 2102.6807, 67.25694, 21.391014, NULL, 0), +(@PATH, 12, 2091.2002, 69.54056, 21.391014, NULL, 0), +(@PATH, 13, 2081.4675, 76.04374, 21.391014, NULL, 0), +(@PATH, 14, 2074.9644, 85.776436, 21.391014, NULL, 0), +(@PATH, 15, 2072.6807, 97.256935, 21.391014, NULL, 0), +(@PATH, 16, 2074.9644, 108.73744, 21.391014, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Seafeather Albatross +SET @MOVERGUID := @CGUID+203; +SET @ENTRY := 227668; +SET @PATHOFFSET := 2; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 8.5475, 'Seafeather Albatross - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1628.3756, 506.24786, 59.22516, NULL, 0), +(@PATH, 1, 1634.8788, 515.9806, 59.22516, NULL, 0), +(@PATH, 2, 1644.6116, 522.48376, 59.22516, NULL, 0), +(@PATH, 3, 1656.092, 524.76733, 59.22516, NULL, 0), +(@PATH, 4, 1667.5725, 522.48376, 59.22516, NULL, 0), +(@PATH, 5, 1677.3053, 515.9806, 59.22516, NULL, 0), +(@PATH, 6, 1683.8085, 506.24786, 59.22516, NULL, 0), +(@PATH, 7, 1686.092, 494.76736, 59.22516, NULL, 0), +(@PATH, 8, 1683.8085, 483.28687, 59.22516, NULL, 0), +(@PATH, 9, 1677.3053, 473.55417, 59.22516, NULL, 0), +(@PATH, 10, 1667.5725, 467.05096, 59.22516, NULL, 0), +(@PATH, 11, 1656.092, 464.76736, 59.22516, NULL, 0), +(@PATH, 12, 1644.6116, 467.05096, 59.22516, NULL, 0), +(@PATH, 13, 1634.8788, 473.55417, 59.22516, NULL, 0), +(@PATH, 14, 1628.3756, 483.28687, 59.22516, NULL, 0), +(@PATH, 15, 1626.092, 494.76736, 60.212273, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Seafeather Albatross +SET @MOVERGUID := @CGUID+199; +SET @ENTRY := 227668; +SET @PATHOFFSET := 3; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 8.5454, 'Seafeather Albatross - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1552.5718, 472.31903, 25.14907, NULL, 0), +(@PATH, 1, 1559.075, 482.05173, 25.14907, NULL, 0), +(@PATH, 2, 1568.8077, 488.5549, 25.14907, NULL, 0), +(@PATH, 3, 1580.2882, 490.83853, 25.14907, NULL, 0), +(@PATH, 4, 1591.7687, 488.55493, 25.14907, NULL, 0), +(@PATH, 5, 1601.5015, 482.05173, 25.14907, NULL, 0), +(@PATH, 6, 1608.0046, 472.31903, 25.14907, NULL, 0), +(@PATH, 7, 1610.2882, 460.83853, 25.14907, NULL, 0), +(@PATH, 8, 1608.0046, 449.35803, 25.14907, NULL, 0), +(@PATH, 9, 1601.5015, 439.62534, 25.14907, NULL, 0), +(@PATH, 10, 1591.7687, 433.12213, 25.14907, NULL, 0), +(@PATH, 11, 1580.2882, 430.83853, 25.14907, NULL, 0), +(@PATH, 12, 1568.8077, 433.12213, 25.14907, NULL, 0), +(@PATH, 13, 1559.075, 439.62534, 25.14907, NULL, 0), +(@PATH, 14, 1552.5718, 449.35803, 25.14907, NULL, 0), +(@PATH, 15, 1550.2882, 460.83853, 25.14907, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Seafeather Albatross +SET @MOVERGUID := @CGUID+194; +SET @ENTRY := 227668; +SET @PATHOFFSET := 4; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 8.5454, 'Seafeather Albatross - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1601.1742, 555.9492, 40.032784, NULL, 0), +(@PATH, 1, 1607.6774, 565.68195, 40.032784, NULL, 0), +(@PATH, 2, 1617.4102, 572.1851, 40.032784, NULL, 0), +(@PATH, 3, 1628.8906, 574.46875, 40.032784, NULL, 0), +(@PATH, 4, 1640.3711, 572.1851, 40.032784, NULL, 0), +(@PATH, 5, 1650.1039, 565.68195, 40.032784, NULL, 0), +(@PATH, 6, 1656.607, 555.9493, 40.032784, NULL, 0), +(@PATH, 7, 1658.8906, 544.46875, 40.032784, NULL, 0), +(@PATH, 8, 1656.607, 532.9882, 40.032784, NULL, 0), +(@PATH, 9, 1650.1039, 523.25555, 40.032784, NULL, 0), +(@PATH, 10, 1640.3711, 516.7524, 40.032784, NULL, 0), +(@PATH, 11, 1628.8906, 514.46875, 40.032784, NULL, 0), +(@PATH, 12, 1617.4102, 516.7524, 40.032784, NULL, 0), +(@PATH, 13, 1607.6774, 523.25555, 40.032784, NULL, 0), +(@PATH, 14, 1601.1742, 532.9882, 40.032784, NULL, 0), +(@PATH, 15, 1598.8906, 544.46875, 40.032784, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Seafeather Albatross +SET @MOVERGUID := @CGUID+207; +SET @ENTRY := 227668; +SET @PATHOFFSET := 5; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 8.5454, 'Seafeather Albatross - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1743.0249, 478.71835, 28.568699, NULL, 0), +(@PATH, 1, 1749.5281, 488.45105, 28.568699, NULL, 0), +(@PATH, 2, 1759.2609, 494.95422, 28.568699, NULL, 0), +(@PATH, 3, 1770.7413, 497.23785, 28.568699, NULL, 0), +(@PATH, 4, 1782.2218, 494.95425, 28.568699, NULL, 0), +(@PATH, 5, 1791.9546, 488.45105, 28.568699, NULL, 0), +(@PATH, 6, 1798.4578, 478.71835, 28.568699, NULL, 0), +(@PATH, 7, 1800.7413, 467.23785, 28.568699, NULL, 0), +(@PATH, 8, 1798.4578, 455.75735, 28.568699, NULL, 0), +(@PATH, 9, 1791.9546, 446.02466, 28.568699, NULL, 0), +(@PATH, 10, 1782.2218, 439.52148, 28.568699, NULL, 0), +(@PATH, 11, 1770.7413, 437.23785, 28.568699, NULL, 0), +(@PATH, 12, 1759.2609, 439.52148, 28.568699, NULL, 0), +(@PATH, 13, 1749.5281, 446.02466, 28.568699, NULL, 0), +(@PATH, 14, 1743.0249, 455.75735, 28.568699, NULL, 0), +(@PATH, 15, 1740.7413, 467.23785, 28.568699, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Seafeather Albatross +SET @MOVERGUID := @CGUID+209; +SET @ENTRY := 227668; +SET @PATHOFFSET := 6; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 8.5477, 'Seafeather Albatross - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1734.6482, 411.76175, 35.394314, NULL, 0), +(@PATH, 1, 1741.1514, 421.49445, 35.394314, NULL, 0), +(@PATH, 2, 1750.8842, 427.99762, 35.394314, NULL, 0), +(@PATH, 3, 1762.3646, 430.28125, 35.394314, NULL, 0), +(@PATH, 4, 1773.8451, 427.99765, 35.394314, NULL, 0), +(@PATH, 5, 1783.5779, 421.49445, 35.394314, NULL, 0), +(@PATH, 6, 1790.081, 411.76175, 35.394314, NULL, 0), +(@PATH, 7, 1792.3646, 400.28125, 35.394314, NULL, 0), +(@PATH, 8, 1790.081, 388.80075, 35.394314, NULL, 0), +(@PATH, 9, 1783.5779, 379.06805, 35.394314, NULL, 0), +(@PATH, 10, 1773.8451, 372.56488, 35.394314, NULL, 0), +(@PATH, 11, 1762.3646, 370.28125, 35.394314, NULL, 0), +(@PATH, 12, 1750.8842, 372.56488, 35.394314, NULL, 0), +(@PATH, 13, 1741.1514, 379.06805, 35.394314, NULL, 0), +(@PATH, 14, 1734.6482, 388.80075, 35.394314, NULL, 0), +(@PATH, 15, 1732.3646, 400.28125, 36.452816, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Stormfeather Falcon +SET @MOVERGUID := @CGUID+52; +SET @ENTRY := 229534; +SET @PATHOFFSET := 0; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 2.8660, 'Stormfeather Falcon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 2312.854, 219.15651, 189.42834, NULL, 0), +(@PATH, 1, 2320.1692, 221.40717, 189.42834, NULL, 0), +(@PATH, 2, 2326.9333, 217.82596, 189.42834, NULL, 0), +(@PATH, 3, 2329.184, 210.5107, 189.42834, NULL, 0), +(@PATH, 4, 2325.6028, 203.74655, 189.42834, NULL, 0), +(@PATH, 5, 2318.2876, 201.49588, 189.42834, NULL, 0), +(@PATH, 6, 2311.5234, 205.0771, 189.42834, NULL, 0), +(@PATH, 7, 2309.2727, 212.39236, 189.42834, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Stormfeather Falcon +SET @MOVERGUID := @CGUID+42; +SET @ENTRY := 229534; +SET @PATHOFFSET := 1; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 2.8655, 'Stormfeather Falcon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 2215.7578, 207.05428, 119.39705, NULL, 0), +(@PATH, 1, 2222.264, 197.59523, 119.39705, NULL, 0), +(@PATH, 2, 2220.1758, 186.30621, 119.39705, NULL, 0), +(@PATH, 3, 2210.7166, 179.80019, 119.39705, NULL, 0), +(@PATH, 4, 2199.4277, 181.88828, 119.39705, NULL, 0), +(@PATH, 5, 2192.9216, 191.34732, 119.39705, NULL, 0), +(@PATH, 6, 2195.0098, 202.63634, 119.39705, NULL, 0), +(@PATH, 7, 2204.4688, 209.14236, 119.39705, NULL, 0), +(@PATH, 8, 2215.7578, 207.05428, 119.39705, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Stormfeather Falcon +SET @MOVERGUID := @CGUID+41; +SET @ENTRY := 229534; +SET @PATHOFFSET := 2; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 2.8661, 'Stormfeather Falcon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 2185.0952, 228.64435, 133.83223, NULL, 0), +(@PATH, 1, 2192.4104, 230.895, 133.83223, NULL, 0), +(@PATH, 2, 2199.1746, 227.3138, 133.83223, NULL, 0), +(@PATH, 3, 2201.4253, 219.99854, 133.83223, NULL, 0), +(@PATH, 4, 2197.844, 213.23439, 133.83223, NULL, 0), +(@PATH, 5, 2190.5288, 210.98372, 133.83223, NULL, 0), +(@PATH, 6, 2183.7646, 214.56494, 133.83223, NULL, 0), +(@PATH, 7, 2181.514, 221.8802, 133.83223, NULL, 0), +(@PATH, 8, 2185.0952, 228.64435, 133.83223, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Stormfeather Falcon +SET @MOVERGUID := @CGUID+58; +SET @ENTRY := 229534; +SET @PATHOFFSET := 3; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 2.8660, 'Stormfeather Falcon - Cyclic'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1960.378, 154.6079, 53.433052, NULL, 0), +(@PATH, 1, 1967.6934, 156.85855, 53.433052, NULL, 0), +(@PATH, 2, 1974.4575, 153.27734, 53.433052, NULL, 0), +(@PATH, 3, 1976.7081, 145.96208, 53.433052, NULL, 0), +(@PATH, 4, 1973.127, 139.19794, 53.433052, NULL, 0), +(@PATH, 5, 1965.8116, 136.94727, 53.433052, NULL, 0), +(@PATH, 6, 1959.0475, 140.52849, 53.433052, NULL, 0), +(@PATH, 7, 1956.7969, 147.84375, 53.433052, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Stormfeather Falcon +SET @MOVERGUID := @CGUID+57; +SET @ENTRY := 229534; +SET @PATHOFFSET := 4; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 2.8655, 'Stormfeather Falcon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1935.4835, 135.78865, 60.79176, NULL, 0), +(@PATH, 1, 1941.9895, 126.329605, 60.79176, NULL, 0), +(@PATH, 2, 1939.9014, 115.04059, 60.79176, NULL, 0), +(@PATH, 3, 1930.4424, 108.53456, 60.79176, NULL, 0), +(@PATH, 4, 1919.1533, 110.62265, 60.79176, NULL, 0), +(@PATH, 5, 1912.6473, 120.081696, 60.79176, NULL, 0), +(@PATH, 6, 1914.7355, 131.37071, 60.79176, NULL, 0), +(@PATH, 7, 1924.1945, 137.87674, 60.79176, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Stormfeather Falcon +SET @MOVERGUID := @CGUID+70; +SET @ENTRY := 229534; +SET @PATHOFFSET := 5; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 2.8660, 'Stormfeather Falcon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1912.3184, 353.34097, 64.74963, NULL, 0), +(@PATH, 1, 1919.0825, 349.75977, 64.74963, NULL, 0), +(@PATH, 2, 1926.3978, 352.01044, 64.74963, NULL, 0), +(@PATH, 3, 1929.979, 358.77457, 64.74963, NULL, 0), +(@PATH, 4, 1927.7284, 366.08984, 64.74963, NULL, 0), +(@PATH, 5, 1920.9642, 369.67105, 64.74963, NULL, 0), +(@PATH, 6, 1913.6489, 367.42038, 64.74963, NULL, 0), +(@PATH, 7, 1910.0677, 360.65625, 64.74963, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Stormfeather Falcon +SET @MOVERGUID := @CGUID+68; +SET @ENTRY := 229534; +SET @PATHOFFSET := 6; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 8.5454, 'Stormfeather Falcon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1851.239, 298.62033, 48.0557, NULL, 0), +(@PATH, 1, 1859.8607, 309.21097, 48.0557, NULL, 0), +(@PATH, 2, 1871.8789, 315.69604, 48.0557, NULL, 0), +(@PATH, 3, 1885.4641, 317.0883, 48.0557, NULL, 0), +(@PATH, 4, 1898.548, 313.17575, 48.0557, NULL, 0), +(@PATH, 5, 1909.1385, 304.55405, 48.0557, NULL, 0), +(@PATH, 6, 1915.6237, 292.53577, 48.0557, NULL, 0), +(@PATH, 7, 1917.0159, 278.9506, 48.0557, NULL, 0), +(@PATH, 8, 1913.1034, 265.86676, 48.0557, NULL, 0), +(@PATH, 9, 1904.4817, 255.27612, 48.0557, NULL, 0), +(@PATH, 10, 1892.4634, 248.79105, 48.0557, NULL, 0), +(@PATH, 11, 1878.8782, 247.3988, 48.0557, NULL, 0), +(@PATH, 12, 1865.7943, 251.31136, 48.0557, NULL, 0), +(@PATH, 13, 1855.2037, 259.93304, 48.0557, NULL, 0), +(@PATH, 14, 1848.7186, 271.95132, 48.0557, NULL, 0), +(@PATH, 15, 1847.3264, 285.5365, 48.0557, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Stormfeather Falcon +SET @MOVERGUID := @CGUID+95; +SET @ENTRY := 229534; +SET @PATHOFFSET := 7; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 2.8660, 'Stormfeather Falcon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1967.0256, 545.6409, 140.46405, NULL, 0), +(@PATH, 1, 1974.341, 547.8916, 140.46405, NULL, 0), +(@PATH, 2, 1981.1051, 544.31036, 140.46405, NULL, 0), +(@PATH, 3, 1983.3557, 536.9951, 140.46405, NULL, 0), +(@PATH, 4, 1979.7745, 530.23096, 140.46405, NULL, 0), +(@PATH, 5, 1972.4592, 527.9803, 140.46405, NULL, 0), +(@PATH, 6, 1965.6951, 531.5615, 140.46405, NULL, 0), +(@PATH, 7, 1963.4445, 538.8768, 140.46405, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Stormfeather Falcon +SET @MOVERGUID := @CGUID+94; +SET @ENTRY := 229534; +SET @PATHOFFSET := 8; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 2.8660, 'Stormfeather Falcon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 2017.5388, 513.1518, 125.90871, NULL, 0), +(@PATH, 1, 2024.303, 509.57056, 125.90871, NULL, 0), +(@PATH, 2, 2031.6183, 511.82123, 125.90871, NULL, 0), +(@PATH, 3, 2035.1995, 518.5854, 125.90871, NULL, 0), +(@PATH, 4, 2032.9489, 525.90063, 125.90871, NULL, 0), +(@PATH, 5, 2026.1847, 529.4819, 125.90871, NULL, 0), +(@PATH, 6, 2018.8694, 527.2312, 125.90871, NULL, 0), +(@PATH, 7, 2015.2882, 520.46704, 125.90871, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Stormfeather Falcon +SET @MOVERGUID := @CGUID+143; +SET @ENTRY := 229534; +SET @PATHOFFSET := 9; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 2.8660, 'Stormfeather Falcon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 2109.227, 556.66, 150.4184, NULL, 0), +(@PATH, 1, 2116.5422, 558.91064, 150.4184, NULL, 0), +(@PATH, 2, 2123.3064, 555.3294, 150.4184, NULL, 0), +(@PATH, 3, 2125.5571, 548.01416, 150.4184, NULL, 0), +(@PATH, 4, 2121.9758, 541.25, 150.4184, NULL, 0), +(@PATH, 5, 2114.6606, 538.9993, 150.4184, NULL, 0), +(@PATH, 6, 2107.8965, 542.58057, 150.4184, NULL, 0), +(@PATH, 7, 2105.6458, 549.8958, 150.4184, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Stormfeather Falcon +SET @MOVERGUID := @CGUID+225; +SET @ENTRY := 229534; +SET @PATHOFFSET := 10; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 2.8655, 'Stormfeather Falcon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1832.02, -6.91969, 97.50832, NULL, 0), +(@PATH, 1, 1838.526, -16.378735, 97.50832, NULL, 0), +(@PATH, 2, 1836.4379, -27.667747, 97.50832, NULL, 0), +(@PATH, 3, 1826.9789, -34.17378, 97.50832, NULL, 0), +(@PATH, 4, 1815.6898, -32.085686, 97.50832, NULL, 0), +(@PATH, 5, 1809.1838, -22.62664, 97.50832, NULL, 0), +(@PATH, 6, 1811.272, -11.337626, 97.50832, NULL, 0), +(@PATH, 7, 1820.731, -4.8315964, 97.50832, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Stormfeather Falcon +SET @MOVERGUID := @CGUID+224; +SET @ENTRY := 229534; +SET @PATHOFFSET := 11; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 2.8655, 'Stormfeather Falcon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1735.6953, 65.22267, 64.1085, NULL, 0), +(@PATH, 1, 1742.2013, 55.763634, 64.1085, NULL, 0), +(@PATH, 2, 1740.1132, 44.474617, 64.1085, NULL, 0), +(@PATH, 3, 1730.6542, 37.968586, 64.1085, NULL, 0), +(@PATH, 4, 1719.3651, 40.05668, 64.1085, NULL, 0), +(@PATH, 5, 1712.8591, 49.515724, 64.1085, NULL, 0), +(@PATH, 6, 1714.9473, 60.80474, 64.1085, NULL, 0), +(@PATH, 7, 1724.4062, 67.31077, 64.1085, NULL, 0), +(@PATH, 8, 1735.6953, 65.22267, 64.1085, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Stormfeather Falcon +SET @MOVERGUID := @CGUID+223; +SET @ENTRY := 229534; +SET @PATHOFFSET := 12; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 2.8655, 'Stormfeather Falcon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1764.0773, 28.682741, 113.28931, NULL, 0), +(@PATH, 1, 1770.5833, 19.223698, 113.28931, NULL, 0), +(@PATH, 2, 1768.4951, 7.9346848, 113.28931, NULL, 0), +(@PATH, 3, 1759.0361, 1.4286518, 113.28931, NULL, 0), +(@PATH, 4, 1747.7471, 3.5167465, 113.28931, NULL, 0), +(@PATH, 5, 1741.2411, 12.97579, 113.28931, NULL, 0), +(@PATH, 6, 1743.3292, 24.264805, 113.28931, NULL, 0), +(@PATH, 7, 1752.7882, 30.770836, 113.28931, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Stormfeather Falcon +SET @MOVERGUID := @CGUID+222; +SET @ENTRY := 229534; +SET @PATHOFFSET := 13; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 2.8655, 'Stormfeather Falcon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1857.4001, 124.50044, 53.28297, NULL, 0), +(@PATH, 1, 1863.9061, 115.041405, 53.28297, NULL, 0), +(@PATH, 2, 1861.818, 103.75239, 53.28297, NULL, 0), +(@PATH, 3, 1852.359, 97.24635, 53.28297, NULL, 0), +(@PATH, 4, 1841.07, 99.33445, 53.28297, NULL, 0), +(@PATH, 5, 1834.564, 108.793495, 53.28297, NULL, 0), +(@PATH, 6, 1836.6521, 120.08251, 53.28297, NULL, 0), +(@PATH, 7, 1846.1111, 126.58854, 53.28297, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Stormfeather Falcon +SET @MOVERGUID := @CGUID+221; +SET @ENTRY := 229534; +SET @PATHOFFSET := 14; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 2.8655, 'Stormfeather Falcon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1810.6051, 113.182755, 58.348022, NULL, 0), +(@PATH, 1, 1817.1111, 103.72371, 58.348022, NULL, 0), +(@PATH, 2, 1815.023, 92.43469, 58.348022, NULL, 0), +(@PATH, 3, 1805.564, 85.928665, 58.348022, NULL, 0), +(@PATH, 4, 1794.2749, 88.016754, 58.348022, NULL, 0), +(@PATH, 5, 1787.7689, 97.4758, 58.348022, NULL, 0), +(@PATH, 6, 1789.857, 108.76482, 58.348022, NULL, 0), +(@PATH, 7, 1799.316, 115.27084, 58.348022, NULL, 0), +(@PATH, 8, 1810.6051, 113.182755, 58.348022, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Cliffreach Pridetalon +SET @MOVERGUID := @CGUID+49; +SET @ENTRY := 229522; +SET @PATHOFFSET := 0; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 11.4706, 'Cliffreach Pridetalon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 2273.4338, 292.5019, 222.70122, NULL, 0), +(@PATH, 1, 2284.1042, 276.61926, 222.70122, NULL, 0), +(@PATH, 2, 2280.4187, 257.84338, 222.70122, NULL, 0), +(@PATH, 3, 2264.536, 247.17297, 222.70122, NULL, 0), +(@PATH, 4, 2245.7603, 250.85857, 222.70122, NULL, 0), +(@PATH, 5, 2235.0896, 266.7412, 222.70122, NULL, 0), +(@PATH, 6, 2238.7754, 285.51706, 222.70122, NULL, 0), +(@PATH, 7, 2254.658, 296.1875, 222.70122, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `AnimTier`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 3, 1); + +-- Path for Cliffreach Pridetalon +SET @MOVERGUID := @CGUID+48; +SET @ENTRY := 229522; +SET @PATHOFFSET := 1; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 11.4706, 'Cliffreach Pridetalon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 2325.2524, 269.5246, 208.61002, NULL, 0), +(@PATH, 1, 2343.3164, 275.83414, 208.61002, NULL, 0), +(@PATH, 2, 2360.551, 267.52252, 208.61002, NULL, 0), +(@PATH, 3, 2366.8606, 249.45859, 208.61002, NULL, 0), +(@PATH, 4, 2358.549, 232.22392, 208.61002, NULL, 0), +(@PATH, 5, 2340.485, 225.91438, 208.61002, NULL, 0), +(@PATH, 6, 2323.2505, 234.226, 208.61002, NULL, 0), +(@PATH, 7, 2316.941, 252.28993, 208.61002, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `AnimTier`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 3, 1); + +-- Path for Cliffreach Pridetalon +SET @MOVERGUID := @CGUID+55; +SET @ENTRY := 229522; +SET @PATHOFFSET := 2; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 11.4713, 'Cliffreach Pridetalon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 2322.5051, 362.83807, 189.34691, NULL, 0), +(@PATH, 1, 2336.9563, 367.8857, 189.34691, NULL, 0), +(@PATH, 2, 2350.7441, 361.23645, 189.34691, NULL, 0), +(@PATH, 3, 2355.7917, 346.78528, 189.34691, NULL, 0), +(@PATH, 4, 2349.1426, 332.99756, 189.34691, NULL, 0), +(@PATH, 5, 2334.6914, 327.94992, 189.34691, NULL, 0), +(@PATH, 6, 2320.9036, 334.5992, 189.34691, NULL, 0), +(@PATH, 7, 2315.856, 349.05035, 189.34691, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `AnimTier`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 3, 1); + +-- Path for Cliffreach Pridetalon +SET @MOVERGUID := @CGUID+54; +SET @ENTRY := 229522; +SET @PATHOFFSET := 3; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 11.4706, 'Cliffreach Pridetalon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 2302.7217, 315.59866, 201.75383, NULL, 0), +(@PATH, 1, 2301.7207, 334.70663, 201.75383, NULL, 0), +(@PATH, 2, 2314.5242, 348.92584, 201.75383, NULL, 0), +(@PATH, 3, 2333.632, 349.9269, 201.75383, NULL, 0), +(@PATH, 4, 2347.8513, 337.12338, 201.75383, NULL, 0), +(@PATH, 5, 2348.8523, 318.0154, 201.75383, NULL, 0), +(@PATH, 6, 2336.0488, 303.7962, 201.75383, NULL, 0), +(@PATH, 7, 2316.941, 302.79514, 201.75383, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `AnimTier`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 3, 1); + +-- Path for Cliffreach Pridetalon +SET @MOVERGUID := @CGUID+112; +SET @ENTRY := 229522; +SET @PATHOFFSET := 4; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 11.4623, 'Cliffreach Pridetalon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1806.0852, 491.57394, 84.85687, NULL, 0), +(@PATH, 1, 1817.1077, 488.3631, 84.85687, NULL, 0), +(@PATH, 2, 1822.6312, 478.2987, 84.85687, NULL, 0), +(@PATH, 3, 1819.4204, 467.27637, 84.85687, NULL, 0), +(@PATH, 4, 1809.356, 461.75278, 84.85687, NULL, 0), +(@PATH, 5, 1798.3336, 464.9636, 84.85687, NULL, 0), +(@PATH, 6, 1792.81, 475.02798, 84.85687, NULL, 0), +(@PATH, 7, 1796.0209, 486.05035, 84.85687, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Cliffreach Pridetalon +SET @MOVERGUID := @CGUID+105; +SET @ENTRY := 229522; +SET @PATHOFFSET := 5; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 10.1918, 'Cliffreach Pridetalon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1850.0095, 404.5439, 80.74973, NULL, 0), +(@PATH, 1, 1860.8479, 408.32965, 80.74973, NULL, 0), +(@PATH, 2, 1871.1887, 403.34268, 80.74973, NULL, 0), +(@PATH, 3, 1874.9745, 392.50433, 80.74973, NULL, 0), +(@PATH, 4, 1869.9874, 382.1635, 80.74973, NULL, 0), +(@PATH, 5, 1859.1492, 378.37778, 80.74973, NULL, 0), +(@PATH, 6, 1848.8083, 383.36475, 80.74973, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Cliffreach Pridetalon +SET @MOVERGUID := @CGUID+140; +SET @ENTRY := 229522; +SET @PATHOFFSET := 6; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 11.4706, 'Cliffreach Pridetalon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1892.9718, 718.4091, 127.55022, NULL, 0), +(@PATH, 1, 1911.3424, 713.05774, 127.55022, NULL, 0), +(@PATH, 2, 1920.5485, 696.28375, 127.55022, NULL, 0), +(@PATH, 3, 1915.197, 677.91315, 127.55022, NULL, 0), +(@PATH, 4, 1898.4231, 668.70715, 127.55022, NULL, 0), +(@PATH, 5, 1880.0525, 674.05853, 127.55022, NULL, 0), +(@PATH, 6, 1870.8464, 690.8325, 127.55022, NULL, 0), +(@PATH, 7, 1876.1979, 709.2031, 127.55022, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Cliffreach Pridetalon +SET @MOVERGUID := @CGUID+128; +SET @ENTRY := 229522; +SET @PATHOFFSET := 7; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 11.4623, 'Cliffreach Pridetalon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1791.1311, 667.78876, 82.586655, NULL, 0), +(@PATH, 1, 1801.9695, 671.57446, 82.586655, NULL, 0), +(@PATH, 2, 1812.3103, 666.5875, 82.586655, NULL, 0), +(@PATH, 3, 1816.0961, 655.74915, 82.586655, NULL, 0), +(@PATH, 4, 1811.109, 645.4083, 82.586655, NULL, 0), +(@PATH, 5, 1800.2708, 641.6226, 82.586655, NULL, 0), +(@PATH, 6, 1789.9299, 646.60956, 82.586655, NULL, 0), +(@PATH, 7, 1786.1442, 657.44794, 82.586655, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Cliffreach Pridetalon +SET @MOVERGUID := @CGUID+129; +SET @ENTRY := 229522; +SET @PATHOFFSET := 8; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 11.4623, 'Cliffreach Pridetalon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1723.9869, 673.2974, 30.944296, NULL, 0), +(@PATH, 1, 1734.8253, 677.0831, 30.944296, NULL, 0), +(@PATH, 2, 1745.1661, 672.0962, 30.944296, NULL, 0), +(@PATH, 3, 1748.9519, 661.2578, 30.944296, NULL, 0), +(@PATH, 4, 1743.9648, 650.917, 30.944296, NULL, 0), +(@PATH, 5, 1733.1266, 647.1313, 30.944296, NULL, 0), +(@PATH, 6, 1722.7858, 652.1182, 30.944296, NULL, 0), +(@PATH, 7, 1719, 662.9566, 30.944296, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Cliffreach Pridetalon +SET @MOVERGUID := @CGUID+51; +SET @ENTRY := 233254; +SET @PATHOFFSET := 0; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 10.6854, 'Cliffreach Pridetalon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 2147.3547, 350.1086, 177.29031, NULL, 0), +(@PATH, 1, 2156.7466, 362.57373, 177.29031, NULL, 0), +(@PATH, 2, 2170.1936, 370.49588, 177.29031, NULL, 0), +(@PATH, 3, 2185.649, 372.669, 177.29031, NULL, 0), +(@PATH, 4, 2200.7593, 368.76227, 177.29031, NULL, 0), +(@PATH, 5, 2213.2244, 359.37042, 177.29031, NULL, 0), +(@PATH, 6, 2221.1465, 345.92328, 177.29031, NULL, 0), +(@PATH, 7, 2223.3196, 330.4681, 177.29031, NULL, 0), +(@PATH, 8, 2219.4128, 315.35776, 177.29031, NULL, 0), +(@PATH, 9, 2210.021, 302.89264, 177.29031, NULL, 0), +(@PATH, 10, 2196.574, 294.9705, 177.29031, NULL, 0), +(@PATH, 11, 2181.1187, 292.79736, 177.29031, NULL, 0), +(@PATH, 12, 2166.0083, 296.70413, 177.29031, NULL, 0), +(@PATH, 13, 2153.5432, 306.09595, 177.29031, NULL, 0), +(@PATH, 14, 2145.621, 319.5431, 177.29031, NULL, 0), +(@PATH, 15, 2143.448, 334.99826, 177.29031, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `AnimTier`, `SheathState`, `visibilityDistanceType`) VALUES +(@MOVERGUID, @PATH, 3, 1, 3); + +-- Path for Cliffreach Pridetalon +SET @MOVERGUID := @CGUID+47; +SET @ENTRY := 233254; +SET @PATHOFFSET := 1; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 11.4706, 'Cliffreach Pridetalon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 2229.494, 264.51593, 208.61002, NULL, 0), +(@PATH, 1, 2247.5579, 270.82547, 208.61002, NULL, 0), +(@PATH, 2, 2264.7925, 262.51385, 208.61002, NULL, 0), +(@PATH, 3, 2271.102, 244.4499, 208.61002, NULL, 0), +(@PATH, 4, 2262.7905, 227.21524, 208.61002, NULL, 0), +(@PATH, 5, 2244.7266, 220.9057, 208.61002, NULL, 0), +(@PATH, 6, 2227.492, 229.21732, 208.61002, NULL, 0), +(@PATH, 7, 2221.1824, 247.28125, 208.61002, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `AnimTier`, `SheathState`, `visibilityDistanceType`) VALUES +(@MOVERGUID, @PATH, 3, 1, 3); + +-- Path for Cliffreach Pridetalon +SET @MOVERGUID := @CGUID+107; +SET @ENTRY := 233254; +SET @PATHOFFSET := 2; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 10.6831, 'Cliffreach Pridetalon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1923.7443, 489.7824, 125.09721, NULL, 0), +(@PATH, 1, 1930.7881, 499.13126, 125.09721, NULL, 0), +(@PATH, 2, 1940.8735, 505.07288, 125.09721, NULL, 0), +(@PATH, 3, 1952.4648, 506.7027, 125.09721, NULL, 0), +(@PATH, 4, 1963.7976, 503.77264, 125.09721, NULL, 0), +(@PATH, 5, 1973.1465, 496.72876, 125.09721, NULL, 0), +(@PATH, 6, 1979.0881, 486.64343, 125.09721, NULL, 0), +(@PATH, 7, 1980.7179, 475.05203, 125.09721, NULL, 0), +(@PATH, 8, 1977.7878, 463.71927, 125.09721, NULL, 0), +(@PATH, 9, 1970.744, 454.37042, 125.09721, NULL, 0), +(@PATH, 10, 1960.6587, 448.42883, 125.09721, NULL, 0), +(@PATH, 11, 1949.0673, 446.79898, 125.09721, NULL, 0), +(@PATH, 12, 1937.7345, 449.72903, 125.09721, NULL, 0), +(@PATH, 13, 1928.3856, 456.77292, 125.09721, NULL, 0), +(@PATH, 14, 1922.4441, 466.85828, 125.09721, NULL, 0), +(@PATH, 15, 1920.8142, 478.44965, 125.09721, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `AnimTier`, `SheathState`, `visibilityDistanceType`) VALUES +(@MOVERGUID, @PATH, 3, 1, 3); + +-- Path for Cliffreach Pridetalon +SET @MOVERGUID := @CGUID+104; +SET @ENTRY := 233254; +SET @PATHOFFSET := 3; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 10.6854, 'Cliffreach Pridetalon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1863.044, 463.87598, 157.96613, NULL, 0), +(@PATH, 1, 1872.4358, 476.3411, 157.96613, NULL, 0), +(@PATH, 2, 1885.8829, 484.26324, 157.96613, NULL, 0), +(@PATH, 3, 1901.3381, 486.43637, 157.96613, NULL, 0), +(@PATH, 4, 1916.4485, 482.52963, 157.96613, NULL, 0), +(@PATH, 5, 1928.9136, 473.1378, 157.96613, NULL, 0), +(@PATH, 6, 1936.8357, 459.69067, 157.96613, NULL, 0), +(@PATH, 7, 1939.0088, 444.23547, 157.96613, NULL, 0), +(@PATH, 8, 1935.102, 429.12512, 157.96613, NULL, 0), +(@PATH, 9, 1925.7102, 416.66, 157.96613, NULL, 0), +(@PATH, 10, 1912.2632, 408.73785, 157.96613, NULL, 0), +(@PATH, 11, 1896.808, 406.56473, 157.96613, NULL, 0), +(@PATH, 12, 1881.6976, 410.4715, 157.96613, NULL, 0), +(@PATH, 13, 1869.2324, 419.8633, 157.96613, NULL, 0), +(@PATH, 14, 1861.3103, 433.31046, 157.96613, NULL, 0), +(@PATH, 15, 1859.1372, 448.76562, 157.96613, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `AnimTier`, `SheathState`, `visibilityDistanceType`) VALUES +(@MOVERGUID, @PATH, 3, 1, 3); + +-- Path for Cliffreach Pridetalon +SET @MOVERGUID := @CGUID+110; +SET @ENTRY := 233254; +SET @PATHOFFSET := 4; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 10.6854, 'Cliffreach Pridetalon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1786.6984, 545.744, 109.52408, NULL, 0), +(@PATH, 1, 1796.0902, 558.2091, 109.52408, NULL, 0), +(@PATH, 2, 1809.5374, 566.1313, 109.52408, NULL, 0), +(@PATH, 3, 1824.9926, 568.3044, 109.52408, NULL, 0), +(@PATH, 4, 1840.1029, 564.39764, 109.52408, NULL, 0), +(@PATH, 5, 1852.568, 555.0058, 109.52408, NULL, 0), +(@PATH, 6, 1860.4901, 541.5587, 109.52408, NULL, 0), +(@PATH, 7, 1862.6632, 526.1035, 109.52408, NULL, 0), +(@PATH, 8, 1858.7565, 510.99316, 109.52408, NULL, 0), +(@PATH, 9, 1849.3646, 498.52805, 109.52408, NULL, 0), +(@PATH, 10, 1835.9176, 490.6059, 109.52408, NULL, 0), +(@PATH, 11, 1820.4624, 488.43277, 109.52408, NULL, 0), +(@PATH, 12, 1805.352, 492.33954, 109.52408, NULL, 0), +(@PATH, 13, 1792.8868, 501.73135, 109.52408, NULL, 0), +(@PATH, 14, 1784.9647, 515.17847, 109.52408, NULL, 0), +(@PATH, 15, 1782.7916, 530.63367, 109.52408, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `AnimTier`, `SheathState`, `visibilityDistanceType`) VALUES +(@MOVERGUID, @PATH, 3, 1, 3); + +-- Path for Cliffreach Pridetalon +SET @MOVERGUID := @CGUID+139; +SET @ENTRY := 233254; +SET @PATHOFFSET := 5; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 10.6854, 'Cliffreach Pridetalon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1834.3043, 661.4871, 170.45158, NULL, 0), +(@PATH, 1, 1843.6962, 673.9522, 170.45158, NULL, 0), +(@PATH, 2, 1857.1433, 681.8744, 170.45158, NULL, 0), +(@PATH, 3, 1872.5985, 684.0475, 170.45158, NULL, 0), +(@PATH, 4, 1887.7089, 680.14075, 170.45158, NULL, 0), +(@PATH, 5, 1900.174, 670.7489, 170.45158, NULL, 0), +(@PATH, 6, 1908.0961, 657.3018, 170.45158, NULL, 0), +(@PATH, 7, 1910.2692, 641.8466, 170.45158, NULL, 0), +(@PATH, 8, 1906.3624, 626.73627, 170.45158, NULL, 0), +(@PATH, 9, 1896.9706, 614.2712, 170.45158, NULL, 0), +(@PATH, 10, 1883.5236, 606.349, 170.45158, NULL, 0), +(@PATH, 11, 1868.0684, 604.1759, 170.45158, NULL, 0), +(@PATH, 12, 1852.958, 608.08264, 170.45158, NULL, 0), +(@PATH, 13, 1840.4928, 617.4745, 170.45158, NULL, 0), +(@PATH, 14, 1832.5707, 630.9216, 170.45158, NULL, 0), +(@PATH, 15, 1830.3976, 646.3768, 170.45158, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `AnimTier`, `SheathState`, `visibilityDistanceType`) VALUES +(@MOVERGUID, @PATH, 3, 1, 3); + +-- Path for Cliffreach Pridetalon +SET @MOVERGUID := @CGUID+141; +SET @ENTRY := 233254; +SET @PATHOFFSET := 6; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 10.6854, 'Cliffreach Pridetalon - Cyclic'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1968.8772, 706.2041, 298.28662, NULL, 0), +(@PATH, 1, 1978.269, 718.6692, 298.28662, NULL, 0), +(@PATH, 2, 1991.7162, 726.5914, 298.28662, NULL, 0), +(@PATH, 3, 2007.1714, 728.76447, 298.28662, NULL, 0), +(@PATH, 4, 2022.2817, 724.8577, 298.28662, NULL, 0), +(@PATH, 5, 2034.7468, 715.4659, 298.28662, NULL, 0), +(@PATH, 6, 2042.669, 702.0188, 298.28662, NULL, 0), +(@PATH, 7, 2044.842, 686.5636, 298.28662, NULL, 0), +(@PATH, 8, 2040.9353, 671.45325, 298.28662, NULL, 0), +(@PATH, 9, 2031.5435, 658.98816, 298.28662, NULL, 0), +(@PATH, 10, 2018.0964, 651.066, 298.28662, NULL, 0), +(@PATH, 11, 2002.6412, 648.8929, 298.28662, NULL, 0), +(@PATH, 12, 1987.5309, 652.7996, 298.28662, NULL, 0), +(@PATH, 13, 1975.0657, 662.19147, 298.28662, NULL, 0), +(@PATH, 14, 1967.1436, 675.63855, 298.28662, NULL, 0), +(@PATH, 15, 1964.9705, 691.09375, 298.28662, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `AnimTier`, `SheathState`, `visibilityDistanceType`) VALUES +(@MOVERGUID, @PATH, 3, 1, 3); + +-- Path for Cliffreach Pridetalon +SET @MOVERGUID := @CGUID+145; +SET @ENTRY := 233254; +SET @PATHOFFSET := 7; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 10.6854, 'Cliffreach Pridetalon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 2079.8513, 529.1642, 168.75128, NULL, 0), +(@PATH, 1, 2089.2432, 541.6293, 168.75128, NULL, 0), +(@PATH, 2, 2102.6902, 549.55145, 168.75128, NULL, 0), +(@PATH, 3, 2118.1455, 551.72455, 168.75128, NULL, 0), +(@PATH, 4, 2133.2559, 547.8178, 168.75128, NULL, 0), +(@PATH, 5, 2145.721, 538.42596, 168.75128, NULL, 0), +(@PATH, 6, 2153.643, 524.9789, 168.75128, NULL, 0), +(@PATH, 7, 2155.8162, 509.52368, 168.75128, NULL, 0), +(@PATH, 8, 2151.9094, 494.41333, 168.75128, NULL, 0), +(@PATH, 9, 2142.5176, 481.9482, 168.75128, NULL, 0), +(@PATH, 10, 2129.0706, 474.02606, 168.75128, NULL, 0), +(@PATH, 11, 2113.6152, 471.85294, 168.75128, NULL, 0), +(@PATH, 12, 2098.505, 475.7597, 168.75128, NULL, 0), +(@PATH, 13, 2086.0398, 485.15152, 168.75128, NULL, 0), +(@PATH, 14, 2078.1177, 498.59866, 168.75128, NULL, 0), +(@PATH, 15, 2075.9446, 514.05383, 168.75128, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `AnimTier`, `SheathState`, `visibilityDistanceType`) VALUES +(@MOVERGUID, @PATH, 3, 1, 3); + +-- Path for Cliffreach Pridetalon +SET @MOVERGUID := @CGUID+201; +SET @ENTRY := 233254; +SET @PATHOFFSET := 8; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 10.6854, 'Cliffreach Pridetalon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1631.8009, 545.744, 53.804577, NULL, 0), +(@PATH, 1, 1641.1927, 558.2091, 53.804577, NULL, 0), +(@PATH, 2, 1654.6399, 566.1313, 53.804577, NULL, 0), +(@PATH, 3, 1670.0951, 568.3044, 53.804577, NULL, 0), +(@PATH, 4, 1685.2054, 564.39764, 53.804577, NULL, 0), +(@PATH, 5, 1697.6705, 555.0058, 53.804577, NULL, 0), +(@PATH, 6, 1705.5927, 541.5587, 53.804577, NULL, 0), +(@PATH, 7, 1707.7657, 526.1035, 53.804577, NULL, 0), +(@PATH, 8, 1703.859, 510.99316, 53.804577, NULL, 0), +(@PATH, 9, 1694.4672, 498.52805, 53.804577, NULL, 0), +(@PATH, 10, 1681.0201, 490.6059, 53.804577, NULL, 0), +(@PATH, 11, 1665.565, 488.43277, 53.804577, NULL, 0), +(@PATH, 12, 1650.4546, 492.33954, 53.804577, NULL, 0), +(@PATH, 13, 1637.9894, 501.73135, 53.804577, NULL, 0), +(@PATH, 14, 1630.0673, 515.17847, 53.804577, NULL, 0), +(@PATH, 15, 1627.8942, 530.63367, 53.804577, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `AnimTier`, `SheathState`, `visibilityDistanceType`) VALUES +(@MOVERGUID, @PATH, 3, 1, 3); + +-- Path for Cowardly Cliffreach Cub +SET @MOVERGUID := @CGUID+111; +SET @ENTRY := 231589; +SET @PATHOFFSET := 0; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 6.8854, 'Cowardly Cliffreach Cub - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1860.5485, 403.57303, 75.974915, NULL, 0), +(@PATH, 1, 1862.0486, 403.87766, 76.075134, NULL, 0), +(@PATH, 2, 1863.3247, 403.03235, 75.9738, NULL, 0), +(@PATH, 3, 1863.6294, 401.53223, 75.844604, NULL, 0), +(@PATH, 4, 1862.784, 400.25607, 75.66192, NULL, 0), +(@PATH, 5, 1861.2839, 399.95145, 75.58653, NULL, 0), +(@PATH, 6, 1860.0078, 400.79675, 75.55602, NULL, 0), +(@PATH, 7, 1859.7031, 402.29688, 75.728584, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); |