aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2021-08-02 23:36:19 +0300
committeroffl <offl@users.noreply.github.com>2021-08-02 23:36:19 +0300
commitf42b80b739df70f7e17e2da53b474d69e4538e85 (patch)
tree50a8ee613afff8bbca7e991cdc7f65ba6cdd71f7
parentb5b61d99938253293f6910bb8d8f28dc7cc4ed8f (diff)
DB/Creature: Update some fields
-rw-r--r--sql/updates/world/3.3.5/2021_08_02_01_world.sql187
1 files changed, 187 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_08_02_01_world.sql b/sql/updates/world/3.3.5/2021_08_02_01_world.sql
new file mode 100644
index 00000000000..f5c271062d9
--- /dev/null
+++ b/sql/updates/world/3.3.5/2021_08_02_01_world.sql
@@ -0,0 +1,187 @@
+--
+UPDATE `creature_model_info` SET `CombatReach`=1.5 WHERE `DisplayID`=27043;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.413100004196166992, `CombatReach`=2.02500009536743164 WHERE `DisplayID`=30869;
+UPDATE `creature_model_info` SET `CombatReach`=1.5 WHERE `DisplayID`=29488;
+UPDATE `creature_model_info` SET `CombatReach`=1.5 WHERE `DisplayID`=27541;
+UPDATE `creature_model_info` SET `Gender`=2 WHERE `DisplayID`=856;
+
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=35472; -- Huntsman Yahto
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=35501; -- Herald Beluus
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=36101; -- Priestess Alorah
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=35499; -- Huntsman Lokni
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=34885; -- Dame Evniki Kapsalis
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=34882; -- High Crusader Adelard
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=35094; -- Crusader Silverdawn
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=36102; -- Priest Grimmin
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33656; -- Ranii
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33653; -- Rook Hawkfist
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33649; -- Flickin Gearspanner
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=33625; -- Arcanist Taelis
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33222; -- Sir Marcus Barlowe
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33225; -- Marshal Jacob Alerius
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=34881; -- Hiren Loresong
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33309; -- Clara Tumblebrew
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33593; -- Colosos
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33657; -- Irisee
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33223; -- Captain Joseph Holley
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=33970; -- Caris Sunlance
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33655; -- Saandos
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33307; -- Corporal Arthur Flew
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=34912; -- Savinia Loresong
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33652; -- Illestria Bladesinger
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=33646; -- Avareth Swiftstrike
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33654; -- Airae Starseeker
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33650; -- Rillie Spindlenut
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=34880; -- Narasi Snowdawn
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33648; -- Tickin Gearspanner
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=35293; -- Anmarie
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33315; -- Rollo Sureshot
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33592; -- Jaelyne Evensong
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=33647; -- Scout Shalyndria
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33312; -- Lana Stouthammer
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33335; -- Ambrose Boltspark
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33310; -- Derrick Brindlebeard
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=35291; -- Moonbell
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=35290; -- Steen Horngrass
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=34772; -- Vasarin Redmorn
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=35574; -- Magistrix Iruvia
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33553; -- Freka Bloodaxe
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=35476; -- Wilfred Fizzlebang
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=35578; -- Valiant Bressia
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=35576; -- Champion Faesrol
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=36124; -- Harkzog
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=36122; -- Narrhok Steelbreaker
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33541; -- Sarah Chalke
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=36109; -- Baelnor Lightbearer
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=35573; -- Arcanist Asarina
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33547; -- Handler Dretch
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=35579; -- Aspirant Forudir
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=35575; -- Champion Isimode
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33555; -- Eliza Killian
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=35292; -- Froggle
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=36116; -- Melador Valestrider
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=36114; -- Noozle Whizzlestick
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=36069; -- Argent Custodian
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33538; -- Kethiel Sunlance
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=36119; -- Caiphus the Stern
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=35577; -- Valiant Laradia
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=36108; -- Anthar Forgemender
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=34914; -- Tylos Dawnrunner
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=36120; -- Malithus Brightblade
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=35580; -- Aspirant Naradiel
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=36118; -- Shocuul
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33557; -- Trellis Morningsun
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33548; -- Aneera Thuron
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=33971; -- Jarin Dawnglow
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=36121; -- Maz'dinah
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=35475; -- Visiting Warlock
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33545; -- Gahju
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=35483; -- Huntsman Hakan
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33556; -- Doru Thunderhorn
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33544; -- Morah Worgsister
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33549; -- Anka Clawhoof
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33539; -- Dern Ragetotem
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33554; -- Samamba
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=34771; -- Girana the Blooded
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=35470; -- Icehowl
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33542; -- Magister Edien Sunhollow
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=34794; -- Immuyak
+UPDATE `creature_template` SET `speed_run`=1.385714292526245117, `unit_flags2`=0 WHERE `entry`=33698; -- Argent Peacekeeper
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=33540; -- Shadow Hunter Mezil-kree
+UPDATE `creature_template` SET `speed_walk`=1, `HoverHeight`=3.5 WHERE `entry`=31702; -- Frostbrood Spawn
+UPDATE `creature_template` SET `unit_flags`=33280 WHERE `entry`=30203; -- Forgotten Depths High Priest
+UPDATE `creature_template` SET `unit_flags`=33555200 WHERE `entry`=37864; -- Lord Marrowgar Image
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=37998; -- Talan Moonstrike
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=37999; -- Alana Moonstrike
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=37997; -- Yili
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=38182; -- Niby the Almighty
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=38840; -- Jedebia
+UPDATE `creature_template` SET `unit_flags`=33536 WHERE `entry`=38283; -- Malfus Grimfrost
+UPDATE `creature_template` SET `unit_flags`=33600 WHERE `entry`=37200; -- Muradin Bronzebeard
+UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.142857193946838378, `unit_flags`=33554432 WHERE `entry`=31641; -- Icecrown - Pit Fall
+UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.385714292526245117 WHERE `entry`=37968; -- Argent Hippogryph
+UPDATE `creature_template` SET `faction`=2230 WHERE `entry`=38493; -- Argent Crusader
+UPDATE `creature_template` SET `speed_walk`=2.40000009536743164, `speed_run`=1.714285731315612792 WHERE `entry`=31139; -- Pustulent Horror
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=32467; -- Skeletal Reaver
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=31833; -- Kor'kron Squad Leader
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=31832; -- Kor'kron Infantry
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=31891; -- Kor'kron Transport Pilot
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=31882; -- Kor'kron Infiltrator
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=30825; -- Chief Engineer Copperclaw
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=33780; -- Argent Watchman
+UPDATE `creature_template` SET `minlevel`=68 WHERE `entry`=25235; -- Hilda Stoneforge
+UPDATE `creature_template` SET `unit_flags`=33555200 WHERE `entry`=37859; -- Ignis the Furnace Master Image
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=7172; -- Lore Keeper of Norgannon
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=7206; -- Ancient Stone Keeper
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=2748; -- Archaedas
+UPDATE `creature_template` SET `unit_flags`=32768 WHERE `entry`=7397; -- Earthen Stonecarver
+UPDATE `creature_template` SET `faction`=470, `unit_flags`=64 WHERE `entry`=4857; -- Stone Keeper
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=10120; -- Vault Warder
+UPDATE `creature_template` SET `unit_flags`=32768 WHERE `entry`=7396; -- Earthen Stonebreaker
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=4854; -- Grimlok
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=7321; -- Stonevault Flameweaver
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=7320; -- Stonevault Mauler
+UPDATE `creature_template` SET `unit_flags`=32832 WHERE `entry`=4848; -- Shadowforge Darkcaster
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=7291; -- Galgann Firehammer
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=4853; -- Stonevault Geomancer
+UPDATE `creature_template` SET `unit_flags`=32832 WHERE `entry`=4849; -- Shadowforge Archaeologist
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=4855; -- Stonevault Brawler
+UPDATE `creature_template` SET `unit_flags`=32832 WHERE `entry`=7290; -- Shadowforge Sharpshooter
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=4860; -- Stone Steward
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=7023; -- Obsidian Sentinel
+UPDATE `creature_template` SET `unit_flags`=32832 WHERE `entry`=7030; -- Shadowforge Geologist
+UPDATE `creature_template` SET `unit_flags`=32768 WHERE `entry`=7012; -- Earthen Sculptor
+UPDATE `creature_template` SET `unit_flags`=32768 WHERE `entry`=7011; -- Earthen Rocksmasher
+UPDATE `creature_template` SET `unit_flags`=32832 WHERE `entry`=4847; -- Shadowforge Relic Hunter
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=7228; -- Ironaya
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=4861; -- Shrike Bat
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=7022; -- Venomlash Scorpid
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=4863; -- Jadespine Basilisk
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=4850; -- Stonevault Cave Lurker
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=6910; -- Revelosh
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=6908; -- Olaf
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=6907; -- Eric "The Swift"
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=6906; -- Baelog
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=24830; -- Stonevault Pillager
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=4852; -- Stonevault Oracle
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=7354; -- Ragglesnout
+UPDATE `creature_template` SET `unit_flags`=512 WHERE `entry`=35073; -- Farseer Eannu
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=7937; -- High Tinker Mekkatorque
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=12858; -- Torek
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=12859; -- Splintertree Raider
+UPDATE `creature_template` SET `faction`=151 WHERE `entry`=4923; -- Guard Jarad
+UPDATE `creature_template` SET `unit_flags`=512 WHERE `entry`=33934; -- Ecton Brasstumbler
+UPDATE `creature_template` SET `unit_flags`=512 WHERE `entry`=33939; -- Argex Irongut
+UPDATE `creature_template` SET `unit_flags`=512 WHERE `entry`=33935; -- Evee Copperspring
+UPDATE `creature_template` SET `unit_flags`=512 WHERE `entry`=34093; -- Blazzek the Biter
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=34988; -- Landuen Moonclaw
+UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry`=34989; -- Rissa Shadeleaf
+UPDATE `creature_template` SET `BaseAttackTime`=3000 WHERE `entry`=17185; -- Bristlelimb Ursa
+UPDATE `creature_template` SET `unit_flags`=32768 WHERE `entry`=17587; -- Draenei Youngling
+UPDATE `creature_template` SET `modelid2`=2001, `modelid3`=6802, `modelid4`=8589 WHERE `entry`=17432; -- Stillpine Defender
+UPDATE `creature_template` SET `modelid2`=2001, `modelid3`=6802, `modelid4`=8589 WHERE `entry`=17437; -- Stillpine Defender Corpse
+UPDATE `creature_template` SET `modelid2`=2001, `modelid3`=6802, `modelid4`=8589 WHERE `entry`=17439; -- Stillpine Hunter
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=945; -- Rybrad Coldbank
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=1104; -- Grundel Harkin
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=8416; -- Felix Whindlebolt
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=926; -- Bromos Grummner
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=916; -- Solm Hargrin
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=895; -- Thorgas Grimson
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=912; -- Thran Khorman
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=6782; -- Hands Springsprocket
+UPDATE `creature_template` SET `unit_flags`=512 WHERE `entry`=1965; -- Mountaineer Thalos
+UPDATE `creature_template` SET `unit_flags`=512 WHERE `entry`=1243; -- Hegnar Rumbleshot
+UPDATE `creature_template` SET `unit_flags`=512 WHERE `entry`=10805; -- Spotter Klemmy
+UPDATE `creature_template` SET `unit_flags`=512 WHERE `entry`=10611; -- Shorty
+UPDATE `creature_template` SET `unit_flags`=512 WHERE `entry`=10804; -- Rifleman Middlecamp
+UPDATE `creature_template` SET `unit_flags`=512 WHERE `entry`=10610; -- Angus
+UPDATE `creature_template` SET `unit_flags`=512 WHERE `entry`=10803; -- Rifleman Wheeler
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=12427; -- Mountaineer Dolf
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=6119; -- Tog Rustsprocket
+UPDATE `creature_template` SET `unit_flags`=512 WHERE `entry`=1268; -- Ozzie Togglevolt
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=24108; -- Self-Turning and Oscillating Utility Target
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=24109; -- Brewfest Target Dummy Move To Target
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=23706; -- Gordok Festive Keg
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=23702; -- Thunderbrew Festive Keg
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=23700; -- Barleybrew Festive Keg
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=23808; -- Brewfest Keg Move to Target