DB/Spawns: Added Darkmaul Citadel critters in NPE/Exiles Reach

Closes #28233

1 files changed, 163 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_09_09_02_world.sql b/sql/updates/world/master/2022_09_09_02_world.sql
new file mode 100644
index 00000000000..08e4a80674f
--- /dev/null
+++ b/sql/updates/world/master/2022_09_09_02_world.sql
@@ -0,0 +1,163 @@
+SET @CGUID := 1051442;
+
+-- Creature
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+66;
+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`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(@CGUID+0, 164827, 2175, 10424, 10588, '0', 0, 0, 0, 0, 328.957977294921875, -2346.54736328125, 103.62933349609375, 4.163355350494384765, 7200, 0, 0, 155, 0, 0, 0, 0, 0, 45114), -- Sharpbeak Hawk (Area: -Unknown- - Difficulty: 0)
+(@CGUID+1, 165758, 2175, 10424, 10588, '0', 0, 0, 0, 0, 285.93402099609375, -2295.882080078125, 79.40378570556640625, 5.156900405883789062, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 45114), -- Spotted Hopper (Area: -Unknown- - Difficulty: 0)
+(@CGUID+2, 165758, 2175, 10424, 10588, '0', 0, 0, 0, 0, 294.78125, -2307.060791015625, 79.40378570556640625, 4.905873298645019531, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 45114), -- Spotted Hopper (Area: -Unknown- - Difficulty: 0)
+(@CGUID+3, 165758, 2175, 10424, 10588, '0', 0, 0, 0, 0, 286.743072509765625, -2317.173583984375, 79.40378570556640625, 2.575829029083251953, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 45114), -- Spotted Hopper (Area: -Unknown- - Difficulty: 0)
+(@CGUID+4, 172028, 2175, 10424, 10588, '0', 0, 0, 0, 0, 426.84722900390625, -2317.6875, 127.4378433227539062, 2.185167312622070312, 7200, 0, 0, 124, 0, 0, 0, 0, 0, 45114), -- Mountain Roamer (Area: -Unknown- - Difficulty: 0)
+(@CGUID+5, 165757, 2175, 10424, 10588, '0', 0, 0, 0, 0, 266.618072509765625, -2287.744873046875, 81.45318603515625, 0.679411292076110839, 7200, 0, 0, 3, 0, 0, 0, 0, 0, 45114), -- Prairie Dog (Area: -Unknown- - Difficulty: 0)
+(@CGUID+6, 154268, 2175, 10424, 10588, '0', 0, 0, 0, 0, 228.875640869140625, -2290.54248046875, 108.5223770141601562, 3.674787044525146484, 7200, 10, 0, 113, 0, 1, 0, 0, 0, 45114), -- Hungry Vulture (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement)
+(@CGUID+7, 172029, 2175, 10424, 10588, '0', 0, 0, 0, 0, 414.461822509765625, -2300.1806640625, 111.46832275390625, 0.435241490602493286, 7200, 0, 0, 124, 0, 0, 0, 0, 0, 45114), -- Prickly Porcupine (Area: -Unknown- - Difficulty: 0)
+(@CGUID+8, 165757, 2175, 10424, 10588, '0', 0, 0, 0, 0, 271.87847900390625, -2290.345458984375, 81.46312713623046875, 1.127977609634399414, 7200, 0, 0, 3, 0, 0, 0, 0, 0, 45114), -- Prairie Dog (Area: -Unknown- - Difficulty: 0)
+(@CGUID+9, 165758, 2175, 10424, 10588, '0', 0, 0, 0, 0, 285.467010498046875, -2299.65283203125, 79.40378570556640625, 0, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 45114), -- Spotted Hopper (Area: -Unknown- - Difficulty: 0)
+(@CGUID+10, 172028, 2175, 10424, 10588, '0', 0, 0, 0, 0, 410.833343505859375, -2332.079833984375, 121.7001876831054687, 3.1136932373046875, 7200, 0, 0, 124, 0, 0, 0, 0, 0, 45114), -- Mountain Roamer (Area: -Unknown- - Difficulty: 0)
+(@CGUID+11, 165758, 2175, 10424, 10588, '0', 0, 0, 0, 0, 295.109375, -2310.923583984375, 79.40378570556640625, 2.555430412292480468, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 45114), -- Spotted Hopper (Area: -Unknown- - Difficulty: 0)
+(@CGUID+12, 165757, 2175, 10424, 10588, '0', 0, 0, 0, 0, 266.5625, -2286.822998046875, 81.42684173583984375, 0.679411292076110839, 7200, 0, 0, 3, 0, 0, 0, 0, 0, 45114), -- Prairie Dog (Area: -Unknown- - Difficulty: 0)
+(@CGUID+13, 172029, 2175, 10424, 10588, '0', 0, 0, 0, 0, 414.619781494140625, -2298.600830078125, 111.1724929809570312, 6.079207420349121093, 7200, 0, 0, 124, 0, 0, 0, 0, 0, 45114), -- Prickly Porcupine (Area: -Unknown- - Difficulty: 0)
+(@CGUID+14, 165757, 2175, 10424, 10588, '0', 0, 0, 0, 0, 270.8819580078125, -2290.30029296875, 81.3974456787109375, 1.127977609634399414, 7200, 0, 0, 3, 0, 0, 0, 0, 0, 45114), -- Prairie Dog (Area: -Unknown- - Difficulty: 0)
+(@CGUID+15, 165758, 2175, 10424, 10588, '0', 0, 0, 0, 0, 288.583343505859375, -2297.140625, 79.40378570556640625, 3.645235538482666015, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 45114), -- Spotted Hopper (Area: -Unknown- - Difficulty: 0)
+(@CGUID+16, 164827, 2175, 10424, 10588, '0', 0, 0, 0, 0, 317.76031494140625, -2269.1728515625, 116.0819320678710937, 1.322083711624145507, 7200, 0, 0, 155, 0, 0, 0, 0, 0, 45114), -- Sharpbeak Hawk (Area: -Unknown- - Difficulty: 0)
+(@CGUID+17, 165757, 2175, 10424, 10588, '0', 0, 0, 0, 0, 266.111114501953125, -2282.267333984375, 81.43719482421875, 0.001870071748271584, 7200, 0, 0, 3, 0, 0, 0, 0, 0, 45114), -- Prairie Dog (Area: -Unknown- - Difficulty: 0)
+(@CGUID+18, 165757, 2175, 10424, 10588, '0', 0, 0, 0, 0, 270.30902099609375, -2289.760498046875, 81.4036102294921875, 1.127977609634399414, 7200, 0, 0, 3, 0, 0, 0, 0, 0, 45114), -- Prairie Dog (Area: -Unknown- - Difficulty: 0)
+(@CGUID+19, 165758, 2175, 10424, 10588, '0', 0, 0, 0, 0, 292.868072509765625, -2309.4775390625, 79.40378570556640625, 4.905873298645019531, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 45114), -- Spotted Hopper (Area: -Unknown- - Difficulty: 0)
+(@CGUID+20, 165757, 2175, 10424, 10588, '0', 0, 0, 0, 0, 272.4600830078125, -2282.241455078125, 89.66510772705078125, 3.95679783821105957, 7200, 0, 0, 3, 0, 0, 0, 0, 0, 45114), -- Prairie Dog (Area: -Unknown- - Difficulty: 0)
+(@CGUID+21, 165758, 2175, 10424, 10588, '0', 0, 0, 0, 0, 287.076385498046875, -2296.28466796875, 79.40378570556640625, 0, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 45114), -- Spotted Hopper (Area: -Unknown- - Difficulty: 0))
+(@CGUID+22, 165758, 2175, 10424, 10588, '0', 0, 0, 0, 0, 288.005218505859375, -2298.921875, 79.40378570556640625, 2.576819896697998046, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 45114), -- Spotted Hopper (Area: -Unknown- - Difficulty: 0)
+(@CGUID+23, 154268, 2175, 10424, 10588, '0', 0, 0, 0, 0, 237.0532379150390625, -2323.0849609375, 110.3733367919921875, 5.413966178894042968, 7200, 0, 0, 113, 0, 0, 0, 0, 0, 45114), -- Hungry Vulture (Area: -Unknown- - Difficulty: 0)
+(@CGUID+24, 165757, 2175, 10424, 10588, '0', 0, 0, 0, 0, 266.15972900390625, -2281.3369140625, 81.4508056640625, 0.001870071748271584, 7200, 0, 0, 3, 0, 0, 0, 0, 0, 45114), -- Prairie Dog (Area: -Unknown- - Difficulty: 0)
+(@CGUID+25, 165758, 2175, 10424, 10588, '0', 0, 0, 0, 0, 296.12152099609375, -2309.3369140625, 79.40378570556640625, 2.42406630516052246, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 45114), -- Spotted Hopper (Area: -Unknown- - Difficulty: 0)
+(@CGUID+26, 165757, 2175, 10424, 10588, '0', 0, 0, 0, 0, 266.039947509765625, -2286.458251953125, 81.49481964111328125, 0.679411292076110839, 7200, 0, 0, 3, 0, 0, 0, 0, 0, 45114), -- Prairie Dog (Area: -Unknown- - Difficulty: 0)
+(@CGUID+27, 154301, 2175, 10424, 10588, '0', 0, 0, 0, 0, 16.42708396911621093, -2511.819580078125, 78.82154083251953125, 5.663975715637207031, 7200, 0, 0, 124, 0, 0, 0, 0, 0, 45114), -- Lindie Springstock (Area: -Unknown- - Difficulty: 0) (Auras: 305513 - -Unknown-)
+(@CGUID+28, 154268, 2175, 10424, 10588, '0', 0, 0, 0, 0, 184.280364990234375, -2291.67236328125, 126.892486572265625, 2.585401296615600585, 7200, 10, 0, 136, 0, 1, 0, 0, 0, 45114), -- Hungry Vulture (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement)
+(@CGUID+29, 172029, 2175, 10424, 10588, '0', 0, 0, 0, 0, 386.789947509765625, -2285.90625, 105.310638427734375, 1.936057329177856445, 7200, 0, 0, 124, 0, 0, 0, 0, 0, 45114), -- Prickly Porcupine (Area: -Unknown- - Difficulty: 0)
+(@CGUID+30, 165758, 2175, 10424, 10588, '0', 0, 0, 0, 0, 285.3194580078125, -2297.116455078125, 79.40378570556640625, 0, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 45114), -- Spotted Hopper (Area: -Unknown- - Difficulty: 0)
+(@CGUID+31, 165758, 2175, 10424, 10588, '0', 0, 0, 0, 0, 299.576385498046875, -2306.85595703125, 79.40378570556640625, 2.575829029083251953, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 45114), -- Spotted Hopper (Area: -Unknown- - Difficulty: 0)
+(@CGUID+32, 172028, 2175, 10424, 10588, '0', 0, 0, 0, 0, 435.098968505859375, -2332.723876953125, 138.3422088623046875, 3.57601475715637207, 7200, 0, 0, 124, 0, 0, 0, 0, 0, 45114), -- Mountain Roamer (Area: -Unknown- - Difficulty: 0)
+(@CGUID+33, 172028, 2175, 10424, 10568, '0', 0, 0, 0, 0, 453.821197509765625, -2304.623291015625, 141.1075439453125, 2.185167312622070312, 7200, 0, 0, 124, 0, 0, 0, 0, 0, 45114), -- Mountain Roamer (Area: -Unknown- - Difficulty: 0)
+(@CGUID+34, 164827, 2175, 10424, 10568, '0', 0, 0, 0, 0, 329.2786865234375, -2153.822265625, 126.2316436767578125, 3.636197090148925781, 7200, 0, 0, 155, 0, 0, 0, 0, 0, 45114), -- Sharpbeak Hawk (Area: -Unknown- - Difficulty: 0)
+(@CGUID+35, 165727, 2175, 10424, 10568, '0', 0, 0, 0, 0, 283.144622802734375, -2154.93603515625, 103.1320877075195312, 3.978484630584716796, 7200, 0, 0, 99, 0, 0, 0, 0, 0, 45114), -- Plains Doe (Area: -Unknown- - Difficulty: 0)
+(@CGUID+36, 165730, 2175, 10424, 10568, '0', 0, 0, 0, 0, 264.626953125, -2139.5, 101.42669677734375, 1.662693619728088378, 7200, 0, 0, 149, 0, 0, 0, 0, 0, 45114), -- Plains Stag (Area: -Unknown- - Difficulty: 0)
+(@CGUID+37, 165757, 2175, 10424, 10568, '0', 0, 0, 0, 0, 251.7581634521484375, -2152.89990234375, 99.25089263916015625, 1.056822061538696289, 7200, 10, 0, 3, 0, 1, 0, 0, 0, 45114), -- Prairie Dog (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement)
+(@CGUID+38, 165757, 2175, 10424, 10568, '0', 0, 0, 0, 0, 247.7708282470703125, -2150.63720703125, 100.6016464233398437, 5.83673715591430664, 7200, 0, 0, 3, 0, 0, 0, 0, 0, 45114), -- Prairie Dog (Area: -Unknown- - Difficulty: 0)
+(@CGUID+39, 164827, 2175, 10424, 10568, '0', 0, 0, 0, 0, 323.921630859375, -2086.713623046875, 131.389373779296875, 3.845774650573730468, 7200, 0, 0, 155, 0, 0, 0, 0, 0, 45114), -- Sharpbeak Hawk (Area: -Unknown- - Difficulty: 0)
+(@CGUID+40, 164827, 2175, 10424, 10568, '0', 0, 0, 0, 0, 252.2896728515625, -2107.99365234375, 123.64117431640625, 2.509568214416503906, 7200, 0, 0, 155, 0, 0, 0, 0, 0, 45114), -- Sharpbeak Hawk (Area: -Unknown- - Difficulty: 0)
+(@CGUID+41, 165711, 2175, 10424, 10568, '0', 0, 0, 0, 0, 313.7698974609375, -2075.169677734375, 113.00665283203125, 5.820971012115478515, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 45114), -- Plains Fawn (Area: -Unknown- - Difficulty: 0)
+(@CGUID+42, 165711, 2175, 10424, 10568, '0', 0, 0, 0, 0, 320.180938720703125, -2072.487548828125, 113.1185531616210937, 0.39623001217842102, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 45114), -- Plains Fawn (Area: -Unknown- - Difficulty: 0)
+(@CGUID+43, 171997, 2175, 10424, 10568, '0', 0, 0, 0, 0, 320.723968505859375, -2074.17529296875, 116.7222824096679687, 1.691510438919067382, 7200, 0, 0, 149, 0, 0, 0, 0, 0, 45114), -- Woodlands Watcher (Area: -Unknown- - Difficulty: 0)
+(@CGUID+44, 171997, 2175, 10424, 10530, '0', 0, 0, 0, 0, 333.52777099609375, -2065.17529296875, 116.3958663940429687, 3.100680112838745117, 7200, 0, 0, 149, 0, 0, 0, 0, 0, 45114), -- Woodlands Watcher (Area: -Unknown- - Difficulty: 0)
+(@CGUID+45, 165711, 2175, 10424, 10530, '0', 0, 0, 0, 0, 316.452789306640625, -2068.62744140625, 112.66851806640625, 0.442364901304244995, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 45114), -- Plains Fawn (Area: -Unknown- - Difficulty: 0)
+(@CGUID+46, 165727, 2175, 10424, 10530, '0', 0, 0, 0, 0, 325.546875, -2060.920166015625, 112.937652587890625, 2.700356960296630859, 7200, 0, 0, 99, 0, 0, 0, 0, 0, 45114), -- Plains Doe (Area: -Unknown- - Difficulty: 0)
+(@CGUID+47, 165727, 2175, 10424, 10530, '0', 0, 0, 0, 0, 313.43402099609375, -2056.420166015625, 112.16375732421875, 0.380261570215225219, 7200, 0, 0, 99, 0, 0, 0, 0, 0, 45114), -- Plains Doe (Area: -Unknown- - Difficulty: 0)
+(@CGUID+48, 165757, 2175, 10424, 10530, '0', 0, 0, 0, 0, 322.432281494140625, -2053.3125, 112.2863845825195312, 0.93129730224609375, 7200, 0, 0, 3, 0, 0, 0, 0, 0, 45114), -- Prairie Dog (Area: -Unknown- - Difficulty: 0)
+(@CGUID+49, 165757, 2175, 10424, 10530, '0', 0, 0, 0, 0, 322.135406494140625, -2052.859375, 112.2583084106445312, 0.615994453430175781, 7200, 0, 0, 3, 0, 0, 0, 0, 0, 45114), -- Prairie Dog (Area: -Unknown- - Difficulty: 0)
+(@CGUID+50, 171997, 2175, 10424, 10530, '0', 0, 0, 0, 0, 325.3125, -2054.7744140625, 115.23748779296875, 3.452181100845336914, 7200, 0, 0, 149, 0, 0, 0, 0, 0, 45114), -- Woodlands Watcher (Area: -Unknown- - Difficulty: 0)
+(@CGUID+51, 165757, 2175, 10424, 10530, '0', 0, 0, 0, 0, 323.6007080078125, -2054.26220703125, 112.3975296020507812, 1.31756591796875, 7200, 0, 0, 3, 0, 0, 0, 0, 0, 45114), -- Prairie Dog (Area: -Unknown- - Difficulty: 0)
+(@CGUID+52, 165757, 2175, 10424, 10530, '0', 0, 0, 0, 0, 322.9444580078125, -2053.861083984375, 112.3350753784179687, 0.93129730224609375, 7200, 0, 0, 3, 0, 0, 0, 0, 0, 45114), -- Prairie Dog (Area: -Unknown- - Difficulty: 0)
+(@CGUID+53, 164827, 2175, 10424, 10530, '0', 0, 0, 0, 0, 300.349334716796875, -2056.240966796875, 125.5921783447265625, 0.054645191878080368, 7200, 0, 0, 155, 0, 0, 0, 0, 0, 45114), -- Sharpbeak Hawk (Area: -Unknown- - Difficulty: 0)
+(@CGUID+54, 165730, 2175, 10424, 10530, '0', 0, 0, 0, 0, 314.49652099609375, -2052.26904296875, 112.5903396606445312, 5.860091209411621093, 7200, 0, 0, 149, 0, 0, 0, 0, 0, 45114), -- Plains Stag (Area: -Unknown- - Difficulty: 0)
+(@CGUID+55, 165757, 2175, 10424, 10530, '0', 0, 0, 0, 0, 320.220489501953125, -1982.2847900390625, 125.9277267456054687, 0.894634604454040527, 7200, 0, 0, 3, 0, 0, 0, 0, 0, 45114), -- Prairie Dog (Area: -Unknown- - Difficulty: 0)
+(@CGUID+56, 165757, 2175, 10424, 10530, '0', 0, 0, 0, 0, 320.546875, -1981.423583984375, 126.0230865478515625, 3.934155225753784179, 7200, 0, 0, 3, 0, 0, 0, 0, 0, 45114), -- Prairie Dog (Area: -Unknown- - Difficulty: 0)
+(@CGUID+57, 165757, 2175, 10424, 10530, '0', 0, 0, 0, 0, 320.71527099609375, -1982.5, 125.9539947509765625, 1.323416352272033691, 7200, 0, 0, 3, 0, 0, 0, 0, 0, 45114), -- Prairie Dog (Area: -Unknown- - Difficulty: 0)
+(@CGUID+58, 165757, 2175, 10424, 10530, '0', 0, 0, 0, 0, 319.71527099609375, -1981.8958740234375, 125.9195175170898437, 0.894634604454040527, 7200, 0, 0, 3, 0, 0, 0, 0, 0, 45114), -- Prairie Dog (Area: -Unknown- - Difficulty: 0)
+(@CGUID+59, 165757, 2175, 10424, 10530, '0', 0, 0, 0, 0, 319.598968505859375, -1981.3697509765625, 125.8683853149414062, 0.13941967487335205, 7200, 0, 0, 3, 0, 0, 0, 0, 0, 45114), -- Prairie Dog (Area: -Unknown- - Difficulty: 0)
+(@CGUID+60, 165757, 2175, 10424, 10530, '0', 0, 0, 0, 0, 319.914947509765625, -1982.1597900390625, 125.891632080078125, 0.894634604454040527, 7200, 0, 0, 3, 0, 0, 0, 0, 0, 45114), -- Prairie Dog (Area: -Unknown- - Difficulty: 0)
+(@CGUID+61, 165727, 2175, 10424, 10530, '0', 0, 0, 0, 0, 314.9444580078125, -1988.845458984375, 123.0555038452148437, 3.64621281623840332, 7200, 0, 0, 99, 0, 0, 0, 0, 0, 45114), -- Plains Doe (Area: -Unknown- - Difficulty: 0)
+(@CGUID+62, 165727, 2175, 10424, 10530, '0', 0, 0, 0, 0, 312.21527099609375, -1984.6007080078125, 122.2383956909179687, 4.164447307586669921, 7200, 0, 0, 99, 0, 0, 0, 0, 0, 45114), -- Plains Doe (Area: -Unknown- - Difficulty: 0)
+(@CGUID+63, 165711, 2175, 10424, 10530, '0', 0, 0, 0, 0, 276.529510498046875, -2012.8785400390625, 115.7943191528320312, 3.312581300735473632, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 45114), -- Plains Fawn (Area: -Unknown- - Difficulty: 0)
+(@CGUID+64, 165711, 2175, 10424, 10530, '0', 0, 0, 0, 0, 277.3507080078125, -2013.3646240234375, 115.8667678833007812, 3.312581300735473632, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 45114), -- Plains Fawn (Area: -Unknown- - Difficulty: 0)
+(@CGUID+65, 165727, 2175, 10424, 10530, '0', 0, 0, 0, 0, 276.510406494140625, -2014.9427490234375, 116.0030975341796875, 3.489482641220092773, 7200, 0, 0, 99, 0, 0, 0, 0, 0, 45114), -- Plains Doe (Area: -Unknown- - Difficulty: 0)
+(@CGUID+66, 165730, 2175, 10424, 10530, '0', 0, 0, 0, 0, 275.890625, -2011.6822509765625, 115.6985549926757812, 3.403353452682495117, 7200, 0, 0, 149, 0, 0, 0, 0, 0, 45114); -- Plains Stag (Area: -Unknown- - Difficulty: 0)
+
+-- Creature Addon
+DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+66;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(@CGUID+50, 0, 0, 50331649, 1, 0, 0, 0, 0, 0, ''), -- Woodlands Watcher
+(@CGUID+44, 0, 0, 50331649, 1, 0, 0, 0, 0, 0, ''), -- Woodlands Watcher
+(@CGUID+43, 0, 0, 50331649, 1, 0, 0, 0, 0, 0, ''), -- Woodlands Watcher
+(@CGUID+54, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Plains Stag
+(@CGUID+47, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Plains Doe
+(@CGUID+46, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Plains Doe
+(@CGUID+61, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Plains Doe
+(@CGUID+62, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Plains Doe
+(@CGUID+66, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''); -- Plains Stag
+
+-- Creature Template
+UPDATE `creature_template` SET `minlevel`=10, `maxlevel`=10, `faction`=7, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=172029; -- Prickly Porcupine
+
+-- Creature Movement Template
+DELETE FROM `creature_template_movement` WHERE `CreatureId` = 171997;
+INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`, `InteractionPauseTimer`) VALUES
+(171997, 0, 0, 1, 0, 0, 0, NULL);
+
+-- Waypoint and Formation Data for CGUID+36
+DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+36;
+INSERT INTO `creature_formations`(`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES
+(@CGUID+36, @CGUID+36, 0, 0, 515, 0, 0),
+(@CGUID+36, @CGUID+35, 3, 270, 515, 0, 0);
+
+SET @PATH := @CGUID+36 * 10;
+DELETE FROM `waypoint_data` WHERE `id`= @PATH;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES
+(@PATH, 0, 292.2483, -2095.484, 110.0487, NULL, 0),
+(@PATH, 1, 301.2083, -2103.156, 112.6425, NULL, 0),
+(@PATH, 2, 313.3229, -2110.276, 112.7873, NULL, 0),
+(@PATH, 3, 321.658, -2121.707, 113.3704, NULL, 0),
+(@PATH, 4, 307.9375, -2122.764, 111.9128, NULL, 0),
+(@PATH, 5, 294.3663, -2134.842, 107.8937, NULL, 0),
+(@PATH, 6, 288.1476, -2151.184, 105.2233, NULL, 0),
+(@PATH, 7, 265.0859, -2144.48, 101.9267, NULL, 0),
+(@PATH, 8, 263.1233, -2123.259, 101.9349, NULL, 0),
+(@PATH, 9, 272.7813, -2108.7, 105.8262, NULL, 0),
+(@PATH, 10, 282, -2095.637, 108.1517, NULL, 0);
+
+UPDATE `creature` SET `position_x`= 292.2483, `position_y`= -2095.484, `position_z`= 110.0487, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+36;
+DELETE FROM `creature_addon` WHERE `guid`= @CGUID+36;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES
+(@CGUID+36, @PATH, 1);
+
+-- Waypoints for CGUID+37
+SET @PATH := @CGUID+37 * 10;
+DELETE FROM `waypoint_data` WHERE `id`= @PATH;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`) VALUES
+(@PATH, 0, 249.3958, -2145.238, 97.91681, NULL, 0, 1),
+(@PATH, 1, 240.7465, -2145.413, 96.87872, NULL, 0, 1),
+(@PATH, 2, 241.4132, -2152.655, 97.46503, NULL, 0, 1),
+(@PATH, 3, 243.6267, -2156.481, 98.11224, NULL, 0, 1),
+(@PATH, 4, 247.6997, -2157.972, 99.23236, NULL, 0, 1),
+(@PATH, 5, 251.7587, -2152.899, 99.36078, NULL, 0, 1);
+
+UPDATE `creature` SET `position_x`= 249.3958, `position_y`= -2145.238, `position_z`= 97.91681, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+37;
+DELETE FROM `creature_addon` WHERE `guid`= @CGUID+37;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES
+(@CGUID+37, @PATH, 1);
+
+-- Waypoints and Formations for CGUID+42
+DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+42;
+INSERT INTO `creature_formations`(`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES
+(@CGUID+42, @CGUID+42, 0, 0, 515, 0, 0),
+(@CGUID+42, @CGUID+45, 3, 270, 515, 0, 0),
+(@CGUID+42, @CGUID+41, 3, 0, 515, 0, 0);
+
+SET @PATH := @CGUID+42 * 10;
+DELETE FROM `waypoint_data` WHERE `id`= @PATH;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES
+(@PATH, 0, 309.0191, -2072.701, 112.5153, NULL, 0),
+(@PATH, 1, 314.5781, -2074.832, 113.0838, NULL, 0),
+(@PATH, 2, 322.7656, -2071.406, 113.1346, NULL, 0),
+(@PATH, 3, 322.0035, -2068.616, 112.9584, NULL, 0),
+(@PATH, 4, 317.6788, -2067.882, 112.6673, NULL, 0),
+(@PATH, 5, 313.4805, -2065.168, 112.1918, NULL, 0),
+(@PATH, 6, 310.8681, -2059.47, 111.9928, NULL, 0),
+(@PATH, 7, 311.7153, -2051.214, 112.9325, NULL, 0),
+(@PATH, 8, 306.0295, -2047.418, 113.2781, NULL, 0),
+(@PATH, 9, 299.0762, -2054.605, 112.8848, NULL, 0),
+(@PATH, 10, 300.1823, -2063.073, 111.5201, NULL, 0),
+(@PATH, 11, 305.2691, -2068.134, 111.6536, NULL, 0);
+
+UPDATE `creature` SET `position_x`= 309.0191, `position_y`= -2072.701, `position_z`= 112.5153, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+42;
+DELETE FROM `creature_addon` WHERE `guid`= @CGUID+42;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES
+(@CGUID+42, @PATH, 1);