diff options
| -rw-r--r-- | sql/updates/world/master/2017_05_25_01_world.sql | 328 |
1 files changed, 328 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_05_25_01_world.sql b/sql/updates/world/master/2017_05_25_01_world.sql new file mode 100644 index 00000000000..b2b1aefcd50 --- /dev/null +++ b/sql/updates/world/master/2017_05_25_01_world.sql @@ -0,0 +1,328 @@ +UPDATE `creature_template` SET `minlevel`= 110,`maxlevel`= 110 WHERE `entry` IN (84700, 84495, 85829, 84509, 90960, 29137, 82511, 97860); +UPDATE `creature_template` SET `minlevel`= 72,`maxlevel`= 72 WHERE `entry` IN (2833); +UPDATE `creature_template` SET `minlevel`= 91,`maxlevel`= 91 WHERE `entry` IN (72313); +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1 WHERE `entry`=31485; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1 WHERE `entry`=31489; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1 WHERE `entry`=31499; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=32313; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33070; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=32846; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33694; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33147; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33693; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33149; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33148; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33154; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=33360; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=33392; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=33393; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=33391; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33692; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33909; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=33910; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33911; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=34215; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=34045; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=34003; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33190; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33191; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=34332; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=34111; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1075838976 WHERE `entry`=33724; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33234; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=34113; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=34105; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=34257; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33449; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=34256; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33955; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=33885; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33995; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33729; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33737; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33732; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33731; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=34106; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=34175; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33735; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33734; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33741; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33733; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=34108; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=34109; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33700; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33723; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33757; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33758; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33773; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=34255; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33827; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33829; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33830; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33828; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33832; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33831; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=33954; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=34166; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=34185; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=34186; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=34201; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=34162; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=34165; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=34229; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=34216; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=34245; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=34226; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=34236; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=34237; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=34235; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=35413; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=35403; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=36085; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=36084; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=35517; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=35490; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=36089; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=35518; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=35438; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=35439; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=35440; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=35514; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=35515; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=35516; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=35511; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=35512; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=35513; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=35447; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=35448; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=35449; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=35216; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=35268; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=35269; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=35429; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=35410; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=35427; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=35415; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=35431; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=35421; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=35433; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=36358; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1 WHERE `entry`=31485; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1 WHERE `entry`=31489; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=36357; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=35419; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=35417; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=35436; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=35405; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=36087; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=36086; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=36083; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=36082; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=36088; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=37627; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=37629; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=37613; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=36498; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=37677; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=37957; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=37958; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=37959; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=36938; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=37720; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38058; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=37609; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38075; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38073; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38076; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38072; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38074; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=37644; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=37612; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=37637; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38106; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38296; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38297; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=37656; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=37622; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=37641; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=37642; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=37636; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=37639; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=37611; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38082; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38086; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38079; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38031; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38061; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38059; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38081; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38078; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38083; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38080; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38094; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38092; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38091; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38090; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38087; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38088; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38096; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38097; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38093; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38084; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38089; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=38129; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=38701; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=38702; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38444; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=38128; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=38699; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=38700; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38481; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38445; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38446; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38025; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38026; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=37731; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=37730; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38402; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38582; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38583; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=37504; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=37505; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=37506; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38390; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38549; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38550; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38431; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38585; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38586; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38062; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38063; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38418; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38098; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38100; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38102; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38480; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38099; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38101; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38479; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38434; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38435; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38436; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|6291457 WHERE `entry`=38401; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|6291457 WHERE `entry`=38784; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|6291457 WHERE `entry`=38785; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38641; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38773; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38774; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38404; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38679; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38680; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2099200 WHERE `entry`=38262; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2099200 WHERE `entry`=38683; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2099200 WHERE `entry`=38684; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38403; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38675; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38676; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38405; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38681; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38682; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38095; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38257; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38677; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38678; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|3145728 WHERE `entry`=38174; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=38220; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=38219; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38298; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38299; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38303; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38304; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=38258; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1 WHERE `entry`=38126; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=38000; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1 WHERE `entry`=38131; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=38265; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=38266; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=38267; +UPDATE `creature_template` SET `minlevel`= 110,`maxlevel`= 110 WHERE `entry` IN (90556); +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=39666; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=39680; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=39699; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=39701; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=39706; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=49066; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1 WHERE `entry`=39991; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=49080; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=49096; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=49064; +UPDATE `creature_template` SET `type`=15 WHERE `entry`=49064; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=49082; +UPDATE `creature_template` SET `type`=15 WHERE `entry`=49082; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=40818; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=49072; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=49103; +UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216 WHERE `entry`=51101; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=49654; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=49624; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=49538; +UPDATE `creature_template` SET `family`=68 WHERE `entry`=47774; +UPDATE `creature_template` SET `family`=68 WHERE `entry`=47775; +UPDATE `creature_template` SET `family`=68 WHERE `entry`=47776; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=49642; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=49097; +UPDATE `creature_template` SET `type`=1 WHERE `entry`=49097; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=49100; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=49101; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=49708; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=49711; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=49712; +UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216 WHERE `entry`=48804; +UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216 WHERE `entry`=48803; +UPDATE `creature_template` SET `minlevel`= 110,`maxlevel`= 110 WHERE `entry` IN (76850, 96565); +UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216 WHERE `entry`=48913; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=54044; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=54045; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=54046; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=54056; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=54057; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=53973; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=54059; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|526336 WHERE `entry`=57359; +UPDATE `creature_template` SET `type`=15 WHERE `entry`=57359; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|526336 WHERE `entry`=57360; +UPDATE `creature_template` SET `type`=15 WHERE `entry`=57360; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|526336 WHERE `entry`=57361; +UPDATE `creature_template` SET `type`=15 WHERE `entry`=57361; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|524288 WHERE `entry`=57374; +UPDATE `creature_template` SET `type`=15 WHERE `entry`=57374; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|524288 WHERE `entry`=57375; +UPDATE `creature_template` SET `type`=15 WHERE `entry`=57375; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|524288 WHERE `entry`=57376; +UPDATE `creature_template` SET `type`=15 WHERE `entry`=57376; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|524288 WHERE `entry`=57368; +UPDATE `creature_template` SET `type`=15 WHERE `entry`=57368; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|524288 WHERE `entry`=57369; +UPDATE `creature_template` SET `type`=15 WHERE `entry`=57369; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|524288 WHERE `entry`=57370; +UPDATE `creature_template` SET `type`=15 WHERE `entry`=57370; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|524288 WHERE `entry`=57365; +UPDATE `creature_template` SET `type`=15 WHERE `entry`=57365; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|524288 WHERE `entry`=57366; +UPDATE `creature_template` SET `type`=15 WHERE `entry`=57366; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|524288 WHERE `entry`=57367; +UPDATE `creature_template` SET `type`=15 WHERE `entry`=57367; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|524288 WHERE `entry`=57362; +UPDATE `creature_template` SET `type`=15 WHERE `entry`=57362; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|524288 WHERE `entry`=57363; +UPDATE `creature_template` SET `type`=15 WHERE `entry`=57363; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|524288 WHERE `entry`=57364; +UPDATE `creature_template` SET `type`=15 WHERE `entry`=57364; +UPDATE `creature_template` SET `type`=15 WHERE `entry`=57434; +UPDATE `creature_template` SET `type`=15 WHERE `entry`=57435; +UPDATE `creature_template` SET `type`=15 WHERE `entry`=57436; +UPDATE `creature_template` SET `type`=15 WHERE `entry`=57425; +UPDATE `creature_template` SET `type`=15 WHERE `entry`=57426; +UPDATE `creature_template` SET `type`=15 WHERE `entry`=57427; +UPDATE `creature_template` SET `type`=15 WHERE `entry`=57428; +UPDATE `creature_template` SET `type`=15 WHERE `entry`=57430; |