diff options
| -rw-r--r-- | sql/updates/world/2015_07_19_20_world.sql | 152 |
1 files changed, 152 insertions, 0 deletions
diff --git a/sql/updates/world/2015_07_19_20_world.sql b/sql/updates/world/2015_07_19_20_world.sql new file mode 100644 index 00000000000..d132039903f --- /dev/null +++ b/sql/updates/world/2015_07_19_20_world.sql @@ -0,0 +1,152 @@ +-- Stormshield Creature Template Values +UPDATE `creature_template`SET`minlevel`=80, `maxlevel`=80, `faction`=1732, `npcflag`=640, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=33536, `unit_flags2`=2048 WHERE`entry`=32638; +UPDATE `creature_template`SET`minlevel`=80, `maxlevel`=80, `faction`=1732, `npcflag`=7296, `speed_run`=0.992063, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=33536, `unit_flags2`=2048 WHERE`entry`=32639; +UPDATE `creature_template`SET`minlevel`=102, `maxlevel`=102, `faction`=2201, `speed_walk`=1.6, `speed_run`=1.71429, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_class`=2, `unit_flags`=64, `unit_flags2`=1073741824, `HealthModifier`=1, `ManaModifier`=1, `movementId`=0 WHERE`entry`=82201; +UPDATE `creature_template`SET`minlevel`=102, `maxlevel`=102, `faction`=1575, `npcflag`=4224, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags2`=2097152, `HealthModifier`=1 WHERE`entry`=82876; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=123, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=1073743872, `HealthModifier`=1 WHERE`entry`=85445; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=125, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=1073743872, `HealthModifier`=1 WHERE`entry`=85483; +UPDATE `creature_template`SET`minlevel`=90, `maxlevel`=90, `faction`=875, `npcflag`=131, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE`entry`=85849; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=12, `npcflag`=16, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=85905; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2163, `npcflag`=16, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=85910; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=1732, `npcflag`=16, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=85911; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=875, `npcflag`=81, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=85914; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2762, `npcflag`=80, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=85916; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=55, `npcflag`=17, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=85917; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=875, `npcflag`=16, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=85918; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=55, `npcflag`=16, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=85919; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=80, `npcflag`=16, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=34816 WHERE`entry`=85920; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=1732, `npcflag`=16, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=85921; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2762, `npcflag`=17, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=85923; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=12, `npcflag`=80, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=85925; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=12, `npcflag`=81, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=85926; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=12, `npcflag`=80, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=34816 WHERE`entry`=85927; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=80, `npcflag`=80, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=85930; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2781, `npcflag`=129, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=85932; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2700, `npcflag`=128, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=85946; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2762, `npcflag`=128, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=85950; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=12, `npcflag`=128, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=85951; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=80, `npcflag`=2176, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=85955; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=80, `npcflag`=65537, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=85956; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=12, `npcflag`=131072, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=85957; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=875, `npcflag`=8388608, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=85958; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=1732, `npcflag`=268435456, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=85961; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=1732, `npcflag`=536870912, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=85962; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2163, `npcflag`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=85963; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=12, `npcflag`=2097152, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=85964; +UPDATE `creature_template`SET`minlevel`=90, `maxlevel`=90, `faction`=123, `npcflag`=3, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=33280, `unit_flags2`=2048 WHERE`entry`=86065; +UPDATE `creature_template`SET`minlevel`=95, `maxlevel`=95, `faction`=123, `npcflag`=2, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=33280, `unit_flags2`=2048, `HealthModifier`=1 WHERE`entry`=86069; +UPDATE `creature_template`SET`minlevel`=91, `maxlevel`=91, `faction`=2110, `npcflag`=3, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=86084; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=12, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=86087; +UPDATE `creature_template`SET`minlevel`=90, `maxlevel`=90, `faction`=875, `npcflag`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_class`=8, `unit_flags`=33024, `unit_flags2`=2048, `HealthModifier`=1, `ManaModifier`=1 WHERE`entry`=86093; +UPDATE `creature_template`SET`minlevel`=90, `maxlevel`=90, `faction`=124, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_class`=4, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=86110; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2762, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=86129; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=12, `npcflag`=128, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=86136; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=875, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=34816 WHERE`entry`=86141; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=12, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=86142; +UPDATE `creature_template`SET`minlevel`=90, `maxlevel`=90, `faction`=12, `npcflag`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=33280, `unit_flags2`=2048 WHERE`entry`=86148; +UPDATE `creature_template`SET`minlevel`=90, `maxlevel`=90, `faction`=122, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=33280, `unit_flags2`=2048 WHERE`entry`=86154; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=1733, `npcflag`=4225, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=86175; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=1733, `npcflag`=4225, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=86176; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=1075, `npcflag`=4224, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=86178; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2700, `npcflag`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=86182; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2700, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=86184; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=1732, `npcflag`=129, `speed_walk`=0.92, `speed_run`=0.992857, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=86387; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=1732, `speed_walk`=0.92, `speed_run`=0.992857, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=86388; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=1732, `npcflag`=128, `speed_walk`=0.92, `speed_run`=0.992857, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=86389; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=1732, `npcflag`=128, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=86390; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=1732, `npcflag`=128, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=86391; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=123, `npcflag`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048, `HealthModifier`=1 WHERE`entry`=86408; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=11, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048, `HealthModifier`=1 WHERE`entry`=86413; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=12, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=86418; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=80, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=86424; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2762, `npcflag`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=34816 WHERE`entry`=86432; +UPDATE `creature_template`SET`femaleName`='', `minlevel`=100, `maxlevel`=100, `faction`=123, `speed_run`=1.28968, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048, `HealthModifier`=1 WHERE`entry`=86433; +UPDATE `creature_template`SET`femaleName`='', `minlevel`=100, `maxlevel`=100, `faction`=123, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048, `HealthModifier`=1 WHERE`entry`=86436; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=123, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048, `HealthModifier`=1 WHERE`entry`=86438; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=875, `npcflag`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=86440; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2762, `npcflag`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=86441; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=12, `npcflag`=2097152, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=86733; +UPDATE `creature_template`SET`faction`=190, `speed_run`=0.857143, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=526336, `HealthModifier`=1 WHERE`entry`=86749; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=12, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=86762; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=12, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=86763; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=1732, `npcflag`=129, `speed_run`=0.992063, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=87022; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=12, `npcflag`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=87048; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=12, `npcflag`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=34816 WHERE`entry`=87049; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2762, `npcflag`=129, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=87052; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=80, `npcflag`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=87057; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=55, `npcflag`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=87062; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=12, `npcflag`=129, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=87063; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=875, `npcflag`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=87065; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2762, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=87067; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2762, `npcflag`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=87243; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2712, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=87255; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=123, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=87269; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2166, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=87270; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=124, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=87271; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=122, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=87273; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2712, `npcflag`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=87274; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2259, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=87275; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=123, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=87276; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=122, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=87277; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=124, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=87278; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2259, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=87285; +UPDATE `creature_template`SET`minlevel`=102, `maxlevel`=102, `faction`=7, `speed_run`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=131072, `unit_flags2`=2048, `HealthModifier`=1 WHERE`entry`=87318; +UPDATE `creature_template`SET`minlevel`=103, `maxlevel`=103, `faction`=7, `speed_run`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=131072, `unit_flags2`=2048, `HealthModifier`=1 WHERE`entry`=87320; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `speed_run`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=131072, `unit_flags2`=2048, `HealthModifier`=1 WHERE`entry`=87321; +UPDATE `creature_template`SET`minlevel`=102, `maxlevel`=102, `faction`=7, `speed_run`=1, `BaseAttackTime`=1500, `RangeAttackTime`=2000, `unit_flags2`=2048, `HealthModifier`=1 WHERE`entry`=87322; +UPDATE `creature_template`SET`minlevel`=103, `maxlevel`=103, `faction`=7, `speed_run`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags2`=2048, `HealthModifier`=1 WHERE`entry`=87329; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=1575, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048, `HealthModifier`=1 WHERE`entry`=87342; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=1732, `npcflag`=128, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=87365; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2762, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=87375; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=1732, `npcflag`=131, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=87391; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=875, `npcflag`=1, `BaseAttackTime`=1000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=87427; +UPDATE `creature_template`SET`faction`=31, `speed_run`=0.857143, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048, `HealthModifier`=1 WHERE`entry`=87431; +UPDATE `creature_template`SET`faction`=31, `speed_walk`=1.11111, `speed_run`=0.857143, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048, `HealthModifier`=1 WHERE`entry`=87435; +UPDATE `creature_template`SET`faction`=31, `speed_run`=0.857143, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048, `HealthModifier`=1 WHERE`entry`=87436; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=123, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048, `HealthModifier`=1 WHERE`entry`=87657; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=123, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048, `HealthModifier`=1 WHERE`entry`=87663; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=12, `speed_run`=1.38571, `BaseAttackTime`=1000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=87692; +UPDATE `creature_template`SET`minlevel`=40, `maxlevel`=40, `faction`=114, `speed_run`=1.38571, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=33555200, `unit_flags2`=2048 WHERE`entry`=87763; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=190, `speed_walk`=0.8, `speed_run`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048, `family`=0, `HealthModifier`=1 WHERE`entry`=88075; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=190, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048, `family`=0 WHERE`entry`=88076; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=190, `speed_run`=0.992057, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048, `HoverHeight`=1.35, `HealthModifier`=1 WHERE`entry`=88077; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=84, `npcflag`=131, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=88155; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=124, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048, `HealthModifier`=1 WHERE`entry`=88168; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=124, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=88181; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=80, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=88182; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=80, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=88183; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=80, `npcflag`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=88184; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=124, `speed_run`=1.57143, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048, `HealthModifier`=1 WHERE`entry`=88189; +UPDATE `creature_template`SET`modelid3`=0, `minlevel`=100, `maxlevel`=100, `faction`=210, `speed_run`=1.38571, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags2`=2048 WHERE`entry`=88194; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2259, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=88211; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2259, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=88212; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2259, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=88214; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2259, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=88215; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=1732, `npcflag`=4224, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=88230; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=80, `npcflag`=640, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=88235; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=12, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=88236; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=55, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=88237; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=1732, `npcflag`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=88254; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=55, `npcflag`=131072, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=88468; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=55, `npcflag`=131072, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=88469; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=875, `npcflag`=131072, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=88471; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=55, `npcflag`=8388608, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=88472; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2746, `npcflag`=128, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=34816 WHERE`entry`=88482; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2746, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=88484; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2746, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=88485; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=55, `npcflag`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=88501; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=55, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=88502; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=55, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=88503; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=2762, `npcflag`=2097152, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=88520; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=1732, `npcflag`=2097152, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=88522; +UPDATE `creature_template`SET`faction`=188, `speed_run`=0.857143, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags2`=2048, `HealthModifier`=1, `movementId`=0 WHERE`entry`=88975; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=1733, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_class`=8, `unit_flags`=33536, `unit_flags2`=34816, `HealthModifier`=1 WHERE`entry`=90967; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=1078, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_class`=8, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=91273; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=1732, `npcflag`=128, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=91321; +UPDATE `creature_template`SET`minlevel`=90, `maxlevel`=90, `faction`=2110, `npcflag`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags2`=2048 WHERE`entry`=91483; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=1732, `npcflag`=128, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=92501; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=1733, `npcflag`=4225, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=93906; +UPDATE `creature_template`SET`minlevel`=100, `maxlevel`=100, `faction`=1733, `npcflag`=4225, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE`entry`=93907; +UPDATE `creature_template` SET `minlevel`=100, `maxlevel`=100, `faction`=123, `npcflag`=8195 WHERE `entry`=85959; +-- remove wrongly spawned creatures +DELETE FROM `creature` WHERE `guid` IN (371383, 371382, 371271, 371273); |