diff options
| -rw-r--r-- | sql/updates/world/2016_04_11_03_world.sql | 128 |
1 files changed, 128 insertions, 0 deletions
diff --git a/sql/updates/world/2016_04_11_03_world.sql b/sql/updates/world/2016_04_11_03_world.sql new file mode 100644 index 00000000000..8ce24c917f9 --- /dev/null +++ b/sql/updates/world/2016_04_11_03_world.sql @@ -0,0 +1,128 @@ +-- +UPDATE `creature_template` SET `difficulty_entry_1`=48748 WHERE `entry`=39870; +UPDATE `creature_template` SET `difficulty_entry_1`=48595 WHERE `entry`=39890; +UPDATE `creature_template` SET `difficulty_entry_1`=48754 WHERE `entry`=39873; +UPDATE `creature_template` SET `difficulty_entry_1`=48611 WHERE `entry`=41073; +UPDATE `creature_template` SET `difficulty_entry_1`=48597 WHERE `entry`=39962; +UPDATE `creature_template` SET `difficulty_entry_1`=48509 WHERE `entry`=39450; +UPDATE `creature_template` SET `difficulty_entry_1`=48661 WHERE `entry`=39854; +UPDATE `creature_template` SET `difficulty_entry_1`=48669 WHERE `entry`=39954; +UPDATE `creature_template` SET `difficulty_entry_1`=48666 WHERE `entry`=39956; +UPDATE `creature_template` SET `difficulty_entry_1`=48652 WHERE `entry`=39405; +UPDATE `creature_template` SET `difficulty_entry_1`=48667 WHERE `entry`=40448; +UPDATE `creature_template` SET `difficulty_entry_1`=48746 WHERE `entry`=40291; +UPDATE `creature_template` SET `difficulty_entry_1`=48680 WHERE `entry`=39909; +UPDATE `creature_template` SET `difficulty_entry_1`=48654 WHERE `entry`=39381; +UPDATE `creature_template` SET `difficulty_entry_1`=48677 WHERE `entry`=39415; +UPDATE `creature_template` SET `difficulty_entry_1`=48676 WHERE `entry`=39414; +UPDATE `creature_template` SET `difficulty_entry_1`=48750 WHERE `entry`=40270; +UPDATE `creature_template` SET `difficulty_entry_1`=48753 WHERE `entry`=40273; +UPDATE `creature_template` SET `difficulty_entry_1`=48751 WHERE `entry`=40272; +UPDATE `creature_template` SET `difficulty_entry_1`=48610 WHERE `entry`=40306; +UPDATE `creature_template` SET `difficulty_entry_1`=48682 WHERE `entry`=39626; +UPDATE `creature_template` SET `difficulty_entry_1`=48744 WHERE `entry`=40268; +UPDATE `creature_template` SET `difficulty_entry_1`=48653 WHERE `entry`=40290; +UPDATE `creature_template` SET `difficulty_entry_1`=48337 WHERE `entry`=39625; +UPDATE `creature_template` SET `difficulty_entry_1`=48695 WHERE `entry`=40167; +UPDATE `creature_template` SET `difficulty_entry_1`=48693 WHERE `entry`=40166; +UPDATE `creature_template` SET `difficulty_entry_1`=48818 WHERE `entry`=39392; +UPDATE `creature_template` SET `difficulty_entry_1`=48784 WHERE `entry`=40319; +UPDATE `creature_template` SET `difficulty_entry_1`=48801 WHERE `entry`=40320; +UPDATE `creature_template` SET `difficulty_entry_1`=48702 WHERE `entry`=40177; +UPDATE `creature_template` SET `difficulty_entry_1`=48822 WHERE `entry`=40484; +UPDATE `creature_template` SET `difficulty_entry_1`=48350 WHERE `entry`=39984; +UPDATE `creature_template` SET `difficulty_entry_1`=48348 WHERE `entry`=45467; +UPDATE `creature_template` SET `difficulty_entry_1`=48755 WHERE `entry`=41095; +UPDATE `creature_template` SET `difficulty_entry_1`=48828 WHERE `entry`=40600; +UPDATE `creature_template` SET `difficulty_entry_1`=48845 WHERE `entry`=48844; +UPDATE `creature_template` SET `difficulty_entry_1`=48832 WHERE `entry`=39388; +UPDATE `creature_template` SET `difficulty_entry_1`=48745 WHERE `entry`=39855; +UPDATE `creature_template` SET `difficulty_entry_1`=48657 WHERE `entry`=40293; +UPDATE `creature_template` SET `difficulty_entry_1`=48662 WHERE `entry`=40294; +UPDATE `creature_template` SET `difficulty_entry_1`=48785 WHERE `entry`=40357; + +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=1771, `speed_walk`=0.888888, `speed_run`=1.42857, `unit_class`=1, `unit_flags`=67141696, `unit_flags2`=2048, `spell1`=91937, `spell2`=74846, `spell3`=90250, `spell4`=74670, `VehicleId`=0, `mingold`=20004, `maxgold`=20004, `DamageModifier`=125, `mechanic_immune_mask`=617299967, `flags_extra`=1 WHERE `entry`=48337; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=16, `speed_walk`=2, `speed_run`=1.42857, `unit_class`=1, `unit_flags`=0, `unit_flags2`=2048, `spell1`=76507, `spell2`=90212, `spell3`=0, `spell4`=0, `VehicleId`=0, `mingold`=0, `maxgold`=0, `DamageModifier`=7, `mechanic_immune_mask`=8388624, `flags_extra`=0 WHERE `entry`=48348; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=16, `speed_walk`=2.8, `speed_run`=1, `unit_class`=1, `unit_flags`=0, `unit_flags2`=2048, `spell1`=76507, `spell2`=90212, `spell3`=74699, `spell4`=90169, `VehicleId`=0, `mingold`=0, `maxgold`=0, `DamageModifier`=7, `mechanic_immune_mask`=8388624, `flags_extra`=0 WHERE `entry`=48350; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=16, `speed_walk`=1, `speed_run`=1.42857, `unit_class`=1, `unit_flags`=0, `unit_flags2`=2048, `spell1`=76507, `spell2`=90212, `spell3`=0, `spell4`=0, `VehicleId`=0, `mingold`=6367, `maxgold`=6367, `DamageModifier`=7, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48509; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=1771, `speed_walk`=1, `speed_run`=1.14286, `unit_class`=8, `unit_flags`=32832, `unit_flags2`=2048, `spell1`=76603, `spell2`=90487, `spell3`=76596, `spell4`=90486, `VehicleId`=0, `mingold`=12181, `maxgold`=12181, `DamageModifier`=48, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48595; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=1771, `speed_walk`=1, `speed_run`=1.14286, `unit_class`=8, `unit_flags`=32832, `unit_flags2`=2048, `spell1`=74561, `spell2`=76720, `spell3`=90491, `spell4`=90522, `VehicleId`=0, `mingold`=12187, `maxgold`=12187, `DamageModifier`=48, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48597; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=1771, `speed_walk`=1, `speed_run`=1.14286, `unit_class`=1, `unit_flags`=64, `unit_flags2`=2048, `spell1`=76729, `spell2`=90526, `spell3`=76727, `spell4`=0, `VehicleId`=0, `mingold`=12158, `maxgold`=12158, `DamageModifier`=35, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48610; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=1771, `speed_walk`=1, `speed_run`=1.14286, `unit_class`=1, `unit_flags`=64, `unit_flags2`=2048, `spell1`=76729, `spell2`=90526, `spell3`=76727, `spell4`=0, `VehicleId`=0, `mingold`=12188, `maxgold`=12188, `DamageModifier`=35, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48611; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=1771, `speed_walk`=0.888888, `speed_run`=1.14286, `unit_class`=8, `unit_flags`=67108928, `unit_flags2`=33554432, `spell1`=76314, `spell2`=90308, `spell3`=76332, `spell4`=90653, `VehicleId`=0, `mingold`=12188, `maxgold`=12188, `DamageModifier`=48, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48652; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=1771, `speed_walk`=0.888888, `speed_run`=1.14286, `unit_class`=8, `unit_flags`=64, `unit_flags2`=33554432, `spell1`=76314, `spell2`=90308, `spell3`=76332, `spell4`=90653, `VehicleId`=0, `mingold`=12139, `maxgold`=12139, `DamageModifier`=48, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48653; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=1771, `speed_walk`=0.888888, `speed_run`=1.14286, `unit_class`=1, `unit_flags`=67108928, `unit_flags2`=33554432, `spell1`=76404, `spell2`=0, `spell3`=0, `spell4`=0, `VehicleId`=0, `mingold`=12151, `maxgold`=12151, `DamageModifier`=35, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48654; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=1771, `speed_walk`=0.888888, `speed_run`=1.14286, `unit_class`=1, `unit_flags`=67108944, `unit_flags2`=33554432, `spell1`=76378, `spell2`=76394, `spell3`=90659, `spell4`=0, `VehicleId`=0, `mingold`=12171, `maxgold`=12171, `DamageModifier`=35, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48661; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=1771, `speed_walk`=1, `speed_run`=1.14286, `unit_class`=1, `unit_flags`=64, `unit_flags2`=33554432, `spell1`=90665, `spell2`=76411, `spell3`=0, `spell4`=0, `VehicleId`=0, `mingold`=12161, `maxgold`=12161, `DamageModifier`=35, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48666; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=1771, `speed_walk`=1, `speed_run`=1.14286, `unit_class`=1, `unit_flags`=537133120, `unit_flags2`=33554432, `spell1`=90665, `spell2`=76411, `spell3`=0, `spell4`=0, `VehicleId`=0, `mingold`=12142, `maxgold`=12142, `DamageModifier`=35, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48667; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=1771, `speed_walk`=1, `speed_run`=1.14286, `unit_class`=8, `unit_flags`=64, `unit_flags2`=2048, `spell1`=76416, `spell2`=90668, `spell3`=90673, `spell4`=76418, `VehicleId`=0, `mingold`=0, `maxgold`=0, `DamageModifier`=48, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48669; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=16, `speed_walk`=1, `speed_run`=1.14286, `unit_class`=1, `unit_flags`=64, `unit_flags2`=33554432, `spell1`=76557, `spell2`=0, `spell3`=0, `spell4`=0, `VehicleId`=0, `mingold`=12196, `maxgold`=12196, `DamageModifier`=35, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48676; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=16, `speed_walk`=1, `speed_run`=1.14286, `unit_class`=2, `unit_flags`=64, `unit_flags2`=33554432, `spell1`=76514, `spell2`=90692, `spell3`=76517, `spell4`=90693, `VehicleId`=779, `mingold`=12166, `maxgold`=12166, `DamageModifier`=37.7, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48677; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=1771, `speed_walk`=0.888888, `speed_run`=1.14286, `unit_class`=1, `unit_flags`=67108928, `unit_flags2`=33554432, `spell1`=90697, `spell2`=76620, `spell3`=76626, `spell4`=90695, `VehicleId`=0, `mingold`=12136, `maxgold`=12136, `DamageModifier`=35, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48680; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=1771, `speed_walk`=0.888888, `speed_run`=1.14286, `unit_class`=1, `unit_flags`=67108928, `unit_flags2`=33554432, `spell1`=90705, `spell2`=76679, `spell3`=76685, `spell4`=90704, `VehicleId`=0, `mingold`=12148, `maxgold`=12148, `DamageModifier`=35, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48682; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=16, `speed_walk`=1, `speed_run`=1.14286, `unit_class`=1, `unit_flags`=262208, `unit_flags2`=2048, `spell1`=0, `spell2`=0, `spell3`=0, `spell4`=0, `VehicleId`=0, `mingold`=12193, `maxgold`=12193, `DamageModifier`=35, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48693; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=2146, `speed_walk`=1, `speed_run`=1.14286, `unit_class`=8, `unit_flags`=294976, `unit_flags2`=2048, `spell1`=90715, `spell2`=76711, `spell3`=76715, `spell4`=90712, `VehicleId`=0, `mingold`=12157, `maxgold`=12157, `DamageModifier`=48, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48695; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=1771, `speed_walk`=2, `speed_run`=1.42857, `unit_class`=1, `unit_flags`=64, `unit_flags2`=67584, `spell1`=74976, `spell2`=90737, `spell3`=75056, `spell4`=90756, `VehicleId`=733, `mingold`=19994, `maxgold`=19994, `DamageModifier`=125, `mechanic_immune_mask`=617299967, `flags_extra`=1 WHERE `entry`=48702; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=1771, `speed_walk`=1, `speed_run`=1.14286, `unit_class`=2, `unit_flags`=64, `unit_flags2`=2048, `spell1`=76822, `spell2`=76823, `spell3`=76826, `spell4`=90839, `VehicleId`=0, `mingold`=12214, `maxgold`=12214, `DamageModifier`=37.7, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48744; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=1771, `speed_walk`=0.888888, `speed_run`=1.14286, `unit_class`=8, `unit_flags`=64, `unit_flags2`=33554432, `spell1`=76369, `spell2`=90303, `spell3`=90844, `spell4`=76340, `VehicleId`=0, `mingold`=12832, `maxgold`=12832, `DamageModifier`=48, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48745; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=1771, `speed_walk`=0.888888, `speed_run`=1.14286, `unit_class`=8, `unit_flags`=67108928, `unit_flags2`=33554432, `spell1`=76369, `spell2`=90303, `spell3`=90844, `spell4`=76340, `VehicleId`=0, `mingold`=12153, `maxgold`=12153, `DamageModifier`=48, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48746; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=1771, `speed_walk`=1, `speed_run`=1.14286, `unit_class`=8, `unit_flags`=32832, `unit_flags2`=2048, `spell1`=76766, `spell2`=90851, `spell3`=76765, `spell4`=90849, `VehicleId`=0, `mingold`=12161, `maxgold`=12161, `DamageModifier`=48, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48748; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=1771, `speed_walk`=1, `speed_run`=1.14286, `unit_class`=8, `unit_flags`=32832, `unit_flags2`=2048, `spell1`=76578, `spell2`=90856, `spell3`=76579, `spell4`=90858, `VehicleId`=0, `mingold`=12150, `maxgold`=12150, `DamageModifier`=48, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48750; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=16, `speed_walk`=1, `speed_run`=1.14286, `unit_class`=1, `unit_flags`=64, `unit_flags2`=33554432, `spell1`=90867, `spell2`=76792, `spell3`=76779, `spell4`=90866, `VehicleId`=0, `mingold`=12179, `maxgold`=12179, `DamageModifier`=35, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48751; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=16, `speed_walk`=1, `speed_run`=1.14286, `unit_class`=2, `unit_flags`=64, `unit_flags2`=33554432, `spell1`=76797, `spell2`=90870, `spell3`=76794, `spell4`=90868, `VehicleId`=0, `mingold`=12185, `maxgold`=12185, `DamageModifier`=37.7, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48753; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=2146, `speed_walk`=1, `speed_run`=1.14286, `unit_class`=1, `unit_flags`=32832, `unit_flags2`=2048, `spell1`=90872, `spell2`=76816, `spell3`=0, `spell4`=0, `VehicleId`=0, `mingold`=12174, `maxgold`=12174, `DamageModifier`=35, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48754; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=14, `speed_walk`=1, `speed_run`=1.42857, `unit_class`=1, `unit_flags`=67108928, `unit_flags2`=33556480, `spell1`=90875, `spell2`=76817, `spell3`=75931, `spell4`=0, `VehicleId`=0, `mingold`=0, `maxgold`=0, `DamageModifier`=35, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48755; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=2146, `speed_walk`=1, `speed_run`=1.14286, `unit_class`=2, `unit_flags`=32832, `unit_flags2`=2048, `spell1`=90915, `spell2`=75245, `spell3`=76303, `spell4`=0, `VehicleId`=0, `mingold`=20026, `maxgold`=20026, `DamageModifier`=125, `mechanic_immune_mask`=617299967, `flags_extra`=1 WHERE `entry`=48784; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=2146, `speed_walk`=1, `speed_run`=1.42857, `unit_class`=1, `unit_flags`=32832, `unit_flags2`=2048, `spell1`=90950, `spell2`=75328, `spell3`=75321, `spell4`=0, `VehicleId`=737, `mingold`=0, `maxgold`=0, `DamageModifier`=35, `mechanic_immune_mask`=617299967, `flags_extra`=0 WHERE `entry`=48801; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=16, `speed_walk`=1, `speed_run`=0.912699, `unit_class`=1, `unit_flags`=64, `unit_flags2`=2048, `spell1`=91028, `spell2`=75755, `spell3`=75569, `spell4`=79467, `VehicleId`=0, `mingold`=12136, `maxgold`=12136, `DamageModifier`=35, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48818; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=16, `speed_walk`=1, `speed_run`=1.28571, `unit_class`=1, `unit_flags`=64, `unit_flags2`=134219776, `spell1`=79466, `spell2`=91081, `spell3`=75789, `spell4`=91091, `VehicleId`=0, `mingold`=20003, `maxgold`=20003, `DamageModifier`=125, `mechanic_immune_mask`=617299967, `flags_extra`=1 WHERE `entry`=48822; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=16, `speed_walk`=3.6, `speed_run`=1.28571, `unit_class`=1, `unit_flags`=64, `unit_flags2`=2048, `spell1`=75755, `spell2`=91028, `spell3`=91049, `spell4`=75520, `VehicleId`=0, `mingold`=0, `maxgold`=0, `DamageModifier`=35, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48828; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=14, `speed_walk`=1, `speed_run`=1.14286, `unit_class`=1, `unit_flags`=33554432, `unit_flags2`=2048, `spell1`=0, `spell2`=0, `spell3`=0, `spell4`=0, `VehicleId`=0, `mingold`=0, `maxgold`=0, `DamageModifier`=35, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48832; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=16, `speed_walk`=3.6, `speed_run`=1.28571, `unit_class`=1, `unit_flags`=64, `unit_flags2`=2048, `spell1`=91028, `spell2`=91049, `spell3`=91040, `spell4`=0, `VehicleId`=0, `mingold`=0, `maxgold`=0, `DamageModifier`=35, `mechanic_immune_mask`=0, `flags_extra`=0 WHERE `entry`=48845; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=1771, `speed_walk`=1, `speed_run`=1.14286, `unit_class`=1, `unit_flags`=0, `unit_flags2`=2048, `spell1`=76404, `spell2`=0, `spell3`=0, `spell4`=0, `VehicleId`=0, `mingold`=12159, `maxgold`=12159, `DamageModifier`=35, `mechanic_immune_mask`=8388624, `flags_extra`=0 WHERE `entry`=48657; +UPDATE `creature_template` SET `minlevel`=84, `maxlevel`=84, `exp`=3, `faction`=1771, `speed_walk`=1, `speed_run`=1.14286, `unit_class`=1, `unit_flags`=0, `unit_flags2`=2048, `spell1`=76378, `spell2`=76394, `spell3`=90659, `spell4`=0, `VehicleId`=0, `mingold`=12148, `maxgold`=12148, `DamageModifier`=36.2, `mechanic_immune_mask`=8388624, `flags_extra`=0 WHERE `entry`=48662; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=14, `speed_walk`=1.55556, `speed_run`=1, `unit_class`=1, `unit_flags`=0, `unit_flags2`=2048, `spell1`=0, `spell2`=0, `spell3`=0, `spell4`=0, `VehicleId`=0, `mingold`=0, `maxgold`=0, `DamageModifier`=35, `mechanic_immune_mask`=8388624, `flags_extra`=0 WHERE `entry`=48785; + +-- Drake Part +DELETE FROM `creature` WHERE `id` =42571 AND `guid` NOT IN (339783,339784,339782,339781,339780); +UPDATE `creature` SET `position_z`=345.94 WHERE `guid` IN (340008, 340378, 339966, 339890, 340283, 340293); +UPDATE `creature` SET `position_z`=236.371 WHERE `guid` IN (339824); + +DELETE FROM `creature` WHERE `guid` IN (340373,339903,340376,340101,340122,340085,339912,339961,340018,340118,340112,339905,339892,340108,340384,339899,340086,339970,340000,340380,340083,339964,340096,340075,339768,340016,339830,339894,340011,339962,340093,339898,339904,340124,340087,340074,339889,340110,340381,340377,340119,339906,340017,339827,340111,340386,340082,339992,339914,339773,340100,339893,339965,339767,339764,339911,339762,340363,340327,340297,340367,340339,340255,340202,340354,340371,340308,340331,340369,340305,340152,340286,340312,340375,340343,340161,340359,340365,340313,340145,340334,340304,340158,340181,340150,340374,340366,340364,340095,340356,340368,340370,340301,340329,340089,340314,340361,340285,340274,340239,340296,340309,340340,340311,340128,340310,340287,340151,340267,340341,340298,340362,340358,340306,340162,340315,340254,340338,340133); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(340373,40268,670,0, 0, 6, 169, 0, 0, 1, -575.284485, -699.97735, 268.7676, 2.968479, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(339903,39626,670,0, 0, 6, 169, 0, 0, 1, -576.561523, -697.73522, 268.7684, 2.891018, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(340376,39909,670,0, 0, 6, 169, 0, 0, 1, -575.046631, -694.11480, 268.7675, 2.919857, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(340101,40448,670,0, 0, 6, 169, 0, 0, 1, -572.992798, -691.09594, 268.7675, 3.017984, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(340122,39870,670,0, 0, 6, 169, 0, 0, 1, -539.585022, -696.51318, 268.7684, 0.616211, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(340085,40270,670,0, 0, 6, 169, 0, 0, 1, -533.775879, -703.29345, 268.7672, 1.334843, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(339912,40270,670,0, 0, 6, 169, 0, 0, 1, -656.722656, -725.30139, 269.1153, 1.425167, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(339961,39870,670,0, 0, 6, 169, 0, 0, 1, -649.716675, -728.94116, 269.1172, 1.939608, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(340018,40448,670,0, 0, 6, 169, 0, 0, 1, -481.643921, -735.08947, 268.7677, 0.136811, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(340118,39909,670,0, 0, 6, 169, 0, 0, 1, -477.318787, -739.53515, 268.7677, 0.221161, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(340112,40268,670,0, 0, 6, 169, 0, 0, 1, -479.162567, -745.30114, 268.7677, 0.423481, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(339905,42570,670,0, 0, 6, 169, 0, 0, 0, -440.726013, -335.56201, 268.8160, 3.124140, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(339892,42570,670,0, 0, 6, 169, 0, 0, 0, -443.128998, -350.76599, 267.6069, 2.583090, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(340108,42570,670,0, 0, 6, 169, 0, 0, 0, -436.037994, -371.02099, 269.0480, 2.600540, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(340384,42570,670,0, 0, 6, 169, 0, 0, 0, -435.717010, -387.11499, 267.7959, 1.937310, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(339899,42570,670,0, 0, 6, 169, 0, 0, 0, -450.401001, -387.39099, 268.9590, 1.151920, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 0); + +UPDATE `creature` SET `id`=42571 WHERE `guid` IN (339783,339784,339782,339781,339780); +UPDATE `creature` SET `equipment_id`=1 WHERE `map`=670 AND `id` IN (SELECT `CreatureID` FROM `creature_equip_template`); +UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry` IN (40197, 42495); +UPDATE `creature_template` SET `flags_extra`=`flags_extra`|128 WHERE `entry` IN(40566, 44314); +UPDATE `creature_template` SET `unit_flags`=`unit_flags`|131072, `flags_extra`=`flags_extra`|2 WHERE `entry` IN(42570); + +DELETE FROM `creature_template_addon` WHERE `entry` IN (42496, 42495, 39294, 42571); +INSERT INTO `creature_template_addon` (`entry`,`bytes1`,`bytes2`,`auras`) VALUES +(42496,0,1, "39199"), +(42495,0,1, "39199"), +(42571,0,1, "79377"), +(39294,0,1, ""); + +-- Ground Siege Stalker +UPDATE `creature_template` SET `flags_extra`=130 WHERE `entry`=40030; +-- Blitz Stalker +UPDATE `creature_template` SET `flags_extra`=128 WHERE `entry`=40040; +-- Shadow Gale Trigger +UPDATE `creature_template` SET `flags_extra`=130 WHERE `entry`=40567; |