diff options
| -rw-r--r-- | sql/updates/world/master/2022_10_13_00_world.sql | 804 |
1 files changed, 804 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_10_13_00_world.sql b/sql/updates/world/master/2022_10_13_00_world.sql new file mode 100644 index 00000000000..9bb8fa4ebd6 --- /dev/null +++ b/sql/updates/world/master/2022_10_13_00_world.sql @@ -0,0 +1,804 @@ +SET @CGUID := 650581; +SET @OGUID := 400187; + +-- Creature +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+378; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID+0, 114788, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3301.98876953125, 592.7742919921875, 635.8582763671875, 0.296480149030685424, 7200, 0, 0, 3865, 1534, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+1, 114791, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3110.171875, 543.24652099609375, 647.0072021484375, 4.723446369171142578, 7200, 0, 0, 7730, 0, 0, 0, 0, 0, 45745), -- Chosen of Eyir (Area: -Unknown- - Difficulty: 14) +(@CGUID+2, 114786, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 3287.65625, 613.7100830078125, 635.8555908203125, 0.179805979132652282, 7200, 0, 0, 3865, 1534, 0, 0, 0, 0, 45745), -- Valarjar Mystic (Area: -Unknown- - Difficulty: 14) (Auras: 191450 - Mod Scale 95-120%) +(@CGUID+3, 114787, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 3322.772705078125, 569.529541015625, 635.8551025390625, 3.614912271499633789, 7200, 0, 0, 3865, 1534, 0, 0, 0, 0, 45745), -- Valarjar Runecarver (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+4, 114786, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 3322.2900390625, 484.578125, 635.85247802734375, 3.538666248321533203, 7200, 0, 0, 3865, 1534, 0, 0, 0, 0, 45745), -- Valarjar Mystic (Area: -Unknown- - Difficulty: 14) (Auras: 191450 - Mod Scale 95-120%) +(@CGUID+5, 114784, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3286.39404296875, 450.373260498046875, 635.8585205078125, 4.811279773712158203, 7200, 0, 0, 2706, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+6, 114789, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 3171.294189453125, 548.060791015625, 632.72125244140625, 0, 7200, 0, 0, 6400, 0, 0, 0, 0, 0, 45745), -- Stormforged Sentinel (Area: -Unknown- - Difficulty: 14) +(@CGUID+7, 114785, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3317.049560546875, 496.78472900390625, 635.864013671875, 4.114185810089111328, 7200, 0, 0, 3788, 0, 0, 0, 0, 0, 45745), -- Valarjar Marksman (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+8, 114784, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3285.984375, 443.888885498046875, 635.8499755859375, 1.52594757080078125, 7200, 0, 0, 2706, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+9, 114787, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 3278.4697265625, 576.02081298828125, 635.85247802734375, 6.228013038635253906, 7200, 0, 0, 3865, 1534, 0, 0, 0, 0, 45745), -- Valarjar Runecarver (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+10, 114788, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3267.263916015625, 600.7413330078125, 635.8587646484375, 5.228653430938720703, 7200, 0, 0, 3865, 1534, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+11, 114784, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3221.62841796875, 508.961822509765625, 632.71221923828125, 1.065840721130371093, 7200, 0, 0, 2706, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+12, 114786, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 3233.143310546875, 547.23089599609375, 632.712158203125, 5.53787851333618164, 7200, 0, 0, 3865, 1534, 0, 0, 0, 0, 45745), -- Valarjar Mystic (Area: -Unknown- - Difficulty: 14) (Auras: 191450 - Mod Scale 95-120%) +(@CGUID+13, 114787, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 3296.6337890625, 533.951416015625, 635.74951171875, 4.262418746948242187, 7200, 0, 0, 3865, 1534, 0, 0, 0, 0, 45745), -- Valarjar Runecarver (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+14, 114786, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 3312.79345703125, 575.73956298828125, 635.8568115234375, 6.142906665802001953, 7200, 0, 0, 3865, 1534, 0, 0, 0, 0, 45745), -- Valarjar Mystic (Area: -Unknown- - Difficulty: 14) (Auras: 191450 - Mod Scale 95-120%) +(@CGUID+15, 114787, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 3294.1962890625, 443.53125, 635.8431396484375, 2.074612617492675781, 7200, 0, 0, 3865, 1534, 0, 0, 0, 0, 45745), -- Valarjar Runecarver (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+16, 114789, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 3264.68310546875, 519.92706298828125, 635.06951904296875, 0.106725648045539855, 7200, 0, 0, 6400, 0, 0, 0, 0, 0, 45745), -- Stormforged Sentinel (Area: -Unknown- - Difficulty: 14) +(@CGUID+17, 114784, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3288.466064453125, 493.25347900390625, 635.860107421875, 3.627431392669677734, 7200, 0, 0, 2706, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+18, 114785, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3322.358642578125, 480.10589599609375, 635.84912109375, 2.546734571456909179, 7200, 0, 0, 3788, 0, 0, 0, 0, 0, 45745), -- Valarjar Marksman (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+19, 114786, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 3321.32373046875, 500.109375, 635.8516845703125, 0.213788986206054687, 7200, 0, 0, 3865, 1534, 0, 0, 0, 0, 45745), -- Valarjar Mystic (Area: -Unknown- - Difficulty: 14) (Auras: 191450 - Mod Scale 95-120%) +(@CGUID+20, 114789, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 3302.962646484375, 505.0537109375, 635.0531005859375, 1.113230228424072265, 7200, 0, 0, 6400, 0, 0, 0, 0, 0, 45745), -- Stormforged Sentinel (Area: -Unknown- - Difficulty: 14) +(@CGUID+21, 114785, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3294.89404296875, 614.3680419921875, 635.84710693359375, 3.012674331665039062, 7200, 0, 0, 3788, 0, 0, 0, 0, 0, 45745), -- Valarjar Marksman (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+22, 114788, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3219.85498046875, 513.89239501953125, 632.71234130859375, 0, 7200, 0, 0, 3865, 1534, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+23, 114784, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3358.50341796875, 535.217041015625, 631.94720458984375, 3.957241058349609375, 7200, 0, 0, 2706, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+24, 114785, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3323.181396484375, 575.529541015625, 635.8497314453125, 3.131434202194213867, 7200, 0, 0, 3788, 0, 0, 0, 0, 0, 45745), -- Valarjar Marksman (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+25, 114788, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3286.42626953125, 563.44793701171875, 635.8585205078125, 1.618728995323181152, 7200, 0, 0, 3865, 1534, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+26, 114784, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3311.521728515625, 598.154541015625, 635.86187744140625, 4.095317840576171875, 7200, 0, 0, 2706, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+27, 114785, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3294.2587890625, 529.217041015625, 635.74847412109375, 0.580597341060638427, 7200, 0, 0, 3788, 0, 0, 0, 0, 0, 45745), -- Valarjar Marksman (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+28, 114787, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 3308.52685546875, 471.588531494140625, 635.85687255859375, 4.262418746948242187, 7200, 0, 0, 3865, 1534, 0, 0, 0, 0, 45745), -- Valarjar Runecarver (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+29, 114784, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3306.140625, 587.39239501953125, 635.85760498046875, 0.816173672676086425, 7200, 0, 0, 2706, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+30, 114787, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 3283.96875, 475.95660400390625, 635.85394287109375, 2.074612617492675781, 7200, 0, 0, 3865, 1534, 0, 0, 0, 0, 45745), -- Valarjar Runecarver (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+31, 114791, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3110.171875, 514.96527099609375, 647.0072021484375, 1.580252647399902343, 7200, 0, 0, 7730, 0, 0, 0, 0, 0, 45745), -- Chosen of Eyir (Area: -Unknown- - Difficulty: 14) +(@CGUID+32, 114784, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3302.30908203125, 527.75, 635.74871826171875, 2.928056001663208007, 7200, 0, 0, 2706, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+33, 114789, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 3264.655517578125, 537.9288330078125, 635.06884765625, 0.106725648045539855, 7200, 0, 0, 6400, 0, 0, 0, 0, 0, 45745), -- Stormforged Sentinel (Area: -Unknown- - Difficulty: 14) +(@CGUID+34, 114788, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3319.085205078125, 564.170166015625, 635.861328125, 1.253449201583862304, 7200, 0, 0, 3865, 1534, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+35, 114789, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 3299.411376953125, 563.4554443359375, 635.0531005859375, 4.883910179138183593, 7200, 0, 0, 6400, 0, 0, 0, 0, 0, 45745), -- Stormforged Sentinel (Area: -Unknown- - Difficulty: 14) +(@CGUID+36, 114785, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3237.267333984375, 544.123291015625, 632.712158203125, 2.54845285415649414, 7200, 0, 0, 3788, 0, 0, 0, 0, 0, 45745), -- Valarjar Marksman (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+37, 114789, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 3170.873291015625, 510.727447509765625, 632.71185302734375, 0, 7200, 0, 0, 6400, 0, 0, 0, 0, 0, 45745), -- Stormforged Sentinel (Area: -Unknown- - Difficulty: 14) +(@CGUID+38, 114787, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 3226.72998046875, 510.739593505859375, 632.71221923828125, 3.150338649749755859, 7200, 0, 0, 3865, 1534, 0, 0, 0, 0, 45745), -- Valarjar Runecarver (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+39, 114788, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3355.40966796875, 531.34893798828125, 631.94720458984375, 0.941482841968536376, 7200, 0, 0, 3865, 1534, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+40, 114784, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3279.154541015625, 496.1944580078125, 635.8604736328125, 5.612825393676757812, 7200, 0, 0, 2706, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+41, 114788, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3374.92626953125, 541.79864501953125, 631.25848388671875, 5.778752803802490234, 7200, 0, 0, 3865, 1534, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+42, 114786, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 3275.330810546875, 598.22918701171875, 635.86102294921875, 3.152405023574829101, 7200, 0, 0, 3865, 1534, 0, 0, 0, 0, 45745), -- Valarjar Mystic (Area: -Unknown- - Difficulty: 14) (Auras: 191450 - Mod Scale 95-120%) +(@CGUID+43, 114784, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3312.283935546875, 491.76214599609375, 635.86358642578125, 0.776352465152740478, 7200, 0, 0, 2706, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+44, 114788, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3298.212646484375, 524.95660400390625, 635.74847412109375, 1.314003705978393554, 7200, 0, 0, 3865, 1534, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+45, 114791, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3017.86376953125, 543.11285400390625, 670.0550537109375, 4.723446369171142578, 7200, 0, 0, 7730, 0, 0, 0, 0, 0, 45745), -- Chosen of Eyir (Area: -Unknown- - Difficulty: 14) +(@CGUID+46, 114791, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2625.4931640625, 542.65972900390625, 750.21905517578125, 4.723446369171142578, 7200, 0, 0, 7730, 0, 0, 0, 0, 0, 45745), -- Chosen of Eyir (Area: -Unknown- - Difficulty: 14) +(@CGUID+47, 114791, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2725.194580078125, 515.17535400390625, 731.87176513671875, 1.580252647399902343, 7200, 0, 0, 7730, 0, 0, 0, 0, 0, 45745), -- Chosen of Eyir (Area: -Unknown- - Difficulty: 14) +(@CGUID+48, 114791, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2924.94189453125, 515.6492919921875, 692.8958740234375, 1.580252647399902343, 7200, 0, 0, 7730, 0, 0, 0, 0, 0, 45745), -- Chosen of Eyir (Area: -Unknown- - Difficulty: 14) +(@CGUID+49, 114791, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3017.86376953125, 514.83160400390625, 670.0550537109375, 1.580252647399902343, 7200, 0, 0, 7730, 0, 0, 0, 0, 0, 45745), -- Chosen of Eyir (Area: -Unknown- - Difficulty: 14) +(@CGUID+50, 114791, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2924.94189453125, 543.9305419921875, 692.8958740234375, 4.723446369171142578, 7200, 0, 0, 7730, 0, 0, 0, 0, 0, 45745), -- Chosen of Eyir (Area: -Unknown- - Difficulty: 14) +(@CGUID+51, 114784, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3378.794189453125, 523.0850830078125, 630.3927001953125, 5.612825393676757812, 7200, 0, 0, 2706, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+52, 114791, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2823.955810546875, 543.16839599609375, 714.0494384765625, 4.723446369171142578, 7200, 0, 0, 7730, 0, 0, 0, 0, 0, 45745), -- Chosen of Eyir (Area: -Unknown- - Difficulty: 14) +(@CGUID+53, 114791, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2725.194580078125, 543.45660400390625, 731.87176513671875, 4.723446369171142578, 7200, 0, 0, 7730, 0, 0, 0, 0, 0, 45745), -- Chosen of Eyir (Area: -Unknown- - Difficulty: 14) +(@CGUID+54, 114791, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2625.4931640625, 514.37847900390625, 750.21905517578125, 1.580252647399902343, 7200, 0, 0, 7730, 0, 0, 0, 0, 0, 45745), -- Chosen of Eyir (Area: -Unknown- - Difficulty: 14) +(@CGUID+55, 114263, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2341.8837890625, 528.59375, 770.09112548828125, 0, 7200, 0, 0, 308160, 100, 0, 0, 0, 0, 45745), -- Odyn (Area: -Unknown- - Difficulty: 14) +(@CGUID+56, 114784, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3379.14501953125, 539.201416015625, 630.39715576171875, 2.511324644088745117, 7200, 0, 0, 2706, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+57, 114788, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 3380.2041015625, 518.670166015625, 630.39581298828125, 1.314003705978393554, 7200, 0, 0, 3865, 1534, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+58, 114791, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2823.955810546875, 514.88714599609375, 714.0494384765625, 1.580252647399902343, 7200, 0, 0, 7730, 0, 0, 0, 0, 0, 45745), -- Chosen of Eyir (Area: -Unknown- - Difficulty: 14) +(@CGUID+59, 114786, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 3385.315185546875, 524.7413330078125, 630.3829345703125, 3.955158472061157226, 7200, 0, 0, 3865, 1534, 0, 0, 0, 0, 45745), -- Valarjar Mystic (Area: -Unknown- - Difficulty: 14) (Auras: 191450 - Mod Scale 95-120%) +(@CGUID+60, 114789, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2576.798583984375, 544.232666015625, 748.748291015625, 0.157948881387710571, 7200, 0, 0, 6400, 0, 0, 0, 0, 0, 45745), -- Stormforged Sentinel (Area: -Unknown- - Difficulty: 14) +(@CGUID+61, 114789, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2577.118896484375, 514.328125, 748.740966796875, 0.157948881387710571, 7200, 0, 0, 6400, 0, 0, 0, 0, 0, 45745), -- Stormforged Sentinel (Area: -Unknown- - Difficulty: 14) +(@CGUID+62, 96574, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2527.921875, 567.33160400390625, 789.297607421875, 3.920105934143066406, 7200, 0, 0, 216, 0, 0, 0, 0, 0, 45745), -- Stormforged Sentinel (Area: -Unknown- - Difficulty: 14) +(@CGUID+63, 95842, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2525.350830078125, 584.95489501953125, 795.8079833984375, 4.193844795227050781, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+64, 97087, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2535.200439453125, 558.78302001953125, 792.5526123046875, 3.540673732757568359, 7200, 0, 0, 95, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+65, 97087, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2524.1337890625, 491.607635498046875, 786.0421142578125, 2.808092355728149414, 7200, 0, 0, 95, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+66, 95834, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2510.450439453125, 486.298614501953125, 776.2760009765625, 2.808092355728149414, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Mystic (Area: -Unknown- - Difficulty: 14) (Auras: 191450 - Mod Scale 95-120%) +(@CGUID+67, 96574, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2521.16064453125, 499.135406494140625, 840.6595458984375, 2.808092355728149414, 7200, 0, 0, 216, 0, 0, 0, 0, 0, 45745), -- Stormforged Sentinel (Area: -Unknown- - Difficulty: 14) +(@CGUID+68, 97087, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2521.827392578125, 468.498260498046875, 795.807373046875, 2.808092355728149414, 7200, 0, 0, 95, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+69, 95842, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2525.834228515625, 556.57989501953125, 782.78656005859375, 3.804104328155517578, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+70, 96574, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2517.12158203125, 577.623291015625, 786.04168701171875, 3.901625394821166992, 7200, 0, 0, 216, 0, 0, 0, 0, 0, 45745), -- Stormforged Sentinel (Area: -Unknown- - Difficulty: 14) +(@CGUID+71, 97087, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2511.010498046875, 575.23785400390625, 779.5308837890625, 4.261914730072021484, 7200, 0, 0, 95, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+72, 95834, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2537.8046875, 494.37152099609375, 795.80859375, 2.808092355728149414, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Mystic (Area: -Unknown- - Difficulty: 14) (Auras: 191450 - Mod Scale 95-120%) +(@CGUID+73, 97087, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2531.1875, 473.479156494140625, 799.06396484375, 2.808092355728149414, 7200, 0, 0, 95, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+74, 95842, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2531.58154296875, 490.673614501953125, 792.552978515625, 2.808092355728149414, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+75, 97087, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2526.631103515625, 578.37847900390625, 792.55322265625, 4.108850479125976562, 7200, 0, 0, 95, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+76, 95834, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2519.916748046875, 561.0555419921875, 779.53143310546875, 3.868478059768676757, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Mystic (Area: -Unknown- - Difficulty: 14) (Auras: 191450 - Mod Scale 95-120%) +(@CGUID+77, 95842, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2513.419189453125, 479.489593505859375, 782.7862548828125, 2.808092355728149414, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+78, 95834, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2511.748291015625, 570.453125, 776.27630615234375, 3.866049051284790039, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Mystic (Area: -Unknown- - Difficulty: 14) (Auras: 191450 - Mod Scale 95-120%) +(@CGUID+79, 96574, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2520.822998046875, 479.260406494140625, 789.2972412109375, 2.808092355728149414, 7200, 0, 0, 216, 0, 0, 0, 0, 0, 45745), -- Stormforged Sentinel (Area: -Unknown- - Difficulty: 14) +(@CGUID+80, 97087, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2480.713623046875, 617.34722900390625, 799.0218505859375, 4.700470924377441406, 7200, 0, 0, 95, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+81, 96574, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2493.1025390625, 452.602447509765625, 792.51068115234375, 2.131465673446655273, 7200, 0, 0, 216, 0, 0, 0, 0, 0, 45745), -- Stormforged Sentinel (Area: -Unknown- - Difficulty: 14) +(@CGUID+82, 96574, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2494.017333984375, 598.59375, 786, 4.457468986511230468, 7200, 0, 0, 216, 0, 0, 0, 0, 0, 45745), -- Stormforged Sentinel (Area: -Unknown- - Difficulty: 14) +(@CGUID+83, 95834, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2487.3212890625, 446.482635498046875, 795.76641845703125, 2.131465673446655273, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Mystic (Area: -Unknown- - Difficulty: 14) (Auras: 191450 - Mod Scale 95-120%) +(@CGUID+84, 95834, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2478.382080078125, 602.99481201171875, 786.0001220703125, 4.389131069183349609, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Mystic (Area: -Unknown- - Difficulty: 14) (Auras: 191450 - Mod Scale 95-120%) +(@CGUID+85, 95834, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2490.286376953125, 458.717010498046875, 786, 2.131465673446655273, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Mystic (Area: -Unknown- - Difficulty: 14) (Auras: 191450 - Mod Scale 95-120%) +(@CGUID+86, 95842, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2505.3837890625, 453.22222900390625, 795.7652587890625, 2.131465673446655273, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+87, 95834, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2489.229248046875, 592.82293701171875, 779.4893798828125, 4.535265445709228515, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Mystic (Area: -Unknown- - Difficulty: 14) (Auras: 191450 - Mod Scale 95-120%) +(@CGUID+88, 95842, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2475.263916015625, 596.701416015625, 779.4892578125, 3.804104089736938476, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+89, 97087, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2482.869873046875, 588.59027099609375, 780.3529052734375, 4.700470924377441406, 7200, 0, 0, 95, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+90, 97087, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2493.30029296875, 463.732635498046875, 782.74395751953125, 2.131465673446655273, 7200, 0, 0, 95, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+91, 96574, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2471.93408203125, 600.52777099609375, 782.7442626953125, 4.633760929107666015, 7200, 0, 0, 216, 0, 0, 0, 0, 0, 45745), -- Stormforged Sentinel (Area: -Unknown- - Difficulty: 14) +(@CGUID+92, 97087, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2495.546875, 593.80206298828125, 782.74407958984375, 4.014927864074707031, 7200, 0, 0, 95, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+93, 95842, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2475.538330078125, 451.15972900390625, 789.2554931640625, 2.131465673446655273, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+94, 97087, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2472.814208984375, 462.251739501953125, 779.48895263671875, 2.131465673446655273, 7200, 0, 0, 95, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+95, 97087, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2491.882080078125, 606.83856201171875, 792.51104736328125, 4.327576637268066406, 7200, 0, 0, 95, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+96, 97087, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2502.0400390625, 606.138916015625, 795.7657470703125, 4.177879810333251953, 7200, 0, 0, 95, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+97, 95842, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2487.673583984375, 468.87847900390625, 776.2335205078125, 2.131465673446655273, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+98, 95842, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2473.729248046875, 612.00518798828125, 792.51068115234375, 5.123279571533203125, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+99, 96574, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2434.923583984375, 447.614593505859375, 789.3472900390625, 1.806920647621154785, 7200, 0, 0, 216, 0, 0, 0, 0, 0, 45745), -- Stormforged Sentinel (Area: -Unknown- - Difficulty: 14) +(@CGUID+100, 95842, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2445.42529296875, 618.6336669921875, 795.83251953125, 5.123279571533203125, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+101, 97087, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2446.251708984375, 444.65277099609375, 792.6021728515625, 1.715370774269104003, 7200, 0, 0, 95, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+102, 95842, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2449.670166015625, 600.7117919921875, 779.5816650390625, 5.123279571533203125, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+103, 97087, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2431.232666015625, 607.82989501953125, 786.09100341796875, 5.180682182312011718, 7200, 0, 0, 95, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+104, 95842, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2443.203125, 451.607635498046875, 786.0919189453125, 2.131465673446655273, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+105, 97087, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2443.916748046875, 461.833343505859375, 776.3260498046875, 1.620431303977966308, 7200, 0, 0, 95, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+106, 95834, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2438.630126953125, 615.58160400390625, 792.5989990234375, 4.535265445709228515, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Mystic (Area: -Unknown- - Difficulty: 14) (Auras: 191450 - Mod Scale 95-120%) +(@CGUID+107, 95834, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2449.72216796875, 459.125, 779.5816650390625, 1.722623109817504882, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Mystic (Area: -Unknown- - Difficulty: 14) (Auras: 191450 - Mod Scale 95-120%) +(@CGUID+108, 95834, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2432.953125, 438.638885498046875, 799.11279296875, 1.573890328407287597, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Mystic (Area: -Unknown- - Difficulty: 14) (Auras: 191450 - Mod Scale 95-120%) +(@CGUID+109, 95834, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2429.953125, 600.953125, 779.58172607421875, 4.535265445709228515, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Mystic (Area: -Unknown- - Difficulty: 14) (Auras: 191450 - Mod Scale 95-120%) +(@CGUID+110, 95842, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2436.970458984375, 604.2725830078125, 782.83642578125, 5.123279571533203125, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+111, 97087, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2431.454833984375, 458.76214599609375, 779.5819091796875, 1.574580192565917968, 7200, 0, 0, 95, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+112, 97087, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2476.802001953125, 440.36285400390625, 799.021728515625, 2.131465673446655273, 7200, 0, 0, 95, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+113, 96574, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2446.333251953125, 608.35589599609375, 786.0914306640625, 4.768220901489257812, 7200, 0, 0, 216, 0, 0, 0, 0, 0, 45745), -- Stormforged Sentinel (Area: -Unknown- - Difficulty: 14) +(@CGUID+114, 95842, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2431.92529296875, 615.27081298828125, 792.56640625, 5.123279571533203125, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+115, 95834, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2432.279541015625, 621.8125, 799.0799560546875, 4.535265445709228515, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Mystic (Area: -Unknown- - Difficulty: 14) (Auras: 191450 - Mod Scale 95-120%) +(@CGUID+116, 97087, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2442.6875, 597.44793701171875, 776.3262939453125, 4.700470924377441406, 7200, 0, 0, 95, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+117, 95834, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2395.989501953125, 613.14410400390625, 795.76629638671875, 5.190628528594970703, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Mystic (Area: -Unknown- - Difficulty: 14) (Auras: 191450 - Mod Scale 95-120%) +(@CGUID+118, 95834, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2408.329833984375, 461.060760498046875, 779.4888916015625, 1.65281534194946289, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Mystic (Area: -Unknown- - Difficulty: 14) (Auras: 191450 - Mod Scale 95-120%) +(@CGUID+119, 97087, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2394.632080078125, 591.36981201171875, 776.23382568359375, 5.376995086669921875, 7200, 0, 0, 95, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+120, 97087, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2404.944580078125, 453.342010498046875, 786.0003662109375, 1.520025253295898437, 7200, 0, 0, 95, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+121, 95834, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2399.939208984375, 458.439239501953125, 782.7447509765625, 1.637854695320129394, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Mystic (Area: -Unknown- - Difficulty: 14) (Auras: 191450 - Mod Scale 95-120%) +(@CGUID+122, 97087, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2397.87841796875, 448.604156494140625, 792.51092529296875, 1.328917860984802246, 7200, 0, 0, 95, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+123, 95834, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2409.197998046875, 595.28125, 776.233642578125, 5.190628528594970703, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Mystic (Area: -Unknown- - Difficulty: 14) (Auras: 191450 - Mod Scale 95-120%) +(@CGUID+124, 97087, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2404.348876953125, 600.920166015625, 782.74468994140625, 5.376995086669921875, 7200, 0, 0, 95, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+125, 96574, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2403.267333984375, 611.39581298828125, 792.5108642578125, 5.167051315307617187, 7200, 0, 0, 216, 0, 0, 0, 0, 0, 45745), -- Stormforged Sentinel (Area: -Unknown- - Difficulty: 14) +(@CGUID+126, 97087, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2405.822998046875, 618.91143798828125, 799.021240234375, 5.376995086669921875, 7200, 0, 0, 95, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+127, 95842, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2390.423583984375, 468.779510498046875, 776.2335205078125, 1.392594575881958007, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+128, 114361, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2382.53125, 512.62847900390625, 749.0782470703125, 0.292808175086975097, 7200, 0, 0, 92624, 0, 0, 0, 0, 0, 45745), -- Hymdall (Area: -Unknown- - Difficulty: 14) (Auras: 228016 - Valarjar's Bond, 228018 - Valarjar's Bond) +(@CGUID+129, 114360, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2382.963623046875, 543.482666015625, 749.0782470703125, 6.275820255279541015, 7200, 0, 0, 92624, 0, 0, 0, 0, 0, 45745), -- Hyrja (Area: -Unknown- - Difficulty: 14) (Auras: 228018 - Valarjar's Bond) +(@CGUID+130, 96574, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2389.0869140625, 592.2899169921875, 779.48870849609375, 5.553338527679443359, 7200, 0, 0, 216, 0, 0, 0, 0, 0, 45745), -- Stormforged Sentinel (Area: -Unknown- - Difficulty: 14) +(@CGUID+131, 95842, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2402.7119140625, 442.548614501953125, 795.7667236328125, 1.248848319053649902, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+132, 95842, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2395.489501953125, 598.890625, 782.7447509765625, 5.123279571533203125, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+133, 95842, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2384.515625, 610.13714599609375, 795.7664794921875, 5.123279571533203125, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+134, 95834, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2388.197998046875, 604.20660400390625, 789.25567626953125, 5.26400613784790039, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Mystic (Area: -Unknown- - Difficulty: 14) (Auras: 191450 - Mod Scale 95-120%) +(@CGUID+135, 97087, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2389.875, 454.31597900390625, 789.2554931640625, 1.417665600776672363, 7200, 0, 0, 95, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+136, 97087, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2382.15966796875, 604.43231201171875, 792.5103759765625, 5.376995086669921875, 7200, 0, 0, 95, 0, 0, 0, 0, 0, 45745), -- Valarjar Champion (Area: -Unknown- - Difficulty: 14) (Auras: 123978 - Mod Scale 95-120%) +(@CGUID+137, 96574, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 0, 2380.517333984375, 446.04339599609375, 799.0216064453125, 0.973893523216247558, 7200, 0, 0, 216, 0, 0, 0, 0, 0, 45745), -- Stormforged Sentinel (Area: -Unknown- - Difficulty: 14) +(@CGUID+138, 95842, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2379.288330078125, 450.732635498046875, 795.7657470703125, 1.160579442977905273, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+139, 95842, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2374.65283203125, 608.3975830078125, 799.0206298828125, 5.658857345581054687, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+140, 95842, 1648, 8440, 8440, '14,15,16,17', 0, 0, 0, 1, 2387.73779296875, 462.736114501953125, 782.7442626953125, 1.19992232322692871, 7200, 0, 0, 135, 60, 0, 0, 0, 0, 45745), -- Valarjar Thundercaller (Area: -Unknown- - Difficulty: 14) +-- Hasutvald Area +(@CGUID+141, 114534, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 0, 3448.33935546875, 5771.0625, 96.49652862548828125, 4.814341545104980468, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Helhound (Area: -Unknown- - Difficulty: 14) (Auras: ) +(@CGUID+142, 93094, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 0, 3392.82666015625, 5940.55859375, 131.9110870361328125, 0.995890796184539794, 7200, 0, 0, 2751, 1534, 0, 0, 0, 0, 45745), -- Restless Ancestor (Area: -Unknown- - Difficulty: 14) (Auras: 184840 - Hover Anim Replacement, 191995 - Weakened Spirit, 221829 - Shadowy Ghost Visual, Bright) +(@CGUID+143, 114532, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3450.158935546875, 5765.30908203125, 96.37200927734375, 2.620513677597045898, 7200, 0, 0, 11909, 1640, 0, 0, 0, 0, 45745), -- Bonespeaker Soulbinder (Area: -Unknown- - Difficulty: 14) (Auras: ) +(@CGUID+144, 93094, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 0, 3385.80078125, 5980.720703125, 130.88934326171875, 1.054956674575805664, 7200, 10, 0, 2751, 1534, 1, 0, 0, 0, 45745), -- Restless Ancestor (Area: -Unknown- - Difficulty: 14) (Auras: 184840 - Hover Anim Replacement, 191995 - Weakened Spirit, 221829 - Shadowy Ghost Visual, Bright) (possible waypoints or random movement) +(@CGUID+145, 114547, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3377.249267578125, 5855.5322265625, 112.7891387939453125, 2.305945873260498046, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Ancient Bonethrall (Area: -Unknown- - Difficulty: 14) +(@CGUID+146, 114547, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3411.81591796875, 5772.60595703125, 101.4260787963867187, 1.544829487800598144, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Ancient Bonethrall (Area: -Unknown- - Difficulty: 14) +(@CGUID+147, 114672, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 0, 3478.4384765625, 5765.375, 99.1490325927734375, 0, 7200, 0, 0, 773, 0, 0, 0, 0, 0, 45745), -- Brazier Stalker (Area: -Unknown- - Difficulty: 14) +(@CGUID+148, 114547, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3469.614501953125, 5814.65087890625, 99.933349609375, 4.406435012817382812, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Ancient Bonethrall (Area: -Unknown- - Difficulty: 14) +(@CGUID+149, 114547, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3449.046142578125, 5735.93603515625, 84.689239501953125, 1.324221730232238769, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Ancient Bonethrall (Area: -Unknown- - Difficulty: 14) +(@CGUID+150, 93094, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 0, 3333.533447265625, 5962.07373046875, 123.746368408203125, 4.56000375747680664, 7200, 10, 0, 2751, 1534, 1, 0, 0, 0, 45745), -- Restless Ancestor (Area: -Unknown- - Difficulty: 14) (Auras: 184840 - Hover Anim Replacement, 191995 - Weakened Spirit, 221829 - Shadowy Ghost Visual, Bright) (possible waypoints or random movement) +(@CGUID+151, 114534, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 0, 3442.733642578125, 5766.56689453125, 96.38889312744140625, 6.099382400512695312, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Helhound (Area: -Unknown- - Difficulty: 14) +(@CGUID+152, 114547, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3363.723876953125, 5845.4521484375, 112.2184677124023437, 2.305945873260498046, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Ancient Bonethrall (Area: -Unknown- - Difficulty: 14) +(@CGUID+153, 114538, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3412.165771484375, 5813.4931640625, 100.0345535278320312, 2.543511152267456054, 7200, 0, 0, 9262, 0, 0, 0, 0, 0, 45745), -- Kvaldir Spiritrender (Area: -Unknown- - Difficulty: 14) +(@CGUID+154, 114547, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3368.424560546875, 5852.95556640625, 112.1097030639648437, 2.305945873260498046, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Ancient Bonethrall (Area: -Unknown- - Difficulty: 14) +(@CGUID+155, 114538, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3403.33251953125, 5803.689453125, 99.290985107421875, 2.087818145751953125, 7200, 0, 0, 9262, 0, 0, 0, 0, 0, 45745), -- Kvaldir Spiritrender (Area: -Unknown- - Difficulty: 14) +(@CGUID+156, 114547, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3405.635498046875, 5772.87841796875, 101.2447280883789062, 1.632381439208984375, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Ancient Bonethrall (Area: -Unknown- - Difficulty: 14) +(@CGUID+157, 114547, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3475.322998046875, 5812.5, 100.4158935546875, 4.567775249481201171, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Ancient Bonethrall (Area: -Unknown- - Difficulty: 14) +(@CGUID+158, 114532, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3414.380126953125, 5803.36962890625, 98.171875, 2.220149517059326171, 7200, 0, 0, 11909, 1640, 0, 0, 0, 0, 45745), -- Bonespeaker Soulbinder (Area: -Unknown- - Difficulty: 14) +(@CGUID+159, 93094, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 0, 3359.828125, 5904.3291015625, 125.9947967529296875, 3.976376533508300781, 7200, 0, 0, 2751, 1534, 0, 0, 0, 0, 45745), -- Restless Ancestor (Area: -Unknown- - Difficulty: 14) (Auras: 184840 - Hover Anim Replacement, 191995 - Weakened Spirit, 221829 - Shadowy Ghost Visual, Bright) +(@CGUID+160, 114538, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3504.704833984375, 5664.875, 83.798614501953125, 0.483767479658126831, 7200, 0, 0, 9262, 0, 0, 0, 0, 0, 45745), -- Kvaldir Spiritrender (Area: -Unknown- - Difficulty: 14) (Auras: 228317 - Near Brazier) +(@CGUID+161, 114534, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 0, 3484.189697265625, 5679.87548828125, 83.04901885986328125, 1.628462195396423339, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Helhound (Area: -Unknown- - Difficulty: 14) +(@CGUID+162, 114547, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3532.460205078125, 5769.88916015625, 103.006988525390625, 3.319352149963378906, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Ancient Bonethrall (Area: -Unknown- - Difficulty: 14) +(@CGUID+163, 114532, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3538.55029296875, 5695.6318359375, 52.99317169189453125, 2.274824857711791992, 7200, 0, 0, 11909, 1640, 0, 0, 0, 0, 45745), -- Bonespeaker Soulbinder (Area: -Unknown- - Difficulty: 14) +(@CGUID+164, 114548, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 0, 3578.30908203125, 5711.66943359375, 97.0662841796875, 3.564280986785888671, 7200, 0, 0, 31757, 0, 0, 0, 0, 0, 45745), -- Rotsoul Giant (Area: -Unknown- - Difficulty: 14) +(@CGUID+165, 114538, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3535.778564453125, 5611.861328125, 76.73077392578125, 0.483767479658126831, 7200, 0, 0, 9262, 0, 0, 0, 0, 0, 45745), -- Kvaldir Spiritrender (Area: -Unknown- - Difficulty: 14) (Auras: 228317 - Near Brazier) +(@CGUID+166, 114538, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3564.752685546875, 5692.77001953125, 97.21295166015625, 3.865037202835083007, 7200, 0, 0, 9262, 0, 0, 0, 0, 0, 45745), -- Kvaldir Spiritrender (Area: -Unknown- - Difficulty: 14) (Auras: 228317 - Near Brazier) +(@CGUID+167, 114534, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 0, 3514.236328125, 5629.6640625, 76.79685211181640625, 1.736200332641601562, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Helhound (Area: -Unknown- - Difficulty: 14) +(@CGUID+168, 114538, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3606.819580078125, 5681.923828125, 76.07515716552734375, 4.261194229125976562, 7200, 0, 0, 9262, 0, 0, 0, 0, 0, 45745), -- Kvaldir Spiritrender (Area: -Unknown- - Difficulty: 14) (Auras: 228317 - Near Brazier) +(@CGUID+169, 114534, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 0, 3507.742431640625, 5626.638671875, 77.13669586181640625, 2.215939283370971679, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Helhound (Area: -Unknown- - Difficulty: 14) +(@CGUID+170, 114547, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3451.635498046875, 5733.22216796875, 84.7647247314453125, 0.165481373667716979, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Ancient Bonethrall (Area: -Unknown- - Difficulty: 14) +(@CGUID+171, 114538, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3523.032958984375, 5640.11376953125, 79.04044342041015625, 1.58851170539855957, 7200, 0, 0, 9262, 0, 0, 0, 0, 0, 45745), -- Kvaldir Spiritrender (Area: -Unknown- - Difficulty: 14) (Auras: 228317 - Near Brazier) +(@CGUID+172, 114538, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3550.059814453125, 5614.35693359375, 36.51544189453125, 1.72895669937133789, 7200, 0, 0, 9262, 0, 0, 0, 0, 0, 45745), -- Kvaldir Spiritrender (Area: -Unknown- - Difficulty: 14) (Auras: 228317 - Near Brazier) +(@CGUID+173, 114534, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 0, 3491.21826171875, 5680.69775390625, 82.59198760986328125, 1.626511573791503906, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Helhound (Area: -Unknown- - Difficulty: 14) +(@CGUID+174, 114547, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3524.125, 5779.7890625, 103.00408935546875, 4.874868392944335937, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Ancient Bonethrall (Area: -Unknown- - Difficulty: 14) +(@CGUID+175, 114532, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3522.593017578125, 5680.01318359375, 52.95665740966796875, 2.274824857711791992, 7200, 0, 0, 11909, 1640, 0, 0, 0, 0, 45745), -- Bonespeaker Soulbinder (Area: -Unknown- - Difficulty: 14) +(@CGUID+176, 114538, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3541.875, 5709.3134765625, 95.8559112548828125, 3.865037202835083007, 7200, 0, 0, 9262, 0, 0, 0, 0, 0, 45745), -- Kvaldir Spiritrender (Area: -Unknown- - Difficulty: 14) (Auras: 228317 - Near Brazier) +(@CGUID+177, 114538, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3503.64404296875, 5735.001953125, 96.16534423828125, 3.865037202835083007, 7200, 0, 0, 9262, 0, 0, 0, 0, 0, 45745), -- Kvaldir Spiritrender (Area: -Unknown- - Difficulty: 14) (Auras: 228317 - Near Brazier) +(@CGUID+178, 114672, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 0, 3509.037353515625, 5732.46435546875, 99.2469482421875, 0, 7200, 0, 0, 773, 0, 0, 0, 0, 0, 45745), -- Brazier Stalker (Area: -Unknown- - Difficulty: 14) +(@CGUID+179, 114548, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 0, 3494.595458984375, 5639.6552734375, 77.50091552734375, 1.980064034461975097, 7200, 0, 0, 31757, 0, 0, 0, 0, 0, 45745), -- Rotsoul Giant (Area: -Unknown- - Difficulty: 14) +(@CGUID+180, 114672, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 0, 3485.6728515625, 5708.81103515625, 88.31146240234375, 0, 7200, 0, 0, 773, 0, 0, 0, 0, 0, 45745), -- Brazier Stalker (Area: -Unknown- - Difficulty: 14) +(@CGUID+181, 114534, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 0, 3547.199462890625, 5729.11767578125, 95.89127349853515625, 2.854892730712890625, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Helhound (Area: -Unknown- - Difficulty: 14) (Auras: ) +(@CGUID+182, 114538, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3596.72314453125, 5670.0869140625, 40.88824462890625, 4.261194229125976562, 7200, 0, 0, 9262, 0, 0, 0, 0, 0, 45745), -- Kvaldir Spiritrender (Area: -Unknown- - Difficulty: 14) (Auras: 228317 - Near Brazier) +(@CGUID+183, 114546, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 0, 3487.45068359375, 5683.67578125, 82.463470458984375, 1.652497291564941406, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Risen Bonethrall (Area: -Unknown- - Difficulty: 14) +(@CGUID+184, 114534, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 0, 3543.007080078125, 5724.82177734375, 96.29186248779296875, 2.211856842041015625, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Helhound (Area: -Unknown- - Difficulty: 14) (Auras: ) +(@CGUID+185, 114538, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3482.609375, 5710.6494140625, 85.17493438720703125, 0.483767479658126831, 7200, 0, 0, 9262, 0, 0, 0, 0, 0, 45745), -- Kvaldir Spiritrender (Area: -Unknown- - Difficulty: 14) (Auras: 228317 - Near Brazier) +(@CGUID+186, 114546, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 0, 3539.87060546875, 5731.49853515625, 95.7174835205078125, 2.620407581329345703, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Risen Bonethrall (Area: -Unknown- - Difficulty: 14) (Auras: ) +(@CGUID+187, 114538, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3573.40283203125, 5632.298828125, 25.81501388549804687, 1.651850104331970214, 7200, 0, 0, 9262, 0, 0, 0, 0, 0, 45745), -- Kvaldir Spiritrender (Area: -Unknown- - Difficulty: 14) +(@CGUID+188, 114539, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3578.298583984375, 5631.3349609375, 25.06152153015136718, 1.651850104331970214, 7200, 0, 0, 10586, 16400, 0, 0, 0, 0, 45745), -- Kvaldir Reefcaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+189, 114539, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3585.963623046875, 5639.689453125, 25.06077766418457031, 2.497718095779418945, 7200, 0, 0, 10586, 16400, 0, 0, 0, 0, 45745), -- Kvaldir Reefcaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+190, 114538, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3585.6171875, 5644.11181640625, 26.53461647033691406, 2.6584930419921875, 7200, 0, 0, 9262, 0, 0, 0, 0, 0, 45745), -- Kvaldir Spiritrender (Area: -Unknown- - Difficulty: 14) +(@CGUID+191, 114672, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 0, 3549.5869140625, 5707.36962890625, 100.3296585083007812, 0, 7200, 0, 0, 773, 0, 0, 0, 0, 0, 45745), -- Brazier Stalker (Area: -Unknown- - Difficulty: 14) +(@CGUID+192, 114538, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3608.0009765625, 5643.57275390625, 36.86886215209960937, 3.660773277282714843, 7200, 0, 0, 9262, 0, 0, 0, 0, 0, 45745), -- Kvaldir Spiritrender (Area: -Unknown- - Difficulty: 14) (Auras: 228317 - Near Brazier) +(@CGUID+193, 114548, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 0, 3560.87060546875, 5587.2255859375, 36.58924484252929687, 1.320157647132873535, 7200, 0, 0, 31757, 0, 0, 0, 0, 0, 45745), -- Rotsoul Giant (Area: -Unknown- - Difficulty: 14) +(@CGUID+194, 114538, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3573.647705078125, 5609.30029296875, 36.2286834716796875, 1.470846772193908691, 7200, 0, 0, 9262, 0, 0, 0, 0, 0, 45745), -- Kvaldir Spiritrender (Area: -Unknown- - Difficulty: 14) (Auras: 228317 - Near Brazier) +(@CGUID+195, 114548, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 0, 3635.228271484375, 5655.80029296875, 36.97372055053710937, 3.564280986785888671, 7200, 0, 0, 31757, 0, 0, 0, 0, 0, 45745), -- Rotsoul Giant (Area: -Unknown- - Difficulty: 14) +(@CGUID+196, 114672, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 0, 3503.65625, 5659.8583984375, 85.21062469482421875, 0, 7200, 0, 0, 773, 0, 0, 0, 0, 0, 45745), -- Brazier Stalker (Area: -Unknown- - Difficulty: 14) +(@CGUID+197, 114532, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3603.654541015625, 5606.48681640625, 13.78326416015625, 2.274824857711791992, 7200, 0, 0, 11909, 1640, 0, 0, 0, 0, 45745), -- Bonespeaker Soulbinder (Area: -Unknown- - Difficulty: 14) +(@CGUID+198, 114546, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 0, 3515.58935546875, 5655.87646484375, 78.6645355224609375, 0.779568254947662353, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Risen Bonethrall (Area: -Unknown- - Difficulty: 14) +(@CGUID+199, 114672, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 0, 3560.458251953125, 5695.6181640625, 100.812469482421875, 0, 7200, 0, 0, 773, 0, 0, 0, 0, 0, 45745), -- Brazier Stalker (Area: -Unknown- - Difficulty: 14) +(@CGUID+200, 114532, 1648, 8440, 8521, '14,15,16,17', 0, 0, 0, 1, 3609.507080078125, 5613.65625, 14.15479755401611328, 2.274824857711791992, 7200, 0, 0, 11909, 1640, 0, 0, 0, 0, 45745), -- Bonespeaker Soulbinder (Area: -Unknown- - Difficulty: 14) +(@CGUID+201, 114672, 1648, 8440, 8522, '14,15,16,17', 0, 0, 0, 0, 3518.489501953125, 5643.0693359375, 83.5663909912109375, 0, 7200, 0, 0, 773, 0, 0, 0, 0, 0, 45745), -- Brazier Stalker (Area: -Unknown- - Difficulty: 14) +(@CGUID+202, 114532, 1648, 8440, 8522, '14,15,16,17', 0, 0, 0, 1, 3633.8671875, 5582.59814453125, 38.93706893920898437, 5.54949951171875, 7200, 0, 0, 11909, 1640, 0, 0, 0, 0, 45745), -- Bonespeaker Soulbinder (Area: -Unknown- - Difficulty: 14) +(@CGUID+203, 114672, 1648, 8440, 8522, '14,15,16,17', 0, 0, 0, 0, 3537.9150390625, 5608.80908203125, 76.78790283203125, 0, 7200, 0, 0, 773, 0, 0, 0, 0, 0, 45745), -- Brazier Stalker (Area: -Unknown- - Difficulty: 14) +(@CGUID+204, 114532, 1648, 8440, 8522, '14,15,16,17', 0, 0, 0, 1, 3628.119873046875, 5561.9833984375, 38.93914031982421875, 0.193086639046669006, 7200, 0, 0, 11909, 1640, 0, 0, 0, 0, 45745), -- Bonespeaker Soulbinder (Area: -Unknown- - Difficulty: 14) +(@CGUID+205, 114672, 1648, 8440, 8522, '14,15,16,17', 0, 0, 0, 0, 3610.612060546875, 5678.78564453125, 76.78790283203125, 0, 7200, 0, 0, 773, 0, 0, 0, 0, 0, 45745), -- Brazier Stalker (Area: -Unknown- - Difficulty: 14) +(@CGUID+206, 114532, 1648, 8440, 8522, '14,15,16,17', 0, 0, 0, 1, 3652.908935546875, 5587.79345703125, 38.9381866455078125, 4.422446250915527343, 7200, 0, 0, 11909, 1640, 0, 0, 0, 0, 45745), -- Bonespeaker Soulbinder (Area: -Unknown- - Difficulty: 14) +(@CGUID+207, 114672, 1648, 8440, 8522, '14,15,16,17', 0, 0, 0, 0, 3554.329833984375, 5617.494140625, 37.7209320068359375, 0, 7200, 0, 0, 773, 0, 0, 0, 0, 0, 45745), -- Brazier Stalker (Area: -Unknown- - Difficulty: 14) +(@CGUID+208, 114672, 1648, 8440, 8522, '14,15,16,17', 0, 0, 0, 0, 3600.882080078125, 5662.57275390625, 37.7209320068359375, 0, 7200, 0, 0, 773, 0, 0, 0, 0, 0, 45745), -- Brazier Stalker (Area: -Unknown- - Difficulty: 14) +(@CGUID+209, 114548, 1648, 8440, 8522, '14,15,16,17', 0, 0, 0, 0, 3646.21435546875, 5567.82275390625, 38.94959259033203125, 2.104576349258422851, 7200, 0, 0, 31757, 0, 0, 0, 0, 0, 45745), -- Rotsoul Giant (Area: -Unknown- - Difficulty: 14) +(@CGUID+210, 114672, 1648, 8440, 8522, '14,15,16,17', 0, 0, 0, 0, 3605.604248046875, 5646.10498046875, 37.3061065673828125, 0, 7200, 0, 0, 773, 0, 0, 0, 0, 0, 45745), -- Brazier Stalker (Area: -Unknown- - Difficulty: 14) +(@CGUID+211, 114672, 1648, 8440, 8522, '14,15,16,17', 0, 0, 0, 0, 3570.520751953125, 5612.494140625, 37.3061065673828125, 0, 7200, 0, 0, 773, 0, 0, 0, 0, 0, 45745), -- Brazier Stalker (Area: -Unknown- - Difficulty: 14) +(@CGUID+212, 114672, 1648, 8440, 8522, '14,15,16,17', 0, 0, 0, 0, 3535.97216796875, 5558.3916015625, 63.59933853149414062, 0, 7200, 0, 0, 773, 0, 0, 0, 0, 0, 45745), -- Brazier Stalker (Area: -Unknown- - Difficulty: 14) +(@CGUID+213, 114672, 1648, 8440, 8522, '14,15,16,17', 0, 0, 0, 0, 3550.020751953125, 5572.056640625, 62.02167510986328125, 0, 7200, 0, 0, 773, 0, 0, 0, 0, 0, 45745), -- Brazier Stalker (Area: -Unknown- - Difficulty: 14) +(@CGUID+214, 114672, 1648, 8440, 8522, '14,15,16,17', 0, 0, 0, 0, 3646.65625, 5664.95849609375, 62.02167510986328125, 0, 7200, 0, 0, 773, 0, 0, 0, 0, 0, 45745), -- Brazier Stalker (Area: -Unknown- - Difficulty: 14) +(@CGUID+215, 114672, 1648, 8440, 8522, '14,15,16,17', 0, 0, 0, 0, 3661.637939453125, 5679.27783203125, 62.02167510986328125, 0, 7200, 0, 0, 773, 0, 0, 0, 0, 0, 45745), -- Brazier Stalker (Area: -Unknown- - Difficulty: 14) +(@CGUID+216, 114672, 1648, 8440, 8522, '14,15,16,17', 0, 0, 0, 0, 3588.49658203125, 5561.78662109375, 42.11798858642578125, 0, 7200, 0, 0, 773, 0, 0, 0, 0, 0, 45745), -- Brazier Stalker (Area: -Unknown- - Difficulty: 14) +(@CGUID+217, 114672, 1648, 8440, 8522, '14,15,16,17', 0, 0, 0, 0, 3655.958251953125, 5626.63525390625, 42.11798858642578125, 0, 7200, 0, 0, 773, 0, 0, 0, 0, 0, 45745), -- Brazier Stalker (Area: -Unknown- - Difficulty: 14) +(@CGUID+218, 114672, 1648, 8440, 8522, '14,15,16,17', 0, 0, 0, 0, 3587.257080078125, 5542.52978515625, 42.97108078002929687, 0, 7200, 0, 0, 773, 0, 0, 0, 0, 0, 45745), -- Brazier Stalker (Area: -Unknown- - Difficulty: 14) +(@CGUID+219, 114672, 1648, 8440, 8522, '14,15,16,17', 0, 0, 0, 0, 3673.90185546875, 5628.36279296875, 42.11798858642578125, 0, 7200, 0, 0, 773, 0, 0, 0, 0, 0, 45745), -- Brazier Stalker (Area: -Unknown- - Difficulty: 14) +-- Helheim Area +(@CGUID+220, 114538, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 373.0069580078125, 410.901031494140625, 18.98283767700195312, 2.107839107513427734, 7200, 0, 0, 9262, 0, 0, 0, 0, 0, 45745), -- Kvaldir Spiritrender (Area: -Unknown- - Difficulty: 14) (Auras: 228317 - Near Brazier) +(@CGUID+221, 114534, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 0, 434.711822509765625, 377.609375, 0.816870331764221191, 3.181462287902832031, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Helhound (Area: -Unknown- - Difficulty: 14) +(@CGUID+222, 114538, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 375.795135498046875, 420.19964599609375, 18.27316093444824218, 4.293008804321289062, 7200, 0, 0, 9262, 0, 0, 0, 0, 0, 45745), -- Kvaldir Spiritrender (Area: -Unknown- - Difficulty: 14) (Auras: 228317 - Near Brazier) +(@CGUID+223, 114547, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 367.017364501953125, 384.111114501953125, 24.71222114562988281, 2.439806461334228515, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Ancient Bonethrall (Area: -Unknown- - Difficulty: 14) +(@CGUID+224, 114538, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 441.2569580078125, 386.06597900390625, 0.963293433189392089, 4.80498504638671875, 7200, 0, 0, 9262, 0, 0, 0, 0, 0, 45745), -- Kvaldir Spiritrender (Area: -Unknown- - Difficulty: 14) (Auras: 228317 - Near Brazier) +(@CGUID+225, 114539, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 370.267364501953125, 369.234375, 27.30884742736816406, 6.155948162078857421, 7200, 0, 0, 10586, 16400, 0, 0, 0, 0, 45745), -- Kvaldir Reefcaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+226, 114534, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 0, 366.34375, 413.75, 18.86157417297363281, 3.181462526321411132, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Helhound (Area: -Unknown- - Difficulty: 14) +(@CGUID+227, 114539, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 371.015625, 363.24652099609375, 28.1604461669921875, 0.574547171592712402, 7200, 0, 0, 10586, 16400, 0, 0, 0, 0, 45745), -- Kvaldir Reefcaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+228, 114534, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 0, 445.164947509765625, 375.7257080078125, 1.058184981346130371, 4.293009281158447265, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Helhound (Area: -Unknown- - Difficulty: 14) +(@CGUID+229, 114538, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 367.90277099609375, 416.572906494140625, 18.6322479248046875, 6.198830604553222656, 7200, 0, 0, 9262, 0, 0, 0, 0, 0, 45745), -- Kvaldir Spiritrender (Area: -Unknown- - Difficulty: 14) (Auras: 228317 - Near Brazier) +(@CGUID+330, 114538, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 440.602447509765625, 374.385406494140625, 0.742419898509979248, 1.660672664642333984, 7200, 0, 0, 9262, 0, 0, 0, 0, 0, 45745), -- Kvaldir Spiritrender (Area: -Unknown- - Difficulty: 14) (Auras: 228317 - Near Brazier) +(@CGUID+331, 114534, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 0, 362.939239501953125, 381.44097900390625, 25.70524787902832031, 4.164832592010498046, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Helhound (Area: -Unknown- - Difficulty: 14) +(@CGUID+332, 114538, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 436.270843505859375, 380.432281494140625, 1.135416746139526367, 6.198831081390380859, 7200, 0, 0, 9262, 0, 0, 0, 0, 0, 45745), -- Kvaldir Spiritrender (Area: -Unknown- - Difficulty: 14) (Auras: 228317 - Near Brazier) +(@CGUID+333, 114534, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 0, 366.107635498046875, 371.404510498046875, 27.236907958984375, 2.219550371170043945, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Helhound (Area: -Unknown- - Difficulty: 14) +(@CGUID+334, 114547, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 364.204864501953125, 378.454864501953125, 25.95213508605957031, 3.656747102737426757, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Ancient Bonethrall (Area: -Unknown- - Difficulty: 14) +(@CGUID+335, 114538, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 445.7100830078125, 382.072906494140625, 1.202563047409057617, 4.003568649291992187, 7200, 0, 0, 9262, 0, 0, 0, 0, 0, 45745), -- Kvaldir Spiritrender (Area: -Unknown- - Difficulty: 14) (Auras: 228317 - Near Brazier) +(@CGUID+336, 114672, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 0, 372.54339599609375, 416.39410400390625, 20.26743316650390625, 0, 7200, 0, 0, 773, 0, 0, 0, 0, 0, 45745), -- Brazier Stalker (Area: -Unknown- - Difficulty: 14) +(@CGUID+337, 114672, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 0, 440.84375, 379.69097900390625, 3.511229991912841796, 0, 7200, 0, 0, 773, 0, 0, 0, 0, 0, 45745), -- Brazier Stalker (Area: -Unknown- - Difficulty: 14) +(@CGUID+338, 114539, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 382.142364501953125, 424.9757080078125, 18.14312934875488281, 3.306724786758422851, 7200, 0, 0, 10586, 16400, 0, 0, 0, 0, 45745), -- Kvaldir Reefcaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+339, 114534, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 0, 376.697906494140625, 414.25347900390625, 18.55938529968261718, 4.293009281158447265, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Helhound (Area: -Unknown- - Difficulty: 14) +(@CGUID+340, 114539, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 492.463531494140625, 328.192718505859375, 2.63223123550415039, 4.081829071044921875, 7200, 0, 0, 10586, 16400, 0, 0, 0, 0, 45745), -- Kvaldir Reefcaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+341, 114539, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 491.411468505859375, 323.454864501953125, 2.715974330902099609, 2.305614233016967773, 7200, 0, 0, 10586, 16400, 0, 0, 0, 0, 45745), -- Kvaldir Reefcaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+343, 114539, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 490.314239501953125, 647.65802001953125, 1.954291939735412597, 0.897942304611206054, 7200, 0, 0, 10586, 16400, 0, 0, 0, 0, 45745), -- Kvaldir Reefcaller (Area: -Unknown- - Difficulty: 14) (Auras: ) +(@CGUID+344, 116404, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 0, 472.20660400390625, 533.578125, 3.491601467132568359, 3.677042007446289062, 7200, 0, 0, 856, 0, 0, 0, 0, 0, 45745), -- Guarm's Chew Toy (Area: -Unknown- - Difficulty: 14) (Auras: 232391 - Guarm's Favorite Bone) +(@CGUID+345, 114323, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 0, 466.229156494140625, 498.477447509765625, 6.06031036376953125, 4.685933589935302734, 7200, 0, 0, 308160, 100, 0, 0, 0, 0, 45745), -- Guarm (Area: -Unknown- - Difficulty: 14) (Auras: 227512 - Multi-Headed) +(@CGUID+346, 114547, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 499.526031494140625, 321.130218505859375, 2.525347709655761718, 1.901872992515563964, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Ancient Bonethrall (Area: -Unknown- - Difficulty: 14) +(@CGUID+347, 114548, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 0, 495.02374267578125, 350.739410400390625, 2.647845983505249023, 1.534893035888671875, 7200, 0, 0, 31757, 0, 0, 0, 0, 0, 45745), -- Rotsoul Giant (Area: -Unknown- - Difficulty: 14) +(@CGUID+348, 114538, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 492.979156494140625, 314.8194580078125, 2.758961200714111328, 5.964539051055908203, 7200, 0, 0, 9262, 0, 0, 0, 0, 0, 45745), -- Kvaldir Spiritrender (Area: -Unknown- - Difficulty: 14) +(@CGUID+349, 114547, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 496.70660400390625, 317.970489501953125, 2.60565948486328125, 3.397397518157958984, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Ancient Bonethrall (Area: -Unknown- - Difficulty: 14) +(@CGUID+350, 114932, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 0, 442.7607421875, 635.8341064453125, 5.21347808837890625, 6.164109230041503906, 7200, 0, 0, 21171, 1640, 0, 0, 0, 0, 45745), -- Deepbrine Monstrosity (Area: -Unknown- - Difficulty: 14) (Auras: 217128 - Seaweed) +(@CGUID+351, 114539, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 503.71875, 634.9600830078125, 1.975303292274475097, 1.214860081672668457, 7200, 0, 0, 10586, 16400, 0, 0, 0, 0, 45745), -- Kvaldir Reefcaller (Area: -Unknown- - Difficulty: 14) (Auras: ) +(@CGUID+352, 114548, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 0, 482.666656494140625, 626.5086669921875, 2.213478326797485351, 5.780352592468261718, 7200, 0, 0, 31757, 0, 0, 0, 0, 0, 45745), -- Rotsoul Giant (Area: -Unknown- - Difficulty: 14) (Auras: ) +(@CGUID+353, 114538, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 505.036468505859375, 325.071197509765625, 2.444749116897583007, 0, 7200, 0, 0, 9262, 0, 0, 0, 0, 0, 45745), -- Kvaldir Spiritrender (Area: -Unknown- - Difficulty: 14) +(@CGUID+354, 114539, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 484.189239501953125, 647.01214599609375, 2.100876331329345703, 0.805534303188323974, 7200, 0, 0, 10586, 16400, 0, 0, 0, 0, 45745), -- Kvaldir Reefcaller (Area: -Unknown- - Difficulty: 14) (Auras: ) +(@CGUID+355, 114539, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 502.0225830078125, 640.6944580078125, 1.926480650901794433, 1.163261294364929199, 7200, 0, 0, 10586, 16400, 0, 0, 0, 0, 45745), -- Kvaldir Reefcaller (Area: -Unknown- - Difficulty: 14) (Auras: ) +(@CGUID+356, 114547, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 542.71527099609375, 614.90802001953125, 6.768410682678222656, 2.333387613296508789, 7200, 0, 0, 21172, 0, 0, 0, 0, 0, 45745), -- Ancient Bonethrall (Area: -Unknown- - Difficulty: 14) (Auras: 232346 - Rally of the Kvaldir) +(@CGUID+357, 114922, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 454.9288330078125, 595.39239501953125, -1.44839715957641601, 4.699264049530029296, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Dark Seraph (Area: -Unknown- - Difficulty: 14) +(@CGUID+358, 117783, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 0, 534.935791015625, 674.54168701171875, -84.9166641235351562, 0.891579985618591308, 7200, 0, 0, 773, 0, 0, 0, 0, 0, 45745), -- Gripping Tentacle (Area: -Unknown- - Difficulty: 14) (Auras: 234205 - Helya) +(@CGUID+359, 114539, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 497.157989501953125, 649.14581298828125, 1.939204573631286621, 1.00976574420928955, 7200, 0, 0, 10586, 16400, 0, 0, 0, 0, 45745), -- Kvaldir Reefcaller (Area: -Unknown- - Difficulty: 14) (Auras: ) +(@CGUID+360, 117784, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 0, 523.08160400390625, 712.904541015625, -70.87872314453125, 2.304878473281860351, 7200, 0, 0, 773, 0, 0, 0, 0, 0, 45745), -- Gripping Tentacle (Area: -Unknown- - Difficulty: 14) (Auras: 234204 - Helya) +(@CGUID+361, 114547, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 537.5694580078125, 629.61456298828125, 6.645550251007080078, 3.215488195419311523, 7200, 0, 0, 21172, 0, 0, 0, 0, 0, 45745), -- Ancient Bonethrall (Area: -Unknown- - Difficulty: 14) (Auras: 232346 - Rally of the Kvaldir) +(@CGUID+362, 114932, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 0, 523.79864501953125, 662.37677001953125, 2.270138263702392578, 3.65066695213317871, 7200, 0, 0, 21171, 1640, 0, 0, 0, 0, 45745), -- Deepbrine Monstrosity (Area: -Unknown- - Difficulty: 14) (Auras: 217128 - Seaweed) +(@CGUID+363, 114922, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 453.010406494140625, 676.4600830078125, 10.44071578979492187, 4.319749355316162109, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Dark Seraph (Area: -Unknown- - Difficulty: 14) +(@CGUID+364, 114932, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 0, 500.640625, 674.3975830078125, 2.225071430206298828, 4.628417491912841796, 7200, 0, 0, 21171, 1640, 0, 0, 0, 0, 45745), -- Deepbrine Monstrosity (Area: -Unknown- - Difficulty: 14) (Auras: 217128 - Seaweed) +(@CGUID+365, 114813, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 446.310760498046875, 669.04339599609375, 7.023967742919921875, 4.975840091705322265, 7200, 0, 0, 10586, 1640, 0, 0, 0, 0, 45745), -- Kvaldir Tide Witch (Area: -Unknown- - Difficulty: 14) +(@CGUID+366, 114537, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 0, 524.03125, 699.0555419921875, 5.1763153076171875, 4.298753261566162109, 7200, 0, 0, 494215, 100, 0, 0, 0, 0, 45745), -- Helya (Area: -Unknown- - Difficulty: 14) +(@CGUID+367, 114922, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 433.75, 673.29168701171875, 5.19580841064453125, 5.168002605438232421, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Dark Seraph (Area: -Unknown- - Difficulty: 14) +(@CGUID+368, 114539, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 554.53643798828125, 659.1632080078125, 18.04003143310546875, 3.405625104904174804, 7200, 0, 0, 10586, 16400, 0, 0, 0, 0, 45745), -- Kvaldir Reefcaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+369, 114813, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 438.645843505859375, 669.1319580078125, 7.112064361572265625, 4.948626995086669921, 7200, 0, 0, 10586, 1640, 0, 0, 0, 0, 45745), -- Kvaldir Tide Witch (Area: -Unknown- - Difficulty: 14) +(@CGUID+370, 114539, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 575.046875, 653.73089599609375, 18.03987503051757812, 3.203715324401855468, 7200, 0, 0, 10586, 16400, 0, 0, 0, 0, 45745), -- Kvaldir Reefcaller (Area: -Unknown- - Difficulty: 14) +(@CGUID+371, 114539, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 500.8125, 646.58160400390625, 1.926561832427978515, 1.086929798126220703, 7200, 0, 0, 10586, 16400, 0, 0, 0, 0, 45745), -- Kvaldir Reefcaller (Area: -Unknown- - Difficulty: 14) (Auras: ) +(@CGUID+372, 114547, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 539.0625, 640.2725830078125, 3.532245159149169921, 2.640752077102661132, 7200, 0, 0, 21172, 0, 0, 0, 0, 0, 45745), -- Ancient Bonethrall (Area: -Unknown- - Difficulty: 14) (Auras: 232346 - Rally of the Kvaldir) +(@CGUID+373, 114922, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 564.7117919921875, 671.015625, 16.04702377319335937, 4.893186569213867187, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Dark Seraph (Area: -Unknown- - Difficulty: 14) +(@CGUID+374, 114932, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 0, 454.2882080078125, 702.1336669921875, 18.01035118103027343, 3.21138930320739746, 7200, 0, 0, 21171, 1640, 0, 0, 0, 0, 45745), -- Deepbrine Monstrosity (Area: -Unknown- - Difficulty: 14) (Auras: 217128 - Seaweed) +(@CGUID+375, 114811, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 561.03125, 665.73785400390625, 18.03987693786621093, 5.409101009368896484, 7200, 0, 0, 10586, 0, 0, 0, 0, 0, 45745), -- Kvaldir Coral Maiden (Area: -Unknown- - Difficulty: 14) +(@CGUID+376, 114813, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 564.8038330078125, 664.47052001953125, 18.039764404296875, 3.007096529006958007, 7200, 0, 0, 10586, 1640, 0, 0, 0, 0, 45745), -- Kvaldir Tide Witch (Area: -Unknown- - Difficulty: 14) +(@CGUID+377, 114813, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 466.095489501953125, 698.0867919921875, 18.050384521484375, 4.312522411346435546, 7200, 0, 0, 10586, 1640, 0, 0, 0, 0, 45745), -- Kvaldir Tide Witch (Area: -Unknown- - Difficulty: 14) +(@CGUID+378, 114813, 1648, 8440, 8512, '14,15,16,17', 0, 0, 0, 1, 462.9600830078125, 707.84027099609375, 18.04800224304199218, 2.791689395904541015, 7200, 0, 0, 10586, 1640, 0, 0, 0, 0, 45745); -- Kvaldir Tide Witch (Area: -Unknown- - Difficulty: 14) + +-- Update UnitFlags for GUIDS since the entry is used in ToV - Valarjar Mystic - Valarjar Champion - Valarjar Thundercaller - Stormforged Sentinel +UPDATE `creature` SET `unit_flags`=33587520, `unit_flags3`=1 WHERE `guid` IN (@CGUID+66, @CGUID+72, @CGUID+76, @CGUID+78, @CGUID+83, @CGUID+84, @CGUID+85, @CGUID+87, @CGUID+106, @CGUID+107, @CGUID+108, @CGUID+109, @CGUID+115, @CGUID+117, @CGUID+118, @CGUID+121, @CGUID+123, @CGUID+134); +UPDATE `creature` SET `unit_flags`=33587520, `unit_flags3`=1 WHERE `guid` IN (@CGUID+64, @CGUID+65, @CGUID+68, @CGUID+71, @CGUID+73, @CGUID+75, @CGUID+80, @CGUID+89, @CGUID+90, @CGUID+92, @CGUID+94, @CGUID+95, @CGUID+96, @CGUID+101, @CGUID+103, @CGUID+105, @CGUID+111, @CGUID+112, @CGUID+116, @CGUID+119, @CGUID+120, @CGUID+122, @CGUID+124, @CGUID+126, @CGUID+135, @CGUID+136); +UPDATE `creature` SET `unit_flags`=33587520, `unit_flags3`=1 WHERE `guid` IN (@CGUID+63, @CGUID+69, @CGUID+74, @CGUID+77, @CGUID+86, @CGUID+88, @CGUID+93, @CGUID+97, @CGUID+98, @CGUID+100, @CGUID+102, @CGUID+104, @CGUID+110, @CGUID+114, @CGUID+127, @CGUID+131, @CGUID+132, @CGUID+133, @CGUID+138, @CGUID+139, @CGUID+140); +UPDATE `creature` SET `unit_flags`=33587520, `unit_flags3`=1 WHERE `guid` IN (@CGUID+62, @CGUID+67, @CGUID+70, @CGUID+79, @CGUID+81, @CGUID+82, @CGUID+91, @CGUID+99, @CGUID+113, @CGUID+125, @CGUID+130, @CGUID+137); + +-- GameObject +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+33; +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, 245702, 1648, 8440, 8440, '14,15,16,17', 0, 0, 3196.19970703125, 371.3297119140625, 655.4173583984375, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 7200, 255, 0, 45745), -- Doodad_7du_valhalla_gate003 (Area: -Unknown- - Difficulty: 14) +(@OGUID+1, 246144, 1648, 8440, 8440, '14,15,16,17', 0, 0, 3154.173828125, 530.00775146484375, 634.71710205078125, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 0, 45745), -- Doodad_7du_valhalla_bridge001 (Area: -Unknown- - Difficulty: 14) +(@OGUID+2, 253130, 1648, 8440, 8440, '14,15,16,17', 0, 0, 3250.239501953125, 528.171875, 640, 3.083585739135742187, 0, 0, 0.999579429626464843, 0.028999343514442443, 7200, 255, 1, 45745), -- Instance Portal (Area: -Unknown- - Difficulty: 14) +(@OGUID+3, 244664, 1648, 8440, 8440, '14,15,16,17', 0, 0, 3254.5224609375, 529.18182373046875, 632.6917724609375, 0, 0, 0, 0, 1, 7200, 255, 1, 45745), -- The Gateway of Splendor (Area: -Unknown- - Difficulty: 14) +(@OGUID+4, 245701, 1648, 8440, 8440, '14,15,16,17', 0, 0, 3487.18505859375, 529.2353515625, 616.943603515625, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 45745), -- Doodad_7du_valhalla_gate002 (Area: -Unknown- - Difficulty: 14) +(@OGUID+5, 245700, 1648, 8440, 8440, '14,15,16,17', 0, 0, 3581.256103515625, 529.2353515625, 616.943603515625, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 0, 45745), -- Doodad_7du_valhalla_gate001 (Area: -Unknown- - Difficulty: 14) +(@OGUID+6, 246145, 1648, 8440, 8440, '14,15,16,17', 0, 0, 2520.255859375, 528.95953369140625, 749.0062255859375, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 0, 45745), -- Doodad_7du_valhalla_gate006 (Area: -Unknown- - Difficulty: 14) +(@OGUID+7, 245884, 1648, 8440, 8440, '14,15,16,17', 0, 0, 2439.17724609375, 530.0076904296875, 773.53912353515625, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 0, 45745), -- Doodad_7du_valhalla_gate004 (Area: -Unknown- - Difficulty: 14) +(@OGUID+8, 245699, 1648, 8440, 8440, '14,15,16,17', 0, 0, 2461.408935546875, 528.71466064453125, 747.94891357421875, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 45745), -- Doodad_7du_valhalla_rune005 (Area: -Unknown- - Difficulty: 14) +(@OGUID+9, 245698, 1648, 8440, 8440, '14,15,16,17', 0, 0, 2437.717529296875, 497.51763916015625, 747.94891357421875, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 45745), -- Doodad_7du_valhalla_rune004 (Area: -Unknown- - Difficulty: 14) +(@OGUID+10, 245696, 1648, 8440, 8440, '14,15,16,17', 0, 0, 2437.7275390625, 559.927734375, 747.94891357421875, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 45745), -- Doodad_7du_valhalla_rune002 (Area: -Unknown- - Difficulty: 14) +(@OGUID+11, 245697, 1648, 8440, 8440, '14,15,16,17', 0, 0, 2403.38330078125, 509.320098876953125, 747.94891357421875, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 45745), -- Doodad_7du_valhalla_rune003 (Area: -Unknown- - Difficulty: 14) +(@OGUID+12, 245695, 1648, 8440, 8440, '14,15,16,17', 0, 0, 2403.39599609375, 548.13519287109375, 747.94891357421875, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 45745), -- Doodad_7du_valhalla_rune001 (Area: -Unknown- - Difficulty: 14) +-- Haustvald Area +(@OGUID+13, 266845, 1648, 8440, 8521, '14,15,16,17', 0, 0, 2355.476806640625, 5711.20751953125, 252.9258575439453125, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 7200, 255, 0, 45745), -- Doodad_7du_valhalla_door001 (Area: -Unknown- - Difficulty: 14) +-- Helheim Area +(@OGUID+14, 266531, 1648, 8440, 8512, '14,15,16,17', 0, 0, 440.967010498046875, 379.54339599609375, 1.92790389060974121, 3.892087936401367187, -0.00392055511474609, -0.00191402435302734, -0.93040752410888671, 0.366500794887542724, 7200, 255, 1, 45745), -- Bonfire (Area: -Unknown- - Difficulty: 14) +(@OGUID+15, 266530, 1648, 8440, 8512, '14,15,16,17', 0, 0, 372.0538330078125, 416.4375, 18.20260047912597656, 3.804818153381347656, -0.02441787719726562, -0.0249185562133789, -0.94478416442871093, 0.325830787420272827, 7200, 255, 1, 45745), -- Bonfire (Area: -Unknown- - Difficulty: 14) +(@OGUID+16, 266532, 1648, 8440, 8512, '14,15,16,17', 0, 0, 473.461822509765625, 433.173614501953125, 7.124047279357910156, 4.68620920181274414, 0, 0, -0.71630191802978515, 0.697790443897247314, 7200, 255, 0, 45745), -- Guarm_Boss_Door01 (Area: -Unknown- - Difficulty: 14) +(@OGUID+17, 243404, 1648, 8440, 8512, '14,15,16,17', 0, 0, 335.029510498046875, 343.282989501953125, 30.52192115783691406, 0.989376246929168701, 0, 0, 0.474757194519042968, 0.880116820335388183, 7200, 255, 1, 45745), -- Collision Wall (Area: -Unknown- - Difficulty: 14) +(@OGUID+18, 265596, 1648, 8440, 8512, '14,15,16,17', 0, 0, 468.805572509765625, 616.03302001953125, 3.235487699508666992, 0.662890315055847167, 0, 0, 0.325409889221191406, 0.945573031902313232, 7200, 255, 1, 45745), -- Ritual Stone (Area: -Unknown- - Difficulty: 14) +(@OGUID+19, 266533, 1648, 8440, 8512, '14,15,16,17', 0, 0, 462.59722900390625, 562.20831298828125, 0.702151119709014892, 4.773476600646972656, 0, 0, -0.68518257141113281, 0.728371381759643554, 7200, 255, 1, 45745), -- Guarm_Boss_Door02 (Area: -Unknown- - Difficulty: 14) +(@OGUID+20, 265596, 1648, 8440, 8512, '14,15,16,17', 0, 0, 501.75347900390625, 601.94268798828125, 2.794027566909790039, 1.849896669387817382, 0, 0, 0.798589706420898437, 0.601875841617584228, 7200, 255, 1, 45745), -- Ritual Stone (Area: -Unknown- - Difficulty: 14) +(@OGUID+21, 265596, 1648, 8440, 8512, '14,15,16,17', 0, 0, 482.5850830078125, 606.3367919921875, 2.794027566909790039, 1.166894793510437011, 0, 0, 0.550904273986816406, 0.834568440914154052, 7200, 255, 1, 45745), -- Ritual Stone (Area: -Unknown- - Difficulty: 14) +(@OGUID+22, 265596, 1648, 8440, 8512, '14,15,16,17', 0, 0, 543.91668701171875, 676.76043701171875, 0.847184181213378906, 3.73675847053527832, 0, 0, -0.95604801177978515, 0.293210148811340332, 7200, 255, 1, 45745), -- Ritual Stone (Area: -Unknown- - Difficulty: 14) +(@OGUID+23, 265596, 1648, 8440, 8512, '14,15,16,17', 0, 0, 500.23089599609375, 698.97222900390625, 2.595106363296508789, 4.756479263305664062, 0, 0, -0.69134807586669921, 0.722521901130676269, 7200, 255, 1, 45745), -- Ritual Stone (Area: -Unknown- - Difficulty: 14) +(@OGUID+24, 266917, 1648, 8440, 8512, '14,15,16,17', 0, 0, 453.03033447265625, 694.74237060546875, 17.92857933044433593, 5.183629035949707031, 0, 0, -0.52249813079833984, 0.852640450000762939, 7200, 255, 1, 45745), -- Doodad_7vr_Vrykul_fence004 (Area: -Unknown- - Difficulty: 14) +(@OGUID+25, 266916, 1648, 8440, 8512, '14,15,16,17', 0, 0, 468.612213134765625, 683.47601318359375, 17.92857933044433593, 5.183629035949707031, 0, 0, -0.52249813079833984, 0.852640450000762939, 7200, 255, 1, 45745), -- Doodad_7vr_Vrykul_fence003 (Area: -Unknown- - Difficulty: 14) +(@OGUID+26, 242454, 1648, 8440, 8512, '14,15,16,17', 0, 0, 520.09027099609375, 767.045166015625, -3.82647061347961425, 4.492815017700195312, 0, 0, -0.78032493591308593, 0.625374317169189453, 7200, 255, 1, 45745), -- Hellfire Gate (Area: -Unknown- - Difficulty: 14) +(@OGUID+27, 265596, 1648, 8440, 8512, '14,15,16,17', 0, 0, 556.420166015625, 675.78125, 18.14999580383300781, 5.226071357727050781, 0, 0, -0.5042877197265625, 0.863535702228546142, 7200, 255, 1, 45745), -- Ritual Stone (Area: -Unknown- - Difficulty: 14) +(@OGUID+28, 266915, 1648, 8440, 8512, '14,15,16,17', 0, 0, 549.68426513671875, 644.76434326171875, 17.92857933044433593, 5.183629035949707031, 0, 0, -0.52249813079833984, 0.852640450000762939, 7200, 255, 1, 45745), -- Doodad_7vr_Vrykul_fence002 (Area: -Unknown- - Difficulty: 14) +(@OGUID+29, 242454, 1648, 8440, 8512, '14,15,16,17', 0, 0, 498.791656494140625, 757.62152099609375, -3.82613921165466308, 5.813851356506347656, 0, 0, -0.23251914978027343, 0.972591817378997802, 7200, 255, 1, 45745), -- Hellfire Gate (Area: -Unknown- - Difficulty: 14) +(@OGUID+30, 266914, 1648, 8440, 8512, '14,15,16,17', 0, 0, 568.12274169921875, 636.2069091796875, 17.92857933044433593, 5.183629035949707031, 0, 0, -0.52249813079833984, 0.852640450000762939, 7200, 255, 1, 45745), -- Doodad_7vr_Vrykul_fence001 (Area: -Unknown- - Difficulty: 14) +(@OGUID+31, 242454, 1648, 8440, 8512, '14,15,16,17', 0, 0, 562.51739501953125, 714.20489501953125, -3.79519820213317871, 3.198065996170043945, 0, 0, -0.99960136413574218, 0.028232833370566368, 7200, 255, 1, 45745), -- Hellfire Gate (Area: -Unknown- - Difficulty: 14) +(@OGUID+32, 242454, 1648, 8440, 8512, '14,15,16,17', 0, 0, 543.77777099609375, 760.86981201171875, -4.10994291305541992, 4.492815017700195312, 0, 0, -0.78032493591308593, 0.625374317169189453, 7200, 255, 1, 45745), -- Hellfire Gate (Area: -Unknown- - Difficulty: 14) +(@OGUID+33, 242454, 1648, 8440, 8512, '14,15,16,17', 0, 0, 561.2742919921875, 754.23785400390625, -4.03214311599731445, 3.198065996170043945, 0, 0, -0.99960136413574218, 0.028232833370566368, 7200, 255, 1, 45745); -- Hellfire Gate (Area: -Unknown- - Difficulty: 14) +DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+33; +INSERT INTO `gameobject_addon` (`guid`, `parent_rotation0`, `parent_rotation1`, `parent_rotation2`, `parent_rotation3`, `WorldEffectID`, `AIAnimKitID`) VALUES +(@OGUID+0, 0, 0, 1, -0.00000004371138828, 0, 0), -- Doodad_7du_valhalla_gate003 +(@OGUID+1, 0, 0, 1, -0.00000004371138828, 0, 0), -- Doodad_7du_valhalla_bridge001 +(@OGUID+3, 0, 0, 1, -0.00000004371138828, 0, 0), -- The Gateway of Splendor +(@OGUID+4, 0, 0, 1, -0.00000004371138828, 0, 0), -- Doodad_7du_valhalla_gate002 +(@OGUID+5, 0, 0, 1, -0.00000004371138828, 0, 0), -- Doodad_7du_valhalla_gate001 +(@OGUID+6, 0, 0, 1, -0.00000004371138828, 0, 0), -- Doodad_7du_valhalla_gate006 +(@OGUID+7, 0, 0, 1, -0.00000004371138828, 0, 0), -- Doodad_7du_valhalla_gate004 +(@OGUID+8, 0, 0, 1, -0.00000004371138828, 0, 0), -- Doodad_7du_valhalla_rune005 +(@OGUID+9, 0, 0, 1, -0.00000004371138828, 0, 0), -- Doodad_7du_valhalla_rune004 +(@OGUID+10, 0, 0, 1, -0.00000004371138828, 0, 0), -- Doodad_7du_valhalla_rune002 +(@OGUID+11, 0, 0, 1, -0.00000004371138828, 0, 0), -- Doodad_7du_valhalla_rune003 +(@OGUID+12, 0, 0, 1, -0.00000004371138828, 0, 0), -- Doodad_7du_valhalla_rune001 +(@OGUID+13, 0, 0, 0.382683455944061279, 0.923879563808441162, 0, 0), -- Doodad_7du_valhalla_door001 +(@OGUID+17, 0, 0, 0, 1, 0, 12054), -- Ritual Stone +(@OGUID+19, 0, 0, 0, 1, 0, 12054), -- Ritual Stone +(@OGUID+20, 0, 0, 0, 1, 0, 12054), -- Ritual Stone +(@OGUID+21, 0, 0, 0, 1, 0, 12054), -- Ritual Stone +(@OGUID+22, 0, 0, 0, 1, 0, 12054), -- Ritual Stone +(@OGUID+24, 0, 0, -0.52249842882156372, 0.852640211582183837, 0, 0), -- Doodad_7vr_Vrykul_fence004 +(@OGUID+25, 0, 0, -0.52249842882156372, 0.852640211582183837, 0, 0), -- Doodad_7vr_Vrykul_fence003 +(@OGUID+27, 0, 0, 0, 1, 0, 12054), -- Ritual Stone +(@OGUID+28, 0, 0, -0.52249842882156372, 0.852640211582183837, 0, 0), -- Doodad_7vr_Vrykul_fence002 +(@OGUID+30, 0, 0, -0.52249842882156372, 0.852640211582183837, 0, 0); -- Doodad_7vr_Vrykul_fence001 + +-- Creature Addon +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+378; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+152, 0, 0, 0, 1, 333, 0, 0, 0, 3, ''), -- Ancient Bonethrall +(@CGUID+154, 0, 0, 0, 1, 333, 0, 0, 0, 3, ''), -- Ancient Bonethrall +(@CGUID+145, 0, 0, 0, 1, 333, 0, 0, 0, 3, ''), -- Ancient Bonethrall +(@CGUID+153, 0, 0, 0, 1, 333, 0, 0, 0, 3, ''), -- Kvaldir Spiritrender +(@CGUID+155, 0, 0, 0, 1, 333, 0, 0, 0, 3, ''), -- Kvaldir Spiritrender +(@CGUID+158, 0, 0, 0, 1, 425, 0, 0, 0, 3, ''), -- Bonespeaker Soulbinder +(@CGUID+143, 0, 0, 8, 1, 0, 0, 0, 0, 3, ''), -- Bonespeaker Soulbinder +(@CGUID+189, 0, 0, 0, 1, 425, 0, 0, 0, 3, ''), -- Kvaldir Reefcaller +(@CGUID+188, 0, 0, 0, 1, 425, 0, 0, 0, 3, ''), -- Kvaldir Reefcaller +(@CGUID+187, 0, 0, 0, 1, 333, 0, 0, 0, 3, '228317'), -- Kvaldir Spiritrender - 228317 - Near Brazier +(@CGUID+190, 0, 0, 0, 1, 333, 0, 0, 0, 3, '228317'), -- Kvaldir Spiritrender - 228317 - Near Brazier +(@CGUID+146, 0, 0, 3, 1, 0, 0, 0, 0, 3, ''), -- Ancient Bonethrall +(@CGUID+156, 0, 0, 3, 1, 0, 0, 0, 0, 3, ''), -- Ancient Bonethrall +(@CGUID+148, 0, 0, 3, 1, 0, 0, 0, 0, 3, ''), -- Ancient Bonethrall +(@CGUID+157, 0, 0, 3, 1, 0, 0, 0, 0, 3, ''), -- Ancient Bonethrall +(@CGUID+170, 0, 0, 3, 1, 0, 0, 0, 0, 3, ''), -- Ancient Bonethrall +(@CGUID+149, 0, 0, 3, 1, 0, 0, 0, 0, 3, ''), -- Ancient Bonethrall +(@CGUID+174, 0, 0, 3, 1, 0, 0, 0, 0, 3, ''), -- Ancient Bonethrall +(@CGUID+162, 0, 0, 3, 1, 0, 0, 0, 0, 3, ''), -- Ancient Bonethrall +(@CGUID+225, 0, 0, 8, 1, 0, 0, 0, 0, 3, ''), -- Kvaldir Reefcaller +(@CGUID+227, 0, 0, 8, 1, 0, 0, 0, 0, 3, ''), -- Kvaldir Reefcaller +(@CGUID+223, 0, 0, 3, 1, 0, 0, 0, 0, 3, ''), -- Ancient Bonethrall +(@CGUID+334, 0, 0, 3, 1, 0, 0, 0, 0, 3, ''), -- Ancient Bonethrall +(@CGUID+333, 0, 0, 3, 1, 0, 0, 0, 0, 3, ''), -- Helhound +(@CGUID+331, 0, 0, 3, 1, 0, 0, 0, 0, 3, ''), -- Helhound +(@CGUID+339, 0, 0, 3, 1, 0, 0, 0, 0, 3, ''), -- Helhound +(@CGUID+226, 0, 0, 3, 1, 0, 0, 0, 0, 3, ''), -- Helhound +(@CGUID+338, 0, 0, 8, 1, 0, 0, 0, 0, 3, ''), -- Kvaldir Reefcaller +(@CGUID+221, 0, 0, 3, 1, 0, 0, 0, 0, 3, ''), -- Helhound +(@CGUID+228, 0, 0, 3, 1, 0, 0, 0, 0, 3, ''), -- Helhound +(@CGUID+330, 0, 0, 8, 1, 0, 0, 0, 0, 3, '228317'), -- Kvaldir Spiritrender - 228317 - Near Brazier +(@CGUID+353, 0, 0, 8, 1, 0, 0, 0, 0, 3, '228317'), -- Kvaldir Spiritrender - 228317 - Near Brazier +(@CGUID+348, 0, 0, 8, 1, 0, 0, 0, 0, 3, '228317'), -- Kvaldir Spiritrender - 228317 - Near Brazier +(@CGUID+346, 0, 0, 3, 1, 0, 0, 0, 0, 3, ''), -- Ancient Bonethrall +(@CGUID+349, 0, 0, 3, 1, 0, 0, 0, 0, 3, ''), -- Ancient Bonethrall +(@CGUID+357, 0, 0, 33554432, 1, 333, 0, 0, 0, 0, ''), -- Dark Seraph +(@CGUID+363, 0, 0, 33554432, 1, 333, 0, 0, 0, 0, ''), -- Dark Seraph +(@CGUID+367, 0, 0, 33554432, 1, 333, 0, 0, 0, 0, ''), -- Dark Seraph +(@CGUID+373, 0, 0, 33554432, 1, 0, 0, 0, 0, 0, ''), -- Dark Seraph +(@CGUID+369, 0, 0, 0, 1, 333, 0, 0, 0, 0, ''), -- Kvaldir Tide Witch +(@CGUID+365, 0, 0, 0, 1, 333, 0, 0, 0, 0, ''), -- Kvaldir Tide Witch +(@CGUID+378, 0, 0, 8, 1, 0, 0, 0, 0, 0, ''), -- Kvaldir Tide Witch +(@CGUID+377, 0, 0, 8, 1, 0, 0, 0, 0, 0, ''), -- Kvaldir Tide Witch +(@CGUID+354, 0, 0, 8, 1, 0, 0, 0, 0, 3, ''), -- Kvaldir Reefcaller +(@CGUID+343, 0, 0, 8, 1, 0, 0, 0, 0, 3, ''), -- Kvaldir Reefcaller +(@CGUID+359, 0, 0, 8, 1, 0, 0, 0, 0, 3, ''), -- Kvaldir Reefcaller +(@CGUID+371, 0, 0, 8, 1, 0, 0, 0, 0, 3, ''), -- Kvaldir Reefcaller +(@CGUID+355, 0, 0, 8, 1, 0, 0, 0, 0, 3, ''), -- Kvaldir Reefcaller +(@CGUID+351, 0, 0, 8, 1, 0, 0, 0, 0, 3, ''), -- Kvaldir Reefcaller +(@CGUID+368, 0, 0, 8, 1, 0, 0, 0, 0, 3, ''), -- Kvaldir Reefcaller +(@CGUID+370, 0, 0, 3, 1, 0, 0, 0, 0, 3, ''), -- Kvaldir Reefcaller +(@CGUID+375, 0, 0, 0, 1, 333, 0, 0, 0, 0, ''); -- Kvaldir Coral Maiden + +-- Creature Template addon +DELETE FROM `creature_template_addon` WHERE `entry` IN (114360 /*114360 (Hyrja) - Valarjar's Bond*/, 114361 /*114361 (Hymdall) - Valarjar's Bond, Valarjar's Bond*/, 114263 /*114263 (Odyn)*/, 114785 /*114785 (Valarjar Marksman) - Mod Scale 95-120%*/, 114789 /*114789 (Stormforged Sentinel)*/, 114784 /*114784 (Valarjar Champion) - Mod Scale 95-120%*/, 114787 /*114787 (Valarjar Runecarver) - Mod Scale 95-120%*/, 114786 /*114786 (Valarjar Mystic) - Mod Scale 95-120%*/, 114791 /*114791 (Chosen of Eyir)*/, 114788 /*114788 (Valarjar Thundercaller)*/, 114640 /*114640 (Helhound)*/, 114639 /*114639 (Kvaldir Reefcaller) - Near Brazier*/, 114614 /*114614 (Kvaldir Spiritrender) - Near Brazier*/, 114539 /*114539 (Kvaldir Reefcaller)*/, 114548 /*114548 (Rotsoul Giant)*/, 114538 /*114538 (Kvaldir Spiritrender)*/, 114547 /*114547 (Ancient Bonethrall)*/, 114532 /*114532 (Bonespeaker Soulbinder)*/, 109795 /*109795 (Neglected Bones) - Mod Scale 95-120%*/, 93094 /*93094 (Restless Ancestor) - Hover Anim Replacement, Weakened Spirit, Shadowy Ghost Visual, Bright*/, 114534 /*114534 (Helhound)*/, 114537 /*114537 (Helya)*/, 117784 /*117784 (Gripping Tentacle) - Helya*/, 117783 /*117783 (Gripping Tentacle) - Helya*/, 114343 /*114343 (Guarm) - Ride Vehicle Hardcoded*/, 114922 /*114922 (Dark Seraph)*/, 114932 /*114932 (Deepbrine Monstrosity) - Seaweed*/, 114344 /*114344 (Guarm) - Ride Vehicle Hardcoded*/, 114323 /*114323 (Guarm) - Multi-Headed*/, 116404 /*116404 (Guarm's Chew Toy) - Guarm's Favorite Bone*/, 114341 /*114341 (Guarm) - Ride Vehicle Hardcoded*/); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(114360, 0, 0, 0, 1, 0, 0, 0, 0, 4, '228018'), -- 114360 (Hyrja) - Valarjar's Bond +(114361, 0, 0, 0, 1, 0, 0, 0, 0, 4, '228016 228018'), -- 114361 (Hymdall) - Valarjar's Bond, Valarjar's Bond +(114263, 0, 0, 0, 1, 0, 0, 0, 0, 5, ''), -- 114263 (Odyn) +(114785, 0, 0, 0, 1, 0, 0, 0, 0, 3, '123978'), -- 114785 (Valarjar Marksman) - Mod Scale 95-120% +(114789, 0, 0, 0, 1, 0, 0, 0, 0, 4, ''), -- 114789 (Stormforged Sentinel) +(114784, 0, 0, 0, 1, 0, 0, 0, 0, 3, '123978'), -- 114784 (Valarjar Champion) - Mod Scale 95-120% +(114787, 0, 0, 0, 1, 0, 0, 0, 0, 3, '123978'), -- 114787 (Valarjar Runecarver) - Mod Scale 95-120% +(114786, 0, 0, 0, 1, 0, 0, 0, 0, 3, '191450'), -- 114786 (Valarjar Mystic) - Mod Scale 95-120% +(114791, 0, 0, 0, 1, 0, 0, 0, 0, 4, ''), -- 114791 (Chosen of Eyir) +(114788, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''), -- 114788 (Valarjar Thundercaller) +(114640, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''), -- 114640 (Helhound) +(114639, 0, 0, 0, 1, 0, 0, 0, 0, 3, '228317'), -- 114639 (Kvaldir Reefcaller) - Near Brazier +(114614, 0, 0, 0, 1, 0, 0, 0, 0, 3, '228317'), -- 114614 (Kvaldir Spiritrender) - Near Brazier +(114539, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''), -- 114539 (Kvaldir Reefcaller) +(114548, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''), -- 114548 (Rotsoul Giant) +(114538, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''), -- 114538 (Kvaldir Spiritrender) +(114547, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''), -- 114547 (Ancient Bonethrall) +(114532, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''), -- 114532 (Bonespeaker Soulbinder) +(109795, 0, 0, 0, 1, 0, 0, 0, 0, 0, '123978'), -- 109795 (Neglected Bones) - Mod Scale 95-120% +(93094, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, '184840 191995 221829'), -- 93094 (Restless Ancestor) - Hover Anim Replacement, Weakened Spirit, Shadowy Ghost Visual, Bright +(114534, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''), -- 114534 (Helhound) +(114537, 0, 0, 0, 1, 0, 0, 0, 0, 5, ''), -- 114537 (Helya) +(117784, 0, 0, 0, 1, 0, 0, 0, 0, 4, '234204'), -- 117784 (Gripping Tentacle) - Helya +(117783, 0, 0, 0, 1, 0, 0, 0, 0, 4, '234205'), -- 117783 (Gripping Tentacle) - Helya +(114343, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- 114343 (Guarm) - Ride Vehicle Hardcoded +(114922, 0, 0, 33554432, 1, 0, 0, 0, 0, 0, ''), -- 114922 (Dark Seraph) +(114932, 0, 0, 0, 1, 0, 0, 0, 0, 0, '217128'), -- 114932 (Deepbrine Monstrosity) - Seaweed +(114344, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- 114344 (Guarm) - Ride Vehicle Hardcoded +(114323, 0, 0, 0, 1, 0, 0, 0, 0, 3, '227512'), -- 114323 (Guarm) - Multi-Headed +(116404, 0, 0, 0, 1, 0, 0, 0, 0, 0, '232391'), -- 116404 (Guarm's Chew Toy) - Guarm's Favorite Bone +(114341, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''); -- 114341 (Guarm) - Ride Vehicle Hardcoded + +-- Creature Template data +UPDATE `creature_template` SET `minlevel`=47, `maxlevel`=47, `speed_walk`=4.800000190734863281, `speed_run`=1.714285731315612792, `BaseAttackTime`=1500, `unit_flags2`=4196352, `HoverHeight`=9 WHERE `entry`=114360; -- Hyrja +UPDATE `creature_template` SET `minlevel`=47, `maxlevel`=47, `speed_walk`=4.800000190734863281, `speed_run`=1.714285731315612792, `BaseAttackTime`=1500, `unit_flags2`=4196352 WHERE `entry`=114361; -- Hymdall +UPDATE `creature_template` SET `minlevel`=48, `maxlevel`=48, `speed_walk`=6, `speed_run`=2.142857074737548828, `BaseAttackTime`=1500, `unit_flags2`=1073741824 WHERE `entry`=114263; -- Odyn +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45, `speed_run`=1.428571462631225585, `BaseAttackTime`=1500, `unit_flags`=33088, `unit_flags2`=35653632 WHERE `entry`=114785; -- Valarjar Marksman +UPDATE `creature_template` SET `minlevel`=46, `maxlevel`=46, `speed_walk`=1.60000002384185791, `speed_run`=1.428571462631225585, `BaseAttackTime`=1500, `unit_flags`=33088, `unit_flags2`=4196352 WHERE `entry`=114789; -- Stormforged Sentinel +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45, `speed_run`=1.428571462631225585, `BaseAttackTime`=2000, `unit_flags`=33088, `unit_flags2`=2099200 WHERE `entry`=114784; -- Valarjar Champion +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45, `speed_run`=1.428571462631225585, `BaseAttackTime`=1500, `unit_flags`=33088, `unit_flags2`=2099200 WHERE `entry`=114787; -- Valarjar Runecarver +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45, `speed_run`=1.428571462631225585, `BaseAttackTime`=1500, `unit_flags`=33088, `unit_flags2`=2099200 WHERE `entry`=114786; -- Valarjar Mystic +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45, `speed_walk`=4, `speed_run`=1.428571462631225585, `BaseAttackTime`=1500, `unit_flags`=33088, `unit_flags2`=4196352, `HoverHeight`=6 WHERE `entry`=114791; -- Chosen of Eyir +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45, `speed_run`=1.428571462631225585, `BaseAttackTime`=1500, `unit_flags`=33088, `unit_flags2`=2099200 WHERE `entry`=114788; -- Valarjar Thundercaller +UPDATE `creature_template` SET `minlevel`=47, `maxlevel`=47, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2099200 WHERE `entry` IN (114640, 114534); -- Helhound +UPDATE `creature_template` SET `minlevel`=47, `maxlevel`=47, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2099200 WHERE `entry` IN (114639, 114539); -- Kvaldir Reefcaller +UPDATE `creature_template` SET `minlevel`=47, `maxlevel`=47, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2099200 WHERE `entry` IN (114614, 114538); -- Kvaldir Spiritrender +UPDATE `creature_template` SET `minlevel`=47, `maxlevel`=47, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=114546; -- Risen Bonethrall +UPDATE `creature_template` SET `minlevel`=47, `maxlevel`=47, `faction`=16, `speed_walk`=2, `speed_run`=1.428571462631225585, `BaseAttackTime`=1500, `unit_flags`=32768, `unit_flags2`=2099200 WHERE `entry`=114548; -- Rotsoul Giant +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45, `BaseAttackTime`=2000, `unit_flags`=33555200, `unit_flags2`=268437504, `unit_flags3`=16777216 WHERE `entry`=114672; -- Brazier Stalker +UPDATE `creature_template` SET `minlevel`=47, `maxlevel`=47, `faction`=16, `speed_walk`=1.20000004768371582, `speed_run`=1.428571462631225585, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2099200 WHERE `entry`=114547; -- Ancient Bonethrall +UPDATE `creature_template` SET `minlevel`=47, `maxlevel`=47, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2099200 WHERE `entry`=114532; -- Bonespeaker Soulbinder +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45, `unit_flags`=33587456, `unit_flags3`=1 WHERE `entry`=109795; -- Neglected Bones +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45, `unit_flags`=33587968, `unit_flags3`=1, `dynamicflags`=0 WHERE `entry`=93094; -- Restless Ancestor +UPDATE `creature_template` SET `minlevel`=47, `maxlevel`=47, `faction`=16, `BaseAttackTime`=1500, `unit_flags`=33600, `unit_flags2`=1073741824, `VehicleId`=5002 WHERE `entry`=114537; -- Helya +UPDATE `creature_template` SET `minlevel`=47, `maxlevel`=47, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048, `HoverHeight`=4.199999809265136718 WHERE `entry`=114813; -- Kvaldir Tide Witch +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=33816576, `unit_flags2`=4196352, `unit_flags3`=1 WHERE `entry` IN (117784, 117783); -- Gripping Tentacle +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45, `faction`=14, `speed_run`=0.571428596973419189, `BaseAttackTime`=1500, `unit_flags`=33587200, `unit_flags3`=16777217 WHERE `entry` IN (114343, 114344, 114341); -- Guarm +UPDATE `creature_template` SET `minlevel`=47, `maxlevel`=47, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048, `HoverHeight`=6 WHERE `entry`=114922; -- Dark Seraph +UPDATE `creature_template` SET `minlevel`=47, `maxlevel`=47, `faction`=14, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=114932; -- Deepbrine Monstrosity +UPDATE `creature_template` SET `minlevel`=48, `maxlevel`=48, `faction`=14, `speed_run`=2, `BaseAttackTime`=1500, `unit_flags`=32832, `unit_flags2`=2097152, `VehicleId`=4995 WHERE `entry`=114323; -- Guarm +UPDATE `creature_template` SET `minlevel`=48, `maxlevel`=48, `npcflag`=16777216, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags`=256, `unit_flags2`=526336, `unit_flags3`=16777216 WHERE `entry`=116404; -- Guarm's Chew Toy +UPDATE `creature_template` SET `minlevel`=47, `maxlevel`=47, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048, `HoverHeight`=4.5 WHERE `entry`=114811; -- Kvaldir Coral Maiden + +-- GameObject Template Addon data +DELETE FROM `gameobject_template_addon` WHERE `entry` IN (266914 /*Doodad_7vr_Vrykul_fence001*/, 266915 /*Doodad_7vr_Vrykul_fence002*/, 242454 /*Hellfire Gate*/, 266916 /*Doodad_7vr_Vrykul_fence003*/, 266917 /*Doodad_7vr_Vrykul_fence004*/, 266533 /*Guarm_Boss_Door02*/, 265596 /*Ritual Stone*/, 243404 /*Collision Wall*/, 266532 /*Guarm_Boss_Door01*/); +INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES +(266914, 1375, 16, 0, 0), -- Doodad_7vr_Vrykul_fence001 +(266915, 1375, 16, 0, 0), -- Doodad_7vr_Vrykul_fence002 +(242454, 0, 48, 0, 0), -- Hellfire Gate +(266916, 1375, 16, 0, 0), -- Doodad_7vr_Vrykul_fence003 +(266917, 1375, 16, 0, 0), -- Doodad_7vr_Vrykul_fence004 +(266533, 1375, 48, 0, 0), -- Guarm_Boss_Door02 +(265596, 0, 48, 0, 12054), -- Ritual Stone +(243404, 0, 8192, 0, 0), -- Collision Wall +(266532, 1375, 48, 0, 0); -- Guarm_Boss_Door01 + +-- Scaling +DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=14 AND `Entry` IN (114360,114361,114263,114785,114789,114784,114787,114786,114791,114788,114640)); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(114360, 14, 2, 2, 622, 45745), +(114361, 14, 2, 2, 622, 45745), +(114263, 14, 3, 3, 622, 45745), +(114785, 14, 0, 0, 622, 45745), +(114789, 14, 1, 1, 622, 45745), +(114784, 14, 0, 0, 622, 45745), +(114787, 14, 0, 0, 622, 45745), +(114786, 14, 0, 0, 622, 45745), +(114791, 14, 0, 0, 622, 45745), +(114788, 14, 0, 0, 622, 45745), +(114640, 14, 2, 2, 622, 45745); + +-- Vehicle +DELETE FROM `vehicle_template_accessory` WHERE `entry` = 114323; +INSERT INTO `vehicle_template_accessory` (`entry`, `accessory_entry`, `seat_id`, `minion`, `description`, `summontype`, `summontimer`) VALUES +(114323, 114343, 1, 0, 'Guarm - Guarm', 6, 3000000), -- Guarm - Guarm +(114323, 114341, 0, 0, 'Guarm - Guarm', 6, 3000000), -- Guarm - Guarm +(114323, 114344, 2, 0, 'Guarm - Guarm', 6, 3000000); -- Guarm - Guarm + +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` = 116404; +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES +(116404, 231846, 0, 0); + +-- Creature Movement +DELETE FROM `creature_template_movement` WHERE `CreatureId` = 114791; +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`, `InteractionPauseTimer`) VALUES +(114791, 0, 0, 1, 0, 0, 0, NULL); + +-- Waypoints for CGUID+183 +DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+183; +INSERT INTO `creature_formations`(`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@CGUID+183, @CGUID+183, 0, 0, 515, 0, 0), +(@CGUID+183, @CGUID+161, 4, 310, 515, 0, 0), +(@CGUID+183, @CGUID+173, 4, 60, 515, 0, 0); + +SET @PATH := (@CGUID+183) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 3485.76, 5662.651, 82.57409, NULL, 12213), +(@PATH, 1, 3486.754, 5669.905, 82.52381, NULL, 0), +(@PATH, 2, 3487.97, 5677.327, 82.32813, NULL, 0), +(@PATH, 3, 3487.072, 5688.299, 82.56202, NULL, 0), +(@PATH, 4, 3482.465, 5697.556, 84.79453, NULL, 0), +(@PATH, 5, 3477.644, 5706.443, 84.32499, NULL, 0), +(@PATH, 6, 3473.364, 5712.713, 84.32499, NULL, 0), +(@PATH, 7, 3470.023, 5719.099, 84.2902, NULL, 0), +(@PATH, 8, 3463.691, 5721.213, 84.21239, NULL, 0), +(@PATH, 9, 3458.306, 5717.249, 84.39586, NULL, 12489), +(@PATH, 10, 3463.691, 5721.213, 84.21239, NULL, 0), +(@PATH, 11, 3470.023, 5719.099, 84.2902, NULL, 0), +(@PATH, 12, 3473.364, 5712.713, 84.32499, NULL, 0), +(@PATH, 13, 3477.644, 5706.443, 84.32499, NULL, 0), +(@PATH, 14, 3482.465, 5697.556, 84.79453, NULL, 0), +(@PATH, 15, 3487.072, 5688.299, 82.56202, NULL, 0), +(@PATH, 16, 3487.97, 5677.327, 82.32813, NULL, 0), +(@PATH, 17, 3486.754, 5669.905, 82.52381, NULL, 0); + +UPDATE `creature` SET `position_x`= 3485.76, `position_y`= 5662.651, `position_z`= 82.57409, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+183; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+183; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+183, @PATH, 1); + +-- Waypoints for CGUID+186 +DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+186; +INSERT INTO `creature_formations`(`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@CGUID+186, @CGUID+186, 0, 0, 515, 0, 0), +(@CGUID+186, @CGUID+184, 4, 310, 515, 0, 0), +(@CGUID+186, @CGUID+181, 4, 60, 515, 0, 0); + +SET @PATH := (@CGUID+186) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 3520.368, 5745.231, 95.94474, NULL, 0), +(@PATH, 1, 3528.133, 5738.238, 95.63126, NULL, 0), +(@PATH, 2, 3541.915, 5730.325, 95.88823, NULL, 0), +(@PATH, 3, 3550.484, 5722.228, 95.82048, NULL, 0), +(@PATH, 4, 3558.906, 5718.048, 95.94878, NULL, 0), +(@PATH, 5, 3564.966, 5711.732, 96.29594, NULL, 12717), +(@PATH, 6, 3558.906, 5718.048, 95.94878, NULL, 0), +(@PATH, 7, 3550.484, 5722.228, 95.82048, NULL, 0), +(@PATH, 8, 3541.915, 5730.325, 95.88823, NULL, 0), +(@PATH, 9, 3528.133, 5738.238, 95.63126, NULL, 0), +(@PATH, 10, 3520.368, 5745.231, 95.94474, NULL, 0), +(@PATH, 11, 3510.983, 5760.134, 96.0983, NULL, 0), +(@PATH, 12, 3492.197, 5775.397, 95.84507, NULL, 0), +(@PATH, 13, 3474.484, 5788.241, 95.47056, NULL, 12715), +(@PATH, 14, 3492.197, 5775.397, 95.84507, NULL, 0), +(@PATH, 15, 3510.983, 5760.134, 96.0983, NULL, 0); + +UPDATE `creature` SET `position_x`= 3520.368, `position_y`= 5745.231, `position_z`= 95.94474, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+186; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+186; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+186, @PATH, 1); + +-- Waypoints for CGUID+198 +DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+198; +INSERT INTO `creature_formations`(`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@CGUID+198, @CGUID+198, 0, 0, 515, 0, 0), +(@CGUID+198, @CGUID+169, 4, 310, 515, 0, 0), +(@CGUID+198, @CGUID+167, 4, 60, 515, 0, 0); + +SET @PATH := (@CGUID+198) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 3525.036, 5665.215, 87.09477, NULL, 0), +(@PATH, 1, 3513.548, 5653.819, 76.38228, NULL, 0), +(@PATH, 2, 3509.349, 5649.655, 76.70747, NULL, 0), +(@PATH, 3, 3506.351, 5637.521, 76.37068, NULL, 0), +(@PATH, 4, 3511.17, 5627.677, 76.91294, NULL, 0), +(@PATH, 5, 3517.104, 5620.052, 77.08787, NULL, 0), +(@PATH, 6, 3525.669, 5610.364, 77.26121, NULL, 0), +(@PATH, 7, 3531.34, 5600.186, 76.38488, NULL, 0), +(@PATH, 8, 3535.054, 5584.25, 67.88745, NULL, 0), +(@PATH, 9, 3540.313, 5572.823, 62.64262, NULL, 0), +(@PATH, 10, 3550.725, 5559.653, 56.09074, NULL, 0), +(@PATH, 11, 3563.499, 5554.38, 49.78151, NULL, 0), +(@PATH, 12, 3580.184, 5550.561, 42.43045, NULL, 0), +(@PATH, 13, 3592.2, 5550.689, 41.60512, NULL, 13086), +(@PATH, 14, 3580.184, 5550.561, 42.43045, NULL, 0), +(@PATH, 15, 3563.499, 5554.38, 49.78151, NULL, 0), +(@PATH, 16, 3550.725, 5559.653, 56.09074, NULL, 0), +(@PATH, 17, 3540.313, 5572.823, 62.64262, NULL, 0), +(@PATH, 18, 3535.054, 5584.25, 67.88745, NULL, 0), +(@PATH, 19, 3531.34, 5600.186, 76.38488, NULL, 0), +(@PATH, 20, 3525.669, 5610.364, 77.26121, NULL, 0), +(@PATH, 21, 3517.104, 5620.052, 77.08787, NULL, 0), +(@PATH, 22, 3511.17, 5627.677, 76.91294, NULL, 0), +(@PATH, 23, 3506.351, 5637.521, 76.37068, NULL, 0), +(@PATH, 24, 3509.349, 5649.655, 76.70747, NULL, 0), +(@PATH, 25, 3513.437, 5653.748, 76.29062, NULL, 0), +(@PATH, 26, 3524.994, 5665.174, 87.08397, NULL, 0), +(@PATH, 27, 3534.714, 5676.743, 92.44234, NULL, 0), +(@PATH, 28, 3546.879, 5691.166, 95.80746, NULL, 0), +(@PATH, 29, 3555.453, 5702.166, 95.492, NULL, 12346), +(@PATH, 30, 3546.879, 5691.166, 95.80746, NULL, 0), +(@PATH, 31, 3534.714, 5676.743, 92.44234, NULL, 0); + +UPDATE `creature` SET `position_x`= 3525.036, `position_y`= 5665.215, `position_z`= 87.09477, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+198; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+198; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+198, @PATH, 1); + +-- Waypoints for CGUID+347 +SET @PATH := (@CGUID+347) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 488.9375, 370.125, 1.866717, NULL, 0), +(@PATH, 1, 486.6701, 380.6806, 1.616717, NULL, 0), +(@PATH, 2, 480.5052, 394.4983, 1.491717, NULL, 6520), +(@PATH, 3, 486.6701, 380.6806, 1.616717, NULL, 0), +(@PATH, 4, 488.9375, 370.125, 1.866717, NULL, 0), +(@PATH, 5, 493.2951, 359.7535, 2.419406, NULL, 0), +(@PATH, 6, 495.0365, 351.0938, 2.652317, NULL, 0), +(@PATH, 7, 494.6806, 341.1858, 2.527317, NULL, 0), +(@PATH, 8, 490.3056, 333.5399, 2.527317, NULL, 0), +(@PATH, 9, 485.316, 329.0625, 2.585166, NULL, 0), +(@PATH, 10, 476.559, 324.184, 2.585166, NULL, 0), +(@PATH, 11, 470.0538, 324.1667, 2.585166, NULL, 0), +(@PATH, 12, 461.1337, 326.6858, 2.452724, NULL, 0), +(@PATH, 13, 448.533, 330.0642, 1.804286, NULL, 0), +(@PATH, 14, 437.2222, 330.5868, 1.429286, NULL, 0), +(@PATH, 15, 426.7274, 330.7708, 1.596109, NULL, 0), +(@PATH, 16, 419.2691, 332.1042, 2.491007, NULL, 0), +(@PATH, 17, 412.2383, 335.9316, 4.090636, NULL, 0), +(@PATH, 18, 407.9149, 341.0781, 5.570251, NULL, 8944), +(@PATH, 19, 419.2617, 332.1055, 2.490762, NULL, 0), +(@PATH, 20, 426.7274, 330.7708, 1.596109, NULL, 0), +(@PATH, 21, 437.2222, 330.5868, 1.429286, NULL, 0), +(@PATH, 22, 448.533, 330.0642, 1.804286, NULL, 0), +(@PATH, 23, 461.1337, 326.6858, 2.452724, NULL, 0), +(@PATH, 24, 470.0538, 324.1667, 2.585166, NULL, 0), +(@PATH, 25, 476.559, 324.184, 2.585166, NULL, 0), +(@PATH, 26, 485.316, 329.0625, 2.585166, NULL, 0), +(@PATH, 27, 490.3056, 333.5399, 2.527317, NULL, 0), +(@PATH, 28, 494.6806, 341.1858, 2.527317, NULL, 0), +(@PATH, 29, 495.0365, 351.0938, 2.652317, NULL, 0), +(@PATH, 30, 493.2951, 359.7535, 2.419406, NULL, 0); + +UPDATE `creature` SET `position_x`= 488.9375, `position_y`= 370.125, `position_z`= 1.866717, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+347; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+347; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`, `visibilityDistanceType`) VALUES +(@CGUID+347, @PATH, 1, 3); + +-- Waypoints for CGUID+350 +SET @PATH := (@CGUID+350) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 448.8472, 635.1059, 5.213478, NULL, 0), +(@PATH, 1, 455.3192, 635.609, 5.489793, NULL, 0), +(@PATH, 2, 460.0868, 637.9045, 5.408415, NULL, 0), +(@PATH, 3, 465.5035, 641.4757, 5.199173, NULL, 0), +(@PATH, 4, 468.4201, 644.9809, 5.213478, NULL, 10446), +(@PATH, 5, 465.5035, 641.4757, 5.199173, NULL, 0), +(@PATH, 6, 460.0868, 637.9045, 5.408415, NULL, 0), +(@PATH, 7, 455.4358, 635.618, 5.457537, NULL, 0), +(@PATH, 8, 448.8472, 635.1059, 5.213478, NULL, 0), +(@PATH, 9, 442.0417, 635.9202, 5.213478, NULL, 0), +(@PATH, 10, 437.1337, 638.1927, 5.350871, NULL, 0), +(@PATH, 11, 430.5311, 642.1442, 5.304961, NULL, 10247), +(@PATH, 12, 437.1337, 638.1927, 5.350871, NULL, 0), +(@PATH, 13, 442.0417, 635.9202, 5.213478, NULL, 0); + +UPDATE `creature` SET `position_x`= 448.8472, `position_y`= 635.1059, `position_z`= 5.213478, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+350; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+350; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`, `visibilityDistanceType`) VALUES +(@CGUID+350, @PATH, 1, 3); + +-- Waypoints for CGUID+352 +SET @PATH := (@CGUID+352) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 511.8958, 616.3577, 4.458658, NULL, 0), +(@PATH, 1, 520.8038, 618.132, 4.789623, NULL, 0), +(@PATH, 2, 531.2396, 616.2465, 6.689819, NULL, 0), +(@PATH, 3, 542.007, 622.9114, 8.478286, NULL, 0), +(@PATH, 4, 551.3351, 629.3976, 13.92295, NULL, 0), +(@PATH, 5, 555.1441, 637.9427, 18.05649, NULL, 0), +(@PATH, 6, 567.9028, 656.0174, 18.2062, NULL, 6060), +(@PATH, 7, 555.1441, 637.9427, 18.05649, NULL, 0), +(@PATH, 8, 551.3351, 629.3976, 13.92295, NULL, 0), +(@PATH, 9, 542.007, 622.9114, 8.478286, NULL, 0), +(@PATH, 10, 531.2396, 616.2465, 6.689819, NULL, 0), +(@PATH, 11, 520.8038, 618.132, 4.789623, NULL, 0), +(@PATH, 12, 511.8958, 616.3577, 4.458658, NULL, 0), +(@PATH, 13, 499.7049, 618.4254, 2.213478, NULL, 0), +(@PATH, 14, 490.0469, 622.4496, 2.213478, NULL, 0), +(@PATH, 15, 482.6667, 626.5087, 2.213478, NULL, 6930), +(@PATH, 16, 499.7049, 618.4254, 2.213478, NULL, 0); + +UPDATE `creature` SET `position_x`= 511.8958, `position_y`= 616.3577, `position_z`= 4.458658, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+352; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+352; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`, `visibilityDistanceType`) VALUES +(@CGUID+352, @PATH, 1, 3); + +-- Waypoints for CGUID+374 +SET @PATH := (@CGUID+374) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 458.9323, 702.4583, 18.01036, NULL, 0), +(@PATH, 1, 462.8854, 702.7153, 18.01036, NULL, 0), +(@PATH, 2, 466.2621, 703.6337, 18.02884, NULL, 0), +(@PATH, 3, 468.9549, 705.5972, 18.0649, NULL, 0), +(@PATH, 4, 471.5208, 708.0764, 18.0633, NULL, 5720), +(@PATH, 5, 466.2621, 703.6337, 18.02884, NULL, 0), +(@PATH, 6, 462.8854, 702.7153, 18.01036, NULL, 0), +(@PATH, 7, 458.9323, 702.4583, 18.01036, NULL, 0), +(@PATH, 8, 454.2882, 702.1337, 18.01035, NULL, 5725); + +UPDATE `creature` SET `position_x`= 458.9323, `position_y`= 702.4583, `position_z`= 18.01036, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+374; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+374; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`, `visibilityDistanceType`) VALUES +(@CGUID+374, @PATH, 1, 3); + +-- Waypoints for CGUID+35 +SET @PATH := (@CGUID+35) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 3292.543, 553.1406, 635.0531, NULL, 0), +(@PATH, 1, 3299.781, 561.3246, 635.0531, NULL, 0), +(@PATH, 2, 3295.169, 588.0833, 635.0532, NULL, 0), +(@PATH, 3, 3274.527, 609.9271, 635.0531, NULL, 0), +(@PATH, 4, 3295.141, 588.113, 635.0531, NULL, 0), +(@PATH, 5, 3299.781, 561.3246, 635.0531, NULL, 0), +(@PATH, 6, 3292.543, 553.1406, 635.0531, NULL, 0), +(@PATH, 7, 3276.578, 541.5504, 635.0531, NULL, 0), +(@PATH, 8, 3276.173, 519.6337, 635.053, NULL, 0), +(@PATH, 9, 3290.415, 508.3715, 635.0531, NULL, 0), +(@PATH, 10, 3298.574, 498.0573, 635.0531, NULL, 0), +(@PATH, 11, 3293.214, 468.4931, 635.0531, NULL, 0), +(@PATH, 12, 3274.589, 450.1945, 635.0531, NULL, 0), +(@PATH, 13, 3293.214, 468.4931, 635.0531, NULL, 0), +(@PATH, 14, 3298.574, 498.0573, 635.0531, NULL, 0), +(@PATH, 15, 3290.415, 508.3715, 635.0531, NULL, 0), +(@PATH, 16, 3276.173, 519.6337, 635.053, NULL, 0), +(@PATH, 17, 3276.578, 541.5504, 635.0531, NULL, 0); + +UPDATE `creature` SET `position_x`= 3292.543, `position_y`= 553.1406, `position_z`= 635.0531, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+35; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+35; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+35, @PATH, 1); + +-- Waypoints for CGUID+20 +SET @PATH := (@CGUID+20) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 3304.207, 507.5799, 635.0531, NULL, 0), +(@PATH, 1, 3299.065, 497.1389, 635.0531, NULL, 0), +(@PATH, 2, 3293.407, 467.9722, 635.0531, NULL, 0), +(@PATH, 3, 3274.532, 449.8299, 635.0531, NULL, 0), +(@PATH, 4, 3293.407, 467.9722, 635.0531, NULL, 0), +(@PATH, 5, 3299.065, 497.1389, 635.0531, NULL, 0), +(@PATH, 6, 3304.207, 507.5799, 635.0531, NULL, 0), +(@PATH, 7, 3320.059, 517.6702, 635.0531, NULL, 0), +(@PATH, 8, 3321.642, 537.3941, 635.053, NULL, 0), +(@PATH, 9, 3307.813, 550.5156, 635.0531, NULL, 0), +(@PATH, 10, 3300.22, 560.8264, 635.0531, NULL, 0), +(@PATH, 11, 3295.51, 587.6389, 635.0532, NULL, 0), +(@PATH, 12, 3275.682, 608.7257, 635.0531, NULL, 0), +(@PATH, 13, 3295.51, 587.6389, 635.0532, NULL, 0), +(@PATH, 14, 3300.22, 560.8264, 635.0531, NULL, 0), +(@PATH, 15, 3307.813, 550.5156, 635.0531, NULL, 0), +(@PATH, 16, 3321.642, 537.3941, 635.053, NULL, 0), +(@PATH, 17, 3320.059, 517.6702, 635.0531, NULL, 0); + +UPDATE `creature` SET `position_x`= 3304.207, `position_y`= 507.5799, `position_z`= 635.0531, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+20; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+20; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+20, @PATH, 1); |