diff options
| -rw-r--r-- | sql/updates/world/master/2025_06_26_00_world.sql | 877 |
1 files changed, 877 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_06_26_00_world.sql b/sql/updates/world/master/2025_06_26_00_world.sql new file mode 100644 index 00000000000..723553e73ba --- /dev/null +++ b/sql/updates/world/master/2025_06_26_00_world.sql @@ -0,0 +1,877 @@ +SET @CGUID := 6004988; +SET @OGUID := 6002747; + +-- Creature +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+165; +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, 116864, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4572.1513671875, -2266.7041015625, 2968.726318359375, 1.18160414695739746, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+1, 116864, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4568.0380859375, -2271.953125, 2974.485595703125, 4.441329002380371093, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+2, 116495, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4571.21142578125, -2221.516357421875, 2904.576904296875, 1.103187322616577148, 7200, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Rat (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+3, 115484, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4596.375, -2259.145751953125, 2916.196044921875, 0.449937880039215087, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Fel Bat (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 229621 - Short Temper) +(@CGUID+4, 116864, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4567.37744140625, -2265.604248046875, 2973.227783203125, 0.428879052400588989, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+5, 116495, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4487.783203125, -2244.267333984375, 2932.63330078125, 6.265491008758544921, 7200, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Rat (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+6, 116495, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4485.55322265625, -2248.529052734375, 2932.76806640625, 0.152358323335647583, 7200, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Rat (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+7, 115484, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4569.890625, -2259.685791015625, 2912.85400390625, 0.402428150177001953, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Fel Bat (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 229621 - Short Temper) +(@CGUID+8, 116495, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4530.9560546875, -2177.382080078125, 2880.83447265625, 2.134500980377197265, 7200, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Rat (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+9, 115488, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4584.53466796875, -2210.6416015625, 2900.841796875, 1.519435882568359375, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Infused Pyromancer (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+10, 115484, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4614.876953125, -2249.828125, 2913.52392578125, 2.903269529342651367, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Fel Bat (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 229621 - Short Temper) +(@CGUID+11, 115488, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4581.126953125, -2175.299560546875, 2880.7763671875, 0.027241995558142662, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Infused Pyromancer (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+12, 115484, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4610.1806640625, -2218, 2913.52392578125, 2.903269529342651367, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Fel Bat (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 229621 - Short Temper) +(@CGUID+13, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4589.45166015625, -2314.720458984375, 2868.19677734375, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+14, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4584.5, -2309.770751953125, 2868.15869140625, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+15, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4589.45166015625, -2304.8212890625, 2868.19677734375, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+16, 116864, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4594.1328125, -2311.877197265625, 2909.08056640625, 1.894892573356628417, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+17, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4594.3994140625, -2309.770751953125, 2868.15869140625, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+18, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4584.5, -2319.670166015625, 2868.15869140625, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+19, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4614.19970703125, -2309.770751953125, 2868.15869140625, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+20, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4614.19970703125, -2319.670166015625, 2868.15869140625, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+21, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4599.3505859375, -2334.51904296875, 2868.19677734375, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+22, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4589.45166015625, -2324.619873046875, 2868.19677734375, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+23, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4594.3994140625, -2339.46875, 2868.15869140625, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+24, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4604.298828125, -2319.670166015625, 2868.15869140625, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+25, 115484, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4632.55224609375, -2145.609619140625, 2916.986572265625, 2.070325613021850585, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Fel Bat (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 229621 - Short Temper) +(@CGUID+26, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4604.298828125, -2329.569580078125, 2868.15869140625, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+27, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4599.3505859375, -2324.619873046875, 2868.19677734375, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+28, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4594.3994140625, -2329.569580078125, 2868.15869140625, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+29, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4604.298828125, -2309.770751953125, 2868.15869140625, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+30, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4599.3505859375, -2314.720458984375, 2868.19677734375, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+31, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4584.5, -2329.569580078125, 2868.15869140625, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+32, 116864, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4591.490234375, -2328.274658203125, 2912.5986328125, 4.057215690612792968, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+33, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4609.25, -2314.720458984375, 2868.19677734375, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+34, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4594.3994140625, -2319.670166015625, 2868.15869140625, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+35, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4599.3505859375, -2304.8212890625, 2868.19677734375, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+36, 116864, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4605.38818359375, -2334.11669921875, 2905.975830078125, 4.314844608306884765, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+37, 115757, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 1, -4599.41845703125, -2329.588623046875, 2868.407958984375, 1.576775670051574707, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Wrathguard Flamebringer (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 230045 - Melee Override, 42459 - Dual Wield) +(@CGUID+38, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4609.25, -2324.619873046875, 2868.19677734375, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+39, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4614.19970703125, -2329.569580078125, 2868.15869140625, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+40, 116864, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4606.4033203125, -2320.93212890625, 2910.132080078125, 3.9158935546875, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+41, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4609.25, -2304.8212890625, 2868.19677734375, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+42, 115484, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4529.8330078125, -2166.76025390625, 2775.92822265625, 5.374750137329101562, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Fel Bat (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 229621 - Short Temper) +(@CGUID+43, 115488, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4662.8037109375, -2149.140625, 2855.783447265625, 2.484714269638061523, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Infused Pyromancer (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+44, 115488, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4675.4111328125, -2158.26171875, 2853.072509765625, 2.538235187530517578, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Infused Pyromancer (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+45, 115484, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4597.35693359375, -2211.90478515625, 2779.9208984375, 5.695137500762939453, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Fel Bat (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 229621 - Short Temper) +(@CGUID+46, 115484, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4655.90234375, -2242.8896484375, 2835.468017578125, 1.022846102714538574, 7200, 10, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Fel Bat (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 229621 - Short Temper) (possible waypoints or random movement) +(@CGUID+47, 115484, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4638.20166015625, -2134.342529296875, 2754.25439453125, 5.089190959930419921, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Fel Bat (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 229621 - Short Temper) +(@CGUID+48, 115757, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 1, -4710.48291015625, -2111.27392578125, 2871.3212890625, 3.08612680435180664, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Wrathguard Flamebringer (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 230045 - Melee Override, 42459 - Dual Wield) +(@CGUID+49, 116864, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4696.220703125, -2303.238525390625, 2899.91748046875, 3.2878265380859375, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+50, 116864, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4698.28662109375, -2313.870361328125, 2901.314453125, 2.428710460662841796, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+51, 115488, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4689.15283203125, -2308.429443359375, 2880.03759765625, 4.750634670257568359, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Infused Pyromancer (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+52, 116864, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4694.70361328125, -2324.860107421875, 2895.901611328125, 4.862498283386230468, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+53, 115484, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4649.15283203125, -2236.3037109375, 2748.33740234375, 5.374760627746582031, 7200, 10, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Fel Bat (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 229621 - Short Temper) (possible waypoints or random movement) +(@CGUID+54, 116495, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4595.2529296875, -2472.16162109375, 2876.51123046875, 3.484880447387695312, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Rat (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+55, 114350, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 1, -4599.0556640625, -2524.583251953125, 2876.592529296875, 1.708566904067993164, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Shade of Medivh (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 189573 - Arcane Channel) +(@CGUID+56, 116865, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4515.73974609375, -2725.4404296875, 1019.685791015625, 3.957487344741821289, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+57, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4589.45166015625, -2334.51904296875, 2363.433349609375, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+58, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4604.298828125, -2339.46875, 2363.39501953125, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+59, 116865, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -5053.37646484375, -2877.38671875, 883.00274658203125, 0.389759689569473266, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+60, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4614.19970703125, -2339.46875, 2363.39501953125, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+61, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4609.25, -2334.51904296875, 2363.433349609375, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+62, 116865, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4525.40771484375, -2796.75439453125, 801.83441162109375, 0.955771863460540771, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+63, 115746, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4584.5, -2339.46875, 2363.39501953125, 0.78539818525314331, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Burning Tiles (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+64, 116865, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4218.93603515625, -2696.289306640625, 819.41217041015625, 6.04120635986328125, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+65, 116865, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4929.888671875, -2858.682373046875, 757.2479248046875, 0.205584391951560974, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+66, 116865, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4009.923828125, -2901.9619140625, 848.37969970703125, 4.339352130889892578, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+67, 116865, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4123.16748046875, -2845.36181640625, 718.59405517578125, 3.020385265350341796, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+68, 116494, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4945.2958984375, -2694.90771484375, 153.6284637451171875, 2.860342025756835937, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Mana Devourer (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+69, 116494, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4996.40380859375, -2664.113525390625, 153.6361083984375, 2.152373552322387695, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Mana Devourer (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+70, 116494, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4983.2841796875, -2707.19091796875, 153.6284637451171875, 5.221322536468505859, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Mana Devourer (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+71, 115417, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4558.56396484375, -2603.1748046875, 154.225341796875, 1.634811282157897949, 7200, 10, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Rat (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+72, 115419, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4743.87646484375, -2573.742431640625, 153.504791259765625, 2.831016302108764648, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Ancient Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+73, 115418, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4543.93212890625, -2576.337158203125, 154.2524261474609375, 5.3332672119140625, 7200, 10, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Spider (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: ) +(@CGUID+74, 115417, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4624.07763671875, -2593.181640625, 153.4284820556640625, 0.822370469570159912, 7200, 10, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Rat (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: ) (possible waypoints or random movement) +(@CGUID+75, 115419, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4463.40234375, -2555.666015625, 154.230377197265625, 4.08889007568359375, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Ancient Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+76, 115417, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4493.47119140625, -2629.690185546875, 153.428466796875, 3.711565971374511718, 7200, 10, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Rat (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: ) +(@CGUID+77, 114252, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4358.3544921875, -2628.598876953125, 153.433258056640625, 3.776975154876708984, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Mana Devourer (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 388184 - Override Energy Bar Color) +(@CGUID+78, 115418, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4409.45751953125, -2600.90966796875, 153.428466796875, 3.32038116455078125, 7200, 10, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Spider (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: ) +(@CGUID+79, 116494, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4041.7060546875, -2776.79833984375, 153.62847900390625, 1.953140139579772949, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Mana Devourer (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+80, 116494, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4027.704833984375, -2821.43017578125, 153.62847900390625, 0.493231803178787231, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Mana Devourer (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+81, 116494, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -3984.859130859375, -2818.482177734375, 153.6284637451171875, 0.394230246543884277, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Mana Devourer (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+82, 63420, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, -4474.01025390625, -2597.0712890625, 153.3470001220703125, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- SLG Generic MoP (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+83, 116551, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4164.01318359375, -2055.961669921875, 750.9820556640625, 1.240807652473449707, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+84, 115484, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4138.9140625, -2284.345458984375, 711.41778564453125, 1.695798754692077636, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Fel Bat (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 229621 - Short Temper) +(@CGUID+85, 115831, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4143.80810546875, -2087.89013671875, 727.88287353515625, 4.612326622009277343, 7200, 3, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Mana Devourer (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 232309 - Charging Up) +(@CGUID+86, 116551, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4175.61865234375, -2065.428955078125, 751.67974853515625, 0.763853490352630615, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+87, 116495, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4116.8447265625, -2053.318359375, 730.67974853515625, 5.291539669036865234, 7200, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Rat (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+88, 115831, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4116.22314453125, -2060.741943359375, 730.67974853515625, 6.142392635345458984, 7200, 3, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Mana Devourer (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+89, 116491, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4160.86376953125, -2092.3525390625, 748.26641845703125, 1.31820082664489746, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Spider (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+90, 115831, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4120.80029296875, -2043.04150390625, 730.67974853515625, 3.020617246627807617, 7200, 3, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Mana Devourer (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+91, 116491, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4171.2939453125, -2076.46923828125, 748.6798095703125, 0.41174432635307312, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Spider (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+92, 116551, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4146.30810546875, -2040.09375, 750.13775634765625, 2.913249492645263671, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+93, 116495, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4155.65966796875, -2034.811279296875, 748.81463623046875, 2.133587837219238281, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Rat (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+94, 115831, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4144.45654296875, -2088.77001953125, 727.88287353515625, 3.926598072052001953, 7200, 3, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Mana Devourer (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 232309 - Charging Up) +(@CGUID+95, 116495, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4124.4853515625, -2040.3377685546875, 730.67974853515625, 1.093411445617675781, 7200, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Rat (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+96, 116491, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4128.63037109375, -2032.85986328125, 748.790771484375, 3.014122962951660156, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Spider (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+97, 116551, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4111.8837890625, -2055.45361328125, 752.88287353515625, 2.930145025253295898, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+98, 115487, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4145.31689453125, -2065.75341796875, 727.752685546875, 4.159482955932617187, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Medivh (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 229594 - Vision, 227369 - Mod Scale +10% [DNT], 145363 - Permanent Feign Death (Stun, Untrackable, Immune)) +(@CGUID+99, 115831, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4116.6630859375, -2065.24658203125, 730.6798095703125, 3.010401725769042968, 7200, 3, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Mana Devourer (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+100, 115484, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4037.13623046875, -2252.1650390625, 785.10760498046875, 2.903269529342651367, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Fel Bat (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 229621 - Short Temper) +(@CGUID+101, 116551, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4167.16015625, -2045.8104248046875, 751.0548095703125, 2.320239782333374023, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+102, 116491, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4163.78125, -2061.79541015625, 727.8828125, 0.584311664104461669, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Spider (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+103, 115831, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4172.72705078125, -2063.107421875, 730.6798095703125, 3.329756498336791992, 7200, 3, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Mana Devourer (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+104, 115831, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4151.28466796875, -2032.1319580078125, 730.63983154296875, 0, 7200, 3, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Mana Devourer (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 145363 - Permanent Feign Death (Stun, Untrackable, Immune)) +(@CGUID+105, 116491, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4173.65576171875, -2094.790771484375, 727.88287353515625, 4.462822437286376953, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Spider (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+106, 115489, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 1, 4143.50439453125, -2068.65625, 727.90020751953125, 1.206694245338439941, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Anduin Lothar (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 229485 - Vision) +(@CGUID+107, 116495, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4156.8779296875, -2049.756103515625, 727.8829345703125, 6.105372905731201171, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Rat (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+108, 115831, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4172.82568359375, -2049.640625, 730.6798095703125, 0.811840653419494628, 7200, 3, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Mana Devourer (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+109, 116495, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4172.81298828125, -2063.12890625, 730.6798095703125, 4.368546485900878906, 7200, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Rat (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+110, 116551, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4151.39697265625, -2072.472412109375, 750.214599609375, 4.198017120361328125, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+111, 115484, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4128.796875, -2283.335205078125, 731.0413818359375, 5.714715957641601562, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Fel Bat (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 229621 - Short Temper) +(@CGUID+112, 116495, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4165.1552734375, -2082.49462890625, 727.88287353515625, 0.017884636297821998, 7200, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Rat (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+113, 116551, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4131.72900390625, -2045.6231689453125, 752.1708984375, 4.827420711517333984, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+114, 116804, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4145.18212890625, -2059.30029296875, 727.2620849609375, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Scene Actor (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+115, 116495, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4119.7734375, -2040.6295166015625, 748.74310302734375, 2.390640735626220703, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Rat (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+116, 114913, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 3800.630126953125, -1876.4896240234375, 869.97784423828125, 4.188632965087890625, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Command Ship (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+117, 115831, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4172.71923828125, -2063.081787109375, 730.6798095703125, 0.296049505472183227, 7200, 3, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Mana Devourer (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+118, 115484, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4100.28466796875, -2247.74658203125, 746.7677001953125, 4.070464134216308593, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Fel Bat (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 229621 - Short Temper) +(@CGUID+119, 116491, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4146, -2031.8194580078125, 730.63983154296875, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Spider (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 145363 - Permanent Feign Death (Stun, Untrackable, Immune)) +(@CGUID+120, 116495, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4169.67724609375, -2046.76806640625, 731.139404296875, 3.629835844039916992, 7200, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Rat (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+121, 115831, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4119.27099609375, -2039.855712890625, 730.67974853515625, 2.678457498550415039, 7200, 3, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Mana Devourer (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+122, 115501, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 1, 4146.19189453125, -2068.635498046875, 727.90020751953125, 1.962789535522460937, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Archmage Khadgar (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 229485 - Vision) +(@CGUID+123, 116551, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4139.35595703125, -2075.499267578125, 751.18017578125, 0.078503139317035675, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+124, 114790, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 3657.49658203125, -2125.796875, 815.6807861328125, 4.998692989349365234, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Viz'aduum the Watcher (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+125, 116495, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4140.20654296875, -2030.7239990234375, 730.63983154296875, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Rat (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 145363 - Permanent Feign Death (Stun, Untrackable, Immune)) +(@CGUID+126, 116551, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4139.58056640625, -2087.210205078125, 751.40570068359375, 2.344496488571166992, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+127, 116495, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4171.6884765625, -2059.651611328125, 748.74542236328125, 4.488528728485107421, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Rat (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+128, 115831, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4115.5546875, -2061.12109375, 730.67974853515625, 3.694691181182861328, 7200, 3, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Mana Devourer (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+129, 115484, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4005.552978515625, -2262.34716796875, 795.2569580078125, 0.402428150177001953, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Fel Bat (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 229621 - Short Temper) +(@CGUID+130, 116491, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4125.337890625, -2092.729736328125, 727.860595703125, 4.774980545043945312, 7200, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Spider (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+131, 116495, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4124.28369140625, -2074.676025390625, 748.6798095703125, 5.792941570281982421, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Rat (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+132, 116551, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4133.3798828125, -2037.3126220703125, 751.5517578125, 5.542613983154296875, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+133, 115831, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4123.38720703125, -2043.5679931640625, 731.47662353515625, 5.262396812438964843, 7200, 3, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Mana Devourer (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+134, 115831, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4143.76416015625, -2087.442626953125, 727.90020751953125, 4.191956043243408203, 7200, 3, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Mana Devourer (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: ) +(@CGUID+135, 116495, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4149.04931640625, -2031.5989990234375, 730.63983154296875, 0, 7200, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Rat (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 145363 - Permanent Feign Death (Stun, Untrackable, Immune)) +(@CGUID+136, 116491, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4114.14208984375, -2089.14990234375, 748.0859375, 1.458954691886901855, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Spider (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+137, 115488, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4030.796142578125, -2254.151123046875, 763.7003173828125, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Infused Pyromancer (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+138, 115386, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 3938.673583984375, -2223.77783203125, 781.4248046875, 3.181042909622192382, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Chest Board (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: ) +(@CGUID+139, 115831, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4172.4853515625, -2049.39453125, 730.6798095703125, 4.303403854370117187, 7200, 3, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Mana Devourer (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+140, 116551, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4157.3955078125, -2082.09423828125, 753.03887939453125, 2.401462793350219726, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+141, 115484, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 3984.244873046875, -2250.6181640625, 797.3056640625, 0.449937880039215087, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Fel Bat (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 229621 - Short Temper) +(@CGUID+142, 115486, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 1, 4090.841064453125, -2262.95654296875, 737.55316162109375, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Erudite Slayer (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+143, 116551, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4120.82373046875, -2074.76220703125, 749.53533935546875, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Flying Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+144, 115831, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4172.748046875, -2061.588134765625, 730.6798095703125, 5.33186197280883789, 7200, 3, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Mana Devourer (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+145, 115484, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4088.490478515625, -2236.484375, 743.72552490234375, 4.700222969055175781, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Fel Bat (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 229621 - Short Temper) +(@CGUID+146, 116491, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4159.33056640625, -2034.543212890625, 730.67974853515625, 0.082121722400188446, 7200, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Spider (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+147, 115831, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4173.953125, -2049.328857421875, 730.6798095703125, 3.638588905334472656, 7200, 3, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Mana Devourer (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+148, 115484, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4145.38720703125, -2283.979248046875, 717.31768798828125, 1.695798754692077636, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Fel Bat (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 229621 - Short Temper) +(@CGUID+149, 116495, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4129.2109375, -2050.013671875, 727.88287353515625, 1.043905615806579589, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Rat (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+150, 116495, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4138.0185546875, -2030.590087890625, 730.6796875, 0.817997753620147705, 7200, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Rat (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+151, 114913, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 3397.1103515625, -2142.850830078125, 977.435302734375, 6.115651130676269531, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Command Ship (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@CGUID+152, 115484, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4096.46337890625, -2273.470458984375, 753.9464111328125, 2.289373159408569335, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Fel Bat (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 229621 - Short Temper) +(@CGUID+153, 116491, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 4150.025390625, -2029.04345703125, 730.63983154296875, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Spider (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 145363 - Permanent Feign Death (Stun, Untrackable, Immune)) +(@CGUID+154, 115406, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 1, 3915.780517578125, -2248.51904296875, 778.0811767578125, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Knight (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 232713 - Transform - Wolf, 229442 - Chess Piece, 229467 - Chess Piece, 229490 - King's Court) +(@CGUID+155, 115486, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 1, 3938.4462890625, -2241.4931640625, 779.3878173828125, 1.691205859184265136, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Erudite Slayer (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 145363 - Permanent Feign Death (Stun, Untrackable, Immune)) +(@CGUID+156, 115488, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 3933.093017578125, -2267.09033203125, 780.369873046875, 3.255775213241577148, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Infused Pyromancer (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 145363 - Permanent Feign Death (Stun, Untrackable, Immune)) +(@CGUID+157, 115402, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 3915.86279296875, -2236.94091796875, 779.3514404296875, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Bishop (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 232711 - Transform - Necrolyte, 229442 - Chess Piece, 229467 - Chess Piece, 229490 - King's Court) +(@CGUID+158, 115401, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 3909.4462890625, -2225.170166015625, 784.78497314453125, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Bishop (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 232711 - Transform - Necrolyte, 229442 - Chess Piece, 229467 - Chess Piece, 229490 - King's Court) +(@CGUID+159, 115406, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 1, 3915.7353515625, -2254.421875, 777.518798828125, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Knight (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 232713 - Transform - Wolf, 229442 - Chess Piece, 229467 - Chess Piece, 229490 - King's Court) +(@CGUID+160, 115388, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 1, 3909.040771484375, -2248.782958984375, 778.2216796875, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- King (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 232710 - Transform - Warchief, 229489 - Royalty) +(@CGUID+161, 115407, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 3896.475830078125, -2243.25, 780.2884521484375, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Rook (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 229442 - Chess Piece, 229467 - Chess Piece, 229490 - King's Court) +(@CGUID+162, 115395, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 3908.66064453125, -2254.63720703125, 777.19921875, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Queen (Area: Karazhan - Difficulty: Heroic) CreateObject1 (Auras: 232712 - Transform - Warlock, 229442 - Chess Piece, 229467 - Chess Piece, 229490 - King's Court) +(@CGUID+163, 115734, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 3526.75537109375, -1989.435791015625, 1061.7822265625, 6.039111137390136718, 7200, 10, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Shadow Spitter (Area: Karazhan - Difficulty: Heroic) CreateObject1 (possible waypoints or random movement) +(@CGUID+164, 115734, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 3466.741943359375, -2028.9730224609375, 1065.2733154296875, 0.163444593548774719, 7200, 10, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Shadow Spitter (Area: Karazhan - Difficulty: Heroic) CreateObject1 (possible waypoints or random movement) +(@CGUID+165, 114913, 1651, 8443, 8443, '23,2,8', 0, 0, 0, 0, 3496.739501953125, -1959.6597900390625, 996.70330810546875, 5.802992820739746093, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 61609); -- Command Ship (Area: Karazhan - Difficulty: Heroic) CreateObject2 +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+165; +INSERT INTO `creature_addon` (`guid`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+98, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 0, 3, '229594 227369 145363'), -- Medivh - 229594 - Vision, 227369 - Mod Scale +10% [DNT], 145363 - Permanent Feign Death (Stun, Untrackable, Immune) +(@CGUID+104, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 0, 0, '145363'), -- Mana Devourer - 145363 - Permanent Feign Death (Stun, Untrackable, Immune) +(@CGUID+119, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 0, 0, '145363'), -- Spider - 145363 - Permanent Feign Death (Stun, Untrackable, Immune) +(@CGUID+125, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 0, 0, '145363'), -- Rat - 145363 - Permanent Feign Death (Stun, Untrackable, Immune) +(@CGUID+153, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 0, 0, '145363'), -- Spider - 145363 - Permanent Feign Death (Stun, Untrackable, Immune) +(@CGUID+155, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 0, 0, '145363'), -- Erudite Slayer - 145363 - Permanent Feign Death (Stun, Untrackable, Immune) +(@CGUID+156, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 0, 0, '145363'); -- Infused Pyromancer - 145363 - Permanent Feign Death (Stun, Untrackable, Immune) + +-- GameObject +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+57; +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, 266896, 1651, 8443, 8443, '23,2,8', 0, 0, -4556.51953125, -2257.885009765625, 2950.0673828125, 0, 0, 0, 0, 1, 7200, 255, 1, 61609), -- Doodad_7DU_KarazhanB_BooksFall001 (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+1, 266806, 1651, 8443, 8443, '23,2,8', 0, 0, -4489.18603515625, -2223.04296875, 2951.933349609375, 4.712389945983886718, 0.707106590270996093, -0.70710659027099609, 0, 0, 7200, 255, 0, 61609), -- Mysterious Wall (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+2, 259984, 1651, 8443, 8443, '23,2,8', 0, 0, -4569.67431640625, -2300.66259765625, 2981.42236328125, 3.849053382873535156, -0.34639883041381835, 0.938086509704589843, 0, 0.001244877814315259, 7200, 255, 1, 61609), -- Doodad_GeneralChairHighEnd180 (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+3, 259982, 1651, 8443, 8443, '23,2,8', 0, 0, -4580.87890625, -2293.871337890625, 2981.42236328125, 3.767702579498291015, -0.30796623229980468, 0.951396942138671875, 0, 0, 7200, 255, 1, 61609), -- Doodad_GeneralChairHighEnd178 (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+4, 259980, 1651, 8443, 8443, '23,2,8', 0, 0, -4650.84716796875, -2157.835205078125, 2937.5126953125, 3.777671575546264648, -0.31270456314086914, 0.949850082397460937, 0, 0, 7200, 255, 1, 61609), -- Doodad_GeneralMedChair99 (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+5, 259985, 1651, 8443, 8443, '23,2,8', 0, 0, -4599.40869140625, -2346.009765625, 2915.10986328125, 3.141592741012573242, 0, -1, 0, 0, 7200, 255, 1, 61609), -- Door (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+6, 266895, 1651, 8443, 8443, '23,2,8', 0, 0, -4621.8193359375, -2285.086669921875, 2950.0673828125, 0, 0, 0, 0, 1, 7200, 255, 1, 61609), -- Doodad_7DU_KarazhanB_BooksFall003 (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+7, 266894, 1651, 8443, 8443, '23,2,8', 0, 0, -4642.9423828125, -2259.5458984375, 2950.0673828125, 0, 0, 0, 0, 1, 7200, 255, 1, 61609), -- Doodad_7DU_KarazhanB_BooksFall002 (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+8, 259978, 1651, 8443, 8443, '23,2,8', 0, 0, -4644.1591796875, -2173.1591796875, 2937.647705078125, 3.401400089263916015, -0.12953853607177734, 0.991574287414550781, 0, 0, 7200, 255, 1, 61609), -- Doodad_GeneralMedChair97 (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+9, 259977, 1651, 8443, 8443, '23,2,8', 0, 0, -4642.7412109375, -2182.52685546875, 2937.647705078125, 3.058449268341064453, 0.041559696197509765, 0.999135971069335937, 0, 0, 7200, 255, 1, 61609), -- Doodad_GeneralMedChair96 (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+10, 259981, 1651, 8443, 8443, '23,2,8', 0, 0, -4689.07373046875, -2283.52978515625, 2981.42236328125, 3.767702579498291015, -0.30796623229980468, 0.951396942138671875, 0, 0, 7200, 255, 1, 61609), -- Doodad_GeneralChairHighEnd08 (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+11, 259979, 1651, 8443, 8443, '23,2,8', 0, 0, -4651.9912109375, -2156.379150390625, 2937.5126953125, 3.777671575546264648, -0.31270456314086914, 0.949850082397460937, 0, 0, 7200, 255, 1, 61609), -- Doodad_GeneralMedChair98 (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+12, 259976, 1651, 8443, 8443, '23,2,8', 0, 0, -4664.44970703125, -2152.24609375, 2937.56689453125, 3.777671575546264648, -0.31270456314086914, 0.949850082397460937, 0, 0, 7200, 255, 1, 61609), -- Doodad_GeneralMedChair95 (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+13, 259983, 1651, 8443, 8443, '23,2,8', 0, 0, -4658.71435546875, -2283.52978515625, 2981.42236328125, 3.767702579498291015, -0.30796623229980468, 0.951396942138671875, 0, 0, 7200, 255, 1, 61609), -- Doodad_GeneralChairHighEnd179 (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+14, 259986, 1651, 8443, 8443, '23,2,8', 0, 0, -4690.4580078125, -2307.646728515625, 2938.335205078125, 3.839724540710449218, -0.34202003479003906, 0.939692497253417968, 0, 0, 7200, 255, 1, 61609), -- Doodad_UldamanScroll70 (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+15, 266846, 1651, 8443, 8443, '23,2,8', 0, 0, -4599.2529296875, -2476.5419921875, 2877.82666015625, 4.708188056945800781, 0, 0, -0.70859050750732421, 0.7056199312210083, 7200, 255, 1, 61609), -- Door (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+16, 259967, 1651, 8443, 8443, '23,2,8', 0, 0, -4717.72216796875, -2147.47412109375, 2937.48095703125, 5.648927688598632812, 0.95013427734375, -0.31184005737304687, 0, 0, 7200, 255, 1, 61609), -- Doodad_GeneralMedChair84 (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+17, 259966, 1651, 8443, 8443, '23,2,8', 0, 0, -4718.7744140625, -2148.997802734375, 2937.48095703125, 5.648927688598632812, 0.95013427734375, -0.31184005737304687, 0, 0, 7200, 255, 1, 61609), -- Doodad_GeneralMedChair83 (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+18, 259971, 1651, 8443, 8443, '23,2,8', 0, 0, -4737.6923828125, -2186.908447265625, 2937.611572265625, 0.136423975229263305, 0.997674465179443359, 0.068159103393554687, 0, 0, 7200, 255, 1, 61609), -- Doodad_GeneralMedChair90 (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+19, 259970, 1651, 8443, 8443, '23,2,8', 0, 0, -4733.701171875, -2183.54345703125, 2937.643798828125, 5.58185434341430664, 0.939143657684326171, -0.34352302551269531, 0, 0.001064184354618191, 7200, 255, 1, 61609), -- Doodad_GeneralMedChair89 (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+20, 259969, 1651, 8443, 8443, '23,2,8', 0, 0, -4730.34912109375, -2159.73828125, 2937.642822265625, 5.660467147827148437, 0.95191812515258789, -0.30635261535644531, 0, 0, 7200, 255, 1, 61609), -- Doodad_GeneralMedChair86 (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+21, 259968, 1651, 8443, 8443, '23,2,8', 0, 0, -4734.48486328125, -2168.017822265625, 2937.614990234375, 5.959493160247802734, 0.986931324005126953, -0.16114044189453125, 0, 0, 7200, 255, 1, 61609), -- Doodad_GeneralMedChair85 (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+22, 259975, 1651, 8443, 8443, '23,2,8', 0, 0, -4716.32958984375, -2224.17919921875, 2937.5322265625, 1.12039339542388916, 0.847149848937988281, 0.531352996826171875, 0, 0.001064184354618191, 7200, 255, 1, 61609), -- Doodad_GeneralMedChair94 (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+23, 259974, 1651, 8443, 8443, '23,2,8', 0, 0, -4726.1640625, -2215.47314453125, 2937.678955078125, 0.292090952396392822, 0.989354133605957031, 0.145526885986328125, 0, 0, 7200, 255, 1, 61609), -- Doodad_GeneralMedChair93 (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+24, 259973, 1651, 8443, 8443, '23,2,8', 0, 0, -4719.31103515625, -2221.968994140625, 2937.5322265625, 0.867321431636810302, 0.907433032989501953, 0.420195579528808593, 0, 0.0009765625, 7200, 255, 1, 61609), -- Doodad_GeneralMedChair92 (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+25, 259972, 1651, 8443, 8443, '23,2,8', 0, 0, -4728.2294921875, -2209.13037109375, 2937.6337890625, 5.946959972381591796, 0.985901832580566406, -0.16732215881347656, 0, 0, 7200, 255, 1, 61609), -- Doodad_GeneralMedChair91 (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+26, 266878, 1651, 8443, 8443, '23,2,8', 0, 0, -4586.328125, -2498.598876953125, 2876.50927734375, 0, 0, 0, 0, 1, 7200, 255, 1, 61609), -- Terrifying Stories to Tell at Night (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+27, 266510, 1651, 8443, 8443, '23,2,8', 0, 0, -4625.5556640625, -2517.377197265625, 2876.381591796875, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 7200, 255, 1, 61609), -- Suspicious Bookcase (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+28, 266826, 1651, 8443, 8443, '23,2,8', 0, 0, -4542.6943359375, -2510.863525390625, 153.894287109375, 4.707406997680664062, 0, 0, -0.70886611938476562, 0.705343067646026611, 7200, 255, 1, 61609), -- Medivh's Footlocker (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+29, 265598, 1651, 8443, 8443, '23,2,8', 0, 0, 4147.96533203125, -2092.328125, 749.8739013671875, 4.380776405334472656, 0, 0, -0.81411552429199218, 0.580702960491180419, 7200, 255, 1, 61609), -- Sealed Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+30, 265597, 1651, 8443, 8443, '23,2,8', 0, 0, 4133.626953125, -2035.1197509765625, 731.7752685546875, 4.380776405334472656, 0, 0, -0.81411552429199218, 0.580702960491180419, 7200, 255, 1, 61609), -- Sealed Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+31, 265598, 1651, 8443, 8443, '23,2,8', 0, 0, 4162.28125, -2067.303955078125, 749.8485107421875, 4.380776405334472656, 0, 0, -0.81411552429199218, 0.580702960491180419, 7200, 255, 1, 61609), -- Sealed Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+32, 266577, 1651, 8443, 8443, '23,2,8', 0, 0, 4050.89111328125, -2276.3466796875, 761.958251953125, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 61609), -- Falling Books (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+33, 266576, 1651, 8443, 8443, '23,2,8', 0, 0, 4154.45068359375, -2257.680419921875, 741.909423828125, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 61609), -- Falling Books (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+34, 265598, 1651, 8443, 8443, '23,2,8', 0, 0, 4112.02783203125, -2064.161376953125, 730.5565185546875, 4.380776405334472656, 0, 0, -0.81411552429199218, 0.580702960491180419, 7200, 255, 1, 61609), -- Sealed Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+35, 266592, 1651, 8443, 8443, '23,2,8', 0, 0, 4144.984375, -2028.5728759765625, 730.594970703125, 4.735628128051757812, 0, 0, -0.69884300231933593, 0.715275108814239501, 7200, 255, 1, 61609), -- Medivh's Footlocker (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+36, 265597, 1651, 8443, 8443, '23,2,8', 0, 0, 4117.9453125, -2040.30908203125, 731.3297119140625, 5.981044769287109375, 0, 0, -0.15049648284912109, 0.988610565662384033, 7200, 255, 1, 61609), -- Sealed Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+37, 266656, 1651, 8443, 8443, '23,2,8', 0, 0, 3857.91552734375, -2245.921142578125, 795.61553955078125, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 0, 61609), -- Nether Barrier (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+38, 266593, 1651, 8443, 8443, '23,2,8', 0, 0, 3696.09228515625, -2208.966552734375, 815.5478515625, 3.297393321990966796, 0, 0, -0.99696731567382812, 0.077821522951126098, 7200, 255, 1, 61609), -- Tower Door (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+39, 265489, 1651, 8443, 8443, '23,2,8', 0, 0, 4144.791015625, -2262.063232421875, 864.76141357421875, 0.698131382465362548, 0.939692497253417968, 0.342020034790039062, 0, 0, 7200, 255, 1, 61609), -- Scroll (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+40, 265488, 1651, 8443, 8443, '23,2,8', 0, 0, 4053.741943359375, -2223.700439453125, 841.5361328125, 0, -1, 0, 0, 0, 7200, 255, 1, 61609), -- Bookshelf (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+41, 265605, 1651, 8443, 8443, '23,2,8', 0, 0, 4166.78564453125, -2093.111083984375, 727.81689453125, 4.380776405334472656, 0, 0, -0.81411552429199218, 0.580702960491180419, 7200, 255, 1, 61609), -- Sealed Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+42, 265598, 1651, 8443, 8443, '23,2,8', 0, 0, 4127.033203125, -2030.29345703125, 748.7242431640625, 5.841286182403564453, 0, 0, -0.21915626525878906, 0.97568976879119873, 7200, 255, 1, 61609), -- Sealed Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+43, 259959, 1651, 8443, 8443, '23,2,8', 0, 0, 3940.1748046875, -2205.7451171875, 786.65576171875, 5.477255821228027343, 0.191015243530273437, 0.086656570434570312, -0.4039468765258789, 0.890410423278808593, 7200, 255, 1, 61609), -- Chair (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+44, 259958, 1651, 8443, 8443, '23,2,8', 0, 0, 3943.139892578125, -2205.640380859375, 786.69195556640625, 3.954421758651733398, 0.087308883666992187, 0.190717697143554687, -0.8890237808227539, 0.406989663839340209, 7200, 255, 1, 61609), -- Chair (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+45, 265599, 1651, 8443, 8443, '23,2,8', 0, 0, 4126.35400390625, -2068.640625, 748.5045166015625, 4.380776405334472656, 0, 0, -0.81411552429199218, 0.580702960491180419, 7200, 255, 1, 61609), -- Sealed Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+46, 266295, 1651, 8443, 8443, '23,2,8', 0, 0, 3857.207275390625, -2246.02734375, 796.13348388671875, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 61609), -- Shattered Board (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+47, 265597, 1651, 8443, 8443, '23,2,8', 0, 0, 4176.04443359375, -2070.953125, 748.56591796875, 4.380776405334472656, 0, 0, -0.81411552429199218, 0.580702960491180419, 7200, 255, 1, 61609), -- Sealed Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+48, 265600, 1651, 8443, 8443, '23,2,8', 0, 0, 4127.75341796875, -2093.916748046875, 727.81689453125, 4.380776405334472656, 0, 0, -0.81411552429199218, 0.580702960491180419, 7200, 255, 1, 61609), -- Sealed Tome (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+49, 267190, 1651, 8443, 8443, '23,2,8', 0, 0, 4179.5322265625, -2053.632080078125, 749.708251953125, 3.297662734985351562, 0, 0, -0.99695682525634765, 0.077955827116966247, 7200, 255, 1, 61609), -- Tri-Disc of Fire (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+50, 259965, 1651, 8443, 8443, '23,2,8', 0, 0, 3931.93896484375, -2285.7998046875, 785.6968994140625, 0.823106646537780761, -0.17029142379760742, 0.078022003173828125, 0.409157752990722656, 0.893030405044555664, 7200, 255, 1, 61609), -- Chair (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+51, 259964, 1651, 8443, 8443, '23,2,8', 0, 0, 3934.427734375, -2285.710693359375, 785.66162109375, 1.997654199600219726, -0.10348892211914062, 0.156129837036132812, 0.818765640258789062, 0.542712032794952392, 7200, 255, 1, 61609), -- Chair (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+52, 259963, 1651, 8443, 8443, '23,2,8', 0, 0, 3916.08642578125, -2286.03369140625, 785.7349853515625, 2.325913429260253906, -0.07659864425659179, 0.168984413146972656, 0.894983291625976562, 0.405686795711517333, 7200, 255, 1, 61609), -- Chair (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+53, 259962, 1651, 8443, 8443, '23,2,8', 0, 0, 3913.81689453125, -2286.141845703125, 785.76666259765625, 0.82381671667098999, -0.16867351531982421, 0.077280044555664062, 0.409297943115234375, 0.893337726593017578, 7200, 255, 1, 61609), -- Chair (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+54, 259961, 1651, 8443, 8443, '23,2,8', 0, 0, 3898.162353515625, -2286.260498046875, 785.86602783203125, 2.327440977096557617, -0.07816934585571289, 0.172449111938476562, 0.894321441650390625, 0.405388712882995605, 7200, 255, 1, 61609), -- Chair (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+55, 259960, 1651, 8443, 8443, '23,2,8', 0, 0, 3895.736572265625, -2286.368408203125, 785.89849853515625, 0.822287201881408691, -0.17213201522827148, 0.07886505126953125, 0.408995628356933593, 0.892677664756774902, 7200, 255, 1, 61609), -- Chair (Area: Karazhan - Difficulty: Heroic) CreateObject1 +(@OGUID+56, 265486, 1651, 8443, 8443, '23,2,8', 0, 0, 3960.62158203125, -2007.7066650390625, 671.73858642578125, 4.032716751098632812, 0, 0, -0.90236854553222656, 0.430965185165405273, 7200, 255, 1, 61609), -- Command Ship (Area: Karazhan - Difficulty: Heroic) CreateObject2 +(@OGUID+57, 265486, 1651, 8443, 8443, '23,2,8', 0, 0, 3496.7431640625, -1959.65625, 784.6182861328125, 5.80300140380859375, 0, 0, -0.23779201507568359, 0.971316099166870117, 7200, 255, 1, 61609); -- Command Ship (Area: Karazhan - Difficulty: Heroic) CreateObject2 +DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+57; +INSERT INTO `gameobject_addon` (`guid`, `parent_rotation0`, `parent_rotation1`, `parent_rotation2`, `parent_rotation3`, `WorldEffectID`, `AIAnimKitID`) VALUES +(@OGUID+0, 0, 0, 0.000000087422776573, 1, 0, 0), -- Doodad_7DU_KarazhanB_BooksFall001 +(@OGUID+1, 0, 0, 0.000000087422776573, 1, 0, 0), -- Mysterious Wall +(@OGUID+2, 0, 0, 0.000000087422776573, 1, 0, 0), -- Doodad_GeneralChairHighEnd180 +(@OGUID+3, 0, 0, 0.000000087422776573, 1, 0, 0), -- Doodad_GeneralChairHighEnd178 +(@OGUID+4, 0, 0, 0.000000087422776573, 1, 0, 0), -- Doodad_GeneralMedChair99 +(@OGUID+5, 0, 0, 0.000000087422776573, 1, 0, 0), -- Door +(@OGUID+6, 0, 0, 0.000000087422776573, 1, 0, 0), -- Doodad_7DU_KarazhanB_BooksFall003 +(@OGUID+7, 0, 0, 0.000000087422776573, 1, 0, 0), -- Doodad_7DU_KarazhanB_BooksFall002 +(@OGUID+8, 0, 0, 0.000000087422776573, 1, 0, 0), -- Doodad_GeneralMedChair97 +(@OGUID+9, 0, 0, 0.000000087422776573, 1, 0, 0), -- Doodad_GeneralMedChair96 +(@OGUID+10, 0, 0, 0.000000087422776573, 1, 0, 0), -- Doodad_GeneralChairHighEnd08 +(@OGUID+11, 0, 0, 0.000000087422776573, 1, 0, 0), -- Doodad_GeneralMedChair98 +(@OGUID+12, 0, 0, 0.000000087422776573, 1, 0, 0), -- Doodad_GeneralMedChair95 +(@OGUID+13, 0, 0, 0.000000087422776573, 1, 0, 0), -- Doodad_GeneralChairHighEnd179 +(@OGUID+14, 0, 0, 0.000000087422776573, 1, 0, 0), -- Doodad_UldamanScroll70 +(@OGUID+15, 0, 0, 0.000000087422776573, 1, 0, 0), -- Door +(@OGUID+16, 0, 0, 0.000000087422776573, 1, 0, 0), -- Doodad_GeneralMedChair84 +(@OGUID+17, 0, 0, 0.000000087422776573, 1, 0, 0), -- Doodad_GeneralMedChair83 +(@OGUID+18, 0, 0, 0.000000087422776573, 1, 0, 0), -- Doodad_GeneralMedChair90 +(@OGUID+19, 0, 0, 0.000000087422776573, 1, 0, 0), -- Doodad_GeneralMedChair89 +(@OGUID+20, 0, 0, 0.000000087422776573, 1, 0, 0), -- Doodad_GeneralMedChair86 +(@OGUID+21, 0, 0, 0.000000087422776573, 1, 0, 0), -- Doodad_GeneralMedChair85 +(@OGUID+22, 0, 0, 0.000000087422776573, 1, 0, 0), -- Doodad_GeneralMedChair94 +(@OGUID+23, 0, 0, 0.000000087422776573, 1, 0, 0), -- Doodad_GeneralMedChair93 +(@OGUID+24, 0, 0, 0.000000087422776573, 1, 0, 0), -- Doodad_GeneralMedChair92 +(@OGUID+25, 0, 0, 0.000000087422776573, 1, 0, 0), -- Doodad_GeneralMedChair91 +(@OGUID+27, 0, 0, 0.000000087422776573, 1, 0, 0), -- Suspicious Bookcase +(@OGUID+28, 0, 0, 0.000000087422776573, 1, 2869, 0), -- Medivh's Footlocker +(@OGUID+32, 0, 0, 1, -0.00000004371138828, 0, 0), -- Falling Books +(@OGUID+33, 0, 0, 1, -0.00000004371138828, 0, 0), -- Falling Books +(@OGUID+35, 0, 0, 0, 1, 2437, 0), -- Medivh's Footlocker +(@OGUID+37, 0, 0, 1, -0.00000004371138828, 0, 0), -- Nether Barrier +(@OGUID+38, 0, 0, 1, -0.00000004371138828, 0, 0), -- Tower Door +(@OGUID+39, 0, 0, 1, -0.00000004371138828, 0, 0), -- Scroll +(@OGUID+40, 0, 0, 1, -0.00000004371138828, 0, 0), -- Bookshelf +(@OGUID+43, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair +(@OGUID+44, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair +(@OGUID+46, 0, 0, 1, -0.00000004371138828, 0, 0), -- Shattered Board +(@OGUID+49, 0, 0, 0, 1, 0, 12379), -- Tri-Disc of Fire +(@OGUID+50, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair +(@OGUID+51, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair +(@OGUID+52, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair +(@OGUID+53, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair +(@OGUID+54, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair +(@OGUID+55, 0, 0, 1, -0.00000004371138828, 0, 0); -- Chair + +-- Template Addon +DELETE FROM `creature_template_addon` WHERE `entry` IN (115734 /*115734 (Shadow Spitter)*/, 116124 /*116124 (Medivh)*/, 116259 /*116259 (Archmage Khadgar) - Raven Form*/, 115395 /*115395 (Queen) - Transform - Warlock, Chess Piece, Chess Piece, King's Court*/, 115407 /*115407 (Rook) - Chess Piece, Chess Piece, King's Court*/, 115388 /*115388 (King) - Transform - Warchief, Royalty*/, 115401 /*115401 (Bishop) - Transform - Necrolyte, Chess Piece, Chess Piece, King's Court*/, 115402 /*115402 (Bishop) - Transform - Necrolyte, Chess Piece, Chess Piece, King's Court*/, 115488 /*115488 (Infused Pyromancer) - Permanent Feign Death (Stun, Untrackable, Immune)*/, 115486 /*115486 (Erudite Slayer) - Permanent Feign Death (Stun, Untrackable, Immune)*/, 115406 /*115406 (Knight) - Transform - Wolf, Chess Piece, Chess Piece, King's Court*/, 116495 /*116495 (Rat) - Permanent Feign Death (Stun, Untrackable, Immune)*/, 114790 /*114790 (Viz'aduum the Watcher)*/, 115501 /*115501 (Archmage Khadgar) - Vision*/, 116491 /*116491 (Spider) - Permanent Feign Death (Stun, Untrackable, Immune)*/, 114913 /*114913 (Command Ship)*/, 115489 /*115489 (Anduin Lothar) - Vision*/, 115487 /*115487 (Medivh) - Vision, Mod Scale +10% [DNT], Permanent Feign Death (Stun, Untrackable, Immune)*/, 115831 /*115831 (Mana Devourer) - Charging Up*/, 116418 /*116418 (Ethereal Thief) - Ride Vehicle Hardcoded*/, 116551 /*116551 (Flying Tome)*/, 114252 /*114252 (Mana Devourer) - Override Energy Bar Color*/, 115419 /*115419 (Ancient Tome)*/, 116494 /*116494 (Mana Devourer)*/, 116865 /*116865 (Flying Tome)*/, 114350 /*114350 (Shade of Medivh) - Arcane Channel*/, 114844 /*114844 (Spell Shade) - Ride Vehicle Hardcoded, Phasing Invisibility*/, 115757 /*115757 (Wrathguard Flamebringer) - Melee Override, Dual Wield*/, 114843 /*114843 (Shadow Pillager) - Ride Vehicle Hardcoded*/, 114842 /*114842 (Homunculus) - Ride Vehicle Hardcoded*/, 114839 /*114839 (Chaotic Sentience) - Ride Vehicle Hardcoded, Double Attack*/, 114833 /*114833 (Upside Down Trash Vehicle)*/, 115484 /*115484 (Fel Bat) - Short Temper*/, 114835 /*114835 (Mana Feeder) - Ride Vehicle Hardcoded, Astral Bite*/, 114834 /*114834 (Arcane Watchman) - Ride Vehicle Hardcoded, Invisibility and Stealth Detection*/, 116864 /*116864 (Flying Tome)*/); +INSERT INTO `creature_template_addon` (`entry`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(115734, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 3, ''), -- 115734 (Shadow Spitter) +(116124, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 3, ''), -- 116124 (Medivh) +(116259, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, ''), -- 116259 (Archmage Khadgar) - Raven Form +(115395, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '232712 229442 229467 229490'), -- 115395 (Queen) - Transform - Warlock, Chess Piece, Chess Piece, King's Court +(115407, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '229442 229467 229490'), -- 115407 (Rook) - Chess Piece, Chess Piece, King's Court +(115388, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '232710 229489'), -- 115388 (King) - Transform - Warchief, Royalty +(115401, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '232711 229442 229467 229490'), -- 115401 (Bishop) - Transform - Necrolyte, Chess Piece, Chess Piece, King's Court +(115402, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '232711 229442 229467 229490'), -- 115402 (Bishop) - Transform - Necrolyte, Chess Piece, Chess Piece, King's Court +(115488, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 0, 0, ''), -- 115488 (Infused Pyromancer) - Permanent Feign Death (Stun, Untrackable, Immune) +(115486, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 0, 0, ''), -- 115486 (Erudite Slayer) - Permanent Feign Death (Stun, Untrackable, Immune) +(115406, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '232713 229442 229467 229490'), -- 115406 (Knight) - Transform - Wolf, Chess Piece, Chess Piece, King's Court +(116495, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 0, 0, ''), -- 116495 (Rat) - Permanent Feign Death (Stun, Untrackable, Immune) +(114790, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 4, ''), -- 114790 (Viz'aduum the Watcher) +(115501, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '229485'), -- 115501 (Archmage Khadgar) - Vision +(116491, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 0, 0, ''), -- 116491 (Spider) - Permanent Feign Death (Stun, Untrackable, Immune) +(114913, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 5, ''), -- 114913 (Command Ship) +(115489, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, '229485'), -- 115489 (Anduin Lothar) - Vision +(115487, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 0, 3, ''), -- 115487 (Medivh) - Vision, Mod Scale +10% [DNT], Permanent Feign Death (Stun, Untrackable, Immune) +(115831, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '232309'), -- 115831 (Mana Devourer) - Charging Up +(116418, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 116418 (Ethereal Thief) - Ride Vehicle Hardcoded +(116551, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 116551 (Flying Tome) +(114252, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, '388184'), -- 114252 (Mana Devourer) - Override Energy Bar Color +(115419, 0, 0, 0, 2, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 115419 (Ancient Tome) +(116494, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 4, ''), -- 116494 (Mana Devourer) +(116865, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 5, ''), -- 116865 (Flying Tome) +(114350, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 5, ''), -- 114350 (Shade of Medivh) - Arcane Channel +(114844, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '29920'), -- 114844 (Spell Shade) - Ride Vehicle Hardcoded, Phasing Invisibility +(115757, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '230045 42459'), -- 115757 (Wrathguard Flamebringer) - Melee Override, Dual Wield +(114843, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 114843 (Shadow Pillager) - Ride Vehicle Hardcoded +(114842, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 114842 (Homunculus) - Ride Vehicle Hardcoded +(114839, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '19818'), -- 114839 (Chaotic Sentience) - Ride Vehicle Hardcoded, Double Attack +(114833, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 114833 (Upside Down Trash Vehicle) +(115484, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 0, '229621'), -- 115484 (Fel Bat) - Short Temper +(114835, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '29908'), -- 114835 (Mana Feeder) - Ride Vehicle Hardcoded, Astral Bite +(114834, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '18950'), -- 114834 (Arcane Watchman) - Ride Vehicle Hardcoded, Invisibility and Stealth Detection +(116864, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 3, ''); -- 116864 (Flying Tome) + +DELETE FROM `gameobject_template_addon` WHERE `entry` IN (265486 /*Command Ship*/, 267190 /*Tri-Disc of Fire*/, 266295 /*Shattered Board*/, 265488 /*Bookshelf*/, 266593 /*Tower Door*/, 266656 /*Nether Barrier*/, 266592 /*Medivh's Footlocker*/, 266576 /*Falling Books*/, 266577 /*Falling Books*/, 266826 /*Medivh's Footlocker*/, 266510 /*Suspicious Bookcase*/, 266846 /*Door*/, 259985 /*Door*/, 266806 /*Mysterious Wall*/); +INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES +(265486, 0, 0x100020, 0, 0), -- Command Ship +(267190, 0, 0x4, 0, 12379), -- Tri-Disc of Fire +(266295, 114, 0x400020, 0, 0), -- Shattered Board +(265488, 114, 0x400020, 0, 0), -- Bookshelf +(266593, 114, 0x20, 0, 0), -- Tower Door +(266656, 114, 0x400020, 0, 0), -- Nether Barrier +(266592, 94, 0x204020, 2437, 0), -- Medivh's Footlocker +(266576, 114, 0x0, 0, 0), -- Falling Books +(266577, 114, 0x20, 0, 0), -- Falling Books +(266826, 0, 0x20, 2869, 0), -- Medivh's Footlocker +(266510, 114, 0x20, 0, 0), -- Suspicious Bookcase +(266846, 1375, 0x30, 0, 0), -- Door +(259985, 114, 0x20, 0, 0), -- Door +(266806, 114, 0x20, 0, 0); -- Mysterious Wall + +-- Template +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=0x2000300, `unit_flags2`=0x800, `unit_flags3`=0x1000000, `VehicleId`=5009 WHERE `entry`=114833; -- Upside Down Trash Vehicle +UPDATE `creature_template` SET `faction`=14, `unit_flags`=0x40, `unit_flags2`=0x800 WHERE `entry`=114790; -- Viz'aduum the Watcher +UPDATE `creature_template` SET `unit_flags`=0x40 WHERE `entry`=115831; -- Mana Devourer + +-- Creature Equip +DELETE FROM `creature_equip_template` WHERE (`ID`=1 AND `CreatureID` IN (116259,115388,115406,115486,115501,115489,114350,115757)); +INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `AppearanceModID1`, `ItemVisual1`, `ItemID2`, `AppearanceModID2`, `ItemVisual2`, `ItemID3`, `AppearanceModID3`, `ItemVisual3`, `VerifiedBuild`) VALUES +(116259, 1, 28067, 0, 0, 0, 0, 0, 0, 0, 0, 61609), -- Archmage Khadgar +(115388, 1, 140999, 0, 0, 0, 0, 0, 0, 0, 0, 61609), -- King +(115406, 1, 37579, 0, 0, 12860, 0, 0, 0, 0, 0, 61609), -- Knight +(115486, 1, 124447, 0, 0, 0, 0, 0, 0, 0, 0, 61609), -- Erudite Slayer +(115501, 1, 28067, 0, 0, 0, 0, 0, 0, 0, 0, 61609), -- Archmage Khadgar +(115489, 1, 21553, 0, 0, 0, 0, 0, 0, 0, 0, 61609), -- Anduin Lothar +(114350, 1, 28067, 0, 0, 0, 0, 0, 0, 0, 0, 61609), -- Shade of Medivh +(115757, 1, 138422, 0, 0, 138422, 0, 0, 0, 0, 0, 61609); -- Wrathguard Flamebringer + +-- Spellscript name +DELETE FROM `spell_script_names` WHERE `spell_id` = 145363; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(145363, 'spell_gen_feign_death_all_flags_no_uninteractible'); + +-- SpellClick +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` = 114833; +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES +(114833, 46598, 1, 0); + +-- Vehicle +DELETE FROM `vehicle_template_accessory` WHERE (`entry`=114833 AND `seat_id`=0); +INSERT INTO `vehicle_template_accessory` (`entry`, `accessory_entry`, `seat_id`, `minion`, `description`, `summontype`, `summontimer`) VALUES +(114833, 114844, 0, 0, 'Upside Down Trash Vehicle - Spell Shade', 8, 0); -- Upside Down Trash Vehicle - Spell Shade + +-- Creature Template movement +DELETE FROM `creature_template_movement` WHERE `CreatureId` = 115419; +INSERT INTO `creature_template_movement` (`CreatureId`, `HoverInitiallyEnabled`, `Chase`, `Random`, `InteractionPauseTimer`) VALUES +(115419, 1, 0, 0, NULL); + +-- Difficulty Override +DELETE FROM `creature_static_flags_override` WHERE `SpawnId` IN (@CGUID+25, @CGUID+42, @CGUID+45, @CGUID+46, @CGUID+53, @CGUID+47); +INSERT INTO `creature_static_flags_override` (`SpawnId`, `DifficultyId`, `StaticFlags1`, `StaticFlags2`, `StaticFlags3`, `StaticFlags4`, `StaticFlags5`, `StaticFlags6`, `StaticFlags7`, `StaticFlags8`) VALUES +(@CGUID+25, 23, 0x30000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(@CGUID+25, 8, 0x30000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(@CGUID+25, 2, 0x30000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(@CGUID+42, 23, 0x30000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(@CGUID+42, 8, 0x30000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(@CGUID+42, 2, 0x30000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(@CGUID+45, 23, 0x30000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(@CGUID+45, 8, 0x30000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(@CGUID+45, 2, 0x30000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(@CGUID+46, 23, 0x30000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(@CGUID+46, 8, 0x30000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(@CGUID+46, 2, 0x30000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(@CGUID+53, 23, 0x30000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(@CGUID+53, 8, 0x30000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(@CGUID+53, 2, 0x30000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(@CGUID+47, 23, 0x30000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(@CGUID+47, 8, 0x30000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(@CGUID+47, 2, 0x30000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL); + +-- Difficulty (Heroic) +DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID` IN (0,1) AND `Entry` = 115484); +DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID`=2 AND `Entry` IN (115734,116124,116259,115386,115501,114913,116804,115489,115487,116491,116418,116551,116494,116865,114844,115746,114843,114842,114839,114833,116495,114835,114834,116864)); +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `StaticFlags1`, `StaticFlags2`, `StaticFlags3`, `StaticFlags4`, `StaticFlags5`, `StaticFlags6`, `StaticFlags7`, `StaticFlags8`, `VerifiedBuild`) VALUES +(115734, 2, 0, 0, 628, 0x30000000, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 115734 (Shadow Spitter) - CanSwim, Floating +(116124, 2, 0, 0, 628, 0x100, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 116124 (Medivh) - Sessile +(116259, 2, 0, 0, 628, 0x30000000, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 116259 (Archmage Khadgar) - CanSwim, Floating +(115386, 2, 0, 0, 628, 0x30000100, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 115386 (Chest Board) - Sessile, CanSwim, Floating +(115501, 2, 0, 0, 628, 0x10000000, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 115501 (Archmage Khadgar) - CanSwim +(114913, 2, 0, 0, 628, 0x20000000, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 114913 (Command Ship) - Floating +(116804, 2, 0, 0, 628, 0x0, 0x0, 0x100, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 116804 (Scene Actor) - CannotSwim +(115489, 2, 0, 0, 628, 0x10000000, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 115489 (Anduin Lothar) - CanSwim +(115487, 2, 0, 0, 628, 0x20000100, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 115487 (Medivh) - Sessile, Floating +(116491, 2, 0, 0, 81, 0x10000000, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 116491 (Spider) - CanSwim +(116418, 2, 0, 0, 628, 0x20000100, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 116418 (Ethereal Thief) - Sessile, Floating +(116551, 2, 0, 0, 628, 0x20000000, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 116551 (Flying Tome) - Floating +(116494, 2, 0, 0, 628, 0x30000000, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 116494 (Mana Devourer) - CanSwim, Floating +(116865, 2, 0, 0, 628, 0x20000000, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 116865 (Flying Tome) - Floating +(114844, 2, 0, 0, 628, 0x20000100, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 114844 (Spell Shade) - Sessile, Floating +(115746, 2, 0, 0, 628, 0x20000100, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 115746 (Burning Tiles) - Sessile, Floating +(114843, 2, 0, 0, 628, 0x30000100, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 114843 (Shadow Pillager) - Sessile, CanSwim, Floating +(114842, 2, 0, 0, 628, 0x20000100, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 114842 (Homunculus) - Sessile, Floating +(114839, 2, 0, 0, 628, 0x20000100, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 114839 (Chaotic Sentience) - Sessile, Floating +(114833, 2, 0, 0, 628, 0x20000000, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 114833 (Upside Down Trash Vehicle) - Floating +(116495, 2, 0, 0, 81, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 116495 (Rat) - +(114835, 2, 0, 0, 628, 0x20000100, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 114835 (Mana Feeder) - Sessile, Floating +(114834, 2, 0, 0, 628, 0x20000100, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 114834 (Arcane Watchman) - Sessile, Floating +(116864, 2, 0, 0, 628, 0x20000000, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609); -- 116864 (Flying Tome) - Floating + +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=0.550000011920928955, `CreatureDifficultyID`=119308, `TypeFlags2`=128 WHERE (`Entry`=115734 AND `DifficultyID`=2); -- Shadow Spitter +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=13.75, `CreatureDifficultyID`=119763, `TypeFlags`=0x4 WHERE (`Entry`=116124 AND `DifficultyID`=2); -- Medivh +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=110, `ManaModifier`=80, `CreatureDifficultyID`=119918, `TypeFlags`=0x4 WHERE (`Entry`=116259 AND `DifficultyID`=2); -- Archmage Khadgar +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=13.75, `CreatureDifficultyID`=119048, `TypeFlags`=0x4 WHERE (`Entry`=115487 AND `DifficultyID`=2); -- Medivh +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=1.10000002384185791, `CreatureDifficultyID`=118425, `TypeFlags`=0x400, `TypeFlags2`=16 WHERE (`Entry`=114913 AND `DifficultyID`=2); -- Command Ship +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=110, `ManaModifier`=80, `CreatureDifficultyID`=119062, `TypeFlags`=0x4 WHERE (`Entry`=115501 AND `DifficultyID`=2); -- Archmage Khadgar +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=0.550000011920928955, `CreatureDifficultyID`=119050 WHERE (`Entry`=115489 AND `DifficultyID`=2); -- Anduin Lothar +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=3.079999923706054687, `CreatureDifficultyID`=120173, `TypeFlags`=0x8 WHERE (`Entry`=116418 AND `DifficultyID`=2); -- Ethereal Thief +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=8.25, `CreatureDifficultyID`=118939, `TypeFlags`=0x200048 WHERE (`Entry`=115386 AND `DifficultyID`=2); -- Chest Board +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=0.550000011920928955, `CreatureDifficultyID`=120738, `TypeFlags`=0x400 WHERE (`Entry`=116804 AND `DifficultyID`=2); -- Scene Actor +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=0.550000011920928955, `CreatureDifficultyID`=120306 WHERE (`Entry`=116551 AND `DifficultyID`=2); -- Flying Tome +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=10, `HealthModifier`=0.050000000745058059, `CreatureDifficultyID`=120246 WHERE (`Entry`=116491 AND `DifficultyID`=2); -- Spider +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=46.55199813842773437, `ManaModifier`=0.350600004196166992, `CreatureDifficultyID`=120249, `TypeFlags`=0x200068 WHERE (`Entry`=116494 AND `DifficultyID`=2); -- Mana Devourer +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=0.550000011920928955, `CreatureDifficultyID`=120804 WHERE (`Entry`=116865 AND `DifficultyID`=2); -- Flying Tome +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=2.309999942779541015, `CreatureDifficultyID`=118347, `TypeFlags`=0x8 WHERE (`Entry`=114844 AND `DifficultyID`=2); -- Spell Shade +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=8.25, `CreatureDifficultyID`=119322 WHERE (`Entry`=115746 AND `DifficultyID`=2); -- Burning Tiles +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=1.154999971389770507, `ManaModifier`=12.34029960632324218, `CreatureDifficultyID`=118345, `TypeFlags`=0x8 WHERE (`Entry`=114842 AND `DifficultyID`=2); -- Homunculus +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=2.309999942779541015, `ManaModifier`=21.57110023498535156, `CreatureDifficultyID`=118346, `TypeFlags`=0x8 WHERE (`Entry`=114843 AND `DifficultyID`=2); -- Shadow Pillager +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=3.079999923706054687, `CreatureDifficultyID`=118342, `TypeFlags`=0x8 WHERE (`Entry`=114839 AND `DifficultyID`=2); -- Chaotic Sentience +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=0.550000011920928955, `CreatureDifficultyID`=120803 WHERE (`Entry`=116864 AND `DifficultyID`=2); -- Flying Tome +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=0.769999980926513671, `CreatureDifficultyID`=118338, `TypeFlags`=0x9 WHERE (`Entry`=114835 AND `DifficultyID`=2); -- Mana Feeder +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=4.619999885559082031, `CreatureDifficultyID`=118337, `TypeFlags`=0x400008 WHERE (`Entry`=114834 AND `DifficultyID`=2); -- Arcane Watchman +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=0.550000011920928955, `CreatureDifficultyID`=118336, `TypeFlags`=0x400000 WHERE (`Entry`=114833 AND `DifficultyID`=2); -- Upside Down Trash Vehicle +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=10, `HealthModifier`=0.009999999776482582, `CreatureDifficultyID`=120250 WHERE (`Entry`=116495 AND `DifficultyID`=2); -- Rat + +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=628, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=115395 AND `DifficultyID`=2); -- 115395 (Queen) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=628, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=115407 AND `DifficultyID`=2); -- 115407 (Rook) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=628, `StaticFlags1`=0x30000100, `VerifiedBuild`=61609 WHERE (`Entry`=115388 AND `DifficultyID`=2); -- 115388 (King) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=628, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=115401 AND `DifficultyID`=2); -- 115401 (Bishop) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=628, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=115402 AND `DifficultyID`=2); -- 115402 (Bishop) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=628, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=115406 AND `DifficultyID`=2); -- 115406 (Knight) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=628, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=115486 AND `DifficultyID`=2); -- 115486 (Erudite Slayer) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=628, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=114790 AND `DifficultyID`=2); -- 114790 (Viz'aduum the Watcher) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=628, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=115831 AND `DifficultyID`=2); -- 115831 (Mana Devourer) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x20000100, `VerifiedBuild`=61609 WHERE (`Entry`=63420 AND `DifficultyID`=2); -- 63420 (SLG Generic MoP) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=628, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=114252 AND `DifficultyID`=2); -- 114252 (Mana Devourer) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=628, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=115418 AND `DifficultyID`=2); -- 115418 (Spider) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=628, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=115419 AND `DifficultyID`=2); -- 115419 (Ancient Tome) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=628, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=115417 AND `DifficultyID`=2); -- 115417 (Rat) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=628, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=114350 AND `DifficultyID`=2); -- 114350 (Shade of Medivh) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=628, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=115757 AND `DifficultyID`=2); -- 115757 (Wrathguard Flamebringer) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=628, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=115488 AND `DifficultyID`=2); -- 115488 (Infused Pyromancer) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=628, `StaticFlags1`=0x30000100, `VerifiedBuild`=61609 WHERE (`Entry`=115484 AND `DifficultyID`=2); -- 115484 (Fel Bat) - Sessile, CanSwim, Floating + +-- Difficulty (Mythic) +DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID`=23 AND `Entry` IN (115734,116124,116259,115487,116804,115501,116418,114913,115386,115489,116491,116551,116494,116865,114844,115746,114842,114843,114839,114834,116495,116864,114835,114833)); +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `StaticFlags1`, `StaticFlags2`, `StaticFlags3`, `StaticFlags4`, `StaticFlags5`, `StaticFlags6`, `StaticFlags7`, `StaticFlags8`, `VerifiedBuild`) VALUES +(115734, 23, 0, 0, 629, 0x30000000, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 115734 (Shadow Spitter) - CanSwim, Floating +(116124, 23, 0, 0, 629, 0x100, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 116124 (Medivh) - Sessile +(116259, 23, 0, 0, 629, 0x30000000, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 116259 (Archmage Khadgar) - CanSwim, Floating +(115487, 23, 0, 0, 629, 0x20000100, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 115487 (Medivh) - Sessile, Floating +(116804, 23, 0, 0, 629, 0x0, 0x0, 0x100, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 116804 (Scene Actor) - CannotSwim +(115501, 23, 0, 0, 629, 0x10000000, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 115501 (Archmage Khadgar) - CanSwim +(116418, 23, 0, 0, 629, 0x20000100, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 116418 (Ethereal Thief) - Sessile, Floating +(114913, 23, 0, 0, 629, 0x20000000, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 114913 (Command Ship) - Floating +(115386, 23, 0, 0, 629, 0x30000100, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 115386 (Chest Board) - Sessile, CanSwim, Floating +(115489, 23, 0, 0, 629, 0x10000000, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 115489 (Anduin Lothar) - CanSwim +(116491, 23, 0, 0, 81, 0x10000000, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 116491 (Spider) - CanSwim +(116551, 23, 0, 0, 629, 0x20000000, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 116551 (Flying Tome) - Floating +(116494, 23, 0, 0, 629, 0x30000000, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 116494 (Mana Devourer) - CanSwim, Floating +(116865, 23, 0, 0, 629, 0x20000000, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 116865 (Flying Tome) - Floating +(114844, 23, 0, 0, 629, 0x20000100, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 114844 (Spell Shade) - Sessile, Floating +(115746, 23, 0, 0, 629, 0x20000100, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 115746 (Burning Tiles) - Sessile, Floating +(114842, 23, 0, 0, 629, 0x20000100, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 114842 (Homunculus) - Sessile, Floating +(114843, 23, 0, 0, 629, 0x30000100, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 114843 (Shadow Pillager) - Sessile, CanSwim, Floating +(114839, 23, 0, 0, 629, 0x20000100, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 114839 (Chaotic Sentience) - Sessile, Floating +(114834, 23, 0, 0, 629, 0x20000100, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 114834 (Arcane Watchman) - Sessile, Floating +(116495, 23, 0, 0, 81, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 116495 (Rat) - +(116864, 23, 0, 0, 629, 0x20000000, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 116864 (Flying Tome) - Floating +(114835, 23, 0, 0, 629, 0x20000100, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609), -- 114835 (Mana Feeder) - Sessile, Floating +(114833, 23, 0, 0, 629, 0x20000000, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 61609); -- 114833 (Upside Down Trash Vehicle) - Floating + +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=0.550000011920928955, `CreatureDifficultyID`=119308, `TypeFlags2`=128 WHERE (`Entry`=115734 AND `DifficultyID`=23); -- Shadow Spitter +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=13.75, `CreatureDifficultyID`=119763, `TypeFlags`=0x4 WHERE (`Entry`=116124 AND `DifficultyID`=23); -- Medivh +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=110, `ManaModifier`=80, `CreatureDifficultyID`=119918, `TypeFlags`=0x4 WHERE (`Entry`=116259 AND `DifficultyID`=23); -- Archmage Khadgar +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=13.75, `CreatureDifficultyID`=119048, `TypeFlags`=0x4 WHERE (`Entry`=115487 AND `DifficultyID`=23); -- Medivh +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=110, `ManaModifier`=80, `CreatureDifficultyID`=119062, `TypeFlags`=0x4 WHERE (`Entry`=115501 AND `DifficultyID`=23); -- Archmage Khadgar +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=8.25, `CreatureDifficultyID`=118939, `TypeFlags`=0x200048 WHERE (`Entry`=115386 AND `DifficultyID`=23); -- Chest Board +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=0.550000011920928955, `CreatureDifficultyID`=120306 WHERE (`Entry`=116551 AND `DifficultyID`=23); -- Flying Tome +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=1.10000002384185791, `CreatureDifficultyID`=118425, `TypeFlags`=0x400, `TypeFlags2`=16 WHERE (`Entry`=114913 AND `DifficultyID`=23); -- Command Ship +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=0.550000011920928955, `CreatureDifficultyID`=119050 WHERE (`Entry`=115489 AND `DifficultyID`=23); -- Anduin Lothar +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=3.079999923706054687, `CreatureDifficultyID`=120173, `TypeFlags`=0x8 WHERE (`Entry`=116418 AND `DifficultyID`=23); -- Ethereal Thief +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=0.550000011920928955, `CreatureDifficultyID`=120738, `TypeFlags`=0x400 WHERE (`Entry`=116804 AND `DifficultyID`=23); -- Scene Actor +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=10, `HealthModifier`=0.050000000745058059, `CreatureDifficultyID`=120246 WHERE (`Entry`=116491 AND `DifficultyID`=23); -- Spider +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=46.55199813842773437, `ManaModifier`=0.350600004196166992, `CreatureDifficultyID`=120249, `TypeFlags`=0x200068 WHERE (`Entry`=116494 AND `DifficultyID`=23); -- Mana Devourer +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=0.550000011920928955, `CreatureDifficultyID`=120804 WHERE (`Entry`=116865 AND `DifficultyID`=23); -- Flying Tome +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=2.309999942779541015, `CreatureDifficultyID`=118347, `TypeFlags`=0x8 WHERE (`Entry`=114844 AND `DifficultyID`=23); -- Spell Shade +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=8.25, `CreatureDifficultyID`=119322 WHERE (`Entry`=115746 AND `DifficultyID`=23); -- Burning Tiles +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=1.154999971389770507, `ManaModifier`=12.34029960632324218, `CreatureDifficultyID`=118345, `TypeFlags`=0x8 WHERE (`Entry`=114842 AND `DifficultyID`=23); -- Homunculus +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=2.309999942779541015, `ManaModifier`=21.57110023498535156, `CreatureDifficultyID`=118346, `TypeFlags`=0x8 WHERE (`Entry`=114843 AND `DifficultyID`=23); -- Shadow Pillager +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=0.550000011920928955, `CreatureDifficultyID`=120803 WHERE (`Entry`=116864 AND `DifficultyID`=23); -- Flying Tome +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=3.079999923706054687, `CreatureDifficultyID`=118342, `TypeFlags`=0x8 WHERE (`Entry`=114839 AND `DifficultyID`=23); -- Chaotic Sentience +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=0.769999980926513671, `CreatureDifficultyID`=118338, `TypeFlags`=0x9 WHERE (`Entry`=114835 AND `DifficultyID`=23); -- Mana Feeder +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=4.619999885559082031, `CreatureDifficultyID`=118337, `TypeFlags`=0x400008 WHERE (`Entry`=114834 AND `DifficultyID`=23); -- Arcane Watchman +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=6, `HealthModifier`=0.550000011920928955, `CreatureDifficultyID`=118336, `TypeFlags`=0x400000 WHERE (`Entry`=114833 AND `DifficultyID`=23); -- Upside Down Trash Vehicle +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=10, `HealthModifier`=0.009999999776482582, `CreatureDifficultyID`=120250 WHERE (`Entry`=116495 AND `DifficultyID`=23); -- Rat + +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=629, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=115407 AND `DifficultyID`=23); -- 115407 (Rook) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=629, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=115406 AND `DifficultyID`=23); -- 115406 (Knight) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=629, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=115401 AND `DifficultyID`=23); -- 115401 (Bishop) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=629, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=115402 AND `DifficultyID`=23); -- 115402 (Bishop) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=629, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=115395 AND `DifficultyID`=23); -- 115395 (Queen) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=629, `StaticFlags1`=0x30000100, `VerifiedBuild`=61609 WHERE (`Entry`=115388 AND `DifficultyID`=23); -- 115388 (King) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=629, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=115486 AND `DifficultyID`=23); -- 115486 (Erudite Slayer) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=629, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=114790 AND `DifficultyID`=23); -- 114790 (Viz'aduum the Watcher) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=629, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=115831 AND `DifficultyID`=23); -- 115831 (Mana Devourer) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x20000100, `VerifiedBuild`=61609 WHERE (`Entry`=63420 AND `DifficultyID`=23); -- 63420 (SLG Generic MoP) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=629, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=114252 AND `DifficultyID`=23); -- 114252 (Mana Devourer) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=629, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=115418 AND `DifficultyID`=23); -- 115418 (Spider) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=629, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=115417 AND `DifficultyID`=23); -- 115417 (Rat) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=629, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=115419 AND `DifficultyID`=23); -- 115419 (Ancient Tome) - CanSwim +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=61609 WHERE (`Entry`=120652 AND `DifficultyID`=23); +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=629, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=114350 AND `DifficultyID`=23); -- 114350 (Shade of Medivh) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=629, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=115757 AND `DifficultyID`=23); -- 115757 (Wrathguard Flamebringer) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=629, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=115488 AND `DifficultyID`=23); -- 115488 (Infused Pyromancer) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=629, `StaticFlags1`=0x30000100, `VerifiedBuild`=61609 WHERE (`Entry`=115484 AND `DifficultyID`=23); -- 115484 (Fel Bat) - Sessile, CanSwim, Floating + +-- Path for Infused Pyromancer +SET @MOVERGUID := @CGUID+11; +SET @ENTRY := 115488; +SET @PATHOFFSET := 0; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x0, NULL, 'Infused Pyromancer - Cosmetic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, -4552.6772, -2175.019, 2880.7334, NULL, 0), +(@PATH, 1, -4539.2397, -2175.1753, 2880.7556, NULL, 0), +(@PATH, 2, -4528.415, -2175.4548, 2880.8345, NULL, 0), +(@PATH, 3, -4539.2397, -2175.1753, 2880.7556, NULL, 0), +(@PATH, 4, -4552.6772, -2175.019, 2880.7334, NULL, 0), +(@PATH, 5, -4565.5347, -2174.875, 2880.7124, NULL, 0), +(@PATH, 6, -4583.1943, -2175.356, 2880.7463, NULL, 0), +(@PATH, 7, -4565.5347, -2174.875, 2880.7124, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Infused Pyromancer +SET @MOVERGUID := @CGUID+9; +SET @ENTRY := 115488; +SET @PATHOFFSET := 1; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x0, NULL, 'Infused Pyromancer - Cosmetic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, -4585.184, -2223.309, 2903.9727, NULL, 0), +(@PATH, 1, -4578.783, -2237.1892, 2903.6555, NULL, 0), +(@PATH, 2, -4584.9585, -2250.4531, 2904.3586, NULL, 0), +(@PATH, 3, -4578.783, -2237.1892, 2903.6555, NULL, 0), +(@PATH, 4, -4585.184, -2223.309, 2903.9727, NULL, 0), +(@PATH, 5, -4584.528, -2210.5088, 2900.7937, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Infused Pyromancer +SET @MOVERGUID := @CGUID+43; +SET @ENTRY := 115488; +SET @PATHOFFSET := 2; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 2.5152, 'Infused Pyromancer - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, -4670.2285, -2144.4521, 2855.7998, NULL, 0), +(@PATH, 1, -4687.1274, -2139.714, 2855.8347, NULL, 0), +(@PATH, 2, -4704.5483, -2141.7847, 2855.733, NULL, 0), +(@PATH, 3, -4719.7446, -2150.618, 2855.9434, NULL, 0), +(@PATH, 4, -4730.6323, -2164.2612, 2856.0378, NULL, 0), +(@PATH, 5, -4735.3574, -2181.1663, 2855.6836, NULL, 0), +(@PATH, 6, -4733.229, -2198.595, 2855.3047, NULL, 0), +(@PATH, 7, -4724.593, -2213.8823, 2855.6145, NULL, 0), +(@PATH, 8, -4710.7637, -2224.7012, 2855.4626, NULL, 0), +(@PATH, 9, -4693.847, -2229.4043, 2855.3064, NULL, 0), +(@PATH, 10, -4676.4185, -2227.2756, 2855.043, NULL, 0), +(@PATH, 11, -4661.131, -2218.6394, 2855.3152, NULL, 0), +(@PATH, 12, -4650.3125, -2204.8105, 2855.4968, NULL, 0), +(@PATH, 13, -4645.6094, -2187.8938, 2854.7031, NULL, 0), +(@PATH, 14, -4647.738, -2170.4653, 2855.3103, NULL, 0), +(@PATH, 15, -4656.374, -2155.178, 2855.721, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Infused Pyromancer +SET @MOVERGUID := @CGUID+44; +SET @ENTRY := 115488; +SET @PATHOFFSET := 3; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 2.5150, 'Infused Pyromancer - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, -4676.0186, -2157.8547, 2853.0728, NULL, 0), +(@PATH, 1, -4686.8877, -2153.51, 2853.0378, NULL, 0), +(@PATH, 2, -4698.592, -2153.6553, 2853.0378, NULL, 0), +(@PATH, 3, -4709.35, -2158.2686, 2853.0376, NULL, 0), +(@PATH, 4, -4717.5234, -2166.6477, 2853.0378, NULL, 0), +(@PATH, 5, -4721.8687, -2177.5168, 2853.038, NULL, 0), +(@PATH, 6, -4721.723, -2189.2214, 2853.102, NULL, 0), +(@PATH, 7, -4717.11, -2199.9792, 2853.0378, NULL, 0), +(@PATH, 8, -4708.731, -2208.1528, 2853.0425, NULL, 0), +(@PATH, 9, -4697.8613, -2212.4978, 2853.1592, NULL, 0), +(@PATH, 10, -4686.157, -2212.3525, 2853.0378, NULL, 0), +(@PATH, 11, -4675.399, -2207.739, 2853.0376, NULL, 0), +(@PATH, 12, -4667.2256, -2199.36, 2853.0376, NULL, 0), +(@PATH, 13, -4662.8804, -2188.491, 2853.0378, NULL, 0), +(@PATH, 14, -4663.026, -2176.7864, 2853.1094, NULL, 0), +(@PATH, 15, -4667.639, -2166.0283, 2853.0378, NULL, 0); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Infused Pyromancer +SET @MOVERGUID := @CGUID+51; +SET @ENTRY := 115488; +SET @PATHOFFSET := 4; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x0, NULL, 'Infused Pyromancer - Cosmetic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, -4689.0244, -2311.783, 2880.1912, NULL, 0), +(@PATH, 1, -4689.413, -2301.6267, 2880.0376, NULL, 0), +(@PATH, 2, -4684.283, -2295.962, 2880.1475, NULL, 0), +(@PATH, 3, -4683.066, -2287.144, 2881.2256, NULL, 0), +(@PATH, 4, -4682.616, -2274.3958, 2881.225, NULL, 10471), +(@PATH, 5, -4683.066, -2287.144, 2881.2256, NULL, 0), +(@PATH, 6, -4684.283, -2295.962, 2880.1475, NULL, 0), +(@PATH, 7, -4689.413, -2301.6267, 2880.0376, NULL, 0), +(@PATH, 8, -4689.0244, -2311.783, 2880.1912, NULL, 0), +(@PATH, 9, -4657.5244, -2311.8594, 2881.225, NULL, 2878); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Wrathguard Flamebringer +SET @MOVERGUID := @CGUID+48; +SET @ENTRY := 115757; +SET @PATHOFFSET := 0; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x0, NULL, 'Wrathguard Flamebringer - Cosmetic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, -4670.137, -2113.514, 2871.2358, NULL, 10252), +(@PATH, 1, -4711.5054, -2111.217, 2871.3235, NULL, 4216); + +UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`, `auras`) VALUES +(@MOVERGUID, @PATH, 1, '230045 42459'); + +-- Path for Fel Bat +SET @MOVERGUID := @CGUID+25; +SET @ENTRY := 115484; +SET @PATHOFFSET := 0; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 4.2231, 'Fel Bat - Cosmetic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, -4640.521, -2201.9827, 2896.6733, NULL, 0), +(@PATH, 1, -4616.127, -2183.2014, 2913.7063, NULL, 0), +(@PATH, 2, -4657.703, -2107.316, 2918.2532, NULL, 0), +(@PATH, 3, -4690.153, -2106.5435, 2918.2532, NULL, 0), +(@PATH, 4, -4706.1943, -2134.4062, 2918.2532, NULL, 0), +(@PATH, 5, -4710.3125, -2156.6025, 2918.2532, NULL, 0); + +UPDATE `creature` SET `position_x`=-4640.521, `position_y`=-2201.9827, `position_z`=2896.6733, `orientation`=0, `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`, `auras`) VALUES +(@MOVERGUID, @PATH, 1, '229621'); + +-- Path for Fel Bat +SET @MOVERGUID := @CGUID+42; +SET @ENTRY := 115484; +SET @PATHOFFSET := 1; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 8.0435, 'Fel Bat - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, -4574.625, -2164.077, 2775.9282, NULL, 0), +(@PATH, 1, -4564.892, -2157.5737, 2775.9282, NULL, 0), +(@PATH, 2, -4553.4116, -2155.29, 2775.9282, NULL, 0), +(@PATH, 3, -4541.931, -2157.5737, 2775.9282, NULL, 0), +(@PATH, 4, -4532.198, -2164.077, 2775.9282, NULL, 0), +(@PATH, 5, -4525.6953, -2173.8096, 2775.9282, NULL, 0), +(@PATH, 6, -4523.4116, -2185.29, 2775.9282, NULL, 0), +(@PATH, 7, -4525.6953, -2196.7705, 2775.9282, NULL, 0), +(@PATH, 8, -4532.198, -2206.5032, 2775.9282, NULL, 0), +(@PATH, 9, -4541.931, -2213.0063, 2775.9282, NULL, 0), +(@PATH, 10, -4553.4116, -2215.29, 2775.9282, NULL, 0), +(@PATH, 11, -4564.892, -2213.0063, 2775.9282, NULL, 0), +(@PATH, 12, -4574.625, -2206.5032, 2775.9282, NULL, 0), +(@PATH, 13, -4581.128, -2196.7705, 2775.9282, NULL, 0), +(@PATH, 14, -4583.4116, -2185.29, 2775.9282, NULL, 0), +(@PATH, 15, -4581.128, -2173.8096, 2775.9282, NULL, 0); + +UPDATE `creature` SET `position_x`=-4574.625, `position_y`=-2164.077, `position_z`=2775.9282, `orientation`=0, `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`, `auras`) VALUES +(@MOVERGUID, @PATH, 1, '229621'); + +-- Path for Fel Bat +SET @MOVERGUID := @CGUID+45; +SET @ENTRY := 115484; +SET @PATHOFFSET := 2; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 3.2644, 'Fel Bat - Cosmetic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, -4593.4146, -2214.6526, 2779.9326, NULL, 0), +(@PATH, 1, -4539.311, -2227.5938, 2806.1638, NULL, 0), +(@PATH, 2, -4572.856, -2155.2551, 2784.9778, NULL, 0), +(@PATH, 3, -4632.354, -2103.462, 2784.9778, NULL, 0), +(@PATH, 4, -4683.2085, -2147.6926, 2779.9329, NULL, 0); + +UPDATE `creature` SET `position_x`=-4593.4146, `position_y`=-2214.6526, `position_z`=2779.9326, `orientation`=0, `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`, `auras`) VALUES +(@MOVERGUID, @PATH, 1, '229621'); + +-- Path for Fel Bat +SET @MOVERGUID := @CGUID+46; +SET @ENTRY := 115484; +SET @PATHOFFSET := 3; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 2.2912, 'Fel Bat - Cosmetic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, -4615.58, -2285.823, 2822.0579, NULL, 0), +(@PATH, 1, -4658.408, -2248.394, 2835.585, NULL, 0), +(@PATH, 2, -4593.047, -2196.4966, 2826.1707, NULL, 0), +(@PATH, 3, -4539.453, -2233.967, 2832.497, NULL, 0); + +UPDATE `creature` SET `position_x`=-4615.58, `position_y`=-2285.823, `position_z`=2822.0579, `orientation`=0, `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`, `auras`) VALUES +(@MOVERGUID, @PATH, 1, '229621'); + +-- Path for Fel Bat +SET @MOVERGUID := @CGUID+53; +SET @ENTRY := 115484; +SET @PATHOFFSET := 4; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 8.0437, 'Fel Bat - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, -4693.9443, -2233.62, 2748.3374, NULL, 0), +(@PATH, 1, -4684.2114, -2227.117, 2748.3374, NULL, 0), +(@PATH, 2, -4672.731, -2224.8333, 2748.3374, NULL, 0), +(@PATH, 3, -4661.2505, -2227.117, 2748.3374, NULL, 0), +(@PATH, 4, -4651.5176, -2233.62, 2748.3374, NULL, 0), +(@PATH, 5, -4645.0146, -2243.3528, 2748.3374, NULL, 0), +(@PATH, 6, -4642.731, -2254.8333, 2748.3374, NULL, 0), +(@PATH, 7, -4645.0146, -2266.3137, 2748.3374, NULL, 0), +(@PATH, 8, -4651.5176, -2276.0464, 2748.3374, NULL, 0), +(@PATH, 9, -4661.2505, -2282.5496, 2748.3374, NULL, 0), +(@PATH, 10, -4672.731, -2284.8333, 2748.3374, NULL, 0), +(@PATH, 11, -4684.2114, -2282.5496, 2748.3374, NULL, 0), +(@PATH, 12, -4693.9443, -2276.0464, 2748.3374, NULL, 0), +(@PATH, 13, -4700.4473, -2266.3137, 2748.3374, NULL, 0), +(@PATH, 14, -4702.731, -2254.8333, 2748.3374, NULL, 0), +(@PATH, 15, -4700.4473, -2243.3528, 2748.3374, NULL, 0); + +UPDATE `creature` SET `position_x`=-4693.9443, `position_y`=-2233.62, `position_z`=2748.3374, `orientation`=0, `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`, `auras`) VALUES +(@MOVERGUID, @PATH, 1, '229621'); + +-- Path for Fel Bat +SET @MOVERGUID := @CGUID+47; +SET @ENTRY := 115484; +SET @PATHOFFSET := 5; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 8.0435, 'Fel Bat - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, -4687.2935, -2124.2104, 2754.2544, NULL, 0), +(@PATH, 1, -4677.5605, -2117.7073, 2754.2544, NULL, 0), +(@PATH, 2, -4666.08, -2115.4236, 2754.2544, NULL, 0), +(@PATH, 3, -4654.5996, -2117.7073, 2754.2544, NULL, 0), +(@PATH, 4, -4644.8667, -2124.2104, 2754.2544, NULL, 0), +(@PATH, 5, -4638.364, -2133.943, 2754.2544, NULL, 0), +(@PATH, 6, -4636.08, -2145.4236, 2754.2544, NULL, 0), +(@PATH, 7, -4638.364, -2156.904, 2754.2544, NULL, 0), +(@PATH, 8, -4644.8667, -2166.6367, 2754.2544, NULL, 0), +(@PATH, 9, -4654.5996, -2173.14, 2754.2544, NULL, 0), +(@PATH, 10, -4666.08, -2175.4236, 2754.2544, NULL, 0), +(@PATH, 11, -4677.5605, -2173.14, 2754.2544, NULL, 0), +(@PATH, 12, -4687.2935, -2166.6367, 2754.2544, NULL, 0), +(@PATH, 13, -4693.7964, -2156.904, 2754.2544, NULL, 0), +(@PATH, 14, -4696.08, -2145.4236, 2754.2544, NULL, 0), +(@PATH, 15, -4693.7964, -2133.943, 2754.2544, NULL, 0); + +UPDATE `creature` SET `position_x`=-4687.2935, `position_y`=-2124.2104, `position_z`=2754.2544, `orientation`=0, `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`, `auras`) VALUES +(@MOVERGUID, @PATH, 1, '229621'); |