diff options
| author | Aqua Deus <95978183+aquadeus@users.noreply.github.com> | 2024-06-17 01:34:20 +0200 |
|---|---|---|
| committer | Naddley <NaddleyTC@gmail.com> | 2024-06-17 01:34:24 +0200 |
| commit | d17126706f3481432ffafce4f786b79fbe468da1 (patch) | |
| tree | b147e074cc84deaa0a72d9f89940aa954fa86576 | |
| parent | 3974648ae02970a62841104c7678db89cfbeea48 (diff) | |
DB/Auchindoun: Added init. spawns
Closes #30029
| -rw-r--r-- | sql/updates/world/master/2024_06_17_00_world.sql | 649 |
1 files changed, 649 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_06_17_00_world.sql b/sql/updates/world/master/2024_06_17_00_world.sql new file mode 100644 index 00000000000..326f4b95f71 --- /dev/null +++ b/sql/updates/world/master/2024_06_17_00_world.sql @@ -0,0 +1,649 @@ +SET @CGUID := 5000400; +SET @OGUID := 5000056; +SET @ATID := 68; + +-- Creatures +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+156; +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, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1491.3228759765625, 2961.841064453125, 36.23116683959960937, 3.980869293212890625, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+1, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1529.671875, 2960.15283203125, 35.69658279418945312, 4.713648319244384765, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+2, 77819, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1667.1788330078125, 3077.600830078125, 36.67950057983398437, 5.796135902404785156, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Vigilant (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 156893 - Auchindoun Defense Construct) +(@CGUID+3, 77695, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1505.154541015625, 2962.052978515625, 36.231170654296875, 4.713648319244384765, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Arbiter (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+4, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1583.7552490234375, 2961.96435546875, 36.23111724853515625, 4.05728912353515625, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+5, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1498.9896240234375, 2947.382080078125, 35.32217025756835937, 2.783493280410766601, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+6, 77696, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1553.6910400390625, 2944.291748046875, 35.32229232788085937, 0.073448918759822845, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Soulpriest (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+7, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1495.236083984375, 2945.859375, 35.69659042358398437, 2.554013013839721679, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+8, 77695, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1540.2100830078125, 2957.69091796875, 35.32219696044921875, 3.189603090286254882, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Arbiter (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+9, 77695, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1505.8541259765625, 2944.1259765625, 36.231170654296875, 1.649249792098999023, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Arbiter (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+10, 77696, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1563.2447509765625, 2959.335205078125, 35.32232666015625, 1.328914165496826171, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Soulpriest (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+11, 79248, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1543.7117919921875, 2955.87841796875, 35.32222747802734375, 3.343645572662353515, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Soulbinder (Area: Auchindoun - Difficulty: 0) CreateObject1 +(@CGUID+12, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1498.8021240234375, 2958.611083984375, 35.32217025756835937, 3.472944498062133789, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+13, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1506.546875, 2960.385498046875, 35.69659042358398437, 4.713648319244384765, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+14, 77819, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1724.7291259765625, 3153.71533203125, 36.67934799194335937, 5.423369884490966796, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Vigilant (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 156893 - Auchindoun Defense Construct) +(@CGUID+15, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1527.439208984375, 2960.072998046875, 35.69659042358398437, 4.774088382720947265, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+16, 77704, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1529.6690673828125, 2949.3115234375, 35.22933197021484375, 0.005536025390028953, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Warden (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 155647 - NPC Reaction) +(@CGUID+17, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1592.4288330078125, 2961.96435546875, 36.23116302490234375, 4.64665842056274414, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+18, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1504.092041015625, 2960.241455078125, 35.69659042358398437, 4.713648319244384765, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+19, 82681, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 0, 1911.1961669921875, 2952.842041015625, 16.92805671691894531, 0, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Shield Stalker (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+20, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1491.4774169921875, 2944.37158203125, 36.23116683959960937, 2.294145584106445312, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+21, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1587.85595703125, 2944.014892578125, 36.23117828369140625, 1.516095519065856933, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+22, 77819, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1692.6285400390625, 3118.178955078125, 36.67943191528320312, 5.632548332214355468, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Vigilant (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 156893 - Auchindoun Defense Construct) +(@CGUID+23, 77947, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1661.9617919921875, 2913.55908203125, 34.84741973876953125, 1.613085746765136718, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Cleric (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+24, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1555.62158203125, 2946.5390625, 35.32230758666992187, 4.027932167053222656, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+25, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1597.045166015625, 2944.1171875, 36.231170654296875, 1.516095519065856933, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+26, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1556.579833984375, 2944.067626953125, 35.32231521606445312, 2.837917804718017578, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+27, 77694, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1567.5364990234375, 2962.7431640625, 35.32230377197265625, 2.071651697158813476, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Magus (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+28, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1504.607666015625, 2945.658935546875, 35.69659042358398437, 1.514774680137634277, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+29, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1530.19970703125, 2945.874267578125, 35.6965789794921875, 1.567850351333618164, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+30, 77695, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1528.7066650390625, 2944.012939453125, 36.23116683959960937, 1.581174135208129882, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Arbiter (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+31, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1527.0850830078125, 2945.88623046875, 35.69659042358398437, 1.569900989532470703, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+32, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1495.3350830078125, 2960.201416015625, 35.69659042358398437, 3.68580031394958496, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+33, 77695, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1540.111083984375, 2948.291748046875, 35.32219314575195312, 3.135090351104736328, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Arbiter (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+34, 77695, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1528.4879150390625, 2961.6337890625, 36.23116683959960937, 4.747385025024414062, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Arbiter (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+35, 77819, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1762.4254150390625, 3183.012939453125, 36.6792449951171875, 5.268512248992919921, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Vigilant (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 156893 - Auchindoun Defense Construct) +(@CGUID+36, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1507.02783203125, 2945.72314453125, 35.69659042358398437, 1.567850351333618164, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+37, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1601.578125, 2961.96435546875, 36.231170654296875, 4.64665842056274414, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+38, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1606.435791015625, 2944.218017578125, 36.2311553955078125, 1.516095519065856933, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+39, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1611.0625, 2961.96435546875, 36.23115921020507812, 4.64665842056274414, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+40, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1615.3524169921875, 2944.31689453125, 36.2311553955078125, 1.516095519065856933, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+41, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1619.814208984375, 2961.96435546875, 36.22805404663085937, 5.218808174133300781, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+42, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1640.986083984375, 2960.064208984375, 35.5829010009765625, 5.559096813201904296, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+43, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1640.9600830078125, 2945.71533203125, 35.60343170166015625, 0.67940223217010498, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+44, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1642.1961669921875, 2927.654541015625, 35.24270248413085937, 0.01525938045233488, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+45, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1645.295166015625, 2977.645751953125, 35.23143386840820312, 0.008443285711109638, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+46, 77694, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1646.16845703125, 2958.1572265625, 35.1436614990234375, 5.929937362670898437, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Magus (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+47, 77949, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1649.515625, 2941.357666015625, 35.40304183959960937, 0.947370529174804687, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Ritualist (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+48, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1644.810791015625, 2968.411376953125, 35.21453857421875, 6.212331295013427734, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+49, 77695, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1645.3629150390625, 2947.537353515625, 35.40304183959960937, 0.24801965057849884, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Arbiter (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+50, 77949, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1646.65625, 2944.69091796875, 35.40304183959960937, 0.560388743877410888, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Ritualist (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+51, 77949, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1646.623291015625, 2961.395751953125, 35.40304183959960937, 5.716198444366455078, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Ritualist (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+52, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1646.486083984375, 2993.46533203125, 35.32218170166015625, 5.953157901763916015, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+53, 77134, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1897.4461669921875, 3162.686767578125, 30.88268470764160156, 0.973815202713012695, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Sargerei Cleric (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 156955 - Void Form) +(@CGUID+54, 75839, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1911.63720703125, 3131.975830078125, 29.79482460021972656, 1.5778275728225708, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Vigilant Kaathar (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 157266 - Vigilant Submerge State, 42459 - Dual Wield) +(@CGUID+55, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1645.767333984375, 2985.91845703125, 35.32218170166015625, 0.008443285711109638, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+56, 77695, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1650.579833984375, 2962.982666015625, 35.14365005493164062, 5.50257110595703125, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Arbiter (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+57, 77694, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1654.0242919921875, 2940.4462890625, 35.05950927734375, 1.081962466239929199, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Magus (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: ) +(@CGUID+58, 77696, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1656.921875, 2915.362060546875, 34.84733963012695312, 0.768780052661895751, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Soulpriest (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+59, 77704, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1657.1614990234375, 2929.3212890625, 34.8416900634765625, 5.446918964385986328, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Warden (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+60, 77704, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1661.0364990234375, 2919.46875, 34.94428253173828125, 4.858886241912841796, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Warden (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+61, 77696, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1674.71875, 2953.107666015625, 35.1436614990234375, 3.135791301727294921, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Soulpriest (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (possible waypoints or random movement) +(@CGUID+62, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1645.654541015625, 2894.26220703125, 35.32217788696289062, 0.374487310647964477, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+63, 77695, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1659.7708740234375, 2925.875, 34.84703445434570312, 2.130390405654907226, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Arbiter (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+64, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1647.232666015625, 3001.00341796875, 35.32218170166015625, 5.928806781768798828, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+65, 77694, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1662.3975830078125, 2939.756103515625, 35.14365005493164062, 1.624581456184387207, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Magus (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+66, 77696, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1658.9722900390625, 2914.057373046875, 34.8473663330078125, 1.240181326866149902, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Soulpriest (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+67, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1648.329833984375, 3008.029541015625, 35.31502532958984375, 5.819012165069580078, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+68, 77949, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1666.2603759765625, 2926.459228515625, 34.84720611572265625, 0.491822987794876098, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Ritualist (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+69, 77950, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1664.234375, 2911.596435546875, 34.84752273559570312, 1.978927850723266601, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Zealot (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+70, 77696, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1666.376708984375, 2916.9765625, 34.847259521484375, 2.829090833663940429, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Soulpriest (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+71, 77952, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1667.001708984375, 2913.90966796875, 34.84732818603515625, 2.464233636856079101, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Soulbinder (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+72, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1659.05908203125, 2911.08935546875, 34.84760284423828125, 1.325223088264465332, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+73, 77951, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1669.2864990234375, 2928.670166015625, 34.84729766845703125, 3.686169624328613281, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Spirit-Tender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+74, 77949, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1672.2117919921875, 2944.5634765625, 35.14365005493164062, 2.491034507751464843, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Ritualist (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+75, 77696, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1664.75, 2915.018310546875, 34.84739303588867187, 2.360809803009033203, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Soulpriest (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+76, 77694, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1668.029541015625, 2941.395751953125, 35.14365005493164062, 2.242946624755859375, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Magus (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+77, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1679.765625, 2935.8759765625, 35.19507598876953125, 3.192433118820190429, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+78, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1676.435791015625, 2986.002685546875, 35.32218170166015625, 2.876665592193603515, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+79, 77704, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1682.3680419921875, 2953.29248046875, 35.62078094482421875, 6.139192581176757812, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Warden (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+80, 77948, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1676.5625, 2931.239501953125, 35.19874954223632812, 4.822155952453613281, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Hoplite (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+81, 77949, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1676.3004150390625, 2947.290771484375, 35.40304183959960937, 3.880580902099609375, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Ritualist (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+82, 77812, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1894.51220703125, 3200.030517578125, 30.88272476196289062, 5.597739696502685546, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Sargerei Soulbinder (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 156955 - Void Form) +(@CGUID+83, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1676.1163330078125, 2979.145751953125, 35.26027297973632812, 3.03649139404296875, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+84, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1676.0086669921875, 2971.538330078125, 35.21437835693359375, 3.03649139404296875, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+85, 79417, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 0, 1661.4757080078125, 3012.5546875, 40.77339553833007812, 4.136562347412109375, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Invisible Stalker (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+86, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1676.439208984375, 2964.721435546875, 35.24824905395507812, 3.095417737960815429, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+87, 77952, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1676.59375, 2927.076416015625, 35.258575439453125, 1.515209197998046875, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Soulbinder (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+88, 77696, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1675.810791015625, 2946.27001953125, 35.40304183959960937, 1.084618210792541503, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Soulpriest (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+89, 77696, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1687.30908203125, 2950.84375, 35.69637680053710937, 2.504041910171508789, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Soulpriest (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+90, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1687.3489990234375, 2948.397705078125, 35.69637680053710937, 2.279029369354248046, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+91, 79417, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 0, 1669.638916015625, 3010.072998046875, 41.74965667724609375, 4.136562347412109375, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Invisible Stalker (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+92, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1677.0191650390625, 2991.90625, 35.32218170166015625, 2.876665592193603515, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+93, 77832, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 0, 1911.73095703125, 3183.638916015625, 33.50413131713867187, 0, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Soul Aegis (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 156922 - Soul Aegis) +(@CGUID+94, 77950, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1690.13720703125, 2951.868896484375, 35.69637680053710937, 2.928548336029052734, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Zealot (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+95, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1677.5572509765625, 2997.974853515625, 35.31458282470703125, 3.031241893768310546, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+96, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1686.7447509765625, 2956.775146484375, 35.69637680053710937, 3.830792427062988281, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+97, 79417, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 0, 1666.7760009765625, 3010.6640625, 37.83771514892578125, 4.136562347412109375, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Invisible Stalker (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+98, 77810, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1913.8941650390625, 3189.854248046875, 30.88270759582519531, 4.075302600860595703, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Soulbinder Nyami (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 157234 - Void Shell) +(@CGUID+99, 77950, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1688.88720703125, 2958.1884765625, 35.696380615234375, 3.787583589553833007, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Zealot (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+100, 79417, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 0, 1664.892333984375, 3011.3759765625, 42.05359649658203125, 4.136562347412109375, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Invisible Stalker (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+101, 77696, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1690.3194580078125, 2946.46533203125, 35.69638442993164062, 2.364319801330566406, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Soulpriest (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+102, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1684.8785400390625, 2947.015625, 35.696380615234375, 1.946364879608154296, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+103, 79417, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 0, 1663.1875, 3012.079833984375, 37.778472900390625, 4.136562347412109375, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Invisible Stalker (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+104, 77949, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1692.623291015625, 2948.35595703125, 35.69638442993164062, 2.63987278938293457, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Ritualist (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+105, 77949, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1687.3663330078125, 2952.897705078125, 35.69637298583984375, 3.125909805297851562, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Ritualist (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+106, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1684.638916015625, 2959.2666015625, 35.696380615234375, 4.355805873870849609, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+107, 77696, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1687.861083984375, 2955.04248046875, 35.696380615234375, 3.49931192398071289, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Soulpriest (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+108, 79417, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 0, 1666.7274169921875, 3011.040771484375, 43.77808380126953125, 4.136562347412109375, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Invisible Stalker (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+109, 77949, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1693.55908203125, 2956.625, 35.696380615234375, 3.403077602386474609, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Ritualist (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+110, 77949, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1694.51220703125, 2952.609375, 35.69637680053710937, 3.057715892791748046, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Ritualist (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+111, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1675.8697509765625, 3023.09375, 35.25547027587890625, 2.940030813217163085, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+112, 77949, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1706.94970703125, 2948.984375, 35.32215118408203125, 0.615237057209014892, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Ritualist (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+113, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1676.8646240234375, 3032.341064453125, 35.22306442260742187, 2.828145027160644531, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+114, 77704, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1712.595458984375, 2953.46533203125, 35.32215499877929687, 3.026159524917602539, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Warden (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+116, 77704, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1712.6771240234375, 2948.538330078125, 35.32215118408203125, 2.536875486373901367, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Warden (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+117, 77131, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1935.888916015625, 3183.606689453125, 30.8827056884765625, 3.201084375381469726, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Sargerei Spirit-Tender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 156955 - Void Form) +(@CGUID+118, 77950, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1704.9930419921875, 2953.138916015625, 35.39653778076171875, 0.095412008464336395, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Zealot (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+119, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1676.017333984375, 3025.943603515625, 35.24180984497070312, 2.908563852310180664, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+120, 77704, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1673.6927490234375, 3032.5234375, 35.23430633544921875, 1.410390615463256835, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Warden (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+121, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1676.3489990234375, 3029.0478515625, 35.22306060791015625, 2.92891693115234375, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+122, 77704, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1712.4444580078125, 2957.618896484375, 35.3221588134765625, 3.17419600486755371, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Warden (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+123, 77950, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1706.3819580078125, 2957.646728515625, 35.3221588134765625, 5.789441585540771484, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Zealot (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+124, 77950, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1707.4739990234375, 2960.529541015625, 35.69658660888671875, 5.496424674987792968, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Zealot (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+125, 77949, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1709.10595703125, 2946.35498046875, 35.69657135009765625, 0.644170701503753662, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Ritualist (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+126, 77948, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1691.0399169921875, 3062.772705078125, 35.22322845458984375, 2.610810279846191406, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Hoplite (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 157739 - At Arms) +(@CGUID+127, 77950, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1689.5103759765625, 3066.12939453125, 35.13763427734375, 1.184453248977661132, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Zealot (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+128, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1691.513916015625, 3070.65625, 35.22322463989257812, 5.132762908935546875, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+129, 77948, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1693.328125, 3067.4775390625, 35.2232208251953125, 2.607628822326660156, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Hoplite (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 157739 - At Arms) +(@CGUID+130, 77695, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1673.967041015625, 3074.104248046875, 36.13217926025390625, 5.834946632385253906, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Arbiter (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+131, 77694, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1675.6788330078125, 3068.34375, 35.22326278686523437, 2.696657180786132812, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Magus (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+132, 77694, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1679.357666015625, 3075.5859375, 35.22324371337890625, 2.604601860046386718, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Magus (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+133, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1714.7691650390625, 3100.943603515625, 35.22316360473632812, 2.435690879821777343, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+134, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1712.6978759765625, 3097.87939453125, 35.22316741943359375, 2.607788562774658203, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+135, 77696, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1701.6754150390625, 3113.021728515625, 35.22318649291992187, 0, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Soulpriest (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+136, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1716.7257080078125, 3104.069580078125, 35.2231597900390625, 2.5426483154296875, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+137, 77695, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1714.4478759765625, 3104.975830078125, 35.13762664794921875, 5.904528617858886718, 86400, 10, 0, 100, 1, NULL, NULL, NULL, NULL, 54904), -- Auchenai Arbiter (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (possible waypoints or random movement) +(@CGUID+138, 77694, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1710.420166015625, 3113.875, 35.22317123413085937, 3.38626265525817871, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Magus (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: ) +(@CGUID+139, 77694, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1728.7430419921875, 3139.203125, 35.22311782836914062, 2.261404037475585937, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Magus (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+140, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1727.720458984375, 3141.53125, 35.22311782836914062, 4.695310115814208984, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+141, 77696, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1745.9305419921875, 3138.907958984375, 35.22307968139648437, 0.293291807174682617, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Soulpriest (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+142, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1748.3021240234375, 3138.0087890625, 35.22307205200195312, 2.92891693115234375, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+143, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1748.373291015625, 3140.741455078125, 35.22307205200195312, 3.436568498611450195, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+144, 77133, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1896.875, 3155.9462890625, 31.05600738525390625, 1.607088327407836914, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Sargerei Hoplite (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 157081 - Void Strikes) +(@CGUID+145, 77950, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1767.8507080078125, 3174.45751953125, 35.22301483154296875, 3.923529624938964843, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Zealot (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+146, 77695, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1765.99658203125, 3172.454833984375, 35.22301864624023437, 0.878998160362243652, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Arbiter (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+147, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1780.7430419921875, 3161.4296875, 35.22298812866210937, 2.103954792022705078, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+148, 77693, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1774.1007080078125, 3157.08154296875, 35.22300338745117187, 2.221400260925292968, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Auchenai Defender (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+149, 77133, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1887.1146240234375, 3205.30908203125, 31.05605888366699218, 4.987659454345703125, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Sargerei Hoplite (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 157081 - Void Strikes) +(@CGUID+150, 77133, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1938.482666015625, 3187.0478515625, 30.88270759582519531, 4.002863407135009765, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Sargerei Hoplite (Area: Auchindoun - Difficulty: Heroic) CreateObject1 (Auras: 157081 - Void Strikes) +(@CGUID+151, 77130, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1889.5103759765625, 3200.78466796875, 30.88272476196289062, 0.426818430423736572, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Sargerei Ritualist (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+152, 77130, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1892.75, 3160.609375, 30.88268089294433593, 0.336703449487686157, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Sargerei Ritualist (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+153, 77132, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1893.5347900390625, 3155.532958984375, 31.05600738525390625, 0.973815202713012695, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Sargerei Zealot (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+154, 77132, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1891.0208740234375, 3205.635498046875, 30.88256645202636718, 5.389794826507568359, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Sargerei Zealot (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+155, 77130, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1940.923583984375, 3177.864501953125, 30.88269805908203125, 2.72194981575012207, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904), -- Sargerei Ritualist (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@CGUID+156, 77132, 1182, 6912, 6912, '1,2,8,23', 0, 0, 0, 1, 1940.204833984375, 3189.73779296875, 30.88271141052246093, 3.201084375381469726, 86400, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54904); -- Sargerei Zealot (Area: Auchindoun - Difficulty: Heroic) CreateObject1 + +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+156; +INSERT INTO `creature_addon` (`guid`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+0, 0, 0, 0, 0, 0, 1, 0, 505, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+5, 0, 0, 0, 0, 0, 1, 0, 505, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+7, 0, 0, 0, 0, 0, 1, 0, 505, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+11, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 5, ''), -- Soulbinder Tuulani +(@CGUID+12, 0, 0, 0, 0, 0, 1, 0, 505, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+20, 0, 0, 0, 0, 0, 1, 0, 505, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+32, 0, 0, 0, 0, 0, 1, 0, 505, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+42, 0, 0, 8, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+43, 0, 0, 8, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+44, 0, 0, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+45, 0, 0, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+46, 0, 0, 0, 0, 0, 1, 0, 533, 0, 0, 0, 0, ''), -- Auchenai Magus +(@CGUID+48, 0, 0, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+49, 0, 0, 8, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Auchenai Arbiter +(@CGUID+52, 0, 0, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+55, 0, 0, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+56, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Auchenai Arbiter +(@CGUID+58, 0, 0, 0, 0, 0, 1, 0, 533, 0, 0, 0, 0, ''), -- Auchenai Soulpriestv +(@CGUID+60, 0, 0, 0, 0, 0, 1, 0, 378, 0, 0, 0, 0, ''), -- Auchenai Warden +(@CGUID+62, 0, 0, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+64, 0, 0, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+65, 0, 0, 0, 0, 0, 1, 0, 533, 0, 0, 0, 0, ''), -- Auchenai Magus +(@CGUID+67, 0, 0, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+70, 0, 0, 0, 0, 0, 1, 0, 533, 0, 0, 0, 0, ''), -- Auchenai Soulpriest +(@CGUID+72, 0, 0, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+74, 0, 0, 0, 0, 0, 1, 0, 483, 0, 0, 0, 0, ''), -- Auchenai Ritualist +(@CGUID+75, 0, 0, 0, 0, 0, 1, 0, 533, 0, 0, 0, 0, ''), -- Auchenai Soulpriest +(@CGUID+76, 0, 0, 0, 0, 0, 1, 0, 533, 0, 0, 0, 0, ''), -- Auchenai Magus +(@CGUID+77, 0, 0, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+78, 0, 0, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+79, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Auchenai Warden +(@CGUID+81, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Auchenai Ritualist +(@CGUID+83, 0, 0, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+84, 0, 0, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+86, 0, 0, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+88, 0, 0, 0, 0, 0, 1, 0, 378, 0, 0, 0, 0, ''), -- Auchenai Soulpriest +(@CGUID+90, 0, 0, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+92, 0, 0, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+95, 0, 0, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+96, 0, 0, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+102, 0, 0, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+106, 0, 0, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+128, 0, 0, 0, 0, 0, 0, 0, 483, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+130, 0, 0, 0, 0, 0, 0, 0, 483, 0, 0, 0, 0, ''), -- Auchenai Arbiter +(@CGUID+131, 0, 0, 0, 0, 0, 1, 0, 533, 0, 0, 0, 0, ''), -- Auchenai Magus +(@CGUID+132, 0, 0, 0, 0, 0, 1, 0, 533, 0, 0, 0, 0, ''), -- Auchenai Magus +(@CGUID+135, 0, 0, 0, 0, 0, 0, 0, 533, 0, 0, 0, 0, ''), -- Auchenai Soulpriest +(@CGUID+139, 0, 0, 0, 0, 0, 1, 0, 378, 0, 0, 0, 0, ''), -- Auchenai Magus +(@CGUID+140, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+141, 0, 0, 0, 0, 0, 1, 0, 378, 0, 0, 0, 0, ''), -- Auchenai Soulpriest +(@CGUID+145, 0, 0, 0, 0, 0, 1, 0, 588, 0, 0, 0, 0, ''), -- Auchenai Zealot +(@CGUID+147, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(@CGUID+148, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '123167'); -- Auchenai Defender - 123167 - Mod Scale 95-100% + +-- Gameobjects +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+20; +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, 231742, 1182, 6912, 6912, '1,2,8,23', 0, 0, 1844.3779296875, 2953.1298828125, 15.16725635528564453, 3.141592741012573242, 0, 0, -1, 0, 86400, 255, 1, 54904), -- Soul Transporter (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@OGUID+1, 237459, 1182, 6912, 6912, '1,2,8,23', 0, 0, 1827.97021484375, 2722.52978515625, 29.2783203125, 3.125251531600952148, 0, 0, 0.999966621398925781, 0.008170507848262786, 86400, 255, 0, 54904), -- Holy Barrier (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@OGUID+2, 231743, 1182, 6912, 6912, '1,2,8,23', 0, 0, 1802.8836669921875, 2953.053955078125, 25.48373794555664062, 3.141592741012573242, 0, 0, -1, 0, 86400, 255, 1, 54904), -- Soul Transporter (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@OGUID+3, 233010, 1182, 6912, 6912, '1,2,8,23', 0, 0, 1737.890625, 2765.779052734375, 35.05662918090820312, 0.820305347442626953, 0, 0, 0.398749351501464843, 0.917059957981109619, 86400, 255, 1, 54904), -- Auchindoun Window 2 (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@OGUID+4, 231741, 1182, 6912, 6912, '1,2,8,23', 0, 0, 1830.89404296875, 3033.296142578125, 35.60332107543945312, 3.141592741012573242, 0, 0, -1, 0, 86400, 255, 1, 54904), -- Soul Transporter (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@OGUID+5, 231680, 1182, 6912, 6912, '1,2,8,23', 0, 0, 1704.3170166015625, 2953.16552734375, 35.58184051513671875, 6.281350612640380859, 0, 0, -0.00091743469238281, 0.999999582767486572, 86400, 255, 0, 54904), -- Holy Barrier (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@OGUID+6, 212899, 1182, 6912, 6912, '1,2,8,23', 0, 0, 1483.564208984375, 2953.048583984375, 35.31077957153320312, 6.219974994659423828, 0, 0, -0.03159999847412109, 0.999500572681427001, 86400, 255, 1, 54904), -- Instance Portal (Party + Heroic + Challenge) (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@OGUID+7, 233009, 1182, 6912, 6912, '1,2,8,23', 0, 0, 1684.3145751953125, 2836.506591796875, 35.056640625, 0.471238493919372558, 0, 0, 0.233445167541503906, 0.972369968891143798, 86400, 255, 1, 54904), -- Auchindoun Window 1 (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@OGUID+8, 230511, 1182, 6912, 6912, '1,2,8,23', 0, 0, 1827.9700927734375, 3183.653564453125, 28.45749282836914062, 3.125251531600952148, 0, 0, 0.999966621398925781, 0.008170507848262786, 86400, 255, 0, 54904), -- Holy Barrier (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@OGUID+9, 227633, 1182, 6912, 6912, '1,2,8,23', 0, 0, 1482.0625, 2953.0556640625, 0, 3.141592741012573242, 0, 0, -1, 0, 86400, 255, 1, 54904), -- Auchindoun_Section_001 (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@OGUID+10, 230398, 1182, 6912, 6912, '1,2,8,23', 0, 0, 1665.140625, 3012.127197265625, 35.58184051513671875, 4.434296131134033203, 0, 0, -0.79828643798828125, 0.602277994155883789, 86400, 255, 1, 54904), -- Holy Barrier (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@OGUID+11, 230399, 1182, 6912, 6912, '1,2,8,23', 0, 0, 1911.6396484375, 3183.603759765625, 31.48963165283203125, 3.141592741012573242, 0, 0, -1, 0, 86400, 255, 0, 54904), -- Holy Barrier (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@OGUID+12, 230397, 1182, 6912, 6912, '1,2,8,23', 0, 0, 1665.14013671875, 2894.444091796875, 35.58184051513671875, 4.996966361999511718, 0, 0, -0.5996866226196289, 0.800234973430633544, 86400, 255, 1, 54904), -- Holy Barrier (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@OGUID+13, 230400, 1182, 6912, 6912, '1,2,8,23', 0, 0, 1911.6397705078125, 2722.507568359375, 31.57850456237792968, 3.141592741012573242, 0, 0, -1, 0, 86400, 255, 0, 54904), -- Fel Barrier (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@OGUID+14, 231738, 1182, 6912, 6912, '1,2,8,23', 0, 0, 1831.1392822265625, 2872.88037109375, 35.591522216796875, 3.141592741012573242, 0, 0, -1, 0, 86400, 255, 1, 54904), -- Soul Transporter (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@OGUID+15, 231679, 1182, 6912, 6912, '1,2,8,23', 0, 0, 1617.25146484375, 2953.16552734375, 35.58184051513671875, 6.281350612640380859, 0, 0, -0.00091743469238281, 0.999999582767486572, 86400, 255, 0, 54904), -- Holy Barrier (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@OGUID+16, 231736, 1182, 6912, 6912, '1,2,8,23', 0, 0, 1911.621826171875, 3105.61083984375, 4.55859375, 3.141592741012573242, 0, 0, -1, 0, 86400, 255, 1, 54904), -- Soul Transporter (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@OGUID+17, 231737, 1182, 6912, 6912, '1,2,8,23', 0, 0, 1911.716796875, 2800.406494140625, 4.55859375, 3.141592741012573242, 0, 0, -1, 0, 86400, 255, 1, 54904), -- Soul Transporter (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@OGUID+18, 237464, 1182, 6912, 6912, '1,2,8,23', 0, 0, 1685.4444580078125, 2913.046142578125, 36.72615432739257812, 6.200767040252685546, 0.702855110168457031, -0.03005886077880859, -0.0282135009765625, 0.710137426853179931, 86400, 255, 1, 54904), -- Soulsever Blade (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@OGUID+19, 231739, 1182, 6912, 6912, '1,2,8,23', 0, 0, 1992.41748046875, 2872.893310546875, 35.37061691284179687, 3.141592741012573242, 0, 0, -1, 0, 86400, 255, 1, 54904), -- Soul Transporter (Area: Auchindoun - Difficulty: Heroic) CreateObject1 +(@OGUID+20, 231740, 1182, 6912, 6912, '1,2,8,23', 0, 0, 1992.5048828125, 3033.2978515625, 35.36113739013671875, 3.141592741012573242, 0, 0, -1, 0, 86400, 255, 1, 54904); -- Soul Transporter (Area: Auchindoun - Difficulty: Heroic) CreateObject1 + +DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+20; +INSERT INTO `gameobject_addon` (`guid`, `parent_rotation0`, `parent_rotation1`, `parent_rotation2`, `parent_rotation3`, `WorldEffectID`, `AIAnimKitID`) VALUES +(@OGUID+0, 0, 0, 1, -0.00000004371138828, 0, 5460), -- Soul Transporter +(@OGUID+1, 0, 0, 1, -0.00000004371138828, 0, 0), -- Holy Barrier +(@OGUID+2, 0, 0, 1, -0.00000004371138828, 0, 5460), -- Soul Transporter +(@OGUID+3, 0, 0, 1, -0.00000004371138828, 0, 0), -- Auchindoun Window 2 +(@OGUID+4, 0, 0, 1, -0.00000004371138828, 0, 5460), -- Soul Transporter +(@OGUID+5, 0, 0, 1, -0.00000004371138828, 0, 0), -- Holy Barrier +(@OGUID+7, 0, 0, 1, -0.00000004371138828, 0, 0), -- Auchindoun Window 1 +(@OGUID+8, 0, 0, 1, -0.00000004371138828, 0, 0), -- Holy Barrier +(@OGUID+9, 0, 0, 0, 1, 0, 0), -- Auchindoun_Section_001 +(@OGUID+10, 0, 0, 1, -0.00000004371138828, 0, 0), -- Holy Barrier +(@OGUID+11, 0, 0, 1, -0.00000004371138828, 0, 0), -- Holy Barrier +(@OGUID+12, 0, 0, 1, -0.00000004371138828, 0, 0), -- Holy Barrier +(@OGUID+13, 0, 0, 1, -0.00000004371138828, 0, 0), -- Fel Barrier +(@OGUID+14, 0, 0, 1, -0.00000004371138828, 0, 5460), -- Soul Transporter +(@OGUID+15, 0, 0, 1, -0.00000004371138828, 0, 0), -- Holy Barrier +(@OGUID+16, 0, 0, 1, -0.00000004371138828, 0, 5460), -- Soul Transporter +(@OGUID+17, 0, 0, 1, -0.00000004371138828, 0, 5460), -- Soul Transporter +(@OGUID+19, 0, 0, 1, -0.00000004371138828, 0, 5460), -- Soul Transporter +(@OGUID+20, 0, 0, 1, -0.00000004371138828, 0, 5460); -- Soul Transporter + +-- Template +DELETE FROM `instance_template` WHERE `map`=1182; +INSERT INTO `instance_template` (`map`, `parent`, `script`) VALUES +(1182, 0, 'instance_auchindoun'); + +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=77947; -- Auchenai Cleric +UPDATE `creature_template` SET `unit_flags2`=2048, `unit_flags3`=16777216 WHERE `entry`=82681; -- Shield Stalker +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=79248; -- Soulbinder Tuulani +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=77819; -- Auchenai Vigilant +UPDATE `creature_template` SET `unit_flags2`=2048, `AIName`='SmartAI' WHERE `entry`=77131; -- Sargerei Spirit-Tender +UPDATE `creature_template` SET `unit_flags2`=2048, `AIName`='SmartAI' WHERE `entry`=77810; -- Soulbinder Nyami +UPDATE `creature_template` SET `unit_flags2`=67110912, `unit_flags3`=16777217 WHERE `entry`=77832; -- Soul Aegis +UPDATE `creature_template` SET `unit_flags`=33554688 WHERE `entry`=79417; -- Invisible Stalker +UPDATE `creature_template` SET `unit_flags2`=2048, `AIName`='SmartAI' WHERE `entry`=77812; -- Sargerei Soulbinder +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=75839; -- Vigilant Kaathar +UPDATE `creature_template` SET `unit_flags2`=2048, `AIName`='SmartAI' WHERE `entry`=77134; -- Sargerei Cleric +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=77695; -- Auchenai Arbiter +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=77694; -- Auchenai Magus +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=77696; -- Auchenai Soulpriest + +UPDATE `creature` SET `StringId`='CosmeticArcaneBomb' WHERE `guid`= @CGUID+138; +UPDATE `creature` SET `StringId`='EventArcaneBomb' WHERE `guid` = @CGUID+57; +UPDATE `creature` SET `StringId`='EventHalo' WHERE `guid`= @CGUID+61; +UPDATE `creature` SET `StringId`='EventRadiantFury' WHERE `guid`= @CGUID+56; + +-- Template Addon +DELETE FROM `creature_template_addon` WHERE `entry` IN (77950, 77948, 77131, 77810, 77832, 77812, 75839, 77134, 77695, 77947, 82681, 77133, 77819, 77693, 77694, 77947, 77949, 77696); +INSERT INTO `creature_template_addon` (`entry`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(77950, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), -- 77950 (Auchenai Zealot) +(77948, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '157739'), -- 77948 (Auchenai Hoplite) - At Arms +(77131, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 4, '156955'), -- 77131 (Sargerei Spirit-Tender) - Void Form +(77810, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 4, '157234'), -- 77810 (Soulbinder Nyami) - Void Shell +(77832, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 4, '156922'), -- 77832 (Soul Aegis) - Soul Aegis +(77812, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 4, '156955'), -- 77812 (Sargerei Soulbinder) - Void Form +(75839, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 4, '157266 42459'), -- 75839 (Vigilant Kaathar) - Vigilant Submerge State, Dual Wield +(77134, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 4, '156955'), -- 77134 (Sargerei Cleric) - Void Form +(77695, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), -- 77695 (Auchenai Arbiter) +(77947, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, ''), -- 77947 (Auchenai Cleric) +(82681, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 5, ''), -- 82681 (Shield Stalker) +(77133, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, '157081'), -- 77133 (Sargerei Hoplite) - Void Strikes +(77819, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 4, '156893'), -- 77819 (Auchenai Vigilant) - Auchindoun Defense Construct +(77693, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123167'), -- Auchenai Defender - 123167 - Mod Scale 95-100% +(77694, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Auchenai Magus +(77949, 0, 0, 8, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Auchenai Ritualist +(77696, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''); -- Auchenai Soulpriest + +UPDATE `gameobject_template_addon` SET `flags`=48 WHERE `entry` IN (231679, 230397, 230399, 230398, 230511, 231680, 237459); -- Holy Barrier +UPDATE `gameobject_template_addon` SET `flags`=48, `AIAnimKitID`=5460 WHERE `entry` IN (231738, 231741, 231743, 231742); -- Soul Transporter +UPDATE `gameobject_template_addon` SET `flags`=48 WHERE `entry`=230400; -- Fel Barrier +UPDATE `gameobject_template_addon` SET `flags`=1048608 WHERE `entry`=227633; -- Auchindoun_Section_001 +UPDATE `gameobject_template_addon` SET `flags`=48 WHERE `entry`=233009; -- Auchindoun Window 1 +UPDATE `gameobject_template_addon` SET `flags`=48 WHERE `entry`=233010; -- Auchindoun Window 2 + +-- Areatrigger +DELETE FROM `areatrigger_template` WHERE (`Id`=@ATID AND `IsCustom`=1); +INSERT INTO `areatrigger_template` (`Id`, `IsCustom`, `Flags`, `VerifiedBuild`) VALUES +(@ATID, 1, 1, 0); + +DELETE FROM `areatrigger_create_properties` WHERE `Id`=1725 AND `IsCustom`=0; +INSERT INTO `areatrigger_create_properties` (`Id`, `IsCustom`, `AreaTriggerId`, `IsAreatriggerCustom`, `Flags`, `MoveCurveId`, `ScaleCurveId`, `MorphCurveId`, `FacingCurveId`, `AnimId`, `AnimKitId`, `DecalPropertiesId`, `SpellForVisuals`, `TimeToTarget`, `TimeToTargetScale`, `Shape`, `ShapeData0`, `ShapeData1`, `ShapeData2`, `ShapeData3`, `ShapeData4`, `ShapeData5`, `ShapeData6`, `ShapeData7`, `ScriptName`, `VerifiedBuild`) VALUES +(1725, 0, @ATID, 1, 4, 0, 0, 0, 0, -1, 0, 0, NULL, 0, 0, 0, 6, 6, 0, 0, 0, 0, 0, 0, '', 0); + +DELETE FROM `areatrigger_template` WHERE (`IsCustom`=0 AND `Id` = 6035); +INSERT INTO `areatrigger_template` (`Id`, `IsCustom`, `Flags`, `VerifiedBuild`) VALUES +(6035, 0, 0, 54904); + +DELETE FROM `areatrigger_create_properties` WHERE (`Id`=1569 AND `IsCustom`=0); +INSERT INTO `areatrigger_create_properties` (`Id`, `IsCustom`, `AreaTriggerId`, `IsAreatriggerCustom`, `Flags`, `MoveCurveId`, `ScaleCurveId`, `MorphCurveId`, `FacingCurveId`, `AnimId`, `AnimKitId`, `DecalPropertiesId`, `TimeToTarget`, `TimeToTargetScale`, `Shape`, `ShapeData0`, `ShapeData1`, `ShapeData2`, `ShapeData3`, `ShapeData4`, `ShapeData5`, `ShapeData6`, `ShapeData7`, `VerifiedBuild`) VALUES +(1569, 0, 6035, 0, 2, 470, 0, 469, 0, -1, 0, 0, 9446, 10000, 0, 0.75, 1.25, 0, 0, 0, 0, 0, 0, 54904); -- Spell: 154174 (Arcane Bomb) + +-- Creature difficulties (Normal) +DELETE FROM `creature_template_difficulty` WHERE (`Entry`IN (77130, 77132, 77133) AND `DifficultyID`=1); + +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=5 WHERE (`Entry`=77132 AND `DifficultyID`=0); -- Sargerei Zealot +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=5 WHERE (`Entry`=77130 AND `DifficultyID`=0); -- Sargerei Ritualist +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=5 WHERE (`Entry`=77133 AND `DifficultyID`=0); -- Sargerei Hoplite +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=5 WHERE (`Entry`=77131 AND `DifficultyID`=0); -- Sargerei Spirit-Tender +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=5 WHERE (`Entry`=77810 AND `DifficultyID`=0); -- Soulbinder Nyami +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=5 WHERE (`Entry`=77948 AND `DifficultyID`=0); -- Auchenai Hoplite +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=5 WHERE (`Entry`=77832 AND `DifficultyID`=0); -- Soul Aegis +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=5 WHERE (`Entry`=77812 AND `DifficultyID`=0); -- Sargerei Soulbinder +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=5 WHERE (`Entry`=77952 AND `DifficultyID`=0); -- Auchenai Soulbinder +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=5 WHERE (`Entry`=77951 AND `DifficultyID`=0); -- Auchenai Spirit-Tender +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=5 WHERE (`Entry`=77950 AND `DifficultyID`=0); -- Auchenai Zealot +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=5 WHERE (`Entry`=77134 AND `DifficultyID`=0); -- Sargerei Cleric +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=5 WHERE (`Entry`=75839 AND `DifficultyID`=0); -- Vigilant Kaathar +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=5 WHERE (`Entry`=77949 AND `DifficultyID`=0); -- Auchenai Ritualist +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=5 WHERE (`Entry`=77947 AND `DifficultyID`=0); -- Auchenai Cleric +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=5 WHERE (`Entry`=77704 AND `DifficultyID`=0); -- Auchenai Warden +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=5 WHERE (`Entry`=77694 AND `DifficultyID`=0); -- Auchenai Magus +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=5 WHERE (`Entry`=77819 AND `DifficultyID`=0); -- Auchenai Vigilant +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=5 WHERE (`Entry`=77695 AND `DifficultyID`=0); -- Auchenai Arbiter +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=5 WHERE (`Entry`=77696 AND `DifficultyID`=0); -- Auchenai Soulpriest +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=5 WHERE (`Entry`=82681 AND `DifficultyID`=0); -- Shield Stalker +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=5 WHERE (`Entry`=77693 AND `DifficultyID`=0); -- Auchenai Defender +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=5 WHERE (`Entry`=79248 AND `DifficultyID`=0); -- Soulbinder Tuulani + +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2216, `StaticFlags1`=268435456, `VerifiedBuild`=54904 WHERE (`Entry`=77132 AND `DifficultyID`=0); -- 77132 (Sargerei Zealot) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2216, `StaticFlags1`=268435456, `VerifiedBuild`=54904 WHERE (`Entry`=77130 AND `DifficultyID`=0); -- 77130 (Sargerei Ritualist) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2216, `StaticFlags1`=268435456, `VerifiedBuild`=54904 WHERE (`Entry`=77133 AND `DifficultyID`=0); -- 77133 (Sargerei Hoplite) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2216, `StaticFlags1`=268435456, `VerifiedBuild`=54904 WHERE (`Entry`=77131 AND `DifficultyID`=0); -- 77131 (Sargerei Spirit-Tender) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=2216, `StaticFlags1`=805306368, `VerifiedBuild`=54904 WHERE (`Entry`=77810 AND `DifficultyID`=0); -- 77810 (Soulbinder Nyami) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=54904 WHERE (`DifficultyID`=0 AND `Entry` IN (79417,88439)); +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2216, `StaticFlags1`=536871168, `VerifiedBuild`=54904 WHERE (`Entry`=77832 AND `DifficultyID`=0); -- 77832 (Soul Aegis) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2216, `StaticFlags1`=268435456, `VerifiedBuild`=54904 WHERE (`Entry`=77812 AND `DifficultyID`=0); -- 77812 (Sargerei Soulbinder) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2216, `VerifiedBuild`=54904 WHERE (`Entry`=77948 AND `DifficultyID`=0); -- 77948 (Auchenai Hoplite) - +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2216, `VerifiedBuild`=54904 WHERE (`Entry`=77950 AND `DifficultyID`=0); -- 77950 (Auchenai Zealot) - +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2216, `VerifiedBuild`=54904 WHERE (`Entry`=77951 AND `DifficultyID`=0); -- 77951 (Auchenai Spirit-Tender) - +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2216, `VerifiedBuild`=54904 WHERE (`Entry`=77952 AND `DifficultyID`=0); -- 77952 (Auchenai Soulbinder) - +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2216, `StaticFlags1`=268435456, `VerifiedBuild`=54904 WHERE (`Entry`=77134 AND `DifficultyID`=0); -- 77134 (Sargerei Cleric) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2216, `StaticFlags1`=268435456, `VerifiedBuild`=54904 WHERE (`Entry`=75839 AND `DifficultyID`=0); -- 75839 (Vigilant Kaathar) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2216, `VerifiedBuild`=54904 WHERE (`Entry`=77949 AND `DifficultyID`=0); -- 77949 (Auchenai Ritualist) - +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2216, `VerifiedBuild`=54904 WHERE (`Entry`=77947 AND `DifficultyID`=0); -- 77947 (Auchenai Cleric) - +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2216, `VerifiedBuild`=54904 WHERE (`Entry`=77704 AND `DifficultyID`=0); -- 77704 (Auchenai Warden) - +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2216, `VerifiedBuild`=54904 WHERE (`Entry`=77694 AND `DifficultyID`=0); -- 77694 (Auchenai Magus) - +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2216, `StaticFlags1`=268435456, `VerifiedBuild`=54904 WHERE (`Entry`=79248 AND `DifficultyID`=0); -- 79248 (Soulbinder Tuulani) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2216, `VerifiedBuild`=54904 WHERE (`Entry`=77695 AND `DifficultyID`=0); -- 77695 (Auchenai Arbiter) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2216, `StaticFlags1`=268435456, `VerifiedBuild`=54904 WHERE (`Entry`=77819 AND `DifficultyID`=0); -- 77819 (Auchenai Vigilant) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2216, `VerifiedBuild`=54904 WHERE (`Entry`=77696 AND `DifficultyID`=0); -- 77696 (Auchenai Soulpriest) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2216, `StaticFlags1`=536871168, `VerifiedBuild`=54904 WHERE (`Entry`=82681 AND `DifficultyID`=0); -- 82681 (Shield Stalker) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2216, `VerifiedBuild`=54904 WHERE (`Entry`=77693 AND `DifficultyID`=0); -- 77693 (Auchenai Defender) - + +-- Creature Difficulty (Heroic) +DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID`=2 AND `Entry` IN (77832,79417)); +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `StaticFlags1`, `StaticFlags2`, `StaticFlags3`, `StaticFlags4`, `StaticFlags5`, `StaticFlags6`, `StaticFlags7`, `StaticFlags8`, `VerifiedBuild`) VALUES +(77832, 2, 0, 0, 2218, 536871168, 0, 0, 0, 0, 0, 0, 0, 54904), -- 77832 (Soul Aegis) - Sessile, Floating +(79417, 2, 0, 0, 328, 536871168, 0, 0, 0, 0, 0, 0, 0, 54904); -- 79417 (Invisible Stalker) - Sessile; Floating + +DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID`=2 AND `Entry` IN (77132,77130,77133,77131,77810,77948,77812,77952,77951,77950,77134,75839,77949,77694,77704,77695,79248,77696,77693,77947)); +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`) VALUES +(77132, 2, 5, 5, 1, 79232, 270532680, 0), -- Sargerei Zealot +(77130, 2, 5, 5, 1, 79229, 2097224, 0), -- Sargerei Ritualist +(77133, 2, 5, 5, 1, 79228, 270532712, 0), -- Sargerei Hoplite +(77131, 2, 5, 8.5, 1, 79231, 2097224, 0), -- Sargerei Spirit-Tender +(77810, 2, 5, 26, 1, 79861, 2097256, 0), -- Soulbinder Nyami +(77948, 2, 5, 1, 1, 79867, 0, 0), -- Auchenai Hoplite +(77812, 2, 5, 8, 1, 79230, 2097224, 0), -- Sargerei Soulbinder +(77952, 2, 5, 1, 1, 79870, 0, 0), -- Auchenai Soulbinder +(77951, 2, 5, 1, 1, 79871, 0, 0), -- Auchenai Spirit-Tender +(77950, 2, 5, 1, 1, 79873, 0, 0), -- Auchenai Zealot +(77134, 2, 5, 10, 1, 79227, 2097224, 0), -- Sargerei Cleric +(75839, 2, 5, 35, 1, 79226, 270532712, 128), -- Vigilant Kaathar +(77949, 2, 5, 1, 1, 79869, 0, 0), -- Auchenai Ritualist +(77694, 2, 5, 1, 1, 79868, 0, 0), -- Auchenai Magus +(77704, 2, 5, 1, 1, 79872, 0, 0), -- Auchenai Warden +(77695, 2, 5, 1, 1, 79863, 0, 0), -- Auchenai Arbiter +(79248, 2, 5, 5.199999809265136718, 1, 79884, 32, 0), -- Soulbinder Tuulani +(77696, 2, 5, 1, 1, 79862, 0, 0), -- Auchenai Soulpriest +(77693, 2, 5, 1, 1, 79866, 0, 0), -- Auchenai Defender +(77947, 2, 5, 1, 1, 79864, 0, 0); -- Auchenai Cleric + +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2218, `StaticFlags1`=268435456, `VerifiedBuild`=54904 WHERE (`Entry`=77132 AND `DifficultyID`=2); -- 77132 (Sargerei Zealot) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2218, `StaticFlags1`=268435456, `VerifiedBuild`=54904 WHERE (`Entry`=77130 AND `DifficultyID`=2); -- 77130 (Sargerei Ritualist) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2218, `StaticFlags1`=268435456, `VerifiedBuild`=54904 WHERE (`Entry`=77133 AND `DifficultyID`=2); -- 77133 (Sargerei Hoplite) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2218, `StaticFlags1`=268435456, `VerifiedBuild`=54904 WHERE (`Entry`=77131 AND `DifficultyID`=2); -- 77131 (Sargerei Spirit-Tender) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2218, `StaticFlags1`=805306368, `VerifiedBuild`=54904 WHERE (`Entry`=77810 AND `DifficultyID`=2); -- 77810 (Soulbinder Nyami) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2218, `VerifiedBuild`=54904 WHERE (`Entry`=77948 AND `DifficultyID`=2); -- 77948 (Auchenai Hoplite) - +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2218, `StaticFlags1`=268435456, `VerifiedBuild`=54904 WHERE (`Entry`=77812 AND `DifficultyID`=2); -- 77812 (Sargerei Soulbinder) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2218, `VerifiedBuild`=54904 WHERE (`Entry`=77951 AND `DifficultyID`=2); -- 77951 (Auchenai Spirit-Tender) - +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2218, `VerifiedBuild`=54904 WHERE (`Entry`=77952 AND `DifficultyID`=2); -- 77952 (Auchenai Soulbinder) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2218, `VerifiedBuild`=54904 WHERE (`Entry`=77950 AND `DifficultyID`=2); -- 77950 (Auchenai Zealot) - +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2218, `StaticFlags1`=268435456, `VerifiedBuild`=54904 WHERE (`Entry`=75839 AND `DifficultyID`=2); -- 75839 (Vigilant Kaathar) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2218, `StaticFlags1`=268435456, `VerifiedBuild`=54904 WHERE (`Entry`=77134 AND `DifficultyID`=2); -- 77134 (Sargerei Cleric) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2218, `VerifiedBuild`=54904 WHERE (`Entry`=77949 AND `DifficultyID`=2); -- 77949 (Auchenai Ritualist) - +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2218 WHERE (`Entry`=77947 AND `DifficultyID`=2); -- 77947 (Auchenai Cleric) - +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2218, `VerifiedBuild`=54904 WHERE (`Entry`=77694 AND `DifficultyID`=2); -- 77694 (Auchenai Magus) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2218, `VerifiedBuild`=54904 WHERE (`Entry`=77704 AND `DifficultyID`=2); -- 77704 (Auchenai Warden) -- +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=9, `CreatureDifficultyID`=76970, `TypeFlags`=1024 WHERE (`Entry`=79417 AND `DifficultyID`=2); -- Invisible Stalker +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=5, `CreatureDifficultyID`=74871, `TypeFlags`=1024 WHERE (`Entry`=77832 AND `DifficultyID`=2); -- Soul Aegis +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=0, `LevelScalingDeltaMax`=0, `ContentTuningID`=2218 WHERE (`Entry`=79248 AND `DifficultyID`=2); -- 79248 (Soulbinder Tuulani) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2218 WHERE (`Entry`=77695 AND `DifficultyID`=2); -- 77695 (Auchenai Arbiter) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2218 WHERE (`DifficultyID`=2 AND `Entry` IN (82681,77819)); +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2218 WHERE (`Entry`=77696 AND `DifficultyID`=2); -- 77696 (Auchenai Soulpriest) - +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=0, `LevelScalingDeltaMax`=0, `ContentTuningID`=2218 WHERE (`Entry`=77693 AND `DifficultyID`=2); -- 77693 (Auchenai Defender) - + +-- Creature Difficulty (Mythic) +DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID`=23 AND `Entry` IN (77132,77130,77133,77131,77812,77832,79417,77134,75839)); +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`) VALUES +(77132, 23, 5, 5, 1, 93790, 270532680, 0), -- Sargerei Zealot +(77130, 23, 5, 5, 1, 93792, 2097224, 0), -- Sargerei Ritualist +(77133, 23, 5, 5, 1, 93789, 270532712, 0), -- Sargerei Hoplite +(77131, 23, 5, 8.5, 1, 93791, 2097224, 0), -- Sargerei Spirit-Tender +(77812, 23, 5, 8, 1, 93779, 2097224, 0), -- Sargerei Soulbinder +(77832, 23, 5, 1, 1, 74871, 1024, 0), -- Soul Aegis +(79417, 23, 9, 1, 1, 76970, 1024, 0), -- Invisible Stalker +(77134, 23, 5, 10, 1, 93788, 2097224, 0), -- Sargerei Cleric +(75839, 23, 5, 35, 1, 93888, 270532712, 128); -- Vigilant Kaathar + +DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID`=23 AND `Entry` IN (77810,77952,77948,77951,77950,77949,77947,77704,77695,77694)); +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `StaticFlags1`, `StaticFlags2`, `StaticFlags3`, `StaticFlags4`, `StaticFlags5`, `StaticFlags6`, `StaticFlags7`, `StaticFlags8`, `VerifiedBuild`) VALUES +(77810, 23, 2, 2, 2219, 805306368, 0, 0, 0, 0, 0, 0, 0, 54904), -- 77810 (Soulbinder Nyami) - CanSwim, Floating +(77952, 23, 1, 1, 2219, 0, 0, 0, 0, 0, 0, 0, 0, 54904), -- 77952 (Auchenai Soulbinder) - +(77948, 23, 0, 0, 2219, 0, 0, 0, 0, 0, 0, 0, 0, 54904), -- 77948 (Auchenai Hoplite) - +(77951, 23, 1, 1, 2219, 0, 0, 0, 0, 0, 0, 0, 0, 54904), -- 77951 (Auchenai Spirit-Tender) - +(77950, 23, 0, 0, 2219, 0, 0, 0, 0, 0, 0, 0, 0, 54904), -- 77950 (Auchenai Zealot) - +(77949, 23, 0, 0, 2219, 0, 0, 0, 0, 0, 0, 0, 0, 54904), -- 77949 (Auchenai Ritualist) - +(77947, 23, 1, 1, 2219, 0, 0, 0, 0, 0, 0, 0, 0, 54904), -- 77947 (Auchenai Cleric) - +(77704, 23, 0, 0, 2219, 0, 0, 0, 0, 0, 0, 0, 0, 54904), -- 77704 (Auchenai Warden) - +(77695, 23, 1, 1, 2219, 0, 0, 0, 0, 0, 0, 0, 0, 54904), -- 77695 (Auchenai Arbiter) - +(77694, 23, 1, 1, 2219, 0, 0, 0, 0, 0, 0, 0, 0, 54904); -- 77694 (Auchenai Magus) - + +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2219, `StaticFlags1`=268435456, `VerifiedBuild`=54904 WHERE (`Entry`=77132 AND `DifficultyID`=23); -- 77132 (Sargerei Zealot) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2219, `StaticFlags1`=268435456, `VerifiedBuild`=54904 WHERE (`Entry`=77130 AND `DifficultyID`=23); -- 77130 (Sargerei Ritualist) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2219, `StaticFlags1`=268435456, `VerifiedBuild`=54904 WHERE (`Entry`=77133 AND `DifficultyID`=23); -- 77133 (Sargerei Hoplite) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2219, `StaticFlags1`=268435456, `VerifiedBuild`=54904 WHERE (`Entry`=77131 AND `DifficultyID`=23); -- 77131 (Sargerei Spirit-Tender) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2219, `StaticFlags1`=536871168, `VerifiedBuild`=54904 WHERE (`Entry`=77832 AND `DifficultyID`=23); -- 77832 (Soul Aegis) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2219, `StaticFlags1`=268435456, `VerifiedBuild`=54904 WHERE (`Entry`=77812 AND `DifficultyID`=23); -- 77812 (Sargerei Soulbinder) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=328, `StaticFlags1`=536871168, `VerifiedBuild`=54904 WHERE (`Entry`=79417 AND `DifficultyID`=23); -- 79417 (Invisible Stalker) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2219, `StaticFlags1`=268435456, `VerifiedBuild`=54904 WHERE (`Entry`=75839 AND `DifficultyID`=23); -- 75839 (Vigilant Kaathar) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2219, `StaticFlags1`=268435456, `VerifiedBuild`=54904 WHERE (`Entry`=77134 AND `DifficultyID`=23); -- 77134 (Sargerei Cleric) - CanSwim + +-- Conditions +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup` = 1 AND `SourceEntry` = 156920; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 1, 156920, 0, 2, 51, 0, 5, 77832, 0, '', 0, 0, 0, '', 'Spell \'Void Beam\' can only hit \'Invisible Stalker\''); + +-- SAI +DELETE FROM `smart_scripts` WHERE `entryorguid`=77695 AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (7769500, 7769501) AND `source_type`=9; +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`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `action_param_string`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_param_string`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(77695, 0, 0, 0, '', 40, 0, 100, 0, 0, 7769500, 0, 0, 0, '', 80, (77695 * 100), 2, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Auchenai Arbiter - On Waypoint reached 0 - Set Action List'), +(77695, 0, 1, 0, '', 40, 0, 100, 0, 1, 7769500, 0, 0, 0, '', 80, (77695 * 100), 2, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Auchenai Arbiter - On Waypoint reached 1 - Set Action List'), +(77695, 0, 2, 0, '', 38, 0, 100, 0, 0, 1, 0, 0, 0, '', 80, (77695 * 100) + 1, 2, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Auchenai Magus - On Data Set - Action List'), +(77695, 0, 3, 0, '', 40, 0, 100, 0, 0, 7769501, 0, 0, 0, '', 97, 14, 0, 0, 0, 0, 0, 0, NULL, 8, 0, 0, 0, 0, NULL, 1665.137, 2927.535, 34.76397, 0, 'Auchenai Arbiter - Self: Jump To Pos'), +(77695, 0, 4, 0, '', 40, 0, 100, 0, 0, 7769501, 0, 0, 0, '', 11, 155525, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Auchenai Arbiter - Self: Cast Spell 155525'), +(77695, 0, 5, 0, '', 40, 0, 100, 0, 1, 7769501, 0, 0, 0, '', 97, 14, 0, 0, 0, 0, 0, 0, NULL, 8, 0, 0, 0, 0, NULL, 1655.913, 2979.347, 34.76414, 0, 'Auchenai Arbiter - Self: Jump To Pos'), +(77695, 0, 6, 0, '', 40, 0, 100, 0, 1, 7769501, 0, 0, 0, '', 11, 155525, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Auchenai Arbiter - Self: Cast Spell 155525'), +(7769500, 9, 0, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 66, 0, 0, 0, 0, 0, 0, 0, NULL, 19, 77693, 0, 0, 0, NULL, 0, 0, 0, 0, 'Auchenai Arbiter - Face To Auchenai Defender'), +(7769500, 9, 1, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 5, 22, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Auchenai Arbiter - Play emote OneShotShot'), +(7769501, 9, 0, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 53, 0, 7769501, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, 'EventRadiantFury', 0, 0, 0, 0, 'Auchenai Arbiter - Action List - Start Waypoint'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup` = 3 AND `SourceEntry`=77695; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(22, 3, 77695, 0, 0, 58, 1, 0, 0, 0, 'EventRadiantFury', 0, 0, 0, '', 'Scripted creature has StringId \'EventRadiantFury\''); + +-- SAI Sargerei Spirit-Tender +DELETE FROM `smart_scripts` WHERE `entryorguid`=77131 AND `source_type`=0; +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`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `action_param_string`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_param_string`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(77131, 0, 0, 0, '', 63, 0, 100, 0, 0, 0, 0, 0, 0, '', 11, 156920, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Sargerei Spirit-Tender - On Just Created - Self Cast spell 156920'); + +-- SAI Sargerei Soulbinder +DELETE FROM `smart_scripts` WHERE `entryorguid`=77812 AND `source_type`=0; +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`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `action_param_string`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_param_string`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(77812, 0, 0, 0, '', 63, 0, 100, 0, 0, 0, 0, 0, 0, '', 11, 156920, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Sargerei Soulbinder - On Just Created - Self Cast spell 156920'); + +-- SAI Sargerei Cleric +DELETE FROM `smart_scripts` WHERE `entryorguid`=77134 AND `source_type`=0; +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`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `action_param_string`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_param_string`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(77134, 0, 0, 0, '', 63, 0, 100, 0, 0, 0, 0, 0, 0, '', 11, 156920, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Sargerei Cleric - On Just Created - Self Cast spell 156920'); + +-- SAI Soulbinder Nymia +DELETE FROM `smart_scripts` WHERE `entryorguid`=77810 AND `source_type`=0; +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`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `action_param_string`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_param_string`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(77810, 0, 0, 0, '', 63, 0, 100, 0, 0, 0, 0, 0, 0, '', 11, 156920, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Soulbinder Nymia - On Just Created - Self Cast spell 156920'); + +-- SAI Auchenai Magus +DELETE FROM `smart_scripts` WHERE `entryorguid`=77694 AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid` = 7769400 AND `source_type`=9; +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`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `action_param_string`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_param_string`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(77694, 0, 0, 0, '', 1, 0, 100, 0, 9000, 30000, 9000, 30000, 0, '', 11, 157652, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Auchenai Magus (OOC) - Self: Cast spell 157652 on Self'), +(77694, 0, 1, 0, '', 40, 0, 100, 0, 0, 0, 0, 0, 0, '', 11, 157652, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Auchenai Magus - Waypoint Reached - Cast spell 157652'), +(77694, 0, 2, 0, '', 38, 0, 100, 0, 0, 1, 0, 0, 0, '', 80, (77694 * 100), 2, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Auchenai Magus - On Data Set - Action List'), +(7769400, 9, 0, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 53, 0, 7769400, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, 'EventArcaneBomb', 0, 0, 0, 0, 'Auchenai Soulpriest - Action List - Start Waypoint'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup` IN (1, 2, 3) AND `SourceEntry`=77694; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(22, 1, 77694, 0, 0, 58, 1, 0, 0, 0, 'CosmeticArcaneBomb', 0, 0, 0, '', 'Scripted creature has StringId \'CosmeticArcaneBomb\''), +(22, 2, 77694, 0, 0, 58, 1, 0, 0, 0, 'EventArcaneBomb', 0, 0, 0, '', 'Scripted creature has StringId \'EventArcaneBomb\''), +(22, 3, 77694, 0, 0, 58, 1, 0, 0, 0, 'EventArcaneBomb', 0, 0, 0, '', 'Scripted creature has StringId \'EventArcaneBomb\''); + +-- Event at Nave of Eternal Rest +DELETE FROM `smart_scripts` WHERE `entryorguid`=77696 AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (7769600, 7769601, 7769602) AND `source_type`=9; +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`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `action_param_string`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_param_string`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(77696, 0, 0, 0, '', 1, 0, 100, 0, 39000, 39000, 39000, 39000, 0, '', 87, 7769600, 7769601, 7769602, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Auchenai Soulpriest (OOC) - Run Random Script'), +(77696, 0, 1, 0, '', 40, 0, 100, 0, 0, 0, 0, 0, 0, '', 11, 157762, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Auchenai Soulpriest (OOC) - Waypoint Reached - Cast spell 157762'), +(7769600, 9, 0, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 53, 0, 7769600, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Auchenai Soulpriest - Action List - Start Waypoint'), +(7769601, 9, 1, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 45, 0, 1, 0, 0, 0, 0, 0, NULL, 19, 77694, 0, 0, 0, 'EventArcaneBomb', 0, 0, 0, 0, 'Auchenai Soulpriest - Action List - Set Data 0 1 to Auchenai Magus'), +(7769602, 9, 2, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 45, 0, 1, 0, 0, 0, 0, 0, NULL, 19, 77695, 0, 0, 0, 'EventRadiantFury', 0, 0, 0, 0, 'Auchenai Soulpriest - Action List - Set Data 0 1 to Auchenai Arbiter'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup` IN (1, 2) AND `SourceEntry`=77696; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(22, 1, 77696, 0, 0, 58, 1, 0, 0, 0, 'EventHalo', 0, 0, 0, '', 'Scripted creature has StringId \'EventHalo\''), +(22, 2, 77696, 0, 0, 58, 1, 0, 0, 0, 'EventHalo', 0, 0, 0, '', 'Scripted creature has StringId \'EventHalo\''); + +-- Path for CGUID+16 +SET @ENTRY := 77704; +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, 2, 'Auchenai Warden - 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, 1501.226, 2956.841, 35.23874, NULL, 16300), +(@PATH, 1, 1538.024, 2956.989, 35.23879, NULL, 0), +(@PATH, 2, 1538.042, 2949.358, 35.2387, NULL, 0), +(@PATH, 3, 1501.196, 2949.155, 35.22998, NULL, 15971), +(@PATH, 4, 1538.042, 2949.358, 35.2387, NULL, 0), +(@PATH, 5, 1538.024, 2956.989, 35.23879, NULL, 0); + +UPDATE `creature` SET `position_x`= 1501.226, `position_y`= 2956.841, `position_z`= 35.23874, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+16; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+16; +INSERT INTO `creature_addon` (`guid`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+16, @PATH, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '155647'); -- Auchenai Warden - 155647 - NPC Reaction + +-- Path for CGUID+120 +SET @ENTRY := 77704; +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, 'Auchenai Warden - 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, 1672.106, 3022.716, 35.16462, NULL, 10562), +(@PATH, 1, 1673.693, 3032.523, 35.23431, NULL, 16588); + +UPDATE `creature` SET `position_x`= 1672.106, `position_y`= 3022.716, `position_z`= 35.16462, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+120; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+120; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@CGUID+120, @PATH, 1); + +-- Path for CGUID+137 +SET @ENTRY := 77695; +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, 'Auchenai Arbiter - 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, 1709.325, 3099.063, 35.13764, NULL, 10193), +(@PATH, 1, 1714.448, 3104.976, 35.13763, NULL, 7779); + +UPDATE `creature` SET `position_x`= 1709.325, `position_y`= 3099.063, `position_z`= 35.13764, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+137; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+137; +INSERT INTO `creature_addon` (`guid`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+137, @PATH, 0, 0, 0, 0, 1, 0, 378, 0, 0, 0, 0, ''); -- Auchenai Arbiter + +-- Path for Auchenai Arbiter +SET @ENTRY := 77695; +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, 'Auchenai Arbiter - Scripted Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1660.043, 2953.735, 34.27824, NULL, 284), +(@PATH, 1, 1663.869, 2930.622, 34.82322, NULL, 280), +(@PATH, 2, 1650.58, 2962.983, 35.05951, 5.50257110, 0); + +-- Path for Auchenai Soulpriest +SET @ENTRY := 77696; +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, 'Auchenai Soulpriest - Scripted Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1661.759, 2953.042, 34.27822, NULL, 5126), +(@PATH, 1, 1674.719, 2953.108, 35.05952, 3.13579130, 0); + +-- Path for Auchenai Magus +SET @ENTRY := 77694; +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, 'Auchenai Magus - Scripted Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1660.287, 2952.155, 34.27823, NULL, 11557), +(@PATH, 1, 1654.024, 2940.446, 35.05951, 1.07963836, 0); |