diff options
| author | Aqua Deus <95978183+aquadeus@users.noreply.github.com> | 2023-07-05 00:47:01 +0200 |
|---|---|---|
| committer | Naddley <NaddleyTC@gmail.com> | 2023-07-05 00:47:11 +0200 |
| commit | d48ed9589072da068cc2c134a953bd2510ceb9ff (patch) | |
| tree | 9c2463d4e24465909e3f2cbdb69ec02a4d1a7d39 | |
| parent | 074c5da6e43796a88ad34e8724362433d5109f88 (diff) | |
DB/Azsuna: Added spawns for Oceanus Cove
Closes #28570
| -rw-r--r-- | sql/updates/world/master/2023_07_05_00_world.sql | 1278 |
1 files changed, 1278 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_07_05_00_world.sql b/sql/updates/world/master/2023_07_05_00_world.sql new file mode 100644 index 00000000000..57653a3185f --- /dev/null +++ b/sql/updates/world/master/2023_07_05_00_world.sql @@ -0,0 +1,1278 @@ +SET @CGUID := 651886; +SET @OGUID := 400549; + +-- Creature +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+244; +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`, `VerifiedBuild`) VALUES +(@CGUID+0, 89101, 1220, 7334, 7521, '0', 0, 0, 0, 1, -1008.50872802734375, 6294.37841796875, 28.78668975830078125, 0.757367849349975585, 120, 0, 0, 56470, 0, 0, 0, 0, 46702), -- Prince Oceanus (Area: Old Coast Path - Difficulty: 0) +(@CGUID+1, 91528, 1220, 7334, 7348, '0', 0, 0, 0, 1, -760.373291015625, 6915.52099609375, 7.603428363800048828, 0.351358294486999511, 120, 0, 0, 3953, 0, 0, 0, 0, 46702), -- Southsea Smuggler (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+2, 91528, 1220, 7334, 7348, '0', 0, 0, 0, 1, -758.4149169921875, 6909.41845703125, 9.510894775390625, 5.800727367401123046, 120, 0, 0, 3953, 0, 0, 0, 0, 46702), -- Southsea Smuggler (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+3, 97289, 1220, 7334, 7521, '0', 0, 0, 0, 0, -708.7291259765625, 6236.5625, 4.746686935424804687, 3.792521476745605468, 120, 0, 0, 27, 0, 0, 0, 0, 46702), -- Juvenile Scuttleback (Area: Old Coast Path - Difficulty: 0) +(@CGUID+4, 89097, 1220, 7334, 7521, '0', 0, 0, 0, 1, -790.0086669921875, 6325.9921875, 0.57430267333984375, 3.694494009017944335, 120, 0, 0, 56470, 0, 0, 0, 0, 46702), -- Cove Skrog (Area: Old Coast Path - Difficulty: 0) +(@CGUID+5, 101554, 1220, 7334, 7521, '0', 0, 0, 0, 0, -717.39154052734375, 6234.41748046875, 4.609724044799804687, 0.975751638412475585, 120, 0, 0, 5647, 0, 0, 0, 0, 46702), -- Spikebacked Scuttler (Area: Old Coast Path - Difficulty: 0) +(@CGUID+6, 89097, 1220, 7334, 7521, '0', 0, 0, 0, 1, -814.11285400390625, 6310.703125, 2.565588951110839843, 6.274301528930664062, 120, 0, 0, 56470, 0, 0, 0, 0, 46702), -- Cove Skrog (Area: Old Coast Path - Difficulty: 0) +(@CGUID+7, 101554, 1220, 7334, 7521, '0', 0, 0, 0, 0, -748.9068603515625, 6272.1044921875, 0.385496139526367187, 3.01142740249633789, 120, 0, 0, 5647, 0, 0, 0, 0, 46702), -- Spikebacked Scuttler (Area: Old Coast Path - Difficulty: 0) +(@CGUID+8, 101554, 1220, 7334, 7521, '0', 0, 0, 0, 0, -788.2890625, 6258.0048828125, 0.381948709487915039, 3.749250173568725585, 120, 0, 0, 5647, 0, 0, 0, 0, 46702), -- Spikebacked Scuttler (Area: Old Coast Path - Difficulty: 0) +(@CGUID+9, 97283, 1220, 7334, 7521, '0', 0, 0, 0, 0, -791.63824462890625, 6300.830078125, 0.57430267333984375, 1.223805189132690429, 120, 0, 0, 1, 0, 0, 0, 0, 46702), -- Juvenile Scuttleback (Area: Old Coast Path - Difficulty: 0) +(@CGUID+10, 101554, 1220, 7334, 7521, '0', 0, 0, 0, 0, -814.90789794921875, 6275.4208984375, -0.35774451494216918, 4.481857776641845703, 120, 0, 0, 5647, 0, 0, 0, 0, 46702), -- Spikebacked Scuttler (Area: Old Coast Path - Difficulty: 0) +(@CGUID+11, 89097, 1220, 7334, 7521, '0', 0, 0, 0, 1, -864.703125, 6373.6728515625, 3.87999892234802246, 2.574114322662353515, 120, 0, 0, 56470, 0, 0, 0, 0, 46702), -- Cove Skrog (Area: Old Coast Path - Difficulty: 0) +(@CGUID+12, 101554, 1220, 7334, 7521, '0', 0, 0, 0, 0, -782.5721435546875, 6302.55517578125, 0.651958882808685302, 0.020223518833518028, 120, 0, 0, 5647, 0, 0, 0, 0, 46702), -- Spikebacked Scuttler (Area: Old Coast Path - Difficulty: 0) +(@CGUID+13, 101554, 1220, 7334, 7348, '0', 0, 0, 0, 0, -802.04473876953125, 6349.296875, 3.95349431037902832, 6.081725120544433593, 120, 10, 0, 5647, 0, 1, 0, 0, 46702), -- Spikebacked Scuttler (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+14, 97289, 1220, 7334, 7348, '0', 0, 0, 0, 0, -846.724365234375, 6348.376953125, 6.393026351928710937, 3.455313920974731445, 120, 10, 0, 27, 0, 1, 0, 0, 46702), -- Juvenile Scuttleback (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+15, 89097, 1220, 7334, 7348, '0', 0, 0, 0, 1, -802.0608, 6492.027, 0.673588, 4.857522964477539062, 120, 0, 0, 56470, 0, 2, 0, 0, 46702), -- Cove Skrog (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+16, 97283, 1220, 7334, 7348, '0', 0, 0, 0, 0, -807.83538818359375, 6404.0029296875, 3.720440149307250976, 1.308055400848388671, 120, 10, 0, 1, 0, 1, 0, 0, 46702), -- Juvenile Scuttleback (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+17, 64352, 1220, 7334, 7348, '0', 0, 0, 0, 0, -887.58837890625, 6361.341796875, 7.470587730407714843, 3.655896186828613281, 120, 10, 0, 5, 0, 1, 0, 0, 46702), -- Rapana Whelk (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+18, 89097, 1220, 7334, 7348, '0', 0, 0, 0, 1, -960.375, 6466.47314453125, 1.742544770240783691, 1.486965656280517578, 120, 0, 0, 56470, 0, 0, 0, 0, 46702), -- Cove Skrog (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+19, 64806, 1220, 7334, 7348, '0', 0, 0, 0, 0, -962.893310546875, 6306.583984375, 29.54188728332519531, 0.016600036993622779, 120, 0, 0, 5, 0, 0, 0, 0, 46702), -- Rapana Whelk (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+20, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -861.140625, 6438.4287109375, 6.878919601440429687, 1.098822355270385742, 120, 0, 0, 5647, 0, 0, 0, 0, 46702), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+21, 97289, 1220, 7334, 7348, '0', 0, 0, 0, 0, -982.9354248046875, 6358.7626953125, 28.59468650817871093, 0.488479673862457275, 120, 0, 0, 27, 0, 0, 0, 0, 46702), -- Juvenile Scuttleback (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+22, 64806, 1220, 7334, 7348, '0', 0, 0, 0, 0, -936.84075927734375, 6411.73046875, 10.63226127624511718, 0.216550320386886596, 120, 10, 0, 5, 0, 1, 0, 0, 46702), -- Rapana Whelk (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+23, 97289, 1220, 7334, 7348, '0', 0, 0, 0, 0, -896.488525390625, 6456.45947265625, 1.0827789306640625, 2.68580174446105957, 120, 10, 0, 27, 0, 1, 0, 0, 46702), -- Juvenile Scuttleback (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+24, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -907.5347, 6470.977, 0.9999864, 2.055315971374511718, 120, 0, 0, 5647, 0, 2, 0, 0, 46702), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+25, 89097, 1220, 7334, 7348, '0', 0, 0, 0, 1, -1082.6875, 6488.03369140625, 9.104984283447265625, 2.700007915496826171, 120, 0, 0, 56470, 0, 0, 0, 0, 46702), -- Cove Skrog (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+26, 89097, 1220, 7334, 7348, '0', 0, 0, 0, 1, -950.684, 6527.042, 0.258884, 4.751309394836425781, 120, 0, 0, 56470, 0, 2, 0, 0, 46702), -- Cove Skrog (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+27, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -905.5716, 6477.982, 0.9999864, 1.55898439884185791, 120, 0, 0, 5647, 0, 0, 0, 0, 46702), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+28, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -876.8055419921875, 6466.0927734375, 5.998051643371582031, 1.450535416603088378, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+29, 89104, 1220, 7334, 7348, '0', 0, 0, 0, 1, -886.59552001953125, 6468.56494140625, 4.401131153106689453, 0.699903249740600585, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+30, 97289, 1220, 7334, 7348, '0', 0, 0, 0, 0, -932.0689697265625, 6481.9990234375, 6.868154525756835937, 3.509957790374755859, 120, 10, 0, 27, 0, 1, 0, 0, 46702), -- Juvenile Scuttleback (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+31, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -830.88714599609375, 6438.3603515625, 1.621919035911560058, 1.354182243347167968, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+32, 89104, 1220, 7334, 7348, '0', 0, 0, 0, 1, -857.82464599609375, 6460.01416015625, 12.46171760559082031, 6.256319999694824218, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+33, 89097, 1220, 7334, 7348, '0', 0, 0, 0, 1, -906.5711669921875, 6583.45654296875, -0.65778160095214843, 4.1167144775390625, 120, 0, 0, 56470, 0, 0, 0, 0, 46702), -- Cove Skrog (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+34, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -848.93402099609375, 6444.08056640625, 4.264596939086914062, 0.708338499069213867, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+35, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -896.72222900390625, 6497.2958984375, 2.574015140533447265, 6.19969940185546875, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+36, 89097, 1220, 7334, 7348, '0', 0, 0, 0, 1, -974.19964599609375, 6582.08837890625, 0.777723968029022216, 3.108411550521850585, 120, 0, 0, 56470, 0, 0, 0, 0, 46702), -- Cove Skrog (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+37, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -896.94793701171875, 6494.4931640625, 2.99146270751953125, 3.2257537841796875, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+38, 89111, 1220, 7334, 7348, '0', 0, 0, 0, 1, -850.55035400390625, 6500.5556640625, 8.430142402648925781, 4.962922096252441406, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+39, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -889.2882080078125, 6504.783203125, 1.046247124671936035, 5.021486282348632812, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+40, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -868.3680419921875, 6493.22900390625, 10.29804420471191406, 4.867645263671875, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+41, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -901.1719, 6491.491, 1.968736, 5.355109214782714843, 120, 0, 0, 5647, 0, 2, 0, 0, 46702), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+42, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -874.9583, 6624.446, 0.4067106, 3.955278873443603515, 120, 0, 0, 5647, 0, 2, 0, 0, 46702), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+43, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -874.6189, 6624.413, 0.6506379, 3.95460820198059082, 120, 0, 0, 5647, 0, 0, 0, 0, 46702), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+44, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -850.84552001953125, 6517.81591796875, 4.085549831390380859, 4.691881179809570312, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+45, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -867.34722900390625, 6513.93408203125, 4.30560302734375, 4.937313079833984375, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+46, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -784.84722900390625, 6457.1494140625, -0.58114659786224365, 5.538644790649414062, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+47, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -742.16668701171875, 6505.36181640625, -2.43447351455688476, 4.944809913635253906, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+48, 64806, 1220, 7334, 7348, '0', 0, 0, 0, 0, -815.6107177734375, 6485.9658203125, 3.011422634124755859, 5.2409515380859375, 120, 10, 0, 5, 0, 1, 0, 0, 46702), -- Rapana Whelk (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+49, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -793.98785400390625, 6511.17431640625, 2.218703985214233398, 1.406742453575134277, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+50, 64806, 1220, 7334, 7348, '0', 0, 0, 0, 0, -862.490478515625, 6535.21630859375, 1.837960362434387207, 2.672400951385498046, 120, 10, 0, 5, 0, 1, 0, 0, 46702), -- Rapana Whelk (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+51, 89111, 1220, 7334, 7348, '0', 0, 0, 0, 1, -767.7569580078125, 6462.94091796875, -5.58218669891357421, 4.775942802429199218, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+52, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -813.45831298828125, 6540.51416015625, 5.864685535430908203, 0.019272763282060623, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+53, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -829.2483, 6548.671, 4.224971, 5.701677322387695312, 120, 0, 0, 5647, 0, 2, 0, 0, 46702), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+54, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -759.54168701171875, 6498.59228515625, -2.75352334976196289, 1.123551130294799804, 120, 0, 0, 5647, 0, 0, 0, 0, 46702), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+55, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -913.00177001953125, 6536.47998046875, -0.65778267383575439, 4.088678359985351562, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+56, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -926.30035400390625, 6538.96337890625, -0.65778267383575439, 5.64591217041015625, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+57, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -918.1944580078125, 6538.16650390625, -0.65778267383575439, 3.308106184005737304, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+58, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -914.21527099609375, 6544.24462890625, -0.65778267383575439, 0.185318470001220703, 120, 0, 0, 5647, 0, 0, 0, 0, 46702), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+59, 89104, 1220, 7334, 7348, '0', 0, 0, 0, 1, -977.7586669921875, 6529.32275390625, 9.443813323974609375, 2.502672672271728515, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+60, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -957.033, 6516.28, 0.8831516, 0.148116722702980041, 120, 0, 0, 5647, 0, 2, 0, 0, 46702), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+61, 89110, 1220, 7334, 7348, '0', 0, 0, 0, 1, -991.07464599609375, 6512.93212890625, 8.936032295227050781, 3.992903709411621093, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+62, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -976.40625, 6522.85400390625, 4.548275947570800781, 2.706159353256225585, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+63, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -981.451416015625, 6517.57275390625, 5.724842548370361328, 4.486578941345214843, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+64, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -992.57464599609375, 6528.64306640625, 12.18358230590820312, 1.829253911972045898, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+65, 89111, 1220, 7334, 7348, '0', 0, 0, 0, 1, -1007.59722900390625, 6524.03125, 12.63854503631591796, 3.40159916877746582, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+66, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -999.685791015625, 6511.751953125, 9.282024383544921875, 1.721313357353210449, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+67, 97289, 1220, 7334, 7348, '0', 0, 0, 0, 0, -944.5845947265625, 6572.0341796875, -0.42045703530311584, 3.268854141235351562, 120, 10, 0, 27, 0, 1, 0, 0, 46702), -- Juvenile Scuttleback (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+68, 97018, 1220, 7334, 7348, '0', 0, 0, 0, 0, -991.0537109375, 6638.6669921875, 21.69032669067382812, 5.14017343521118164, 120, 10, 0, 27, 0, 1, 0, 0, 46702), -- Albatross Chick (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+69, 89097, 1220, 7334, 7348, '0', 0, 0, 0, 1, -882.8211669921875, 6710.7724609375, 6.66353464126586914, 5.292879581451416015, 120, 0, 0, 56470, 0, 0, 0, 0, 46702), -- Cove Skrog (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+70, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -947.58160400390625, 6639.76123046875, 3.984517335891723632, 3.403933525085449218, 120, 0, 0, 5647, 0, 0, 0, 0, 46702), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+71, 64806, 1220, 7334, 7348, '0', 0, 0, 0, 0, -865.94744873046875, 6619.87109375, 0.421855926513671875, 4.446200847625732421, 120, 10, 0, 5, 0, 1, 0, 0, 46702), -- Rapana Whelk (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+72, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -804.53125, 6568.1962890625, 10.47701168060302734, 5.843165874481201171, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+73, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -808.7586669921875, 6574.81005859375, 9.225521087646484375, 0.635065376758575439, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+74, 97289, 1220, 7334, 7348, '0', 0, 0, 0, 0, -815.7935791015625, 6588.62451171875, 4.330504417419433593, 4.827899932861328125, 120, 10, 0, 27, 0, 1, 0, 0, 46702), -- Juvenile Scuttleback (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+75, 89097, 1220, 7334, 7348, '0', 0, 0, 0, 1, -676.4549, 6603.991, -3.855994, 3.254719495773315429, 120, 0, 0, 56470, 0, 2, 0, 0, 46702), -- Cove Skrog (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+76, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -939.47393798828125, 6657.8896484375, 6.849045753479003906, 1.756753087043762207, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+77, 89111, 1220, 7334, 7348, '0', 0, 0, 0, 1, -947.8194580078125, 6654.12060546875, 4.87050485610961914, 2.502951622009277343, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+78, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -957.5867919921875, 6656.82568359375, 5.896479129791259765, 1.030628919601440429, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+79, 89386, 1220, 7334, 7348, '0', 0, 0, 0, 0, -973.8125, 6690.0322265625, 39.34669876098632812, 3.802817821502685546, 120, 0, 0, 6776, 0, 0, 0, 0, 46702), -- Cliffwing Hippogryph (Area: Oceanus Cove - Difficulty: 0) (Auras: ) +(@CGUID+80, 97289, 1220, 7334, 7348, '0', 0, 0, 0, 0, -932.11639404296875, 6654.37548828125, 6.609972000122070312, 1.476863503456115722, 120, 10, 0, 27, 0, 1, 0, 0, 46702), -- Juvenile Scuttleback (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+81, 89097, 1220, 7334, 7348, '0', 0, 0, 0, 1, -919.19097900390625, 6774.01123046875, 41.80742645263671875, 3.968492984771728515, 120, 0, 0, 56470, 0, 0, 0, 0, 46702), -- Cove Skrog (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+82, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -935.28302001953125, 6671.783203125, 16.48830413818359375, 2.76086282730102539, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+83, 89111, 1220, 7334, 7348, '0', 0, 0, 0, 1, -933.234375, 6674.44091796875, 16.06459236145019531, 2.911953687667846679, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+84, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -919.21875, 6683.267578125, 12.67469310760498046, 2.25949716567993164, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+85, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -915.96527099609375, 6690.9755859375, 11.39723873138427734, 3.379255533218383789, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+86, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -858.4149169921875, 6652.76123046875, -0.95874375104904174, 0.157278358936309814, 120, 0, 0, 5647, 0, 2, 0, 0, 46702), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+87, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -833.513916015625, 6659.83154296875, 2.11005258560180664, 1.079213500022888183, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+88, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -861.4444580078125, 6682.36279296875, 0.695225715637207031, 3.109214544296264648, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+89, 97289, 1220, 7334, 7348, '0', 0, 0, 0, 0, -897.993896484375, 6702.00634765625, 7.707239151000976562, 4.069083213806152343, 120, 10, 0, 27, 0, 1, 0, 0, 46702), -- Juvenile Scuttleback (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+90, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -835.5538, 6647.838, 3.100126, 0.205834180116653442, 120, 0, 0, 5647, 0, 2, 0, 0, 46702), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+91, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -878.618, 6673.234, 0.1890473, 1.241675019264221191, 120, 0, 0, 5647, 0, 2, 0, 0, 46702), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+92, 89097, 1220, 7334, 7348, '0', 0, 0, 0, 1, -737.5399169921875, 6753.81103515625, 3.579896450042724609, 4.945740222930908203, 120, 0, 0, 56470, 0, 0, 0, 0, 46702), -- Cove Skrog (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+93, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -803.9288330078125, 6638.30810546875, 4.090976715087890625, 1.010109305381774902, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+94, 89111, 1220, 7334, 7348, '0', 0, 0, 0, 1, -809.921875, 6664.8818359375, 2.013123512268066406, 0.43171703815460205, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+95, 89110, 1220, 7334, 7348, '0', 0, 0, 0, 1, -785.4600830078125, 6595.314453125, -0.79772669076919555, 4.324149131774902343, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+96, 89110, 1220, 7334, 7348, '0', 0, 0, 0, 1, -842.88018798828125, 6693.6474609375, 1.597935676574707031, 3.367239713668823242, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+97, 89104, 1220, 7334, 7348, '0', 0, 0, 0, 1, -842.1805419921875, 6695.6552734375, 1.67253422737121582, 0.203518763184547424, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+98, 89111, 1220, 7334, 7348, '0', 0, 0, 0, 1, -897.5069580078125, 6705.845703125, 7.74799346923828125, 2.547564983367919921, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+99, 89110, 1220, 7334, 7348, '0', 0, 0, 0, 1, -837.98785400390625, 6721.04345703125, 1.438478469848632812, 5.837256908416748046, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+100, 89110, 1220, 7334, 7348, '0', 0, 0, 0, 1, -836.953125, 6722.6962890625, 1.279542922973632812, 1.968152403831481933, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+101, 89386, 1220, 7334, 7348, '0', 0, 0, 0, 0, -820.685791015625, 6713.32470703125, 50.07516098022460937, 0.97066575288772583, 120, 0, 0, 6776, 0, 0, 0, 0, 46702), -- Cliffwing Hippogryph (Area: Oceanus Cove - Difficulty: 0) (Auras: ) +(@CGUID+102, 89104, 1220, 7334, 7348, '0', 0, 0, 0, 1, -779.65277099609375, 6680.69970703125, 5.926285266876220703, 0.117917314171791076, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+103, 89111, 1220, 7334, 7348, '0', 0, 0, 0, 1, -787.36456298828125, 6702.67041015625, 4.165828704833984375, 5.499047279357910156, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+104, 89110, 1220, 7334, 7348, '0', 0, 0, 0, 1, -780.98956298828125, 6698.55224609375, 5.067653656005859375, 3.301751613616943359, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+105, 89110, 1220, 7334, 7348, '0', 0, 0, 0, 1, -791.9444580078125, 6714.017578125, 5.104299068450927734, 3.953296422958374023, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+106, 97283, 1220, 7334, 7348, '0', 0, 0, 0, 0, -813.52593994140625, 6745.423828125, 0.597163975238800048, 6.041491985321044921, 120, 10, 0, 1, 0, 1, 0, 0, 46702), -- Juvenile Scuttleback (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+107, 89110, 1220, 7334, 7348, '0', 0, 0, 0, 1, -832.65277099609375, 6745.666015625, 0.619615852832794189, 2.590888738632202148, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+108, 89097, 1220, 7334, 7348, '0', 0, 0, 0, 1, -697.1180419921875, 6787.783203125, 1.524135828018188476, 6.201552867889404296, 120, 0, 0, 56470, 0, 0, 0, 0, 46702), -- Cove Skrog (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+109, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -713.3246, 6613.659, 4.322826, 3.134447336196899414, 120, 0, 0, 5647, 0, 2, 0, 0, 46702), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+110, 97289, 1220, 7334, 7348, '0', 0, 0, 0, 0, -798.91644287109375, 6740.7978515625, 0.121641844511032104, 5.676617145538330078, 120, 10, 0, 27, 0, 1, 0, 0, 46879), -- Juvenile Scuttleback (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+111, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -804.8367919921875, 6738.7041015625, 0.924034714698791503, 4.024903297424316406, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+112, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -761.484375, 6609.5537109375, -0.76011896133422851, 4.60242462158203125, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+113, 89097, 1220, 7334, 7348, '0', 0, 0, 0, 1, -839.65277099609375, 6843.81494140625, 26.1761627197265625, 3.212978839874267578, 120, 0, 0, 56470, 0, 0, 0, 0, 46702), -- Cove Skrog (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+114, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -889.1389, 6672.59, 2.363242, 4.040432929992675781, 120, 0, 0, 5647, 0, 2, 0, 0, 46702), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+115, 89111, 1220, 7334, 7348, '0', 0, 0, 0, 1, -825.05731201171875, 6761.23291015625, 2.951388835906982421, 2.510239124298095703, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+116, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -821.93310546875, 6761.07861328125, 2.71472477912902832, 6.141337871551513671, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+117, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -762.92706298828125, 6718.18505859375, 9.083668708801269531, 4.679363250732421875, 120, 0, 0, 5647, 0, 0, 0, 0, 46702), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+118, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -807.5538330078125, 6795.98974609375, 9.885811805725097656, 4.041399002075195312, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+119, 97283, 1220, 7334, 7348, '0', 0, 0, 0, 0, -777.898681640625, 6793.00634765625, 5.474011898040771484, 4.384151458740234375, 120, 10, 0, 1, 0, 1, 0, 0, 46702), -- Juvenile Scuttleback (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+120, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -803.03125, 6790.08837890625, 7.927645683288574218, 3.60791325569152832, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+121, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -811.42535400390625, 6803.6943359375, 12.40567684173583984, 2.838097810745239257, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+122, 89104, 1220, 7334, 7348, '0', 0, 0, 0, 1, -815.5711669921875, 6812.0244140625, 14.23236465454101562, 4.05087137222290039, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+123, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -753.97918701171875, 6714.29345703125, 10.9022979736328125, 5.54223489761352539, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+124, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -788.5261, 6804.029, 7.319728, 2.594930887222290039, 120, 0, 0, 5647, 0, 2, 0, 0, 46702), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+125, 89111, 1220, 7334, 7348, '0', 0, 0, 0, 1, -807.92706298828125, 6820.65478515625, 10.27726554870605468, 3.004990577697753906, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+126, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -712.51739501953125, 6729.90380859375, 8.334241867065429687, 4.758816242218017578, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+127, 64806, 1220, 7334, 7348, '0', 0, 0, 0, 0, -729.3455810546875, 6760.923828125, 2.926792383193969726, 3.57556772232055664, 120, 0, 0, 5, 0, 0, 0, 0, 46702), -- Rapana Whelk (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+128, 89110, 1220, 7334, 7348, '0', 0, 0, 0, 1, -704.33160400390625, 6733.7353515625, 8.894810676574707031, 5.004142284393310546, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+129, 89097, 1220, 7334, 7348, '0', 0, 0, 0, 1, -606.5243, 6781.788, -3.517866, 2.581407546997070312, 120, 0, 0, 56470, 0, 2, 0, 0, 46702), -- Cove Skrog (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+130, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -761.4705, 6775.325, 0.6374264, 3.803064346313476562, 120, 0, 0, 5647, 0, 2, 0, 0, 46702), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+131, 89884, 1220, 7334, 7348, '0', 0, 0, 0, 0, -734.560791015625, 6852.42529296875, -1.74846374988555908, 2.083124160766601562, 120, 0, 0, 84705, 0, 0, 0, 0, 46702), -- Flog the Captain-Eater (Area: Oceanus Cove - Difficulty: 0) (Auras: 181573 - Anchor Drag) +(@CGUID+132, 91528, 1220, 7334, 7348, '0', 0, 0, 0, 1, -730.2313232421875, 6861.4345703125, -1.45543575286865234, 3.927048206329345703, 120, 0, 0, 3953, 0, 0, 0, 0, 46702), -- Southsea Smuggler (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+133, 97289, 1220, 7334, 7348, '0', 0, 0, 0, 0, -781.22613525390625, 6862.5107421875, 4.089273452758789062, 4.833835601806640625, 120, 10, 0, 27, 0, 1, 0, 0, 46702), -- Juvenile Scuttleback (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+134, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -676.3768, 6814.268, 0.1515371, 0.735026478767395019, 120, 0, 0, 5647, 0, 2, 0, 0, 46702), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+135, 91528, 1220, 7334, 7348, '0', 0, 0, 0, 1, -732.31396484375, 6862.13916015625, -0.97975754737854003, 4.483981132507324218, 120, 0, 0, 3953, 0, 0, 0, 0, 46702), -- Southsea Smuggler (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+136, 91528, 1220, 7334, 7348, '0', 0, 0, 0, 1, -742.16888427734375, 6858.83544921875, -0.70299434661865234, 5.497965335845947265, 120, 0, 0, 3953, 0, 0, 0, 0, 46702), -- Southsea Smuggler (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+137, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -762.7134, 6780.291, 0.2624264, 3.186493158340454101, 120, 0, 0, 5647, 0, 0, 0, 0, 46702), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+138, 89097, 1220, 7334, 7348, '0', 0, 0, 0, 1, -655.873291015625, 6928.3974609375, 11.82632255554199218, 3.06105804443359375, 120, 0, 0, 56470, 0, 0, 0, 0, 46702), -- Cove Skrog (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+139, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -667.9288330078125, 6779.16162109375, 9.954111099243164062, 5.300325393676757812, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+140, 97283, 1220, 7334, 7348, '0', 0, 0, 0, 0, -684.1737060546875, 6839.775390625, 0.438923746347427368, 2.266520023345947265, 120, 10, 0, 1, 0, 1, 0, 0, 46702), -- Juvenile Scuttleback (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+141, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -659.30035400390625, 6798.4375, 4.13368082046508789, 6.271588802337646484, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+142, 91544, 1220, 7334, 7348, '0', 0, 0, 0, 1, -755.35589599609375, 6900.626953125, 10.86480903625488281, 5.109842300415039062, 120, 0, 0, 56470, 0, 0, 0, 0, 46702), -- Captain Blindside (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+143, 91524, 1220, 7334, 7348, '0', 0, 0, 0, 0, -767.1649169921875, 6902.52001953125, 9.705759048461914062, 5.133476734161376953, 120, 0, 0, 5647, 1534, 0, 0, 0, 46702), -- Cannon (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+144, 55370, 1220, 7334, 7348, '0', 0, 0, 0, 0, -755.5069580078125, 6899.12744140625, 8.860773086547851562, 5.170505046844482421, 120, 0, 0, 19343, 2434, 0, 0, 0, 46702), -- General Purpose Bunny ZTO (Area: Oceanus Cove - Difficulty: 0) (Auras: ) +(@CGUID+145, 91524, 1220, 7334, 7348, '0', 0, 0, 0, 0, -763.3680419921875, 6901.31005859375, 10.32251834869384765, 5.133476734161376953, 120, 0, 0, 5647, 1534, 0, 0, 0, 46702), -- Cannon (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+146, 89104, 1220, 7334, 7348, '0', 0, 0, 0, 1, -695.02777099609375, 6894.564453125, 9.940640449523925781, 3.289577722549438476, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+147, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -688.38543701171875, 6901.43994140625, 8.434312820434570312, 2.522246837615966796, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+148, 64806, 1220, 7334, 7348, '0', 0, 0, 0, 0, -664.5303955078125, 6859.6630859375, 0.639960348606109619, 4.283786296844482421, 120, 10, 0, 5, 0, 1, 0, 0, 46702), -- Rapana Whelk (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+149, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -682.4757, 6897.734, 6.777429, 6.240468502044677734, 120, 0, 0, 5647, 0, 2, 0, 0, 46702), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+150, 97283, 1220, 7334, 7348, '0', 0, 0, 0, 0, -839.7354736328125, 6900.6689453125, 8.728796958923339843, 3.627420425415039062, 120, 10, 0, 1, 0, 1, 0, 0, 46702), -- Juvenile Scuttleback (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+151, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -677.06427001953125, 6905.32275390625, 5.54814767837524414, 2.389096260070800781, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+152, 97020, 1220, 7334, 7348, '0', 0, 0, 0, 0, -820.4725341796875, 6925.93505859375, 26.34235572814941406, 5.285966396331787109, 120, 10, 0, 27, 0, 1, 0, 0, 46702), -- Albatross Chick (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+153, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -670.9930419921875, 6923.3828125, 9.321848869323730468, 3.036244392395019531, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+154, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -645.29864501953125, 6786.54345703125, -0.82631260156631469, 2.377149820327758789, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+155, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -643.7718505859375, 6787.9765625, -0.83723068237304687, 6.037278175354003906, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+156, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -618.26043701171875, 6855.00439453125, 0.461410462856292724, 5.86350250244140625, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+157, 89110, 1220, 7334, 7348, '0', 0, 0, 0, 1, -623.15106201171875, 6848.611328125, 0.779999852180480957, 4.117775917053222656, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+158, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -627.67706298828125, 6815.4912109375, 1.80423891544342041, 2.658314228057861328, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+159, 97289, 1220, 7334, 7348, '0', 0, 0, 0, 0, -616.03045654296875, 6884.56298828125, 0.566563725471496582, 1.725672483444213867, 120, 0, 0, 27, 0, 0, 0, 0, 46702), -- Juvenile Scuttleback (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+160, 97283, 1220, 7334, 7348, '0', 0, 0, 0, 0, -655.07696533203125, 6801.7998046875, 4.629490852355957031, 2.419087171554565429, 120, 0, 0, 1, 0, 0, 0, 0, 46702), -- Juvenile Scuttleback (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+161, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -611.640625, 6842.3837890625, 3.683964490890502929, 0.963236570358276367, 120, 0, 0, 5647, 0, 0, 0, 0, 46702), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+162, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -624.8819580078125, 6859.9609375, 0.946392297744750976, 6.20728921890258789, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+163, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -602.9774, 6867.322, 0.8475696, 4.630544662475585937, 120, 0, 0, 5647, 0, 2, 0, 0, 46702), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+164, 64806, 1220, 7334, 7348, '0', 0, 0, 0, 0, -594.904541015625, 6874.1396484375, 0.601093649864196777, 6.195178031921386718, 120, 0, 0, 5, 0, 0, 0, 0, 46702), -- Rapana Whelk (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+165, 89110, 1220, 7334, 7348, '0', 0, 0, 0, 1, -580.13018798828125, 6870.03466796875, 1.492720723152160644, 5.208482742309570312, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+166, 89104, 1220, 7334, 7348, '0', 0, 0, 0, 1, -586.47052001953125, 6864.7490234375, 0.90612107515335083, 5.678408145904541015, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+167, 97289, 1220, 7334, 7348, '0', 0, 0, 0, 0, -601.860595703125, 6786.17919921875, -3.354705810546875, 1.620699405670166015, 120, 10, 0, 27, 0, 1, 0, 0, 46702), -- Juvenile Scuttleback (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+168, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -612.9097, 6734.817, -0.8487108, 2.095047950744628906, 120, 0, 0, 5647, 0, 2, 0, 0, 46702), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+169, 89111, 1220, 7334, 7348, '0', 0, 0, 0, 1, -581.13543701171875, 6767.515625, 4.069705963134765625, 4.947862625122070312, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+170, 89104, 1220, 7334, 7348, '0', 0, 0, 0, 1, -594.76910400390625, 6758.43505859375, 0.434261590242385864, 5.92899322509765625, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+171, 89386, 1220, 7334, 7348, '0', 0, 0, 0, 0, -581.79168701171875, 6790.98779296875, 81.53778076171875, 2.49387359619140625, 120, 0, 0, 6776, 0, 0, 0, 0, 46702), -- Cliffwing Hippogryph (Area: Oceanus Cove - Difficulty: 0) (Auras: ) +(@CGUID+172, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -595.79864501953125, 6756.78125, 0.260871320962905883, 3.331701517105102539, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+173, 89104, 1220, 7334, 7348, '0', 0, 0, 0, 1, -629.8819580078125, 6755.01025390625, 0.710632681846618652, 3.414361000061035156, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+174, 89104, 1220, 7334, 7348, '0', 0, 0, 0, 1, -583.36114501953125, 6648.0791015625, -1.03256154060363769, 5.26729583740234375, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+175, 89111, 1220, 7334, 7348, '0', 0, 0, 0, 1, -581.22918701171875, 6734.27978515625, -1.86366462707519531, 3.356546640396118164, 120, 0, 0, 4518, 0, 0, 0, 0, 46702), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+176, 64806, 1220, 7334, 7348, '0', 0, 0, 0, 0, -889.363037109375, 6899.76953125, 6.765208244323730468, 5.52264404296875, 120, 0, 0, 5, 0, 0, 0, 0, 46702), -- Rapana Whelk (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+177, 97289, 1220, 7334, 7348, '0', 0, 0, 0, 0, -899.59332275390625, 6839.9482421875, 11.05530643463134765, 5.623682498931884765, 120, 0, 0, 27, 0, 0, 0, 0, 46702), -- Juvenile Scuttleback (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+178, 89386, 1220, 7334, 7348, '0', 0, 0, 0, 0, -965.404541015625, 6791.09375, 65.81768798828125, 1.660518169403076171, 120, 0, 0, 6776, 0, 0, 0, 0, 46702), -- Cliffwing Hippogryph (Area: Oceanus Cove - Difficulty: 0) (Auras: ) +(@CGUID+179, 89386, 1220, 7334, 7348, '0', 0, 0, 0, 0, -1129.5242919921875, 6448.46728515625, 18.93314743041992187, 2.854464530944824218, 120, 0, 0, 6776, 0, 0, 0, 0, 46702), -- Cliffwing Hippogryph (Area: Oceanus Cove - Difficulty: 0) (Auras: ) +(@CGUID+180, 88094, 1220, 7334, 7348, '0', 0, 0, 0, 1, -1252.720458984375, 6511.86279296875, -100.078987121582031, 2.420162439346313476, 120, 0, 0, 16941, 0, 0, 0, 0, 46702), -- Sea Skrog (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+181, 88094, 1220, 7334, 7348, '0', 0, 0, 0, 1, -1226.3350830078125, 6620.87255859375, -74.4512710571289062, 4.011722087860107421, 120, 0, 0, 16941, 0, 0, 0, 0, 46702), -- Sea Skrog (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+182, 88094, 1220, 7334, 7348, '0', 0, 0, 0, 1, -1274.748291015625, 6578.43408203125, -105.471527099609375, 1.646265983581542968, 120, 0, 0, 16941, 0, 0, 0, 0, 46702), -- Sea Skrog (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+183, 88094, 1220, 7334, 7348, '0', 0, 0, 0, 1, -1331.2239990234375, 6465.8505859375, -90.28509521484375, 1.533799648284912109, 120, 0, 0, 16941, 0, 0, 0, 0, 46702), -- Sea Skrog (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+184, 111682, 1220, 7334, 7348, '0', 0, 0, 0, 0, -1212.5032958984375, 6567.4130859375, -26.0577335357666015, 3.281294822692871093, 120, 10, 0, 16941, 0, 1, 0, 0, 46702), -- Savage Great White (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+185, 111682, 1220, 7334, 7348, '0', 0, 0, 0, 0, -1273.310791015625, 6564.587890625, -86.965057373046875, 4.090945243835449218, 120, 10, 0, 16941, 0, 1, 0, 0, 46702), -- Savage Great White (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+186, 91528, 1220, 7334, 7348, '0', 0, 0, 0, 1, -743.7740478515625, 6860.43994140625, -0.83617305755615234, 5.4977874755859375, 120, 0, 0, 3953, 0, 0, 0, 0, 46879), -- Southsea Smuggler (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+187, 97289, 1220, 7334, 7348, '0', 0, 0, 0, 0, -604.53668212890625, 6782.0810546875, -3.49695348739624023, 5.245412349700927734, 120, 0, 0, 27, 0, 0, 0, 0, 46879), -- Juvenile Scuttleback (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+188, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -565.5501708984375, 6771.83251953125, -1.64025759696960449, 2.628099918365478515, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+189, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -546.4636, 6745.757, -3.192686, 4.992163658142089843, 120, 0, 0, 5647, 0, 2, 0, 0, 46879), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+190, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -583.64410400390625, 6719.76123046875, -1.82187223434448242, 5.236592, 120, 0, 0, 5647, 0, 0, 0, 0, 46879), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+191, 97283, 1220, 7334, 7348, '0', 0, 0, 0, 0, -549.9737548828125, 6728.4296875, -2.61979651451110839, 4.124414443969726562, 120, 0, 0, 1, 0, 0, 0, 0, 46879), -- Juvenile Scuttleback (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+192, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -522.3038, 6742.083, -2.439491, 1.718753457069396972, 120, 0, 0, 5647, 0, 2, 0, 0, 46879), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+193, 89110, 1220, 7334, 7348, '0', 0, 0, 0, 1, -555.65972900390625, 6664.634765625, -6.42964649200439453, 2.310320377349853515, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+194, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -525.7586669921875, 6757.69189453125, -1.03049612045288085, 0.766962707042694091, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+195, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -572.41729736328125, 6710.24658203125, -1.62885844707489013, 4.207798957824707031, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+196, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -526.40625, 6735.62353515625, -2.12933158874511718, 6.178088665008544921, 120, 0, 0, 5647, 0, 0, 0, 0, 46879), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+197, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -573.94097900390625, 6703.1728515625, -1.69118690490722656, 5.469538211822509765, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+198, 89110, 1220, 7334, 7348, '0', 0, 0, 0, 1, -515.6788330078125, 6740.2412109375, -0.91386693716049194, 0.549206137657165527, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+199, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -526.49407958984375, 6720.76513671875, -1.9052739143371582, 3.996221542358398437, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+200, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -536.78125, 6706.15185546875, -2.52059507369995117, 3.453974008560180664, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+201, 89111, 1220, 7334, 7348, '0', 0, 0, 0, 1, -734.1180419921875, 6453.046875, -7.17189884185791015, 3.485471725463867187, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+202, 89110, 1220, 7334, 7348, '0', 0, 0, 0, 1, -515.69097900390625, 6659.1572265625, -6.46496963500976562, 2.145476579666137695, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+203, 89097, 1220, 7334, 7348, '0', 0, 0, 0, 1, -553.1823, 6623.632, -10.72044, 0.347216129302978515, 120, 0, 0, 56470, 0, 2, 0, 0, 46879), -- Cove Skrog (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+204, 64806, 1220, 7334, 7348, '0', 0, 0, 0, 0, -543.13458251953125, 6648.07568359375, -10.4302167892456054, 1.629122853279113769, 120, 10, 0, 5, 0, 1, 0, 0, 46879), -- Rapana Whelk (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+205, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -565, 6637.8662109375, -10.5015716552734375, 1.326328754425048828, 120, 0, 0, 5647, 0, 0, 0, 0, 46879), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+206, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -537.20489501953125, 6676.9765625, -6.09215116500854492, 3.202090024948120117, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+207, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -575.1389, 6632.951, -10.5486, 3.488560676574707031, 120, 0, 0, 5647, 0, 2, 0, 0, 46879), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+208, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -531.64239501953125, 6618.61376953125, -5.79813241958618164, 5.910975456237792968, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+209, 89111, 1220, 7334, 7348, '0', 0, 0, 0, 1, -804.441162109375, 6482.573242875, 0.584960699081420898, 5.626517772674560546, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+210, 89199, 1220, 7334, 7348, '0', 0, 0, 0, 1, -579.3338623046875, 6507.7373046875, -10.3560438156127929, 0.013086176477372646, 120, 0, 0, 16941, 1534, 2, 0, 0, 46879), -- Lady Sssurine (Area: Oceanus Cove - Difficulty: 0 +(@CGUID+211, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -549.58331298828125, 6599.29150390625, -8.78490924835205078, 6.163769721984863281, 120, 0, 0, 5647, 0, 0, 0, 0, 46879), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+212, 93513, 1220, 7334, 7348, '0', 0, 0, 0, 1, -571.4617919921875, 6488.203125, -3.9832460880279541, 1.553356885910034179, 120, 0, 0, 56470, 0, 0, 0, 0, 46879), -- Skrog Ambassador (Area: Oceanus Cove - Difficulty: 0) (Auras: 175813 - Sea Giant Temp FX, 185095 - Cosmetic - Sleep Zzz Breakable) +(@CGUID+213, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -551.8889, 6567.242, -9.554152, 0.459424406290054321, 120, 0, 0, 5647, 0, 2, 0, 0, 46879), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+214, 89110, 1220, 7334, 7348, '0', 0, 0, 0, 1, -539.5242919921875, 6576.6005859375, -7.69445610046386718, 5.789409637451171875, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+215, 89110, 1220, 7334, 7348, '0', 0, 0, 0, 1, -622.9132080078125, 6622.1552734375, -7.79297971725463867, 0.508554041385650634, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+216, 97289, 1220, 7334, 7348, '0', 0, 0, 0, 0, -716.37420654296875, 6458.650390625, -11.4202232360839843, 2.064303398132324218, 120, 0, 0, 27, 0, 0, 0, 0, 46879), -- Juvenile Scuttleback (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+217, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -568.1961669921875, 6554.8525390625, -12.1319856643676757, 1.7847335, 120, 0, 0, 5647, 0, 0, 0, 0, 46879), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+218, 97289, 1220, 7334, 7348, '0', 0, 0, 0, 0, -589.4388427734375, 6545.501953125, -11.4001140594482421, 6.092706680297851562, 120, 10, 0, 27, 0, 1, 0, 0, 46879), -- Juvenile Scuttleback (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+219, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -595.90972900390625, 6546.734375, -9.56999111175537109, 1.848350763320922851, 120, 0, 0, 5647, 0, 0, 0, 0, 46879), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+220, 89111, 1220, 7334, 7348, '0', 0, 0, 0, 1, -633.09722900390625, 6560.7568359375, -2.0948801040649414, 0.616978287696838378, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+221, 64806, 1220, 7334, 7348, '0', 0, 0, 0, 0, -644.98779296875, 6592.1962890625, -5.76810693740844726, 1.94699108600616455, 120, 10, 0, 5, 0, 1, 0, 0, 46879), -- Rapana Whelk (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+222, 89104, 1220, 7334, 7348, '0', 0, 0, 0, 1, -637.171875, 6560.15869140625, -1.54683542251586914, 4.55611419677734375, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+223, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -664.74652099609375, 6636.96728515625, -0.59019142389297485, 1.742975, 120, 0, 0, 5647, 0, 0, 0, 0, 46879), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+224, 89104, 1220, 7334, 7348, '0', 0, 0, 0, 1, -668.66143798828125, 6540.5849609375, -3.61407852172851562, 0.396136164665222167, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+225, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -661.1198, 6487.894, -12.6888, 6.213212966918945312, 120, 0, 0, 5647, 0, 2, 0, 0, 46879), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+226, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -684.03472900390625, 6585.32275390625, -3.38093280792236328, 3.6877396, 120, 0, 0, 5647, 0, 0, 0, 0, 46879), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+227, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -767.50347900390625, 6519.3603515625, 2.8975982666015625, 2.009998559951782226, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+228, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -654.217041015625, 6484.1953125, -14.3733472824096679, 0.291045159101486206, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+229, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -705.4445, 6529.844, -2.473737, 6.069781303405761718, 120, 0, 0, 5647, 0, 2, 0, 0, 46879), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+230, 89110, 1220, 7334, 7348, '0', 0, 0, 0, 1, -698.138916015625, 6572.94091796875, -1.54263699054718017, 6.006361961364746093, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+231, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -696.30206298828125, 6529.9453125, -4.85493183135986328, 2.895397, 120, 0, 0, 5647, 0, 0, 0, 0, 46879), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+232, 89104, 1220, 7334, 7348, '0', 0, 0, 0, 1, -710.2586669921875, 6585.203125, -0.16886764764785766, 4.548013210296630859, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+233, 97289, 1220, 7334, 7348, '0', 0, 0, 0, 0, -669.31353759765625, 6661.33984375, -3.21509957313537597, 2.667874097824096679, 120, 10, 0, 27, 0, 1, 0, 0, 46879), -- Juvenile Scuttleback (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+234, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -679.513916015625, 6653.6630859375, -1.98445308208465576, 2.516224384307861328, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+235, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -706.75, 6538.5, -0.39417466521263122, 2.418025732040405273, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+236, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -724.0867919921875, 6617.65087890625, 5.184843063354492187, 2.389098882675170898, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+237, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -704.10418701171875, 6657.3818359375, 2.178419351577758789, 2.836410284042358398, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+238, 89104, 1220, 7334, 7348, '0', 0, 0, 0, 1, -697.80010986328125, 6634.5498046875, 2.96221160888671875, 0.9554187655448913575, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+239, 97289, 1220, 7334, 7348, '0', 0, 0, 0, 0, -759.4375, 6585.0546875, -0.59073835611343383, 2.247922182083129882, 120, 10, 0, 27, 0, 1, 0, 0, 46879), -- Juvenile Scuttleback (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+240, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -699.7639, 6645.301, 3.169553, 2.710061550140380859, 120, 0, 0, 5647, 0, 2, 0, 0, 46879), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+241, 89112, 1220, 7334, 7348, '0', 0, 0, 0, 1, -709.07989501953125, 6515.56591796875, -2.28409290313720703, 5.4259033203125, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+242, 89113, 1220, 7334, 7348, '0', 0, 0, 0, 1, -714.060791015625, 6511.916015625, -0.81647866964340209, 3.20886397361755371, 120, 0, 0, 4518, 0, 0, 0, 0, 46879), -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+243, 90109, 1220, 7334, 7348, '0', 0, 0, 0, 1, -693.4149169921875, 6470.84619140625, -11.9220333099365234, 2.104029417037963867, 120, 0, 0, 5647, 0, 0, 0, 0, 46879), -- Hatecoil Slavemaster (Area: Oceanus Cove - Difficulty: 0) +(@CGUID+244, 89111, 1220, 7334, 7348, '0', 0, 0, 0, 1, -755.324462890625, 6505.49853515625, -1.28087663650512695, 0.806399941444396972, 120, 0, 0, 4518, 0, 0, 0, 0, 46879); -- Shipwrecked Captive (Area: Oceanus Cove - Difficulty: 0) +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+244; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `MountCreatureID`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvPFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 4, ''), +(@CGUID+4, 0, 0, 0, 0, 0, 0, 1, 0, 378, 0, 0, 0, 3, ''), +(@CGUID+6, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 3, ''), +(@CGUID+11, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, ''), +(@CGUID+15, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, ''), +(@CGUID+18, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, ''), +(@CGUID+25, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, ''), +(@CGUID+26, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, ''), +(@CGUID+28, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+29, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+31, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+32, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+33, 0, 0, 0, 0, 0, 0, 1, 0, 28, 0, 0, 0, 3, ''), +(@CGUID+34, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+35, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+36, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, ''), +(@CGUID+38, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+39, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+40, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+44, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+45, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+46, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+49, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+51, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+52, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+55, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+56, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+57, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+59, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+62, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+63, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+64, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+65, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+66, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+68, 0, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 0, ''), +(@CGUID+69, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, ''), +(@CGUID+72, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+73, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+75, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, ''), +(@CGUID+76, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+77, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+78, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+79, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), +(@CGUID+81, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 3, ''), +(@CGUID+82, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+83, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+84, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+85, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+87, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+92, 0, 0, 0, 0, 0, 0, 1, 0, 28, 0, 0, 0, 3, ''), +(@CGUID+93, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+94, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+95, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+97, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+98, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+99, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+101, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), +(@CGUID+102, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+103, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+104, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+105, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+107, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+108, 0, 0, 0, 0, 0, 0, 1, 0, 28, 0, 0, 0, 3, ''), +(@CGUID+111, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+113, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, ''), +(@CGUID+115, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+118, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+120, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+121, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+122, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+123, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+125, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+126, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+128, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+129, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, ''), +(@CGUID+131, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '181573'), +(@CGUID+138, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, ''), +(@CGUID+139, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+141, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+143, 0, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 0, ''), +(@CGUID+144, 0, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 0, ''), +(@CGUID+145, 0, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 0, ''), +(@CGUID+146, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+147, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+151, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+152, 0, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 0, ''), +(@CGUID+153, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+154, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+157, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+158, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+162, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+165, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+166, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+169, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+170, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+171, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), +(@CGUID+173, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+178, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), +(@CGUID+179, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), +(@CGUID+180, 0, 0, 0, 0, 0, 0, 1, 0, 28, 0, 0, 0, 3, ''), +(@CGUID+181, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, ''), +(@CGUID+182, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 3, ''), +(@CGUID+183, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 3, ''), +(@CGUID+193, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+194, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+197, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+198, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+200, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+201, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+203, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, ''), +(@CGUID+206, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+208, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+210, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, ''), +(@CGUID+212, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, '175813 185095'), +(@CGUID+214, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+215, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+222, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+224, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+227, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+228, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+232, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+234, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+235, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+236, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+237, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''), +(@CGUID+242, 0, 0, 0, 0, 0, 0, 1, 0, 233, 0, 0, 0, 0, ''); + +-- GameObjects +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+60; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 239122, 1220, 7334, 7521, '0', 0, 0, -957.23785400390625, 6309.16845703125, 29.30948638916015625, 2.841597318649291992, 0, 0, 0.988771438598632812, 0.149435803294181823, 120, 255, 1, 46702), -- Okuna's Cage (Area: Old Coast Path - Difficulty: 0) +(@OGUID+1, 251496, 1220, 7334, 7348, '0', 0, 0, -880.6961669921875, 6379.4287109375, 6.595629215240478515, 0.250523000955581665, 0, 0, 0.124934196472167968, 0.992165029048919677, 120, 255, 1, 46702), -- Naga Weaponry (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+2, 241905, 1220, 7334, 7348, '0', 0, 0, -873.28302001953125, 6444.5478515625, 2.733907938003540039, 3.677321910858154296, 0.027279853820800781, 0.007508277893066406, -0.96395206451416015, 0.264567345380783081, 120, 255, 1, 46702), -- Grace the Green's Cage (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+3, 245862, 1220, 7334, 7348, '0', 0, 0, -956.5, 6456.0322265625, 2.270020008087158203, 5.454771995544433593, 0, 0, -0.40246391296386718, 0.915435850620269775, 120, 255, 1, 46702), -- Skrog Weapons (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+4, 245862, 1220, 7334, 7348, '0', 0, 0, -886.1336669921875, 6459.3994140625, 2.238675355911254882, 2.625298023223876953, 0, 0, 0.966864585876464843, 0.255289733409881591, 120, 255, 1, 46702), -- Skrog Weapons (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+5, 245862, 1220, 7334, 7348, '0', 0, 0, -754.3507080078125, 6476.20068359375, -5.65609693527221679, 1.359165430068969726, 0, 0, 0.628468513488769531, 0.777835011482238769, 120, 255, 1, 46702), -- Skrog Weapons (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+6, 245862, 1220, 7334, 7348, '0', 0, 0, -889.06597900390625, 6542.578125, -0.02541550435125827, 2.997215032577514648, 0, 0, 0.997395515441894531, 0.072126097977161407, 120, 255, 1, 46702), -- Skrog Weapons (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+7, 245862, 1220, 7334, 7348, '0', 0, 0, -922.5867919921875, 6578.171875, -0.7411159873008728, 1.905878186225891113, 0, 0, 0.815121650695800781, 0.579289853572845458, 120, 255, 1, 46702), -- Skrog Weapons (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+8, 241901, 1220, 7334, 7348, '0', 0, 0, -959.109375, 6608.87939453125, 0.115693621337413787, 5.959390163421630859, 0.004539966583251953, 0.027927398681640625, -0.16112613677978515, 0.98652815818786621, 120, 255, 1, 46702), -- Cleave Thunderhill's Cage (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+9, 251496, 1220, 7334, 7348, '0', 0, 0, -820.1632080078125, 6565.81103515625, 5.266399383544921875, 1.821151375770568847, 0, 0, 0.789856910705566406, 0.613291144371032714, 120, 255, 1, 46702), -- Naga Weaponry (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+10, 241909, 1220, 7334, 7348, '0', 0, 0, -912.53302001953125, 6649.8984375, 0.554982304573059082, 4.71116495132446289, 0, 0, -0.70753955841064453, 0.706673741340637207, 120, 255, 1, 46702), -- Skrog Weapons (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+11, 241909, 1220, 7334, 7348, '0', 0, 0, -792.00177001953125, 6620.4208984375, 0.813889086246490478, 1.252338886260986328, 0, 0, 0.586045265197753906, 0.810278296470642089, 120, 255, 1, 46702), -- Skrog Weapons (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+12, 241909, 1220, 7334, 7348, '0', 0, 0, -841.3836669921875, 6708.4228515625, 0.400635510683059692, 2.184125423431396484, 0, 0, 0.887578964233398437, 0.460655570030212402, 120, 255, 1, 46702), -- Skrog Weapons (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+13, 251496, 1220, 7334, 7348, '0', 0, 0, -841.18402099609375, 6717.236328125, 0.575619697570800781, 3.514478445053100585, 0, 0, -0.98266983032226562, 0.185364484786987304, 120, 255, 1, 46702), -- Naga Weaponry (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+14, 241902, 1220, 7334, 7348, '0', 0, 0, -787.26043701171875, 6783.05810546875, 5.48264169692993164, 2.255038738250732421, -0.00470972061157226, 0.002744674682617187, 0.903336524963378906, 0.428897887468338012, 120, 255, 1, 46702), -- Gentle Rosh's Cage (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+15, 251496, 1220, 7334, 7348, '0', 0, 0, -772.6875, 6799.1240234375, 6.239315986633300781, 3.427406787872314453, 0, 0, -0.98980617523193359, 0.142421066761016845, 120, 255, 1, 46702), -- Naga Weaponry (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+16, 245862, 1220, 7334, 7348, '0', 0, 0, -701.36456298828125, 6778.931640625, 1.58013308048248291, 1.252338886260986328, 0, 0, 0.586045265197753906, 0.810278296470642089, 120, 255, 1, 46702), -- Skrog Weapons (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+17, 251496, 1220, 7334, 7348, '0', 0, 0, -667.3819580078125, 6785.86279296875, 7.63477945327758789, 1.329160571098327636, 0, 0, 0.616728782653808593, 0.787175714969635009, 120, 255, 1, 46702), -- Naga Weaponry (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+18, 254246, 1220, 7334, 7348, '0', 0, 0, -765.45831298828125, 6904.41748046875, 8.666940689086914062, 0.016971014440059661, -0.11064529418945312, -0.01771831512451171, 0.006561279296875, 0.993680357933044433, 120, 255, 1, 46702), -- Storehouse Crate (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+19, 254246, 1220, 7334, 7348, '0', 0, 0, -763.80206298828125, 6903.80029296875, 7.942027568817138671, 0.016971014440059661, -0.11064529418945312, -0.01771831512451171, 0.006561279296875, 0.993680357933044433, 120, 255, 1, 46702), -- Storehouse Crate (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+20, 254246, 1220, 7334, 7348, '0', 0, 0, -764.70660400390625, 6904.10693359375, 7.644502639770507812, 0.016971014440059661, -0.11064529418945312, -0.01771831512451171, 0.006561279296875, 0.993680357933044433, 120, 255, 1, 46702), -- Storehouse Crate (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+21, 254246, 1220, 7334, 7348, '0', 0, 0, -770.310791015625, 6906.31787109375, 6.145668506622314453, 0.016971014440059661, -0.11064529418945312, -0.01771831512451171, 0.006561279296875, 0.993680357933044433, 120, 255, 1, 46702), -- Storehouse Crate (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+22, 254246, 1220, 7334, 7348, '0', 0, 0, -765.43927001953125, 6904.939453125, 7.274104595184326171, 0.016971014440059661, -0.11064529418945312, -0.01771831512451171, 0.006561279296875, 0.993680357933044433, 120, 255, 1, 46702), -- Storehouse Crate (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+23, 254246, 1220, 7334, 7348, '0', 0, 0, -767.75, 6904.5546875, 6.9641876220703125, 0.016971014440059661, -0.11064529418945312, -0.01771831512451171, 0.006561279296875, 0.993680357933044433, 120, 255, 1, 46702), -- Storehouse Crate (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+24, 254246, 1220, 7334, 7348, '0', 0, 0, -767.68231201171875, 6906.0380859375, 6.555226802825927734, 0.016971014440059661, -0.11064529418945312, -0.01771831512451171, 0.006561279296875, 0.993680357933044433, 120, 255, 1, 46702), -- Storehouse Crate (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+25, 254246, 1220, 7334, 7348, '0', 0, 0, -770.7725830078125, 6906.66943359375, 7.008194923400878906, 0.632033765316009521, 0.058339595794677734, 0.085022926330566406, 0.304218292236328125, 0.947005212306976318, 120, 255, 1, 46702), -- Storehouse Crate (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+26, 190228, 1220, 7334, 7348, '0', 0, 0, -765.00347900390625, 6903.96533203125, 8.811307907104492187, 5.323887825012207031, 0, 0, -0.46146774291992187, 0.887156963348388671, 120, 255, 1, 46702), -- Cannon - 0.50 (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+27, 254246, 1220, 7334, 7348, '0', 0, 0, -769.28472900390625, 6904.9912109375, 7.224740028381347656, 0.016971014440059661, -0.11064529418945312, -0.01771831512451171, 0.006561279296875, 0.993680357933044433, 120, 255, 1, 46702), -- Storehouse Crate (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+28, 190228, 1220, 7334, 7348, '0', 0, 0, -768.9149169921875, 6904.79541015625, 7.77200174331665039, 5.396942615509033203, 0, 0, -0.42876148223876953, 0.903417706489562988, 120, 255, 1, 46702), -- Cannon - 0.50 (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+29, 254246, 1220, 7334, 7348, '0', 0, 0, -766.6961669921875, 6905.4912109375, 6.838783740997314453, 0.016971014440059661, -0.11064529418945312, -0.01771831512451171, 0.006561279296875, 0.993680357933044433, 120, 255, 1, 46702), -- Storehouse Crate (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+30, 254246, 1220, 7334, 7348, '0', 0, 0, -764.73614501953125, 6903.8974609375, 8.2414703369140625, 0.016971014440059661, -0.11064529418945312, -0.01771831512451171, 0.006561279296875, 0.993680357933044433, 120, 255, 1, 46702), -- Storehouse Crate (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+31, 254246, 1220, 7334, 7348, '0', 0, 0, -768.67364501953125, 6905.1806640625, 6.670732975006103515, 0.016971014440059661, -0.11064529418945312, -0.01771831512451171, 0.006561279296875, 0.993680357933044433, 120, 255, 1, 46702), -- Storehouse Crate (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+32, 254246, 1220, 7334, 7348, '0', 0, 0, -765.671875, 6904.0224609375, 7.418042659759521484, 0.016971014440059661, -0.11064529418945312, -0.01771831512451171, 0.006561279296875, 0.993680357933044433, 120, 255, 1, 46702), -- Storehouse Crate (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+33, 254246, 1220, 7334, 7348, '0', 0, 0, -770.54339599609375, 6905.40283203125, 6.53373575210571289, 0.016971014440059661, -0.11064529418945312, -0.01771831512451171, 0.006561279296875, 0.993680357933044433, 120, 255, 1, 46702), -- Storehouse Crate (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+34, 254246, 1220, 7334, 7348, '0', 0, 0, -766.37152099609375, 6905.921875, 8.011418342590332031, 0.632033765316009521, 0.058339595794677734, 0.085022926330566406, 0.304218292236328125, 0.947005212306976318, 120, 255, 1, 46702), -- Storehouse Crate (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+35, 254246, 1220, 7334, 7348, '0', 0, 0, -769.578125, 6905.48681640625, 6.471607208251953125, 0.016971014440059661, -0.11064529418945312, -0.01771831512451171, 0.006561279296875, 0.993680357933044433, 120, 255, 1, 46702), -- Storehouse Crate (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+36, 254246, 1220, 7334, 7348, '0', 0, 0, -765.57293701171875, 6905.9697265625, 7.0120086669921875, 0.016971014440059661, -0.11064529418945312, -0.01771831512451171, 0.006561279296875, 0.993680357933044433, 120, 255, 1, 46702), -- Storehouse Crate (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+37, 241909, 1220, 7334, 7348, '0', 0, 0, -647.29168701171875, 6914.04248046875, 6.013508796691894531, 3.375383853912353515, 0, 0, -0.99317550659179687, 0.116629481315612792, 120, 255, 1, 46702), -- Skrog Weapons (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+38, 241909, 1220, 7334, 7348, '0', 0, 0, -638.52606201171875, 6797.41650390625, -1.15406417846679687, 5.466907024383544921, 0, 0, -0.39690208435058593, 0.917860984802246093, 120, 255, 1, 46702), -- Skrog Weapons (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+39, 245221, 1220, 7334, 7348, '0', 0, 0, -560.20660400390625, 6792.1796875, -1.81680703163146972, 3.107202529907226562, 0, 0, 0.999852180480957031, 0.017194157466292381, 120, 255, 1, 46702), -- Crate of Mail Armor (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+40, 241908, 1220, 7334, 7348, '0', 0, 0, -550.75518798828125, 6713.79541015625, -0.84987252950668334, 1.711851954460144042, 0.031225204467773437, -0.00581932067871093, 0.755085945129394531, 0.654855966567993164, 120, 255, 1, 46879), -- Prince's Plunder (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+41, 251496, 1220, 7334, 7348, '0', 0, 0, -511.041656494140625, 6668.65087890625, -3.58063840866088867, 2.632838010787963867, 0, 0, 0.967820167541503906, 0.251642793416976928, 120, 255, 1, 46879), -- Naga Weaponry (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+42, 245221, 1220, 7334, 7348, '0', 0, 0, -563.17706298828125, 6710.478515625, -0.7478758692741394, 2.993534326553344726, -0.09996986389160156, 0.028006553649902343, 0.9917144775390625, 0.075657203793525695, 120, 255, 1, 46879), -- Crate of Mail Armor (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+43, 241908, 1220, 7334, 7348, '0', 0, 0, -541.11456298828125, 6780.3193359375, 0.353374898433685302, 4.120302200317382812, 0.10947275161743164, 0.065184593200683593, -0.8750762939453125, 0.466913431882858276, 120, 255, 1, 46879), -- Prince's Plunder (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+44, 251496, 1220, 7334, 7348, '0', 0, 0, -596.33331298828125, 6713.56787109375, 0.383994668722152709, 0.894389629364013671, 0, 0, 0.432437896728515625, 0.901663720607757568, 120, 255, 1, 46879), -- Naga Weaponry (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+45, 241908, 1220, 7334, 7348, '0', 0, 0, -512.95660400390625, 6666.197265625, -4.44157600402832031, 1.896248817443847656, -0.14668941497802734, -0.19063663482666015, 0.789623260498046875, 0.564477622509002685, 120, 255, 1, 46879), -- Prince's Plunder (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+46, 245221, 1220, 7334, 7348, '0', 0, 0, -507.265625, 6669.892578125, -2.69045925140380859, 3.119438409805297851, -0.10153436660766601, 0.02165985107421875, 0.994509696960449218, 0.013117874041199684, 120, 255, 1, 46879), -- Crate of Mail Armor (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+47, 245221, 1220, 7334, 7348, '0', 0, 0, -529.19793701171875, 6633.03564453125, -5.98692560195922851, 3.598437309265136718, 0.123524188995361328, -0.11523723602294921, -0.96297264099121093, 0.210109069943428039, 120, 255, 1, 46879), -- Crate of Mail Armor (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+48, 241908, 1220, 7334, 7348, '0', 0, 0, -537.4288330078125, 6598.67724609375, -6.94567823410034179, 2.96664285659790039, 0.028694629669189453, 0.01361846923828125, 0.9957122802734375, 0.086880452930927276, 120, 255, 1, 46879), -- Prince's Plunder (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+49, 245221, 1220, 7334, 7348, '0', 0, 0, -546.46527099609375, 6585.6005859375, -8.32245540618896484, 4.251910686492919921, 0.082818031311035156, -0.06048870086669921, -0.84726905822753906, 0.521169245243072509, 120, 255, 1, 46879), -- Crate of Mail Armor (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+50, 245221, 1220, 7334, 7348, '0', 0, 0, -544.93402099609375, 6584.41748046875, -7.99679422378540039, 3.347785234451293945, 0.10465240478515625, -0.04471683502197265, -0.98878192901611328, 0.09673977643251419, 120, 255, 1, 46879), -- Crate of Mail Armor (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+51, 245862, 1220, 7334, 7348, '0', 0, 0, -615.40972900390625, 6622.18603515625, -8.50875663757324218, 4.359757900238037109, 0, 0, -0.82017326354980468, 0.572115182876586914, 120, 255, 1, 46879), -- Skrog Weapons (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+52, 245221, 1220, 7334, 7348, '0', 0, 0, -621.94793701171875, 6619.3359375, -7.54677248001098632, 4.471294403076171875, -0.0413064956665039, -0.03221607208251953, -0.78593254089355468, 0.616089224815368652, 120, 255, 1, 46879), -- Crate of Mail Armor (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+53, 245221, 1220, 7334, 7348, '0', 0, 0, -665.01214599609375, 6563.13916015625, -4.17217874526977539, 1.121714472770690917, -0.1687169075012207, 0.042937278747558593, 0.5367431640625, 0.825589358806610107, 120, 255, 1, 46879), -- Crate of Mail Armor (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+54, 251496, 1220, 7334, 7348, '0', 0, 0, -659.0069580078125, 6563.36279296875, -3.815812349319458, 1.532381772994995117, 0, 0, 0.693395614624023437, 0.720557093620300292, 120, 255, 1, 46879), -- Naga Weaponry (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+55, 241908, 1220, 7334, 7348, '0', 0, 0, -575.2899169921875, 6493.22998046875, -5.37338495254516601, 1.797549247741699218, 0.031445980072021484, -0.00447654724121093, 0.782444000244140625, 0.621910393238067626, 120, 255, 1, 46879), -- Prince's Plunder (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+56, 245221, 1220, 7334, 7348, '0', 0, 0, -671.54864501953125, 6515.1865234375, -5.17141199111938476, 2.17999124526977539, 0.084152698516845703, -0.01044750213623046, 0.884522438049316406, 0.458725690841674804, 120, 255, 1, 46879), -- Crate of Mail Armor (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+57, 251496, 1220, 7334, 7348, '0', 0, 0, -670.40277099609375, 6503.64404296875, -7.70304012298583984, 3.311374425888061523, 0, 0, -0.99639892578125, 0.084788881242275238, 120, 255, 1, 46879), -- Naga Weaponry (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+58, 241908, 1220, 7334, 7348, '0', 0, 0, -672.72918701171875, 6655.0322265625, -1.65610790252685546, 5.84157562255859375, -0.05067253112792968, -0.10024356842041015, -0.22056770324707031, 0.968882560729980468, 120, 255, 1, 46879), -- Prince's Plunder (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+59, 241908, 1220, 7334, 7348, '0', 0, 0, -690.092041015625, 6472.4599609375, -11.9375228881835937, 2.44327092170715332, 0.1021728515625, -0.11874771118164062, 0.924378395080566406, 0.347827911376953125, 120, 255, 1, 46879), -- Prince's Plunder (Area: Oceanus Cove - Difficulty: 0) +(@OGUID+60, 245221, 1220, 7334, 7348, '0', 0, 0, -733.12152099609375, 6423.45068359375, -14.0424060821533203, 2.889130592346191406, 0.068974494934082031, -0.03550434112548828, 0.98880767822265625, 0.12744140625, 120, 255, 1, 46879); -- Crate of Mail Armor (Area: Oceanus Cove - Difficulty: 0) + +-- Template data +UPDATE `creature_template` SET `unit_flags3`=16777217, `VerifiedBuild`=46702 WHERE `entry`=55370; -- General Purpose Bunny ZTO +UPDATE `creature_template` SET `unit_flags3`=16777217, `VerifiedBuild`=46702 WHERE `entry`=91524; -- Cannon +UPDATE `creature_template` SET `BaseAttackTime`=2000, `unit_flags`=16448, `VerifiedBuild`=46702 WHERE `entry`=89884; -- Flog the Captain-Eater +UPDATE `creature_template` SET `VerifiedBuild`=46702 WHERE `entry` IN (89097, 97283, 97018, 89386, 88094, 89199, 93513, 91528, 91544); +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (91528, 89884, 91524, 91544); + +UPDATE `gameobject_template` SET `ContentTuningId`=331, `VerifiedBuild`=46702 WHERE `entry` IN (241909, 245862); -- Skrog Weapons +UPDATE `gameobject_template` SET `ContentTuningId`=331, `VerifiedBuild`=46879 WHERE `entry`=241908; -- Prince's Plunder +UPDATE `gameobject_template` SET `ContentTuningId`=348, `VerifiedBuild`=46879 WHERE `entry`=245221; -- Crate of Mail Armor + +DELETE FROM `gameobject_template_addon` WHERE `entry` IN (241909, 245862, 241908, 245221); +INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES +(241909, 0, 262144, 0, 0), -- Skrog Weapons +(245862, 0, 262144, 0, 0), -- Skrog Weapons +(241908, 0, 2113536, 0, 0), -- Prince's Plunder +(245221, 0, 4, 0, 0); -- Crate of Mail Armor + +-- Creature Template movement +DELETE FROM `creature_template_movement` WHERE `CreatureId`=97018; +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`, `InteractionPauseTimer`) VALUES +(97018, 0, 0, 1, 0, 0, 0, NULL); + +-- Creature text +DELETE FROM `creature_text` WHERE `CreatureID`=91544; +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(91544, 0, 0, 'Stand to and bring that thing down or its the gullet for all of you.', 14, 0, 100, 0, 0, 0, 93617, 0, 'Captain Blindside'); + +-- Condition +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=1 AND `SourceEntry`=181573; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 1, 181573, 0, 0, 31, 0, 3, 55370, 0, 0, 0, 0, '', 'Spell \'Anchor Drag\' EFFECT_0 can only hit \'General Purpose Bunny ZTO\''); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=1 AND `SourceEntry`=181593; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 1, 181593, 0, 0, 31, 0, 3, 89884, 0, 0, 0, 0, '', 'Spell \'Fire Cannon\' EFFECT_0 can only hit \'Flog the Captain-Eater\''); + +-- SAI +DELETE FROM `smart_scripts` WHERE `entryorguid`=91528 AND `source_type`=0 AND `id`=0 AND `link`=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 +(91528, 0, 0, 0, 1, 0, 100, 0, 0, 0, 1210, 1210, 0, '', 5, 36, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Southsea Smuggler - OOC Every 1.21s - Play Emote 36 - to self'); + +DELETE FROM `smart_scripts` WHERE `entryorguid` = 89884 AND `source_type`=0 AND `id`=0 AND `link`=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 +(89884, 0, 0, 0, 25, 0, 100, 0, 0, 0, 0, 0, 0, '', 11, 181573, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Flog the Captain-Eater - After Combat, On Respawn or Spawn - Cast spell "Anchor Drag" - to self'); + +DELETE FROM `smart_scripts` WHERE `entryorguid` = 91524 AND `source_type`=0 AND `id`=0 AND `link`=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 +(91524, 0, 0, 0, 1, 0, 100, 0, 0, 0, 1200, 17000, 0, '', 11, 181593, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Fire Cannon - OOC - Cast spell "Fire Cannon" - to self'); + +DELETE FROM `smart_scripts` WHERE `entryorguid`=91544 AND `source_type`=0 AND `id`=0 AND `link`=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 +(91544, 0, 0, 0, 1, 0, 100, 0, 600000, 720000, 600000, 720000, 0, '', 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Captain Blindside - OOC - Say text'); + +DELETE FROM `creature` WHERE `guid` IN (651446, 651460, 651392, 651446, 651448, 651420); +DELETE FROM `creature_addon` WHERE `guid` IN (651446, 651460, 651392, 651446, 651448, 651420); + +-- Waypoints for CGUID+26 +SET @PATH := ((@CGUID+26 * 10) << 3); +UPDATE `creature_addon` SET `path_id` = @PATH WHERE `guid` = @CGUID+26; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -950.684, 6527.042, 0.258884, 0), +(@PATH, 1, -939.7778, 6514.127, 0.258884, 0), +(@PATH, 2, -925.618, 6508.127, 0.258884, 0), +(@PATH, 3, -913.7743, 6511.397, 0.258884, 0), +(@PATH, 4, -903.7743, 6518.424, 0.5323215, 0), +(@PATH, 5, -893.382, 6526.011, 1.163597, 0), +(@PATH, 6, -885.5764, 6534.197, 1.092624, 0), +(@PATH, 7, -873.3264, 6548.729, 0.258884, 0), +(@PATH, 8, -864.757, 6570.347, 0.2766724, 0), +(@PATH, 9, -863.4358, 6588.01, 0.2766724, 0), +(@PATH, 10, -868.5208, 6606.473, 0.2817106, 0), +(@PATH, 11, -888.0712, 6622.962, 0.1567106, 0), +(@PATH, 12, -909.1146, 6632.991, 0.258884, 0), +(@PATH, 13, -920.691, 6631.66, 0.258884, 0), +(@PATH, 14, -932.9792, 6617.264, 0.258884, 0), +(@PATH, 15, -943.8351, 6602.91, 0.2768886, 0), +(@PATH, 16, -950.7535, 6586.358, 0.258884, 0), +(@PATH, 17, -955.9844, 6565.171, 0.258884, 0), +(@PATH, 18, -955.3577, 6549.077, 0.258884, 0); + +-- Waypoints for CGUID+24 +SET @PATH := ((@CGUID+24 * 10) << 3); +DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+24; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@CGUID+24, @CGUID+24, 0, 0, 515, 0, 0), +(@CGUID+24, @CGUID+27, 4, 270, 515, 6, 14); + +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -907.5347, 6470.977, 0.9999864, 0), +(@PATH, 1, -900.783, 6460.366, 1.052395, 0), +(@PATH, 2, -891.4722, 6446.677, 0.8308258, 0), +(@PATH, 3, -878.8438, 6430.189, 0.9733076, 0), +(@PATH, 4, -863.0521, 6420.293, 0.9779568, 0), +(@PATH, 5, -840.7813, 6411.673, 0.9334011, 0), +(@PATH, 6, -825.9739, 6413.653, 0.6863825, 0), +(@PATH, 7, -819.0799, 6418.031, 0.3845026, 0), +(@PATH, 8, -825.9739, 6413.653, 0.6863825, 0), +(@PATH, 9, -840.7813, 6411.673, 0.9334011, 0), +(@PATH, 10, -863.0521, 6420.293, 0.9779568, 0), +(@PATH, 11, -878.8438, 6430.189, 0.9733076, 0), +(@PATH, 12, -891.4722, 6446.677, 0.8308258, 0), +(@PATH, 13, -900.783, 6460.366, 1.052395, 0), +(@PATH, 14, -907.5347, 6470.977, 0.9999864, 0), +(@PATH, 15, -911.9184, 6479.305, 0.8749864, 2621); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+24; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+24, @PATH, 1); + +-- Waypoints for CGUID+42 +SET @PATH := ((@CGUID+42 * 10) << 3); +DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+42; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@CGUID+42, @CGUID+42, 0, 0, 515, 0, 0), +(@CGUID+42, @CGUID+43, 4, 270, 515, 0, 0); + +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -874.9583, 6624.446, 0.4067106, 0), +(@PATH, 1, -862.3785, 6613.674, 0.3945652, 0), +(@PATH, 2, -855.9861, 6606.248, 0.8491551, 0), +(@PATH, 3, -853.6893, 6598.392, 0.6359253, 0), +(@PATH, 4, -852.8646, 6580.444, 1.089172, 0), +(@PATH, 5, -856.6545, 6562.377, 0.6707439, 0), +(@PATH, 6, -866.2674, 6543.617, 0.5171795, 0), +(@PATH, 7, -878.5104, 6530.127, 1.557152, 0), +(@PATH, 8, -894.8299, 6512.844, 0.6150129, 0), +(@PATH, 9, -904.3351, 6505.367, 0.5945774, 0), +(@PATH, 10, -919.2813, 6498.851, 0.3749864, 0), +(@PATH, 11, -930.5955, 6499.832, 0.5665147, 0), +(@PATH, 12, -942.507, 6507.707, 0.8223606, 0), +(@PATH, 13, -951.5087, 6516.278, 0.3680149, 0), +(@PATH, 14, -957.0677, 6527.683, 0.258884, 0), +(@PATH, 15, -959.6684, 6540.981, 0.6570774, 0), +(@PATH, 16, -963.6113, 6558.16, 0.508884, 0), +(@PATH, 17, -950.9531, 6600.96, 0.2768886, 0), +(@PATH, 18, -942.6545, 6618.702, 0.1518886, 0), +(@PATH, 19, -929.7413, 6636.557, 0.4080675, 0), +(@PATH, 20, -909.2205, 6641.018, 0.5921495, 0), +(@PATH, 21, -889.6962, 6634.01, 0.2201753, 0); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+42; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+42, @PATH, 1); + +-- Waypoints for CGUID+41 +SET @PATH := ((@CGUID+41 * 10) << 3); +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -890.757, 6476.261, 3.173592, 8909), +(@PATH, 1, -896.1528, 6482.935, 2.623299, 0), +(@PATH, 2, -901.1719, 6491.491, 1.968736, 0), +(@PATH, 3, -899.2153, 6501.049, 1.150535, 0), +(@PATH, 4, -892.4636, 6508.715, 0.6821516, 0), +(@PATH, 5, -882.717, 6517.142, 1.710594, 0), +(@PATH, 6, -874.5799, 6522.51, 2.154808, 0), +(@PATH, 7, -870.4948, 6522.576, 2.388695, 0), +(@PATH, 8, -868.6953, 6520.174, 3.182152, 10207), +(@PATH, 9, -874.5799, 6522.51, 2.154808, 0), +(@PATH, 10, -882.717, 6517.142, 1.710594, 0), +(@PATH, 11, -892.4636, 6508.715, 0.6821516, 0), +(@PATH, 12, -899.2153, 6501.049, 1.150535, 0), +(@PATH, 13, -901.1719, 6491.491, 1.968736, 0), +(@PATH, 14, -896.1528, 6482.935, 2.623299, 0); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+41; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+41, @PATH, 1); + +-- Waypoints for CGUID+60 +SET @PATH := ((@CGUID+60 * 10) << 3); +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -932.0313, 6535.053, -0.616116, 15097), +(@PATH, 1, -957.033, 6516.28, 0.8831516, 0), +(@PATH, 2, -967.5399, 6516.055, 2.942868, 0), +(@PATH, 3, -981.3559, 6513.21, 5.290158, 0), +(@PATH, 4, -986.7188, 6509.835, 6.788693, 0), +(@PATH, 5, -993.7222, 6508.792, 8.183957, 0), +(@PATH, 6, -999.4566, 6508.658, 8.715207, 10098), +(@PATH, 7, -993.7222, 6508.792, 8.183957, 0), +(@PATH, 8, -986.7188, 6509.835, 6.788693, 0), +(@PATH, 9, -981.3559, 6513.21, 5.290158, 0), +(@PATH, 10, -967.5399, 6516.055, 2.942868, 0), +(@PATH, 11, -957.033, 6516.28, 0.8831516, 0); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+60; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+60, @PATH, 1); + +-- Waypoints for CGUID+90 +SET @PATH := ((@CGUID+90 * 10) << 3); +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -835.5538, 6647.838, 3.100126, 0), +(@PATH, 1, -836.1736, 6653.472, 4.057768, 0), +(@PATH, 2, -839.7309, 6656.919, 3.33206, 0), +(@PATH, 3, -845.3802, 6657.846, 0.07632232, 0), +(@PATH, 4, -854.1094, 6662.075, -1.498873, 0), +(@PATH, 5, -853.25, 6672.035, -1.493739, 0), +(@PATH, 6, -858.4722, 6682.793, 0.8789415, 0), +(@PATH, 7, -855.6927, 6687.879, 0.2732286, 0), +(@PATH, 8, -853.0695, 6691.119, 0.5885363, 0), +(@PATH, 9, -845.8594, 6694.331, 1.704015, 15062), +(@PATH, 10, -853.0695, 6691.119, 0.5885363, 0), +(@PATH, 11, -855.6927, 6687.879, 0.2732286, 0), +(@PATH, 12, -858.4722, 6682.793, 0.8789415, 0), +(@PATH, 13, -853.2535, 6672.094, -1.508265, 0), +(@PATH, 14, -854.1094, 6662.075, -1.498873, 0), +(@PATH, 15, -845.3802, 6657.846, 0.07632232, 0), +(@PATH, 16, -839.7309, 6656.919, 3.33206, 0), +(@PATH, 17, -836.1736, 6653.472, 4.057768, 0), +(@PATH, 18, -835.5538, 6647.838, 3.100126, 0), +(@PATH, 19, -834.0833, 6640.378, 2.195951, 0), +(@PATH, 20, -827.9097, 6634.931, 5.161022, 0), +(@PATH, 21, -823.291, 6633.007, 5.363908, 0), +(@PATH, 22, -827.9097, 6634.931, 5.161022, 0), +(@PATH, 23, -834.0833, 6640.378, 2.195951, 0); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+90; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+90, @PATH, 1); + +-- Waypoints for CGUID+91 +SET @PATH := ((@CGUID+91 * 10) << 3); +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -878.618, 6673.234, 0.1890473, 0), +(@PATH, 1, -861.816, 6698.393, 0.7562609, 0), +(@PATH, 2, -853.0938, 6711.299, 0.8454609, 0), +(@PATH, 3, -841.3785, 6726.351, 0.3454609, 0), +(@PATH, 4, -833.8594, 6737.033, 0.3782501, 0), +(@PATH, 5, -825.118, 6748.022, 0.5009674, 0), +(@PATH, 6, -818.3924, 6754.391, 0.9096588, 0), +(@PATH, 7, -811.6927, 6759.616, 0.7560943, 0), +(@PATH, 8, -818.3924, 6754.391, 0.9096588, 0), +(@PATH, 9, -825.118, 6748.022, 0.5009674, 0), +(@PATH, 10, -833.8594, 6737.033, 0.3782501, 0), +(@PATH, 11, -841.3785, 6726.351, 0.3454609, 0), +(@PATH, 12, -853.0313, 6711.358, 0.8454609, 0), +(@PATH, 13, -861.816, 6698.393, 0.7562609, 0); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+91; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+91, @PATH, 1); + +-- Waypoints for CGUID+114 +SET @PATH := ((@CGUID+114 * 10) << 3); +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -889.1389, 6672.59, 2.363242, 0), +(@PATH, 1, -880.1111, 6682.347, 1.140952, 0), +(@PATH, 2, -877.3889, 6690.335, 1.095175, 14785), +(@PATH, 3, -880.1111, 6682.347, 1.140952, 0), +(@PATH, 4, -889.1389, 6672.59, 2.363242, 0), +(@PATH, 5, -897.6111, 6672.86, 4.978598, 0), +(@PATH, 6, -910.0139, 6673.222, 9.379537, 0), +(@PATH, 7, -918.9961, 6672.625, 11.95046, 10771), +(@PATH, 8, -910.041, 6673.224, 9.450459, 0), +(@PATH, 9, -897.6111, 6672.86, 4.978598, 0); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+114; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+114, @PATH, 1); + +-- Waypoints for CGUID+124 +SET @PATH := ((@CGUID+124 * 10) << 3); +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -788.5261, 6804.029, 7.319728, 0), +(@PATH, 1, -794.1354, 6810.137, 9.14883, 0), +(@PATH, 2, -796.757, 6815.807, 9.700954, 0), +(@PATH, 3, -801.7066, 6818.094, 10.29579, 0), +(@PATH, 4, -805.2324, 6814.544, 11.26112, 0), +(@PATH, 5, -807.1667, 6808.656, 11.45716, 0), +(@PATH, 6, -804.6476, 6800.827, 9.408825, 0), +(@PATH, 7, -799.684, 6792.938, 7.101137, 0), +(@PATH, 8, -797.1493, 6785.817, 5.657167, 0), +(@PATH, 9, -789.8316, 6776.585, 5.489565, 6432), +(@PATH, 10, -797.1493, 6785.817, 5.657167, 0), +(@PATH, 11, -799.684, 6792.938, 7.101137, 0), +(@PATH, 12, -804.6476, 6800.827, 9.408825, 0), +(@PATH, 13, -807.1667, 6808.656, 11.45716, 0), +(@PATH, 14, -805.2552, 6814.516, 11.14735, 0), +(@PATH, 15, -801.7305, 6818.065, 10.26112, 0), +(@PATH, 16, -796.757, 6815.807, 9.700954, 0), +(@PATH, 17, -794.1354, 6810.137, 9.14883, 0), +(@PATH, 18, -788.5261, 6804.029, 7.319728, 0), +(@PATH, 19, -782.0504, 6800.479, 6.032619, 0), +(@PATH, 20, -776.6667, 6794.838, 5.793276, 8548), +(@PATH, 21, -782.0504, 6800.479, 6.032619, 0); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+124; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+124, @PATH, 1); + +-- Waypoints for CGUID+130 +SET @PATH := ((@CGUID+130 * 10) << 3); +DELETE FROM `creature_formations` WHERE `leaderGUID` = @CGUID+130; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@CGUID+130, @CGUID+130, 0, 0, 515, 0, 0), +(@CGUID+130, @CGUID+137, 4, 270, 515, 0, 0); + +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -761.4705, 6775.325, 0.6374264, 0), +(@PATH, 1, -776.3472, 6764.287, 0.5264795, 0), +(@PATH, 2, -788.1198, 6761.275, 0.803457, 0), +(@PATH, 3, -798.7952, 6767.385, 2.065493, 0), +(@PATH, 4, -791.4809, 6774.857, 5.212709, 0), +(@PATH, 5, -799.4323, 6785.283, 5.622988, 0), +(@PATH, 6, -797.0781, 6794.911, 7.028261, 0), +(@PATH, 7, -790.0643, 6799.653, 7.108706, 0), +(@PATH, 8, -779.2136, 6806.064, 5.902614, 0), +(@PATH, 9, -767.5, 6806.603, 2.358058, 0), +(@PATH, 10, -755.1788, 6805.003, 0.3555447, 0), +(@PATH, 17, -742.9739, 6797.471, 0.8783932, 0), +(@PATH, 18, -733.7483, 6791.713, 1.262426, 0), +(@PATH, 19, -716.4636, 6798.418, 0.2032738, 0), +(@PATH, 20, -705.4653, 6806.976, -0.1444553, 0), +(@PATH, 21, -693.6805, 6818.479, 0.6838857, 0), +(@PATH, 22, -684.1285, 6828.734, 0.6539785, 0), +(@PATH, 23, -674.7552, 6836.087, 0.6395051, 0), +(@PATH, 24, -664.7952, 6838.618, 0.2645051, 0), +(@PATH, 25, -656.7465, 6838.226, 0.7645051, 0), +(@PATH, 26, -648.4618, 6834.218, 0.5145051, 0), +(@PATH, 27, -643.1129, 6830.532, 0.5977525, 0), +(@PATH, 28, -648.4618, 6834.218, 0.5145051, 0), +(@PATH, 29, -656.7465, 6838.226, 0.7645051, 0), +(@PATH, 30, -664.7952, 6838.618, 0.2645051, 0), +(@PATH, 31, -674.7552, 6836.087, 0.6395051, 0), +(@PATH, 32, -684.1285, 6828.734, 0.6539785, 0), +(@PATH, 33, -693.6805, 6818.479, 0.6838857, 0), +(@PATH, 34, -705.4653, 6806.976, -0.1444553, 0), +(@PATH, 35, -716.4636, 6798.418, 0.2032738, 0), +(@PATH, 36, -733.7483, 6791.713, 1.262426, 0), +(@PATH, 37, -742.9739, 6797.471, 0.8783932, 0), +(@PATH, 38, -755.1788, 6805.003, 0.3555447, 0), +(@PATH, 39, -767.5, 6806.603, 2.358058, 0), +(@PATH, 40, -779.2136, 6806.064, 5.902614, 0), +(@PATH, 41, -790.0643, 6799.653, 7.108706, 0), +(@PATH, 42, -797.0781, 6794.911, 7.028261, 0), +(@PATH, 43, -799.4323, 6785.283, 5.622988, 0), +(@PATH, 44, -791.4809, 6774.857, 5.212709, 0), +(@PATH, 45, -798.7952, 6767.385, 2.065493, 0), +(@PATH, 46, -788.1198, 6761.275, 0.803457, 0), +(@PATH, 47, -776.3472, 6764.287, 0.5264795, 0), +(@PATH, 48, -761.4705, 6775.325, 0.6374264, 0), +(@PATH, 49, -749.4879, 6781.281, 0.5112057, 0), +(@PATH, 50, -739.2413, 6788.087, 1.115942, 0), +(@PATH, 51, -733.0729, 6791.949, 1.481838, 0), +(@PATH, 52, -723.3195, 6794.321, 0.1830101, 0), +(@PATH, 53, -708.5121, 6803.189, -0.01945531, 0), +(@PATH, 54, -697.7795, 6812.877, 0.2789785, 0), +(@PATH, 55, -687.493, 6824.095, 0.592455, 0), +(@PATH, 56, -679.3351, 6832.366, 0.6962148, 0), +(@PATH, 57, -671.2049, 6837.796, 0.4966829, 0), +(@PATH, 58, -660.7031, 6838.856, 0.4423615, 0), +(@PATH, 59, -652.4722, 6837.308, 0.8736359, 0), +(@PATH, 60, -646.5816, 6833.49, 0.5145051, 0), +(@PATH, 61, -643.0486, 6830.61, 0.605565, 0), +(@PATH, 62, -646.5816, 6833.49, 0.5145051, 0), +(@PATH, 63, -652.4722, 6837.308, 0.8736359, 0), +(@PATH, 64, -660.7031, 6838.856, 0.4423615, 0), +(@PATH, 65, -671.2049, 6837.796, 0.4966829, 0), +(@PATH, 66, -679.3351, 6832.366, 0.6962148, 0), +(@PATH, 67, -687.493, 6824.095, 0.592455, 0), +(@PATH, 68, -697.7795, 6812.877, 0.2789785, 0), +(@PATH, 69, -708.5121, 6803.189, -0.01945531, 0), +(@PATH, 70, -723.3195, 6794.321, 0.1830101, 0), +(@PATH, 71, -733.0729, 6791.949, 1.481838, 0), +(@PATH, 72, -739.2413, 6788.087, 1.115942, 0), +(@PATH, 73, -749.4879, 6781.281, 0.5112057, 0); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+130; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+130, @PATH, 1); + +-- Waypoint for CGUID+163 +SET @PATH := ((@CGUID+163 * 10) << 3); +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -602.9774, 6867.322, 0.8475696, 0), +(@PATH, 1, -596.5347, 6871.486, 0.315205, 0), +(@PATH, 2, -591.1805, 6872.268, 0.1779979, 0), +(@PATH, 3, -586.8438, 6870.686, 0.7904247, 7310), +(@PATH, 4, -591.1805, 6872.268, 0.1779979, 0), +(@PATH, 5, -596.5347, 6871.486, 0.315205, 0), +(@PATH, 6, -602.9774, 6867.322, 0.8475696, 0), +(@PATH, 9, -608.9011, 6859.061, 0.5222015, 0), +(@PATH, 10, -611.3871, 6852.063, 0.7530364, 0), +(@PATH, 11, -611.8004, 6846.938, 1.90831, 11288), +(@PATH, 12, -611.3871, 6852.063, 0.7530364, 0), +(@PATH, 13, -608.9011, 6859.061, 0.5222015, 0); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+163; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+163, @PATH, 1); + +-- Waypoint for CGUID+149 +SET @PATH := ((@CGUID+149 * 10) << 3); +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -682.4757, 6897.734, 6.777429, 0), +(@PATH, 1, -677.4097, 6902.479, 5.571411, 0), +(@PATH, 2, -673.7483, 6905.505, 5.344604, 0), +(@PATH, 3, -670.2361, 6908.405, 5.986938, 0), +(@PATH, 4, -668.1771, 6911.019, 6.610595, 0), +(@PATH, 5, -667.1458, 6913.815, 7.160034, 0), +(@PATH, 6, -669.2778, 6916.726, 7.483032, 11848), +(@PATH, 7, -668.1771, 6911.019, 6.610595, 0), +(@PATH, 8, -670.2361, 6908.405, 5.986938, 0), +(@PATH, 9, -673.7483, 6905.505, 5.344604, 0), +(@PATH, 10, -677.4097, 6902.479, 5.571411, 0), +(@PATH, 11, -682.4757, 6897.734, 6.777429, 0), +(@PATH, 12, -687.2205, 6893.637, 7.838098, 0), +(@PATH, 13, -691.382, 6893.816, 9.084803, 12982); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+149; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+149, @PATH, 1); + +-- Waypoints for CGUID+134 +SET @PATH := ((@CGUID+134 * 10) << 3); +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -676.3768, 6814.268, 0.1515371, 0), +(@PATH, 1, -684.5208, 6813.256, 0.1539785, 0), +(@PATH, 2, -696.8316, 6809.124, 0.1539785, 0), +(@PATH, 3, -704.6979, 6800.669, -0.1444553, 0), +(@PATH, 4, -710.5208, 6789.328, -0.1717262, 0), +(@PATH, 5, -713.1285, 6779.46, -0.1717262, 0), +(@PATH, 6, -714.1927, 6765.266, 0.00760293, 0), +(@PATH, 7, -714.967, 6755.458, 2.534825, 0), +(@PATH, 8, -711.4445, 6747.997, 4.451694, 0), +(@PATH, 9, -709.375, 6746.343, 4.510288, 0), +(@PATH, 10, -704.007, 6744.055, 6.589634, 0), +(@PATH, 11, -702.9636, 6739.95, 9.151157, 0), +(@PATH, 12, -705.0018, 6737.245, 9.088779, 12036), +(@PATH, 13, -704.007, 6744.055, 6.589634, 0), +(@PATH, 14, -709.375, 6746.343, 4.510288, 0), +(@PATH, 15, -711.4445, 6747.997, 4.451694, 0), +(@PATH, 16, -714.967, 6755.458, 2.534825, 0), +(@PATH, 17, -714.1927, 6765.266, 0.00760293, 0), +(@PATH, 18, -713.1285, 6779.46, -0.1717262, 0), +(@PATH, 19, -710.5208, 6789.328, -0.1717262, 0), +(@PATH, 20, -704.6979, 6800.669, -0.1444553, 0), +(@PATH, 21, -696.8316, 6809.124, 0.1539785, 0), +(@PATH, 22, -684.5208, 6813.256, 0.1539785, 0), +(@PATH, 23, -676.3768, 6814.268, 0.1515371, 0), +(@PATH, 24, -669.6563, 6810.724, 0.5544912, 0), +(@PATH, 25, -665.5052, 6800.084, 1.838109, 0), +(@PATH, 26, -664.5399, 6792.665, 4.889852, 0), +(@PATH, 27, -664.4566, 6788.379, 6.61324, 4810), +(@PATH, 28, -664.5399, 6792.665, 4.889852, 0), +(@PATH, 29, -665.5052, 6800.084, 1.838109, 0), +(@PATH, 30, -669.6563, 6810.724, 0.5544912, 0); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+134; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+134, @PATH, 1); + +-- Waypoints for CGUID+168 +SET @PATH := ((@CGUID+168 * 10) << 3); +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -612.9097, 6734.817, -0.8487108, 0), +(@PATH, 1, -619.0243, 6745.392, -1.606079, 0), +(@PATH, 2, -623.7604, 6751.882, -1.265022, 0), +(@PATH, 3, -631.467, 6772.971, -1.081603, 0), +(@PATH, 4, -633.4948, 6788.272, 0.3924965, 0), +(@PATH, 5, -639.0868, 6788.049, -0.5989982, 9320), +(@PATH, 6, -633.4948, 6788.272, 0.3924965, 0), +(@PATH, 7, -631.467, 6772.971, -1.081603, 0), +(@PATH, 8, -623.8137, 6752.028, -1.244607, 0), +(@PATH, 9, -619.0243, 6745.392, -1.606079, 0), +(@PATH, 10, -612.9097, 6734.817, -0.8487108, 0), +(@PATH, 11, -608.7986, 6728.213, -1.227856, 0), +(@PATH, 12, -607.7049, 6724.406, -1.477887, 9479); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+168; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+168, @PATH, 1); + +-- Waypoints for CGUID+189 +SET @PATH := ((@CGUID+189 * 10) << 3); +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -546.4636, 6745.757, -3.192686, 0), +(@PATH, 1, -548.3785, 6756.448, -2.793069, 0), +(@PATH, 2, -554.7708, 6763.377, -2.421883, 0), +(@PATH, 3, -564.4114, 6770.322, -1.512674, 0), +(@PATH, 4, -572.4114, 6771.58, 0.3264315, 0), +(@PATH, 5, -578.8924, 6772.742, 1.57954, 0), +(@PATH, 6, -585.2168, 6771.088, 2.665408, 0), +(@PATH, 7, -592.0972, 6769.835, 0.8394823, 0), +(@PATH, 8, -598.0643, 6766.119, -0.3774234, 0), +(@PATH, 9, -603.6823, 6755.264, -1.027009, 0), +(@PATH, 10, -602.5972, 6745.065, -0.8426746, 0), +(@PATH, 11, -593.1215, 6735.461, -0.8134504, 0), +(@PATH, 12, -582.257, 6730.768, -1.297933, 0), +(@PATH, 13, -571.9861, 6729.543, -3.715058, 0), +(@PATH, 14, -557.5264, 6736.479, -4.464255, 0); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+189; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+189, @PATH, 1); + +-- Waypoints for CGUID+192 +SET @PATH := ((@CGUID+192 * 10) << 3); +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -522.3038, 6742.083, -2.439491, 0), +(@PATH, 1, -521.4809, 6728.422, -1.845145, 0), +(@PATH, 2, -523.3021, 6720.632, -2.014477, 0), +(@PATH, 3, -529.2413, 6715.377, -2.165789, 0), +(@PATH, 4, -533.6458, 6713.04, -2.442631, 0), +(@PATH, 5, -534.4688, 6708.546, -2.609104, 32866), +(@PATH, 6, -533.6458, 6713.04, -2.442631, 0), +(@PATH, 7, -529.2413, 6715.377, -2.165789, 0), +(@PATH, 8, -523.3021, 6720.632, -2.014477, 0), +(@PATH, 9, -521.4809, 6728.422, -1.845145, 0), +(@PATH, 10, -522.3038, 6742.083, -2.439491, 0), +(@PATH, 11, -525.1424, 6753.557, -1.908394, 9727); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+192; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+192, @PATH, 1); + +-- Waypoints for CGUID+129 +SET @PATH := ((@CGUID+129 * 10) << 3); +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -606.5243, 6781.788, -3.517866, 0), +(@PATH, 1, -610.7535, 6752.195, -2.36381, 0), +(@PATH, 2, -597.5521, 6735.047, -0.961401, 0), +(@PATH, 3, -574.6268, 6724.594, -2.57423, 0), +(@PATH, 4, -550.3542, 6724.993, -2.381176, 0), +(@PATH, 5, -536.4583, 6717.87, -1.986443, 0), +(@PATH, 6, -529.4861, 6706.537, -3.101636, 0), +(@PATH, 7, -524.4375, 6692.022, -4.386474, 12376), +(@PATH, 8, -530.9948, 6731.088, -1.990176, 0), +(@PATH, 9, -536.9653, 6751.838, -2.551496, 0), +(@PATH, 10, -563.3733, 6779.003, -3.365569, 0), +(@PATH, 11, -589.1996, 6795.673, -2.879963, 0), +(@PATH, 12, -605.9792, 6803.417, -1.313295, 0), +(@PATH, 13, -617.0903, 6810.386, 1.695207, 14026); + +UPDATE `creature_addon` SET `path_id` = @PATH WHERE `guid` = @CGUID+129; + +-- Waypoints for CGUID+207 +SET @PATH := ((@CGUID+207 * 10) << 3); +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 1, -575.1389, 6632.951, -10.5486, 0), +(@PATH, 2, -567.5347, 6640.577, -9.436355, 0), +(@PATH, 3, -562.6899, 6647.589, -8.877408, 0), +(@PATH, 4, -552.0313, 6658.005, -8.010046, 0), +(@PATH, 5, -537.5903, 6666.44, -6.917422, 0), +(@PATH, 6, -535.9547, 6672.727, -6.62231, 23946), +(@PATH, 7, -562.6007, 6647.718, -8.887341, 0), +(@PATH, 8, -567.5347, 6640.577, -9.436355, 0), +(@PATH, 9, -575.1389, 6632.951, -10.5486, 0), +(@PATH, 10, -586.6077, 6628.804, -10.309, 20194); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+207; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+207, @PATH, 1); + +-- Waypoints for CGUID+225 +SET @PATH := ((@CGUID+225 * 10) << 3); +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -661.1198, 6487.894, -12.6888, 8135), +(@PATH, 1, -670.7934, 6494.552, -9.432038, 0), +(@PATH, 2, -679.6918, 6507.1, -5.027595, 0), +(@PATH, 3, -679.8021, 6529.891, -3.837231, 0), +(@PATH, 4, -678.316, 6549.401, -3.522604, 0), +(@PATH, 5, -671.6597, 6563.111, -4.525078, 0), +(@PATH, 6, -659.0955, 6567.792, -5.292948, 0), +(@PATH, 7, -642.309, 6569.799, -2.662143, 0), +(@PATH, 8, -633.7448, 6568.119, -2.685596, 0), +(@PATH, 9, -626.1858, 6563.882, -1.910463, 0), +(@PATH, 10, -623.434, 6561.638, -1.103593, 12759), +(@PATH, 11, -633.7448, 6568.119, -2.685596, 0), +(@PATH, 12, -642.309, 6569.799, -2.662143, 0), +(@PATH, 13, -659.0955, 6567.792, -5.292948, 0), +(@PATH, 14, -671.6597, 6563.111, -4.525078, 0), +(@PATH, 15, -678.316, 6549.401, -3.522604, 0), +(@PATH, 16, -679.7949, 6529.985, -3.833877, 0), +(@PATH, 17, -679.6986, 6507.267, -4.998388, 0), +(@PATH, 18, -670.7934, 6494.552, -9.432038, 0); +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+225; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+225, @PATH, 1); + +-- Waypoints for CGUID+203 +SET @PATH := ((@CGUID+203 * 10) << 3); +UPDATE `creature_addon` SET `path_id` = @PATH WHERE `guid` = @CGUID+203; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -553.1823, 6623.632, -10.72044, 0), +(@PATH, 1, -536.5677, 6653.049, -9.810242, 0), +(@PATH, 2, -529.3646, 6665.233, -7.492726, 11776), +(@PATH, 3, -536.4948, 6653.172, -9.803768, 0), +(@PATH, 4, -553.1823, 6623.632, -10.72044, 0), +(@PATH, 5, -575.2813, 6607.79, -10.96224, 0), +(@PATH, 6, -596.1354, 6600.241, -10.4851, 0), +(@PATH, 7, -610.6077, 6597.864, -7.343277, 11561), +(@PATH, 8, -596.1354, 6600.241, -10.4851, 0), +(@PATH, 9, -575.2813, 6607.79, -10.96224, 0); + +-- Waypoints for CGUID+75 +SET @PATH := ((@CGUID+75 * 10) << 3); +UPDATE `creature_addon` SET `path_id` = @PATH WHERE `guid` = @CGUID+75; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -676.4549, 6603.991, -3.855994, 0), +(@PATH, 1, -656.0886, 6601.588, -6.189635, 0), +(@PATH, 2, -631.9393, 6599.356, -5.370617, 15714), +(@PATH, 3, -655.9644, 6601.577, -6.237308, 0), +(@PATH, 4, -676.4549, 6603.991, -3.855994, 0), +(@PATH, 5, -703.4688, 6600.92, 2.1835, 0), +(@PATH, 6, -722.9581, 6597.16, 3.01436, 0), +(@PATH, 7, -755.1945, 6596.842, -1.665176, 0), +(@PATH, 8, -786.679, 6603.244, -1.158356, 0), +(@PATH, 9, -804.6582, 6605.959, 0.9889083, 47249), +(@PATH, 10, -786.8333, 6603.275, -1.158757, 0), +(@PATH, 11, -755.1945, 6596.842, -1.665176, 0), +(@PATH, 12, -723.0087, 6597.15, 3.007033, 0), +(@PATH, 13, -703.4688, 6600.92, 2.1835, 0); + +-- Waypoints for CGUID+15 +SET @PATH := ((@CGUID+15 * 10) << 3); +UPDATE `creature_addon` SET `path_id` = @PATH WHERE `guid` = @CGUID+15; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -802.0608, 6492.027, 0.673588, 0), +(@PATH, 1, -799.0718, 6471.578, 0.275999, 0), +(@PATH, 2, -801.7396, 6453.868, 1.974996, 0), +(@PATH, 3, -808.5989, 6433.135, 0.7034723, 13929), +(@PATH, 4, -798.7153, 6451.863, 1.646798, 0), +(@PATH, 5, -792.4358, 6465.444, -0.4266195, 0), +(@PATH, 6, -772.3438, 6480.594, -4.562941, 0), +(@PATH, 7, -749.8403, 6484.194, -5.459761, 0), +(@PATH, 8, -729.8854, 6482.764, -6.939956, 0), +(@PATH, 9, -710.4167, 6488.695, -6.710887, 0), +(@PATH, 10, -699.9896, 6502.049, -6.522191, 0), +(@PATH, 11, -689.5226, 6526.634, -5.221442, 0), +(@PATH, 12, -685.0729, 6544.356, -4.515147, 0), +(@PATH, 13, -683.3333, 6559.616, -3.494267, 16658), +(@PATH, 14, -689.8021, 6505.02, -5.485256, 0), +(@PATH, 15, -701.1858, 6489.267, -6.866352, 0), +(@PATH, 16, -723.5208, 6485.088, -6.717724, 0), +(@PATH, 17, -741.4063, 6488.257, -6.288282, 0), +(@PATH, 18, -762.7205, 6491.778, -4.061181, 0), +(@PATH, 19, -780.8976, 6488.689, -3.464918, 0), +(@PATH, 20, -796.0868, 6494.339, -0.2558941, 0), +(@PATH, 21, -811.9566, 6506.726, 2.683488, 0); + +-- Waypoints for CGUID+216 +SET @PATH := ((@CGUID+216 * 10) << 3); +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -781.6077, 6472.954, -2.924516, 0), +(@PATH, 1, -792.1632, 6503.005, 0.3546144, 9075), +(@PATH, 2, -781.6077, 6472.954, -2.924516, 0), +(@PATH, 3, -769.6528, 6469.251, -5.389073, 0), +(@PATH, 4, -763.6354, 6473.338, -5.75027, 0), +(@PATH, 5, -761.0428, 6485.665, -5.260369, 0), +(@PATH, 6, -764.6406, 6500.179, -1.903567, 0), +(@PATH, 7, -765.9531, 6508.492, 0.4402879, 0), +(@PATH, 8, -761.0712, 6511.393, 0.7577024, 0), +(@PATH, 9, -753.1337, 6506.983, -1.122985, 0), +(@PATH, 10, -746.7934, 6502.742, -2.863655, 0), +(@PATH, 11, -734.8264, 6487.039, -6.42943, 0), +(@PATH, 12, -730.1511, 6474.788, -7.521414, 0), +(@PATH, 13, -733.8236, 6458.013, -7.670295, 11002), +(@PATH, 14, -730.1511, 6474.788, -7.521414, 0), +(@PATH, 15, -734.8264, 6487.039, -6.42943, 0), +(@PATH, 16, -746.7934, 6502.742, -2.863655, 0), +(@PATH, 17, -753.1337, 6506.983, -1.122985, 0), +(@PATH, 18, -761.0712, 6511.393, 0.7577024, 0), +(@PATH, 19, -765.9531, 6508.492, 0.4402879, 0), +(@PATH, 20, -764.6406, 6500.179, -1.903567, 0), +(@PATH, 21, -761.0139, 6485.802, -5.248221, 0), +(@PATH, 22, -763.6354, 6473.338, -5.75027, 0), +(@PATH, 23, -769.6528, 6469.251, -5.389073, 0); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+216; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+216, @PATH, 1); + +-- Waypoints for CGUID+53 +SET @PATH := ((@CGUID+53 * 10) << 3); +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -829.2483, 6548.671, 4.224971, 0), +(@PATH, 1, -835.0452, 6553.223, 2.871183, 0), +(@PATH, 2, -838.5625, 6560.042, 2.859587, 0), +(@PATH, 5, -835.9792, 6572.558, 3.64679, 0), +(@PATH, 6, -832.0504, 6578.642, 4.227952, 0), +(@PATH, 7, -827.2552, 6580.075, 4.714036, 0), +(@PATH, 8, -822.7344, 6577.488, 7.134202, 0), +(@PATH, 9, -816.3871, 6574.835, 8.395677, 9307), +(@PATH, 10, -822.7344, 6577.488, 7.134202, 0), +(@PATH, 11, -827.2552, 6580.075, 4.714036, 0), +(@PATH, 12, -832.0504, 6578.642, 4.227952, 0), +(@PATH, 13, -835.9792, 6572.558, 3.64679, 0), +(@PATH, 14, -838.5625, 6560.042, 2.859587, 0), +(@PATH, 15, -835.0452, 6553.223, 2.871183, 0), +(@PATH, 16, -829.2483, 6548.671, 4.224971, 0), +(@PATH, 17, -820.1476, 6542.686, 5.753779, 11882); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+53; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+53, @PATH, 1); + +-- Waypoints for CGUID+240 +SET @PATH := ((@CGUID+240 * 10) << 3); +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -699.7639, 6645.301, 3.169553, 0), +(@PATH, 1, -702.1684, 6653.667, 2.319802, 13106), +(@PATH, 2, -699.7639, 6645.301, 3.169553, 0), +(@PATH, 3, -692.5676, 6642.575, 1.111368, 0), +(@PATH, 4, -683.8195, 6642.344, -1.431269, 0), +(@PATH, 5, -676.3299, 6643.726, -1.387223, 0), +(@PATH, 6, -668.9531, 6644.985, -0.7779691, 0), +(@PATH, 7, -660.6493, 6646.691, 0.8361406, 0), +(@PATH, 8, -649.967, 6647.172, 0.8477491, 15407), +(@PATH, 9, -660.6493, 6646.691, 0.8361406, 0), +(@PATH, 10, -668.9531, 6644.985, -0.7779691, 0), +(@PATH, 11, -676.3299, 6643.726, -1.387223, 0), +(@PATH, 12, -683.8195, 6642.344, -1.431269, 0), +(@PATH, 13, -692.4236, 6642.52, 1.130976, 0); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+240; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+240, @PATH, 1); + +-- Waypoints for CGUID+109 +SET @PATH := ((@CGUID+109 * 10) << 3); +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -713.3246, 6613.659, 4.322826, 0), +(@PATH, 1, -718.1875, 6615.897, 4.854696, 0), +(@PATH, 2, -722.7882, 6608.804, 4.785114, 0), +(@PATH, 3, -727.1476, 6607.185, 4.867548, 0), +(@PATH, 4, -738.8698, 6605.257, 0.4796949, 0), +(@PATH, 5, -752.5243, 6605.307, -1.70408, 0), +(@PATH, 6, -762.8403, 6606.796, -1.555578, 0), +(@PATH, 7, -775.1736, 6609.651, -1.147741, 0), +(@PATH, 8, -780.3524, 6608.563, -1.660752, 0), +(@PATH, 9, -784.0913, 6605.622, -1.457062, 0), +(@PATH, 10, -783.7778, 6600.842, -1.165748, 0), +(@PATH, 11, -780.757, 6595.627, -0.7883918, 0), +(@PATH, 12, -769.7813, 6589.487, -0.9689014, 0), +(@PATH, 13, -758.2413, 6588.174, -0.8745821, 0), +(@PATH, 14, -745.632, 6588.071, -0.9574898, 0), +(@PATH, 15, -733.9114, 6589.647, -0.6109128, 0), +(@PATH, 16, -723.3906, 6592.149, 1.372754, 0), +(@PATH, 17, -712.3455, 6591.817, 1.045359, 0), +(@PATH, 18, -710.033, 6594.53, 1.619264, 0), +(@PATH, 19, -707.2448, 6602.452, 2.834125, 0), +(@PATH, 20, -708.7778, 6607.787, 3.52123, 0); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+109; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+109, @PATH, 1); + +-- Waypoints for CGUID+229 +SET @PATH := ((@CGUID+229 * 10) << 3); +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -705.4445, 6529.844, -2.473737, 0), +(@PATH, 1, -708.0955, 6520.962, -2.19171, 0), +(@PATH, 2, -707.9827, 6511.576, -3.722264, 0), +(@PATH, 3, -704.1719, 6506.307, -6.139216, 0), +(@PATH, 4, -690.2014, 6496.288, -6.067897, 0), +(@PATH, 5, -680.7379, 6495.927, -6.857364, 0), +(@PATH, 6, -676.3299, 6503.387, -6.245034, 0), +(@PATH, 7, -675.8299, 6510.402, -4.950175, 0), +(@PATH, 8, -676.4045, 6522.218, -3.813058, 0), +(@PATH, 9, -673.8663, 6532.965, -3.230746, 0), +(@PATH, 10, -675.5191, 6549.214, -3.187364, 0), +(@PATH, 11, -679.2761, 6563.667, -3.885521, 0), +(@PATH, 12, -686.6424, 6567.455, -3.073523, 0), +(@PATH, 13, -692.5243, 6564.592, -2.54006, 0), +(@PATH, 14, -691.8611, 6552.88, -1.622693, 0), +(@PATH, 15, -697.2136, 6545.181, -1.099491, 0), +(@PATH, 16, -702.6111, 6536.222, -1.621531, 0); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+229; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+229, @PATH, 1); + +-- Waypoints for CGUID+213 +SET @PATH := ((@CGUID+213 * 10) << 3); +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -551.8889, 6567.242, -9.554152, 0), +(@PATH, 1, -557.1031, 6600, -10.05213, 0), +(@PATH, 2, -545.9132, 6610.404, -8.332332, 0), +(@PATH, 3, -538.0417, 6628.511, -7.951262, 0), +(@PATH, 4, -533.5226, 6636.23, -7.852307, 0), +(@PATH, 5, -528.5226, 6645.358, -7.910801, 0), +(@PATH, 6, -518.7136, 6654.244, -7.159576, 26160), +(@PATH, 7, -533.5226, 6636.23, -7.852307, 0), +(@PATH, 8, -538.0417, 6628.511, -7.951262, 0), +(@PATH, 9, -545.9132, 6610.404, -8.332332, 0), +(@PATH, 10, -557.132, 6600.076, -10.088, 0), +(@PATH, 11, -558.0035, 6571.887, -9.109226, 0), +(@PATH, 12, -551.8889, 6567.242, -9.554152, 0), +(@PATH, 13, -543.7725, 6574.048, -8.354779, 11966); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+213; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+213, @PATH, 1); + +-- Waypoints for CGUID+210 +SET @PATH := ((@CGUID+210 * 10) << 3); +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`) VALUES +(@PATH, 0, -561.7413, 6507.968, -10.89258, 0), +(@PATH, 1, -580.243, 6507.726, -10.33165, 0); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+210; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+210, @PATH, 1); |