diff options
| author | Meji <alvaro.megias@outlook.com> | 2024-06-03 21:22:53 +0200 |
|---|---|---|
| committer | Meji <alvaro.megias@outlook.com> | 2024-06-03 21:22:53 +0200 |
| commit | 6dab3c4c19bad10b9f6f9938a67892d529e3e3be (patch) | |
| tree | 4dafe0d3732e5cd7a9afddfa01b80bbd5b5a50ab | |
| parent | 596dd26150d1af8822e2c58fb297790ec9417f12 (diff) | |
DB/BoreanTundra: Update templates and difficulties
| -rw-r--r-- | sql/updates/world/master/2024_06_03_01_world.sql | 733 |
1 files changed, 733 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_06_03_01_world.sql b/sql/updates/world/master/2024_06_03_01_world.sql new file mode 100644 index 00000000000..8e37c93b1f1 --- /dev/null +++ b/sql/updates/world/master/2024_06_03_01_world.sql @@ -0,0 +1,733 @@ +-- Creature templates +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=32548; -- Corastrasza +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.142857193946838378, `unit_flags`=0 WHERE `entry`=25716; -- General Cerulean +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.142857193946838378, `unit_flags`=0 WHERE `entry`=25717; -- Coldarra Scalesworn +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=26265; -- Saragosa's End Invisman +UPDATE `creature_template` SET `speed_run`=1.142857193946838378, `unit_flags2`=2048 WHERE `entry`=33087; -- Signal Fire Invisman +UPDATE `creature_template` SET `speed_run`=1.142857193946838378, `unit_flags`=0 WHERE `entry`=25712; -- Warbringer Goredrak +UPDATE `creature_template` SET `unit_flags3`=67108864 WHERE `entry`=25721; -- Arcane Serpent +UPDATE `creature_template` SET `BaseAttackTime`=3000, `unit_flags`=64 WHERE `entry`=32357; -- Old Crystalbark +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=26127; -- Nexus Drake Hatchling +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=28960; -- Totally Generic Bunny (JSB) +UPDATE `creature_template` SET `speed_walk`=5.599999904632568359, `speed_run`=2, `unit_flags2`=2048 WHERE `entry`=32534; -- Scalesworn Elite +UPDATE `creature_template` SET `unit_flags3`=67108864 WHERE `entry`=25711; -- Spirit of the North +UPDATE `creature_template` SET `unit_flags3`=8388608 WHERE `entry`=27906; -- Warmage Hollister +UPDATE `creature_template` SET `unit_flags3`=8388608 WHERE `entry`=27904; -- Warmage Watkins +UPDATE `creature_template` SET `unit_flags3`=8388608 WHERE `entry`=27173; -- Warmage Calandra +UPDATE `creature_template` SET `npcflag`=131 WHERE `entry`=26110; -- Librarian Serrah +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=26175; -- Coldarra - Drake Hunt Invisman +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=26117; -- Raelorasz +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=45396; -- Dave's Industrial Light and Magic Bunny (Medium)(Sessile)(Large AOI) +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=24770; -- Nexus Watcher +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=26373; -- Coldarra Spell FX InvisMan +UPDATE `creature_template` SET `unit_flags3`=67108864 WHERE `entry`=25718; -- Coldarra Mage Slayer +UPDATE `creature_template` SET `unit_flags2`=2048, `unit_flags3`=0 WHERE `entry`=27610; -- Dead Caribou +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=26219; -- Iruk +UPDATE `creature_template` SET `npcflag`=1, `unit_flags3`=8388608 WHERE `entry`=27189; -- Unu'pe Spearman +UPDATE `creature_template` SET `npcflag`=1 WHERE `entry`=29965; -- Unu'pe Turtle Rider +UPDATE `creature_template` SET `unit_flags`=256, `unit_flags2`=2048, `unit_flags3`=0 WHERE `entry`=26172; -- Slain Cultist +UPDATE `creature_template` SET `speed_run`=1.142857193946838378, `unit_flags3`=402653184 WHERE `entry`=32361; -- Icehorn +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25473; -- Temple C +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25472; -- Temple B +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25493; -- West En'kilah Cauldron +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25492; -- Central En'kilah Cauldron +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25471; -- Temple A +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25490; -- East En'kilah Cauldron +UPDATE `creature_template` SET `speed_walk`=1, `BaseAttackTime`=250 WHERE `entry`=25390; -- En'kilah Hatchling +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=26093; -- Naxxanar Target +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25386; -- En'kilah Crypt Fiend +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25601; -- Prince Valanar +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=26094; -- Naxxanar Caster +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25383; -- En'kilah Abomination +UPDATE `creature_template` SET `unit_flags2`=2048, `unit_flags3`=67108864 WHERE `entry`=26174; -- Carrion Condor +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25387; -- En'kilah Gargoyle +UPDATE `creature_template` SET `unit_flags3`=134217728 WHERE `entry`=25454; -- Tundra Crawler +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=25615; -- Plagued Magnataur +UPDATE `creature_template` SET `unit_flags3`=67108864 WHERE `entry`=25452; -- Scourged Mammoth +UPDATE `creature_template` SET `unit_flags`=0, `unit_flags2`=2048, `unit_flags3`=0 WHERE `entry`=26160; -- Taunka'le Pack Kodo +UPDATE `creature_template` SET `unit_flags`=0, `unit_flags2`=2048, `unit_flags3`=0 WHERE `entry`=26159; -- Taunka'le Evacuee +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=26041; -- Lightning Target +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=26266; -- Heigarr the Horrible +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25762; -- Vrykul Landing Ship +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25760; -- Kvaldir Raider +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25764; -- Kaskala Defender +UPDATE `creature_template` SET `unit_flags2`=2048, `unit_flags3`=0 WHERE `entry`=25984; -- Crashed Recon Pilot +UPDATE `creature_template` SET `faction`=21, `unit_flags`=33554432, `unit_flags2`=2080, `unit_flags3`=1 WHERE `entry`=27999; -- Rock Shield Trigger (Borean Tundra) +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25664; -- South Sinkhole +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25665; -- Northeast Sinkhole +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25666; -- Northwest Sinkhole +UPDATE `creature_template` SET `faction`=21 WHERE `entry`=25660; -- Festering Ghoul +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=32544; -- Steam Cloud +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=25427; -- Kaganishu +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=25430; -- Magmothregar +UPDATE `creature_template` SET `unit_flags3`=0 WHERE `entry`=21757; -- Big Electromental Flavor +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=25434; -- Magmoth Crusher +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=25429; -- Magmoth Forager +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=25432; -- Mate of Magmothregar +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=25433; -- Offspring of Magmothregar +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=25428; -- Magmoth Shaman +UPDATE `creature_template` SET `unit_flags3`=8388608 WHERE `entry`=27073; -- Bor'gorok Battleguard +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=25226; -- Scalder +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25847; -- East Crash +UPDATE `creature_template` SET `unit_flags3`=67108864 WHERE `entry`=25862; -- Khu'nok the Behemoth +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25845; -- Northwest Crash +UPDATE `creature_template` SET `unit_flags`=33554432, `unit_flags2`=2048 WHERE `entry`=25781; -- Oil Pool +UPDATE `creature_template` SET `unit_flags3`=524288 WHERE `entry`=26817; -- Fizzcrank Fighter +UPDATE `creature_template` SET `speed_run`=3.428571462631225585, `unit_flags2`=2048 WHERE `entry`=25765; -- Fizzcrank Bomber +UPDATE `creature_template` SET `unit_flags2`=2048, `unit_flags3`=67108864 WHERE `entry`=25750; -- Oil-soaked Caribou +UPDATE `creature_template` SET `unit_flags2`=2048, `unit_flags3`=67108864 WHERE `entry`=25748; -- Oil-covered Hawk +UPDATE `creature_template` SET `unit_flags2`=2048, `unit_flags3`=67108864 WHERE `entry`=25817; -- Oiled Fledgeling +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=25418; -- Churn +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=25419; -- Boiling Spirit +UPDATE `creature_template` SET `npcflag`=0, `unit_flags2`=2048, `unit_flags3`=1 WHERE `entry`=25384; -- Steeljaw's Corpse +UPDATE `creature_template` SET `unit_flags2`=2048, `unit_flags3`=1 WHERE `entry`=25343; -- Dead Caravan Worker +UPDATE `creature_template` SET `unit_flags2`=2048, `unit_flags3`=1 WHERE `entry`=25342; -- Dead Caravan Guard +UPDATE `creature_template` SET `unit_flags`=768, `unit_flags2`=2048, `unit_flags3`=0 WHERE `entry`=25841; -- Fizzcrank Recon Pilot +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25846; -- South Crash +UPDATE `creature_template` SET `unit_flags2`=2048, `unit_flags3`=67108864 WHERE `entry`=25791; -- Oil-stained Wolf +UPDATE `creature_template` SET `unit_flags3`=67108864 WHERE `entry`=25355; -- Beryl Hound +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25431; -- Kaskala Ancestor +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=24862; -- Mage Hunter Target +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=24795; -- Surristrasz +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25364; -- Red Guardian Drake +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25724; -- Ascended Mage Hunter +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25594; -- Beryl Point InvisMan +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=54242; -- Borean Beam Target +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25732; -- Warmage Preston +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25727; -- Warmage Moran +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=36155; -- Anzim Controller Bunny +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25356; -- Warmage Anzim +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=27888; -- Warmage Archus +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25733; -- Warmage Austin +UPDATE `creature_template` SET `unit_flags3`=268435456 WHERE `entry`=25968; -- "Lunchbox" +UPDATE `creature_template` SET `unit_flags3`=524288 WHERE `entry`=25801; -- Nedar, Lord of Rhinos +UPDATE `creature_template` SET `unit_flags3`=67108864 WHERE `entry`=24614; -- Wooly Mammoth +UPDATE `creature_template` SET `unit_flags3`=67108864 WHERE `entry`=25743; -- Wooly Mammoth Bull +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25385; -- William Allerton +UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=25650; -- Plagued Scavenger +UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=26083; -- Gerald Green +UPDATE `creature_template` SET `BaseAttackTime`=2000 WHERE `entry`=25843; -- Northsea Thug +UPDATE `creature_template` SET `npcflag`=80 WHERE `entry`=26992; -- Brynna Wilson +UPDATE `creature_template` SET `unit_flags`=33554432 WHERE `entry`=27365; -- Stabled Horse +UPDATE `creature_template` SET `unit_flags3`=524288 WHERE `entry`=25220; -- Civilian Recruit +UPDATE `creature_template` SET `unit_flags3`=524288 WHERE `entry`=25313; -- Valiance Keep Footman +UPDATE `creature_template` SET `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=24580; -- Riplash Siren +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=26451; -- Ragnar Drakkarlund +UPDATE `creature_template` SET `speed_run`=1.142857193946838378, `unit_flags3`=268435456 WHERE `entry`=26452; -- Leviroth +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=25450; -- Veehja +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=24662; -- Riplash Sorceress +UPDATE `creature_template` SET `faction`=1692, `unit_flags2`=2048 WHERE `entry`=24576; -- Riplash Myrmidon +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=26449; -- Gamel the Cruel +UPDATE `creature_template` SET `unit_flags3`=335544320 WHERE `entry`=25498; -- Aspatha the Broodmother +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25797; -- Bloodmage Alkor +UPDATE `creature_template` SET `unit_flags3`=67108864 WHERE `entry`=25680; -- Marsh Caribou +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=25789; -- Gammothra the Tormentor +UPDATE `creature_template` SET `unit_flags3`=67108864 WHERE `entry`=25464; -- Bloodspore Moth +UPDATE `creature_template` SET `unit_flags3`=335544320 WHERE `entry`=25774; -- Rockfang +UPDATE `creature_template` SET `unit_flags3`=67108864 WHERE `entry`=25675; -- Tundra Wolf +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25465; -- Kel'Thuzad +UPDATE `creature_template` SET `unit_flags3`=524288 WHERE `entry`=25466; -- Necropolis Beam (Target) +UPDATE `creature_template` SET `speed_walk`=1, `unit_flags3`=524288 WHERE `entry`=25469; -- Mindless Aberration +UPDATE `creature_template` SET `faction`=1989, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=208182; -- Crazed Looter +UPDATE `creature_template` SET `unit_flags3`=67108864 WHERE `entry`=25481; -- Landing Crawler +UPDATE `creature_template` SET `unit_flags3`=67108864 WHERE `entry`=25482; -- Sand Turtle +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25334; -- Horde Siege Tank +UPDATE `creature_template` SET `unit_flags2`=2048, `unit_flags3`=1 WHERE `entry`=28150; -- Destroyed Siege Tank +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=27064; -- Abandoned Fuel Tank +UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=25349; -- Scourge Plague Spreader +UPDATE `creature_template` SET `unit_flags3`=524288 WHERE `entry`=25625; -- Warsong Aberration +UPDATE `creature_template` SET `faction`=14, `unit_flags`=832, `unit_flags2`=2048 WHERE `entry`=25618; -- Varidus the Flenser +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=24771; -- Coldarra Invisman +UPDATE `creature_template` SET `unit_flags3`=134217728 WHERE `entry`=25489; -- Wooly Rhino Bull +UPDATE `creature_template` SET `unit_flags3`=134217728 WHERE `entry`=25487; -- Wooly Rhino Matriarch +UPDATE `creature_template` SET `unit_flags`=768, `unit_flags2`=2048, `unit_flags3`=0 WHERE `entry`=25328; -- Shadowstalker Luther +UPDATE `creature_template` SET `unit_flags`=0, `unit_flags2`=2048, `unit_flags3`=134217728 WHERE `entry`=25488; -- Wooly Rhino Calf +UPDATE `creature_template` SET `unit_flags3`=67108864 WHERE `entry`=25362; -- Warsong Swine +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25289; -- Wind Master To'bor +UPDATE `creature_template` SET `unit_flags`=33555200 WHERE `entry`=25075; -- Zeppelin Controls +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=25286; -- Warsong Wind Rider +UPDATE `creature_template` SET `unit_flags3`=8388608 WHERE `entry`=31726; -- Grunt Gritch +UPDATE `creature_template` SET `unit_flags3`=8388608 WHERE `entry`=31727; -- Grunt Grikee +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=32520; -- Totally Generic Bunny (All Phase) +UPDATE `creature_template` SET `unit_flags`=256 WHERE `entry`=32647; -- Warsong Hold Practice Dummy + +DELETE FROM `creature_template_addon` WHERE `entry` IN (68845, 71163, 54242); +INSERT INTO `creature_template_addon` (`entry`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(68845, 0, 0, 0, 2, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 68845 (Nexus Whelpling) +(71163, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 0, '142256'), -- 71163 (Unborn Val'kyr) - Unborn Val'kyr +(54242, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, ''); -- 54242 (Borean Beam Target) + +UPDATE `creature_template_addon` SET `visibilityDistanceType`=3 WHERE `entry`=45396; -- 45396 (Dave's Industrial Light and Magic Bunny (Medium)(Sessile)(Large AOI)) +UPDATE `creature_template_addon` SET `AnimTier`=3, `auras`='36630' WHERE `entry`=24770; -- 24770 (Nexus Watcher) - Resistances + +DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (68845); +INSERT INTO `creature_template_movement` (`CreatureId`,`HoverInitiallyEnabled`,`Chase`,`Random`,`InteractionPauseTimer`) VALUES +(68845,1,0,0,NULL); + +-- Difficulties +UPDATE `creature_template_difficulty` ctd +LEFT JOIN `creature_template_difficulty` ctd2 ON ctd.`Entry`=ctd2.`Entry` +SET + ctd.`DamageModifier`=ctd2.`DamageModifier`, + ctd.`LootID`=ctd2.`LootID`, + ctd.`PickPocketLootID`=ctd2.`PickPocketLootID`, + ctd.`SkinLootID`=ctd2.`SkinLootID`, + ctd.`GoldMin`=ctd2.`GoldMin`, + ctd.`GoldMax`=ctd2.`GoldMax` +WHERE ctd.`Entry` IN (25434,25416,25429,25432,25433,25428,25444,26848,25326,25736,27074,27065,27058,25339,25455,27069,27067,27063,25374,27073,26112,25376,25199,34381,25211,25205,25415,25203,25209,25208,28375,25210,24288,25309,25216,25201,25217,25206,25226,25197,25847,25845,25781,25780,26602,26600,26817,26645,26601,26804,25881,25748,25817,25417,25418,25204,25419,25198,25215,25336,25338,25335,25308,25384,25343,25802,25880,25351,25342,25350,25441,25443,25841,25846,25810,25812,25809,25819,25811,25808,25292,25442,25321,25322,25448,25355,25353,25449,25431,24862,27271,27301,27298,27147,27138,27139,27137,27143,25480,27291,27302,27300,27299,27142,27140,27141,25262,25291,24795,25364,25584,25316,25585,54242,25732,25727,36155,25356,27888,25733,25801,25995,25804,25806,25838,25687,25686,25385,25803,25981,26161,26084,26083,26085,25839,25843,25617,24637,25800,27393,25281,25282,25297,25826,25248,27011,26999,25239,25235,32564,25240,26992,25238,25241,26988,25302,25271,25827,25251,26879,24357,27010,25245,29158,25737,25219,26989,27364,27365,27012,26991,26987,26994,26993,25301,25250,25285,26990,27385,27000,27001,26998,26997,26995,25828,25300,25317,25220,26155,29617,26249,26248,25264,25253,25306,25311,24042,25313,24580,26451,25523,25520,26452,25450,24662,24576,26449,25613,25522,25636,25521,25435,25498,25797,25501,25380,25381,25440,25836,25979,25789,24567,24469,25464,25774,25332,25675,25465,25466,25469,25513,208182,28440,25310,25510,25511,25512,25479,25496,25504,25475,25503,25481,25329,25482,25476,25334,27107,27110,25333,28150,27064,27106,27108,25349,25669,25671,25625,25618,25624,24771,25655,25672,25489,25487,25421,25414,25607,25438,25439,25437,25426,25379,25327,25279,25403,25394,25446,25402,25288,25328,25404,25488,25405,25361,25280,32565,27440,27441,25289,32474,25075,25247,25237,26044,25278,25274,25272,25269,26109,25978,26078,25273,25284,25286,31726,31727,25256,25277,26945,26974,26975,26972,29155,26968,26969,29233,26982,26980,26981,26976,26977,32647,25242,25459,25275,25244,26941,26938,25276,25243,31790,31788,31789,31793,31791,31792,25650,25623,26549,25307,25222,35133,35131,47576,25816,25825,25468,61158,25467,60761,25611,25600,25609,25610,24562,25294,26538,27432,47577,35135,35132,31724,31725,31723,31720,24566,25684,25983,26158,25602,26847,26159,25982,26157,26104,26048,26041,25700,25701,25699,25786,26790,26266,25760,25764,25685,25984,25807,27999,26766,26768,26767,25665,25666,25622,24957,25670,25660,26126,19871,25814,25425,25427,25430,25589,21757,25477,25702,26619,26598,25747,25590,26599,26596,26597,25767,26634,27566,27187,27186,27189,29965,25514,71163,26172,25715,26162,32361,25668,27860,25422,26073,25473,26115,25392,25516,25534,25472,26076,25493,25492,25471,25391,27859,25378,25490,25390,26093,25377,26094,25393,25725,25604,25606,25454,25705,25615,25452,25682,25658,25678,25714,25713,25721,32357,26127,28960,32534,25711,27906,27904,30051,25314,27173,27046,26110,26175,26117,25709,25728,45396,24770,25722,25707,26373,25719,25718,27529,27569,27494,27193,27610,31805,26556,31807,27195,27190,26403,26218,28382,26219,26169,26213,27194,25720,32548,25716,25717,29655,26265,33087,25712,27306,68845,28195,129141,26186,26187,26191,26189,26173,26185,26171,26202,26170,25396,26103,25386,25601,25383,26174,25387,26725,24730,26996,26160,25849,24709,26697,26709,26720,26721,24706,24703,26986,24733,26718,24702,25726,25762,25664,25652,24563,25619,25739,24601,25677,25758,32544,25752,25753,24021,23837,25792,25793,25862,62697,25766,25765,25750,25791,18955,25724,25594,25968,25850,24614,24613,25743,62693,25986,26252,25679,29328,26098,25249,18376,18375,24959,15214,25298,25299,385,25395,25605,25234,25651,25228,25582,24921,25227,25829,25680,25470,62695,25596,31685,25362,26047,25445,18380,18378,18379,32520,26043) +AND ctd.`DifficultyID`=0 AND ctd2.`DifficultyID`=1 AND ctd2.`Entry` IS NOT NULL; + +DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID` IN (1,2,4,5,12,14) AND `Entry` IN (25434,25416,25429,25432,25433,25428,25444,26848,25326,25736,27074,27065,27058,25339,25455,27069,27067,27063,25374,27073,26112,25376,25199,34381,25211,25205,25415,25203,25209,25208,28375,25210,24288,25309,25216,25201,25217,25206,25226,25197,25847,25845,25781,25780,26602,26600,26817,26645,26601,26804,25881,25748,25817,25417,25418,25204,25419,25198,25215,25336,25338,25335,25308,25384,25343,25802,25880,25351,25342,25350,25441,25443,25841,25846,25810,25812,25809,25819,25811,25808,25292,25442,25321,25322,25448,25355,25353,25449,25431,24862,27271,27301,27298,27147,27138,27139,27137,27143,25480,27291,27302,27300,27299,27142,27140,27141,25262,25291,24795,25364,25584,25316,25585,54242,25732,25727,36155,25356,27888,25733,25801,25995,25804,25806,25838,25687,25686,25385,25803,25981,26161,26084,26083,26085,25839,25843,25617,24637,25800,27393,25281,25282,25297,25826,25248,27011,26999,25239,25235,32564,25240,26992,25238,25241,26988,25302,25271,25827,25251,26879,24357,27010,25245,29158,25737,25219,26989,27364,27365,27012,26991,26987,26994,26993,25301,25250,25285,26990,27385,27000,27001,26998,26997,26995,25828,25300,25317,25220,26155,29617,26249,26248,25264,25253,25306,25311,24042,25313,24580,26451,25523,25520,26452,25450,24662,24576,26449,25613,25522,25636,25521,25435,25498,25797,25501,25380,25381,25440,25836,25979,25789,24567,24469,25464,25774,25332,25675,25465,25466,25469,25513,208182,28440,25310,25510,25511,25512,25479,25496,25504,25475,25503,25481,25329,25482,25476,25334,27107,27110,25333,28150,27064,27106,27108,25349,25669,25671,25625,25618,25624,24771,25655,25672,25489,25487,25421,25414,25607,25438,25439,25437,25426,25379,25327,25279,25403,25394,25446,25402,25288,25328,25404,25488,25405,25361,25280,32565,27440,27441,25289,32474,25075,25247,25237,26044,25278,25274,25272,25269,26109,25978,26078,25273,25284,25286,31726,31727,25256,25277,26945,26974,26975,26972,29155,26968,26969,29233,26982,26980,26981,26976,26977,32647,25242,25459,25275,25244,26941,26938,25276,25243,31790,31788,31789,31793,31791,31792,25650,25623,26549,25307,25222,35133,35131,47576,25816,25825,25468,61158,25467,60761,25611,25600,25609,25610,24562,25294,26538,27432,47577,35135,35132,31724,31725,31723,31720,24566,25684,25983,26158,25602,26847,26159,25982,26157,26104,26048,26041,25700,25701,25699,25786,26790,26266,25760,25764,25685,25984,25807,27999,26766,26768,26767,25665,25666,25622,24957,25670,25660,26126,19871,25814,25425,25427,25430,25589,21757,25477,25702,26619,26598,25747,25590,26599,26596,26597,25767,26634,27566,27187,27186,27189,29965,25514,71163,26172,25715,26162,32361,25668,27860,25422,26073,25473,26115,25392,25516,25534,25472,26076,25493,25492,25471,25391,27859,25378,25490,25390,26093,25377,26094,25393,25725,25604,25606,25454,25705,25615,25452,25682,25658,25678,25714,25713,25721,32357,26127,28960,32534,25711,27906,27904,30051,25314,27173,27046,26110,26175,26117,25709,25728,45396,24770,25722,25707,26373,25719,25718,27529,27569,27494,27193,27610,31805,26556,31807,27195,27190,26403,26218,28382,26219,26169,26213,27194,155076,25720,32548,25716,25717,29655,26265,33087,25712,27306,68845,28195,129141,26186,26187,26191,26189,26173,26185,26171,26202,26170,25396,26103,25386,25601,25383,26174,25387,26725,24730,26996,26160,25849,24709,26697,26709,26720,26721,24706,24703,26986,24733,26718,24702,25726,25762,25664,25652,24563,25619,25739,24601,25677,25758,32544,25752,25753,24021,23837,25792,25793,25862,62697,25766,25765,25750,25791,18955,25724,25594,25968,25850,24614,24613,25743,62693,25986,26252,25679,29328,26098,25249,18376,18375,24959,15214,25298,25299,385,25395,25605,25234,25651,25228,25582,24921,25227,25829,25680,25470,62695,25596,31685,25362,26047,25445,18380,18378,18379,32520,26043)); + +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=54847 WHERE (`DifficultyID`=0 AND `Entry` IN (27306,68845,28195,129141,26186,26187,26191,26189,26173,26185,26171,26202,26170,25396,26103,25386,25601,25383,26174,25387,26725,24730,26996,26160,25849,24709,26697,26709,26720,26721,24706,24703,26986,24733,26718,24702,25726,25762,25664,25652,24563,25619,25739,24601,25677,25758,32544,25752,25753,24021,23837,25792,25793,25862,62697,25766,25765,25750,25791,18955,25724,25594,25968,25850,24614,24613,25743,62693,25986,26252,25679,29328,26098,25249,18376,18375,24959,15214,25298,25299,385,25395,25605,25234,25651,25228,25582,24921,25227,25829,25680,25470,62695,25596,31685,25362,26047,25445,18380,18378,18379,32520,26043)); +UPDATE `creature_template_difficulty` SET `ContentTuningID`=740, `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=155076 AND `DifficultyID`=0); -- 155076 (Spell Bunny) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25720 AND `DifficultyID`=0); -- 25720 (Inquisitor Caleras) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=32548 AND `DifficultyID`=0); -- 32548 (Corastrasza) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25716 AND `DifficultyID`=0); -- 25716 (General Cerulean) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25717 AND `DifficultyID`=0); -- 25717 (Coldarra Scalesworn) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=29655 AND `DifficultyID`=0); -- 29655 (Malygos) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=26265 AND `DifficultyID`=0); -- 26265 (Saragosa's End Invisman) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=33087 AND `DifficultyID`=0); -- 33087 (Signal Fire Invisman) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25712 AND `DifficultyID`=0); -- 25712 (Warbringer Goredrak) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25713 AND `DifficultyID`=0); -- 25713 (Blue Drakonid Supplicant) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25721 AND `DifficultyID`=0); -- 25721 (Arcane Serpent) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=32357 AND `DifficultyID`=0); -- 32357 (Old Crystalbark) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=26127 AND `DifficultyID`=0); -- 26127 (Nexus Drake Hatchling) - Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=28960 AND `DifficultyID`=0); -- 28960 (Totally Generic Bunny (JSB)) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=32534 AND `DifficultyID`=0); -- 32534 (Scalesworn Elite) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=524288, `VerifiedBuild`=54847 WHERE (`Entry`=25711 AND `DifficultyID`=0); -- 25711 (Spirit of the North) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=27906 AND `DifficultyID`=0); -- 27906 (Warmage Hollister) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=27904 AND `DifficultyID`=0); -- 27904 (Warmage Watkins) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=30051 AND `DifficultyID`=0); -- 30051 (Librarian Tiare) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25314 AND `DifficultyID`=0); -- 25314 (Archmage Berinand) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=27173 AND `DifficultyID`=0); -- 27173 (Warmage Calandra) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=881, `VerifiedBuild`=54847 WHERE (`Entry`=27046 AND `DifficultyID`=0); -- 27046 (Warmage Adami) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=26110 AND `DifficultyID`=0); -- 26110 (Librarian Serrah) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=26175 AND `DifficultyID`=0); -- 26175 (Coldarra - Drake Hunt Invisman) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=26117 AND `DifficultyID`=0); -- 26117 (Raelorasz) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25709 AND `DifficultyID`=0); -- 25709 (Glacial Ancient) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25728 AND `DifficultyID`=0); -- 25728 (Coldarra Wyrmkin) - +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=45396 AND `DifficultyID`=0); -- 45396 (Dave's Industrial Light and Magic Bunny (Medium)(Sessile)(Large AOI)) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=24770 AND `DifficultyID`=0); -- 24770 (Nexus Watcher) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25722 AND `DifficultyID`=0); -- 25722 (Coldarra Spellweaver) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25707 AND `DifficultyID`=0); -- 25707 (Magic-bound Ancient) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=26373 AND `DifficultyID`=0); -- 26373 (Coldarra Spell FX InvisMan) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25719 AND `DifficultyID`=0); -- 25719 (Coldarra Spellbinder) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25718 AND `DifficultyID`=0); -- 25718 (Coldarra Mage Slayer) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|536871168, `VerifiedBuild`=54847 WHERE (`Entry`=27529 AND `DifficultyID`=0); -- 27529 (Unu'pe Vision - Smoke Target (DND)) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|536871168, `VerifiedBuild`=54847 WHERE (`Entry`=27569 AND `DifficultyID`=0); -- 27569 (Unu'pe Vision - Villager Bunny (DND)) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=54847 WHERE (`Entry`=27494 AND `DifficultyID`=0); -- 27494 (Mystic Tomkin) - +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=54847 WHERE (`Entry`=27193 AND `DifficultyID`=0); -- 27193 (Alornerk) - +UPDATE `creature_template_difficulty` SET `StaticFlags1`=256, `VerifiedBuild`=54847 WHERE (`Entry`=27610 AND `DifficultyID`=0); -- 27610 (Dead Caribou) - Sessile +UPDATE `creature_template_difficulty` SET `ContentTuningID`=966, `VerifiedBuild`=54847 WHERE (`Entry`=31805 AND `DifficultyID`=0); -- 31805 (Nagojut) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=26556 AND `DifficultyID`=0); -- 26556 (Agloolik) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=966, `VerifiedBuild`=54847 WHERE (`Entry`=31807 AND `DifficultyID`=0); -- 31807 (Aumanil) - +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=54847 WHERE (`Entry`=27195 AND `DifficultyID`=0); -- 27195 (Tarralikitak) - +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=54847 WHERE (`Entry`=27190 AND `DifficultyID`=0); -- 27190 (Tupit) - +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=26403 AND `DifficultyID`=0); -- 26403 (Kaskala Lookout) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=26218 AND `DifficultyID`=0); -- 26218 (Elder Muahit) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=28382 AND `DifficultyID`=0); -- 28382 (Hotawa) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=`StaticFlags1`|268435712, `VerifiedBuild`=54847 WHERE (`Entry`=26219 AND `DifficultyID`=0); -- 26219 (Iruk) - Sessile, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=26169 AND `DifficultyID`=0); -- 26169 (Ataika) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=26213 AND `DifficultyID`=0); -- 26213 (Utaik) - CanSwim +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=54847 WHERE (`Entry`=27194 AND `DifficultyID`=0); -- 27194 (Trapper Saghani) - +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=54847 WHERE (`Entry`=27566 AND `DifficultyID`=0); -- 27566 (Unu'pe Villager) - +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=54847 WHERE (`Entry`=27187 AND `DifficultyID`=0); -- 27187 (Caregiver Poallu) - +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=54847 WHERE (`Entry`=27186 AND `DifficultyID`=0); -- 27186 (Oogrooq) - +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=27189 AND `DifficultyID`=0); -- 27189 (Unu'pe Spearman) - CanSwim +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=54847 WHERE (`Entry`=29965 AND `DifficultyID`=0); -- 29965 (Unu'pe Turtle Rider) - +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=54847 WHERE (`Entry`=25514 AND `DifficultyID`=0); -- 25514 (Rocknar) - +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|805306368, `VerifiedBuild`=54847 WHERE (`Entry`=71163 AND `DifficultyID`=0); -- 71163 (Unborn Val'kyr) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=256, `VerifiedBuild`=54847 WHERE (`Entry`=26172 AND `DifficultyID`=0); -- 26172 (Slain Cultist) - Sessile +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25715 AND `DifficultyID`=0); -- 25715 (Frozen Elemental) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=26162 AND `DifficultyID`=0); -- 26162 (Transborea Generator 001) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=32361 AND `DifficultyID`=0); -- 32361 (Icehorn) - CanSwim +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=54847 WHERE (`Entry`=25668 AND `DifficultyID`=0); -- 25668 (Vengeful Taunka Spirit) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=27860 AND `DifficultyID`=0); -- 27860 (Luthion the Vile) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=25422 AND `DifficultyID`=0); -- 25422 (Mystical Webbing) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=`StaticFlags1`|536870912, `VerifiedBuild`=54847 WHERE (`Entry`=26073 AND `DifficultyID`=0); -- 26073 (High Priest Talet-Kha) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=25473 AND `DifficultyID`=0); -- 25473 (Temple C) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=26115 AND `DifficultyID`=0); -- 26115 (Darkfallen Bloodbearer) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25392 AND `DifficultyID`=0); -- 25392 (High Priest Andorath) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25516 AND `DifficultyID`=0); -- 25516 (Snow Tracker Grumm) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=25534 AND `DifficultyID`=0); -- 25534 (En'kilah Blood Globe) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=25472 AND `DifficultyID`=0); -- 25472 (Temple B) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=26076 AND `DifficultyID`=0); -- 26076 (High Priest Naferset) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=25493 AND `DifficultyID`=0); -- 25493 (West En'kilah Cauldron) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=25492 AND `DifficultyID`=0); -- 25492 (Central En'kilah Cauldron) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=25471 AND `DifficultyID`=0); -- 25471 (Temple A) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=25391 AND `DifficultyID`=0); -- 25391 (En'kilah Focus Crystal) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=27859 AND `DifficultyID`=0); -- 27859 (Vanthryn the Merciless) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25378 AND `DifficultyID`=0); -- 25378 (En'kilah Necromancer) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=25490 AND `DifficultyID`=0); -- 25490 (East En'kilah Cauldron) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25390 AND `DifficultyID`=0); -- 25390 (En'kilah Hatchling) - +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=26093 AND `DifficultyID`=0); -- 26093 (Naxxanar Target) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25377 AND `DifficultyID`=0); -- 25377 (Brittle Skeleton) - +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=26094 AND `DifficultyID`=0); -- 26094 (Naxxanar Caster) - Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25393 AND `DifficultyID`=0); -- 25393 (En'kilah Ghoul) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25725 AND `DifficultyID`=0); -- 25725 (Chieftain Gurgleboggle) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25604 AND `DifficultyID`=0); -- 25604 (Sage Highmesa) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25606 AND `DifficultyID`=0); -- 25606 (Hamat) - +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25454 AND `DifficultyID`=0); -- 25454 (Tundra Crawler) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25705 AND `DifficultyID`=0); -- 25705 (Bixie Wrenchshanker) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25615 AND `DifficultyID`=0); -- 25615 (Plagued Magnataur) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25452 AND `DifficultyID`=0); -- 25452 (Scourged Mammoth) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25682 AND `DifficultyID`=0); -- 25682 (Lich-Lord Chillwinter) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=`StaticFlags1`|805306624, `VerifiedBuild`=54847 WHERE (`Entry`=25658 AND `DifficultyID`=0); -- 25658 (Longrunner Bristlehorn) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25678 AND `DifficultyID`=0); -- 25678 (Doctor Razorgrin) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25714 AND `DifficultyID`=0); -- 25714 (Tinky Wickwhistle) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25684 AND `DifficultyID`=0); -- 25684 (Talramas Abomination) - +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25983 AND `DifficultyID`=0); -- 25983 (Dorain Frosthoof) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=26158 AND `DifficultyID`=0); -- 26158 (Mother Tauranook) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25602 AND `DifficultyID`=0); -- 25602 (Greatmother Taiga) - CanSwim +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=54847 WHERE (`Entry`=26847 AND `DifficultyID`=0); -- 26847 (Omu Spiritbreeze) - +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=26159 AND `DifficultyID`=0); -- 26159 (Taunka'le Evacuee) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25982 AND `DifficultyID`=0); -- 25982 (Sage Earth and Sky) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=26157 AND `DifficultyID`=0); -- 26157 (Taunka'le Brave) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=26104 AND `DifficultyID`=0); -- 26104 (Iron Eyes) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=26048 AND `DifficultyID`=0); -- 26048 (Storm Totem) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=26041 AND `DifficultyID`=0); -- 26041 (Lightning Target) - Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25700 AND `DifficultyID`=0); -- 25700 (Gorloc Hunter) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25701 AND `DifficultyID`=0); -- 25701 (Gorloc Dredger) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25699 AND `DifficultyID`=0); -- 25699 (Gorloc Mud Splasher) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25786 AND `DifficultyID`=0); -- 25786 (Friar Tuskus) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=26790 AND `DifficultyID`=0); -- 26790 (Taunka'le Longrunner) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=26266 AND `DifficultyID`=0); -- 26266 (Heigarr the Horrible) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25760 AND `DifficultyID`=0); -- 25760 (Kvaldir Raider) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25764 AND `DifficultyID`=0); -- 25764 (Kaskala Defender) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25685 AND `DifficultyID`=0); -- 25685 (Gorloc Waddler) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=25984 AND `DifficultyID`=0); -- 25984 (Crashed Recon Pilot) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25807 AND `DifficultyID`=0); -- 25807 (Iggy "Tailspin" Cogtoggle) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=27999 AND `DifficultyID`=0); -- 27999 (Rock Shield Trigger (Borean Tundra)) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=26766 AND `DifficultyID`=0); -- 26766 (Brave Storming Sky) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=26768 AND `DifficultyID`=0); -- 26768 (Snow Tracker Haloke) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=26767 AND `DifficultyID`=0); -- 26767 (Longrunner Taima) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25665 AND `DifficultyID`=0); -- 25665 (Northeast Sinkhole) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25666 AND `DifficultyID`=0); -- 25666 (Northwest Sinkhole) - Floating +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=54847 WHERE (`Entry`=25622 AND `DifficultyID`=0); -- 25622 (Nerub'ar Tunneler) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=24957 AND `DifficultyID`=0); -- 24957 (Cult Plaguebringer) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=25670 AND `DifficultyID`=0); -- 25670 (ELM General Purpose Bunny (scale x3)) - Floating +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=54847 WHERE (`Entry`=25660 AND `DifficultyID`=0); -- 25660 (Festering Ghoul) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=26126 AND `DifficultyID`=0); -- 26126 (Bone Warrior) - +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0, `VerifiedBuild`=54847 WHERE (`Entry`=19871 AND `DifficultyID`=0); -- 19871 (World Trigger (Not Immune NPC)) - +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25814 AND `DifficultyID`=0); -- 25814 (Fizzcrank Mechagnome) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=25425 AND `DifficultyID`=0); -- 25425 (Farseer Grimwalker's Spirit) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25427 AND `DifficultyID`=0); -- 25427 (Kaganishu) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25430 AND `DifficultyID`=0); -- 25430 (Magmothregar) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=`StaticFlags1`|805306624, `VerifiedBuild`=54847 WHERE (`Entry`=25589 AND `DifficultyID`=0); -- 25589 (Bonker Togglevolt) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=54847 WHERE (`Entry`=21757 AND `DifficultyID`=0); -- 21757 (Big Electromental Flavor) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25477 AND `DifficultyID`=0); -- 25477 (Crafty Wobblesprocket) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25702 AND `DifficultyID`=0); -- 25702 (Mordle Cogspinner) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=26619 AND `DifficultyID`=0); -- 26619 (Fizzcrank Paratrooper) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=26598 AND `DifficultyID`=0); -- 26598 (Mistie Flitterdawn) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|805306624, `VerifiedBuild`=54847 WHERE (`Entry`=25747 AND `DifficultyID`=0); -- 25747 (Jinky Wingnut) - Sessile, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25590 AND `DifficultyID`=0); -- 25590 (Fizzcrank Fullthrottle) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=26599 AND `DifficultyID`=0); -- 26599 (Willis Wobblewheel) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=26596 AND `DifficultyID`=0); -- 26596 ("Charlie" Northtop) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=26597 AND `DifficultyID`=0); -- 26597 (Toby "Mother Goose" Ironbolt) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25767 AND `DifficultyID`=0); -- 25767 (Fizzcrank Pilot) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=`StaticFlags1`|268435456, `VerifiedBuild`=54847 WHERE (`Entry`=26634 AND `DifficultyID`=0); -- 26634 (Fizzcrank Watcher Rupert Keeneye) - CanSwim +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=54847 WHERE (`DifficultyID`=0 AND `Entry` IN (31790,31788,31789,31793,31791,31792,25650,25623,26549,25307,25222,35133,35131,47576,25816,25825,25468,61158,25467,60761,25611,25600,25609,25610,24562,25294,26538,27432,47577,35135,35132,31724,31725,31723,31720,24566)); +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25434 AND `DifficultyID`=0); -- 25434 (Magmoth Crusher) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25416 AND `DifficultyID`=0); -- 25416 (Simmer) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25429 AND `DifficultyID`=0); -- 25429 (Magmoth Forager) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25432 AND `DifficultyID`=0); -- 25432 (Mate of Magmothregar) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25433 AND `DifficultyID`=0); -- 25433 (Offspring of Magmothregar) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25428 AND `DifficultyID`=0); -- 25428 (Magmoth Shaman) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=25444 AND `DifficultyID`=0); -- 25444 (Magmoth Fire Totem) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=881, `VerifiedBuild`=54847 WHERE (`Entry`=26848 AND `DifficultyID`=0); -- 26848 (Kimbiza) - Amphibious +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25326 AND `DifficultyID`=0); -- 25326 (Overlord Bor'gorok) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25736 AND `DifficultyID`=0); -- 25736 (Supply Master Taz'ishi) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=27074 AND `DifficultyID`=0); -- 27074 (Bor'gorok Wolf) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=27065 AND `DifficultyID`=0); -- 27065 (Breka Wolfsister) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=27058 AND `DifficultyID`=0); -- 27058 (Korag Keeneye) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25339 AND `DifficultyID`=0); -- 25339 (Spirit Talker Snarlfang) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=25455 AND `DifficultyID`=0); -- 25455 (Snarlfang's Totem) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=27069 AND `DifficultyID`=0); -- 27069 (Matron Magah) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=27067 AND `DifficultyID`=0); -- 27067 (Drigoth) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=27063 AND `DifficultyID`=0); -- 27063 (Vrok) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=805830912, `VerifiedBuild`=54847 WHERE (`Entry`=25374 AND `DifficultyID`=0); -- 25374 (Ortrosh) - Sessile, Amphibious, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2110, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=27073 AND `DifficultyID`=0); -- 27073 (Bor'gorok Battleguard) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26112 AND `DifficultyID`=0); -- 26112 (Bor'gorok Peon) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25376 AND `DifficultyID`=0); -- 25376 (Imperean) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25199 AND `DifficultyID`=0); -- 25199 (Brglmurgl) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0, `VerifiedBuild`=54847 WHERE (`Entry`=34381 AND `DifficultyID`=0); -- 34381 ([DND]Northrend Children's Week Trigger) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25211 AND `DifficultyID`=0); -- 25211 (Cleaver Bmurglbrm) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25205 AND `DifficultyID`=0); -- 25205 (Mrmrglmr) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25415 AND `DifficultyID`=0); -- 25415 (Enraged Tempest) - Amphibious +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268697600, `VerifiedBuild`=54847 WHERE (`Entry`=25203 AND `DifficultyID`=0); -- 25203 (Glrggl) - Aquatic, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25209 AND `DifficultyID`=0); -- 25209 (Claximus) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25208 AND `DifficultyID`=0); -- 25208 (Lurgglbr) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=28375 AND `DifficultyID`=0); -- 28375 (Glrglrglr) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25210 AND `DifficultyID`=0); -- 25210 (Keymaster Urmgrgl) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=24288 AND `DifficultyID`=0); -- 24288 (ELM General Purpose Bunny Hide Body) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=0, `VerifiedBuild`=54847 WHERE (`Entry`=25309 AND `DifficultyID`=0); -- 25309 (Borean - Westrift Cavern Anomaly) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25216 AND `DifficultyID`=0); -- 25216 (Winterfin Oracle) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25201 AND `DifficultyID`=0); -- 25201 (Winterfin Tadpole) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25217 AND `DifficultyID`=0); -- 25217 (Winterfin Warrior) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25206 AND `DifficultyID`=0); -- 25206 (Ahlurglgr) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268697600, `VerifiedBuild`=54847 WHERE (`Entry`=25226 AND `DifficultyID`=0); -- 25226 (Scalder) - Aquatic, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25197 AND `DifficultyID`=0); -- 25197 (King Mrgl-Mrgl) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=25847 AND `DifficultyID`=0); -- 25847 (East Crash) - Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=25845 AND `DifficultyID`=0); -- 25845 (Northwest Crash) - Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=25781 AND `DifficultyID`=0); -- 25781 (Oil Pool) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25780 AND `DifficultyID`=0); -- 25780 (Abner Fizzletorque) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26602 AND `DifficultyID`=0); -- 26602 (Kara Thricestar) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26600 AND `DifficultyID`=0); -- 26600 (Chief Engineer Galpen Rolltie) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26817 AND `DifficultyID`=0); -- 26817 (Fizzcrank Fighter) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26645 AND `DifficultyID`=0); -- 26645 (Fizzcrank Engineering Crew) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26601 AND `DifficultyID`=0); -- 26601 (Fizzcrank Airman) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=26804 AND `DifficultyID`=0); -- 26804 (Fizzcrank Bomber Invisible Bunny) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25881 AND `DifficultyID`=0); -- 25881 (Moria) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=25748 AND `DifficultyID`=0); -- 25748 (Oil-covered Hawk) - Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=25817 AND `DifficultyID`=0); -- 25817 (Oiled Fledgeling) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25417 AND `DifficultyID`=0); -- 25417 (Raging Boiler) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25418 AND `DifficultyID`=0); -- 25418 (Churn) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268697600, `VerifiedBuild`=54847 WHERE (`Entry`=25204 AND `DifficultyID`=0); -- 25204 (Glimmer Bay Orca) - Aquatic, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25419 AND `DifficultyID`=0); -- 25419 (Boiling Spirit) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25198 AND `DifficultyID`=0); -- 25198 (Winterfin Gatherer) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25215 AND `DifficultyID`=0); -- 25215 (Winterfin Shorestriker) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25336 AND `DifficultyID`=0); -- 25336 (Grunt Ragefist) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25338 AND `DifficultyID`=0); -- 25338 (Warsong Caravan Guard) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25335 AND `DifficultyID`=0); -- 25335 (Longrunner Proudhoof) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=0, `VerifiedBuild`=54847 WHERE (`Entry`=25308 AND `DifficultyID`=0); -- 25308 (Borean - Westrift Chasm Anomaly) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=25384 AND `DifficultyID`=0); -- 25384 (Steeljaw's Corpse) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=805830912, `VerifiedBuild`=54847 WHERE (`Entry`=25343 AND `DifficultyID`=0); -- 25343 (Dead Caravan Worker) - Sessile, Amphibious, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25802 AND `DifficultyID`=0); -- 25802 (Kaw the Mammoth Destroyer) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25880 AND `DifficultyID`=0); -- 25880 (Minion of Kaw) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25351 AND `DifficultyID`=0); -- 25351 (Ghostly Sage) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=805830912, `VerifiedBuild`=54847 WHERE (`Entry`=25342 AND `DifficultyID`=0); -- 25342 (Dead Caravan Guard) - Sessile, Amphibious, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25350 AND `DifficultyID`=0); -- 25350 (Risen Longrunner) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=25441 AND `DifficultyID`=0); -- 25441 (North Platform) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=25443 AND `DifficultyID`=0); -- 25443 (West Platform) - Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=25841 AND `DifficultyID`=0); -- 25841 (Fizzcrank Recon Pilot) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=25846 AND `DifficultyID`=0); -- 25846 (South Crash) - Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25810 AND `DifficultyID`=0); -- 25810 (Hierophant Cenius) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25812 AND `DifficultyID`=0); -- 25812 (Killinger the Den Watcher) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25809 AND `DifficultyID`=0); -- 25809 (Archdruid Lathorius) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=805830656, `VerifiedBuild`=54847 WHERE (`Entry`=25819 AND `DifficultyID`=0); -- 25819 (D.E.H.T.A. Enforcer) - Amphibious, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25811 AND `DifficultyID`=0); -- 25811 (Zaza) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25808 AND `DifficultyID`=0); -- 25808 (D.E.H.T.A. Enforcer) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25292 AND `DifficultyID`=0); -- 25292 (Etaruk) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=25442 AND `DifficultyID`=0); -- 25442 (East Platform) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25321 AND `DifficultyID`=0); -- 25321 (Kaskala Craftsman) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25322 AND `DifficultyID`=0); -- 25322 (Kaskala Shaman) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25448 AND `DifficultyID`=0); -- 25448 (Curator Insivius) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25355 AND `DifficultyID`=0); -- 25355 (Beryl Hound) - Amphibious +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25353 AND `DifficultyID`=0); -- 25353 (Beryl Treasure Hunter) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25449 AND `DifficultyID`=0); -- 25449 (Beryl Reclaimer) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=25431 AND `DifficultyID`=0); -- 25431 (Kaskala Ancestor) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=24862 AND `DifficultyID`=0); -- 24862 (Mage Hunter Target) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=27271 AND `DifficultyID`=0); -- 27271 (Initiate Knapp) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=27301 AND `DifficultyID`=0); -- 27301 (Apprentice Trotter) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=27298 AND `DifficultyID`=0); -- 27298 (Apprentice Ranch) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=27147 AND `DifficultyID`=0); -- 27147 (Librarian Erickson) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=27138 AND `DifficultyID`=0); -- 27138 (Apprentice Rosen) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=27139 AND `DifficultyID`=0); -- 27139 (Librarian Whitley) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=27137 AND `DifficultyID`=0); -- 27137 (Apprentice Fraser) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=27143 AND `DifficultyID`=0); -- 27143 (Librarian Ingram) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25480 AND `DifficultyID`=0); -- 25480 (Librarian Normantis) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=27291 AND `DifficultyID`=0); -- 27291 (Initiate Mehrtens) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=27302 AND `DifficultyID`=0); -- 27302 (Initiate Park) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=27300 AND `DifficultyID`=0); -- 27300 (Initiate Vernon) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=27299 AND `DifficultyID`=0); -- 27299 (Initiate Greer) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=27142 AND `DifficultyID`=0); -- 27142 (Librarian Jeffers) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=27140 AND `DifficultyID`=0); -- 27140 (Librarian Andersen) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=27141 AND `DifficultyID`=0); -- 27141 (Librarian Hamilton) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25262 AND `DifficultyID`=0); -- 25262 (Librarian Donathan) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25291 AND `DifficultyID`=0); -- 25291 (Librarian Garren) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=881, `VerifiedBuild`=54847 WHERE (`Entry`=24795 AND `DifficultyID`=0); -- 24795 (Surristrasz) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=524288, `VerifiedBuild`=54847 WHERE (`Entry`=25364 AND `DifficultyID`=0); -- 25364 (Red Guardian Drake) - Amphibious +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25584 AND `DifficultyID`=0); -- 25584 (Inquisitor Salrand) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25316 AND `DifficultyID`=0); -- 25316 (Beryl Sorcerer) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25585 AND `DifficultyID`=0); -- 25585 (Beryl Mage Hunter) - Amphibious +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=54242 AND `DifficultyID`=0); -- 54242 (Borean Beam Target) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=0, `VerifiedBuild`=54847 WHERE (`Entry`=25732 AND `DifficultyID`=0); -- 25732 (Warmage Preston) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=0, `VerifiedBuild`=54847 WHERE (`Entry`=25727 AND `DifficultyID`=0); -- 25727 (Warmage Moran) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=36155 AND `DifficultyID`=0); -- 36155 (Anzim Controller Bunny) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25356 AND `DifficultyID`=0); -- 25356 (Warmage Anzim) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=0, `VerifiedBuild`=54847 WHERE (`Entry`=27888 AND `DifficultyID`=0); -- 27888 (Warmage Archus) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=0, `VerifiedBuild`=54847 WHERE (`Entry`=25733 AND `DifficultyID`=0); -- 25733 (Warmage Austin) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=805830912, `VerifiedBuild`=54847 WHERE (`Entry`=25801 AND `DifficultyID`=0); -- 25801 (Nedar, Lord of Rhinos) - Sessile, Amphibious, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=25995 AND `DifficultyID`=0); -- 25995 (Stampede Exit Point) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25804 AND `DifficultyID`=0); -- 25804 (Harold Lane) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25806 AND `DifficultyID`=0); -- 25806 (Loot Crazed Poacher) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=805830656, `VerifiedBuild`=54847 WHERE (`Entry`=25838 AND `DifficultyID`=0); -- 25838 (Hierophant Liandra) - Amphibious, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25687 AND `DifficultyID`=0); -- 25687 (Gorloc Steam Belcher) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25686 AND `DifficultyID`=0); -- 25686 (Gorloc Gibberer) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=256, `VerifiedBuild`=54847 WHERE (`Entry`=25385 AND `DifficultyID`=0); -- 25385 (William Allerton) - Sessile +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25803 AND `DifficultyID`=0); -- 25803 (Karen "I Don't Caribou" the Culler) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25981 AND `DifficultyID`=0); -- 25981 (Scourged Footman) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0, `VerifiedBuild`=54847 WHERE (`Entry`=26161 AND `DifficultyID`=0); -- 26161 (Farshire Grain Credit) - +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26084 AND `DifficultyID`=0); -- 26084 (Jeremiah Hawning) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26083 AND `DifficultyID`=0); -- 26083 (Gerald Green) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26085 AND `DifficultyID`=0); -- 26085 (Wendy Darren) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25839 AND `DifficultyID`=0); -- 25839 (Northsea Mercenary) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25843 AND `DifficultyID`=0); -- 25843 (Northsea Thug) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25617 AND `DifficultyID`=0); -- 25617 (Farshire Militia) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=-1, `LevelScalingDeltaMax`=-1, `StaticFlags1`=268697600, `VerifiedBuild`=54847 WHERE (`Entry`=24637 AND `DifficultyID`=0); -- 24637 (Great Reef Shark) - Aquatic, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25800 AND `DifficultyID`=0); -- 25800 (Clam Master K) - Amphibious +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=27393 AND `DifficultyID`=0); -- 27393 (Valiance Keep Fisherman) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25281 AND `DifficultyID`=0); -- 25281 (Heldgarr Steelbeard) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25282 AND `DifficultyID`=0); -- 25282 (Ferlynn Windsong) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=25297 AND `DifficultyID`=0); -- 25297 (Drill Dummy) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25826 AND `DifficultyID`=0); -- 25826 (Vindicator Yaala) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25248 AND `DifficultyID`=0); -- 25248 ("Salty" John Thorpe) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=27011 AND `DifficultyID`=0); -- 27011 (Broff Bombast) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26999 AND `DifficultyID`=0); -- 26999 (Fendrig Redbeard) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25239 AND `DifficultyID`=0); -- 25239 (Thulrin) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25235 AND `DifficultyID`=0); -- 25235 (Hilda Stoneforge) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=32564 AND `DifficultyID`=0); -- 32564 (Logistics Officer Silverstone) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25240 AND `DifficultyID`=0); -- 25240 (Bromm) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26992 AND `DifficultyID`=0); -- 26992 (Brynna Wilson) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25238 AND `DifficultyID`=0); -- 25238 (Gamlen) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25241 AND `DifficultyID`=0); -- 25241 (Gelrynd) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26988 AND `DifficultyID`=0); -- 26988 (Argo Strongstout) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25302 AND `DifficultyID`=0); -- 25302 (Old Man Colburn) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25271 AND `DifficultyID`=0); -- 25271 (Valiance Keep Worker) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25827 AND `DifficultyID`=0); -- 25827 (Tom Hegger) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25251 AND `DifficultyID`=0); -- 25251 (Leryssa) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26879 AND `DifficultyID`=0); -- 26879 (Tomas Riverwell) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=24357 AND `DifficultyID`=0); -- 24357 (Maethor Skyshadow) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=27010 AND `DifficultyID`=0); -- 27010 (Celidh Aletracker) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25245 AND `DifficultyID`=0); -- 25245 (James Deacon) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=29158 AND `DifficultyID`=0); -- 29158 (Magister Dath'omere) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25737 AND `DifficultyID`=0); -- 25737 (Airman Skyhopper) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=25219 AND `DifficultyID`=0); -- 25219 (Borean Queue Trigger LAB) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26989 AND `DifficultyID`=0); -- 26989 (Rollick MacKreel) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=27364 AND `DifficultyID`=0); -- 27364 (Jimmy the Stable Boy) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=27365 AND `DifficultyID`=0); -- 27365 (Stabled Horse) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=27012 AND `DifficultyID`=0); -- 27012 (Beem Goldsprocket) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26991 AND `DifficultyID`=0); -- 26991 (Sock Brightbolt) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26987 AND `DifficultyID`=0); -- 26987 (Falorn Nightwhisper) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26994 AND `DifficultyID`=0); -- 26994 (Kirea Moondancer) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26993 AND `DifficultyID`=0); -- 26993 (Old Man Robert) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25301 AND `DifficultyID`=0); -- 25301 (Counselor Talbot) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25250 AND `DifficultyID`=0); -- 25250 (General Arlos) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25285 AND `DifficultyID`=0); -- 25285 (Harbinger Vurenn) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26990 AND `DifficultyID`=0); -- 26990 (Alexis Marlowe) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=27385 AND `DifficultyID`=0); -- 27385 (Ronald Anderson) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=27000 AND `DifficultyID`=0); -- 27000 (Trapper Jack) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=27001 AND `DifficultyID`=0); -- 27001 (Darin Goodstitch) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26998 AND `DifficultyID`=0); -- 26998 (Rosemary Bovard) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26997 AND `DifficultyID`=0); -- 26997 (Alestos) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26995 AND `DifficultyID`=0); -- 26995 (Tink Brightbolt) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25828 AND `DifficultyID`=0); -- 25828 (Guard Mitchells) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25300 AND `DifficultyID`=0); -- 25300 (Draenei Delegate) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25317 AND `DifficultyID`=0); -- 25317 (Civilian Recruit) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25220 AND `DifficultyID`=0); -- 25220 (Civilian Recruit) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26155 AND `DifficultyID`=0); -- 26155 (Mark Hanes) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=29617 AND `DifficultyID`=0); -- 29617 (Valiance Keep Defender) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0, `VerifiedBuild`=54847 WHERE (`Entry`=26249 AND `DifficultyID`=0); -- 26249 (Southern Sinkhole Kill Credit) - +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0, `VerifiedBuild`=54847 WHERE (`Entry`=26248 AND `DifficultyID`=0); -- 26248 (Northern Sinkhole Kill Credit) - +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25264 AND `DifficultyID`=0); -- 25264 (Justicar Julia Celeste) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25253 AND `DifficultyID`=0); -- 25253 (Valiance Keep Footman) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25306 AND `DifficultyID`=0); -- 25306 (Valiance Keep Cannoneer) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25311 AND `DifficultyID`=0); -- 25311 (Valiance Keep Rifleman) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=24042 AND `DifficultyID`=0); -- 24042 (Generic Trigger LAB - OLD) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25313 AND `DifficultyID`=0); -- 25313 (Valiance Keep Footman) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=256, `VerifiedBuild`=54847 WHERE (`Entry`=24580 AND `DifficultyID`=0); -- 24580 (Riplash Siren) - Sessile +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26451 AND `DifficultyID`=0); -- 26451 (Ragnar Drakkarlund) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25523 AND `DifficultyID`=0); -- 25523 (Skadir Mariner) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25520 AND `DifficultyID`=0); -- 25520 (Skadir Runecaster) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26452 AND `DifficultyID`=0); -- 26452 (Leviroth) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25450 AND `DifficultyID`=0); -- 25450 (Veehja) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=256, `VerifiedBuild`=54847 WHERE (`Entry`=24662 AND `DifficultyID`=0); -- 24662 (Riplash Sorceress) - Sessile +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=24576 AND `DifficultyID`=0); -- 24576 (Riplash Myrmidon) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26449 AND `DifficultyID`=0); -- 26449 (Gamel the Cruel) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25613 AND `DifficultyID`=0); -- 25613 (Skadir Mistweaver) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25522 AND `DifficultyID`=0); -- 25522 (Skadir Raider) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25636 AND `DifficultyID`=0); -- 25636 (Captured Tuskarr Prisoner) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25521 AND `DifficultyID`=0); -- 25521 (Skadir Longboatsman) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25435 AND `DifficultyID`=0); -- 25435 (Karuk) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25498 AND `DifficultyID`=0); -- 25498 (Aspatha the Broodmother) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268960000, `VerifiedBuild`=54847 WHERE (`Entry`=25797 AND `DifficultyID`=0); -- 25797 (Bloodmage Alkor) - Sessile, Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25501 AND `DifficultyID`=0); -- 25501 (Gammoth Tender) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25380 AND `DifficultyID`=0); -- 25380 (Primal Mighthorn) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25381 AND `DifficultyID`=0); -- 25381 (Bloodmage Laurith) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25440 AND `DifficultyID`=0); -- 25440 (Scout Tungok) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25836 AND `DifficultyID`=0); -- 25836 (Loot Crazed Diver) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25979 AND `DifficultyID`=0); -- 25979 (Loot Crazed Hunter) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25789 AND `DifficultyID`=0); -- 25789 (Gammothra the Tormentor) - Amphibious +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=24567 AND `DifficultyID`=0); -- 24567 (Den Vermin) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=24469 AND `DifficultyID`=0); -- 24469 (Magnataur Huntress) - Amphibious +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0, `VerifiedBuild`=54847 WHERE (`Entry`=25464 AND `DifficultyID`=0); -- 25464 (Bloodspore Moth) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25774 AND `DifficultyID`=0); -- 25774 (Rockfang) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25332 AND `DifficultyID`=0); -- 25332 (Stitched Warsong Horror) - +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25675 AND `DifficultyID`=0); -- 25675 (Tundra Wolf) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=25465 AND `DifficultyID`=0); -- 25465 (Kel'Thuzad) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=25466 AND `DifficultyID`=0); -- 25466 (Necropolis Beam (Target)) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25469 AND `DifficultyID`=0); -- 25469 (Mindless Aberration) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=25513 AND `DifficultyID`=0); -- 25513 (4th Kvaldir Vessel (Bor's Anvil)) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2523, `StaticFlags1`=268435456, `VerifiedBuild`=54847 WHERE (`Entry`=208182 AND `DifficultyID`=0); -- 208182 (Crazed Looter) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=28440 AND `DifficultyID`=0); -- 28440 (Tundra Penguin) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=0, `VerifiedBuild`=54847 WHERE (`Entry`=25310 AND `DifficultyID`=0); -- 25310 (Borean - Westrift Cleftcliff Anomaly) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=25510 AND `DifficultyID`=0); -- 25510 (1st Kvaldir Vessel (The Serpent's Maw)) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=25511 AND `DifficultyID`=0); -- 25511 (2nd Kvaldir Vessel (The Kur Drakkar)) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=25512 AND `DifficultyID`=0); -- 25512 (3rd Kvaldir Vessel (Bor's Hammer)) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25479 AND `DifficultyID`=0); -- 25479 (Kvaldir Mistweaver) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25496 AND `DifficultyID`=0); -- 25496 (Kvaldir Mist Lord) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25504 AND `DifficultyID`=0); -- 25504 (Mootoo the Younger) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25475 AND `DifficultyID`=0); -- 25475 (Mobu) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25503 AND `DifficultyID`=0); -- 25503 (Elder Mootoo) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25481 AND `DifficultyID`=0); -- 25481 (Landing Crawler) - Amphibious +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25329 AND `DifficultyID`=0); -- 25329 (Annihilator Grek'lor) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25482 AND `DifficultyID`=0); -- 25482 (Sand Turtle) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25476 AND `DifficultyID`=0); -- 25476 (Waltor of Pal'ea) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25334 AND `DifficultyID`=0); -- 25334 (Horde Siege Tank) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=27107 AND `DifficultyID`=0); -- 27107 (Injured Warsong Mage) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=27110 AND `DifficultyID`=0); -- 27110 (Injured Warsong Engineer) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25333 AND `DifficultyID`=0); -- 25333 (Undying Aggressor) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=256, `VerifiedBuild`=54847 WHERE (`Entry`=28150 AND `DifficultyID`=0); -- 28150 (Destroyed Siege Tank) - Sessile +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=27064 AND `DifficultyID`=0); -- 27064 (Abandoned Fuel Tank) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=27106 AND `DifficultyID`=0); -- 27106 (Injured Warsong Warrior) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=27108 AND `DifficultyID`=0); -- 27108 (Injured Warsong Shaman) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25349 AND `DifficultyID`=0); -- 25349 (Scourge Plague Spreader) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=25669 AND `DifficultyID`=0); -- 25669 (Warsong Grainery Credit) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=25671 AND `DifficultyID`=0); -- 25671 (Torp's Farm Credit) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25625 AND `DifficultyID`=0); -- 25625 (Warsong Aberration) - +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25618 AND `DifficultyID`=0); -- 25618 (Varidus the Flenser) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25624 AND `DifficultyID`=0); -- 25624 (Infested Prisoner) - +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912, `VerifiedBuild`=54847 WHERE (`Entry`=24771 AND `DifficultyID`=0); -- 24771 (Coldarra Invisman) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `VerifiedBuild`=54847 WHERE (`Entry`=25655 AND `DifficultyID`=0); -- 25655 (Bane) - +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=25672 AND `DifficultyID`=0); -- 25672 (Warsong Slaughterhouse Credit) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25489 AND `DifficultyID`=0); -- 25489 (Wooly Rhino Bull) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25487 AND `DifficultyID`=0); -- 25487 (Wooly Rhino Matriarch) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25421 AND `DifficultyID`=0); -- 25421 (Warsong Hold Shaman) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25414 AND `DifficultyID`=0); -- 25414 (Warsong Hold Warrior) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25607 AND `DifficultyID`=0); -- 25607 (Farmer Torp) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25438 AND `DifficultyID`=0); -- 25438 (Shadowstalker Canarius) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25439 AND `DifficultyID`=0); -- 25439 (Warsong Scout) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25437 AND `DifficultyID`=0); -- 25437 (Shadowstalker Ickoris) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25426 AND `DifficultyID`=0); -- 25426 (Ug'thor Bloodfrenzy) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25379 AND `DifficultyID`=0); -- 25379 (Warden Nork Bloodfrenzy) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25327 AND `DifficultyID`=0); -- 25327 (Quartermaster Holgoth) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25279 AND `DifficultyID`=0); -- 25279 (Overlord Razgor) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=25403 AND `DifficultyID`=0); -- 25403 (Nerub'ar Sinkhole (East)) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25394 AND `DifficultyID`=0); -- 25394 (Shadowstalker Barthus) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25446 AND `DifficultyID`=0); -- 25446 (Warsong Captain) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=25402 AND `DifficultyID`=0); -- 25402 (Nerub'ar Sinkhole (South)) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25288 AND `DifficultyID`=0); -- 25288 (Turida Coldwind) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268960000, `VerifiedBuild`=54847 WHERE (`Entry`=25328 AND `DifficultyID`=0); -- 25328 (Shadowstalker Luther) - Sessile, Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=25404 AND `DifficultyID`=0); -- 25404 (Nerub'ar Sinkhole (West)) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25488 AND `DifficultyID`=0); -- 25488 (Wooly Rhino Calf) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=25405 AND `DifficultyID`=0); -- 25405 (Nerub'ar Sinkhole (North)) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25361 AND `DifficultyID`=0); -- 25361 (Alliance Deserter) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25280 AND `DifficultyID`=0); -- 25280 (Foreman Mortuus) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=32565 AND `DifficultyID`=0); -- 32565 (Gara Skullcrush) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=27440 AND `DifficultyID`=0); -- 27440 (Argah) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=27441 AND `DifficultyID`=0); -- 27441 (Sagai) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25289 AND `DifficultyID`=0); -- 25289 (Wind Master To'bor) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=32474 AND `DifficultyID`=0); -- 32474 (Fishy Ser'ji) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=524544, `VerifiedBuild`=54847 WHERE (`Entry`=25075 AND `DifficultyID`=0); -- 25075 (Zeppelin Controls) - Sessile, Amphibious +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25247 AND `DifficultyID`=0); -- 25247 (Endorah) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25237 AND `DifficultyID`=0); -- 25237 (Garrosh Hellscream) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26044 AND `DifficultyID`=0); -- 26044 (Durkot Wolfbrother) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25278 AND `DifficultyID`=0); -- 25278 (Williamson) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25274 AND `DifficultyID`=0); -- 25274 (Armorer Orkuruk) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25272 AND `DifficultyID`=0); -- 25272 (Sauranok the Mystic) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25269 AND `DifficultyID`=0); -- 25269 (Horde Zeppelin (Northrend)) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26109 AND `DifficultyID`=0); -- 26109 (Off-duty Battleguard) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25978 AND `DifficultyID`=0); -- 25978 (Ambassador Talonga) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=44, `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26078 AND `DifficultyID`=0); -- 26078 (Blakelow) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25273 AND `DifficultyID`=0); -- 25273 (Warsong Recruitment Officer) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=25284 AND `DifficultyID`=0); -- 25284 (Nerub'ar Victim) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25286 AND `DifficultyID`=0); -- 25286 (Warsong Wind Rider) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=31726 AND `DifficultyID`=0); -- 31726 (Grunt Gritch) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=31727 AND `DifficultyID`=0); -- 31727 (Grunt Grikee) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25256 AND `DifficultyID`=0); -- 25256 (High Overlord Saurfang) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25277 AND `DifficultyID`=0); -- 25277 (Chief Engineer Leveny) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26945 AND `DifficultyID`=0); -- 26945 (Zend'li Venomtusk) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26974 AND `DifficultyID`=0); -- 26974 (Tansy Wildmane) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26975 AND `DifficultyID`=0); -- 26975 (Arthur Henslowe) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26972 AND `DifficultyID`=0); -- 26972 (Orn Tenderhoof) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=29155 AND `DifficultyID`=0); -- 29155 (Magistrix Kaelana) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26968 AND `DifficultyID`=0); -- 26968 (Drikka) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26969 AND `DifficultyID`=0); -- 26969 (Raenah) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=29233 AND `DifficultyID`=0); -- 29233 (Nurse Applewood) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26982 AND `DifficultyID`=0); -- 26982 (Geba'li) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26980 AND `DifficultyID`=0); -- 26980 (Eorain Dawnstrike) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26981 AND `DifficultyID`=0); -- 26981 (Crog Steelspine) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26976 AND `DifficultyID`=0); -- 26976 (Brunna Ironaxe) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26977 AND `DifficultyID`=0); -- 26977 (Adelene Sunlance) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168, `VerifiedBuild`=54847 WHERE (`Entry`=32647 AND `DifficultyID`=0); -- 32647 (Warsong Hold Practice Dummy) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25242 AND `DifficultyID`=0); -- 25242 (Warsong Battleguard) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `VerifiedBuild`=54847 WHERE (`Entry`=25459 AND `DifficultyID`=0); -- 25459 (Yanni) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25275 AND `DifficultyID`=0); -- 25275 (Warsong Blacksmith) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=805830912, `VerifiedBuild`=54847 WHERE (`Entry`=25244 AND `DifficultyID`=0); -- 25244 (Warsong Marksman) - Sessile, Amphibious, CanSwim, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26941 AND `DifficultyID`=0); -- 26941 (Brokkan Bear-Arms) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=26938 AND `DifficultyID`=0); -- 26938 (Groll) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25276 AND `DifficultyID`=0); -- 25276 (Goblin Siege Engineer) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268959744, `VerifiedBuild`=54847 WHERE (`Entry`=25243 AND `DifficultyID`=0); -- 25243 (Warsong Honor Guard) - Amphibious, CanSwim + +DELETE FROM `creature_questitem` WHERE (`CreatureEntry` IN (24562,24563,24601,24613,24614,24637,25203,25204,25209,25210,25227,25294,25350,25351,25355,25383,25386,25387,25392,25415,25427,25445,25449,25452,25464,25479,25496,25498,25514,25520,25521,25522,25523,25582,25585,25609,25611,25613,25619,25622,25650,25651,25655,25660,25668,25678,25680,25682,25684,25685,25686,25687,25699,25700,25701,25707,25709,25712,25715,25716,25719,25720,25721,25725,25726,25728,25743,25750,25760,25789,25981,26073,26076,26126,26202,26252,26266,26451) AND `DifficultyID`=1); +UPDATE `creature_questitem` SET `VerifiedBuild`=54847 WHERE (`CreatureEntry`=25728 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25619 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=24563 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25726 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25415 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=25415 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25684 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25203 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=25203 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25210 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25720 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25721 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25514 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25387 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25682 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25700 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=24601 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25750 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25709 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=25709 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25204 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25350 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25355 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25668 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25351 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25585 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25707 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=25707 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=24613 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25725 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=24614 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=24614 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=26252 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25981 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25715 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=25715 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25701 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=26266 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25622 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25660 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=25660 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=26126 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25650 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25743 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=25743 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=24637 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25719 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25452 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=25452 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25760 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25209 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25651 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=26451 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=26202 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25699 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25522 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=26073 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25427 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25449 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25521 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25716 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25523 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25680 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25386 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25383 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25678 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25227 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25613 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25464 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25582 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25789 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25479 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=25479 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=25479 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25498 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25611 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=25611 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25392 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25686 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25496 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=25496 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25655 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25685 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25687 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25520 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=24562 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25294 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25712 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=26076 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25609 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=25445 AND `DifficultyID`=0 AND `Idx`=0); + +-- Models +UPDATE `creature_model_info` SET `VerifiedBuild`=54847 WHERE `DisplayID` IN (23331, 28050, 25252, 25195, 15435, 20736, 14886, 23333, 24960, 25256, 28828, 23329, 24915, 24916, 26716, 23082, 24567, 24566, 23556, 23573, 24961, 25225, 24140, 47635, 27478, 18695, 23332, 26870, 25530, 24387, 27729, 24126, 25198, 27731, 24389, 25529, 24386, 24384, 26361, 26345, 26343, 26344, 25532, 24388, 25531, 24390, 24391, 24385, 26665, 26666, 23241, 48650, 26500, 7919, 5231, 23655, 23681, 23348, 23349, 22249, 26286, 26702, 23652, 26703, 23649, 24881, 14698, 23510, 23242, 24826, 23103, 22506, 24880, 2606, 23554, 10005, 11402, 17308, 25514, 1065, 24992, 12818, 23483, 23352, 17311, 23272, 10914, 24564, 23327, 24855, 17252, 23301, 23312, 10612, 23330, 14700, 15958, 15962, 22608, 26658, 26765, 23644, 30562, 23433, 23650, 23271, 24125, 23651, 22600, 24000, 23645, 24004, 24012, 24014, 22599, 22595, 22121, 23499, 23653, 22610, 23643, 24011, 22592, 23555, 16988, 21688, 23351, 24038, 25668, 26127, 23278, 25633, 26126, 23392, 24025, 24027, 24026, 23300, 23913, 23563, 23571, 23366, 23343, 23313, 7847, 23307, 23294, 15880, 24997, 23303, 24996, 570, 11489, 775, 24114, 24947, 24108, 24119, 24103, 28065, 23188, 27191, 24873, 23263, 24053, 23220, 6888, 23324, 24051, 23956, 23354, 23264, 23953, 23935, 23957, 23965, 23367, 24851, 12231, 24852, 24853, 27192, 4589, 21999, 24253, 23116, 23341, 24457, 24456, 24258, 24254, 23163, 16998, 24263, 24259, 24257, 23164, 14502, 386, 5025, 5490, 5187, 25194, 22989, 757, 2597, 23004, 3940, 506, 3617, 22986, 15984, 32790, 391, 11293, 1305, 15369, 22987, 5243, 478, 346, 4920, 23000, 22984, 1994, 23362, 27578, 27280, 42781, 31126, 23378, 23955, 23967, 23368, 24006, 23968, 6774, 24008, 24005, 23365, 26510, 23464, 22633, 23403, 1070, 5488, 14514, 1762, 21975, 5450, 5561, 486, 540, 652, 23121, 23123, 23170, 23126, 23125, 23124, 23171, 23248, 23174, 23247, 23127, 23463, 23249, 23461, 23387, 23462, 23172, 23246, 23173, 24906, 25976, 23430, 22003, 23393, 20872, 23395, 29419, 23399, 23394, 23401, 23398, 23400, 25981, 25975, 25973, 25977, 23206, 23145, 23203, 24909, 23205, 23204, 24485, 24504, 24487, 24341, 24342, 24343, 24344, 24346, 23223, 24501, 24505, 24488, 24486, 24347, 24340, 6371, 24345, 23032, 23055, 16925, 26699, 12821, 23260, 23221, 25249, 22769, 23337, 23336, 27165, 23149, 23338, 26266, 23386, 23389, 23490, 26423, 23434, 23493, 23426, 26425, 23418, 23417, 28291, 23416, 23712, 21243, 23321, 23311, 23320, 328, 1557, 27714, 27712, 27713, 27717, 27715, 27716, 23282, 26575, 23496, 23388, 23497, 569, 218, 23512, 94, 1060, 22576, 88841, 22578, 23280, 22577, 88847, 23279, 12200, 23385, 24145, 24606, 24607, 23049, 23050, 3019, 24602, 24601, 23027, 24281, 24289, 23013, 23001, 28058, 23011, 24285, 23005, 23012, 24284, 1720, 2733, 23073, 23025, 4125, 23072, 29625, 29623, 17718, 17703, 23410, 23083, 22041, 22339, 24298, 23010, 25956, 23342, 23061, 23062, 24293, 338, 24280, 24295, 24288, 24290, 24291, 23063, 23026, 35701, 23052, 23065, 24283, 24600, 24297, 24287, 24294, 24282, 24296, 24818, 23064, 24821, 23066, 24819, 3422, 22999, 23402, 22998, 23273, 23274, 23035, 23068, 23409, 23883, 23077, 23031, 9758, 20216, 32791, 17582, 6766, 11253, 23553, 24382, 25632, 23237, 23384, 27185, 23197, 23169, 23198, 23427, 23492, 23491, 347, 15903, 24849, 24848, 27170, 23316, 22088, 32789, 22496, 15961, 22044, 27195, 27174, 23214, 17612, 10627, 23142, 23141, 23391, 25391, 25390, 45880, 25773, 25775, 25772, 25774, 23239, 23218, 23238, 999, 23118, 14661, 22199, 23184, 23182, 24274, 25092, 24256, 23179, 23183, 24471, 23181, 23289, 23288, 19595, 22181, 23285, 23299, 23873, 23283, 23286, 11686, 6122, 23287, 23284, 23485, 1072, 26268, 1236, 26297, 23039, 23185, 23186, 23275, 23196, 23194, 23195, 23193, 23147, 14589, 23167, 23115, 23047, 23176, 23201, 23014, 23053, 23117, 26296, 18657, 25237, 23152, 23151, 44108, 23150, 23016, 23880, 23048, 28059, 24638, 24639, 23054, 28001, 22873, 23021, 23006, 9509, 23502, 23046, 23042, 23040, 23036, 24170, 23488, 23508, 23505, 23916, 23037, 23038, 23075, 23041, 35702, 29626, 29624, 16213, 17722, 23044, 17720, 23022, 17721, 27685, 27687, 27684, 27686, 21342, 23045, 24185, 24212, 24214, 24197, 25946, 24192, 24194, 23079, 23024, 23078, 26063, 23074, 24220, 24218, 24219, 23007, 24215, 24216, 23015, 23018, 23819, 23019, 19283, 23017, 23210, 23076, 23043, 23501, 23009, 24183, 23023, 24180, 23080, 23008); +UPDATE `creature_model_info` SET `BoundingRadius`=0.450000017881393432, `VerifiedBuild`=54847 WHERE `DisplayID`=1079; +UPDATE `creature_model_info` SET `BoundingRadius`=0.975292801856994628, `CombatReach`=1.5, `VerifiedBuild`=54847 WHERE `DisplayID`=23304; +UPDATE `creature_model_info` SET `BoundingRadius`=0.729359745979309082, `CombatReach`=1, `VerifiedBuild`=54847 WHERE `DisplayID`=4973; +UPDATE `creature_model_info` SET `BoundingRadius`=1.086323738098144531, `VerifiedBuild`=54847 WHERE `DisplayID`=22123; +UPDATE `creature_model_info` SET `BoundingRadius`=0.74217301607131958, `VerifiedBuild`=54847 WHERE `DisplayID`=14732; +UPDATE `creature_template_model` SET `VerifiedBuild`=54847 WHERE (`Idx`=0 AND `CreatureID` IN (25709,26115,27859,26767,25767,27074,27067,25226,25204,25419,25350,25811,25355,24795,25827,26995,25607,25437,25402,25288,25405,35132,25459,27306,25849,25665,26600,25584,25724,25240,27012,25498,24567,25512,25611,25489,25272,32474,26945,30051,27569,25615,25786,25664,24021,25210,25309,26645,25198,25880,25342,25819,25321,27298,27302,25291,31790,25238,26987,25228,25829,25618,31685,25414,32565,18380,31725,31720,25728,27494,26219,71163,26186,25422,25606,24733,27063,27073,25292,25353,25431,24862,27299,26085,25501,25349,25244,26976,25256,25717,68845,26373,29965,26172,25472,26986,25666,25619,26599,24288,25862,26804,25748,27888,25679,25307,25222,29158,26248,25253,25450,25675,25438,25394,26078,29155,26977,27904,26110,27187,25390,25386,25383,25678,26725,25739,32544,26597,25339,25211,25847,62697,25791,25812,25364,26991,26990,25227,25613,25464,25504,25403,26941,24566,25719,25534,25493,26174,25452,24709,25760,25433,25199,25209,25206,25197,54242,25282,27385,25285,25651,26451,25836,25468,25466,27110,27106,27108,25421,25426,25361,47577,18378,32548,25712,27566,26173,32361,27860,26076,25396,24730,26160,24706,25736,25205,27138,27291,25828,26249,25435,28440,25481,25609,25445,25289,25274,26117,25722,129141,26187,25726,26766,26848,25374,25415,25442,25448,25733,25804,26098,26549,25297,18376,26993,25301,25511,25600,25278,25269,25075,26968,25713,25711,27189,25670,25758,26634,27058,34381,25793,35133,27365,27000,25582,25789,25479,25334,26538,32520,25716,27173,25314,25473,25516,25391,25490,21757,25434,25817,25732,62693,25271,27010,24921,25523,24662,26449,25680,25467,25624,26044,25276,27441,27906,45396,27529,26171,25377,25454,26721,25982,25702,25428,23837,25781,25215,25308,25810,27137,27300,25316,25743,31792,24637,26989,26155,25636,25797,24469,25470,27064,31724,26969,26109,26265,26213,27186,26170,25604,25477,25343,25727,25981,26083,25617,25251,26994,25310,25510,25503,25482,25672,25362,26047,25237,27440,25273,27046,26556,26162,25392,26697,25762,26768,25814,26619,25590,25416,25376,27301,25986,25686,25385,26084,25311,25313,24580,25496,25655,25487,25327,25280,25284,31807,26218,25684,26720,26790,25984,25752,26598,27065,25203,28375,25384,25841,25480,27393,32564,26988,25395,25234,25979,61158,25329,28150,25610,25379,25279,25242,29655,26175,27190,26191,26189,26202,26094,26157,25699,25652,25216,25335,25808,27271,25968,31789,25623,25843,25302,25522,25469,60761,32647,27432,25983,26709,26718,25685,19871,25201,26817,25417,25338,25441,25846,27142,25594,25356,25838,25687,31793,25281,24959,25520,25465,25475,25476,24562,25294,31727,26974,155076,25668,24702,24957,25430,25589,25217,25765,25881,25351,25322,18955,25585,18375,26879,25249,26452,24576,27107,25596,26975,25978,26980,25707,25492,25378,25601,26041,27999,25432,25418,25995,24613,27011,35131,25245,27364,47576,25250,25605,25333,25404,26981,31723,32357,24770,28195,27195,26169,27194,25715,25602,25701,26266,25764,25807,25622,25677,25660,26126,26596,25455,25845,27140,25850,29328,26161,25650,25839,25826,25239,24357,25299,27001,25317,25264,25669,25488,31726,25720,25721,26127,28960,27193,25514,26103,25387,25682,26996,26847,26104,25700,24601,25747,25429,25444,26602,26601,25750,25802,27147,27141,36155,25806,26999,25235,25241,25737,29617,25825,25380,25440,62695,26972,25286,25243,25718,26403,26185,26073,25658,25714,26159,25425,25427,25792,25809,25449,27143,25803,25219,25300,25816,25306,25521,25332,24771,25439,25328,35135,26982,25277,25275,33087,32534,28382,25471,26093,25393,25725,25705,25326,27069,26112,25780,25336,25262,25801,24614,26252,31788,25800,26997,385,208182,25671,25625,25446,26938,26043,27610,31805,26158,24703,26048,24563,25753,25208,25766,25443,27139,31791,25248,26992,15214,25298,26998,25220,24042,25381,25774,25513,25247,29233)) OR (`Idx`=3 AND `CreatureID` IN (25767,25198,25880,27073,25244,25361,28440,25271,25276,25215,26109,25617,25814,26619,25684,25979,61158,25610,25242,25216,25808,25469,25201,26817,25338,25217,25596,25660,25317,26601,25806,25286,25243,26159,25306,25275,208182,25220)) OR (`Idx`=2 AND `CreatureID` IN (25767,27074,25355,25198,25880,27073,25244,25361,27566,32361,28440,25271,25276,25215,24637,26109,25981,25617,25362,25814,26619,25684,25979,61158,25610,25242,25216,25808,25469,27432,25201,26817,25338,25217,25596,25715,25660,26126,25839,25317,26601,25806,25286,25243,26159,25306,25275,26112,208182,25625,25220)) OR (`Idx`=1 AND `CreatureID` IN (25767,27074,25419,25350,25355,25402,25405,27306,25665,24567,25512,27569,25664,24021,25309,26645,25198,25880,25342,25819,25321,25414,27073,25353,25431,24862,25501,25349,25244,26373,29965,26172,25472,25666,24288,26804,26248,25739,25847,25364,25403,25534,25493,54242,25651,25836,25468,25466,27110,27106,27108,25421,25361,27566,32361,26249,28440,25609,25415,25442,25511,27189,25670,34381,25479,32520,25473,25490,25271,24921,25467,25276,45396,27529,25428,23837,25215,25308,24637,26109,26265,25343,25981,25617,25310,25510,25672,25362,26047,26162,25814,26619,25496,25684,26790,27393,25234,25979,61158,25610,25242,29655,26175,26189,26094,26157,25216,25808,25968,25843,25469,32647,27432,19871,25201,26817,25417,25338,25441,25846,25594,24959,155076,25668,24957,25217,25351,25322,18955,27107,25596,25492,26041,27999,25995,25605,25404,25715,25764,25660,26126,25845,26161,25839,25317,25669,28960,25429,26601,36155,25806,25286,25243,26403,26159,25449,25219,25300,25306,24771,25439,25275,33087,25471,26093,25393,26112,208182,25671,25625,26043,25443,15214,25220,24042,25513)); + +-- Gameobject templates +DELETE FROM `gameobject_template` WHERE `entry`=385811; +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 +(385811, 10, 9011, 'Portal to the Azure Archives', '', '', '', 1.299999952316284179, 0, 0, 0, 3000, 0, 0, 1, 0, 0, 0, 405304, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 107651, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2424, 54847); -- Portal to the Azure Archives + +UPDATE `gameobject_template` SET `VerifiedBuild`=54847 WHERE `entry` IN (187388, 189979, 148544, 169278, 190547, 188131, 186844, 187316, 187240, 187856, 190536, 188113, 188164, 195034, 187900, 187995, 188029, 148540, 169288, 188013, 182071, 186842, 187880, 187867, 194687, 188140, 191225, 187885, 187886, 188085, 186836, 191075, 187870, 194694, 191832, 191228, 175544, 188025, 188027, 148567, 169264, 187565, 190546, 186837, 194953, 187450, 191081, 187189, 187249, 188521, 187237, 216714, 187320, 195035, 190342, 190334, 189316, 187454, 188030, 191304, 148554, 187241, 191082, 191699, 191697, 188102, 214523, 194026, 187318, 189329, 188038, 188044, 188022, 191089, 188014, 148556, 169292, 187247, 189978, 192052, 187868, 188092, 194692, 194685, 188087, 207492, 187261, 187456, 169284, 188015, 188656, 187863, 187860, 208632, 191287, 187432, 194688, 192053, 188088, 187367, 191090, 169266, 148550, 191370, 187558, 187187, 187694, 194693, 188106, 187984, 188032, 187376, 169289, 169267, 187258, 186835, 187852, 191073, 188657, 187854, 194690, 191636, 214507, 187677, 188108, 188031, 169281, 188112, 188016, 187184, 187243, 192046, 404905, 187858, 187862, 191635, 187695, 191698, 188007, 188006, 187364, 188005, 169290, 169269, 187772, 188018, 194682, 194683, 187321, 188004, 169270, 188008, 187859, 278347, 187884, 187659, 191637, 187387, 195033, 188003, 187986, 187697, 188034, 169282, 187568, 194677, 187448, 192051, 188653, 187864, 187855, 187660, 191639, 188133, 187999, 188651, 188043, 188000, 169280, 169277, 188028, 187889, 187244, 191070, 191074, 191080, 191076, 194689, 194684, 188100, 191142, 188141, 191303, 188037, 169285, 169275, 187259, 186841, 186840, 188692, 187658, 187251, 187248, 187866, 194696, 194691, 193602, 187317, 188002, 188033, 189287, 169273, 169268, 188104, 190194, 187449, 187246, 187188, 187902, 187250, 188655, 187861, 194686, 195032, 187319, 187901, 188652, 188035, 187996, 169283, 148547, 186839, 187980, 187560, 187106, 191078, 187185, 191638, 186238, 195031, 188612, 189315, 187897, 187268, 188042, 191088, 188001, 169279, 148549, 182072, 187239, 187433, 191288, 194025, 190335, 187899, 169272, 278574, 187851, 190193, 187245, 191072, 404907, 187871, 194681, 187693, 192573, 188089, 188454, 169265, 187453, 190169, 188017, 194954, 187447, 188010, 187857, 187773, 195030, 194680, 187314, 187322, 187373, 187997, 169271, 148551, 191079, 187909, 191077, 195029, 188514, 187315, 192033, 187998, 187898, 187255, 207528, 188041, 188040, 187915, 188026, 169276, 169274, 188163, 187256, 186838, 186843, 187186, 191542, 187872, 188091, 187661, 194695, 189317, 188036, 188039, 187982, 148557, 169293, 190548, 190287, 187082, 191071, 189973, 187452, 187655, 152614, 192572, 187085, 188024, 169287, 169291, 188012, 188084, 190556, 187242, 187873, 187874, 193981, 190352); +UPDATE `gameobject_template` SET `ContentTuningId`=44, `VerifiedBuild`=54847 WHERE `entry`=187690; -- En'kilah Cauldron +UPDATE `gameobject_template` SET `ContentTuningId`=44, `VerifiedBuild`=54847 WHERE `entry` IN (187369, 190567); -- Cage +UPDATE `gameobject_template` SET `ContentTuningId`=44, `VerifiedBuild`=54847 WHERE `entry`=187664; -- "Elder Takret" +UPDATE `gameobject_template` SET `ContentTuningId`=44, `VerifiedBuild`=54847 WHERE `entry`=187561; -- Arcane Prison +UPDATE `gameobject_template` SET `ContentTuningId`=44, `VerifiedBuild`=54847 WHERE `entry`=187663; -- "Elder Sagani" +UPDATE `gameobject_template` SET `ContentTuningId`=44, `VerifiedBuild`=54847 WHERE `entry`=187683; -- Pneumatic Tank Transjigamarig +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=23094, `ContentTuningId`=44, `VerifiedBuild`=54847 WHERE `entry`=187689; -- Crafty's Stuff +UPDATE `gameobject_template` SET `ContentTuningId`=44, `VerifiedBuild`=54847 WHERE `entry`=188120; -- Fields, Factories and Workshops +UPDATE `gameobject_template` SET `ContentTuningId`=44, `VerifiedBuild`=54847 WHERE `entry`=187905; -- Massive Glowing Egg +UPDATE `gameobject_template` SET `ContentTuningId`=44, `VerifiedBuild`=54847 WHERE `entry`=194151; -- Signal Fire +UPDATE `gameobject_template` SET `ContentTuningId`=44, `VerifiedBuild`=54847 WHERE `entry` IN (188101, 188103); -- Coldarra Geological Monitor +UPDATE `gameobject_template` SET `ContentTuningId`=44, `VerifiedBuild`=54847 WHERE `entry`=187389; -- Falling Rocks +UPDATE `gameobject_template` SET `ContentTuningId`=44, `VerifiedBuild`=54847 WHERE `entry`=187577; -- Warsong Banner +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=23085, `ContentTuningId`=44, `VerifiedBuild`=54847 WHERE `entry`=187671; -- Tuskarr Ritual Object +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=23093, `ContentTuningId`=44, `VerifiedBuild`=54847 WHERE `entry`=187684; -- Super Strong Metal Plate +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=23093, `ContentTuningId`=44, `VerifiedBuild`=54847 WHERE `entry`=187686; -- Super Strong Metal Plate +UPDATE `gameobject_template` SET `ContentTuningId`=44, `VerifiedBuild`=54847 WHERE `entry` IN (187987, 188109); -- South Point Station Valve +UPDATE `gameobject_template` SET `ContentTuningId`=44, `VerifiedBuild`=54847 WHERE `entry`=187879; -- Den of Dying Plague Cauldron +UPDATE `gameobject_template` SET `ContentTuningId`=44, `VerifiedBuild`=54847 WHERE `entry` IN (187985, 188107); -- North Point Station Valve +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=23085, `ContentTuningId`=44, `VerifiedBuild`=54847 WHERE `entry`=187670; -- Tuskarr Ritual Object +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=23093, `ContentTuningId`=44, `VerifiedBuild`=54847 WHERE `entry`=187685; -- Super Strong Metal Plate +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=62019, `ContentTuningId`=677, `VerifiedBuild`=54847 WHERE `entry`=244447; -- White Murloc Egg +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=23093, `ContentTuningId`=44, `VerifiedBuild`=54847 WHERE `entry`=187687; -- Super Strong Metal Plate +UPDATE `gameobject_template` SET `ContentTuningId`=44, `VerifiedBuild`=54847 WHERE `entry`=187881; -- Talramas Scourge Summoning Circle +UPDATE `gameobject_template` SET `ContentTuningId`=44, `VerifiedBuild`=54847 WHERE `entry`=187703; -- Kvaldir Inferno +UPDATE `gameobject_template` SET `ContentTuningId`=44, `VerifiedBuild`=54847 WHERE `entry`=187673; -- Farseer Grimwalker's Remains +UPDATE `gameobject_template` SET `ContentTuningId`=44, `VerifiedBuild`=54847 WHERE `entry`=187662; -- "Elder Kesuk" + +DELETE FROM `gameobject_template_addon` WHERE `entry`=385811; +INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES +(385811, 0, 262144, 0, 5605); -- Portal to the Azure Archives + +UPDATE `gameobject_template_addon` SET `faction`=35, `flags`=8192 WHERE `entry`=214523; -- Instance Portal (Raid 10/25 No Heroic) +UPDATE `gameobject_template_addon` SET `flags`=2113540 WHERE `entry`=187885; -- Gurgleboggle's Bauble +UPDATE `gameobject_template_addon` SET `flags`=2113540 WHERE `entry`=187886; -- Burblegobble's Bauble +UPDATE `gameobject_template_addon` SET `flags`=2113540 WHERE `entry`=187697; -- Crafty's Tools +UPDATE `gameobject_template_addon` SET `flags`=278528 WHERE `entry`=191303; -- Firethorn +UPDATE `gameobject_template_addon` SET `flags`=2113540 WHERE `entry`=187673; -- Farseer Grimwalker's Remains +UPDATE `gameobject_template_addon` SET `faction`=114, `WorldEffectID`=2773 WHERE `entry`=187376; -- NPC Fishing Bobber +UPDATE `gameobject_template_addon` SET `flags`=2113540 WHERE `entry`=187577; -- Warsong Banner +UPDATE `gameobject_template_addon` SET `flags`=278528 WHERE `entry`=189979; -- Rich Cobalt Deposit +UPDATE `gameobject_template_addon` SET `flags`=2113540 WHERE `entry`=188120; -- Fields, Factories and Workshops +UPDATE `gameobject_template_addon` SET `flags`=2113540 WHERE `entry`=188131; -- Wine Crate +UPDATE `gameobject_template_addon` SET `flags`=2113540 WHERE `entry`=187980; -- First Aid Supplies +UPDATE `gameobject_template_addon` SET `WorldEffectID`=2437 WHERE `entry`=244447; -- White Murloc Egg +UPDATE `gameobject_template_addon` SET `flags`=0 WHERE `entry`=191079; -- Campfire +UPDATE `gameobject_template_addon` SET `flags`=4 WHERE `entry`=187905; -- Massive Glowing Egg +UPDATE `gameobject_template_addon` SET `flags`=0 WHERE `entry`=187909; -- Coldrock Clam +UPDATE `gameobject_template_addon` SET `flags`=2113540 WHERE `entry`=187683; -- Pneumatic Tank Transjigamarig +UPDATE `gameobject_template_addon` SET `flags`=1048608 WHERE `entry`=208632; -- Coldarra Disc +UPDATE `gameobject_template_addon` SET `flags`=36 WHERE `entry`=187884; -- Evanor's Prison + +UPDATE `gameobject_questitem` SET `VerifiedBuild`=54847 WHERE (`Idx`=0 AND `GameObjectEntry` IN (188140,187885,187886,187899,187673,188113,188164,187900,187689,187577,187671,188017,188120,188131,188015,187901,187980,187902,187683,187897,187687,187685,187677,188016,187684,188018,187686,187697,187670,187660,187659,187898,187661)); |