aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2016-04-24 17:52:25 +0200
committerKillyana <morphone1@gmail.com>2016-04-24 17:52:25 +0200
commit2db839f6761d867d8066c77452292e08a9d30e78 (patch)
tree00f561d7445e2ed2c89b65a8f2d1dcd6ebca231d /sql
parent948146f3ee890b85af50944176877c7d44c0c120 (diff)
DB/Creature: Update creature templates for gimm batol normal mode
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/6.x/2016_04_24_00_world.sql43
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;