diff options
| -rw-r--r-- | sql/updates/world/master/2017_05_25_00_world.sql | 133 |
1 files changed, 133 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_05_25_00_world.sql b/sql/updates/world/master/2017_05_25_00_world.sql new file mode 100644 index 00000000000..48e15c51588 --- /dev/null +++ b/sql/updates/world/master/2017_05_25_00_world.sql @@ -0,0 +1,133 @@ +-- Fix Startup Errors Part 2 +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=29273; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=29274; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=29256; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=29941; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=18436; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=18435; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=18433; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=18058; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=19893; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=19894; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=19895; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=20318; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=20306; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=20690; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=20706; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=20299; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=20307; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=20304; +UPDATE `creature_template` SET `family`=35 WHERE `entry`=20263; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=21988; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=24857; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=25562; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=25573; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=25574; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=25541; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=25555; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=25578; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=25550; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=25556; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=25579; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=25549; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=25567; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=25552; +UPDATE `creature_template` SET `family`=35 WHERE `entry`=25545; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=25560; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=25557; +UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=25763; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30748; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31673; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31669; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31679; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31656; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31676; +UPDATE `creature_template` SET `family`=53 WHERE `entry`=25388; +UPDATE `creature_template` SET `type`=1 WHERE `entry`=25388; +UPDATE `creature_template` SET `family`=53 WHERE `entry`=25389; +UPDATE `creature_template` SET `type`=1 WHERE `entry`=25389; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31210; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31211; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31212; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31217; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31359; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30810; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30774; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30822; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30823; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30819; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30807; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30459; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30457; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30540; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30510; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30518; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30521; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30529; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30532; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30398; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30397; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30495; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30496; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30508; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30509; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30497; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30498; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30788; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30775; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30522; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30805; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=31559; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30903; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=30905; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31558; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=31560; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=31561; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=32795; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31373; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31386; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30991; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31537; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=31533; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31536; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31612; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31616; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31615; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31617; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=32796; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|1073741824 WHERE `entry`=31734; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31311; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30972; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31611; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31592; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31538; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31591; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31596; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31603; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31610; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31604; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=30973; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31511; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31368; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|4194304 WHERE `entry`=31469; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31465; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31464; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31509; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31508; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31512; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31510; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31598; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30925; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30935; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30936; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30934; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30075; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30087; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31535; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31520; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31534; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31001; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30600; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30999; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=30998; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|2097152 WHERE `entry`=31000; |