diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2021_11_05_00_world.sql | 68 |
1 files changed, 68 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_11_05_00_world.sql b/sql/updates/world/3.3.5/2021_11_05_00_world.sql new file mode 100644 index 00000000000..5e06e6d1d62 --- /dev/null +++ b/sql/updates/world/3.3.5/2021_11_05_00_world.sql @@ -0,0 +1,68 @@ +-- +UPDATE `creature_template_addon` SET `bytes1` = 0, `bytes2` = 1, `emote` = 0, `auras` = '29266' WHERE `entry` = 17600; + +UPDATE `creature_template` SET `unit_flags`=33587968 WHERE `entry`=16550; -- Image of Technician Dyvuun +UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=17073; -- Draenei Mourner +UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=16971; -- Injured Draenei +UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=16483; -- Draenei Survivor +UPDATE `creature_template` SET `unit_flags`=256 WHERE `entry`=17453; -- Vision of the Kurken +UPDATE `creature_template` SET `unit_flags`=33024 WHERE `entry`=17452; -- Vision of the Prophesied Hero +UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=17551; -- Tavara +UPDATE `creature_template` SET `maxlevel`=17 WHERE `entry`=17341; -- Axxarien Trickster +UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=17426; -- Galaen +UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=17600; -- Draenei Cartographer +UPDATE `creature_template` SET `unit_flags`=32768 WHERE `entry`=17715; -- Atoph the Bloodcursed +UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=17886; -- [DND]Sunhawk Portal Controller +UPDATE `creature_template` SET `unit_flags`=32832 WHERE `entry`=22060; -- Fenissa the Assassin +UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=17680; -- Webbed Creature +UPDATE `creature_template` SET `minlevel`=64 WHERE `entry`=19000; -- High Elf Ranger +UPDATE `creature_template` SET `minlevel`=63 WHERE `entry`=18454; -- Shalassi Talonguard +UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=18256; -- Alliance Halaani Guard +UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=23501; -- Netherwing Ray +UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry` IN (21419,21786); -- Infernal Attacker +UPDATE `creature_template` SET `BaseAttackTime`=1300 WHERE `entry`=21723; -- Blackwind Sabercat +UPDATE `creature_template` SET `BaseAttackTime`=1300, `unit_flags`=32832 WHERE `entry`=21724; -- Hawkbane +UPDATE `creature_template` SET `minlevel`=70 WHERE `entry`=21763; -- Time-Lost Skettis Worshipper +UPDATE `creature_template` SET `BaseAttackTime`=3000, `unit_flags`=64 WHERE `entry`=10506; -- Kirtonos the Herald +UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=12429; -- Sentinel Shaya +UPDATE `creature_template` SET `faction`=22 WHERE `entry`=1994; -- Githyiss the Vile +UPDATE `creature_template` SET `faction`=22 WHERE `entry`=1986; -- Webwood Spider +UPDATE `creature_template` SET `unit_flags`=33555200 WHERE `entry`=37854; -- Patchwerk Image +UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=27605; -- Colossal Abomination +UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=27691; -- Frenzied Gargoyle +UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry` IN (26793,30528); -- Crystalline Frayer +UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry` IN (26918,30522); -- Chaotic Rift +UPDATE `creature_template` SET `unit_flags`=33555200 WHERE `entry`=26249; -- Southern Sinkhole Kill Credit +UPDATE `creature_template` SET `maxlevel`=34 WHERE `entry`=28596; -- Dwarven Construction Worker +UPDATE `creature_template` SET `maxlevel`=70, `unit_flags`=33024 WHERE `entry`=21776; -- Illidari Temptress +UPDATE `creature_template` SET `unit_flags`=33024 WHERE `entry`=21699; -- Maiev Shadowsong +UPDATE `creature_template` SET `BaseAttackTime`=2000 WHERE `entry`=21700; -- Akama +UPDATE `creature_template` SET `unit_flags`=33554688 WHERE `entry`=23496; -- Akama Event Trigger +UPDATE `creature_template` SET `unit_flags`=33024 WHERE `entry`=21029; -- Captured Water Spirit +UPDATE `creature_template` SET `unit_flags`=32832 WHERE `entry`=21205; -- Ravenous Flayer Matriarch +UPDATE `creature_template` SET `BaseAttackTime`=2000, `unit_flags`=32768 WHERE `entry`=20795; -- Keeper of the Cistern +UPDATE `creature_template` SET `unit_flags`=33555200 WHERE `entry`=21041; -- Earthmender Wilda Trigger +UPDATE `creature_template` SET `unit_flags`=32768 WHERE `entry`=21027; -- Earthmender Wilda +UPDATE `creature_template` SET `unit_flags`=33555200 WHERE `entry`=31047; -- ELM General Purpose Bunny Gigantic +UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=12430; -- Grunt Kor'ja +UPDATE `creature_template` SET `unit_flags`=32832 WHERE `entry`=24240; -- Alyson Antille +UPDATE `creature_template` SET `unit_flags`=32832 WHERE `entry`=24246; -- Darkheart +UPDATE `creature_template` SET `maxlevel`=59, `unit_flags`=512 WHERE `entry`=16996; -- Draenei Vindicator +UPDATE `creature_template` SET `unit_flags`=512 WHERE `entry`=16994; -- Draenei Anchorite +UPDATE `creature_template` SET `unit_flags`=32832 WHERE `entry` IN (17400,18604); -- Felguard Annihilator +UPDATE `creature_template` SET `unit_flags`=32832 WHERE `entry` IN (18894,21645); -- Felguard Brute +UPDATE `creature_template` SET `unit_flags`=32768 WHERE `entry` IN (19016,21646); -- Hellfire Familiar +UPDATE `creature_template` SET `unit_flags`=64 WHERE `entry` IN (17381,18621); -- The Maker +UPDATE `creature_template` SET `unit_flags`=32832 WHERE `entry` IN (17624,18611); -- Laughing Skull Warden +UPDATE `creature_template` SET `unit_flags`=32832 WHERE `entry` IN (17414,18618); -- Shadowmoon Technician +UPDATE `creature_template` SET `maxlevel`=62 WHERE `entry`=17371; -- Shadowmoon Warlock +UPDATE `creature_template` SET `unit_flags`=32832 WHERE `entry` IN (17371,18619); -- Shadowmoon Warlock +UPDATE `creature_template` SET `unit_flags`=32832 WHERE `entry` IN (17626,18609); -- Laughing Skull Legionnaire +UPDATE `creature_template` SET `unit_flags`=32832 WHERE `entry` IN (17395,18617); -- Shadowmoon Summoner +UPDATE `creature_template` SET `unit_flags`=32832 WHERE `entry` IN (17491,18610); -- Laughing Skull Rogue +UPDATE `creature_template` SET `unit_flags`=33554944 WHERE `entry`=20229; -- Void Spawner - Quest - Void Ridge - Galaxis +UPDATE `creature_template` SET `faction`=14, `unit_flags`=33555200 WHERE `entry`=24847; -- Loken +UPDATE `creature_template` SET `unit_flags`=32768 WHERE `entry`=24846; -- Iron Dwarf +UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=22355; -- Netherweb Victim +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=24411; -- Shattered Hand Centurion Image +UPDATE `creature_template` SET `minlevel`=72, `maxlevel`=72 WHERE `entry`=24410; -- Vazruden the Herald Image |