diff options
author | Odyssey <odysseyhyd@gmail.com> | 2022-12-31 01:08:31 +0100 |
---|---|---|
committer | Naddley <NaddleyTC@gmail.com> | 2022-12-31 01:09:02 +0100 |
commit | 23cb9592fc83957ce1a5cfb0b5bef0ce13c19edb (patch) | |
tree | 59712c7e8978595d0392a6669ede8e782ad001ec /sql | |
parent | e2d51ddc5f4431694c66423435d0e8f474f6ae64 (diff) |
DB/Spawns: Populate Algeth'ar Academy
Closes #28636
Diffstat (limited to 'sql')
-rw-r--r-- | sql/updates/world/master/2022_12_31_01_world.sql | 974 |
1 files changed, 974 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_12_31_01_world.sql b/sql/updates/world/master/2022_12_31_01_world.sql new file mode 100644 index 00000000000..46488db3983 --- /dev/null +++ b/sql/updates/world/master/2022_12_31_01_world.sql @@ -0,0 +1,974 @@ +SET @CGUID := 1251221; -- 231 +SET @OGUID := 700057; -- 29 +SET @NPCTEXTID := 590021; -- 5 + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+230; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID+0, 191736, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 2370.676025390625, -3030.52685546875, 921.92828369140625, 1.267032027244567871, 7200, 0, 0, 7155450, 0, 0, 0, 0, 0, 47213), -- Crawth (Area: -Unknown- - Difficulty: 0) +(@CGUID+1, 195569, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1435.560791015625, -2818.848876953125, 951.65472412109375, 2.084954261779785156, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Jump Pad Visual (Area: -Unknown- - Difficulty: 0) +(@CGUID+2, 195564, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1440.6041259765625, -2827.303955078125, 951.74249267578125, 5.262929916381835937, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Jump Pad (Area: -Unknown- - Difficulty: 0) +(@CGUID+3, 171322, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1404.421875, -2788.032958984375, 955.70062255859375, 0.856456637382507324, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Global Affix Stalker (Area: -Unknown- - Difficulty: 0) +(@CGUID+4, 196977, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1560.78125, -2928.859375, 900.26544189453125, 5.495911121368408203, 7200, 0, 0, 715545, 3155, 0, 0, 0, 0, 47213), -- Bronze Dragonflight Recruiter (Area: -Unknown- - Difficulty: 23) +(@CGUID+5, 189668, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1811.501708984375, -2783.670166015625, 903.51995849609375, 6.181200981140136718, 7200, 0, 0, 143109, 3155, 0, 0, 0, 0, 47213), -- Professor Maxdormu (Area: -Unknown- - Difficulty: 23) +(@CGUID+6, 196974, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1538.1319580078125, -2968.322998046875, 900.27569580078125, 1.774106740951538085, 7200, 0, 0, 715545, 3155, 0, 0, 0, 0, 47213), -- Black Dragonflight Recruiter (Area: -Unknown- - Difficulty: 23) +(@CGUID+7, 196978, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1613.265625, -2932.12841796875, 900.7232666015625, 3.839272022247314453, 7200, 0, 0, 715545, 3155, 0, 0, 0, 0, 47213), -- Blue Dragonflight Recruiter (Area: -Unknown- - Difficulty: 23) +(@CGUID+8, 195569, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1490.04345703125, -2905.692626953125, 902.98388671875, 5.262929916381835937, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Jump Pad Visual (Area: -Unknown- - Difficulty: 23) +(@CGUID+9, 195564, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1482.51220703125, -2894.569580078125, 900.51263427734375, 5.262929916381835937, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Jump Pad (Area: -Unknown- - Difficulty: 23) +(@CGUID+10, 190609, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1467.7603759765625, -3216.135498046875, 941.0616455078125, 1.085256218910217285, 7200, 0, 0, 6439905, 100, 0, 0, 0, 0, 47213), -- Echo of Doragosa (Area: -Unknown- - Difficulty: 23) +(@CGUID+11, 196482, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1766.2535400390625, -3086.40625, 913.65948486328125, 3.133788585662841796, 7200, 0, 0, 4293270, 100, 0, 0, 0, 0, 47213), -- Overgrown Ancient (Area: -Unknown- - Difficulty: 23) +(@CGUID+12, 182706, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1533.73388671875, -2934.12646484375, 901.9501953125, 4.134075641632080078, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Butterfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+13, 195587, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1500.4444580078125, -2935.791748046875, 900.03497314453125, 2.076085805892944335, 7200, 0, 0, 143109, 100, 0, 0, 0, 0, 47213), -- Headteacher Doragosa (Area: -Unknown- - Difficulty: 23) +(@CGUID+14, 196869, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1541.2447509765625, -2976.1181640625, 900.27569580078125, 1.30462193489074707, 7200, 0, 0, 715545, 3155, 0, 0, 0, 0, 47213), -- Black Dragonflight Alumni (Area: -Unknown- - Difficulty: 23) +(@CGUID+15, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1558.498291015625, -2944.65966796875, 900.028076171875, 1.375822067260742187, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+16, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1585.015625, -2910.267333984375, 900.01910400390625, 1.661058306694030761, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+17, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1584.845458984375, -2906.59716796875, 900.0242919921875, 3.031115055084228515, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+18, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1563.934326171875, -2944.450439453125, 899.997314453125, 0.984587550163269042, 7200, 10, 0, 143109, 0, 1, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+19, 196981, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1632.763916015625, -2998.333251953125, 900.333740234375, 1.835052251815795898, 7200, 0, 0, 715545, 3155, 0, 0, 0, 0, 47213), -- Red Dragonflight Recruiter (Area: -Unknown- - Difficulty: 23) +(@CGUID+20, 182706, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1500.379638671875, -2960.285400390625, 901.623291015625, 3.27865910530090332, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Butterfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+21, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1532.2447509765625, -2941.6806640625, 900.036865234375, 4.707534313201904296, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+22, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1529.9166259765625, -2943.907958984375, 900.036865234375, 5.957511425018310546, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+23, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1557.1649169921875, -2940.751708984375, 900.027099609375, 5.334624290466308593, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+24, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1583.07470703125, -2908.859375, 900.01910400390625, 0.472435176372528076, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+25, 182706, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1499.2476806640625, -2977.99169921875, 902.406982421875, 5.641621112823486328, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Butterfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+26, 196868, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1561.1754150390625, -2920.30029296875, 900.26544189453125, 5.546327114105224609, 7200, 0, 0, 715545, 3155, 0, 0, 0, 0, 47213), -- Bronze Dragonflight Alumni (Area: -Unknown- - Difficulty: 23) +(@CGUID+27, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1532.7760009765625, -2943.598876953125, 900.03662109375, 2.233006238937377929, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+28, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1583.1024169921875, -2905.638916015625, 900.02410888671875, 5.505643367767333984, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+29, 196979, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1653.529541015625, -2975.32470703125, 900.072021484375, 2.826504468917846679, 7200, 0, 0, 715545, 3155, 0, 0, 0, 0, 47213), -- Green Dragonflight Recruiter (Area: -Unknown- - Difficulty: 23) +(@CGUID+30, 196868, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1545.8524169921875, -2923.757080078125, 900.35107421875, 1.1576995849609375, 7200, 0, 0, 715545, 3155, 0, 0, 0, 0, 47213), -- Bronze Dragonflight Alumni (Area: -Unknown- - Difficulty: 23) +(@CGUID+31, 196869, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1532.6788330078125, -2973.210205078125, 900.27569580078125, 1.30462193489074707, 7200, 0, 0, 715545, 3155, 0, 0, 0, 0, 47213), -- Black Dragonflight Alumni (Area: -Unknown- - Difficulty: 23) +(@CGUID+32, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1580.8350830078125, -2908.001708984375, 900.0203857421875, 0.351620346307754516, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+33, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1563.1319580078125, -2968.748291015625, 900.0262451171875, 4.059599876403808593, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+34, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1559.782958984375, -2971.163330078125, 900.0262451171875, 0.10079745203256607, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+35, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1580.5242919921875, -2941.1337890625, 900.24871826171875, 3.031115055084228515, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+36, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1578.78125, -2940.17529296875, 900.06298828125, 5.505643367767333984, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+37, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1578.751708984375, -2943.395751953125, 900.1329345703125, 0.472435176372528076, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+38, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1568.6805419921875, -2965.9462890625, 900.0482177734375, 4.722859382629394531, 7200, 10, 0, 143109, 0, 1, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+39, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1576.736083984375, -2971.3681640625, 900.34014892578125, 5.505643367767333984, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+40, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1574.467041015625, -2973.73095703125, 900.0469970703125, 0.351620346307754516, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+41, 182706, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1587.8865966796875, -2970.441650390625, 902.73516845703125, 3.883431434631347656, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Butterfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+42, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1578.6492919921875, -2975.99658203125, 900.11865234375, 1.661058306694030761, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+43, 182706, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1596.0845947265625, -2908.1376953125, 901.01171875, 5.668548107147216796, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Butterfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+44, 182706, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1591.5020751953125, -2944.20751953125, 903.0086669921875, 5.126651763916015625, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Butterfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+45, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1578.4791259765625, -2972.326416015625, 900.47308349609375, 3.031115055084228515, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+46, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1601.017333984375, -2933.01904296875, 900.027099609375, 4.059599876403808593, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+47, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1576.7066650390625, -2974.588623046875, 900.1041259765625, 0.472435176372528076, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+48, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1597.66845703125, -2935.435791015625, 900.0272216796875, 0.10079745203256607, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+49, 196203, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 1, 1527.3160400390625, -3019.145751953125, 941.9794921875, 3.64131021499633789, 7200, 0, 0, 715545, 0, 0, 0, 0, 0, 47213), -- Ethereal Restorer (Area: -Unknown- - Difficulty: 23) +(@CGUID+50, 182706, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1579.29931640625, -2996.751220703125, 901.22076416015625, 1.8046799898147583, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Butterfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+51, 196202, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 1, 1519.6649169921875, -3019.43408203125, 942.52471923828125, 5.942115306854248046, 7200, 0, 0, 787100, 3155, 0, 0, 0, 0, 47213), -- Spectral Invoker (Area: -Unknown- - Difficulty: 23) +(@CGUID+52, 196202, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 1, 1521.94970703125, -3025.60595703125, 941.60198974609375, 1.0370866060256958, 7200, 0, 0, 787100, 3155, 0, 0, 0, 0, 47213), -- Spectral Invoker (Area: -Unknown- - Difficulty: 23) +(@CGUID+53, 196866, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1611.623291015625, -2919.25341796875, 900.72332763671875, 5.544145107269287109, 7200, 0, 0, 715545, 3155, 0, 0, 0, 0, 47213), -- Blue Dragonflight Alumni (Area: -Unknown- - Difficulty: 23) +(@CGUID+54, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1603.5035400390625, -2969.723876953125, 900.6632080078125, 4.794261455535888671, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+55, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1602.63720703125, -2973.760498046875, 900.5313720703125, 0.83545917272567749, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+56, 197882, 2526, 14032, 14032, '1,2,8,23', 0, 0, 0, 0, 1620.376708984375, -2943.125732421875, 900.0687255859375, 1.591729998588562011, 7200, 10, 0, 143109, 0, 1, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+57, 189667, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1620.78125, -2985.76220703125, 900.23956298828125, 1.778198480606079101, 7200, 0, 0, 143109, 3155, 1, 0, 0, 0, 47213), -- Professor Ichistrasz (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+58, 182706, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1641.0284423828125, -2929.130859375, 902.71923828125, 5.625397682189941406, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Butterfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+59, 197882, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1605.75, -2998.635498046875, 900.0382080078125, 2.312203884124755859, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+60, 182706, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1505.3294677734375, -3035.837890625, 943.693603515625, 0.307598471641540527, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Butterfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+61, 197882, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1605.0694580078125, -2996.765625, 900.0382080078125, 4.786732196807861328, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+62, 196865, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1623.78125, -3001.427001953125, 900.1817626953125, 1.731241106986999511, 7200, 0, 0, 143109, 3155, 0, 0, 0, 0, 47213), -- Red Dragonflight Alumni (Area: -Unknown- - Difficulty: 23) +(@CGUID+63, 196866, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1618.623291015625, -2917.310791015625, 900.722900390625, 1.1387101411819458, 7200, 0, 0, 715545, 3155, 0, 0, 0, 0, 47213), -- Blue Dragonflight Alumni (Area: -Unknown- - Difficulty: 23) +(@CGUID+64, 197882, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1602.9271240234375, -2999.16845703125, 900.04168701171875, 6.036709308624267578, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+65, 197882, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1640.3975830078125, -2940.225830078125, 900.0579833984375, 3.031115055084228515, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+66, 182706, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1556.897705078125, -3047.29248046875, 943.23577880859375, 3.609307765960693359, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Butterfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+67, 196865, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1628.1041259765625, -2999.23779296875, 900.3338623046875, 2.508337736129760742, 7200, 0, 0, 143109, 3155, 0, 0, 0, 0, 47213), -- Red Dragonflight Alumni (Area: -Unknown- - Difficulty: 23) +(@CGUID+68, 187287, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1636.670166015625, -2971.28466796875, 900.0313720703125, 2.855185747146606445, 7200, 0, 0, 143109, 3155, 1, 0, 0, 0, 47213), -- Professor Mystakria (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+69, 197882, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1632.02783203125, -2963.538330078125, 900.028076171875, 5.479539871215820312, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+70, 197882, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1633.9097900390625, -2967.217041015625, 900.02813720703125, 1.520737886428833007, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+71, 197882, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1638.654541015625, -2939.267333984375, 900.1275634765625, 5.505643367767333984, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+72, 197882, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1638.626708984375, -2942.48779296875, 900.02947998046875, 0.472435176372528076, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+73, 196864, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 1, 1642.189208984375, -3006.2744140625, 900.1817626953125, 0.684621989727020263, 7200, 0, 0, 715545, 3155, 0, 0, 0, 0, 47213), -- Red Dragonflight Alumni (Area: -Unknown- - Difficulty: 23) +(@CGUID+74, 197882, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1648.4566650390625, -2991.048583984375, 900.0279541015625, 5.422504901885986328, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+75, 196200, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 1, 1591.59033203125, -3054.736083984375, 940.96820068359375, 5.866595268249511718, 7200, 0, 0, 894431, 0, 0, 0, 0, 0, 47213), -- Algeth'ar Echoknight (Area: -Unknown- - Difficulty: 23) +(@CGUID+76, 196202, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 1, 1598.9427490234375, -3051.897705078125, 941.8819580078125, 4.233921527862548828, 7200, 0, 0, 787100, 3155, 0, 0, 0, 0, 47213), -- Spectral Invoker (Area: -Unknown- - Difficulty: 23) +(@CGUID+77, 196143, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1659.560791015625, -2968.1806640625, 900.072021484375, 0.932887196540832519, 7200, 0, 0, 112919, 3155, 0, 0, 0, 0, 47213), -- Green Dragonflight Alumni (Area: -Unknown- - Difficulty: 23) +(@CGUID+78, 196143, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1661.30908203125, -2982.286376953125, 900.072021484375, 5.698178291320800781, 7200, 0, 0, 112919, 3155, 0, 0, 0, 0, 47213), -- Green Dragonflight Alumni (Area: -Unknown- - Difficulty: 23) +(@CGUID+79, 197882, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1652.3541259765625, -2992.411376953125, 900.0279541015625, 3.098121404647827148, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dracthyr Freshscale (Area: -Unknown- - Difficulty: 23) +(@CGUID+80, 196203, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 1, 1598.1910400390625, -3058.7119140625, 940.84234619140625, 2.265871763229370117, 7200, 0, 0, 715545, 0, 0, 0, 0, 0, 47213), -- Ethereal Restorer (Area: -Unknown- - Difficulty: 23) +(@CGUID+81, 182706, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1663.5543212890625, -2949.345458984375, 902.04315185546875, 1.313371181488037109, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Butterfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+82, 182706, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1653.5677490234375, -3020.57470703125, 900.85345458984375, 0, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Butterfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+83, 182706, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1605.202880859375, -3063.58984375, 942.11187744140625, 2.702175378799438476, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Butterfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+84, 196577, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 1, 1681.079833984375, -2922.44970703125, 900.1629638671875, 3.719261646270751953, 7200, 0, 0, 787100, 0, 0, 0, 0, 0, 47213), -- Spellbound Battleaxe (Area: -Unknown- - Difficulty: 23) +(@CGUID+85, 196045, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1681.03125, -2917.390625, 900.1629638671875, 3.719261646270751953, 7200, 0, 0, 715545, 0, 0, 0, 0, 0, 47213), -- Corrupted Manafiend (Area: -Unknown- - Difficulty: 23) +(@CGUID+86, 196045, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1684.967041015625, -2923.685791015625, 901.359130859375, 3.719261646270751953, 7200, 0, 0, 715545, 0, 0, 0, 0, 0, 47213), -- Corrupted Manafiend (Area: -Unknown- - Difficulty: 23) +(@CGUID+87, 196202, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 1, 1578.529296875, -3053.03662109375, 940.5242919921875, 1.613586068153381347, 7200, 10, 0, 787100, 3155, 1, 0, 0, 0, 47213), -- Spectral Invoker (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+88, 182599, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1737.4149169921875, -3016.814208984375, 913.89495849609375, 0, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Dragonfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+89, 182599, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1664.0980224609375, -3067.91552734375, 914.67022705078125, 2.296781063079833984, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Dragonfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+90, 182599, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1690.5411376953125, -3085.402099609375, 914.35052490234375, 0.12892848253250122, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Dragonfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+91, 182706, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1639.298095703125, -3088.327392578125, 936.1414794921875, 1.251463532447814941, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Butterfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+92, 197398, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1746.545166015625, -3038.642333984375, 914.19769287109375, 0, 7200, 0, 0, 357773, 0, 0, 0, 0, 0, 47213), -- Hungry Lasher (Area: -Unknown- - Difficulty: 23) +(@CGUID+93, 182599, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1708.951416015625, -3078.10595703125, 915.29632568359375, 0, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Dragonfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+94, 197398, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1757.15625, -3046.553955078125, 914.8428955078125, 0, 7200, 0, 0, 357773, 0, 0, 0, 0, 0, 47213), -- Hungry Lasher (Area: -Unknown- - Difficulty: 23) +(@CGUID+95, 197398, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1762.2083740234375, -3030.520751953125, 914.9888916015625, 0, 7200, 0, 0, 357773, 0, 0, 0, 0, 0, 47213), -- Hungry Lasher (Area: -Unknown- - Difficulty: 23) +(@CGUID+96, 191936, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 2058.8701171875, -3127.97998046875, 924.8740234375, 0.430074065923690795, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dulox (Area: 0 - Difficulty: 23) +(@CGUID+97, 191932, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 2060.4599609375, -3117.280029296875, 924.87298583984375, 0.154094234108924865, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Dra'zish (Area: 0 - Difficulty: 23) +(@CGUID+98, 191933, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 2062.260009765625, -3124.550048828125, 924.87298583984375, 0.379086852073669433, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Malinor (Area: 0 - Difficulty: 23) +(@CGUID+99, 191935, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 2056.080078125, -3116.010009765625, 924.87701416015625, 0.102598741650581359, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Koflo (Area: 0 - Difficulty: 23) +(@CGUID+100, 196200, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 1, 1638.68408203125, -3103.80029296875, 933.6162109375, 6.112105369567871093, 7200, 0, 0, 894431, 0, 0, 0, 0, 0, 47213), -- Algeth'ar Echoknight (Area: 0 - Difficulty: 23) +(@CGUID+101, 196200, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 1, 1636.029541015625, -3111.638916015625, 933.63299560546875, 6.05920267105102539, 7200, 0, 0, 894431, 0, 0, 0, 0, 0, 47213), -- Algeth'ar Echoknight (Area: 0 - Difficulty: 23) +(@CGUID+102, 197398, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1779.1129150390625, -3032.32470703125, 914.6658935546875, 0, 7200, 0, 0, 357773, 0, 0, 0, 0, 0, 47213), -- Hungry Lasher (Area: 0 - Difficulty: 23) +(@CGUID+103, 197398, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1772.1944580078125, -3053.51220703125, 914.38031005859375, 0, 7200, 0, 0, 357773, 0, 0, 0, 0, 0, 47213), -- Hungry Lasher (Area: 0 - Difficulty: 23) +(@CGUID+104, 197398, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1740.2379150390625, -3116.05908203125, 913.98162841796875, 0, 7200, 0, 0, 357773, 0, 0, 0, 0, 0, 47213), -- Hungry Lasher (Area: -Unknown- - Difficulty: 23) +(@CGUID+105, 197398, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1784.4288330078125, -3059.138916015625, 915.26495361328125, 0, 7200, 0, 0, 357773, 0, 0, 0, 0, 0, 47213), -- Hungry Lasher (Area: -Unknown- - Difficulty: 23) +(@CGUID+106, 197398, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1749.15625, -3115.15966796875, 914.0001220703125, 0, 7200, 0, 0, 357773, 0, 0, 0, 0, 0, 47213), -- Hungry Lasher (Area: -Unknown- - Difficulty: 23) +(@CGUID+107, 197398, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1797.328125, -3055.270751953125, 914.2027587890625, 0, 7200, 0, 0, 357773, 0, 0, 0, 0, 0, 47213), -- Hungry Lasher (Area: -Unknown- - Difficulty: 23) +(@CGUID+108, 197398, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1794.7117919921875, -3039, 914.251953125, 0, 7200, 0, 0, 357773, 0, 0, 0, 0, 0, 47213), -- Hungry Lasher (Area: -Unknown- - Difficulty: 23) +(@CGUID+109, 197398, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1765.7603759765625, -3115.579833984375, 913.60296630859375, 0, 7200, 0, 0, 357773, 0, 0, 0, 0, 0, 47213), -- Hungry Lasher (Area: -Unknown- - Difficulty: 23) +(@CGUID+110, 197219, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1791.4346923828125, -3037.06591796875, 914.5218505859375, 2.766317367553710937, 7200, 10, 0, 1287981, 0, 1, 0, 0, 0, 47213), -- Vile Lasher (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+111, 197406, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1758.066650390625, -3103.979248046875, 913.66571044921875, 2.001652717590332031, 7200, 10, 0, 572436, 0, 1, 0, 0, 0, 47213), -- Aggravated Skitterfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+112, 197398, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1740.4722900390625, -3126, 913.52557373046875, 0, 7200, 0, 0, 357773, 0, 0, 0, 0, 0, 47213), -- Hungry Lasher (Area: -Unknown- - Difficulty: 23) +(@CGUID+113, 197398, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1780.923583984375, -3114.583251953125, 914.9482421875, 0, 7200, 0, 0, 357773, 0, 0, 0, 0, 0, 47213), -- Hungry Lasher (Area: -Unknown- - Difficulty: 23) +(@CGUID+114, 197398, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1803.6978759765625, -3067.19970703125, 913.67108154296875, 0, 7200, 0, 0, 357773, 0, 0, 0, 0, 0, 47213), -- Hungry Lasher (Area: -Unknown- - Difficulty: 23) +(@CGUID+115, 197406, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1766.5924072265625, -3118.60498046875, 913.5164794921875, 1.884517312049865722, 7200, 10, 0, 572436, 0, 1, 0, 0, 0, 47213), -- Aggravated Skitterfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+116, 197398, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1752.0850830078125, -3132.439208984375, 913.8804931640625, 0, 7200, 0, 0, 357773, 0, 0, 0, 0, 0, 47213), -- Hungry Lasher (Area: -Unknown- - Difficulty: 23) +(@CGUID+117, 197219, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1760.642333984375, -3124.68408203125, 914.614013671875, 4.357890129089355468, 7200, 0, 0, 1287981, 0, 0, 0, 0, 0, 47213), -- Vile Lasher (Area: -Unknown- - Difficulty: 23) +(@CGUID+118, 197406, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1758.0546875, -3117.639892578125, 914.77825927734375, 1.911063313484191894, 7200, 10, 0, 572436, 0, 1, 0, 0, 0, 47213), -- Aggravated Skitterfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+119, 197398, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1795.8646240234375, -3081.7587890625, 914.84307861328125, 0, 7200, 0, 0, 357773, 0, 0, 0, 0, 0, 47213), -- Hungry Lasher (Area: -Unknown- - Difficulty: 23) +(@CGUID+120, 182706, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1669.75732421875, -3137.27734375, 935.71136474609375, 2.273236036300659179, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Butterfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+121, 182599, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1729.5416259765625, -3146.963623046875, 914.2882080078125, 0, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Dragonfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+122, 197398, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1771.982666015625, -3132.296875, 913.64898681640625, 0, 7200, 0, 0, 357773, 0, 0, 0, 0, 0, 47213), -- Hungry Lasher (Area: -Unknown- - Difficulty: 23) +(@CGUID+123, 197406, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1805.319580078125, -3065.8173828125, 913.70721435546875, 3.282915592193603515, 7200, 10, 0, 572436, 0, 1, 0, 0, 0, 47213), -- Aggravated Skitterfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+124, 182599, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1808.7154541015625, -3034.943359375, 914.83575439453125, 5.331890106201171875, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Dragonfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+125, 197406, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1801.5672607421875, -3068.55615234375, 913.90216064453125, 3.521736621856689453, 7200, 10, 0, 572436, 0, 1, 0, 0, 0, 47213), -- Aggravated Skitterfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+126, 197406, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1804.692626953125, -3074.42138671875, 914.44921875, 3.716042518615722656, 7200, 10, 0, 572436, 0, 1, 0, 0, 0, 47213), -- Aggravated Skitterfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+127, 197398, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1782.15283203125, -3126.829833984375, 914.16351318359375, 0, 7200, 0, 0, 357773, 0, 0, 0, 0, 0, 47213), -- Hungry Lasher (Area: -Unknown- - Difficulty: 23) +(@CGUID+128, 197219, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1808.918212890625, -3068.0791015625, 913.892333984375, 3.413192987442016601, 7200, 10, 0, 1287981, 0, 1, 0, 0, 0, 47213), -- Vile Lasher (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+129, 182706, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1638.0645751953125, -3135.177978515625, 935.66204833984375, 2.359888792037963867, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Butterfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+130, 196200, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 1, 1603.923583984375, -3091.170166015625, 940.4991455078125, 5.800279617309570312, 7200, 0, 0, 894431, 0, 0, 0, 0, 0, 47213), -- Algeth'ar Echoknight (Area: -Unknown- - Difficulty: 23) +(@CGUID+131, 197398, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1820.767333984375, -3062.89404296875, 914.06268310546875, 0, 7200, 0, 0, 357773, 0, 0, 0, 0, 0, 47213), -- Hungry Lasher (Area: -Unknown- - Difficulty: 23) +(@CGUID+132, 197398, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1827.5504150390625, -3082.31591796875, 913.744140625, 0, 7200, 0, 0, 357773, 0, 0, 0, 0, 0, 47213), -- Hungry Lasher (Area: -Unknown- - Difficulty: 23) +(@CGUID+133, 197398, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1798.9566650390625, -3131.010498046875, 913.59515380859375, 0, 7200, 0, 0, 357773, 0, 0, 0, 0, 0, 47213), -- Hungry Lasher (Area: -Unknown- - Difficulty: 23) +(@CGUID+134, 182599, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1775.4775390625, -3155.52978515625, 915.264404296875, 0.560566723346710205, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Dragonfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+135, 197398, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1807.7291259765625, -3138.619873046875, 914.257568359375, 0, 7200, 0, 0, 357773, 0, 0, 0, 0, 0, 47213), -- Hungry Lasher (Area: -Unknown- - Difficulty: 23) +(@CGUID+136, 197398, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1823.3629150390625, -3101.036376953125, 914.947021484375, 0, 7200, 0, 0, 357773, 0, 0, 0, 0, 0, 47213), -- Hungry Lasher (Area: -Unknown- - Difficulty: 23) +(@CGUID+137, 197398, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1807.2708740234375, -3126.91845703125, 914.67633056640625, 0, 7200, 0, 0, 357773, 0, 0, 0, 0, 0, 47213), -- Hungry Lasher (Area: -Unknown- - Difficulty: 23) +(@CGUID+138, 182599, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1835.4259033203125, -3071.931640625, 914.67950439453125, 2.322913169860839843, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Dragonfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+139, 197802, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1791.62158203125, -3165.046875, 913.5966796875, 4.241666793823242187, 7200, 2, 0, 71555, 0, 1, 0, 0, 0, 47213), -- Well-Fed Duckling (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+140, 197802, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1798.48095703125, -3169.326416015625, 913.64727783203125, 0.362675040960311889, 7200, 2, 0, 71555, 0, 1, 0, 0, 0, 47213), -- Well-Fed Duckling (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+141, 196200, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 1, 1649.3853759765625, -3164.460205078125, 932.98394775390625, 2.408941030502319335, 7200, 0, 0, 894431, 0, 0, 0, 0, 0, 47213), -- Algeth'ar Echoknight (Area: -Unknown- - Difficulty: 23) +(@CGUID+142, 197802, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1805.9930419921875, -3174.951416015625, 913.45843505859375, 3.207857131958007812, 7200, 2, 0, 71555, 0, 1, 0, 0, 0, 47213), -- Well-Fed Duckling (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+143, 197802, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1808.0833740234375, -3184.90283203125, 913.44952392578125, 0, 7200, 2, 0, 71555, 0, 1, 0, 0, 0, 47213), -- Well-Fed Duckling (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+144, 182599, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1817.548583984375, -3161.955078125, 915.26416015625, 3.908746242523193359, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Dragonfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+145, 197802, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1802.48095703125, -3191.47216796875, 913.6092529296875, 4.582408905029296875, 7200, 2, 0, 71555, 0, 1, 0, 0, 0, 47213), -- Well-Fed Duckling (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+146, 196200, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 1, 1643.25, -3170.01220703125, 932.98394775390625, 2.461844205856323242, 7200, 0, 0, 894431, 0, 0, 0, 0, 0, 47213), -- Algeth'ar Echoknight (Area: -Unknown- - Difficulty: 23) +(@CGUID+147, 182599, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1787.852783203125, -3212.076904296875, 914.71124267578125, 6.071532726287841796, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Dragonfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+148, 196198, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1721.296875, -3221.390625, 964.37347412109375, 2.166369199752807617, 7200, 0, 0, 1144872, 0, 0, 0, 0, 0, 47213), -- Algeth'ar Security (Area: -Unknown- - Difficulty: 23) +(@CGUID+149, 196198, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1714.3160400390625, -3228.241455078125, 964.37347412109375, 2.092945814132690429, 7200, 0, 0, 1144872, 0, 0, 0, 0, 0, 47213), -- Algeth'ar Security (Area: -Unknown- - Difficulty: 23) +(@CGUID+150, 182706, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1733.7288818359375, -3226.2919921875, 965.325439453125, 0.989059031009674072, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 47213), -- Butterfly (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+151, 196202, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 1, 1721.123291015625, -3227.51904296875, 964.37347412109375, 2.416546583175659179, 7200, 0, 0, 787100, 3155, 0, 0, 0, 0, 47213), -- Spectral Invoker (Area: -Unknown- - Difficulty: 23) +(@CGUID+152, 196202, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 1, 1750.2535400390625, -3240.689208984375, 964.37347412109375, 4.233921051025390625, 7200, 0, 0, 787100, 3155, 0, 0, 0, 0, 47213), -- Spectral Invoker (Area: -Unknown- - Difficulty: 23) +(@CGUID+153, 195569, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1866.954833984375, -3133.185791015625, 917.5986328125, 3.07617044448852539, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Jump Pad Visual (Area: -Unknown- - Difficulty: 23) +(@CGUID+154, 195564, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1881.920166015625, -3133.491455078125, 914.6929931640625, 3.07617044448852539, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Jump Pad (Area: -Unknown- - Difficulty: 23) +(@CGUID+155, 196203, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 1, 1749.501708984375, -3247.501708984375, 964.4010009765625, 2.265871763229370117, 7200, 0, 0, 715545, 0, 0, 0, 0, 0, 47213), -- Ethereal Restorer (Area: -Unknown- - Difficulty: 23) +(@CGUID+156, 196198, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1742.9010009765625, -3243.526123046875, 964.38116455078125, 5.866595268249511718, 7200, 0, 0, 1144872, 0, 0, 0, 0, 0, 47213), -- Algeth'ar Security (Area: -Unknown- - Difficulty: 23) +(@CGUID+157, 195569, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 2054.392333984375, -3122.72216796875, 924.9560546875, 0.052324723452329635, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Jump Pad Visual (Area: -Unknown- - Difficulty: 23) +(@CGUID+158, 195564, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 2043.29345703125, -3125.48779296875, 925.40679931640625, 0.052324723452329635, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Jump Pad (Area: -Unknown- - Difficulty: 23) +(@CGUID+159, 191610, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 2370.541748046875, -3175.609375, 944.3475341796875, 1.572368621826171875, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Goal of the Searing Blaze (Area: -Unknown- - Difficulty: 23) +(@CGUID+160, 193033, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 2368.51220703125, -3049.663330078125, 968.0504150390625, 0, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Spell Bunny (Area: -Unknown- - Difficulty: 23) +(@CGUID+161, 195569, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 2081.507080078125, -3072.642333984375, 924.9560546875, 5.098744392395019531, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Jump Pad Visual (Area: -Unknown- - Difficulty: 23) +(@CGUID+162, 195564, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 2078.201416015625, -3062.87158203125, 925.40570068359375, 5.098744392395019531, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Jump Pad (Area: -Unknown- - Difficulty: 23) +(@CGUID+163, 192680, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 2093.32470703125, -3112.17529296875, 925.193115234375, 3.370730400085449218, 7200, 0, 0, 2146635, 0, 0, 0, 0, 0, 47213), -- Guardian Sentry (Area: -Unknown- - Difficulty: 23) +(@CGUID+164, 196947, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 2370.541748046875, -2921.6650390625, 944.3475341796875, 4.686403751373291015, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Goal of the Rushing Winds (Area: 0 - Difficulty: 23) +(@CGUID+165, 195564, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 2038.26220703125, -2942.736083984375, 897.1451416015625, 5.098744392395019531, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Jump Pad (Area: 0 - Difficulty: 23) +(@CGUID+166, 195569, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 2032.78125, -2928.326416015625, 900.0880126953125, 1.857543110847473144, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Jump Pad Visual (Area: 0 - Difficulty: 23) +(@CGUID+167, 196045, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 2012.072265625, -2894.293212890625, 896.8223876953125, 1.942186355590820312, 7200, 0, 0, 715545, 0, 0, 0, 0, 0, 47213), -- Corrupted Manafiend (Area: 0 - Difficulty: 23) +(@CGUID+168, 196045, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 2019.947265625, -2893.706787109375, 896.76312255859375, 5.335118770599365234, 7200, 0, 0, 715545, 0, 0, 0, 0, 0, 47213), -- Corrupted Manafiend (Area: 0 - Difficulty: 23) +(@CGUID+169, 196577, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 1, 2015.6966552734375, -2891.947509765625, 896.85369873046875, 0.404166102409362792, 7200, 0, 0, 787100, 0, 0, 0, 0, 0, 47213), -- Spellbound Battleaxe (Area: 0 - Difficulty: 23) +(@CGUID+170, 182706, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1999.7052001953125, -2908.20263671875, 895.92529296875, 3.51792764663696289, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 47213), -- Butterfly (Area: 0 - Difficulty: 23) +(@CGUID+171, 195294, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 2044.564453125, -2892.328857421875, 895.6534423828125, 3.493022441864013671, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 47213), -- Beetle (Area: 0 - Difficulty: 23) +(@CGUID+172, 196694, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 2036.1676025390625, -2878.63720703125, 896.2900390625, 3.18362593650817871, 7200, 0, 0, 572436, 0, 0, 0, 0, 0, 47213), -- Arcane Forager (Area: 0 - Difficulty: 23) +(@CGUID+173, 196694, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 2033.342529296875, -2872.732421875, 896.1103515625, 4.794712066650390625, 7200, 0, 0, 572436, 0, 0, 0, 0, 0, 47213), -- Arcane Forager (Area: 0 - Difficulty: 23) +(@CGUID+174, 196694, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1980.4813232421875, -2901.770751953125, 894.03204345703125, 6.230239391326904296, 7200, 0, 0, 572436, 0, 0, 0, 0, 0, 47213), -- Arcane Forager (Area: 0 - Difficulty: 23) +(@CGUID+175, 196694, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1983.5201416015625, -2898.400634765625, 894.3902587890625, 4.830585479736328125, 7200, 0, 0, 572436, 0, 0, 0, 0, 0, 47213), -- Arcane Forager (Area: 0 - Difficulty: 23) +(@CGUID+176, 196671, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1980.3211669921875, -2880.34375, 895.80181884765625, 6.218436241149902343, 7200, 0, 0, 1717308, 0, 0, 0, 0, 0, 47213), -- Arcane Ravager (Area: 0 - Difficulty: 23) +(@CGUID+177, 196576, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 1, 1974.0379638671875, -2879.76025390625, 895.20989990234375, 5.28864288330078125, 7200, 0, 0, 643991, 0, 0, 0, 0, 0, 47213), -- Spellbound Scepter (Area: 0 - Difficulty: 23) +(@CGUID+178, 196577, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 1, 1982.8155517578125, -2875.953369140625, 896.28271484375, 0.195068448781967163, 7200, 0, 0, 787100, 0, 0, 0, 0, 0, 47213), -- Spellbound Battleaxe (Area: 0 - Difficulty: 23) +(@CGUID+179, 195294, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1972.86865234375, -2890.594482421875, 894.2275390625, 4.468873977661132812, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 47213), -- Beetle (Area: 0 - Difficulty: 23) +(@CGUID+180, 195294, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 2000.6357421875, -2849.251953125, 896.8248291015625, 1.957731842994689941, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 47213), -- Beetle (Area: 0 - Difficulty: 23) +(@CGUID+181, 195294, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1962.910888671875, -2844.08447265625, 895.0977783203125, 5.463441371917724609, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 47213), -- Beetle (Area: 0 - Difficulty: 23) +(@CGUID+182, 196694, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1987.6510009765625, -2823.61279296875, 895.3817138671875, 3.907679080963134765, 7200, 0, 0, 572436, 0, 0, 0, 0, 0, 47213), -- Arcane Forager (Area: 0 - Difficulty: 23) +(@CGUID+183, 196694, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1977.970458984375, -2819.72900390625, 895.30389404296875, 2.208752632141113281, 7200, 0, 0, 572436, 0, 0, 0, 0, 0, 47213), -- Arcane Forager (Area: 0 - Difficulty: 23) +(@CGUID+184, 196694, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1989.499267578125, -2815.484619140625, 894.75079345703125, 3.651326417922973632, 7200, 0, 0, 572436, 0, 0, 0, 0, 0, 47213), -- Arcane Forager (Area: 0 - Difficulty: 23) +(@CGUID+185, 196694, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1979.1624755859375, -2809.823974609375, 894.7724609375, 1.118758201599121093, 7200, 0, 0, 572436, 0, 0, 0, 0, 0, 47213), -- Arcane Forager (Area: 0 - Difficulty: 23) +(@CGUID+186, 182706, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1973.3680419921875, -2803.359375, 894.51214599609375, 0, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 47213), -- Butterfly (Area: 0 - Difficulty: 23) +(@CGUID+187, 196045, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1894.8121337890625, -2869.71337890625, 895.05560302734375, 0.027519308030605316, 7200, 10, 0, 715545, 0, 1, 0, 0, 0, 47213), -- Corrupted Manafiend (Area: 0 - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+188, 196045, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1892.5216064453125, -2852.81982421875, 895.05560302734375, 5.692238330841064453, 7200, 10, 0, 715545, 0, 1, 0, 0, 0, 47213), -- Corrupted Manafiend (Area: 0 - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+189, 196577, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 1, 1887.130859375, -2861.9501953125, 895.05560302734375, 0.649513959884643554, 7200, 10, 0, 787100, 0, 1, 0, 0, 0, 47213), -- Spellbound Battleaxe (Area: 0 - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+190, 196576, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 1, 1886.3555908203125, -2858.14306640625, 895.05560302734375, 5.978523731231689453, 7200, 10, 0, 643991, 0, 1, 0, 0, 0, 47213), -- Spellbound Scepter (Area: 0 - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+191, 182706, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1824.7327880859375, -2846.81884765625, 900.79962158203125, 2.624429702758789062, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 47213), -- Butterfly (Area: 0 - Difficulty: 23) +(@CGUID+192, 196044, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1837.4208984375, -2800.00390625, 903.52685546875, 1.060813307762145996, 7200, 0, 0, 572436, 0, 0, 0, 0, 0, 47213), -- Unruly Textbook (Area: 0 - Difficulty: 23) +(@CGUID+193, 197904, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 1, 1829.59765625, -2806.26318359375, 903.5933837890625, 6.037605762481689453, 7200, 0, 0, 787100, 0, 0, 0, 0, 0, 47213), -- Spellbound Battleaxe (Area: 0 - Difficulty: 23) +(@CGUID+194, 196798, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1833.328125, -2805.086669921875, 903.55841064453125, 0.851667284965515136, 7200, 0, 0, 715545, 0, 0, 0, 0, 0, 47213), -- Corrupted Manafiend (Area: 0 - Difficulty: 23) +(@CGUID+195, 196798, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1830.2647705078125, -2802.0263671875, 903.5633544921875, 5.227001190185546875, 7200, 0, 0, 715545, 0, 0, 0, 0, 0, 47213), -- Corrupted Manafiend (Area: 0 - Difficulty: 23) +(@CGUID+196, 196694, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1815.6925048828125, -2843.9267578125, 901.78131103515625, 5.647647380828857421, 7200, 0, 0, 572436, 0, 0, 0, 0, 0, 47213), -- Arcane Forager (Area: 0 - Difficulty: 23) +(@CGUID+197, 196694, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1811.5350341796875, -2842.003662109375, 902.33917236328125, 2.724582433700561523, 7200, 0, 0, 572436, 0, 0, 0, 0, 0, 47213), -- Arcane Forager (Area: 0 - Difficulty: 23) +(@CGUID+198, 196044, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1825.407958984375, -2777.1875, 904.53875732421875, 3.738338232040405273, 7200, 10, 0, 572436, 0, 1, 0, 0, 0, 47213), -- Unruly Textbook (Area: 0 - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+199, 196694, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1805.4539794921875, -2878.677978515625, 901.28277587890625, 2.727178812026977539, 7200, 10, 0, 572436, 0, 1, 0, 0, 0, 47213), -- Arcane Forager (Area: 0 - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+200, 195416, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1815.5364990234375, -2783.7587890625, 903.51995849609375, 4.26464080810546875, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Magic Book (Area: 0 - Difficulty: 23) +(@CGUID+201, 196798, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1824.3551025390625, -2774.4541015625, 903.4461669921875, 3.200696468353271484, 7200, 0, 0, 715545, 0, 0, 0, 0, 0, 47213), -- Corrupted Manafiend (Area: 0 - Difficulty: 23) +(@CGUID+202, 182706, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1788.1446533203125, -2874.312255859375, 902.58782958984375, 0.225959211587905883, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 47213), -- Butterfly (Area: 0 - Difficulty: 23) +(@CGUID+203, 196694, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1786.9287109375, -2852.2119140625, 900.02777099609375, 5.543605804443359375, 7200, 0, 0, 572436, 0, 0, 0, 0, 0, 47213), -- Arcane Forager (Area: 0 - Difficulty: 23) +(@CGUID+204, 196694, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1800.3701171875, -2879.97119140625, 901.04278564453125, 5.745515823364257812, 7200, 10, 0, 572436, 0, 1, 0, 0, 0, 47213), -- Arcane Forager (Area: 0 - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+205, 196694, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1783.3739013671875, -2861.279541015625, 900.02777099609375, 5.823615074157714843, 7200, 0, 0, 572436, 0, 0, 0, 0, 0, 47213), -- Arcane Forager (Area: 0 - Difficulty: 23) +(@CGUID+206, 196671, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1786.0572509765625, -2858.025634765625, 900.02777099609375, 5.600834846496582031, 7200, 0, 0, 1717308, 0, 0, 0, 0, 0, 47213), -- Arcane Ravager (Area: 0 - Difficulty: 23) +(@CGUID+207, 195294, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1778.656494140625, -2818.39990234375, 901.75537109375, 5.788979530334472656, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 47213), -- Beetle (Area: 0 - Difficulty: 23) +(@CGUID+208, 197904, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 1, 1789.7720947265625, -2787.26123046875, 903.625244140625, 2.836070537567138671, 7200, 0, 0, 787100, 0, 0, 0, 0, 0, 47213), -- Spellbound Battleaxe (Area: 0 - Difficulty: 23) +(@CGUID+209, 197905, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 1, 1824.3316650390625, -2766.28515625, 903.484130859375, 2.72032785415649414, 7200, 10, 0, 643991, 0, 1, 0, 0, 0, 47213), -- Spellbound Scepter (Area: 0 - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+210, 196694, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1762.8062744140625, -2834.1259765625, 902.216064453125, 0.562447726726531982, 7200, 0, 0, 572436, 0, 0, 0, 0, 0, 47213), -- Arcane Forager (Area: 0 - Difficulty: 23) +(@CGUID+211, 195294, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1761.908447265625, -2849.30517578125, 900.9033203125, 1.042440533638000488, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 47213), -- Beetle (Area: 0 - Difficulty: 23) +(@CGUID+212, 196798, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1817.162109375, -2770.232666015625, 903.46990966796875, 4.62086343765258789, 7200, 10, 0, 715545, 0, 1, 0, 0, 0, 47213), -- Corrupted Manafiend (Area: 0 - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+213, 196798, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1787.19091796875, -2784.126220703125, 903.5555419921875, 0.991994678974151611, 7200, 0, 0, 715545, 0, 0, 0, 0, 0, 47213), -- Corrupted Manafiend (Area: 0 - Difficulty: 23) +(@CGUID+214, 196694, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1759.1639404296875, -2832.8818359375, 902.41619873046875, 0.317718327045440673, 7200, 0, 0, 572436, 0, 0, 0, 0, 0, 47213), -- Arcane Forager (Area: 0 - Difficulty: 23) +(@CGUID+215, 196798, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1795.14111328125, -2780.816162109375, 903.531005859375, 4.13897562026977539, 7200, 0, 0, 715545, 0, 0, 0, 0, 0, 47213), -- Corrupted Manafiend (Area: 0 - Difficulty: 23) +(@CGUID+216, 196044, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1828.5421142578125, -2763.870361328125, 903.49310302734375, 5.473397254943847656, 7200, 10, 0, 572436, 0, 1, 0, 0, 0, 47213), -- Unruly Textbook (Area: 0 - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+217, 196044, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1790.236328125, -2776.033203125, 903.6395263671875, 0.720443606376647949, 7200, 0, 0, 572436, 0, 0, 0, 0, 0, 47213), -- Unruly Textbook (Area: 0 - Difficulty: 23) +(@CGUID+218, 196045, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1717.662353515625, -2900.651123046875, 900.44622802734375, 5.326707839965820312, 7200, 10, 0, 715545, 0, 1, 0, 0, 0, 47213), -- Corrupted Manafiend (Area: 0 - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+219, 196045, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1712.418212890625, -2892.416015625, 900.44622802734375, 2.448913097381591796, 7200, 10, 0, 715545, 0, 1, 0, 0, 0, 47213), -- Corrupted Manafiend (Area: 0 - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+220, 196577, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 1, 1707.808349609375, -2898.891845703125, 900.44622802734375, 1.24682772159576416, 7200, 10, 0, 787100, 0, 1, 0, 0, 0, 47213), -- Spellbound Battleaxe (Area: 0 - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+221, 196576, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 1, 1710.81005859375, -2904.273681640625, 900.44622802734375, 1.429446697235107421, 7200, 10, 0, 643991, 0, 1, 0, 0, 0, 47213), -- Spellbound Scepter (Area: 0 - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+222, 199677, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 1722.6875, -2807.404541015625, 862.878173828125, 0, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Teleporter Stalker (Area: 0 - Difficulty: 23) +(@CGUID+223, 196203, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 1, 1579.708740234375, -3044.195556640625, 940.5242919921875, 1.920749902725219726, 7200, 10, 0, 715545, 0, 1, 0, 0, 0, 47213), -- Ethereal Restorer (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+224, 196202, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 1, 1571.777099609375, -3043.551513671875, 940.5242919921875, 2.440057277679443359, 7200, 10, 0, 787100, 3155, 1, 0, 0, 0, 47213), -- Spectral Invoker (Area: -Unknown- - Difficulty: 23) (possible waypoints or random movement) +(@CGUID+225, 182706, 2526, 14032, 14033, '1,2,8,23', 0, 0, 0, 0, 1548.0479736328125, -3064.542236328125, 943.83306884765625, 6.164545059204101562, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 47213), -- Butterfly (Area: -Unknown- - Difficulty: 23) +(@CGUID+226, 196200, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 1, 1600.0416259765625, -3104.4375, 940.4991455078125, 6.27634429931640625, 7200, 0, 0, 894431, 0, 0, 0, 0, 0, 47213), -- Algeth'ar Echoknight (Area: -Unknown- - Difficulty: 23) +(@CGUID+227, 196202, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 1, 1596.7725830078125, -3096.788330078125, 940.4991455078125, 6.050457000732421875, 7200, 0, 0, 787100, 3155, 0, 0, 0, 0, 47213), -- Spectral Invoker (Area: -Unknown- - Difficulty: 23) +(@CGUID+228, 182706, 2526, 14032, 14037, '1,2,8,23', 0, 0, 0, 0, 1581.5875244140625, -3113.579833984375, 943.71099853515625, 1.697130203247070312, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 47213), -- Butterfly (Area: -Unknown- - Difficulty: 23) +(@CGUID+229, 192864, 2526, 14032, 0, '1,2,8,23', 0, 0, 0, 0, 2116.463623046875, -3105.170166015625, 928.6461181640625, 3.348936319351196289, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213), -- Jump Pad (Area: 0 - Difficulty: 23) +(@CGUID+230, 192864, 2526, 14032, 14035, '1,2,8,23', 0, 0, 0, 0, 2318.132080078125, -3054.920166015625, 910.01983642578125, 0.243503466248512268, 7200, 0, 0, 143109, 0, 0, 0, 0, 0, 47213); -- Jump Pad (Area: -Unknown- - Difficulty: 23) + +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+230; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+0, 0, 0, 50331648, 1, 0, 0, 0, 0, 5, ''), -- Crawth +(@CGUID+1, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Jump Pad Visual +(@CGUID+4, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''), -- Bronze Dragonflight Recruiter +(@CGUID+5, 0, 0, 0, 1, 0, 0, 0, 0, 4, ''), -- Professor Maxdormu +(@CGUID+6, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''), -- Black Dragonflight Recruiter +(@CGUID+7, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''), -- Blue Dragonflight Recruiter +(@CGUID+8, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Jump Pad Visual +(@CGUID+10, 0, 0, 0, 1, 0, 0, 0, 0, 4, ''), -- Echo of Doragosa +(@CGUID+11, 0, 0, 0, 1, 0, 0, 0, 0, 4, ''), -- Overgrown Ancient +(@CGUID+12, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Butterfly +(@CGUID+19, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''), -- Red Dragonflight Recruiter +(@CGUID+20, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Butterfly +(@CGUID+25, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Butterfly +(@CGUID+29, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''), -- Green Dragonflight Recruiter +(@CGUID+41, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Butterfly +(@CGUID+43, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Butterfly +(@CGUID+44, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Butterfly +(@CGUID+50, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Butterfly +(@CGUID+58, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Butterfly +(@CGUID+60, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Butterfly +(@CGUID+66, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Butterfly +(@CGUID+81, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Butterfly +(@CGUID+82, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Butterfly +(@CGUID+83, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Butterfly +(@CGUID+84, 0, 0, 0, 1, 333, 0, 0, 0, 0, ''), -- Spellbound Battleaxe +(@CGUID+85, 0, 0, 0, 1, 333, 0, 0, 0, 0, ''), -- Corrupted Manafiend +(@CGUID+86, 0, 0, 0, 1, 333, 0, 0, 0, 0, ''), -- Corrupted Manafiend +(@CGUID+88, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Dragonfly +(@CGUID+89, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Dragonfly +(@CGUID+90, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Dragonfly +(@CGUID+91, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Butterfly +(@CGUID+93, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Dragonfly +(@CGUID+96, 0, 0, 0, 1, 0, 0, 0, 0, 4, ''), -- Dulox +(@CGUID+97, 0, 0, 0, 1, 0, 0, 0, 0, 4, ''), -- Dra'zish +(@CGUID+98, 0, 0, 0, 1, 0, 0, 0, 0, 4, ''), -- Malinor +(@CGUID+99, 0, 0, 0, 1, 0, 0, 0, 0, 4, ''), -- Koflo +(@CGUID+100, 0, 0, 0, 1, 716, 0, 0, 0, 0, ''), -- Algeth'ar Echoknight +(@CGUID+101, 0, 0, 0, 1, 716, 0, 0, 0, 0, ''), -- Algeth'ar Echoknight +(@CGUID+111, 0, 0, 33554432, 1, 0, 0, 0, 0, 0, ''), -- Aggravated Skitterfly +(@CGUID+115, 0, 0, 33554432, 1, 0, 0, 0, 0, 0, ''), -- Aggravated Skitterfly +(@CGUID+118, 0, 0, 33554432, 1, 0, 0, 0, 0, 0, ''), -- Aggravated Skitterfly +(@CGUID+120, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Butterfly +(@CGUID+121, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Dragonfly +(@CGUID+123, 0, 0, 33554432, 1, 0, 0, 0, 0, 0, ''), -- Aggravated Skitterfly +(@CGUID+124, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Dragonfly +(@CGUID+125, 0, 0, 33554432, 1, 0, 0, 0, 0, 0, ''), -- Aggravated Skitterfly +(@CGUID+126, 0, 0, 33554432, 1, 0, 0, 0, 0, 0, ''), -- Aggravated Skitterfly +(@CGUID+129, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Butterfly +(@CGUID+130, 0, 0, 0, 1, 716, 0, 0, 0, 0, ''), -- Algeth'ar Echoknight +(@CGUID+134, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Dragonfly +(@CGUID+138, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Dragonfly +(@CGUID+141, 0, 0, 0, 1, 716, 0, 0, 0, 0, ''), -- Algeth'ar Echoknight +(@CGUID+144, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Dragonfly +(@CGUID+146, 0, 0, 0, 1, 716, 0, 0, 0, 0, ''), -- Algeth'ar Echoknight +(@CGUID+147, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Dragonfly +(@CGUID+148, 0, 0, 0, 1, 716, 0, 0, 0, 0, ''), -- Algeth'ar Security +(@CGUID+149, 0, 0, 0, 1, 716, 0, 0, 0, 0, ''), -- Algeth'ar Security +(@CGUID+150, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Butterfly +(@CGUID+151, 0, 0, 0, 1, 716, 0, 0, 0, 0, ''), -- Spectral Invoker +(@CGUID+153, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Jump Pad Visual +(@CGUID+157, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Jump Pad Visual +(@CGUID+159, 0, 0, 0, 1, 0, 0, 0, 0, 4, ''), -- Goal of the Searing Blaze +(@CGUID+160, 0, 0, 50331648, 1, 0, 0, 0, 0, 4, ''), -- Spell Bunny +(@CGUID+161, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Jump Pad Visual +(@CGUID+164, 0, 0, 0, 1, 0, 0, 0, 0, 4, ''), -- Goal of the Rushing Winds +(@CGUID+166, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Jump Pad Visual +(@CGUID+170, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Butterfly +(@CGUID+186, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Butterfly +(@CGUID+191, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Butterfly +(@CGUID+192, 0, 0, 33554432, 1, 0, 0, 0, 0, 0, ''), -- Unruly Textbook +(@CGUID+198, 0, 0, 33554432, 1, 0, 0, 0, 0, 0, ''), -- Unruly Textbook +(@CGUID+202, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Butterfly +(@CGUID+216, 0, 0, 33554432, 1, 0, 0, 0, 0, 0, ''), -- Unruly Textbook +(@CGUID+217, 0, 0, 33554432, 1, 0, 0, 0, 0, 0, ''), -- Unruly Textbook +(@CGUID+225, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- Butterfly +(@CGUID+226, 0, 0, 0, 1, 716, 0, 0, 0, 0, ''), -- Algeth'ar Echoknight +(@CGUID+227, 0, 0, 0, 1, 716, 0, 0, 0, 0, ''), -- Spectral Invoker +(@CGUID+228, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''); -- Butterfly + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+28; +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, 378468, 2526, 14032, 14032, '1,2,8,23', 0, 0, 1528.2772216796875, -3102.718505859375, 941.106689453125, 4.222011089324951171, 0, 0, -0.85760116577148437, 0.514315307140350341, 7200, 255, 0, 47213), -- Door (Area: -Unknown- - Difficulty: 0) +(@OGUID+1, 382476, 2526, 14032, 14032, '1,2,8,23', 0, 0, 1688.04345703125, -3031.513916015625, 913.8153076171875, 2.312558174133300781, 0, 0, 0.915310859680175781, 0.402748137712478637, 7200, 255, 0, 47213), -- Door (Area: -Unknown- - Difficulty: 0) +(@OGUID+2, 382477, 2526, 14032, 14032, '1,2,8,23', 0, 0, 1845.5, -3130.286376953125, 914.480712890625, 6.178466320037841796, 0, 0, -0.05233573913574218, 0.998629570007324218, 7200, 255, 0, 47213), -- Door (Area: -Unknown- - Difficulty: 0) +(@OGUID+3, 246779, 2526, 14032, 14032, '8,23', 0, 0, 1408.453125, -2785.223876953125, 955.6241455078125, 2.900490999221801757, 0, 0, 0.992742538452148437, 0.120259024202823638, 7200, 255, 1, 47213), -- Font of Power (Area: -Unknown- - Difficulty: 0) +(@OGUID+4, 382475, 2526, 14032, 14032, '1,2,8,23', 0, 0, 1677.9097900390625, -3111.42529296875, 933.3074951171875, 0.296705186367034912, 0, 0, 0.147809028625488281, 0.989015936851501464, 7200, 255, 1, 47213), -- Door (Area: -Unknown- - Difficulty: 0) +(@OGUID+5, 382480, 2526, 14032, 14032, '1,2,8,23', 0, 0, 1484.609375, -2937.255126953125, 906.3345947265625, 4.108412742614746093, 0, 0, -0.88541507720947265, 0.464801162481307983, 7200, 255, 1, 47213), -- Brazier (Area: -Unknown- - Difficulty: 23) +(@OGUID+6, 382500, 2526, 14032, 14032, '1,2,8,23', 0, 0, 1519.109375, -2908.135498046875, 906.31671142578125, 4.108417034149169921, 0, 0, -0.88541412353515625, 0.464802980422973632, 7200, 255, 1, 47213), -- Brazier (Area: -Unknown- - Difficulty: 23) +(@OGUID+7, 384399, 2526, 14032, 14032, '1,2,8,23', 0, 0, 1535.875, -2994.005126953125, 901.65899658203125, 4.606465339660644531, 0, 0, -0.74354743957519531, 0.668683171272277832, 7200, 255, 1, 47213), -- Lava (Area: -Unknown- - Difficulty: 23) +(@OGUID+8, 384978, 2526, 14032, 14032, '1,2,8,23', 0, 0, 1534.9114990234375, -2990.467041015625, 899.71368408203125, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 47213), -- Lava (Area: -Unknown- - Difficulty: 23) +(@OGUID+9, 382506, 2526, 14032, 14032, '1,2,8,23', 0, 0, 1468.5660400390625, -3009.0400390625, 923.36944580078125, 1.160645961761474609, 0, 0, 0.5482940673828125, 0.836285591125488281, 7200, 255, 1, 47213), -- Brazier (Area: -Unknown- - Difficulty: 23) +(@OGUID+10, 382521, 2526, 14032, 14033, '1,2,8,23', 0, 0, 1553.6961669921875, -3056.725830078125, 944.42523193359375, 2.67034769058227539, 0, 0, 0.972369194030761718, 0.233448356389999389, 7200, 255, 1, 47213), -- Brazier (Area: -Unknown- - Difficulty: 23) +(@OGUID+11, 382508, 2526, 14032, 14033, '1,2,8,23', 0, 0, 1659.6978759765625, -2922.397705078125, 905.82098388671875, 0.29486936330795288, 0, 0, 0.146901130676269531, 0.989151179790496826, 7200, 255, 1, 47213), -- Brazier (Area: -Unknown- - Difficulty: 23) +(@OGUID+12, 382509, 2526, 14032, 14033, '1,2,8,23', 0, 0, 1672.63720703125, -2941.1337890625, 905.87060546875, 2.773230552673339843, 0, 0, 0.983086585998535156, 0.183141440153121948, 7200, 255, 1, 47213), -- Brazier (Area: -Unknown- - Difficulty: 23) +(@OGUID+13, 382485, 2526, 14032, 14033, '1,2,8,23', 0, 0, 1614.0711669921875, -3077.491455078125, 946.674072265625, 3.281238555908203125, 0, 0, -0.99756336212158203, 0.069766148924827575, 7200, 255, 1, 47213), -- Brazier (Area: -Unknown- - Difficulty: 23) +(@OGUID+14, 382512, 2526, 14032, 14033, '1,2,8,23', 0, 0, 1709.1458740234375, -3084.666748046875, 913.45587158203125, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 7200, 255, 1, 47213), -- Brazier (Area: -Unknown- - Difficulty: 23) +(@OGUID+15, 382518, 2526, 14032, 0, '1,2,8,23', 0, 0, 1717.59033203125, -3115.31591796875, 913.8204345703125, 1.649336218833923339, 0, 0, 0.734322547912597656, 0.678800702095031738, 7200, 255, 1, 47213), -- Brazier (Area: 0 - Difficulty: 23) +(@OGUID+16, 384370, 2526, 14032, 14037, '1,2,8,23', 0, 0, 1837.2725830078125, -3083.998291015625, 915.153564453125, 0, 0, 0, 0, 1, 7200, 255, 1, 47213), -- Deliberately Delinquent Notes (Area: -Unknown- - Difficulty: 23) +(@OGUID+17, 382492, 2526, 14032, 14037, '1,2,8,23', 0, 0, 1845.57470703125, -3153.548583984375, 921.33270263671875, 0.635207653045654296, 0, 0, 0.312291145324707031, 0.949986457824707031, 7200, 255, 1, 47213), -- Brazier (Area: -Unknown- - Difficulty: 23) +(@OGUID+18, 382503, 2526, 14032, 14037, '1,2,8,23', 0, 0, 1849.9583740234375, -3107.510498046875, 921.7188720703125, 3.506281137466430664, 0, 0, -0.98342132568359375, 0.181335359811782836, 7200, 255, 1, 47213), -- Brazier (Area: -Unknown- - Difficulty: 23) +(@OGUID+19, 382510, 2526, 14032, 14037, '1,2,8,23', 0, 0, 1841.560791015625, -3201.282958984375, 960.74285888671875, 1.160643696784973144, 0, 0, 0.548293113708496093, 0.83628624677658081, 7200, 255, 1, 47213), -- Brazier (Area: -Unknown- - Difficulty: 23) +(@OGUID+20, 382482, 2526, 14032, 0, '1,2,8,23', 0, 0, 2005.5711669921875, -2910.328125, 895.14306640625, 3.375383853912353515, 0, 0, -0.99317550659179687, 0.116629481315612792, 7200, 255, 1, 47213), -- Brazier (Area: 0 - Difficulty: 23) +(@OGUID+21, 382489, 2526, 14032, 0, '1,2,8,23', 0, 0, 2043.248291015625, -2897.307373046875, 895.615478515625, 4.204418182373046875, 0, 0, -0.8620920181274414, 0.506751775741577148, 7200, 255, 1, 47213), -- Brazier (Area: 0 - Difficulty: 23) +(@OGUID+22, 382486, 2526, 14032, 0, '1,2,8,23', 0, 0, 1948.736083984375, -2871.817626953125, 900.56036376953125, 4.701828479766845703, 0, 0, -0.7108306884765625, 0.70336318016052246, 7200, 255, 1, 47213), -- Brazier (Area: 0 - Difficulty: 23) +(@OGUID+23, 382478, 2526, 14032, 0, '1,2,8,23', 0, 0, 1947.99658203125, -2849.15283203125, 900.55596923828125, 4.815276145935058593, 0, 0, -0.66981124877929687, 0.742531359195709228, 7200, 255, 1, 47213), -- Brazier (Area: 0 - Difficulty: 23) +(@OGUID+24, 382494, 2526, 14032, 0, '1,2,8,23', 0, 0, 1834.0816650390625, -2851.16845703125, 900.54290771484375, 4.108412742614746093, 0, 0, -0.88541507720947265, 0.464801162481307983, 7200, 255, 1, 47213), -- Brazier (Area: 0 - Difficulty: 23) +(@OGUID+25, 382499, 2526, 14032, 0, '1,2,8,23', 0, 0, 1834.8629150390625, -2873.882080078125, 900.48773193359375, 4.108412742614746093, 0, 0, -0.88541507720947265, 0.464801162481307983, 7200, 255, 1, 47213), -- Brazier (Area: 0 - Difficulty: 23) +(@OGUID+26, 382524, 2526, 14032, 0, '1,2,8,23', 0, 0, 1766.3072509765625, -2876.569580078125, 905.8604736328125, 0.259961068630218505, 0, 0, 0.129614830017089843, 0.991564452648162841, 7200, 255, 1, 47213), -- Brazier (Area: 0 - Difficulty: 23) +(@OGUID+27, 382502, 2526, 14032, 0, '1,2,8,23', 0, 0, 1753.529541015625, -2858.28125, 905.81280517578125, 0.338501125574111938, 0, 0, 0.168443679809570312, 0.985711276531219482, 7200, 255, 1, 47213), -- Brazier (Area: 0 - Difficulty: 23) +(@OGUID+28, 382484, 2526, 14032, 14037, '1,2,8,23', 0, 0, 1602.7916259765625, -3118.1337890625, 946.95880126953125, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 7200, 255, 1, 47213); -- Brazier (Area: -Unknown- - Difficulty: 23) + +DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+28; +INSERT INTO `gameobject_addon` (`guid`, `parent_rotation0`, `parent_rotation1`, `parent_rotation2`, `parent_rotation3`, `WorldEffectID`, `AIAnimKitID`) VALUES +(@OGUID+0, 0, 0, -0.85760194063186645, 0.514313995838165283, 0, 0), -- Door +(@OGUID+16, 0, 0, 0, 1, 20744, 0); -- Deliberately Delinquent Notes + +DELETE FROM `gameobject_template_addon` WHERE `entry` IN (384370 /*Deliberately Delinquent Notes*/, 382475 /*Door*/, 382477 /*Door*/, 382476 /*Door*/, 378468 /*Door*/); +INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES +(384370, 0, 0, 20744, 0), -- Deliberately Delinquent Notes +(382475, 0, 48, 0, 0), -- Door +(382477, 0, 48, 0, 0), -- Door +(382476, 0, 48, 0, 0), -- Door +(378468, 0, 48, 0, 0); -- Door + +-- Waypoints +-- @CGUID+0 waypoints +SET @PATH := (@CGUID+0) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 2430.304, -2978.9307, 959.7348, NULL, 0), +(@PATH, 1, 2465.2761, -3004.3247, 959.7348, NULL, 0), +(@PATH, 2, 2476.9565, -3037.9775, 959.7348, NULL, 0), +(@PATH, 3, 2478.408, -3080.054, 959.7348, NULL, 0), +(@PATH, 4, 2431.804, -3117.7883, 959.7348, NULL, 0), +(@PATH, 5, 2404.6355, -3133.7153, 959.7348, NULL, 0), +(@PATH, 6, 2316.6025, -3137.2222, 959.7348, NULL, 0), +(@PATH, 7, 2249.861, -3102.2778, 959.7348, NULL, 0), +(@PATH, 8, 2242.6284, -3065.6233, 959.7348, NULL, 0), +(@PATH, 9, 2264.3281, -2991.8455, 959.7348, NULL, 0), +(@PATH, 10, 2305.4949, -2957.5364, 959.7348, NULL, 0), +(@PATH, 11, 2379.2847, -2959.3958, 959.7348, NULL, 0), +(@PATH, 12, 2396.427, -2962.1875, 959.7348, NULL, 0); +UPDATE `waypoint_data` SET `move_type`=2 WHERE `id`=@PATH; + +UPDATE `creature` SET `position_x`= 2430.304, `position_y`= -2978.9307, `position_z`= 959.7348, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+0; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+0; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+0, @PATH, 1); + +-- @CGUID+18 waypoints +SET @PATH := (@CGUID+18) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 1615.73, -2989.75, 900.16, NULL, 0), +(@PATH, 1, 1604.03, -2987.76, 899.95, NULL, 0), +(@PATH, 2, 1595.35, -2987.43, 899.942, NULL, 0), +(@PATH, 3, 1583.94, -2985.44, 899.944, NULL, 0), +(@PATH, 4, 1572.91, -2979.69, 899.947, NULL, 0), +(@PATH, 5, 1568.35, -2972.35, 899.944, NULL, 0), +(@PATH, 6, 1566.15, -2966.99, 899.944, NULL, 0), +(@PATH, 7, 1566.62, -2959.43, 899.944, NULL, 0), +(@PATH, 8, 1567.03, -2952.39, 899.944, NULL, 0), +(@PATH, 9, 1565.77, -2946.29, 899.944, NULL, 0), +(@PATH, 10, 1564.32, -2939.63, 899.944, NULL, 0), +(@PATH, 11, 1562.02, -2933.89, 900.183, NULL, 8000), +(@PATH, 12, 1560.93, -2936.99, 900.183, NULL, 0), +(@PATH, 13, 1563.18, -2942.23, 899.943, NULL, 0), +(@PATH, 14, 1565.11, -2949.85, 899.943, NULL, 0), +(@PATH, 15, 1565.89, -2956.28, 899.943, NULL, 0), +(@PATH, 16, 1566.78, -2960.59, 899.943, NULL, 0), +(@PATH, 17, 1567.66, -2968.66, 899.943, NULL, 0), +(@PATH, 18, 1570.21, -2975.66, 899.943, NULL, 0), +(@PATH, 19, 1575.54, -2981.29, 899.947, NULL, 0), +(@PATH, 20, 1580.86, -2984.12, 899.949, NULL, 0), +(@PATH, 21, 1590.26, -2987.04, 899.943, NULL, 0), +(@PATH, 22, 1599.77, -2987.9, 899.948, NULL, 0), +(@PATH, 23, 1607.77, -2988.34, 899.949, NULL, 0), +(@PATH, 24, 1615.5, -2988.01, 899.963, NULL, 0), +(@PATH, 25, 1619.57, -2989.59, 900.348, NULL, 0), +(@PATH, 26, 1623.23, -2991.63, 900.16, NULL, 0), +(@PATH, 27, 1626.87, -2994.7, 900.099, NULL, 8000), +(@PATH, 28, 1625.29, -2990.94, 900.057, NULL, 0), +(@PATH, 29, 1621.45, -2989.13, 900.478, NULL, 0); + +UPDATE `creature` SET `position_x`= 1615.73, `position_y`= -2989.75, `position_z`= 900.16, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+18; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+18; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+18, @PATH, 1); + +-- @CGUID+38 waypoints +SET @PATH := (@CGUID+38) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 1556.67, -2952.79, 899.944, NULL, 0), +(@PATH, 1, 1553.1, -2956.86, 899.944, NULL, 0), +(@PATH, 2, 1549.47, -2959.86, 899.944, NULL, 0), +(@PATH, 3, 1545.85, -2962.78, 899.944, NULL, 0), +(@PATH, 4, 1542.97, -2960.7, 899.95, NULL, 0), +(@PATH, 5, 1540.36, -2964.07, 900.193, NULL, 8000), +(@PATH, 6, 1542.36, -2964.31, 900.193, NULL, 0), +(@PATH, 7, 1544.54, -2962.68, 900.193, NULL, 0), +(@PATH, 8, 1545.46, -2960.17, 899.946, NULL, 0), +(@PATH, 9, 1547.77, -2961.03, 899.944, NULL, 0), +(@PATH, 10, 1552.12, -2958.36, 899.943, NULL, 0), +(@PATH, 11, 1554.28, -2954.07, 899.943, NULL, 0), +(@PATH, 12, 1560.59, -2948.37, 899.943, NULL, 0), +(@PATH, 13, 1565.95, -2941.95, 899.943, NULL, 0), +(@PATH, 14, 1573.59, -2933.73, 899.941, NULL, 0), +(@PATH, 15, 1581.67, -2928.82, 899.887, NULL, 0), +(@PATH, 16, 1590.65, -2927.02, 899.911, NULL, 0), +(@PATH, 17, 1598.74, -2926.5, 899.942, NULL, 0), +(@PATH, 18, 1603.71, -2926.64, 899.942, NULL, 0), +(@PATH, 19, 1607.1, -2928.84, 900.189, NULL, 0), +(@PATH, 20, 1610.08, -2931.37, 900.189, NULL, 8000), +(@PATH, 21, 1609.05, -2928.51, 900.19, NULL, 0), +(@PATH, 22, 1605.66, -2927.11, 900.035, NULL, 0), +(@PATH, 23, 1600.31, -2926.34, 899.944, NULL, 0), +(@PATH, 24, 1593.4, -2928.32, 899.934, NULL, 0), +(@PATH, 25, 1583.21, -2931.86, 899.91, NULL, 0), +(@PATH, 26, 1576.98, -2934.61, 899.935, NULL, 0), +(@PATH, 27, 1572.04, -2938.32, 899.941, NULL, 0), +(@PATH, 28, 1567.63, -2943.15, 899.941, NULL, 0), +(@PATH, 29, 1564.09, -2947.93, 899.941, NULL, 0); + +UPDATE `creature` SET `position_x`= 1556.67, `position_y`= -2952.79, `position_z`= 899.944, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+38; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+38; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+38, @PATH, 1); + +-- @CGUID+56 waypoints +SET @PATH := (@CGUID+56) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 1621.52, -2959.73, 899.947, NULL, 0), +(@PATH, 1, 1621.73, -2953.08, 899.951, NULL, 0), +(@PATH, 2, 1621.68, -2947.26, 899.951, NULL, 0), +(@PATH, 3, 1620.39, -2941.4, 899.951, NULL, 0), +(@PATH, 4, 1619.41, -2937.17, 899.951, NULL, 0), +(@PATH, 5, 1618.54, -2935.43, 900.162, NULL, 0), +(@PATH, 6, 1617.11, -2933.72, 900.19, NULL, 8000), +(@PATH, 7, 1613.81, -2936.99, 899.949, NULL, 0), +(@PATH, 8, 1616.64, -2938.83, 899.949, NULL, 0), +(@PATH, 9, 1618.42, -2942.5, 899.95, NULL, 0), +(@PATH, 10, 1621.96, -2948.96, 899.95, NULL, 0), +(@PATH, 11, 1624.53, -2953.92, 899.947, NULL, 0), +(@PATH, 12, 1626.89, -2960.46, 899.946, NULL, 0), +(@PATH, 13, 1628.45, -2966.01, 899.946, NULL, 0), +(@PATH, 14, 1634.28, -2974.39, 899.946, NULL, 0), +(@PATH, 15, 1638.99, -2976.79, 899.946, NULL, 0), +(@PATH, 16, 1642.97, -2977.45, 899.989, NULL, 0), +(@PATH, 17, 1647.31, -2976.39, 899.989, NULL, 8000), +(@PATH, 18, 1647.48, -2972.23, 899.989, NULL, 0), +(@PATH, 19, 1644.62, -2968.51, 899.989, NULL, 0), +(@PATH, 20, 1640.68, -2965.86, 899.945, NULL, 0), +(@PATH, 21, 1635.82, -2964.18, 899.946, NULL, 0), +(@PATH, 22, 1629.68, -2963.26, 899.946, NULL, 0), +(@PATH, 23, 1624.02, -2962.67, 899.946, NULL, 0); + +UPDATE `creature` SET `position_x`= 1621.52, `position_y`= -2959.73, `position_z`= 899.947, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+56; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+56; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+56, @PATH, 1); + +-- @CGUID+110 waypoints +SET @PATH := (@CGUID+110) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 1757.89, -3049.78, 914.589, NULL, 0), +(@PATH, 1, 1771.21, -3054.93, 914.17, NULL, 0), +(@PATH, 2, 1779.72, -3056.16, 915.047, NULL, 0), +(@PATH, 3, 1789.2, -3055.11, 915.298, NULL, 0), +(@PATH, 4, 1796.97, -3051.63, 914.103, NULL, 0), +(@PATH, 5, 1797.65, -3039.46, 913.956, NULL, 0), +(@PATH, 6, 1782.2, -3032.46, 914.724, NULL, 0), +(@PATH, 7, 1764.55, -3028.99, 914.821, NULL, 0), +(@PATH, 8, 1755.4, -3032.49, 915.326, NULL, 0), +(@PATH, 9, 1750.24, -3038.14, 914.729, NULL, 0), +(@PATH, 10, 1751.16, -3045.74, 914.687, NULL, 0); + +UPDATE `creature` SET `position_x`= 1757.89, `position_y`= -3049.78, `position_z`= 914.589, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+110; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+110; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+110, @PATH, 1); + +-- @CGUID+118 waypoints +SET @PATH := (@CGUID+118) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 1754.37, -3083.38, 913.575, NULL, 0), +(@PATH, 1, 1753.71, -3069.24, 913.627, NULL, 0), +(@PATH, 2, 1747.74, -3051.79, 914.035, NULL, 0), +(@PATH, 3, 1739.31, -3035.58, 913.623, NULL, 0), +(@PATH, 4, 1731.63, -3026.68, 913.61, NULL, 0), +(@PATH, 5, 1726.05, -3025.76, 914.296, NULL, 0), +(@PATH, 6, 1721.05, -3028.99, 914.419, NULL, 0), +(@PATH, 7, 1714.42, -3036.39, 913.587, NULL, 0), +(@PATH, 8, 1713.18, -3044.05, 913.577, NULL, 0), +(@PATH, 9, 1715.37, -3053.88, 913.577, NULL, 0), +(@PATH, 10, 1722.27, -3063.36, 913.577, NULL, 0), +(@PATH, 11, 1728.85, -3072.42, 913.577, NULL, 0), +(@PATH, 12, 1733.37, -3081.95, 913.577, NULL, 0), +(@PATH, 13, 1735.32, -3094.35, 913.577, NULL, 0), +(@PATH, 14, 1736.04, -3107.64, 914.128, NULL, 0), +(@PATH, 15, 1740.34, -3118.45, 913.606, NULL, 0), +(@PATH, 16, 1748.45, -3126.69, 913.509, NULL, 0), +(@PATH, 17, 1756.83, -3129.99, 914.404, NULL, 0), +(@PATH, 18, 1766.26, -3127.73, 913.444, NULL, 0), +(@PATH, 19, 1768.85, -3119.6, 913.458, NULL, 0), +(@PATH, 20, 1765.9, -3110.97, 913.568, NULL, 0), +(@PATH, 21, 1760.69, -3099.27, 913.574, NULL, 0); +UPDATE `waypoint_data` SET `move_type`=1 WHERE `id`=@PATH; + +UPDATE `creature` SET `position_x`= 1754.37, `position_y`= -3083.38, `position_z`= 913.575, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+118; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+118; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+118, @PATH, 1); + +DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+118; +INSERT INTO `creature_formations`(`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@CGUID+118, @CGUID+118, 0, 0, 515, 0, 0), +(@CGUID+118, @CGUID+111, 5, 45, 515, 0, 0), +(@CGUID+118, @CGUID+115, 5, 315, 515, 0, 0); + +-- @CGUID+123 waypoints +SET @PATH := (@CGUID+123) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 1824.68, -3082.65, 913.765, NULL, 0), +(@PATH, 1, 1822.86, -3074.33, 915.269, NULL, 0), +(@PATH, 2, 1813.55, -3070.04, 913.741, NULL, 0), +(@PATH, 3, 1803.06, -3069.01, 913.644, NULL, 0), +(@PATH, 4, 1795.31, -3077, 914.579, NULL, 0), +(@PATH, 5, 1787.97, -3088, 913.575, NULL, 0), +(@PATH, 6, 1780.03, -3095.76, 913.575, NULL, 0), +(@PATH, 7, 1769.71, -3103.23, 913.573, NULL, 0), +(@PATH, 8, 1756.63, -3105.85, 913.574, NULL, 0), +(@PATH, 9, 1745.52, -3113.7, 913.599, NULL, 0), +(@PATH, 10, 1744.91, -3122.57, 913.449, NULL, 0), +(@PATH, 11, 1753.26, -3129.38, 913.996, NULL, 0), +(@PATH, 12, 1769.86, -3128.76, 913.383, NULL, 0), +(@PATH, 13, 1784.83, -3136.95, 914.965, NULL, 0), +(@PATH, 14, 1791.7, -3147.93, 913.822, NULL, 0), +(@PATH, 15, 1796.04, -3157.8, 913.996, NULL, 0), +(@PATH, 16, 1805.84, -3162.34, 913.974, NULL, 0), +(@PATH, 17, 1814.51, -3151.06, 914.735, NULL, 0), +(@PATH, 18, 1818.57, -3136.9, 913.824, NULL, 0), +(@PATH, 19, 1820.23, -3121.94, 913.578, NULL, 0), +(@PATH, 20, 1820.17, -3110.72, 913.635, NULL, 0), +(@PATH, 21, 1820.08, -3095, 915.062, NULL, 0); +UPDATE `waypoint_data` SET `move_type`=1 WHERE `id`=@PATH; + +UPDATE `creature` SET `position_x`= 1824.68, `position_y`= -3082.65, `position_z`= 913.765, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+123; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+123; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+123, @PATH, 1); + +DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+123; +INSERT INTO `creature_formations`(`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@CGUID+123, @CGUID+123, 0, 0, 515, 0, 0), +(@CGUID+123, @CGUID+125, 5, 45, 515, 0, 0), +(@CGUID+123, @CGUID+126, 5, 315, 515, 0, 0); + +-- @CGUID+128 waypoints +SET @PATH := (@CGUID+128) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 1813.94, -3125.74, 913.762, NULL, 0), +(@PATH, 1, 1816.8, -3117.63, 913.578, NULL, 0), +(@PATH, 2, 1816.49, -3108.24, 913.577, NULL, 0), +(@PATH, 3, 1816.6, -3101.25, 914.423, NULL, 0), +(@PATH, 4, 1821.88, -3081.8, 913.938, NULL, 0), +(@PATH, 5, 1821.79, -3072.05, 915.39, NULL, 0), +(@PATH, 6, 1815.38, -3066.81, 913.684, NULL, 0), +(@PATH, 7, 1804.94, -3068.8, 913.634, NULL, 0), +(@PATH, 8, 1796.47, -3074.41, 914.674, NULL, 0), +(@PATH, 9, 1799.17, -3087.44, 914.644, NULL, 0), +(@PATH, 10, 1803.2, -3098.59, 913.584, NULL, 0), +(@PATH, 11, 1802.93, -3112.87, 913.577, NULL, 0), +(@PATH, 12, 1803.6, -3124.12, 913.721, NULL, 0), +(@PATH, 13, 1807.96, -3130.46, 914.966, NULL, 0); + +UPDATE `creature` SET `position_x`= 1813.94, `position_y`= -3125.74, `position_z`= 913.762, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+128; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+128; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+128, @PATH, 1); + +-- @CGUID+176 waypoints +SET @PATH := (@CGUID+176) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 1975.63, -2857.79, 895.795, NULL, 0), +(@PATH, 1, 1974.91, -2871.51, 895.492, NULL, 0), +(@PATH, 2, 1986.28, -2881.81, 896.043, NULL, 0), +(@PATH, 3, 1996.47, -2875.95, 896.763, NULL, 0), +(@PATH, 4, 1996.73, -2861.35, 896.753, NULL, 0), +(@PATH, 5, 1991.15, -2853.66, 896.412, NULL, 0), +(@PATH, 6, 1982.24, -2852.08, 895.947, NULL, 0); + +UPDATE `creature` SET `position_x`= 1975.63, `position_y`= -2857.79, `position_z`= 895.795, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+176; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+176; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+176, @PATH, 1); + +DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+176; +INSERT INTO `creature_formations`(`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@CGUID+176, @CGUID+176, 0, 0, 515, 0, 0), +(@CGUID+176, @CGUID+178, 4, 90, 515, 0, 0), +(@CGUID+176, @CGUID+177, 4, 270, 515, 0, 0); + +-- @CGUID+198 waypoints +SET @PATH := (@CGUID+198) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 1824.33, -2777.17, 903.437, NULL, 0), +(@PATH, 1, 1817.06, -2771.69, 903.437, NULL, 0), +(@PATH, 2, 1817.94, -2765.17, 903.437, NULL, 0), +(@PATH, 3, 1821.88, -2761.25, 903.437, NULL, 0), +(@PATH, 4, 1827.18, -2762.38, 903.438, NULL, 0), +(@PATH, 5, 1832.14, -2766.46, 903.438, NULL, 0), +(@PATH, 6, 1830.55, -2773.5, 903.438, NULL, 0); + +UPDATE `creature` SET `position_x`= 1824.33, `position_y`= -2777.17, `position_z`= 903.437, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+198; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+198; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+198, @PATH, 1); + +-- @CGUID+206 waypoints +SET @PATH := (@CGUID+206) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 1788.69, -2858.2, 900.009, NULL, 0), +(@PATH, 1, 1793.97, -2856.63, 900.02, NULL, 0), +(@PATH, 2, 1796.92, -2850.02, 900.015, NULL, 0), +(@PATH, 3, 1788.24, -2839.78, 899.997, NULL, 0), +(@PATH, 4, 1781.91, -2843.12, 899.997, NULL, 0), +(@PATH, 5, 1779.75, -2849.46, 899.997, NULL, 0), +(@PATH, 6, 1782.62, -2855.51, 899.997, NULL, 0), +(@PATH, 7, 1787.81, -2858.48, 900.005, NULL, 0); + +UPDATE `creature` SET `position_x`= 1788.69, `position_y`= -2858.2, `position_z`= 900.009, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+206; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+206; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+206, @PATH, 1); + +DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+206; +INSERT INTO `creature_formations`(`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@CGUID+206, @CGUID+206, 0, 0, 515, 0, 0), +(@CGUID+206, @CGUID+205, 4, 90, 515, 0, 0), +(@CGUID+206, @CGUID+203, 4, 270, 515, 0, 0); + +-- @CGUID+216 waypoints +SET @PATH := (@CGUID+216) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 1827.18, -2762.38, 903.438, NULL, 0), +(@PATH, 1, 1832.14, -2766.46, 903.438, NULL, 0), +(@PATH, 2, 1830.55, -2773.5, 903.438, NULL, 0), +(@PATH, 3, 1824.33, -2777.17, 903.437, NULL, 0), +(@PATH, 4, 1817.06, -2771.69, 903.437, NULL, 0), +(@PATH, 5, 1817.94, -2765.17, 903.437, NULL, 0), +(@PATH, 6, 1821.88, -2761.25, 903.437, NULL, 0); + +UPDATE `creature` SET `position_x`= 1827.18, `position_y`= -2762.38, `position_z`= 903.438, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+216; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+216; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+216, @PATH, 1); + +-- @CGUID+223 waypoints +SET @PATH := (@CGUID+223) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 1576.22, -3042.69, 940.416, NULL, 0), +(@PATH, 1, 1552.69, -3028.98, 940.417, NULL, 0), +(@PATH, 2, 1546.39, -3030.24, 940.417, NULL, 0), +(@PATH, 3, 1526.06, -3048.72, 940.417, NULL, 0), +(@PATH, 4, 1525.33, -3059.1, 940.417, NULL, 0), +(@PATH, 5, 1538.64, -3082.14, 940.417, NULL, 0), +(@PATH, 6, 1564.08, -3081.01, 940.417, NULL, 0), +(@PATH, 7, 1575.07, -3075.48, 940.417, NULL, 0), +(@PATH, 8, 1578.04, -3056.8, 940.417, NULL, 0), +(@PATH, 9, 1577.42, -3047.3, 940.417, NULL, 0); + +UPDATE `creature` SET `position_x`= 1576.22, `position_y`= -3042.69, `position_z`= 940.416, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+223; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+223; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+223, @PATH, 1); + +DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+223; +INSERT INTO `creature_formations`(`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@CGUID+223, @CGUID+223, 0, 0, 515, 0, 0), +(@CGUID+223, @CGUID+87, 4, 45, 515, 0, 0), +(@CGUID+223, @CGUID+224, 4, 315, 515, 0, 0); + +-- MISC creature related additions +DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (191736,196044,193033,197406,182599,182706,195569); +INSERT INTO `creature_template_movement` (`CreatureID`,`Ground`,`Swim`,`Flight`,`Rooted`,`Chase`,`Random`,`InteractionPauseTimer`) VALUES +(191736, 0, 0, 1, 0, 0, 0, 0), -- Crawth +(196044, 2, 0, 0, 0, 0, 0, 0), -- Unruly Textbook +(193033, 0, 0, 1, 1, 0, 0, 0), -- Spell Bunny +(197406, 2, 0, 0, 0, 0, 0, 0), -- Aggravated Skitterfly +(182599, 0, 0, 1, 0, 0, 0, 0), -- Dragonfly +(182706, 0, 0, 1, 0, 0, 0, 0), -- Butterfly +(195569, 0, 0, 1, 0, 0, 0, 0); -- Jump Pad Visual + +DELETE FROM `creature_template_addon` WHERE `entry` IN (196044 /*196044 (Unruly Textbook)*/, 196947 /*196947 (Goal of the Rushing Winds)*/, 193033 /*193033 (Spell Bunny)*/, 191610 /*191610 (Goal of the Searing Blaze)*/, 197406 /*197406 (Aggravated Skitterfly)*/, 191935 /*191935 (Koflo)*/, 191933 /*191933 (Malinor)*/, 191932 /*191932 (Dra'zish)*/, 191936 /*191936 (Dulox)*/, 182599 /*182599 (Dragonfly)*/, 196979 /*196979 (Green Dragonflight Recruiter)*/, 196981 /*196981 (Red Dragonflight Recruiter)*/, 182706 /*182706 (Butterfly)*/, 196482 /*196482 (Overgrown Ancient)*/, 190609 /*190609 (Echo of Doragosa)*/, 196978 /*196978 (Blue Dragonflight Recruiter)*/, 196974 /*196974 (Black Dragonflight Recruiter)*/, 189668 /*189668 (Professor Maxdormu)*/, 196977 /*196977 (Bronze Dragonflight Recruiter)*/, 195569 /*195569 (Jump Pad Visual)*/, 191736 /*191736 (Crawth)*/, 197398 /*Hungry Lasher*/); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(196044, 0, 0, 33554432, 1, 0, 0, 0, 0, 0, ''), -- 196044 (Unruly Textbook) +(196947, 0, 0, 0, 1, 0, 0, 0, 0, 4, ''), -- 196947 (Goal of the Rushing Winds) +(193033, 0, 0, 50331648, 1, 0, 0, 0, 0, 4, ''), -- 193033 (Spell Bunny) +(191610, 0, 0, 0, 1, 0, 0, 0, 0, 4, ''), -- 191610 (Goal of the Searing Blaze) +(197406, 0, 0, 33554432, 1, 0, 0, 0, 0, 0, ''), -- 197406 (Aggravated Skitterfly) +(191935, 0, 0, 0, 1, 0, 0, 0, 0, 4, ''), -- 191935 (Koflo) +(191933, 0, 0, 0, 1, 0, 0, 0, 0, 4, ''), -- 191933 (Malinor) +(191932, 0, 0, 0, 1, 0, 0, 0, 0, 4, ''), -- 191932 (Dra'zish) +(191936, 0, 0, 0, 1, 0, 0, 0, 0, 4, ''), -- 191936 (Dulox) +(182599, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- 182599 (Dragonfly) +(196979, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''), -- 196979 (Green Dragonflight Recruiter) +(196981, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''), -- 196981 (Red Dragonflight Recruiter) +(182706, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- 182706 (Butterfly) +(196482, 0, 0, 0, 1, 0, 0, 0, 0, 4, ''), -- 196482 (Overgrown Ancient) +(190609, 0, 0, 0, 1, 0, 0, 0, 0, 4, ''), -- 190609 (Echo of Doragosa) +(196978, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''), -- 196978 (Blue Dragonflight Recruiter) +(196974, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''), -- 196974 (Black Dragonflight Recruiter) +(189668, 0, 0, 0, 1, 0, 0, 0, 0, 4, ''), -- 189668 (Professor Maxdormu) +(196977, 0, 0, 0, 1, 0, 0, 0, 0, 3, ''), -- 196977 (Bronze Dragonflight Recruiter) +(195569, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- 195569 (Jump Pad Visual) +(191736, 0, 0, 50331648, 1, 0, 0, 0, 0, 5, ''), -- 191736 (Crawth) +(197398, 0, 0, 0, 1, 0, 0, 0, 0, 0, '390806 281206'); -- 197398 (Hungry Lasher) + +DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=23 AND `Entry` IN (182599,182706,196198)) OR (`DifficultyID`=0 AND `Entry` IN (191736,195564,195569)) OR (`DifficultyID`=2 AND `Entry` IN (3527,43499,47649,61245,63508,76168,95072,97285,100820,182599,182706,187287,189667,189668,190609,191610,191631,191750,191932,191933,191935,191936,192329,192333,192680,192864,193033,194181,195294,195416,195587,196044,196045,196143,196200,196202,196203,196482,196548,196576,196577,196642,196664,196671,196694,196798,196864,196865,196866,196868,196869,196947,196974,196977,196978,196979,196981,197219,197398,197406,197802,197882,197904,197905,199495,199496,199677)); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(182599, 23, 0, 0, 81, 47213), +(182706, 23, 0, 0, 81, 47213), +(191736, 0, 2, 2, 2157, 47213), +(195564, 0, 0, 0, 2157, 47213), +(195569, 0, 0, 0, 2157, 47213), +(196198, 23, 0, 0, 2157, 47213), +(3527, 2, 0, 0, 482, 47213), +(43499, 2, 0, 0, 482, 47213), +(47649, 2, 0, 0, 482, 47213), +(61245, 2, 0, 0, 482, 47213), +(63508, 2, 0, 0, 482, 47213), +(76168, 2, 0, 0, 482, 47213), +(95072, 2, 0, 0, 482, 47213), +(97285, 2, 0, 0, 482, 47213), +(100820, 2, 0, 0, 482, 47213), +(182599, 2, 0, 0, 81, 47213), +(182706, 2, 0, 0, 81, 47213), +(187287, 2, 0, 0, 2156, 47213), +(189667, 2, 0, 0, 2156, 47213), +(189668, 2, 0, 0, 2156, 47213), +(190609, 2, 2, 2, 2156, 47213), +(191610, 2, 0, 0, 2156, 47213), +(191631, 2, 0, 0, 2156, 47213), +(191750, 2, 0, 0, 2156, 47213), +(191932, 2, 0, 0, 2156, 47213), +(191933, 2, 0, 0, 2156, 47213), +(191935, 2, 0, 0, 2156, 47213), +(191936, 2, 0, 0, 2156, 47213), +(192329, 2, 0, 0, 2156, 47213), +(192333, 2, 1, 1, 2156, 47213), +(192680, 2, 1, 1, 2156, 47213), +(192864, 2, 0, 0, 2156, 47213), +(193033, 2, 0, 0, 2156, 47213), +(194181, 2, 2, 2, 2156, 47213), +(195294, 2, 0, 0, 81, 47213), +(195416, 2, 0, 0, 2156, 47213), +(195587, 2, 0, 0, 2156, 47213), +(196044, 2, 0, 0, 2156, 47213), +(196045, 2, 0, 0, 2156, 47213), +(196143, 2, 0, 0, 2552, 47213), +(196200, 2, 0, 0, 2156, 47213), +(196202, 2, 0, 0, 2156, 47213), +(196203, 2, 0, 0, 2156, 47213), +(196482, 2, 2, 2, 2156, 47213), +(196548, 2, 0, 0, 2156, 47213), +(196576, 2, 0, 0, 2156, 47213), +(196577, 2, 0, 0, 2156, 47213), +(196642, 2, 0, 0, 2156, 47213), +(196664, 2, 0, 0, 2156, 47213), +(196671, 2, 1, 1, 2156, 47213), +(196694, 2, 0, 0, 2156, 47213), +(196798, 2, 0, 0, 2156, 47213), +(196864, 2, 0, 0, 2156, 47213), +(196865, 2, 0, 0, 2156, 47213), +(196866, 2, 0, 0, 2156, 47213), +(196868, 2, 0, 0, 2156, 47213), +(196869, 2, 0, 0, 2156, 47213), +(196947, 2, 0, 0, 2156, 47213), +(196974, 2, 0, 0, 2156, 47213), +(196977, 2, 0, 0, 2156, 47213), +(196978, 2, 0, 0, 2156, 47213), +(196979, 2, 0, 0, 2156, 47213), +(196981, 2, 0, 0, 2156, 47213), +(197219, 2, 1, 1, 2156, 47213), +(197398, 2, 0, 0, 2156, 47213), +(197406, 2, 0, 0, 2156, 47213), +(197802, 2, 0, 0, 2156, 47213), +(197882, 2, 0, 0, 2156, 47213), +(197904, 2, 0, 0, 2156, 47213), +(197905, 2, 0, 0, 2156, 47213), +(199495, 2, 0, 0, 2156, 47213), +(199496, 2, 0, 0, 2156, 47213), +(199677, 2, 0, 0, 2156, 47213); + +UPDATE `creature_template_scaling` SET `VerifiedBuild`=47213 WHERE (`DifficultyID`=0 AND `Entry` IN (143622,171322,186404,192103,192684,192733,192857,195111,196000,197049,197062,197187,197468,198617)) OR (`DifficultyID`=23 AND `Entry` IN (187287,189667,189668,190609,191932,191933,191935,191936,195294,195416,195587,196045,196143,196200,196202,196203,196482,196576,196577,196671,196694,196798,196864,196865,196866,196868,196869,196974,196977,196978,196979,196981,197882,197904,199677)); +UPDATE `creature_template_scaling` SET `ContentTuningID`=2157, `VerifiedBuild`=47213 WHERE (`DifficultyID`=23 AND `Entry` IN (191610,192680,193033,196044,196947,197219,197398,197406,197802,197905)); +UPDATE `creature_template_scaling` SET `VerifiedBuild`=47213 WHERE (`DifficultyID`=2 AND `Entry` IN (62821,62822)); +UPDATE `creature_template_scaling` SET `ContentTuningID`=2156 WHERE (`DifficultyID`=0 AND `Entry` IN (191736,195564,195569)); + +UPDATE `creature_model_info` SET `VerifiedBuild`=47213 WHERE `DisplayID` IN (108826, 108830, 109308, 108831, 108833, 109246, 110795, 108829, 108027, 26385, 11686, 108026, 103845, 103843, 103762, 104635, 105451, 110646, 106048, 105401, 103844, 104474, 103841, 103842, 107525, 110721, 104043, 104044, 104568, 104563, 109104, 105791, 106088, 102690, 107060, 104275, 109105, 109106, 104042, 104377, 103811, 104040, 108058, 108062, 104041, 102765, 108059, 108060, 102202, 108932, 104045, 109194, 108925, 104317, 102329, 107061, 103053, 16925, 46710, 107996, 110805); +UPDATE `creature_model_info` SET `BoundingRadius`=1.284184455871582031, `VerifiedBuild`=47213 WHERE `DisplayID`=108642; +UPDATE `creature_model_info` SET `BoundingRadius`=1.201863050460815429, `VerifiedBuild`=47213 WHERE `DisplayID`=62384; +UPDATE `creature_model_info` SET `BoundingRadius`=0.384305894374847412, `VerifiedBuild`=47213 WHERE `DisplayID` IN (101136, 101134, 101137); +UPDATE `creature_model_info` SET `VerifiedBuild`=47213 WHERE `DisplayID` IN (106261, 107538, 33004, 39133, 34918, 66845, 66843, 66844, 109099, 30756, 56304, 14511, 42722, 42720, 30759); +UPDATE `creature_model_info` SET `BoundingRadius`=1.833205103874206542, `CombatReach`=4, `VerifiedBuild`=47213 WHERE `DisplayID` IN (102071, 101438); +UPDATE `creature_model_info` SET `BoundingRadius`=0.520500004291534423, `CombatReach`=3, `VerifiedBuild`=47213 WHERE `DisplayID`=107359; + +DELETE FROM `creature_model_info` WHERE `DisplayID`=109102; +INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES +(109102, 2.106381893157958984, 1.80000007152557373, 0, 47213); + +-- Creature Equip Template +DELETE FROM `creature_equip_template` WHERE (`ID`=1 AND `CreatureID` IN (196200,196202,196203,196576,196577,196864,197904,197905,196198)); +INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `AppearanceModID1`, `ItemVisual1`, `ItemID2`, `AppearanceModID2`, `ItemVisual2`, `ItemID3`, `AppearanceModID3`, `ItemVisual3`, `VerifiedBuild`) VALUES +(196200, 1, 191416, 0, 0, 0, 0, 0, 0, 0, 0, 47213), -- Algeth'ar Echoknight +(196202, 1, 192498, 0, 0, 0, 0, 0, 0, 0, 0, 47213), -- Spectral Invoker +(196203, 1, 191709, 0, 0, 192509, 0, 0, 0, 0, 0, 47213), -- Ethereal Restorer +(196576, 1, 192498, 0, 0, 0, 0, 0, 0, 0, 0, 47213), -- Spellbound Scepter +(196577, 1, 191416, 0, 0, 0, 0, 0, 0, 0, 0, 47213), -- Spellbound Battleaxe +(196864, 1, 192522, 0, 0, 0, 0, 0, 0, 0, 0, 47213), -- Red Dragonflight Alumni +(197904, 1, 191416, 0, 0, 0, 0, 0, 0, 0, 0, 47213), -- Spellbound Battleaxe +(197905, 1, 192498, 0, 0, 0, 0, 0, 0, 0, 0, 47213), -- Spellbound Scepter +(196198, 1, 191694, 0, 0, 193843, 0, 0, 0, 0, 0, 47213); -- Algeth'ar Security + +-- Creature template updates +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=190, `BaseAttackTime`=2000, `unit_flags`=33555200, `unit_flags2`=2048, `unit_flags3`=16777216 WHERE `entry`=199677; -- Teleporter Stalker +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32832, `unit_flags2`=2048 WHERE `entry` IN (197905, 196576); -- Spellbound Scepter +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=35, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags`=512, `unit_flags2`=34816 WHERE `entry`=195416; -- Magic Book +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32832, `unit_flags2`=2048 WHERE `entry` IN (196798, 196045); -- Corrupted Manafiend +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32832, `unit_flags2`=2048 WHERE `entry` IN (197904, 196577); -- Spellbound Battleaxe +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32832, `unit_flags2`=2048, `HoverHeight`=3 WHERE `entry`=196044; -- Unruly Textbook +UPDATE `creature_template` SET `minlevel`=71, `maxlevel`=71, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32832, `unit_flags2`=2048, `HoverHeight`=4.5 WHERE `entry`=196671; -- Arcane Ravager +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32832, `unit_flags2`=2048 WHERE `entry`=196694; -- Arcane Forager +UPDATE `creature_template` SET `faction`=190, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=195294; -- Beetle +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=190, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags2`=4196352 WHERE `entry`=196947; -- Goal of the Rushing Winds +UPDATE `creature_template` SET `minlevel`=71, `maxlevel`=71, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32832, `unit_flags2`=2048 WHERE `entry`=192680; -- Guardian Sentry +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=190, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags2`=4196352 WHERE `entry`=191610; -- Goal of the Searing Blaze +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33555200, `unit_flags2`=4196352 WHERE `entry`=193033; -- Spell Bunny +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=35, `npcflag`=16777216, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=197802; -- Well-Fed Duckling +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33280, `unit_flags2`=4196352 WHERE `entry`=191936; -- Dulox +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33280, `unit_flags2`=4196352 WHERE `entry`=191935; -- Koflo +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33280, `unit_flags2`=4196352 WHERE `entry`=191933; -- Malinor +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33280, `unit_flags2`=4196352 WHERE `entry`=191932; -- Dra'zish +UPDATE `creature_template` SET `minlevel`=71, `maxlevel`=71, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32832, `unit_flags2`=2048 WHERE `entry`=197219; -- Vile Lasher +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32832, `unit_flags2`=2080 WHERE `entry`=197398; -- Hungry Lasher +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32832, `unit_flags2`=2048 WHERE `entry`=196200; -- Algeth'ar Echoknight +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32832, `unit_flags2`=2080 WHERE `entry`=197406; -- Aggravated Skitterfly +UPDATE `creature_template` SET `faction`=188, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=182599; -- Dragonfly +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=33556480, `unit_flags3`=1048576 WHERE `entry`=196864; -- Red Dragonflight Alumni +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=196143; -- Green Dragonflight Alumni +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=187287; -- Professor Mystakria +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=196865; -- Red Dragonflight Alumni +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=189667; -- Professor Ichistrasz +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=196866; -- Blue Dragonflight Alumni +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32832, `unit_flags2`=2048 WHERE `entry`=196202; -- Spectral Invoker +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32832, `unit_flags2`=2048 WHERE `entry`=196203; -- Ethereal Restorer +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=196869; -- Black Dragonflight Alumni +UPDATE `creature_template` SET `gossip_menu_id`=29738, `minlevel`=70, `maxlevel`=70, `faction`=35, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2099200 WHERE `entry`=196979; -- Green Dragonflight Recruiter +UPDATE `creature_template` SET `gossip_menu_id`=29743, `minlevel`=70, `maxlevel`=70, `faction`=35, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2099200 WHERE `entry`=196981; -- Red Dragonflight Recruiter +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=196868; -- Bronze Dragonflight Alumni +UPDATE `creature_template` SET `faction`=188, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=182706; -- Butterfly +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=3276, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=197882; -- Dracthyr Freshscale +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=195587; -- Headteacher Doragosa +UPDATE `creature_template` SET `minlevel`=72, `maxlevel`=72, `faction`=16, `speed_walk`=1.20000004768371582, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags`=33600, `unit_flags2`=4194304, `VehicleId`=7976 WHERE `entry`=196482; -- Overgrown Ancient +UPDATE `creature_template` SET `gossip_menu_id`=29720, `minlevel`=70, `maxlevel`=70, `faction`=35, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2099200 WHERE `entry`=196974; -- Black Dragonflight Recruiter +UPDATE `creature_template` SET `gossip_menu_id`=29737, `minlevel`=70, `maxlevel`=70, `faction`=35, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2099200 WHERE `entry`=196978; -- Blue Dragonflight Recruiter +UPDATE `creature_template` SET `minlevel`=72, `maxlevel`=72, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32832, `unit_flags2`=4194304, `HoverHeight`=10 WHERE `entry`=190609; -- Echo of Doragosa +UPDATE `creature_template` SET `gossip_menu_id`=29736, `minlevel`=70, `maxlevel`=70, `faction`=35, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2099200 WHERE `entry`=196977; -- Bronze Dragonflight Recruiter +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=4196352 WHERE `entry`=189668; -- Professor Maxdormu +UPDATE `creature_template` SET `minlevel`=72, `maxlevel`=72, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=832, `unit_flags2`=1073743872 WHERE `entry`=191736; -- Crawth +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=35, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=67108864, `unit_flags3`=16777217 WHERE `entry`=195569; -- Jump Pad Visual +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=67108864, `unit_flags3`=16777217 WHERE `entry`=195564; -- Jump Pad +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33555200, `unit_flags2`=73402368, `unit_flags3`=16777216 WHERE `entry`=195111; -- Dragon Glyph +UPDATE `creature_template` SET `minlevel`=72, `maxlevel`=72, `faction`=3315, `BaseAttackTime`=2000, `unit_flags`=33536, `unit_flags2`=2099200 WHERE `entry`=196000; -- Vazallia +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=192684; -- Ravenous Riversnapper +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=3276, `BaseAttackTime`=2000, `unit_flags`=32832, `unit_flags2`=2099200, `HoverHeight`=10 WHERE `entry`=186404; -- Visiting Dragon +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=35, `npcflag`=3, `BaseAttackTime`=2000, `unit_flags`=33536, `unit_flags2`=2048, `HoverHeight`=10 WHERE `entry`=192733; -- Professor Dromokdormi +UPDATE `creature_template` SET `faction`=190, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=197049; -- Woolly Hare +UPDATE `creature_template` SET `faction`=190, `speed_walk`=0.400000005960464477, `speed_run`=0.214285716414451599, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=197062; -- Spotted Fritillary +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=3276, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=198617; -- Stubert Sealgager +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=3276, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=197187; -- Academy Chef +UPDATE `creature_template` SET `faction`=188, `speed_run`=0.857142865657806396, `BaseAttackTime`=2000, `unit_flags`=33280, `unit_flags2`=2048 WHERE `entry`=192103; -- Pricklefury Hare +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=3276, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=2048 WHERE `entry`=197468; -- Studious Scholar +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=3276, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=33024, `unit_flags2`=34816, `dynamicflags`=128 WHERE `entry`=192857; -- Dracthyr Freshscale +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `unit_flags3`=16777217 WHERE `entry`=171322; -- Global Affix Stalker +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32832, `unit_flags2`=2048 WHERE `entry`=196198; -- Algeth'ar Security + +-- npc_spellclick_spells (pick up ducklings) +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=197802; +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES +(197802, 392004, 1, 0); + +-- scene_template +DELETE FROM `scene_template` WHERE `SceneId`=3079; +INSERT INTO `scene_template` (`SceneId`, `Flags`, `ScriptPackageID`, `Encrypted`) VALUES +(3079, 16, 3695, 0); + +-- Gossips +DELETE FROM `npc_text` WHERE `ID` BETWEEN @NPCTEXTID+0 AND @NPCTEXTID+4; +INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES +(@NPCTEXTID+0, 1, 0, 0, 0, 0, 0, 0, 0, 230902, 0, 0, 0, 0, 0, 0, 0, 47213), -- 196977 (Bronze Dragonflight Recruiter) +(@NPCTEXTID+1, 1, 0, 0, 0, 0, 0, 0, 0, 230919, 0, 0, 0, 0, 0, 0, 0, 47213), -- 196978 (Blue Dragonflight Recruiter) +(@NPCTEXTID+2, 1, 0, 0, 0, 0, 0, 0, 0, 230929, 0, 0, 0, 0, 0, 0, 0, 47213), -- 196979 (Green Dragonflight Recruiter) +(@NPCTEXTID+3, 1, 0, 0, 0, 0, 0, 0, 0, 230952, 0, 0, 0, 0, 0, 0, 0, 47213), -- 196981 (Red Dragonflight Recruiter) +(@NPCTEXTID+4, 1, 0, 0, 0, 0, 0, 0, 0, 230847, 0, 0, 0, 0, 0, 0, 0, 47213); -- 196974 (Black Dragonflight Recruiter) + +DELETE FROM `gossip_menu` WHERE (`MenuID`=29736 AND `TextID`=@NPCTEXTID+0) OR (`MenuID`=29737 AND `TextID`=@NPCTEXTID+1) OR (`MenuID`=29738 AND `TextID`=@NPCTEXTID+2) OR (`MenuID`=29743 AND `TextID`=@NPCTEXTID+3) OR (`MenuID`=29720 AND `TextID`=@NPCTEXTID+4); +INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES +(29736, @NPCTEXTID+0, 47213), -- 196977 (Bronze Dragonflight Recruiter) +(29737, @NPCTEXTID+1, 47213), -- 196978 (Blue Dragonflight Recruiter) +(29738, @NPCTEXTID+2, 47213), -- 196979 (Green Dragonflight Recruiter) +(29743, @NPCTEXTID+3, 47213), -- 196981 (Red Dragonflight Recruiter) +(29720, @NPCTEXTID+4, 47213); -- 196974 (Black Dragonflight Recruiter) + +DELETE FROM `gossip_menu_option` WHERE (`OptionID`=0 AND `MenuID` IN (29720,29736,29737,29738,29743)); +INSERT INTO `gossip_menu_option` (`GossipOptionID`, `MenuID`, `OptionID`, `OptionNpc`, `OptionText`, `OptionBroadcastTextId`, `Language`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `SpellID`, `Flags`, `OverrideIconID`, `GossipNpcOptionID`, `VerifiedBuild`) VALUES +(107065, 29720, 0, 0, 'I wish to pledge to the Black Dragonflight. (Bestows a Critical Strike buff.)', 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 47213), +(107081, 29736, 0, 0, 'I wish to pledge to the Bronze Dragonflight. (Bestows a Haste buff.)', 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 47213), +(107082, 29737, 0, 0, 'I wish to pledge to the Blue Dragonflight. (Bestows a Mastery buff.)', 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 47213), +(107083, 29738, 0, 0, 'I wish to pledge to the Green Dragonflight. (Bestows a Healing Taken buff.)', 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 47213), +(107088, 29743, 0, 0, 'I wish to pledge to the Red Dragonflight. (Bestows a Versatility buff.)', 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 47213); |