diff options
| -rw-r--r-- | sql/updates/world/master/2022_05_22_00_world.sql | 466 |
1 files changed, 466 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_05_22_00_world.sql b/sql/updates/world/master/2022_05_22_00_world.sql new file mode 100644 index 00000000000..e3dcece1a8e --- /dev/null +++ b/sql/updates/world/master/2022_05_22_00_world.sql @@ -0,0 +1,466 @@ +SET @CGUID := 395109; +SET @OGUID := 239510; + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+154; +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, 59746, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 1109.9375, 544.53472900390625, 0.081974223256111145, 2.237177848815917968, 7200, 0, 0, 7620, 0, 0, 0, 0, 0, 43345), -- Scarlet Centurion (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+1, 59746, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 1143.048583984375, 552.7430419921875, 0.296063840389251708, 2.108403205871582031, 7200, 0, 0, 7620, 0, 0, 0, 0, 0, 43345), -- Scarlet Centurion (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+2, 59746, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 1073.3038330078125, 587.9774169921875, 0.738074421882629394, 0.547464430332183837, 7200, 10, 0, 7620, 0, 1, 0, 0, 0, 43345), -- Scarlet Centurion (Area: Forlorn Cloister - Difficulty: 1) (possible waypoints or random movement) +(@CGUID+3, 59705, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 1072.986083984375, 590.32464599609375, 0.738072693347930908, 0.151742652058601379, 7200, 0, 0, 7620, 0, 0, 0, 0, 0, 43345), -- Scarlet Flamethrower (Area: Forlorn Cloister - Difficulty: 1) (Auras: ) +(@CGUID+4, 59746, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 1075.80908203125, 585.9375, 0.738076090812683105, 1.167363643646240234, 7200, 10, 0, 7620, 0, 1, 0, 0, 0, 43345), -- Scarlet Centurion (Area: Forlorn Cloister - Difficulty: 1) (possible waypoints or random movement) +(@CGUID+5, 59705, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 1145.6927490234375, 555.02606201171875, 0.181448280811309814, 2.415186166763305664, 7200, 0, 0, 7620, 0, 0, 0, 0, 0, 43345), -- Scarlet Flamethrower (Area: Forlorn Cloister - Difficulty: 1) (Auras: ) +(@CGUID+6, 59746, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 1107.66845703125, 543.4149169921875, 0.140690311789512634, 1.794417142868041992, 7200, 0, 0, 7620, 0, 0, 0, 0, 0, 43345), -- Scarlet Centurion (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+7, 59746, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 1138.77783203125, 552.50347900390625, 0.465277791023254394, 1.320500731468200683, 7200, 0, 0, 7620, 0, 0, 0, 0, 0, 43345), -- Scarlet Centurion (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+8, 59746, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 1124.2552490234375, 584.9930419921875, 1.098561286926269531, 5.406425952911376953, 7200, 0, 0, 7620, 0, 0, 0, 0, 0, 43345), -- Scarlet Centurion (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+9, 59722, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1139.751708984375, 559.50518798828125, 0.513276636600494384, 4.505911827087402343, 7200, 0, 0, 2286, 0, 0, 0, 0, 0, 43345), -- Pile of Corpses (Area: Forlorn Cloister - Difficulty: 1) (Auras: 114951 - Pile of Corpses) +(@CGUID+10, 64827, 1004, 6109, 6384, '1', 1443, 0, 0, 1, 1122.0572509765625, 522.67535400390625, 0.741729438304901123, 2.087583303451538085, 7200, 0, 0, 1604, 852, 0, 0, 0, 0, 43345), -- Hooded Crusader (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+11, 59746, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 1127.2222900390625, 585.1319580078125, 1.099356412887573242, 4.6183013916015625, 7200, 0, 0, 7620, 0, 0, 0, 0, 0, 43345), -- Scarlet Centurion (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+12, 59789, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 1124.71533203125, 688.51214599609375, 1.315146446228027343, 4.758397102355957031, 7200, 0, 0, 41950, 0, 0, 0, 0, 0, 43345), -- Thalnos the Soulrender (Area: Forlorn Cloister - Difficulty: 1) (Auras: 126653 - Cosmetic Visual) +(@CGUID+13, 59722, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1078.282958984375, 591.09722900390625, 0.738076090812683105, 0, 7200, 0, 0, 2286, 0, 0, 0, 0, 0, 43345), -- Pile of Corpses (Area: Forlorn Cloister - Difficulty: 1) (Auras: 114951 - Pile of Corpses) +(@CGUID+14, 59722, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1171.4288330078125, 553.43927001953125, 0.738077759742736816, 0, 7200, 0, 0, 2286, 0, 0, 0, 0, 0, 43345), -- Pile of Corpses (Area: Forlorn Cloister - Difficulty: 1) (Auras: 114951 - Pile of Corpses) +(@CGUID+15, 59722, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1126.6163330078125, 580.7586669921875, 1.074611663818359375, 3.928114652633666992, 7200, 0, 0, 2286, 0, 0, 0, 0, 0, 43345), -- Pile of Corpses (Area: Forlorn Cloister - Difficulty: 1) (Auras: 114951 - Pile of Corpses) +(@CGUID+16, 59705, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 1104.6771240234375, 543.13018798828125, 0.25874406099319458, 1.164664268493652343, 7200, 0, 0, 7620, 0, 0, 0, 0, 0, 43345), -- Scarlet Flamethrower (Area: Forlorn Cloister - Difficulty: 1) (Auras: ) +(@CGUID+17, 59705, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 1170.970458984375, 548.671875, 0.738079488277435302, 1.569302320480346679, 7200, 0, 0, 7620, 0, 0, 0, 0, 0, 43345), -- Scarlet Flamethrower (Area: Forlorn Cloister - Difficulty: 1) (Auras: ) +(@CGUID+18, 59722, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1106.1197509765625, 548.842041015625, 0.384861081838607788, 4.770580291748046875, 7200, 0, 0, 2286, 0, 0, 0, 0, 0, 43345), -- Pile of Corpses (Area: Forlorn Cloister - Difficulty: 1) (Auras: 114951 - Pile of Corpses) +(@CGUID+19, 59705, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 1129.9375, 584.248291015625, 1.094351530075073242, 3.9961700439453125, 7200, 0, 0, 7620, 0, 0, 0, 0, 0, 43345), -- Scarlet Flamethrower (Area: Forlorn Cloister - Difficulty: 1) (Auras: ) +(@CGUID+20, 59746, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 1175.017333984375, 549.88018798828125, 0.738074421882629394, 2.375252485275268554, 7200, 0, 0, 7620, 0, 0, 0, 0, 0, 43345), -- Scarlet Centurion (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+21, 59746, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 1175.373291015625, 557.63714599609375, 0.738074421882629394, 3.854184150695800781, 7200, 0, 0, 7620, 0, 0, 0, 0, 0, 43345), -- Scarlet Centurion (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+22, 59705, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 1139.8367919921875, 618.7257080078125, 0.274204671382904052, 4.112521648406982421, 7200, 0, 0, 7620, 0, 0, 0, 0, 0, 43345), -- Scarlet Flamethrower (Area: Forlorn Cloister - Difficulty: 1) (Auras: ) +(@CGUID+23, 59746, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 1133.9896240234375, 617.03125, 0.832947611808776855, 5.130477428436279296, 7200, 0, 0, 7620, 0, 0, 0, 0, 0, 43345), -- Scarlet Centurion (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+24, 59746, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 1136.9427490234375, 619.20489501953125, 0.546218931674957275, 4.518032550811767578, 7200, 0, 0, 7620, 0, 0, 0, 0, 0, 43345), -- Scarlet Centurion (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115511 - Retaliation) +(@CGUID+25, 59722, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1137.1319580078125, 614.2430419921875, 0.435763895511627197, 0, 7200, 0, 0, 2286, 0, 0, 0, 0, 0, 43345), -- Pile of Corpses (Area: Forlorn Cloister - Difficulty: 1) (Auras: 114951 - Pile of Corpses) +(@CGUID+26, 58590, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 1036.782958984375, 598.26214599609375, 0.427690953016281127, 2.967059612274169921, 7200, 0, 0, 8020, 1870, 0, 0, 0, 0, 43345), -- Scarlet Zealot (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+27, 58555, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1033.484375, 600.0225830078125, 0.428062230348587036, 5.427973747253417968, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Fanatic (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+28, 58569, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 1033.6302490234375, 596.234375, 0.427592605352401733, 1.01229095458984375, 7200, 0, 0, 5132, 4724, 0, 0, 0, 0, 43345), -- Scarlet Purifier (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+29, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1082.7396240234375, 671.7242431640625, 1.697984933853149414, 4.722390651702880859, 7200, 4, 0, 1524, 0, 1, 0, 0, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+30, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1103.1956787109375, 674.30010986328125, 1.549743533134460449, 0.581176161766052246, 7200, 4, 0, 1524, 0, 1, 0, 0, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+31, 58605, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 1050.3004150390625, 633.77081298828125, 1.126108407974243164, 4.599108219146728515, 7200, 0, 0, 8020, 0, 0, 0, 0, 0, 43345), -- Scarlet Judicator (Area: Forlorn Cloister - Difficulty: 1) (Auras: 128800 - Drunk) +(@CGUID+32, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1155.7750244140625, 665.41204833984375, 2.71191716194152832, 4.958417415618896484, 7200, 4, 0, 1524, 0, 1, 0, 0, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+33, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1166.4024658203125, 664.02069091796875, 2.70703434944152832, 0.17936640977859497, 7200, 4, 0, 1524, 0, 1, 0, 0, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+34, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1093.3533935546875, 662.13287353515625, 1.704046964645385742, 2.53034377098083496, 7200, 4, 0, 1524, 0, 1, 0, 0, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+35, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1168.5306396484375, 676.32330322265625, 2.528564453125, 1.796083927154541015, 7200, 4, 0, 1524, 0, 1, 0, 0, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+36, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1163.9893798828125, 669.2222900390625, 2.761507749557495117, 4.984951972961425781, 7200, 4, 0, 1524, 0, 1, 0, 0, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+37, 58605, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 1047.15625, 651.1632080078125, 1.141776680946350097, 3.05529332160949707, 7200, 0, 0, 8020, 0, 0, 0, 0, 0, 43345), -- Scarlet Judicator (Area: Forlorn Cloister - Difficulty: 1) (Auras: 128800 - Drunk) +(@CGUID+38, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1094.6827392578125, 677.21099853515625, 0.561903953552246093, 3.342252016067504882, 7200, 4, 0, 1524, 0, 1, 0, 0, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+39, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1092.04296875, 675.083740234375, 0.20458725094795227, 5.528512477874755859, 7200, 4, 0, 1524, 0, 1, 0, 0, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+40, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1090.5264892578125, 676.87005615234375, 0.198758766055107116, 3.828763484954833984, 7200, 4, 0, 1524, 0, 1, 0, 0, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+41, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1172.317138671875, 669.5377197265625, 2.6343994140625, 4.835579395294189453, 7200, 4, 0, 1524, 0, 1, 0, 0, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+42, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1163.961181640625, 681.5750732421875, 1.907264113426208496, 0.7398529052734375, 7200, 4, 0, 1524, 0, 1, 0, 0, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+43, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1153.99072265625, 707.79437255859375, 15.59815311431884765, 0.1506253182888031, 7200, 4, 0, 1524, 0, 1, 0, 33587200, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+44, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1166.875244140625, 709.68389892578125, 16.05526351928710937, 3.343551158905029296, 7200, 4, 0, 1524, 0, 1, 0, 33587200, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+45, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1093.244873046875, 715.68084716796875, 22.45142173767089843, 5.495411872863769531, 7200, 4, 0, 1524, 0, 1, 0, 33587200, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+46, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1086.2506103515625, 714.756591796875, 22.40993499755859375, 1.636744141578674316, 7200, 4, 0, 1524, 0, 1, 0, 33587200, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+47, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1079.188232421875, 704.60931396484375, 22.31425857543945312, 4.961771965026855468, 7200, 4, 0, 1524, 0, 1, 0, 33587200, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+48, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1090.599853515625, 703.71588134765625, 21.81208419799804687, 0.465483993291854858, 7200, 4, 0, 1524, 0, 1, 0, 33587200, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+49, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1161.363525390625, 714.7449951171875, 16.01024627685546875, 1.345113158226013183, 7200, 4, 0, 1524, 0, 1, 0, 33587200, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+50, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1160.83935546875, 715.43914794921875, 16.22253608703613281, 5.457734107971191406, 7200, 4, 0, 1524, 0, 1, 0, 33587200, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+51, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1164.4892578125, 704.31646728515625, 15.4451141357421875, 0.678982198238372802, 7200, 4, 0, 1524, 0, 1, 0, 33587200, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+52, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1094.8533935546875, 708.7664794921875, 21.99460411071777343, 4.24237680435180664, 7200, 4, 0, 1524, 0, 1, 0, 33587200, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+53, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1087.596435546875, 717.47772216796875, 22.52738571166992187, 6.242808818817138671, 7200, 4, 0, 1524, 0, 1, 0, 33587200, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+54, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1124.3702392578125, 734.94073486328125, 28.78701591491699218, 6.10919189453125, 7200, 4, 0, 1524, 0, 1, 0, 33587200, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+55, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1110.3753662109375, 731.44488525390625, 30.91811180114746093, 3.079877376556396484, 7200, 4, 0, 1524, 0, 1, 0, 33587200, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+56, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1122.96728515625, 723.06500244140625, 32.51914215087890625, 4.75276947021484375, 7200, 4, 0, 1524, 0, 1, 0, 33587200, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+57, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1169.1649169921875, 716.55999755859375, 16.46749114990234375, 5.949561119079589843, 7200, 4, 0, 1524, 0, 1, 0, 33587200, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+58, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1130.37890625, 733.34466552734375, 29.03057861328125, 4.448268890380859375, 7200, 4, 0, 1524, 0, 1, 0, 33587200, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+59, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1116.5745849609375, 740.56597900390625, 28.92258262634277343, 3.394371271133422851, 7200, 4, 0, 1524, 0, 1, 0, 33587200, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+60, 60033, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 1128.3048095703125, 743.5618896484375, 29.05166816711425781, 0.732173800468444824, 7200, 4, 0, 1524, 0, 1, 0, 33587200, 0, 43345), -- Frenzied Spirit (Area: Forlorn Cloister - Difficulty: 1) (Auras: 115523 - Frenzied Spirit) +(@CGUID+61, 58569, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 1013.5521240234375, 643.21527099609375, 1.260477781295776367, 2.216568231582641601, 7200, 0, 0, 5132, 4724, 0, 0, 0, 0, 43345), -- Scarlet Purifier (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+62, 58569, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 1011.2257080078125, 645.66668701171875, 1.260476112365722656, 5.497786998748779296, 7200, 0, 0, 5132, 4724, 0, 0, 0, 0, 43345), -- Scarlet Purifier (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+63, 58605, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 995.7569580078125, 631.50177001953125, 0.940972208976745605, 0.965424656867980957, 7200, 0, 0, 8020, 0, 0, 0, 0, 0, 43345), -- Scarlet Judicator (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+64, 58605, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 999.9461669921875, 627.578125, 0.908070802688598632, 0.649475753307342529, 7200, 0, 0, 8020, 0, 0, 0, 0, 0, 43345), -- Scarlet Judicator (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+65, 58605, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 984.68231201171875, 614.47052001953125, 0.767247498035430908, 4.327502727508544921, 7200, 0, 0, 8020, 0, 0, 0, 0, 0, 43345), -- Scarlet Judicator (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+66, 58590, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 992.72283935546875, 590.56866455078125, 0.783931136131286621, 4.702386856079101562, 7200, 10, 0, 8020, 1870, 1, 0, 0, 0, 43345), -- Scarlet Zealot (Area: Forlorn Cloister - Difficulty: 1) (possible waypoints or random movement) +(@CGUID+67, 58555, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 970.34722900390625, 641.2413330078125, 1.260454058647155761, 1.221730470657348632, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Fanatic (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+68, 58605, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 984.53302001953125, 610.703125, 0.767247498035430908, 3.019266128540039062, 7200, 0, 0, 8020, 0, 0, 0, 0, 0, 43345), -- Scarlet Judicator (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+69, 58569, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 973.09027099609375, 645.15802001953125, 1.260459065437316894, 3.59537816047668457, 7200, 0, 0, 5132, 4724, 0, 0, 0, 0, 43345), -- Scarlet Purifier (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+70, 58590, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 968.15802001953125, 645.373291015625, 1.260457396507263183, 5.777040004730224609, 7200, 0, 0, 8020, 1870, 0, 0, 0, 0, 43345), -- Scarlet Zealot (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+71, 58569, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 985.97222900390625, 598.2899169921875, 0.767247498035430908, 3.109818935394287109, 7200, 0, 0, 5132, 4724, 0, 0, 0, 0, 43345), -- Scarlet Purifier (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+72, 58569, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 993.420166015625, 577.02777099609375, 1.186687707901000976, 1.01229095458984375, 7200, 0, 0, 5132, 4724, 0, 0, 0, 0, 43345), -- Scarlet Purifier (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+73, 58569, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 985.421875, 595.70831298828125, 0.767247498035430908, 1.966287493705749511, 7200, 0, 0, 5132, 4724, 0, 0, 0, 0, 43345), -- Scarlet Purifier (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+74, 58555, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 993.2742919921875, 580.81597900390625, 1.119306087493896484, 5.427973747253417968, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Fanatic (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+75, 58590, 1004, 6109, 6384, '1,2', 0, 0, 0, 1, 996.57293701171875, 579.0555419921875, 1.375, 2.967059612274169921, 7200, 0, 0, 8020, 1870, 0, 0, 0, 0, 43345), -- Scarlet Zealot (Area: Forlorn Cloister - Difficulty: 1) +(@CGUID+76, 60197, 1004, 6109, 6384, '1,2', 0, 0, 0, 0, 982.68231201171875, 598.47918701171875, 0.767247498035430908, 0, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 43345), -- Training Dummy (Area: Forlorn Cloister - Difficulty: 1) (Auras: 98892 - Training Dummy Marker) +(@CGUID+77, 58569, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 984.35516357421875, 567.36798095703125, 1.160874247550964355, 0.004193613771349191, 7200, 0, 0, 5132, 4724, 0, 0, 0, 0, 43345), -- Scarlet Purifier (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+78, 59223, 1004, 6109, 6386, '1,2', 0, 0, 0, 0, 858.4910888671875, 598.55535888671875, 10.05390548706054687, 1.835566997528076171, 7200, 0, 0, 43825, 0, 0, 0, 0, 0, 43345), -- Brother Korloff (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+79, 64854, 1004, 6109, 6386, '1', 1443, 0, 0, 0, 961.35589599609375, 605.49481201171875, 0.926281332969665527, 0.236222386360168457, 7200, 0, 0, 2013, 0, 0, 0, 0, 0, 43345), -- Blade of the Anointed (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+80, 58569, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 967.45489501953125, 565.85589599609375, 1.260460853576660156, 0.541052043437957763, 7200, 0, 0, 5132, 4724, 0, 0, 0, 0, 43345), -- Scarlet Purifier (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+81, 58555, 1004, 6109, 6386, '1,2', 0, 0, 0, 0, 969.96527099609375, 569.75, 1.260455727577209472, 4.450589656829833984, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Fanatic (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+82, 58590, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 972.39581298828125, 565.9305419921875, 1.260462522506713867, 2.722713708877563476, 7200, 0, 0, 8020, 1870, 0, 0, 0, 0, 43345), -- Scarlet Zealot (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+83, 58605, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 938.97052001953125, 627.23956298828125, 1.260438799858093261, 4.712388992309570312, 7200, 0, 0, 8020, 0, 0, 0, 0, 0, 43345), -- Scarlet Judicator (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+84, 58605, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 938.951416015625, 623.9132080078125, 1.260440468788146972, 1.518436431884765625, 7200, 0, 0, 8020, 0, 0, 0, 0, 0, 43345), -- Scarlet Judicator (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+85, 58569, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 938.76214599609375, 644.00518798828125, 1.260445594787597656, 0.01745329238474369, 7200, 10, 0, 5132, 4724, 1, 0, 0, 0, 43345), -- Scarlet Purifier (Area: Chapel Gardens - Difficulty: 1) (possible waypoints or random movement) +(@CGUID+86, 58590, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 946.04339599609375, 584.092041015625, 0.767247557640075683, 6.161012172698974609, 7200, 0, 0, 8020, 1870, 0, 0, 0, 0, 43345), -- Scarlet Zealot (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+87, 58605, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 948.76739501953125, 583.98614501953125, 0.767247557640075683, 3.071779489517211914, 7200, 0, 0, 8020, 0, 0, 0, 0, 0, 43345), -- Scarlet Judicator (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+88, 58590, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 937.140625, 625.40802001953125, 1.260445594787597656, 0, 7200, 0, 0, 8020, 1870, 0, 0, 0, 0, 43345), -- Scarlet Zealot (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+89, 58569, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 946.29168701171875, 582.22222900390625, 0.758954405784606933, 6.143558979034423828, 7200, 0, 0, 5132, 4724, 0, 0, 0, 0, 43345), -- Scarlet Purifier (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+90, 58569, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 948.8524169921875, 582.140625, 0.775043725967407226, 3.193952560424804687, 7200, 0, 0, 5132, 4724, 0, 0, 0, 0, 43345), -- Scarlet Purifier (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+91, 58555, 1004, 6109, 6386, '1,2', 0, 0, 0, 0, 915.12677001953125, 550.734375, 11.72920417785644531, 6.17846536636352539, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Fanatic (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+92, 58590, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 916.98089599609375, 549.80902099609375, 11.72919654846191406, 3.159045934677124023, 7200, 0, 0, 8020, 1870, 0, 0, 0, 0, 43345), -- Scarlet Zealot (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+93, 58605, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 916.77777099609375, 663.27081298828125, 11.72920417785644531, 5.288347721099853515, 7200, 0, 0, 8020, 0, 0, 0, 0, 0, 43345), -- Scarlet Judicator (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+94, 58555, 1004, 6109, 6386, '1,2', 0, 0, 0, 0, 915.2586669921875, 549.01910400390625, 11.72920036315917968, 6.2657318115234375, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Fanatic (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+95, 58569, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 918.5069580078125, 660.72052001953125, 11.72919273376464843, 2.059488534927368164, 7200, 0, 0, 5132, 4724, 0, 0, 0, 0, 43345), -- Scarlet Purifier (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+96, 64446, 1004, 6109, 6386, '1,2', 0, 0, 0, 0, 903.609375, 562.01739501953125, 10.63365936279296875, 1.550858855247497558, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 43345), -- Training Dummy (Area: Chapel Gardens - Difficulty: 1) (Auras: 98892 - Training Dummy Marker) +(@CGUID+97, 64446, 1004, 6109, 6386, '1,2', 0, 0, 0, 0, 899.97918701171875, 562.03125, 10.55350589752197265, 1.684665083885192871, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 43345), -- Training Dummy (Area: Chapel Gardens - Difficulty: 1) (Auras: 98892 - Training Dummy Marker) +(@CGUID+98, 58555, 1004, 6109, 6386, '1,2', 0, 0, 0, 0, 900.13018798828125, 563.56768798828125, 10.48814582824707031, 4.592707633972167968, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Fanatic (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+99, 64446, 1004, 6109, 6386, '1,2', 0, 0, 0, 0, 903.32293701171875, 649.546875, 10.30208301544189453, 4.65209197998046875, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 43345), -- Training Dummy (Area: Chapel Gardens - Difficulty: 1) (Auras: 98892 - Training Dummy Marker) +(@CGUID+100, 58555, 1004, 6109, 6386, '1,2', 0, 0, 0, 0, 903.765625, 563.46356201171875, 10.61150741577148437, 4.722781658172607421, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Fanatic (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+101, 64446, 1004, 6109, 6386, '1,2', 0, 0, 0, 0, 896.53302001953125, 562.22222900390625, 10.47829437255859375, 1.611341357231140136, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 43345), -- Training Dummy (Area: Chapel Gardens - Difficulty: 1) (Auras: 98892 - Training Dummy Marker) +(@CGUID+102, 64446, 1004, 6109, 6386, '1,2', 0, 0, 0, 0, 899.6944580078125, 649.560791015625, 10.21358203887939453, 4.661051273345947265, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 43345), -- Training Dummy (Area: Chapel Gardens - Difficulty: 1) (Auras: 98892 - Training Dummy Marker) +(@CGUID+103, 58590, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 893.78790283203125, 661.27862548828125, 11.63098335266113281, 6.278508186340332031, 7200, 10, 0, 8020, 1870, 1, 0, 0, 0, 43345), -- Scarlet Zealot (Area: Chapel Gardens - Difficulty: 1) (possible waypoints or random movement) +(@CGUID+104, 58555, 1004, 6109, 6386, '1,2', 0, 0, 0, 0, 896.57464599609375, 563.625, 10.37731647491455078, 4.665303707122802734, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Fanatic (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+105, 58555, 1004, 6109, 6386, '1,2', 0, 0, 0, 0, 885.14410400390625, 629.263916015625, 11.42142200469970703, 5.238763809204101562, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Fanatic (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+106, 64446, 1004, 6109, 6386, '1,2', 0, 0, 0, 0, 896.24652099609375, 649.75177001953125, 10.12673568725585937, 4.6787872314453125, 7200, 0, 0, 1, 0, 0, 0, 0, 0, 43345), -- Training Dummy (Area: Chapel Gardens - Difficulty: 1) (Auras: 98892 - Training Dummy Marker) +(@CGUID+107, 58555, 1004, 6109, 6386, '1,2', 0, 0, 0, 0, 887.482666015625, 630.03302001953125, 11.421417236328125, 5.06145477294921875, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Fanatic (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+108, 58555, 1004, 6109, 6386, '1,2', 0, 0, 0, 0, 889.54864501953125, 631.09552001953125, 11.42142009735107421, 4.991641521453857421, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Fanatic (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+109, 58555, 1004, 6109, 6386, '1,2', 0, 0, 0, 0, 861.19268798828125, 625.56427001953125, 10.11534500122070312, 4.642575740814208984, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Fanatic (Area: Chapel Gardens - Difficulty: 1) (Auras: 110954 - Hands of Purity) +(@CGUID+110, 58555, 1004, 6109, 6386, '1,2', 0, 0, 0, 0, 864.47918701171875, 585.70831298828125, 10.19092464447021484, 1.675516128540039062, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Fanatic (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+111, 58555, 1004, 6109, 6386, '1,2', 0, 0, 0, 0, 864.75347900390625, 625.54339599609375, 10.34755897521972656, 4.468042850494384765, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Fanatic (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+112, 58555, 1004, 6109, 6386, '1,2', 0, 0, 0, 0, 857.10418701171875, 625.578125, 10.07245540618896484, 4.834561824798583984, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Fanatic (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+113, 58555, 1004, 6109, 6386, '1,2', 0, 0, 0, 0, 856.842041015625, 586.16668701171875, 10.07245540618896484, 1.308996915817260742, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Fanatic (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+114, 58555, 1004, 6109, 6386, '1,2', 0, 0, 0, 0, 860.92364501953125, 585.92535400390625, 10.08468055725097656, 1.518436431884765625, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Fanatic (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+115, 60040, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 747.96527099609375, 605.97052001953125, 15.11051368713378906, 6.239861011505126953, 7200, 0, 0, 17530, 0, 0, 0, 0, 0, 43345), -- Commander Durand (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+116, 58569, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 811.8350830078125, 582.560791015625, 12.89025688171386718, 4.694935798645019531, 7200, 0, 0, 5132, 4724, 0, 0, 0, 0, 43345), -- Scarlet Purifier (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+117, 58569, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 811.9132080078125, 628.28125, 12.88993453979492187, 1.500983119010925292, 7200, 0, 0, 5132, 4724, 0, 0, 0, 0, 43345), -- Scarlet Purifier (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+118, 3977, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 700.53302001953125, 605.763916015625, 11.59242439270019531, 6.195918560028076171, 7200, 0, 0, 14024, 5525, 0, 0, 0, 0, 43345), -- High Inquisitor Whitemane (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+119, 58569, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 793.02081298828125, 582.765625, 12.89106178283691406, 4.694935798645019531, 7200, 0, 0, 5132, 4724, 0, 0, 0, 0, 43345), -- Scarlet Purifier (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+120, 58569, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 803.77081298828125, 614.44793701171875, 12.88638496398925781, 0.621372997760772705, 7200, 0, 0, 5132, 4724, 0, 0, 0, 0, 43345), -- Scarlet Purifier (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+121, 58555, 1004, 6109, 6386, '1,2', 0, 0, 0, 0, 803.86114501953125, 616.77606201171875, 12.8852386474609375, 5.621012687683105468, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Fanatic (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+122, 58555, 1004, 6109, 6386, '1,2', 0, 0, 0, 0, 806.90972900390625, 616.24481201171875, 12.88578319549560546, 3.541357040405273437, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Fanatic (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+123, 58590, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 806.90802001953125, 614.27081298828125, 12.88633632659912109, 2.428856611251831054, 7200, 0, 0, 8020, 1870, 0, 0, 0, 0, 43345), -- Scarlet Zealot (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+124, 58569, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 785.53472900390625, 598.6632080078125, 12.88624191284179687, 5.325046062469482421, 7200, 0, 0, 5132, 4724, 0, 0, 0, 0, 43345), -- Scarlet Purifier (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+125, 58569, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 793.19097900390625, 628.5242919921875, 12.8903961181640625, 1.500983119010925292, 7200, 0, 0, 5132, 4724, 0, 0, 0, 0, 43345), -- Scarlet Purifier (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+126, 58555, 1004, 6109, 6386, '1,2', 0, 0, 0, 0, 785.27081298828125, 595.61114501953125, 12.8832550048828125, 0.766644179821014404, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Fanatic (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+127, 58555, 1004, 6109, 6386, '1,2', 0, 0, 0, 0, 788.15106201171875, 598.42364501953125, 12.886383056640625, 3.921834945678710937, 7200, 0, 0, 4812, 0, 0, 0, 0, 0, 43345), -- Scarlet Fanatic (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+128, 58590, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 788.0225830078125, 595.38543701171875, 12.88447856903076171, 2.255929231643676757, 7200, 0, 0, 8020, 1870, 0, 0, 0, 0, 43345), -- Scarlet Zealot (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+129, 58569, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 788.3172607421875, 624.34283447265625, 12.79489803314208984, 3.154498100280761718, 7200, 10, 0, 5132, 4724, 1, 0, 0, 0, 43345), -- Scarlet Purifier (Area: Chapel Gardens - Difficulty: 1) (possible waypoints or random movement) +(@CGUID+130, 58783, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 761.40277099609375, 663.388916015625, 12.88508892059326171, 4.660028934478759765, 7200, 0, 0, 1245, 756, 0, 0, 0, 0, 43345), -- Scarlet Initiate (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+131, 58605, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 758.92535400390625, 548.0538330078125, 12.88260459899902343, 4.014257431030273437, 7200, 0, 0, 8020, 0, 0, 0, 570720320, 0, 43345), -- Scarlet Judicator (Area: Chapel Gardens - Difficulty: 1) (Auras: 111672 - Resurrect Requirement, 96733 - Permanent Feign Death (Stun)) +(@CGUID+132, 58605, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 767.9444580078125, 543.68231201171875, 12.88750076293945312, 0.01745329238474369, 7200, 0, 0, 8020, 0, 0, 0, 570720320, 0, 43345), -- Scarlet Judicator (Area: Chapel Gardens - Difficulty: 1) (Auras: 111672 - Resurrect Requirement, 96733 - Permanent Feign Death (Stun)) +(@CGUID+133, 58605, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 770.4305419921875, 549.9375, 12.88748073577880859, 1.65806281566619873, 7200, 0, 0, 8020, 0, 0, 0, 570720320, 0, 43345), -- Scarlet Judicator (Area: Chapel Gardens - Difficulty: 1) (Auras: 111672 - Resurrect Requirement, 96733 - Permanent Feign Death (Stun)) +(@CGUID+134, 58590, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 760.76214599609375, 551.482666015625, 12.88635444641113281, 4.677482128143310546, 7200, 0, 0, 8020, 1870, 0, 0, 0, 0, 43345), -- Scarlet Zealot (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+135, 58605, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 756.576416015625, 550.28643798828125, 12.88434028625488281, 6.213372230529785156, 7200, 0, 0, 8020, 0, 0, 0, 570720320, 0, 43345), -- Scarlet Judicator (Area: Chapel Gardens - Difficulty: 1) (Auras: 111672 - Resurrect Requirement, 96733 - Permanent Feign Death (Stun)) +(@CGUID+136, 58605, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 755.3367919921875, 544.25518798828125, 12.88449954986572265, 1.239183783531188964, 7200, 0, 0, 8020, 0, 0, 0, 570720320, 0, 43345), -- Scarlet Judicator (Area: Chapel Gardens - Difficulty: 1) (Auras: 111672 - Resurrect Requirement, 96733 - Permanent Feign Death (Stun)) +(@CGUID+137, 58783, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 758.01043701171875, 663.4305419921875, 12.88620948791503906, 4.660028934478759765, 7200, 0, 0, 1245, 756, 0, 0, 0, 0, 43345), -- Scarlet Initiate (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+138, 58605, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 761.47222900390625, 546.904541015625, 12.88402557373046875, 1.221730470657348632, 7200, 0, 0, 8020, 0, 0, 0, 570720320, 0, 43345), -- Scarlet Judicator (Area: Chapel Gardens - Difficulty: 1) (Auras: 111672 - Resurrect Requirement, 96733 - Permanent Feign Death (Stun)) +(@CGUID+139, 58783, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 764.638916015625, 663.43402099609375, 12.88397693634033203, 4.660028934478759765, 7200, 0, 0, 1245, 756, 0, 0, 0, 0, 43345), -- Scarlet Initiate (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+140, 58605, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 763.875, 543.89239501953125, 12.88635826110839843, 5.078907966613769531, 7200, 0, 0, 8020, 0, 0, 0, 570720320, 0, 43345), -- Scarlet Judicator (Area: Chapel Gardens - Difficulty: 1) (Auras: 111672 - Resurrect Requirement, 96733 - Permanent Feign Death (Stun)) +(@CGUID+141, 4542, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 743.57293701171875, 649.48089599609375, 12.88829994201660156, 0.860329926013946533, 7200, 0, 0, 40100, 2566, 0, 0, 0, 0, 43345), -- High Inquisitor Fairbanks (Area: Chapel Gardens - Difficulty: 1) (Auras: 111672 - Resurrect Requirement, 96733 - Permanent Feign Death (Stun), 8278 - Invisibility Detection) +(@CGUID+142, 58605, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 763.0711669921875, 550.67706298828125, 12.88516712188720703, 4.136430263519287109, 7200, 0, 0, 8020, 0, 0, 0, 0, 0, 43345), -- Scarlet Judicator (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+143, 58605, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 752.3211669921875, 546.02777099609375, 12.88773822784423828, 0.593411922454833984, 7200, 0, 0, 8020, 0, 0, 0, 570720320, 0, 43345), -- Scarlet Judicator (Area: Chapel Gardens - Difficulty: 1) (Auras: 111672 - Resurrect Requirement, 96733 - Permanent Feign Death (Stun)) +(@CGUID+144, 58783, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 764.20831298828125, 659.8507080078125, 12.88594722747802734, 4.660028934478759765, 7200, 0, 0, 1245, 756, 0, 0, 0, 0, 43345), -- Scarlet Initiate (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+145, 58605, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 765.295166015625, 546.9375, 12.88524055480957031, 3.438298702239990234, 7200, 0, 0, 8020, 0, 0, 0, 570720320, 0, 43345), -- Scarlet Judicator (Area: Chapel Gardens - Difficulty: 1) (Auras: 111672 - Resurrect Requirement, 96733 - Permanent Feign Death (Stun)) +(@CGUID+146, 58590, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 761.0069580078125, 655.732666015625, 12.88912773132324218, 1.500983119010925292, 7200, 0, 0, 8020, 1870, 0, 0, 0, 0, 43345), -- Scarlet Zealot (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+147, 58783, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 761.1875, 659.90277099609375, 12.88694095611572265, 4.660028934478759765, 7200, 0, 0, 1245, 756, 0, 0, 0, 0, 43345), -- Scarlet Initiate (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+148, 58605, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 758.6632080078125, 544.07293701171875, 12.88458442687988281, 5.864306449890136718, 7200, 0, 0, 8020, 0, 0, 0, 570720320, 0, 43345), -- Scarlet Judicator (Area: Chapel Gardens - Difficulty: 1) (Auras: 111672 - Resurrect Requirement, 96733 - Permanent Feign Death (Stun)) +(@CGUID+149, 58783, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 757.9132080078125, 660.12152099609375, 12.88793087005615234, 4.660028934478759765, 7200, 0, 0, 1245, 756, 0, 0, 0, 0, 43345), -- Scarlet Initiate (Area: Chapel Gardens - Difficulty: 1) +(@CGUID+150, 58605, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 767.08331298828125, 551.015625, 12.88738918304443359, 1.099557399749755859, 7200, 0, 0, 8020, 0, 0, 0, 570720320, 0, 43345), -- Scarlet Judicator (Area: Chapel Gardens - Difficulty: 1) (Auras: 111672 - Resurrect Requirement, 96733 - Permanent Feign Death (Stun)) +(@CGUID+151, 58605, 1004, 6109, 6386, '1,2', 0, 0, 0, 1, 753.154541015625, 550.77777099609375, 12.88586997985839843, 0.890117883682250976, 7200, 0, 0, 8020, 0, 0, 0, 570720320, 0, 43345), -- Scarlet Judicator (Area: Chapel Gardens - Difficulty: 1) (Auras: 111672 - Resurrect Requirement, 96733 - Permanent Feign Death (Stun)) +(@CGUID+152, 58605, 1004, 6109, 0, '1,2', 0, 0, 0, 1, 768.95831298828125, 547.529541015625, 12.88637542724609375, 3.298672199249267578, 7200, 0, 0, 8020, 0, 0, 0, 570720320, 0, 43345), -- Scarlet Judicator (Area: 0 - Difficulty: 1) (Auras: 111672 - Resurrect Requirement; 96733 - Permanent Feign Death (Stun)) +(@CGUID+153, 64838, 1004, 6109, 6384, '2', 1445, 0, 0, 1, 1122.0572509765625, 522.67535400390625, 0.741729438304901123, 2.087583303451538085, 7200, 0, 0, 2058, 1097, 0, 0, 0, 0, 43345), -- Hooded Crusader (Area: Forlorn Cloister - Difficulty: 2) +(@CGUID+154, 64855, 1004, 6109, 6386, '2', 1445, 0, 0, 0, 961.35589599609375, 605.49481201171875, 0.926281332969665527, 0.236222386360168457, 7200, 0, 0, 2423, 0, 0, 0, 0, 0, 43345); -- Blade of the Anointed (Area: Chapel Gardens - Difficulty: 2) + +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+153; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+10, 0, 0, 0, 1, 333, 0, 0, 0, 0, ''), -- Hooded Crusader +(@CGUID+31, 0, 0, 0, 1, 426, 0, 0, 0, 0, '128800'), -- Scarlet Judicator - 128800 - Drunk +(@CGUID+37, 0, 0, 0, 1, 426, 0, 0, 0, 0, '128800'), -- Scarlet Judicator - 128800 - Drunk +(@CGUID+105, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Scarlet Fanatic +(@CGUID+107, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Scarlet Fanatic +(@CGUID+108, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Scarlet Fanatic +(@CGUID+131, 0, 0, 0, 1, 0, 0, 0, 0, 0, '111672 96733'), -- Scarlet Judicator - 111672 - Resurrect Requirement, 96733 - Permanent Feign Death (Stun) +(@CGUID+132, 0, 0, 0, 1, 0, 0, 0, 0, 0, '111672 96733'), -- Scarlet Judicator - 111672 - Resurrect Requirement, 96733 - Permanent Feign Death (Stun) +(@CGUID+133, 0, 0, 0, 1, 0, 0, 0, 0, 0, '111672 96733'), -- Scarlet Judicator - 111672 - Resurrect Requirement, 96733 - Permanent Feign Death (Stun) +(@CGUID+135, 0, 0, 0, 1, 0, 0, 0, 0, 0, '111672 96733'), -- Scarlet Judicator - 111672 - Resurrect Requirement, 96733 - Permanent Feign Death (Stun) +(@CGUID+136, 0, 0, 0, 1, 0, 0, 0, 0, 0, '111672 96733'), -- Scarlet Judicator - 111672 - Resurrect Requirement, 96733 - Permanent Feign Death (Stun) +(@CGUID+138, 0, 0, 0, 1, 0, 0, 0, 0, 0, '111672 96733'), -- Scarlet Judicator - 111672 - Resurrect Requirement, 96733 - Permanent Feign Death (Stun) +(@CGUID+140, 0, 0, 0, 1, 0, 0, 0, 0, 0, '111672 96733'), -- Scarlet Judicator - 111672 - Resurrect Requirement, 96733 - Permanent Feign Death (Stun) +(@CGUID+143, 0, 0, 0, 1, 0, 0, 0, 0, 0, '111672 96733'), -- Scarlet Judicator - 111672 - Resurrect Requirement, 96733 - Permanent Feign Death (Stun) +(@CGUID+145, 0, 0, 0, 1, 0, 0, 0, 0, 0, '111672 96733'), -- Scarlet Judicator - 111672 - Resurrect Requirement, 96733 - Permanent Feign Death (Stun) +(@CGUID+148, 0, 0, 0, 1, 0, 0, 0, 0, 0, '111672 96733'), -- Scarlet Judicator - 111672 - Resurrect Requirement, 96733 - Permanent Feign Death (Stun) +(@CGUID+150, 0, 0, 0, 1, 0, 0, 0, 0, 0, '111672 96733'), -- Scarlet Judicator - 111672 - Resurrect Requirement, 96733 - Permanent Feign Death (Stun) +(@CGUID+151, 0, 0, 0, 1, 0, 0, 0, 0, 0, '111672 96733'), -- Scarlet Judicator - 111672 - Resurrect Requirement, 96733 - Permanent Feign Death (Stun) +(@CGUID+152, 0, 0, 0, 1, 0, 0, 0, 0, 0, '111672 96733'), -- Scarlet Judicator - 111672 - Resurrect Requirement, 96733 - Permanent Feign Death (Stun) +(@CGUID+153, 0, 0, 0, 1, 333, 0, 0, 0, 0, ''); -- Hooded Crusader + +-- Creature Template +DELETE FROM `creature_template_addon` WHERE `entry` IN (58783 /*58783 (Scarlet Initiate)*/, 60040 /*60040 (Commander Durand)*/, 64446 /*64446 (Training Dummy) - Training Dummy Marker*/, 58555 /*58555 (Scarlet Fanatic)*/, 59223 /*59223 (Brother Korloff)*/, 60197 /*60197 (Training Dummy) - Training Dummy Marker*/, 58605 /*58605 (Scarlet Judicator) - Drunk*/, 60033 /*60033 (Frenzied Spirit) - Frenzied Spirit*/, 59746 /*59746 (Scarlet Centurion) - Retaliation*/, 59789 /*59789 (Thalnos the Soulrender) - Cosmetic Visual*/, 59722 /*59722 (Pile of Corpses) - Pile of Corpses*/, 59706 /*59706 (Fuel Tank) - Ride Vehicle Hardcoded*/); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(58783, 0, 0, 8, 1, 0, 0, 0, 0, 0, ''), -- 58783 (Scarlet Initiate) +(60040, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''), -- 60040 (Commander Durand) +(64446, 0, 0, 0, 1, 0, 0, 0, 0, 0, '98892'), -- 64446 (Training Dummy) - Training Dummy Marker +(59223, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''), -- 59223 (Brother Korloff) +(60197, 0, 0, 0, 1, 0, 0, 0, 0, 0, '98892'), -- 60197 (Training Dummy) - Training Dummy Marker +(60033, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, '115523'), -- 60033 (Frenzied Spirit) - Frenzied Spirit +(59746, 0, 0, 0, 1, 0, 0, 0, 0, 0, '115511'), -- 59746 (Scarlet Centurion) - Retaliation +(59789, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''), -- 59789 (Thalnos the Soulrender) - Cosmetic Visual +(59722, 0, 0, 0, 1, 0, 0, 0, 0, 0, '114951'), -- 59722 (Pile of Corpses) - Pile of Corpses +(59706, 0, 0, 0, 1, 0, 0, 0, 0, 0, '46598'); -- 59706 (Fuel Tank) - Ride Vehicle Hardcoded + +UPDATE `creature_template_addon` SET `bytes1`=0, `bytes2`=1, `auras`='111672 96733 8278' WHERE `entry`=4542; -- 4542 (High Inquisitor Fairbanks) - Resurrect Requirement, Permanent Feign Death (Stun), Invisibility Detection +UPDATE `creature_template_addon` SET `bytes2`=1 WHERE `entry`=3977; -- 3977 (High Inquisitor Whitemane) + +-- NPC Scaling +DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=1 AND `Entry` IN (4542,58783,3977,60040,64446,64854,59223,60197,58605,60033,58569,58555,58590,59789,64827,59722,59705,59706,59746)); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(4542, 1, 0, 0, 211, 43345), +(58783, 1, -2, -2, 211, 43345), +(3977, 1, 2, 2, 211, 43345), +(60040, 1, 2, 2, 211, 43345), +(64446, 1, 0, 0, 211, 43345), +(64854, 1, 3, 3, 211, 43345), +(59223, 1, 2, 2, 211, 43345), +(60197, 1, 0, 0, 328, 43345), +(58605, 1, 0, 0, 211, 43345), +(60033, 1, -1, -1, 211, 43345), +(58569, 1, 0, 0, 211, 43345), +(58555, 1, 0, 0, 211, 43345), +(58590, 1, 0, 0, 211, 43345), +(59789, 1, 1, 1, 211, 43345), +(64827, 1, 0, 0, 211, 43345), +(59722, 1, -1, -1, 211, 43345), +(59705, 1, -1, -1, 211, 43345), +(59706, 1, 0, 0, 211, 43345), +(59746, 1, -1, -1, 211, 43345); + +-- GameObject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+32; +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, 211844, 1004, 6109, 6384, '1,2', 0, 0, 1057.6865234375, 652.21490478515625, 2.738302230834960937, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 43345), -- Graveyard Door (Area: Forlorn Cloister - Difficulty: 1) +(@OGUID+1, 214508, 1004, 6109, 6384, '1,2', 0, 0, 1124.5572509765625, 504.333343505859375, 0.989199519157409667, 1.561401128768920898, 0, 0, 0.703777313232421875, 0.710420668125152587, 7200, 255, 1, 43345), -- Instance Portal (Party + Heroic + Challenge) (Area: Forlorn Cloister - Difficulty: 1) +(@OGUID+2, 214285, 1004, 6109, 6384, '1', 1443, 0, 1124.7274169921875, 701.46527099609375, 5.9694976806640625, 0, 0, 0, 0, 1, 7200, 255, 1, 43345), -- Blades of the Anointed Coffin (Area: Forlorn Cloister - Difficulty: 1) +(@OGUID+3, 214287, 1004, 6109, 6384, '1', 1443, 0, 960.96356201171875, 605.51043701171875, 2.322011947631835937, 6.256268501281738281, 0.19423675537109375, 0.030352592468261718, -0.01971054077148437, 0.980286836624145507, 7200, 255, 1, 43345), -- Blade of the Anointed (Area: Forlorn Cloister - Difficulty: 1) +(@OGUID+4, 214286, 1004, 6109, 6384, '1', 1443, 0, 1124.9600830078125, 701.5086669921875, 7.884554386138916015, 0, 0, 0, 0, 1, 7200, 255, 1, 43345), -- Aura Red Tall (scale x1.5) (Area: Forlorn Cloister - Difficulty: 1) +(@OGUID+5, 214289, 1004, 6109, 6384, '1', 1443, 0, 960.88543701171875, 605.420166015625, 0.843084514141082763, 0, 0, 0, 0, 1, 7200, 255, 1, 43345), -- Aura Yellow Tall (scale x1.5) (Area: Forlorn Cloister - Difficulty: 1) +(@OGUID+6, 210563, 1004, 6109, 6384, '1,2', 0, 0, 729.4373779296875, 605.80340576171875, 14.47163963317871093, 0, 0, 0, 0, 1, 7200, 255, 1, 43345), -- Doodad_MonestaryBossDoor01 (Area: Forlorn Cloister - Difficulty: 1) +(@OGUID+7, 214290, 1004, 6109, 6384, '1', 1443, 0, 959.9288330078125, 605.4617919921875, 0.842723309993743896, 0, 0, 0, 0, 1, 7200, 255, 1, 43345), -- Pool Statue (Area: Forlorn Cloister - Difficulty: 1) +(@OGUID+8, 210562, 1004, 6109, 6384, '1,2', 0, 0, 734.65264892578125, 657.4451904296875, 14.04876518249511718, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 7200, 255, 1, 43345), -- Doodad_MonestarySecretDoor01 (Area: Forlorn Cloister - Difficulty: 1) +(@OGUID+9, 210564, 1004, 6109, 6384, '1,2', 0, 0, 832.491455078125, 605.56805419921875, 13.29495811462402343, 0, 0, 0, 0, 1, 7200, 255, 1, 43345), -- Doodad_ScarletCathedralDoor01 (Area: Forlorn Cloister - Difficulty: 1) +(@OGUID+10, 2044, 1004, 6109, 6384, '1,2', 0, 0, 1097.41845703125, 637.29168701171875, 0.304806768894195556, 3.597096920013427734, 0, 0, -0.97417640686035156, 0.225788235664367675, 7200, 255, 1, 43345), -- Dragon's Teeth (Area: Forlorn Cloister - Difficulty: 1) +(@OGUID+11, 214284, 1004, 6109, 6384, '1,2', 0, 0, 1126.2379150390625, 701.44964599609375, 7.692743301391601562, 5.508723735809326171, 0.190638065338134765, -0.64641952514648437, 0.06362152099609375, 0.73603755235671997, 7200, 255, 1, 43345), -- Blade of the Anointed (Area: Forlorn Cloister - Difficulty: 1) +(@OGUID+12, 2042, 1004, 6109, 6384, '1,2', 0, 0, 1000.748291015625, 631.625, 1.035452485084533691, 4.840319156646728515, 0, 0, -0.66046142578125, 0.750859975814819335, 7200, 255, 1, 43345), -- Fadeleaf (Area: Forlorn Cloister - Difficulty: 1) +(@OGUID+13, 2042, 1004, 6109, 6386, '1,2', 0, 0, 900.53302001953125, 559.1805419921875, 10.42366409301757812, 1.143519878387451171, 0, 0, 0.541112899780273437, 0.840949952602386474, 7200, 255, 1, 43345), -- Fadeleaf (Area: Chapel Gardens - Difficulty: 1) +(@OGUID+14, 210548, 1004, 6109, 6386, '1,2', 0, 0, 828.5303955078125, 598.7862548828125, 12.77158164978027343, 0, 0, 0, 0, 1, 7200, 255, 1, 43345), -- Doodad_G_LeverMetal01 (Area: Chapel Gardens - Difficulty: 1) +(@OGUID+15, 210549, 1004, 6109, 6386, '1,2', 0, 0, 741.0556640625, 629.30145263671875, 14.57956695556640625, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 7200, 255, 1, 43345), -- Wooden Chair (Area: Chapel Gardens - Difficulty: 1) +(@OGUID+16, 210560, 1004, 6109, 6386, '1,2', 0, 0, 741.02197265625, 582.12384033203125, 14.57956695556640625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 7200, 255, 1, 43345), -- Wooden Chair (Area: Chapel Gardens - Difficulty: 1) +(@OGUID+17, 210551, 1004, 6109, 6386, '1,2', 0, 0, 737.37579345703125, 629.30145263671875, 14.57956695556640625, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 7200, 255, 1, 43345), -- Wooden Chair (Area: Chapel Gardens - Difficulty: 1) +(@OGUID+18, 210550, 1004, 6109, 6386, '1,2', 0, 0, 739.2060546875, 629.30145263671875, 14.57956695556640625, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 7200, 255, 1, 43345), -- Wooden Chair (Area: Chapel Gardens - Difficulty: 1) +(@OGUID+19, 210553, 1004, 6109, 6386, '1,2', 0, 0, 737.37579345703125, 631.7822265625, 14.57956695556640625, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 7200, 255, 1, 43345), -- Wooden Chair (Area: Chapel Gardens - Difficulty: 1) +(@OGUID+20, 210552, 1004, 6109, 6386, '1,2', 0, 0, 739.2060546875, 631.7822265625, 14.57956695556640625, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 7200, 255, 1, 43345), -- Wooden Chair (Area: Chapel Gardens - Difficulty: 1) +(@OGUID+21, 210555, 1004, 6109, 6386, '1,2', 0, 0, 739.1917724609375, 578.73590087890625, 14.57956695556640625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 7200, 255, 1, 43345), -- Wooden Chair (Area: Chapel Gardens - Difficulty: 1) +(@OGUID+22, 210554, 1004, 6109, 6386, '1,2', 0, 0, 741.0556640625, 631.7822265625, 14.57956695556640625, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 7200, 255, 1, 43345), -- Wooden Chair (Area: Chapel Gardens - Difficulty: 1) +(@OGUID+23, 210557, 1004, 6109, 6386, '1,2', 0, 0, 737.3421630859375, 578.73590087890625, 14.57956695556640625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 7200, 255, 1, 43345), -- Wooden Chair (Area: Chapel Gardens - Difficulty: 1) +(@OGUID+24, 210556, 1004, 6109, 6386, '1,2', 0, 0, 741.02197265625, 578.73590087890625, 14.57956695556640625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 7200, 255, 1, 43345), -- Wooden Chair (Area: Chapel Gardens - Difficulty: 1) +(@OGUID+25, 210559, 1004, 6109, 6386, '1,2', 0, 0, 737.3421630859375, 582.12384033203125, 14.57956695556640625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 7200, 255, 1, 43345), -- Wooden Chair (Area: Chapel Gardens - Difficulty: 1) +(@OGUID+26, 210558, 1004, 6109, 6386, '1,2', 0, 0, 739.1917724609375, 582.12384033203125, 14.57956695556640625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 7200, 255, 1, 43345), -- Wooden Chair (Area: Chapel Gardens - Difficulty: 1) +(@OGUID+27, 210561, 1004, 6109, 6386, '1,2', 0, 0, 733.41070556640625, 659.08148193359375, 15.54491424560546875, 0, 0, 0, 0, 1, 7200, 255, 1, 43345), -- Suspicious Torch (Area: Chapel Gardens - Difficulty: 1) +(@OGUID+28, 214287, 1004, 6109, 6386, '2', '1445', 0, 960.96356201171875, 605.51043701171875, 2.322011947631835937, 6.256268501281738281, 0.19423675537109375, 0.030352592468261718, -0.01971054077148437, 0.980286836624145507, 7200, 255, 1, 43345), -- Blade of the Anointed (Area: Chapel Gardens - Difficulty: 2) +(@OGUID+29, 214289, 1004, 6109, 6386, '2', '1445', 0, 960.88543701171875, 605.420166015625, 0.843084514141082763, 0, 0, 0, 0, 1, 7200, 255, 1, 43345), -- Aura Yellow Tall (scale x1.5) (Area: Chapel Gardens - Difficulty: 2) +(@OGUID+30, 214290, 1004, 6109, 6386, '2', '1445', 0, 959.9288330078125, 605.4617919921875, 0.842723309993743896, 0, 0, 0, 0, 1, 7200, 255, 1, 43345), -- Pool Statue (Area: Chapel Gardens - Difficulty: 2) +(@OGUID+31, 214285, 1004, 6109, 6386, '2', '1445', 0, 1124.7274169921875, 701.46527099609375, 5.9694976806640625, 0, 0, 0, 0, 1, 7200, 255, 1, 43345), -- Blades of the Anointed Coffin (Area: Chapel Gardens - Difficulty: 2) +(@OGUID+32, 214286, 1004, 6109, 6386, '2', '1445', 0, 1124.9600830078125, 701.5086669921875, 7.884554386138916015, 0, 0, 0, 0, 1, 7200, 255, 1, 43345); -- Aura Red Tall (scale x1.5) (Area: Chapel Gardens - Difficulty: 2) + +DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+27; +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), -- Graveyard Door +(@OGUID+6, 0, 0, 1, -0.00000004371138828, 0, 0), -- Doodad_MonestaryBossDoor01 +(@OGUID+8, 0, 0, 1, -0.00000004371138828, 0, 0), -- Doodad_MonestarySecretDoor01 +(@OGUID+9, 0, 0, 1, -0.00000004371138828, 0, 0), -- Doodad_ScarletCathedralDoor01 +(@OGUID+14, 0, 0, 1, -0.00000004371138828, 0, 0), -- Doodad_G_LeverMetal01 +(@OGUID+15, 0, 0, 1, -0.00000004371138828, 0, 0), -- Wooden Chair +(@OGUID+16, 0, 0, 1, -0.00000004371138828, 0, 0), -- Wooden Chair +(@OGUID+17, 0, 0, 1, -0.00000004371138828, 0, 0), -- Wooden Chair +(@OGUID+18, 0, 0, 1, -0.00000004371138828, 0, 0), -- Wooden Chair +(@OGUID+19, 0, 0, 1, -0.00000004371138828, 0, 0), -- Wooden Chair +(@OGUID+20, 0, 0, 1, -0.00000004371138828, 0, 0), -- Wooden Chair +(@OGUID+21, 0, 0, 1, -0.00000004371138828, 0, 0), -- Wooden Chair +(@OGUID+22, 0, 0, 1, -0.00000004371138828, 0, 0), -- Wooden Chair +(@OGUID+23, 0, 0, 1, -0.00000004371138828, 0, 0), -- Wooden Chair +(@OGUID+24, 0, 0, 1, -0.00000004371138828, 0, 0), -- Wooden Chair +(@OGUID+25, 0, 0, 1, -0.00000004371138828, 0, 0), -- Wooden Chair +(@OGUID+26, 0, 0, 1, -0.00000004371138828, 0, 0), -- Wooden Chair +(@OGUID+27, 0, 0, 1, -0.00000004371138828, 0, 0); -- Suspicious Torch + +UPDATE `gameobject_template_addon` SET `faction`=114 WHERE `entry`=210548; -- Doodad_G_LeverMetal01 +UPDATE `gameobject_template_addon` SET `flags`=4 WHERE `entry`=214284; -- Blade of the Anointed +UPDATE `gameobject_template_addon` SET `flags`=278528 WHERE `entry`=2044; -- Dragon's Teeth + +UPDATE `gameobject_template` SET `Data1`=0, `Data2`=1, `Data30`=43122, `ContentTuningId`=211, `VerifiedBuild`=43345 WHERE `entry`=214284; -- Blade of the Anointed +UPDATE `gameobject_template` SET `ContentTuningId`=683, `VerifiedBuild`=43345 WHERE `entry`=2044; -- Dragon's Teeth + +-- Creature Template Data +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30, `unit_flags3`=8193 WHERE `entry`=4542; -- High Inquisitor Fairbanks +UPDATE `creature_template` SET `minlevel`=28, `maxlevel`=28 WHERE `entry`=58783; -- Scarlet Initiate +UPDATE `creature_template` SET `minlevel`=32, `maxlevel`=32 WHERE `entry`=3977; -- High Inquisitor Whitemane +UPDATE `creature_template` SET `minlevel`=32, `maxlevel`=32 WHERE `entry`=60040; -- Commander Durand +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30, `speed_run`=1, `unit_flags3`=8388609 WHERE `entry`=64446; -- Training Dummy +UPDATE `creature_template` SET `minlevel`=33, `maxlevel`=33, `npcflag`=3, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048, `unit_flags3`=16777216 WHERE `entry`=64854; -- Blade of the Anointed +UPDATE `creature_template` SET `minlevel`=32, `maxlevel`=32, `speed_walk`=2.799999952316284179, `speed_run`=2 WHERE `entry`=59223; -- Brother Korloff +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `unit_flags3`=8388609 WHERE `entry`=60197; -- Training Dummy +UPDATE `creature_template` SET `minlevel`=29, `maxlevel`=29, `speed_run`=0.857142865657806396 WHERE `entry`=60033; -- Frenzied Spirit +UPDATE `creature_template` SET `minlevel`=31, `maxlevel`=31 WHERE `entry`=59789; -- Thalnos the Soulrender +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30, `gossip_menu_id`=14598, `unit_flags`=32768, `unit_flags3`=1048576 WHERE `entry`=64827; -- Hooded Crusader +UPDATE `creature_template` SET `minlevel`=29, `maxlevel`=29 WHERE `entry`=59722; -- Pile of Corpses +UPDATE `creature_template` SET `minlevel`=29, `maxlevel`=29 WHERE `entry`=59705; -- Scarlet Flamethrower +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30, `unit_flags`=33587200 WHERE `entry`=59706; -- Fuel Tank +UPDATE `creature_template` SET `minlevel`=29, `maxlevel`=29, `unit_flags`=32848 WHERE `entry`=59746; -- Scarlet Centurion +UPDATE `creature_template` SET `faction`= 67 WHERE `entry`= 58605; -- Scarlet Judicator + +-- Creature Template Movement +DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (60033, 59722, 60197); +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`, `InteractionPauseTimer`) VALUES +(60033, 1, 0, 1, 0, 0, 0, NULL), +(59722, 0, 0, 0, 1, 0, 0, NULL), +(60197, 0, 0, 0, 1, 0, 0, NULL); + +-- Vehicle Data +DELETE FROM `vehicle_template_accessory` WHERE `entry` = 59705; +INSERT INTO `vehicle_template_accessory` (`entry`, `accessory_entry`, `seat_id`, `minion`, `description`, `summontype`, `summontimer`) VALUES +(59705, 59706, 0, 0, 'Scarlet Flamethrower - Fuel Tank', 6, 300000); -- Scarlet Flamethrower - Fuel Tank + +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (59706, 59705); +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES +(59706, 114953, 1, 0), +(59705, 46598, 1, 0); + +-- Phasing +DELETE FROM `phase_area` WHERE `AreaId` = 6384 AND `PhaseId` = 1443 OR `AreaId` = 6386 AND `PhaseId` = 1443 OR `AreaId` = 6384 AND `PhaseId` = 1445 OR `AreaId` = 6386 AND `PhaseId` = 1445; +INSERT INTO `phase_area` (`AreaId`, `PhaseId`, `Comment`) VALUES +(6384, 1443, 'Cosmetic - Scarlet Monastery Quest Phase'), +(6386, 1443, 'Cosmetic - Scarlet Monastery Quest Phase'), +(6384, 1445, 'Cosmetic - Scarlet Monastery Quest HC Phase'), +(6386, 1445, 'Cosmetic - Scarlet Monastery Quest HC Phase'); + +DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId` = 26 AND `SourceGroup` = 1443 AND `SourceEntry` = 6384) OR (`SourceTypeOrReferenceId` = 26 AND `SourceGroup` = 1443 AND `SourceEntry` = 6386) OR (`SourceTypeOrReferenceId` = 26 AND `SourceGroup` = 1445 AND `SourceEntry` = 6386) OR (`SourceTypeOrReferenceId` = 26 AND `SourceGroup` = 1445 AND `SourceEntry` = 6384); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `Comment`) VALUES +(26, 1443, 6384, 0, 0, 8, 0, 31514, 0, 0, 1, 'Allow Phase 1443 if Quest (31514) IS NOT rewarded'), +(26, 1443, 6386, 0, 0, 8, 0, 31514, 0, 0, 1, 'Allow Phase 1443 if Quest (31514) IS NOT rewarded'), +(26, 1445, 6384, 0, 0, 8, 0, 31516, 0, 0, 1, 'Allow Phase 1443 if Quest (31516) IS NOT rewarded'), +(26, 1445, 6386, 0, 0, 8, 0, 31516, 0, 0, 1, 'Allow Phase 1443 if Quest (31516) IS NOT rewarded'); + +UPDATE `creature_queststarter` SET `VerifiedBuild`=43345 WHERE (`id`=64855 AND `quest`=31516) OR (`id`=64854 AND `quest`=31514) OR (`id`=64827 AND `quest`=31513) OR (`id`=64838 AND `quest`=31515); +UPDATE `creature_questender` SET `VerifiedBuild`=43345 WHERE (`id` IN (64838, 64839, 64842) AND `quest`=31516) OR (`id`=64855 AND `quest`=31515) OR (`id` IN (64827, 64837, 64841) AND `quest`=31514) OR (`id`=64854 AND `quest`=31513); + +-- Quest stuff +DELETE FROM `quest_template_addon` WHERE `ID` IN (31514, 31516); +INSERT INTO `quest_template_addon` (`ID`, `MaxLevel`, `AllowableClasses`, `SourceSpellID`, `PrevQuestID`, `NextQuestID`, `ExclusiveGroup`, `BreadcrumbForQuestId`, `RewardMailTemplateID`, `RewardMailDelay`, `RequiredSkillID`, `RequiredSkillPoints`, `RequiredMinRepFaction`, `RequiredMaxRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepValue`, `ProvidedItemCount`, `SpecialFlags`, `ScriptName`) VALUES +(31514, 0, 0, 0, 31513, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(31516, 0, 0, 0, 31515, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''); + +DELETE FROM `quest_offer_reward` WHERE `ID` IN (31516 /*Unto Dust Thou Shalt Return*/, 31515 /*Blades of the Anointed*/, 31514 /*Unto Dust Thou Shalt Return*/, 31513 /*Blades of the Anointed*/); +INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES +(31516, 396, 396, 2, 0, 0, 0, 0, 0, 'With Whitemane gone for good, the Scarlet Crusade is finished. It\'s just a matter of sweeping up the refuse.$B$BThank you, $p. Not just for myself, but for everyone opposed to mindless hatred and bigotry.$B$BAnd, thank you for these two new blades. Anointed anew in her blood, they should serve me well as I take the fight to Scholomance and deal with Darkmaster Gandling.$B$BI bid you adieu for now.', 43345), -- Unto Dust Thou Shalt Return +(31515, 0, 0, 0, 0, 0, 0, 0, 0, '<The second anointed blade floats just in front of the wet statue. Steam rises from the sword.>$B$B<You get the uncanny feeling that the Hand of Providence has been waiting for you.>', 43345), -- Blades of the Anointed +(31514, 396, 396, 2, 0, 0, 0, 0, 0, 'With Whitemane gone for good, the Scarlet Crusade is finished. It\'s just a matter of sweeping up the refuse.$B$BThank you, $p. Not just for myself, but for everyone opposed to mindless hatred and bigotry.$B$BAnd, thank you for these two new blades. Anointed anew in her blood, they should serve me well as I take the fight to Scholomance and deal with Darkmaster Gandling.$B$BI bid you adieu for now.', 43345), -- Unto Dust Thou Shalt Return +(31513, 0, 0, 0, 0, 0, 0, 0, 0, '<The second anointed blade floats just in front of the wet statue. Steam rises from the sword.>$B$B<You get the uncanny feeling that the Hand of Providence has been waiting for you.>', 43345); -- Blades of the Anointed + +DELETE FROM `quest_details` WHERE `ID` IN (31516 /*Unto Dust Thou Shalt Return*/, 31515 /*Blades of the Anointed*/, 31514 /*Unto Dust Thou Shalt Return*/, 31513 /*Blades of the Anointed*/); +INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES +(31516, 0, 0, 0, 0, 0, 0, 0, 0, 43345), -- Unto Dust Thou Shalt Return +(31515, 1, 0, 0, 0, 0, 0, 0, 0, 43345), -- Blades of the Anointed +(31514, 0, 0, 0, 0, 0, 0, 0, 0, 43345), -- Unto Dust Thou Shalt Return +(31513, 1, 0, 0, 0, 0, 0, 0, 0, 43345); -- Blades of the Anointed + +DELETE FROM `quest_request_items` WHERE `ID` IN(31516 /*Unto Dust Thou Shalt Return*/, 31515 /*Blades of the Anointed*/, 31514 /*Unto Dust Thou Shalt Return*/, 31513 /*Blades of the Anointed*/); +INSERT INTO `quest_request_items` (`ID`, `EmoteOnComplete`, `EmoteOnIncomplete`, `EmoteOnCompleteDelay`, `EmoteOnIncompleteDelay`, `CompletionText`, `VerifiedBuild`) VALUES +(31516, 0, 0, 0, 0, '<The deed is not yet done. There can be no end to the Scarlet Crusade while Whitemane can come back from the dead.>', 43345), -- Unto Dust Thou Shalt Return +(31515, 0, 0, 0, 0, '<With one blade already in your possession, you move to take the other.>$B$B<An inscription on the statue behind the sword reads, \"The Hand of Providence\".>', 43345), -- Blades of the Anointed +(31514, 0, 0, 0, 0, '<The deed is not yet done. There can be no end to the Scarlet Crusade while Whitemane can come back from the dead.>', 43345), -- Unto Dust Thou Shalt Return +(31513, 0, 0, 0, 0, '<With one blade already in your possession, you move to take the other.>$B$B<An inscription on the statue behind the sword reads, \"The Hand of Providence\".>', 43345); -- Blades of the Anointed + +-- Add SpellScript to Feign Death Aura +DELETE FROM `spell_script_names` WHERE `spell_id` = 96733; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(96733, 'spell_gen_feign_death_all_flags'); + +-- Waypoints for CGUID+103 +SET @PATH := @CGUID+103 * 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, 913.1684, 661.1545, 11.62775, 0, 0), +(@PATH, 1, 898.0555, 661.2587, 11.63099, 0, 0), +(@PATH, 2, 881.7188, 661.3351, 11.63083, 0, 0), +(@PATH, 3, 862.2101, 661.4063, 11.62882, 0, 0), +(@PATH, 4, 881.7188, 661.3351, 11.63083, 0, 0), +(@PATH, 5, 898.0555, 661.2587, 11.63099, 0, 0); + +UPDATE `creature` SET `position_x`= 913.1684, `position_y`= 661.1545, `position_z`= 11.62775, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+103; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+103; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+103, @PATH, 1); + +-- Waypoints for CGUID+77 +SET @PATH := @CGUID+77 * 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, 1012.135, 567.4844, 1.089556, 0, 0), +(@PATH, 1, 975.2639, 567.3299, 1.153966, 0, 0), +(@PATH, 2, 950.4531, 567.2327, 1.153399, 0, 0), +(@PATH, 3, 938.1268, 567.2552, 1.160954, 0, 0), +(@PATH, 4, 950.4531, 567.2327, 1.153399, 0, 0), +(@PATH, 5, 975.2639, 567.3299, 1.153966, 0, 0), +(@PATH, 6, 1012.051, 567.484, 1.118437, 0, 0), +(@PATH, 7, 1012.188, 582.1326, 1.15845, 0, 0); + +UPDATE `creature` SET `position_x`= 1012.135, `position_y`= 567.4844, `position_z`= 1.089556, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+77; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+77; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+77, @PATH, 1); + +-- Waypoints for CGUID+66 +SET @PATH := @CGUID+66 * 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, 992.6441, 582.6945, 0.79107, 0, 0), +(@PATH, 1, 993.0972, 627.9948, 0.75, 0, 0), +(@PATH, 2, 955.7656, 628.8386, 0.75, 0, 0), +(@PATH, 3, 993.0972, 627.9948, 0.75, 0, -0), +(@PATH, 4, 992.6441, 582.6945, 0.79107, 0, 0), +(@PATH, 5, 951.5729, 583.0955, 0.7222222, 0, 0); + +UPDATE `creature` SET `position_x`= 992.6441, `position_y`= 582.6945, `position_z`= 0.79107, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+66; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+66; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+66, @PATH, 1); + +-- Waypoints for CGUID+85 +SET @PATH := @CGUID+85 * 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, 938.8472, 644.0191, 1.162303, 0, 0), +(@PATH, 1, 946.6441, 644.1042, 1.159303, 0, 0), +(@PATH, 2, 966.0573, 644.0679, 1.156372, 0, 0), +(@PATH, 3, 1012.432, 644.066, 1.096169, 0, 0), +(@PATH, 4, 966.2014, 644.0677, 1.154793, 0, 0), +(@PATH, 5, 946.6441, 644.1042, 1.159303, 0, 0); + +UPDATE `creature` SET `position_x`= 938.8472, `position_y`= 644.0191, `position_z`= 1.162303, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+85; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+85; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+85, @PATH, 1); + +-- Waypoints for CGUID+129 +SET @PATH := @CGUID+129 * 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, 821.9601, 587, 12.7955, 0, 103), +(@PATH, 1, 794.7118, 586.9531, 12.79512, 0, 0), +(@PATH, 2, 768.7153, 586.7031, 12.79924, 0, 0), +(@PATH, 3, 768.8889, 624.092, 12.7959, 0, 0), +(@PATH, 4, 793.3698, 624.408, 12.79631, 0, 0), +(@PATH, 5, 822.6163, 624.1597, 12.79478, 0, 0), +(@PATH, 6, 793.3698, 624.408, 12.79631, 0, 0), +(@PATH, 7, 768.8889, 624.092, 12.7959, 0, 0), +(@PATH, 8, 768.7153, 586.7031, 12.79924, 0, 0), +(@PATH, 9, 794.7118, 586.9531, 12.79512, 0, 0); + +UPDATE `creature` SET `position_x`= 821.9601, `position_y`= 587, `position_z`= 12.7955, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+129; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+129; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+129, @PATH, 1); + +UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = 58605; +DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` IN(-(@CGUID+31), -(@CGUID+37)); +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(-(@CGUID+31), 0, 0, 0, 63, 0, 100, 0, 0, 0, 0, 0, 2, 2156, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On just created - Self: Set faction to 2156'), +(-(@CGUID+37), 0, 0, 0, 63, 0, 100, 0, 0, 0, 0, 0, 2, 2156, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On just created - Self: Set faction to 2156'); |