diff options
| author | Naddley <NaddleyTC@gmail.com> | 2024-09-17 22:40:55 +0200 |
|---|---|---|
| committer | Naddley <NaddleyTC@gmail.com> | 2024-09-17 22:40:55 +0200 |
| commit | 080c15362c7584b778a7429415fbbfef9915cf9f (patch) | |
| tree | 77ff42dbec2ddbbd05e47e36cd8234c1fe5b97c4 | |
| parent | 1f60e76b7f157af6a24fa3c962b59f3391b21e75 (diff) | |
DB/Nerub-arPalace: Added spawns until first Boss
| -rw-r--r-- | sql/updates/world/master/2024_09_17_01_world.sql | 613 |
1 files changed, 613 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_09_17_01_world.sql b/sql/updates/world/master/2024_09_17_01_world.sql new file mode 100644 index 00000000000..e6df25d08bf --- /dev/null +++ b/sql/updates/world/master/2024_09_17_01_world.sql @@ -0,0 +1,613 @@ +SET @CGUID := 10001981; +SET @OGUID := 10000475; + +-- Creature +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+79; +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, 222214, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2704.921875, -332.529510498046875, -1164.951904296875, 1.469749093055725097, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Frenzied Leaper (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 (Auras: 441315 - Razor-sharp Claws) +(@CGUID+1, 218315, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2672.0556640625, -427.010406494140625, -1173.642333984375, 5.148128986358642578, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Kaheti Sentry (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+2, 233422, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2629.572998046875, -381.34722900390625, -1165.325927734375, 0, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Nerub-ar Palace (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+3, 226697, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2642.114990234375, -429.25457763671875, -1175.8541259765625, 5.690641403198242187, 604800, 3, 0, 1, NULL, NULL, NULL, NULL, 56513), -- Spider (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+4, 226697, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2684.75830078125, -473.49462890625, -1175.8544921875, 1.205718994140625, 604800, 3, 0, 1, NULL, NULL, NULL, NULL, 56513), -- Spider (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+5, 226697, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2637.019775390625, -434.78497314453125, -1175.8604736328125, 0.491247206926345825, 604800, 3, 0, 1, NULL, NULL, NULL, NULL, 56513), -- Spider (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+6, 222214, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2708.74658203125, -328.08160400390625, -1165.1151123046875, 6.235717296600341796, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Frenzied Leaper (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 (Auras: 441315 - Razor-sharp Claws) +(@CGUID+7, 219846, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2726.546875, -433.001739501953125, -1173.642333984375, 0, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Nerubian Alarm (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 (Auras: ) +(@CGUID+8, 218317, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2711.442626953125, -463.508697509765625, -1171.5252685546875, 0, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Woven Threadmancer (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+9, 214720, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2751.273681640625, -395.128387451171875, -1157.3221435546875, 1.599391937255859375, 604800, 3, 0, 1, NULL, NULL, NULL, NULL, 56513), -- Pill Bug (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+10, 218316, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2770.1806640625, -352.6319580078125, -1165.030029296875, 5.714919090270996093, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Kaheti Vanguard (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+11, 219776, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2617.835205078125, -475.736114501953125, -1171.915283203125, 4.195309162139892578, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Anub'azal (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+12, 214720, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2720.53125, -367.771484375, -1158.83056640625, 2.937550544738769531, 604800, 3, 0, 1, NULL, NULL, NULL, NULL, 56513), -- Pill Bug (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+13, 226697, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2687.99560546875, -478.9879150390625, -1175.8599853515625, 5.993021011352539062, 604800, 3, 0, 1, NULL, NULL, NULL, NULL, 56513), -- Spider (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+14, 218315, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2690.567626953125, -442.11285400390625, -1173.642333984375, 5.708153247833251953, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Kaheti Sentry (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+15, 226697, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2639.1962890625, -427.137054443359375, -1175.8575439453125, 2.189795970916748046, 604800, 3, 0, 1, NULL, NULL, NULL, NULL, 56513), -- Spider (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+16, 226697, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2683.72314453125, -477.345001220703125, -1175.8583984375, 0.583292007446289062, 604800, 3, 0, 1, NULL, NULL, NULL, NULL, 56513), -- Spider (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+17, 218306, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2683.90966796875, -433.052093505859375, -1173.642333984375, 5.490996360778808593, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Scarab Captain Vul'akan (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 (Auras: 18950 - Invisibility and Stealth Detection) +(@CGUID+18, 233422, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2736.661376953125, -489.81597900390625, -1166.1282958984375, 0, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Nerub-ar Palace (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+19, 219846, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2683.9462890625, -389.041656494140625, -1173.642333984375, 4.889959335327148437, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Nerubian Alarm (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 (Auras: ) +(@CGUID+20, 218317, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2653.428955078125, -405.314239501953125, -1171.5247802734375, 4.32733011245727539, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Woven Threadmancer (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+21, 222214, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2701.786376953125, -327.704864501953125, -1165.115966796875, 3.530727386474609375, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Frenzied Leaper (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 (Auras: 441315 - Razor-sharp Claws) +(@CGUID+22, 214720, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2809.91455078125, -363.690673828125, -1168.635498046875, 4.069033622741699218, 604800, 3, 0, 1, NULL, NULL, NULL, NULL, 56513), -- Pill Bug (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+23, 214714, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2696.027099609375, -267.366943359375, -1154.5858154296875, 3.723925113677978515, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Moth (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+24, 214714, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2852.40283203125, -413.3642578125, -1153.6243896484375, 2.153605222702026367, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Moth (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+25, 222193, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2770.736083984375, -337.368072509765625, -1164.9910888671875, 5.093820571899414062, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Hollow Frostweaver (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+26, 226697, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2802.07568359375, -359.565277099609375, -1168.880126953125, 2.710929155349731445, 604800, 3, 0, 1, NULL, NULL, NULL, NULL, 56513), -- Spider (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+27, 214714, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2846.161865234375, -418.69390869140625, -1154.0933837890625, 4.328064918518066406, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Moth (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+28, 222214, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2779.666748046875, -357.196197509765625, -1165.0301513671875, 5.714046955108642578, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Frenzied Leaper (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 (Auras: 441315 - Razor-sharp Claws) +(@CGUID+29, 218320, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2779.579833984375, -346.055572509765625, -1164.9910888671875, 5.799431800842285156, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Web Acolyte (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+30, 214720, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2753.429931640625, -302.472442626953125, -1171.365966796875, 3.994060516357421875, 604800, 3, 0, 1, NULL, NULL, NULL, NULL, 56513), -- Pill Bug (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+31, 222193, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2734.7275390625, -286.2257080078125, -1160.1607666015625, 3.020457267761230468, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Hollow Frostweaver (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+32, 218316, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2714.619873046875, -280.953125, -1160.1607666015625, 5.47555398941040039, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Kaheti Vanguard (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+33, 214714, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2837.5458984375, -378.7152099609375, -1153.67578125, 0.847040295600891113, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Moth (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+34, 214720, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2744.893798828125, -299.534698486328125, -1170.1407470703125, 6.008593559265136718, 604800, 3, 0, 1, NULL, NULL, NULL, NULL, 56513), -- Pill Bug (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+35, 218316, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2764.23779296875, -346.45660400390625, -1165.0301513671875, 5.244007587432861328, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Kaheti Vanguard (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+36, 226697, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2752.205078125, -303.5101318359375, -1171.074951171875, 0.824216067790985107, 604800, 3, 0, 1, NULL, NULL, NULL, NULL, 56513), -- Spider (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+37, 222214, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2761.067626953125, -335.611114501953125, -1165.0301513671875, 5.462981700897216796, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Frenzied Leaper (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 (Auras: 441315 - Razor-sharp Claws) +(@CGUID+38, 214720, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2806.7197265625, -363.17193603515625, -1170.47802734375, 2.481635093688964843, 604800, 3, 0, 1, NULL, NULL, NULL, NULL, 56513), -- Pill Bug (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+39, 226697, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2756.839111328125, -309.7943115234375, -1170.855224609375, 4.821652412414550781, 604800, 3, 0, 1, NULL, NULL, NULL, NULL, 56513), -- Spider (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+40, 214714, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2700.872802734375, -265.11016845703125, -1153.942138671875, 0.97838747501373291, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Moth (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+41, 231649, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2692.48095703125, -423.12847900390625, -1371.2127685546875, 0, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Ki'katal the Harvester (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+42, 218320, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2730.741455078125, -273.927093505859375, -1160.1607666015625, 2.345757484436035156, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Web Acolyte (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+43, 226697, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2803.73583984375, -360.144256591796875, -1170.7532958984375, 6.031390190124511718, 604800, 3, 0, 1, NULL, NULL, NULL, NULL, 56513), -- Spider (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+44, 218316, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2707.94970703125, -282.19097900390625, -1160.1607666015625, 3.499052286148071289, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Kaheti Vanguard (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+45, 218320, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2726.060791015625, -267.763885498046875, -1160.1607666015625, 2.284255504608154296, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Web Acolyte (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+46, 224439, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2767.76220703125, -291.008697509765625, -1181.8538818359375, 0.471584051847457885, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Web Support (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+47, 222235, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2680.21435546875, -220.28436279296875, -1145.92138671875, 5.733019828796386718, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Bloodthirsty Swarmer (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 (Auras: 445909 - Bloodthirsty) +(@CGUID+48, 214714, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2837.010498046875, -373.2662353515625, -1153.298828125, 5.580513954162597656, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Moth (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+49, 224439, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2765.729248046875, -275.310760498046875, -1180.059326171875, 1.236770987510681152, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Web Support (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+50, 222235, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2684.450439453125, -217.686187744140625, -1146.5870361328125, 5.733019828796386718, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Bloodthirsty Swarmer (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 (Auras: 445909 - Bloodthirsty) +(@CGUID+51, 214714, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2839.458740234375, -375.183868408203125, -1152.1002197265625, 0.175556644797325134, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Moth (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+52, 214714, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2741.485595703125, -276.046966552734375, -1154.385498046875, 4.32364654541015625, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Moth (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+53, 218317, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2732.09716796875, -267.151031494140625, -1160.1607666015625, 2.322773933410644531, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Woven Threadmancer (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+54, 214714, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2744.496826171875, -278.59185791015625, -1154.5718994140625, 5.381952285766601562, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Moth (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+55, 224439, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2844.257080078125, -335.19097900390625, -1187.1611328125, 0, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Web Support (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+56, 224439, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2842.46533203125, -350.17535400390625, -1181.117431640625, 0.009002549573779106, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Web Support (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+57, 224439, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2786.388916015625, -271.51910400390625, -1188.54443359375, 6.267438411712646484, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Web Support (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+58, 222235, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2671.221435546875, -220.373092651367187, -1145.775146484375, 0.054765596985816955, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Bloodthirsty Swarmer (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 (Auras: 445909 - Bloodthirsty) +(@CGUID+59, 214714, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2739.42041015625, -279.61810302734375, -1154.7349853515625, 0.860358715057373046, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Moth (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+60, 222235, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2675.220703125, -220.592330932617187, -1143.5284423828125, 0.054765596985816955, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Bloodthirsty Swarmer (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 (Auras: 445909 - Bloodthirsty) +(@CGUID+61, 215657, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -3041.970458984375, -76.0121536254882812, -1137.0885009765625, 5.323254108428955078, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Ulgrax the Devourer (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 (Auras: 441716 - Anim Replacement) +(@CGUID+62, 229633, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2820.59716796875, -294.5225830078125, -1189.605712890625, 0, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Ulgrax the Devourer (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+63, 220551, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -3574.712890625, -149.417022705078125, -1269.253662109375, 5.197409629821777343, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Sureki Ironweaver (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+64, 219878, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2958.65625, -173.83160400390625, -1164.1201171875, 5.72528696060180664, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Skeinspinner Takazj (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+65, 219778, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2942.182373046875, -174.762161254882812, -1163.791259765625, 5.585053443908691406, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Queen Ansurek (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+66, 222235, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2694.966796875, -207.56341552734375, -1143.0938720703125, 0.001164076151326298, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Bloodthirsty Swarmer (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 (Auras: 445909 - Bloodthirsty) +(@CGUID+67, 219877, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2941.15966796875, -153.96875, -1164.1201171875, 5.316039562225341796, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Anub'arash (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+68, 222235, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2694.19384765625, -207.938674926757812, -1143.073486328125, 0.041718415915966033, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Bloodthirsty Swarmer (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 (Auras: 445909 - Bloodthirsty) +(@CGUID+69, 223987, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -3482.960205078125, -245.822921752929687, -1415.296630859375, 0, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- BlackBlood Fall Base (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 (Auras: 450141 - -Unknown-) +(@CGUID+70, 225880, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2880.666748046875, -181.657989501953125, -1188.2779541015625, 4.622725486755371093, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Spider Silk Grub (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+71, 225184, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2623.0400390625, -475.1944580078125, -1168.127197265625, 4.678469657897949218, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Anub'azal (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject2 +(@CGUID+72, 229633, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2846.25, -193.743057250976562, -1189.370361328125, 0, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Ulgrax the Devourer (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+73, 229633, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2921.4150390625, -267.399322509765625, -1189.3385009765625, 0, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Ulgrax the Devourer (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+74, 224439, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2951.810791015625, -237.984375, -1178.007568359375, 0, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Web Support (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+75, 224439, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2876.545166015625, -174.559036254882812, -1185.557861328125, 5.979579448699951171, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Web Support (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+76, 224439, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2941.475830078125, -229.168411254882812, -1185.6419677734375, 0, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Web Support (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+77, 224439, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2872.09033203125, -157.920135498046875, -1175.1024169921875, 0, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Web Support (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+78, 224439, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2884.947998046875, -167.006942749023437, -1182.038818359375, 0, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513), -- Web Support (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@CGUID+79, 224439, 2657, 14980, 14980, '14,15,16,17', '0', 0, 0, 0, -2957.99658203125, -224.276046752929687, -1175.568603515625, 0, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 56513); -- Web Support (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+79; +INSERT INTO `creature_addon` (`guid`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+10, 0, 0, 0, 0, 0, 0, 0, 425, 0, 0, 0, 0, ''), -- Kaheti Vanguard +(@CGUID+25, 0, 0, 0, 0, 0, 1, 0, 27, 0, 0, 0, 0, ''), -- Hollow Frostweaver +(@CGUID+29, 0, 0, 0, 0, 0, 1, 0, 27, 0, 0, 0, 0, ''), -- Web Acolyte +(@CGUID+32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), -- Kaheti Vanguard +(@CGUID+35, 0, 0, 0, 0, 0, 0, 0, 425, 0, 0, 0, 0, ''), -- Kaheti Vanguard +(@CGUID+44, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''); -- Kaheti Vanguard + +-- GameObject +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+70; +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, 437231, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3605.3740234375, 585.4705810546875, -1014.713134765625, 0.231482923030853271, 0.107710838317871093, 0.012521743774414062, 0.114802360534667968, 0.987452268600463867, 604800, 255, 0, 56513), -- Web Bridge (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+1, 437233, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3810.7744140625, 596.3232421875, -1014.973876953125, 3.40346837043762207, 0.014429569244384765, -0.10957717895507812, -0.98536586761474609, 0.129764124751091003, 604800, 255, 0, 56513), -- Web Bridge (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+2, 437232, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3651.493896484375, 677.93310546875, -1003.85882568359375, 1.324368834495544433, 0.139258384704589843, 0.101413726806640625, 0.606426239013671875, 0.776253581047058105, 604800, 255, 0, 56513), -- Web Bridge (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+3, 437052, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2780.735595703125, -336.07281494140625, -1165.562255859375, 0.767246484756469726, -0.19513893127441406, -0.07891654968261718, 0.365868568420410156, 0.906550109386444091, 604800, 255, 0, 56513), -- Web (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+4, 437234, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3765.251220703125, 503.53900146484375, -1004.19439697265625, 4.487581253051757812, 0.104114532470703125, -0.13965797424316406, -0.76938152313232421, 0.614579439163208007, 604800, 255, 0, 56513), -- Web Bridge (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+5, 437049, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3612.205322265625, 495.29327392578125, -1038.6588134765625, 0.801644623279571533, 0.032105445861816406, 0.013605117797851562, 0.3899383544921875, 0.920180499553680419, 604800, 255, 0, 56513), -- Web (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+6, 422811, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2862.576416015625, -252.168411254882812, -1189.6070556640625, 3.394674062728881835, 0, 0, -0.99200439453125, 0.126203224062919616, 604800, 255, 1, 56513), -- Platform (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+7, 445007, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3517.245361328125, -422.53326416015625, -1083.572021484375, 4.450592041015625, 0.097948551177978515, -0.12764835357666015, -0.78301620483398437, 0.600830793380737304, 604800, 255, 0, 56513), -- Web (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+8, 444355, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2719.962646484375, -396.542388916015625, -1158.6959228515625, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 604800, 255, 1, 56513), -- Door (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+9, 451920, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2623.03125, -475.0625, -1172.01171875, 1.648617029190063476, 0, 0, 0.734078407287597656, 0.679064691066741943, 604800, 255, 0, 56513), -- Shadecaster (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+10, 453133, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2815.404541015625, -291.671875, -1188.4521484375, 2.930126667022705078, 0.057314872741699218, 0.879755973815917968, 0.457345962524414062, 0.116529524326324462, 604800, 255, 1, 56513), -- Web (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+11, 453918, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2370.3427734375, -419.7744140625, -1184.5657958984375, 6.267125606536865234, 0, 0, -0.00802993774414062, 0.999967753887176513, 604800, 255, 1, 56513), -- Chair (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+12, 453141, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2812.592041015625, -288.09375, -1190.4534912109375, 0.604273080825805664, -0.14064311981201171, -0.05372238159179687, 0.292798995971679687, 0.944246888160705566, 604800, 255, 1, 56513), -- Web (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+13, 453140, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2827.069580078125, -302.685760498046875, -1190.5321044921875, 4.026968955993652343, 0.085697650909423828, -0.19688129425048828, -0.88187599182128906, 0.419748038053512573, 604800, 255, 1, 56513), -- Web (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+14, 453137, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2842.833251953125, -322.196197509765625, -1199.88525390625, 3.732559680938720703, 0.040721893310546875, -0.0171966552734375, -0.95600605010986328, 0.289997249841690063, 604800, 255, 1, 56513), -- Web (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+15, 453136, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2817.076416015625, -296.9913330078125, -1186.1590576171875, 4.099550247192382812, 0.4428253173828125, -0.8580484390258789, -0.22648906707763671, 0.127911284565925598, 604800, 255, 1, 56513), -- Web (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+16, 453139, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2821.147705078125, -302.60589599609375, -1186.473876953125, 3.597314357757568359, 0.2384796142578125, -0.89129638671875, -0.38545799255371093, 0.011845224536955356, 604800, 255, 1, 56513), -- Web (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+17, 452122, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3608.39794921875, 197.63232421875, -1112.198974609375, 5.788933277130126953, 0, 0, -0.24461841583251953, 0.969619393348693847, 604800, 255, 0, 56513), -- Barrier (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+18, 443865, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3439.1552734375, 257.05718994140625, -1090.74755859375, 6.206035137176513671, 0, 0, -0.03856563568115234, 0.999256074428558349, 604800, 255, 0, 56513), -- Door (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+19, 441734, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3729.640625, -285.5, -1142.0777587890625, 0, 0, 0, 0, 1, 604800, 255, 1, 56513), -- Weapon Rack (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+20, 443864, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3374.102783203125, 323.00799560546875, -1090.61572265625, 4.803981304168701171, 0, 0, -0.67399406433105468, 0.738736748695373535, 604800, 255, 1, 56513), -- Door (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+21, 453144, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2796.0625, -274.296875, -1198.9029541015625, 3.94437575340270996, 0.004566192626953125, -0.00539779663085937, -0.92050075531005859, 0.390676796436309814, 604800, 255, 1, 56513), -- Web (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+22, 453147, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2827.6181640625, -288.9288330078125, -1190.2335205078125, 3.234630584716796875, -0.0085759162902832, 0.67523193359375, -0.7354898452758789, 0.055163357406854629, 604800, 255, 1, 56513), -- Web (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+23, 449810, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2220.59033203125, -1684.2547607421875, -1189.84228515625, 2.085664033889770507, 0, 0, 0.863834381103515625, 0.50377589464187622, 604800, 255, 0, 56513), -- Door (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+24, 449810, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3436.943359375, -810.80902099609375, -1009.177001953125, 0.270525157451629638, 0, 0, 0.134850502014160156, 0.990865945816040039, 604800, 255, 0, 56513), -- Door (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+25, 449810, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2581.024169921875, -1300.4906005859375, -899.906494140625, 0, 0, 0, 0, 1, 604800, 255, 0, 56513), -- Door (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+26, 441734, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3664.270751953125, -426.079864501953125, -1076.135986328125, 0.998730719089508056, 0, 0, 0.478868484497070312, 0.877886652946472167, 604800, 255, 1, 56513), -- Weapon Rack (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+27, 438045, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2482.392578125, -1175.0770263671875, -1131.857177734375, 0, 0, 0, 0, 1, 604800, 255, 1, 56513), -- Door (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+28, 441734, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3763.09375, -251.802078247070312, -1142.0777587890625, 0, 0, 0, 0, 1, 604800, 255, 1, 56513), -- Weapon Rack (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+29, 441734, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3645.157958984375, -431.151031494140625, -1076.135986328125, 0.998730719089508056, 0, 0, 0.478868484497070312, 0.877886652946472167, 604800, 255, 1, 56513), -- Weapon Rack (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+30, 438047, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2648.23046875, -1204.9637451171875, -1131.857177734375, 5.497961997985839843, 0, 0, -0.38260269165039062, 0.92391294240951538, 604800, 255, 1, 56513), -- Door (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+31, 445076, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3182.06640625, 65.30352783203125, -1136.87890625, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 604800, 255, 1, 56513), -- Web Door (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+32, 441734, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3685.560791015625, -351.82464599609375, -1074.0526123046875, 0, 0, 0, 0, 1, 604800, 255, 1, 56513), -- Weapon Rack (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+33, 438046, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2648.26220703125, -1145.0802001953125, -1131.857177734375, 3.926820993423461914, 0, 0, -0.92391204833984375, 0.382604897022247314, 604800, 255, 1, 56513), -- Door (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+34, 453135, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2825.423583984375, -298.17535400390625, -1189.4339599609375, 2.490072011947631835, -0.30225992202758789, -0.67655372619628906, 0.656682968139648437, 0.140290603041648864, 604800, 255, 1, 56513), -- Web (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+35, 453134, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2818.788330078125, -289.395843505859375, -1189.8712158203125, 2.302958965301513671, -0.36570692062377929, -0.60686111450195312, 0.675136566162109375, 0.205349981784820556, 604800, 255, 1, 56513), -- Web (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+36, 445075, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2993.99755859375, -122.765625, -1138.4207763671875, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 604800, 255, 0, 56513), -- Web Door (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+37, 441710, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3569.751708984375, -408.777252197265625, -1078.1759033203125, 2.88005232810974121, -0.08501529693603515, 0.011180877685546875, 0.987810134887695312, 0.129917457699775695, 604800, 255, 1, 56513), -- Door (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+38, 444012, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3381.859375, 355.76824951171875, -1061.8153076171875, 4.727564334869384765, 0, 0, -0.70172119140625, 0.712451636791229248, 604800, 255, 0, 56513), -- Door (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+39, 445024, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3263.971435546875, 145.6492919921875, -1091.687255859375, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 604800, 255, 1, 56513), -- Door (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+40, 441734, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3740.595458984375, -246.55035400390625, -1142.0777587890625, 0, 0, 0, 0, 1, 604800, 255, 1, 56513), -- Weapon Rack (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+41, 454747, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3450.510498046875, 333.57049560546875, -1054.9351806640625, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 604800, 255, 0, 56513), -- 11DU_NerubianRaid_Special_WebWall01 (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+42, 445179, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3546.084228515625, 429.1441650390625, -1054.65625, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 604800, 255, 1, 56513), -- 11DU_NerubianRaid_Special_WebWall01 (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+43, 441734, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3706.40625, -357.182281494140625, -1074.0526123046875, 0, 0, 0, 0, 1, 604800, 255, 1, 56513), -- Weapon Rack (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+44, 444011, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3447.8427734375, 329.318359375, -1059.646484375, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 604800, 255, 1, 56513), -- Door (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+45, 444779, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3470.069580078125, -64.0694427490234375, -1310.051025390625, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 604800, 255, 1, 56513), -- Door (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+46, 449810, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2913.870361328125, 567.7503662109375, -1028.9508056640625, 3.141592741012573242, 0, 0, -1, 0, 604800, 255, 0, 56513), -- Door (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+47, 453138, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2828.359375, -298.751739501953125, -1194.819580078125, 3.804620265960693359, -0.25764274597167968, 0.442805290222167968, -0.82915878295898437, 0.223694905638694763, 604800, 255, 1, 56513), -- Web (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+48, 449810, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2370.33935546875, -1679.9903564453125, -1168.0537109375, 0.94247448444366455, 0, 0, 0.453989028930664062, 0.89100724458694458, 604800, 255, 0, 56513), -- Door (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+49, 441734, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3752.232666015625, -291.52777099609375, -1142.0777587890625, 0, 0, 0, 0, 1, 604800, 255, 1, 56513), -- Weapon Rack (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+50, 441288, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3723.4892578125, 649.563232421875, -969.72308349609375, 1.834337949752807617, 0, 0, 0.793883323669433593, 0.608070075511932373, 604800, 255, 1, 56513), -- 11.0 Raid - Nerubian - Boss - Queen - WebWall 1 - SRC (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+51, 441291, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3692.2978515625, 532.45184326171875, -969.72308349609375, 4.974529266357421875, 0, 0, -0.60862636566162109, 0.793456971645355224, 604800, 255, 1, 56513), -- 11.0 Raid - Nerubian - Boss - Queen - WebWall 4 - SRC (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+52, 441290, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3750.4765625, 548.06195068359375, -969.72308349609375, 3.929305076599121093, 0, 0, -0.92343616485595703, 0.383752107620239257, 604800, 255, 1, 56513), -- 11.0 Raid - Nerubian - Boss - Queen - WebWall 5 - SRC (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+53, 449810, 2657, 14980, 14980, '14,15,16,17', '0', 0, -4199.08544921875, -746.9254150390625, -1123.77001953125, 3.141592741012573242, 0, 0, -1, 0, 604800, 255, 0, 56513), -- Door (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+54, 435013, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3596.720703125, 584.95361328125, -1013.89410400390625, 5.780613899230957031, 0, 0, -0.24864959716796875, 0.968593478202819824, 604800, 255, 1, 56513), -- Web Spool (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+55, 435015, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3803.57470703125, 601.1871337890625, -1013.89410400390625, 5.780613899230957031, 0, 0, -0.24864959716796875, 0.968593478202819824, 604800, 255, 1, 56513), -- Web Spool (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+56, 449810, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3148.130126953125, 909.4046630859375, -954.40643310546875, 3.141592741012573242, 0, 0, -1, 0, 604800, 255, 0, 56513), -- Door (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+57, 435014, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3612.31494140625, 580.6156005859375, -1013.89410400390625, 5.780613899230957031, 0, 0, -0.24864959716796875, 0.968593478202819824, 604800, 255, 1, 56513), -- Web Spool (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+58, 444013, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3422.48095703125, 550.3504638671875, -1042.37939453125, 5.789212703704833984, 0, 0, -0.24448299407958984, 0.969653546810150146, 604800, 255, 1, 56513), -- Door (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+59, 441287, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3664.847900390625, 633.6912841796875, -969.72308349609375, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 604800, 255, 1, 56513), -- 11.0 Raid - Nerubian - Boss - Queen - WebWall 2 - SRC (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+60, 435020, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3650.85986328125, 687.7408447265625, -1000.88134765625, 0.542483806610107421, 0, 0, 0.267928123474121093, 0.963438928127288818, 604800, 255, 1, 56513), -- Web Spool (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+61, 435017, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3764.403076171875, 493.48699951171875, -1000.88134765625, 0.519035935401916503, 0, 0, 0.25661468505859375, 0.966513812541961669, 604800, 255, 1, 56513), -- Web Spool (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+62, 441292, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3649.41015625, 575.1705322265625, -969.72308349609375, 6.025851726531982421, 0, 0, -0.1283121109008789, 0.991733849048614501, 604800, 255, 1, 56513), -- 11.0 Raid - Nerubian - Boss - Queen - WebWall 3 - SRC (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+63, 435016, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3818.97509765625, 597.0675048828125, -1013.89410400390625, 5.780613899230957031, 0, 0, -0.24864959716796875, 0.968593478202819824, 604800, 255, 1, 56513), -- Web Spool (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+64, 435019, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3656.183837890625, 668.641845703125, -1000.88134765625, 0.625952899456024169, 0, 0, 0.307891845703125, 0.951421380043029785, 604800, 255, 1, 56513), -- Web Spool (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+65, 435018, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3759.051513671875, 512.423095703125, -1000.88134765625, 0.53449404239654541, 0, 0, 0.264077186584472656, 0.964501559734344482, 604800, 255, 1, 56513), -- Web Spool (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+66, 441289, 2657, 14980, 14980, '14,15,16,17', '0', 0, -3766.47998046875, 606.5386962890625, -969.72308349609375, 2.880476713180541992, 0, 0, 0.991489410400390625, 0.130187407135963439, 604800, 255, 1, 56513), -- 11.0 Raid - Nerubian - Boss - Queen - WebWall 6 - SRC (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+67, 453145, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2932.333251953125, -234.006942749023437, -1198.0076904296875, 1.095979213714599609, -0.03194952011108398, -0.07658863067626953, 0.516368865966796875, 0.852335929870605468, 604800, 255, 1, 56513), -- Web (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+68, 453146, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2933.630126953125, -238.142364501953125, -1198.75, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 604800, 255, 1, 56513), -- Web (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+69, 453143, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2881.63720703125, -184.907989501953125, -1198.3223876953125, 6.034157752990722656, -0.03796768188476562, -0.02885150909423828, -0.12518024444580078, 0.990987360477447509, 604800, 255, 1, 56513), -- Web (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +(@OGUID+70, 453142, 2657, 14980, 14980, '14,15,16,17', '0', 0, -2885.3369140625, -185.954864501953125, -1198.3775634765625, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 604800, 255, 1, 56513); -- Web (Area: Nerub-ar Palace - Difficulty: Heroic) CreateObject1 +DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+70; +INSERT INTO `gameobject_addon` (`guid`, `parent_rotation0`, `parent_rotation1`, `parent_rotation2`, `parent_rotation3`, `WorldEffectID`, `AIAnimKitID`) VALUES +(@OGUID+0, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Web Bridge +(@OGUID+1, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Web Bridge +(@OGUID+2, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Web Bridge +(@OGUID+3, 0, 0, -0.38268372416496276, 0.923879444599151611, 0, 0), -- Web +(@OGUID+4, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Web Bridge +(@OGUID+5, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Web +(@OGUID+6, 0, 0, 0, 1, 0, 0), -- Platform +(@OGUID+7, 0, 0, 1, -0.00000004371138828, 0, 0), -- Web +(@OGUID+8, 0, 0, -0.38268372416496276, 0.923879444599151611, 0, 0), -- Door +(@OGUID+11, 0, 0, 0.000000325841369885, 1, 0, 0), -- Chair +(@OGUID+17, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Barrier +(@OGUID+18, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Door +(@OGUID+20, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Door +(@OGUID+23, 0, 0, 0.863834738731384277, 0.503775298595428466, 0, 0), -- Door +(@OGUID+24, 0, 0, 0.134851425886154174, 0.990865826606750488, 0, 0), -- Door +(@OGUID+25, 0, 0, 0.000000325841369885, 1, 0, 0), -- Door +(@OGUID+27, 0, 0, 0.000000325841369885, 1, 0, 0), -- Door +(@OGUID+30, 0, 0, 0.000000325841369885, 1, 0, 0), -- Door +(@OGUID+31, 0, 0, -0.38268372416496276, 0.923879444599151611, 0, 0), -- Web Door +(@OGUID+33, 0, 0, 0.000000325841369885, 1, 0, 0), -- Door +(@OGUID+36, 0, 0, -0.38268372416496276, 0.923879444599151611, 0, 0), -- Web Door +(@OGUID+37, 0, 0, 1, -0.00000004371138828, 0, 0), -- Door +(@OGUID+38, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Door +(@OGUID+39, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Door +(@OGUID+41, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- 11DU_NerubianRaid_Special_WebWall01 +(@OGUID+42, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- 11DU_NerubianRaid_Special_WebWall01 +(@OGUID+44, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Door +(@OGUID+46, 0, 0, 1, -0.00000004371138828, 0, 0), -- Door +(@OGUID+48, 0, 0, 0.453989654779434204, 0.891006946563720703, 0, 0), -- Door +(@OGUID+50, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- 11.0 Raid - Nerubian - Boss - Queen - WebWall 1 - SRC +(@OGUID+51, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- 11.0 Raid - Nerubian - Boss - Queen - WebWall 4 - SRC +(@OGUID+52, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- 11.0 Raid - Nerubian - Boss - Queen - WebWall 5 - SRC +(@OGUID+53, 0, 0, 1, -0.00000004371138828, 0, 0), -- Door +(@OGUID+54, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Web Spool +(@OGUID+55, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Web Spool +(@OGUID+56, 0, 0, 1, -0.00000004371138828, 0, 0), -- Door +(@OGUID+57, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Web Spool +(@OGUID+58, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Door +(@OGUID+59, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- 11.0 Raid - Nerubian - Boss - Queen - WebWall 2 - SRC +(@OGUID+60, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Web Spool +(@OGUID+61, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Web Spool +(@OGUID+62, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- 11.0 Raid - Nerubian - Boss - Queen - WebWall 3 - SRC +(@OGUID+63, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Web Spool +(@OGUID+64, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Web Spool +(@OGUID+65, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Web Spool +(@OGUID+66, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0); -- 11.0 Raid - Nerubian - Boss - Queen - WebWall 6 - SRC + +-- Template Addon +DELETE FROM `creature_template_addon` WHERE `entry` IN (220138 /*220138 (Regurgitating Monstrosity) - Invisibility and Stealth Detection*/, 225880 /*225880 (Spider Silk Grub)*/, 223987 /*223987 (BlackBlood Fall Base) - -Unknown-*/, 219877 /*219877 (Anub'arash)*/, 219778 /*219778 (Queen Ansurek)*/, 219878 /*219878 (Skeinspinner Takazj)*/, 215657 /*215657 (Ulgrax the Devourer) - Anim Replacement*/, 231649 /*231649 (Ki'katal the Harvester)*/, 222235 /*222235 (Bloodthirsty Swarmer) - Bloodthirsty*/, 214714 /*214714 (Moth)*/, 218306 /*218306 (Scarab Captain Vul'akan) - Invisibility and Stealth Detection*/, 218316 /*218316 (Kaheti Vanguard)*/, 222214 /*222214 (Frenzied Leaper) - Razor-sharp Claws*/); +INSERT INTO `creature_template_addon` (`entry`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(220138, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 4, '18950'), -- 220138 (Regurgitating Monstrosity) - Invisibility and Stealth Detection +(225880, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 4, ''), -- 225880 (Spider Silk Grub) +(223987, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '450141'), -- 223987 (BlackBlood Fall Base) - -Unknown- +(219877, 0, 0, 0, 0, 0, 1, 0, 0, 29973, 0, 0, 4, ''), -- 219877 (Anub'arash) +(219778, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 4, ''), -- 219778 (Queen Ansurek) +(219878, 0, 0, 0, 0, 0, 1, 0, 0, 29973, 0, 0, 4, ''), -- 219878 (Skeinspinner Takazj) +(215657, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 4, '441716'), -- 215657 (Ulgrax the Devourer) - Anim Replacement +(231649, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 0, 0, ''), -- 231649 (Ki'katal the Harvester) +(214714, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 214714 (Moth) +(218306, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '18950'), -- 218306 (Scarab Captain Vul'akan) - Invisibility and Stealth Detection +(218316, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), -- 218316 (Kaheti Vanguard) +(222214, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '441315'); -- 222214 (Frenzied Leaper) - Razor-sharp Claws + +DELETE FROM `gameobject_template_addon` WHERE `entry` IN (453142 /*Web*/, 453143 /*Web*/, 453146 /*Web*/, 453145 /*Web*/, 441289 /*11.0 Raid - Nerubian - Boss - Queen - WebWall 6 - SRC*/, 435018 /*Web Spool*/, 435019 /*Web Spool*/, 435016 /*Web Spool*/, 441292 /*11.0 Raid - Nerubian - Boss - Queen - WebWall 3 - SRC*/, 435017 /*Web Spool*/, 435020 /*Web Spool*/, 441287 /*11.0 Raid - Nerubian - Boss - Queen - WebWall 2 - SRC*/, 444013 /*Door*/, 435014 /*Web Spool*/, 435015 /*Web Spool*/, 435013 /*Web Spool*/, 441290 /*11.0 Raid - Nerubian - Boss - Queen - WebWall 5 - SRC*/, 441291 /*11.0 Raid - Nerubian - Boss - Queen - WebWall 4 - SRC*/, 441288 /*11.0 Raid - Nerubian - Boss - Queen - WebWall 1 - SRC*/, 453138 /*Web*/, 444779 /*Door*/, 444011 /*Door*/, 445179 /*11DU_NerubianRaid_Special_WebWall01*/, 454747 /*11DU_NerubianRaid_Special_WebWall01*/, 445024 /*Door*/, 444012 /*Door*/, 441710 /*Door*/, 445075 /*Web Door*/, 453134 /*Web*/, 453135 /*Web*/, 438046 /*Door*/, 445076 /*Web Door*/, 438047 /*Door*/, 438045 /*Door*/, 449810 /*Door*/, 453147 /*Web*/, 453144 /*Web*/, 443864 /*Door*/, 441734 /*Weapon Rack*/, 443865 /*Door*/, 452122 /*Barrier*/, 453139 /*Web*/, 453136 /*Web*/, 453137 /*Web*/, 453140 /*Web*/, 453141 /*Web*/, 453133 /*Web*/, 451920 /*Shadecaster*/, 444355 /*Door*/, 445007 /*Web*/, 422811 /*Platform*/, 437049 /*Web*/, 437234 /*Web Bridge*/, 437052 /*Web*/, 437232 /*Web Bridge*/, 437233 /*Web Bridge*/, 437231 /*Web Bridge*/); +INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES +(453142, 0, 16, 0, 0), -- Web +(453143, 0, 16, 0, 0), -- Web +(453146, 0, 16, 0, 0), -- Web +(453145, 0, 16, 0, 0), -- Web +(441289, 0, 48, 0, 0), -- 11.0 Raid - Nerubian - Boss - Queen - WebWall 6 - SRC +(435018, 0, 48, 0, 0), -- Web Spool +(435019, 0, 48, 0, 0), -- Web Spool +(435016, 0, 48, 0, 0), -- Web Spool +(441292, 0, 48, 0, 0), -- 11.0 Raid - Nerubian - Boss - Queen - WebWall 3 - SRC +(435017, 0, 48, 0, 0), -- Web Spool +(435020, 0, 48, 0, 0), -- Web Spool +(441287, 0, 48, 0, 0), -- 11.0 Raid - Nerubian - Boss - Queen - WebWall 2 - SRC +(444013, 0, 48, 0, 0), -- Door +(435014, 0, 48, 0, 0), -- Web Spool +(435015, 0, 48, 0, 0), -- Web Spool +(435013, 0, 48, 0, 0), -- Web Spool +(441290, 0, 48, 0, 0), -- 11.0 Raid - Nerubian - Boss - Queen - WebWall 5 - SRC +(441291, 0, 48, 0, 0), -- 11.0 Raid - Nerubian - Boss - Queen - WebWall 4 - SRC +(441288, 0, 48, 0, 0), -- 11.0 Raid - Nerubian - Boss - Queen - WebWall 1 - SRC +(453138, 0, 16, 0, 0), -- Web +(444779, 0, 48, 0, 0), -- Door +(444011, 0, 48, 0, 0), -- Door +(445179, 0, 48, 0, 0), -- 11DU_NerubianRaid_Special_WebWall01 +(454747, 0, 48, 0, 0), -- 11DU_NerubianRaid_Special_WebWall01 +(445024, 0, 48, 0, 0), -- Door +(444012, 0, 48, 0, 0), -- Door +(441710, 0, 48, 0, 0), -- Door +(445075, 1375, 32, 0, 0), -- Web Door +(453134, 0, 16, 0, 0), -- Web +(453135, 0, 16, 0, 0), -- Web +(438046, 0, 48, 0, 0), -- Door +(445076, 1375, 32, 0, 0), -- Web Door +(438047, 0, 48, 0, 0), -- Door +(438045, 0, 48, 0, 0), -- Door +(449810, 0, 32, 0, 0), -- Door +(453147, 0, 48, 0, 0), -- Web +(453144, 0, 16, 0, 0), -- Web +(443864, 0, 48, 0, 0), -- Door +(441734, 0, 48, 0, 0), -- Weapon Rack +(443865, 0, 48, 0, 0), -- Door +(452122, 0, 48, 0, 0), -- Barrier +(453139, 0, 16, 0, 0), -- Web +(453136, 0, 16, 0, 0), -- Web +(453137, 0, 16, 0, 0), -- Web +(453140, 0, 545259536, 0, 0), -- Web +(453141, 0, 545259536, 0, 0), -- Web +(453133, 0, 16, 0, 0), -- Web +(451920, 0, 16, 0, 0), -- Shadecaster +(444355, 0, 48, 0, 0), -- Door +(445007, 0, 268435504, 0, 0), -- Web +(422811, 0, 1048624, 0, 0), -- Platform +(437049, 0, 268435504, 0, 0), -- Web +(437234, 0, 268435504, 0, 0), -- Web Bridge +(437052, 0, 48, 0, 0), -- Web +(437232, 0, 268435504, 0, 0), -- Web Bridge +(437233, 0, 268435504, 0, 0), -- Web Bridge +(437231, 0, 268435504, 0, 0); -- Web Bridge + +-- Template +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=64, `unit_flags2`=2048, `unit_flags3`=524288 WHERE `entry`=226100; -- Kaheti Skirmisher +UPDATE `creature_template` SET `faction`=14, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=220138; -- Regurgitating Monstrosity +UPDATE `creature_template` SET `faction`=35, `npcflag`=2, `BaseAttackTime`=2000, `unit_flags`=256, `unit_flags2`=2048, `unit_flags3`=1073741825 WHERE `entry`=225184; -- Anub'azal +UPDATE `creature_template` SET `faction`=35, `speed_walk`=2.799999952316284179, `speed_run`=1, `BaseAttackTime`=2000 WHERE `entry`=225880; -- Spider Silk Grub +UPDATE `creature_template` SET `faction`=190, `BaseAttackTime`=2000, `unit_flags`=33554944, `unit_flags2`=67110912, `unit_flags3`=1090551809 WHERE `entry`=223987; -- BlackBlood Fall Base +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=256, `unit_flags2`=2048, `unit_flags3`=1 WHERE `entry`=219877; -- Anub'arash +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=256, `unit_flags2`=2048, `unit_flags3`=1 WHERE `entry`=219778; -- Queen Ansurek +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=256, `unit_flags2`=2048, `unit_flags3`=1 WHERE `entry`=219878; -- Skeinspinner Takazj +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=220551; -- Sureki Ironweaver +UPDATE `creature_template` SET `faction`=1812, `BaseAttackTime`=2000, `unit_flags`=33555200, `unit_flags2`=2048, `unit_flags3`=1073741825 WHERE `entry`=229633; -- Ulgrax the Devourer +UPDATE `creature_template` SET `faction`=16, `speed_walk`=2.799999952316284179, `speed_run`=2, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags3`=8388608 WHERE `entry`=215657; -- Ulgrax the Devourer +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33555200, `unit_flags2`=67110912, `unit_flags3`=1090551808, `flags_extra` = 128 WHERE `entry`=224439; -- Web Support +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048, `unit_flags3`=2147483649 WHERE `entry`=231649; -- Ki'katal the Harvester +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=64, `unit_flags2`=2048 WHERE `entry`=218320; -- Web Acolyte +UPDATE `creature_template` SET `faction`=14, `speed_walk`=4, `speed_run`=2.571428537368774414, `BaseAttackTime`=2000, `unit_flags2`=2080, `unit_flags3`=67108864 WHERE `entry`=222235; -- Bloodthirsty Swarmer +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags2`=2080 WHERE `entry`=222193; -- Hollow Frostweaver +UPDATE `creature_template` SET `faction`=190, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=214714; -- Moth +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=64, `unit_flags2`=2048 WHERE `entry`=218306; -- Scarab Captain Vul'akan +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=33555200, `unit_flags2`=2048, `unit_flags3`=1 WHERE `entry`=219776; -- Anub'azal +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=64, `unit_flags2`=2048 WHERE `entry`=218316; -- Kaheti Vanguard +UPDATE `creature_template` SET `faction`=190, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=214720; -- Pill Bug +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=64, `unit_flags2`=2048 WHERE `entry`=218317; -- Woven Threadmancer +UPDATE `creature_template` SET `faction`=35, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags`=33554432, `unit_flags2`=67110912, `unit_flags3`=1090551809 WHERE `entry`=219846; -- Nerubian Alarm +UPDATE `creature_template` SET `faction`=190, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=226697; -- Spider +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=64, `unit_flags2`=2048 WHERE `entry`=218315; -- Kaheti Sentry +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags2`=2080 WHERE `entry`=222214; -- Frenzied Leaper + +DELETE FROM `gameobject_template` WHERE `entry` IN (453146 /*Web*/, 453145 /*Web*/, 453143 /*Web*/, 453142 /*Web*/, 441290 /*11.0 Raid - Nerubian - Boss - Queen - WebWall 5 - SRC*/, 435018 /*Web Spool*/, 441287 /*11.0 Raid - Nerubian - Boss - Queen - WebWall 2 - SRC*/, 435015 /*Web Spool*/, 441291 /*11.0 Raid - Nerubian - Boss - Queen - WebWall 4 - SRC*/, 435019 /*Web Spool*/, 441288 /*11.0 Raid - Nerubian - Boss - Queen - WebWall 1 - SRC*/, 435016 /*Web Spool*/, 435013 /*Web Spool*/, 441292 /*11.0 Raid - Nerubian - Boss - Queen - WebWall 3 - SRC*/, 435020 /*Web Spool*/, 441289 /*11.0 Raid - Nerubian - Boss - Queen - WebWall 6 - SRC*/, 435017 /*Web Spool*/, 435014 /*Web Spool*/, 444013 /*Door*/, 445179 /*11DU_NerubianRaid_Special_WebWall01*/, 452122 /*Barrier*/, 444011 /*Door*/, 444012 /*Door*/, 454747 /*11DU_NerubianRaid_Special_WebWall01*/, 443864 /*Door*/, 443865 /*Door*/, 441734 /*Weapon Rack*/, 441710 /*Door*/, 444779 /*Door*/, 445024 /*Door*/, 453147 /*Web*/, 453144 /*Web*/, 453138 /*Web*/, 453135 /*Web*/, 453134 /*Web*/, 453137 /*Web*/, 453133 /*Web*/, 453141 /*Web*/, 453140 /*Web*/, 453136 /*Web*/, 453139 /*Web*/, 453918 /*Chair*/, 451920 /*Shadecaster*/, 445007 /*Web*/, 437234 /*Web Bridge*/, 437233 /*Web Bridge*/, 437232 /*Web Bridge*/, 437231 /*Web Bridge*/, 437049 /*Web*/, 422811 /*Platform*/); +INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `Data24`, `Data25`, `Data26`, `Data27`, `Data28`, `Data29`, `Data30`, `Data31`, `Data32`, `Data33`, `Data34`, `ContentTuningId`, `VerifiedBuild`) VALUES +(453146, 1, 91180, 'Web', '', '', '', 0.889999985694885253, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web +(453145, 1, 91180, 'Web', '', '', '', 0.800000011920928955, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web +(453143, 1, 91180, 'Web', '', '', '', 0.870000064373016357, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web +(453142, 1, 91180, 'Web', '', '', '', 0.839999973773956298, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web +(441290, 0, 89187, '11.0 Raid - Nerubian - Boss - Queen - WebWall 5 - SRC', '', '', '', 0.999999105930328369, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- 11.0 Raid - Nerubian - Boss - Queen - WebWall 5 - SRC +(435018, 10, 89379, 'Web Spool', '', '', '', 0.999999463558197021, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web Spool +(441287, 0, 89187, '11.0 Raid - Nerubian - Boss - Queen - WebWall 2 - SRC', '', '', '', 0.999999403953552246, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- 11.0 Raid - Nerubian - Boss - Queen - WebWall 2 - SRC +(435015, 10, 89379, 'Web Spool', '', '', '', 0.999999523162841796, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web Spool +(441291, 0, 89187, '11.0 Raid - Nerubian - Boss - Queen - WebWall 4 - SRC', '', '', '', 0.99999934434890747, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- 11.0 Raid - Nerubian - Boss - Queen - WebWall 4 - SRC +(435019, 10, 89379, 'Web Spool', '', '', '', 0.999999523162841796, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web Spool +(441288, 0, 89187, '11.0 Raid - Nerubian - Boss - Queen - WebWall 1 - SRC', '', '', '', 0.999999403953552246, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- 11.0 Raid - Nerubian - Boss - Queen - WebWall 1 - SRC +(435016, 10, 89379, 'Web Spool', '', '', '', 0.999999523162841796, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web Spool +(435013, 10, 89379, 'Web Spool', '', '', '', 0.999999523162841796, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web Spool +(441292, 0, 89187, '11.0 Raid - Nerubian - Boss - Queen - WebWall 3 - SRC', '', '', '', 0.999999165534973144, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- 11.0 Raid - Nerubian - Boss - Queen - WebWall 3 - SRC +(435020, 10, 89379, 'Web Spool', '', '', '', 0.999999582767486572, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web Spool +(441289, 0, 89187, '11.0 Raid - Nerubian - Boss - Queen - WebWall 6 - SRC', '', '', '', 0.999999165534973144, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- 11.0 Raid - Nerubian - Boss - Queen - WebWall 6 - SRC +(435017, 10, 89379, 'Web Spool', '', '', '', 0.999999523162841796, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web Spool +(435014, 10, 89379, 'Web Spool', '', '', '', 0.999999523162841796, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web Spool +(444013, 0, 90851, 'Door', '', '', '', 1.020185232162475585, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Door +(445179, 0, 91161, '11DU_NerubianRaid_Special_WebWall01', '', '', '', 0.661271393299102783, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- 11DU_NerubianRaid_Special_WebWall01 +(452122, 0, 92578, 'Barrier', '', '', '', 0.999999701976776123, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Barrier +(444011, 0, 90850, 'Door', '', '', '', 1.023672103881835937, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Door +(444012, 0, 90851, 'Door', '', '', '', 1.020185589790344238, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Door +(454747, 0, 91161, '11DU_NerubianRaid_Special_WebWall01', '', '', '', 0.804445803165435791, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- 11DU_NerubianRaid_Special_WebWall01 +(443864, 0, 90341, 'Door', '', '', '', 0.785758495330810546, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Door +(443865, 0, 90341, 'Door', '', '', '', 0.78575831651687622, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Door +(441734, 5, 89824, 'Weapon Rack', '', '', '', 2, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Weapon Rack +(441710, 0, 90341, 'Door', '', '', '', 0.695741057395935058, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Door +(444779, 0, 90341, 'Door', '', '', '', 0.579999923706054687, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Door +(445024, 0, 90850, 'Door', '', '', '', 1.023672103881835937, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Door +(453147, 1, 90409, 'Web', '', '', '', 2.359999656677246093, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web +(453144, 1, 91180, 'Web', '', '', '', 0.920000016689300537, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web +(453138, 1, 92300, 'Web', '', '', '', 1.299999952316284179, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web +(453135, 1, 90409, 'Web', '', '', '', 1.629999995231628417, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web +(453134, 1, 90409, 'Web', '', '', '', 2.70000004768371582, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web +(453137, 1, 91180, 'Web', '', '', '', 1.080000042915344238, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web +(453133, 1, 87438, 'Web', '', '', '', 1.120000004768371582, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web +(453141, 1, 85465, 'Web', '', '', '', 1.05000007152557373, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web +(453140, 1, 85465, 'Web', '', '', '', 1.240000009536743164, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web +(453136, 1, 87438, 'Web', '', '', '', 2.779999971389770507, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web +(453139, 1, 87438, 'Web', '', '', '', 1.699999928474426269, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web +(453918, 7, 89574, 'Chair', '', '', '', 0.999999523162841796, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Chair +(451920, 10, 87030, 'Shadecaster', '', '', '', 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Shadecaster +(445007, 35, 89188, 'Web', '', '', '', 0.999999821186065673, 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web +(437234, 35, 89188, 'Web Bridge', '', '', '', 0.999999582767486572, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web Bridge +(437233, 35, 89188, 'Web Bridge', '', '', '', 0.999999582767486572, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web Bridge +(437232, 35, 89188, 'Web Bridge', '', '', '', 0.999999523162841796, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web Bridge +(437231, 35, 89188, 'Web Bridge', '', '', '', 0.999999642372131347, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web Bridge +(437049, 35, 89487, 'Web', '', '', '', 0.999999523162841796, 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513), -- Web +(422811, 33, 87662, 'Platform', '', '', '', 1, 0, 0, 99, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 379, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56513); -- Platform + +-- Model +DELETE FROM `creature_model_info` WHERE `DisplayID` IN (120497, 104797, 118997, 118481, 119005, 117772, 117473, 115748, 115731, 117938, 123899, 122208); +INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES +(120497, 1.5, 2.5, 0, 56513), +(104797, 0.154382199048995971, 1, 0, 56513), +(118997, 0.5, 10, 0, 56513), +(118481, 1.751960515975952148, 2.5, 0, 56513), +(119005, 1.800455808639526367, 3.000000238418579101, 0, 56513), +(117772, 11.80086803436279296, 8, 0, 56513), +(117473, 0.948864400386810302, 1.80000007152557373, 0, 56513), +(115748, 1.534133195877075195, 1.5, 0, 56513), +(115731, 0.5, 10, 0, 56513), +(117938, 1.481522440910339355, 0, 0, 56513), +(123899, 1.101556658744812011, 0, 0, 56513), +(122208, 1.565289497375488281, 1.5, 0, 56513); + +UPDATE `creature_model_info` SET `VerifiedBuild`=56513 WHERE `DisplayID` IN (114530, 115009, 119886, 115733, 116832, 114989, 27823, 114988, 114986, 115735, 115734, 114542, 114408, 114987, 114541, 112383, 107538, 114533, 43223, 114411, 114536); +UPDATE `creature_model_info` SET `BoundingRadius`=0.835285544395446777, `CombatReach`=0.540540575981140136, `VerifiedBuild`=56513 WHERE `DisplayID`=99860; +UPDATE `creature_model_info` SET `BoundingRadius`=0.828504681587219238, `CombatReach`=0.666666626930236816, `VerifiedBuild`=56513 WHERE `DisplayID` IN (117448, 117450, 117449); + +-- Difficulty (Normal) +DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID`=14 AND `Entry` IN (218884,220626,219046,219045,223839,223822,217748,214506,218370,217489,217491,214504,214503,221986,221667,221945,220138,214502,225817,228713,223372,227774,227773,215657,233422)); +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`) VALUES +(218884, 14, 10, 10.5, 1, 279878, 2097224, 128), -- Shattershell Scarab +(220626, 14, 10, 2.299999952316284179, 1, 270615, 0, 128), -- Blood Parasite +(219046, 14, 10, 4.5, 1, 270623, 0, 128), -- Voracious Worm +(219045, 14, 10, 12, 1, 270619, 0, 128), -- Colossal Spider +(223839, 14, 10, 42, 1, 274701, 2097224, 0), -- Queen's Guard Ge'zah +(223822, 14, 10, 42, 1, 274684, 2097224, 0), -- Queen's Guard Re'zah +(217748, 14, 10, 550, 1, 277339, 2097260, 128), -- Nexus-Princess Ky'veza +(214506, 14, 10, 600, 1, 270642, 2097260, 128), -- Broodtwister Ovi'nax +(218370, 14, 10, 520, 1, 277851, 2097260, 128), -- Queen Ansurek +(217489, 14, 10, 892, 1, 282112, 2097260, 128), -- Anub'arash +(217491, 14, 10, 892, 1, 284640, 2097260, 128), -- Skeinspinner Takazj +(214504, 14, 10, 821.8599853515625, 1, 284618, 2097260, 128), -- Rasha'nan +(214503, 14, 10, 495, 1, 275356, 270532716, 128), -- Sikran +(221986, 14, 10, 0.649999976158142089, 1, 280030, 2097224, 128), -- Blood Horror +(221667, 14, 10, 7.40000009536743164, 1, 278998, 2097224, 128), -- Lost Watcher +(221945, 14, 10, 5.5, 1, 274810, 2097224, 128), -- Forgotten Harbinger +(220138, 14, 10, 18, 1, 269747, 2097224, 0), -- Regurgitating Monstrosity +(214502, 14, 10, 460, 1, 279741, 2097260, 128), -- The Bloodbound Horror +(225817, 14, 10, 32, 1, 276791, 2097224, 0), -- Caustic Skyrazor +(228713, 14, 10, 410, 1, 279926, 0, 0), -- Ulgrax the Devourer +(223372, 14, 10, 22, 1, 274195, 2097224, 0), -- Prime Slime +(227774, 14, 10, 1, 1, 278953, 1610612752, 67108870), -- Field Repair Anvil +(227773, 14, 10, 1, 1, 278952, 1610612752, 67108870), -- Travel Duffel +(215657, 14, 10, 420, 1, 284652, 2097260, 128), -- Ulgrax the Devourer +(233422, 14, 10, 1, 1, 285008, 1610612752, 102); -- Nerub-ar Palace + +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=2723, `StaticFlags1`=536871168, `StaticFlags3`=33554432, `VerifiedBuild`=56513 WHERE (`Entry`=224279 AND `DifficultyID`=0); -- 224279 (Shatter Existance Stalker) - Sessile, Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=223876 AND `DifficultyID`=0); -- 223876 (Impaling Spike) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=225863 AND `DifficultyID`=0); -- 225863 (Web Bomb) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=218884 AND `DifficultyID`=14); -- 218884 (Shattershell Scarab) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `VerifiedBuild`=56513 WHERE (`Entry`=220626 AND `DifficultyID`=14); -- 220626 (Blood Parasite) - +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=805306624, `VerifiedBuild`=56513 WHERE (`Entry`=219046 AND `DifficultyID`=14); -- 219046 (Voracious Worm) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=219045 AND `DifficultyID`=14); -- 219045 (Colossal Spider) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags3`=262144, `VerifiedBuild`=56513 WHERE (`Entry`=231032 AND `DifficultyID`=0); -- 231032 (Sanguine Overflow) - AllowInteractionWhileInCombat +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=222145 AND `DifficultyID`=0); -- 222145 (Voracious Stagshell) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `VerifiedBuild`=56513 WHERE (`Entry`=222572 AND `DifficultyID`=0); -- 222572 (Infesting Latcher) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536870912, `StaticFlags3`=262144, `VerifiedBuild`=56513 WHERE (`Entry`=220751 AND `DifficultyID`=0); -- 220751 (Tank Container Stalker) - Floating - AllowInteractionWhileInCombat +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536870912, `StaticFlags3`=262144, `VerifiedBuild`=56513 WHERE (`Entry`=220774 AND `DifficultyID`=0); -- 220774 (Puddle Container Stalker) - Floating - AllowInteractionWhileInCombat +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags3`=262144, `VerifiedBuild`=56513 WHERE (`Entry`=220151 AND `DifficultyID`=0); -- 220151 (Quivering Broodcluster) - AllowInteractionWhileInCombat +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=805306624, `VerifiedBuild`=56513 WHERE (`Entry`=225727 AND `DifficultyID`=0); -- 225727 (Executor Nizrek) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=228470 AND `DifficultyID`=0); -- 228470 (Nexus-Princess Ky'veza) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=2723, `StaticFlags1`=268435456, `StaticFlags3`=33554432, `VerifiedBuild`=56513 WHERE (`Entry`=218265 AND `DifficultyID`=0); -- 218265 (Nether Phantom) - CanSwim - CannotTurn +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=2723, `StaticFlags1`=805306624, `VerifiedBuild`=56513 WHERE (`Entry`=218429 AND `DifficultyID`=0); -- 218429 (Nether Phantom) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2609, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=230877 AND `DifficultyID`=0); -- 230877 (Ky'veza's Burn Book) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=2723, `StaticFlags1`=268435456, `StaticFlags3`=33554432, `VerifiedBuild`=56513 WHERE (`Entry`=218425 AND `DifficultyID`=0); -- 218425 (Nexus-Princess Ky'veza) - CanSwim - CannotTurn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `StaticFlags3`=33554432, `VerifiedBuild`=56513 WHERE (`Entry`=223493 AND `DifficultyID`=0); -- 223493 (Devoted Worshipper) - Sessile, Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=225522 AND `DifficultyID`=0); -- 225522 (Void Portal) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=225519 AND `DifficultyID`=0); -- 225519 (Void Shredder) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435712, `VerifiedBuild`=56513 WHERE (`Entry`=224111 AND `DifficultyID`=0); -- 224111 (Court Attendant) - Sessile, CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=223839 AND `DifficultyID`=14); -- 223839 (Queen's Guard Ge'zah) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=223822 AND `DifficultyID`=14); -- 223822 (Queen's Guard Re'zah) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=217748 AND `DifficultyID`=14); -- 217748 (Nexus-Princess Ky'veza) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags3`=262144, `VerifiedBuild`=56513 WHERE (`Entry`=220149 AND `DifficultyID`=0); -- 220149 (Colossal Egg) - AllowInteractionWhileInCombat +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags3`=262144, `VerifiedBuild`=56513 WHERE (`Entry`=220150 AND `DifficultyID`=0); -- 220150 (Squirming Egg) - AllowInteractionWhileInCombat +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=214506 AND `DifficultyID`=14); -- 214506 (Broodtwister Ovi'nax) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=231580 AND `DifficultyID`=0); -- 231580 (The Crown of Shadows) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `StaticFlags3`=33554432, `VerifiedBuild`=56513 WHERE (`Entry`=228182 AND `DifficultyID`=0); -- 228182 (Sureki Royal Jewel) - CanSwim - CannotTurn +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435712, `VerifiedBuild`=56513 WHERE (`Entry`=224113 AND `DifficultyID`=0); -- 224113 (Royal Weaver) - Sessile, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags3`=262144, `VerifiedBuild`=56513 WHERE (`Entry`=224682 AND `DifficultyID`=0); -- 224682 (Nozzle Stalker) - AllowInteractionWhileInCombat +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536870912, `StaticFlags3`=262144, `VerifiedBuild`=56513 WHERE (`Entry`=223635 AND `DifficultyID`=0); -- 223635 (Puddle Container Movement Stalker) - Floating - AllowInteractionWhileInCombat +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536870912, `StaticFlags3`=262144, `VerifiedBuild`=56513 WHERE (`Entry`=220773 AND `DifficultyID`=0); -- 220773 (Web Container Stalker) - Floating - AllowInteractionWhileInCombat +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `StaticFlags3`=33554432, `VerifiedBuild`=56513 WHERE (`Entry`=228440 AND `DifficultyID`=0); -- 228440 (Web Anchor) - Sessile, Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=2723, `StaticFlags1`=805306368, `VerifiedBuild`=56513 WHERE (`Entry`=218370 AND `DifficultyID`=14); -- 218370 (Queen Ansurek) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `VerifiedBuild`=56513 WHERE (`Entry`=221537 AND `DifficultyID`=0); -- 221537 (Unstable Experiment) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=218261 AND `DifficultyID`=0); -- 218261 (Royal Silkwing) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `StaticFlags3`=33554432, `VerifiedBuild`=56513 WHERE (`Entry`=228080 AND `DifficultyID`=0); -- 228080 (Weaver's Loom) - CanSwim - CannotTurn +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=2723, `VerifiedBuild`=56513 WHERE (`Entry`=217489 AND `DifficultyID`=14); -- 217489 (Anub'arash) - +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=2723, `VerifiedBuild`=56513 WHERE (`Entry`=217491 AND `DifficultyID`=14); -- 217491 (Skeinspinner Takazj) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags3`=262144, `VerifiedBuild`=56513 WHERE (`Entry`=222510 AND `DifficultyID`=0); -- 222510 (Stagshell Egg) - AllowInteractionWhileInCombat +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=222167 AND `DifficultyID`=0); -- 222167 (Brood Infuser) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=536870912, `VerifiedBuild`=56513 WHERE (`Entry`=221669 AND `DifficultyID`=0); -- 221669 (Blight Swarmer) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=81, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=214712 AND `DifficultyID`=0); -- 214712 (Leech) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags3`=262144, `VerifiedBuild`=56513 WHERE (`Entry`=220540 AND `DifficultyID`=0); -- 220540 (Latcher Broodcluster) - AllowInteractionWhileInCombat +UPDATE `creature_template_difficulty` SET `ContentTuningID`=81, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=214713 AND `DifficultyID`=0); -- 214713 (Bloodfeaster) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=81, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=214710 AND `DifficultyID`=0); -- 214710 (Larva) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=805306624, `VerifiedBuild`=56513 WHERE (`Entry`=225764 AND `DifficultyID`=0); -- 225764 (Nerub-ar Palace) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=219904 AND `DifficultyID`=0); -- 219904 (Executor Nizrek) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `StaticFlags3`=33554432, `VerifiedBuild`=56513 WHERE (`Entry`=229217 AND `DifficultyID`=0); -- 229217 (Glyph of Dread) - CanSwim - CannotTurn +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=222368 AND `DifficultyID`=0); -- 222368 (Exalted Priest) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=219724 AND `DifficultyID`=0); -- 219724 (Court Attendant) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=219723 AND `DifficultyID`=0); -- 219723 (Royal Whisperer) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=219739 AND `DifficultyID`=0); -- 219739 (Infested Spawn) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=219669 AND `DifficultyID`=0); -- 219669 (Nerubian) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=536870912, `VerifiedBuild`=56513 WHERE (`Entry`=219711 AND `DifficultyID`=0); -- 219711 (Spinnerette's Strands) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=221538 AND `DifficultyID`=0); -- 221538 (Nerubian) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=2723, `StaticFlags1`=805306368, `VerifiedBuild`=56513 WHERE (`Entry`=214504 AND `DifficultyID`=14); -- 214504 (Rasha'nan) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=224923 AND `DifficultyID`=0); -- 224923 (Nerubian) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=536871168, `StaticFlags3`=33554432, `VerifiedBuild`=56513 WHERE (`Entry`=218439 AND `DifficultyID`=0); -- 218439 (Sureki War Banner) - Sessile, Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=224066 AND `DifficultyID`=0); -- 224066 (Sureki Vanguard) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=805306368, `VerifiedBuild`=56513 WHERE (`Entry`=229918 AND `DifficultyID`=0); -- 229918 (Caustic Skyrazor) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=229402 AND `DifficultyID`=0); -- 229402 (Frostshard Bolts) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=229403 AND `DifficultyID`=0); -- 229403 (Caustic Bolts) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=229401 AND `DifficultyID`=0); -- 229401 (Barbed Bolts) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=229285 AND `DifficultyID`=0); -- 229285 (Nerubian Ballista) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=216982 AND `DifficultyID`=0); -- 216982 (Royal Silkwing) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=218266 AND `DifficultyID`=0); -- 218266 (Royal Silkwing) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=219006 AND `DifficultyID`=0); -- 219006 (Venommaster Nezarox) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=229995 AND `DifficultyID`=0); -- 229995 (Sureki Arbalest) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=227507 AND `DifficultyID`=0); -- 227507 (Sureki Skirmisher) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `StaticFlags3`=33554432, `VerifiedBuild`=56513 WHERE (`Entry`=228321 AND `DifficultyID`=0); -- 228321 (Cosmic Residue) - Sessile, Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `StaticFlags3`=33554432, `VerifiedBuild`=56513 WHERE (`Entry`=223251 AND `DifficultyID`=0); -- 223251 (Spear Stalker (Impact)) - Sessile, Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `StaticFlags3`=33554432, `VerifiedBuild`=56513 WHERE (`Entry`=227617 AND `DifficultyID`=0); -- 227617 (Cosmic Simulacrum) - Sessile, Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `StaticFlags3`=33554432, `VerifiedBuild`=56513 WHERE (`Entry`=224639 AND `DifficultyID`=0); -- 224639 (Surekian Decapitator) - Sessile, Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=218260 AND `DifficultyID`=0); -- 218260 (Royal Silkwing) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=805306368, `VerifiedBuild`=56513 WHERE (`Entry`=227614 AND `DifficultyID`=0); -- 227614 (Royal Silkwing) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=227768 AND `DifficultyID`=0); -- 227768 (Captured Arathi) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=223996 AND `DifficultyID`=0); -- 223996 (Royal Weaver Stalker) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=805306368, `VerifiedBuild`=56513 WHERE (`Entry`=224970 AND `DifficultyID`=0); -- 224970 (Caustic Bomber) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=805306368, `VerifiedBuild`=56513 WHERE (`Entry`=222881 AND `DifficultyID`=0); -- 222881 (Royal Weaver) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=214503 AND `DifficultyID`=14); -- 214503 (Sikran) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `StaticFlags3`=33554432, `VerifiedBuild`=56513 WHERE (`Entry`=222275 AND `DifficultyID`=0); -- 222275 (Training Dummy) - Sessile, Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=222273 AND `DifficultyID`=0); -- 222273 (Sureki Silkbow) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=222038 AND `DifficultyID`=0); -- 222038 (Shrillwing Hunter En'kilah) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=219853 AND `DifficultyID`=0); -- 219853 (Sikran) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `StaticFlags3`=33554432, `VerifiedBuild`=56513 WHERE (`Entry`=228157 AND `DifficultyID`=0); -- 228157 (Nerubian Anvil) - CanSwim - CannotTurn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `StaticFlags3`=33554432, `VerifiedBuild`=56513 WHERE (`Entry`=224610 AND `DifficultyID`=0); -- 224610 (Surekian Weapon Rack) - Sessile, Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=805306368, `VerifiedBuild`=56513 WHERE (`Entry`=222042 AND `DifficultyID`=0); -- 222042 (Shrillwing) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `StaticFlags3`=33554432, `VerifiedBuild`=56513 WHERE (`Entry`=224370 AND `DifficultyID`=0); -- 224370 (Surekian Weapon Rack) - Sessile, Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=222274 AND `DifficultyID`=0); -- 222274 (Sureki Darkblade) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=219725 AND `DifficultyID`=0); -- 219725 (Chitin Knight) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=227170 AND `DifficultyID`=0); -- 227170 (Royal Silkwing) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=805306624, `VerifiedBuild`=56513 WHERE (`Entry`=225394 AND `DifficultyID`=0); -- 225394 (Widow Arak'nai) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=219834 AND `DifficultyID`=0); -- 219834 (Weaver's Eyes) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435712, `VerifiedBuild`=56513 WHERE (`Entry`=219847 AND `DifficultyID`=0); -- 219847 (Kaheti Lord) - Sessile, CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435712, `VerifiedBuild`=56513 WHERE (`Entry`=219845 AND `DifficultyID`=0); -- 219845 (Kaheti Threadmancer) - Sessile, CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435712, `VerifiedBuild`=56513 WHERE (`Entry`=219835 AND `DifficultyID`=0); -- 219835 (Kaheti Sentry) - Sessile, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=229131 AND `DifficultyID`=0); -- 229131 (Royal Silkwing) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `VerifiedBuild`=56513 WHERE (`Entry`=219836 AND `DifficultyID`=0); -- 219836 (Nerubian Blood Pool) - +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=219833 AND `DifficultyID`=0); -- 219833 (Weaver's Fang) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=805306368, `StaticFlags3`=33554432, `VerifiedBuild`=56513 WHERE (`Entry`=227172 AND `DifficultyID`=0); -- 227172 (Royal Silkwing) - CanSwim, Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=219796 AND `DifficultyID`=0); -- 219796 (Widow Arak'nai) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=225335 AND `DifficultyID`=0); -- 225335 (Shifted Oozeling) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=221986 AND `DifficultyID`=14); -- 221986 (Blood Horror) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=805306624, `VerifiedBuild`=56513 WHERE (`Entry`=221945 AND `DifficultyID`=14); -- 221945 (Forgotten Harbinger) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=221667 AND `DifficultyID`=14); -- 221667 (Lost Watcher) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=805306624, `VerifiedBuild`=56513 WHERE (`Entry`=221771 AND `DifficultyID`=0); -- 221771 (Faceless One) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=225208 AND `DifficultyID`=0); -- 225208 (Slime Wave) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=220139 AND `DifficultyID`=0); -- 220139 (Slithering Spew) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=230390 AND `DifficultyID`=0); -- 230390 (The Congealing Pool) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=222581 AND `DifficultyID`=0); -- 222581 (Ruptured Ooze) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=214801 AND `DifficultyID`=0); -- 214801 (Skipper) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=216971 AND `DifficultyID`=0); -- 216971 (Shadow Walker Tarvex) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=221845 AND `DifficultyID`=0); -- 221845 (Xur'khun the Defiled) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=227714 AND `DifficultyID`=0); -- 227714 (The Pulsing Pit) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=222461 AND `DifficultyID`=0); -- 222461 (Congealed Mass) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=2723, `StaticFlags1`=805306624, `VerifiedBuild`=56513 WHERE (`Entry`=214502 AND `DifficultyID`=14); -- 214502 (The Bloodbound Horror) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=229399 AND `DifficultyID`=0); -- 229399 (Blood Drainer) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=229614 AND `DifficultyID`=0); -- 229614 (Caustic Skyrazor) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `StaticFlags3`=33554432, `VerifiedBuild`=56513 WHERE (`Entry`=228195 AND `DifficultyID`=0); -- 228195 (Strange Mushroom) - CanSwim - CannotTurn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `StaticFlags3`=33554432, `VerifiedBuild`=56513 WHERE (`Entry`=229208 AND `DifficultyID`=0); -- 229208 (Unstable Mixture) - CanSwim - CannotTurn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=222455 AND `DifficultyID`=0); -- 222455 (Black Blood Harvester) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `VerifiedBuild`=56513 WHERE (`Entry`=221035 AND `DifficultyID`=0); -- 221035 (Royal Scribe) - +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=222213 AND `DifficultyID`=0); -- 222213 (Lurking Marauder) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=225817 AND `DifficultyID`=14); -- 225817 (Caustic Skyrazor) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=223200 AND `DifficultyID`=0); -- 223200 (Blood Collector) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=805306368, `StaticFlags3`=33554432, `VerifiedBuild`=56513 WHERE (`Entry`=228033 AND `DifficultyID`=0); -- 228033 (Coalesced Shadow) - CanSwim, Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=223199 AND `DifficultyID`=0); -- 223199 (Black Blood Pool) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=215435 AND `DifficultyID`=0); -- 215435 (Foreseer Xix'amon) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `StaticFlags3`=33554432, `VerifiedBuild`=56513 WHERE (`Entry`=228076 AND `DifficultyID`=0); -- 228076 (Caustic Bomb) - CanSwim - CannotTurn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=81, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=214820 AND `DifficultyID`=0); -- 214820 (Black Blood Droplet) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=222786 AND `DifficultyID`=0); -- 222786 (Parasitic Worm) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=222459 AND `DifficultyID`=0); -- 222459 (Congealing Mass) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=216977 AND `DifficultyID`=0); -- 216977 (Royal Silkwing) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=222564 AND `DifficultyID`=0); -- 222564 (Rupturing Ooze) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=223207 AND `DifficultyID`=0); -- 223207 (Black Blood) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=2723, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=219038 AND `DifficultyID`=0); -- 219038 (Chunky Viscera) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `VerifiedBuild`=56513 WHERE (`Entry`=216205 AND `DifficultyID`=0); -- 216205 (Ravenous Spawn) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=221388 AND `DifficultyID`=0); -- 221388 (Ping Stalker) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=218018 AND `DifficultyID`=0); -- 218018 (Ping Stalker) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `StaticFlags3`=33554432, `VerifiedBuild`=56513 WHERE (`Entry`=223790 AND `DifficultyID`=0); -- 223790 (Ravenous Spawn Stalker) - Sessile, Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=222001 AND `DifficultyID`=0); -- 222001 (Hulking Crash Stalker) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=2723, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=228713 AND `DifficultyID`=14); -- 228713 (Ulgrax the Devourer) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=223449 AND `DifficultyID`=0); -- 223449 (The Swaying Span) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=222305 AND `DifficultyID`=0); -- 222305 (Palace Guardian) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=223372 AND `DifficultyID`=14); -- 223372 (Prime Slime) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=81, `StaticFlags1`=805306368, `VerifiedBuild`=56513 WHERE (`Entry`=214711 AND `DifficultyID`=0); -- 214711 (Glowmite) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=227715 AND `DifficultyID`=0); -- 227715 (The Swaying Span) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=216663 AND `DifficultyID`=0); -- 216663 (The Bloodfeaster) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=536871168, `StaticFlags3`=33554432, `VerifiedBuild`=56513 WHERE (`Entry`=218440 AND `DifficultyID`=0); -- 218440 (Kaheti War Banner) - Sessile, Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=229396 AND `DifficultyID`=0); -- 229396 (Volatile Black Blood Pool) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=223373 AND `DifficultyID`=0); -- 223373 (Slime Wave) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=220138 AND `DifficultyID`=14); -- 220138 (Regurgitating Monstrosity) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=2723, `StaticFlags1`=805306368, `VerifiedBuild`=56513 WHERE (`Entry`=224437 AND `DifficultyID`=0); -- 224437 (Rasha'nan) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=219778 AND `DifficultyID`=0); -- 219778 (Queen Ansurek) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=215657 AND `DifficultyID`=14); -- 215657 (Ulgrax the Devourer) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=219878 AND `DifficultyID`=0); -- 219878 (Skeinspinner Takazj) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=219877 AND `DifficultyID`=0); -- 219877 (Anub'arash) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=81, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=223987 AND `DifficultyID`=0); -- 223987 (BlackBlood Fall Base) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=225880 AND `DifficultyID`=0); -- 225880 (Spider Silk Grub) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=220551 AND `DifficultyID`=0); -- 220551 (Sureki Ironweaver) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=231649 AND `DifficultyID`=0); -- 231649 (Ki'katal the Harvester) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=218316 AND `DifficultyID`=0); -- 218316 (Kaheti Vanguard) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=181, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=229633 AND `DifficultyID`=0); -- 229633 (Ulgrax the Devourer) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=222193 AND `DifficultyID`=0); -- 222193 (Hollow Frostweaver) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=218320 AND `DifficultyID`=0); -- 218320 (Web Acolyte) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=805306368, `VerifiedBuild`=56513 WHERE (`Entry`=222235 AND `DifficultyID`=0); -- 222235 (Bloodthirsty Swarmer) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=224439 AND `DifficultyID`=0); -- 224439 (Web Support) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=81, `StaticFlags1`=805306368, `VerifiedBuild`=56513 WHERE (`Entry`=214714 AND `DifficultyID`=0); -- 214714 (Moth) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=482, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=225409 AND `DifficultyID`=0); -- 225409 (Surging Totem) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=218315 AND `DifficultyID`=0); -- 218315 (Kaheti Sentry) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=805306624, `StaticFlags3`=262144, `VerifiedBuild`=56513 WHERE (`Entry`=219846 AND `DifficultyID`=0); -- 219846 (Nerubian Alarm) - Sessile, CanSwim, Floating - AllowInteractionWhileInCombat +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=222214 AND `DifficultyID`=0); -- 222214 (Frenzied Leaper) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=805306624, `VerifiedBuild`=56513 WHERE (`Entry`=233422 AND `DifficultyID`=14); -- 233422 (Nerub-ar Palace) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=81, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=214720 AND `DifficultyID`=0); -- 214720 (Pill Bug) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `StaticFlags1`=536871168, `StaticFlags3`=33554432, `VerifiedBuild`=56513 WHERE (`Entry`=218447 AND `DifficultyID`=0); -- 218447 (Web Cocoon) - Sessile, Floating - CannotTurn +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=218306 AND `DifficultyID`=0); -- 218306 (Scarab Captain Vul'akan) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=226100 AND `DifficultyID`=0); -- 226100 (Kaheti Skirmisher) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=81, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=226697 AND `DifficultyID`=0); -- 226697 (Spider) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=482, `StaticFlags1`=536871168, `VerifiedBuild`=56513 WHERE (`Entry`=223453 AND `DifficultyID`=0); -- 223453 (Arcane Phoenix) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=482, `VerifiedBuild`=56513 WHERE (`Entry`=221177 AND `DifficultyID`=0); -- 221177 (Ancestor) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=482, `VerifiedBuild`=56513 WHERE (`Entry`=77942 AND `DifficultyID`=0); -- 77942 (Primal Storm Elemental) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2723, `VerifiedBuild`=56513 WHERE (`Entry`=219776 AND `DifficultyID`=0); -- 219776 (Anub'azal) - +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=2723, `StaticFlags1`=805306624, `VerifiedBuild`=56513 WHERE (`Entry`=225184 AND `DifficultyID`=0); -- 225184 (Anub'azal) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=371, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=222339 AND `DifficultyID`=0); -- 222339 (Spinner) - CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=2723, `StaticFlags1`=268435456, `VerifiedBuild`=56513 WHERE (`Entry`=218317 AND `DifficultyID`=0); -- 218317 (Woven Threadmancer) - CanSwim |