diff options
author | Naddley <NaddleyTC@gmail.com> | 2025-03-28 18:34:42 +0100 |
---|---|---|
committer | Naddley <NaddleyTC@gmail.com> | 2025-03-28 18:34:42 +0100 |
commit | ba2847e7b82409bd721b872f7d6bb0b8653c28f2 (patch) | |
tree | cf6d6701d62d36333ee5e498a1d5f8a9604d284c | |
parent | e400b5bcc9eb5dd35caf2db0d2ee93eecdb7840c (diff) |
DB/Drustvar: Added some more spawns
-rw-r--r-- | sql/updates/world/master/2025_03_28_04_world.sql | 334 |
1 files changed, 334 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_03_28_04_world.sql b/sql/updates/world/master/2025_03_28_04_world.sql new file mode 100644 index 00000000000..2c90b9c7380 --- /dev/null +++ b/sql/updates/world/master/2025_03_28_04_world.sql @@ -0,0 +1,334 @@ +SET @CGUID := 7001618; + +-- Creature +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+100; +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, 124382, 1643, 8721, 9032, '0', 0, 0, 0, 0, 42.23090362548828125, 2016.0208740234375, 50.63563156127929687, 4.413890361785888671, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Bonepicker Raven (Area: Fallhaven - Difficulty: 0) CreateObject2 (Auras: 248065 - Possessed) +(@CGUID+1, 124382, 1643, 8721, 9032, '0', 0, 0, 0, 0, 31.59201431274414062, 1958.7552490234375, 61.47903823852539062, 1.415887713432312011, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Bonepicker Raven (Area: Fallhaven - Difficulty: 0) CreateObject2 (Auras: 248065 - Possessed) +(@CGUID+2, 124382, 1643, 8721, 9032, '0', 0, 0, 0, 0, 23.36458396911621093, 1973.876708984375, 74.0631561279296875, 0.343883931636810302, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Bonepicker Raven (Area: Fallhaven - Difficulty: 0) CreateObject2 (Auras: 248065 - Possessed) (possible waypoints or random movement) +(@CGUID+3, 124382, 1643, 8721, 9032, '0', 0, 0, 0, 0, 39.89236068725585937, 2018.3785400390625, 50.06557846069335937, 3.901584148406982421, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Bonepicker Raven (Area: Fallhaven - Difficulty: 0) CreateObject2 (Auras: 248065 - Possessed) +(@CGUID+4, 128385, 1643, 8721, 9032, '0', 0, 0, 0, 0, 74.984375, 2068.357666015625, 56.80765151977539062, 0.890672922134399414, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Lowlands Doe (Area: Fallhaven - Difficulty: 0) CreateObject2 (Auras: 123169 - Mod Scale 105-110%) +(@CGUID+5, 128386, 1643, 8721, 9032, '0', 0, 0, 0, 0, -9.98263931274414062, 1876.6754150390625, 43.40884780883789062, 5.014912605285644531, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Lowlands Fawn (Area: Fallhaven - Difficulty: 0) CreateObject2 (Auras: 123169 - Mod Scale 105-110%) +(@CGUID+6, 128386, 1643, 8721, 9032, '0', 0, 0, 0, 0, -14.3628473281860351, 1875.71875, 42.32808303833007812, 0, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Lowlands Fawn (Area: Fallhaven - Difficulty: 0) CreateObject2 (Auras: 123169 - Mod Scale 105-110%) +(@CGUID+7, 128386, 1643, 8721, 9032, '0', 0, 0, 0, 0, -14.8767366409301757, 1870.43408203125, 42.94130325317382812, 4.362474441528320312, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Lowlands Fawn (Area: Fallhaven - Difficulty: 0) CreateObject2 (Auras: 123169 - Mod Scale 105-110%) +(@CGUID+8, 128385, 1643, 8721, 9032, '0', 0, 0, 0, 0, 22.05034828186035156, 1905.935791015625, 51.39732742309570312, 5.308913707733154296, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Lowlands Doe (Area: Fallhaven - Difficulty: 0) CreateObject2 (Auras: 123169 - Mod Scale 105-110%) +(@CGUID+9, 128384, 1643, 8721, 9032, '0', 0, 0, 0, 0, -22.7743053436279296, 1889.5867919921875, 40.25401687622070312, 1.215039014816284179, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Lowlands Greatstag (Area: Fallhaven - Difficulty: 0) CreateObject2 (Auras: 123169 - Mod Scale 105-110%) +(@CGUID+10, 128386, 1643, 8721, 9032, '0', 0, 0, 0, 0, -13.2586803436279296, 1865.4132080078125, 44.0304412841796875, 2.383303642272949218, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Lowlands Fawn (Area: Fallhaven - Difficulty: 0) CreateObject2 (Auras: 123169 - Mod Scale 105-110%) +(@CGUID+11, 128385, 1643, 8721, 9032, '0', 0, 0, 0, 0, -11.7795143127441406, 1868.90625, 43.81818771362304687, 2.000954866409301757, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Lowlands Doe (Area: Fallhaven - Difficulty: 0) CreateObject2 (Auras: 123169 - Mod Scale 105-110%) +(@CGUID+12, 124382, 1643, 8721, 9032, '0', 0, 0, 0, 0, 19.39756965637207031, 1881.3802490234375, 64.80654144287109375, 1.765741467475891113, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Bonepicker Raven (Area: Fallhaven - Difficulty: 0) CreateObject2 (Auras: 248065 - Possessed) +(@CGUID+13, 128385, 1643, 8721, 9032, '0', 0, 0, 0, 0, -9.64583301544189453, 1872.907958984375, 43.80377578735351562, 3.594196796417236328, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Lowlands Doe (Area: Fallhaven - Difficulty: 0) CreateObject2 (Auras: 123169 - Mod Scale 105-110%) +(@CGUID+14, 124382, 1643, 8721, 9032, '0', 0, 0, 0, 0, 15.76215267181396484, 1876.3507080078125, 65.6763916015625, 2.683441638946533203, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Bonepicker Raven (Area: Fallhaven - Difficulty: 0) CreateObject2 (Auras: 248065 - Possessed) +(@CGUID+15, 128625, 1643, 8721, 9032, '0', 0, 0, 0, 0, -83.0902786254882812, 1843.76220703125, 8.565039634704589843, 4.063967704772949218, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Harbor Gull (Area: Fallhaven - Difficulty: 0) CreateObject2 +(@CGUID+16, 124170, 1643, 8721, 9032, '0', 0, 0, 0, 0, -72.2638931274414062, 1862.7535400390625, 12.2825326919555664, 0.603066563606262207, 120, 8, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Fallhaven Pig (Area: Fallhaven - Difficulty: 0) CreateObject2 (Auras: 247043 - Possessed) +(@CGUID+17, 128623, 1643, 8721, 9032, '0', 0, 0, 0, 0, -97.4513931274414062, 1839.24658203125, 2.147007226943969726, 0.062290087342262268, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Harbor Crab (Area: Fallhaven - Difficulty: 0) CreateObject2 +(@CGUID+18, 61081, 1643, 8721, 9026, '0', 0, 0, 0, 0, 74.671875, 1671.6910400390625, 19.2417755126953125, 5.242915153503417968, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Squirrel (Area: Carver's Harbor - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+19, 1412, 1643, 8721, 0, '0', 0, 0, 0, 0, 70.35416412353515625, 1769.298583984375, 35.53831100463867187, 2.7469635009765625, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Squirrel (Area: 0 - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+20, 1412, 1643, 8721, 0, '0', 0, 0, 0, 0, 138.046875, 1730.907958984375, 33.465484619140625, 0, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Squirrel (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+21, 1412, 1643, 8721, 0, '0', 0, 0, 0, 0, 106.001739501953125, 1739.5555419921875, 29.71160888671875, 1.203186750411987304, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Squirrel (Area: 0 - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+22, 1412, 1643, 8721, 0, '0', 0, 0, 0, 0, 48.32291793823242187, 1748.9097900390625, 25.7085113525390625, 5.851899147033691406, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Squirrel (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+23, 1412, 1643, 8721, 0, '0', 0, 0, 0, 0, 85.72396087646484375, 1785.1614990234375, 39.46529006958007812, 5.545518875122070312, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Squirrel (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+24, 128385, 1643, 8721, 0, '0', 0, 0, 0, 0, 51.21875, 1737.55908203125, 24.12088394165039062, 0, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Lowlands Doe (Area: 0 - Difficulty: 0) CreateObject2 (Auras: 123169 - Mod Scale 105-110%) +(@CGUID+25, 1412, 1643, 8721, 0, '0', 0, 0, 0, 0, 136.5555572509765625, 1738.3646240234375, 31.62593650817871093, 4.974195480346679687, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Squirrel (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+26, 128384, 1643, 8721, 0, '0', 0, 0, 0, 0, 51.52777862548828125, 1734.8021240234375, 24.49189376831054687, 0.913327336311340332, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Lowlands Greatstag (Area: 0 - Difficulty: 0) CreateObject2 (Auras: 123169 - Mod Scale 105-110%) +(@CGUID+27, 1412, 1643, 8721, 0, '0', 0, 0, 0, 0, 56.72569656372070312, 1736.2552490234375, 25.76707649230957031, 2.84374856948852539, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Squirrel (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+28, 128385, 1643, 8721, 0, '0', 0, 0, 0, 0, 74.4774322509765625, 1762.828125, 34.02570724487304687, 0.969233512878417968, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Lowlands Doe (Area: 0 - Difficulty: 0) CreateObject2 (Auras: 123169 - Mod Scale 105-110%) +(@CGUID+29, 124921, 1643, 8721, 9026, '0', 0, 0, 0, 0, 50.203125, 1729.873291015625, 50.95584869384765625, 5.299686431884765625, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Harbor Raven (Area: Carver's Harbor - Difficulty: 0) CreateObject2 +(@CGUID+30, 128625, 1643, 8721, 0, '0', 0, 0, 0, 0, 17.06597328186035156, 1703.2916259765625, 10.61167430877685546, 4.220865249633789062, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Harbor Gull (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+31, 128514, 1643, 8721, 0, '0', 0, 0, 0, 0, 2.284722328186035156, 1694.6822509765625, 1.263451576232910156, 0.769809305667877197, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Harbor Scuttler (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+32, 128514, 1643, 8721, 0, '0', 0, 0, 0, 0, -33.9010429382324218, 1742.8125, -0.41332578659057617, 2.81264042854309082, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Harbor Scuttler (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+33, 128514, 1643, 8721, 0, '0', 0, 0, 0, 0, 24.82291603088378906, 1662.40283203125, -0.75025689601898193, 3.570493698120117187, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Harbor Scuttler (Area: 0 - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+34, 124921, 1643, 8721, 0, '0', 0, 0, 0, 0, -1.37326395511627197, 1715.3507080078125, 22.5054473876953125, 5.299686431884765625, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Harbor Raven (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+35, 1412, 1643, 8721, 0, '0', 0, 0, 0, 0, 43.55902862548828125, 1706.6475830078125, 8.686781883239746093, 3.57908487319946289, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Squirrel (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+36, 130160, 1643, 8721, 0, '0', 0, 0, 0, 0, -65.7881927490234375, 1757.642333984375, -7.13582277297973632, 4.767452239990234375, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Saltrock Terrapin (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+37, 128514, 1643, 8721, 0, '0', 0, 0, 0, 0, 7.08680582046508789, 1673.0989990234375, -1.38654136657714843, 0.422597855329513549, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Harbor Scuttler (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+38, 128514, 1643, 8721, 0, '0', 0, 0, 0, 0, -16.2829856872558593, 1684.5382080078125, -1.01629483699798583, 0.227439895272254943, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Harbor Scuttler (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+39, 128623, 1643, 8721, 0, '0', 0, 0, 0, 0, -15.2934026718139648, 1689.0260009765625, 0.016790606081485748, 2.144964218139648437, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Harbor Crab (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+40, 128514, 1643, 8721, 0, '0', 0, 0, 0, 0, -25.6267356872558593, 1707.4757080078125, -0.41477945446968078, 3.70846724510192871, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Harbor Scuttler (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+41, 128623, 1643, 8721, 0, '0', 0, 0, 0, 0, 16.42013931274414062, 1700.515625, 1.8559722900390625, 0, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Harbor Crab (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+42, 128623, 1643, 8721, 0, '0', 0, 0, 0, 0, -32.3489570617675781, 1717.295166015625, -0.61049890518188476, 1.842280030250549316, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Harbor Crab (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+43, 128623, 1643, 8721, 0, '0', 0, 0, 0, 0, 11.27951431274414062, 1666.189208984375, -2.31994056701660156, 1.233017683029174804, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Harbor Crab (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+44, 128625, 1643, 8721, 0, '0', 0, 0, 0, 0, -10.2534723281860351, 1743.576416015625, 6.1191864013671875, 2.184941053390502929, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Harbor Gull (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+45, 130160, 1643, 8721, 0, '0', 0, 0, 0, 0, -66.2725677490234375, 1782.9757080078125, -3.21718311309814453, 0.234530746936798095, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Saltrock Terrapin (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+46, 128623, 1643, 8721, 0, '0', 0, 0, 0, 0, -29.2777786254882812, 1783.220458984375, 3.838407754898071289, 3.038740873336791992, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Harbor Crab (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+47, 128623, 1643, 8721, 0, '0', 0, 0, 0, 0, -7.79513883590698242, 1732.44970703125, 1.990942955017089843, 0.216026827692985534, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Harbor Crab (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+48, 128623, 1643, 8721, 0, '0', 0, 0, 0, 0, 29.34375, 1669.2603759765625, 0.355749249458312988, 5.88362741470336914, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Harbor Crab (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+49, 128623, 1643, 8721, 0, '0', 0, 0, 0, 0, -44.7673606872558593, 1772.8194580078125, 0.351240694522857666, 4.030216217041015625, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Harbor Crab (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+50, 128514, 1643, 8721, 0, '0', 0, 0, 0, 0, -29.0763893127441406, 1728.0694580078125, 0.808174014091491699, 2.266376733779907226, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Harbor Scuttler (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+51, 129137, 1643, 8721, 8721, '0', 0, 0, 0, 0, 152.6875, 1844.8819580078125, 62.7891845703125, 0.464484244585037231, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Thicket Hare (Area: Drustvar - Difficulty: 0) CreateObject2 +(@CGUID+52, 129137, 1643, 8721, 8721, '0', 0, 0, 0, 0, 104.041656494140625, 1842.94970703125, 51.45974349975585937, 2.320698976516723632, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Thicket Hare (Area: Drustvar - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+53, 129137, 1643, 8721, 8721, '0', 0, 0, 0, 0, 136.7725677490234375, 1831.1875, 55.3795166015625, 3.245434761047363281, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Thicket Hare (Area: Drustvar - Difficulty: 0) CreateObject2 +(@CGUID+54, 130164, 1643, 8721, 8721, '0', 0, 0, 0, 0, 142.7239532470703125, 1818.0382080078125, 53.74872589111328125, 2.340101480484008789, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Highland Boar (Area: Drustvar - Difficulty: 0) CreateObject2 +(@CGUID+55, 130165, 1643, 8721, 8721, '0', 0, 0, 0, 0, 147.951385498046875, 1811.5660400390625, 51.735137939453125, 2.142010450363159179, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Highland Shoat (Area: Drustvar - Difficulty: 0) CreateObject2 +(@CGUID+56, 130165, 1643, 8721, 8721, '0', 0, 0, 0, 0, 246.3489532470703125, 1809.1788330078125, 61.17023468017578125, 0.012629462406039237, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Highland Shoat (Area: Drustvar - Difficulty: 0) CreateObject2 +(@CGUID+57, 130164, 1643, 8721, 8721, '0', 0, 0, 0, 0, 204.842010498046875, 1777.373291015625, 49.9444580078125, 3.162820100784301757, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Highland Boar (Area: Drustvar - Difficulty: 0) CreateObject2 +(@CGUID+58, 130165, 1643, 8721, 8721, '0', 0, 0, 0, 0, 192.9756927490234375, 1782.8228759765625, 49.12415313720703125, 4.80647134780883789, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Highland Shoat (Area: Drustvar - Difficulty: 0) CreateObject2 +(@CGUID+59, 130165, 1643, 8721, 8721, '0', 0, 0, 0, 0, 206.75347900390625, 1767.7708740234375, 47.39558029174804687, 1.134932756423950195, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Highland Shoat (Area: Drustvar - Difficulty: 0) CreateObject2 +(@CGUID+60, 129137, 1643, 8721, 8721, '0', 0, 0, 0, 0, 122.9288177490234375, 1874.8975830078125, 64.3742523193359375, 3.698478937149047851, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Thicket Hare (Area: Drustvar - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+61, 129137, 1643, 8721, 8721, '0', 0, 0, 0, 0, 147.0277862548828125, 1799.3975830078125, 49.80290985107421875, 3.996520042419433593, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Thicket Hare (Area: Drustvar - Difficulty: 0) CreateObject2 +(@CGUID+62, 129137, 1643, 8721, 8721, '0', 0, 0, 0, 0, 157.8541717529296875, 1870.451416015625, 72.0160369873046875, 0.764284968376159667, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Thicket Hare (Area: Drustvar - Difficulty: 0) CreateObject2 +(@CGUID+63, 129137, 1643, 8721, 8721, '0', 0, 0, 0, 0, 196.5555572509765625, 1782.6961669921875, 50.18581771850585937, 4.51129770278930664, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Thicket Hare (Area: Drustvar - Difficulty: 0) CreateObject2 +(@CGUID+64, 129137, 1643, 8721, 8721, '0', 0, 0, 0, 0, 186.376739501953125, 1843.685791015625, 67.64125823974609375, 5.585810661315917968, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Thicket Hare (Area: Drustvar - Difficulty: 0) CreateObject2 +(@CGUID+65, 130164, 1643, 8721, 8721, '0', 0, 0, 0, 0, 143.90625, 1795.3802490234375, 48.80193710327148437, 6.227429866790771484, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Highland Boar (Area: Drustvar - Difficulty: 0) CreateObject2 +(@CGUID+66, 130164, 1643, 8721, 8721, '0', 0, 0, 0, 0, 251.611114501953125, 1810.5191650390625, 61.80693817138671875, 6.129218101501464843, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Highland Boar (Area: Drustvar - Difficulty: 0) CreateObject2 +(@CGUID+67, 130165, 1643, 8721, 8721, '0', 0, 0, 0, 0, 143.4184112548828125, 1802.10595703125, 49.4398651123046875, 3.81643843650817871, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Highland Shoat (Area: Drustvar - Difficulty: 0) CreateObject2 +(@CGUID+68, 129137, 1643, 8721, 8721, '0', 0, 0, 0, 0, 158.654510498046875, 1863.4879150390625, 70.357940673828125, 4.278679847717285156, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Thicket Hare (Area: Drustvar - Difficulty: 0) CreateObject2 +(@CGUID+69, 130165, 1643, 8721, 8721, '0', 0, 0, 0, 0, 237.6649322509765625, 1801.7882080078125, 58.2825775146484375, 3.230849504470825195, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Highland Shoat (Area: Drustvar - Difficulty: 0) CreateObject2 +(@CGUID+70, 129137, 1643, 8721, 8721, '0', 0, 0, 0, 0, 108.4253463745117187, 1814.87158203125, 47.8625946044921875, 5.405132770538330078, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Thicket Hare (Area: Drustvar - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+71, 130165, 1643, 8721, 8721, '0', 0, 0, 0, 0, 257.88714599609375, 1798.9947509765625, 59.36203765869140625, 2.998440504074096679, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Highland Shoat (Area: Drustvar - Difficulty: 0) CreateObject2 +(@CGUID+72, 130165, 1643, 8721, 8721, '0', 0, 0, 0, 0, 137.0850677490234375, 1800.236083984375, 47.79976272583007812, 3.190376758575439453, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Highland Shoat (Area: Drustvar - Difficulty: 0) CreateObject2 +(@CGUID+73, 129137, 1643, 8721, 8721, '0', 0, 0, 0, 0, 221.9739532470703125, 1759.8489990234375, 46.50286865234375, 1.046539068222045898, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Thicket Hare (Area: Drustvar - Difficulty: 0) CreateObject2 +(@CGUID+74, 129137, 1643, 8721, 8721, '0', 0, 0, 0, 0, 184.0069427490234375, 1847.8524169921875, 68.86716461181640625, 5.532693386077880859, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Thicket Hare (Area: Drustvar - Difficulty: 0) CreateObject2 +(@CGUID+75, 129137, 1643, 8721, 8721, '0', 0, 0, 0, 0, 224.0989532470703125, 1780.4896240234375, 53.014251708984375, 1.820018172264099121, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Thicket Hare (Area: Drustvar - Difficulty: 0) CreateObject2 +(@CGUID+76, 130164, 1643, 8721, 8721, '0', 0, 0, 0, 0, 235.0416717529296875, 1821.453125, 65.07635498046875, 3.144520521163940429, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Highland Boar (Area: Drustvar - Difficulty: 0) CreateObject2 +(@CGUID+77, 130164, 1643, 8721, 8721, '0', 0, 0, 0, 0, 237.467010498046875, 1810.3038330078125, 61.26643753051757812, 4.456104278564453125, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Highland Boar (Area: Drustvar - Difficulty: 0) CreateObject2 +(@CGUID+78, 130165, 1643, 8721, 0, '0', 0, 0, 0, 0, 301.670135498046875, 1771.6875, 53.27759552001953125, 2.725197315216064453, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Highland Shoat (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+79, 130164, 1643, 8721, 0, '0', 0, 0, 0, 0, 298.119781494140625, 1770.1475830078125, 54.21622467041015625, 2.399568557739257812, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Highland Boar (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+80, 130165, 1643, 8721, 0, '0', 0, 0, 0, 0, 302.640625, 1766.3228759765625, 53.81183624267578125, 2.959900856018066406, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Highland Shoat (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+81, 130165, 1643, 8721, 0, '0', 0, 0, 0, 0, 296.421875, 1766.46533203125, 54.8679351806640625, 1.135422468185424804, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Highland Shoat (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+82, 130165, 1643, 8721, 0, '0', 0, 0, 0, 0, 288.373260498046875, 1754.125, 57.2696990966796875, 5.143656730651855468, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Highland Shoat (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+83, 129137, 1643, 8721, 0, '0', 0, 0, 0, 0, 310.302093505859375, 1787.029541015625, 51.00532913208007812, 2.671998262405395507, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Thicket Hare (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+84, 129137, 1643, 8721, 0, '0', 0, 0, 0, 0, 257.34027099609375, 1759.8992919921875, 50.42948532104492187, 1.641331791877746582, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Thicket Hare (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+85, 129137, 1643, 8721, 0, '0', 0, 0, 0, 0, 271.142364501953125, 1765.1024169921875, 53.2971343994140625, 1.820018172264099121, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Thicket Hare (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+86, 130164, 1643, 8721, 0, '0', 0, 0, 0, 0, 290.94964599609375, 1722.29345703125, 62.46451568603515625, 5.912218093872070312, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Highland Boar (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+87, 130165, 1643, 8721, 0, '0', 0, 0, 0, 0, 296.95660400390625, 1757.3663330078125, 55.1655120849609375, 0.276633054018020629, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Highland Shoat (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+88, 130165, 1643, 8721, 0, '0', 0, 0, 0, 0, 308.133697509765625, 1753.420166015625, 53.80842208862304687, 0, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Highland Shoat (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+89, 1412, 1643, 8721, 0, '0', 0, 0, 0, 0, 214.15972900390625, 1714.142333984375, 29.64234161376953125, 0.40338173508644104, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Squirrel (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+90, 130164, 1643, 8721, 0, '0', 0, 0, 0, 0, 296.045135498046875, 1813.6805419921875, 59.5447998046875, 3.3182830810546875, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Highland Boar (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+91, 130165, 1643, 8721, 0, '0', 0, 0, 0, 0, 294.04339599609375, 1713.2066650390625, 58.48992156982421875, 2.149744987487792968, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Highland Shoat (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+92, 130165, 1643, 8721, 0, '0', 0, 0, 0, 0, 299.013885498046875, 1721.38720703125, 63.1525115966796875, 6.115296840667724609, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Highland Shoat (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+93, 129137, 1643, 8721, 0, '0', 0, 0, 0, 0, 267.14410400390625, 1772.5260009765625, 53.17105865478515625, 5.939667701721191406, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Thicket Hare (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+94, 130164, 1643, 8721, 0, '0', 0, 0, 0, 0, 298.76910400390625, 1751.8472900390625, 55.17011260986328125, 3.162820100784301757, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Highland Boar (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+95, 130165, 1643, 8721, 0, '0', 0, 0, 0, 0, 298.451385498046875, 1717.515625, 61.4291229248046875, 2.576797962188720703, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Highland Shoat (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+96, 130164, 1643, 8721, 0, '0', 0, 0, 0, 0, 273.552093505859375, 1812.6754150390625, 62.90400314331054687, 4.456104278564453125, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888), -- Highland Boar (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+97, 130165, 1643, 8721, 0, '0', 0, 0, 0, 0, 289.619781494140625, 1806.8785400390625, 59.58362960815429687, 5.624402999877929687, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Highland Shoat (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+98, 130165, 1643, 8721, 0, '0', 0, 0, 0, 0, 293.125, 1804.1649169921875, 58.61663055419921875, 0, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Highland Shoat (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+99, 130165, 1643, 8721, 0, '0', 0, 0, 0, 0, 288.869781494140625, 1801.015625, 58.57543182373046875, 0.154909119009971618, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 59888), -- Highland Shoat (Area: 0 - Difficulty: 0) CreateObject2 +(@CGUID+100, 130164, 1643, 8721, 8721, '0', 0, 0, 0, 0, 295.013885498046875, 1727.21875, 64.9677734375, 5.456957340240478515, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59888); -- Highland Boar (Area: Drustvar - Difficulty: 0) CreateObject2 +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+100; +INSERT INTO `creature_addon` (`guid`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+4, 0, 0, 0, 0, 0, 1, 0, 418, 0, 0, 0, 0, '123169'), -- Lowlands Doe - 123169 - Mod Scale 105-110% +(@CGUID+8, 0, 0, 0, 0, 0, 1, 0, 418, 0, 0, 0, 0, '123169'), -- Lowlands Doe - 123169 - Mod Scale 105-110% +(@CGUID+9, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123169'), -- Lowlands Greatstag - 123169 - Mod Scale 105-110% +(@CGUID+11, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123169'), -- Lowlands Doe - 123169 - Mod Scale 105-110% +(@CGUID+13, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123169'), -- Lowlands Doe - 123169 - Mod Scale 105-110% +(@CGUID+15, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Harbor Gull +(@CGUID+24, 0, 0, 0, 0, 0, 1, 0, 418, 0, 0, 0, 0, '123169'), -- Lowlands Doe - 123169 - Mod Scale 105-110% +(@CGUID+26, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123169'), -- Lowlands Greatstag - 123169 - Mod Scale 105-110% +(@CGUID+30, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Harbor Gull +(@CGUID+44, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''); -- Harbor Gull + +UPDATE `creature` SET `StringId` = 'ChannelPerched' WHERE `guid` IN (7001596, @CGUID+1, @CGUID+0, @CGUID+3, @CGUID+12, @CGUID+14); + +-- Template Addon +DELETE FROM `creature_template_addon` WHERE `entry` IN (128384,128385,124170); +INSERT INTO `creature_template_addon` (`entry`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(128384, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123169'), -- 128384 (Lowlands Greatstag) - Mod Scale 105-110% +(128385, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123169'), -- 128385 (Lowlands Doe) - Mod Scale 105-110% +(124170, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '247043'); -- 124170 (Fallhaven Pig) - Possessed + +-- Difficulty +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10000000, `VerifiedBuild`=59888 WHERE (`Entry`=128384 AND `DifficultyID`=0); -- 128384 (Lowlands Greatstag) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10000000, `VerifiedBuild`=59888 WHERE (`Entry`=128385 AND `DifficultyID`=0); -- 128385 (Lowlands Doe) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10000000, `VerifiedBuild`=59888 WHERE (`Entry`=128386 AND `DifficultyID`=0); -- 128386 (Lowlands Fawn) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10000000, `VerifiedBuild`=59888 WHERE (`Entry`=130160 AND `DifficultyID`=0); -- 130160 (Saltrock Terrapin) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x30000000, `VerifiedBuild`=59888 WHERE (`Entry`=128625 AND `DifficultyID`=0); -- 128625 (Harbor Gull) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x30000000, `VerifiedBuild`=59888 WHERE (`Entry`=124921 AND `DifficultyID`=0); -- 124921 (Harbor Raven) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10000000, `VerifiedBuild`=59888 WHERE (`Entry`=130165 AND `DifficultyID`=0); -- 130165 (Highland Shoat) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10000000, `VerifiedBuild`=59888 WHERE (`Entry`=130164 AND `DifficultyID`=0); -- 130164 (Highland Boar) - CanSwim + +-- Path for Bonepicker Raven +SET @MOVERGUID := @CGUID+2; +SET @ENTRY := 124382; +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.8683, 'Bonepicker 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, 34.172924, 1977.7473, 74.063156, NULL, 0), +(@PATH, 1, 44.552513, 1972.8416, 74.063156, NULL, 0), +(@PATH, 2, 48.423122, 1962.0332, 74.063156, NULL, 0), +(@PATH, 3, 43.517403, 1951.6537, 74.063156, NULL, 0), +(@PATH, 4, 32.709057, 1947.7831, 74.063156, NULL, 0), +(@PATH, 5, 22.329468, 1952.6887, 74.063156, NULL, 0), +(@PATH, 6, 18.458858, 1963.4971, 74.063156, NULL, 0), +(@PATH, 7, 23.364582, 1973.8767, 74.063156, NULL, 0), +(@PATH, 8, 34.172924, 1977.7473, 74.063156, 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, '248065'); + +-- Path for Harbor Raven +SET @MOVERGUID := @CGUID+29; +SET @ENTRY := 124921; +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.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, 58.685104, 1717.1309, 50.95585, NULL, 0), +(@PATH, 1, 55.672493, 1702.1229, 50.95585, NULL, 0), +(@PATH, 2, 42.93003, 1693.6409, 50.95585, NULL, 0), +(@PATH, 3, 27.922075, 1696.6534, 50.95585, NULL, 0), +(@PATH, 4, 19.440083, 1709.396, 50.95585, NULL, 0), +(@PATH, 5, 22.45269, 1724.4039, 50.95585, NULL, 0), +(@PATH, 6, 35.195156, 1732.8859, 50.95585, NULL, 0), +(@PATH, 7, 50.203114, 1729.8733, 50.95585, 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+34; +SET @ENTRY := 124921; +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.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, 7.1087165, 1702.6083, 22.505447, NULL, 0), +(@PATH, 1, 4.096103, 1687.6003, 22.505447, NULL, 0), +(@PATH, 2, -8.646359, 1679.1183, 22.505447, NULL, 0), +(@PATH, 3, -23.654314, 1682.1309, 22.505447, NULL, 0), +(@PATH, 4, -32.136307, 1694.8734, 22.505447, NULL, 0), +(@PATH, 5, -29.1237, 1709.8813, 22.505447, NULL, 0), +(@PATH, 6, -16.381231, 1718.3633, 22.505447, NULL, 0), +(@PATH, 7, -1.3732764, 1715.3507, 22.505447, 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 Highland Boar +SET @MOVERGUID := @CGUID+76; +SET @ENTRY := 130164; +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, 1, 0x0, NULL, 'Highland Boar - 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, 186.92188, 1822.4271, 59.86056, NULL, 0), +(@PATH, 1, 203.50174, 1821.2084, 59.443653, NULL, 0), +(@PATH, 2, 214.90973, 1821.9392, 61.304222, NULL, 0), +(@PATH, 3, 222.61285, 1821.4132, 63.32054, NULL, 0), +(@PATH, 4, 231.75348, 1818.8889, 63.739334, NULL, 7167), +(@PATH, 5, 214.90973, 1821.9392, 61.304222, NULL, 0), +(@PATH, 6, 203.50174, 1821.2084, 59.443653, NULL, 0), +(@PATH, 7, 186.92188, 1822.4271, 59.86056, NULL, 0), +(@PATH, 8, 171.61111, 1829.2517, 59.00619, NULL, 0), +(@PATH, 9, 162.57118, 1838.4757, 62.08969, NULL, 0), +(@PATH, 10, 145.13542, 1851.2223, 62.800232, NULL, 3396), +(@PATH, 11, 162.57118, 1838.4757, 62.08969, NULL, 0), +(@PATH, 12, 171.61111, 1829.2517, 59.00619, 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 Highland Boar +SET @MOVERGUID := @CGUID+100; +SET @ENTRY := 130164; +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, 'Highland Boar - 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, 306.84897, 1714.3646, 60.256668, NULL, 0), +(@PATH, 1, 303.77258, 1704.5591, 55.195457, NULL, 0), +(@PATH, 2, 293.53473, 1695.1528, 49.001842, NULL, 0), +(@PATH, 3, 285.64236, 1692.0817, 45.856476, NULL, 0), +(@PATH, 4, 276.46008, 1698.5747, 47.659725, NULL, 0), +(@PATH, 5, 275.95486, 1706.9966, 51.69615, NULL, 0), +(@PATH, 6, 266.07465, 1713.3524, 52.411064, NULL, 0), +(@PATH, 7, 258.87326, 1718.1267, 53.789276, NULL, 0), +(@PATH, 8, 251.07466, 1719.3438, 53.94587, NULL, 5006), +(@PATH, 9, 258.87326, 1718.1267, 53.789276, NULL, 0), +(@PATH, 10, 266.07465, 1713.3524, 52.411064, NULL, 0), +(@PATH, 11, 275.95486, 1706.9966, 51.69615, NULL, 0), +(@PATH, 12, 276.46008, 1698.5747, 47.659725, NULL, 0), +(@PATH, 13, 285.64236, 1692.0817, 45.856476, NULL, 0), +(@PATH, 14, 293.53473, 1695.1528, 49.001842, NULL, 0), +(@PATH, 15, 303.77258, 1704.5591, 55.195457, NULL, 0), +(@PATH, 16, 306.84897, 1714.3646, 60.256668, NULL, 0), +(@PATH, 17, 303.96527, 1724.151, 64.340256, NULL, 8404); + +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 Highland Boar +DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+79; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@CGUID+79, @CGUID+79, 0, 0, 515, 0, 0), +(@CGUID+79, @CGUID+78, 3, 90, 515, 0, 0), +(@CGUID+79, @CGUID+80, 3, 180, 515, 0, 0), +(@CGUID+79, @CGUID+81, 3, 270, 515, 0, 0); + +SET @MOVERGUID := @CGUID+79; +SET @ENTRY := 130164; +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, 'Highland Boar - Formation Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 274.88715, 1778.7795, 54.047234, NULL, 0), +(@PATH, 1, 257.68057, 1775.7899, 54.880978, NULL, 0), +(@PATH, 2, 242.90451, 1774.3142, 53.9317, NULL, 0), +(@PATH, 3, 227.68924, 1754.8403, 46.47596, NULL, 0), +(@PATH, 4, 215.46701, 1741.9896, 41.369293, NULL, 0), +(@PATH, 5, 207.77605, 1739.6337, 40.089867, NULL, 0), +(@PATH, 6, 206.9375, 1740.1807, 40.134224, NULL, 0), +(@PATH, 7, 206.09961, 1740.7275, 40.422874, NULL, 0), +(@PATH, 8, 204.42383, 1741.8213, 40.660545, NULL, 0), +(@PATH, 9, 203.58594, 1742.3682, 40.44428, NULL, 0), +(@PATH, 10, 201.07227, 1744.0088, 40.751144, NULL, 0), +(@PATH, 11, 200.23438, 1744.5557, 40.501465, NULL, 0), +(@PATH, 12, 199.39648, 1745.1025, 40.72397, NULL, 0), +(@PATH, 13, 196.04492, 1747.29, 40.964256, NULL, 0), +(@PATH, 14, 195.20703, 1747.8369, 40.777294, NULL, 0), +(@PATH, 15, 193.53125, 1748.9307, 40.591423, NULL, 0), +(@PATH, 16, 191.85547, 1750.0244, 40.933094, NULL, 0), +(@PATH, 17, 191.01758, 1750.5713, 40.659744, NULL, 0), +(@PATH, 18, 190.32292, 1751.0365, 40.585167, NULL, 0), +(@PATH, 19, 182.88542, 1767.4115, 43.037994, NULL, 0), +(@PATH, 20, 178.09961, 1780.5771, 47.58781, NULL, 0), +(@PATH, 21, 186.40973, 1795.401, 51.47758, NULL, 0), +(@PATH, 22, 199.02605, 1802.658, 53.033188, NULL, 0), +(@PATH, 23, 207.46355, 1799.8993, 53.5881, NULL, 0), +(@PATH, 24, 217.07118, 1792.2656, 54.565163, NULL, 0), +(@PATH, 25, 228.23611, 1784.7709, 53.9877, NULL, 0), +(@PATH, 26, 237.63194, 1777.441, 54.25532, NULL, 0), +(@PATH, 27, 249.63281, 1777.6406, 55.27042, NULL, 0), +(@PATH, 28, 267.6328, 1778.0801, 54.230186, NULL, 0), +(@PATH, 29, 283.7587, 1776.3055, 54.32863, NULL, 0), +(@PATH, 30, 291.87326, 1769.493, 54.817894, NULL, 0), +(@PATH, 31, 302.2639, 1763.9774, 54.093163, NULL, 11456); + +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); |