diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/master/2023_11_12_00_world.sql | 103 |
1 files changed, 103 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_11_12_00_world.sql b/sql/updates/world/master/2023_11_12_00_world.sql new file mode 100644 index 00000000000..35f4b65c079 --- /dev/null +++ b/sql/updates/world/master/2023_11_12_00_world.sql @@ -0,0 +1,103 @@ +SET @CGUID := 6000786; + +-- Creature +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+81; +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`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES +(@CGUID+0, 101288, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1287.1475830078125, 2122.232666015625, 92.58498382568359375, 6.142977714538574218, 120, 4, 0, 3106, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+1, 101748, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1404.8472900390625, 2152.007080078125, 96.1861114501953125, 0.122197546064853668, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Fel Geyser (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+2, 94655, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1180.5694580078125, 2216.361083984375, 12.28936386108398437, 10, 120, 0, 0, 1129, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Soul Leech (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+3, 101288, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1336.68408203125, 2132.84033203125, 93.943206787109375, 5.2825775146484375, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+4, 101288, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1290.9635009765625, 2195.895751953125, 57.61343765258789062, 5.334726333618164062, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+5, 101748, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1294.18408203125, 2155.342041015625, 65.427459716796875, 0.122197546064853668, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Fel Geyser (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+6, 101748, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1298.7447509765625, 2185.507080078125, 59.26985549926757812, 0.122197546064853668, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Fel Geyser (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+7, 94655, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1331.91552734375, 2148.936279296875, 88.900848388671875, 1.4300079345703125, 120, 10, 0, 1129, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Soul Leech (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+8, 101748, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1368.84375, 2239.151123046875, 85.1483154296875, 0.122197546064853668, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Fel Geyser (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+9, 101748, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1382.2274169921875, 2200.657958984375, 91.77230072021484375, 0.122197546064853668, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Fel Geyser (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+10, 101748, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1341.734375, 2113.486083984375, 93.1077880859375, 0.122197546064853668, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Fel Geyser (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+11, 101748, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1373.7274169921875, 2215.5400390625, 89.9414520263671875, 0.122197546064853668, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Fel Geyser (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+12, 101748, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1392.5260009765625, 2268.204833984375, 72.71968841552734375, 0.122197546064853668, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Fel Geyser (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+13, 99650, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1320.41845703125, 2222.496337890625, 65.626861572265625, 1.986382007598876953, 120, 10, 0, 5, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Thornclaw Broodling (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+14, 101288, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1185.2864990234375, 2147.421875, 60.21644973754882812, 3.015295028686523437, 120, 4, 0, 3106, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+15, 101748, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1270.6978759765625, 2250.147705078125, 30.09471702575683593, 0.122197546064853668, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Fel Geyser (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+16, 101748, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1437.0382080078125, 2124.866455078125, 102.1797027587890625, 0.122197546064853668, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Fel Geyser (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+17, 101288, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1234.0704345703125, 2242.5341796875, 25.58222198486328125, 2.44472813606262207, 120, 4, 0, 3106, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+18, 101748, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1217.951416015625, 2309.557373046875, -12.1867380142211914, 0.122197546064853668, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Fel Geyser (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+19, 101288, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1237.18359375, 2143.4228515625, 57.42170333862304687, 4.89102029800415039, 120, 4, 0, 3106, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+20, 101748, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1250.3385009765625, 2258.65283203125, 21.03161430358886718, 0.122197546064853668, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Fel Geyser (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+21, 101288, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1223.4156494140625, 2249.452880859375, 18.34777641296386718, 5.476366996765136718, 120, 4, 0, 3106, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+22, 101288, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1283.4410400390625, 2264.210205078125, 33.0902862548828125, 3.371525526046752929, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+23, 101748, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1438.2100830078125, 2144.907958984375, 102.1116180419921875, 0.122197546064853668, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Fel Geyser (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+24, 101748, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1375.60595703125, 2058.1337890625, 99.97265625, 0.122197546064853668, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Fel Geyser (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+25, 101288, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1325.6553955078125, 2110.618896484375, 91.9345703125, 4.008192062377929687, 120, 4, 0, 3106, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+26, 94655, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1244.107666015625, 2084.80029296875, 69.9457244873046875, 1.48111581802368164, 120, 0, 0, 1129, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Soul Leech (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+27, 99656, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1249.8240966796875, 2216.8681640625, 33.23112869262695312, 2.502387523651123046, 120, 10, 0, 5, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Red Broodling (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+28, 101288, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1188.7552490234375, 2235.59375, 15.39151668548583984, 6.096101760864257812, 120, 4, 0, 3106, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+29, 97603, 1481, 7705, 7713, '0', 0, 0, 0, 1, 1492.96875, 1906.576416015625, 67.338897705078125, 4.557210445404052734, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Doom Slayer (Area: Inferno Peak - Difficulty: 0) CreateObject1 (Auras: 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune)) +(@CGUID+30, 101748, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1391.796875, 2177.29345703125, 92.65099334716796875, 0.122197546064853668, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Fel Geyser (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+31, 99650, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1180.4097900390625, 2151.270751953125, 62.9303436279296875, 3.881151914596557617, 120, 10, 0, 5, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Thornclaw Broodling (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+32, 99650, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1248.4189453125, 2147.115966796875, 48.98194503784179687, 2.399705410003662109, 120, 10, 0, 5, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Thornclaw Broodling (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+33, 101748, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1346.2882080078125, 2138.600830078125, 90.79993438720703125, 0.122197546064853668, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Fel Geyser (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+34, 101748, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1361.939208984375, 2088.638916015625, 98.04991912841796875, 0.122197546064853668, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Fel Geyser (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+35, 101748, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1403.4444580078125, 2033.3975830078125, 101.9391555786132812, 0.122197546064853668, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Fel Geyser (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+36, 94655, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1249.0989990234375, 2283.89404296875, 15.41629886627197265, 10, 120, 0, 0, 1129, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Soul Leech (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+37, 101288, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1276.1617431640625, 2299.21044921875, 27.86720657348632812, 5.707898139953613281, 120, 4, 0, 3106, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+38, 94655, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1175.736083984375, 2279.053955078125, 0.986831843852996826, 4.846424579620361328, 120, 10, 0, 1129, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Soul Leech (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+39, 101288, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1181.4114990234375, 2287.8056640625, 5.51836395263671875, 6.149211406707763671, 120, 4, 0, 3106, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+40, 99656, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1325.43408203125, 2290.75, 72.6002349853515625, 4.751863479614257812, 120, 10, 0, 5, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Red Broodling (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+41, 101288, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1204.8489990234375, 2312.701416015625, -10.1591300964355468, 1.701243281364440917, 120, 4, 0, 3106, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+42, 99650, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1112.9703369140625, 2222.09765625, -8.61129093170166015, 1.174417376518249511, 120, 10, 0, 5, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Thornclaw Broodling (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+43, 94655, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1362.39892578125, 2232.858642578125, 86.7499237060546875, 2.132344245910644531, 120, 10, 0, 1129, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Soul Leech (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+44, 94655, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1393.826416015625, 2160.142822265625, 95.2934722900390625, 4.023154258728027343, 120, 10, 0, 1129, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Soul Leech (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+45, 101288, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1396.59033203125, 2251.76904296875, 80.2812957763671875, 2.243822813034057617, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+46, 99650, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1392.9825439453125, 2295.06640625, 71.41387939453125, 6.136466503143310546, 120, 10, 0, 5, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Thornclaw Broodling (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+47, 101288, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1420.158203125, 2156.935546875, 105.8828887939453125, 6.015219688415527343, 120, 4, 0, 3106, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+48, 101748, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1412.798583984375, 2004.6041259765625, 101.0859222412109375, 0.122197546064853668, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Fel Geyser (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+49, 94655, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1334.06201171875, 2097.445068359375, 96.1309051513671875, 0.799209415912628173, 120, 10, 0, 1129, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Soul Leech (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+50, 94655, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1383.3958740234375, 2084.8525390625, 99.58807373046875, 5.215888500213623046, 120, 10, 0, 1129, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Soul Leech (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+51, 101288, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1431.5723876953125, 2129.5302734375, 103.5511322021484375, 5.642039775848388671, 120, 4, 0, 3106, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+52, 101748, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1412.7274169921875, 1973.27783203125, 97.06513214111328125, 0.122197546064853668, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Fel Geyser (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+53, 94655, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1448.5364990234375, 2083.87158203125, 114.8671875, 0.887604892253875732, 120, 10, 0, 1129, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Soul Leech (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+54, 101288, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1394.55078125, 2056.224853515625, 104.39300537109375, 5.95803689956665039, 120, 4, 0, 3106, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+55, 101288, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1456.71875, 2090.26904296875, 125.417388916015625, 3.248174190521240234, 120, 4, 0, 3106, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+56, 101748, 1481, 7705, 7705, '0', 0, 0, 0, 0, 1453.8125, 1958.4254150390625, 86.37097930908203125, 0.122197546064853668, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Fel Geyser (Area: Mardum, the Shattered Abyss - Difficulty: 0) CreateObject1 +(@CGUID+57, 101288, 1481, 7705, 7713, '0', 0, 0, 0, 0, 1356.09033203125, 2022.8489990234375, 103.11431884765625, 0.871825218200683593, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Inferno Peak - Difficulty: 0) CreateObject1 +(@CGUID+58, 101288, 1481, 7705, 7713, '0', 0, 0, 0, 0, 1427.6666259765625, 2017.982666015625, 106.2523422241210937, 3.745103836059570312, 120, 4, 0, 3106, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Inferno Peak - Difficulty: 0) CreateObject1 +(@CGUID+59, 99656, 1481, 7705, 7713, '0', 0, 0, 0, 0, 1385.092041015625, 2018.7117919921875, 100.4149322509765625, 1.370781898498535156, 120, 10, 0, 5, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Red Broodling (Area: Inferno Peak - Difficulty: 0) CreateObject1 +(@CGUID+60, 94655, 1481, 7705, 7713, '0', 0, 0, 0, 0, 1451.8316650390625, 2021.720458984375, 108.3912582397460937, 2.122258424758911132, 120, 10, 0, 1129, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Soul Leech (Area: Inferno Peak - Difficulty: 0) CreateObject1 +(@CGUID+61, 93716, 1481, 7705, 7713, '0', 0, 0, 0, 3, 1471.828125, 1995.1353759765625, 103.5131988525390625, 1.30901503562927246, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Doom Slayer (Area: Inferno Peak - Difficulty: 0) CreateObject1 +(@CGUID+62, 101288, 1481, 7705, 7713, '0', 0, 0, 0, 0, 1436.9617919921875, 1969.5677490234375, 96.694244384765625, 0.333606719970703125, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Inferno Peak - Difficulty: 0) CreateObject1 +(@CGUID+63, 101288, 1481, 7705, 7713, '0', 0, 0, 0, 0, 1449.267333984375, 1945.2257080078125, 88.13549041748046875, 5.561549186706542968, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Inferno Peak - Difficulty: 0) CreateObject1 +(@CGUID+64, 93716, 1481, 7705, 7713, '0', 0, 0, 0, 2, 1510.5260009765625, 1966.795166015625, 89.57257080078125, 2.054637432098388671, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Doom Slayer (Area: Inferno Peak - Difficulty: 0) CreateObject1 +(@CGUID+65, 99650, 1481, 7705, 7713, '0', 0, 0, 0, 0, 1446.9776611328125, 1945.1280517578125, 87.80252838134765625, 3.71903228759765625, 120, 10, 0, 5, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Thornclaw Broodling (Area: Inferno Peak - Difficulty: 0) CreateObject1 +(@CGUID+66, 94655, 1481, 7705, 7713, '0', 0, 0, 0, 0, 1513.673583984375, 1953.0972900390625, 85.44197845458984375, 0.216364696621894836, 120, 10, 0, 1129, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Soul Leech (Area: Inferno Peak - Difficulty: 0) CreateObject1 +(@CGUID+67, 93716, 1481, 7705, 7713, '0', 0, 0, 0, 2, 1489.3004150390625, 1927.798583984375, 74.1589202880859375, 4.496942520141601562, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Doom Slayer (Area: Inferno Peak - Difficulty: 0) CreateObject1 +(@CGUID+68, 101288, 1481, 7705, 7713, '0', 0, 0, 0, 0, 1490.24658203125, 1911.5711669921875, 69.577667236328125, 5.228761672973632812, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Inferno Peak - Difficulty: 0) CreateObject1 +(@CGUID+69, 97603, 1481, 7705, 7712, '0', 0, 0, 0, 1, 1501.736083984375, 1807.6285400390625, 46.97268295288085937, 3.382666349411010742, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Doom Slayer (Area: Illidari Foothold - Difficulty: 0) CreateObject1 (Auras: 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune)) +(@CGUID+70, 97603, 1481, 7705, 7712, '0', 0, 0, 0, 1, 1503.24658203125, 1792.0850830078125, 47.8784027099609375, 2.016900539398193359, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Doom Slayer (Area: Illidari Foothold - Difficulty: 0) CreateObject1 (Auras: 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune)) +(@CGUID+71, 97603, 1481, 7705, 7712, '0', 0, 0, 0, 1, 1458.66845703125, 1853.3507080078125, 65.727935791015625, 3.592181205749511718, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Doom Slayer (Area: Illidari Foothold - Difficulty: 0) CreateObject1 (Auras: 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune)) +(@CGUID+72, 97603, 1481, 7705, 7712, '0', 0, 0, 0, 1, 1486.717041015625, 1895.3316650390625, 66.12921142578125, 3.51352548599243164, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Doom Slayer (Area: Illidari Foothold - Difficulty: 0) CreateObject1 (Auras: 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune)) +(@CGUID+73, 97603, 1481, 7705, 7712, '0', 0, 0, 0, 1, 1455.96875, 1880.9930419921875, 68.8471221923828125, 5.334343433380126953, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Doom Slayer (Area: Illidari Foothold - Difficulty: 0) CreateObject1 (Auras: 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune)) +(@CGUID+74, 97604, 1481, 7705, 7712, '0', 0, 0, 0, 1, 1496.52783203125, 1805.9149169921875, 48.51848602294921875, 4.226232051849365234, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Queen's Centurion (Area: Illidari Foothold - Difficulty: 0) CreateObject1 (Auras: 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune)) +(@CGUID+75, 96502, 1481, 7705, 7712, '0', 0, 0, 0, 1, 1553.361083984375, 1809.2742919921875, 4.442063808441162109, 6.052255153656005859, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Coilskar Myrmidon (Area: Illidari Foothold - Difficulty: 0) CreateObject1 (Auras: 159474 - Permanent Feign Death (NO Stun, Untrackable, Immune)) +(@CGUID+76, 101288, 1481, 7705, 7712, '0', 0, 0, 0, 0, 1553.9375, 1805.15625, 5.321775436401367187, 1.756915569305419921, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Illidari Foothold - Difficulty: 0) CreateObject1 +(@CGUID+77, 101288, 1481, 7705, 7712, '0', 0, 0, 0, 0, 1536.10595703125, 1848.4375, 3.107820034027099609, 5.491298675537109375, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Illidari Foothold - Difficulty: 0) CreateObject1 +(@CGUID+78, 101288, 1481, 7705, 7712, '0', 0, 0, 0, 0, 1520.614013671875, 1875.5386962890625, 0.280856609344482421, 3.171597480773925781, 120, 4, 0, 3106, 0, 1, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Illidari Foothold - Difficulty: 0) CreateObject1 +(@CGUID+79, 101288, 1481, 7705, 7712, '0', 0, 0, 0, 0, 1547.2535400390625, 1822.859375, 5.234502792358398437, 5.114633560180664062, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Illidari Foothold - Difficulty: 0) CreateObject1 +(@CGUID+80, 101288, 1481, 7705, 7712, '0', 0, 0, 0, 0, 1540.921875, 1849.7899169921875, 3.011479139328002929, 4.868092060089111328, 120, 0, 0, 3106, 0, 0, NULL, NULL, NULL, NULL, 52106), -- Abyssal Basilisk (Area: Illidari Foothold - Difficulty: 0) CreateObject1 +(@CGUID+81, 101288, 1481, 7705, 7712, '0', 0, 0, 0, 0, 1551.4771728515625, 1865.6146240234375, 1.052178859710693359, 1.912309527397155761, 120, 4, 0, 3106, 0, 1, NULL, NULL, NULL, NULL, 52106); -- Abyssal Basilisk (Area: Illidari Foothold - Difficulty: 0) CreateObject1 + +-- Template +UPDATE `creature_template` SET `unit_flags`=536904448, `unit_flags2`=33556481, `unit_flags3`=8192 WHERE `entry`=96502; -- Coilskar Myrmidon + +-- Template Addon +DELETE FROM `creature_template_addon` WHERE `entry` IN (97603, 93716, 97604, 96502); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(97603, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 0, 0, '159474'), -- 97603 (Doom Slayer) - Permanent Feign Death (NO Stun, Untrackable, Immune) +(93716, 0, 0, 0, 2, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 93716 (Doom Slayer) +(97604, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 0, 0, '159474'), -- 97604 (Queen's Centurion) - Permanent Feign Death (NO Stun, Untrackable, Immune) +(96502, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 0, 0, '159474'); -- 96502 (Coilskar Myrmidon) - Permanent Feign Death (NO Stun, Untrackable, Immune) + +-- Creature Movement +DELETE FROM `creature_template_movement` WHERE `CreatureId` = 93716; +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`, `InteractionPauseTimer`) VALUES +(93716, 2, 0, 0, 0, 0, 0, NULL); |