diff options
| -rw-r--r-- | sql/updates/world/6.x/2016_04_24_00_world.sql | 43 |
1 files changed, 43 insertions, 0 deletions
diff --git a/sql/updates/world/6.x/2016_04_24_00_world.sql b/sql/updates/world/6.x/2016_04_24_00_world.sql new file mode 100644 index 00000000000..ea698467b7e --- /dev/null +++ b/sql/updates/world/6.x/2016_04_24_00_world.sql @@ -0,0 +1,43 @@ +-- + +UPDATE `creature_template` SET `speed_walk`=0.888888, `speed_run`=1.14286, `unit_flags`=67108928, `unit_flags2`=33554432, `mingold`=12151, `maxgold`=12151, `DamageModifier`=35, `mechanic_immune_mask`=0 WHERE `entry`=39381; +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.14286, `unit_flags`=33554432, `unit_flags2`=2048, `mingold`=0, `maxgold`=0, `DamageModifier`=35, `mechanic_immune_mask`=0 WHERE `entry`=39388; +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=0.912699, `unit_flags`=64, `unit_flags2`=2048, `mingold`=12136, `maxgold`=12136, `DamageModifier`=35, `mechanic_immune_mask`=0 WHERE `entry`=39392; +UPDATE `creature_template` SET `speed_walk`=0.888888, `speed_run`=1.14286, `unit_flags`=67108928, `unit_flags2`=33554432, `mingold`=12188, `maxgold`=12188, `DamageModifier`=48, `mechanic_immune_mask`=0 WHERE `entry`=39405; +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.14286, `unit_flags`=64, `unit_flags2`=33554432, `mingold`=12196, `maxgold`=12196, `DamageModifier`=35, `mechanic_immune_mask`=0 WHERE `entry`=39414; +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.14286, `unit_flags`=64, `unit_flags2`=33554432, `mingold`=12166, `maxgold`=12166, `DamageModifier`=37.7, `mechanic_immune_mask`=0 WHERE `entry`=39415; +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.42857, `unit_flags`=0, `unit_flags2`=2048, `mingold`=6367, `maxgold`=6367, `DamageModifier`=7, `mechanic_immune_mask`=0 WHERE `entry`=39450; +UPDATE `creature_template` SET `speed_walk`=0.888888, `speed_run`=1.42857, `unit_flags`=67141696, `unit_flags2`=2048, `mingold`=20004, `maxgold`=20004, `DamageModifier`=121.2, `mechanic_immune_mask`=617299967 WHERE `entry`=39625; +UPDATE `creature_template` SET `speed_walk`=0.888888, `speed_run`=1.14286, `unit_flags`=67108928, `unit_flags2`=33554432, `mingold`=12148, `maxgold`=12148, `DamageModifier`=35, `mechanic_immune_mask`=0 WHERE `entry`=39626; +UPDATE `creature_template` SET `speed_walk`=0.888888, `speed_run`=1.14286, `unit_flags`=67108944, `unit_flags2`=33554432, `mingold`=12171, `maxgold`=12171, `DamageModifier`=35, `mechanic_immune_mask`=0 WHERE `entry`=39854; +UPDATE `creature_template` SET `speed_walk`=0.888888, `speed_run`=1.14286, `unit_flags`=64, `unit_flags2`=33554432, `mingold`=12832, `maxgold`=12832, `DamageModifier`=48, `mechanic_immune_mask`=0 WHERE `entry`=39855; +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.14286, `unit_flags`=32832, `unit_flags2`=2048, `mingold`=12161, `maxgold`=12161, `DamageModifier`=48, `mechanic_immune_mask`=0 WHERE `entry`=39870; +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.14286, `unit_flags`=32832, `unit_flags2`=2048, `mingold`=12174, `maxgold`=12174, `DamageModifier`=35, `mechanic_immune_mask`=0 WHERE `entry`=39873; +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.14286, `unit_flags`=32832, `unit_flags2`=2048, `mingold`=12181, `maxgold`=12181, `DamageModifier`=48, `mechanic_immune_mask`=0 WHERE `entry`=39890; +UPDATE `creature_template` SET `speed_walk`=0.888888, `speed_run`=1.14286, `unit_flags`=67108928, `unit_flags2`=33554432, `mingold`=12136, `maxgold`=12136, `DamageModifier`=35, `mechanic_immune_mask`=0 WHERE `entry`=39909; +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.14286, `unit_flags`=64, `unit_flags2`=2048, `mingold`=0, `maxgold`=0, `DamageModifier`=48, `mechanic_immune_mask`=0 WHERE `entry`=39954; +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.14286, `unit_flags`=64, `unit_flags2`=33554432, `mingold`=12161, `maxgold`=12161, `DamageModifier`=35, `mechanic_immune_mask`=0 WHERE `entry`=39956; +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.14286, `unit_flags`=32832, `unit_flags2`=2048, `mingold`=12187, `maxgold`=12187, `DamageModifier`=48, `mechanic_immune_mask`=0 WHERE `entry`=39962; +UPDATE `creature_template` SET `speed_walk`=2.8, `speed_run`=1, `unit_flags`=0, `unit_flags2`=2048, `mingold`=0, `maxgold`=0, `DamageModifier`=7, `mechanic_immune_mask`=0 WHERE `entry`=39984; +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.14286, `unit_flags`=262208, `unit_flags2`=2048, `mingold`=12193, `maxgold`=12193, `DamageModifier`=35, `mechanic_immune_mask`=0 WHERE `entry`=40166; +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.14286, `unit_flags`=294976, `unit_flags2`=2048, `mingold`=12157, `maxgold`=12157, `DamageModifier`=48, `mechanic_immune_mask`=0 WHERE `entry`=40167; +UPDATE `creature_template` SET `speed_walk`=2, `speed_run`=1.42857, `unit_flags`=64, `unit_flags2`=67584, `mingold`=19994, `maxgold`=19994, `DamageModifier`=121.2, `mechanic_immune_mask`=617299967 WHERE `entry`=40177; +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.14286, `unit_flags`=64, `unit_flags2`=2048, `mingold`=12214, `maxgold`=12214, `DamageModifier`=37.7, `mechanic_immune_mask`=0 WHERE `entry`=40268; +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.14286, `unit_flags`=32832, `unit_flags2`=2048, `mingold`=12150, `maxgold`=12150, `DamageModifier`=48, `mechanic_immune_mask`=0 WHERE `entry`=40270; +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.14286, `unit_flags`=64, `unit_flags2`=33554432, `mingold`=12179, `maxgold`=12179, `DamageModifier`=35, `mechanic_immune_mask`=0 WHERE `entry`=40272; +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.14286, `unit_flags`=64, `unit_flags2`=33554432, `mingold`=12185, `maxgold`=12185, `DamageModifier`=37.7, `mechanic_immune_mask`=0 WHERE `entry`=40273; +UPDATE `creature_template` SET `speed_walk`=0.888888, `speed_run`=1.14286, `unit_flags`=64, `unit_flags2`=33554432, `mingold`=12139, `maxgold`=12139, `DamageModifier`=48, `mechanic_immune_mask`=0 WHERE `entry`=40290; +UPDATE `creature_template` SET `speed_walk`=0.888888, `speed_run`=1.14286, `unit_flags`=67108928, `unit_flags2`=33554432, `mingold`=12153, `maxgold`=12153, `DamageModifier`=72.1, `mechanic_immune_mask`=0 WHERE `entry`=40291; +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.14286, `unit_flags`=0, `unit_flags2`=2048, `mingold`=12159, `maxgold`=12159, `DamageModifier`=36.2, `mechanic_immune_mask`=0 WHERE `entry`=40293; +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.14286, `unit_flags`=0, `unit_flags2`=2048, `mingold`=12148, `maxgold`=12148, `DamageModifier`=36.2, `mechanic_immune_mask`=0 WHERE `entry`=40294; +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.14286, `unit_flags`=64, `unit_flags2`=2048, `mingold`=12158, `maxgold`=12158, `DamageModifier`=35, `mechanic_immune_mask`=0 WHERE `entry`=40306; +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.14286, `unit_flags`=32832, `unit_flags2`=2048, `mingold`=20026, `maxgold`=20026, `DamageModifier`=102.1, `mechanic_immune_mask`=617299967 WHERE `entry`=40319; +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.42857, `unit_flags`=32832, `unit_flags2`=2048, `mingold`=0, `maxgold`=0, `DamageModifier`=46.6, `mechanic_immune_mask`=617299967 WHERE `entry`=40320; +UPDATE `creature_template` SET `speed_walk`=1.55556, `speed_run`=1, `unit_flags`=0, `unit_flags2`=2048, `mingold`=0, `maxgold`=0, `DamageModifier`=72.4, `mechanic_immune_mask`=0 WHERE `entry`=40357; +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.14286, `unit_flags`=537133120,`unit_flags2`=33554432, `mingold`=12142, `maxgold`=12142, `DamageModifier`=35, `mechanic_immune_mask`=0 WHERE `entry`=40448; +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.28571, `unit_flags`=64, `unit_flags2`=134219776, `mingold`=20003, `maxgold`=20003, `DamageModifier`=121.2, `mechanic_immune_mask`=617299967 WHERE `entry`=40484; +UPDATE `creature_template` SET `speed_walk`=3.6, `speed_run`=1.28571, `unit_flags`=64, `unit_flags2`=2048, `mingold`=0, `maxgold`=0, `DamageModifier`=35, `mechanic_immune_mask`=0 WHERE `entry`=40600; +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.14286, `unit_flags`=64, `unit_flags2`=2048, `mingold`=12188, `maxgold`=12188, `DamageModifier`=35, `mechanic_immune_mask`=0 WHERE `entry`=41073; +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.42857, `unit_flags`=67108928, `unit_flags2`=33556480, `mingold`=0, `maxgold`=0, `DamageModifier`=46.7, `mechanic_immune_mask`=0 WHERE `entry`=41095; +UPDATE `creature_template` SET `speed_walk`=2, `speed_run`=1.42857, `unit_flags`=0, `unit_flags2`=2048, `mingold`=0, `maxgold`=0, `DamageModifier`=7, `mechanic_immune_mask`=0 WHERE `entry`=45467; +UPDATE `creature_template` SET `speed_walk`=3.6, `speed_run`=1.28571, `unit_flags`=64, `unit_flags2`=2048, `mingold`=0, `maxgold`=0, `DamageModifier`=35, `mechanic_immune_mask`=0 WHERE `entry`=48844; |