diff options
author | Naddley <64811442+Naddley@users.noreply.github.com> | 2022-06-24 16:32:38 +0200 |
---|---|---|
committer | ModoX <moardox@gmail.com> | 2022-06-24 16:32:57 +0200 |
commit | 4ca8a1e95a4633fd57813fa5d8c5e45666dbe169 (patch) | |
tree | ec0511fa81bcee23be6babb6ab742da6b9ca9401 /sql | |
parent | 926b7616485a7d4898774686fafd4afcc6261954 (diff) |
DB/Spawns: Added spawns to Gul'var / Shadowmoon Valley
Closes #28052
Diffstat (limited to 'sql')
-rw-r--r-- | sql/updates/world/master/2022_06_24_01_world.sql | 670 |
1 files changed, 670 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_06_24_01_world.sql b/sql/updates/world/master/2022_06_24_01_world.sql new file mode 100644 index 00000000000..e624d838170 --- /dev/null +++ b/sql/updates/world/master/2022_06_24_01_world.sql @@ -0,0 +1,670 @@ +SET @CGUID := 459989; +SET @OGUID := 395491; + +-- Creature +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+127; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID+0, 52187, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1449.2066650390625, 870.00347900390625, 125.82940673828125, 3.213826179504394531, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny Gigantic Hide Body (Area: -Unknown- - Difficulty: 0) (Auras: 146894 - Soul Shards of Summoning: Light Beam) +(@CGUID+1, 77518, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1525.3802490234375, 996.29339599609375, 75.3673248291015625, 3.353975534439086914, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Shadow Warrior (Area: -Unknown- - Difficulty: 0) +(@CGUID+2, 77517, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1576.701416015625, 1027.5989990234375, 74.23416900634765625, 0.489093780517578125, 7200, 0, 0, 2463, 1283, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: 146130 - Cosmetic - Fel Fire Channeling Omni) +(@CGUID+3, 52187, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1587.8194580078125, 1050.4757080078125, 73.1494293212890625, 3.909678220748901367, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny Gigantic Hide Body (Area: -Unknown- - Difficulty: 0) (Auras: 146894 - Soul Shards of Summoning: Light Beam) +(@CGUID+4, 77518, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1547.547119140625, 1045.55859375, 70.63753509521484375, 1.948576688766479492, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Shadow Warrior (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+5, 72785, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1466.2650146484375, 609.31036376953125, 74.113372802734375, 2.169362068176269531, 7200, 10, 0, 24630, 12830, 1, 0, 0, 0, 44232), -- Twisted Ancient (Area: -Unknown- - Difficulty: 0) (Auras: 146164 - Fel-Cursed) (possible waypoints or random movement) +(@CGUID+6, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1519.8663330078125, 994.34893798828125, 75.35593414306640625, 3.859789848327636718, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) +(@CGUID+7, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1568.80908203125, 913.90106201171875, 82.0049896240234375, 2.260404825210571289, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+8, 77518, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1546.532958984375, 1048.3992919921875, 70.79327392578125, 5.186388969421386718, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Shadow Warrior (Area: -Unknown- - Difficulty: 0) +(@CGUID+9, 77517, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1452.7413330078125, 928.7586669921875, 117.5175247192382812, 5.31950998306274414, 7200, 0, 0, 2463, 1283, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: 146130 - Cosmetic - Fel Fire Channeling Omni) +(@CGUID+10, 77488, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1433.38720703125, 1081.6319580078125, 104.4456558227539062, 4.710556507110595703, 7200, 0, 0, 8005, 0, 0, 0, 0, 0, 44232), -- Krosnis (Area: -Unknown- - Difficulty: 0) (Auras: 12743 - Immolation) +(@CGUID+11, 77518, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1471.8211669921875, 1014.01910400390625, 94.6138153076171875, 3.581189870834350585, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Shadow Warrior (Area: -Unknown- - Difficulty: 0) +(@CGUID+12, 77518, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1514.23095703125, 952.0625, 77.9777069091796875, 4.7929840087890625, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Shadow Warrior (Area: -Unknown- - Difficulty: 0) +(@CGUID+13, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1565.5711669921875, 914.66839599609375, 84.24494171142578125, 2.43888401985168457, 7200, 0, 0, 1847, 0, 0, 0, 33587456, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+14, 77518, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1502.1492919921875, 1000.4600830078125, 94.23488616943359375, 6.082509994506835937, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Shadow Warrior (Area: -Unknown- - Difficulty: 0) +(@CGUID+15, 52187, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1249.6353759765625, 878.8055419921875, 119.6107864379882812, 4.923907756805419921, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny Gigantic Hide Body (Area: -Unknown- - Difficulty: 0) (Auras: 146894 - Soul Shards of Summoning: Light Beam) +(@CGUID+16, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1481.736083984375, 1021.56951904296875, 95.5037689208984375, 3.28923201560974121, 7200, 10, 0, 1847, 0, 1, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+17, 72677, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1442.9461669921875, 869.4757080078125, 123.9414825439453125, 0.130194485187530517, 7200, 0, 0, 7389, 1924, 0, 0, 0, 0, 44232), -- Fel Mistress Hagra (Area: -Unknown- - Difficulty: 0) (Auras: 51733 - Shadow Channelling) +(@CGUID+18, 77518, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1544.8125, 886.703125, 76.678070068359375, 4.899161815643310546, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Shadow Warrior (Area: -Unknown- - Difficulty: 0) +(@CGUID+19, 72647, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1583.0728759765625, 1045.640625, 71.0319061279296875, 0.826330959796905517, 7200, 0, 0, 6896, 1924, 0, 0, 0, 0, 44232), -- Corruptor Kurgoth (Area: -Unknown- - Difficulty: 0) (Auras: 51733 - Shadow Channelling) +(@CGUID+20, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1490.4410400390625, 1021.20489501953125, 95.4234161376953125, 1.881794452667236328, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) +(@CGUID+21, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1566.3958740234375, 911.47918701171875, 81.95147705078125, 2.260404825210571289, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+22, 77518, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1549.767333984375, 920.74652099609375, 78.18906402587890625, 2.074411869049072265, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Shadow Warrior (Area: -Unknown- - Difficulty: 0) +(@CGUID+23, 77517, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1563.0833740234375, 917.09027099609375, 78.74045562744140625, 5.510416030883789062, 7200, 0, 0, 2463, 1283, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: 146130 - Cosmetic - Fel Fire Channeling Omni) +(@CGUID+24, 77518, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1508.4149169921875, 873.56768798828125, 71.52874755859375, 4.686344623565673828, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Shadow Warrior (Area: -Unknown- - Difficulty: 0) +(@CGUID+25, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1569.138916015625, 913.58856201171875, 85.47371673583984375, 2.260404825210571289, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+26, 77517, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1442.2725830078125, 917.4444580078125, 117.854034423828125, 6.249334335327148437, 7200, 0, 0, 2463, 1283, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: 146130 - Cosmetic - Fel Fire Channeling Omni) +(@CGUID+27, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1570.4114990234375, 1007.34722900390625, 76.3968353271484375, 1.177248716354370117, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) +(@CGUID+28, 77517, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1488.9461669921875, 1025.6302490234375, 95.4432373046875, 5.266125679016113281, 7200, 0, 0, 2463, 1283, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+29, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1566.5677490234375, 911.36456298828125, 85.632537841796875, 2.260404825210571289, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+30, 77518, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1477.2412109375, 907.7958984375, 121.1289749145507812, 0.368399322032928466, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Shadow Warrior (Area: -Unknown- - Difficulty: 0) +(@CGUID+31, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1464.423583984375, 870.48089599609375, 124.107086181640625, 2.983550071716308593, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) (Auras: 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune)) +(@CGUID+32, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1448.4635009765625, 870.26910400390625, 125.7504653930664062, 4.859127044677734375, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) (Auras: 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune)) +(@CGUID+33, 77517, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1450.203125, 1029.782958984375, 96.98624420166015625, 1.080089688301086425, 7200, 0, 0, 2463, 1283, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: 146130 - Cosmetic - Fel Fire Channeling Omni) +(@CGUID+34, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1586.40283203125, 1050.626708984375, 73.11419677734375, 1.460186123847961425, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) (Auras: 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune)) +(@CGUID+35, 77517, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1538.6649169921875, 1058.5694580078125, 71.1173553466796875, 2.082193613052368164, 7200, 0, 0, 2463, 1283, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: 146130 - Cosmetic - Fel Fire Channeling Omni) +(@CGUID+36, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1589.6875, 1047.8004150390625, 73.07779693603515625, 3.490752935409545898, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) (Auras: 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune)) +(@CGUID+37, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1495.7274169921875, 1069.1007080078125, 97.29517364501953125, 4.877722740173339843, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+38, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1538.1822509765625, 1056.8975830078125, 71.7068939208984375, 2.064427852630615234, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) +(@CGUID+39, 77518, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1481.654541015625, 1055.8541259765625, 94.54892730712890625, 4.234434127807617187, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Shadow Warrior (Area: -Unknown- - Difficulty: 0) +(@CGUID+40, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1489.8507080078125, 1061.74658203125, 94.55777740478515625, 4.123087882995605468, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) (Auras: 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune)) +(@CGUID+41, 80793, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1576.3333740234375, 1062.2725830078125, 72.54518890380859375, 5.58945322036743164, 7200, 0, 0, 1971, 3191, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune)) +(@CGUID+42, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1494.0069580078125, 1069.8524169921875, 97.36138916015625, 2.944649696350097656, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+43, 77517, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1448.7005615234375, 1019.725830078125, 95.288421630859375, 5.623856067657470703, 7200, 0, 0, 2463, 1283, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+44, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1442.25, 1076.545166015625, 106.39080810546875, 2.632137298583984375, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+45, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1424.2603759765625, 1078.4635009765625, 105.3420028686523437, 0.31838303804397583, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+46, 80793, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1430.673583984375, 1073.69970703125, 104.567138671875, 1.268526434898376464, 7200, 0, 0, 1971, 3191, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune)) +(@CGUID+47, 77518, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1435.8663330078125, 1076.37158203125, 104.4516754150390625, 5.355632781982421875, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Shadow Warrior (Area: -Unknown- - Difficulty: 0) (Auras: 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune)) +(@CGUID+48, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1440.35595703125, 1087.376708984375, 104.4456558227539062, 3.832149505615234375, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+49, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1424.5660400390625, 1086.7569580078125, 105.4241790771484375, 5.756253242492675781, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+50, 72793, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1312.21533203125, 1073.545166015625, 147.801544189453125, 2.059689521789550781, 7200, 0, 0, 12315, 1283, 0, 0, 0, 0, 44232), -- Razuun (Area: -Unknown- - Difficulty: 0) (Auras: 146130 - Cosmetic - Fel Fire Channeling Omni) +(@CGUID+51, 73857, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1302.2899169921875, 1061.876708984375, 147.8588409423828125, 2.237591028213500976, 7200, 0, 0, 2365200, 797750, 0, 0, 0, 0, 44232), -- Gul'dan (Area: -Unknown- - Difficulty: 0) (Auras: 173746 - Shadow Channelling) +(@CGUID+52, 77517, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1404.951416015625, 1019.486083984375, 101.794189453125, 2.698138236999511718, 7200, 10, 0, 2463, 1283, 1, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(@CGUID+53, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1393.5555419921875, 1025.123291015625, 105.8257522583007812, 6.116362571716308593, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+54, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1396.5521240234375, 1022.7725830078125, 107.81207275390625, 6.186385631561279296, 7200, 0, 0, 1847, 0, 0, 0, 33587456, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+55, 77517, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1401.970458984375, 1022.24298095703125, 101.884033203125, 3.031076669692993164, 7200, 0, 0, 2463, 1283, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: 146130 - Cosmetic - Fel Fire Channeling Omni) +(@CGUID+56, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1393.0347900390625, 1021.140625, 105.6394729614257812, 6.139719486236572265, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+57, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1392.59033203125, 1021.21527099609375, 109.18389892578125, 6.122662544250488281, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+58, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1393.1492919921875, 1025.1754150390625, 109.4370346069335937, 6.096427440643310546, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+59, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1368.640625, 1034.9617919921875, 151.839202880859375, 2.443775177001953125, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+60, 80793, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1375.5052490234375, 1064.1197509765625, 147.9542999267578125, 3.745495319366455078, 7200, 0, 0, 1971, 3191, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+61, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1376.80908203125, 1064.9271240234375, 150.5307159423828125, 3.696032524108886718, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+62, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1349.3992919921875, 1022.64581298828125, 150.073944091796875, 1.8012620210647583, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+63, 77518, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1390.1302490234375, 965.873291015625, 131.8693389892578125, 2.284102201461791992, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Shadow Warrior (Area: -Unknown- - Difficulty: 0) +(@CGUID+64, 80793, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1349.0416259765625, 1024.170166015625, 148.36187744140625, 1.75344705581665039, 7200, 0, 0, 1971, 3191, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+65, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 2, 1370.8629150390625, 974.86456298828125, 131.450836181640625, 1.051430940628051757, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) +(@CGUID+66, 80793, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1367.59375, 1035.6146240234375, 149.4924774169921875, 2.416148662567138671, 7200, 0, 0, 1971, 3191, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+67, 77517, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1385.35595703125, 922.83856201171875, 118.2669525146484375, 3.754230022430419921, 7200, 0, 0, 2463, 1283, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+68, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1404.7447509765625, 929.9617919921875, 118.5855789184570312, 3.09320831298828125, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) +(@CGUID+69, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1381.1319580078125, 919.9375, 118.2669677734375, 0.643846333026885986, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) +(@CGUID+70, 77518, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1354.2222900390625, 964.61981201171875, 128.8269805908203125, 4.400142192840576171, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Shadow Warrior (Area: -Unknown- - Difficulty: 0) +(@CGUID+71, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1350.6875, 992.388916015625, 131.53533935546875, 0.032199215143918991, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) +(@CGUID+72, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1387.0103759765625, 903.78472900390625, 118.1648330688476562, 1.454749584197998046, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) +(@CGUID+73, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1332.079833984375, 932.25347900390625, 130.6280059814453125, 4.551133632659912109, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) +(@CGUID+74, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1441.09375, 852.76910400390625, 123.7447967529296875, 5.279994487762451171, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) (Auras: 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune)) +(@CGUID+75, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1396.421875, 853.6649169921875, 118.8933944702148437, 5.288592815399169921, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) +(@CGUID+76, 72674, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1251.0416259765625, 872.08160400390625, 117.5612258911132812, 1.780099987983703613, 7200, 0, 0, 7635, 1924, 0, 0, 0, 0, 44232), -- Grogal the Harvester (Area: -Unknown- - Difficulty: 0) (Auras: 51733 - Shadow Channelling) +(@CGUID+77, 77517, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1376.125, 860.75347900390625, 117.7425155639648437, 2.82718205451965332, 7200, 0, 0, 2463, 1283, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: 146130 - Cosmetic - Fel Fire Channeling Omni) +(@CGUID+78, 77517, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1357.8038330078125, 867.42364501953125, 117.5495986938476562, 5.889403820037841796, 7200, 0, 0, 2463, 1283, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: 146130 - Cosmetic - Fel Fire Channeling Omni) +(@CGUID+79, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1314.3607177734375, 900.54962158203125, 130.566162109375, 4.182347774505615234, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) +(@CGUID+80, 77517, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1362.6939697265625, 849.54119873046875, 117.6012115478515625, 3.313595533370971679, 7200, 0, 0, 2463, 1283, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+81, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1382.6805419921875, 822.03302001953125, 119.1417160034179687, 0.7559548020362854, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) +(@CGUID+82, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1330.6319580078125, 829.9600830078125, 117.8404541015625, 2.477484941482543945, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) +(@CGUID+83, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1306.6754150390625, 858.8992919921875, 117.5776596069335937, 1.328278779983520507, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) +(@CGUID+84, 77517, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1295.532958984375, 911.2586669921875, 129.4506378173828125, 4.53056955337524414, 7200, 0, 0, 2463, 1283, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+85, 77518, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1372.5103759765625, 836.6024169921875, 117.5388641357421875, 1.760763883590698242, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Shadow Warrior (Area: -Unknown- - Difficulty: 0) +(@CGUID+86, 77518, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1423.3194580078125, 826, 119.3945465087890625, 5.660382747650146484, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Shadow Warrior (Area: -Unknown- - Difficulty: 0) +(@CGUID+87, 77518, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1385.5035400390625, 809.7882080078125, 119.1378860473632812, 5.135850906372070312, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Shadow Warrior (Area: -Unknown- - Difficulty: 0) +(@CGUID+88, 77518, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1384.9271240234375, 824.015625, 119.5917892456054687, 3.896007537841796875, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Shadow Warrior (Area: -Unknown- - Difficulty: 0) +(@CGUID+89, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1326.85595703125, 928.951416015625, 130.3241119384765625, 5.702555656433105468, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) +(@CGUID+90, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1299.4010009765625, 910.4617919921875, 129.5037689208984375, 3.926055908203125, 7200, 10, 0, 1847, 0, 1, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+91, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1299.19970703125, 905.482666015625, 129.4561767578125, 2.856860160827636718, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) +(@CGUID+92, 77518, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1336.4774169921875, 808.08331298828125, 118.0975341796875, 3.952999830245971679, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Shadow Warrior (Area: -Unknown- - Difficulty: 0) +(@CGUID+93, 77517, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1314.96533203125, 815.43927001953125, 118.01507568359375, 4.730028152465820312, 7200, 0, 0, 2463, 1283, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: 146130 - Cosmetic - Fel Fire Channeling Omni) +(@CGUID+94, 77518, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1345.3228759765625, 794.98785400390625, 118.4735260009765625, 4.0600433349609375, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Shadow Warrior (Area: -Unknown- - Difficulty: 0) +(@CGUID+95, 77518, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1318.9375, 797.060791015625, 119.2691650390625, 5.084611415863037109, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Shadow Warrior (Area: -Unknown- - Difficulty: 0) +(@CGUID+96, 76380, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1182.3507080078125, 822.18231201171875, 105.5113143920898437, 0, 7200, 0, 0, 14778, 0, 0, 0, 0, 0, 44232), -- Gorum (Area: -Unknown- - Difficulty: 0) +(@CGUID+97, 80793, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1262.060791015625, 888.0225830078125, 118.41290283203125, 4.113819599151611328, 7200, 0, 0, 1971, 3191, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune)) +(@CGUID+98, 77518, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1272.5572509765625, 857.99481201171875, 117.0713043212890625, 5.728406429290771484, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Shadow Warrior (Area: -Unknown- - Difficulty: 0) +(@CGUID+99, 77518, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1310.615478515625, 815.266845703125, 118.2261123657226562, 6.257697582244873046, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Shadow Warrior (Area: -Unknown- - Difficulty: 0) +(@CGUID+100, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1250.2691650390625, 879.33856201171875, 119.6120758056640625, 4.13726043701171875, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) (Auras: 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune)) +(@CGUID+101, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1249.19970703125, 878.56597900390625, 119.6285552978515625, 6.202928066253662109, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) (Auras: 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune)) +(@CGUID+102, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1251.0625, 901.27606201171875, 117.686248779296875, 5.378069400787353515, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) (Auras: 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune)) +(@CGUID+103, 77518, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1317.7569580078125, 766.060791015625, 99.0465087890625, 4.972855567932128906, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Shadow Warrior (Area: -Unknown- - Difficulty: 0) +(@CGUID+104, 77518, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1248.2430419921875, 834.82464599609375, 122.295196533203125, 0.343529671430587768, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Shadow Warrior (Area: -Unknown- - Difficulty: 0) +(@CGUID+105, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1231.68408203125, 811.40277099609375, 125.365692138671875, 0.742831230163574218, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+106, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1235.5816650390625, 819.8125, 126.3585662841796875, 1.193047165870666503, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+107, 77522, 1116, 6719, 6797, '0', 0, 0, 0, 1, 1241.8646240234375, 826.09375, 122.7769393920898437, 4.048214435577392578, 7200, 0, 0, 1847, 0, 0, 0, 0, 0, 44232), -- Gul'var Peon (Area: -Unknown- - Difficulty: 0) +(@CGUID+108, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1320.5711669921875, 983.73956298828125, 141.1061553955078125, 0.91813671588897705, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+109, 80793, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1321.79345703125, 985.33856201171875, 137.796844482421875, 0.947314620018005371, 7200, 0, 0, 1971, 3191, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+110, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1329.48095703125, 1015.05548095703125, 147.3646697998046875, 3.039979457855224609, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+111, 80793, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1328.032958984375, 1015.203125, 145.7552490234375, 2.93128061294555664, 7200, 0, 0, 1971, 3191, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+112, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1301.486083984375, 1024.48095703125, 148.220367431640625, 0.562612891197204589, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+113, 80793, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1302.642333984375, 1025.2100830078125, 146.378570556640625, 0.576924324035644531, 7200, 0, 0, 1971, 3191, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+114, 80793, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1291.75, 1045.328125, 148.752471923828125, 0.564803719520568847, 7200, 0, 0, 1971, 3191, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+115, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1289.6944580078125, 1044.4879150390625, 151.604644775390625, 0.388029634952545166, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+116, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1310.626708984375, 1080.732666015625, 153.4841766357421875, 5.266770362854003906, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+117, 80793, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1354.310791015625, 1081.814208984375, 147.6729888916015625, 3.97063755989074707, 7200, 0, 0, 1971, 3191, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+118, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1310.736083984375, 1080.5850830078125, 150.852783203125, 5.263157844543457031, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+119, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1322.013916015625, 1090.9913330078125, 151.7999725341796875, 4.802734375, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+120, 80793, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1322.2135009765625, 1088.7882080078125, 148.4130096435546875, 4.957859992980957031, 7200, 0, 0, 1971, 3191, 0, 0, 0, 0, 44232), -- Lesser Warlock (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+121, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1355.24658203125, 1083.0625, 149.534820556640625, 4.0691070556640625, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+122, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1307.3992919921875, 1079.1197509765625, 153.436004638671875, 4.99095773696899414, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+123, 24021, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1307.5103759765625, 1078.8489990234375, 150.9644622802734375, 5.146735668182373046, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 44232), -- ELM General Purpose Bunny (scale x0.01) (Area: -Unknown- - Difficulty: 0) +(@CGUID+124, 73101, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1234.329833984375, 821.435791015625, 122.7769393920898437, 0.432259798049926757, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Cursed Wolf (Area: -Unknown- - Difficulty: 0) (Auras: 147629 - Fel-Cursed) +(@CGUID+125, 73101, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1232.2135009765625, 813.890625, 122.7769393920898437, 5.426285266876220703, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Cursed Wolf (Area: -Unknown- - Difficulty: 0) (Auras: 147629 - Fel-Cursed) +(@CGUID+126, 73101, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1492.657958984375, 1070.12158203125, 94.54755401611328125, 4.422297954559326171, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232), -- Cursed Wolf (Area: -Unknown- - Difficulty: 0) (Auras: 147629 - Fel-Cursed) +(@CGUID+127, 73101, 1116, 6719, 6797, '0', 0, 0, 0, 0, 1495.9774169921875, 1067.6024169921875, 94.5065460205078125, 3.903701543807983398, 7200, 0, 0, 2956, 0, 0, 0, 0, 0, 44232); -- Cursed Wolf (Area: -Unknown- - Difficulty: 0) (Auras: 147629 - Fel-Cursed) + +-- Creature Addon +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+127; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+6, 0, 0, 0, 0, 69, 0, 0, 0, 0, ''), -- Gul'var Peon +(@CGUID+8, 0, 0, 0, 0, 425, 0, 0, 0, 0, ''), -- Shadow Warrior +(@CGUID+11, 0, 0, 0, 0, 425, 0, 0, 0, 0, ''), -- Shadow Warrior +(@CGUID+12, 0, 0, 0, 0, 425, 0, 0, 0, 0, ''), -- Shadow Warrior +(@CGUID+13, 0, 0, 50331648, 1, 0, 5594, 0, 0, 0, ''), -- Gul'var Peon +(@CGUID+20, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Gul'var Peon +(@CGUID+22, 0, 0, 0, 0, 425, 0, 0, 0, 0, ''), -- Shadow Warrior +(@CGUID+25, 0, 0, 0, 0, 425, 0, 0, 0, 0, ''), -- Shadow Warrior +(@CGUID+27, 0, 0, 0, 0, 69, 0, 0, 0, 0, ''), -- Gul'var Peon +(@CGUID+28, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Lesser Warlock +(@CGUID+32, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'), -- Gul'var Peon - 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune) +(@CGUID+34, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'), -- Gul'var Peon - 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune) +(@CGUID+36, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'), -- Gul'var Peon - 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune) +(@CGUID+39, 0, 0, 0, 0, 425, 0, 0, 0, 0, ''), -- Shadow Warrior +(@CGUID+40, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'), -- Gul'var Peon - 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune) +(@CGUID+41, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'), -- Lesser Warlock - 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune) +(@CGUID+46, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'), -- Lesser Warlock - 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune) +(@CGUID+47, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'), -- Gul'var Peon - 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune) +(@CGUID+54, 0, 0, 50331648, 1, 0, 5594, 0, 0, 0, ''), -- Gul'var Peon +(@CGUID+63, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Shadow Warrior +(@CGUID+65, 0, 0, 0, 0, 233, 0, 0, 0, 0, ''), -- Gul'var Peon +(@CGUID+67, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Lesser Warlock +(@CGUID+68, 0, 0, 0, 0, 69, 0, 0, 0, 0, ''), -- Gul'var Peon +(@CGUID+69, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Gul'var Peon +(@CGUID+70, 0, 0, 0, 0, 425, 0, 0, 0, 0, ''), -- Shadow Warrior +(@CGUID+71, 0, 0, 0, 0, 69, 0, 0, 0, 0, ''), -- Gul'var Peon +(@CGUID+72, 0, 0, 0, 0, 69, 0, 0, 0, 0, ''), -- Gul'var Peon +(@CGUID+75, 0, 0, 0, 0, 69, 0, 0, 0, 0, ''), -- Gul'var Peon +(@CGUID+82, 0, 0, 0, 0, 69, 0, 0, 0, 0, ''), -- Gul'var Peon +(@CGUID+83, 0, 0, 0, 0, 69, 0, 0, 0, 0, ''), -- Gul'var Peon +(@CGUID+84, 0, 0, 1, 1, 0, 0, 0, 0, 0, '168134'), -- Lesser Warlock +(@CGUID+85, 0, 0, 0, 0, 425, 0, 0, 0, 0, ''), -- Shadow Warrior +(@CGUID+88, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Shadow Warrior +(@CGUID+89, 0, 0, 0, 0, 69, 0, 0, 0, 0, ''), -- Gul'var Peon +(@CGUID+91, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Gul'var Peon +(@CGUID+92, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Shadow Warrior +(@CGUID+98, 0, 0, 0, 0, 425, 0, 0, 0, 0, ''), -- Shadow Warrior +(@CGUID+100, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'), -- Gul'var Peon - 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune) +(@CGUID+101, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '159474'), -- Gul'var Peon - 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune) +(@CGUID+104, 0, 0, 0, 0, 425, 0, 0, 0, 0, ''), -- Shadow Warrior +(@CGUID+107, 0, 0, 0, 0, 431, 0, 0, 0, 0, ''); -- Gul'var Peon + +-- Creature Addon Template +DELETE FROM `creature_template_addon` WHERE `entry` IN (76380, 72674, 73857, 72793, 72647, 72677, 77518, 77488, 80793); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(76380, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''), -- 76380 (Gorum) +(72674, 0, 0, 0, 1, 0, 0, 0, 0, 3, '51733'), -- 72674 (Grogal the Harvester) - Shadow Channelling +(73857, 0, 0, 0, 0, 0, 0, 0, 0, 3, '173746'), -- 73857 (Gul'dan) - Shadow Channelling +(72793, 0, 0, 0, 1, 0, 0, 0, 0, 3, '146130'), -- 72793 (Razuun) - Cosmetic - Fel Fire Channeling Omni +(72647, 0, 0, 0, 1, 0, 0, 0, 0, 3, '51733'), -- 72647 (Corruptor Kurgoth) - Shadow Channelling +(72677, 0, 0, 0, 1, 0, 0, 0, 0, 3, '51733'), -- 72677 (Fel Mistress Hagra) - Shadow Channelling +(77518, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), -- 77518 (Shadow Warrior) +(80793, 0, 0, 0, 1, 0, 5606, 0, 0, 0, ''), -- 80793 (Lesser Warlock) +(77488, 0, 0, 0, 1, 0, 0, 0, 0, 3, '12743'); -- 77488 (Krosnis) - Immolation + +-- Creature Template +UPDATE `creature_template` SET `minlevel`=40, `maxlevel`=40 WHERE `entry`=76380; -- Gorum +UPDATE `creature_template` SET `minlevel`=40, `maxlevel`=40 WHERE `entry`=72674; -- Grogal the Harvester +UPDATE `creature_template` SET `minlevel`=40, `maxlevel`=40 WHERE `entry`=73857; -- Gul'dan +UPDATE `creature_template` SET `minlevel`=40, `maxlevel`=40 WHERE `entry`=72793; -- Razuun +UPDATE `creature_template` SET `minlevel`=40, `maxlevel`=40 WHERE `entry`=72647; -- Corruptor Kurgoth +UPDATE `creature_template` SET `minlevel`=40, `maxlevel`=40 WHERE `entry`=72677; -- Fel Mistress Hagra +UPDATE `creature_template` SET `minlevel`=40, `maxlevel`=40 WHERE `entry`=77488; -- Krosnis +UPDATE `creature_template` SET `minlevel`=40, `maxlevel`=40 WHERE `entry`=77522; -- Gul'var Peon +UPDATE `creature_template` SET `minlevel`=40, `maxlevel`=40 WHERE `entry`=77517; -- Lesser Warlock +UPDATE `creature_template` SET `minlevel`=40, `maxlevel`=40 WHERE `entry`=77518; -- Shadow Warrior +UPDATE `creature_template` SET `minlevel`=40, `maxlevel`=40, `unit_flags`=32768, `unit_flags2`=0, `unit_flags3`=1 WHERE `entry`=80793; -- Lesser Warlock + +-- Creature Equiptment +DELETE FROM `creature_equip_template` WHERE (`CreatureID`=72793 AND `ID`=1); +INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `AppearanceModID1`, `ItemVisual1`, `ItemID2`, `AppearanceModID2`, `ItemVisual2`, `ItemID3`, `AppearanceModID3`, `ItemVisual3`, `VerifiedBuild`) VALUES +(72793, 1, 25879, 0, 0, 0, 0, 0, 0, 0, 0, 44232); -- Razuun + +-- Scaling +DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=0 AND `Entry` IN (78903,78902,76380,72674,73857,72793,80793,72647,72677,77488,77522,77517,77518)); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(78903, 0, 0, 0, 63, 44232), +(78902, 0, 0, 0, 63, 44232), +(76380, 0, 0, 0, 63, 44232), +(72674, 0, 0, 0, 63, 44232), +(73857, 0, 0, 0, 63, 44232), +(72793, 0, 0, 0, 63, 44232), +(80793, 0, 0, 0, 63, 44232), +(72647, 0, 0, 0, 63, 44232), +(72677, 0, 0, 0, 63, 44232), +(77488, 0, 0, 0, 63, 44232), +(77522, 0, 0, 0, 63, 44232), +(77517, 0, 0, 0, 63, 44232), +(77518, 0, 0, 0, 63, 44232); + +UPDATE `creature_template_scaling` SET `VerifiedBuild`=44232 WHERE (`DifficultyID`=0 AND `Entry` IN (78857,76382,78856,73101,73805,50487,24021,72785,52187)); + +-- Creature Text +DELETE FROM `creature_text` WHERE `CreatureID` = 80793; +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(80793, 0, 0, 'The pain!', 12, 0, 100, 0, 0, 0, 75975, 0, 'Lesser Warlock to Player'), +(80793, 1, 0, '...kill... me.', 12, 0, 100, 0, 0, 0, 76091, 0, 'Lesser Warlock to Player'); + +-- Creature Movement Override +DELETE FROM `creature_movement_override` WHERE `SpawnId` IN (@CGUID+13, @CGUID+54); +INSERT INTO `creature_movement_override` (`SpawnId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`, `InteractionPauseTimer`) VALUES +(@CGUID+13, 1, 0, 1, 0, 0, 0, NULL), +(@CGUID+54, 1, 0, 1, 0, 0, 0, NULL); + +-- Add SpellScript to Feign Death Aura +DELETE FROM `spell_script_names` WHERE `spell_id` = 159474; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(159474, 'spell_gen_feign_death_all_flags'); + +-- Serverside Spell +DELETE FROM `serverside_spell` WHERE `ID` IN(168134, 168135); +INSERT INTO `serverside_spell` (`Id`, `DifficultyID`, `CategoryId`, `Dispel`, `Mechanic`, `Attributes`, `AttributesEx`, `AttributesEx2`, `AttributesEx3`, `AttributesEx4`, `AttributesEx5`, `AttributesEx6`, `AttributesEx7`, `AttributesEx8`, `AttributesEx9`, `AttributesEx10`, `AttributesEx11`, `AttributesEx12`, `AttributesEx13`, `AttributesEx14`, `Stances`, `StancesNot`, `Targets`, `TargetCreatureType`, `RequiresSpellFocus`, `FacingCasterFlags`, `CasterAuraState`, `TargetAuraState`, `ExcludeCasterAuraState`, `ExcludeTargetAuraState`, `CasterAuraSpell`, `TargetAuraSpell`, `ExcludeCasterAuraSpell`, `ExcludeTargetAuraSpell`, `CastingTimeIndex`, `RecoveryTime`, `CategoryRecoveryTime`, `StartRecoveryCategory`, `StartRecoveryTime`, `InterruptFlags`, `AuraInterruptFlags1`, `AuraInterruptFlags2`, `ChannelInterruptFlags1`, `ChannelInterruptFlags2`, `ProcFlags`, `ProcFlags2`, `ProcChance`, `ProcCharges`, `ProcCooldown`, `ProcBasePPM`, `MaxLevel`, `BaseLevel`, `SpellLevel`, `DurationIndex`, `RangeIndex`, `Speed`, `LaunchDelay`, `StackAmount`, `EquippedItemClass`, `EquippedItemSubClassMask`, `EquippedItemInventoryTypeMask`, `ContentTuningId`, `SpellName`, `ConeAngle`, `ConeWidth`, `MaxTargetLevel`, `MaxAffectedTargets`, `SpellFamilyName`, `SpellFamilyFlags1`, `SpellFamilyFlags2`, `SpellFamilyFlags3`, `SpellFamilyFlags4`, `DmgClass`, `PreventionType`, `AreaGroupId`, `SchoolMask`, `ChargeCategoryId`) VALUES +(168134, 0, 0, 0, 0, 0x8000080, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 21, 1, 0, 0, 0, -1, 0, 0, 0, 'Warlock Affinity', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(168135, 0, 0, 0, 0, 0x8000080, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 21, 1, 0, 0, 0, -1, 0, 0, 0, 'Warlock Affinity', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); + +DELETE FROM `serverside_spell_effect` WHERE `SpellID` IN(168134, 168134); +INSERT INTO `serverside_spell_effect` (`SpellID`, `EffectIndex`, `DifficultyID`, `Effect`, `EffectAura`, `EffectAmplitude`, `EffectAttributes`, `EffectAuraPeriod`, `EffectBonusCoefficient`, `EffectChainAmplitude`, `EffectChainTargets`, `EffectItemType`, `EffectMechanic`, `EffectPointsPerResource`, `EffectPosFacing`, `EffectRealPointsPerLevel`, `EffectTriggerSpell`, `BonusCoefficientFromAP`, `PvpMultiplier`, `Coefficient`, `Variance`, `ResourceCoefficient`, `GroupSizeBasePointsCoefficient`, `EffectBasePoints`, `EffectMiscValue1`, `EffectMiscValue2`, `EffectRadiusIndex1`, `EffectRadiusIndex2`, `EffectSpellClassMask1`, `EffectSpellClassMask2`, `EffectSpellClassMask3`, `EffectSpellClassMask4`, `ImplicitTarget1`, `ImplicitTarget2`) VALUES +(168134, 0, 0, 6, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(168135, 0, 0, 6, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); + +-- GameObject +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+18; +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, 238041, 1116, 6719, 6797, '0', 0, 0, 1572.8992919921875, 1012.078125, 75.9723358154296875, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 7200, 255, 1, 44232), -- Cookpot (Area: -Unknown- - Difficulty: 0) +(@OGUID+1, 238041, 1116, 6719, 6797, '0', 0, 0, 1572.8992919921875, 1012.078125, 75.9723358154296875, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 7200, 255, 1, 44232), -- Cookpot (Area: -Unknown- - Difficulty: 0) +(@OGUID+2, 237546, 1116, 6719, 6797, '0', 0, 0, 1536.77490234375, 1062.181396484375, 71.79447174072265625, 5.183629035949707031, 0, 0, -0.52249813079833984, 0.852640450000762939, 7200, 255, 1, 44232), -- Cooking Fire (Area: -Unknown- - Difficulty: 0) +(@OGUID+3, 238447, 1116, 6719, 6797, '0', 0, 0, 1388.3785400390625, 967.98785400390625, 131.343505859375, 4.7638702392578125, -0.01070117950439453, -0.0245819091796875, -0.68825817108154296, 0.724970340728759765, 7200, 255, 1, 44232), -- Campfire (Area: -Unknown- - Difficulty: 0) +(@OGUID+4, 238444, 1116, 6719, 6797, '0', 0, 0, 1381.2396240234375, 971.55035400390625, 131.2327423095703125, 2.888511419296264648, 0, 0, 0.99200439453125, 0.126203224062919616, 7200, 255, 1, 44232), -- Anvil (Area: -Unknown- - Difficulty: 0) +(@OGUID+5, 238445, 1116, 6719, 6797, '0', 0, 0, 1371.48095703125, 976.19268798828125, 131.3991241455078125, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 7200, 255, 1, 44232), -- Anvil (Area: -Unknown- - Difficulty: 0) +(@OGUID+6, 236290, 1116, 6719, 6797, '0', 0, 0, 1383.037841796875, 921.09063720703125, 117.9286117553710937, 4.433139801025390625, 0, 0, -0.79863452911376953, 0.601816356182098388, 7200, 255, 1, 44232), -- Cooking Fire (Area: -Unknown- - Difficulty: 0) +(@OGUID+7, 238037, 1116, 6719, 6797, '0', 0, 0, 1331.720458984375, 926.7569580078125, 130.223724365234375, 0.750490784645080566, 0, 0, 0.3665008544921875, 0.93041771650314331, 7200, 255, 1, 44232), -- Cookpot (Area: -Unknown- - Difficulty: 0) +(@OGUID+8, 238514, 1116, 6719, 6797, '0', 0, 0, 1366.7691650390625, 862.8663330078125, 117.6121673583984375, 1.160643696784973144, 0, 0, 0.548293113708496093, 0.83628624677658081, 7200, 255, 1, 44232), -- Cookpot (Area: -Unknown- - Difficulty: 0) +(@OGUID+9, 238036, 1116, 6719, 6797, '0', 0, 0, 1326.76220703125, 922.3663330078125, 130.296478271484375, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 7200, 255, 1, 44232), -- Cookpot (Area: -Unknown- - Difficulty: 0) +(@OGUID+10, 224785, 1116, 6719, 6797, '0', 0, 0, 1291.4410400390625, 903.61285400390625, 129.36505126953125, 0.745831191539764404, 0, 0, 0.364332199096679687, 0.931269049644470214, 7200, 255, 1, 44232), -- Demonic Cache (Area: -Unknown- - Difficulty: 0) +(@OGUID+11, 238038, 1116, 6719, 6797, '0', 0, 0, 1333.095458984375, 804.36114501953125, 117.483673095703125, 4.057891845703125, 0, 0, -0.89687252044677734, 0.442289173603057861, 7200, 255, 1, 44232), -- Campfire (Area: -Unknown- - Difficulty: 0) +(@OGUID+12, 220559, 1116, 6719, 6797, '0', 0, 0, 1186.3489990234375, 825.90625, 105.4835662841796875, 0.726055681705474853, 0, 0, 0.355106353759765625, 0.934825897216796875, 7200, 255, 1, 44232), -- Bones (Area: -Unknown- - Difficulty: 0) +(@OGUID+13, 229634, 1116, 6719, 6797, '0', 0, 0, 1179.232666015625, 824.015625, 105.5712203979492187, 3.403294086456298828, 0, 0, -0.99145126342773437, 0.130477577447891235, 7200, 255, 1, 44232), -- Bones (Area: -Unknown- - Difficulty: 0) +(@OGUID+14, 229634, 1116, 6719, 6797, '0', 0, 0, 1186.0382080078125, 824.21356201171875, 105.4499893188476562, 0.824881196022033691, 0, 0, 0.400846481323242187, 0.916145205497741699, 7200, 255, 1, 44232), -- Bones (Area: -Unknown- - Difficulty: 0) +(@OGUID+15, 229635, 1116, 6719, 6797, '0', 0, 0, 1176.013916015625, 819.56597900390625, 105.5102767944335937, 0.516968071460723876, 0, 0, 0.255615234375, 0.966778576374053955, 7200, 255, 1, 44232), -- Bones (Area: -Unknown- - Difficulty: 0) +(@OGUID+16, 220559, 1116, 6719, 6797, '0', 0, 0, 1176.2760009765625, 814.51043701171875, 104.82745361328125, 4.320775032043457031, 0, 0, -0.83116817474365234, 0.556021094322204589, 7200, 255, 1, 44232), -- Bones (Area: -Unknown- - Difficulty: 0) +(@OGUID+17, 229634, 1116, 6719, 6797, '0', 0, 0, 1175.41845703125, 815.97222900390625, 104.9863433837890625, 2.519008636474609375, 0, 0, 0.951938629150390625, 0.306288778781890869, 7200, 255, 1, 44232), -- Bones (Area: -Unknown- - Difficulty: 0) +(@OGUID+18, 238446, 1116, 6719, 6797, '0', 0, 0, 1303.5694580078125, 1068.546875, 147.8557891845703125, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 7200, 255, 1, 44232); -- Cookpot (Area: -Unknown- - Difficulty: 0) + +-- GameObject Template +UPDATE `gameobject_template_addon` SET `WorldEffectID`=2437 WHERE `entry`=224785; -- Demonic Cache + +-- SAI Scripts +UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` IN (24021, 77517, 72647, 77488, 72677, 72674, 80793, 73857, 72793); + +DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` IN (73857, 72793, 72647, 72677, 72674, -(@CGUID+25), -(@CGUID+29), -(@CGUID+7), -(@CGUID+21), -(@CGUID+57), -(@CGUID+58), -(@CGUID+56), -(@CGUID+53), -(@CGUID+42), -(@CGUID+37), -(@CGUID+44), -(@CGUID+45), -(@CGUID+48), -(@CGUID+49), -(@CGUID+23), -(@CGUID+55), -(@CGUID+2), -(@CGUID+33), -(@CGUID+9), -(@CGUID+26), -(@CGUID+35), -(@CGUID+43), -(@CGUID+52), -(@CGUID+10), -(@CGUID+77), -(@CGUID+78), -(@CGUID+93), -(@CGUID+80), -(@CGUID+108), -(@CGUID+112), -(@CGUID+115), -(@CGUID+110), -(@CGUID+62), -(@CGUID+59), -(@CGUID+61), -(@CGUID+121), -(@CGUID+119), -(@CGUID+106), -(@CGUID+105), -(@CGUID+84), -(@CGUID+60), -(@CGUID+64), -(@CGUID+66), -(@CGUID+109), -(@CGUID+111), -(@CGUID+113), -(@CGUID+114), -(@CGUID+117), -(@CGUID+120)); +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `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 +(73857, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 173746, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'OnRespawn - Cast spell "(Guldan) - Shadow Channelling" - to self'), +(72793, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 146130, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'OnRespawn - Cast spell "Cosmetic - Fel Fire Channeling Omni" - to self'), +(72647, 0, 0, 0, 1, 0, 100, 1, 0, 0, 0, 0, 11, 51733, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'OOC - Cast spell "Cosmetic - Shadow Channelling" - to self'), +(72677, 0, 0, 0, 1, 0, 100, 1, 0, 0, 0, 0, 11, 51733, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'OOC - Cast spell "Cosmetic - Shadow Channelling" - to self'), +(72674, 0, 0, 0, 1, 0, 100, 1, 0, 0, 0, 0, 11, 51733, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'OOC - Cast spell "Cosmetic - Shadow Channelling" - to self'), +(-(@CGUID+25), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 147675, 0, 0, 0, 0, 0, 19, 77522, 5, 0, 0, 0, 0, 0, 'OnRespawn - Cast spell "Gulvar Chain Victim: Fel Chain to Right Hand" - to nearest Gulvar Peon'), +(-(@CGUID+29), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 147480, 0, 0, 0, 0, 0, 19, 77522, 5, 0, 0, 0, 0, 0, 'OnRespawn - Cast spell "Gulvar Chain Victim: Fel Chain to Left Hand" - to nearest Gulvar Peon'), +(-(@CGUID+7), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 147001, 0, 0, 0, 0, 0, 19, 77522, 5, 0, 0, 0, 0, 0, 'OnRespawn - Cast spell "Gulvar Chain Victim: Fel Chain to Right Foot" - to nearest Gulvar Peon'), +(-(@CGUID+21), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 147664, 0, 0, 0, 0, 0, 19, 77522, 5, 0, 0, 0, 0, 0, 'OnRespawn - Cast spell "Gulvar Chain Victim: Fel Chain to Left Foot" - to nearest Gulvar Peon'), +(-(@CGUID+57), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 147675, 0, 0, 0, 0, 0, 19, 77522, 5, 0, 0, 0, 0, 0, 'OnRespawn - Cast spell "Gulvar Chain Victim: Fel Chain to Right Hand" - to nearest Gulvar Peon'), +(-(@CGUID+58), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 147480, 0, 0, 0, 0, 0, 19, 77522, 5, 0, 0, 0, 0, 0, 'OnRespawn - Cast spell "Gulvar Chain Victim: Fel Chain to Left Hand" - to nearest Gulvar Peon'), +(-(@CGUID+56), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 147001, 0, 0, 0, 0, 0, 19, 77522, 5, 0, 0, 0, 0, 0, 'OnRespawn - Cast spell "Gulvar Chain Victim: Fel Chain to Right Foot" - to nearest Gulvar Peon'), +(-(@CGUID+53), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 147664, 0, 0, 0, 0, 0, 19, 77522, 5, 0, 0, 0, 0, 0, 'OnRespawn - Cast spell "Gulvar Chain Victim: Fel Chain to Left Foot" - to nearest Gulvar Peon'), +(-(@CGUID+42), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 147174, 0, 0, 0, 0, 0, 10, (@CGUID+126), 73101, 0, 0, 0, 0, 0, 'OnRespawn - Cast spell "Tainted Wolf in Gulvar: Chains" - to nearest Cursed Wolf'), +(-(@CGUID+37), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 147174, 0, 0, 0, 0, 0, 10, (@CGUID+127), 73101, 0, 0, 0, 0, 0, 'OnRespawn - Cast spell "Tainted Wolf in Gulvar: Chains" - to nearest Cursed Wolf'), +(-(@CGUID+44), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 148737, 0, 0, 0, 0, 0, 10, (@CGUID+10), 77488, 0, 0, 0, 0, 0, 'OnRespawn - Cast spell "Have a Heart: Chain to Fernus - Left Hand" - to Krosnis'), +(-(@CGUID+48), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 148737, 0, 0, 0, 0, 0, 10, (@CGUID+10), 77488, 0, 0, 0, 0, 0, 'OnRespawn - Cast spell "Have a Heart: Chain to Fernus - Left Hand" - to Krosnis'), +(-(@CGUID+45), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 148738, 0, 0, 0, 0, 0, 10, (@CGUID+10), 77488, 0, 0, 0, 0, 0, 'OnRespawn - Cast spell "Have a Heart: Chain to Fernus - Right Hand" - to Krosnis'), +(-(@CGUID+49), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 148738, 0, 0, 0, 0, 0, 10, (@CGUID+10), 77488, 0, 0, 0, 0, 0, 'OnRespawn - Cast spell "Have a Heart: Chain to Fernus - Right Hand" - to Krosnis'), +(-(@CGUID+23), 0, 0, 0, 1, 0, 100, 1, 0, 0, 0, 0, 11, 146130, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'OOC - Cast spell "Cosmetic - Fel Fire Channeling Omni" - to self'), +(-(@CGUID+55), 0, 0, 0, 1, 0, 100, 1, 0, 0, 0, 0, 11, 146130, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'OOC - Cast spell "Cosmetic - Fel Fire Channeling Omni" - to self'), +(-(@CGUID+2), 0, 0, 0, 1, 0, 100, 1, 0, 0, 0, 0, 11, 146130, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'OOC - Cast spell "Cosmetic - Fel Fire Channeling Omni" - to self'), +(-(@CGUID+33), 0, 0, 0, 1, 0, 100, 1, 0, 0, 0, 0, 11, 146130, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'OOC - Cast spell "Cosmetic - Fel Fire Channeling Omni" - to self'), +(-(@CGUID+9), 0, 0, 0, 1, 0, 100, 1, 0, 0, 0, 0, 11, 146130, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'OOC - Cast spell "Cosmetic - Fel Fire Channeling Omni" - to self'), +(-(@CGUID+26), 0, 0, 0, 1, 0, 100, 1, 0, 0, 0, 0, 11, 146130, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'OOC - Cast spell "Cosmetic - Fel Fire Channeling Omni" - to self'), +(-(@CGUID+35), 0, 0, 0, 1, 0, 100, 1, 0, 0, 0, 0, 11, 146130, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'OOC - Cast spell "Cosmetic - Fel Fire Channeling Omni" - to self'), +(-(@CGUID+77), 0, 0, 0, 1, 0, 100, 1, 0, 0, 0, 0, 11, 146130, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'OOC - Cast spell "Cosmetic - Fel Fire Channeling Omni" - to self'), +(-(@CGUID+78), 0, 0, 0, 1, 0, 100, 1, 0, 0, 0, 0, 11, 146130, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'OOC - Cast spell "Cosmetic - Fel Fire Channeling Omni" - to self'), +(-(@CGUID+93), 0, 0, 0, 1, 0, 100, 1, 0, 0, 0, 0, 11, 146130, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'OOC - Cast spell "Cosmetic - Fel Fire Channeling Omni" - to self'), +(-(@CGUID+43), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 168138, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'OnRespawn - Cast spell "Summon Observer" - to self'), +(-(@CGUID+80), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 168138, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'OnRespawn - Cast spell "Summon Observer" - to self'), +(-(@CGUID+84), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 168138, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'OnRespawn - Cast spell "Summon Observer" - to self'), +(-(@CGUID+52), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 168139, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'OnRespawn - Cast spell "Summon Voidwalker" - to self'), +(-(@CGUID+10), 0, 0, 0, 1, 0, 100, 0, 7000, 11000, 7000, 11000, 10, 33, 35, 33, 35, 33, 35, 1, 0, 0, 0, 0, 0, 0, 0, 'OOC every 7-11s - do rnd Emote 33 and 35 - to self'), +(-(@CGUID+108), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 149136, 0, 0, 0, 0, 0, 19, 80793, 5, 0, 0, 0, 0, 0, 'OOC - Cast spell "Shadow Rise Chain Victim: Fel Chain to Neck" - to nearest Lesser Warlock'), +(-(@CGUID+112), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 149136, 0, 0, 0, 0, 0, 19, 80793, 5, 0, 0, 0, 0, 0, 'OOC - Cast spell "Shadow Rise Chain Victim: Fel Chain to Neck" - to nearest Lesser Warlock'), +(-(@CGUID+115), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 149136, 0, 0, 0, 0, 0, 19, 80793, 5, 0, 0, 0, 0, 0, 'OOC - Cast spell "Shadow Rise Chain Victim: Fel Chain to Neck" - to nearest Lesser Warlock'), +(-(@CGUID+110), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 149136, 0, 0, 0, 0, 0, 19, 80793, 5, 0, 0, 0, 0, 0, 'OOC - Cast spell "Shadow Rise Chain Victim: Fel Chain to Neck" - to nearest Lesser Warlock'), +(-(@CGUID+62), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 149136, 0, 0, 0, 0, 0, 19, 80793, 5, 0, 0, 0, 0, 0, 'OOC - Cast spell "Shadow Rise Chain Victim: Fel Chain to Neck" - Lesser Warlock'), +(-(@CGUID+59), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 149136, 0, 0, 0, 0, 0, 19, 80793, 5, 0, 0, 0, 0, 0, 'OOC - Cast spell "Shadow Rise Chain Victim: Fel Chain to Neck" - Lesser Warlock'), +(-(@CGUID+61), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 149136, 0, 0, 0, 0, 0, 19, 80793, 5, 0, 0, 0, 0, 0, 'OOC - Cast spell "Shadow Rise Chain Victim: Fel Chain to Neck" - Lesser Warlock'), +(-(@CGUID+121), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 149136, 0, 0, 0, 0, 0, 19, 80793, 5, 0, 0, 0, 0, 0, 'OOC - Cast spell "Shadow Rise Chain Victim: Fel Chain to Neck" - Lesser Warlock'), +(-(@CGUID+119), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 149136, 0, 0, 0, 0, 0, 19, 80793, 5, 0, 0, 0, 0, 0, 'OOC - Cast spell "Shadow Rise Chain Victim: Fel Chain to Neck" - Lesser Warlock'), +(-(@CGUID+106), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 147174, 0, 0, 0, 0, 0, 10, (@CGUID+124), 73101, 0, 0, 0, 0, 0, 'OnRespawn - Cast spell "Tainted Wolf in Gulvar: Chains" - to nearest Cursed Wolf'), +(-(@CGUID+105), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 147174, 0, 0, 0, 0, 0, 10, (@CGUID+125), 73101, 0, 0, 0, 0, 0, 'OnRespawn - Cast spell "Tainted Wolf in Gulvar: Chains" - to nearest Cursed Wolf'), +(-(@CGUID+60), 0, 0, 1, 11, 0, 100, 0, 0, 0, 0, 0, 102, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On respawn - Self: Do not regenerate HP'), +(-(@CGUID+64), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 102, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On respawn - Self: Do not regenerate HP'), +(-(@CGUID+66), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 102, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On respawn - Self: Do not regenerate HP'), +(-(@CGUID+109), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 102, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On respawn - Self: Do not regenerate HP'), +(-(@CGUID+111), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 102, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On respawn - Self: Do not regenerate HP'), +(-(@CGUID+113), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 102, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On respawn - Self: Do not regenerate HP'), +(-(@CGUID+114), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 102, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On respawn - Self: Do not regenerate HP'), +(-(@CGUID+117), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 102, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On respawn - Self: Do not regenerate HP'), +(-(@CGUID+120), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 102, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On respawn - Self: Do not regenerate HP'); + +-- Waypoints for CGUID+1 +SET @PATH := @CGUID+1 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 1531.819, 997.6875, 75.86732, NULL, 0), +(@PATH, 1, 1536.068, 996.7031, 75.86813, NULL, 0), +(@PATH, 2, 1541.135, 989.7621, 76.41293, NULL, 0), +(@PATH, 3, 1545.316, 977.9948, 76.36813, NULL, 0), +(@PATH, 4, 1546.274, 965.0729, 77.54283, NULL, 0), +(@PATH, 5, 1546.512, 952.2621, 79.73961, NULL, 0), +(@PATH, 6, 1547.813, 939.7118, 79.25743, NULL, 0), +(@PATH, 7, 1549.411, 924.9288, 77.77522, NULL, 21386), +(@PATH, 8, 1547.813, 939.7118, 79.25743, NULL, 0), +(@PATH, 9, 1546.512, 952.2621, 79.73961, NULL, 0), +(@PATH, 10, 1546.274, 965.0729, 77.54283, NULL, 0), +(@PATH, 11, 1545.316, 977.9948, 76.36813, NULL, 0), +(@PATH, 12, 1541.135, 989.7621, 76.41293, NULL, 0), +(@PATH, 13, 1536.068, 996.7031, 75.86813, NULL, 0), +(@PATH, 14, 1531.819, 997.6875, 75.86732, NULL, 0), +(@PATH, 15, 1525.38, 996.2934, 75.36732, NULL, 21437); + +UPDATE `creature` SET `position_x`= 1531.819, `position_y`= 997.6875, `position_z`= 75.86732, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+1; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+1; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+1, @PATH, 1); + +-- Waypoints for CGUID+4 +SET @PATH := @CGUID+4 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 1548.12, 993.8663, 75.16672, NULL, 0), +(@PATH, 1, 1542.278, 978.7327, 76.36813, NULL, 0), +(@PATH, 2, 1537.774, 969.5989, 76.93698, NULL, 0), +(@PATH, 3, 1531.785, 961.9219, 76.88147, NULL, 0), +(@PATH, 4, 1524.594, 952.7101, 77.26501, NULL, 0), +(@PATH, 5, 1519.486, 943.9427, 77.16589, NULL, 0), +(@PATH, 6, 1515.844, 932.3351, 76.78776, NULL, 0), +(@PATH, 7, 1514.134, 922.2153, 76.44828, NULL, 0), +(@PATH, 8, 1513.819, 913.3663, 75.51151, NULL, 0), +(@PATH, 9, 1514.526, 901.6528, 74.30009, NULL, 0), +(@PATH, 10, 1514.563, 888.4445, 72.62299, NULL, 0), +(@PATH, 11, 1514.545, 879.5695, 71.80097, NULL, 0), +(@PATH, 12, 1514.109, 873.9184, 71.05, NULL, 21241), +(@PATH, 13, 1514.545, 879.5695, 71.80097, NULL, 0), +(@PATH, 14, 1514.563, 888.4445, 72.62299, NULL, 0), +(@PATH, 15, 1514.526, 901.6528, 74.30009, NULL, 0), +(@PATH, 16, 1513.819, 913.3663, 75.51151, NULL, 0), +(@PATH, 17, 1514.134, 922.2153, 76.44828, NULL, 0), +(@PATH, 18, 1515.844, 932.3351, 76.78776, NULL, 0), +(@PATH, 19, 1519.486, 943.9427, 77.16589, NULL, 0), +(@PATH, 20, 1524.594, 952.7101, 77.26501, NULL, 0), +(@PATH, 21, 1531.785, 961.9219, 76.88147, NULL, 0), +(@PATH, 22, 1537.774, 969.5989, 76.93698, NULL, 0), +(@PATH, 23, 1542.278, 978.7327, 76.36813, NULL, 0), +(@PATH, 24, 1548.12, 993.8663, 75.16672, NULL, 0), +(@PATH, 25, 1553.625, 1012.71, 72.65073, NULL, 0), +(@PATH, 26, 1554.771, 1025.517, 71.07358, NULL, 0), +(@PATH, 27, 1551.997, 1034.332, 71.31058, NULL, 0), +(@PATH, 28, 1547.214, 1046.399, 70.6188, NULL, 20874), +(@PATH, 29, 1551.997, 1034.332, 71.31058, NULL, 0), +(@PATH, 30, 1554.771, 1025.517, 71.07358, NULL, 0), +(@PATH, 31, 1553.625, 1012.71, 72.65073, NULL, 0); + +UPDATE `creature` SET `position_x`= 1548.12, `position_y`= 993.8663, `position_z`= 75.16672, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+4; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+4; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+4, @PATH, 1); + +-- Waypoints for CGUID+38 +SET @PATH := @CGUID+38 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 1542.17, 1050.689, 71.70689, NULL, 0), +(@PATH, 1, 1544.163, 1047.283, 70.98489, NULL, 0), +(@PATH, 2, 1548.965, 1039.938, 70.92874, NULL, 0), +(@PATH, 3, 1556.095, 1030.823, 71.07358, NULL, 0), +(@PATH, 4, 1561.415, 1024.307, 71.93808, NULL, 0), +(@PATH, 5, 1565.241, 1019.69, 74.19858, NULL, 0), +(@PATH, 6, 1568.592, 1015.852, 74.88304, NULL, 14828), +(@PATH, 7, 1565.301, 1019.617, 74.19858, NULL, 0), +(@PATH, 8, 1561.415, 1024.307, 71.93808, NULL, 0), +(@PATH, 9, 1556.095, 1030.823, 71.07358, NULL, 0), +(@PATH, 10, 1548.965, 1039.938, 70.92874, NULL, 0), +(@PATH, 11, 1544.163, 1047.283, 70.98489, NULL, 0), +(@PATH, 12, 1542.17, 1050.689, 71.70206, NULL, 0), +(@PATH, 13, 1539.042, 1055.3, 71.70689, NULL, 0), +(@PATH, 14, 1538.182, 1056.898, 71.70689, NULL, 14234); + +UPDATE `creature` SET `position_x`= 1542.17, `position_y`= 1050.689, `position_z`= 71.70689, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+38; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+38; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+38, @PATH, 1); + +-- Waypoints for CGUID+16 +SET @PATH := @CGUID+16 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 1473.948, 1035.37, 94.51041, NULL, 0), +(@PATH, 1, 1474.045, 1028.309, 95.16076, NULL, 0), +(@PATH, 2, 1476.054, 1021.948, 94.92968, NULL, 0), +(@PATH, 3, 1478.925, 1021.151, 95.37598, NULL, 0), +(@PATH, 4, 1481.736, 1021.57, 95.50377, NULL, 0), +(@PATH, 5, 1487.192, 1022.763, 95.50591, NULL, 19557), +(@PATH, 6, 1481.736, 1021.57, 95.50377, NULL, 0), +(@PATH, 7, 1478.925, 1021.151, 95.37598, NULL, 0), +(@PATH, 8, 1476.041, 1021.875, 95.04736, NULL, 0), +(@PATH, 9, 1474.045, 1028.309, 95.16076, NULL, 0), +(@PATH, 10, 1473.948, 1035.37, 94.51041, NULL, 0), +(@PATH, 11, 1478.891, 1045.082, 94.50602, NULL, 0), +(@PATH, 12, 1484.438, 1053.554, 94.50602, NULL, 0), +(@PATH, 13, 1488.757, 1059.979, 94.50602, NULL, 14592), +(@PATH, 14, 1484.438, 1053.554, 94.50602, NULL, 0), +(@PATH, 15, 1478.891, 1045.082, 94.50602, NULL, 0); + +UPDATE `creature` SET `position_x`= 1473.948, `position_y`= 1035.37, `position_z`= 94.51041, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+16; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+16; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+16, @PATH, 1); + +-- Waypoints for CGUID+52 +SET @PATH := @CGUID+52 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 1422.512, 1011.18, 99.03027, NULL, 0), +(@PATH, 1, 1424.957, 1007.889, 98.78503, NULL, 0), +(@PATH, 2, 1425.563, 1002.564, 99.66895, NULL, 0), +(@PATH, 3, 1425.653, 991.2014, 101.6825, NULL, 0), +(@PATH, 4, 1423.594, 975.3854, 104.9523, NULL, 0), +(@PATH, 5, 1423.083, 960.9739, 108.0499, NULL, 0), +(@PATH, 6, 1426.854, 949.9583, 110.7287, NULL, 0), +(@PATH, 7, 1431.837, 942.0538, 113.7397, NULL, 0), +(@PATH, 8, 1438.731, 934.0729, 116.4576, NULL, 0), +(@PATH, 9, 1443.413, 928.9323, 117.3925, NULL, 20563), +(@PATH, 10, 1438.731, 934.0729, 116.4576, NULL, 0), +(@PATH, 11, 1431.837, 942.0538, 113.7397, NULL, 0), +(@PATH, 12, 1426.854, 949.9583, 110.7287, NULL, 0), +(@PATH, 13, 1423.083, 960.9739, 108.0499, NULL, 0), +(@PATH, 14, 1423.594, 975.3854, 104.9523, NULL, 0), +(@PATH, 15, 1425.653, 991.2014, 101.6825, NULL, 0), +(@PATH, 16, 1425.563, 1002.564, 99.66895, NULL, 0), +(@PATH, 17, 1424.957, 1007.889, 98.78503, NULL, 0), +(@PATH, 18, 1422.512, 1011.18, 99.03027, NULL, 0), +(@PATH, 19, 1413.469, 1015.438, 101.2942, NULL, 0), +(@PATH, 20, 1404.951, 1019.486, 101.7942, NULL, 20585), +(@PATH, 21, 1413.415, 1015.467, 101.2126, NULL, 0); + +UPDATE `creature` SET `position_x`= 1422.512, `position_y`= 1011.18, `position_z`= 99.03027, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+52; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+52; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`, `auras`) VALUES +(@CGUID+52, @PATH, 1, 168135); + +-- Waypoints for CGUID+43 +SET @PATH := @CGUID+43 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 1439.243, 1028.408, 97.98031, NULL, 0), +(@PATH, 1, 1446.38, 1021.524, 96.02755, NULL, 0), +(@PATH, 2, 1456.363, 1013.783, 94.07955, NULL, 0), +(@PATH, 3, 1464.257, 1006.304, 92.95126, NULL, 0), +(@PATH, 4, 1470.328, 998.5156, 91.25275, NULL, 0), +(@PATH, 5, 1483.347, 978.5104, 85.89668, NULL, 0), +(@PATH, 6, 1496.547, 960.2952, 80.02731, NULL, 0), +(@PATH, 7, 1504.535, 950.7118, 78.03796, NULL, 0), +(@PATH, 8, 1508.243, 947.7604, 77.51501, NULL, 0), +(@PATH, 9, 1510.847, 946.3125, 77.27576, NULL, 0), +(@PATH, 10, 1513.252, 947.3246, 77.35376, NULL, 0), +(@PATH, 11, 1514.241, 948.743, 77.40515, NULL, 0), +(@PATH, 12, 1514.333, 950.2691, 77.54724, NULL, 21298), +(@PATH, 13, 1510.847, 946.3125, 77.27576, NULL, 0), +(@PATH, 14, 1508.243, 947.7604, 77.51501, NULL, 0), +(@PATH, 15, 1504.535, 950.7118, 78.03796, NULL, 0), +(@PATH, 16, 1496.547, 960.2952, 80.02731, NULL, 0), +(@PATH, 17, 1483.347, 978.5104, 85.89668, NULL, 0), +(@PATH, 18, 1470.328, 998.5156, 91.25275, NULL, 0), +(@PATH, 19, 1464.257, 1006.304, 92.95126, NULL, 0), +(@PATH, 20, 1456.363, 1013.783, 94.07955, NULL, 0), +(@PATH, 21, 1446.38, 1021.524, 96.02755, NULL, 0), +(@PATH, 22, 1439.243, 1028.408, 97.98031, NULL, 0), +(@PATH, 23, 1433.734, 1038.983, 100.8869, NULL, 0), +(@PATH, 24, 1432.981, 1054.743, 102.6329, NULL, 21405), +(@PATH, 25, 1433.734, 1038.983, 100.8869, NULL, 0); + +UPDATE `creature` SET `position_x`= 1439.243, `position_y`= 1028.408, `position_z`= 97.98031, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+43; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+43; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`, `auras`) VALUES +(@CGUID+43, @PATH, 1, 168134); + +-- Waypoints for CGUID+99 +SET @PATH := @CGUID+99 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 1299.573, 813.0746, 117.8429, NULL, 0), +(@PATH, 1, 1307.599, 815.3438, 118.0844, NULL, 0), +(@PATH, 2, 1311.686, 815.2396, 118.2764, NULL, 20302), +(@PATH, 3, 1299.573, 813.0746, 117.8429, NULL, 0), +(@PATH, 4, 1289.665, 804.8195, 117.1602, NULL, 0), +(@PATH, 5, 1284.96, 794.1875, 116.0429, NULL, 0), +(@PATH, 6, 1285.722, 788.2344, 114.4279, NULL, 0), +(@PATH, 7, 1292.167, 780.5879, 109.5529, NULL, 0), +(@PATH, 8, 1300.097, 773.9688, 104.0992, NULL, 0), +(@PATH, 9, 1305.543, 768.1094, 99.59041, NULL, 0), +(@PATH, 10, 1309.882, 763.2118, 97.8034, NULL, 20324), +(@PATH, 11, 1305.552, 768.1059, 99.6031, NULL, 0), +(@PATH, 12, 1300.106, 773.9648, 103.9654, NULL, 0), +(@PATH, 13, 1292.194, 780.559, 109.5093, NULL, 0), +(@PATH, 14, 1285.729, 788.1855, 114.4279, NULL, 0), +(@PATH, 15, 1284.96, 794.1875, 116.0429, NULL, 0), +(@PATH, 16, 1289.665, 804.8195, 117.1602, NULL, 0); + +UPDATE `creature` SET `position_x`= 1299.573, `position_y`= 813.0746, `position_z`= 117.8429, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+99; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+99; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+99, @PATH, 1); + +-- Waypoints for CGUID+80 +SET @PATH := @CGUID+80 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 1301.655, 844.6545, 117.6636, NULL, 0), +(@PATH, 1, 1311.172, 852.842, 117.5736, NULL, 0), +(@PATH, 2, 1322.125, 853.7986, 117.6986, NULL, 0), +(@PATH, 3, 1331.007, 852.3368, 117.5736, NULL, 0), +(@PATH, 4, 1343.807, 856.6754, 117.5956, NULL, 0), +(@PATH, 5, 1350.995, 862.8698, 117.5956, NULL, 0), +(@PATH, 6, 1355.689, 870.3125, 117.4352, NULL, 0), +(@PATH, 7, 1365.101, 880.5712, 117.4352, NULL, 0), +(@PATH, 8, 1371.481, 882.0504, 117.5607, NULL, 0), +(@PATH, 9, 1380.877, 881.0417, 117.1857, NULL, 0), +(@PATH, 10, 1386.648, 876.3403, 117.0607, NULL, 0), +(@PATH, 11, 1386.49, 868.1215, 117.3695, NULL, 0), +(@PATH, 12, 1383.814, 858.4288, 117.605, NULL, 0), +(@PATH, 13, 1377.083, 851.4132, 117.605, NULL, 0), +(@PATH, 14, 1366.684, 850.2344, 117.605, NULL, 0), +(@PATH, 15, 1356.76, 848.5104, 117.5956, NULL, 0), +(@PATH, 16, 1346.233, 843.2274, 117.5956, NULL, 0), +(@PATH, 17, 1339.733, 834.9653, 117.5956, NULL, 0), +(@PATH, 18, 1335.13, 828.5833, 117.6029, NULL, 0), +(@PATH, 19, 1327.12, 823.2274, 117.5426, NULL, 0), +(@PATH, 20, 1314.498, 823.3246, 117.1676, NULL, 0), +(@PATH, 21, 1306.564, 827.4983, 117.3174, NULL, 0), +(@PATH, 22, 1300.733, 836.4688, 117.5483, NULL, 0); + +UPDATE `creature` SET `position_x`= 1301.655, `position_y`= 844.6545, `position_z`= 117.6636, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+80; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+80; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`, `auras`) VALUES +(@CGUID+80, @PATH, 1, 168134); + +-- Waypoints for CGUID+79 +SET @PATH := @CGUID+79 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 1313.427, 898.0938, 130.4402, NULL, 0), +(@PATH, 1, 1317.698, 905.3594, 131.3216, NULL, 0), +(@PATH, 2, 1325.576, 919.6893, 130.4725, NULL, 16157), +(@PATH, 3, 1307.714, 889.1945, 130.8134, NULL, 10114); + +UPDATE `creature` SET `position_x`= 1313.427, `position_y`= 898.0938, `position_z`= 130.4402, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+79; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+79; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`, `emote`) VALUES +(@CGUID+79, @PATH, 1, 69); + +-- Waypoints for CGUID+73 +SET @PATH := @CGUID+73 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 1333.057, 938.2621, 130.4664, NULL, 0), +(@PATH, 1, 1333.995, 941.8802, 130.1325, NULL, 0), +(@PATH, 2, 1336.99, 945.9879, 129.6238, NULL, 0), +(@PATH, 3, 1340.589, 948.2292, 128.9203, NULL, 0), +(@PATH, 4, 1346.214, 947.2031, 127.6974, NULL, 0), +(@PATH, 5, 1351.28, 938.6285, 125.4746, NULL, 0), +(@PATH, 6, 1353.995, 927.316, 122.7017, NULL, 0), +(@PATH, 7, 1355.606, 916.1441, 119.472, NULL, 0), +(@PATH, 8, 1357.326, 902.3837, 117.9457, NULL, 0), +(@PATH, 9, 1360.719, 889.6215, 117.3772, NULL, 0), +(@PATH, 10, 1364.068, 881.2986, 117.3102, NULL, 0), +(@PATH, 11, 1367.842, 873.8924, 118.1311, NULL, 11838), +(@PATH, 12, 1364.068, 881.2986, 117.3102, NULL, 0), +(@PATH, 13, 1360.719, 889.6215, 117.3772, NULL, 0), +(@PATH, 14, 1357.326, 902.3837, 117.9457, NULL, 0), +(@PATH, 15, 1355.606, 916.1441, 119.472, NULL, 0), +(@PATH, 16, 1353.995, 927.316, 122.7017, NULL, 0), +(@PATH, 17, 1351.28, 938.6285, 125.4746, NULL, 0), +(@PATH, 18, 1346.214, 947.2031, 127.6974, NULL, 0), +(@PATH, 19, 1340.589, 948.2292, 128.9203, NULL, 0), +(@PATH, 20, 1336.99, 945.9879, 129.6238, NULL, 0), +(@PATH, 21, 1333.995, 941.8802, 130.1325, NULL, 0), +(@PATH, 22, 1333.057, 938.2621, 130.4664, NULL, 0), +(@PATH, 23, 1332.08, 932.2535, 130.628, NULL, 19033); + +UPDATE `creature` SET `position_x`= 1333.057, `position_y`= 938.2621, `position_z`= 130.4664, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+73; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+73; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+73, @PATH, 1); + +-- Waypoints for CGUID+90 +SET @PATH := @CGUID+90 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 1303.217, 914.2708, 129.3946, NULL, 0), +(@PATH, 1, 1307.257, 919.2986, 128.8409, NULL, 0), +(@PATH, 2, 1314.377, 928.2274, 128.8409, NULL, 0), +(@PATH, 3, 1318.401, 936.8906, 128.8409, NULL, 0), +(@PATH, 4, 1323.958, 943.5955, 128.8848, NULL, 0), +(@PATH, 5, 1335.064, 950.5399, 128.9536, NULL, 0), +(@PATH, 6, 1351.01, 958.2118, 128.5786, NULL, 0), +(@PATH, 7, 1361.573, 962.5764, 128.5969, NULL, 0), +(@PATH, 8, 1376.122, 965.9601, 131.535, NULL, 0), +(@PATH, 9, 1380.708, 965.9063, 131.4389, NULL, 0), +(@PATH, 10, 1385.292, 966.9688, 131.4492, NULL, 13641), +(@PATH, 11, 1380.708, 965.9063, 131.4389, NULL, 0), +(@PATH, 12, 1376.122, 965.9601, 131.535, NULL, 0), +(@PATH, 13, 1361.573, 962.5764, 128.5969, NULL, 0), +(@PATH, 14, 1351.01, 958.2118, 128.5786, NULL, 0), +(@PATH, 15, 1335.064, 950.5399, 128.9536, NULL, 0), +(@PATH, 16, 1323.958, 943.5955, 128.8848, NULL, 0), +(@PATH, 17, 1318.401, 936.8906, 128.8409, NULL, 0), +(@PATH, 18, 1314.377, 928.2274, 128.8409, NULL, 0), +(@PATH, 19, 1307.257, 919.2986, 128.8409, NULL, 0), +(@PATH, 20, 1303.217, 914.2708, 129.3946, NULL, 0), +(@PATH, 21, 1299.401, 910.4618, 129.5038, NULL, 11098); + +UPDATE `creature` SET `position_x`= 1303.217, `position_y`= 914.2708, `position_z`= 129.3946, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+90; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+90; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+90, @PATH, 1);
\ No newline at end of file |