DB/Creature: Update stats & auras of some creatures

(cherry picked from commit cce23a2d4b5e01db4d88c9e7a77cf3054b23f6f0)

1 files changed, 271 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_03_05_12_world_2020_12_23_03_world.sql b/sql/updates/world/master/2022_03_05_12_world_2020_12_23_03_world.sql
new file mode 100644
index 00000000000..42ebc9d8cfe
--- /dev/null
+++ b/sql/updates/world/master/2022_03_05_12_world_2020_12_23_03_world.sql
@@ -0,0 +1,271 @@
+--
+UPDATE `creature_model_info` SET `BoundingRadius`=0.004999999888241291, `CombatReach`=0.009999999776482582 WHERE `DisplayID`=13069;
+
+DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (39717,39715,39716,12786,12787,29668,29671,34952,29669,29670,34953,15650,28714,28701,32514,28721,28715,28727,28723,32516,29478,29491,29812,29714,28989,31851,28951,28776,29528,29497));
+
+UPDATE `creature_addon` SET `auras`='18950' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 26253);
+UPDATE `creature_addon` SET `auras`='16428' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 11896); -- 11896 (Borelgore) - Virulent Poison Proc
+UPDATE `creature_addon` SET `auras`='18950' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 16378); -- 16378 (Argent Sentry) - Invisibility and Stealth Detection
+
+DELETE FROM `creature_template_addon` WHERE `entry` IN (39717 /*39717 (Shooting Mechano-Tank) - Freeze Anim*/, 39715 /*39715 (Ejector Mechano-Tank) - Freeze Anim*/, 39675 /*39675 (Captain Tread Sparknozzle) - [DND] Persuaded*/, 39716 /*39716 (Scuttling Mechano-Tank) - Freeze Anim*/, 19445 /*19445 (Wounded Soldier) - Invisibility and Stealth Detection*/, 26253 /*26253 (Shattered Sun Peacekeeper) - Invisibility and Stealth Detection*/);
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(39717, 0, 0, 0, 1, 0, '16245 25900'), -- 39717 (Shooting Mechano-Tank) - Freeze Anim
+(39715, 0, 0, 0, 1, 0, '16245 25900'), -- 39715 (Ejector Mechano-Tank) - Freeze Anim
+(39675, 0, 0, 0, 1, 0, '73954'), -- 39675 (Captain Tread Sparknozzle) - [DND] Persuaded
+(39716, 0, 0, 0, 1, 0, '16245 25900'), -- 39716 (Scuttling Mechano-Tank) - Freeze Anim
+(19445, 0, 0, 7, 1, 0, '18950'), -- 19445 (Wounded Soldier) - Invisibility and Stealth Detection
+(26253, 0, 0, 0, 1, 0, '18950'); -- 26253 (Shattered Sun Peacekeeper) - Invisibility and Stealth Detection
+
+UPDATE `creature_template_addon` SET `bytes2`=257, `auras`='5301' WHERE `entry`=12786; -- 12786 (Guard Quine)
+UPDATE `creature_template_addon` SET `bytes2`=257, `auras`='5301' WHERE `entry`=12787; -- 12787 (Guard Hammon)
+UPDATE `creature_template_addon` SET `auras`='28782' WHERE `entry`=29668;
+UPDATE `creature_template_addon` SET `auras`='28782' WHERE `entry`=29671;
+UPDATE `creature_template_addon` SET `auras`='28782' WHERE `entry`=34952;
+UPDATE `creature_template_addon` SET `auras`='28782' WHERE `entry`=29669;
+UPDATE `creature_template_addon` SET `auras`='28782' WHERE `entry`=29670;
+UPDATE `creature_template_addon` SET `auras`='28782' WHERE `entry`=29667;
+UPDATE `creature_template_addon` SET `auras`='28782' WHERE `entry`=29673;
+UPDATE `creature_template_addon` SET `auras`='28782' WHERE `entry`=29675;
+UPDATE `creature_template_addon` SET `auras`='28782' WHERE `entry`=34953;
+UPDATE `creature_template_addon` SET `auras`='16575' WHERE `entry`=8535; -- 8535 (Putrid Shrieker)
+UPDATE `creature_template_addon` SET `auras`='29119' WHERE `entry`=15650; -- 15650 (Crazed Dragonhawk)
+UPDATE `creature_template_addon` SET `auras`='12896' WHERE `entry`=5993; -- 5993 (Helboar)
+UPDATE `creature_template_addon` SET `auras`='32008' WHERE `entry`=18944; -- 18944 (Fel Soldier)
+UPDATE `creature_template_addon` SET `auras`='18950' WHERE `entry`=19446; -- 19446 (Operations Officer)
+UPDATE `creature_template_addon` SET `auras`='18950' WHERE `entry`=20513; -- 20513 (Honor Hold Defender)
+UPDATE `creature_template_addon` SET `auras`='18950' WHERE `entry`=17557; -- 17557 (Lieutenant Chadwick)
+UPDATE `creature_template_addon` SET `auras`='18950' WHERE `entry`=19392; -- 19392 (Watch Commander Leonus)
+UPDATE `creature_template_addon` SET `auras`='18950' WHERE `entry`=17479; -- 17479 (Gunny)
+UPDATE `creature_template_addon` SET `auras`='60913' WHERE `entry`=28714; -- 28714 (Ildine Sorrowspear)
+UPDATE `creature_template_addon` SET `auras`='50200' WHERE `entry`=28701; -- 28701 (Timothy Jones)
+UPDATE `creature_template_addon` SET `auras`='60913' WHERE `entry`=32514; -- 32514 (Vanessa Sellers)
+UPDATE `creature_template_addon` SET `auras`='60913' WHERE `entry`=28721; -- 28721 (Tiffany Cartier)
+UPDATE `creature_template_addon` SET `auras`='60913' WHERE `entry`=28715; -- 28715 (Endora Moorehead)
+UPDATE `creature_template_addon` SET `auras`='60913' WHERE `entry`=33027; -- 33027 (Jessica Sellers)
+UPDATE `creature_template_addon` SET `auras`='60913' WHERE `entry`=28727; -- 28727 (Edward Egan)
+UPDATE `creature_template_addon` SET `auras`='60913' WHERE `entry`=28723; -- 28723 (Larana Drome)
+UPDATE `creature_template_addon` SET `auras`='55474' WHERE `entry`=32516; -- 32516 (Washed-Up Mage)
+UPDATE `creature_template_addon` SET `auras`='60913' WHERE `entry`=29478; -- 29478 (Jepetto Joybuzz)
+UPDATE `creature_template_addon` SET `auras`='60913' WHERE `entry`=29491; -- 29491 (Karandonna)
+UPDATE `creature_template_addon` SET `auras`='28782' WHERE `entry`=29812; -- 29812 ([DND] Dalaran Toy Store Plane String Bunny)
+UPDATE `creature_template_addon` SET `auras`='60913' WHERE `entry`=29714; -- 29714 (Lucian Trias)
+UPDATE `creature_template_addon` SET `auras`='60913' WHERE `entry`=28989; -- 28989 (Aemara)
+UPDATE `creature_template_addon` SET `auras`='60190' WHERE `entry`=31851; -- 31851 (Wooly Mammoth)
+UPDATE `creature_template_addon` SET `auras`='60913' WHERE `entry`=28951; -- 28951 (Breanni)
+UPDATE `creature_template_addon` SET `auras`='60913' WHERE `entry`=28776; -- 28776 (Elizabeth Ross)
+UPDATE `creature_template_addon` SET `auras`='60913' WHERE `entry`=29528; -- 29528 (Debbi Moore)
+UPDATE `creature_template_addon` SET `auras`='60913' WHERE `entry`=29497; -- 29497 (Walther Whiteford)
+UPDATE `creature_template_addon` SET `auras`='11984' WHERE `entry`=5858; -- 5858 (Greater Lava Spider)
+UPDATE `creature_template_addon` SET `auras`='7276' WHERE `entry`=2260; -- 2260 (Syndicate Rogue)
+UPDATE `creature_template_addon` SET `auras`='3417' WHERE `entry`=24819; -- 24819 (Anvilrage Enforcer)
+
+UPDATE `creature_template_addon` SET `auras`='11441' WHERE `entry`=8606; -- 8606 (Living Decay)
+UPDATE `creature_template` SET `AIName` = "" WHERE `entry` = 8606;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 8606 AND `source_type` = 0;
+
+UPDATE `creature_template_addon` SET `auras`='8247' WHERE `entry`=1824; -- 1824 (Plague Lurker)
+UPDATE `creature_template` SET `AIName` = "" WHERE `entry` = 1824;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 1824 AND `source_type` = 0;
+
+UPDATE `creature_template_addon` SET `auras`='11964' WHERE `entry`=5983; -- 5983 (Bonepicker Felfeeder)
+UPDATE `creature_template` SET `AIName` = "" WHERE `entry` = 5983;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 5983 AND `source_type` = 0;
+
+UPDATE `creature_template_addon` SET `auras`='18950' WHERE `entry`=19444; -- 19444 (Peasant Worker)
+UPDATE `creature_addon` SET `auras`='18950' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 19444);
+
+UPDATE `creature_template_addon` SET `auras`='18950' WHERE `entry`=16842; -- 16842 (Honor Hold Defender)
+UPDATE `creature_addon` SET `auras`='18950' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 16842);
+
+UPDATE `creature_template_addon` SET `auras`='5301' WHERE `entry`=19687; -- 19687 (Shattrath City Peacekeeper)
+UPDATE `creature_addon` SET `auras`='5301' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 19687);
+
+UPDATE `creature_template` SET `AIName` = "SmartAI" WHERE `entry` = 32169;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 32169 AND `source_type` = 0;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(32169,0,0,0,1,0,100,0,0,0,30000,30000,0,11,12544,32,0,0,0,0,1,0,0,0,0,0,0,0,0,"Arcanist Braedin - Out of Combat - Cast 'Frost Armor'");
+
+UPDATE `creature_template_addon` SET `auras`='18950' WHERE `entry`=32724; -- 32724 (Warmage Mumplina)
+UPDATE `creature_addon` SET `auras`='18950' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 32724);
+
+UPDATE `creature_template` SET `AIName` = "SmartAI" WHERE `entry` = 32724;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 32724 AND `source_type` = 0;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(32724,0,0,0,1,0,100,0,0,0,30000,30000,0,11,12544,32,0,0,0,0,1,0,0,0,0,0,0,0,0,"Warmage Mumplina - Out of Combat - Cast 'Frost Armor'");
+
+UPDATE `creature_template_addon` SET `auras`='18950' WHERE `entry`=32722; -- 32722 (Warmage Lukems)
+UPDATE `creature_addon` SET `auras`='18950' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 32722);
+
+UPDATE `creature_template` SET `AIName` = "SmartAI" WHERE `entry` = 32722;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 32722 AND `source_type` = 0;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(32722,0,0,0,1,0,100,0,0,0,30000,30000,0,11,12544,32,0,0,0,0,1,0,0,0,0,0,0,0,0,"Warmage Lukems - Out of Combat - Cast 'Frost Armor'");
+
+-- Dup
+DELETE FROM `creature` WHERE `guid` = 104493 AND `id` = 32606;
+UPDATE `creature_template` SET `AIName` = "SmartAI" WHERE `entry` = 32606;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 32606 AND `source_type` = 0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` BETWEEN 3260600 AND 3260604 AND `source_type` = 9;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(32606,0,0,0,11,0,100,0,0,0,0,0,0,88,3260600,3260604,0,0,0,0,1,0,0,0,0,0,0,0,0,"[DND] Cosmetic Book - On Respawn - Run Random Script"),
+
+(3260600,9,0,0,0,0,100,0,0,0,0,0,0,11,61378,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"[DND] Cosmetic Book - On Script - Cast '[DND] Dalaran - Book_Dwarf_01 Visual'"),
+(3260601,9,0,0,0,0,100,0,0,0,0,0,0,11,61403,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"[DND] Cosmetic Book - On Script - Cast '[DND] Dalaran - Book_Human_01 Visual'"),
+(3260602,9,0,0,0,0,100,0,0,0,0,0,0,11,61404,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"[DND] Cosmetic Book - On Script - Cast '[DND] Dalaran - Book_Human_03 Visual'"),
+(3260603,9,0,0,0,0,100,0,0,0,0,0,0,11,61405,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"[DND] Cosmetic Book - On Script - Cast '[DND] Dalaran -  Book_Human_04 Visual'"),
+(3260604,9,0,0,0,0,100,0,0,0,0,0,0,11,61406,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"[DND] Cosmetic Book - On Script - Cast '[DND] Dalaran - Book_Troll_02 Visual'");
+
+UPDATE `creature_template` SET `AIName` = "SmartAI" WHERE `entry` = 32170;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 32170 AND `source_type` = 0;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(32170,0,0,0,1,0,100,0,0,0,30000,30000,0,11,12544,32,0,0,0,0,1,0,0,0,0,0,0,0,0,"Magister Surdiel - Out of Combat - Cast 'Frost Armor'");
+
+UPDATE `creature_template_addon` SET `auras`='13589' WHERE `entry`=24818; -- 24818 (Anvilrage Taskmaster)
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 24818 AND `source_type` = 0 AND `id` = 1;
+
+UPDATE `creature_template_addon` SET `auras`='5301' WHERE `entry`=1423; -- 1423 (Stormwind Guard)
+UPDATE `creature_addon` SET `auras`='5301' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 1423);
+
+UPDATE `creature_template_addon` SET `bytes2`=257, `auras`='18950' WHERE `entry`=14423; -- 14423 (Officer Jaxon)
+UPDATE `creature_addon` SET `bytes2`=257, `auras`='18950' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 14423);
+
+UPDATE `creature_template` SET `AIName` = "SmartAI" WHERE `entry` = 35596;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 35596 AND `source_type` = 0;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(35596,0,0,0,1,0,100,0,0,0,30000,30000,0,11,12544,32,0,0,0,0,1,0,0,0,0,0,0,0,0,"Arcanist Iramhir - Out of Combat - Cast 'Frost Armor'");
+
+DELETE FROM `creature_template_addon` WHERE `entry` IN (16354);
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(16354, 0, 0, 0, 1, 0, '29363'); -- 16354 (Vampiric Mistbat) - Draining Touch
+DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (16354));
+UPDATE `creature_template` SET `AIName` = "" WHERE `entry` = 16354;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 16354 AND `source_type` = 0;
+
+DELETE FROM `creature_template_addon` WHERE `entry` IN (8532);
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(8532, 0, 0, 0, 1, 0, '8876 12539'); -- 8532 (Diseased Flayer) - Thrash, Ghoul Rot
+DELETE FROM `creature_addon` WHERE `path_id` = 0 AND `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (8532));
+UPDATE `creature_addon` SET `bytes2`=1, `auras`='8876 12539' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 8532);
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 8532 AND `source_type` = 0 AND `id` = 1;
+
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 8546 AND `source_type` = 0 AND `id` = 2;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(8546,0,2,0,25,0,100,0,0,0,0,0,0,11,3417,32,0,0,0,0,1,0,0,0,0,0,0,0,0,"Dark Adept - On Reset - Cast 'Thrash'");
+
+-- No stealth
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 8539 AND `source_type` = 0 AND `id` = 2; -- 8539 (Eyeless Watcher) - Stealth Detection
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 8538 AND `source_type` = 0 AND `id` = 2; -- 8538 (Unseen Servant) - Stealth Detection
+
+UPDATE `creature_template` SET `unit_flags`=33554432 WHERE `entry`=29812; -- [DND] Dalaran Toy Store Plane String Bunny
+UPDATE `creature_template` SET `unit_flags`=32768 WHERE `entry`=12779; -- Archmage Gaiman
+UPDATE `creature_template` SET /*`minlevel`=75, `maxlevel`=75,*/ `unit_flags`=32768 WHERE `entry`=12786; -- Guard Quine
+UPDATE `creature_template` SET /*`minlevel`=75, `maxlevel`=75,*/ `unit_flags`=32768 WHERE `entry`=12787; -- Guard Hammon
+UPDATE `creature_template` SET `unit_flags`=32768 WHERE `entry`=19848; -- Harbinger Ennarth
+UPDATE `creature_template` SET `unit_flags`=32768 WHERE `entry`=12784; -- Lieutenant Jackspring
+UPDATE `creature_template` SET `unit_flags`=32768 WHERE `entry`=12778; -- Lieutenant Rachel Vaccar
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=35477; -- Little Adeline
+UPDATE `creature_template` SET `unit_flags`=32768 WHERE `entry`=12785; -- Sergeant Major Clate
+UPDATE `creature_template` SET `unit_flags`=32768 WHERE `entry`=12780; -- Sergeant Major Skyshadow
+UPDATE `creature_template` SET `unit_flags`=32768 WHERE `entry`=12781; -- Master Sergeant Biggins
+UPDATE `creature_template` SET `unit_flags`=33024 WHERE `entry`=39678; -- Toby Zeigear
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=7955; -- Milli Featherwhistle
+UPDATE `creature_template` SET `unit_flags`=33024 WHERE `entry`=39368; -- Drill Sergeant Steamcrank
+UPDATE `creature_template` SET `unit_flags`=256 WHERE `entry`=39717; -- Shooting Mechano-Tank
+UPDATE `creature_template` SET `unit_flags`=33024 WHERE `entry`=39275; -- Gnomeregan Medic
+UPDATE `creature_template` SET /*`minlevel`=40, `maxlevel`=40,*/ `unit_flags`=768 WHERE `entry`=39396; -- 'Thunderflash'
+UPDATE `creature_template` SET `unit_flags`=33024 WHERE `entry`=39386; -- Pilot Muzzlesprock
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=39715; -- Ejector Mechano-Tank
+UPDATE `creature_template` SET `unit_flags`=33024 WHERE `entry`=39675; -- Captain Tread Sparknozzle
+UPDATE `creature_template` SET `unit_flags`=256 WHERE `entry`=39716; -- Scuttling Mechano-Tank
+UPDATE `creature_template` SET /*`minlevel`=8, `maxlevel`=10,*/ `unit_flags`=33536 WHERE `entry`=39349; -- Gnomeregan Trainee
+UPDATE `creature_template` SET `gossip_menu_id`=6944 WHERE `entry`=37888; -- Frax Bucketdrop
+-- UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=17984; -- Power Source Invisible Bunny
+UPDATE `creature_template` SET `unit_flags`=0, `unit_flags2`=0 WHERE `entry`=25031; -- Pit Overlord
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=25033; -- Eredar Sorcerer
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=24972; -- Erratic Sentry
+-- UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=25172; -- Archmage Invisible Target
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=33536 WHERE `entry`=25163; -- Anchorite Kairthos
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=25108; -- Vindicator Kaalan
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=25035; -- Tyrael Flamekissed
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=33536 WHERE `entry`=25043; -- Sereth Duskbringer
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=25039; -- Kaalif
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=33536 WHERE `entry`=24975; -- Mar'nah
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=33536 WHERE `entry`=25950; -- Shaani
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=26092; -- Soryn
+UPDATE `creature_template` SET `unit_flags`=33554432, `unit_flags2`=2050 WHERE `entry`=25192; -- Bridge Marksman Target Bunny
+UPDATE `creature_template` SET `unit_flags`=32768 WHERE `entry`=24960; -- Wretched Devourer
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=33536 WHERE `entry`=25045; -- Sentinel
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=33536 WHERE `entry`=25112; -- Anchorite Ayuri
+UPDATE `creature_template` SET `RangeAttackTime`=2000, `unit_flags`=33536 WHERE `entry`=25037; -- Seraphina Bloodheart
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=25036; -- Caregiver Inaara
+-- UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=24980; -- Crystal Ward
+-- UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=24991; -- Converted Sentry Credit
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=25133; -- Astromancer Darnarian
+UPDATE `creature_template` SET `unit_flags`=33024 WHERE `entry`=25115; -- Shattered Sun Warrior (512 if tempsummon or something like that)
+UPDATE `creature_template` SET `unit_flags`=33024 WHERE `entry`=24938; -- Shattered Sun Marksman (512 if tempsummon or something like that)
+-- UPDATE `creature_template` SET `minlevel`=55 WHERE `entry`=7671; -- Servant of Sevine
+UPDATE `creature_template` SET `unit_flags`=33024 WHERE `entry`=18969; -- Melgromm Highmountain
+UPDATE `creature_template` SET `unit_flags`=33024 WHERE `entry`=18986; -- Ironforge Paladin
+UPDATE `creature_template` SET `unit_flags`=33024 WHERE `entry`=18972; -- Orgrimmar Shaman
+UPDATE `creature_template` SET `BaseAttackTime`=2000, `unit_flags`=33024 WHERE `entry`=18950; -- Orgrimmar Grunt
+UPDATE `creature_template` SET `unit_flags`=33024 WHERE `entry`=18966; -- Justinius the Harbinger
+UPDATE `creature_template` SET `unit_flags`=33024 WHERE `entry`=18970; -- Darkspear Axe Thrower
+UPDATE `creature_template` SET `unit_flags`=33024 WHERE `entry`=18965; -- Darnassian Archer
+UPDATE `creature_template` SET `unit_flags`=33024 WHERE `entry`=18948; -- Stormwind Soldier
+UPDATE `creature_template` SET `unit_flags`=33554688 WHERE `entry`=21075; -- Infernal Target (Hyjal)
+UPDATE `creature_template` SET `unit_flags`=33554688 WHERE `entry`=16897; -- Honor Hold Target Dummy Middle
+-- UPDATE `creature_template` SET `maxlevel`=60 WHERE `entry`=16866; -- Injured Nethergarde Infantry
+UPDATE `creature_template` SET `BaseAttackTime`=2000 WHERE `entry`=18827; -- Gan'arg Sapper
+UPDATE `creature_template` SET `unit_flags`=33554432, `unit_flags2`=2048 WHERE `entry`=18729; -- Infernal Rain (Hellfire)
+-- UPDATE `creature_template` SET `minlevel`=62 WHERE `entry`=18539; -- Ashkaz
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=25580; -- Old Man Barlo
+UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=18750; -- Shimmerscale Eel
+UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=25143; -- Shattered Sun Veteran
+UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=25135; -- Shattered Sun Trainee
+UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=25136; -- Shattered Sun Trainee
+UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=25134; -- Shattered Sun Trainee
+UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=25137; -- Shattered Sun Trainee
+UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=25142; -- Shattered Sun Marksman
+UPDATE `creature_template` SET `speed_run`=2.285714387893676757 WHERE `entry`=25246; -- Lady Liadrin
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=29668; -- Arathi Basin Portal
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=29671; -- Strand of the Ancients Portal
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=34952; -- Isle of Conquest Portal
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=29669; -- Alterac Valley Portal
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=29670; -- Eye of the Storm Portal
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=29667; -- Warsong Gulch Portal
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=29641; -- Theresa Wolf
+UPDATE `creature_template` SET `speed_run`=1.428571462631225585 WHERE `entry`=32653; -- Wounded Dalaran Serpent
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=28714; -- Ildine Sorrowspear
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=28706; -- Olisarra the Kind
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=29628; -- Angelique Butler
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=28995; -- Paldesse
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=28704; -- Dorothy Egan
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=32744; -- Bakor the Gangly
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=28716; -- Palja Amboss
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=35498; -- Horace Hunderland
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=29505; -- Imindril Spearsong
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=35496; -- Rueben Lauren
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=32731; -- Metopious Loreseeker
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378, `unit_flags2`=0 WHERE `entry`=32333; -- "Dapper" Danik Blackshaft
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=28990; -- Anthony Durain
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=32332; -- Ramik Slamwrench
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=32329; -- Kanika Goldwell
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=29703; -- Sheddle Glossgleam
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=29673; -- Arathi Basin Portal
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=28708; -- Kizi Copperclip
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=29675; -- Eye of the Storm Portal
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=34953; -- Isle of Conquest Portal
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=29478; -- Jepetto Joybuzz
+UPDATE `creature_template` SET `speed_run`=1 WHERE `entry`=29802; -- Cosmetic Toy Plane
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=32676; -- Grindle Firespark
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=32680; -- Fabioso the Fabulous
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=32678; -- Emeline Fizzlefry
+UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=0.992062866687774658 WHERE `entry`=31755; -- Stabled Hunter Pet
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=28687; -- Amisi Azuregaze
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=31769; -- Stabled Hunter Pet
+UPDATE `creature_template` SET `unit_flags2`=2050 WHERE `entry`=35608; -- [DND] Dalaran Argent Tournament Herald Bunny
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=29255; -- Sunreaver Guardian Mage
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=32689; -- Adorean Lew
+UPDATE `creature_template` SET `speed_run`=0.952381432056427001 WHERE `entry`=31768; -- Stabled Hunter Pet
+UPDATE `creature_template` SET `speed_run`=0.857142865657806396 WHERE `entry`=30095; -- Dalaran Sewer Turtle
+UPDATE `creature_template` SET `unit_flags`=33555200 WHERE `entry`=37853; -- Instructor Razuvious Image