diff options
author | Naddley <64811442+Naddley@users.noreply.github.com> | 2022-02-12 06:43:29 +0100 |
---|---|---|
committer | ModoX <moardox@gmail.com> | 2022-02-12 06:43:58 +0100 |
commit | 5b28a5ab14f3ca25f986d547e2d2005be3f047b7 (patch) | |
tree | 9a2566da794bbde10c84964e77374837ce99b376 | |
parent | f6280163c6b0da6c3cbeb280a0617dfd1433a90c (diff) |
DB/Spawns: Added some critters and passive mobs in Bastion intro area
Closes #27757
-rw-r--r-- | sql/updates/world/master/2022_02_12_00_world.sql | 194 |
1 files changed, 194 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_02_12_00_world.sql b/sql/updates/world/master/2022_02_12_00_world.sql new file mode 100644 index 00000000000..04d2a30b3b1 --- /dev/null +++ b/sql/updates/world/master/2022_02_12_00_world.sql @@ -0,0 +1,194 @@ +SET @CGUID := 1050590; + +-- Creature Spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+82; +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, 168731, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4431.88525390625, -4072.364501953125, 6563.69482421875, 3.666834831237792968, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Copperfur Lurker (Area: -Unknown- - Difficulty: 0) (Auras: 159510 - Cosmetic - Sleep Zzz Breakable) +(@CGUID+1, 172058, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4422.775390625, -4036.196044921875, 6557.6328125, 4.008443355560302734, 7200, 6, 0, 3210, 0, 1, 0, 0, 0, 42010), -- Malnourished Etherwyrm (Area: -Unknown- - Difficulty: 0) +(@CGUID+2, 172058, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4405.12060546875, -4083.64306640625, 6574.6044921875, 0.47355857491493225, 7200, 6, 0, 3210, 0, 1, 0, 0, 0, 42010), -- Malnourished Etherwyrm (Area: -Unknown- - Difficulty: 0) +(@CGUID+3, 168733, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4435.90966796875, -4073.603515625, 6563.515625, 3.306420326232910156, 7200, 4, 0, 27, 0, 1, 0, 0, 0, 42010), -- Copperfur Kit (Area: -Unknown- - Difficulty: 0) +(@CGUID+4, 168731, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4435.09033203125, -4079.55908203125, 6565.439453125, 2.502280473709106445, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Copperfur Lurker (Area: -Unknown- - Difficulty: 0) (Auras: 159510 - Cosmetic - Sleep Zzz Breakable) +(@CGUID+6, 168731, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4426.34619140625, -4085.848388671875, 6568.88720703125, 4.991494178771972656, 7200, 4, 0, 5404, 0, 1, 0, 0, 0, 42010), -- Copperfur Lurker (Area: -Unknown- - Difficulty: 0) +(@CGUID+7, 168624, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4415.267578125, -4006.6328125, 6545.0908203125, 3.618340253829956054, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+8, 171668, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4406.22119140625, -4039.896728515625, 6557.70849609375, 4.0962371826171875, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Vibrant Glimmerfly (Area: -Unknown- - Difficulty: 0) (Auras: 308853 - -Unknown-) +(@CGUID+9, 171664, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4417.673828125, -4062.065185546875, 6563.8388671875, 6.044602394104003906, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Fluttering Glimmerfly (Area: -Unknown- - Difficulty: 0) (Auras: 308853 - -Unknown-) +(@CGUID+10, 168733, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4431.11865234375, -4077.721435546875, 6565.3779296875, 3.70245671272277832, 7200, 4, 0, 27, 0, 1, 0, 0, 0, 42010), -- Copperfur Kit (Area: -Unknown- - Difficulty: 0) +(@CGUID+11, 168731, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4429.51953125, -4052.191650390625, 6557.6630859375, 3.226167917251586914, 7200, 2, 0, 5404, 0, 1, 0, 0, 0, 42010), -- Copperfur Lurker (Area: -Unknown- - Difficulty: 0) +(@CGUID+12, 168410, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4430.8916015625, -4107.5380859375, 6582.3369140625, 3.344356536865234375, 7200, 6, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+13, 168624, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4426.50634765625, -4107.36474609375, 6583.55810546875, 5.023136138916015625, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+14, 170008, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4467.6806640625, -4100.64501953125, 6569.3271484375, 2.693104982376098632, 7200, 6, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Goldenback Roamer (Area: -Unknown- - Difficulty: 0) +(@CGUID+15, 168309, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4468.27783203125, -4086.59912109375, 6604.373046875, 1.068947792053222656, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Hungering Etherwyrm (Area: -Unknown- - Difficulty: 0) +(@CGUID+16, 168410, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4396.18359375, -4100.22265625, 6572.515625, 5.187895774841308593, 7200, 6, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+17, 168915, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4474.52783203125, -4120.650390625, 6576.28759765625, 3.211926698684692382, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Field Everhopper (Area: -Unknown- - Difficulty: 0) +(@CGUID+18, 170008, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4425.55224609375, -4118.56591796875, 6584.69140625, 6.236546039581298828, 7200, 6, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Goldenback Roamer (Area: -Unknown- - Difficulty: 0) +(@CGUID+19, 172058, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4464.845703125, -4126.7138671875, 6589.8193359375, 5.886736869812011718, 7200, 6, 0, 3210, 0, 1, 0, 0, 0, 42010), -- Malnourished Etherwyrm (Area: -Unknown- - Difficulty: 0) +(@CGUID+20, 170008, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4424.119140625, -4142.548828125, 6587.40625, 5.213348388671875, 7200, 6, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Goldenback Roamer (Area: -Unknown- - Difficulty: 0) +(@CGUID+21, 168309, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4516.85205078125, -4085.926513671875, 6584.689453125, 5.07971954345703125, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Hungering Etherwyrm (Area: -Unknown- - Difficulty: 0) +(@CGUID+22, 168397, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4468.27587890625, -4156.0244140625, 6589.7099609375, 0.39407658576965332, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+23, 168731, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4474.80712890625, -4162.80224609375, 6590.59130859375, 3.474839210510253906, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Copperfur Lurker (Area: -Unknown- - Difficulty: 0) (Auras: 159510 - Cosmetic - Sleep Zzz Breakable) +(@CGUID+24, 170008, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4500.0888671875, -4139.33544921875, 6577.8876953125, 2.476610422134399414, 7200, 6, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Goldenback Roamer (Area: -Unknown- - Difficulty: 0) +(@CGUID+25, 171668, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4459.0947265625, -4166.9150390625, 6593.26513671875, 5.944086074829101562, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Vibrant Glimmerfly (Area: -Unknown- - Difficulty: 0) (Auras: 308853 - -Unknown-) +(@CGUID+26, 168397, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4521.83544921875, -4145.3857421875, 6577.2578125, 2.385837554931640625, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+27, 170008, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4525.65625, -4148.53662109375, 6577.0712890625, 1.768540382385253906, 7200, 6, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Goldenback Roamer (Area: -Unknown- - Difficulty: 0) +(@CGUID+28, 168733, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4478.6279296875, -4166.998046875, 6591.4228515625, 3.083233356475830078, 7200, 4, 0, 27, 0, 1, 0, 0, 0, 42010), -- Copperfur Kit (Area: -Unknown- - Difficulty: 0) +(@CGUID+29, 168731, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4477.86181640625, -4170.59521484375, 6592.2861328125, 2.505903959274291992, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Copperfur Lurker (Area: -Unknown- - Difficulty: 0) +(@CGUID+30, 172058, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4517.96875, -4165.298828125, 6592.126953125, 2.600980281829833984, 7200, 6, 0, 3210, 0, 1, 0, 0, 0, 42010), -- Malnourished Etherwyrm (Area: -Unknown- - Difficulty: 0) +(@CGUID+31, 168410, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4465.39404296875, -4198.4658203125, 6594.486328125, 5.078020095825195312, 7200, 6, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+32, 168397, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4546.71533203125, -4178.19140625, 6587.11279296875, 2.089859962463378906, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+33, 172058, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4549.27294921875, -4164.05322265625, 6586.8603515625, 0.718922674655914306, 7200, 6, 0, 3210, 0, 1, 0, 0, 0, 42010), -- Malnourished Etherwyrm (Area: -Unknown- - Difficulty: 0) +(@CGUID+34, 168410, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4534.66552734375, -4185.80029296875, 6592.90234375, 0.202370628714561462, 7200, 6, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+35, 168309, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4557.0966796875, -4157.796875, 6617.37255859375, 3.078995227813720703, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Hungering Etherwyrm (Area: -Unknown- - Difficulty: 0) +(@CGUID+36, 170008, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4479.9765625, -4208.36767578125, 6596.6337890625, 1.149992108345031738, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Goldenback Roamer (Area: -Unknown- - Difficulty: 0) +(@CGUID+37, 170008, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4533.7900390625, -4216.15283203125, 6602.61328125, 0.101309843361377716, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Goldenback Roamer (Area: -Unknown- - Difficulty: 0) +(@CGUID+38, 168624, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4531.14306640625, -4229.0615234375, 6606.09716796875, 1.759407758712768554, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+39, 168890, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4537.3212890625, -4231.998046875, 6605.416015625, 1.803453326225280761, 7200, 0, 0, 13510, 0, 0, 0, 0, 0, 42010), -- Goldenback Stag (Area: -Unknown- - Difficulty: 0) +(@CGUID+40, 172058, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4486.9443359375, -4247.96044921875, 6604.72998046875, 1.342966318130493164, 7200, 6, 0, 3210, 0, 1, 0, 0, 0, 42010), -- Malnourished Etherwyrm (Area: -Unknown- - Difficulty: 0) +(@CGUID+41, 170008, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4545.7060546875, -4247.8134765625, 6607.890625, 3.67430734634399414, 7200, 6, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Goldenback Roamer (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+42, 170008, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4577.68408203125, -4196.763671875, 6588.3701171875, 0.420007228851318359, 7200, 6, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Goldenback Roamer (Area: -Unknown- - Difficulty: 0) +(@CGUID+43, 168915, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4554.345703125, -4225.17822265625, 6601.09033203125, 0.585927367210388183, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Field Everhopper (Area: -Unknown- - Difficulty: 0) +(@CGUID+44, 168410, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4553.76513671875, -4270.529296875, 6611.0517578125, 3.739351272583007812, 7200, 6, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+45, 168624, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4567.53564453125, -4251.96875, 6605.5224609375, 2.47979140281677246, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+46, 168915, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4605.24169921875, -4220.126953125, 6590.68701171875, 2.251028299331665039, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Field Everhopper (Area: -Unknown- - Difficulty: 0) +(@CGUID+47, 168731, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4599.62158203125, -4260.3056640625, 6601.6708984375, 6.197541713714599609, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Copperfur Lurker (Area: -Unknown- - Difficulty: 0) (Auras: 159510 - Cosmetic - Sleep Zzz Breakable) +(@CGUID+48, 168624, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4513.89501953125, -4281.77978515625, 6615.74951171875, 4.979505538940429687, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+49, 170008, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4614.3125, -4228.22509765625, 6590.16259765625, 3.526174783706665039, 7200, 6, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Goldenback Roamer (Area: -Unknown- - Difficulty: 0) +(@CGUID+50, 172058, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4531.0341796875, -4279.3427734375, 6619.55615234375, 5.411814689636230468, 7200, 6, 0, 3210, 0, 1, 0, 0, 0, 42010), -- Malnourished Etherwyrm (Area: -Unknown- - Difficulty: 0) +(@CGUID+51, 168397, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4556.65869140625, -4287.78076171875, 6616.0107421875, 4.415648937225341796, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+52, 168731, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4596.97216796875, -4266.080078125, 6603.52734375, 0.810189545154571533, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Copperfur Lurker (Area: -Unknown- - Difficulty: 0) (Auras: 159510 - Cosmetic - Sleep Zzz Breakable) +(@CGUID+53, 168733, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4597.26708984375, -4263.60302734375, 6602.9384765625, 4.392368793487548828, 7200, 4, 0, 27, 0, 1, 0, 0, 0, 42010), -- Copperfur Kit (Area: -Unknown- - Difficulty: 0) +(@CGUID+54, 168624, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4590.7490234375, -4274.650390625, 6608.38818359375, 2.361420631408691406, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+55, 168731, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4588.703125, -4288.12646484375, 6609.0791015625, 3.874563217163085937, 7200, 0, 0, 5404, 0, 0, 0, 0, 0, 42010), -- Copperfur Lurker (Area: -Unknown- - Difficulty: 0) +(@CGUID+56, 168410, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4492.806640625, -4292.732421875, 6604.951171875, 6.025831222534179687, 7200, 6, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+57, 170008, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4567.81201171875, -4303.474609375, 6616.0322265625, 4.471552848815917968, 7200, 6, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Goldenback Roamer (Area: -Unknown- - Difficulty: 0) +(@CGUID+58, 168624, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4586.54833984375, -4298.40966796875, 6611.29345703125, 4.0377349853515625, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+59, 170008, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4494.66748046875, -4328.9716796875, 6610.2626953125, 3.188524961471557617, 7200, 6, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Goldenback Roamer (Area: -Unknown- - Difficulty: 0) +(@CGUID+60, 170008, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4539.75927734375, -4352.98388671875, 6607.80078125, 2.489110946655273437, 7200, 6, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Goldenback Roamer (Area: -Unknown- - Difficulty: 0) +(@CGUID+61, 168309, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4580.203125, -4361.69677734375, 6604.72021484375, 1.815838575363159179, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Hungering Etherwyrm (Area: -Unknown- - Difficulty: 0) +(@CGUID+62, 168624, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4484.904296875, -4348.68310546875, 6605.576171875, 0.32877284288406372, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+63, 168890, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4472.033203125, -4337.04345703125, 6600.8486328125, 5.058688163757324218, 7200, 0, 0, 13510, 0, 0, 0, 0, 0, 42010), -- Goldenback Stag (Area: -Unknown- - Difficulty: 0) +(@CGUID+64, 168410, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4537.0478515625, -4381.34765625, 6610.6982421875, 4.737774372100830078, 7200, 6, 0, 5, 0, 1, 0, 0, 0, 42010), -- Aureate Peachick (Area: -Unknown- - Difficulty: 0) +(@CGUID+65, 170008, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4476.03662109375, -4351.3037109375, 6603.80078125, 1.768540382385253906, 7200, 6, 0, 6755, 0, 1, 0, 0, 0, 42010), -- Goldenback Roamer (Area: -Unknown- - Difficulty: 0) +(@CGUID+66, 168397, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4559.70556640625, -4369.30517578125, 6605.0888671875, 1.454816579818725585, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+67, 168915, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4517.6591796875, -4363.2412109375, 6610.48486328125, 4.964943408966064453, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 42010), -- Field Everhopper (Area: -Unknown- - Difficulty: 0) +(@CGUID+68, 172058, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4513.671875, -4384.93115234375, 6616.861328125, 5.796586036682128906, 7200, 6, 0, 3210, 0, 1, 0, 0, 0, 42010), -- Malnourished Etherwyrm (Area: -Unknown- - Difficulty: 0) +(@CGUID+69, 168397, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4487.27099609375, -4385.61474609375, 6608.11669921875, 1.524385333061218261, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+70, 172058, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4474.79638671875, -4368.02734375, 6613.42578125, 5.182179927825927734, 7200, 6, 0, 3210, 0, 1, 0, 0, 0, 42010), -- Malnourished Etherwyrm (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+71, 168309, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4483.22900390625, -4379.02880859375, 6634.33349609375, 0.91653519868850708, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Hungering Etherwyrm (Area: -Unknown- - Difficulty: 0) +(@CGUID+72, 170399, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4548.73291015625, -4420.330078125, 6546.1201171875, 0, 7200, 3, 0, 2702, 0, 1, 0, 0, 0, 42010), -- Eternal Flutterer (Area: -Unknown- - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+73, 169572, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4564.65185546875, -4438.5068359375, 6532.44970703125, 0.267263650894165039, 7200, 6, 0, 14, 0, 1, 0, 0, 0, 42010), -- Shriveled Wyrmling (Area: -Unknown- - Difficulty: 0) +(@CGUID+74, 170399, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4605.986328125, -4426.55224609375, 6531.1767578125, 0, 7200, 0, 0, 2702, 0, 0, 0, 0, 0, 42010), -- Eternal Flutterer (Area: -Unknown- - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+75, 169572, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4587.87158203125, -4428.875, 6508.2744140625, 2.408193349838256835, 7200, 6, 0, 14, 0, 1, 0, 0, 0, 42010), -- Shriveled Wyrmling (Area: -Unknown- - Difficulty: 0) +(@CGUID+76, 169572, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4579.8212890625, -4448.82666015625, 6503.62548828125, 5.032820701599121093, 7200, 6, 0, 14, 0, 1, 0, 0, 0, 42010), -- Shriveled Wyrmling (Area: -Unknown- - Difficulty: 0) +(@CGUID+77, 168397, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4586.6357421875, -4450.2060546875, 6500.03466796875, 5.866970539093017578, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+78, 170399, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4559.12890625, -4455.17578125, 6521.25, 0.803411483764648437, 7200, 3, 0, 2702, 0, 1, 0, 0, 0, 42010), -- Eternal Flutterer (Area: -Unknown- - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+79, 168309, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4563.86328125, -4440.0244140625, 6580.2919921875, 0.432391464710235595, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Hungering Etherwyrm (Area: -Unknown- - Difficulty: 0) +(@CGUID+80, 170399, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4530.63232421875, -4454.072265625, 6542.41748046875, 2.156455278396606445, 7200, 3, 0, 2702, 0, 1, 0, 0, 0, 42010), -- Eternal Flutterer (Area: -Unknown- - Difficulty: 0) (Auras: 312748 - -Unknown-) +(@CGUID+81, 168309, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4473.70556640625, -4271.44482421875, 6630.43408203125, 4.3279266357421875, 7200, 0, 0, 6755, 0, 0, 0, 0, 0, 42010), -- Hungering Etherwyrm (Area: -Unknown- - Difficulty: 0) +(@CGUID+82, 168624, 2222, 10534, 10534, '0', 0, 0, 0, 0, -4442.880859375, -4351.0986328125, 6594.76904296875, 1.169716715812683105, 7200, 3, 0, 5, 0, 1, 0, 0, 0, 42010); -- Spiritwing Flitter (Area: -Unknown- - Difficulty: 0) + +-- Creature_Template_Addon Data +DELETE FROM `creature_template_addon` WHERE `entry` IN (169572, 170399, 168397, 168309, 171664, 171668, 168624, 172058); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(169572, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- 169572 (Shriveled Wyrmling) +(170399, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, '312748'), -- 170399 (Eternal Flutterer) - -Unknown- +(168397, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- 168397 (Soulwing Flitter) +(168309, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- 168309 (Hungering Etherwyrm) +(171664, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, '308853'), -- 171664 (Fluttering Glimmerfly) - -Unknown- +(171668, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, '308853'), -- 171668 (Vibrant Glimmerfly) - -Unknown- +(168624, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''), -- 168624 (Spiritwing Flitter) +(172058, 0, 0, 50331648, 1, 0, 0, 0, 0, 0, ''); -- 172058 (Malnourished Etherwyrm) + +-- Creature Addon +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+82; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+0, 0, 0, 0, 1, 0, 0, 0, 0, 0, '159510'), -- Copperfur Lurker - 159510 - Cosmetic - Sleep Zzz Breakable +(@CGUID+4, 0, 0, 0, 1, 0, 0, 0, 0, 0, '159510'), -- Copperfur Lurker - 159510 - Cosmetic - Sleep Zzz Breakable +(@CGUID+23, 0, 0, 0, 1, 0, 0, 0, 0, 0, '159510'), -- Copperfur Lurker - 159510 - Cosmetic - Sleep Zzz Breakable +(@CGUID+52, 0, 0, 0, 1, 0, 0, 0, 0, 0, '159510'), -- Copperfur Lurker - 159510 - Cosmetic - Sleep Zzz Breakable +(@CGUID+47, 0, 0, 0, 1, 0, 0, 0, 0, 0, '159510'); -- Copperfur Lurker - 159510 - Cosmetic - Sleep Zzz Breakable + +-- Creature Movement +DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (172058, 168309, 169572); +INSERT INTO `creature_template_movement`(`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`) VALUES +(172058, 1, 0, 1, 0, 0, 0), +(168309, 1, 0, 1, 0, 0, 0), +(169572, 1, 0, 1, 0, 0, 0); + +-- Waypoints for @CGUID+39 +SET @PATH := @CGUID+39 * 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, -4542.45, -4214.8, 6601.11, 0, 0, 0, 0, 100, 0), +(@PATH, 1, -4547.31, -4206.65, 6597.69, 0, 41580, 0, 0, 100, 0), +(@PATH, 2, -4565.93, -4204.7, 6592, 0, 0, 0, 0, 100, 0), +(@PATH, 3, -4569.18, -4212.43, 6594.03, 0, 0, 0, 0, 100, 0), +(@PATH, 4, -4572.49, -4221.36, 6596.21, 0, 0, 0, 0, 100, 0), +(@PATH, 5, -4575.07, -4230.75, 6598.67, 0, 0, 0, 0, 100, 0), +(@PATH, 6, -4577.27, -4238.87, 6600.75, 0, 0, 0, 0, 100, 0), +(@PATH, 7, -4577.37, -4245.82, 6602.88, 0, 0, 0, 0, 100, 0), +(@PATH, 8, -4576.76, -4256.8, 6606.5, 0, 0, 0, 0, 100, 0), +(@PATH, 9, -4574.97, -4267.75, 6609.58, 0, 0, 0, 0, 100, 0), +(@PATH, 10, -4572.11, -4277.88, 6611.77, 0, 0, 0, 0, 100, 0), +(@PATH, 11, -4568.96, -4286.4, 6613.79, 0, 0, 0, 0, 100, 0), +(@PATH, 12, -4565.25, -4298.75, 6616.03, 0, 0, 0, 0, 100, 0), +(@PATH, 13, -4562.27, -4308.52, 6616.99, 0, 0, 0, 0, 100, 0), +(@PATH, 14, -4559.71, -4317.91, 6617.1, 0, 36744, 0, 0, 100, 0), +(@PATH, 15, -4543.82, -4303.63, 6618.43, 0, 0, 0, 0, 100, 0), +(@PATH, 16, -4540.05, -4297.92, 6617.53, 0, 0, 0, 0, 100, 0), +(@PATH, 17, -4538.19, -4292.58, 6616.93, 0, 0, 0, 0, 100, 0), +(@PATH, 18, -4538.14, -4285.73, 6616.35, 0, 0, 0, 0, 100, 0), +(@PATH, 19, -4537.7, -4277.79, 6615.19, 0, 0, 0, 0, 100, 0), +(@PATH, 20, -4536.43, -4267.11, 6612.88, 0, 0, 0, 0, 100, 0), +(@PATH, 21, -4535.73, -4259.63, 6611.3, 0, 0, 0, 0, 100, 0), +(@PATH, 22, -4535.56, -4253.19, 6609.85, 0, 0, 0, 0, 100, 0), +(@PATH, 23, -4535.12, -4244.64, 6607.93, 0, 0, 0, 0, 100, 0), +(@PATH, 24, -4536.58, -4235.11, 6606.06, 0, 0, 0, 0, 100, 0), +(@PATH, 25, -4539.06, -4224.7, 6603.89, 0, 0, 0, 0, 100, 0); + +UPDATE `creature` SET `position_x`= -4542.452, `position_y`= -4214.8, `position_z`= 6601.111, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+39; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+39; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+39, @PATH, 1); + +-- Waypoints for @CGUID+63 +SET @PATH := @CGUID+63 * 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, -4477.09, -4323.08, 6604.13, 0, 0, 0, 0, 100, 0), +(@PATH, 1, -4479.87, -4313.05, 6604.41, 0, 0, 0, 0, 100, 0), +(@PATH, 2, -4481.42, -4305.79, 6603.91, 0, 0, 0, 0, 100, 0), +(@PATH, 3, -4483.43, -4296.44, 6603.13, 0, 0, 0, 0, 100, 0), +(@PATH, 4, -4486.43, -4285.52, 6602.45, 0, 0, 0, 0, 100, 0), +(@PATH, 5, -4489.03, -4274.78, 6601.72, 0, 0, 0, 0, 100, 0), +(@PATH, 6, -4492.78, -4262.81, 6601.8, 0, 0, 0, 0, 100, 0), +(@PATH, 7, -4494.85, -4251.52, 6602.17, 0, 0, 0, 0, 100, 0), +(@PATH, 8, -4495.46, -4242.72, 6601.88, 0, 0, 0, 0, 100, 0), +(@PATH, 9, -4496.08, -4233.31, 6601.34, 0, 0, 0, 0, 100, 0), +(@PATH, 10, -4499.67, -4224.85, 6601.17, 0, 0, 0, 0, 100, 0), +(@PATH, 11, -4504.15, -4218.66, 6599.63, 0, 0, 0, 0, 100, 0), +(@PATH, 12, -4506.61, -4216.25, 6599.03, 0, 0, 0, 0, 100, 0), +(@PATH, 13, -4507.81, -4215.92, 6598.76, 0, 20556, 0, 0, 100, 0), +(@PATH, 14, -4500.54, -4219.3, 6600.27, 0, 0, 0, 0, 100, 0), +(@PATH, 15, -4495.09, -4222.68, 6600.82, 0, 0, 0, 0, 100, 0), +(@PATH, 16, -4487.71, -4224.91, 6599.3, 0, 0, 0, 0, 100, 0), +(@PATH, 17, -4481.49, -4224.65, 6597.81, 0, 0, 0, 0, 100, 0), +(@PATH, 18, -4475.36, -4223.6, 6596.33, 0, 0, 0, 0, 100, 0), +(@PATH, 19, -4469.31, -4220.53, 6595.5, 0, 0, 0, 0, 100, 0), +(@PATH, 20, -4465.4, -4217.41, 6595.44, 0, 24767, 0, 0, 100, 0), +(@PATH, 21, -4472.77, -4234.76, 6595.26, 0, 0, 0, 0, 100, 0), +(@PATH, 22, -4475.34, -4243.96, 6595.96, 0, 0, 0, 0, 100, 0), +(@PATH, 23, -4478.06, -4257.62, 6596.87, 0, 0, 0, 0, 100, 0), +(@PATH, 24, -4478.63, -4269, 6597.56, 0, 0, 0, 0, 100, 0), +(@PATH, 25, -4479.09, -4282.25, 6598.34, 0, 0, 0, 0, 100, 0), +(@PATH, 26, -4479.12, -4294.67, 6600.45, 0, 0, 0, 0, 100, 0), +(@PATH, 27, -4476.41, -4304.78, 6601.41, 0, 0, 0, 0, 100, 0), +(@PATH, 28, -4474.88, -4312.75, 6602.48, 0, 0, 0, 0, 100, 0), +(@PATH, 29, -4474.59, -4320.2, 6603.1, 0, 0, 0, 0, 100, 0), +(@PATH, 30, -4474.42, -4326.62, 6602.9, 0, 0, 0, 0, 100, 0), +(@PATH, 31, -4473.65, -4332.57, 6601.82, 0, 0, 0, 0, 100, 0), +(@PATH, 32, -4472.03, -4337.04, 6600.85, 0, 16780, 0, 0, 100, 0); + +UPDATE `creature` SET `position_x`= -4477.092, `position_y`= -4323.083, `position_z`= 6604.133, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+63; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+63; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+63, @PATH, 1); |