DB/Drustvar: Added spawns for Mudfish Lodge

1 files changed, 447 insertions, 0 deletions

diff --git a/sql/updates/world/master/2025_07_22_00_world.sql b/sql/updates/world/master/2025_07_22_00_world.sql
new file mode 100644
index 00000000000..bdb698f042a
--- /dev/null
+++ b/sql/updates/world/master/2025_07_22_00_world.sql
@@ -0,0 +1,447 @@
+SET @CGUID := 7003178;
+SET @OGUID := 7000632;
+
+-- Creature
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+94;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES
+(@CGUID+0, 130165, 1643, 8721, 8721, '0', 0, 0, 0, 0, -727.69097900390625, 1355.1146240234375, 23.3473968505859375, 0.372618287801742553, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Highland Shoat (Area: Drustvar - Difficulty: 0) CreateObject2 (possible waypoints or random movement)
+(@CGUID+1, 130165, 1643, 8721, 8721, '0', 0, 0, 0, 0, -738.8211669921875, 1365.69970703125, 26.24887847900390625, 1.485788345336914062, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Highland Shoat (Area: Drustvar - Difficulty: 0) CreateObject2 (possible waypoints or random movement)
+(@CGUID+2, 130165, 1643, 8721, 8721, '0', 0, 0, 0, 0, -664.435791015625, 1375.1319580078125, 29.245819091796875, 0.787384986877441406, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Highland Shoat (Area: Drustvar - Difficulty: 0) CreateObject2
+(@CGUID+3, 127526, 1643, 8721, 9264, '0', 0, 0, 0, 0, -588.20831298828125, 1288.5364990234375, 0.691107034683227539, 5.15903472900390625, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Scavenging Snapclaw (Area: Mudfish Lodge - Difficulty: 0) CreateObject2
+(@CGUID+4, 130165, 1643, 8721, 8721, '0', 0, 0, 0, 0, -722.078125, 1361.3629150390625, 25.68696212768554687, 5.843300819396972656, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Highland Shoat (Area: Drustvar - Difficulty: 0) CreateObject2 (possible waypoints or random movement)
+(@CGUID+5, 129137, 1643, 8721, 8721, '0', 0, 0, 0, 0, -727.26214599609375, 1349.564208984375, 22.97634124755859375, 5.218525886535644531, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Thicket Hare (Area: Drustvar - Difficulty: 0) CreateObject2 (possible waypoints or random movement)
+(@CGUID+6, 130165, 1643, 8721, 8721, '0', 0, 0, 0, 0, -693.203125, 1362.3802490234375, 27.17545318603515625, 1.226134300231933593, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Highland Shoat (Area: Drustvar - Difficulty: 0) CreateObject2 (possible waypoints or random movement)
+(@CGUID+7, 130164, 1643, 8721, 8721, '0', 0, 0, 0, 0, -718.5555419921875, 1358.8125, 25.34671401977539062, 5.788094997406005859, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Highland Boar (Area: Drustvar - Difficulty: 0) CreateObject2
+(@CGUID+8, 126353, 1643, 8721, 8721, '0', 0, 0, 0, 0, -713.4288330078125, 1365.829833984375, 33.36644744873046875, 6.155664443969726562, 120, 6, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Woodland Bat (Area: Drustvar - Difficulty: 0) CreateObject2
+(@CGUID+9, 130164, 1643, 8721, 8721, '0', 0, 0, 0, 0, -814.3125, 1396.439208984375, 21.92026519775390625, 4.144854068756103515, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Highland Boar (Area: Drustvar - Difficulty: 0) CreateObject2 (possible waypoints or random movement)
+(@CGUID+10, 130164, 1643, 8721, 8721, '0', 0, 0, 0, 0, -661.53643798828125, 1377.420166015625, 29.6895599365234375, 1.814188957214355468, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Highland Boar (Area: Drustvar - Difficulty: 0) CreateObject2
+(@CGUID+11, 127526, 1643, 8721, 9264, '0', 0, 0, 0, 0, -543.94268798828125, 1295.142333984375, 0.590597331523895263, 5.888964653015136718, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Scavenging Snapclaw (Area: Mudfish Lodge - Difficulty: 0) CreateObject2
+(@CGUID+12, 130164, 1643, 8721, 8721, '0', 0, 0, 0, 0, -688.61456298828125, 1359.9757080078125, 26.94134140014648437, 0.852011263370513916, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Highland Boar (Area: Drustvar - Difficulty: 0) CreateObject2
+(@CGUID+13, 127530, 1643, 8721, 9265, '0', 0, 0, 0, 0, -801.23089599609375, 1278.8333740234375, 3.456723213195800781, 5.343322277069091796, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Snapclaw Shore - Difficulty: 0) CreateObject2 (Auras: )
+(@CGUID+14, 127530, 1643, 8721, 9265, '0', 0, 0, 0, 0, -865.4444580078125, 1309.123291015625, 0.977530658245086669, 1.445237278938293457, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+15, 127530, 1643, 8721, 9265, '0', 0, 0, 0, 0, -798.11456298828125, 1277.90625, 3.44584512710571289, 3.676903963088989257, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Snapclaw Shore - Difficulty: 0) CreateObject2 (Auras: )
+(@CGUID+16, 127530, 1643, 8721, 9265, '0', 0, 0, 0, 0, -831.17364501953125, 1286.34375, 25.02601814270019531, 1.178093314170837402, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Snapclaw Shore - Difficulty: 0) CreateObject2 (possible waypoints or random movement)
+(@CGUID+17, 127530, 1643, 8721, 9265, '0', 0, 0, 0, 0, -823.31768798828125, 1307.26220703125, 6.73795318603515625, 4.504976272583007812, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+18, 127530, 1643, 8721, 9265, '0', 0, 0, 0, 0, -865.873291015625, 1312.0989990234375, 1.204643487930297851, 4.209236621856689453, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+19, 127526, 1643, 8721, 9265, '0', 0, 0, 0, 0, -823.326416015625, 1273.15283203125, 0.991255760192871093, 5.894612789154052734, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Scavenging Snapclaw (Area: Snapclaw Shore - Difficulty: 0) CreateObject2 (Auras: )
+(@CGUID+20, 127526, 1643, 8721, 9265, '0', 0, 0, 0, 0, -792.763916015625, 1251.1805419921875, 0.193085014820098876, 3.558018445968627929, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Scavenging Snapclaw (Area: Snapclaw Shore - Difficulty: 0) CreateObject2 (Auras: )
+(@CGUID+21, 127526, 1643, 8721, 9265, '0', 0, 0, 0, 0, -817.2899169921875, 1263.8680419921875, 0.841438174247741699, 0.468191713094711303, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Scavenging Snapclaw (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+22, 127530, 1643, 8721, 9265, '0', 0, 0, 0, 0, -825.2257080078125, 1307.6475830078125, 6.4569854736328125, 3.688308238983154296, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+23, 127526, 1643, 8721, 9265, '0', 0, 0, 0, 0, -843.48614501953125, 1257.8021240234375, -2.28969049453735351, 0.323933660984039306, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Scavenging Snapclaw (Area: Snapclaw Shore - Difficulty: 0) CreateObject2 (possible waypoints or random movement)
+(@CGUID+24, 127530, 1643, 8721, 9265, '0', 0, 0, 0, 0, -842.498291015625, 1280.8385009765625, 2.984570503234863281, 4.864971160888671875, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+25, 129137, 1643, 8721, 9265, '0', 0, 0, 0, 0, -806.0086669921875, 1314.4600830078125, 10.59224128723144531, 2.755614280700683593, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Thicket Hare (Area: Snapclaw Shore - Difficulty: 0) CreateObject2 (possible waypoints or random movement)
+(@CGUID+26, 127526, 1643, 8721, 9265, '0', 0, 0, 0, 0, -812.11456298828125, 1263.23095703125, 1.208698034286499023, 3.074378728866577148, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Scavenging Snapclaw (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+27, 127526, 1643, 8721, 9265, '0', 0, 0, 0, 0, -778.89410400390625, 1238.390625, 0.238037407398223876, 0.468191713094711303, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Scavenging Snapclaw (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+28, 127526, 1643, 8721, 9265, '0', 0, 0, 0, 0, -717.07464599609375, 1218.4896240234375, 0.724489808082580566, 2.461985349655151367, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Scavenging Snapclaw (Area: Snapclaw Shore - Difficulty: 0) CreateObject2 (Auras: )
+(@CGUID+29, 127526, 1643, 8721, 9265, '0', 0, 0, 0, 0, -728.40625, 1204.8489990234375, -2.49589920043945312, 4.397478103637695312, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Scavenging Snapclaw (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+30, 127526, 1643, 8721, 9265, '0', 0, 0, 0, 0, -751.1961669921875, 1230.7083740234375, 0.991963803768157958, 4.595852375030517578, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Scavenging Snapclaw (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+31, 127530, 1643, 8721, 9265, '0', 0, 0, 0, 0, -765.15106201171875, 1258.642333984375, 1.543103575706481933, 3.676904201507568359, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+32, 127526, 1643, 8721, 9265, '0', 0, 0, 0, 0, -707.19793701171875, 1222.064208984375, 0.513160943984985351, 0.673750996589660644, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Scavenging Snapclaw (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+33, 127530, 1643, 8721, 9265, '0', 0, 0, 0, 0, -772.49481201171875, 1288.6666259765625, 9.006483078002929687, 4.864971160888671875, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+34, 127530, 1643, 8721, 9265, '0', 0, 0, 0, 0, -767.092041015625, 1258.751708984375, 1.642134904861450195, 5.366741657257080078, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+35, 127530, 1643, 8721, 9265, '0', 0, 0, 0, 0, -731.68231201171875, 1230.28125, 0.762691617012023925, 4.60064697265625, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Snapclaw Shore - Difficulty: 0) CreateObject2 (Auras: )
+(@CGUID+36, 127530, 1643, 8721, 9265, '0', 0, 0, 0, 0, -742.185791015625, 1301.93408203125, 16.07320594787597656, 5.25076913833618164, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+37, 127530, 1643, 8721, 9265, '0', 0, 0, 0, 0, -710.25518798828125, 1258.9305419921875, 6.775804519653320312, 4.023269176483154296, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+38, 127526, 1643, 8721, 9265, '0', 0, 0, 0, 0, -699.37677001953125, 1198.73095703125, -0.39634671807289123, 0.77066349983215332, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Scavenging Snapclaw (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+39, 127530, 1643, 8721, 9265, '0', 0, 0, 0, 0, -733.1649169921875, 1229.845458984375, 0.918452918529510498, 5.789493560791015625, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Snapclaw Shore - Difficulty: 0) CreateObject2 (Auras: )
+(@CGUID+40, 127530, 1643, 8721, 9265, '0', 0, 0, 0, 0, -745.7899169921875, 1301.8663330078125, 16.10391998291015625, 4.201458454132080078, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+41, 127530, 1643, 8721, 9265, '0', 0, 0, 0, 0, -790.201416015625, 1258.24658203125, 21.11149787902832031, 5.105092048645019531, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+42, 127526, 1643, 8721, 9265, '0', 0, 0, 0, 0, -705.3350830078125, 1226.2135009765625, 0.370980530977249145, 4.96037912368774414, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Scavenging Snapclaw (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+43, 127530, 1643, 8721, 9265, '0', 0, 0, 0, 0, -758.045166015625, 1258.3941650390625, 18.62761497497558593, 5.105092048645019531, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+44, 127526, 1643, 8721, 9265, '0', 0, 0, 0, 0, -756.46356201171875, 1211.392333984375, -1.23745489120483398, 0.705930829048156738, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Scavenging Snapclaw (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+45, 127530, 1643, 8721, 9265, '0', 0, 0, 0, 0, -733.0225830078125, 1240.486083984375, 19.314971923828125, 1.178093314170837402, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+46, 127530, 1643, 8721, 9265, '0', 0, 0, 0, 0, -735.28302001953125, 1263.8507080078125, 1.129084587097167968, 0.540636599063873291, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+47, 127526, 1643, 8721, 9265, '0', 0, 0, 0, 0, -777.36114501953125, 1236.8472900390625, 0.312203884124755859, 1.650610685348510742, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Scavenging Snapclaw (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+48, 127526, 1643, 8721, 9265, '0', 0, 0, 0, 0, -770.404541015625, 1223.3680419921875, -0.66497111320495605, 4.062172889709472656, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Scavenging Snapclaw (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+49, 127526, 1643, 8721, 9265, '0', 0, 0, 0, 0, -747.19964599609375, 1194.5816650390625, -1.96580922603607177, 3.429046869277954101, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Scavenging Snapclaw (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+50, 127530, 1643, 8721, 9265, '0', 0, 0, 0, 0, -773.1336669921875, 1234.203125, 16.49652481079101562, 5.105092048645019531, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Snapclaw Shore - Difficulty: 0) CreateObject2
+(@CGUID+51, 127553, 1643, 8721, 9264, '0', 0, 0, 0, 0, -613.56768798828125, 1203.935791015625, 5.272043228149414062, 1.930952668190002441, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Brinebeak (Area: Mudfish Lodge - Difficulty: 0) CreateObject2
+(@CGUID+52, 127530, 1643, 8721, 9264, '0', 0, 0, 0, 0, -640.97393798828125, 1287.3836669921875, 13.81244659423828125, 0.198666483163833618, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Mudfish Lodge - Difficulty: 0) CreateObject2
+(@CGUID+53, 127530, 1643, 8721, 9264, '0', 0, 0, 0, 0, -641.232666015625, 1260.045166015625, 15.20421695709228515, 2.093986988067626953, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Mudfish Lodge - Difficulty: 0) CreateObject2
+(@CGUID+54, 127530, 1643, 8721, 9264, '0', 0, 0, 0, 0, -634.28472900390625, 1226.0242919921875, 15.3011474609375, 2.790626287460327148, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Mudfish Lodge - Difficulty: 0) CreateObject2
+(@CGUID+55, 127530, 1643, 8721, 9264, '0', 0, 0, 0, 0, -608.295166015625, 1230.6129150390625, 5.877149581909179687, 4.21269845962524414, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Mudfish Lodge - Difficulty: 0) CreateObject2
+(@CGUID+56, 127530, 1643, 8721, 9264, '0', 0, 0, 0, 0, -668.55206298828125, 1282.4444580078125, 36.26724624633789062, 1.178093314170837402, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Mudfish Lodge - Difficulty: 0) CreateObject2
+(@CGUID+57, 127530, 1643, 8721, 9264, '0', 0, 0, 0, 0, -609.78643798828125, 1228.751708984375, 5.856270313262939453, 1.035397052764892578, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Mudfish Lodge - Difficulty: 0) CreateObject2
+(@CGUID+58, 127530, 1643, 8721, 9264, '0', 0, 0, 0, 0, -681.36981201171875, 1264.873291015625, 38.48355865478515625, 5.105092048645019531, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Mudfish Lodge - Difficulty: 0) CreateObject2
+(@CGUID+59, 127530, 1643, 8721, 9264, '0', 0, 0, 0, 0, -665.19268798828125, 1276.0242919921875, 13.8170633316040039, 4.084651947021484375, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Mudfish Lodge - Difficulty: 0) CreateObject2
+(@CGUID+60, 127530, 1643, 8721, 9264, '0', 0, 0, 0, 0, -608.763916015625, 1270.545166015625, 5.174061298370361328, 0.094555534422397613, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Mudfish Lodge - Difficulty: 0) CreateObject2
+(@CGUID+61, 127526, 1643, 8721, 9264, '0', 0, 0, 0, 0, -535.33160400390625, 1308.3802490234375, 3.500948429107666015, 1.246457338333129882, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Scavenging Snapclaw (Area: Mudfish Lodge - Difficulty: 0) CreateObject2
+(@CGUID+62, 127530, 1643, 8721, 9264, '0', 0, 0, 0, 0, -639.0225830078125, 1287.015625, 13.73761177062988281, 2.162952423095703125, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Mudfish Lodge - Difficulty: 0) CreateObject2
+(@CGUID+63, 127530, 1643, 8721, 9264, '0', 0, 0, 0, 0, -610.12152099609375, 1269.0728759765625, 5.195971488952636718, 5.416916370391845703, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Mudfish Lodge - Difficulty: 0) CreateObject2
+(@CGUID+64, 127530, 1643, 8721, 9264, '0', 0, 0, 0, 0, -651, 1267.578125, 35.390869140625, 1.178093314170837402, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Ravenous Gull (Area: Mudfish Lodge - Difficulty: 0) CreateObject2
+(@CGUID+65, 127526, 1643, 8721, 9264, '0', 0, 0, 0, 0, -559.3680419921875, 1270.6475830078125, -0.0230071023106575, 3.560774564743041992, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Scavenging Snapclaw (Area: Mudfish Lodge - Difficulty: 0) CreateObject2
+(@CGUID+66, 127526, 1643, 8721, 9264, '0', 0, 0, 0, 0, -562.9132080078125, 1290.6805419921875, 1.797439217567443847, 4.409995079040527343, 120, 4, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Scavenging Snapclaw (Area: Mudfish Lodge - Difficulty: 0) CreateObject2
+(@CGUID+67, 128772, 1643, 8721, 9265, '0', 0, 0, 0, 0, -596.44097900390625, 1273.375, 1.340177774429321289, 0, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Mudwallow Frog (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@CGUID+68, 128772, 1643, 8721, 9265, '0', 0, 0, 0, 0, -525.4288330078125, 1323.467041015625, 2.430429458618164062, 0.622211337089538574, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Mudwallow Frog (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@CGUID+69, 128772, 1643, 8721, 9265, '0', 0, 0, 0, 0, -580.90887451171875, 1266.0501708984375, -0.07698092609643936, 3.693265676498413085, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Mudwallow Frog (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@CGUID+70, 128772, 1643, 8721, 9265, '0', 0, 0, 0, 0, -601.4305419921875, 1233.939208984375, 0.668629884719848632, 5.790529251098632812, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Mudwallow Frog (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@CGUID+71, 128772, 1643, 8721, 9265, '0', 0, 0, 0, 0, -567.28472900390625, 1274.6302490234375, 0.530616521835327148, 2.29919743537902832, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Mudwallow Frog (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@CGUID+72, 128772, 1643, 8721, 9265, '0', 0, 0, 0, 0, -547.18096923828125, 1285.9139404296875, 0.241623058915138244, 4.846943378448486328, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Mudwallow Frog (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@CGUID+73, 128772, 1643, 8721, 9265, '0', 0, 0, 0, 0, -527.44964599609375, 1325.4617919921875, 2.19077301025390625, 0.922905147075653076, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Mudwallow Frog (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@CGUID+74, 127558, 1643, 8721, 9265, '0', 0, 0, 0, 1, -663.7117919921875, 1184.357666015625, 5.708058834075927734, 4.752450942993164062, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Art Hughie (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@CGUID+75, 128772, 1643, 8721, 9264, '0', 0, 0, 0, 0, -707.96875, 1206.607666015625, 0.564762592315673828, 4.597264289855957031, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Mudwallow Frog (Area: Mudfish Lodge - Difficulty: 0) CreateObject1
+(@CGUID+76, 128772, 1643, 8721, 9264, '0', 0, 0, 0, 0, -709.04168701171875, 1207.826416015625, 0.593884408473968505, 3.499276638031005859, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Mudwallow Frog (Area: Mudfish Lodge - Difficulty: 0) CreateObject1
+(@CGUID+77, 127548, 1643, 8721, 9264, '0', 0, 0, 0, 0, -712.51910400390625, 1216.07470703125, 0.614556431770324707, 4.933927059173583984, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Fishing Rod (Area: Mudfish Lodge - Difficulty: 0) CreateObject1 (Auras: 253105 - Fishing Rod)
+(@CGUID+78, 128772, 1643, 8721, 9264, '0', 0, 0, 0, 0, -726.60693359375, 1234.07275390625, 0.231143072247505187, 1.206368923187255859, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Mudwallow Frog (Area: Mudfish Lodge - Difficulty: 0) CreateObject1
+(@CGUID+79, 128772, 1643, 8721, 9264, '0', 0, 0, 0, 0, -729.35821533203125, 1255.5938720703125, -0.20717242360115051, 4.093502044677734375, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Mudwallow Frog (Area: Mudfish Lodge - Difficulty: 0) CreateObject1
+(@CGUID+80, 128772, 1643, 8721, 9264, '0', 0, 0, 0, 0, -744.67706298828125, 1245.376708984375, 2.204370021820068359, 4.597264289855957031, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Mudwallow Frog (Area: Mudfish Lodge - Difficulty: 0) CreateObject1
+(@CGUID+81, 128772, 1643, 8721, 9264, '0', 0, 0, 0, 0, -741.51080322265625, 1241.96875, -0.11475798487663269, 6.244170188903808593, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Mudwallow Frog (Area: Mudfish Lodge - Difficulty: 0) CreateObject1
+(@CGUID+82, 128772, 1643, 8721, 9264, '0', 0, 0, 0, 0, -746.810791015625, 1247.3004150390625, 1.885159254074096679, 2.740456581115722656, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Mudwallow Frog (Area: Mudfish Lodge - Difficulty: 0) CreateObject1
+(@CGUID+83, 127548, 1643, 8721, 9264, '0', 0, 0, 0, 0, -755.90625, 1225.6163330078125, 0.551871001720428466, 5.006527423858642578, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Fishing Rod (Area: Mudfish Lodge - Difficulty: 0) CreateObject1 (Auras: 253105 - Fishing Rod)
+(@CGUID+84, 128772, 1643, 8721, 9264, '0', 0, 0, 0, 0, -762.267578125, 1232.8397216796875, 1.08823704719543457, 3.851911544799804687, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Mudwallow Frog (Area: Mudfish Lodge - Difficulty: 0) CreateObject1
+(@CGUID+85, 128772, 1643, 8721, 9264, '0', 0, 0, 0, 0, -766.9288330078125, 1248.69970703125, 0.738383471965789794, 6.117122173309326171, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Mudwallow Frog (Area: Mudfish Lodge - Difficulty: 0) CreateObject1
+(@CGUID+86, 127548, 1643, 8721, 9264, '0', 0, 0, 0, 0, -779.951416015625, 1240.3663330078125, 0.246002435684204101, 3.358357429504394531, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Fishing Rod (Area: Mudfish Lodge - Difficulty: 0) CreateObject1 (Auras: 253105 - Fishing Rod)
+(@CGUID+87, 128772, 1643, 8721, 9264, '0', 0, 0, 0, 0, -792.83331298828125, 1264.3211669921875, 3.525282621383666992, 2.819799661636352539, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Mudwallow Frog (Area: Mudfish Lodge - Difficulty: 0) CreateObject1
+(@CGUID+88, 127548, 1643, 8721, 9265, '0', 0, 0, 0, 0, -806.7742919921875, 1259.3629150390625, 0.766896009445190429, 4.030555248260498046, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Fishing Rod (Area: Snapclaw Shore - Difficulty: 0) CreateObject1 (Auras: 253105 - Fishing Rod)
+(@CGUID+89, 128772, 1643, 8721, 9265, '0', 0, 0, 0, 0, -831.4132080078125, 1270.1754150390625, 0.976042509078979492, 2.248590946197509765, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Mudwallow Frog (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@CGUID+90, 127548, 1643, 8721, 9265, '0', 0, 0, 0, 0, -841.80902099609375, 1281.23095703125, 0.384869009256362915, 3.765257596969604492, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967), -- Fishing Rod (Area: Snapclaw Shore - Difficulty: 0) CreateObject1 (Auras: 253105 - Fishing Rod)
+(@CGUID+91, 128772, 1643, 8721, 9265, '0', 0, 0, 0, 0, -855.87677001953125, 1295.1458740234375, 0.731626868247985839, 4.76127481460571289, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Mudwallow Frog (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@CGUID+92, 128772, 1643, 8721, 9265, '0', 0, 0, 0, 0, -850.1949462890625, 1297.061279296875, 0.535593867301940917, 5.013759613037109375, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Mudwallow Frog (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@CGUID+93, 128772, 1643, 8721, 9265, '0', 0, 0, 0, 0, -858.333984375, 1294.55322265625, -0.24207666516304016, 4.712388992309570312, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 61967), -- Mudwallow Frog (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@CGUID+94, 127548, 1643, 8721, 9265, '0', 0, 0, 0, 0, -871.0242919921875, 1310.0242919921875, 0.404536634683609008, 3.325029850006103515, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 61967); -- Fishing Rod (Area: Snapclaw Shore - Difficulty: 0) CreateObject1 (Auras: 253105 - Fishing Rod)
+DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+94;
+INSERT INTO `creature_addon` (`guid`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(@CGUID+13, 0, 0, 0, 0, 0, 1, 0, 428, 0, 0, 0, 0, ''), -- Ravenous Gull
+(@CGUID+14, 0, 0, 0, 0, 0, 1, 0, 428, 0, 0, 0, 0, ''), -- Ravenous Gull
+(@CGUID+15, 0, 0, 0, 0, 0, 1, 0, 428, 0, 0, 0, 0, ''), -- Ravenous Gull
+(@CGUID+17, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Ravenous Gull
+(@CGUID+18, 0, 0, 0, 0, 0, 1, 0, 428, 0, 0, 0, 0, ''), -- Ravenous Gull
+(@CGUID+22, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Ravenous Gull
+(@CGUID+24, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Ravenous Gull
+(@CGUID+31, 0, 0, 0, 0, 0, 1, 0, 428, 0, 0, 0, 0, ''), -- Ravenous Gull
+(@CGUID+33, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Ravenous Gull
+(@CGUID+34, 0, 0, 0, 0, 0, 1, 0, 428, 0, 0, 0, 0, ''), -- Ravenous Gull
+(@CGUID+36, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Ravenous Gull
+(@CGUID+37, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Ravenous Gull
+(@CGUID+40, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Ravenous Gull
+(@CGUID+46, 0, 0, 0, 0, 0, 1, 0, 428, 0, 0, 0, 0, ''), -- Ravenous Gull
+(@CGUID+51, 0, 0, 0, 0, 0, 1, 0, 428, 0, 0, 0, 0, ''), -- Brinebeak
+(@CGUID+52, 0, 0, 0, 0, 0, 1, 0, 428, 0, 0, 0, 0, ''), -- Ravenous Gull
+(@CGUID+53, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Ravenous Gull
+(@CGUID+54, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Ravenous Gull
+(@CGUID+55, 0, 0, 0, 0, 0, 1, 0, 428, 0, 0, 0, 0, ''), -- Ravenous Gull
+(@CGUID+57, 0, 0, 0, 0, 0, 1, 0, 428, 0, 0, 0, 0, ''), -- Ravenous Gull
+(@CGUID+59, 0, 0, 0, 0, 0, 1, 0, 428, 0, 0, 0, 0, ''), -- Ravenous Gull
+(@CGUID+60, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Ravenous Gull
+(@CGUID+62, 0, 0, 0, 0, 0, 1, 0, 428, 0, 0, 0, 0, ''), -- Ravenous Gull
+(@CGUID+63, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''); -- Ravenous Gull
+
+-- GameObject
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+46;
+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, 276471, 1643, 8721, 9265, '0', 0, 0, -647.4444580078125, 1285.21875, 13.71358776092529296, 0.834376394748687744, 0, 0, 0.405191421508789062, 0.914231836795806884, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+1, 276471, 1643, 8721, 9265, '0', 0, 0, -613.72393798828125, 1204.7100830078125, 2.035724401473999023, 0, 0, 0, 0, 1, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+2, 276471, 1643, 8721, 9265, '0', 0, 0, -665.06597900390625, 1187.045166015625, 5.624722003936767578, 2.557938337326049804, 0, 0, 0.957719802856445312, 0.287702620029449462, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+3, 276471, 1643, 8721, 9265, '0', 0, 0, -661.7100830078125, 1184.1822509765625, 5.62472391128540039, 6.230826377868652343, 0, 0, -0.02617645263671875, 0.999657332897186279, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+4, 276471, 1643, 8721, 9265, '0', 0, 0, -648.185791015625, 1286.9722900390625, 13.67893314361572265, 2.739741086959838867, 0, 0, 0.979882240295410156, 0.199576556682586669, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+5, 276471, 1643, 8721, 9265, '0', 0, 0, -614.7725830078125, 1205.5242919921875, 2.184391260147094726, 3.364484071731567382, 0, 0, -0.99379634857177734, 0.111215099692344665, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+6, 296698, 1643, 8721, 9265, '0', 0, 0, -664.69268798828125, 1184.8836669921875, 5.5749359130859375, 5.654868602752685546, 0, 0, -0.30901622772216796, 0.95105677843093872, 120, 255, 1, 61967), -- Chair (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+7, 276471, 1643, 8721, 9265, '0', 0, 0, -666.04339599609375, 1275.0069580078125, 13.73371601104736328, 4.52684640884399414, 0, 0, -0.76957130432128906, 0.638560891151428222, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+8, 276471, 1643, 8721, 9265, '0', 0, 0, -676.2413330078125, 1247.3228759765625, 14, 3.481034517288208007, 0, 0, -0.98563194274902343, 0.168907210230827331, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+9, 276502, 1643, 8721, 9265, '0', 0, 0, -665.52081298828125, 1184.0191650390625, 5.624720573425292968, 6.230826377868652343, 0, 0, -0.02617645263671875, 0.999657332897186279, 120, 255, 1, 61967), -- Mudfish Innards (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+10, 276471, 1643, 8721, 9265, '0', 0, 0, -640.00347900390625, 1287.4288330078125, 13.70024013519287109, 5.97910165786743164, 0, 0, -0.15145683288574218, 0.988463878631591796, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+11, 276513, 1643, 8721, 9265, '0', 0, 0, -676.30902099609375, 1245.0972900390625, 13.96423053741455078, 0, 0, 0, 0, 1, 120, 255, 1, 61967), -- Intact Mudfish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+12, 276471, 1643, 8721, 9265, '0', 0, 0, -674.60589599609375, 1246.8697509765625, 13.97380447387695312, 1.326288461685180664, 0, 0, 0.615597724914550781, 0.788060545921325683, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+13, 276471, 1643, 8721, 9265, '0', 0, 0, -676.24652099609375, 1242.717041015625, 13.94618034362792968, 4.52684640884399414, 0, 0, -0.76957130432128906, 0.638560891151428222, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+14, 276471, 1643, 8721, 9265, '0', 0, 0, -649.734375, 1270.0867919921875, 13.50401115417480468, 4.52684640884399414, 0, 0, -0.76957130432128906, 0.638560891151428222, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+15, 276471, 1643, 8721, 9265, '0', 0, 0, -608.80902099609375, 1229.7396240234375, 5.764249324798583984, 0, 0, 0, 0, 1, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+16, 276471, 1643, 8721, 9265, '0', 0, 0, -666.61114501953125, 1184.15625, 5.690206050872802734, 3.500449895858764648, 0, 0, -0.98394584655761718, 0.17846730351448059, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+17, 276502, 1643, 8721, 9265, '0', 0, 0, -665.6007080078125, 1183.0885009765625, 5.690206050872802734, 3.860703945159912109, 0, 0, -0.93605327606201171, 0.351858317852020263, 120, 255, 1, 61967), -- Mudfish Innards (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+18, 276502, 1643, 8721, 9265, '0', 0, 0, -661.71356201171875, 1182.94970703125, 5.69020700454711914, 2.189471960067749023, 0, 0, 0.888807296752929687, 0.458281159400939941, 120, 255, 1, 61967), -- Mudfish Innards (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+19, 276471, 1643, 8721, 9265, '0', 0, 0, -613.46527099609375, 1205.685791015625, 2.045465707778930664, 5.267747879028320312, 0, 0, -0.48618507385253906, 0.873855888843536376, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+20, 276471, 1643, 8721, 9265, '0', 0, 0, -735.6961669921875, 1246.454833984375, 0.270667135715484619, 0, 0, 0, 0, 1, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+21, 276471, 1643, 8721, 9265, '0', 0, 0, -733.34722900390625, 1221.4114990234375, 0.422193288803100585, 4.52684640884399414, 0, 0, -0.76957130432128906, 0.638560891151428222, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+22, 276471, 1643, 8721, 9265, '0', 0, 0, -704.138916015625, 1224.670166015625, 0.382522225379943847, 0, 0, 0, 0, 1, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+23, 276471, 1643, 8721, 9265, '0', 0, 0, -704.78472900390625, 1223.2535400390625, 0.47671017050743103, 1.186894655227661132, 0, 0, 0.559222221374511718, 0.829017817974090576, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+24, 276471, 1643, 8721, 9265, '0', 0, 0, -731.72918701171875, 1229.4635009765625, 0.760358929634094238, 0, 0, 0, 0, 1, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+25, 276486, 1643, 8721, 9265, '0', 0, 0, -712.23785400390625, 1215.171875, 0.418239057064056396, 3.332872867584228515, 0, 0, -0.99542999267578125, 0.095494255423545837, 120, 255, 1, 61967), -- Rod Holder (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+26, 276471, 1643, 8721, 9265, '0', 0, 0, -734.43927001953125, 1264.6632080078125, 1.301799535751342773, 0, 0, 0, 0, 1, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+27, 276486, 1643, 8721, 9265, '0', 0, 0, -739.140625, 1221.77783203125, 0.165550202131271362, 2.750118732452392578, 0, 0, 0.980904579162597656, 0.194489538669586181, 120, 255, 1, 61967), -- Rod Holder (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+28, 276471, 1643, 8721, 9265, '0', 0, 0, -750.53125, 1257.0052490234375, 0.991849184036254882, 0, 0, 0, 0, 1, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+29, 276486, 1643, 8721, 9265, '0', 0, 0, -755.54168701171875, 1224.75, 0.208154156804084777, 3.412051200866699218, 0, 0, -0.99087047576904296, 0.134817361831665039, 120, 255, 1, 61967), -- Rod Holder (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+30, 276471, 1643, 8721, 9265, '0', 0, 0, -751.01214599609375, 1228.8507080078125, 1.029752373695373535, 0, 0, 0, 0, 1, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+31, 276471, 1643, 8721, 9265, '0', 0, 0, -752.95660400390625, 1253.6666259765625, 0.984304964542388916, 0, 0, 0, 0, 1, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+32, 276471, 1643, 8721, 9265, '0', 0, 0, -766.31597900390625, 1258.1771240234375, 1.492533087730407714, 0, 0, 0, 0, 1, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+33, 276486, 1643, 8721, 9264, '0', 0, 0, -780.935791015625, 1240.0660400390625, 0.002035160781815648, 1.759358525276184082, 0, 0, 0.770534515380859375, 0.637398302555084228, 120, 255, 1, 61967), -- Rod Holder (Area: Mudfish Lodge - Difficulty: 0) CreateObject1
+(@OGUID+34, 276471, 1643, 8721, 9264, '0', 0, 0, -778.09722900390625, 1248.9774169921875, 0.558413386344909667, 0, 0, 0, 0, 1, 120, 255, 1, 61967), -- Rotting Fish (Area: Mudfish Lodge - Difficulty: 0) CreateObject1
+(@OGUID+35, 276471, 1643, 8721, 9264, '0', 0, 0, -783.326416015625, 1259.5242919921875, 1.439633727073669433, 0, 0, 0, 0, 1, 120, 255, 1, 61967), -- Rotting Fish (Area: Mudfish Lodge - Difficulty: 0) CreateObject1
+(@OGUID+36, 276486, 1643, 8721, 9264, '0', 0, 0, -807.39239501953125, 1258.46533203125, 0.619764626026153564, 2.168961524963378906, 0, 0, 0.884060859680175781, 0.467371821403503417, 120, 255, 1, 61967), -- Rod Holder (Area: Mudfish Lodge - Difficulty: 0) CreateObject1
+(@OGUID+37, 276471, 1643, 8721, 9264, '0', 0, 0, -814.11114501953125, 1263.123291015625, 0.938786625862121582, 0, 0, 0, 0, 1, 120, 255, 1, 61967), -- Rotting Fish (Area: Mudfish Lodge - Difficulty: 0) CreateObject1
+(@OGUID+38, 276471, 1643, 8721, 9264, '0', 0, 0, -776.96527099609375, 1238.4427490234375, 0.379305660724639892, 0, 0, 0, 0, 1, 120, 255, 1, 61967), -- Rotting Fish (Area: Mudfish Lodge - Difficulty: 0) CreateObject1
+(@OGUID+39, 276471, 1643, 8721, 9264, '0', 0, 0, -799.75518798828125, 1277.3038330078125, 3.123456001281738281, 0, 0, 0, 0, 1, 120, 255, 1, 61967), -- Rotting Fish (Area: Mudfish Lodge - Difficulty: 0) CreateObject1
+(@OGUID+40, 276471, 1643, 8721, 9264, '0', 0, 0, -794.2586669921875, 1261.6129150390625, 1.769251108169555664, 0, 0, 0, 0, 1, 120, 255, 1, 61967), -- Rotting Fish (Area: Mudfish Lodge - Difficulty: 0) CreateObject1
+(@OGUID+41, 276471, 1643, 8721, 9264, '0', 0, 0, -814.63018798828125, 1264.7535400390625, 1.218963027000427246, 1.411776900291442871, 0, 0, 0.648710250854492187, 0.761035501956939697, 120, 255, 1, 61967), -- Rotting Fish (Area: Mudfish Lodge - Difficulty: 0) CreateObject1
+(@OGUID+42, 276486, 1643, 8721, 9264, '0', 0, 0, -842.45660400390625, 1280.6649169921875, 0.094687938690185546, 2.266081809997558593, 0, 0, 0.905705451965332031, 0.423907577991485595, 120, 255, 1, 61967), -- Rod Holder (Area: Mudfish Lodge - Difficulty: 0) CreateObject1
+(@OGUID+43, 276471, 1643, 8721, 9265, '0', 0, 0, -865.29168701171875, 1310.267333984375, 1.024560928344726562, 0.732372224330902099, 0, 0, 0.358057022094726562, 0.933699727058410644, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+44, 276471, 1643, 8721, 9265, '0', 0, 0, -866.44097900390625, 1311.1822509765625, 0.968453288078308105, 5.831486701965332031, 0, 0, -0.22393417358398437, 0.974604249000549316, 120, 255, 1, 61967), -- Rotting Fish (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+45, 276486, 1643, 8721, 9265, '0', 0, 0, -871.9149169921875, 1309.8021240234375, 0.126857176423072814, 1.714108943939208984, 0, 0, 0.755917549133300781, 0.654666841030120849, 120, 255, 1, 61967), -- Rod Holder (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+(@OGUID+46, 276515, 1643, 8721, 9265, '0', 0, 0, -738.4774169921875, 1222.467041015625, 0.353597909212112426, 5.213128089904785156, -0.70429039001464843, 0.467242240905761718, 0.42122650146484375, 0.328980207443237304, 120, 255, 1, 61967); -- Fishing Rod (Area: Snapclaw Shore - Difficulty: 0) CreateObject1
+
+-- Template Addon
+DELETE FROM `creature_template_addon` WHERE `entry` IN (127548 /*127548 (Fishing Rod) - Fishing Rod*/, 127558 /*127558 (Art Hughie)*/);
+INSERT INTO `creature_template_addon` (`entry`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(127548, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '253105'), -- 127548 (Fishing Rod) - Fishing Rod
+(127558, 0, 0, 0, 0, 0, 1, 0, 0, 8037, 0, 0, 3, ''); -- 127558 (Art Hughie)
+
+-- Template
+UPDATE `gameobject_template` SET `ContentTuningId`=187, `VerifiedBuild`=61967 WHERE `entry`=276513; -- Intact Mudfish
+UPDATE `gameobject_template` SET `ContentTuningId`=464, `VerifiedBuild`=61967 WHERE `entry`=293972; -- Azerite Chunk
+UPDATE `gameobject_template` SET `ContentTuningId`=187, `VerifiedBuild`=61967 WHERE `entry`=276515; -- Fishing Rod
+UPDATE `gameobject_template` SET `ContentTuningId`=464, `VerifiedBuild`=61967 WHERE `entry`=290754; -- Egg Sac
+UPDATE `gameobject_template` SET `ContentTuningId`=187, `VerifiedBuild`=61967 WHERE `entry`=272792; -- Egg Sac
+
+-- Difficulty
+UPDATE `creature_template_difficulty` SET `VerifiedBuild`=61967 WHERE (`DifficultyID`=0 AND `Entry` IN (126824,126151,144215,127558,69018,126677,126434,129137,128798,125130,126353,125132,130165,130164));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x20000000, `VerifiedBuild`=61967 WHERE (`Entry`=126953 AND `DifficultyID`=0); -- 126953 (Tiragarde Hawk) - Floating
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10000000, `VerifiedBuild`=61967 WHERE (`Entry`=130083 AND `DifficultyID`=0); -- 130083 (Curseformed Ravager) - CanSwim
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x30000000, `VerifiedBuild`=61967 WHERE (`Entry`=128937 AND `DifficultyID`=0); -- 128937 (Scavenging Raven) - CanSwim, Floating
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10000000, `VerifiedBuild`=61967 WHERE (`Entry`=132166 AND `DifficultyID`=0); -- 132166 (Ian Glassel) - CanSwim
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10000000, `VerifiedBuild`=61967 WHERE (`Entry`=128942 AND `DifficultyID`=0); -- 128942 (Mudfisher Crab) - CanSwim
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10000000, `VerifiedBuild`=61967 WHERE (`Entry`=127526 AND `DifficultyID`=0); -- 127526 (Scavenging Snapclaw) - CanSwim
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10000000, `VerifiedBuild`=61967 WHERE (`Entry`=127553 AND `DifficultyID`=0); -- 127553 (Brinebeak) - CanSwim
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x30000100, `VerifiedBuild`=61967 WHERE (`Entry`=127548 AND `DifficultyID`=0); -- 127548 (Fishing Rod) - Sessile, CanSwim, Floating
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x20000100, `VerifiedBuild`=61967 WHERE (`Entry`=115913 AND `DifficultyID`=0); -- 115913 (Target) - Sessile, Floating
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10000000, `VerifiedBuild`=61967 WHERE (`Entry`=127530 AND `DifficultyID`=0); -- 127530 (Ravenous Gull) - CanSwim
+
+DELETE FROM `creature_static_flags_override` WHERE `SpawnId` IN (@CGUID+16,@CGUID+41,@CGUID+50,@CGUID+45,@CGUID+43,@CGUID+58,@CGUID+56,@CGUID+64);
+INSERT INTO `creature_static_flags_override` (`SpawnId`, `DifficultyId`, `StaticFlags1`, `StaticFlags2`, `StaticFlags3`, `StaticFlags4`, `StaticFlags5`, `StaticFlags6`, `StaticFlags7`, `StaticFlags8`) VALUES
+(@CGUID+16, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(@CGUID+41, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(@CGUID+50, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(@CGUID+45, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(@CGUID+43, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(@CGUID+58, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(@CGUID+56, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(@CGUID+64, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+
+-- Quest
+DELETE FROM `quest_greeting` WHERE (`ID`=127558 AND `Type`=0);
+INSERT INTO `quest_greeting` (`ID`, `Type`, `GreetEmoteType`, `GreetEmoteDelay`, `Greeting`, `VerifiedBuild`) VALUES
+(127558, 0, 0, 0, 'Do you like to fish? ...I love to fish... love to catch...\n\nI only keep the best... livers... stomachs... hearts... only the best...', 61967); -- 127558
+
+DELETE FROM `quest_details` WHERE `ID` IN (48881 /*The Reel Deal*/, 48882 /*I Like Fish Guts and I Cannot Lie*/, 48904 /*Take the Bait*/, 48880 /*Mean Gulls*/);
+INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES
+(48881, 0, 0, 0, 0, 0, 0, 0, 0, 61967), -- The Reel Deal
+(48882, 0, 0, 0, 0, 0, 0, 0, 0, 61967), -- I Like Fish Guts and I Cannot Lie
+(48904, 0, 0, 0, 0, 0, 0, 0, 0, 61967), -- Take the Bait
+(48880, 0, 0, 0, 0, 0, 0, 0, 0, 61967); -- Mean Gulls
+
+DELETE FROM `creature_queststarter` WHERE (`id`=127558 AND `quest` IN (48904,48880));
+INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(127558, 48904, 61967), -- Take the Bait offered by Art Hughie
+(127558, 48880, 61967); -- Mean Gulls offered by Art Hughie
+
+DELETE FROM `creature_questender` WHERE (`id`=127558 AND `quest` IN (48880,48904));
+INSERT INTO `creature_questender` (`id`, `quest`, `VerifiedBuild`) VALUES
+(127558, 48880, 61967), -- Mean Gulls ended by Art Hughie
+(127558, 48904, 61967); -- Take the Bait ended by Art Hughie
+
+DELETE FROM `gameobject_queststarter` WHERE (`id`=276515 AND `quest`=48881) OR (`id`=276513 AND `quest`=48882);
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(276515, 48881, 61967), -- The Reel Deal offered by Fishing Rod
+(276513, 48882, 61967); -- I Like Fish Guts and I Cannot Lie offered by Intact Mudfish
+
+DELETE FROM `ui_map_quest_line` WHERE (`UIMapId`=896 AND `QuestLineId`=5673);
+INSERT INTO `ui_map_quest_line` (`UIMapId`, `QuestLineId`, `VerifiedBuild`) VALUES
+(896, 5673, 61967);
+
+-- Path for Ravenous Gull
+SET @MOVERGUID := @CGUID+16;
+SET @ENTRY := 127530;
+SET @PATHOFFSET := 0;
+SET @PATH := @ENTRY * 100 + @PATHOFFSET;
+DELETE FROM `waypoint_path` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES
+(@PATH, 0, 0x2, 2.8683, 'Ravenous Gull - Cyclic Path');
+
+DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES
+(@PATH, 0, -828.2447, 1293.4148, 25.026018, NULL, 0),
+(@PATH, 1, -821.17365, 1296.3438, 25.026018, NULL, 0),
+(@PATH, 2, -814.1026, 1293.4148, 25.026018, NULL, 0),
+(@PATH, 3, -811.17365, 1286.3438, 25.026018, NULL, 0),
+(@PATH, 4, -814.1026, 1279.2727, 25.026018, NULL, 0),
+(@PATH, 5, -821.17365, 1276.3438, 25.026018, NULL, 0),
+(@PATH, 6, -828.2447, 1279.2727, 25.026018, NULL, 0),
+(@PATH, 7, -831.17365, 1286.3438, 25.026018, NULL, 0),
+(@PATH, 8, -828.2447, 1293.4148, 25.026018, NULL, 0);
+
+UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID;
+DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID;
+INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES
+(@MOVERGUID, @PATH, 1);
+
+-- Path for Ravenous Gull
+SET @MOVERGUID := @CGUID+41;
+SET @ENTRY := 127530;
+SET @PATHOFFSET := 1;
+SET @PATH := @ENTRY * 100 + @PATHOFFSET;
+DELETE FROM `waypoint_path` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES
+(@PATH, 0, 0x2, 2.8682, 'Ravenous Gull - Cyclic Path');
+
+DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES
+(@PATH, 0, -787.27246, 1251.1755, 21.111498, NULL, 0),
+(@PATH, 1, -780.2014, 1248.2466, 21.111498, NULL, 0),
+(@PATH, 2, -773.1304, 1251.1755, 21.111498, NULL, 0),
+(@PATH, 3, -770.2014, 1258.2466, 21.111498, NULL, 0),
+(@PATH, 4, -773.1304, 1265.3176, 21.111498, NULL, 0),
+(@PATH, 5, -780.2014, 1268.2466, 21.111498, NULL, 0),
+(@PATH, 6, -787.27246, 1265.3176, 21.111498, NULL, 0),
+(@PATH, 7, -790.2014, 1258.2466, 21.111498, NULL, 0);
+
+UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID;
+DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID;
+INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES
+(@MOVERGUID, @PATH, 1);
+
+-- Path for Ravenous Gull
+SET @MOVERGUID := @CGUID+43;
+SET @ENTRY := 127530;
+SET @PATHOFFSET := 2;
+SET @PATH := @ENTRY * 100 + @PATHOFFSET;
+DELETE FROM `waypoint_path` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES
+(@PATH, 0, 0x2, 2.8683, 'Ravenous Gull - Cyclic Path');
+
+DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES
+(@PATH, 0, -755.1162, 1251.3231, 18.627615, NULL, 0),
+(@PATH, 1, -748.04517, 1248.3942, 18.627615, NULL, 0),
+(@PATH, 2, -740.9741, 1251.3231, 18.627615, NULL, 0),
+(@PATH, 3, -738.04517, 1258.3942, 18.627615, NULL, 0),
+(@PATH, 4, -740.9741, 1265.4652, 18.627615, NULL, 0),
+(@PATH, 5, -748.04517, 1268.3942, 18.627615, NULL, 0),
+(@PATH, 6, -755.1162, 1265.4652, 18.627615, NULL, 0),
+(@PATH, 7, -758.04517, 1258.3942, 18.627615, NULL, 0);
+
+UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID;
+DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID;
+INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES
+(@MOVERGUID, @PATH, 1);
+
+-- Path for Ravenous Gull
+SET @MOVERGUID := @CGUID+45;
+SET @ENTRY := 127530;
+SET @PATHOFFSET := 3;
+SET @PATH := @ENTRY * 100 + @PATHOFFSET;
+DELETE FROM `waypoint_path` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES
+(@PATH, 0, 0x2, 2.8683, 'Ravenous Gull - Cyclic Path');
+
+DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES
+(@PATH, 0, -730.0936, 1247.5571, 19.314972, NULL, 0),
+(@PATH, 1, -723.0226, 1250.4861, 19.314972, NULL, 0),
+(@PATH, 2, -715.95154, 1247.5571, 19.314972, NULL, 0),
+(@PATH, 3, -713.0226, 1240.4861, 19.314972, NULL, 0),
+(@PATH, 4, -715.95154, 1233.415, 19.314972, NULL, 0),
+(@PATH, 5, -723.0226, 1230.4861, 19.314972, NULL, 0),
+(@PATH, 6, -730.0936, 1233.415, 19.314972, NULL, 0),
+(@PATH, 7, -733.0226, 1240.4861, 19.314972, NULL, 0);
+
+UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID;
+DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID;
+INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES
+(@MOVERGUID, @PATH, 1);
+
+-- Path for Ravenous Gull
+SET @MOVERGUID := @CGUID+50;
+SET @ENTRY := 127530;
+SET @PATHOFFSET := 4;
+SET @PATH := @ENTRY * 100 + @PATHOFFSET;
+DELETE FROM `waypoint_path` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES
+(@PATH, 0, 0x2, 2.8683, 'Ravenous Gull - Cyclic Path');
+
+DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES
+(@PATH, 0, -770.2047, 1227.1321, 16.496525, NULL, 0),
+(@PATH, 1, -763.13367, 1224.2031, 16.496525, NULL, 0),
+(@PATH, 2, -756.0626, 1227.1321, 16.496525, NULL, 0),
+(@PATH, 3, -753.13367, 1234.2031, 16.496525, NULL, 0),
+(@PATH, 4, -756.0626, 1241.2742, 16.496525, NULL, 0),
+(@PATH, 5, -763.13367, 1244.2031, 16.496525, NULL, 0),
+(@PATH, 6, -770.2047, 1241.2742, 16.496525, NULL, 0),
+(@PATH, 7, -773.13367, 1234.2031, 16.496525, NULL, 0);
+
+UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID;
+DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID;
+INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES
+(@MOVERGUID, @PATH, 1);
+
+-- Path for Ravenous Gull
+SET @MOVERGUID := @CGUID+56;
+SET @ENTRY := 127530;
+SET @PATHOFFSET := 5;
+SET @PATH := @ENTRY * 100 + @PATHOFFSET;
+DELETE FROM `waypoint_path` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES
+(@PATH, 0, 0x2, 2.8683, 'Ravenous Gull - Cyclic Path');
+
+DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES
+(@PATH, 0, -665.6231, 1289.5155, 36.267246, NULL, 0),
+(@PATH, 1, -658.55206, 1292.4445, 36.267246, NULL, 0),
+(@PATH, 2, -651.481, 1289.5155, 36.267246, NULL, 0),
+(@PATH, 3, -648.55206, 1282.4445, 36.267246, NULL, 0),
+(@PATH, 4, -651.481, 1275.3734, 36.267246, NULL, 0),
+(@PATH, 5, -658.55206, 1272.4445, 36.267246, NULL, 0),
+(@PATH, 6, -665.6231, 1275.3734, 36.267246, NULL, 0),
+(@PATH, 7, -668.55206, 1282.4445, 36.267246, NULL, 0);
+
+UPDATE `creature` SET `orientation`=0, `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID;
+DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID;
+INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES
+(@MOVERGUID, @PATH, 1);
+
+-- Path for Ravenous Gull
+SET @MOVERGUID := @CGUID+58;
+SET @ENTRY := 127530;
+SET @PATHOFFSET := 6;
+SET @PATH := @ENTRY * 100 + @PATHOFFSET;
+DELETE FROM `waypoint_path` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES
+(@PATH, 0, 0x2, 2.8682, 'Ravenous Gull - Cyclic Path');
+
+DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES
+(@PATH, 0, -678.44086, 1257.8022, 38.48356, NULL, 0),
+(@PATH, 1, -671.3698, 1254.8733, 38.48356, NULL, 0),
+(@PATH, 2, -664.29877, 1257.8022, 38.48356, NULL, 0),
+(@PATH, 3, -661.3698, 1264.8733, 38.48356, NULL, 0),
+(@PATH, 4, -664.29877, 1271.9443, 38.48356, NULL, 0),
+(@PATH, 5, -671.3698, 1274.8733, 38.48356, NULL, 0),
+(@PATH, 6, -678.44086, 1271.9443, 38.48356, NULL, 0),
+(@PATH, 7, -681.3698, 1264.8733, 38.48356, NULL, 0);
+
+UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID;
+DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID;
+INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES
+(@MOVERGUID, @PATH, 1);
+
+-- Path for Ravenous Gull
+SET @MOVERGUID := @CGUID+64;
+SET @ENTRY := 127530;
+SET @PATHOFFSET := 7;
+SET @PATH := @ENTRY * 100 + @PATHOFFSET;
+DELETE FROM `waypoint_path` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES
+(@PATH, 0, 0x2, 2.8682, 'Ravenous Gull - Cyclic Path');
+
+DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES
+(@PATH, 0, -648.07104, 1274.6492, 35.39087, NULL, 0),
+(@PATH, 1, -641, 1277.5781, 35.39087, NULL, 0),
+(@PATH, 2, -633.92896, 1274.6492, 35.39087, NULL, 0),
+(@PATH, 3, -631, 1267.5781, 35.39087, NULL, 0),
+(@PATH, 4, -633.92896, 1260.5071, 35.39087, NULL, 0),
+(@PATH, 5, -641, 1257.5781, 35.39087, NULL, 0),
+(@PATH, 6, -648.07104, 1260.5071, 35.39087, NULL, 0),
+(@PATH, 7, -651, 1267.5781, 35.39087, NULL, 0);
+
+UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID;
+DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID;
+INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES
+(@MOVERGUID, @PATH, 1);