diff options
| -rw-r--r-- | sql/updates/world/master/2022_02_14_00_world.sql | 44 | ||||
| -rw-r--r-- | sql/updates/world/master/2022_02_14_01_world.sql | 459 | ||||
| -rw-r--r-- | sql/updates/world/master/2022_02_14_02_world.sql | 62 |
3 files changed, 565 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_02_14_00_world.sql b/sql/updates/world/master/2022_02_14_00_world.sql new file mode 100644 index 00000000000..38fffafa400 --- /dev/null +++ b/sql/updates/world/master/2022_02_14_00_world.sql @@ -0,0 +1,44 @@ +SET @CGUID := 1050673; + +-- Creature Spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+20; +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, 168397, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4548.8203125, -4543.896484375, 6505.51513671875, 5.315079212188720703, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+1, 168502, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4517.55224609375, -4477.84033203125, 6499.1943359375, 3.626362562179565429, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Riverfall Snapper (Area: -Unknown- - Difficulty: 0) (Auras: 120703 - Cosmetic - Sleep Zzz Breakable) +(@CGUID+2, 168437, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4581.080078125, -4486.03515625, 6483.37939453125, 1.323262929916381835, 7200, 4, 0, 27, 0, 1, 0, 0, 0, 42010), -- Riverfall Hatchling (Area: -Unknown- - Difficulty: 0) +(@CGUID+3, 168502, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4562.7421875, -4482.61865234375, 6489.9892578125, 1.947251677513122558, 7200, 4, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Riverfall Snapper (Area: -Unknown- - Difficulty: 0) +(@CGUID+4, 168624, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4554.44580078125, -4509.3857421875, 6501.22314453125, 5.897574901580810546, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+5, 170399, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4525.22509765625, -4540.35107421875, 6515.6962890625, 5.648643016815185546, 7200, 3, 0, 2702, 0, 1, 0, 0, 0, 42010), -- Eternal Flutterer (Area: -Unknown- - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+6, 168437, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4560.14697265625, -4471.55908203125, 6491.5751953125, 2.378290414810180664, 7200, 4, 0, 27, 0, 1, 0, 0, 0, 42010), -- Riverfall Hatchling (Area: -Unknown- - Difficulty: 0) +(@CGUID+7, 170399, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4593.56396484375, -4453.86181640625, 6515.18603515625, 2.353317975997924804, 7200, 3, 0, 2702, 0, 1, 0, 0, 0, 42010), -- Eternal Flutterer (Area: -Unknown- - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+8, 168502, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4578.01123046875, -4473.8994140625, 6482.61767578125, 4.101346969604492187, 7200, 4, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Riverfall Snapper (Area: -Unknown- - Difficulty: 0) +(@CGUID+9, 170399, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4530.07470703125, -4557.78369140625, 6532.90478515625, 1.17114269733428955, 7200, 3, 0, 2702, 0, 1, 0, 0, 0, 42010), -- Eternal Flutterer (Area: -Unknown- - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+10, 168437, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4593.53515625, -4475.2060546875, 6483.12939453125, 0.62026369571685791, 7200, 4, 0, 27, 0, 1, 0, 0, 0, 42010), -- Riverfall Hatchling (Area: -Unknown- - Difficulty: 0) +(@CGUID+11, 170399, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4514.90087890625, -4486.02783203125, 6522.21337890625, 4.731200218200683593, 7200, 3, 0, 2702, 0, 1, 0, 0, 0, 42010), -- Eternal Flutterer (Area: -Unknown- - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+12, 170399, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4591.015625, -4522.5, 6498.501953125, 0, 7200, 3, 0, 2702, 0, 1, 0, 0, 0, 42010), -- Eternal Flutterer (Area: -Unknown- - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+13, 168502, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4591.1494140625, -4468.88916015625, 6483.86572265625, 5.225974082946777343, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Riverfall Snapper (Area: -Unknown- - Difficulty: 0) (Auras: 120703 - Cosmetic - Sleep Zzz Breakable) +(@CGUID+14, 168502, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4531.88427734375, -4484.33056640625, 6497.072265625, 1.632946729660034179, 7200, 4, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Riverfall Snapper (Area: -Unknown- - Difficulty: 0) +(@CGUID+15, 170399, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4516.0791015625, -4497.2783203125, 6518.74169921875, 1.478560686111450195, 7200, 3, 0, 2702, 0, 1, 0, 0, 0, 42010), -- Eternal Flutterer (Area: -Unknown- - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+16, 168502, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4567.7646484375, -4493.99169921875, 6490.42822265625, 0.996877312660217285, 7200, 4, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Riverfall Snapper (Area: -Unknown- - Difficulty: 0) +(@CGUID+17, 170399, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4582.982421875, -4528.3017578125, 6512.3046875, 5.081422805786132812, 7200, 3, 0, 2702, 0, 1, 0, 0, 0, 42010), -- Eternal Flutterer (Area: -Unknown- - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+18, 168502, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4599.580078125, -4464.455078125, 6483.86328125, 5.989694118499755859, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Riverfall Snapper (Area: -Unknown- - Difficulty: 0) (Auras: 120703 - Cosmetic - Sleep Zzz Breakable) +(@CGUID+19, 168437, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4522.7265625, -4481.349609375, 6497.072265625, 0.292805433273315429, 7200, 4, 0, 27, 0, 1, 0, 0, 0, 42010), -- Riverfall Hatchling (Area: -Unknown- - Difficulty: 0) +(@CGUID+20, 168502, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4590.06103515625, -4483.50830078125, 6483.12939453125, 3.439382553100585937, 7200, 4, 0, 6755, 0, 1, 0, 0, 0, 42010); -- Riverfall Snapper (Area: -Unknown- - Difficulty: 0) + +-- Creature Addon +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+20; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+18, 0, 0, 0, 1, 0, 0, 0, 0, 0, '120703'), +(@CGUID+13, 0, 0, 0, 1, 0, 0, 0, 0, 0, '120703'), +(@CGUID+1, 0, 0, 0, 1, 0, 0, 0, 0, 0, '120703'); + +-- Creature Movement +DELETE FROM `creature_template_movement` WHERE `CreatureId` = 170399; +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`) VALUES +(170399, 1, 0, 1, 0, 0, 0); + +-- SAI and Script for Riverfall Snapper +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry` = 168502; +DELETE FROM `smart_scripts` WHERE `entryorguid` = 168502 AND `source_type` = 0; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(168502, 0, 0, 0, 0, 0, 100, 0, 1000, 3000, 3000, 8000, 0, '', 11, 250208, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Riverfall Snapper - init. 1-3s and repeat every 3-8s - cast \"Snapping Bite\" 250208 - to Victim'); diff --git a/sql/updates/world/master/2022_02_14_01_world.sql b/sql/updates/world/master/2022_02_14_01_world.sql new file mode 100644 index 00000000000..88586235fd9 --- /dev/null +++ b/sql/updates/world/master/2022_02_14_01_world.sql @@ -0,0 +1,459 @@ +SET @CGUID := 1050694; + +-- Creature Spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+153; +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, 168613, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4080.814697265625, -4457.69287109375, 6686.052734375, 5.305948734283447265, 7200, 8, 0, 10133, 0, 1, 0, 0, 0, 42010), -- Aurumane Larion (Area: -Unknown- - Difficulty: 0) +(@CGUID+1, 168410, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4100.3076171875, -4482.5927734375, 6689.314453125, 5.105520248413085937, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+2, 168268, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4140.97900390625, -4526.205078125, 6694.5087890625, 0, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Spiritwing Glimmerfly (Area: -Unknown- - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+3, 168410, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4139.8076171875, -4492.03076171875, 6691.685546875, 6.034178733825683593, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+4, 156279, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4089.442626953125, -4658.13037109375, 6536.0849609375, 0, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- [DNT] FX Stalker (Area: -Unknown- - Difficulty: 0) +(@CGUID+5, 168410, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4215.619140625, -4510.57861328125, 6621.9072265625, 0.160640805959701538, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+6, 168397, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4086.4072265625, -4414.36669921875, 6679.7880859375, 0.787902235984802246, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+7, 168410, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4208.02685546875, -4422.8349609375, 6687.1240234375, 3.764792203903198242, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+8, 168268, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4171.7041015625, -4539.314453125, 6700.7763671875, 2.819690465927124023, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Spiritwing Glimmerfly (Area: -Unknown- - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+9, 168410, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4125.82568359375, -4385.859375, 6682.5029296875, 2.060638904571533203, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+10, 168397, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4144.98583984375, -4524.98193359375, 6694.46630859375, 4.653726100921630859, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+11, 156279, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4087.114501953125, -4636.283203125, 6536.0849609375, 0, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- [DNT] FX Stalker (Area: -Unknown- - Difficulty: 0) +(@CGUID+12, 168624, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4226.75732421875, -4432.4169921875, 6687.28076171875, 4.713216304779052734, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+13, 171664, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4227.36279296875, -4440.41162109375, 6687.84033203125, 0.996037602424621582, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Fluttering Glimmerfly (Area: -Unknown- - Difficulty: 0) (Auras: 308853 - -Unknown-) +(@CGUID+14, 156279, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4111.71875, -4629.0400390625, 6536.0849609375, 0, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- [DNT] FX Stalker (Area: -Unknown- - Difficulty: 0) +(@CGUID+15, 168613, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4134.80615234375, -4429.3046875, 6689.3408203125, 1.882242202758789062, 7200, 6, 0, 10133, 0, 1, 0, 0, 0, 42010), -- Aurumane Larion (Area: -Unknown- - Difficulty: 0) +(@CGUID+16, 168624, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4165.4013671875, -4459.0712890625, 6691.31103515625, 3.177806854248046875, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+17, 171664, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4103.82177734375, -4571.35400390625, 6546.67529296875, 6.000770092010498046, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Fluttering Glimmerfly (Area: -Unknown- - Difficulty: 0) (Auras: 308853 - -Unknown-) +(@CGUID+18, 168410, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4072.245361328125, -4419.60205078125, 6680.36181640625, 1.382093191146850585, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+19, 168624, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4156.9326171875, -4391.59814453125, 6681.2744140625, 3.499139070510864257, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+20, 168397, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4183.74755859375, -4500.67822265625, 6694.5302734375, 1.795969486236572265, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+21, 168624, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4140.7041015625, -4489.2744140625, 6692.49365234375, 5.191266536712646484, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+22, 168410, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4183.44189453125, -4489.68505859375, 6692.77099609375, 2.537175178527832031, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+23, 168410, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4114.080078125, -4462.1611328125, 6686.421875, 2.643024682998657226, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+24, 156279, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4116.08349609375, -4652.83154296875, 6536.0849609375, 0, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- [DNT] FX Stalker (Area: -Unknown- - Difficulty: 0) +(@CGUID+25, 168410, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4154.44384765625, -4403.31591796875, 6683.3759765625, 1.206477642059326171, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+26, 168268, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4113.7724609375, -4490.5869140625, 6693.5576171875, 2.871495962142944335, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Spiritwing Glimmerfly (Area: -Unknown- - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+27, 168617, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4186.4990234375, -4465.6103515625, 6692.90087890625, 1.861582636833190917, 7200, 0, 0, 50663, 0, 0, 0, 0, 0, 42010), -- Aurumane Patriarch (Area: -Unknown- - Difficulty: 0) +(@CGUID+28, 168268, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4087.489013671875, -4412.46875, 6685.341796875, 2.87274932861328125, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Spiritwing Glimmerfly (Area: -Unknown- - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+29, 168268, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4165.07177734375, -4401.1630859375, 6686.1181640625, 5.732340812683105468, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Spiritwing Glimmerfly (Area: -Unknown- - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+30, 168624, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4133.05224609375, -4551.9892578125, 6691.59423828125, 3.674165964126586914, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+31, 168410, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4164.619140625, -4458.6171875, 6690.33447265625, 4.588882923126220703, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+32, 168410, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4101.02099609375, -4426.10107421875, 6682.35693359375, 2.321812152862548828, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+33, 168613, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4127.3388671875, -4453.5234375, 6689.26416015625, 4.279299736022949218, 7200, 6, 0, 10133, 0, 1, 0, 0, 0, 42010), -- Aurumane Larion (Area: -Unknown- - Difficulty: 0) +(@CGUID+34, 168397, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4111.51611328125, -4487.0009765625, 6690.01513671875, 0.781806588172912597, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+35, 168268, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4134.37890625, -4366.4150390625, 6675.9072265625, 6.013096809387207031, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Spiritwing Glimmerfly (Area: -Unknown- - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+36, 168397, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4132.748046875, -4361.87646484375, 6673.2548828125, 0.1590462327003479, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+37, 168268, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4043.08447265625, -4431.39794921875, 6679.533203125, 3.084458112716674804, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Spiritwing Glimmerfly (Area: -Unknown- - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+38, 171668, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4047.446044921875, -4442.2939453125, 6675.90576171875, 5.527765274047851562, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Vibrant Glimmerfly (Area: -Unknown- - Difficulty: 0) (Auras: 308853 - -Unknown-) +(@CGUID+39, 168410, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4159.72998046875, -4381.970703125, 6678.6943359375, 0.235851228237152099, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+40, 168397, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4211.2392578125, -4406.5966796875, 6683.36083984375, 2.844062089920043945, 7200, 0, 3, 5, 0, 0, 1, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+41, 168624, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4069.586181640625, -4390.45849609375, 6675.02197265625, 2.246492385864257812, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+42, 168731, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4065.475830078125, -4386.44775390625, 6672.98046875, 1.214982509613037109, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Copperfur Lurker (Area: -Unknown- - Difficulty: 0) (Auras: 125567 - Cosmetic - Sleep Zzz - Small Zs) +(@CGUID+43, 168731, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4082.7734375, -4399.482421875, 6677.92041015625, 2.33409881591796875, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Copperfur Lurker (Area: -Unknown- - Difficulty: 0) +(@CGUID+44, 168613, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4187.38232421875, -4384.81298828125, 6679.2578125, 5.85878610610961914, 7200, 8, 0, 10133, 0, 1, 0, 0, 0, 42010), -- Aurumane Larion (Area: -Unknown- - Difficulty: 0) +(@CGUID+45, 168410, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4148.67822265625, -4344.27783203125, 6667.7783203125, 1.721811652183532714, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+46, 168397, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4036.97802734375, -4471.7685546875, 6676.123046875, 3.708130836486816406, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+47, 168268, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4042.91552734375, -4464.41552734375, 6680.78857421875, 3.48441171646118164, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Spiritwing Glimmerfly (Area: -Unknown- - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+48, 168733, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4103.89111328125, -4315.345703125, 6656.4677734375, 5.506074428558349609, 7200, 3, 0, 27, 0, 1, 0, 0, 0, 42010), -- Copperfur Kit (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+49, 168733, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4018.924560546875, -4376.60595703125, 6668.15380859375, 1.090991139411926269, 7200, 3, 0, 27, 0, 1, 0, 0, 0, 42010), -- Copperfur Kit (Area: -Unknown- - Difficulty: 0) +(@CGUID+50, 173115, 2222, 10534, 13376, '0', 0, 0, 0, 0, -3731.015625, -4298.4912109375, 6734.8173828125, 5.717256546020507812, 7200, 0, 0, 266963, 2041, 0, 0, 0, 0, 42010), -- Depleted Guardian (Area: -Unknown- - Difficulty: 0) (Auras: 320712 - -Unknown-, 314629 - -Unknown-) +(@CGUID+51, 168731, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4008.806640625, -4378.5625, 6667.06005859375, 5.989857673645019531, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Copperfur Lurker (Area: -Unknown- - Difficulty: 0) +(@CGUID+52, 168733, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4045.72607421875, -4367.4296875, 6669.6611328125, 4.829652786254882812, 7200, 3, 0, 27, 0, 1, 0, 0, 0, 42010), -- Copperfur Kit (Area: -Unknown- - Difficulty: 0) +(@CGUID+53, 168731, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4018.23095703125, -4398.3173828125, 6670.07275390625, 0.244505181908607482, 7200, 4, 0, 5404, 0, 1, 0, 0, 0, 42010), -- Copperfur Lurker (Area: -Unknown- - Difficulty: 0) +(@CGUID+54, 168397, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4097.0234375, -4322.49365234375, 6660.1552734375, 3.952785491943359375, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+55, 168733, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4012.865234375, -4373.318359375, 6666.93505859375, 4.899057388305664062, 7200, 3, 0, 27, 0, 1, 0, 0, 0, 42010), -- Copperfur Kit (Area: -Unknown- - Difficulty: 0)) +(@CGUID+56, 168624, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4040.265625, -4348.2705078125, 6665.931640625, 6.157701492309570312, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+57, 168410, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4019.651123046875, -4454.98486328125, 6675.6669921875, 0.353123992681503295, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+58, 168624, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4012.11474609375, -4384.619140625, 6669.38671875, 5.925005435943603515, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+59, 168638, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4067.28662109375, -4332.41552734375, 6667.1083984375, 5.40512704849243164, 7200, 6, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Wild Cloudracer (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+60, 168731, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4046.197998046875, -4361.22216796875, 6667.89306640625, 4.918170928955078125, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Copperfur Lurker (Area: -Unknown- - Difficulty: 0) (Auras: 125567 - Cosmetic - Sleep Zzz - Small Zs) +(@CGUID+61, 168397, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4009.20166015625, -4355.029296875, 6661.95068359375, 3.27131962776184082, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+62, 168397, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4087.75732421875, -4310.3623046875, 6656.5556640625, 4.87207794189453125, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+63, 168731, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4008.869873046875, -4373.40478515625, 6666.30908203125, 3.195556163787841796, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Copperfur Lurker (Area: -Unknown- - Difficulty: 0) (Auras: 125567 - Cosmetic - Sleep Zzz - Small Zs) +(@CGUID+64, 168397, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4041.183837890625, -4364.498046875, 6669.7783203125, 1.798328995704650878, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+65, 168410, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4142.0556640625, -4416.07666015625, 6688.23681640625, 1.197551369667053222, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+66, 168397, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4045.569091796875, -4290.0419921875, 6645.5107421875, 3.316169500350952148, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+67, 168410, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4025.01708984375, -4318.1376953125, 6653.435546875, 4.657649517059326171, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+68, 168731, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4093.104248046875, -4294.94384765625, 6647.4931640625, 1.222773194313049316, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Copperfur Lurker (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+69, 168731, 2222, 10534, 13376, '0', 0, 0, 0, 0, -3992.14111328125, -4357.904296875, 6661.462890625, 0.264881253242492675, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Copperfur Lurker (Area: -Unknown- - Difficulty: 0) +(@CGUID+70, 171664, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4012.32666015625, -4315.5712890625, 6650.1982421875, 4.788765430450439453, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Fluttering Glimmerfly (Area: -Unknown- - Difficulty: 0) (Auras: 308853 - -Unknown-) +(@CGUID+71, 168397, 2222, 10534, 13376, '0', 0, 0, 0, 0, -3990.294921875, -4364.9853515625, 6665.15576171875, 0.533953726291656494, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+72, 168359, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4059.697021484375, -4258.0478515625, 6634.22314453125, 3.178157806396484375, 7200, 10, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Swift Skymane (Area: -Unknown- - Difficulty: 0) +(@CGUID+73, 168410, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4083.433837890625, -4275.7392578125, 6641.666015625, 5.11830759048461914, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+74, 168624, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4063.250732421875, -4260.025390625, 6635.7724609375, 3.615709304809570312, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+75, 168359, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4007.182861328125, -4258.5361328125, 6635, 1.957470893859863281, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Swift Skymane (Area: -Unknown- - Difficulty: 0) +(@CGUID+76, 168410, 2222, 10534, 13376, '0', 0, 0, 0, 0, -3986.358642578125, -4284.81689453125, 6644.2626953125, 1.234213709831237792, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+77, 168638, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4003.4873046875, -4266.29296875, 6637.91552734375, 2.103510856628417968, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Wild Cloudracer (Area: -Unknown- - Difficulty: 0) +(@CGUID+78, 168638, 2222, 10534, 13376, '0', 0, 0, 0, 0, -3959.6357421875, -4290.34912109375, 6651.7041015625, 4.89102029800415039, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Wild Cloudracer (Area: -Unknown- - Difficulty: 0) +(@CGUID+79, 156279, 2222, 10534, 13376, '0', 0, 0, 0, 0, -3881.604248046875, -4194.21875, 6609.7646484375, 0.775802254676818847, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- [DNT] FX Stalker (Area: -Unknown- - Difficulty: 0) (Auras: 346988 - -Unknown-) +(@CGUID+80, 168359, 2222, 10534, 13376, '0', 0, 0, 0, 0, -3997.29345703125, -4227.07666015625, 6621.9619140625, 0.02021871879696846, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Swift Skymane (Area: -Unknown- - Difficulty: 0) +(@CGUID+81, 168634, 2222, 10534, 13376, '0', 0, 0, 0, 0, -3985.519775390625, -4198.4921875, 6689.01318359375, 1.341972589492797851, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Soulwing Glimmerfly (Area: -Unknown- - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+82, 168915, 2222, 10534, 13376, '0', 0, 0, 0, 0, -3905.092041015625, -4241.75732421875, 6712.5771484375, 0.007812341209501028, 7200, 8, 0, 5, 0, 1, 0, 0, 0, 42010), -- Field Everhopper (Area: -Unknown- - Difficulty: 0) +(@CGUID+83, 168624, 2222, 10534, 13376, '0', 0, 0, 0, 0, -3942.9150390625, -4215.98193359375, 6698.61181640625, 1.452106356620788574, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+84, 168887, 2222, 10534, 13376, '0', 0, 0, 0, 0, -3949.78466796875, -4206.86962890625, 6691.79296875, 1.224472403526306152, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Gilded Cloudstrider (Area: -Unknown- - Difficulty: 0) +(@CGUID+85, 168397, 2222, 10534, 13376, '0', 0, 0, 0, 0, -3979.967529296875, -4202.04248046875, 6685.4189453125, 3.43096780776977539, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+86, 168624, 2222, 10534, 13376, '0', 0, 0, 0, 0, -3900.384033203125, -4269.509765625, 6716.26416015625, 2.232235908508300781, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+87, 168919, 2222, 10534, 13376, '0', 0, 0, 0, 0, -3929.7373046875, -4209.490234375, 6700.51953125, 3.523164272308349609, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Elysian Owl (Area: -Unknown- - Difficulty: 0) +(@CGUID+88, 168397, 2222, 10534, 13376, '0', 0, 0, 0, 0, -3946.802001953125, -4190.1181640625, 6685.69677734375, 5.311147689819335937, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+89, 171664, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4074.497802734375, -4213.171875, 6616.75341796875, 4.694667339324951171, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Fluttering Glimmerfly (Area: -Unknown- - Difficulty: 0) (Auras: 308853 - -Unknown-) (possible waypoints or random movement) +(@CGUID+90, 168397, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4053.493408203125, -4209.1044921875, 6614.62158203125, 2.638566493988037109, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+91, 168624, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4091.142578125, -4170.83447265625, 6586.82177734375, 3.015537023544311523, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+92, 168359, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4108.8935546875, -4200.671875, 6593.9072265625, 0.018588857725262641, 7200, 10, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Swift Skymane (Area: -Unknown- - Difficulty: 0) +(@CGUID+93, 168624, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4089.0546875, -4186.65185546875, 6590.4921875, 4.273965835571289062, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+94, 168434, 2222, 10534, 13376, '0', 0, 0, 0, 0, -4062.864501953125, -4143.90087890625, 6553.95849609375, 1.498490452766418457, 7200, 0, 0, 33775, 0, 0, 0, 0, 0, 42010), -- Riverfall Crystalback (Area: -Unknown- - Difficulty: 0) (Auras: 350558 - -Unknown-) +(@CGUID+95, 168410, 2222, 10534, 0, '0', 0, 0, 0, 0, -4148.99755859375, -4201.017578125, 6593.18115234375, 4.881068229675292968, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+96, 168359, 2222, 10534, 0, '0', 0, 0, 0, 0, -4123.64453125, -4148.18212890625, 6577.2587890625, 3.000524044036865234, 7200, 4, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Swift Skymane (Area: 0 - Difficulty: 0) +(@CGUID+97, 168397, 2222, 10534, 0, '0', 0, 0, 0, 0, -4085.13037109375, -4137.1591796875, 6569.923828125, 3.491738080978393554, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: 0 - Difficulty: 0) +(@CGUID+98, 168268, 2222, 10534, 0, '0', 0, 0, 0, 0, -4094.376953125, -4131.91845703125, 6578.39990234375, 5.525578498840332031, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Spiritwing Glimmerfly (Area: 0 - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+99, 171668, 2222, 10534, 0, '0', 0, 0, 0, 0, -4105.966796875, -4125.07421875, 6575.52001953125, 6.154389858245849609, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Vibrant Glimmerfly (Area: 0 - Difficulty: 0) (Auras: 308853 - -Unknown-) +(@CGUID+100, 168624, 2222, 10534, 0, '0', 0, 0, 0, 0, -4079.62109375, -4121.42138671875, 6572.0947265625, 5.811511039733886718, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: 0 - Difficulty: 0) +(@CGUID+101, 168359, 2222, 10534, 0, '0', 0, 0, 0, 0, -4148.73486328125, -4170.30078125, 6582.7265625, 5.65596628189086914, 7200, 6, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Swift Skymane (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+102, 168410, 2222, 10534, 0, '0', 0, 0, 0, 0, -4105.3310546875, -4111.89013671875, 6562.73828125, 5.519883155822753906, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: 0 - Difficulty: 0) +(@CGUID+103, 168428, 2222, 10534, 0, '0', 0, 0, 0, 0, -4066.65673828125, -4091.968994140625, 6544.84423828125, 5.576462745666503906, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Riverfall Terrapin (Area: 0 - Difficulty: 0) +(@CGUID+104, 168731, 2222, 10534, 0, '0', 0, 0, 0, 0, -4145.62841796875, -4141.12158203125, 6571.67822265625, 2.722748756408691406, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Copperfur Lurker (Area: 0 - Difficulty: 0) (Auras: 159510 - Cosmetic - Sleep Zzz Breakable) +(@CGUID+105, 168397, 2222, 10534, 0, '0', 0, 0, 0, 0, -3997.68701171875, -4126.03466796875, 6578.7744140625, 4.665620803833007812, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 42010), -- Soulwing Flitter (Area: 0 - Difficulty: 0) +(@CGUID+106, 168437, 2222, 10534, 0, '0', 0, 0, 0, 0, -4063.441162109375, -4089.455322265625, 6543.873046875, 5.446656227111816406, 7200, 4, 0, 27, 0, 1, 0, 0, 0, 42010), -- Riverfall Hatchling (Area: 0 - Difficulty: 0) +(@CGUID+107, 168438, 2222, 10534, 0, '0', 0, 0, 0, 0, -4058.4365234375, -4099.90283203125, 6541.71875, 4.802236557006835937, 7200, 4, 0, 13510, 0, 1, 0, 0, 0, 42010), -- Riverfall Scaleback (Area: 0 - Difficulty: 0) +(@CGUID+108, 168437, 2222, 10534, 0, '0', 0, 0, 0, 0, -4036.05029296875, -4106.2177734375, 6557.28076171875, 3.163074016571044921, 7200, 4, 0, 27, 0, 1, 0, 0, 0, 42010), -- Riverfall Hatchling (Area: 0 - Difficulty: 0) +(@CGUID+109, 168428, 2222, 10534, 0, '0', 0, 0, 0, 0, -4036.29150390625, -4099.791015625, 6554.65771484375, 3.864830493927001953, 7200, 4, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Riverfall Terrapin (Area: 0 - Difficulty: 0) +(@CGUID+110, 168634, 2222, 10534, 0, '0', 0, 0, 0, 0, -3997.000732421875, -4118.76416015625, 6577.76123046875, 0.589517593383789062, 7200, 3, 0, 5404, 0, 1, 0, 0, 0, 42010), -- Soulwing Glimmerfly (Area: 0 - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+111, 168634, 2222, 10534, 0, '0', 0, 0, 0, 0, -3992.404052734375, -4098.20361328125, 6567.13916015625, 5.399653434753417968, 7200, 3, 0, 5404, 0, 1, 0, 0, 0, 42010), -- Soulwing Glimmerfly (Area: 0 - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+112, 168437, 2222, 10534, 0, '0', 0, 0, 0, 0, -4062.151611328125, -4066.31005859375, 6532.89453125, 0.970656216144561767, 7200, 4, 0, 27, 0, 1, 0, 0, 0, 42010), -- Riverfall Hatchling (Area: 0 - Difficulty: 0) +(@CGUID+113, 168428, 2222, 10534, 0, '0', 0, 0, 0, 0, -4042.044677734375, -4068.427978515625, 6529.8203125, 1.260457158088684082, 7200, 4, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Riverfall Terrapin (Area: 0 - Difficulty: 0) +(@CGUID+114, 168428, 2222, 10534, 0, '0', 0, 0, 0, 0, -4060.76611328125, -4071.14697265625, 6531.91162109375, 2.723368406295776367, 7200, 4, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Riverfall Terrapin (Area: 0 - Difficulty: 0) +(@CGUID+115, 168397, 2222, 10534, 0, '0', 0, 0, 0, 0, -3982.31982421875, -4109.91552734375, 6574.1025390625, 3.577605724334716796, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: 0 - Difficulty: 0) +(@CGUID+116, 168428, 2222, 10534, 0, '0', 0, 0, 0, 0, -4056.032958984375, -4087.96875, 6543.115234375, 0, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Riverfall Terrapin (Area: 0 - Difficulty: 0) (Auras: 350558 - -Unknown-) +(@CGUID+117, 168887, 2222, 10534, 0, '0', 0, 0, 0, 0, -4000, -4096.875, 6558.08837890625, 4.54224395751953125, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Gilded Cloudstrider (Area: 0 - Difficulty: 0) +(@CGUID+118, 168397, 2222, 10534, 0, '0', 0, 0, 0, 0, -4143.52880859375, -4120.9970703125, 6571.40087890625, 0.057498626410961151, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: 0 - Difficulty: 0) +(@CGUID+119, 168624, 2222, 10534, 0, '0', 0, 0, 0, 0, -4074.023681640625, -4085.820556640625, 6548.5029296875, 4.939455986022949218, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: 0 - Difficulty: 0) +(@CGUID+120, 168731, 2222, 10534, 0, '0', 0, 0, 0, 0, -4148.9326171875, -4118.80078125, 6567.337890625, 5.176036834716796875, 7200, 4, 0, 5404, 0, 1, 0, 0, 0, 42010), -- Copperfur Lurker (Area: 0 - Difficulty: 0) +(@CGUID+121, 168887, 2222, 10534, 0, '0', 0, 0, 0, 0, -4009.34619140625, -4061.09423828125, 6543.4296875, 1.789253473281860351, 7200, 6, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Gilded Cloudstrider (Area: 0 - Difficulty: 0) +(@CGUID+122, 168359, 2222, 10534, 0, '0', 0, 0, 0, 0, -4085.58837890625, -4057.81298828125, 6539.931640625, 0.559084475040435791, 7200, 4, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Swift Skymane (Area: 0 - Difficulty: 0) +(@CGUID+123, 168437, 2222, 10534, 0, '0', 0, 0, 0, 0, -4033.333984375, -4064.583984375, 6532.6884765625, 6.226104736328125, 7200, 4, 0, 27, 0, 1, 0, 0, 0, 42010), -- Riverfall Hatchling (Area: 0 - Difficulty: 0) +(@CGUID+124, 168359, 2222, 10534, 0, '0', 0, 0, 0, 0, -4127.53466796875, -4078.7900390625, 6552.89208984375, 5.611253738403320312, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Swift Skymane (Area: 0 - Difficulty: 0) +(@CGUID+125, 168410, 2222, 10534, 0, '0', 0, 0, 0, 0, -4101.68798828125, -4057.05419921875, 6543.62744140625, 3.62097334861755371, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: 0 - Difficulty: 0) +(@CGUID+126, 168410, 2222, 10534, 0, '0', 0, 0, 0, 0, -3995.6826171875, -4071.87646484375, 6550.09765625, 1.704073548316955566, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: 0 - Difficulty: 0) +(@CGUID+127, 168887, 2222, 10534, 0, '0', 0, 0, 0, 0, -3971.25927734375, -4091.588134765625, 6567.18310546875, 0.373619943857192993, 7200, 6, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Gilded Cloudstrider (Area: 0 - Difficulty: 0) +(@CGUID+128, 168397, 2222, 10534, 0, '0', 0, 0, 0, 0, -4148.39306640625, -4098.34130859375, 6562.71044921875, 4.980228900909423828, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: 0 - Difficulty: 0) +(@CGUID+129, 168887, 2222, 10534, 0, '0', 0, 0, 0, 0, -4000, -4050, 6543.91748046875, 1.399861812591552734, 7200, 6, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Gilded Cloudstrider (Area: 0 - Difficulty: 0) +(@CGUID+130, 168634, 2222, 10534, 0, '0', 0, 0, 0, 0, -3958.08203125, -4069.214111328125, 6564.09228515625, 0.089656561613082885, 7200, 3, 0, 5404, 0, 1, 0, 0, 0, 42010), -- Soulwing Glimmerfly (Area: 0 - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+131, 168892, 2222, 10534, 0, '0', 0, 0, 0, 0, -4002.55322265625, -4014.08203125, 6566.2021484375, 3.111806631088256835, 7200, 0, 0, 3210, 0, 0, 0, 0, 0, 42010), -- Famished Etherwyrm (Area: 0 - Difficulty: 0) +(@CGUID+132, 168624, 2222, 10534, 0, '0', 0, 0, 0, 0, -3955.820556640625, -4073.881591796875, 6563.17431640625, 0.093355059623718261, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: 0 - Difficulty: 0) +(@CGUID+133, 168915, 2222, 10534, 0, '0', 0, 0, 0, 0, -3962.41845703125, -4060.102783203125, 6552.197265625, 0.664939045906066894, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 42010), -- Field Everhopper (Area: 0 - Difficulty: 0) +(@CGUID+134, 168887, 2222, 10534, 0, '0', 0, 0, 0, 0, -3967.03662109375, -4058.58984375, 6550.85546875, 1.496568918228149414, 7200, 6, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Gilded Cloudstrider (Area: 0 - Difficulty: 0) +(@CGUID+135, 168731, 2222, 10534, 0, '0', 0, 0, 0, 0, -4156.9150390625, -4094.1494140625, 6561.5390625, 3.141928434371948242, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Copperfur Lurker (Area: 0 - Difficulty: 0) (Auras: 159510 - Cosmetic - Sleep Zzz Breakable) +(@CGUID+136, 168410, 2222, 10534, 0, '0', 0, 0, 0, 0, -4152.640625, -4082.552978515625, 6559.72900390625, 5.331412315368652343, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: 0 - Difficulty: 0) +(@CGUID+137, 168359, 2222, 10534, 0, '0', 0, 0, 0, 0, -4190.354890625, -4214.647720703125, 6598.14404296875, 4.696656155776977539, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Swift Skymane (Area: 0 - Difficulty: 0) +(@CGUID+138, 168359, 2222, 10534, 0, '0', 0, 0, 0, 0, -4190.354890625, -4214.647720703125, 6598.14404296875, 4.696656155776977539, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Swift Skymane (Area: 0 - Difficulty: 0) +(@CGUID+139, 168410, 2222, 10534, 0, '0', 0, 0, 0, 0, -4196.35107421875, -4180.09814453125, 6588.04345703125, 2.235778570175170898, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: 0 - Difficulty: 0) +(@CGUID+140, 168268, 2222, 10534, 0, '0', 0, 0, 0, 0, -4161.55908203125, -4210.3017578125, 6596.22265625, 4.036590576171875, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Spiritwing Glimmerfly (Area: 0 - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+141, 168731, 2222, 10534, 0, '0', 0, 0, 0, 0, -4195.94775390625, -4140.75341796875, 6573.5595703125, 1.532678484916687011, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Copperfur Lurker (Area: 0 - Difficulty: 0) (Auras: 159510 - Cosmetic - Sleep Zzz Breakable) +(@CGUID+142, 168397, 2222, 10534, 0, '0', 0, 0, 0, 0, -4199.6806640625, -4143.14208984375, 6576.361328125, 2.738422870635986328, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: 0 - Difficulty: 0) +(@CGUID+143, 168397, 2222, 10534, 0, '0', 0, 0, 0, 0, -4211.91259765625, -4127.1328125, 6574.71484375, 5.275630474090576171, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: 0 - Difficulty: 0) +(@CGUID+144, 168624, 2222, 10534, 0, '0', 0, 0, 0, 0, -4174.982421875, -4221.04443359375, 6599.54443359375, 5.772047996520996093, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: 0 - Difficulty: 0) +(@CGUID+145, 168397, 2222, 10534, 0, '0', 0, 0, 0, 0, -4171.3466796875, -4209.1328125, 6597.6328125, 1.04582071304321289, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: 0 - Difficulty: 0) +(@CGUID+146, 168268, 2222, 10534, 0, '0', 0, 0, 0, 0, -4219.30029296875, -4185.23046875, 6584.0146484375, 4.241250991821289062, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Spiritwing Glimmerfly (Area: 0 - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+147, 168309, 2222, 10534, 0, '0', 0, 0, 0, 0, -4219.26416015625, -4195.0830078125, 6596.5419921875, 5.608821392059326171, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Hungering Etherwyrm (Area: 0 - Difficulty: 0) +(@CGUID+148, 168410, 2222, 10534, 0, '0', 0, 0, 0, 0, -4193.27783203125, -4255.50341796875, 6605.826171875, 3.037840843200683593, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: 0 - Difficulty: 0) +(@CGUID+149, 168268, 2222, 10534, 0, '0', 0, 0, 0, 0, -4151.859375, -4281.2119140625, 6649.5234375, 0, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Spiritwing Glimmerfly (Area: 0 - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+150, 168624, 2222, 10534, 0, '0', 0, 0, 0, 0, -4215.6630859375, -4223.87890625, 6595.49755859375, 2.102097511291503906, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: 0 - Difficulty: 0) +(@CGUID+151, 168624, 2222, 10534, 0, '0', 0, 0, 0, 0, -4214.83349609375, -4236.1142578125, 6596.60205078125, 5.201276779174804687, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: 0 - Difficulty: 0) +(@CGUID+152, 168359, 2222, 10534, 0, '0', 0, 0, 0, 0, -4200.8759765625, -4282.255859375, 6608.07666015625, 1.5376054048538208, 7200, 10, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Swift Skymane (Area: 0 - Difficulty: 0) +(@CGUID+153, 171668, 2222, 10534, 0, '0', 0, 0, 0, 0, -4152.16650390625, -4288.86474609375, 6650.10107421875, 1.321388006210327148, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 42010); -- Vibrant Glimmerfly (Area: 0 - Difficulty: 0) (Auras: 308853 - -Unknown-) + +-- Creature Addon +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+153; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+104, 0, 0, 0, 1, 0, 0, 0, 0, 0, '159510'), -- Copperfur Lurker - 159510 - Cosmetic - Sleep Zzz Breakable +(@CGUID+135, 0, 0, 0, 1, 0, 0, 0, 0, 0, '159510'), -- Copperfur Lurker - 159510 - Cosmetic - Sleep Zzz Breakable +(@CGUID+94, 0, 0, 3, 1, 0, 0, 0, 0, 0, '350558'), -- Riverfall Crystalback - 350558 - -Unknown- +(@CGUID+116, 0, 0, 3, 1, 0, 0, 0, 0, 0, '350558'), -- Riverfall Terrapin - 350558 - -Unknown- +(@CGUID+63, 0, 0, 3, 1, 0, 0, 0, 0, 0, '125567'), -- Copperfur Lurker - 125567 - Cosmetic - Sleep Zzz - Small Zs +(@CGUID+60, 0, 0, 3, 1, 0, 0, 0, 0, 0, '125567'); -- Copperfur Lurker - 125567 - Cosmetic - Sleep Zzz - Small Zs + +-- Creature Template Addon +DELETE FROM `creature_template_addon` WHERE `entry` = 168892; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(168892, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''); -- 168892 (Famished Etherwyrm) + +-- Creature Movement +DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (168624, 168268, 168634, 168892); +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`) VALUES +(168624, 1, 0, 1, 0, 0, 0), +(168268, 1, 0, 1, 0, 0, 0), +(168634, 1, 0, 1, 0, 0, 0), +(168892, 1, 0, 1, 0, 0, 0); + +-- Waypoints for @CGUID+27 +SET @PATH := @CGUID+27 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data`(`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(@PATH, 11, -4201.82, -4440.99, 6690.73, 0, 0, 0, 0, 100, 0), +(@PATH, 10, -4196.35, -4448.52, 6691.93, 0, 0, 0, 0, 100, 0), +(@PATH, 9, -4191.08, -4456.53, 6692.52, 0, 0, 0, 0, 100, 0), +(@PATH, 8, -4186.57, -4465.37, 6692.9, 0, 0, 0, 0, 100, 0), +(@PATH, 7, -4183.87, -4474.39, 6692.79, 0, 0, 0, 0, 100, 0), +(@PATH, 6, -4180.92, -4481.79, 6692.54, 0, 6763, 0, 0, 100, 0), +(@PATH, 5, -4183.87, -4474.39, 6692.79, 0, 0, 0, 0, 100, 0), +(@PATH, 4, -4186.57, -4465.37, 6692.9, 0, 0, 0, 0, 100, 0), +(@PATH, 3, -4191.08, -4456.53, 6692.52, 0, 0, 0, 0, 100, 0), +(@PATH, 2, -4196.35, -4448.52, 6691.93, 0, 0, 0, 0, 100, 0), +(@PATH, 1, -4201.82, -4440.99, 6690.73, 0, 0, 0, 0, 100, 0), +(@PATH, 0, -4206.45, -4434.97, 6689.65, 0, 13981, 0, 0, 100, 0); + +UPDATE `creature` SET `position_x`= -4206.453, `position_y`= -4434.967, `position_z`= 6689.646, `orientation`= 2.210634, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+27; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+27; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+27, @PATH, 1); + +-- Waypoints for @CGUID+51 +SET @PATH := @CGUID+51 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data`(`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(@PATH, 5, -4020.29, -4375.09, 6667.96, 0, 0, 0, 0, 100, 0), +(@PATH, 4, -4025.79, -4369.87, 6666.48, 0, 0, 0, 0, 100, 0), +(@PATH, 3, -4038.02, -4359.01, 6667.51, 0, 13683, 0, 0, 100, 0), +(@PATH, 2, -4029.12, -4364.29, 6666.44, 0, 0, 0, 0, 100, 0), +(@PATH, 1, -4019.77, -4369.49, 6666.14, 0, 0, 0, 0, 100, 0), +(@PATH, 0, -4008.81, -4378.56, 6667.06, 0, 14481, 0, 0, 100, 0); + +UPDATE `creature` SET `position_x`= -4008.807, `position_y`= -4378.563, `position_z`= 6667.06, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+51; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+51; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+51, @PATH, 1); + +-- Waypoints for @CGUID+68 +SET @PATH := @CGUID+68 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data`(`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(@PATH, 12, -4107.51, -4310.94, 6655.18, 0, 0, 0, 0, 100, 0), +(@PATH, 11, -4107.55, -4318.75, 6658.06, 0, 0, 0, 0, 100, 0), +(@PATH, 10, -4105.66, -4327.23, 6660.05, 0, 0, 0, 0, 100, 0), +(@PATH, 9, -4105.12, -4334.09, 6663.33, 0, 4406, 0, 0, 100, 0), +(@PATH, 8, -4106.26, -4333.1, 6662.57, 0, 5800, 0, 0, 100, 0), +(@PATH, 7, -4104.86, -4333.56, 6663.08, 0, 0, 0, 0, 100, 0), +(@PATH, 6, -4105.66, -4327.23, 6660.05, 0, 0, 0, 0, 100, 0), +(@PATH, 5, -4107.55, -4318.75, 6658.06, 0, 0, 0, 0, 100, 0), +(@PATH, 4, -4107.51, -4310.94, 6655.18, 0, 0, 0, 0, 100, 0), +(@PATH, 3, -4102.42, -4302.4, 6651.46, 0, 0, 0, 0, 100, 0), +(@PATH, 2, -4094.67, -4295.06, 6647.53, 0, 1131, 0, 0, 100, 0), +(@PATH, 1, -4087.83, -4284.64, 6644.2, 0, 0, 0, 0, 100, 0), +(@PATH, 0, -4102.42, -4302.4, 6651.46, 0, 0, 0, 0, 100, 0); + +UPDATE `creature` SET `position_x`= -4102.418, `position_y`= -4302.403, `position_z`= 6651.462, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+68; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+68; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+68, @PATH, 1); + +-- Waypoints & Formation for @CGUID+75 AND @CGUID+77 +DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+75; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@CGUID+75, @CGUID+75, 0, 0, 515, 0, 0), +(@CGUID+75, @CGUID+77, 6, 0, 515, 0, 0); + +SET @PATH := @CGUID+75 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data`(`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(@PATH, 0, -3958.82, -4309.56, 6656.21, 0, 0, 1, 0, 100, 0), +(@PATH, 1, -3966.7, -4294.95, 6650.08, 0, 0, 1, 0, 100, 0), +(@PATH, 2, -3984.68, -4288.64, 6645.27, 0, 0, 1, 0, 100, 0), +(@PATH, 3, -4000.08, -4275.99, 6640.94, 0, 0, 1, 0, 100, 0), +(@PATH, 4, -4008.72, -4254.76, 6633.76, 0, 0, 1, 0, 100, 0), +(@PATH, 5, -4012.98, -4235.23, 6625.84, 0, 0, 1, 0, 100, 0), +(@PATH, 6, -4023.71, -4217.27, 6619.18, 0, 0, 1, 0, 100, 0), +(@PATH, 7, -4041.32, -4217.63, 6616.34, 0, 0, 1, 0, 100, 0), +(@PATH, 8, -4059.98, -4233.01, 6624.98, 0, 0, 1, 0, 100, 0), +(@PATH, 9, -4072.13, -4248.2, 6631.31, 0, 0, 1, 0, 100, 0), +(@PATH, 10, -4076.23, -4264.81, 6636.72, 0, 0, 1, 0, 100, 0), +(@PATH, 11, -4066.97, -4288.2, 6647.46, 0, 0, 1, 0, 100, 0), +(@PATH, 12, -4064, -4300.41, 6652.74, 0, 0, 1, 0, 100, 0), +(@PATH, 13, -4062.2, -4317.31, 6660.04, 0, 0, 1, 0, 100, 0), +(@PATH, 14, -4045.82, -4329.87, 6659.91, 0, 0, 1, 0, 100, 0), +(@PATH, 15, -4023.62, -4331.18, 6657.74, 0, 0, 1, 0, 100, 0), +(@PATH, 16, -4000.8, -4332.23, 6653.89, 0, 0, 1, 0, 100, 0), +(@PATH, 17, -3981.88, -4330.37, 6655.35, 0, 0, 1, 0, 100, 0), +(@PATH, 18, -3965.51, -4324.83, 6657.35, 0, 0, 1, 0, 100, 0); + +UPDATE `creature` SET `position_x`= -3958.82, `position_y`= -4309.557, `position_z`= 6656.211, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+75; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+75; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+75, @PATH, 1); + +-- Waypoints & Formation for @CGUID+138 AND @CGUID+137 +DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+138; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@CGUID+138, @CGUID+138, 0, 0, 515, 0, 0), +(@CGUID+138, @CGUID+137, 6, 0, 515, 0, 0); + +SET @PATH := @CGUID+138 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data`(`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(@PATH, 0, -4190.32, -4226.63, 6600.56, 0, 0, 0, 0, 100, 0), +(@PATH, 1, -4189.68, -4229.54, 6601.19, 0, 0, 0, 0, 100, 0), +(@PATH, 2, -4189.07, -4232.35, 6601.92, 0, 0, 0, 0, 100, 0), +(@PATH, 3, -4192.74, -4237.75, 6602.85, 0, 0, 0, 0, 100, 0), +(@PATH, 4, -4190.17, -4239.55, 6603.48, 0, 0, 0, 0, 100, 0), +(@PATH, 5, -4187.64, -4241.33, 6603.9, 0, 0, 0, 0, 100, 0), +(@PATH, 6, -4185.07, -4243.13, 6603.87, 0, 0, 0, 0, 100, 0), +(@PATH, 7, -4182.52, -4244.92, 6604.1, 0, 0, 0, 0, 100, 0), +(@PATH, 8, -4181.26, -4251.87, 6605.36, 0, 0, 0, 0, 100, 0), +(@PATH, 9, -4178.54, -4251.38, 6604.92, 0, 0, 0, 0, 100, 0), +(@PATH, 10, -4175.6, -4250.74, 6604.23, 0, 0, 0, 0, 100, 0), +(@PATH, 11, -4172.54, -4250.09, 6603.47, 0, 0, 0, 0, 100, 0), +(@PATH, 12, -4166.95, -4253.95, 6604.47, 0, 0, 0, 0, 100, 0), +(@PATH, 13, -4165.04, -4251.64, 6604.24, 0, 0, 0, 0, 100, 0), +(@PATH, 14, -4163.1, -4249.29, 6603.79, 0, 0, 0, 0, 100, 0), +(@PATH, 15, -4161.15, -4246.92, 6603.44, 0, 0, 0, 0, 100, 0), +(@PATH, 16, -4159.22, -4244.6, 6603.12, 0, 0, 0, 0, 100, 0), +(@PATH, 17, -4155.04, -4243.87, 6603.44, 0, 0, 0, 0, 100, 0), +(@PATH, 18, -4154.31, -4241.01, 6602.85, 0, 0, 0, 0, 100, 0), +(@PATH, 19, -4153.59, -4238.15, 6602.24, 0, 0, 0, 0, 100, 0), +(@PATH, 20, -4152.86, -4235.28, 6601.64, 0, 0, 0, 0, 100, 0), +(@PATH, 21, -4152.17, -4232.55, 6600.97, 0, 0, 0, 0, 100, 0), +(@PATH, 22, -4151.41, -4229.6, 6600.22, 0, 0, 0, 0, 100, 0), +(@PATH, 23, -4150.69, -4226.75, 6599.47, 0, 0, 0, 0, 100, 0), +(@PATH, 24, -4150.1, -4223.9, 6598.6, 0, 0, 0, 0, 100, 0), +(@PATH, 25, -4145.99, -4220.91, 6597.81, 0, 0, 0, 0, 100, 0), +(@PATH, 26, -4146.98, -4218.13, 6597.2, 0, 0, 0, 0, 100, 0), +(@PATH, 27, -4147.99, -4215.33, 6596.35, 0, 0, 0, 0, 100, 0), +(@PATH, 28, -4148.97, -4212.62, 6595.85, 0, 0, 0, 0, 100, 0), +(@PATH, 29, -4149.96, -4209.84, 6595.1, 0, 0, 0, 0, 100, 0), +(@PATH, 30, -4150.97, -4207.04, 6594.47, 0, 0, 0, 0, 100, 0), +(@PATH, 31, -4152, -4204.16, 6593.97, 0, 0, 0, 0, 100, 0), +(@PATH, 32, -4153.07, -4201.52, 6593.35, 0, 0, 0, 0, 100, 0), +(@PATH, 33, -4153.5, -4198.58, 6592.68, 0, 0, 0, 0, 100, 0), +(@PATH, 34, -4154.74, -4195.83, 6591.81, 0, 0, 0, 0, 100, 0), +(@PATH, 35, -4155.93, -4193.23, 6591.16, 0, 0, 0, 0, 100, 0), +(@PATH, 36, -4157.13, -4190.58, 6590.42, 0, 0, 0, 0, 100, 0), +(@PATH, 37, -4158.33, -4187.96, 6589.67, 0, 0, 0, 0, 100, 0), +(@PATH, 38, -4159.52, -4185.35, 6588.52, 0, 0, 0, 0, 100, 0), +(@PATH, 39, -4160.74, -4182.69, 6587.56, 0, 0, 0, 0, 100, 0), +(@PATH, 40, -4161.97, -4180.01, 6586.55, 0, 0, 0, 0, 100, 0), +(@PATH, 41, -4164.11, -4178.12, 6586.12, 0, 0, 0, 0, 100, 0), +(@PATH, 42, -4164.94, -4175.21, 6585.34, 0, 0, 0, 0, 100, 0), +(@PATH, 43, -4165.74, -4172.37, 6584.58, 0, 0, 0, 0, 100, 0), +(@PATH, 44, -4166.55, -4169.54, 6583.97, 0, 0, 0, 0, 100, 0), +(@PATH, 45, -4167.35, -4166.75, 6583.58, 0, 0, 0, 0, 100, 0), +(@PATH, 46, -4168.13, -4163.98, 6582.94, 0, 0, 0, 0, 100, 0), +(@PATH, 47, -4168.96, -4161.07, 6582.27, 0, 0, 0, 0, 100, 0), +(@PATH, 48, -4169.75, -4158.3, 6581.55, 0, 0, 0, 0, 100, 0), +(@PATH, 49, -4170.52, -4155.57, 6580.81, 0, 0, 0, 0, 100, 0), +(@PATH, 50, -4171.31, -4152.81, 6579.94, 0, 0, 0, 0, 100, 0), +(@PATH, 51, -4172.08, -4150.14, 6579.14, 0, 0, 0, 0, 100, 0), +(@PATH, 52, -4173.41, -4147.63, 6578.3, 0, 0, 0, 0, 100, 0), +(@PATH, 53, -4173.85, -4145.02, 6577.33, 0, 0, 0, 0, 100, 0), +(@PATH, 54, -4174.31, -4142.27, 6576, 0, 0, 0, 0, 100, 0), +(@PATH, 55, -4174.77, -4139.55, 6574.92, 0, 0, 0, 0, 100, 0), +(@PATH, 56, -4175.23, -4136.82, 6573.4, 0, 0, 0, 0, 100, 0), +(@PATH, 57, -4175.7, -4134.02, 6572, 0, 0, 0, 0, 100, 0), +(@PATH, 58, -4176.19, -4131.07, 6570.52, 0, 0, 0, 0, 100, 0), +(@PATH, 59, -4176.64, -4128.08, 6569.37, 0, 0, 0, 0, 100, 0), +(@PATH, 60, -4178.94, -4125.17, 6568.65, 0, 0, 0, 0, 100, 0), +(@PATH, 61, -4178.47, -4122.2, 6568.02, 0, 0, 0, 0, 100, 0), +(@PATH, 62, -4177.99, -4119.16, 6567.6, 0, 0, 0, 0, 100, 0), +(@PATH, 63, -4177.52, -4116.15, 6567.3, 0, 0, 0, 0, 100, 0), +(@PATH, 64, -4177.04, -4113.17, 6566.89, 0, 0, 0, 0, 100, 0), +(@PATH, 65, -4176.58, -4110.22, 6566.57, 0, 0, 0, 0, 100, 0), +(@PATH, 66, -4176.11, -4107.23, 6566.07, 0, 0, 0, 0, 100, 0), +(@PATH, 67, -4175.63, -4104.24, 6565.65, 0, 0, 0, 0, 100, 0), +(@PATH, 68, -4175.16, -4101.26, 6565.24, 0, 0, 0, 0, 100, 0), +(@PATH, 69, -4174.72, -4098.46, 6564.78, 0, 0, 0, 0, 100, 0), +(@PATH, 70, -4177.69, -4094.33, 6564.54, 0, 0, 0, 0, 100, 0), +(@PATH, 71, -4175.93, -4091.94, 6564.12, 0, 0, 0, 0, 100, 0), +(@PATH, 72, -4174.16, -4089.53, 6563.55, 0, 0, 0, 0, 100, 0), +(@PATH, 73, -4172.47, -4087.25, 6563.03, 0, 0, 0, 0, 100, 0), +(@PATH, 74, -4170.7, -4084.86, 6562.4, 0, 0, 0, 0, 100, 0), +(@PATH, 75, -4168.86, -4082.35, 6561.87, 0, 0, 0, 0, 100, 0), +(@PATH, 76, -4167.15, -4080.05, 6561.28, 0, 0, 0, 0, 100, 0), +(@PATH, 77, -4165.29, -4077.51, 6560.65, 0, 0, 0, 0, 100, 0), +(@PATH, 78, -4163.51, -4075.1, 6560.05, 0, 0, 0, 0, 100, 0), +(@PATH, 79, -4164.57, -4068.58, 6559.11, 0, 0, 0, 0, 100, 0), +(@PATH, 80, -4161.65, -4067.87, 6558.48, 0, 0, 0, 0, 100, 0), +(@PATH, 81, -4158.8, -4067.19, 6558.35, 0, 0, 0, 0, 100, 0), +(@PATH, 82, -4156, -4066.52, 6557.64, 0, 0, 0, 0, 100, 0), +(@PATH, 83, -4153.12, -4065.81, 6557.14, 0, 0, 0, 0, 100, 0), +(@PATH, 84, -4150.29, -4065.14, 6556.51, 0, 0, 0, 0, 100, 0), +(@PATH, 85, -4147.4, -4064.44, 6555.89, 0, 0, 0, 0, 100, 0), +(@PATH, 86, -4144.46, -4063.73, 6555.15, 0, 0, 0, 0, 100, 0), +(@PATH, 87, -4141.66, -4063.05, 6554.27, 0, 0, 0, 0, 100, 0), +(@PATH, 88, -4138.82, -4062.37, 6553.64, 0, 0, 0, 0, 100, 0), +(@PATH, 89, -4136.04, -4058.7, 6552.63, 0, 0, 0, 0, 100, 0), +(@PATH, 90, -4133.19, -4059.19, 6552.12, 0, 0, 0, 0, 100, 0), +(@PATH, 91, -4130.26, -4059.68, 6551.42, 0, 0, 0, 0, 100, 0), +(@PATH, 92, -4127.31, -4060.18, 6550.64, 0, 0, 0, 0, 100, 0), +(@PATH, 93, -4124.43, -4060.66, 6550.03, 0, 0, 0, 0, 100, 0), +(@PATH, 94, -4121.56, -4061.19, 6549.28, 0, 0, 0, 0, 100, 0), +(@PATH, 95, -4117.1, -4058.06, 6548.16, 0, 0, 0, 0, 100, 0), +(@PATH, 96, -4115.06, -4060.23, 6547.81, 0, 0, 0, 0, 100, 0), +(@PATH, 97, -4112.98, -4062.42, 6547.57, 0, 0, 0, 0, 100, 0), +(@PATH, 98, -4110.86, -4064.67, 6547.16, 0, 0, 0, 0, 100, 0), +(@PATH, 99, -4103.82, -4064.82, 6545.19, 0, 0, 0, 0, 100, 0), +(@PATH, 100, -4103.76, -4067.68, 6545.35, 0, 0, 0, 0, 100, 0), +(@PATH, 101, -4103.7, -4070.53, 6545.9, 0, 0, 0, 0, 100, 0), +(@PATH, 102, -4103.7, -4073.39, 6546.85, 0, 0, 0, 0, 100, 0), +(@PATH, 103, -4099.69, -4077.57, 6547.62, 0, 0, 0, 0, 100, 0), +(@PATH, 104, -4101.71, -4079.68, 6548.6, 0, 0, 0, 0, 100, 0), +(@PATH, 105, -4103.7, -4081.8, 6549.61, 0, 0, 0, 0, 100, 0), +(@PATH, 106, -4105.71, -4083.91, 6550.72, 0, 0, 0, 0, 100, 0), +(@PATH, 107, -4107.6, -4085.9, 6551.72, 0, 0, 0, 0, 100, 0), +(@PATH, 108, -4109.61, -4088.03, 6552.72, 0, 0, 0, 0, 100, 0), +(@PATH, 109, -4110.38, -4091.75, 6553.79, 0, 0, 0, 0, 100, 0), +(@PATH, 110, -4112.87, -4093.2, 6554.56, 0, 0, 0, 0, 100, 0), +(@PATH, 111, -4115.45, -4094.68, 6555.4, 0, 0, 0, 0, 100, 0), +(@PATH, 112, -4117.88, -4096.09, 6556.2, 0, 0, 0, 0, 100, 0), +(@PATH, 113, -4120.37, -4097.53, 6557.1, 0, 0, 0, 0, 100, 0), +(@PATH, 114, -4122.92, -4099, 6557.98, 0, 0, 0, 0, 100, 0), +(@PATH, 115, -4125.43, -4100.45, 6558.91, 0, 0, 0, 0, 100, 0), +(@PATH, 116, -4128.01, -4101.94, 6559.73, 0, 0, 0, 0, 100, 0), +(@PATH, 117, -4130.56, -4103.41, 6560.56, 0, 0, 0, 0, 100, 0), +(@PATH, 118, -4133.06, -4104.86, 6561.39, 0, 0, 0, 0, 100, 0), +(@PATH, 119, -4135.6, -4106.33, 6562.1, 0, 0, 0, 0, 100, 0), +(@PATH, 120, -4138.08, -4107.76, 6562.74, 0, 0, 0, 0, 100, 0), +(@PATH, 121, -4142.12, -4107.43, 6563.22, 0, 0, 0, 0, 100, 0), +(@PATH, 122, -4143.91, -4109.76, 6564.12, 0, 0, 0, 0, 100, 0), +(@PATH, 123, -4145.71, -4112.05, 6565.07, 0, 0, 0, 0, 100, 0), +(@PATH, 124, -4147.52, -4114.39, 6565.73, 0, 0, 0, 0, 100, 0), +(@PATH, 125, -4149.29, -4116.68, 6566.66, 0, 0, 0, 0, 100, 0), +(@PATH, 126, -4151.06, -4118.96, 6567.51, 0, 0, 0, 0, 100, 0), +(@PATH, 127, -4152.84, -4121.26, 6568.5, 0, 0, 0, 0, 100, 0), +(@PATH, 128, -4154.65, -4123.58, 6569.24, 0, 0, 0, 0, 100, 0), +(@PATH, 129, -4156.4, -4125.84, 6569.98, 0, 0, 0, 0, 100, 0), +(@PATH, 130, -4158.19, -4128.16, 6570.99, 0, 0, 0, 0, 100, 0), +(@PATH, 131, -4159.9, -4130.35, 6571.87, 0, 0, 0, 0, 100, 0), +(@PATH, 132, -4161.74, -4132.73, 6572.62, 0, 0, 0, 0, 100, 0), +(@PATH, 133, -4163.52, -4135.03, 6573.29, 0, 0, 0, 0, 100, 0), +(@PATH, 134, -4165.3, -4137.32, 6574.32, 0, 0, 0, 0, 100, 0), +(@PATH, 135, -4168.09, -4138.93, 6574.89, 0, 0, 0, 0, 100, 0), +(@PATH, 136, -4169.29, -4141.52, 6575.95, 0, 0, 0, 0, 100, 0), +(@PATH, 137, -4170.48, -4144.07, 6576.94, 0, 0, 0, 0, 100, 0), +(@PATH, 138, -4171.71, -4146.71, 6578.07, 0, 0, 0, 0, 100, 0), +(@PATH, 139, -4172.89, -4149.24, 6578.91, 0, 0, 0, 0, 100, 0), +(@PATH, 140, -4174.5, -4151.66, 6579.97, 0, 0, 0, 0, 100, 0), +(@PATH, 141, -4175.48, -4154.29, 6581.05, 0, 0, 0, 0, 100, 0), +(@PATH, 142, -4175.94, -4157.16, 6582, 0, 0, 0, 0, 100, 0), +(@PATH, 143, -4177.35, -4159.61, 6583.06, 0, 0, 0, 0, 100, 0), +(@PATH, 144, -4178.4, -4162.26, 6584.06, 0, 0, 0, 0, 100, 0), +(@PATH, 145, -4179.46, -4164.94, 6585.19, 0, 0, 0, 0, 100, 0), +(@PATH, 146, -4180.59, -4167.76, 6586.16, 0, 0, 0, 0, 100, 0), +(@PATH, 147, -4181.56, -4170.38, 6586.96, 0, 0, 0, 0, 100, 0), +(@PATH, 148, -4183.05, -4173.07, 6587.83, 0, 0, 0, 0, 100, 0), +(@PATH, 149, -4183.91, -4175.72, 6588.58, 0, 0, 0, 0, 100, 0), +(@PATH, 150, -4184.86, -4178.62, 6589.33, 0, 0, 0, 0, 100, 0), +(@PATH, 151, -4185.76, -4181.37, 6590.21, 0, 0, 0, 0, 100, 0), +(@PATH, 152, -4186.68, -4184.22, 6590.83, 0, 0, 0, 0, 100, 0), +(@PATH, 153, -4188.78, -4186.81, 6591.45, 0, 0, 0, 0, 100, 0), +(@PATH, 154, -4189.2, -4189.63, 6592.46, 0, 0, 0, 0, 100, 0), +(@PATH, 155, -4189.68, -4192.69, 6593, 0, 0, 0, 0, 100, 0), +(@PATH, 156, -4190.11, -4195.52, 6593.71, 0, 0, 0, 0, 100, 0), +(@PATH, 157, -4190.56, -4198.45, 6594.46, 0, 0, 0, 0, 100, 0), +(@PATH, 158, -4191, -4201.37, 6595.04, 0, 0, 0, 0, 100, 0), +(@PATH, 159, -4193.05, -4204.29, 6595.19, 0, 0, 0, 0, 100, 0), +(@PATH, 160, -4192.74, -4207.25, 6596.1, 0, 0, 0, 0, 100, 0), +(@PATH, 161, -4192.43, -4210.15, 6596.83, 0, 0, 0, 0, 100, 0), +(@PATH, 162, -4192.12, -4213.04, 6597.54, 0, 0, 0, 0, 100, 0), +(@PATH, 163, -4192.63, -4216.13, 6598.19, 0, 0, 0, 0, 100, 0), +(@PATH, 164, -4191.99, -4219.03, 6598.92, 0, 0, 0, 0, 100, 0), +(@PATH, 165, -4191.36, -4221.9, 6599.52, 0, 0, 0, 0, 100, 0), +(@PATH, 166, -4190.71, -4224.86, 6600.22, 0, 0, 0, 0, 100, 0); + +UPDATE `creature` SET `position_x`= -4190.322, `position_y`= -4226.628, `position_z`= 6600.562, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+138; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+138; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+138, @PATH, 1); diff --git a/sql/updates/world/master/2022_02_14_02_world.sql b/sql/updates/world/master/2022_02_14_02_world.sql new file mode 100644 index 00000000000..e08b18b097b --- /dev/null +++ b/sql/updates/world/master/2022_02_14_02_world.sql @@ -0,0 +1,62 @@ +SET @CGUID := 1050848; + +-- Creature Spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+44; +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, 168624, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4288.16796875, -4446.697265625, 6621.18603515625, 0.367853283882141113, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+1, 168428, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4237.22900390625, -4365.8125, 6609.841796875, 1.890304327011108398, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Riverfall Terrapin (Area: -Unknown- - Difficulty: 0) (Auras: 350558 - -Unknown-) +(@CGUID+2, 168333, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4249.943359375, -4508.95947265625, 6608.92724609375, 1.588372588157653808, 7200, 8, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Gildfur Bighorn (Area: -Unknown- - Difficulty: 0) +(@CGUID+3, 168613, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4294.404296875, -4397.90966796875, 6694.51904296875, 3.527477979660034179, 7200, 0, 0, 10133, 0, 0, 0, 0, 0, 42010), -- Aurumane Larion (Area: -Unknown- - Difficulty: 0) +(@CGUID+4, 168410, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4318.220703125, -4437.55908203125, 6606.193359375, 6.204914569854736328, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+5, 168410, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4266.8447265625, -4450.095703125, 6622.8134765625, 4.725453376770019531, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+6, 168268, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4294.63427734375, -4474.12451171875, 6623.5771484375, 0.148648470640182495, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Spiritwing Glimmerfly (Area: -Unknown- - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+7, 168333, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4254.751953125, -4452.22216796875, 6625.59765625, 3.973099470138549804, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Gildfur Bighorn (Area: -Unknown- - Difficulty: 0) +(@CGUID+8, 168268, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4300.33447265625, -4407.81298828125, 6614.33056640625, 1.28951418399810791, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Spiritwing Glimmerfly (Area: -Unknown- - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+9, 168437, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4251.63916015625, -4370.0009765625, 6596.8984375, 4.092958450317382812, 7200, 4, 0, 27, 0, 1, 0, 0, 0, 42010), -- Riverfall Hatchling (Area: -Unknown- - Difficulty: 0) +(@CGUID+10, 168397, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4247.43310546875, -4420.884765625, 6628.890625, 1.288228511810302734, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+11, 168624, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4275.85888671875, -4474.6103515625, 6621.64697265625, 4.137640953063964843, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+12, 168397, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4233.94287109375, -4490.8857421875, 6623.32861328125, 5.44704437255859375, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+13, 168397, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4283.54736328125, -4418.56298828125, 6619.7412109375, 0.919228851795196533, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+14, 168333, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4259.6767578125, -4417.80224609375, 6622.50341796875, 5.630703926086425781, 7200, 8, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Gildfur Bighorn (Area: -Unknown- - Difficulty: 0) +(@CGUID+15, 168410, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4276.0234375, -4375.4619140625, 6599.51904296875, 0.571220219135284423, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+16, 168333, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4275, -4502.083984375, 6604.62353515625, 3.064045667648315429, 7200, 8, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Gildfur Bighorn (Area: -Unknown- - Difficulty: 0) +(@CGUID+17, 168333, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4257.18408203125, -4456.04541015625, 6624.63818359375, 0.977491974830627441, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Gildfur Bighorn (Area: -Unknown- - Difficulty: 0) +(@CGUID+18, 168624, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4278.57080078125, -4406.564453125, 6616.83837890625, 3.754418134689331054, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+19, 168410, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4203.6416015625, -4420.36767578125, 6686.25244140625, 0.801971256732940673, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+20, 168438, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4231.4599609375, -4349.6142578125, 6585.736328125, 6.102705001831054687, 7200, 4, 0, 13510, 0, 1, 0, 0, 0, 42010), -- Riverfall Scaleback (Area: -Unknown- - Difficulty: 0) +(@CGUID+21, 168268, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4254.794921875, -4531.01416015625, 6607.3232421875, 2.638660192489624023, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Spiritwing Glimmerfly (Area: -Unknown- - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+22, 168397, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4336.673828125, -4430.51416015625, 6603.376953125, 0.662260472774505615, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+23, 168333, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4313.830078125, -4399.765625, 6604.2275390625, 5.498345375061035156, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Gildfur Bighorn (Area: -Unknown- - Difficulty: 0) +(@CGUID+24, 168428, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4234.99853515625, -4364.58349609375, 6609.9453125, 2.193511724472045898, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Riverfall Terrapin (Area: -Unknown- - Difficulty: 0) (Auras: 350558 - -Unknown-) +(@CGUID+25, 168437, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4247.1513671875, -4352.37353515625, 6585.89306640625, 2.065745353698730468, 7200, 4, 0, 27, 0, 1, 0, 0, 0, 42010), -- Riverfall Hatchling (Area: -Unknown- - Difficulty: 0) +(@CGUID+26, 168428, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4224.478515625, -4359.896484375, 6610.64892578125, 6.237467288970947265, 7200, 4, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Riverfall Terrapin (Area: -Unknown- - Difficulty: 0) +(@CGUID+27, 168333, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4310.1181640625, -4402.36962890625, 6605.4169921875, 2.50273752212524414, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Gildfur Bighorn (Area: -Unknown- - Difficulty: 0) +(@CGUID+28, 168624, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4252.60107421875, -4529.01708984375, 6604.37255859375, 2.630561590194702148, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+29, 168410, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4162.08251953125, -4449.30712890625, 6689.7958984375, 2.11395430564880371, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+30, 168268, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4279.31591796875, -4372.138671875, 6602.4111328125, 5.135951042175292968, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Spiritwing Glimmerfly (Area: -Unknown- - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+31, 168410, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4228.142578125, -4533.46044921875, 6607.025390625, 3.976673841476440429, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+32, 168624, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4330.55615234375, -4452.7216796875, 6601.7802734375, 3.422464847564697265, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+33, 168268, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4325.138671875, -4443.7333984375, 6605.09521484375, 1.657061338424682617, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Spiritwing Glimmerfly (Area: -Unknown- - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+34, 168410, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4316.947265625, -4408.07470703125, 6605.1357421875, 4.224270820617675781, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+35, 168333, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4320.54248046875, -4451.73681640625, 6603.36328125, 4.489489078521728515, 7200, 8, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Gildfur Bighorn (Area: -Unknown- - Difficulty: 0) +(@CGUID+36, 168309, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4332.349609375, -4486.4140625, 6609.6005859375, 0.738880276679992675, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Hungering Etherwyrm (Area: -Unknown- - Difficulty: 0) +(@CGUID+37, 168333, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4211.8935546875, -4541.69287109375, 6609.62939453125, 0.392837971448898315, 7200, 8, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Gildfur Bighorn (Area: -Unknown- - Difficulty: 0) +(@CGUID+38, 168613, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4210.9228515625, -4551.20263671875, 6706.15478515625, 2.00921940803527832, 7200, 0, 0, 10133, 0, 0, 0, 0, 0, 42010), -- Aurumane Larion (Area: -Unknown- - Difficulty: 0) +(@CGUID+39, 168397, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4251.84716796875, -4576.5693359375, 6545.26171875, 2.368716239929199218, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+40, 168333, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4153.373046875, -4549.384765625, 6616.7734375, 2.664845466613769531, 7200, 8, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Gildfur Bighorn (Area: -Unknown- - Difficulty: 0) +(@CGUID+41, 168410, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4154.97607421875, -4550.2021484375, 6616.3984375, 0.826810896396636962, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+42, 168268, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4154.39892578125, -4575.8095703125, 6613.62890625, 0.092172928154468536, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Spiritwing Glimmerfly (Area: 0 - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+43, 168437, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4232.55322265625, -4339.64501953125, 6585.80517578125, 2.798831462860107421, 7200, 4, 0, 27, 0, 1, 0, 0, 0, 42010), -- Riverfall Hatchling (Area: -Unknown- - Difficulty: 0) +(@CGUID+44, 168309, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4268.48828125, -4318.3017578125, 6597.22412109375, 0.662720143795013427, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010); -- Hungering Etherwyrm (Area: -Unknown- - Difficulty: 0) + +-- Creature Addon +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+44; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+24, 0, 0, 3, 1, 0, 0, 0, 0, 0, '350558'), -- Riverfall Terrapin - 350558 - -Unknown- +(@CGUID+1, 0, 0, 3, 1, 0, 0, 0, 0, 0, '350558'); -- Riverfall Terrapin - 350558 - -Unknown- + +-- Creature Movement Override +DELETE FROM `creature_movement_override` WHERE `SpawnId` IN (@CGUID+3, @CGUID+38); +INSERT INTO `creature_movement_override` (`SpawnId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`) VALUES +(@CGUID+3, 1, 0, 1, 0, 0, 0), +(@CGUID+38, 1, 0, 1, 0, 0, 0);
\ No newline at end of file |