diff options
| -rw-r--r-- | sql/updates/world/master/2022_06_08_02_world.sql | 682 |
1 files changed, 682 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_06_08_02_world.sql b/sql/updates/world/master/2022_06_08_02_world.sql new file mode 100644 index 00000000000..47ae722fc2e --- /dev/null +++ b/sql/updates/world/master/2022_06_08_02_world.sql @@ -0,0 +1,682 @@ +SET @CGUID := 395265; +SET @OGUID := 239544; + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+207; +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, 58876, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 835.85968017578125, 584.74627685546875, 12.81984329223632812, 4.709848403930664062, 7200, 0, 0, 2005, 0, 0, 0, 0, 0, 43345), -- Starving Hound (Area: Scarlet Halls - Difficulty: 1) (possible waypoints or random movement) +(@CGUID+1, 58876, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 849.063720703125, 523.68621826171875, 13.48109912872314453, 4.719628810882568359, 7200, 0, 0, 2005, 0, 0, 0, 0, 0, 43345), -- Starving Hound (Area: Scarlet Halls - Difficulty: 1) (Auras: 111837 - Pack Instincts, 111838 - Pack Member) +(@CGUID+2, 58701, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 868.28472900390625, 566.11114501953125, 13.57187557220458984, 4.421063423156738281, 7200, 0, 0, 1604, 0, 0, 0, 0, 0, 43345), -- Stake (Area: Scarlet Halls - Difficulty: 1) (Auras: 111703 - Stake Checker) +(@CGUID+3, 58876, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 885.4141845703125, 561.33538818359375, 13.48333740234375, 3.140685319900512695, 7200, 0, 0, 2005, 0, 0, 0, 0, 0, 43345), -- Starving Hound (Area: Scarlet Halls - Difficulty: 1) (Auras: 111837 - Pack Instincts, 111838 - Pack Member) +(@CGUID+4, 58701, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 831.65625, 557.26214599609375, 12.89547920227050781, 1.535889744758605957, 7200, 0, 0, 1604, 0, 0, 0, 0, 0, 43345), -- Stake (Area: Scarlet Halls - Difficulty: 1) (Auras: 111703 - Stake Checker) +(@CGUID+5, 58876, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 834.44903564453125, 586.15582275390625, 12.82125568389892578, 4.709840774536132812, 7200, 0, 0, 2005, 0, 0, 0, 0, 0, 43345), -- Starving Hound (Area: Scarlet Halls - Difficulty: 1) (possible waypoints or random movement) +(@CGUID+6, 58674, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 833.92315673828125, 556.49456787109375, 12.81158351898193359, 3.43626713752746582, 7200, 3, 0, 5034, 100, 1, 0, 0, 0, 43345), -- Angry Hound (Area: Scarlet Halls - Difficulty: 1) (Auras: 72242 - Zero Energy + Zero Regen, 111641 - Chained, 111634 - Speedy, 111406 - Calming Down) +(@CGUID+7, 58674, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 864.38458251953125, 564.25054931640625, 13.4833383560180664, 2.538899660110473632, 7200, 3, 0, 5034, 100, 1, 0, 0, 0, 43345), -- Angry Hound (Area: Scarlet Halls - Difficulty: 1) (Auras: 72242 - Zero Energy + Zero Regen, 111641 - Chained, 111634 - Speedy) +(@CGUID+8, 58876, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 840.1058349609375, 586.14141845703125, 12.81749916076660156, 4.709854602813720703, 7200, 0, 0, 2005, 0, 0, 0, 0, 0, 43345), -- Starving Hound (Area: Scarlet Halls - Difficulty: 1) +(@CGUID+9, 58876, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 886.473876953125, 560.2738037109375, 13.48333740234375, 3.140685319900512695, 7200, 0, 0, 2005, 0, 0, 0, 0, 0, 43345), -- Starving Hound (Area: Scarlet Halls - Difficulty: 1) (Auras: 111837 - Pack Instincts, 111838 - Pack Member) +(@CGUID+10, 65379, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 834.14581298828125, 620.7274169921875, 12.89479827880859375, 2.903693437576293945, 7200, 0, 0, 1604, 0, 0, 0, 0, 0, 43345), -- Bucket of Meaty Dog Food (Area: Scarlet Halls - Difficulty: 1) (Auras: 128176 - Bucket of Meaty Dog Food, 113994 - Cosmetic - Loot Sparkles (2.00)) +(@CGUID+11, 58674, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 840.466552734375, 590.63641357421875, 12.81877803802490234, 4.802843093872070312, 7200, 3, 0, 5034, 100, 1, 0, 0, 0, 43345), -- Angry Hound (Area: Scarlet Halls - Difficulty: 1) (Auras: 72242 - Zero Energy + Zero Regen, 111641 - Chained, 111634 - Speedy, 111406 - Calming Down) +(@CGUID+12, 58898, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 884.14727783203125, 562.397216796875, 13.48333454132080078, 3.140691280364990234, 7200, 0, 0, 8390, 0, 0, 0, 0, 0, 43345), -- Vigilant Watchman (Area: Scarlet Halls - Difficulty: 1) +(@CGUID+13, 58876, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 886.47772216796875, 564.516357421875, 13.48334026336669921, 3.140666723251342773, 7200, 0, 0, 2005, 0, 0, 0, 0, 0, 43345), -- Starving Hound (Area: Scarlet Halls - Difficulty: 1) (Auras: 111837 - Pack Instincts, 111838 - Pack Member) +(@CGUID+14, 58876, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 838.68804931640625, 584.74005126953125, 12.81796646118164062, 4.709849834442138671, 7200, 0, 0, 2005, 0, 0, 0, 0, 0, 43345), -- Starving Hound (Area: Scarlet Halls - Difficulty: 1) (possible waypoints or random movement) +(@CGUID+15, 65379, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 833.0382080078125, 619.36981201171875, 12.89479827880859375, 5.731126785278320312, 7200, 0, 0, 1604, 0, 0, 0, 0, 0, 43345), -- Bucket of Meaty Dog Food (Area: Scarlet Halls - Difficulty: 1) (Auras: 128176 - Bucket of Meaty Dog Food, 113994 - Cosmetic - Loot Sparkles (2.00)) +(@CGUID+16, 58701, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 842.8524169921875, 589.66143798828125, 12.89799785614013671, 0.461178541183471679, 7200, 0, 0, 1604, 0, 0, 0, 0, 0, 43345), -- Stake (Area: Scarlet Halls - Difficulty: 1) (Auras: 111703 - Stake Checker) +(@CGUID+17, 58898, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 837.27032470703125, 583.3477783203125, 12.8187103271484375, 4.709844589233398437, 7200, 0, 0, 8390, 0, 0, 0, 0, 0, 43345), -- Vigilant Watchman (Area: Scarlet Halls - Difficulty: 1) (possible waypoints or random movement) +(@CGUID+18, 58876, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 885.41650390625, 563.45672607421875, 13.48333930969238281, 3.140685558319091796, 7200, 0, 0, 2005, 0, 0, 0, 0, 0, 43345), -- Starving Hound (Area: Scarlet Halls - Difficulty: 1) (Auras: 111837 - Pack Instincts, 111838 - Pack Member) +(@CGUID+19, 65379, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 833.513916015625, 620.13543701171875, 12.89479827880859375, 1.472524642944335937, 7200, 0, 0, 1604, 0, 0, 0, 0, 0, 43345), -- Bucket of Meaty Dog Food (Area: Scarlet Halls - Difficulty: 1) (Auras: 128176 - Bucket of Meaty Dog Food, 113994 - Cosmetic - Loot Sparkles (2.00)) +(@CGUID+20, 60908, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 872.2569580078125, 549.40277099609375, 13.21958732604980468, 6.069111824035644531, 7200, 0, 0, 160400, 0, 0, 0, 0, 0, 43345), -- Archery Target Base (Area: Scarlet Halls - Difficulty: 1) +(@CGUID+21, 58876, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 853.3062744140625, 523.71722412109375, 13.48110389709472656, 4.719624042510986328, 7200, 0, 0, 2005, 0, 0, 0, 0, 0, 43345), -- Starving Hound (Area: Scarlet Halls - Difficulty: 1) (Auras: 111837 - Pack Instincts, 111838 - Pack Member) +(@CGUID+22, 58876, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 850.13214111328125, 522.63812255859375, 13.4810953140258789, 4.719662189483642578, 7200, 0, 0, 2005, 0, 0, 0, 0, 0, 43345), -- Starving Hound (Area: Scarlet Halls - Difficulty: 1) (Auras: 111837 - Pack Instincts, 111838 - Pack Member) +(@CGUID+23, 60908, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 864.9913330078125, 537.94964599609375, 13.003326416015625, 6.202894210815429687, 7200, 0, 0, 160400, 0, 0, 0, 0, 0, 43345), -- Archery Target Base (Area: Scarlet Halls - Difficulty: 1) +(@CGUID+24, 58876, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 852.25335693359375, 522.64813232421875, 13.48109912872314453, 4.71966552734375, 7200, 0, 0, 2005, 0, 0, 0, 0, 0, 43345), -- Starving Hound (Area: Scarlet Halls - Difficulty: 1) (Auras: 111837 - Pack Instincts, 111838 - Pack Member) +(@CGUID+25, 54030, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 901.09552001953125, 539.609375, 12.98916912078857421, 0, 7200, 0, 0, 118, 0, 0, 0, 0, 0, 43345), -- Invisible Stalker (Area: Scarlet Halls - Difficulty: 1) +(@CGUID+26, 58898, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 851.20013427734375, 521.57598876953125, 13.48108959197998046, 4.719811916351318359, 7200, 0, 0, 8390, 0, 0, 0, 0, 0, 43345), -- Vigilant Watchman (Area: Scarlet Halls - Difficulty: 1) +(@CGUID+27, 60908, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 873.30206298828125, 532.1944580078125, 13.07185554504394531, 0.282533168792724609, 7200, 0, 0, 160400, 0, 0, 0, 0, 0, 43345), -- Archery Target Base (Area: Scarlet Halls - Difficulty: 1) +(@CGUID+28, 58876, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 900.28448486328125, 519.32769775390625, 13.48110198974609375, 3.143206119537353515, 7200, 0, 0, 2005, 0, 0, 0, 0, 0, 43345), -- Starving Hound (Area: Scarlet Halls - Difficulty: 1) (Auras: 111837 - Pack Instincts, 111838 - Pack Member) (possible waypoints or random movement) +(@CGUID+29, 58876, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 901.34686279296875, 518.26873779296875, 13.48110198974609375, 3.14320683479309082, 7200, 0, 0, 2005, 0, 0, 0, 0, 0, 43345), -- Starving Hound (Area: Scarlet Halls - Difficulty: 1) (Auras: 111837 - Pack Instincts, 111838 - Pack Member) (possible waypoints or random movement) +(@CGUID+30, 58876, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 909.77947998046875, 515.100341796875, 13.48110294342041015, 0.001615163404494524, 7200, 0, 0, 2005, 0, 0, 0, 0, 0, 43345), -- Starving Hound (Area: Scarlet Halls - Difficulty: 1) (Auras: 111837 - Pack Instincts, 111838 - Pack Member) (possible waypoints or random movement) +(@CGUID+31, 58876, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 910.9654541015625, 516.16290283203125, 13.48110389709472656, 0.001618016278371214, 7200, 0, 0, 2005, 0, 0, 0, 0, 0, 43345), -- Starving Hound (Area: Scarlet Halls - Difficulty: 1) (Auras: 111837 - Pack Instincts, 111838 - Pack Member) (possible waypoints or random movement) +(@CGUID+32, 58898, 1001, 6052, 6052, '1,2', '0', 0, 0, 0, 921.62451171875, 517.24078369140625, 13.48110389709472656, 0.001614950015209615, 7200, 0, 0, 8390, 0, 0, 0, 0, 0, 43345), -- Vigilant Watchman (Area: Scarlet Halls - Difficulty: 1) (possible waypoints or random movement) +(@CGUID+33, 59175, 1001, 6052, 6052, '1,2', '0', 0, 0, 1, 935.26214599609375, 535.51910400390625, 12.99773502349853515, 3.13011336326599121, 7200, 0, 0, 802, 0, 0, 0, 0, 0, 43345), -- Master Archer (Area: Scarlet Halls - Difficulty: 1) (Auras: 113845 - Perfect Shot) +(@CGUID+34, 59175, 1001, 6052, 6052, '1,2', '0', 0, 0, 1, 935.25347900390625, 543.15277099609375, 13.03716373443603515, 3.108350038528442382, 7200, 0, 0, 802, 0, 0, 0, 0, 0, 43345), -- Master Archer (Area: Scarlet Halls - Difficulty: 1) (Auras: 113845 - Perfect Shot) +(@CGUID+35, 59175, 1001, 6052, 6052, '1,2', '0', 0, 0, 1, 935.75347900390625, 545.04864501953125, 13.04882621765136718, 2.939230680465698242, 7200, 0, 0, 802, 0, 0, 0, 0, 0, 43345), -- Master Archer (Area: Scarlet Halls - Difficulty: 1) (Auras: 113845 - Perfect Shot) +(@CGUID+36, 59175, 1001, 6052, 6052, '1,2', '0', 0, 0, 1, 933.87847900390625, 541.75177001953125, 13.0326089859008789, 3.049272537231445312, 7200, 0, 0, 802, 0, 0, 0, 0, 0, 43345), -- Master Archer (Area: Scarlet Halls - Difficulty: 1) (Auras: 113845 - Perfect Shot) +(@CGUID+37, 59175, 1001, 6052, 6052, '1,2', '0', 0, 0, 1, 934.86285400390625, 537.32989501953125, 12.99441432952880859, 3.290455818176269531, 7200, 0, 0, 802, 0, 0, 0, 0, 0, 43345), -- Master Archer (Area: Scarlet Halls - Difficulty: 1) (Auras: 113845 - Perfect Shot) +(@CGUID+38, 59175, 1001, 6052, 6052, '1,2', '0', 0, 0, 1, 933.75, 538.81427001953125, 13.00293159484863281, 3.267296075820922851, 7200, 0, 0, 802, 0, 0, 0, 0, 0, 43345), -- Master Archer (Area: Scarlet Halls - Difficulty: 1) (Auras: 113845 - Perfect Shot) +(@CGUID+39, 59175, 1001, 6052, 6052, '1,2', '0', 0, 0, 1, 937.17706298828125, 546.36285400390625, 13.05854225158691406, 3.048897504806518554, 7200, 0, 0, 802, 0, 0, 0, 0, 0, 43345), -- Master Archer (Area: Scarlet Halls - Difficulty: 1) (Auras: 113845 - Perfect Shot) +(@CGUID+40, 59191, 1001, 6052, 6301, '1,2', '0', 0, 0, 1, 940.0625, 540.19964599609375, 13.01444149017333984, 3.11681675910949707, 7200, 0, 0, 13424, 0, 0, 0, 0, 0, 43345), -- Commander Lindon (Area: Training Grounds - Difficulty: 1) (Auras: 113847 - Slaughter the Weak) +(@CGUID+41, 59175, 1001, 6052, 6301, '1,2', '0', 0, 0, 1, 936.84375, 533.84893798828125, 13.04358768463134765, 3.228859186172485351, 7200, 0, 0, 802, 0, 0, 0, 0, 0, 43345), -- Master Archer (Area: Training Grounds - Difficulty: 1) (Auras: 113845 - Perfect Shot) +(@CGUID+42, 58674, 1001, 6052, 6301, '1,2', '0', 0, 0, 0, 950.9375, 562.32464599609375, 13.57187843322753906, 1.481395602226257324, 7200, 3, 0, 5034, 100, 1, 0, 0, 0, 43345), -- Angry Hound (Area: Training Grounds - Difficulty: 1) (Auras: 72242 - Zero Energy + Zero Regen, 111641 - Chained, 111634 - Speedy) +(@CGUID+43, 58701, 1001, 6052, 6301, '1,2', '0', 0, 0, 0, 953.37847900390625, 564.54339599609375, 13.57188034057617187, 3.809812545776367187, 7200, 0, 0, 1604, 0, 0, 0, 0, 0, 43345), -- Stake (Area: Training Grounds - Difficulty: 1) (Auras: 111703 - Stake Checker) +(@CGUID+44, 65379, 1001, 6052, 6301, '1,2', '0', 0, 0, 0, 954.0625, 532.232666015625, 13.57187747955322265, 3.141592741012573242, 7200, 0, 0, 1604, 0, 0, 0, 0, 0, 43345), -- Bucket of Meaty Dog Food (Area: Training Grounds - Difficulty: 1) (Auras: 128176 - Bucket of Meaty Dog Food, 113994 - Cosmetic - Loot Sparkles (2.00)) +(@CGUID+45, 65379, 1001, 6052, 6301, '1,2', '0', 0, 0, 0, 954.185791015625, 531.38714599609375, 13.57187366485595703, 0.366519153118133544, 7200, 0, 0, 1604, 0, 0, 0, 0, 0, 43345), -- Bucket of Meaty Dog Food (Area: Training Grounds - Difficulty: 1) (Auras: 128176 - Bucket of Meaty Dog Food, 113994 - Cosmetic - Loot Sparkles (2.00)) +(@CGUID+46, 58674, 1001, 6052, 6301, '1,2', '0', 0, 0, 0, 950.75347900390625, 517.24481201171875, 13.57187747955322265, 0.419521659612655639, 7200, 3, 0, 5034, 100, 1, 0, 0, 0, 43345), -- Angry Hound (Area: Training Grounds - Difficulty: 1) (Auras: 72242 - Zero Energy + Zero Regen, 111641 - Chained, 111634 - Speedy) +(@CGUID+47, 65379, 1001, 6052, 6301, '1,2', '0', 0, 0, 0, 954.79864501953125, 530.64239501953125, 13.57187366485595703, 2.635447263717651367, 7200, 0, 0, 1604, 0, 0, 0, 0, 0, 43345), -- Bucket of Meaty Dog Food (Area: Training Grounds - Difficulty: 1) (Auras: 128176 - Bucket of Meaty Dog Food, 113994 - Cosmetic - Loot Sparkles (2.00)) +(@CGUID+48, 58701, 1001, 6052, 6301, '1,2', '0', 0, 0, 0, 953.36114501953125, 515.02606201171875, 13.57187843322753906, 2.350283145904541015, 7200, 0, 0, 1604, 0, 0, 0, 0, 0, 43345), -- Stake (Area: Training Grounds - Difficulty: 1) (Auras: 111703 - Stake Checker) +(@CGUID+49, 58876, 1001, 6052, 6301, '1,2', '0', 0, 0, 0, 985.6600341796875, 510.276885986328125, 13.48244285583496093, 1.571924924850463867, 7200, 0, 0, 2005, 0, 0, 0, 0, 0, 43345), -- Starving Hound (Area: Training Grounds - Difficulty: 1) (Auras: 111837 - Pack Instincts, 111838 - Pack Member) +(@CGUID+50, 58876, 1001, 6052, 6301, '1,2', '0', 0, 0, 0, 984.6005859375, 509.21502685546875, 13.4809427261352539, 1.571928381919860839, 7200, 0, 0, 2005, 0, 0, 0, 0, 0, 43345), -- Starving Hound (Area: Training Grounds - Difficulty: 1) (Auras: 111837 - Pack Instincts, 111838 - Pack Member) +(@CGUID+51, 58898, 1001, 6052, 6301, '1,2', '0', 0, 0, 0, 986.71502685546875, 515.28033447265625, 13.4810638427734375, 1.571923136711120605, 7200, 0, 0, 8390, 0, 0, 0, 0, 0, 43345), -- Vigilant Watchman (Area: Training Grounds - Difficulty: 1) +(@CGUID+52, 58876, 1001, 6052, 6301, '1,2', '0', 0, 0, 0, 988.83978271484375, 512.24786376953125, 13.48213005065917968, 1.571919441223144531, 7200, 0, 0, 2005, 0, 0, 0, 0, 0, 43345), -- Starving Hound (Area: Training Grounds - Difficulty: 1) (Auras: 111837 - Pack Instincts, 111838 - Pack Member) +(@CGUID+53, 58876, 1001, 6052, 6301, '1,2', '0', 0, 0, 0, 987.77789306640625, 513.30615234375, 13.48198509216308593, 1.571922540664672851, 7200, 0, 0, 2005, 0, 0, 0, 0, 0, 43345), -- Starving Hound (Area: Training Grounds - Difficulty: 1) (Auras: 111837 - Pack Instincts, 111838 - Pack Member) +(@CGUID+54, 58701, 1001, 6052, 6301, '1,2', '0', 0, 0, 0, 984.921875, 488.989593505859375, 13.57186031341552734, 0.591135561466217041, 7200, 0, 0, 1604, 0, 0, 0, 0, 0, 43345), -- Stake (Area: Training Grounds - Difficulty: 1) (Auras: 111703 - Stake Checker) +(@CGUID+55, 59303, 1001, 6052, 6301, '1,2', '0', 0, 0, 1, 1009.55731201171875, 513.6875, 12.98916244506835937, 2.369224786758422851, 7200, 0, 0, 43825, 0, 0, 0, 0, 0, 43345), -- Houndmaster Braun (Area: Training Grounds - Difficulty: 1) (Auras: 114027 - Houndmaster Controller Aura) +(@CGUID+56, 58674, 1001, 6052, 6301, '1,2', '0', 0, 0, 0, 986.66839599609375, 490.532989501953125, 13.57186222076416015, 5.518087387084960937, 7200, 3, 0, 5034, 100, 1, 0, 0, 0, 43345), -- Angry Hound (Area: Training Grounds - Difficulty: 1) (Auras: 72242 - Zero Energy + Zero Regen, 111641 - Chained, 111634 - Speedy) +(@CGUID+57, 59309, 1001, 6052, 6301, '1,2', '0', 0, 0, 0, 1003.859375, 495.859375, 13.57186126708984375, 1.412733435630798339, 7200, 0, 0, 2098, 0, 0, 0, 0, 0, 43345), -- Obedient Hound (Area: Training Grounds - Difficulty: 1) (Auras: 130286 - Purge All Debuffs) +(@CGUID+58, 59309, 1001, 6052, 6301, '1,2', '0', 0, 0, 0, 1006.86627197265625, 495.9288330078125, 13.57186126708984375, 1.434311389923095703, 7200, 0, 0, 2098, 0, 0, 0, 0, 0, 43345), -- Obedient Hound (Area: Training Grounds - Difficulty: 1) (Auras: 130286 - Purge All Debuffs) +(@CGUID+59, 59309, 1001, 6052, 6301, '1,2', '0', 0, 0, 0, 1005.36627197265625, 497.185760498046875, 13.57184219360351562, 1.481205463409423828, 7200, 0, 0, 2098, 0, 0, 0, 0, 0, 43345), -- Obedient Hound (Area: Training Grounds - Difficulty: 1) (Auras: 130286 - Purge All Debuffs) +(@CGUID+60, 59309, 1001, 6052, 6301, '1,2', '0', 0, 0, 0, 1027.407958984375, 511.0225830078125, 13.57186031341552734, 3.037650585174560546, 7200, 0, 0, 2098, 0, 0, 0, 0, 0, 43345), -- Obedient Hound (Area: Training Grounds - Difficulty: 1) (Auras: 130286 - Purge All Debuffs) +(@CGUID+61, 58674, 1001, 6052, 6301, '1,2', '0', 0, 0, 0, 1031.90625, 536.45831298828125, 13.57186126708984375, 3.895525693893432617, 7200, 3, 0, 5034, 100, 1, 0, 0, 0, 43345), -- Angry Hound (Area: Training Grounds - Difficulty: 1) (Auras: 72242 - Zero Energy + Zero Regen, 111641 - Chained, 111634 - Speedy) +(@CGUID+62, 59299, 1001, 6052, 6301, '1,2', '0', 0, 0, 1, 1036.1771240234375, 510.7882080078125, 13.57189846038818359, 2.94766545295715332, 7200, 0, 0, 16780, 0, 0, 0, 0, 0, 43345), -- Scarlet Guardian (Area: Training Grounds - Difficulty: 1) (Auras: 127352 - Phalanx Defense) +(@CGUID+63, 59309, 1001, 6052, 6301, '1,2', '0', 0, 0, 0, 1027.342041015625, 508.005218505859375, 13.57184028625488281, 3.066401958465576171, 7200, 0, 0, 2098, 0, 0, 0, 0, 0, 43345), -- Obedient Hound (Area: Training Grounds - Difficulty: 1) (Auras: 130286 - Purge All Debuffs) +(@CGUID+64, 59299, 1001, 6052, 6301, '1,2', '0', 0, 0, 1, 1036.6285400390625, 511.770843505859375, 13.5719146728515625, 2.821597814559936523, 7200, 0, 0, 16780, 0, 0, 0, 0, 0, 43345), -- Scarlet Guardian (Area: Training Grounds - Difficulty: 1) (Auras: 127352 - Phalanx Defense) +(@CGUID+65, 59302, 1001, 6052, 6301, '1,2', '0', 0, 0, 1, 1036.032958984375, 509.630218505859375, 13.57294940948486328, 3.159045934677124023, 7200, 0, 0, 67120, 0, 0, 0, 0, 0, 43345), -- Sergeant Verdone (Area: Training Grounds - Difficulty: 1) (Auras: 127352 - Phalanx Defense) +(@CGUID+66, 59309, 1001, 6052, 6301, '1,2', '0', 0, 0, 0, 1026.0850830078125, 509.578125, 13.57186031341552734, 3.202285051345825195, 7200, 0, 0, 2098, 0, 0, 0, 0, 0, 43345), -- Obedient Hound (Area: Training Grounds - Difficulty: 1) (Auras: 130286 - Purge All Debuffs) +(@CGUID+67, 58701, 1001, 6052, 6301, '1,2', '0', 0, 0, 0, 1034.2864990234375, 538.342041015625, 13.57186031341552734, 3.818997144699096679, 7200, 0, 0, 1604, 0, 0, 0, 0, 0, 43345), -- Stake (Area: Training Grounds - Difficulty: 1) (Auras: 111703 - Stake Checker) +(@CGUID+68, 59299, 1001, 6052, 6301, '1,2', '0', 0, 0, 1, 1039.9617919921875, 511.671875, 12.79599571228027343, 2.920719623565673828, 7200, 0, 0, 16780, 0, 0, 0, 0, 0, 43345), -- Scarlet Guardian (Area: Training Grounds - Difficulty: 1) (Auras: 127352 - Phalanx Defense) +(@CGUID+69, 59299, 1001, 6052, 6301, '1,2', '0', 0, 0, 1, 1037.748291015625, 509.638885498046875, 13.56160163879394531, 3.159045934677124023, 7200, 0, 0, 16780, 0, 0, 0, 0, 0, 43345), -- Scarlet Guardian (Area: Training Grounds - Difficulty: 1) (Auras: 127352 - Phalanx Defense) +(@CGUID+70, 58701, 1001, 6052, 6301, '1,2', '0', 0, 0, 0, 1034.0208740234375, 488.90972900390625, 13.57186222076416015, 2.184990406036376953, 7200, 0, 0, 1604, 0, 0, 0, 0, 0, 43345), -- Stake (Area: Training Grounds - Difficulty: 1) (Auras: 111703 - Stake Checker) +(@CGUID+71, 59299, 1001, 6052, 6301, '1,2', '0', 0, 0, 1, 1038.2586669921875, 511.62152099609375, 13.50290870666503906, 2.814899444580078125, 7200, 0, 0, 16780, 0, 0, 0, 0, 0, 43345), -- Scarlet Guardian (Area: Training Grounds - Difficulty: 1) (Auras: 127352 - Phalanx Defense) +(@CGUID+72, 59299, 1001, 6052, 6301, '1,2', '0', 0, 0, 1, 1036.298583984375, 508.3975830078125, 13.57195758819580078, 3.465875625610351562, 7200, 0, 0, 16780, 0, 0, 0, 0, 0, 43345), -- Scarlet Guardian (Area: Training Grounds - Difficulty: 1) (Auras: 127352 - Phalanx Defense) +(@CGUID+73, 59299, 1001, 6052, 6301, '1,2', '0', 0, 0, 1, 1036.6041259765625, 507.279510498046875, 13.57190513610839843, 3.548868894577026367, 7200, 0, 0, 16780, 0, 0, 0, 0, 0, 43345), -- Scarlet Guardian (Area: Training Grounds - Difficulty: 1) (Auras: 127352 - Phalanx Defense) +(@CGUID+74, 58674, 1001, 6052, 6301, '1,2', '0', 0, 0, 0, 1032.1788330078125, 491.02777099609375, 13.57186222076416015, 1.058788895606994628, 7200, 3, 0, 5034, 100, 1, 0, 0, 0, 43345), -- Angry Hound (Area: Training Grounds - Difficulty: 1) (Auras: 72242 - Zero Energy + Zero Regen, 111641 - Chained, 111634 - Speedy) +(@CGUID+75, 59299, 1001, 6052, 6301, '1,2', '0', 0, 0, 1, 1039.592041015625, 509.673614501953125, 12.94993209838867187, 3.159045934677124023, 7200, 0, 0, 16780, 0, 0, 0, 0, 0, 43345), -- Scarlet Guardian (Area: Training Grounds - Difficulty: 1) (Auras: 127352 - Phalanx Defense) +(@CGUID+76, 59299, 1001, 6052, 6301, '1,2', '0', 0, 0, 1, 1038.26220703125, 507.94097900390625, 13.49287033081054687, 3.472372055053710937, 7200, 0, 0, 16780, 0, 0, 0, 0, 0, 43345), -- Scarlet Guardian (Area: Training Grounds - Difficulty: 1) (Auras: 127352 - Phalanx Defense) +(@CGUID+77, 59299, 1001, 6052, 6301, '1,2', '0', 0, 0, 1, 1040.0191650390625, 507.78472900390625, 12.77234172821044921, 3.405711174011230468, 7200, 0, 0, 16780, 0, 0, 0, 0, 0, 43345), -- Scarlet Guardian (Area: Training Grounds - Difficulty: 1) (Auras: 127352 - Phalanx Defense) +(@CGUID+78, 58684, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1071.701416015625, 486.40277099609375, 2.90463423728942871, 4.572762489318847656, 7200, 0, 0, 8020, 0, 0, 0, 0, 0, 43345), -- Scarlet Scourge Hewer (Area: 0 - Difficulty: 1) +(@CGUID+79, 58683, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1069.078125, 483.572906494140625, 2.904514789581298828, 0.314159274101257324, 7200, 0, 0, 8020, 0, 0, 0, 0, 0, 43345), -- Scarlet Myrmidon (Area: 0 - Difficulty: 1) (Auras: ) +(@CGUID+80, 58685, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1074.795166015625, 480.664947509765625, 2.90590071678161621, 2.30383467674255371, 7200, 0, 0, 6415, 2068, 0, 0, 0, 0, 43345), -- Scarlet Evangelist (Area: 0 - Difficulty: 1) +(@CGUID+81, 59309, 1001, 6052, 6302, '1,2', '0', 0, 0, 0, 1067.267333984375, 508.123260498046875, 2.9058837890625, 3.16055154800415039, 7200, 0, 0, 2098, 0, 0, 0, 0, 0, 43345), -- Obedient Hound (Area: Huntsman's Cloister - Difficulty: 1) (Auras: 130286 - Purge All Debuffs) +(@CGUID+82, 58685, 1001, 6052, 6302, '1,2', '0', 0, 0, 1, 1098.550048828125, 486.11114501953125, 2.834355354309082031, 1.560312986373901367, 7200, 0, 0, 6415, 2068, 0, 0, 0, 0, 43345), -- Scarlet Evangelist (Area: Huntsman's Cloister - Difficulty: 1) (possible waypoints or random movement) +(@CGUID+83, 59309, 1001, 6052, 6302, '1,2', '0', 0, 0, 0, 1067.267333984375, 511.133697509765625, 2.90558028221130371, 3.122888088226318359, 7200, 0, 0, 2098, 0, 0, 0, 0, 0, 43345), -- Obedient Hound (Area: Huntsman's Cloister - Difficulty: 1) (Auras: 130286 - Purge All Debuffs) +(@CGUID+84, 59309, 1001, 6052, 6302, '1,2', '0', 0, 0, 0, 999.15277099609375, 466.204864501953125, 12.98916244506835937, 0.955806076526641845, 7200, 0, 0, 2098, 0, 0, 0, 0, 0, 43345), -- Obedient Hound (Area: Huntsman's Cloister - Difficulty: 1) (Auras: 130286 - Purge All Debuffs) +(@CGUID+85, 59309, 1001, 6052, 6302, '1,2', '0', 0, 0, 0, 997.63714599609375, 467.098968505859375, 12.98916244506835937, 1.737045526504516601, 7200, 0, 0, 2098, 0, 0, 0, 0, 0, 43345), -- Obedient Hound (Area: Huntsman's Cloister - Difficulty: 1) (Auras: 130286 - Purge All Debuffs) +(@CGUID+86, 59309, 1001, 6052, 6302, '1,2', '0', 0, 0, 0, 1065.9791259765625, 509.664947509765625, 2.905510663986206054, 3.15450596809387207, 7200, 0, 0, 2098, 0, 0, 0, 0, 0, 43345), -- Obedient Hound (Area: Huntsman's Cloister - Difficulty: 1) (Auras: 130286 - Purge All Debuffs) +(@CGUID+87, 59309, 1001, 6052, 6302, '1,2', '0', 0, 0, 0, 996.32293701171875, 466.130218505859375, 12.98916244506835937, 1.513786911964416503, 7200, 0, 0, 2098, 0, 0, 0, 0, 0, 43345), -- Obedient Hound (Area: Huntsman's Cloister - Difficulty: 1) (Auras: 130286 - Purge All Debuffs) +(@CGUID+88, 58676, 1001, 6052, 6302, '1,2', '0', 0, 0, 1, 1099.2742919921875, 466.744781494140625, 2.906136274337768554, 0.209439516067504882, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Defender (Area: Huntsman's Cloister - Difficulty: 1) (Auras: 111323 - Heavy Armor, 111324 - Shield Barrier) +(@CGUID+89, 58683, 1001, 6052, 6302, '1,2', '0', 0, 0, 1, 1102.3680419921875, 467.45660400390625, 2.905280113220214843, 1.117010712623596191, 7200, 0, 0, 8020, 0, 0, 0, 0, 0, 43345), -- Scarlet Myrmidon (Area: Huntsman's Cloister - Difficulty: 1) +(@CGUID+90, 58684, 1001, 6052, 6302, '1,2', '0', 0, 0, 1, 1102.3680419921875, 461.0069580078125, 2.905280113220214843, 1.117010712623596191, 7200, 0, 0, 8020, 0, 0, 0, 0, 0, 43345), -- Scarlet Scourge Hewer (Area: Huntsman's Cloister - Difficulty: 1) +(@CGUID+91, 58632, 1001, 6052, 6302, '1,2', '0', 0, 0, 1, 1206.435791015625, 443.961822509765625, 1.071199655532836914, 3.141592741012573242, 7200, 0, 0, 52590, 0, 0, 0, 0, 0, 43345), -- Armsmaster Harlan (Area: Huntsman's Cloister - Difficulty: 1) +(@CGUID+92, 58756, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1121.91845703125, 467.826385498046875, 2.906081199645996093, 0.209439516067504882, 7200, 0, 0, 6415, 2068, 0, 0, 0, 0, 43345), -- Scarlet Evoker (Area: 0 - Difficulty: 1) +(@CGUID+93, 58685, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1125.01220703125, 462.088531494140625, 2.9055023193359375, 1.117010712623596191, 7200, 0, 0, 6415, 2068, 0, 0, 0, 0, 43345), -- Scarlet Evangelist (Area: 0 - Difficulty: 1) +(@CGUID+94, 58684, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1124.31103515625, 458.577850341796875, 2.752123832702636718, 1.569312453269958496, 7200, 0, 0, 8020, 0, 0, 0, 0, 0, 43345), -- Scarlet Scourge Hewer (Area: 0 - Difficulty: 1) +(@CGUID+95, 65546, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1152.2445068359375, 506.039581298828125, 13.4722146987915039, 0.750712931156158447, 7200, 0, 0, 11791, 100, 0, 0, 0, 0, 43345), -- Sekrit (Area: 0 - Difficulty: 1) (Auras: 125061 - Hide) +(@CGUID+96, 58676, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1163.3394775390625, 462.360870361328125, 12.81594467163085937, 1.56858062744140625, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Defender (Area: 0 - Difficulty: 1) (Auras: 111323 - Heavy Armor, 111324 - Shield Barrier) +(@CGUID+97, 58683, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1167.404541015625, 478.529510498046875, 12.81594467163085937, 1.575735211372375488, 7200, 0, 0, 8020, 0, 0, 0, 0, 0, 43345), -- Scarlet Myrmidon (Area: 0 - Difficulty: 1) +(@CGUID+98, 58756, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1171.367431640625, 475.0469970703125, 12.81594467163085937, 1.568601965904235839, 7200, 0, 0, 6415, 2068, 0, 0, 0, 0, 43345), -- Scarlet Evoker (Area: 0 - Difficulty: 1) +(@CGUID+99, 58685, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1169.367431640625, 475.056854248046875, 12.81594467163085937, 1.56860053539276123, 7200, 0, 0, 6415, 2068, 0, 0, 0, 0, 43345), -- Scarlet Evangelist (Area: 0 - Difficulty: 1) +(@CGUID+100, 58684, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1165.3675537109375, 475.076507568359375, 12.81594467163085937, 1.568597793579101562, 7200, 0, 0, 8020, 0, 0, 0, 0, 0, 43345), -- Scarlet Scourge Hewer (Area: 0 - Difficulty: 1) +(@CGUID+101, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1276.55908203125, 545.59027099609375, 18.3601531982421875, 0.191986218094825744, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+102, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1276.532958984375, 553.50177001953125, 18.04937744140625, 0, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+103, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1280.3680419921875, 536.607666015625, 18.39814186096191406, 0.628318548202514648, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) (Auras: ) +(@CGUID+104, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1279.4566650390625, 538.37152099609375, 15.74306011199951171, 0.541052043437957763, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+105, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1276.6961669921875, 555.171875, 16.15997695922851562, 6.021385669708251953, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+106, 59155, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1279.3177490234375, 541.90277099609375, 12.87879276275634765, 0.366519153118133544, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Book Case (Area: 0 - Difficulty: 1) +(@CGUID+107, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1282.2135009765625, 534.9461669921875, 14.67138004302978515, 0.750491559505462646, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+108, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1279.9271240234375, 537.18927001953125, 16.88263511657714843, 0.593411922454833984, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+109, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1283.4461669921875, 533.33331298828125, 19.79291343688964843, 0.837758064270019531, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) (Auras: ) +(@CGUID+110, 59198, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1279.06884765625, 548.71112060546875, 13.83067703247070312, 1.637171626091003417, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Dragon Breath Target (Area: 0 - Difficulty: 1) (possible waypoints or random movement) +(@CGUID+111, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1276.53125, 544.1024169921875, 17.01406288146972656, 0.244346097111701965, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+112, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1276.685791015625, 545.640625, 15.84839725494384765, 0.174532920122146606, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+113, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1276.55908203125, 555.36456298828125, 19.05624198913574218, 6.021385669708251953, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+114, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1282.1944580078125, 534.66668701171875, 19.00866127014160156, 0.750491559505462646, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+115, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1285.4879150390625, 531.53472900390625, 19.15541839599609375, 0.959931075572967529, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+116, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1280.2603759765625, 561.7586669921875, 16.64483642578125, 5.689773082733154296, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) (Auras: ) +(@CGUID+117, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1278.4947509765625, 560.65802001953125, 15.92259407043457031, 5.759586334228515625, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) (Auras: ) +(@CGUID+118, 59155, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1279.8177490234375, 557.33331298828125, 12.87795448303222656, 5.864306449890136718, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Book Case (Area: 0 - Difficulty: 1) +(@CGUID+119, 59155, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1290.579833984375, 531.1961669921875, 12.87951374053955078, 1.169370532035827636, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Book Case (Area: 0 - Difficulty: 1) +(@CGUID+120, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1292.8975830078125, 528.078125, 14.62805366516113281, 1.326450228691101074, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+121, 59240, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1187.93408203125, 516.607666015625, 12.90716361999511718, 4.799655437469482421, 7200, 0, 0, 8020, 0, 0, 0, 0, 0, 43345), -- Scarlet Hall Guardian (Area: 0 - Difficulty: 1) +(@CGUID+122, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1286.439208984375, 531.01043701171875, 15.73329448699951171, 1.01229095458984375, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) (Auras: ) +(@CGUID+123, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1294.02783203125, 527.7742919921875, 20.20392990112304687, 1.378810048103332519, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) (Auras: ) +(@CGUID+124, 59240, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1191.4566650390625, 516.51214599609375, 12.90704631805419921, 4.799655437469482421, 7200, 0, 0, 8020, 0, 0, 0, 0, 0, 43345), -- Scarlet Hall Guardian (Area: 0 - Difficulty: 1) +(@CGUID+125, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1293.907958984375, 527.86285400390625, 18.34935379028320312, 1.378810048103332519, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+126, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1280.05908203125, 562.185791015625, 18.03764533996582031, 5.672319889068603515, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+127, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1286.861083984375, 530.52606201171875, 19.887847900390625, 1.029744267463684082, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+128, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1282.0225830078125, 564.22052001953125, 16.05789375305175781, 5.532693862915039062, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+129, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1297.4288330078125, 527.74481201171875, 19.12301063537597656, 1.535889744758605957, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) (Auras: ) +(@CGUID+130, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1281.859375, 564.2586669921875, 19.03419876098632812, 5.550147056579589843, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) (Auras: ) +(@CGUID+131, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1298.5069580078125, 527.67706298828125, 20.34915924072265625, 1.588249564170837402, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+132, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1301.9600830078125, 528.05731201171875, 14.93479061126708984, 1.745329260826110839, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+133, 59241, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1189.616455078125, 525.88641357421875, 12.81700611114501953, 1.582689523696899414, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Treasurer (Area: 0 - Difficulty: 1) (Auras: 113876 - Carrying Treasure) (possible waypoints or random movement) +(@CGUID+134, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1299.2569580078125, 527.9132080078125, 14.89675045013427734, 1.623156189918518066, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+135, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1283.3836669921875, 565.373291015625, 16.79845046997070312, 5.462880611419677734, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+136, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1302.171875, 527.82464599609375, 19.6558380126953125, 1.745329260826110839, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+137, 59241, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1193.173095703125, 519.0013427734375, 12.808258056640625, 4.706137657165527343, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Treasurer (Area: 0 - Difficulty: 1) (Auras: 113874 - Carrying Treasure) (possible waypoints or random movement) +(@CGUID+138, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1303.217041015625, 527.888916015625, 16.9113006591796875, 1.797689080238342285, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+139, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1285.77783203125, 567.75, 14.82933712005615234, 5.305800914764404296, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+140, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1303.6197509765625, 527.796875, 18.4222869873046875, 1.815142393112182617, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) (Auras: ) +(@CGUID+141, 59155, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1305.810791015625, 531.36981201171875, 12.87739849090576171, 1.954768776893615722, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Book Case (Area: 0 - Difficulty: 1) +(@CGUID+142, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1309.8055419921875, 530.5711669921875, 19.20388412475585937, 2.111848354339599609, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+143, 59155, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1290.5069580078125, 567.9600830078125, 12.87825298309326171, 5.096361160278320312, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Book Case (Area: 0 - Difficulty: 1) +(@CGUID+144, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1312.7413330078125, 533.640625, 14.78537178039550781, 2.30383467674255371, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) (Auras: ) +(@CGUID+145, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1310.1597900390625, 531.16839599609375, 14.97029972076416015, 2.146754980087280273, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+146, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1286.921875, 568.85589599609375, 15.84986686706542968, 5.235987663269042968, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) (Auras: ) +(@CGUID+147, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1312.9461669921875, 534.107666015625, 18.94790267944335937, 2.321287870407104492, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+148, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1310.4410400390625, 531.640625, 20.09951591491699218, 2.164208173751831054, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+149, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1285.7899169921875, 567.55731201171875, 20.16889572143554687, 5.305800914764404296, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+150, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1309.657958984375, 530.64581298828125, 16.050262451171875, 2.111848354339599609, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+151, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1313.6754150390625, 534.38543701171875, 17.11921119689941406, 2.356194496154785156, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+152, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1293.140625, 571.10589599609375, 14.99205684661865234, 3.717551231384277343, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) (Auras: ) +(@CGUID+153, 59150, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1308.032958984375, 549.06427001953125, 12.86906147003173828, 2.615616798400878906, 7200, 0, 0, 61355, 19271, 0, 0, 0, 0, 43345), -- Flameweaver Koegler (Area: 0 - Difficulty: 1) +(@CGUID+154, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1299.12158203125, 571.40277099609375, 20.3282928466796875, 4.660028934478759765, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+155, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1293.6822509765625, 571.22222900390625, 18.18926811218261718, 3.717551231384277343, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) (Auras: ) +(@CGUID+156, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1316.998291015625, 537.875, 16.00054550170898437, 2.565634012222290039, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) (Auras: ) +(@CGUID+157, 59155, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1316.6875, 541.98614501953125, 12.87698554992675781, 2.740166902542114257, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Book Case (Area: 0 - Difficulty: 1) +(@CGUID+158, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1293.8836669921875, 571.1024169921875, 16.00655364990234375, 3.717551231384277343, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+159, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1316.8038330078125, 538.03643798828125, 18.89136123657226562, 2.565634012222290039, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+160, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1316.342041015625, 537.3524169921875, 14.97194576263427734, 2.530727386474609375, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) (Auras: ) +(@CGUID+161, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1319.626708984375, 544.80902099609375, 19.52492141723632812, 2.914699792861938476, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+162, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1319.3680419921875, 544.01214599609375, 14.73028755187988281, 2.862339973449707031, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) (Auras: ) +(@CGUID+163, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1297.123291015625, 571.17535400390625, 14.7918701171875, 4.747295379638671875, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+164, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1292.8646240234375, 571.326416015625, 19.43090057373046875, 3.717551231384277343, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+165, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1297.0538330078125, 570.97052001953125, 18.69906806945800781, 4.747295379638671875, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+166, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1319.7379150390625, 550.08856201171875, 19.34741783142089843, 3.141592741012573242, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+167, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1319.501708984375, 548.92535400390625, 14.70551681518554687, 3.089232683181762695, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) (Auras: ) +(@CGUID+168, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1309.451416015625, 568.5867919921875, 14.80987548828125, 4.15388345718383789, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+169, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1316.5, 561.8125, 20.33852195739746093, 3.717551231384277343, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+170, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1312.4097900390625, 566.0086669921875, 19.262359619140625, 3.979350566864013671, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+171, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1309.420166015625, 568.951416015625, 19.54998588562011718, 4.171336650848388671, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+172, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1317.27783203125, 560.80731201171875, 17.95528221130371093, 3.647738218307495117, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) (Auras: ) +(@CGUID+173, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1315.65625, 561.82293701171875, 15.41545963287353515, 3.717551231384277343, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+174, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1310.3125, 567.3194580078125, 18.79671287536621093, 4.084070205688476562, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+175, 59155, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1316.076416015625, 557.00347900390625, 12.87793540954589843, 3.525565147399902343, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Book Case (Area: 0 - Difficulty: 1) +(@CGUID+176, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1301.7239990234375, 570.9913330078125, 16.82733917236328125, 4.537856101989746093, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+177, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1319.4947509765625, 555.11285400390625, 14.78991889953613281, 3.368485450744628906, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) (Auras: ) +(@CGUID+178, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1301.9566650390625, 571.30731201171875, 19.7624969482421875, 4.520402908325195312, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+179, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1319.60595703125, 553.22918701171875, 19.54143142700195312, 3.298672199249267578, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+180, 59155, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1305.6319580078125, 567.83856201171875, 12.87824440002441406, 4.310963153839111328, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Book Case (Area: 0 - Difficulty: 1) +(@CGUID+181, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1312.3992919921875, 565.2100830078125, 15.52765560150146484, 3.96189737319946289, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+182, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1303.05908203125, 570.67535400390625, 15.46782207489013671, 4.468042850494384765, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) +(@CGUID+183, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1319.704833984375, 555.3350830078125, 19.01318359375, 3.385938644409179687, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) (Auras: ) +(@CGUID+184, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1319.501708984375, 545.78125, 16.00999832153320312, 2.94960641860961914, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) (Auras: ) +(@CGUID+185, 59209, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1313.951416015625, 564.498291015625, 20.3523406982421875, 3.874630928039550781, 7200, 0, 0, 3208, 0, 0, 0, 0, 0, 43345), -- Books (Area: 0 - Difficulty: 1) (Auras: ) +(@CGUID+186, 59240, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1188.09033203125, 538.84893798828125, 12.89546394348144531, 4.799655437469482421, 7200, 0, 0, 8020, 0, 0, 0, 0, 0, 43345), -- Scarlet Hall Guardian (Area: 0 - Difficulty: 1) +(@CGUID+187, 59240, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1191.6146240234375, 538.75347900390625, 12.90413761138916015, 4.799655437469482421, 7200, 0, 0, 8020, 0, 0, 0, 0, 0, 43345), -- Scarlet Hall Guardian (Area: 0 - Difficulty: 1) +(@CGUID+188, 59241, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1183.163818359375, 548.75665283203125, 12.81348609924316406, 2.78467416763305664, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Treasurer (Area: 0 - Difficulty: 1) (Auras: 113876 - Carrying Treasure) (possible waypoints or random movement) +(@CGUID+189, 66091, 1001, 6052, 0, '1,2', '0', 0, 0, 0, 1200.3853759765625, 443.95660400390625, 12.53029918670654296, 0, 7200, 0, 0, 1989, 0, 0, 0, 0, 0, 43345), -- Referee (Area: 0 - Difficulty: 1) +(@CGUID+190, 59241, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1178.5120849609375, 549.9305419921875, 13.70385551452636718, 6.099505424499511718, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Treasurer (Area: 0 - Difficulty: 1) (Auras: 113876 - Carrying Treasure) (possible waypoints or random movement) +(@CGUID+191, 59241, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1189.2794189453125, 557.23834228515625, 12.8077239990234375, 1.132458329200744628, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Treasurer (Area: 0 - Difficulty: 1) (Auras: 113875 - Carrying Treasure) +(@CGUID+192, 59373, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1231.001708984375, 544.65802001953125, 12.92136955261230468, 3.211405754089355468, 7200, 0, 0, 1604, 852, 0, 0, 0, 0, 43345), -- Scarlet Pupil (Area: 0 - Difficulty: 1) (Auras: 114159 - Studying) +(@CGUID+193, 59373, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1227.703125, 545.15972900390625, 12.91878509521484375, 5.8817596435546875, 7200, 0, 0, 1604, 852, 0, 0, 0, 0, 43345), -- Scarlet Pupil (Area: 0 - Difficulty: 1) (Auras: 114159 - Studying) +(@CGUID+194, 59373, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1229.1788330078125, 546.47918701171875, 12.91840839385986328, 4.712388992309570312, 7200, 0, 0, 1604, 852, 0, 0, 0, 0, 43345), -- Scarlet Pupil (Area: 0 - Difficulty: 1) (Auras: 114159 - Studying) +(@CGUID+195, 59372, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1227.390625, 552.58856201171875, 12.80950927734375, 0.851660609245300292, 7200, 0, 0, 6416, 1622, 0, 0, 0, 0, 43345), -- Scarlet Scholar (Area: 0 - Difficulty: 1) +(@CGUID+196, 59373, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1227.9114990234375, 554.43402099609375, 12.9146270751953125, 6.091198921203613281, 7200, 0, 0, 1604, 852, 0, 0, 0, 0, 43345), -- Scarlet Pupil (Area: 0 - Difficulty: 1) (Auras: 114159 - Studying) +(@CGUID+197, 59373, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1231.4305419921875, 554.63018798828125, 12.92118263244628906, 3.333578824996948242, 7200, 0, 0, 1604, 852, 0, 0, 0, 0, 43345), -- Scarlet Pupil (Area: 0 - Difficulty: 1) (Auras: 114159 - Studying) +(@CGUID+198, 59373, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1229.345458984375, 553.11114501953125, 12.91886329650878906, 1.692969322204589843, 7200, 0, 0, 1604, 852, 0, 0, 0, 0, 43345), -- Scarlet Pupil (Area: 0 - Difficulty: 1) (Auras: 114159 - Studying) +(@CGUID+199, 59373, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1250.93408203125, 546.05731201171875, 12.91726589202880859, 4.712388992309570312, 7200, 0, 0, 1604, 852, 0, 0, 0, 0, 43345), -- Scarlet Pupil (Area: 0 - Difficulty: 1) (Auras: 114159 - Studying) +(@CGUID+200, 59373, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1249.4583740234375, 544.73785400390625, 12.91932392120361328, 5.8817596435546875, 7200, 0, 0, 1604, 852, 0, 0, 0, 0, 43345), -- Scarlet Pupil (Area: 0 - Difficulty: 1) (Auras: 114159 - Studying) +(@CGUID+201, 59372, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1249.57470703125, 546.30035400390625, 12.81136226654052734, 5.325881004333496093, 7200, 0, 0, 6416, 1622, 0, 0, 0, 0, 43345), -- Scarlet Scholar (Area: 0 - Difficulty: 1) +(@CGUID+202, 59373, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1249.6666259765625, 554.01214599609375, 12.91935348510742187, 6.091198921203613281, 7200, 0, 0, 1604, 852, 0, 0, 0, 0, 43345), -- Scarlet Pupil (Area: 0 - Difficulty: 1) (Auras: 114159 - Studying) +(@CGUID+203, 59373, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1252.7569580078125, 544.234375, 12.92205047607421875, 3.211405754089355468, 7200, 0, 0, 1604, 852, 0, 0, 0, 0, 43345), -- Scarlet Pupil (Area: 0 - Difficulty: 1) (Auras: 114159 - Studying) +(@CGUID+204, 59373, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1251.1007080078125, 552.68927001953125, 12.91834354400634765, 1.692969322204589843, 7200, 0, 0, 1604, 852, 0, 0, 0, 0, 43345), -- Scarlet Pupil (Area: 0 - Difficulty: 1) (Auras: 114159 - Studying) +(@CGUID+205, 59373, 1001, 6052, 0, '1,2', '0', 0, 0, 1, 1253.18408203125, 554.20660400390625, 12.92056655883789062, 3.333578824996948242, 7200, 0, 0, 1604, 852, 0, 0, 0, 0, 43345), -- Scarlet Pupil (Area: 0 - Difficulty: 1) (Auras: 114159 - Studying) +(@CGUID+206, 64764, 1001, 6052, 6052, '2', 1442, 0, 0, 1, 838.3125, 619.1336669921875, 12.89531135559082031, 3.945157289505004882, 7200, 0, 0, 2058, 1097, 0, 0, 0, 0, 43345), -- Hooded Crusader (Area: Scarlet Halls - Difficulty: 2) +(@CGUID+207, 64738, 1001, 6052, 6052, '1', '1441', 0, 0, 1, 838.3125, 619.1336669921875, 12.89531135559082031, 3.945157289505004882, 7200, 0, 0, 1604, 852, 0, 0, 0, 0, 44061); -- Hooded Crusader (Area: Scarlet Halls - Difficulty: 1) + +-- GameObject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+29; +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, 214508, 1001, 6052, 6052, '1,2', '0', 0, 820.58856201171875, 615.045166015625, 13.4903421401977539, 4.715349197387695312, 0, 0, -0.70605945587158203, 0.708152532577514648, 7200, 255, 1, 43345), -- Instance Portal (Party + Heroic + Challenge) (Area: Scarlet Halls - Difficulty: 1) +(@OGUID+1, 212160, 1001, 6052, 6052, '1,2', '0', 0, 946.39990234375, 535.8843994140625, 13.58847618103027343, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 43345), -- Doodad_TolBarad_Gates_024 (Area: Scarlet Halls - Difficulty: 1) +(@OGUID+2, 210480, 1001, 6052, 6052, '1,2', '0', 0, 1174.9837646484375, 443.9715576171875, 13.48141670227050781, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 0, 43345), -- Herod's Door (Area: Scarlet Halls - Difficulty: 1) +(@OGUID+3, 210097, 1001, 6052, 6052, '1,2', '0', 0, 1040.27783203125, 509.71875, 13.47688007354736328, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 7200, 255, 1, 43345), -- Invisible Fire Wall - CoT Well of Eternity (Area: Scarlet Halls - Difficulty: 1) +(@OGUID+4, 2042, 1001, 6052, 6301, '1,2', '0', 0, 940.97393798828125, 552.7430419921875, 13.06961822509765625, 5.045995235443115234, 0, 0, -0.57989120483398437, 0.814693927764892578, 7200, 255, 1, 43345), -- Fadeleaf (Area: Training Grounds - Difficulty: 1) +(@OGUID+5, 210499, 1001, 6052, 0, '1,2', '0', 0, 1146.890380859375, 503.65924072265625, 13.53452110290527343, 6.283183574676513671, 0, 0, -0.0000009536743164, 1, 7200, 255, 1, 43345), -- Fine Chair (Area: 0 - Difficulty: 1) +(@OGUID+6, 210501, 1001, 6052, 0, '1,2', '0', 0, 1146.890380859375, 507.17315673828125, 13.53452110290527343, 6.283183574676513671, 0, 0, -0.0000009536743164, 1, 7200, 255, 1, 43345), -- Fine Chair (Area: 0 - Difficulty: 1) +(@OGUID+7, 210500, 1001, 6052, 0, '1,2', '0', 0, 1146.890380859375, 501.8111572265625, 13.53452110290527343, 6.283183574676513671, 0, 0, -0.0000009536743164, 1, 7200, 255, 1, 43345), -- Fine Chair (Area: 0 - Difficulty: 1) +(@OGUID+8, 210502, 1001, 6052, 0, '1,2', '0', 0, 1146.890380859375, 509.021209716796875, 13.53452110290527343, 6.283183574676513671, 0, 0, -0.0000009536743164, 1, 7200, 255, 1, 43345), -- Fine Chair (Area: 0 - Difficulty: 1) +(@OGUID+9, 210479, 1001, 6052, 0, '1,2', '0', 0, 1180.7738037109375, 447.62774658203125, 11.89191055297851562, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 43345), -- Lever (Area: 0 - Difficulty: 1) +(@OGUID+10, 210491, 1001, 6052, 0, '1,2', '0', 0, 1186.4139404296875, 455.557373046875, 10.39205360412597656, 5.759587764739990234, 0, 0, -0.25881862640380859, 0.965925931930541992, 7200, 255, 1, 43345), -- Invar One-Arm (Area: 0 - Difficulty: 1) +(@OGUID+11, 210481, 1001, 6052, 0, '1,2', '0', 0, 1193.12451171875, 449.22137451171875, 1.10054636001586914, 5.89921426773071289, 0, 0, -0.19080829620361328, 0.981627285480499267, 7200, 255, 1, 43345), -- Fine Chair (Area: 0 - Difficulty: 1) +(@OGUID+12, 210482, 1001, 6052, 0, '1,2', '0', 0, 1193.082275390625, 438.905517578125, 1.10054636001586914, 0.366519540548324584, 0, 0, 0.1822357177734375, 0.983254849910736083, 7200, 255, 1, 43345), -- Fine Chair (Area: 0 - Difficulty: 1) +(@OGUID+13, 210485, 1001, 6052, 0, '1,2', '0', 0, 1186.3927001953125, 432.4857177734375, 10.39330101013183593, 0.514871180057525634, 0, 0, 0.254601478576660156, 0.967046082019805908, 7200, 255, 1, 43345), -- Admiral Barean Westwind (Area: 0 - Difficulty: 1) +(@OGUID+14, 210484, 1001, 6052, 0, '1,2', '0', 0, 1195.832275390625, 464.51263427734375, 9.334241867065429687, 5.192357540130615234, 0, 0, -0.51877212524414062, 0.85491257905960083, 7200, 255, 1, 43345), -- Arellas Fireleaf (Area: 0 - Difficulty: 1) +(@OGUID+15, 210490, 1001, 6052, 0, '1,2', '0', 0, 1206.3504638671875, 467.091888427734375, 7.355008602142333984, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 7200, 255, 1, 43345), -- Holia Sunshield (Area: 0 - Difficulty: 1) +(@OGUID+16, 210489, 1001, 6052, 0, '1,2', '0', 0, 1195.717041015625, 423.5684814453125, 9.321104049682617187, 1.073376059532165527, 0, 0, 0.511292457580566406, 0.859406769275665283, 7200, 255, 1, 43345), -- Harthal Truesight (Area: 0 - Difficulty: 1) +(@OGUID+17, 210493, 1001, 6052, 0, '1,2', '0', 0, 1206.3751220703125, 420.9425048828125, 7.355008602142333984, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 7200, 255, 1, 43345), -- Valea Twinblades (Area: 0 - Difficulty: 1) +(@OGUID+18, 210483, 1001, 6052, 0, '1,2', '0', 0, 1213.307861328125, 438.365386962890625, 1.10054636001586914, 2.469640254974365234, 0, 0, 0.944088935852050781, 0.329690933227539062, 7200, 255, 1, 43345), -- Fine Chair (Area: 0 - Difficulty: 1) +(@OGUID+19, 210488, 1001, 6052, 0, '1,2', '0', 0, 1217.8978271484375, 464.01544189453125, 7.354197025299072265, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 7200, 255, 1, 43345), -- Ferren Marcus (Area: 0 - Difficulty: 1) +(@OGUID+20, 210494, 1001, 6052, 0, '1,2', '0', 0, 1226.3570556640625, 455.574462890625, 7.342121601104736328, 3.656466007232666015, 0, 0, -0.96704578399658203, 0.254602491855621337, 7200, 255, 1, 43345), -- Yana Bloodspear (Area: 0 - Difficulty: 1) +(@OGUID+21, 210486, 1001, 6052, 0, '1,2', '0', 0, 1217.86865234375, 424.00616455078125, 7.355008602142333984, 2.085667610168457031, 0, 0, 0.863835334777832031, 0.503774285316467285, 7200, 255, 1, 43345), -- Dorgar Stoenbrow (Area: 0 - Difficulty: 1) +(@OGUID+22, 210492, 1001, 6052, 0, '1,2', '0', 0, 1229.452880859375, 444.01788330078125, 7.355008602142333984, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 43345), -- Orman of Stromgarde (Area: 0 - Difficulty: 1) +(@OGUID+23, 210487, 1001, 6052, 0, '1,2', '0', 0, 1226.35498046875, 432.464019775390625, 7.355008602142333984, 2.617989301681518554, 0, 0, 0.965925216674804687, 0.258821308612823486, 7200, 255, 1, 43345), -- Fellari Swiftarrow (Area: 0 - Difficulty: 1) +(@OGUID+24, 212968, 1001, 6052, 0, '1,2', '0', 0, 1283.7899169921875, 533.375, 16.7499237060546875, 2.367238759994506835, 0, 0, 0.925978660583496093, 0.377575844526290893, 7200, 255, 1, 43345), -- Ancient Tome (Area: 0 - Difficulty: 1) +(@OGUID+25, 210498, 1001, 6052, 0, '1,2', '0', 0, 1287.671875, 533.526123046875, 12.87752151489257812, 0.366517573595046997, 0, 0, 0.182234764099121093, 0.98325502872467041, 7200, 255, 1, 43345), -- Fine Chair (Area: 0 - Difficulty: 1) +(@OGUID+26, 210497, 1001, 6052, 0, '1,2', '0', 0, 1299.5826416015625, 532.4459228515625, 12.867706298828125, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 43345), -- Fine Chair (Area: 0 - Difficulty: 1) +(@OGUID+27, 252851, 1001, 6052, 0, '1,2', '0', 0, 1298.689208984375, 533.3125, 14.22403812408447265, 0.405000090599060058, 0.687770366668701171, 0.137936592102050781, 0.146427154541015625, 0.697498738765716552, 7200, 255, 1, 43345), -- Which Came First, the Tree or the Seed? (Area: 0 - Difficulty: 1) +(@OGUID+28, 210495, 1001, 6052, 0, '1,2', '0', 0, 1316.297607421875, 554.50726318359375, 12.87752151489257812, 3.211419343948364257, 0, 0, -0.9993906021118164, 0.034906134009361267, 7200, 255, 1, 43345), -- Fine Chair (Area: 0 - Difficulty: 1) +(@OGUID+29, 210496, 1001, 6052, 0, '1,2', '0', 0, 1316.0166015625, 551.47576904296875, 12.87752151489257812, 2.277649402618408203, 0, 0, 0.90814208984375, 0.418662101030349731, 7200, 255, 1, 43345); -- Fine Chair (Area: 0 - Difficulty: 1) + +DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+29; +INSERT INTO `gameobject_addon` (`guid`, `parent_rotation0`, `parent_rotation1`, `parent_rotation2`, `parent_rotation3`, `WorldEffectID`, `AIAnimKitID`) VALUES +(@OGUID+1, 0, 0, 1, -0.00000004371138828, 0, 0), -- Doodad_TolBarad_Gates_024 +(@OGUID+2, 0, 0, 1, -0.00000004371138828, 0, 0), -- Herod's Door +(@OGUID+5, 0, 0, 1, -0.00000004371138828, 0, 0), -- Fine Chair +(@OGUID+6, 0, 0, 1, -0.00000004371138828, 0, 0), -- Fine Chair +(@OGUID+7, 0, 0, 1, -0.00000004371138828, 0, 0), -- Fine Chair +(@OGUID+8, 0, 0, 1, -0.00000004371138828, 0, 0), -- Fine Chair +(@OGUID+9, 0, 0, 1, -0.00000004371138828, 0, 0), -- Lever +(@OGUID+10, 0, 0, 1, -0.00000004371138828, 0, 0), -- Invar One-Arm +(@OGUID+11, 0, 0, 1, -0.00000004371138828, 0, 0), -- Fine Chair +(@OGUID+12, 0, 0, 1, -0.00000004371138828, 0, 0), -- Fine Chair +(@OGUID+13, 0, 0, 1, -0.00000004371138828, 0, 0), -- Admiral Barean Westwind +(@OGUID+14, 0, 0, 1, -0.00000004371138828, 0, 0), -- Arellas Fireleaf +(@OGUID+15, 0, 0, 1, -0.00000004371138828, 0, 0), -- Holia Sunshield +(@OGUID+16, 0, 0, 1, -0.00000004371138828, 0, 0), -- Harthal Truesight +(@OGUID+17, 0, 0, 1, -0.00000004371138828, 0, 0), -- Valea Twinblades +(@OGUID+18, 0, 0, 1, -0.00000004371138828, 0, 0), -- Fine Chair +(@OGUID+19, 0, 0, 1, -0.00000004371138828, 0, 0), -- Ferren Marcus +(@OGUID+20, 0, 0, 1, -0.00000004371138828, 0, 0), -- Yana Bloodspear +(@OGUID+21, 0, 0, 1, -0.00000004371138828, 0, 0), -- Dorgar Stoenbrow +(@OGUID+22, 0, 0, 1, -0.00000004371138828, 0, 0), -- Orman of Stromgarde +(@OGUID+23, 0, 0, 1, -0.00000004371138828, 0, 0), -- Fellari Swiftarrow +(@OGUID+25, 0, 0, 1, -0.00000004371138828, 0, 0), -- Fine Chair +(@OGUID+26, 0, 0, 1, -0.00000004371138828, 0, 0), -- Fine Chair +(@OGUID+28, 0, 0, 1, -0.00000004371138828, 0, 0), -- Fine Chair +(@OGUID+29, 0, 0, 1, -0.00000004371138828, 0, 0); -- Fine Chair + +-- Creature Scaling +DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=1 AND `Entry` IN (59372,59373,66091,59150,59241,59240,59198,59155,59209,65546,58756,58632,58676,58685,58683,58684,59302,59299,59309,59303,59191,59175,54030,60908,58727,58898,65379,58674,58701,58876,64738)); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(59372, 1, 0, 0, 210, 43345), +(59373, 1, 0, 0, 210, 43345), +(66091, 1, 5, 5, 210, 43345), +(59150, 1, 2, 2, 210, 43345), +(59241, 1, 0, 0, 210, 43345), +(59240, 1, 0, 0, 210, 43345), +(59198, 1, 0, 0, 210, 43345), +(59155, 1, 0, 0, 210, 43345), +(59209, 1, 0, 0, 210, 43345), +(65546, 1, 0, 0, 996, 43345), +(58756, 1, 0, 0, 210, 43345), +(58632, 1, 2, 2, 210, 43345), +(58676, 1, 0, 0, 210, 43345), +(58685, 1, 0, 0, 210, 43345), +(58683, 1, 0, 0, 210, 43345), +(58684, 1, 0, 0, 210, 43345), +(59302, 1, 1, 1, 210, 43345), +(59299, 1, 1, 1, 210, 43345), +(59309, 1, 1, 1, 210, 43345), +(59303, 1, 2, 2, 210, 43345), +(59191, 1, 1, 1, 210, 43345), +(59175, 1, 0, 0, 210, 43345), +(54030, 1, 0, 0, 181, 43345), +(60908, 1, 0, 0, 210, 43345), +(58727, 1, 0, 0, 210, 43345), +(58898, 1, 1, 1, 210, 43345), +(65379, 1, 0, 0, 210, 43345), +(58674, 1, 1, 1, 210, 43345), +(58701, 1, 0, 0, 210, 43345), +(58876, 1, 0, 0, 210, 43345), +(64738, 1, 0, 0, 210, 44061); + +-- Creature Template Addon +DELETE FROM `creature_template_addon` WHERE `entry` IN (59373 /*59373 (Scarlet Pupil) - Studying*/, 66091 /*66091 (Referee)*/, 59150 /*59150 (Flameweaver Koegler)*/, 59241 /*59241 (Scarlet Treasurer) - Carrying Treasure*/, 59198 /*59198 (Dragon Breath Target)*/, 59155 /*59155 (Book Case)*/, 59209 /*59209 (Books)*/, 65546 /*65546 (Sekrit) - Hide*/, 58632 /*58632 (Armsmaster Harlan)*/, 58676 /*58676 (Scarlet Defender) - Heavy Armor, Shield Barrier*/, 59302 /*59302 (Sergeant Verdone) - Phalanx Defense*/, 59299 /*59299 (Scarlet Guardian) - Phalanx Defense*/, 59309 /*59309 (Obedient Hound) - Purge All Debuffs*/, 59303 /*59303 (Houndmaster Braun) - Houndmaster Controller Aura*/, 59191 /*59191 (Commander Lindon) - Slaughter the Weak*/, 59175 /*59175 (Master Archer) - Perfect Shot*/, 54030 /*54030 (Invisible Stalker)*/, 58727 /*58727 (Chained Dog Target) - Ride Vehicle Hardcoded*/, 65379 /*65379 (Bucket of Meaty Dog Food) - Bucket of Meaty Dog Food, Cosmetic - Loot Sparkles (2.00)*/, 58674 /*58674 (Angry Hound) - Zero Energy + Zero Regen, Chained, Speedy, Calming Down*/, 58701 /*58701 (Stake) - Stake Checker*/, 58876 /*58876 (Starving Hound) - Pack Instincts, Pack Member*/); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(59373, 0, 0, 0, 1, 0, 0, 0, 0, 0, '114159'), -- 59373 (Scarlet Pupil) - Studying +(66091, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- 66091 (Referee) +(59150, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''), -- 59150 (Flameweaver Koegler) +(59241, 0, 0, 0, 1, 0, 0, 0, 0, 0, '113876'), -- 59241 (Scarlet Treasurer) - Carrying Treasure +(59198, 0, 0, 50331648, 1, 0, 0, 0, 0, 3, ''), -- 59198 (Dragon Breath Target) +(59155, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''), -- 59155 (Book Case) +(59209, 0, 0, 50331648, 1, 0, 0, 0, 0, 3, ''), -- 59209 (Books) +(65546, 0, 0, 0, 1, 0, 0, 0, 0, 0, '125061'), -- 65546 (Sekrit) - Hide +(58632, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''), -- 58632 (Armsmaster Harlan) +(58676, 0, 0, 0, 1, 0, 0, 0, 0, 0, '111323 111324'), -- 58676 (Scarlet Defender) - Heavy Armor, Shield Barrier +(59302, 0, 0, 0, 1, 0, 0, 0, 0, 0, '127352'), -- 59302 (Sergeant Verdone) - Phalanx Defense +(59299, 0, 0, 0, 1, 0, 0, 0, 0, 0, '127352'), -- 59299 (Scarlet Guardian) - Phalanx Defense +(59309, 0, 0, 0, 1, 0, 0, 0, 0, 0, '130286'), -- 59309 (Obedient Hound) - Purge All Debuffs +(59303, 0, 0, 0, 1, 0, 0, 0, 0, 0, '114027'), -- 59303 (Houndmaster Braun) - Houndmaster Controller Aura +(59191, 0, 0, 0, 1, 0, 0, 0, 0, 0, '113847'), -- 59191 (Commander Lindon) - Slaughter the Weak +(59175, 0, 0, 0, 1, 0, 0, 0, 0, 0, '113845'), -- 59175 (Master Archer) - Perfect Shot +(54030, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- 54030 (Invisible Stalker) +(58727, 0, 0, 0, 1, 0, 0, 0, 0, 0, '46598'), -- 58727 (Chained Dog Target) - Ride Vehicle Hardcoded +(65379, 0, 0, 0, 1, 0, 0, 0, 0, 0, '128176 113994'), -- 65379 (Bucket of Meaty Dog Food) - Bucket of Meaty Dog Food, Cosmetic - Loot Sparkles (2.00) +(58674, 0, 0, 0, 1, 0, 0, 0, 0, 0, '72242 111641 111634 111406'), -- 58674 (Angry Hound) - Zero Energy + Zero Regen, Chained, Speedy, Calming Down +(58701, 0, 0, 0, 1, 0, 0, 0, 0, 0, '111703'), -- 58701 (Stake) - Stake Checker +(58876, 0, 0, 0, 1, 0, 0, 0, 0, 0, '111837 111838'); -- 58876 (Starving Hound) - Pack Instincts; Pack Member + +-- Update Template Data +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=59372; -- Scarlet Scholar +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=59373; -- Scarlet Pupil +UPDATE `creature_template` SET `minlevel`=35, `maxlevel`=35, `unit_flags3`=16777216 WHERE `entry`=66091; -- Referee +UPDATE `creature_template` SET `minlevel`=32, `maxlevel`=32 WHERE `entry`=59150; -- Flameweaver Koegler +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=59241; -- Scarlet Treasurer +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=59240; -- Scarlet Hall Guardian +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=59198; -- Dragon Breath Target +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=59155; -- Book Case +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=59209; -- Books +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=65546; -- Sekrit +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30, `dynamicflags`=0 WHERE `entry`=58756; -- Scarlet Evoker +UPDATE `creature_template` SET `minlevel`=32, `maxlevel`=32, `faction`=67 WHERE `entry`=58632; -- Armsmaster Harlan +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=58676; -- Scarlet Defender +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=58685; -- Scarlet Evangelist +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=58683; -- Scarlet Myrmidon +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=58684; -- Scarlet Scourge Hewer +UPDATE `creature_template` SET `minlevel`=31, `maxlevel`=31 WHERE `entry`=59302; -- Sergeant Verdone +UPDATE `creature_template` SET `minlevel`=31, `maxlevel`=31 WHERE `entry`=59299; -- Scarlet Guardian +UPDATE `creature_template` SET `minlevel`=31, `maxlevel`=31, `faction`=16, `unit_flags`=0, `unit_flags2`=2048 WHERE `entry`=59309; -- Obedient Hound +UPDATE `creature_template` SET `minlevel`=32, `maxlevel`=32, `faction`=16 WHERE `entry`=59303; -- Houndmaster Braun +UPDATE `creature_template` SET `minlevel`=31, `maxlevel`=31 WHERE `entry`=59191; -- Commander Lindon +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=59175; -- Master Archer +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=60908; -- Archery Target Base +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=58727; -- Chained Dog Target +UPDATE `creature_template` SET `minlevel`=31, `maxlevel`=31, `dynamicflags`=0 WHERE `entry`=58898; -- Vigilant Watchman +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30, `unit_flags3`=16777217 WHERE `entry`=65379; -- Bucket of Meaty Dog Food +UPDATE `creature_template` SET `minlevel`=31, `maxlevel`=31 WHERE `entry`=58674; -- Angry Hound +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=58701; -- Stake +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=58876; -- Starving Hound +UPDATE `creature_template` SET `gossip_menu_id`=14590, `minlevel`=36, `maxlevel`=36 WHERE `entry`=64764; -- Hooded Crusader +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=64738; -- Hooded Crusader + +-- Quest stuff +DELETE FROM `quest_offer_reward` WHERE `ID` IN(31495, 31497); +INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES +(31495, 25, 0, 0, 0, 0, 0, 0, 0, 'Great start, $p!$B$BIt won\'t be long now before the Scarlet Crusade is nothing more than an ugly footnote in the annals of history.', 44061), -- Rank and File +(31497, 273, 274, 0, 0, 0, 3000, 0, 0, 'Ah yes!$B$B<The Hooded Crusader rubs her hands together gleefully at the sight of the codex.>$B$BAnd now, I have a checklist with the name of every Scarlet Crusader on it!$B$BYou know... just in case any of them are unaccounted for. I don\'t like loose ends.', 44061); -- Just for Safekeeping; Of Course + +UPDATE `quest_offer_reward` SET `VerifiedBuild`=44061 WHERE `ID` IN (31493, 31490); + +DELETE FROM `quest_details` WHERE `ID` IN (31497 /*Just for Safekeeping, Of Course*/, 31495 /*Rank and File*/); +INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES +(31497, 1, 0, 0, 0, 0, 0, 0, 0, 44061), -- Just for Safekeeping, Of Course +(31495, 1, 0, 0, 0, 0, 0, 0, 0, 44061); -- Rank and File + +DELETE FROM `quest_request_items` WHERE `ID` IN (31495 /*Rank and File*/, 31497 /*Just for Safekeeping, Of Course*/, 31490 /*Rank and File*/); +INSERT INTO `quest_request_items` (`ID`, `EmoteOnComplete`, `EmoteOnIncomplete`, `EmoteOnCompleteDelay`, `EmoteOnIncompleteDelay`, `CompletionText`, `VerifiedBuild`) VALUES +(31495, 0, 1, 0, 0, 'You know, I\'ve been killing the ones that you can\'t see behind closed doors.$B$BBut I need to maintain this disguise. So if you could just take care of all of the ones out there in the open, that\'d be great.', 44061), -- Rank and File +(31497, 1, 1, 0, 0, 'It\'s imperative that I get my hands on the codex.', 44061), -- Just for Safekeeping; Of Course +(31490, 0, 1, 0, 0, 'You know, I\'ve been killing the ones that you can\'t see behind closed doors.$B$BBut I need to maintain this disguise. So if you could just take care of all of the ones out there in the open, that\'d be great.', 44061); -- Rank and File + +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=1, `VerifiedBuild`=44061 WHERE `ID`=31493; -- Just for Safekeeping, Of Course + +DELETE FROM `gossip_menu` WHERE (`MenuID`=14590 AND `TextID` IN (20632,20638)); +INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES +(14590, 20632, 44061), -- 64764 (Hooded Crusader) +(14590, 20638, 44061); -- 64764 (Hooded Crusader) + +UPDATE `npc_text` SET `VerifiedBuild`=44061 WHERE `ID` IN (20632, 20638); + +-- Phasing +DELETE FROM `phase_area` WHERE (`AreaId` = 6052 AND `PhaseId` = 1442) OR (`AreaId` = 6052 AND `PhaseId` = 1441); +INSERT INTO `phase_area` (`AreaId`, `PhaseId`, `Comment`) VALUES +(6052, 1442, 'Cosmetic: Scarlet Halls - HC Quest Phase'), +(6052, 1441, 'Cosmetic: Scarlet Halls - NHC Quest Phase'); + +DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId` = 26 AND `SourceGroup` = 1442 AND `SourceEntry` = 6052) OR (`SourceTypeOrReferenceId` = 26 AND `SourceGroup` = 1441 AND `SourceEntry` = 6052) OR (`SourceTypeOrReferenceId` = 14 AND `SourceGroup` = 14590 AND `SourceEntry` = 20632); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `Comment`) VALUES +(26, 1442, 6052, 0, 0, 8, 0, 31495, 0, 0, 1, 'Apply Phase 1442 if Quest 31495 is NOT rewarded'), +(26, 1442, 6052, 0, 0, 8, 0, 31497, 0, 0, 1, 'Apply Phase 1442 if Quest 31497 is NOT rewarded'), +(26, 1441, 6052, 0, 0, 8, 0, 31493, 0, 0, 1, 'Apply Phase 1441 if Quest 31493 is NOT rewarded'), +(26, 1441, 6052, 0, 0, 8, 0, 31490, 0, 0, 1, 'Apply Phase 1441 if Quest 31490 is NOT rewarded'), +-- Gossip Menu +(14, 14590, 20632, 0, 0, 47, 0, 31495, 66, 0, 0, 'Show Gossip Menu Text 20632 if Quest 31495 IS complete/rewarded'), +(14, 14590, 20632, 0, 0, 47, 0, 31497, 66, 0, 0, 'Show Gossip Menu Text 20632 if Quest 31497 IS complete/rewarded'), +(14, 14590, 20632, 0, 1, 47, 0, 31490, 66, 0, 0, 'Show Gossip Menu Text 20632 if Quest 31490 IS complete/rewarded'), +(14, 14590, 20632, 0, 1, 47, 0, 31493, 66, 0, 0, 'Show Gossip Menu Text 20632 if Quest 31493 IS complete/rewarded'); + + +-- Vehicle +DELETE FROM `vehicle_template_accessory` WHERE `entry` = 58674; +INSERT INTO `vehicle_template_accessory` (`entry`, `accessory_entry`, `seat_id`, `minion`, `description`, `summontype`, `summontimer`) VALUES +(58674, 58727, 0, 0, 'Angry Hound - Chained Dog Target', 6, 300000); -- Angry Hound - Chained Dog Target + +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (65379, 60908, 58674); +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES +(65379, 128179, 1, 0), +(60908, 114878, 1, 0), +(58674, 46598, 1, 0); + +-- Waypoints and Formations for CGUID+17 +DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+17; +INSERT INTO `creature_formations`(`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@CGUID+17, @CGUID+17, 0, 0, 515, 1, 1), +(@CGUID+17, @CGUID+14, 2, 290, 515, 1, 1), +(@CGUID+17, @CGUID+8, 4, 310, 515, 1, 1), +(@CGUID+17, @CGUID+0, 2, 70, 515, 1, 1), +(@CGUID+17, @CGUID+5, 4, 50, 515, 1, 1); + +SET @PATH := @CGUID+13 * 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, 837.3004, 595.1528, 12.82033, 0, 0), +(@PATH, 1, 837.2066, 558.3038, 12.81002, 0, 0); + +UPDATE `creature` SET `position_x`= 837.3004, `position_y`= 595.1528, `position_z`= 12.82033, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+17; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+17; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+17, @PATH, 1); + +-- Waypoints and Formations for CGUID+12 +DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+12; +INSERT INTO `creature_formations`(`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@CGUID+12, @CGUID+12, 0, 0, 515, 1, 1), +(@CGUID+12, @CGUID+3, 1, 290, 515, 1, 1), +(@CGUID+12, @CGUID+9, 2, 310, 515, 1, 1), +(@CGUID+12, @CGUID+18, 1, 70, 515, 1, 1), +(@CGUID+12, @CGUID+13, 2, 50, 515, 1, 1); + +SET @PATH := @CGUID+12 * 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, 916.5417, 562.368, 13.48333, 0, 0), +(@PATH, 1, 881.8629, 562.3993, 13.48333, 0, 0); + +UPDATE `creature` SET `position_x`= 916.5417, `position_y`= 562.368, `position_z`= 13.48333, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+12; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+12; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+12, @PATH, 1); + +-- Waypoints and Formations for CGUID+32 +DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+32; +INSERT INTO `creature_formations`(`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@CGUID+32, @CGUID+32, 0, 0, 515, 1, 1), +(@CGUID+32, @CGUID+29, 1, 290, 515, 1, 1), +(@CGUID+32, @CGUID+28, 2, 310, 515, 1, 1), +(@CGUID+32, @CGUID+31, 1, 70, 515, 1, 1), +(@CGUID+32, @CGUID+30, 2, 50, 515, 1, 1); + +SET @PATH := @CGUID+32 * 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, 898.2847, 517.2031, 13.4811, 0, 0), +(@PATH, 1, 937.0052, 517.2656, 13.4811, 0, 0); + +UPDATE `creature` SET `position_x`= 898.2847, `position_y`= 517.2031, `position_z`= 13.4811, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+32; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+32; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+32, @PATH, 1); + +-- Waypoints and Formations for CGUID+51 +DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+51; +INSERT INTO `creature_formations`(`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@CGUID+51, @CGUID+51, 0, 0, 515, 1, 1), +(@CGUID+51, @CGUID+49, 1, 290, 515, 1, 1), +(@CGUID+51, @CGUID+50, 2, 310, 515, 1, 1), +(@CGUID+51, @CGUID+53, 1, 70, 515, 1, 1), +(@CGUID+51, @CGUID+52, 2, 50, 515, 1, 1); + +SET @PATH := @CGUID+51 * 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, 986.7344, 498.1267, 13.48111, 0, 0), +(@PATH, 1, 986.7066, 522.7587, 13.48111, 0, 0); + +UPDATE `creature` SET `position_x`= 986.7344, `position_y`= 498.1267, `position_z`= 13.48111, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+51; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+51; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+51, @PATH, 1); + +-- Waypoints and Formations for CGUID+26 +DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+26; +INSERT INTO `creature_formations`(`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@CGUID+26, @CGUID+26, 0, 0, 515, 2, 5), +(@CGUID+26, @CGUID+24, 1, 290, 515, 2, 5), +(@CGUID+26, @CGUID+21, 2, 310, 515, 2, 5), +(@CGUID+26, @CGUID+22, 1, 70, 515, 2, 5), +(@CGUID+26, @CGUID+1, 2, 50, 515, 2, 5); + +SET @PATH := @CGUID+26 * 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, 851.1424, 529.3577, 13.4811, 0, 0), +(@PATH, 1, 851.1649, 544.0087, 13.48335, 0, 0), +(@PATH, 2, 851.1215, 554.6893, 13.48332, 0, 0), +(@PATH, 3, 851.1649, 544.0087, 13.48335, 0, 0), +(@PATH, 4, 851.1424, 529.3577, 13.4811, 0, 0), +(@PATH, 5, 851.2327, 517.191, 13.48109, 0, 0); + +UPDATE `creature` SET `position_x`= 851.1424, `position_y`= 529.3577, `position_z`= 13.4811, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+26; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+26; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+26, @PATH, 1); + +-- Waypoints for CGUID+82 +SET @PATH := @CGUID+82 * 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, 1098.326, 464.776, 2.835088, 0, 0), +(@PATH, 1, 1098.568, 487.8038, 2.838317, 0, 0); + +UPDATE `creature` SET `position_x`= 1098.326, `position_y`= 464.776, `position_z`= 2.835088, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+82; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+82; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+82, @PATH, 1); + +-- Waypoints for CGUID+94 +SET @PATH := @CGUID+94 * 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, 1105.72, 464.9514, 2.860409, 0, 0), +(@PATH, 1, 1124.321, 465.441, 2.813667, 0, 0), +(@PATH, 2, 1124.29, 444.4045, 2.815916, 0, 0), +(@PATH, 3, 1124.321, 465.441, 2.813667, 0, 0); + +UPDATE `creature` SET `position_x`= 1105.72, `position_y`= 464.9514, `position_z`= 2.860409, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+94; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+94; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+94, @PATH, 1); + +-- Waypoints and Formations for CGUID+97 +DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+97; +INSERT INTO `creature_formations`(`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@CGUID+97, @CGUID+97, 0, 0, 515, 1, 3), +(@CGUID+97, @CGUID+100, 2, 270, 515, 1, 3), +(@CGUID+97, @CGUID+96, 4, 270, 515, 1, 3), +(@CGUID+97, @CGUID+99, 2, 90, 515, 1, 3), +(@CGUID+97, @CGUID+98, 4, 90, 515, 1, 3); + +SET @PATH := @CGUID+97 * 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, 1167.405, 478.5295, 12.81594, 0, 0), +(@PATH, 1, 1167.323, 458.2205, 12.81594, 0, 0), +(@PATH, 2, 1167.405, 478.5295, 12.81594, 0, 0), +(@PATH, 3, 1167.267, 506.3316, 12.81595, 0, 0); + +UPDATE `creature` SET `position_x`= 1167.405, `position_y`= 478.5295, `position_z`= 12.81594, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+97; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+97; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+97, @PATH, 1); + +-- Waypoints for CGUID+133 +SET @PATH := @CGUID+133 * 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, 1175.962, 527.7656, 14.33977, 0, 0), +(@PATH, 1, 1164.566, 527.3663, 14.34719, 0, 0), +(@PATH, 2, 1163.536, 523.5886, 14.34719, 0, 0), +(@PATH, 3, 1177.182, 527.7604, 14.33191, 0, 5279), +(@PATH, 4, 1189.859, 495.2135, 12.81985, 0, 6440), +(@PATH, 5, 1190.313, 509.4983, 12.82886, 0, 6430), +(@PATH, 6, 1189.694, 519.3316, 12.8088, 0, 0), +(@PATH, 7, 1189.595, 527.658, 12.81703, 0, 0), +(@PATH, 8, 1185.523, 527.9757, 12.81494, 0, 0); + +UPDATE `creature` SET `position_x`= 1175.962, `position_y`= 527.7656, `position_z`= 14.33977, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+133; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+133; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+133, @PATH, 1); + +-- Waypoints for CGUID+137 +SET @PATH := @CGUID+137 * 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, 1198.37, 505.6302, 12.82211, 0, 0), +(@PATH, 1, 1200.127, 505.4184, 12.81866, 0, 4066), +(@PATH, 2, 1193.62, 510.5451, 12.82649, 0, 0), +(@PATH, 3, 1189.599, 514.0781, 12.81559, 0, 0), +(@PATH, 4, 1188.914, 527.2728, 12.81784, 0, 0), +(@PATH, 5, 1179.22, 527.5851, 13.24628, 0, 0), +(@PATH, 6, 1172.28, 527.4636, 14.34719, 0, 0), +(@PATH, 7, 1165.325, 531.2396, 14.34719, 0, 3455), +(@PATH, 8, 1191.379, 527.3559, 12.8165, 0, 0), +(@PATH, 9, 1193.186, 521.033, 12.8108, 0, 0), +(@PATH, 10, 1193.125, 511.3021, 12.82409, 0, 0); + +UPDATE `creature` SET `position_x`= 1198.37, `position_y`= 505.6302, `position_z`= 12.82211, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+137; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+137; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+137, @PATH, 1); + +-- Waypoints for CGUID+188 +SET @PATH := @CGUID+188 * 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, 1189.865, 533.7917, 12.82015, 0, 0), +(@PATH, 1, 1197.828, 527.434, 12.81459, 0, 0), +(@PATH, 2, 1199.839, 527.5226, 12.81594, 0, 3594), +(@PATH, 3, 1189.679, 531.618, 12.81697, 0, 0), +(@PATH, 4, 1189.91, 539.1354, 12.80469, 0, 0), +(@PATH, 5, 1189.816, 546.2761, 12.80761, 0, 0), +(@PATH, 6, 1180.616, 549.7066, 12.81381, 0, 0), +(@PATH, 7, 1170.365, 549.408, 14.34919, 0, 0), +(@PATH, 8, 1168.809, 547.5313, 14.34919, 0, 3548), +(@PATH, 9, 1182.674, 549.4305, 12.81112, 0, 0), +(@PATH, 10, 1189.307, 548.7726, 12.79885, 0, 0); + +UPDATE `creature` SET `position_x`= 1189.865, `position_y`= 533.7917, `position_z`= 12.82015, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+188; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+188; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+188, @PATH, 1); + +-- Waypoints for CGUID+191 +SET @PATH := @CGUID+191 * 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, 1189.599, 559.882, 12.80978, 0, 4140), +(@PATH, 1, 1184.78, 549.8438, 12.80506, 0, 0), +(@PATH, 2, 1176.373, 549.6163, 14.34489, 0, 0), +(@PATH, 3, 1172.759, 549.6996, 14.34919, 0, 0), +(@PATH, 4, 1170.458, 553.3976, 14.34919, 0, 3327), +(@PATH, 5, 1176.543, 549.2344, 14.34073, 0, 0), +(@PATH, 6, 1186.267, 550.8125, 12.79952, 0, 0), +(@PATH, 7, 1189.677, 558.0868, 12.80908, 0, 0); + +UPDATE `creature` SET `position_x`= 1189.599, `position_y`= 559.882, `position_z`= 12.80978, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+191; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+191; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+191, @PATH, 1); + +-- Waypoints for CGUID+190 +SET @PATH := @CGUID+190 * 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, 1198.063, 553.7379, 12.81792, 0, 0), +(@PATH, 1, 1199.974, 553.7292, 12.81335, 0, 3878), +(@PATH, 2, 1186.563, 549.8871, 12.80138, 0, 0), +(@PATH, 3, 1176.311, 549.6233, 14.3464, 0, 0), +(@PATH, 4, 1168.141, 550.1667, 14.34919, 0, 0), +(@PATH, 5, 1167.493, 551.9774, 14.34919, 0, 18903), +(@PATH, 6, 1199.974, 553.7292, 12.81335, 0, 3859); + +UPDATE `creature` SET `position_x`= 1198.063, `position_y`= 553.7379, `position_z`= 12.81792, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+190; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+190; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+190, @PATH, 1); + +-- SAI Script for ENTRY: 58701 Stake +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry` = 58701; +DELETE FROM `smart_scripts` WHERE `entryorguid` = 58701 AND `source_type` = 0; +INSERT INTO `smart_scripts`(`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(58701, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 0, '', 11, 111350, 3, 0, 0, 0, 0, 19, 58727, 10, 0, 0, 0, 0, 0, 'OnSpawn/Respawn - cast "Cosmetic Chains" - to nearest Chained Dog Target in max. 10y');
\ No newline at end of file |