diff options
| -rw-r--r-- | sql/updates/world/master/2025_04_29_02_world.sql | 643 |
1 files changed, 643 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_04_29_02_world.sql b/sql/updates/world/master/2025_04_29_02_world.sql new file mode 100644 index 00000000000..82ec4946436 --- /dev/null +++ b/sql/updates/world/master/2025_04_29_02_world.sql @@ -0,0 +1,643 @@ +SET @CGUID := 7002526; +SET @OGUID := 7000546; + +-- Creature +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+132; +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, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 171.829864501953125, 1632.77783203125, 6.009616851806640625, 2.449326753616333007, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+1, 128514, 1643, 8721, 9026, '0', 0, 0, 0, 0, 105.2447891235351562, 1580.7535400390625, 0.799330830574035644, 3.91103982925415039, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Scuttler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+2, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 158.4340362548828125, 1679.265625, 11.53204154968261718, 3.654170751571655273, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+3, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 150.8368072509765625, 1657.967041015625, 2.857259035110473632, 3.994214296340942382, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+4, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 186.2309112548828125, 1601.8333740234375, 6.262094974517822265, 2.015507936477661132, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+5, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 169.3194427490234375, 1671.43408203125, 11.67384147644042968, 5.863808631896972656, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+6, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 126.3524322509765625, 1623.96875, 2.56670379638671875, 0.171838864684104919, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+7, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 175.1336822509765625, 1626.0208740234375, 6.198480129241943359, 0.761542558670043945, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+8, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 119.7569427490234375, 1655.829833984375, 1.40437173843383789, 5.533108234405517578, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+9, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 169.685760498046875, 1605.0504150390625, 6.084836959838867187, 5.350421905517578125, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+10, 124921, 1643, 8721, 9026, '0', 0, 0, 0, 0, 189.0434112548828125, 1686.6597900390625, 20.6303558349609375, 1.047312021255493164, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Raven (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+11, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 181.6180572509765625, 1577.5677490234375, 6.8313751220703125, 2.249932765960693359, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+12, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 116.1684036254882812, 1600.6805419921875, 1.038174390792846679, 3.77406477928161621, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+13, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 159.9444427490234375, 1586.517333984375, 6.045888423919677734, 1.509089231491088867, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+14, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 151.4756927490234375, 1611.19970703125, 3.078275203704833984, 2.069423675537109375, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+15, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 162.435760498046875, 1564.7222900390625, 5.871370792388916015, 6.281026840209960937, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+16, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 130.545135498046875, 1558.5677490234375, 5.827822685241699218, 4.558137416839599609, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+17, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 64.1024322509765625, 1586.2379150390625, 0.76356595754623413, 0.843534409999847412, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+18, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 130.8246612548828125, 1636.404541015625, 0.996773719787597656, 2.69671940803527832, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+19, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 108.0868072509765625, 1625.5347900390625, 0.957151710987091064, 3.317879438400268554, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+20, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 106.2135391235351562, 1566.1632080078125, 1.560348153114318847, 5.517392635345458984, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+21, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 62.19270706176757812, 1685.5260009765625, 0.177251189947128295, 0.259118139743804931, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+22, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 131.342010498046875, 1589.298583984375, 5.119434356689453125, 1.468174576759338378, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+23, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 119.2621536254882812, 1580.0191650390625, 5.305766105651855468, 2.82434844970703125, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+24, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 77.845489501953125, 1689.1041259765625, 1.22207796573638916, 1.516843914985656738, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+25, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 44.67013931274414062, 1681.404541015625, 1.164537906646728515, 4.776487350463867187, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+26, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 55.69270706176757812, 1667.876708984375, 0.694840192794799804, 3.273921012878417968, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+27, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 115.6788177490234375, 1683.421875, 0.003620311617851257, 3.048931837081909179, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+28, 124921, 1643, 8721, 9026, '0', 0, 0, 0, 0, 169.982635498046875, 1685.46533203125, 18.47027778625488281, 4.68398904800415039, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Raven (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+29, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 63.77777862548828125, 1621.4478759765625, 0.850977838039398193, 6.009560108184814453, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+30, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 73.26909637451171875, 1595.717041015625, 0.780859589576721191, 2.199317455291748046, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+31, 128514, 1643, 8721, 9026, '0', 0, 0, 0, 0, 91.33333587646484375, 1599.1754150390625, 0.751722633838653564, 3.825811147689819335, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Scuttler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+32, 124921, 1643, 8721, 9026, '0', 0, 0, 0, 0, 117.135406494140625, 1625.3333740234375, 6.2913055419921875, 5.615557193756103515, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Raven (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+33, 128514, 1643, 8721, 9026, '0', 0, 0, 0, 0, 102.3975677490234375, 1569.6875, 0.882806241512298583, 4.892214775085449218, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Scuttler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+34, 128514, 1643, 8721, 9026, '0', 0, 0, 0, 0, 96.6875, 1590.392333984375, 0.929117381572723388, 0.803829729557037353, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Scuttler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+35, 124921, 1643, 8721, 9026, '0', 0, 0, 0, 0, 163.2743072509765625, 1580.0867919921875, 6.100682258605957031, 5.263541698455810546, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Raven (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+36, 124921, 1643, 8721, 9026, '0', 0, 0, 0, 0, 186.6840362548828125, 1595.796875, 7.355634212493896484, 2.419909477233886718, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Raven (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+37, 128623, 1643, 8721, 9026, '0', 0, 0, 0, 0, 100.7847213745117187, 1547.7379150390625, 0.548170089721679687, 4.473973274230957031, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 60490), -- Harbor Crab (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+38, 124814, 1643, 8721, 9026, '0', 0, 0, 0, 0, 102.2447891235351562, 1673.6944580078125, 1.167317509651184082, 4.499606132507324218, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hexed Howler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (Auras: 248058 - Possessed) +(@CGUID+39, 128514, 1643, 8721, 9026, '0', 0, 0, 0, 0, 110.7743072509765625, 1560.6163330078125, 1.191732048988342285, 0.805003941059112548, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Scuttler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+40, 124921, 1643, 8721, 9026, '0', 0, 0, 0, 0, 72.9288177490234375, 1621.765625, 0.804356098175048828, 2.49769449234008789, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Raven (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+41, 124921, 1643, 8721, 9026, '0', 0, 0, 0, 0, 195.0590362548828125, 1581.170166015625, 19.91125297546386718, 1.123755335807800292, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Raven (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+42, 128514, 1643, 8721, 9026, '0', 0, 0, 0, 0, 124.1875, 1540.9427490234375, 1.683101773262023925, 4.325760841369628906, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Scuttler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+43, 128514, 1643, 8721, 9026, '0', 0, 0, 0, 0, 109.6684036254882812, 1552.6492919921875, 1.366469860076904296, 5.916128158569335937, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Scuttler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+44, 128514, 1643, 8721, 9026, '0', 0, 0, 0, 0, 114.0625, 1540.1302490234375, 0.293723374605178833, 4.136350154876708984, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Scuttler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+45, 124921, 1643, 8721, 9026, '0', 0, 0, 0, 0, 94.68576812744140625, 1642.939208984375, 17.8756561279296875, 4.547791004180908203, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Raven (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+46, 124921, 1643, 8721, 9026, '0', 0, 0, 0, 0, 29.01215362548828125, 1628.904541015625, 0.620257496833801269, 2.789592981338500976, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Raven (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+47, 124921, 1643, 8721, 9026, '0', 0, 0, 0, 0, 75.27083587646484375, 1681.0867919921875, 3.532975196838378906, 1.210987329483032226, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Raven (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+48, 128514, 1643, 8721, 9026, '0', 0, 0, 0, 0, 61.02257156372070312, 1584.1632080078125, 0.77198868989944458, 2.590063095092773437, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Scuttler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+49, 128526, 1643, 8721, 9026, '0', 0, 0, 0, 0, 230.6840362548828125, 1673.2916259765625, 20.7321624755859375, 2.813037395477294921, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Fire Bunny (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@CGUID+50, 128475, 1643, 8721, 9026, '0', 0, 0, 0, 0, 197.71875, 1634.7725830078125, 8.07929229736328125, 0, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Post Bunny (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@CGUID+51, 128475, 1643, 8721, 9026, '0', 0, 0, 0, 0, 170.123260498046875, 1625.7760009765625, 7.864020824432373046, 0, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Post Bunny (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@CGUID+52, 128475, 1643, 8721, 9026, '0', 0, 0, 0, 0, 189.5885467529296875, 1614.796875, 8.389309883117675781, 6.137429237365722656, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Post Bunny (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@CGUID+53, 128475, 1643, 8721, 9026, '0', 0, 0, 0, 0, 183.3090362548828125, 1609.4322509765625, 8.408242225646972656, 6.137429237365722656, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Post Bunny (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@CGUID+54, 128475, 1643, 8721, 9026, '0', 0, 0, 0, 0, 207.4947967529296875, 1614.8160400390625, 8.081991195678710937, 0, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Post Bunny (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@CGUID+55, 128475, 1643, 8721, 9026, '0', 0, 0, 0, 0, 169.44097900390625, 1610.060791015625, 7.700731277465820312, 0, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Post Bunny (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@CGUID+56, 128475, 1643, 8721, 9026, '0', 0, 0, 0, 0, 140.9270782470703125, 1654.748291015625, 5.030066490173339843, 0, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Post Bunny (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: ) +(@CGUID+57, 128475, 1643, 8721, 9026, '0', 0, 0, 0, 0, 183.9184112548828125, 1620.40625, 7.921984672546386718, 0, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Post Bunny (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: ) +(@CGUID+58, 128475, 1643, 8721, 9026, '0', 0, 0, 0, 0, 164.4947967529296875, 1674.4617919921875, 13.85722541809082031, 0, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Post Bunny (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: ) +(@CGUID+59, 128475, 1643, 8721, 9026, '0', 0, 0, 0, 0, 178.9809112548828125, 1597.611083984375, 7.690691947937011718, 0, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Post Bunny (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@CGUID+60, 129721, 1643, 8721, 9026, '0', 0, 0, 0, 0, 113.1180572509765625, 1669.357666015625, 4.037645816802978515, 3.217993497848510742, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Hanging Pig Bunny (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 258721 - Hanging Pig Fetish) +(@CGUID+61, 128475, 1643, 8721, 9026, '0', 0, 0, 0, 0, 145.3975677490234375, 1611.29345703125, 4.222028255462646484, 6.137429237365722656, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Post Bunny (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: ) +(@CGUID+62, 119314, 1643, 8721, 9026, '0', 0, 0, 0, 0, 73.44097137451171875, 1640.6197509765625, 0.805085599422454833, 0.136517360806465148, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Meat Grinder (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: ) +(@CGUID+63, 128475, 1643, 8721, 9026, '0', 0, 0, 0, 0, 111.9965286254882812, 1590.2847900390625, 3.250648975372314453, 0, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Post Bunny (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: ) +(@CGUID+64, 128475, 1643, 8721, 9026, '0', 0, 0, 0, 0, 73.548614501953125, 1607.9757080078125, 3.125719308853149414, 0, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Post Bunny (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: ) +(@CGUID+65, 128475, 1643, 8721, 9026, '0', 0, 0, 0, 0, 60.87847137451171875, 1628.16845703125, 3.204098224639892578, 0.467966943979263305, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Post Bunny (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: ) +(@CGUID+66, 128475, 1643, 8721, 9026, '0', 0, 0, 0, 0, 59.37847137451171875, 1674.38720703125, 3.238924026489257812, 0, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Post Bunny (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: ) +(@CGUID+67, 128514, 1643, 8721, 9026, '0', 0, 0, 0, 0, 178.329864501953125, 1557.001708984375, 6.314270496368408203, 5.621073722839355468, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Scuttler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+68, 128514, 1643, 8721, 9026, '0', 0, 0, 0, 0, 143.828125, 1542.23095703125, 1.207893848419189453, 5.267284393310546875, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Scuttler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+69, 128623, 1643, 8721, 9026, '0', 0, 0, 0, 0, 131.0677032470703125, 1551.98095703125, 2.391134023666381835, 3.971599817276000976, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 60490), -- Harbor Crab (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+70, 128514, 1643, 8721, 9026, '0', 0, 0, 0, 0, 142.87847900390625, 1540.5694580078125, 1.440230727195739746, 3.411614894866943359, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Scuttler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+71, 128514, 1643, 8721, 9026, '0', 0, 0, 0, 0, 143.06597900390625, 1541.6944580078125, 1.361746788024902343, 2.39304208755493164, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Scuttler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+72, 128514, 1643, 8721, 9026, '0', 0, 0, 0, 0, 171.579864501953125, 1541.7569580078125, 3.153430461883544921, 0.367352187633514404, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Scuttler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+73, 128514, 1643, 8721, 9026, '0', 0, 0, 0, 0, 141.8055572509765625, 1542.328125, 1.341657638549804687, 0, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Scuttler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+74, 128623, 1643, 8721, 9026, '0', 0, 0, 0, 0, 136.8020782470703125, 1531.3160400390625, 0.75403594970703125, 4.786878585815429687, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 60490), -- Harbor Crab (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+75, 128623, 1643, 8721, 9026, '0', 0, 0, 0, 0, 153.736114501953125, 1535.4930419921875, 0.713759899139404296, 4.786878585815429687, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 60490), -- Harbor Crab (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+76, 128514, 1643, 8721, 9026, '0', 0, 0, 0, 0, 199.4010467529296875, 1549.888916015625, 7.063394546508789062, 2.918326377868652343, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Scuttler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+77, 128514, 1643, 8721, 9026, '0', 0, 0, 0, 0, 172.67535400390625, 1540.9288330078125, 3.219966411590576171, 1.971345305442810058, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Scuttler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+78, 128514, 1643, 8721, 9026, '0', 0, 0, 0, 0, 171.3836822509765625, 1542.4132080078125, 3.430037736892700195, 0, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Scuttler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+79, 128514, 1643, 8721, 9026, '0', 0, 0, 0, 0, 171.064239501953125, 1541.3160400390625, 2.858900308609008789, 0.934223294258117675, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Scuttler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+80, 128514, 1643, 8721, 9026, '0', 0, 0, 0, 0, 140.8125, 1544.767333984375, 1.412003278732299804, 0.71370697021484375, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Scuttler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+81, 128514, 1643, 8721, 9026, '0', 0, 0, 0, 0, 140.75, 1541.4791259765625, 1.517935514450073242, 3.537173032760620117, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Scuttler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+82, 128514, 1643, 8721, 9026, '0', 0, 0, 0, 0, 173.2934112548828125, 1542.4166259765625, 3.944512605667114257, 0.846934735774993896, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Scuttler (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+83, 129489, 1643, 8721, 9026, '0', 0, 0, 0, 0, 110.5034713745117187, 1591.74658203125, 0.995067179203033447, 0.873750150203704833, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Kyle Sailford (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 248917 - Cursed, 256582 - Pig Dock Hat, 254963 - Tied Up) +(@CGUID+84, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 114.625, 1591.9774169921875, 1.257663249969482421, 2.280079126358032226, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 254963 - Tied Up) +(@CGUID+85, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 163.75347900390625, 1564.451416015625, 5.882394790649414062, 1.315830588340759277, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune)) +(@CGUID+86, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 109.3715286254882812, 1589.078125, 0.783238828182220458, 5.451233863830566406, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 254963 - Tied Up) +(@CGUID+87, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 75.16146087646484375, 1606.7586669921875, 0.775322318077087402, 0.956760883331298828, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 254963 - Tied Up) +(@CGUID+88, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 179.7203521728515625, 1611.505126953125, 6.096187114715576171, 3.685747385025024414, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@CGUID+89, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 75.032989501953125, 1608.9166259765625, 0.775286793708801269, 4.571907520294189453, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 254963 - Tied Up) +(@CGUID+90, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 72.46701812744140625, 1609.9739990234375, 0.774480223655700683, 0.521180629730224609, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 254963 - Tied Up) +(@CGUID+91, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 178.8611602783203125, 1614.609375, 5.868587493896484375, 4.550825119018554687, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@CGUID+92, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 192.568359375, 1603.30859375, 6.252595901489257812, 4.550008773803710937, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@CGUID+93, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 187.607879638671875, 1609.23388671875, 6.167801856994628906, 1.406303763389587402, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@CGUID+94, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 143.7743072509765625, 1613.4322509765625, 1.419998764991760253, 4.607439517974853515, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 254963 - Tied Up) +(@CGUID+95, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 175.1304779052734375, 1616.7716064453125, 5.948781967163085937, 0.813383042812347412, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@CGUID+96, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 72.37847137451171875, 1607.1129150390625, 0.776208817958831787, 1.874995350837707519, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 254963 - Tied Up) +(@CGUID+97, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 142.626739501953125, 1610.2413330078125, 1.473173141479492187, 5.183466911315917968, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 254963 - Tied Up) +(@CGUID+98, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 170.3125, 1614.5830078125, 6.043115139007568359, 0, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@CGUID+99, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 166.5701751708984375, 1617.1529541015625, 6.010402679443359375, 3.389478921890258789, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@CGUID+100, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 146.8194427490234375, 1613.7847900390625, 2.034143924713134765, 5.589594841003417968, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 254963 - Tied Up) +(@CGUID+101, 124844, 1643, 8721, 9026, '0', 0, 0, 0, 0, 181.7465362548828125, 1618.845458984375, 5.658763885498046875, 5.555399894714355468, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Trevor Hightide (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 248917 - Cursed, 256576 - Pig Goggles, 254963 - Tied Up) +(@CGUID+102, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 189.494415283203125, 1616.5791015625, 6.121455192565917968, 1.088130116462707519, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+103, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 187.7116241455078125, 1620.9652099609375, 6.14021921157836914, 1.481170058250427246, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@CGUID+104, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 203.815521240234375, 1616.3809814453125, 6.425552845001220703, 0.684458553791046142, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@CGUID+105, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 196.5025177001953125, 1627.0899658203125, 6.413990974426269531, 2.306326866149902343, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@CGUID+106, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 204.092926025390625, 1622.030029296875, 6.496469020843505859, 4.773375511169433593, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@CGUID+107, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 199.7492218017578125, 1626.1556396484375, 6.462860107421875, 0.472751170396804809, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@CGUID+108, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 200, 1625, 6.461417675018310546, 0.932218730449676513, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@CGUID+109, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 186.4774627685546875, 1634.9195556640625, 6.299296379089355468, 5.844939231872558593, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@CGUID+110, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 191.666015625, 1638.021484375, 6.368474960327148437, 5.630160808563232421, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@CGUID+111, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 194.0026092529296875, 1633.828369140625, 6.405772209167480468, 0.46686825156211853, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@CGUID+112, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 196.353515625, 1631.25, 6.443385124206542968, 2.154774904251098632, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@CGUID+113, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 62.375, 1629.546875, 0.845486104488372802, 5.204124927520751953, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 254963 - Tied Up) +(@CGUID+114, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 61.81944656372070312, 1626.0816650390625, 0.883315205574035644, 3.428330183029174804, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 254963 - Tied Up) +(@CGUID+115, 129490, 1643, 8721, 9026, '0', 0, 0, 0, 0, 59.02777862548828125, 1628.873291015625, 1.323850870132446289, 1.012436866760253906, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Burke Stevenson (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 248917 - Cursed, 256574 - Pig Top Hat, 254963 - Tied Up) +(@CGUID+116, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 59.03472137451171875, 1672.142333984375, 0.784915745258331298, 6.118127822875976562, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 254963 - Tied Up) +(@CGUID+117, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 58.17882156372070312, 1677.6180419921875, 0.84755796194076538, 3.848198652267456054, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 254963 - Tied Up) +(@CGUID+118, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 55.33333206176757812, 1673.0867919921875, 0.993423223495483398, 1.929083108901977539, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 254963 - Tied Up) +(@CGUID+119, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 53.890625, 1675.2569580078125, 1.200402259826660156, 4.571907520294189453, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 254963 - Tied Up) +(@CGUID+120, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 77.71527862548828125, 1690.5086669921875, 1.221826553344726562, 2.565113544464111328, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune)) +(@CGUID+121, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 142.923614501953125, 1657.34375, 3.257519245147705078, 5.334957122802734375, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 254963 - Tied Up) +(@CGUID+122, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 166.829864501953125, 1675.3802490234375, 11.65707588195800781, 4.306904792785644531, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 254963 - Tied Up) +(@CGUID+123, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 166.15972900390625, 1673.560791015625, 11.67975234985351562, 1.545127153396606445, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 254963 - Tied Up) +(@CGUID+124, 129488, 1643, 8721, 9026, '0', 0, 0, 0, 0, 142.763885498046875, 1654.5347900390625, 3.068011999130249023, 1.374182581901550292, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Travis Daybreak (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 248917 - Cursed, 256598 - Pig Belt, 254963 - Tied Up) +(@CGUID+125, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 139.90625, 1653.4617919921875, 2.411360025405883789, 5.699315071105957031, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 254963 - Tied Up) +(@CGUID+126, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 140.2743072509765625, 1657.8228759765625, 3.069979667663574218, 3.930724620819091796, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 254963 - Tied Up) +(@CGUID+127, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 162.2465362548828125, 1675.03125, 11.67425155639648437, 0.567196309566497802, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 254963 - Tied Up) +(@CGUID+128, 129501, 1643, 8721, 9026, '0', 0, 0, 0, 0, 164.203125, 1671.642333984375, 11.74465847015380859, 1.874995350837707519, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Stockyard Pig (Area: Carver's Harbor - Difficulty: 0) CreateObject1 (Auras: 254963 - Tied Up) +(@CGUID+129, 124921, 1643, 8721, 9026, '0', 0, 0, 0, 0, 31.15972328186035156, 1663.173583984375, 17.44399642944335937, 4.081215858459472656, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Raven (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+130, 124921, 1643, 8721, 9026, '0', 0, 0, 0, 0, 67.37152862548828125, 1589.217041015625, 27.38347625732421875, 0.454994827508926391, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Raven (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+131, 124921, 1643, 8721, 9026, '0', 0, 0, 0, 0, 228.72222900390625, 1678.7760009765625, 26.47960472106933593, 4.110684394836425781, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490), -- Harbor Raven (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+132, 124786, 1643, 8721, 9026, '0', 0, 0, 0, 0, 230.3020782470703125, 1675.592041015625, 20.72267913818359375, 3.629101276397705078, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 60490); -- Thomas Staughton (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+132; +INSERT INTO `creature_addon` (`guid`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+10, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Harbor Raven +(@CGUID+28, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Harbor Raven +(@CGUID+32, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Harbor Raven +(@CGUID+35, 0, 0, 0, 0, 0, 1, 0, 428, 0, 0, 0, 0, ''), -- Harbor Raven +(@CGUID+36, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Harbor Raven +(@CGUID+40, 0, 0, 0, 0, 0, 1, 0, 428, 0, 0, 0, 0, ''), -- Harbor Raven +(@CGUID+46, 0, 0, 0, 0, 0, 1, 0, 428, 0, 0, 0, 0, ''), -- Harbor Raven +(@CGUID+47, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Harbor Raven +(@CGUID+60, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '258721'), -- Hanging Pig Bunny - 258721 - Hanging Pig Fetish +(@CGUID+85, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 0, 0, '159474'), -- Stockyard Pig - 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune) +(@CGUID+120, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 0, 0, '159474'), -- Stockyard Pig - 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune) +(@CGUID+131, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''); -- Harbor Raven + +-- GameObject +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+11; +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, 277515, 1643, 8721, 9026, '0', 0, 0, 164.1979217529296875, 1674.5677490234375, 11.5912637710571289, 0, 0, 0, 0, 1, 120, 255, 1, 60490), -- Tethering Post (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@OGUID+1, 277515, 1643, 8721, 9026, '0', 0, 0, 183.234375, 1609.4896240234375, 6.119922161102294921, 0, 0, 0, 0, 1, 120, 255, 1, 60490), -- Tethering Post (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@OGUID+2, 277515, 1643, 8721, 9026, '0', 0, 0, 183.529510498046875, 1620.4149169921875, 5.66075754165649414, 0, 0, 0, 0, 1, 120, 255, 1, 60490), -- Tethering Post (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@OGUID+3, 277515, 1643, 8721, 9026, '0', 0, 0, 189.4600677490234375, 1614.8680419921875, 6.144156455993652343, 0, 0, 0, 0, 1, 120, 255, 1, 60490), -- Tethering Post (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@OGUID+4, 277515, 1643, 8721, 9026, '0', 0, 0, 140.8802032470703125, 1654.765625, 2.712239742279052734, 0, 0, 0, 0, 1, 120, 255, 1, 60490), -- Tethering Post (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@OGUID+5, 277515, 1643, 8721, 9026, '0', 0, 0, 111.8593826293945312, 1590.1458740234375, 0.967798352241516113, 0, 0, 0, 0, 1, 120, 255, 1, 60490), -- Tethering Post (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@OGUID+6, 277515, 1643, 8721, 9026, '0', 0, 0, 145.3975677490234375, 1611.29345703125, 1.802109599113464355, 0, 0, 0, 0, 1, 120, 255, 1, 60490), -- Tethering Post (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@OGUID+7, 277515, 1643, 8721, 9026, '0', 0, 0, 59.17708206176757812, 1674.467041015625, 0.895907104015350341, 0, 0, 0, 0, 1, 120, 255, 1, 60490), -- Tethering Post (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@OGUID+8, 277515, 1643, 8721, 9026, '0', 0, 0, 60.77777862548828125, 1628.0225830078125, 0.987847208976745605, 0.467965304851531982, 0, 0, 0.231853485107421875, 0.972750723361968994, 120, 255, 1, 60490), -- Tethering Post (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@OGUID+9, 277515, 1643, 8721, 9026, '0', 0, 0, 73.42014312744140625, 1607.9930419921875, 0.693975508213043212, 0, 0, 0, 0, 1, 120, 255, 1, 60490), -- Tethering Post (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@OGUID+10, 278527, 1643, 8721, 9026, '0', 0, 0, 230.8350677490234375, 1673.1875, 20.58913993835449218, 3.142819166183471679, 0.007823467254638671, 0.04631805419921875, -0.99889564514160156, 0.0009765625, 120, 255, 1, 60490), -- Campfire (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +(@OGUID+11, 325418, 1643, 8721, 9026, '0', 0, 0, 75.32291412353515625, 1626.9271240234375, 0.710495650768280029, 2.533647537231445312, 0, 0, 0.95415496826171875, 0.299313008785247802, 120, 255, 1, 60490); -- Boiling Cauldron (Area: Carver's Harbor - Difficulty: 0) CreateObject1 +DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+11; +INSERT INTO `gameobject_addon` (`guid`, `parent_rotation0`, `parent_rotation1`, `parent_rotation2`, `parent_rotation3`, `WorldEffectID`, `AIAnimKitID`) VALUES +(@OGUID+11, 0, 0, 0, 1, 11674, 0); -- Boiling Cauldron + +-- Template Addon +DELETE FROM `creature_template_addon` WHERE `entry` IN (124921,124814,124844,129489,129490,129488,124882); +INSERT INTO `creature_template_addon` (`entry`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(124921, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 124921 (Harbor Raven) +(124814, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '248058'), -- 124814 (Hexed Howler) - Possessed +(124844, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '248917 256576'), -- 124844 (Trevor Hightide) - Cursed, Pig Goggles, Tied Up +(129489, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '248917 256582'), -- 129489 (Kyle Sailford) - Cursed, Pig Dock Hat, Tied Up +(129490, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '248917 256574'), -- 129490 (Burke Stevenson) - Cursed, Pig Top Hat, Tied Up +(129488, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '248917 256598'), -- 129488 (Travis Daybreak) - Cursed, Pig Belt, Tied Up +(124882, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '257881'); -- 124882 (Roland Hacksaw) - Enthralled, Ride Vehicle Hardcoded + +UPDATE `gameobject_template_addon` SET `flags`=0x0, `WorldEffectID`=11674 WHERE `entry`=325418; -- Boiling Cauldron + +-- Template +UPDATE `creature_template` SET `unit_flags3`=0x41000000 WHERE `entry`=119314; -- Meat Grinder +UPDATE `creature_template` SET `unit_flags3`=0x40000001, `flags_extra` = 128 WHERE `entry`=129721; -- Hanging Pig Bunny +UPDATE `creature_template` SET `unit_flags3`=0x40000001, `flags_extra` = 128 WHERE `entry`=128475; -- Post Bunny +UPDATE `creature_template` SET `unit_flags3`=0x40000001, `flags_extra` = 128 WHERE `entry`=128526; -- Fire Bunny +UPDATE `creature_template` SET `unit_flags`=0x0, `unit_flags3`=0x4000000 WHERE `entry`=128623; -- Harbor Crab + +UPDATE `gameobject_template` SET `ContentTuningId`=187, `VerifiedBuild`=60490 WHERE `entry`=277459; -- Pig Effigy +UPDATE `gameobject_template` SET `ContentTuningId`=187, `VerifiedBuild`=60490 WHERE `entry`=277515; -- Tethering Post + +-- Difficulty +DELETE FROM `creature_template_difficulty` WHERE (`Entry` IN (129490,138868,129489,119314,124882,129721,124844,129488,124786,128475,124921,125375,124814,128526,129501) AND `DifficultyID`=1); +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10000000, `VerifiedBuild`=60490 WHERE (`Entry`=129490 AND `DifficultyID`=0); -- 129490 (Burke Stevenson) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10000000, `VerifiedBuild`=60490 WHERE (`Entry`=138868 AND `DifficultyID`=0); -- 138868 (Gilnean Officer) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10000000, `VerifiedBuild`=60490 WHERE (`Entry`=129489 AND `DifficultyID`=0); -- 129489 (Kyle Sailford) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x20000100, `VerifiedBuild`=60490 WHERE (`Entry`=119314 AND `DifficultyID`=0); -- 119314 (Meat Grinder) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x30000100, `VerifiedBuild`=60490 WHERE (`Entry`=124882 AND `DifficultyID`=0); -- 124882 (Roland Hacksaw) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x20000100, `VerifiedBuild`=60490 WHERE (`Entry`=129721 AND `DifficultyID`=0); -- 129721 (Hanging Pig Bunny) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10000000, `VerifiedBuild`=60490 WHERE (`Entry`=124844 AND `DifficultyID`=0); -- 124844 (Trevor Hightide) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10000000, `VerifiedBuild`=60490 WHERE (`Entry`=129488 AND `DifficultyID`=0); -- 129488 (Travis Daybreak) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10000000, `VerifiedBuild`=60490 WHERE (`Entry`=124786 AND `DifficultyID`=0); -- 124786 (Thomas Staughton) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x20000100, `VerifiedBuild`=60490 WHERE (`Entry`=128475 AND `DifficultyID`=0); -- 128475 (Post Bunny) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x20000100, `VerifiedBuild`=60490 WHERE (`Entry`=125375 AND `DifficultyID`=0); -- 125375 (Pig Corral) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10000000, `VerifiedBuild`=60490 WHERE (`Entry`=124814 AND `DifficultyID`=0); -- 124814 (Hexed Howler) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x20000100, `VerifiedBuild`=60490 WHERE (`Entry`=128526 AND `DifficultyID`=0); -- 128526 (Fire Bunny) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10000000, `VerifiedBuild`=60490 WHERE (`Entry`=129501 AND `DifficultyID`=0); -- 129501 (Stockyard Pig) - CanSwim + +-- Spellclick +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` = 119314; +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES +(119314, 125095, 1, 0); + +-- Vehicle +DELETE FROM `vehicle_template_accessory` WHERE (`entry`=119314 AND `seat_id`=0); +INSERT INTO `vehicle_template_accessory` (`entry`, `accessory_entry`, `seat_id`, `minion`, `description`, `summontype`, `summontimer`) VALUES +(119314, 124882, 0, 0, 'Meat Grinder - Roland Hacksaw', 8, 0); -- Meat Grinder - Roland Hacksaw + +-- Quest +DELETE FROM `quest_details` WHERE `ID` IN (47948 /*Pork Chop*/, 47947 /*Big Bad Wolves*/, 47946 /*Save Their Bacon*/); +INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES +(47948, 1, 0, 0, 0, 0, 0, 0, 0, 60490), -- Pork Chop +(47947, 1, 0, 0, 0, 0, 0, 0, 0, 60490), -- Big Bad Wolves +(47946, 1, 0, 0, 0, 0, 0, 0, 0, 60490); -- Save Their Bacon + +DELETE FROM `creature_queststarter` WHERE (`id`=124786 AND `quest` IN (47948,47947,47946)); +INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(124786, 47948, 60490), -- Pork Chop offered by Thomas Staughton +(124786, 47947, 60490), -- Big Bad Wolves offered by Thomas Staughton +(124786, 47946, 60490); -- Save Their Bacon offered by Thomas Staughton + +DELETE FROM `creature_questender` WHERE (`id`=124786 AND `quest` IN (47946,47947,47948)); +INSERT INTO `creature_questender` (`id`, `quest`, `VerifiedBuild`) VALUES +(124786, 47946, 60490), -- Save Their Bacon ended by Thomas Staughton +(124786, 47947, 60490), -- Big Bad Wolves ended by Thomas Staughton +(124786, 47948, 60490); -- Pork Chop ended by Thomas Staughton + +-- Path for Hexed Howler +SET @MOVERGUID := @CGUID+2; +SET @ENTRY := 124814; +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, 'Hexed Howler - 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, 161.28125, 1678.2067, 11.549086, NULL, 0), +(@PATH, 1, 155.48785, 1677.6077, 10.948646, NULL, 0), +(@PATH, 2, 150.54861, 1676.5365, 9.238617, NULL, 0), +(@PATH, 3, 145.15973, 1673.6858, 6.805654, NULL, 0), +(@PATH, 4, 140.65279, 1668.4896, 4.6753473, NULL, 0), +(@PATH, 5, 130.85938, 1664.6927, 2.1892362, NULL, 0), +(@PATH, 6, 125.3941, 1664.4705, 1.5225694, NULL, 0), +(@PATH, 7, 122.46007, 1661.408, 1.2413194, NULL, 0), +(@PATH, 8, 124.80556, 1658.6007, 1.6354166, NULL, 0), +(@PATH, 9, 131.7066, 1662.0504, 2.2256944, NULL, 0), +(@PATH, 10, 140.79861, 1665.4098, 4.3464456, NULL, 0), +(@PATH, 11, 145.62848, 1668.6719, 6.105655, NULL, 0), +(@PATH, 12, 150.57639, 1674.1997, 9.121257, NULL, 0), +(@PATH, 13, 157.49132, 1675.5052, 11.456011, NULL, 0), +(@PATH, 14, 161.16841, 1672.6233, 11.749509, NULL, 0), +(@PATH, 15, 169.23264, 1667.3403, 11.76222, NULL, 0), +(@PATH, 16, 176.72395, 1663.3524, 11.073758, NULL, 0), +(@PATH, 17, 183.30904, 1665.4601, 10.837148, NULL, 0), +(@PATH, 18, 181.19792, 1668.4288, 11.205377, NULL, 0), +(@PATH, 19, 175.23264, 1671.5348, 11.549069, NULL, 0), +(@PATH, 20, 170.86806, 1676.1962, 11.559814, 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`, `auras`) VALUES +(@MOVERGUID, @PATH, 1, '248058'); + +-- Path for Hexed Howler +SET @MOVERGUID := @CGUID+7; +SET @ENTRY := 124814; +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, 0x0, NULL, 'Hexed Howler - 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, 175.95312, 1626.8021, 6.107839, NULL, 0), +(@PATH, 1, 182.7882, 1632.2153, 6.2482233, NULL, 0), +(@PATH, 2, 184.35938, 1631.4098, 6.2627783, NULL, 0), +(@PATH, 3, 196.8993, 1616.0243, 6.3470883, NULL, 0), +(@PATH, 4, 195.30556, 1611.2413, 6.311939, NULL, 0), +(@PATH, 5, 190.6302, 1607.3298, 6.245478, NULL, 0), +(@PATH, 6, 183.65625, 1603.1702, 6.1531863, NULL, 0), +(@PATH, 7, 181.54688, 1602.8959, 6.2264066, NULL, 0), +(@PATH, 8, 177.61458, 1607.257, 6.098021, NULL, 0), +(@PATH, 9, 173.77951, 1613.0139, 6.0745935, NULL, 0), +(@PATH, 10, 170.08333, 1618.5747, 6.055042, NULL, 0), +(@PATH, 11, 169.39583, 1620.7344, 6.0552235, NULL, 0), +(@PATH, 12, 173.55556, 1624.5017, 6.101873, 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`, `auras`) VALUES +(@MOVERGUID, @PATH, 1, '248058'); + +-- Path for Hexed Howler +SET @MOVERGUID := @CGUID+9; +SET @ENTRY := 124814; +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, 0x0, NULL, 'Hexed Howler - 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, 169.68576, 1605.0504, 6.084837, NULL, 0), +(@PATH, 1, 173.69444, 1599.6442, 6.0266757, NULL, 0), +(@PATH, 2, 175.71875, 1596.9827, 6.0411716, NULL, 0), +(@PATH, 3, 179.04514, 1594.1077, 6.0682473, NULL, 0), +(@PATH, 4, 181.47223, 1591.8403, 6.0871177, NULL, 0), +(@PATH, 5, 183.4375, 1590.9185, 6.1056995, NULL, 0), +(@PATH, 6, 188.54861, 1593.8438, 6.173384, NULL, 0), +(@PATH, 7, 195.29861, 1599.7726, 6.270247, NULL, 0), +(@PATH, 8, 202.03473, 1606.0504, 6.372206, NULL, 0), +(@PATH, 9, 204.71355, 1606.8108, 6.48645, NULL, 0), +(@PATH, 10, 204.68924, 1603.8942, 6.6080647, NULL, 0), +(@PATH, 11, 198.44098, 1600.3541, 6.3319497, NULL, 0), +(@PATH, 12, 196.01389, 1599.9098, 6.2787237, NULL, 0), +(@PATH, 13, 190.86111, 1595.0677, 6.203637, NULL, 0), +(@PATH, 14, 186.73438, 1592.1997, 6.1471424, NULL, 0), +(@PATH, 15, 182.83855, 1591.2552, 6.1002336, NULL, 0), +(@PATH, 16, 177.77605, 1594.0573, 6.0539145, NULL, 0), +(@PATH, 17, 173.56598, 1599.0504, 6.025954, NULL, 0), +(@PATH, 18, 170.1441, 1603.3351, 5.999773, NULL, 0), +(@PATH, 19, 163.81424, 1609.4427, 5.9503274, NULL, 0), +(@PATH, 20, 162.13889, 1613.3438, 5.899306, NULL, 0), +(@PATH, 21, 167.98611, 1607.6997, 5.9921603, 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`, `auras`) VALUES +(@MOVERGUID, @PATH, 1, '248058'); + +-- Path for Hexed Howler +SET @MOVERGUID := @CGUID+18; +SET @ENTRY := 124814; +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, 0x0, NULL, 'Hexed Howler - 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, 130.82466, 1636.4045, 0.9967737, NULL, 0), +(@PATH, 1, 126.15972, 1638.6285, 0.916531, NULL, 0), +(@PATH, 2, 116.05556, 1642.3733, 0.71332127, NULL, 0), +(@PATH, 3, 108.14931, 1641.349, 0.71315175, NULL, 0), +(@PATH, 4, 103.47569, 1634.2344, 0.71311784, NULL, 0), +(@PATH, 5, 100.57986, 1628.6442, 0.71311444, NULL, 0), +(@PATH, 6, 100.55035, 1622.9548, 0.71311104, NULL, 0), +(@PATH, 7, 104.35764, 1616.7692, 0.711636, NULL, 0), +(@PATH, 8, 108.08854, 1610.75, 0.6826613, NULL, 0), +(@PATH, 9, 115.24653, 1608.7101, 0.71239215, NULL, 0), +(@PATH, 10, 123.81771, 1609.1736, 0.6758728, NULL, 0), +(@PATH, 11, 132.73958, 1614.2413, 0.8149855, NULL, 0), +(@PATH, 12, 136.78473, 1621.2118, 0.7752957, NULL, 0), +(@PATH, 13, 137.00868, 1627.9045, 0.91345894, 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`, `auras`) VALUES +(@MOVERGUID, @PATH, 1, '248058'); + +-- Path for Hexed Howler +SET @MOVERGUID := @CGUID+30; +SET @ENTRY := 124814; +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, 0x0, NULL, 'Hexed Howler - 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, 73.2691, 1595.717, 0.7808596, NULL, 0), +(@PATH, 1, 71.06077, 1598.7552, 0.6944445, NULL, 0), +(@PATH, 2, 67.43924, 1601.8247, 0.63325334, NULL, 0), +(@PATH, 3, 61.623264, 1606.481, 0.66594106, NULL, 0), +(@PATH, 4, 54.88889, 1612.6892, 0.7760417, NULL, 0), +(@PATH, 5, 49.68403, 1619.6997, 0.87705487, NULL, 0), +(@PATH, 6, 48.123264, 1623.8942, 0.80907524, NULL, 0), +(@PATH, 7, 52.189236, 1618.441, 0.80388385, NULL, 0), +(@PATH, 8, 55.338543, 1613.191, 0.7447917, NULL, 0), +(@PATH, 9, 59.796875, 1609.4098, 0.7466702, NULL, 0), +(@PATH, 10, 64.65972, 1605.3108, 0.6618245, NULL, 0), +(@PATH, 11, 68.7934, 1602.158, 0.70040554, NULL, 0), +(@PATH, 12, 72.12674, 1599.0365, 0.7958103, NULL, 0), +(@PATH, 13, 73.96528, 1595.6632, 0.6666667, 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`, `auras`) VALUES +(@MOVERGUID, @PATH, 1, '248058'); + +-- Path for Hexed Howler +SET @MOVERGUID := @CGUID+27; +SET @ENTRY := 124814; +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, 0x0, NULL, 'Hexed Howler - 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, 115.67882, 1683.4219, 0.0036203116, NULL, 0), +(@PATH, 1, 111.625, 1683.7986, 0.038194444, NULL, 0), +(@PATH, 2, 105.89931, 1685.007, -0.23001099, NULL, 0), +(@PATH, 3, 95.739586, 1686.0538, -0.19035594, NULL, 0), +(@PATH, 4, 87.99653, 1686.2361, -0.04925876, NULL, 0), +(@PATH, 5, 76.49479, 1685.7291, 0.08382331, NULL, 0), +(@PATH, 6, 71.53646, 1685.0555, 0.2432624, NULL, 0), +(@PATH, 7, 77.96181, 1684.592, 0.1497718, NULL, 0), +(@PATH, 8, 87.947914, 1685.4115, -0.032352023, NULL, 0), +(@PATH, 9, 96.08681, 1685.7361, -0.20068784, NULL, 0), +(@PATH, 10, 102.80729, 1686.1233, -0.20148638, NULL, 0), +(@PATH, 11, 109.21875, 1685.9254, -0.1535136, NULL, 0), +(@PATH, 12, 113.06944, 1685.1598, 0.009463994, NULL, 0), +(@PATH, 13, 117.84896, 1684.651, -0.12152778, NULL, 0), +(@PATH, 14, 120.82639, 1683.4757, 0.013423383, 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`, `auras`) VALUES +(@MOVERGUID, @PATH, 1, '248058'); + +-- Path for Hexed Howler +SET @MOVERGUID := @CGUID+25; +SET @ENTRY := 124814; +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, 0x0, NULL, 'Hexed Howler - 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, 44.67014, 1681.4045, 1.1645379, NULL, 0), +(@PATH, 1, 44.822918, 1679.0243, 1.1379441, NULL, 0), +(@PATH, 2, 44.67014, 1672.8524, 1.1726624, NULL, 0), +(@PATH, 3, 45.25347, 1662.7709, 0.33348933, NULL, 0), +(@PATH, 4, 44.633682, 1651.0052, 1.185764, NULL, 0), +(@PATH, 5, 44.883682, 1643.4062, 1.2061348, NULL, 0), +(@PATH, 6, 44.869793, 1629.7882, 1.21875, NULL, 0), +(@PATH, 7, 43.57986, 1637.4028, 1.1734381, NULL, 0), +(@PATH, 8, 43.868057, 1649.9879, 1.1788194, NULL, 0), +(@PATH, 9, 45.538197, 1664.0521, 0.30763754, NULL, 0), +(@PATH, 10, 43.822918, 1676.6545, 1.1498468, 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`, `auras`) VALUES +(@MOVERGUID, @PATH, 1, '248058'); + +-- Path for Hexed Howler +SET @MOVERGUID := @CGUID+20; +SET @ENTRY := 124814; +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, 0x0, NULL, 'Hexed Howler - 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, 111.92709, 1563.9653, 1.6995579, NULL, 0), +(@PATH, 1, 116.24653, 1562.1372, 2.925403, NULL, 0), +(@PATH, 2, 119.08854, 1557.651, 2.523246, NULL, 0), +(@PATH, 3, 119.17709, 1550.1927, 1.4317662, NULL, 0), +(@PATH, 4, 118.88368, 1545.8646, 1.6523963, NULL, 0), +(@PATH, 5, 122.71528, 1543.8055, 1.5538245, NULL, 0), +(@PATH, 6, 128.75348, 1544.4548, 1.8836263, NULL, 0), +(@PATH, 7, 130.06424, 1547.6598, 2.392612, NULL, 0), +(@PATH, 8, 132.4323, 1549.493, 2.3593378, NULL, 0), +(@PATH, 9, 138.36632, 1550.7205, 1.9855363, NULL, 0), +(@PATH, 10, 145.98438, 1550.9305, 1.8178762, NULL, 0), +(@PATH, 11, 151.69098, 1547.7587, 1.8239458, NULL, 0), +(@PATH, 12, 151.19966, 1545.6788, 1.5903015, NULL, 0), +(@PATH, 13, 142.88889, 1546.7135, 1.4104631, NULL, 0), +(@PATH, 14, 136.79341, 1547.2726, 1.9328665, NULL, 0), +(@PATH, 15, 132.52779, 1547.2639, 2.3788164, NULL, 0), +(@PATH, 16, 130.36111, 1545.1233, 2.1019711, NULL, 0), +(@PATH, 17, 127.71528, 1543.7969, 1.637619, NULL, 0), +(@PATH, 18, 123.31944, 1543.5035, 1.542194, NULL, 0), +(@PATH, 19, 119.78646, 1544.8767, 1.7173394, NULL, 0), +(@PATH, 20, 118.40972, 1548.0104, 1.5364939, NULL, 0), +(@PATH, 21, 115.7066, 1560.4861, 2.1977267, NULL, 0), +(@PATH, 22, 112.30556, 1562.5104, 1.4859415, NULL, 0), +(@PATH, 23, 107.47569, 1562.9983, 1.2893151, 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`, `auras`) VALUES +(@MOVERGUID, @PATH, 1, '248058'); + +-- Path for Hexed Howler +SET @MOVERGUID := @CGUID+12; +SET @ENTRY := 124814; +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, 0x0, NULL, 'Hexed Howler - 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, 116.1684, 1600.6805, 1.0381744, NULL, 0), +(@PATH, 1, 113.29514, 1598.5747, 0.6996697, NULL, 0), +(@PATH, 2, 110.33681, 1596.7639, 0.6940681, NULL, 0), +(@PATH, 3, 106.3941, 1593.0278, 0.68361074, NULL, 0), +(@PATH, 4, 102.96875, 1590.1979, 0.7013889, NULL, 0), +(@PATH, 5, 102.8559, 1585.7274, 0.7204861, NULL, 0), +(@PATH, 6, 103.73611, 1578.2327, 0.7648365, NULL, 0), +(@PATH, 7, 104.84028, 1571.6841, 0.8819445, NULL, 0), +(@PATH, 8, 102.95834, 1571.6493, 0.7795139, NULL, 0), +(@PATH, 9, 102.01389, 1578.882, 0.7517361, NULL, 0), +(@PATH, 10, 101.20313, 1585.493, 0.72830224, NULL, 0), +(@PATH, 11, 102.20313, 1591.2413, 0.7256945, NULL, 0), +(@PATH, 12, 107.7066, 1596.1111, 0.6836175, NULL, 0), +(@PATH, 13, 112.18229, 1598.4774, 0.6898736, NULL, 0), +(@PATH, 14, 118.38541, 1601.5538, 0.6553955, 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`, `auras`) VALUES +(@MOVERGUID, @PATH, 1, '248058'); + +-- Path for Harbor Raven +SET @MOVERGUID := @CGUID+41; +SET @ENTRY := 124921; +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.8687, 'Harbor Raven - 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, 201.67639, 1594.9733, 19.911253, NULL, 0), +(@PATH, 1, 196.5953, 1609.4127, 19.911253, NULL, 0), +(@PATH, 2, 182.79222, 1616.03, 19.911253, NULL, 0), +(@PATH, 3, 168.35278, 1610.949, 19.911253, NULL, 0), +(@PATH, 4, 161.73544, 1597.1459, 19.911253, NULL, 0), +(@PATH, 5, 166.81653, 1582.7064, 19.911253, NULL, 0), +(@PATH, 6, 180.6196, 1576.0891, 19.911253, NULL, 0), +(@PATH, 7, 195.05904, 1581.1702, 19.911253, 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 Harbor Raven +SET @MOVERGUID := @CGUID+45; +SET @ENTRY := 124921; +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.8687, 'Harbor Raven - 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, 92.17757, 1627.8387, 17.875656, NULL, 0), +(@PATH, 1, 101.081635, 1615.3876, 17.875656, NULL, 0), +(@PATH, 2, 116.182076, 1612.8794, 17.875656, NULL, 0), +(@PATH, 3, 128.63327, 1621.7834, 17.875656, NULL, 0), +(@PATH, 4, 131.14148, 1636.8839, 17.875656, NULL, 0), +(@PATH, 5, 122.23741, 1649.3351, 17.875656, NULL, 0), +(@PATH, 6, 107.13696, 1651.8433, 17.875656, NULL, 0), +(@PATH, 7, 94.68577, 1642.9392, 17.875656, 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 Harbor Raven +SET @MOVERGUID := @CGUID+129; +SET @ENTRY := 124921; +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.8687, 'Harbor Raven - 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, 22.126986, 1650.8154, 17.443996, NULL, 0), +(@PATH, 1, 24.478432, 1635.6897, 17.443996, NULL, 0), +(@PATH, 2, 36.8366, 1626.657, 17.443996, NULL, 0), +(@PATH, 3, 51.96225, 1629.0084, 17.443996, NULL, 0), +(@PATH, 4, 60.99498, 1641.3667, 17.443996, NULL, 0), +(@PATH, 5, 58.64354, 1656.4923, 17.443996, NULL, 0), +(@PATH, 6, 46.285374, 1665.525, 17.443996, NULL, 0), +(@PATH, 7, 31.159721, 1663.1736, 17.443996, 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 Harbor Raven +SET @MOVERGUID := @CGUID+130; +SET @ENTRY := 124921; +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.8687, 'Harbor Raven - 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, 81.12155, 1595.944, 27.383476, NULL, 0), +(@PATH, 1, 95.60093, 1590.9779, 27.383476, NULL, 0), +(@PATH, 2, 102.32784, 1577.2278, 27.383476, NULL, 0), +(@PATH, 3, 97.361755, 1562.7484, 27.383476, NULL, 0), +(@PATH, 4, 83.611725, 1556.0215, 27.383476, NULL, 0), +(@PATH, 5, 69.13235, 1560.9877, 27.383476, NULL, 0), +(@PATH, 6, 62.405434, 1574.7377, 27.383476, NULL, 0), +(@PATH, 7, 67.37153, 1589.217, 27.383476, 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); |