diff options
| -rw-r--r-- | sql/updates/world/master/2024_09_01_00_world.sql | 374 |
1 files changed, 374 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_09_01_00_world.sql b/sql/updates/world/master/2024_09_01_00_world.sql new file mode 100644 index 00000000000..737196953a4 --- /dev/null +++ b/sql/updates/world/master/2024_09_01_00_world.sql @@ -0,0 +1,374 @@ +SET @CGUID := 10000825; +SET @OGUID := 10000006; + +-- Creature +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+241; +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`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES +(@CGUID+0, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1980.392333984375, -832.97222900390625, 3.461805582046508789, 3.13384103775024414, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) (possible waypoints or random movement) +(@CGUID+1, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1981.8819580078125, -834.22918701171875, 3.465277671813964843, 2.786286115646362304, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+2, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1982.2742919921875, -831.91143798828125, 3.182291507720947265, 3.302634954452514648, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+3, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2135.850830078125, -876.8836669921875, 7.340188980102539062, 4.120525836944580078, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+4, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1968.9617919921875, -912.94793701171875, 19.28472328186035156, 0.899954557418823242, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+5, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1985.9930419921875, -891.15106201171875, 13.58680534362792968, 5.982346057891845703, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+6, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1965.1649169921875, -889.1180419921875, 20.4628143310546875, 2.459722757339477539, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+7, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2081.670166015625, -836.51214599609375, 0.961970627307891845, 5.528889656066894531, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+8, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2034.43408203125, -880.545166015625, 10.54518890380859375, 0.123680397868156433, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+9, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2113.572998046875, -877.8836669921875, 8.5625, 4.774155616760253906, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+10, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2113.96533203125, -875.56597900390625, 8.353037834167480468, 5.056838512420654296, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+11, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2112.083251953125, -876.62677001953125, 8.506944656372070312, 5.068270683288574218, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) (possible waypoints or random movement) +(@CGUID+12, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2025.935791015625, -893.71356201171875, 11.36886215209960937, 2.651847362518310546, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+13, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2104.576416015625, -920.763916015625, 14.76682662963867187, 2.651847362518310546, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) (possible waypoints or random movement) +(@CGUID+14, 212717, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1947.09033203125, -879.578125, 25.50347328186035156, 0.182974606752395629, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Webspinner (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: 436072 - Sticky Webs) +(@CGUID+15, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2017.3975830078125, -834.55206298828125, 2.110215663909912109, 4.138926982879638671, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+16, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2053.703125, -937.95660400390625, 20.50352668762207031, 0.465400189161300659, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+17, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2128.6494140625, -900.9375, 10.98263835906982421, 4.385390281677246093, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+18, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2079.677001953125, -901.70831298828125, 14.35119915008544921, 1.54832613468170166, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+19, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2079.017333984375, -900.0382080078125, 14.15403461456298828, 4.589624881744384765, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+20, 220067, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2049.5625, -849.28643798828125, 2.848442792892456054, 5.268709182739257812, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Salmoncrab (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+21, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1935.5555419921875, -969.7569580078125, 28.02087593078613281, 4.544935226440429687, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+22, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1933.6771240234375, -970.81597900390625, 28.31423759460449218, 5.580784797668457031, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+23, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1935.1632080078125, -972.07293701171875, 28.08159828186035156, 1.622937679290771484, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+24, 220067, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2026.8160400390625, -826.00177001953125, 0.821075439453125, 0, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Salmoncrab (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+25, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2013.607666015625, -962.1180419921875, 16.89236259460449218, 2.055228710174560546, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+26, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2015.095458984375, -963.375, 17.17881965637207031, 2.010321617126464843, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+27, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2015.4879150390625, -961.05731201171875, 16.89583396911621093, 2.394478797912597656, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+28, 220038, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1994.638916015625, -911.62152099609375, 16.30380821228027343, 2.398970365524291992, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Shattered Crystal (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) (possible waypoints or random movement) +(@CGUID+29, 212717, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1985.19970703125, -962.515625, 19.04600715637207031, 1.241394996643066406, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Webspinner (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: 436072 - Sticky Webs) +(@CGUID+30, 212717, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2045.0260009765625, -879.15277099609375, 9.870965003967285156, 0.270456254482269287, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Webspinner (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: 436072 - Sticky Webs) (possible waypoints or random movement) +(@CGUID+31, 220038, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2019.6978759765625, -1016.1632080078125, 18.29770660400390625, 2.566622495651245117, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Shattered Crystal (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+32, 220038, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2050.833251953125, -923.23089599609375, 14.54733562469482421, 0, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Shattered Crystal (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+33, 217939, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1932.939208984375, -925.890625, 42.20728302001953125, 6.112947463989257812, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Swarming Drone (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) (possible waypoints or random movement) +(@CGUID+34, 217939, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1935.9288330078125, -925.890625, 42.01544952392578125, 5.105090618133544921, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Swarming Drone (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) (possible waypoints or random movement) +(@CGUID+35, 217939, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1929.66845703125, -925.890625, 42.30887603759765625, 6.11306619644165039, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Swarming Drone (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) (possible waypoints or random movement) +(@CGUID+36, 228057, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1985.9097900390625, -1005.9254150390625, 22.71795082092285156, 1.114030122756958007, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: 459457 - Polymorphed) +(@CGUID+37, 220038, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1910.7916259765625, -864.234375, 37.10112380981445312, 5.052828788757324218, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Shattered Crystal (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+38, 217939, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1994.6927490234375, -972.08331298828125, 40.18082427978515625, 6.113013744354248046, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Swarming Drone (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+39, 217939, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1997.9635009765625, -972.08331298828125, 40.45551300048828125, 6.113167762756347656, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Swarming Drone (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+40, 217939, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2000.953125, -972.08331298828125, 40.52631378173828125, 5.105090618133544921, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Swarming Drone (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+41, 220038, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1920.439208984375, -991.873291015625, 29.22720146179199218, 5.604808807373046875, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Shattered Crystal (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+42, 220038, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1854.3125, -1025.4930419921875, 33.69024658203125, 4.599205970764160156, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Shattered Crystal (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+43, 220038, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1938.579833984375, -1036.8228759765625, 28.18071937561035156, 0, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Shattered Crystal (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+44, 220038, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1847.7535400390625, -1004.74652099609375, 35.1537628173828125, 5.271671295166015625, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Shattered Crystal (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+45, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2077.279541015625, -1059.720458984375, 10.74311161041259765, 5.888373851776123046, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+46, 220038, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1990.7274169921875, -985.64239501953125, 17.72397041320800781, 5.950801849365234375, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Shattered Crystal (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+47, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2043.0694580078125, -1050.2725830078125, 15.9980926513671875, 0.437091648578643798, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+48, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2041.189208984375, -1051.3333740234375, 16.23958396911621093, 0.311234772205352783, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+49, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2042.6771240234375, -1052.59033203125, 15.92361068725585937, 0.838166236877441406, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+50, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2152.923583984375, -1039.7691650390625, 1.771743416786193847, 6.060407638549804687, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+51, 220038, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2039.84375, -978.8836669921875, 22.568450927734375, 0, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Shattered Crystal (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+52, 217939, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1993.8177490234375, -1037.845458984375, 34.20742416381835937, 5.105092048645019531, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Swarming Drone (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+53, 217939, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1987.5572509765625, -1037.845458984375, 36.27948760986328125, 6.106691837310791015, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Swarming Drone (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+54, 217939, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1990.828125, -1037.845458984375, 35.41490554809570312, 6.103688716888427734, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Swarming Drone (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+55, 220038, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2079.3125, -1023.80377197265625, 15.19616508483886718, 6.059811592102050781, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Shattered Crystal (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+56, 220067, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2086.9306640625, -1091.532958984375, 3.883802652359008789, 2.179260969161987304, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Salmoncrab (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+57, 220038, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2124.890625, -1060.0694580078125, 1.502677083015441894, 3.226559400558471679, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Shattered Crystal (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+58, 220067, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2188.52783203125, -1037.3680419921875, 0.451631337404251098, 1.314199686050415039, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Salmoncrab (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+59, 220067, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2220.6337890625, -1012.3524169921875, 3.419001102447509765, 2.71881103515625, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Salmoncrab (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+60, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2158.204833984375, -885.625, 8.228216171264648437, 2.213659286499023437, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+61, 220038, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2145.689208984375, -956.6649169921875, 5.195072174072265625, 2.798273324966430664, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Shattered Crystal (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+62, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2178.5712890625, -912.390625, 7.807044506072998046, 4.848464012145996093, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+63, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2065.322998046875, -859.05902099609375, 3.46082925796508789, 3.384024858474731445, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+64, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2063.444580078125, -860.11981201171875, 3.779513835906982421, 3.170203447341918945, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+65, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2064.9306640625, -861.37677001953125, 4.614583492279052734, 2.713640213012695312, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+66, 212717, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2181.920166015625, -930.38714599609375, 7.627023696899414062, 0.174847126007080078, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Webspinner (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: 436072 - Sticky Webs) (possible waypoints or random movement) +(@CGUID+67, 220067, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2112.427001953125, -842.6336669921875, 3.102162599563598632, 1.763242125511169433, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Salmoncrab (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+68, 220038, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2145.546875, -893.30035400390625, 9.695471763610839843, 1.866055607795715332, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Shattered Crystal (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+69, 220038, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2174.932373046875, -906.02081298828125, 9.040369987487792968, 4.873427391052246093, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Shattered Crystal (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+70, 220038, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2124.876708984375, -921.13018798828125, 12.78422355651855468, 2.789196252822875976, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Shattered Crystal (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+71, 220038, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2009.1597900390625, -884.578125, 12.02620601654052734, 1.772808432579040527, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Shattered Crystal (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+72, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1981.2066650390625, -935.670166015625, 19.5868072509765625, 0.015095862559974193, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+73, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1999.8819580078125, -884.7899169921875, 12.03472232818603515, 4.8709716796875, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+74, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1974.8819580078125, -909.467041015625, 17.77604293823242187, 3.4531707763671875, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+75, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1880.796875, -1003.875, 34.95475006103515625, 4.444427967071533203, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+76, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1887.35595703125, -1014.92877197265625, 31.91888427734375, 2.998565912246704101, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+77, 220038, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1892.251708984375, -1018.986083984375, 31.90678024291992187, 5.732097625732421875, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Shattered Crystal (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+78, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1963.0555419921875, -864.5086669921875, 17.8818206787109375, 3.617208242416381835, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+79, 217939, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1973.77783203125, -891.45489501953125, 31.94371604919433593, 5.151216030120849609, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Swarming Drone (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+80, 217939, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1970.5069580078125, -891.45489501953125, 33.028778076171875, 5.529022216796875, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Swarming Drone (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+81, 217939, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1976.767333984375, -891.45489501953125, 30.983642578125, 5.105090618133544921, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Swarming Drone (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+82, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1933.4305419921875, -884.55035400390625, 28.37056732177734375, 2.092473268508911132, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+83, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1927.3541259765625, -964.265625, 28.83159828186035156, 3.513453006744384765, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+84, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1998.5885009765625, -913.671875, 16.04720497131347656, 1.725128650665283203, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+85, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1987.6510009765625, -938.04168701171875, 18.40738105773925781, 2.568311452865600585, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+86, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1969.388916015625, -878.9461669921875, 15.65233039855957031, 2.954611063003540039, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+87, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2047.0989990234375, -955.43402099609375, 23.31865692138671875, 5.545135021209716796, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+88, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2006.90625, -968.11114501953125, 16.38931083679199218, 5.575929641723632812, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) (possible waypoints or random movement) +(@CGUID+89, 220038, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2007.8489990234375, -943.03125, 16.715545654296875, 0, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Shattered Crystal (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+90, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1973.923583984375, -1009.20831298828125, 25.64703369140625, 2.057731389999389648, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+91, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1901.9722900390625, -947.18231201171875, 30.94401741027832031, 2.092473268508911132, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+92, 217939, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2054.62158203125, -902.9288330078125, 25.95391273498535156, 0, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Swarming Drone (Area: Tranquil Strand - Difficulty: 0) CreateObject, +(@CGUID+93, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1935.1632080078125, -972.07293701171875, 28.08159828186035156, 0, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) (possible waypoints or random movement) +(@CGUID+94, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1933.6771240234375, -970.81597900390625, 28.31423759460449218, 0, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) (possible waypoints or random movement) +(@CGUID+95, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1957.876708984375, -861.9461669921875, 19.83801078796386718, 4.161553382873535156, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+96, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1922.43408203125, -961.8125, 29.02777862548828125, 5.295098781585693359, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+97, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1964.3125, -960.654541015625, 23.82937431335449218, 2.266330957412719726, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+98, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1956.68408203125, -961.1180419921875, 24.37881660461425781, 0.77292710542678833, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+99, 220038, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1944.9322509765625, -893.99652099609375, 25.778106689453125, 3.109914302825927734, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Shattered Crystal (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) (possible waypoints or random movement) +(@CGUID+100, 220038, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1830.4149169921875, -859.48785400390625, 48.8837890625, 0.612358629703521728, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Shattered Crystal (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+101, 220038, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1852.7291259765625, -874.0850830078125, 48.42879867553710937, 3.551796436309814453, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Shattered Crystal (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+102, 220038, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1893.904541015625, -938.25177001953125, 32.44071197509765625, 4.085583209991455078, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Shattered Crystal (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+103, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2006.21533203125, -881.4617919921875, 11.01779556274414062, 0.42068144679069519, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+104, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2071.359375, -1003.09381103515625, 21.94707107543945312, 1.419570326805114746, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+105, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2073.6025390625, -1007.73272705078125, 20.74770545959472656, 3.857130765914916992, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+106, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2068.06591796875, -1008.4132080078125, 20.67708396911621093, 5.821211814880371093, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+107, 220038, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2044.3125, -1056.545166015625, 15.18276119232177734, 1.803425192832946777, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Shattered Crystal (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+108, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2088.953125, -1062.2117919921875, 7.196392059326171875, 3.678826808929443359, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+109, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1910.5850830078125, -886.2413330078125, 33.31770706176757812, 5.501905441284179687, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+110, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1927.8489990234375, -880.89239501953125, 29.23464393615722656, 5.259595870971679687, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+111, 220038, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1939.2257080078125, -958.55731201171875, 27.01470565795898437, 4.916959762573242187, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Shattered Crystal (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+112, 228057, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1972.3802490234375, -1019.85418701171875, 24.6234893798828125, 3.22937941551208496, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: 459457 - Polymorphed) +(@CGUID+113, 220038, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1916.954833984375, -904.4600830078125, 29.178131103515625, 4.653845787048339843, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 56313), -- Shattered Crystal (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+114, 220068, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1996.9774169921875, -1025.8228759765625, 22.8231201171875, 2.290785074234008789, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Malfunctioning Spire (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+115, 228057, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1981.12158203125, -983.6805419921875, 21.83518600463867187, 5.405011177062988281, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: 459457 - Polymorphed) +(@CGUID+116, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2053.6025390625, -866.77777099609375, 4.01539468765258789, 3.10344552993774414, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+117, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2062.53466796875, -844.8055419921875, 4.910937309265136718, 3.316603422164916992, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+118, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2050.46875, -870.1944580078125, 4.745791435241699218, 1.967525839805603027, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+119, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1984.9271240234375, -847.8194580078125, 6.722095489501953125, 4.962075710296630859, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+120, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2058.600830078125, -851.7100830078125, 2.458218574523925781, 1.78056037425994873, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+121, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2015.9132080078125, -879.65106201171875, 10.7595062255859375, 1.428903102874755859, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+122, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2011.4757080078125, -838.03302001953125, 2.346038341522216796, 0.899954557418823242, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+123, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2020.40283203125, -893.11285400390625, 13.48273181915283203, 0.875551462173461914, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+124, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1997.734375, -911.8211669921875, 16.1024322509765625, 5.831696510314941406, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+125, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2027.6666259765625, -996.09722900390625, 16.0950469970703125, 2.740733623504638671, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+126, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1963.0103759765625, -985.2257080078125, 26.060302734375, 4.941134452819824218, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+127, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1883.2725830078125, -923.10418701171875, 37.96698760986328125, 0.540635526180267333, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+128, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1928.423583984375, -1008.875, 31.87783241271972656, 0.77292710542678833, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+129, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1925.4566650390625, -1003.19451904296875, 30.98632621765136718, 6.197861194610595703, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+130, 212717, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1906.2083740234375, -1018.03472900390625, 30.71128463745117187, 6.071014404296875, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Webspinner (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: 436072 - Sticky Webs) +(@CGUID+131, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2031.3836669921875, -1055.032958984375, 18.18249702453613281, 0.616823256015777587, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+132, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2028.27783203125, -1028.1927490234375, 17.46701431274414062, 3.678826808929443359, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+133, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2019.8194580078125, -1026.498291015625, 17.76041793823242187, 5.821211814880371093, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+134, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2081.350830078125, -1069.736083984375, 6.603756904602050781, 2.029378175735473632, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+135, 212717, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2036.9271240234375, -1058.9132080078125, 16.805389404296875, 2.569419384002685546, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Webspinner (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: 436072 - Sticky Webs) +(@CGUID+136, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2099.151123046875, -923.9305419921875, 14.98824691772460937, 1.349119067192077636, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+137, 212717, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2149.421875, -1043.217041015625, 1.867045402526855468, 3.700378656387329101, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Webspinner (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: 436072 - Sticky Webs) +(@CGUID+138, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2154.635498046875, -1038.5972900390625, 1.840039253234863281, 4.202218532562255859, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+139, 212717, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2162.588623046875, -898.453125, 13.37440109252929687, 1.217412471771240234, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Webspinner (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: 436072 - Sticky Webs) +(@CGUID+140, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2102.892333984375, -884.3819580078125, 9.396572113037109375, 5.417967796325683593, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+141, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2108.678955078125, -885.51214599609375, 9.657845497131347656, 4.015566349029541015, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+142, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2108.869873046875, -843.670166015625, 3.375029563903808593, 4.105309963226318359, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+143, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2170.697998046875, -885.49481201171875, 7.725475788116455078, 4.451488494873046875, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+144, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2162.44970703125, -940.00518798828125, 9.47611236572265625, 1.570063710212707519, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+145, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2153.625, -855.420166015625, 2.196996212005615234, 3.818439006805419921, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+146, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2195.59716796875, -886.86456298828125, 3.163170814514160156, 3.01116800308227539, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+147, 212715, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2175.670166015625, -924.482666015625, 8.499936103820800781, 3.882529020309448242, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (Auras: ) +(@CGUID+148, 217949, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2204.484375, -923.671875, 6.17368316650390625, 0.690459668636322021, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Skittering Swarmite (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+149, 216983, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2016.361083984375, -877.0069580078125, 9.889269828796386718, 1.403102397918701171, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Kirin Tor Conjuror (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+150, 219637, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2033.204833984375, -857.48089599609375, 4.883466720581054687, 2.206841230392456054, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Sunreaver Battlemage (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+151, 216980, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1987.8055419921875, -846.75177001953125, 5.298969268798828125, 4.994104862213134765, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Silver Covenant Spellcaster (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+152, 216980, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2026.5521240234375, -889.48089599609375, 11.94983482360839843, 2.884695053100585937, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Silver Covenant Spellcaster (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+153, 216980, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1929.15283203125, -883.97222900390625, 28.9892578125, 2.590133428573608398, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Silver Covenant Spellcaster (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+154, 216980, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1984.3853759765625, -935.60418701171875, 18.83159828186035156, 4.061192989349365234, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Silver Covenant Spellcaster (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+155, 216980, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1997.9896240234375, -887.50177001953125, 12.73090267181396484, 2.636124134063720703, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Silver Covenant Spellcaster (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+156, 216976, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1975.4879150390625, -830.935791015625, 3.366819620132446289, 2.360383033752441406, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Sunreaver Battlemage (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+157, 216983, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1983.34375, -887.6788330078125, 13.50694465637207031, 5.200833320617675781, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Kirin Tor Conjuror (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+158, 216976, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2101.876708984375, -918.8524169921875, 15.60778427124023437, 5.59463357925415039, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Sunreaver Battlemage (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+159, 216983, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1973.7117919921875, -912.953125, 18.66145896911621093, 1.246126413345336914, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Kirin Tor Conjuror (Area: Tranquil Strand - Difficulty: 0) CreateObject2(possible waypoints or random movement) +(@CGUID+160, 216983, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1968.361083984375, -961.22918701171875, 23.20058441162109375, 2.99906158447265625, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Kirin Tor Conjuror (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+161, 216976, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1926.15283203125, -961.1024169921875, 28.59723281860351562, 5.288232326507568359, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Sunreaver Battlemage (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+162, 216976, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2054.604248046875, -853.0625, 2.825459480285644531, 0.325905650854110717, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Sunreaver Battlemage (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+163, 216980, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1884.6910400390625, -925.87677001953125, 35.7848052978515625, 2.939128398895263671, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Silver Covenant Spellcaster (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+164, 216980, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2022.6024169921875, -894.90277099609375, 12.87941741943359375, 4.994104862213134765, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Silver Covenant Spellcaster (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+165, 216983, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2049.022705078125, -867.24652099609375, 4.170557498931884765, 1.019037365913391113, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Kirin Tor Conjuror (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+166, 216980, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1878.3941650390625, -1002.65631103515625, 35.44333648681640625, 2.67216801643371582, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Silver Covenant Spellcaster (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+167, 216983, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1926.4913330078125, -1011.4774169921875, 31.50892257690429687, 3.937603950500488281, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Kirin Tor Conjuror (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+168, 216976, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1923.1875, -1006.3125, 30.96941566467285156, 1.693133115768432617, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Sunreaver Battlemage (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+169, 216980, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1969.982666015625, -910.85418701171875, 18.76388931274414062, 1.779348134994506835, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Silver Covenant Spellcaster (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+170, 216983, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2010.4132080078125, -968.31768798828125, 16.28782081604003906, 3.313592910766601562, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Kirin Tor Conjuror (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+171, 216983, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1890.5260009765625, -1016.62677001953125, 31.64517021179199218, 3.570872306823730468, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Kirin Tor Conjuror (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+172, 216976, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1971.44970703125, -1010.06951904296875, 26.36783790588378906, 3.937603950500488281, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Sunreaver Battlemage (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+173, 216980, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1885.1771240234375, -921.40802001953125, 36.81824493408203125, 4.061192989349365234, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Silver Covenant Spellcaster (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+174, 216983, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1931.9375, -881.0867919921875, 28.51219367980957031, 5.4134521484375, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Kirin Tor Conjuror (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+175, 216976, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1972.388916015625, -907.5625, 17.737701416015625, 0.87899857759475708, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Sunreaver Battlemage (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+176, 216980, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1923.7569580078125, -965.638916015625, 29.3055572509765625, 0.366138160228729248, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Silver Covenant Spellcaster (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+177, 216976, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1912.1805419921875, -888.279541015625, 32.80104827880859375, 5.376514911651611328, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Sunreaver Battlemage (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+178, 216976, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1899.99658203125, -944.388916015625, 31.29819869995117187, 5.359595775604248046, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Sunreaver Battlemage (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+179, 216976, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1984.3021240234375, -938.545166015625, 19.00694465637207031, 2.393629312515258789, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Sunreaver Battlemage (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+180, 216976, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1962.7708740234375, -957.17364501953125, 23.66322517395019531, 5.128366470336914062, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Sunreaver Battlemage (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+181, 216980, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1926.15283203125, -961.1024169921875, 28.59723281860351562, 3.327478885650634765, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Silver Covenant Spellcaster (Area: Tranquil Strand - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+182, 216983, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1883.8697509765625, -1004.2274169921875, 34.13988876342773437, 3.937603950500488281, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Kirin Tor Conjuror (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+183, 216980, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1922.875, -1000.85418701171875, 30.45616722106933593, 3.937603950500488281, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Silver Covenant Spellcaster (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+184, 216976, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2009.4617919921875, -970.5867919921875, 15.71421432495117187, 2.978038311004638671, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Sunreaver Battlemage (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+185, 216980, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1959.28125, -958.30035400390625, 23.94194221496582031, 5.845388412475585937, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Silver Covenant Spellcaster (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+186, 216976, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2078.09716796875, -1065.5086669921875, 8.529513359069824218, 0.295422226190567016, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Sunreaver Battlemage (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+187, 216976, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2024.451416015625, -995.3524169921875, 15.32314872741699218, 0.280883610248565673, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Sunreaver Battlemage (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+188, 216976, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2046.7882080078125, -958.11114501953125, 23.86308670043945312, 1.291758418083190917, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Sunreaver Battlemage (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+189, 216983, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2076.609375, -1008.93927001953125, 19.95319557189941406, 2.302427291870117187, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Kirin Tor Conjuror (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+190, 216976, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2070.975830078125, -1008.77947998046875, 20.38922691345214843, 1.461312174797058105, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Sunreaver Battlemage (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+191, 216983, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2038.4791259765625, -1055.3697509765625, 16.73005104064941406, 3.094079256057739257, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Kirin Tor Conjuror (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+192, 216980, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2064.869873046875, -1010.78302001953125, 21.3041534423828125, 0.838409662246704101, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Silver Covenant Spellcaster (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+193, 216983, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2047.5103759765625, -952.15277099609375, 22.77884483337402343, 4.462789535522460937, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Kirin Tor Conjuror (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+194, 216983, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2074.70654296875, -1001.63018798828125, 22.47456550598144531, 3.937603950500488281, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Kirin Tor Conjuror (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+195, 216983, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2025.548583984375, -1030.734375, 17.5182647705078125, 0.749375343322753906, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Kirin Tor Conjuror (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+196, 216980, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2022.232666015625, -1029.7725830078125, 17.57986259460449218, 2.207357406616210937, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Silver Covenant Spellcaster (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+197, 216976, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2081.310791015625, -1059.53125, 9.831499099731445312, 3.188551664352416992, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Sunreaver Battlemage (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+198, 216980, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2085.05029296875, -1064.5728759765625, 7.2034912109375, 0.544384598731994628, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Silver Covenant Spellcaster (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+199, 216983, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2138.638916015625, -879.8125, 7.569190502166748046, 3.255678653717041015, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Kirin Tor Conjuror (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+200, 216980, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2099.87841796875, -919.81768798828125, 15.50425148010253906, 5.32696390151977539, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Silver Covenant Spellcaster (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+201, 216976, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2062.828125, -851.95660400390625, 2.508168220520019531, 2.250800609588623046, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Sunreaver Battlemage (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+202, 216980, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2057.31591796875, -865.14581298828125, 4.22156524658203125, 1.227692246437072753, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Silver Covenant Spellcaster (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+203, 216976, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2155.111083984375, -883.35418701171875, 8.228729248046875, 6.146160602569580078, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Sunreaver Battlemage (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+204, 216983, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2057.83154296875, -847.31768798828125, 2.28132939338684082, 0.496047943830490112, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Kirin Tor Conjuror (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+205, 216983, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2038.5538330078125, -880.2274169921875, 10.43048858642578125, 3.678337335586547851, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Kirin Tor Conjuror (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+206, 216980, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2124.694580078125, -900.109375, 11.16034317016601562, 0.463663190603256225, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Silver Covenant Spellcaster (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+207, 216980, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2171.161376953125, -889.66668701171875, 8.230822563171386718, 0.991282165050506591, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Silver Covenant Spellcaster (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+208, 216983, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2167.49658203125, -884.27606201171875, 7.900500297546386718, 6.052874565124511718, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Kirin Tor Conjuror (Area: Tranquil Strand - Difficulty: 0) CreateObject2 +(@CGUID+209, 219636, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2034.2413330078125, -860.3507080078125, 5.76427459716796875, 6.265034675598144531, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Kirin Tor Conjuror (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@CGUID+210, 216983, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2017.17529296875, -838.03631591796875, 2.327603101730346679, 4.994104862213134765, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Kirin Tor Conjuror (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@CGUID+211, 216976, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2016.1109619140625, -882.77581787109375, 12.66774559020996093, 1.63399815559387207, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Sunreaver Battlemage (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@CGUID+212, 216976, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2085.05517578125, -837.8809814453125, 1.367530465126037597, 2.757314682006835937, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Sunreaver Battlemage (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@CGUID+213, 216983, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2013.770751953125, -835.0819091796875, 2.035548925399780273, 0.145064339041709899, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Kirin Tor Conjuror (Area: Tranquil Strand - Difficulty: 0) CreateObject1 (Auras: ) +(@CGUID+214, 219638, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 1970.013916015625, -856.48089599609375, 13.33491039276123046, 0, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Silver Covenant Spellcaster (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@CGUID+215, 216976, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2151.43701171875, -858.29241943359375, 2.834986686706542968, 0.919806659221649169, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Sunreaver Battlemage (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@CGUID+216, 216976, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2192.9423828125, -886.798828125, 3.840959548950195312, 6.093459129333496093, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Sunreaver Battlemage (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@CGUID+217, 216980, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2106.418701171875, -846.39337158203125, 3.595438480377197265, 0.837923049926757812, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Silver Covenant Spellcaster (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@CGUID+218, 219638, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2050.39404296875, -923.9375, 14.54222393035888671, 1.790153980255126953, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Silver Covenant Spellcaster (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@CGUID+219, 212718, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1998.6614990234375, -912.77606201171875, 16.03472328186035156, 0, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Kirin Tor Conjuror (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@CGUID+220, 212718, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2102.84033203125, -888.373291015625, 10.26264572143554687, 0, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Kirin Tor Conjuror (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@CGUID+221, 219636, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2055.729248046875, -923.47393798828125, 15.16832637786865234, 0.138571709394454956, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Kirin Tor Conjuror (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@CGUID+222, 216976, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2056.248779296875, -935.65374755859375, 19.49976158142089843, 3.842346906661987304, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Sunreaver Battlemage (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@CGUID+223, 214466, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 1997.376708984375, -853.37152099609375, 6.703286647796630859, 5.449717521667480468, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@CGUID+224, 214466, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2014.3524169921875, -866.5399169921875, 9.243086814880371093, 2.036844253540039062, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject1 (Auras: 436058 - Arcane Debuff [DNT]) +(@CGUID+225, 214466, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2000.6961669921875, -842.16668701171875, 2.38952493667602539, 4.645351886749267578, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@CGUID+226, 212721, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2120.963623046875, -824.7100830078125, -0.09467781335115432, 1.265465974807739257, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Underbelly Rogue (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@CGUID+227, 214466, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2102.39404296875, -835.0382080078125, 1.975835680961608886, 0.64678966999053955, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@CGUID+228, 214466, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2115.546875, -834.8038330078125, 1.822032570838928222, 1.77602541446685791, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@CGUID+229, 229868, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2106.598876953125, -822.3524169921875, 0.344894111156463623, 2.04900527000427246, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Fizzi Liverzapper (Area: Tranquil Strand - Difficulty: 0) CreateObject1 (Auras: 463181 - Wounded) +(@CGUID+230, 229867, 2552, 14717, 14774, '0', 22642, 0, 0, 1, 2112.536376953125, -829.263916015625, 0.886013448238372802, 4.789204597473144531, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Raethan (Area: Tranquil Strand - Difficulty: 0) CreateObject1 (Auras: 463181 - Wounded) +(@CGUID+231, 212721, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2106.491455078125, -821.36981201171875, 0.188165575265884399, 0, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Underbelly Rogue (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@CGUID+232, 212721, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2112.645751953125, -830.87677001953125, 1.171614766120910644, 3.673082828521728515, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Underbelly Rogue (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@CGUID+233, 212721, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2109.984375, -828.4444580078125, 0.843021273612976074, 2.116896867752075195, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Underbelly Rogue (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@CGUID+234, 214466, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2033.5347900390625, -920.90802001953125, 13.96036148071289062, 4.142208099365234375, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@CGUID+235, 212721, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2120.7900390625, -801.09722900390625, -0.1688317060470581, 0, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Underbelly Rogue (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@CGUID+236, 212914, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2127.432373046875, -802.24652099609375, 0.681588053703308105, 1.877253293991088867, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Dalaran Sewer Turtle (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@CGUID+237, 214466, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2198.911376953125, -893.513916015625, 4.160859584808349609, 0.501452982425689697, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject1 (Auras: 463278 - Entangled) +(@CGUID+238, 229922, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2210.6875, -889.18402099609375, 0.61208045482635498, 4.601498126983642578, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Applebough (Area: Tranquil Strand - Difficulty: 0) CreateObject1 (Auras: 463277 - Nature Cosmetic [DNT]) +(@CGUID+239, 214466, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2214.802001953125, -898.10589599609375, 1.305214881896972656, 1.386556148529052734, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject1 (Auras: 463278 - Entangled) +(@CGUID+240, 214466, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2218.392333984375, -892.06768798828125, 0.121764212846755981, 2.617760658264160156, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313), -- Nerubian Saboteur (Area: Tranquil Strand - Difficulty: 0) CreateObject1 (Auras: 463278 - Entangled) +(@CGUID+241, 212912, 2552, 14717, 14774, '0', 22642, 0, 0, 0, 2126.8369140625, -800.72918701171875, 0.958718180656433105, 5.145321846008300781, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56313); -- Dalaran Sewer Turtle (Area: Tranquil Strand - Difficulty: 0) CreateObject1 + +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+241; +INSERT INTO `creature_addon` (`guid`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+36, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '459457'), -- Nerubian Saboteur - 459457 - Polymorphed +(@CGUID+112, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '459457'), -- Nerubian Saboteur - 459457 - Polymorphed +(@CGUID+237, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, '463278'), -- Nerubian Saboteur - 463278 - Entangled +(@CGUID+239, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, '463278'), -- Nerubian Saboteur - 463278 - Entangled +(@CGUID+240, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, '463278'); -- Nerubian Saboteur - 463278 - Entangled + +-- GameObject +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+3; +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, 414919, 2552, 14717, 14774, '0', 22642, 0, 2072.954833984375, -950.98956298828125, 18.7959442138671875, 5.515820026397705078, -0.13747358322143554, -0.04321765899658203, -0.37995815277099609, 0.913709461688995361, 120, 255, 0, 56313), -- Tower Fragment (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@OGUID+1, 411837, 2552, 14717, 14774, '0', 22642, 0, 2050.751708984375, -1021.07989501953125, 14.86567211151123046, 5.122759342193603515, 0.078935623168945312, 0.066649436950683593, -0.54772090911865234, 0.83025825023651123, 120, 255, 1, 56313), -- Demonic Gateway (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@OGUID+2, 290530, 2552, 14717, 14774, '0', 22642, 0, 2049.46875, -1024.1978759765625, 15.60464668273925781, 3.804349660873413085, 0, 0, -0.94559478759765625, 0.325346767902374267, 120, 255, 1, 56313), -- Blood Pool (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +(@OGUID+3, 423854, 2552, 14717, 14774, '0', 22642, 0, 2061.80029296875, -1035.1163330078125, 14.57276439666748046, 0, 0, 0, 0, 1, 120, 255, 1, 56313); -- Soulwell (Area: Tranquil Strand - Difficulty: 0) CreateObject1 +DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+3; +INSERT INTO `gameobject_addon` (`guid`, `parent_rotation0`, `parent_rotation1`, `parent_rotation2`, `parent_rotation3`, `WorldEffectID`, `AIAnimKitID`) VALUES +(@OGUID+3, 0, 0, 0, 1, 0, 947); -- Soulwell + +-- Template +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=320, `unit_flags2`=2048 WHERE `entry`=216980; -- Silver Covenant Spellcaster +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=320, `unit_flags2`=2048 WHERE `entry`=216976; -- Sunreaver Battlemage +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048, `unit_flags3`=2147483648 WHERE `entry`=212718; -- Kirin Tor Conjuror +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=214449; -- Kirin Tor Mage +UPDATE `creature_template` SET `faction`=14, `BaseAttackTime`=2000, `unit_flags2`=2048, `unit_flags3`=67108864 WHERE `entry`=217939; -- Swarming Drone +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2049, `unit_flags3`=2214600704 WHERE `entry`=214466; -- Nerubian Saboteur +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry` IN (228057, 212715); -- Nerubian Saboteur +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2049, `unit_flags3`=2214600704 WHERE `entry`=212721; -- Underbelly Rogue +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=256, `unit_flags2`=2048 WHERE `entry`=219637; -- Sunreaver Battlemage +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=229867; -- Raethan +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=229868; -- Fizzi Liverzapper +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=256, `unit_flags2`=2048 WHERE `entry`=219638; -- Silver Covenant Spellcaster +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=320, `unit_flags2`=2048 WHERE `entry` IN (219636, 216983); -- Kirin Tor Conjuror +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=256, `unit_flags2`=2048 WHERE `entry`=214604; -- Recovering Contractor +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=64, `unit_flags2`=2048 WHERE `entry`=212717; -- Nerubian Webspinner +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=576, `unit_flags2`=2048 WHERE `entry`=220068; -- Malfunctioning Spire +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048, `unit_flags3`=2147483648 WHERE `entry`=214522; -- Sunreaver Battlemage +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=229922; -- Applebough +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags2`=2048, `unit_flags3`=67108864 WHERE `entry`=217949; -- Skittering Swarmite + +-- Template Addon +DELETE FROM `creature_template_addon` WHERE `entry` IN (216980 /*216980 (Silver Covenant Spellcaster)*/, 216983 /*216983 (Kirin Tor Conjuror)*/, 216976 /*216976 (Sunreaver Battlemage)*/, 219638 /*219638 (Silver Covenant Spellcaster)*/, 219636 /*219636 (Kirin Tor Conjuror)*/, 219637 /*219637 (Sunreaver Battlemage)*/, 229922 /*229922 (Applebough) - Nature Cosmetic [DNT]*/, 229867 /*229867 (Raethan) - Wounded*/, 229868 /*229868 (Fizzi Liverzapper) - Wounded*/, 212721 /*212721 (Underbelly Rogue)*/, 214466 /*214466 (Nerubian Saboteur)*/, 212717); +INSERT INTO `creature_template_addon` (`entry`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(216980, 0, 0, 0, 0, 0, 1, 0, 0, 28856, 0, 0, 0, ''), -- 216980 (Silver Covenant Spellcaster) +(216983, 0, 0, 0, 0, 0, 1, 0, 0, 28856, 0, 0, 0, ''), -- 216983 (Kirin Tor Conjuror) +(216976, 0, 0, 0, 0, 0, 1, 0, 0, 13818, 0, 0, 0, ''), -- 216976 (Sunreaver Battlemage) +(219638, 0, 0, 0, 0, 0, 1, 0, 0, 28856, 0, 0, 0, ''), -- 219638 (Silver Covenant Spellcaster) +(219636, 0, 0, 0, 0, 0, 1, 0, 0, 28856, 0, 0, 0, ''), -- 219636 (Kirin Tor Conjuror) +(219637, 0, 0, 0, 0, 0, 1, 0, 0, 28856, 0, 0, 0, ''), -- 219637 (Sunreaver Battlemage) +(229922, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '463277'), -- 229922 (Applebough) - Nature Cosmetic [DNT] +(229867, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, '463181'), -- 229867 (Raethan) - Wounded +(229868, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, '463181'), -- 229868 (Fizzi Liverzapper) - Wounded +(212721, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 0, 0, ''), -- 212721 (Underbelly Rogue) +(214466, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, ''), -- 214466 (Nerubian Saboteur) +(212717, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '436072'); -- 212717 (Nerubian Webspinner) - Sticky Webs + +DELETE FROM `gameobject_template_addon` WHERE `entry` IN (423854 /*Soulwell*/, 414919 /*Tower Fragment*/); +INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES +(423854, 0, 262144, 0, 947), -- Soulwell +(414919, 0, 262145, 0, 0); -- Tower Fragment + +-- Creature Sparring +DELETE FROM `creature_template_sparring` WHERE `Entry` = 212715; +INSERT INTO `creature_template_sparring` (`Entry`, `NoNPCDamageBelowHealthPct`) VALUES +(212715, 85); + +-- Phase +DELETE FROM `phase_area` WHERE `PhaseId` = 22642; +INSERT INTO `phase_area` (`AreaId`, `PhaseId`, `Comment`) VALUES +(14774, 22642, 'Tranquil Strand - Nerubian Battle'); + +DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId`=26 AND `SourceGroup` = 22642 AND `SourceEntry` = 0); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `Comment`) VALUE +(26, 22642, 0, 0, 0, 47, 0, 78529, 2|8|64, 0, 0, 'Apply Phase 22642 if Quest 78529 is taken | complete | rewarded'); + +-- Difficulty +DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID`=0 AND `Entry` IN (212915,212913,212911,217960,228059,214543,228057,214522,229922,214472,212795,216932,214604,214470,214569,214570)); +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`) VALUES +(212915, 0, 10, 1, 1, 262310, 0, 0), -- Dalaran Sewer Turtle +(212913, 0, 10, 1, 1, 262308, 0, 67108864), -- Dalaran Sewer Turtle +(212911, 0, 10, 1, 1, 262306, 0, 0), -- Dalaran Sewer Rat +(217960, 0, 10, 1, 1, 267455, 0, 0), -- Surviving Warlock +(228059, 0, 10, 1, 1, 279243, 1610612752, 117440582), -- Missile Stalker [DNT] +(214543, 0, 10, 10, 1, 263985, 0, 64), -- Polymorphed Victim +(228057, 0, 10, 1, 1, 279240, 0, 0), -- Nerubian Saboteur +(214522, 0, 10, 1, 1, 263964, 0, 0), -- Sunreaver Battlemage +(229922, 0, 10, 1, 1, 281214, 0, 0), -- Applebough +(214472, 0, 10, 10, 1, 263914, 0, 0), -- Meryl Felstorm +(212795, 0, 10, 1, 1, 262168, 1610612752, 117440518), -- Damaged Arcane Relic +(216932, 0, 10, 1, 1, 266422, 0, 0), -- Arcane Bunny [DNT] +(214604, 0, 10, 1, 1, 264051, 0, 0), -- Recovering Contractor +(214470, 0, 10, 10, 1, 263912, 0, 0), -- Marin Noggenfogger +(214569, 0, 10, 1, 1, 264011, 0, 0), -- Envenomed Contractor +(214570, 0, 10, 1, 1, 264012, 0, 0); -- Underbelly Bruiser + +UPDATE `creature_template_difficulty` SET `ContentTuningID`=81, `VerifiedBuild`=56313 WHERE (`Entry`=212915 AND `DifficultyID`=0); -- 212915 (Dalaran Sewer Turtle) - +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=56313 WHERE (`DifficultyID`=0 AND `Entry` IN (228101,174170,98035,55659,143622,212914,212912,211858,214585,214586,212717,214471,212719,219638,219636,229867,229868,214595,219637,211994,214520,212721,212720,216980,220038,211993,216976,220067,212718,214449,216983,217939,214466,217949,212715)); +UPDATE `creature_template_difficulty` SET `ContentTuningID`=81, `StaticFlags1`=268435456, `StaticFlags3`=33554432, `VerifiedBuild`=56313 WHERE (`Entry`=212913 AND `DifficultyID`=0); -- 212913 (Dalaran Sewer Turtle) - CanSwim - CannotTurn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=81, `VerifiedBuild`=56313 WHERE (`Entry`=212911 AND `DifficultyID`=0); -- 212911 (Dalaran Sewer Rat) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2797, `StaticFlags1`=268435456, `VerifiedBuild`=56313 WHERE (`Entry`=217960 AND `DifficultyID`=0); -- 217960 (Surviving Warlock) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2797, `StaticFlags1`=805306624, `VerifiedBuild`=56313 WHERE (`Entry`=228059 AND `DifficultyID`=0); -- 228059 (Missile Stalker [DNT]) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2797, `StaticFlags1`=268435456, `VerifiedBuild`=56313 WHERE (`Entry`=228057 AND `DifficultyID`=0); -- 228057 (Nerubian Saboteur) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2462, `StaticFlags1`=268435456, `VerifiedBuild`=56313 WHERE (`Entry`=212449 AND `DifficultyID`=0); -- 212449 (Magni Bronzebeard) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2797, `StaticFlags1`=268435456, `VerifiedBuild`=56313 WHERE (`Entry`=214522 AND `DifficultyID`=0); -- 214522 (Sunreaver Battlemage) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2797, `StaticFlags1`=268435456, `VerifiedBuild`=56313 WHERE (`Entry`=229922 AND `DifficultyID`=0); -- 229922 (Applebough) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2797, `StaticFlags1`=268435456, `VerifiedBuild`=56313 WHERE (`Entry`=220068 AND `DifficultyID`=0); -- 220068 (Malfunctioning Spire) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2797, `StaticFlags1`=268435456, `VerifiedBuild`=56313 WHERE (`Entry`=214472 AND `DifficultyID`=0); -- 214472 (Meryl Felstorm) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2797, `StaticFlags1`=805306624, `VerifiedBuild`=56313 WHERE (`Entry`=212795 AND `DifficultyID`=0); -- 212795 (Damaged Arcane Relic) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2797, `StaticFlags1`=536871168, `VerifiedBuild`=56313 WHERE (`Entry`=216932 AND `DifficultyID`=0); -- 216932 (Arcane Bunny [DNT]) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2797, `StaticFlags1`=268435456, `VerifiedBuild`=56313 WHERE (`Entry`=214470 AND `DifficultyID`=0); -- 214470 (Marin Noggenfogger) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2797, `StaticFlags1`=268435456, `VerifiedBuild`=56313 WHERE (`Entry`=214604 AND `DifficultyID`=0); -- 214604 (Recovering Contractor) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2797, `StaticFlags1`=268435456, `VerifiedBuild`=56313 WHERE (`Entry`=214569 AND `DifficultyID`=0); -- 214569 (Envenomed Contractor) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2797, `StaticFlags1`=268435456, `VerifiedBuild`=56313 WHERE (`Entry`=214570 AND `DifficultyID`=0); -- 214570 (Underbelly Bruiser) - CanSwim + +-- Model +DELETE FROM `creature_model_info` WHERE `DisplayID` IN (122149, 122151, 116167); +INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES +(122149, 0.305999994277954101, 1.5, 0, 56313), +(122151, 0.305999994277954101, 1.5, 0, 56313), +(116167, 1.006044268608093261, 0, 0, 56313); + +UPDATE `creature_model_info` SET `VerifiedBuild`=56313 WHERE `DisplayID` IN (77687, 54918, 121468, 114650, 121467, 114929, 114304, 856, 857, 26759, 100727, 120682, 28158, 64965, 77404, 77406, 77402, 77403, 77405, 77407, 45042, 72532, 72555, 72551, 72549, 72547, 46605, 28151, 109247, 116130, 46607, 28157, 115747, 107538, 121972, 114868, 68019, 121982, 46608, 46606, 121988, 65106, 109344, 121974, 121976, 67760, 114867, 121975, 121992, 115746, 68020, 68022, 121985, 16259, 74160, 11686, 114662, 31319, 116109, 122146, 121989, 55233, 121978, 122147, 121984, 99452, 115745, 117186, 71445, 71461, 3257, 121971, 121991, 65187, 71599, 68021, 121981, 88316, 121970, 121979, 93415, 121969, 72494, 99451, 121973, 121983, 109350, 121980, 115495, 121986, 121977, 115110, 121990, 58289, 121987, 114531, 114532); +UPDATE `creature_model_info` SET `BoundingRadius`=0.305999994277954101, `CombatReach`=1.5, `VerifiedBuild`=56313 WHERE `DisplayID`=72548; +UPDATE `creature_model_info` SET `BoundingRadius`=0.630706548690795898, `CombatReach`=1.80000007152557373, `VerifiedBuild`=56313 WHERE `DisplayID`=73483; +UPDATE `creature_model_info` SET `BoundingRadius`=2.212586402893066406, `CombatReach`=2.03125, `VerifiedBuild`=56313 WHERE `DisplayID`=114512; |