diff options
| -rw-r--r-- | sql/updates/world/master/2024_06_19_00_world.sql | 1061 |
1 files changed, 1061 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_06_19_00_world.sql b/sql/updates/world/master/2024_06_19_00_world.sql new file mode 100644 index 00000000000..6d01ca9700e --- /dev/null +++ b/sql/updates/world/master/2024_06_19_00_world.sql @@ -0,0 +1,1061 @@ +SET @CGUID := 7001159; +SET @OGUID := 7000335; + +-- Creature +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+190; +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`, `curHealthPct`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES +(@CGUID+0, 137034, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -571.02606201171875, -237.493057250976562, 236.1141204833984375, 1.07134711742401123, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Thistle Acolyte (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 267413 - Cosmetic Missile Transform) +(@CGUID+1, 137033, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -569.02777099609375, -247.725692749023437, 236.115203857421875, 0.593174397945404052, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Runic Disciple (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 267413 - Cosmetic Missile Transform) +(@CGUID+2, 137034, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -589.04864501953125, -236.845489501953125, 236.1165008544921875, 3.132869243621826171, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Thistle Acolyte (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 267413 - Cosmetic Missile Transform) +(@CGUID+3, 137033, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -590.91143798828125, -232.553817749023437, 236.1165008544921875, 4.219472885131835937, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Runic Disciple (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 267413 - Cosmetic Missile Transform) +(@CGUID+4, 131585, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -587.209716796875, -217.019607543945312, 249.5423431396484375, 4.667870521545410156, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Enthralled Guard (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 259712 - Enthralled) +(@CGUID+5, 137034, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -567.50347900390625, -270.649322509765625, 236.115234375, 5.487166404724121093, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Thistle Acolyte (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 267413 - Cosmetic Missile Transform) +(@CGUID+6, 137034, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -569.87677001953125, -243.135421752929687, 235.71575927734375, 0.195613443851470947, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Thistle Acolyte (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 267413 - Cosmetic Missile Transform) +(@CGUID+7, 135359, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -572.7257080078125, -259.947906494140625, 236.112335205078125, 4.211675167083740234, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Sister Solena (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 267413 - Cosmetic Missile Transform) +(@CGUID+8, 135358, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -572.34027099609375, -254.649307250976562, 236.36468505859375, 4.211675167083740234, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Sister Malady (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 267413 - Cosmetic Missile Transform) +(@CGUID+9, 137034, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -568.39410400390625, -274.588531494140625, 236.114532470703125, 1.339905619621276855, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Thistle Acolyte (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 267413 - Cosmetic Missile Transform) +(@CGUID+10, 120652, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -600.4600830078125, -259.513885498046875, 236.1165008544921875, 3.138837814331054687, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Global Affix Stalker (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+11, 135360, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -572.029541015625, -264.859375, 236.477783203125, 3.085693836212158203, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Sister Briar (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 267413 - Cosmetic Missile Transform) +(@CGUID+12, 137033, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -574.296875, -233.689239501953125, 236.11517333984375, 0.240302875638008117, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Runic Disciple (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 267413 - Cosmetic Missile Transform) +(@CGUID+13, 135240, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -588.46527099609375, -288.151031494140625, 236.1050872802734375, 2.932393789291381835, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Soul Essence (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+14, 131685, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -589.43927001953125, -219.397567749023437, 249.5423431396484375, 4.667777061462402343, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Runic Disciple (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+15, 137033, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -592.93927001953125, -235.092010498046875, 236.1165008544921875, 5.983878135681152343, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Runic Disciple (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 267413 - Cosmetic Missile Transform) +(@CGUID+16, 135240, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -593.44097900390625, -284.28125, 236.1165008544921875, 4.793862342834472656, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Soul Essence (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+17, 137048, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -564.6475830078125, -246.010421752929687, 236.1155242919921875, 3.550517797470092773, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Beguiled Villager (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 269121 - Cosmetic Beguiled) +(@CGUID+18, 135240, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -566.404541015625, -242.09375, 236.1143951416015625, 4.904598236083984375, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Soul Essence (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+19, 116633, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -571.18927001953125, -267.489593505859375, 189.703277587890625, 0, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Effect (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+20, 135240, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -570.81768798828125, -230.819442749023437, 236.11474609375, 4.607960700988769531, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Soul Essence (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+21, 137033, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -562.55035400390625, -270.970489501953125, 236.11614990234375, 3.373791933059692382, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Runic Disciple (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 267413 - Cosmetic Missile Transform) +(@CGUID+22, 137034, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -570.9774169921875, -287.258697509765625, 236.096588134765625, 0.87963569164276123, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Thistle Acolyte (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 267413 - Cosmetic Missile Transform) +(@CGUID+23, 137033, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -542.94964599609375, -254.725692749023437, 245.269439697265625, 4.352036952972412109, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Runic Disciple (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 267413 - Cosmetic Missile Transform) +(@CGUID+24, 135240, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -565.32464599609375, -277.258697509765625, 236.1145782470703125, 1.736617565155029296, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Soul Essence (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+25, 131585, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -566.89208984375, -195.686065673828125, 236.3025360107421875, 3.148679494857788085, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Enthralled Guard (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 259712 - Enthralled) +(@CGUID+26, 137033, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -540.951416015625, -260.102447509765625, 245.269439697265625, 3.221382379531860351, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Runic Disciple (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 267413 - Cosmetic Missile Transform) +(@CGUID+27, 135240, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -564.00518798828125, -268.166656494140625, 236.115875244140625, 4.22330474853515625, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Soul Essence (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+28, 135357, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -558.47222900390625, -259.2725830078125, 242.269927978515625, 3.109388589859008789, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Lady Waycrest (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 269118 - Cosmetic Missile Transform (Lady Waycrest)) +(@CGUID+29, 137033, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -563.9444580078125, -274.401031494140625, 236.11541748046875, 2.378868579864501953, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Runic Disciple (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 267413 - Cosmetic Missile Transform) +(@CGUID+30, 137048, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -570.75177001953125, -233.902786254882812, 236.114715576171875, 3.72335052490234375, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Beguiled Villager (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 269121 - Cosmetic Beguiled) +(@CGUID+31, 137034, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -541.9305419921875, -264.098968505859375, 245.269439697265625, 2.76560211181640625, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Thistle Acolyte (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 267413 - Cosmetic Missile Transform) +(@CGUID+32, 137048, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -593.08856201171875, -288.59722900390625, 236.1165008544921875, 0.74304431676864624, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Beguiled Villager (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 269121 - Cosmetic Beguiled) +(@CGUID+33, 137033, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -557.592041015625, -282.107635498046875, 249.56805419921875, 3.109470605850219726, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Runic Disciple (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 267413 - Cosmetic Missile Transform) +(@CGUID+34, 137033, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -567.701416015625, -284.779510498046875, 236.115020751953125, 4.3520355224609375, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Runic Disciple (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 267413 - Cosmetic Missile Transform) +(@CGUID+35, 137034, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -560.77777099609375, -285.22222900390625, 249.5779876708984375, 2.070507049560546875, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Thistle Acolyte (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 267413 - Cosmetic Missile Transform) +(@CGUID+36, 131587, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -566.87847900390625, -198.686050415039062, 236.208984375, 3.148666143417358398, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Bewitched Captain (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 259712 - Enthralled) +(@CGUID+37, 116633, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -570.2257080078125, -252.81597900390625, 190.171112060546875, 0, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Effect (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+38, 135240, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -562.64239501953125, -249.279510498046875, 236.11614990234375, 2.500848293304443359, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Soul Essence (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+39, 134041, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -537.1492919921875, -295.505218505859375, 236.111572265625, 5.501866340637207031, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Infected Peasant (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 266008 - Infected, 272860 - Cosmetic Thin Man Begging) +(@CGUID+40, 131666, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -533.65277099609375, -271.77777099609375, 235.934051513671875, 5.43984079360961914, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Coven Thornshaper (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+41, 131858, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -534.95489501953125, -278.836822509765625, 236.0850372314453125, 0.851217627525329589, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Thornguard (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+42, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -536.26947021484375, -301.89923095703125, 236.136077880859375, 2.365589141845703125, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%) +(@CGUID+43, 116633, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -563.00347900390625, -275.4132080078125, 190.0098419189453125, 0, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Effect (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+44, 131666, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -527.0867919921875, -279.923614501953125, 236.102294921875, 3.193425655364990234, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Coven Thornshaper (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+45, 135052, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -609.9375, -161.411453247070312, 235.6681060791015625, 0.304306626319885253, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Blight Toad (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+46, 135052, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -605.11114501953125, -165.319442749023437, 235.6681060791015625, 2.890430927276611328, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Blight Toad (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+47, 135234, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -561.6805419921875, -330.630218505859375, 249.580474853515625, 0.99009937047958374, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Diseased Mastiff (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%, 265630 - Mastiff Disease) +(@CGUID+48, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -533.86737060546875, -297.502685546875, 236.1360931396484375, 1.104825735092163085, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%, 278431 - Parasitic) +(@CGUID+49, 135234, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -562.54339599609375, -330.036468505859375, 236.112518310546875, 4.502013206481933593, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Diseased Mastiff (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%, 265630 - Mastiff Disease) +(@CGUID+50, 131850, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -559.3663330078125, -331.619781494140625, 249.5794525146484375, 0.910719037055969238, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Maddened Survivalist (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+51, 131849, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -560.46875, -327.008697509765625, 236.1114349365234375, 3.695490598678588867, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Crazed Marksman (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+52, 131850, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -564.39581298828125, -326.55035400390625, 236.1113739013671875, 4.548031330108642578, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Maddened Survivalist (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+53, 131849, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -586.49652099609375, -347.73089599609375, 235.7375946044921875, 1.860623478889465332, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Crazed Marksman (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+54, 135052, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -608.5850830078125, -167.772567749023437, 235.6681060791015625, 0.863629043102264404, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Blight Toad (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+55, 137830, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -534.4674072265625, -299.823974609375, 236.1360931396484375, 3.135935783386230468, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Pallid Gorger (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+56, 135711, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -592.66143798828125, -326.586822509765625, 237.138458251953125, 4.473574161529541015, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Hunting Map (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+57, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -539.27264404296875, -297.227996826171875, 236.3379974365234375, 2.469692468643188476, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%) +(@CGUID+58, 135474, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -610.25, -164.918411254882812, 235.6681060791015625, 3.295940637588500976, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Thistle Acolyte (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 269151 - Cosmetic Witch Frog Usage) +(@CGUID+59, 131850, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -588.1319580078125, -345.708343505859375, 235.7375946044921875, 5.884096622467041015, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Maddened Survivalist (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+60, 116633, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -562.75518798828125, -245.34375, 190.081329345703125, 0, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Effect (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+61, 135139, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -531.71875, -330.572906494140625, 236.111572265625, 0.031905733048915863, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Dead Villager (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 265448 - Permanent Feign Death On Spawn) +(@CGUID+62, 131823, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -568.6319580078125, -150.71875, 235.2671356201171875, 4.215025901794433593, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Sister Malady (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 272625 - Override Energy Bar Color, 261266 - Runic Ward) +(@CGUID+63, 131545, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -517.25, -260.104156494140625, 184.0252227783203125, 6.152141571044921875, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Lady Waycrest (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+64, 131587, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -516.30206298828125, -190.197921752929687, 236.116485595703125, 5.574076175689697265, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Bewitched Captain (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 259712 - Enthralled) +(@CGUID+65, 135234, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -558.09893798828125, -333.958343505859375, 249.5802154541015625, 1.205202937126159667, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Diseased Mastiff (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%, 265630 - Mastiff Disease) +(@CGUID+66, 131685, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -609.685791015625, -155.954864501953125, 249.51531982421875, 5.710288047790527343, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Runic Disciple (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+67, 131821, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -528.7725830078125, -335.376739501953125, 249.515350341796875, 2.098216772079467773, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Faceless Maiden (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+68, 116633, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -552.91143798828125, -276.984375, 189.8520355224609375, 0, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Effect (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+69, 131825, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -580.234375, -150.5625, 235.267547607421875, 5.491910934448242187, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Sister Briar (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 272627 - Override Energy Bar Color, 261265 - Ironbark Shield) +(@CGUID+70, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -532.68438720703125, -326.05157470703125, 236.1360931396484375, 0.751057803630828857, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%) +(@CGUID+71, 135139, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -521.44793701171875, -302.170135498046875, 236.111572265625, 3.358336210250854492, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Dead Villager (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 265448 - Permanent Feign Death On Spawn) +(@CGUID+72, 131824, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -574.73089599609375, -145.892364501953125, 235.2644805908203125, 4.778371334075927734, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Sister Solena (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 272626 - Override Energy Bar Color) +(@CGUID+73, 135048, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -537.25457763671875, -350.3045654296875, 236.136077880859375, 1.65627753734588623, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Gorestained Piglet (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+74, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -518.5155029296875, -303.159576416015625, 236.1361083984375, 3.967284917831420898, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%) +(@CGUID+75, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -529.19805908203125, -329.118072509765625, 236.1361083984375, 5.95155954360961914, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%, 278431 - Parasitic) +(@CGUID+76, 131685, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -538.53125, -322.052093505859375, 249.5301361083984375, 5.361541748046875, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Runic Disciple (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+77, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -521.76043701171875, -299.975921630859375, 236.1360931396484375, 2.779886484146118164, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%, 278431 - Parasitic) +(@CGUID+78, 131527, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -518.54864501953125, -268.505218505859375, 182.782318115234375, 2.667675733566284179, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Lord Waycrest (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+79, 137830, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -531.5643310546875, -299.840576171875, 236.1361083984375, 3.135821342468261718, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Pallid Gorger (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+80, 131669, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -505.18798828125, -266.95013427734375, 234.60888671875, 5.964896678924560546, 7200, 3, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Jagged Hound (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+81, 116633, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -552.6024169921875, -243.805557250976562, 190.20855712890625, 0, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Effect (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+82, 135049, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -605.9149169921875, -152.583328247070312, 249.51531982421875, 4.44603586196899414, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Dreadwing Raven (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+83, 135048, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -536.22430419921875, -313.56982421875, 236.454498291015625, 4.733040809631347656, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Gorestained Piglet (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+84, 131669, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -504.6319580078125, -252.536453247070312, 234.6051025390625, 6.14012002944946289, 7200, 3, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Jagged Hound (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+85, 116633, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -521.75, -281.420135498046875, 186.580352783203125, 0, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Effect (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+86, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -530.3836669921875, -332.695556640625, 236.1361083984375, 0.076816625893115997, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%) +(@CGUID+87, 116633, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -525.72393798828125, -242.579864501953125, 184.405548095703125, 0, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Effect (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+88, 131666, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -504.0142822265625, -260.8154296875, 234.60321044921875, 0.956529498100280761, 7200, 3, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Coven Thornshaper (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+89, 135139, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -537.02606201171875, -300.421875, 236.111572265625, 3.126610755920410156, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Dead Villager (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 265448 - Permanent Feign Death On Spawn) +(@CGUID+90, 134303, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -450.630218505859375, -321.42535400390625, 236.111572265625, 4.163387775421142578, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Summoning Portal (Area: Waycrest Manor - Difficulty: Mythic) CreateObject2 (Auras: 266070 - Cosmetic Visual) +(@CGUID+91, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -502.5791015625, -296.699798583984375, 236.1361083984375, 3.151485204696655273, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%, 278431 - Parasitic) +(@CGUID+92, 135048, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -514.404541015625, -319.395843505859375, 236.782196044921875, 5.541881561279296875, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Gorestained Piglet (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+93, 135234, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -575.22222900390625, -357.9913330078125, 235.7375946044921875, 5.594793319702148437, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Diseased Mastiff (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%, 265630 - Mastiff Disease) +(@CGUID+94, 135315, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -419.046875, -249.536453247070312, 246.3013763427734375, 4.576903820037841796, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Goliath Drain Target Female (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 259712 - Enthralled) +(@CGUID+95, 135714, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -523.95831298828125, -285.364593505859375, 227.90399169921875, 0, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Vinegared Wine (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+96, 131821, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -528.576416015625, -320.9913330078125, 249.5301361083984375, 4.115458011627197265, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Faceless Maiden (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+97, 132209, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -385.607635498046875, -257.765625, 236.37640380859375, 0, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Lightning Controller (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 260564 - Wildfire) +(@CGUID+98, 135713, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -511.4913330078125, -257.510406494140625, 236.73333740234375, 0, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Vile Pod (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+99, 131669, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -497.547943115234375, -262.49212646484375, 234.6028900146484375, 0.137453705072402954, 7200, 3, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Jagged Hound (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+100, 131585, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -519.2725830078125, -192.927078247070312, 236.1165008544921875, 6.031474113464355468, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Enthralled Guard (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 259712 - Enthralled) +(@CGUID+101, 132361, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -574.69097900390625, -151.559036254882812, 235.2676239013671875, 4.716972827911376953, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Focusing Iris (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 271079 - Cosmetic Focusing Iris Look) +(@CGUID+102, 131849, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -572.74481201171875, -359.986114501953125, 235.7375946044921875, 1.961302042007446289, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Crazed Marksman (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+103, 131669, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -498.031524658203125, -254.4959716796875, 234.6052703857421875, 5.341821670532226562, 7200, 3, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Jagged Hound (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+104, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -521.6878662109375, -302.930908203125, 236.1361083984375, 3.723121166229248046, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%) +(@CGUID+105, 135052, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -541.17706298828125, -150.880203247070312, 235.6681060791015625, 3.720450878143310546, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Blight Toad (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+106, 137830, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -515.37847900390625, -341.348968505859375, 236.79071044921875, 0.514622867107391357, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Pallid Gorger (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+107, 131667, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -415.598968505859375, -259.25347900390625, 236.1174774169921875, 3.168833017349243164, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Soulbound Goliath (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 261580 - Soul Harvest) +(@CGUID+108, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -495.857421875, -296.0693359375, 236.1361083984375, 2.022163867950439453, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%) +(@CGUID+109, 135513, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -528.57989501953125, -188.428817749023437, 237.617919921875, 5.5980987548828125, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Ancient Tome (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+110, 134303, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -496.454864501953125, -198.105911254882812, 244.4434356689453125, 4.163387775421142578, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Summoning Portal (Area: Waycrest Manor - Difficulty: Mythic) CreateObject2 (Auras: 266070 - Cosmetic Visual) +(@CGUID+111, 135049, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -544.39239501953125, -158.20660400390625, 249.51531982421875, 5.187650203704833984, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Dreadwing Raven (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+112, 116633, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -515.62677001953125, -275.661468505859375, 185.683502197265625, 0, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Effect (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+113, 135474, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -538.70831298828125, -155.852432250976562, 249.51531982421875, 3.939949512481689453, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Thistle Acolyte (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+114, 135052, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -543.232666015625, -157.227432250976562, 235.671173095703125, 3.720450878143310546, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Blight Toad (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+115, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -539.381591796875, -366.20379638671875, 236.1360931396484375, 1.778770089149475097, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%) +(@CGUID+116, 135474, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -540.842041015625, -154.08160400390625, 235.670135498046875, 0.101273626089096069, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Thistle Acolyte (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 269151 - Cosmetic Witch Frog Usage) +(@CGUID+117, 135052, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -538.0382080078125, -155.892364501953125, 235.6739044189453125, 3.720450878143310546, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Blight Toad (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+118, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -499.5068359375, -299.24951171875, 236.1361083984375, 5.580564022064208984, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%) +(@CGUID+119, 131685, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -542.61456298828125, -153.428817749023437, 249.515289306640625, 5.528810501098632812, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Runic Disciple (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+120, 116633, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -514.8194580078125, -242.359375, 186.4376983642578125, 0, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Effect (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+121, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -532.5440673828125, -359.704498291015625, 236.1360931396484375, 1.847705960273742675, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%) +(@CGUID+122, 135052, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -544.64581298828125, -153.272567749023437, 235.6681060791015625, 3.720450878143310546, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Blight Toad (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+123, 131585, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -493.507659912109375, -198.357635498046875, 236.0748748779296875, 0.002160806441679596, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Enthralled Guard (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 259712 - Enthralled) +(@CGUID+124, 131669, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -475.446441650390625, -246.423629760742187, 234.624786376953125, 6.208818912506103515, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Jagged Hound (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+125, 135049, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -515.8507080078125, -161.274307250976562, 251.8550872802734375, 4.810708522796630859, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Dreadwing Raven (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+126, 135048, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -482.848968505859375, -300.873260498046875, 236.1360931396484375, 3.488520145416259765, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Gorestained Piglet (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+127, 131669, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -475.3857421875, -271.826812744140625, 234.6963653564453125, 3.017324209213256835, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Jagged Hound (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+128, 135725, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -525.19964599609375, -342.869781494140625, 249.51483154296875, 2.40065169334411621, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Cursed Loom (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+129, 137830, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -494.7882080078125, -320.798614501953125, 235.70989990234375, 1.637995362281799316, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Pallid Gorger (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+130, 131669, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -472.66571044921875, -247.138961791992187, 234.60443115234375, 0.041875664144754409, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Jagged Hound (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+131, 131666, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -485.196197509765625, -259.9600830078125, 235.2390594482421875, 0.585030436515808105, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Coven Thornshaper (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+132, 135048, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -506.633697509765625, -340.185760498046875, 235.70989990234375, 5.806537151336669921, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Gorestained Piglet (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+133, 135139, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -536.44964599609375, -365.18402099609375, 236.111785888671875, 1.055417180061340332, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Dead Villager (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 265448 - Permanent Feign Death On Spawn) +(@CGUID+134, 131587, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -493.513885498046875, -195.357635498046875, 236.015960693359375, 0.002079832134768366, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Bewitched Captain (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 259712 - Enthralled) +(@CGUID+135, 131586, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -505.515625, -342.102447509765625, 236.109527587890625, 1.590731143951416015, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Banquet Steward (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 259716 - Enthralled) +(@CGUID+136, 131847, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -491.071197509765625, -321.02777099609375, 235.70989990234375, 2.982226848602294921, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Waycrest Reveler (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 259712 - Enthralled) +(@CGUID+137, 134041, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -531.39581298828125, -366.779510498046875, 236.1121063232421875, 1.961832404136657714, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Infected Peasant (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 266008 - Infected, 272860 - Cosmetic Thin Man Begging) +(@CGUID+138, 131669, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -474.291015625, -268.838653564453125, 234.6369171142578125, 3.326071023941040039, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Jagged Hound (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+139, 131669, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -474.708343505859375, -249.30029296875, 234.60333251953125, 0.031052092090249061, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Jagged Hound (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+140, 131858, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -476.541656494140625, -260.0225830078125, 235.2390594482421875, 3.538356542587280273, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Thornguard (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+141, 131669, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -473.839263916015625, -269.412567138671875, 234.6248931884765625, 3.442658424377441406, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Jagged Hound (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+142, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -532.39166259765625, -364.468902587890625, 236.1360931396484375, 2.194856882095336914, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%, 278431 - Parasitic) +(@CGUID+143, 135139, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -499.201385498046875, -298.083343505859375, 236.111572265625, 1.566159248352050781, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Dead Villager (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 265448 - Permanent Feign Death On Spawn) +(@CGUID+144, 131847, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -510.770843505859375, -339.87847900390625, 235.70989990234375, 4.05202341079711914, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Waycrest Reveler (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 259712 - Enthralled) +(@CGUID+145, 131847, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -471.552093505859375, -318.08160400390625, 236.109527587890625, 4.134391307830810546, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Waycrest Reveler (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 259712 - Enthralled) +(@CGUID+146, 135048, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -476.517364501953125, -338.3507080078125, 235.70989990234375, 0.178709819912910461, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Gorestained Piglet (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+147, 131586, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -477.74322509765625, -334.44073486328125, 235.771881103515625, 0.293698012828826904, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Banquet Steward (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 259716 - Enthralled) +(@CGUID+148, 131863, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -494.142364501953125, -345.82464599609375, 236.595184326171875, 1.550201058387756347, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Raal the Gluttonous (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+149, 135139, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -469.614593505859375, -300.338531494140625, 236.111572265625, 0.939325690269470214, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Dead Villager (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 265448 - Permanent Feign Death On Spawn) +(@CGUID+150, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -472.357421875, -301.5068359375, 236.1360931396484375, 1.392820477485656738, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%) +(@CGUID+151, 131847, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -475.03472900390625, -319.84375, 235.70989990234375, 0, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Waycrest Reveler (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 259712 - Enthralled) +(@CGUID+152, 135048, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -474.692718505859375, -337.05035400390625, 235.70989990234375, 4.976558685302734375, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Gorestained Piglet (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+153, 131685, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -483.97222900390625, -190.142364501953125, 236.116241455078125, 1.025903940200805664, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Runic Disciple (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+154, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -470.95074462890625, -297.82073974609375, 236.136077880859375, 0.168031617999076843, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%, 278431 - Parasitic) +(@CGUID+155, 131847, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -471.0694580078125, -322.1007080078125, 235.70989990234375, 2.284619331359863281, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Waycrest Reveler (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 259712 - Enthralled) +(@CGUID+156, 131585, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -480.630218505859375, -189.435760498046875, 236.116241455078125, 3.543432235717773437, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Enthralled Guard (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 259712 - Enthralled) +(@CGUID+157, 131669, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -471.4898681640625, -267.6510009765625, 234.6194610595703125, 3.551302433013916015, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Jagged Hound (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+158, 131666, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -450.4132080078125, -252.220489501953125, 234.6866607666015625, 3.658944606781005859, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Coven Thornshaper (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+159, 134041, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -467.48089599609375, -296.939239501953125, 236.111572265625, 3.697540283203125, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Infected Peasant (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 266008 - Infected, 272860 - Cosmetic Thin Man Begging) +(@CGUID+160, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -470.614532470703125, -296.327362060546875, 236.229736328125, 6.108142375946044921, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%) +(@CGUID+161, 131585, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -483.17535400390625, -186.692703247070312, 236.116241455078125, 4.560091972351074218, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Enthralled Guard (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 259712 - Enthralled) +(@CGUID+162, 131666, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -450.98089599609375, -268.171875, 234.6866607666015625, 3.485479116439819335, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Coven Thornshaper (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+163, 135049, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -491.625, -161.680557250976562, 251.8558502197265625, 4.839976787567138671, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Dreadwing Raven (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+164, 131586, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 1, -469.53125, -336.993072509765625, 236.109527587890625, 3.089185953140258789, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Banquet Steward (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 259716 - Enthralled) +(@CGUID+165, 137830, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -473.625, -341.3975830078125, 236.8321380615234375, 2.023208379745483398, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Pallid Gorger (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+166, 135168, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -447.484375, -315.555572509765625, 237.645751953125, 4.420731067657470703, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Dead Pig (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 265448 - Permanent Feign Death On Spawn) +(@CGUID+167, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -449.234954833984375, -334.523529052734375, 236.1947174072265625, 5.522914409637451171, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%) +(@CGUID+168, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -440.701019287109375, -318.724884033203125, 236.165771484375, 4.048826217651367187, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%) +(@CGUID+169, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -444.356353759765625, -335.0155029296875, 236.1985321044921875, 0.335822492837905883, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%, 278431 - Parasitic) +(@CGUID+170, 133435, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -480.46527099609375, -344.767364501953125, 151.316070556640625, 2.421268224716186523, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Drust Slaver Summoning Portal (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@CGUID+171, 135312, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -427.479156494140625, -269.53125, 243.176300048828125, 0, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Goliath Drain Target Male (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 259712 - Enthralled) +(@CGUID+172, 131669, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -431.9912109375, -254.112518310546875, 234.039886474609375, 0.054383471608161926, 7200, 3, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Jagged Hound (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+173, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -455.37811279296875, -316.740386962890625, 236.18548583984375, 1.064016580581665039, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%) +(@CGUID+174, 131669, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -438.1947021484375, -260.94293212890625, 233.82867431640625, 0.691592931747436523, 7200, 3, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Jagged Hound (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+175, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -447.049530029296875, -330.407012939453125, 236.1361083984375, 2.802553892135620117, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%) +(@CGUID+176, 135312, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -443.28472900390625, -267.958343505859375, 244.61761474609375, 0, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Goliath Drain Target Male (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 259712 - Enthralled) +(@CGUID+177, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -449.2747802734375, -321.50439453125, 236.1361083984375, 1.350999355316162109, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%) +(@CGUID+178, 131669, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -433.811492919921875, -271.0914306640625, 233.82867431640625, 4.203943252563476562, 7200, 3, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Jagged Hound (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 214567 - Mod Scale 90-110%) +(@CGUID+179, 135329, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -432.625, -259.493072509765625, 236.1174774169921875, 0.548182964324951171, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Matron Bryndle (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 265777 - Goliath Drain Flavor) +(@CGUID+180, 135168, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -446.56597900390625, -323.93402099609375, 237.645751953125, 1.603698015213012695, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Dead Pig (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 265448 - Permanent Feign Death On Spawn) +(@CGUID+181, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -440.796356201171875, -316.28143310546875, 236.176971435546875, 0.170766040682792663, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%) +(@CGUID+182, 135315, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -438.380218505859375, -250.489578247070312, 242.6348724365234375, 0, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Goliath Drain Target Female (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 259712 - Enthralled) +(@CGUID+183, 135312, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -428.817718505859375, -248.19097900390625, 243.373504638671875, 0, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Goliath Drain Target Male (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 259712 - Enthralled) +(@CGUID+184, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -452.085296630859375, -314.97174072265625, 236.271514892578125, 2.876992702484130859, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%) +(@CGUID+185, 135313, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -434.223968505859375, -270.263885498046875, 240.76904296875, 0, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Goliath Drain Target Heavy (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 259716 - Enthralled) +(@CGUID+186, 134024, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -441.495208740234375, -320.460357666015625, 236.2048492431640625, 4.721146583557128906, 7200, 2, 0, 100, 1, NULL, NULL, NULL, NULL, 55165), -- Devouring Maggot (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 202427 - Mod Scale 150%) +(@CGUID+187, 135312, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -433.90972900390625, -245.723953247070312, 241.0567169189453125, 0, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Goliath Drain Target Male (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 259712 - Enthralled) +(@CGUID+188, 137774, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -444.395843505859375, -331.390625, 180.5082244873046875, 0, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Portal to Basement (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 271040 - Teleport to Basement Area Trigger) +(@CGUID+189, 135315, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -418.642364501953125, -269.967010498046875, 244.74169921875, 4.576903820037841796, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165), -- Goliath Drain Target Female (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 259712 - Enthralled) +(@CGUID+190, 135313, 1862, 9424, 9424, '1,23,2,8', 0, 0, 0, 0, -415.26214599609375, -266.62152099609375, 244.74169921875, 4.576903820037841796, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55165); -- Goliath Drain Target Heavy (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 (Auras: 259716 - Enthralled) +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+190; +INSERT INTO `creature_addon` (`guid`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+48, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '202427 278431'), -- Devouring Maggot - 202427 - Mod Scale 150%, 278431 - Parasitic +(@CGUID+59, 0, 0, 0, 0, 0, 1, 0, 0, 15336, 0, 0, 0, ''), -- Maddened Survivalist +(@CGUID+75, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '202427 278431'), -- Devouring Maggot - 202427 - Mod Scale 150%, 278431 - Parasitic +(@CGUID+77, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '202427 278431'), -- Devouring Maggot - 202427 - Mod Scale 150%, 278431 - Parasitic +(@CGUID+82, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 0, '214567'), -- Dreadwing Raven - 214567 - Mod Scale 90-110% +(@CGUID+91, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '202427 278431'), -- Devouring Maggot - 202427 - Mod Scale 150%, 278431 - Parasitic +(@CGUID+102, 0, 0, 0, 0, 0, 1, 0, 0, 15336, 0, 0, 0, ''), -- Crazed Marksman +(@CGUID+106, 0, 0, 0, 0, 0, 1, 0, 418, 0, 0, 0, 0, '214567'), -- Pallid Gorger - 214567 - Mod Scale 90-110% +(@CGUID+111, 0, 0, 0, 3, 0, 1, 0, 0, 1700, 0, 0, 0, '214567'), -- Dreadwing Raven - 214567 - Mod Scale 90-110% +(@CGUID+125, 0, 0, 0, 3, 0, 1, 0, 0, 1700, 0, 0, 0, '214567'), -- Dreadwing Raven - 214567 - Mod Scale 90-110% +(@CGUID+129, 0, 0, 0, 0, 0, 1, 0, 418, 0, 0, 0, 0, '214567'), -- Pallid Gorger - 214567 - Mod Scale 90-110% +(@CGUID+132, 0, 0, 0, 0, 0, 1, 0, 720, 0, 0, 0, 0, '214567'), -- Gorestained Piglet - 214567 - Mod Scale 90-110% +(@CGUID+135, 0, 0, 0, 0, 0, 1, 0, 720, 0, 0, 0, 0, '259716'), -- Banquet Steward - 259716 - Enthralled +(@CGUID+136, 0, 0, 0, 0, 0, 1, 0, 64, 0, 0, 0, 0, '259712'), -- Waycrest Reveler - 259712 - Enthralled +(@CGUID+142, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '202427 278431'), -- Devouring Maggot - 202427 - Mod Scale 150%, 278431 - Parasitic +(@CGUID+144, 0, 0, 0, 0, 0, 1, 0, 64, 0, 0, 0, 0, '259712'), -- Waycrest Reveler - 259712 - Enthralled +(@CGUID+145, 0, 0, 0, 0, 0, 1, 0, 400, 0, 0, 0, 0, '259712'), -- Waycrest Reveler - 259712 - Enthralled +(@CGUID+146, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '214567'), -- Gorestained Piglet - 214567 - Mod Scale 90-110% +(@CGUID+147, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '259716'), -- Banquet Steward - 259716 - Enthralled +(@CGUID+151, 0, 0, 0, 0, 0, 1, 0, 400, 0, 0, 0, 0, '259712'), -- Waycrest Reveler - 259712 - Enthralled +(@CGUID+152, 0, 0, 0, 0, 0, 1, 0, 418, 0, 0, 0, 0, '214567'), -- Gorestained Piglet - 214567 - Mod Scale 90-110% +(@CGUID+154, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '202427 278431'), -- Devouring Maggot - 202427 - Mod Scale 150%, 278431 - Parasitic +(@CGUID+155, 0, 0, 0, 0, 0, 1, 0, 400, 0, 0, 0, 0, '259712'), -- Waycrest Reveler - 259712 - Enthralled +(@CGUID+163, 0, 0, 0, 3, 0, 1, 0, 0, 1700, 0, 0, 0, '214567'), -- Dreadwing Raven - 214567 - Mod Scale 90-110% +(@CGUID+164, 0, 0, 0, 0, 0, 1, 0, 720, 0, 0, 0, 0, '259716'); -- Banquet Steward - 259716 - Enthralled + +-- GameObjects +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+25; +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, 289699, 1862, 9424, 9424, '1,23,2,8', 0, 0, -454.484375, -299.807281494140625, 241.1402130126953125, 0.42129296064376831, 0, 0, 0.209092140197753906, 0.977895915508270263, 7200, 255, 1, 55165), -- Drustvar Dungeon - Organ Energy (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@OGUID+1, 282409, 1862, 9424, 9424, '1,23,2,8', 0, 0, -580.433349609375, -296.19244384765625, 235.97235107421875, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 7200, 255, 0, 55165), -- Door (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@OGUID+2, 282408, 1862, 9424, 9424, '1,23,2,8', 0, 0, -580.4478759765625, -223.058517456054687, 236.01092529296875, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 7200, 255, 0, 55165), -- Door (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@OGUID+3, 282767, 1862, 9424, 9424, '1,23,2,8', 0, 0, -588.95867919921875, -223.062652587890625, 249.4219207763671875, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 7200, 255, 0, 55165), -- Door (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@OGUID+4, 282766, 1862, 9424, 9424, '1,23,2,8', 0, 0, -559.332275390625, -296.226593017578125, 249.4219207763671875, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 7200, 255, 0, 55165), -- Door (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@OGUID+5, 282765, 1862, 9424, 9424, '1,23,2,8', 0, 0, -588.8980712890625, -296.226593017578125, 249.4219207763671875, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 7200, 255, 0, 55165), -- Door (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@OGUID+6, 282768, 1862, 9424, 9424, '1,23,2,8', 0, 0, -559.3995361328125, -223.062652587890625, 249.4219207763671875, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 7200, 255, 0, 55165), -- Door (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@OGUID+7, 282411, 1862, 9424, 9424, '1,23,2,8', 0, 0, -523.65533447265625, -233.675750732421875, 235.97235107421875, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 7200, 255, 0, 55165), -- Door (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@OGUID+8, 282410, 1862, 9424, 9424, '1,23,2,8', 0, 0, -574.8778076171875, -183.705795288085937, 236.0064544677734375, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 7200, 255, 0, 55165), -- Door (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@OGUID+9, 297809, 1862, 9424, 9424, '1,23,2,8', 0, 0, -544.79522705078125, -259.010162353515625, 182.44378662109375, 6.278062343597412109, 0, 0, -0.00256156921386718, 0.999996721744537353, 7200, 255, 1, 55165), -- Doodad_8FX_Drustvar_Witch_Waycrest_Organ_Barrier001 (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@OGUID+10, 289699, 1862, 9424, 9424, '1,23,2,8', 0, 0, -584.34893798828125, -323.5225830078125, 253.1695404052734375, 6.24246072769165039, 0, 0, -0.02036094665527343, 0.999792695045471191, 7200, 255, 1, 55165), -- Drustvar Dungeon - Organ Energy (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@OGUID+11, 289699, 1862, 9424, 9424, '1,23,2,8', 0, 0, -555.171875, -218.791671752929687, 255.1493072509765625, 4.795436382293701171, 0, 0, -0.67714405059814453, 0.735850453376770019, 7200, 255, 1, 55165), -- Drustvar Dungeon - Organ Energy (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@OGUID+12, 289699, 1862, 9424, 9424, '1,23,2,8', 0, 0, -564.36981201171875, -323.7257080078125, 255.6175994873046875, 6.24246072769165039, 0, 0, -0.02036094665527343, 0.999792695045471191, 7200, 255, 1, 55165), -- Drustvar Dungeon - Organ Energy (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@OGUID+13, 282413, 1862, 9424, 9424, '1,23,2,8', 0, 0, -526.0927734375, -330.263916015625, 235.97235107421875, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 0, 55165), -- Door (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@OGUID+14, 289699, 1862, 9424, 9424, '1,23,2,8', 0, 0, -555.171875, -203.828125, 255.1493072509765625, 4.795436382293701171, 0, 0, -0.67714405059814453, 0.735850453376770019, 7200, 255, 1, 55165), -- Drustvar Dungeon - Organ Energy (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@OGUID+15, 282769, 1862, 9424, 9424, '1,23,2,8', 0, 0, -505.8912353515625, -309.13470458984375, 235.97235107421875, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 7200, 255, 0, 55165), -- Door (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@OGUID+16, 290130, 1862, 9424, 9424, '1,23,2,8', 0, 0, -489.90728759765625, -208.030914306640625, 236.02386474609375, 0, 0, 0, 0, 1, 7200, 255, 1, 55165), -- Door (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@OGUID+17, 282412, 1862, 9424, 9424, '1,23,2,8', 0, 0, -484.003570556640625, -233.936126708984375, 235.97235107421875, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 7200, 255, 0, 55165), -- Door (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@OGUID+18, 289699, 1862, 9424, 9424, '1,23,2,8', 0, 0, -523.58856201171875, -324.1944580078125, 255.366455078125, 4.575895309448242187, 0, 0, -0.75368118286132812, 0.657240211963653564, 7200, 255, 1, 55165), -- Drustvar Dungeon - Organ Energy (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@OGUID+19, 290702, 1862, 9424, 9424, '1,23,2,8', 0, 0, -481.664794921875, -287.277587890625, 235.97235107421875, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 7200, 255, 0, 55165), -- Door (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@OGUID+20, 282770, 1862, 9424, 9424, '1,23,2,8', 0, 0, -481.628814697265625, -309.13470458984375, 235.97235107421875, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 7200, 255, 0, 55165), -- Door (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@OGUID+21, 289699, 1862, 9424, 9424, '1,23,2,8', 0, 0, -523.58856201171875, -336.135406494140625, 255.366455078125, 4.575895309448242187, 0, 0, -0.75368118286132812, 0.657240211963653564, 7200, 255, 1, 55165), -- Drustvar Dungeon - Organ Energy (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@OGUID+22, 289699, 1862, 9424, 9424, '1,23,2,8', 0, 0, -513.76043701171875, -183.970489501953125, 240.9019622802734375, 0.520980000495910644, 0, 0, 0.257554054260253906, 0.966263890266418457, 7200, 255, 1, 55165), -- Drustvar Dungeon - Organ Energy (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@OGUID+23, 289699, 1862, 9424, 9424, '1,23,2,8', 0, 0, -506.739593505859375, -179.840286254882812, 241.28717041015625, 0.325213253498077392, 0, 0, 0.161890983581542968, 0.986808657646179199, 7200, 255, 1, 55165), -- Drustvar Dungeon - Organ Energy (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@OGUID+24, 290131, 1862, 9424, 9424, '1,23,2,8', 0, 0, -464.10552978515625, -300.783203125, 226.5698089599609375, 0, 0, 0, 0, 1, 7200, 255, 1, 55165), -- Door (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +(@OGUID+25, 289699, 1862, 9424, 9424, '1,23,2,8', 0, 0, -502.682281494140625, -179.553817749023437, 241.28717041015625, 6.167336940765380859, 0, 0, -0.057891845703125, 0.998322844505310058, 7200, 255, 1, 55165); -- Drustvar Dungeon - Organ Energy (Area: Waycrest Manor - Difficulty: Mythic) CreateObject1 +DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+26; +INSERT INTO `gameobject_addon` (`guid`, `parent_rotation0`, `parent_rotation1`, `parent_rotation2`, `parent_rotation3`, `WorldEffectID`, `AIAnimKitID`) VALUES +(@OGUID+1, 0, 0, 1, -0.00000004371138828, 0, 0), -- Door +(@OGUID+2, 0, 0, 1, -0.00000004371138828, 0, 0), -- Door +(@OGUID+3, 0, 0, 1, -0.00000004371138828, 0, 0), -- Door +(@OGUID+4, 0, 0, 1, -0.00000004371138828, 0, 0), -- Door +(@OGUID+5, 0, 0, 1, -0.00000004371138828, 0, 0), -- Door +(@OGUID+6, 0, 0, 1, -0.00000004371138828, 0, 0), -- Door +(@OGUID+7, 0, 0, 1, -0.00000004371138828, 0, 0), -- Door +(@OGUID+8, 0, 0, 1, -0.00000004371138828, 0, 0), -- Door +(@OGUID+9, 0, 0, 1, -0.00000004371138828, 0, 0), -- Doodad_8FX_Drustvar_Witch_Waycrest_Organ_Barrier001 +(@OGUID+13, 0, 0, 1, -0.00000004371138828, 0, 0), -- Door +(@OGUID+15, 0, 0, 1, -0.00000004371138828, 0, 0), -- Door +(@OGUID+16, 0, 0, 1, -0.00000004371138828, 0, 0), -- Door +(@OGUID+17, 0, 0, 1, -0.00000004371138828, 0, 0), -- Door +(@OGUID+19, 0, 0, 1, -0.00000004371138828, 0, 0), -- Door +(@OGUID+20, 0, 0, 1, -0.00000004371138828, 0, 0), -- Door +(@OGUID+24, 0, 0, 1, -0.00000004371138828, 0, 0); -- Door + +-- Template +UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=131667; -- Soulbound Goliath +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=137774; -- Portal to Basement +UPDATE `creature_template` SET `unit_flags`=33554688, `unit_flags2`=2048, `unit_flags3`=0 WHERE `entry`=135168; -- Dead Pig +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=131595; -- Governess Tabitha +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=131863; -- Raal the Gluttonous +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=131615; -- Head Vintner Justin +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=131617; -- Groundskeeper Lilith +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=131619; -- Seamstress Johanna +UPDATE `creature_template` SET `unit_flags3`=4194304 WHERE `entry`=132361; -- Focusing Iris +UPDATE `creature_template` SET `unit_flags3`=67108864 WHERE `entry`=135049; -- Dreadwing Raven +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=131527; -- Lord Waycrest +UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=131824; -- Sister Solena +UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=131825; -- Sister Briar +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry` IN (131545, 135357); -- Lady Waycrest +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=131853; -- Huntmaster Grath +UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=131823; -- Sister Malady +UPDATE `creature_template` SET `unit_flags`=33554688, `unit_flags2`=2048, `unit_flags3`=0 WHERE `entry`=135139; -- Dead Villager +UPDATE `creature_template` SET `unit_flags3`=67108864 WHERE `entry`=135234; -- Diseased Mastiff +UPDATE `creature_template` SET `unit_flags3`=67108864 WHERE `entry`=135052; -- Blight Toad +UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=137048; -- Beguiled Villager +UPDATE `creature_template` SET `unit_flags`=33554752 WHERE `entry`=135360; -- Sister Briar +UPDATE `creature_template` SET `unit_flags`=33554752 WHERE `entry`=135358; -- Sister Malady +UPDATE `creature_template` SET `unit_flags`=33554752 WHERE `entry`=135359; -- Sister Solena +UPDATE `creature_template` SET `unit_flags`=33554752 WHERE `entry`=137033; -- Runic Disciple +UPDATE `creature_template` SET `unit_flags`=33554752 WHERE `entry`=137034; -- Thistle Acolyte +UPDATE `creature_template` SET `flags_extra` = 128 WHERE `entry` = 132209; + +-- Template Addon +DELETE FROM `creature_template_addon` WHERE `entry` IN (134303, 131667, 132209, 137774, 135313, 135315, 135329, 135312, 135168, 131863, 131847, 131586, 135513, 131849, 132361, 135713, 131669, 131527, 135048, 131824, 131825, 131545, 131823, 135139, 137830, 135234, 134024, 134041, 131587, 137048, 131585); +INSERT INTO `creature_template_addon` (`entry`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(134303, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 0, '266070'), -- 134303 (Summoning Portal) - Cosmetic Visual +(131667, 0, 0, 0, 0, 0, 1, 0, 0, 13946, 0, 0, 3, '261580'), -- 131667 (Soulbound Goliath) - Soul Harvest +(132209, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '260564'), -- 132209 (Lightning Controller) - Wildfire +(137774, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '271040'), -- 137774 (Portal to Basement) - Teleport to Basement Area Trigger +(135313, 0, 0, 0, 0, 0, 1, 0, 0, 6270, 0, 0, 0, '259716'), -- 135313 (Goliath Drain Target Heavy) - Enthralled +(135315, 0, 0, 0, 3, 0, 1, 0, 0, 6270, 0, 0, 0, '259712'), -- 135315 (Goliath Drain Target Female) - Enthralled +(135329, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '265777'), -- 135329 (Matron Bryndle) - Goliath Drain Flavor +(135312, 0, 0, 0, 3, 0, 1, 0, 0, 6270, 0, 0, 0, '259712'), -- 135312 (Goliath Drain Target Male) - Enthralled +(135168, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 0, 0, '265448'), -- 135168 (Dead Pig) - Permanent Feign Death On Spawn +(131863, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, ''), -- 131863 (Raal the Gluttonous) +(131847, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '259712'), -- 131847 (Waycrest Reveler) - Enthralled +(131586, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '259716'), -- 131586 (Banquet Steward) - Enthralled +(135513, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 135513 (Ancient Tome) +(131849, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 131849 (Crazed Marksman) +(132361, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '271079'), -- 132361 (Focusing Iris) - Cosmetic Focusing Iris Look +(135713, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 135713 (Vile Pod) +(131669, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '214567'), -- 131669 (Jagged Hound) - Mod Scale 90-110% +(131527, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, ''), -- 131527 (Lord Waycrest) +(135048, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '214567'), -- 135048 (Gorestained Piglet) - Mod Scale 90-110% +(131824, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, '272626'), -- 131824 (Sister Solena) - Override Energy Bar Color +(131825, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, '272627 261265'), -- 131825 (Sister Briar) - Override Energy Bar Color, Ironbark Shield +(131545, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, ''), -- 131545 (Lady Waycrest) +(131823, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, '272625 261266'), -- 131823 (Sister Malady) - Override Energy Bar Color, Runic Ward +(135139, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 0, 0, '265448'), -- 135139 (Dead Villager) - Permanent Feign Death On Spawn +(137830, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '214567'), -- 137830 (Pallid Gorger) - Mod Scale 90-110% +(135234, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '214567 265630'), -- 135234 (Diseased Mastiff) - Mod Scale 90-110%, Mastiff Disease +(134024, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '202427'), -- 134024 (Devouring Maggot) - Mod Scale 150% +(134041, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '266008 272860'), -- 134041 (Infected Peasant) - Infected, Cosmetic Thin Man Begging +(131587, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '259712'), -- 131587 (Bewitched Captain) - Enthralled +(137048, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '269121'), -- 137048 (Beguiled Villager) - Cosmetic Beguiled +(131585, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '259712'); -- 131585 (Enthralled Guard) - Enthralled + +-- ScriptNames +DELETE FROM `spell_script_names` WHERE `spell_id` = 265448; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(265448, 'spell_gen_feign_death_all_flags'); + +-- Difficulty (Normal) +DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID`=1 AND `Entry` IN (144324,138761,135552,135556,135555,135553,139269,138762,131864,137806,135255,136302,135365,135341,131819,136330,134303,136094,136087,136086,136085,136084,137774,135315,135312,135168,132209,131667,135329,135313,133435,131863,131595,131847,131586,135725,135474,131615,131619,135513,131617,132361,131812,131824,135713,131823,131545,137830,136161,135714,135139,135049,131853,131825,131821,131527,135048,131669,134041,134024,135234,131849,131666,131858,131677,131850,135711,131587,135357,137048,218647,218646,218977,131585,131685,135360,135358,135359,137034,135240,137033)); +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`) VALUES +(144324, 1, 7, 1, 1, 157025, 0, 0), -- Gorak Tul +(138761, 1, 7, 3, 1, 145524, 0, 0), -- Lucille Waycrest +(135552, 1, 7, 2, 1, 141758, 2101320, 128), -- Deathtouched Slaver +(135556, 1, 7, 3, 1, 141762, 4096, 0), -- Inquisitor Mace +(135555, 1, 7, 3, 1, 141761, 4096, 0), -- Inquisitor Sterntide +(135553, 1, 7, 3, 1, 141759, 4096, 0), -- Inquisitor Yorrick +(139269, 1, 7, 5, 1, 146062, 2097224, 0), -- Gloom Horror +(138762, 1, 7, 3, 1, 145525, 0, 0), -- Lucille Waycrest +(131864, 1, 7, 32, 1, 137784, 2097256, 128), -- Gorak Tul +(137806, 1, 7, 1, 1, 144353, 0, 0), -- Organ to Basement Traveler +(135255, 1, 7, 1, 1, 141404, 0, 0), -- Drain Target +(136302, 1, 7, 1, 1, 142596, 0, 0), -- Dark Etching Target +(135365, 1, 7, 12, 1, 141545, 2097224, 0), -- Matron Alma +(135341, 1, 7, 1, 1, 141509, 0, 0), -- Captured Villager +(131819, 1, 7, 4.5, 1, 137739, 2097224, 0), -- Coven Diviner +(136330, 1, 7, 1, 1, 142627, 0, 128), -- Soul Thorns +(134303, 1, 7, 1, 1, 140361, 0, 0), -- Summoning Portal +(136094, 1, 7, 3, 1, 142352, 0, 0), -- Inquisitor Notley +(136087, 1, 7, 3, 1, 142343, 0, 0), -- Inquisitor Sterntide +(136086, 1, 7, 3, 1, 142342, 0, 0), -- Inquisitor Mace +(136085, 1, 7, 3, 1, 142341, 0, 0), -- Inquisitor Yorrick +(136084, 1, 7, 3, 1, 142340, 0, 0), -- Lucille Waycrest +(137774, 1, 7, 1, 1, 144319, 1073741824, 6), -- Portal to Basement +(135315, 1, 7, 1, 1, 141476, 0, 0), -- Goliath Drain Target Female +(135312, 1, 7, 1, 1, 141473, 0, 0), -- Goliath Drain Target Male +(135168, 1, 7, 1, 1, 141306, 0, 0), -- Dead Pig +(132209, 1, 7, 1, 1, 138133, 0, 0), -- Lightning Controller +(131667, 1, 7, 35, 1, 137585, 2097256, 128), -- Soulbound Goliath +(135329, 1, 7, 12, 1, 141495, 2097224, 0), -- Matron Bryndle +(135313, 1, 7, 5, 1, 141474, 0, 0), -- Goliath Drain Target Heavy +(133435, 1, 7, 1, 1, 139464, 0, 0), -- Drust Slaver Summoning Portal +(131863, 1, 7, 34, 1, 137783, 2097256, 128), -- Raal the Gluttonous +(131595, 1, 7, 15, 1, 137513, 2097224, 0), -- Governess Tabitha +(131847, 1, 7, 3, 1, 137767, 2097224, 0), -- Waycrest Reveler +(131586, 1, 7, 5, 1, 137504, 2097224, 0), -- Banquet Steward +(135725, 1, 7, 1, 1, 141954, 1073741824, 6), -- Cursed Loom +(135474, 1, 7, 5, 1, 141669, 2097224, 0), -- Thistle Acolyte +(131615, 1, 7, 15, 1, 137533, 2097224, 0), -- Head Vintner Justin +(131619, 1, 7, 15, 1, 137537, 2097224, 0), -- Seamstress Johanna +(135513, 1, 7, 1, 1, 141715, 1073741824, 6), -- Ancient Tome +(131617, 1, 7, 12, 1, 137535, 2097224, 0), -- Groundskeeper Lilith +(132361, 1, 7, 1, 1, 138291, 0, 0), -- Focusing Iris +(131812, 1, 7, 8, 1, 137732, 2097224, 0), -- Heartsbane Soulcharmer +(131824, 1, 7, 9.5, 1, 137744, 2097256, 128), -- Sister Solena +(135713, 1, 7, 1, 1, 141942, 1073741824, 6), -- Vile Pod +(131823, 1, 7, 9.5, 1, 137743, 2097256, 128), -- Sister Malady +(131545, 1, 7, 100, 1, 137411, 2097256, 128), -- Lady Waycrest +(137830, 1, 7, 5, 1, 144377, 2097224, 0), -- Pallid Gorger +(136161, 1, 7, 32, 1, 142425, 2097224, 0), -- Gorak Tul +(135714, 1, 7, 1, 1, 141943, 1073741824, 6), -- Vinegared Wine +(135139, 1, 7, 1, 1, 141277, 0, 0), -- Dead Villager +(135049, 1, 7, 3, 1, 141177, 2097225, 0), -- Dreadwing Raven +(131853, 1, 7, 15, 1, 137773, 2097224, 0), -- Huntmaster Grath +(131825, 1, 7, 9.5, 1, 137745, 2097256, 128), -- Sister Briar +(131821, 1, 7, 4, 1, 137741, 2097224, 0), -- Faceless Maiden +(131527, 1, 7, 9, 1, 137391, 2097256, 128), -- Lord Waycrest +(135048, 1, 7, 2.5, 1, 141174, 2097225, 0), -- Gorestained Piglet +(131669, 1, 7, 1, 1, 137587, 2097224, 0), -- Jagged Hound +(134041, 1, 7, 5, 1, 140091, 2097224, 0), -- Infected Peasant +(134024, 1, 7, 1, 1, 140072, 2097224, 0), -- Devouring Maggot +(135234, 1, 7, 3, 1, 141375, 2097225, 0), -- Diseased Mastiff +(131849, 1, 7, 5, 1, 137769, 2097224, 0), -- Crazed Marksman +(131666, 1, 7, 5, 1, 137584, 2097224, 0), -- Coven Thornshaper +(131858, 1, 7, 5, 1, 137778, 2097224, 0), -- Thornguard +(131677, 1, 7, 8, 1, 137595, 2097224, 0), -- Heartsbane Runeweaver +(131850, 1, 7, 5, 1, 137770, 2097224, 0), -- Maddened Survivalist +(135711, 1, 7, 1, 1, 141940, 1073741824, 6), -- Hunting Map +(131587, 1, 7, 8, 1, 137505, 2097224, 0), -- Bewitched Captain +(135357, 1, 7, 100, 1, 141529, 2097224, 0), -- Lady Waycrest +(137048, 1, 7, 3, 1, 143491, 0, 0), -- Beguiled Villager +(131585, 1, 7, 5, 1, 137503, 2097224, 0), -- Enthralled Guard +(131685, 1, 7, 5, 1, 137603, 2097224, 0), -- Runic Disciple +(135360, 1, 7, 12, 1, 141538, 2097224, 0), -- Sister Briar +(135358, 1, 7, 12, 1, 141532, 2097224, 0), -- Sister Malady +(135359, 1, 7, 12, 1, 141535, 2097224, 0), -- Sister Solena +(137034, 1, 7, 5, 1, 143475, 2097224, 0), -- Thistle Acolyte +(135240, 1, 7, 3, 1, 141383, 2097224, 0), -- Soul Essence +(137033, 1, 7, 5, 1, 143472, 2097224, 0); -- Runic Disciple + +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `VerifiedBuild`=55165 WHERE (`Entry`=144324 AND `DifficultyID`=1); -- 144324 (Gorak Tul) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=138761 AND `DifficultyID`=1); -- 138761 (Lucille Waycrest) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135552 AND `DifficultyID`=1); -- 135552 (Deathtouched Slaver) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135556 AND `DifficultyID`=1); -- 135556 (Inquisitor Mace) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135553 AND `DifficultyID`=1); -- 135553 (Inquisitor Yorrick) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135555 AND `DifficultyID`=1); -- 135555 (Inquisitor Sterntide) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=139269 AND `DifficultyID`=1); -- 139269 (Gloom Horror) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=138762 AND `DifficultyID`=1); -- 138762 (Lucille Waycrest) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131864 AND `DifficultyID`=1); -- 131864 (Gorak Tul) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=536870912, `VerifiedBuild`=55165 WHERE (`Entry`=137806 AND `DifficultyID`=1); -- 137806 (Organ to Basement Traveler) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=536871168, `VerifiedBuild`=55165 WHERE (`Entry`=135255 AND `DifficultyID`=1); -- 135255 (Drain Target) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=536871168, `StaticFlags3`=33554432, `VerifiedBuild`=55165 WHERE (`Entry`=136302 AND `DifficultyID`=1); -- 136302 (Dark Etching Target) - Sessile, Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131819 AND `DifficultyID`=1); -- 131819 (Coven Diviner) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `VerifiedBuild`=55165 WHERE (`Entry`=135341 AND `DifficultyID`=1); -- 135341 (Captured Villager) - +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135365 AND `DifficultyID`=1); -- 135365 (Matron Alma) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=536871168, `StaticFlags3`=33554432, `VerifiedBuild`=55165 WHERE (`Entry`=136330 AND `DifficultyID`=1); -- 136330 (Soul Thorns) - Sessile, Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=536870912, `VerifiedBuild`=55165 WHERE (`Entry`=134303 AND `DifficultyID`=1); -- 134303 (Summoning Portal) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=136094 AND `DifficultyID`=1); -- 136094 (Inquisitor Notley) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=136084 AND `DifficultyID`=1); -- 136084 (Lucille Waycrest) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=136085 AND `DifficultyID`=1); -- 136085 (Inquisitor Yorrick) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=136086 AND `DifficultyID`=1); -- 136086 (Inquisitor Mace) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=136087 AND `DifficultyID`=1); -- 136087 (Inquisitor Sterntide) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131667 AND `DifficultyID`=1); -- 131667 (Soulbound Goliath) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=536871168, `VerifiedBuild`=55165 WHERE (`Entry`=132209 AND `DifficultyID`=1); -- 132209 (Lightning Controller) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=536871168, `VerifiedBuild`=55165 WHERE (`Entry`=135312 AND `DifficultyID`=1); -- 135312 (Goliath Drain Target Male) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=536871168, `VerifiedBuild`=55165 WHERE (`Entry`=135315 AND `DifficultyID`=1); -- 135315 (Goliath Drain Target Female) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=536871168, `VerifiedBuild`=55165 WHERE (`Entry`=137774 AND `DifficultyID`=1); -- 137774 (Portal to Basement) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=256, `VerifiedBuild`=55165 WHERE (`Entry`=135168 AND `DifficultyID`=1); -- 135168 (Dead Pig) - Sessile +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135329 AND `DifficultyID`=1); -- 135329 (Matron Bryndle) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=536871168, `VerifiedBuild`=55165 WHERE (`Entry`=133435 AND `DifficultyID`=1); -- 133435 (Drust Slaver Summoning Portal) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=536871168, `VerifiedBuild`=55165 WHERE (`Entry`=135313 AND `DifficultyID`=1); -- 135313 (Goliath Drain Target Heavy) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131595 AND `DifficultyID`=1); -- 131595 (Governess Tabitha) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=500, `StaticFlags1`=805306624, `VerifiedBuild`=55165 WHERE (`Entry`=131863 AND `DifficultyID`=1); -- 131863 (Raal the Gluttonous) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131586 AND `DifficultyID`=1); -- 131586 (Banquet Steward) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131847 AND `DifficultyID`=1); -- 131847 (Waycrest Reveler) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags3`=33554432, `VerifiedBuild`=55165 WHERE (`Entry`=135725 AND `DifficultyID`=1); -- 135725 (Cursed Loom) - CannotTurn +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131619 AND `DifficultyID`=1); -- 131619 (Seamstress Johanna) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131615 AND `DifficultyID`=1); -- 131615 (Head Vintner Justin) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135474 AND `DifficultyID`=1); -- 135474 (Thistle Acolyte) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=500, `StaticFlags1`=805306624, `VerifiedBuild`=55165 WHERE (`Entry`=131824 AND `DifficultyID`=1); -- 131824 (Sister Solena) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131617 AND `DifficultyID`=1); -- 131617 (Groundskeeper Lilith) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=500, `StaticFlags1`=805306624, `VerifiedBuild`=55165 WHERE (`Entry`=131545 AND `DifficultyID`=1); -- 131545 (Lady Waycrest) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=536870912, `StaticFlags3`=33554432, `VerifiedBuild`=55165 WHERE (`Entry`=135513 AND `DifficultyID`=1); -- 135513 (Ancient Tome) - Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=500, `StaticFlags1`=805306624, `VerifiedBuild`=55165 WHERE (`Entry`=131823 AND `DifficultyID`=1); -- 131823 (Sister Malady) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131812 AND `DifficultyID`=1); -- 131812 (Heartsbane Soulcharmer) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `VerifiedBuild`=55165 WHERE (`Entry`=132361 AND `DifficultyID`=1); -- 132361 (Focusing Iris) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=536870912, `StaticFlags3`=33554432, `VerifiedBuild`=55165 WHERE (`Entry`=135713 AND `DifficultyID`=1); -- 135713 (Vile Pod) - Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135048 AND `DifficultyID`=1); -- 135048 (Gorestained Piglet) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131527 AND `DifficultyID`=1); -- 131527 (Lord Waycrest) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=500, `StaticFlags1`=805306624, `VerifiedBuild`=55165 WHERE (`Entry`=131825 AND `DifficultyID`=1); -- 131825 (Sister Briar) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131669 AND `DifficultyID`=1); -- 131669 (Jagged Hound) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=805306368, `VerifiedBuild`=55165 WHERE (`Entry`=135049 AND `DifficultyID`=1); -- 135049 (Dreadwing Raven) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131858 AND `DifficultyID`=1); -- 131858 (Thornguard) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131666 AND `DifficultyID`=1); -- 131666 (Coven Thornshaper) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131853 AND `DifficultyID`=1); -- 131853 (Huntmaster Grath) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131821 AND `DifficultyID`=1); -- 131821 (Faceless Maiden) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=136161 AND `DifficultyID`=1); -- 136161 (Gorak Tul) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=134041 AND `DifficultyID`=1); -- 134041 (Infected Peasant) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=256, `VerifiedBuild`=55165 WHERE (`Entry`=135139 AND `DifficultyID`=1); -- 135139 (Dead Villager) - Sessile +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131849 AND `DifficultyID`=1); -- 131849 (Crazed Marksman) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags3`=33554432, `VerifiedBuild`=55165 WHERE (`Entry`=135714 AND `DifficultyID`=1); -- 135714 (Vinegared Wine) - CannotTurn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131850 AND `DifficultyID`=1); -- 131850 (Maddened Survivalist) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131677 AND `DifficultyID`=1); -- 131677 (Heartsbane Runeweaver) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=137830 AND `DifficultyID`=1); -- 137830 (Pallid Gorger) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135234 AND `DifficultyID`=1); -- 135234 (Diseased Mastiff) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=134024 AND `DifficultyID`=1); -- 134024 (Devouring Maggot) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=500, `StaticFlags1`=805306624, `VerifiedBuild`=55165 WHERE (`Entry`=135357 AND `DifficultyID`=1); -- 135357 (Lady Waycrest) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131587 AND `DifficultyID`=1); -- 131587 (Bewitched Captain) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=256, `VerifiedBuild`=55165 WHERE (`Entry`=137048 AND `DifficultyID`=1); -- 137048 (Beguiled Villager) - Sessile +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags3`=33554432, `VerifiedBuild`=55165 WHERE (`Entry`=135711 AND `DifficultyID`=1); -- 135711 (Hunting Map) - CannotTurn +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135360 AND `DifficultyID`=1); -- 135360 (Sister Briar) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135359 AND `DifficultyID`=1); -- 135359 (Sister Solena) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135358 AND `DifficultyID`=1); -- 135358 (Sister Malady) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131585 AND `DifficultyID`=1); -- 131585 (Enthralled Guard) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135240 AND `DifficultyID`=1); -- 135240 (Soul Essence) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=137033 AND `DifficultyID`=1); -- 137033 (Runic Disciple) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131685 AND `DifficultyID`=1); -- 131685 (Runic Disciple) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=500, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=137034 AND `DifficultyID`=1); -- 137034 (Thistle Acolyte) - CanSwim + +-- Difficulty (Heroic) +DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID`=2 AND `Entry` IN (135552,139269,131864,135365,131819,136541,136330,131667,132209,135329,131863,131595,131586,131847,131615,137830,131619,131617,131812,131824,131823,131545,131527,131825,136161,135049,135048,131853,131821,135474,134041,131669,135234,135052,134024,131849,131666,131858,131677,131850,131587,135357,131685,131585,137048,135360,135358,135359,135240,137033,137034)); +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`) VALUES +(135552, 2, 7, 2, 1, 141828, 2101320, 128), -- Deathtouched Slaver +(139269, 2, 7, 5, 1, 146072, 2097224, 0), -- Gloom Horror +(131864, 2, 7, 32, 1, 141826, 2097256, 128), -- Gorak Tul +(135365, 2, 7, 12, 1, 141546, 2097224, 0), -- Matron Alma +(131819, 2, 7, 4.5, 1, 138949, 2097224, 0), -- Coven Diviner +(136541, 2, 7, 0.384600013494491577, 1, 142860, 2097224, 128), -- Bile Oozeling +(136330, 2, 7, 1, 1, 142628, 0, 128), -- Soul Thorns +(131667, 2, 7, 35, 1, 138058, 2097256, 128), -- Soulbound Goliath +(132209, 2, 7, 1, 1, 148704, 0, 0), -- Lightning Controller +(135329, 2, 7, 12, 1, 141496, 2097224, 0), -- Matron Bryndle +(131863, 2, 7, 34, 1, 139377, 2097256, 128), -- Raal the Gluttonous +(131595, 2, 7, 15, 1, 138972, 2097224, 0), -- Governess Tabitha +(131586, 2, 7, 5, 1, 138935, 2097224, 0), -- Banquet Steward +(131847, 2, 7, 3, 1, 138945, 2097224, 0), -- Waycrest Reveler +(131615, 2, 7, 15, 1, 138964, 2097224, 0), -- Head Vintner Justin +(137830, 2, 7, 5, 1, 144378, 2097224, 0), -- Pallid Gorger +(131619, 2, 7, 15, 1, 138960, 2097224, 0), -- Seamstress Johanna +(131617, 2, 7, 12, 1, 138962, 2097224, 0), -- Groundskeeper Lilith +(131812, 2, 7, 8, 1, 138919, 2097224, 0), -- Heartsbane Soulcharmer +(131824, 2, 7, 9.5, 1, 138242, 2097256, 128), -- Sister Solena +(131823, 2, 7, 9.5, 1, 138244, 2097256, 128), -- Sister Malady +(131545, 2, 7, 100, 1, 137412, 2097256, 128), -- Lady Waycrest +(131527, 2, 7, 9, 1, 137392, 2097256, 128), -- Lord Waycrest +(131825, 2, 7, 9.5, 1, 138240, 2097256, 128), -- Sister Briar +(136161, 2, 7, 32, 1, 158828, 2097224, 0), -- Gorak Tul +(135049, 2, 7, 3, 1, 141182, 2097225, 0), -- Dreadwing Raven +(135048, 2, 7, 2.5, 1, 141175, 2097224, 0), -- Gorestained Piglet +(131853, 2, 7, 15, 1, 138958, 2097224, 0), -- Huntmaster Grath +(131821, 2, 7, 4, 1, 138947, 2097224, 0), -- Faceless Maiden +(135474, 2, 7, 5, 1, 141670, 2097224, 0), -- Thistle Acolyte +(134041, 2, 7, 5, 1, 141702, 2097224, 0), -- Infected Peasant +(131669, 2, 7, 1, 1, 138927, 2097224, 0), -- Jagged Hound +(135234, 2, 7, 3, 1, 141376, 2097225, 0), -- Diseased Mastiff +(135052, 2, 7, 1, 1, 141185, 2097225, 0), -- Blight Toad +(134024, 2, 7, 1, 1, 140074, 2097224, 0), -- Devouring Maggot +(131849, 2, 7, 5, 1, 138943, 2097224, 0), -- Crazed Marksman +(131666, 2, 7, 5, 1, 138929, 2097224, 0), -- Coven Thornshaper +(131858, 2, 7, 5, 1, 138939, 2097224, 0), -- Thornguard +(131677, 2, 7, 8, 1, 138923, 2097224, 0), -- Heartsbane Runeweaver +(131850, 2, 7, 5, 1, 138941, 2097224, 0), -- Maddened Survivalist +(131587, 2, 7, 8, 1, 138933, 2097224, 0), -- Bewitched Captain +(135357, 2, 7, 130, 1, 141530, 2097224, 0), -- Lady Waycrest +(131685, 2, 7, 5, 1, 138921, 2097224, 0), -- Runic Disciple +(131585, 2, 7, 5, 1, 138937, 2097224, 0), -- Enthralled Guard +(137048, 2, 7, 3.899999856948852539, 1, 143492, 0, 0), -- Beguiled Villager +(135360, 2, 7, 15.59999942779541015, 1, 141539, 2097224, 0), -- Sister Briar +(135358, 2, 7, 15.59999942779541015, 1, 141533, 2097224, 0), -- Sister Malady +(135359, 2, 7, 15.59999942779541015, 1, 141536, 2097224, 0), -- Sister Solena +(135240, 2, 7, 3, 1, 141776, 2097224, 0), -- Soul Essence +(137033, 2, 7, 6.5, 1, 143473, 2097224, 0), -- Runic Disciple +(137034, 2, 7, 6.5, 1, 143476, 2097224, 0); -- Thistle Acolyte + +DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID`=2 AND `Entry` IN (144324,138761,135556,135553,135555,138762,137806,136302,135341,135255,134303,136094,136084,136085,136086,136087,135315,137774,133435,135168,135312,135313,135725,135513,135713,135714,132361,135139,135711)); +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `StaticFlags1`, `StaticFlags2`, `StaticFlags3`, `StaticFlags4`, `StaticFlags5`, `StaticFlags6`, `StaticFlags7`, `StaticFlags8`, `VerifiedBuild`) VALUES +(144324, 2, 0, 0, 501, 0, 0, 0, 0, 0, 0, 0, 0, 55165), -- 144324 (Gorak Tul) - +(138761, 2, 0, 0, 501, 268435456, 0, 0, 0, 0, 0, 0, 0, 55165), -- 138761 (Lucille Waycrest) - CanSwim +(135556, 2, 0, 0, 501, 268435456, 0, 0, 0, 0, 0, 0, 0, 55165), -- 135556 (Inquisitor Mace) - CanSwim +(135553, 2, 0, 0, 501, 268435456, 0, 0, 0, 0, 0, 0, 0, 55165), -- 135553 (Inquisitor Yorrick) - CanSwim +(135555, 2, 0, 0, 501, 268435456, 0, 0, 0, 0, 0, 0, 0, 55165), -- 135555 (Inquisitor Sterntide) - CanSwim +(138762, 2, 0, 0, 501, 268435456, 0, 0, 0, 0, 0, 0, 0, 55165), -- 138762 (Lucille Waycrest) - CanSwim +(137806, 2, 0, 0, 501, 536870912, 0, 0, 0, 0, 0, 0, 0, 55165), -- 137806 (Organ to Basement Traveler) - Floating +(136302, 2, 0, 0, 501, 536871168, 0, 33554432, 0, 0, 0, 0, 0, 55165), -- 136302 (Dark Etching Target) - Sessile, Floating - CannotTurn +(135341, 2, 0, 0, 501, 0, 0, 0, 0, 0, 0, 0, 0, 55165), -- 135341 (Captured Villager) - +(135255, 2, 0, 0, 501, 536871168, 0, 0, 0, 0, 0, 0, 0, 55165), -- 135255 (Drain Target) - Sessile, Floating +(134303, 2, 0, 0, 501, 536870912, 0, 0, 0, 0, 0, 0, 0, 55165), -- 134303 (Summoning Portal) - Floating +(136094, 2, 0, 0, 501, 268435456, 0, 0, 0, 0, 0, 0, 0, 55165), -- 136094 (Inquisitor Notley) - CanSwim +(136084, 2, 0, 0, 501, 268435456, 0, 0, 0, 0, 0, 0, 0, 55165), -- 136084 (Lucille Waycrest) - CanSwim +(136085, 2, 0, 0, 501, 268435456, 0, 0, 0, 0, 0, 0, 0, 55165), -- 136085 (Inquisitor Yorrick) - CanSwim +(136086, 2, 0, 0, 501, 268435456, 0, 0, 0, 0, 0, 0, 0, 55165), -- 136086 (Inquisitor Mace) - CanSwim +(136087, 2, 0, 0, 501, 268435456, 0, 0, 0, 0, 0, 0, 0, 55165), -- 136087 (Inquisitor Sterntide) - CanSwim +(135315, 2, 0, 0, 501, 536871168, 0, 0, 0, 0, 0, 0, 0, 55165), -- 135315 (Goliath Drain Target Female) - Sessile, Floating +(137774, 2, 0, 0, 501, 536871168, 0, 0, 0, 0, 0, 0, 0, 55165), -- 137774 (Portal to Basement) - Sessile, Floating +(133435, 2, 0, 0, 501, 536871168, 0, 0, 0, 0, 0, 0, 0, 55165), -- 133435 (Drust Slaver Summoning Portal) - Sessile, Floating +(135168, 2, 0, 0, 501, 256, 0, 0, 0, 0, 0, 0, 0, 55165), -- 135168 (Dead Pig) - Sessile +(135312, 2, 0, 0, 501, 536871168, 0, 0, 0, 0, 0, 0, 0, 55165), -- 135312 (Goliath Drain Target Male) - Sessile, Floating +(135313, 2, 0, 0, 501, 536871168, 0, 0, 0, 0, 0, 0, 0, 55165), -- 135313 (Goliath Drain Target Heavy) - Sessile, Floating +(135725, 2, 0, 0, 501, 0, 0, 33554432, 0, 0, 0, 0, 0, 55165), -- 135725 (Cursed Loom) - CannotTurn +(135513, 2, 0, 0, 501, 536870912, 0, 33554432, 0, 0, 0, 0, 0, 55165), -- 135513 (Ancient Tome) - Floating - CannotTurn +(135713, 2, 0, 0, 501, 536870912, 0, 33554432, 0, 0, 0, 0, 0, 55165), -- 135713 (Vile Pod) - Floating - CannotTurn +(135714, 2, 0, 0, 501, 0, 0, 33554432, 0, 0, 0, 0, 0, 55165), -- 135714 (Vinegared Wine) - CannotTurn +(132361, 2, 0, 0, 501, 0, 0, 0, 0, 0, 0, 0, 0, 55165), -- 132361 (Focusing Iris) - +(135139, 2, 0, 0, 501, 256, 0, 0, 0, 0, 0, 0, 0, 55165), -- 135139 (Dead Villager) - Sessile +(135711, 2, 0, 0, 501, 0, 0, 33554432, 0, 0, 0, 0, 0, 55165); -- 135711 (Hunting Map) - CannotTurn + +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `CreatureDifficultyID`=157025 WHERE (`Entry`=144324 AND `DifficultyID`=2); -- Gorak Tul +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `HealthModifier`=3, `CreatureDifficultyID`=145524 WHERE (`Entry`=138761 AND `DifficultyID`=2); -- Lucille Waycrest +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `HealthModifier`=3, `CreatureDifficultyID`=141762, `TypeFlags`=4096 WHERE (`Entry`=135556 AND `DifficultyID`=2); -- Inquisitor Mace +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `HealthModifier`=3, `CreatureDifficultyID`=141761, `TypeFlags`=4096 WHERE (`Entry`=135555 AND `DifficultyID`=2); -- Inquisitor Sterntide +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `HealthModifier`=3, `CreatureDifficultyID`=141759, `TypeFlags`=4096 WHERE (`Entry`=135553 AND `DifficultyID`=2); -- Inquisitor Yorrick +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `HealthModifier`=3, `CreatureDifficultyID`=145525 WHERE (`Entry`=138762 AND `DifficultyID`=2); -- Lucille Waycrest +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `CreatureDifficultyID`=144353 WHERE (`Entry`=137806 AND `DifficultyID`=2); -- Organ to Basement Traveler +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `CreatureDifficultyID`=142596 WHERE (`Entry`=136302 AND `DifficultyID`=2); -- Dark Etching Target +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `CreatureDifficultyID`=141509 WHERE (`Entry`=135341 AND `DifficultyID`=2); -- Captured Villager +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `CreatureDifficultyID`=141404 WHERE (`Entry`=135255 AND `DifficultyID`=2); -- Drain Target +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `CreatureDifficultyID`=140361 WHERE (`Entry`=134303 AND `DifficultyID`=2); -- Summoning Portal +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `HealthModifier`=3, `CreatureDifficultyID`=142352 WHERE (`Entry`=136094 AND `DifficultyID`=2); -- Inquisitor Notley +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `HealthModifier`=3, `CreatureDifficultyID`=142343 WHERE (`Entry`=136087 AND `DifficultyID`=2); -- Inquisitor Sterntide +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `HealthModifier`=3, `CreatureDifficultyID`=142342 WHERE (`Entry`=136086 AND `DifficultyID`=2); -- Inquisitor Mace +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `HealthModifier`=3, `CreatureDifficultyID`=142341 WHERE (`Entry`=136085 AND `DifficultyID`=2); -- Inquisitor Yorrick +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `HealthModifier`=3, `CreatureDifficultyID`=142340 WHERE (`Entry`=136084 AND `DifficultyID`=2); -- Lucille Waycrest +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `CreatureDifficultyID`=141476 WHERE (`Entry`=135315 AND `DifficultyID`=2); -- Goliath Drain Target Female +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `CreatureDifficultyID`=144319, `TypeFlags`=1073741824, `TypeFlags2`=6 WHERE (`Entry`=137774 AND `DifficultyID`=2); -- Portal to Basement +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `HealthModifier`=5, `CreatureDifficultyID`=141474 WHERE (`Entry`=135313 AND `DifficultyID`=2); -- Goliath Drain Target Heavy +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `CreatureDifficultyID`=141473 WHERE (`Entry`=135312 AND `DifficultyID`=2); -- Goliath Drain Target Male +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `CreatureDifficultyID`=141306 WHERE (`Entry`=135168 AND `DifficultyID`=2); -- Dead Pig +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `CreatureDifficultyID`=139464 WHERE (`Entry`=133435 AND `DifficultyID`=2); -- Drust Slaver Summoning Portal +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `CreatureDifficultyID`=141954, `TypeFlags`=1073741824, `TypeFlags2`=6 WHERE (`Entry`=135725 AND `DifficultyID`=2); -- Cursed Loom +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `CreatureDifficultyID`=141715, `TypeFlags`=1073741824, `TypeFlags2`=6 WHERE (`Entry`=135513 AND `DifficultyID`=2); -- Ancient Tome +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `CreatureDifficultyID`=138291 WHERE (`Entry`=132361 AND `DifficultyID`=2); -- Focusing Iris +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `CreatureDifficultyID`=141942, `TypeFlags`=1073741824, `TypeFlags2`=6 WHERE (`Entry`=135713 AND `DifficultyID`=2); -- Vile Pod +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `CreatureDifficultyID`=141943, `TypeFlags`=1073741824, `TypeFlags2`=6 WHERE (`Entry`=135714 AND `DifficultyID`=2); -- Vinegared Wine +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `CreatureDifficultyID`=141277 WHERE (`Entry`=135139 AND `DifficultyID`=2); -- Dead Villager +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=7, `CreatureDifficultyID`=141940, `TypeFlags`=1073741824, `TypeFlags2`=6 WHERE (`Entry`=135711 AND `DifficultyID`=2); -- Hunting Map +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=9, `CreatureDifficultyID`=120388 WHERE (`Entry`=116633 AND `DifficultyID`=2); -- Effect + + +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135552 AND `DifficultyID`=2); -- 135552 (Deathtouched Slaver) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=139269 AND `DifficultyID`=2); -- 139269 (Gloom Horror) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131864 AND `DifficultyID`=2); -- 131864 (Gorak Tul) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135365 AND `DifficultyID`=2); -- 135365 (Matron Alma) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131819 AND `DifficultyID`=2); -- 131819 (Coven Diviner) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=136541 AND `DifficultyID`=2); -- 136541 (Bile Oozeling) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=536871168, `StaticFlags3`=33554432, `VerifiedBuild`=55165 WHERE (`Entry`=136330 AND `DifficultyID`=2); -- 136330 (Soul Thorns) - Sessile, Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131667 AND `DifficultyID`=2); -- 131667 (Soulbound Goliath) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=536871168, `VerifiedBuild`=55165 WHERE (`Entry`=132209 AND `DifficultyID`=2); -- 132209 (Lightning Controller) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135329 AND `DifficultyID`=2); -- 135329 (Matron Bryndle) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=501, `StaticFlags1`=805306624, `VerifiedBuild`=55165 WHERE (`Entry`=131863 AND `DifficultyID`=2); -- 131863 (Raal the Gluttonous) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131595 AND `DifficultyID`=2); -- 131595 (Governess Tabitha) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131847 AND `DifficultyID`=2); -- 131847 (Waycrest Reveler) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131586 AND `DifficultyID`=2); -- 131586 (Banquet Steward) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=137830 AND `DifficultyID`=2); -- 137830 (Pallid Gorger) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131617 AND `DifficultyID`=2); -- 131617 (Groundskeeper Lilith) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131619 AND `DifficultyID`=2); -- 131619 (Seamstress Johanna) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131615 AND `DifficultyID`=2); -- 131615 (Head Vintner Justin) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131527 AND `DifficultyID`=2); -- 131527 (Lord Waycrest) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=501, `StaticFlags1`=805306624, `VerifiedBuild`=55165 WHERE (`Entry`=131545 AND `DifficultyID`=2); -- 131545 (Lady Waycrest) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=501, `StaticFlags1`=805306624, `VerifiedBuild`=55165 WHERE (`Entry`=131823 AND `DifficultyID`=2); -- 131823 (Sister Malady) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=805306368, `VerifiedBuild`=55165 WHERE (`Entry`=135049 AND `DifficultyID`=2); -- 135049 (Dreadwing Raven) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131821 AND `DifficultyID`=2); -- 131821 (Faceless Maiden) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135048 AND `DifficultyID`=2); -- 135048 (Gorestained Piglet) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131812 AND `DifficultyID`=2); -- 131812 (Heartsbane Soulcharmer) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=501, `StaticFlags1`=805306624, `VerifiedBuild`=55165 WHERE (`Entry`=131824 AND `DifficultyID`=2); -- 131824 (Sister Solena) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=501, `StaticFlags1`=805306624, `VerifiedBuild`=55165 WHERE (`Entry`=131825 AND `DifficultyID`=2); -- 131825 (Sister Briar) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=136161 AND `DifficultyID`=2); -- 136161 (Gorak Tul) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131853 AND `DifficultyID`=2); -- 131853 (Huntmaster Grath) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135474 AND `DifficultyID`=2); -- 135474 (Thistle Acolyte) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131858 AND `DifficultyID`=2); -- 131858 (Thornguard) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131666 AND `DifficultyID`=2); -- 131666 (Coven Thornshaper) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135052 AND `DifficultyID`=2); -- 135052 (Blight Toad) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135234 AND `DifficultyID`=2); -- 135234 (Diseased Mastiff) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=134041 AND `DifficultyID`=2); -- 134041 (Infected Peasant) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131677 AND `DifficultyID`=2); -- 131677 (Heartsbane Runeweaver) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=134024 AND `DifficultyID`=2); -- 134024 (Devouring Maggot) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131669 AND `DifficultyID`=2); -- 131669 (Jagged Hound) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131849 AND `DifficultyID`=2); -- 131849 (Crazed Marksman) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131685 AND `DifficultyID`=2); -- 131685 (Runic Disciple) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=256, `VerifiedBuild`=55165 WHERE (`Entry`=137048 AND `DifficultyID`=2); -- 137048 (Beguiled Villager) - Sessile +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131850 AND `DifficultyID`=2); -- 131850 (Maddened Survivalist) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=501, `StaticFlags1`=805306624, `VerifiedBuild`=55165 WHERE (`Entry`=135357 AND `DifficultyID`=2); -- 135357 (Lady Waycrest) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131585 AND `DifficultyID`=2); -- 131585 (Enthralled Guard) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131587 AND `DifficultyID`=2); -- 131587 (Bewitched Captain) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135360 AND `DifficultyID`=2); -- 135360 (Sister Briar) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135358 AND `DifficultyID`=2); -- 135358 (Sister Malady) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135359 AND `DifficultyID`=2); -- 135359 (Sister Solena) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135240 AND `DifficultyID`=2); -- 135240 (Soul Essence) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=137033 AND `DifficultyID`=2); -- 137033 (Runic Disciple) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=501, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=137034 AND `DifficultyID`=2); -- 137034 (Thistle Acolyte) - CanSwim + +-- Difficulty (Mythic) +DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID`=23 AND `Entry` IN (136330,136436,198489,134303,136094,136087,136086,136085,136084,131667,132209,137774,135329,135315,135313,135312,135168,133435,131863,131595,131586,135725,131847,131615,131619,135513,131617,132361,131812,137830,131824,135713,131823,131545,131527,131825,135714,136161,135139,135049,135048,131853,131821,131669,135474,131587,134041,134024,135234,135052,131849,131666,131858,131677,131850,135711,116633,131685,131585,135357,137048,135360,135358,135359,137034,137033,135240)); +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`) VALUES +(136330, 23, 7, 1, 1, 142629, 0, 128), -- Soul Thorns +(136436, 23, 7, 1, 1, 142749, 8, 128), -- Burning Soul +(198489, 23, 9, 1, 2, 226868, 0, 0), -- Denizen of the Dream +(134303, 23, 7, 1, 1, 140361, 0, 0), -- Summoning Portal +(136094, 23, 7, 3, 1, 142352, 0, 0), -- Inquisitor Notley +(136087, 23, 7, 3, 1, 142343, 0, 0), -- Inquisitor Sterntide +(136086, 23, 7, 3, 1, 142342, 0, 0), -- Inquisitor Mace +(136085, 23, 7, 3, 1, 142341, 0, 0), -- Inquisitor Yorrick +(136084, 23, 7, 3, 1, 142340, 0, 0), -- Lucille Waycrest +(131667, 23, 7, 35, 1, 138059, 2097256, 128), -- Soulbound Goliath +(132209, 23, 7, 1, 1, 148705, 0, 0), -- Lightning Controller +(137774, 23, 7, 1, 1, 144319, 1073741824, 6), -- Portal to Basement +(135329, 23, 7, 12, 1, 141497, 2097224, 0), -- Matron Bryndle +(135315, 23, 7, 1, 1, 141476, 0, 0), -- Goliath Drain Target Female +(135313, 23, 7, 5, 1, 141474, 0, 0), -- Goliath Drain Target Heavy +(135312, 23, 7, 1, 1, 141473, 0, 0), -- Goliath Drain Target Male +(135168, 23, 7, 1, 1, 141306, 0, 0), -- Dead Pig +(133435, 23, 7, 1, 1, 139464, 0, 0), -- Drust Slaver Summoning Portal +(131863, 23, 7, 34, 1, 139378, 2097256, 128), -- Raal the Gluttonous +(131595, 23, 7, 15, 1, 138973, 2097224, 0), -- Governess Tabitha +(131586, 23, 7, 5, 1, 138936, 2097224, 0), -- Banquet Steward +(135725, 23, 7, 1, 1, 141954, 1073741824, 6), -- Cursed Loom +(131847, 23, 7, 3, 1, 138946, 2097224, 0), -- Waycrest Reveler +(131615, 23, 7, 15, 1, 138965, 2097224, 0), -- Head Vintner Justin +(131619, 23, 7, 15, 1, 138961, 2097224, 0), -- Seamstress Johanna +(135513, 23, 7, 1, 1, 141715, 1073741824, 6), -- Ancient Tome +(131617, 23, 7, 12, 1, 138963, 2097224, 0), -- Groundskeeper Lilith +(132361, 23, 7, 1, 1, 138291, 0, 0), -- Focusing Iris +(131812, 23, 7, 8, 1, 138920, 2097224, 0), -- Heartsbane Soulcharmer +(137830, 23, 7, 5, 1, 144379, 2097224, 0), -- Pallid Gorger +(131824, 23, 7, 9.5, 1, 138243, 2097256, 128), -- Sister Solena +(135713, 23, 7, 1, 1, 141942, 1073741824, 6), -- Vile Pod +(131823, 23, 7, 9.5, 1, 138245, 2097256, 128), -- Sister Malady +(131545, 23, 7, 100, 1, 137413, 2097256, 128), -- Lady Waycrest +(131527, 23, 7, 9, 1, 137393, 2097256, 128), -- Lord Waycrest +(131825, 23, 7, 9.5, 1, 138241, 2097256, 128), -- Sister Briar +(135714, 23, 7, 1, 1, 141943, 1073741824, 6), -- Vinegared Wine +(136161, 23, 7, 32, 1, 158829, 2097224, 0), -- Gorak Tul +(135139, 23, 7, 1, 1, 141277, 0, 0), -- Dead Villager +(135049, 23, 7, 3, 1, 141183, 2097225, 0), -- Dreadwing Raven +(135048, 23, 7, 2.5, 1, 141176, 2097224, 0), -- Gorestained Piglet +(131853, 23, 7, 15, 1, 138959, 2097224, 0), -- Huntmaster Grath +(131821, 23, 7, 4, 1, 138948, 2097224, 0), -- Faceless Maiden +(131669, 23, 7, 1, 1, 138928, 2097224, 0), -- Jagged Hound +(135474, 23, 7, 5, 1, 141671, 2097224, 0), -- Thistle Acolyte +(131587, 23, 7, 8, 1, 138934, 2097224, 0), -- Bewitched Captain +(134041, 23, 7, 5, 1, 141703, 2097224, 0), -- Infected Peasant +(134024, 23, 7, 1, 1, 140075, 2097224, 0), -- Devouring Maggot +(135234, 23, 7, 3, 1, 141377, 2097225, 0), -- Diseased Mastiff +(135052, 23, 7, 1, 1, 141186, 2097225, 0), -- Blight Toad +(131849, 23, 7, 5, 1, 138944, 2097224, 0), -- Crazed Marksman +(131666, 23, 7, 5, 1, 138930, 2097224, 0), -- Coven Thornshaper +(131858, 23, 7, 5, 1, 138940, 2097224, 0), -- Thornguard +(131677, 23, 7, 8, 1, 138924, 2097224, 0), -- Heartsbane Runeweaver +(131850, 23, 7, 5, 1, 138942, 2097224, 0), -- Maddened Survivalist +(135711, 23, 7, 1, 1, 141940, 1073741824, 6), -- Hunting Map +(116633, 23, 9, 1, 1, 120388, 0, 0), -- Effect +(131685, 23, 7, 5, 1, 138922, 2097224, 0), -- Runic Disciple +(131585, 23, 7, 5, 1, 138938, 2097224, 0), -- Enthralled Guard +(135357, 23, 7, 162.5, 1, 141531, 2097224, 0), -- Lady Waycrest +(137048, 23, 7, 4.875, 1, 143493, 0, 0), -- Beguiled Villager +(135360, 23, 7, 19.5, 1, 141540, 2097224, 0), -- Sister Briar +(135358, 23, 7, 19.5, 1, 141534, 2097224, 0), -- Sister Malady +(135359, 23, 7, 19.5, 1, 141537, 2097224, 0), -- Sister Solena +(137034, 23, 7, 8.125, 1, 143477, 2097224, 0), -- Thistle Acolyte +(137033, 23, 7, 8.125, 1, 143474, 2097224, 0), -- Runic Disciple +(135240, 23, 7, 3, 1, 141777, 2097224, 0); -- Soul Essence + +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=536871168, `StaticFlags3`=33554432, `VerifiedBuild`=55165 WHERE (`Entry`=136330 AND `DifficultyID`=23); -- 136330 (Soul Thorns) - Sessile, Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=136436 AND `DifficultyID`=23); -- 136436 (Burning Soul) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=482, `StaticFlags3`=262144, `VerifiedBuild`=55165 WHERE (`Entry`=198489 AND `DifficultyID`=23); -- 198489 (Denizen of the Dream) - AllowInteractionWhileInCombat +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=536870912, `VerifiedBuild`=55165 WHERE (`Entry`=134303 AND `DifficultyID`=23); -- 134303 (Summoning Portal) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=136084 AND `DifficultyID`=23); -- 136084 (Lucille Waycrest) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=136085 AND `DifficultyID`=23); -- 136085 (Inquisitor Yorrick) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=136086 AND `DifficultyID`=23); -- 136086 (Inquisitor Mace) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=136087 AND `DifficultyID`=23); -- 136087 (Inquisitor Sterntide) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=136094 AND `DifficultyID`=23); -- 136094 (Inquisitor Notley) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131667 AND `DifficultyID`=23); -- 131667 (Soulbound Goliath) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=536871168, `VerifiedBuild`=55165 WHERE (`Entry`=132209 AND `DifficultyID`=23); -- 132209 (Lightning Controller) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=256, `VerifiedBuild`=55165 WHERE (`Entry`=135168 AND `DifficultyID`=23); -- 135168 (Dead Pig) - Sessile +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135329 AND `DifficultyID`=23); -- 135329 (Matron Bryndle) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=536871168, `VerifiedBuild`=55165 WHERE (`Entry`=135312 AND `DifficultyID`=23); -- 135312 (Goliath Drain Target Male) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=536871168, `VerifiedBuild`=55165 WHERE (`Entry`=133435 AND `DifficultyID`=23); -- 133435 (Drust Slaver Summoning Portal) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=536871168, `VerifiedBuild`=55165 WHERE (`Entry`=135313 AND `DifficultyID`=23); -- 135313 (Goliath Drain Target Heavy) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=536871168, `VerifiedBuild`=55165 WHERE (`Entry`=135315 AND `DifficultyID`=23); -- 135315 (Goliath Drain Target Female) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=536871168, `VerifiedBuild`=55165 WHERE (`Entry`=137774 AND `DifficultyID`=23); -- 137774 (Portal to Basement) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131595 AND `DifficultyID`=23); -- 131595 (Governess Tabitha) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=502, `StaticFlags1`=805306624, `VerifiedBuild`=55165 WHERE (`Entry`=131863 AND `DifficultyID`=23); -- 131863 (Raal the Gluttonous) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131586 AND `DifficultyID`=23); -- 131586 (Banquet Steward) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131615 AND `DifficultyID`=23); -- 131615 (Head Vintner Justin) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131847 AND `DifficultyID`=23); -- 131847 (Waycrest Reveler) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags3`=33554432, `VerifiedBuild`=55165 WHERE (`Entry`=135725 AND `DifficultyID`=23); -- 135725 (Cursed Loom) - CannotTurn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=536870912, `StaticFlags3`=33554432, `VerifiedBuild`=55165 WHERE (`Entry`=135513 AND `DifficultyID`=23); -- 135513 (Ancient Tome) - Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131619 AND `DifficultyID`=23); -- 131619 (Seamstress Johanna) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131812 AND `DifficultyID`=23); -- 131812 (Heartsbane Soulcharmer) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `VerifiedBuild`=55165 WHERE (`Entry`=132361 AND `DifficultyID`=23); -- 132361 (Focusing Iris) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=137830 AND `DifficultyID`=23); -- 137830 (Pallid Gorger) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131617 AND `DifficultyID`=23); -- 131617 (Groundskeeper Lilith) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=502, `StaticFlags1`=805306624, `StaticFlags3`=33554432, `VerifiedBuild`=55165 WHERE (`Entry`=131545 AND `DifficultyID`=23); -- 131545 (Lady Waycrest) - Sessile, CanSwim, Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131853 AND `DifficultyID`=23); -- 131853 (Huntmaster Grath) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=502, `StaticFlags1`=805306624, `VerifiedBuild`=55165 WHERE (`Entry`=131823 AND `DifficultyID`=23); -- 131823 (Sister Malady) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131858 AND `DifficultyID`=23); -- 131858 (Thornguard) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=136161 AND `DifficultyID`=23); -- 136161 (Gorak Tul) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=134041 AND `DifficultyID`=23); -- 134041 (Infected Peasant) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=536870912, `StaticFlags3`=33554432, `VerifiedBuild`=55165 WHERE (`Entry`=135713 AND `DifficultyID`=23); -- 135713 (Vile Pod) - Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131849 AND `DifficultyID`=23); -- 131849 (Crazed Marksman) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags3`=33554432, `VerifiedBuild`=55165 WHERE (`Entry`=135714 AND `DifficultyID`=23); -- 135714 (Vinegared Wine) - CannotTurn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135052 AND `DifficultyID`=23); -- 135052 (Blight Toad) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135474 AND `DifficultyID`=23); -- 135474 (Thistle Acolyte) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=805306368, `VerifiedBuild`=55165 WHERE (`Entry`=135049 AND `DifficultyID`=23); -- 135049 (Dreadwing Raven) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131677 AND `DifficultyID`=23); -- 131677 (Heartsbane Runeweaver) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131527 AND `DifficultyID`=23); -- 131527 (Lord Waycrest) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131666 AND `DifficultyID`=23); -- 131666 (Coven Thornshaper) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131669 AND `DifficultyID`=23); -- 131669 (Jagged Hound) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=502, `StaticFlags1`=805306624, `VerifiedBuild`=55165 WHERE (`Entry`=131824 AND `DifficultyID`=23); -- 131824 (Sister Solena) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=256, `VerifiedBuild`=55165 WHERE (`Entry`=135139 AND `DifficultyID`=23); -- 135139 (Dead Villager) - Sessile +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=502, `StaticFlags1`=805306624, `VerifiedBuild`=55165 WHERE (`Entry`=131825 AND `DifficultyID`=23); -- 131825 (Sister Briar) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135048 AND `DifficultyID`=23); -- 135048 (Gorestained Piglet) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131821 AND `DifficultyID`=23); -- 131821 (Faceless Maiden) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=134024 AND `DifficultyID`=23); -- 134024 (Devouring Maggot) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135234 AND `DifficultyID`=23); -- 135234 (Diseased Mastiff) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131587 AND `DifficultyID`=23); -- 131587 (Bewitched Captain) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131850 AND `DifficultyID`=23); -- 131850 (Maddened Survivalist) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131685 AND `DifficultyID`=23); -- 131685 (Runic Disciple) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags3`=33554432, `VerifiedBuild`=55165 WHERE (`Entry`=135711 AND `DifficultyID`=23); -- 135711 (Hunting Map) - CannotTurn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=256, `VerifiedBuild`=55165 WHERE (`Entry`=137048 AND `DifficultyID`=23); -- 137048 (Beguiled Villager) - Sessile +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=502, `StaticFlags1`=805306624, `VerifiedBuild`=55165 WHERE (`Entry`=135357 AND `DifficultyID`=23); -- 135357 (Lady Waycrest) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=181, `StaticFlags1`=536871168, `VerifiedBuild`=55165 WHERE (`Entry`=116633 AND `DifficultyID`=23); -- 116633 (Effect) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=131585 AND `DifficultyID`=23); -- 131585 (Enthralled Guard) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135360 AND `DifficultyID`=23); -- 135360 (Sister Briar) - CanSwim +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=55165 WHERE (`Entry`=120652 AND `DifficultyID`=23); +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135358 AND `DifficultyID`=23); -- 135358 (Sister Malady) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135359 AND `DifficultyID`=23); -- 135359 (Sister Solena) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=137034 AND `DifficultyID`=23); -- 137034 (Thistle Acolyte) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=135240 AND `DifficultyID`=23); -- 135240 (Soul Essence) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=502, `StaticFlags1`=268435456, `VerifiedBuild`=55165 WHERE (`Entry`=137033 AND `DifficultyID`=23); -- 137033 (Runic Disciple) - CanSwim + +-- Soul Essence smart ai +SET @ENTRY := 135240; +UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(@ENTRY, 0, 0, 0, '', 25, 0, 100, 0, 0, 0, 0, 0, 11, 267812, 0, 0, 0, 0, 0, 19, 137048, 6, 0, 0, 0, 0, 0, 'On reset - Self: Cast spell 267812 on Closest alive creature Beguiled Villager (137048) in 6 yards'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 22 AND `SourceGroup` = 1 AND `SourceEntry` = @ENTRY; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `Comment`) VALUES +(22, 1, @ENTRY, 0, 0, 58, 1, 0, 0, 0, 'CosmeticDarkEtching', 0, 'Scripted creature has StringId ''CosmeticDarkEtching'''); + +UPDATE `creature` SET `StringId`='CosmeticDarkEtching' WHERE `guid` IN (@CGUID+16, @CGUID+13, @CGUID+38, @CGUID+18, @CGUID+20); + +-- Thistle Acolyte smart ai +SET @ENTRY := 135474; +UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(@ENTRY, 0, 0, 0, '', 25, 0, 100, 0, 0, 0, 0, 0, 85, 269151, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On reset - Self: Cast spell 269151 on self'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 22 AND `SourceGroup` = 1 AND `SourceEntry` = @ENTRY; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `Comment`) VALUES +(22, 1, @ENTRY, 0, 0, 58, 1, 0, 0, 0, 'CosmeticWitchFrog', 0, 'Scripted creature has StringId ''CosmeticWitchFrog'''); + +UPDATE `creature` SET `StringId`='CosmeticWitchFrog' WHERE `guid` IN (@CGUID+58, @CGUID+116); + +-- Infected Peasant smart ai +SET @ENTRY := 134041; +UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(@ENTRY, 0, 0, 0, '', 25, 0, 100, 0, 0, 0, 0, 0, 85, 272860, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On reset - Self: Cast spell 272860 on self'); + +-- Waypoints for CGUID+14 +DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+14; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@CGUID+14, @CGUID+14, 0, 0, 515, 0, 0), +(@CGUID+14, @CGUID+4, 2, 270, 515, 4, 10); + +SET @ENTRY := 131685; +SET @PATHOFFSET := 0; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES +(@PATH, 0, 0, 'Runic Disciple - 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, -559.2674, -191.4844, 249.5423, NULL, 0), +(@PATH, 1, -571.7257, -191.7691, 249.5423, NULL, 0), +(@PATH, 2, -588.0625, -191.5365, 249.5883, NULL, 0), +(@PATH, 3, -588.8386, -205.9427, 249.5423, NULL, 0), +(@PATH, 4, -589.4393, -219.3976, 249.5423, NULL, 4832), +(@PATH, 5, -588.8386, -205.9427, 249.5423, NULL, 0), +(@PATH, 6, -588.0625, -191.5365, 249.5883, NULL, 0), +(@PATH, 7, -571.7257, -191.7691, 249.5423, NULL, 0), +(@PATH, 8, -559.2674, -191.4844, 249.5423, NULL, 0), +(@PATH, 9, -559.9028, -207.7483, 249.5423, NULL, 0), +(@PATH, 10, -559.9011, -219.2951, 249.5423, NULL, 4808), +(@PATH, 11, -559.9028, -207.7483, 249.5423, NULL, 0); + +UPDATE `creature` SET `position_x`= -559.2674, `position_y`= -191.4844, `position_z`= 249.5423, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+14; +UPDATE `creature` SET `position_x`= -559.2674, `position_y`= -191.4844, `position_z`= 249.5423 WHERE `guid`= @CGUID+4; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+14; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@CGUID+14, @PATH, 1); + +-- Waypoints 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+25, 2, 90, 515, 1, 0); + +SET @ENTRY := 131587; +SET @PATHOFFSET := 0; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES +(@PATH, 0, 0, 'Bewitched Captain - 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, -579.8489, -198.7778, 236.1361, NULL, 0), +(@PATH, 1, -529.4012, -198.421, 236.1361, NULL, 0); + +UPDATE `creature` SET `position_x`= -579.8489, `position_y`= -198.7778, `position_z`= 236.1361, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+36; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+36; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`, `auras`) VALUES +(@CGUID+36, @PATH, 1, '259712'); + +-- Waypoints for CGUID+134 +DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+134; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@CGUID+134, @CGUID+134, 0, 0, 515, 0, 0), +(@CGUID+134, @CGUID+123, 2, 270, 515, 1, 9); + +SET @ENTRY := 131587; +SET @PATHOFFSET := 1; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES +(@PATH, 0, 0, 'Bewitched Captain - 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, -501.0644, -187.4605, 249.5423, NULL, 0), +(@PATH, 1, -504.3195, -168.5938, 249.6306, NULL, 4085), +(@PATH, 2, -501.1059, -187.4601, 249.5423, NULL, 0), +(@PATH, 3, -482.7951, -187.6458, 249.5424, NULL, 0), +(@PATH, 4, -482.0226, -207.5104, 249.6559, NULL, 0), +(@PATH, 5, -512.1129, -207.1337, 236.1001, NULL, 0), +(@PATH, 6, -520.0972, -206.0434, 236.0613, NULL, 0), +(@PATH, 7, -520.3889, -198.6684, 235.9686, NULL, 0), +(@PATH, 8, -511.9132, -195.3958, 236.0183, NULL, 0), +(@PATH, 9, -493.5139, -195.3576, 236.016, NULL, 4290), +(@PATH, 10, -511.9132, -195.3958, 236.0183, NULL, 0), +(@PATH, 11, -520.3889, -198.6684, 235.9686, NULL, 0), +(@PATH, 12, -520.0972, -206.0434, 236.0613, NULL, 0), +(@PATH, 13, -512.1129, -207.1337, 236.1001, NULL, 0), +(@PATH, 14, -482.0226, -207.5104, 249.6559, NULL, 0), +(@PATH, 15, -482.7951, -187.6458, 249.5424, NULL, 0); + +UPDATE `creature` SET `position_x`= -501.0644, `position_y`= -187.4605, `position_z`= 249.5423, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+134; +UPDATE `creature` SET `position_x`= -501.0644, `position_y`= -187.4605, `position_z`= 249.5423 WHERE `guid`= @CGUID+123; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+134; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`, `auras`) VALUES +(@CGUID+134, @PATH, 1, '259712'); + +-- Waypoints for CGUID+147 +SET @ENTRY := 131586; +SET @PATHOFFSET := 0; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES +(@PATH, 0, 0, 'Banquet Steward - 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, -507.0243, -323.8368, 235.7298, NULL, 0), +(@PATH, 1, -508.8837, -337.5451, 235.7299, NULL, 0), +(@PATH, 2, -491.2813, -335.1823, 235.7298, NULL, 0), +(@PATH, 3, -483.691, -336.2396, 235.804, NULL, 0), +(@PATH, 4, -471.757, -332.6302, 235.7299, NULL, 0), +(@PATH, 5, -456.5712, -330.6181, 236.1361, NULL, 0), +(@PATH, 6, -448.8663, -330.7135, 236.1361, NULL, 0), +(@PATH, 7, -442.1163, -330.9254, 236.1646, NULL, 0), +(@PATH, 8, -440.5712, -319.132, 236.2429, NULL, 0), +(@PATH, 9, -441.1684, -310.6389, 236.2031, NULL, 0), +(@PATH, 10, -445.2066, -309.4757, 236.1361, NULL, 0), +(@PATH, 11, -451.6615, -311.2552, 236.1361, NULL, 0), +(@PATH, 12, -452.4757, -320.4201, 236.2586, NULL, 0), +(@PATH, 13, -457.7101, -328.9323, 236.1361, NULL, 0), +(@PATH, 14, -471.9149, -329.5903, 235.7299, NULL, 0), +(@PATH, 15, -476.408, -323.6146, 235.7299, NULL, 0), +(@PATH, 16, -490.1354, -323.309, 235.7298, NULL, 0); + +UPDATE `creature` SET `position_x`= -507.0243, `position_y`= -323.8368, `position_z`= 235.7298, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+147; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+147; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`, `auras`) VALUES +(@CGUID+147, @PATH, 1, '259712'); + +-- Waypoints for CGUID+55 +DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+55; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@CGUID+55, @CGUID+55, 0, 0, 515, 0, 0), +(@CGUID+55, @CGUID+79, 2, 0, 515, 0, 0); + +SET @ENTRY := 137830; +SET @PATHOFFSET := 0; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES +(@PATH, 0, 0, 'Pallid Gorger - 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, -515.6285, -299.9306, 236.1361, NULL, 0), +(@PATH, 1, -536.4983, -299.8125, 236.1361, NULL, 0), +(@PATH, 2, -535.1858, -330.0903, 236.1361, NULL, 0), +(@PATH, 3, -535.7465, -361.2517, 236.1361, NULL, 229), +(@PATH, 4, -535.1858, -330.0903, 236.1361, NULL, 0), +(@PATH, 5, -536.4983, -299.8125, 236.1361, NULL, 0), +(@PATH, 6, -515.6285, -299.9306, 236.1361, NULL, 0), +(@PATH, 7, -480.9271, -299.5625, 236.1361, NULL, 116); + +UPDATE `creature` SET `position_x`= -515.6285, `position_y`= -299.9306, `position_z`= 236.1361, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+55; +UPDATE `creature` SET `position_x`= -515.6285, `position_y`= -299.9306, `position_z`= 236.1361 WHERE `guid`= @CGUID+79; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+55; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@CGUID+55, @PATH, 1); + +-- Waypoints for CGUIDS+127 +DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+127; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@CGUID+127, @CGUID+127, 0, 0, 515, 0, 0), +(@CGUID+127, @CGUID+141, 2, 310, 515, 0, 0), +(@CGUID+127, @CGUID+138, 4, 310, 515, 0, 0), +(@CGUID+127, @CGUID+157, 2, 50, 515, 0, 0); + +SET @ENTRY := 131669; +SET @PATHOFFSET := 0; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES +(@PATH, 1, 0, 'Jagged Hound - 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, -531.1788, -273.8333, 235.0007, NULL, 0), +(@PATH, 1, -531.1735, -247.0815, 235.3397, NULL, 0), +(@PATH, 2, -492.8507, -248.1146, 234.6055, NULL, 0), +(@PATH, 3, -463.3785, -246.8698, 234.6031, NULL, 0), +(@PATH, 4, -463.1719, -260.2639, 234.6033, NULL, 0), +(@PATH, 5, -463.8125, -272.916, 234.7457, NULL, 0), +(@PATH, 6, -496.3368, -273.5781, 234.7459, NULL, 0); + +UPDATE `creature` SET `position_x`= -531.1788, `position_y`= -273.8333, `position_z`= 235.0007, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+127; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+127; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`, `auras`) VALUES +(@CGUID+127, @PATH, 1, '214567'); + +-- Waypoints for CGUID+130 +DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+130; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@CGUID+130, @CGUID+130, 0, 0, 515, 0, 0), +(@CGUID+130, @CGUID+124, 2, 310, 515, 0, 0), +(@CGUID+130, @CGUID+139, 2, 50, 515, 0, 0); + +SET @ENTRY := 131669; +SET @PATHOFFSET := 1; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES +(@PATH, 1, 0, 'Jagged Hound - 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, -529.1511, -273.6962, 234.9343, NULL, 0), +(@PATH, 1, -529.5625, -247.0417, 234.8347, NULL, 0), +(@PATH, 2, -492.5938, -247.974, 234.6072, NULL, 0), +(@PATH, 3, -463.1754, -246.7413, 234.6031, NULL, 0), +(@PATH, 4, -463.8871, -272.916, 234.7459, NULL, 0), +(@PATH, 5, -496.684, -273.6823, 234.7502, NULL, 0); + +UPDATE `creature` SET `position_x`= -529.1511, `position_y`= -273.6962, `position_z`= 234.9343, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+130; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+130; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`, `auras`) VALUES +(@CGUID+130, @PATH, 1, '214567'); |